package com.dingzhuo.energy.project.reportForm.controller; import com.dingzhuo.energy.framework.web.controller.BaseController; import com.dingzhuo.energy.framework.web.domain.AjaxResult; import com.dingzhuo.energy.project.reportForm.domain.reportForm; import com.dingzhuo.energy.project.reportForm.service.IreportFormService; import org.apache.commons.lang3.StringUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import java.util.stream.Collectors; /** * 报表 * @author sys * @date 2020-03-25 */ @RestController @RequestMapping("/reportForm") class reportFormController extends BaseController { @Autowired private IreportFormService reportFormService; /** * 报表查询 */ @PreAuthorize("@ss.hasPermi('dailyReport:list')") @GetMapping("/list") public AjaxResult list(reportForm report) { List list= reportFormService.selectReportFormList(report.getCode());//根据父级查询二级数据 List resultList= reportFormService.selectReportFormListp(report.getCode());//根据二级查询三级数据 List result= reportFormService.selectList(report.getTimeDate(),report.getCode(),report.getTimeYear(),report.getTimeType());//查询三级 List table = new ArrayList(); List tables = new ArrayList(); resultList.forEach(value->{ list.forEach(item->{ if(item.getParentId().equals(value.getNodeId())){ Map map=new HashMap(); map.put("parentName",value.getName()); map.put("name",item.getName()); map.put("nodeId",item.getNodeId()); table.add(map); } }); }); Map> groupBy = result.stream().filter(item-> StringUtils.isNotBlank(item.getNodeId())).collect(Collectors.groupingBy(reportForm::getNodeId)); groupBy.forEach((indexName,value)->{ for (Map item : table) { //Map map=new HashMap(); reportForm map=new reportForm(); if(item.get("nodeId").equals(indexName)){ for(reportForm resultValue:value){ if(report.getTimeYear().equals(resultValue.getTimeYear())){ //map.put("value13",resultValue.getValue()); map.setValue13(resultValue.getValue()); }else if(resultValue.getTimeDate().equals("01")){ //map.put("value1",resultValue.getValue()); map.setValue1(resultValue.getValue()); }else if(resultValue.getTimeDate().equals("02")){ //map.put("value2",resultValue.getValue()); map.setValue2(resultValue.getValue()); }else if(resultValue.getTimeDate().equals("03")){ //map.put("value3",resultValue.getValue()); map.setValue3(resultValue.getValue()); }else if(resultValue.getTimeDate().equals("04")){ //map.put("value4",resultValue.getValue()); map.setValue4(resultValue.getValue()); }else if(resultValue.getTimeDate().equals("05")){ //map.put("value5",resultValue.getValue()); map.setValue5(resultValue.getValue()); }else if(resultValue.getTimeDate().equals("06")){ //map.put("value6",resultValue.getValue()); map.setValue6(resultValue.getValue()); }else if(resultValue.getTimeDate().equals("07")){ //map.put("value7",resultValue.getValue()); map.setValue7(resultValue.getValue()); }else if(resultValue.getTimeDate().equals("08")){ //map.put("value8",resultValue.getValue()); map.setValue8(resultValue.getValue()); }else if(resultValue.getTimeDate().equals("09")){ //map.put("value9",resultValue.getValue()); map.setValue9(resultValue.getValue()); }else if(resultValue.getTimeDate().equals("10")){ //map.put("value10",resultValue.getValue()); map.setValue10(resultValue.getValue()); }else if(resultValue.getTimeDate().equals("11")){ //map.put("value11",resultValue.getValue()); map.setValue11(resultValue.getValue()); }else { //map.put("value12",resultValue.getValue()); map.setValue12(resultValue.getValue()); } } //map.put("parentName",item.get("parentName")); //map.put("name",item.get("name")); map.setParentName((String) item.get("parentName")); map.setName((String) item.get("name")); tables.add(map); } } }); return AjaxResult.success(tables); } }