From bd72b193becb5770c2ba7dd0580d46428def7a03 Mon Sep 17 00:00:00 2001
From: java110 <928255095@qq.com>
Date: 星期一, 29 五月 2023 17:00:57 +0800
Subject: [PATCH] optmize
---
service-report/src/main/java/com/java110/report/api/ReportFeeMonthStatisticsApi.java | 218 ++++++++++++++++++++++++++++++++++--------------------
1 files changed, 138 insertions(+), 80 deletions(-)
diff --git a/service-report/src/main/java/com/java110/report/api/ReportFeeMonthStatisticsApi.java b/service-report/src/main/java/com/java110/report/api/ReportFeeMonthStatisticsApi.java
index 0d281d4..633e8af 100755
--- a/service-report/src/main/java/com/java110/report/api/ReportFeeMonthStatisticsApi.java
+++ b/service-report/src/main/java/com/java110/report/api/ReportFeeMonthStatisticsApi.java
@@ -1,6 +1,7 @@
package com.java110.report.api;
import com.alibaba.fastjson.JSONObject;
+import com.java110.dto.FloorDto;
import com.java110.dto.RoomDto;
import com.java110.dto.repair.RepairUserDto;
import com.java110.dto.report.ReportDeposit;
@@ -18,9 +19,10 @@
import org.springframework.http.ResponseEntity;
import org.springframework.web.bind.annotation.*;
-import java.text.ParseException;
-import java.text.SimpleDateFormat;
import java.util.Calendar;
+import java.util.HashMap;
+import java.util.List;
+import java.util.Map;
@RestController
@RequestMapping(value = "/reportFeeMonthStatistics")
@@ -113,40 +115,7 @@
return getReportFeeMonthStatisticsBMOImpl.get(reportFeeMonthStatisticsDto);
}
- /**
- * 鏌ヨ璐圭敤姹囨�昏〃
- *
- * @param communityId 灏忓尯ID
- * @return
- * @serviceCode /reportFeeMonthStatistics/queryReportFeeSummary
- * @path /app/reportFeeMonthStatistics/queryReportFeeSummary
- */
- @RequestMapping(value = "/queryReportFeeSummary", method = RequestMethod.GET)
- public ResponseEntity<String> queryReportFeeSummary(@RequestParam(value = "communityId") String communityId,
- @RequestParam(value = "floorId", required = false) String floorId,
- @RequestParam(value = "floorNum", required = false) String floorNum,
- @RequestParam(value = "unitNum", required = false) String unitNum,
- @RequestParam(value = "unitId", required = false) String unitId,
- @RequestParam(value = "roomId", required = false) String roomId,
- @RequestParam(value = "roomNum", required = false) String roomNum,
- @RequestParam(value = "startTime", required = false) String startTime,
- @RequestParam(value = "endTime", required = false) String endTime,
- @RequestParam(value = "page") int page,
- @RequestParam(value = "row") int row) {
- ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto = new ReportFeeMonthStatisticsDto();
- reportFeeMonthStatisticsDto.setPage(page);
- reportFeeMonthStatisticsDto.setRow(row);
- reportFeeMonthStatisticsDto.setCommunityId(communityId);
- reportFeeMonthStatisticsDto.setFloorId(floorId);
- reportFeeMonthStatisticsDto.setFloorNum(floorNum);
- reportFeeMonthStatisticsDto.setUnitId(unitId);
- reportFeeMonthStatisticsDto.setUnitNum(unitNum);
- reportFeeMonthStatisticsDto.setRoomId(roomId);
- reportFeeMonthStatisticsDto.setRoomNum(roomNum);
- reportFeeMonthStatisticsDto.setStartTime(startTime);
- reportFeeMonthStatisticsDto.setEndTime(endTime);
- return getReportFeeMonthStatisticsBMOImpl.queryReportFeeSummary(reportFeeMonthStatisticsDto);
- }
+
/**
* 鏌ヨ璐圭敤姹囨�昏〃
@@ -166,6 +135,7 @@
@RequestParam(value = "roomNum", required = false) String roomNum,
@RequestParam(value = "startTime", required = false) String startTime,
@RequestParam(value = "endTime", required = false) String endTime,
+ @RequestParam(value = "configIds", required = false) String configIds,
@RequestParam(value = "page") int page,
@RequestParam(value = "row") int row) {
ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto = new ReportFeeMonthStatisticsDto();
@@ -180,6 +150,9 @@
reportFeeMonthStatisticsDto.setRoomNum(roomNum);
reportFeeMonthStatisticsDto.setStartTime(startTime);
reportFeeMonthStatisticsDto.setEndTime(endTime);
+ if (!StringUtil.isEmpty(configIds)) {
+ reportFeeMonthStatisticsDto.setConfigIds(configIds.split(","));
+ }
return getReportFeeMonthStatisticsBMOImpl.queryReportFloorUnitFeeSummary(reportFeeMonthStatisticsDto);
}
@@ -203,6 +176,7 @@
@RequestParam(value = "feeTypeCd", required = false) String feeTypeCd,
@RequestParam(value = "startTime", required = false) String startTime,
@RequestParam(value = "endTime", required = false) String endTime,
+ @RequestParam(value = "yearMonth", required = false) String yearMonth,
@RequestParam(value = "page") int page,
@RequestParam(value = "row") int row) {
ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto = new ReportFeeMonthStatisticsDto();
@@ -217,6 +191,7 @@
reportFeeMonthStatisticsDto.setRoomNum(roomNum);
reportFeeMonthStatisticsDto.setConfigId(configId);
reportFeeMonthStatisticsDto.setFeeTypeCd(feeTypeCd);
+ reportFeeMonthStatisticsDto.setYearMonth(yearMonth);
if (!StringUtil.isEmpty(startTime)) {
reportFeeMonthStatisticsDto.setStartTime(startTime + " 00:00:00");
}
@@ -242,6 +217,7 @@
@RequestParam(value = "unitId", required = false) String unitId,
@RequestParam(value = "roomId", required = false) String roomId,
@RequestParam(value = "roomNum", required = false) String roomNum,
+ @RequestParam(value = "feeTypeCd", required = false) String feeTypeCd,
@RequestParam(value = "startTime", required = false) String startTime,
@RequestParam(value = "endTime", required = false) String endTime,
@RequestParam(value = "feeName", required = false) String feeName,
@@ -260,6 +236,7 @@
reportFeeMonthStatisticsDto.setRoomNum(roomNum);
reportFeeMonthStatisticsDto.setFeeName(feeName);
reportFeeMonthStatisticsDto.setConfigId(configId);
+ reportFeeMonthStatisticsDto.setFeeTypeCd(feeTypeCd);
reportFeeMonthStatisticsDto.setStartTime(startTime);
reportFeeMonthStatisticsDto.setEndTime(endTime);
return getReportFeeMonthStatisticsBMOImpl.queryFeeDetail(reportFeeMonthStatisticsDto);
@@ -283,6 +260,7 @@
@RequestParam(value = "roomNum", required = false) String roomNum,
@RequestParam(value = "startTime", required = false) String startTime,
@RequestParam(value = "endTime", required = false) String endTime,
+ @RequestParam(value = "objName", required = false) String objName,
@RequestParam(value = "page") int page,
@RequestParam(value = "row") int row) {
ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto = new ReportFeeMonthStatisticsDto();
@@ -297,6 +275,7 @@
reportFeeMonthStatisticsDto.setRoomNum(roomNum);
reportFeeMonthStatisticsDto.setStartTime(startTime);
reportFeeMonthStatisticsDto.setEndTime(endTime);
+ reportFeeMonthStatisticsDto.setObjName(objName);
return getReportFeeMonthStatisticsBMOImpl.queryOweFeeDetail(reportFeeMonthStatisticsDto);
}
@@ -322,6 +301,8 @@
@RequestParam(value = "configId", required = false) String configId,
@RequestParam(value = "startTime", required = false) String startTime,
@RequestParam(value = "endTime", required = false) String endTime,
+ @RequestParam(value = "objId", required = false) String objId,
+ @RequestParam(value = "roomName", required = false) String roomName,
@RequestParam(value = "page") int page,
@RequestParam(value = "row") int row) {
ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto = new ReportFeeMonthStatisticsDto();
@@ -340,6 +321,13 @@
reportFeeMonthStatisticsDto.setConfigId(configId);
reportFeeMonthStatisticsDto.setStartTime(startTime);
reportFeeMonthStatisticsDto.setEndTime(endTime);
+ reportFeeMonthStatisticsDto.setObjId(objId);
+ if(!StringUtil.isEmpty(roomName)){
+ String[] roomNameArray = roomName.split("-",3);
+ reportFeeMonthStatisticsDto.setFloorNum(roomNameArray[0]);
+ reportFeeMonthStatisticsDto.setUnitNum(roomNameArray[1]);
+ reportFeeMonthStatisticsDto.setRoomNum(roomNameArray[2]);
+ }
return getReportFeeMonthStatisticsBMOImpl.queryPayFeeDetail(reportFeeMonthStatisticsDto);
}
@@ -508,29 +496,6 @@
*
* @param communityId 灏忓尯ID
* @return
- * @serviceCode /reportFeeMonthStatistics/queryPrePayment
- * @path /app/reportFeeMonthStatistics/queryPrePayment
- */
- @RequestMapping(value = "/queryPrePayment", method = RequestMethod.GET)
- public ResponseEntity<String> queryPrePayment(@RequestParam(value = "communityId") String communityId,
- @RequestParam(value = "page") int page,
- @RequestParam(value = "row") int row) {
- ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto = new ReportFeeMonthStatisticsDto();
- reportFeeMonthStatisticsDto.setCommunityId(communityId);
- reportFeeMonthStatisticsDto.setPage(page);
- reportFeeMonthStatisticsDto.setRow(row);
- reportFeeMonthStatisticsDto.setStartTime(DateUtil.getNow(DateUtil.DATE_FORMATE_STRING_A));
- Calendar calendar = Calendar.getInstance();
- calendar.add(Calendar.DAY_OF_MONTH, 7);
- reportFeeMonthStatisticsDto.setEndTime(DateUtil.getFormatTimeString(calendar.getTime(), DateUtil.DATE_FORMATE_STRING_A));
- return getReportFeeMonthStatisticsBMOImpl.queryPrePayment(reportFeeMonthStatisticsDto);
- }
-
- /**
- * 鏌ヨ璐圭敤鍒嗛」琛�
- *
- * @param communityId 灏忓尯ID
- * @return
* @serviceCode /reportFeeMonthStatistics/queryOwePaymentCount
* @path /app/reportFeeMonthStatistics/queryOwePaymentCount
*/
@@ -539,22 +504,6 @@
ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto = new ReportFeeMonthStatisticsDto();
reportFeeMonthStatisticsDto.setCommunityId(communityId);
return getReportFeeMonthStatisticsBMOImpl.queryOwePaymentCount(reportFeeMonthStatisticsDto);
- }
-
-
- /**
- * 鏌ヨ璐圭敤鍒嗛」琛�
- *
- * @param communityId 灏忓尯ID
- * @return
- * @serviceCode /reportFeeMonthStatistics/queryReportProficient
- * @path /app/reportFeeMonthStatistics/queryReportProficient
- */
- @RequestMapping(value = "/queryReportProficient", method = RequestMethod.GET)
- public ResponseEntity<String> queryReportProficient(@RequestParam(value = "communityId") String communityId) {
- ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto = new ReportFeeMonthStatisticsDto();
- reportFeeMonthStatisticsDto.setCommunityId(communityId);
- return getReportFeeMonthStatisticsBMOImpl.queryReportProficientCount(reportFeeMonthStatisticsDto);
}
/**
@@ -579,11 +528,9 @@
* @path /app/reportFeeMonthStatistics/queryNoFeeRooms
*/
@RequestMapping(value = "/queryNoFeeRooms", method = RequestMethod.GET)
- public ResponseEntity<String> queryNoFeeRooms(
- @RequestParam(value = "communityId") String communityId,
- @RequestParam(value = "page") int page,
- @RequestParam(value = "row") int row
- ) {
+ public ResponseEntity<String> queryNoFeeRooms(@RequestParam(value = "communityId") String communityId,
+ @RequestParam(value = "page") int page,
+ @RequestParam(value = "row") int row) {
RoomDto roomDto = new RoomDto();
roomDto.setCommunityId(communityId);
roomDto.setPage(page);
@@ -591,4 +538,115 @@
return getReportFeeMonthStatisticsBMOImpl.queryNoFeeRooms(roomDto);
}
+
+ /**
+ * 鏌ヨ鍗庡畞鐗╀笟 娆犺垂缁熻鎶ヨ〃
+ * 浣滆�咃細 鍚村鏂�
+ * 鏃堕棿锛�2021-08-13
+ *
+ * @param communityId 灏忓尯ID
+ * @return
+ * @serviceCode /reportFeeMonthStatistics/queryHuaningOweFee
+ * @path /app/reportFeeMonthStatistics/queryHuaningOweFee
+ */
+ @RequestMapping(value = "/queryHuaningOweFee", method = RequestMethod.GET)
+ public ResponseEntity<String> queryHuaningOweFee(@RequestParam(value = "communityId") String communityId,
+ @RequestParam(value = "configId", required = false) String configId,
+ @RequestParam(value = "feeTypeCd", required = false) String feeTypeCd,
+ @RequestParam(value = "floorNum", required = false) String floorNum,
+ @RequestParam(value = "page") int page,
+ @RequestParam(value = "row") int row) {
+ ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto = new ReportFeeMonthStatisticsDto();
+ reportFeeMonthStatisticsDto.setCommunityId(communityId);
+ reportFeeMonthStatisticsDto.setConfigId(configId);
+ reportFeeMonthStatisticsDto.setFeeTypeCd(feeTypeCd);
+ reportFeeMonthStatisticsDto.setFloorNum(floorNum);
+ reportFeeMonthStatisticsDto.setPage(page);
+ reportFeeMonthStatisticsDto.setRow(row);
+ reportFeeMonthStatisticsDto.setFeeYear(DateUtil.getYear() + "");
+ return getReportFeeMonthStatisticsBMOImpl.queryHuaningOweFee(reportFeeMonthStatisticsDto);
+ }
+
+ /**
+ * 鏌ヨ鍗庡畞鐗╀笟 娆犺垂缁熻鎶ヨ〃
+ * 浣滆�咃細 鍚村鏂�
+ * 鏃堕棿锛�2021-08-13
+ *
+ * @param communityId 灏忓尯ID
+ * @return
+ * @serviceCode /reportFeeMonthStatistics/queryHuaningPayFee
+ * @path /app/reportFeeMonthStatistics/queryHuaningPayFee
+ */
+ @RequestMapping(value = "/queryHuaningPayFee", method = RequestMethod.GET)
+ public ResponseEntity<String> queryHuaningPayFee(@RequestParam(value = "communityId") String communityId,
+ @RequestParam(value = "configId", required = false) String configId,
+ @RequestParam(value = "feeTypeCd", required = false) String feeTypeCd,
+ @RequestParam(value = "floorNum", required = false) String floorNum,
+ @RequestParam(value = "year", required = false) int year,
+ @RequestParam(value = "month", required = false) int month,
+ @RequestParam(value = "page") int page,
+ @RequestParam(value = "row") int row) {
+ Map paramInfo = new HashMap();
+ paramInfo.put("communityId", communityId);
+ paramInfo.put("configId", configId);
+ paramInfo.put("feeTypeCd", feeTypeCd);
+ paramInfo.put("floorNum", floorNum);
+ paramInfo.put("year", year);
+ paramInfo.put("month", month);
+ paramInfo.put("page", page);
+ paramInfo.put("row", row);
+ return getReportFeeMonthStatisticsBMOImpl.queryHuaningPayFee(paramInfo);
+ }
+
+ /**
+ * 鏌ヨ鍗庡畞鐗╀笟 娆犺垂缁熻鎶ヨ〃
+ * 浣滆�咃細 鍚村鏂�
+ * 鏃堕棿锛�2021-08-13
+ *
+ * @param communityId 灏忓尯ID
+ * @return
+ * @serviceCode /reportFeeMonthStatistics/queryHuaningPayFeeTwo
+ * @path /app/reportFeeMonthStatistics/queryHuaningPayFeeTwo
+ */
+ @RequestMapping(value = "/queryHuaningPayFeeTwo", method = RequestMethod.GET)
+ public ResponseEntity<String> queryHuaningPayFeeTwo(@RequestParam(value = "communityId") String communityId,
+ @RequestParam(value = "year") int year,
+ @RequestParam(value = "month") int month,
+ @RequestParam(value = "page") int page,
+ @RequestParam(value = "row") int row) {
+ Map paramInfo = new HashMap();
+ paramInfo.put("communityId", communityId);
+ paramInfo.put("year", year);
+ paramInfo.put("month", month);
+ paramInfo.put("page", page);
+ paramInfo.put("row", row);
+ return getReportFeeMonthStatisticsBMOImpl.queryHuaningPayFeeTwo(paramInfo);
+ }
+
+ /**
+ * 鏌ヨ鍗庡畞鐗╀笟 娆犺垂缁熻鎶ヨ〃
+ * 浣滆�咃細 鍚村鏂�
+ * 鏃堕棿锛�2021-08-13
+ *
+ * @param communityId 灏忓尯ID
+ * @return
+ * @serviceCode /reportFeeMonthStatistics/queryHuaningOweFeeDetail
+ * @path /app/reportFeeMonthStatistics/queryHuaningOweFeeDetail
+ */
+ @RequestMapping(value = "/queryHuaningOweFeeDetail", method = RequestMethod.GET)
+ public ResponseEntity<String> queryHuaningOweFeeDetail(@RequestParam(value = "communityId") String communityId,
+ @RequestParam(value = "year") int year,
+ @RequestParam(value = "month") int month,
+ @RequestParam(value = "page") int page,
+ @RequestParam(value = "row") int row) {
+ Map paramInfo = new HashMap();
+ paramInfo.put("communityId", communityId);
+ paramInfo.put("year", year);
+ paramInfo.put("month", month);
+ paramInfo.put("page", page);
+ paramInfo.put("row", row);
+ return getReportFeeMonthStatisticsBMOImpl.queryHuaningOweFeeDetail(paramInfo);
+ }
+
+
}
--
Gitblit v1.8.0