OrderNewServiceImpl.java 29 KB

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