OrderNewServiceImpl.java 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660
  1. package com.goafanti.order.service.impl;
  2. import java.io.UnsupportedEncodingException;
  3. import java.math.BigDecimal;
  4. import java.text.ParseException;
  5. import java.text.SimpleDateFormat;
  6. import java.util.Date;
  7. import java.util.HashMap;
  8. import java.util.List;
  9. import java.util.Map;
  10. import java.util.UUID;
  11. import javax.mail.MessagingException;
  12. import org.apache.commons.lang3.StringUtils;
  13. import org.apache.poi.xssf.usermodel.XSSFWorkbook;
  14. import org.apache.xmlbeans.impl.xb.xsdschema.Public;
  15. import org.slf4j.Logger;
  16. import org.slf4j.LoggerFactory;
  17. import org.springframework.beans.factory.annotation.Autowired;
  18. import org.springframework.beans.factory.annotation.Value;
  19. import org.springframework.stereotype.Service;
  20. import org.springframework.transaction.annotation.Transactional;
  21. import com.alibaba.fastjson.JSON;
  22. import com.goafanti.admin.bo.AdminListBo;
  23. import com.goafanti.common.bo.EmailBo;
  24. import com.goafanti.common.bo.Error;
  25. import com.goafanti.common.constant.ErrorConstants;
  26. import com.goafanti.common.dao.AdminMapper;
  27. import com.goafanti.common.dao.NoticeMapper;
  28. import com.goafanti.common.dao.OrganizationContactBookMapper;
  29. import com.goafanti.common.dao.TDunLogMapper;
  30. import com.goafanti.common.dao.TOrderBackMapper;
  31. import com.goafanti.common.dao.TOrderDunMapper;
  32. import com.goafanti.common.dao.TOrderNewMapper;
  33. import com.goafanti.common.dao.TOrderRefundMapper;
  34. import com.goafanti.common.dao.TOrderTaskMapper;
  35. import com.goafanti.common.dao.UserLockReleaseMapper;
  36. import com.goafanti.common.enums.NoticeStatus;
  37. import com.goafanti.common.error.BusinessException;
  38. import com.goafanti.common.model.Notice;
  39. import com.goafanti.common.model.OrganizationContactBook;
  40. import com.goafanti.common.model.OrganizationManagement;
  41. import com.goafanti.common.model.TDunLog;
  42. import com.goafanti.common.model.TOrderBack;
  43. import com.goafanti.common.model.TOrderDun;
  44. import com.goafanti.common.model.TOrderNew;
  45. import com.goafanti.common.model.TOrderRefund;
  46. import com.goafanti.common.model.TOrderRefundWithBLOBs;
  47. import com.goafanti.common.model.TOrderTask;
  48. import com.goafanti.common.utils.ExportExcelUtil;
  49. import com.goafanti.common.utils.LoggerUtils;
  50. import com.goafanti.common.utils.SendEmailUtil;
  51. import com.goafanti.core.mybatis.BaseMybatisDao;
  52. import com.goafanti.core.mybatis.JDBCIdGenerator;
  53. import com.goafanti.core.mybatis.page.Pagination;
  54. import com.goafanti.core.shiro.token.TokenManager;
  55. import com.goafanti.customer.bo.LockingReleaseBo;
  56. import com.goafanti.order.bo.OrderDunTaskBo;
  57. import com.goafanti.order.bo.OrderRefundDetailBo;
  58. import com.goafanti.order.bo.TDunLogListBo;
  59. import com.goafanti.order.bo.TOrderNewBo;
  60. import com.goafanti.order.bo.TOrderRefundBo;
  61. import com.goafanti.order.bo.TOrderTaskBo;
  62. import com.goafanti.order.enums.ActiveState;
  63. import com.goafanti.order.enums.ApprovalNewState;
  64. import com.goafanti.order.enums.LiquidationNewState;
  65. import com.goafanti.order.enums.OrderDunSubject;
  66. import com.goafanti.order.enums.OrderNewState;
  67. import com.goafanti.order.enums.ProcessStatus;
  68. import com.goafanti.order.enums.ProjectNewStage;
  69. import com.goafanti.order.enums.TaskState;
  70. import com.goafanti.order.enums.refundState;
  71. import com.goafanti.order.service.OrderNewService;
  72. import com.goafanti.order.service.OrderService;
  73. @Service
  74. public class OrderNewServiceImpl extends BaseMybatisDao<TOrderNewMapper> implements OrderNewService {
  75. @Autowired
  76. private TOrderNewMapper tOrderNewMapper;
  77. @Autowired
  78. private TOrderTaskMapper tOrderTaskMapper;
  79. @Autowired
  80. private TOrderDunMapper tOrderDunMapper;
  81. @Autowired
  82. private TDunLogMapper tDunLogMapper;
  83. @Autowired
  84. private TOrderRefundMapper tOrderRefundMapper;
  85. @Autowired
  86. private TOrderBackMapper tOrderBackMapper;
  87. @Autowired
  88. private OrganizationContactBookMapper organizationContactBookMapper;
  89. @Autowired
  90. private JDBCIdGenerator idGenerator;
  91. @Autowired
  92. private AdminMapper adminMapper;
  93. @Autowired
  94. NoticeMapper noticeMapper;
  95. @Autowired
  96. OrderService orderService;
  97. @Autowired
  98. private UserLockReleaseMapper userLockReleaseMapper;
  99. @Value(value = "${mobileRemindCodeTemplate}")
  100. private String mobileRemindCodeTemplate = null;
  101. @Value(value = "${upload.path}")
  102. private String uploadPath = null;
  103. @Value(value = "${accessKey}")
  104. private String accessKey = null;
  105. @Value(value = "${accessSecret}")
  106. private String accessSecret = null;
  107. Logger logger = LoggerFactory.getLogger(OrderNewServiceImpl.class);
  108. @Override
  109. public int createServiceOrder(String uid, Integer orderType) {
  110. BigDecimal initial = new BigDecimal(0);
  111. TOrderNew t=new TOrderNew();
  112. t.setOrderNo(idGenerator.generateId().toString());
  113. t.setOrderType(orderType);
  114. t.setOrderStatus(OrderNewState.DQD.getCode());
  115. t.setFirstAmount(initial);
  116. t.setTotalAmount(initial);
  117. t.setSettlementAmount(initial);
  118. t.setLiquidationStatus(LiquidationNewState.WAIT_PAY_FIRST_BALANCE.getCode());
  119. t.setProcessStatus(ProcessStatus.YPYXY.getCode());
  120. t.setProjectStatus(ProjectNewStage.DTJ.getCode());
  121. t.setApproval(ApprovalNewState.FTP.getCode());
  122. t.setDeleteSign(0);//0-正常,1-作废,2-锁定
  123. t.setSalesmanId(TokenManager.getAdminId());
  124. t.setCreater(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  125. t.setCreateTime(new Date());
  126. t.setUpdateTime(new Date());
  127. t.setBuyerId(uid);
  128. return tOrderNewMapper.insertSelective(t);
  129. }
  130. @Override
  131. public int addOrderTask(TOrderTask t) {
  132. TOrderNew order=tOrderNewMapper.selectByPrimaryKey(t.getOrderNo());
  133. checkOrder(order,t);
  134. t.setTaskStatus(TaskState.WFP.getCode());
  135. t.setProjectStatus(ProjectNewStage.DTJ.getCode());
  136. if(t.getCommodityPrice()!=null)order.setTotalAmount(order.getTotalAmount());
  137. return tOrderTaskMapper.insertSelective(t);
  138. }
  139. public void checkOrder(TOrderNew order,TOrderTask t){
  140. if(order == null)
  141. throw new BusinessException(new Error(ErrorConstants.ORDER_NOT_EXIST, "" ,""));
  142. if(order.getDeleteSign() == ActiveState.ABOLISH.getCode())
  143. throw new BusinessException(new Error(ErrorConstants.ORDER_ALREADY_FREEZE, order.getOrderNo(),""));
  144. if(order.getDeleteSign() == ActiveState.LOCKING.getCode())
  145. throw new BusinessException(new Error(ErrorConstants.ORDER_ALREADY_REVOKE, order.getOrderNo(),""));
  146. List<LockingReleaseBo> list=userLockReleaseMapper.checkTask(order.getBuyerId(),t.getCommodityId());
  147. if (list.size()>0) {
  148. for (LockingReleaseBo lockingReleaseBo : list) {
  149. if (!lockingReleaseBo.getAid().equals(TokenManager.getAdminId())) {
  150. throw new BusinessException(new Error( "该业务已经被其他人锁定","该业务已经被其他人锁定"));
  151. }
  152. }
  153. }
  154. }
  155. @Override
  156. public int updateOrderTask(TOrderTask t) {
  157. return tOrderTaskMapper.updateByPrimaryKeySelective(t);
  158. }
  159. @Override
  160. public int delectOrderTask(Integer id) {
  161. return tOrderTaskMapper.deleteByPrimaryKey(id);
  162. }
  163. @Override
  164. public List<TOrderTaskBo> selectOrderTask(String orderNo) {
  165. return tOrderTaskMapper.selectOrderTask(orderNo);
  166. }
  167. @Override
  168. public int updateServiceOrder(TOrderNew t, Integer isSubmit) {
  169. TOrderNew t2=tOrderNewMapper.selectByPrimaryKey(t.getOrderNo());
  170. //判断手机号码是否存在
  171. if (StringUtils.isNotBlank(t.getContacts())&&StringUtils.isNotBlank(t.getContactMobile())&&
  172. organizationContactBookMapper.checkContacts(t2.getBuyerId(), t2.getContactMobile(),TokenManager.getAdminId()==null?"1":TokenManager.getAdminId() )>0) {
  173. OrganizationContactBook contactBook=new OrganizationContactBook();
  174. contactBook.setId(UUID.randomUUID().toString());
  175. contactBook.setAid(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  176. contactBook.setUid(t2.getBuyerId());
  177. contactBook.setName(t.getContacts());
  178. contactBook.setMobile(t.getContactMobile());
  179. organizationContactBookMapper.insertSelective(contactBook);
  180. }
  181. if (isSubmit==1) {
  182. t.setOrderStatus(OrderNewState.QDDS.getCode());
  183. t.setProcessStatus(ProcessStatus.YPYXGLY.getCode());
  184. }
  185. if (t2.getApproval()==ApprovalNewState.BH.getCode()||
  186. t2.getOrderStatus()==OrderNewState.QDSHJJ.getCode()||
  187. t2.getOrderStatus()==OrderNewState.YBH.getCode()) {
  188. tOrderBackMapper.updateByOrderNoAndBackStatus(t.getOrderNo());
  189. }
  190. return tOrderNewMapper.updateByPrimaryKeySelective(t);
  191. }
  192. @Override
  193. public TOrderNewBo getOrderNewDetail(String orderNo) {
  194. TOrderNewBo tOrder= tOrderNewMapper.getOrderNewDetail(orderNo);
  195. return tOrder;
  196. }
  197. @Override
  198. public int createOrderDun(String orderDun,String orderNo) {
  199. List<TOrderDun> l= JSON.parseArray(orderDun, TOrderDun.class);
  200. List<TOrderDun> l2=tOrderDunMapper.selectByOrderNoDunSubject(orderNo);
  201. if (l!=null&&!l.isEmpty()) {
  202. for (TOrderDun t : l) {
  203. if (t.getId()==null||t.getId().equals("")) {//Id为空新增
  204. if (tOrderDunMapper.checkOrderDun(t.getDunSubject(),orderNo)>0) {
  205. throw new BusinessException(new Error( "该截点已经存在","该截点已经存在"));
  206. }
  207. t.setId(UUID.randomUUID().toString());
  208. t.setDunBy(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  209. t.setDunStatus(0);//未启动
  210. tOrderDunMapper.insertSelective(t);
  211. }else {
  212. tOrderDunMapper.updateByPrimaryKeySelective(t);
  213. }
  214. }
  215. }
  216. boolean flag=true;
  217. for (TOrderDun t2 : l2) {
  218. if (l.isEmpty()) {
  219. tOrderDunMapper.deleteByPrimaryKey(t2.getId());
  220. }else {
  221. for (TOrderDun t : l) {
  222. if (t2.getId().equals(t.getId())) {//查询集合与返回集合比较查出删除项
  223. flag=false;
  224. }
  225. }
  226. if (t2.getId()!=null&&flag) {
  227. tOrderDunMapper.deleteByPrimaryKey(t2.getId());
  228. }
  229. flag=true;
  230. }
  231. }
  232. return 1;
  233. }
  234. @SuppressWarnings("unchecked")
  235. @Override
  236. public Pagination<TOrderNewBo> orderNewList(String name, String orderNo, String starTime, String endTime,Integer specially,Integer distribution, Integer pageNo,
  237. Integer pageSize) {
  238. Map<String, Object> params = new HashMap<String, Object>();
  239. if(pageSize==null||pageSize<0)pageSize=10;
  240. if(pageNo==null||pageNo<0)pageNo=1;
  241. if (specially!=null&&(specially==0||specially==1||specially==2||specially==5)) {
  242. //0 个人 1 营销员管理 2 驳回 3 特批 4 咨询师管理 5部门订单查询
  243. if (specially!=3&&specially!=4) {
  244. params.put("aid", TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  245. }
  246. //(咨询师管理列表 0 未分配 1部分 2全部)
  247. if(specially==4) params.put("distribution",distribution);
  248. // 计算出所有本部门及所属部门的ID
  249. if(specially==1||specially==5) params.put("deps", orderService.selectMyDeps());
  250. }
  251. params.put("specially",specially);
  252. if (StringUtils.isNotBlank(name)) params.put("name", name);
  253. if (StringUtils.isNotBlank(orderNo)) params.put("orderNo", orderNo);
  254. if (StringUtils.isNotBlank(starTime)) params.put("starTime", starTime);
  255. if (StringUtils.isNotBlank(endTime)) params.put("endTime", endTime+" 23:59:59");
  256. Pagination<TOrderNewBo> p = (Pagination<TOrderNewBo>)findPage("selectOrderNewListByPage", "selectOrderNewListCount", params, pageNo, pageSize);
  257. return p;
  258. }
  259. @Override
  260. public int updateOrderNew(String orderNo, Integer orderStatus,String reason) {
  261. TOrderNew t= new TOrderNew();
  262. TOrderNew t2= tOrderNewMapper.selectByPrimaryKey(orderNo);
  263. t.setOrderNo(orderNo);
  264. if (orderStatus==OrderNewState.QDSHTG.getCode()&&t2.getApproval()==ApprovalNewState.FTP.getCode()) {//如果通过分配给财务管理员
  265. t.setProcessStatus(ProcessStatus.YPCWGLY.getCode());
  266. }
  267. if (orderStatus==OrderNewState.QDSHJJ.getCode()) {//如果不通过新增驳回
  268. t.setProcessStatus(ProcessStatus.YPYXY.getCode());
  269. addBackOrder(orderNo, reason);
  270. }
  271. t.setOrderStatus(orderStatus);
  272. return tOrderNewMapper.updateByPrimaryKeySelective(t);
  273. }
  274. private void addBackOrder(String orderNo, String reason) {
  275. TOrderBack ob=new TOrderBack();
  276. TOrderNew tOrder= tOrderNewMapper.selectByPrimaryKey(orderNo);
  277. ob.setCreateTime(new Date());
  278. ob.setOrderNo(orderNo);
  279. ob.setReason(reason);
  280. ob.setBackStatus(0);//待处理
  281. ob.setInitiate(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  282. ob.setAccept(tOrder.getSalesmanId());
  283. try {
  284. addNoticAndSendEmail(orderNo, null, NoticeStatus.ORDER_BACK.getCode());
  285. } catch (UnsupportedEncodingException | MessagingException e) {
  286. LoggerUtils.error(getClass(), "发送邮件失败", e);
  287. }
  288. tOrderBackMapper.insertSelective(ob);
  289. }
  290. @SuppressWarnings("unchecked")
  291. @Override
  292. public Pagination<TOrderNewBo> dunOrderNewList(String name, String orderNo, String starTime, String endTime,
  293. Integer specially, Integer pageNo, Integer pageSize) {
  294. Map<String, Object> params = new HashMap<String, Object>();
  295. if(pageSize==null||pageSize<0)pageSize=10;
  296. if(pageNo==null||pageNo<0)pageNo=1;
  297. if (StringUtils.isNotBlank(name)) params.put("name", name);
  298. if (StringUtils.isNotBlank(orderNo)) params.put("orderNo", orderNo);
  299. if (StringUtils.isNotBlank(starTime)) params.put("starTime", starTime);
  300. if (StringUtils.isNotBlank(endTime)) params.put("endTime", endTime+" 23:59:59");
  301. Pagination<TOrderNewBo> p = (Pagination<TOrderNewBo>)findPage("selectDunOrderNewListByPage", "selectDunOrderNewListCount", params, pageNo, pageSize);
  302. return p;
  303. }
  304. @Override
  305. public int createDunLog(String dunId,String dumTime,String remarks) {
  306. TDunLog d=new TDunLog();
  307. d.setId(UUID.randomUUID().toString());
  308. d.setDunId(dunId);
  309. d.setDumBy(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  310. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  311. try {
  312. d.setDumTime(sdf.parse(dumTime));
  313. } catch (ParseException e) {
  314. e.printStackTrace();
  315. }
  316. d.setRemarks(remarks);
  317. return tDunLogMapper.insertSelective(d);
  318. }
  319. @Override
  320. public List<TDunLogListBo> selectDunLogList(String dunId) {
  321. return tDunLogMapper.selectByDunId(dunId);
  322. }
  323. @Override
  324. public int addOrderRefund(TOrderRefundWithBLOBs t) {
  325. TOrderNew order =tOrderNewMapper.selectByPrimaryKey(t.getOrderNo());
  326. t.setRefundStatus(refundState.DSH.getCode());
  327. t.setCreateTime(new Date());
  328. t.setInitiate(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  329. //t.setAccept("1");
  330. t.setAccept(order.getFinanceId());
  331. t.setResult("");
  332. TOrderNew tOrder=new TOrderNew();
  333. tOrder.setOrderNo(t.getOrderNo());
  334. tOrder.setOrderStatus(OrderNewState.TDZ.getCode());
  335. tOrderNewMapper.updateByPrimaryKeySelective(tOrder);
  336. return tOrderRefundMapper.insertSelective(t);
  337. }
  338. @Override
  339. public int updateApprovalOrder(String orderNo,Integer confirm,String reason) {
  340. TOrderNew t=new TOrderNew();
  341. t.setOrderNo(orderNo);
  342. if (confirm==2) {
  343. t.setApproval(2);
  344. t.setProcessStatus(ProcessStatus.YPZXSGLY.getCode());
  345. } else {
  346. t.setApproval(3);
  347. t.setOrderStatus(OrderNewState.YBH.getCode());
  348. addBackOrder(orderNo, reason);
  349. }
  350. return tOrderNewMapper.updateByPrimaryKeySelective(t);
  351. }
  352. @Override
  353. public List<TOrderDun> selectOrderDun(String orderNo) {
  354. return tOrderDunMapper.selectByOrderNoDunSubject(orderNo);
  355. }
  356. @Override
  357. public boolean checkOrderMain(TOrderTask t) {
  358. List<TOrderTaskBo> list=tOrderTaskMapper.selectOrderTask(t.getOrderNo());
  359. int flag=0;
  360. if (t.getMain()==1) {
  361. flag++;
  362. }
  363. for (TOrderTask t2 : list) {
  364. if (t2.getMain()==1&&t.getId()!=t2.getId()) {
  365. flag++;
  366. }
  367. }
  368. if (flag>1) {
  369. return true;
  370. }
  371. return false;
  372. }
  373. @Override
  374. public boolean chekeOrderStatus(String orderNo) {
  375. TOrderNew tOrder= tOrderNewMapper.selectByPrimaryKey(orderNo);
  376. if (tOrder.getOrderStatus()!=OrderNewState.QDDS.getCode()) {
  377. return true;
  378. }
  379. return false;
  380. }
  381. @Override
  382. public boolean chekeApprovalOrderStatus(String orderNo) {
  383. TOrderNew tOrder= tOrderNewMapper.selectByPrimaryKey(orderNo);
  384. if (tOrder.getApproval()==ApprovalNewState.FTP.getCode()||
  385. tOrder.getOrderStatus()==OrderNewState.QDSHJJ.getCode()||
  386. tOrder.getOrderStatus()==OrderNewState.YBH.getCode()) {
  387. return true;
  388. }
  389. return false;
  390. }
  391. @Override
  392. public int deleteOrderNew(String orderNo) {
  393. TOrderNew t=tOrderNewMapper.selectByPrimaryKey(orderNo);
  394. if (t.getOrderStatus()==OrderNewState.YBH.getCode()||t.getOrderStatus()==OrderNewState.YTD.getCode()||
  395. t.getOrderStatus()==OrderNewState.DQD.getCode()||t.getOrderStatus()==OrderNewState.QDSHJJ.getCode()) {
  396. t.setOrderNo(orderNo);
  397. t.setDeleteSign(1);//作废
  398. return tOrderNewMapper.updateByPrimaryKeySelective(t);
  399. }
  400. return -1;
  401. }
  402. @Override
  403. public boolean checkOderSettlementAmount(String orderNo) {
  404. TOrderNew tOrder= tOrderNewMapper.selectByPrimaryKey(orderNo);
  405. if (tOrder.getSettlementAmount()==null||
  406. tOrder.getSettlementAmount().doubleValue()==0||
  407. tOrder.getOrderStatus()==OrderNewState.TDZ.getCode()){
  408. return true;
  409. }
  410. return false;
  411. }
  412. @SuppressWarnings("unchecked")
  413. @Override
  414. public Pagination<TOrderRefundBo> orderRefundList(String name, String orderNo, String starTime, String endTime, Integer specially,
  415. Integer pageNo, Integer pageSize) {
  416. Map<String, Object> params = new HashMap<String, Object>();
  417. if(pageSize==null||pageSize<0)pageSize=10;
  418. if(pageNo==null||pageNo<0)pageNo=1;
  419. params.put("aid", TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  420. if (StringUtils.isNotBlank(name)) params.put("name", name);
  421. if (StringUtils.isNotBlank(orderNo)) params.put("orderNo", orderNo);
  422. if (StringUtils.isNotBlank(starTime)) params.put("starTime", starTime);
  423. if (StringUtils.isNotBlank(endTime)) params.put("endTime", endTime+" 23:59:59");
  424. Pagination<TOrderRefundBo> p = (Pagination<TOrderRefundBo>)findPage("selectOrderRefundListByPage", "selectOrderRefundListCount", params, pageNo, pageSize);
  425. return p;
  426. }
  427. @Override
  428. public boolean checkORderTask(String orderNo) {
  429. List<TOrderTaskBo> list=tOrderTaskMapper.selectOrderTask(orderNo);
  430. for (TOrderTaskBo t : list) {
  431. if (t.getMain()==1) {
  432. return false;
  433. }
  434. }
  435. return true;
  436. }
  437. @Override
  438. public boolean checkORderDun(String orderNo) {
  439. List<TOrderDun> list=tOrderDunMapper.selectByOrderNoDunSubject(orderNo);
  440. if (list==null||list.size()<1) {
  441. return true;
  442. }else {
  443. return false;
  444. }
  445. }
  446. /**
  447. * 获取催款数据
  448. */
  449. @SuppressWarnings("null")
  450. @Override
  451. public XSSFWorkbook exportOrderDunData(String name, String orderNo, String starTime, String endTime) {
  452. if(endTime!=null) endTime=endTime+" 23:59:59";
  453. List<TOrderNewBo> list=tOrderDunMapper.getOrderDunData(name,orderNo,starTime,endTime);
  454. if (list==null && list.size()==0) {
  455. return null;
  456. }
  457. String[] comment = {"订单编号","签单时间","客户名称","订单状态","签单金额(万元)","项目状态","结算状态","已收款(万元)","订单负责人","催收科目","催款启动日期"};
  458. String filePath = uploadPath + "/OrderDun";
  459. XSSFWorkbook wb = ExportExcelUtil.exportOrderDunData(list, comment, filePath);
  460. return wb;
  461. }
  462. @Override
  463. public int updateOrderOver(String orderNo) {
  464. TOrderNew t=tOrderNewMapper.selectByPrimaryKey(orderNo);
  465. if (t.getLiquidationStatus()!=LiquidationNewState.ALREADY_PAY.getCode()||
  466. t.getProcessStatus()!=ProcessStatus.YQBFPZXSGLY.getCode()) {
  467. return -1;
  468. }
  469. List<TOrderTaskBo> list=tOrderTaskMapper.selectOrderTask(orderNo);
  470. for (TOrderTaskBo task : list) {
  471. if (task.getTaskStatus()!=TaskState.CLYWC.getCode()) {
  472. return -1;
  473. }
  474. }
  475. t.setOrderStatus(OrderNewState.YJX.getCode());
  476. t.setSettlementTime(new Date());
  477. return tOrderNewMapper.updateByPrimaryKeySelective(t);
  478. }
  479. @Override
  480. public OrderRefundDetailBo orderRefundDetail(String id) {
  481. return tOrderNewMapper.orderRefundDetail(id);
  482. }
  483. @Override
  484. public int updateOrderRefund(TOrderRefundWithBLOBs t) {
  485. return tOrderRefundMapper.updateByPrimaryKeySelective(t);
  486. }
  487. @Override
  488. public int updatetechnicianBackOrder(String orderNo,String reason) {
  489. TOrderNew t=tOrderNewMapper.selectByPrimaryKey(orderNo);
  490. if (t.getSettlementAmount().compareTo(new BigDecimal(0))!=0||
  491. t.getProcessStatus()>ProcessStatus.YPZXSGLY.getCode()) {
  492. return -1;
  493. }
  494. t.setOrderStatus(OrderNewState.YBH.getCode());
  495. addBackOrder(orderNo, reason);
  496. return tOrderNewMapper.updateByPrimaryKeySelective(t);
  497. }
  498. @Override
  499. public List<OrderDunTaskBo> selectAllOrderDun() {
  500. return tOrderDunMapper.getTaskAllOrderDun();
  501. }
  502. @Override
  503. public void updateOrderDun(TOrderDun tDun) {
  504. tOrderDunMapper.updateByPrimaryKeySelective(tDun);
  505. }
  506. public void addNotic(String orderNo,Integer type,AdminListBo a,TOrderNewBo b) {
  507. LoggerUtils.debug(logger, "======================站内消息发送启动===================");
  508. String str=NoticeStatus.getValueByCode(type)+": 订单编号 -"+orderNo+", 操作人:"+a.getDepartmentName()+"-"+a.getName()+"。";
  509. Notice n =new Notice();
  510. n.setId(UUID.randomUUID().toString());
  511. n.setAid(b.getSalesmanId());
  512. n.setNoticeType(type);
  513. n.setContent(str);
  514. n.setReaded(0);//未读
  515. noticeMapper.insertSelective(n);
  516. }
  517. public void sendEmail(String orderNo,String dunId,AdminListBo a,TOrderNewBo b) throws UnsupportedEncodingException, MessagingException{
  518. LoggerUtils.debug(logger, "======================邮件信息发送===================");
  519. String content = "<div>客户名称: "+ b.getUserName() +"</div><div>订单编号: " + orderNo + "</div>";
  520. String tite="订单驳回";
  521. if(StringUtils.isNotBlank(dunId)) {
  522. TOrderDun tDun=tOrderDunMapper.selectByPrimaryKey(dunId);
  523. content +="<div>催收时间: " + new SimpleDateFormat("yyyy-MM-dd").format(tDun.getCreateTime()) +
  524. "</div><div>催收科目: " + OrderDunSubject.getValueByCode(tDun.getDunSubject()) +
  525. "</div><div>催收情况: " + (tDun.getDunStatus()==2?"已完成":"已启动") +"</div>";
  526. tite="催收通知";
  527. }
  528. //发送驳回邮件
  529. EmailBo bo = new EmailBo(tite, b.getEmail(), b.getSalesmanName(), a.getDepartmentName(), a.getName(), content);
  530. LoggerUtils.debug(logger, "tite:"+tite+" Email:"+ b.getEmail()+" 收件人姓名:"+ b.getSalesmanName()+ " 部门:"+a.getDepartmentName()+ " 发件人姓名:"+a.getName()+" 内容:"+ content);
  531. SendEmailUtil.getInstance().send(bo);
  532. LoggerUtils.debug(logger, "=========================================发送邮件成功");
  533. }
  534. @Override
  535. public void addNoticAndSendEmail(String orderNo,OrderDunTaskBo t,Integer type)
  536. throws UnsupportedEncodingException, MessagingException {
  537. TOrderNewBo b = tOrderNewMapper.getSaleIdByOno(type==NoticeStatus.ORDER_DUN.getCode()?t.getOrderNo():orderNo);
  538. String id="1";
  539. if (type==NoticeStatus.ORDER_DUN.getCode()) id=b.getSalesmanId();
  540. if (type==NoticeStatus.ORDER_BACK.getCode()) id=TokenManager.getAdminId()==null?"1":TokenManager.getAdminId();
  541. AdminListBo a = adminMapper.getDeptNameByAid(id);
  542. sendEmail(type==NoticeStatus.ORDER_DUN.getCode()?t.getOrderNo():orderNo, t==null?null:t.getId(), a, b);
  543. addNotic(type==NoticeStatus.ORDER_DUN.getCode()?t.getOrderNo():orderNo,type,a, b);
  544. }
  545. }