|  |  | 
 |  |  | package com.doumee.service.business.impl; | 
 |  |  |  | 
 |  |  | import com.alibaba.fastjson.JSON; | 
 |  |  | import com.alibaba.fastjson.JSONObject; | 
 |  |  | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; | 
 |  |  | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; | 
 |  |  | import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; | 
 |  |  | import com.baomidou.mybatisplus.core.metadata.IPage; | 
 |  |  | 
 |  |  | import com.doumee.biz.system.SystemDictDataBiz; | 
 |  |  | import com.doumee.core.constants.ResponseStatus; | 
 |  |  | import com.doumee.core.exception.BusinessException; | 
 |  |  | import com.doumee.core.haikang.model.HKConstants; | 
 |  |  | import com.doumee.core.haikang.model.param.BaseResponse; | 
 |  |  | import com.doumee.core.haikang.service.HKService; | 
 |  |  | import com.doumee.core.model.PageData; | 
 |  |  | import com.doumee.core.model.PageWrap; | 
 |  |  | import com.doumee.core.utils.*; | 
 |  |  | import com.doumee.dao.business.*; | 
 |  |  | import com.doumee.dao.business.dao.SmsConfigMapper; | 
 |  |  | import com.doumee.dao.business.dao.SmsEmailMapper; | 
 |  |  | import com.doumee.dao.business.join.VisitsJoinMapper; | 
 |  |  | import com.doumee.dao.business.model.*; | 
 |  |  | import com.doumee.dao.business.model.vo.ValidPhoneCodeVO; | 
 |  |  | import com.doumee.dao.system.model.SystemUser; | 
 |  |  | import com.doumee.service.business.SmsEmailService; | 
 |  |  | import com.doumee.service.business.third.EmayService; | 
 |  |  | import com.github.yulichang.wrapper.MPJLambdaWrapper; | 
 |  |  | import org.apache.commons.lang3.StringUtils; | 
 |  |  | import org.springframework.beans.factory.annotation.Autowired; | 
 |  |  | import org.springframework.beans.factory.annotation.Value; | 
 |  |  | 
 |  |  | import org.springframework.stereotype.Service; | 
 |  |  | import org.springframework.util.CollectionUtils; | 
 |  |  |  | 
 |  |  | import java.net.URLEncoder; | 
 |  |  | import java.util.*; | 
 |  |  | import java.util.Date; | 
 |  |  |  | 
 |  |  | 
 |  |  |     @Autowired | 
 |  |  |     @Lazy | 
 |  |  |     private EmayService emayService; | 
 |  |  |     @Autowired | 
 |  |  |     private SmsConfigMapper smsConfigMapper; | 
 |  |  |  | 
 |  |  |     @Value("${debug_model}") | 
 |  |  |     private boolean debugModel; | 
 |  |  | 
 |  |  |  | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     public     void validPhoneCaptcha(ValidPhoneCodeVO param){ | 
 |  |  |        isCaptcheValide(smsEmailMapper,param.getPhone(),param.getCode()); | 
 |  |  |     } | 
 |  |  |     @Override | 
 |  |  |     public Integer create(SmsEmail smsEmail) { | 
 |  |  |         smsEmailMapper.insert(smsEmail); | 
 |  |  |         return smsEmail.getId(); | 
 |  |  | 
 |  |  |         )>=3){ | 
 |  |  |             throw  new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"对不起,超出发送次数,请稍后重试!"); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         String code = Constants.getRandom6Num(); | 
 |  |  |  | 
 |  |  |         String content = systemDictDataBiz.queryByCode(Constants.SMS,Constants.SMS_COMNAME).getCode()+"验证码为:"+code+",此验证码有效为3分钟。请勿泄露"; | 
 |  |  |  | 
 |  |  | //        boolean result=   emayService.sendSingleSms(smsEmail.getPhone(),content); | 
 |  |  |         emayService.sendSmsByHk(smsEmail.getPhone(),content); | 
 |  |  | //        if(!result){ | 
 |  |  | //            throw  new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"对不起,短信验证码发送失败,请稍后重试!"); | 
 |  |  | //        } | 
 |  |  |  | 
 |  |  |         smsEmail.setRemark(code); | 
 |  |  |         smsEmail.setIsdeleted(Constants.ZERO); | 
 |  |  |         smsEmail.setCreateDate(new Date()); | 
 |  |  |         smsEmail.setStatus(Constants.ZERO); | 
 |  |  |         smsEmail.setType(Constants.ZERO); | 
 |  |  |         smsEmail.setTitle("短信验证码"); | 
 |  |  |         smsEmail.setContent(content); | 
 |  |  |         smsEmail.setObjType(Constants.ZERO+""); | 
 |  |  |         smsEmailMapper.insert(smsEmail); | 
 |  |  |  | 
 |  |  |         return smsEmail.getId(); | 
 |  |  |         SmsConfig smsConfig = smsConfigMapper.selectOne(new QueryWrapper<SmsConfig>().lambda().eq(SmsConfig::getObjType, | 
 |  |  |                 SmsConstants.inventCode).last(" limit 1 ")); | 
 |  |  |         //开启短信通知 | 
 |  |  |         if(Objects.nonNull(smsConfig) || Constants.equalsInteger(smsConfig.getStatus(),Constants.ZERO)){ | 
 |  |  |             if(StringUtils.isNotBlank(smsConfig.getContent())){ | 
 |  |  |                 String content  = smsConfig.getContent().replace("{验证码}",code); | 
 |  |  |                 emayService.sendSmsByHk(smsEmail.getPhone(),content); | 
 |  |  |                 smsEmail.setRemark(code); | 
 |  |  |                 smsEmail.setIsdeleted(Constants.ZERO); | 
 |  |  |                 smsEmail.setCreateDate(new Date()); | 
 |  |  |                 smsEmail.setStatus(Constants.ZERO); | 
 |  |  |                 smsEmail.setType(Constants.ZERO); | 
 |  |  |                 smsEmail.setTitle("短信验证码"); | 
 |  |  |                 smsEmail.setContent(content); | 
 |  |  |                 smsEmail.setObjType(Constants.ZERO+""); | 
 |  |  |                 smsEmailMapper.insert(smsEmail); | 
 |  |  |                 return smsEmail.getId(); | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |         return null; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |  | 
 |  |  | 
 |  |  |         QueryWrapper<SmsEmail> wrapper = new QueryWrapper<>(smsEmail); | 
 |  |  |         return smsEmailMapper.selectCount(wrapper); | 
 |  |  |     } | 
 |  |  |     @Override | 
 |  |  |     public void sendWaitingSmsNotice(){ | 
 |  |  |         LambdaQueryWrapper<SmsEmail> wrapper = new LambdaQueryWrapper<SmsEmail>() | 
 |  |  |                 .eq(SmsEmail::getIsdeleted,Constants.ZERO) | 
 |  |  |                 .eq(SmsEmail::getStatus,Constants.TWO); | 
 |  |  |         List<SmsEmail> smsEmails = smsEmailMapper.selectList(wrapper); | 
 |  |  |         if(smsEmails!=null && smsEmails.size()>0){ | 
 |  |  |             for(SmsEmail model : smsEmails){ | 
 |  |  |                 if(model.getPhone() == null){ | 
 |  |  |                     model.setStatus(Constants.THREE);//发送失败 | 
 |  |  |                     model.setRemark("手机号为空,取消任务发送!"); | 
 |  |  |                 }else{ | 
 |  |  |                     try { | 
 |  |  |                         emayService.sendSmsByHk(model.getPhone(),model.getContent()); | 
 |  |  |                         model.setStatus(Constants.ONE);//发送成功 | 
 |  |  |                         model.setRemark("短信任务发送成功"); | 
 |  |  |                     }catch (Exception e){ | 
 |  |  |                         model.setStatus(Constants.THREE);//发送失败 | 
 |  |  |                         model.setRemark("短信任务发送失败!"+e.getMessage()); | 
 |  |  |                     } | 
 |  |  |                 } | 
 |  |  |                 model.setEditDate(new Date()); | 
 |  |  |                 smsEmailMapper.updateById(model); | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 访客申请业务短信通知 | 
 |  |  | 
 |  |  |      * @param auditUser | 
 |  |  |      */ | 
 |  |  |     public static void sendVisitSms(SystemDictDataBiz systemDictDataBiz, EmayService emayService , com.doumee.dao.business.dao.SmsEmailMapper smsEmailMapper , SmsConfigMapper smsConfigMapper, | 
 |  |  |                                     VisitsMapper visitsMapper, Integer objId, String objCode, String msg, List<String> auditUser){ | 
 |  |  |                                     VisitsJoinMapper visitsMapper, Integer objId, String objCode, String msg, List<String> auditUser){ | 
 |  |  |         try{ | 
 |  |  |             SmsConfig smsConfig = smsConfigMapper.selectOne(new QueryWrapper<SmsConfig>().lambda().eq(SmsConfig::getCode, | 
 |  |  |                     objCode).last(" limit 1 ")); | 
 |  |  |             //开启短信通知 | 
 |  |  |             if(Objects.nonNull(smsConfig) || Constants.equalsInteger(smsConfig.getStatus(),Constants.ZERO)){ | 
 |  |  |                 String content = systemDictDataBiz.queryByCode(Constants.SMS,Constants.SMS_COMNAME).getCode() + smsConfig.getContent(); | 
 |  |  |                 Visits visits = visitsMapper.selectById(objId); | 
 |  |  |                 Visits visits = visitsMapper.selectJoinOne(Visits.class,new MPJLambdaWrapper<Visits>().selectAll(Visits.class) | 
 |  |  |                                 .selectAs(SystemUser::getMobile,Visits::getReceptMemberMobile) | 
 |  |  |                         .leftJoin(SystemUser.class,SystemUser::getMemberId, Visits::getReceptMemberId) | 
 |  |  |                         .eq(Visits::getId,objId).last(" limit 1 ")); | 
 |  |  |                 if(Objects.nonNull(visits)){ | 
 |  |  |                     if(objCode.equals(SmsConstants.visitContent.visitAuditSuccess)){ | 
 |  |  |                         //您的【访客申请】已经审批通过,请于{预约入园开始时间}前往门卫室访客机签到入园,如有疑问,请联系被访人 | 
 |  |  |                         //您的[访客申请]已经审批通过,请通知访客于{预约入园开始时间}入园,如有疑问,请联系被访人。 | 
 |  |  |                         content = content.replace("{预约入园开始时间}",DateUtil.getFomartDate(visits.getStarttime(),"yyyy-MM-dd HH:mm")); | 
 |  |  |                         sendBusinessSms(emayService,smsEmailMapper, | 
 |  |  |                                 Arrays.asList(visits.getPhone().split(",")),SmsConstants.visit,content,visits.getId()); | 
 |  |  | 
 |  |  |                         content = content.replace("{未签离数量}",msg); | 
 |  |  |                         sendBusinessSms(emayService,smsEmailMapper, | 
 |  |  |                                 Arrays.asList(visits.getPhone().split(",")),SmsConstants.visit,content,visits.getId()); | 
 |  |  |                     }else if(objCode.equals(SmsConstants.visitContent.visitAuditSuccessToVisiter))  { | 
 |  |  |                         content = content.replace("{预约入园开始时间}",DateUtil.getFomartDate(visits.getStarttime(),"yyyy-MM-dd HH:mm")); | 
 |  |  |                         sendBusinessSms(emayService,smsEmailMapper, | 
 |  |  |                                 Arrays.asList(visits.getReceptMemberMobile().split(",")),SmsConstants.visit,content,visits.getId()); | 
 |  |  |                     }else{ | 
 |  |  |                         //您有一条【车辆入园申请】需要处理,详细信息请前往微信公众号查看。 | 
 |  |  |                         sendBusinessSms(emayService,smsEmailMapper, | 
 |  |  | 
 |  |  |      * @param auditUser | 
 |  |  |      */ | 
 |  |  |     public static void sendVisitReportSms(SystemDictDataBiz systemDictDataBiz, EmayService emayService , com.doumee.dao.business.dao.SmsEmailMapper smsEmailMapper , SmsConfigMapper smsConfigMapper, | 
 |  |  |                                           VisitsMapper visitsMapper, Integer objId, String objCode, String msg, List<String> auditUser){ | 
 |  |  |                                           VisitsJoinMapper visitsMapper, Integer objId, String objCode, String msg, List<String> auditUser){ | 
 |  |  |         try{ | 
 |  |  |             SmsConfig smsConfig = smsConfigMapper.selectOne(new QueryWrapper<SmsConfig>().lambda().eq(SmsConfig::getCode, | 
 |  |  |                     objCode).last(" limit 1 ")); | 
 |  |  |             //开启短信通知 | 
 |  |  |             if(Objects.nonNull(smsConfig) || Constants.equalsInteger(smsConfig.getStatus(),Constants.ZERO)){ | 
 |  |  |                 String content = systemDictDataBiz.queryByCode(Constants.SMS,Constants.SMS_COMNAME).getCode() + smsConfig.getContent(); | 
 |  |  |                 Visits visits = visitsMapper.selectById(objId); | 
 |  |  |                 Visits visits = visitsMapper.selectJoinOne(Visits.class,new MPJLambdaWrapper<Visits>().selectAll(Visits.class) | 
 |  |  |                         .selectAs(SystemUser::getMobile,Visits::getCreateMobile) | 
 |  |  |                         .leftJoin(SystemUser.class,SystemUser::getMemberId,Visits::getMemberId) | 
 |  |  |                         .eq(Visits::getId,objId) | 
 |  |  |                         .last(" limit   1") | 
 |  |  |                 ); | 
 |  |  |                 if(Objects.nonNull(visits)){ | 
 |  |  |                     if(objCode.equals(SmsConstants.visitReportingContent.visitReportingAuditSuccess)){ | 
 |  |  |                         // 您的【访客报备】已经审批通过,请通知访客于{预约入园开始时间}后乘坐{车牌号}入园,如有疑问,请联系被访人。 | 
 |  |  |                         content = content.replace("{预约入园开始时间}",DateUtil.getFomartDate(visits.getStarttime(),"yyyy-MM-dd HH:mm")) | 
 |  |  |                                 .replace("{车牌号}",visits.getCarNos()); | 
 |  |  |                         sendBusinessSms(emayService,smsEmailMapper, | 
 |  |  |                                 Arrays.asList(visits.getPhone().split(",")),SmsConstants.visitReport,content,visits.getId()); | 
 |  |  |                                 Arrays.asList(visits.getCreateMobile().split(",")),SmsConstants.visitReport,content,visits.getId()); | 
 |  |  |                     }else if(objCode.equals(SmsConstants.visitReportingContent.visitReportingAuditFail)){ | 
 |  |  |                         //您的【访客报备】已被驳回,驳回原因为:{驳回原因}。如有疑问,请联系审批人。 | 
 |  |  |                         content = content.replace("{驳回原因}",msg); | 
 |  |  |                         sendBusinessSms(emayService,smsEmailMapper, | 
 |  |  |                                 Arrays.asList(visits.getPhone().split(",")),SmsConstants.visitReport,content,visits.getId()); | 
 |  |  |                                 Arrays.asList(visits.getCreateMobile().split(",")),SmsConstants.visitReport,content,visits.getId()); | 
 |  |  |                     }else if(objCode.equals(SmsConstants.visitReportingContent.visitReportingTimeOutSignOut)){ | 
 |  |  |                         //您的【访客报备】已于{预约入园结束时间}到期,请及时离场,如有疑问,请联系被访人 | 
 |  |  |                         content = content.replace("{预约入园结束时间}",DateUtil.getFomartDate(visits.getEndtime(),"yyyy-MM-dd HH:mm")); | 
 |  |  | 
 |  |  |                         sendBusinessSms(emayService,smsEmailMapper, | 
 |  |  |                                 auditUser,SmsConstants.platformBook,content,visits.getId()); | 
 |  |  |                     } | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |         }catch (Exception e){ | 
 |  |  |             e.printStackTrace(); | 
 |  |  |         } | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     public static void sendVisitReportTimeOutSms(SystemDictDataBiz systemDictDataBiz, EmayService emayService , com.doumee.dao.business.dao.SmsEmailMapper smsEmailMapper , | 
 |  |  |                                                  SmsConfigMapper smsConfigMapper, | 
 |  |  |                                            String objCode, String msg,List<String> mobiles){ | 
 |  |  |         try{ | 
 |  |  |             SmsConfig smsConfig = smsConfigMapper.selectOne(new QueryWrapper<SmsConfig>().lambda().eq(SmsConfig::getCode, | 
 |  |  |                     objCode).last(" limit 1 ")); | 
 |  |  |             //开启短信通知 | 
 |  |  |             if(Objects.nonNull(smsConfig) || Constants.equalsInteger(smsConfig.getStatus(),Constants.ZERO)){ | 
 |  |  |                 String content = systemDictDataBiz.queryByCode(Constants.SMS,Constants.SMS_COMNAME).getCode() + smsConfig.getContent(); | 
 |  |  |                 //超时特殊处理 | 
 |  |  |                 if(smsConfig.getCode().equals(SmsConstants.visitReportingContent.visitReportingTimeOutSignOutNum)){ | 
 |  |  |                     //今日还有{未签离数量}个访客报备车辆未离场,请前往PC端查看详细信息。 | 
 |  |  |                     content = content.replace("{未签离数量}",msg); | 
 |  |  |                     sendBusinessSms(emayService,smsEmailMapper, | 
 |  |  |                             mobiles,SmsConstants.visitReport,content,0); | 
 |  |  |                     return; | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |         }catch (Exception e){ | 
 |  |  |             e.printStackTrace(); | 
 |  |  |         } | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |     public static void sendVisitTimeOutSms(SystemDictDataBiz systemDictDataBiz, EmayService emayService , com.doumee.dao.business.dao.SmsEmailMapper smsEmailMapper , | 
 |  |  |                                                  SmsConfigMapper smsConfigMapper, | 
 |  |  |                                                  String objCode, String msg,List<String> mobiles){ | 
 |  |  |         try{ | 
 |  |  |             SmsConfig smsConfig = smsConfigMapper.selectOne(new QueryWrapper<SmsConfig>().lambda().eq(SmsConfig::getCode, | 
 |  |  |                     objCode).last(" limit 1 ")); | 
 |  |  |             //开启短信通知 | 
 |  |  |             if(Objects.nonNull(smsConfig) || Constants.equalsInteger(smsConfig.getStatus(),Constants.ZERO)){ | 
 |  |  |                 String content = systemDictDataBiz.queryByCode(Constants.SMS,Constants.SMS_COMNAME).getCode() + smsConfig.getContent(); | 
 |  |  |                 //超时特殊处理 | 
 |  |  |                 if(smsConfig.getCode().equals(SmsConstants.visitContent.visitTimeOutSignOutNum)){ | 
 |  |  |                     //今日还有{未签离数量}个访客报备车辆未离场,请前往PC端查看详细信息。 | 
 |  |  |                     content = content.replace("{未签离数量}",msg); | 
 |  |  |                     sendBusinessSms(emayService,smsEmailMapper, | 
 |  |  |                             mobiles,SmsConstants.visit,content,0); | 
 |  |  |                     return; | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |         }catch (Exception e){ | 
 |  |  | 
 |  |  |                         content = content.replace("{提交的出发时间}",DateUtil.getFomartDate(carUseBook.getStartTime(),"yyyy-MM-dd HH:mm")); | 
 |  |  |                     }else if(objCode.equals(SmsConstants.carUseBookContent.carUseBookAuditFail) || objCode.equals(SmsConstants.carUseBookContent.carUseBookCancel)){ | 
 |  |  |                         //您的【用车申请】已被驳回,驳回原因为:{驳回原因}。如有疑问,请联系派车员。 | 
 |  |  |                         if(StringUtils.isBlank(msg)){ | 
 |  |  |                             msg = "其他原因"; | 
 |  |  |                         } | 
 |  |  |                         content = content.replace("{驳回原因}",msg); | 
 |  |  |                         //您的【用车申请】已被取消,取消原因为:{取消原因}。如有疑问,请联系派车员。 | 
 |  |  |                         content = content.replace("{取消原因}",msg); | 
 |  |  | 
 |  |  |             smsEmail.setObjId(objId); | 
 |  |  |             smsEmailMapper.insert(smsEmail); | 
 |  |  |             emayService.sendSmsByHk(phone,content); | 
 |  |  |  | 
 |  |  |  | 
 |  |  |         } | 
 |  |  |     } | 
 |  |  |  |