Method HistoryReadBook

models/read_record.go:197–223

(uid, page, size int)

}

func (this *ReadRecord) HistoryReadBook(uid, page, size int) (books []Book) {
	// 由于md_books 没有 created_at 这个字段，所以这里将这个字段映射到version里面...
	fields := "b.book_id,b.book_name,b.cover,b.vcnt,b.doc_count,b.description,b.identify,max(rr.create_at) as version"
	sql := `
select 
	%v 
from 
	md_read_record rr 
left join 
	md_books b 
on 
	rr.book_id = b.book_id 
where 
	b.privately_owned=0 and rr.uid = ? 
group by b.book_id 
order by version desc 
limit ? offset ?
`
	sql = fmt.Sprintf(sql, fields)
	orm.NewOrm().Raw(sql, uid, size, (page-1)*size).QueryRows(&books)
	for idx, book := range books {
		book.ModifyTime = time.Unix(book.Version, 0)
		book.Version = 0
		books[idx] = book
	}
	return
}

//清空阅读记录
//当删除书籍时，直接删除该书籍的所有记录