123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104 |
- package report
- import (
- "encoding/json"
- "errors"
- "fmt"
- report_chapter_type_cache "hongze/hongze_yb/cache/report_chapter_type"
- "hongze/hongze_yb/global"
- "hongze/hongze_yb/models/response"
- "hongze/hongze_yb/models/response/purchase"
- "hongze/hongze_yb/models/tables/chart_permission"
- "hongze/hongze_yb/models/tables/chart_permission_chapter_mapping"
- "hongze/hongze_yb/models/tables/chart_permission_search_key_word_mapping"
- "hongze/hongze_yb/models/tables/company_product"
- "hongze/hongze_yb/models/tables/daily_base_column"
- "hongze/hongze_yb/models/tables/rddp/classify"
- "hongze/hongze_yb/models/tables/rddp/report"
- "hongze/hongze_yb/models/tables/rddp/report_chapter"
- "hongze/hongze_yb/models/tables/rddp/report_chapter_ticker"
- "hongze/hongze_yb/models/tables/report_chapter_type"
- "hongze/hongze_yb/models/tables/report_chapter_type_permission"
- "hongze/hongze_yb/services/company"
- elasticService "hongze/hongze_yb/services/elastic"
- "hongze/hongze_yb/services/user"
- "hongze/hongze_yb/task"
- "hongze/hongze_yb/utils"
- "html"
- "sort"
- "strconv"
- "strings"
- "time"
- )
- // GetLatestClassReport 已购列表最新报告
- func GetLatestClassReport(permissionIds []int, userId uint64) (purchaseList []*purchase.PurchaseListItem, err error) {
- var errMsg string
- defer func() {
- if sysErr := recover(); sysErr != nil {
- err = errors.New("系统错误")
- global.LOG.Critical(fmt.Sprintf("GetLatestClassReport: userId=%d, err:%s,sysErr:%s", userId, err.Error(), sysErr))
- }
- if err != nil {
- global.LOG.Critical(fmt.Sprintf("GetLatestClassReport: userId=%d, err:%s, errMsg:%s", userId, err.Error(), errMsg))
- }
- }()
- //获取所有分类信息
- classifys, err := classify.GetSimpleAll()
- if err != nil {
- errMsg = err.Error()
- err = errors.New("分类查询出错")
- return
- }
- classifyFirstIconMap := make(map[int]string)
- classifySecondNameMap := make(map[string]int)
- classifyFirstIdMap := make(map[int]bool)
- classifySecondIdMap := make(map[int]bool)
- for _, v := range classifys {
- if v.ParentId == 0 {
- classifyFirstIdMap[v.Id] = true
- classifyFirstIconMap[v.Id] = v.YbIconUrl
- } else {
- classifySecondIdMap[v.Id] = true
- classifySecondNameMap[v.ClassifyName] = v.Id
- }
- }
- //获取最新的晨报
- dayReport, err := report.GetLatestDay()
- if err != nil {
- errMsg = err.Error()
- err = errors.New("晨报查询出错")
- return
- }
- //获取最新的有权限的周报
- //typeIds, err := report_chapter_type.GetEffectTypeID()
- typeIds, err := report_chapter_type_cache.GetEffectTypeID()
- if err != nil {
- errMsg = err.Error()
- err = errors.New("晨报查询出错")
- return
- }
- weekReport, err := GetLatestWeek(permissionIds, typeIds)
- if err != nil {
- errMsg = err.Error()
- err = errors.New("周报查询出错")
- return
- }
- // 有权限的二级分类
- var reports []*report.Report
- var classifyIdSeconds []int
- classifyIdSecondMap := make(map[int]bool)
- // 获取晨报和周报以外的其他报告
- // 获取有权限的二级分类
- chartPermissions, err := chart_permission_search_key_word_mapping.GetChartPermissionByFrom("rddp")
- if err != nil {
- errMsg = err.Error()
- err = errors.New("分类权限查询出错")
- return
- }
- if len(chartPermissions) > 0 {
- for _, v := range chartPermissions {
- for _, myPerId := range permissionIds {
- if v.ChartPermissionId == myPerId {
- if classifyIdSecond, ok := classifySecondNameMap[v.KeyWord]; ok {
- if _, ok2 := classifyIdSecondMap[classifyIdSecond]; !ok2 {
- classifyIdSeconds = append(classifyIdSeconds, classifyIdSecond)
- classifyIdSecondMap[classifyIdSecond] = true
- }
- }
- break
- }
- }
- }
- }
- reports, err = report.GetLatestClassReportsByClassifyIdSeconds(classifyIdSeconds)
- if err != nil {
- errMsg = err.Error()
- err = errors.New("二级分类最新报告查询出错")
- return
- }
- if dayReport.Id > 0 {
- reports = append(reports, dayReport)
- }
- if weekReport != nil && weekReport.Id > 0 {
- reports = append(reports, weekReport)
- }
- //获取未读数
- unReadItem, tErr := GetUnRead(classifyIdSeconds, userId)
- if tErr != nil {
- err = tErr
- return
- }
- if len(reports) > 0 {
- otherLatestItem := new(purchase.PurchaseListItem)
- // 处理其他报告()
- for _, v := range reports {
- temp := new(purchase.PurchaseListItem)
- temp.ReportId = v.Id
- temp.ClassifyIdFirst = v.ClassifyIdFirst
- temp.ClassifyNameFirst = v.ClassifyNameFirst
- temp.Stage = v.Stage
- temp.Title = v.Title
- temp.ClassifyIdSecond = v.ClassifyIdSecond
- temp.ClassifyNameSecond = v.ClassifyNameSecond
- temp.Time = v.PublishTime
- if temp.ClassifyNameFirst == "大事点评" || temp.ClassifyNameFirst == "会议纪要" || temp.ClassifyNameFirst == "年报合集" {
- if otherLatestItem.Time.Format(utils.FormatDateTime) > v.PublishTime.Format(utils.FormatDateTime) {
- continue
- }
- temp.Unread = unReadItem["大事点评"] + unReadItem["会议纪要"] + unReadItem["年报合集"]
- temp.Content = fmt.Sprintf("【第%d期|FICC】%s", temp.Stage, temp.ClassifyNameFirst)
- temp.ImgUrl = "https://hzstatic.hzinsights.com/static/yb_wx/purchase_icon_other.png"
- otherLatestItem = temp
- }
- }
- for _, v := range reports {
- if v.ClassifyNameFirst != "晨报" && v.ClassifyNameFirst != "周报" {
- // 报告的分类不存在
- if !classifyFirstIdMap[v.ClassifyIdFirst] || !classifyIdSecondMap[v.ClassifyIdSecond] {
- continue
- }
- }
- temp := new(purchase.PurchaseListItem)
- temp.ReportId = v.Id
- temp.ClassifyIdFirst = v.ClassifyIdFirst
- temp.ClassifyNameFirst = v.ClassifyNameFirst
- temp.Stage = v.Stage
- temp.Title = v.Title
- temp.ClassifyIdSecond = v.ClassifyIdSecond
- temp.ClassifyNameSecond = v.ClassifyNameSecond
- temp.Time = v.PublishTime
- temp.Unread = unReadItem[temp.ClassifyNameFirst]
- if imgUrl, ok := classifyFirstIconMap[temp.ClassifyIdFirst]; ok {
- temp.ImgUrl = imgUrl
- }
- if temp.ClassifyNameFirst == "晨报" || temp.ClassifyNameFirst == "周报" { //晨报或者周报,查询最新的章节信息
- temp.Content = fmt.Sprintf("【第%d期|FICC】%s", temp.Stage, temp.Title)
- } else if temp.ClassifyNameFirst == "大事点评" || temp.ClassifyNameFirst == "会议纪要" || temp.ClassifyNameFirst == "年报合集" {
- continue
- } else {
- if temp.ClassifyNameFirst != temp.ClassifyNameSecond { //包含二级分类
- temp.Content = fmt.Sprintf("【第%d期|FICC| %s】%s", temp.Stage, temp.ClassifyNameSecond, temp.ClassifyNameFirst)
- } else { //无二级分类
- temp.Content = fmt.Sprintf("【第%d期|FICC】%s", temp.Stage, temp.ClassifyNameFirst)
- }
- }
- purchaseList = append(purchaseList, temp)
- }
- if otherLatestItem.ReportId > 0 {
- purchaseList = append(purchaseList, otherLatestItem)
- }
- }
- return
- }
- // GetPurchaseDetail 已购详情页面
- func GetPurchaseDetail(permissionIds []int, userId uint64, classifyIdFirst int, pageIndex, pageSize int) (ret *purchase.DetailResp, err error) {
- var errMsg string
- defer func() {
- if err != nil {
- global.LOG.Critical(fmt.Sprintf("GetPurchaseDetail: userId=%d, err:%s, errMsg:%s", userId, err.Error(), errMsg))
- }
- }()
- var reports []*report.Report
- var weekReportIds []int
- classifyInfo, err := classify.GetByClassifyId(classifyIdFirst)
- if err != nil {
- errMsg = err.Error()
- err = errors.New("分类查询出错")
- return
- }
- if classifyInfo.Id == 0 {
- err = errors.New("分类不存在")
- return
- }
- classifyNameFirst := classifyInfo.ClassifyName
- offset := (pageIndex - 1) * pageSize
- var total int64
- var classifyIdSeconds []int
- if classifyNameFirst == "晨报" {
- //分类获取
- reports, err = report.GetListByClassifyIdFirst(classifyIdFirst, offset, pageSize)
- if err != nil {
- errMsg = err.Error()
- err = errors.New("晨报查询出错")
- return
- }
- total, err = report.GetListCountByClassifyIdFirst(classifyIdFirst)
- if err != nil {
- errMsg = err.Error()
- err = errors.New("查询报告总数出错")
- return
- }
- } else {
- if classifyNameFirst == "周报" {
- newTypeIds, tErr := GetWeekTypeIdsByPermissionIds(permissionIds, []int{})
- if tErr != nil {
- return
- }
- weekReportIds, err = report_chapter.GetReportIdsByTypeIdsAndClass(newTypeIds, classifyNameFirst)
- //分类获取
- reports, err = report.GetListByIDsAndClassifyIdFirst(weekReportIds, classifyIdFirst, offset, pageSize)
- if err != nil {
- return
- }
- total, err = report.GetListCountByIDsAndClassifyIdFirst(weekReportIds, classifyIdFirst)
- if err != nil {
- errMsg = err.Error()
- err = errors.New("查询报告总数出错")
- return
- }
- } else {
- //获取有权限的二级分类
- var classifyNameSeconds []string
- chartPermissions, tErr := chart_permission_search_key_word_mapping.GetChartPermissionByFrom("rddp")
- if tErr != nil {
- errMsg = tErr.Error()
- err = errors.New("分类权限查询出错")
- return
- }
- if len(chartPermissions) > 0 {
- for _, v := range chartPermissions {
- for _, myPerId := range permissionIds {
- if v.ChartPermissionId == myPerId {
- if classifyNameFirst == "大事点评" || classifyNameFirst == "会议纪要" || classifyNameFirst == "年报合集" {
- if v.KeyWord == "大事点评" || v.KeyWord == "会议纪要" || v.KeyWord == "年报合集" { //筛选出用户有权限的二级分类ID
- classifyNameSeconds = append(classifyNameSeconds, v.KeyWord)
- }
- } else {
- classifyNameSeconds = append(classifyNameSeconds, v.KeyWord)
- }
- break
- }
- }
- }
- }
- //获取所有二级分类的id
- if classifyNameFirst == "大事点评" || classifyNameFirst == "会议纪要" || classifyNameFirst == "年报合集" {
- classifyIdSeconds, tErr = classify.GetOtherSecondIds([]string{"大事点评", "会议纪要", "年报合集"})
- } else {
- classifyIdSeconds, tErr = classify.GetIdsByClassifyNameAndParentId(classifyNameSeconds, classifyIdFirst)
- }
- if tErr != nil {
- errMsg = tErr.Error()
- err = errors.New("二级分类查询出错")
- return
- }
- if len(classifyIdSeconds) > 0 {
- //分类获取
- reports, err = report.GetListByClassifyIdSeconds(classifyIdSeconds, offset, pageSize)
- if err != nil {
- return
- }
- total, err = report.GetListCountByClassifyIdSeconds(classifyIdSeconds)
- if err != nil {
- errMsg = err.Error()
- err = errors.New("查询报告总数出错")
- return
- }
- }
- }
- }
- var list []*purchase.Detail
- ret = new(purchase.DetailResp)
- if len(reports) > 0 {
- var viewReportIds []int
- for _, v := range reports {
- viewReportIds = append(viewReportIds, v.Id)
- temp := new(purchase.Detail)
- temp.ReportId = v.Id
- temp.ClassifyIdFirst = v.ClassifyIdFirst
- temp.ClassifyNameFirst = v.ClassifyNameFirst
- temp.Title = v.Title
- temp.ClassifyIdSecond = v.ClassifyIdSecond
- temp.ClassifyNameSecond = v.ClassifyNameSecond
- temp.Stage = v.Stage
- temp.ImgUrl = classifyInfo.YbBgUrl
- if temp.ClassifyNameFirst == "晨报" || temp.ClassifyNameFirst == "周报" { //晨报或者周报,查询最新的章节信息
- temp.Content = fmt.Sprintf("【第%d期|FICC】%s", temp.Stage, temp.Title)
- temp.TopName = temp.Title
- } else {
- if temp.ClassifyNameFirst != temp.ClassifyNameSecond { //包含二级分类
- temp.Content = fmt.Sprintf("【第%d期|FICC| %s】%s", temp.Stage, temp.ClassifyNameSecond, temp.ClassifyNameFirst)
- temp.TopName = temp.ClassifyNameSecond
- } else {
- temp.Content = fmt.Sprintf("【第%d期|FICC】%s", temp.Stage, temp.ClassifyNameFirst)
- temp.TopName = temp.ClassifyNameFirst
- }
- }
- temp.Time = v.PublishTime
- list = append(list, temp)
- }
- }
- ret.List = list
- ret.Paging = response.GetPaging(pageIndex, pageSize, int(total))
- // 执行一个协程任务,新增用户浏览记录
- //_, tErr := BatchInsertReportView(weekReportIds, userId, classifyNameFirst, classifyIdSeconds)
- task.Task(BatchInsertReportView, weekReportIds, userId, classifyNameFirst, classifyIdSeconds)
- /*if tErr != nil {
- err = tErr
- return
- }*/
- return
- }
- // 获取报告详情
- func GetReportDetail(userinfo user.UserInfo, reportId int) (reportDetail response.ReportDetail, err error) {
- var errMsg string
- defer func() {
- if err != nil {
- global.LOG.Critical(fmt.Sprintf("GetReportDetail: userId=%d, err:%s, errMsg:%s", userinfo.UserID, err.Error(), errMsg))
- }
- }()
- // 判断用户状态是否是正常和永续
- var productAuthOk bool
- companyProduct, err := company_product.GetByCompany2ProductId(userinfo.CompanyID, 1)
- if err == utils.ErrNoRow {
- err = nil
- }
- if err != nil {
- errMsg = err.Error()
- err = errors.New("查询用户购买产品出错")
- return
- }
- if companyProduct != nil {
- // 无FICC权限的客户不可见
- if companyProduct.CompanyProductID > 0 {
- // 已购或者试用用户可见
- if strings.Contains("永续,正式", companyProduct.Status) || (companyProduct.Status == "试用" && companyProduct.IsSuspend != 1) {
- productAuthOk = true
- }
- }
- }
- reportInfo, err := report.GetByReportId(reportId)
- if err != nil {
- errMsg = err.Error()
- err = errors.New("报告查询出错")
- return
- }
- if reportInfo.Id == 0 {
- err = errors.New("报告不存在")
- return
- }
- if reportInfo.State != 2 {
- err = errors.New("报告未发布")
- return
- }
- //判断权限
- var authOk bool
- var permissionCheckInfo response.PermissionCheckInfo
- var vaildWeekTypeIds []int
- if reportInfo.ClassifyNameFirst == "晨报" {
- authOk, permissionCheckInfo, err = CheckDayReportPermission(userinfo, productAuthOk)
- } else if reportInfo.ClassifyNameFirst == "周报" {
- authOk, permissionCheckInfo, vaildWeekTypeIds, err = CheckWeekReportPermission(userinfo, productAuthOk)
- } else {
- authOk, permissionCheckInfo, err = CheckReportPermission(userinfo, reportId, productAuthOk)
- }
- if err != nil {
- return
- }
- reportItem := new(response.ReportItem)
- reportItem.ReportId = reportInfo.Id
- reportItem.Title = reportInfo.Title
- reportItem.PublishTime = reportInfo.PublishTime
- reportItem.ClassifyNameFirst = reportInfo.ClassifyNameFirst
- reportItem.ClassifyNameSecond = reportInfo.ClassifyNameSecond
- reportItem.Stage = reportInfo.Stage
- reportItem.Abstract = reportInfo.Abstract
- reportItem.ContentSub = html.UnescapeString(reportInfo.ContentSub)
- reportItem.Frequency = reportInfo.Frequency
- reportItem.VideoName = reportInfo.VideoName
- if reportInfo.VideoName == "" && reportInfo.VideoUrl != "" {
- reportItem.VideoName = reportInfo.Title
- }
- reportItem.VideoPlaySeconds = reportInfo.VideoPlaySeconds
- reportItem.Author = reportInfo.Author
- var reportTypeList []*response.ReportChapterListItem
- if reportInfo.ClassifyNameFirst == "晨报" || reportInfo.ClassifyNameFirst == "周报" {
- //(晨报和周报的banner图)
- if reportInfo.ClassifyNameFirst == "晨报" {
- reportItem.BannerUrl = utils.ALIYUN_YBIMG_HOST + "report_banner_day.jpg"
- } else {
- reportItem.BannerUrl = utils.ALIYUN_YBIMG_HOST + "report_banner_week.jpg"
- }
- if authOk {
- reportTypeList, err = GetChapterListByReport(reportInfo.ClassifyNameFirst, reportInfo.Id, vaildWeekTypeIds, reportInfo.CreateTime)
- if err != nil {
- return
- }
- }
- }
- //如果有权限则展示content
- if authOk {
- task.Task(AddViewRecord, userinfo, reportInfo.Id, reportInfo.ClassifyNameFirst, 0)
- reportItem.Content = html.UnescapeString(reportInfo.Content)
- reportItem.VideoUrl = reportInfo.VideoUrl
- }
- //新增用户访问日志
- task.Task(AddUserAccessRecord, userinfo, reportInfo.Id, reportInfo.ClassifyNameFirst, 0, authOk)
- reportDetail.ReportInfo = reportItem
- reportDetail.ReportChapterList = reportTypeList
- reportDetail.PermissionCheck = &permissionCheckInfo
- reportDetail.AuthOk = authOk
- return
- }
- // CheckReportPermission 验证用户查看报告的权限
- func CheckReportPermission(userInfo user.UserInfo, reportId int, productAuthOk bool) (authOk bool, permissionCheckInfo response.PermissionCheckInfo, err error) {
- var permissionIds []int
- if productAuthOk {
- permissionIds, err = chart_permission_chapter_mapping.GetPermissionIdsByReportId(reportId, "rddp")
- if err != nil && err != utils.ErrNoRow {
- return
- }
- }
- authOk, permissionCheckInfo, _, err = company.GetCheckPermission(userInfo.CompanyID, int(userInfo.UserID), permissionIds)
- return
- }
- // GetReportList 获取报告列表
- func GetReportList(user user.UserInfo, keyWord string, classifyIdFirst, classifyIdSecond, pageIndex, pageSize int) (ret *response.ReportList, err error) {
- var errMsg string
- defer func() {
- if err != nil {
- global.LOG.Critical(fmt.Sprintf("GetReportList: userId=%d, err:%s, errMsg:%s", user.UserID, err.Error(), errMsg))
- }
- }()
- // 判断用户状态是否是正常和永续
- var productAuthOk bool
- companyProduct, err := company_product.GetByCompany2ProductId(user.CompanyID, 1)
- if err == utils.ErrNoRow {
- err = nil
- }
- if err != nil {
- errMsg = err.Error()
- err = errors.New("查询用户购买产品出错")
- return
- }
- if companyProduct != nil {
- // 无FICC权限的客户不可见
- if companyProduct.CompanyProductID > 0 {
- // 已购或者试用用户可见
- if strings.Contains("永续,正式", companyProduct.Status) || (companyProduct.Status == "试用" && companyProduct.IsSuspend != 1) {
- productAuthOk = true
- }
- }
- }
- var condition string
- pars := make([]interface{}, 0)
- classifyParent, err := classify.GetByClassifyId(classifyIdFirst)
- if err != nil {
- errMsg = err.Error()
- err = errors.New("分类查询出错")
- return
- }
- if classifyParent.Id == 0 {
- err = errors.New("该分类不存在")
- return
- }
- condition = `classify_id_first = ? and state = 2`
- pars = append(pars, classifyIdFirst)
- permissionMap := make(map[string][]int)
- checkPermissionMap := make(map[string]bool)
- permissionImageMap := make(map[string]string)
- chartPermissionImageMap := make(map[int]string)
- var classifyIdSeconds []int
- var reportImgUrl string
- chartPermissionList, err := chart_permission.GetFiccListExceptTacticByProductId()
- if err != nil {
- errMsg = err.Error()
- err = errors.New("分类查询出错")
- return
- }
- if len(chartPermissionList) > 0 {
- for _, v := range chartPermissionList {
- chartPermissionImageMap[int(v.ChartPermissionID)] = v.YbImgUrl
- }
- }
- if classifyIdSecond > 0 && keyWord == "" {
- classifyInfo, tErr := classify.GetByClassifyId(classifyIdSecond)
- if tErr != nil {
- errMsg = tErr.Error()
- err = errors.New("分类查询出错")
- return
- }
- if classifyInfo.Id == 0 {
- err = errors.New("该二级分类不存在")
- return
- }
- condition += " AND classify_id_second = ?"
- pars = append(pars, classifyIdSecond)
- //查询二级分类对应的权限
- permissionIds, tErr := chart_permission_search_key_word_mapping.GetChartPermissionIdsByKeyWord(classifyInfo.ClassifyName)
- if tErr != nil {
- errMsg = tErr.Error()
- err = errors.New("分类权限查询出错")
- return
- }
- permissionMap[classifyInfo.ClassifyName] = permissionIds
- if len(permissionIds) > 0 {
- for _, v := range permissionIds {
- reportImgUrl = chartPermissionImageMap[v]
- }
- }
- } else {
- if classifyParent.ClassifyName == "晨报" || classifyParent.ClassifyName == "周报" {
- reportImgUrl = chartPermissionImageMap[1]
- classifyIdSeconds = append(classifyIdSeconds, 0)
- }
- chartPermissions, tErr := chart_permission_search_key_word_mapping.GetChartPermissionByFrom("rddp")
- if tErr != nil {
- errMsg = tErr.Error()
- err = errors.New("分类权限查询出错")
- return
- }
- if len(chartPermissions) > 0 {
- for _, v := range chartPermissions {
- permissionMap[v.KeyWord] = append(permissionMap[v.KeyWord], v.ChartPermissionId)
- permissionImageMap[v.KeyWord] = chartPermissionImageMap[v.ChartPermissionId]
- }
- }
- //获取二级分类的所有头像
- classifyList, tErr := classify.GetListByPid(classifyIdFirst)
- if tErr != nil {
- errMsg = tErr.Error()
- err = errors.New("二级分类查询出错")
- return
- }
- for _, v := range classifyList {
- classifyIdSeconds = append(classifyIdSeconds, v.Id)
- }
- if len(classifyIdSeconds) == 0 && classifyParent.ClassifyName != "晨报" && classifyParent.ClassifyName != "周报" {
- ret = new(response.ReportList)
- ret.Paging = response.GetPaging(pageIndex, pageSize, 0)
- return
- }
- condition += ` AND classify_id_second IN ? `
- pars = append(pars, classifyIdSeconds)
- }
- // 获取有效的权限id列表
- var validPermissionIdList []int
- if productAuthOk {
- validPermissionIdList, err = company.GetValidPermissionIdListByCompany2ProductId(user.CompanyID, 1)
- if err != nil && err != utils.ErrNoRow {
- errMsg = err.Error()
- err = errors.New("查询分类出错")
- return
- }
- }
- if len(validPermissionIdList) > 0 {
- for classifyName, perIds := range permissionMap {
- checkLoop:
- for _, checkId := range perIds {
- for _, validPerid := range validPermissionIdList {
- if checkId == validPerid {
- checkPermissionMap[classifyName] = true
- break checkLoop
- }
- }
- }
- }
- }
- var total int64
- var list []*report.Report
- if keyWord == "" {
- offset := (pageIndex - 1) * pageSize
- list, err = report.GetReportList(condition, pars, offset, pageSize)
- if err != nil {
- errMsg = err.Error()
- err = errors.New("报告查询出错")
- return
- }
- total, err = report.GetReportListCount(condition, pars)
- if err != nil {
- errMsg = err.Error()
- err = errors.New("查询报告总数出错")
- return
- }
- } else {
- if classifyIdSecond > 0 {
- classifyIdSeconds = append(classifyIdSeconds, classifyIdSecond)
- }
- if classifyParent.ClassifyName == "晨报" || classifyParent.ClassifyName == "周报" {
- classifyIdSeconds = append(classifyIdSeconds, 0)
- }
- searchResp, total1, tErr := elasticService.ReportListSearch(keyWord, classifyIdFirst, classifyIdSeconds, pageIndex, pageSize)
- if tErr != nil {
- errMsg = tErr.Error()
- err = errors.New("查询失败")
- return
- }
- total = int64(total1)
- if searchResp.Hits != nil && total > 0 {
- var reportIds []int
- for _, v := range searchResp.Hits.Hits {
- temp := new(report.Report)
- itemJson, tmpErr := v.Source.MarshalJSON()
- if tmpErr != nil {
- errMsg = tmpErr.Error()
- err = errors.New("解析出错")
- return
- }
- reportItem := new(response.EsReportItem)
- tmpErr = json.Unmarshal(itemJson, &reportItem)
- if tmpErr != nil {
- errMsg = tmpErr.Error()
- err = errors.New("解析json出错")
- return
- }
- temp.Id = reportItem.ReportId
- reportIds = append(reportIds, reportItem.ReportId)
- temp.ClassifyIdFirst = reportItem.ClassifyIdFirst
- temp.ClassifyNameFirst = reportItem.ClassifyNameFirst
- temp.ClassifyIdSecond = reportItem.ClassifyIdSecond
- temp.ClassifyNameSecond = reportItem.ClassifyNameSecond
- temp.Abstract = reportItem.Abstract
- temp.StageStr = reportItem.StageStr
- temp.Title = reportItem.Title
- temp.PublishTime, err = time.Parse("2006-01-02 15:04:05", reportItem.PublishTime)
- if len(v.Highlight["Title"]) > 0 {
- temp.Title = v.Highlight["Title"][0]
- }
- // 样式限制行数
- temp.Title = "<div style=\"-webkit-line-clamp: 3;-webkit-box-orient: vertical;display: -webkit-box;overflow: hidden;text-overflow: ellipsis;\">" + temp.Title + "</div>"
- if len(v.Highlight["Abstract"]) > 0 {
- temp.Abstract = v.Highlight["Abstract"][0]
- }
- if len(v.Highlight["StageStr"]) > 0 {
- temp.StageStr = v.Highlight["StageStr"][0]
- }
- list = append(list, temp)
- }
- reportInfoList, tmpErr := report.GetByReportIds(reportIds)
- if tmpErr != nil {
- errMsg = tmpErr.Error()
- err = errors.New("查询报告出错")
- return
- }
- reportListMap := make(map[int]*report.Report)
- for _, temp := range reportInfoList {
- reportListMap[temp.Id] = temp
- }
- for k, reportDetail := range list {
- if v, ok := reportListMap[reportDetail.Id]; ok {
- list[k].CreateTime = v.CreateTime
- }
- }
- }
- }
- var reportList []*response.ReportListItem
- if len(list) > 0 {
- var videoReportIds []int
- videoMap := make(map[int][]*response.VideoListItem)
- weekAuthMap := make(map[int]bool)
- if classifyParent.ClassifyName == "晨报" && productAuthOk {
- //获取晨报的音频列表
- videoMap, _, errMsg, err = GetReportChapterVideoList(validPermissionIdList, classifyParent.ClassifyName, list)
- if err != nil {
- return
- }
- } else if classifyParent.ClassifyName == "周报" {
- //查询所有权限typeID
- //如果存在可以查看的章节ID
- for _, reportInfo := range list {
- videoReportIds = append(videoReportIds, reportInfo.Id)
- }
- // 判断周报权限\查询周报的音频列表
- videoMap, weekAuthMap, errMsg, err = GetReportChapterVideoList(validPermissionIdList, classifyParent.ClassifyName, list)
- if err != nil {
- return
- }
- }
- for _, reportInfo := range list {
- reportItem := new(response.ReportListItem)
- reportItem.ReportId = reportInfo.Id
- reportItem.Title = reportInfo.Title
- reportItem.PublishTime = reportInfo.PublishTime
- reportItem.ClassifyNameFirst = reportInfo.ClassifyNameFirst
- reportItem.ClassifyNameSecond = reportInfo.ClassifyNameSecond
- reportItem.ClassifyIdFirst = reportInfo.ClassifyIdFirst
- reportItem.ClassifyIdSecond = reportInfo.ClassifyIdSecond
- reportItem.Stage = reportInfo.Stage
- reportItem.Abstract = reportInfo.Abstract
- if reportInfo.Abstract != "" {
- reportItem.Abstract = "<div style=\"overflow: hidden;white-space: nowrap;text-overflow: ellipsis;\">" + reportInfo.Abstract + "</div>"
- }
- reportItem.Author = reportInfo.Author
- stageStr := reportInfo.StageStr
- if stageStr == "" {
- stageStr = strconv.Itoa(reportInfo.Stage)
- }
- reportItem.TitleInfo = fmt.Sprintf("【第%s期|FICC|%s】", stageStr, reportItem.ClassifyNameSecond)
- if reportInfo.ClassifyNameFirst == "晨报" || reportInfo.ClassifyNameFirst == "周报" || classifyIdSecond > 0 {
- reportItem.ReportImgUrl = utils.ALIYUN_YBIMG_HOST + reportImgUrl
- reportItem.TitleInfo = fmt.Sprintf("【第%s期|FICC|%s】", stageStr, reportItem.ClassifyNameFirst)
- } else if url, ok := permissionImageMap[reportInfo.ClassifyNameSecond]; ok {
- reportItem.ReportImgUrl = utils.ALIYUN_YBIMG_HOST + url
- }
- if classifyParent.ClassifyName == "晨报" && productAuthOk {
- // 查询当前晨报的所有音频
- if vList, ok := videoMap[reportInfo.Id]; ok {
- reportItem.VideoList = vList
- }
- reportItem.AuthOk = productAuthOk
- } else if classifyParent.ClassifyName == "周报" {
- if wAuth, ok := weekAuthMap[reportInfo.Id]; ok {
- reportItem.AuthOk = wAuth
- if wAuth {
- // 查询当前晨报的所有音频
- if vList, ok2 := videoMap[reportInfo.Id]; ok2 {
- reportItem.VideoList = vList
- }
- }
- }
- } else if authOk, ok := checkPermissionMap[reportInfo.ClassifyNameSecond]; ok && authOk {
- if reportInfo.VideoUrl != "" {
- videoTemp := new(response.VideoListItem)
- videoTemp.VideoUrl = reportInfo.VideoUrl
- videoTemp.VideoName = reportInfo.VideoName
- if reportInfo.VideoName == "" {
- videoTemp.VideoName = reportInfo.Title
- }
- videoTemp.VideoPlaySeconds = reportInfo.VideoPlaySeconds
- reportItem.VideoList = append(reportItem.VideoList, videoTemp)
- }
- reportItem.AuthOk = authOk
- }
- reportList = append(reportList, reportItem)
- }
- }
- ret = new(response.ReportList)
- ret.List = reportList
- ret.Paging = response.GetPaging(pageIndex, pageSize, int(total))
- return
- }
- // GetCollectReportList 首页展示报告汇总列表
- func GetCollectReportList(user user.UserInfo, chartPermissionId, pageIndex, pageSize int) (ret *response.ReportCollectResp, err error) {
- var errMsg string
- defer func() {
- if err != nil {
- global.LOG.Critical(fmt.Sprintf("GetCollectReportList: userId=%d, err:%s, errMsg:%s", user.UserID, err.Error(), errMsg))
- }
- }()
- // 查询权限的基本信息
- permissionInfo, err := chart_permission.GetByChartPermissionId(chartPermissionId)
- if err != nil {
- errMsg = err.Error()
- err = errors.New("查询权限出错")
- return
- }
- if permissionInfo.ChartPermissionID == 0 {
- err = errors.New("权限不存在")
- return
- }
- // 除了晨报和周报以外的其他报告
- classifyNames, err := chart_permission_search_key_word_mapping.GetKeyWordsByChartPermissionId(chartPermissionId, "rddp")
- if err != nil {
- errMsg = err.Error()
- err = errors.New("查询权限对应的分类出错")
- return
- }
- var classifySecondIds []int
- if len(classifyNames) > 0 {
- classifySecondIds, err = classify.GetSecondIdsByClassifyNames(classifyNames)
- if err != nil {
- errMsg = err.Error()
- err = errors.New("查询分类出错")
- return
- }
- }
- // 查询晨报和周报相对应的章节ID
- reportChapterTypeIds, err := report_chapter_type_permission.GetTypeIdsByChartPermissionId(chartPermissionId)
- if err != nil {
- errMsg = err.Error()
- err = errors.New("查询权限对应的章节出错")
- return
- }
- var reportList []*response.ReportCollectListItem
- list := response.ReportCollectListResp{}
- var total int64
- if len(reportChapterTypeIds) > 0 || len(classifySecondIds) > 0 {
- offset := (pageIndex - 1) * pageSize
- reportList, err = report.GetReportCollectListByPermission(classifySecondIds, reportChapterTypeIds, offset, pageSize)
- if err != nil {
- errMsg = err.Error()
- err = errors.New("查询报告信息出错")
- return
- }
- listMap := make(map[string]*response.ReportCollectList)
- for _, v := range reportList {
- v.ContentSub = GetReportContentSub(v.ContentSub, true)
- if _, ok := listMap[v.PublishTime.Format("2006-01-02")]; !ok {
- temp := new(response.ReportCollectList)
- temp.Date = v.PublishTime.Format("2006-01-02")
- listMap[v.PublishTime.Format("2006-01-02")] = temp
- }
- listMap[v.PublishTime.Format("2006-01-02")].SubList = append(listMap[v.PublishTime.Format("2006-01-02")].SubList, v)
- }
- for _, v := range listMap {
- list = append(list, v)
- }
- total, err = report.GetReportCollectCountByPermission(classifySecondIds, reportChapterTypeIds)
- if err != nil {
- errMsg = err.Error()
- err = errors.New("查询报告总数出错")
- return
- }
- if len(list) > 0 {
- sort.Sort(list)
- }
- }
- ret = new(response.ReportCollectResp)
- ret.List = list
- ret.Paging = response.GetPaging(pageIndex, pageSize, int(total))
- return
- }
- func SearchReport(user user.UserInfo, keyWord string, pageIndex, pageSize int) (ret *response.ReportSearchResp, err error) {
- var errMsg string
- defer func() {
- if err != nil {
- global.LOG.Critical(fmt.Sprintf("SearchReport: userId=%d, err:%s, errMsg:%s", user.UserID, err.Error(), errMsg))
- }
- }()
- //查询正常状态的分类
- classifys, err := classify.GetSimpleAll()
- if err != nil {
- errMsg = err.Error()
- err = errors.New("分类查询出错")
- return
- }
- var classifyIdFirsts []int
- classifyIdSeconds := []int{0}
- for _, v := range classifys {
- if v.ParentId == 0 {
- classifyIdFirsts = append(classifyIdFirsts, v.Id)
- } else {
- classifyIdSeconds = append(classifyIdSeconds, v.Id)
- }
- }
- keyWord = addAliasToKeyword(keyWord)
- searchResp, total, err := elasticService.SearchReport(keyWord, classifyIdFirsts, classifyIdSeconds, pageIndex, pageSize)
- if err != nil {
- errMsg = err.Error()
- err = errors.New("查询失败")
- return
- }
- var reportList []*response.ReportCollectListItem
- if searchResp.Hits != nil {
- for _, v := range searchResp.Hits.Hits {
- temp := new(response.ReportCollectListItem)
- itemJson, tmpErr := v.Source.MarshalJSON()
- if tmpErr != nil {
- errMsg = tmpErr.Error()
- err = errors.New("解析出错")
- return
- }
- reportItem := new(response.EsReportItem)
- tmpErr = json.Unmarshal(itemJson, &reportItem)
- if tmpErr != nil {
- errMsg = tmpErr.Error()
- err = errors.New("解析json出错")
- return
- }
- temp.ReportId = reportItem.ReportId
- temp.ReportChapterId = reportItem.ReportChapterId
- temp.ClassifyIdFirst = reportItem.ClassifyIdFirst
- temp.ClassifyNameFirst = reportItem.ClassifyNameFirst
- temp.ClassifyIdSecond = reportItem.ClassifyIdSecond
- temp.ClassifyNameSecond = reportItem.ClassifyNameSecond
- temp.Title = reportItem.Title
- temp.ContentSub = reportItem.BodyContent
- temp.PublishTime, err = time.Parse("2006-01-02 15:04:05", reportItem.PublishTime)
- if len(v.Highlight["Title"]) > 0 {
- temp.Title = v.Highlight["Title"][0]
- }
- if len(v.Highlight["BodyContent"]) > 0 {
- temp.ContentSub = v.Highlight["BodyContent"][0]
- }
- //if len(v.Highlight["Categories"]) > 0 {
- // if temp.ClassifyNameSecond != "" {
- // temp.ClassifyNameSecond = "<span style=\"color:#E3B377\">"+temp.ClassifyNameSecond+"</span>"
- // }
- // if temp.ClassifyNameFirst != "" {
- // temp.ClassifyNameFirst = "<span style=\"color:#E3B377\">"+temp.ClassifyNameFirst+"</span>"
- // }
- //}
- temp.ContentSub = GetReportContentSub(temp.ContentSub, false)
- reportList = append(reportList, temp)
- }
- }
- ret = new(response.ReportSearchResp)
- ret.List = reportList
- ret.Paging = response.GetPaging(pageIndex, pageSize, int(total))
- return
- }
- // GetTickerData 获取指标数据
- func GetTickerData(user user.UserInfo, reportChapterId int) (ret *response.TickerData, err error) {
- var errMsg string
- defer func() {
- if err != nil {
- global.LOG.Critical(fmt.Sprintf("GetTickerData: userId=%d, err:%s, errMsg:%s", user.UserID, err.Error(), errMsg))
- }
- }()
- //查询章节类型
- chapter, err := report_chapter.GetTypeIdById(reportChapterId)
- if err != nil {
- errMsg = err.Error()
- err = errors.New("查询章节失败")
- return
- }
- if chapter.ReportChapterId == 0 {
- err = errors.New("章节不存在或者未发布")
- return
- }
- tickers, err := report_chapter_ticker.GetTickerByChapterId(reportChapterId)
- if err != nil {
- errMsg = err.Error()
- err = errors.New("查询章节指标失败")
- return
- }
- var list []*response.TickerDataItem
- if len(tickers) > 0 {
- var tickerNames []string
- for _, v := range tickers {
- tickerNames = append(tickerNames, v.Ticker)
- }
- var dataList []*response.TickerDataItem
- if chapter.TypeId == 17 {
- dataList, err = daily_base_column.GetDataByBaseColumnTickers17(tickerNames)
- } else {
- dataList, err = daily_base_column.GetDataByBaseColumnTickers(tickerNames)
- }
- if err != nil {
- errMsg = err.Error()
- err = errors.New("查询指标数据失败")
- return
- }
- chapterTypeInfo, tErr := report_chapter_type.GetTickerTitleByTypeId(chapter.TypeId)
- if tErr != nil {
- errMsg = tErr.Error()
- err = errors.New("查询章节类型失败")
- return
- }
- if len(dataList) >= 0 {
- for _, v := range dataList {
- temp := new(response.TickerDataItem)
- temp.BaseColumnName = v.BaseColumnName
- temp.Ticker = v.Ticker
- temp.Date = v.Date
- temp.TickerValue, _ = strconv.ParseFloat(fmt.Sprintf("%.2f", v.TickerValue), 2)
- temp.LastValue, _ = strconv.ParseFloat(fmt.Sprintf("%.2f", v.LastValue), 2)
- temp.MmValue, _ = strconv.ParseFloat(fmt.Sprintf("%.2f", v.MmValue), 2)
- temp.DdValue, _ = strconv.ParseFloat(fmt.Sprintf("%.2f", v.DdValue), 2)
- temp.WwValue, _ = strconv.ParseFloat(fmt.Sprintf("%.2f", v.WwValue), 2)
- list = append(list, temp)
- }
- }
- tickerTitle := new(response.TickerTitleData)
- tickerTitle.TickerTitle = chapterTypeInfo.TickerTitle
- tickerTitle.ReportChapterTypeId = int(chapterTypeInfo.ReportChapterTypeId)
- tickerTitle.ReportChapterTypeName = chapterTypeInfo.ReportChapterTypeName
- tickerTitle.DataTableImage = fmt.Sprintf("http://hongze.oss-cn-shanghai.aliyuncs.com/data_table/%s.png", chapterTypeInfo.ReportChapterTypeKey)
- ret = new(response.TickerData)
- ret.List = list
- ret.TickerTitle = tickerTitle
- }
- return
- }
- // GetReportContentSub 特殊处理contentSub
- func GetReportContentSub(content string, scapeFlag bool) (contentSub string) {
- if scapeFlag {
- content = html.UnescapeString(content)
- content = utils.TrimHtml(content) //只展示纯文本
- }
- contentSub = "<div style=\"-webkit-line-clamp: 3;-webkit-box-orient: vertical;display: -webkit-box;overflow: hidden;text-overflow: ellipsis;\">" + content + "</div>"
- return
- }
- // addAliasToKeyword 品种别名
- func addAliasToKeyword(keyword string) string {
- if keyword == "" {
- return ""
- }
- keywordArr := make([]string, 0)
- keywordArr = append(keywordArr, keyword)
- if strings.Contains(keyword, "沥青") || strings.Contains(keyword, "BU") {
- keywordArr = append(keywordArr, "沥青", "BU")
- }
- if strings.Contains(keyword, "MEG") || strings.Contains(keyword, "EG") || strings.Contains(keyword, "乙二醇") {
- keywordArr = append(keywordArr, "MEG", "EG", "乙二醇")
- }
- if strings.Contains(keyword, "聚酯") || strings.Contains(keyword, "长丝") || strings.Contains(keyword, "短纤") || strings.Contains(keyword, "瓶片") {
- keywordArr = append(keywordArr, "聚酯", "长丝", "短纤", "瓶片")
- }
- if strings.Contains(keyword, "纯苯") || strings.Contains(keyword, "苯乙烯") || strings.Contains(keyword, "EB") {
- keywordArr = append(keywordArr, "纯苯", "苯乙烯", "EB")
- }
- if strings.Contains(keyword, "甲醇") || strings.Contains(keyword, "MA") {
- keywordArr = append(keywordArr, "甲醇", "MA")
- }
- if strings.Contains(keyword, "橡胶") || strings.Contains(keyword, "RU") {
- keywordArr = append(keywordArr, "橡胶", "RU")
- }
- if strings.Contains(keyword, "聚乙烯") || strings.Contains(keyword, "PP") || strings.Contains(keyword, "PE") {
- keywordArr = append(keywordArr, "聚乙烯", "PP", "PE")
- }
- if strings.Contains(keyword, "玻璃") || strings.Contains(keyword, "纯碱") || strings.Contains(keyword, "FG") || strings.Contains(keyword, "SA") {
- keywordArr = append(keywordArr, "玻璃", "纯碱", "FG", "SA")
- }
- keyword = strings.Join(keywordArr, ",")
- return keyword
- }
|