-
Notifications
You must be signed in to change notification settings - Fork 31
/
list.go
97 lines (79 loc) · 2.09 KB
/
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
// Copyright 2019-2020 Axetroy. All rights reserved. MIT license.
package news
import (
"errors"
"github.com/axetroy/go-server/internal/library/exception"
"github.com/axetroy/go-server/internal/library/helper"
"github.com/axetroy/go-server/internal/library/router"
"github.com/axetroy/go-server/internal/model"
"github.com/axetroy/go-server/internal/schema"
"github.com/axetroy/go-server/internal/service/database"
"github.com/mitchellh/mapstructure"
"time"
)
type Query struct {
schema.Query
Status *model.NewsStatus `json:"status" form:"status"`
Type *model.NewsType `json:"type" form:"type"`
}
func GetNewsList(input Query) (res schema.Response) {
var (
err error
data = make([]schema.News, 0) // 接口输出的数据
list = make([]model.News, 0) // 数据库查询返回的原始数据
meta = &schema.Meta{}
)
defer func() {
if r := recover(); r != nil {
switch t := r.(type) {
case string:
err = errors.New(t)
case error:
err = t
default:
err = exception.Unknown
}
}
helper.Response(&res, data, meta, err)
}()
query := input.Query
query.Normalize()
filter := map[string]interface{}{}
if input.Status != nil {
filter["status"] = *input.Status
}
if input.Type != nil {
filter["type"] = *input.Type
}
if err = query.Order(database.Db.Limit(query.Limit).Offset(query.Limit * query.Page)).Where(filter).Find(&list).Error; err != nil {
return
}
var total int64
if err = database.Db.Model(model.News{}).Where(filter).Count(&total).Error; err != nil {
return
}
for _, v := range list {
d := schema.News{}
if er := mapstructure.Decode(v, &d.NewsPure); er != nil {
err = er
return
}
d.CreatedAt = v.CreatedAt.Format(time.RFC3339Nano)
d.UpdatedAt = v.UpdatedAt.Format(time.RFC3339Nano)
data = append(data, d)
}
meta.Total = total
meta.Num = len(data)
meta.Page = query.Page
meta.Limit = query.Limit
meta.Sort = query.Sort
return
}
var GetNewsListRouter = router.Handler(func(c router.Context) {
var (
input Query
)
c.ResponseFunc(c.ShouldBindQuery(&input), func() schema.Response {
return GetNewsList(input)
})
})