PatentService.java 101 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523
  1. package cn.cslg.pas.service;
  2. import cn.cslg.pas.common.core.base.Constants;
  3. import cn.cslg.pas.common.model.BaseEntity;
  4. import cn.cslg.pas.common.model.QueryPatentVO;
  5. import cn.cslg.pas.common.model.dto.PatentDTO;
  6. import cn.cslg.pas.common.model.dto.PatentQueryFieldSourceDTO;
  7. import cn.cslg.pas.common.model.dto.TaskWebSocketDTO;
  8. import cn.cslg.pas.domain.*;
  9. import cn.cslg.pas.common.model.vo.PatentExportVO;
  10. import cn.cslg.pas.common.model.vo.PatentQueryFieldSourceVO;
  11. import cn.cslg.pas.common.model.vo.PatentVO;
  12. import cn.cslg.pas.common.model.vo.TaskParams;
  13. import cn.cslg.pas.common.utils.*;
  14. import cn.cslg.pas.common.model.dto.CustomFieldDTO;
  15. import cn.cslg.pas.common.model.params.PatentCustomFieldParams;
  16. import cn.cslg.pas.common.utils.WebSocketServer;
  17. import cn.cslg.pas.mapper.PatentMapper;
  18. import cn.cslg.pas.common.utils.CacheUtils;
  19. import cn.cslg.pas.common.utils.PatentUtils;
  20. import cn.hutool.core.io.FileUtil;
  21. import cn.hutool.core.util.IdUtil;
  22. import com.alibaba.fastjson.JSON;
  23. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  24. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  25. import com.baomidou.mybatisplus.core.metadata.IPage;
  26. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  27. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  28. import lombok.RequiredArgsConstructor;
  29. import org.apache.ibatis.annotations.Param;
  30. import org.apache.poi.hssf.usermodel.*;
  31. import org.apache.poi.hssf.util.HSSFColor;
  32. import org.apache.poi.ss.usermodel.*;
  33. import org.springframework.beans.BeanUtils;
  34. import org.springframework.context.annotation.Lazy;
  35. import org.springframework.scheduling.annotation.Async;
  36. import org.springframework.stereotype.Service;
  37. import java.io.FileOutputStream;
  38. import java.util.*;
  39. import java.util.stream.Collectors;
  40. /**
  41. * <p>
  42. * 专利信息表 服务实现类
  43. * </p>
  44. *
  45. * @author 王岩
  46. * @since 2021-12-26
  47. */
  48. @Service
  49. @RequiredArgsConstructor(onConstructor_ = {@Lazy})
  50. public class PatentService extends ServiceImpl<PatentMapper, Patent> {
  51. private final PatentMapper patentMapper;
  52. private final PatentApplicantService patentApplicantService;
  53. private final PatentApplicantLinkService applicantAttributeService;
  54. private final ProjectPatentLinkService projectPatentLinkService;
  55. private final CustomAnalysisItemSourceService customAnalysisItemSourceService;
  56. private final CacheUtils cacheUtils;
  57. private final DataAnalysisService dataAnalysisService;
  58. private final PatentAffairService patentAffairService;
  59. private final ProjectFieldTreeService projectFieldTreeService;
  60. private final ProjectFieldOptionService projectFieldOptionService;
  61. private final PatentLabelService patentLabelService;
  62. private final ProjectFieldTextService projectFieldTextService;
  63. private final PatentFieldService patentFieldService;
  64. private final ProjectFieldService projectFieldService;
  65. private final TaskService taskService;
  66. private final FileUtils fileUtils;
  67. private final PatentImageService patentImageService;
  68. private final PatentInventorService patentInventorService;
  69. private final PatentAgencyService patentAgencyService;
  70. private final PatentAgentService patentAgentService;
  71. private final ProjectFolderPatentLinkService projectFolderPatentLinkService;
  72. private final PatentApplicantMergeLinkService patentApplicantMergeLinkService;
  73. private final AreaService areaService;
  74. private final PatentClassNumberService patentClassNumberService;
  75. private final PatentClassNumberLinkService patentClassNumberLinkService;
  76. private final ProjectFieldPatentLinkService projectFieldPatentLinkService;
  77. private final PatentInstructionService patentInstructionService;
  78. private final PatentSimpleFamilyService patentSimpleFamilyService;
  79. private final SystemDictService systemDictService;
  80. private final PatentSimpleFamilyLinkService patentSimpleFamilyLinkService;
  81. private final PatentRightService patentRightService;
  82. private final PatentInstructionTextService patentInstructionTextService;
  83. private final PatentLicensorService patentLicensorService;
  84. private final PatentPledgeService patentPledgeService;
  85. private final PatentInventorMergeService patentInventorMergeService;
  86. public List<Patent> getPatentListByIds(List<Integer> ids) {
  87. if (ids == null || ids.size() == 0) {
  88. return new ArrayList<>();
  89. }
  90. LambdaQueryWrapper<Patent> queryWrapper = new LambdaQueryWrapper<>();
  91. queryWrapper.in(Patent::getId, ids);
  92. return this.list(queryWrapper);
  93. }
  94. public List<Patent> getPatentListByPatentNo(List<String> patentNo) {
  95. if (patentNo == null || patentNo.size() == 0) {
  96. return new ArrayList<>();
  97. }
  98. LambdaQueryWrapper<Patent> queryWrapper = new LambdaQueryWrapper<>();
  99. queryWrapper.in(Patent::getPatentNo, patentNo);
  100. return this.list(queryWrapper);
  101. }
  102. public Patent getByPatentNo(String patentNo) {
  103. LambdaQueryWrapper<Patent> queryWrapper = new LambdaQueryWrapper<>();
  104. queryWrapper.eq(Patent::getPatentNo, patentNo);
  105. return this.getOne(queryWrapper);
  106. }
  107. public List<Patent> getPublicDateAndPatentNoByPatentNo(List<String> patentNo) {
  108. LambdaQueryWrapper<Patent> queryWrapper = new LambdaQueryWrapper<>();
  109. queryWrapper.select(Patent::getPublicDate, Patent::getPatentNo, Patent::getId, Patent::getPublicNo
  110. , Patent::getSimpleFamily, Patent::getInpadocFamily, Patent::getPatSnapFamily);
  111. queryWrapper.in(Patent::getPatentNo, patentNo);
  112. queryWrapper.last(" order by appdate, patentno");
  113. return this.list(queryWrapper);
  114. }
  115. public List<Patent> getPatentIdAndPatentNoByIds(List<Integer> ids) {
  116. if (ids == null || ids.size() == 0) {
  117. return new ArrayList<>();
  118. }
  119. LambdaQueryWrapper<Patent> queryWrapper = new LambdaQueryWrapper<>();
  120. queryWrapper.select(Patent::getPatentNo, Patent::getId);
  121. queryWrapper.in(Patent::getId, ids);
  122. return this.list(queryWrapper);
  123. }
  124. public Date getDateTime(String ids, Integer fieldId, String type) {
  125. String column = "";
  126. switch (fieldId) {
  127. case 25:
  128. column = "appdate";
  129. break;
  130. case 26:
  131. column = "publicdate";
  132. break;
  133. case 27:
  134. column = "publictodate";
  135. break;
  136. default:
  137. return new Date(baseMapper.getDateTime2(ids, fieldId, type) * 1000L);
  138. }
  139. return new Date(baseMapper.getDateTime(ids, column, type) * 1000L);
  140. }
  141. public String getPatentNumberTypeCount(Integer projectId, String id, Integer field, CustomAnalysisItemSource source) {
  142. QueryWrapper<Patent> queryWrapper = new QueryWrapper<>();
  143. List<Integer> ids = StringUtils.changeStringToInteger(id, ",");
  144. String column = "";
  145. List<String> options = Arrays.asList(">", ">=", "<", "<=");
  146. if (ids.size() == 0) {
  147. return null;
  148. }
  149. Integer mino = source.getMin().getOperator();
  150. Integer maxo = source.getMax().getOperator();
  151. Integer minv = source.getMin().getValue();
  152. Integer maxv = source.getMax().getValue();
  153. queryWrapper.lambda().in(Patent::getId, ids);
  154. switch (field) {
  155. case 32:
  156. column = "quoteno";
  157. break;
  158. case 33:
  159. column = "quotedno";
  160. break;
  161. case 34:
  162. column = "inpadocfamilynum";
  163. break;
  164. case 35:
  165. column = "simplefamilynum";
  166. break;
  167. case 55:
  168. column = "patsnapfamilynum";
  169. break;
  170. case 38:
  171. column = "num2";
  172. break;
  173. case 39:
  174. column = "num3";
  175. break;
  176. default:
  177. List<Integer> patentIds = baseMapper.getCustomFieldCount(ids, field, options.get(mino), options.get(maxo), minv, maxv);
  178. return StringUtils.join(patentIds.stream().distinct().collect(Collectors.toList()), ",");
  179. }
  180. if (mino.equals(0)) {
  181. queryWrapper.gt(column, minv);
  182. } else {
  183. queryWrapper.ge(column, minv);
  184. }
  185. if (maxo.equals(2)) {
  186. queryWrapper.lt(column, maxv);
  187. } else {
  188. queryWrapper.le(column, maxv);
  189. }
  190. List<Patent> patentList = this.list(queryWrapper);
  191. return StringUtils.join(patentList.stream().map(Patent::getId).distinct().collect(Collectors.toList()), ",");
  192. }
  193. public String getPatentDateTime2(Integer projectId, Integer field, Long startDate, Long endDate, String id) {
  194. LambdaQueryWrapper<Patent> queryWrapper = new LambdaQueryWrapper<>();
  195. List<Integer> ids = StringUtils.changeStringToInteger(id, ",");
  196. if (ids.size() == 0) {
  197. return null;
  198. }
  199. queryWrapper.in(Patent::getId, ids);
  200. switch (field) {
  201. case 25:
  202. queryWrapper.between(Patent::getApplicationDate, startDate, endDate);
  203. break;
  204. case 26:
  205. queryWrapper.between(Patent::getPublicDate, startDate, endDate);
  206. break;
  207. case 27:
  208. queryWrapper.between(Patent::getPublicAccreditDate, startDate, endDate);
  209. break;
  210. default:
  211. List<Integer> patentIds = baseMapper.getCustomFieldTime(ids, field, startDate, endDate);
  212. return StringUtils.join(patentIds.stream().distinct().collect(Collectors.toList()), ",");
  213. }
  214. List<Patent> patentList = this.list(queryWrapper);
  215. return StringUtils.join(patentList.stream().map(BaseEntity::getId).distinct().collect(Collectors.toList()), ",");
  216. }
  217. private void setQueryPatentParams(PatentVO params) {
  218. List<String> customIds = new ArrayList<>();
  219. if (StringUtils.isNotEmpty(params.getName())) {
  220. params.setNameSql(PatentUtils.formatTextQuerySql(params.getName(), "a.name"));
  221. }
  222. if (StringUtils.isNotEmpty(params.getAbstractStr())) {
  223. params.setAbstractStrSql(PatentUtils.formatTextQuerySql(params.getAbstractStr(), "a.abstract"));
  224. }
  225. if (StringUtils.isNotEmpty(params.getPublicNo())) {
  226. params.setPublicNoSql(PatentUtils.formatTextQuerySql(params.getPublicNo(), "a.publicno"));
  227. }
  228. if (StringUtils.isNotEmpty(params.getApplicationNo())) {
  229. params.setApplicationNoSql(PatentUtils.formatTextQuerySql(params.getApplicationNo(), "a.applicationno"));
  230. }
  231. if (StringUtils.isNotEmpty(params.getRightContent())) {
  232. params.setRightContentSql(PatentUtils.formatTextQuerySql(params.getRightContent(), "content"));
  233. }
  234. for (int i = 0; i < params.getField().size(); i++) {
  235. List<String> queryList = params.getField().get(i).getValue();
  236. String key = params.getField().get(i).getKey();
  237. List<Integer> field = StringUtils.changeStringToInteger(key, "-");
  238. if (queryList.size() == 0) {
  239. continue;
  240. }
  241. String fieldType = params.getField().get(i).getType();
  242. switch (key) {
  243. case "13":
  244. case "15":
  245. case "16":
  246. case "17":
  247. if (field.get(0) == 13) {
  248. params.setQueryClassNumberIpc(true);
  249. params.setWhereClassNumberIpc(queryList);
  250. params.setQueryClassNumberIpcMethod(params.getField().get(i).getClassId());
  251. }
  252. if (field.get(0) == 15) {
  253. params.setQueryClassNumberCpc(true);
  254. params.setWhereClassNumberCpc(queryList);
  255. params.setQueryClassNumberCpcMethod(params.getField().get(i).getClassId());
  256. }
  257. if (field.get(0) == 17) {
  258. params.setQueryClassNumberUpc(true);
  259. params.setWhereClassNumberUpc(queryList);
  260. params.setQueryClassNumberUpcMethod(params.getField().get(i).getClassId());
  261. }
  262. if (field.get(0) == 16) {
  263. params.setQueryClassNumberLoc(true);
  264. params.setWhereClassNumberLoc(queryList);
  265. params.setQueryClassNumberLocMethod(params.getField().get(i).getClassId());
  266. }
  267. break;
  268. case "18-6":
  269. params.setQueryApplicantOriginal(true);
  270. params.setWhereApplicantOriginal(queryList);
  271. break;
  272. case "19-6":
  273. params.setQueryApplicantCurrent(true);
  274. params.setWhereApplicantCurrent(queryList);
  275. break;
  276. case "20-0":
  277. params.setQueryInventor(true);
  278. params.setWhereInventor(queryList);
  279. break;
  280. case "20-1":
  281. params.setQueryInventor(true);
  282. params.setQueryInventorMerge(true);
  283. params.setWhereInventorMerge(queryList);
  284. break;
  285. case "18-7":
  286. params.setQueryApplicantOriginalStandard(true);
  287. params.setWhereApplicantOriginalStandard(queryList);
  288. break;
  289. case "19-7":
  290. params.setQueryApplicantCurrentStandard(true);
  291. params.setWhereApplicantCurrentStandard(queryList);
  292. break;
  293. case "18-8":
  294. params.setQueryApplicantOriginal(true);
  295. params.setQueryApplicantOriginalMerge(true);
  296. params.setWhereApplicantOriginalMerge(queryList);
  297. break;
  298. case "19-8":
  299. params.setQueryApplicantCurrent(true);
  300. params.setQueryApplicantCurrentMerge(true);
  301. params.setWhereApplicantCurrentMerge(queryList);
  302. break;
  303. case "28-0":
  304. params.setQueryBureau(true);
  305. params.setWhereBureau(queryList);
  306. break;
  307. case "37-0":
  308. params.setQueryType(true);
  309. params.setWhereType(queryList);
  310. break;
  311. case "36-0":
  312. params.setQueryStatus(true);
  313. params.setWhereStatus(queryList);
  314. break;
  315. case "25-12":
  316. params.setQueryAppDate(true);
  317. params.setWhereAppDate(queryList);
  318. break;
  319. case "26-12":
  320. params.setQueryPublicDate(true);
  321. params.setWherePublicDate(queryList);
  322. break;
  323. case "29-17":
  324. params.setQueryApplicantAddress(true);
  325. params.setQueryCountry(true);
  326. params.setWhereCountry(queryList);
  327. break;
  328. case "29-18":
  329. params.setQueryApplicantAddress(true);
  330. params.setQueryApplicantProvince(true);
  331. params.setWhereApplicantProvince(queryList);
  332. break;
  333. case "40-0":
  334. params.setQueryAffair(true);
  335. StringBuilder str = new StringBuilder();
  336. for (String s : queryList) {
  337. str.append(s).append("|");
  338. }
  339. params.setWhereAffair(str.substring(0, str.length() - 1));
  340. break;
  341. case "54-0":
  342. params.setQueryLabel(true);
  343. params.setWhereLabel(queryList);
  344. break;
  345. default:
  346. customIds.add(String.valueOf(field.get(0)));
  347. if (fieldType.equals("6")) {
  348. if (field.get(1).equals(1)) {
  349. params.setQueryTreeType1(true);
  350. params.setWhereTreeType1(queryList);
  351. params.setQueryTreeType0(false);
  352. params.setWhereTreeType0(null);
  353. } else {
  354. params.setQueryTreeType0(true);
  355. params.setWhereTreeType0(queryList);
  356. params.setQueryTreeType1(false);
  357. params.setWhereTreeType1(null);
  358. }
  359. } else if (fieldType.equals("0") || fieldType.equals("1") || fieldType.equals("2")) {
  360. params.setWhereFieldText(queryList);
  361. params.setWhereFieldTextNull(queryList.stream().anyMatch(item -> item.equals("null")));
  362. } else {
  363. params.setWhereFieldMultiple(queryList);
  364. params.setWhereFieldMultipleNull(queryList.stream().anyMatch(item -> item.equals("null")));
  365. }
  366. }
  367. }
  368. if (customIds.size() != 0) {
  369. params.setQueryFieldText(true);
  370. params.setQueryFieldMultiple(true);
  371. params.setCustomIds(customIds);
  372. }
  373. }
  374. public List<Integer> getPatentListIds(PatentVO params) {
  375. this.setQueryFamilyParams(params);
  376. params.setSelected(new ArrayList<>());
  377. List<Integer> ids = this.getQueryPatentIds(params);
  378. return ids.stream().skip(params.getStartNumber() - 1).limit(params.getEndNumber() - params.getStartNumber() + 1).collect(Collectors.toList());
  379. }
  380. private void setQueryFamilyParams(PatentVO params) {
  381. switch (params.getFamily()) {
  382. case 0:
  383. params.setQuerySimpleFamily(false);
  384. params.setQueryInpadocFamily(false);
  385. params.setQueryPatSnapFamily(false);
  386. break;
  387. case 1:
  388. params.setQuerySimpleFamily(true);
  389. params.setQueryInpadocFamily(false);
  390. params.setQueryPatSnapFamily(false);
  391. break;
  392. case 2:
  393. params.setQuerySimpleFamily(false);
  394. params.setQueryInpadocFamily(true);
  395. params.setQueryPatSnapFamily(false);
  396. break;
  397. case 3:
  398. params.setQuerySimpleFamily(false);
  399. params.setQueryInpadocFamily(false);
  400. params.setQueryPatSnapFamily(true);
  401. break;
  402. }
  403. }
  404. public IPage<PatentDTO> getPageList(PatentVO params) {
  405. this.setQueryFamilyParams(params);
  406. this.setQueryPatentParams(params);
  407. IPage<Patent> dataPage = baseMapper.getPageList(new Page<>(params.getCurrent(), params.getSize()), params);
  408. IPage<PatentDTO> pageList = new Page<>();
  409. List<PatentDTO> records = new ArrayList<>();
  410. List<Integer> patentIds = dataPage.getRecords().stream().map(Patent::getId).collect(Collectors.toList());
  411. List<PatentApplicant> patentApplicantList = patentApplicantService.getPatentApplicantByPatentIds(patentIds);
  412. List<PatentInventor> patentInventorList = patentInventorService.getPatentInventorByPatentIds(patentIds);
  413. List<PatentLabel> patentLabelList = patentLabelService.getPatentLabelByPatentIdsAndProjectId(patentIds, params.getProjectId());
  414. List<PatentClassNumberLink> patentClassNumberLinkList = patentClassNumberLinkService.getPatentClassNumberLinkByPatentIds(patentIds);
  415. List<PatentAgent> patentAgentList = patentAgentService.getPatentAgentByPatentIds(patentIds);
  416. List<PatentAgency> patentAgencyList = patentAgencyService.getPatentAgencyByIds(dataPage.getRecords().stream().filter(item -> StringUtils.isNotEmpty(item.getAgencyId())).map(item -> Integer.parseInt(item.getAgencyId())).distinct().collect(Collectors.toList()));
  417. List<PatentSimpleFamilyLink> patentSimpleFamilyLinkList = patentSimpleFamilyLinkService.getPatentSimpleFamilyLinkByFamilyIds(dataPage.getRecords().stream().map(Patent::getSimpleFamily).collect(Collectors.toList()));
  418. List<PatentSimpleFamilyLink> patentInpadocFamilyLinkList = patentSimpleFamilyLinkService.getPatentSimpleFamilyLinkByFamilyIds(dataPage.getRecords().stream().map(Patent::getInpadocFamily).collect(Collectors.toList()));
  419. List<PatentSimpleFamilyLink> patentPatSnapFamilyLinkList = patentSimpleFamilyLinkService.getPatentSimpleFamilyLinkByFamilyIds(dataPage.getRecords().stream().map(Patent::getPatSnapFamily).collect(Collectors.toList()));
  420. List<SystemDict> systemDictList = systemDictService.getSystemDictListByType(Arrays.asList(Constants.PATENT_TYPE, Constants.PATENT_SIMPLE_STATUS));
  421. dataPage.getRecords().forEach(item -> {
  422. PatentDTO patentDTO = new PatentDTO();
  423. BeanUtils.copyProperties(item, patentDTO);
  424. patentDTO.setApplicationDate(DateUtils.formatDate(item.getApplicationDate(), DateUtils.YYYY_MM_DD));
  425. patentDTO.setPriorityDate(DateUtils.formatDate(item.getPriorityDate(), DateUtils.YYYY_MM_DD));
  426. patentDTO.setPublicDate(DateUtils.formatDate(item.getPublicDate(), DateUtils.YYYY_MM_DD));
  427. patentDTO.setPublicAccreditDate(DateUtils.formatDate(item.getPublicAccreditDate(), DateUtils.YYYY_MM_DD));
  428. patentDTO.setFirstPublicDate(DateUtils.formatDate(item.getFirstPublicDate(), DateUtils.YYYY_MM_DD));
  429. patentDTO.setSimpleStatus(systemDictList.stream().filter(systemDict -> systemDict.getType().equals(Constants.PATENT_SIMPLE_STATUS) && systemDict.getValue().equals(String.valueOf(item.getSimpleStatus()))).findFirst().orElse(new SystemDict()).getLabel());
  430. patentDTO.setType(systemDictList.stream().filter(systemDict -> systemDict.getType().equals(Constants.PATENT_TYPE) && systemDict.getValue().equals(String.valueOf(item.getType()))).findFirst().orElse(new SystemDict()).getLabel());
  431. patentDTO.setApplicant(patentApplicantList.stream().filter(patentApplicant -> patentApplicant.getPatentId().equals(item.getId())).collect(Collectors.toList()));
  432. patentDTO.setInventor(patentInventorList.stream().filter(patentInventor -> patentInventor.getPatentId().equals(item.getId())).collect(Collectors.toList()));
  433. patentDTO.setLabel(patentLabelList.stream().filter(patentLabel -> patentLabel.getPatentId().equals(item.getId())).collect(Collectors.toList()));
  434. patentDTO.setIpcList(patentClassNumberLinkList.stream().filter(patentClassNumber -> patentClassNumber.getPatentId().equals(item.getId()) && patentClassNumber.getType().equals(Constants.PATENT_CLASS_NUMBER_IPC)).map(PatentClassNumberLink::getCode).distinct().collect(Collectors.toList()));
  435. patentDTO.setCpcList(patentClassNumberLinkList.stream().filter(patentClassNumber -> patentClassNumber.getPatentId().equals(item.getId()) && patentClassNumber.getType().equals(Constants.PATENT_CLASS_NUMBER_CPC)).map(PatentClassNumberLink::getCode).distinct().collect(Collectors.toList()));
  436. patentDTO.setUpcList(patentClassNumberLinkList.stream().filter(patentClassNumber -> patentClassNumber.getPatentId().equals(item.getId()) && patentClassNumber.getType().equals(Constants.PATENT_CLASS_NUMBER_UPC)).map(PatentClassNumberLink::getCode).distinct().collect(Collectors.toList()));
  437. patentDTO.setLocList(patentClassNumberLinkList.stream().filter(patentClassNumber -> patentClassNumber.getPatentId().equals(item.getId()) && patentClassNumber.getType().equals(Constants.PATENT_CLASS_NUMBER_LOC)).map(PatentClassNumberLink::getCode).distinct().collect(Collectors.toList()));
  438. if (StringUtils.isNotEmpty(item.getAgencyId())) {
  439. patentDTO.setAgency(patentAgencyList.stream().filter(patentAgency -> patentAgency.getId().equals(Integer.parseInt(item.getAgencyId()))).findFirst().orElse(null));
  440. }
  441. PatentDTO.PatentFamily patentFamily = new PatentDTO.PatentFamily();
  442. patentFamily.setSimple(patentSimpleFamilyLinkList.stream().filter(patentSimpleFamilyLink -> patentSimpleFamilyLink.getFamilyId().equals(item.getSimpleFamily())).map(PatentSimpleFamilyLink::getPatentNo).collect(Collectors.toList()));
  443. patentFamily.setInpadoc(patentInpadocFamilyLinkList.stream().filter(patentSimpleFamilyLink -> patentSimpleFamilyLink.getFamilyId().equals(item.getInpadocFamily())).map(PatentSimpleFamilyLink::getPatentNo).collect(Collectors.toList()));
  444. patentFamily.setPatSnap(patentPatSnapFamilyLinkList.stream().filter(patentSimpleFamilyLink -> patentSimpleFamilyLink.getFamilyId().equals(item.getPatSnapFamily())).map(PatentSimpleFamilyLink::getPatentNo).collect(Collectors.toList()));
  445. patentDTO.setFamily(patentFamily);
  446. patentDTO.setAgent(patentAgentList.stream().filter(patentAgent -> patentAgent.getPatentId().equals(item.getId())).collect(Collectors.toList()));
  447. // TODO 性能优化
  448. patentDTO.setField(projectFieldService.getPatentFieldByPatentIdAndProjectId(params.getProjectId(), item.getId()));
  449. records.add(patentDTO);
  450. });
  451. pageList.setTotal(dataPage.getTotal());
  452. pageList.setRecords(records);
  453. pageList.setPages(dataPage.getPages());
  454. pageList.setSize(dataPage.getSize());
  455. pageList.setCurrent(dataPage.getCurrent());
  456. return pageList;
  457. }
  458. public IPage<PatentDTO> getPageListForRMS(QueryPatentVO params) {
  459. IPage<Patent> dataPage = baseMapper.getPageListForRMS2(new Page<>(params.getCurrent(), params.getSize()),params);
  460. IPage<PatentDTO> pageList = new Page<>();
  461. List<PatentDTO> records = new ArrayList<>();
  462. List<Integer> patentIds = dataPage.getRecords().stream().map(Patent::getId).collect(Collectors.toList());
  463. List<PatentApplicant> patentApplicantList = patentApplicantService.getPatentApplicantByPatentIds(patentIds);
  464. List<PatentInventor> patentInventorList = patentInventorService.getPatentInventorByPatentIds(patentIds);
  465. List<PatentLabel> patentLabelList = patentLabelService.getPatentLabelByPatentIdsAndProjectId(patentIds, params.getProjectId());
  466. List<PatentClassNumberLink> patentClassNumberLinkList = patentClassNumberLinkService.getPatentClassNumberLinkByPatentIds(patentIds);
  467. List<PatentAgent> patentAgentList = patentAgentService.getPatentAgentByPatentIds(patentIds);
  468. List<PatentAgency> patentAgencyList = patentAgencyService.getPatentAgencyByIds(dataPage.getRecords().stream().filter(item -> StringUtils.isNotEmpty(item.getAgencyId())).map(item -> Integer.parseInt(item.getAgencyId())).distinct().collect(Collectors.toList()));
  469. List<PatentSimpleFamilyLink> patentSimpleFamilyLinkList = patentSimpleFamilyLinkService.getPatentSimpleFamilyLinkByFamilyIds(dataPage.getRecords().stream().map(Patent::getSimpleFamily).collect(Collectors.toList()));
  470. List<PatentSimpleFamilyLink> patentInpadocFamilyLinkList = patentSimpleFamilyLinkService.getPatentSimpleFamilyLinkByFamilyIds(dataPage.getRecords().stream().map(Patent::getInpadocFamily).collect(Collectors.toList()));
  471. List<PatentSimpleFamilyLink> patentPatSnapFamilyLinkList = patentSimpleFamilyLinkService.getPatentSimpleFamilyLinkByFamilyIds(dataPage.getRecords().stream().map(Patent::getPatSnapFamily).collect(Collectors.toList()));
  472. List<SystemDict> systemDictList = systemDictService.getSystemDictListByType(Arrays.asList(Constants.PATENT_TYPE, Constants.PATENT_SIMPLE_STATUS));
  473. dataPage.getRecords().forEach(item -> {
  474. PatentDTO patentDTO = new PatentDTO();
  475. BeanUtils.copyProperties(item, patentDTO);
  476. patentDTO.setApplicationDate(DateUtils.formatDate(item.getApplicationDate(), DateUtils.YYYY_MM_DD));
  477. patentDTO.setPriorityDate(DateUtils.formatDate(item.getPriorityDate(), DateUtils.YYYY_MM_DD));
  478. patentDTO.setPublicDate(DateUtils.formatDate(item.getPublicDate(), DateUtils.YYYY_MM_DD));
  479. patentDTO.setPublicAccreditDate(DateUtils.formatDate(item.getPublicAccreditDate(), DateUtils.YYYY_MM_DD));
  480. patentDTO.setFirstPublicDate(DateUtils.formatDate(item.getFirstPublicDate(), DateUtils.YYYY_MM_DD));
  481. patentDTO.setSimpleStatus(systemDictList.stream().filter(systemDict -> systemDict.getType().equals(Constants.PATENT_SIMPLE_STATUS) && systemDict.getValue().equals(String.valueOf(item.getSimpleStatus()))).findFirst().orElse(new SystemDict()).getLabel());
  482. patentDTO.setType(systemDictList.stream().filter(systemDict -> systemDict.getType().equals(Constants.PATENT_TYPE) && systemDict.getValue().equals(String.valueOf(item.getType()))).findFirst().orElse(new SystemDict()).getLabel());
  483. patentDTO.setApplicant(patentApplicantList.stream().filter(patentApplicant -> patentApplicant.getPatentId().equals(item.getId())).collect(Collectors.toList()));
  484. patentDTO.setInventor(patentInventorList.stream().filter(patentInventor -> patentInventor.getPatentId().equals(item.getId())).collect(Collectors.toList()));
  485. patentDTO.setLabel(patentLabelList.stream().filter(patentLabel -> patentLabel.getPatentId().equals(item.getId())).collect(Collectors.toList()));
  486. patentDTO.setIpcList(patentClassNumberLinkList.stream().filter(patentClassNumber -> patentClassNumber.getPatentId().equals(item.getId()) && patentClassNumber.getType().equals(Constants.PATENT_CLASS_NUMBER_IPC)).map(PatentClassNumberLink::getCode).distinct().collect(Collectors.toList()));
  487. patentDTO.setCpcList(patentClassNumberLinkList.stream().filter(patentClassNumber -> patentClassNumber.getPatentId().equals(item.getId()) && patentClassNumber.getType().equals(Constants.PATENT_CLASS_NUMBER_CPC)).map(PatentClassNumberLink::getCode).distinct().collect(Collectors.toList()));
  488. patentDTO.setUpcList(patentClassNumberLinkList.stream().filter(patentClassNumber -> patentClassNumber.getPatentId().equals(item.getId()) && patentClassNumber.getType().equals(Constants.PATENT_CLASS_NUMBER_UPC)).map(PatentClassNumberLink::getCode).distinct().collect(Collectors.toList()));
  489. patentDTO.setLocList(patentClassNumberLinkList.stream().filter(patentClassNumber -> patentClassNumber.getPatentId().equals(item.getId()) && patentClassNumber.getType().equals(Constants.PATENT_CLASS_NUMBER_LOC)).map(PatentClassNumberLink::getCode).distinct().collect(Collectors.toList()));
  490. patentDTO.setAffair(patentAffairService.getPatentAffairByPatentId(item.getId()));
  491. if (StringUtils.isNotEmpty(item.getAgencyId())) {
  492. patentDTO.setAgency(patentAgencyList.stream().filter(patentAgency -> patentAgency.getId().equals(Integer.parseInt(item.getAgencyId()))).findFirst().orElse(null));
  493. }
  494. PatentDTO.PatentFamily patentFamily = new PatentDTO.PatentFamily();
  495. patentFamily.setSimple(patentSimpleFamilyLinkList.stream().filter(patentSimpleFamilyLink -> patentSimpleFamilyLink.getFamilyId().equals(item.getSimpleFamily())).map(PatentSimpleFamilyLink::getPatentNo).collect(Collectors.toList()));
  496. patentFamily.setInpadoc(patentInpadocFamilyLinkList.stream().filter(patentSimpleFamilyLink -> patentSimpleFamilyLink.getFamilyId().equals(item.getInpadocFamily())).map(PatentSimpleFamilyLink::getPatentNo).collect(Collectors.toList()));
  497. patentFamily.setPatSnap(patentPatSnapFamilyLinkList.stream().filter(patentSimpleFamilyLink -> patentSimpleFamilyLink.getFamilyId().equals(item.getPatSnapFamily())).map(PatentSimpleFamilyLink::getPatentNo).collect(Collectors.toList()));
  498. patentDTO.setFamily(patentFamily);
  499. patentDTO.setAgent(patentAgentList.stream().filter(patentAgent -> patentAgent.getPatentId().equals(item.getId())).collect(Collectors.toList()));
  500. // TODO 性能优化
  501. patentDTO.setField(projectFieldService.getPatentFieldByPatentIdAndProjectId(params.getProjectId(), item.getId()));
  502. records.add(patentDTO);
  503. });
  504. pageList.setTotal(dataPage.getTotal());
  505. pageList.setRecords(records);
  506. pageList.setPages(dataPage.getPages());
  507. pageList.setSize(dataPage.getSize());
  508. pageList.setCurrent(dataPage.getCurrent());
  509. return pageList;
  510. }
  511. public List<PatentDTO> getPatentDTOListForRMS(PatentVO params) {
  512. List<Patent> dataPage = baseMapper.getPatent(params.getPatentNos(),-1,-1);
  513. List<PatentDTO> records = new ArrayList<>();
  514. List<Integer> patentIds = dataPage.stream().map(Patent::getId).collect(Collectors.toList());
  515. List<PatentApplicant> patentApplicantList = patentApplicantService.getPatentApplicantByPatentIds(patentIds);
  516. List<PatentInventor> patentInventorList = patentInventorService.getPatentInventorByPatentIds(patentIds);
  517. List<PatentClassNumberLink> patentClassNumberLinkList = patentClassNumberLinkService.getPatentClassNumberLinkByPatentIds(patentIds);
  518. List<PatentAgent> patentAgentList = patentAgentService.getPatentAgentByPatentIds(patentIds);
  519. List<PatentAgency> patentAgencyList = patentAgencyService.getPatentAgencyByIds(dataPage.stream().filter(item -> StringUtils.isNotEmpty(item.getAgencyId())).map(item -> Integer.parseInt(item.getAgencyId())).distinct().collect(Collectors.toList()));
  520. List<PatentSimpleFamilyLink> patentSimpleFamilyLinkList = patentSimpleFamilyLinkService.getPatentSimpleFamilyLinkByFamilyIds(dataPage.stream().map(Patent::getSimpleFamily).collect(Collectors.toList()));
  521. List<PatentSimpleFamilyLink> patentInpadocFamilyLinkList = patentSimpleFamilyLinkService.getPatentSimpleFamilyLinkByFamilyIds(dataPage.stream().map(Patent::getInpadocFamily).collect(Collectors.toList()));
  522. List<PatentSimpleFamilyLink> patentPatSnapFamilyLinkList = patentSimpleFamilyLinkService.getPatentSimpleFamilyLinkByFamilyIds(dataPage.stream().map(Patent::getPatSnapFamily).collect(Collectors.toList()));
  523. List<SystemDict> systemDictList = systemDictService.getSystemDictListByType(Arrays.asList(Constants.PATENT_TYPE, Constants.PATENT_SIMPLE_STATUS));
  524. dataPage.forEach(item -> {
  525. PatentDTO patentDTO = new PatentDTO();
  526. BeanUtils.copyProperties(item, patentDTO);
  527. patentDTO.setApplicationDate(DateUtils.formatDate(item.getApplicationDate(), DateUtils.YYYY_MM_DD));
  528. patentDTO.setPriorityDate(DateUtils.formatDate(item.getPriorityDate(), DateUtils.YYYY_MM_DD));
  529. patentDTO.setPublicDate(DateUtils.formatDate(item.getPublicDate(), DateUtils.YYYY_MM_DD));
  530. patentDTO.setPublicAccreditDate(DateUtils.formatDate(item.getPublicAccreditDate(), DateUtils.YYYY_MM_DD));
  531. patentDTO.setFirstPublicDate(DateUtils.formatDate(item.getFirstPublicDate(), DateUtils.YYYY_MM_DD));
  532. patentDTO.setSimpleStatus(systemDictList.stream().filter(systemDict -> systemDict.getType().equals(Constants.PATENT_SIMPLE_STATUS) && systemDict.getValue().equals(String.valueOf(item.getSimpleStatus()))).findFirst().orElse(new SystemDict()).getLabel());
  533. patentDTO.setSimpleStatusInt(item.getSimpleStatus());
  534. patentDTO.setType(systemDictList.stream().filter(systemDict -> systemDict.getType().equals(Constants.PATENT_TYPE) && systemDict.getValue().equals(String.valueOf(item.getType()))).findFirst().orElse(new SystemDict()).getLabel());
  535. patentDTO.setApplicant(patentApplicantList.stream().filter(patentApplicant -> patentApplicant.getPatentId().equals(item.getId())).collect(Collectors.toList()));
  536. patentDTO.setInventor(patentInventorList.stream().filter(patentInventor -> patentInventor.getPatentId().equals(item.getId())).collect(Collectors.toList()));
  537. patentDTO.setIpcList(patentClassNumberLinkList.stream().filter(patentClassNumber -> patentClassNumber.getPatentId().equals(item.getId()) && patentClassNumber.getType().equals(Constants.PATENT_CLASS_NUMBER_IPC)).map(PatentClassNumberLink::getCode).distinct().collect(Collectors.toList()));
  538. patentDTO.setCpcList(patentClassNumberLinkList.stream().filter(patentClassNumber -> patentClassNumber.getPatentId().equals(item.getId()) && patentClassNumber.getType().equals(Constants.PATENT_CLASS_NUMBER_CPC)).map(PatentClassNumberLink::getCode).distinct().collect(Collectors.toList()));
  539. patentDTO.setUpcList(patentClassNumberLinkList.stream().filter(patentClassNumber -> patentClassNumber.getPatentId().equals(item.getId()) && patentClassNumber.getType().equals(Constants.PATENT_CLASS_NUMBER_UPC)).map(PatentClassNumberLink::getCode).distinct().collect(Collectors.toList()));
  540. patentDTO.setLocList(patentClassNumberLinkList.stream().filter(patentClassNumber -> patentClassNumber.getPatentId().equals(item.getId()) && patentClassNumber.getType().equals(Constants.PATENT_CLASS_NUMBER_LOC)).map(PatentClassNumberLink::getCode).distinct().collect(Collectors.toList()));
  541. if (StringUtils.isNotEmpty(item.getAgencyId())) {
  542. patentDTO.setAgency(patentAgencyList.stream().filter(patentAgency -> patentAgency.getId().equals(Integer.parseInt(item.getAgencyId()))).findFirst().orElse(null));
  543. }
  544. PatentDTO.PatentFamily patentFamily = new PatentDTO.PatentFamily();
  545. patentFamily.setSimple(patentSimpleFamilyLinkList.stream().filter(patentSimpleFamilyLink -> patentSimpleFamilyLink.getFamilyId().equals(item.getSimpleFamily())).map(PatentSimpleFamilyLink::getPatentNo).collect(Collectors.toList()));
  546. patentFamily.setInpadoc(patentInpadocFamilyLinkList.stream().filter(patentSimpleFamilyLink -> patentSimpleFamilyLink.getFamilyId().equals(item.getInpadocFamily())).map(PatentSimpleFamilyLink::getPatentNo).collect(Collectors.toList()));
  547. patentFamily.setPatSnap(patentPatSnapFamilyLinkList.stream().filter(patentSimpleFamilyLink -> patentSimpleFamilyLink.getFamilyId().equals(item.getPatSnapFamily())).map(PatentSimpleFamilyLink::getPatentNo).collect(Collectors.toList()));
  548. patentDTO.setFamily(patentFamily);
  549. patentDTO.setAffair(patentAffairService.getPatentAffairByPatentId(item.getId()));
  550. patentDTO.setAgent(patentAgentList.stream().filter(patentAgent -> patentAgent.getPatentId().equals(item.getId())).collect(Collectors.toList()));
  551. // TODO 性能优化
  552. records.add(patentDTO);
  553. });
  554. return records;
  555. }
  556. //查询对比文件信息
  557. public List<PatentDTO> getRmsComparePatent(PatentVO params) {
  558. List<Patent> dataPage = baseMapper.getPatent(params.getPatentNos(),-1,-1);
  559. List<PatentDTO> records = new ArrayList<>();
  560. List<Integer> patentIds = dataPage.stream().map(Patent::getId).collect(Collectors.toList());
  561. List<PatentApplicant> patentApplicantList = patentApplicantService.getPatentApplicantByPatentIds(patentIds);
  562. List<PatentInventor> patentInventorList = patentInventorService.getPatentInventorByPatentIds(patentIds);
  563. List<PatentClassNumberLink> patentClassNumberLinkList = patentClassNumberLinkService.getPatentClassNumberLinkByPatentIds(patentIds);
  564. List<PatentAgent> patentAgentList = patentAgentService.getPatentAgentByPatentIds(patentIds);
  565. List<PatentAgency> patentAgencyList = patentAgencyService.getPatentAgencyByIds(dataPage.stream().filter(item -> StringUtils.isNotEmpty(item.getAgencyId())).map(item -> Integer.parseInt(item.getAgencyId())).distinct().collect(Collectors.toList()));
  566. List<PatentSimpleFamilyLink> patentSimpleFamilyLinkList = patentSimpleFamilyLinkService.getPatentSimpleFamilyLinkByFamilyIds(dataPage.stream().map(Patent::getSimpleFamily).collect(Collectors.toList()));
  567. List<PatentSimpleFamilyLink> patentInpadocFamilyLinkList = patentSimpleFamilyLinkService.getPatentSimpleFamilyLinkByFamilyIds(dataPage.stream().map(Patent::getInpadocFamily).collect(Collectors.toList()));
  568. List<PatentSimpleFamilyLink> patentPatSnapFamilyLinkList = patentSimpleFamilyLinkService.getPatentSimpleFamilyLinkByFamilyIds(dataPage.stream().map(Patent::getPatSnapFamily).collect(Collectors.toList()));
  569. List<SystemDict> systemDictList = systemDictService.getSystemDictListByType(Arrays.asList(Constants.PATENT_TYPE, Constants.PATENT_SIMPLE_STATUS));
  570. dataPage.forEach(item -> {
  571. PatentDTO patentDTO = new PatentDTO();
  572. BeanUtils.copyProperties(item, patentDTO);
  573. patentDTO.setApplicationDate(DateUtils.formatDate(item.getApplicationDate(), DateUtils.YYYY_MM_DD));
  574. patentDTO.setPriorityDate(DateUtils.formatDate(item.getPriorityDate(), DateUtils.YYYY_MM_DD));
  575. patentDTO.setPublicDate(DateUtils.formatDate(item.getPublicDate(), DateUtils.YYYY_MM_DD));
  576. patentDTO.setPublicAccreditDate(DateUtils.formatDate(item.getPublicAccreditDate(), DateUtils.YYYY_MM_DD));
  577. patentDTO.setFirstPublicDate(DateUtils.formatDate(item.getFirstPublicDate(), DateUtils.YYYY_MM_DD));
  578. patentDTO.setSimpleStatus(systemDictList.stream().filter(systemDict -> systemDict.getType().equals(Constants.PATENT_SIMPLE_STATUS) && systemDict.getValue().equals(String.valueOf(item.getSimpleStatus()))).findFirst().orElse(new SystemDict()).getLabel());
  579. patentDTO.setSimpleStatusInt(item.getSimpleStatus());
  580. patentDTO.setType(systemDictList.stream().filter(systemDict -> systemDict.getType().equals(Constants.PATENT_TYPE) && systemDict.getValue().equals(String.valueOf(item.getType()))).findFirst().orElse(new SystemDict()).getLabel());
  581. patentDTO.setApplicant(patentApplicantList.stream().filter(patentApplicant -> patentApplicant.getPatentId().equals(item.getId())).collect(Collectors.toList()));
  582. patentDTO.setInventor(patentInventorList.stream().filter(patentInventor -> patentInventor.getPatentId().equals(item.getId())).collect(Collectors.toList()));
  583. patentDTO.setIpcList(patentClassNumberLinkList.stream().filter(patentClassNumber -> patentClassNumber.getPatentId().equals(item.getId()) && patentClassNumber.getType().equals(Constants.PATENT_CLASS_NUMBER_IPC)).map(PatentClassNumberLink::getCode).distinct().collect(Collectors.toList()));
  584. patentDTO.setCpcList(patentClassNumberLinkList.stream().filter(patentClassNumber -> patentClassNumber.getPatentId().equals(item.getId()) && patentClassNumber.getType().equals(Constants.PATENT_CLASS_NUMBER_CPC)).map(PatentClassNumberLink::getCode).distinct().collect(Collectors.toList()));
  585. patentDTO.setUpcList(patentClassNumberLinkList.stream().filter(patentClassNumber -> patentClassNumber.getPatentId().equals(item.getId()) && patentClassNumber.getType().equals(Constants.PATENT_CLASS_NUMBER_UPC)).map(PatentClassNumberLink::getCode).distinct().collect(Collectors.toList()));
  586. patentDTO.setLocList(patentClassNumberLinkList.stream().filter(patentClassNumber -> patentClassNumber.getPatentId().equals(item.getId()) && patentClassNumber.getType().equals(Constants.PATENT_CLASS_NUMBER_LOC)).map(PatentClassNumberLink::getCode).distinct().collect(Collectors.toList()));
  587. if (StringUtils.isNotEmpty(item.getAgencyId())) {
  588. patentDTO.setAgency(patentAgencyList.stream().filter(patentAgency -> patentAgency.getId().equals(Integer.parseInt(item.getAgencyId()))).findFirst().orElse(null));
  589. }
  590. PatentDTO.PatentFamily patentFamily = new PatentDTO.PatentFamily();
  591. patentFamily.setSimple(patentSimpleFamilyLinkList.stream().filter(patentSimpleFamilyLink -> patentSimpleFamilyLink.getFamilyId().equals(item.getSimpleFamily())).map(PatentSimpleFamilyLink::getPatentNo).collect(Collectors.toList()));
  592. patentFamily.setInpadoc(patentInpadocFamilyLinkList.stream().filter(patentSimpleFamilyLink -> patentSimpleFamilyLink.getFamilyId().equals(item.getInpadocFamily())).map(PatentSimpleFamilyLink::getPatentNo).collect(Collectors.toList()));
  593. patentFamily.setPatSnap(patentPatSnapFamilyLinkList.stream().filter(patentSimpleFamilyLink -> patentSimpleFamilyLink.getFamilyId().equals(item.getPatSnapFamily())).map(PatentSimpleFamilyLink::getPatentNo).collect(Collectors.toList()));
  594. patentDTO.setFamily(patentFamily);
  595. patentDTO.setAffair(patentAffairService.getPatentAffairByPatentId(item.getId()));
  596. patentDTO.setAgent(patentAgentList.stream().filter(patentAgent -> patentAgent.getPatentId().equals(item.getId())).collect(Collectors.toList()));
  597. // TODO 性能优化
  598. records.add(patentDTO);
  599. });
  600. return records;
  601. }
  602. // 获得对比专利号
  603. public String getComPantentNos(QueryPatentVO params){
  604. List<String> patents = baseMapper.getListForRMS(params);
  605. return Response.success(patents);
  606. }
  607. // 获得带筛选条件的对比专利号
  608. public String getConPantentNos(QueryPatentVO params){
  609. List<String> patents = baseMapper.getConPantentNos(params);
  610. return Response.success(patents);
  611. }
  612. public PatentDTO getPatentDTOById(Integer id, Integer projectId) {
  613. Patent patent = baseMapper.selectById(id);
  614. PatentDTO patentDTO = new PatentDTO();
  615. BeanUtils.copyProperties(patent, patentDTO);
  616. List<SystemDict> systemDictList = systemDictService.getSystemDictListByType(Arrays.asList(Constants.PATENT_TYPE, Constants.PATENT_SIMPLE_STATUS, Constants.COUNTRIES));
  617. List<PatentClassNumberLink> patentClassNumberLinkList = patentClassNumberLinkService.getPatentClassNumberLinkByPatentIds(Collections.singletonList(id));
  618. if (patent.getPriorityNo() != null) {
  619. patentDTO.setPriorityNo(patent.getPriorityNo());
  620. } else {
  621. patentDTO.setPriorityNo("");
  622. }
  623. if (patent.getPriorityCountry() != null) {
  624. if (patent.getPriorityCountry().contains("\\|")) {
  625. List<String> countryList = StringUtils.changeStringToString(patent.getPriorityCountry().replaceAll(" ", ""), "\\|");
  626. patentDTO.setPriorityCountry(countryList);
  627. } else if (patent.getPriorityCountry().contains(",")) {
  628. List<String> countryList = StringUtils.changeStringToString(patent.getPriorityCountry().replaceAll(" ", ""), ",");
  629. patentDTO.setPriorityCountry(countryList);
  630. } else if (patent.getPriorityCountry().contains(";")) {
  631. List<String> countryList = StringUtils.changeStringToString(patent.getPriorityCountry().replaceAll(" ", ""), ";");
  632. patentDTO.setPriorityCountry(countryList);
  633. }
  634. } else {
  635. patentDTO.setPriorityCountry(Collections.singletonList(""));
  636. }
  637. patentDTO.setApplicationDate(DateUtils.formatDate(patent.getApplicationDate(), DateUtils.YYYY_MM_DD));
  638. patentDTO.setPriorityDate(DateUtils.formatDate(patent.getPriorityDate(), DateUtils.YYYY_MM_DD));
  639. patentDTO.setPublicDate(DateUtils.formatDate(patent.getPublicDate(), DateUtils.YYYY_MM_DD));
  640. patentDTO.setPublicAccreditDate(DateUtils.formatDate(patent.getPublicAccreditDate(), DateUtils.YYYY_MM_DD));
  641. patentDTO.setFirstPublicDate(DateUtils.formatDate(patent.getFirstPublicDate(), DateUtils.YYYY_MM_DD));
  642. patentDTO.setSimpleStatus(systemDictList.stream().filter(systemDict -> systemDict.getType().equals(Constants.PATENT_SIMPLE_STATUS) && systemDict.getValue().equals(String.valueOf(patent.getSimpleStatus()))).findFirst().orElse(new SystemDict()).getLabel());
  643. patentDTO.setType(systemDictList.stream().filter(systemDict -> systemDict.getType().equals(Constants.PATENT_TYPE) && systemDict.getValue().equals(String.valueOf(patent.getType()))).findFirst().orElse(new SystemDict()).getLabel());
  644. patentDTO.setLabel(patentLabelService.getPatentLabelByPatentIdAndProjectId(patent.getId(), projectId));
  645. patentDTO.setApplicant(patentApplicantService.getPatentApplicantByPatentId(patent.getId()));
  646. patentDTO.setInventor(patentInventorService.getPatentInventorByPatentId(patent.getId()));
  647. if (StringUtils.isNotEmpty(patent.getAgencyId())) {
  648. patentDTO.setAgency(patentAgencyService.getPatentAgencyById(Integer.parseInt(patent.getAgencyId())));
  649. } else {
  650. PatentAgency patentAgency = new PatentAgency();
  651. patentAgency.setName("");
  652. patentDTO.setAgency(patentAgency);
  653. }
  654. patentDTO.setAgent(patentAgentService.getPatentAgentByPatentId(patent.getId()));
  655. patentDTO.setAffair(patentAffairService.getPatentAffairByPatentId(patent.getId()));
  656. if (projectId != null) {
  657. patentDTO.setField(projectFieldService.getPatentFieldByPatentIdAndProjectId(projectId, patent.getId()));
  658. }
  659. if (StringUtils.isNotEmpty(patent.getPriorityCountry())) {
  660. List<String> priorityList = PatentUtils.formatValue(patent.getPriorityCountry());
  661. List<String> priorityCountryList = new ArrayList<>();
  662. for (String priorityCountry : priorityList) {
  663. priorityCountryList.add(systemDictList.stream().filter(systemDict -> systemDict.getType().equals(Constants.COUNTRIES) && systemDict.getValue().equals(priorityCountry)).findFirst().orElse(new SystemDict()).getLabel());
  664. }
  665. patentDTO.setPriorityCountry(priorityCountryList);
  666. }
  667. patentDTO.setInstruction(patentInstructionTextService.getPatentInstructionTextByPatentId(patent.getId()));
  668. patentDTO.setRights(patentRightService.getPatentRightByPatentId(patent.getId()));
  669. patentDTO.setImage(patentImageService.getPatentImageByPatentId(patent.getId()));
  670. patentDTO.setPdf(patentInstructionService.getPatentInstructionByPatentNo(patent.getPatentNo()));
  671. patentDTO.setIpc(patentClassNumberLinkList.stream().filter(patentClassNumberLink -> patentClassNumberLink.getType().equals(Constants.PATENT_CLASS_NUMBER_IPC) && patentClassNumberLink.getMain().equals(1)).findFirst().orElse(new PatentClassNumberLink()).getCode());
  672. patentDTO.setUpc(patentClassNumberLinkList.stream().filter(patentClassNumberLink -> patentClassNumberLink.getType().equals(Constants.PATENT_CLASS_NUMBER_UPC) && patentClassNumberLink.getMain().equals(1)).findFirst().orElse(new PatentClassNumberLink()).getCode());
  673. patentDTO.setIpcList(patentClassNumberLinkList.stream().filter(patentClassNumber -> patentClassNumber.getType().equals(Constants.PATENT_CLASS_NUMBER_IPC)).map(PatentClassNumberLink::getCode).distinct().collect(Collectors.toList()));
  674. patentDTO.setCpcList(patentClassNumberLinkList.stream().filter(patentClassNumber -> patentClassNumber.getType().equals(Constants.PATENT_CLASS_NUMBER_CPC)).map(PatentClassNumberLink::getCode).distinct().collect(Collectors.toList()));
  675. patentDTO.setUpcList(patentClassNumberLinkList.stream().filter(patentClassNumber -> patentClassNumber.getType().equals(Constants.PATENT_CLASS_NUMBER_UPC)).map(PatentClassNumberLink::getCode).distinct().collect(Collectors.toList()));
  676. patentDTO.setLocList(patentClassNumberLinkList.stream().filter(patentClassNumber -> patentClassNumber.getType().equals(Constants.PATENT_CLASS_NUMBER_LOC)).map(PatentClassNumberLink::getCode).distinct().collect(Collectors.toList()));
  677. return patentDTO;
  678. }
  679. public PatentDTO getPatentDTOById(String patentNo) {
  680. LambdaQueryWrapper<Patent> wrapper = new LambdaQueryWrapper<>();
  681. wrapper.eq(Patent::getPatentNo, patentNo);
  682. List<Patent> patents =this.list(wrapper);
  683. PatentDTO patentDTO = new PatentDTO();
  684. //如果未查出专利则返回为空
  685. if (patents ==null||patents.size()==0) {
  686. return patentDTO;
  687. }
  688. Patent patent = patents.get(0);
  689. BeanUtils.copyProperties(patent, patentDTO);
  690. List<SystemDict> systemDictList = systemDictService.getSystemDictListByType(Arrays.asList(Constants.PATENT_TYPE, Constants.PATENT_SIMPLE_STATUS, Constants.COUNTRIES));
  691. List<PatentClassNumberLink> patentClassNumberLinkList = patentClassNumberLinkService.getPatentClassNumberLinkByPatentIds(Collections.singletonList(patent.getId()));
  692. if (patent.getPriorityNo() != null) {
  693. patentDTO.setPriorityNo(patent.getPriorityNo());
  694. } else {
  695. patentDTO.setPriorityNo("");
  696. }
  697. if (patent.getPriorityCountry() != null) {
  698. if (patent.getPriorityCountry().contains("\\|")) {
  699. List<String> countryList = StringUtils.changeStringToString(patent.getPriorityCountry().replaceAll(" ", ""), "\\|");
  700. patentDTO.setPriorityCountry(countryList);
  701. } else if (patent.getPriorityCountry().contains(",")) {
  702. List<String> countryList = StringUtils.changeStringToString(patent.getPriorityCountry().replaceAll(" ", ""), ",");
  703. patentDTO.setPriorityCountry(countryList);
  704. } else if (patent.getPriorityCountry().contains(";")) {
  705. List<String> countryList = StringUtils.changeStringToString(patent.getPriorityCountry().replaceAll(" ", ""), ";");
  706. patentDTO.setPriorityCountry(countryList);
  707. }
  708. } else {
  709. patentDTO.setPriorityCountry(Collections.singletonList(""));
  710. }
  711. patentDTO.setQuote("");
  712. if(patent.getQuote()!=null){
  713. patentDTO.setQuote(patent.getQuote());
  714. }
  715. patentDTO.setQuoted("");
  716. if(patent.getQuoted()!=null){
  717. patentDTO.setQuoted(patent.getQuoted());
  718. }
  719. //根据同族号,获得所有同族专利(三种同族)
  720. List<Integer> familyIds= new ArrayList<>();
  721. if(patent.getSimpleFamily()!=null)
  722. {familyIds.add(patent.getSimpleFamily());}
  723. if(patent.getInpadocFamily()!=null){
  724. familyIds.add(patent.getInpadocFamily());
  725. }
  726. if(patent.getPatSnapFamily()!=null){
  727. familyIds.add(patent.getPatSnapFamily());
  728. }
  729. if(familyIds.size()!=0) {
  730. LambdaQueryWrapper<PatentSimpleFamilyLink> queryWrapper = new LambdaQueryWrapper<>();
  731. queryWrapper.in(PatentSimpleFamilyLink::getFamilyId, familyIds);
  732. List<PatentSimpleFamilyLink> patentSimpleFamilyLinks = patentSimpleFamilyLinkService.list(queryWrapper);
  733. List<String> familyPatentNos = patentSimpleFamilyLinks.stream().map(PatentSimpleFamilyLink::getPatentNo).collect(Collectors.toList());
  734. PatentDTO.PatentFamily patentFamily =new PatentDTO.PatentFamily();
  735. patentFamily.setSimple(familyPatentNos);
  736. patentDTO.setFamily(patentFamily);
  737. }
  738. patentDTO.setApplicationDate(DateUtils.formatDate(patent.getApplicationDate(), DateUtils.YYYY_MM_DD));
  739. patentDTO.setPriorityDate(DateUtils.formatDate(patent.getPriorityDate(), DateUtils.YYYY_MM_DD));
  740. patentDTO.setPublicDate(DateUtils.formatDate(patent.getPublicDate(), DateUtils.YYYY_MM_DD));
  741. patentDTO.setPublicAccreditDate(DateUtils.formatDate(patent.getPublicAccreditDate(), DateUtils.YYYY_MM_DD));
  742. patentDTO.setFirstPublicDate(DateUtils.formatDate(patent.getFirstPublicDate(), DateUtils.YYYY_MM_DD));
  743. patentDTO.setSimpleStatus(systemDictList.stream().filter(systemDict -> systemDict.getType().equals(Constants.PATENT_SIMPLE_STATUS) && systemDict.getValue().equals(String.valueOf(patent.getSimpleStatus()))).findFirst().orElse(new SystemDict()).getLabel());
  744. patentDTO.setSimpleStatusInt(patent.getSimpleStatus());
  745. patentDTO.setType(systemDictList.stream().filter(systemDict -> systemDict.getType().equals(Constants.PATENT_TYPE) && systemDict.getValue().equals(String.valueOf(patent.getType()))).findFirst().orElse(new SystemDict()).getLabel());
  746. patentDTO.setApplicant(patentApplicantService.getPatentApplicantByPatentId(patent.getId()));
  747. patentDTO.setInventor(patentInventorService.getPatentInventorByPatentId(patent.getId()));
  748. if (StringUtils.isNotEmpty(patent.getAgencyId())) {
  749. patentDTO.setAgency(patentAgencyService.getPatentAgencyById(Integer.parseInt(patent.getAgencyId())));
  750. } else {
  751. PatentAgency patentAgency = new PatentAgency();
  752. patentAgency.setName("");
  753. patentDTO.setAgency(patentAgency);
  754. }
  755. patentDTO.setAgent(patentAgentService.getPatentAgentByPatentId(patent.getId()));
  756. patentDTO.setAffair(patentAffairService.getPatentAffairByPatentId(patent.getId()));
  757. if (StringUtils.isNotEmpty(patent.getPriorityCountry())) {
  758. List<String> priorityList = PatentUtils.formatValue(patent.getPriorityCountry());
  759. List<String> priorityCountryList = new ArrayList<>();
  760. for (String priorityCountry : priorityList) {
  761. priorityCountryList.add(systemDictList.stream().filter(systemDict -> systemDict.getType().equals(Constants.COUNTRIES) && systemDict.getValue().equals(priorityCountry)).findFirst().orElse(new SystemDict()).getLabel());
  762. }
  763. patentDTO.setPriorityCountry(priorityCountryList);
  764. }
  765. patentDTO.setInstruction(patentInstructionTextService.getPatentInstructionTextByPatentId(patent.getId()));
  766. patentDTO.setRights(patentRightService.getPatentRightByPatentId(patent.getId()));
  767. patentDTO.setImage(patentImageService.getPatentImageByPatentId(patent.getId()));
  768. patentDTO.setPdf(patentInstructionService.getPatentInstructionByPatentNo(patent.getPatentNo()));
  769. patentDTO.setIpc(patentClassNumberLinkList.stream().filter(patentClassNumberLink -> patentClassNumberLink.getType().equals(Constants.PATENT_CLASS_NUMBER_IPC) && patentClassNumberLink.getMain().equals(1)).findFirst().orElse(new PatentClassNumberLink()).getCode());
  770. patentDTO.setUpc(patentClassNumberLinkList.stream().filter(patentClassNumberLink -> patentClassNumberLink.getType().equals(Constants.PATENT_CLASS_NUMBER_UPC) && patentClassNumberLink.getMain().equals(1)).findFirst().orElse(new PatentClassNumberLink()).getCode());
  771. patentDTO.setIpcList(patentClassNumberLinkList.stream().filter(patentClassNumber -> patentClassNumber.getType().equals(Constants.PATENT_CLASS_NUMBER_IPC)).map(PatentClassNumberLink::getCode).distinct().collect(Collectors.toList()));
  772. patentDTO.setCpcList(patentClassNumberLinkList.stream().filter(patentClassNumber -> patentClassNumber.getType().equals(Constants.PATENT_CLASS_NUMBER_CPC)).map(PatentClassNumberLink::getCode).distinct().collect(Collectors.toList()));
  773. patentDTO.setUpcList(patentClassNumberLinkList.stream().filter(patentClassNumber -> patentClassNumber.getType().equals(Constants.PATENT_CLASS_NUMBER_UPC)).map(PatentClassNumberLink::getCode).distinct().collect(Collectors.toList()));
  774. patentDTO.setLocList(patentClassNumberLinkList.stream().filter(patentClassNumber -> patentClassNumber.getType().equals(Constants.PATENT_CLASS_NUMBER_LOC)).map(PatentClassNumberLink::getCode).distinct().collect(Collectors.toList()));
  775. return patentDTO;
  776. }
  777. public List<Integer> getQueryPatentIds(PatentVO params) {
  778. if (params.getSelected() != null && params.getSelected().size() != 0 && params.getSelectId() != null && params.getSelectId()) {
  779. return params.getSelected().stream().distinct().collect(Collectors.toList());
  780. }
  781. this.setQueryPatentParams(params);
  782. List<Patent> patentList = baseMapper.getPageList(params);
  783. return patentList.stream().map(Patent::getId).distinct().collect(Collectors.toList());
  784. }
  785. @Async
  786. public void exportPatent(TaskParams taskParams) {
  787. try {
  788. List<PatentExportVO> selected = JsonUtils.jsonToList(taskParams.getSelected(), PatentExportVO.class);
  789. List<Integer> ids = StringUtils.changeStringToInteger(taskParams.getIds(), ",");
  790. if (selected != null) {
  791. List<String> columns = selected.stream().filter(PatentExportVO::getSelected).map(PatentExportVO::getKey).distinct().collect(Collectors.toList());
  792. List<String> headers = selected.stream().filter(PatentExportVO::getSelected).map(PatentExportVO::getName).distinct().collect(Collectors.toList());
  793. String fileName = IdUtil.simpleUUID() + ".xls";
  794. String directoryName = fileUtils.createDirectory();
  795. String savePath = fileUtils.getSavePath(directoryName);
  796. HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
  797. HSSFSheet sheet = hssfWorkbook.createSheet();
  798. sheet.setDefaultColumnWidth(30);
  799. HSSFRow headerRow = sheet.createRow(0);
  800. headerRow.setHeight((short) 500);
  801. HSSFCellStyle headerCellStyle = hssfWorkbook.createCellStyle();
  802. HSSFCellStyle commonCellStyle = hssfWorkbook.createCellStyle();
  803. for (int i = 0; i < headers.size(); i++) {
  804. HSSFCell cell = headerRow.createCell(i);
  805. ExcelUtils.setExcelCellStyle(headerCellStyle);
  806. headerCellStyle.setAlignment(HorizontalAlignment.CENTER);
  807. headerCellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
  808. headerCellStyle.setFillForegroundColor(HSSFColor.HSSFColorPredefined.SKY_BLUE.getIndex());
  809. headerCellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
  810. headerCellStyle.setWrapText(true);
  811. cell.setCellStyle(headerCellStyle);
  812. cell.setCellValue(headers.get(i));
  813. }
  814. for (int i = 0; i < ids.size(); i++) {
  815. Map<String, Object> map = new LinkedHashMap<>();
  816. PatentDTO patent = this.getPatentDTOById(ids.get(i), taskParams.getProjectId());
  817. if (patent == null) {
  818. continue;
  819. }
  820. String country = PatentUtils.getPatentCountry(patent.getPatentNo());
  821. for (int j = 0; j < columns.size(); j++) {
  822. String column = columns.get(j);
  823. PatentExportVO patentExportVO = selected.stream().filter(item -> item.getKey().equals(column)).findFirst().orElse(new PatentExportVO());
  824. Object value = null;
  825. switch (column) {
  826. case "pname":
  827. value = patent.getName();
  828. break;
  829. case "pname_out":
  830. value = patent.getNameOut();
  831. break;
  832. case "patentno":
  833. value = patent.getPatentNo();
  834. break;
  835. case "abstract":
  836. value = patent.getAbstractStr();
  837. break;
  838. case "abstract_out":
  839. value = patent.getAbstractOut();
  840. break;
  841. case "abstract_path":
  842. break;
  843. case "applicationno":
  844. value = patent.getApplicationNo();
  845. break;
  846. case "appdate":
  847. value = patent.getApplicationDate();
  848. break;
  849. case "publicno":
  850. value = patent.getPublicNo();
  851. break;
  852. case "publicdate":
  853. value = patent.getPublicDate();
  854. break;
  855. case "fpublicdate":
  856. value = patent.getFirstPublicDate();
  857. break;
  858. case "publictono":
  859. value = patent.getPublicAccreditNo();
  860. break;
  861. case "publictodate":
  862. value = patent.getPublicAccreditDate();
  863. break;
  864. case "tags":
  865. value = StringUtils.join(patent.getLabel().stream().map(PatentLabel::getName).distinct().collect(Collectors.toList()), "\n");
  866. break;
  867. case "bureau":
  868. value = patent.getBureau();
  869. break;
  870. case "simplefamily":
  871. List<PatentSimpleFamilyLink> patentSimpleFamilyLinkList = patentSimpleFamilyLinkService.getPatentSimpleFamilyLinkByFamilyIds(Collections.singletonList(patent.getSimpleFamily()));
  872. value = StringUtils.join(patentSimpleFamilyLinkList.stream().map(PatentSimpleFamilyLink::getPatentNo).collect(Collectors.toList()), Constants.SEPARATOR_VERTICAL_BAR);
  873. break;
  874. case "inpadocfamily":
  875. List<PatentSimpleFamilyLink> patentInpadocFamilyLinkList = patentSimpleFamilyLinkService.getPatentSimpleFamilyLinkByFamilyIds(Collections.singletonList(patent.getInpadocFamily()));
  876. value = StringUtils.join(patentInpadocFamilyLinkList.stream().map(PatentSimpleFamilyLink::getPatentNo).collect(Collectors.toList()), Constants.SEPARATOR_VERTICAL_BAR);
  877. break;
  878. case "patsnapfamily":
  879. List<PatentSimpleFamilyLink> patentPatSnapFamilyLinkList = patentSimpleFamilyLinkService.getPatentSimpleFamilyLinkByFamilyIds(Collections.singletonList(patent.getPatSnapFamily()));
  880. value = StringUtils.join(patentPatSnapFamilyLinkList.stream().map(PatentSimpleFamilyLink::getPatentNo).collect(Collectors.toList()), Constants.SEPARATOR_VERTICAL_BAR);
  881. break;
  882. case "ipc":
  883. value = StringUtils.join(patent.getIpcList(), Constants.SEPARATOR_VERTICAL_BAR);
  884. break;
  885. case "upc":
  886. value = StringUtils.join(patent.getUpcList(), Constants.SEPARATOR_VERTICAL_BAR);
  887. break;
  888. case "intclassno":
  889. value = patent.getIpc();
  890. break;
  891. case "intclasscpcno":
  892. value = StringUtils.join(patent.getCpcList(), Constants.SEPARATOR_VERTICAL_BAR);
  893. break;
  894. case "intclassupcno":
  895. value = patent.getUpc();
  896. break;
  897. case "intclasslocno":
  898. value = StringUtils.join(patent.getLocList(), Constants.SEPARATOR_VERTICAL_BAR);
  899. break;
  900. case "pstatus":
  901. value = patent.getSimpleStatus();
  902. break;
  903. case "ptype":
  904. value = patent.getType();
  905. break;
  906. case "law_datetime":
  907. value = PatentUtils.getPatentAffair(patent.getAffair(), 0);
  908. break;
  909. case "law_status":
  910. value = PatentUtils.getPatentAffair(patent.getAffair(), 1);
  911. break;
  912. case "law_simplestatus":
  913. value = PatentUtils.getPatentAffair(patent.getAffair(), 2);
  914. break;
  915. case "law_content":
  916. value = PatentUtils.getPatentAffair(patent.getAffair(), 3);
  917. break;
  918. case "applicant":
  919. value = StringUtils.join(patent.getApplicant().stream().filter(item -> item.getDataType().equals(2)).collect(Collectors.toList()).stream().map(PatentApplicant::getName).distinct().collect(Collectors.toList()), Constants.SEPARATOR_VERTICAL_BAR);
  920. break;
  921. case "applicant1":
  922. value = StringUtils.join(patent.getApplicant().stream().filter(item -> item.getDataType().equals(2)).collect(Collectors.toList()).stream().map(PatentApplicant::getShortName).distinct().collect(Collectors.toList()), Constants.SEPARATOR_VERTICAL_BAR);
  923. break;
  924. case "rightholder":
  925. value = StringUtils.join(patent.getApplicant().stream().filter(item -> item.getDataType().equals(1)).collect(Collectors.toList()).stream().map(PatentApplicant::getName).distinct().collect(Collectors.toList()), Constants.SEPARATOR_VERTICAL_BAR);
  926. break;
  927. case "rightholder1":
  928. value = StringUtils.join(patent.getApplicant().stream().filter(item -> item.getDataType().equals(1)).collect(Collectors.toList()).stream().map(PatentApplicant::getShortName).distinct().collect(Collectors.toList()), Constants.SEPARATOR_VERTICAL_BAR);
  929. break;
  930. case "applicantcountry":
  931. value = PatentUtils.getPeopleCountry(patent.getApplicant().stream().filter(item -> item.getDataType().equals(2)).collect(Collectors.toList()));
  932. break;
  933. case "rightholdercountry":
  934. value = PatentUtils.getPeopleCountry(patent.getApplicant().stream().filter(item -> item.getDataType().equals(1)).collect(Collectors.toList()));
  935. break;
  936. case "applicantaddress":
  937. value = PatentUtils.getPeopleAddress(patent.getApplicant().stream().filter(item -> item.getDataType().equals(2)).collect(Collectors.toList()));
  938. break;
  939. case "rightholderaddress":
  940. value = PatentUtils.getPeopleAddress(patent.getApplicant().stream().filter(item -> item.getDataType().equals(1)).collect(Collectors.toList()));
  941. break;
  942. case "applicantaddr":
  943. break;
  944. case "rightholderaddr":
  945. break;
  946. case "firstapplicant":
  947. PatentApplicant firstApplicant1 = patent.getApplicant().stream().filter(item -> item.getDataType().equals(2) && item.getOrder().equals(0)).findFirst().orElse(null);
  948. if (firstApplicant1 != null) {
  949. value = firstApplicant1.getName();
  950. }
  951. break;
  952. case "firstrightholder":
  953. PatentApplicant firstApplicant3 = patent.getApplicant().stream().filter(item -> item.getDataType().equals(1) && item.getOrder().equals(0)).findFirst().orElse(null);
  954. if (firstApplicant3 != null) {
  955. value = firstApplicant3.getName();
  956. }
  957. break;
  958. case "firstapplicantaddr":
  959. PatentApplicant firstApplicant2 = patent.getApplicant().stream().filter(item -> item.getDataType().equals(2) && item.getOrder().equals(0)).findFirst().orElse(null);
  960. if (firstApplicant2 != null) {
  961. value = firstApplicant2.getAddressStr();
  962. }
  963. break;
  964. case "firstrightholderaddr":
  965. PatentApplicant firstApplicant4 = patent.getApplicant().stream().filter(item -> item.getDataType().equals(1) && item.getOrder().equals(0)).findFirst().orElse(null);
  966. if (firstApplicant4 != null) {
  967. value = firstApplicant4.getAddressStr();
  968. }
  969. break;
  970. case "firstapplicantnum":
  971. value = patent.getApplicantNum();
  972. break;
  973. case "inventor":
  974. value = StringUtils.join(patent.getInventor().stream().map(PatentInventor::getName).distinct().collect(Collectors.toList()), Constants.SEPARATOR_VERTICAL_BAR);
  975. break;
  976. case "firstnventoraddr":
  977. value = patent.getInventor().stream().filter(PatentInventor::getFirst).findFirst().orElse(new PatentInventor()).getAddress();
  978. break;
  979. case "firstnventor":
  980. value = patent.getInventor().stream().filter(PatentInventor::getFirst).findFirst().orElse(new PatentInventor()).getName();
  981. break;
  982. case "inventornum":
  983. value = patent.getInventorNum();
  984. break;
  985. case "num2":
  986. value = patent.getRightNum();
  987. break;
  988. case "content":
  989. case "content_out":
  990. case "selfcontent":
  991. List<String> content = new ArrayList<>();
  992. if (column.equals("content")) {
  993. content = patent.getRights().stream().map(PatentRight::getContent).collect(Collectors.toList());
  994. }
  995. if (column.equals("content_out")) {
  996. content = patent.getRights().stream().map(PatentRight::getContentOut).collect(Collectors.toList());
  997. }
  998. if (column.equals("selfcontent")) {
  999. content = patent.getRights().stream().filter(item -> item.getType().equals(1)).map(PatentRight::getContent).collect(Collectors.toList());
  1000. }
  1001. StringBuffer contentBuffer = new StringBuffer();
  1002. for (String s : content) {
  1003. contentBuffer.append(s);
  1004. switch (country) {
  1005. case "JP":
  1006. case "CN":
  1007. contentBuffer.append("。\n");
  1008. break;
  1009. default:
  1010. contentBuffer.append("\n");
  1011. }
  1012. }
  1013. value = contentBuffer.toString();
  1014. break;
  1015. case "priorityno":
  1016. value = patent.getPriorityNo();
  1017. break;
  1018. case "prioritycountry":
  1019. value = patent.getPriorityCountry();
  1020. break;
  1021. case "prioritydate":
  1022. value = patent.getPriorityDate();
  1023. break;
  1024. case "page":
  1025. value = patent.getDocPage();
  1026. break;
  1027. case "code":
  1028. value = patent.getCode();
  1029. break;
  1030. case "manual":
  1031. if (patent.getInstruction() != null) {
  1032. value = patent.getInstruction().getManual();
  1033. }
  1034. break;
  1035. case "simplefamilynum":
  1036. value = patent.getSimpleFamilyNum();
  1037. break;
  1038. case "inpadocfamilynum":
  1039. value = patent.getInpadocFamilyNum();
  1040. break;
  1041. case "patsnapfamilynum":
  1042. value = patent.getPatSnapFamilyNum();
  1043. break;
  1044. case "quoteno":
  1045. value = patent.getQuoteNum();
  1046. break;
  1047. case "quotedno":
  1048. value = patent.getQuotedNum();
  1049. break;
  1050. case "quotedno3":
  1051. value = patent.getQuotedNum3();
  1052. break;
  1053. case "quotedno5":
  1054. value = patent.getQuotedNum5();
  1055. break;
  1056. case "agency":
  1057. PatentAgency agency = patent.getAgency();
  1058. if (agency != null) {
  1059. value = agency.getName();
  1060. }
  1061. break;
  1062. case "agent":
  1063. value = StringUtils.join(patent.getAgent().stream().map(PatentAgent::getName).distinct().collect(Collectors.toList()), Constants.SEPARATOR_VERTICAL_BAR);
  1064. break;
  1065. case "wonational":
  1066. value = patent.getWo();
  1067. break;
  1068. case "examiner":
  1069. value = patent.getExaminer();
  1070. break;
  1071. case "assexaminer":
  1072. value = patent.getAidExaminer();
  1073. break;
  1074. case "quote":
  1075. value = patent.getQuote();
  1076. break;
  1077. case "quoted":
  1078. value = patent.getQuoted();
  1079. break;
  1080. case "nonpatentquote":
  1081. value = patent.getNotPatentQuote();
  1082. break;
  1083. case "epcountry":
  1084. value = patent.getEpStatus();
  1085. break;
  1086. default:
  1087. PatentDTO.Field field = patent.getField().stream().filter(item -> item.getId().equals(Integer.parseInt(column))).findFirst().orElse(null);
  1088. if (field != null) {
  1089. value = StringUtils.join(field.getSelected(), "\n");
  1090. }
  1091. }
  1092. map.put(patentExportVO.getName(), value);
  1093. }
  1094. HSSFRow row = sheet.createRow(i + 1);
  1095. row.setHeight((short) 800);
  1096. for (String key : map.keySet()) {
  1097. int index = headers.indexOf(key);
  1098. if (index != -1) {
  1099. HSSFCell cell = row.createCell(index);
  1100. ExcelUtils.setExcelCellStyle(commonCellStyle);
  1101. commonCellStyle.setVerticalAlignment(VerticalAlignment.TOP);
  1102. commonCellStyle.setWrapText(true);
  1103. cell.setCellStyle(commonCellStyle);
  1104. if (key.equals("摘要附图")) {
  1105. if (StringUtils.isNotEmpty(patent.getAbstractPath())) {
  1106. try {
  1107. byte[] pictureData = FileUtil.readBytes(fileUtils.getSystemPath(patent.getAbstractPath()));
  1108. if (pictureData != null) {
  1109. ExcelUtils.writePicture(sheet, index, i + 1, pictureData, HSSFWorkbook.PICTURE_TYPE_JPEG);
  1110. }
  1111. row.setHeight((short) 2500);
  1112. } catch (Exception e) {
  1113. }
  1114. }
  1115. } else if (StringUtils.isNotNull(map.get(key))) {
  1116. cell.setCellValue(String.valueOf(map.get(key)));
  1117. }
  1118. }
  1119. }
  1120. Integer total = ids.size();
  1121. WebSocketServer.sendInfo(Response.websocket(new TaskWebSocketDTO()
  1122. .setTaskId(taskParams.getTaskId())
  1123. .setProjectId(taskParams.getProjectId())
  1124. .setComplete(false)
  1125. .setIndex(i)
  1126. .setTaskType(Constants.TASK_EXPORT_PATENT)
  1127. .setPercentage(total == 0 ? 0 : Math.round((total.equals(i) ? (i * 1D) : (i + 1D)) / total * 100D))
  1128. .setFileName("")
  1129. .setOldName("")
  1130. .setUrl("")
  1131. .setTotal(total), ResponseEnum.PATENT_EXPORT_TASK_SUCCESS), taskParams.getUserId());
  1132. }
  1133. FileOutputStream fos = new FileOutputStream(savePath + fileName);
  1134. hssfWorkbook.write(fos);
  1135. fos.flush();
  1136. fos.close();
  1137. String url = fileUtils.getDirectory(fileName);
  1138. taskService.updateTime(taskParams.getTaskId(), 2, DateUtils.getDateTime(), url, fileName);
  1139. WebSocketServer.sendInfo(Response.websocket(new TaskWebSocketDTO()
  1140. .setTaskId(taskParams.getTaskId())
  1141. .setProjectId(taskParams.getProjectId())
  1142. .setComplete(true)
  1143. .setIndex(ids.size())
  1144. .setTaskType(Constants.TASK_EXPORT_PATENT)
  1145. .setPercentage(100L)
  1146. .setFileName(fileName)
  1147. .setOldName("")
  1148. .setUrl(url)
  1149. .setTotal(ids.size()), ResponseEnum.PATENT_EXPORT_TASK_SUCCESS), taskParams.getUserId());
  1150. }
  1151. } catch (Exception e) {
  1152. e.printStackTrace();
  1153. taskService.updateTime(taskParams.getTaskId(), 3, DateUtils.getDateTime(), null, null);
  1154. WebSocketServer.sendInfo(Response.error(ResponseEnum.PATENT_EXPORT_TASK_ERROR), taskParams.getUserId());
  1155. }
  1156. }
  1157. public IPage<PatentQueryFieldSourceDTO> getPatentQuerySourcePageList(PatentQueryFieldSourceVO params) {
  1158. return this.getPatentAttributeSourcePageList(params);
  1159. }
  1160. public IPage<PatentQueryFieldSourceDTO> getPatentAttributeSourcePageList(PatentQueryFieldSourceVO params) {
  1161. this.setPatentQuerySourceParams(params);
  1162. if (params.getKey().equals("40-0")) {
  1163. Integer projectId = params.getProjectId();
  1164. List<PatentQueryFieldSourceDTO> dataList = baseMapper.getCountStatus(projectId);
  1165. List<PatentQueryFieldSourceDTO> lstA = new ArrayList<>();
  1166. List<PatentQueryFieldSourceDTO> lstB = new ArrayList<>();
  1167. dataList.forEach(item -> {
  1168. if (StringUtils.changeStringToString(item.getLabel(), "\\|").size() > 1) {
  1169. lstA.add(item);
  1170. } else {
  1171. lstB.add(item);
  1172. }
  1173. });
  1174. lstA.forEach(item -> {
  1175. List<String> stringList = StringUtils.changeStringToString(item.getLabel(), "\\|");
  1176. stringList.forEach(x -> {
  1177. List<PatentQueryFieldSourceDTO> lstC = new ArrayList<>();
  1178. for (PatentQueryFieldSourceDTO patentQueryFieldSourceDTO : lstB) {
  1179. if (!lstB.stream().map(PatentQueryFieldSourceDTO::getLabel).collect(Collectors.toList()).contains(x)) {
  1180. PatentQueryFieldSourceDTO a = new PatentQueryFieldSourceDTO();
  1181. a.setCount(item.getCount());
  1182. a.setLabel(x);
  1183. lstC.add(a);
  1184. break;
  1185. }
  1186. if (patentQueryFieldSourceDTO.getLabel().equals(x)) {
  1187. patentQueryFieldSourceDTO.setCount(patentQueryFieldSourceDTO.getCount() + item.getCount());
  1188. }
  1189. }
  1190. lstB.addAll(lstC);
  1191. });
  1192. });
  1193. List<SystemDict> systemDictList = systemDictService.getSystemDictListByType(Collections.singletonList(Constants.PATENT_STATUS));
  1194. lstB.forEach(b -> {
  1195. Integer status = Integer.parseInt(systemDictList.stream()
  1196. .filter(systemDict -> systemDict.getType().equals(Constants.PATENT_STATUS) && systemDict.getLabel().equals(b.getLabel()))
  1197. .findFirst()
  1198. .orElse(new SystemDict()).getValue());
  1199. b.setValue(String.valueOf(status));
  1200. });
  1201. IPage<PatentQueryFieldSourceDTO> pageList = baseMapper.getPatentQuerySourcePageList(new Page<>(params.getCurrent(), params.getSize()), params, new ArrayList<>());
  1202. pageList.setRecords(lstB);
  1203. return pageList;
  1204. }
  1205. IPage<PatentQueryFieldSourceDTO> pageList = baseMapper.getPatentQuerySourcePageList(new Page<>(params.getCurrent(), params.getSize()), params, new ArrayList<>());
  1206. pageList.getRecords().forEach(item -> item.setIds(null));
  1207. return pageList;
  1208. }
  1209. public List<PatentQueryFieldSourceDTO> getPatentAttributeSourceList(PatentQueryFieldSourceVO params, List<Integer> patentIds) {
  1210. this.setPatentQuerySourceParams(params);
  1211. List<PatentQueryFieldSourceDTO> dataList = baseMapper.getPatentQuerySourcePageList(params, patentIds);
  1212. return dataList;
  1213. }
  1214. private void setPatentQuerySourceParams(PatentQueryFieldSourceVO params) {
  1215. List<Integer> field = StringUtils.changeStringToInteger(params.getKey(), "-");
  1216. Integer type = 0;
  1217. Integer level = 0;
  1218. Integer status = 0;
  1219. switch (params.getKey()) {
  1220. case "18-6":
  1221. case "18-7":
  1222. case "18-8":
  1223. case "23-6":
  1224. case "23-7":
  1225. case "23-8":
  1226. params.setApplicantType(2);
  1227. break;
  1228. case "19-6":
  1229. case "19-7":
  1230. case "19-8":
  1231. case "24-6":
  1232. case "24-7":
  1233. case "24-8":
  1234. params.setApplicantType(1);
  1235. break;
  1236. case "29-17":
  1237. case "30-17":
  1238. case "29-18":
  1239. case "29-19":
  1240. case "29-20":
  1241. case "30-18":
  1242. case "30-19":
  1243. case "30-20":
  1244. params.setApplicantType(field.get(0) == 29 ? 2 : 1);
  1245. break;
  1246. default:
  1247. params.setCustomFieldId(field.get(0));
  1248. if (params.getType().equals("6") && field.get(1).equals(0)) {
  1249. params.setCustomFieldTreeType(0);
  1250. } else {
  1251. params.setCustomFieldTreeType(null);
  1252. }
  1253. }
  1254. }
  1255. public void updatePatentCustomField(PatentCustomFieldParams params) {
  1256. List<CustomFieldDTO> dataList = new ArrayList<>();
  1257. for (String key : params.keySet()) {
  1258. List<String> fields = StringUtils.changeStringToString(key, ":");
  1259. if (fields.size() == 2) {
  1260. Object name = fields.get(0);
  1261. Object selected = params.get(key);
  1262. List<String> select = JsonUtils.jsonToList(JsonUtils.objectToJson(selected), String.class);
  1263. if (StringUtils.isNull(select)) {
  1264. select = new ArrayList<>();
  1265. }
  1266. CustomFieldDTO data = new CustomFieldDTO();
  1267. data.setName(name.toString());
  1268. data.setSelected(select);
  1269. data.setType(Integer.parseInt(fields.get(1)));
  1270. dataList.add(data);
  1271. }
  1272. }
  1273. for (CustomFieldDTO data : dataList) {
  1274. ProjectField projectField = projectFieldService.getProjectFieldByNameAndType(data.getName(), data.getType(), params.getProjectId(), params.getUserId());
  1275. projectFieldPatentLinkService.deleteByPatentIdAndProjectIdAndFieldId(params.getPatentId(), params.getProjectId(), projectField.getId());
  1276. switch (projectField.getType()) {
  1277. case 0:
  1278. case 1:
  1279. case 2:
  1280. for (String text : data.getSelected()) {
  1281. ProjectFieldText projectFieldText = projectFieldTextService.getProjectFieldTextByNameAndFieldId(text, projectField.getId());
  1282. if (projectFieldText == null) {
  1283. projectFieldText = new ProjectFieldText();
  1284. projectFieldText.setFieldId(projectField.getId());
  1285. projectFieldText.setText(text);
  1286. projectFieldText.insert();
  1287. }
  1288. projectFieldPatentLinkService.updateProjectPatentLink(params.getPatentId(), projectField.getType(), projectField.getId(), projectFieldText.getId(), params.getUserId(), params.getProjectId());
  1289. }
  1290. break;
  1291. case 3:
  1292. case 4:
  1293. case 5:
  1294. for (String option : data.getSelected()) {
  1295. ProjectFieldOption projectFieldOption = projectFieldOptionService.getProjectFieldOptionByNameAndFieldId(option, projectField.getId());
  1296. if (projectFieldOption == null) {
  1297. projectFieldOption = new ProjectFieldOption();
  1298. projectFieldOption.setFieldId(projectField.getId());
  1299. projectFieldOption.setName(option);
  1300. projectFieldOption.insert();
  1301. }
  1302. projectFieldPatentLinkService.updateProjectPatentLink(params.getPatentId(), projectField.getType(), projectField.getId(), projectFieldOption.getId(), params.getUserId(), params.getProjectId());
  1303. }
  1304. break;
  1305. case 6:
  1306. for (String tree : data.getSelected()) {
  1307. List<String> treeNode = StringUtils.changeStringToString(tree, "\\\\");
  1308. Integer treeNodeId = projectFieldTreeService.getTreeNodeIdByPathNameAndUpdateTreeData(treeNode, projectField);
  1309. if (treeNodeId != 0) {
  1310. projectFieldPatentLinkService.updateProjectPatentLink(params.getPatentId(), projectField.getType(), projectField.getId(), treeNodeId, params.getUserId(), params.getProjectId());
  1311. }
  1312. }
  1313. break;
  1314. }
  1315. }
  1316. }
  1317. public Map<String, Object> getBetweenPatentList(PatentVO params) {
  1318. this.setQueryPatentParams(params);
  1319. List<Patent> patentList = baseMapper.getPageList(params);
  1320. int index = patentList.stream().map(Patent::getId).collect(Collectors.toList()).indexOf(params.getPatentId());
  1321. Map<String, Object> map = new HashMap<>();
  1322. if (index > 0) {
  1323. Patent patent = patentList.get(index - 1);
  1324. Map<String, Object> prev = new HashMap<>();
  1325. prev.put("id", patent.getId());
  1326. prev.put("patentNo", patent.getPatentNo());
  1327. prev.put("total", index);
  1328. map.put("prev", prev);
  1329. }
  1330. if (index < patentList.size() - 1) {
  1331. Patent patent = patentList.get(index + 1);
  1332. Map<String, Object> next = new HashMap<>();
  1333. next.put("id", patent.getId());
  1334. next.put("patentNo", patent.getPatentNo());
  1335. next.put("total", patentList.size() - index - 1);
  1336. map.put("next", next);
  1337. }
  1338. return map;
  1339. }
  1340. public void importPatent(Integer projectId, String patentJson, String patentAffairJson, String patentAgencyJson, String patentFamilyJson, String patentFamilyLinkJson, String patentInventorJson, String patentInventorLinkJson, String patentAgentJson, String patentAgentLinkJson, String patentApplicantJson, String patentApplicantLinkJson, String patentApplicantMergeLinkJson, String patentClassNumberJson, String patentInstructionTextJson, String patentRightJson, String patentLicensorJson, String patentPledgeJson, String patentInventorMergeJson) {
  1341. List<Patent> importPatentList = JsonUtils.jsonToList(patentJson, Patent.class);
  1342. List<PatentAffair> importPatentAffairList = JsonUtils.jsonToList(patentAffairJson, PatentAffair.class);
  1343. List<PatentAgency> importPatentAgencyList = JsonUtils.jsonToList(patentAgencyJson, PatentAgency.class);
  1344. List<PatentAgent> importPatentAgentList = JsonUtils.jsonToList(patentAgentJson, PatentAgent.class);
  1345. List<PatentAgentLink> importPatentAgentLinkList = JsonUtils.jsonToList(patentAgentLinkJson, PatentAgentLink.class);
  1346. List<PatentInventor> importPatentInventorList = JsonUtils.jsonToList(patentInventorJson, PatentInventor.class);
  1347. List<PatentInventorMerge> importPatentInventorMergeList = JsonUtils.jsonToList(patentInventorMergeJson, PatentInventorMerge.class);
  1348. List<PatentInventorLink> importPatentInventorLinkList = JsonUtils.jsonToList(patentInventorLinkJson, PatentInventorLink.class);
  1349. List<PatentApplicant> importPatentApplicantList = JsonUtils.jsonToList(patentApplicantJson, PatentApplicant.class);
  1350. List<PatentApplicantLink> importPatentApplicantLinkList = JsonUtils.jsonToList(patentApplicantLinkJson, PatentApplicantLink.class);
  1351. List<PatentApplicantMergeLink> importPatentApplicantMergeLinkList = JsonUtils.jsonToList(patentApplicantMergeLinkJson, PatentApplicantMergeLink.class);
  1352. List<PatentSimpleFamily> importPatentSimpleFamilyList = JsonUtils.jsonToList(patentFamilyJson, PatentSimpleFamily.class);
  1353. List<PatentSimpleFamilyLink> importPatentSimpleFamilyLinkList = JsonUtils.jsonToList(patentFamilyLinkJson, PatentSimpleFamilyLink.class);
  1354. List<PatentClassNumberLink> importPatentClassNumberLinkList = JsonUtils.jsonToList(patentClassNumberJson, PatentClassNumberLink.class);
  1355. List<PatentInstructionText> importPatentInstructionTextList = JsonUtils.jsonToList(patentInstructionTextJson, PatentInstructionText.class);
  1356. List<PatentRight> importPatentRightList = JsonUtils.jsonToList(patentRightJson, PatentRight.class);
  1357. List<PatentLicensor> importPatentLicensorList = JsonUtils.jsonToList(patentLicensorJson, PatentLicensor.class);
  1358. List<PatentPledge> importPatentPledgeList = JsonUtils.jsonToList(patentPledgeJson, PatentPledge.class);
  1359. List<Patent> localPatentList = this.getPatentListByPatentNo(importPatentList.stream().map(Patent::getPatentNo).collect(Collectors.toList()));
  1360. List<Patent> patentList = new ArrayList<>();
  1361. for (Patent importPatent : importPatentList) {
  1362. Patent localPatent = localPatentList.stream().filter(item -> item.getPatentNo().equals(importPatent.getPatentNo())).findFirst().orElse(null);
  1363. Integer patentId;
  1364. if (localPatent == null) {
  1365. localPatent = new Patent();
  1366. patentId = null;
  1367. } else {
  1368. patentId = localPatent.getId();
  1369. }
  1370. BeanUtils.copyProperties(importPatent, localPatent);
  1371. localPatent.setId(patentId);
  1372. if (StringUtils.isNotEmpty(importPatent.getAgencyId())) {
  1373. PatentAgency importPatentAgency = importPatentAgencyList.stream().filter(item -> item.getId().equals(Integer.valueOf(importPatent.getAgencyId()))).findFirst().orElse(new PatentAgency());
  1374. localPatent.setAgencyId(patentAgencyService.getAgencyStringIdByName(importPatentAgency.getName()));
  1375. }
  1376. localPatent.insertOrUpdate();
  1377. patentList.add(localPatent);
  1378. }
  1379. for (Patent patent : patentList) {
  1380. Patent importPatent = importPatentList.stream().filter(item -> item.getPatentNo().equals(patent.getPatentNo())).findFirst().orElse(new Patent());
  1381. patentAffairService.importPatentAffair(patent, importPatentList, importPatentAffairList);
  1382. patentAgentService.importPatentAgent(patent.getId(), importPatent.getId(), importPatentAgentList, importPatentAgentLinkList);
  1383. patentSimpleFamilyService.importPatentSimpleFamily(patent, importPatentSimpleFamilyList, importPatentSimpleFamilyLinkList);
  1384. patentInventorService.importPatentInventor(patent.getId(), importPatent.getId(), importPatentInventorList, importPatentInventorLinkList);
  1385. patentApplicantService.importPatentApplicant(projectId, patent.getId(), importPatent.getId(), importPatentApplicantList, importPatentApplicantLinkList);
  1386. patentClassNumberLinkService.importPatentClassNumberLink(patent.getId(), importPatent.getId(), importPatentClassNumberLinkList);
  1387. patentInstructionTextService.importPatentInstructionText(patent.getId(), importPatent.getId(), importPatentInstructionTextList);
  1388. patentRightService.importPatentRight(patent.getId(), importPatent.getId(), importPatentRightList);
  1389. patentLicensorService.importPatentLicensor(patent.getId(), importPatent.getId(), importPatentLicensorList);
  1390. patentPledgeService.importPatentPledge(patent.getId(), importPatent.getId(), importPatentPledgeList);
  1391. }
  1392. patentInventorMergeService.importPatentInventorMergeLink(projectId, importPatentInventorList, importPatentInventorMergeList);
  1393. patentApplicantMergeLinkService.importPatentApplicantMergeLink(projectId, importPatentApplicantList, importPatentApplicantMergeLinkList);
  1394. }
  1395. public String getPatentNos(Integer projectId) {
  1396. //根据专题库号获得专利id
  1397. LambdaQueryWrapper<ProjectPatentLink> wrapper = new LambdaQueryWrapper<>();
  1398. wrapper.select(ProjectPatentLink::getPatentId).eq(ProjectPatentLink::getProjectId, projectId);
  1399. List<ProjectPatentLink> projectPatentLinkList = projectPatentLinkService.list(wrapper);
  1400. List<Integer> patentIds = projectPatentLinkList.stream().map(ProjectPatentLink::getPatentId).collect(Collectors.toList());
  1401. //根据专利Id获得专利号
  1402. LambdaQueryWrapper<Patent> queryWrapper = new LambdaQueryWrapper<>();
  1403. queryWrapper.in(Patent::getId, patentIds);
  1404. List<Patent> patents = this.list(queryWrapper);
  1405. List<String> patentNos = patents.stream().map(Patent::getPatentNo).collect(Collectors.toList());
  1406. return Response.success(patentNos);
  1407. }
  1408. public String getPagination(List<String> list,int location){
  1409. Map map=new HashMap();
  1410. LambdaQueryWrapper<Patent> wrapper =new LambdaQueryWrapper<>();
  1411. wrapper.in(Patent::getPatentNo,list);
  1412. Integer totalNumber = Math.toIntExact(this.count(wrapper));
  1413. if(location>=totalNumber){
  1414. location=totalNumber;
  1415. int a=location-2;
  1416. int b=2;
  1417. List<Patent> patent = patentMapper.getPatent(list, a, b);
  1418. int front=location-1;
  1419. String str1 =patent.get(0).getPatentNo();
  1420. String srr2= patent.get(1).getPatentNo();
  1421. int i=patent.get(0).getId();
  1422. int j=patent.get(1).getId();
  1423. map.put("frontID",i);
  1424. map.put("currentID",j);
  1425. map.put("behindPatentNo",null);
  1426. map.put("frontNumber",front);
  1427. map.put("behindNumber",0);
  1428. map.put("frontPatentNo",str1);
  1429. map.put("currentPatentNo",srr2);
  1430. map.put("totalNumber",totalNumber);
  1431. return Response.success(map);
  1432. }
  1433. if(location==1){
  1434. int a=0;
  1435. int p=2;
  1436. List<Patent> patent = patentMapper.getPatent(list, a, p);
  1437. String str1 =patent.get(0).getPatentNo();
  1438. String srr2= patent.get(1).getPatentNo();
  1439. int i=patent.get(0).getId();
  1440. int j=patent.get(1).getId();
  1441. map.put("currentID",i);
  1442. map.put("behindID",j);
  1443. map.put("currentPatentNo",str1);
  1444. map.put("behindPatentNo",srr2);
  1445. map.put("frontPatentNo",null);
  1446. map.put("frontNumber",0);
  1447. int behindNumber=totalNumber-location;
  1448. map.put("behindNumber",behindNumber);
  1449. map.put("totalNumber",totalNumber);
  1450. return Response.success(map);
  1451. }
  1452. int a=location-2;
  1453. int p=3;
  1454. List<Patent> patent = patentMapper.getPatent(list, a, p);
  1455. String str1 =patent.get(0).getPatentNo();
  1456. String str2 =patent.get(1).getPatentNo();
  1457. String str3 =patent.get(2).getPatentNo();
  1458. int i=patent.get(0).getId();
  1459. int j=patent.get(1).getId();
  1460. int k=patent.get(2).getId();
  1461. map.put("frontID",i);
  1462. map.put("currentID",j);
  1463. map.put("behindID",k);
  1464. map.put("frontPatentNo",str1);
  1465. map.put("currentPatentNo",str2);
  1466. map.put("behindPatentNo",str3);
  1467. map.put("totalNumber",totalNumber);
  1468. int behindNumber=totalNumber-location;
  1469. int frontNumber=location-1;
  1470. map.put("behindNumber",behindNumber);
  1471. map.put("frontNumber",frontNumber);
  1472. return Response.success(map);
  1473. }
  1474. }