<#-- 月度排班,班次选择页面不分页 -->
select 
ad.id,
ad.duty_name AS dutyName,
ad.pid AS pid,
ad.duty_type AS dutyType,
ad.normalwork_stime AS normalworkStime,
ad.normalwork_etime AS normalworkEtime,
ad.spunch_minute AS spunchMinute,
ad.epunch_minute AS epunchMinute,
ad.datum_workhours AS datumWorkhours,
ad.shift_workhours AS shiftWorkhours,
ad.onduty_stime AS ondutyStime,
ad.onduty_etime AS ondutyEtime,
ad.onduty_workhours AS ondutyWorkhours,
ad.timeout_overtime_stime AS timeOutOvertimeStime,
ad.timeout_overtime_etime AS timeOutOvertimeEtime,
ad.timeout_overtime_hours AS timeOutOvertimeHours,
ad.duty_mealid AS dutyMealid,
ad.remark AS remark,
ad.create_name AS createName,
ad.create_by AS createBy,
ad.create_date AS createDate,
ad.update_name AS updateName,
ad.update_by AS updateBy,
ad.update_date AS updateDate,
ad.sys_org_code AS sysOrgCode,
ad.sys_company_code AS sysCompanyCode,
ad.status AS status,
ad.delete_flag AS deleteFlag
 from t_bus_arrange_duty ad where 1 = 1
AND ad.duty_type IN (
	'changban8h',
	'riban11h',
	'yeban11.5',
	'zhiban'
)
	<#if (arrangeDutyDto.pid )?? && arrangeDutyDto.pid ?length gt 0>
		and ad.pid like CONCAT('%', :arrangeDutyDto.pid ,'%') 
	</#if>
	<#if (arrangeDutyDto.dutyName )?? && arrangeDutyDto.dutyName ?length gt 0>
		and ad.DUTY_NAME like CONCAT('%', :arrangeDutyDto.dutyName ,'%') 
	</#if>
	<#if (arrangeDutyDto.dutyType )?? && arrangeDutyDto.dutyType ?length gt 0>
		and ad.DUTY_TYPE like CONCAT('%', :arrangeDutyDto.dutyType ,'%') 
	</#if>
AND ad.delete_flag = 0
AND ad.status = 0
ORDER BY
	ad.create_date DESC