OrderProjectServiceImpl.java 42 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951
  1. package com.goafanti.order.service.impl;
  2. import java.io.IOException;
  3. import java.io.OutputStream;
  4. import java.io.UnsupportedEncodingException;
  5. import java.math.BigDecimal;
  6. import java.text.ParseException;
  7. import java.text.SimpleDateFormat;
  8. import java.util.ArrayList;
  9. import java.util.Date;
  10. import java.util.HashMap;
  11. import java.util.List;
  12. import java.util.Map;
  13. import java.util.UUID;
  14. import javax.mail.MessagingException;
  15. import javax.servlet.http.HttpServletResponse;
  16. import org.apache.commons.lang3.StringUtils;
  17. import org.apache.poi.xssf.usermodel.XSSFCell;
  18. import org.apache.poi.xssf.usermodel.XSSFRow;
  19. import org.apache.poi.xssf.usermodel.XSSFSheet;
  20. import org.apache.poi.xssf.usermodel.XSSFWorkbook;
  21. import org.slf4j.Logger;
  22. import org.slf4j.LoggerFactory;
  23. import org.springframework.beans.factory.annotation.Autowired;
  24. import org.springframework.beans.factory.annotation.Value;
  25. import org.springframework.stereotype.Service;
  26. import org.springframework.transaction.annotation.Transactional;
  27. import com.goafanti.common.bo.EmailBo;
  28. import com.goafanti.common.bo.Error;
  29. import com.goafanti.common.bo.paymentNodeEmailBo;
  30. import com.goafanti.common.constant.AFTConstants;
  31. import com.goafanti.common.constant.ErrorConstants;
  32. import com.goafanti.common.dao.AdminMapper;
  33. import com.goafanti.common.dao.BusinessProjectMapper;
  34. import com.goafanti.common.dao.NewOrderDunMapper;
  35. import com.goafanti.common.dao.NoticeMapper;
  36. import com.goafanti.common.dao.OrganizationContactBookMapper;
  37. import com.goafanti.common.dao.OrganizationIdentityMapper;
  38. import com.goafanti.common.dao.PaymentNodeMapper;
  39. import com.goafanti.common.dao.TArrearsDunMapper;
  40. import com.goafanti.common.dao.TOrderBonusMapper;
  41. import com.goafanti.common.dao.TOrderLogMapper;
  42. import com.goafanti.common.dao.TOrderMidMapper;
  43. import com.goafanti.common.dao.TOrderNewMapper;
  44. import com.goafanti.common.dao.TOrderTaskMapper;
  45. import com.goafanti.common.dao.TTaskHoursMapper;
  46. import com.goafanti.common.dao.TTaskLogMapper;
  47. import com.goafanti.common.dao.TTaskMidMapper;
  48. import com.goafanti.common.dao.TaskHoursCountMapper;
  49. import com.goafanti.common.dao.TaskLogMapper;
  50. import com.goafanti.common.dao.TaskProgressMapper;
  51. import com.goafanti.common.dao.UserBusinessMapper;
  52. import com.goafanti.common.dao.UserLockReleaseMapper;
  53. import com.goafanti.common.dao.UserMapper;
  54. import com.goafanti.common.enums.NoticeStatus;
  55. import com.goafanti.common.enums.OrderLogProcess;
  56. import com.goafanti.common.error.BusinessException;
  57. import com.goafanti.common.model.Admin;
  58. import com.goafanti.common.model.BusinessProject;
  59. import com.goafanti.common.model.Notice;
  60. import com.goafanti.common.model.OrganizationContactBook;
  61. import com.goafanti.common.model.OrganizationIdentity;
  62. import com.goafanti.common.model.TArrearsDun;
  63. import com.goafanti.common.model.TOrderBonus;
  64. import com.goafanti.common.model.TOrderLog;
  65. import com.goafanti.common.model.TOrderMid;
  66. import com.goafanti.common.model.TOrderNew;
  67. import com.goafanti.common.model.TOrderTask;
  68. import com.goafanti.common.model.TTaskHours;
  69. import com.goafanti.common.model.TTaskLog;
  70. import com.goafanti.common.model.TTaskMid;
  71. import com.goafanti.common.model.TaskHoursCount;
  72. import com.goafanti.common.model.TaskLog;
  73. import com.goafanti.common.model.TaskProgress;
  74. import com.goafanti.common.model.UserBusiness;
  75. import com.goafanti.common.model.UserLockRelease;
  76. import com.goafanti.common.utils.DateUtils;
  77. import com.goafanti.common.utils.ExportExcelUtil;
  78. import com.goafanti.common.utils.LoggerUtils;
  79. import com.goafanti.common.utils.SendEmailUtil;
  80. import com.goafanti.core.mybatis.BaseMybatisDao;
  81. import com.goafanti.core.mybatis.page.Pagination;
  82. import com.goafanti.core.shiro.token.TokenManager;
  83. import com.goafanti.order.bo.OutNewOrderDunBo;
  84. import com.goafanti.order.bo.TOrderTaskBo;
  85. import com.goafanti.order.bo.TOrderTaskDetailBo;
  86. import com.goafanti.order.bo.TOrderTaskListBo;
  87. import com.goafanti.order.bo.TaskLogBo;
  88. import com.goafanti.order.bo.TaskProgressBo;
  89. import com.goafanti.order.bo.inuptTaskHoursListBo;
  90. import com.goafanti.order.bo.inuptTaskListBo;
  91. import com.goafanti.order.enums.BonusSubject;
  92. import com.goafanti.order.enums.NewOrderDunType;
  93. import com.goafanti.order.enums.OrderDunProjectType;
  94. import com.goafanti.order.enums.OrderProjectStatus;
  95. import com.goafanti.order.enums.ProcessStatus;
  96. import com.goafanti.order.enums.ProjectNewStage;
  97. import com.goafanti.order.service.OrderNewService;
  98. import com.goafanti.order.service.OrderProjectService;
  99. import com.goafanti.organization.bo.OutPaymentNode;
  100. import com.goafanti.techproject.enums.TaskState;
  101. @Service
  102. public class OrderProjectServiceImpl extends BaseMybatisDao<TOrderTaskMapper> implements OrderProjectService {
  103. @Autowired
  104. private TOrderTaskMapper tOrderTaskMapper;
  105. @Autowired
  106. private TOrderNewMapper tOrderNewMapper;
  107. @Autowired
  108. private TTaskHoursMapper tTaskHoursMapper;
  109. @Autowired
  110. private TOrderBonusMapper tOrderBonusMapper;
  111. @Autowired
  112. private TTaskLogMapper tTaskLogMapper;
  113. @Autowired
  114. private TOrderLogMapper tOrderLogMapper;
  115. @Autowired
  116. private TaskProgressMapper taskProgressMapper;
  117. @Autowired
  118. private OrganizationContactBookMapper organizationContactBookMapper;
  119. @Autowired
  120. private OrganizationIdentityMapper organizationIdentityMapper;
  121. @Autowired
  122. private TaskLogMapper taskLogMapper;
  123. @Autowired
  124. private OrderNewService orderNewService;
  125. @Autowired
  126. private TaskHoursCountMapper taskHoursCountMapper;
  127. @Autowired
  128. private AdminMapper adminMapper;
  129. @Autowired
  130. private BusinessProjectMapper businessProjectMapper;
  131. @Autowired
  132. private NewOrderDunMapper newOrderDunMapper;
  133. @Autowired
  134. private TOrderMidMapper tOrderMidMapper;
  135. @Autowired
  136. private TArrearsDunMapper tArrearsDunMapper;
  137. @Autowired
  138. private PaymentNodeMapper paymentNodeMapper;
  139. @Autowired
  140. private NoticeMapper noticeMapper;
  141. @Autowired
  142. private TTaskMidMapper tTaskMidMapper;
  143. @Autowired
  144. private UserMapper userMapper;
  145. @Autowired
  146. private UserLockReleaseMapper userLockReleaseMapper;
  147. @Autowired
  148. private UserBusinessMapper userBusinessMapper;
  149. @Value(value = "${upload.path}")
  150. private String uploadPath = null;
  151. Logger logger = LoggerFactory.getLogger(OrderProjectServiceImpl.class);
  152. @Override
  153. public int updateProjectDistribution(Integer taskId, String taskReceiverId,Integer specially,String remarks) {
  154. TOrderTask t=tOrderTaskMapper.selectByPrimaryKey(taskId);
  155. TOrderNew tn=checkDeleteSign(t.getOrderNo());
  156. Date date=new Date();
  157. t.setTaskStatus(TaskState.DISTRIBUTION.getCode());
  158. t.setTaskAllocator(TokenManager.getAdminId());
  159. t.setTaskReceiver(taskReceiverId);
  160. t.setTaskDistributionTime(date);
  161. Admin a=adminMapper.selectByPrimaryKey(taskReceiverId);
  162. if (a==null||a.getId()==null) {
  163. throw new BusinessException(new Error("分配人员不存在!","分配人员不存在!"));
  164. }
  165. insetLog(taskId, taskReceiverId);
  166. //0-经理 (经理分派会创建子项目)1 管理员或经理转交
  167. if (specially==1) {
  168. addOrderLog(t.getOrderNo(), OrderLogProcess.XMDDPD.getCode(),remarks);
  169. t.setManagerId(taskReceiverId);
  170. t.setConsultantId(null);
  171. //设置催款触发
  172. TOrderNew b=tOrderNewMapper.selectByPrimaryKey(t.getOrderNo());
  173. if(b.getApproval()==0)orderNewService.pushOrderDun(t.getOrderNo());
  174. //未锁定客户就锁定客户
  175. if (userMapper.checkLock(tn.getBuyerId())<1) {
  176. userLockReleaseMapper.updateByAidAndUid(tn.getSalesmanId(),tn.getBuyerId());
  177. userMapper.updateShareType(tn.getBuyerId(),tn.getSalesmanId());
  178. }
  179. //未锁定业务就锁定业务
  180. if (userLockReleaseMapper.checkLock(tn.getSalesmanId(),tn.getBuyerId(),t.getCommodityId())<1) {
  181. UserLockRelease ulr=new UserLockRelease();
  182. ulr.setId(UUID.randomUUID().toString());
  183. ulr.setBusinessProjectId(t.getCommodityId());
  184. ulr.setType(1);
  185. ulr.setUid(tn.getBuyerId());
  186. ulr.setAid(tn.getSalesmanId());
  187. ulr.setStatus(0);
  188. ulr.setLockTime(date);
  189. userLockReleaseMapper.insertSelective(ulr);
  190. }
  191. UserBusiness ub=new UserBusiness();
  192. ub.setId(UUID.randomUUID().toString());
  193. ub.setUid(tn.getBuyerId());
  194. ub.setAid(tn.getSalesmanId());
  195. ub.setFollowSituation(5);
  196. ub.setCustomerStatus(4);
  197. ub.setCreateTime(date);
  198. ub.setUpdateTime(date);
  199. ub.setRemarks("派单自动锁定客户");
  200. ub.setBusinessProjectId(t.getCommodityId());
  201. userLockReleaseMapper.updateByAidAndUid(tn.getSalesmanId(),tn.getBuyerId());
  202. userBusinessMapper.insertSelective(ub);
  203. }else if (specially==0) {
  204. addOrderLog(t.getOrderNo(), OrderLogProcess.XMPD.getCode(),remarks);
  205. t.setConsultantId(taskReceiverId);
  206. //咨询师推给咨询师经理
  207. }else if(specially==2) {
  208. t.setConsultantId(null);
  209. }
  210. t.setReceiverName(a.getName());
  211. tOrderTaskMapper.updateByPrimaryKey(t);
  212. List<String> aids = new ArrayList<>();
  213. aids.add(taskReceiverId);
  214. orderNewService.pushGeneralSendNoticeAndEmail(aids, NoticeStatus.ORDER_TASK_TO.getCode(),t.getOrderNo(), TokenManager.getAdminId(),0);
  215. checkProjiectAllocation(t.getOrderNo());
  216. return 1;
  217. }
  218. public TOrderNew checkDeleteSign(String orderNo) {
  219. TOrderNew t=tOrderNewMapper.selectByPrimaryKey(orderNo);
  220. if(t.getDeleteSign()==2||t.getDeleteSign()==3) throw new BusinessException(new Error(ErrorConstants.ORDER_ALREADY_REVOKE, t.getOrderNo(),""));
  221. return t;
  222. }
  223. public void addOrderLog(String orderNo, Integer code,String remarks) {
  224. TOrderLog tl=new TOrderLog();
  225. tl.setOrderNo(orderNo);
  226. tl.setProcess(code);
  227. tl.setAid(TokenManager.getAdminId());
  228. if(null!=remarks)tl.setRemarks(remarks);
  229. tOrderLogMapper.insertSelective(tl);
  230. }
  231. public void checkProjiectAllocation(String orderNo) {
  232. List<TOrderTaskBo> taskBos=tOrderTaskMapper.selectOrderTask(orderNo);
  233. TOrderNew tNew=new TOrderNew();
  234. tNew.setOrderNo(orderNo);
  235. int i=0;
  236. for (TOrderTaskBo to : taskBos) {
  237. if (to.getTaskStatus()>TaskState.UN_DISTRIBUTION.getCode()&&to.getTaskStatus()<TaskState.INVALID.getCode()) {
  238. i++;
  239. }
  240. }
  241. if (i==taskBos.size()) {
  242. tNew.setProcessStatus(ProcessStatus.YQBFPZXSGLY.getCode());
  243. }else if(i>0&&i<taskBos.size()){
  244. tNew.setProcessStatus(ProcessStatus.YBFPZXSGLY.getCode());
  245. }else if(i==0){
  246. tNew.setProcessStatus(ProcessStatus.YPZXSGLY.getCode());
  247. }
  248. tOrderNewMapper.updateByPrimaryKeySelective(tNew);
  249. }
  250. private void insetLog(Integer taskId, String taskReceiverId) {
  251. TTaskLog tl=new TTaskLog();
  252. tl.setCreateTime(new Date());
  253. tl.setTaskId(taskId);
  254. tl.setTaskAllocator(TokenManager.getAdminId());
  255. tl.setTaskReceiver(taskReceiverId);
  256. tTaskLogMapper.insertSelective(tl);
  257. }
  258. @SuppressWarnings("unchecked")
  259. @Override
  260. public Pagination<TOrderTaskListBo> orderTaskList(inuptTaskListBo ib) {
  261. Map<String, Object> params = new HashMap<String, Object>();
  262. if(ib.getPageSize()==null||ib.getPageSize()<0)ib.setPageSize(10);
  263. if(ib.getPageNo()==null||ib.getPageNo()<0)ib.setPageNo(1);
  264. params.put("outsource", ib.getOutsource()==null?0:ib.getOutsource());
  265. if (null!=ib.getSpecially()) params.put("specially", ib.getSpecially());
  266. if (StringUtils.isNotBlank(ib.getName())) params.put("name", ib.getName());
  267. if (StringUtils.isNotBlank(ib.getDepId())) params.put("depId", ib.getDepId());
  268. if (StringUtils.isNotBlank(ib.getOrderNo())) params.put("orderNo", ib.getOrderNo());
  269. if (StringUtils.isNotBlank(ib.getContractNo())) params.put("contractNo", ib.getContractNo());
  270. if (ib.getProjectStatus() !=null ) params.put("projectStatus", ib.getProjectStatus());
  271. if (StringUtils.isNotBlank(ib.getTaskId())) params.put("taskId", ib.getTaskId());
  272. if (ib.getApproval() !=null) params.put("approval", ib.getApproval());
  273. if (StringUtils.isNotBlank(ib.getAdminName())) params.put("adminName", ib.getAdminName());
  274. if (StringUtils.isNotBlank(ib.getStartTime())) params.put("startTime", ib.getStartTime());
  275. if (StringUtils.isNotBlank(ib.getEndTime())) params.put("endTime", ib.getEndTime());
  276. if (null != ib.getTaskStatus()) params.put("taskStatus", ib.getTaskStatus());
  277. if (ib.getOutsourceStatus() !=null) params.put("outsourceStatus", ib.getOutsourceStatus());
  278. List<String> fids=new ArrayList<>();
  279. if (TokenManager.hasRole(AFTConstants.FINANCE_ADMIN) ||TokenManager.hasRole(AFTConstants.SUPERADMIN)||
  280. TokenManager.hasRole(AFTConstants.CED)||TokenManager.hasRole(AFTConstants.APPROVAL_DECISION)||
  281. TokenManager.hasRole(AFTConstants.VICE_CEO)) {
  282. params.put("role", 2);
  283. }else if (TokenManager.hasRole(AFTConstants.FINANCE_MANAGER)) {
  284. params.put("role", 1);
  285. fids =adminMapper.selectBySuperId(TokenManager.getAdminId());
  286. params.put("fids",fids);
  287. }else if (TokenManager.hasRole(AFTConstants.FINANCE)) {
  288. params.put("role", 1);
  289. fids.add(TokenManager.getAdminId());
  290. params.put("fids",fids);
  291. } else {
  292. params.put("role", 0);
  293. params.put("aid", TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  294. }
  295. Pagination<TOrderTaskListBo> p = (Pagination<TOrderTaskListBo>)findPage("selectOrderTaskListByPage", "selectOrderTaskListCount", params, ib.getPageNo(), ib.getPageSize());
  296. List<TOrderTaskListBo> list=(List<TOrderTaskListBo>) p.getList();
  297. for (TOrderTaskListBo t : list) {
  298. if(t.getSplitStatus()==1) {
  299. List<TOrderTaskListBo> l=splitProjectList(t.getId());
  300. t.setSplitList(l);
  301. }
  302. }
  303. return p;
  304. }
  305. @Override
  306. public TOrderTaskDetailBo orderTaskDetail(String id) {
  307. TOrderTaskDetailBo t=tOrderTaskMapper.getOrderTaskDetail(id);
  308. if (TokenManager.hasRole(AFTConstants.SUPERADMIN)||TokenManager.hasRole(AFTConstants.APPROVAL_DECISION)
  309. ||TokenManager.hasRole(AFTConstants.APPROVAL_DECISION)||TokenManager.hasRole(AFTConstants.TECH_ADMIN)
  310. ||TokenManager.getAdminId().equals(t.getTaskReceiver())) {
  311. return t;
  312. }else {
  313. t.setOutsourceName("****");
  314. t.setOutsourcePrice("****");
  315. t.setDeclareUser("****");
  316. t.setDeclarePwd("****");
  317. t.setCertificateNumber("****");
  318. return t;
  319. }
  320. }
  321. @Override
  322. @Transactional
  323. public int updateOrderTask(TOrderTaskDetailBo t) {
  324. TOrderTask task=new TOrderTask();
  325. TOrderNew tn=checkDeleteSign(t.getOrderNo());
  326. task.setAttachmentUrl(t.getAttachmentUrl());
  327. task.setId(Integer.valueOf(t.getId()));
  328. task.setTaskStatus(t.getTaskStatus());
  329. task.setProjectStatus(t.getProjectStatus());
  330. task.setTaskComment(t.getTaskComment());
  331. task.setCertificateNumber(t.getCertificateNumber());
  332. task.setStatus(t.getStatus());
  333. task.setFormRetrieve(t.getFormRetrieve());
  334. task.setTaskRefund(t.getTaskRefund());
  335. task.setRefundContent(t.getRefundContent());
  336. task.setRetrieveContent(t.getRetrieveContent());
  337. task.setDeclareUser(t.getDeclareUser());
  338. task.setDeclarePwd(t.getDeclarePwd());
  339. task.setArrivalMoney(t.getArrivalMoney());
  340. task.setSetUpAmount(t.getSetUpAmount());
  341. task.setOutsourceName(t.getOutsourceName());
  342. task.setDeclarationBatch(t.getDeclarationBatch());
  343. if(StringUtils.isNotBlank(t.getOutsourcePrice()))task.setOutsourcePrice(new BigDecimal(t.getOutsourcePrice()));
  344. //根据修改的修改订单法人与联系人
  345. if(StringUtils.isNotEmpty(t.getContacts()))tn.setContacts(t.getContacts());
  346. if(StringUtils.isNotEmpty(t.getContactMobile())) tn.setContactMobile(t.getContactMobile());
  347. if(StringUtils.isNotEmpty(t.getLegalPerson()))tn.setLegalPerson(t.getLegalPerson());
  348. if(StringUtils.isNotEmpty(t.getLegalPersonTel()))tn.setLegalPersonTel(t.getLegalPersonTel());
  349. tOrderNewMapper.updateByPrimaryKeySelective(tn);
  350. //修改公司地址信息
  351. if (null!=t.getLocationProvince()||null!=t.getLocationArea()||null!=t.getLocationCity()||null!=t.getPostalAddress()) {
  352. OrganizationIdentity org=new OrganizationIdentity();
  353. org.setUid(tn.getBuyerId());
  354. org.setLocationProvince(t.getLocationProvince());
  355. org.setLocationArea(t.getLocationArea());
  356. org.setLocationCity(t.getLocationCity());
  357. org.setPostalAddress(t.getPostalAddress());
  358. organizationIdentityMapper.updateServiceByUid(org);
  359. }
  360. //修改公司联系人
  361. int adcount=organizationContactBookMapper.checkContacts(tn.getBuyerId(), t.getContactMobile(),tn.getSalesmanId());
  362. if (StringUtils.isNotBlank(t.getContacts())&&StringUtils.isNotBlank(t.getContactMobile())&&adcount<1) {
  363. OrganizationContactBook contactBook=new OrganizationContactBook();
  364. contactBook.setId(UUID.randomUUID().toString());
  365. contactBook.setAid(tn.getSalesmanId());
  366. contactBook.setUid(tn.getBuyerId());
  367. contactBook.setName(t.getContacts());
  368. contactBook.setMobile(t.getContactMobile());
  369. organizationContactBookMapper.insertSelective(contactBook);
  370. }
  371. //新增结算奖金信息
  372. checkSettlementAward(tn,task);
  373. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  374. try {
  375. if(StringUtils.isNotBlank(t.getStartDate()))task.setTaskStartTime(sdf.parse(t.getStartDate()));
  376. if(StringUtils.isNotBlank(t.getEndDate()))task.setTaskEndTime(sdf.parse(t.getEndDate()));
  377. if(StringUtils.isNotBlank(t.getAcceptDate()))task.setAcceptTime(sdf.parse(t.getAcceptDate()));
  378. if(StringUtils.isNotBlank(t.getReviewDate()))task.setReviewTime(sdf.parse(t.getReviewDate()));
  379. if(StringUtils.isNotBlank(t.getPublicityDate()))task.setPublicityTime(sdf.parse(t.getPublicityDate()));
  380. if(StringUtils.isNotBlank(t.getLicenceDate()))task.setLicenceTime(sdf.parse(t.getLicenceDate()));
  381. } catch (ParseException e) {
  382. e.printStackTrace();
  383. }
  384. TOrderTask task2=tOrderTaskMapper.selectByPrimaryKey(task.getId());//查询出项目信息
  385. tOrderTaskMapper.updateByPrimaryKeySelective(task);
  386. TaskLog tl=new TaskLog();
  387. tl.setCreateTime(new Date());
  388. tl.setTaskId(t.getId());
  389. tl.setAid(TokenManager.getAdminId());
  390. if (t.getStatus()!=null) {
  391. if (t.getStatus()!=task2.getStatus()) {
  392. String s="将当前项目状态修改为";
  393. if (t.getStatus()==0)s+="开启";
  394. if (t.getStatus()==1)s+="暂停";
  395. tl.setContent(s);
  396. taskLogMapper.insertSelective(tl);
  397. }
  398. if (t.getTaskRefund()!=task2.getTaskRefund()) {
  399. String s="将当前项目退单修改为";
  400. if (t.getTaskRefund()==0)s+="未完成";
  401. if (t.getTaskRefund()==1)s+="已完成";
  402. if (t.getTaskRefund()==2)s+="其他";
  403. tl.setContent(s);
  404. taskLogMapper.insertSelective(tl);
  405. }
  406. if (t.getFormRetrieve()!=task2.getFormRetrieve()) {
  407. String s="将当前满意度表格回收修改为";
  408. if (t.getFormRetrieve()==0)s+="未回收";
  409. if (t.getFormRetrieve()==1)s+="已回收";
  410. if (t.getFormRetrieve()==2)s+="其他";
  411. tl.setContent(s);
  412. taskLogMapper.insertSelective(tl);
  413. }
  414. }
  415. //项目触发发催款
  416. if (task2.getSplitStatus()==0) {
  417. pushOrderDunAndPaymentNode(t,task2);
  418. }else if (task2.getSplitStatus()==2){
  419. //查出父项目
  420. List<TOrderTaskListBo> list=tOrderTaskMapper.splitProjectList(task2.getSplitSuper());
  421. //设置一个比较大的流程数字,然后取最小的
  422. Integer i=OrderProjectStatus.XMJD10.getCode();
  423. for (TOrderTaskListBo tt : list) {
  424. if (tt.getProjectStatus()<i) i=tt.getProjectStatus();
  425. }
  426. TOrderTask fatherTask=new TOrderTask();
  427. fatherTask.setId(task2.getSplitSuper());
  428. fatherTask.setProjectStatus(i);
  429. tOrderTaskMapper.updateByPrimaryKeySelective(fatherTask);
  430. TOrderTask task3=tOrderTaskMapper.selectByPrimaryKey(task2.getSplitSuper());
  431. //设置父任务
  432. TOrderTaskDetailBo t2=new TOrderTaskDetailBo();
  433. t2.setOrderNo(t.getOrderNo());
  434. t2.setId(task2.getSplitSuper().toString());
  435. t2.setProjectStatus(task3.getProjectStatus());
  436. pushOrderDunAndPaymentNode(t2,task3);
  437. }
  438. if (task2.getSuperId()!=null) {//是否有父项目
  439. TOrderTask task3 =tOrderTaskMapper.selectBySuperId(task2.getSuperId());
  440. task3.setId(Integer.valueOf(task2.getSuperId()));
  441. task3.setSuperId(null);
  442. tOrderTaskMapper.updateByPrimaryKeySelective(task3);
  443. TOrderTask task4 = tOrderTaskMapper.selectByPrimaryKey(Integer.valueOf(task2.getSuperId()));
  444. meanwhileUpdateOrder(task4);
  445. }else {
  446. meanwhileUpdateOrder(task2);
  447. }
  448. return 1;
  449. }
  450. private void pushOrderDunAndPaymentNode(TOrderTaskDetailBo t,TOrderTask task2) {
  451. List<OutNewOrderDunBo> list=newOrderDunMapper.selectByTid(t.getId());
  452. for (OutNewOrderDunBo ob : list) {
  453. if (ob!=null) {
  454. boolean flag=false;
  455. if((ob.getProjectType()==OrderDunProjectType.CGZH.getCode()&&ob.getDunType()==2&&//成果转化 验收
  456. t.getProjectStatus()==OrderProjectStatus.XMYS.getCode()))flag=true;
  457. if((ob.getProjectType()==OrderDunProjectType.COMMON.getCode()&&ob.getDunType()==2&&//通用 公示
  458. t.getProjectStatus()==OrderProjectStatus.XMGS.getCode()))flag=true;
  459. if((ob.getProjectType()==OrderDunProjectType.COMMON.getCode()&&ob.getDunType()==3&&//通用 下证
  460. t.getProjectStatus()==OrderProjectStatus.XMXZ.getCode()))flag=true;
  461. if((ob.getProjectType()==OrderDunProjectType.KJXM.getCode()&&ob.getDunType()==2&&//科技项目 立项或者公示
  462. (t.getProjectStatus()==OrderProjectStatus.XMLX.getCode()||(t.getProjectStatus()==OrderProjectStatus.XMGS.getCode()))))flag=true;
  463. if((ob.getProjectType()==OrderDunProjectType.KJXM.getCode()&&ob.getDunType()==3&&//科技项目 拨款
  464. t.getProjectStatus()==OrderProjectStatus.XMBK.getCode()))flag=true;
  465. if((ob.getProjectType()==OrderDunProjectType.KJJR.getCode()&&ob.getDunType()==2&&//科技金融 拨款
  466. t.getProjectStatus()==OrderProjectStatus.XMBK.getCode()))flag=true;
  467. if((ob.getProjectType()==OrderDunProjectType.RJKF.getCode()&&ob.getDunType()==2&&//软件开发 立项
  468. t.getProjectStatus()==OrderProjectStatus.XMLX.getCode()))flag=true;
  469. if((ob.getProjectType()==OrderDunProjectType.RJKF.getCode()&&ob.getDunType()==3&&//软件开发 验收
  470. t.getProjectStatus()==OrderProjectStatus.XMYS.getCode()))flag=true;
  471. if(ob.getProjectType()==OrderDunProjectType.ZSCQ.getCode()){//知识产权 公示 专利受理、转让(项目已提交),软著下证
  472. if(ob.getDunType()==3&&t.getProjectStatus()==OrderProjectStatus.XMXZ.getCode()) {
  473. flag=true;
  474. }else if (ob.getDunType()==2) {
  475. BusinessProject bp=businessProjectMapper.selectByPrimaryKey(task2.getCommodityId());
  476. if (bp.getType()==0&&t.getProjectStatus()==OrderProjectStatus.XMGS.getCode()) {
  477. flag=true;
  478. }
  479. if (bp.getType()==1&&t.getProjectStatus()==OrderProjectStatus.XMYTJ.getCode()) {
  480. flag=true;
  481. }
  482. if (bp.getType()==2&&t.getProjectStatus()==OrderProjectStatus.XMXZ.getCode()) {
  483. flag=true;
  484. }
  485. }
  486. }
  487. if(flag) {
  488. //如果启动催款,则新增欠款与应收款
  489. tOrderMidMapper.addOrderReceivables(t.getOrderNo(), ob.getMoney());
  490. TOrderMid tm=tOrderMidMapper.selectByOrderNo(t.getOrderNo());
  491. TArrearsDun td=new TArrearsDun();
  492. td.setOrderArrears(tm.getOrderArrears());
  493. td.setOrderReceivables(tm.getOrderReceivables());
  494. if (tArrearsDunMapper.checkOrderNo(t.getOrderNo(),null)<1) {
  495. td.setOrderNo(t.getOrderNo());
  496. tArrearsDunMapper.insertSelective(td);
  497. }else if(tArrearsDunMapper.checkOrderNo(t.getOrderNo(),0)>0){
  498. Integer i=tArrearsDunMapper.selectByStatus(t.getOrderNo(), 0);
  499. td.setId(i);
  500. tArrearsDunMapper.updateByPrimaryKeySelective(td);
  501. }
  502. orderNewService.addNewDunNoticAndSendEmail(t.getOrderNo(),ob);
  503. ob.setStatus(1);
  504. ob.setStartTime(new Date());
  505. newOrderDunMapper.updateByPrimaryKeySelective(ob);
  506. }
  507. }
  508. }
  509. List<OutPaymentNode> list2=paymentNodeMapper.selectByTid(Integer.parseInt(t.getId()),0);
  510. for (OutPaymentNode op : list2) {
  511. if (op!=null) {
  512. boolean flag=false;
  513. if((op.getProjectType()==OrderDunProjectType.CGZH.getCode()&&op.getDunType()==2&&//成果转化 验收
  514. t.getProjectStatus()==OrderProjectStatus.XMYS.getCode()))flag=true;
  515. if((op.getProjectType()==OrderDunProjectType.COMMON.getCode()&&op.getDunType()==2&&//通用 公示
  516. t.getProjectStatus()==OrderProjectStatus.XMGS.getCode()))flag=true;
  517. if((op.getProjectType()==OrderDunProjectType.COMMON.getCode()&&op.getDunType()==3&&//通用 下证
  518. t.getProjectStatus()==OrderProjectStatus.XMXZ.getCode()))flag=true;
  519. if((op.getProjectType()==OrderDunProjectType.KJXM.getCode()&&op.getDunType()==2&&//科技项目 立项或者公示
  520. (t.getProjectStatus()==OrderProjectStatus.XMLX.getCode()||(t.getProjectStatus()==OrderProjectStatus.XMGS.getCode()))))flag=true;
  521. if((op.getProjectType()==OrderDunProjectType.KJXM.getCode()&&op.getDunType()==3&&//科技项目 拨款
  522. t.getProjectStatus()==OrderProjectStatus.XMBK.getCode()))flag=true;
  523. if((op.getProjectType()==OrderDunProjectType.KJJR.getCode()&&op.getDunType()==2&&//科技金融 拨款
  524. t.getProjectStatus()==OrderProjectStatus.XMBK.getCode()))flag=true;
  525. if((op.getProjectType()==OrderDunProjectType.RJKF.getCode()&&op.getDunType()==2&&//软件开发 立项
  526. t.getProjectStatus()==OrderProjectStatus.XMLX.getCode()))flag=true;
  527. if((op.getProjectType()==OrderDunProjectType.RJKF.getCode()&&op.getDunType()==3&&//软件开发 验收
  528. t.getProjectStatus()==OrderProjectStatus.XMYS.getCode()))flag=true;
  529. if(op.getProjectType()==OrderDunProjectType.ZSCQ.getCode()){//知识产权 公示 专利受理、转让(项目已提交),软著下证
  530. if(op.getDunType()==3&&t.getProjectStatus()==OrderProjectStatus.XMXZ.getCode()) {
  531. flag=true;
  532. }else if (op.getDunType()==2) {
  533. BusinessProject bp=businessProjectMapper.selectByPrimaryKey(task2.getCommodityId());
  534. if (bp.getType()==0&&t.getProjectStatus()==OrderProjectStatus.XMGS.getCode()) {
  535. flag=true;
  536. }
  537. if (bp.getType()==1&&t.getProjectStatus()==OrderProjectStatus.XMYTJ.getCode()) {
  538. flag=true;
  539. }
  540. if (bp.getType()==2&&t.getProjectStatus()==OrderProjectStatus.XMXZ.getCode()) {
  541. flag=true;
  542. }
  543. }
  544. }
  545. if(flag)addNoticAndEmail( op,NoticeStatus.PAYMENT_DUN.getCode());
  546. }
  547. }
  548. }
  549. public void addNoticAndEmail(OutPaymentNode pn,Integer type) {
  550. paymentNodeEmailBo pnb=paymentNodeMapper.selectBytidGetEmail(pn.getTid());
  551. String str=NoticeStatus.getValueByCode(type)+": 订单编号 -"+pnb.getOrderNo()+", 操作人:平台超管中心-管理员。";
  552. Notice n =new Notice();
  553. n.setId(UUID.randomUUID().toString());
  554. n.setAid(pnb.getSalesmanId());
  555. n.setNoticeType(type);
  556. n.setContent(str);
  557. n.setReaded(0);//未读
  558. noticeMapper.insertSelective(n);
  559. pn.setDunStatus(1);
  560. paymentNodeMapper.updateByPrimaryKeySelective(pn);
  561. //营销员名称、邮箱、订单编号、客户名称
  562. String dunTypeName=NewOrderDunType.getValueByCode(Integer.valueOf(""+pn.getProjectType()+pn.getDunType()));
  563. //发送驳回邮件
  564. if(SendEmailUtil.isEmail(pnb.getEmail())) {
  565. EmailBo bo = new EmailBo("付款通知", pnb.getEmail(), "平台超管中心", "管理员",
  566. "", pnb.getOrderNo(),pn.getPartyTimes(),
  567. dunTypeName,pnb.getSalesmanName(),pnb.getUserName(),2,0);
  568. if(StringUtils.isNotBlank(pnb.getEmail())) {
  569. try {
  570. SendEmailUtil.getInstance().patentSend(bo);
  571. } catch (UnsupportedEncodingException | MessagingException e) {
  572. LoggerUtils.debug(logger, "=========================================发送邮件异常");
  573. e.printStackTrace();
  574. }
  575. }
  576. }
  577. }
  578. private void checkSettlementAward(TOrderNew tn,TOrderTask task) {
  579. if(task.getTaskStatus()==TaskState.COMPLETE.getCode()&&tn.getTotalAmount().compareTo(tn.getSettlementAmount())==0) {
  580. List<TOrderTask> l = tOrderTaskMapper.getReceiverByOid(tn.getOrderNo());
  581. for (TOrderTask tOrderTask : l) {
  582. if(null != tOrderTask &&null != tOrderTask.getTaskReceiver()){
  583. TOrderBonus bonus = new TOrderBonus();
  584. bonus.setId(UUID.randomUUID().toString());
  585. bonus.setOrderNo(tn.getOrderNo());
  586. bonus.setGrantBy(tn.getFinanceId());
  587. bonus.setBonusSubject(BonusSubject.WK.getCode());//12
  588. bonus.setTaskId(tOrderTask.getId());//任务id
  589. bonus.setGrantTarget(tOrderTask.getTaskReceiver());
  590. bonus.setGrantType(1);
  591. int c = tOrderBonusMapper.checkByOnoAndSub(bonus);
  592. //不存在就设置
  593. if(c==0){
  594. bonus.setId(UUID.randomUUID().toString());
  595. tOrderBonusMapper.insertSelective(bonus);
  596. }
  597. }
  598. }
  599. }
  600. }
  601. private void meanwhileUpdateOrder(TOrderTask task) {
  602. // if (task.getMain()==1) {//是否是主要项目 更改为不管是不是主项目都会有奖金信息
  603. //更改订单项目状态
  604. TOrderNew tNew=new TOrderNew();
  605. tNew.setProjectStatus(task.getProjectStatus());
  606. tNew.setOrderNo(task.getOrderNo());
  607. tOrderNewMapper.updateByPrimaryKeySelective(tNew);
  608. if (task.getProjectStatus()==ProjectNewStage.YTJ.getCode()||task.getProjectStatus()==ProjectNewStage.LS.getCode()||
  609. task.getProjectStatus()==ProjectNewStage.GS.getCode()) {
  610. TOrderBonus tb=new TOrderBonus();
  611. TOrderNew t=tOrderNewMapper.selectByPrimaryKey(task.getOrderNo());
  612. tb.setId(UUID.randomUUID().toString());
  613. tb.setOrderNo(task.getOrderNo());
  614. if (task.getProjectStatus()==ProjectNewStage.YTJ.getCode()) {
  615. tb.setBonusSubject(21);//项目已提交
  616. addOrderLog(task.getOrderNo(),OrderLogProcess.XMWC.getCode(),null);
  617. }
  618. if (task.getProjectStatus()==ProjectNewStage.LS.getCode())tb.setBonusSubject(23);//项目立项
  619. if (task.getProjectStatus()==ProjectNewStage.GS.getCode())tb.setBonusSubject(24);//项目公示
  620. tb.setGrantType(1);//技术员
  621. //新增奖金之前检查这个奖金数据是否存在
  622. tb.setGrantTarget(task.getTaskReceiver());
  623. int c = tOrderBonusMapper.checkByOnoAndSub(tb);
  624. if(c==0){
  625. tb.setGrantBy(t.getFinanceId());
  626. tb.setTaskId(task.getId());
  627. tOrderBonusMapper.insertSelective(tb);
  628. }
  629. }
  630. }
  631. @Override
  632. public int addTaskHours(TTaskHours t) {
  633. TOrderTask tt=tOrderTaskMapper.selectByPrimaryKey(Integer.valueOf(t.getTaskId()));
  634. checkDeleteSign(tt.getOrderNo());
  635. t.setAid(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  636. t.setId(UUID.randomUUID().toString());
  637. t.setCreateTime(new Date());
  638. if(taskHoursCountMapper.selectByAidAndTid(TokenManager.getAdminId(),t.getTaskId())>0) {
  639. taskHoursCountMapper.updateByAidAndTid(TokenManager.getAdminId(),t.getTaskId(),t.getHours());
  640. }else {
  641. TaskHoursCount tc=new TaskHoursCount();
  642. tc.setAid(TokenManager.getAdminId());
  643. tc.setTid(Integer.valueOf(t.getTaskId()));
  644. tc.setHours(t.getHours());
  645. taskHoursCountMapper.insertSelective(tc);
  646. }
  647. return tTaskHoursMapper.insertSelective(t);
  648. }
  649. @SuppressWarnings("unchecked")
  650. @Override
  651. public Pagination<TOrderTaskListBo> taskHoursList(inuptTaskHoursListBo ib, Integer pageNo,
  652. Integer pageSize) {
  653. Map<String, Object> params = new HashMap<String, Object>();
  654. if(pageSize==null||pageSize<0)pageSize=10;
  655. if(pageNo==null||pageNo<0)pageNo=1;
  656. if (StringUtils.isNotBlank(ib.getName())) params.put("name", ib.getName());
  657. if (StringUtils.isNotBlank(ib.getOrderNo())) params.put("orderNo", ib.getOrderNo());
  658. if (StringUtils.isNotBlank(ib.getTaskId())) params.put("taskId", ib.getTaskId());
  659. if (StringUtils.isNotBlank(ib.getStarTime())) params.put("starTime", ib.getStarTime());
  660. if (StringUtils.isNotBlank(ib.getEndTime())) params.put("endTime", ib.getEndTime()+" 23:59:59");
  661. if(StringUtils.isNotBlank(ib.getContractNo()))params.put("contractNo", ib.getContractNo());
  662. if(StringUtils.isNotBlank(ib.getDepId()))params.put("depId", ib.getDepId());
  663. if(StringUtils.isNotBlank(ib.getCid()))params.put("cid", ib.getCid());
  664. if(null!=ib.getOutsource())params.put("outsource", ib.getOutsource());
  665. Integer i=null;
  666. if (TokenManager.hasRole(AFTConstants.FINANCE))i=1;
  667. if (TokenManager.hasRole(AFTConstants.FINANCE_MANAGER))i=2;
  668. if (TokenManager.hasRole(AFTConstants.FINANCE_ADMIN)||TokenManager.hasRole(AFTConstants.VICE_CEO)||
  669. TokenManager.hasRole(AFTConstants.SUPERADMIN)||TokenManager.hasRole(AFTConstants.CED)||
  670. TokenManager.hasRole(AFTConstants.APPROVAL_DECISION))i=3;
  671. if(TokenManager.getAdminId()!=null)params.put("aid", TokenManager.getAdminId());
  672. if(i!=null)params.put("shiroType", i);
  673. Pagination<TOrderTaskListBo> p = (Pagination<TOrderTaskListBo>)findPage("selectTaskHoursListByPage", "selectTaskHoursListCount", params, pageNo, pageSize);
  674. return p;
  675. }
  676. @SuppressWarnings("unchecked")
  677. @Override
  678. public Pagination<TOrderTaskListBo> selectTaskList(String name, String orderNo, String taskId, Integer taskStatus,
  679. String adminName, Integer specially,String depId , Integer pageNo, Integer pageSize) {
  680. Map<String, Object> params = new HashMap<String, Object>();
  681. if(pageSize==null||pageSize<0)pageSize=10;
  682. if(pageNo==null||pageNo<0)pageNo=1;
  683. params.put("aid", TokenManager.getAdminId()==null?"":TokenManager.getAdminId());
  684. if (StringUtils.isNotBlank(name)) params.put("name", name);
  685. if (StringUtils.isNotBlank(depId)) params.put("depId", depId);
  686. if (StringUtils.isNotBlank(orderNo)) params.put("orderNo", orderNo);
  687. if (StringUtils.isNotBlank(taskId)) params.put("taskId", taskId);
  688. if (StringUtils.isNotBlank(adminName)) params.put("adminName", adminName);
  689. if (null != taskStatus) params.put("taskStatus", taskStatus);
  690. Pagination<TOrderTaskListBo> p = (Pagination<TOrderTaskListBo>)findPage("selectTaskListByPage", "selectTaskListCount", params, pageNo, pageSize);
  691. return p;
  692. }
  693. @Override
  694. public List<TaskLogBo> TaskLogList(Integer id) {
  695. return taskLogMapper.selectTaskLogList(id);
  696. }
  697. @Override
  698. public int createTaskProgress(TaskProgressBo t) {
  699. TaskProgress tp=new TaskProgress();
  700. TOrderTask tt=tOrderTaskMapper.selectByPrimaryKey(t.getTaskId());
  701. int count =taskProgressMapper.AlreadyNuberCount(t.getTaskId());
  702. count +=t.getAlreadyNumber();
  703. if(tt.getCommodityQuantity()<count)throw new BusinessException(new Error( "数量不能大于总量!" ,"数量不能大于总量!"));
  704. tp.setAlreadyNumber(t.getAlreadyNumber());
  705. tp.setLicenceTime(DateUtils.StringToDate(t.getLicenceTimes(), AFTConstants.YYYYMMDD));
  706. tp.setTaskId(t.getTaskId());
  707. return taskProgressMapper.insertSelective(tp);
  708. }
  709. @Override
  710. public int delectTaskProgress(Integer id) {
  711. return taskProgressMapper.deleteByPrimaryKey(id);
  712. }
  713. @Override
  714. public List<TaskProgressBo> selectTaskProgress(Integer tid) {
  715. List<TaskProgressBo> l=taskProgressMapper.selectTaskProgress(tid);
  716. int notcount=0;
  717. for (TaskProgressBo t : l) {
  718. notcount+=t.getAlreadyNumber();
  719. t.setNotCount(t.getIngCount()-notcount);
  720. }
  721. return l;
  722. }
  723. @Override
  724. public List<TTaskHours> taskHoursDetailsList(String taskId) {
  725. String aid=TokenManager.getAdminId();
  726. return tTaskHoursMapper.taskHoursDetailsList(taskId,aid);
  727. }
  728. @Override
  729. public void exportMyTaskList(HttpServletResponse response,inuptTaskHoursListBo ib, Integer pageNo, Integer pageSize) throws IOException {
  730. OutputStream out = response.getOutputStream();
  731. try {
  732. if(pageSize==null)pageSize=999999;
  733. @SuppressWarnings("unchecked")
  734. List<TOrderTaskListBo> list=(List<TOrderTaskListBo>) taskHoursList(ib, pageNo, pageSize).getList();
  735. //合同编号 订单编号 客户名称 订单部门 订单负责人 项目类别 项目编号 项目名称 项目负责人 项目价格(万元) 数量(个) 任务状态 项目状态 工时 签单时间 派单时间 分配时间 完成时间
  736. String[] comment = {"合同编号","订单编号","客户名称","订单部门","订单负责人","项目类别","项目编号","项目名称","项目负责人","项目价格(万元)",
  737. "数量(个)","任务状态","项目状态","是否外包","工时","签单日期","派单日期","分配时间","完成时间" ,"成本(万元)","已付(万元)" };
  738. String fileName ="工时信息记录表" + new SimpleDateFormat("yyyy-MM-dd HH:mm").format(new Date()) + ".xls";
  739. //type 0 变更
  740. XSSFWorkbook wb =ExportExcelUtil.exportTemplateInfoS(comment,"工时信息");
  741. //根据列表编写文档
  742. XSSFSheet sheet =wb.getSheetAt(0);
  743. for (TOrderTaskListBo ob : (List<TOrderTaskListBo>)list) {
  744. //新增一行
  745. XSSFRow r = sheet.createRow(sheet.getLastRowNum()+1);
  746. for (int i = 0; i < comment.length; i++) {
  747. //当前列的只
  748. String o = "";
  749. switch (comment[i]) {
  750. // "合同编号","订单编号","客户名称","订单部门","订单负责人 ","项目类别","项目编号","项目名称","项目负责人","项目价格(万元)",
  751. // " 数量(个)","任务状态","项目状态","工时","签单日期","派单日期","分配时间","完成时间"
  752. case "合同编号": o = ob.getContractNo(); break;
  753. case "订单编号": o = ob.getOrderNo().toString(); break;
  754. case "客户名称": o = ob.getUserName(); break;
  755. case "订单部门": o = ob.getDepName(); break;
  756. case "订单负责人": o = ob.getSalesmanName(); break;
  757. case "项目类别": o =ob.getCname(); break;
  758. case "项目编号": o = ob.getId().toString(); break;
  759. case "项目名称": o = ob.getTaskName(); break;
  760. case "是否外包": o = ob.getOutsource()==1?"是":"否"; break;
  761. case "项目负责人": o = ob.getReceiverName(); break;
  762. case "项目价格(万元)": o = ob.getCommodityPrice().toString(); break;
  763. case "数量(个)": o = ob.getCommodityQuantity().toString(); break;
  764. case "任务状态": o = TaskState.getValueByCode(ob.getTaskStatus()); break;
  765. case "项目状态": o = ProjectNewStage.getValueByCode(ob.getProjectStatus()); break;
  766. case "工时": o = ob.getHours().toString(); break;
  767. case "分配时间": o = ob.getTaskDistributionTime(); break;
  768. case "完成时间": o = ob.getTaskEndTime(); break;
  769. case "签单日期": o = ob.getSignTime(); break;
  770. case "派单日期": o = ob.getCreteTime();break;
  771. case "成本(万元)": o = ob.getCostAmount().toString(); break;
  772. case "已付(万元)": o = ob.getPartyAmount().toString(); break;
  773. default: o = ""; break;
  774. }
  775. XSSFCell c = r.createCell(i);
  776. c.setCellValue(o);
  777. }
  778. }
  779. //返回名称及参数
  780. response.addHeader("Content-Disposition", "attachment;filename=" + new String(fileName.getBytes(),"iso-8859-1"));
  781. response.setContentType("application/octet-stream;charset=utf-8");
  782. // 返回数据流
  783. wb.write(out);
  784. out.flush();
  785. out.close();
  786. } catch (Exception e) {
  787. throw new BusinessException(new Error("表格生成错误。"));
  788. }finally {
  789. out.flush();
  790. out.close();
  791. }
  792. }
  793. @Override
  794. public int pushSplitProject(Integer tid, String splitList) {
  795. String[] str=splitList.split(",");
  796. TOrderTask task=tOrderTaskMapper.selectByPrimaryKey(tid);
  797. checkDeleteSign(task.getOrderNo());
  798. TOrderTask usedTask=new TOrderTask();
  799. usedTask.setId(tid);
  800. usedTask.setSplitStatus(1);
  801. //计算拆分数量
  802. Integer x=0;
  803. for (String string : str) {
  804. x+=Integer.parseInt(string);
  805. }
  806. if (!task.getCommodityQuantity().equals(x)||str.length==1) {
  807. return -1;
  808. }
  809. tOrderTaskMapper.updateByPrimaryKeySelective(usedTask);
  810. int i=1;
  811. TOrderTask newTask=task;
  812. newTask.setCommodityPrice(new BigDecimal(0));
  813. newTask.setSplitAid(TokenManager.getAdminId());
  814. newTask.setSplitStatus(2);
  815. newTask.setSplitSuper(tid);
  816. newTask.setSplitTime(new Date());
  817. for (String string : str) {
  818. newTask.setId(null);
  819. newTask.setCommodityQuantity(Integer.parseInt(string));
  820. newTask.setSplitId(i);
  821. i++;
  822. tOrderTaskMapper.insertSelectiveGetId(newTask);
  823. TTaskMid tm=new TTaskMid(newTask.getId(),null);
  824. tTaskMidMapper.insertSelective(tm);
  825. }
  826. return 1;
  827. }
  828. @Override
  829. public List<TOrderTaskListBo> splitProjectList(Integer tid) {
  830. return tOrderTaskMapper.splitProjectList(tid);
  831. }
  832. @Override
  833. public void exporProjectList(HttpServletResponse response, inuptTaskListBo ib)
  834. throws IOException {
  835. OutputStream out = response.getOutputStream();
  836. try {
  837. if(ib.getPageSize()==null)ib.setPageSize(99999);
  838. String str="项目任务列表";
  839. if (ib.getOutsource()!=null&&ib.getOutsource()==1)str="外包项目任务";
  840. @SuppressWarnings("unchecked")
  841. List<TOrderTaskListBo> list=(List<TOrderTaskListBo>) orderTaskList(ib).getList();
  842. String[] comment = {"项目编号","项目名称","项目数量","订单编号","合同编号","业务类别","客户名称(软著/下证数)","分配状态",
  843. "项目状态","外包审核","分配时间","订单部门","累计工时","项目金额","成本(万元)","已付(万元)" };
  844. String fileName =str+"记录表" + new SimpleDateFormat("yyyy-MM-dd HH:mm").format(new Date()) + ".xls";
  845. //type 0 变更
  846. XSSFWorkbook wb =ExportExcelUtil.exportTemplateInfoS(comment,str);
  847. //根据列表编写文档
  848. XSSFSheet sheet =wb.getSheetAt(0);
  849. for (TOrderTaskListBo ob : (List<TOrderTaskListBo>)list) {
  850. //新增一行
  851. XSSFRow r = sheet.createRow(sheet.getLastRowNum()+1);
  852. for (int i = 0; i < comment.length; i++) {
  853. //当前列的只
  854. String o = "";
  855. switch (comment[i]) {
  856. // {"项目编号","项目名称","项目数量","订单编号","合同编号","业务类别","客户名称(软著/下证数)","分配状态",
  857. // "项目状态","外包审核","分配时间","订单部门","累计工时","项目金额","成本(万元)","已付(万元)" };
  858. case "项目编号": o = ob.getId().toString(); break;
  859. case "项目名称": o = ob.getTaskName(); break;
  860. case "项目数量": o = ob.getCommodityQuantity().toString(); break;
  861. case "订单编号": o = ob.getOrderNo(); break;
  862. case "合同编号": o = ob.getContractNo(); break;
  863. case "业务类别": o =ob.getCname(); break;
  864. case "客户名称(软著/下证数)": o =ob.getUserName();
  865. break;
  866. case "分配状态": o = TaskState.getValueByCode(ob.getTaskStatus()); break;
  867. case "项目状态": o = ProjectNewStage.getValueByCode(ob.getProjectStatus()); break;
  868. case "外包审核": o = ob.getOutsource()==1?"是":"否"; break;
  869. case "分配时间": o = ob.getTaskDate(); break;
  870. case "订单部门": o =ob.getDepName(); break;
  871. case "累计工时": o = ob.getHours().toString(); break;
  872. case "项目金额": o = ob.getCommodityPrice().toString(); break;
  873. case "成本(万元)": o = ob.getCostAmount().toString(); break;
  874. case "已付(万元)": o = ob.getPartyAmount().toString(); break;
  875. default: o = ""; break;
  876. }
  877. XSSFCell c = r.createCell(i);
  878. c.setCellValue(o);
  879. }
  880. }
  881. //返回名称及参数
  882. response.addHeader("Content-Disposition", "attachment;filename=" + new String(fileName.getBytes(),"iso-8859-1"));
  883. response.setContentType("application/octet-stream;charset=utf-8");
  884. // 返回数据流
  885. wb.write(out);
  886. out.flush();
  887. out.close();
  888. } catch (Exception e) {
  889. e.printStackTrace();
  890. }finally {
  891. out.flush();
  892. out.close();
  893. }
  894. }
  895. }