Method FindToPager

models/book_result.go:126–167

(pageIndex, pageSize int, private int, wd ...string)

}

func (m *BookResult) FindToPager(pageIndex, pageSize int, private int, wd ...string) (books []*BookResult, totalCount int, err error) {
	var args []interface{}
	word := ""
	if len(wd) > 0 {
		if w := strings.TrimSpace(wd[0]); w != "" {
			word = w
		}
	}
	o := orm.NewOrm()
	q := o.QueryTable(NewBook().TableNameWithPrefix())
	if word != "" {
		cond := orm.NewCondition().Or("book_name__icontains", word).Or("description__icontains", word)
		q = q.SetCond(orm.NewCondition().AndCond(cond))
	}
	q = q.Filter("privately_owned", private)

	count, err := q.Count()
	if err != nil {
		return
	}

	totalCount = int(count)

	sql := `SELECT
			book.*,rel.relationship_id,rel.role_id,m.account AS create_name
		FROM md_books AS book
			LEFT JOIN md_relationship AS rel ON rel.book_id = book.book_id AND rel.role_id = 0
			LEFT JOIN md_members AS m ON rel.member_id = m.member_id %v
		ORDER BY book.order_index DESC ,book.book_id DESC  LIMIT ?,?`
	condition := ""
	condition = "where book.privately_owned=" + strconv.Itoa(private)
	if word != "" {
		condition = condition + " and (book.book_name like ? or book.description like ?)"
		args = append(args, "%"+word+"%", "%"+word+"%")
	}

	sql = fmt.Sprintf(sql, condition)
	offset := (pageIndex - 1) * pageSize
	args = append(args, offset, pageSize)
	_, err = o.Raw(sql, args...).QueryRows(&books)
	return
}