OrderProjectServiceImpl.java 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722
  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. if(StringUtils.isNotBlank(t.getOutsourcePrice()))task.setOutsourcePrice(new BigDecimal(t.getOutsourcePrice()));
  258. //根据修改的修改订单法人与联系人
  259. if(StringUtils.isNotEmpty(t.getContacts()))tn.setContacts(t.getContacts());
  260. if(StringUtils.isNotEmpty(t.getContactMobile())) tn.setContactMobile(t.getContactMobile());
  261. if(StringUtils.isNotEmpty(t.getLegalPerson()))tn.setLegalPerson(t.getLegalPerson());
  262. if(StringUtils.isNotEmpty(t.getLegalPersonTel()))tn.setLegalPersonTel(t.getLegalPersonTel());
  263. tOrderNewMapper.updateByPrimaryKeySelective(tn);
  264. //修改公司地址信息
  265. if (null!=t.getLocationProvince()||null!=t.getLocationArea()||null!=t.getLocationCity()||null!=t.getPostalAddress()) {
  266. OrganizationIdentity org=new OrganizationIdentity();
  267. org.setUid(tn.getBuyerId());
  268. org.setLocationProvince(t.getLocationProvince());
  269. org.setLocationArea(t.getLocationArea());
  270. org.setLocationCity(t.getLocationCity());
  271. org.setPostalAddress(t.getPostalAddress());
  272. organizationIdentityMapper.updateServiceByUid(org);
  273. }
  274. //修改公司联系人
  275. int adcount=organizationContactBookMapper.checkContacts(tn.getBuyerId(), t.getContactMobile(),tn.getSalesmanId());
  276. if (StringUtils.isNotBlank(t.getContacts())&&StringUtils.isNotBlank(t.getContactMobile())&&adcount<1) {
  277. OrganizationContactBook contactBook=new OrganizationContactBook();
  278. contactBook.setId(UUID.randomUUID().toString());
  279. contactBook.setAid(tn.getSalesmanId());
  280. contactBook.setUid(tn.getBuyerId());
  281. contactBook.setName(t.getContacts());
  282. contactBook.setMobile(t.getContactMobile());
  283. organizationContactBookMapper.insertSelective(contactBook);
  284. }
  285. //新增结算奖金信息
  286. checkSettlementAward(tn,task);
  287. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  288. try {
  289. if(StringUtils.isNotBlank(t.getStartDate()))task.setTaskStartTime(sdf.parse(t.getStartDate()));
  290. if(StringUtils.isNotBlank(t.getEndDate()))task.setTaskEndTime(sdf.parse(t.getEndDate()));
  291. if(StringUtils.isNotBlank(t.getAcceptDate()))task.setAcceptTime(sdf.parse(t.getAcceptDate()));
  292. if(StringUtils.isNotBlank(t.getReviewDate()))task.setReviewTime(sdf.parse(t.getReviewDate()));
  293. if(StringUtils.isNotBlank(t.getPublicityDate()))task.setPublicityTime(sdf.parse(t.getPublicityDate()));
  294. if(StringUtils.isNotBlank(t.getLicenceDate()))task.setLicenceTime(sdf.parse(t.getLicenceDate()));
  295. } catch (ParseException e) {
  296. e.printStackTrace();
  297. }
  298. TOrderTask task2=tOrderTaskMapper.selectByPrimaryKey(task.getId());//查询出项目信息
  299. tOrderTaskMapper.updateByPrimaryKeySelective(task);
  300. TaskLog tl=new TaskLog();
  301. tl.setCreateTime(new Date());
  302. tl.setTaskId(t.getId());
  303. tl.setAid(TokenManager.getAdminId());
  304. if (t.getStatus()!=null) {
  305. if (t.getStatus()!=task2.getStatus()) {
  306. String s="将当前项目状态修改为";
  307. if (t.getStatus()==0)s+="开启";
  308. if (t.getStatus()==1)s+="暂停";
  309. tl.setContent(s);
  310. taskLogMapper.insertSelective(tl);
  311. }
  312. if (t.getTaskRefund()!=task2.getTaskRefund()) {
  313. String s="将当前项目退单修改为";
  314. if (t.getTaskRefund()==0)s+="未完成";
  315. if (t.getTaskRefund()==1)s+="已完成";
  316. if (t.getTaskRefund()==2)s+="其他";
  317. tl.setContent(s);
  318. taskLogMapper.insertSelective(tl);
  319. }
  320. if (t.getFormRetrieve()!=task2.getFormRetrieve()) {
  321. String s="将当前满意度表格回收修改为";
  322. if (t.getFormRetrieve()==0)s+="未回收";
  323. if (t.getFormRetrieve()==1)s+="已回收";
  324. if (t.getFormRetrieve()==2)s+="其他";
  325. tl.setContent(s);
  326. taskLogMapper.insertSelective(tl);
  327. }
  328. }
  329. //项目触发发催款
  330. if (task2.getSplitStatus()==0) {
  331. pushOrderDun(t,task2);
  332. }else if (task2.getSplitStatus()==2){
  333. //查出父项目
  334. List<TOrderTaskListBo> list=tOrderTaskMapper.splitProjectList(task2.getSplitSuper());
  335. //设置一个比较大的流程数字,然后取最小的
  336. Integer i=OrderProjectStatus.XMJD10.getCode();
  337. for (TOrderTaskListBo tt : list) {
  338. if (tt.getProjectStatus()<i) i=tt.getProjectStatus();
  339. }
  340. TOrderTask fatherTask=new TOrderTask();
  341. fatherTask.setId(task2.getSplitSuper());
  342. fatherTask.setProjectStatus(i);
  343. tOrderTaskMapper.updateByPrimaryKeySelective(fatherTask);
  344. TOrderTask task3=tOrderTaskMapper.selectByPrimaryKey(task2.getSplitSuper());
  345. //设置父任务
  346. TOrderTaskDetailBo t2=new TOrderTaskDetailBo();
  347. t2.setOrderNo(t.getOrderNo());
  348. t2.setId(task2.getSplitSuper().toString());
  349. t2.setProjectStatus(task3.getProjectStatus());
  350. pushOrderDun(t2,task3);
  351. }
  352. if (task2.getSuperId()!=null) {//是否有父项目
  353. TOrderTask task3 =tOrderTaskMapper.selectBySuperId(task2.getSuperId());
  354. task3.setId(Integer.valueOf(task2.getSuperId()));
  355. task3.setSuperId(null);
  356. tOrderTaskMapper.updateByPrimaryKeySelective(task3);
  357. TOrderTask task4 = tOrderTaskMapper.selectByPrimaryKey(Integer.valueOf(task2.getSuperId()));
  358. meanwhileUpdateOrder(task4);
  359. }else {
  360. meanwhileUpdateOrder(task2);
  361. }
  362. return 1;
  363. }
  364. private void pushOrderDun(TOrderTaskDetailBo t,TOrderTask task2) {
  365. List<OutNewOrderDunBo> list=newOrderDunMapper.selectByTid(t.getId());
  366. for (OutNewOrderDunBo ob : list) {
  367. if (ob!=null) {
  368. boolean flag=false;
  369. if((ob.getProjectType()==OrderDunProjectType.CGZH.getCode()&&ob.getDunType()==2&&//成果转化 验收
  370. t.getProjectStatus()==OrderProjectStatus.XMYS.getCode()))flag=true;
  371. if((ob.getProjectType()==OrderDunProjectType.COMMON.getCode()&&ob.getDunType()==2&&//通用 公示
  372. t.getProjectStatus()==OrderProjectStatus.XMGS.getCode()))flag=true;
  373. if((ob.getProjectType()==OrderDunProjectType.COMMON.getCode()&&ob.getDunType()==3&&//通用 下证
  374. t.getProjectStatus()==OrderProjectStatus.XMXZ.getCode()))flag=true;
  375. if((ob.getProjectType()==OrderDunProjectType.KJXM.getCode()&&ob.getDunType()==2&&//科技项目 立项或者公示
  376. (t.getProjectStatus()==OrderProjectStatus.XMLX.getCode()||(t.getProjectStatus()==OrderProjectStatus.XMGS.getCode()))))flag=true;
  377. if((ob.getProjectType()==OrderDunProjectType.KJXM.getCode()&&ob.getDunType()==3&&//科技项目 拨款
  378. t.getProjectStatus()==OrderProjectStatus.XMBK.getCode()))flag=true;
  379. if((ob.getProjectType()==OrderDunProjectType.KJJR.getCode()&&ob.getDunType()==2&&//科技金融 拨款
  380. t.getProjectStatus()==OrderProjectStatus.XMBK.getCode()))flag=true;
  381. if((ob.getProjectType()==OrderDunProjectType.RJKF.getCode()&&ob.getDunType()==2&&//软件开发 立项
  382. t.getProjectStatus()==OrderProjectStatus.XMLX.getCode()))flag=true;
  383. if((ob.getProjectType()==OrderDunProjectType.RJKF.getCode()&&ob.getDunType()==3&&//软件开发 验收
  384. t.getProjectStatus()==OrderProjectStatus.XMYS.getCode()))flag=true;
  385. if(ob.getProjectType()==OrderDunProjectType.ZSCQ.getCode()){//知识产权 公示 专利受理、转让(项目已提交),软著下证
  386. if(ob.getDunType()==3&&t.getProjectStatus()==OrderProjectStatus.XMXZ.getCode()) {
  387. flag=true;
  388. }else if (ob.getDunType()==2) {
  389. BusinessProject bp=businessProjectMapper.selectByPrimaryKey(task2.getCommodityId());
  390. if (bp.getType()==0&&t.getProjectStatus()==OrderProjectStatus.XMGS.getCode()) {
  391. flag=true;
  392. }
  393. if (bp.getType()==1&&t.getProjectStatus()==OrderProjectStatus.XMYTJ.getCode()) {
  394. flag=true;
  395. }
  396. if (bp.getType()==2&&t.getProjectStatus()==OrderProjectStatus.XMXZ.getCode()) {
  397. flag=true;
  398. }
  399. }
  400. }
  401. if(flag) {
  402. TOrderNew tn=tOrderNewMapper.selectByPrimaryKey(t.getOrderNo());
  403. //如果启动催款,则新增欠款与应收款
  404. tOrderMidMapper.addOrderReceivables(t.getOrderNo(), ob.getMoney());
  405. TOrderMid tm=tOrderMidMapper.selectByOrderNo(t.getOrderNo());
  406. TArrearsDun td=new TArrearsDun();
  407. td.setOrderArrears(tm.getOrderArrears());
  408. td.setOrderReceivables(tm.getOrderReceivables());
  409. if (tArrearsDunMapper.checkOrderNo(t.getOrderNo(),null)<1) {
  410. td.setOrderNo(t.getOrderNo());
  411. tArrearsDunMapper.insertSelective(td);
  412. }else if(tArrearsDunMapper.checkOrderNo(t.getOrderNo(),0)>0){
  413. Integer i=tArrearsDunMapper.selectByStatus(t.getOrderNo(), 0);
  414. td.setId(i);
  415. tArrearsDunMapper.updateByPrimaryKeySelective(td);
  416. }
  417. orderNewService.addNewDunNoticAndSendEmail(tn,ob);
  418. ob.setStatus(1);
  419. ob.setStartTime(new Date());
  420. newOrderDunMapper.updateByPrimaryKeySelective(ob);
  421. }
  422. }
  423. }
  424. }
  425. private void checkSettlementAward(TOrderNew tn,TOrderTask task) {
  426. if(task.getTaskStatus()==TaskState.COMPLETE.getCode()&&tn.getTotalAmount().compareTo(tn.getSettlementAmount())==0) {
  427. List<TOrderTask> l = tOrderTaskMapper.getReceiverByOid(tn.getOrderNo());
  428. for (TOrderTask tOrderTask : l) {
  429. if(null != tOrderTask &&null != tOrderTask.getTaskReceiver()){
  430. TOrderBonus bonus = new TOrderBonus();
  431. bonus.setId(UUID.randomUUID().toString());
  432. bonus.setOrderNo(tn.getOrderNo());
  433. bonus.setGrantBy(tn.getFinanceId());
  434. bonus.setBonusSubject(BonusSubject.WK.getCode());//12
  435. bonus.setTaskId(tOrderTask.getId());//任务id
  436. bonus.setGrantTarget(tOrderTask.getTaskReceiver());
  437. bonus.setGrantType(1);
  438. int c = tOrderBonusMapper.checkByOnoAndSub(bonus);
  439. //不存在就设置
  440. if(c==0){
  441. bonus.setId(UUID.randomUUID().toString());
  442. tOrderBonusMapper.insertSelective(bonus);
  443. }
  444. }
  445. }
  446. }
  447. }
  448. private void meanwhileUpdateOrder(TOrderTask task) {
  449. // if (task.getMain()==1) {//是否是主要项目 更改为不管是不是主项目都会有奖金信息
  450. //更改订单项目状态
  451. TOrderNew tNew=new TOrderNew();
  452. tNew.setProjectStatus(task.getProjectStatus());
  453. tNew.setOrderNo(task.getOrderNo());
  454. tOrderNewMapper.updateByPrimaryKeySelective(tNew);
  455. if (task.getProjectStatus()==ProjectNewStage.YTJ.getCode()||task.getProjectStatus()==ProjectNewStage.LS.getCode()||
  456. task.getProjectStatus()==ProjectNewStage.GS.getCode()) {
  457. TOrderBonus tb=new TOrderBonus();
  458. TOrderNew t=tOrderNewMapper.selectByPrimaryKey(task.getOrderNo());
  459. tb.setId(UUID.randomUUID().toString());
  460. tb.setOrderNo(task.getOrderNo());
  461. if (task.getProjectStatus()==ProjectNewStage.YTJ.getCode()) {
  462. tb.setBonusSubject(21);//项目已提交
  463. addOrderLog(task.getOrderNo(),OrderLogProcess.XMWC.getCode(),null);
  464. }
  465. if (task.getProjectStatus()==ProjectNewStage.LS.getCode())tb.setBonusSubject(23);//项目立项
  466. if (task.getProjectStatus()==ProjectNewStage.GS.getCode())tb.setBonusSubject(24);//项目公示
  467. tb.setGrantType(1);//技术员
  468. //新增奖金之前检查这个奖金数据是否存在
  469. tb.setGrantTarget(task.getTaskReceiver());
  470. int c = tOrderBonusMapper.checkByOnoAndSub(tb);
  471. if(c==0){
  472. tb.setGrantBy(t.getFinanceId());
  473. tb.setTaskId(task.getId());
  474. tOrderBonusMapper.insertSelective(tb);
  475. }
  476. }
  477. }
  478. @Override
  479. public int addTaskHours(TTaskHours t) {
  480. TOrderTask tt=tOrderTaskMapper.selectByPrimaryKey(Integer.valueOf(t.getTaskId()));
  481. checkDeleteSign(tt.getOrderNo());
  482. t.setAid(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  483. t.setId(UUID.randomUUID().toString());
  484. t.setCreateTime(new Date());
  485. if(taskHoursCountMapper.selectByAidAndTid(TokenManager.getAdminId(),t.getTaskId())>0) {
  486. taskHoursCountMapper.updateByAidAndTid(TokenManager.getAdminId(),t.getTaskId(),t.getHours());
  487. }else {
  488. TaskHoursCount tc=new TaskHoursCount();
  489. tc.setAid(TokenManager.getAdminId());
  490. tc.setTid(Integer.valueOf(t.getTaskId()));
  491. tc.setHours(t.getHours());
  492. taskHoursCountMapper.insertSelective(tc);
  493. }
  494. return tTaskHoursMapper.insertSelective(t);
  495. }
  496. @SuppressWarnings("unchecked")
  497. @Override
  498. public Pagination<TOrderTaskListBo> taskHoursList(inuptTaskHoursListBo ib, Integer pageNo,
  499. Integer pageSize) {
  500. Map<String, Object> params = new HashMap<String, Object>();
  501. if(pageSize==null||pageSize<0)pageSize=10;
  502. if(pageNo==null||pageNo<0)pageNo=1;
  503. if (StringUtils.isNotBlank(ib.getName())) params.put("name", ib.getName());
  504. if (StringUtils.isNotBlank(ib.getOrderNo())) params.put("orderNo", ib.getOrderNo());
  505. if (StringUtils.isNotBlank(ib.getTaskId())) params.put("taskId", ib.getTaskId());
  506. if (StringUtils.isNotBlank(ib.getStarTime())) params.put("starTime", ib.getStarTime());
  507. if (StringUtils.isNotBlank(ib.getEndTime())) params.put("endTime", ib.getEndTime()+" 23:59:59");
  508. if(StringUtils.isNotBlank(ib.getContractNo()))params.put("contractNo", ib.getContractNo());
  509. if(StringUtils.isNotBlank(ib.getDepId()))params.put("depId", ib.getDepId());
  510. if(StringUtils.isNotBlank(ib.getCid()))params.put("cid", ib.getCid());
  511. if(null!=ib.getOutsource())params.put("outsource", ib.getOutsource());
  512. Integer i=null;
  513. if (TokenManager.hasRole(AFTConstants.FINANCE))i=1;
  514. if (TokenManager.hasRole(AFTConstants.FINANCE_MANAGER))i=2;
  515. if (TokenManager.hasRole(AFTConstants.FINANCE_ADMIN)||TokenManager.hasRole(AFTConstants.VICE_CEO)||
  516. TokenManager.hasRole(AFTConstants.SUPERADMIN)||TokenManager.hasRole(AFTConstants.CED)||
  517. TokenManager.hasRole(AFTConstants.APPROVAL_DECISION))i=3;
  518. if(TokenManager.getAdminId()!=null)params.put("aid", TokenManager.getAdminId());
  519. if(i!=null)params.put("shiroType", i);
  520. Pagination<TOrderTaskListBo> p = (Pagination<TOrderTaskListBo>)findPage("selectTaskHoursListByPage", "selectTaskHoursListCount", params, pageNo, pageSize);
  521. return p;
  522. }
  523. @SuppressWarnings("unchecked")
  524. @Override
  525. public Pagination<TOrderTaskListBo> selectTaskList(String name, String orderNo, String taskId, Integer taskStatus,
  526. String adminName, Integer specially,String depId , Integer pageNo, Integer pageSize) {
  527. Map<String, Object> params = new HashMap<String, Object>();
  528. if(pageSize==null||pageSize<0)pageSize=10;
  529. if(pageNo==null||pageNo<0)pageNo=1;
  530. params.put("aid", TokenManager.getAdminId()==null?"":TokenManager.getAdminId());
  531. if (StringUtils.isNotBlank(name)) params.put("name", name);
  532. if (StringUtils.isNotBlank(depId)) params.put("depId", depId);
  533. if (StringUtils.isNotBlank(orderNo)) params.put("orderNo", orderNo);
  534. if (StringUtils.isNotBlank(taskId)) params.put("taskId", taskId);
  535. if (StringUtils.isNotBlank(adminName)) params.put("adminName", adminName);
  536. if (null != taskStatus) params.put("taskStatus", taskStatus);
  537. Pagination<TOrderTaskListBo> p = (Pagination<TOrderTaskListBo>)findPage("selectTaskListByPage", "selectTaskListCount", params, pageNo, pageSize);
  538. return p;
  539. }
  540. @Override
  541. public List<TaskLogBo> TaskLogList(Integer id) {
  542. return taskLogMapper.selectTaskLogList(id);
  543. }
  544. @Override
  545. public int createTaskProgress(TaskProgressBo t) {
  546. TaskProgress tp=new TaskProgress();
  547. TOrderTask tt=tOrderTaskMapper.selectByPrimaryKey(t.getTaskId());
  548. int count =taskProgressMapper.AlreadyNuberCount(t.getTaskId());
  549. count +=t.getAlreadyNumber();
  550. if(tt.getCommodityQuantity()<count)throw new BusinessException(new Error( "数量不能大于总量!" ,"数量不能大于总量!"));
  551. tp.setAlreadyNumber(t.getAlreadyNumber());
  552. try {
  553. tp.setLicenceTime(DateUtils.StringToDate(t.getLicenceTimes(), AFTConstants.YYYYMMDD));
  554. } catch (ParseException e) {
  555. throw new BusinessException(new Error( "日期错误" ,"日期错误"));
  556. }
  557. tp.setTaskId(t.getTaskId());
  558. return taskProgressMapper.insertSelective(tp);
  559. }
  560. @Override
  561. public int delectTaskProgress(Integer id) {
  562. return taskProgressMapper.deleteByPrimaryKey(id);
  563. }
  564. @Override
  565. public List<TaskProgressBo> selectTaskProgress(Integer tid) {
  566. List<TaskProgressBo> l=taskProgressMapper.selectTaskProgress(tid);
  567. int notcount=0;
  568. for (TaskProgressBo t : l) {
  569. notcount+=t.getAlreadyNumber();
  570. t.setNotCount(t.getIngCount()-notcount);
  571. }
  572. return l;
  573. }
  574. @Override
  575. public List<TTaskHours> taskHoursDetailsList(String taskId) {
  576. String aid=TokenManager.getAdminId();
  577. return tTaskHoursMapper.taskHoursDetailsList(taskId,aid);
  578. }
  579. @Override
  580. public void exportMyTaskList(HttpServletResponse response,inuptTaskHoursListBo ib, Integer pageNo, Integer pageSize) throws IOException {
  581. OutputStream out = response.getOutputStream();
  582. try {
  583. if(pageSize==null)pageSize=999999;
  584. @SuppressWarnings("unchecked")
  585. List<TOrderTaskListBo> list=(List<TOrderTaskListBo>) taskHoursList(ib, pageNo, pageSize).getList();
  586. //合同编号 订单编号 客户名称 订单部门 订单负责人 项目类别 项目编号 项目名称 项目负责人 项目价格(万元) 数量(个) 任务状态 项目状态 工时 签单时间 派单时间 分配时间 完成时间
  587. String[] comment = {"合同编号","订单编号","客户名称","订单部门","订单负责人","项目类别","项目编号","项目名称","项目负责人","项目价格(万元)","数量(个)","任务状态","项目状态","是否外包","工时","签单日期","派单日期","分配时间","完成时间"};
  588. String fileName ="工时信息记录表" + new SimpleDateFormat("yyyy-MM-dd HH:mm").format(new Date()) + ".xls";
  589. //type 0 变更
  590. XSSFWorkbook wb =ExportExcelUtil.exportTemplateInfoS(comment,"工时信息");
  591. //根据列表编写文档
  592. XSSFSheet sheet =wb.getSheetAt(0);
  593. for (TOrderTaskListBo ob : (List<TOrderTaskListBo>)list) {
  594. //新增一行
  595. XSSFRow r = sheet.createRow(sheet.getLastRowNum()+1);
  596. for (int i = 0; i < comment.length; i++) {
  597. //当前列的只
  598. String o = "";
  599. switch (comment[i]) {
  600. // "合同编号","订单编号","客户名称","订单部门","订单负责人 ","项目类别","项目编号","项目名称","项目负责人","项目价格(万元)",
  601. // " 数量(个)","任务状态","项目状态","工时","签单日期","派单日期","分配时间","完成时间"
  602. case "合同编号": o = ob.getContractNo(); break;
  603. case "订单编号": o = ob.getOrderNo().toString(); break;
  604. case "客户名称": o = ob.getUserName(); break;
  605. case "订单部门": o = ob.getDepName(); break;
  606. case "订单负责人": o = ob.getSalesmanName(); break;
  607. case "项目类别": o =ob.getCname(); break;
  608. case "项目编号": o = ob.getId().toString(); break;
  609. case "项目名称": o = ob.getTaskName(); break;
  610. case "是否外包": o = ob.getOutsource()==1?"是":"否"; break;
  611. case "项目负责人": o = ob.getReceiverName(); break;
  612. case "项目价格(万元)": o = ob.getCommodityPrice().toString(); break;
  613. case "数量(个)": o = ob.getCommodityQuantity().toString(); break;
  614. case "任务状态": o = TaskState.getValueByCode(ob.getTaskStatus()); break;
  615. case "项目状态": o = ProjectNewStage.getValueByCode(ob.getProjectStatus()); break;
  616. case "工时": o = ob.getHours().toString(); break;
  617. case "分配时间": o = ob.getTaskDistributionTime(); break;
  618. case "完成时间": o = ob.getTaskEndTime(); break;
  619. case "签单日期": o = ob.getSignTime(); break;
  620. case "派单日期": o = ob.getCreteTime();break;
  621. default: o = ""; break;
  622. }
  623. XSSFCell c = r.createCell(i);
  624. c.setCellValue(o);
  625. }
  626. }
  627. //返回名称及参数
  628. response.addHeader("Content-Disposition", "attachment;filename=" + new String(fileName.getBytes(),"iso-8859-1"));
  629. response.setContentType("application/octet-stream;charset=utf-8");
  630. // 返回数据流
  631. wb.write(out);
  632. out.flush();
  633. out.close();
  634. } catch (Exception e) {
  635. throw new BusinessException(new Error("表格生成错误。"));
  636. }finally {
  637. out.flush();
  638. out.close();
  639. }
  640. }
  641. @Override
  642. public int pushSplitProject(Integer tid, String splitList) {
  643. String[] str=splitList.split(",");
  644. TOrderTask task=tOrderTaskMapper.selectByPrimaryKey(tid);
  645. checkDeleteSign(task.getOrderNo());
  646. TOrderTask usedTask=new TOrderTask();
  647. usedTask.setId(tid);
  648. usedTask.setSplitStatus(1);
  649. //计算拆分数量
  650. Integer x=0;
  651. for (String string : str) {
  652. x+=Integer.parseInt(string);
  653. }
  654. if (!task.getCommodityQuantity().equals(x)||str.length==1) {
  655. return -1;
  656. }
  657. tOrderTaskMapper.updateByPrimaryKeySelective(usedTask);
  658. int i=1;
  659. TOrderTask newTask=task;
  660. newTask.setCommodityPrice(new BigDecimal(0));
  661. newTask.setSplitAid(TokenManager.getAdminId());
  662. newTask.setSplitStatus(2);
  663. newTask.setSplitSuper(tid);
  664. newTask.setSplitTime(new Date());
  665. for (String string : str) {
  666. newTask.setId(null);
  667. newTask.setCommodityQuantity(Integer.parseInt(string));
  668. newTask.setSplitId(i);
  669. i++;
  670. tOrderTaskMapper.insertSelective(newTask);
  671. }
  672. return 1;
  673. }
  674. @Override
  675. public List<TOrderTaskListBo> splitProjectList(Integer tid) {
  676. return tOrderTaskMapper.splitProjectList(tid);
  677. }
  678. }