查询书籍的用户
(bookId, pageIndex, pageSize int)
| 61 | |
| 62 | // 查询书籍的用户 |
| 63 | func (m *MemberRelationshipResult) FindForUsersByBookId(bookId, pageIndex, pageSize int) ([]*MemberRelationshipResult, int, error) { |
| 64 | o := orm.NewOrm() |
| 65 | |
| 66 | var members []*MemberRelationshipResult |
| 67 | |
| 68 | sql1 := "SELECT * FROM md_relationship AS rel LEFT JOIN md_members as member ON rel.member_id = member.member_id WHERE rel.book_id = ? ORDER BY rel.relationship_id DESC LIMIT ?,?" |
| 69 | |
| 70 | sql2 := "SELECT count(*) AS total_count FROM md_relationship AS rel LEFT JOIN md_members as member ON rel.member_id = member.member_id WHERE rel.book_id = ?" |
| 71 | |
| 72 | var totalCount int |
| 73 | |
| 74 | err := o.Raw(sql2, bookId).QueryRow(&totalCount) |
| 75 | |
| 76 | if err != nil { |
| 77 | return members, 0, err |
| 78 | } |
| 79 | |
| 80 | offset := (pageIndex - 1) * pageSize |
| 81 | |
| 82 | _, err = o.Raw(sql1, bookId, offset, pageSize).QueryRows(&members) |
| 83 | |
| 84 | if err != nil { |
| 85 | return members, 0, err |
| 86 | } |
| 87 | |
| 88 | for _, item := range members { |
| 89 | item.ResolveRoleName() |
| 90 | } |
| 91 | return members, totalCount, nil |
| 92 | } |