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