java110-bean/src/main/java/com/java110/dto/reportFeeMonthStatistics/ReportFeeMonthStatisticsDto.java
@@ -79,6 +79,9 @@ //实收总金额(大计) private String allReceivedAmount; //实收总金额(大计) private String allOweAmount; private List<FeeConfigDto> FeeConfigDtos; //费用类型 @@ -572,4 +575,12 @@ public void setStateName(String stateName) { this.stateName = stateName; } public String getAllOweAmount() { return allOweAmount; } public void setAllOweAmount(String allOweAmount) { this.allOweAmount = allOweAmount; } } java110-db/src/main/resources/mapper/report/ReportFeeMonthStatisticsServiceDaoImplMapper.xml
@@ -329,6 +329,58 @@ </if> </select> <!-- 查询费用月统计信息 大计 add by wuxw 2018-07-03 --> <select id="queryReportFeeSummaryMajor" parameterType="Map" resultType="Map"> select SUM(t.receivable_amount) allReceivableAmount,SUM(t.received_amount) allReceivedAmount,SUM(t.owe_amount) allOweAmount 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' left join f_floor f on bu.floor_id = f.floor_id and f.status_cd = '0' inner join pay_fee pf on t.fee_id = pf.fee_id and pf.community_id = t.community_id and pf.status_cd = '0' where t.status_cd = '0' <if test="roomNum !=null and roomNum != ''"> and br.room_num= #{roomNum} </if> <if test="unitId !=null and unitId != ''"> and bu.unit_id= #{unitId} </if> <if test="floorId !=null and floorId != ''"> and f.floor_id = #{floorId} </if> <if test="objName !=null and objName != ''"> and t.obj_name= #{objName} </if> <if test="feeYear !=null and feeYear != ''"> and t.fee_year= #{feeYear} </if> <if test="feeMonth !=null and feeMonth != ''"> and t.fee_month= #{feeMonth} </if> <if test="feeId !=null and feeId != ''"> and t.fee_id= #{feeId} </if> <if test="configId !=null and configId != ''"> and t.config_id= #{configId} </if> <if test="objId !=null and objId != ''"> and t.obj_id= #{objId} </if> <if test="feeName !=null and feeName != ''"> and t.fee_name= #{feeName} </if> <if test="communityId !=null and communityId != ''"> and t.community_id= #{communityId} </if> <if test="startTime !=null"> and t.create_time >= #{startTime} </if> <if test="endTime !=null"> and t.create_time <= #{endTime} </if> </select> <select id="queryReportFloorUnitFeeSummaryCount" parameterType="Map" resultType="Map"> select count(1) count from ( java110-interface/src/main/java/com/java110/intf/report/IReportFeeMonthStatisticsInnerServiceSMO.java
@@ -75,6 +75,15 @@ List<ReportFeeMonthStatisticsDto> queryReportFeeSummary(@RequestBody ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto); /** * 查询费用汇总表 大计 * * @param reportFeeMonthStatisticsDto * @return */ @RequestMapping(value = "/queryReportFeeSummaryMajor", method = RequestMethod.POST) ReportFeeMonthStatisticsDto queryReportFeeSummaryMajor(@RequestBody ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto); /** * 查询费用汇总表个数 * * @param reportFeeMonthStatisticsDto service-report/src/main/java/com/java110/report/bmo/reportFeeMonthStatistics/impl/GetReportFeeMonthStatisticsBMOImpl.java
@@ -80,6 +80,14 @@ reportFeeMonthStatistics.setChargeRate(String.format("%.2f", chargeRate) + "%"); reportFeeMonthStatisticsDtos.add(reportFeeMonthStatistics); } ReportFeeMonthStatisticsDto tmpReportFeeMonthStatisticsDto = reportFeeMonthStatisticsInnerServiceSMOImpl.queryReportFeeSummaryMajor(reportFeeMonthStatisticsDto); if(reportFeeMonthStatisticsList != null && reportFeeMonthStatisticsList.size()> 0){ for(ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto1 : reportFeeMonthStatisticsList){ reportFeeMonthStatisticsDto1.setAllReceivableAmount(tmpReportFeeMonthStatisticsDto.getAllReceivableAmount()); reportFeeMonthStatisticsDto1.setAllReceivedAmount(tmpReportFeeMonthStatisticsDto.getAllReceivableAmount()); reportFeeMonthStatisticsDto1.setAllOweAmount(tmpReportFeeMonthStatisticsDto.getAllOweAmount()); } } } else { reportFeeMonthStatisticsDtos = new ArrayList<>(); } service-report/src/main/java/com/java110/report/dao/IReportFeeMonthStatisticsServiceDao.java
@@ -302,4 +302,6 @@ List<Map> queryPayFeeDeposit(Map beanCovertMap); List<Map> queryFeeDepositAmount(Map beanCovertMap); Map queryReportFeeSummaryMajor(Map beanCovertMap); } service-report/src/main/java/com/java110/report/dao/impl/ReportFeeMonthStatisticsServiceDaoImpl.java
@@ -129,6 +129,16 @@ return businessReportFeeMonthStatisticsInfos; } @Override public Map queryReportFeeSummaryMajor(Map info) { logger.debug("查询费用月统计信息 入参 info : {}", info); List<Map> businessReportFeeMonthStatisticsInfos = sqlSessionTemplate.selectList("reportFeeMonthStatisticsServiceDaoImpl.queryReportFeeSummaryMajor", info); return businessReportFeeMonthStatisticsInfos.get(0); } @Override public int queryReportFloorUnitFeeSummaryCount(Map info) { logger.debug("查询费用月统计数据 入参 info : {}", info); @@ -443,4 +453,5 @@ return deposits; } } service-report/src/main/java/com/java110/report/smo/impl/ReportFeeMonthStatisticsInnerServiceSMOImpl.java
@@ -103,6 +103,14 @@ } @Override public ReportFeeMonthStatisticsDto queryReportFeeSummaryMajor(@RequestBody ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto) { ReportFeeMonthStatisticsDto reportFeeMonthStatistics = BeanConvertUtil.covertBean( reportFeeMonthStatisticsServiceDaoImpl.queryReportFeeSummaryMajor( BeanConvertUtil.beanCovertMap(reportFeeMonthStatisticsDto)), ReportFeeMonthStatisticsDto.class); return reportFeeMonthStatistics; } @Override public int queryReportFloorUnitFeeSummaryCount(@RequestBody ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto) { return reportFeeMonthStatisticsServiceDaoImpl.queryReportFloorUnitFeeSummaryCount(BeanConvertUtil.beanCovertMap(reportFeeMonthStatisticsDto)); }
