src/main/java/com/zy/asrs/task/MatScheduler.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
src/main/java/com/zy/asrs/task/handler/MatHandler.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
src/main/resources/mapper/LocMastMapper.xml | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
src/main/java/com/zy/asrs/task/MatScheduler.java
@@ -20,6 +20,7 @@ @Autowired private MatHandler matHandler; // @Scheduled(cron = "0/3 * * * * ? ") @Scheduled(cron = "0 0 23 * * ? ") private void execute(){ ReturnT<String> returnT = matHandler.start(); src/main/java/com/zy/asrs/task/handler/MatHandler.java
@@ -1,5 +1,6 @@ package com.zy.asrs.task.handler; import com.core.common.Cools; import com.zy.asrs.entity.Mat; import com.zy.asrs.entity.dto.MatnrCountDto; import com.zy.asrs.service.MatService; @@ -38,7 +39,7 @@ public ReturnT<String> start() { try { Date now = new Date(); List<MatnrCountDto> matnrCountDtos = jdbcTemplate.queryForList("select\n" + List<Map<String, Object>> list = jdbcTemplate.queryForList("select\n" + "matnr,\n" + "count(1) as count\n" + "from (\n" + @@ -51,8 +52,10 @@ "\tand io_type not in (103,104,107)\n" + "\tand (manu_type is null or manu_type != '手动取消')\n" + ") a\n" + "group by matnr", MatnrCountDto.class); for (MatnrCountDto dto : matnrCountDtos) { "group by matnr"); if (!Cools.isEmpty(list)) { for (Map<String, Object> map : list) { MatnrCountDto dto = Cools.conver(map, MatnrCountDto.class); if (dto.getCount() >= 3) { Mat mat = matService.selectByMatnr(dto.getMatnr()); mat.setInoutEveryday(Boolean.TRUE); @@ -62,6 +65,7 @@ } } } } } catch (Exception e) { e.printStackTrace(); TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); src/main/resources/mapper/LocMastMapper.xml
@@ -107,10 +107,10 @@ </if> <choose> <when test="inoutEveryday != null and inoutEveryday"> AND bay1 < 11 AND bay1 < 11 and lev1 in (2,3,4) </when> <otherwise> AND bay1 > 10 AND (bay1 >= 11 or (bay1 < 11 and lev1 in (1))) </otherwise> </choose> and loc_no not in ('0100101', '0200101', '0300101', '1200701', '1300701', '1400701', '1900401', '2000401', '2100401')