MyBatisPlus统计数据
<lect id="supplysDetail" resultType="com.dcz.labor.vo.SupplysDetailsVO">
SELECT厨具品牌
T1.`name`,蒜蓉排骨
T1.phone,
漫漫红糖水
T1.is_delete,
COUNT( T2.ur_id ) AS total_emps,
水晶饺子皮的做法SUM(IF ( T2.staff_statu = 1 AND T3.job_type = 0, 1, 0 )) AS full_job_inemps,
SUM(IF ( T2.staff_statu = 0 AND T3.job_type = 0,1,0)) AS full_job_leaveemps,
SUM(IF ( T2.staff_statu = 1 AND T3.job_type = 3, 1, 0 )) AS temp_job_inemps,
SUM(IF ( T2.staff_statu = 0 AND T3.job_type = 3,1,0)) AS temp_job_leaveemps,
CASE
WHEN T2.id IS NOT NULL THEN '在职员⼯'
封闭式管理WHEN T2.id IS NULL THEN '委外供应商'毛蛤
END supply_type
FROM
company_supply T1
LEFT JOIN company_roster T2 ON T2.source_id = T1.id
LEFT JOIN job T3 ON T3.id = T2.job_id
${ew.customSqlSegment}
西服搭配</lect>
以物喻人@Mapper
public interface CompanySupplyMapper extends BaMapper<CompanySupplyEntity> {
Page<SupplysDetailsVO> supplysDetail(Page<SupplysDetailsVO> page, @Param(Constants.WRAPPER) Wrapper wrapper); }
