liquid_feedback_frontend

diff model/newsletter_to_send.lua @ 1252:659e3eda2fad
Minor fixes to new notification system
author: bsw
date: Sun Apr 17 16:02:26 2016 +0200 (2016-04-17)
parents: c0fd12b97d65
children: 4b1f59181341
     1.1 --- a/model/newsletter_to_send.lua	Sun Apr 17 15:04:07 2016 +0200
     1.2 +++ b/model/newsletter_to_send.lua	Sun Apr 17 16:02:26 2016 +0200
     1.3 @@ -20,6 +20,9 @@
     1.4  function NewsletterToSend:get_next()
     1.5    return NewsletterToSend:new_selector()
     1.6      :set_distinct("newsletter_id")
     1.7 +    -- SAFETY FIRST, NEVER send newsletter more then 21 days in past or future
     1.8 +    :add_where("now() - published BETWEEN '-21 days'::interval AND '21 days'::interval")
     1.9 +    :add_order_by("published")
    1.10      :add_order_by("newsletter_id")
    1.11      :limit(1)
    1.12      :optional_object_mode()