1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556 |
- package models
- import (
- "github.com/beego/beego/v2/client/orm"
- "time"
- )
- type CygxProductInteriorHistory struct {
- Id int `orm:"column(id);pk"`
- ProductInteriorId int
- UserId int
- CreateTime time.Time
- Mobile string `description:"手机号"`
- Email string `description:"邮箱"`
- CompanyId int `description:"公司id"`
- CompanyName string `description:"公司名称"`
- ModifyTime time.Time `description:"修改时间"`
- RealName string `description:"用户实际名称"`
- SellerName string `description:"所属销售"`
- }
- // 添加历史信息
- func AddCygxProductInteriorHistory(item *CygxProductInteriorHistory) (lastId int64, err error) {
- o := orm.NewOrm()
- item.ModifyTime = time.Now()
- lastId, err = o.Insert(item)
- return
- }
- // 列表
- func GetCygxProductInteriorHistoryList(condition string, pars []interface{}) (items []*CygxProductInteriorHistory, err error) {
- o := orm.NewOrm()
- sql := `SELECT * FROM cygx_product_interior_history as art WHERE 1= 1 `
- if condition != "" {
- sql += condition
- }
- _, err = o.Raw(sql, pars).QueryRows(&items)
- return
- }
- type ListProductInteriorPvResp struct {
- ProductInteriorId int `description:"文章ID"`
- Pv int `description:"pv"`
- }
- // 列表
- func GetCygxProductInteriorHistoryListPv(condition string, pars []interface{}) (items []*ListProductInteriorPvResp, err error) {
- o := orm.NewOrm()
- sql := `SELECT product_interior_id ,COUNT(*) as pv FROM cygx_product_interior_history WHERE 1= 1 `
- if condition != "" {
- sql += condition
- }
- sql += " GROUP BY product_interior_id "
- _, err = o.Raw(sql, pars).QueryRows(&items)
- return
- }
|