eta_mini_ht_api/models/eta/eta_report.go

package eta

import (
	"eta/eta_mini_ht_api/models"
	"strings"
	"time"
)

const (
	colunms      = "id,author,abstract,title,publish_time,"
	detailColumn = "id,author,abstract,title,publish_time,content,collaborate_type,report_layout,video_url,video_name,video_play_seconds,head_resource_id,end_resource_id,has_chapter,need_splice"
	published    = 2
	passed       = 6

	limit                                  = 500
	TlbChartPermissionSearchKeyWordMapping = "chart_permission_search_key_word_mapping"
)

var (
	classifyIds = []string{"classify_id_third", "classify_id_second", "classify_id_first"}
)

func (ETAReport) TableName() string {
	return "report"
}

type ETAReport struct {
	ID               int    `gorm:"primary_key;auto_increment"`
	ClassifyID       int    `gorm:"_"`
	ClassifyIDFirst  int    `gorm:"column:classify_id_first;default:0"`
	ClassifyIDSecond int    `gorm:"column:classify_id_second;default:0"`
	ClassifyIDThird  int    `gorm:"column:classify_id_third;default:0"`
	Title            string `gorm:"column:title;size:125;"`
	Abstract         string `gorm:"column:abstract;size:255;"`
	Author           string `gorm:"column:author;size:50;"`
	PublishTime      string `gorm:"column:publish_time"`
	Content          string `gorm:"column:content"`
	CollaborateType  int    `gorm:"column:collaborate_type"`
	ReportLayout     int    `gorm:"column:report_layout"`
	VideoUrl         string `gorm:"column:video_url"`
	VideoName        string `gorm:"column:video_name"`
	VideoPlaySeconds string `gorm:"column:video_play_seconds"`
	HeadResourceId   int    `gorm:"column:head_resource_id"`
	EndResourceId    int    `gorm:"column:end_resource_id"`
	HasChapter       bool   `gorm:"column:has_chapter"`
	NeedSplice       bool   `gorm:"column:need_splice"`
}

//type ReportClassify struct {
//	ClassifyID int `gorm:"column:classify_id" json:"classify_id"`
//	ReportPermission
//}

type ReportPermission struct {
	ChartPermissionID int `gorm:"primaryKey;autoIncrement;column:chart_permission_id;comment:主键"`
	ParentID          int `gorm:"size:11;default:0;column:parent_id;comment:父级权限id"`
}

func GetETAReports(id int) (reports []ETAReport, err error) {
	err = models.ETA().Table("report").Select(colunms+strings.Join(classifyIds, ",")).Where("state =? or state=?", published, passed).Where("id > ?", id).Order("id asc").Limit(limit).Find(&reports).Error
	if reports != nil {
		for i := 0; i < len(reports); i++ {
			setClassifyIdValue(&reports[i])
		}
	}
	return
}

func GetUpdateETAReports(id int) (reports []ETAReport, err error) {
	duration := time.Now().Add(-10 * time.Minute)
	err = models.ETA().Table("report").Select(colunms+strings.Join(classifyIds, ",")).Where("state =? or state=? and modify_time >=?", published, passed, duration).Where("id <= ?", id).Order("id asc").Find(&reports).Error
	if reports != nil {
		for _, report := range reports {
			setClassifyIdValue(&report)
		}
	}
	return
}
func GetETAReportById(id int) (report ETAReport, err error) {
	err = models.ETA().Table("report").Select(detailColumn).Where("id = ?", id).Where("state =? or state=?", published, passed).First(&report).Error
	return
}
func DoSql(sql string, result interface{}, values ...interface{}) (err error) {
	db := models.ETA()
	return db.Raw(sql, values...).Scan(&result).Error
}
func GetReportClassifyById(id int) (classifyId int, err error) {
	db := models.ETA()
	err = db.Table("report").
		Select("COALESCE(NULLIF(classify_id_third,0),NULLIF(classify_id_second,0),classify_id_first) classify_id").
		Where("id =?", id).Scan(&classifyId).Error
	return
}

func GetETAReportIdsByClassifyIds(classifyIds []int) (reportIds []int, err error) {
	db := models.ETA()
	err = db.Model(&ETAReport{}).Select("DISTINCT id").Where("COALESCE(NULLIF(classify_id_third,0),NULLIF(classify_id_second,0),classify_id_first) in (?)", classifyIds).Scan(&reportIds).Error
	return
}
func setClassifyIdValue(report *ETAReport) {
	if report.ClassifyIDThird > 0 {
		report.ClassifyID = report.ClassifyIDThird
		return
	}
	if report.ClassifyIDSecond > 0 {
		report.ClassifyID = report.ClassifyIDSecond
		return
	}
	report.ClassifyID = report.ClassifyIDFirst
}