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
|
package tags
import (
"log"
"math"
"net/http"
"strconv"
"fagott.pw/charakterin"
"fagott.pw/grilist/frontend"
"fagott.pw/grilist/grilist"
"fagott.pw/grilist/modules/grils"
"github.com/julienschmidt/httprouter"
)
type Module struct {
g *grilist.Grilist
grils *grils.GrilsModule
}
func New() *Module {
return &Module{}
}
func (m *Module) Name() string {
return "Tags"
}
func (m *Module) Init(g *grilist.Grilist) {
m.g = g
gm, ok := g.Modules["Grils"]
if !ok {
log.Fatal("tags: grils module not found")
}
m.grils = gm.(*grils.GrilsModule)
m.g.Router.GET("/tag/:tag", m.viewTag)
m.g.Router.GET("/tag/:tag/:page", m.viewTagPage)
}
func (m *Module) Interface() interface{} {
return m
}
func (m *Module) ProvideDashboardData(user *charakterin.User) []grilist.DashboardCategory {
return make([]grilist.DashboardCategory, 0)
}
func (m *Module) viewTag(w http.ResponseWriter, r *http.Request, p httprouter.Params) {
p = append(p, httprouter.Param{
Key: "page",
Value: "1",
})
m.viewTagPage(w, r, p)
}
func (m *Module) viewTagPage(w http.ResponseWriter, r *http.Request, p httprouter.Params) {
user, _ := m.g.Charakterin.GetUserFromRequest(r)
tag := p.ByName("tag")
var tagID int
row := m.g.DB.QueryRow("SELECT id FROM grilist.tags WHERE name = $1;", tag)
if err := row.Scan(&tagID); err != nil {
log.Println("error getting tag id", err)
http.Redirect(w, r, "/", 302)
return
}
pageNumber, err := strconv.Atoi(p.ByName("page"))
if err != nil || pageNumber < 1 {
pageNumber = 1
}
// Anzahl an Pages holen
var pageNum int
err = m.g.DB.QueryRow(`SELECT COUNT(*) FROM grilist.grils_tags WHERE tag_id = $1`, tagID).Scan(&pageNum)
if err != nil {
log.Println("error getting page count", err)
http.Redirect(w, r, "/", 302)
return
}
pageCount := (int)(math.Ceil(float64(pageNum) / 12.0))
if pageNumber > pageCount {
pageNumber = pageCount
}
idList := make([]int, 0)
rows, err := m.g.DB.Query(
"SELECT gril_id FROM grilist.grils_tags WHERE tag_id = $1 LIMIT 12 OFFSET $2",
tagID, (pageNumber-1)*12)
if err != nil {
log.Println("error getting idList", err)
http.Redirect(w, r, "/", 302)
return
}
defer rows.Close()
for rows.Next() {
var grilID int
rows.Scan(&grilID)
idList = append(idList, grilID)
}
grils, err := m.grils.FromIDs(idList)
if err != nil {
log.Println(err)
http.Redirect(w, r, "/", 302)
return
}
cards := make([]frontend.Card, 0)
for _, v := range grils {
cards = append(cards, frontend.Card{
Title: v.RomajiName,
Description: v.KanjiName,
Size: "medium",
Actions: []frontend.Action{
frontend.Action{
Name: "anguckieren",
Link: "/gril/" + v.Slug(),
},
},
})
}
data := m.g.Renderer.DefaultData()
data["user"] = user
data["tag"] = tag
data["cards"] = cards
data["pagination"] = frontend.PaginationFromPage(3, pageNumber, pageCount)
m.g.Renderer.RenderPage("tag", w, data)
}
|