Function CountCategory

models/base.go:199–230

CountCategory 统计书籍分类

()

// CountCategory 统计书籍分类
func CountCategory() {
	var (
		count     []Count
		tableCate = "md_category"
		err       error
	)

	o := orm.NewOrm()
	o.Begin()
	defer func() {
		if err != nil {
			beego.Error(err)
			o.Rollback()
		} else {
			o.Commit()
		}
	}()

	sql := "select count(bc.id) cnt, bc.category_id from md_book_category bc left join md_books b on b.book_id=bc.book_id where b.privately_owned=0 and bc.category_id>0  group by bc.category_id"
	o.Raw(sql).QueryRows(&count)

	// 重置为0
	if _, err = o.QueryTable(tableCate).Filter("id__gt", 0).Update(orm.Params{"cnt": 0}); err != nil {
		beego.Error(err)
	}

	for _, item := range count {
		if _, err = o.QueryTable(tableCate).Filter("id", item.CategoryId).Update(orm.Params{"cnt": item.Cnt}); err != nil {
			return
		}
	}
}

func getTimeRange(t time.Time, prd period) (start, end string) {
	switch prd {