liquid_feedback_core
diff core.sql @ 501:4a8d9f00867b
Use "recipient_id" instead of "member_id" in function "get_initiatives_for_notification"
author | jbe |
---|---|
date | Mon Apr 04 18:51:13 2016 +0200 (2016-04-04) |
parents | bc4b590a8eec |
children | f39c673420cb |
line diff
1.1 --- a/core.sql Mon Apr 04 18:46:44 2016 +0200 1.2 +++ b/core.sql Mon Apr 04 18:51:13 2016 +0200 1.3 @@ -3120,7 +3120,7 @@ 1.4 ------------------------- 1.5 1.6 CREATE FUNCTION "get_initiatives_for_notification" 1.7 - ( "member_id_p" "member"."id"%TYPE ) 1.8 + ( "recipient_id_p" "member"."id"%TYPE ) 1.9 RETURNS SETOF "initiative_for_notification" 1.10 LANGUAGE 'plpgsql' VOLATILE AS $$ 1.11 DECLARE 1.12 @@ -3129,10 +3129,10 @@ 1.13 "last_suggestion_id_v" "suggestion"."id"%TYPE; 1.14 BEGIN 1.15 PERFORM "require_transaction_isolation"(); 1.16 - PERFORM NULL FROM "member" WHERE "id" = "member_id_p" FOR UPDATE; 1.17 + PERFORM NULL FROM "member" WHERE "id" = "recipient_id_p" FOR UPDATE; 1.18 FOR "result_row" IN 1.19 SELECT * FROM "initiative_for_notification" 1.20 - WHERE "member_id" = "member_id_p" 1.21 + WHERE "recipient_id" = "recipient_id_p" 1.22 LOOP 1.23 SELECT "id" INTO "last_draft_id_v" FROM "draft" 1.24 WHERE "draft"."initiative_id" = "result_row"."initiative_id" 1.25 @@ -3143,7 +3143,7 @@ 1.26 INSERT INTO "initiative_notification_sent" 1.27 ("member_id", "initiative_id", "last_draft_id", "last_suggestion_id") 1.28 VALUES ( 1.29 - "member_id_p", 1.30 + "recipient_id_p", 1.31 "result_row"."initiative_id", 1.32 "last_draft_id_v", 1.33 "last_suggestion_id_v" ) 1.34 @@ -3162,12 +3162,12 @@ 1.35 END LOOP; 1.36 DELETE FROM "initiative_notification_sent" 1.37 USING "initiative", "issue" 1.38 - WHERE "initiative_notification_sent"."member_id" = "member_id_p" 1.39 + WHERE "initiative_notification_sent"."member_id" = "recipient_id_p" 1.40 AND "initiative"."id" = "initiative_notification_sent"."initiative_id" 1.41 AND "issue"."id" = "initiative"."issue_id" 1.42 AND ( "issue"."closed" NOTNULL OR "issue"."fully_frozen" NOTNULL ); 1.43 UPDATE "member" SET "notification_counter" = "notification_counter" + 1 1.44 - WHERE "id" = "member_id_p"; 1.45 + WHERE "id" = "recipient_id_p"; 1.46 RETURN; 1.47 END; 1.48 $$;