OrderProjectServiceImpl.java 24 KB

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