public boolean isModuleAssigned(Integer moduleConfigId) {
JwSqlSelect st = createSelect();
st.selectCount();
st.from(TABLE, ALIAS);
st.where().or();
st.where().isEqual(ALIAS, MY_GLOBAL_MODULE_CONFIG_ID, moduleConfigId);
st.where().isEqual(ALIAS, MY_STATION_MODULE_CONFIG_ID, moduleConfigId);
int count = composeCount(st);
return count > 0;
}
public JwList<AcDomesticNominatedRouteSummaryVo> groupSummaryByCreatedUtcTsOnOrAfter(
JwTimestamp startUtcTs) {
JwList<AcDomesticNominatedRouteSummaryVo> v = new JwList<AcDomesticNominatedRouteSummaryVo>();
JwSqlSelect st = createSelect();
st.selectDate(ALIAS, NORMALIZED_BEGIN_UTC_DT);
st.selectDate(ALIAS, NORMALIZED_END_UTC_DT);
st.selectMinimumTimestamp(ALIAS, CREATED_UTC_TS);
st.selectCount();
st.from(TABLE, ALIAS);
st.where().isGreaterThanOrEqualTo(ALIAS, CREATED_UTC_TS, startUtcTs);
st.where().isEqual(ALIAS, STATUS, AcDomesticNominatedRouteStatusEnum.NEW.getCode());
st.groupBy(ALIAS, NORMALIZED_BEGIN_UTC_DT);
st.groupBy(ALIAS, NORMALIZED_END_UTC_DT);
AcDbUtility.processResults(
getAccess(), st, getReadNominatedRouteSummaryVoListResultSetProcessor(v));
return v;
}
public JwSqlSelect getSelectCount() {
JwSqlSelect st = createSelect();
st.selectCount();
st.from(TABLE, ALIAS);
return st;
}
