owner.go 3.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129
  1. package owner
  2. import (
  3. "errors"
  4. "server/dao"
  5. "server/global"
  6. "server/model/owner/request"
  7. )
  8. type ownerService struct{}
  9. func NewOwnerService() *ownerService {
  10. return &ownerService{}
  11. }
  12. // CreateOwner 创建车主信息
  13. func (s *ownerService) CreateOwner(req request.OwnerCreate) error {
  14. // 检查手机号是否已存在
  15. var existingOwner dao.Owner
  16. result := global.GVA_DB.Where("owner_phone = ?", req.OwnerPhone).First(&existingOwner)
  17. if result.RowsAffected > 0 {
  18. return errors.New("手机号已存在")
  19. }
  20. owner := dao.Owner{
  21. OwnerName: req.OwnerName,
  22. OwnerSurname: req.OwnerSurname,
  23. OwnerPhone: req.OwnerPhone,
  24. IsVip: req.IsVip,
  25. VipExpireTime: req.VipExpireTime,
  26. }
  27. return global.GVA_DB.Create(&owner).Error
  28. }
  29. // UpdateOwner 更新车主信息
  30. func (s *ownerService) UpdateOwner(req request.OwnerUpdate) error {
  31. var owner dao.Owner
  32. result := global.GVA_DB.First(&owner, req.ID)
  33. if result.RowsAffected == 0 {
  34. return errors.New("车主不存在")
  35. }
  36. // 检查手机号是否被其他车主使用
  37. var existingOwner dao.Owner
  38. result = global.GVA_DB.Where("owner_phone = ? AND id != ?", req.OwnerPhone, req.ID).First(&existingOwner)
  39. if result.RowsAffected > 0 {
  40. return errors.New("手机号已被其他车主使用")
  41. }
  42. owner.OwnerName = req.OwnerName
  43. owner.OwnerSurname = req.OwnerSurname
  44. owner.OwnerPhone = req.OwnerPhone
  45. owner.IsVip = req.IsVip
  46. owner.VipExpireTime = req.VipExpireTime
  47. return global.GVA_DB.Save(&owner).Error
  48. }
  49. // GetOwnerByID 根据ID获取车主信息
  50. func (s *ownerService) GetOwnerByID(id uint) (dao.Owner, error) {
  51. var owner dao.Owner
  52. result := global.GVA_DB.First(&owner, id)
  53. if result.RowsAffected == 0 {
  54. return dao.Owner{}, errors.New("车主不存在")
  55. }
  56. return owner, nil
  57. }
  58. // GetOwnerByPhone 根据手机号获取车主信息
  59. func (s *ownerService) GetOwnerByPhone(phone string) (dao.Owner, error) {
  60. var owner dao.Owner
  61. result := global.GVA_DB.Where("owner_phone = ?", phone).First(&owner)
  62. if result.RowsAffected == 0 {
  63. return dao.Owner{}, errors.New("车主不存在")
  64. }
  65. return owner, nil
  66. }
  67. // ListOwners 获取车主列表
  68. func (s *ownerService) ListOwners(req request.OwnerQuery) (int64, []dao.Owner, error) {
  69. var owners []dao.Owner
  70. var total int64
  71. query := global.GVA_DB.Model(&dao.Owner{})
  72. if req.OwnerName != "" {
  73. query = query.Where("owner_name LIKE ?", "%"+req.OwnerName+"%")
  74. }
  75. if req.OwnerPhone != "" {
  76. query = query.Where("owner_phone LIKE ?", "%"+req.OwnerPhone+"%")
  77. }
  78. if req.IsVip != nil {
  79. query = query.Where("is_vip = ?", *req.IsVip)
  80. }
  81. // 计算总数
  82. query.Count(&total)
  83. // 分页查询
  84. offset := (req.Page - 1) * req.PageSize
  85. result := query.Offset(offset).Limit(req.PageSize).Find(&owners)
  86. if result.Error != nil {
  87. return 0, nil, result.Error
  88. }
  89. return total, owners, nil
  90. }
  91. // DeleteOwner 删除车主
  92. func (s *ownerService) DeleteOwner(id uint) error {
  93. // 检查车主是否存在
  94. var owner dao.Owner
  95. result := global.GVA_DB.First(&owner, id)
  96. if result.RowsAffected == 0 {
  97. return errors.New("车主不存在")
  98. }
  99. // 检查车主是否有车辆
  100. var vehicleCount int64
  101. global.GVA_DB.Model(&dao.Vehicle{}).Where("owner_id = ?", id).Count(&vehicleCount)
  102. if vehicleCount > 0 {
  103. return errors.New("车主有车辆,无法删除")
  104. }
  105. return global.GVA_DB.Delete(&owner, id).Error
  106. }