OrderNewServiceImpl.java 37 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021
  1. package com.goafanti.order.service.impl;
  2. import java.io.IOException;
  3. import java.io.OutputStream;
  4. import java.io.UnsupportedEncodingException;
  5. import java.math.BigDecimal;
  6. import java.text.ParseException;
  7. import java.text.SimpleDateFormat;
  8. import java.util.ArrayList;
  9. import java.util.Arrays;
  10. import java.util.Calendar;
  11. import java.util.Date;
  12. import java.util.HashMap;
  13. import java.util.List;
  14. import java.util.Map;
  15. import java.util.UUID;
  16. import javax.mail.MessagingException;
  17. import javax.servlet.http.HttpServletResponse;
  18. import org.apache.commons.lang3.StringUtils;
  19. import org.apache.poi.xssf.usermodel.XSSFCell;
  20. import org.apache.poi.xssf.usermodel.XSSFRow;
  21. import org.apache.poi.xssf.usermodel.XSSFSheet;
  22. import org.apache.poi.xssf.usermodel.XSSFWorkbook;
  23. import org.slf4j.Logger;
  24. import org.slf4j.LoggerFactory;
  25. import org.springframework.beans.factory.annotation.Autowired;
  26. import org.springframework.beans.factory.annotation.Value;
  27. import org.springframework.core.task.TaskExecutor;
  28. import org.springframework.scheduling.annotation.Async;
  29. import org.springframework.scheduling.annotation.EnableAsync;
  30. import org.springframework.stereotype.Service;
  31. import com.alibaba.fastjson.JSON;
  32. import com.goafanti.admin.bo.AdminListBo;
  33. import com.goafanti.common.bo.EmailBo;
  34. import com.goafanti.common.bo.Error;
  35. import com.goafanti.common.constant.ErrorConstants;
  36. import com.goafanti.common.dao.AdminMapper;
  37. import com.goafanti.common.dao.IdleContractNoMapper;
  38. import com.goafanti.common.dao.NoticeMapper;
  39. import com.goafanti.common.dao.OrganizationContactBookMapper;
  40. import com.goafanti.common.dao.OrganizationManagementMapper;
  41. import com.goafanti.common.dao.TDunLogMapper;
  42. import com.goafanti.common.dao.TOrderBackMapper;
  43. import com.goafanti.common.dao.TOrderDunMapper;
  44. import com.goafanti.common.dao.TOrderLogMapper;
  45. import com.goafanti.common.dao.TOrderNewMapper;
  46. import com.goafanti.common.dao.TOrderOutsourceMapper;
  47. import com.goafanti.common.dao.TOrderRefundMapper;
  48. import com.goafanti.common.dao.TOrderTaskMapper;
  49. import com.goafanti.common.dao.UserLockReleaseMapper;
  50. import com.goafanti.common.enums.NoticeStatus;
  51. import com.goafanti.common.enums.OrderLogProcess;
  52. import com.goafanti.common.error.BusinessException;
  53. import com.goafanti.common.model.Admin;
  54. import com.goafanti.common.model.IdleContractNo;
  55. import com.goafanti.common.model.Notice;
  56. import com.goafanti.common.model.OrganizationContactBook;
  57. import com.goafanti.common.model.OrganizationManagement;
  58. import com.goafanti.common.model.TDunLog;
  59. import com.goafanti.common.model.TOrderBack;
  60. import com.goafanti.common.model.TOrderDun;
  61. import com.goafanti.common.model.TOrderLog;
  62. import com.goafanti.common.model.TOrderNew;
  63. import com.goafanti.common.model.TOrderOutsource;
  64. import com.goafanti.common.model.TOrderRefundWithBLOBs;
  65. import com.goafanti.common.model.TOrderTask;
  66. import com.goafanti.common.utils.ExportExcelUtil;
  67. import com.goafanti.common.utils.LoggerUtils;
  68. import com.goafanti.common.utils.SendEmailUtil;
  69. import com.goafanti.core.mybatis.BaseMybatisDao;
  70. import com.goafanti.core.mybatis.JDBCIdGenerator;
  71. import com.goafanti.core.mybatis.page.Pagination;
  72. import com.goafanti.core.shiro.token.TokenManager;
  73. import com.goafanti.customer.bo.LockingReleaseBo;
  74. import com.goafanti.order.bo.OrderDunTaskBo;
  75. import com.goafanti.order.bo.OrderRefundDetailBo;
  76. import com.goafanti.order.bo.TDunLogListBo;
  77. import com.goafanti.order.bo.TOrderLogBo;
  78. import com.goafanti.order.bo.TOrderNewBo;
  79. import com.goafanti.order.bo.TOrderRefundBo;
  80. import com.goafanti.order.bo.TOrderTaskBo;
  81. import com.goafanti.order.bo.TOrderTaskListBo;
  82. import com.goafanti.order.enums.ActiveState;
  83. import com.goafanti.order.enums.ApprovalNewState;
  84. import com.goafanti.order.enums.LiquidationNewState;
  85. import com.goafanti.order.enums.OrderDunSubject;
  86. import com.goafanti.order.enums.OrderNewState;
  87. import com.goafanti.order.enums.ProcessStatus;
  88. import com.goafanti.order.enums.ProjectNewStage;
  89. import com.goafanti.order.enums.TaskState;
  90. import com.goafanti.order.enums.refundState;
  91. import com.goafanti.order.service.OrderNewService;
  92. import com.goafanti.order.service.OrderService;
  93. import com.goafanti.organization.bo.OrganizationListOut;
  94. @Service
  95. @EnableAsync
  96. public class OrderNewServiceImpl extends BaseMybatisDao<TOrderNewMapper> implements OrderNewService {
  97. @Autowired
  98. private TOrderNewMapper tOrderNewMapper;
  99. @Autowired
  100. private TOrderTaskMapper tOrderTaskMapper;
  101. @Autowired
  102. private TOrderDunMapper tOrderDunMapper;
  103. @Autowired
  104. private TDunLogMapper tDunLogMapper;
  105. @Autowired
  106. private TOrderRefundMapper tOrderRefundMapper;
  107. @Autowired
  108. private TOrderBackMapper tOrderBackMapper;
  109. @Autowired
  110. private OrganizationContactBookMapper organizationContactBookMapper;
  111. @Autowired
  112. private OrganizationManagementMapper organizationManagementMapper ;
  113. @Autowired
  114. private JDBCIdGenerator idGenerator;
  115. @Autowired
  116. private AdminMapper adminMapper;
  117. @Autowired
  118. private TOrderLogMapper tOrderLogMapper;
  119. @Autowired
  120. private NoticeMapper noticeMapper;
  121. @Autowired
  122. private OrderService orderService;
  123. @Autowired
  124. private IdleContractNoMapper idleContractNoMapper;
  125. @Autowired
  126. private TOrderOutsourceMapper tOrderOutsourceMapper;
  127. @Autowired
  128. private UserLockReleaseMapper userLockReleaseMapper;
  129. @Value(value = "${mobileRemindCodeTemplate}")
  130. private String mobileRemindCodeTemplate = null;
  131. @Value(value = "${upload.path}")
  132. private String uploadPath = null;
  133. @Value(value = "${accessKey}")
  134. private String accessKey = null;
  135. @Value(value = "${accessSecret}")
  136. private String accessSecret = null;
  137. Logger logger = LoggerFactory.getLogger(OrderNewServiceImpl.class);
  138. @Override
  139. public int createServiceOrder(String uid, Integer orderType) {
  140. BigDecimal initial = new BigDecimal(0);
  141. TOrderNew t=new TOrderNew();
  142. t.setOrderNo(idGenerator.generateId().toString());
  143. t.setOrderType(orderType);
  144. t.setOrderStatus(OrderNewState.DQD.getCode());
  145. t.setFirstAmount(initial);
  146. t.setTotalAmount(initial);
  147. t.setSettlementAmount(initial);
  148. t.setLiquidationStatus(LiquidationNewState.WAIT_PAY_FIRST_BALANCE.getCode());
  149. t.setProcessStatus(ProcessStatus.YPYXY.getCode());
  150. t.setProjectStatus(ProjectNewStage.DTJ.getCode());
  151. t.setApproval(ApprovalNewState.FTP.getCode());
  152. t.setDeleteSign(0);//0-正常,1-作废,2-锁定
  153. t.setSalesmanId(TokenManager.getAdminId());
  154. t.setCreater(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  155. t.setOrderDep(adminMapper.selectByPrimaryKey(TokenManager.getAdminId()).getDepartmentId());
  156. t.setCreateTime(new Date());
  157. t.setUpdateTime(new Date());
  158. t.setBuyerId(uid);
  159. return tOrderNewMapper.insertSelective(t);
  160. }
  161. @Override
  162. public int addOrderTask(TOrderTask t) {
  163. TOrderNew order=tOrderNewMapper.selectByPrimaryKey(t.getOrderNo());
  164. checkOrder(order,t);
  165. t.setTaskStatus(TaskState.WFP.getCode());
  166. t.setProjectStatus(ProjectNewStage.DTJ.getCode());
  167. if(t.getCommodityPrice()!=null)order.setTotalAmount(order.getTotalAmount());
  168. return tOrderTaskMapper.insertSelective(t);
  169. }
  170. public void checkOrder(TOrderNew order,TOrderTask t){
  171. if(order == null)
  172. throw new BusinessException(new Error(ErrorConstants.ORDER_NOT_EXIST, "" ,""));
  173. if(order.getDeleteSign() == ActiveState.ABOLISH.getCode())
  174. throw new BusinessException(new Error(ErrorConstants.ORDER_ALREADY_FREEZE, order.getOrderNo(),""));
  175. if(order.getDeleteSign() == ActiveState.LOCKING.getCode())
  176. throw new BusinessException(new Error(ErrorConstants.ORDER_ALREADY_REVOKE, order.getOrderNo(),""));
  177. List<LockingReleaseBo> list=userLockReleaseMapper.checkTask(order.getBuyerId(),t.getCommodityId());
  178. if (list.size()>0) {
  179. for (LockingReleaseBo lockingReleaseBo : list) {
  180. if (!lockingReleaseBo.getAid().equals(TokenManager.getAdminId())) {
  181. throw new BusinessException(new Error( "该业务已经被其他人锁定","该业务已经被其他人锁定"));
  182. }
  183. }
  184. }
  185. }
  186. @Override
  187. public int updateOrderTask(TOrderTask t) {
  188. return tOrderTaskMapper.updateByPrimaryKeySelective(t);
  189. }
  190. @Override
  191. public int delectOrderTask(Integer id) {
  192. return tOrderTaskMapper.deleteByPrimaryKey(id);
  193. }
  194. @Override
  195. public List<TOrderTaskBo> selectOrderTask(String orderNo) {
  196. return tOrderTaskMapper.selectOrderTask(orderNo);
  197. }
  198. @Override
  199. public int updateServiceOrder(TOrderNew t, Integer isSubmit) {
  200. TOrderNew t2=tOrderNewMapper.selectByPrimaryKey(t.getOrderNo());
  201. //判断手机号码是否存在
  202. if (StringUtils.isNotBlank(t.getContacts())&&StringUtils.isNotBlank(t.getContactMobile())&&
  203. organizationContactBookMapper.checkContacts(t2.getBuyerId(), t2.getContactMobile(),TokenManager.getAdminId()==null?"1":TokenManager.getAdminId() )>0) {
  204. OrganizationContactBook contactBook=new OrganizationContactBook();
  205. contactBook.setId(UUID.randomUUID().toString());
  206. contactBook.setAid(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  207. contactBook.setUid(t2.getBuyerId());
  208. contactBook.setName(t.getContacts());
  209. contactBook.setMobile(t.getContactMobile());
  210. organizationContactBookMapper.insertSelective(contactBook);
  211. }
  212. if (StringUtils.isBlank(t.getOrderDep())) {
  213. t.setOrderDep(adminMapper.selectByPrimaryKey(TokenManager.getAdminId()).getDepartmentId());
  214. }
  215. if (isSubmit==1) {//订单提交
  216. if(t2.getProcessStatus()<ProcessStatus.YPYXGLY.getCode()) {
  217. t.setOrderStatus(OrderNewState.QDDS.getCode());
  218. t.setProcessStatus(ProcessStatus.YPYXGLY.getCode());
  219. }else {
  220. t.setOrderStatus(OrderNewState.QDSHTG.getCode());
  221. }
  222. if (t2.getApproval()==ApprovalNewState.BH.getCode()){
  223. t.setApproval(ApprovalNewState.DSH.getCode());
  224. }
  225. //生成流转
  226. addOrderLog(t.getOrderNo(),OrderLogProcess.TJ.getCode());
  227. if (StringUtils.isBlank(t2.getContractNo())) {
  228. //没有合同编号则生成
  229. createContractNo(t);
  230. }else if(!t.getOrderDep().equals(t2.getOrderDep())) {
  231. contractNoReplace(t.getOrderNo(), t2.getContractNo(),t2.getOrderDep());
  232. createContractNo(t);
  233. }
  234. List<String> aids = new ArrayList<>();
  235. Integer type=null;
  236. AdminListBo a = adminMapper.getDeptNameByAid(TokenManager.getAdminId());
  237. aids.addAll(adminMapper.listNameByDepAndName(a.getDepartmentId(), "营销管理员"));
  238. type=NoticeStatus.ORDER_START.getCode();
  239. pushGeneralSendNoticeAndEmail(aids, type,t2.getOrderNo(), TokenManager.getAdminId());
  240. }
  241. if (t2.getApproval()==ApprovalNewState.BH.getCode()||
  242. t2.getOrderStatus()==OrderNewState.QDSHJJ.getCode()||
  243. t2.getOrderStatus()==OrderNewState.YBH.getCode()) {
  244. t.setCreateTime(new Date());
  245. tOrderBackMapper.updateByOrderNoAndBackStatus(t.getOrderNo());
  246. }
  247. // 0 相等
  248. // -1 小于
  249. // 1 大于
  250. //liquidation_status 清算状态 0-首付待付请,1-尾款待付清,2-已付请,3-部分退款,4-全部退款
  251. //settlement_amount 已付 total_amount 总价格 first_amount首付
  252. if(t2.getLiquidationStatus()!=LiquidationNewState.FULL_REFUND.getCode()) {
  253. if(t2.getSettlementAmount().compareTo(t.getTotalAmount()) == 0){//如果已付等于总价
  254. t.setLiquidationStatus(LiquidationNewState.ALREADY_PAY.getCode());
  255. }else if(t2.getSettlementAmount().compareTo(t.getFirstAmount()) >= 0){//如果大于等于首付
  256. t.setLiquidationStatus(LiquidationNewState.WAIT_PAY_LAST_BALANCE.getCode());
  257. } else if(t2.getSettlementAmount().compareTo(t.getFirstAmount()) < 0){//如果小于首付
  258. t.setLiquidationStatus(LiquidationNewState.WAIT_PAY_FIRST_BALANCE.getCode());
  259. }
  260. }
  261. return tOrderNewMapper.updateByPrimaryKeySelective(t);
  262. }
  263. /**
  264. * 新建合同编号,优先获取闲置合同编号,否则按年份生成编号
  265. * @param t
  266. */
  267. private void createContractNo(TOrderNew t) {
  268. //根据订单部门或许合同编号前缀
  269. OrganizationManagement dep=organizationManagementMapper.selectByPrimaryKey(t.getOrderDep());
  270. if (dep==null||StringUtils.isBlank(dep.getAbbreviation())) {
  271. throw new BusinessException(new Error( "该部门缩写不存在","该部门缩写不存在"));
  272. }
  273. IdleContractNo i=idleContractNoMapper.selectByAbbreviation(dep.getAbbreviation());
  274. if (i!=null&&i.getContractNo()!=null) {
  275. t.setContractNo(i.getContractNo());
  276. idleContractNoMapper.deleteByPrimaryKey(i.getId());
  277. }else {
  278. //根据前缀查询最大编号
  279. String max=organizationManagementMapper.getMaxAbbreviation(dep.getAbbreviation()+"-");
  280. //获取日期年份
  281. Calendar c=Calendar.getInstance();
  282. int y=c.getWeekYear();
  283. String sno=null;
  284. if (StringUtils.isBlank(max)||max.length()<13) {
  285. String cn=""+dep.getAbbreviation()+"-"+y+"0001";
  286. cn=iterationNo(cn,dep.getAbbreviation(),y,1);
  287. t.setContractNo(cn);
  288. }else {
  289. int ty=Integer.parseInt(max.substring(max.indexOf("-")+1, max.length()-4));
  290. int no=Integer.parseInt(max.substring(max.length()-4, max.length()));
  291. //得出字符串
  292. sno = countNo(dep.getAbbreviation(), sno, ty, no);
  293. //迭代得出最后编码
  294. sno=iterationNo(sno,dep.getAbbreviation(),ty,no);
  295. //年份小于等于则获取最大值加1,大于则获取最新年份
  296. if (y<=ty) {
  297. t.setContractNo(sno);
  298. }else {
  299. t.setContractNo(""+dep.getAbbreviation()+"-"+y+"0001");
  300. }
  301. }
  302. }
  303. }
  304. private String iterationNo(String sno ,Object mp, int ty, int no) {
  305. if (tOrderNewMapper.checkContractNo(sno)>0) {
  306. int i=Integer.parseInt(sno.substring(sno.indexOf("-")+5, sno.length()));
  307. sno=countNo(mp, sno, ty, i);
  308. iterationNo(sno,mp,ty,i);
  309. }
  310. return sno;
  311. }
  312. private String countNo(Object object, String sno, int ty, int no) {
  313. no++;
  314. if (no>0&&no<10) {
  315. sno=object+"-"+ty+"000"+no;
  316. }else if (no>9&&no<100) {
  317. sno=object+"-"+ty+"00"+no;
  318. } else if (no>99&&no<1000) {
  319. sno=object+"-"+ty+"0"+no;
  320. } else if(no>1000){
  321. sno=object+"-"+ty+no;
  322. }
  323. return sno;
  324. }
  325. public void addOrderLog(String orderNo, Integer code) {
  326. TOrderLog tl=new TOrderLog();
  327. tl.setOrderNo(orderNo);
  328. tl.setProcess(code);
  329. tl.setAid(TokenManager.getAdminId());
  330. tOrderLogMapper.insertSelective(tl);
  331. }
  332. @Override
  333. public TOrderNewBo getOrderNewDetail(String orderNo) {
  334. TOrderNewBo tOrder= tOrderNewMapper.getOrderNewDetail(orderNo);
  335. return tOrder;
  336. }
  337. @Override
  338. public int createOrderDun(String orderDun,String orderNo) {
  339. List<TOrderDun> l= JSON.parseArray(orderDun, TOrderDun.class);
  340. List<TOrderDun> l2=tOrderDunMapper.selectByOrderNoDunSubject(orderNo);
  341. if (l!=null&&!l.isEmpty()) {
  342. for (TOrderDun t : l) {
  343. if (t.getId()==null||t.getId().equals("")) {//Id为空新增
  344. if (tOrderDunMapper.checkOrderDun(t.getDunSubject(),orderNo)>0) {
  345. throw new BusinessException(new Error( "该截点已经存在","该截点已经存在"));
  346. }
  347. t.setId(UUID.randomUUID().toString());
  348. t.setDunBy(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  349. t.setDunStatus(0);//未启动
  350. tOrderDunMapper.insertSelective(t);
  351. }else {
  352. tOrderDunMapper.updateByPrimaryKeySelective(t);
  353. }
  354. }
  355. }
  356. boolean flag=true;
  357. for (TOrderDun t2 : l2) {
  358. if (l.isEmpty()) {
  359. tOrderDunMapper.deleteByPrimaryKey(t2.getId());
  360. }else {
  361. for (TOrderDun t : l) {
  362. if (t2.getId().equals(t.getId())) {//查询集合与返回集合比较查出删除项
  363. flag=false;
  364. }
  365. }
  366. if (t2.getId()!=null&&flag) {
  367. tOrderDunMapper.deleteByPrimaryKey(t2.getId());
  368. }
  369. flag=true;
  370. }
  371. }
  372. return 1;
  373. }
  374. @SuppressWarnings("unchecked")
  375. @Override
  376. public Pagination<TOrderNewBo> orderNewList(String name, String orderNo, String starTime, String endTime,Integer specially,Integer distribution,String depId, Integer pageNo,
  377. Integer pageSize,Integer outsource) {
  378. Map<String, Object> params = new HashMap<String, Object>();
  379. if(pageSize==null||pageSize<0)pageSize=10;
  380. if(pageNo==null||pageNo<0)pageNo=1;
  381. if (specially!=null&&(specially==0||specially==1||specially==2||specially==4||specially==5)) {
  382. //0 个人 1 营销员管理 2 驳回 3 特批 4 咨询师管理 5部门订单查询
  383. if (specially!=3&&specially!=4) {
  384. params.put("aid", TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  385. }
  386. //(咨询师管理列表 0 未分配 1部分 2全部)
  387. if(specially==4) params.put("distribution",distribution);
  388. // 计算出所有本部门及所属部门的ID
  389. if(specially==1||specially==5) params.put("deps", orderService.selectMyDeps());
  390. }
  391. params.put("specially",specially);
  392. if (StringUtils.isNotBlank(name)) params.put("name", name);
  393. if (StringUtils.isNotBlank(depId)) params.put("depId", depId);
  394. if (StringUtils.isNotBlank(orderNo)) params.put("orderNo", orderNo);
  395. if (StringUtils.isNotBlank(starTime)) params.put("starTime", starTime);
  396. if (StringUtils.isNotBlank(endTime)) params.put("endTime", endTime+" 23:59:59");
  397. params.put("outsource", outsource);
  398. Pagination<TOrderNewBo> p = (Pagination<TOrderNewBo>)findPage("selectOrderNewListByPage", "selectOrderNewListCount", params, pageNo, pageSize);
  399. return p;
  400. }
  401. @Override
  402. public int updateOrderNew(String orderNo, Integer orderStatus,String reason,Integer outsource, TOrderOutsource o) {
  403. TOrderNew t= new TOrderNew();
  404. TOrderNew t2= checkDeleteSign(orderNo);
  405. t.setOrderNo(orderNo);
  406. List<String> aids = new ArrayList<>();
  407. Integer type=null;
  408. if (orderStatus==OrderNewState.QDSHTG.getCode()) {
  409. t.setOutsource(outsource);
  410. if (t2.getApproval()==ApprovalNewState.FTP.getCode()||
  411. t2.getApproval()==ApprovalNewState.TG.getCode()) {//如果通过分配给财务管理员
  412. if(outsource==0) {
  413. t.setProcessStatus(ProcessStatus.YPCWZY.getCode());
  414. //如果是转的暂时不删除外包信息
  415. aids.add(organizationManagementMapper.selectByPrimaryKey(t2.getOrderDep()).getFinanceId());
  416. } else if(outsource==1) {
  417. for (Admin admin : adminMapper.getAdminRoleList("外包审核员")) {
  418. aids.add(admin.getId());
  419. }
  420. t.setProcessStatus(ProcessStatus.YPWBSH.getCode());
  421. addOrderLog(orderNo, OrderLogProcess.FQWB.getCode());
  422. //外包
  423. o.setRefundStatus(0);
  424. if(o.getId()==null) {
  425. o.setCreateTime(new Date());
  426. tOrderOutsourceMapper.insertSelective(o);
  427. }else {
  428. tOrderOutsourceMapper.updateByPrimaryKeySelective(o);
  429. }
  430. }
  431. }else {
  432. t.setProcessStatus(ProcessStatus.YPTPSH.getCode());
  433. for (Admin admin : adminMapper.getAdminRoleList("总裁")) {
  434. aids.add(admin.getId());
  435. }
  436. }
  437. type=NoticeStatus.ORDER_YES.getCode();
  438. addOrderLog(orderNo, OrderLogProcess.SH.getCode());
  439. }else if (orderStatus==OrderNewState.QDSHJJ.getCode()) {//如果不通过新增驳回
  440. if (outsource==0) {//非外包
  441. t.setProcessStatus(ProcessStatus.YPYXY.getCode());
  442. addBackOrder(orderNo, reason);
  443. addOrderLog(orderNo, OrderLogProcess.BH.getCode());
  444. }
  445. aids.add(t2.getSalesmanId());
  446. type=NoticeStatus.ORDER_NO.getCode();
  447. }
  448. t.setOrderStatus(orderStatus);
  449. tOrderNewMapper.updateByPrimaryKeySelective(t);
  450. pushGeneralSendNoticeAndEmail(aids, type,t2.getOrderNo(), TokenManager.getAdminId());
  451. return 1;
  452. }
  453. private void addBackOrder(String orderNo, String reason) {
  454. TOrderBack ob=new TOrderBack();
  455. TOrderNew tOrder= tOrderNewMapper.selectByPrimaryKey(orderNo);
  456. ob.setCreateTime(new Date());
  457. ob.setOrderNo(orderNo);
  458. ob.setReason(reason);
  459. ob.setBackStatus(0);//待处理
  460. ob.setInitiate(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  461. ob.setAccept(tOrder.getSalesmanId());
  462. /*try {
  463. addNoticAndSendEmail(orderNo, null, NoticeStatus.ORDER_BACK.getCode());
  464. } catch (UnsupportedEncodingException | MessagingException e) {
  465. LoggerUtils.error(getClass(), "发送邮件失败", e);
  466. }*/
  467. tOrderBackMapper.insertSelective(ob);
  468. }
  469. @SuppressWarnings("unchecked")
  470. @Override
  471. public Pagination<TOrderNewBo> dunOrderNewList(String name, String orderNo, String starTime, String endTime,
  472. Integer specially, String adminName,String depId,Integer pageNo, Integer pageSize) {
  473. Map<String, Object> params = new HashMap<String, Object>();
  474. if(pageSize==null||pageSize<0)pageSize=10;
  475. if(pageNo==null||pageNo<0)pageNo=1;
  476. if (StringUtils.isNotBlank(name)) params.put("name", name);
  477. if (StringUtils.isNotBlank(depId)) params.put("depId", depId);
  478. if(specially!=null&&specially==1) params.put("aid", TokenManager.getAdminId());;
  479. if (StringUtils.isNotBlank(adminName)) params.put("adminName", adminName);
  480. if (StringUtils.isNotBlank(orderNo)) params.put("orderNo", orderNo);
  481. if (StringUtils.isNotBlank(starTime)) params.put("starTime", starTime);
  482. if (StringUtils.isNotBlank(endTime)) params.put("endTime", endTime+" 23:59:59");
  483. Pagination<TOrderNewBo> p = (Pagination<TOrderNewBo>)findPage("selectDunOrderNewListByPage", "selectDunOrderNewListCount", params, pageNo, pageSize);
  484. return p;
  485. }
  486. @Override
  487. public int createDunLog(String dunId,String dumTime,String remarks) {
  488. TDunLog d=new TDunLog();
  489. d.setId(UUID.randomUUID().toString());
  490. d.setDunId(dunId);
  491. d.setDumBy(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  492. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  493. try {
  494. d.setDumTime(sdf.parse(dumTime));
  495. } catch (ParseException e) {
  496. e.printStackTrace();
  497. }
  498. d.setRemarks(remarks);
  499. return tDunLogMapper.insertSelective(d);
  500. }
  501. @Override
  502. public List<TDunLogListBo> selectDunLogList(String dunId) {
  503. return tDunLogMapper.selectByDunId(dunId);
  504. }
  505. @Override
  506. public int addOrderRefund(TOrderRefundWithBLOBs t) {
  507. TOrderNew order =checkDeleteSign(t.getOrderNo());
  508. if(order.getDeleteSign()!=0)throw new BusinessException(new Error( "订单变更锁定中","订单变更锁定中"));
  509. t.setRefundStatus(refundState.DSH.getCode());
  510. t.setCreateTime(new Date());
  511. t.setInitiate(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  512. //t.setAccept("1");
  513. t.setAccept(order.getFinanceId());
  514. t.setResult("");
  515. TOrderNew tOrder=new TOrderNew();
  516. tOrder.setOrderNo(t.getOrderNo());
  517. tOrder.setOrderStatus(OrderNewState.TDZ.getCode());
  518. tOrderNewMapper.updateByPrimaryKeySelective(tOrder);
  519. addOrderLog(t.getOrderNo(), OrderLogProcess.FQTD.getCode());
  520. return tOrderRefundMapper.insertSelective(t);
  521. }
  522. @Override
  523. public int updateApprovalOrder(String orderNo,Integer confirm,String reason) {
  524. TOrderNew t=new TOrderNew();
  525. TOrderNew t2=checkDeleteSign(orderNo);
  526. t.setOrderNo(orderNo);
  527. List<String> aids = new ArrayList<>();
  528. Integer type=null;
  529. if (confirm==2) {
  530. t.setApproval(2);
  531. if(t2.getOutsource()==0) {
  532. t.setProcessStatus(ProcessStatus.YPCWZY.getCode());
  533. aids.add(organizationManagementMapper.selectByPrimaryKey(t2.getOrderDep()).getFinanceId());
  534. }else {
  535. t.setProcessStatus(ProcessStatus.YPWBSH.getCode());
  536. for (Admin admin : adminMapper.getAdminRoleList("外包审核员")) {
  537. aids.add(admin.getId());
  538. }
  539. }
  540. type=NoticeStatus.ORDER_APPROVA_YES.getCode();
  541. addOrderLog(orderNo, OrderLogProcess.TP.getCode());
  542. } else {
  543. t.setApproval(3);
  544. t.setOrderStatus(OrderNewState.YBH.getCode());
  545. t.setProcessStatus(ProcessStatus.YPYXY.getCode());
  546. addBackOrder(orderNo, reason);
  547. addOrderLog(orderNo, OrderLogProcess.BH.getCode());
  548. aids.add(t2.getSalesmanId());
  549. type=NoticeStatus.ORDER_APPROVA_NO.getCode();
  550. }
  551. pushGeneralSendNoticeAndEmail(aids, type,t2.getOrderNo(), TokenManager.getAdminId());
  552. return tOrderNewMapper.updateByPrimaryKeySelective(t);
  553. }
  554. @Override
  555. public List<TOrderDun> selectOrderDun(String orderNo) {
  556. return tOrderDunMapper.selectByOrderNoDunSubject(orderNo);
  557. }
  558. @Override
  559. public boolean checkOrderMain(TOrderTask t) {
  560. List<TOrderTaskBo> list=tOrderTaskMapper.selectOrderTask(t.getOrderNo());
  561. int flag=0;
  562. if(t.getMain()==1)flag++;
  563. for (TOrderTask t2 : list) {
  564. if(t2.getMain()==1&&t.getId()==null) {
  565. flag++;
  566. }else if (t2.getMain()==1&&(!t.getId().equals(t2.getId()))) {
  567. flag++;
  568. }
  569. }
  570. if (flag>1) {
  571. return true;
  572. }
  573. return false;
  574. }
  575. @Override
  576. public boolean chekeOrderStatus(String orderNo) {
  577. TOrderNew tOrder= tOrderNewMapper.selectByPrimaryKey(orderNo);
  578. if (tOrder.getOrderStatus()==OrderNewState.QDDS.getCode()||tOrder.getOrderStatus()==OrderNewState.QDSHTG.getCode()) {
  579. return false;
  580. }
  581. return true;
  582. }
  583. @Override
  584. public boolean chekeApprovalOrderStatus(String orderNo) {
  585. TOrderNew tOrder= tOrderNewMapper.selectByPrimaryKey(orderNo);
  586. if (tOrder.getApproval()==ApprovalNewState.FTP.getCode()||
  587. tOrder.getOrderStatus()==OrderNewState.QDSHJJ.getCode()||
  588. tOrder.getOrderStatus()==OrderNewState.YBH.getCode()) {
  589. return true;
  590. }
  591. return false;
  592. }
  593. @Override
  594. public int deleteOrderNew(String orderNo) {
  595. TOrderNew t=tOrderNewMapper.selectByPrimaryKey(orderNo);
  596. if (t.getOrderStatus()==OrderNewState.YBH.getCode()||t.getOrderStatus()==OrderNewState.YTD.getCode()||
  597. t.getOrderStatus()==OrderNewState.DQD.getCode()||t.getOrderStatus()==OrderNewState.QDSHJJ.getCode()) {
  598. t.setOrderNo(orderNo);
  599. t.setDeleteSign(1);//作废
  600. contractNoReplace(orderNo, t.getContractNo(),t.getOrderDep());
  601. t.setContractNo("");
  602. return tOrderNewMapper.updateByPrimaryKeySelective(t);
  603. }
  604. return -1;
  605. }
  606. /**
  607. * 将合同编号置为闲置编号
  608. * @param orderNo
  609. * @param t
  610. */
  611. private void contractNoReplace(String orderNo, String contractNo,String orderDep) {
  612. Calendar c=Calendar.getInstance();
  613. int y=c.getWeekYear();
  614. String ys="-"+y;
  615. //判断编号是否类似‘-2019’,是则为有效编号
  616. if (contractNo.contains(ys)) {
  617. IdleContractNo i=new IdleContractNo();
  618. i.setAid(TokenManager.getAdminId());
  619. i.setContractNo(contractNo);
  620. i.setUsedOrderNo(orderNo);
  621. //如果找不到订单部门,则取订单编号-前面的缩写
  622. if(StringUtils.isNotBlank(orderDep)) {
  623. OrganizationManagement o=organizationManagementMapper.selectByPrimaryKey(orderDep);
  624. i.setAbbreviation(o.getAbbreviation());
  625. }else {
  626. i.setAbbreviation(contractNo.substring(0, contractNo.indexOf("-")));
  627. }
  628. idleContractNoMapper.insertSelective(i);
  629. }
  630. }
  631. @Override
  632. public boolean checkOderSettlementAmount(String orderNo) {
  633. TOrderNew tOrder= tOrderNewMapper.selectByPrimaryKey(orderNo);
  634. if (tOrder.getSettlementAmount()==null||
  635. tOrder.getSettlementAmount().doubleValue()==0||
  636. tOrder.getOrderStatus()==OrderNewState.TDZ.getCode()){
  637. return true;
  638. }
  639. return false;
  640. }
  641. @SuppressWarnings("unchecked")
  642. @Override
  643. public Pagination<TOrderRefundBo> orderRefundList(String name, String orderNo, String starTime, String endTime, Integer specially,
  644. Integer pageNo, Integer pageSize) {
  645. Map<String, Object> params = new HashMap<String, Object>();
  646. if(pageSize==null||pageSize<0)pageSize=10;
  647. if(pageNo==null||pageNo<0)pageNo=1;
  648. params.put("aid", TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  649. if (StringUtils.isNotBlank(name)) params.put("name", name);
  650. if (StringUtils.isNotBlank(orderNo)) params.put("orderNo", orderNo);
  651. if (StringUtils.isNotBlank(starTime)) params.put("starTime", starTime);
  652. if (StringUtils.isNotBlank(endTime)) params.put("endTime", endTime+" 23:59:59");
  653. Pagination<TOrderRefundBo> p = (Pagination<TOrderRefundBo>)findPage("selectOrderRefundListByPage", "selectOrderRefundListCount", params, pageNo, pageSize);
  654. return p;
  655. }
  656. @Override
  657. public boolean checkORderTask(String orderNo) {
  658. List<TOrderTaskBo> list=tOrderTaskMapper.selectOrderTask(orderNo);
  659. for (TOrderTaskBo t : list) {
  660. if (t.getMain()==1) {
  661. return false;
  662. }
  663. }
  664. return true;
  665. }
  666. @Override
  667. public boolean checkORderDun(String orderNo) {
  668. List<TOrderDun> list=tOrderDunMapper.selectByOrderNoDunSubject(orderNo);
  669. if (list==null||list.size()<1) {
  670. return true;
  671. }else {
  672. return false;
  673. }
  674. }
  675. /**
  676. * 获取催款数据
  677. * @throws IOException
  678. */
  679. @Override
  680. public void exportOrderDunData(String name,String orderNo,String starTime,String endTime,Integer specially,String adminName,
  681. String depId,Integer pageNo,Integer pageSize,HttpServletResponse response) throws IOException {
  682. OutputStream out = response.getOutputStream();
  683. try {
  684. @SuppressWarnings("unchecked")
  685. List<TOrderNewBo> list=(List<TOrderNewBo>) dunOrderNewList( name, orderNo, starTime, endTime,
  686. specially, adminName, depId, pageNo, pageSize).getList();
  687. String[] comment = {"合同编号","订单编号","客户名称","订单负责人","订单部门","订单状态","签单金额","结算状态","已收款","应收款","项目节点","项目状态","催收科目","催款启动时间"};
  688. String fileName ="催款信息记录表" + new SimpleDateFormat("yyyy-MM-dd HH:mm").format(new Date()) + ".xls";
  689. //type 0 变更
  690. XSSFWorkbook wb =ExportExcelUtil.exportTemplateInfoS(comment,"催款信息");
  691. //根据列表编写文档
  692. XSSFSheet sheet =wb.getSheetAt(0);
  693. for (TOrderNewBo ob : list) {
  694. //新增一行
  695. XSSFRow r = sheet.createRow(sheet.getLastRowNum()+1);
  696. for (int i = 0; i < comment.length; i++) {
  697. //当前列的只
  698. String o = "";
  699. switch (comment[i]) {
  700. // "合同编号","订单编号","客户名称","订单负责人","订单部门","订单状态","项目负责人","签单金额","结算状态","已收款","应收款","项目状态","催收科目","催款启动时间"
  701. case "合同编号": o = ob.getContractNo(); break;
  702. case "订单编号": o = ob.getOrderNo().toString(); break;
  703. case "客户名称": o = ob.getUserName(); break;
  704. case "订单负责人": o = ob.getSalesmanName(); break;
  705. case "订单部门": o = ob.getDepName(); break;
  706. case "订单状态": o = OrderNewState.getValueByCode(ob.getOrderStatus());break;
  707. case "签单金额": o = ob.getTotalAmount().toString(); break;
  708. case "结算状态": o = LiquidationNewState.getValueByCode(ob.getLiquidationStatus()); break;
  709. case "已收款": o = ob.getSettlementAmount().toString(); break;
  710. case "应收款": o = ob.getAccountsReceivable(); break;
  711. case "项目节点": o = ob.getSalesmanName(); break;
  712. case "项目状态": o = ProjectNewStage.getValueByCode(ob.getProjectStatus()); break;
  713. case "催收科目": o = OrderDunSubject.getValueByCode(Integer.valueOf(ob.getDunSubject())); break;
  714. case "催款启动时间": o = ob.getStartDate(); break;
  715. default: o = ""; break;
  716. }
  717. XSSFCell c = r.createCell(i);
  718. c.setCellValue(o);
  719. }
  720. }
  721. //返回名称及参数
  722. response.addHeader("Content-Disposition", "attachment;filename=" + new String(fileName.getBytes(),"iso-8859-1"));
  723. response.setContentType("application/octet-stream;charset=utf-8");
  724. // 返回数据流
  725. wb.write(out);
  726. out.flush();
  727. out.close();
  728. } catch (Exception e) {
  729. throw new BusinessException(new Error("表格生成错误。"));
  730. }finally {
  731. out.flush();
  732. out.close();
  733. }
  734. }
  735. @Override
  736. public int updateOrderOver(String orderNo) {
  737. TOrderNew t=tOrderNewMapper.selectByPrimaryKey(orderNo);
  738. if (t.getLiquidationStatus()!=LiquidationNewState.ALREADY_PAY.getCode()||
  739. t.getProcessStatus()!=ProcessStatus.YQBFPZXSGLY.getCode()) {
  740. return -1;
  741. }
  742. List<TOrderTaskBo> list=tOrderTaskMapper.selectOrderTask(orderNo);
  743. for (TOrderTaskBo task : list) {
  744. if (task.getTaskStatus()!=TaskState.CLYWC.getCode()) {
  745. return -1;
  746. }
  747. }
  748. t.setOrderStatus(OrderNewState.YJX.getCode());
  749. t.setSettlementTime(new Date());
  750. return tOrderNewMapper.updateByPrimaryKeySelective(t);
  751. }
  752. @Override
  753. public OrderRefundDetailBo orderRefundDetail(String id) {
  754. return tOrderNewMapper.orderRefundDetail(id);
  755. }
  756. @Override
  757. public int updateOrderRefund(TOrderRefundWithBLOBs t) {
  758. checkDeleteSign(t.getOrderNo());
  759. return tOrderRefundMapper.updateByPrimaryKeySelective(t);
  760. }
  761. @Override
  762. public int updatetechnicianBackOrder(String orderNo,String reason) {
  763. TOrderNew t = checkDeleteSign(orderNo);
  764. if (t.getSettlementAmount().compareTo(new BigDecimal(0))!=0) {
  765. return -1;
  766. }
  767. t.setOrderStatus(OrderNewState.YBH.getCode());
  768. t.setProcessStatus(ProcessStatus.YPYXY.getCode());
  769. t.setFinanceId("");
  770. addBackOrder(orderNo, reason);
  771. List<String> aids = new ArrayList<>();
  772. aids.add(t.getSalesmanId());
  773. pushGeneralSendNoticeAndEmail(aids, NoticeStatus.ORDER_NO.getCode(),t.getOrderNo(), TokenManager.getAdminId());
  774. return tOrderNewMapper.updateByPrimaryKeySelective(t);
  775. }
  776. private TOrderNew checkDeleteSign(String orderNo) {
  777. TOrderNew t=tOrderNewMapper.selectByPrimaryKey(orderNo);
  778. //if(t.getDeleteSign()==2) throw new BusinessException(new Error(ErrorConstants.ORDER_ALREADY_REVOKE, t.getOrderNo(),""));
  779. return t;
  780. }
  781. @Override
  782. public List<OrderDunTaskBo> selectAllOrderDun() {
  783. return tOrderDunMapper.getTaskAllOrderDun();
  784. }
  785. @Override
  786. public void updateOrderDun(TOrderDun tDun) {
  787. tOrderDunMapper.updateByPrimaryKeySelective(tDun);
  788. }
  789. public void addNotic(String orderNo,Integer type,AdminListBo a,TOrderNewBo b) {
  790. LoggerUtils.debug(logger, "======================站内消息发送启动===================");
  791. String str=NoticeStatus.getValueByCode(type)+": 订单编号 -"+orderNo+", 操作人:"+a.getDepartmentName()+"-"+a.getName()+"。";
  792. Notice n =new Notice();
  793. n.setId(UUID.randomUUID().toString());
  794. n.setAid(b.getSalesmanId());
  795. n.setNoticeType(type);
  796. n.setContent(str);
  797. n.setReaded(0);//未读
  798. noticeMapper.insertSelective(n);
  799. }
  800. public void sendEmail(String orderNo,String dunId,AdminListBo a,TOrderNewBo b) throws UnsupportedEncodingException, MessagingException{
  801. LoggerUtils.debug(logger, "======================邮件信息发送===================");
  802. String content = "<div>客户名称: "+ b.getUserName() +"</div><div>订单编号: " + orderNo + "</div>";
  803. String tite="订单驳回";
  804. if(StringUtils.isNotBlank(dunId)) {
  805. TOrderDun tDun=tOrderDunMapper.selectByPrimaryKey(dunId);
  806. content +="<div>催收时间: " + new SimpleDateFormat("yyyy-MM-dd").format(tDun.getCreateTime()) +
  807. "</div><div>催收科目: " + OrderDunSubject.getValueByCode(tDun.getDunSubject()) +
  808. "</div><div>催收情况: " + (tDun.getDunStatus()==2?"已完成":"已启动") +"</div>";
  809. tite="催收通知";
  810. }
  811. //发送驳回邮件
  812. EmailBo bo = new EmailBo(tite, b.getEmail(), b.getSalesmanName(), a.getDepartmentName(), a.getName(), content);
  813. if(StringUtils.isNotBlank(b.getEmail())) {
  814. LoggerUtils.debug(logger, "tite:"+tite+" Email:"+ b.getEmail()+" 收件人姓名:"+ b.getSalesmanName()+ " 部门:"+a.getDepartmentName()+ " 发件人姓名:"+a.getName()+" 内容:"+ content);
  815. SendEmailUtil.getInstance().send(bo);
  816. }
  817. LoggerUtils.debug(logger, "=========================================发送邮件成功");
  818. }
  819. @Override
  820. public void addNoticAndSendEmail(String orderNo,OrderDunTaskBo t,Integer type)
  821. throws UnsupportedEncodingException, MessagingException {
  822. TOrderNewBo b = tOrderNewMapper.getSaleIdByOno(type==NoticeStatus.ORDER_DUN.getCode()?t.getOrderNo():orderNo);
  823. String id="1";
  824. if (type==NoticeStatus.ORDER_DUN.getCode()) id=b.getSalesmanId();
  825. if (type==NoticeStatus.ORDER_BACK.getCode()) id=TokenManager.getAdminId()==null?"1":TokenManager.getAdminId();
  826. AdminListBo a = adminMapper.getDeptNameByAid(id);
  827. sendEmail(type==NoticeStatus.ORDER_DUN.getCode()?t.getOrderNo():orderNo, t==null?null:t.getId(), a, b);
  828. addNotic(type==NoticeStatus.ORDER_DUN.getCode()?t.getOrderNo():orderNo,type,a, b);
  829. }
  830. @Override
  831. public int updateFinance(String orderNo, String newFinance) {
  832. String aid=TokenManager.getAdminId();
  833. String[] l=orderNo.split(",");
  834. List<String> orderNos=new ArrayList<>(Arrays.asList(l));
  835. tOrderNewMapper.updateFinance(aid,orderNos,newFinance);
  836. return 1;
  837. }
  838. @Override
  839. public List<TOrderLogBo> selectOrderLog(String orderNo) {
  840. return tOrderLogMapper.selectOrderByNo(orderNo);
  841. }
  842. @Async
  843. public void pushGeneralSendNoticeAndEmail(List<String> alist, Integer type,String OrderNo,String adminId) {
  844. AdminListBo a = adminMapper.getDeptNameByAid(adminId);
  845. String str=NoticeStatus.getValueByCode(type)+": 订单编号 -"+OrderNo+", 操作人:"+a.getDepartmentName()+"-"+a.getName()+"。";
  846. String adminIds="";
  847. List<Notice> nlist=new ArrayList<>();
  848. for (String string : alist) {
  849. Notice n =new Notice();
  850. n.setId(UUID.randomUUID().toString());
  851. n.setNoticeType(type);
  852. n.setContent(str);
  853. n.setCreateTime(new Date());
  854. n.setReaded(0);//未读
  855. n.setAid(string);
  856. nlist.add(n);
  857. Admin admin = adminMapper.selectAllByid(string);
  858. if(admin!=null&&StringUtils.isNotBlank(admin.getEmail()))adminIds+=admin.getEmail()+",";
  859. }
  860. if(!nlist.isEmpty())noticeMapper.insertBatch(nlist);
  861. if(StringUtils.isNotBlank(adminIds)) {
  862. adminIds=adminIds.substring(0, adminIds.length()-1);
  863. EmailBo bo = new EmailBo(NoticeStatus.getValueByCode(type), adminIds, a.getDepartmentName(), a.getName(), "请登录查看");
  864. try {
  865. //使用专利邮件模板
  866. SendEmailUtil.getInstance().patentSend(bo);
  867. } catch (UnsupportedEncodingException | MessagingException e) {
  868. throw new BusinessException(new Error( "邮件发送错误","邮件发送错误"));
  869. }
  870. }
  871. }
  872. }