approver.go 1.7 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152
  1. package dao
  2. import (
  3. "server/dao/system"
  4. "server/global"
  5. )
  6. type Approver struct {
  7. global.GVA_MODEL
  8. UserId int `json:"userId" form:"userId" gorm:"comment:用户id"`
  9. User system.SysUser `json:"user" form:"user" gorm:"foreignKey:UserId;references:id;"`
  10. ApproverDescription string `json:"approverDescription" form:"approverDescription" gorm:"comment:审批人详情"`
  11. ApproverRightsDescription string `json:"approverRightsDescription" form:"approverRightsDescription" gorm:"comment:审批人权限详情"`
  12. }
  13. func (Approver) TableName() string {
  14. return "approver"
  15. }
  16. func QueryAllApprover() (approvers []Approver, err error) {
  17. err = global.GVA_DB.Model(&Approver{}).Preload("User").Find(&approvers).Error
  18. return approvers, err
  19. }
  20. func QueryApproverList(limit, offset int) (approvers []Approver, total int64, err error) {
  21. // 创建db
  22. db := global.GVA_DB.Model(&Approver{})
  23. // 如果有条件搜索 下方会自动创建搜索语句
  24. err = db.Count(&total).Error
  25. if err != nil {
  26. return
  27. }
  28. err = db.Order("id desc").Limit(limit).Offset(offset).Preload("User").Find(&approvers).Error
  29. return approvers, total, err
  30. }
  31. func QueryApproverByUserId(userId int) (approver Approver, err error) {
  32. err = global.GVA_DB.Model(&Approver{}).Where("user_id = ?", userId).Preload("User").First(&approver).Error
  33. return approver, err
  34. }
  35. func (a Approver) CreateApprover() error {
  36. return global.GVA_DB.Create(&a).Error
  37. }
  38. func (a Approver) UpdateApprover() error {
  39. return global.GVA_DB.Where("id = ?", a.ID).Updates(&a).Error
  40. }
  41. func (a Approver) DeleteApprover() error {
  42. return global.GVA_DB.Unscoped().Delete(&a).Error
  43. }