| | |
|---|
| | | 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; |
|---|
| | |
|---|
| | | @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>(); |
|---|
| | |
|---|
| | | LocChartPie locUseRate = reportQueryMapper.getLocUseRate(); |
|---|
| | | if(locUseRate!=null) { |
|---|
| | | ChartBean fqty = new ChartBean(); |
|---|
| | | fqty.setName("在库库位"); |
|---|
| | | fqty.setName("Основной термин"); |
|---|
| | | fqty.setY(locUseRate.getFqty()); |
|---|
| | | list.add(fqty); |
|---|
| | | |
|---|
| | | ChartBean oqty = new ChartBean(); |
|---|
| | | oqty.setName("空库位"); |
|---|
| | | oqty.setName("Пустые складские места"); |
|---|
| | | oqty.setY(locUseRate.getOqty()); |
|---|
| | | list.add(oqty); |
|---|
| | | |
|---|
| | | ChartBean uqty = new ChartBean(); |
|---|
| | | uqty.setName("使用库位"); |
|---|
| | | uqty.setName("Используемые складские места"); |
|---|
| | | uqty.setY(locUseRate.getUqty()); |
|---|
| | | list.add(uqty); |
|---|
| | | |
|---|
| | | ChartBean xqty = new ChartBean(); |
|---|
| | | xqty.setName("禁用库位"); |
|---|
| | | xqty.setName("Заблокированные складские места"); |
|---|
| | | xqty.setY(locUseRate.getXqty()); |
|---|
| | | list.add(xqty); |
|---|
| | | } |
|---|
| | |
|---|
| | | } |
|---|
| | | } |
|---|
| | | AxisBean inqty = new AxisBean(); |
|---|
| | | inqty.setName("入库数量"); |
|---|
| | | inqty.setName("Количество поступающих товаров"); |
|---|
| | | Integer[] array1 = new Integer[data1.size()]; |
|---|
| | | inqty.setData(data1.toArray(array1)); |
|---|
| | | list.add(inqty); |
|---|
| | | AxisBean outqty = new AxisBean(); |
|---|
| | | outqty.setName("出库数量"); |
|---|
| | | outqty.setName("Количество исходящих товаров"); |
|---|
| | | Integer[] array2 = new Integer[data2.size()]; |
|---|
| | | outqty.setData(data2.toArray(array2)); |
|---|
| | | list.add(outqty); |
|---|
