zhouqi_article_map.go 1.7 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364
  1. package models
  2. import (
  3. "github.com/beego/beego/v2/client/orm"
  4. )
  5. type CygxZhouqiArticleMap struct {
  6. CategoryId int `description:"产业Id"`
  7. ParentId int `description:"父级ID"`
  8. MatchTypeName string `description:"行业名称"`
  9. ArticleUpdateTime string `description:"对应文章的更新时间"`
  10. }
  11. // 获取周期下面的一级分类
  12. func GetCygxZhouqiArticleMapFirst() (items []*CygxZhouqiArticleMap, err error) {
  13. o := orm.NewOrm()
  14. sql := `SELECT
  15. category_id,
  16. parent_id,
  17. match_type_name,
  18. article_update_time
  19. FROM
  20. cygx_zhouqi_article_map
  21. WHERE
  22. hidden = 0
  23. AND parent_id = 0
  24. ORDER BY
  25. sort DESC `
  26. _, err = o.Raw(sql).QueryRows(&items)
  27. return
  28. }
  29. // 根据父级分类ID获取下面的子分类
  30. func GetCygxZhouqiArticleMapByParentId(parentId int) (items []*CygxZhouqiArticleMap, err error) {
  31. o := orm.NewOrm()
  32. sql := `SELECT
  33. category_id,
  34. match_type_name,
  35. article_update_time
  36. FROM
  37. cygx_zhouqi_article_map
  38. WHERE
  39. parent_id = ? `
  40. _, err = o.Raw(sql, parentId).QueryRows(&items)
  41. return
  42. }
  43. // 根据名称获取详情
  44. func GetCygxZhouqiArticleMapByMatchTypeName(matchTypeName string) (item *CygxZhouqiArticleMap, err error) {
  45. o := orm.NewOrm()
  46. sql := ``
  47. sql = `SELECT a.* FROM cygx_zhouqi_article_map AS a WHERE a.match_type_name=? AND parent_id > 0 `
  48. err = o.Raw(sql, matchTypeName).QueryRow(&item)
  49. return
  50. }
  51. // 更新对应分类所关联的最新文章的时间
  52. func UpdateCygxZhouqiArticleMapTime(articleUpdateTime string, categoryId int) (err error) {
  53. o := orm.NewOrm()
  54. sql := ``
  55. sql = `UPDATE cygx_zhouqi_article_map SET hidden=0,article_update_time=? WHERE category_id = ? `
  56. _, err = o.Raw(sql, articleUpdateTime, categoryId).Exec()
  57. return
  58. }