1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
|
package mail
import (
"strings"
"dove/database"
"dove/models/mail"
"dove/utils/meta"
"gorm.io/gorm"
)
func FindMailboxByAddress(address string) *mail.Mailbox {
var mailbox mail.Mailbox
result := database.DB.Where("address = ?", address).First(&mailbox)
if result.Error == gorm.ErrRecordNotFound {
return nil
}
return &mailbox
}
func FindMailboxByAlias(aliasAddress string) *mail.Mailbox {
var alias mail.Alias
result := database.DB.Where("source_address = ?", aliasAddress).Preload("Mailbox").First(&alias)
if result.Error != nil {
return nil
}
return &alias.Mailbox
}
func CreateMailbox(mailbox *mail.Mailbox) error {
return database.DB.Create(mailbox).Error
}
func ListMailboxes(pagination meta.Pagination, sorting meta.Sorting, search string) ([]mail.Mailbox, int64) {
var mailboxes []mail.Mailbox
var total int64
query := database.DB.Model(&mail.Mailbox{})
if search != "" {
like := "%" + search + "%"
query = query.Where("address LIKE ?", like)
}
query.Count(&total)
pagination.Apply(sorting.Apply(query)).Preload("User").Preload("Domain").Preload("Domain.TLD").Find(&mailboxes)
return mailboxes, total
}
func FindMailboxByID(mailboxID uint) *mail.Mailbox {
var mailbox mail.Mailbox
result := database.DB.First(&mailbox, mailboxID)
if result.Error == gorm.ErrRecordNotFound {
return nil
}
return &mailbox
}
func UpdateMailbox(mailbox *mail.Mailbox) error {
return database.DB.Save(mailbox).Error
}
func DeleteMailbox(mailbox *mail.Mailbox) error {
return database.DB.Delete(mailbox).Error
}
func FindMailboxByIDWithRelations(mailboxID uint) *mail.Mailbox {
var mailbox mail.Mailbox
result := database.DB.Preload("User").Preload("Domain").Preload("Domain.TLD").First(&mailbox, mailboxID)
if result.Error == gorm.ErrRecordNotFound {
return nil
}
return &mailbox
}
func RebuildMailboxAddressesByDomainID(domainID uint) error {
var mailboxes []mail.Mailbox
database.DB.Where("domain_id = ?", domainID).Preload("Domain").Preload("Domain.TLD").Find(&mailboxes)
for index := range mailboxes {
localPart := strings.Split(mailboxes[index].Address, "@")[0]
mailboxes[index].Address = localPart + "@" + mailboxes[index].Domain.Name + "." + mailboxes[index].Domain.TLD.Name
database.DB.Save(&mailboxes[index])
}
return nil
}
func CountMailboxesByDomainID(domainID uint) int64 {
var count int64
database.DB.Model(&mail.Mailbox{}).Where("domain_id = ?", domainID).Count(&count)
return count
}
func CountMailboxes() int64 {
var count int64
database.DB.Model(&mail.Mailbox{}).Count(&count)
return count
}
|
