| | |
| | | |
| | | @GetMapping(value = "/locDetl/pda/statisticalModel") |
| | | public R statisticalModel() { |
| | | //仓库数据 |
| | | EntityWrapper<LocDetl> locDetlEntityWrapper = new EntityWrapper<>(); |
| | | locDetlEntityWrapper.setSqlSelect("model,COUNT(*) as modelCount").groupBy("model"); |
| | | List<Map<String, Object>> selectMap = locDetlService.selectMaps(locDetlEntityWrapper); |
| | | locDetlEntityWrapper.setSqlSelect("matnr,count(*)as matnrCount").groupBy("matnr"); |
| | | List<Map<String, Object>> selectMap = locDetlService.selectMaps(locDetlEntityWrapper); |
| | | return R.ok(selectMap); |
| | | } |
| | | |