| | |
| | | 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(){ |