es_comprehensive.go 48 KB

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