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
|
package meta
import (
"shrine/types/common"
"strconv"
"github.com/gofiber/fiber/v2"
"gorm.io/gorm"
)
type Pagination struct {
Page int
PerPage int
}
type Sorting struct {
Field string
Direction string
}
func Paginate(context *fiber.Ctx) Pagination {
request := Request(context)
pageStr, _ := request.Query("page")
page, _ := strconv.Atoi(pageStr)
if page < 1 {
page = 1
}
perPageStr, _ := request.Query("per_page")
perPage, _ := strconv.Atoi(perPageStr)
if perPage < 1 || perPage > 50 {
perPage = 20
}
return Pagination{Page: page, PerPage: perPage}
}
func Sort(context *fiber.Ctx, allowed []string, fallback string) Sorting {
request := Request(context)
field, _ := request.Query("sort")
direction, _ := request.Query("order")
valid := false
for _, column := range allowed {
if field == column {
valid = true
break
}
}
if !valid {
field = fallback
}
if direction != "asc" && direction != "desc" {
direction = "desc"
}
return Sorting{Field: field, Direction: direction}
}
func (self Pagination) Apply(query *gorm.DB) *gorm.DB {
return query.Offset((self.Page - 1) * self.PerPage).Limit(self.PerPage)
}
func (self Sorting) Apply(query *gorm.DB) *gorm.DB {
return query.Order(self.Field + " " + self.Direction)
}
func (self Pagination) Response(items any, total int64) common.PaginatedResponse {
totalPages := int(total) / self.PerPage
if int(total)%self.PerPage > 0 {
totalPages++
}
return common.PaginatedResponse{
Items: items,
Total: total,
Page: self.Page,
PerPage: self.PerPage,
TotalPages: totalPages,
}
}
|
