286,7 → 286,7 |
return listMailboxes(null, 0, 0, null, editor); |
} |
|
public Collection listMailboxes(CollectionInfo info, int pageSize, int pageNumber, |
public Collection listMailboxes(CollectionInfo info, int rowsPerPage, int pageNumber, |
Integer[] sortingKeys, User editor) |
throws ModelException |
{ |
293,11 → 293,12 |
try { |
if(editor.isSuperuser()) { |
if(info != null) { |
info.setSize(((Integer)HibernateUtil.currentSession().iterate( |
"select count(*) from Mailbox").next()).intValue()); |
info.init(((Integer)HibernateUtil.currentSession().iterate( |
"select count(*) from Mailbox").next()).intValue(), |
pageNumber, rowsPerPage); |
} |
|
return HibernateUtil.pageableListSql(pageSize, pageNumber, |
return HibernateUtil.pageableListSql(rowsPerPage, pageNumber, |
"select {mb.*}, {d.*}, {o.*}, {su.*}" |
+ " from mailboxes as mb" |
+ " left join domains as d on mb.domain = d.id" |
322,10 → 323,11 |
+ ") as count_table", |
new Object[] { editor.getId(), editor.getId() }); |
|
info.setSize(((Long)countlist.get(0)).intValue()); |
info.init(((Long)countlist.get(0)).intValue(), |
pageNumber, rowsPerPage); |
} |
|
return HibernateUtil.pageableListSql(pageSize, pageNumber, |
return HibernateUtil.pageableListSql(rowsPerPage, pageNumber, |
"select {mb.*}, {d.*}, {o.*}, {su.*}" |
+ " from mailboxes as mb" |
+ " left join domains as d on mb.domain = d.id" |