Method FindToPager

models/attachment.go:83–125

分页查询附件

(pageIndex, pageSize int)

//分页查询附件
func (m *Attachment) FindToPager(pageIndex, pageSize int) (attachList []*AttachmentResult, totalCount int64, err error) {
	o := orm.NewOrm()

	totalCount, err = o.QueryTable(m.TableNameWithPrefix()).Count()
	if err != nil {
		return
	}

	offset := (pageIndex - 1) * pageSize

	var list []*Attachment
	_, err = o.QueryTable(m.TableNameWithPrefix()).OrderBy("-attachment_id").Offset(offset).Limit(pageSize).All(&list)

	if err != nil {
		return
	}

	for _, item := range list {
		attach := &AttachmentResult{}
		attach.Attachment = *item
		attach.FileShortSize = utils.FormatBytes(int64(attach.FileSize))

		book := NewBook()
		if e := o.QueryTable(book.TableNameWithPrefix()).Filter("book_id", item.BookId).One(book, "book_name", "identify"); e == nil {
			attach.BookName = book.BookName
			attach.BookIdentify = book.Identify
		} else {
			attach.BookName = "[不存在]"
		}

		doc := NewDocument()
		if e := o.QueryTable(doc.TableNameWithPrefix()).Filter("document_id", item.DocumentId).One(doc, "document_name", "identify"); e == nil {
			attach.DocumentName = doc.DocumentName
			attach.DocIdentify = doc.Identify
		} else {
			attach.DocumentName = "[不存在]"
		}
		attach.LocalHttpPath = strings.Replace(item.FilePath, "\\", "/", -1)
		attachList = append(attachList, attach)
	}

	return
}