| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950 |
- <#-- 月度排班,班次选择页面不分页 -->
- 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
|
