public Row findActivityBySrNumber(String incidentNumber) {
XxntcCsCalendarActivitiesEOVOImpl searchVo = getXxntcCsCalendarActivitiesEOVOSearch();
searchVo.setApplyViewCriteriaName("GetSrNumberCriteria");
VariableValueManager vvm = searchVo.ensureVariableManager();
vvm.setVariableValue("pIncidentNumber", incidentNumber);
vvm.setVariableValue("pResourceId", getResourceId());
searchVo.executeQuery();
if (searchVo.getRowCount() == 0) return null;
return searchVo.first();
}
public void applyGarageFilter(String garage) {
XxntcInventoriesVOImpl invVo = getXxntcInventoriesVO1();
invVo.setApplyViewCriteriaName("GarageCriteria");
VariableValueManager vvm = invVo.ensureVariableManager();
vvm.setVariableValue("pGarage", garage);
invVo.executeQuery();
}
public void applyProviderFilter(Number resourceId) {
XxntcCsCalendarProvidersVOImpl providerVo = getXxntcCsCalendarProvidersVO1();
providerVo.setApplyViewCriteriaName("XxntcCsCalendarProvidersVOCriteria");
VariableValueManager vvm = providerVo.ensureVariableManager();
vvm.setVariableValue("pResourceId", resourceId);
providerVo.executeQuery();
}
public RowIterator getSuggestedTitles(String title) {
XxntcTitlesVOImpl titlesVo = getXxntcTitlesVO1();
ViewCriteria vc = titlesVo.getViewCriteriaManager().getViewCriteria("SuggestedTitles");
titlesVo.setApplyViewCriteriaName("SuggestedTitles");
VariableValueManager vvm = vc.ensureVariableManager();
vvm.setVariableValue("pTitle", title);
RowIterator ri =
titlesVo.findByViewCriteria(vc, 25, ViewObject.QUERY_MODE_SCAN_DATABASE_TABLES);
return ri;
}
private Row getFirstDateForPlate(String plate) {
Map<String, Object> resultMap = new HashMap<String, Object>();
XxntcCsCalendarActivitiesEOVOImpl searchVo = getXxntcCsCalendarActivitiesEOVOSearch();
searchVo.setApplyViewCriteriaName("GetDateCriteria");
VariableValueManager vvm = searchVo.ensureVariableManager();
vvm.setVariableValue("pTitle", plate);
vvm.setVariableValue("pResourceId", getResourceId());
searchVo.executeQuery();
if (searchVo.getRowCount() == 0) return null;
RowSetIterator iterator = searchVo.createRowSetIterator(null);
iterator.reset();
List<Row> rows = new ArrayList<Row>();
while (iterator.hasNext()) {
Row row = iterator.next();
rows.add(row);
}
iterator.closeRowSetIterator();
return getMaxStartTimeActRow(rows);
}