chart_collect.go 2.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182
  1. package models
  2. import (
  3. "github.com/beego/beego/v2/client/orm"
  4. "time"
  5. )
  6. type CygxChartCollect struct {
  7. Id int `orm:"column(id);pk"`
  8. ChartId int `description:"图表ID"`
  9. UserId int `description:"用户ID"`
  10. CreateTime time.Time `description:"创建时间"`
  11. Mobile string `description:"手机号"`
  12. Email string `description:"邮箱"`
  13. CompanyId int `description:"公司id"`
  14. CompanyName string `description:"公司名称"`
  15. RealName string `description:"用户实际名称"`
  16. SellerName string `description:"所属销售"`
  17. }
  18. //添加收藏信息
  19. func AddCygxChartCollect(item *CygxChartCollect) (lastId int64, err error) {
  20. o := orm.NewOrm()
  21. lastId, err = o.Insert(item)
  22. return
  23. }
  24. type ChartCollectResp struct {
  25. Status int `description:"1:收藏,2:取消收藏"`
  26. CollectCount int `description:"收藏总数"`
  27. }
  28. func RemoveChartCollect(userId, ChartId int) (err error) {
  29. o := orm.NewOrm()
  30. sql := `DELETE FROM cygx_chart_collect WHERE user_id=? AND chart_id=? `
  31. _, err = o.Raw(sql, userId, ChartId).Exec()
  32. return
  33. }
  34. func GetChartCountByUserId(userId, chartID int) (count int, err error) {
  35. sql := `SELECT COUNT(1) AS count FROM cygx_chart_collect WHERE user_id=? AND chart_id=? `
  36. err = orm.NewOrm().Raw(sql, userId, chartID).QueryRow(&count)
  37. return
  38. }
  39. type CygxChartTop struct {
  40. Id int `orm:"column(id);pk"`
  41. ChartId int `description:"图表ID"`
  42. UserId int `description:"用户ID"`
  43. CreateTime time.Time `description:"创建时间"`
  44. Mobile string `description:"手机号"`
  45. Email string `description:"邮箱"`
  46. CompanyId int `description:"公司id"`
  47. CompanyName string `description:"公司名称"`
  48. RealName string `description:"用户实际名称"`
  49. SellerName string `description:"所属销售"`
  50. }
  51. //添加置顶信息
  52. func AddCygxChartTop(item *CygxChartTop) (lastId int64, err error) {
  53. o := orm.NewOrm()
  54. lastId, err = o.Insert(item)
  55. return
  56. }
  57. type ChartTopresp struct {
  58. Status int `description:"1:收藏,2:取消收藏"`
  59. CollectCount int `description:"收藏总数"`
  60. }
  61. func RemoveChartTop(userId, ChartId int) (err error) {
  62. o := orm.NewOrm()
  63. sql := `DELETE FROM cygx_chart_top WHERE user_id=? AND chart_id=? `
  64. _, err = o.Raw(sql, userId, ChartId).Exec()
  65. return
  66. }
  67. func GetChartTopCountByUserId(userId, chartID int) (count int, err error) {
  68. sql := `SELECT COUNT(1) AS count FROM cygx_chart_top WHERE user_id=? AND chart_id=? `
  69. err = orm.NewOrm().Raw(sql, userId, chartID).QueryRow(&count)
  70. return
  71. }