优化代码

wuxw

2024-02-23 7c03d86f6c06cbd6fbfb02edd5f7aa70dab0a2fe

优化代码

 java110-db/src/main/resources/mapper/report/ReportFeeStatisticsServiceDaoImplMapper.xml

@@ -793,7 +793,7 @@
    <!-- 查询业主费用明细表 -->
    <select id="getOwnerFeeSummary" parameterType="Map" resultType="Map">
        select
        a.owner_id ownerId,GROUP_CONCAT(a.obj_name) objName,pfc.fee_type_cd feeTypeCd,
        a.owner_id ownerId,GROUP_CONCAT(a.obj_name) objName,a.fee_type_cd feeTypeCd,
        (
        select ifnull(sum(t.receivable_amount),0.0) hisOweFee
        from pay_fee_detail_month t
@@ -816,12 +816,11 @@
        and t.pay_fee_time &lt; #{endDate}
        ) receivedFee
        from pay_fee_detail_month a
        inner join pay_fee_config pfc on a.config_id = pfc.config_id and pfc.status_cd = '0'
        where a.owner_id in
        <foreach collection="ownerIds" item="item" index="index" open="(" close=")" separator=",">
            #{item}
        </foreach>
        group by a.owner_id,pfc.fee_type_cd,a.community_id
        group by a.owner_id,a.fee_type_cd,a.community_id
    </select>



 service-report/src/main/java/com/java110/report/cmd/reportFeeMonthStatistics/QueryReportFloorFeeSummaryCmd.java

@@ -219,7 +219,7 @@
            data.put("curReceivedFee","0");
            for(ReportFloorFeeStatisticsDto reportFloorFeeStatisticsDto:curReceivedFees){
                if(reportFloorFeeStatisticsDto.getFloorId().equals(data.get("floorId"))){
                    data.put("curReceivedFee",reportFloorFeeStatisticsDto.getReceivedFee());
                    data.put("curReceivedFee",reportFloorFeeStatisticsDto.getCurReceivedFee());
                }
            }
        }