# HG changeset patch
# User bsw
# Date 1319111647 -7200
# Node ID cfdb8f15c388825128b86a2204579ecb7443d38f
# Parent  9fe872cc376d9f22dc09c06dc055dfb80f1caa52
Added issue order by state_time_left

diff -r 9fe872cc376d -r cfdb8f15c388 lfapi/general_params.js
--- a/lfapi/general_params.js	Mon Sep 12 21:09:48 2011 +0200
+++ b/lfapi/general_params.js	Thu Oct 20 13:54:07 2011 +0200
@@ -138,6 +138,10 @@
     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]);
   };
   
+  if (params.issue_order_by_state_time_left) {
+    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)');
+  };
+  
   if (params.issue_order_by_id) query.addOrderBy('"issue"."id"');
 }