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";

Impressum / About Us