38 lines
715 B
Go
38 lines
715 B
Go
|
package gorm_models
|
||
|
|
|
||
|
|
import (
|
||
|
|
"log"
|
||
|
|
|
||
|
|
"gorm.io/gorm"
|
||
|
|
)
|
||
|
|
|
||
|
|
type CategoryTranslation struct {
|
||
|
|
ID uint `gorm:"primaryKey"`
|
||
|
|
Slug string
|
||
|
|
CategoryID uint
|
||
|
|
MetaDescription string
|
||
|
|
MetaKeywords string
|
||
|
|
Locale string
|
||
|
|
}
|
||
|
|
|
||
|
|
type Category struct {
|
||
|
|
ID uint `gorm:"primaryKey"`
|
||
|
|
Status int8
|
||
|
|
Position int
|
||
|
|
ParentId uint
|
||
|
|
DisplayMode string
|
||
|
|
Translations []CategoryTranslation
|
||
|
|
}
|
||
|
|
|
||
|
|
func GetMainCategories(db *gorm.DB) []Category {
|
||
|
|
var categories []Category
|
||
|
|
err := db.Model(&Category{}).Preload("Translations").Find(&categories, "status=1 AND parent_id=1 AND display_mode!='promotion'").Error
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
log.Println(err.Error())
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
return categories
|
||
|
|
}
|