OrderProjectServiceImpl.java 48 KB

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