sysjob.go 3.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113
  1. package models
  2. import (
  3. "device-manage/common/dto"
  4. orm "device-manage/common/global"
  5. "device-manage/common/models"
  6. "device-manage/tools"
  7. "strconv"
  8. )
  9. type SysJob struct {
  10. JobId uint `json:"jobId" gorm:"primary_key;AUTO_INCREMENT"` // 编码
  11. JobName string `json:"jobName" gorm:"size:255;"` // 名称
  12. JobGroup string `json:"jobGroup" gorm:"size:255;"` // 任务分组
  13. JobType int `json:"jobType" gorm:"size:1;"` // 任务类型
  14. CronExpression string `json:"cronExpression" gorm:"size:255;"` // cron表达式
  15. InvokeTarget string `json:"invokeTarget" gorm:"size:255;"` // 调用目标
  16. Args string `json:"args" gorm:"size:255;"` // 目标参数
  17. MisfirePolicy int `json:"misfirePolicy" gorm:"size:255;"` // 执行策略
  18. Concurrent int `json:"concurrent" gorm:"size:1;"` // 是否并发
  19. Status int `json:"status" gorm:"size:1;"` // 状态
  20. EntryId int `json:"entry_id" gorm:"size:11;"` // job启动时返回的id
  21. CreateBy string `json:"createBy" gorm:"size:128;"` //
  22. UpdateBy string `json:"updateBy" gorm:"size:128;"` //
  23. BaseModel
  24. DataScope string `json:"dataScope" gorm:"-"`
  25. }
  26. func (SysJob) TableName() string {
  27. return "sys_job"
  28. }
  29. func (e *SysJob) Generate() models.ActiveRecord {
  30. o := *e
  31. return &o
  32. }
  33. func (e *SysJob) GetId() interface{} {
  34. return e.JobId
  35. }
  36. func (e *SysJob) SetCreateBy(createBy uint) {
  37. e.CreateBy = strconv.Itoa(int(createBy))
  38. }
  39. func (e *SysJob) SetUpdateBy(updateBy uint) {
  40. e.UpdateBy = strconv.Itoa(int(updateBy))
  41. }
  42. // 创建SysJob
  43. func (e *SysJob) Create() (err error) {
  44. return orm.Eloquent.Table(e.TableName()).Create(e).Error
  45. }
  46. // 获取SysJob
  47. func (e *SysJob) Get(id interface{}) (err error) {
  48. return orm.Eloquent.Table(e.TableName()).First(e, id).Error
  49. }
  50. // 获取SysJob带分页
  51. func (e *SysJob) GetPage(pageSize int, pageIndex int, v interface{}, list interface{}) (int, error) {
  52. table := orm.Eloquent.Table(e.TableName()).Scopes(dto.MakeCondition(v))
  53. // 数据权限控制(如果不需要数据权限请将此处去掉)
  54. //dataPermission := new(DataPermission)
  55. userid, _ := tools.StringToInt(e.DataScope)
  56. var count int64
  57. if err := table.Scopes(DataScopes(e.TableName(), userid), dto.Paginate(pageSize, pageIndex)).Find(list).Offset(-1).Limit(-1).Count(&count).Error; err != nil {
  58. return 0, err
  59. }
  60. return int(count), nil
  61. }
  62. func (e *SysJob) GetList(list interface{}) (err error) {
  63. return orm.Eloquent.Table(e.TableName()).Where("status = ?", 2).Find(list).Error
  64. }
  65. // 更新SysJob
  66. func (e *SysJob) Update(id interface{}) (err error) {
  67. return orm.Eloquent.Table(e.TableName()).Where(id).Updates(&e).Error
  68. }
  69. func (e *SysJob) RemoveAllEntryID() (update SysJob, err error) {
  70. if err = orm.Eloquent.Table(e.TableName()).Where("entry_id > ?", 0).Update("entry_id", 0).Error; err != nil {
  71. return
  72. }
  73. return
  74. }
  75. func (e *SysJob) RemoveEntryID(entryID int) (update SysJob, err error) {
  76. if err = orm.Eloquent.Table(e.TableName()).Where("entry_id = ?", entryID).Updates(map[string]interface{}{"entry_id": 0}).Error; err != nil {
  77. return
  78. }
  79. return
  80. }
  81. // 删除SysJob
  82. func (e *SysJob) Delete(id int) (success bool, err error) {
  83. if err = orm.Eloquent.Table(e.TableName()).Where(id).Delete(&SysJob{}).Error; err != nil {
  84. success = false
  85. return
  86. }
  87. success = true
  88. return
  89. }
  90. //批量删除
  91. func (e *SysJob) BatchDelete(id []int) error {
  92. return orm.Eloquent.Table(e.TableName()).Where(id).Delete(&SysJob{}).Error
  93. }