OrderProjectServiceImpl.java 31 KB

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