es_comprehensive.go 50 KB

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