liquid_feedback_core
changeset 174:368fe2299d07
Ordering for final rank: 1st winner, 2nd initiatives fultilling direct AND indirect majority, rest ordered by schulze_rank and id
author | jbe |
---|---|
date | Tue Jun 07 20:56:42 2011 +0200 (2011-06-07) |
parents | d8e11e6cfa1d |
children | 62ac82e55a57 |
files | core.sql |
line diff
1.1 --- a/core.sql Tue Jun 07 20:42:50 2011 +0200 1.2 +++ b/core.sql Tue Jun 07 20:56:42 2011 +0200 1.3 @@ -3805,7 +3805,11 @@ 1.4 SELECT "id" 1.5 FROM "initiative" 1.6 WHERE "issue_id" = "issue_id_p" AND "admitted" 1.7 - ORDER BY "winner" DESC, "schulze_rank", "id" 1.8 + ORDER BY 1.9 + "winner" DESC, 1.10 + ("direct_majority" AND "indirect_majority") DESC, 1.11 + "schulze_rank", 1.12 + "id" 1.13 LOOP 1.14 UPDATE "initiative" SET "rank" = "rank_v" 1.15 WHERE "id" = "initiative_id_v";