report_chapter.go 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460
  1. package report
  2. import (
  3. "errors"
  4. "fmt"
  5. report_chapter_type_cache "hongze/hongze_yb/cache/report_chapter_type"
  6. "hongze/hongze_yb/global"
  7. "hongze/hongze_yb/models/response"
  8. "hongze/hongze_yb/models/tables/chart_permission_chapter_mapping"
  9. "hongze/hongze_yb/models/tables/company_product"
  10. "hongze/hongze_yb/models/tables/rddp/classify"
  11. "hongze/hongze_yb/models/tables/rddp/report"
  12. "hongze/hongze_yb/models/tables/rddp/report_chapter"
  13. "hongze/hongze_yb/models/tables/report_chapter_type"
  14. "hongze/hongze_yb/services"
  15. "hongze/hongze_yb/services/collection"
  16. "hongze/hongze_yb/services/company"
  17. "hongze/hongze_yb/services/user"
  18. "hongze/hongze_yb/utils"
  19. "html"
  20. "sort"
  21. "strings"
  22. "time"
  23. )
  24. // GetReportTypeIdsByPermissionIds 获取所有和权限绑定的报告章节ID
  25. func GetReportTypeIdsByPermissionIds(permissionIds []int) (ids []int, err error) {
  26. ids, err = chart_permission_chapter_mapping.GetReportIdsByPermisssionIds(permissionIds, "week")
  27. return
  28. }
  29. // GetLatestWeek 获取有权限的最新的周报
  30. func GetLatestWeek(permissionIds []int, typeIds []int) (reportInfo *report.Report, err error) {
  31. newTypeIds, err := GetWeekTypeIdsByPermissionIds(permissionIds, typeIds)
  32. chapters, err := report_chapter.GetLatestChaptersByTypeIdsAndClass(newTypeIds,"week")
  33. if err != nil {
  34. return
  35. }
  36. var reportIds []int
  37. for _, v := range chapters {
  38. reportIds = append(reportIds, v.ReportId)
  39. }
  40. reportInfo, err = report.GetLatestByReportIds(reportIds)
  41. return
  42. }
  43. // GetWeekTypeIdsByPermissionIds 获取有权限的章节类型ID
  44. func GetWeekTypeIdsByPermissionIds(permissionIds []int, typeIds []int) (newTypeIds []int, err error) {
  45. ids, err := GetReportTypeIdsByPermissionIds(permissionIds)
  46. if err != nil {
  47. return
  48. }
  49. if len(typeIds) == 0 {
  50. typeIds, err = report_chapter_type_cache.GetEffectTypeID()
  51. if err != nil {
  52. return
  53. }
  54. }
  55. for _, v1 := range typeIds {
  56. for _, v2 := range ids {
  57. if v1 == v2 {
  58. newTypeIds = append(newTypeIds, v2)
  59. }
  60. }
  61. }
  62. return
  63. }
  64. // GetChapterListByReport 根据报告获取章节列表
  65. func GetChapterListByReport(classifyNameFirst string, reportId int, validWeekTypeIds []int, reportCreateTime time.Time) (reportTypeList response.ReportChapterList, err error) {
  66. var errMsg string
  67. defer func() {
  68. if err != nil {
  69. global.LOG.Critical(fmt.Sprintf("GetChapterListByReport: err:%s, errMsg:%s", err.Error(), errMsg))
  70. }
  71. }()
  72. //查询有效的章节
  73. typeList, tErr := report_chapter_type.GetEffectTypes()
  74. if tErr != nil {
  75. errMsg = tErr.Error()
  76. err = errors.New("章节类型查询出错")
  77. return
  78. }
  79. if len(typeList) == 0 {
  80. err = errors.New("无有效的章节")
  81. return
  82. }
  83. typeMap := make(map[uint64]*report_chapter_type.ReportChapterType)
  84. var typeIds []int
  85. newTypeMap := make(map[int]bool)
  86. for _, v := range typeList {
  87. typeMap[v.ReportChapterTypeId] = v
  88. typeIds = append(typeIds, int(v.ReportChapterTypeId))
  89. }
  90. if classifyNameFirst == "周报" {
  91. for _, v := range validWeekTypeIds {
  92. newTypeMap[v] = true
  93. }
  94. }
  95. //获取所有当前研报的章节
  96. chapterList, tErr := report_chapter.GetListByReportId(reportId, classifyNameFirst)
  97. if tErr != nil && tErr != utils.ErrNoRow{
  98. errMsg = err.Error()
  99. err = errors.New("章节查询出错")
  100. return
  101. }
  102. if len(chapterList) == 0 {
  103. err = errors.New("无有效章节")
  104. return
  105. }
  106. for _, item := range chapterList {
  107. if typeItem, ok := typeMap[uint64(item.TypeId)]; ok {
  108. // 如果是周报只展示有权限的章节
  109. if classifyNameFirst == "周报" {
  110. if _, ok1 := newTypeMap[item.TypeId]; !ok1 {
  111. continue
  112. }
  113. }
  114. temp := new(response.ReportChapterListItem)
  115. if reportCreateTime.Before(typeItem.PauseStartTime) || reportCreateTime.After(typeItem.PauseEndTime) {
  116. temp.ReportChapterId = item.ReportChapterId
  117. temp.TypeId = item.TypeId
  118. temp.TypeName = item.TypeName
  119. temp.Title = item.Title
  120. temp.Trend = item.Trend
  121. temp.ReportId = item.ReportId
  122. temp.Sort = typeItem.Sort
  123. temp.PublishTime = item.PublishTime
  124. temp.ReportChapterTypeKey = typeItem.ReportChapterTypeKey
  125. temp.ReportChapterTypeName = typeItem.ReportChapterTypeName
  126. temp.ReportChapterTypeThumb = typeItem.YbIconUrl
  127. reportTypeList = append(reportTypeList, temp)
  128. }
  129. }
  130. }
  131. if len(reportTypeList) > 0 {
  132. sort.Sort(reportTypeList)
  133. }
  134. return
  135. }
  136. // GetChapterDetail 获取章节详情
  137. func GetChapterDetail(user user.UserInfo, reportChapterId int) (reportChapterDetail *response.ReportChapterDetail, err error) {
  138. var errMsg string
  139. defer func() {
  140. if err != nil {
  141. global.LOG.Critical(fmt.Sprintf("GetChapterDetail: userId=%d, err:%s, errMsg:%s", user.UserID, err.Error(), errMsg))
  142. }
  143. }()
  144. var authOk bool
  145. var productAuthOk bool
  146. var chapterAuthOk bool
  147. var permissionCheckInfo response.PermissionCheckInfo
  148. // 判断用户状态是否是正常和永续
  149. companyProduct, err := company_product.GetByCompany2ProductId(user.CompanyID, 1)
  150. if err == utils.ErrNoRow {
  151. err = nil
  152. }
  153. if err != nil {
  154. errMsg = err.Error()
  155. err = errors.New("查询用户购买产品出错")
  156. return
  157. }
  158. if companyProduct != nil {
  159. // 无FICC权限的客户不可见
  160. if companyProduct.CompanyProductID > 0 {
  161. // 已购或者试用用户可见
  162. if strings.Contains("永续,正式", companyProduct.Status) || (companyProduct.Status == "试用" && companyProduct.IsSuspend != 1) {
  163. productAuthOk = true
  164. }
  165. }
  166. }
  167. typeIds, err := report_chapter_type_cache.GetEffectTypeID()
  168. if err != nil {
  169. errMsg = err.Error()
  170. err = errors.New("章节类型查询出错")
  171. return
  172. }
  173. if len(typeIds) == 0 {
  174. err = errors.New("无有效的章节类型")
  175. return
  176. }
  177. reportChapter, err := report_chapter.GetContentById(reportChapterId, typeIds)
  178. if err != nil {
  179. errMsg = err.Error()
  180. err = errors.New("章节查询出错")
  181. return
  182. }
  183. if reportChapter.ReportChapterId == 0 {
  184. err = errors.New("章节不存在")
  185. return
  186. }
  187. reportInfo, tErr := report.GetByReportId(reportChapter.ReportId)
  188. if tErr != nil {
  189. errMsg = tErr.Error()
  190. err = errors.New("报告查询出错")
  191. return
  192. }
  193. if reportInfo.Id == 0 {
  194. err = errors.New("报告不存在")
  195. return
  196. }
  197. if reportInfo.ClassifyNameFirst == "周报" && reportChapter.IsEdit != 1 {
  198. err = errors.New("章节未编辑")
  199. return
  200. }
  201. //判断权限
  202. var newTypeIds []int
  203. if reportInfo.ClassifyNameFirst == "晨报"{
  204. authOk, permissionCheckInfo, err = CheckDayReportPermission(user, productAuthOk)
  205. if err != nil && err != utils.ErrNoRow {
  206. errMsg = err.Error()
  207. err = errors.New("权限查询出错")
  208. return
  209. }
  210. }else if reportInfo.ClassifyNameFirst == "周报"{
  211. authOk, permissionCheckInfo, newTypeIds, err = CheckWeekReportPermission(user, productAuthOk)
  212. if err != nil && err != utils.ErrNoRow {
  213. errMsg = err.Error()
  214. err = errors.New("权限查询出错")
  215. return
  216. }
  217. for _, v := range newTypeIds {
  218. if v == reportChapter.TypeId {
  219. chapterAuthOk = true
  220. }
  221. }
  222. authOk = chapterAuthOk
  223. }
  224. var chapterMenu []*response.ReportChapterMenu
  225. reportChapterItem := new(response.ReportChapterItem)
  226. reportChapterItem.ReportChapterId = reportChapter.ReportChapterId
  227. reportChapterItem.ReportId = reportChapter.ReportId
  228. reportChapterItem.Abstract = reportChapter.Abstract
  229. reportChapterItem.TypeId = reportChapter.TypeId
  230. reportChapterItem.Title = reportChapter.Title
  231. reportChapterItem.ReportId = reportChapter.ReportId
  232. reportChapterItem.PublishTime = reportChapter.PublishTime
  233. reportChapterItem.VideoPlaySeconds = reportChapter.VideoPlaySeconds
  234. reportChapterItem.VideoName = reportChapter.VideoName
  235. if reportChapter.VideoUrl != "" && reportChapter.VideoName == "" {
  236. reportChapterItem.VideoName = reportChapter.Title
  237. }
  238. reportChapterItem.VideoSize = reportChapter.VideoSize
  239. videoImgMap := map[string]string{
  240. "day": "report_list_chen.png",
  241. "week": "report_list_zhou.png",
  242. }
  243. reportChapterItem.VideoImg = utils.ALIYUN_YBIMG_HOST + videoImgMap[reportChapter.ReportType]
  244. reportChapterItem.TypeName = reportChapter.TypeName
  245. reportChapterItem.Author = reportChapter.Author
  246. reportChapterItem.Stage = reportChapter.Stage
  247. reportChapterItem.ClassifyNameFirst = reportChapter.ClassifyNameFirst
  248. reportChapterItem.ClassifyIdFirst = reportChapter.ClassifyIdFirst
  249. // 分享背景图
  250. reportChapterItem.ShareBgImg = utils.DEFAULT_REPORT_SHARE_BG_IMG
  251. firstClassify, e := classify.GetByClassifyId(reportInfo.ClassifyIdFirst)
  252. if e != nil {
  253. err = errors.New("报告一级分类有误")
  254. return
  255. }
  256. if firstClassify.YbShareBgImg != "" {
  257. reportChapterItem.ShareBgImg = firstClassify.YbShareBgImg
  258. }
  259. var likeNum int64
  260. var likeEnabled int8
  261. if authOk {
  262. reportChapterItem.Content = html.UnescapeString(reportChapter.Content)
  263. reportChapterItem.VideoUrl = reportChapter.VideoUrl
  264. //底部菜单切换
  265. if reportInfo.ClassifyNameFirst == "周报" {
  266. chapterMenu, err = GetMenuChapter(reportInfo.Id, newTypeIds, reportInfo.ClassifyNameFirst, reportInfo.CreateTime)
  267. }else{
  268. chapterMenu, err = GetMenuChapter(reportInfo.Id, typeIds, reportInfo.ClassifyNameFirst, reportInfo.CreateTime)
  269. }
  270. //查询点赞数
  271. likeNum,likeEnabled, _ = services.GetReportLikeByReportIdOldReportId(user.UserID, reportInfo.Id, reportChapter.ReportChapterId,0,0)
  272. go AddViewRecord(user, reportInfo.Id, reportInfo.ClassifyNameFirst, reportChapterId)
  273. }else{
  274. reportChapterItem.ContentSub = html.UnescapeString(reportChapter.ContentSub)
  275. }
  276. go AddUserAccessRecord(user, reportInfo.Id, reportInfo.ClassifyNameFirst, reportChapterId, authOk)
  277. reportChapterDetail = new(response.ReportChapterDetail)
  278. reportChapterDetail.ReportChapterItem = reportChapterItem
  279. reportChapterDetail.PermissionCheck = &permissionCheckInfo
  280. reportChapterDetail.ReportChapterMenuList = chapterMenu
  281. reportChapterDetail.AuthOk = authOk
  282. reportChapterDetail.LikeNum = likeNum
  283. reportChapterDetail.LikeEnabled = likeEnabled
  284. // 收藏
  285. collectionId, e := collection.GetUserCollectByItem(int(user.UserID), collection.CollectionTypeReport, reportChapterItem.ReportId, reportChapterId)
  286. if e != nil {
  287. err = e
  288. return
  289. }
  290. reportChapterDetail.CollectionId = collectionId
  291. return
  292. }
  293. func GetMenuChapter(reportId int, typeIds []int, classifyNameFirst string, reportCreateTime time.Time) (reportTypeList response.ReportChapterMenuList, err error) {
  294. //查询有效的章节
  295. typeList, tErr := report_chapter_type.GetEffectTypes()
  296. if tErr != nil {
  297. return
  298. }
  299. if len(typeList) == 0 {
  300. err = errors.New("无有效的章节")
  301. return
  302. }
  303. typeMap := make(map[uint64]*report_chapter_type.ReportChapterType)
  304. for _, v := range typeList {
  305. typeMap[v.ReportChapterTypeId] = v
  306. }
  307. //获取所有当前研报的章节
  308. chapterList, tErr := report_chapter.GetListByReportIdTypeIds(reportId, typeIds, classifyNameFirst)
  309. if tErr != nil && tErr != utils.ErrNoRow{
  310. return
  311. }
  312. if len(chapterList) > 0 {
  313. for _, item := range chapterList {
  314. if typeItem, ok := typeMap[uint64(item.TypeId)]; ok {
  315. if reportCreateTime.Before(typeItem.PauseStartTime) || reportCreateTime.After(typeItem.PauseEndTime) {
  316. temp := new(response.ReportChapterMenu)
  317. temp.ReportChapterId = item.ReportChapterId
  318. temp.ReportId = item.ReportId
  319. temp.ReportChapterTypeName = typeItem.ReportChapterTypeName
  320. temp.ReportChapterTypeThumb = typeItem.YbBottomIcon
  321. temp.Sort = typeItem.Sort
  322. temp.PcSelectedThumb = typeItem.PcSelectedImage
  323. temp.PcUnselectedThumb = typeItem.PcUnselectedImage
  324. reportTypeList = append(reportTypeList, temp)
  325. }
  326. }
  327. }
  328. }
  329. if len(reportTypeList) > 0{
  330. sort.Sort(reportTypeList)
  331. }
  332. return
  333. }
  334. // CheckWeekReportPermission 验证周报的权限
  335. func CheckWeekReportPermission(userInfo user.UserInfo, productAuthOk bool) (authOk bool, permissionCheckInfo response.PermissionCheckInfo, validTypeIds []int, err error) {
  336. var permissionIds []int
  337. var validPermissionIds []int //最后允许显示的章节
  338. if productAuthOk {
  339. permissionIds, err = chart_permission_chapter_mapping.GetPermissionIdsByWeek()
  340. if err != nil && err != utils.ErrNoRow {
  341. return
  342. }
  343. }
  344. authOk, permissionCheckInfo, validPermissionIds, err = company.GetCheckPermission(userInfo.CompanyID, int(userInfo.UserID), permissionIds)
  345. if err != nil {
  346. return
  347. }
  348. //返回可用的章节列表
  349. if len(validPermissionIds) > 0 {
  350. validTypeIds, err = chart_permission_chapter_mapping.GetReportIdsByPermisssionIds(validPermissionIds, "week")
  351. }
  352. return
  353. }
  354. // CheckDayReportPermission 验证晨报的权限
  355. func CheckDayReportPermission(userInfo user.UserInfo, productAuthOk bool) (authOk bool, permissionCheckInfo response.PermissionCheckInfo, err error) {
  356. if productAuthOk {
  357. authOk = true
  358. return
  359. }
  360. authOk, permissionCheckInfo,_, err = company.GetCheckPermission(userInfo.CompanyID, int(userInfo.UserID), []int{})
  361. return
  362. }
  363. // GetReportChapterVideoList 根据报告获取章节的音频列表
  364. func GetReportChapterVideoList(permissionIds []int, classifyName string, list []*report.Report) (videoMap map[int][]*response.VideoListItem, weekAuthMap map[int]bool, errMsg string, err error) {
  365. videoMap = make(map[int][]*response.VideoListItem)
  366. weekAuthMap = make(map[int]bool)
  367. var reportIds []int
  368. reportMap := make(map[int]*report.Report)
  369. for _, reportInfo := range list {
  370. reportMap[reportInfo.Id] = reportInfo
  371. reportIds = append(reportIds, reportInfo.Id)
  372. }
  373. // 查询有效的章节
  374. //查询有效的章节
  375. typeList, tErr := report_chapter_type.GetEffectTypes()
  376. if tErr != nil {
  377. errMsg = tErr.Error()
  378. err = errors.New("章节类型查询出错")
  379. return
  380. }
  381. if len(typeList) == 0 {
  382. err = errors.New("无有效的章节")
  383. return
  384. }
  385. typeMap := make(map[int]*report_chapter_type.ReportChapterType)
  386. var typeIds []int
  387. for _, v := range typeList {
  388. typeMap[int(v.ReportChapterTypeId)] = v
  389. typeIds = append(typeIds, int(v.ReportChapterTypeId))
  390. }
  391. var chapters []*report_chapter.ReportChapter
  392. if classifyName == "周报" {
  393. // 查询用户有权限的章节ID
  394. newTypeIds, tErr := GetWeekTypeIdsByPermissionIds(permissionIds, typeIds)
  395. if tErr != nil {
  396. errMsg = tErr.Error()
  397. err = errors.New("查询章节类型权限出错")
  398. return
  399. }
  400. // 查询章节列表
  401. chapters, err = report_chapter.GetByTypeIdsAndReportIds(newTypeIds, reportIds, classifyName)
  402. }else{
  403. // 查询章节列表
  404. chapters, err = report_chapter.GetByTypeIdsAndReportIds(typeIds, reportIds, classifyName)
  405. }
  406. if err != nil {
  407. errMsg = err.Error()
  408. err = errors.New("查询章节出错")
  409. return
  410. }
  411. for _, v := range chapters {
  412. if classifyName == "周报" {
  413. weekAuthMap[v.ReportId] = true
  414. }
  415. if temp, ok := typeMap[v.TypeId]; ok && v.VideoUrl != "" {
  416. if reportDetail, ok1 := reportMap[v.ReportId]; ok1 {
  417. reportDate := reportDetail.CreateTime
  418. if reportDate.Before(temp.PauseStartTime) || reportDate.After(temp.PauseEndTime) {
  419. videoItem := new(response.VideoListItem)
  420. videoItem.VideoPlaySeconds = v.VideoPlaySeconds
  421. videoItem.VideoName = v.VideoName
  422. if v.VideoName == "" {
  423. videoItem.VideoName = v.Title
  424. }
  425. videoItem.VideoUrl = v.VideoUrl
  426. videoItem.Sort = v.Sort
  427. videoMap[v.ReportId] = append(videoMap[v.ReportId], videoItem)
  428. }
  429. }
  430. }
  431. }
  432. return
  433. }