From 9fd2f9a7b69a26cf1a5aed1d664a0d042e1e864a Mon Sep 17 00:00:00 2001
From: java110 <928255095@qq.com>
Date: 星期一, 21 十二月 2020 16:44:01 +0800
Subject: [PATCH] 完成富友 支付对接完成
---
service-front/src/main/java/com/java110/front/smo/assetExport/impl/ExportReportFeeSMOImpl.java | 287 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 283 insertions(+), 4 deletions(-)
diff --git a/service-front/src/main/java/com/java110/front/smo/assetExport/impl/ExportReportFeeSMOImpl.java b/service-front/src/main/java/com/java110/front/smo/assetExport/impl/ExportReportFeeSMOImpl.java
index a4f6717..c5b86ac 100644
--- a/service-front/src/main/java/com/java110/front/smo/assetExport/impl/ExportReportFeeSMOImpl.java
+++ b/service-front/src/main/java/com/java110/front/smo/assetExport/impl/ExportReportFeeSMOImpl.java
@@ -41,6 +41,11 @@
private final static Logger logger = LoggerFactory.getLogger(ExportReportFeeSMOImpl.class);
public static final String REPORT_FEE_SUMMARY = "reportFeeSummary";
+ public static final String REPORT_FLOOR_UNIT_FEE_SUMMARY = "reportFloorUnitFeeSummary";
+ public static final String REPORT_FEE_BREAKDOWN = "reportFeeBreakdown";
+ public static final String REPORT_FEE_DETAIL = "reportFeeDetail";
+ public static final String REPORT_OWE_FEE_DETAIL = "reportOweFeeDetail";
+ public static final String REPORT_PAY_FEE_DETAIL = "reportPayFeeDetail";
@Autowired
private RestTemplate restTemplate;
@@ -63,13 +68,30 @@
case REPORT_FEE_SUMMARY:
reportFeeSummary(pd, result, workbook);
break;
+ case REPORT_FLOOR_UNIT_FEE_SUMMARY:
+ reportFloorUnitFeeSummary(pd, result, workbook);
+ break;
+ case REPORT_FEE_BREAKDOWN:
+ reportFeeBreakdown(pd, result, workbook);
+ break;
+ case REPORT_FEE_DETAIL:
+ reportFeeDetail(pd, result, workbook);
+ break;
+
+ case REPORT_OWE_FEE_DETAIL:
+ reportOweFeeDetail(pd, result, workbook);
+ break;
+ case REPORT_PAY_FEE_DETAIL:
+ reportPayFeeDetail(pd, result, workbook);
+ break;
+
}
ByteArrayOutputStream os = new ByteArrayOutputStream();
MultiValueMap headers = new HttpHeaders();
headers.add("content-type", "application/octet-stream;charset=UTF-8");
- headers.add("Content-Disposition", "attachment;filename=feeManualCollection_" + DateUtil.getyyyyMMddhhmmssDateString() + ".xlsx");
+ headers.add("Content-Disposition", "attachment;filename=" + pagePath + DateUtil.getyyyyMMddhhmmssDateString() + ".xlsx");
headers.add("Pargam", "no-cache");
headers.add("Cache-Control", "no-cache");
//headers.add("Content-Disposition", "attachment; filename=" + outParam.getString("fileName"));
@@ -87,6 +109,265 @@
}
// 淇濆瓨鏁版嵁
return new ResponseEntity<Object>(context, headers, HttpStatus.OK);
+ }
+
+ private void reportPayFeeDetail(IPageData pd, ComponentValidateResult result, Workbook workbook) {
+ Sheet sheet = workbook.createSheet("缂磋垂鏄庣粏琛�");
+ Row row = sheet.createRow(0);
+ row.createCell(0).setCellValue("璐圭敤缂栧彿");
+ row.createCell(1).setCellValue("鎴垮彿");
+ row.createCell(2).setCellValue("璐圭敤椤�");
+ row.createCell(3).setCellValue("缂磋垂寮�濮嬫椂闂�");
+ row.createCell(4).setCellValue("缂磋垂缁撴潫鏃堕棿");
+ row.createCell(5).setCellValue("缂磋垂鏃堕棿");
+ row.createCell(6).setCellValue("搴旀敹閲戦");
+ row.createCell(7).setCellValue("瀹炴敹閲戦");
+
+
+ //鏌ヨ妤兼爧淇℃伅
+ JSONArray rooms = this.getReportPayFeeDetail(pd, result);
+
+ if (rooms == null) {
+ return;
+ }
+ JSONObject dataObj = null;
+ for (int roomIndex = 0; roomIndex < rooms.size(); roomIndex++) {
+ row = sheet.createRow(roomIndex + 1);
+ dataObj = rooms.getJSONObject(roomIndex);
+
+ row.createCell(0).setCellValue(roomIndex + 1);
+ row.createCell(1).setCellValue(dataObj.getString("objName"));
+ row.createCell(2).setCellValue(dataObj.getString("feeName"));
+ row.createCell(3).setCellValue(dataObj.getString("startTime"));
+ row.createCell(4).setCellValue(dataObj.getString("endTime"));
+ row.createCell(5).setCellValue(dataObj.getString("createTime"));
+ row.createCell(6).setCellValue(dataObj.getString("receivableAmount"));
+ row.createCell(7).setCellValue(dataObj.getString("receivedAmount"));
+
+ }
+ }
+
+ private JSONArray getReportPayFeeDetail(IPageData pd, ComponentValidateResult result) {
+ String apiUrl = "";
+ ResponseEntity<String> responseEntity = null;
+ JSONObject reqJson = JSONObject.parseObject(pd.getReqData());
+ reqJson.put("page", 1);
+ reqJson.put("row", 10000);
+ apiUrl = ServiceConstant.SERVICE_API_URL + "/api/reportFeeMonthStatistics/queryPayFeeDetail" + mapToUrlParam(reqJson);
+ responseEntity = this.callCenterService(restTemplate, pd, "", apiUrl, HttpMethod.GET);
+
+ if (responseEntity.getStatusCode() != HttpStatus.OK) { //璺宠繃 淇濆瓨鍗曞厓淇℃伅
+ return null;
+ }
+
+ JSONObject savedRoomInfoResults = JSONObject.parseObject(responseEntity.getBody(), Feature.OrderedField);
+
+
+ if (!savedRoomInfoResults.containsKey("data")) {
+ return null;
+ }
+
+
+ return savedRoomInfoResults.getJSONArray("data");
+ }
+
+ private void reportOweFeeDetail(IPageData pd, ComponentValidateResult result, Workbook workbook) {
+ Sheet sheet = workbook.createSheet("娆犺垂鏄庣粏琛�");
+ Row row = sheet.createRow(0);
+ row.createCell(0).setCellValue("璐圭敤缂栧彿");
+ row.createCell(1).setCellValue("鎴垮彿");
+ row.createCell(2).setCellValue("璐圭敤椤�");
+ row.createCell(3).setCellValue("璐圭敤寮�濮嬫椂闂�");
+ row.createCell(4).setCellValue("娆犺垂鏃堕暱锛堝ぉ锛�");
+ row.createCell(5).setCellValue("娆犺垂閲戦");
+
+
+ //鏌ヨ妤兼爧淇℃伅
+ JSONArray rooms = this.getReportOweFeeDetail(pd, result);
+ JSONObject dataObj = null;
+ for (int roomIndex = 0; roomIndex < rooms.size(); roomIndex++) {
+ row = sheet.createRow(roomIndex + 1);
+ dataObj = rooms.getJSONObject(roomIndex);
+
+ row.createCell(0).setCellValue(roomIndex + 1);
+ row.createCell(1).setCellValue(dataObj.getString("objName"));
+ row.createCell(2).setCellValue(dataObj.getString("feeName"));
+ row.createCell(3).setCellValue(dataObj.getString("feeCreateTime"));
+ row.createCell(4).setCellValue(dataObj.getString("oweDay"));
+ row.createCell(5).setCellValue(dataObj.getString("oweAmount"));
+
+ }
+ }
+
+ private void reportFeeDetail(IPageData pd, ComponentValidateResult result, Workbook workbook) {
+ Sheet sheet = workbook.createSheet("璐圭敤鏄庣粏琛�");
+ Row row = sheet.createRow(0);
+ row.createCell(0).setCellValue("璐圭敤缂栧彿");
+ row.createCell(1).setCellValue("鎴垮彿");
+ row.createCell(2).setCellValue("璐圭敤椤�");
+ row.createCell(3).setCellValue("璐圭敤寮�濮嬫椂闂�");
+ row.createCell(4).setCellValue("璐圭敤缁撴潫鏃堕棿");
+ row.createCell(5).setCellValue("搴旀敹閲戦");
+ row.createCell(6).setCellValue("瀹炴敹閲戦");
+
+
+ //鏌ヨ妤兼爧淇℃伅
+ JSONArray rooms = this.getReportFeeDetail(pd, result);
+ JSONObject dataObj = null;
+ for (int roomIndex = 0; roomIndex < rooms.size(); roomIndex++) {
+ row = sheet.createRow(roomIndex + 1);
+ dataObj = rooms.getJSONObject(roomIndex);
+
+ row.createCell(0).setCellValue(roomIndex + 1);
+ row.createCell(1).setCellValue(dataObj.getString("objName"));
+ row.createCell(2).setCellValue(dataObj.getString("feeName"));
+ row.createCell(3).setCellValue(dataObj.getString("feeCreateTime"));
+ row.createCell(4).setCellValue(dataObj.getString("deadlineTime"));
+ row.createCell(5).setCellValue(dataObj.getString("receivableAmount"));
+ row.createCell(6).setCellValue(dataObj.getString("receivedAmount"));
+
+ }
+ }
+
+ private JSONArray getReportOweFeeDetail(IPageData pd, ComponentValidateResult result) {
+ String apiUrl = "";
+ ResponseEntity<String> responseEntity = null;
+ apiUrl = ServiceConstant.SERVICE_API_URL + "/api/reportFeeMonthStatistics/queryOweFeeDetail?communityId=" + result.getCommunityId() + "&page=1&row=10000";
+ responseEntity = this.callCenterService(restTemplate, pd, "", apiUrl, HttpMethod.GET);
+
+ if (responseEntity.getStatusCode() != HttpStatus.OK) { //璺宠繃 淇濆瓨鍗曞厓淇℃伅
+ return null;
+ }
+
+ JSONObject savedRoomInfoResults = JSONObject.parseObject(responseEntity.getBody(), Feature.OrderedField);
+
+
+ if (!savedRoomInfoResults.containsKey("data")) {
+ return null;
+ }
+
+
+ return savedRoomInfoResults.getJSONArray("data");
+ }
+
+ private JSONArray getReportFeeDetail(IPageData pd, ComponentValidateResult result) {
+ String apiUrl = "";
+ ResponseEntity<String> responseEntity = null;
+ apiUrl = ServiceConstant.SERVICE_API_URL + "/api/reportFeeMonthStatistics/queryFeeDetail?communityId=" + result.getCommunityId() + "&page=1&row=10000";
+ responseEntity = this.callCenterService(restTemplate, pd, "", apiUrl, HttpMethod.GET);
+
+ if (responseEntity.getStatusCode() != HttpStatus.OK) { //璺宠繃 淇濆瓨鍗曞厓淇℃伅
+ return null;
+ }
+
+ JSONObject savedRoomInfoResults = JSONObject.parseObject(responseEntity.getBody(), Feature.OrderedField);
+
+
+ if (!savedRoomInfoResults.containsKey("data")) {
+ return null;
+ }
+
+
+ return savedRoomInfoResults.getJSONArray("data");
+ }
+
+ private void reportFeeBreakdown(IPageData pd, ComponentValidateResult result, Workbook workbook) {
+ Sheet sheet = workbook.createSheet("璐圭敤鍒嗛」琛�");
+ Row row = sheet.createRow(0);
+ row.createCell(0).setCellValue("璐圭敤缂栧彿");
+ row.createCell(1).setCellValue("璐圭敤椤�");
+ row.createCell(2).setCellValue("璐圭敤寮�濮嬫椂闂�");
+ row.createCell(3).setCellValue("搴旀敹閲戦");
+ row.createCell(4).setCellValue("瀹炴敹閲戦");
+ row.createCell(5).setCellValue("娆犺垂閲戦");
+
+
+ //鏌ヨ妤兼爧淇℃伅
+ JSONArray rooms = this.getReportFeeBreakdown(pd, result);
+ JSONObject dataObj = null;
+ for (int roomIndex = 0; roomIndex < rooms.size(); roomIndex++) {
+ row = sheet.createRow(roomIndex + 1);
+ dataObj = rooms.getJSONObject(roomIndex);
+
+ row.createCell(0).setCellValue(roomIndex + 1);
+ row.createCell(1).setCellValue(dataObj.getString("feeName"));
+ row.createCell(2).setCellValue(dataObj.getString("feeCreateTime"));
+ row.createCell(3).setCellValue(dataObj.getString("receivableAmount"));
+ row.createCell(4).setCellValue(dataObj.getString("receivedAmount"));
+ row.createCell(5).setCellValue(dataObj.getString("oweAmount"));
+
+ }
+ }
+
+ private JSONArray getReportFeeBreakdown(IPageData pd, ComponentValidateResult result) {
+
+ String apiUrl = "";
+ ResponseEntity<String> responseEntity = null;
+ apiUrl = ServiceConstant.SERVICE_API_URL + "/api/reportFeeMonthStatistics/queryFeeBreakdown?communityId=" + result.getCommunityId() + "&page=1&row=10000";
+ responseEntity = this.callCenterService(restTemplate, pd, "", apiUrl, HttpMethod.GET);
+
+ if (responseEntity.getStatusCode() != HttpStatus.OK) { //璺宠繃 淇濆瓨鍗曞厓淇℃伅
+ return null;
+ }
+
+ JSONObject savedRoomInfoResults = JSONObject.parseObject(responseEntity.getBody(), Feature.OrderedField);
+
+
+ if (!savedRoomInfoResults.containsKey("data")) {
+ return null;
+ }
+
+
+ return savedRoomInfoResults.getJSONArray("data");
+ }
+
+ private void reportFloorUnitFeeSummary(IPageData pd, ComponentValidateResult result, Workbook workbook) {
+ Sheet sheet = workbook.createSheet("妤兼爧璐圭敤琛�");
+ Row row = sheet.createRow(0);
+ row.createCell(0).setCellValue("鏃ユ湡");
+ row.createCell(1).setCellValue("妤兼爧");
+ row.createCell(2).setCellValue("鍗曞厓");
+ row.createCell(3).setCellValue("搴旀敹閲戦");
+ row.createCell(4).setCellValue("瀹炴敹閲戦");
+ row.createCell(5).setCellValue("娆犺垂閲戦");
+
+
+ //鏌ヨ妤兼爧淇℃伅
+ JSONArray rooms = this.getReportFloorUnitFeeSummary(pd, result);
+ JSONObject dataObj = null;
+ for (int roomIndex = 0; roomIndex < rooms.size(); roomIndex++) {
+ row = sheet.createRow(roomIndex + 1);
+ dataObj = rooms.getJSONObject(roomIndex);
+ row.createCell(0).setCellValue(dataObj.getString("feeYear") + "骞�" + dataObj.getString("feeMonth") + "鏈�");
+ row.createCell(1).setCellValue(dataObj.getString("floorNum") + "鍙锋ゼ");
+ row.createCell(2).setCellValue(dataObj.getString("unitNum") + "鍗曞厓");
+ row.createCell(3).setCellValue(dataObj.getString("receivableAmount"));
+ row.createCell(4).setCellValue(dataObj.getString("receivedAmount"));
+ row.createCell(5).setCellValue(dataObj.getString("oweAmount"));
+
+ }
+ }
+
+ private JSONArray getReportFloorUnitFeeSummary(IPageData pd, ComponentValidateResult result) {
+ String apiUrl = "";
+ ResponseEntity<String> responseEntity = null;
+ apiUrl = ServiceConstant.SERVICE_API_URL + "/api/reportFeeMonthStatistics/queryFloorUnitFeeSummary?communityId=" + result.getCommunityId() + "&page=1&row=10000";
+ responseEntity = this.callCenterService(restTemplate, pd, "", apiUrl, HttpMethod.GET);
+
+ if (responseEntity.getStatusCode() != HttpStatus.OK) { //璺宠繃 淇濆瓨鍗曞厓淇℃伅
+ return null;
+ }
+
+ JSONObject savedRoomInfoResults = JSONObject.parseObject(responseEntity.getBody(), Feature.OrderedField);
+
+
+ if (!savedRoomInfoResults.containsKey("data")) {
+ return null;
+ }
+
+
+ return savedRoomInfoResults.getJSONArray("data");
+
}
@@ -133,15 +414,13 @@
row.createCell(1).setCellValue("搴旀敹閲戦");
row.createCell(2).setCellValue("瀹炴敹閲戦");
row.createCell(3).setCellValue("娆犺垂閲戦");
- row = sheet.createRow(1);
- row.createCell(0).setCellValue("搴忓彿");
//鏌ヨ妤兼爧淇℃伅
JSONArray rooms = this.getReportFeeSummaryFee(pd, componentValidateResult);
JSONObject dataObj = null;
for (int roomIndex = 0; roomIndex < rooms.size(); roomIndex++) {
- row = sheet.createRow(roomIndex + 2);
+ row = sheet.createRow(roomIndex + 1);
dataObj = rooms.getJSONObject(roomIndex);
row.createCell(0).setCellValue(dataObj.getString("feeYear") + "骞�" + dataObj.getString("feeMonth") + "鏈�");
--
Gitblit v1.8.0