1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768 |
- package models
- import "github.com/beego/beego/v2/client/orm"
- type UserCollectClassify struct {
- UserCollectClassifyId int `orm:"column(user_collect_classify_id);pk" description:"用户收藏的分类id"`
- ClassifyId int `orm:"column(classify_id)" description:"分类id"`
- SysUserId int `orm:"column(sys_user_id)" description:"收藏人用户id"`
- CreateTime string `orm:"column(create_time)" description:"收藏时间"`
- }
- func GetUserCollectClassifyList(sysUserId, classifyId int) (list []*UserCollectClassify, err error) {
- o := orm.NewOrmUsingDB("rddp")
- sql := `SELECT * FROM user_collect_classify WHERE 1=1`
- var params []interface{}
-
- if sysUserId > 0 {
- sql += ` AND sys_user_id=?`
- params = append(params, sysUserId)
- }
-
- if classifyId > 0 {
- sql += ` AND classify_id=?`
- params = append(params, classifyId)
- }
- _, err = o.Raw(sql, params...).QueryRows(&list)
- return
- }
- func InsertUserCollectClassify(item UserCollectClassify) (err error) {
- o := orm.NewOrmUsingDB("rddp")
- sql := `INSERT INTO user_collect_classify(classify_id, sys_user_id, create_time) VALUES(?, ?, ?)`
- _, err = o.Raw(sql, item.ClassifyId, item.SysUserId, item.CreateTime).Exec()
- return
- }
- func DeleteUserCollectClassify(sysUserId, classifyId int) (err error) {
- o := orm.NewOrmUsingDB("rddp")
- sql := `DELETE FROM user_collect_classify WHERE sys_user_id=? AND classify_id=?`
- _, err = o.Raw(sql, sysUserId, classifyId).Exec()
- return
- }
- func DeleteCollectByClassifyId(classifyId int) (err error) {
- o := orm.NewOrmUsingDB("rddp")
- sql := `DELETE FROM user_collect_classify WHERE classify_id=?`
- _, err = o.Raw(sql, classifyId).Exec()
- return
- }
|