forked from qor/qor-example
/
dashboard.go
67 lines (55 loc) · 1.39 KB
/
dashboard.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
package admin
import (
"encoding/json"
"time"
"github.com/conku/admin"
"github.com/conku/now"
"github.com/conku/qor-example/config/db"
)
type Chart struct {
Total string
Date time.Time
}
/*
date format 2015-01-23
*/
func GetChartData(table, start, end string) (res []Chart) {
startdate, err := now.Parse(start)
if err != nil {
return
}
enddate, err := now.Parse(end)
if err != nil || enddate.UnixNano() < startdate.UnixNano() {
enddate = now.EndOfDay()
} else {
enddate = enddate.AddDate(0, 0, 1)
}
db.DB.Table(table).
Where("created_at > ? AND created_at < ?", startdate, enddate).
Select("date(created_at) as date, count(*) as total").
Group("date(created_at)").
Order("date(created_at)").
Scan(&res)
return
}
type Charts struct {
Orders []Chart
Users []Chart
}
func ReportsDataHandler(context *admin.Context) {
charts := &Charts{}
startDate := context.Request.URL.Query().Get("startDate")
endDate := context.Request.URL.Query().Get("endDate")
charts.Orders = GetChartData("orders", startDate, endDate)
charts.Users = GetChartData("users", startDate, endDate)
b, _ := json.Marshal(charts)
context.Writer.Write(b)
return
}
// SetupDashboard setup dashboard
func SetupDashboard(Admin *admin.Admin) {
// Add Dashboard
Admin.AddMenu(&admin.Menu{Name: "Dashboard", Link: "/admin", Priority: 1})
Admin.GetRouter().Get("/reports", ReportsDataHandler)
initFuncMap(Admin)
}