OrderProjectServiceImpl.java 78 KB

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