| | |
|---|
| | | |
|---|
| | | <!-- 查询费用月统计信息 add by wuxw 2018-07-03 --> |
|---|
| | | <select id="queryReportFeeSummary" parameterType="Map" resultType="Map"> |
|---|
| | | select t.fee_year feeYear,t.fee_month feeMonth,t.create_time createTime,SUM(t.receivable_amount) |
|---|
| | | receivableAmount,SUM(t.received_amount) |
|---|
| | | receivedAmount,SUM(t.owe_amount) oweAmount,max(t.update_time) updateTime |
|---|
| | | select t.fee_year feeYear,t.fee_month feeMonth,t.create_time createTime,SUM(t.his_owe_amount) hisOweAmount,SUM(t.cur_receivable_amount) curReceivableAmount, |
|---|
| | | SUM(t.cur_received_amount) curReceivedAmount,SUM(t.his_owe_received_amount) hisOweReceivedAmount,SUM(t.pre_received_amount) preReceivedAmount, |
|---|
| | | max(t.update_time) updateTime |
|---|
| | | from report_fee_month_statistics t |
|---|
| | | left join building_room br on t.obj_id = br.room_id and t.obj_type = '3333' and br.status_cd = '0' |
|---|
| | | left join building_unit bu on br.unit_id = bu.unit_id and bu.status_cd = '0' |
|---|
