report_chapter.go 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463
  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. temp.VideoUrl = item.VideoUrl
  128. temp.VideoName = item.VideoName
  129. temp.VideoPlaySeconds = item.VideoPlaySeconds
  130. temp.VideoSize = item.VideoSize
  131. reportTypeList = append(reportTypeList, temp)
  132. }
  133. }
  134. }
  135. if len(reportTypeList) > 0 {
  136. sort.Sort(reportTypeList)
  137. }
  138. return
  139. }
  140. // GetChapterDetail 获取章节详情
  141. func GetChapterDetail(user user.UserInfo, reportChapterId int) (reportChapterDetail *response.ReportChapterDetail, err error) {
  142. var errMsg string
  143. defer func() {
  144. if err != nil {
  145. global.LOG.Critical(fmt.Sprintf("GetChapterDetail: userId=%d, err:%s, errMsg:%s", user.UserID, err.Error(), errMsg))
  146. }
  147. }()
  148. var authOk bool
  149. var productAuthOk bool
  150. var chapterAuthOk bool
  151. var permissionCheckInfo response.PermissionCheckInfo
  152. // 判断用户状态是否是正常和永续
  153. companyProduct, err := company_product.GetByCompany2ProductId(user.CompanyID, 1)
  154. if err == utils.ErrNoRow {
  155. err = nil
  156. }
  157. if err != nil {
  158. errMsg = err.Error()
  159. err = errors.New("查询用户购买产品出错")
  160. return
  161. }
  162. if companyProduct != nil {
  163. // 无FICC权限的客户不可见
  164. if companyProduct.CompanyProductID > 0 {
  165. // 已购或者试用用户可见
  166. if strings.Contains("永续,正式", companyProduct.Status) || (companyProduct.Status == "试用" && companyProduct.IsSuspend != 1) {
  167. productAuthOk = true
  168. }
  169. }
  170. }
  171. typeIds, err := report_chapter_type_cache.GetEffectTypeID()
  172. if err != nil {
  173. errMsg = err.Error()
  174. err = errors.New("章节类型查询出错")
  175. return
  176. }
  177. if len(typeIds) == 0 {
  178. err = errors.New("无有效的章节类型")
  179. return
  180. }
  181. reportChapter, err := report_chapter.GetContentById(reportChapterId, typeIds)
  182. if err != nil {
  183. errMsg = err.Error()
  184. err = errors.New("章节查询出错")
  185. return
  186. }
  187. if reportChapter.ReportChapterId == 0 {
  188. err = errors.New("章节不存在")
  189. return
  190. }
  191. reportInfo, tErr := report.GetByReportId(reportChapter.ReportId)
  192. if tErr != nil {
  193. errMsg = tErr.Error()
  194. err = errors.New("报告查询出错")
  195. return
  196. }
  197. if reportInfo.Id == 0 {
  198. err = errors.New("报告不存在")
  199. return
  200. }
  201. if reportInfo.ClassifyNameFirst == "周报" && reportChapter.IsEdit != 1 {
  202. err = errors.New("章节未编辑")
  203. return
  204. }
  205. //判断权限
  206. var newTypeIds []int
  207. if reportInfo.ClassifyNameFirst == "晨报" {
  208. authOk, permissionCheckInfo, err = CheckDayReportPermission(user, productAuthOk)
  209. if err != nil && err != utils.ErrNoRow {
  210. errMsg = err.Error()
  211. err = errors.New("权限查询出错")
  212. return
  213. }
  214. } else if reportInfo.ClassifyNameFirst == "周报" {
  215. authOk, permissionCheckInfo, newTypeIds, err = CheckWeekReportPermission(user, productAuthOk)
  216. if err != nil && err != utils.ErrNoRow {
  217. errMsg = err.Error()
  218. err = errors.New("权限查询出错")
  219. return
  220. }
  221. for _, v := range newTypeIds {
  222. if v == reportChapter.TypeId {
  223. chapterAuthOk = true
  224. }
  225. }
  226. authOk = chapterAuthOk
  227. }
  228. var chapterMenu []*response.ReportChapterMenu
  229. reportChapterItem := new(response.ReportChapterItem)
  230. reportChapterItem.ReportChapterId = reportChapter.ReportChapterId
  231. reportChapterItem.ReportId = reportChapter.ReportId
  232. reportChapterItem.Abstract = reportChapter.Abstract
  233. reportChapterItem.TypeId = reportChapter.TypeId
  234. reportChapterItem.Title = reportChapter.Title
  235. reportChapterItem.ReportId = reportChapter.ReportId
  236. reportChapterItem.PublishTime = reportChapter.PublishTime
  237. reportChapterItem.VideoPlaySeconds = reportChapter.VideoPlaySeconds
  238. reportChapterItem.VideoName = reportChapter.VideoName
  239. if reportChapter.VideoUrl != "" && reportChapter.VideoName == "" {
  240. reportChapterItem.VideoName = reportChapter.Title
  241. }
  242. reportChapterItem.VideoSize = reportChapter.VideoSize
  243. videoImgMap := map[string]string{
  244. "day": "report_list_chen.png",
  245. "week": "report_list_zhou.png",
  246. }
  247. reportChapterItem.VideoImg = utils.ALIYUN_YBIMG_HOST + videoImgMap[reportChapter.ReportType]
  248. reportChapterItem.TypeName = reportChapter.TypeName
  249. reportChapterItem.Author = reportChapter.Author
  250. reportChapterItem.Stage = reportChapter.Stage
  251. reportChapterItem.ClassifyNameFirst = reportChapter.ClassifyNameFirst
  252. reportChapterItem.ClassifyIdFirst = reportChapter.ClassifyIdFirst
  253. // 分享背景图
  254. reportChapterItem.ShareBgImg = utils.DEFAULT_REPORT_SHARE_BG_IMG
  255. firstClassify, e := classify.GetByClassifyId(reportInfo.ClassifyIdFirst)
  256. if e != nil {
  257. err = errors.New("报告一级分类有误")
  258. return
  259. }
  260. if firstClassify.YbShareBgImg != "" {
  261. reportChapterItem.ShareBgImg = firstClassify.YbShareBgImg
  262. }
  263. var likeNum int64
  264. var likeEnabled int8
  265. if authOk {
  266. reportChapterItem.Content = html.UnescapeString(reportChapter.Content)
  267. reportChapterItem.VideoUrl = reportChapter.VideoUrl
  268. //底部菜单切换
  269. if reportInfo.ClassifyNameFirst == "周报" {
  270. chapterMenu, err = GetMenuChapter(reportInfo.Id, newTypeIds, reportInfo.ClassifyNameFirst, reportInfo.CreateTime)
  271. } else {
  272. chapterMenu, err = GetMenuChapter(reportInfo.Id, typeIds, reportInfo.ClassifyNameFirst, reportInfo.CreateTime)
  273. }
  274. //查询点赞数
  275. likeNum, likeEnabled, _ = services.GetReportLikeByReportIdOldReportId(user.UserID, reportInfo.Id, reportChapter.ReportChapterId, 0, 0)
  276. go AddViewRecord(user, reportInfo.Id, reportInfo.ClassifyNameFirst, reportChapterId)
  277. } else {
  278. reportChapterItem.ContentSub = html.UnescapeString(reportChapter.ContentSub)
  279. }
  280. go AddUserAccessRecord(user, reportInfo.Id, reportInfo.ClassifyNameFirst, reportChapterId, authOk)
  281. reportChapterDetail = new(response.ReportChapterDetail)
  282. reportChapterDetail.ReportChapterItem = reportChapterItem
  283. reportChapterDetail.PermissionCheck = &permissionCheckInfo
  284. reportChapterDetail.ReportChapterMenuList = chapterMenu
  285. reportChapterDetail.AuthOk = authOk
  286. reportChapterDetail.LikeNum = likeNum
  287. reportChapterDetail.LikeEnabled = likeEnabled
  288. // 收藏
  289. collectionId, e := collection.GetUserCollectByItem(int(user.UserID), collection.CollectionTypeReport, reportChapterItem.ReportId, reportChapterId)
  290. if e != nil {
  291. err = e
  292. return
  293. }
  294. reportChapterDetail.CollectionId = collectionId
  295. return
  296. }
  297. func GetMenuChapter(reportId int, typeIds []int, classifyNameFirst string, reportCreateTime time.Time) (reportTypeList response.ReportChapterMenuList, err error) {
  298. //查询有效的章节
  299. typeList, tErr := report_chapter_type.GetEffectTypes()
  300. if tErr != nil {
  301. return
  302. }
  303. if len(typeList) == 0 {
  304. err = errors.New("无有效的章节")
  305. return
  306. }
  307. typeMap := make(map[uint64]*report_chapter_type.ReportChapterType)
  308. for _, v := range typeList {
  309. typeMap[v.ReportChapterTypeId] = v
  310. }
  311. //获取所有当前研报的章节
  312. chapterList, tErr := report_chapter.GetListByReportIdTypeIds(reportId, typeIds, classifyNameFirst)
  313. if tErr != nil && tErr != utils.ErrNoRow {
  314. return
  315. }
  316. if len(chapterList) > 0 {
  317. for _, item := range chapterList {
  318. if typeItem, ok := typeMap[uint64(item.TypeId)]; ok {
  319. if reportCreateTime.Before(typeItem.PauseStartTime) || reportCreateTime.After(typeItem.PauseEndTime) {
  320. temp := new(response.ReportChapterMenu)
  321. temp.ReportChapterId = item.ReportChapterId
  322. temp.ReportId = item.ReportId
  323. temp.ReportChapterTypeName = typeItem.ReportChapterTypeName
  324. temp.ReportChapterTypeThumb = typeItem.YbBottomIcon
  325. temp.Sort = typeItem.Sort
  326. temp.PcSelectedThumb = typeItem.PcSelectedImage
  327. temp.PcUnselectedThumb = typeItem.PcUnselectedImage
  328. reportTypeList = append(reportTypeList, temp)
  329. }
  330. }
  331. }
  332. }
  333. if len(reportTypeList) > 0 {
  334. sort.Sort(reportTypeList)
  335. }
  336. return
  337. }
  338. // CheckWeekReportPermission 验证周报的权限
  339. func CheckWeekReportPermission(userInfo user.UserInfo, productAuthOk bool) (authOk bool, permissionCheckInfo response.PermissionCheckInfo, validTypeIds []int, err error) {
  340. var permissionIds []int
  341. var validPermissionIds []int //最后允许显示的章节
  342. if productAuthOk {
  343. permissionIds, err = chart_permission_chapter_mapping.GetPermissionIdsByWeek()
  344. if err != nil && err != utils.ErrNoRow {
  345. return
  346. }
  347. }
  348. authOk, permissionCheckInfo, validPermissionIds, err = company.GetCheckPermission(userInfo.CompanyID, int(userInfo.UserID), permissionIds)
  349. if err != nil {
  350. return
  351. }
  352. //返回可用的章节列表
  353. if len(validPermissionIds) > 0 {
  354. validTypeIds, err = chart_permission_chapter_mapping.GetReportIdsByPermisssionIds(validPermissionIds, "week")
  355. }
  356. return
  357. }
  358. // CheckDayReportPermission 验证晨报的权限
  359. func CheckDayReportPermission(userInfo user.UserInfo, productAuthOk bool) (authOk bool, permissionCheckInfo response.PermissionCheckInfo, err error) {
  360. if productAuthOk {
  361. authOk = true
  362. return
  363. }
  364. authOk, permissionCheckInfo, _, err = company.GetCheckPermission(userInfo.CompanyID, int(userInfo.UserID), []int{})
  365. return
  366. }
  367. // GetReportChapterVideoList 根据报告获取章节的音频列表
  368. func GetReportChapterVideoList(permissionIds []int, classifyName string, list []*report.Report) (videoMap map[int][]*response.VideoListItem, weekAuthMap map[int]bool, errMsg string, err error) {
  369. videoMap = make(map[int][]*response.VideoListItem)
  370. weekAuthMap = make(map[int]bool)
  371. var reportIds []int
  372. reportMap := make(map[int]*report.Report)
  373. for _, reportInfo := range list {
  374. reportMap[reportInfo.Id] = reportInfo
  375. reportIds = append(reportIds, reportInfo.Id)
  376. }
  377. // 查询有效的章节
  378. //查询有效的章节
  379. typeList, tErr := report_chapter_type.GetEffectTypes()
  380. if tErr != nil {
  381. errMsg = tErr.Error()
  382. err = errors.New("章节类型查询出错")
  383. return
  384. }
  385. if len(typeList) == 0 {
  386. err = errors.New("无有效的章节")
  387. return
  388. }
  389. typeMap := make(map[int]*report_chapter_type.ReportChapterType)
  390. var typeIds []int
  391. for _, v := range typeList {
  392. typeMap[int(v.ReportChapterTypeId)] = v
  393. typeIds = append(typeIds, int(v.ReportChapterTypeId))
  394. }
  395. var chapters []*report_chapter.ReportChapter
  396. if classifyName == "周报" {
  397. // 查询用户有权限的章节ID
  398. newTypeIds, tErr := GetWeekTypeIdsByPermissionIds(permissionIds, typeIds)
  399. if tErr != nil {
  400. errMsg = tErr.Error()
  401. err = errors.New("查询章节类型权限出错")
  402. return
  403. }
  404. // 查询章节列表
  405. chapters, err = report_chapter.GetByTypeIdsAndReportIds(newTypeIds, reportIds, classifyName)
  406. } else {
  407. // 查询章节列表
  408. chapters, err = report_chapter.GetByTypeIdsAndReportIds(typeIds, reportIds, classifyName)
  409. }
  410. if err != nil {
  411. errMsg = err.Error()
  412. err = errors.New("查询章节出错")
  413. return
  414. }
  415. for _, v := range chapters {
  416. if classifyName == "周报" {
  417. weekAuthMap[v.ReportId] = true
  418. }
  419. if temp, ok := typeMap[v.TypeId]; ok && v.VideoUrl != "" {
  420. if reportDetail, ok1 := reportMap[v.ReportId]; ok1 {
  421. reportDate := reportDetail.CreateTime
  422. if reportDate.Before(temp.PauseStartTime) || reportDate.After(temp.PauseEndTime) {
  423. videoItem := new(response.VideoListItem)
  424. videoItem.VideoPlaySeconds = v.VideoPlaySeconds
  425. videoItem.VideoName = v.VideoName
  426. if v.VideoName == "" {
  427. videoItem.VideoName = v.Title
  428. }
  429. videoItem.VideoUrl = v.VideoUrl
  430. videoItem.Sort = v.Sort
  431. videoMap[v.ReportId] = append(videoMap[v.ReportId], videoItem)
  432. }
  433. }
  434. }
  435. }
  436. return
  437. }