report.go 51 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694
  1. package controllers
  2. import (
  3. "encoding/json"
  4. "fmt"
  5. "github.com/rdlucklib/rdluck_tools/paging"
  6. "hongze/hongze_cygx/models"
  7. "hongze/hongze_cygx/services"
  8. "hongze/hongze_cygx/utils"
  9. "html"
  10. "strconv"
  11. "strings"
  12. "time"
  13. )
  14. //报告
  15. type ReportController struct {
  16. BaseAuthController
  17. }
  18. type ReportCommonController struct {
  19. BaseCommonController
  20. }
  21. // @Title 行业报告分类列表接口
  22. // @Description 获取行业报告分类列表接口
  23. // @Param ChartPermissionId query int true "分类ID"
  24. // @Success 200 {object} models.IndustrialManagementList
  25. // @router /home/tradeList [get]
  26. func (this *ReportController) TradeList() {
  27. br := new(models.BaseResponse).Init()
  28. defer func() {
  29. this.Data["json"] = br
  30. this.ServeJSON()
  31. }()
  32. user := this.User
  33. if user == nil {
  34. br.Msg = "请重新登录"
  35. br.Ret = 408
  36. return
  37. }
  38. uid := user.UserId
  39. ChartPermissionId, _ := this.GetInt("ChartPermissionId")
  40. if ChartPermissionId < 1 {
  41. br.Msg = "请输入分类ID"
  42. return
  43. }
  44. list, err := models.GetTradeAll(ChartPermissionId)
  45. if err != nil {
  46. br.Msg = "获取信息失败"
  47. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  48. return
  49. }
  50. for k, v := range list {
  51. list[k].UpdateTime = utils.TimeRemoveHms(v.UpdateTime)
  52. count, err := models.CheckThisCategoryNewArticleIsRead(uid, v.CategoryId)
  53. if err != nil {
  54. br.Msg = "获取信息失败"
  55. br.ErrMsg = "获取帖子总数失败,Err:" + err.Error()
  56. return
  57. }
  58. if count == 0 && user.CreatedTime.Before(utils.StrTimeToTime(v.UpdateTime)) && utils.StrTimeToTime(utils.OnlineTime).Before(utils.StrTimeToTime(v.UpdateTime)) {
  59. list[k].IsRed = true
  60. }
  61. }
  62. resp := new(models.TradeReportMappingResp)
  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. // @Param IsNewLabel query string true "是否属于新标签,1是,0否"
  73. // @Param IsDeepLabel query string true "是否属于深标签,1是,0否"
  74. // @Param KeyWord query string true "搜索关键词"
  75. // @Param OrderColumn query int true "排序字段 ,NewTime 最近更新 ,Recommend弘则推荐"
  76. // @Param PageSize query int true "每页数据条数"
  77. // @Param CurrentIndex query int true "当前页页码,从1开始"
  78. // @Success 200 {object} models.IndustrialManagementList
  79. // @router /home/industryList [get]
  80. func (this *ReportController) IndustryList() {
  81. br := new(models.BaseResponse).Init()
  82. defer func() {
  83. this.Data["json"] = br
  84. this.ServeJSON()
  85. }()
  86. user := this.User
  87. if user == nil {
  88. br.Msg = "请重新登录"
  89. br.Ret = 408
  90. return
  91. }
  92. uid := user.UserId
  93. fmt.Println(uid)
  94. ChartPermissionId, _ := this.GetInt("ChartPermissionId")
  95. orderColumn := this.GetString("OrderColumn")
  96. isNewLabel := this.GetString("IsNewLabel")
  97. isDeepLabel := this.GetString("IsDeepLabel")
  98. keyWord := this.GetString("KeyWord")
  99. pageSize, _ := this.GetInt("PageSize")
  100. currentIndex, _ := this.GetInt("CurrentIndex")
  101. var orderSrt string
  102. var condition string
  103. var startSize int
  104. resp := new(models.IndustrialManagementList)
  105. if pageSize <= 0 {
  106. pageSize = utils.PageSize20
  107. }
  108. if currentIndex <= 0 {
  109. currentIndex = 1
  110. }
  111. startSize = paging.StartIndex(currentIndex, pageSize)
  112. if isNewLabel == "1" {
  113. condition += ` AND is_new_label = ` + isNewLabel
  114. }
  115. if isDeepLabel == "1" {
  116. condition += ` AND is_deep_label = ` + isDeepLabel
  117. }
  118. if keyWord != "" {
  119. //keyWordArr, err := services.GetIndustryMapNameSliceV2(keyWord)
  120. //if err != nil {
  121. // br.Msg = "获取信息失败"
  122. // br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  123. // return
  124. //}
  125. //var conditionkeyWord string
  126. //conditionkeyWord += ` subject_names LIKE '%` + keyWord + `%'`
  127. //keyWordArr = services.RemoveDuplicatesAndEmpty(keyWordArr)
  128. //keyWordLen := len(keyWordArr)
  129. //if keyWordLen <= 0 {
  130. // keyWordArr = append(keyWordArr, keyWord)
  131. // keyWordLen = len(keyWordArr)
  132. //}
  133. //for _, v := range keyWordArr {
  134. // conditionkeyWord += ` OR subject_names LIKE '%` + v + `%'`
  135. //}
  136. //industrialManagementIds, err := models.GetIndustrialManagementIdsBykeyWord(conditionkeyWord)
  137. //if err != nil {
  138. // br.Msg = "获取信息失败"
  139. // br.ErrMsg = "获取客户信息失败,Err:" + err.Error()
  140. // return
  141. //}
  142. //if industrialManagementIds == "" {
  143. // br.Ret = 200
  144. // br.Success = true
  145. // br.Msg = "获取成功"
  146. // br.Data = resp
  147. // return
  148. //}
  149. //condition += ` AND man.industrial_management_id IN (` + industrialManagementIds + `)`
  150. condition += ` AND subject_names LIKE '%` + keyWord + `%'`
  151. }
  152. var sqlChartPermissionId string
  153. if ChartPermissionId > 0 {
  154. sqlChartPermissionId += ` AND man_g.industrial_management_id IN ( SELECT industrial_management_id FROM cygx_industrial_management WHERE chart_permission_id = ` + strconv.Itoa(ChartPermissionId) + ` ) `
  155. condition += ` AND man.chart_permission_id IN (` + strconv.Itoa(ChartPermissionId) + `)`
  156. }
  157. var list []*models.IndustrialManagement
  158. total, err := models.GetIndustrialManagementAllCount(condition)
  159. if err != nil {
  160. br.Msg = "获取信息失败"
  161. br.ErrMsg = "获取数量失败,Err:" + err.Error()
  162. return
  163. }
  164. page := paging.GetPaging(currentIndex, pageSize, total)
  165. if orderColumn == "" {
  166. orderColumn = "NewTime"
  167. }
  168. if orderColumn == "NewTime" {
  169. orderSrt = "update_time DESC"
  170. } else {
  171. orderSrt = "man.recommended_index DESC,update_time DESC"
  172. }
  173. if ChartPermissionId == 0 {
  174. ChartPermissionId = 20
  175. }
  176. detailHot3, err := models.GetIndustrialManagementHot3(ChartPermissionId)
  177. if err != nil {
  178. br.Msg = "获取信息失败"
  179. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  180. return
  181. }
  182. list, err = models.GetIndustrialManagementAll(uid, condition, orderSrt, startSize, pageSize)
  183. if err != nil {
  184. br.Msg = "获取信息失败"
  185. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  186. return
  187. }
  188. for k, v := range list {
  189. industrialSubjectList, err := models.GetIndustrialSubjectAll(v.IndustrialManagementId)
  190. if err != nil {
  191. br.Msg = "获取信息失败"
  192. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  193. return
  194. }
  195. list[k].IndustrialSubjectList = industrialSubjectList
  196. list[k].LayoutTime = utils.TimeRemoveHms(v.LayoutTime)
  197. newArtinfo, err := models.GetIndustrialNewArticleDetail(v.IndustrialManagementId)
  198. if err != nil {
  199. br.Msg = "获取信息失败"
  200. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  201. return
  202. }
  203. list[k].UpdateTime = utils.TimeRemoveHms(newArtinfo.PublishDate)
  204. recordCount, err := models.GetUserToArticleCount(uid, newArtinfo.ArticleId)
  205. if err != nil && err.Error() != utils.ErrNoRow() {
  206. br.Msg = "获取信息失败"
  207. br.ErrMsg = "获取信息失败,Err:" + strconv.Itoa(uid) + ";articleId" + strconv.Itoa(newArtinfo.ArticleId)
  208. return
  209. }
  210. if recordCount == 0 && user.CreatedTime.Before(utils.StrTimeToTime(newArtinfo.PublishDate)) && utils.StrTimeToTime(utils.OnlineTime).Before(utils.StrTimeToTime(newArtinfo.PublishDate)) {
  211. list[k].IsRed = true
  212. }
  213. if v.ArticleReadNum >= detailHot3.ArticleReadNum {
  214. list[k].IsHot = true
  215. }
  216. }
  217. resp.List = list
  218. resp.Paging = page
  219. br.Ret = 200
  220. br.Success = true
  221. br.Msg = "获取成功"
  222. br.Data = resp
  223. }
  224. // @Title 产业下所关联的文章分类列表
  225. // @Description 产业下所关联的文章分类列表接口
  226. // @Param IndustrialManagementId query int true "产业ID"
  227. // @Success 200 {object} models.IndustrialToArticleCategoryListRep
  228. // @router /toArticleCategoryList [get]
  229. func (this *ReportController) ArticleCategoryList() {
  230. br := new(models.BaseResponse).Init()
  231. defer func() {
  232. this.Data["json"] = br
  233. this.ServeJSON()
  234. }()
  235. user := this.User
  236. if user == nil {
  237. br.Msg = "请重新登录"
  238. br.Ret = 408
  239. return
  240. }
  241. uid := user.UserId
  242. industrialManagementId, _ := this.GetInt("IndustrialManagementId")
  243. if industrialManagementId < 1 {
  244. br.Msg = "请输入分类ID"
  245. return
  246. }
  247. list, err := models.IndustrialToArticleCategory(industrialManagementId)
  248. if err != nil {
  249. br.Msg = "获取信息失败"
  250. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  251. return
  252. }
  253. for k, v := range list {
  254. recordCount, err := models.IndustrialUserRecordArticleCount(uid, industrialManagementId, v.CategoryId)
  255. if err != nil && err.Error() != utils.ErrNoRow() {
  256. br.Msg = "获取信息失败"
  257. br.ErrMsg = "判断是否已申请过试用失败,Err:" + err.Error()
  258. return
  259. }
  260. Newdetail, err := models.GetNewIndustrialUserRecordArticle(industrialManagementId, v.CategoryId)
  261. if err != nil {
  262. br.Msg = "获取信息失败"
  263. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  264. return
  265. }
  266. if recordCount == 0 && user.CreatedTime.Before(utils.StrTimeToTime(Newdetail.PublishDate)) && utils.StrTimeToTime(utils.OnlineTime).Before(utils.StrTimeToTime(Newdetail.PublishDate)) {
  267. list[k].IsRed = true
  268. }
  269. }
  270. detail, err := models.GetIndustrialManagementDetail(industrialManagementId)
  271. if err != nil {
  272. br.Msg = "获取信息失败"
  273. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  274. return
  275. }
  276. resp := new(models.IndustrialToArticleCategoryListRep)
  277. resp.List = list
  278. resp.LayoutTime = utils.TimeRemoveHms(detail.LayoutTime)
  279. resp.IndustryName = detail.IndustryName
  280. resp.IndustrialManagementId = industrialManagementId
  281. br.Ret = 200
  282. br.Success = true
  283. br.Msg = "获取成功"
  284. br.Data = resp
  285. }
  286. // @Title 产业文章列表接口
  287. // @Description 获取产业文章列表接口
  288. // @Param PageSize query int true "每页数据条数"
  289. // @Param CurrentIndex query int true "当前页页码,从1开始"
  290. // @Param CategoryId query int true "分类ID"
  291. // @Param IndustrialManagementId query int true "产业ID"
  292. // @Success 200 {object} models.TacticsListResp
  293. // @router /industry/ArticleList [get]
  294. func (this *ReportController) List() {
  295. br := new(models.BaseResponse).Init()
  296. defer func() {
  297. this.Data["json"] = br
  298. this.ServeJSON()
  299. }()
  300. user := this.User
  301. if user == nil {
  302. br.Msg = "请重新登录"
  303. br.Ret = 408
  304. return
  305. }
  306. uid := user.UserId
  307. pageSize, _ := this.GetInt("PageSize")
  308. currentIndex, _ := this.GetInt("CurrentIndex")
  309. categoryId, _ := this.GetInt("CategoryId")
  310. industrialManagementId, _ := this.GetInt("IndustrialManagementId")
  311. var startSize int
  312. if pageSize <= 0 {
  313. pageSize = utils.PageSize20
  314. }
  315. if currentIndex <= 0 {
  316. currentIndex = 1
  317. }
  318. startSize = paging.StartIndex(currentIndex, pageSize)
  319. var pars []interface{}
  320. var total int
  321. resp := new(models.TacticsListResp)
  322. page := paging.GetPaging(currentIndex, pageSize, total)
  323. if categoryId < 1 {
  324. br.Msg = "请输入分类ID"
  325. return
  326. }
  327. if industrialManagementId < 1 {
  328. br.Msg = "请输入产业ID"
  329. return
  330. }
  331. total, err := models.GetReportIndustrialCount(categoryId, industrialManagementId)
  332. if err != nil {
  333. br.Msg = "获取信息失败"
  334. br.ErrMsg = "获取帖子总数失败,Err:" + err.Error()
  335. return
  336. }
  337. page = paging.GetPaging(currentIndex, pageSize, total)
  338. list, err := models.GetReportIndustrialList(pars, categoryId, industrialManagementId, uid, startSize, pageSize)
  339. if err != nil {
  340. br.Msg = "获取信息失败"
  341. br.ErrMsg = "获取帖子数据失败,Err:" + err.Error()
  342. return
  343. }
  344. lenList := len(list)
  345. for i := 0; i < lenList; i++ {
  346. item := list[i]
  347. list[i].Body, _ = services.GetReportContentTextSub(item.Body)
  348. //list[i].Abstract = html.UnescapeString(item.Abstract)
  349. list[i].Abstract, _ = services.GetReportContentTextSub(item.Abstract)
  350. }
  351. for k, v := range list {
  352. if v.Readnum == 0 && user.CreatedTime.Before(utils.StrTimeToTime(v.PublishDate)) && utils.StrTimeToTime(utils.OnlineTime).Before(utils.StrTimeToTime(v.PublishDate)) {
  353. list[k].IsRed = true
  354. }
  355. if v.VideoUrl != "" {
  356. list[k].IsHaveVideo = true
  357. }
  358. }
  359. resp.List = list
  360. resp.Paging = page
  361. br.Ret = 200
  362. br.Success = true
  363. br.Msg = "获取成功"
  364. br.Data = resp
  365. }
  366. // @Title 置顶/取消置顶
  367. // @Description 置顶
  368. // @Param request body models.CygxIndustryTopRep true "type json string"
  369. // @Success 200
  370. // @router /top [post]
  371. func (this *ReportController) ArticleCollect() {
  372. br := new(models.BaseResponse).Init()
  373. defer func() {
  374. this.Data["json"] = br
  375. this.ServeJSON()
  376. }()
  377. user := this.User
  378. if user == nil {
  379. br.Msg = "请重新登录"
  380. br.Ret = 408
  381. return
  382. }
  383. uid := user.UserId
  384. var req models.CygxIndustryTopRep
  385. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  386. if err != nil {
  387. br.Msg = "参数解析异常!"
  388. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  389. return
  390. }
  391. industrialManagementId := req.IndustrialManagementId
  392. countIndustrial, err := models.GetIndustrialManagementCount(industrialManagementId)
  393. if err != nil {
  394. br.Msg = "获取数据失败!"
  395. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  396. return
  397. }
  398. if countIndustrial == 0 {
  399. br.Msg = "产业不存在!"
  400. br.ErrMsg = "产业ID不存在:" + strconv.Itoa(industrialManagementId)
  401. return
  402. }
  403. count, err := models.GetCygxIndustryTop(uid, industrialManagementId)
  404. if err != nil {
  405. br.Msg = "获取数据失败!"
  406. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  407. return
  408. }
  409. resp := new(models.ArticleCollectResp)
  410. if count <= 0 {
  411. item := new(models.CygxIndustryTop)
  412. item.IndustrialManagementId = req.IndustrialManagementId
  413. item.UserId = uid
  414. item.CreateTime = time.Now()
  415. _, err = models.AddCygxIndustryTop(item)
  416. if err != nil {
  417. br.Msg = "置顶失败"
  418. br.ErrMsg = "置顶失败,Err:" + err.Error()
  419. return
  420. }
  421. br.Msg = "置顶成功"
  422. resp.Status = 1
  423. } else {
  424. err = models.RemoveCygxIndustryTop(uid, industrialManagementId)
  425. if err != nil {
  426. br.Msg = "取消置顶失败"
  427. br.ErrMsg = "取消置顶失败,Err:" + err.Error()
  428. return
  429. }
  430. br.Msg = "已取消置顶"
  431. resp.Status = 2
  432. }
  433. br.Ret = 200
  434. br.Success = true
  435. br.Data = resp
  436. }
  437. // @Title 关注/取消关注产业
  438. // @Description 关注/取消关注 接口
  439. // @Param request body models.CygxIndustryFllowRep true "type json string"
  440. // @Success 200
  441. // @router /fllow [post]
  442. func (this *ReportController) Fllow() {
  443. br := new(models.BaseResponse).Init()
  444. defer func() {
  445. this.Data["json"] = br
  446. this.ServeJSON()
  447. }()
  448. user := this.User
  449. if user == nil {
  450. br.Msg = "请重新登录"
  451. br.Ret = 408
  452. return
  453. }
  454. uid := user.UserId
  455. var req models.CygxIndustryFllowRep
  456. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  457. if err != nil {
  458. br.Msg = "参数解析异常!"
  459. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  460. return
  461. }
  462. industrialManagementId := req.IndustrialManagementId
  463. var condition string
  464. countIndustrial, err := models.GetIndustrialManagementCount(industrialManagementId)
  465. if err != nil {
  466. br.Msg = "获取数据失败!"
  467. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  468. return
  469. }
  470. if countIndustrial == 0 {
  471. br.Msg = "产业不存在!"
  472. br.ErrMsg = "产业ID不存在:" + strconv.Itoa(industrialManagementId)
  473. return
  474. }
  475. count, err := models.GetCountCygxIndustryFllow(uid, industrialManagementId, condition)
  476. if err != nil {
  477. br.Msg = "获取数据失败!"
  478. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  479. return
  480. }
  481. resp := new(models.CygxIndustryFllowResp)
  482. countUser, err := models.GetCountCygxIndustryFllowByUid(uid)
  483. if countUser == 0 {
  484. resp.GoFollow = true
  485. }
  486. if count == 0 {
  487. item := new(models.CygxIndustryFllow)
  488. item.IndustrialManagementId = industrialManagementId
  489. item.UserId = uid
  490. item.Email = user.Email
  491. item.Mobile = user.Mobile
  492. item.CompanyId = user.CompanyId
  493. item.CompanyName = user.CompanyName
  494. item.Type = 1
  495. item.CreateTime = time.Now()
  496. item.ModifyTime = time.Now()
  497. _, err = models.AddCygxIndustryFllow(item)
  498. if err != nil {
  499. br.Msg = "操作失败"
  500. br.ErrMsg = "操作失败,Err:" + err.Error()
  501. return
  502. }
  503. resp.Status = 1
  504. } else {
  505. var doType int
  506. condition = ` AND type = 1`
  507. count, err = models.GetCountCygxIndustryFllow(uid, industrialManagementId, condition)
  508. if err != nil {
  509. br.Msg = "操作失败!"
  510. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  511. return
  512. }
  513. if count == 1 {
  514. resp.Status = 2
  515. doType = 2
  516. } else {
  517. resp.Status = 1
  518. doType = 1
  519. }
  520. err = models.RemoveCygxIndustryFllow(uid, industrialManagementId, doType)
  521. if err != nil {
  522. br.Msg = "操作失败"
  523. br.ErrMsg = "取消关注失败,Err:" + err.Error()
  524. return
  525. }
  526. }
  527. br.Msg = "操作成功"
  528. br.Ret = 200
  529. br.Success = true
  530. br.Data = resp
  531. }
  532. // @Title 产业报告分类关联作者列表接口
  533. // @Description 获取产业报告分类关联作者列表接口
  534. // @Param ChartPermissionId query int true "分类ID"
  535. // @Param PageSize query int true "每页数据条数"
  536. // @Param CurrentIndex query int true "当前页页码,从1开始"
  537. // @Success 200 {object} models.CygxArticleDepartmentList
  538. // @router /industryListByDepartment [get]
  539. func (this *ReportController) IndustryListByDepartment() {
  540. br := new(models.BaseResponse).Init()
  541. defer func() {
  542. this.Data["json"] = br
  543. this.ServeJSON()
  544. }()
  545. user := this.User
  546. if user == nil {
  547. br.Msg = "请重新登录"
  548. br.Ret = 408
  549. return
  550. }
  551. uid := user.UserId
  552. pageSize, _ := this.GetInt("PageSize")
  553. currentIndex, _ := this.GetInt("CurrentIndex")
  554. //chartPermissionId, _ := this.GetInt("ChartPermissionId")
  555. var startSize int
  556. var condition string
  557. //condition = ` AND a.publish_status=1 AND m.chart_permission_id =` + strconv.Itoa(chartPermissionId)
  558. condition = ` AND a.publish_status=1 `
  559. if pageSize <= 0 {
  560. pageSize = utils.PageSize20
  561. }
  562. if currentIndex <= 0 {
  563. currentIndex = 1
  564. }
  565. startSize = paging.StartIndex(currentIndex, pageSize)
  566. total, err := models.GetArticleDepartmentCount(condition)
  567. page := paging.GetPaging(currentIndex, pageSize, total)
  568. resp := new(models.CygxArticleDepartmentList)
  569. userType, _, err := services.GetUserType(user.CompanyId)
  570. if err != nil {
  571. br.Msg = "获取信息失败"
  572. br.ErrMsg = "获取用户信息失败,Err:" + err.Error()
  573. return
  574. }
  575. if userType == 1 {
  576. resp.Paging = page
  577. br.Ret = 200
  578. br.Success = true
  579. br.Msg = "获取成功"
  580. br.Data = resp
  581. return
  582. }
  583. resp.HaveResearch = true
  584. //获取作者信息,并排序
  585. list, err := models.GetCygxArticleDepartmentList(startSize, pageSize, condition, uid)
  586. if err != nil {
  587. br.Msg = "获取信息失败"
  588. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  589. return
  590. }
  591. for k, v := range list {
  592. artList, err := models.GetArticleByDepartmentId(v.DepartmentId)
  593. if err != nil {
  594. br.Msg = "获取信息失败"
  595. br.ErrMsg = "获取文章信息失败,Err:" + err.Error()
  596. return
  597. }
  598. for k2, v2 := range artList {
  599. subjectNames, err := models.GetSubjectNames(v2.ArticleId)
  600. if err != nil {
  601. br.Msg = "获取失败" + strconv.Itoa(v2.ArticleId)
  602. br.ErrMsg = "获取失败,Err:" + err.Error()
  603. return
  604. }
  605. var subjectNamesNew string
  606. if len(subjectNames) > 0 {
  607. slice := strings.Split(subjectNames, "/")
  608. for k3, v3 := range slice {
  609. if k3 < 4 {
  610. subjectNamesNew += v3 + "/"
  611. }
  612. }
  613. }
  614. industryName, err := models.GetIndustrialNames(v2.ArticleId)
  615. if err != nil && err.Error() != utils.ErrNoRow() {
  616. br.Msg = "获取失败" + strconv.Itoa(v2.ArticleId)
  617. br.ErrMsg = "获取失败,Err:" + err.Error()
  618. return
  619. }
  620. subjectNamesNew = strings.TrimRight(subjectNamesNew, "/")
  621. artList[k2].SubjectName = subjectNamesNew
  622. artList[k2].DepartmentId = v.DepartmentId
  623. if subjectNamesNew == "" {
  624. artList[k2].IndustryName = industryName
  625. } else {
  626. artList[k2].IndustryName = industryName + "-" + subjectNamesNew
  627. }
  628. if artList[k2].IsReport == "1" {
  629. artList[k2].IndustryName = "【观点】" + artList[k2].IndustryName
  630. } else {
  631. artList[k2].IndustryName = "【纪要】" + artList[k2].IndustryName
  632. }
  633. }
  634. list[k].List = artList
  635. if v.FollowNum > 0 {
  636. list[k].IsMyFollow = true
  637. }
  638. }
  639. listnNew, err := models.GetIndustrialSubjectByDepartmentNew()
  640. if err != nil {
  641. br.Msg = "获取信息失败"
  642. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  643. return
  644. }
  645. if len(listnNew) > 0 {
  646. for _, v := range listnNew {
  647. firstStr := strings.Index(v.IndustrialAndSubjectIds, "—")
  648. Management := new(models.IndustrialManagementIdInt)
  649. if firstStr == 0 {
  650. Management.IndustryName = v.IndustryName
  651. } else {
  652. listSub, err := models.GetIndustrialManagementSubjectList(v.ArticleId)
  653. if err != nil {
  654. br.Msg = "获取信息失败"
  655. br.ErrMsg = "获取关联标的列表失败,Err:" + err.Error()
  656. return
  657. }
  658. var subjectNamesNew string
  659. for _, v1 := range listSub {
  660. subjectNamesNew += v1.SubjectName + "/"
  661. }
  662. subjectNamesNew = strings.TrimRight(subjectNamesNew, "/")
  663. Management.IndustryName = subjectNamesNew
  664. }
  665. Management.IndustrialManagementId = v.IndustrialManagementId
  666. Management.ArticleId = v.ArticleId
  667. resp.ListnNew = append(resp.ListnNew, Management)
  668. }
  669. }
  670. resp.List = list
  671. resp.Paging = page
  672. br.Ret = 200
  673. br.Success = true
  674. br.Msg = "获取成功"
  675. br.Data = resp
  676. }
  677. // @Title 关注作者/取消关注作者
  678. // @Description 关注作者/取消关注作者 接口
  679. // @Param request body models.CygxArticleDepartmentId true "type json string"
  680. // @Success 200
  681. // @router /fllowDepartment [post]
  682. func (this *ReportController) FllowDepartment() {
  683. br := new(models.BaseResponse).Init()
  684. defer func() {
  685. this.Data["json"] = br
  686. this.ServeJSON()
  687. }()
  688. user := this.User
  689. if user == nil {
  690. br.Msg = "请重新登录"
  691. br.Ret = 408
  692. return
  693. }
  694. uid := user.UserId
  695. var req models.CygxArticleDepartmentId
  696. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  697. if err != nil {
  698. br.Msg = "参数解析异常!"
  699. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  700. return
  701. }
  702. departmentId := req.DepartmentId
  703. var condition string
  704. countDepartment, err := models.GetDepartmentCount(departmentId)
  705. if err != nil {
  706. br.Msg = "获取数据失败!"
  707. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  708. return
  709. }
  710. if countDepartment == 0 {
  711. br.Msg = "作者不存在!"
  712. br.ErrMsg = "作者ID不存在:" + strconv.Itoa(departmentId)
  713. return
  714. }
  715. countUser, err := models.GetArticleDepartmentFollowByUid(uid)
  716. count, err := models.GetArticleDepartmentFollow(uid, departmentId, condition)
  717. if err != nil {
  718. br.Msg = "获取数据失败!"
  719. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  720. return
  721. }
  722. resp := new(models.CygxArticleDepartmentFollowResp)
  723. if countUser == 0 {
  724. resp.GoFollow = true
  725. }
  726. if count == 0 {
  727. item := new(models.CygxArticleDepartmentFollow)
  728. item.DepartmentId = departmentId
  729. item.UserId = uid
  730. item.Email = user.Email
  731. item.Mobile = user.Mobile
  732. item.CompanyId = user.CompanyId
  733. item.CompanyName = user.CompanyName
  734. item.Type = 1
  735. item.CreateTime = time.Now()
  736. item.ModifyTime = time.Now()
  737. _, err = models.AddArticleDepartmentFollow(item)
  738. if err != nil {
  739. br.Msg = "操作失败"
  740. br.ErrMsg = "操作失败,Err:" + err.Error()
  741. return
  742. }
  743. resp.Status = 1
  744. } else {
  745. var doType int
  746. condition = ` AND type = 1`
  747. count, err = models.GetArticleDepartmentFollow(uid, departmentId, condition)
  748. if err != nil {
  749. br.Msg = "操作失败!"
  750. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  751. return
  752. }
  753. if count == 1 {
  754. resp.Status = 2
  755. doType = 2
  756. } else {
  757. resp.Status = 1
  758. doType = 1
  759. }
  760. err = models.RemoveArticleDepartmentFollow(uid, departmentId, doType)
  761. if err != nil {
  762. br.Msg = "操作失败"
  763. br.ErrMsg = "取消关注失败,Err:" + err.Error()
  764. return
  765. }
  766. }
  767. br.Msg = "操作成功"
  768. br.Ret = 200
  769. br.Success = true
  770. br.Data = resp
  771. }
  772. // @Title 研选文章列表接口
  773. // @Description 获取研选文章列表接口
  774. // @Param PageSize query int true "每页数据条数"
  775. // @Param CurrentIndex query int true "当前页页码,从1开始"
  776. // @Param ArticleId query int true "文章id"
  777. // @Param DepartmentId query int true "作者ID"
  778. // @Param IndustrialManagementId query int true "产业ID"
  779. // @Success 200 {object} models.ReportArticleWhichIndustrialRepList
  780. // @router /industry/reportList [get]
  781. func (this *ReportController) ReportList() {
  782. br := new(models.BaseResponse).Init()
  783. defer func() {
  784. this.Data["json"] = br
  785. this.ServeJSON()
  786. }()
  787. user := this.User
  788. if user == nil {
  789. br.Msg = "请重新登录"
  790. br.Ret = 408
  791. return
  792. }
  793. uid := user.UserId
  794. pageSize, _ := this.GetInt("PageSize")
  795. currentIndex, _ := this.GetInt("CurrentIndex")
  796. departmentId, _ := this.GetInt("DepartmentId")
  797. industrialManagementId, _ := this.GetInt("IndustrialManagementId")
  798. articleId, _ := this.GetInt("ArticleId")
  799. var condition string
  800. var startSize int
  801. if pageSize <= 0 {
  802. pageSize = utils.PageSize20
  803. }
  804. if currentIndex <= 0 {
  805. currentIndex = 1
  806. }
  807. startSize = paging.StartIndex(currentIndex, pageSize)
  808. var pars []interface{}
  809. var total int
  810. resp := new(models.ReportArticleWhichIndustrialRepList)
  811. page := paging.GetPaging(currentIndex, pageSize, total)
  812. userType, _, err := services.GetUserType(user.CompanyId)
  813. if err != nil {
  814. br.Msg = "获取信息失败"
  815. br.ErrMsg = "获取用户信息失败,Err:" + err.Error()
  816. return
  817. }
  818. if userType == 1 {
  819. resp.Paging = page
  820. br.Ret = 200
  821. br.Success = true
  822. br.Msg = "获取成功"
  823. br.Data = resp
  824. return
  825. }
  826. resp.HaveResearch = true
  827. if departmentId > 0 {
  828. condition += ` AND art.department_id = ` + strconv.Itoa(departmentId)
  829. detail, err := models.GetArticleDepartmentDateilById(departmentId)
  830. if err != nil {
  831. br.Msg = "获取信息失败"
  832. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  833. return
  834. }
  835. resp.NickName = detail.NickName
  836. }
  837. if industrialManagementId > 0 {
  838. condition += ` AND m.industrial_management_id = ` + strconv.Itoa(industrialManagementId)
  839. }
  840. if articleId > 0 {
  841. detail, err := models.GetArticleDetailById(articleId)
  842. if err != nil {
  843. br.Msg = "获取信息失败"
  844. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  845. return
  846. }
  847. condition += ` AND art.subject_ids = '` + detail.SubjectIds + `'`
  848. }
  849. total, err = models.GetWhichDepartmentCount(condition)
  850. if err != nil {
  851. br.Msg = "获取信息失败"
  852. br.ErrMsg = "获取帖子总数失败,Err:" + err.Error()
  853. return
  854. }
  855. page = paging.GetPaging(currentIndex, pageSize, total)
  856. condition += ` GROUP BY art.article_id ORDER BY art.publish_date DESC`
  857. list, err := models.IndustrialToArticleWhichDepartment(condition, pars, uid, startSize, pageSize)
  858. if err != nil {
  859. br.Msg = "获取失败"
  860. br.ErrMsg = "获取失败,Err:" + err.Error()
  861. return
  862. }
  863. for k, v := range list {
  864. if v.Readnum == 0 {
  865. list[k].IsRed = true
  866. }
  867. list[k].IsResearch = true
  868. subjectNames, err := models.GetSubjectNames(v.ArticleId)
  869. if err != nil {
  870. br.Msg = "获取失败" + strconv.Itoa(v.ArticleId)
  871. br.ErrMsg = "获取失败,Err:" + err.Error()
  872. return
  873. }
  874. var subjectNamesNew string
  875. if len(subjectNames) > 0 {
  876. slice := strings.Split(subjectNames, "/")
  877. for k3, v3 := range slice {
  878. if k3 < 4 {
  879. subjectNamesNew += v3 + "/"
  880. }
  881. }
  882. }
  883. industryName, err := models.GetIndustrialNames(v.ArticleId)
  884. if err != nil && err.Error() != utils.ErrNoRow() {
  885. br.Msg = "获取失败" + strconv.Itoa(v.ArticleId)
  886. br.ErrMsg = "获取失败,Err:" + err.Error()
  887. return
  888. }
  889. subjectNamesNew = strings.TrimRight(subjectNamesNew, "/")
  890. list[k].SubjectName = subjectNamesNew
  891. if subjectNamesNew != "" {
  892. list[k].IndustryName = industryName + "-" + subjectNamesNew
  893. } else {
  894. list[k].IndustryName = industryName
  895. }
  896. resp.IndustryName = industryName
  897. }
  898. resp.List = list
  899. resp.Paging = page
  900. br.Ret = 200
  901. br.Success = true
  902. br.Msg = "获取成功"
  903. br.Data = resp
  904. }
  905. // @Title 研选最新主题关键词文章列表接口
  906. // @Description 获取研选最新主题关键词文章列表接口
  907. // @Param PageSize query int true "每页数据条数"
  908. // @Param CurrentIndex query int true "当前页页码,从1开始"
  909. // @Param ArticleId query int true "文章id"
  910. // @Success 200 {object} models.ReportArticleWhichIndustrialRepList
  911. // @router /industry/reportListNew [get]
  912. func (this *ReportController) ReportListNew() {
  913. br := new(models.BaseResponse).Init()
  914. defer func() {
  915. this.Data["json"] = br
  916. this.ServeJSON()
  917. }()
  918. user := this.User
  919. if user == nil {
  920. br.Msg = "请重新登录"
  921. br.Ret = 408
  922. return
  923. }
  924. uid := user.UserId
  925. pageSize, _ := this.GetInt("PageSize")
  926. currentIndex, _ := this.GetInt("CurrentIndex")
  927. articleId, _ := this.GetInt("ArticleId")
  928. var condition string
  929. var startSize int
  930. if pageSize <= 0 {
  931. pageSize = utils.PageSize20
  932. }
  933. if currentIndex <= 0 {
  934. currentIndex = 1
  935. }
  936. startSize = paging.StartIndex(currentIndex, pageSize)
  937. var pars []interface{}
  938. var total int
  939. resp := new(models.ReportArticleWhichIndustrialRepList)
  940. page := paging.GetPaging(currentIndex, pageSize, total)
  941. userType, _, err := services.GetUserType(user.CompanyId)
  942. if err != nil {
  943. br.Msg = "获取信息失败"
  944. br.ErrMsg = "获取用户信息失败,Err:" + err.Error()
  945. return
  946. }
  947. if userType == 1 {
  948. resp.Paging = page
  949. br.Ret = 200
  950. br.Success = true
  951. br.Msg = "获取成功"
  952. br.Data = resp
  953. return
  954. }
  955. resp.HaveResearch = true
  956. if articleId > 0 {
  957. detail, err := models.GetArticleDetailById(articleId)
  958. if err != nil {
  959. br.Msg = "获取信息失败"
  960. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  961. return
  962. }
  963. firstStr := strings.Index(detail.IndustrialAndSubjectIds, "—")
  964. if firstStr == 0 {
  965. condition += ` AND art.industrial_management_id = '` + strconv.Itoa(detail.IndustrialManagementId) + `'`
  966. } else {
  967. condition += ` AND art.industrial_and_subject_ids = '` + detail.IndustrialAndSubjectIds + `'`
  968. }
  969. }
  970. total, err = models.GetWhichDepartmentCount(condition)
  971. if err != nil {
  972. br.Msg = "获取信息失败"
  973. br.ErrMsg = "获取帖子总数失败,Err:" + err.Error()
  974. return
  975. }
  976. page = paging.GetPaging(currentIndex, pageSize, total)
  977. condition += ` GROUP BY art.article_id ORDER BY art.publish_date DESC`
  978. list, err := models.IndustrialToArticleWhichDepartment(condition, pars, uid, startSize, pageSize)
  979. if err != nil {
  980. br.Msg = "获取失败"
  981. br.ErrMsg = "获取失败,Err:" + err.Error()
  982. return
  983. }
  984. for k, v := range list {
  985. if v.Readnum == 0 {
  986. list[k].IsRed = true
  987. }
  988. list[k].IsResearch = true
  989. subjectNames, err := models.GetSubjectNames(v.ArticleId)
  990. if err != nil {
  991. br.Msg = "获取失败" + strconv.Itoa(v.ArticleId)
  992. br.ErrMsg = "获取失败,Err:" + err.Error()
  993. return
  994. }
  995. var subjectNamesNew string
  996. if len(subjectNames) > 0 {
  997. slice := strings.Split(subjectNames, "/")
  998. for k3, v3 := range slice {
  999. if k3 < 4 {
  1000. subjectNamesNew += v3 + "/"
  1001. }
  1002. }
  1003. }
  1004. industryName, err := models.GetIndustrialNames(v.ArticleId)
  1005. if err != nil && err.Error() != utils.ErrNoRow() {
  1006. br.Msg = "获取失败" + strconv.Itoa(v.ArticleId)
  1007. br.ErrMsg = "获取失败,Err:" + err.Error()
  1008. return
  1009. }
  1010. subjectNamesNew = strings.TrimRight(subjectNamesNew, "/")
  1011. list[k].SubjectName = subjectNamesNew
  1012. if subjectNamesNew != "" {
  1013. list[k].IndustryName = industryName + "-" + subjectNamesNew
  1014. } else {
  1015. list[k].IndustryName = industryName
  1016. }
  1017. resp.IndustryName = industryName
  1018. }
  1019. resp.List = list
  1020. resp.Paging = page
  1021. br.Ret = 200
  1022. br.Success = true
  1023. br.Msg = "获取成功"
  1024. br.Data = resp
  1025. }
  1026. // @Title 是否展示绝密内参
  1027. // @Description 获取是否展示绝密内参接口
  1028. // @Param request body models.IsShow true "type json string"
  1029. // @Success 200
  1030. // @router /isShow [get]
  1031. func (this *ReportController) IsShow() {
  1032. br := new(models.BaseResponse).Init()
  1033. defer func() {
  1034. this.Data["json"] = br
  1035. this.ServeJSON()
  1036. }()
  1037. user := this.User
  1038. if user == nil {
  1039. br.Msg = "请重新登录"
  1040. br.Ret = 408
  1041. return
  1042. }
  1043. var resp models.IsShow
  1044. mobile := user.Mobile
  1045. if mobile == "" {
  1046. br.Ret = 200
  1047. br.Success = true
  1048. br.Data = resp
  1049. return
  1050. }
  1051. total, _ := models.GetUserIsAdminCount(mobile)
  1052. if total > 0 {
  1053. resp.IsShow = true
  1054. }
  1055. br.Ret = 200
  1056. br.Success = true
  1057. br.Data = resp
  1058. }
  1059. // @Title 报告精选、本周研究汇总、上周纪要汇总列表
  1060. // @Description 获取报告精选、本周研究汇总、上周纪要汇总列表接口
  1061. // @Param PageSize query int true "每页数据条数"
  1062. // @Param CurrentIndex query int true "当前页页码,从1开始"
  1063. // @Param ReportType string query true "报告类型 ,1报告精选、2本周研究汇总、3上周纪要汇总"
  1064. // @Success 200 {object} models.CygxReportSelectionListPublicRep
  1065. // @router /reportList/byType [get]
  1066. func (this *ReportController) ReportListByType() {
  1067. br := new(models.BaseResponse).Init()
  1068. defer func() {
  1069. this.Data["json"] = br
  1070. this.ServeJSON()
  1071. }()
  1072. user := this.User
  1073. if user == nil {
  1074. br.Msg = "请重新登录"
  1075. br.Ret = 408
  1076. return
  1077. }
  1078. uid := user.UserId
  1079. pageSize, _ := this.GetInt("PageSize")
  1080. currentIndex, _ := this.GetInt("CurrentIndex")
  1081. reportType := this.GetString("ReportType")
  1082. var condition string
  1083. var startSize int
  1084. if pageSize <= 0 {
  1085. pageSize = utils.PageSize20
  1086. }
  1087. if currentIndex <= 0 {
  1088. currentIndex = 1
  1089. }
  1090. startSize = paging.StartIndex(currentIndex, pageSize)
  1091. var pars []interface{}
  1092. var total int
  1093. resp := new(models.CygxReportSelectionListPublicRep)
  1094. page := paging.GetPaging(currentIndex, pageSize, total)
  1095. var tbdb string
  1096. var readSql string
  1097. var reportTypeStr string
  1098. if reportType == "1" {
  1099. tbdb = "cygx_report_selection"
  1100. reportTypeStr = "bgjx"
  1101. } else if reportType == "2" {
  1102. tbdb = "cygx_research_summary"
  1103. reportTypeStr = "bzyjhz"
  1104. } else if reportType == "3" {
  1105. tbdb = "cygx_minutes_summary"
  1106. reportTypeStr = "szjyhz"
  1107. } else {
  1108. br.Msg = "请选择报告类型"
  1109. return
  1110. }
  1111. fmt.Println(tbdb)
  1112. condition = ` AND publish_status = 1`
  1113. total, err := models.GetCygxReportSelectionPublic(condition, tbdb, pars)
  1114. if err != nil {
  1115. br.Msg = "获取信息失败"
  1116. br.ErrMsg = "获取帖子总数失败,Err:" + err.Error()
  1117. return
  1118. }
  1119. readSql = ` (SELECT COUNT(1) AS count FROM cygx_report_history_record AS h WHERE h.article_id = art.article_id AND report_type ='` + reportTypeStr + `' AND h.user_id = ` + strconv.Itoa(uid) + `) as read_num`
  1120. page = paging.GetPaging(currentIndex, pageSize, total)
  1121. list, err := models.GetReportSelectionListPublic(condition, readSql, tbdb, pars, startSize, pageSize)
  1122. if err != nil {
  1123. br.Msg = "获取失败"
  1124. br.ErrMsg = "获取失败,Err:" + err.Error()
  1125. return
  1126. }
  1127. for k, v := range list {
  1128. if reportType == "1" {
  1129. list[k].Abstract = v.UpdateDescription
  1130. }
  1131. list[k].PublishDate = utils.StrTimeToTime(v.PublishDate).Format("2006-01-02")
  1132. if v.ReadNum == 0 {
  1133. list[k].IsRed = true
  1134. }
  1135. }
  1136. resp.List = list
  1137. resp.Paging = page
  1138. br.Ret = 200
  1139. br.Success = true
  1140. br.Msg = "获取成功"
  1141. br.Data = resp
  1142. }
  1143. // @Title 获取报告精选详情
  1144. // @Description 获取报告精选详情接口
  1145. // @Param ArticleId query int true "报告ID"
  1146. // @Success 200 {object} models.ReportSelectionLetailResp
  1147. // @router /reportSelection/detail [get]
  1148. func (this *ReportController) Detail() {
  1149. br := new(models.BaseResponse).Init()
  1150. defer func() {
  1151. this.Data["json"] = br
  1152. this.ServeJSON()
  1153. }()
  1154. user := this.User
  1155. if user == nil {
  1156. br.Msg = "请重新登录"
  1157. br.Ret = 408
  1158. return
  1159. }
  1160. uid := user.UserId
  1161. articleId, _ := this.GetInt("ArticleId")
  1162. if articleId < 0 {
  1163. br.Msg = "参数错误"
  1164. br.ErrMsg = "参数错误"
  1165. return
  1166. }
  1167. resp := new(models.ReportSelectionLetailResp)
  1168. //判断用户权限
  1169. hasPermission, err := services.GetUserhasPermission(user)
  1170. if err != nil {
  1171. br.Msg = "获取信息失败"
  1172. br.ErrMsg = "获取用户权限信息失败,Err:" + err.Error()
  1173. }
  1174. resp.HasPermission = hasPermission
  1175. if hasPermission != 1 {
  1176. br.Ret = 200
  1177. br.Success = true
  1178. br.Msg = "获取成功"
  1179. br.Data = resp
  1180. return
  1181. }
  1182. detail, err := models.GetCygxReportSelectionInfoById(articleId)
  1183. if err != nil {
  1184. br.Msg = "获取信息失败"
  1185. br.ErrMsg = "报告不存在,Err:" + err.Error() + "articleId:" + strconv.Itoa(articleId)
  1186. return
  1187. }
  1188. detail.PublishDate = utils.StrTimeToTime(detail.PublishDate).Format("2006-01-02")
  1189. existMap := make(map[int]int)
  1190. var items []*models.ReportSelectionChartPermission
  1191. listLog, err := models.GetReportSelectionlogListAll(articleId)
  1192. detail.VideoPlaySeconds = utils.Mp3Time(detail.VideoPlaySeconds)
  1193. if err != nil {
  1194. br.Msg = "获取失败"
  1195. br.ErrMsg = "获取子类信息失败,Err:" + err.Error()
  1196. return
  1197. }
  1198. //var itemLogs []*models.CygxReportSelectionLogDetail
  1199. for _, v := range listLog {
  1200. item := new(models.ReportSelectionChartPermission)
  1201. if existMap[v.ChartPermissionId] == 0 {
  1202. item.PermissionName = v.PermissionName + "领域深度调研和报告"
  1203. item.IcoLink = v.IcoLink
  1204. listSonLog, err := models.GetReportSelectionlogSonListAll(articleId, v.ChartPermissionId)
  1205. if err != nil && err.Error() != utils.ErrNoRow() {
  1206. br.Msg = "获取信息失败"
  1207. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  1208. return
  1209. }
  1210. for k2, v2 := range listSonLog {
  1211. if v2.IndustrialManagementId != "" {
  1212. listIndustrial, err := models.GetIndustrialByIds(v2.IndustrialManagementId)
  1213. if err != nil && err.Error() != utils.ErrNoRow() {
  1214. br.Msg = "获取信息失败"
  1215. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  1216. return
  1217. }
  1218. listSonLog[k2].List = listIndustrial
  1219. }
  1220. }
  1221. item.List = listSonLog
  1222. items = append(items, item)
  1223. //itemLogs = make([]*models.CygxReportSelectionLogDetail, 0)
  1224. }
  1225. existMap[v.ChartPermissionId] = v.ChartPermissionId
  1226. }
  1227. historyRecord := new(models.CygxReportHistoryRecord)
  1228. historyRecord.UserId = uid
  1229. historyRecord.ArticleId = articleId
  1230. historyRecord.CreateTime = time.Now()
  1231. historyRecord.Mobile = user.Mobile
  1232. historyRecord.Email = user.Email
  1233. historyRecord.CompanyId = user.CompanyId
  1234. historyRecord.CompanyName = user.CompanyName
  1235. historyRecord.ReportType = "bgjx"
  1236. go models.AddCygxReportHistoryRecord(historyRecord)
  1237. resp.List = items
  1238. resp.Detail = detail
  1239. br.Ret = 200
  1240. br.Success = true
  1241. br.Msg = "获取成功"
  1242. br.Data = resp
  1243. }
  1244. // @Title 获取本周研究汇总详情
  1245. // @Description 获取本周研究汇总详情接口
  1246. // @Param ArticleId query int true "报告ID"
  1247. // @Success 200 {object} models.ResearchSummaryLetailResp
  1248. // @router /researchSummary/detail [get]
  1249. func (this *ReportController) ResearchDetail() {
  1250. br := new(models.BaseResponse).Init()
  1251. defer func() {
  1252. this.Data["json"] = br
  1253. this.ServeJSON()
  1254. }()
  1255. user := this.User
  1256. if user == nil {
  1257. br.Msg = "请重新登录"
  1258. br.Ret = 408
  1259. return
  1260. }
  1261. uid := user.UserId
  1262. articleId, _ := this.GetInt("ArticleId")
  1263. if articleId < 0 {
  1264. br.Msg = "参数错误"
  1265. br.ErrMsg = "参数错误"
  1266. return
  1267. }
  1268. resp := new(models.ResearchSummaryLetailResp)
  1269. //判断用户权限
  1270. hasPermission, err := services.GetUserhasPermission(user)
  1271. if err != nil {
  1272. br.Msg = "获取信息失败"
  1273. br.ErrMsg = "获取用户权限信息失败,Err:" + err.Error()
  1274. }
  1275. resp.HasPermission = hasPermission
  1276. if hasPermission != 1 {
  1277. br.Ret = 200
  1278. br.Success = true
  1279. br.Msg = "获取成功"
  1280. br.Data = resp
  1281. return
  1282. }
  1283. detail, err := models.GetCygxResearchSummaryInfoById(articleId)
  1284. if err != nil {
  1285. br.Msg = "获取信息失败"
  1286. br.ErrMsg = "报告不存在,Err:" + err.Error() + "articleId:" + strconv.Itoa(articleId)
  1287. return
  1288. }
  1289. detail.PublishDate = utils.StrTimeToTime(detail.PublishDate).Format("2006-01-02")
  1290. detail.VideoPlaySeconds = utils.Mp3Time(detail.VideoPlaySeconds)
  1291. listFirst, err := models.GetResearchSummarylogListFirst(articleId)
  1292. if err != nil {
  1293. br.Msg = "获取失败"
  1294. br.ErrMsg = "获取子类信息失败,Err:" + err.Error()
  1295. return
  1296. }
  1297. for k, v := range listFirst {
  1298. listSecond, err := models.GetResearchSummarylogSonListSecond(articleId, v.Type)
  1299. if err != nil && err.Error() != utils.ErrNoRow() {
  1300. br.Msg = "获取信息失败"
  1301. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  1302. return
  1303. }
  1304. for k2, v2 := range listSecond {
  1305. listThird, err := models.GetResearchSummarylogSonListThird(articleId, v2.ChartPermissionId, v.Type)
  1306. if err != nil && err.Error() != utils.ErrNoRow() {
  1307. br.Msg = "获取信息失败"
  1308. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  1309. return
  1310. }
  1311. if len(listThird) > 0 {
  1312. listSecond[k2].List = listThird
  1313. for k3, v3 := range listThird {
  1314. if v3.VideoUrl != "" {
  1315. listThird[k3].IsHaveVideo = true
  1316. }
  1317. if v3.ReportLink == "0" {
  1318. listThird[k3].ReportLink = ""
  1319. }
  1320. }
  1321. }
  1322. }
  1323. if len(listSecond) > 0 {
  1324. listFirst[k].List = listSecond
  1325. }
  1326. //`description:"类型'SDBG深度报告片篇,’CYDYJY:产业调研纪要’,’SJDP事件点评,’BZCHJH:本周晨会精华’"`
  1327. if v.Type == "SDBG" {
  1328. listFirst[k].ListName = "深度报告"
  1329. listFirst[k].IcoLink = "https://hongze.oss-cn-shanghai.aliyuncs.com/static/images/202110/20211027/le8AcRjDz0MhA72bVDiaf3d5ALSe.png"
  1330. } else if v.Type == "BZCHJH" {
  1331. listFirst[k].ListName = "本周晨会精华"
  1332. listFirst[k].IcoLink = "https://hongze.oss-cn-shanghai.aliyuncs.com/static/images/202110/20211020/DCfekcxaIKGePBsNVu1ULfmNcJBY.png"
  1333. } else if v.Type == "CYDYJY" {
  1334. listFirst[k].ListName = "产业调研纪要"
  1335. listFirst[k].IcoLink = "https://hongze.oss-cn-shanghai.aliyuncs.com/static/images/202110/20211020/UPAdozy96z9ypzY04vi0Y3Ogqzji.png"
  1336. } else if v.Type == "SSGS" {
  1337. listFirst[k].ListName = "上市公司调研纪要篇"
  1338. listFirst[k].IcoLink = "https://hongze.oss-cn-shanghai.aliyuncs.com/static/images/202111/20211101/ujHXB48I8ay9T0XoPRI7lorz7OkL.png"
  1339. } else {
  1340. listFirst[k].ListName = "事件点评"
  1341. listFirst[k].IcoLink = "https://hongze.oss-cn-shanghai.aliyuncs.com/static/images/202110/20211020/2a5cXafO3Iws4QcFp1bd5WPdYikV.png"
  1342. }
  1343. }
  1344. historyRecord := new(models.CygxReportHistoryRecord)
  1345. historyRecord.UserId = uid
  1346. historyRecord.ArticleId = articleId
  1347. historyRecord.CreateTime = time.Now()
  1348. historyRecord.Mobile = user.Mobile
  1349. historyRecord.Email = user.Email
  1350. historyRecord.CompanyId = user.CompanyId
  1351. historyRecord.CompanyName = user.CompanyName
  1352. historyRecord.ReportType = "bzyjhz"
  1353. go models.AddCygxReportHistoryRecord(historyRecord)
  1354. resp.List = listFirst
  1355. resp.Detail = detail
  1356. br.Ret = 200
  1357. br.Success = true
  1358. br.Msg = "获取成功"
  1359. br.Data = resp
  1360. }
  1361. // @Title 上周纪要汇总内容详情
  1362. // @Description 获取上周纪要汇总内容详情接口
  1363. // @Param ArticleId query int true "报告ID"
  1364. // @Success 200 {object} models.MinutesSummaryLetailResp
  1365. // @router /minutesSummary/detail [get]
  1366. func (this *ReportController) MinutesDetail() {
  1367. br := new(models.BaseResponse).Init()
  1368. defer func() {
  1369. this.Data["json"] = br
  1370. this.ServeJSON()
  1371. }()
  1372. user := this.User
  1373. if user == nil {
  1374. br.Msg = "请重新登录"
  1375. br.Ret = 408
  1376. return
  1377. }
  1378. uid := user.UserId
  1379. articleId, _ := this.GetInt("ArticleId")
  1380. if articleId < 0 {
  1381. br.Msg = "参数错误"
  1382. br.ErrMsg = "参数错误"
  1383. return
  1384. }
  1385. resp := new(models.MinutesSummaryLetailResp)
  1386. //判断用户权限
  1387. hasPermission, err := services.GetUserhasPermission(user)
  1388. if err != nil {
  1389. br.Msg = "获取信息失败"
  1390. br.ErrMsg = "获取用户权限信息失败,Err:" + err.Error()
  1391. }
  1392. resp.HasPermission = hasPermission
  1393. if hasPermission != 1 {
  1394. br.Ret = 200
  1395. br.Success = true
  1396. br.Msg = "获取成功"
  1397. br.Data = resp
  1398. return
  1399. }
  1400. detail, err := models.GetCygxMinutesSummaryInfoById(articleId)
  1401. if err != nil {
  1402. br.Msg = "获取信息失败"
  1403. br.ErrMsg = "报告不存在,Err:" + err.Error() + "articleId:" + strconv.Itoa(articleId)
  1404. return
  1405. }
  1406. detail.PublishDate = utils.StrTimeToTime(detail.PublishDate).Format("2006-01-02")
  1407. detail.VideoPlaySeconds = utils.Mp3Time(detail.VideoPlaySeconds)
  1408. listLog, err := models.GetMinutesSummarylogListAll(articleId)
  1409. if err != nil {
  1410. br.Msg = "获取失败"
  1411. br.ErrMsg = "获取子类信息失败,Err:" + err.Error()
  1412. return
  1413. }
  1414. for k, v := range listLog {
  1415. listSonLog, err := models.GetMinutesSummarylogSonListAll(articleId, v.ChartPermissionId)
  1416. if err != nil && err.Error() != utils.ErrNoRow() {
  1417. br.Msg = "获取信息失败"
  1418. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  1419. return
  1420. }
  1421. if len(listSonLog) > 0 {
  1422. listLog[k].List = listSonLog
  1423. for k2, v2 := range listSonLog {
  1424. if v2.ReportLink == "0" {
  1425. listSonLog[k2].ReportLink = ""
  1426. }
  1427. }
  1428. }
  1429. }
  1430. historyRecord := new(models.CygxReportHistoryRecord)
  1431. historyRecord.UserId = uid
  1432. historyRecord.ArticleId = articleId
  1433. historyRecord.CreateTime = time.Now()
  1434. historyRecord.Mobile = user.Mobile
  1435. historyRecord.Email = user.Email
  1436. historyRecord.CompanyId = user.CompanyId
  1437. historyRecord.CompanyName = user.CompanyName
  1438. historyRecord.ReportType = "szjyhz"
  1439. go models.AddCygxReportHistoryRecord(historyRecord)
  1440. resp.List = listLog
  1441. resp.Detail = detail
  1442. br.Ret = 200
  1443. br.Success = true
  1444. br.Msg = "获取成功"
  1445. br.Data = resp
  1446. }
  1447. // @Title 获取路演精华详情
  1448. // @Description 获取路演精华详情接口
  1449. // @Param ArticleId query int true "报告ID"
  1450. // @Success 200 {object} models.RoadshowDetailResp
  1451. // @router /roadshowEssence/detail [get]
  1452. func (this *ReportController) RoadshowDetail() {
  1453. br := new(models.BaseResponse).Init()
  1454. defer func() {
  1455. this.Data["json"] = br
  1456. this.ServeJSON()
  1457. }()
  1458. user := this.User
  1459. if user == nil {
  1460. br.Msg = "请登录"
  1461. br.ErrMsg = "请登录,用户信息为空"
  1462. br.Ret = 408
  1463. return
  1464. }
  1465. uid := user.UserId
  1466. articleId, err := this.GetInt("ArticleId")
  1467. if articleId <= 0 {
  1468. br.Msg = "文章不存在"
  1469. br.ErrMsg = "文章不存在,文章ID错误"
  1470. return
  1471. }
  1472. detail := new(models.ReportDetailRoadshow)
  1473. hasPermission := 0
  1474. hasFree := 0
  1475. //判断是否已经申请过
  1476. applyCount, err := models.GetApplyRecordCount(uid)
  1477. if err != nil && err.Error() != utils.ErrNoRow() {
  1478. br.Msg = "获取信息失败"
  1479. br.ErrMsg = "判断是否已申请过试用失败,Err:" + err.Error()
  1480. return
  1481. }
  1482. //`description:"1:有该行业权限,正常展示,2:无该行业权限,不存在权益客户下,3:无该品类权限,4:潜在客户,未提交过申请,5:潜在客户,已提交过申请"`
  1483. if user.CompanyId > 1 {
  1484. companyPermission, err := models.GetCompanyPermission(user.CompanyId)
  1485. if err != nil {
  1486. br.Msg = "获取信息失败"
  1487. br.ErrMsg = "判断是否已申请访谈失败,Err:" + strconv.Itoa(uid) + ";articleId" + strconv.Itoa(articleId)
  1488. return
  1489. }
  1490. detail, err = models.GetReportRoadshowDetailById(articleId)
  1491. if err != nil {
  1492. br.Msg = "获取信息失败"
  1493. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  1494. return
  1495. }
  1496. detail.Body = html.UnescapeString(detail.Body)
  1497. detail.Abstract, _ = services.GetReportContentTextSub(detail.Abstract)
  1498. detail.PublishDate = utils.StrTimeToTime(detail.PublishDate).Format("2006-01-02")
  1499. detail.VideoPlaySeconds = utils.Mp3Time(detail.VideoPlaySeconds)
  1500. if detail.ReportLink == "0" {
  1501. detail.ReportLink = ""
  1502. }
  1503. if companyPermission == "" {
  1504. if applyCount > 0 {
  1505. hasPermission = 5
  1506. } else {
  1507. hasPermission = 2
  1508. }
  1509. hasFree = 2
  1510. goto Loop
  1511. } else {
  1512. hasFree = 1
  1513. var articlePermissionPermissionName string
  1514. articlePermissionPermissionName = detail.CategoryName
  1515. var hasPersion bool
  1516. slice := strings.Split(articlePermissionPermissionName, ",")
  1517. for _, v := range slice {
  1518. if strings.Contains(companyPermission, v) {
  1519. hasPersion = true
  1520. }
  1521. }
  1522. if hasPersion {
  1523. hasPermission = 1
  1524. historyRecord := new(models.CygxArticleHistoryRecord)
  1525. historyRecord.UserId = uid
  1526. historyRecord.ArticleId = articleId
  1527. historyRecord.CreateTime = time.Now()
  1528. historyRecord.Mobile = user.Mobile
  1529. historyRecord.Email = user.Email
  1530. historyRecord.CompanyId = user.CompanyId
  1531. historyRecord.CompanyName = user.CompanyName
  1532. go models.AddCygxArticleHistoryRecord(historyRecord)
  1533. } else { //无该行业权限
  1534. hasPermission = 3
  1535. }
  1536. if hasPermission == 1 {
  1537. key := "CYGX_ARTICLE_" + strconv.Itoa(articleId) + "_" + strconv.Itoa(uid)
  1538. if !utils.Rc.IsExist(key) {
  1539. //新增浏览记录
  1540. record := new(models.CygxArticleViewRecord)
  1541. record.UserId = uid
  1542. record.ArticleId = articleId
  1543. record.CreateTime = time.Now()
  1544. record.Mobile = user.Mobile
  1545. record.Email = user.Email
  1546. record.CompanyId = user.CompanyId
  1547. record.CompanyName = user.CompanyName
  1548. go models.AddCygxArticleViewRecord(record)
  1549. utils.Rc.Put(key, 1, 5*time.Second)
  1550. models.ModifyReportLastViewTime(uid)
  1551. }
  1552. }
  1553. }
  1554. } else { //潜在客户
  1555. if applyCount > 0 {
  1556. hasPermission = 5
  1557. } else {
  1558. hasPermission = 4
  1559. }
  1560. }
  1561. Loop:
  1562. if hasPermission != 1 {
  1563. detail.Body = ""
  1564. detail.Abstract = ""
  1565. }
  1566. resp := new(models.RoadshowDetailResp)
  1567. resp.HasPermission = hasPermission
  1568. resp.HasFree = hasFree
  1569. resp.Detail = detail
  1570. br.Ret = 200
  1571. br.Success = true
  1572. br.Msg = "获取成功"
  1573. br.Data = resp
  1574. }
  1575. // @Title 产业文章列表接口
  1576. // @Description 获取产业文章列表接口
  1577. // @Param KeyWord query string true "搜索关键词"
  1578. // @Success 200 {object} models.CygxIndustrySearchList
  1579. // @router /industryAndArticle/list [get]
  1580. func (this *ReportController) IndustryAndArticleList() {
  1581. br := new(models.BaseResponse).Init()
  1582. defer func() {
  1583. this.Data["json"] = br
  1584. this.ServeJSON()
  1585. }()
  1586. user := this.User
  1587. if user == nil {
  1588. br.Msg = "请重新登录"
  1589. br.Ret = 408
  1590. return
  1591. }
  1592. uid := user.UserId
  1593. keyWord := this.GetString("KeyWord")
  1594. orderSrt := "update_time DESC"
  1595. condition := ` AND subject_names LIKE '%` + keyWord + `%'`
  1596. list, err := models.GetIndustrialManagementAll(uid, condition, orderSrt, 0, 100)
  1597. if err != nil {
  1598. br.Msg = "获取信息失败"
  1599. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  1600. return
  1601. }
  1602. for k, v := range list {
  1603. industrialSubjectList, err := models.GetIndustrialSubjectAll(v.IndustrialManagementId)
  1604. if err != nil {
  1605. br.Msg = "获取信息失败"
  1606. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  1607. return
  1608. }
  1609. list[k].IndustrialSubjectList = industrialSubjectList
  1610. //list[k].LayoutTime = utils.TimeRemoveHms(v.LayoutTime)
  1611. newArtinfo, err := models.GetIndustrialNewArticleDetail(v.IndustrialManagementId)
  1612. if err != nil {
  1613. br.Msg = "获取信息失败"
  1614. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  1615. return
  1616. }
  1617. list[k].UpdateTime = utils.TimeRemoveHms(newArtinfo.PublishDate)
  1618. }
  1619. artList, err := models.GetCygxIndustryAndArticleList(keyWord)
  1620. if err != nil {
  1621. br.Msg = "获取失败"
  1622. br.ErrMsg = "获取失败,Err:" + err.Error()
  1623. return
  1624. }
  1625. for k2, v2 := range artList {
  1626. subjectNames, err := models.GetSubjectNames(v2.ArticleId)
  1627. if err != nil {
  1628. br.Msg = "获取失败" + strconv.Itoa(v2.ArticleId)
  1629. br.ErrMsg = "获取失败,Err:" + err.Error()
  1630. return
  1631. }
  1632. var subjectNamesNew string
  1633. if len(subjectNames) > 0 {
  1634. slice := strings.Split(subjectNames, "/")
  1635. for k3, v3 := range slice {
  1636. if k3 < 4 {
  1637. subjectNamesNew += v3 + "/"
  1638. }
  1639. }
  1640. }
  1641. industryName, err := models.GetIndustrialNames(v2.ArticleId)
  1642. if err != nil && err.Error() != utils.ErrNoRow() {
  1643. br.Msg = "获取失败" + strconv.Itoa(v2.ArticleId)
  1644. br.ErrMsg = "获取失败,Err:" + err.Error()
  1645. return
  1646. }
  1647. subjectNamesNew = strings.TrimRight(subjectNamesNew, "/")
  1648. artList[k2].SubjectName = subjectNamesNew
  1649. if subjectNamesNew == "" {
  1650. artList[k2].IndustryName = industryName
  1651. } else {
  1652. artList[k2].IndustryName = industryName + "-" + subjectNamesNew
  1653. }
  1654. }
  1655. resp := new(models.CygxIndustrySearchList)
  1656. resp.ArtList = artList
  1657. resp.IndList = list
  1658. br.Ret = 200
  1659. br.Success = true
  1660. br.Msg = "获取成功"
  1661. br.Data = resp
  1662. }