| 297,7 → 297,7 |
|---|
| "select count(*) from Mailbox").next()).intValue()); |
| } |
| |
| return HibernateUtil.pageableList(pageSize, pageNumber, |
| return HibernateUtil.pageableListSql(pageSize, pageNumber, |
| "select {mb.*}, {d.*}, {o.*}, {su.*}" |
| + " from mailboxes as mb" |
| + " left join domains as d on mb.domain = d.id" |
| 304,7 → 304,6 |
|---|
| + " left join users as o on mb.owner = o.id" |
| + " left join systemusers as su on mb.systemUser = su.id" |
| + HibernateUtil.formOrderClause(sortingKeys, sortKeys), |
| Mailbox.class, |
| new String[] { "mb", "d", "o", "su" }, |
| new Class[] { Mailbox.class, InetDomain.class, User.class, SystemUser.class }, |
| null, |
| 326,7 → 325,7 |
|---|
| info.setSize(((Long)countlist.get(0)).intValue()); |
| } |
| |
| return HibernateUtil.pageableList(pageSize, pageNumber, |
| return HibernateUtil.pageableListSql(pageSize, pageNumber, |
| "select {mb.*}, {d.*}, {o.*}, {su.*}" |
| + " from mailboxes as mb" |
| + " left join domains as d on mb.domain = d.id" |
| 341,7 → 340,6 |
|---|
| + " left join systemusers as su on mb.systemUser = su.id" |
| + " where d.owner=?" |
| + HibernateUtil.formOrderClause(sortingKeys, sortKeys), |
| Mailbox.class, |
| new String[] { "mb", "d", "o", "su" }, |
| new Class[] { Mailbox.class, InetDomain.class, User.class, SystemUser.class }, |
| new Object[] { editor, editor }, |