meidu2021/daju/target/classes/cn/com/lzt/wagestrategy/sql/WagestrategyMiniDao_getZoneWagestrategyDtoPage.sql

<#-- 获取工资策略表数据 (分页)-->
SELECT
	bw.id,
	bw.dutiesid,
	bd.parent_dutiesid AS parentDutiesId,
	bw.basic_wage AS basicWage,
	bw.subsidy,
	bw.trafficsubsidy,
	bw.leveltwosubsidy,
	bw.levelonesubsidy,
	bw.levelthreesubsidy,
	bw.zone,
	bw.project,
	bw. STATUS,
	bw.create_name AS createName,
	bw.create_by AS createBy,
	bw.create_date AS createDate,
	bw.update_name AS updateName,
	bw.update_by AS updateBy,
	bw.update_date AS updateDate,
	bw.sys_org_code AS sysOrgCode,
	bw.sys_company_code AS sysCompanyCode,
	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
WHERE
	1 = 1
AND bw.delete_flag = '0'
AND bd. STATUS = '0'
AND bd.delete_flag = '0'
and bw.zone is not null
<#if sortorder ?exists && sortorder ?length gt 0>
	 order by ${sortorder}
</#if>