OrderProjectServiceImpl.java 65 KB

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