@Select("<script>"
        + "select a.id, a.emp_name, a.emp_no,b.depart_name sys_org_code,c.post_name,c.post_name as post_mutex " +
        "        from ls_emp_info a left join sys_depart b on a.org_code = b.org_code " +
        "        left join ls_emp_post c on a.emp_no = c.emp_no " +
        "        <where>" +
        "            <if test=\"empInfo.empName != null and empInfo.empName != ''\"> " +
        "                a.emp_name like CONCAT('%',#{empInfo.empName},'%'), " +
        "            </if>" +
        "        </where>"
        + "</script>")
IPage<EmpInfo> getPage(Page<EmpInfo> page, QueryWrapper<EmpInfo> queryWrapper, @Param("empInfo") EmpInfo empInfo);

@Select({"<script>"
	+"select * from func_report_waste_crktj(#{startDate},#{endDate}) "
	+" where 1=1  "
	+"<when test= 'khbm!=null'> and khbm=#{khbm} </when>"
	+"<when test= 'lbbm!=null'> and lbbm=#{lbbm} </when>"
	+"<when test= 'djbm!=null'> and djbm=#{djbm} </when>"
	+"</script>"})
List<Map<String,Object>>  getWasteCrktjxxList(Map<String,Object> params);