liquid_feedback_frontend

annotate model/newsletter_to_send.lua @ 1248:c0fd12b97d65

Changes on notifications system, newsletter support added
author bsw
date Tue Apr 05 20:40:37 2016 +0200 (2016-04-05)
parents
children 659e3eda2fad
rev   line source
bsw@1248 1 NewsletterToSend = mondelefant.new_class()
bsw@1248 2 NewsletterToSend.table = 'newsletter_to_send'
bsw@1248 3
bsw@1248 4 NewsletterToSend:add_reference{
bsw@1248 5 mode = 'm1',
bsw@1248 6 to = "Newsletter",
bsw@1248 7 this_key = 'newsletter_id',
bsw@1248 8 that_key = 'id',
bsw@1248 9 ref = 'newsletter',
bsw@1248 10 }
bsw@1248 11
bsw@1248 12 NewsletterToSend:add_reference{
bsw@1248 13 mode = 'm1',
bsw@1248 14 to = "Member",
bsw@1248 15 this_key = 'recipient_id',
bsw@1248 16 that_key = 'id',
bsw@1248 17 ref = 'member',
bsw@1248 18 }
bsw@1248 19
bsw@1248 20 function NewsletterToSend:get_next()
bsw@1248 21 return NewsletterToSend:new_selector()
bsw@1248 22 :set_distinct("newsletter_id")
bsw@1248 23 :add_order_by("newsletter_id")
bsw@1248 24 :limit(1)
bsw@1248 25 :optional_object_mode()
bsw@1248 26 :exec()
bsw@1248 27 end
bsw@1248 28
bsw@1248 29 function NewsletterToSend:by_newsletter_id(id)
bsw@1248 30 return NewsletterToSend:new_selector()
bsw@1248 31 :add_where{ "newsletter_id = ?", id }
bsw@1248 32 :optional_object_mode()
bsw@1248 33 :exec()
bsw@1248 34 end

Impressum / About Us