forked from bojand/ghz
-
Notifications
You must be signed in to change notification settings - Fork 0
/
report.go
160 lines (125 loc) · 3.67 KB
/
report.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
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
package database
import (
"strconv"
"github.com/bhua-panw/ghz/web/model"
)
// FindReportByID gets the report by id
func (d *Database) FindReportByID(id uint) (*model.Report, error) {
p := new(model.Report)
err := d.DB.First(p, id).Error
if err != nil {
p = nil
}
return p, err
}
// CountReports returns the number of reports
func (d *Database) CountReports() (uint, error) {
p := new(model.Report)
count := uint(0)
err := d.DB.Model(p).Count(&count).Error
return count, err
}
// CountReportsForProject returns the number of reports
func (d *Database) CountReportsForProject(pid uint) (uint, error) {
count := uint(0)
err := d.DB.Model(&model.Report{}).Where("project_id = ?", pid).Count(&count).Error
return count, err
}
// CreateReport creates a new report
func (d *Database) CreateReport(r *model.Report) error {
return d.DB.Create(r).Error
}
// DeleteReport deletes an existing report
func (d *Database) DeleteReport(r *model.Report) error {
return d.DB.Delete(r).Error
}
// DeleteReportBulk performans a bulk of deletes
func (d *Database) DeleteReportBulk(ids []uint) (int, error) {
nItems := len(ids)
ids2 := make([]string, nItems)
for i, id := range ids {
idStr := strconv.FormatUint(uint64(id), 10)
ids2[i] = idStr
}
query := "id IN ("
for i, id := range ids2 {
query += id
if i < nItems-1 {
query += ", "
}
}
query += ")"
existing := make([]*model.Report, 0, nItems)
err := d.DB.Where(query).Find(&existing).Error
if err != nil {
return 0, err
}
nExisting := len(existing)
query = "id IN ("
for i, rep := range existing {
query += strconv.FormatUint(uint64(rep.ID), 10)
if i < nExisting-1 {
query += ", "
}
}
query += ")"
err = d.DB.Where(query).Delete(&model.Report{}).Error
if err != nil {
return 0, err
}
return nExisting, err
}
// FindPreviousReport find previous report for the report id
func (d *Database) FindPreviousReport(rid uint) (*model.Report, error) {
report, err := d.FindReportByID(rid)
if err != nil {
return nil, err
}
previous := new(model.Report)
orderSQL := "date desc"
whereSQL := "project_id = ? AND date < ?"
err = d.DB.Debug().Where(whereSQL, report.ProjectID, report.Date).Order(orderSQL).Limit(1).Find(&previous).Error
if err != nil {
return nil, err
}
return previous, err
}
// FindLatestReportForProject returns the latest / most recent report for project
func (d *Database) FindLatestReportForProject(pid uint) (*model.Report, error) {
list, err := d.listReports(true, pid, 1, 0, "date", "desc")
if err != nil || len(list) == 0 {
return nil, err
}
return list[0], nil
}
// ListReports lists reports using sorting
func (d *Database) ListReports(limit, page uint, sortField, order string) ([]*model.Report, error) {
return d.listReports(false, 0, limit, page, sortField, order)
}
// ListReportsForProject lists reports using sorting
func (d *Database) ListReportsForProject(pid, limit, page uint, sortField, order string) ([]*model.Report, error) {
return d.listReports(true, pid, limit, page, sortField, order)
}
func (d *Database) listReports(byProject bool, pid, limit, page uint, sortField, order string) ([]*model.Report, error) {
if sortField != "id" && sortField != "date" {
sortField = "id"
}
if order != "asc" && order != "desc" {
order = "desc"
}
offset := uint(0)
if page > 0 && limit > 0 {
offset = page * limit
}
orderSQL := sortField + " " + string(order)
if byProject {
p := &model.Project{}
p.ID = pid
s := make([]*model.Report, limit)
err := d.DB.Order(orderSQL).Offset(offset).Limit(limit).Model(p).Related(&s).Error
return s, err
}
s := make([]*model.Report, limit)
err := d.DB.Order(orderSQL).Offset(offset).Limit(limit).Find(&s).Error
return s, err
}