| 3,6 → 3,7 |
|---|
| import java.util.*; |
| import net.sf.hibernate.*; |
| import net.sf.hibernate.type.Type; |
| import ak.hostadmiral.util.CollectionInfo; |
| import ak.hostadmiral.util.HibernateUtil; |
| import ak.hostadmiral.util.ModelException; |
| import ak.hostadmiral.util.ModelSecurityException; |
| 304,15 → 305,39 |
|---|
| public Collection listSystemUsers(User editor) |
| throws ModelException |
| { |
| return listSystemUsers(null, 0, 0, null, editor); |
| } |
| |
| public Collection listSystemUsers(CollectionInfo info, int rowsPerPage, int pageNumber, |
| Integer[] sortingKeys, User editor) |
| throws ModelException |
| { |
| try { |
| if(editor.isSuperuser()) { |
| return HibernateUtil.currentSession().find( |
| "select u from SystemUser u left join fetch u.owner"); |
| if(info != null) { |
| info.init(((Integer)HibernateUtil.currentSession().iterate( |
| "select count(*) from SystemUser").next()).intValue(), |
| pageNumber, rowsPerPage); |
| } |
| |
| return HibernateUtil.pageableList(rowsPerPage, pageNumber, |
| "select u from SystemUser u left join fetch u.owner" |
| + HibernateUtil.formOrderClause(sortingKeys, sortKeys), null, null); |
| } |
| else { |
| return HibernateUtil.currentSession().find( |
| "select u from SystemUser u left join u.owner o where o is null or o=?", |
| editor, Hibernate.entity(User.class)); |
| if(info != null) { |
| info.init(((Integer)HibernateUtil.currentSession().iterate( |
| "select count(*) from SystemUser where owner is null or owner = ?", |
| editor, Hibernate.entity(User.class)) |
| .next()).intValue(), |
| pageNumber, rowsPerPage); |
| } |
| |
| return HibernateUtil.pageableList(rowsPerPage, pageNumber, |
| "select u from SystemUser u left join u.owner o" |
| + " where u.owner is null or u.owner = ?" |
| + HibernateUtil.formOrderClause(sortingKeys, sortKeys), |
| new Object[] { editor }, new Type[] { Hibernate.entity(User.class) } ); |
| } |
| } |
| catch(HibernateException ex) |
| 392,6 → 417,16 |
|---|
| } |
| } |
| |
| public static final Integer SORT_UID = new Integer(1); |
| public static final Integer SORT_NAME = new Integer(2); |
| |
| protected static Map sortKeys = new HashMap(); |
| |
| static { |
| sortKeys.put(SORT_UID, "u.uid"); |
| sortKeys.put(SORT_NAME, "u.name"); |
| } |
| |
| public static final Comparator UID_COMPARATOR = new UidComparator(); |
| public static final Comparator NAME_COMPARATOR = new NameComparator(); |
| |