public JwList<AcGlobalAuditLog> getAllById(Collection<Integer> ids) {
JwList<AcGlobalAuditLog> v = new JwList<AcGlobalAuditLog>();
for (Integer id : ids) {
JwSqlSelect st = getSelect();
st.where().isEqual(ALIAS, ID, id);
v.addAll(composeList(st));
}
return v;
}
public JwList<AcUploadDownloadFile> getAllById(Collection<Integer> ids) {
JwList<AcUploadDownloadFile> v = new JwList<AcUploadDownloadFile>();
for (Integer id : ids) {
JwSqlSelect st = getSelect();
st.where().isEqual(ALIAS, ID, id);
v.addAll(composeList(st));
}
return v;
}
public JwList<AcDomesticCandidateRouteTmp> getAllWhere(String whereClause, Integer rowLimit) {
JwSqlSelect st = getSelect();
if (JwUtility.hasValue(whereClause)) st.where().setCondition(whereClause);
return composeList(st, rowLimit);
}
public AcDomesticCandidateRouteTmp getDomesticCandidateRouteTmp(String login) {
if (isPrimaryKeyNull(login)) return null;
JwSqlSelect st = getSelect();
st.where().isEqual(ALIAS, LOGIN, login);
return composeFirst(st);
}
public JwList<AcMobileProfile> getAllWhere(String whereClause, Integer rowLimit) {
JwSqlSelect st = getSelect();
if (JwUtility.hasValue(whereClause)) st.where().setCondition(whereClause);
return composeList(st, rowLimit);
}
public AcMobileProfile getMobileProfile(String name) {
if (isPrimaryKeyNull(name)) return null;
JwSqlSelect st = getSelect();
st.where().isEqual(ALIAS, NAME, name);
return composeFirst(st);
}
public void verifyNoName(AcMobileProfile e) {
JwSqlSelect st = getSelect();
st.where().isEqual(ALIAS, NAME, e.getName());
AcMobileProfile o = composeFirst(st);
if (o != null) JwErrorUtility.throwNewUniqueError("AcMobileProfile", "Name", e.getName());
}
public AcUploadDownloadFile getUploadDownloadFile(Integer id) {
if (isPrimaryKeyNull(id)) return null;
JwSqlSelect st = getSelect();
st.where().isEqual(ALIAS, ID, id);
return composeFirst(st);
}
public AcScheduledFlightUpload getScheduledFlightUpload(Integer id) {
if (isPrimaryKeyNull(id)) return null;
JwSqlSelect st = getSelect();
st.where().isEqual(ALIAS, ID, id);
return composeFirst(st);
}
public JwList<AcScheduledFlightUpload> getAllByDestinationAirportCode(
String destinationAirportCode) {
JwSqlSelect st = getSelect();
st.where().isEqual(ALIAS, DESTINATION_AIRPORT_CODE, destinationAirportCode);
return composeList(st);
}
public JwList<AcScheduledFlightUpload> getAllByOriginAirportCode(String originAirportCode) {
JwSqlSelect st = getSelect();
st.where().isEqual(ALIAS, ORIGIN_AIRPORT_CODE, originAirportCode);
return composeList(st);
}
public AcGlobalAuditLog getGlobalAuditLog(Integer id) {
if (isPrimaryKeyNull(id)) return null;
JwSqlSelect st = getSelect();
st.where().isEqual(ALIAS, ID, id);
return composeFirst(st);
}
public JwList<AcGlobalAuditLog> getAllByType(Integer type) {
JwSqlSelect st = getSelect();
st.where().isEqual(ALIAS, TYPE, type);
return composeList(st);
}
public JwList<AcGlobalAuditLog> getAllByUser(String user) {
JwSqlSelect st = getSelect();
st.where().isEqual(ALIAS, USER, user);
return composeList(st);
}