report.go 75 KB

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