OrderNewServiceImpl.java 50 KB

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