liquid_feedback_frontend
changeset 1302:9ff5b868760d
Make use of member_to_notify view
author | bsw |
---|---|
date | Thu May 05 23:16:23 2016 +0200 (2016-05-05) |
parents | 73e8b4e48078 |
children | 0160d9a01d0a |
files | model/event.lua |
line diff
1.1 --- a/model/event.lua Wed May 04 21:38:50 2016 +0200 1.2 +++ b/model/event.lua Thu May 05 23:16:23 2016 +0200 1.3 @@ -51,14 +51,13 @@ 1.4 function Event.object:send_notification() 1.5 1.6 local members_to_notify = Member:new_selector() 1.7 + :join("member_to_notify", nil, "member_to_notify.id = member.id") 1.8 :join("event_for_notification", nil, { "event_for_notification.recipient_id = member.id AND event_for_notification.id = ?", self.id } ) 1.9 -- SAFETY FIRST, NEVER send notifications for events more then 3 days in past or future 1.10 :add_where("now() - event_for_notification.occurrence BETWEEN '-3 days'::interval AND '3 days'::interval") 1.11 -- do not notify a member about the events caused by the member 1.12 :add_where("event_for_notification.member_id ISNULL OR event_for_notification.member_id != member.id") 1.13 :add_where("member.notify_email NOTNULL") 1.14 - :add_where("NOT member.locked") 1.15 - :add_where("NOT member.disable_notifications") 1.16 :exec() 1.17 1.18 io.stderr:write("Sending notifications for event " .. self.id .. " to " .. (#members_to_notify) .. " members\n")