meidu2021/daju/target/classes/cn/com/lzt/arrangeduty/sql/MealsSubsidyMiniDao_getMealsSubsidySelect.sql

<#--班次餐补选择-->

SELECT 
tbms.id,
tbms.subsidy_type as subsidyType,
tbms.shift_subsidy_type as shiftSubsidyType,
tbms.subsidy_name as subsidyName,
tbms.subsidy_money as subsidyMoney,
tbms.calcu_unit as calcuUnit,
tbms.iffixed

 from t_bus_meals_subsidy tbms where 1=1

<#if ( mealsSubsidyDto.subsidyTypeList )?? && mealsSubsidyDto.subsidyTypeList ?size gt 0>
	and tbms.subsidy_type in(
	<#list mealsSubsidyDto.subsidyTypeList as item>        
	   '${item}'
	 <#if item_has_next>,</#if>
	 </#list>
	)
<#else >
	and id=null
</#if>
<#if authSql ?exists && authSql ?length gt 0>
	${authSql}
</#if>
and status='0'
and delete_flag='0'
order by subsidyName