lfapi
changeset 2:cfdb8f15c388
Added issue order by state_time_left
author | bsw |
---|---|
date | Thu Oct 20 13:54:07 2011 +0200 (2011-10-20) |
parents | 9fe872cc376d |
children | e69609a3c98a |
files | lfapi/general_params.js |
line diff
1.1 --- a/lfapi/general_params.js Mon Sep 12 21:09:48 2011 +0200 1.2 +++ b/lfapi/general_params.js Thu Oct 20 13:54:07 2011 +0200 1.3 @@ -138,6 +138,10 @@ 1.4 query.addWhere(['(case issue.state when \'admission\' then issue.created + issue.admission_time when \'discussion\' then issue.accepted + issue.discussion_time when \'verification\' then issue.half_frozen + issue.verification_time when \'voting\' then issue.fully_frozen + issue.voting_time end) - now() < ?', params.issue_state_time_left_below]); 1.5 }; 1.6 1.7 + if (params.issue_order_by_state_time_left) { 1.8 + query.addOrderBy('(case issue.state when \'admission\' then issue.created + issue.admission_time when \'discussion\' then issue.accepted + issue.discussion_time when \'verification\' then issue.half_frozen + issue.verification_time when \'voting\' then issue.fully_frozen + issue.voting_time end)'); 1.9 + }; 1.10 + 1.11 if (params.issue_order_by_id) query.addOrderBy('"issue"."id"'); 1.12 } 1.13