1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980 |
- package models
- import (
- //"hongze/hongze_admin/models"
- "github.com/beego/beego/v2/client/orm"
- "time"
- )
- type CygxActivitySpecialTrip struct {
- Id int `orm:"column(id);pk"`
- UserId int `description:"用户id,多个用,隔开"`
- ActivityId int `description:"活动ID"`
- CreateTime time.Time `description:"创建时间"`
- Mobile string `description:"手机号"`
- Email string `description:"邮箱号"`
- CompanyId int `description:"公司ID"`
- CompanyName string `description:"公司名称"`
- RealName string `description:"用户实际名称"`
- SellerName string `description:"所属销售"`
- AdminId int `description:"销售/管理员ID"`
- Source int `description:"来源,1小程序,2后台添加"`
- OutboundMobile string `description:"外呼手机号"`
- CountryCode string `description:"手机国家区号"`
- }
- type CygxActivitySpecialTripResp struct {
- Id int `description:"ID"`
- UserId int `description:"用户id"`
- ActivityId int `description:"活动ID"`
- CreateTime string `description:"创建时间"`
- Mobile string `description:"手机号"`
- Email string `description:"邮箱号"`
- CompanyId int `description:"公司ID"`
- CompanyName string `description:"公司名称"`
- RealName string `description:"用户实际名称"`
- SellerName string `description:"所属销售"`
- OutboundMobile string `description:"外呼手机号"`
- CountryCode string `description:"手机国家区号"`
- }
- func GetCygxActivitySpecialTripList(condition string, pars []interface{}) (item []*CygxActivitySpecialTripResp, err error) {
- o := orm.NewOrm()
- sql := `SELECT *
- FROM
- cygx_activity_special_trip
- WHERE 1 = 1 ` + condition
- _, err = o.Raw(sql, pars).QueryRows(&item)
- return
- }
- //获取某一用户的报名的数量
- func GetUserActivitySpecialTripCount(uid, activityId int) (count int, err error) {
- sqlCount := `SELECT COUNT(1) AS count FROM cygx_activity_special_trip WHERE user_id=? AND activity_id =? `
- o := orm.NewOrm()
- err = o.Raw(sqlCount, uid, activityId).QueryRow(&count)
- return
- }
- //获取某一活动的报名的数量
- func GetActivitySpecialTripCountByActivityId(condition string, pars []interface{}) (count int, err error) {
- sqlCount := `SELECT COUNT(1) AS count FROM cygx_activity_special_trip WHERE 1 = 1 ` + condition
- o := orm.NewOrm()
- err = o.Raw(sqlCount, pars).QueryRow(&count)
- return
- }
- //添加
- func AddCygxActivitySpecialTrip(item *CygxActivitySpecialTrip) (err error) {
- o := orm.NewOrm()
- _, err = o.Insert(item)
- return
- }
- //取消
- func CancelActivitySpecialTrip(uid int, item *CygxActivitySpecialDetail) (err error) {
- o := orm.NewOrm()
- sql := `DELETE FROM cygx_activity_special_trip WHERE user_id=? AND activity_id=? `
- _, err = o.Raw(sql, uid, item.ActivityId).Exec()
- return
- }
|