package excel import ( "eta_gn/eta_chart_lib/global" "eta_gn/eta_chart_lib/utils" "fmt" "time" ) type ExcelClassify struct { ExcelClassifyId int `gorm:"column:excel_classify_id;primaryKey" orm:"column(excel_classify_id);pk"` // 主键 Source int `description:"表格来源，1：excel插件的表格，2：自定义表格，3：混合表格，4：自定义分析，默认：1" gorm:"column:source"` ExcelClassifyName string `description:"分类名称" gorm:"column:excel_classify_name"` ParentId int `description:"父级id" gorm:"column:parent_id"` SysUserId int `description:"创建人id" gorm:"column:sys_user_id"` SysUserRealName string `description:"创建人姓名" gorm:"column:sys_user_real_name"` Level int `description:"层级" gorm:"column:level"` UniqueCode string `description:"唯一编码" gorm:"column:unique_code"` Sort int `description:"排序字段，越小越靠前，默认值：10" gorm:"column:sort"` IsDelete int `description:"是否删除，0：未删除；1：已删除，默认值：0" gorm:"column:is_delete"` // 修改了注释以避免混淆 CreateTime time.Time `description:"创建时间" gorm:"column:create_time"` ModifyTime time.Time `description:"修改时间" gorm:"column:modify_time"` IsJoinPermission int `description:"是否加入权限管控，0：不加入；1：加入；默认：0" gorm:"column:is_join_permission"` } func (ExcelClassify) TableName() string { return "excel_classify" } func AddExcelClassify(item *ExcelClassify) (lastId int64, err error) { o := global.DmSQL["data"] err = o.Create(item).Error if err != nil { return } lastId = int64(item.ExcelClassifyId) return } func GetExcelClassifyCount(ExcelClassifyName string, parentId, source int) (count int, err error) { o := global.DmSQL["data"] sql := `SELECT COUNT(1) AS count FROM excel_classify WHERE parent_id=? AND source = ? AND excel_classify_name=? AND is_delete=0 ` err = o.Raw(sql, parentId, source, ExcelClassifyName).Scan(&count).Error return } func GetExcelClassifyById(classifyId int) (item *ExcelClassify, err error) { o := global.DmSQL["data"] sql := `SELECT * FROM excel_classify WHERE excel_classify_id=? AND is_delete=0 ` err = o.Raw(sql, classifyId).First(&item).Error return } func GetExcelClassifyByIdList(classifyIdList []int) (items []*ExcelClassify, err error) { num := len(classifyIdList) if num <= 0 { return } o := global.DmSQL["data"] sql := `SELECT * FROM excel_classify WHERE excel_classify_id in (` + utils.GetGormInReplace(num) + `) AND is_delete=0 ` err = o.Raw(sql, classifyIdList).Scan(&items).Error return } func GetExcelClassifyBySourceAndIsJoinPermission(source, isJoinPermission int) (items []*ExcelClassify, err error) { o := global.DmSQL["data"] sql := `SELECT * FROM excel_classify WHERE source = ? AND is_join_permission = ? ` err = o.Raw(sql, source, isJoinPermission).Scan(&items).Error return } func GetChildClassifyById(classifyId int) (items []*ExcelClassify, err error) { o := global.DmSQL["data"] sql := `SELECT * FROM excel_classify WHERE parent_id=? AND is_delete=0 ` err = o.Raw(sql, classifyId).Scan(&items).Error return } func GetExcelClassifyByParentId(parentId, source int) (items []*ExcelClassifyItems, err error) { o := global.DmSQL["data"] sql := ` SELECT * FROM excel_classify WHERE parent_id=? AND source = ? AND is_delete=0 order by sort asc,excel_classify_id asc` err = o.Raw(sql, parentId, source).Scan(&items).Error return } func GetExcelClassifyBySource(source int) (items []*ExcelClassifyItems, err error) { o := global.DmSQL["data"] sql := ` SELECT * FROM excel_classify WHERE source = ? AND is_delete=0 order by sort asc,excel_classify_id asc` err = o.Raw(sql, source).Scan(&items).Error return } func GetExcelClassifyBySourceOrderByLevel(source int) (items []*ExcelClassifyItems, err error) { o := global.DmSQL["data"] sql := ` SELECT * FROM excel_classify WHERE source = ? AND is_delete=0 order by level asc, sort asc,excel_classify_id asc` err = o.Raw(sql, source).Scan(&items).Error return } func GetExcelClassifyAll() (items []*ExcelClassifyItems, err error) { o := global.DmSQL["data"] sql := ` SELECT * FROM excel_classify WHERE parent_id<>0 AND is_delete=0 order by sort asc,excel_classify_id asc` err = o.Raw(sql).Scan(&items).Error return } type ExcelClassifyItems struct { ExcelClassifyId int `gorm:"column:excel_classify_id" description:"分类id"` // 分类id ExcelInfoId int `gorm:"column:excel_info_id" description:"表格id"` // 表格id ExcelClassifyName string `gorm:"column:excel_classify_name" description:"分类名称"` ParentId int `gorm:"column:parent_id" description:"父级id"` Level int `gorm:"column:level" description:"层级"` // 层级 Sort int `gorm:"column:sort" description:"排序字段，越小越靠前，默认值：10"` // 排序字段，越小越靠前，默认值：10 UniqueCode string `gorm:"column:unique_code" description:"唯一编码"` // 唯一编码 SysUserId int `gorm:"column:sys_user_id" description:"创建人id"` // 创建人id SysUserRealName string `gorm:"column:sys_user_real_name" description:"创建人姓名"` // 创建人姓名 StartDate string `gorm:"column:start_date" description:"自定义开始日期"` // 自定义开始日期 Children []*ExcelClassifyItems `gorm:"-"` IsJoinPermission int `gorm:"column:is_join_permission" description:"是否加入权限管控，0：不加入；1：加入；默认：0"` // 是否加入权限管控，0：不加入；1：加入；默认：0 HaveOperaAuth bool `gorm:"column:have_opener_auth" description:"是否有数据权限"` // 是否有数据权限 } func (ExcelClassifyItems) TableName() string { return "excel_classify_items" } func GetExcelClassifyByCondition(condition string, pars []interface{}) (item *ExcelClassify, err error) { o := global.DmSQL["data"] sql := ` SELECT * FROM excel_classify WHERE 1=1 AND is_delete=0 ` if condition != "" { sql += condition } err = o.Raw(sql, pars...).First(&item).Error return } func GetNextExcelClassifyByCondition(condition string, pars []interface{}) (item *ExcelClassify, err error) { o := global.DmSQL["data"] sql := ` SELECT * FROM excel_classify WHERE 1=1 AND is_delete=0 ` if condition != "" { sql += condition } sql += " ORDER BY sort asc , create_time ASC LIMIT 1 " err = o.Raw(sql, pars...).First(&item).Error return } func GetFirstExcelClassifyByParentId(parentId int) (item *ExcelClassify, err error) { o := global.DmSQL["data"] sql := ` SELECT * FROM excel_classify WHERE parent_id=? AND is_delete=0 order by sort asc,excel_classify_id asc limit 1` err = o.Raw(sql, parentId).First(&item).Error return } func UpdateExcelClassifySortByParentId(parentId, classifyId, nowSort int, updateSort string, source int) (err error) { o := global.DmSQL["data"] sql := ` update excel_classify set sort = ` + updateSort + ` WHERE parent_id=? and source=? and sort > ? AND is_delete=0 ` if classifyId > 0 { sql += ` or ( excel_classify_id > ` + fmt.Sprint(classifyId) + ` and sort= ` + fmt.Sprint(nowSort) + `)` } err = o.Exec(sql, parentId, source, nowSort).Error return } func (ExcelClassify *ExcelClassify) Update(cols []string) (err error) { o := global.DmSQL["data"] err = o.Model(ExcelClassify).Select(cols).Updates(ExcelClassify).Error return } func GetExcelClassifyMaxSort(parentId int, source int) (sort int, err error) { o := global.DmSQL["data"] sql := `SELECT COALESCE(MAX(sort), 0) AS sort FROM excel_classify WHERE parent_id=? AND source = ? AND is_delete=0 ` err = o.Raw(sql, parentId, source).Scan(&sort).Error return } type ExcelClassifyView struct { ExcelClassifyId int `orm:"column(excel_classify_id);pk" gorm:"column:excel_classify_id;primaryKey"` // 主键 ExcelClassifyName string `description:"分类名称" gorm:"column:excel_classify_name"` // 分类名称 ParentId int `description:"父级id" gorm:"column:parent_id"` // 父级id } func GetExcelClassifyViewById(classifyId int) (item *ExcelClassifyView, err error) { o := global.DmSQL["data"] sql := `SELECT * FROM excel_classify WHERE excel_classify_id=? AND is_delete=0 ` err = o.Raw(sql, classifyId).First(&item).Error return } func ExcelClassifyItemBySort(p1, p2 *ExcelClassifyItems) bool { return p1.Sort < p2.Sort } func GetClassifyByIdList(classifyIdList []int) (items []*ExcelClassify, err error) { num := len(classifyIdList) if num <= 0 { return } o := global.DmSQL["data"] sql := `SELECT * FROM excel_classify WHERE excel_classify_id in (` + utils.GetGormInReplace(num) + `) AND is_delete=0 ` err = o.Raw(sql, classifyIdList).Scan(&items).Error return }