OrderProjectServiceImpl.java 81 KB

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