OrderProjectServiceImpl.java 28 KB

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