es_comprehensive.go 48 KB

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