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 |