ruoyi-quartz/src/main/java/com/ruoyi/quartz/task/RyTask.java
@@ -473,11 +473,11 @@ * 处理补偿任务 */ public void compensateTask() { //获取到sendstate=3 并且 visit_time为今天的subtask //获取到sendstate=3 并且 visit_time为小于等于今天的subtask ServiceSubtaskVO serviceSubtaskVO = new ServiceSubtaskVO(); serviceSubtaskVO.setSendstate(3L); serviceSubtaskVO.setVisitTime(new Date()); List<ServiceSubtask> serviceSubtaskList = serviceSubtaskMapper.selectServiceSubtaskList(serviceSubtaskVO); List<ServiceSubtask> serviceSubtaskList = serviceSubtaskMapper.getCompensateServiceSubtaskList(serviceSubtaskVO); for (ServiceSubtask serviceSubtask : serviceSubtaskList) { //根据当前的执行方式,获取下一种执行方式 ServiceSubtaskPreachform serviceSubtaskPreachform = new ServiceSubtaskPreachform(); @@ -748,11 +748,11 @@ serviceSubtask.setSendstate(3L); if (StringUtils.isNotEmpty(isSuccess) && isSuccess.equals("true")) { serviceSubtask.setResult("success"); serviceSubtask.setRemark("短信发送成功"); serviceSubtask.setRemark(serviceSubtask.getRemark() + "," + "短信发送成功"); setSuccessPreachForm(serviceSubtask, sendPreachform, "短信发送成功", "2"); } else { serviceSubtask.setResult("error"); serviceSubtask.setRemark("短信发送失败" + now); serviceSubtask.setRemark(serviceSubtask.getRemark() + "," +"短信发送失败" + now); setSuccessPreachForm(serviceSubtask, sendPreachform, "短信发送失败" + now, "5"); } } catch (Exception e) { smartor/src/main/java/com/smartor/mapper/ServiceSubtaskMapper.java
@@ -31,6 +31,13 @@ */ public List<ServiceSubtask> selectServiceSubtaskList(ServiceSubtaskVO serviceSubtaskVO); /** * 用于补偿查询 * @param serviceSubtaskVO * @return */ public List<ServiceSubtask> getCompensateServiceSubtaskList(ServiceSubtaskVO serviceSubtaskVO); public List<ServiceSubtask> selectServiceSubtaskByDiagname(ServiceSubtask serviceSubtask); public List<ServiceSubtask> queryServiceSubtaskList(ServiceSubtaskVO serviceSubtaskVO); smartor/src/main/resources/mapper/smartor/ServiceSubtaskMapper.xml
@@ -408,6 +408,19 @@ <!-- order by update_time desc,id desc --> </select> <select id="getCompensateServiceSubtaskList" parameterType="com.smartor.domain.ServiceSubtaskVO" resultMap="ServiceSubtaskResult"> <include refid="selectServiceSubtaskVo"/> <where> del_flag=0 <if test="visitTime != null"> AND date_format(visit_time,'%y%m%d') <= date_format(#{visitTime},'%y%m%d') </if> <if test="sendstate != null ">and sendstate = #{sendstate}</if> </where> </select> <select id="selectServiceSubtaskListByCreateTime" parameterType="com.smartor.domain.ServiceSubtaskVO" resultMap="ServiceSubtaskResult"> @@ -1951,7 +1964,8 @@ <if test="deptOrDistrict == 1"> <if test="leavehospitaldistrictcodes != null and leavehospitaldistrictcodes.size() > 0"> AND leavehospitaldistrictcode IN <foreach collection="leavehospitaldistrictcodes" item="leavehospitaldistrictcode" open="(" separator="," close=")"> <foreach collection="leavehospitaldistrictcodes" item="leavehospitaldistrictcode" open="(" separator="," close=")"> #{leavehospitaldistrictcode} </foreach> </if>