meidu2021/daju/target/classes/cn/com/lzt/projarrangedetail/sql/ProjArrangeDetailAndUserMiniDao_getArrangeDutyOperate4CopyLastMonth.sql

<#-- 根据月份、项目id查询排班做五休二oprate数据-->
SELECT
	yearmonth,
	shiftid,
	userid,
	runway,
	deploy_people_num as deployPeopleNum,
	attendance_cycle as attendanceCycle,
	sys_org_code as sysOrgCode,
	sys_company_code as sysCompanyCode,
	pjt_postid as pjtPostId,
	pid 
FROM
	t_bus_arrangeduty_operate
WHERE
	runway in ('f2t_wujiabanfei','f2t_jijiabanfei')
	and pid = :pid
	and yearmonth = :yearmonth