#优化

lsh

2024-08-21 f72b0dc0ae80fee81a7a678deb0e3d97f89a0e1b

 src/main/java/com/zy/asrs/controller/ConsoleController.java

@@ -1,12 +1,11 @@
package com.zy.asrs.controller;

import com.alibaba.fastjson.JSON;
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 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;
@@ -25,32 +24,6 @@
    @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>();
@@ -58,15 +31,45 @@

        LocChartPie locUseRate = reportQueryMapper.getLocUseRate();
        if(locUseRate!=null) {
            ChartBean fqty = new ChartBean();
            fqty.setName("在库库位");
            fqty.setY(locUseRate.getFqty());
            list.add(fqty);
//            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 fqty1 = new ChartBean();
            fqty1.setName("单品在库"+locUseRate.getFqty1());
            fqty1.setY(locUseRate.getFqty1());
            list.add(fqty1);

            ChartBean fqty2 = new ChartBean();
            fqty2.setName("高频在库"+locUseRate.getFqty2());
            fqty2.setY(locUseRate.getFqty2());
            list.add(fqty2);

            ChartBean fqty3 = new ChartBean();
            fqty3.setName("低频在库"+locUseRate.getFqty3());
            fqty3.setY(locUseRate.getFqty3());
            list.add(fqty3);

//            ChartBean oqty = new ChartBean();
//            oqty.setName("空库位");
//            oqty.setY(locUseRate.getOqty());
//            list.add(oqty);

            ChartBean oqty1 = new ChartBean();
            oqty1.setName("单品空库位"+locUseRate.getOqty1());
            oqty1.setY(locUseRate.getOqty1());
            list.add(oqty1);

            ChartBean oqty2 = new ChartBean();
            oqty2.setName("高频空库位"+locUseRate.getOqty2());
            oqty2.setY(locUseRate.getOqty2());
            list.add(oqty2);

            ChartBean oqty3 = new ChartBean();
            oqty3.setName("低频空库位"+locUseRate.getOqty3());
            oqty3.setY(locUseRate.getOqty3());
            list.add(oqty3);

            ChartBean uqty = new ChartBean();
            uqty.setName("使用库位");