#

zjj

2023-11-10 cffbaec750882dd7f4d112d7c735d247e2a961a7

 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,38 +24,69 @@
    @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();
        List<ChartBean> lists = lists(locUseRate);
        map.put("rows",lists);
        return R.ok(map);
    }
    @PostMapping("loc/pieA/charts")
    public R dsaA(){
        Map<String,Object> map=new HashMap<String, Object>();


        LocChartPie locUseRate = reportQueryMapper.getLocUseRateA();
        List<ChartBean> lists = lists(locUseRate);
        map.put("rows",lists);
        return R.ok(map);
    }
    @PostMapping("loc/pieB/charts")
    public R dsaB(){
        Map<String,Object> map=new HashMap<String, Object>();


        LocChartPie locUseRate = reportQueryMapper.getLocUseRateB();
        List<ChartBean> lists = lists(locUseRate);
        map.put("rows",lists);
        return R.ok(map);
    }
    @PostMapping("loc/pieC/charts")
    public R dsaC(){
        Map<String,Object> map=new HashMap<String, Object>();


        LocChartPie locUseRate = reportQueryMapper.getLocUseRateC();
        List<ChartBean> lists = lists(locUseRate);
        map.put("rows",lists);
        return R.ok(map);
    }
    @PostMapping("loc/pieD/charts")
    public R dsaD(){
        Map<String,Object> map=new HashMap<String, Object>();


        LocChartPie locUseRate = reportQueryMapper.getLocUseRateD();
        List<ChartBean> lists = lists(locUseRate);
        map.put("rows",lists);
        return R.ok(map);
    }
    @PostMapping("loc/pieE/charts")
    public R dsaE(){
        Map<String,Object> map=new HashMap<String, Object>();


        LocChartPie locUseRate = reportQueryMapper.getLocUseRateE();
        List<ChartBean> lists = lists(locUseRate);
        map.put("rows",lists);
        return R.ok(map);
    }

    public List<ChartBean> lists(LocChartPie locUseRate){
        List<ChartBean>  list = new ArrayList<ChartBean>();
        if(locUseRate!=null) {
            ChartBean fqty = new ChartBean();
            fqty.setName("在库库位");
@@ -68,20 +98,23 @@
            oqty.setY(locUseRate.getOqty());
            list.add(oqty);

            ChartBean uqty = new ChartBean();
            uqty.setName("使用库位");
            uqty.setY(locUseRate.getUqty());
            list.add(uqty);
//            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);
        }else {
            return null;
        }
        map.put("rows",list);
        return R.ok(map);
        return list;
    }



    @PostMapping("locIo/line/charts")
    public R locIoLineCharts(){
        Map<String,Object> map=new HashMap<String, Object>();