From 74be20dfb5b244bbae3387db7a1aecb9fc1a21bd Mon Sep 17 00:00:00 2001
From: shiyj1101 <1098226878@qq.com>
Date: 星期三, 16 六月 2021 18:22:03 +0800
Subject: [PATCH] Merge branch 'master' of http://git.homecommunity.cn/supervip/MicroCommunity
---
service-front/src/main/java/com/java110/front/smo/assetExport/impl/ExportReportFeeSMOImpl.java | 191 +++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 180 insertions(+), 11 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
old mode 100644
new mode 100755
index 47fba4e..c97443f
--- 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
@@ -5,11 +5,13 @@
import com.alibaba.fastjson.parser.Feature;
import com.java110.core.component.BaseComponentSMO;
import com.java110.core.context.IPageData;
+import com.java110.dto.fee.FeeConfigDto;
import com.java110.entity.component.ComponentValidateResult;
import com.java110.front.smo.assetExport.IExportReportFeeSMO;
import com.java110.utils.constant.ServiceConstant;
import com.java110.utils.util.Assert;
import com.java110.utils.util.DateUtil;
+import com.java110.utils.util.StringUtil;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
@@ -27,6 +29,9 @@
import java.io.ByteArrayOutputStream;
import java.io.IOException;
+import java.math.BigDecimal;
+import java.util.ArrayList;
+import java.util.List;
/**
* @ClassName AssetImportSmoImpl
@@ -46,6 +51,7 @@
public static final String REPORT_OWE_FEE_DETAIL = "reportOweFeeDetail";
public static final String REPORT_PAY_FEE_DETAIL = "reportPayFeeDetail";
public static final String REPORT_YEAR_COLLECTION = "reportYearCollection";
+ public static final String REPORT_LIST_OWE_FEE = "listOweFee";
@Autowired
private RestTemplate restTemplate;
@@ -87,7 +93,9 @@
case REPORT_YEAR_COLLECTION:
reportYearCollection(pd, result, workbook);
break;
-
+ case REPORT_LIST_OWE_FEE:
+ reportListOweFee(pd, result, workbook);
+ break;
}
ByteArrayOutputStream os = new ByteArrayOutputStream();
MultiValueMap headers = new HttpHeaders();
@@ -112,10 +120,150 @@
return new ResponseEntity<Object>(context, headers, HttpStatus.OK);
}
+ private void reportListOweFee(IPageData pd, ComponentValidateResult result, Workbook workbook) {
+ JSONObject reqJson = JSONObject.parseObject(pd.getReqData());
+ String configIds = reqJson.getString("configIds");
+ //鏌ヨ妤兼爧淇℃伅
+ JSONArray oweFees = this.getReportListOweFees(pd, result);
+ if (oweFees == null) {
+ return;
+ }
+ //鑾峰彇璐圭敤椤�
+ List<FeeConfigDto> feeConfigDtos = getFeeConfigs(oweFees);
+ 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("缁撴潫鏃堕棿");
+ if (!StringUtil.isEmpty(configIds)) {
+ for (int feeConfigIndex = 0; feeConfigIndex < feeConfigDtos.size(); feeConfigIndex++) {
+ row.createCell(4 + feeConfigIndex).setCellValue(feeConfigDtos.get(feeConfigIndex).getFeeName());
+ }
+ row.createCell(4 + feeConfigDtos.size()).setCellValue("鍚堣");
+ } else {
+ row.createCell(4).setCellValue("鍚堣");
+ }
+
+
+ JSONObject dataObj = null;
+ for (int roomIndex = 0; roomIndex < oweFees.size(); roomIndex++) {
+ row = sheet.createRow(roomIndex + 1);
+ dataObj = oweFees.getJSONObject(roomIndex);
+ row.createCell(0).setCellValue(dataObj.getString("payerObjName"));
+ row.createCell(1).setCellValue(dataObj.getString("ownerName"));
+ row.createCell(2).setCellValue(dataObj.getString("endTime"));
+ row.createCell(3).setCellValue(dataObj.getString("deadlineTime"));
+ if (!StringUtil.isEmpty(configIds)) {
+ for (int feeConfigIndex = 0; feeConfigIndex < feeConfigDtos.size(); feeConfigIndex++) {
+ row.createCell(4 + feeConfigIndex).setCellValue(getFeeConfigAmount(feeConfigDtos.get(feeConfigIndex), dataObj));
+ }
+ row.createCell(4 + feeConfigDtos.size()).setCellValue(getAllFeeOweAmount(feeConfigDtos, dataObj));
+ } else {
+ row.createCell(4).setCellValue(getAllFeeOweAmount(feeConfigDtos, dataObj));
+ }
+
+ }
+ }
+
+ /**
+ * _getAllFeeOweAmount: function (_fee) {
+ * let _feeConfigNames = $that.listOweFeeInfo.feeConfigNames;
+ * if (_feeConfigNames.length < 1) {
+ * return _fee.amountOwed;
+ * }
+ * <p>
+ * let _amountOwed = 0.0;
+ * let _items = _fee.items;
+ * _feeConfigNames.forEach(_feeItem =>{
+ * _items.forEach(_item=>{
+ * if(_feeItem.configId == _item.configId){
+ * _amountOwed += parseFloat(_item.amountOwed);
+ * }
+ * })
+ * })
+ * return _amountOwed;
+ * }
+ *
+ * @param dataObj
+ * @return
+ */
+ private double getAllFeeOweAmount(List<FeeConfigDto> feeConfigDtos, JSONObject dataObj) {
+ if (feeConfigDtos == null || feeConfigDtos.size() < 1) {
+ return dataObj.getDouble("amountOwed");
+ }
+ JSONArray items = dataObj.getJSONArray("items");
+ if (items == null || items.size() < 1) {
+ return dataObj.getDouble("amountOwed");
+ }
+
+ BigDecimal oweAmount = new BigDecimal(0);
+ for (FeeConfigDto feeConfigDto : feeConfigDtos) {
+ for (int itemIndex = 0; itemIndex < items.size(); itemIndex++) {
+ if (feeConfigDto.getConfigId().equals(items.getJSONObject(itemIndex).getString("configId"))) {
+ oweAmount = oweAmount.add(new BigDecimal(items.getJSONObject(itemIndex).getDouble("amountOwed")));
+ }
+ }
+ }
+
+ return oweAmount.doubleValue();
+ }
+
+ private double getFeeConfigAmount(FeeConfigDto feeConfigDto, JSONObject dataObj) {
+ JSONArray items = dataObj.getJSONArray("items");
+ double oweAmount = 0;
+
+ if (items == null || items.size() < 1) {
+ return oweAmount;
+ }
+
+ for (int itemIndex = 0; itemIndex < items.size(); itemIndex++) {
+ if (feeConfigDto.getConfigId().equals(items.getJSONObject(itemIndex).getString("configId"))) {
+ oweAmount = items.getJSONObject(itemIndex).getDouble("amountOwed");
+ break;
+ }
+ }
+ return oweAmount;
+ }
+
+
+ private List<FeeConfigDto> getFeeConfigs(JSONArray oweFees) {
+ List<FeeConfigDto> feeConfigDtos = new ArrayList<>();
+ FeeConfigDto feeConfigDto = null;
+ for (int oweFeeIndex = 0; oweFeeIndex < oweFees.size(); oweFeeIndex++) {
+ JSONArray items = oweFees.getJSONObject(oweFeeIndex).getJSONArray("items");
+ for (int itemIndex = 0; itemIndex < items.size(); itemIndex++) {
+ if (existsFeeConfig(feeConfigDtos, items.getJSONObject(itemIndex))) {
+ continue;
+ }
+ feeConfigDto = new FeeConfigDto();
+ feeConfigDto.setConfigId(items.getJSONObject(itemIndex).getString("configId"));
+ feeConfigDto.setFeeName(items.getJSONObject(itemIndex).getString("configName"));
+ feeConfigDtos.add(feeConfigDto);
+ }
+ }
+
+ return feeConfigDtos;
+ }
+
+ private boolean existsFeeConfig(List<FeeConfigDto> feeConfigDtos, JSONObject oweFee) {
+ if (feeConfigDtos.size() < 1) {
+ return false;
+ }
+ for (FeeConfigDto feeConfigDto : feeConfigDtos) {
+ if (feeConfigDto.getConfigId().equals(oweFee.getString("configId"))) {
+ return true;
+ }
+ }
+
+ return false;
+ }
+
+
private void reportPayFeeDetail(IPageData pd, ComponentValidateResult result, Workbook workbook) {
Sheet sheet = workbook.createSheet("缂磋垂鏄庣粏琛�");
Row row = sheet.createRow(0);
- row.createCell(0).setCellValue("璐圭敤缂栧彿");
+ row.createCell(0).setCellValue("璁㈠崟鍙�");
row.createCell(1).setCellValue("鎴垮彿");
row.createCell(2).setCellValue("璐圭敤椤�");
row.createCell(3).setCellValue("鏀粯鏂瑰紡");
@@ -129,6 +277,7 @@
row.createCell(11).setCellValue("婊炵撼閲�");
row.createCell(12).setCellValue("绌虹疆鎴挎墦鎶橀噾棰�");
row.createCell(13).setCellValue("绌虹疆鎴垮噺鍏嶉噾棰�");
+ row.createCell(14).setCellValue("涓氫富");
//鏌ヨ妤兼爧淇℃伅
JSONArray rooms = this.getReportPayFeeDetail(pd, result);
if (rooms == null) {
@@ -138,20 +287,22 @@
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(0).setCellValue(dataObj.getString("oId"));
row.createCell(1).setCellValue(dataObj.getString("objName"));
row.createCell(2).setCellValue(dataObj.getString("feeName"));
row.createCell(3).setCellValue(dataObj.getString("primeRate"));
row.createCell(4).setCellValue(dataObj.getString("startTime"));
row.createCell(5).setCellValue(dataObj.getString("endTime"));
row.createCell(6).setCellValue(dataObj.getString("createTime"));
- row.createCell(7).setCellValue(dataObj.getString("receivableAmount"));
- row.createCell(8).setCellValue(dataObj.getString("receivedAmount"));
- row.createCell(9).setCellValue(dataObj.getString("preferentialAmount"));
- row.createCell(10).setCellValue(dataObj.getString("deductionAmount"));
- row.createCell(11).setCellValue(dataObj.getString("lateFee"));
- row.createCell(12).setCellValue(dataObj.getString("vacantHousingDiscount"));
- row.createCell(13).setCellValue(dataObj.getString("vacantHousingReduction"));
+ row.createCell(7).setCellValue(dataObj.getDouble("receivableAmount"));
+ row.createCell(8).setCellValue(dataObj.getDouble("receivedAmount"));
+ row.createCell(9).setCellValue(dataObj.getDouble("preferentialAmount"));
+ row.createCell(10).setCellValue(dataObj.getDouble("deductionAmount"));
+ row.createCell(11).setCellValue(dataObj.getDouble("lateFee"));
+ row.createCell(12).setCellValue(dataObj.getDouble("vacantHousingDiscount"));
+ row.createCell(13).setCellValue(dataObj.getDouble("vacantHousingReduction"));
+ row.createCell(14).setCellValue(dataObj.getString("ownerName"));
+
}
}
@@ -192,6 +343,24 @@
row.createCell(6 + detailIndex).setCellValue(reportFeeYearCollectionDetailDtos.getJSONObject(detailIndex).getString("receivedAmount"));
}
}
+ }
+
+ private JSONArray getReportListOweFees(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//reportOweFee/queryReportAllOweFee" + 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 JSONArray getReportPayFeeDetail(IPageData pd, ComponentValidateResult result) {
@@ -367,7 +536,7 @@
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(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"));
--
Gitblit v1.8.0