| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960 |
- package report
- import (
- "eta/eta_email_analysis/global"
- "time"
- )
- type Classify struct {
- Id int `gorm:"column:id;primaryKey;autoIncrement"` // 注意：gorm 默认自增，所以 autoIncrement 可以省略
- ClassifyName string `gorm:"column:classify_name;size:125;default:'';comment:'分类名称'"`
- Sort int `gorm:"column:sort;type:tinyint;default:0;comment:'排序'"`
- ParentId int `gorm:"column:parent_id;default:0;comment:'父级分类id'"`
- CreateTime time.Time `gorm:"column:create_time;comment:'创建时间'"`
- ModifyTime time.Time `gorm:"column:modify_time;comment:'修改时间'"`
- Abstract string `gorm:"column:abstract;size:500;default:'';comment:'栏目简介'"`
- Descript string `gorm:"column:descript;size:500;default:'';comment:'分享描述'"`
- ReportAuthor string `gorm:"column:report_author;size:100;default:'';comment:'栏目作者'"`
- AuthorDescript string `gorm:"column:author_descript;size:500;default:'';comment:'作者简介'"`
- ReportImgUrl string `gorm:"column:report_img_url;size:255;default:'';comment:'报告配图'"`
- HeadImgUrl string `gorm:"column:head_img_url;size:255;default:'';comment:'头部banner'"`
- AvatarImgUrl string `gorm:"column:avatar_img_url;size:255;default:'';comment:'头像'"`
- ColumnImgUrl string `gorm:"column:column_img_url;size:255;default:'';comment:'栏目配图'"`
- IsHomeColumn int `gorm:"column:is_home_column;type:tinyint;default:0;comment:'1:首页专栏'"`
- HomeImgUrl string `gorm:"column:home_img_url;size:255;default:'';comment:'首页配图'"`
- ClassifyLabel string `gorm:"column:classify_label;size:500;default:''"`
- ShowType int `gorm:"column:show_type;type:tinyint unsigned;default:0;comment:'展示类型：1-列表 2-专栏 3-品种'"`
- HasTeleconference int `gorm:"column:has_teleconference;type:tinyint unsigned;default:0;comment:'是否有电话会 0-否 1-是'"`
- VipTitle string `gorm:"column:vip_title;size:200;comment:'研究员头衔'"`
- YbIconUrl string `gorm:"column:yb_icon_url;size:255;default:'';comment:'研报3.0已购页面icon图片地址'"`
- YbBgUrl string `gorm:"column:yb_bg_url;size:255;default:'';comment:'研报3.0已购详情背景图地址'"`
- IsShow int `gorm:"column:is_show;type:tinyint;default:1;comment:'是否展示报告：1,展示该分类下的报告，0隐藏分类下的报告'"`
- YbFiccSort int `gorm:"column:yb_ficc_sort;type:tinyint;default:0;comment:'研报小程序端ficc页面排序'"`
- YbFiccIcon string `gorm:"column:yb_ficc_icon;size:255;comment:'研报小程序端ficc页码图标'"`
- YbFiccPcIcon string `gorm:"column:yb_ficc_pc_icon;size:255;comment:'研报 pc端ficc页码图标'"`
- YbListImg string `gorm:"column:yb_list_img;size:255;default:'';comment:'研报小程序-列表封面图'"`
- YbShareBgImg string `gorm:"column:yb_share_bg_img;size:255;default:'';comment:'研报小程序-报告分享背景图'"`
- YbRightBanner string `gorm:"column:yb_right_banner;size:255;comment:'Pc端详情页，右侧，报告合集背景图'"`
- RelateTel int `gorm:"column:relate_tel;type:tinyint unsigned;default:0;comment:'是否在电话会中可选: 0-否; 1-是'"`
- RelateVideo int `gorm:"column:relate_video;type:tinyint unsigned;default:0;comment:'是否在路演视频中可选: 0-否; 1-是'"`
- IsMassSend int `gorm:"column:is_mass_send;type:tinyint;default:0;comment:'1:群发,0:非群发'"`
- Enabled int `gorm:"column:enabled;type:tinyint;default:1;comment:'是否可用'"`
- Level int `gorm:"column:level;type:int unsigned;default:0;comment:'层级'"`
- HasChild int `gorm:"column:has_child;type:tinyint unsigned;default:0;comment:'是否有子级别，0：下面没有子分类，1：下面有子分类；默认：0'"`
- ReportDetailShowType int `gorm:"column:report_detail_show_type;type:tinyint unsigned;default:1;comment:'报告详情的展示类型：1-拼接；2:目录'"`
- }
- // tableName
- func (m *Classify) TableName() string {
- return "classify"
- }
- func GetClassifyByClassifyId(classifyId int) (item *Classify, err error) {
- err = global.DEFAULT_MYSQL.Where("id = ?", classifyId).First(&item).Error
- return
- }
- func GetClassifyAll() (items []*Classify, err error) {
- err = global.DEFAULT_MYSQL.Model(&Classify{}).Scan(&items).Error
- return
- }
|
