1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/model/newsletter_to_send.lua	Tue Apr 05 20:40:37 2016 +0200
     1.3 @@ -0,0 +1,34 @@
     1.4 +NewsletterToSend = mondelefant.new_class()
     1.5 +NewsletterToSend.table = 'newsletter_to_send'
     1.6 +
     1.7 +NewsletterToSend:add_reference{
     1.8 +  mode          = 'm1',
     1.9 +  to            = "Newsletter",
    1.10 +  this_key      = 'newsletter_id',
    1.11 +  that_key      = 'id',
    1.12 +  ref           = 'newsletter',
    1.13 +}
    1.14 +
    1.15 +NewsletterToSend:add_reference{
    1.16 +  mode          = 'm1',
    1.17 +  to            = "Member",
    1.18 +  this_key      = 'recipient_id',
    1.19 +  that_key      = 'id',
    1.20 +  ref           = 'member',
    1.21 +}
    1.22 +
    1.23 +function NewsletterToSend:get_next()
    1.24 +  return NewsletterToSend:new_selector()
    1.25 +    :set_distinct("newsletter_id")
    1.26 +    :add_order_by("newsletter_id")
    1.27 +    :limit(1)
    1.28 +    :optional_object_mode()
    1.29 +    :exec()
    1.30 +end
    1.31 +
    1.32 +function NewsletterToSend:by_newsletter_id(id)
    1.33 +  return NewsletterToSend:new_selector()
    1.34 +    :add_where{ "newsletter_id = ?", id }
    1.35 +    :optional_object_mode()
    1.36 +    :exec()
    1.37 +end
    1.38 \ No newline at end of file