OrderNewServiceImpl.java 35 KB

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