| 123456789101112131415161718 |
- 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
|
