SampleXxlJob.java 46 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950
  1. package com.trs.project.exchange;
  2. import com.alibaba.fastjson.JSONArray;
  3. import com.alibaba.fastjson.JSONObject;
  4. import com.trs.project.entity.*;
  5. import com.trs.project.service.*;
  6. import com.trs.project.util.Base64Util;
  7. import com.trs.project.util.GpDESUtils;
  8. import com.trs.project.util.RSAUtils;
  9. import com.xxl.job.core.context.XxlJobHelper;
  10. import com.xxl.job.core.handler.annotation.XxlJob;
  11. import generator.ZrzyCkqBidwinnoticeDao;
  12. import org.slf4j.Logger;
  13. import org.slf4j.LoggerFactory;
  14. import org.springframework.beans.factory.annotation.Autowired;
  15. import org.springframework.http.*;
  16. import org.springframework.http.converter.StringHttpMessageConverter;
  17. import org.springframework.stereotype.Component;
  18. import org.springframework.util.LinkedMultiValueMap;
  19. import org.springframework.util.MultiValueMap;
  20. import org.springframework.util.StringUtils;
  21. import org.springframework.web.client.RestTemplate;
  22. import java.nio.charset.StandardCharsets;
  23. import java.text.ParseException;
  24. import java.text.SimpleDateFormat;
  25. import java.util.ArrayList;
  26. import java.util.Date;
  27. import java.util.List;
  28. /**
  29. * XxlJob开发示例(Bean模式)
  30. *
  31. * 开发步骤:
  32. * 1、任务开发:在Spring Bean实例中,开发Job方法;
  33. * 2、注解配置:为Job方法添加注解 "@XxlJob(value="自定义jobhandler名称", init = "JobHandler初始化方法", destroy = "JobHandler销毁方法")",注解value值对应的是调度中心新建任务的JobHandler属性的值。
  34. * 3、执行日志:需要通过 "XxlJobHelper.log" 打印执行日志;
  35. * 4、任务结果:默认任务结果为 "成功" 状态,不需要主动设置;如有诉求,比如设置任务结果为失败,可以通过 "XxlJobHelper.handleFail/handleSuccess" 自主设置任务结果;
  36. *
  37. * @author xuxueli 2019-12-11 21:52:51
  38. */
  39. @Component
  40. public class SampleXxlJob {
  41. private static Logger logger = LoggerFactory.getLogger(SampleXxlJob.class);
  42. @Autowired
  43. private RestTemplate restTemplate;
  44. @Autowired
  45. private GcNoticeandfileService gcNoticeandfileService;//1、工程-招标公告与资格预审公告【GC_NOTICEANDFILE】
  46. @Autowired
  47. private GcBidopenrecordService gcBidopenrecordService;//3、工程-开标记录【GC_BIDOPENRECORD】
  48. @Autowired
  49. private GcBidcandidatePostService gcBidcandidatePostService;//4、工程-中标候选人公示【GC_BIDCANDIDATE_POST】
  50. @Autowired
  51. private GcBidpublicityService gcBidpublicityService;//5、工程-中标结果公示【GC_BIDPUBLICITY】
  52. @Autowired
  53. private GcProjectService gcProjectService;//6、工程-项目【GC_PROJECT】
  54. @Autowired
  55. private GcTenderprojectService gcTenderprojectService;//7、工程-招标项目【GC_TENDERPROJECT】
  56. @Autowired
  57. private GcTenderbidfileService gcTenderbidfileService;//8、工程-招标文件/招标文件澄清与修改【Tenderbidfile
  58. @Autowired
  59. private GcPubContractService gcPubContractService;//9、工程-合同签订【GC_PUB_CONTRACT】
  60. @Autowired
  61. private GcPerformanceService gcPerformanceService;//10、工程-合同履约【GC_PERFORMANCE】
  62. @Autowired
  63. private GcBidExceptioNoticeService gcBidExceptioNoticeService;//11、工程-招标异常公告【GC_BID_EXCEPTIO_NOTICE】
  64. @Autowired
  65. private GcAttachmentService gcAttachmentService;//12、工程-附件集结构【GC_ATTACHMENT】
  66. @Autowired
  67. private TaskRecordService taskRecordService;
  68. @Autowired
  69. private GcBidopenFileService gcBidopenFileService;//13、工程-开标明细数据集【GC_BIDOPEN_FILE】
  70. @Autowired
  71. private GcPackageService gcPackageService;//
  72. @Autowired
  73. private ZrzyTdCedeNoticeService zrzyTdCedeNoticeService;//20、自然资源-土地出让公告信息【ZRZY_TD_CEDE_NOTICE】
  74. @Autowired
  75. private ZrzyTdBidwinnoticeService zrzyTdBidwinnoticeService;//21、自然资源-土地成交结果公告【ZRZY_TD_BIDWINNOTICE】
  76. @Autowired
  77. private CqSwIssueBulletinService cqSwIssueBulletinService;//30、国有产权-实物资产挂牌披露信息【CQ_SW_ISSUE_BULLETIN】
  78. @Autowired
  79. private CqSwBargainResultService cqSwBargainResultService;//31、国有产权-实物资产交易结果信息【CQ_SW_BARGAIN_RESULT】】
  80. @Autowired
  81. private ZtLegalinfoService ztLegalinfoService;//100、主体库
  82. @Autowired
  83. private YcNoticeService ycNoticeService;//200、药采公告
  84. @Autowired
  85. private JgFieldApplyService jgFieldApplyService;
  86. @Autowired
  87. private JgSiteInformationService jgSiteInformationService;//
  88. @Autowired
  89. private CqGqIssueBulletinService cqGqIssueBulletinService;//
  90. @Autowired
  91. private CqGqBargainResultService cqGqBargainResultService;//
  92. @Autowired
  93. private ZrzyCkqNoticeService zrzyCkqNoticeService;//
  94. @Autowired
  95. private ZrzyCkqBidwinnoticeService zrzyCkqBidwinnoticeService;//
  96. @Autowired
  97. private ZrzyCkqProjectInfoService zrzyCkqProjectInfoService;//
  98. @Autowired
  99. private ZrzyTkqNoticeService zrzyTkqNoticeService;//
  100. @Autowired
  101. private ZrzyTkqBidwinnoticeService zrzyTkqBidwinnoticeService;//
  102. @Autowired
  103. private ZrzyTkqProjectInfoService zrzyTkqProjectInfoService;
  104. @Autowired
  105. private ZrzyBgBidwinNoticeService zrzyBgBidwinNoticeService;
  106. @Autowired
  107. private ZrzyBgNoticeService zrzyBgNoticeService;
  108. @Autowired
  109. private ZrzyBgStockIndexService zrzyBgStockIndexService;
  110. @Autowired
  111. private ZrzyDkBinwinNoticeService zrzyDkBinwinNoticeService;
  112. @Autowired
  113. private ZrzyDkNoticeService zrzyDkNoticeService;
  114. @Autowired
  115. private ZrzyDkProjectService zrzyDkProjectService;
  116. @Autowired
  117. private ZrzyJyzbBidwinNoticeService zrzyJyzbBidwinNoticeService;
  118. @Autowired
  119. private ZrzyJyzbNoticeService zrzyJyzbNoticeService;
  120. @Autowired
  121. private ZrzyJyzbStockIndexService zrzyJyzbStockIndexService;
  122. @Autowired
  123. private ZrzyTdCedeInfoService zrzyTdCedeInfoService;
  124. @Autowired
  125. private CqGqProjectService cqGqProjectService;
  126. @Autowired
  127. private CqSwProjectService cqSwProjectService;
  128. @Autowired
  129. private NmNoticeService nmNoticeService;
  130. @Autowired
  131. private NmProjectService nmProjectService;
  132. @Autowired
  133. private NmResultNoticeService nmResultNoticeService;
  134. @Autowired
  135. private ZfcgGongaoService zfcgGongaoService;
  136. /**
  137. * 1、工程-招标公告与资格预审公告【GC_NOTICEANDFILE】
  138. */
  139. @XxlJob("task_GC_NOTICEANDFILE")
  140. public void GC_NOTICEANDFILE() throws Exception {
  141. detailMethod(1);//1:post 0:get
  142. }
  143. /**
  144. * 2、工程-招标异常公告【GC_BID_EXCEPTIO_NOTICE】
  145. */
  146. /* @XxlJob("task_GC_BID_EXCEPTIO_NOTICE")
  147. public void GC_BID_EXCEPTIO_NOTICE() throws Exception {
  148. detailMethod(1);//1:post 0:get
  149. }*/
  150. /**
  151. * 3、工程-开标记录【GC_BIDOPENRECORD】
  152. */
  153. @XxlJob("task_GC_BIDOPENRECORD")
  154. public void GC_BIDOPENRECORD() throws Exception {
  155. detailMethod(1);//1:post 0:get
  156. }
  157. /**
  158. * 4、工程-中标候选人公示【GC_BIDCANDIDATE_POST】
  159. */
  160. @XxlJob("task_GC_BIDCANDIDATE_POST")
  161. public void GC_BIDCANDIDATE_POST() throws Exception {
  162. detailMethod(1);//1:post 0:get
  163. }
  164. /**
  165. * 5、工程-中标结果公示【GC_BIDPUBLICITY】
  166. */
  167. @XxlJob("task_GC_BIDPUBLICITY")
  168. public void GC_BIDPUBLICITY() throws Exception {
  169. detailMethod(1);//1:post 0:get
  170. }
  171. /**
  172. * 6、工程-项目【GC_PROJECT】
  173. */
  174. @XxlJob("task_GC_PROJECT")
  175. public void GC_PROJECT() throws Exception {
  176. detailMethod(1);//1:post 0:get
  177. }
  178. /**
  179. * 7、工程-招标项目【GC_TENDERPROJECT】
  180. */
  181. @XxlJob("task_GC_TENDERPROJECT")
  182. public void GC_TENDERPROJECT() throws Exception {
  183. detailMethod(1);//1:post 0:get
  184. }
  185. /**
  186. * 8、工程-招标文件/招标文件澄清与修改【GC_TENDERBIDFILE】
  187. */
  188. @XxlJob("task_GC_TENDERBIDFILE")
  189. public void GC_TENDERBIDFILE() throws Exception {
  190. detailMethod(1);//1:post 0:get
  191. }
  192. /**
  193. * 9、工程-合同签订【GC_PUB_CONTRACT】
  194. */
  195. @XxlJob("task_GC_PUB_CONTRACT")
  196. public void GC_PUB_CONTRACT() throws Exception {
  197. detailMethod(1);//1:post 0:get
  198. }
  199. /**
  200. * 10、工程-合同履约【GC_PERFORMANCE】
  201. */
  202. @XxlJob("task_GC_PERFORMANCE")
  203. public void GC_PERFORMANCE() throws Exception {
  204. detailMethod(1);//1:post 0:get
  205. }
  206. /**
  207. * 11、工程-招标异常公告【GC_BID_EXCEPTIO_NOTICE】
  208. */
  209. @XxlJob("task_GC_BID_EXCEPTIO_NOTICE")
  210. public void GC_BID_EXCEPTIO_NOTICE() throws Exception {
  211. detailMethod(1);//1:post 0:get
  212. }
  213. /**
  214. * 12、工程-附件集结构【GC_ATTACHMENT】
  215. */
  216. @XxlJob("task_GC_ATTACHMENT")
  217. public void GC_ATTACHMENT() throws Exception {
  218. detailMethod(1);//1:post 0:get
  219. }
  220. /**
  221. * 13、工程-开标明细数据集【GC_BIDOPEN_FILE】
  222. */
  223. @XxlJob("task_GC_BIDOPEN_FILE")
  224. public void GC_BIDOPEN_FILE() throws Exception {
  225. detailMethod(1);//1:post 0:get
  226. }
  227. /**
  228. * 16、工程-标段(包)【GC_PACKAGE】
  229. */
  230. @XxlJob("task_GC_PACKAGE")
  231. public void GC_PACKAGE() throws Exception {
  232. detailMethod(1);//1:post 0:get
  233. }
  234. /**
  235. * 14、场地预约【JG_FIELDAPPLY】
  236. */
  237. @XxlJob("task_JG_FIELDAPPLY")
  238. public void JG_FIELDAPPLY() throws Exception {
  239. detailMethod(1);//1:post 0:get
  240. }
  241. /**
  242. * 15、场地信息【JG_SITE_INFORMATION】
  243. */
  244. @XxlJob("task_JG_SITE_INFORMATION")
  245. public void JG_SITE_INFORMATION() throws Exception {
  246. detailMethod(0);//1:post 0:get
  247. }
  248. /**
  249. * 20、自然资源-土地出让公告信息【ZRZY_TD_CEDE_NOTICE】
  250. */
  251. @XxlJob("task_ZRZY_TD_CEDE_NOTICE")
  252. public void ZRZY_TD_CEDE_NOTICE() throws Exception {
  253. detailMethod(1);//1:post 0:get
  254. }
  255. /**
  256. * 21、自然资源-土地成交结果公告【ZRZY_TD_BIDWINNOTICE】
  257. */
  258. @XxlJob("task_ZRZY_TD_BIDWINNOTICE")
  259. public void ZRZY_TD_BIDWINNOTICE() throws Exception {
  260. detailMethod(1);//1:post 0:get
  261. }
  262. /**
  263. * 22、自然资源-探矿权招拍挂公告信息【ZRZY_TKQ_NOTICE】
  264. */
  265. @XxlJob("task_ZRZY_TKQ_NOTICE")
  266. public void ZRZY_ZRZY_TKQ_NOTICE() throws Exception {
  267. detailMethod(0);//1:post 0:get
  268. }
  269. /**
  270. * 23、自然资源-探矿权招拍挂结果公示信息【ZRZY_TKQ_BIDWINNOTICE】
  271. */
  272. @XxlJob("task_ZRZY_TKQ_BIDWINNOTICE")
  273. public void ZRZY_TKQ_BIDWINNOTICE() throws Exception {
  274. detailMethod(0);//1:post 0:get
  275. }
  276. /**
  277. * 24、自然资源-采矿权招拍挂公告信息【ZRZY_CKQ_NOTICE】
  278. */
  279. @XxlJob("task_ZRZY_CKQ_NOTICE")
  280. public void ZRZY_CKQ_NOTICE() throws Exception {
  281. detailMethod(0);//1:post 0:get
  282. }
  283. /**
  284. * 25、自然资源-采矿权招拍挂结果公示信息【ZRZY_CKQ_BIDWINNOTICE】
  285. */
  286. @XxlJob("task_ZRZY_CKQ_BIDWINNOTICE")
  287. public void ZRZY_CKQ_BIDWINNOTICE() throws Exception {
  288. detailMethod(0);//1:post 0:get
  289. }
  290. /**
  291. * 30、国有产权-实物资产挂牌披露信息【CQ_SW_ISSUE_BULLETIN】
  292. */
  293. @XxlJob("task_CQ_SW_ISSUE_BULLETIN")
  294. public void CQ_SW_ISSUE_BULLETIN() throws Exception {
  295. detailMethod(1);//1:post 0:get
  296. }
  297. /**
  298. * 31、国有产权-实物资产交易结果信息【CQ_SW_BARGAIN_RESULT】】
  299. */
  300. @XxlJob("task_CQ_SW_BARGAIN_RESULT")
  301. public void CQ_SW_BARGAIN_RESULT() throws Exception {
  302. detailMethod(1);//1:post 0:get
  303. }
  304. /**
  305. * 32、国有产权-挂牌披露信息【CQ_GQ_ISSUE_BULLETIN】
  306. */
  307. @XxlJob("task_CQ_GQ_ISSUE_BULLETIN")
  308. public void CQ_GQ_ISSUE_BULLETIN() throws Exception {
  309. detailMethod(1);//1:post 0:get
  310. }
  311. /**
  312. * 33、国有产权-交易结果信息【CQ_GQ_BARGAIN_RESULT】
  313. */
  314. @XxlJob("task_CQ_GQ_BARGAIN_RESULT")
  315. public void CQ_GQ_BARGAIN_RESULT() throws Exception {
  316. detailMethod(1);//1:post 0:get
  317. }
  318. /**
  319. * 100、法人基本信息【ZT_LEGALINFO】
  320. */
  321. @XxlJob("task_ZT_LEGALINFO")
  322. public void ZT_LEGALINFO() throws Exception {
  323. detailMethod(1);//1:post 0:get
  324. }
  325. /**
  326. * 200、药采公告 【YC_NOTICE】
  327. */
  328. @XxlJob("task_YC_NOTICE")
  329. public void YC_NOTICE() throws Exception {
  330. detailMethod(1);//1:post 0:get
  331. }
  332. /**
  333. * 26、自然资源-探矿权项目信息【ZRZY_TKQ_PROJECT_INFO】
  334. */
  335. @XxlJob("task_ZRZY_TKQ_PROJECT_INFO")
  336. public void ZRZY_TKQ_PROJECT_INFO() throws Exception {
  337. detailMethod(0);//1:post 0:get
  338. }
  339. /**
  340. * 27、自然资源-采矿权项目信息【ZRZY_CKQ_PROJECT_INFO】
  341. */
  342. @XxlJob("task_ZRZY_CKQ_PROJECT_INFO")
  343. public void ZRZY_CKQ_PROJECT_INFO() throws Exception {
  344. detailMethod(0);//1:post 0:get
  345. }
  346. /**
  347. * 28、自然资源-土地出让信息【ZRZY_TD_CEDE_INFO】
  348. */
  349. @XxlJob("task_ZRZY_TD_CEDE_INFO")
  350. public void ZRZY_TD_CEDE_INFO() throws Exception {
  351. detailMethod(0);//1:post 0:get
  352. }
  353. /**
  354. * 29、自然资源-地质勘查基金项目信息【ZRZY_DK_PROJECT】
  355. */
  356. @XxlJob("task_ZRZY_DK_PROJECT")
  357. public void ZRZY_DK_PROJECT() throws Exception {
  358. detailMethod(0);//1:post 0:get
  359. }
  360. /**
  361. * 201、自然资源-地质勘查基金交易公告【ZRZY_DK_NOTICE】
  362. */
  363. @XxlJob("task_ZRZY_DK_NOTICE")
  364. public void ZRZY_DK_NOTICE() throws Exception {
  365. detailMethod(0);//1:post 0:get
  366. }
  367. /**
  368. * 202、自然资源-地质勘查基金结果公示【ZRZY_DK_BIDWIN_NOTICE】
  369. */
  370. @XxlJob("task_ZRZY_DK_BIDWIN_NOTICE")
  371. public void ZRZY_DK_BIDWIN_NOTICE() throws Exception {
  372. detailMethod(0);//1:post 0:get
  373. }
  374. /**
  375. * 203、自然资源-存量指标【ZRZY_BG_STOCK_INDEX】
  376. */
  377. @XxlJob("task_ZRZY_BG_STOCK_INDEX")
  378. public void ZRZY_BG_STOCK_INDEX() throws Exception {
  379. detailMethod(0);//1:post 0:get
  380. }
  381. /**
  382. * 204、自然资源-交易公告【ZRZY_BG_NOTICE】
  383. */
  384. @XxlJob("task_ZRZY_BG_NOTICE")
  385. public void ZRZY_BG_NOTICE() throws Exception {
  386. detailMethod(0);//1:post 0:get
  387. }
  388. /**
  389. * 205、自然资源-结果公示【ZRZY_BG_BIDWIN_NOTICE】
  390. */
  391. @XxlJob("task_ZRZY_BG_BIDWIN_NOTICE")
  392. public void ZRZY_BG_BIDWIN_NOTICE() throws Exception {
  393. detailMethod(0);//1:post 0:get
  394. }
  395. /**
  396. * 205、自然资源-存量指标库【ZRZY_JYZB_STOCK_INDEX】
  397. */
  398. @XxlJob("task_ZRZY_JYZB_STOCK_INDEX")
  399. public void ZRZY_JYZB_STOCK_INDEX() throws Exception {
  400. detailMethod(0);//1:post 0:get
  401. }
  402. /**
  403. * 205、自然资源-节余指标公告【ZRZY_JYZB_NOTICE】
  404. */
  405. @XxlJob("task_ZRZY_JYZB_NOTICE")
  406. public void ZRZY_JYZB_NOTICE() throws Exception {
  407. detailMethod(0);//1:post 0:get
  408. }
  409. /**
  410. * 205、自然资源-【ZRZY_JYZB_BIDWIN_NOTICE】
  411. */
  412. @XxlJob("task_ZRZY_JYZB_BIDWIN_NOTICE")
  413. public void ZRZY_JYZB_BIDWIN_NOTICE() throws Exception {
  414. detailMethod(0);//1:post 0:get
  415. }
  416. /**
  417. * 34、国有产权-股权类项目信息【CQ_GQ_PROJECT】
  418. */
  419. @XxlJob("task_CqGqProject")
  420. public void CqGqProject() throws Exception {
  421. detailMethod(0);//1:post 0:get
  422. }
  423. /**
  424. * 35、国有产权-实物资产类项目信息【CQ_SW_PROJECT】
  425. */
  426. @XxlJob("task_CqSwProject")
  427. public void CqSwProject() throws Exception {
  428. detailMethod(0);//1:post 0:get
  429. }
  430. /**
  431. * 36、电力交易-招标公告与资格预审公告【NM_NOTICE】
  432. */
  433. @XxlJob("task_NmNotice")
  434. public void NmNotice() throws Exception {
  435. detailMethod(0);//1:post 0:get
  436. }
  437. /**
  438. * 37、电力交易-项目【NM_PROJECT】
  439. */
  440. @XxlJob("task_NmProject")
  441. public void NmProject() throws Exception {
  442. detailMethod(0);//1:post 0:get
  443. }
  444. /**
  445. * 38、电力交易-中标结果公示【NM_RESULT_NOTICE】
  446. */
  447. @XxlJob("task_NmResultNotice")
  448. public void NmResultNotice() throws Exception {
  449. detailMethod(0);//1:post 0:get
  450. }
  451. /**
  452. * 40、政府采购【GONGAO】
  453. */
  454. @XxlJob("task_gongao")
  455. public void gongao() throws Exception {
  456. detailMethod(0);//1:post 0:get
  457. }
  458. private void detailMethod(Integer type){
  459. System.out.println("进来了==================");
  460. String param = XxlJobHelper.getJobParam();
  461. XxlJobHelper.log("XXL-JOB, start="+param);
  462. if (param==null || param.trim().length()==0) {
  463. XxlJobHelper.log("param["+ param +"] invalid.");
  464. XxlJobHelper.handleFail();
  465. return;
  466. }
  467. String setDateStr = "";
  468. String tableName = param;
  469. if(param.contains(";")){
  470. tableName = param.substring(0,param.lastIndexOf(";"));
  471. setDateStr = param.substring(param.lastIndexOf(";")+1);
  472. }
  473. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");// 设置日期格式
  474. long startDate = 0;
  475. try {
  476. if(!StringUtils.isEmpty(setDateStr)){
  477. startDate = sdf.parse(setDateStr).getTime();
  478. }else{
  479. TaskRecord byId = taskRecordService.getById(tableName);
  480. if(null == byId){
  481. byId = new TaskRecord();
  482. byId.setTableName(tableName);
  483. byId.setUpdateTime(new Date());
  484. byId.setLastDealTime(new Date());
  485. }
  486. /* Date startDateTime = byId.getLastDealTime();
  487. // String startDateStr = Log.getTxtData("time.txt");
  488. // startDate = sdf.parse(startDateStr).getTime();
  489. startDate = startDateTime.getTime();
  490. Date afterDate = new Date(startDate + 5*60*1000);//5分钟后的时间
  491. //Log.Logger("time.txt",sdf.format(afterDate));
  492. byId.setLastDealTime(afterDate);*/
  493. startDate = new Date().getTime();
  494. Date startDateTime = new Date(startDate - 10*60*1000);//10分钟前的时间
  495. startDate = startDateTime.getTime();
  496. byId.setLastDealTime(new Date(startDate));
  497. byId.setUpdateTime(new Date());
  498. System.out.println("getTableName"+byId.getTableName());
  499. taskRecordService.saveOrUpdate(byId);
  500. }
  501. System.out.println(startDate);
  502. } catch (ParseException e) {
  503. throw new RuntimeException(e);
  504. }
  505. Integer total = 0;
  506. try{
  507. MultiValueMap<String, Object> params = new LinkedMultiValueMap<>();
  508. params.add("platform_code", "e64975be");
  509. params.add("table_name", tableName);
  510. params.add("page", "1");
  511. params.add("page_size", "1");
  512. params.add("startTime", startDate);
  513. JSONObject jsonObject1 = null;
  514. if(type==0){
  515. jsonObject1 = httpGetMethod("http://10.8.3.137:7401/adminNmg/api/down.do",params);
  516. }else{
  517. jsonObject1 = httpPostMethod("http://10.8.3.137:7401/adminNmg/api/down.do",params);//&startTime=1676540529
  518. }
  519. total = jsonObject1.getInteger("total");
  520. }catch (Exception e){
  521. e.printStackTrace();
  522. }
  523. //Integer pages = total/20+1;
  524. int pages = (int) Math.ceil((double) total / 20);
  525. for(int i = 1; i <= pages ; i++){
  526. if(i<=0)i=1;
  527. try{
  528. MultiValueMap<String, Object> params = new LinkedMultiValueMap<>();
  529. params.add("platform_code", "e64975be");
  530. params.add("table_name", tableName);
  531. params.add("page", i);
  532. params.add("page_size", "20");
  533. params.add("startTime", startDate);
  534. JSONObject jsonObject = null;
  535. if(type==0){
  536. jsonObject = httpGetMethod("http://10.8.3.137:7401/adminNmg/api/down.do",params);
  537. }else{
  538. jsonObject = httpPostMethod("http://10.8.3.137:7401/adminNmg/api/down.do",params);//&startTime=1676540529
  539. }
  540. String data = RSAUtils.decrypt(jsonObject.getString("data"));
  541. JSONArray jsonArray = JSONArray.parseArray(data);
  542. //数据入库
  543. updateDatas(tableName,jsonArray);
  544. XxlJobHelper.handleSuccess();
  545. }catch (Exception e){
  546. e.printStackTrace();
  547. }
  548. }
  549. }
  550. //http方法
  551. public JSONObject httpPostMethod(String uri, MultiValueMap<String, Object> params){
  552. System.out.println("uri"+uri);
  553. System.out.println("params"+params);
  554. restTemplate.getMessageConverters().set(1, new StringHttpMessageConverter(StandardCharsets.UTF_8));
  555. //JSONObject response = restTemplate.getForObject(uri,JSONObject.class);
  556. HttpHeaders headers = new HttpHeaders();
  557. // 以表单的方式提交
  558. headers.setContentType(MediaType.APPLICATION_FORM_URLENCODED);
  559. //将请求头部和参数合成一个请求
  560. HttpEntity<MultiValueMap<String, String>> entity = new HttpEntity(params, headers);
  561. //System.out.println("post===============");
  562. ResponseEntity<JSONObject> response = restTemplate.exchange(uri, HttpMethod.POST, entity, JSONObject.class);
  563. //System.out.println("response"+response);
  564. JSONObject body = response.getBody();
  565. //System.out.println("response2"+body);
  566. return body;
  567. }
  568. public JSONObject httpGetMethod(String uri, MultiValueMap<String, Object> params){
  569. uri = uri + "?platform_code=e64975be&table_name="+params.get("table_name").get(0)+"&page="+params.get("page").get(0)+"&page_size="+params.get("page_size").get(0)+"&startTime="+params.get("startTime").get(0);
  570. JSONObject response = restTemplate.getForObject(uri, JSONObject.class);
  571. return response;
  572. }
  573. private void updateDatas(String param , JSONArray jsonArray ) {
  574. SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyyMMddHHmmss");
  575. switch (param)
  576. {
  577. case "GC_NOTICEANDFILE"://1、工程-招标公告与资格预审公告【GC_NOTICEANDFILE】
  578. List<GcNoticeandfile> listGcNoticeandfile = JSONObject.parseArray(jsonArray.toJSONString(), GcNoticeandfile.class);
  579. logger.info(param+":数据入库="+listGcNoticeandfile.size());
  580. XxlJobHelper.log(param+":数据入库="+listGcNoticeandfile.size());
  581. gcNoticeandfileService.saveOrUpdateBatch(listGcNoticeandfile);
  582. // for (GcNoticeandfile gcNoticeandfile : listGcNoticeandfile) {
  583. // if(gcNoticeandfile.getNoticeName()!=null&&!gcNoticeandfile.getNoticeName().equals("")){
  584. // logger.info(param+":数据入库="+20);
  585. // XxlJobHelper.log(param+":数据入库="+20);
  586. // gcNoticeandfileService.saveOrUpdateBatch(listGcNoticeandfile);
  587. // }
  588. // }
  589. break;
  590. case "GC_BIDOPENRECORD"://3、工程-开标记录【GC_BIDOPENRECORD】
  591. List<GcBidopenrecord> listGcBidopenrecord = JSONObject.parseArray(jsonArray.toJSONString(), GcBidopenrecord.class);
  592. logger.info(param+":数据入库="+listGcBidopenrecord.size());
  593. System.out.println("=============公共资源:"+listGcBidopenrecord.get(0).getNoticeName());
  594. XxlJobHelper.log(param+":数据入库="+listGcBidopenrecord.get(0));
  595. gcBidopenrecordService.saveOrUpdateBatch(listGcBidopenrecord);
  596. break;
  597. case "GC_BIDCANDIDATE_POST"://4、工程-中标候选人公示【GC_BIDCANDIDATE_POST】
  598. List<GcBidcandidatePost> listGcBidcandidatePost = JSONObject.parseArray(jsonArray.toJSONString(), GcBidcandidatePost.class);
  599. logger.info(param+":数据入库="+listGcBidcandidatePost.size());
  600. XxlJobHelper.log(param+":数据入库="+listGcBidcandidatePost.size());
  601. gcBidcandidatePostService.saveOrUpdateBatch(listGcBidcandidatePost);
  602. break;
  603. case "GC_BIDPUBLICITY"://5、工程-中标结果公示【GC_BIDPUBLICITY】
  604. List<GcBidpublicity> listGcBidpublicity = JSONObject.parseArray(jsonArray.toJSONString(), GcBidpublicity.class);
  605. logger.info(param+":数据入库="+listGcBidpublicity.size());
  606. XxlJobHelper.log(param+":数据入库="+listGcBidpublicity.size());
  607. gcBidpublicityService.saveOrUpdateBatch(listGcBidpublicity);
  608. break;
  609. case "GC_PROJECT"://6、工程-项目【GC_PROJECT】
  610. List<GcProject> listGcProject = JSONObject.parseArray(jsonArray.toJSONString(), GcProject.class);
  611. logger.info(param+":数据入库="+listGcProject.size());
  612. XxlJobHelper.log(param+":数据入库="+listGcProject.size());
  613. gcProjectService.saveOrUpdateBatch(listGcProject);
  614. break;
  615. case "GC_TENDERPROJECT"://7、工程-招标项目【GC_TENDERPROJECT】
  616. List<GcTenderproject> listGcTenderproject = JSONObject.parseArray(jsonArray.toJSONString(), GcTenderproject.class);
  617. logger.info(param+":数据入库="+listGcTenderproject.size());
  618. XxlJobHelper.log(param+":数据入库="+listGcTenderproject.size());
  619. gcTenderprojectService.saveOrUpdateBatch(listGcTenderproject);
  620. break;
  621. case "GC_TENDERBIDFILE":////8、工程-招标文件/招标文件澄清与修改【GC_TENDERPROJECT】
  622. List<GcTenderbidfile> listGcTenderbidfile = JSONObject.parseArray(jsonArray.toJSONString(), GcTenderbidfile.class);
  623. logger.info(param+":数据入库="+listGcTenderbidfile.size());
  624. XxlJobHelper.log(param+":数据入库="+listGcTenderbidfile.size());
  625. gcTenderbidfileService.saveOrUpdateBatch(listGcTenderbidfile);
  626. break;
  627. case "GC_PUB_CONTRACT"://9、工程-合同签订【GC_PUB_CONTRACT】
  628. List<GcPubContract> listGcPubContract = JSONObject.parseArray(jsonArray.toJSONString(), GcPubContract.class);
  629. logger.info(param+":数据入库="+listGcPubContract.size());
  630. XxlJobHelper.log(param+":数据入库="+listGcPubContract.size());
  631. gcPubContractService.saveOrUpdateBatch(listGcPubContract);
  632. break;
  633. case "GC_PERFORMANCE"://10、工程-合同履约【GC_PERFORMANCE】
  634. List<GcPerformance> listGcPerformance = JSONObject.parseArray(jsonArray.toJSONString(), GcPerformance.class);
  635. logger.info(param+":数据入库="+listGcPerformance.size());
  636. XxlJobHelper.log(param+":数据入库="+listGcPerformance.size());
  637. gcPerformanceService.saveOrUpdateBatch(listGcPerformance);
  638. break;
  639. case "GC_BID_EXCEPTIO_NOTICE"://11、工程-招标异常公告【GC_BID_EXCEPTIO_NOTICE】
  640. List<GcBidExceptioNotice> listGcBidExceptioNotice = JSONObject.parseArray(jsonArray.toJSONString(), GcBidExceptioNotice.class);
  641. logger.info(param+":数据入库="+listGcBidExceptioNotice.size());
  642. XxlJobHelper.log(param+":数据入库="+listGcBidExceptioNotice.size());
  643. gcBidExceptioNoticeService.saveOrUpdateBatch(listGcBidExceptioNotice);
  644. break;
  645. case "GC_ATTACHMENT"://12、工程-附件集结构【GC_ATTACHMENT】
  646. List<GcAttachment> listGcAttachment = JSONObject.parseArray(jsonArray.toJSONString(), GcAttachment.class);
  647. logger.info(param+":数据入库="+listGcAttachment.size());
  648. XxlJobHelper.log(param+":数据入库="+listGcAttachment.size());
  649. gcAttachmentService.saveOrUpdateBatch(listGcAttachment);
  650. break;
  651. case "GC_BIDOPEN_FILE"://13、工程-开标明细数据集【GC_BIDOPEN_FILE】
  652. List<GcBidopenFile> listGcBidopenFile = JSONObject.parseArray(jsonArray.toJSONString(), GcBidopenFile.class);
  653. logger.info(param+":数据入库="+listGcBidopenFile.size());
  654. XxlJobHelper.log(param+":数据入库="+listGcBidopenFile.size());
  655. gcBidopenFileService.saveOrUpdateBatch(listGcBidopenFile);
  656. break;
  657. case "GC_PACKAGE"://16、工程-标段(包)【GC_PACKAGE】
  658. List<GcPackage> listGcPackage = JSONObject.parseArray(jsonArray.toJSONString(), GcPackage.class);
  659. logger.info(param+":数据入库="+listGcPackage.size());
  660. XxlJobHelper.log(param+":数据入库="+listGcPackage.size());
  661. gcPackageService.saveOrUpdateBatch(listGcPackage);
  662. break;
  663. case "ZRZY_TD_CEDE_NOTICE"://20、自然资源-土地出让公告信息【ZRZY_TD_CEDE_NOTICE】
  664. List<ZrzyTdCedeNotice> listZrzyTdCedeNotice = JSONObject.parseArray(jsonArray.toJSONString(), ZrzyTdCedeNotice.class);
  665. logger.info(param+":数据入库="+listZrzyTdCedeNotice.size());
  666. XxlJobHelper.log(param+":数据入库="+listZrzyTdCedeNotice.size());
  667. zrzyTdCedeNoticeService.saveOrUpdateBatch(listZrzyTdCedeNotice);
  668. break;
  669. case "ZRZY_TD_BIDWINNOTICE"://21、自然资源-土地成交结果公告【ZRZY_TD_BIDWINNOTICE】
  670. List<ZrzyTdBidwinnotice> listZrzyTdBidwinnotice = JSONObject.parseArray(jsonArray.toJSONString(), ZrzyTdBidwinnotice.class);
  671. logger.info(param+":数据入库="+listZrzyTdBidwinnotice.size());
  672. XxlJobHelper.log(param+":数据入库="+listZrzyTdBidwinnotice.size());
  673. zrzyTdBidwinnoticeService.saveOrUpdateBatch(listZrzyTdBidwinnotice);
  674. break;
  675. case "CQ_SW_ISSUE_BULLETIN"://30、国有产权-实物资产挂牌披露信息【CQ_SW_ISSUE_BULLETIN】
  676. List<CqSwIssueBulletin> listCqSwIssueBulletin = JSONObject.parseArray(jsonArray.toJSONString(), CqSwIssueBulletin.class);
  677. logger.info(param+":数据入库="+listCqSwIssueBulletin.size());
  678. XxlJobHelper.log(param+":数据入库="+listCqSwIssueBulletin.size());
  679. cqSwIssueBulletinService.saveOrUpdateBatch(listCqSwIssueBulletin);
  680. break;
  681. case "CQ_SW_BARGAIN_RESULT"://31、国有产权-实物资产交易结果信息【CQ_SW_BARGAIN_RESULT】】
  682. List<CqSwBargainResult> listCqSwBargainResult = JSONObject.parseArray(jsonArray.toJSONString(), CqSwBargainResult.class);
  683. logger.info(param+":数据入库="+listCqSwBargainResult.size());
  684. XxlJobHelper.log(param+":数据入库="+listCqSwBargainResult.size());
  685. cqSwBargainResultService.saveOrUpdateBatch(listCqSwBargainResult);
  686. break;
  687. case "ZT_LEGALINFO"://100、主体库ZT_LEGALINFO
  688. List<ZtLegalinfo> listZtLegalinfo = JSONObject.parseArray(jsonArray.toJSONString(), ZtLegalinfo.class);
  689. logger.info(param+":数据入库="+listZtLegalinfo.size());
  690. XxlJobHelper.log(param+":数据入库="+listZtLegalinfo.size());
  691. ztLegalinfoService.saveOrUpdateBatch(listZtLegalinfo);
  692. break;
  693. case "YC_NOTICE"://200、药采公告 【YC_NOTICE】
  694. List<YcNotice> listYcNotice = JSONObject.parseArray(jsonArray.toJSONString(), YcNotice.class);
  695. logger.info(param+":数据入库="+listYcNotice.size());
  696. XxlJobHelper.log(param+":数据入库="+listYcNotice.size());
  697. ycNoticeService.saveOrUpdateBatch(listYcNotice);
  698. break;
  699. case "JG_FIELDAPPLY"://14、场地预约【JG_FIELDAPPLY】
  700. List<JgFieldApply> listJgFieldApply = JSONObject.parseArray(jsonArray.toJSONString(), JgFieldApply.class);
  701. logger.info(param+":数据入库="+listJgFieldApply.size());
  702. XxlJobHelper.log(param+":数据入库="+listJgFieldApply.size());
  703. jgFieldApplyService.saveOrUpdateBatch(listJgFieldApply);
  704. break;
  705. case "JG_SITE_INFORMATION"://15、场地信息【JG_SITE_INFORMATION】
  706. List<JgSiteInformation> listJgSiteInformation = JSONObject.parseArray(jsonArray.toJSONString(), JgSiteInformation.class);
  707. logger.info(param+":数据入库="+listJgSiteInformation.size());
  708. XxlJobHelper.log(param+":数据入库="+listJgSiteInformation.size());
  709. jgSiteInformationService.saveOrUpdateBatch(listJgSiteInformation);
  710. break;
  711. case "CQ_GQ_ISSUE_BULLETIN"://32、国有产权-挂牌披露信息【CQ_GQ_ISSUE_BULLETIN】
  712. List<CqGqIssueBulletin> listCqGqIssueBulletin = JSONObject.parseArray(jsonArray.toJSONString(), CqGqIssueBulletin.class);
  713. logger.info(param+":数据入库="+listCqGqIssueBulletin.size());
  714. XxlJobHelper.log(param+":数据入库="+listCqGqIssueBulletin.size());
  715. cqGqIssueBulletinService.saveOrUpdateBatch(listCqGqIssueBulletin);
  716. break;
  717. case "CQ_GQ_BARGAIN_RESULT"://33、国有产权-交易结果信息【CQ_GQ_BARGAIN_RESULT】
  718. List<CqGqBargainResult> listCqGqBargainResult = JSONObject.parseArray(jsonArray.toJSONString(), CqGqBargainResult.class);
  719. logger.info(param+":数据入库="+listCqGqBargainResult.size());
  720. XxlJobHelper.log(param+":数据入库="+listCqGqBargainResult.size());
  721. cqGqBargainResultService.saveOrUpdateBatch(listCqGqBargainResult);
  722. break;
  723. case "ZRZY_TKQ_NOTICE"://22、自然资源-探矿权招拍挂公告信息【ZRZY_TKQ_NOTICE】
  724. List<ZrzyTkqNotice> listZrzyTkqNotice = JSONObject.parseArray(jsonArray.toJSONString(), ZrzyTkqNotice.class);
  725. logger.info(param+":数据入库="+listZrzyTkqNotice.size());
  726. XxlJobHelper.log(param+":数据入库="+listZrzyTkqNotice.size());
  727. zrzyTkqNoticeService.saveOrUpdateBatch(listZrzyTkqNotice);
  728. break;
  729. case "ZRZY_TKQ_BIDWINNOTICE"://23、自然资源-探矿权招拍挂结果公示信息【ZRZY_TKQ_BIDWINNOTICE】
  730. List<ZrzyTkqBidwinnotice> listZrzyTkqBidwinnotice = JSONObject.parseArray(jsonArray.toJSONString(), ZrzyTkqBidwinnotice.class);
  731. logger.info(param+":数据入库="+listZrzyTkqBidwinnotice.size());
  732. XxlJobHelper.log(param+":数据入库="+listZrzyTkqBidwinnotice.size());
  733. zrzyTkqBidwinnoticeService.saveOrUpdateBatch(listZrzyTkqBidwinnotice);
  734. break;
  735. case "ZRZY_CKQ_NOTICE"://24、自然资源-采矿权招拍挂公告信息【ZRZY_CKQ_NOTICE】
  736. List<ZrzyCkqNotice> listZrzyCkqNotice = JSONObject.parseArray(jsonArray.toJSONString(), ZrzyCkqNotice.class);
  737. logger.info(param+":数据入库="+listZrzyCkqNotice.size());
  738. XxlJobHelper.log(param+":数据入库="+listZrzyCkqNotice.size());
  739. zrzyCkqNoticeService.saveOrUpdateBatch(listZrzyCkqNotice);
  740. break;
  741. case "ZRZY_CKQ_BIDWINNOTICE"://25、自然资源-采矿权招拍挂结果公示信息【ZRZY_CKQ_BIDWINNOTICE】
  742. List<ZrzyCkqBidwinnotice> listZrzyCkqBidwinnotice = JSONObject.parseArray(jsonArray.toJSONString(), ZrzyCkqBidwinnotice.class);
  743. logger.info(param+":数据入库="+listZrzyCkqBidwinnotice.size());
  744. XxlJobHelper.log(param+":数据入库="+listZrzyCkqBidwinnotice.size());
  745. zrzyCkqBidwinnoticeService.saveOrUpdateBatch(listZrzyCkqBidwinnotice);
  746. break;
  747. case "ZRZY_TKQ_PROJECT_INFO"://26、自然资源-探矿权项目信息【ZRZY_TKQ_PROJECT_INFO】
  748. List<ZrzyTkqProjectInfo> listZrzyTkqProjectInfo = JSONObject.parseArray(jsonArray.toJSONString(), ZrzyTkqProjectInfo.class);
  749. logger.info(param+":数据入库="+listZrzyTkqProjectInfo.size());
  750. XxlJobHelper.log(param+":数据入库="+listZrzyTkqProjectInfo.size());
  751. zrzyTkqProjectInfoService.saveOrUpdateBatch(listZrzyTkqProjectInfo);
  752. break;
  753. case "ZRZY_CKQ_PROJECT_INFO"://27、自然资源-采矿权项目信息【ZRZY_CKQ_PROJECT_INFO】
  754. List<ZrzyCkqProjectInfo> listZrzyCkqProjectInfo = JSONObject.parseArray(jsonArray.toJSONString(), ZrzyCkqProjectInfo.class);
  755. logger.info(param+":数据入库="+listZrzyCkqProjectInfo.size());
  756. XxlJobHelper.log(param+":数据入库="+listZrzyCkqProjectInfo.size());
  757. zrzyCkqProjectInfoService.saveOrUpdateBatch(listZrzyCkqProjectInfo);
  758. break;
  759. case "ZRZY_TD_CEDE_INFO":// 28、自然资源-土地出让信息【ZRZY_TD_CEDE_INFO】
  760. List<ZrzyTdCedeInfo> listZrzyTdCedeInfo = JSONObject.parseArray(jsonArray.toJSONString(), ZrzyTdCedeInfo.class);
  761. logger.info(param+":数据入库="+listZrzyTdCedeInfo.size());
  762. XxlJobHelper.log(param+":数据入库="+listZrzyTdCedeInfo.size());
  763. zrzyTdCedeInfoService.saveOrUpdateBatch(listZrzyTdCedeInfo);
  764. break;
  765. case "ZRZY_DK_PROJECT"://29、自然资源-地质勘查基金项目信息【ZRZY_DK_PROJECT】
  766. List<ZrzyDkProject> listZrzyDkProject = JSONObject.parseArray(jsonArray.toJSONString(), ZrzyDkProject.class);
  767. logger.info(param+":数据入库="+listZrzyDkProject.size());
  768. XxlJobHelper.log(param+":数据入库="+listZrzyDkProject.size());
  769. zrzyDkProjectService.saveOrUpdateBatch(listZrzyDkProject);
  770. break;
  771. case "ZRZY_DK_NOTICE"://201、自然资源-地质勘查基金交易公告【ZRZY_DK_NOTICE】
  772. List<ZrzyDkNotice> listZrzyDkNotice = JSONObject.parseArray(jsonArray.toJSONString(), ZrzyDkNotice.class);
  773. logger.info(param+":数据入库="+listZrzyDkNotice.size());
  774. XxlJobHelper.log(param+":数据入库="+listZrzyDkNotice.size());
  775. zrzyDkNoticeService.saveOrUpdateBatch(listZrzyDkNotice);
  776. break;
  777. case "ZRZY_DK_BIDWIN_NOTICE"://202、自然资源-地质勘查基金结果公示【ZRZY_DK_BIDWIN_NOTICE】
  778. List<ZrzyDkBinwinNotice> listZrzyDkBinwinNotice = JSONObject.parseArray(jsonArray.toJSONString(), ZrzyDkBinwinNotice.class);
  779. logger.info(param+":数据入库="+listZrzyDkBinwinNotice.size());
  780. XxlJobHelper.log(param+":数据入库="+listZrzyDkBinwinNotice.size());
  781. zrzyDkBinwinNoticeService.saveOrUpdateBatch(listZrzyDkBinwinNotice);
  782. break;
  783. case "ZRZY_BG_STOCK_INDEX"://203、自然资源-存量指标【ZRZY_BG_STOCK_INDEX】
  784. List<ZrzyBgStockIndex> listZrzyBgStockIndex = JSONObject.parseArray(jsonArray.toJSONString(), ZrzyBgStockIndex.class);
  785. logger.info(param+":数据入库="+listZrzyBgStockIndex.size());
  786. XxlJobHelper.log(param+":数据入库="+listZrzyBgStockIndex.size());
  787. zrzyBgStockIndexService.saveOrUpdateBatch(listZrzyBgStockIndex);
  788. break;
  789. case "ZRZY_BG_NOTICE":// 204、自然资源-交易公告【ZRZY_BG_NOTICE】
  790. List<ZrzyBgNotice> listZrzyBgNotice = JSONObject.parseArray(jsonArray.toJSONString(), ZrzyBgNotice.class);
  791. logger.info(param+":数据入库="+listZrzyBgNotice.size());
  792. XxlJobHelper.log(param+":数据入库="+listZrzyBgNotice.size());
  793. zrzyBgNoticeService.saveOrUpdateBatch(listZrzyBgNotice);
  794. break;
  795. case "ZRZY_BG_BIDWIN_NOTICE"://205、自然资源-结果公示【ZRZY_BG_BIDWIN_NOTICE】
  796. List<ZrzyBgBidwinNotice> listZrzyBgBidwinNotice = JSONObject.parseArray(jsonArray.toJSONString(), ZrzyBgBidwinNotice.class);
  797. logger.info(param+":数据入库="+listZrzyBgBidwinNotice.size());
  798. XxlJobHelper.log(param+":数据入库="+listZrzyBgBidwinNotice.size());
  799. zrzyBgBidwinNoticeService.saveOrUpdateBatch(listZrzyBgBidwinNotice);
  800. break;
  801. case "ZRZY_JYZB_STOCK_INDEX"://206、自然资源-存量指标库【ZRZY_JYZB_STOCK_INDEX】
  802. List<ZrzyJyzbStockIndex> listZrzyJyzbStockIndex = JSONObject.parseArray(jsonArray.toJSONString(), ZrzyJyzbStockIndex.class);
  803. logger.info(param+":数据入库="+listZrzyJyzbStockIndex.size());
  804. XxlJobHelper.log(param+":数据入库="+listZrzyJyzbStockIndex.size());
  805. zrzyJyzbStockIndexService.saveOrUpdateBatch(listZrzyJyzbStockIndex);
  806. break;
  807. case "ZRZY_JYZB_NOTICE"://207、自然资源-节余指标公告【ZRZY_JYZB_NOTICE】
  808. List<ZrzyJyzbNotice> listZrzyJyzbNotice = JSONObject.parseArray(jsonArray.toJSONString(), ZrzyJyzbNotice.class);
  809. logger.info(param+":数据入库="+listZrzyJyzbNotice.size());
  810. XxlJobHelper.log(param+":数据入库="+listZrzyJyzbNotice.size());
  811. zrzyJyzbNoticeService.saveOrUpdateBatch(listZrzyJyzbNotice);
  812. break;
  813. case "ZRZY_JYZB_BIDWIN_NOTICE"://208、自然资源-【ZRZY_JYZB_BIDWIN_NOTICE】
  814. List<ZrzyJyzbBidwinNotice> listZrzyJyzbBidwinNotice = JSONObject.parseArray(jsonArray.toJSONString(), ZrzyJyzbBidwinNotice.class);
  815. logger.info(param+":数据入库="+listZrzyJyzbBidwinNotice.size());
  816. XxlJobHelper.log(param+":数据入库="+listZrzyJyzbBidwinNotice.size());
  817. zrzyJyzbBidwinNoticeService.saveOrUpdateBatch(listZrzyJyzbBidwinNotice);
  818. break;
  819. case "CQ_GQ_PROJECT"://34、国有产权-股权类项目信息【CQ_GQ_PROJECT】
  820. List<CqGqProject> listCqGqProject = JSONObject.parseArray(jsonArray.toJSONString(), CqGqProject.class);
  821. logger.info(param+":数据入库="+listCqGqProject.size());
  822. XxlJobHelper.log(param+":数据入库="+listCqGqProject.size());
  823. cqGqProjectService.saveOrUpdateBatch(listCqGqProject);
  824. break;
  825. case "CQ_SW_PROJECT"://35、国有产权-实物资产类项目信息【CQ_SW_PROJECT】
  826. List<CqSwProject> listCqSwProject = JSONObject.parseArray(jsonArray.toJSONString(), CqSwProject.class);
  827. logger.info(param+":数据入库="+listCqSwProject.size());
  828. XxlJobHelper.log(param+":数据入库="+listCqSwProject.size());
  829. cqSwProjectService.saveOrUpdateBatch(listCqSwProject);
  830. break;
  831. case "NM_NOTICE"://36、电力交易-招标公告与资格预审公告【NM_NOTICE】
  832. List<NmNotice> nmNoticeList = JSONObject.parseArray(jsonArray.toJSONString(), NmNotice.class);
  833. logger.info(param+":数据入库="+nmNoticeList.size());
  834. XxlJobHelper.log(param+":数据入库="+nmNoticeList.size());
  835. nmNoticeService.saveOrUpdateBatch(nmNoticeList);
  836. break;
  837. case "NM_PROJECT"://37、电力交易-项目【NM_PROJECT】
  838. List<NmProject> nmProjectList = JSONObject.parseArray(jsonArray.toJSONString(), NmProject.class);
  839. logger.info(param+":数据入库="+nmProjectList.size());
  840. XxlJobHelper.log(param+":数据入库="+nmProjectList.size());
  841. nmProjectService.saveOrUpdateBatch(nmProjectList);
  842. break;
  843. case "NM_RESULT_NOTICE"://38、电力交易-中标结果公示【NM_RESULT_NOTICE】
  844. List<NmResultNotice> nmResultNotice = JSONObject.parseArray(jsonArray.toJSONString(), NmResultNotice.class);
  845. logger.info(param+":数据入库="+nmResultNotice.size());
  846. XxlJobHelper.log(param+":数据入库="+nmResultNotice.size());
  847. nmResultNoticeService.saveOrUpdateBatch(nmResultNotice);
  848. break;
  849. case "ZFCG_GONGAO"://38、政府采购【ZfcgGongao】
  850. List<Gongao> gongaoList = JSONObject.parseArray(jsonArray.toJSONString(), Gongao.class);
  851. List<ZfcgGongao> gongaoDbList = new ArrayList<>();
  852. for(Gongao gongao : gongaoList){
  853. ZfcgGongao zfcgGongao = new ZfcgGongao();
  854. try{
  855. zfcgGongao.setNoticeTime((gongao.getNoticeTime()));
  856. zfcgGongao.setNoticeName(gongao.getNoticeName());
  857. zfcgGongao.setNoticeGuid(gongao.getNoticeGuid());
  858. zfcgGongao.setNoticeType(gongao.getNoticeType());
  859. zfcgGongao.setRegionName(gongao.getRegionName());
  860. zfcgGongao.setSourceDataKey(gongao.getId());
  861. zfcgGongao.setRegionCode(gongao.getRegionCode());
  862. zfcgGongao.setDataTimestamp(Long.parseLong(simpleDateFormat.format(new Date())));
  863. String regionCode = gongao.getRegionCode();
  864. if(!"1504".equals(regionCode.substring(0,4))){
  865. zfcgGongao.setNoticeContent(Base64Util.decode(gongao.getNoticeContent()));
  866. }else {
  867. zfcgGongao.setNoticeContent(gongao.getNoticeContent());
  868. }
  869. gongaoDbList.add(zfcgGongao);
  870. }catch (Exception e){
  871. e.printStackTrace();
  872. }
  873. }
  874. logger.info(param+":数据入库="+gongaoDbList.size());
  875. XxlJobHelper.log(param+":数据入库="+gongaoDbList.size());
  876. zfcgGongaoService.saveOrUpdateBatch(gongaoDbList);
  877. break;
  878. default:
  879. }
  880. }
  881. }