advice.go 1.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
  1. package cygx
  2. import (
  3. "github.com/beego/beego/v2/client/orm"
  4. "github.com/rdlucklib/rdluck_tools/paging"
  5. )
  6. type CygxAdvice struct {
  7. AdviceId int `description:"优化建议id"`
  8. UserId int `description:"用户id"`
  9. UserRealName string `description:"姓名"`
  10. CompanyId int `description:"公司id"`
  11. CompanyName string `description:"公司名称"`
  12. SalesRealName string `description:"所属销售"`
  13. Advice string `description:"优化建议"`
  14. AdviceImgUrl string `description:"图片,多张用#分割"`
  15. CreateTime string `description:"访谈时间"`
  16. Mobile string `description:"手机号"`
  17. Email string `description:"邮箱"`
  18. }
  19. type AdviceListResp struct {
  20. Paging *paging.PagingItem
  21. List []*CygxAdvice
  22. }
  23. func GetAdviceListCount(condition string, pars []interface{}) (count int, err error) {
  24. o := orm.NewOrm()
  25. sql := `SELECT COUNT(1) AS count FROM cygx_advice AS a
  26. LEFT JOIN wx_user AS b ON a.user_id=b.user_id
  27. LEFT JOIN company AS c ON a.company_id=c.company_id`
  28. if condition != "" {
  29. sql += condition
  30. }
  31. err = o.Raw(sql, pars).QueryRow(&count)
  32. return
  33. }
  34. func GetAdviceList(condition string, pars []interface{}, startSize, pageSize int) (items []*CygxAdvice, err error) {
  35. o := orm.NewOrm()
  36. sql := ` SELECT a.*,b.real_name AS user_real_name,c.company_name,b.mobile,b.email FROM cygx_advice AS a
  37. LEFT JOIN wx_user AS b ON a.user_id=b.user_id
  38. LEFT JOIN company AS c ON a.company_id=c.company_id
  39. `
  40. if condition != "" {
  41. sql += condition
  42. }
  43. sql += ` ORDER BY a.create_time DESC LIMIT ?,? `
  44. _, err = o.Raw(sql, pars, startSize, pageSize).QueryRows(&items)
  45. return
  46. }