OrderProjectServiceImpl.java 48 KB

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