package com.java110.fee.cmd.fee; import com.alibaba.fastjson.JSONObject; import com.java110.core.annotation.Java110Cmd; import com.java110.core.context.ICmdDataFlowContext; import com.java110.core.event.cmd.Cmd; import com.java110.core.event.cmd.CmdEvent; import com.java110.dto.community.CommunityDto; import com.java110.dto.dict.DictDto; import com.java110.dto.fee.FeeDto; import com.java110.intf.community.ICommunityInnerServiceSMO; import com.java110.intf.dev.IDictV1InnerServiceSMO; import com.java110.intf.fee.IReportFeeInnerServiceSMO; import com.java110.po.fee.PayFeePo; import com.java110.utils.exception.CmdException; import com.java110.utils.util.Assert; import com.java110.vo.FeeQueryParams; import com.java110.vo.ResultVo; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.http.HttpStatus; import org.springframework.http.ResponseEntity; import java.math.BigDecimal; import java.text.ParseException; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; @Java110Cmd(serviceCode = "fee.reportFeeCmd") public class ReportFeeCmd extends Cmd { @Autowired private IReportFeeInnerServiceSMO reportFeeInnerServiceSMOImpl; @Autowired private ICommunityInnerServiceSMO communityInnerServiceSMOImpl; @Autowired private IDictV1InnerServiceSMO dictV1InnerServiceSMOImpl; @Override public void validate(CmdEvent event, ICmdDataFlowContext context, JSONObject reqJson) throws CmdException, ParseException { Assert.hasKey(reqJson, "communityId", "请求报文中未包含小区编号"); } @Override public void doCmd(CmdEvent event, ICmdDataFlowContext context, JSONObject reqJson) throws CmdException, ParseException { int startYear = 2020; CommunityDto communityDto = new CommunityDto(); communityDto.setCommunityId(reqJson.getString("communityId")); List communityDtos = communityInnerServiceSMOImpl.queryCommunitys(communityDto); FeeQueryParams feeQueryParams = new FeeQueryParams(); feeQueryParams.setCommunityId(reqJson.getString("communityId")); feeQueryParams.setStartYear(startYear); int currentYear = java.time.Year.now().getValue(); feeQueryParams.setEndYear(currentYear + 2); int endYear = feeQueryParams.getEndYear(); List result = reportFeeInnerServiceSMOImpl.repostPaidInFee(feeQueryParams); DictDto dictDto = new DictDto(); dictDto.setTableName("pay_fee_config"); dictDto.setTableColumns("fee_type_cd"); List dictDtos = dictV1InnerServiceSMOImpl.queryDicts(dictDto); int doYear = endYear - startYear; List> reportFeeDtoLists = new ArrayList<>(); for (DictDto dictDto1 : dictDtos) {//类型 List reportFeeDtos = new ArrayList<>(); for (int i = startYear; i <= endYear; i++) { for (Map map : result) { FeeDto feeDto = new FeeDto(); if (map.get("统计周期")!=null&&map.get("统计周期").equals(i)&&map.get("费用类型编码").equals(dictDto1.getStatusCd())){ feeDto.setCurYear((i)+""); feeDto.setFeeTypeCdName(map.get("费用类型名称")+""); double[] doubles = new double[doYear]; for (int j = startYear ; j <= endYear ; j++) { if(map.get((j)+"年收费金额(元)")!=null){ doubles[j-startYear] = ((BigDecimal)map.get((j)+"年收费金额(元)")).doubleValue(); } } feeDto.setReport(doubles); reportFeeDtos.add(feeDto); } // if(startYear == currentYear){ // for (int x = 1 ; x <= 12 ; x++){ // feeDto = new FeeDto(); // feeDto.setCurYear(startYear+"/"+x); // feeDto.setFeeTypeCdName(dictDto1.getName()); // if(map.get(startYear + "年" + x + "月收费金额(元)")!=null){ // d // } // } // } } } reportFeeDtoLists.add(reportFeeDtos); } ResultVo resultVo = new ResultVo(reportFeeDtoLists); ResponseEntity responseEntity = new ResponseEntity(resultVo.toString(), HttpStatus.OK); context.setResponseEntity(responseEntity); } }