liquid_feedback_frontend
view 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 |
line source
1 NewsletterToSend = mondelefant.new_class()
2 NewsletterToSend.table = 'newsletter_to_send'
4 NewsletterToSend:add_reference{
5 mode = 'm1',
6 to = "Newsletter",
7 this_key = 'newsletter_id',
8 that_key = 'id',
9 ref = 'newsletter',
10 }
12 NewsletterToSend:add_reference{
13 mode = 'm1',
14 to = "Member",
15 this_key = 'recipient_id',
16 that_key = 'id',
17 ref = 'member',
18 }
20 function NewsletterToSend:get_next()
21 return NewsletterToSend:new_selector()
22 :set_distinct("newsletter_id")
23 :add_order_by("newsletter_id")
24 :limit(1)
25 :optional_object_mode()
26 :exec()
27 end
29 function NewsletterToSend:by_newsletter_id(id)
30 return NewsletterToSend:new_selector()
31 :add_where{ "newsletter_id = ?", id }
32 :optional_object_mode()
33 :exec()
34 end