OrderProjectServiceImpl.java 68 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762
  1. package com.goafanti.order.service.impl;
  2. import com.alibaba.fastjson.JSON;
  3. import com.goafanti.admin.service.DepartmentService;
  4. import com.goafanti.common.bo.Error;
  5. import com.goafanti.common.bo.*;
  6. import com.goafanti.common.constant.AFTConstants;
  7. import com.goafanti.common.constant.ErrorConstants;
  8. import com.goafanti.common.dao.*;
  9. import com.goafanti.common.enums.ChannelStatus;
  10. import com.goafanti.common.enums.NoticeStatus;
  11. import com.goafanti.common.enums.NoticeTypes;
  12. import com.goafanti.common.enums.OrderLogProcess;
  13. import com.goafanti.common.error.BusinessException;
  14. import com.goafanti.common.model.*;
  15. import com.goafanti.common.utils.AsyncUtils;
  16. import com.goafanti.common.utils.DateUtils;
  17. import com.goafanti.common.utils.LoggerUtils;
  18. import com.goafanti.common.utils.SendEmailUtil;
  19. import com.goafanti.common.utils.excel.NewExcelUtil;
  20. import com.goafanti.core.mybatis.BaseMybatisDao;
  21. import com.goafanti.core.mybatis.page.Pagination;
  22. import com.goafanti.core.shiro.token.TokenManager;
  23. import com.goafanti.customer.service.CustomerService;
  24. import com.goafanti.order.bo.*;
  25. import com.goafanti.order.controller.InputTaskStopLog;
  26. import com.goafanti.order.enums.*;
  27. import com.goafanti.order.service.OrderNewService;
  28. import com.goafanti.order.service.OrderProjectService;
  29. import com.goafanti.organization.bo.OutPaymentNode;
  30. import com.goafanti.techproject.enums.TaskState;
  31. import org.apache.commons.collections4.map.HashedMap;
  32. import org.apache.commons.lang3.StringUtils;
  33. import org.slf4j.Logger;
  34. import org.slf4j.LoggerFactory;
  35. import org.springframework.beans.BeanUtils;
  36. import org.springframework.beans.factory.annotation.Autowired;
  37. import org.springframework.beans.factory.annotation.Value;
  38. import org.springframework.stereotype.Service;
  39. import org.springframework.transaction.annotation.Transactional;
  40. import javax.mail.MessagingException;
  41. import java.io.UnsupportedEncodingException;
  42. import java.math.BigDecimal;
  43. import java.text.ParseException;
  44. import java.text.SimpleDateFormat;
  45. import java.util.*;
  46. @Service
  47. public class OrderProjectServiceImpl extends BaseMybatisDao<TOrderTaskMapper> implements OrderProjectService {
  48. @Autowired
  49. private TOrderTaskMapper tOrderTaskMapper;
  50. @Autowired
  51. private TOrderNewMapper tOrderNewMapper;
  52. @Autowired
  53. private TTaskHoursMapper tTaskHoursMapper;
  54. @Autowired
  55. private TOrderBonusMapper tOrderBonusMapper;
  56. @Autowired
  57. private TTaskLogMapper tTaskLogMapper;
  58. @Autowired
  59. private TOrderLogMapper tOrderLogMapper;
  60. @Autowired
  61. private TaskProgressMapper taskProgressMapper;
  62. @Autowired
  63. private TaskProgressLogMapper taskProgressLogMapper;
  64. @Autowired
  65. private OrganizationContactBookMapper organizationContactBookMapper;
  66. @Autowired
  67. private OrganizationIdentityMapper organizationIdentityMapper;
  68. @Autowired
  69. private TaskLogMapper taskLogMapper;
  70. @Autowired
  71. private OrderNewService orderNewService;
  72. @Autowired
  73. private TaskHoursCountMapper taskHoursCountMapper;
  74. @Autowired
  75. private AdminMapper adminMapper;
  76. @Autowired
  77. private BusinessProjectMapper businessProjectMapper;
  78. @Autowired
  79. private NewOrderDunMapper newOrderDunMapper;
  80. @Autowired
  81. private DepartmentService departmentService;
  82. @Autowired
  83. private TArrearsDunMapper tArrearsDunMapper;
  84. @Autowired
  85. private PaymentNodeMapper paymentNodeMapper;
  86. @Autowired
  87. private TTaskMidMapper tTaskMidMapper;
  88. @Autowired
  89. private UserMapper userMapper;
  90. @Autowired
  91. private UserLockReleaseMapper userLockReleaseMapper;
  92. @Autowired
  93. private UserBusinessMapper userBusinessMapper;
  94. @Autowired
  95. private UserChannelMapper userChannelMapper;
  96. @Autowired
  97. private TaskAttributionLogMapper taskAttributionLogMapper;
  98. @Autowired
  99. private ProjcetCheckLogMapper projcetCheckLogMapper;
  100. @Autowired
  101. private TOrderPaymentMapper tOrderPaymentMapper;
  102. @Autowired
  103. private PublicReleaseMapper publicReleaseMapper;
  104. @Autowired
  105. private MemberLogMapper memberLogMapper;
  106. @Autowired
  107. private UserMidMapper userMidMapper;
  108. @Autowired
  109. private AsyncUtils asyncUtils;
  110. @Autowired
  111. private TTaskMemberMapper tTaskMemberMapper;
  112. @Autowired
  113. private TOrderMidMapper tOrderMidMapper;
  114. @Autowired
  115. private OrderExamineMapper orderExamineMapper;
  116. @Autowired
  117. private NewOrderChangeMapper newOrderChangeMapper;
  118. @Autowired
  119. private TaskStopMapper taskStopMapper;
  120. @Autowired
  121. private TaskStopLogMapper taskStopLogMapper;
  122. @Autowired
  123. private CustomerService customerService;
  124. @Autowired
  125. private TaskTimeMapper taskTimeMapper;
  126. @Autowired
  127. private FinanceCountMapper financeCountMapper;
  128. @Value(value = "${upload.path}")
  129. private String uploadPath = null;
  130. Logger logger = LoggerFactory.getLogger(OrderProjectServiceImpl.class);
  131. @Override
  132. @Transactional
  133. public int updateProjectDistribution(Integer taskId, String taskReceiverId,String remarks,Integer type) {
  134. TOrderTask t=tOrderTaskMapper.selectByPrimaryKey(taskId);
  135. TOrderNew tn=checkDeleteSign(t.getOrderNo());
  136. Date date=new Date();
  137. t.setTaskStatus(TaskState.DISTRIBUTION.getCode());
  138. t.setTaskAllocator(TokenManager.getAdminId());
  139. t.setTaskReceiver(taskReceiverId);
  140. t.setTaskDistributionTime(date);
  141. Admin a=adminMapper.selectByPrimaryKey(taskReceiverId);
  142. insetLog(taskId, taskReceiverId);
  143. addtaskAttributionLog(taskId,taskReceiverId,remarks,type,date);
  144. if (a==null||a.getId()==null) {
  145. throw new BusinessException(new Error("分配人员不存在!","分配人员不存在!"));
  146. }
  147. if (type==0) {
  148. addOrderLog(t.getOrderNo(), OrderLogProcess.XMZJPD.getCode(),remarks);
  149. t.setManagerId(taskReceiverId);
  150. t.setConsultantId(null);
  151. //设置催款触发
  152. orderNewService.pushOrderDun(tn);
  153. //未锁定客户就锁定客户
  154. pushUser(t, tn, date);
  155. //处理客户已派项目
  156. projectDistributionPushUserMid(tn);
  157. }else if(type==1) {
  158. t.setManagerId(taskReceiverId);
  159. t.setConsultantId(null);
  160. }else if(type==2) {
  161. addOrderLog(t.getOrderNo(), OrderLogProcess.XMJLPD.getCode(),remarks);
  162. t.setConsultantId(taskReceiverId);
  163. }else if(type==3) {
  164. t.setConsultantId(taskReceiverId);
  165. }else if(type==4) {
  166. t.setConsultantId(null);
  167. t.setManagerId(taskReceiverId);
  168. }
  169. t.setReceiverName(a.getName());
  170. tOrderTaskMapper.updateByPrimaryKey(t);
  171. List<String> aids = new ArrayList<>();
  172. aids.add(taskReceiverId);
  173. TOrderNewBo order = tOrderNewMapper.getSaleIdByOno(t.getOrderNo());
  174. orderNewService.pushGeneralSendNoticeAndEmail(aids, NoticeStatus.ORDER_TASK_TO.getCode(),order, TokenManager.getAdminId(),0,taskId);
  175. //处理项目统计表
  176. TTaskMid dtails = tTaskMidMapper.getDtails(taskId);
  177. if (type==0){
  178. dtails.setDispatchCount(t.getCommodityQuantity());
  179. dtails.setStockCount(t.getCommodityQuantity());
  180. }
  181. //如果不相等就切换
  182. if (!dtails.getDutyDep().equals(a.getDepartmentId())){
  183. dtails.setDutyDep(a.getDepartmentId());
  184. }
  185. tTaskMidMapper.updateByTid(dtails);
  186. //处理订单信息
  187. checkProjiectAllocation(t.getOrderNo());
  188. pushTaskChange(TokenManager.getAdminId(),taskReceiverId,type,t.getOrderNo());
  189. //派单后设置用户客户统计
  190. if (type==0){
  191. customerService.updateAdminUserCount(tn.getSalesmanId(),date);
  192. }
  193. return 1;
  194. }
  195. /**
  196. *
  197. * @param aid 操作者
  198. * @param taskReceiverId 接收方
  199. * @param type type – 0管理员派单 1经理转交 2经理派单 3咨询师转交 4回退
  200. */
  201. private void pushTaskChange(String aid, String taskReceiverId,Integer type,String orderNo) {
  202. if (type==1||type==3){
  203. orderExamineMapper.updateDimissionTransfer(aid,taskReceiverId,null,orderNo);
  204. }else if (type==2){
  205. OrderExamine o=new OrderExamine();
  206. o.setAid(taskReceiverId);
  207. o.setOrderNo(orderNo);
  208. o.setCreateTime(new Date());
  209. o.setType(0);//咨询师经理
  210. o.setStatus(0);//正常
  211. orderExamineMapper.insertSelective(o);
  212. }else if (type==4){
  213. orderExamineMapper.updateBack(aid,taskReceiverId,orderNo);
  214. }
  215. newOrderChangeMapper.updateTaskExamineName(aid,taskReceiverId,OrderChangeProcess.JSY.getCode());
  216. newOrderChangeMapper.updateTaskExamineName(aid,taskReceiverId,OrderChangeProcess.JSJL.getCode());
  217. }
  218. private void projectDistributionPushUserMid(TOrderNew tn) {
  219. if (tn.getProcessStatus()==ProcessStatus.YPZXSGLY.getCode()){
  220. UserMid um=new UserMid();
  221. String taskNames=userMidMapper.getUserTaskNames(tn.getBuyerId());
  222. UserMid use=userMidMapper.getUserDtails(tn.getBuyerId());
  223. um.setUid(tn.getBuyerId());
  224. um.setTaskNames(taskNames);
  225. um.setLastSigningTime(tn.getCreateTime());
  226. if(tn.getSalesType()!=null){
  227. um.setLastSalesType(tn.getSalesType());
  228. }
  229. BigDecimal signAmount;
  230. Integer signNumber;
  231. if (use!=null){
  232. if (use.getFirstSigningTime() != null) {
  233. um.setFirstSigningTime(use.getFirstSigningTime()); }
  234. if (use.getSignAmount() != null) {
  235. signAmount=use.getSignAmount().add(tn.getTotalAmount());
  236. }else{
  237. signAmount=new BigDecimal(0).add(tn.getTotalAmount());
  238. }
  239. if (use.getSignNumber()!=null){
  240. signNumber=use.getSignNumber()+1;
  241. }else {
  242. signNumber=1;
  243. }
  244. }else {
  245. signAmount=new BigDecimal(0).add(tn.getTotalAmount());
  246. signNumber=1;
  247. }
  248. um.setSignAmount(signAmount);
  249. um.setSignNumber(signNumber);
  250. userMidMapper.updateByUid(um);
  251. }
  252. }
  253. /**
  254. * 推动客户、业务渠道的锁定
  255. * @param t
  256. * @param tn
  257. * @param date
  258. */
  259. private void pushUser(TOrderTask t, TOrderNew tn, Date date) {
  260. if (userMapper.checkLock(tn.getBuyerId())<1) {
  261. userLockReleaseMapper.updateByAidAndUid(tn.getSalesmanId(),tn.getBuyerId());
  262. userMapper.updateShareType(tn.getBuyerId(),tn.getSalesmanId());
  263. }
  264. //未锁定业务就锁定业务
  265. if (userLockReleaseMapper.checkLock(tn.getSalesmanId(),tn.getBuyerId(),t.getCommodityId())<1) {
  266. UserLockRelease ulr=new UserLockRelease();
  267. ulr.setId(UUID.randomUUID().toString());
  268. ulr.setBusinessProjectId(t.getCommodityId());
  269. ulr.setType(1);
  270. ulr.setUid(tn.getBuyerId());
  271. ulr.setAid(tn.getSalesmanId());
  272. ulr.setStatus(0);
  273. ulr.setLockTime(date);
  274. userLockReleaseMapper.insertSelective(ulr);
  275. }
  276. UserBusiness ub=new UserBusiness();
  277. ub.setId(UUID.randomUUID().toString());
  278. ub.setUid(tn.getBuyerId());
  279. ub.setAid(tn.getSalesmanId());
  280. ub.setFollowSituation(5);
  281. ub.setCustomerStatus(4);
  282. ub.setCreateTime(date);
  283. ub.setUpdateTime(date);
  284. ub.setRemarks("派单自动锁定客户");
  285. ub.setBusinessProjectId(t.getCommodityId());
  286. userBusinessMapper.insertSelective(ub);
  287. //如果是渠道客户更新渠道表
  288. UserChannel uc=new UserChannel();
  289. uc.setUid(tn.getBuyerId());
  290. uc.setStatus(ChannelStatus.YQD.getCode());
  291. uc.setSignTime(date);
  292. userChannelMapper.updateByUid(uc);
  293. //标记最新的打卡
  294. publicReleaseMapper.updateSignByAidAndUid(tn.getBuyerId(),tn.getSalesmanId());
  295. }
  296. private void addtaskAttributionLog(Integer taskId, String taskReceiverId, String remarks, Integer type, Date date) {
  297. TaskAttributionLog log=new TaskAttributionLog(taskId,TokenManager.getAdminId(),taskReceiverId,remarks,type,date);
  298. taskAttributionLogMapper.insertSelective(log);
  299. }
  300. public TOrderNew checkDeleteSign(String orderNo) {
  301. TOrderNew t=tOrderNewMapper.selectByPrimaryKey(orderNo);
  302. if(t.getDeleteSign()==2||t.getDeleteSign()==3) throw new BusinessException(new Error(ErrorConstants.ORDER_ALREADY_REVOKE, t.getOrderNo(),""));
  303. return t;
  304. }
  305. public void addOrderLog(String orderNo, Integer code,String remarks) {
  306. TOrderLog tl=new TOrderLog();
  307. tl.setOrderNo(orderNo);
  308. tl.setProcess(code);
  309. tl.setAid(TokenManager.getAdminId());
  310. if(null!=remarks)tl.setRemarks(remarks);
  311. tOrderLogMapper.insertSelective(tl);
  312. }
  313. public void checkProjiectAllocation(String orderNo) {
  314. TOrderNew tNew=new TOrderNew();
  315. tNew.setOrderNo(orderNo);
  316. tNew.setProcessStatus(getOrderProcessStatus(orderNo));
  317. tNew.setExamineName("");
  318. tOrderNewMapper.updateByPrimaryKeySelective(tNew);
  319. updateMidServiceProject(orderNo);
  320. }
  321. @Override
  322. public Integer getOrderProcessStatus(String orderNo) {
  323. Integer processStatus=ProcessStatus.YPZXSGLY.getCode();
  324. List<TOrderTaskBo> taskBos=tOrderTaskMapper.selectOrderTaskAll(orderNo,4);
  325. int i=0;
  326. for (TOrderTaskBo to : taskBos) {
  327. if (to.getTaskStatus()>TaskState.UN_DISTRIBUTION.getCode()&&to.getTaskStatus()<TaskState.INVALID.getCode()) {
  328. i++;
  329. }
  330. }
  331. if (i==taskBos.size()) {
  332. processStatus=ProcessStatus.YQBFPZXSGLY.getCode();
  333. }else if(i>0&&i<taskBos.size()){
  334. processStatus=ProcessStatus.YBFPZXSGLY.getCode();;
  335. }else if(i==0){
  336. processStatus=ProcessStatus.YPZXSGLY.getCode();
  337. }
  338. return processStatus;
  339. }
  340. private void insetLog(Integer taskId, String taskReceiverId) {
  341. TTaskLog tl=new TTaskLog();
  342. tl.setCreateTime(new Date());
  343. tl.setTaskId(taskId);
  344. tl.setTaskAllocator(TokenManager.getAdminId());
  345. tl.setTaskReceiver(taskReceiverId);
  346. tTaskLogMapper.insertSelective(tl);
  347. }
  348. @SuppressWarnings("unchecked")
  349. @Override
  350. public Pagination<TOrderTaskListBo> orderTaskList(inuptTaskListBo ib) {
  351. Map<String, Object> params = new HashMap<String, Object>();
  352. if(ib.getPageSize()==null||ib.getPageSize()<0)ib.setPageSize(10);
  353. if(ib.getPageNo()==null||ib.getPageNo()<0)ib.setPageNo(1);
  354. params.put("outsource", ib.getOutsource()==null?0:ib.getOutsource());
  355. if (null!=ib.getSpecially()) params.put("specially", ib.getSpecially());
  356. if (StringUtils.isNotBlank(ib.getName())) params.put("name", ib.getName());
  357. if (StringUtils.isNotBlank(ib.getDeps())) params.put("deps", departmentService.parseArray(ib.getDeps()));
  358. if (StringUtils.isNotBlank(ib.getOrderNo())) params.put("orderNo", ib.getOrderNo());
  359. if (StringUtils.isNotBlank(ib.getContractNo())) params.put("contractNo", ib.getContractNo());
  360. if (ib.getProjectStatus() !=null ) params.put("projectStatus", ib.getProjectStatus());
  361. if (StringUtils.isNotBlank(ib.getTaskId())) params.put("taskId", ib.getTaskId());
  362. if (ib.getApproval() !=null) params.put("approval", ib.getApproval());
  363. if (StringUtils.isNotBlank(ib.getAdminName())) params.put("adminName", ib.getAdminName());
  364. if (StringUtils.isNotBlank(ib.getStartTime())) params.put("startTime", ib.getStartTime());
  365. if (StringUtils.isNotBlank(ib.getEndTime())) params.put("endTime", ib.getEndTime());
  366. if (null != ib.getTaskStatus()) params.put("taskStatus", ib.getTaskStatus());
  367. if (ib.getOutsourceStatus() !=null) params.put("outsourceStatus", ib.getOutsourceStatus());
  368. if (ib.getCid() !=null) params.put("cid", ib.getCid());
  369. List<String> fids=new ArrayList<>();
  370. if (TokenManager.hasRole(AFTConstants.FINANCE_ADMIN) ||TokenManager.hasRole(AFTConstants.SUPERADMIN)||
  371. TokenManager.hasRole(AFTConstants.CED)||TokenManager.hasRole(AFTConstants.APPROVAL_DECISION)||
  372. TokenManager.hasRole(AFTConstants.VICE_CEO)) {
  373. params.put("role", 2);
  374. }else if (TokenManager.hasRole(AFTConstants.FINANCE_MANAGER)) {
  375. params.put("role", 1);
  376. fids =adminMapper.selectBySuperId(TokenManager.getAdminId());
  377. params.put("fids",fids);
  378. }else if (TokenManager.hasRole(AFTConstants.FINANCE)) {
  379. params.put("role", 1);
  380. fids.add(TokenManager.getAdminId());
  381. params.put("fids",fids);
  382. } else {
  383. params.put("role", 0);
  384. params.put("aid", TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  385. }
  386. Pagination<TOrderTaskListBo> p = (Pagination<TOrderTaskListBo>)findPage("selectOrderTaskListByPage", "selectOrderTaskListCount", params, ib.getPageNo(), ib.getPageSize());
  387. List<TOrderTaskListBo> list=(List<TOrderTaskListBo>) p.getList();
  388. for (TOrderTaskListBo t : list) {
  389. if(t.getSplitStatus()==1) {
  390. List<TOrderTaskListBo> l=splitProjectList(t.getId(),1);
  391. t.setSplitList(l);
  392. }
  393. }
  394. return p;
  395. }
  396. @Override
  397. public TOrderTaskDetailBo orderTaskDetail(Integer id) {
  398. TOrderTaskDetailBo t=tOrderTaskMapper.getOrderTaskDetail(id);
  399. TaskTime tt=new TaskTime();
  400. tt.setTid(t.getId());
  401. tt.setProjectStatus(t.getProjectStatus());
  402. List<TaskTime> taskTimes = taskTimeMapper.selectByTidAndProject(tt);
  403. Map<String,Object> map=new HashMap<>();
  404. for (TaskTime e : taskTimes) {
  405. Map<String,Object> param=new HashMap<>();
  406. param.put("date",DateUtils.formatDate(e.getDateTime(),AFTConstants.YYYYMMDD));
  407. param.put("title",NewProjectStatus.getValueByCode(e.getProjectStatus()));
  408. map.put(e.getProjectStatus().toString(),param);
  409. }
  410. t.setTimeRecord(JSON.toJSONString(map));
  411. if (TokenManager.hasRole(AFTConstants.SUPERADMIN)||TokenManager.hasRole(AFTConstants.APPROVAL_DECISION)
  412. ||TokenManager.hasRole(AFTConstants.CUSTOMER_SERVICE)
  413. ||TokenManager.getAdminId().equals(t.getTaskReceiver())) {
  414. return t;
  415. }else {
  416. t.setContacts("***");
  417. t.setContactMobile("***");
  418. t.setLegalPerson("***");
  419. t.setLegalPersonTel("***");
  420. t.setOutsourceName("****");
  421. t.setOutsourcePrice("****");
  422. t.setDeclareUser("****");
  423. t.setDeclarePwd("****");
  424. t.setCertificateNumber("****");
  425. return t;
  426. }
  427. }
  428. @Override
  429. @Transactional
  430. public int updateOrderTask(TOrderTaskDetailBo t) {
  431. TOrderTask task=new TOrderTask();
  432. TOrderNew tn=checkDeleteSign(t.getOrderNo());
  433. task.setAttachmentUrl(t.getAttachmentUrl());
  434. task.setId(Integer.valueOf(t.getId()));
  435. task.setTaskComment(t.getTaskComment());
  436. task.setCertificateNumber(t.getCertificateNumber());
  437. task.setStatus(t.getStatus());
  438. task.setFormRetrieve(t.getFormRetrieve());
  439. task.setTaskRefund(t.getTaskRefund());
  440. task.setRefundContent(t.getRefundContent());
  441. task.setRetrieveContent(t.getRetrieveContent());
  442. task.setDeclareUser(t.getDeclareUser());
  443. task.setDeclarePwd(t.getDeclarePwd());
  444. task.setArrivalMoney(t.getArrivalMoney());
  445. task.setSetUpAmount(t.getSetUpAmount());
  446. task.setOutsourceName(t.getOutsourceName());
  447. task.setDeclarationBatch(t.getDeclarationBatch());
  448. task.setSetUpStatus(t.getSetUpStatus());
  449. if(t.getSetUpTime()!=null)task.setSetUpTime(DateUtils.StringToDate(t.getSetUpTime(), AFTConstants.YYYYMMDD));
  450. task.setSpotCheckStatus(t.getSpotCheckStatus());
  451. task.setHighTechStatus(t.getHighTechStatus());
  452. task.setSpecialComment(t.getSpecialComment());
  453. if(StringUtils.isNotBlank(t.getOutsourcePrice()))task.setOutsourcePrice(new BigDecimal(t.getOutsourcePrice()));
  454. if (t.getIfCertificationFee()!=null&&t.getIfCertificationFee()==1) {
  455. task.setCertificationCorporate(t.getCertificationCorporate());
  456. task.setCertificationFee(t.getCertificationFee());
  457. }
  458. //根据修改的修改订单法人与联系人
  459. if(StringUtils.isNotEmpty(t.getContacts()))tn.setContacts(t.getContacts());
  460. if(StringUtils.isNotEmpty(t.getContactMobile())) tn.setContactMobile(t.getContactMobile());
  461. if(StringUtils.isNotEmpty(t.getLegalPerson()))tn.setLegalPerson(t.getLegalPerson());
  462. if(StringUtils.isNotEmpty(t.getLegalPersonTel()))tn.setLegalPersonTel(t.getLegalPersonTel());
  463. tOrderNewMapper.updateByPrimaryKeySelective(tn);
  464. //修改公司地址信息
  465. if (null!=t.getLocationProvince()||null!=t.getLocationArea()||null!=t.getLocationCity()||null!=t.getPostalAddress()) {
  466. OrganizationIdentity org=new OrganizationIdentity();
  467. org.setUid(tn.getBuyerId());
  468. org.setLocationProvince(t.getLocationProvince());
  469. org.setLocationArea(t.getLocationArea());
  470. org.setLocationCity(t.getLocationCity());
  471. org.setPostalAddress(t.getPostalAddress());
  472. organizationIdentityMapper.updateServiceByUid(org);
  473. }
  474. //修改公司联系人
  475. int adcount=organizationContactBookMapper.checkContacts(tn.getBuyerId(), t.getContactMobile(),tn.getSalesmanId());
  476. if (StringUtils.isNotBlank(t.getContacts())&&StringUtils.isNotBlank(t.getContactMobile())&&adcount<1) {
  477. OrganizationContactBook contactBook=new OrganizationContactBook();
  478. contactBook.setId(UUID.randomUUID().toString());
  479. contactBook.setAid(tn.getSalesmanId());
  480. contactBook.setUid(tn.getBuyerId());
  481. contactBook.setName(t.getContacts());
  482. contactBook.setMobile(t.getContactMobile());
  483. organizationContactBookMapper.insertSelective(contactBook);
  484. }
  485. //新增结算奖金信息
  486. checkSettlementAward(tn,task);
  487. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  488. try {
  489. if(StringUtils.isNotBlank(t.getStartDate()))task.setTaskStartTime(sdf.parse(t.getStartDate()));
  490. if(StringUtils.isNotBlank(t.getEndDate()))task.setTaskEndTime(sdf.parse(t.getEndDate()));
  491. if(StringUtils.isNotBlank(t.getAcceptDate()))task.setAcceptTime(sdf.parse(t.getAcceptDate()));
  492. if(StringUtils.isNotBlank(t.getReviewDate()))task.setReviewTime(sdf.parse(t.getReviewDate()));
  493. if(StringUtils.isNotBlank(t.getPublicityDate()))task.setPublicityTime(sdf.parse(t.getPublicityDate()));
  494. if(StringUtils.isNotBlank(t.getLicenceDate()))task.setLicenceTime(sdf.parse(t.getLicenceDate()));
  495. } catch (ParseException e) {
  496. e.printStackTrace();
  497. }
  498. tOrderTaskMapper.updateByPrimaryKeySelective(task);
  499. //项目中间表修改
  500. if (t.getUrgentDay()!=null||t.getIfMaterial()!=null||t.getRejectCount()!=null||
  501. t.getAcceptCount()!=null||t.getAuthorizeCount()!=null||t.getSpotCheckStatus()!=null) {
  502. TTaskMid tm=new TTaskMid();
  503. tm.setTid(task.getId());
  504. if (t.getUrgentDay()!=null)tm.setUrgentDay(t.getUrgentDay());
  505. if (t.getIfMaterial()!=null)tm.setIfMaterial(t.getIfMaterial());
  506. if (t.getRejectCount()!=null)tm.setRejectCount(t.getRejectCount());
  507. if (t.getAcceptCount()!=null)tm.setAcceptCount(t.getAcceptCount());
  508. if (t.getAuthorizeCount()!=null)tm.setAuthorizeCount(t.getAuthorizeCount());
  509. if (t.getSpotCheckStatus()==1||t.getSpotCheckStatus()==2){
  510. tm.setSpotCheckCount(t.getCommodityQuantity());
  511. if (t.getSpotCheckStatus()==2){
  512. tm.setFailCount(t.getCommodityQuantity());
  513. }
  514. }
  515. tTaskMidMapper.updateByTid(tm);
  516. }
  517. TaskLog tl=new TaskLog();
  518. tl.setCreateTime(new Date());
  519. tl.setTaskId(t.getId());
  520. tl.setAid(TokenManager.getAdminId());
  521. //项目触发发催款
  522. return 1;
  523. }
  524. public int updateProjectStatus(UpdateProjectStatusBo b) {
  525. TOrderTask t=new TOrderTask();
  526. t.setId(b.getTid());
  527. t.setProjectStatus(b.getProjectStatus());
  528. t.setTimeRecord(b.getTimeRecord());
  529. t.setCertificateNumber(b.getCertificateNumber());
  530. if(b.getSetUpAmount()!=null)t.setSetUpAmount(new BigDecimal(b.getSetUpAmount()));
  531. if (b.getPubicityUrl()!=null)t.setPubicityUrl(b.getPubicityUrl());
  532. TOrderTask task2=tOrderTaskMapper.selectByPrimaryKey(b.getTid());//查询出项目信息
  533. if(b.getProjectStatus()!=task2.getProjectStatus()||!b.getTimeRecord().equals(task2.getTimeRecord())){
  534. TTaskMid taskMid = new TTaskMid();
  535. taskMid.setTid(b.getTid());
  536. if(b.getProjectStatus()==NewProjectStatus.YLX.getCode()||b.getProjectStatus()==NewProjectStatus.YNGS.getCode()){
  537. t.setSetUpStatus(1);
  538. taskMid.setSetUpCount(task2.getCommodityQuantity());
  539. if (b.getProjectStatus()==NewProjectStatus.YNGS.getCode()){
  540. t.setIfPublicity(1);
  541. taskMid.setPromulgateCount(task2.getCommodityQuantity());
  542. }
  543. }else if (b.getProjectStatus().equals(NewProjectStatus.YWCXZ.getCode())||b.getProjectStatus().equals(NewProjectStatus.YXZ.getCode())||
  544. b.getProjectStatus().equals(NewProjectStatus.D1NWC.getCode())||b.getProjectStatus().equals(NewProjectStatus.D2NWC.getCode())||
  545. b.getProjectStatus().equals(NewProjectStatus.D3NWC.getCode())||b.getProjectStatus().equals(NewProjectStatus.QBWC.getCode())
  546. ){
  547. //完成时通知客服
  548. completeSendCustomerService(b.getTid());
  549. }
  550. //大于3计做已完成 不计做库存
  551. if (b.getProjectStatus()>3){
  552. taskMid.setCompleteCount(task2.getCommodityQuantity());
  553. taskMid.setStockCount(0);
  554. }
  555. if (taskMid.getPromulgateCount()!=null||taskMid.getSetUpCount()!=null||
  556. taskMid.getCompleteCount()!=null ||taskMid.getStockCount()!=null){
  557. tTaskMidMapper.updateByTid(taskMid);
  558. }
  559. //做计时处理
  560. pushTaskTimes(t);
  561. tOrderTaskMapper.updateByPrimaryKeySelective(t);
  562. projectSplitPush(b.getTid(), b.getProjectStatus(),task2);
  563. pushTaskLog(b.getTid(), b.getProjectStatus());
  564. updateMidServiceProject(task2.getOrderNo());
  565. }
  566. return 1;
  567. }
  568. private void pushTaskTimes(TOrderTask t) {
  569. Map<String,Object> map = JSON.parseObject(t.getTimeRecord(), Map.class);
  570. for (String key : map.keySet()) {
  571. Map map1 = JSON.parseObject(map.get(key).toString(), Map.class);
  572. TaskTime tt=new TaskTime();
  573. tt.setTid(t.getId());
  574. tt.setProjectStatus(Integer.valueOf(key));
  575. String date = map1.get("date").toString();
  576. tt.setDateTime(DateUtils.StringToDate(date,AFTConstants.YYYYMMDD));
  577. int i = taskTimeMapper.updateByTidAndProjectSelective(tt);
  578. if (i==0){
  579. taskTimeMapper.insertSelective(tt);
  580. }
  581. }
  582. }
  583. private void completeSendCustomerService(Integer id) {
  584. OrderOperator orderOperator = tOrderTaskMapper.selectAidByParam(id);
  585. String content=String.format("[%s]企业[%s]项目已完成,订单编号[%s]。",orderOperator.getBuyerName(),orderOperator.getProjectName(),orderOperator.getOrderNo());
  586. List<Admin> list =adminMapper.getAdminRoleTypeList(AFTConstants.CUSTOMER_SERVICE);
  587. List<Notice> notices=new ArrayList<>();
  588. for (Admin admin : list) {
  589. Notice notice=new Notice();
  590. notice.setId(UUID.randomUUID().toString());
  591. notice.setNoticeType(NoticeStatus.COMPLETES_PROJECT.getCode());
  592. notice.setType(NoticeTypes.getType(NoticeStatus.COMPLETES_PROJECT.getCode()));
  593. notice.setAid(admin.getId());
  594. notice.setCreateTime(new Date());
  595. notice.setContent(content);
  596. notice.setReaded(0);
  597. notices.add(notice);
  598. }
  599. asyncUtils.addNoticeBatch(notices);
  600. }
  601. /**
  602. * 推动项目日志
  603. * @param tid
  604. * @param projectStatus
  605. */
  606. private void pushTaskLog(Integer tid,Integer projectStatus) {
  607. TaskLog tl = new TaskLog();
  608. tl.setCreateTime(new Date());
  609. tl.setTaskId(tid);
  610. tl.setAid(TokenManager.getAdminId());
  611. StringBuffer s = new StringBuffer("项目状态修改为:");
  612. s.append(NewProjectStatus.getValueByCode(projectStatus));
  613. tl.setContent(s.toString());
  614. taskLogMapper.insertSelective(tl);
  615. }
  616. //推动项目计算及催款
  617. private void projectSplitPush(Integer tid, Integer projectStatus,TOrderTask task2) {
  618. //0否 1父拆分 2子拆分 如果没有拆分
  619. if (task2.getSplitStatus()==0) {
  620. pushOrderDunAndPaymentNode(tid,projectStatus,task2);
  621. //如果是子项目
  622. }else if (task2.getSplitStatus()==2){
  623. //查出父项目
  624. List<TOrderTaskListBo> list=tOrderTaskMapper.splitProjectList(task2.getSplitSuper(),null);
  625. //设置一个比较大的流程数字,然后取最小的
  626. Integer i=28;
  627. for (TOrderTaskListBo tt : list) {
  628. if (tt.getProjectStatus()<i) i=tt.getProjectStatus();
  629. }
  630. TOrderTask fatherTask=new TOrderTask();
  631. fatherTask.setId(task2.getSplitSuper());
  632. fatherTask.setProjectStatus(i);
  633. tOrderTaskMapper.updateByPrimaryKeySelective(fatherTask);
  634. TOrderTask task3=tOrderTaskMapper.selectByPrimaryKey(task2.getSplitSuper());
  635. //设置父任务
  636. TOrderTaskDetailBo t2=new TOrderTaskDetailBo();
  637. t2.setOrderNo(task2.getOrderNo());
  638. t2.setId(task2.getSplitSuper());
  639. t2.setProjectStatus(task3.getProjectStatus());
  640. pushOrderDunAndPaymentNode(t2.getId(),t2.getProjectStatus(),task3);
  641. }
  642. if (task2.getSuperId()!=null) {//有父项目
  643. TOrderTask task3 =tOrderTaskMapper.selectBySuperId(task2.getSuperId());
  644. task3.setId(Integer.valueOf(task2.getSuperId()));
  645. task3.setSuperId(null);
  646. tOrderTaskMapper.updateByPrimaryKeySelective(task3);
  647. TOrderTask task4 = tOrderTaskMapper.selectByPrimaryKey(Integer.valueOf(task2.getSuperId()));
  648. meanwhileUpdateOrder(task4);
  649. }else {
  650. meanwhileUpdateOrder(task2);
  651. }
  652. }
  653. /**
  654. * 项目状态达到触发催款
  655. * @param tid
  656. * @param projectStatus
  657. * @param task2
  658. */
  659. private void pushOrderDunAndPaymentNode(Integer tid,Integer projectStatus,TOrderTask task2) {
  660. List<OutNewOrderDunBo> list=newOrderDunMapper.selectByTid(tid);
  661. for (OutNewOrderDunBo ob : list) {
  662. if (ob!=null) {
  663. boolean flag=false;
  664. if((ob.getProjectType()==OrderDunProjectType.CGZH.getCode()&&ob.getDunType()==2&&//成果转化 验收
  665. projectStatus==NewProjectStatus.YWCXZ.getCode()))flag=true;
  666. else if((ob.getProjectType()==OrderDunProjectType.COMMON.getCode()&&ob.getDunType()==2&&//通用 公示
  667. projectStatus==NewProjectStatus.YTJ.getCode()))flag=true;
  668. else if((ob.getProjectType()==OrderDunProjectType.COMMON.getCode()&&ob.getDunType()==3&&//通用 下证
  669. projectStatus==NewProjectStatus.YWCXZ.getCode()))flag=true;
  670. else if((ob.getProjectType()==OrderDunProjectType.KJXM.getCode()&&ob.getDunType()==2&&//科技项目 立项或者公示
  671. projectStatus==NewProjectStatus.YLX.getCode()))flag=true;
  672. else if((ob.getProjectType()==OrderDunProjectType.KJXM.getCode()&&ob.getDunType()==3&&//科技项目 拨款
  673. projectStatus==NewProjectStatus.LXYBK.getCode()))flag=true;
  674. else if((ob.getProjectType()==OrderDunProjectType.KJJR.getCode()&&ob.getDunType()==2&&//科技金融 拨款
  675. projectStatus==NewProjectStatus.YWCXZ.getCode()))flag=true;
  676. else if((ob.getProjectType()==OrderDunProjectType.RJKF.getCode()&&ob.getDunType()==2&&//软件开发 立项
  677. projectStatus==NewProjectStatus.YTJ.getCode()))flag=true;
  678. else if((ob.getProjectType()==OrderDunProjectType.RJKF.getCode()&&ob.getDunType()==3&&//软件开发 验收
  679. projectStatus==NewProjectStatus.YWCXZ.getCode()))flag=true;
  680. else if(ob.getProjectType()==OrderDunProjectType.ZSCQ.getCode()){//知识产权 公示 专利受理、转让(项目已提交),软著下证
  681. if(ob.getDunType()==3&&projectStatus==NewProjectStatus.YWCXZ.getCode()) {
  682. flag=true;
  683. }else if (ob.getDunType()==2) {
  684. BusinessProject bp=businessProjectMapper.selectByPrimaryKey(task2.getCommodityId());
  685. if (bp.getType()==0&&projectStatus==NewProjectStatus.YWCXZ.getCode()) {
  686. flag=true;
  687. }
  688. if (bp.getType()==1&&projectStatus==NewProjectStatus.YTJ.getCode()) {
  689. flag=true;
  690. }
  691. if (bp.getType()==2&&projectStatus==NewProjectStatus.YWCXZ.getCode()) {
  692. flag=true;
  693. }
  694. }
  695. }else if(ob.getProjectType()==OrderDunProjectType.GX.getCode()) {
  696. if (ob.getDunType()==2&&projectStatus>=NewProjectStatus.YNGS.getCode()
  697. &&projectStatus<=NewProjectStatus.YXZ.getCode()) {
  698. flag=true;
  699. } else if (ob.getDunType()==3&&projectStatus==NewProjectStatus.YXZ.getCode()){
  700. flag=true;
  701. }
  702. }
  703. if(flag) {
  704. //如果启动催款,则新增欠款与应收款
  705. TOrderNew tn=tOrderNewMapper.selectByPrimaryKey(task2.getOrderNo());
  706. ob.setStatus(1);
  707. ob.setStartTime(new Date());
  708. newOrderDunMapper.updateByPrimaryKeySelective(ob);
  709. TOrderMid tm=orderNewService.pushOrderMidDun(task2.getOrderNo(),tn.getSettlementAmount(),new Date());
  710. TArrearsDun td=new TArrearsDun();
  711. td.setOrderArrears(tm.getOrderArrears());
  712. td.setOrderReceivables(tm.getOrderReceivables());
  713. if (tArrearsDunMapper.checkOrderNo(task2.getOrderNo(),null)<1) {
  714. td.setOrderNo(task2.getOrderNo());
  715. tArrearsDunMapper.insertSelective(td);
  716. }else if(tArrearsDunMapper.checkOrderNo(task2.getOrderNo(),0)>0){
  717. Integer i=tArrearsDunMapper.selectByStatus(task2.getOrderNo(), 0);
  718. td.setId(i);
  719. tArrearsDunMapper.updateByPrimaryKeySelective(td);
  720. }
  721. orderNewService.addNewDunNoticAndSendEmail(task2.getOrderNo(),ob);
  722. }
  723. }
  724. }
  725. List<OutPaymentNode> list2=paymentNodeMapper.selectByTid(tid,0);
  726. for (OutPaymentNode op : list2) {
  727. if (op!=null) {
  728. boolean flag=false;
  729. if((op.getProjectType()==OrderDunProjectType.CGZH.getCode()&&op.getDunType()==2&&//成果转化 验收
  730. projectStatus==NewProjectStatus.YWCXZ.getCode()))flag=true;
  731. if((op.getProjectType()==OrderDunProjectType.COMMON.getCode()&&op.getDunType()==2&&//通用 公示
  732. projectStatus==NewProjectStatus.YTJ.getCode()))flag=true;
  733. if((op.getProjectType()==OrderDunProjectType.COMMON.getCode()&&op.getDunType()==3&&//通用 下证
  734. projectStatus==NewProjectStatus.YWCXZ.getCode()))flag=true;
  735. if((op.getProjectType()==OrderDunProjectType.KJXM.getCode()&&op.getDunType()==2&&//科技项目 立项或者公示
  736. projectStatus==NewProjectStatus.YLX.getCode()))flag=true;
  737. if((op.getProjectType()==OrderDunProjectType.KJXM.getCode()&&op.getDunType()==3&&//科技项目 拨款
  738. projectStatus==NewProjectStatus.LXYBK.getCode()))flag=true;
  739. if((op.getProjectType()==OrderDunProjectType.KJJR.getCode()&&op.getDunType()==2&&//科技金融 拨款
  740. projectStatus==NewProjectStatus.YWCXZ.getCode()))flag=true;
  741. if((op.getProjectType()==OrderDunProjectType.RJKF.getCode()&&op.getDunType()==2&&//软件开发 立项
  742. projectStatus==NewProjectStatus.YTJ.getCode()))flag=true;
  743. if((op.getProjectType()==OrderDunProjectType.RJKF.getCode()&&op.getDunType()==3&&//软件开发 验收
  744. projectStatus==NewProjectStatus.YWCXZ.getCode()))flag=true;
  745. if(op.getProjectType()==OrderDunProjectType.ZSCQ.getCode()){//知识产权 公示 专利受理、转让(项目已提交),软著下证
  746. if(op.getDunType()==3&&projectStatus==NewProjectStatus.YWCXZ.getCode()) {
  747. flag=true;
  748. }else if (op.getDunType()==2) {
  749. BusinessProject bp=businessProjectMapper.selectByPrimaryKey(task2.getCommodityId());
  750. if (bp.getType()==0&&projectStatus==NewProjectStatus.YWCXZ.getCode()) {
  751. flag=true;
  752. }
  753. if (bp.getType()==1&&projectStatus==NewProjectStatus.YTJ.getCode()) {
  754. flag=true;
  755. }
  756. if (bp.getType()==2&&projectStatus==NewProjectStatus.YWCXZ.getCode()) {
  757. flag=true;
  758. }
  759. }
  760. }
  761. if(flag)addNoticAndEmail( op,NoticeStatus.PAYMENT_DUN.getCode());
  762. }
  763. }
  764. }
  765. public void addNoticAndEmail(OutPaymentNode pn,Integer type) {
  766. paymentNodeEmailBo pnb=paymentNodeMapper.selectBytidGetEmail(pn.getTid());
  767. TOrderNewBo b = tOrderNewMapper.getSaleIdByOno(pnb.getOrderNo());
  768. orderNewService.addNotic(type,b,null);
  769. pn.setDunStatus(1);
  770. paymentNodeMapper.updateByPrimaryKeySelective(pn);
  771. //营销员名称、邮箱、订单编号、客户名称
  772. String dunTypeName=NewOrderDunType.getValueByCode(Integer.valueOf(""+pn.getProjectType()+pn.getDunType()));
  773. //发送驳回邮件
  774. if(SendEmailUtil.isEmail(pnb.getEmail())) {
  775. EmailBo bo = new EmailBo("付款通知", pnb.getEmail(), "平台超管中心", "管理员",
  776. "", pnb.getOrderNo(),pnb.getContractNo(),pn.getPartyTimes(),
  777. dunTypeName,pnb.getSalesmanName(),pnb.getUserName(),2,0);
  778. if(StringUtils.isNotBlank(pnb.getEmail())) {
  779. try {
  780. asyncUtils.patentSend(bo);
  781. } catch (UnsupportedEncodingException | MessagingException e) {
  782. LoggerUtils.debug(logger, "=========================================发送邮件异常");
  783. e.printStackTrace();
  784. }
  785. }
  786. }
  787. }
  788. private void checkSettlementAward(TOrderNew tn,TOrderTask task) {
  789. if(task.getTaskStatus()==TaskState.COMPLETE.getCode()&&tn.getTotalAmount().compareTo(tn.getSettlementAmount())==0) {
  790. List<TOrderTaskBo> l = tOrderTaskMapper.getReceiverByOid(tn.getOrderNo());
  791. for (TOrderTaskBo tOrderTask : l) {
  792. if(null != tOrderTask &&null != tOrderTask.getTaskReceiver()){
  793. TOrderBonus bonus = new TOrderBonus();
  794. bonus.setId(UUID.randomUUID().toString());
  795. bonus.setOrderNo(tn.getOrderNo());
  796. bonus.setGrantBy(tn.getFinanceId());
  797. bonus.setBonusSubject(BonusSubject.WK.getCode());//12
  798. bonus.setTaskId(tOrderTask.getId());//任务id
  799. bonus.setGrantTarget(tOrderTask.getTaskReceiver());
  800. bonus.setGrantType(1);
  801. int c = tOrderBonusMapper.checkByOnoAndSub(bonus);
  802. //不存在就设置
  803. if(c==0){
  804. bonus.setId(UUID.randomUUID().toString());
  805. tOrderBonusMapper.insertSelective(bonus);
  806. }
  807. }
  808. }
  809. }
  810. }
  811. private void meanwhileUpdateOrder(TOrderTask task) {
  812. //是否是主要项目
  813. if (task.getMain()==1) {
  814. //更改订单项目状态
  815. TOrderNew tNew = new TOrderNew();
  816. tNew.setProjectStatus(task.getProjectStatus());
  817. tNew.setOrderNo(task.getOrderNo());
  818. tOrderNewMapper.updateByPrimaryKeySelective(tNew);
  819. }
  820. if (task.getProjectStatus()==NewProjectStatus.YTJ.getCode()||task.getProjectStatus()==NewProjectStatus.YLX.getCode()||
  821. task.getProjectStatus()==NewProjectStatus.YNGS.getCode()) {
  822. TOrderBonus tb=new TOrderBonus();
  823. TOrderNew t=tOrderNewMapper.selectByPrimaryKey(task.getOrderNo());
  824. tb.setId(UUID.randomUUID().toString());
  825. tb.setOrderNo(task.getOrderNo());
  826. if (task.getProjectStatus()==NewProjectStatus.YTJ.getCode()) {
  827. tb.setBonusSubject(21);//项目已提交
  828. addOrderLog(task.getOrderNo(),OrderLogProcess.XMWC.getCode(),null);
  829. }
  830. if (task.getProjectStatus()==NewProjectStatus.YLX.getCode())tb.setBonusSubject(23);//项目立项
  831. if (task.getProjectStatus()==NewProjectStatus.YNGS.getCode())tb.setBonusSubject(24);//项目公示
  832. tb.setGrantType(1);//技术员
  833. //新增奖金之前检查这个奖金数据是否存在
  834. tb.setGrantTarget(task.getTaskReceiver());
  835. int c = tOrderBonusMapper.checkByOnoAndSub(tb);
  836. if(c==0){
  837. tb.setGrantBy(t.getFinanceId());
  838. tb.setTaskId(task.getId());
  839. tOrderBonusMapper.insertSelective(tb);
  840. }
  841. }
  842. }
  843. @Override
  844. public int addTaskHours(TTaskHours t) {
  845. TOrderTask tt=tOrderTaskMapper.selectByPrimaryKey(Integer.valueOf(t.getTaskId()));
  846. checkDeleteSign(tt.getOrderNo());
  847. t.setAid(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  848. t.setId(UUID.randomUUID().toString());
  849. t.setCreateTime(new Date());
  850. if(taskHoursCountMapper.selectByAidAndTid(TokenManager.getAdminId(),t.getTaskId())>0) {
  851. taskHoursCountMapper.updateByAidAndTid(TokenManager.getAdminId(),t.getTaskId(),t.getHours());
  852. }else {
  853. TaskHoursCount tc=new TaskHoursCount();
  854. tc.setAid(TokenManager.getAdminId());
  855. tc.setTid(Integer.valueOf(t.getTaskId()));
  856. tc.setHours(t.getHours());
  857. taskHoursCountMapper.insertSelective(tc);
  858. }
  859. return tTaskHoursMapper.insertSelective(t);
  860. }
  861. @SuppressWarnings("unchecked")
  862. @Override
  863. public Pagination<TOrderTaskListBo> taskHoursList(inuptTaskHoursListBo ib, Integer pageNo,
  864. Integer pageSize) {
  865. Map<String, Object> params = new HashMap<String, Object>();
  866. if(pageSize==null||pageSize<0)pageSize=10;
  867. if(pageNo==null||pageNo<0)pageNo=1;
  868. if (StringUtils.isNotBlank(ib.getName())) params.put("name", ib.getName());
  869. if (StringUtils.isNotBlank(ib.getOrderNo())) params.put("orderNo", ib.getOrderNo());
  870. if (StringUtils.isNotBlank(ib.getTaskId())) params.put("taskId", ib.getTaskId());
  871. if (StringUtils.isNotBlank(ib.getStarTime())) params.put("starTime", ib.getStarTime());
  872. if (StringUtils.isNotBlank(ib.getEndTime())) params.put("endTime", ib.getEndTime()+" 23:59:59");
  873. if(StringUtils.isNotBlank(ib.getContractNo()))params.put("contractNo", ib.getContractNo());
  874. if(StringUtils.isNotBlank(ib.getDepId()))params.put("depId", ib.getDepId());
  875. if(StringUtils.isNotBlank(ib.getCid()))params.put("cid", ib.getCid());
  876. if (ib.getThchId()!=null)params.put("thchId", ib.getThchId());
  877. if(null!=ib.getOutsource())params.put("outsource", ib.getOutsource());
  878. Integer i=null;
  879. if (TokenManager.hasRole(AFTConstants.FINANCE))i=1;
  880. if (TokenManager.hasRole(AFTConstants.FINANCE_MANAGER))i=2;
  881. if (TokenManager.hasRole(AFTConstants.FINANCE_ADMIN)||TokenManager.hasRole(AFTConstants.VICE_CEO)||
  882. TokenManager.hasRole(AFTConstants.SUPERADMIN)||TokenManager.hasRole(AFTConstants.CED)||
  883. TokenManager.hasRole(AFTConstants.APPROVAL_DECISION))i=3;
  884. if(TokenManager.getAdminId()!=null)params.put("aid", TokenManager.getAdminId());
  885. if(i!=null)params.put("shiroType", i);
  886. Pagination<TOrderTaskListBo> p = (Pagination<TOrderTaskListBo>)findPage("selectTaskHoursListByPage", "selectTaskHoursListCount", params, pageNo, pageSize);
  887. return p;
  888. }
  889. @SuppressWarnings("unchecked")
  890. @Override
  891. public Pagination<TOrderTaskListBo> selectTaskList(String name, String orderNo, String taskId, Integer taskStatus,
  892. String adminName, Integer specially,String depId,String thchId , Integer pageNo, Integer pageSize) {
  893. Map<String, Object> params = new HashMap<String, Object>();
  894. if(pageSize==null||pageSize<0)pageSize=10;
  895. if(pageNo==null||pageNo<0)pageNo=1;
  896. params.put("aid", TokenManager.getAdminId()==null?"":TokenManager.getAdminId());
  897. if (StringUtils.isNotBlank(name)) params.put("name", name);
  898. if (StringUtils.isNotBlank(depId)) params.put("depId", depId);
  899. if (StringUtils.isNotBlank(orderNo)) params.put("orderNo", orderNo);
  900. if (StringUtils.isNotBlank(taskId)) params.put("taskId", taskId);
  901. if (StringUtils.isNotBlank(thchId)) params.put("thchId", thchId);
  902. if (StringUtils.isNotBlank(adminName)) params.put("adminName", adminName);
  903. if (null != taskStatus) params.put("taskStatus", taskStatus);
  904. Pagination<TOrderTaskListBo> p = (Pagination<TOrderTaskListBo>)findPage("selectTaskListByPage", "selectTaskListCount", params, pageNo, pageSize);
  905. return p;
  906. }
  907. @Override
  908. public List<TaskLogBo> TaskLogList(Integer id) {
  909. return taskLogMapper.selectTaskLogList(id);
  910. }
  911. @Override
  912. public int createTaskProgress(TaskProgressBo t) {
  913. TaskProgress tp=new TaskProgress();
  914. TOrderTask tt=tOrderTaskMapper.selectByPrimaryKey(t.getTaskId());
  915. int count =taskProgressMapper.AlreadyNuberCount(t.getTaskId());
  916. count +=t.getAlreadyNumber();
  917. if(tt.getCommodityQuantity()<count)throw new BusinessException(new Error( "数量不能大于总量!" ,"数量不能大于总量!"));
  918. tp.setAlreadyNumber(t.getAlreadyNumber());
  919. tp.setPatentName(t.getPatentName());
  920. tp.setPatentNo(t.getPatentNo());
  921. tp.setType(t.getType());
  922. if (t.getLicenceTimes()!=null) tp.setLicenceTime(DateUtils.StringToDate(t.getLicenceTimes(), AFTConstants.YYYYMMDD));
  923. if (t.getAcceptTimes()!=null) tp.setAcceptTime(DateUtils.StringToDate(t.getAcceptTimes(), AFTConstants.YYYYMMDD));
  924. if (t.getAuthorizeTimes()!=null) tp.setAuthorizeTime(DateUtils.StringToDate(t.getAuthorizeTimes(), AFTConstants.YYYYMMDD));
  925. tp.setStatus(t.getStatus());
  926. tp.setTaskId(t.getTaskId());
  927. tTaskMidMapper.updateCertificatesCountByTid(t.getTaskId(),count);
  928. TaskProgressLog tpl=new TaskProgressLog(t.getTaskId(),t.getPatentName(),0,new Date());
  929. taskProgressLogMapper.insertSelective(tpl);
  930. int i=taskProgressMapper.insertSelective(tp);
  931. countByTid(tp.getTaskId(),tp.getType());
  932. return i;
  933. }
  934. @Override
  935. public int updateTaskProgress(TaskProgressBo t) {
  936. TaskProgress tp=taskProgressMapper.selectByPrimaryKey(t.getId());
  937. TOrderTask tt=tOrderTaskMapper.selectByPrimaryKey(t.getTaskId());
  938. int count =taskProgressMapper.AlreadyNuberCount(t.getTaskId());
  939. count = count-tp.getAlreadyNumber()+t.getAlreadyNumber();
  940. if(tt.getCommodityQuantity()<count)throw new BusinessException(new Error( "数量不能大于总量!" ,"数量不能大于总量!"));
  941. tp.setAlreadyNumber(t.getAlreadyNumber());
  942. tp.setPatentName(t.getPatentName());
  943. tp.setPatentNo(t.getPatentNo());
  944. tp.setType(t.getType());
  945. if (t.getLicenceTimes()!=null) tp.setLicenceTime(DateUtils.StringToDate(t.getLicenceTimes(), AFTConstants.YYYYMMDD));
  946. if (t.getAcceptTimes()!=null) tp.setAcceptTime(DateUtils.StringToDate(t.getAcceptTimes(), AFTConstants.YYYYMMDD));
  947. if (t.getAuthorizeTimes()!=null) tp.setAuthorizeTime(DateUtils.StringToDate(t.getAuthorizeTimes(), AFTConstants.YYYYMMDD));
  948. tp.setStatus(t.getStatus());
  949. tp.setTaskId(t.getTaskId());
  950. tTaskMidMapper.updateCertificatesCountByTid(t.getTaskId(),count);
  951. TaskProgressLog tpl=new TaskProgressLog(t.getTaskId(),t.getPatentName(),2,new Date());
  952. taskProgressLogMapper.insertSelective(tpl);
  953. int i=taskProgressMapper.updateByPrimaryKeySelective(tp);
  954. countByTid(tp.getTaskId(),tp.getType());
  955. return i;
  956. }
  957. @Override
  958. public int delectTaskProgress(Integer id) {
  959. TaskProgress tp=taskProgressMapper.selectByPrimaryKey(id);
  960. if (tp==null) {
  961. return 0;
  962. }
  963. int i=taskProgressMapper.deleteByPrimaryKey(id);
  964. TaskProgressLog tpl=new TaskProgressLog(tp.getTaskId(),tp.getPatentName(),1,new Date());
  965. taskProgressLogMapper.insertSelective(tpl);
  966. countByTid(tp.getTaskId(),tp.getType());
  967. return i;
  968. }
  969. private void countByTid(Integer taskId, Integer type) {
  970. //目前不做计算
  971. // TTaskMid ttm=tTaskMidMapper.selectCountBytid(taskId,type);
  972. // tTaskMidMapper.updateByPrimaryKeySelective(ttm);
  973. }
  974. @Override
  975. public List<TaskProgressBo> selectTaskProgress(Integer tid) {
  976. List<TaskProgressBo> l=taskProgressMapper.selectTaskProgress(tid);
  977. int notcount=0;
  978. for (TaskProgressBo t : l) {
  979. notcount+=t.getAlreadyNumber();
  980. t.setNotCount(t.getIngCount()-notcount);
  981. }
  982. return l;
  983. }
  984. @Override
  985. public List<TTaskHours> taskHoursDetailsList(String taskId) {
  986. String aid=TokenManager.getAdminId();
  987. return tTaskHoursMapper.taskHoursDetailsList(taskId,aid);
  988. }
  989. @Override
  990. public int pushSplitProject(Integer tid, String splitList) {
  991. String[] str=splitList.split(",");
  992. TOrderTask task=tOrderTaskMapper.selectByPrimaryKey(tid);
  993. checkDeleteSign(task.getOrderNo());
  994. TOrderTask usedTask=new TOrderTask();
  995. usedTask.setId(tid);
  996. usedTask.setSplitStatus(1);
  997. //计算拆分数量
  998. Integer x=0;
  999. for (String string : str) {
  1000. x+=Integer.parseInt(string);
  1001. }
  1002. if (!task.getCommodityQuantity().equals(x)||str.length==1) {
  1003. return -1;
  1004. }
  1005. tOrderTaskMapper.updateByPrimaryKeySelective(usedTask);
  1006. int i=1;
  1007. TOrderTask newTask=task;
  1008. newTask.setCommodityPrice(new BigDecimal(0));
  1009. newTask.setSplitAid(TokenManager.getAdminId());
  1010. newTask.setSplitStatus(2);
  1011. newTask.setSplitSuper(tid);
  1012. newTask.setSplitTime(new Date());
  1013. for (String string : str) {
  1014. newTask.setId(null);
  1015. newTask.setCommodityQuantity(Integer.parseInt(string));
  1016. newTask.setSplitId(i);
  1017. i++;
  1018. tOrderTaskMapper.insertSelective(newTask);
  1019. TTaskMid dtails = tTaskMidMapper.getDtails(newTask.getId());
  1020. TTaskMid tTaskMid = new TTaskMid(newTask.getId(), new BigDecimal(0));
  1021. tTaskMid.setDispatchProvince(dtails.getDispatchProvince());
  1022. tTaskMid.setDutyDep(dtails.getDutyDep());
  1023. tTaskMidMapper.insertSelective(tTaskMid);
  1024. }
  1025. return 1;
  1026. }
  1027. @Override
  1028. public List<TOrderTaskListBo> splitProjectList(Integer tid,Integer type) {
  1029. return tOrderTaskMapper.splitProjectList(tid,type);
  1030. }
  1031. @Override
  1032. public List<OutTaskProgressLog> selectTaskProgressLog(Integer tid) {
  1033. return taskProgressLogMapper.selectTaskProgressLog(tid);
  1034. }
  1035. @Override
  1036. public Pagination<managerListBo> managerSelect(String name, String orderNo, String contractNo, String cid,
  1037. String projectType,String thchId, String depId, String techDepId, Integer declarationBatch, String commodityPrice,
  1038. String startTime,String endTime ,Integer pageNo, Integer pageSize) {
  1039. Map<String, Object> params = new HashMap<String, Object>();
  1040. if(pageSize==null||pageSize<0)pageSize=10;
  1041. if(pageNo==null||pageNo<0)pageNo=1;
  1042. params.put("aid", TokenManager.getAdminId()==null?"":TokenManager.getAdminId());
  1043. if (StringUtils.isNotBlank(name))params.put("name", name);
  1044. if (StringUtils.isNotBlank(depId)) params.put("depId", depId);
  1045. if (StringUtils.isNotBlank(orderNo)) params.put("orderNo", orderNo);
  1046. if (StringUtils.isNotBlank(contractNo)) params.put("contractNo", contractNo);
  1047. if (StringUtils.isNotBlank(cid)) params.put("cid", cid);
  1048. if (StringUtils.isNotBlank(projectType)) params.put("projectType", projectType);
  1049. if (StringUtils.isNotBlank(depId)) params.put("depId", depId);
  1050. if (StringUtils.isNotBlank(thchId))params.put("thchId", thchId);
  1051. if (StringUtils.isNotBlank(techDepId)) params.put("techDepId", techDepId);
  1052. if (StringUtils.isNotBlank(commodityPrice)) params.put("commodityPrice", commodityPrice);
  1053. if (StringUtils.isNotBlank(startTime)) params.put("startTime", startTime);
  1054. if (StringUtils.isNotBlank(endTime)) params.put("endTime", endTime+" 23:59:59");
  1055. if (null != declarationBatch) params.put("declarationBatch", declarationBatch);
  1056. @SuppressWarnings("unchecked")
  1057. Pagination<managerListBo> p = (Pagination<managerListBo>)findPage("managerSelectByPage", "managerSelectCount", params, pageNo, pageSize);
  1058. return p;
  1059. }
  1060. @Override
  1061. public List<taskAttributionLogBo> taskAttributionLog(Integer tid) {
  1062. return taskAttributionLogMapper.selectByTid(tid);
  1063. }
  1064. @Override
  1065. public List<UserOrderTask> selectUidByproject(String uid) {
  1066. return tOrderTaskMapper.selectUidByproject(uid);
  1067. }
  1068. @Override
  1069. public int addProjectCheck(Integer tid) {
  1070. TOrderTask t=new TOrderTask();
  1071. t.setCheckStatus(1);
  1072. t.setId(tid);
  1073. ProjcetCheckLog log=new ProjcetCheckLog();
  1074. log.setAid(TokenManager.getAdminId());
  1075. log.setRemarks("发起核对");
  1076. log.setTid(tid);
  1077. log.setStatus(0);
  1078. OrderOperator oo=tOrderTaskMapper.selectAidByParam(tid);
  1079. if (oo!=null&&oo.getOrderNo()!=null&&oo.getSalesmanId()!=null) {
  1080. Notice n =new Notice();
  1081. String str=String.format("[%s]发起专利核对,客户名称[%s]订单编号[%s]项目编号[%s]。", oo.getTechName(),oo.getBuyerName(),oo.getOrderNo(),oo.getTid());
  1082. n.setId(UUID.randomUUID().toString());
  1083. n.setAid(oo.getSalesmanId());
  1084. n.setNoticeType(NoticeStatus.ITEM_CHECK_START.getCode());
  1085. n.setContent(str);
  1086. n.setReaded(0);//未读
  1087. asyncUtils.addNoticAndEmail(n);
  1088. }
  1089. projcetCheckLogMapper.insertSelective(log);
  1090. tOrderPaymentMapper.deleteByParam(tid,2);
  1091. return tOrderTaskMapper.updateByPrimaryKeySelective(t);
  1092. }
  1093. @Override
  1094. public List<OutProjectCheckLog> projectCheckLog(Integer tid) {
  1095. return projcetCheckLogMapper.projectCheckLog(tid);
  1096. }
  1097. @SuppressWarnings("unchecked")
  1098. @Override
  1099. public Object selectProjectCheck(InputProjectCheck in) {
  1100. Map<String, Object> map=new HashedMap<String, Object>();
  1101. if (in.getName()!=null) map.put("name", in.getName());
  1102. if (in.getOrderNo()!=null) map.put("orderNo", in.getOrderNo());
  1103. if (in.getContractNo()!=null) map.put("contartNo", in.getContractNo());
  1104. if (in.getPname()!=null) map.put("pname", in.getPname());
  1105. if (in.getDeps()!=null) {
  1106. map.put("deps", departmentService.parseArray(in.getDeps()));
  1107. }
  1108. map.put("aid", TokenManager.getAdminId());
  1109. return (Pagination<OutProjectCheck>)findPage("selectProjectCheck", "countProjectCheck", map, in.getPageNo(), in.getPageSize());
  1110. }
  1111. @Override
  1112. public List<OutHighNewRetrialStatistics> highNewRetrialStatistics(String depId, String startDate, String endDate) {
  1113. endDate=endDate+" 23:59:59";
  1114. return tOrderTaskMapper.highNewRetrialStatistics(depId,startDate,endDate);
  1115. }
  1116. @Override
  1117. public List<OutHighNewRetrialList> highNewRetrialList(String province, String depId, String aid, Integer sort, String startDate, String endDate) {
  1118. endDate=endDate+" 23:59:59";
  1119. if (sort==null)sort=0;
  1120. return tOrderTaskMapper.highNewRetrialList( province, depId, aid, sort, startDate, endDate);
  1121. }
  1122. @Override
  1123. public Pagination<OutMemberList> memberList(InputMemberList in) {
  1124. HashMap<String, Object> map = new HashMap<>();
  1125. addParam(in, map);
  1126. return (Pagination<OutMemberList>) findPage("findMemberList","findMemberCount",map,in.getPageNo(), in.getPageSize());
  1127. }
  1128. private void addParam(InputMemberList in, HashMap<String, Object> map) {
  1129. if(in.getOrderNo()!=null) map.put("orderNo", in.getOrderNo());
  1130. if(in.getUserName()!=null) map.put("userName", in.getUserName());
  1131. if(in.getDeps()!=null&&!in.getDeps().isEmpty()){
  1132. List<String> ls=JSON.parseArray(in.getDeps(),String.class);
  1133. map.put("deps", ls);
  1134. }
  1135. if(in.getContractNo()!=null) map.put("contractNo", in.getContractNo());
  1136. if(in.getSalesmanId()!=null) map.put("salesmanId", in.getSalesmanId());
  1137. if(in.getProjectName()!=null) map.put("projectName", in.getProjectName());
  1138. if(in.getAmountStatus()!=null) map.put("amountStatus", in.getAmountStatus());
  1139. if(in.getApproval()!=null) map.put("approval", in.getApproval());
  1140. if(in.getStatus()!=null) map.put("status", in.getStatus());
  1141. if(in.getShiroType()!=null) map.put("shiroType", in.getShiroType());
  1142. map.put("aid",TokenManager.getAdminId());
  1143. }
  1144. @Override
  1145. public Result memberListExport(InputMemberList in) {
  1146. HashMap<String, Object> map = new HashMap<>();
  1147. addParam(in, map);
  1148. List<OutMemberList>list= (List<OutMemberList>) findList("findMemberList",map,1,9999);
  1149. for (OutMemberList out : list) {
  1150. if (out.getSalesType()!=null){
  1151. StringBuffer str=new StringBuffer();
  1152. str.append(SalesTypes.getValueByCode(out.getSalesType()));
  1153. if (out.getSalesType()==SalesTypes.qd.getCode()){
  1154. str.append("-").append(out.getOther());
  1155. }
  1156. out.setSalesTypeName(str.toString());
  1157. }
  1158. if (out.getTotalAmount()!=null){
  1159. StringBuffer str=new StringBuffer();
  1160. str.append(out.getTotalAmount().compareTo(new BigDecimal(10))>=0?"大客户":"一般客户");
  1161. out.setBigUser(str.toString());
  1162. }
  1163. if (out.getDeleteSign()!=null){
  1164. StringBuffer str=new StringBuffer();
  1165. str=str.append(out.getDeleteSign()==0?"正常": out.getDeleteSign()==1?"删除":
  1166. out.getDeleteSign()==2?"锁定":"未知");
  1167. out.setDeleteSignStr(str.toString());
  1168. }
  1169. }
  1170. NewExcelUtil<OutMemberList> excelUtil=new NewExcelUtil<>(OutMemberList.class);
  1171. return excelUtil.exportExcel(list,"会员审核列表",uploadPath);
  1172. }
  1173. @Override
  1174. public int pushExamineMemberProject(InputMenber in) {
  1175. TOrderTask task=tOrderTaskMapper.selectByPrimaryKey(in.getId());
  1176. Integer status=1;
  1177. TOrderTask nt=new TOrderTask();
  1178. nt.setId(task.getId());
  1179. Integer result=0;
  1180. Integer notice=NoticeStatus.MENBER_YES.getCode();
  1181. TOrderNewBo ono = tOrderNewMapper.getSaleIdByOno(task.getOrderNo());
  1182. // 1=通过 0=驳回
  1183. if (in.getResult()==1){
  1184. //0=财务 1=特批
  1185. if (in.getType()==0){
  1186. if(task.getProcessStatus()!=1)throw new BusinessException("审核状态错误");
  1187. if (task.getMemberType()==1||task.getMemberType()==2){
  1188. nt.setProcessStatus(2);
  1189. status=1;
  1190. }else if (task.getMemberType()==0){
  1191. nt.setProcessStatus(3);
  1192. status=3;
  1193. result=1;
  1194. }
  1195. }else if(in.getType()==1){
  1196. if(task.getProcessStatus()!=2)throw new BusinessException("审核状态错误");
  1197. nt.setProcessStatus(3);
  1198. status=3;
  1199. result=1;
  1200. }
  1201. }else if (in.getResult()==0){
  1202. status=2;
  1203. nt.setProcessStatus(4);
  1204. notice=NoticeStatus.MENBER_NO.getCode();
  1205. }
  1206. addNoticMember(notice, ono, in.getType(),result);
  1207. addMemberLog(in.getId(),status,in.getRemarks());
  1208. if (nt.getProcessStatus()==3){
  1209. tTaskMemberMapper.updateServiceYearBySplitSuper(task.getSplitSuper());
  1210. }
  1211. return tOrderTaskMapper.updateByPrimaryKeySelective(nt);
  1212. }
  1213. @Override
  1214. public int updateMemberProject(InputAddTask t) {
  1215. TOrderTask task=tOrderTaskMapper.selectByPrimaryKey(t.getId());
  1216. if(task.getProcessStatus()!=4)throw new BusinessException("审核状态错误,无法提交。");
  1217. addMemberLog(t.getId(),0,"修改重新发起");
  1218. t.setProcessStatus(1);
  1219. TOrderNewBo ono = tOrderNewMapper.getSaleIdByOno(task.getOrderNo());
  1220. addNoticMember(NoticeStatus.MENBER_START.getCode(), ono, null,0);
  1221. return orderNewService.updateOrderTask(t);
  1222. }
  1223. @Override
  1224. public void addMemberLog(Integer id,Integer status ,String remarks){
  1225. MemberLog log = new MemberLog();
  1226. log.setPid(id);
  1227. log.setStatus(status);
  1228. log.setRemarks(remarks);
  1229. log.setAid(TokenManager.getAdminId());
  1230. memberLogMapper.insertSelective(log);
  1231. }
  1232. @Override
  1233. public List<MemberLogBo> memberLog(Integer id) {
  1234. return memberLogMapper.memberLog(id);
  1235. }
  1236. @Override
  1237. public TOrderTask addMemberSonProject(Integer tid, String serviceYear, String taskComment,Integer memberType,String pictureUrl) {
  1238. Date date =new Date();
  1239. TOrderTask tOrderTask = tOrderTaskMapper.selectByPrimaryKey(tid);
  1240. tOrderTask.setSplitStatus(1);
  1241. tOrderTask.setSplitAid(TokenManager.getAdminId());
  1242. tOrderTask.setSplitTime(date);
  1243. tOrderTaskMapper.updateByPrimaryKey(tOrderTask);
  1244. tOrderTask.setId(null);
  1245. tOrderTask.setSplitStatus(2);
  1246. tOrderTask.setSplitSuper(tid);
  1247. if (memberType!=null){
  1248. tOrderTask.setProcessStatus(1);
  1249. tOrderTask.setMemberType(memberType);
  1250. tOrderTask.setPictureUrl(pictureUrl);
  1251. }
  1252. Integer i=tOrderTaskMapper.getSplitCount(tid);
  1253. i++;
  1254. tOrderTask.setSplitId(i);
  1255. tOrderTask.setCommodityQuantity(1);
  1256. tOrderTask.setTaskComment(taskComment);
  1257. tOrderTask.setMain(0);
  1258. tOrderTask.setCommodityPrice(new BigDecimal(0));
  1259. tOrderTaskMapper.insertSelective(tOrderTask);
  1260. TTaskMember t = tTaskMemberMapper.selectByTid(tid);
  1261. TOrderTaskBo tb=new TOrderTaskBo();
  1262. BeanUtils.copyProperties(tOrderTask,tb);
  1263. if (t.getServiceLife()!=null||t.getYearSum()!=null||t.getContractTerm()!=null||serviceYear!=null){
  1264. TTaskMember ttm=new TTaskMember();
  1265. ttm.setId(null);
  1266. ttm.setTid(tOrderTask.getId());
  1267. if(t.getServiceLife()!=null)ttm.setServiceLife(t.getServiceLife());
  1268. ttm.setServiceYear(serviceYear);
  1269. tb.setServiceYear(serviceYear);
  1270. if(t.getYearSum()!=null)ttm.setYearSum(t.getYearSum());
  1271. if(t.getContractTerm()!=null)ttm.setContractTerm(t.getContractTerm());
  1272. tTaskMemberMapper.insertSelective(ttm);
  1273. }
  1274. orderNewService.addTaskMid(tOrderTask.getId(),tOrderTask.getCommodityId(), tOrderTask.getOrderNo());
  1275. //处理主项目本次派单年份
  1276. tTaskMemberMapper.updateServiceYearBySplitSuper(tid);
  1277. addMemberLog(tOrderTask.getId(),0,"新增会员项目");
  1278. if(memberType!=null){
  1279. addNoticMember(NoticeStatus.MENBER_START.getCode(),tOrderTask.getOrderNo(),null,0);
  1280. addFinanceCountMember(tOrderTask.getOrderNo(),date);
  1281. }
  1282. return tb;
  1283. }
  1284. private void addFinanceCountMember(String orderNo, Date date) {
  1285. Admin admin = adminMapper.selectOrderByFinanace(orderNo);
  1286. String startTime = DateUtils.formatDate(date, AFTConstants.YYYYMMDD);
  1287. FinanceCount financeCount = financeCountMapper.selectByAidAndDates(admin.getId(), startTime);
  1288. if (financeCount == null) {
  1289. financeCount = FinanceCount.initialization(admin.getId(), startTime);
  1290. financeCount.setMemberCount(1);
  1291. financeCount.setMemberUnauditedCount(1);
  1292. }else {
  1293. FinanceCount newFinanceCount =new FinanceCount();
  1294. newFinanceCount.setId(financeCount.getId());
  1295. newFinanceCount.setMemberCount(financeCount.getMemberCount()+1);
  1296. newFinanceCount.setMemberUnauditedCount(financeCount.getMemberUnauditedCount()+1);
  1297. financeCountMapper.updateByPrimaryKeySelective(newFinanceCount);
  1298. }
  1299. }
  1300. public void addNoticMember(Integer type, String orderNo,Integer shiroType,Integer result) {
  1301. TOrderNewBo tn = tOrderNewMapper.getSaleIdByOno(orderNo);
  1302. addNoticMember(NoticeStatus.MENBER_START.getCode(),tn,null,0);
  1303. }
  1304. @Override
  1305. public void addNoticMember(Integer type, TOrderNewBo b,Integer shiroType,Integer result) {
  1306. StringBuffer sb=new StringBuffer();
  1307. String aid=null;
  1308. List<Admin>admins=new ArrayList<>();
  1309. sb.append("客户名称【").append(b.getUserName()).append("】,订单编号【").append(b.getOrderNo()).append("】,");
  1310. if (type.equals(NoticeStatus.MENBER_START.getCode())){
  1311. sb=sb.append("发起会员项目,请及时审核");
  1312. aid=b.getFinanceId();
  1313. }else if (type.equals(NoticeStatus.MENBER_YES.getCode())){
  1314. sb=sb.append("会员项目审核");
  1315. if(shiroType==0){
  1316. sb=sb.append("财务已通过。");
  1317. if (result==1) {
  1318. admins = MemberEnd(b);
  1319. }else{
  1320. admins=adminMapper.getAdminRoleTypeList(AFTConstants.CED);
  1321. }
  1322. } else if(shiroType==1){
  1323. sb=sb.append("特批已通过。");
  1324. admins = MemberEnd(b);
  1325. }
  1326. }else if (type.equals(NoticeStatus.MENBER_NO.getCode())){
  1327. if(shiroType==0){
  1328. sb=sb.append("财务已驳回。");
  1329. } else if(shiroType==1){
  1330. sb=sb.append("特批已驳回。");
  1331. }
  1332. aid=b.getSalesmanId();
  1333. }
  1334. if (admins!=null&&admins.size()>0){
  1335. for (Admin admin : admins) {
  1336. asyncUtils.addNotic(type,admin.getId(),sb.toString());
  1337. sendMemberEmail(type,admin.getId(),sb.toString());
  1338. }
  1339. }else {
  1340. asyncUtils.addNotic(type,aid,sb.toString());
  1341. sendMemberEmail(type,aid,sb.toString());
  1342. }
  1343. }
  1344. /**
  1345. * 会员项目完成审核调用
  1346. * @param b
  1347. * @return
  1348. */
  1349. private List<Admin> MemberEnd(TOrderNewBo b) {
  1350. List<Admin> admins;
  1351. admins=adminMapper.getAdminRoleTypeList(AFTConstants.TECH_ADMIN);
  1352. Admin admin = new Admin();
  1353. admin.setId(b.getSalesmanId());
  1354. admins.add(admin);
  1355. pushTOrderNew(b);
  1356. return admins;
  1357. }
  1358. /**
  1359. * 新建完成会员项目修改订单状态
  1360. * @param b
  1361. */
  1362. private void pushTOrderNew(TOrderNewBo b) {
  1363. List<TOrderTaskBo> l = tOrderTaskMapper.selectOrderTask(b.getOrderNo(), 0);
  1364. int counts =l.size();
  1365. int x=0;
  1366. for (TOrderTaskBo t : l) {
  1367. if (t.getTaskStatus()>0) {
  1368. x++;
  1369. }
  1370. }
  1371. TOrderNew n = new TOrderNew();
  1372. n.setOrderNo(b.getOrderNo());
  1373. if (x==0) {
  1374. n.setProcessStatus(4);
  1375. } else if(x<counts) {
  1376. n.setProcessStatus(5);
  1377. } else if(x==counts) {
  1378. n.setProcessStatus(6);
  1379. }
  1380. tOrderNewMapper.updateByPrimaryKeySelective(n);
  1381. }
  1382. /**
  1383. * 发送邮件使用
  1384. * @param type
  1385. * @param aid
  1386. * @param content
  1387. */
  1388. private void sendMemberEmail(Integer type,String aid,String content) {
  1389. Admin admin = adminMapper.selectByPrimaryKey(aid);
  1390. EmailBo bo = new EmailBo(NoticeStatus.getValueByCode(type), admin.getEmail(),content);
  1391. if(com.goafanti.common.utils.StringUtils.isNotBlank(admin.getEmail())) {
  1392. asyncUtils.send(bo);
  1393. }
  1394. }
  1395. @Override
  1396. public int deleteMemberSonProject(Integer id) {
  1397. TOrderTask task = tOrderTaskMapper.selectByPrimaryKey(id);
  1398. tOrderTaskMapper.deleteByPrimaryKey(id);
  1399. List<TOrderTaskListBo> tOrderTaskListBos = tOrderTaskMapper.splitProjectList(task.getSplitSuper(),null);
  1400. //如果没有子项目则修改上级
  1401. if (tOrderTaskListBos==null||tOrderTaskListBos.isEmpty()){
  1402. TOrderTask tOrderTask=new TOrderTask();
  1403. tOrderTask.setId(task.getSplitSuper());
  1404. tOrderTask.setSplitStatus(0);
  1405. tOrderTaskMapper.updateByPrimaryKeySelective(tOrderTask);
  1406. }
  1407. tTaskMidMapper.deleteByPrimaryKey(id);
  1408. tTaskMemberMapper.deleteByPrimaryKey(id);
  1409. tTaskLogMapper.deleteByPrimaryKey(id);
  1410. tTaskMemberMapper.updateServiceYearBySplitSuper(task.getSplitSuper());
  1411. return 1;
  1412. }
  1413. @Override
  1414. public boolean checkOrderProcessStatus(Integer tid, Integer processStatus) {
  1415. TOrderNew tOrderNew = tOrderNewMapper.checkOrderProcessStatus(tid);
  1416. if (tOrderNew.getProcessStatus()>processStatus){
  1417. return true;
  1418. }
  1419. return false;
  1420. }
  1421. @Override
  1422. public void updateMidServiceProject(String orderNo) {
  1423. List<TOrderTaskBo> taskBos = tOrderTaskMapper.selectOrderTaskAll(orderNo, 4);
  1424. if (!taskBos.isEmpty()){
  1425. List<String > cp=new ArrayList<>();
  1426. List<String > cc=new ArrayList<>();
  1427. StringBuffer ps=new StringBuffer();
  1428. StringBuffer cs=new StringBuffer();
  1429. for (TOrderTaskBo taskBo : taskBos) {
  1430. if (!cp.contains(taskBo.getCommodityName())){
  1431. cp.add(taskBo.getCommodityName());
  1432. ps=ps.append(taskBo.getCommodityName());
  1433. String str= NewProjectStatus.getValueByCode(taskBo.getProjectStatus());
  1434. String contacts=taskBo.getContacts()!=null?taskBo.getContacts():"暂无";
  1435. ps=ps.append("-").append(str).append("-").append(contacts).append(",");
  1436. }
  1437. if (!cc.contains(taskBo.getCname())){
  1438. cc.add(taskBo.getCname());
  1439. cs=cs.append(taskBo.getCname()).append(",");
  1440. }
  1441. }
  1442. TOrderMid tOrderMid = new TOrderMid();
  1443. tOrderMid.setOrderNo(orderNo);
  1444. if (ps.length()>1)tOrderMid.setServiceProject(ps.substring(0,ps.length()-1));
  1445. if (ps.length()>1)tOrderMid.setServiceType(cs.substring(0,cs.length()-1));
  1446. tOrderMidMapper.updateByOrderNo(tOrderMid);
  1447. }
  1448. }
  1449. @Override
  1450. public Integer addProjectStop(InputProjectStop in) {
  1451. String[] split = in.getIds().split(",");
  1452. Date date = new Date();
  1453. String adminId = TokenManager.getAdminId();
  1454. for (String s : split) {
  1455. Integer id=Integer.valueOf(s);
  1456. TaskStop use = taskStopMapper.selectByTid(id);
  1457. if (use!=null){
  1458. throw new BusinessException(String.format("项目[%s]暂停流程已存在,请先走完流程",id));
  1459. }
  1460. TOrderTaskDetailBo orderOp = tOrderTaskMapper.getOrderTaskDetail(id);
  1461. if (orderOp.getDeleteSign()==2){
  1462. throw new BusinessException(String.format("订单[%s]存在变更审核,请先走完流程",orderOp.getOrderNo()));
  1463. }
  1464. TaskStop ts = new TaskStop();
  1465. ts.setTid(id);
  1466. ts.setType(in.getType());
  1467. ts.setStatus(0);
  1468. ts.setReason(in.getReason());
  1469. ts.setAnnexUrl(in.getAnnexUrl());
  1470. ts.setCreateBy(adminId);
  1471. ts.setCreateTime(date);
  1472. taskStopMapper.insertSelective(ts);
  1473. TaskStopLog log = new TaskStopLog();
  1474. log.setTaskStopId(ts.getId());
  1475. log.setReason(in.getReason());
  1476. log.setCreateBy(adminId);
  1477. log.setCreateTime(date);
  1478. taskStopLogMapper.insertSelective(log);
  1479. TTaskMid tt=new TTaskMid();
  1480. tt.setTid(id);
  1481. tt.setStopStatus(0);
  1482. tt.setStopType(in.getType());
  1483. tTaskMidMapper.updateByTid(tt);
  1484. }
  1485. asyncUtils.addProjectSotpNotic(0, in.getType(),in.getIds(),null);
  1486. return 1;
  1487. }
  1488. @Override
  1489. public Integer updateProjectStop(InputProjectStop in) {
  1490. TaskStop use = taskStopMapper.selectByPrimaryKey(in.getStopId());
  1491. Date date = new Date();
  1492. String adminId = TokenManager.getAdminId();
  1493. TaskStop ts = new TaskStop();
  1494. ts.setId(in.getStopId());
  1495. ts.setType(in.getType());
  1496. ts.setStatus(0);
  1497. ts.setReason(in.getReason());
  1498. ts.setAnnexUrl(in.getAnnexUrl());
  1499. taskStopMapper.updateByPrimaryKeySelective(ts);
  1500. TaskStopLog log = new TaskStopLog();
  1501. log.setTaskStopId(ts.getId());
  1502. log.setReason(in.getReason());
  1503. log.setCreateBy(adminId);
  1504. log.setCreateTime(date);
  1505. taskStopLogMapper.insertSelective(log);
  1506. TTaskMid tt=new TTaskMid();
  1507. tt.setTid(use.getTid());
  1508. tt.setStopStatus(0);
  1509. tTaskMidMapper.updateByTid(tt);
  1510. asyncUtils.addProjectSotpNotic(0, in.getType(),use.getTid().toString(),null);
  1511. return 1;
  1512. }
  1513. @Override
  1514. public Pagination<?> selectProjectStop(String orderNo, String userName, String depId, String contractNo, String projectName,
  1515. Integer status,String startTime,String endTime,String receiverId,
  1516. Integer shiroType,Integer pageNo, Integer pageSize) {
  1517. Map<String,Object>params =new HashMap<>();
  1518. if (orderNo!=null)params.put("orderNo",orderNo);
  1519. if (userName!=null)params.put("userName",userName);
  1520. if (depId!=null)params.put("depId",depId);
  1521. if (contractNo!=null)params.put("contractNo",contractNo);
  1522. if (projectName!=null)params.put("projectName",projectName);
  1523. if (status!=null)params.put("status",status);
  1524. if (startTime!=null)params.put("startTime",startTime);
  1525. if (endTime!=null)params.put("endTime",endTime+" 23:59:59");
  1526. if (receiverId!=null)params.put("receiverId",receiverId);
  1527. if (shiroType==0){
  1528. if (TokenManager.hasRole(AFTConstants.SALESMAN)||TokenManager.hasRole(AFTConstants.SALESMAN_MANAGER)){
  1529. params.put("shiro",1);
  1530. params.put("aid",TokenManager.getAdminId());
  1531. }
  1532. }else if (shiroType==1){
  1533. if (TokenManager.hasRole(AFTConstants.SUPERADMIN)){
  1534. params.put("shiro",0);
  1535. }else if (TokenManager.hasRole(AFTConstants.SALESMAN_ADMIN)){
  1536. params.put("shiro",2);
  1537. params.put("deps",departmentService.selectMyDeps());
  1538. }
  1539. }else {
  1540. return new Pagination<>();
  1541. }
  1542. return findPage("selectProjectSotpList","selectProjectSotpCount",params,pageNo,pageSize);
  1543. }
  1544. @Override
  1545. public List<TaskStopLogBo> projectStopList(Integer taskStopId) {
  1546. List<TaskStopLogBo> list =taskStopLogMapper.selectListBySoptId(taskStopId);
  1547. return list;
  1548. }
  1549. @Override
  1550. public Object pushExamineProjectStop(InputTaskStopLog in) {
  1551. TaskStop use = taskStopMapper.selectByPrimaryKey(in.getTaskStopId());
  1552. TaskStop t=new TaskStop();
  1553. t.setId(use.getId());
  1554. TOrderTask task = tOrderTaskMapper.selectByPrimaryKey(use.getTid());
  1555. if (in.getStatus()==1){
  1556. t.setStatus(1);
  1557. StringBuffer str =new StringBuffer();
  1558. str.append("项目状态修改为:");
  1559. if (use.getType()==0){
  1560. task.setProjectStatus(NewProjectStatus.ZT.getCode());
  1561. str=str.append("已暂停");
  1562. //处理时间
  1563. pushExamineTaskTimes(task);
  1564. }else {
  1565. task.setProjectStatus(NewProjectStatus.JXZ.getCode());
  1566. str=str.append("进行中");
  1567. }
  1568. TaskLog taskLog = new TaskLog();
  1569. taskLog.setStopId(in.getTaskStopId());
  1570. taskLog.setTaskId(use.getTid());
  1571. taskLog.setContent(str.toString());
  1572. taskLog.setAid(use.getCreateBy());
  1573. taskLogMapper.insertSelective(taskLog);
  1574. TOrderTask task2 =new TOrderTask();
  1575. task2.setId(task.getId());
  1576. task2.setProjectStatus(task.getProjectStatus());
  1577. tOrderTaskMapper.updateByPrimaryKeySelective(task2);
  1578. tOrderMidMapper.updateStopProjectByOrderNo(task.getOrderNo());
  1579. if (task.getSplitStatus()==1){
  1580. TOrderTask tot=new TOrderTask();
  1581. tot.setSplitSuper(task.getId());
  1582. tot.setProjectStatus(NewProjectStatus.ZT.getCode());
  1583. tOrderTaskMapper.updateBySuperId(tot);
  1584. }
  1585. updateMidServiceProject(task.getOrderNo());
  1586. examineProjectSotpAddNotice(task,1,use.getType());
  1587. }else if(in.getStatus()==2) {
  1588. t.setStatus(2);
  1589. examineProjectSotpAddNotice(task,2,use.getType());
  1590. }
  1591. TTaskMid tt=new TTaskMid();
  1592. tt.setTid(use.getTid());
  1593. tt.setStopStatus(in.getStatus());
  1594. tTaskMidMapper.updateByTid(tt);
  1595. TaskStopLog tsl=new TaskStopLog();
  1596. tsl.setTaskStopId(in.getTaskStopId());
  1597. tsl.setReason(in.getReason());
  1598. tsl.setStatus(in.getStatus());
  1599. tsl.setCreateTime(new Date());
  1600. tsl.setCreateBy(TokenManager.getAdminId());
  1601. taskStopLogMapper.insertSelective(tsl);
  1602. return taskStopMapper.updateByPrimaryKeySelective(t);
  1603. }
  1604. private void pushExamineTaskTimes(TOrderTask task) {
  1605. TaskTime tt=new TaskTime();
  1606. tt.setTid(task.getId());
  1607. tt.setProjectStatus(task.getProjectStatus());
  1608. tt.setDateTime(new Date());
  1609. int i = taskTimeMapper.updateByTidAndProjectSelective(tt);
  1610. if (i==0){
  1611. taskTimeMapper.insertSelective(tt);
  1612. }
  1613. }
  1614. private void examineProjectSotpAddNotice(TOrderTask task,Integer status,Integer sotpType) {
  1615. asyncUtils.addProjectSotpNotic(status,sotpType,null,task);
  1616. }
  1617. @Override
  1618. public Object updateSatisfactionDegree(Integer id, Integer formRetrieve, Integer satisfactionDegree, String satisfactionDegreeUrl) {
  1619. TOrderTask in=new TOrderTask();
  1620. in.setId(id);
  1621. in.setFormRetrieve(formRetrieve);
  1622. if(formRetrieve==2){
  1623. if(satisfactionDegree!=null)in.setSatisfactionDegree(satisfactionDegree);
  1624. in.setSatisfactionDegreeUrl(satisfactionDegreeUrl);
  1625. }else if (formRetrieve==4){
  1626. in.setSatisfactionDegreeUrl(satisfactionDegreeUrl);
  1627. }
  1628. return tOrderTaskMapper.updateByPrimaryKeySelective(in);
  1629. }
  1630. }