| | |
| | | left join pay_fee_attrs pfa1 on t.fee_id = pfa1.fee_id and pfa1.status_cd = '0' and pfa1.spec_cd = '390008' |
| | | left join pay_fee_attrs pfa2 on t.fee_id = pfa2.fee_id and pfa2.status_cd = '0' and pfa2.spec_cd = '390009' |
| | | where t.config_id = #{configId} |
| | | <if test="payerObjType != null and payerObjType != ''"> |
| | | and t.payer_obj_type= #{payerObjType} |
| | | </if> |
| | | and t.community_id= #{communityId} |
| | | </select> |
| | | |
| | |
| | | left join pay_fee_attrs pfa2 on t.fee_id = pfa2.fee_id and pfa2.status_cd = '0' and pfa2.spec_cd = '390009' |
| | | where t.config_id = #{configId} |
| | | and t.community_id= #{communityId} |
| | | <if test="payerObjType != null and payerObjType != ''"> |
| | | and t.payer_obj_type= #{payerObjType} |
| | | </if> |
| | | order by t.create_time desc |
| | | <if test="page != -1 and page != null "> |
| | | limit #{page}, #{row} |