eta_menu_sync/models/eta_business_menu.go

package models

import (
	"eta/eta_menu_sync/global"
	"time"
)

type EtaBusinessMenu struct {
	MenuId     int    `orm:"column(menu_id);pk"`
	ParentId   int    `description:"商家名称"`
	Name       string `description:"商家编码"`
	Sort       int    `description:"排序序号"`
	Path       string `description:"路由地址"`
	IconPath   string `description:"菜单图标地址"`
	Component  string `description:"组件路径"`
	Hidden     int    `description:"是否隐藏：1-隐藏 0-显示"`
	IsLevel    int    `description:"是否为多级菜单：1,只有一级；2,有多级"`
	LevelPath  string `description:"兼容以前menu表的字段"`
	MenuType   int    `description:"菜单类型： 0-菜单; 1-按钮; 2-字段(需要特殊处理)"`
	ButtonCode string `description:"按钮唯一标识"`
	CreateTime time.Time
	ModifyTime time.Time
	Api        string `description:"api"`
	NameEn     string `description:"name_en"`
}

func (m *EtaBusinessMenu) TableName() string {
	return "eta_business_menu"
}

// GetMenuList 获取菜单列表
func (m *EtaBusinessMenu) GetMenuList(businessCode string) (items []*EtaBusinessMenu, err error) {
	sql := `SELECT a.* FROM eta_business_menu AS a
JOIN eta_business_menu_relate AS b ON a.menu_id = b.menu_id
WHERE b.eta_business_id = (
    SELECT eta_business_id FROM eta_business WHERE business_code = ?
) AND b.type = 0;`

	err = global.DEFAULT_MYSQL.Raw(sql, businessCode).Scan(&items).Error
	return
}