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.FeeDetailDto; import com.java110.dto.fee.FeeDto; import com.java110.dto.report.ReportExcelDto; import com.java110.dto.report.ReportQueryRecord; import com.java110.fee.smo.impl.FeeDetailInnerServiceSMOImpl; import com.java110.intf.community.ICommunityInnerServiceSMO; import com.java110.intf.dev.IDictV1InnerServiceSMO; import com.java110.intf.fee.IReportFeeInnerServiceSMO; import com.java110.utils.exception.CmdException; import com.java110.utils.util.Assert; import com.java110.utils.util.BeanConvertUtil; 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.LinkedList; import java.util.List; import java.util.Map; @Java110Cmd(serviceCode = "fee.whiteOrderReportFeeCmd") public class ReportFeeWriteOrderCmd extends Cmd { @Autowired private IReportFeeInnerServiceSMO reportFeeInnerServiceSMOImpl; @Autowired private ICommunityInnerServiceSMO communityInnerServiceSMOImpl; @Autowired private IDictV1InnerServiceSMO dictV1InnerServiceSMOImpl; @Autowired private FeeDetailInnerServiceSMOImpl feeDetailInnerServiceSMOImpl; @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 { FeeQueryParams feeQueryParams = new FeeQueryParams(); feeQueryParams.setCommunityId(reqJson.getString("communityId")); feeQueryParams.setRow(reqJson.containsKey("row") ? Integer.valueOf(reqJson.getString("row")) : 20); feeQueryParams.setPage(reqJson.containsKey("page")? Integer.valueOf(reqJson.get("page").toString()) :1); feeQueryParams.setPage(feeQueryParams.getPage() * feeQueryParams.getRow() - feeQueryParams.getRow()); List result = reportFeeInnerServiceSMOImpl.repostPaidInFeeByWhiteOrder(feeQueryParams); String[][] reportList = new String[feeQueryParams.getRow()!=null?feeQueryParams.getRow():100][]; if (!result.get(0).get("count").toString().equals("0")) { for (int i = 0; i < result.size(); i++) { Map map = result.get(i); String[] strings = new String[29]; for (int j = 1; j <= 27; j++) { if(map.containsKey("row"+j)){ strings[j-1] = map.get("row"+j).toString(); } } reportList[i] = strings; } } FeeDetailDto feeDetailDto = new FeeDetailDto(); feeDetailDto.setCommunityId(reqJson.getString("communityId")); int c = feeDetailInnerServiceSMOImpl.queryFeeDetailsCount(feeDetailDto); ResultVo resultVo = new ResultVo(reportList); resultVo.setTotal(Integer.parseInt(result.get(0).get("count").toString())); resultVo.setRecords((int) (resultVo.getTotal() / feeQueryParams.getRow())); // resultVo.setTotal(count); ResponseEntity responseEntity = new ResponseEntity(resultVo.toString(), HttpStatus.OK); context.setResponseEntity(responseEntity); // } } }