liquid_feedback_frontend

changeset 726:d3d7a01624f6
Forbid sending of notifications for events more than 3 days in future or past instead of 7 days
author: bsw
date: Thu Jun 28 16:08:45 2012 +0200 (2012-06-28)
parents: 344e5fdce8c9
children: 161cebfc44d4
files: model/event.lua
     1.1 --- a/model/event.lua	Thu Jun 28 13:52:42 2012 +0200
     1.2 +++ b/model/event.lua	Thu Jun 28 16:08:45 2012 +0200
     1.3 @@ -66,8 +66,8 @@
     1.4    local members_to_notify = Member:new_selector()
     1.5      :join("event_seen_by_member", nil, { "event_seen_by_member.seen_by_member_id = member.id AND event_seen_by_member.notify_level <= member.notify_level AND event_seen_by_member.id = ?", self.id } )
     1.6      :add_where("member.activated NOTNULL AND member.notify_email NOTNULL")
     1.7 -    -- SAFETY FIRST, NEVER send notifications for events more then 7 days in past or future
     1.8 -    :add_where("now() - event_seen_by_member.occurrence BETWEEN '-7 days'::interval AND '7 days'::interval")
     1.9 +    -- SAFETY FIRST, NEVER send notifications for events more then 3 days in past or future
    1.10 +    :add_where("now() - event_seen_by_member.occurrence BETWEEN '-3 days'::interval AND '3 days'::interval")
    1.11      :exec()
    1.12      
    1.13    print (_("Event #{id} -> #{num} members", { id = self.id, num = #members_to_notify }))