# HG changeset patch
# User jbe
# Date 1381491736 -7200
# Node ID 1e4fcb7f0eac3bcc16ecc1b902768e68d9cd0625
# Parent  ad50723ef4ed3b051c7ef3ac8e77396d6fd8005c
Added helper view "open_issues_ordered_with_minimum_position" for lf_update_issue_order.c

diff -r ad50723ef4ed -r 1e4fcb7f0eac core.sql
--- a/core.sql	Fri Oct 11 13:17:29 2013 +0200
+++ b/core.sql	Fri Oct 11 13:42:16 2013 +0200
@@ -2082,6 +2082,24 @@
 COMMENT ON VIEW "issue_supporter_in_admission_state" IS 'Helper view for "lf_update_issue_order" to allow a (proportional) ordering of issues within an area';
 
 
+CREATE VIEW "open_issues_ordered_with_minimum_position" AS
+  SELECT
+    "area_id",
+    "id" AS "issue_id",
+    "order_in_admission_state" * 2 - 1 AS "minimum_position"
+  FROM "issue"
+  WHERE "closed" ISNULL
+  ORDER BY
+    coalesce(
+      "fully_frozen" + "voting_time",
+      "half_frozen" + "verification_time",
+      "accepted" + "discussion_time",
+      "created" + "admission_time"
+    ) - now();
+
+COMMENT ON VIEW "open_issues_ordered_with_minimum_position" IS 'Helper view for "lf_update_issue_order" to allow a (mixed) ordering of issues within an area';
+
+
 CREATE VIEW "initiative_suggestion_order_calculation" AS
   SELECT
     "initiative"."id" AS "initiative_id",
diff -r ad50723ef4ed -r 1e4fcb7f0eac update/core-update.v2.2.5-v2.2.6.sql
--- a/update/core-update.v2.2.5-v2.2.6.sql	Fri Oct 11 13:17:29 2013 +0200
+++ b/update/core-update.v2.2.5-v2.2.6.sql	Fri Oct 11 13:42:16 2013 +0200
@@ -26,4 +26,21 @@
 
 COMMENT ON VIEW "issue_supporter_in_admission_state" IS 'Helper view for "lf_update_issue_order" to allow a (proportional) ordering of issues within an area';
 
+CREATE VIEW "open_issues_ordered_with_minimum_position" AS
+  SELECT
+    "area_id",
+    "id" AS "issue_id",
+    "order_in_admission_state" * 2 - 1 AS "minimum_position"
+  FROM "issue"
+  WHERE "closed" ISNULL
+  ORDER BY
+    coalesce(
+      "fully_frozen" + "voting_time",
+      "half_frozen" + "verification_time",
+      "accepted" + "discussion_time",
+      "created" + "admission_time"
+    ) - now();
+
+COMMENT ON VIEW "open_issues_ordered_with_minimum_position" IS 'Helper view for "lf_update_issue_order" to allow a (mixed) ordering of issues within an area';
+
 COMMIT;