package com.zy.asrs.controller;
|
|
import com.alibaba.fastjson.JSON;
|
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 com.core.common.R;
|
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("/pie")
|
public R pieStats(){
|
// ViewStockUseBean bean = new ViewStockUseBean();
|
// bean.setPageSize(65535);
|
// bean.setPageNumber(1);
|
// List<ViewStockUseBean> list= reportQueryMapper.queryViewStockUseList(bean);
|
// PieChartsVo pieVo = new PieChartsVo();
|
// for (ViewStockUseBean one: list){
|
// // 总库位
|
// pieVo.setTotalQty(pieVo.getTotalQty() + one.getTotal_qty());
|
// // 在库
|
// pieVo.setFullQty(pieVo.getFullQty() + one.getFull_qty());
|
// // 空闲
|
// pieVo.setNullQty(pieVo.getNullQty() + one.getNull_qty());
|
// // 禁用
|
// pieVo.setForbidQty(pieVo.getForbidQty() + one.getForbid_qty());
|
// // 使用 = 总 - 在库 - 空闲 - 禁用
|
// pieVo.setOccQty(pieVo.getOccQty()+(one.getTotal_qty()-one.getFull_qty()-one.getNull_qty()-one.getForbid_qty()));
|
// }
|
// pieVo.complete();
|
// System.out.println(JSON.toJSONString(pieVo));
|
// return R.ok(pieVo);
|
String s = "{\"forbidDes\":\"禁用库位0.1%\",\"forbidQty\":2,\"fullDes\":\"在库库位44.4%\",\"fullQty\":1061,\"nullDes\":\"空库位47.2%\",\"nullQty\":1128,\"occDes\":\"使用库位8.4%\",\"occQty\":201,\"totalDes\":\"\",\"totalQty\":2392}\n";
|
return R.ok(JSON.parse(s));
|
}
|
|
@PostMapping("loc/pie/charts")
|
public R dsa(){
|
Map<String,Object> map=new HashMap<String, Object>();
|
List<ChartBean> list = new ArrayList<ChartBean>();
|
|
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<String,Object> map=new HashMap<String, Object>();
|
List<AxisBean> list = new ArrayList<AxisBean>();
|
|
List<WorkChartAxis> listChart = reportQueryMapper.getChartAxis();
|
|
if(listChart!=null) {
|
ArrayList<Integer> data1 = new ArrayList<Integer>();
|
ArrayList<Integer> data2 = new ArrayList<Integer>();
|
|
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);
|
}
|
|
|
|
|
}
|
