123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051 |
- package cygx
- import (
- "github.com/beego/beego/v2/client/orm"
- "github.com/rdlucklib/rdluck_tools/paging"
- )
- type CygxAdvice struct {
- AdviceId int `description:"优化建议id"`
- UserId int `description:"用户id"`
- UserRealName string `description:"姓名"`
- CompanyId int `description:"公司id"`
- CompanyName string `description:"公司名称"`
- SalesRealName string `description:"所属销售"`
- Advice string `description:"优化建议"`
- AdviceImgUrl string `description:"图片,多张用#分割"`
- CreateTime string `description:"访谈时间"`
- Mobile string `description:"手机号"`
- Email string `description:"邮箱"`
- }
- type AdviceListResp struct {
- Paging *paging.PagingItem
- List []*CygxAdvice
- }
- func GetAdviceListCount(condition string, pars []interface{}) (count int, err error) {
- o := orm.NewOrm()
- sql := `SELECT COUNT(1) AS count FROM cygx_advice AS a
- LEFT JOIN wx_user AS b ON a.user_id=b.user_id
- LEFT JOIN company AS c ON a.company_id=c.company_id`
- if condition != "" {
- sql += condition
- }
- err = o.Raw(sql, pars).QueryRow(&count)
- return
- }
- func GetAdviceList(condition string, pars []interface{}, startSize, pageSize int) (items []*CygxAdvice, err error) {
- o := orm.NewOrm()
- sql := ` SELECT a.*,b.real_name AS user_real_name,c.company_name,b.mobile,b.email FROM cygx_advice AS a
- LEFT JOIN wx_user AS b ON a.user_id=b.user_id
- LEFT JOIN company AS c ON a.company_id=c.company_id
- `
- if condition != "" {
- sql += condition
- }
- sql += ` ORDER BY a.create_time DESC LIMIT ?,? `
- _, err = o.Raw(sql, pars, startSize, pageSize).QueryRows(&items)
- return
- }
|