package com.zy.asrs.controller; import com.core.common.R; import com.zy.asrs.entity.AxisBean; import com.zy.asrs.entity.ChartBean; import com.zy.asrs.entity.LocChartPie; import com.zy.asrs.entity.WorkChartAxis; import com.zy.asrs.mapper.ReportQueryMapper; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import java.text.SimpleDateFormat; import java.util.*; /** * Created by vincent on 2020-05-23 */ @RestController @RequestMapping("/console") public class ConsoleController { @Autowired private ReportQueryMapper reportQueryMapper; @PostMapping("loc/pie/charts") public R dsa(){ Map map=new HashMap(); List list = new ArrayList(); LocChartPie locUseRate = reportQueryMapper.getLocUseRate(); if(locUseRate!=null) { ChartBean fqty = new ChartBean(); fqty.setName("在库库位"); fqty.setY(locUseRate.getFqty()); list.add(fqty); ChartBean oqty = new ChartBean(); oqty.setName("空库位"); oqty.setY(locUseRate.getOqty()); list.add(oqty); ChartBean uqty = new ChartBean(); uqty.setName("使用库位"); uqty.setY(locUseRate.getUqty()); list.add(uqty); ChartBean xqty = new ChartBean(); xqty.setName("禁用库位"); xqty.setY(locUseRate.getXqty()); list.add(xqty); } map.put("rows",list); return R.ok(map); } @PostMapping("locIo/line/charts") public R locIoLineCharts(){ Map map=new HashMap(); List list = new ArrayList(); List listChart = reportQueryMapper.getChartAxis(); if(listChart!=null) { ArrayList data1 = new ArrayList(); ArrayList data2 = new ArrayList(); SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd"); Calendar calendar = Calendar.getInstance(); calendar.add(Calendar.DATE, -12); for(int i=0;i<12;i++) { boolean flag = true; calendar.add(Calendar.DATE, 1); String str = sf.format(calendar.getTime()); for(WorkChartAxis workChart : listChart) { if(str.equals(workChart.getYmd())) { data1.add(workChart.getInqty()); data2.add(workChart.getOutqty()); flag = false; break; } } if(flag) { data1.add(0); data2.add(0); } } AxisBean inqty = new AxisBean(); inqty.setName("入库数量"); Integer[] array1 = new Integer[data1.size()]; inqty.setData(data1.toArray(array1)); list.add(inqty); AxisBean outqty = new AxisBean(); outqty.setName("出库数量"); Integer[] array2 = new Integer[data2.size()]; outqty.setData(data2.toArray(array2)); list.add(outqty); } map.put("rows",list); return R.ok(map); } }