| | |
| | | @Autowired |
| | | private LocDetlService locDetlService; |
| | | |
| | | @Scheduled(cron = "0/2 * * * * ? ") |
| | | // @Scheduled(cron = "0/2 * * * * ? ") |
| | | private void send() { |
| | | |
| | | //饼图 |
| | |
| | | } |
| | | //仓库数据 |
| | | EntityWrapper<LocDetl> locDetlEntityWrapper = new EntityWrapper<>(); |
| | | locDetlEntityWrapper.setSqlSelect("matnr,COUNT(*) as matnrCount").groupBy("matnr"); |
| | | locDetlEntityWrapper.setSqlSelect("TOP 5 matnr,SUM(anfme) as matnrCount").groupBy("matnr").orderBy("matnrCount",false); |
| | | List<Map<String, Object>> selectMap = locDetlService.selectMaps(locDetlEntityWrapper); |
| | | |
| | | Date now = new Date(); |