Rev 191 | Rev 228 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed
Rev 191 | Rev 200 | ||
---|---|---|---|
Line 195... | Line 195... | ||
195 | query.append(", ").append(session.buildSelect(User.class, "creator")); |
195 | query.append(", ").append(session.buildSelect(User.class, "creator")); |
196 | query.append(", ").append(session.buildSelect(User.class, "modifier")); |
196 | query.append(", ").append(session.buildSelect(User.class, "modifier")); |
197 | query.append(" from Pages p"); |
197 | query.append(" from Pages p"); |
198 | query.append(" join Users creator on p.created_by = creator.id"); |
198 | query.append(" join Users creator on p.created_by = creator.id"); |
199 | query.append(" left join Users modifier on p.modified_by = modifier.id"); |
199 | query.append(" left join Users modifier on p.modified_by = modifier.id"); |
200 | query.append(" where p.deleted = 'F'"); |
- | |
- | 200 | query.append(" where p.deleted = 'F' and p.language_id in ("); |
|
- | 201 | ||
- | 202 | List<Language> langs = Language.all(); |
|
- | 203 | int count = 0; |
|
- | 204 | for(Language lang : langs) { |
|
- | 205 | if (count++ > 0) query.append(","); |
|
- | 206 | query.append(lang.getId()); |
|
- | 207 | }
|
|
- | 208 | query.append(")"); |
|
- | 209 | ||
201 | if (!includeSystemPages) { |
210 | if (!includeSystemPages) { |
202 | query.append(" and p.system_page = 'F'"); |
211 | query.append(" and p.system_page = 'F'"); |
203 | }
|
212 | }
|
204 | query.append(" order by p.system_page, p.front_page, p.name, p.language_id"); |
213 | query.append(" order by p.system_page, p.front_page, p.name, p.language_id"); |
205 | 214 |