optimize

java110

2023-05-25 6ed9905c27af169aeb8a0aef5c3f7e331a325c06

optimize

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

@@ -835,7 +835,7 @@

    <!-- 查询账户扣款-->
    <select id="getWithholdAccount" parameterType="Map" resultType="Map">
        select ifnull(SUM(t.amount),0.0) lateFee
        select ifnull(SUM(t.amount),0.0) withholdAccount
        from account_detail t
        INNER JOIN account ac on t.acct_id = ac.acct_id and ac.status_cd = '0'
        where 1=1