research.go 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538
  1. package controllers
  2. import (
  3. "github.com/rdlucklib/rdluck_tools/paging"
  4. "hongze/hongze_cygx/models"
  5. "hongze/hongze_cygx/utils"
  6. "strconv"
  7. )
  8. //研选
  9. type ResearchController struct {
  10. BaseAuthController
  11. }
  12. // @Title 近期更新主题列表
  13. // @Description 近期更新主题列表接口
  14. // @Param ChartPermissionId query int true "分类ID"
  15. // @Success 200 {object} models.IndustrialManagementNewList
  16. // @router /theme/newList [get]
  17. func (this *ResearchController) NewList() {
  18. br := new(models.BaseResponse).Init()
  19. defer func() {
  20. this.Data["json"] = br
  21. this.ServeJSON()
  22. }()
  23. user := this.User
  24. if user == nil {
  25. br.Msg = "请重新登录"
  26. br.Ret = 408
  27. return
  28. }
  29. chartPermissionId, _ := this.GetInt("ChartPermissionId")
  30. if chartPermissionId < 1 {
  31. br.Msg = "请输入分类ID"
  32. return
  33. }
  34. categoryinfo, err := models.GetChartPermissionById(chartPermissionId)
  35. if err != nil {
  36. br.Msg = "获取信息失败"
  37. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  38. return
  39. }
  40. list, err := models.GetIndustrialManagementNewList(categoryinfo.PermissionName)
  41. if err != nil {
  42. br.Msg = "获取信息失败"
  43. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  44. return
  45. }
  46. mapHot := make(map[string]int)
  47. condition := ` ORDER BY sum_num DESC `
  48. listHot, err := models.GetThemeHeatList(categoryinfo.PermissionName, user.UserId, condition, 0, 3)
  49. if err != nil {
  50. br.Msg = "获取信息失败"
  51. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  52. return
  53. }
  54. for _, v := range listHot {
  55. mapHot[v.IndustryName] = v.IndustrialManagementId
  56. }
  57. for k, v := range list {
  58. if mapHot[v.IndustryName] > 0 {
  59. list[k].IsHot = true
  60. }
  61. }
  62. resp := new(models.IndustrialManagementNewList)
  63. resp.List = list
  64. br.Ret = 200
  65. br.Success = true
  66. br.Msg = "获取成功"
  67. br.Data = resp
  68. }
  69. // @Title 用户收藏列表
  70. // @Description 用户收藏列表接口
  71. // @Param ChartPermissionId query int true "分类ID"
  72. // @Success 200 {object} models.ArticleCollectionLIstResp
  73. // @router /collectionList [get]
  74. func (this *ResearchController) CollectionList() {
  75. br := new(models.BaseResponse).Init()
  76. defer func() {
  77. this.Data["json"] = br
  78. this.ServeJSON()
  79. }()
  80. user := this.User
  81. if user == nil {
  82. br.Msg = "请重新登录"
  83. br.Ret = 408
  84. return
  85. }
  86. chartPermissionId, _ := this.GetInt("ChartPermissionId")
  87. if chartPermissionId < 1 {
  88. br.Msg = "请输入分类ID"
  89. return
  90. }
  91. categoryinfo, err := models.GetChartPermissionById(chartPermissionId)
  92. if err != nil {
  93. br.Msg = "获取信息失败"
  94. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  95. return
  96. }
  97. var condition string
  98. condition = ` AND a.category_name LIKE '%` + categoryinfo.PermissionName + `%' AND publish_status = 1 GROUP BY a.article_id ORDER BY collect_num DESC, publish_date DESC LIMIT 15 `
  99. list, err := models.GetArticleCollectionList(condition, user.UserId)
  100. if err != nil {
  101. br.Msg = "获取信息失败"
  102. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  103. return
  104. }
  105. for k, v := range list {
  106. if v.MyCollectNum > 0 {
  107. list[k].IsCollect = true
  108. }
  109. }
  110. resp := new(models.ArticleCollectionLIstResp)
  111. resp.List = list
  112. br.Ret = 200
  113. br.Success = true
  114. br.Msg = "获取成功"
  115. br.Data = resp
  116. }
  117. // @Title 主题热度/近期更新更多,列表
  118. // @Description 主题热度/近期更新更多,列表接口
  119. // @Param ChartPermissionId query int true "分类ID"
  120. // @Param ThemeType query int true "主题类型,1主题热度、2近期更新 默认1"
  121. // @Param PageSize query int true "每页数据条数"
  122. // @Param CurrentIndex query int true "当前页页码,从1开始"
  123. // @Success 200 {object} models.IndustrialManagementHotListResp
  124. // @router /hotList [get]
  125. func (this *ResearchController) HotList() {
  126. br := new(models.BaseResponse).Init()
  127. defer func() {
  128. this.Data["json"] = br
  129. this.ServeJSON()
  130. }()
  131. user := this.User
  132. if user == nil {
  133. br.Msg = "请重新登录"
  134. br.Ret = 408
  135. return
  136. }
  137. chartPermissionId, _ := this.GetInt("ChartPermissionId")
  138. themeType, _ := this.GetInt("ThemeType")
  139. if chartPermissionId < 1 {
  140. br.Msg = "请输入分类ID"
  141. return
  142. }
  143. pageSize, _ := this.GetInt("PageSize")
  144. currentIndex, _ := this.GetInt("CurrentIndex")
  145. var startSize int
  146. if pageSize <= 0 {
  147. pageSize = utils.PageSize15
  148. }
  149. if currentIndex <= 0 {
  150. currentIndex = 1
  151. }
  152. startSize = utils.StartIndex(currentIndex, pageSize)
  153. var condition string
  154. if themeType != 2 {
  155. themeType = 1
  156. condition = `ORDER BY sum_num DESC `
  157. } else {
  158. condition = `ORDER BY publish_date DESC `
  159. }
  160. categoryinfo, err := models.GetChartPermissionById(chartPermissionId)
  161. if err != nil {
  162. br.Msg = "获取信息失败"
  163. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  164. return
  165. }
  166. total, err := models.GetThemeHeatListCount(categoryinfo.PermissionName, "")
  167. if err != nil {
  168. br.Msg = "获取失败"
  169. br.ErrMsg = "获取失败,Err:" + err.Error()
  170. return
  171. }
  172. list, err := models.GetThemeHeatList(categoryinfo.PermissionName, user.UserId, condition, startSize, pageSize)
  173. if err != nil {
  174. br.Msg = "获取信息失败"
  175. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  176. return
  177. }
  178. newMap := make(map[int]string)
  179. listNew, err := models.GetIndustrialManagementNewList(categoryinfo.PermissionName)
  180. if err != nil {
  181. br.Msg = "获取信息失败"
  182. br.ErrMsg = "获取产业最新信息失败,Err:" + err.Error()
  183. return
  184. }
  185. for _, v := range listNew {
  186. newMap[v.IndustrialManagementId] = v.IndustryName
  187. }
  188. condition = ` AND a.category_name LIKE '%` + categoryinfo.PermissionName + `%' `
  189. listSubjcet, err := models.GetThemeHeatSubjectList(condition)
  190. if err != nil {
  191. br.Msg = "获取信息失败"
  192. br.ErrMsg = "获取标的信息失败,Err:" + err.Error()
  193. return
  194. }
  195. mapHot := make(map[string]int)
  196. condition = ` ORDER BY sum_num DESC `
  197. listHot, err := models.GetThemeHeatList(categoryinfo.PermissionName, user.UserId, condition, 0, 3)
  198. if err != nil {
  199. br.Msg = "获取信息失败"
  200. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  201. return
  202. }
  203. for _, v := range listHot {
  204. mapHot[v.IndustryName] = v.IndustrialManagementId
  205. }
  206. for k, v := range list {
  207. if newMap[v.IndustrialManagementId] != "" {
  208. list[k].IsNew = true
  209. }
  210. if v.FllowNum > 0 {
  211. list[k].IsFollw = true
  212. }
  213. for _, v2 := range listSubjcet {
  214. if v2.IndustrialManagementId == v.IndustrialManagementId {
  215. list[k].IndustrialSubjectList = append(list[k].IndustrialSubjectList, v2)
  216. }
  217. }
  218. if mapHot[v.IndustryName] > 0 {
  219. list[k].IsHot = true
  220. }
  221. }
  222. page := paging.GetPaging(currentIndex, pageSize, total)
  223. resp := new(models.IndustrialManagementHotListResp)
  224. resp.Paging = page
  225. resp.List = list
  226. br.Ret = 200
  227. br.Success = true
  228. br.Msg = "获取成功"
  229. br.Data = resp
  230. }
  231. // @Title KOL榜列表
  232. // @Description KOL榜列表接口
  233. // @Param ChartPermissionId query int true "分类ID"
  234. // @Success 200 {object} models.DepartmentListResp
  235. // @router /kolList [get]
  236. func (this *ResearchController) KolList() {
  237. br := new(models.BaseResponse).Init()
  238. defer func() {
  239. this.Data["json"] = br
  240. this.ServeJSON()
  241. }()
  242. user := this.User
  243. if user == nil {
  244. br.Msg = "请重新登录"
  245. br.Ret = 408
  246. return
  247. }
  248. chartPermissionId, _ := this.GetInt("ChartPermissionId")
  249. if chartPermissionId < 1 {
  250. br.Msg = "请输入分类ID"
  251. return
  252. }
  253. categoryinfo, err := models.GetChartPermissionById(chartPermissionId)
  254. if err != nil {
  255. br.Msg = "获取信息失败"
  256. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  257. return
  258. }
  259. list, err := models.GetDepartmentList(categoryinfo.PermissionName, user.UserId)
  260. if err != nil {
  261. br.Msg = "获取信息失败"
  262. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  263. return
  264. }
  265. listIndustrial, err := models.GetIndustrialDepartmentList(categoryinfo.PermissionName)
  266. if err != nil {
  267. br.Msg = "获取信息失败"
  268. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  269. return
  270. }
  271. departmentMap := make(map[string]string)
  272. for k, v := range list {
  273. if v.FllowNum > 0 {
  274. list[k].IsFollw = true
  275. }
  276. for _, v2 := range listIndustrial {
  277. if v2.DepartmentId == v.DepartmentId {
  278. if departmentMap["D"+strconv.Itoa(v2.DepartmentId)+"In"+strconv.Itoa(v2.IndustrialManagementId)] == "" && len(list[k].List) < 4 {
  279. list[k].List = append(list[k].List, v2)
  280. departmentMap["D"+strconv.Itoa(v2.DepartmentId)+"In"+strconv.Itoa(v2.IndustrialManagementId)] = v.NickName
  281. }
  282. }
  283. }
  284. }
  285. resp := new(models.DepartmentListResp)
  286. resp.List = list
  287. br.Ret = 200
  288. br.Success = true
  289. br.Msg = "获取成功"
  290. br.Data = resp
  291. }
  292. // @Title 主题详情
  293. // @Description 主题详情接口
  294. // @Param IndustrialManagementId query int true "分类ID"
  295. // @Success 200 {object} models.GetThemeDetailResp
  296. // @router /theme/detail [get]
  297. func (this *ResearchController) ThemeDetail() {
  298. br := new(models.BaseResponse).Init()
  299. defer func() {
  300. this.Data["json"] = br
  301. this.ServeJSON()
  302. }()
  303. user := this.User
  304. if user == nil {
  305. br.Msg = "请重新登录"
  306. br.Ret = 408
  307. return
  308. }
  309. industrialManagementId, _ := this.GetInt("IndustrialManagementId")
  310. if industrialManagementId < 1 {
  311. br.Msg = "请输入产业ID"
  312. return
  313. }
  314. resp := new(models.GetThemeDetailResp)
  315. list, err := models.GetThemeDetail(user.UserId, industrialManagementId)
  316. if err != nil {
  317. br.Msg = "获取信息失败"
  318. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  319. return
  320. }
  321. var itemsNull []*models.GetThemeAericleListResp
  322. subjectMap := make(map[string]string)
  323. articleMap := make(map[int]int)
  324. for _, v := range list {
  325. resp.IndustryName = v.IndustryName
  326. resp.IndustrialManagementId = v.IndustrialManagementId
  327. itemSubJect := new(models.IndustrialSubject)
  328. itemSubJect.SubjectName = v.SubjectName
  329. itemSubJect.IndustrialSubjectId = v.IndustrialSubjectId
  330. if subjectMap[v.SubjectName] == "" && v.SubjectName != "" {
  331. resp.ListSubject = append(resp.ListSubject, itemSubJect)
  332. }
  333. subjectMap[v.SubjectName] = v.IndustryName
  334. if v.FllowNum > 0 {
  335. resp.IsFollw = true
  336. }
  337. if v.SubjectName == "" {
  338. item := new(models.GetThemeAericleListResp)
  339. item.ArticleId = v.ArticleId
  340. item.Title = v.Title
  341. item.PublishDate = v.PublishDate
  342. item.SubjectName = v.SubjectName
  343. item.DepartmentId = v.DepartmentId
  344. item.NickName = v.NickName
  345. item.Pv = v.Pv
  346. item.CollectNum = v.CollectNum
  347. itemsNull = append(itemsNull, item)
  348. }
  349. }
  350. for _, v := range resp.ListSubject {
  351. subjetcGroup := new(models.GetThemeAericleListBuSubjectResp)
  352. for _, v2 := range list {
  353. if v2.IndustrialSubjectId == v.IndustrialSubjectId && articleMap[v2.ArticleId] == 0 {
  354. item := new(models.GetThemeAericleListResp)
  355. item.ArticleId = v2.ArticleId
  356. item.Title = v2.Title
  357. item.PublishDate = v2.PublishDate
  358. item.SubjectName = v2.SubjectName
  359. item.IndustrialSubjectId = v2.IndustrialSubjectId
  360. for _, v3 := range list {
  361. if v3.ArticleId == v2.ArticleId && v3.SubjectName != v2.SubjectName && v3.SubjectName != "" {
  362. item.SubjectName += "/" + v3.SubjectName
  363. }
  364. }
  365. item.DepartmentId = v2.DepartmentId
  366. item.NickName = v2.NickName
  367. item.Pv = v2.Pv
  368. item.CollectNum = v2.CollectNum
  369. item.MyCollectNum = v2.MyCollectNum
  370. if v2.MyCollectNum > 0 {
  371. item.IsCollect = true
  372. }
  373. resp.List = append(resp.List, item)
  374. articleMap[v2.ArticleId] = v2.ArticleId
  375. //subjetcGroup.List = append(subjetcGroup.List, item)
  376. }
  377. subjetcGroup.SubjectName = v.SubjectName
  378. }
  379. }
  380. //当标的为空时进行合并
  381. if len(itemsNull) > 0 {
  382. for _, v := range itemsNull {
  383. resp.List = append(resp.List, v)
  384. }
  385. }
  386. br.Ret = 200
  387. br.Success = true
  388. br.Msg = "获取成功"
  389. br.Data = resp
  390. }
  391. // @Title 研选作者详情
  392. // @Description 研选作者详情接口
  393. // @Param DepartmentId query int true "作者ID"
  394. // @Success 200 {object} models.DepartmentDetailResp
  395. // @router /departmentId/detail [get]
  396. func (this *ResearchController) DepartmentIdDetail() {
  397. br := new(models.BaseResponse).Init()
  398. defer func() {
  399. this.Data["json"] = br
  400. this.ServeJSON()
  401. }()
  402. user := this.User
  403. if user == nil {
  404. br.Msg = "请重新登录"
  405. br.Ret = 408
  406. return
  407. }
  408. departmentId, _ := this.GetInt("DepartmentId")
  409. if departmentId < 1 {
  410. br.Msg = "请输入作者ID"
  411. return
  412. }
  413. resp := new(models.DepartmentDetailResp)
  414. detail, err := models.GetDepartmentDetail(user.UserId, departmentId)
  415. if err != nil {
  416. br.Msg = "获取信息失败"
  417. br.ErrMsg = "获取作者信息失败,Err:" + err.Error()
  418. return
  419. }
  420. resp.DepartmentId = detail.DepartmentId
  421. resp.NickName = detail.NickName
  422. resp.ImgUrl = detail.ImgUrl
  423. resp.FllowNum = detail.FllowNum
  424. resp.ArticleNum = detail.ArticleNum
  425. resp.CollectNum = detail.CollectNum
  426. if detail.MyFllowNum > 0 {
  427. resp.IsFllow = true
  428. }
  429. var condition string
  430. condition = ` AND a.department_id = ` + strconv.Itoa(departmentId) + ` ORDER BY a.publish_date DESC `
  431. list, err := models.GetArticleCollectionList(condition, user.UserId)
  432. if err != nil {
  433. br.Msg = "获取信息失败"
  434. br.ErrMsg = "获取文章列表失败,Err:" + err.Error()
  435. return
  436. }
  437. for k, v := range list {
  438. if v.MyCollectNum > 0 {
  439. list[k].IsCollect = true
  440. }
  441. }
  442. resp.List = list
  443. br.Ret = 200
  444. br.Success = true
  445. br.Msg = "获取成功"
  446. br.Data = resp
  447. }
  448. // @Title 文章相关热门收藏
  449. // @Description 文章相关热门收藏接口
  450. // @Param ArticleId query int true "文章ID"
  451. // @Success 200 {object} models.ArticleCollectionLIstResp
  452. // @router /article/hotList [get]
  453. func (this *ResearchController) ArticleHotList() {
  454. br := new(models.BaseResponse).Init()
  455. defer func() {
  456. this.Data["json"] = br
  457. this.ServeJSON()
  458. }()
  459. user := this.User
  460. if user == nil {
  461. br.Msg = "请重新登录"
  462. br.Ret = 408
  463. return
  464. }
  465. articleId, _ := this.GetInt("ArticleId")
  466. if articleId < 1 {
  467. br.Msg = "请输入分类ID"
  468. return
  469. }
  470. var condition string
  471. condition = ` AND a.article_id IN (SELECT article_id FROM cygx_industrial_article_group_management WHERE industrial_management_id IN (SELECT industrial_management_id FROM cygx_industrial_article_group_management WHERE article_id = ` + strconv.Itoa(articleId) + ` ) ) AND a.article_id != ` + strconv.Itoa(articleId) + ` AND a.category_name LIKE '%研选%' AND publish_status = 1 GROUP BY a.article_id ORDER BY collect_num DESC, publish_date DESC LIMIT 3 `
  472. list, err := models.GetArticleCollectionList(condition, user.UserId)
  473. if err != nil {
  474. br.Msg = "获取信息失败"
  475. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  476. return
  477. }
  478. for k, v := range list {
  479. if v.MyCollectNum > 0 {
  480. list[k].IsCollect = true
  481. }
  482. }
  483. resp := new(models.ArticleCollectionLIstResp)
  484. resp.List = list
  485. br.Ret = 200
  486. br.Success = true
  487. br.Msg = "获取成功"
  488. br.Data = resp
  489. }
  490. // @Title 热搜关键词
  491. // @Description 热搜关键词接口
  492. // @Success 200 {object} models.UserSearchKeyWordListResp
  493. // @router /hotKeyWord [get]
  494. func (this *ResearchController) HotKeyWord() {
  495. br := new(models.BaseResponse).Init()
  496. defer func() {
  497. this.Data["json"] = br
  498. this.ServeJSON()
  499. }()
  500. user := this.User
  501. if user == nil {
  502. br.Msg = "请重新登录"
  503. br.Ret = 408
  504. return
  505. }
  506. //本来应该放在config控制器下,与未上线的代码冲突,所以放在这里
  507. list, err := models.GetUserSearchKeyWord()
  508. if err != nil {
  509. br.Msg = "获取信息失败"
  510. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  511. return
  512. }
  513. resp := new(models.UserSearchKeyWordListResp)
  514. resp.List = list
  515. br.Ret = 200
  516. br.Success = true
  517. br.Msg = "获取成功"
  518. br.Data = resp
  519. }