package com.java110.report.bmo.reportFeeMonthStatistics.impl;
|
|
import com.alibaba.fastjson.JSONObject;
|
import com.java110.dto.RoomDto;
|
import com.java110.dto.fee.FeeConfigDto;
|
import com.java110.dto.fee.FeeDto;
|
import com.java110.dto.repair.RepairUserDto;
|
import com.java110.dto.reportFeeMonthStatistics.ReportFeeMonthStatisticsDto;
|
import com.java110.dto.reportFeeMonthStatistics.ReportFeeMonthStatisticsTotalDto;
|
import com.java110.intf.report.IReportFeeMonthStatisticsInnerServiceSMO;
|
import com.java110.report.bmo.reportFeeMonthStatistics.IGetReportFeeMonthStatisticsBMO;
|
import com.java110.utils.util.DateUtil;
|
import com.java110.utils.util.StringUtil;
|
import com.java110.vo.ResultVo;
|
import org.slf4j.Logger;
|
import org.slf4j.LoggerFactory;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.http.HttpStatus;
|
import org.springframework.http.ResponseEntity;
|
import org.springframework.stereotype.Service;
|
|
import java.text.ParseException;
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
|
@Service("getReportFeeMonthStatisticsBMOImpl")
|
public class GetReportFeeMonthStatisticsBMOImpl implements IGetReportFeeMonthStatisticsBMO {
|
|
private static final Logger logger = LoggerFactory.getLogger(GetReportFeeMonthStatisticsBMOImpl.class);
|
|
@Autowired
|
private IReportFeeMonthStatisticsInnerServiceSMO reportFeeMonthStatisticsInnerServiceSMOImpl;
|
|
/**
|
* @param reportFeeMonthStatisticsDto
|
* @return 订单服务能够接受的报文
|
*/
|
public ResponseEntity<String> get(ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto) {
|
|
|
int count = reportFeeMonthStatisticsInnerServiceSMOImpl.queryReportFeeMonthStatisticssCount(reportFeeMonthStatisticsDto);
|
|
List<ReportFeeMonthStatisticsDto> reportFeeMonthStatisticsDtos = null;
|
if (count > 0) {
|
reportFeeMonthStatisticsDtos = reportFeeMonthStatisticsInnerServiceSMOImpl.queryReportFeeMonthStatisticss(reportFeeMonthStatisticsDto);
|
} else {
|
reportFeeMonthStatisticsDtos = new ArrayList<>();
|
}
|
|
ResultVo resultVo = new ResultVo((int) Math.ceil((double) count / (double) reportFeeMonthStatisticsDto.getRow()), count, reportFeeMonthStatisticsDtos);
|
|
ResponseEntity<String> responseEntity = new ResponseEntity<String>(resultVo.toString(), HttpStatus.OK);
|
|
return responseEntity;
|
}
|
|
@Override
|
public ResponseEntity<String> queryReportFeeSummary(ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto) {
|
int count = reportFeeMonthStatisticsInnerServiceSMOImpl.queryReportFeeSummaryCount(reportFeeMonthStatisticsDto);
|
|
List<ReportFeeMonthStatisticsDto> reportFeeMonthStatisticsDtos = new ArrayList<>();
|
if (count > 0) {
|
List<ReportFeeMonthStatisticsDto> reportFeeMonthStatisticsList = reportFeeMonthStatisticsInnerServiceSMOImpl.queryReportFeeSummary(reportFeeMonthStatisticsDto);
|
for (ReportFeeMonthStatisticsDto reportFeeMonthStatistics : reportFeeMonthStatisticsList) {
|
//获取应收金额
|
double receivableAmount = Double.parseDouble(reportFeeMonthStatistics.getReceivableAmount());
|
//获取实收金额
|
double receivedAmount = Double.parseDouble(reportFeeMonthStatistics.getReceivedAmount());
|
double chargeRate = (receivedAmount / receivableAmount) * 100.0;
|
reportFeeMonthStatistics.setChargeRate(String.format("%.2f", chargeRate) + "%");
|
reportFeeMonthStatisticsDtos.add(reportFeeMonthStatistics);
|
}
|
} else {
|
reportFeeMonthStatisticsDtos = new ArrayList<>();
|
}
|
|
ResultVo resultVo = new ResultVo((int) Math.ceil((double) count / (double) reportFeeMonthStatisticsDto.getRow()), count, reportFeeMonthStatisticsDtos);
|
|
ResponseEntity<String> responseEntity = new ResponseEntity<String>(resultVo.toString(), HttpStatus.OK);
|
|
return responseEntity;
|
}
|
|
@Override
|
public ResponseEntity<String> queryReportFloorUnitFeeSummary(ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto) {
|
int count = reportFeeMonthStatisticsInnerServiceSMOImpl.queryReportFloorUnitFeeSummaryCount(reportFeeMonthStatisticsDto);
|
|
List<ReportFeeMonthStatisticsDto> reportFeeMonthStatisticsDtos = null;
|
if (count > 0) {
|
reportFeeMonthStatisticsDtos = reportFeeMonthStatisticsInnerServiceSMOImpl.queryReportFloorUnitFeeSummary(reportFeeMonthStatisticsDto);
|
} else {
|
reportFeeMonthStatisticsDtos = new ArrayList<>();
|
}
|
|
ResultVo resultVo = new ResultVo((int) Math.ceil((double) count / (double) reportFeeMonthStatisticsDto.getRow()), count, reportFeeMonthStatisticsDtos);
|
|
ResponseEntity<String> responseEntity = new ResponseEntity<String>(resultVo.toString(), HttpStatus.OK);
|
|
return responseEntity;
|
}
|
|
@Override
|
public ResponseEntity<String> queryFeeBreakdown(ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto) {
|
int count = reportFeeMonthStatisticsInnerServiceSMOImpl.queryFeeBreakdownCount(reportFeeMonthStatisticsDto);
|
|
List<ReportFeeMonthStatisticsDto> reportFeeMonthStatisticsDtos = null;
|
if (count > 0) {
|
reportFeeMonthStatisticsDtos = reportFeeMonthStatisticsInnerServiceSMOImpl.queryFeeBreakdown(reportFeeMonthStatisticsDto);
|
} else {
|
reportFeeMonthStatisticsDtos = new ArrayList<>();
|
}
|
|
//查询该小区下的费用项目
|
FeeConfigDto feeConfigDto = new FeeConfigDto();
|
feeConfigDto.setCommunityId(reportFeeMonthStatisticsDto.getCommunityId());
|
List<FeeConfigDto> feeConfigDtos = reportFeeMonthStatisticsInnerServiceSMOImpl.queryFeeConfigs(feeConfigDto);
|
|
List<ReportFeeMonthStatisticsDto> reportList = new ArrayList<>();
|
for (ReportFeeMonthStatisticsDto reportFeeMonthStatistics : reportFeeMonthStatisticsDtos) {
|
reportFeeMonthStatistics.setFeeConfigDtos(feeConfigDtos);
|
reportList.add(reportFeeMonthStatistics);
|
}
|
|
ResultVo resultVo = new ResultVo((int) Math.ceil((double) count / (double) reportFeeMonthStatisticsDto.getRow()), count, reportList);
|
|
ResponseEntity<String> responseEntity = new ResponseEntity<String>(resultVo.toString(), HttpStatus.OK);
|
|
return responseEntity;
|
}
|
|
@Override
|
public ResponseEntity<String> queryFeeDetail(ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto) {
|
int count = reportFeeMonthStatisticsInnerServiceSMOImpl.queryFeeDetailCount(reportFeeMonthStatisticsDto);
|
|
List<ReportFeeMonthStatisticsDto> reportFeeMonthStatisticsDtos = null;
|
//应收总金额(大计)
|
Double allReceivableAmount = 0.0;
|
//实收金额(大计)
|
Double allReceivedAmount = 0.0;
|
if (count > 0) {
|
reportFeeMonthStatisticsDtos = reportFeeMonthStatisticsInnerServiceSMOImpl.queryFeeDetail(reportFeeMonthStatisticsDto);
|
List<ReportFeeMonthStatisticsDto> reportFeeMonthStatisticsList = reportFeeMonthStatisticsInnerServiceSMOImpl.queryAllFeeDetail(reportFeeMonthStatisticsDto);
|
allReceivableAmount = Double.valueOf(reportFeeMonthStatisticsList.get(0).getAllReceivableAmount());
|
allReceivedAmount = Double.valueOf(reportFeeMonthStatisticsList.get(0).getAllReceivedAmount());
|
} else {
|
reportFeeMonthStatisticsDtos = new ArrayList<>();
|
}
|
|
//应收总金额(小计)
|
Double totalReceivableAmount = 0.0;
|
//实收总金额(小计)
|
Double totalReceivedAmount = 0.0;
|
List<ReportFeeMonthStatisticsDto> reportList = new ArrayList<>();
|
for (ReportFeeMonthStatisticsDto reportFeeMonthStatistics : reportFeeMonthStatisticsDtos) {
|
//应收金额
|
Double receivableAmount = Double.valueOf(reportFeeMonthStatistics.getReceivableAmount());
|
//实收金额
|
Double receivedAmount = Double.valueOf(reportFeeMonthStatistics.getReceivedAmount());
|
totalReceivableAmount = totalReceivableAmount + receivableAmount;
|
totalReceivedAmount = totalReceivedAmount + receivedAmount;
|
}
|
|
//查询该小区下的费用项目
|
FeeConfigDto feeConfigDto = new FeeConfigDto();
|
feeConfigDto.setCommunityId(reportFeeMonthStatisticsDto.getCommunityId());
|
List<FeeConfigDto> feeConfigDtos = reportFeeMonthStatisticsInnerServiceSMOImpl.queryFeeConfigs(feeConfigDto);
|
|
for (ReportFeeMonthStatisticsDto reportFeeMonthStatistics : reportFeeMonthStatisticsDtos) {
|
reportFeeMonthStatistics.setTotalReceivableAmount(String.format("%.2f", totalReceivableAmount));
|
reportFeeMonthStatistics.setTotalReceivedAmount(String.format("%.2f", totalReceivedAmount));
|
reportFeeMonthStatistics.setAllReceivableAmount(String.format("%.2f", allReceivableAmount));
|
reportFeeMonthStatistics.setAllReceivedAmount(String.format("%.2f", allReceivedAmount));
|
reportFeeMonthStatistics.setFeeConfigDtos(feeConfigDtos);
|
reportList.add(reportFeeMonthStatistics);
|
}
|
|
ResultVo resultVo = new ResultVo((int) Math.ceil((double) count / (double) reportFeeMonthStatisticsDto.getRow()), count, reportList);
|
|
ResponseEntity<String> responseEntity = new ResponseEntity<String>(resultVo.toString(), HttpStatus.OK);
|
|
return responseEntity;
|
}
|
|
@Override
|
public ResponseEntity<String> queryOweFeeDetail(ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto) {
|
int count = reportFeeMonthStatisticsInnerServiceSMOImpl.queryOweFeeDetailCount(reportFeeMonthStatisticsDto);
|
|
List<ReportFeeMonthStatisticsDto> reportFeeMonthStatisticsDtos = null;
|
if (count > 0) {
|
reportFeeMonthStatisticsDtos = reportFeeMonthStatisticsInnerServiceSMOImpl.queryOweFeeDetail(reportFeeMonthStatisticsDto);
|
|
freshReportOweDay(reportFeeMonthStatisticsDtos);
|
} else {
|
reportFeeMonthStatisticsDtos = new ArrayList<>();
|
}
|
|
ResultVo resultVo = new ResultVo((int) Math.ceil((double) count / (double) reportFeeMonthStatisticsDto.getRow()), count, reportFeeMonthStatisticsDtos);
|
|
ResponseEntity<String> responseEntity = new ResponseEntity<String>(resultVo.toString(), HttpStatus.OK);
|
|
return responseEntity;
|
}
|
|
@Override
|
public ResponseEntity<String> queryPayFeeDetail(ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto) {
|
|
JSONObject countInfo = reportFeeMonthStatisticsInnerServiceSMOImpl.queryPayFeeDetailCount(reportFeeMonthStatisticsDto);
|
|
int count = Integer.parseInt(countInfo.get("count").toString());
|
|
List<ReportFeeMonthStatisticsDto> reportFeeMonthStatisticsDtos = null;
|
ReportFeeMonthStatisticsTotalDto reportFeeMonthStatisticsTotalDto = new ReportFeeMonthStatisticsTotalDto();
|
List<ReportFeeMonthStatisticsDto> reportList = new ArrayList<>();
|
//查询该小区下的费用项目
|
FeeConfigDto feeConfigDto = new FeeConfigDto();
|
feeConfigDto.setCommunityId(reportFeeMonthStatisticsDto.getCommunityId());
|
List<FeeConfigDto> feeConfigDtos = reportFeeMonthStatisticsInnerServiceSMOImpl.queryFeeConfigs(feeConfigDto);
|
//应收总金额(大计)
|
Double allReceivableAmount = 0.0;
|
//实收金额(大计)
|
Double allReceivedAmount = 0.0;
|
//优惠金额(大计)
|
Double allPreferentialAmount = 0.0;
|
//减免金额(大计)
|
Double allDeductionAmount = 0.0;
|
//滞纳金(大计)
|
Double allLateFee = 0.0;
|
//空置房打折(大计)
|
Double allVacantHousingDiscount = 0.0;
|
//空置房减免(大计)
|
Double allVacantHousingReduction = 0.0;
|
if (count > 0) {
|
//查询缴费明细
|
reportFeeMonthStatisticsDtos = reportFeeMonthStatisticsInnerServiceSMOImpl.queryPayFeeDetail(reportFeeMonthStatisticsDto);
|
//查询应收、实收总金额(大计)
|
List<ReportFeeMonthStatisticsDto> reportFeeMonthStatisticsList = reportFeeMonthStatisticsInnerServiceSMOImpl.queryAllPayFeeDetail(reportFeeMonthStatisticsDto);
|
//查询(优惠、减免、滞纳金、空置房打折、空置房减免金额等)大计总金额
|
List<ReportFeeMonthStatisticsDto> reportFeeMonthStatisticsSum = reportFeeMonthStatisticsInnerServiceSMOImpl.queryPayFeeDetailSum(reportFeeMonthStatisticsDto);
|
allReceivableAmount = Double.valueOf(reportFeeMonthStatisticsList.get(0).getAllReceivableAmount());
|
allReceivedAmount = Double.valueOf(reportFeeMonthStatisticsList.get(0).getAllReceivedAmount());
|
for (ReportFeeMonthStatisticsDto reportFeeMonthStatistics : reportFeeMonthStatisticsSum) {
|
//这里是查询出的金额总和
|
String discountPrice = reportFeeMonthStatistics.getDiscountPrice();
|
//优惠金额(大计)
|
if (!StringUtil.isEmpty(reportFeeMonthStatistics.getDiscountSmallType()) && reportFeeMonthStatistics.getDiscountSmallType().equals("1")) {
|
allPreferentialAmount = Double.valueOf(discountPrice);
|
}
|
//减免金额(大计)
|
if (!StringUtil.isEmpty(reportFeeMonthStatistics.getDiscountSmallType()) && reportFeeMonthStatistics.getDiscountSmallType().equals("2")) {
|
allDeductionAmount = Double.valueOf(discountPrice);
|
}
|
//滞纳金(大计)
|
if (!StringUtil.isEmpty(reportFeeMonthStatistics.getDiscountSmallType()) && reportFeeMonthStatistics.getDiscountSmallType().equals("3")) {
|
allLateFee = Double.valueOf(discountPrice);
|
}
|
//空置房打折金额(大计)
|
if (!StringUtil.isEmpty(reportFeeMonthStatistics.getDiscountSmallType()) && reportFeeMonthStatistics.getDiscountSmallType().equals("4")) {
|
allVacantHousingDiscount = Double.valueOf(discountPrice);
|
}
|
//空置房减免金额(大计)
|
if (!StringUtil.isEmpty(reportFeeMonthStatistics.getDiscountSmallType()) && reportFeeMonthStatistics.getDiscountSmallType().equals("5")) {
|
allVacantHousingReduction = Double.valueOf(discountPrice);
|
}
|
}
|
//应收总金额(小计)
|
Double totalReceivableAmount = 0.0;
|
//实收总金额(小计)
|
Double totalReceivedAmount = 0.0;
|
//优惠金额(小计)
|
Double totalPreferentialAmount = 0.0;
|
//减免金额(小计)
|
Double totalDeductionAmount = 0.0;
|
//空置房打折金额(小计)
|
Double totalVacantHousingDiscount = 0.0;
|
//空置房减免金额(小计)
|
Double totalVacantHousingReduction = 0.0;
|
//滞纳金(小计)
|
Double totalLateFee = 0.0;
|
for (ReportFeeMonthStatisticsDto reportFeeMonthStatistics : reportFeeMonthStatisticsDtos) {
|
//应收金额
|
Double receivableAmount = Double.valueOf(reportFeeMonthStatistics.getReceivableAmount());
|
//实收金额
|
Double receivedAmount = Double.valueOf(reportFeeMonthStatistics.getReceivedAmount());
|
totalReceivableAmount = totalReceivableAmount + receivableAmount;
|
totalReceivedAmount = totalReceivedAmount + receivedAmount;
|
//优惠金额
|
if (!StringUtil.isEmpty(reportFeeMonthStatistics.getDiscountSmallType()) && reportFeeMonthStatistics.getDiscountSmallType().equals("1")) {
|
//获取优惠金额
|
Double discountPrice = Double.valueOf(reportFeeMonthStatistics.getDiscountPrice());
|
totalPreferentialAmount = totalPreferentialAmount + discountPrice;
|
//优惠金额
|
reportFeeMonthStatistics.setPreferentialAmount(reportFeeMonthStatistics.getDiscountPrice());
|
} else {
|
reportFeeMonthStatistics.setPreferentialAmount("0");
|
}
|
//减免金额
|
if (!StringUtil.isEmpty(reportFeeMonthStatistics.getDiscountSmallType()) && reportFeeMonthStatistics.getDiscountSmallType().equals("2")) {
|
//获取减免金额
|
Double discountPrice = Double.valueOf(reportFeeMonthStatistics.getDiscountPrice());
|
totalDeductionAmount = totalDeductionAmount + discountPrice;
|
//减免金额
|
reportFeeMonthStatistics.setDeductionAmount(reportFeeMonthStatistics.getDiscountPrice());
|
} else {
|
reportFeeMonthStatistics.setDeductionAmount("0");
|
}
|
//滞纳金
|
if (!StringUtil.isEmpty(reportFeeMonthStatistics.getDiscountSmallType()) && reportFeeMonthStatistics.getDiscountSmallType().equals("3")) {
|
//获取滞纳金金额
|
Double discountPrice = (Double.valueOf(reportFeeMonthStatistics.getDiscountPrice())) * (-1);
|
totalLateFee = totalLateFee + discountPrice;
|
//滞纳金
|
reportFeeMonthStatistics.setLateFee(reportFeeMonthStatistics.getDiscountPrice());
|
} else {
|
reportFeeMonthStatistics.setLateFee("0");
|
}
|
//空置房打折
|
if (!StringUtil.isEmpty(reportFeeMonthStatistics.getDiscountSmallType()) && reportFeeMonthStatistics.getDiscountSmallType().equals("4")) {
|
//空置房打折金额
|
Double discountPrice = Double.valueOf(reportFeeMonthStatistics.getDiscountPrice());
|
totalVacantHousingDiscount = totalVacantHousingDiscount + discountPrice;
|
//空置房打折
|
reportFeeMonthStatistics.setVacantHousingDiscount(reportFeeMonthStatistics.getDiscountPrice());
|
} else {
|
reportFeeMonthStatistics.setVacantHousingDiscount("0");
|
}
|
//空置房减免
|
if (!StringUtil.isEmpty(reportFeeMonthStatistics.getDiscountSmallType()) && reportFeeMonthStatistics.getDiscountSmallType().equals("5")) {
|
//空置房减免金额
|
Double discountPrice = Double.valueOf(reportFeeMonthStatistics.getDiscountPrice());
|
totalVacantHousingReduction = totalVacantHousingReduction + discountPrice;
|
//空置房减免
|
reportFeeMonthStatistics.setVacantHousingReduction(reportFeeMonthStatistics.getDiscountPrice());
|
} else {
|
reportFeeMonthStatistics.setVacantHousingReduction("0");
|
}
|
if (FeeDto.PAYER_OBJ_TYPE_ROOM.equals(reportFeeMonthStatistics.getPayerObjType())) {
|
reportFeeMonthStatistics.setObjName(reportFeeMonthStatistics.getFloorNum()
|
+ "栋" + reportFeeMonthStatistics.getUnitNum()
|
+ "单元" + reportFeeMonthStatistics.getRoomNum() + "室");
|
} else if (FeeDto.PAYER_OBJ_TYPE_CAR.equals(reportFeeMonthStatistics.getPayerObjType())) {
|
reportFeeMonthStatistics.setObjName(reportFeeMonthStatistics.getCarNum());
|
} else {
|
reportFeeMonthStatistics.setObjName(reportFeeMonthStatistics.getContractCode());
|
|
}
|
if (!StringUtil.isEmpty(reportFeeMonthStatistics.getImportFeeName())) {
|
reportFeeMonthStatistics.setFeeName(reportFeeMonthStatistics.getImportFeeName());
|
}
|
//费用项目
|
reportFeeMonthStatistics.setFeeConfigDtos(feeConfigDtos);
|
reportList.add(reportFeeMonthStatistics);
|
}
|
//应收总金额(小计)
|
reportFeeMonthStatisticsTotalDto.setTotalReceivableAmount(String.format("%.2f", totalReceivableAmount));
|
//实收金额(小计)
|
reportFeeMonthStatisticsTotalDto.setTotalReceivedAmount(String.format("%.2f", totalReceivedAmount));
|
//优惠金额(小计)
|
reportFeeMonthStatisticsTotalDto.setTotalPreferentialAmount(String.valueOf(totalPreferentialAmount));
|
//减免金额(小计)
|
reportFeeMonthStatisticsTotalDto.setTotalDeductionAmount(String.valueOf(totalDeductionAmount));
|
//滞纳金(小计)
|
reportFeeMonthStatisticsTotalDto.setTotalLateFee(String.valueOf(totalLateFee));
|
//空置房打折(小计)
|
reportFeeMonthStatisticsTotalDto.setTotalVacantHousingDiscount(String.valueOf(totalVacantHousingDiscount));
|
//空置房减免(小计)
|
reportFeeMonthStatisticsTotalDto.setTotalVacantHousingReduction(String.valueOf(totalVacantHousingReduction));
|
//应收金额(大计)
|
reportFeeMonthStatisticsTotalDto.setAllReceivableAmount(String.format("%.2f", allReceivableAmount));
|
//实收金额(大计)
|
reportFeeMonthStatisticsTotalDto.setAllReceivedAmount(String.format("%.2f", allReceivedAmount));
|
//优惠金额(大计)
|
reportFeeMonthStatisticsTotalDto.setAllPreferentialAmount(String.valueOf(allPreferentialAmount));
|
//减免金额(大计)
|
reportFeeMonthStatisticsTotalDto.setAllDeductionAmount(String.valueOf(allDeductionAmount));
|
//滞纳金(大计)
|
reportFeeMonthStatisticsTotalDto.setAllLateFee(String.valueOf(allLateFee));
|
//空置房打折金额(大计)
|
reportFeeMonthStatisticsTotalDto.setAllVacantHousingDiscount(String.valueOf(allVacantHousingDiscount));
|
//空置房减免金额(大计)
|
reportFeeMonthStatisticsTotalDto.setAllVacantHousingReduction(String.valueOf(allVacantHousingReduction));
|
} else {
|
reportFeeMonthStatisticsDtos = new ArrayList<>();
|
reportList.addAll(reportFeeMonthStatisticsDtos);
|
reportFeeMonthStatisticsTotalDto = new ReportFeeMonthStatisticsTotalDto();
|
}
|
|
ResultVo resultVo = new ResultVo((int) Math.ceil((double) count / (double) reportFeeMonthStatisticsDto.getRow()), count, reportList, reportFeeMonthStatisticsTotalDto);
|
|
ResponseEntity<String> responseEntity = new ResponseEntity<String>(resultVo.toString(), HttpStatus.OK);
|
|
return responseEntity;
|
}
|
|
@Override
|
public ResponseEntity<String> queryDeadlineFee(ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto) {
|
int count = reportFeeMonthStatisticsInnerServiceSMOImpl.queryDeadlineFeeCount(reportFeeMonthStatisticsDto);
|
|
List<ReportFeeMonthStatisticsDto> reportFeeMonthStatisticsDtos = null;
|
if (count > 0) {
|
reportFeeMonthStatisticsDtos = reportFeeMonthStatisticsInnerServiceSMOImpl.queryDeadlineFee(reportFeeMonthStatisticsDto);
|
|
freshReportDeadlineDay(reportFeeMonthStatisticsDtos);
|
} else {
|
reportFeeMonthStatisticsDtos = new ArrayList<>();
|
}
|
|
ResultVo resultVo = new ResultVo((int) Math.ceil((double) count / (double) reportFeeMonthStatisticsDto.getRow()), count, reportFeeMonthStatisticsDtos);
|
|
ResponseEntity<String> responseEntity = new ResponseEntity<String>(resultVo.toString(), HttpStatus.OK);
|
|
return responseEntity;
|
}
|
|
@Override
|
public ResponseEntity<String> queryPrePaymentCount(ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto) {
|
|
List<ReportFeeMonthStatisticsDto> reportFeeMonthStatisticsDtos = null;
|
|
reportFeeMonthStatisticsDtos = reportFeeMonthStatisticsInnerServiceSMOImpl.queryPrePaymentCount(reportFeeMonthStatisticsDto);
|
|
ResultVo resultVo = new ResultVo(reportFeeMonthStatisticsDtos);
|
|
ResponseEntity<String> responseEntity = new ResponseEntity<String>(resultVo.toString(), HttpStatus.OK);
|
|
return responseEntity;
|
}
|
|
@Override
|
public ResponseEntity<String> queryDeadlinePaymentCount(ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto) {
|
|
List<ReportFeeMonthStatisticsDto> reportFeeMonthStatisticsDtos = null;
|
|
reportFeeMonthStatisticsDtos = reportFeeMonthStatisticsInnerServiceSMOImpl.queryDeadlinePaymentCount(reportFeeMonthStatisticsDto);
|
|
ResultVo resultVo = new ResultVo(reportFeeMonthStatisticsDtos);
|
|
ResponseEntity<String> responseEntity = new ResponseEntity<String>(resultVo.toString(), HttpStatus.OK);
|
|
return responseEntity;
|
}
|
|
@Override
|
public ResponseEntity<String> queryOwePaymentCount(ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto) {
|
|
List<ReportFeeMonthStatisticsDto> reportFeeMonthStatisticsDtos = null;
|
List<ReportFeeMonthStatisticsDto> reportAllFeeMonthStatisticsDtos = null;
|
|
reportFeeMonthStatisticsDtos = reportFeeMonthStatisticsInnerServiceSMOImpl.queryOwePaymentCount(reportFeeMonthStatisticsDto);
|
|
reportAllFeeMonthStatisticsDtos = reportFeeMonthStatisticsInnerServiceSMOImpl.queryAllPaymentCount(reportFeeMonthStatisticsDto);
|
int normalFee = 0;
|
for (ReportFeeMonthStatisticsDto aReportFeeMonthStatisticsDto : reportAllFeeMonthStatisticsDtos) {
|
for (ReportFeeMonthStatisticsDto oweReportFeeMonthStatisticsDto : reportFeeMonthStatisticsDtos) {
|
String objCount = aReportFeeMonthStatisticsDto.getObjCount();
|
if (aReportFeeMonthStatisticsDto.getFeeName().equals(oweReportFeeMonthStatisticsDto.getFeeName())) {
|
aReportFeeMonthStatisticsDto.setObjCount(oweReportFeeMonthStatisticsDto.getObjCount());
|
normalFee = Integer.parseInt(objCount) - Integer.parseInt(oweReportFeeMonthStatisticsDto.getObjCount());
|
aReportFeeMonthStatisticsDto.setNormalCount(normalFee + "");
|
}
|
}
|
}
|
|
|
ResultVo resultVo = new ResultVo(reportAllFeeMonthStatisticsDtos);
|
|
ResponseEntity<String> responseEntity = new ResponseEntity<String>(resultVo.toString(), HttpStatus.OK);
|
|
return responseEntity;
|
}
|
|
/**
|
* 查询报表专家 统计信息
|
*
|
* @param reportFeeMonthStatisticsDto
|
* @return
|
*/
|
@Override
|
public ResponseEntity<String> queryReportProficientCount(ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto) {
|
JSONObject result = reportFeeMonthStatisticsInnerServiceSMOImpl.queryReportProficientCount(reportFeeMonthStatisticsDto);
|
ResponseEntity<String> responseEntity = new ResponseEntity<String>(result.toString(), HttpStatus.OK);
|
|
return responseEntity;
|
}
|
|
/**
|
* 查询报修信息
|
*
|
* @param repairUserDto
|
* @return
|
*/
|
@Override
|
public ResponseEntity<String> queryRepair(RepairUserDto repairUserDto) {
|
//查询员工报修表员工信息
|
List<RepairUserDto> repairUsers = reportFeeMonthStatisticsInnerServiceSMOImpl.queryRepairForStaff(repairUserDto);
|
int count = repairUsers.size();
|
//获取员工id和姓名集合
|
List<RepairUserDto> staffs;
|
if (StringUtil.isEmpty(repairUserDto.getStaffId())) {
|
repairUserDto.setPage(-1);
|
staffs = reportFeeMonthStatisticsInnerServiceSMOImpl.queryRepairForStaff(repairUserDto);
|
} else {
|
repairUserDto.setPage(-1);
|
repairUserDto.setStaffId(null);
|
staffs = reportFeeMonthStatisticsInnerServiceSMOImpl.queryRepairForStaff(repairUserDto);
|
}
|
List<RepairUserDto> repairUserList = new ArrayList<>();
|
//处理中总数量
|
int dealNumber = 0;
|
//结单总数量
|
int statementNumber = 0;
|
//退单总数量
|
int chargebackNumber = 0;
|
//转单总数量
|
int transferOrderNumber = 0;
|
//派单总数量
|
int dispatchNumber = 0;
|
//已回访总数量
|
int returnNumber = 0;
|
if (count > 0) {
|
for (RepairUserDto repairUser : repairUsers) {
|
RepairUserDto repairUserInfo = new RepairUserDto();
|
//员工id
|
repairUserDto.setStaffId(repairUser.getStaffId());
|
List<RepairUserDto> repairUserDtoList = reportFeeMonthStatisticsInnerServiceSMOImpl.queryRepairWithOutPage(repairUserDto);
|
if (repairUserDtoList != null && repairUserDtoList.size() > 0) {
|
//处理中数量
|
int dealAmount = 0;
|
//结单数量
|
int statementAmount = 0;
|
//退单数量
|
int chargebackAmount = 0;
|
//转单数量
|
int transferOrderAmount = 0;
|
//派单数量
|
int dispatchAmount = 0;
|
//回访数量
|
int returnAmount = 0;
|
//评分
|
String score = "";
|
for (RepairUserDto repair : repairUserDtoList) {
|
//处理中状态
|
if (repair.getState().equals("10001")) {
|
//获取数量
|
int amount = Integer.parseInt(repair.getAmount());
|
dealAmount = dealAmount + amount;
|
} else if (repair.getState().equals("10002")) { //结单状态
|
//获取数量
|
int amount = Integer.parseInt(repair.getAmount());
|
statementAmount = statementAmount + amount;
|
} else if (repair.getState().equals("10003")) { //退单状态
|
//获取数量
|
int amount = Integer.parseInt(repair.getAmount());
|
chargebackAmount = chargebackAmount + amount;
|
} else if (repair.getState().equals("10004")) { //转单状态
|
//获取数量
|
int amount = Integer.parseInt(repair.getAmount());
|
transferOrderAmount = transferOrderAmount + amount;
|
} else if (repair.getState().equals("10006")) { //派单状态
|
int amount = Integer.parseInt(repair.getAmount());
|
dispatchAmount = dispatchAmount + amount;
|
} else if (repair.getState().equals("10008")) { //已回访状态
|
int amount = Integer.parseInt(repair.getAmount());
|
returnAmount = returnAmount + amount;
|
}
|
if (!StringUtil.isEmpty(repair.getScore())) {
|
score = repair.getScore();
|
}
|
}
|
//员工id
|
repairUserInfo.setStaffId(repairUser.getStaffId());
|
//员工姓名
|
repairUserInfo.setStaffName(repairUser.getStaffName());
|
//处理中报修数量
|
repairUserInfo.setDealAmount(Integer.toString(dealAmount));
|
//处理中报修总数量
|
repairUserInfo.setDealNumber(Integer.toString(dealNumber));
|
//结单报修数量
|
repairUserInfo.setStatementAmount(Integer.toString(statementAmount));
|
//结单报修总数量
|
repairUserInfo.setStatementNumber(Integer.toString(statementNumber));
|
//退单报修数量
|
repairUserInfo.setChargebackAmount(Integer.toString(chargebackAmount));
|
//退单报修总数量
|
repairUserInfo.setChargebackNumber(Integer.toString(chargebackNumber));
|
//转单报修数量
|
repairUserInfo.setTransferOrderAmount(Integer.toString(transferOrderAmount));
|
//转单报修总数量
|
repairUserInfo.setTransferOrderNumber(Integer.toString(transferOrderNumber));
|
//派单报修数量
|
repairUserInfo.setDispatchAmount(Integer.toString(dispatchAmount));
|
//派单报修总数量
|
repairUserInfo.setDispatchNumber(Integer.toString(dispatchNumber));
|
//回访数量
|
repairUserInfo.setReturnAmount(Integer.toString(returnAmount));
|
//回访总数量
|
repairUserInfo.setReturnNumber(Integer.toString(returnNumber));
|
//员工id和姓名信息集合
|
repairUserInfo.setRepairList(staffs);
|
//员工评分
|
repairUserInfo.setScore(score);
|
repairUserList.add(repairUserInfo);
|
} else {
|
continue;
|
}
|
dealNumber = Integer.parseInt(repairUserInfo.getDealAmount()) + dealNumber;
|
statementNumber = Integer.parseInt(repairUserInfo.getStatementAmount()) + statementNumber;
|
chargebackNumber = Integer.parseInt(repairUserInfo.getChargebackAmount()) + chargebackNumber;
|
transferOrderNumber = Integer.parseInt(repairUserInfo.getTransferOrderAmount()) + transferOrderNumber;
|
dispatchNumber = Integer.parseInt(repairUserInfo.getDispatchAmount()) + dispatchNumber;
|
returnNumber = Integer.parseInt(repairUserInfo.getReturnAmount()) + returnNumber;
|
}
|
} else {
|
repairUserList = new ArrayList<>();
|
}
|
|
RepairUserDto repairUser = new RepairUserDto();
|
repairUser.setDealNumber(Integer.toString(dealNumber));
|
repairUser.setStatementNumber(Integer.toString(statementNumber));
|
repairUser.setChargebackNumber(Integer.toString(chargebackNumber));
|
repairUser.setTransferOrderNumber(Integer.toString(transferOrderNumber));
|
repairUser.setDispatchNumber(Integer.toString(dispatchNumber));
|
repairUser.setReturnNumber(Integer.toString(returnNumber));
|
|
//获取总条数
|
int size = staffs.size();
|
|
ResultVo resultVo = new ResultVo((int) Math.ceil((double) size / (double) repairUserDto.getRow()), repairUserList.size(), repairUserList, staffs, repairUser);
|
|
ResponseEntity<String> responseEntity = new ResponseEntity<String>(resultVo.toString(), HttpStatus.OK);
|
|
return responseEntity;
|
}
|
|
@Override
|
public ResponseEntity<String> queryNoFeeRooms(RoomDto roomDto) {
|
int count = reportFeeMonthStatisticsInnerServiceSMOImpl.queryNoFeeRoomsCount(roomDto);
|
|
List<RoomDto> roomDtos = null;
|
if (count > 0) {
|
roomDtos = reportFeeMonthStatisticsInnerServiceSMOImpl.queryNoFeeRooms(roomDto);
|
} else {
|
roomDtos = new ArrayList<>();
|
}
|
|
ResultVo resultVo = new ResultVo((int) Math.ceil((double) count / (double) roomDto.getRow()), count, roomDtos);
|
|
ResponseEntity<String> responseEntity = new ResponseEntity<String>(resultVo.toString(), HttpStatus.OK);
|
|
return responseEntity;
|
}
|
|
@Override
|
public ResponseEntity<String> queryPrePayment(ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto) {
|
|
int count = reportFeeMonthStatisticsInnerServiceSMOImpl.queryPrePaymentNewCount(reportFeeMonthStatisticsDto);
|
|
List<ReportFeeMonthStatisticsDto> reportFeeMonthStatisticsDtos = null;
|
if (count > 0) {
|
reportFeeMonthStatisticsDtos = reportFeeMonthStatisticsInnerServiceSMOImpl.queryPrePayment(reportFeeMonthStatisticsDto);
|
for (ReportFeeMonthStatisticsDto tmpReportFeeMonthStatisticsDto : reportFeeMonthStatisticsDtos) {
|
if (FeeDto.PAYER_OBJ_TYPE_ROOM.equals(tmpReportFeeMonthStatisticsDto.getPayerObjType())) {
|
tmpReportFeeMonthStatisticsDto.setObjName(tmpReportFeeMonthStatisticsDto.getFloorNum()
|
+ "栋" + tmpReportFeeMonthStatisticsDto.getUnitNum()
|
+ "单元" + tmpReportFeeMonthStatisticsDto.getRoomNum() + "室");
|
} else {
|
tmpReportFeeMonthStatisticsDto.setObjName(tmpReportFeeMonthStatisticsDto.getCarNum());
|
}
|
|
try {
|
tmpReportFeeMonthStatisticsDto.setOweDay(DateUtil.daysBetween(DateUtil.getDateFromString(tmpReportFeeMonthStatisticsDto.getEndTime(), DateUtil.DATE_FORMATE_STRING_A), DateUtil.getCurrentDate()));
|
} catch (ParseException e) {
|
logger.error("费用结束时间错误" + tmpReportFeeMonthStatisticsDto.getEndTime(), e);
|
}
|
}
|
} else {
|
reportFeeMonthStatisticsDtos = new ArrayList<>();
|
}
|
|
ResultVo resultVo = new ResultVo((int) Math.ceil((double) count / (double) reportFeeMonthStatisticsDto.getRow()), count, reportFeeMonthStatisticsDtos);
|
|
ResponseEntity<String> responseEntity = new ResponseEntity<String>(resultVo.toString(), HttpStatus.OK);
|
|
return responseEntity;
|
}
|
|
private void freshReportOweDay(List<ReportFeeMonthStatisticsDto> reportFeeMonthStatisticsDtos) {
|
|
Date nowDate = DateUtil.getCurrentDate();
|
|
for (ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto : reportFeeMonthStatisticsDtos) {
|
try {
|
int day = DateUtil.daysBetween(nowDate, DateUtil.getDateFromString(reportFeeMonthStatisticsDto.getFeeCreateTime(),
|
DateUtil.DATE_FORMATE_STRING_A));
|
reportFeeMonthStatisticsDto.setOweDay(day);
|
} catch (Exception e) {
|
logger.error("计算欠费天数失败", e);
|
}
|
|
}
|
}
|
|
private void freshReportDeadlineDay(List<ReportFeeMonthStatisticsDto> reportFeeMonthStatisticsDtos) {
|
|
Date nowDate = DateUtil.getCurrentDate();
|
|
for (ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto : reportFeeMonthStatisticsDtos) {
|
try {
|
int day = DateUtil.daysBetween(DateUtil.getDateFromString(reportFeeMonthStatisticsDto.getDeadlineTime(),
|
DateUtil.DATE_FORMATE_STRING_A), nowDate);
|
reportFeeMonthStatisticsDto.setOweDay(day);
|
} catch (Exception e) {
|
logger.error("计算欠费天数失败", e);
|
}
|
|
}
|
}
|
|
|
}
|
