Kawai Wiki

Compare Revisions

Ignore whitespace Rev 200 → Rev 199

/trunk/src/main/java/org/kawai/dao/jdbc/JdbcPageDAO.java
197,16 → 197,7
query.append(" from Pages p");
query.append(" join Users creator on p.created_by = creator.id");
query.append(" left join Users modifier on p.modified_by = modifier.id");
query.append(" where p.deleted = 'F' and p.language_id in (");
List<Language> langs = Language.all();
int count = 0;
for(Language lang : langs) {
if (count++ > 0) query.append(",");
query.append(lang.getId());
}
query.append(")");
query.append(" where p.deleted = 'F'");
if (!includeSystemPages) {
query.append(" and p.system_page = 'F'");
}