mirror of
https://gitee.com/XM-GO/PandaX.git
synced 2026-04-23 02:48:34 +08:00
114 lines
3.1 KiB
Go
114 lines
3.1 KiB
Go
package services
|
|
|
|
import (
|
|
"pandax/apps/job/entity"
|
|
"pandax/pkg/global"
|
|
"pandax/pkg/global/model"
|
|
)
|
|
|
|
type (
|
|
JobModel interface {
|
|
Insert(data entity.SysJob) (*entity.SysJob, error)
|
|
FindOne(jobId string) (*entity.SysJob, error)
|
|
FindListPage(page, pageSize int, data entity.SysJob) (*[]entity.SysJob, int64, error)
|
|
FindList(data entity.SysJob) (*[]entity.SysJob, error)
|
|
Update(data entity.SysJob) (*entity.SysJob, error)
|
|
Delete(jobId []string) error
|
|
FindByEntryId(entryId int64) (*entity.SysJob, error)
|
|
RemoveAllEntryID() error
|
|
RemoveEntryID(EntryID int) error
|
|
}
|
|
|
|
jobModelImpl struct {
|
|
table string
|
|
}
|
|
)
|
|
|
|
var JobModelDao JobModel = &jobModelImpl{
|
|
table: `jobs`,
|
|
}
|
|
|
|
func (m *jobModelImpl) Insert(data entity.SysJob) (*entity.SysJob, error) {
|
|
err := global.Db.Table(m.table).Create(&data).Error
|
|
return &data, err
|
|
}
|
|
|
|
func (m *jobModelImpl) FindOne(jobId string) (*entity.SysJob, error) {
|
|
resData := new(entity.SysJob)
|
|
err := global.Db.Table(m.table).Where("id = ?", jobId).First(resData).Error
|
|
return resData, err
|
|
}
|
|
|
|
func (m *jobModelImpl) FindListPage(page, pageSize int, data entity.SysJob) (*[]entity.SysJob, int64, error) {
|
|
list := make([]entity.SysJob, 0)
|
|
var total int64 = 0
|
|
offset := pageSize * (page - 1)
|
|
db := global.Db.Table(m.table)
|
|
// 此处填写 where参数判断
|
|
if data.JobName != "" {
|
|
db = db.Where("job_name like ? ", "%"+data.JobName+"%")
|
|
}
|
|
if data.Status != "" {
|
|
db = db.Where("status = ?", data.Status)
|
|
}
|
|
|
|
// 组织数据访问权限
|
|
model.OrgAuthSet(db, data.RoleId, data.Owner)
|
|
|
|
err := db.Count(&total).Error
|
|
if err != nil {
|
|
return &list, total, err
|
|
}
|
|
err = db.Order("create_time desc").Limit(pageSize).Offset(offset).Find(&list).Error
|
|
return &list, total, err
|
|
}
|
|
|
|
func (m *jobModelImpl) FindList(data entity.SysJob) (*[]entity.SysJob, error) {
|
|
list := make([]entity.SysJob, 0)
|
|
db := global.Db.Table(m.table)
|
|
// 此处填写 where参数判断
|
|
if data.JobName != "" {
|
|
db = db.Where("job_name like ? ", "%"+data.JobName+"%")
|
|
}
|
|
if data.Status != "" {
|
|
db = db.Where("status = ?", data.Status)
|
|
}
|
|
// 组织数据访问权限
|
|
err := model.OrgAuthSet(db, data.RoleId, data.Owner)
|
|
if err != nil {
|
|
return nil, err
|
|
}
|
|
err = db.Order("create_time desc").Find(&list).Error
|
|
return &list, err
|
|
}
|
|
|
|
func (m *jobModelImpl) Update(data entity.SysJob) (*entity.SysJob, error) {
|
|
err := global.Db.Table(m.table).Updates(&data).Error
|
|
return &data, err
|
|
}
|
|
|
|
func (m *jobModelImpl) Delete(jobIds []string) error {
|
|
err := global.Db.Table(m.table).Delete(&entity.SysJob{}, "id in (?)", jobIds).Error
|
|
return err
|
|
}
|
|
|
|
func (m *jobModelImpl) FindByEntryId(entryId int64) (*entity.SysJob, error) {
|
|
resData := new(entity.SysJob)
|
|
err := global.Db.Table(m.table).Where("entry_id = ?", entryId).First(resData).Error
|
|
return resData, err
|
|
}
|
|
|
|
func (m *jobModelImpl) RemoveAllEntryID() error {
|
|
if err := global.Db.Table(m.table).Where("entry_id > ?", 0).Update("entry_id", 0).Error; err != nil {
|
|
return err
|
|
}
|
|
return nil
|
|
}
|
|
|
|
func (m *jobModelImpl) RemoveEntryID(EntryID int) error {
|
|
if err := global.Db.Table(m.table).Where("entry_id = ?", EntryID).Update("entry_id", 0).Error; err != nil {
|
|
return err
|
|
}
|
|
return nil
|
|
}
|