Method CategoryOfUserCollection

models/category.go:119–135

用户收藏了的书籍的分类

(uid int, forAPI ...bool)

// 用户收藏了的书籍的分类
func (m *Category) CategoryOfUserCollection(uid int, forAPI ...bool) (cates []Category) {
	order := " ORDER BY c.sort asc,c.title asc "
	if len(forAPI) > 0 && forAPI[0] {
		order = " ORDER BY c.title asc "
	}
	sql := `
		SELECT c.id,c.pid,c.title
		FROM md_book_category bc
			LEFT JOIN md_star s ON s.bid = bc.book_id
			LEFT JOIN md_category c ON c.id = bc.category_id
		WHERE s.uid = ? 
		GROUP BY c.id ` + order
	if _, err := orm.NewOrm().Raw(sql, uid).QueryRows(&cates); err != nil {
		beego.Error(err.Error())
	}
	return
}