es_comprehensive.go 48 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474
  1. package services
  2. import (
  3. "context"
  4. "encoding/json"
  5. "fmt"
  6. "github.com/PuerkitoBio/goquery"
  7. "github.com/olivere/elastic/v7"
  8. "strconv"
  9. //"go/doc"
  10. "hongze/hongze_cygx/models"
  11. "hongze/hongze_cygx/utils"
  12. "html"
  13. //"strconv"
  14. "errors"
  15. "strings"
  16. "time"
  17. )
  18. type SearchComprehensiveItem struct {
  19. SourceId int `description:"资源ID"`
  20. IsSummary int `description:"是否是纪要"`
  21. Source string `description:"资源类型 报告 :article 、图表 :newchart、微路演 :roadshow、活动 :activity、活动视频:activityvideo、活动音频:activityvoice、专项调研活动:activityspecial 、 本周研究汇总: researchsummary 、 上周纪要汇总 :minutessummary 、晨会精华 :meetingreviewchapt 、 产品内测:productinterior"`
  22. Title string `description:"标题"`
  23. BodyText string `description:"内容"`
  24. PublishDate string `description:"发布时间"`
  25. Abstract string `description:"摘要"`
  26. Annotation string `description:"核心观点"`
  27. IndustryName string `description:"产业名称"`
  28. SubjectNames string `description:"标的名称"`
  29. Body []string
  30. }
  31. type ElasticComprehensiveDetail struct {
  32. SourceId int `description:"资源ID"`
  33. IsSummary int `description:"是否是纪要"`
  34. Source string `description:"资源类型 报告 :article 、图表 :newchart、微路演 :roadshow、活动 :activity、活动视频:activityvideo、活动音频:activityvoice、专项调研活动:activityspecial 、 本周研究汇总: researchsummary 、 上周纪要汇总 :minutessummary 、晨会精华 :meetingreviewchapt 、 产品内测:productinterior 、 产业资源包:industrialsource"`
  35. Title string `description:"标题"`
  36. BodyText string `description:"内容"`
  37. PublishDate string `description:"发布时间"`
  38. Abstract string `description:"摘要"`
  39. Annotation string `description:"核心观点"`
  40. IndustryName string `description:"产业名称"`
  41. SubjectNames string `description:"标的名称"`
  42. }
  43. //func init() {
  44. // AddComprehensiveIndustrialSource("Hz", 0)
  45. // //AddComprehensiveChart(0)
  46. // // AddComprehensiveMeetingreviewchapt()
  47. //}
  48. // 添加文章:报告、纪要
  49. func AddComprehensiveArticle(articleId int) {
  50. var err error
  51. defer func() {
  52. if err != nil {
  53. fmt.Println(err)
  54. go utils.SendAlarmMsg("删除数据综合页面数据Es失败"+err.Error(), 2)
  55. }
  56. }()
  57. IndustrialManagementRespMap, _ := GetIndustrialManagementRespMap()
  58. IndustrialSubjectMap, _ := GetCygxIndustrialSubjectMap()
  59. var condition1 string
  60. var pars1 []interface{}
  61. mapActivityIndustrialManagement := make(map[int][]string)
  62. industrialgroupList, e := models.GetIndustrialArticleGroupManagementList(condition1, pars1)
  63. if e != nil {
  64. fmt.Println(e)
  65. return
  66. }
  67. for _, v := range industrialgroupList {
  68. if v.ArticleId == 0 {
  69. continue
  70. }
  71. mapActivityIndustrialManagement[v.ArticleId] = append(mapActivityIndustrialManagement[v.ArticleId], IndustrialManagementRespMap[v.IndustrialManagementId])
  72. }
  73. mapActivitySubject := make(map[int][]string)
  74. SubjectgroupList, e := models.GetSubjectArticleGroupManagementList(condition1, pars1)
  75. if e != nil {
  76. fmt.Println(e)
  77. return
  78. }
  79. for _, v := range SubjectgroupList {
  80. if v.ArticleId == 0 {
  81. continue
  82. }
  83. mapActivitySubject[v.ArticleId] = append(mapActivitySubject[v.ArticleId], IndustrialSubjectMap[v.IndustrialSubjectId])
  84. }
  85. var condition string
  86. var pars []interface{}
  87. condition += ` AND publish_status = 1 `
  88. if articleId > 0 {
  89. condition = ` AND article_id = ? `
  90. pars = append(pars, articleId)
  91. }
  92. articleList, e := models.GetArticleList(condition, pars)
  93. if e != nil {
  94. err = errors.New("GetArticleList, Err: " + e.Error())
  95. return
  96. }
  97. //indexName := utils.IndexNameComprehensive
  98. for _, v := range articleList {
  99. time.Sleep(200 * time.Millisecond)
  100. content := html.UnescapeString(v.Body)
  101. doc, err := goquery.NewDocumentFromReader(strings.NewReader(content))
  102. if err != nil {
  103. fmt.Println("create doc err:", err.Error())
  104. return
  105. }
  106. bodyText := doc.Text()
  107. item := new(ElasticComprehensiveDetail)
  108. item.SourceId = v.ArticleId
  109. item.IsSummary = v.IsSummary
  110. item.Source = "article"
  111. item.Title = v.Title
  112. item.PublishDate = v.PublishDate
  113. item.BodyText = bodyText
  114. if v.IsSummary == 0 {
  115. item.SubjectNames = strings.Join(mapActivitySubject[v.ArticleId], ",") + "," + v.FieldName
  116. item.IndustryName = strings.Join(mapActivityIndustrialManagement[v.ArticleId], ",")
  117. }
  118. item.Annotation, _ = GetReportContentTextSubNew(v.Annotation)
  119. item.Abstract, _ = GetReportContentTextSubNew(v.Abstract)
  120. EsAddOrEditComprehensiveData(item)
  121. fmt.Println(item.IndustryName)
  122. fmt.Println(item.SubjectNames)
  123. }
  124. }
  125. // 添加图表
  126. func AddComprehensiveChart(chartId int) {
  127. var err error
  128. defer func() {
  129. if err != nil {
  130. fmt.Println(err)
  131. go utils.SendAlarmMsg("AddComprehensiveChart Err"+err.Error()+fmt.Sprint(chartId), 2)
  132. }
  133. }()
  134. var condition string
  135. var pars []interface{}
  136. condition += ` AND publish_status = 1 `
  137. if chartId > 0 {
  138. condition = ` AND chart_id = ? `
  139. pars = append(pars, chartId)
  140. }
  141. list, e := models.GetChartList(condition, pars, 0, 1000000)
  142. if e != nil {
  143. err = errors.New("GetChartList, Err: " + e.Error())
  144. return
  145. }
  146. //indexName := utils.IndexNameComprehensive
  147. for _, v := range list {
  148. time.Sleep(200 * time.Millisecond)
  149. item := new(ElasticComprehensiveDetail)
  150. item.SourceId = v.ChartId
  151. item.Source = "newchart"
  152. item.Title = v.Title
  153. item.PublishDate = v.CreateDate
  154. EsAddOrEditComprehensiveData(item)
  155. fmt.Println(v.ChartId)
  156. }
  157. }
  158. // 添加产业资源包
  159. func AddComprehensiveIndustrialSource(sourceType string, articleId int) {
  160. var err error
  161. defer func() {
  162. if err != nil {
  163. fmt.Println(err)
  164. go utils.SendAlarmMsg("AddComprehensiveIndustrialSource"+err.Error(), 2)
  165. }
  166. }()
  167. var condition string
  168. var pars []interface{}
  169. mapActivitySubject := make(map[int][]string, 0)
  170. maplistMeetingTime := make(map[int]time.Time, 0)
  171. listMeeting, err := models.GetCygxMorningMeetingReviewChapterList(" GROUP BY c.industry_id ORDER BY r.publish_time DESC ", pars)
  172. for _, v := range listMeeting {
  173. resultTime := utils.StrTimeToTime(v.PublishTime)
  174. maplistMeetingTime[v.IndustryId] = resultTime
  175. }
  176. listsubject, e := models.GetCygxIndustrialSubjectListCondition(condition, pars)
  177. if e != nil {
  178. err = errors.New("GetIndustrialManagementRepList, Err: " + e.Error())
  179. return
  180. }
  181. for _, v := range listsubject {
  182. mapActivitySubject[v.IndustrialManagementId] = append(mapActivitySubject[v.IndustrialManagementId], v.SubjectName)
  183. }
  184. var industrialsource string
  185. if sourceType == "Hz" {
  186. condition = " AND a.article_type_id = 0 " // 弘则资源包
  187. industrialsource = "industrialsourceHz"
  188. } else {
  189. condition = " AND a.article_type_id > 0 " //研选资源包
  190. industrialsource = "industrialsourceYx"
  191. }
  192. if articleId > 0 {
  193. condition += " AND a.article_id = " + strconv.Itoa(articleId)
  194. }
  195. list, err := models.GetSearchResourceList(0, condition, 0, 0)
  196. if err != nil {
  197. fmt.Println(err)
  198. return
  199. }
  200. //indexName := utils.IndexNameComprehensive
  201. for _, v := range list {
  202. time.Sleep(200 * time.Millisecond)
  203. item := new(ElasticComprehensiveDetail)
  204. item.SourceId = v.IndustrialManagementId
  205. item.Source = industrialsource
  206. item.IndustryName = v.IndustryName
  207. item.SubjectNames = strings.Join(mapActivitySubject[v.IndustrialManagementId], ",")
  208. item.PublishDate = v.PublishDate + " 00:00:00"
  209. if sourceType == "Hz" {
  210. //如果时间晚就进行替换
  211. resultTime := utils.StrTimeToTime(item.PublishDate)
  212. if maplistMeetingTime[v.IndustrialManagementId].After(resultTime) {
  213. item.PublishDate = maplistMeetingTime[v.IndustrialManagementId].Format(utils.FormatDateTime)
  214. }
  215. }
  216. fmt.Println(item)
  217. EsAddOrEditComprehensiveData(item)
  218. }
  219. }
  220. // 添加晨会精华
  221. func AddComprehensiveMeetingreviewchapt() {
  222. var condition string
  223. var pars []interface{}
  224. IndustrialManagementRespMap, _ := GetIndustrialManagementRespMap()
  225. list, err := models.GetCygxMorningMeetingReviewChapterList(condition, pars)
  226. if err != nil {
  227. fmt.Println(err)
  228. return
  229. }
  230. //indexName := utils.IndexNameComprehensive
  231. for _, v := range list {
  232. time.Sleep(200 * time.Millisecond)
  233. content := html.UnescapeString(v.Content)
  234. doc, err := goquery.NewDocumentFromReader(strings.NewReader(content))
  235. if err != nil {
  236. fmt.Println("create doc err:", err.Error())
  237. return
  238. }
  239. bodyText := doc.Text()
  240. item := new(ElasticComprehensiveDetail)
  241. item.SourceId = v.Id
  242. item.Source = "meetingreviewchapt"
  243. item.IndustryName = IndustrialManagementRespMap[v.IndustryId]
  244. item.PublishDate = v.PublishTime
  245. item.Abstract = bodyText
  246. EsAddOrEditComprehensiveData(item)
  247. fmt.Println(item)
  248. }
  249. }
  250. // 添加活动
  251. func AddComprehensiveActivity() {
  252. var condition string
  253. var pars []interface{}
  254. condition = ` AND publish_status = 1 `
  255. //condition = ` AND publish_status = 1 AND activity_id = 2407 `
  256. list, err := models.GetCygxActivityList(condition, pars, 0, 100000)
  257. if err != nil {
  258. fmt.Println(err)
  259. return
  260. }
  261. IndustrialManagementRespMap, _ := GetIndustrialManagementRespMap()
  262. IndustrialSubjectMap, _ := GetCygxIndustrialSubjectMap()
  263. var condition1 string
  264. var pars1 []interface{}
  265. mapActivityIndustrialManagement := make(map[int][]string)
  266. industrialgroupList, e := models.GetCygxIndustrialActivityGroupManagementList(condition1+" AND source = 1 ", pars1)
  267. if e != nil {
  268. fmt.Println(e)
  269. return
  270. }
  271. for _, v := range industrialgroupList {
  272. if v.ActivityId == 0 {
  273. continue
  274. }
  275. mapActivityIndustrialManagement[v.ActivityId] = append(mapActivityIndustrialManagement[v.ActivityId], IndustrialManagementRespMap[v.IndustrialManagementId])
  276. }
  277. mapActivitySubject := make(map[int][]string)
  278. SubjectgroupList, e := models.GetCygxIndustrialActivityGroupSubjectList(condition1+" AND source = 1 ", pars1)
  279. if e != nil {
  280. fmt.Println(e)
  281. return
  282. }
  283. for _, v := range SubjectgroupList {
  284. if v.ActivityId == 0 {
  285. continue
  286. }
  287. mapActivitySubject[v.ActivityId] = append(mapActivitySubject[v.ActivityId], IndustrialSubjectMap[v.IndustrialSubjectId])
  288. }
  289. //return
  290. for _, v := range list {
  291. time.Sleep(200 * time.Millisecond)
  292. item := new(ElasticComprehensiveDetail)
  293. item.SourceId = v.ActivityId
  294. //item.IsSummary = v.IsSummary
  295. item.Source = "activity"
  296. //item.SubjectNames = json.Sprint(mapActivitySubject[v.ActivityId])
  297. item.SubjectNames = strings.Join(mapActivitySubject[v.ActivityId], ",")
  298. item.IndustryName = strings.Join(mapActivityIndustrialManagement[v.ActivityId], ",")
  299. item.Title = v.ActivityName
  300. item.PublishDate = v.ActivityTime
  301. //item.BodyText = bodyText
  302. //item.Annotation, _ = GetReportContentTextSubNew(v.Annotation)
  303. //item.Abstract, _ = GetReportContentTextSubNew(v.Abstract)
  304. //EsAddOrEditComprehensiveData(indexName, item)
  305. EsAddOrEditComprehensiveData(item)
  306. fmt.Println(item)
  307. }
  308. }
  309. // 添加专项调研活动
  310. func AddComprehensiveActivitySpecial() {
  311. var condition string
  312. var pars []interface{}
  313. condition = ` AND publish_status = 1 `
  314. list, err := models.GetActivitySpecialListAll(condition, pars, 0, 100000)
  315. if err != nil {
  316. fmt.Println(err)
  317. return
  318. }
  319. //indexName := utils.IndexNameComprehensive
  320. IndustrialManagementRespMap, _ := GetIndustrialManagementRespMap() // 产业标签
  321. IndustrialSubjectMap, _ := GetCygxIndustrialSubjectMap() // 标的标签
  322. var condition1 string
  323. var pars1 []interface{}
  324. mapActivityIndustrialManagement := make(map[int][]string)
  325. industrialgroupList, e := models.GetCygxIndustrialActivityGroupManagementList(condition1+" AND source = 2 ", pars1)
  326. if e != nil {
  327. fmt.Println(e)
  328. return
  329. }
  330. for _, v := range industrialgroupList {
  331. if v.ActivityId == 0 {
  332. continue
  333. }
  334. mapActivityIndustrialManagement[v.ActivityId] = append(mapActivityIndustrialManagement[v.ActivityId], IndustrialManagementRespMap[v.IndustrialManagementId])
  335. }
  336. mapActivitySubject := make(map[int][]string)
  337. SubjectgroupList, e := models.GetCygxIndustrialActivityGroupSubjectList(condition1+" AND source = 2 ", pars1)
  338. if e != nil {
  339. fmt.Println(e)
  340. return
  341. }
  342. for _, v := range SubjectgroupList {
  343. if v.ActivityId == 0 {
  344. continue
  345. }
  346. mapActivitySubject[v.ActivityId] = append(mapActivitySubject[v.ActivityId], IndustrialSubjectMap[v.IndustrialSubjectId])
  347. }
  348. for _, v := range list {
  349. time.Sleep(200 * time.Millisecond)
  350. item := new(ElasticComprehensiveDetail)
  351. item.SourceId = v.ActivityId
  352. item.Source = "activityspecial"
  353. item.Title = v.ResearchTheme
  354. item.PublishDate = v.ActivityTime
  355. if v.ActivityTime == utils.FormatDateTimeInit {
  356. item.PublishDate = v.LastUpdatedTime.Format(utils.FormatDateTime)
  357. } else {
  358. item.PublishDate = v.ActivityTime
  359. }
  360. item.SubjectNames = strings.Join(mapActivitySubject[v.ActivityId], ",")
  361. item.IndustryName = strings.Join(mapActivityIndustrialManagement[v.ActivityId], ",")
  362. EsAddOrEditComprehensiveData(item)
  363. }
  364. }
  365. // 添加活动视频
  366. func AddComprehensiveActivityVideo() {
  367. var err error
  368. defer func() {
  369. if err != nil {
  370. fmt.Println(err)
  371. go utils.SendAlarmMsg("添加活动视频综合页面数据Es失败"+err.Error(), 2)
  372. }
  373. }()
  374. var condition string
  375. var pars []interface{}
  376. list, e := models.GetActivityVideoListAll(condition, pars, 0, 100000)
  377. if e != nil {
  378. err = errors.New("GetActivityVideoListAll, Err: " + e.Error())
  379. return
  380. }
  381. if len(list) == 0 {
  382. return
  383. }
  384. var activityIds []int
  385. for _, v := range list {
  386. activityIds = append(activityIds, v.ActivityId)
  387. }
  388. pars = make([]interface{}, 0)
  389. condition = ` AND publish_status = 1 AND art.activity_id IN (` + utils.GetOrmInReplace(len(activityIds)) + `)`
  390. pars = append(pars, activityIds)
  391. listArt, e := models.GetCygxActivityList(condition, pars, 0, 100000)
  392. if e != nil {
  393. err = errors.New("GetCygxActivityList, Err: " + e.Error())
  394. return
  395. }
  396. mapActivity := make(map[int]string)
  397. for _, v := range listArt {
  398. mapActivity[v.ActivityId] = v.ActivityName
  399. }
  400. IndustrialManagementRespMap, _ := GetIndustrialManagementRespMap()
  401. IndustrialSubjectMap, _ := GetCygxIndustrialSubjectMap()
  402. var condition1 string
  403. var pars1 []interface{}
  404. mapActivityIndustrialManagement := make(map[int][]string)
  405. industrialgroupList, e := models.GetCygxIndustrialActivityGroupManagementList(condition1+" AND source = 1 ", pars1)
  406. if e != nil {
  407. fmt.Println(e)
  408. return
  409. }
  410. //产业名称
  411. for _, v := range industrialgroupList {
  412. if v.ActivityId == 0 {
  413. continue
  414. }
  415. mapActivityIndustrialManagement[v.ActivityId] = append(mapActivityIndustrialManagement[v.ActivityId], IndustrialManagementRespMap[v.IndustrialManagementId])
  416. }
  417. //标的名称
  418. mapActivitySubject := make(map[int][]string)
  419. SubjectgroupList, e := models.GetCygxIndustrialActivityGroupSubjectList(condition1+" AND source = 1 ", pars1)
  420. if e != nil {
  421. fmt.Println(e)
  422. return
  423. }
  424. for _, v := range SubjectgroupList {
  425. if v.ActivityId == 0 {
  426. continue
  427. }
  428. mapActivitySubject[v.ActivityId] = append(mapActivitySubject[v.ActivityId], IndustrialSubjectMap[v.IndustrialSubjectId])
  429. }
  430. //indexName := utils.IndexNameComprehensive
  431. for _, v := range list {
  432. time.Sleep(200 * time.Millisecond)
  433. item := new(ElasticComprehensiveDetail)
  434. item.SourceId = v.Id
  435. item.Source = "activityvideo"
  436. item.Title = v.Title
  437. item.PublishDate = v.ActivityTime
  438. item.BodyText = mapActivity[v.ActivityId]
  439. item.SubjectNames = strings.Join(mapActivitySubject[v.ActivityId], ",")
  440. item.IndustryName = strings.Join(mapActivityIndustrialManagement[v.ActivityId], ",")
  441. EsAddOrEditComprehensiveData(item)
  442. fmt.Println(item)
  443. }
  444. }
  445. // 添加活动音频
  446. func AddComprehensiveActivityVoice() {
  447. var err error
  448. defer func() {
  449. if err != nil {
  450. fmt.Println(err)
  451. go utils.SendAlarmMsg("AddComprehensiveActivityVoice"+err.Error(), 2)
  452. }
  453. }()
  454. var condition string
  455. var pars []interface{}
  456. list, err := models.GetActivityVoiceList(condition, pars, 0, 100000)
  457. if err != nil {
  458. fmt.Println(err)
  459. return
  460. }
  461. if len(list) == 0 {
  462. return
  463. }
  464. var activityIds []int
  465. for _, v := range list {
  466. activityIds = append(activityIds, v.ActivityId)
  467. }
  468. pars = make([]interface{}, 0)
  469. condition = ` AND publish_status = 1 AND art.activity_id IN (` + utils.GetOrmInReplace(len(activityIds)) + `)`
  470. pars = append(pars, activityIds)
  471. listArt, e := models.GetCygxActivityList(condition, pars, 0, 100000)
  472. if e != nil {
  473. err = errors.New("GetCygxActivityList, Err: " + e.Error())
  474. return
  475. }
  476. mapActivity := make(map[int]string)
  477. for _, v := range listArt {
  478. mapActivity[v.ActivityId] = v.ActivityName
  479. }
  480. IndustrialManagementRespMap, _ := GetIndustrialManagementRespMap()
  481. IndustrialSubjectMap, _ := GetCygxIndustrialSubjectMap()
  482. var condition1 string
  483. var pars1 []interface{}
  484. mapActivityIndustrialManagement := make(map[int][]string)
  485. industrialgroupList, e := models.GetCygxIndustrialActivityGroupManagementList(condition1+" AND source = 1 ", pars1)
  486. if e != nil {
  487. fmt.Println(e)
  488. return
  489. }
  490. //产业名称
  491. for _, v := range industrialgroupList {
  492. if v.ActivityId == 0 {
  493. continue
  494. }
  495. mapActivityIndustrialManagement[v.ActivityId] = append(mapActivityIndustrialManagement[v.ActivityId], IndustrialManagementRespMap[v.IndustrialManagementId])
  496. }
  497. //标的名称
  498. mapActivitySubject := make(map[int][]string)
  499. SubjectgroupList, e := models.GetCygxIndustrialActivityGroupSubjectList(condition1+" AND source = 1 ", pars1)
  500. if e != nil {
  501. fmt.Println(e)
  502. return
  503. }
  504. for _, v := range SubjectgroupList {
  505. if v.ActivityId == 0 {
  506. continue
  507. }
  508. mapActivitySubject[v.ActivityId] = append(mapActivitySubject[v.ActivityId], IndustrialSubjectMap[v.IndustrialSubjectId])
  509. }
  510. //indexName := utils.IndexNameComprehensive
  511. for _, v := range list {
  512. time.Sleep(200 * time.Millisecond)
  513. item := new(ElasticComprehensiveDetail)
  514. item.SourceId = v.ActivityVoiceId
  515. item.Source = "activityvoice"
  516. item.Title = v.VoiceName
  517. item.PublishDate = v.ActivityTime
  518. item.BodyText = mapActivity[v.ActivityId]
  519. item.SubjectNames = strings.Join(mapActivitySubject[v.ActivityId], ",")
  520. item.IndustryName = strings.Join(mapActivityIndustrialManagement[v.ActivityId], ",")
  521. EsAddOrEditComprehensiveData(item)
  522. fmt.Println(item)
  523. }
  524. }
  525. // 微路演
  526. func AddComprehensiveRoadshow() {
  527. var condition string
  528. var pars []interface{}
  529. IndustrialManagementRespMap, _ := GetIndustrialManagementRespMap()
  530. list, err := models.GetMicroRoadshowVideoListBycondition(condition, pars, 0, 100000)
  531. if err != nil {
  532. fmt.Println(err)
  533. return
  534. }
  535. //indexName := utils.IndexNameComprehensive
  536. for _, v := range list {
  537. time.Sleep(200 * time.Millisecond)
  538. item := new(ElasticComprehensiveDetail)
  539. item.SourceId = v.VideoId
  540. item.Source = "roadshow"
  541. item.IndustryName = IndustrialManagementRespMap[v.IndustryId]
  542. item.Title = v.VideoName
  543. item.PublishDate = v.PublishDate.Format(utils.FormatDateTime)
  544. EsAddOrEditComprehensiveData(item)
  545. fmt.Println(item)
  546. }
  547. }
  548. // 新增和修改数据
  549. func EsAddOrEditComprehensiveData(item *ElasticComprehensiveDetail) (err error) {
  550. indexName := utils.IndexNameComprehensive
  551. //return
  552. defer func() {
  553. if err != nil {
  554. fmt.Println(err, item.SourceId)
  555. //go utils.SendAlarmMsg("更新综合页面数据Es失败"+err.Error()+fmt.Sprint(item), 2)
  556. }
  557. }()
  558. client := utils.Client
  559. mustMap := make([]interface{}, 0)
  560. mustMap = append(mustMap, map[string]interface{}{
  561. "term": map[string]interface{}{
  562. "SourceId": item.SourceId,
  563. },
  564. })
  565. mustMap = append(mustMap, map[string]interface{}{
  566. "term": map[string]interface{}{
  567. "Source": item.Source,
  568. },
  569. })
  570. queryMap := map[string]interface{}{
  571. "query": map[string]interface{}{
  572. "bool": map[string]interface{}{
  573. "must": mustMap,
  574. },
  575. },
  576. }
  577. requestTotalHits := client.Count(indexName).BodyJson(queryMap)
  578. total, e := requestTotalHits.Do(context.Background())
  579. if e != nil {
  580. err = errors.New("requestTotalHits.Do(context.Background()), Err: " + e.Error())
  581. return
  582. }
  583. //return
  584. //根据来源以及ID ,判断内容是否存在,如果存在就新增,如果不存在就修改
  585. if total == 0 {
  586. resp, e := client.Index().Index(indexName).BodyJson(item).Do(context.Background())
  587. if e != nil {
  588. err = errors.New("client.Index().Index(indexName).BodyJson(item).Do(context.Background()), Err: " + e.Error())
  589. return
  590. }
  591. if resp.Status == 0 && resp.Result == "created" {
  592. //fmt.Println("新增成功")
  593. //err = nil
  594. return
  595. } else {
  596. //err = errors.New(fmt.Sprint(resp))
  597. err = errors.New(fmt.Sprint("articleId", item.SourceId))
  598. return
  599. }
  600. } else {
  601. //拼接需要改动的前置条件
  602. bool_query := elastic.NewBoolQuery()
  603. bool_query.Must(elastic.NewTermQuery("SourceId", item.SourceId))
  604. bool_query.Must(elastic.NewTermQuery("Source", item.Source))
  605. //设置需要改动的内容
  606. var script string
  607. script += fmt.Sprint("ctx._source['SubjectNames'] = '", item.SubjectNames, "';")
  608. script += fmt.Sprint("ctx._source['PublishDate'] = '", item.PublishDate, "';")
  609. script += fmt.Sprint("ctx._source['IsSummary'] = ", item.IsSummary, ";")
  610. script += fmt.Sprint("ctx._source['Abstract'] = '", item.Abstract, "';")
  611. script += fmt.Sprint("ctx._source['Title'] = '", item.Title, "';")
  612. script += fmt.Sprint("ctx._source['BodyText'] = '", item.BodyText, "';")
  613. script += fmt.Sprint("ctx._source['Annotation'] = '", item.Annotation, "';")
  614. script += fmt.Sprint("ctx._source['IndustryName'] = '", item.IndustryName, "'")
  615. _, e = client.UpdateByQuery(indexName).
  616. Query(bool_query).
  617. Script(elastic.NewScriptInline(script)).
  618. Refresh("true").
  619. Do(context.Background())
  620. if e != nil && e.Error() != "elastic: Error 400 (Bad Request): compile error [type=script_exception]" {
  621. //文本内容过长的时候,修改会报 400 的错误,暂时先不处理
  622. //fmt.Println("err", e.Error())
  623. ////err = e
  624. //err = errors.New("client.UpdateByQuery(indexName), Err: " + e.Error())
  625. return
  626. }
  627. }
  628. return
  629. }
  630. // 删除数据
  631. func EsDeleteComprehensiveData(item *ElasticComprehensiveDetail) (err error) {
  632. defer func() {
  633. if err != nil {
  634. fmt.Println(err)
  635. go utils.SendAlarmMsg("删除数据综合页面数据Es失败"+err.Error()+fmt.Sprint(item), 2)
  636. }
  637. }()
  638. indexName := utils.IndexNameComprehensive
  639. client := utils.Client
  640. //拼接需要删除的前置条件
  641. bool_query := elastic.NewBoolQuery()
  642. bool_query.Must(elastic.NewTermQuery("SourceId", item.SourceId))
  643. bool_query.Must(elastic.NewTermQuery("Source", item.Source))
  644. _, e := client.DeleteByQuery(indexName).
  645. Query(bool_query).
  646. Do(context.Background())
  647. if e != nil {
  648. err = errors.New(" client.DeleteByQuery(indexName), Err: " + e.Error())
  649. return
  650. }
  651. return
  652. }
  653. func EsComprehensiveSearch(keyWord string, startSize, pageSize int) (result []*SearchComprehensiveItem, total int64, err error) {
  654. indexName := utils.IndexNameComprehensive
  655. client := utils.Client
  656. keyWordArr, err := GetIndustryMapNameSliceV3(keyWord)
  657. keyWordArr = RemoveDuplicatesAndEmpty(keyWordArr)
  658. keyWordLen := len(keyWordArr)
  659. if keyWordLen <= 0 {
  660. keyWordArr = append(keyWordArr, keyWord)
  661. keyWordLen = len(keyWordArr)
  662. }
  663. //Es 的高级查询有 自定义排序 文档一时半会儿撸不懂,先做多次查询手动过滤 2023.2.2
  664. //ikType 查询方式 ,0:查所有 、 1:查询键入词 、 2:查询除了查询键入词之外的联想词
  665. mustMap := make([]interface{}, 0)
  666. shouldMap := make(map[string]interface{}, 0)
  667. shouldMapquery := make([]interface{}, 0)
  668. mustNotMap := make([]interface{}, 0)
  669. shouldNotMap := make(map[string]interface{}, 0)
  670. shouldNotMapquery := make([]interface{}, 0)
  671. // @Param OrderColumn query int true "排序字段 ,Comprehensive综合 ,Matching匹配度 ,PublishDate 发布时间 "
  672. //keyWordWeight := GetWeight(keyWordLen)
  673. var boost int
  674. //lenkeyWordArr := len(keyWordArr)
  675. for k, v := range keyWordArr {
  676. if k > 0 {
  677. continue
  678. }
  679. if k == 0 {
  680. boost = 2 * 1000
  681. } else {
  682. boost = 1
  683. }
  684. if v != "" {
  685. shouldMapquery = append(shouldMapquery, map[string]interface{}{
  686. "function_score": map[string]interface{}{
  687. "query": map[string]interface{}{
  688. "multi_match": map[string]interface{}{
  689. //"boost": (lenkeyWordArr - k) * boost, //给查询的值赋予权重
  690. "boost": boost, //给查询的值赋予权重
  691. "fields": []interface{}{"Title"},
  692. "query": v,
  693. },
  694. },
  695. },
  696. })
  697. shouldMapquery = append(shouldMapquery, map[string]interface{}{
  698. "function_score": map[string]interface{}{
  699. "query": map[string]interface{}{
  700. "multi_match": map[string]interface{}{
  701. "boost": boost, //给查询的值赋予权重
  702. "fields": []interface{}{"Abstract"},
  703. "query": v,
  704. },
  705. },
  706. },
  707. })
  708. shouldMapquery = append(shouldMapquery, map[string]interface{}{
  709. "function_score": map[string]interface{}{
  710. "query": map[string]interface{}{
  711. "multi_match": map[string]interface{}{
  712. "boost": boost, //给查询的值赋予权重
  713. "fields": []interface{}{"Annotation"},
  714. "query": v,
  715. },
  716. },
  717. },
  718. })
  719. //shouldMapquery = append(shouldMapquery, map[string]interface{}{
  720. // "function_score": map[string]interface{}{
  721. // "query": map[string]interface{}{
  722. // "multi_match": map[string]interface{}{
  723. // //"boost": (lenkeyWordArr-k)*boost - 1, //给查询的值赋予权重
  724. // "boost": boost, //给查询的值赋予权重
  725. // "fields": []interface{}{"BodyText"},
  726. // "query": v,
  727. // },
  728. // },
  729. // },
  730. //})
  731. shouldMapquery = append(shouldMapquery, map[string]interface{}{
  732. "function_score": map[string]interface{}{
  733. "query": map[string]interface{}{
  734. "multi_match": map[string]interface{}{
  735. //"boost": (lenkeyWordArr-k)*boost - 1, //给查询的值赋予权重
  736. "boost": boost, //给查询的值赋予权重
  737. "fields": []interface{}{"IndustryName"},
  738. "query": v,
  739. },
  740. },
  741. },
  742. })
  743. shouldMapquery = append(shouldMapquery, map[string]interface{}{
  744. "function_score": map[string]interface{}{
  745. "query": map[string]interface{}{
  746. "multi_match": map[string]interface{}{
  747. //"boost": (lenkeyWordArr-k)*boost - 1, //给查询的值赋予权重
  748. "boost": boost, //给查询的值赋予权重
  749. "fields": []interface{}{"SubjectNames"},
  750. "query": v,
  751. },
  752. },
  753. },
  754. })
  755. }
  756. }
  757. shouldMap = map[string]interface{}{
  758. "should": shouldMapquery,
  759. }
  760. shouldNotMap = map[string]interface{}{
  761. "should": shouldNotMapquery,
  762. }
  763. //排序
  764. sortMap := make([]interface{}, 0)
  765. //时间
  766. sortMap = append(sortMap, map[string]interface{}{
  767. "PublishDate": map[string]interface{}{
  768. "order": "desc",
  769. },
  770. })
  771. //sortMap = append(sortMap, map[string]interface{}{
  772. // "_score": map[string]interface{}{
  773. // "order": "desc",
  774. // },
  775. //})
  776. //高亮
  777. highlightMap := make(map[string]interface{}, 0)
  778. highlightMap = map[string]interface{}{
  779. "fields": map[string]interface{}{
  780. //"BodyText": map[string]interface{}{},
  781. "Title": map[string]interface{}{},
  782. "Abstract": map[string]interface{}{},
  783. "Annotation": map[string]interface{}{},
  784. },
  785. //样式 红色
  786. "post_tags": []interface{}{"</font>"},
  787. "pre_tags": []interface{}{"<font color='red'>"},
  788. "fragment_size": 50,
  789. }
  790. mustMap = append(mustMap, map[string]interface{}{
  791. "bool": shouldMap,
  792. })
  793. mustNotMap = append(mustNotMap, map[string]interface{}{
  794. "bool": shouldNotMap,
  795. })
  796. queryMap := map[string]interface{}{
  797. "query": map[string]interface{}{
  798. "bool": map[string]interface{}{
  799. "must": mustMap,
  800. },
  801. },
  802. }
  803. queryMap["sort"] = sortMap
  804. queryMap["from"] = startSize
  805. queryMap["size"] = pageSize
  806. queryMap["highlight"] = highlightMap
  807. //jsonBytes, _ := json.Marshal(queryMap)
  808. //fmt.Println(string(jsonBytes))
  809. //utils.FileLog.Info(string(jsonBytes))
  810. request := client.Search(indexName).Source(queryMap) // sets the JSON request
  811. searchByMatch, err := request.Do(context.Background())
  812. if searchByMatch != nil {
  813. if searchByMatch.Hits != nil {
  814. for _, v := range searchByMatch.Hits.Hits {
  815. var isAppend bool
  816. articleJson, err := v.Source.MarshalJSON()
  817. if err != nil {
  818. return nil, 0, err
  819. }
  820. article := new(ElasticComprehensiveDetail)
  821. err = json.Unmarshal(articleJson, &article)
  822. if err != nil {
  823. return nil, 0, err
  824. }
  825. //fmt.Println(article.SourceId, article.Title, article.Source)
  826. searchItem := new(SearchComprehensiveItem)
  827. searchItem.SourceId = article.SourceId
  828. if len(v.Highlight["Annotation"]) > 0 {
  829. for _, vText := range v.Highlight["Annotation"] {
  830. searchItem.Body = append(searchItem.Body, vText)
  831. }
  832. }
  833. if len(v.Highlight["Abstract"]) > 0 {
  834. for _, vText := range v.Highlight["Abstract"] {
  835. searchItem.Body = append(searchItem.Body, vText)
  836. }
  837. }
  838. if len(v.Highlight["BodyText"]) > 0 {
  839. for _, vText := range v.Highlight["BodyText"] {
  840. searchItem.Body = append(searchItem.Body, vText)
  841. }
  842. }
  843. //searchItem.IsSummary = article.IsSummary
  844. //if len(searchItem.Body) == 0 {
  845. // bodyRune := []rune(article.BodyText)
  846. // bodyRuneLen := len(bodyRune)
  847. // if bodyRuneLen > 100 {
  848. // bodyRuneLen = 100
  849. // }
  850. // body := string(bodyRune[:bodyRuneLen])
  851. // searchItem.Body = []string{body}
  852. //}
  853. var title string
  854. if len(v.Highlight["Title"]) > 0 {
  855. title = v.Highlight["Title"][0]
  856. } else {
  857. title = article.Title
  858. }
  859. searchItem.Title = title
  860. searchItem.Source = article.Source
  861. searchItem.PublishDate = article.PublishDate
  862. if !isAppend {
  863. result = append(result, searchItem)
  864. }
  865. }
  866. }
  867. total = searchByMatch.Hits.TotalHits.Value
  868. }
  869. return
  870. }
  871. func GetResourceDataEsList(list []*SearchComprehensiveItem, user *models.WxUserItem) (items []*models.CygxResourceDataResp, err error) {
  872. var condition string
  873. var pars []interface{}
  874. uid := user.UserId
  875. titleHighlight := make(map[int]string)
  876. bodyHighlight := make(map[int][]string)
  877. //var bodyHighlight []string
  878. mapItems := make(map[string]*models.CygxResourceDataResp)
  879. for _, v := range list {
  880. //预处理文章
  881. item := new(models.CygxResourceDataResp)
  882. item.SourceId = v.SourceId
  883. item.Source = v.Source
  884. //if v.IsSummary == 1 {
  885. item.BodyHighlight = v.Body
  886. titleHighlight[v.SourceId] = v.Title
  887. bodyHighlight[v.SourceId] = v.Body
  888. //fmt.Println(v.Title)
  889. //} else {
  890. // item.BodyHighlight = make([]string, 0)
  891. //}
  892. item.PublishDate = utils.TimeRemoveHms2(v.PublishDate)
  893. mapItems[fmt.Sprint(v.Source, v.SourceId)] = item
  894. }
  895. var articleIds []int
  896. var newchartIds []int
  897. var roadshowIds []string
  898. var activityIds []int
  899. var activityvideoIds []string
  900. var activityvoiceIds []string
  901. var activityspecialIds []int
  902. var researchsummaryIds []int
  903. var minutessummaryIds []int
  904. var meetingreviewchaptIds []int
  905. var productinteriorIds []int
  906. var industrialResourceIdsHz []int // 弘则产业资源包
  907. var industrialResourceIdsYx []int // 研选产业资源包
  908. //Source string `description:"资源类型 报告 :article 、图表 :newchart、微路演 :roadshow、活动 :activity、活动视频:activityvideo、活动音频:activityvoice、专项调研活动:activityspecial 、 本周研究汇总: researchsummary 、 上周纪要汇总 :minutessummary 、晨会精华 :meetingreviewchapt "`
  909. for _, v := range list {
  910. if v.Source == "article" {
  911. articleIds = append(articleIds, v.SourceId)
  912. } else if v.Source == "newchart" {
  913. newchartIds = append(newchartIds, v.SourceId)
  914. } else if v.Source == "roadshow" {
  915. roadshowIds = append(roadshowIds, strconv.Itoa(v.SourceId))
  916. } else if v.Source == "activity" {
  917. activityIds = append(activityIds, v.SourceId)
  918. } else if v.Source == "activityvideo" {
  919. activityvideoIds = append(activityvideoIds, strconv.Itoa(v.SourceId))
  920. } else if v.Source == "activityvoice" {
  921. activityvoiceIds = append(activityvoiceIds, strconv.Itoa(v.SourceId))
  922. } else if v.Source == "activityspecial" {
  923. activityspecialIds = append(activityspecialIds, v.SourceId)
  924. } else if v.Source == "researchsummary" {
  925. researchsummaryIds = append(researchsummaryIds, v.SourceId)
  926. } else if v.Source == "minutessummary" {
  927. minutessummaryIds = append(minutessummaryIds, v.SourceId)
  928. } else if v.Source == "meetingreviewchapt" {
  929. meetingreviewchaptIds = append(meetingreviewchaptIds, v.SourceId)
  930. } else if v.Source == "productinterior" {
  931. productinteriorIds = append(productinteriorIds, v.SourceId)
  932. } else if v.Source == "industrialsourceHz" {
  933. industrialResourceIdsHz = append(industrialResourceIdsHz, v.SourceId)
  934. } else if v.Source == "industrialsourceYx" {
  935. industrialResourceIdsYx = append(industrialResourceIdsYx, v.SourceId)
  936. }
  937. }
  938. //处理文章
  939. if len(articleIds) > 0 {
  940. pars = make([]interface{}, 0)
  941. condition = ` AND a.article_id IN (` + utils.GetOrmInReplace(len(articleIds)) + `)`
  942. pars = append(pars, articleIds)
  943. listArticle, e := models.GetHomeList(condition, pars, 0, len(articleIds))
  944. if e != nil {
  945. err = errors.New("GetResourceDataList, Err: " + e.Error())
  946. return
  947. }
  948. listArticle, e = HandleArticleCategoryImg(listArticle)
  949. if e != nil {
  950. err = errors.New("HandleArticleCategoryImg, Err: " + e.Error())
  951. return
  952. }
  953. for _, v := range listArticle {
  954. v.Body = ""
  955. v.BodyHtml = ""
  956. if titleHighlight[v.ArticleId] != "" {
  957. v.Title = titleHighlight[v.ArticleId]
  958. }
  959. if len(bodyHighlight[v.ArticleId]) > 0 {
  960. v.Abstract = ""
  961. v.Annotation = ""
  962. v.BodyHighlight = bodyHighlight[v.ArticleId]
  963. } else {
  964. v.BodyHighlight = make([]string, 0)
  965. }
  966. mapItems[fmt.Sprint("article", v.ArticleId)].Article = v
  967. }
  968. }
  969. //处理晨会精华
  970. if len(meetingreviewchaptIds) > 0 {
  971. pars = make([]interface{}, 0)
  972. condition = ` AND c.id IN (` + utils.GetOrmInReplace(len(meetingreviewchaptIds)) + `)`
  973. pars = append(pars, meetingreviewchaptIds)
  974. listrMeet, e := models.GetCygxMorningMeetingReviewChapterList(condition, pars)
  975. if e != nil {
  976. err = errors.New("GetResourceDataList, Err: " + e.Error())
  977. return
  978. }
  979. for _, v := range listrMeet {
  980. v.Content = AnnotationHtml(v.Content)
  981. v.PublishTime = utils.TimeRemoveHms2(v.PublishTime)
  982. mapItems[fmt.Sprint("meetingreviewchapt", v.Id)].Meetingreviewchapt = v
  983. }
  984. }
  985. //处理上周纪要汇总
  986. if len(minutessummaryIds) > 0 {
  987. pars = make([]interface{}, 0)
  988. condition = ` AND article_id IN (` + utils.GetOrmInReplace(len(minutessummaryIds)) + `)`
  989. pars = append(pars, minutessummaryIds)
  990. listresearchsummary, e := models.GetReportSelectionListHome(condition, "cygx_minutes_summary", pars, 0, len(minutessummaryIds))
  991. if e != nil {
  992. err = errors.New("GetResourceDataList, Err: " + e.Error())
  993. return
  994. }
  995. for _, v := range listresearchsummary {
  996. v.PublishDate = utils.TimeRemoveHms2(v.PublishDate)
  997. mapItems[fmt.Sprint("minutessummary", v.ArticleId)].Minutessummary = v
  998. }
  999. }
  1000. //处理本周纪要汇总
  1001. if len(researchsummaryIds) > 0 {
  1002. pars = make([]interface{}, 0)
  1003. condition = ` AND article_id IN (` + utils.GetOrmInReplace(len(researchsummaryIds)) + `)`
  1004. pars = append(pars, researchsummaryIds)
  1005. listresearchsummary, e := models.GetReportSelectionListHome(condition, "cygx_research_summary", pars, 0, len(researchsummaryIds))
  1006. if e != nil {
  1007. err = errors.New("GetReportSelectionListHome, Err: " + e.Error())
  1008. return
  1009. }
  1010. for _, v := range listresearchsummary {
  1011. v.PublishDate = utils.TimeRemoveHms2(v.PublishDate)
  1012. mapItems[fmt.Sprint("researchsummary", v.ArticleId)].Researchsummary = v
  1013. }
  1014. }
  1015. //处理产品内测
  1016. if len(productinteriorIds) > 0 {
  1017. pars = make([]interface{}, 0)
  1018. condition = ` AND art.status = 1 AND art.product_interior_id IN (` + utils.GetOrmInReplace(len(productinteriorIds)) + `)`
  1019. pars = append(pars, productinteriorIds)
  1020. listProductInterior, e := models.GetCygxProductInteriorList(condition, pars, 0, len(productinteriorIds))
  1021. if e != nil {
  1022. err = errors.New("GetCygxProductInteriorList, Err: " + e.Error())
  1023. return
  1024. }
  1025. for _, v := range listProductInterior {
  1026. v.Body = ProductInteriorHtml(v.Body)
  1027. v.PublishTime = utils.TimeRemoveHms2(v.PublishTime)
  1028. mapItems[fmt.Sprint("productinterior", v.ProductInteriorId)].ProductInterior = v
  1029. }
  1030. }
  1031. detail, e := models.GetConfigByCode("city_img_url")
  1032. if e != nil {
  1033. err = errors.New("GetResourceDataList, Err: " + e.Error())
  1034. return
  1035. }
  1036. detailChart, e := models.GetConfigByCode("chart_img_url")
  1037. if e != nil {
  1038. err = errors.New("GetResourceDataList, Err: " + e.Error())
  1039. return
  1040. }
  1041. addressList := strings.Split(detail.ConfigValue, "{|}")
  1042. mapAddress := make(map[string]string)
  1043. chartList := strings.Split(detailChart.ConfigValue, "{|}")
  1044. mapChart := make(map[string]string)
  1045. var cityName string
  1046. var chartName string
  1047. var imgUrl string
  1048. var imgUrlChart string
  1049. for _, v := range addressList {
  1050. vslice := strings.Split(v, "_")
  1051. cityName = vslice[0]
  1052. imgUrl = vslice[len(vslice)-1]
  1053. mapAddress[cityName] = imgUrl
  1054. }
  1055. for _, v := range chartList {
  1056. vslice := strings.Split(v, "_")
  1057. chartName = vslice[0]
  1058. imgUrlChart = vslice[len(vslice)-1]
  1059. mapChart[chartName] = imgUrlChart
  1060. }
  1061. var imgUrlResp string
  1062. //处理活动
  1063. if len(activityIds) > 0 {
  1064. for _, vss := range activityIds {
  1065. imgUrlResp += strconv.Itoa(vss) + ","
  1066. }
  1067. pars = make([]interface{}, 0)
  1068. condition = ` AND art.activity_id IN (` + utils.GetOrmInReplace(len(activityIds)) + `)`
  1069. pars = append(pars, activityIds)
  1070. activityList, e := models.GetActivityListNew(condition, pars, uid, 0, len(activityIds), 0, 0, "")
  1071. if e != nil {
  1072. err = errors.New("GetResourceDataList, Err: " + e.Error())
  1073. return
  1074. }
  1075. //处理不同的报名方式按钮回显
  1076. mapActivitySignup, e := GetActivitySignupResp(activityIds, user)
  1077. if e != nil {
  1078. e = errors.New("GetActivitySignupResp, Err: " + e.Error())
  1079. return
  1080. }
  1081. var activityListRersp []*models.ActivityDetail
  1082. for _, v := range activityList {
  1083. v.SignupType = mapActivitySignup[v.ActivityId]
  1084. activityListRersp = append(activityListRersp, ActivityButtonShow(v))
  1085. }
  1086. for _, v := range activityListRersp {
  1087. if v == nil {
  1088. continue
  1089. }
  1090. if v.ActivityType == 0 {
  1091. if mapAddress[v.City] != "" {
  1092. imgUrlResp = mapAddress[v.City]
  1093. } else {
  1094. imgUrlResp = mapAddress["其它"]
  1095. }
  1096. } else {
  1097. if mapChart[v.ChartPermissionName] != "" {
  1098. imgUrlResp = mapChart[v.ChartPermissionName]
  1099. }
  1100. }
  1101. v.SourceType = 1
  1102. v.Expert, _ = GetReportContentTextSub(v.Expert)
  1103. mapItems[fmt.Sprint("activity", v.ActivityId)].Activity = v
  1104. }
  1105. }
  1106. //产业资源包
  1107. if len(industrialResourceIdsHz) > 0 {
  1108. pars = make([]interface{}, 0)
  1109. var industrialResourceIdstring []string
  1110. for _, v := range industrialResourceIdsHz {
  1111. industrialResourceIdstring = append(industrialResourceIdstring, strconv.Itoa(v))
  1112. }
  1113. industrialId := strings.Join(industrialResourceIdstring, ",")
  1114. condition = ` AND m.industrial_management_id IN (` + industrialId + `) AND a.article_type_id = 0 `
  1115. listIndustrialResourceIds, e := models.GetSearchResourceList(user.UserId, condition, 0, len(industrialResourceIdsHz))
  1116. if e != nil {
  1117. err = errors.New("GetSearchResourceList, Err: " + e.Error())
  1118. return
  1119. }
  1120. //合并产业关联的标的
  1121. listSubjcet, e := models.GetIndustrialSubjectAllByIndustrialId(industrialResourceIdsHz)
  1122. if e != nil {
  1123. e = errors.New("GetIndustrialSubjectAllByIndustrialId, Err: " + e.Error())
  1124. return
  1125. }
  1126. mapIndustrial := make(map[string]int)
  1127. for _, v := range listSubjcet {
  1128. for k2, v2 := range listIndustrialResourceIds {
  1129. if v2.IndustrialManagementId == v.IndustrialManagementId && mapIndustrial[fmt.Sprint(v2.IndustrialManagementId, "Hz", v.SubjectName)] == 0 {
  1130. listIndustrialResourceIds[k2].IndustrialSubjectList = append(listIndustrialResourceIds[k2].IndustrialSubjectList, v)
  1131. }
  1132. }
  1133. }
  1134. for _, v := range listIndustrialResourceIds {
  1135. v.Source = 1
  1136. mapItems[fmt.Sprint("industrialsourceHz", v.IndustrialManagementId)].IndustrialResource = v
  1137. }
  1138. }
  1139. if len(industrialResourceIdsYx) > 0 {
  1140. pars = make([]interface{}, 0)
  1141. var industrialResourceIdstring []string
  1142. for _, v := range industrialResourceIdsYx {
  1143. industrialResourceIdstring = append(industrialResourceIdstring, strconv.Itoa(v))
  1144. }
  1145. industrialId := strings.Join(industrialResourceIdstring, ",")
  1146. condition = ` AND m.industrial_management_id IN (` + industrialId + `) AND a.article_type_id > 0 `
  1147. listIndustrialResourceIds, e := models.GetSearchResourceList(user.UserId, condition, 0, len(industrialResourceIdsYx))
  1148. if e != nil {
  1149. err = errors.New("GetSearchResourceList, Err: " + e.Error())
  1150. return
  1151. }
  1152. //合并产业关联的标的
  1153. listSubjcet, e := models.GetIndustrialSubjectAllByIndustrialId(industrialResourceIdsYx)
  1154. if e != nil {
  1155. e = errors.New("GetIndustrialSubjectAllByIndustrialId, Err: " + e.Error())
  1156. return
  1157. }
  1158. mapIndustrial := make(map[string]int)
  1159. for _, v := range listSubjcet {
  1160. for k2, v2 := range listIndustrialResourceIds {
  1161. if v2.IndustrialManagementId == v.IndustrialManagementId && mapIndustrial[fmt.Sprint(v2.IndustrialManagementId, "Yx", v.SubjectName)] == 0 {
  1162. listIndustrialResourceIds[k2].IndustrialSubjectList = append(listIndustrialResourceIds[k2].IndustrialSubjectList, v)
  1163. }
  1164. }
  1165. }
  1166. for _, v := range listIndustrialResourceIds {
  1167. v.Source = 2
  1168. mapItems[fmt.Sprint("industrialsourceYx", v.IndustrialManagementId)].IndustrialResource = v
  1169. }
  1170. }
  1171. //处理图表
  1172. if len(newchartIds) > 0 {
  1173. pars = make([]interface{}, 0)
  1174. condition = ` AND a.chart_id IN (` + utils.GetOrmInReplace(len(newchartIds)) + `)`
  1175. pars = append(pars, newchartIds)
  1176. chartDateList, e := models.GetChartListCollectionNew(condition, pars, uid, 0, len(newchartIds))
  1177. if e != nil {
  1178. err = errors.New("GetResourceDataList, Err: " + e.Error())
  1179. return
  1180. }
  1181. for _, v := range chartDateList {
  1182. mapItems[fmt.Sprint("newchart", v.ChartId)].Newchart = v
  1183. }
  1184. }
  1185. //处理专项调研
  1186. if len(activityspecialIds) > 0 {
  1187. pars = make([]interface{}, 0)
  1188. condition = ` AND art.activity_id IN (` + utils.GetOrmInReplace(len(activityspecialIds)) + `)`
  1189. pars = append(pars, activityspecialIds)
  1190. activitySpeciallist, e := models.GetCygxActivitySpecialDetailList(condition, pars, user.UserId, 0, len(activityspecialIds))
  1191. if e != nil {
  1192. err = errors.New("GetCygxActivitySpecialDetailList, Err: " + e.Error())
  1193. return
  1194. }
  1195. UserMap, e := GetSpecialTripUserMap(activityIds, user.UserId)
  1196. if e != nil {
  1197. err = errors.New("GetSpecialTripUserMap, Err: " + e.Error())
  1198. return
  1199. }
  1200. for _, v := range activitySpeciallist {
  1201. if mapChart[v.ChartPermissionName] != "" {
  1202. imgUrlResp = mapChart[v.ChartPermissionName]
  1203. }
  1204. if _, ok := UserMap[v.ActivityId]; ok {
  1205. v.IsTrip = 1
  1206. }
  1207. if v.Days == 0 {
  1208. v.TripStatus = 1
  1209. v.TripImgLink = v.TripImgLink
  1210. } else {
  1211. v.TripStatus = 2
  1212. v.TripImgLink = v.TripImgLinkFix
  1213. v.ActivityTimeText = v.ActivityTimeTextByDay
  1214. }
  1215. resultTimeStart := utils.StrTimeToTime(v.ActivityTime) //时间字符串格式转时间格式
  1216. resultTimeEnd := utils.StrTimeToTime(v.ActivityTimeEnd) //时间字符串格式转时间格式
  1217. if resultTimeStart.After(time.Now()) {
  1218. v.ActiveState = 1
  1219. } else if time.Now().After(resultTimeEnd) {
  1220. v.ActiveState = 3
  1221. } else {
  1222. v.ActiveState = 2
  1223. }
  1224. v.ImgUrl = imgUrlResp
  1225. mapItems[fmt.Sprint("activityspecial", v.ActivityId)].Activityspecial = v
  1226. }
  1227. }
  1228. if len(roadshowIds)+len(activityvideoIds)+len(activityvoiceIds) > 0 {
  1229. audioIdstr := strings.Join(activityvoiceIds, ",")
  1230. ideoIdsStr := strings.Join(roadshowIds, ",")
  1231. activityVideoIdsStr := strings.Join(activityvideoIds, ",")
  1232. list, _, e := GetMicroRoadShowMycollect(len(roadshowIds)+len(activityvideoIds)+len(activityvoiceIds), 0, audioIdstr, ideoIdsStr, activityVideoIdsStr)
  1233. if e != nil {
  1234. err = errors.New("GetMicroRoadShowMycollect, Err: " + e.Error())
  1235. return
  1236. }
  1237. for _, item := range list {
  1238. if item.Type == 1 {
  1239. //音频
  1240. count, e := models.GetVoiceCollectCount(user.UserId, item.Id)
  1241. if e != nil {
  1242. err = errors.New("GetVoiceCollectCount, Err: " + e.Error())
  1243. return
  1244. }
  1245. if count > 0 {
  1246. item.IsCollect = true
  1247. }
  1248. } else if item.Type == 2 {
  1249. //活动视频
  1250. count, e := models.GetActivityVideoCollectCount(user.UserId, item.Id)
  1251. if e != nil {
  1252. err = errors.New("GetActivityVideoCollectCount, Err: " + e.Error())
  1253. return
  1254. }
  1255. if count > 0 {
  1256. item.IsCollect = true
  1257. }
  1258. } else if item.Type == 3 {
  1259. //微路演视频
  1260. count, e := models.GetVideoCollectCount(user.UserId, item.Id)
  1261. if e != nil {
  1262. err = errors.New("GetVideoCollectCount, Err: " + e.Error())
  1263. return
  1264. }
  1265. if count > 0 {
  1266. item.IsCollect = true
  1267. }
  1268. }
  1269. }
  1270. // 用户权限
  1271. authInfo, permissionArr, e := GetUserRaiPermissionInfo(user.UserId, user.CompanyId)
  1272. if e != nil {
  1273. err = errors.New("GetUserRaiPermissionInfo, Err: " + e.Error())
  1274. return
  1275. }
  1276. // 获取默认图配置
  1277. audioMap, videoMap, audioShareMap, videoShareMap, e := GetMicroRoadShowDefaultImgConfig()
  1278. if e != nil {
  1279. err = errors.New("GetMicroRoadShowDefaultImgConfig, Err: " + e.Error())
  1280. return
  1281. }
  1282. //Source string `description:"资源类型 报告 :article 、图表 :newchart、微路演 :roadshow、活动 :activity、活动视频:activityvideo、活动音频:activityvoice、专项调研活动:activityspecial"`
  1283. for i := range list {
  1284. // 权限
  1285. au := new(models.UserPermissionAuthInfo)
  1286. au.SellerName = authInfo.SellerName
  1287. au.SellerMobile = authInfo.SellerMobile
  1288. au.HasPermission = authInfo.HasPermission
  1289. au.OperationMode = authInfo.OperationMode
  1290. if au.HasPermission == 1 {
  1291. // 非宏观权限进一步判断是否有权限
  1292. if list[i].ChartPermissionId != utils.HONG_GUAN_ID && !utils.InArrayByStr(permissionArr, list[i].ChartPermissionName) {
  1293. au.HasPermission = 2
  1294. }
  1295. }
  1296. // 无权限的弹框提示
  1297. if au.HasPermission != 1 {
  1298. if au.OperationMode == UserPermissionOperationModeCall {
  1299. if list[i].Type == 1 {
  1300. au.PopupMsg = UserPermissionPopupMsgCallActivity
  1301. } else {
  1302. au.PopupMsg = UserPermissionPopupMsgCallMicroVideo
  1303. }
  1304. } else {
  1305. if list[i].Type == 1 {
  1306. au.PopupMsg = UserPermissionPopupMsgApplyActivity
  1307. } else {
  1308. au.PopupMsg = UserPermissionPopupMsgApplyMicroVideo
  1309. }
  1310. }
  1311. }
  1312. list[i].AuthInfo = au
  1313. list[i].PublishTime = utils.StrTimeToTime(list[i].PublishTime).Format(utils.FormatDate)
  1314. // 默认图
  1315. if list[i].BackgroundImg == "" {
  1316. if list[i].Type == 1 {
  1317. list[i].BackgroundImg = audioMap[list[i].ChartPermissionId]
  1318. } else {
  1319. list[i].BackgroundImg = videoMap[list[i].ChartPermissionId]
  1320. }
  1321. }
  1322. // 分享图
  1323. if list[i].ShareImg == "" {
  1324. if list[i].Type == 1 {
  1325. list[i].ShareImg = audioShareMap[list[i].ChartPermissionId]
  1326. } else {
  1327. list[i].ShareImg = videoShareMap[list[i].ChartPermissionId]
  1328. }
  1329. }
  1330. }
  1331. //Type int `description:"类型: 1-音频; 2-活动视频; 3-产业视频"`
  1332. for _, item := range list {
  1333. if item.Type == 1 {
  1334. mapItems[fmt.Sprint("activityvoice", item.Id)].Activityvoice = item
  1335. } else if item.Type == 2 {
  1336. mapItems[fmt.Sprint("activityvideo", item.Id)].Activityvideo = item
  1337. } else if item.Type == 3 {
  1338. mapItems[fmt.Sprint("roadshow", item.Id)].Roadshow = item
  1339. }
  1340. }
  1341. }
  1342. for _, vList := range list {
  1343. for _, v := range mapItems {
  1344. //如果这些类型都为空,那么就不合并
  1345. if v.Article == nil && v.Newchart == nil && v.Roadshow == nil && v.Activity == nil && v.Activityvideo == nil && v.Activityvoice == nil && v.Activityspecial == nil && v.Researchsummary == nil && v.Minutessummary == nil && v.Meetingreviewchapt == nil && v.ProductInterior == nil && v.IndustrialResource == nil {
  1346. continue
  1347. }
  1348. if v.Article != nil && v.SourceId == vList.SourceId {
  1349. v.Article.Title = vList.Title
  1350. }
  1351. if v.Newchart != nil && v.SourceId == vList.SourceId {
  1352. v.Newchart.Title = vList.Title
  1353. }
  1354. if v.Roadshow != nil && v.SourceId == vList.SourceId {
  1355. v.Roadshow.Title = vList.Title
  1356. }
  1357. if v.Activity != nil && v.SourceId == vList.SourceId {
  1358. v.Activity.ActivityName = vList.Title
  1359. }
  1360. if v.Activityvideo != nil && v.SourceId == vList.SourceId {
  1361. v.Activityvideo.Title = vList.Title
  1362. }
  1363. if v.Activityvoice != nil && v.SourceId == vList.SourceId {
  1364. v.Activityvoice.Title = vList.Title
  1365. }
  1366. if v.Activityspecial != nil && v.SourceId == vList.SourceId {
  1367. v.Activityspecial.ResearchTheme = vList.Title
  1368. }
  1369. if v.Researchsummary != nil && v.SourceId == vList.SourceId {
  1370. v.Researchsummary.Title = vList.Title
  1371. }
  1372. if v.Minutessummary != nil && v.SourceId == vList.SourceId {
  1373. v.Minutessummary.Title = vList.Title
  1374. }
  1375. if v.ProductInterior != nil && v.SourceId == vList.SourceId {
  1376. v.ProductInterior.Title = vList.Title
  1377. }
  1378. //if v.IndustrialResource != nil && v.SourceId == vList.SourceId {
  1379. // v.IndustrialResource.UpdateTime = vList.PublishDate
  1380. //}
  1381. if v.SourceId == vList.SourceId && v.Source == vList.Source {
  1382. items = append(items, v)
  1383. }
  1384. }
  1385. }
  1386. for _, v := range items {
  1387. if v.IndustrialResource != nil {
  1388. v.Source = "industrialsource"
  1389. }
  1390. }
  1391. return
  1392. }