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

Impressum / About Us