SELECT
      c.pjt_id
      ,SUM(basic_wage) basic_wage,SUM(duties_allowance) duties_allowance,SUM(certificate_subsidy) certificate_subsidy,
			SUM(traffic_subsidy) traffic_subsidy,SUM(megathermal_subsidy) megathermal_subsidy,SUM(only_child_cost) only_child_cost,SUM(other_subsidy) other_subsidy
			,SUM(bonus) bonus,SUM(project_performance) project_performance,SUM(meals_subsidy_day) meals_subsidy_day,SUM(meals_subsidy_night) meals_subsidy_night,
			SUM(meals_subsidy) meals_subsidy,SUM(overtimepay_timeout) overtimepay_timeout,SUM(overtimepay_fixed) overtimepay_fixed,
			SUM(duty) duty,SUM(special_overtime) special_overtime,SUM(sick_leave_debit) sick_leave_debit,SUM(thing_leave_debit) thing_leave_debit,
			SUM(absence_debit) absence_debit,SUM(payment_subsidy) payment_subsidy,
			SUM(social_security_debit) social_security_debit,SUM(provident_fund_debit) provident_fund_debit,SUM(com_social_security_debit) com_social_security_debit,
			SUM(com_provident_fund_debit) com_provident_fund_debit,SUM(pre_tax_mone) pre_tax_mone,SUM(comcost) comCost,
			SUM(daikou_debit) daikouDebit,SUM(other_debit) other_debit,sum(reissue) reissue,SUM(tax_money) tax_money,SUM(actual_money) actual_money
			FROM t_bus_user_wage c
			left join t_s_base_user u on c.userid = u.id
where  u.delete_flag='0' and c.status='2'
		<#if ( userWageDto.monthly )?? && userWageDto.monthly ?length gt 0>
			and c.monthly = :userWageDto.monthly
		</#if>
group by c.pjt_id