OrderProjectServiceImpl.java 80 KB

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