OrderNewServiceImpl.java 46 KB

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