meidu2021/daju/target/classes/cn/com/lzt/wageStats/sql/WageStatsMinidaoDao_userWageStatsData.sql

  SELECT uat.monthly yearmonth,uat.pid pjtId,uat.departid deptId,uat.pmId,uat.userid userId,convert(uat.pre_tax_mone,decimal(10,2)) wagePayTotal
		FROM(
			SELECT uw.userid,uw.monthly,uw.pre_tax_mone,IFNULL(uw.com_provident_fund_debit,0) compro ,IFNULL(uw.com_social_security_debit,0)  comsoc ,uw.pjt_id pid,uw.belong_unitid departId,uat.id,d.dept_proj_managerid pmId
			from t_bus_user_wage uw
			LEFT JOIN t_s_depart d
			ON uw.pjt_id = d.ID 
			LEFT JOIN t_bus_user_attendance_total uat
			ON uw.userid = uat.user_id and uat.yearmonth =:params.yearmonth
			WHERE uw.monthly =:params.yearmonth and (d.org_type = 3 or d.org_type = 5)
		) uat
	 WHERE uat.monthly  =:params.yearmonth  AND uat.pid != '' order by wagePayTotal desc