| 123456789101112131415161718192021222324252627282930313233 |
- <#-- 获取工资策略表数据 (分页)-->
- 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>
|
