@Override
public SynchronizedPagingLoadResult<AgreementRemoteSetupUrlTuple> searchAgreementRemoteSetupUrls(
LoadConfig loadConfig, long syncId) throws IllegalArgumentException {
authenticate("search agreement remoteSetupUrls", SecurityManager.ROLE_QUERY);
List<AgreementRemoteSetupUrlTuple> list = new ArrayList<AgreementRemoteSetupUrlTuple>();
String filter = loadConfig.get("filter") != null ? loadConfig.get("filter").toString() : null;
if (filter == null || filter.trim().length() == 0)
return new SynchronizedPagingLoadResult<AgreementRemoteSetupUrlTuple>(list, 0, 0, syncId);
SearchUtilities.SearchSettings searchSettings = new SearchUtilities.SearchSettings(filter);
HibernateUtil.openSession();
HibernateUtil.startTransaction();
try {
// String sortField = null;
// SortDir sortDir = null;
// if (loadConfig instanceof PagingLoadConfig) {
// sortField = ((PagingLoadConfig) loadConfig).getSortField();
// sortDir = ((PagingLoadConfig) loadConfig).getSortDir();
// }
List<Object[]> tuples =
DbRemoteSetupUrl.findFiltered(
searchSettings.getFilter(),
searchSettings.isDoBoolean(),
AppConstants.STATUS_DELETED);
// List<Object []> tuples = DbRemoteSetupUrl.findFiltered(searchSettings.getFilter(),
// searchSettings.isDoBoolean(), (char) 0, AppConstants.STATUS_DELETED, sortField, sortDir);
int loadLimit = AppConstants.STANDARD_LOAD_LIMIT;
if (loadConfig.get("limit") != null && loadConfig.get("limit") instanceof Integer)
loadLimit = ((Integer) loadConfig.get("limit"));
if (tuples.size() > loadLimit) {
// This is an error return with no data, but a count (too many results)
return new SynchronizedPagingLoadResult<AgreementRemoteSetupUrlTuple>(
list, 0, tuples.size(), syncId);
}
for (Object[] objects : tuples) {
AgreementInstance agreement = DbAgreement.getInstance((Agreement) objects[0]);
RemoteSetupUrlInstance remoteSetupUrl =
DbRemoteSetupUrl.getInstance((RemoteSetupUrl) objects[1]);
setDescriptions(remoteSetupUrl);
setDescriptions(agreement);
setInstitution(agreement);
AgreementRemoteSetupUrlTuple tuple =
new AgreementRemoteSetupUrlTuple(agreement, remoteSetupUrl);
list.add(tuple);
}
} catch (Exception exc) {
exc.printStackTrace();
}
HibernateUtil.endTransaction();
HibernateUtil.closeSession();
return new SynchronizedPagingLoadResult<AgreementRemoteSetupUrlTuple>(
list, 0, list.size(), syncId);
}
private void setDescriptions(RemoteSetupUrlInstance remoteSetupUrl) {
DbRemoteSetupUrl.setDescriptions(remoteSetupUrl);
}