联讯物业系统后台
parent: c2e69ffe | 补丁 | 提交 | ignore whitespace
java110
2023-05-22 b5351598c8f1d54cdb445b5975e148aa3fece2a1 
optimize owner received owe fee
1个文件已修改
2 ■■■■■ 已修改文件
java110-db/src/main/resources/mapper/report/ReportFeeStatisticsServiceDaoImplMapper.xml 2 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 
 java110-db/src/main/resources/mapper/report/ReportFeeStatisticsServiceDaoImplMapper.xml


@@ -718,7 +718,7 @@


    <!-- 查询业主费用明细表 -->


    <select id="getOwnerFeeSummary" parameterType="Map" resultType="Map">


        select


        a.owner_id,GROUP_CONCAT(a.obj_name) objName,pfc.fee_type_cd,


        a.owner_id ownerId,GROUP_CONCAT(a.obj_name) objName,pfc.fee_type_cd feeTypeCd,


        (


        select ifnull(sum(t.receivable_amount),0.0) hisOweFee


        from pay_fee_detail_month t