-
Notifications
You must be signed in to change notification settings - Fork 0
/
route-list.go
116 lines (87 loc) · 2.56 KB
/
route-list.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
package main
import (
"net/http"
"github.com/freitagsrunde/modulist/db"
"github.com/gin-gonic/gin"
"github.com/leebenson/conform"
)
// Structs
type SearchPayload struct {
Query string `conform:"trim,lower"`
}
// Functions
func (app *App) ListModules(c *gin.Context) {
// Check if user is authorized.
User, err := app.Authorize(c.Request, db.PRIVILEGE_REVIEWER)
if err != nil {
c.Redirect(http.StatusFound, "/")
return
}
// Update expiration time of session.
app.CreateSession(c, *User)
// Load all modules beginning with 'A' from database.
var Modules []db.Module
app.DB.Where("lower(\"title\") LIKE ?", "a%").Find(&Modules)
c.HTML(http.StatusOK, "modules-list.html", gin.H{
"PageTitle": "Übersicht der Modulbeschreibungen",
"User": User,
"FirstLetter": "A",
"Modules": Modules,
})
}
func (app *App) SearchModules(c *gin.Context) {
// Check if user is authorized.
User, err := app.Authorize(c.Request, db.PRIVILEGE_REVIEWER)
if err != nil {
c.Redirect(http.StatusFound, "/")
return
}
// Update expiration time of session.
app.CreateSession(c, *User)
// Retrieve query term from URL.
Payload := SearchPayload{
Query: c.Request.URL.Query().Get("query"),
}
// Let it be conformant.
conform.Strings(&Payload)
// Find all modules in main database that contain
// the query in their module titles.
var Modules []db.Module
app.DB.Where("lower(\"title\") LIKE ? OR lower(\"title_english\") LIKE ?", ("%" + Payload.Query + "%"), ("%" + Payload.Query + "%")).Find(&Modules)
c.HTML(http.StatusOK, "modules-list.html", gin.H{
"PageTitle": "Übersicht der Modulbeschreibungen",
"User": User,
"FirstLetter": "all",
"Modules": Modules,
})
}
func (app *App) FilterModulesByLetter(c *gin.Context) {
// Check if user is authorized.
User, err := app.Authorize(c.Request, db.PRIVILEGE_REVIEWER)
if err != nil {
c.Redirect(http.StatusFound, "/")
return
}
// Update expiration time of session.
app.CreateSession(c, *User)
var Modules []db.Module
firstLetter := c.Param("firstLetter")
// Retrieve filter letter from URL.
Payload := SearchPayload{
Query: firstLetter,
}
// Let it be conformant.
conform.Strings(&Payload)
if Payload.Query == "all" {
app.DB.Find(&Modules)
} else {
app.DB.Where("lower(\"title\") LIKE ?", (Payload.Query + "%")).Find(&Modules)
}
c.HTML(http.StatusOK, "modules-list.html", gin.H{
"PageTitle": "Übersicht der Modulbeschreibungen",
"User": User,
"FirstLetter": firstLetter,
"Modules": Modules,
})
}
func (app *App) MarkModuleDone(c *gin.Context) {}