You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

107 lines
2.5 KiB

2 years ago
package home
import (
"fmt"
"github.com/gin-gonic/gin"
"github.com/han-joker/moo-layout/api/home/models"
"github.com/han-joker/moo-layout/api/moo/dbm"
"github.com/han-joker/moo-layout/api/moo/logm"
"github.com/han-joker/moo-layout/api/tables"
"net/http"
"strings"
)
const (
contentsLimit = 10
)
func ContentGets(c *gin.Context) {
query := models.ContentsQuery{}
if err := c.ShouldBind(&query); err != nil {
logm.Get().Info(err.Error())
c.JSON(http.StatusOK, gin.H{
"error": err.Error(),
})
return
}
rows := make([]tables.Content, 0)
db := dbm.Get().Model(&tables.Content{})
db.Where("status=?", tables.ContentStatusPublish)
if len(query.Filters.IDs) > 0 {
db.Where("id IN ?", query.Filters.IDs)
}
if query.Filters.CategoryID != 0 {
db.Where("category_id=?", query.Filters.CategoryID)
}
if len(query.Filters.Status) > 0 {
db.Where("status IN ?", query.Filters.Status)
}
if len(query.Filters.Promotes) > 0 {
pc := make([]string, len(query.Filters.Promotes))
pv := make([]interface{}, len(query.Filters.Promotes))
for i, p := range query.Filters.Promotes {
pc[i] = "promotes & ? > 0"
pv[i] = p
}
db.Where(strings.Join(pc, " OR "), pv...)
}
if query.Sorter.Field != "" && query.Sorter.Order != "" {
db.Order(fmt.Sprintf("%s %s", query.Sorter.Field, models.OrderText[query.Sorter.Order])).
Order("updated_at desc")
} else {
db.Order("updated_at desc")
}
db.Count(&query.Pagination.Total)
if query.Pagination.PageSize > 0 {
offset := (query.Pagination.Current - 1) * query.Pagination.PageSize
db.Limit(query.Pagination.PageSize).Offset(offset)
}
db.Find(&rows)
c.JSON(http.StatusOK, gin.H{
"error": nil,
"rows": rows,
"pagination": query.Pagination,
"filters": query.Filters,
"sorter": query.Sorter,
})
}
func ContentGet(c *gin.Context) {
query := models.ContentQuery{}
if err := c.ShouldBind(&query); err != nil {
logm.Get().Info(err.Error())
c.JSON(http.StatusOK, gin.H{
"error": err.Error(),
})
return
}
row := tables.Content{}
if err := dbm.Get().Where("status=?", tables.ContentStatusPublish).Where("id=?", query.ID).First(&row).Error; err != nil {
logm.Get().Info(err.Error())
c.JSON(http.StatusOK, gin.H{
"error": err.Error(),
})
return
}
if query.WithCategory {
dbm.Get().Model(&row).Association("Category").Find(&row.Category)
}
if query.WithUser {
dbm.Get().Model(&row).Association("User").Find(&row.User)
}
c.JSON(http.StatusOK, gin.H{
"error": nil,
"row": row,
})
}