From 1a52289b4d1c7097a654610c132a91716655d3db Mon Sep 17 00:00:00 2001 From: lyfO_o <764716047@qq.com> Date: 星期五, 11 六月 2021 17:34:34 +0800 Subject: [PATCH] 试剂安全库存 --- src/main/java/com/nanometer/smartlab/email/EmailSendSchedule.java | 44 +++++++++++++++++++++++++++++++++----------- 1 files changed, 33 insertions(+), 11 deletions(-) diff --git a/src/main/java/com/nanometer/smartlab/email/EmailSendSchedule.java b/src/main/java/com/nanometer/smartlab/email/EmailSendSchedule.java index 25a3378..8c201c2 100644 --- a/src/main/java/com/nanometer/smartlab/email/EmailSendSchedule.java +++ b/src/main/java/com/nanometer/smartlab/email/EmailSendSchedule.java @@ -1,6 +1,7 @@ package com.nanometer.smartlab.email; import com.nanometer.smartlab.entity.EmailStatus; +import com.nanometer.smartlab.entity.OpeWarehouseReserve; import com.nanometer.smartlab.entity.SysReagent; import com.nanometer.smartlab.entity.enumtype.EmailSendStatus; import com.nanometer.smartlab.exception.BusinessException; @@ -25,6 +26,13 @@ private OpeOrderService opeOrderService; private static Logger logger = Logger.getLogger(EmailSendSchedule.class); + + @Resource + private SysReagentService sysReagentService; + @Resource + private OpeWarehouseReserveService opeWarehouseReserveService; + @Resource + private SysUserService userService; @Scheduled(fixedDelayString = "${emailSend.schedule.delay}") public void EmailSendSchedule(){ @@ -61,13 +69,23 @@ // @Scheduled(cron = "0/5 * * * * ?") //每隔5秒执行一次 - @Scheduled(cron = "0 0 8 * * ?") //每天8点执行一次 + @Scheduled(cron = "0 0/3 * * * ?") //每天8点执行一次 public void EmailSendStock(){ - List<String> revicerList = new ArrayList<>(); - + //收件人为人员角色为库管员的邮箱 + List<String> revicerList = userService.getLibrarianEmail(); + //先查试剂表 安全库存大于0,然后去查库存,实际库存小于安全库存的列表 List<SysReagent> sysReagentList = new ArrayList<>(); - - + //已经填写安全库存的试剂 + List<SysReagent> alreadyFillIn = sysReagentService.selectReagentSafetyNum(); + if (alreadyFillIn.size() > 0) { + for (SysReagent reagent : alreadyFillIn) { + int actualNum = opeWarehouseReserveService.countByReagentId(reagent.getId()); + if (reagent.getSafetynum() > actualNum) { + reagent.setActualnum(actualNum); + sysReagentList.add(reagent); + } + } + } StringBuffer content = new StringBuffer("<html><body>"); content.append("<div style=\"line-height:1.7;color:#000000;font-size:14px;font-family:Arial\">"); content.append("<table border=\"1\">"); @@ -89,20 +107,24 @@ content.append("<td>"+sysReagent.getName()+"</td>"); content.append("<td>"+sysReagent.getProductSn()+"</td>"); content.append("<td>"+sysReagent.getCas()+"</td>"); - content.append("<td>"+sysReagent.getReagentType()+"</td>"); + + content.append("<td>"+sysReagent.getReagentType()+"</td>");// content.append("<td>"+sysReagent.getSupplierName()+"</td>"); + content.append("<td>"+sysReagent.getProductHomeName()+"</td>"); - content.append("<td>"+sysReagent.getReagentFormat()+"</td>"); - content.append("<td>"+sysReagent.getReagentUnit()+"</td>"); - //content.append("<td>"+sysReagent+"</td>");安全库存 - //content.append("<td>"+sysReagent+"</td>");实际库存 + + content.append("<td>"+sysReagent.getReagentFormat()+"</td>");// + + content.append("<td>"+sysReagent.getReagentUnit()+"</td>");// + content.append("<td>"+sysReagent.getSafetynum()+"</td>"); + content.append("<td>"+sysReagent.getActualnum()+"</td>"); content.append("</tr>"); } content.append("</tbody></table></div>"); content.append("</body></html>"); try { - EmailSend.sendArrivalEmail(revicerList,content.toString()); +// EmailSend.sendArrivalEmail(revicerList,content.toString()); // 发送成功,更新邮件发送状态为:已发送 } catch (BusinessException e) { // 发送失败,更新邮件发送状态为:发送失败 -- Gitblit v1.9.2