public JwList<AcGpsReport> getAllCompleteAndCreatedOnOrBefore(JwTimestamp utcTs) {
String[] codes = {
AcGpsReportStatusEnum.COMPLETE.getCode(), AcGpsReportStatusEnum.ERROR.getCode()
};
JwSqlSelect st = getSelect();
st.where().isIn(ALIAS, STATUS, codes);
st.where().isLessThanOrEqualTo(ALIAS, CREATED_UTC_TS, utcTs);
return composeList(st);
}
public AcGpsReport getNotCompleteByOutputChannelId(Integer outputChannelId) {
String[] codes = {
AcGpsReportStatusEnum.COMPLETE.getCode(), AcGpsReportStatusEnum.ERROR.getCode()
};
JwSqlSelect st = getSelect();
st.where().isNotIn(ALIAS, STATUS, codes);
st.where().isEqual(ALIAS, OUTPUT_CHANNEL_ID, outputChannelId);
st.orderBy(ALIAS, CREATED_UTC_TS);
st.orderBy(ALIAS, ID);
return composeFirst(st);
}
