OrderProjectServiceImpl.java 47 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156
  1. package com.goafanti.order.service.impl;
  2. import java.io.UnsupportedEncodingException;
  3. import java.math.BigDecimal;
  4. import java.text.ParseException;
  5. import java.text.SimpleDateFormat;
  6. import java.util.ArrayList;
  7. import java.util.Date;
  8. import java.util.HashMap;
  9. import java.util.List;
  10. import java.util.Map;
  11. import java.util.UUID;
  12. import javax.mail.MessagingException;
  13. import com.goafanti.admin.bo.AdminListBo;
  14. import com.goafanti.common.bo.*;
  15. import com.goafanti.common.bo.Error;
  16. import com.goafanti.common.dao.*;
  17. import com.goafanti.common.utils.*;
  18. import com.goafanti.common.utils.excel.NewExcelUtil;
  19. import com.goafanti.order.bo.*;
  20. import org.apache.commons.collections4.map.HashedMap;
  21. import org.apache.commons.lang3.StringUtils;
  22. import org.slf4j.Logger;
  23. import org.slf4j.LoggerFactory;
  24. import org.springframework.beans.factory.annotation.Autowired;
  25. import org.springframework.beans.factory.annotation.Value;
  26. import org.springframework.stereotype.Service;
  27. import org.springframework.transaction.annotation.Transactional;
  28. import com.goafanti.common.constant.AFTConstants;
  29. import com.goafanti.common.constant.ErrorConstants;
  30. import com.goafanti.common.enums.ChannelStatus;
  31. import com.goafanti.common.enums.NoticeStatus;
  32. import com.goafanti.common.enums.OrderLogProcess;
  33. import com.goafanti.common.error.BusinessException;
  34. import com.goafanti.common.model.Admin;
  35. import com.goafanti.common.model.BusinessProject;
  36. import com.goafanti.common.model.Notice;
  37. import com.goafanti.common.model.OrganizationContactBook;
  38. import com.goafanti.common.model.OrganizationIdentity;
  39. import com.goafanti.common.model.ProjcetCheckLog;
  40. import com.goafanti.common.model.TArrearsDun;
  41. import com.goafanti.common.model.TOrderBonus;
  42. import com.goafanti.common.model.TOrderLog;
  43. import com.goafanti.common.model.TOrderMid;
  44. import com.goafanti.common.model.TOrderNew;
  45. import com.goafanti.common.model.TOrderTask;
  46. import com.goafanti.common.model.TTaskHours;
  47. import com.goafanti.common.model.TTaskLog;
  48. import com.goafanti.common.model.TTaskMid;
  49. import com.goafanti.common.model.TaskAttributionLog;
  50. import com.goafanti.common.model.TaskHoursCount;
  51. import com.goafanti.common.model.TaskLog;
  52. import com.goafanti.common.model.TaskProgress;
  53. import com.goafanti.common.model.TaskProgressLog;
  54. import com.goafanti.common.model.UserBusiness;
  55. import com.goafanti.common.model.UserChannel;
  56. import com.goafanti.common.model.UserLockRelease;
  57. import com.goafanti.core.mybatis.BaseMybatisDao;
  58. import com.goafanti.core.mybatis.page.Pagination;
  59. import com.goafanti.core.shiro.token.TokenManager;
  60. import com.goafanti.order.bo.InputProjectCheck;
  61. import com.goafanti.order.enums.BonusSubject;
  62. import com.goafanti.order.enums.NewOrderDunType;
  63. import com.goafanti.order.enums.NewProjectStatus;
  64. import com.goafanti.order.enums.OrderDunProjectType;
  65. import com.goafanti.order.enums.ProcessStatus;
  66. import com.goafanti.order.service.OrderNewService;
  67. import com.goafanti.order.service.OrderProjectService;
  68. import com.goafanti.organization.bo.OutPaymentNode;
  69. import com.goafanti.techproject.enums.TaskState;
  70. @Service
  71. public class OrderProjectServiceImpl extends BaseMybatisDao<TOrderTaskMapper> implements OrderProjectService {
  72. @Autowired
  73. private TOrderTaskMapper tOrderTaskMapper;
  74. @Autowired
  75. private TOrderNewMapper tOrderNewMapper;
  76. @Autowired
  77. private TTaskHoursMapper tTaskHoursMapper;
  78. @Autowired
  79. private TOrderBonusMapper tOrderBonusMapper;
  80. @Autowired
  81. private TTaskLogMapper tTaskLogMapper;
  82. @Autowired
  83. private TOrderLogMapper tOrderLogMapper;
  84. @Autowired
  85. private TaskProgressMapper taskProgressMapper;
  86. @Autowired
  87. private TaskProgressLogMapper taskProgressLogMapper;
  88. @Autowired
  89. private OrganizationContactBookMapper organizationContactBookMapper;
  90. @Autowired
  91. private OrganizationIdentityMapper organizationIdentityMapper;
  92. @Autowired
  93. private TaskLogMapper taskLogMapper;
  94. @Autowired
  95. private OrderNewService orderNewService;
  96. @Autowired
  97. private TaskHoursCountMapper taskHoursCountMapper;
  98. @Autowired
  99. private AdminMapper adminMapper;
  100. @Autowired
  101. private BusinessProjectMapper businessProjectMapper;
  102. @Autowired
  103. private NewOrderDunMapper newOrderDunMapper;
  104. @Autowired
  105. private TOrderMidMapper tOrderMidMapper;
  106. @Autowired
  107. private TArrearsDunMapper tArrearsDunMapper;
  108. @Autowired
  109. private PaymentNodeMapper paymentNodeMapper;
  110. @Autowired
  111. private TTaskMidMapper tTaskMidMapper;
  112. @Autowired
  113. private UserMapper userMapper;
  114. @Autowired
  115. private UserLockReleaseMapper userLockReleaseMapper;
  116. @Autowired
  117. private UserBusinessMapper userBusinessMapper;
  118. @Autowired
  119. private UserChannelMapper userChannelMapper;
  120. @Autowired
  121. private TaskAttributionLogMapper taskAttributionLogMapper;
  122. @Autowired
  123. private ProjcetCheckLogMapper projcetCheckLogMapper;
  124. @Autowired
  125. private TOrderPaymentMapper tOrderPaymentMapper;
  126. @Autowired
  127. private PublicReleaseMapper publicReleaseMapper;
  128. @Autowired
  129. private AsyncUtils asyncUtils;
  130. @Value(value = "${upload.path}")
  131. private String uploadPath = null;
  132. Logger logger = LoggerFactory.getLogger(OrderProjectServiceImpl.class);
  133. @Override
  134. @Transactional
  135. public int updateProjectDistribution(Integer taskId, String taskReceiverId,String remarks,Integer type) {
  136. TOrderTask t=tOrderTaskMapper.selectByPrimaryKey(taskId);
  137. TOrderNew tn=checkDeleteSign(t.getOrderNo());
  138. Date date=new Date();
  139. t.setTaskStatus(TaskState.DISTRIBUTION.getCode());
  140. t.setTaskAllocator(TokenManager.getAdminId());
  141. t.setTaskReceiver(taskReceiverId);
  142. t.setTaskDistributionTime(date);
  143. Admin a=adminMapper.selectByPrimaryKey(taskReceiverId);
  144. insetLog(taskId, taskReceiverId);
  145. addtaskAttributionLog(taskId,taskReceiverId,remarks,type,date);
  146. if (a==null||a.getId()==null) {
  147. throw new BusinessException(new Error("分配人员不存在!","分配人员不存在!"));
  148. }
  149. if (type==0) {
  150. addOrderLog(t.getOrderNo(), OrderLogProcess.XMDDPD.getCode(),remarks);
  151. t.setManagerId(taskReceiverId);
  152. t.setConsultantId(null);
  153. //设置催款触发
  154. orderNewService.pushOrderDun(t.getOrderNo());
  155. //未锁定客户就锁定客户
  156. pushUser(t, tn, date);
  157. }else if(type==1) {
  158. t.setManagerId(taskReceiverId);
  159. t.setConsultantId(null);
  160. }else if(type==2) {
  161. addOrderLog(t.getOrderNo(), OrderLogProcess.XMJLPD.getCode(),remarks);
  162. t.setConsultantId(taskReceiverId);
  163. }else if(type==4) {
  164. t.setConsultantId(null);
  165. }
  166. t.setReceiverName(a.getName());
  167. tOrderTaskMapper.updateByPrimaryKey(t);
  168. List<String> aids = new ArrayList<>();
  169. aids.add(taskReceiverId);
  170. TOrderNewBo order = tOrderNewMapper.getSaleIdByOno(t.getOrderNo());
  171. orderNewService.pushGeneralSendNoticeAndEmail(aids, NoticeStatus.ORDER_TASK_TO.getCode(),order, TokenManager.getAdminId(),0,taskId);
  172. checkProjiectAllocation(t.getOrderNo());
  173. return 1;
  174. }
  175. /**
  176. * 推动客户、业务渠道的锁定
  177. * @param t
  178. * @param tn
  179. * @param date
  180. */
  181. private void pushUser(TOrderTask t, TOrderNew tn, Date date) {
  182. if (userMapper.checkLock(tn.getBuyerId())<1) {
  183. userLockReleaseMapper.updateByAidAndUid(tn.getSalesmanId(),tn.getBuyerId());
  184. userMapper.updateShareType(tn.getBuyerId(),tn.getSalesmanId());
  185. }
  186. //未锁定业务就锁定业务
  187. if (userLockReleaseMapper.checkLock(tn.getSalesmanId(),tn.getBuyerId(),t.getCommodityId())<1) {
  188. UserLockRelease ulr=new UserLockRelease();
  189. ulr.setId(UUID.randomUUID().toString());
  190. ulr.setBusinessProjectId(t.getCommodityId());
  191. ulr.setType(1);
  192. ulr.setUid(tn.getBuyerId());
  193. ulr.setAid(tn.getSalesmanId());
  194. ulr.setStatus(0);
  195. ulr.setLockTime(date);
  196. userLockReleaseMapper.insertSelective(ulr);
  197. }
  198. UserBusiness ub=new UserBusiness();
  199. ub.setId(UUID.randomUUID().toString());
  200. ub.setUid(tn.getBuyerId());
  201. ub.setAid(tn.getSalesmanId());
  202. ub.setFollowSituation(5);
  203. ub.setCustomerStatus(4);
  204. ub.setCreateTime(date);
  205. ub.setUpdateTime(date);
  206. ub.setRemarks("派单自动锁定客户");
  207. ub.setBusinessProjectId(t.getCommodityId());
  208. userBusinessMapper.insertSelective(ub);
  209. //如果是渠道客户更新渠道表
  210. UserChannel uc=new UserChannel();
  211. uc.setUid(tn.getBuyerId());
  212. uc.setStatus(ChannelStatus.YQD.getCode());
  213. uc.setSignTime(date);
  214. userChannelMapper.updateByUid(uc);
  215. //标记最新的打卡
  216. publicReleaseMapper.updateSignByAidAndUid(tn.getBuyerId(),tn.getSalesmanId());
  217. }
  218. private void addtaskAttributionLog(Integer taskId, String taskReceiverId, String remarks, Integer type, Date date) {
  219. TaskAttributionLog log=new TaskAttributionLog(taskId,TokenManager.getAdminId(),taskReceiverId,remarks,type,date);
  220. taskAttributionLogMapper.insertSelective(log);
  221. }
  222. public TOrderNew checkDeleteSign(String orderNo) {
  223. TOrderNew t=tOrderNewMapper.selectByPrimaryKey(orderNo);
  224. if(t.getDeleteSign()==2||t.getDeleteSign()==3) throw new BusinessException(new Error(ErrorConstants.ORDER_ALREADY_REVOKE, t.getOrderNo(),""));
  225. return t;
  226. }
  227. public void addOrderLog(String orderNo, Integer code,String remarks) {
  228. TOrderLog tl=new TOrderLog();
  229. tl.setOrderNo(orderNo);
  230. tl.setProcess(code);
  231. tl.setAid(TokenManager.getAdminId());
  232. if(null!=remarks)tl.setRemarks(remarks);
  233. tOrderLogMapper.insertSelective(tl);
  234. }
  235. public void checkProjiectAllocation(String orderNo) {
  236. List<TOrderTaskBo> taskBos=tOrderTaskMapper.selectOrderTask(orderNo,0);
  237. TOrderNew tNew=new TOrderNew();
  238. tNew.setOrderNo(orderNo);
  239. int i=0;
  240. for (TOrderTaskBo to : taskBos) {
  241. if (to.getTaskStatus()>TaskState.UN_DISTRIBUTION.getCode()&&to.getTaskStatus()<TaskState.INVALID.getCode()) {
  242. i++;
  243. }
  244. }
  245. if (i==taskBos.size()) {
  246. tNew.setProcessStatus(ProcessStatus.YQBFPZXSGLY.getCode());
  247. }else if(i>0&&i<taskBos.size()){
  248. tNew.setProcessStatus(ProcessStatus.YBFPZXSGLY.getCode());
  249. }else if(i==0){
  250. tNew.setProcessStatus(ProcessStatus.YPZXSGLY.getCode());
  251. }
  252. tOrderNewMapper.updateByPrimaryKeySelective(tNew);
  253. }
  254. private void insetLog(Integer taskId, String taskReceiverId) {
  255. TTaskLog tl=new TTaskLog();
  256. tl.setCreateTime(new Date());
  257. tl.setTaskId(taskId);
  258. tl.setTaskAllocator(TokenManager.getAdminId());
  259. tl.setTaskReceiver(taskReceiverId);
  260. tTaskLogMapper.insertSelective(tl);
  261. }
  262. @SuppressWarnings("unchecked")
  263. @Override
  264. public Pagination<TOrderTaskListBo> orderTaskList(inuptTaskListBo ib) {
  265. Map<String, Object> params = new HashMap<String, Object>();
  266. if(ib.getPageSize()==null||ib.getPageSize()<0)ib.setPageSize(10);
  267. if(ib.getPageNo()==null||ib.getPageNo()<0)ib.setPageNo(1);
  268. params.put("outsource", ib.getOutsource()==null?0:ib.getOutsource());
  269. if (null!=ib.getSpecially()) params.put("specially", ib.getSpecially());
  270. if (StringUtils.isNotBlank(ib.getName())) params.put("name", ib.getName());
  271. if (StringUtils.isNotBlank(ib.getDepId())) params.put("depId", ib.getDepId());
  272. if (StringUtils.isNotBlank(ib.getOrderNo())) params.put("orderNo", ib.getOrderNo());
  273. if (StringUtils.isNotBlank(ib.getContractNo())) params.put("contractNo", ib.getContractNo());
  274. if (ib.getProjectStatus() !=null ) params.put("projectStatus", ib.getProjectStatus());
  275. if (StringUtils.isNotBlank(ib.getTaskId())) params.put("taskId", ib.getTaskId());
  276. if (ib.getApproval() !=null) params.put("approval", ib.getApproval());
  277. if (StringUtils.isNotBlank(ib.getAdminName())) params.put("adminName", ib.getAdminName());
  278. if (StringUtils.isNotBlank(ib.getStartTime())) params.put("startTime", ib.getStartTime());
  279. if (StringUtils.isNotBlank(ib.getEndTime())) params.put("endTime", ib.getEndTime());
  280. if (null != ib.getTaskStatus()) params.put("taskStatus", ib.getTaskStatus());
  281. if (ib.getOutsourceStatus() !=null) params.put("outsourceStatus", ib.getOutsourceStatus());
  282. if (ib.getCid() !=null) params.put("cid", ib.getCid());
  283. List<String> fids=new ArrayList<>();
  284. if (TokenManager.hasRole(AFTConstants.FINANCE_ADMIN) ||TokenManager.hasRole(AFTConstants.SUPERADMIN)||
  285. TokenManager.hasRole(AFTConstants.CED)||TokenManager.hasRole(AFTConstants.APPROVAL_DECISION)||
  286. TokenManager.hasRole(AFTConstants.VICE_CEO)) {
  287. params.put("role", 2);
  288. }else if (TokenManager.hasRole(AFTConstants.FINANCE_MANAGER)) {
  289. params.put("role", 1);
  290. fids =adminMapper.selectBySuperId(TokenManager.getAdminId());
  291. params.put("fids",fids);
  292. }else if (TokenManager.hasRole(AFTConstants.FINANCE)) {
  293. params.put("role", 1);
  294. fids.add(TokenManager.getAdminId());
  295. params.put("fids",fids);
  296. } else {
  297. params.put("role", 0);
  298. params.put("aid", TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  299. }
  300. Pagination<TOrderTaskListBo> p = (Pagination<TOrderTaskListBo>)findPage("selectOrderTaskListByPage", "selectOrderTaskListCount", params, ib.getPageNo(), ib.getPageSize());
  301. List<TOrderTaskListBo> list=(List<TOrderTaskListBo>) p.getList();
  302. for (TOrderTaskListBo t : list) {
  303. if(t.getSplitStatus()==1) {
  304. List<TOrderTaskListBo> l=splitProjectList(t.getId());
  305. t.setSplitList(l);
  306. }
  307. }
  308. return p;
  309. }
  310. @Override
  311. public TOrderTaskDetailBo orderTaskDetail(String id) {
  312. TOrderTaskDetailBo t=tOrderTaskMapper.getOrderTaskDetail(id);
  313. if (TokenManager.hasRole(AFTConstants.SUPERADMIN)||TokenManager.hasRole(AFTConstants.APPROVAL_DECISION)
  314. ||TokenManager.hasRole(AFTConstants.APPROVAL_DECISION)||TokenManager.hasRole(AFTConstants.TECH_ADMIN)
  315. ||TokenManager.getAdminId().equals(t.getTaskReceiver())) {
  316. return t;
  317. }else {
  318. t.setOutsourceName("****");
  319. t.setOutsourcePrice("****");
  320. t.setDeclareUser("****");
  321. t.setDeclarePwd("****");
  322. t.setCertificateNumber("****");
  323. return t;
  324. }
  325. }
  326. @Override
  327. @Transactional
  328. public int updateOrderTask(TOrderTaskDetailBo t) {
  329. TOrderTask task=new TOrderTask();
  330. TOrderNew tn=checkDeleteSign(t.getOrderNo());
  331. task.setAttachmentUrl(t.getAttachmentUrl());
  332. task.setId(Integer.valueOf(t.getId()));
  333. task.setTaskComment(t.getTaskComment());
  334. task.setCertificateNumber(t.getCertificateNumber());
  335. task.setStatus(t.getStatus());
  336. task.setFormRetrieve(t.getFormRetrieve());
  337. task.setTaskRefund(t.getTaskRefund());
  338. task.setRefundContent(t.getRefundContent());
  339. task.setRetrieveContent(t.getRetrieveContent());
  340. task.setDeclareUser(t.getDeclareUser());
  341. task.setDeclarePwd(t.getDeclarePwd());
  342. task.setArrivalMoney(t.getArrivalMoney());
  343. task.setSetUpAmount(t.getSetUpAmount());
  344. task.setOutsourceName(t.getOutsourceName());
  345. task.setDeclarationBatch(t.getDeclarationBatch());
  346. task.setSetUpStatus(t.getSetUpStatus());
  347. if(t.getSetUpTime()!=null)task.setSetUpTime(DateUtils.StringToDate(t.getSetUpTime(), AFTConstants.YYYYMMDD));
  348. task.setSpotCheckStatus(t.getSpotCheckStatus());
  349. task.setHighTechStatus(t.getHighTechStatus());
  350. task.setSpecialComment(t.getSpecialComment());
  351. if(StringUtils.isNotBlank(t.getOutsourcePrice()))task.setOutsourcePrice(new BigDecimal(t.getOutsourcePrice()));
  352. if (t.getIfCertificationFee()!=null&&t.getIfCertificationFee()==1) {
  353. task.setCertificationCorporate(t.getCertificationCorporate());
  354. task.setCertificationFee(t.getCertificationFee());
  355. }
  356. //根据修改的修改订单法人与联系人
  357. if(StringUtils.isNotEmpty(t.getContacts()))tn.setContacts(t.getContacts());
  358. if(StringUtils.isNotEmpty(t.getContactMobile())) tn.setContactMobile(t.getContactMobile());
  359. if(StringUtils.isNotEmpty(t.getLegalPerson()))tn.setLegalPerson(t.getLegalPerson());
  360. if(StringUtils.isNotEmpty(t.getLegalPersonTel()))tn.setLegalPersonTel(t.getLegalPersonTel());
  361. tOrderNewMapper.updateByPrimaryKeySelective(tn);
  362. //修改公司地址信息
  363. if (null!=t.getLocationProvince()||null!=t.getLocationArea()||null!=t.getLocationCity()||null!=t.getPostalAddress()) {
  364. OrganizationIdentity org=new OrganizationIdentity();
  365. org.setUid(tn.getBuyerId());
  366. org.setLocationProvince(t.getLocationProvince());
  367. org.setLocationArea(t.getLocationArea());
  368. org.setLocationCity(t.getLocationCity());
  369. org.setPostalAddress(t.getPostalAddress());
  370. organizationIdentityMapper.updateServiceByUid(org);
  371. }
  372. //修改公司联系人
  373. int adcount=organizationContactBookMapper.checkContacts(tn.getBuyerId(), t.getContactMobile(),tn.getSalesmanId());
  374. if (StringUtils.isNotBlank(t.getContacts())&&StringUtils.isNotBlank(t.getContactMobile())&&adcount<1) {
  375. OrganizationContactBook contactBook=new OrganizationContactBook();
  376. contactBook.setId(UUID.randomUUID().toString());
  377. contactBook.setAid(tn.getSalesmanId());
  378. contactBook.setUid(tn.getBuyerId());
  379. contactBook.setName(t.getContacts());
  380. contactBook.setMobile(t.getContactMobile());
  381. organizationContactBookMapper.insertSelective(contactBook);
  382. }
  383. //新增结算奖金信息
  384. checkSettlementAward(tn,task);
  385. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  386. try {
  387. if(StringUtils.isNotBlank(t.getStartDate()))task.setTaskStartTime(sdf.parse(t.getStartDate()));
  388. if(StringUtils.isNotBlank(t.getEndDate()))task.setTaskEndTime(sdf.parse(t.getEndDate()));
  389. if(StringUtils.isNotBlank(t.getAcceptDate()))task.setAcceptTime(sdf.parse(t.getAcceptDate()));
  390. if(StringUtils.isNotBlank(t.getReviewDate()))task.setReviewTime(sdf.parse(t.getReviewDate()));
  391. if(StringUtils.isNotBlank(t.getPublicityDate()))task.setPublicityTime(sdf.parse(t.getPublicityDate()));
  392. if(StringUtils.isNotBlank(t.getLicenceDate()))task.setLicenceTime(sdf.parse(t.getLicenceDate()));
  393. } catch (ParseException e) {
  394. e.printStackTrace();
  395. }
  396. tOrderTaskMapper.updateByPrimaryKeySelective(task);
  397. //项目中间表修改
  398. if (t.getUrgentDay()!=null||t.getIfMaterial()!=null||t.getRejectCount()!=null||
  399. t.getAcceptCount()!=null||t.getAuthorizeCount()!=null||t.getSpotCheckStatus()!=null) {
  400. TTaskMid tm=new TTaskMid();
  401. tm.setTid(task.getId());
  402. if (t.getUrgentDay()!=null)tm.setUrgentDay(t.getUrgentDay());
  403. if (t.getIfMaterial()!=null)tm.setIfMaterial(t.getIfMaterial());
  404. if (t.getRejectCount()!=null)tm.setRejectCount(t.getRejectCount());
  405. if (t.getAcceptCount()!=null)tm.setAcceptCount(t.getAcceptCount());
  406. if (t.getAuthorizeCount()!=null)tm.setAuthorizeCount(t.getAuthorizeCount());
  407. if (t.getSpotCheckStatus()==1||t.getSpotCheckStatus()==2){
  408. tm.setSpotCheckCount(t.getCommodityQuantity());
  409. if (t.getSpotCheckStatus()==2){
  410. tm.setFailCount(t.getCommodityQuantity());
  411. }
  412. }
  413. tTaskMidMapper.updateByTid(tm);
  414. }
  415. TaskLog tl=new TaskLog();
  416. tl.setCreateTime(new Date());
  417. tl.setTaskId(t.getId());
  418. tl.setAid(TokenManager.getAdminId());
  419. //项目触发发催款
  420. return 1;
  421. }
  422. public int updateProjectStatus(UpdateProjectStatusBo b) {
  423. TOrderTask t=new TOrderTask();
  424. t.setId(b.getTid());
  425. t.setProjectStatus(b.getProjectStatus());
  426. t.setTimeRecord(b.getTimeRecord());
  427. t.setCertificateNumber(b.getCertificateNumber());
  428. if(b.getSetUpAmount()!=null)t.setSetUpAmount(new BigDecimal(b.getSetUpAmount()));
  429. if (b.getPubicityUrl()!=null)t.setPubicityUrl(b.getPubicityUrl());
  430. TOrderTask task2=tOrderTaskMapper.selectByPrimaryKey(b.getTid());//查询出项目信息
  431. if(b.getProjectStatus()!=task2.getProjectStatus()){
  432. TTaskMid taskMid = new TTaskMid();
  433. taskMid.setTid(b.getTid());
  434. if(b.getProjectStatus()==NewProjectStatus.YLX.getCode()||b.getProjectStatus()==NewProjectStatus.YNGS.getCode()){
  435. t.setSetUpStatus(1);
  436. taskMid.setSetUpCount(task2.getCommodityQuantity());
  437. if (b.getProjectStatus()==NewProjectStatus.YNGS.getCode()){
  438. t.setIfPublicity(1);
  439. taskMid.setPromulgateCount(task2.getCommodityQuantity());
  440. }
  441. }
  442. //大于3计做已完成 不计做库存
  443. if (b.getProjectStatus()>3){
  444. taskMid.setCompleteCount(task2.getCommodityQuantity());
  445. taskMid.setStockCount(0);
  446. }
  447. tTaskMidMapper.updateByTid(taskMid);
  448. tOrderTaskMapper.updateByPrimaryKeySelective(t);
  449. projectSplitPush(b.getTid(), b.getProjectStatus(),task2);
  450. pushTaskLog(b.getTid(), b.getProjectStatus());
  451. }
  452. return 1;
  453. }
  454. /**
  455. * 推动项目日志
  456. * @param tid
  457. * @param projectStatus
  458. */
  459. private void pushTaskLog(Integer tid,Integer projectStatus) {
  460. TaskLog tl = new TaskLog();
  461. tl.setCreateTime(new Date());
  462. tl.setTaskId(tid);
  463. tl.setAid(TokenManager.getAdminId());
  464. StringBuffer s = new StringBuffer("项目状态修改为:");
  465. s.append(NewProjectStatus.getValueByCode(projectStatus));
  466. tl.setContent(s.toString());
  467. taskLogMapper.insertSelective(tl);
  468. }
  469. //推动项目计算及催款
  470. private void projectSplitPush(Integer tid, Integer projectStatus,TOrderTask task2) {
  471. //0否 1父拆分 2子拆分 如果没有拆分
  472. if (task2.getSplitStatus()==0) {
  473. pushOrderDunAndPaymentNode(tid,projectStatus,task2);
  474. //如果是子项目
  475. }else if (task2.getSplitStatus()==2){
  476. //查出父项目
  477. List<TOrderTaskListBo> list=tOrderTaskMapper.splitProjectList(task2.getSplitSuper());
  478. //设置一个比较大的流程数字,然后取最小的
  479. Integer i=28;
  480. for (TOrderTaskListBo tt : list) {
  481. if (tt.getProjectStatus()<i) i=tt.getProjectStatus();
  482. }
  483. TOrderTask fatherTask=new TOrderTask();
  484. fatherTask.setId(task2.getSplitSuper());
  485. fatherTask.setProjectStatus(i);
  486. tOrderTaskMapper.updateByPrimaryKeySelective(fatherTask);
  487. TOrderTask task3=tOrderTaskMapper.selectByPrimaryKey(task2.getSplitSuper());
  488. //设置父任务
  489. TOrderTaskDetailBo t2=new TOrderTaskDetailBo();
  490. t2.setOrderNo(task2.getOrderNo());
  491. t2.setId(task2.getSplitSuper());
  492. t2.setProjectStatus(task3.getProjectStatus());
  493. pushOrderDunAndPaymentNode(t2.getId(),t2.getProjectStatus(),task3);
  494. }
  495. if (task2.getSuperId()!=null) {//有父项目
  496. TOrderTask task3 =tOrderTaskMapper.selectBySuperId(task2.getSuperId());
  497. task3.setId(Integer.valueOf(task2.getSuperId()));
  498. task3.setSuperId(null);
  499. tOrderTaskMapper.updateByPrimaryKeySelective(task3);
  500. TOrderTask task4 = tOrderTaskMapper.selectByPrimaryKey(Integer.valueOf(task2.getSuperId()));
  501. meanwhileUpdateOrder(task4);
  502. }else {
  503. meanwhileUpdateOrder(task2);
  504. }
  505. }
  506. /**
  507. * 项目状态达到触发催款
  508. * @param tid
  509. * @param projectStatus
  510. * @param task2
  511. */
  512. private void pushOrderDunAndPaymentNode(Integer tid,Integer projectStatus,TOrderTask task2) {
  513. List<OutNewOrderDunBo> list=newOrderDunMapper.selectByTid(tid);
  514. for (OutNewOrderDunBo ob : list) {
  515. if (ob!=null) {
  516. boolean flag=false;
  517. if((ob.getProjectType()==OrderDunProjectType.CGZH.getCode()&&ob.getDunType()==2&&//成果转化 验收
  518. projectStatus==NewProjectStatus.YWCXZ.getCode()))flag=true;
  519. else if((ob.getProjectType()==OrderDunProjectType.COMMON.getCode()&&ob.getDunType()==2&&//通用 公示
  520. projectStatus==NewProjectStatus.YTJ.getCode()))flag=true;
  521. else if((ob.getProjectType()==OrderDunProjectType.COMMON.getCode()&&ob.getDunType()==3&&//通用 下证
  522. projectStatus==NewProjectStatus.YWCXZ.getCode()))flag=true;
  523. else if((ob.getProjectType()==OrderDunProjectType.KJXM.getCode()&&ob.getDunType()==2&&//科技项目 立项或者公示
  524. projectStatus==NewProjectStatus.YLX.getCode()))flag=true;
  525. else if((ob.getProjectType()==OrderDunProjectType.KJXM.getCode()&&ob.getDunType()==3&&//科技项目 拨款
  526. projectStatus==NewProjectStatus.LXYBK.getCode()))flag=true;
  527. else if((ob.getProjectType()==OrderDunProjectType.KJJR.getCode()&&ob.getDunType()==2&&//科技金融 拨款
  528. projectStatus==NewProjectStatus.YWCXZ.getCode()))flag=true;
  529. else if((ob.getProjectType()==OrderDunProjectType.RJKF.getCode()&&ob.getDunType()==2&&//软件开发 立项
  530. projectStatus==NewProjectStatus.YTJ.getCode()))flag=true;
  531. else if((ob.getProjectType()==OrderDunProjectType.RJKF.getCode()&&ob.getDunType()==3&&//软件开发 验收
  532. projectStatus==NewProjectStatus.YWCXZ.getCode()))flag=true;
  533. else if(ob.getProjectType()==OrderDunProjectType.ZSCQ.getCode()){//知识产权 公示 专利受理、转让(项目已提交),软著下证
  534. if(ob.getDunType()==3&&projectStatus==NewProjectStatus.YWCXZ.getCode()) {
  535. flag=true;
  536. }else if (ob.getDunType()==2) {
  537. BusinessProject bp=businessProjectMapper.selectByPrimaryKey(task2.getCommodityId());
  538. if (bp.getType()==0&&projectStatus==NewProjectStatus.YWCXZ.getCode()) {
  539. flag=true;
  540. }
  541. if (bp.getType()==1&&projectStatus==NewProjectStatus.YTJ.getCode()) {
  542. flag=true;
  543. }
  544. if (bp.getType()==2&&projectStatus==NewProjectStatus.YWCXZ.getCode()) {
  545. flag=true;
  546. }
  547. }
  548. }else if(ob.getProjectType()==OrderDunProjectType.GX.getCode()) {
  549. if (ob.getDunType()==2&&projectStatus>=NewProjectStatus.YNGS.getCode()
  550. &&projectStatus<=NewProjectStatus.YXZ.getCode()) {
  551. flag=true;
  552. } else if (ob.getDunType()==3&&projectStatus==NewProjectStatus.YXZ.getCode()){
  553. flag=true;
  554. }
  555. }
  556. if(flag) {
  557. //如果启动催款,则新增欠款与应收款
  558. TOrderNew tn=tOrderNewMapper.selectByPrimaryKey(task2.getOrderNo());
  559. ob.setStatus(1);
  560. ob.setStartTime(new Date());
  561. newOrderDunMapper.updateByPrimaryKeySelective(ob);
  562. TOrderMid tm=orderNewService.pushOrderMidDun(task2.getOrderNo(),tn.getSettlementAmount(),new Date(),ob);
  563. TArrearsDun td=new TArrearsDun();
  564. td.setOrderArrears(tm.getOrderArrears());
  565. td.setOrderReceivables(tm.getOrderReceivables());
  566. if (tArrearsDunMapper.checkOrderNo(task2.getOrderNo(),null)<1) {
  567. td.setOrderNo(task2.getOrderNo());
  568. tArrearsDunMapper.insertSelective(td);
  569. }else if(tArrearsDunMapper.checkOrderNo(task2.getOrderNo(),0)>0){
  570. Integer i=tArrearsDunMapper.selectByStatus(task2.getOrderNo(), 0);
  571. td.setId(i);
  572. tArrearsDunMapper.updateByPrimaryKeySelective(td);
  573. }
  574. orderNewService.addNewDunNoticAndSendEmail(task2.getOrderNo(),ob);
  575. }
  576. }
  577. }
  578. List<OutPaymentNode> list2=paymentNodeMapper.selectByTid(tid,0);
  579. for (OutPaymentNode op : list2) {
  580. if (op!=null) {
  581. boolean flag=false;
  582. if((op.getProjectType()==OrderDunProjectType.CGZH.getCode()&&op.getDunType()==2&&//成果转化 验收
  583. projectStatus==NewProjectStatus.YWCXZ.getCode()))flag=true;
  584. if((op.getProjectType()==OrderDunProjectType.COMMON.getCode()&&op.getDunType()==2&&//通用 公示
  585. projectStatus==NewProjectStatus.YTJ.getCode()))flag=true;
  586. if((op.getProjectType()==OrderDunProjectType.COMMON.getCode()&&op.getDunType()==3&&//通用 下证
  587. projectStatus==NewProjectStatus.YWCXZ.getCode()))flag=true;
  588. if((op.getProjectType()==OrderDunProjectType.KJXM.getCode()&&op.getDunType()==2&&//科技项目 立项或者公示
  589. projectStatus==NewProjectStatus.YLX.getCode()))flag=true;
  590. if((op.getProjectType()==OrderDunProjectType.KJXM.getCode()&&op.getDunType()==3&&//科技项目 拨款
  591. projectStatus==NewProjectStatus.LXYBK.getCode()))flag=true;
  592. if((op.getProjectType()==OrderDunProjectType.KJJR.getCode()&&op.getDunType()==2&&//科技金融 拨款
  593. projectStatus==NewProjectStatus.YWCXZ.getCode()))flag=true;
  594. if((op.getProjectType()==OrderDunProjectType.RJKF.getCode()&&op.getDunType()==2&&//软件开发 立项
  595. projectStatus==NewProjectStatus.YTJ.getCode()))flag=true;
  596. if((op.getProjectType()==OrderDunProjectType.RJKF.getCode()&&op.getDunType()==3&&//软件开发 验收
  597. projectStatus==NewProjectStatus.YWCXZ.getCode()))flag=true;
  598. if(op.getProjectType()==OrderDunProjectType.ZSCQ.getCode()){//知识产权 公示 专利受理、转让(项目已提交),软著下证
  599. if(op.getDunType()==3&&projectStatus==NewProjectStatus.YWCXZ.getCode()) {
  600. flag=true;
  601. }else if (op.getDunType()==2) {
  602. BusinessProject bp=businessProjectMapper.selectByPrimaryKey(task2.getCommodityId());
  603. if (bp.getType()==0&&projectStatus==NewProjectStatus.YWCXZ.getCode()) {
  604. flag=true;
  605. }
  606. if (bp.getType()==1&&projectStatus==NewProjectStatus.YTJ.getCode()) {
  607. flag=true;
  608. }
  609. if (bp.getType()==2&&projectStatus==NewProjectStatus.YWCXZ.getCode()) {
  610. flag=true;
  611. }
  612. }
  613. }
  614. if(flag)addNoticAndEmail( op,NoticeStatus.PAYMENT_DUN.getCode());
  615. }
  616. }
  617. }
  618. public void addNoticAndEmail(OutPaymentNode pn,Integer type) {
  619. paymentNodeEmailBo pnb=paymentNodeMapper.selectBytidGetEmail(pn.getTid());
  620. TOrderNewBo b = tOrderNewMapper.getSaleIdByOno(pnb.getOrderNo());
  621. orderNewService.addNotic(type,b,null);
  622. pn.setDunStatus(1);
  623. paymentNodeMapper.updateByPrimaryKeySelective(pn);
  624. //营销员名称、邮箱、订单编号、客户名称
  625. String dunTypeName=NewOrderDunType.getValueByCode(Integer.valueOf(""+pn.getProjectType()+pn.getDunType()));
  626. //发送驳回邮件
  627. if(SendEmailUtil.isEmail(pnb.getEmail())) {
  628. EmailBo bo = new EmailBo("付款通知", pnb.getEmail(), "平台超管中心", "管理员",
  629. "", pnb.getOrderNo(),pnb.getContractNo(),pn.getPartyTimes(),
  630. dunTypeName,pnb.getSalesmanName(),pnb.getUserName(),2,0);
  631. if(StringUtils.isNotBlank(pnb.getEmail())) {
  632. try {
  633. asyncUtils.patentSend(bo);
  634. } catch (UnsupportedEncodingException | MessagingException e) {
  635. LoggerUtils.debug(logger, "=========================================发送邮件异常");
  636. e.printStackTrace();
  637. }
  638. }
  639. }
  640. }
  641. private void checkSettlementAward(TOrderNew tn,TOrderTask task) {
  642. if(task.getTaskStatus()==TaskState.COMPLETE.getCode()&&tn.getTotalAmount().compareTo(tn.getSettlementAmount())==0) {
  643. List<TOrderTaskBo> l = tOrderTaskMapper.getReceiverByOid(tn.getOrderNo());
  644. for (TOrderTaskBo tOrderTask : l) {
  645. if(null != tOrderTask &&null != tOrderTask.getTaskReceiver()){
  646. TOrderBonus bonus = new TOrderBonus();
  647. bonus.setId(UUID.randomUUID().toString());
  648. bonus.setOrderNo(tn.getOrderNo());
  649. bonus.setGrantBy(tn.getFinanceId());
  650. bonus.setBonusSubject(BonusSubject.WK.getCode());//12
  651. bonus.setTaskId(tOrderTask.getId());//任务id
  652. bonus.setGrantTarget(tOrderTask.getTaskReceiver());
  653. bonus.setGrantType(1);
  654. int c = tOrderBonusMapper.checkByOnoAndSub(bonus);
  655. //不存在就设置
  656. if(c==0){
  657. bonus.setId(UUID.randomUUID().toString());
  658. tOrderBonusMapper.insertSelective(bonus);
  659. }
  660. }
  661. }
  662. }
  663. }
  664. private void meanwhileUpdateOrder(TOrderTask task) {
  665. //是否是主要项目
  666. if (task.getMain()==1) {
  667. //更改订单项目状态
  668. TOrderNew tNew = new TOrderNew();
  669. tNew.setProjectStatus(task.getProjectStatus());
  670. tNew.setOrderNo(task.getOrderNo());
  671. tOrderNewMapper.updateByPrimaryKeySelective(tNew);
  672. }
  673. if (task.getProjectStatus()==NewProjectStatus.YTJ.getCode()||task.getProjectStatus()==NewProjectStatus.YLX.getCode()||
  674. task.getProjectStatus()==NewProjectStatus.YNGS.getCode()) {
  675. TOrderBonus tb=new TOrderBonus();
  676. TOrderNew t=tOrderNewMapper.selectByPrimaryKey(task.getOrderNo());
  677. tb.setId(UUID.randomUUID().toString());
  678. tb.setOrderNo(task.getOrderNo());
  679. if (task.getProjectStatus()==NewProjectStatus.YTJ.getCode()) {
  680. tb.setBonusSubject(21);//项目已提交
  681. addOrderLog(task.getOrderNo(),OrderLogProcess.XMWC.getCode(),null);
  682. }
  683. if (task.getProjectStatus()==NewProjectStatus.YLX.getCode())tb.setBonusSubject(23);//项目立项
  684. if (task.getProjectStatus()==NewProjectStatus.YNGS.getCode())tb.setBonusSubject(24);//项目公示
  685. tb.setGrantType(1);//技术员
  686. //新增奖金之前检查这个奖金数据是否存在
  687. tb.setGrantTarget(task.getTaskReceiver());
  688. int c = tOrderBonusMapper.checkByOnoAndSub(tb);
  689. if(c==0){
  690. tb.setGrantBy(t.getFinanceId());
  691. tb.setTaskId(task.getId());
  692. tOrderBonusMapper.insertSelective(tb);
  693. }
  694. }
  695. }
  696. @Override
  697. public int addTaskHours(TTaskHours t) {
  698. TOrderTask tt=tOrderTaskMapper.selectByPrimaryKey(Integer.valueOf(t.getTaskId()));
  699. checkDeleteSign(tt.getOrderNo());
  700. t.setAid(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  701. t.setId(UUID.randomUUID().toString());
  702. t.setCreateTime(new Date());
  703. if(taskHoursCountMapper.selectByAidAndTid(TokenManager.getAdminId(),t.getTaskId())>0) {
  704. taskHoursCountMapper.updateByAidAndTid(TokenManager.getAdminId(),t.getTaskId(),t.getHours());
  705. }else {
  706. TaskHoursCount tc=new TaskHoursCount();
  707. tc.setAid(TokenManager.getAdminId());
  708. tc.setTid(Integer.valueOf(t.getTaskId()));
  709. tc.setHours(t.getHours());
  710. taskHoursCountMapper.insertSelective(tc);
  711. }
  712. return tTaskHoursMapper.insertSelective(t);
  713. }
  714. @SuppressWarnings("unchecked")
  715. @Override
  716. public Pagination<TOrderTaskListBo> taskHoursList(inuptTaskHoursListBo ib, Integer pageNo,
  717. Integer pageSize) {
  718. Map<String, Object> params = new HashMap<String, Object>();
  719. if(pageSize==null||pageSize<0)pageSize=10;
  720. if(pageNo==null||pageNo<0)pageNo=1;
  721. if (StringUtils.isNotBlank(ib.getName())) params.put("name", ib.getName());
  722. if (StringUtils.isNotBlank(ib.getOrderNo())) params.put("orderNo", ib.getOrderNo());
  723. if (StringUtils.isNotBlank(ib.getTaskId())) params.put("taskId", ib.getTaskId());
  724. if (StringUtils.isNotBlank(ib.getStarTime())) params.put("starTime", ib.getStarTime());
  725. if (StringUtils.isNotBlank(ib.getEndTime())) params.put("endTime", ib.getEndTime()+" 23:59:59");
  726. if(StringUtils.isNotBlank(ib.getContractNo()))params.put("contractNo", ib.getContractNo());
  727. if(StringUtils.isNotBlank(ib.getDepId()))params.put("depId", ib.getDepId());
  728. if(StringUtils.isNotBlank(ib.getCid()))params.put("cid", ib.getCid());
  729. if(null!=ib.getOutsource())params.put("outsource", ib.getOutsource());
  730. Integer i=null;
  731. if (TokenManager.hasRole(AFTConstants.FINANCE))i=1;
  732. if (TokenManager.hasRole(AFTConstants.FINANCE_MANAGER))i=2;
  733. if (TokenManager.hasRole(AFTConstants.FINANCE_ADMIN)||TokenManager.hasRole(AFTConstants.VICE_CEO)||
  734. TokenManager.hasRole(AFTConstants.SUPERADMIN)||TokenManager.hasRole(AFTConstants.CED)||
  735. TokenManager.hasRole(AFTConstants.APPROVAL_DECISION))i=3;
  736. if(TokenManager.getAdminId()!=null)params.put("aid", TokenManager.getAdminId());
  737. if(i!=null)params.put("shiroType", i);
  738. Pagination<TOrderTaskListBo> p = (Pagination<TOrderTaskListBo>)findPage("selectTaskHoursListByPage", "selectTaskHoursListCount", params, pageNo, pageSize);
  739. return p;
  740. }
  741. @SuppressWarnings("unchecked")
  742. @Override
  743. public Pagination<TOrderTaskListBo> selectTaskList(String name, String orderNo, String taskId, Integer taskStatus,
  744. String adminName, Integer specially,String depId , Integer pageNo, Integer pageSize) {
  745. Map<String, Object> params = new HashMap<String, Object>();
  746. if(pageSize==null||pageSize<0)pageSize=10;
  747. if(pageNo==null||pageNo<0)pageNo=1;
  748. params.put("aid", TokenManager.getAdminId()==null?"":TokenManager.getAdminId());
  749. if (StringUtils.isNotBlank(name)) params.put("name", name);
  750. if (StringUtils.isNotBlank(depId)) params.put("depId", depId);
  751. if (StringUtils.isNotBlank(orderNo)) params.put("orderNo", orderNo);
  752. if (StringUtils.isNotBlank(taskId)) params.put("taskId", taskId);
  753. if (StringUtils.isNotBlank(adminName)) params.put("adminName", adminName);
  754. if (null != taskStatus) params.put("taskStatus", taskStatus);
  755. Pagination<TOrderTaskListBo> p = (Pagination<TOrderTaskListBo>)findPage("selectTaskListByPage", "selectTaskListCount", params, pageNo, pageSize);
  756. return p;
  757. }
  758. @Override
  759. public List<TaskLogBo> TaskLogList(Integer id) {
  760. return taskLogMapper.selectTaskLogList(id);
  761. }
  762. @Override
  763. public int createTaskProgress(TaskProgressBo t) {
  764. TaskProgress tp=new TaskProgress();
  765. TOrderTask tt=tOrderTaskMapper.selectByPrimaryKey(t.getTaskId());
  766. int count =taskProgressMapper.AlreadyNuberCount(t.getTaskId());
  767. count +=t.getAlreadyNumber();
  768. if(tt.getCommodityQuantity()<count)throw new BusinessException(new Error( "数量不能大于总量!" ,"数量不能大于总量!"));
  769. tp.setAlreadyNumber(t.getAlreadyNumber());
  770. tp.setPatentName(t.getPatentName());
  771. tp.setPatentNo(t.getPatentNo());
  772. tp.setType(t.getType());
  773. if (t.getLicenceTimes()!=null) tp.setLicenceTime(DateUtils.StringToDate(t.getLicenceTimes(), AFTConstants.YYYYMMDD));
  774. if (t.getAcceptTimes()!=null) tp.setAcceptTime(DateUtils.StringToDate(t.getAcceptTimes(), AFTConstants.YYYYMMDD));
  775. if (t.getAuthorizeTimes()!=null) tp.setAuthorizeTime(DateUtils.StringToDate(t.getAuthorizeTimes(), AFTConstants.YYYYMMDD));
  776. tp.setStatus(t.getStatus());
  777. tp.setTaskId(t.getTaskId());
  778. tTaskMidMapper.updateCertificatesCountByTid(t.getTaskId(),count);
  779. TaskProgressLog tpl=new TaskProgressLog(t.getTaskId(),t.getPatentName(),0,new Date());
  780. taskProgressLogMapper.insertSelective(tpl);
  781. int i=taskProgressMapper.insertSelective(tp);
  782. countByTid(tp.getTaskId(),tp.getType());
  783. return i;
  784. }
  785. @Override
  786. public int updateTaskProgress(TaskProgressBo t) {
  787. TaskProgress tp=taskProgressMapper.selectByPrimaryKey(t.getId());
  788. TOrderTask tt=tOrderTaskMapper.selectByPrimaryKey(t.getTaskId());
  789. int count =taskProgressMapper.AlreadyNuberCount(t.getTaskId());
  790. count = count-tp.getAlreadyNumber()+t.getAlreadyNumber();
  791. if(tt.getCommodityQuantity()<count)throw new BusinessException(new Error( "数量不能大于总量!" ,"数量不能大于总量!"));
  792. tp.setAlreadyNumber(t.getAlreadyNumber());
  793. tp.setPatentName(t.getPatentName());
  794. tp.setPatentNo(t.getPatentNo());
  795. tp.setType(t.getType());
  796. if (t.getLicenceTimes()!=null) tp.setLicenceTime(DateUtils.StringToDate(t.getLicenceTimes(), AFTConstants.YYYYMMDD));
  797. if (t.getAcceptTimes()!=null) tp.setAcceptTime(DateUtils.StringToDate(t.getAcceptTimes(), AFTConstants.YYYYMMDD));
  798. if (t.getAuthorizeTimes()!=null) tp.setAuthorizeTime(DateUtils.StringToDate(t.getAuthorizeTimes(), AFTConstants.YYYYMMDD));
  799. tp.setStatus(t.getStatus());
  800. tp.setTaskId(t.getTaskId());
  801. tTaskMidMapper.updateCertificatesCountByTid(t.getTaskId(),count);
  802. TaskProgressLog tpl=new TaskProgressLog(t.getTaskId(),t.getPatentName(),2,new Date());
  803. taskProgressLogMapper.insertSelective(tpl);
  804. int i=taskProgressMapper.updateByPrimaryKeySelective(tp);
  805. countByTid(tp.getTaskId(),tp.getType());
  806. return i;
  807. }
  808. @Override
  809. public int delectTaskProgress(Integer id) {
  810. TaskProgress tp=taskProgressMapper.selectByPrimaryKey(id);
  811. if (tp==null) {
  812. return 0;
  813. }
  814. int i=taskProgressMapper.deleteByPrimaryKey(id);
  815. TaskProgressLog tpl=new TaskProgressLog(tp.getTaskId(),tp.getPatentName(),1,new Date());
  816. taskProgressLogMapper.insertSelective(tpl);
  817. countByTid(tp.getTaskId(),tp.getType());
  818. return i;
  819. }
  820. private void countByTid(Integer taskId, Integer type) {
  821. //目前不做计算
  822. // TTaskMid ttm=tTaskMidMapper.selectCountBytid(taskId,type);
  823. // tTaskMidMapper.updateByPrimaryKeySelective(ttm);
  824. }
  825. @Override
  826. public List<TaskProgressBo> selectTaskProgress(Integer tid) {
  827. List<TaskProgressBo> l=taskProgressMapper.selectTaskProgress(tid);
  828. int notcount=0;
  829. for (TaskProgressBo t : l) {
  830. notcount+=t.getAlreadyNumber();
  831. t.setNotCount(t.getIngCount()-notcount);
  832. }
  833. return l;
  834. }
  835. @Override
  836. public List<TTaskHours> taskHoursDetailsList(String taskId) {
  837. String aid=TokenManager.getAdminId();
  838. return tTaskHoursMapper.taskHoursDetailsList(taskId,aid);
  839. }
  840. @Override
  841. public int pushSplitProject(Integer tid, String splitList) {
  842. String[] str=splitList.split(",");
  843. TOrderTask task=tOrderTaskMapper.selectByPrimaryKey(tid);
  844. checkDeleteSign(task.getOrderNo());
  845. TOrderTask usedTask=new TOrderTask();
  846. usedTask.setId(tid);
  847. usedTask.setSplitStatus(1);
  848. //计算拆分数量
  849. Integer x=0;
  850. for (String string : str) {
  851. x+=Integer.parseInt(string);
  852. }
  853. if (!task.getCommodityQuantity().equals(x)||str.length==1) {
  854. return -1;
  855. }
  856. tOrderTaskMapper.updateByPrimaryKeySelective(usedTask);
  857. int i=1;
  858. TOrderTask newTask=task;
  859. newTask.setCommodityPrice(new BigDecimal(0));
  860. newTask.setSplitAid(TokenManager.getAdminId());
  861. newTask.setSplitStatus(2);
  862. newTask.setSplitSuper(tid);
  863. newTask.setSplitTime(new Date());
  864. for (String string : str) {
  865. newTask.setId(null);
  866. newTask.setCommodityQuantity(Integer.parseInt(string));
  867. newTask.setSplitId(i);
  868. i++;
  869. tOrderTaskMapper.insertSelective(newTask);
  870. TTaskMid dtails = tTaskMidMapper.getDtails(newTask.getId());
  871. TTaskMid tTaskMid = new TTaskMid(newTask.getId(), new BigDecimal(0));
  872. tTaskMid.setDispatchProvince(dtails.getDispatchProvince());
  873. tTaskMid.setDutyDep(dtails.getDutyDep());
  874. tTaskMidMapper.insertSelective(tTaskMid);
  875. }
  876. return 1;
  877. }
  878. @Override
  879. public List<TOrderTaskListBo> splitProjectList(Integer tid) {
  880. return tOrderTaskMapper.splitProjectList(tid);
  881. }
  882. @Override
  883. public List<OutTaskProgressLog> selectTaskProgressLog(Integer tid) {
  884. return taskProgressLogMapper.selectTaskProgressLog(tid);
  885. }
  886. @Override
  887. public Pagination<managerListBo> managerSelect(String name, String orderNo, String contractNo, String cid,
  888. String projectType, String depId, String techDepId, Integer declarationBatch, String commodityPrice,
  889. String startTime,String endTime ,Integer pageNo, Integer pageSize) {
  890. Map<String, Object> params = new HashMap<String, Object>();
  891. if(pageSize==null||pageSize<0)pageSize=10;
  892. if(pageNo==null||pageNo<0)pageNo=1;
  893. params.put("aid", TokenManager.getAdminId()==null?"":TokenManager.getAdminId());
  894. if (StringUtils.isNotBlank(name))params.put("name", name);
  895. else params.put("name", "");
  896. if (StringUtils.isNotBlank(depId)) params.put("depId", depId);
  897. if (StringUtils.isNotBlank(orderNo)) params.put("orderNo", orderNo);
  898. if (StringUtils.isNotBlank(contractNo)) params.put("contractNo", contractNo);
  899. if (StringUtils.isNotBlank(cid)) params.put("cid", cid);
  900. if (StringUtils.isNotBlank(projectType)) params.put("projectType", projectType);
  901. if (StringUtils.isNotBlank(depId)) params.put("depId", depId);
  902. if (StringUtils.isNotBlank(techDepId)) params.put("techDepId", techDepId);
  903. if (StringUtils.isNotBlank(commodityPrice)) params.put("commodityPrice", commodityPrice);
  904. if (StringUtils.isNotBlank(startTime)) params.put("startTime", startTime);
  905. if (StringUtils.isNotBlank(endTime)) params.put("endTime", endTime+" 23:59:59");
  906. if (null != declarationBatch) params.put("declarationBatch", declarationBatch);
  907. @SuppressWarnings("unchecked")
  908. Pagination<managerListBo> p = (Pagination<managerListBo>)findPage("managerSelectByPage", "managerSelectCount", params, pageNo, pageSize);
  909. return p;
  910. }
  911. @Override
  912. public List<taskAttributionLogBo> taskAttributionLog(Integer tid) {
  913. return taskAttributionLogMapper.selectByTid(tid);
  914. }
  915. @Override
  916. public List<UserOrderTask> selectUidByproject(String uid) {
  917. return tOrderTaskMapper.selectUidByproject(uid);
  918. }
  919. @Override
  920. public int addProjectCheck(Integer tid) {
  921. TOrderTask t=new TOrderTask();
  922. t.setCheckStatus(1);
  923. t.setId(tid);
  924. ProjcetCheckLog log=new ProjcetCheckLog();
  925. log.setAid(TokenManager.getAdminId());
  926. log.setRemarks("发起核对");
  927. log.setTid(tid);
  928. log.setStatus(0);
  929. OrderOperator oo=tOrderTaskMapper.selectAidByParam(tid);
  930. if (oo!=null&&oo.getOrderNo()!=null&&oo.getSalesmanId()!=null) {
  931. Notice n =new Notice();
  932. String str=String.format("[%s]发起专利核对,客户名称[%s]订单编号[%s]项目编号[%s]。", oo.getTechName(),oo.getBuyerName(),oo.getOrderNo(),oo.getTid());
  933. n.setId(UUID.randomUUID().toString());
  934. n.setAid(oo.getSalesmanId());
  935. n.setNoticeType(NoticeStatus.ITEM_CHECK_START.getCode());
  936. n.setContent(str);
  937. n.setReaded(0);//未读
  938. asyncUtils.addNoticAndEmail(n);
  939. }
  940. projcetCheckLogMapper.insertSelective(log);
  941. tOrderPaymentMapper.deleteByParam(tid,2);
  942. return tOrderTaskMapper.updateByPrimaryKeySelective(t);
  943. }
  944. @Override
  945. public List<OutProjectCheckLog> projectCheckLog(Integer tid) {
  946. return projcetCheckLogMapper.projectCheckLog(tid);
  947. }
  948. @SuppressWarnings("unchecked")
  949. @Override
  950. public Object selectProjectCheck(InputProjectCheck in) {
  951. Map<String, Object> map=new HashedMap<String, Object>();
  952. if (in.getName()!=null) map.put("name", in.getName());
  953. if (in.getOrderNo()!=null) map.put("orderNo", in.getOrderNo());
  954. if (in.getContractNo()!=null) map.put("contartNo", in.getContractNo());
  955. if (in.getPname()!=null) map.put("pname", in.getPname());
  956. if (in.getDepId()!=null) map.put("depId", in.getDepId());
  957. map.put("aid", TokenManager.getAdminId());
  958. return (Pagination<OutProjectCheck>)findPage("selectProjectCheck", "countProjectCheck", map, in.getPageNo(), in.getPageSize());
  959. }
  960. @Override
  961. public List<OutHighNewRetrialStatistics> highNewRetrialStatistics(String depId, String startDate, String endDate) {
  962. endDate=endDate+" 23:59:59";
  963. return tOrderTaskMapper.highNewRetrialStatistics(depId,startDate,endDate);
  964. }
  965. @Override
  966. public List<OutHighNewRetrialList> highNewRetrialList(String province, String depId, String aid, Integer sort, String startDate, String endDate) {
  967. endDate=endDate+" 23:59:59";
  968. if (sort==null)sort=0;
  969. return tOrderTaskMapper.highNewRetrialList( province, depId, aid, sort, startDate, endDate);
  970. }
  971. @Override
  972. public Pagination<OutMemberList> memberList(InputMemberList in) {
  973. HashMap<String, Object> map = new HashMap<>();
  974. addParam(in, map);
  975. return (Pagination<OutMemberList>) findPage("findMemberList","findMemberCount",map,in.getPageNo(), in.getPageSize());
  976. }
  977. private void addParam(InputMemberList in, HashMap<String, Object> map) {
  978. if(in.getOrderNo()!=null) map.put("orderNo", in.getOrderNo());
  979. if(in.getUserName()!=null) map.put("userName", in.getUserName());
  980. if(in.getDepId()!=null) map.put("depId", in.getDepId());
  981. if(in.getContractNo()!=null) map.put("contractNo", in.getContractNo());
  982. if(in.getSalesmanId()!=null) map.put("salesmanId", in.getSalesmanId());
  983. if(in.getProjectName()!=null) map.put("projectName", in.getProjectName());
  984. if(in.getAmountStatus()!=null) map.put("amountStatus", in.getAmountStatus());
  985. if(in.getApproval()!=null) map.put("approval", in.getApproval());
  986. if(in.getStatus()!=null) map.put("status", in.getStatus());
  987. if(in.getShiroType()!=null) map.put("shiroType", in.getShiroType());
  988. map.put("aid",TokenManager.getAdminId());
  989. }
  990. @Override
  991. public Result memberListExport(InputMemberList in) {
  992. HashMap<String, Object> map = new HashMap<>();
  993. addParam(in, map);
  994. List<OutMemberList>list= (List<OutMemberList>) findList("findMemberList",map,1,9999);
  995. NewExcelUtil<OutMemberList> excelUtil=new NewExcelUtil<>(OutMemberList.class);
  996. return excelUtil.exportExcel(list,"会员审核列表",uploadPath);
  997. }
  998. @Override
  999. public int pushExamineMemberProject(InputMenber in) {
  1000. TOrderTask task=tOrderTaskMapper.selectByPrimaryKey(in.getId());
  1001. TOrderLog log=new TOrderLog();
  1002. log.setRemarks(in.getRemarks());
  1003. log.setOrderNo(task.getOrderNo());
  1004. log.setAid(TokenManager.getAdminId());
  1005. TOrderTask nt=new TOrderTask();
  1006. nt.setId(task.getId());
  1007. TOrderNewBo ono = tOrderNewMapper.getSaleIdByOno(task.getOrderNo());
  1008. // 1=通过 0=驳回
  1009. if (in.getResult()==1){
  1010. //0=财务 1=特批
  1011. if (in.getType()==0){
  1012. if(task.getProcessStatus()!=1)throw new BusinessException("审核状态错误");
  1013. log.setProcess(19);
  1014. if (task.getMemberType()==1||task.getMemberType()==2){
  1015. nt.setProcessStatus(2);
  1016. addLog(log,0);
  1017. }else if (task.getMemberType()==0){
  1018. nt.setProcessStatus(3);
  1019. addLog(log,1);
  1020. }
  1021. }else if(in.getType()==1){
  1022. if(task.getProcessStatus()!=2)throw new BusinessException("审核状态错误");
  1023. nt.setProcessStatus(3);
  1024. log.setProcess(20);
  1025. addLog(log,1);
  1026. }
  1027. orderNewService.addNoticMember(NoticeStatus.MENBER_YES.getCode(), ono, in.getType());
  1028. }else if (in.getResult()==0){
  1029. if (in.getType()==0){
  1030. log.setProcess(21);
  1031. }else if(in.getType()==1){
  1032. log.setProcess(22);
  1033. }
  1034. addLog(log,0);
  1035. nt.setProcessStatus(4);
  1036. orderNewService.addNoticMember(NoticeStatus.MENBER_NO.getCode(), ono, in.getType());
  1037. }
  1038. return tOrderTaskMapper.updateByPrimaryKeySelective(nt);
  1039. }
  1040. /**
  1041. *
  1042. * @param log
  1043. * @param type 0只做审核 1并完成
  1044. */
  1045. private void addLog(TOrderLog log,Integer type) {
  1046. tOrderLogMapper.insertSelective(log);
  1047. if (type==1){
  1048. log.setId(null);
  1049. log.setProcess(23);
  1050. tOrderLogMapper.insertSelective(log);
  1051. }
  1052. }
  1053. @Override
  1054. public int updateMemberProject(TOrderTask t) {
  1055. TOrderTask task=tOrderTaskMapper.selectByPrimaryKey(t.getId());
  1056. addOrderLog(task.getOrderNo(),OrderLogProcess.HYXMFQ.getCode(), "修改重新发起");
  1057. t.setProcessStatus(1);
  1058. TOrderNewBo ono = tOrderNewMapper.getSaleIdByOno(task.getOrderNo());
  1059. orderNewService.addNoticMember(NoticeStatus.MENBER_START.getCode(), ono, null);
  1060. return orderNewService.updateOrderTask(t);
  1061. }
  1062. }