OrderNewServiceImpl.java 56 KB

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