report.go 75 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431
  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. orderColumnNew := this.GetString("OrderColumn")
  97. isNewLabel := this.GetString("IsNewLabel")
  98. isDeepLabel := this.GetString("IsDeepLabel")
  99. keyWord := this.GetString("KeyWord")
  100. pageSize, _ := this.GetInt("PageSize")
  101. currentIndex, _ := this.GetInt("CurrentIndex")
  102. var orderSrt string
  103. var condition string
  104. var startSize int
  105. resp := new(models.IndustrialManagementList)
  106. if pageSize <= 0 {
  107. pageSize = utils.PageSize20
  108. }
  109. if currentIndex <= 0 {
  110. currentIndex = 1
  111. }
  112. startSize = paging.StartIndex(currentIndex, pageSize)
  113. if isNewLabel == "1" {
  114. condition += ` AND is_new_label = ` + isNewLabel
  115. }
  116. if isDeepLabel == "1" {
  117. condition += ` AND is_deep_label = ` + isDeepLabel
  118. }
  119. if keyWord != "" {
  120. //keyWordArr, err := services.GetIndustryMapNameSliceV2(keyWord)
  121. //if err != nil {
  122. // br.Msg = "获取信息失败"
  123. // br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  124. // return
  125. //}
  126. //var conditionkeyWord string
  127. //conditionkeyWord += ` subject_names LIKE '%` + keyWord + `%'`
  128. //keyWordArr = services.RemoveDuplicatesAndEmpty(keyWordArr)
  129. //keyWordLen := len(keyWordArr)
  130. //if keyWordLen <= 0 {
  131. // keyWordArr = append(keyWordArr, keyWord)
  132. // keyWordLen = len(keyWordArr)
  133. //}
  134. //for _, v := range keyWordArr {
  135. // conditionkeyWord += ` OR subject_names LIKE '%` + v + `%'`
  136. //}
  137. //industrialManagementIds, err := models.GetIndustrialManagementIdsBykeyWord(conditionkeyWord)
  138. //if err != nil {
  139. // br.Msg = "获取信息失败"
  140. // br.ErrMsg = "获取客户信息失败,Err:" + err.Error()
  141. // return
  142. //}
  143. //if industrialManagementIds == "" {
  144. // br.Ret = 200
  145. // br.Success = true
  146. // br.Msg = "获取成功"
  147. // br.Data = resp
  148. // return
  149. //}
  150. //condition += ` AND man.industrial_management_id IN (` + industrialManagementIds + `)`
  151. condition += ` AND subject_names LIKE '%` + keyWord + `%'`
  152. }
  153. var sqlChartPermissionId string
  154. if ChartPermissionId > 0 {
  155. sqlChartPermissionId += ` AND man_g.industrial_management_id IN ( SELECT industrial_management_id FROM cygx_industrial_management WHERE chart_permission_id = ` + strconv.Itoa(ChartPermissionId) + ` ) `
  156. condition += ` AND man.chart_permission_id IN (` + strconv.Itoa(ChartPermissionId) + `)`
  157. }
  158. var list []*models.IndustrialManagement
  159. total, err := models.GetIndustrialManagementAllCount(condition)
  160. if err != nil {
  161. br.Msg = "获取信息失败"
  162. br.ErrMsg = "获取数量失败,Err:" + err.Error()
  163. return
  164. }
  165. page := paging.GetPaging(currentIndex, pageSize, total)
  166. if orderColumn == "" {
  167. orderColumn = "NewTime"
  168. }
  169. if orderColumn == "NewTime" {
  170. orderSrt = "update_time DESC"
  171. } else {
  172. orderSrt = "man.recommended_index DESC,update_time DESC"
  173. }
  174. if ChartPermissionId == 0 {
  175. ChartPermissionId = 20
  176. }
  177. detailHot3, err := models.GetIndustrialManagementHot3(ChartPermissionId)
  178. if err != nil {
  179. br.Msg = "获取信息失败"
  180. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  181. return
  182. }
  183. list, err = models.GetIndustrialManagementAll(uid, condition, orderSrt, startSize, pageSize)
  184. if err != nil {
  185. br.Msg = "获取信息失败"
  186. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  187. return
  188. }
  189. for k, v := range list {
  190. industrialSubjectList, err := models.GetIndustrialSubjectAll(v.IndustrialManagementId)
  191. if err != nil {
  192. br.Msg = "获取信息失败"
  193. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  194. return
  195. }
  196. list[k].IndustrialSubjectList = industrialSubjectList
  197. list[k].LayoutTime = utils.TimeRemoveHms(v.LayoutTime)
  198. newArtinfo, err := models.GetIndustrialNewArticleDetail(v.IndustrialManagementId)
  199. if err != nil {
  200. br.Msg = "获取信息失败"
  201. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  202. return
  203. }
  204. list[k].UpdateTime = utils.TimeRemoveHms(newArtinfo.PublishDate)
  205. recordCount, err := models.GetUserToArticleCount(uid, newArtinfo.ArticleId)
  206. if err != nil && err.Error() != utils.ErrNoRow() {
  207. br.Msg = "获取信息失败"
  208. br.ErrMsg = "获取信息失败,Err:" + strconv.Itoa(uid) + ";articleId" + strconv.Itoa(newArtinfo.ArticleId)
  209. return
  210. }
  211. if recordCount == 0 && user.CreatedTime.Before(utils.StrTimeToTime(newArtinfo.PublishDate)) && utils.StrTimeToTime(utils.OnlineTime).Before(utils.StrTimeToTime(newArtinfo.PublishDate)) {
  212. list[k].IsRed = true
  213. }
  214. if v.ArticleReadNum >= detailHot3.ArticleReadNum {
  215. list[k].IsHot = true
  216. }
  217. }
  218. //记录用户搜索的筛选条件
  219. if orderColumnNew != "" {
  220. item := new(models.CygxReportIndustrialSeaarchHistory)
  221. item.UserId = user.UserId
  222. item.Mobile = user.Mobile
  223. item.CompanyId = user.CompanyId
  224. item.CompanyName = user.CompanyName
  225. item.CreateTime = time.Now()
  226. item.IsDeepLabel = isDeepLabel
  227. item.IsNewLabel = isNewLabel
  228. item.ChartPermissionId = ChartPermissionId
  229. if orderColumnNew == "NewTime" {
  230. item.OrderColumn = "0"
  231. } else {
  232. item.OrderColumn = "1"
  233. }
  234. go models.AddCygxReportIndustrialSeaarchHistory(item)
  235. }
  236. resp.List = list
  237. resp.Paging = page
  238. br.Ret = 200
  239. br.Success = true
  240. br.Msg = "获取成功"
  241. br.Data = resp
  242. }
  243. // @Title 产业下所关联的文章分类列表
  244. // @Description 产业下所关联的文章分类列表接口
  245. // @Param IndustrialManagementId query int true "产业ID"
  246. // @Success 200 {object} models.IndustrialToArticleCategoryListRep
  247. // @router /toArticleCategoryList [get]
  248. func (this *ReportController) ArticleCategoryList() {
  249. br := new(models.BaseResponse).Init()
  250. defer func() {
  251. this.Data["json"] = br
  252. this.ServeJSON()
  253. }()
  254. user := this.User
  255. if user == nil {
  256. br.Msg = "请重新登录"
  257. br.Ret = 408
  258. return
  259. }
  260. uid := user.UserId
  261. industrialManagementId, _ := this.GetInt("IndustrialManagementId")
  262. if industrialManagementId < 1 {
  263. br.Msg = "请输入分类ID"
  264. return
  265. }
  266. detail, err := models.GetIndustrialManagementDetail(industrialManagementId)
  267. if err != nil {
  268. br.Msg = "获取信息失败"
  269. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  270. return
  271. }
  272. list, err := models.IndustrialToArticleCategory(industrialManagementId, detail.ChartPermissionId)
  273. if err != nil {
  274. br.Msg = "获取信息失败"
  275. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  276. return
  277. }
  278. for k, v := range list {
  279. recordCount, err := models.IndustrialUserRecordArticleCount(uid, industrialManagementId, v.CategoryId)
  280. if err != nil && err.Error() != utils.ErrNoRow() {
  281. br.Msg = "获取信息失败"
  282. br.ErrMsg = "判断是否已申请过试用失败,Err:" + err.Error()
  283. return
  284. }
  285. Newdetail, err := models.GetNewIndustrialUserRecordArticle(industrialManagementId, v.CategoryId)
  286. if err != nil {
  287. br.Msg = "获取信息失败"
  288. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  289. return
  290. }
  291. if recordCount == 0 && user.CreatedTime.Before(utils.StrTimeToTime(Newdetail.PublishDate)) && utils.StrTimeToTime(utils.OnlineTime).Before(utils.StrTimeToTime(Newdetail.PublishDate)) {
  292. list[k].IsRed = true
  293. }
  294. }
  295. //detail, err := models.GetIndustrialManagementDetail(industrialManagementId)
  296. //if err != nil {
  297. // br.Msg = "获取信息失败"
  298. // br.ErrMsg = "获取信息失败,Err:" + err.Error()
  299. // return
  300. //}
  301. resp := new(models.IndustrialToArticleCategoryListRep)
  302. resp.List = list
  303. resp.LayoutTime = utils.TimeRemoveHms(detail.LayoutTime)
  304. resp.IndustryName = detail.IndustryName
  305. resp.IndustrialManagementId = industrialManagementId
  306. br.Ret = 200
  307. br.Success = true
  308. br.Msg = "获取成功"
  309. br.Data = resp
  310. }
  311. // @Title 产业文章列表接口
  312. // @Description 获取产业文章列表接口
  313. // @Param PageSize query int true "每页数据条数"
  314. // @Param CurrentIndex query int true "当前页页码,从1开始"
  315. // @Param CategoryId query int true "分类ID"
  316. // @Param IndustrialManagementId query int true "产业ID"
  317. // @Success 200 {object} models.TacticsListResp
  318. // @router /industry/ArticleList [get]
  319. func (this *ReportController) List() {
  320. br := new(models.BaseResponse).Init()
  321. defer func() {
  322. this.Data["json"] = br
  323. this.ServeJSON()
  324. }()
  325. user := this.User
  326. if user == nil {
  327. br.Msg = "请重新登录"
  328. br.Ret = 408
  329. return
  330. }
  331. uid := user.UserId
  332. pageSize, _ := this.GetInt("PageSize")
  333. currentIndex, _ := this.GetInt("CurrentIndex")
  334. categoryId, _ := this.GetInt("CategoryId")
  335. industrialManagementId, _ := this.GetInt("IndustrialManagementId")
  336. var startSize int
  337. if pageSize <= 0 {
  338. pageSize = utils.PageSize20
  339. }
  340. if currentIndex <= 0 {
  341. currentIndex = 1
  342. }
  343. startSize = paging.StartIndex(currentIndex, pageSize)
  344. var pars []interface{}
  345. var total int
  346. resp := new(models.TacticsListResp)
  347. page := paging.GetPaging(currentIndex, pageSize, total)
  348. if categoryId < 1 {
  349. br.Msg = "请输入分类ID"
  350. return
  351. }
  352. if industrialManagementId < 1 {
  353. br.Msg = "请输入产业ID"
  354. return
  355. }
  356. //获取该产业下所对应的行业图片
  357. detail, errCategory := models.GetdetailByCategoryIdOne(categoryId)
  358. if errCategory != nil {
  359. br.Msg = "获取信息失败"
  360. br.ErrMsg = "获取信息失败,Err:" + errCategory.Error() + "categoryID 不存在:" + strconv.Itoa(categoryId)
  361. return
  362. }
  363. //对应行业的图片
  364. detailChartPermissionUrl, err := models.GetConfigByCode("category_chart_permissionimg_url")
  365. if err != nil {
  366. br.Msg = "获取数据失败"
  367. br.ErrMsg = "行业配置信息失败,Err:" + err.Error()
  368. return
  369. }
  370. chartPermissionUrlList := strings.Split(detailChartPermissionUrl.ConfigValue, "{|}")
  371. mapChartPermission := make(map[string]string)
  372. var permissionName string
  373. var imgUrlChartPermission string
  374. for _, v := range chartPermissionUrlList {
  375. vslice := strings.Split(v, "_")
  376. permissionName = vslice[0]
  377. imgUrlChartPermission = vslice[len(vslice)-1]
  378. mapChartPermission[permissionName] = imgUrlChartPermission
  379. }
  380. total, err = models.GetReportIndustrialCount(categoryId, industrialManagementId)
  381. if err != nil {
  382. br.Msg = "获取信息失败"
  383. br.ErrMsg = "获取帖子总数失败,Err:" + err.Error()
  384. return
  385. }
  386. page = paging.GetPaging(currentIndex, pageSize, total)
  387. list, err := models.GetReportIndustrialList(pars, categoryId, industrialManagementId, uid, startSize, pageSize)
  388. if err != nil {
  389. br.Msg = "获取信息失败"
  390. br.ErrMsg = "获取帖子数据失败,Err:" + err.Error()
  391. return
  392. }
  393. //对应分类的所图片
  394. detailCategoryUrl, err := models.GetConfigByCode("category_map_img_url")
  395. if err != nil {
  396. br.Msg = "获取数据失败"
  397. br.ErrMsg = "行业配置信息失败,Err:" + err.Error()
  398. return
  399. }
  400. categoryUrlList := strings.Split(detailCategoryUrl.ConfigValue, "{|}")
  401. mapCategoryUrl := make(map[string]string)
  402. var categoryIdStr string
  403. var imgUrlChart string
  404. for _, v := range categoryUrlList {
  405. vslice := strings.Split(v, "_")
  406. categoryIdStr = vslice[0]
  407. imgUrlChart = vslice[len(vslice)-1]
  408. mapCategoryUrl[categoryIdStr] = imgUrlChart
  409. }
  410. lenList := len(list)
  411. for i := 0; i < lenList; i++ {
  412. item := list[i]
  413. list[i].Body, _ = services.GetReportContentTextSub(item.Body)
  414. //list[i].Abstract = html.UnescapeString(item.Abstract)
  415. list[i].Abstract, _ = services.GetReportContentTextSub(item.Abstract)
  416. }
  417. for k, v := range list {
  418. if v.Readnum == 0 && user.CreatedTime.Before(utils.StrTimeToTime(v.PublishDate)) && utils.StrTimeToTime(utils.OnlineTime).Before(utils.StrTimeToTime(v.PublishDate)) {
  419. list[k].IsRed = true
  420. }
  421. if v.VideoUrl != "" {
  422. list[k].IsHaveVideo = true
  423. }
  424. list[k].ImgUrlPc = mapCategoryUrl[v.CategoryId]
  425. }
  426. resp.CategoryImgUrlPc = mapChartPermission[detail.ChartPermissionName]
  427. resp.List = list
  428. resp.Paging = page
  429. br.Ret = 200
  430. br.Success = true
  431. br.Msg = "获取成功"
  432. br.Data = resp
  433. }
  434. // @Title 置顶/取消置顶
  435. // @Description 置顶
  436. // @Param request body models.CygxIndustryTopRep true "type json string"
  437. // @Success 200
  438. // @router /top [post]
  439. func (this *ReportController) ArticleCollect() {
  440. br := new(models.BaseResponse).Init()
  441. defer func() {
  442. this.Data["json"] = br
  443. this.ServeJSON()
  444. }()
  445. user := this.User
  446. if user == nil {
  447. br.Msg = "请重新登录"
  448. br.Ret = 408
  449. return
  450. }
  451. uid := user.UserId
  452. var req models.CygxIndustryTopRep
  453. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  454. if err != nil {
  455. br.Msg = "参数解析异常!"
  456. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  457. return
  458. }
  459. industrialManagementId := req.IndustrialManagementId
  460. countIndustrial, err := models.GetIndustrialManagementCount(industrialManagementId)
  461. if err != nil {
  462. br.Msg = "获取数据失败!"
  463. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  464. return
  465. }
  466. if countIndustrial == 0 {
  467. br.Msg = "产业不存在!"
  468. br.ErrMsg = "产业ID不存在:" + strconv.Itoa(industrialManagementId)
  469. return
  470. }
  471. count, err := models.GetCygxIndustryTop(uid, industrialManagementId)
  472. if err != nil {
  473. br.Msg = "获取数据失败!"
  474. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  475. return
  476. }
  477. resp := new(models.ArticleCollectResp)
  478. if count <= 0 {
  479. item := new(models.CygxIndustryTop)
  480. item.IndustrialManagementId = req.IndustrialManagementId
  481. item.UserId = uid
  482. item.CreateTime = time.Now()
  483. _, err = models.AddCygxIndustryTop(item)
  484. if err != nil {
  485. br.Msg = "置顶失败"
  486. br.ErrMsg = "置顶失败,Err:" + err.Error()
  487. return
  488. }
  489. br.Msg = "置顶成功"
  490. resp.Status = 1
  491. } else {
  492. err = models.RemoveCygxIndustryTop(uid, industrialManagementId)
  493. if err != nil {
  494. br.Msg = "取消置顶失败"
  495. br.ErrMsg = "取消置顶失败,Err:" + err.Error()
  496. return
  497. }
  498. br.Msg = "已取消置顶"
  499. resp.Status = 2
  500. }
  501. br.Ret = 200
  502. br.Success = true
  503. br.Data = resp
  504. }
  505. // @Title 关注/取消关注产业
  506. // @Description 关注/取消关注 接口
  507. // @Param request body models.CygxIndustryFllowRep true "type json string"
  508. // @Success 200
  509. // @router /fllow [post]
  510. func (this *ReportController) Fllow() {
  511. br := new(models.BaseResponse).Init()
  512. defer func() {
  513. this.Data["json"] = br
  514. this.ServeJSON()
  515. }()
  516. user := this.User
  517. if user == nil {
  518. br.Msg = "请重新登录"
  519. br.Ret = 408
  520. return
  521. }
  522. uid := user.UserId
  523. var req models.CygxIndustryFllowRep
  524. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  525. if err != nil {
  526. br.Msg = "参数解析异常!"
  527. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  528. return
  529. }
  530. industrialManagementId := req.IndustrialManagementId
  531. var condition string
  532. countIndustrial, err := models.GetIndustrialManagementCount(industrialManagementId)
  533. if err != nil {
  534. br.Msg = "获取数据失败!"
  535. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  536. return
  537. }
  538. if countIndustrial == 0 {
  539. br.Msg = "产业不存在!"
  540. br.ErrMsg = "产业ID不存在:" + strconv.Itoa(industrialManagementId)
  541. return
  542. }
  543. count, err := models.GetCountCygxIndustryFllow(uid, industrialManagementId, condition)
  544. if err != nil {
  545. br.Msg = "获取数据失败!"
  546. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  547. return
  548. }
  549. resp := new(models.CygxIndustryFllowResp)
  550. countUser, err := models.GetCountCygxIndustryFllowByUid(uid)
  551. if countUser == 0 {
  552. resp.GoFollow = true
  553. }
  554. if count == 0 {
  555. item := new(models.CygxIndustryFllow)
  556. item.IndustrialManagementId = industrialManagementId
  557. item.UserId = uid
  558. item.Email = user.Email
  559. item.Mobile = user.Mobile
  560. item.RealName = user.RealName
  561. item.CompanyId = user.CompanyId
  562. item.CompanyName = user.CompanyName
  563. item.Type = 1
  564. item.CreateTime = time.Now()
  565. item.ModifyTime = time.Now()
  566. _, err = models.AddCygxIndustryFllow(item)
  567. if err != nil {
  568. br.Msg = "操作失败"
  569. br.ErrMsg = "操作失败,Err:" + err.Error()
  570. return
  571. }
  572. resp.Status = 1
  573. } else {
  574. var doType int
  575. condition = ` AND type = 1`
  576. count, err = models.GetCountCygxIndustryFllow(uid, industrialManagementId, condition)
  577. if err != nil {
  578. br.Msg = "操作失败!"
  579. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  580. return
  581. }
  582. if count == 1 {
  583. resp.Status = 2
  584. doType = 2
  585. } else {
  586. resp.Status = 1
  587. doType = 1
  588. }
  589. err = models.RemoveCygxIndustryFllow(uid, industrialManagementId, doType)
  590. if err != nil {
  591. br.Msg = "操作失败"
  592. br.ErrMsg = "取消关注失败,Err:" + err.Error()
  593. return
  594. }
  595. }
  596. br.Msg = "操作成功"
  597. br.Ret = 200
  598. br.Success = true
  599. br.Data = resp
  600. }
  601. // @Title 产业报告分类关联作者列表接口
  602. // @Description 获取产业报告分类关联作者列表接口
  603. // @Param ChartPermissionId query int true "分类ID"
  604. // @Param PageSize query int true "每页数据条数"
  605. // @Param CurrentIndex query int true "当前页页码,从1开始"
  606. // @Success 200 {object} models.CygxArticleDepartmentList
  607. // @router /industryListByDepartment [get]
  608. func (this *ReportController) IndustryListByDepartment() {
  609. br := new(models.BaseResponse).Init()
  610. defer func() {
  611. this.Data["json"] = br
  612. this.ServeJSON()
  613. }()
  614. user := this.User
  615. if user == nil {
  616. br.Msg = "请重新登录"
  617. br.Ret = 408
  618. return
  619. }
  620. uid := user.UserId
  621. pageSize, _ := this.GetInt("PageSize")
  622. currentIndex, _ := this.GetInt("CurrentIndex")
  623. //chartPermissionId, _ := this.GetInt("ChartPermissionId")
  624. var startSize int
  625. var condition string
  626. //condition = ` AND a.publish_status=1 AND m.chart_permission_id =` + strconv.Itoa(chartPermissionId)
  627. condition = ` AND a.publish_status=1 `
  628. if pageSize <= 0 {
  629. pageSize = utils.PageSize20
  630. }
  631. if currentIndex <= 0 {
  632. currentIndex = 1
  633. }
  634. startSize = paging.StartIndex(currentIndex, pageSize)
  635. total, err := models.GetArticleDepartmentCount(condition)
  636. page := paging.GetPaging(currentIndex, pageSize, total)
  637. resp := new(models.CygxArticleDepartmentList)
  638. userType, _, err := services.GetUserType(user.CompanyId)
  639. if err != nil {
  640. br.Msg = "获取信息失败"
  641. br.ErrMsg = "获取用户信息失败,Err:" + err.Error()
  642. return
  643. }
  644. if userType == 1 {
  645. resp.Paging = page
  646. br.Ret = 200
  647. br.Success = true
  648. br.Msg = "获取成功"
  649. br.Data = resp
  650. return
  651. }
  652. resp.HaveResearch = true
  653. //获取作者信息,并排序
  654. list, err := models.GetCygxArticleDepartmentList(startSize, pageSize, condition, uid)
  655. if err != nil {
  656. br.Msg = "获取信息失败"
  657. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  658. return
  659. }
  660. for k, v := range list {
  661. artList, err := models.GetArticleByDepartmentId(v.DepartmentId)
  662. if err != nil {
  663. br.Msg = "获取信息失败"
  664. br.ErrMsg = "获取文章信息失败,Err:" + err.Error()
  665. return
  666. }
  667. for k2, v2 := range artList {
  668. subjectNames, err := models.GetSubjectNames(v2.ArticleId)
  669. if err != nil {
  670. br.Msg = "获取失败" + strconv.Itoa(v2.ArticleId)
  671. br.ErrMsg = "获取失败,Err:" + err.Error()
  672. return
  673. }
  674. var subjectNamesNew string
  675. if len(subjectNames) > 0 {
  676. slice := strings.Split(subjectNames, "/")
  677. for k3, v3 := range slice {
  678. if k3 < 4 {
  679. subjectNamesNew += v3 + "/"
  680. }
  681. }
  682. }
  683. industryName, err := models.GetIndustrialNames(v2.ArticleId)
  684. if err != nil && err.Error() != utils.ErrNoRow() {
  685. br.Msg = "获取失败" + strconv.Itoa(v2.ArticleId)
  686. br.ErrMsg = "获取失败,Err:" + err.Error()
  687. return
  688. }
  689. subjectNamesNew = strings.TrimRight(subjectNamesNew, "/")
  690. artList[k2].SubjectName = subjectNamesNew
  691. artList[k2].DepartmentId = v.DepartmentId
  692. if subjectNamesNew == "" {
  693. artList[k2].IndustryName = industryName
  694. } else {
  695. artList[k2].IndustryName = industryName + "-" + subjectNamesNew
  696. }
  697. if artList[k2].IsReport == "1" {
  698. artList[k2].IndustryName = "【观点】" + artList[k2].IndustryName
  699. } else {
  700. artList[k2].IndustryName = "【纪要】" + artList[k2].IndustryName
  701. }
  702. }
  703. list[k].List = artList
  704. if v.FollowNum > 0 {
  705. list[k].IsMyFollow = true
  706. }
  707. }
  708. listnNew, err := models.GetIndustrialSubjectByDepartmentNew()
  709. if err != nil {
  710. br.Msg = "获取信息失败"
  711. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  712. return
  713. }
  714. if len(listnNew) > 0 {
  715. for _, v := range listnNew {
  716. firstStr := strings.Index(v.IndustrialAndSubjectIds, "—")
  717. Management := new(models.IndustrialManagementIdInt)
  718. if firstStr == 0 {
  719. Management.IndustryName = v.IndustryName
  720. } else {
  721. listSub, err := models.GetIndustrialManagementSubjectList(v.ArticleId)
  722. if err != nil {
  723. br.Msg = "获取信息失败"
  724. br.ErrMsg = "获取关联标的列表失败,Err:" + err.Error()
  725. return
  726. }
  727. var subjectNamesNew string
  728. for _, v1 := range listSub {
  729. subjectNamesNew += v1.SubjectName + "/"
  730. }
  731. subjectNamesNew = strings.TrimRight(subjectNamesNew, "/")
  732. Management.IndustryName = subjectNamesNew
  733. }
  734. Management.IndustrialManagementId = v.IndustrialManagementId
  735. Management.ArticleId = v.ArticleId
  736. resp.ListnNew = append(resp.ListnNew, Management)
  737. }
  738. }
  739. resp.List = list
  740. resp.Paging = page
  741. br.Ret = 200
  742. br.Success = true
  743. br.Msg = "获取成功"
  744. br.Data = resp
  745. }
  746. // @Title 关注作者/取消关注作者
  747. // @Description 关注作者/取消关注作者 接口
  748. // @Param request body models.CygxArticleDepartmentId true "type json string"
  749. // @Success 200
  750. // @router /fllowDepartment [post]
  751. func (this *ReportController) FllowDepartment() {
  752. br := new(models.BaseResponse).Init()
  753. defer func() {
  754. this.Data["json"] = br
  755. this.ServeJSON()
  756. }()
  757. user := this.User
  758. if user == nil {
  759. br.Msg = "请重新登录"
  760. br.Ret = 408
  761. return
  762. }
  763. uid := user.UserId
  764. var req models.CygxArticleDepartmentId
  765. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  766. if err != nil {
  767. br.Msg = "参数解析异常!"
  768. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  769. return
  770. }
  771. departmentId := req.DepartmentId
  772. var condition string
  773. countDepartment, err := models.GetDepartmentCount(departmentId)
  774. if err != nil {
  775. br.Msg = "获取数据失败!"
  776. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  777. return
  778. }
  779. if countDepartment == 0 {
  780. br.Msg = "作者不存在!"
  781. br.ErrMsg = "作者ID不存在:" + strconv.Itoa(departmentId)
  782. return
  783. }
  784. countUser, err := models.GetArticleDepartmentFollowByUid(uid)
  785. count, err := models.GetArticleDepartmentFollow(uid, departmentId, condition)
  786. if err != nil {
  787. br.Msg = "获取数据失败!"
  788. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  789. return
  790. }
  791. resp := new(models.CygxArticleDepartmentFollowResp)
  792. if countUser == 0 {
  793. resp.GoFollow = true
  794. }
  795. if count == 0 {
  796. item := new(models.CygxArticleDepartmentFollow)
  797. item.DepartmentId = departmentId
  798. item.UserId = uid
  799. item.Email = user.Email
  800. item.Mobile = user.Mobile
  801. item.RealName = user.RealName
  802. item.CompanyId = user.CompanyId
  803. item.CompanyName = user.CompanyName
  804. item.Type = 1
  805. item.CreateTime = time.Now()
  806. item.ModifyTime = time.Now()
  807. _, err = models.AddArticleDepartmentFollow(item)
  808. if err != nil {
  809. br.Msg = "操作失败"
  810. br.ErrMsg = "操作失败,Err:" + err.Error()
  811. return
  812. }
  813. resp.Status = 1
  814. } else {
  815. var doType int
  816. condition = ` AND type = 1`
  817. count, err = models.GetArticleDepartmentFollow(uid, departmentId, condition)
  818. if err != nil {
  819. br.Msg = "操作失败!"
  820. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  821. return
  822. }
  823. if count == 1 {
  824. resp.Status = 2
  825. doType = 2
  826. } else {
  827. resp.Status = 1
  828. doType = 1
  829. }
  830. err = models.RemoveArticleDepartmentFollow(uid, departmentId, doType)
  831. if err != nil {
  832. br.Msg = "操作失败"
  833. br.ErrMsg = "取消关注失败,Err:" + err.Error()
  834. return
  835. }
  836. }
  837. br.Msg = "操作成功"
  838. br.Ret = 200
  839. br.Success = true
  840. br.Data = resp
  841. }
  842. // @Title 研选文章列表接口
  843. // @Description 获取研选文章列表接口
  844. // @Param PageSize query int true "每页数据条数"
  845. // @Param CurrentIndex query int true "当前页页码,从1开始"
  846. // @Param ArticleId query int true "文章id"
  847. // @Param DepartmentId query int true "作者ID"
  848. // @Param IndustrialManagementId query int true "产业ID"
  849. // @Success 200 {object} models.ReportArticleWhichIndustrialRepList
  850. // @router /industry/reportList [get]
  851. func (this *ReportController) ReportList() {
  852. br := new(models.BaseResponse).Init()
  853. defer func() {
  854. this.Data["json"] = br
  855. this.ServeJSON()
  856. }()
  857. user := this.User
  858. if user == nil {
  859. br.Msg = "请重新登录"
  860. br.Ret = 408
  861. return
  862. }
  863. uid := user.UserId
  864. pageSize, _ := this.GetInt("PageSize")
  865. currentIndex, _ := this.GetInt("CurrentIndex")
  866. departmentId, _ := this.GetInt("DepartmentId")
  867. industrialManagementId, _ := this.GetInt("IndustrialManagementId")
  868. articleId, _ := this.GetInt("ArticleId")
  869. var condition string
  870. var startSize int
  871. if pageSize <= 0 {
  872. pageSize = utils.PageSize20
  873. }
  874. if currentIndex <= 0 {
  875. currentIndex = 1
  876. }
  877. startSize = paging.StartIndex(currentIndex, pageSize)
  878. var pars []interface{}
  879. var total int
  880. resp := new(models.ReportArticleWhichIndustrialRepList)
  881. page := paging.GetPaging(currentIndex, pageSize, total)
  882. userType, _, err := services.GetUserType(user.CompanyId)
  883. if err != nil {
  884. br.Msg = "获取信息失败"
  885. br.ErrMsg = "获取用户信息失败,Err:" + err.Error()
  886. return
  887. }
  888. if userType == 1 {
  889. resp.Paging = page
  890. br.Ret = 200
  891. br.Success = true
  892. br.Msg = "获取成功"
  893. br.Data = resp
  894. return
  895. }
  896. resp.HaveResearch = true
  897. if departmentId > 0 {
  898. condition += ` AND art.department_id = ` + strconv.Itoa(departmentId)
  899. detail, err := models.GetArticleDepartmentDateilById(departmentId)
  900. if err != nil {
  901. br.Msg = "获取信息失败"
  902. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  903. return
  904. }
  905. resp.NickName = detail.NickName
  906. }
  907. if industrialManagementId > 0 {
  908. condition += ` AND m.industrial_management_id = ` + strconv.Itoa(industrialManagementId)
  909. }
  910. if articleId > 0 {
  911. detail, err := models.GetArticleDetailById(articleId)
  912. if err != nil {
  913. br.Msg = "获取信息失败"
  914. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  915. return
  916. }
  917. condition += ` AND art.subject_ids = '` + detail.SubjectIds + `'`
  918. }
  919. total, err = models.GetWhichDepartmentCount(condition)
  920. if err != nil {
  921. br.Msg = "获取信息失败"
  922. br.ErrMsg = "获取帖子总数失败,Err:" + err.Error()
  923. return
  924. }
  925. page = paging.GetPaging(currentIndex, pageSize, total)
  926. condition += ` GROUP BY art.article_id ORDER BY art.publish_date DESC`
  927. list, err := models.IndustrialToArticleWhichDepartment(condition, pars, uid, startSize, pageSize)
  928. if err != nil {
  929. br.Msg = "获取失败"
  930. br.ErrMsg = "获取失败,Err:" + err.Error()
  931. return
  932. }
  933. for k, v := range list {
  934. if v.Readnum == 0 {
  935. list[k].IsRed = true
  936. }
  937. list[k].IsResearch = true
  938. subjectNames, err := models.GetSubjectNames(v.ArticleId)
  939. if err != nil {
  940. br.Msg = "获取失败" + strconv.Itoa(v.ArticleId)
  941. br.ErrMsg = "获取失败,Err:" + err.Error()
  942. return
  943. }
  944. var subjectNamesNew string
  945. if len(subjectNames) > 0 {
  946. slice := strings.Split(subjectNames, "/")
  947. for k3, v3 := range slice {
  948. if k3 < 4 {
  949. subjectNamesNew += v3 + "/"
  950. }
  951. }
  952. }
  953. industryName, err := models.GetIndustrialNames(v.ArticleId)
  954. if err != nil && err.Error() != utils.ErrNoRow() {
  955. br.Msg = "获取失败" + strconv.Itoa(v.ArticleId)
  956. br.ErrMsg = "获取失败,Err:" + err.Error()
  957. return
  958. }
  959. subjectNamesNew = strings.TrimRight(subjectNamesNew, "/")
  960. list[k].SubjectName = subjectNamesNew
  961. if subjectNamesNew != "" {
  962. list[k].IndustryName = industryName + "-" + subjectNamesNew
  963. } else {
  964. list[k].IndustryName = industryName
  965. }
  966. resp.IndustryName = industryName
  967. list[k].ImgUrlPc = "https://hongze.oss-cn-shanghai.aliyuncs.com/static/images/202112/20211206/UvMadc63MLZY6rnQZQgGZAFXkqwf.png"
  968. }
  969. resp.List = list
  970. resp.Paging = page
  971. br.Ret = 200
  972. br.Success = true
  973. br.Msg = "获取成功"
  974. br.Data = resp
  975. }
  976. // @Title 研选最新主题关键词文章列表接口
  977. // @Description 获取研选最新主题关键词文章列表接口
  978. // @Param PageSize query int true "每页数据条数"
  979. // @Param CurrentIndex query int true "当前页页码,从1开始"
  980. // @Param ArticleId query int true "文章id"
  981. // @Success 200 {object} models.ReportArticleWhichIndustrialRepList
  982. // @router /industry/reportListNew [get]
  983. func (this *ReportController) ReportListNew() {
  984. br := new(models.BaseResponse).Init()
  985. defer func() {
  986. this.Data["json"] = br
  987. this.ServeJSON()
  988. }()
  989. user := this.User
  990. if user == nil {
  991. br.Msg = "请重新登录"
  992. br.Ret = 408
  993. return
  994. }
  995. uid := user.UserId
  996. pageSize, _ := this.GetInt("PageSize")
  997. currentIndex, _ := this.GetInt("CurrentIndex")
  998. articleId, _ := this.GetInt("ArticleId")
  999. var condition string
  1000. var startSize int
  1001. if pageSize <= 0 {
  1002. pageSize = utils.PageSize20
  1003. }
  1004. if currentIndex <= 0 {
  1005. currentIndex = 1
  1006. }
  1007. startSize = paging.StartIndex(currentIndex, pageSize)
  1008. var pars []interface{}
  1009. var total int
  1010. resp := new(models.ReportArticleWhichIndustrialRepList)
  1011. page := paging.GetPaging(currentIndex, pageSize, total)
  1012. userType, _, err := services.GetUserType(user.CompanyId)
  1013. if err != nil {
  1014. br.Msg = "获取信息失败"
  1015. br.ErrMsg = "获取用户信息失败,Err:" + err.Error()
  1016. return
  1017. }
  1018. if userType == 1 {
  1019. resp.Paging = page
  1020. br.Ret = 200
  1021. br.Success = true
  1022. br.Msg = "获取成功"
  1023. br.Data = resp
  1024. return
  1025. }
  1026. resp.HaveResearch = true
  1027. if articleId > 0 {
  1028. detail, err := models.GetArticleDetailById(articleId)
  1029. if err != nil {
  1030. br.Msg = "获取信息失败"
  1031. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  1032. return
  1033. }
  1034. firstStr := strings.Index(detail.IndustrialAndSubjectIds, "—")
  1035. if firstStr == 0 {
  1036. condition += ` AND art.industrial_management_id = '` + strconv.Itoa(detail.IndustrialManagementId) + `'`
  1037. } else {
  1038. condition += ` AND art.industrial_and_subject_ids = '` + detail.IndustrialAndSubjectIds + `'`
  1039. }
  1040. }
  1041. total, err = models.GetWhichDepartmentCount(condition)
  1042. if err != nil {
  1043. br.Msg = "获取信息失败"
  1044. br.ErrMsg = "获取帖子总数失败,Err:" + err.Error()
  1045. return
  1046. }
  1047. page = paging.GetPaging(currentIndex, pageSize, total)
  1048. condition += ` GROUP BY art.article_id ORDER BY art.publish_date DESC`
  1049. list, err := models.IndustrialToArticleWhichDepartment(condition, pars, uid, startSize, pageSize)
  1050. if err != nil {
  1051. br.Msg = "获取失败"
  1052. br.ErrMsg = "获取失败,Err:" + err.Error()
  1053. return
  1054. }
  1055. for k, v := range list {
  1056. if v.Readnum == 0 {
  1057. list[k].IsRed = true
  1058. }
  1059. list[k].IsResearch = true
  1060. list[k].ImgUrlPc = "https://hongze.oss-cn-shanghai.aliyuncs.com/static/images/202112/20211206/UvMadc63MLZY6rnQZQgGZAFXkqwf.png"
  1061. subjectNames, err := models.GetSubjectNames(v.ArticleId)
  1062. if err != nil {
  1063. br.Msg = "获取失败" + strconv.Itoa(v.ArticleId)
  1064. br.ErrMsg = "获取失败,Err:" + err.Error()
  1065. return
  1066. }
  1067. var subjectNamesNew string
  1068. if len(subjectNames) > 0 {
  1069. slice := strings.Split(subjectNames, "/")
  1070. for k3, v3 := range slice {
  1071. if k3 < 4 {
  1072. subjectNamesNew += v3 + "/"
  1073. }
  1074. }
  1075. }
  1076. industryName, err := models.GetIndustrialNames(v.ArticleId)
  1077. if err != nil && err.Error() != utils.ErrNoRow() {
  1078. br.Msg = "获取失败" + strconv.Itoa(v.ArticleId)
  1079. br.ErrMsg = "获取失败,Err:" + err.Error()
  1080. return
  1081. }
  1082. subjectNamesNew = strings.TrimRight(subjectNamesNew, "/")
  1083. list[k].SubjectName = subjectNamesNew
  1084. if subjectNamesNew != "" {
  1085. list[k].IndustryName = industryName + "-" + subjectNamesNew
  1086. } else {
  1087. list[k].IndustryName = industryName
  1088. }
  1089. resp.IndustryName = industryName
  1090. }
  1091. resp.List = list
  1092. resp.Paging = page
  1093. br.Ret = 200
  1094. br.Success = true
  1095. br.Msg = "获取成功"
  1096. br.Data = resp
  1097. }
  1098. // @Title 是否展示绝密内参
  1099. // @Description 获取是否展示绝密内参接口
  1100. // @Param request body models.IsShow true "type json string"
  1101. // @Success 200
  1102. // @router /isShow [get]
  1103. func (this *ReportController) IsShow() {
  1104. br := new(models.BaseResponse).Init()
  1105. defer func() {
  1106. this.Data["json"] = br
  1107. this.ServeJSON()
  1108. }()
  1109. user := this.User
  1110. if user == nil {
  1111. br.Msg = "请重新登录"
  1112. br.Ret = 408
  1113. return
  1114. }
  1115. var resp models.IsShow
  1116. //resp.IsShowChart = true
  1117. //resp.IsShowResearch = true
  1118. //resp.IsShowList = true
  1119. //mobile := user.Mobile
  1120. //if mobile == "" {
  1121. // br.Ret = 200
  1122. // br.Success = true
  1123. // br.Data = resp
  1124. // return
  1125. //}
  1126. //total, _ := models.GetUserIsAdminCount(mobile)
  1127. //if total > 0 {
  1128. // resp.IsShow = true
  1129. //}
  1130. //resp.LinkWxExplain = utils.LINK_WX_EXPLAIN
  1131. //resp.YanXuan_Explain = true
  1132. br.Ret = 200
  1133. br.Success = true
  1134. br.Data = resp
  1135. }
  1136. // @Title 报告精选、本周研究汇总、上周纪要汇总列表
  1137. // @Description 获取报告精选、本周研究汇总、上周纪要汇总列表接口
  1138. // @Param PageSize query int true "每页数据条数"
  1139. // @Param CurrentIndex query int true "当前页页码,从1开始"
  1140. // @Param ReportType string query true "报告类型 ,1报告精选、2本周研究汇总、3上周纪要汇总"
  1141. // @Success 200 {object} models.CygxReportSelectionListPublicRep
  1142. // @router /reportList/byType [get]
  1143. func (this *ReportController) ReportListByType() {
  1144. br := new(models.BaseResponse).Init()
  1145. defer func() {
  1146. this.Data["json"] = br
  1147. this.ServeJSON()
  1148. }()
  1149. user := this.User
  1150. if user == nil {
  1151. br.Msg = "请重新登录"
  1152. br.Ret = 408
  1153. return
  1154. }
  1155. uid := user.UserId
  1156. pageSize, _ := this.GetInt("PageSize")
  1157. currentIndex, _ := this.GetInt("CurrentIndex")
  1158. reportType := this.GetString("ReportType")
  1159. var condition string
  1160. var startSize int
  1161. if pageSize <= 0 {
  1162. pageSize = utils.PageSize20
  1163. }
  1164. if currentIndex <= 0 {
  1165. currentIndex = 1
  1166. }
  1167. startSize = paging.StartIndex(currentIndex, pageSize)
  1168. var pars []interface{}
  1169. var total int
  1170. resp := new(models.CygxReportSelectionListPublicRep)
  1171. page := paging.GetPaging(currentIndex, pageSize, total)
  1172. var tbdb string
  1173. var readSql string
  1174. var reportTypeStr string
  1175. if reportType == "1" {
  1176. tbdb = "cygx_report_selection"
  1177. reportTypeStr = "bgjx"
  1178. } else if reportType == "2" {
  1179. tbdb = "cygx_research_summary"
  1180. reportTypeStr = "bzyjhz"
  1181. } else if reportType == "3" {
  1182. tbdb = "cygx_minutes_summary"
  1183. reportTypeStr = "szjyhz"
  1184. } else {
  1185. br.Msg = "请选择报告类型"
  1186. return
  1187. }
  1188. fmt.Println(tbdb)
  1189. condition = ` AND publish_status = 1`
  1190. total, err := models.GetCygxReportSelectionPublic(condition, tbdb, pars)
  1191. if err != nil {
  1192. br.Msg = "获取信息失败"
  1193. br.ErrMsg = "获取帖子总数失败,Err:" + err.Error()
  1194. return
  1195. }
  1196. 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`
  1197. page = paging.GetPaging(currentIndex, pageSize, total)
  1198. list, err := models.GetReportSelectionListPublic(condition, readSql, tbdb, pars, startSize, pageSize)
  1199. if err != nil {
  1200. br.Msg = "获取失败"
  1201. br.ErrMsg = "获取失败,Err:" + err.Error()
  1202. return
  1203. }
  1204. for k, v := range list {
  1205. if reportType == "1" {
  1206. list[k].Abstract = v.UpdateDescription
  1207. }
  1208. list[k].PublishDate = utils.StrTimeToTime(v.PublishDate).Format("2006-01-02")
  1209. if v.ReadNum == 0 {
  1210. list[k].IsRed = true
  1211. }
  1212. }
  1213. resp.List = list
  1214. resp.Paging = page
  1215. br.Ret = 200
  1216. br.Success = true
  1217. br.Msg = "获取成功"
  1218. br.Data = resp
  1219. }
  1220. // @Title 获取报告精选详情
  1221. // @Description 获取报告精选详情接口
  1222. // @Param ArticleId query int true "报告ID"
  1223. // @Success 200 {object} models.ReportSelectionLetailResp
  1224. // @router /reportSelection/detail [get]
  1225. func (this *ReportController) Detail() {
  1226. br := new(models.BaseResponse).Init()
  1227. defer func() {
  1228. this.Data["json"] = br
  1229. this.ServeJSON()
  1230. }()
  1231. user := this.User
  1232. if user == nil {
  1233. br.Msg = "请重新登录"
  1234. br.Ret = 408
  1235. return
  1236. }
  1237. uid := user.UserId
  1238. articleId, _ := this.GetInt("ArticleId")
  1239. if articleId < 0 {
  1240. br.Msg = "参数错误"
  1241. br.ErrMsg = "参数错误"
  1242. return
  1243. }
  1244. resp := new(models.ReportSelectionLetailResp)
  1245. //判断用户权限
  1246. hasPermission, err := services.GetUserhasPermission(user)
  1247. if err != nil {
  1248. br.Msg = "获取信息失败"
  1249. br.ErrMsg = "获取用户权限信息失败,Err:" + err.Error()
  1250. }
  1251. resp.HasPermission = hasPermission
  1252. if hasPermission != 1 {
  1253. br.Ret = 200
  1254. br.Success = true
  1255. br.Msg = "获取成功"
  1256. br.Data = resp
  1257. return
  1258. }
  1259. detail, err := models.GetCygxReportSelectionInfoById(articleId)
  1260. if err != nil {
  1261. br.Msg = "获取信息失败"
  1262. br.ErrMsg = "报告不存在,Err:" + err.Error() + "articleId:" + strconv.Itoa(articleId)
  1263. return
  1264. }
  1265. detail.PublishDate = utils.StrTimeToTime(detail.PublishDate).Format("2006-01-02")
  1266. existMap := make(map[int]int)
  1267. var items []*models.ReportSelectionChartPermission
  1268. listLog, err := models.GetReportSelectionlogListAll(articleId)
  1269. detail.VideoPlaySeconds = utils.Mp3Time(detail.VideoPlaySeconds)
  1270. if err != nil {
  1271. br.Msg = "获取失败"
  1272. br.ErrMsg = "获取子类信息失败,Err:" + err.Error()
  1273. return
  1274. }
  1275. //var itemLogs []*models.CygxReportSelectionLogDetail
  1276. for _, v := range listLog {
  1277. item := new(models.ReportSelectionChartPermission)
  1278. if existMap[v.ChartPermissionId] == 0 {
  1279. item.PermissionName = v.PermissionName + "领域深度报告和调研"
  1280. item.IcoLink = v.IcoLink
  1281. listSonLog, err := models.GetReportSelectionlogSonListAll(articleId, v.ChartPermissionId)
  1282. if err != nil && err.Error() != utils.ErrNoRow() {
  1283. br.Msg = "获取信息失败"
  1284. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  1285. return
  1286. }
  1287. for k2, v2 := range listSonLog {
  1288. if v2.IndustrialManagementId != "" {
  1289. listIndustrial, err := models.GetIndustrialByIds(v2.IndustrialManagementId)
  1290. if err != nil && err.Error() != utils.ErrNoRow() {
  1291. br.Msg = "获取信息失败"
  1292. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  1293. return
  1294. }
  1295. listSonLog[k2].List = listIndustrial
  1296. }
  1297. }
  1298. item.List = listSonLog
  1299. items = append(items, item)
  1300. //itemLogs = make([]*models.CygxReportSelectionLogDetail, 0)
  1301. }
  1302. existMap[v.ChartPermissionId] = v.ChartPermissionId
  1303. }
  1304. historyRecord := new(models.CygxReportHistoryRecord)
  1305. historyRecord.UserId = uid
  1306. historyRecord.ArticleId = articleId
  1307. historyRecord.CreateTime = time.Now()
  1308. historyRecord.Mobile = user.Mobile
  1309. historyRecord.Email = user.Email
  1310. historyRecord.CompanyId = user.CompanyId
  1311. historyRecord.CompanyName = user.CompanyName
  1312. historyRecord.ReportType = "bgjx"
  1313. sellerItem, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  1314. if err != nil && err.Error() != utils.ErrNoRow() {
  1315. br.Msg = "获取信息失败"
  1316. br.ErrMsg = "获取销售信息失败,Err:" + err.Error()
  1317. return
  1318. }
  1319. historyRecord.RealName = user.RealName
  1320. if sellerItem != nil {
  1321. historyRecord.SellerName = sellerItem.RealName
  1322. }
  1323. go models.AddCygxReportHistoryRecord(historyRecord)
  1324. resp.List = items
  1325. resp.Detail = detail
  1326. br.Ret = 200
  1327. br.Success = true
  1328. br.Msg = "获取成功"
  1329. br.Data = resp
  1330. }
  1331. // @Title 获取本周研究汇总详情
  1332. // @Description 获取本周研究汇总详情接口
  1333. // @Param ArticleId query int true "报告ID"
  1334. // @Success 200 {object} models.ResearchSummaryLetailResp
  1335. // @router /researchSummary/detail [get]
  1336. func (this *ReportController) ResearchDetail() {
  1337. br := new(models.BaseResponse).Init()
  1338. defer func() {
  1339. this.Data["json"] = br
  1340. this.ServeJSON()
  1341. }()
  1342. user := this.User
  1343. if user == nil {
  1344. br.Msg = "请重新登录"
  1345. br.Ret = 408
  1346. return
  1347. }
  1348. uid := user.UserId
  1349. articleId, _ := this.GetInt("ArticleId")
  1350. if articleId < 0 {
  1351. br.Msg = "参数错误"
  1352. br.ErrMsg = "参数错误"
  1353. return
  1354. }
  1355. resp := new(models.ResearchSummaryLetailResp)
  1356. //判断用户权限
  1357. hasPermission, err := services.GetUserhasPermission(user)
  1358. if err != nil {
  1359. br.Msg = "获取信息失败"
  1360. br.ErrMsg = "获取用户权限信息失败,Err:" + err.Error()
  1361. }
  1362. resp.HasPermission = hasPermission
  1363. if hasPermission != 1 {
  1364. br.Ret = 200
  1365. br.Success = true
  1366. br.Msg = "获取成功"
  1367. br.Data = resp
  1368. return
  1369. }
  1370. detail, err := models.GetCygxResearchSummaryInfoById(articleId)
  1371. if err != nil {
  1372. br.Msg = "获取信息失败"
  1373. br.ErrMsg = "报告不存在,Err:" + err.Error() + "articleId:" + strconv.Itoa(articleId)
  1374. return
  1375. }
  1376. detail.PublishDate = utils.StrTimeToTime(detail.PublishDate).Format(utils.FormatDate)
  1377. detail.VideoPlaySeconds = utils.Mp3Time(detail.VideoPlaySeconds)
  1378. listFirst, err := models.GetResearchSummarylogListFirst(articleId)
  1379. if err != nil {
  1380. br.Msg = "获取失败"
  1381. br.ErrMsg = "获取子类信息失败,Err:" + err.Error()
  1382. return
  1383. }
  1384. listArticleType, err := models.GetCygxArticleTypeList()
  1385. if err != nil {
  1386. br.Msg = "获取失败"
  1387. br.ErrMsg = "获取文章类型数据失败,Err:" + err.Error()
  1388. return
  1389. }
  1390. for k, v := range listFirst {
  1391. listSecond, err := models.GetResearchSummarylogSonListSecond(articleId, v.Type)
  1392. if err != nil && err.Error() != utils.ErrNoRow() {
  1393. br.Msg = "获取信息失败"
  1394. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  1395. return
  1396. }
  1397. for k2, v2 := range listSecond {
  1398. listThird, err := models.GetResearchSummarylogSonListThird(articleId, v2.ChartPermissionId, v.Type)
  1399. if err != nil && err.Error() != utils.ErrNoRow() {
  1400. br.Msg = "获取信息失败"
  1401. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  1402. return
  1403. }
  1404. for _, vType := range listArticleType {
  1405. if v2.ChartPermissionId == vType.YanxPermissionId {
  1406. listSecond[k2].IcoLink = vType.IcoLinkM
  1407. listSecond[k2].PermissionName = vType.YanxPermissionName
  1408. }
  1409. }
  1410. //if v2.ChartPermissionId == utils.YanxSummaryPermissionId {
  1411. // listSecond[k2].IcoLink = "https://hongze.oss-cn-shanghai.aliyuncs.com/static/images/202111/20211104/QbTGTNhD9MxYp24cJ7V5WpCN0oNl.png"
  1412. // listSecond[k2].PermissionName = "买方研选纪要"
  1413. //} else if v2.ChartPermissionId == utils.YanxViewpointPermissionId {
  1414. // listSecond[k2].IcoLink = "https://hongze.oss-cn-shanghai.aliyuncs.com/static/images/202111/20211104/QbTGTNhD9MxYp24cJ7V5WpCN0oNl.png"
  1415. // listSecond[k2].PermissionName = "买方研选观点"
  1416. //}
  1417. if len(listThird) > 0 {
  1418. for k3, v3 := range listThird {
  1419. if v3.VideoUrl != "" {
  1420. listThird[k3].IsHaveVideo = true
  1421. }
  1422. if v3.ReportLink == "0" {
  1423. listThird[k3].ReportLink = ""
  1424. }
  1425. }
  1426. listSecond[k2].List = listThird
  1427. }
  1428. }
  1429. if len(listSecond) > 0 {
  1430. listFirst[k].List = listSecond
  1431. }
  1432. //`description:"类型'SDBG深度报告片篇,’CYDYJY:产业调研纪要’,’SJDP事件点评,’BZCHJH:本周晨会精华’"`
  1433. if v.Type == "SDBG" {
  1434. listFirst[k].ListName = "深度报告"
  1435. listFirst[k].IcoLink = "https://hongze.oss-cn-shanghai.aliyuncs.com/static/images/202110/20211027/le8AcRjDz0MhA72bVDiaf3d5ALSe.png"
  1436. } else if v.Type == "BZCHJH" {
  1437. listFirst[k].ListName = "本周晨会精华"
  1438. listFirst[k].IcoLink = "https://hongze.oss-cn-shanghai.aliyuncs.com/static/images/202110/20211020/DCfekcxaIKGePBsNVu1ULfmNcJBY.png"
  1439. } else if v.Type == "CYDYJY" {
  1440. listFirst[k].ListName = "产业调研纪要"
  1441. listFirst[k].IcoLink = "https://hongze.oss-cn-shanghai.aliyuncs.com/static/images/202110/20211020/UPAdozy96z9ypzY04vi0Y3Ogqzji.png"
  1442. } else if v.Type == "SSGS" {
  1443. listFirst[k].ListName = "上市公司调研纪要篇"
  1444. listFirst[k].IcoLink = "https://hongze.oss-cn-shanghai.aliyuncs.com/static/images/202111/20211101/ujHXB48I8ay9T0XoPRI7lorz7OkL.png"
  1445. } else if v.Type == "SJDP" {
  1446. listFirst[k].ListName = "事件点评"
  1447. listFirst[k].IcoLink = "https://hongze.oss-cn-shanghai.aliyuncs.com/static/images/202110/20211020/2a5cXafO3Iws4QcFp1bd5WPdYikV.png"
  1448. } else if v.Type == "YANX" {
  1449. listFirst[k].ListName = "买方研选"
  1450. listFirst[k].IcoLink = "https://hongze.oss-cn-shanghai.aliyuncs.com/static/images/202111/20211104/QbTGTNhD9MxYp24cJ7V5WpCN0oNl.png"
  1451. }
  1452. }
  1453. historyRecord := new(models.CygxReportHistoryRecord)
  1454. historyRecord.UserId = uid
  1455. historyRecord.ArticleId = articleId
  1456. historyRecord.CreateTime = time.Now()
  1457. historyRecord.Mobile = user.Mobile
  1458. historyRecord.Email = user.Email
  1459. historyRecord.CompanyId = user.CompanyId
  1460. historyRecord.CompanyName = user.CompanyName
  1461. historyRecord.ReportType = "bzyjhz"
  1462. sellerItem, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  1463. if err != nil && err.Error() != utils.ErrNoRow() {
  1464. br.Msg = "获取信息失败"
  1465. br.ErrMsg = "获取销售信息失败,Err:" + err.Error()
  1466. return
  1467. }
  1468. historyRecord.RealName = user.RealName
  1469. if sellerItem != nil {
  1470. historyRecord.SellerName = sellerItem.RealName
  1471. }
  1472. go models.AddCygxReportHistoryRecord(historyRecord)
  1473. resp.List = listFirst
  1474. resp.Detail = detail
  1475. br.Ret = 200
  1476. br.Success = true
  1477. br.Msg = "获取成功"
  1478. br.Data = resp
  1479. }
  1480. // @Title 上周纪要汇总内容详情
  1481. // @Description 获取上周纪要汇总内容详情接口
  1482. // @Param ArticleId query int true "报告ID"
  1483. // @Success 200 {object} models.MinutesSummaryLetailResp
  1484. // @router /minutesSummary/detailv4 [get]
  1485. func (this *ReportController) MinutesDetailV4() {
  1486. br := new(models.BaseResponse).Init()
  1487. defer func() {
  1488. this.Data["json"] = br
  1489. this.ServeJSON()
  1490. }()
  1491. user := this.User
  1492. if user == nil {
  1493. br.Msg = "请重新登录"
  1494. br.Ret = 408
  1495. return
  1496. }
  1497. uid := user.UserId
  1498. articleId, _ := this.GetInt("ArticleId")
  1499. if articleId < 0 {
  1500. br.Msg = "参数错误"
  1501. br.ErrMsg = "参数错误"
  1502. return
  1503. }
  1504. resp := new(models.MinutesSummaryLetailRespV4)
  1505. //判断用户权限
  1506. hasPermission, err := services.GetUserhasPermission(user)
  1507. if err != nil {
  1508. br.Msg = "获取信息失败"
  1509. br.ErrMsg = "获取用户权限信息失败,Err:" + err.Error()
  1510. }
  1511. resp.HasPermission = hasPermission
  1512. if hasPermission != 1 {
  1513. br.Ret = 200
  1514. br.Success = true
  1515. br.Msg = "获取成功"
  1516. br.Data = resp
  1517. return
  1518. }
  1519. detail, err := models.GetCygxMinutesSummaryInfoById(articleId)
  1520. if err != nil {
  1521. br.Msg = "获取信息失败"
  1522. br.ErrMsg = "报告不存在,Err:" + err.Error() + "articleId:" + strconv.Itoa(articleId)
  1523. return
  1524. }
  1525. detail.PublishDate = utils.StrTimeToTime(detail.PublishDate).Format(utils.FormatDate)
  1526. detail.VideoPlaySeconds = utils.Mp3Time(detail.VideoPlaySeconds)
  1527. listFirst, err := models.GetMinutesSummarylogListAllV4(articleId)
  1528. if err != nil {
  1529. br.Msg = "获取失败"
  1530. br.ErrMsg = "获取子类信息失败,Err:" + err.Error()
  1531. return
  1532. }
  1533. for k, v := range listFirst {
  1534. listSecond, err := models.GetMinutesSummarylogSonListSecond(articleId, v.Type)
  1535. if err != nil && err.Error() != utils.ErrNoRow() {
  1536. br.Msg = "获取信息失败"
  1537. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  1538. return
  1539. }
  1540. for k2, v2 := range listSecond {
  1541. listThird, err := models.GetMinutesSummarylogListThird(articleId, v2.ChartPermissionId, v.Type)
  1542. if err != nil && err.Error() != utils.ErrNoRow() {
  1543. br.Msg = "获取信息失败"
  1544. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  1545. return
  1546. }
  1547. if len(listThird) > 0 {
  1548. for k3, v3 := range listThird {
  1549. if v3.VideoUrl != "" {
  1550. listThird[k3].IsHaveVideo = true
  1551. }
  1552. if v3.ReportLink == "0" {
  1553. listThird[k3].ReportLink = ""
  1554. }
  1555. }
  1556. listSecond[k2].List = listThird
  1557. }
  1558. }
  1559. if len(listSecond) > 0 {
  1560. listFirst[k].List = listSecond
  1561. }
  1562. //`description:"类型'SDBG深度报告片篇,’CYDYJY:产业调研纪要’,’SJDP事件点评,’BZCHJH:本周晨会精华’"`
  1563. if v.Type == "CYDYJY" {
  1564. listFirst[k].ListName = "产业调研纪要"
  1565. listFirst[k].IcoLink = "https://hongze.oss-cn-shanghai.aliyuncs.com/static/images/202110/20211020/UPAdozy96z9ypzY04vi0Y3Ogqzji.png"
  1566. } else if v.Type == "SSGS" {
  1567. listFirst[k].ListName = "上市公司调研纪要篇"
  1568. listFirst[k].IcoLink = "https://hongze.oss-cn-shanghai.aliyuncs.com/static/images/202111/20211101/ujHXB48I8ay9T0XoPRI7lorz7OkL.png"
  1569. } else if v.Type == "YANX" {
  1570. listFirst[k].ListName = "买方研选纪要"
  1571. listFirst[k].IcoLink = "https://hongze.oss-cn-shanghai.aliyuncs.com/static/images/202111/20211104/QbTGTNhD9MxYp24cJ7V5WpCN0oNl.png"
  1572. }
  1573. }
  1574. historyRecord := new(models.CygxReportHistoryRecord)
  1575. historyRecord.UserId = uid
  1576. historyRecord.ArticleId = articleId
  1577. historyRecord.CreateTime = time.Now()
  1578. historyRecord.Mobile = user.Mobile
  1579. historyRecord.Email = user.Email
  1580. historyRecord.CompanyId = user.CompanyId
  1581. historyRecord.CompanyName = user.CompanyName
  1582. historyRecord.ReportType = "szjyhz"
  1583. sellerItem, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  1584. if err != nil && err.Error() != utils.ErrNoRow() {
  1585. br.Msg = "获取信息失败"
  1586. br.ErrMsg = "获取销售信息失败,Err:" + err.Error()
  1587. return
  1588. }
  1589. historyRecord.RealName = user.RealName
  1590. if sellerItem != nil {
  1591. historyRecord.SellerName = sellerItem.RealName
  1592. }
  1593. go models.AddCygxReportHistoryRecord(historyRecord)
  1594. resp.List = listFirst
  1595. resp.Detail = detail
  1596. br.Ret = 200
  1597. br.Success = true
  1598. br.Msg = "获取成功"
  1599. br.Data = resp
  1600. }
  1601. // @Title 上周纪要汇总内容详情
  1602. // @Description 获取上周纪要汇总内容详情接口
  1603. // @Param ArticleId query int true "报告ID"
  1604. // @Success 200 {object} models.MinutesSummaryLetailResp
  1605. // @router /minutesSummary/detail [get]
  1606. func (this *ReportController) MinutesDetail() {
  1607. br := new(models.BaseResponse).Init()
  1608. defer func() {
  1609. this.Data["json"] = br
  1610. this.ServeJSON()
  1611. }()
  1612. user := this.User
  1613. if user == nil {
  1614. br.Msg = "请重新登录"
  1615. br.Ret = 408
  1616. return
  1617. }
  1618. uid := user.UserId
  1619. articleId, _ := this.GetInt("ArticleId")
  1620. if articleId < 0 {
  1621. br.Msg = "参数错误"
  1622. br.ErrMsg = "参数错误"
  1623. return
  1624. }
  1625. resp := new(models.MinutesSummaryLetailResp)
  1626. //判断用户权限
  1627. hasPermission, err := services.GetUserhasPermission(user)
  1628. if err != nil {
  1629. br.Msg = "获取信息失败"
  1630. br.ErrMsg = "获取用户权限信息失败,Err:" + err.Error()
  1631. }
  1632. resp.HasPermission = hasPermission
  1633. if hasPermission != 1 {
  1634. br.Ret = 200
  1635. br.Success = true
  1636. br.Msg = "获取成功"
  1637. br.Data = resp
  1638. return
  1639. }
  1640. detail, err := models.GetCygxMinutesSummaryInfoById(articleId)
  1641. if err != nil {
  1642. br.Msg = "获取信息失败"
  1643. br.ErrMsg = "报告不存在,Err:" + err.Error() + "articleId:" + strconv.Itoa(articleId)
  1644. return
  1645. }
  1646. detail.PublishDate = utils.StrTimeToTime(detail.PublishDate).Format("2006-01-02")
  1647. detail.VideoPlaySeconds = utils.Mp3Time(detail.VideoPlaySeconds)
  1648. listLog, err := models.GetMinutesSummarylogListAll(articleId)
  1649. if err != nil {
  1650. br.Msg = "获取失败"
  1651. br.ErrMsg = "获取子类信息失败,Err:" + err.Error()
  1652. return
  1653. }
  1654. for k, v := range listLog {
  1655. listSonLog, err := models.GetMinutesSummarylogSonListAll(articleId, v.ChartPermissionId)
  1656. if err != nil && err.Error() != utils.ErrNoRow() {
  1657. br.Msg = "获取信息失败"
  1658. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  1659. return
  1660. }
  1661. if len(listSonLog) > 0 {
  1662. listLog[k].List = listSonLog
  1663. for k2, v2 := range listSonLog {
  1664. if v2.ReportLink == "0" {
  1665. listSonLog[k2].ReportLink = ""
  1666. }
  1667. }
  1668. }
  1669. }
  1670. historyRecord := new(models.CygxReportHistoryRecord)
  1671. historyRecord.UserId = uid
  1672. historyRecord.ArticleId = articleId
  1673. historyRecord.CreateTime = time.Now()
  1674. historyRecord.Mobile = user.Mobile
  1675. historyRecord.Email = user.Email
  1676. historyRecord.CompanyId = user.CompanyId
  1677. historyRecord.CompanyName = user.CompanyName
  1678. historyRecord.ReportType = "szjyhz"
  1679. sellerItem, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  1680. if err != nil && err.Error() != utils.ErrNoRow() {
  1681. br.Msg = "获取信息失败"
  1682. br.ErrMsg = "获取销售信息失败,Err:" + err.Error()
  1683. return
  1684. }
  1685. historyRecord.RealName = user.RealName
  1686. if sellerItem != nil {
  1687. historyRecord.SellerName = sellerItem.RealName
  1688. }
  1689. go models.AddCygxReportHistoryRecord(historyRecord)
  1690. resp.List = listLog
  1691. resp.Detail = detail
  1692. br.Ret = 200
  1693. br.Success = true
  1694. br.Msg = "获取成功"
  1695. br.Data = resp
  1696. }
  1697. // @Title 获取路演精华详情
  1698. // @Description 获取路演精华详情接口
  1699. // @Param ArticleId query int true "报告ID"
  1700. // @Success 200 {object} models.RoadshowDetailResp
  1701. // @router /roadshowEssence/detail [get]
  1702. func (this *ReportController) RoadshowDetail() {
  1703. br := new(models.BaseResponse).Init()
  1704. defer func() {
  1705. this.Data["json"] = br
  1706. this.ServeJSON()
  1707. }()
  1708. user := this.User
  1709. if user == nil {
  1710. br.Msg = "请登录"
  1711. br.ErrMsg = "请登录,用户信息为空"
  1712. br.Ret = 408
  1713. return
  1714. }
  1715. uid := user.UserId
  1716. articleId, err := this.GetInt("ArticleId")
  1717. if articleId <= 0 {
  1718. br.Msg = "文章不存在"
  1719. br.ErrMsg = "文章不存在,文章ID错误"
  1720. return
  1721. }
  1722. detail := new(models.ReportDetailRoadshow)
  1723. hasPermission := 0
  1724. hasFree := 0
  1725. //判断是否已经申请过
  1726. applyCount, err := models.GetApplyRecordCount(uid)
  1727. if err != nil && err.Error() != utils.ErrNoRow() {
  1728. br.Msg = "获取信息失败"
  1729. br.ErrMsg = "判断是否已申请过试用失败,Err:" + err.Error()
  1730. return
  1731. }
  1732. //`description:"1:有该行业权限,正常展示,2:无该行业权限,不存在权益客户下,3:无该品类权限,4:潜在客户,未提交过申请,5:潜在客户,已提交过申请"`
  1733. if user.CompanyId > 1 {
  1734. companyPermission, err := models.GetCompanyPermission(user.CompanyId)
  1735. if err != nil {
  1736. br.Msg = "获取信息失败"
  1737. br.ErrMsg = "判断是否已申请访谈失败,Err:" + strconv.Itoa(uid) + ";articleId" + strconv.Itoa(articleId)
  1738. return
  1739. }
  1740. detail, err = models.GetReportRoadshowDetailById(articleId)
  1741. if err != nil {
  1742. br.Msg = "获取信息失败"
  1743. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  1744. return
  1745. }
  1746. detail.Body = html.UnescapeString(detail.Body)
  1747. detail.Abstract, _ = services.GetReportContentTextSubNew(detail.Abstract)
  1748. detail.PublishDate = utils.StrTimeToTime(detail.PublishDate).Format("2006-01-02")
  1749. detail.VideoPlaySeconds = utils.Mp3Time(detail.VideoPlaySeconds)
  1750. if detail.ReportLink == "0" {
  1751. detail.ReportLink = ""
  1752. }
  1753. if companyPermission == "" {
  1754. if applyCount > 0 {
  1755. hasPermission = 5
  1756. } else {
  1757. hasPermission = 2
  1758. }
  1759. hasFree = 2
  1760. goto Loop
  1761. } else {
  1762. hasFree = 1
  1763. var articlePermissionPermissionName string
  1764. articlePermissionPermissionName = detail.CategoryName
  1765. var hasPersion bool
  1766. slice := strings.Split(articlePermissionPermissionName, ",")
  1767. for _, v := range slice {
  1768. if strings.Contains(companyPermission, v) {
  1769. hasPersion = true
  1770. }
  1771. }
  1772. if hasPersion {
  1773. hasPermission = 1
  1774. historyRecord := new(models.CygxArticleHistoryRecord)
  1775. historyRecord.UserId = uid
  1776. historyRecord.ArticleId = articleId
  1777. historyRecord.CreateTime = time.Now()
  1778. historyRecord.Mobile = user.Mobile
  1779. historyRecord.Email = user.Email
  1780. historyRecord.CompanyId = user.CompanyId
  1781. historyRecord.CompanyName = user.CompanyName
  1782. go models.AddCygxArticleHistoryRecord(historyRecord)
  1783. } else { //无该行业权限
  1784. hasPermission = 3
  1785. }
  1786. if hasPermission == 1 {
  1787. key := "CYGX_ARTICLE_" + strconv.Itoa(articleId) + "_" + strconv.Itoa(uid)
  1788. if !utils.Rc.IsExist(key) {
  1789. //新增浏览记录
  1790. record := new(models.CygxArticleViewRecord)
  1791. record.UserId = uid
  1792. record.ArticleId = articleId
  1793. record.CreateTime = time.Now()
  1794. record.Mobile = user.Mobile
  1795. record.Email = user.Email
  1796. record.CompanyId = user.CompanyId
  1797. record.CompanyName = user.CompanyName
  1798. go models.AddCygxArticleViewRecord(record)
  1799. utils.Rc.Put(key, 1, 5*time.Second)
  1800. models.ModifyReportLastViewTime(uid)
  1801. }
  1802. }
  1803. }
  1804. } else { //潜在客户
  1805. if applyCount > 0 {
  1806. hasPermission = 5
  1807. } else {
  1808. hasPermission = 4
  1809. }
  1810. }
  1811. Loop:
  1812. if hasPermission != 1 {
  1813. detail.Body = ""
  1814. detail.Abstract = ""
  1815. }
  1816. resp := new(models.RoadshowDetailResp)
  1817. resp.HasPermission = hasPermission
  1818. resp.HasFree = hasFree
  1819. resp.Detail = detail
  1820. br.Ret = 200
  1821. br.Success = true
  1822. br.Msg = "获取成功"
  1823. br.Data = resp
  1824. }
  1825. // @Title 产业文章列表接口
  1826. // @Description 获取产业文章列表接口
  1827. // @Param KeyWord query string true "搜索关键词"
  1828. // @Success 200 {object} models.CygxIndustrySearchList
  1829. // @router /industryAndArticle/list [get]
  1830. func (this *ReportController) IndustryAndArticleList() {
  1831. br := new(models.BaseResponse).Init()
  1832. defer func() {
  1833. this.Data["json"] = br
  1834. this.ServeJSON()
  1835. }()
  1836. user := this.User
  1837. if user == nil {
  1838. br.Msg = "请重新登录"
  1839. br.Ret = 408
  1840. return
  1841. }
  1842. uid := user.UserId
  1843. keyWord := this.GetString("KeyWord")
  1844. orderSrt := "update_time DESC"
  1845. condition := ` AND subject_names LIKE '%` + keyWord + `%'`
  1846. list, err := models.GetIndustrialManagementAll(uid, condition, orderSrt, 0, 100)
  1847. if err != nil {
  1848. br.Msg = "获取信息失败"
  1849. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  1850. return
  1851. }
  1852. for k, v := range list {
  1853. industrialSubjectList, err := models.GetIndustrialSubjectAll(v.IndustrialManagementId)
  1854. if err != nil {
  1855. br.Msg = "获取信息失败"
  1856. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  1857. return
  1858. }
  1859. list[k].IndustrialSubjectList = industrialSubjectList
  1860. //list[k].LayoutTime = utils.TimeRemoveHms(v.LayoutTime)
  1861. newArtinfo, err := models.GetIndustrialNewArticleDetail(v.IndustrialManagementId)
  1862. if err != nil {
  1863. br.Msg = "获取信息失败"
  1864. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  1865. return
  1866. }
  1867. list[k].UpdateTime = utils.TimeRemoveHms(newArtinfo.PublishDate)
  1868. }
  1869. artList, err := models.GetCygxIndustryAndArticleList(keyWord)
  1870. if err != nil {
  1871. br.Msg = "获取失败"
  1872. br.ErrMsg = "获取失败,Err:" + err.Error()
  1873. return
  1874. }
  1875. for k2, v2 := range artList {
  1876. subjectNames, err := models.GetSubjectNames(v2.ArticleId)
  1877. if err != nil {
  1878. br.Msg = "获取失败" + strconv.Itoa(v2.ArticleId)
  1879. br.ErrMsg = "获取失败,Err:" + err.Error()
  1880. return
  1881. }
  1882. var subjectNamesNew string
  1883. if len(subjectNames) > 0 {
  1884. slice := strings.Split(subjectNames, "/")
  1885. for k3, v3 := range slice {
  1886. if k3 < 4 {
  1887. subjectNamesNew += v3 + "/"
  1888. }
  1889. }
  1890. }
  1891. industryName, err := models.GetIndustrialNames(v2.ArticleId)
  1892. if err != nil && err.Error() != utils.ErrNoRow() {
  1893. br.Msg = "获取失败" + strconv.Itoa(v2.ArticleId)
  1894. br.ErrMsg = "获取失败,Err:" + err.Error()
  1895. return
  1896. }
  1897. subjectNamesNew = strings.TrimRight(subjectNamesNew, "/")
  1898. artList[k2].SubjectName = subjectNamesNew
  1899. if subjectNamesNew == "" {
  1900. artList[k2].IndustryName = industryName
  1901. } else {
  1902. artList[k2].IndustryName = industryName + "-" + subjectNamesNew
  1903. }
  1904. }
  1905. if keyWord != "" {
  1906. keyWordItem := new(models.CygxUserSearchKeyWord)
  1907. keyWordItem.UserId = user.UserId
  1908. keyWordItem.KeyWord = keyWord
  1909. keyWordItem.PageType = "ReortSearch"
  1910. keyWordItem.CreateTime = time.Now()
  1911. go models.AddUserSearchKeyWord(keyWordItem)
  1912. }
  1913. resp := new(models.CygxIndustrySearchList)
  1914. resp.ArtList = artList
  1915. resp.IndList = list
  1916. br.Ret = 200
  1917. br.Success = true
  1918. br.Msg = "获取成功"
  1919. br.Data = resp
  1920. }
  1921. // @Title 产业报告分类关联作者列表接口Pc端
  1922. // @Description 获取产业报告分类关联作者列表接口Pc端
  1923. // @Param ChartPermissionId query int true "分类ID"
  1924. // @Param KeyWord query string true "搜索关键词"
  1925. // @Param PageSize query int true "每页数据条数"
  1926. // @Param CurrentIndex query int true "当前页页码,从1开始"
  1927. // @Success 200 {object} models.CygxArticleDepartmentListPc
  1928. // @router /industryListByDepartmentPc [get]
  1929. func (this *ReportController) IndustryListByDepartmentPc() {
  1930. br := new(models.BaseResponse).Init()
  1931. defer func() {
  1932. this.Data["json"] = br
  1933. this.ServeJSON()
  1934. }()
  1935. user := this.User
  1936. if user == nil {
  1937. br.Msg = "请重新登录"
  1938. br.Ret = 408
  1939. return
  1940. }
  1941. uid := user.UserId
  1942. pageSize, _ := this.GetInt("PageSize")
  1943. currentIndex, _ := this.GetInt("CurrentIndex")
  1944. chartPermissionId, _ := this.GetInt("ChartPermissionId")
  1945. keyWord := this.GetString("KeyWord")
  1946. var startSize int
  1947. var condition string
  1948. condition = ` AND a.publish_status=1 AND m.chart_permission_id =` + strconv.Itoa(chartPermissionId)
  1949. if pageSize <= 0 {
  1950. pageSize = utils.PageSize20
  1951. }
  1952. if currentIndex <= 0 {
  1953. currentIndex = 1
  1954. }
  1955. var articleIdGroup string
  1956. if keyWord != "" {
  1957. //获取标的关联的文章ID
  1958. articleIdSub, err := models.GetArticleIdSubjectGroup(keyWord)
  1959. if err != nil {
  1960. br.Msg = "获取信息失败"
  1961. br.ErrMsg = "获取标的信息失败,Err:" + err.Error()
  1962. return
  1963. }
  1964. //获取产业关联的标的
  1965. articleIdInd, err := models.GetArticleIndustrialIdGroup(keyWord)
  1966. if err != nil {
  1967. br.Msg = "获取信息失败"
  1968. br.ErrMsg = "获取产业信息失败,Err:" + err.Error()
  1969. return
  1970. }
  1971. if articleIdSub != "" && articleIdInd != "" {
  1972. articleIdGroup = articleIdSub + "," + articleIdInd
  1973. } else if articleIdSub != "" && articleIdInd == "" {
  1974. articleIdGroup = articleIdSub
  1975. } else if articleIdSub == "" && articleIdInd != "" {
  1976. articleIdGroup = articleIdInd
  1977. }
  1978. slice := strings.Split(keyWord, "/")
  1979. if len(slice) > 1 {
  1980. var subjectIds string
  1981. for _, v := range slice {
  1982. subjectId, err := models.GetcygxIndustrialSubjectByName(v)
  1983. if err != nil && err.Error() != utils.ErrNoRow() {
  1984. br.Msg = "获取信息失败"
  1985. br.ErrMsg = "获取客户信息失败,Err:" + err.Error()
  1986. return
  1987. }
  1988. if subjectId != "" {
  1989. subjectIds += subjectId + ","
  1990. }
  1991. }
  1992. subjectIds = strings.TrimRight(subjectIds, ",")
  1993. if len(subjectIds) > 0 {
  1994. articleBySub, err := models.GetArticleIdsBySubId(subjectIds)
  1995. if err != nil {
  1996. br.Msg = "获取信息失败"
  1997. br.ErrMsg = "获取文章关联的标的失败,Err:" + err.Error()
  1998. return
  1999. }
  2000. if articleIdGroup != "" {
  2001. if articleBySub != "" {
  2002. articleIdGroup += "," + articleBySub
  2003. }
  2004. } else {
  2005. articleIdGroup = articleBySub
  2006. }
  2007. }
  2008. }
  2009. }
  2010. if articleIdGroup != "" {
  2011. condition += ` AND a.article_id IN (` + articleIdGroup + `)`
  2012. }
  2013. startSize = paging.StartIndex(currentIndex, pageSize)
  2014. total, err := models.GetArticleDepartmentCount(condition)
  2015. page := paging.GetPaging(currentIndex, pageSize, total)
  2016. resp := new(models.CygxArticleDepartmentListPc)
  2017. userType, _, err := services.GetUserType(user.CompanyId)
  2018. if err != nil {
  2019. br.Msg = "获取信息失败"
  2020. br.ErrMsg = "获取用户信息失败,Err:" + err.Error()
  2021. return
  2022. }
  2023. if userType == 1 {
  2024. resp.Paging = page
  2025. br.Ret = 200
  2026. br.Success = true
  2027. br.Msg = "获取成功"
  2028. br.Data = resp
  2029. return
  2030. }
  2031. resp.HaveResearch = true
  2032. //获取作者信息,并排序
  2033. list, err := models.GetCygxArticleDepartmentListPc(startSize, pageSize, condition, uid)
  2034. if err != nil {
  2035. br.Msg = "获取信息失败"
  2036. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  2037. return
  2038. }
  2039. for k, v := range list {
  2040. artList, err := models.GetArticleByDepartmentIdPc(v.DepartmentId, articleIdGroup)
  2041. if err != nil {
  2042. br.Msg = "获取信息失败"
  2043. br.ErrMsg = "获取文章信息失败,Err:" + err.Error()
  2044. return
  2045. }
  2046. for k2, v2 := range artList {
  2047. if artList[k2].IsReport == "1" {
  2048. artList[k2].Title = v2.Title
  2049. } else {
  2050. artList[k2].Title = v2.Title
  2051. }
  2052. artList[k2].IndustryName = strings.Replace(artList[k2].IndustryName, " ", "", -1)
  2053. }
  2054. list[k].List = artList
  2055. if v.FollowNum > 0 {
  2056. list[k].IsMyFollow = true
  2057. }
  2058. }
  2059. listnNew, err := models.GetIndustrialSubjectByDepartmentNew()
  2060. if err != nil {
  2061. br.Msg = "获取信息失败"
  2062. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  2063. return
  2064. }
  2065. if len(listnNew) > 0 {
  2066. for _, v := range listnNew {
  2067. firstStr := strings.Index(v.IndustrialAndSubjectIds, "—")
  2068. Management := new(models.IndustrialManagementIdInt)
  2069. if firstStr == 0 {
  2070. Management.IndustryName = v.IndustryName
  2071. } else {
  2072. listSub, err := models.GetIndustrialManagementSubjectList(v.ArticleId)
  2073. if err != nil {
  2074. br.Msg = "获取信息失败"
  2075. br.ErrMsg = "获取关联标的列表失败,Err:" + err.Error()
  2076. return
  2077. }
  2078. var subjectNamesNew string
  2079. for _, v1 := range listSub {
  2080. subjectNamesNew += v1.SubjectName + "/"
  2081. }
  2082. subjectNamesNew = strings.TrimRight(subjectNamesNew, "/")
  2083. Management.IndustryName = subjectNamesNew
  2084. }
  2085. Management.IndustrialManagementId = v.IndustrialManagementId
  2086. Management.ArticleId = v.ArticleId
  2087. resp.ListnNew = append(resp.ListnNew, Management)
  2088. }
  2089. }
  2090. resp.List = list
  2091. resp.Paging = page
  2092. br.Ret = 200
  2093. br.Success = true
  2094. br.Msg = "获取成功"
  2095. br.Data = resp
  2096. }
  2097. // @Title 产业文章列表接口Pc端
  2098. // @Description 获取产业文章列表接口Pc端
  2099. // @Param KeyWord query string true "搜索关键词"
  2100. // @Success 200 {object} models.CygxIndustrySearchListPc
  2101. // @router /industryAndArticle/listPc [get]
  2102. func (this *ReportController) IndustryAndArticleListPc() {
  2103. br := new(models.BaseResponse).Init()
  2104. defer func() {
  2105. this.Data["json"] = br
  2106. this.ServeJSON()
  2107. }()
  2108. user := this.User
  2109. if user == nil {
  2110. br.Msg = "请重新登录"
  2111. br.Ret = 408
  2112. return
  2113. }
  2114. uid := user.UserId
  2115. keyWord := this.GetString("KeyWord")
  2116. resp := new(models.CygxIndustrySearchListPc)
  2117. orderSrt := "update_time DESC"
  2118. condition := ` AND subject_names LIKE '%` + keyWord + `%'`
  2119. list, err := models.GetIndustrialManagementAll(uid, condition, orderSrt, 0, 100)
  2120. if err != nil {
  2121. br.Msg = "获取信息失败"
  2122. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  2123. return
  2124. }
  2125. for k, v := range list {
  2126. industrialSubjectList, err := models.GetIndustrialSubjectAll(v.IndustrialManagementId)
  2127. if err != nil {
  2128. br.Msg = "获取信息失败"
  2129. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  2130. return
  2131. }
  2132. list[k].IndustrialSubjectList = industrialSubjectList
  2133. //list[k].LayoutTime = utils.TimeRemoveHms(v.LayoutTime)
  2134. newArtinfo, err := models.GetIndustrialNewArticleDetail(v.IndustrialManagementId)
  2135. if err != nil {
  2136. br.Msg = "获取信息失败"
  2137. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  2138. return
  2139. }
  2140. list[k].UpdateTime = utils.TimeRemoveHms(newArtinfo.PublishDate)
  2141. }
  2142. artList, err := models.GetCygxIndustryAndArticleList(keyWord)
  2143. if err != nil {
  2144. br.Msg = "获取失败"
  2145. br.ErrMsg = "获取失败,Err:" + err.Error()
  2146. return
  2147. }
  2148. if len(artList) > 0 {
  2149. var articleIds string
  2150. for _, v := range artList {
  2151. articleIds += strconv.Itoa(v.ArticleId) + ","
  2152. }
  2153. articleIds = strings.TrimRight(articleIds, ",")
  2154. if articleIds != "" {
  2155. condition = ` AND a.article_id IN (` + articleIds + `)`
  2156. DepartmentList, err := models.GetCygxArticleDepartmentListPc(0, 20, condition, uid)
  2157. if err != nil {
  2158. br.Msg = "获取信息失败"
  2159. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  2160. return
  2161. }
  2162. for k, v := range DepartmentList {
  2163. artList, err := models.GetArticleByDepartmentIdPc(v.DepartmentId, articleIds)
  2164. if err != nil {
  2165. br.Msg = "获取信息失败"
  2166. br.ErrMsg = "获取文章信息失败,Err:" + err.Error()
  2167. return
  2168. }
  2169. for k2, v2 := range artList {
  2170. if artList[k2].IsReport == "1" {
  2171. artList[k2].Title = v2.Title
  2172. } else {
  2173. artList[k2].Title = v2.Title
  2174. }
  2175. artList[k2].IndustryName = strings.Replace(artList[k2].IndustryName, " ", "", -1)
  2176. }
  2177. DepartmentList[k].List = artList
  2178. if v.FollowNum > 0 {
  2179. DepartmentList[k].IsMyFollow = true
  2180. }
  2181. }
  2182. resp.DepartmentList = DepartmentList
  2183. }
  2184. }
  2185. if keyWord != "" {
  2186. keyWordItem := new(models.CygxUserSearchKeyWord)
  2187. keyWordItem.UserId = user.UserId
  2188. keyWordItem.KeyWord = keyWord
  2189. keyWordItem.PageType = "ReortSearch"
  2190. keyWordItem.CreateTime = time.Now()
  2191. go models.AddUserSearchKeyWord(keyWordItem)
  2192. }
  2193. resp.IndList = list
  2194. br.Ret = 200
  2195. br.Success = true
  2196. br.Msg = "获取成功"
  2197. br.Data = resp
  2198. }
  2199. // @Title 报告搜索
  2200. // @Description 报告搜索接口
  2201. // @Param KeyWord query string true "搜索关键词"
  2202. // @Success 200 {object} models.ReoprtSearchResp
  2203. // @router /searchReport [get]
  2204. func (this *ReportController) SearchReport() {
  2205. br := new(models.BaseResponse).Init()
  2206. defer func() {
  2207. this.Data["json"] = br
  2208. this.ServeJSON()
  2209. }()
  2210. user := this.User
  2211. if user == nil {
  2212. br.Msg = "请重新登录"
  2213. br.Ret = 408
  2214. return
  2215. }
  2216. keyWord := this.GetString("KeyWord")
  2217. var condition string
  2218. var sqlGroup string
  2219. //匹配报告标题、
  2220. condition = `AND ( a.title LIKE '%` + keyWord + `%' OR a.body LIKE '%` + keyWord + `%') AND a.publish_status = 1 `
  2221. sqlGroup = ` GROUP BY a.article_id ORDER BY a.publish_date DESC `
  2222. //对应产业名称、标的名称。
  2223. //OR a.article_id IN ( SELECT article_id FROM cygx_industrial_article_group_subject WHERE industrial_subject_id IN ( SELECT industrial_subject_id FROM cygx_industrial_subject WHERE subject_name LIKE '%` + keyWord + `%' ) )
  2224. //OR 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_management WHERE industry_name LIKE '%` + keyWord + `%' ) )
  2225. listYx, err := models.GetArticleCollectionList(` AND a.article_id >= 1000000 `+condition+sqlGroup, user.UserId)
  2226. if err != nil {
  2227. br.Msg = "获取信息失败"
  2228. br.ErrMsg = "获取文章列表失败,Err:" + err.Error()
  2229. return
  2230. }
  2231. for k, v := range listYx {
  2232. listYx[k].Source = 2
  2233. if v.MyCollectNum > 0 {
  2234. listYx[k].IsCollect = true
  2235. }
  2236. }
  2237. listHz, err := models.GetReoprtSearchList(` AND a.article_id < 1000000 `+condition+` OR ( article_type = 'lyjh' `+condition+` ) `+sqlGroup, user.UserId)
  2238. if err != nil {
  2239. br.Msg = "获取信息失败"
  2240. br.ErrMsg = "获取文章列表失败,Err:" + err.Error()
  2241. return
  2242. }
  2243. for k, v := range listHz {
  2244. listHz[k].Source = 1
  2245. if v.MyCollectNum > 0 {
  2246. listHz[k].IsCollect = true
  2247. }
  2248. }
  2249. if keyWord != "" {
  2250. keyWordItem := new(models.CygxUserSearchKeyWord)
  2251. keyWordItem.UserId = user.UserId
  2252. keyWordItem.KeyWord = keyWord
  2253. keyWordItem.PageType = "ReortSearch"
  2254. keyWordItem.CreateTime = time.Now()
  2255. go models.AddUserSearchKeyWord(keyWordItem)
  2256. }
  2257. if len(listYx) == 0 {
  2258. listYx = make([]*models.ArticleCollectionResp, 0)
  2259. }
  2260. if len(listHz) == 0 {
  2261. listHz = make([]*models.ArticleCollectionResp, 0)
  2262. }
  2263. resp := new(models.ReoprtSearchResp)
  2264. resp.ListYx = listYx
  2265. resp.ListHz = listHz
  2266. br.Ret = 200
  2267. br.Success = true
  2268. br.Msg = "获取成功"
  2269. br.Data = resp
  2270. }
  2271. // @Title 资源包搜索
  2272. // @Description 资源包搜索接口
  2273. // @Param KeyWord query string true "搜索关键词"
  2274. // @Success 200 {object} models.SearchResourceResp
  2275. // @router /searchResource [get]
  2276. func (this *ReportController) SearchResource() {
  2277. br := new(models.BaseResponse).Init()
  2278. defer func() {
  2279. this.Data["json"] = br
  2280. this.ServeJSON()
  2281. }()
  2282. user := this.User
  2283. if user == nil {
  2284. br.Msg = "请重新登录"
  2285. br.Ret = 408
  2286. return
  2287. }
  2288. uid := user.UserId
  2289. fllowList, err := models.GetUserFllowIndustrialList(uid)
  2290. if err != nil {
  2291. br.Msg = "获取失败"
  2292. br.ErrMsg = "获取失败,GetUserFllowIndustrialList Err:" + err.Error()
  2293. return
  2294. }
  2295. fllowMap := make(map[int]int)
  2296. if len(fllowList) > 0 {
  2297. for _, v := range fllowList {
  2298. fllowMap[v.IndustrialManagementId] = v.IndustrialManagementId
  2299. }
  2300. }
  2301. keyWord := this.GetString("KeyWord")
  2302. var condition string
  2303. var conditionOr string
  2304. //conditionOr = ` OR ( a.title LIKE '%` + keyWord + `%' AND a.article_id < ` + strconv.Itoa(utils.SummaryArticleId) + ` AND publish_status = 1 ) `
  2305. conditionOr += ` OR ( m.subject_names LIKE '%` + keyWord + `%' AND a.article_id < ` + strconv.Itoa(utils.SummaryArticleId) + ` AND publish_status = 1 ) `
  2306. condition = ` AND m.industry_name LIKE '%` + keyWord + `%' AND a.article_id < ` + strconv.Itoa(utils.SummaryArticleId) + conditionOr
  2307. listHz, err := models.GetSearchResourceList(condition)
  2308. if err != nil {
  2309. br.Msg = "获取信息失败"
  2310. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  2311. return
  2312. }
  2313. //conditionOr = ` OR ( a.title LIKE '%` + keyWord + `%' AND a.article_id >= ` + strconv.Itoa(utils.SummaryArticleId) + ` AND publish_status = 1 ) `
  2314. conditionOr = ` OR ( m.subject_names LIKE '%` + keyWord + `%' AND a.article_id >= ` + strconv.Itoa(utils.SummaryArticleId) + ` AND publish_status = 1 ) `
  2315. condition = ` AND m.industry_name LIKE '%` + keyWord + `%' AND a.article_id >= ` + strconv.Itoa(utils.SummaryArticleId) + conditionOr
  2316. listYx, err := models.GetSearchResourceList(condition)
  2317. if err != nil {
  2318. br.Msg = "获取信息失败"
  2319. br.ErrMsg = "获取文章列表失败,Err:" + err.Error()
  2320. return
  2321. }
  2322. //合并产业关联的标的
  2323. listSubjcet, err := models.GetThemeHeatSubjectList("")
  2324. if err != nil {
  2325. br.Msg = "获取信息失败"
  2326. br.ErrMsg = "获取标的信息失败,Err:" + err.Error()
  2327. return
  2328. }
  2329. for k, v := range listHz {
  2330. listHz[k].Source = 1
  2331. for _, v2 := range listSubjcet {
  2332. if v2.IndustrialManagementId == v.IndustrialManagementId {
  2333. listHz[k].IndustrialSubjectList = append(listHz[k].IndustrialSubjectList, v2)
  2334. }
  2335. }
  2336. if fllowMap[v.IndustrialManagementId] > 0 {
  2337. listHz[k].IsFollw = true
  2338. }
  2339. }
  2340. var IndustrialManagementIdStr string
  2341. for k, v := range listYx {
  2342. listYx[k].Source = 2
  2343. IndustrialManagementIdStr += "," + strconv.Itoa(v.IndustrialManagementId)
  2344. if fllowMap[v.IndustrialManagementId] > 0 {
  2345. listYx[k].IsFollw = true
  2346. }
  2347. }
  2348. IndustrialManagementIdStr = strings.TrimLeft(IndustrialManagementIdStr, ",")
  2349. if IndustrialManagementIdStr != "" {
  2350. //合并产业关联的标的
  2351. condition = ` AND mg.article_id IN (SELECT mg.article_id FROM cygx_industrial_article_group_management as mg
  2352. INNER JOIN cygx_article as a ON a.article_id = mg.article_id AND article_type != 'lyjh' WHERE mg.industrial_management_id IN (` + IndustrialManagementIdStr + `) AND mg.article_id >= ` + strconv.Itoa(utils.SummaryArticleId) + ` )`
  2353. listSubjcet, err = models.GetThemeHeatSubjectList(condition)
  2354. if err != nil {
  2355. br.Msg = "获取信息失败"
  2356. br.ErrMsg = "获取标的信息失败,Err:" + err.Error()
  2357. return
  2358. }
  2359. for k, v := range listYx {
  2360. for _, v2 := range listSubjcet {
  2361. if v2.IndustrialManagementId == v.IndustrialManagementId {
  2362. listYx[k].IndustrialSubjectList = append(listYx[k].IndustrialSubjectList, v2)
  2363. }
  2364. }
  2365. }
  2366. }
  2367. if keyWord != "" {
  2368. keyWordItem := new(models.CygxUserSearchKeyWord)
  2369. keyWordItem.UserId = user.UserId
  2370. keyWordItem.KeyWord = keyWord
  2371. keyWordItem.PageType = "ReortSearch"
  2372. keyWordItem.CreateTime = time.Now()
  2373. go models.AddUserSearchKeyWord(keyWordItem)
  2374. }
  2375. resp := new(models.SearchResourceResp)
  2376. if len(listYx) == 0 {
  2377. listYx = make([]*models.IndustrialManagementHotResp, 0)
  2378. }
  2379. if len(listHz) == 0 {
  2380. listHz = make([]*models.IndustrialManagementHotResp, 0)
  2381. }
  2382. resp.ListYx = listYx
  2383. resp.ListHz = listHz
  2384. br.Ret = 200
  2385. br.Success = true
  2386. br.Msg = "获取成功"
  2387. br.Data = resp
  2388. }