OrderNewServiceImpl.java 54 KB

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