OrderProjectServiceImpl.java 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462
  1. package com.goafanti.order.service.impl;
  2. import java.math.BigDecimal;
  3. import java.text.ParseException;
  4. import java.text.SimpleDateFormat;
  5. import java.util.ArrayList;
  6. import java.util.Date;
  7. import java.util.HashMap;
  8. import java.util.List;
  9. import java.util.Map;
  10. import java.util.UUID;
  11. import org.apache.commons.lang3.StringUtils;
  12. import org.apache.poi.hssf.record.EOFRecord;
  13. import org.apache.poi.xssf.usermodel.XSSFWorkbook;
  14. import org.springframework.beans.factory.annotation.Autowired;
  15. import org.springframework.beans.factory.annotation.Value;
  16. import org.springframework.stereotype.Service;
  17. import org.springframework.transaction.annotation.Transactional;
  18. import com.goafanti.common.bo.Error;
  19. import com.goafanti.common.constant.AFTConstants;
  20. import com.goafanti.common.dao.AdminMapper;
  21. import com.goafanti.common.dao.OrganizationContactBookMapper;
  22. import com.goafanti.common.dao.OrganizationIdentityMapper;
  23. import com.goafanti.common.dao.TOrderBonusMapper;
  24. import com.goafanti.common.dao.TOrderLogMapper;
  25. import com.goafanti.common.dao.TOrderNewMapper;
  26. import com.goafanti.common.dao.TOrderTaskMapper;
  27. import com.goafanti.common.dao.TTaskHoursMapper;
  28. import com.goafanti.common.dao.TTaskLogMapper;
  29. import com.goafanti.common.dao.TaskLogMapper;
  30. import com.goafanti.common.dao.TaskProgressMapper;
  31. import com.goafanti.common.enums.NoticeStatus;
  32. import com.goafanti.common.enums.OrderLogProcess;
  33. import com.goafanti.common.error.BusinessException;
  34. import com.goafanti.common.model.Admin;
  35. import com.goafanti.common.model.OrganizationContactBook;
  36. import com.goafanti.common.model.OrganizationIdentity;
  37. import com.goafanti.common.model.TOrderBonus;
  38. import com.goafanti.common.model.TOrderLog;
  39. import com.goafanti.common.model.TOrderNew;
  40. import com.goafanti.common.model.TOrderTask;
  41. import com.goafanti.common.model.TTaskHours;
  42. import com.goafanti.common.model.TTaskLog;
  43. import com.goafanti.common.model.TaskLog;
  44. import com.goafanti.common.model.TaskProgress;
  45. import com.goafanti.common.utils.DateUtils;
  46. import com.goafanti.common.utils.ExportExcelUtil;
  47. import com.goafanti.core.mybatis.BaseMybatisDao;
  48. import com.goafanti.core.mybatis.page.Pagination;
  49. import com.goafanti.core.shiro.token.TokenManager;
  50. import com.goafanti.order.bo.TOrderTaskBo;
  51. import com.goafanti.order.bo.TOrderTaskDetailBo;
  52. import com.goafanti.order.bo.TOrderTaskListBo;
  53. import com.goafanti.order.bo.TaskLogBo;
  54. import com.goafanti.order.bo.TaskProgressBo;
  55. import com.goafanti.order.enums.BonusSubject;
  56. import com.goafanti.order.enums.ProcessStatus;
  57. import com.goafanti.order.enums.ProjectNewStage;
  58. import com.goafanti.order.service.OrderNewService;
  59. import com.goafanti.order.service.OrderProjectService;
  60. import com.goafanti.techproject.enums.TaskState;
  61. @Service
  62. public class OrderProjectServiceImpl extends BaseMybatisDao<TOrderTaskMapper> implements OrderProjectService {
  63. @Autowired
  64. private TOrderTaskMapper tOrderTaskMapper;
  65. @Autowired
  66. private TOrderNewMapper tOrderNewMapper;
  67. @Autowired
  68. private TTaskHoursMapper tTaskHoursMapper;
  69. @Autowired
  70. private TOrderBonusMapper tOrderBonusMapper;
  71. @Autowired
  72. private TTaskLogMapper tTaskLogMapper;
  73. @Autowired
  74. private TOrderLogMapper tOrderLogMapper;
  75. @Autowired
  76. private TaskProgressMapper taskProgressMapper;
  77. @Autowired
  78. private OrganizationContactBookMapper organizationContactBookMapper;
  79. @Autowired
  80. private OrganizationIdentityMapper organizationIdentityMapper;
  81. @Autowired
  82. private TaskLogMapper taskLogMapper;
  83. @Autowired
  84. private OrderNewService orderNewService;
  85. @Autowired
  86. private AdminMapper adminMapper;
  87. @Value(value = "${upload.path}")
  88. private String uploadPath = null;
  89. @Override
  90. public int updateProjectDistribution(Integer taskId, String taskReceiverId,Integer specially) {
  91. TOrderTask t=tOrderTaskMapper.selectByPrimaryKey(taskId);
  92. t.setTaskStatus(TaskState.DISTRIBUTION.getCode());
  93. t.setTaskAllocator(TokenManager.getAdminId());
  94. t.setTaskReceiver(taskReceiverId);
  95. t.setTaskDistributionTime(new Date());
  96. Admin a=adminMapper.selectByPrimaryKey(taskReceiverId);
  97. if (a==null||a.getId()==null) {
  98. throw new BusinessException(new Error("分配人员不存在!","分配人员不存在!"));
  99. }
  100. insetLog(taskId, taskReceiverId);
  101. //0-经理 (经理分派会创建子项目)1 管理员或经理转交
  102. if (specially==1) {
  103. addOrderLog(t.getOrderNo(), OrderLogProcess.XMDDPD.getCode());
  104. t.setManagerId(taskReceiverId);
  105. t.setConsultantId(null);
  106. }else if (specially==0) {
  107. addOrderLog(t.getOrderNo(), OrderLogProcess.XMPD.getCode());
  108. t.setConsultantId(taskReceiverId);
  109. }else if(specially==2) { //咨询师推给咨询师经理
  110. t.setConsultantId(null);
  111. }
  112. tOrderTaskMapper.updateByPrimaryKey(t);
  113. List<String> aids = new ArrayList<>();
  114. aids.add(taskReceiverId);
  115. orderNewService.generalSendNoticeAndEmail(aids, NoticeStatus.ORDER_TASK_TO.getCode(),t.getOrderNo(), TokenManager.getAdminId());
  116. updateOrder(t);
  117. return 1;
  118. }
  119. private TOrderNew checkDeleteSign(String orderNo) {
  120. TOrderNew t=tOrderNewMapper.selectByPrimaryKey(orderNo);
  121. //if(t.getDeleteSign()==2) throw new BusinessException(new Error(ErrorConstants.ORDER_ALREADY_REVOKE, t.getOrderNo(),""));
  122. return t;
  123. }
  124. public void addOrderLog(String orderNo, Integer code) {
  125. TOrderLog tl=new TOrderLog();
  126. tl.setOrderNo(orderNo);
  127. tl.setProcess(code);
  128. tl.setAid(TokenManager.getAdminId());
  129. tOrderLogMapper.insertSelective(tl);
  130. }
  131. private void updateOrder(TOrderTask t) {
  132. List<TOrderTaskBo> taskBos=tOrderTaskMapper.selectOrderTask(t.getOrderNo());
  133. TOrderNew tNew=new TOrderNew();
  134. tNew.setOrderNo(t.getOrderNo());
  135. int i=0;
  136. for (TOrderTaskBo to : taskBos) {
  137. if (to.getTaskStatus()>=TaskState.DISTRIBUTION.getCode()&&to.getTaskStatus()<TaskState.INVALID.getCode()) {
  138. i++;
  139. }
  140. }
  141. if (i==taskBos.size()) {
  142. tNew.setProcessStatus(ProcessStatus.YQBFPZXSGLY.getCode());
  143. }else{
  144. tNew.setProcessStatus(ProcessStatus.YBFPZXSGLY.getCode());
  145. }
  146. tOrderNewMapper.updateByPrimaryKeySelective(tNew);
  147. }
  148. private void insetLog(Integer taskId, String taskReceiverId) {
  149. TTaskLog tl=new TTaskLog();
  150. tl.setCreateTime(new Date());
  151. tl.setTaskId(taskId);
  152. tl.setTaskAllocator(TokenManager.getAdminId());
  153. tl.setTaskReceiver(taskReceiverId);
  154. tTaskLogMapper.insertSelective(tl);
  155. }
  156. @SuppressWarnings("unchecked")
  157. @Override
  158. public Pagination<TOrderTaskListBo> orderTaskList(String name, String orderNo, String taskId, Integer taskStatus,
  159. String adminName,Integer specially, String depId, Integer pageNo, Integer pageSize,Integer outsource) {
  160. Map<String, Object> params = new HashMap<String, Object>();
  161. if(pageSize==null||pageSize<0)pageSize=10;
  162. if(pageNo==null||pageNo<0)pageNo=1;
  163. params.put("aid", TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  164. if (null!=specially) params.put("specially", specially);
  165. if (StringUtils.isNotBlank(name)) params.put("name", name);
  166. if (StringUtils.isNotBlank(depId)) params.put("depId", depId);
  167. if (StringUtils.isNotBlank(orderNo)) params.put("orderNo", orderNo);
  168. if (StringUtils.isNotBlank(taskId)) params.put("taskId", taskId);
  169. if (StringUtils.isNotBlank(adminName)) params.put("adminName", adminName);
  170. if (null != taskStatus) params.put("taskStatus", taskStatus);
  171. params.put("outsource", outsource==null?0:outsource);
  172. Pagination<TOrderTaskListBo> p = (Pagination<TOrderTaskListBo>)findPage("selectOrderTaskListByPage", "selectOrderTaskListCount", params, pageNo, pageSize);
  173. return p;
  174. }
  175. @Override
  176. public TOrderTaskDetailBo orderTaskDetail(String id) {
  177. return tOrderTaskMapper.getOrderTaskDetail(id);
  178. }
  179. @Override
  180. @Transactional
  181. public int updateOrderTask(TOrderTaskDetailBo t) {
  182. TOrderTask task=new TOrderTask();
  183. TOrderNew tn=checkDeleteSign(t.getOrderNo());
  184. task.setAttachmentUrl(t.getAttachmentUrl());
  185. task.setId(Integer.valueOf(t.getId()));
  186. task.setTaskStatus(t.getTaskStatus());
  187. task.setProjectStatus(t.getProjectStatus());
  188. task.setTaskComment(t.getTaskComment());
  189. task.setCertificateNumber(t.getCertificateNumber());
  190. task.setStatus(t.getStatus());
  191. task.setFormRetrieve(t.getFormRetrieve());
  192. task.setTaskRefund(t.getTaskRefund());
  193. task.setRefundContent(t.getRefundContent());
  194. task.setRetrieveContent(t.getRetrieveContent());
  195. task.setDeclareUser(t.getDeclareUser());
  196. task.setDeclarePwd(t.getDeclarePwd());
  197. task.setArrivalMoney(t.getArrivalMoney());
  198. task.setSetUpAmount(t.getSetUpAmount());
  199. task.setOutsourceName(t.getOutsourceName());
  200. if(StringUtils.isNotBlank(t.getOutsourcePrice()))task.setOutsourcePrice(new BigDecimal(t.getOutsourcePrice()));
  201. //根据修改的修改订单法人与联系人
  202. if(StringUtils.isNotEmpty(t.getContacts()))tn.setContacts(t.getContacts());
  203. if(StringUtils.isNotEmpty(t.getContactMobile())) tn.setContactMobile(t.getContactMobile());
  204. if(StringUtils.isNotEmpty(t.getLegalPerson()))tn.setLegalPerson(t.getLegalPerson());
  205. if(StringUtils.isNotEmpty(t.getLegalPersonTel()))tn.setLegalPersonTel(t.getLegalPersonTel());
  206. tOrderNewMapper.updateByPrimaryKeySelective(tn);
  207. //修改公司地址信息
  208. if (null!=t.getLocationProvince()||null!=t.getLocationArea()||null!=t.getLocationCity()||null!=t.getPostalAddress()) {
  209. OrganizationIdentity org=new OrganizationIdentity();
  210. org.setUid(tn.getBuyerId());
  211. org.setLocationProvince(t.getLocationProvince());
  212. org.setLocationArea(t.getLocationArea());
  213. org.setLocationCity(t.getLocationCity());
  214. org.setPostalAddress(t.getPostalAddress());
  215. organizationIdentityMapper.updateServiceByUid(org);
  216. }
  217. //修改公司联系人
  218. int adcount=organizationContactBookMapper.checkContacts(tn.getBuyerId(), t.getContactMobile(),tn.getSalesmanId());
  219. if (StringUtils.isNotBlank(t.getContacts())&&StringUtils.isNotBlank(t.getContactMobile())&&adcount<1) {
  220. OrganizationContactBook contactBook=new OrganizationContactBook();
  221. contactBook.setId(UUID.randomUUID().toString());
  222. contactBook.setAid(tn.getSalesmanId());
  223. contactBook.setUid(tn.getBuyerId());
  224. contactBook.setName(t.getContacts());
  225. contactBook.setMobile(t.getContactMobile());
  226. organizationContactBookMapper.insertSelective(contactBook);
  227. }
  228. //新增结算奖金信息
  229. checkSettlementAward(tn,task);
  230. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  231. try {
  232. if(StringUtils.isNotBlank(t.getStartDate()))task.setTaskStartTime(sdf.parse(t.getStartDate()));
  233. if(StringUtils.isNotBlank(t.getEndDate()))task.setTaskEndTime(sdf.parse(t.getEndDate()));
  234. if(StringUtils.isNotBlank(t.getAcceptDate()))task.setAcceptTime(sdf.parse(t.getAcceptDate()));
  235. if(StringUtils.isNotBlank(t.getReviewDate()))task.setReviewTime(sdf.parse(t.getReviewDate()));
  236. if(StringUtils.isNotBlank(t.getPublicityDate()))task.setPublicityTime(sdf.parse(t.getPublicityDate()));
  237. if(StringUtils.isNotBlank(t.getLicenceDate()))task.setLicenceTime(sdf.parse(t.getLicenceDate()));
  238. } catch (ParseException e) {
  239. e.printStackTrace();
  240. }
  241. TOrderTask task2=tOrderTaskMapper.selectByPrimaryKey(task.getId());//查询出项目信息
  242. tOrderTaskMapper.updateByPrimaryKeySelective(task);
  243. TaskLog tl=new TaskLog();
  244. tl.setCreateTime(new Date());
  245. tl.setTaskId(t.getId());
  246. tl.setAid(TokenManager.getAdminId());
  247. if (t.getStatus()!=null) {
  248. if (t.getStatus()!=task2.getStatus()) {
  249. String s="将当前项目状态修改为";
  250. if (t.getStatus()==0)s+="开启";
  251. if (t.getStatus()==1)s+="暂停";
  252. tl.setContent(s);
  253. taskLogMapper.insertSelective(tl);
  254. }
  255. if (t.getTaskRefund()!=task2.getTaskRefund()) {
  256. String s="将当前项目退单修改为";
  257. if (t.getTaskRefund()==0)s+="未完成";
  258. if (t.getTaskRefund()==1)s+="已完成";
  259. if (t.getTaskRefund()==2)s+="其他";
  260. tl.setContent(s);
  261. taskLogMapper.insertSelective(tl);
  262. }
  263. if (t.getFormRetrieve()!=task2.getFormRetrieve()) {
  264. String s="将当前满意度表格回收修改为";
  265. if (t.getFormRetrieve()==0)s+="未回收";
  266. if (t.getFormRetrieve()==1)s+="已回收";
  267. if (t.getFormRetrieve()==2)s+="其他";
  268. tl.setContent(s);
  269. taskLogMapper.insertSelective(tl);
  270. }
  271. }
  272. if (task2.getSuperId()!=null) {//是否有父项目
  273. TOrderTask task3 =tOrderTaskMapper.selectBySuperId(task2.getSuperId());
  274. task3.setId(Integer.valueOf(task2.getSuperId()));
  275. task3.setSuperId(null);
  276. tOrderTaskMapper.updateByPrimaryKeySelective(task3);
  277. TOrderTask task4 = tOrderTaskMapper.selectByPrimaryKey(Integer.valueOf(task2.getSuperId()));
  278. meanwhileUpdateOrder(task4);
  279. }else {
  280. meanwhileUpdateOrder(task2);
  281. }
  282. return 1;
  283. }
  284. private void checkSettlementAward(TOrderNew tn,TOrderTask task) {
  285. if(task.getTaskStatus()==TaskState.COMPLETE.getCode()&&tn.getTotalAmount().compareTo(tn.getSettlementAmount())==0) {
  286. List<TOrderTask> l = tOrderTaskMapper.getReceiverByOid(tn.getOrderNo());
  287. for (TOrderTask tOrderTask : l) {
  288. if(null != tOrderTask &&null != tOrderTask.getTaskReceiver()){
  289. TOrderBonus bonus = new TOrderBonus();
  290. bonus.setId(UUID.randomUUID().toString());
  291. bonus.setOrderNo(tn.getOrderNo());
  292. bonus.setGrantBy(tn.getFinanceId());
  293. bonus.setBonusSubject(BonusSubject.WK.getCode());//12
  294. bonus.setTaskId(tOrderTask.getId());//任务id
  295. bonus.setGrantTarget(tOrderTask.getTaskReceiver());
  296. bonus.setGrantType(1);
  297. int c = tOrderBonusMapper.checkByOnoAndSub(bonus);
  298. //不存在就设置
  299. if(c==0){
  300. bonus.setId(UUID.randomUUID().toString());
  301. tOrderBonusMapper.insertSelective(bonus);
  302. }
  303. }
  304. }
  305. }
  306. }
  307. private void meanwhileUpdateOrder(TOrderTask task) {
  308. // if (task.getMain()==1) {//是否是主要项目 更改为不管是不是主项目都会有奖金信息
  309. //更改订单项目状态
  310. TOrderNew tNew=new TOrderNew();
  311. tNew.setProjectStatus(task.getProjectStatus());
  312. tNew.setOrderNo(task.getOrderNo());
  313. tOrderNewMapper.updateByPrimaryKeySelective(tNew);
  314. if (task.getProjectStatus()==ProjectNewStage.YTJ.getCode()||task.getProjectStatus()==ProjectNewStage.LS.getCode()||
  315. task.getProjectStatus()==ProjectNewStage.GS.getCode()) {
  316. TOrderBonus tb=new TOrderBonus();
  317. TOrderNew t=tOrderNewMapper.selectByPrimaryKey(task.getOrderNo());
  318. tb.setId(UUID.randomUUID().toString());
  319. tb.setOrderNo(task.getOrderNo());
  320. if (task.getProjectStatus()==ProjectNewStage.YTJ.getCode()) {
  321. tb.setBonusSubject(21);//项目已提交
  322. addOrderLog(task.getOrderNo(),OrderLogProcess.XMWC.getCode());
  323. }
  324. if (task.getProjectStatus()==ProjectNewStage.LS.getCode())tb.setBonusSubject(23);//项目立项
  325. if (task.getProjectStatus()==ProjectNewStage.GS.getCode())tb.setBonusSubject(24);//项目公示
  326. tb.setGrantType(1);//技术员
  327. //新增奖金之前检查这个奖金数据是否存在
  328. tb.setGrantTarget(task.getTaskReceiver());
  329. int c = tOrderBonusMapper.checkByOnoAndSub(tb);
  330. if(c==0){
  331. tb.setGrantBy(t.getFinanceId());
  332. tb.setTaskId(task.getId());
  333. tOrderBonusMapper.insertSelective(tb);
  334. }
  335. }
  336. }
  337. @Override
  338. public int addTaskHours(TTaskHours t) {
  339. t.setAid(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  340. t.setId(UUID.randomUUID().toString());
  341. t.setCreateTime(new Date());
  342. return tTaskHoursMapper.insertSelective(t);
  343. }
  344. @SuppressWarnings("unchecked")
  345. @Override
  346. public Pagination<TOrderTaskListBo> taskHoursList(String name, String taskId, String starTime,String endTime ,Integer type, Integer pageNo,
  347. Integer pageSize) {
  348. Map<String, Object> params = new HashMap<String, Object>();
  349. if(pageSize==null||pageSize<0)pageSize=10;
  350. if(pageNo==null||pageNo<0)pageNo=1;
  351. if (StringUtils.isNotBlank(name)) params.put("name", name);
  352. if (StringUtils.isNotBlank(taskId)) params.put("taskId", taskId);
  353. if (StringUtils.isNotBlank(starTime)) params.put("starTime", starTime);
  354. if (StringUtils.isNotBlank(endTime)) params.put("endTime", endTime+" 23:59:59");
  355. if(type!=null&&type==1)params.put("fid", TokenManager.getAdminId());
  356. Pagination<TOrderTaskListBo> p = (Pagination<TOrderTaskListBo>)findPage("selectTaskHoursListByPage", "selectTaskHoursListCount", params, pageNo, pageSize);
  357. return p;
  358. }
  359. @Override
  360. public XSSFWorkbook exportTaskHoursListData(String name, String taskId, String startTime, String endTime,Integer type) {
  361. if(StringUtils.isNoneBlank(endTime)) endTime=endTime+" 23:59:59";
  362. String fid=null;
  363. if(type!=null&&type==1)fid=TokenManager.getAdminId();
  364. List<TOrderTaskListBo> list=tTaskHoursMapper.getTaskHoursData(name,taskId,startTime,endTime,fid);
  365. if (list==null || list.size()==0) return null;
  366. String[] comment = {"任务编号","任务名称","订单编号","业务别类","订单部门","客户名称","任务负责人","任务状态","工时","合同编号","签单日期","派单日期"};
  367. String filePath = uploadPath + "/TaskHours";
  368. XSSFWorkbook wb = ExportExcelUtil.exportTaskHoursListData(list, comment, filePath);
  369. return wb;
  370. }
  371. @SuppressWarnings("unchecked")
  372. @Override
  373. public Pagination<TOrderTaskListBo> selectTaskList(String name, String orderNo, String taskId, Integer taskStatus,
  374. String adminName, Integer specially,String depId , Integer pageNo, Integer pageSize) {
  375. Map<String, Object> params = new HashMap<String, Object>();
  376. if(pageSize==null||pageSize<0)pageSize=10;
  377. if(pageNo==null||pageNo<0)pageNo=1;
  378. params.put("aid", TokenManager.getAdminId()==null?"":TokenManager.getAdminId());
  379. if (StringUtils.isNotBlank(name)) params.put("name", name);
  380. if (StringUtils.isNotBlank(depId)) params.put("depId", depId);
  381. if (StringUtils.isNotBlank(orderNo)) params.put("orderNo", orderNo);
  382. if (StringUtils.isNotBlank(taskId)) params.put("taskId", taskId);
  383. if (StringUtils.isNotBlank(adminName)) params.put("adminName", adminName);
  384. if (null != taskStatus) params.put("taskStatus", taskStatus);
  385. Pagination<TOrderTaskListBo> p = (Pagination<TOrderTaskListBo>)findPage("selectTaskListByPage", "selectTaskListCount", params, pageNo, pageSize);
  386. return p;
  387. }
  388. @Override
  389. public List<TaskLogBo> TaskLogList(Integer id) {
  390. return taskLogMapper.selectTaskLogList(id);
  391. }
  392. @Override
  393. public int createTaskProgress(TaskProgressBo t) {
  394. TaskProgress tp=new TaskProgress();
  395. TOrderTask tt=tOrderTaskMapper.selectByPrimaryKey(t.getTaskId());
  396. int count =taskProgressMapper.AlreadyNuberCount(t.getTaskId());
  397. count +=t.getAlreadyNumber();
  398. if(tt.getCommodityQuantity()<count)throw new BusinessException(new Error( "数量不能大于总量!" ,"数量不能大于总量!"));
  399. tp.setAlreadyNumber(t.getAlreadyNumber());
  400. try {
  401. tp.setLicenceTime(DateUtils.StringToDate(t.getLicenceTimes(), AFTConstants.YYYYMMDD));
  402. } catch (ParseException e) {
  403. throw new BusinessException(new Error( "日期错误" ,"日期错误"));
  404. }
  405. tp.setTaskId(t.getTaskId());
  406. return taskProgressMapper.insertSelective(tp);
  407. }
  408. @Override
  409. public int delectTaskProgress(Integer id) {
  410. return taskProgressMapper.deleteByPrimaryKey(id);
  411. }
  412. @Override
  413. public List<TaskProgressBo> selectTaskProgress(Integer tid) {
  414. List<TaskProgressBo> l=taskProgressMapper.selectTaskProgress(tid);
  415. int notcount=0;
  416. for (TaskProgressBo t : l) {
  417. notcount+=t.getAlreadyNumber();
  418. t.setNotCount(t.getIngCount()-notcount);
  419. }
  420. return l;
  421. }
  422. @Override
  423. public XSSFWorkbook exportMyTaskList() {
  424. List<TOrderTaskListBo> list=taskProgressMapper.selectMyTaskList(TokenManager.getAdminId());
  425. if (list==null || list.size()==0) return null;
  426. String[] comment = {"任务编号","任务名称","订单编号","业务别类","客户名称(软著数/下证数)","任务状态","项目状态","分配时间","订单部门"};
  427. String filePath = uploadPath + "/MyTaskList";
  428. XSSFWorkbook wb = ExportExcelUtil.exportSelectMyTaskList(list, comment, filePath);
  429. return wb;
  430. }
  431. }