| 12345678910111213141516 |
- select DISTINCT pdu.userNum as username,c.daikou_debit as daikouDebit,c.*,u.realname,d.departname as belongUnitName, du.duties_name as duname,pdu.idcard as pduname,fin.belong_bank,fin.card_number as cardNumber
-
- from t_bus_user_wage c left join t_s_base_user u on c.userid = u.id
-
- left join t_bus_user_personnel per on per.userid = u.id
-
- left join t_s_depart d on d.id = c.pjt_id
-
- left join t_bus_duties du on du.id = per.belong_dutiesid
-
- left join t_s_user pdu on pdu.id = u.id
-
- left join t_bus_user_financial fin on fin.userid = u.id and isdefault = '1' and fin.delete_flag='0'
- where 1=1 and u.delete_flag='0'
- and u.id=:userId
- and c.monthly between :startMonth and :endMonth
|
