package controllers import ( "encoding/json" "eta/eta_api/models" "eta/eta_api/models/report" "eta/eta_api/models/report_approve" "eta/eta_api/models/system" "eta/eta_api/services" "eta/eta_api/services/alarm_msg" "eta/eta_api/services/data" "eta/eta_api/utils" "fmt" "github.com/rdlucklib/rdluck_tools/paging" "html" "strconv" "time" ) // TODO 报告的权限校验(跳过列表页,直接进入详情页,不管是普通报告还是章节报告) // ListReport // @Title 获取报告列表接口 // @Description 获取报告列表 // @Param PageSize query int true "每页数据条数" // @Param CurrentIndex query int true "当前页页码,从1开始" // @Param TimeType query string true "筛选的时间类别:publish_time(发布时间),modify_time(更新时间);approve_time(审批时间)" // @Param StartDate query string true "开始时间" // @Param EndDate query string true "结束时间" // @Param Frequency query string true "频度" // @Param ClassifyIdFirst query int true "一级分类id" // @Param ClassifyIdSecond query int true "二级分类id" // @Param ClassifyIdThird query int true "三级分类id" // @Param State query int true "状态" // @Param KeyWord query string true "搜索关键词" // @Param PublishSort query string true "desc:降序,asc 升序(预留)" // @Param FilterReportType query string true "筛选报告类型,1:公共研报,2:共享研报,3:我的研报" // @Success 200 {object} models.ReportListResp // @router /list [get] func (this *ReportController) ListReport() { br := new(models.BaseResponse).Init() defer func() { this.Data["json"] = br this.ServeJSON() }() pageSize, _ := this.GetInt("PageSize") currentIndex, _ := this.GetInt("CurrentIndex") timeType := this.GetString("TimeType") startDate := this.GetString("StartDate") endDate := this.GetString("EndDate") frequency := this.GetString("Frequency") classifyIdFirst, _ := this.GetInt("ClassifyIdFirst", 0) classifyIdSecond, _ := this.GetInt("ClassifyIdSecond", 0) classifyIdThird, _ := this.GetInt("ClassifyIdThird", 0) state, _ := this.GetInt("State") keyWord := this.GetString("KeyWord") msgIsSend, _ := this.GetInt("MsgIsSend") filterReportType, _ := this.GetInt("FilterReportType", 1) var startSize int if pageSize <= 0 { pageSize = utils.PageSize20 } if currentIndex <= 0 { currentIndex = 1 } startSize = utils.StartIndex(currentIndex, pageSize) if timeType == "" { timeType = "publish_time" } if timeType != "publish_time" && timeType != "modify_time" && timeType != "approve_time" { br.Msg = "请选择正确的时间" br.ErrMsg = "请选择正确的时间" return } var condition string var pars []interface{} if keyWord != "" { condition += ` AND (a.title LIKE ? OR a.admin_real_name LIKE ? ) ` pars = utils.GetLikeKeywordPars(pars, keyWord, 2) } if startDate != "" { condition += ` AND a.` + timeType + ` >= ? ` pars = append(pars, startDate) } if endDate != "" { condition += ` AND a.` + timeType + ` <= ? ` pars = append(pars, endDate) } if frequency != "" { condition += ` AND a.frequency = ? ` pars = append(pars, frequency) } if classifyIdFirst > 0 { condition += ` AND a.classify_id_first = ? ` pars = append(pars, classifyIdFirst) } if classifyIdSecond > 0 { condition += ` AND a.classify_id_second = ? ` pars = append(pars, classifyIdSecond) } if classifyIdThird > 0 { condition += ` AND a.classify_id_third = ? ` pars = append(pars, classifyIdSecond) } if state > 0 { condition += ` AND a.state = ? ` pars = append(pars, state) } // 消息是否已推送 1-未推送; 2-已推送 if msgIsSend == 1 { condition += ` AND (a.msg_is_send = 0 OR a.ths_msg_is_send = 0) ` } if msgIsSend == 2 { condition += ` AND a.msg_is_send = 1 AND a.ths_msg_is_send = 1 ` } var err error var total int var list []*models.ReportList switch filterReportType { // 筛选报告类型,1:公共研报,2:共享研报,3:我的研报 case 1: condition += ` AND a.is_public_publish = ? ` // TODO 临时使用,提测上线前得打开注释 //condition += ` AND a.state in (2,6) ` pars = append(pars, 1) case 3: condition += ` AND a.admin_id = ? ` pars = append(pars, this.SysUser.AdminId) case 2: condition += ` AND (a.admin_id = ? or b.admin_id = ?) ` pars = append(pars, this.SysUser.AdminId, this.SysUser.AdminId) } // 共享报告需要连表查询,所以需要单独写 if filterReportType == 2 { total, err = models.GetReportListCountByGrant(condition, pars) if err != nil { br.Msg = "获取失败" br.ErrMsg = "获取失败,Err:" + err.Error() return } list, err = models.GetReportListByGrant(condition, pars, startSize, pageSize) if err != nil { br.Msg = "获取失败" br.ErrMsg = "获取失败,Err:" + err.Error() return } } else { total, err = models.GetReportListCountV1(condition, pars) if err != nil { br.Msg = "获取失败" br.ErrMsg = "获取失败,Err:" + err.Error() return } list, err = models.GetReportListV1(condition, pars, startSize, pageSize) if err != nil { br.Msg = "获取失败" br.ErrMsg = "获取失败,Err:" + err.Error() return } } listLen := len(list) if listLen > 0 { pvMap := make(map[int]int) uvMap := make(map[int]int) reportIdArr := make([]string, 0) syncReportIdArr := make([]string, 0) // 同步过来的报告IDs oldAndNewReportIdMap := make(map[int]int) // 旧报告和新报告的id对应关系 for i := 0; i < listLen; i++ { reportIdArr = append(reportIdArr, strconv.Itoa(list[i].Id)) if list[i].OldReportId > 0 { syncReportIdArr = append(syncReportIdArr, strconv.Itoa(list[i].OldReportId)) oldAndNewReportIdMap[list[i].OldReportId] = list[i].Id } pvMap[list[i].Id] = list[i].Pv uvMap[list[i].Id] = list[i].Uv } // 当下报告的pv,uv if len(reportIdArr) > 0 { pvList, e := models.GetReportPvUvByReportIdList(reportIdArr) if e != nil { br.Msg = "获取失败" br.ErrMsg = "获取同步报告对应的PV、UV失败, Err: " + e.Error() return } for _, v := range pvList { pv := pvMap[v.ReportId] uv := uvMap[v.ReportId] pvMap[v.ReportId] = v.PvTotal + pv uvMap[v.ReportId] = v.UvTotal + uv } } //reportIds := strings.Join(reportIdArr, ",") //syncReportIds := strings.Join(syncReportIdArr, ",") // 查询同步过来的报告对应的老报告PV+UV if len(syncReportIdArr) > 0 { puvList, e := models.GetPUVByResearchReportIds(syncReportIdArr) if e != nil { br.Msg = "获取失败" br.ErrMsg = "获取同步报告对应的PV、UV失败, Err: " + e.Error() return } puvLen := len(puvList) for i := 0; i < puvLen; i++ { newReportId, ok := oldAndNewReportIdMap[puvList[i].ResearchReportId] if ok { pv := pvMap[newReportId] uv := uvMap[newReportId] pvMap[newReportId] = puvList[i].Pv + pv uvMap[newReportId] = puvList[i].Uv + uv } } } // 晨周报音频列表 videoList, err := models.GetReportChapterVideoListByReportIds(reportIdArr) if err != nil { br.Msg = "获取失败" br.ErrMsg = "获取报告音频文件失败,Err:" + err.Error() return } for i := 0; i < listLen; i++ { list[i].Content = html.UnescapeString(list[i].Content) list[i].ContentSub = html.UnescapeString(list[i].ContentSub) // 除周报外其余报告均可推送客群 list[i].NeedThsMsg = 1 //if list[i].HasChapter == 1 && list[i].ChapterType == utils.REPORT_TYPE_WEEK { // list[i].NeedThsMsg = 0 //} chapterList := make([]*models.ReportChapterVideoList, 0) for ii := 0; ii < len(videoList); ii++ { if list[i].Id == videoList[ii].ReportId { chapterList = append(chapterList, videoList[ii]) } } list[i].ChapterVideoList = chapterList list[i].Pv += pvMap[list[i].Id] list[i].Uv += uvMap[list[i].Id] } } for _, item := range list { /*key := fmt.Sprint(`crm:report:edit:`, item.Id) opUserId, _ := utils.Rc.RedisInt(key) //如果当前没有人操作,获取当前操作人是本人,那么编辑按钮可用 if opUserId <= 0 || (opUserId == this.SysUser.AdminId) || item.ClassifyNameFirst == "周报" || item.ClassifyNameFirst == "晨报" { item.CanEdit = true } else { adminInfo, errAdmin := system.GetSysUserById(opUserId) if errAdmin != nil { br.Msg = "获取失败" br.ErrMsg = "获取失败,Err:" + errAdmin.Error() return } item.Editor = adminInfo.RealName }*/ if item.HasChapter == 1 { item.CanEdit = true continue } markStatus, err := services.UpdateReportEditMark(item.Id, 0, this.SysUser.AdminId, 2, this.SysUser.RealName, this.Lang) if err != nil { br.Msg = "查询标记状态失败" br.ErrMsg = "查询标记状态失败,Err:" + err.Error() return } if markStatus.Status == 0 { item.CanEdit = true } else { item.Editor = markStatus.Editor } } page := paging.GetPaging(currentIndex, pageSize, total) resp := new(models.ReportListResp) resp.Paging = page resp.List = list br.Ret = 200 br.Success = true br.Msg = "获取成功" br.Data = resp } // Add // @Title 新增报告接口 // @Description 新增报告(不区分报告类型) // @Param request body models.AddReq true "type json string" // @Success 200 {object} models.AddResp // @router /add [post] func (this *ReportController) Add() { br := new(models.BaseResponse).Init() defer func() { this.Data["json"] = br this.ServeJSON() }() sysUser := this.SysUser if sysUser == nil { br.Msg = "请登录" br.ErrMsg = "请登录,SysUser Is Empty" br.Ret = 408 return } var req models.AddReq err := json.Unmarshal(this.Ctx.Input.RequestBody, &req) if err != nil { br.Msg = "参数解析异常!" br.ErrMsg = "参数解析失败,Err:" + err.Error() return } if req.Title == `` { br.Msg = "标题不能为空" br.ErrMsg = "标题不能为空" br.IsSendEmail = false return } if req.ClassifyIdFirst <= 0 { br.Msg = "分类必填" br.ErrMsg = "分类必填" br.IsSendEmail = false return } var contentSub string if req.Content != "" { e := utils.ContentXssCheck(req.Content) if e != nil { br.Msg = "存在非法标签" br.ErrMsg = "存在非法标签, Err: " + e.Error() return } content, e := services.FilterReportContentBr(req.Content) if e != nil { br.Msg = "内容去除前后空格失败" br.ErrMsg = "内容去除前后空格失败, Err: " + e.Error() return } req.Content = content contentSub, err = services.GetReportContentSub(req.Content) if err != nil { go alarm_msg.SendAlarmMsg("ContentSub 失败,Err:"+err.Error(), 3) //utils.SendEmail(utils.APPNAME+"失败提醒", "解析 ContentSub 失败,Err:"+err.Error(), utils.EmailSendToUsers) } } // 报告期数 maxStage, err := models.GetReportStage(req.ClassifyIdFirst, req.ClassifyIdSecond, req.ClassifyIdThird) if err != nil { br.Msg = "期数获取失败!" br.ErrMsg = "期数获取失败,Err:" + err.Error() return } // 根据审批开关及审批流判断当前报告状态 state, e := services.CheckReportCurrState(report_approve.FlowReportTypeChinese, req.ClassifyIdFirst, req.ClassifyIdSecond, models.ReportOperateAdd) if e != nil { br.Msg = "操作失败" br.ErrMsg = "校验报告当前状态失败, Err: " + e.Error() return } // 协作方式,1:个人,2:多人协作。默认:1 if req.CollaborateType == 0 { req.CollaborateType = 1 } // 报告布局,1:常规布局,2:智能布局。默认:1 if req.ReportLayout == 0 { req.ReportLayout = 1 } // 是否公开发布,1:是,2:否 if req.IsPublicPublish == 0 { req.IsPublicPublish = 1 } item := new(models.Report) item.AddType = req.AddType item.ReportVersion = 2 item.ClassifyIdFirst = req.ClassifyIdFirst item.ClassifyNameFirst = req.ClassifyNameFirst item.ClassifyIdSecond = req.ClassifyIdSecond item.ClassifyNameSecond = req.ClassifyNameSecond item.Title = req.Title item.Abstract = req.Abstract item.Author = req.Author item.Frequency = req.Frequency item.State = state item.Content = html.EscapeString(req.Content) item.Stage = maxStage + 1 item.ContentSub = html.EscapeString(contentSub) item.CreateTime = req.CreateTime item.ModifyTime = time.Now() item.ReportVersion = req.ReportVersion item.AdminId = sysUser.AdminId item.AdminRealName = sysUser.RealName item.ClassifyIdThird = req.ClassifyIdThird item.ClassifyNameThird = req.ClassifyNameThird // 产品要求,如果是多人协作,那么就是章节类型的报告 if req.CollaborateType == 2 { item.HasChapter = 1 item.ChapterType = "" } item.LastModifyAdminId = sysUser.AdminId item.LastModifyAdminName = sysUser.RealName item.ContentModifyTime = time.Now() item.NeedSplice = 0 item.ContentStruct = html.EscapeString(req.ContentStruct) item.HeadImg = req.HeadImg item.EndImg = req.EndImg item.CanvasColor = req.CanvasColor item.HeadResourceId = req.HeadResourceId item.EndResourceId = req.EndResourceId item.CollaborateType = req.CollaborateType item.ReportLayout = req.ReportLayout item.IsPublicPublish = req.IsPublicPublish item.ReportCreateTime = time.Now() err, errMsg := services.AddReportAndChapter(item, req.InheritReportId, req.GrantAdminIdList) if err != nil { br.Msg = "保存失败" if errMsg != "" { br.Msg = errMsg } br.ErrMsg = "保存失败,Err:" + err.Error() return } recordItem := &models.ReportStateRecord{ ReportId: item.Id, ReportType: 1, State: 1, AdminId: this.SysUser.AdminId, AdminName: this.SysUser.AdminName, CreateTime: time.Now(), } go func() { _, _ = models.AddReportStateRecord(recordItem) }() resp := new(models.AddResp) resp.ReportId = int64(item.Id) resp.ReportCode = item.ReportCode br.Ret = 200 br.Success = true br.Msg = "保存成功" br.Data = resp } // Edit // @Title 编辑报告基础信息接口 // @Description 编辑报告基础信息(不区分报告类型) // @Param request body models.EditReq true "type json string" // @Success 200 {object} models.EditResp // @router /edit [post] func (this *ReportController) Edit() { br := new(models.BaseResponse).Init() defer func() { this.Data["json"] = br this.ServeJSON() }() sysUser := this.SysUser if sysUser == nil { br.Msg = "请登录" br.ErrMsg = "请登录,SysUser Is Empty" br.Ret = 408 return } var req models.EditReq err := json.Unmarshal(this.Ctx.Input.RequestBody, &req) if err != nil { br.Msg = "参数解析异常!" br.ErrMsg = "参数解析失败,Err:" + err.Error() return } //if req.Content == "" { // br.Msg = "报告内容不能为空" // return //} //更新标记key markStatus, err := services.UpdateReportEditMark(int(req.ReportId), 0, sysUser.AdminId, 1, sysUser.RealName, this.Lang) if err != nil { br.Msg = err.Error() return } if markStatus.Status == 1 { br.Msg = markStatus.Msg //br.Ret = 202 //202 服务器已接受请求,但尚未处理。 return } reportInfo, e := models.GetReportByReportId(int(req.ReportId)) if e != nil { if e.Error() == utils.ErrNoRow() { br.Msg = "报告已被删除, 请刷新页面" return } br.Msg = "操作失败" br.ErrMsg = "获取报告失败, Err: " + e.Error() return } if reportInfo.State == models.ReportStatePublished || reportInfo.State == models.ReportStatePass { br.Msg = "该报告已发布,不允许编辑" br.ErrMsg = "该报告已发布,不允许编辑" return } // 编辑报告信息 err, errMsg := services.EditReport(reportInfo, req, sysUser) if err != nil { br.Msg = "保存失败" if errMsg != "" { br.Msg = errMsg } br.ErrMsg = "保存失败,Err:" + err.Error() return } reportCode := utils.MD5(strconv.Itoa(int(req.ReportId))) resp := new(models.EditResp) resp.ReportId = req.ReportId resp.ReportCode = reportCode br.Ret = 200 br.Success = true br.Msg = "保存成功" br.Data = resp } // Detail // @Title 获取报告详情接口 // @Description 获取报告详情 // @Param request body models.ReportDetailReq true "type json string" // @Success 200 {object} models.Report // @router /detail [get] func (this *ReportController) Detail() { br := new(models.BaseResponse).Init() defer func() { this.Data["json"] = br this.ServeJSON() }() /*var req models.ReportDetailReq err := json.Unmarshal(this.Ctx.Input.RequestBody, &req) if err != nil { br.Msg = "参数解析异常!" br.ErrMsg = "参数解析失败,Err:" + err.Error() return } if req.ReportId <= 0 { br.Msg = "参数错误" return }*/ reportId, err := this.GetInt("ReportId") if err != nil { br.Msg = "获取参数失败!" br.ErrMsg = "获取参数失败,Err:" + err.Error() return } if reportId <= 0 { br.Msg = "参数错误" return } item, err := models.GetReportById(reportId) if err != nil { if err.Error() == utils.ErrNoRow() { br.Msg = "报告已被删除" return } br.Msg = "获取失败" br.ErrMsg = "获取失败,Err:" + err.Error() return } chapterList := make([]*models.ReportChapter, 0) if item.HasChapter == 1 { // 获取章节内容 tmpChapterList, err := models.GetPublishedChapterListByReportId(item.Id) if err != nil { br.Msg = "获取失败" br.ErrMsg = "获取晨/周报章节列表失败, Err: " + err.Error() return } // TODO 更新规则 if len(tmpChapterList) > 0 { // 获取更新规则 researchType := tmpChapterList[0].ReportType chapterTypeList, tmpErr := models.GetAllReportChapterTypeListByResearchType(researchType) if tmpErr != nil { br.Msg = "获取更新规则失败" br.ErrMsg = "获取更新规则失败, Err: " + tmpErr.Error() return } // 调整章节更新 nowTime := time.Now().Local() for _, item := range tmpChapterList { stop := false for _, rule := range chapterTypeList { if rule.ReportChapterTypeId == item.TypeId { //fmt.Println("rule.Enabled :", rule.Enabled, ";name=", rule.ReportChapterTypeName, "item.IsEdit:", item.IsEdit, "rule.IsSet:", rule.IsSet) // 如果被永久暂停更新了 if rule.Enabled == 0 && item.IsEdit == 0 { //该章节已被永久禁用,同时未被操作过 stop = true } else if rule.PauseStartTime != "" && rule.PauseEndTime != "" && rule.PauseStartTime != utils.EmptyDateStr && rule.PauseEndTime != utils.EmptyDateStr { startTime, timeErr := time.ParseInLocation(utils.FormatDate, rule.PauseStartTime, time.Local) if timeErr != nil { br.Msg = "获取更新规则失败" br.ErrMsg = "更新规则时间转换失败4001, Err: " + timeErr.Error() return } endTime, timeErr := time.ParseInLocation(utils.FormatDate, rule.PauseEndTime, time.Local) if timeErr != nil { br.Msg = "获取更新规则失败" br.ErrMsg = "更新规则时间转换失败4002, Err: " + timeErr.Error() return } // 暂停更新 if nowTime.After(startTime) && nowTime.Before(endTime.AddDate(0, 0, 1)) { stop = true } break } } } if !stop { item.Content = html.UnescapeString(item.Content) item.ContentSub = html.UnescapeString(item.ContentSub) chapterList = append(chapterList, item) } } } item.Abstract = item.Title } item.Content = html.UnescapeString(item.Content) item.ContentSub = html.UnescapeString(item.ContentSub) resp := &models.ReportDetailView{ ReportDetail: item, ChapterList: chapterList, } br.Ret = 200 br.Success = true br.Msg = "获取成功" br.Data = resp } // SaveReportContent // @Title 保存草稿 // @Description 保存草稿 // @Param request body models.SaveReportContent true "type json string" // @Success 200 {object} models.ReportAuthorResp // @router /saveReportContent [post] func (this *ReportController) SaveReportContent() { br := new(models.BaseResponse).Init() br.IsSendEmail = false defer func() { this.Data["json"] = br this.ServeJSON() }() sysUser := this.SysUser if sysUser == nil { br.Msg = "请登录" br.ErrMsg = "请登录,SysUser Is Empty" br.Ret = 408 return } var req models.SaveReportContent err := json.Unmarshal(this.Ctx.Input.RequestBody, &req) if err != nil { br.Msg = "参数解析异常!" br.ErrMsg = "参数解析失败,Err:" + err.Error() return } reportId := req.ReportId noChangeFlag := req.NoChange if reportId <= 0 { resp := new(models.SaveReportContentResp) resp.ReportId = reportId br.Ret = 200 br.Success = true br.Msg = "保存成功" br.Data = resp return } // 获取报告详情 reportInfo, _ := models.GetReportByReportId(int(req.ReportId)) if reportInfo != nil && reportInfo.State == 2 { br.Msg = "该报告已发布,不允许编辑" br.ErrMsg = "该报告已发布,不允许编辑" return } // 标记更新中 { markStatus, err := services.UpdateReportEditMark(int(req.ReportId), 0, sysUser.AdminId, 1, sysUser.RealName, this.Lang) if err != nil { br.Msg = err.Error() return } if markStatus.Status == 1 { br.Msg = markStatus.Msg return } } // 内容有过修改的话,那么逻辑处理 if noChangeFlag != 1 { content := req.Content if content == "" { content = this.GetString("Content") } if content != "" { e := utils.ContentXssCheck(req.Content) if e != nil { br.Msg = "存在非法标签" br.ErrMsg = "存在非法标签, Err: " + e.Error() return } contentClean, e := services.FilterReportContentBr(req.Content) if e != nil { br.Msg = "内容去除前后空格失败" br.ErrMsg = "内容去除前后空格失败, Err: " + e.Error() return } content = contentClean contentSub, err := services.GetReportContentSub(content) if err != nil { go alarm_msg.SendAlarmMsg("解析 ContentSub 失败,Err:"+err.Error(), 3) //utils.SendEmail(utils.APPNAME+"失败提醒", "解析 ContentSub 失败,Err:"+err.Error(), utils.EmailSendToUsers) } reportInfo.Content = html.EscapeString(content) reportInfo.ContentSub = html.EscapeString(contentSub) reportInfo.ContentStruct = html.EscapeString(req.ContentStruct) reportInfo.HeadImg = req.HeadImg reportInfo.EndImg = req.EndImg reportInfo.CanvasColor = req.CanvasColor reportInfo.HeadResourceId = req.HeadResourceId reportInfo.EndResourceId = req.EndResourceId reportInfo.ModifyTime = time.Now() reportInfo.ContentModifyTime = time.Now() updateCols := []string{"Content", "ContentSub", "HeadImg", "EndImg", "CanvasColor", "HeadResourceId", "EndResourceId", "ModifyTime", "ContentModifyTime"} err = reportInfo.UpdateReport(updateCols) if err != nil { br.Msg = "保存失败" br.ErrMsg = "保存失败,Err:" + err.Error() return } go models.AddReportSaveLog(reportId, this.SysUser.AdminId, reportInfo.Content, reportInfo.ContentSub, reportInfo.ContentStruct, reportInfo.CanvasColor, this.SysUser.AdminName, reportInfo.HeadResourceId, reportInfo.EndResourceId) } } resp := new(models.SaveReportContentResp) resp.ReportId = reportId br.Ret = 200 br.Success = true br.Msg = "保存成功" br.Data = resp } // PublishDayWeekReportChapter // @Title 发布晨周报章节 // @Description 发布晨周报章节 // @Param request body models.PublishReportChapterReq true "type json string" // @Success 200 Ret=200 操作成功 // @router /publishDayWeekReportChapter [post] func (this *ReportController) PublishDayWeekReportChapter() { br := new(models.BaseResponse).Init() defer func() { this.Data["json"] = br this.ServeJSON() }() sysUser := this.SysUser if sysUser == nil { br.Msg = "请登录" br.ErrMsg = "请登录,SysUser Is Empty" br.Ret = 408 return } var req models.PublishReportChapterReq err := json.Unmarshal(this.Ctx.Input.RequestBody, &req) if err != nil { br.Msg = "参数解析异常!" br.ErrMsg = "参数解析失败,Err:" + err.Error() return } if req.ReportChapterId <= 0 { br.Msg = "参数有误" return } if req.Title == "" { br.Msg = "请输入标题" return } if req.Content == "" { br.Msg = "请输入内容" return } if req.AddType == 0 { br.Msg = "请选择新增方式" return } reqTickerList := req.TickerList chapterInfo, err := models.GetReportChapterInfoById(req.ReportChapterId) if err != nil { br.Msg = "章节信息有误" br.ErrMsg = "获取章节信息失败, Err: " + err.Error() return } reportInfo, err := models.GetReportById(chapterInfo.ReportId) if err != nil { br.Msg = "查询报告有误" br.ErrMsg = "查询报告信息失败, Err: " + err.Error() return } if reportInfo.State == 2 { br.Msg = "该报告已发布,不允许编辑" br.ErrMsg = "该报告已发布,不允许编辑" return } // 图表刷新状态 refreshResult := data.CheckBatchChartRefreshResult("report", chapterInfo.ReportId, chapterInfo.ReportChapterId) if !refreshResult { br.Msg = "图表刷新未完成,请稍后操作" br.ErrMsg = "图表刷新未完成,请稍后操作" br.IsSendEmail = false return } // 获取规则配置 reportChapterTypeRule, err := models.GetReportChapterTypeById(chapterInfo.TypeId) if err != nil { br.Msg = "获取配置信息异常" br.ErrMsg = "获取配置信息异常, Err: " + err.Error() return } if reportChapterTypeRule.Enabled == 0 { br.Msg = "该章节已永久停更" br.ErrMsg = "该章节已永久停更 " br.IsSendEmail = false return } updateCols := make([]string, 0) updateCols = append(updateCols, "Title", "AddType", "Author", "Content", "ContentSub", "IsEdit", "CreateTime", "PublishState", "PublishTime") var needHandleVideo bool // 是否需要处理音频文件 nowTime := time.Now() var publishTime time.Time if reportInfo.MsgIsSend == 1 && reportInfo.PublishTime != "" { //如果报告曾经发布过,并且已经发送过模版消息,则章节的发布时间为报告的发布时间 publishTime, _ = time.ParseInLocation(utils.FormatDateTime, reportInfo.PublishTime, time.Local) } else { publishTime = time.Now() } if req.VideoUrl != "" { chapterInfo.VideoUrl = req.VideoUrl chapterInfo.VideoName = req.VideoName chapterInfo.VideoSize = req.VideoSize chapterInfo.VideoPlaySeconds = req.VideoPlaySeconds chapterInfo.VideoKind = 1 updateCols = append(updateCols, "VideoUrl", "VideoName", "VideoSize", "VideoPlaySeconds", "VideoKind") // 手动上传的音频需要处理音频文件 needHandleVideo = true } else { if chapterInfo.VideoUrl == "" { // 生成video videoUrl, videoName, videoSize, videoPlaySeconds, err := services.CreateReportVideo(req.Title, req.Content, publishTime.Format(utils.FormatDateTime)) if err != nil { br.Msg = "生成video失败" br.ErrMsg = "生成video失败, Err: " + err.Error() return } chapterInfo.VideoUrl = videoUrl chapterInfo.VideoName = videoName chapterInfo.VideoSize = videoSize chapterInfo.VideoPlaySeconds = fmt.Sprintf("%.2f", videoPlaySeconds) chapterInfo.VideoKind = 2 updateCols = append(updateCols, "VideoUrl", "VideoName", "VideoSize", "VideoPlaySeconds", "VideoKind") } } // 更新章节信息 contentSub := "" if req.Content != "" { e := utils.ContentXssCheck(req.Content) if e != nil { br.Msg = "存在非法标签" br.ErrMsg = "存在非法标签, Err: " + e.Error() return } contentClean, e := services.FilterReportContentBr(req.Content) if e != nil { br.Msg = "内容去除前后空格失败" br.ErrMsg = "内容去除前后空格失败, Err: " + e.Error() return } req.Content = contentClean contentSub, err = services.GetReportContentSub(req.Content) if err != nil { br.Msg = "内容分段解析失败" br.ErrMsg = "编辑报告章节-解析 ContentSub 失败, Err: " + err.Error() return } } chapterInfo.Title = req.Title chapterInfo.AddType = req.AddType chapterInfo.Author = req.Author chapterInfo.Content = html.EscapeString(req.Content) chapterInfo.ContentSub = html.EscapeString(contentSub) chapterInfo.IsEdit = 1 chapterInfo.CreateTime = req.CreateTime chapterInfo.PublishState = 2 chapterInfo.PublishTime = publishTime // 晨报更新指标 tickerList := make([]*models.ReportChapterTicker, 0) if chapterInfo.ReportType == "day" && len(reqTickerList) > 0 { for i := 0; i < len(reqTickerList); i++ { tickerList = append(tickerList, &models.ReportChapterTicker{ ReportChapterId: chapterInfo.ReportChapterId, Sort: reqTickerList[i].Sort, Ticker: reqTickerList[i].Ticker, CreateTime: nowTime, UpdateTime: nowTime, }) } } if err = models.UpdateChapterAndTicker(chapterInfo, updateCols, tickerList); err != nil { br.Msg = "发布失败" br.ErrMsg = "报告章节内容保存失败, Err: " + err.Error() return } // 更新章节ES { go services.UpdateReportChapterEs(chapterInfo.ReportChapterId) } // 同时发布报告 if req.PublishReport == 1 { if _, e := services.PublishDayWeekReport(chapterInfo.ReportId); e != nil { br.Msg = "章节发布成功,报告发布失败,请手动发布报告" br.ErrMsg = "发布晨/周报失败, Err: " + e.Error() return } } // 处理报告中的音频文件分贝 if needHandleVideo { go services.HandleVideoDecibel(chapterInfo) } br.Ret = 200 br.Success = true br.Msg = "操作成功" } // AuthorizedListReport // @Title 获取有权限的报告列表接口 // @Description 获取有权限的报告列表接口 // @Param PageSize query int true "每页数据条数" // @Param CurrentIndex query int true "当前页页码,从1开始" // @Param Keyword query string true "搜索关键词" // @Param ClassifyIdFirst query int true "一级分类id" // @Param ClassifyIdSecond query int true "二级分类id" // @Param ClassifyIdThird query int true "三级分类id" // @Success 200 {object} models.ReportListResp // @router /list/authorized [get] func (this *ReportController) AuthorizedListReport() { br := new(models.BaseResponse).Init() defer func() { this.Data["json"] = br this.ServeJSON() }() pageSize, _ := this.GetInt("PageSize") currentIndex, _ := this.GetInt("CurrentIndex") keyword := this.GetString("Keyword") classifyIdFirst, _ := this.GetInt("ClassifyIdFirst", 0) classifyIdSecond, _ := this.GetInt("ClassifyIdSecond", 0) classifyIdThird, _ := this.GetInt("ClassifyIdThird", 0) var startSize int if pageSize <= 0 { pageSize = utils.PageSize20 } if currentIndex <= 0 { currentIndex = 1 } startSize = utils.StartIndex(currentIndex, pageSize) var list []*models.ReportList // 没有输入信息,那就不展示 if keyword == `` && classifyIdFirst <= 0 { page := paging.GetPaging(currentIndex, pageSize, 0) resp := new(models.ReportListResp) resp.Paging = page resp.List = list br.Ret = 200 br.Success = true br.Msg = "获取成功" br.Data = resp return } // 当前用户有权限的报告id列表 grantReportIdList := make([]int, 0) { obj := report.ReportGrant{} grantList, err := obj.GetGrantListByAdminId(this.SysUser.AdminId) if err != nil { br.Msg = "获取失败" br.ErrMsg = "获取授权报告id失败,Err:" + err.Error() return } for _, v := range grantList { grantReportIdList = append(grantReportIdList, v.ReportId) } } var condition string var pars []interface{} if classifyIdFirst > 0 { condition += ` AND a.classify_id_first = ? ` pars = append(pars, classifyIdFirst) } if classifyIdSecond > 0 { condition += ` AND a.classify_id_second = ? ` pars = append(pars, classifyIdSecond) } if classifyIdThird > 0 { condition += ` AND a.classify_id_third = ? ` pars = append(pars, classifyIdSecond) } if keyword != `` { condition += ` AND a.title LIKE ? ` pars = utils.GetLikeKeywordPars(pars, keyword, 1) } var err error var total int orCondition := `AND ( (a.is_public_publish = ? AND a.state in (2,6)) or a.admin_id = ? ` pars = append(pars, 1, this.SysUser.AdminId) // 当前用户有权限的报告id列表 num := len(grantReportIdList) if num > 0 { orCondition += ` OR a.id in (` + utils.GetOrmInReplace(num) + `)` pars = append(pars, grantReportIdList) } orCondition += ` ) ` condition += orCondition total, err = models.GetReportListCountByAuthorized(condition, pars) if err != nil { br.Msg = "获取失败" br.ErrMsg = "获取失败,Err:" + err.Error() return } list, err = models.GetReportListByAuthorized(condition, pars, startSize, pageSize) if err != nil { br.Msg = "获取失败" br.ErrMsg = "获取失败,Err:" + err.Error() return } //for _, item := range list { // if item.HasChapter == 1 { // item.CanEdit = true // } else { // markStatus, err := services.UpdateReportEditMark(item.Id, this.SysUser.AdminId, 2, this.SysUser.RealName, this.Lang) // if err != nil { // br.Msg = "查询标记状态失败" // br.ErrMsg = "查询标记状态失败,Err:" + err.Error() // return // } // if markStatus.Status == 0 { // item.CanEdit = true // } else { // item.Editor = markStatus.Editor // } // } //} page := paging.GetPaging(currentIndex, pageSize, total) resp := new(models.ReportListResp) resp.Paging = page resp.List = list br.Ret = 200 br.Success = true br.Msg = "获取成功" br.Data = resp } // BaseDetail // @Title 获取报告基础信息详情接口 // @Description 获取报告基础信息详情接口 // @Param request body models.ReportDetailReq true "type json string" // @Success 200 {object} models.Report // @router /detail/base [get] func (this *ReportController) BaseDetail() { br := new(models.BaseResponse).Init() defer func() { this.Data["json"] = br this.ServeJSON() }() /*var req models.ReportDetailReq err := json.Unmarshal(this.Ctx.Input.RequestBody, &req) if err != nil { br.Msg = "参数解析异常!" br.ErrMsg = "参数解析失败,Err:" + err.Error() return } if req.ReportId <= 0 { br.Msg = "参数错误" return }*/ reportId, err := this.GetInt("ReportId") if err != nil { br.Msg = "获取参数失败!" br.ErrMsg = "获取参数失败,Err:" + err.Error() return } if reportId <= 0 { br.Msg = "参数错误" return } reportInfo, err := models.GetReportById(reportId) if err != nil { if err.Error() == utils.ErrNoRow() { br.Msg = "报告已被删除" return } br.Msg = "获取失败" br.ErrMsg = "获取失败,Err:" + err.Error() return } // 基础信息就不获取章节信息了 chapterList := make([]*models.ReportChapter, 0) reportInfo.Content = html.UnescapeString(reportInfo.Content) reportInfo.ContentSub = html.UnescapeString(reportInfo.ContentSub) grandAdminList := make([]models.ReportDetailViewAdmin, 0) permissionList := make([]models.ReportDetailViewPermission, 0) // 处理报告授权用户列表 { obj := report.ReportGrant{} grantList, tmpErr := obj.GetGrantListById(reportId) if tmpErr != nil { br.Msg = "获取章节id授权用户列表失败" br.ErrMsg = "获取章节id授权用户列表失败, Err: " + tmpErr.Error() return } if len(grantList) > 0 { grandAdminIdList := make([]int, 0) for _, v := range grantList { grandAdminIdList = append(grandAdminIdList, v.AdminId) } adminList, tmpErr := system.GetAdminListByIdList(grandAdminIdList) if tmpErr != nil { br.Msg = "获取章节id授权用户列表失败" br.ErrMsg = "获取章节id授权用户列表失败, Err: " + tmpErr.Error() return } for _, v := range adminList { grandAdminList = append(grandAdminList, models.ReportDetailViewAdmin{ AdminId: v.AdminId, AdminName: v.RealName, }) } } } // 处理章节id关联品种id列表 { minClassifyId := reportInfo.ClassifyIdThird if minClassifyId <= 0 { minClassifyId = reportInfo.ClassifyIdSecond } if minClassifyId <= 0 { minClassifyId = reportInfo.ClassifyIdFirst } if minClassifyId <= 0 { br.Msg = "分类异常" br.ErrMsg = "分类异常" return } // 获取分类关联的品种id classifyPermissionList, tmpErr := models.GetPermission(minClassifyId) if tmpErr != nil { br.Msg = "获取分类信息失败" br.ErrMsg = "获取失败,Err:" + tmpErr.Error() return } if len(classifyPermissionList) > 0 { permissionIdList := make([]int, 0) for _, v := range classifyPermissionList { permissionIdList = append(permissionIdList, v.ChartPermissionId) } adminList, tmpErr := models.GetChartPermissionByIdList(permissionIdList) if tmpErr != nil { br.Msg = "获取章节id授权用户列表失败" br.ErrMsg = "获取章节id授权用户列表失败, Err: " + tmpErr.Error() return } for _, v := range adminList { permissionList = append(permissionList, models.ReportDetailViewPermission{ PermissionId: v.ChartPermissionId, PermissionName: v.ChartPermissionName, }) } } } resp := &models.ReportDetailView{ ReportDetail: reportInfo, ChapterList: chapterList, GrandAdminList: grandAdminList, PermissionList: permissionList, } br.Ret = 200 br.Success = true br.Msg = "获取成功" br.Data = resp }