OrderNewServiceImpl.java 54 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397
  1. package com.goafanti.order.service.impl;
  2. import java.io.IOException;
  3. import java.io.OutputStream;
  4. import java.io.UnsupportedEncodingException;
  5. import java.math.BigDecimal;
  6. import java.text.ParseException;
  7. import java.text.SimpleDateFormat;
  8. import java.util.ArrayList;
  9. import java.util.Arrays;
  10. import java.util.Calendar;
  11. import java.util.Date;
  12. import java.util.HashMap;
  13. import java.util.List;
  14. import java.util.Map;
  15. import java.util.UUID;
  16. import javax.mail.MessagingException;
  17. import javax.servlet.http.HttpServletResponse;
  18. import com.goafanti.common.dao.*;
  19. import com.goafanti.common.model.*;
  20. import com.goafanti.order.bo.*;
  21. import com.goafanti.organization.bo.*;
  22. import com.goafanti.common.utils.StringUtils;
  23. import groovy.transform.Synchronized;
  24. import org.apache.poi.xssf.usermodel.XSSFCell;
  25. import org.apache.poi.xssf.usermodel.XSSFRow;
  26. import org.apache.poi.xssf.usermodel.XSSFSheet;
  27. import org.apache.poi.xssf.usermodel.XSSFWorkbook;
  28. import org.slf4j.Logger;
  29. import org.slf4j.LoggerFactory;
  30. import org.springframework.beans.factory.annotation.Autowired;
  31. import org.springframework.cache.annotation.Cacheable;
  32. import org.springframework.scheduling.annotation.EnableAsync;
  33. import org.springframework.stereotype.Service;
  34. import com.alibaba.fastjson.JSON;
  35. import com.goafanti.admin.bo.AdminListBo;
  36. import com.goafanti.common.bo.EmailBo;
  37. import com.goafanti.common.bo.Error;
  38. import com.goafanti.common.bo.OrderOperator;
  39. import com.goafanti.common.constant.AFTConstants;
  40. import com.goafanti.common.constant.ErrorConstants;
  41. import com.goafanti.common.enums.NoticeStatus;
  42. import com.goafanti.common.enums.OfficialPatentType;
  43. import com.goafanti.common.enums.OrderLogProcess;
  44. import com.goafanti.common.error.BusinessException;
  45. import com.goafanti.common.utils.AsyncUtils;
  46. import com.goafanti.common.utils.ExportExcelUtil;
  47. import com.goafanti.common.utils.LoggerUtils;
  48. import com.goafanti.common.utils.SendEmailUtil;
  49. import com.goafanti.core.mybatis.BaseMybatisDao;
  50. import com.goafanti.core.mybatis.JDBCIdGenerator;
  51. import com.goafanti.core.mybatis.page.Pagination;
  52. import com.goafanti.core.shiro.token.TokenManager;
  53. import com.goafanti.customer.bo.LockingReleaseBo;
  54. import com.goafanti.order.enums.ActiveState;
  55. import com.goafanti.order.enums.ApprovalNewState;
  56. import com.goafanti.order.enums.LiquidationNewState;
  57. import com.goafanti.order.enums.NewOrderDunType;
  58. import com.goafanti.order.enums.NewProjectStatus;
  59. import com.goafanti.order.enums.OrderDunSubject;
  60. import com.goafanti.order.enums.OrderNewState;
  61. import com.goafanti.order.enums.ProcessStatus;
  62. import com.goafanti.order.enums.TaskState;
  63. import com.goafanti.order.enums.refundState;
  64. import com.goafanti.order.service.OrderNewService;
  65. import com.goafanti.order.service.OrderService;
  66. import com.goafanti.patent.service.PatentNewService;
  67. import org.springframework.transaction.annotation.Transactional;
  68. @Service
  69. @EnableAsync
  70. public class OrderNewServiceImpl extends BaseMybatisDao<TOrderNewMapper> implements OrderNewService {
  71. @Autowired
  72. private TOrderNewMapper tOrderNewMapper;
  73. @Autowired
  74. private TOrderTaskMapper tOrderTaskMapper;
  75. @Autowired
  76. private NewOrderDunMapper newOrderDunMapper;
  77. @Autowired
  78. private TOrderDunMapper tOrderDunMapper;
  79. @Autowired
  80. private TDunLogMapper tDunLogMapper;
  81. @Autowired
  82. private TOrderMidMapper tOrderMidMapper;
  83. @Autowired
  84. private TOrderRefundMapper tOrderRefundMapper;
  85. @Autowired
  86. private TOrderBackMapper tOrderBackMapper;
  87. @Autowired
  88. private OrganizationContactBookMapper organizationContactBookMapper;
  89. @Autowired
  90. private OrganizationManagementMapper organizationManagementMapper ;
  91. @Autowired
  92. private JDBCIdGenerator idGenerator;
  93. @Autowired
  94. private AdminMapper adminMapper;
  95. @Autowired
  96. private TOrderLogMapper tOrderLogMapper;
  97. @Autowired
  98. private OrderService orderService;
  99. @Autowired
  100. private IdleContractNoMapper idleContractNoMapper;
  101. @Autowired
  102. private TOrderOutsourceMapper tOrderOutsourceMapper;
  103. @Autowired
  104. private UserLockReleaseMapper userLockReleaseMapper;
  105. @Autowired
  106. private TArrearsDunMapper tArrearsDunMapper;
  107. @Autowired
  108. private TOrderExtendMapper tOrderExtendMapper;
  109. @Autowired
  110. private UserMapper userMapper;
  111. @Autowired
  112. private OutsourceLogMapper outsourceLogMapper;
  113. @Autowired
  114. private PaymentNodeMapper paymentNodeMapper;
  115. @Autowired
  116. private ThirdPartyCompanyMapper thirdPartyCompanyMapper;
  117. @Autowired
  118. private TTaskMidMapper tTaskMidMapper;
  119. @Autowired
  120. private UserMidMapper userMidMapper;
  121. @Autowired
  122. private ProjcetCheckLogMapper projcetCheckLogMapper;
  123. @Autowired
  124. private OfficialFeePriceMapper officialFeePriceMapper;
  125. @Autowired
  126. private PatentNewService patentNewService;
  127. @Autowired
  128. private AsyncUtils asyncUtils;
  129. @Autowired
  130. private PushOrderService pushOrderService;
  131. @Autowired
  132. private BusinessProjectMapper businessProjectMapper;
  133. Logger logger = LoggerFactory.getLogger(OrderNewServiceImpl.class);
  134. @Override
  135. public int createServiceOrder(String uid, Integer orderType) {
  136. BigDecimal initial = new BigDecimal(0);
  137. TOrderNew t=new TOrderNew();
  138. Date date = new Date();
  139. String orderNo=idGenerator.generateId().toString();
  140. t.setOrderNo(orderNo);
  141. t.setOrderType(orderType);
  142. t.setOrderStatus(OrderNewState.DQD.getCode());
  143. t.setFirstAmount(initial);
  144. t.setTotalAmount(initial);
  145. t.setSettlementAmount(initial);
  146. t.setLiquidationStatus(LiquidationNewState.WAIT_PAY_FIRST_BALANCE.getCode());
  147. t.setProcessStatus(ProcessStatus.YPYXY.getCode());
  148. t.setProjectStatus(NewProjectStatus.WQD.getCode());
  149. t.setApproval(ApprovalNewState.FTP.getCode());
  150. t.setDeleteSign(0);//0-正常,1-作废,2-锁定
  151. t.setSalesmanId(TokenManager.getAdminId());
  152. t.setCreater(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  153. t.setOrderDep(adminMapper.selectByPrimaryKey(TokenManager.getAdminId()).getDepartmentId());
  154. t.setCreateTime(date);
  155. t.setUpdateTime(date);
  156. t.setBuyerId(uid);
  157. User u=userMapper.selectByPrimaryKey(uid);
  158. if(u.getShareType()!=null&&u.getShareType()==2){
  159. t.setNewUser(1);
  160. }else {
  161. t.setNewUser(0);
  162. }
  163. TOrderExtend te=new TOrderExtend();
  164. te.setOrderNo(orderNo);
  165. te.setServiceStatus(0);
  166. tOrderExtendMapper.insertSelective(te);
  167. return tOrderNewMapper.insertSelective(t);
  168. }
  169. @Override
  170. public int addOrderTask(TOrderTask t) {
  171. TOrderNew order=tOrderNewMapper.selectByPrimaryKey(t.getOrderNo());
  172. checkOrder(order,t);
  173. t.setTaskStatus(TaskState.WFP.getCode());
  174. t.setProjectStatus(NewProjectStatus.WQD.getCode());
  175. if(t.getCommodityPrice()!=null)order.setTotalAmount(order.getTotalAmount());
  176. String str=tOrderTaskMapper.selectByidGetCname(t.getCommodityId());
  177. t.setCname(str);
  178. tOrderTaskMapper.insertSelectiveGetId(t);
  179. TTaskMid tm=new TTaskMid();
  180. tm.setTid(t.getId());
  181. //判断这个项目是不是高新复审
  182. int highNewRetrial=0;
  183. BusinessProject b=businessProjectMapper.selectByPrimaryKey(t.getCommodityId());
  184. if (b.getType()==5){
  185. int i=tOrderTaskMapper.getHighNewRetrial(order.getOrderNo());
  186. if (i>0) highNewRetrial =1;
  187. }
  188. tm.setHighNewRetrial(highNewRetrial);
  189. tTaskMidMapper.insertSelective(tm);
  190. return 1;
  191. }
  192. public void checkOrder(TOrderNew order,TOrderTask t){
  193. if(order == null)
  194. throw new BusinessException(new Error(ErrorConstants.ORDER_NOT_EXIST, "" ,""));
  195. if(order.getDeleteSign().equals(ActiveState.ABOLISH.getCode()) )
  196. throw new BusinessException(new Error(ErrorConstants.ORDER_ALREADY_FREEZE, order.getOrderNo(),""));
  197. if(order.getDeleteSign().equals( ActiveState.LOCKING.getCode()))
  198. throw new BusinessException(new Error(ErrorConstants.ORDER_ALREADY_REVOKE, order.getOrderNo(),""));
  199. List<LockingReleaseBo> list=userLockReleaseMapper.checkTask(order.getBuyerId(),t.getCommodityId());
  200. if (list.size()>0) {
  201. for (LockingReleaseBo lockingReleaseBo : list) {
  202. if (!lockingReleaseBo.getAid().equals(order.getSalesmanId())) {
  203. throw new BusinessException(new Error( "该业务已经被其他人锁定","该业务已经被其他人锁定"));
  204. }
  205. }
  206. }
  207. }
  208. @Override
  209. public int updateOrderTask(TOrderTask t) {
  210. TOrderTask use=tOrderTaskMapper.selectByPrimaryKey(t.getId());
  211. boolean flag=false;
  212. if(use.getCheckStatus()==1) {
  213. t.setCheckStatus(2);
  214. ProjcetCheckLog log=new ProjcetCheckLog();
  215. log.setTid(t.getId());
  216. log.setAid(TokenManager.getAdminId());
  217. StringBuffer str=new StringBuffer();
  218. if ((t.getOfficialCost()==null&&t.getCostReduction()==null&&t.getPatentType()==null)||
  219. (t.getOfficialCost()==use.getOfficialCost()&&t.getPatentType()==use.getPatentType()&&t.getCostReduction()==use.getCostReduction())) {
  220. str.append("未做任何修改。");
  221. }else {
  222. str.append("修改了:");
  223. if (t.getPatentType()!=null&&use.getPatentType()!=t.getPatentType()) {
  224. str.append("官费类型");
  225. }
  226. if (t.getOfficialCost()!=null&&use.getOfficialCost()!=t.getOfficialCost()) {
  227. str.append(",").append("有无官费");
  228. flag=true;
  229. }
  230. if (t.getCostReduction()!=null&&use.getCostReduction()!=t.getCostReduction()) {
  231. str.append(",").append("有无费减");
  232. flag=true;
  233. }
  234. str.append("。");
  235. }
  236. log.setRemarks(str.toString());
  237. log.setStatus(1);
  238. OrderOperator oo=tOrderTaskMapper.selectAidByParam(t.getId());
  239. if (oo!=null&&oo.getOrderNo()!=null&&oo.getSalesmanId()!=null) {
  240. Notice n =new Notice();
  241. String str2=String.format("[%s]完成了专利核对,客户名称[%s]订单编号[%s]项目编号[%s]。", oo.getSalesmanName(),oo.getBuyerName(),oo.getOrderNo(),oo.getTid());
  242. n.setId(UUID.randomUUID().toString());
  243. n.setAid(oo.getTechId());
  244. n.setNoticeType(NoticeStatus.ITEM_CHECK_END.getCode());
  245. n.setContent(str2);
  246. n.setReaded(0);//未读
  247. asyncUtils.addNoticAndEmail(n);
  248. }
  249. projcetCheckLogMapper.insertSelective(log);
  250. }
  251. int i=tOrderTaskMapper.updateByPrimaryKeySelective(t);
  252. if (flag) {
  253. patentNewService.updateCostReduction(t.getId());
  254. }
  255. return i;
  256. }
  257. @Override
  258. public int delectOrderTask(Integer id) {
  259. //连带催款一起删除
  260. newOrderDunMapper.deleteByTid(id);
  261. return tOrderTaskMapper.deleteByPrimaryKey(id);
  262. }
  263. @Override
  264. public List<TOrderTaskBo> selectOrderTask(String orderNo) {
  265. List<TOrderTaskBo> list=tOrderTaskMapper.selectOrderTask(orderNo);
  266. for (TOrderTaskBo t : list) {
  267. if (TokenManager.hasRole(AFTConstants.SALESMAN)) {
  268. t.setOutsourceName("****");
  269. t.setOutsourcePrice(new BigDecimal(0));
  270. t.setDeclareUser("****");
  271. t.setDeclarePwd("****");
  272. t.setCertificateNumber("****");
  273. }
  274. if (TokenManager.hasRole(AFTConstants.TECH)) {
  275. //设置隐藏金额
  276. t.setCommodityPrice(new BigDecimal(-1));
  277. }
  278. if(t.getPatentType()!=null)t.setPatentTypeName(OfficialPatentType.getValueByCode(t.getPatentType()));
  279. }
  280. return list;
  281. }
  282. @Override
  283. public int updateServiceOrder(TOrderNewWithBLOBs t, Integer isSubmit) {
  284. TOrderNew t2=tOrderNewMapper.selectByPrimaryKey(t.getOrderNo());
  285. //判断手机号码是否存在
  286. if (StringUtils.isNotBlank(t.getContacts())&&StringUtils.isNotBlank(t.getContactMobile())&&
  287. organizationContactBookMapper.checkContacts(t2.getBuyerId(), t2.getContactMobile(),TokenManager.getAdminId()==null?"1":TokenManager.getAdminId() )>0) {
  288. OrganizationContactBook contactBook=new OrganizationContactBook();
  289. contactBook.setId(UUID.randomUUID().toString());
  290. contactBook.setAid(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  291. contactBook.setUid(t2.getBuyerId());
  292. contactBook.setName(t.getContacts());
  293. contactBook.setMobile(t.getContactMobile());
  294. organizationContactBookMapper.insertSelective(contactBook);
  295. }
  296. if (StringUtils.isBlank(t.getOrderDep())) {
  297. t.setOrderDep(adminMapper.selectByPrimaryKey(TokenManager.getAdminId()).getDepartmentId());
  298. }
  299. if (isSubmit==1) {//订单提交
  300. if(t2.getProcessStatus()<ProcessStatus.YPYXGLY.getCode()) {
  301. t.setOrderStatus(OrderNewState.QDDS.getCode());
  302. t.setProcessStatus(ProcessStatus.YPYXGLY.getCode());
  303. }else {
  304. t.setOrderStatus(OrderNewState.QDSHTG.getCode());
  305. }
  306. if (t2.getApproval()==ApprovalNewState.BH.getCode()){
  307. t.setApproval(ApprovalNewState.DSH.getCode());
  308. }
  309. //生成流转
  310. TOrderLog tl=new TOrderLog();
  311. tl.setOrderNo(t.getOrderNo());
  312. tl.setProcess(OrderLogProcess.TJ.getCode());
  313. tl.setAid(TokenManager.getAdminId());
  314. addOrderLog(tl,null);
  315. if (StringUtils.isBlank(t2.getContractNo())) {
  316. //没有合同编号则生成
  317. createContractNo(t);
  318. }else if(!t.getOrderDep().equals(t2.getOrderDep())) {
  319. contractNoReplace(t.getOrderNo(), t2.getContractNo(),t2.getOrderDep());
  320. createContractNo(t);
  321. }
  322. //修改订单中间表信息
  323. t.setBuyerId(t2.getBuyerId());
  324. updateOrderMid(t);
  325. List<String> aids = new ArrayList<>();
  326. Integer type;
  327. AdminListBo a = adminMapper.getDeptNameByAid(TokenManager.getAdminId());
  328. aids.addAll(adminMapper.listNameByDepAndName(a.getDepartmentId(), "营销管理员"));
  329. type=NoticeStatus.ORDER_START.getCode();
  330. //如果订单金额超过10W标记为大客户
  331. if(t.getTotalAmount().compareTo(new BigDecimal("10"))>=0) {
  332. UserMid um=new UserMid();
  333. um.setUid(t.getBuyerId());
  334. um.setAid(t2.getSalesmanId());
  335. um.setBigCustomer(1);
  336. int i=userMidMapper.updateByUid(um);
  337. if (i==0) {
  338. um.setAid(t2.getSalesmanId());
  339. userMidMapper.insertSelective(um);
  340. }
  341. }
  342. TOrderNewBo order = tOrderNewMapper.getSaleIdByOno(t2.getOrderNo());
  343. pushGeneralSendNoticeAndEmail(aids, type,order, TokenManager.getAdminId(),t.getApproval());
  344. }
  345. if (t2.getApproval()==ApprovalNewState.BH.getCode()||
  346. t2.getOrderStatus()==OrderNewState.QDSHJJ.getCode()||
  347. t2.getOrderStatus()==OrderNewState.YBH.getCode()) {
  348. t.setCreateTime(new Date());
  349. tOrderBackMapper.updateByOrderNoAndBackStatus(t.getOrderNo());
  350. }
  351. // 0 相等
  352. // -1 小于
  353. // 1 大于
  354. //liquidation_status 清算状态 0-首付待付请,1-尾款待付清,2-已付请,3-部分退款,4-全部退款
  355. //settlement_amount 已付 total_amount 总价格 first_amount首付
  356. if(t2.getLiquidationStatus()!=LiquidationNewState.FULL_REFUND.getCode()) {
  357. if(t2.getSettlementAmount().compareTo(t.getTotalAmount()) == 0){//如果已付等于总价
  358. t.setLiquidationStatus(LiquidationNewState.ALREADY_PAY.getCode());
  359. }else if(t2.getSettlementAmount().compareTo(t.getFirstAmount()) >= 0){//如果大于等于首付
  360. t.setLiquidationStatus(LiquidationNewState.WAIT_PAY_LAST_BALANCE.getCode());
  361. } else if(t2.getSettlementAmount().compareTo(t.getFirstAmount()) < 0){//如果小于首付
  362. t.setLiquidationStatus(LiquidationNewState.WAIT_PAY_FIRST_BALANCE.getCode());
  363. }
  364. }
  365. return tOrderNewMapper.updateByPrimaryKeySelective(t);
  366. }
  367. private void updateOrderMid(TOrderNew t) {
  368. TOrderMid tm=tOrderMidMapper.selectByOrderNo(t.getOrderNo());
  369. Admin admin=adminMapper.selectFinanceAdminByOrderDep(t.getOrderDep());
  370. Admin a=adminMapper.selectAllByid(TokenManager.getAdminId());
  371. User u=userMapper.selectByPrimaryKey(t.getBuyerId());
  372. if (tm==null) tm=new TOrderMid();
  373. tm.setOrderNo(t.getOrderNo());
  374. if (u!=null&&u.getNickname()!=null) {
  375. tm.setBuyerName(u.getNickname());
  376. }
  377. if (admin!=null&&admin.getName()!=null) {
  378. tm.setFinanceId(admin.getId());
  379. tm.setFinanceName(admin.getName());
  380. }
  381. if(a.getId()!=null&&a.getName()!=null) {
  382. tm.setSalesmanId(a.getId());
  383. tm.setSalesmanName(a.getName());
  384. }
  385. tm.setDepName(tOrderMidMapper.selectDepNameByDepid(t.getOrderDep()));
  386. if (tm.getId()!=null) {
  387. tOrderMidMapper.updateByPrimaryKeySelective(tm);
  388. }else {
  389. tOrderMidMapper.insertSelective(tm);
  390. }
  391. }
  392. /**
  393. * 新建合同编号,优先获取闲置合同编号,否则按年份生成编号
  394. */
  395. private void createContractNo(TOrderNew t) {
  396. //根据订单部门或许合同编号前缀
  397. OrganizationManagement dep=organizationManagementMapper.selectByPrimaryKey(t.getOrderDep());
  398. //获取日期年份
  399. Calendar c=Calendar.getInstance();
  400. int y=c.get(Calendar.YEAR);
  401. if (dep==null||StringUtils.isBlank(dep.getAbbreviation())) {
  402. throw new BusinessException(new Error( "该部门缩写不存在","该部门缩写不存在"));
  403. }
  404. IdleContractNo i=idleContractNoMapper.selectByAbbreviation(dep.getAbbreviation(),y);
  405. if (i!=null&&i.getContractNo()!=null) {
  406. t.setContractNo(i.getContractNo());
  407. idleContractNoMapper.deleteByPrimaryKey(i.getId());
  408. }else {
  409. //根据前缀查询最大编号
  410. String max=organizationManagementMapper.getMaxAbbreviation(dep.getAbbreviation()+"-");
  411. String sno=null;
  412. if (StringUtils.isBlank(max)||max.length()<13) {
  413. String cn=""+dep.getAbbreviation()+"-"+y+"0001";
  414. cn=iterationNo(cn,dep.getAbbreviation(),y,1);
  415. t.setContractNo(cn);
  416. }else {
  417. int ty=Integer.parseInt(max.substring(max.indexOf("-")+1, max.length()-4));
  418. int no=Integer.parseInt(max.substring(max.length()-4, max.length()));
  419. //得出字符串
  420. sno = countNo(dep.getAbbreviation(), sno, ty, no);
  421. //迭代得出最后编码
  422. sno=iterationNo(sno,dep.getAbbreviation(),ty,no);
  423. //年份小于等于则获取最大值加1,大于则获取最新年份
  424. if (y<=ty) {
  425. t.setContractNo(sno);
  426. }else {
  427. t.setContractNo(""+dep.getAbbreviation()+"-"+y+"0001");
  428. }
  429. }
  430. }
  431. }
  432. private String iterationNo(String sno ,Object mp, int ty, int no) {
  433. if (tOrderNewMapper.checkContractNo(sno)>0) {
  434. int i=Integer.parseInt(sno.substring(sno.indexOf("-")+5, sno.length()));
  435. sno=countNo(mp, sno, ty, i);
  436. sno=iterationNo(sno,mp,ty,i);
  437. }
  438. return sno;
  439. }
  440. private String countNo(Object object, String sno, int ty, int no) {
  441. no++;
  442. if (no>0&&no<10) {
  443. sno=object+"-"+ty+"000"+no;
  444. }else if (no>9&&no<100) {
  445. sno=object+"-"+ty+"00"+no;
  446. } else if (no>99&&no<1000) {
  447. sno=object+"-"+ty+"0"+no;
  448. } else if(no>1000){
  449. sno=object+"-"+ty+no;
  450. }
  451. return sno;
  452. }
  453. public void addOrderLog(TOrderLog tl, String reason) {
  454. tl.setAid(TokenManager.getAdminId());
  455. if(reason!=null)tl.setRemarks(reason);
  456. tOrderLogMapper.insertSelective(tl);
  457. }
  458. @Override
  459. public TOrderNewBo getOrderNewDetail(String orderNo) {
  460. TOrderNewBo tOrder= tOrderNewMapper.getOrderNewDetail(orderNo);
  461. String url=pushOrderService.processStatusConstant(tOrder.getContractPictureUrl(),tOrder.getSalesmanId(),tOrder.getProcessStatus());
  462. tOrder.setContractPictureUrl(url);
  463. return tOrder;
  464. }
  465. @Override
  466. public int createOrderDun(String orderDun,String orderNo) {
  467. List<TOrderDun> l= JSON.parseArray(orderDun, TOrderDun.class);
  468. List<TOrderDun> l2=tOrderDunMapper.selectByOrderNoDunSubject(orderNo);
  469. if (l!=null&&!l.isEmpty()) {
  470. for (TOrderDun t : l) {
  471. if (t.getId()==null||t.getId().equals("")) {//Id为空新增
  472. if (tOrderDunMapper.checkOrderDun(t.getDunSubject(),orderNo)>0) {
  473. throw new BusinessException(new Error( "该截点已经存在","该截点已经存在"));
  474. }
  475. t.setId(UUID.randomUUID().toString());
  476. t.setDunBy(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  477. t.setDunStatus(0);//未启动
  478. tOrderDunMapper.insertSelective(t);
  479. }else {
  480. tOrderDunMapper.updateByPrimaryKeySelective(t);
  481. }
  482. }
  483. }
  484. boolean flag=true;
  485. for (TOrderDun t2 : l2) {
  486. if (l.isEmpty()) {
  487. tOrderDunMapper.deleteByPrimaryKey(t2.getId());
  488. }else {
  489. for (TOrderDun t : l) {
  490. if (t2.getId().equals(t.getId())) {//查询集合与返回集合比较查出删除项
  491. flag=false;
  492. }
  493. }
  494. if (t2.getId()!=null&&flag) {
  495. tOrderDunMapper.deleteByPrimaryKey(t2.getId());
  496. }
  497. flag=true;
  498. }
  499. }
  500. return 1;
  501. }
  502. @SuppressWarnings("unchecked")
  503. @Override
  504. public Pagination<TOrderNewBo> orderNewList(String aid,String name, String orderNo, String starTime, String endTime,Integer specially,Integer approval,
  505. Integer distribution,String depId,String contractNo,Integer outsource,Integer liquidationStatus, Integer amountStatus,
  506. String contractStart, String contractEnd,String uid, Integer pageNo, Integer pageSize) {
  507. Map<String, Object> params = new HashMap<String, Object>();
  508. if(pageSize==null||pageSize<0)pageSize=10;
  509. if(pageNo==null||pageNo<0)pageNo=1;
  510. if (specially!=null&&(specially==0||specially==1||specially==2||specially==4||specially==5||specially==7)) {
  511. //0 个人 1 营销员管理 2 驳回 3 特批 4 咨询师管理 5部门订单查询
  512. if (specially!=3&&specially!=4) {
  513. if (aid ==null){
  514. params.put("aid", TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  515. }else{
  516. params.put("aid", aid);
  517. }
  518. }
  519. //(咨询师管理列表 0 未分配 1部分 2全部)
  520. if(specially==4) params.put("distribution",distribution);
  521. // 计算出所有本部门及所属部门的ID
  522. if(specially==1||specially==5) params.put("deps", orderService.selectMyDeps());
  523. }else if(specially==8){
  524. if (StringUtils.isNotBlank(uid)) params.put("uid", uid);
  525. }else if (specially==9){
  526. if (StringUtils.isNotBlank(aid)) params.put("aid", aid);
  527. }
  528. params.put("specially",specially);
  529. if (StringUtils.isNotBlank(name)) params.put("name", name);
  530. if (StringUtils.isNotBlank(depId)) params.put("depId", depId);
  531. if (StringUtils.isNotBlank(contractNo)) params.put("contractNo", contractNo);
  532. if (null!=liquidationStatus) params.put("liquidationStatus", liquidationStatus);
  533. if (null !=approval)params.put("approval", approval);
  534. if(null != amountStatus) params.put("amountStatus", amountStatus);
  535. if (StringUtils.isNotBlank(orderNo)) params.put("orderNo", orderNo);
  536. if (StringUtils.isNotBlank(starTime)) params.put("starTime", starTime);
  537. if (StringUtils.isNotBlank(endTime)) params.put("endTime", endTime+" 23:59:59");
  538. if (StringUtils.isNotBlank(contractStart)) params.put("contractStart", contractStart);
  539. if (StringUtils.isNotBlank(contractEnd)) params.put("contractEnd", contractEnd+" 23:59:59");
  540. params.put("outsource", outsource);
  541. Pagination<TOrderNewBo> p = (Pagination<TOrderNewBo>)findPage("selectOrderNewListByPage", "selectOrderNewListCount", params, pageNo, pageSize);
  542. return p;
  543. }
  544. @Override
  545. public int updateOrderNew(String orderNo, Integer orderStatus,String reason,Integer outsource, TOrderOutsource o) {
  546. TOrderNew t= new TOrderNew();
  547. TOrderNew t2= checkDeleteSign(orderNo);
  548. t.setOrderNo(orderNo);
  549. List<String> aids = new ArrayList<>();
  550. Integer type=null;
  551. TOrderLog tl=new TOrderLog();
  552. tl.setAid(TokenManager.getAdminId());
  553. if (orderStatus==OrderNewState.QDSHTG.getCode()) {
  554. t.setOutsource(outsource);
  555. //外包单给外包审核员 否则给财务专员
  556. if(outsource==0) {
  557. t.setProcessStatus(ProcessStatus.YPCWZY.getCode());
  558. //如果是转的暂时不删除外包信息
  559. aids.add(organizationManagementMapper.selectByPrimaryKey(t2.getOrderDep()).getFinanceId());
  560. } else if(outsource==1) {
  561. for (Admin admin : adminMapper.getAdminRoleList("外包审核员")) {
  562. aids.add(admin.getId());
  563. }
  564. t.setProcessStatus(ProcessStatus.YPWBSH.getCode());
  565. tl.setOrderNo(orderNo);
  566. tl.setProcess(OrderLogProcess.FQWB.getCode());
  567. addOrderLog(tl,reason);
  568. }
  569. type=NoticeStatus.ORDER_YES.getCode();
  570. tl.setOrderNo(orderNo);
  571. tl.setProcess(OrderLogProcess.SH.getCode());
  572. //增加日志
  573. addOrderLog(tl,reason);
  574. //非特批增加催款信息
  575. //外包
  576. if(outsource==1) {
  577. o.setRefundStatus(0);
  578. if(o.getId()==null) {
  579. o.setCreateTime(new Date());
  580. tOrderOutsourceMapper.insertSelective(o);
  581. }else {
  582. tOrderOutsourceMapper.updateByPrimaryKeySelective(o);
  583. }
  584. //修改项目为外包项目
  585. tOrderTaskMapper.updateByOutsourceToOrderNo(orderNo,1);
  586. }
  587. // pushOrderDun(t2);
  588. }else if (orderStatus==OrderNewState.QDSHJJ.getCode()) {//如果不通过新增驳回
  589. if (outsource==0) {//非外包
  590. t.setProcessStatus(ProcessStatus.YPYXY.getCode());
  591. addBackOrder(orderNo, reason);
  592. }
  593. aids.add(t2.getSalesmanId());
  594. type=NoticeStatus.ORDER_NO.getCode();
  595. }
  596. t.setOrderStatus(orderStatus);
  597. tOrderNewMapper.updateByPrimaryKeySelective(t);
  598. if (aids.isEmpty()) {
  599. throw new BusinessException(new Error( "邮件发送失败,对方设置邮箱错误","邮件发送失败,对方设置邮箱错误"));
  600. }
  601. TOrderNewBo order = tOrderNewMapper.getSaleIdByOno(t2.getOrderNo());
  602. pushGeneralSendNoticeAndEmail(aids, type,order, TokenManager.getAdminId(),t2.getApproval());
  603. return 1;
  604. }
  605. /**
  606. * 订单分配触发
  607. * @param orderNo
  608. */
  609. public void pushOrderDun(String orderNo) {
  610. TOrderNew b=tOrderNewMapper.selectByPrimaryKey(orderNo);
  611. if(b.getApproval()==0){
  612. Date date = new Date();
  613. List<OutNewOrderDunBo> list=newOrderDunMapper.selectListNewOrderDun(orderNo,null,0);
  614. for (OutNewOrderDunBo o : list) {
  615. if (o.getDunType()==1) {
  616. o.setStatus(1);
  617. o.setStartTime(date);
  618. newOrderDunMapper.updateByPrimaryKeySelective(o);
  619. //催款统计算
  620. TOrderMid tm = pushOrderMidDun(orderNo, b.getSettlementAmount(), date, o);
  621. TArrearsDun t=new TArrearsDun();
  622. t.setOrderArrears(tm.getOrderArrears());
  623. t.setOrderReceivables(tm.getOrderReceivables());
  624. if (tArrearsDunMapper.checkOrderNo(orderNo,null)<1) {
  625. t.setOrderNo(orderNo);
  626. tArrearsDunMapper.insertSelective(t);
  627. }else if(tArrearsDunMapper.checkOrderNo(orderNo,0)>0){
  628. Integer i=tArrearsDunMapper.selectByStatus(orderNo, 0);
  629. t.setId(i);
  630. tArrearsDunMapper.updateByPrimaryKeySelective(t);
  631. }
  632. addNewDunNoticAndSendEmail(orderNo,o);
  633. }
  634. }
  635. }
  636. }
  637. /**
  638. * NewProjectStatus.YXZ.getCode()
  639. * @param orderNo 订单编号
  640. * @param settlementAmount 已收金额
  641. * @param date 日期
  642. * @param o 订单催款类实对线
  643. * @return
  644. */
  645. @Synchronized
  646. public TOrderMid pushOrderMidDun(String orderNo, BigDecimal settlementAmount, Date date, OutNewOrderDunBo o) {
  647. TOrderMid tm=tOrderMidMapper.selectByOrderNo(orderNo);
  648. tm.setOrderReceivables(tm.getOrderReceivables().add(o.getMoney()));
  649. BigDecimal sum=tm.getOrderReceivables().subtract(settlementAmount);
  650. //如果金额大于欠款修改欠款为0
  651. if (sum.compareTo(new BigDecimal(0))<0)sum=new BigDecimal(0);
  652. tm.setOrderArrears(sum);
  653. if (tm.getDunStartTime()==null)tm.setDunStartTime(date);
  654. tOrderMidMapper.updateByPrimaryKeySelective(tm);
  655. return tm;
  656. }
  657. public void addNewDunNoticAndSendEmail(String orderNo, OutNewOrderDunBo o) {
  658. AdminListBo a = adminMapper.getDeptNameByAid(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  659. TOrderNewBo b = tOrderNewMapper.getSaleIdByOno(orderNo);
  660. addNotic(NoticeStatus.ORDER_DUN.getCode(),a, b);
  661. try {
  662. NewDunsendEmail(orderNo,o.getId(), a, b);
  663. } catch (UnsupportedEncodingException | MessagingException e) {
  664. throw new BusinessException(new Error("邮件发送错误。"));
  665. }
  666. }
  667. public void addTimingTaskNewDunNoticAndSendEmail(TOrderNew t2, OutNewOrderDunBo o) {
  668. AdminListBo a = adminMapper.getDeptNameByAid("1");
  669. TOrderNewBo b = tOrderNewMapper.getSaleIdByOno(t2.getOrderNo());
  670. addNotic(NoticeStatus.ORDER_DUN.getCode(),a, b);
  671. try {
  672. NewDunsendEmail(t2.getOrderNo(),o.getId(), a, b);
  673. } catch (UnsupportedEncodingException | MessagingException e) {
  674. throw new BusinessException(new Error("邮件发送错误。"));
  675. }
  676. }
  677. public void NewDunsendEmail(String orderNo,Integer dunId,AdminListBo a,TOrderNewBo b) throws UnsupportedEncodingException, MessagingException{
  678. NewOrderDun ob=newOrderDunMapper.selectByPrimaryKey(dunId);
  679. AdminListBo a2 = adminMapper.getDeptNameByAid(b.getSalesmanId());
  680. String dunTypeName="";
  681. if(ob.getDunType()!=null&&ob.getProjectType()!=null&&ob.getDunType()!=0) {
  682. dunTypeName= NewOrderDunType.getValueByCode(Integer.valueOf(""+ob.getProjectType()+ob.getDunType()));
  683. }else if(ob.getDunType()!=null&&ob.getProjectType()!=null&&ob.getDunType()==0){
  684. dunTypeName= NewOrderDunType.getValueByCode(Integer.valueOf(""+ob.getProjectType()+ob.getDunType()))+ob.getCustomizeName();
  685. }
  686. //发送驳回邮件
  687. if(SendEmailUtil.isEmail(b.getEmail())) {
  688. EmailBo bo = new EmailBo("催收通知", b.getEmail(), a.getDepartmentName(), a.getName(),
  689. "", orderNo,b.getContractNo(),new SimpleDateFormat("yyyy-MM-dd").format(ob.getCreateTime()),dunTypeName,a2.getName(),b.getUserName(),1,0);
  690. if(StringUtils.isNotBlank(b.getEmail())) {
  691. asyncUtils.patentSend(bo);
  692. }
  693. }
  694. }
  695. private void addBackOrder(String orderNo, String reason) {
  696. TOrderBack ob=new TOrderBack();
  697. TOrderNew tOrder= tOrderNewMapper.selectByPrimaryKey(orderNo);
  698. ob.setCreateTime(new Date());
  699. ob.setOrderNo(orderNo);
  700. ob.setReason(reason);
  701. ob.setBackStatus(0);//待处理
  702. ob.setInitiate(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  703. ob.setAccept(tOrder.getSalesmanId());
  704. TOrderLog tl=new TOrderLog();
  705. tl.setOrderNo(orderNo);
  706. tl.setProcess(OrderLogProcess.BH.getCode());
  707. addOrderLog(tl,reason);
  708. tOrderBackMapper.insertSelective(ob);
  709. }
  710. @SuppressWarnings("unchecked")
  711. @Override
  712. public Pagination<outOrderDunListBo> dunOrderNewList(String name, String orderNo,String contractNo, String starTime, String endTime,
  713. Integer specially,String aid, String adminName,String depId,Integer newStatus,Integer pageNo, Integer pageSize) {
  714. Map<String, Object> params = new HashMap<String, Object>();
  715. if(pageSize==null||pageSize<0)pageSize=10;
  716. if(pageNo==null||pageNo<0)pageNo=1;
  717. if(newStatus!=null&&newStatus==0)params.put("newStatus", 0);
  718. else params.put("newStatus", tOrderDunMapper.selectByOrderNo(orderNo).isEmpty()?1:0);
  719. if (StringUtils.isNotBlank(name)) params.put("name", name);
  720. if (StringUtils.isNotBlank(depId)) params.put("depId", depId);
  721. if (StringUtils.isNotBlank(adminName)) params.put("adminName", adminName);
  722. if (StringUtils.isNotBlank(orderNo)) params.put("orderNo", orderNo);
  723. if (StringUtils.isNotBlank(contractNo)) params.put("contractNo", contractNo);
  724. if (StringUtils.isNotBlank(starTime)) params.put("starTime", starTime);
  725. if (StringUtils.isNotBlank(endTime)) params.put("endTime", endTime+" 23:59:59");
  726. if (specially==null)specially=0;
  727. params.put("specially", specially);
  728. Integer i=null;
  729. if (TokenManager.hasRole(AFTConstants.FINANCE)) {
  730. i=1;
  731. params.put("fid", TokenManager.getAdminId());
  732. }else if (TokenManager.hasRole(AFTConstants.FINANCE_MANAGER)) {
  733. i=2;
  734. params.put("fid", TokenManager.getAdminId());
  735. }else if(TokenManager.hasRole(AFTConstants.FINANCE_ADMIN)||TokenManager.hasRole(AFTConstants.VICE_CEO)||
  736. TokenManager.hasRole(AFTConstants.SUPERADMIN)||TokenManager.hasRole(AFTConstants.CED)||
  737. TokenManager.hasRole(AFTConstants.APPROVAL_DECISION)){
  738. i=3;
  739. }else {
  740. params.put("aid", TokenManager.getAdminId());
  741. }
  742. if (specially==1){
  743. params.put("aid", aid);
  744. params.put("dunStatus", 1);
  745. }
  746. if(i!=null)params.put("shiroType", i);
  747. Pagination<outOrderDunListBo> p = (Pagination<outOrderDunListBo>)findPage("selectDunOrderNewListByPage", "selectDunOrderNewListCount", params, pageNo, pageSize);
  748. return p;
  749. }
  750. @Override
  751. public int createDunLog( String dunId, String dumTime, String remarks, String attUrl) {
  752. TDunLog d=new TDunLog();
  753. d.setId(UUID.randomUUID().toString());
  754. d.setDunId(dunId);
  755. d.setDumBy(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  756. d.setAttachmentUrl(attUrl);
  757. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  758. try {
  759. d.setDumTime(sdf.parse(dumTime));
  760. } catch (ParseException e) {
  761. e.printStackTrace();
  762. }
  763. d.setRemarks(remarks);
  764. return tDunLogMapper.insertSelective(d);
  765. }
  766. @Override
  767. public List<TDunLogListBo> selectDunLogList(String dunId) {
  768. return tDunLogMapper.selectByDunId(dunId);
  769. }
  770. @Override
  771. public int addOrderRefund(TOrderRefundWithBLOBs t) {
  772. TOrderNew order =checkDeleteSign(t.getOrderNo());
  773. if(order.getDeleteSign()!=0)throw new BusinessException(new Error( "订单变更锁定中","订单变更锁定中"));
  774. t.setRefundStatus(refundState.DSH.getCode());
  775. t.setCreateTime(new Date());
  776. t.setInitiate(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  777. //t.setAccept("1");
  778. t.setAccept(order.getFinanceId());
  779. t.setResult("");
  780. TOrderNew tOrder=new TOrderNew();
  781. tOrder.setOrderNo(t.getOrderNo());
  782. tOrder.setOrderStatus(OrderNewState.TDZ.getCode());
  783. tOrderNewMapper.updateByPrimaryKeySelective(tOrder);
  784. TOrderLog tl=new TOrderLog();
  785. tl.setOrderNo(t.getOrderNo());
  786. tl.setProcess(OrderLogProcess.FQTD.getCode());
  787. addOrderLog(tl,null);
  788. return tOrderRefundMapper.insertSelective(t);
  789. }
  790. @Override
  791. public int updateApprovalOrder(String orderNo,Integer confirm,String reason) {
  792. TOrderNew t=new TOrderNew();
  793. TOrderNew t2=checkDeleteSign(orderNo);
  794. t.setOrderNo(orderNo);
  795. List<String> aids = new ArrayList<>();
  796. Integer type=null;
  797. TOrderLog tl=new TOrderLog();
  798. tl.setOrderNo(orderNo);
  799. if (confirm==2) {
  800. t.setApproval(2);
  801. t.setProcessStatus(ProcessStatus.YPZXSGLY.getCode());
  802. OrganizationListOut oo=organizationManagementMapper.selectAllById(t2.getOrderDep());
  803. t.setFinanceId(oo.getFinanceId());
  804. for (Admin admin : adminMapper.getAdminRoleList("咨询师管理员")) {
  805. aids.add(admin.getId());
  806. }
  807. type=NoticeStatus.ORDER_APPROVA_YES.getCode();
  808. tl.setProcess(OrderLogProcess.TP.getCode());
  809. } else {
  810. t.setApproval(3);
  811. t.setOrderStatus(OrderNewState.YBH.getCode());
  812. t.setProcessStatus(ProcessStatus.YPYXY.getCode());
  813. addBackOrder(orderNo, reason);
  814. tl.setProcess(OrderLogProcess.BH.getCode());
  815. aids.add(t2.getSalesmanId());
  816. type=NoticeStatus.ORDER_APPROVA_NO.getCode();
  817. }
  818. addOrderLog(tl,reason);
  819. TOrderNewBo order = tOrderNewMapper.getSaleIdByOno(orderNo);
  820. pushGeneralSendNoticeAndEmail(aids, type,order, TokenManager.getAdminId(),t2.getApproval());
  821. //新增特批催款信息
  822. return tOrderNewMapper.updateByPrimaryKeySelective(t);
  823. }
  824. @Override
  825. public List<TOrderDun> selectOrderDun(String orderNo) {
  826. return tOrderDunMapper.selectByOrderNoDunSubject(orderNo);
  827. }
  828. @Override
  829. public boolean checkOrderMain(TOrderTask t) {
  830. List<TOrderTaskBo> list=tOrderTaskMapper.selectOrderTask(t.getOrderNo());
  831. int flag=0;
  832. if(t.getMain()==1)flag++;
  833. for (TOrderTask t2 : list) {
  834. if(t2.getMain()==1&&t.getId()==null) {
  835. flag++;
  836. }else if (t2.getMain()==1&&(!t.getId().equals(t2.getId()))) {
  837. flag++;
  838. }
  839. }
  840. if (flag>1) {
  841. return true;
  842. }
  843. return false;
  844. }
  845. @Override
  846. public boolean chekeOrderStatus(String orderNo) {
  847. TOrderNew tOrder= tOrderNewMapper.selectByPrimaryKey(orderNo);
  848. if (tOrder.getOrderStatus()==OrderNewState.QDDS.getCode()||tOrder.getOrderStatus()==OrderNewState.QDSHTG.getCode()) {
  849. return false;
  850. }
  851. return true;
  852. }
  853. @Override
  854. public boolean chekeApprovalOrderStatus(String orderNo) {
  855. TOrderNew tOrder= tOrderNewMapper.selectByPrimaryKey(orderNo);
  856. if (tOrder.getApproval()==ApprovalNewState.FTP.getCode()||
  857. tOrder.getOrderStatus()==OrderNewState.QDSHJJ.getCode()||
  858. tOrder.getOrderStatus()==OrderNewState.YBH.getCode()) {
  859. return true;
  860. }
  861. return false;
  862. }
  863. @Override
  864. public int deleteOrderNew(String orderNo) {
  865. TOrderNew t=tOrderNewMapper.selectByPrimaryKey(orderNo);
  866. if (t.getOrderStatus()==OrderNewState.YBH.getCode()||t.getOrderStatus()==OrderNewState.YTD.getCode()||
  867. t.getOrderStatus()==OrderNewState.DQD.getCode()||t.getOrderStatus()==OrderNewState.QDSHJJ.getCode()) {
  868. t.setOrderNo(orderNo);
  869. t.setDeleteSign(1);//作废
  870. contractNoReplace(orderNo, t.getContractNo(),t.getOrderDep());
  871. t.setContractNo("");
  872. return tOrderNewMapper.updateByPrimaryKeySelective(t);
  873. }
  874. return -1;
  875. }
  876. /**
  877. * 将合同编号置为闲置编号
  878. * @param orderNo
  879. */
  880. private void contractNoReplace(String orderNo, String contractNo,String orderDep) {
  881. Calendar c=Calendar.getInstance();
  882. int y=c.get(Calendar.YEAR);
  883. String ys="-"+y;
  884. //判断编号是否类似‘-2019’,是则为有效编号
  885. if (contractNo.contains(ys)) {
  886. IdleContractNo i=new IdleContractNo();
  887. i.setAid(TokenManager.getAdminId());
  888. i.setContractNo(contractNo);
  889. i.setUsedOrderNo(orderNo);
  890. i.setYear(y);
  891. //如果找不到订单部门,则取订单编号-前面的缩写
  892. if(StringUtils.isNotBlank(orderDep)) {
  893. OrganizationManagement o=organizationManagementMapper.selectByPrimaryKey(orderDep);
  894. i.setAbbreviation(o.getAbbreviation());
  895. }else {
  896. i.setAbbreviation(contractNo.substring(0, contractNo.indexOf("-")));
  897. }
  898. idleContractNoMapper.insertSelective(i);
  899. }
  900. }
  901. @Override
  902. public boolean checkOderSettlementAmount(String orderNo) {
  903. TOrderNew tOrder= tOrderNewMapper.selectByPrimaryKey(orderNo);
  904. if (tOrder.getSettlementAmount()==null||
  905. tOrder.getSettlementAmount().doubleValue()==0||
  906. tOrder.getOrderStatus()==OrderNewState.TDZ.getCode()){
  907. return true;
  908. }
  909. return false;
  910. }
  911. @SuppressWarnings("unchecked")
  912. @Override
  913. public Pagination<TOrderRefundBo> orderRefundList(String name, String orderNo, String starTime, String endTime, Integer specially,
  914. Integer pageNo, Integer pageSize) {
  915. Map<String, Object> params = new HashMap<String, Object>();
  916. if(pageSize==null||pageSize<0)pageSize=10;
  917. if(pageNo==null||pageNo<0)pageNo=1;
  918. params.put("aid", TokenManager.getAdminId()==null?"1":TokenManager.getAdminId());
  919. if (StringUtils.isNotBlank(name)) params.put("name", name);
  920. if (StringUtils.isNotBlank(orderNo)) params.put("orderNo", orderNo);
  921. if (StringUtils.isNotBlank(starTime)) params.put("starTime", starTime);
  922. if (StringUtils.isNotBlank(endTime)) params.put("endTime", endTime+" 23:59:59");
  923. Pagination<TOrderRefundBo> p = (Pagination<TOrderRefundBo>)findPage("selectOrderRefundListByPage", "selectOrderRefundListCount", params, pageNo, pageSize);
  924. return p;
  925. }
  926. @Override
  927. public boolean checkORderTask(String orderNo) {
  928. List<TOrderTaskBo> list=tOrderTaskMapper.selectOrderTask(orderNo);
  929. for (TOrderTaskBo t : list) {
  930. if (t.getMain()==1) {
  931. return false;
  932. }
  933. }
  934. return true;
  935. }
  936. @Override
  937. public boolean checkORderDun(String orderNo) {
  938. List<OutNewOrderDunBo> list=newOrderDunMapper.selectListNewOrderDun(orderNo, null, null);
  939. if (list==null||list.size()<1) {
  940. return true;
  941. }else {
  942. return false;
  943. }
  944. }
  945. /**
  946. * 获取催款数据
  947. * @throws IOException
  948. */
  949. @Override
  950. public void exportOrderDunData(String name,String orderNo,String contractNo,String starTime,String endTime,Integer specially,String aid,String adminName,
  951. String depId,Integer newStatus,Integer pageNo,Integer pageSize,HttpServletResponse response) throws Exception {
  952. OutputStream out = response.getOutputStream();
  953. try {
  954. @SuppressWarnings("unchecked")
  955. List<outOrderDunListBo> list=(List<outOrderDunListBo>) dunOrderNewList( name, orderNo, contractNo, starTime, endTime,specially,
  956. aid, adminName, depId,newStatus, pageNo, pageSize).getList();
  957. String[] comment = {"合同编号","订单编号","客户名称","订单负责人","订单部门","订单状态","签单金额","应收款","已收款","拨款比例","结算状态","未收款","项目状态","催收科目","催款状态","催款启动时间","签单时间"};
  958. String fileName ="催款信息记录表" + new SimpleDateFormat("yyyy-MM-dd HH:mm").format(new Date()) + ".xls";
  959. //type 0 变更
  960. XSSFWorkbook wb =ExportExcelUtil.exportTemplateInfoS(comment,"催款信息");
  961. //根据列表编写文档
  962. XSSFSheet sheet =wb.getSheetAt(0);
  963. for (outOrderDunListBo ob : list) {
  964. //新增一行
  965. XSSFRow r = sheet.createRow(sheet.getLastRowNum()+1);
  966. for (int i = 0; i < comment.length; i++) {
  967. //当前列的只
  968. String o = "";
  969. switch (comment[i]) {
  970. // "合同编号","订单编号","客户名称","订单负责人","订单部门","订单状态","项目负责人","签单金额","结算状态","已收款","应收款","项目状态","催收科目","催款启动时间"
  971. case "合同编号": o = ob.getContractNo(); break;
  972. case "订单编号": o = ob.getOrderNo(); break;
  973. case "客户名称": o = ob.getUserName(); break;
  974. case "订单负责人": o = ob.getSalesmanName(); break;
  975. case "订单部门": o = ob.getDepName(); break;
  976. case "订单状态": o = OrderNewState.getValueByCode(ob.getOrderStatus());break;
  977. case "签单金额": o = ob.getTotalAmount().toString(); break;
  978. case "已收款": o = bigToString(ob.getSettlementAmount()); break;
  979. case "未收款": o = bigToString(ob.getUncollectedAmount()); break;
  980. case "拨款比例": o = bigToString(ob.getAppropriationRatio()); break;
  981. case "结算状态": o = LiquidationNewState.getValueByCode(ob.getLiquidationStatus()); break;
  982. case "应收款": o = bigToString(ob.getAccountsReceivable()); break;
  983. case "项目状态": o = NewProjectStatus.getValueByCode(ob.getProjectStatus()); break;
  984. case "催收科目": o = ob.getDunSubject(); break;
  985. case "催款状态": o = ob.getDunStatus()==0?"未启动":"已启动"; break;
  986. case "催款启动时间": o = ob.getStartDate(); break;
  987. case "签单时间": o = ob.getSignDate(); break;
  988. default: o = ""; break;
  989. }
  990. XSSFCell c = r.createCell(i);
  991. c.setCellValue(o);
  992. }
  993. }
  994. //返回名称及参数
  995. response.addHeader("Content-Disposition", "attachment;filename=" + new String(fileName.getBytes(),"iso-8859-1"));
  996. response.setContentType("application/octet-stream;charset=utf-8");
  997. // 返回数据流
  998. wb.write(out);
  999. out.flush();
  1000. out.close();
  1001. } catch (Exception e) {
  1002. e.printStackTrace();
  1003. throw new BusinessException(new Error("表格生成错误。"));
  1004. }finally {
  1005. out.flush();
  1006. out.close();
  1007. }
  1008. }
  1009. private String bigToString (BigDecimal o){
  1010. if(o==null){return "";}
  1011. else{
  1012. return o.stripTrailingZeros().toEngineeringString();
  1013. }
  1014. }
  1015. @Override
  1016. public int updateOrderOver(String orderNo) {
  1017. TOrderNew t=tOrderNewMapper.selectByPrimaryKey(orderNo);
  1018. if (t.getLiquidationStatus()!=LiquidationNewState.ALREADY_PAY.getCode()||
  1019. t.getProcessStatus()!=ProcessStatus.YQBFPZXSGLY.getCode()) {
  1020. return -1;
  1021. }
  1022. List<TOrderTaskBo> list=tOrderTaskMapper.selectOrderTask(orderNo);
  1023. for (TOrderTaskBo task : list) {
  1024. if (task.getTaskStatus()!=TaskState.CLYWC.getCode()) {
  1025. return -1;
  1026. }
  1027. }
  1028. t.setOrderStatus(OrderNewState.YJX.getCode());
  1029. t.setSettlementTime(new Date());
  1030. return tOrderNewMapper.updateByPrimaryKeySelective(t);
  1031. }
  1032. @Override
  1033. public OrderRefundDetailBo orderRefundDetail(String id) {
  1034. return tOrderNewMapper.orderRefundDetail(id);
  1035. }
  1036. @Override
  1037. public int updateOrderRefund(TOrderRefundWithBLOBs t) {
  1038. checkDeleteSign(t.getOrderNo());
  1039. return tOrderRefundMapper.updateByPrimaryKeySelective(t);
  1040. }
  1041. @Override
  1042. public int updatetechnicianBackOrder(String orderNo,String reason) {
  1043. TOrderNew t = checkDeleteSign(orderNo);
  1044. if (t.getSettlementAmount().compareTo(new BigDecimal(0))!=0) {
  1045. return -1;
  1046. }
  1047. t.setOrderStatus(OrderNewState.YBH.getCode());
  1048. t.setProcessStatus(ProcessStatus.YPYXY.getCode());
  1049. t.setFinanceId("");
  1050. addBackOrder(orderNo, reason);
  1051. List<String> aids = new ArrayList<>();
  1052. aids.add(t.getSalesmanId());
  1053. TOrderNewBo order = tOrderNewMapper.getSaleIdByOno(orderNo);
  1054. pushGeneralSendNoticeAndEmail(aids, NoticeStatus.ORDER_NO.getCode(),order, TokenManager.getAdminId(),t.getApproval());
  1055. return tOrderNewMapper.updateByPrimaryKeySelective(t);
  1056. }
  1057. private TOrderNew checkDeleteSign(String orderNo) {
  1058. TOrderNew t=tOrderNewMapper.selectByPrimaryKey(orderNo);
  1059. //if(t.getDeleteSign()==2) throw new BusinessException(new Error(ErrorConstants.ORDER_ALREADY_REVOKE, t.getOrderNo(),""));
  1060. return t;
  1061. }
  1062. @Override
  1063. public List<OrderDunTaskBo> selectAllOrderDun() {
  1064. return tOrderDunMapper.getTaskAllOrderDun();
  1065. }
  1066. @Override
  1067. public void updateOrderDun(TOrderDun tDun) {
  1068. tOrderDunMapper.updateByPrimaryKeySelective(tDun);
  1069. }
  1070. @Override
  1071. public void addNoticAndSendEmail(String orderNo,OrderDunTaskBo t,Integer type)
  1072. throws UnsupportedEncodingException, MessagingException {
  1073. TOrderNewBo b = tOrderNewMapper.getSaleIdByOno(type==NoticeStatus.ORDER_DUN.getCode()?t.getOrderNo():orderNo);
  1074. String id="1";
  1075. if (type==NoticeStatus.ORDER_DUN.getCode()) id=b.getSalesmanId();
  1076. if (type==NoticeStatus.ORDER_BACK.getCode()) id=TokenManager.getAdminId()==null?"1":TokenManager.getAdminId();
  1077. if (type==NoticeStatus.ORDER_APPROVA_NO.getCode()) id=TokenManager.getAdminId()==null?"1":TokenManager.getAdminId();
  1078. AdminListBo a = adminMapper.getDeptNameByAid(id);
  1079. sendEmail( t==null?null:t.getId(), a, b);
  1080. addNotic(type,a, b);
  1081. }
  1082. public void addNotic(Integer type,AdminListBo a,TOrderNewBo b) {
  1083. StringBuffer sb=new StringBuffer();
  1084. sb=sb.append("客户名称[").append(b.getUserName()).append("], 合同编号[").append(b.getContractNo())
  1085. .append("] 订单编号[").append(b.getOrderNo()).append("] 操作人: ").append(a.getDepartmentName()).append("-").append(a.getName()).append("。");
  1086. Notice n =new Notice();
  1087. n.setId(UUID.randomUUID().toString());
  1088. n.setAid(b.getSalesmanId());
  1089. n.setNoticeType(type);
  1090. n.setContent(sb.toString());
  1091. n.setReaded(0);//未读
  1092. asyncUtils.addNotice(n);
  1093. }
  1094. public void sendEmail(String dunId,AdminListBo a,TOrderNewBo b){
  1095. LoggerUtils.debug(logger, "======================邮件信息发送===================");
  1096. String content = "<div>客户名称: "+ b.getUserName() +"</div><div>订单编号: " + b.getOrderNo() + "</div><div>合同编号: " + b.getContractNo() + "</div>";
  1097. String tite="订单驳回";
  1098. if(StringUtils.isNotBlank(dunId)) {
  1099. TOrderDun tDun=tOrderDunMapper.selectByPrimaryKey(dunId);
  1100. content +="<div>催收时间: " + new SimpleDateFormat("yyyy-MM-dd").format(tDun.getCreateTime()) +
  1101. "</div><div>催收科目: " + OrderDunSubject.getValueByCode(tDun.getDunSubject()) +
  1102. "</div><div>催收情况: " + (tDun.getDunStatus()==2?"已完成":"已启动") +"</div>";
  1103. tite="催收通知";
  1104. }
  1105. //发送驳回邮件
  1106. EmailBo bo = new EmailBo(tite, b.getEmail(), b.getSalesmanName(), a.getDepartmentName(), a.getName(), content);
  1107. if(StringUtils.isNotBlank(b.getEmail())) {
  1108. asyncUtils.send(bo);
  1109. }
  1110. LoggerUtils.debug(logger, "=========================================发送邮件成功");
  1111. }
  1112. @Override
  1113. public int updateFinance(String orderNo, String newFinance) {
  1114. String aid=TokenManager.getAdminId();
  1115. String[] l=orderNo.split(",");
  1116. List<String> orderNos=new ArrayList<>(Arrays.asList(l));
  1117. tOrderNewMapper.updateFinance(aid,orderNos,newFinance);
  1118. return 1;
  1119. }
  1120. @Override
  1121. public List<TOrderLogBo> selectOrderLog(String orderNo) {
  1122. return tOrderLogMapper.selectOrderByNo(orderNo);
  1123. }
  1124. public void pushGeneralSendNoticeAndEmail(List<String> alist, Integer type,TOrderNewBo order,String adminId,Integer approval) {
  1125. pushGeneralSendNoticeAndEmail( alist, type, order, adminId, approval,null);
  1126. }
  1127. public void pushGeneralSendNoticeAndEmail(List<String> alist, Integer type,TOrderNewBo order,String adminId,Integer approval,Integer tid) {
  1128. AdminListBo a = adminMapper.getDeptNameByAid(adminId);
  1129. String approvalType="";
  1130. String noticeTypeName = NoticeStatus.getValueByCode(type);
  1131. if (approval!=ApprovalNewState.FTP.getCode()) approvalType="[特批]";
  1132. StringBuffer str=new StringBuffer(approvalType).append(noticeTypeName).append(":");
  1133. if (tid != null) {str=str.append("项目编号[").append(tid).append("],");}
  1134. str=str.append("客户名称[") .append(order.getUserName()).append("],");
  1135. if(StringUtils.isNotBlank(order.getContractNo()))str=str.append("合同编号[").append(order.getContractNo()).append("],");
  1136. str=str.append("订单编号[").append(order.getOrderNo()).append("],").append("操作人:")
  1137. .append(a.getDepartmentName()).append("-").append(a.getName()).append("。");
  1138. String adminIds="";
  1139. List<Notice> nlist=new ArrayList<>();
  1140. for (String string : alist) {
  1141. Notice n =new Notice();
  1142. n.setId(UUID.randomUUID().toString());
  1143. n.setNoticeType(type);
  1144. n.setContent(str.toString());
  1145. n.setCreateTime(new Date());
  1146. n.setReaded(0);//未读
  1147. n.setAid(string);
  1148. nlist.add(n);
  1149. Admin admin = adminMapper.selectAllByid(string);
  1150. //去除邮件重复的
  1151. if(admin!=null&&admin.getEmail()!=null&&SendEmailUtil.isEmail(admin.getEmail().trim())){
  1152. if (!adminIds.contains(admin.getEmail())){
  1153. adminIds+=admin.getEmail()+",";
  1154. }
  1155. }
  1156. }
  1157. if(!nlist.isEmpty())asyncUtils.addNoticeBatch(nlist);
  1158. if (!nlist.isEmpty()&&StringUtils.isNotBlank(adminIds)) {
  1159. adminIds=adminIds.substring(0, adminIds.length()-1);
  1160. EmailBo bo=new EmailBo(noticeTypeName,adminIds,str.toString());
  1161. asyncUtils.send(bo);
  1162. }
  1163. }
  1164. @Override
  1165. @Transactional
  1166. public int pushOutsourceProjectAudit(TOrderOutsource o) {
  1167. //前端加载缓慢避免重复提交
  1168. if(o.getId()==null){
  1169. OrderOutsourceDtails ood=tOrderOutsourceMapper.selectByOrderNo(null,o.getTid().toString());
  1170. if (ood!=null){
  1171. return 1;
  1172. }
  1173. }
  1174. o.setRefundStatus(0);
  1175. o.setCreateTime(new Date());
  1176. if(o.getAmount()==null)o.setAmount(new BigDecimal(0));
  1177. if(o.getStartType()==null)o.setStartType(0);
  1178. if (o.getStartType()==0) {
  1179. List<String> aids = new ArrayList<>();
  1180. for (Admin admin : adminMapper.getAdminRoleList("外包审核员")) {
  1181. aids.add(admin.getId());
  1182. }
  1183. TOrderNew t2= checkDeleteSign(o.getOrderNo());
  1184. Admin a =adminMapper.selectByPrimaryKey(TokenManager.getAdminId());
  1185. OutsourceLog ol=new OutsourceLog(o.getTid(),0,o.getReason(), TokenManager.getAdminId(),a.getName());
  1186. outsourceLogMapper.insertSelective(ol);
  1187. TOrderNewBo order = tOrderNewMapper.getSaleIdByOno(o.getOrderNo());
  1188. pushGeneralSendNoticeAndEmail(aids, NoticeStatus.PROJECT_OUTSOURCE_START.getCode(),order, TokenManager.getAdminId(),t2.getApproval(),o.getTid());
  1189. }
  1190. List<OutPaymentNode> list=paymentNodeMapper.selectByStatus(0);
  1191. for (OutPaymentNode outPaymentNode : list) {
  1192. if (outPaymentNode.getDunType()==1) {
  1193. PaymentNode pn=new PaymentNode();
  1194. pn.setId(outPaymentNode.getId());
  1195. pn.setDunStatus(1);
  1196. paymentNodeMapper.updateByPrimaryKeySelective(pn);
  1197. }
  1198. }
  1199. if (o.getStartType()==1) {//供应商无需审核
  1200. o.setRefundStatus(1);
  1201. }
  1202. if (o.getId()==null) {
  1203. tOrderOutsourceMapper.insertSelective(o);
  1204. }else {
  1205. tOrderOutsourceMapper.updateByPrimaryKeySelective(o);
  1206. //旧项目变更,如果驳回修改成新的项目变更
  1207. if(o.getUnitNumber()!=null)tOrderOutsourceMapper.updateByidNull(o.getId());
  1208. }
  1209. updateOrderCostAmount(o.getTid(),o.getStartType());
  1210. return 1;
  1211. }
  1212. /**
  1213. * 发起外包时,通过计算获取项目的成本,订单的成本
  1214. *
  1215. * @param tid 项目编号
  1216. * @param type 0外包 1供应商
  1217. */
  1218. @Override
  1219. public void updateOrderCostAmount(Integer tid,Integer type) {
  1220. //计算项目成本
  1221. List<OutThirdPartyCompany>list=thirdPartyCompanyMapper.selectByTid(tid);
  1222. BigDecimal tCount=new BigDecimal(0);
  1223. for (OutThirdPartyCompany op : list) {
  1224. tCount=tCount.add(new BigDecimal(op.getTotalAmount()));
  1225. }
  1226. if(type==1) {
  1227. ProjectTypePuls tt=tOrderTaskMapper.selectByTidGetDtails(tid);
  1228. if (tt.getOutPatentType()==0){
  1229. if (tt.getOfficialCost()==1) {
  1230. if (tt.getCostReduction()==1) {
  1231. tCount=tCount.add(tt.getProportion85().multiply(new BigDecimal(tt.getQuantity())));
  1232. }else {
  1233. tCount=tCount.add(tt.getOfficialAmount().multiply(new BigDecimal(tt.getQuantity())));
  1234. }
  1235. }
  1236. }
  1237. }
  1238. tTaskMidMapper.updateCostAmount(tid,tCount);
  1239. //计算订单成本
  1240. BigDecimal oCount=new BigDecimal(0);
  1241. List <TTaskMid> tlist=tTaskMidMapper.selectListByTid(tid);
  1242. for (TTaskMid tm : tlist) {
  1243. if (tm!=null&&tm.getCostAmount()!=null)oCount=oCount.add(tm.getCostAmount()==null?new BigDecimal(0):tm.getCostAmount());
  1244. }
  1245. tOrderMidMapper.updateCostAmount(tid,oCount,null);
  1246. }
  1247. @Override
  1248. @Cacheable(cacheNames = "statisticsList#500",key = "'statisticsList:depId:'+#in.depId+'province:'+#in.province+" +
  1249. "'startCreate:'+#in.startCreate+'endCreate:'+#in.endCreate+'startSign:'+#in.startSign+'endSign:'+#in.endSign+'sort:'+#in.sort")
  1250. public List<outStatisticsList> statisticsList(InputStatistics in) {
  1251. if(in.getSort()==null)in.setSort(0);
  1252. if(in.getEndCreate()!=null)in.setEndCreate(in.getEndCreate()+" 23:59:59");
  1253. if(in.getEndSign()!=null)in.setEndSign(in.getEndSign()+" 23:59:59");
  1254. return tOrderNewMapper.statisticsList(in);
  1255. }
  1256. @Override
  1257. @Cacheable(cacheNames = "provinceStatisticsList#500",key = "'statisticsList:depId:'+#in.depId+'province:'+#in.province+" +
  1258. "'startCreate:'+#in.startCreate+'endCreate:'+#in.endCreate+'startSign:'+#in.startSign+'endSign:'+#in.endSign+'sort:'+#in.sort")
  1259. public List<outProvinceStatisticsList> provinceStatisticsList(InputStatistics in) {
  1260. if(in.getSort()==null)in.setSort(0);
  1261. if(in.getEndCreate()!=null)in.setEndCreate(in.getEndCreate()+" 23:59:59");
  1262. if(in.getEndSign()!=null)in.setEndSign(in.getEndSign()+" 23:59:59");
  1263. return tOrderNewMapper.provinceStatisticsList(in);
  1264. }
  1265. @SuppressWarnings("unchecked")
  1266. @Override
  1267. public Pagination<OutArrearsDunListBo> arrearsDunList(InputArrearsDunListBo in) {
  1268. Map<String, Object> params = new HashMap<String, Object>();
  1269. if(in.getPageSize()==null||in.getPageSize()<0)in.setPageSize(10);
  1270. if(in.getPageNo()==null||in.getPageNo()<0)in.setPageNo(1);
  1271. if (StringUtils.isNotBlank(in.getName())) params.put("name", in.getName());
  1272. if (StringUtils.isNotBlank(in.getDepId())) params.put("depId", in.getDepId());
  1273. if (StringUtils.isNotBlank(in.getAdminName())) params.put("adminName", in.getAdminName());
  1274. if (StringUtils.isNotBlank(in.getOrderNo())) params.put("orderNo", in.getOrderNo());
  1275. if (StringUtils.isNotBlank(in.getContractNo())) params.put("contractNo", in.getContractNo());
  1276. if (StringUtils.isNotBlank(in.getStarTime())) params.put("starTime", in.getStarTime());
  1277. if (StringUtils.isNotBlank(in.getEndTime())) params.put("endTime", in.getEndTime()+" 23:59:59");
  1278. if (StringUtils.isNotBlank(in.gettStarTime())) params.put("tStarTime", in.gettStarTime());
  1279. if (StringUtils.isNotBlank(in.gettEndTime())) params.put("tEndTime", in.gettEndTime()+" 23:59:59");
  1280. Integer i=null;
  1281. if (TokenManager.hasRole(AFTConstants.FINANCE)) {
  1282. i=1;
  1283. params.put("fid", TokenManager.getAdminId());
  1284. }else if (TokenManager.hasRole(AFTConstants.FINANCE_MANAGER)) {
  1285. i=2;
  1286. params.put("fid", TokenManager.getAdminId());
  1287. }else{
  1288. params.put("aid", TokenManager.getAdminId());
  1289. }
  1290. if (TokenManager.hasRole(AFTConstants.FINANCE_ADMIN)||TokenManager.hasRole(AFTConstants.VICE_CEO)||
  1291. TokenManager.hasRole(AFTConstants.SUPERADMIN)||TokenManager.hasRole(AFTConstants.CED)||
  1292. TokenManager.hasRole(AFTConstants.APPROVAL_DECISION))i=3;
  1293. if(i!=null)params.put("shiroType", i);
  1294. Pagination<OutArrearsDunListBo> p = (Pagination<OutArrearsDunListBo>)findPage("selectArrearsDunListByPage", "selectArrearsDunListByCount", params, in.getPageNo(), in.getPageSize());
  1295. return p;
  1296. }
  1297. @Override
  1298. public boolean checkOfficialType(TOrderOutsource o) {
  1299. TOrderTaskDetailBo t=tOrderTaskMapper.getOrderTaskDetail(o.getTid().toString());
  1300. if(t.getPatentTransfer()==0){
  1301. if(t.getBpType()==1) {
  1302. OfficialFeePrice of=officialFeePriceMapper.selectBytype(o.getPatentNameType(), t.getPatentType());
  1303. if (of==null) {
  1304. return true;
  1305. }
  1306. }
  1307. }
  1308. return false;
  1309. }
  1310. }