OrderProjectServiceImpl.java 85 KB

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