edb_classify.go 1.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344
  1. package data_manage
  2. import (
  3. "eta/eta_task/global"
  4. "eta/eta_task/utils"
  5. "time"
  6. )
  7. type EdbClassify struct {
  8. ClassifyID int64 `gorm:"column:classify_id;primaryKey;autoIncrement"`
  9. ClassifyType uint32
  10. ClassifyName string
  11. ParentID int64 `gorm:"column:parent_id"`
  12. HasData int32
  13. CreateTime time.Time
  14. ModifyTime time.Time
  15. SysUserID int64 `gorm:"column:sys_user_id"`
  16. SysUserRealName string
  17. Level int64
  18. UniqueCode string
  19. Sort uint32
  20. RootID int64 `gorm:"column:root_id"`
  21. LastModifyUserID uint32 `gorm:"column:last_modify_user_id"`
  22. LastModifyUserName string
  23. }
  24. // GetAllEdbClassifyListByCondition
  25. // @Description: 获取分类列表
  26. // @author: Roc
  27. // @datetime 2024-02-29 10:55:38
  28. // @param condition string
  29. // @param pars []interface{}
  30. // @return item []*EdbInfoUpdateLog
  31. // @return err error
  32. func GetAllEdbClassifyListByCondition(condition string, pars []interface{}) (item []*EdbClassify, err error) {
  33. o := global.DbMap[utils.DbNameIndex]
  34. sql := ` SELECT * FROM edb_classify WHERE 1=1 `
  35. if condition != "" {
  36. sql += condition
  37. }
  38. sql += `ORDER BY classify_id ASC `
  39. err = o.Raw(sql, pars...).Find(&item).Error
  40. return
  41. }