Merge branch 'master' of http://git.homecommunity.cn/supervip/MicroCommunity
| | |
|---|
| | | <select id="queryFeeBreakdown" parameterType="Map" resultType="Map"> |
|---|
| | | select t.fee_name feeName,td.name feeTypeCd,pfc.fee_type_cd,pfc.start_time feeStartTime,pfc.end_time |
|---|
| | | feeEndTime,SUM(t.receivable_amount) |
|---|
| | | receivableAmount,SUM(t.received_amount) receivedAmount,SUM(t.owe_amount) oweAmount |
|---|
| | | receivableAmount,SUM(t.received_amount) receivedAmount,SUM(t.owe_amount) oweAmount,max(t.update_time) updateTime |
|---|
| | | from report_fee_month_statistics t |
|---|
| | | inner join pay_fee_config pfc on t.config_id = pfc.config_id and pfc.status_cd = '0' |
|---|
| | | left join building_room br on t.obj_id = br.room_id and t.obj_type = '3333' and br.status_cd = '0' |
|---|
