-
Notifications
You must be signed in to change notification settings - Fork 0
/
mail.go
104 lines (86 loc) · 1.92 KB
/
mail.go
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
102
103
104
package model
import (
"fmt"
"strings"
"time"
"github.com/mnako/letters"
"golang.org/x/net/html"
"gorm.io/gorm"
)
type Mail struct {
ID uint
CreatedAt time.Time `gorm:"not null"`
Date string `gorm:"not null;index:search"`
Source string `gorm:"not null"`
SearchText string `gorm:"not null"`
}
func (m *Mail) BeforeSave(tx *gorm.DB) (err error) {
em, err := m.Parse()
if err != nil {
return
}
m.CreatedAt = em.Headers.Date
m.Date = em.Headers.Date.Format("2006-01-02")
m.SearchText = fmt.Sprintf("%s %s %s", em.Headers.Subject, em.Text, extractText(em.HTML))
return
}
func (m *Mail) Parse() (letters.Email, error) {
r := strings.NewReader(m.Source)
return letters.ParseEmail(r)
}
func CreatedAt(s string) func(db *gorm.DB) *gorm.DB {
return func(db *gorm.DB) *gorm.DB {
sw := strings.TrimSpace(s)
if sw == "" {
return db
}
return db.Where("date = ?", s)
}
}
func MatchWord(w string) func(db *gorm.DB) *gorm.DB {
return func(db *gorm.DB) *gorm.DB {
sw := strings.TrimSpace(w)
if sw == "" {
return db
}
wsw := fmt.Sprintf("%%%s%%", sw)
return db.Where("source LIKE ? OR search_text LIKE ?", wsw, wsw)
}
}
func ExpireDays(expireDays int) func(db *gorm.DB) *gorm.DB {
return func(db *gorm.DB) *gorm.DB {
t := time.Now()
return db.Where("created_at < ?", t.AddDate(0, 0, -expireDays))
}
}
func Paginate(page int, per int) func(db *gorm.DB) *gorm.DB {
return func(db *gorm.DB) *gorm.DB {
if page <= 0 {
page = 1
}
switch {
case per > 100:
per = 100
case per <= 0:
per = 10
}
offset := (page - 1) * per
return db.Offset(offset).Limit(per)
}
}
func extractText(htmlStr string) (text string) {
r := strings.NewReader(htmlStr)
z := html.NewTokenizer(r)
loop := true
for loop {
tt := z.Next()
loop = tt != html.ErrorToken
if loop {
switch tt {
case html.TextToken:
text = fmt.Sprintf("%s %s", text, z.Text())
}
}
}
return
}