379 lines
16 KiB
Go
379 lines
16 KiB
Go
package models
|
||
|
||
import (
|
||
"time"
|
||
)
|
||
|
||
// =============================================================
|
||
// 平台官网管理模型（表前缀 yz_platform_website_）
|
||
//
|
||
// 对应 platform 端「官网管理」模块，仅服务平台主站官网，
|
||
// 与租户站点内容表（yz_cms_*）互相独立。
|
||
// 建表 SQL：docs/sql/create_platform_website.sql
|
||
// =============================================================
|
||
|
||
// PlatformWebsiteCategory 平台官网-文章分类 yz_platform_website_category
|
||
type PlatformWebsiteCategory struct {
|
||
ID uint64 `orm:"column(id);pk;auto" json:"id"`
|
||
Cid uint64 `orm:"column(cid);default(0)" json:"cid"` // 父级分类ID，0 为顶级
|
||
Name string `orm:"column(name);size(100);default('')" json:"name"`
|
||
Image string `orm:"column(image);size(500);default('')" json:"image"`
|
||
Desc string `orm:"column(desc);size(500);default('')" json:"desc"`
|
||
Sort int `orm:"column(sort);default(0)" json:"sort"`
|
||
Status int8 `orm:"column(status);default(1)" json:"status"`
|
||
CreateTime time.Time `orm:"column(create_time);type(datetime);auto_now_add" json:"create_time"`
|
||
UpdateTime *time.Time `orm:"column(update_time);type(datetime);null" json:"update_time"`
|
||
DeleteTime *time.Time `orm:"column(delete_time);type(datetime);null" json:"delete_time"`
|
||
}
|
||
|
||
func (m *PlatformWebsiteCategory) TableName() string {
|
||
return "yz_platform_website_category"
|
||
}
|
||
|
||
// PlatformWebsiteArticle 平台官网-文章 yz_platform_website_article
|
||
type PlatformWebsiteArticle struct {
|
||
ID uint64 `orm:"column(id);pk;auto" json:"id"`
|
||
CateID uint64 `orm:"column(cate_id);default(0)" json:"cate_id"`
|
||
Title string `orm:"column(title);size(255);default('')" json:"title"`
|
||
Author string `orm:"column(author);size(100);default('')" json:"author"`
|
||
Desc string `orm:"column(desc);size(500);default('')" json:"desc"`
|
||
Image string `orm:"column(image);size(500);default('')" json:"image"`
|
||
Content string `orm:"column(content);type(mediumtext);null" json:"content"`
|
||
IsTrans int8 `orm:"column(is_trans);default(0)" json:"is_trans"`
|
||
TransURL *string `orm:"column(transurl);size(500);null" json:"transurl"`
|
||
Status int8 `orm:"column(status);default(0)" json:"status"` // 0 草稿 1 待审核 2 已发布 3 已隐藏
|
||
Top int8 `orm:"column(top);default(0)" json:"top"`
|
||
Recommend int8 `orm:"column(recommend);default(0)" json:"recommend"`
|
||
Views int `orm:"column(views);default(0)" json:"views"`
|
||
Likes int `orm:"column(likes);default(0)" json:"likes"`
|
||
PublisherID *uint64 `orm:"column(publisher_id);null" json:"publisher_id"`
|
||
PublishTime *time.Time `orm:"column(publish_time);type(datetime);null" json:"publish_time"`
|
||
CreateTime time.Time `orm:"column(create_time);type(datetime);auto_now_add" json:"create_time"`
|
||
UpdateTime *time.Time `orm:"column(update_time);type(datetime);null" json:"update_time"`
|
||
DeleteTime *time.Time `orm:"column(delete_time);type(datetime);null" json:"delete_time"`
|
||
}
|
||
|
||
func (m *PlatformWebsiteArticle) TableName() string {
|
||
return "yz_platform_website_article"
|
||
}
|
||
|
||
// PlatformWebsiteTag 平台官网-标签 yz_platform_website_tag
|
||
type PlatformWebsiteTag struct {
|
||
ID uint64 `orm:"column(id);pk;auto" json:"id"`
|
||
Name string `orm:"column(name);size(50);default('')" json:"name"`
|
||
Sort int `orm:"column(sort);default(0)" json:"sort"`
|
||
Status int8 `orm:"column(status);default(1)" json:"status"`
|
||
CreateTime time.Time `orm:"column(create_time);type(datetime);auto_now_add" json:"create_time"`
|
||
UpdateTime *time.Time `orm:"column(update_time);type(datetime);null" json:"update_time"`
|
||
DeleteTime *time.Time `orm:"column(delete_time);type(datetime);null" json:"delete_time"`
|
||
}
|
||
|
||
func (m *PlatformWebsiteTag) TableName() string {
|
||
return "yz_platform_website_tag"
|
||
}
|
||
|
||
// PlatformWebsiteArticleTag 平台官网-文章标签关联 yz_platform_website_article_tag
|
||
type PlatformWebsiteArticleTag struct {
|
||
ID uint64 `orm:"column(id);pk;auto" json:"id"`
|
||
ArticleID uint64 `orm:"column(article_id);default(0)" json:"article_id"`
|
||
TagID uint64 `orm:"column(tag_id);default(0)" json:"tag_id"`
|
||
CreateTime time.Time `orm:"column(create_time);type(datetime);auto_now_add" json:"create_time"`
|
||
}
|
||
|
||
func (m *PlatformWebsiteArticleTag) TableName() string {
|
||
return "yz_platform_website_article_tag"
|
||
}
|
||
|
||
// PlatformWebsiteComment 平台官网-评论 yz_platform_website_comment
|
||
type PlatformWebsiteComment struct {
|
||
ID uint64 `orm:"column(id);pk;auto" json:"id"`
|
||
ArticleID uint64 `orm:"column(article_id);default(0)" json:"article_id"`
|
||
Nickname string `orm:"column(nickname);size(100);default('')" json:"nickname"`
|
||
Email string `orm:"column(email);size(150);default('')" json:"email"`
|
||
Content string `orm:"column(content);type(text);null" json:"content"`
|
||
Reply string `orm:"column(reply);type(text);null" json:"reply"`
|
||
Status int8 `orm:"column(status);default(0)" json:"status"` // 0 待审核 1 已通过 2 已拒绝
|
||
IP string `orm:"column(ip);size(64);default('')" json:"ip"`
|
||
CreateTime time.Time `orm:"column(create_time);type(datetime);auto_now_add" json:"create_time"`
|
||
UpdateTime *time.Time `orm:"column(update_time);type(datetime);null" json:"update_time"`
|
||
DeleteTime *time.Time `orm:"column(delete_time);type(datetime);null" json:"delete_time"`
|
||
}
|
||
|
||
func (m *PlatformWebsiteComment) TableName() string {
|
||
return "yz_platform_website_comment"
|
||
}
|
||
|
||
// PlatformWebsiteNav 平台官网-导航菜单 yz_platform_website_nav
|
||
type PlatformWebsiteNav struct {
|
||
ID uint64 `orm:"column(id);pk;auto" json:"id"`
|
||
Pid uint64 `orm:"column(pid);default(0)" json:"pid"`
|
||
Title string `orm:"column(title);size(100);default('')" json:"title"`
|
||
Type int8 `orm:"column(type);default(1)" json:"type"` // 1 目录 2 页面 3 外链 4 单页
|
||
Path string `orm:"column(path);size(255);default('')" json:"path"`
|
||
ComponentPath string `orm:"column(component_path);size(255);default('')" json:"component_path"`
|
||
Icon string `orm:"column(icon);size(100);default('')" json:"icon"`
|
||
Sort int `orm:"column(sort);default(0)" json:"sort"`
|
||
Status int8 `orm:"column(status);default(1)" json:"status"`
|
||
IsVisible int8 `orm:"column(is_visible);default(1)" json:"is_visible"`
|
||
Permission string `orm:"column(permission);size(100);default('')" json:"permission"`
|
||
CreateTime time.Time `orm:"column(create_time);type(datetime);auto_now_add" json:"create_time"`
|
||
UpdateTime *time.Time `orm:"column(update_time);type(datetime);null" json:"update_time"`
|
||
DeleteTime *time.Time `orm:"column(delete_time);type(datetime);null" json:"delete_time"`
|
||
}
|
||
|
||
func (m *PlatformWebsiteNav) TableName() string {
|
||
return "yz_platform_website_nav"
|
||
}
|
||
|
||
// PlatformWebsiteLink 平台官网-友情链接 yz_platform_website_link
|
||
type PlatformWebsiteLink struct {
|
||
ID uint64 `orm:"column(id);pk;auto" json:"id"`
|
||
LinkName string `orm:"column(link_name);size(100);default('')" json:"link_name"`
|
||
LinkURL string `orm:"column(link_url);size(500);default('')" json:"link_url"`
|
||
LinkLogo string `orm:"column(link_logo);size(500);default('')" json:"link_logo"`
|
||
Description string `orm:"column(description);size(255);default('')" json:"description"`
|
||
Sort int `orm:"column(sort);default(0)" json:"sort"`
|
||
Status int8 `orm:"column(status);default(1)" json:"status"`
|
||
CreateTime time.Time `orm:"column(create_time);type(datetime);auto_now_add" json:"create_time"`
|
||
UpdateTime *time.Time `orm:"column(update_time);type(datetime);null" json:"update_time"`
|
||
DeleteTime *time.Time `orm:"column(delete_time);type(datetime);null" json:"delete_time"`
|
||
}
|
||
|
||
func (m *PlatformWebsiteLink) TableName() string {
|
||
return "yz_platform_website_link"
|
||
}
|
||
|
||
// PlatformWebsitePage 平台官网-单页 yz_platform_website_page
|
||
type PlatformWebsitePage struct {
|
||
ID uint64 `orm:"column(id);pk;auto" json:"id"`
|
||
Title string `orm:"column(title);size(255);default('')" json:"title"`
|
||
Path string `orm:"column(path);size(200);default('')" json:"path"`
|
||
Content string `orm:"column(content);type(longtext);null" json:"content"`
|
||
Sort int `orm:"column(sort);default(0)" json:"sort"`
|
||
Status int8 `orm:"column(status);default(1)" json:"status"`
|
||
CreateTime time.Time `orm:"column(create_time);type(datetime);auto_now_add" json:"create_time"`
|
||
UpdateTime *time.Time `orm:"column(update_time);type(datetime);null" json:"update_time"`
|
||
DeleteTime *time.Time `orm:"column(delete_time);type(datetime);null" json:"delete_time"`
|
||
}
|
||
|
||
func (m *PlatformWebsitePage) TableName() string {
|
||
return "yz_platform_website_page"
|
||
}
|
||
|
||
// PlatformWebsiteNotice 平台官网-站点公告 yz_platform_website_notice
|
||
// 建表 SQL：docs/sql/create_platform_website_notice.sql
|
||
type PlatformWebsiteNotice struct {
|
||
ID uint64 `orm:"column(id);pk;auto" json:"id"`
|
||
Title string `orm:"column(title);size(255);default('')" json:"title"`
|
||
Summary string `orm:"column(summary);size(500);default('')" json:"summary"`
|
||
Content string `orm:"column(content);type(mediumtext);null" json:"content"`
|
||
Type int8 `orm:"column(type);default(1)" json:"type"` // 1 通知公告 2 活动公告 3 系统维护
|
||
LinkURL string `orm:"column(link_url);size(500);default('')" json:"link_url"`
|
||
IsPopup int8 `orm:"column(is_popup);default(0)" json:"is_popup"` // 是否作为弹窗公告
|
||
Top int8 `orm:"column(top);default(0)" json:"top"` // 是否置顶
|
||
Sort int `orm:"column(sort);default(0)" json:"sort"`
|
||
Status int8 `orm:"column(status);default(0)" json:"status"` // 0 草稿 1 已发布 2 已下线
|
||
StartTime *time.Time `orm:"column(start_time);type(datetime);null" json:"start_time"`
|
||
EndTime *time.Time `orm:"column(end_time);type(datetime);null" json:"end_time"`
|
||
Views int `orm:"column(views);default(0)" json:"views"`
|
||
PublisherID *uint64 `orm:"column(publisher_id);null" json:"publisher_id"`
|
||
PublishTime *time.Time `orm:"column(publish_time);type(datetime);null" json:"publish_time"`
|
||
CreateTime time.Time `orm:"column(create_time);type(datetime);auto_now_add" json:"create_time"`
|
||
UpdateTime *time.Time `orm:"column(update_time);type(datetime);null" json:"update_time"`
|
||
DeleteTime *time.Time `orm:"column(delete_time);type(datetime);null" json:"delete_time"`
|
||
}
|
||
|
||
func (m *PlatformWebsiteNotice) TableName() string {
|
||
return "yz_platform_website_notice"
|
||
}
|
||
|
||
// ===================== 公共查询helper =====================
|
||
|
||
// PlatformWebsiteCategoryNameMap 分类ID -> 分类名称
|
||
func PlatformWebsiteCategoryNameMap(ids []uint64) map[uint64]string {
|
||
out := make(map[uint64]string)
|
||
if len(ids) == 0 {
|
||
return out
|
||
}
|
||
var rows []PlatformWebsiteCategory
|
||
if _, err := Orm.QueryTable(new(PlatformWebsiteCategory)).
|
||
Filter("id__in", ids).
|
||
All(&rows, "ID", "Name"); err != nil {
|
||
return out
|
||
}
|
||
for _, r := range rows {
|
||
out[r.ID] = r.Name
|
||
}
|
||
return out
|
||
}
|
||
|
||
// PlatformWebsiteCategoryMap 分类ID -> 分类记录
|
||
// 官网前台用：展示分类名与描述，并在文章没有封面图时用分类图片兜底。
|
||
func PlatformWebsiteCategoryMap(ids []uint64) map[uint64]PlatformWebsiteCategory {
|
||
out := make(map[uint64]PlatformWebsiteCategory)
|
||
if len(ids) == 0 {
|
||
return out
|
||
}
|
||
var rows []PlatformWebsiteCategory
|
||
if _, err := Orm.QueryTable(new(PlatformWebsiteCategory)).
|
||
Filter("id__in", ids).
|
||
All(&rows, "ID", "Name", "Desc", "Image"); err != nil {
|
||
return out
|
||
}
|
||
for _, r := range rows {
|
||
out[r.ID] = r
|
||
}
|
||
return out
|
||
}
|
||
|
||
// PlatformWebsiteCategoryDescendantMap 分类ID -> 全部后代分类ID（不含自身）
|
||
//
|
||
// 官网前台按父分类筛选 / 统计数量时，需要把整棵子树都算进来：
|
||
// 文章挂在子分类上时，点父分类也应该能看到。
|
||
// 分类数据量很小，每次整体构建一次即可；存在环时靠 seen 截断。
|
||
func PlatformWebsiteCategoryDescendantMap() map[uint64][]uint64 {
|
||
out := make(map[uint64][]uint64)
|
||
|
||
var rows []PlatformWebsiteCategory
|
||
if _, err := Orm.QueryTable(new(PlatformWebsiteCategory)).
|
||
Filter("delete_time__isnull", true).
|
||
All(&rows, "ID", "Cid"); err != nil {
|
||
return out
|
||
}
|
||
|
||
children := make(map[uint64][]uint64, len(rows))
|
||
ids := make([]uint64, 0, len(rows))
|
||
for _, r := range rows {
|
||
ids = append(ids, r.ID)
|
||
if r.Cid > 0 && r.Cid != r.ID {
|
||
children[r.Cid] = append(children[r.Cid], r.ID)
|
||
}
|
||
}
|
||
|
||
var walk func(id uint64, seen map[uint64]bool) []uint64
|
||
walk = func(id uint64, seen map[uint64]bool) []uint64 {
|
||
res := make([]uint64, 0, len(children[id]))
|
||
for _, child := range children[id] {
|
||
if seen[child] {
|
||
continue
|
||
}
|
||
seen[child] = true
|
||
res = append(res, child)
|
||
res = append(res, walk(child, seen)...)
|
||
}
|
||
return res
|
||
}
|
||
|
||
for _, id := range ids {
|
||
out[id] = walk(id, map[uint64]bool{id: true})
|
||
}
|
||
return out
|
||
}
|
||
|
||
// PlatformWebsiteArticleTitleMap 文章ID -> 标题（评论列表展示所属文章用）
|
||
func PlatformWebsiteArticleTitleMap(ids []uint64) map[uint64]string {
|
||
out := make(map[uint64]string)
|
||
if len(ids) == 0 {
|
||
return out
|
||
}
|
||
var rows []PlatformWebsiteArticle
|
||
if _, err := Orm.QueryTable(new(PlatformWebsiteArticle)).
|
||
Filter("id__in", ids).
|
||
All(&rows, "ID", "Title"); err != nil {
|
||
return out
|
||
}
|
||
for _, r := range rows {
|
||
out[r.ID] = r.Title
|
||
}
|
||
return out
|
||
}
|
||
|
||
// PlatformWebsiteArticleTagNameMap 文章ID -> 标签名称列表（官网前台展示用）
|
||
func PlatformWebsiteArticleTagNameMap(articleIDs []uint64) map[uint64][]string {
|
||
out := make(map[uint64][]string)
|
||
if len(articleIDs) == 0 {
|
||
return out
|
||
}
|
||
var links []PlatformWebsiteArticleTag
|
||
if _, err := Orm.QueryTable(new(PlatformWebsiteArticleTag)).
|
||
Filter("article_id__in", articleIDs).
|
||
All(&links, "ID", "ArticleID", "TagID"); err != nil {
|
||
return out
|
||
}
|
||
if len(links) == 0 {
|
||
return out
|
||
}
|
||
|
||
tagIDs := make([]uint64, 0, len(links))
|
||
for _, l := range links {
|
||
tagIDs = append(tagIDs, l.TagID)
|
||
}
|
||
var tags []PlatformWebsiteTag
|
||
if _, err := Orm.QueryTable(new(PlatformWebsiteTag)).
|
||
Filter("id__in", tagIDs).
|
||
Filter("delete_time__isnull", true).
|
||
All(&tags, "ID", "Name"); err != nil {
|
||
return out
|
||
}
|
||
nameMap := make(map[uint64]string, len(tags))
|
||
for _, t := range tags {
|
||
nameMap[t.ID] = t.Name
|
||
}
|
||
|
||
for _, l := range links {
|
||
if name, ok := nameMap[l.TagID]; ok && name != "" {
|
||
out[l.ArticleID] = append(out[l.ArticleID], name)
|
||
}
|
||
}
|
||
return out
|
||
}
|
||
|
||
// PlatformWebsiteArticleTagIDs 取某文章绑定的标签ID列表
|
||
func PlatformWebsiteArticleTagIDs(articleID uint64) []uint64 {
|
||
out := make([]uint64, 0)
|
||
if articleID == 0 {
|
||
return out
|
||
}
|
||
var rows []PlatformWebsiteArticleTag
|
||
if _, err := Orm.QueryTable(new(PlatformWebsiteArticleTag)).
|
||
Filter("article_id", articleID).
|
||
All(&rows, "ID", "TagID"); err != nil {
|
||
return out
|
||
}
|
||
for _, r := range rows {
|
||
out = append(out, r.TagID)
|
||
}
|
||
return out
|
||
}
|
||
|
||
// SetPlatformWebsiteArticleTags 覆盖式写入文章标签（先清空再插入）
|
||
func SetPlatformWebsiteArticleTags(articleID uint64, tagIDs []uint64) error {
|
||
if articleID == 0 {
|
||
return nil
|
||
}
|
||
if _, err := Orm.QueryTable(new(PlatformWebsiteArticleTag)).
|
||
Filter("article_id", articleID).
|
||
Delete(); err != nil {
|
||
return err
|
||
}
|
||
seen := make(map[uint64]bool, len(tagIDs))
|
||
for _, tid := range tagIDs {
|
||
if tid == 0 || seen[tid] {
|
||
continue
|
||
}
|
||
seen[tid] = true
|
||
if _, err := Orm.Insert(&PlatformWebsiteArticleTag{ArticleID: articleID, TagID: tid}); err != nil {
|
||
return err
|
||
}
|
||
}
|
||
return nil
|
||
}
|
||
|
||
// ClearPlatformWebsiteArticleTags 删除文章时清理标签关联
|
||
func ClearPlatformWebsiteArticleTags(articleID uint64) error {
|
||
_, err := Orm.QueryTable(new(PlatformWebsiteArticleTag)).
|
||
Filter("article_id", articleID).
|
||
Delete()
|
||
return err
|
||
}
|