Wrapper 的where条件在xml使用

mapper.xml 
select * from ( SELECT a.*, b.`id` AS audit_id, IFNULL(b.`status`,0) AS audit_status, b.`reason` AS audit_reason, b.`create_time` AS audit_create_time, b.`create_by` AS audit_create_by, b.`audit_time`, b.`audit_by`, b.`dept_id`, b.`company_id`, IFNULL(d.short_name, d.dept_name) AS company_name FROM `xxx` a LEFT OUTER JOIN `xxx` b ON a.`id` = b.`tbl_key` and b.`tbl_name` = 'hse_prevent_hazard_affirm' LEFT OUTER JOIN `xxx` d ON d.dept_id = b.`company_id` ) t ${ew.customSqlSegment}

mapper.java

IPage<HsePreventHazardAffirm> getList(IPage<HsePreventHazardAffirm> page
        , @Param(Constants.WRAPPER) Wrapper<HsePreventHazardAffirm> wrapper);
 
 
posted @ 2022-02-16 15:46  ±小马哥  阅读(401)  评论(0编辑  收藏  举报