base_from_ccf_classify.go 2.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
  1. package data_manage
  2. import (
  3. "eta_gn/eta_api/global"
  4. "eta_gn/eta_api/utils"
  5. "time"
  6. )
  7. // BaseFromCCFClassify CCF原始数据分类表
  8. type BaseFromCCFClassify struct {
  9. BaseFromCcfClassifyId int `orm:"column(base_from_ccf_classify_id);pk" gorm:"primaryKey" `
  10. ClassifyName string `description:"分类名称"`
  11. ParentId int `description:"父级id"`
  12. SysUserId int `description:"创建人id"`
  13. SysUserRealName string `description:"创建人姓名"`
  14. Level int `description:"层级"`
  15. Sort int `description:"排序字段,越小越靠前,默认值:10"`
  16. ModifyTime time.Time `description:"修改时间"`
  17. CreateTime time.Time `description:"创建时间"`
  18. }
  19. // GetBaseFromCCFClassify 获取所有分类
  20. func GetBaseFromCCFClassify() (items []*BaseFromCCFClassify, err error) {
  21. sql := ` SELECT * FROM base_from_ccf_classify ORDER BY parent_id ASC, sort ASC, base_from_ccf_classify_id ASC`
  22. err = global.DmSQL["data"].Raw(sql).Scan(&items).Error
  23. return
  24. }
  25. // BaseFromCCFClassifyItem CCF数据分类信息
  26. type BaseFromCCFClassifyItem struct {
  27. ClassifyId int `description:"分类ID"`
  28. ClassifyName string `description:"分类名称"`
  29. ParentId int `description:"父级id"`
  30. Level int `description:"层级"`
  31. Sort int `description:"排序字段"`
  32. CreateTime string `description:"创建时间"`
  33. ModifyTime string `description:"修改时间"`
  34. Child []*BaseFromCCFClassifyItem `gorm:"-" description:"子分类"`
  35. }
  36. func (y *BaseFromCCFClassify) Format2Item(origin *BaseFromCCFClassify) (item *BaseFromCCFClassifyItem) {
  37. if origin == nil {
  38. return
  39. }
  40. item = new(BaseFromCCFClassifyItem)
  41. item.ClassifyId = origin.BaseFromCcfClassifyId
  42. item.ClassifyName = origin.ClassifyName
  43. item.ParentId = origin.ParentId
  44. item.Level = origin.Level
  45. item.Sort = origin.Sort
  46. item.CreateTime = utils.TimeTransferString(utils.FormatDateTime, origin.CreateTime)
  47. item.ModifyTime = utils.TimeTransferString(utils.FormatDateTime, origin.ModifyTime)
  48. return
  49. }