优化费用明细表

wuxw

2025-01-04 a2d2caf2ffc1d79694d813b6cf5225a4c1c67e41

优化费用明细表

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

@@ -386,7 +386,7 @@
        left join building_unit bu on t.unit_id = bu.unit_id and bu.status_cd = '0'
        inner join pay_fee pf on pf.payer_obj_id = t.room_id and pf.payer_obj_type = '3333' and pf.status_cd = '0' and pf.state = '2008001'
        <if test="feeTypeCd != null and feeTypeCd != ''">
            left join pay_fee_config pfc on t.config_id = pfc.config_id and pfc.status_cd = '0'
            left join pay_fee_config pfc on pf.config_id = pfc.config_id and pfc.status_cd = '0'
        </if>
        where
        1=1

 springboot/src/main/resources/application-debug.yml

@@ -29,7 +29,7 @@
  activiti:
    database-schema-update: false
  datasource:
    url: jdbc:mysql://118.182.119.121:3306/TT?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&useSSL=false
    url: jdbc:mysql://192.168.100.108:3306/TT?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&useSSL=false
    username: TT
    password: hc12345678
    type: com.alibaba.druid.pool.DruidDataSource