package eta_business import ( "fmt" "github.com/beego/beego/v2/client/orm" "strings" ) // EtaBusinessMenuRelate ETA商家菜单关联表 type EtaBusinessMenuRelate struct { Id int `orm:"column(id);pk"` EtaBusinessId int `description:"商家ID"` MenuId int `description:"菜单ID"` Type int `description:"类型: 0-全选; 1-半选(此字段仅供前端回显做区分)"` } func (m *EtaBusinessMenuRelate) TableName() string { return "eta_business_menu_relate" } func (m *EtaBusinessMenuRelate) PrimaryId() string { return "id" } func (m *EtaBusinessMenuRelate) Create() (err error) { o := orm.NewOrm() id, err := o.Insert(m) if err != nil { return } m.MenuId = int(id) return } func (m *EtaBusinessMenuRelate) CreateMulti(businessId int, items []*EtaBusinessMenuRelate) (err error) { if businessId == 0 { return } o := orm.NewOrm() tx, err := o.Begin() if err != nil { return } defer func() { if err != nil { _ = tx.Rollback() return } _ = tx.Commit() }() sql := fmt.Sprintf(`DELETE FROM %s WHERE eta_business_id = ?`, m.TableName()) _, err = tx.Raw(sql, businessId).Exec() if err != nil { return } if len(items) > 0 { _, err = tx.InsertMulti(len(items), items) } return } func (m *EtaBusinessMenuRelate) Update(cols []string) (err error) { o := orm.NewOrm() _, err = o.Update(m, cols...) return } func (m *EtaBusinessMenuRelate) Del() (err error) { o := orm.NewOrm() sql := fmt.Sprintf(`DELETE FROM %s WHERE %s = ? LIMIT 1`, m.TableName(), m.PrimaryId()) _, err = o.Raw(sql, m.MenuId).Exec() return } func (m *EtaBusinessMenuRelate) GetItemById(id int) (item *EtaBusinessMenuRelate, err error) { o := orm.NewOrm() sql := fmt.Sprintf(`SELECT * FROM %s WHERE %s = ? LIMIT 1`, m.TableName(), m.PrimaryId()) err = o.Raw(sql, id).QueryRow(&item) return } func (m *EtaBusinessMenuRelate) GetItemByCondition(condition string, pars []interface{}) (item *EtaBusinessMenuRelate, err error) { o := orm.NewOrm() sql := fmt.Sprintf(`SELECT * FROM %s WHERE 1=1 %s LIMIT 1`, m.TableName(), condition) err = o.Raw(sql, pars).QueryRow(&item) return } func (m *EtaBusinessMenuRelate) GetCountByCondition(condition string, pars []interface{}) (count int, err error) { o := orm.NewOrm() sql := fmt.Sprintf(`SELECT COUNT(1) FROM %s WHERE 1=1 %s`, m.TableName(), condition) err = o.Raw(sql, pars).QueryRow(&count) return } func (m *EtaBusinessMenuRelate) GetItemsByCondition(condition string, pars []interface{}, fieldArr []string, orderRule string) (items []*EtaBusinessMenuRelate, err error) { o := orm.NewOrm() fields := strings.Join(fieldArr, ",") if len(fieldArr) == 0 { fields = `*` } order := `` if orderRule != "" { order = ` ORDER BY ` + orderRule } sql := fmt.Sprintf(`SELECT %s FROM %s WHERE 1=1 %s %s`, fields, m.TableName(), condition, order) _, err = o.Raw(sql, pars).QueryRows(&items) return } func (m *EtaBusinessMenuRelate) GetPageItemsByCondition(condition string, pars []interface{}, fieldArr []string, orderRule string, startSize, pageSize int) (items []*EtaBusinessMenuRelate, err error) { o := orm.NewOrm() fields := strings.Join(fieldArr, ",") if len(fieldArr) == 0 { fields = `*` } order := `` if orderRule != "" { order = ` ORDER BY ` + orderRule } sql := fmt.Sprintf(`SELECT %s FROM %s WHERE 1=1 %s %s LIMIT ?,?`, fields, m.TableName(), condition, order) _, err = o.Raw(sql, pars, startSize, pageSize).QueryRows(&items) return } // EtaBusinessMenuRelateSaveReq 保存商家菜单关联 type EtaBusinessMenuRelateSaveReq struct { EtaBusinessId int `description:"商家ID"` MenuIds []int `description:"菜单IDs"` HalfMenuIds []int `description:"半选菜单IDs-仅供前端回显用的"` }