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  

Impressum / About Us