<#-- 获取工资策略表数据 (分页)-->
SELECT
	bw.id,
	bw.dutiesid,
	bd.parent_dutiesid AS parentDutiesId,
	bw.basic_wage AS basicWage,
	bw.subsidy,
	bw.leveltwosubsidy,
	bw.levelonesubsidy,
	bw.levelthreesubsidy,
	bw.trafficsubsidy,
	bw.zone,
	bw.project,
	bw.STATUS,
	bw.delete_flag AS deleteFlag,
	pst.id as postId,
	pst.post_name as postName,
	pst.money as postMoney
FROM
	t_bus_wagestrategy bw
LEFT JOIN t_bus_duties bd ON bw.dutiesid = bd.ID
left join t_bus_post pst on pst.id = bd.post
left join t_bus_base_wagestrategy basewage on basewage.zone is null 
WHERE
	1 = 1
AND bw.delete_flag = '0'
AND bd. STATUS = '0'
AND bd.delete_flag = '0' 
<#if dutiesId ?exists && dutiesId ?length gt 0>
	 AND bw.dutiesid = :dutiesId
</#if>


