FundManagerOrderServiceImpl.java 24 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472
  1. package com.goafanti.order.service.impl;
  2. import java.io.UnsupportedEncodingException;
  3. import java.math.BigDecimal;
  4. import java.util.Calendar;
  5. import java.util.Date;
  6. import java.util.HashMap;
  7. import java.util.List;
  8. import java.util.Map;
  9. import java.util.UUID;
  10. import javax.mail.MessagingException;
  11. import org.slf4j.Logger;
  12. import org.slf4j.LoggerFactory;
  13. import org.springframework.beans.factory.annotation.Autowired;
  14. import org.springframework.stereotype.Service;
  15. import com.goafanti.admin.bo.AdminListBo;
  16. import com.goafanti.common.bo.EmailBo;
  17. import com.goafanti.common.dao.AdminMapper;
  18. import com.goafanti.common.dao.NoticeMapper;
  19. import com.goafanti.common.dao.TOrderBackMapper;
  20. import com.goafanti.common.dao.TOrderBillNewMapper;
  21. import com.goafanti.common.dao.TOrderBonusMapper;
  22. import com.goafanti.common.dao.TOrderMonthReportMapper;
  23. import com.goafanti.common.dao.TOrderNewMapper;
  24. import com.goafanti.common.dao.TOrderRefundMapper;
  25. import com.goafanti.common.dao.TOrderTaskMapper;
  26. import com.goafanti.common.enums.NoticeStatus;
  27. import com.goafanti.common.model.Notice;
  28. import com.goafanti.common.model.TOrderBack;
  29. import com.goafanti.common.model.TOrderBillNew;
  30. import com.goafanti.common.model.TOrderBonus;
  31. import com.goafanti.common.model.TOrderMonthReport;
  32. import com.goafanti.common.model.TOrderNew;
  33. import com.goafanti.common.model.TOrderRefund;
  34. import com.goafanti.common.model.TOrderTask;
  35. import com.goafanti.common.utils.LoggerUtils;
  36. import com.goafanti.common.utils.SendEmailUtil;
  37. import com.goafanti.common.utils.StringUtils;
  38. import com.goafanti.core.mybatis.BaseMybatisDao;
  39. import com.goafanti.core.mybatis.JDBCIdGenerator;
  40. import com.goafanti.core.mybatis.page.Pagination;
  41. import com.goafanti.core.shiro.token.TokenManager;
  42. import com.goafanti.order.bo.OrderListBo;
  43. import com.goafanti.order.bo.TOrderNewBo;
  44. import com.goafanti.order.enums.ApprovalNewState;
  45. import com.goafanti.order.enums.BonusSubject;
  46. import com.goafanti.order.enums.LiquidationNewState;
  47. import com.goafanti.order.enums.OrderNewState;
  48. import com.goafanti.order.enums.ProcessStatus;
  49. import com.goafanti.order.enums.refundState;
  50. import com.goafanti.order.service.FundManageOrderService;
  51. @Service
  52. public class FundManagerOrderServiceImpl extends BaseMybatisDao<TOrderNewMapper> implements FundManageOrderService {
  53. @Autowired
  54. private TOrderNewMapper tOrderNewMapper;
  55. @Autowired
  56. private AdminMapper adminMapper;
  57. @Autowired
  58. private TOrderBillNewMapper billNewMapper;
  59. @Autowired
  60. private TOrderBackMapper backMapper;
  61. @Autowired
  62. private TOrderRefundMapper refundMapper;
  63. @Autowired
  64. private TOrderBonusMapper bonusMapper;
  65. @Autowired
  66. private TOrderMonthReportMapper monthReportMapper;
  67. @Autowired
  68. private TOrderTaskMapper taskMapper;
  69. @Autowired
  70. JDBCIdGenerator idGenerator;
  71. @Autowired
  72. NoticeMapper noticeMapper;
  73. Logger logger = LoggerFactory.getLogger(FundManagerOrderServiceImpl.class);
  74. @SuppressWarnings("unchecked")
  75. @Override
  76. public Pagination<OrderListBo> allUnassignedOrder(OrderListBo order, Integer pageNo,
  77. Integer pageSize,Integer ob) {
  78. Map<String, Object> params = new HashMap<String, Object>();
  79. params.put("o", order);
  80. params.put("ob", ob);
  81. Pagination<OrderListBo> data = (Pagination<OrderListBo>)findPage("getAllUnassignedListOrder", "getAllUnassignedCountOrder", params, pageNo, pageSize);
  82. return data;
  83. }
  84. @Override
  85. public Integer updateDistributionFinance(String orderNo, String financeId, Integer approval) {
  86. // 先判断订单id和财务专员是否存在或者能够使用
  87. //判断是不是特批的数据
  88. if(approval != ApprovalNewState.TG.getCode() && approval != ApprovalNewState.FTP.getCode()){//特批未通过 2 0
  89. return -1;
  90. }
  91. TOrderNew onew = new TOrderNew();
  92. onew.setOrderNo(orderNo);
  93. onew.setDeleteSign(0);//正常
  94. onew.setApproval(approval);//特批状态
  95. if(approval == ApprovalNewState.FTP.getCode()){
  96. onew.setProcessStatus(ProcessStatus.YPCWGLY.getCode());//已派财务管理员
  97. }
  98. onew.setOrderStatus(OrderNewState.QDSHTG.getCode());//营销管理员审核通过
  99. int idCount = tOrderNewMapper.getCountByIdAndStatus(onew);
  100. int fidCount = adminMapper.getCountById(financeId);
  101. Integer r = null;
  102. if(idCount == 1 && fidCount == 1){
  103. //修改订单流程状态
  104. TOrderNew record = new TOrderNew();
  105. record.setOrderNo(orderNo);
  106. record.setFinanceId(financeId);
  107. record.setProcessStatus(ProcessStatus.YPCWZY.getCode());
  108. r = tOrderNewMapper.updateByPrimaryKeySelective(record);
  109. }else{
  110. //返回错误标志 提示订单编号或者财务专员选择错误
  111. r = -2;
  112. }
  113. return r;
  114. }
  115. @SuppressWarnings("unchecked")
  116. @Override
  117. public Pagination<OrderListBo> financeList(OrderListBo order,
  118. Integer pageNo, Integer pageSize) {
  119. Map<String, Object> params = new HashMap<String, Object>();
  120. params.put("o", order);
  121. Pagination<OrderListBo> data = (Pagination<OrderListBo>)findPage("financeList", "financeCount", params, pageNo, pageSize);
  122. return data;
  123. }
  124. @Override
  125. public Integer updateReject(TOrderBack back) {
  126. // 是否已经收款
  127. BigDecimal bd = billNewMapper.getAmountByOid(back.getOrderNo());
  128. if(bd.compareTo(new BigDecimal(0.0)) == 1){
  129. return 0;//已经收款不能驳回
  130. }
  131. TOrderNewBo b = tOrderNewMapper.getSaleIdByOno(back.getOrderNo());//订单和订单负责人相关信息
  132. if(null == b || StringUtils.isBlank(b.getSalesmanId())){
  133. return -1;
  134. }
  135. //否 可以处理驳回
  136. //修改订单状态
  137. TOrderNew orderNew = new TOrderNew();
  138. orderNew.setOrderNo(back.getOrderNo());
  139. orderNew.setOrderStatus(OrderNewState.YBH.getCode());
  140. int c = tOrderNewMapper.updateByPrimaryKeySelective(orderNew);
  141. //新增驳回数据
  142. if(c>0){
  143. back.setBackStatus(0);
  144. back.setInitiate(TokenManager.getAdminId());//发起人
  145. back.setAccept(b.getSalesmanId()); //查看该订单的负责人
  146. c = backMapper.insertSelective(back);
  147. //发送站内消息
  148. addNotic(back.getOrderNo(),NoticeStatus.ORDER_BACK.getCode(),b.getSalesmanId());
  149. if(StringUtils.isNotBlank(b.getEmail())){ //邮箱不为空发送邮件
  150. AdminListBo a = adminMapper.getDeptNameByAid(TokenManager.getAdminId());
  151. //发送驳回邮件
  152. String content = "<div>客户名称: "+ b.getUserName() +"</div><div>订单编号: " + back.getOrderNo() + "</div>";
  153. EmailBo bo = new EmailBo("订单驳回", b.getEmail(), b.getSalesmanName(), a.getDepartmentName(), a.getName(), content);
  154. try {
  155. SendEmailUtil.getInstance().send(bo);
  156. } catch (UnsupportedEncodingException e) {
  157. e.printStackTrace();
  158. } catch (MessagingException e) {
  159. e.printStackTrace();
  160. }
  161. }
  162. }
  163. return c;
  164. }
  165. @Override
  166. public Integer addReceiptsFlow(TOrderBillNew billNew, String contractNo) {
  167. //判断有没有要加入的金额有没有超过总金额
  168. BigDecimal bill = billNewMapper.getAmountByOid(billNew.getOrderNo());
  169. //获得的单个订单金额数据(首付金额和总金额)
  170. TOrderNew o = tOrderNewMapper.selectByPrimaryKey(billNew.getOrderNo());
  171. if(null == o){
  172. return -2;
  173. }
  174. BigDecimal bd = bill.add(billNew.getTransactionAmount().abs());
  175. //奖金信息
  176. TOrderBonus bonus = new TOrderBonus();
  177. bonus.setId(UUID.randomUUID().toString());
  178. bonus.setOrderNo(billNew.getOrderNo());
  179. bonus.setGrantBy(TokenManager.getAdminId());
  180. int lstaus = 0;//如果订单流水小于首付 lstaus 0
  181. // 0 相等
  182. // -1 小于
  183. // 1 大于
  184. if(bd.compareTo(o.getTotalAmount()) == 1){//如果订单流水总额大于总金额 return -1
  185. return -1;//超过不能添加
  186. }else if(bd.compareTo(o.getTotalAmount()) == 0){//付完款//如果订单流水等于于总金额 lstaus 2
  187. lstaus = 2;
  188. bonus.setBonusSubject(BonusSubject.WK.getCode());//12
  189. //发放给技术员如果付完款所有参与这个项目任务的人都会有结算奖
  190. //获得所有的任务负责人
  191. List<TOrderTask> l = taskMapper.getReceiverByOid(billNew.getOrderNo());
  192. if(null == l || l.size() == 0){
  193. return -3;//没有给将任务分给咨询师(技术员)
  194. }
  195. for (TOrderTask tOrderTask : l) {
  196. if(null == tOrderTask ||null == tOrderTask.getTaskReceiver()){
  197. return -3;
  198. }
  199. bonus.setTaskId(tOrderTask.getId());//任务id
  200. bonus.setGrantTarget(tOrderTask.getTaskReceiver());
  201. bonus.setGrantType(1);
  202. int c = bonusMapper.checkByOnoAndSub(bonus);
  203. //不存在就设置
  204. if(c==0){
  205. bonus.setId(UUID.randomUUID().toString());
  206. bonusMapper.insertSelective(bonus);
  207. }
  208. }
  209. }else if(bd.compareTo(o.getTotalAmount()) == -1){//如果订单流水小于总金额
  210. if(bd.compareTo(o.getFirstAmount()) == 0 || bd.compareTo(o.getFirstAmount()) == 1){//首付完成
  211. //查看首付奖是否存在
  212. TOrderBonus b = new TOrderBonus();
  213. b.setOrderNo(billNew.getOrderNo());
  214. b.setBonusSubject(11);
  215. b.setGrantType(0);
  216. b.setGrantTarget(o.getSalesmanId());
  217. int c = bonusMapper.checkByOnoAndSub(b);
  218. //不存在就设置
  219. if(c==0){
  220. bonus.setBonusSubject(BonusSubject.SF.getCode());//11
  221. }
  222. lstaus = 1;
  223. }
  224. }
  225. //否则新增流水信息
  226. billNew.setBillNo(UUID.randomUUID().toString().replaceAll("-", ""));
  227. //System.out.println("*****************"+billNew.getBillNo());
  228. billNew.setCreater(TokenManager.getAdminId());
  229. int result = billNewMapper.insertSelective(billNew);
  230. //修改订单结算金额和结算状态
  231. //如果已经首付并且流程状态是没有派给咨询师的修改流程状态为4
  232. TOrderNew orderNew = new TOrderNew();
  233. orderNew.setOrderNo(billNew.getOrderNo());
  234. orderNew.setContractNo(contractNo);
  235. //这里的已收金额是以前收的所有金额加上本次收的金额
  236. orderNew.setSettlementAmount(billNew.getTransactionAmount().add(o.getSettlementAmount()));
  237. orderNew.setLiquidationStatus(lstaus);
  238. if((lstaus == LiquidationNewState.WAIT_PAY_LAST_BALANCE.getCode()
  239. || lstaus == LiquidationNewState.ALREADY_PAY.getCode())
  240. && o.getProcessStatus() < ProcessStatus.YPCWZY.getCode()){
  241. //流程状态是3,结算是付款的话
  242. orderNew.setProcessStatus(ProcessStatus.YPZXSGLY.getCode());//4
  243. }
  244. if(result > 0){
  245. result = tOrderNewMapper.updateByPrimaryKeySelective(orderNew);
  246. //如果达到奖金发放要求新增奖金信息
  247. if(null != bonus.getBonusSubject()){
  248. bonus.setId(UUID.randomUUID().toString());
  249. bonus.setGrantTarget(o.getSalesmanId());
  250. //设置发放人类型
  251. bonus.setGrantType(0);
  252. bonusMapper.insertSelective(bonus);
  253. }
  254. }
  255. return result;
  256. }
  257. @Override
  258. public Integer updateChangeRefund(TOrderRefund refund) {
  259. //查看当前退单状态
  260. TOrderRefund d = refundMapper.selectByPrimaryKey(refund.getId());
  261. if(d.getRefundStatus() != refundState.DSH.getCode()){
  262. return -1;
  263. }
  264. //如果审核通过给咨询师和营销员发起退单通知
  265. if(refund.getRefundStatus() == refundState.SHTG.getCode()){
  266. //修改订单状态
  267. TOrderNewBo o = tOrderNewMapper.agreeEmailData(refund.getId());
  268. TOrderNew record = new TOrderNew();
  269. record.setOrderNo(o.getOrderNo());
  270. record.setOrderStatus(OrderNewState.YTD.getCode());//7
  271. record.setProofCount(0.0f);//订单单量为0
  272. tOrderNewMapper.updateByPrimaryKeySelective(record);
  273. //更新统计表
  274. updateCount(o.getOrderNo());
  275. //新增奖金信息表数据
  276. TOrderBonus bonus = new TOrderBonus();
  277. bonus.setId(UUID.randomUUID().toString());
  278. bonus.setOrderNo(o.getOrderNo());
  279. bonus.setGrantBy(TokenManager.getAdminId());
  280. bonus.setGrantTarget(o.getSalesmanId());
  281. bonus.setBonusSubject(BonusSubject.TK.getCode());//16
  282. bonusMapper.insertSelective(bonus);
  283. //退单邮件发送需要的数据
  284. AdminListBo a = adminMapper.getDeptNameByAid(TokenManager.getAdminId());
  285. String content = "<div>退单编号: "+ refund.getId() +"</div><div>客户名称: " + o.getUserName() + "</div>";
  286. content += "<div>订单编号: "+ o.getOrderNo() +"</div>";
  287. if(StringUtils.isNotBlank(o.getEmail())){
  288. EmailBo emailBo = new EmailBo("同意退单", o.getEmail(), o.getSalesmanName(), a.getDepartmentName(), a.getName(), content);
  289. try {
  290. SendEmailUtil.getInstance().send(emailBo);
  291. } catch (UnsupportedEncodingException e) {
  292. e.printStackTrace();
  293. } catch (MessagingException e) {
  294. e.printStackTrace();
  295. }
  296. }
  297. //发送站内消息
  298. addNotic(o.getOrderNo(),NoticeStatus.ORDER_REFUND.getCode(),o.getSalesmanId());//给营销员
  299. //根据订单编号获得所有的技术员
  300. List<TOrderTask> l = taskMapper.getReceiverByOid(o.getOrderNo());
  301. for (TOrderTask tOrderTask : l) {
  302. if(null != tOrderTask && null != tOrderTask.getTaskReceiver()){
  303. addNotic(o.getOrderNo(),NoticeStatus.ORDER_REFUND.getCode(),tOrderTask.getTaskReceiver());//给技术员
  304. //发邮件给技术员
  305. if(StringUtils.isNotBlank(tOrderTask.getEmail())){
  306. EmailBo emailBo = new EmailBo("同意退单", tOrderTask.getEmail(), tOrderTask.getName(), a.getDepartmentName(), a.getName(), content);
  307. try {
  308. SendEmailUtil.getInstance().send(emailBo);
  309. } catch (UnsupportedEncodingException e) {
  310. e.printStackTrace();
  311. } catch (MessagingException e) {
  312. e.printStackTrace();
  313. }
  314. }
  315. }
  316. }
  317. }else{//审核拒绝
  318. //给营销员发通知和邮件
  319. TOrderNewBo o = tOrderNewMapper.agreeEmailData(refund.getId());
  320. addNotic(o.getOrderNo(),NoticeStatus.ORDER_REFUND_REFUSE.getCode(),o.getSalesmanId());//给营销员
  321. AdminListBo a = adminMapper.getDeptNameByAid(TokenManager.getAdminId());
  322. String content = "<div>退单编号: "+ refund.getId() +"</div><div>客户名称: " + o.getUserName() + "</div>";
  323. content += "<div>订单编号: "+ o.getOrderNo() +"</div>";
  324. String email = o.getEmail();
  325. if(StringUtils.isNotBlank(email)){
  326. email = email.substring(0, email.indexOf(","));
  327. String sale = o.getSalesmanName();
  328. sale = sale.substring(0,sale.indexOf(","));
  329. if(email.matches("[\\w\\.\\-]+@([\\w\\-]+\\.)+[\\w\\-]+")){//email格式校验
  330. EmailBo emailBo = new EmailBo("拒绝退单",email, sale, a.getDepartmentName(), a.getName(), content);
  331. try {
  332. SendEmailUtil.getInstance().send(emailBo);
  333. } catch (UnsupportedEncodingException e) {
  334. e.printStackTrace();
  335. } catch (MessagingException e) {
  336. e.printStackTrace();
  337. }
  338. }
  339. }
  340. }
  341. //修改退单审核状态
  342. return refundMapper.updateRefundById(refund);
  343. }
  344. @Override
  345. public Integer addRefundFlow(TOrderBillNew billNew) {
  346. // 查看收款总金额流水
  347. BigDecimal bd = billNewMapper.getAmountByOid(billNew.getOrderNo());
  348. billNew.setTransactionAmount(billNew.getTransactionAmount().abs());//绝对值
  349. int lstaus = 3;
  350. //如果小于要退的金额 return -1
  351. //如果等于要退的金额 lstatus 4
  352. //如果大于 要退的金额 lstatus 3
  353. if(bd.compareTo(billNew.getTransactionAmount()) == -1){
  354. return -1;
  355. }else if(bd.compareTo(billNew.getTransactionAmount()) == 0){
  356. lstaus = 4;
  357. }
  358. //新增退款流水
  359. billNew.setBillNo(UUID.randomUUID().toString().replaceAll("-", ""));
  360. //System.out.println("*****************"+billNew.getBillNo());
  361. billNew.setCreater(TokenManager.getAdminId());
  362. billNew.setTransactionAmount(billNew.getTransactionAmount().negate());// 取负数
  363. int result = billNewMapper.insertSelective(billNew);
  364. //修改订单数据结算状态和结算金额
  365. TOrderNew orderNew = new TOrderNew();
  366. orderNew.setOrderNo(billNew.getOrderNo());
  367. TOrderNew o = tOrderNewMapper.selectByPrimaryKey(billNew.getOrderNo());
  368. //这里修改退款金额数据之前退的金额加上本次退的金额
  369. orderNew.setRefundAmount(billNew.getTransactionAmount().add(o.getRefundAmount()));
  370. orderNew.setLiquidationStatus(lstaus);
  371. if(lstaus == 4){//如果款项全部退完就更改订单状态,这里不一定待商榷
  372. //orderNew.setProcessStatus(6);
  373. }
  374. if(result > 0){
  375. result = tOrderNewMapper.updateByPrimaryKeySelective(orderNew);
  376. }
  377. return result;
  378. }
  379. @Override
  380. public TOrderBillNew selectOneRefundFlow(String BillNo) {
  381. return billNewMapper.getOneRefundFlow(BillNo);
  382. }
  383. @Override
  384. public List<TOrderBillNew> selectOneOrderAllRefundFlow(String orderNo) {
  385. return billNewMapper.getOneOrderAllRefundFlow(orderNo);
  386. }
  387. @Override
  388. public Integer updateProofreading(TOrderNew orderNew) {
  389. // 创建人
  390. orderNew.setProofAid(TokenManager.getAdminId());
  391. //校对状态
  392. orderNew.setProofStatus(1);
  393. //校对时间
  394. orderNew.setProofTime(new Date());
  395. tOrderNewMapper.updateByPrimaryKeySelective(orderNew);
  396. updateCount(orderNew.getOrderNo());
  397. return 0;
  398. }
  399. public void addNotic(String orderNo,Integer type,String aid) {
  400. String id=TokenManager.getAdminId()==null?"1":TokenManager.getAdminId();
  401. AdminListBo a = adminMapper.getDeptNameByAid(id);
  402. String str=NoticeStatus.getValueByCode(type)+": 订单编号 -"+orderNo+", 操作人:"+a.getDepartmentName()+"-"+a.getName()+"。";
  403. Notice n =new Notice();
  404. n.setId(UUID.randomUUID().toString());
  405. n.setAid(aid);//通知人
  406. n.setNoticeType(type);
  407. n.setContent(str);
  408. n.setReaded(0);//未读
  409. noticeMapper.insertSelective(n);
  410. }
  411. private void updateCount(String orderNo){
  412. //获得订单数据
  413. TOrderNew new1 = tOrderNewMapper.selectByPrimaryKey(orderNo);
  414. Calendar cal = Calendar.getInstance();
  415. cal.setTime(new1.getSignTime());
  416. int sy = cal.get(Calendar.YEAR);
  417. int sm = cal.get(Calendar.MONTH);
  418. Integer month = sy*100+(sm+1);
  419. //重新校对月统计
  420. int c = monthReportMapper.updateByMonth(month);
  421. LoggerUtils.debug(logger, "更新订单统计【%s】条。", c);
  422. }
  423. @Override
  424. public int updateContractNo(TOrderNew orderNew) {
  425. return tOrderNewMapper.updateByPrimaryKeySelective(orderNew);
  426. }
  427. }