projekt kivitendo

  active                     => { type => 'boolean', default => 'true' },

  ar_chart_id                => { type => 'integer', not_null => 1 },

  copies                     => { type => 'integer' },

  direct_debit               => { type => 'boolean', default => 'false', not_null => 1 },

  email_body                 => { type => 'text' },

  email_recipient_address    => { type => 'text' },

  email_recipient_contact_id => { type => 'integer' },

  email_sender               => { type => 'text' },

  email_subject              => { type => 'text' },

  end_date                   => { type => 'date' },

  extend_automatically_by    => { type => 'integer' },

  first_billing_date         => { type => 'date' },

  id                         => { type => 'integer', not_null => 1, sequence => 'id' },

  oe_id                      => { type => 'integer', not_null => 1 },

  order_value_periodicity    => { type => 'varchar', length => 1, not_null => 1 },

  periodicity                => { type => 'varchar', length => 1, not_null => 1 },

  print                      => { type => 'boolean', default => 'false' },

  printer_id                 => { type => 'integer' },

  send_email                 => { type => 'boolean', default => 'false', not_null => 1 },

  start_date                 => { type => 'date' },

  terminated                 => { type => 'boolean', default => 'false' },

  email_recipient_contact => {

    class       => 'SL::DB::Contact',

    key_columns => { email_recipient_contact_id => 'cp_id' },

  },

                                                      print printer_id copies direct_debit send_email email_recipient_contact_id email_recipient_address email_sender email_subject email_body) };

  if ($::form->{customer_id}) {

    $::form->{ALL_CONTACTS} = SL::DB::Manager::Contact->get_all_sorted(where => [ cp_cv_id => $::form->{customer_id} ]);

  }

                 send_email                 => $::form->{send_email} ? 1 : 0,

                 email_recipient_contact_id => $::form->{email_recipient_contact_id} * 1 || undef,

                 email_recipient_address    => $::form->{email_recipient_address},

                 email_sender               => $::form->{email_sender},

                 email_subject              => $::form->{email_subject},

                 email_body                 => $::form->{email_body},

tr.rule-before th, tr.rule-before td {

  padding-top: 2px;

  border-top: 2px solid #EBEBEB;

}

  var width     = 800;

  var height    = 650;

  var cus_id    = $('[name=customer_id]').val();

    "customer_id="              + encodeURIComponent(cus_id) + "&" +

  'Contact to send to'          => 'An Ansprechperson schicken',

  'Multiple addresses can be entered separated by commas.' => 'Mehrere Adressen können durch Kommata getrennt angegeben werden.',

  'Other recipients'            => 'Weitere EmpfängerInnen',

  'Send invoice via email'      => 'Rechnung via E-Mail verschicken',

    periodic_invoices_configs => { oe_id => 'order', email_recipient_contact_id => 'email_recipient_contact' },

-- @tag: periodic_invoices_send_email

-- @description: Wiederkehrende Rechnungen automatisch per E-Mail verschicken

-- @depends: release_3_4_0

ALTER TABLE periodic_invoices_configs ADD COLUMN send_email                 BOOLEAN;

ALTER TABLE periodic_invoices_configs ADD COLUMN email_recipient_contact_id INTEGER;

ALTER TABLE periodic_invoices_configs ADD COLUMN email_recipient_address    TEXT;

ALTER TABLE periodic_invoices_configs ADD COLUMN email_sender               TEXT;

ALTER TABLE periodic_invoices_configs ADD COLUMN email_subject              TEXT;

ALTER TABLE periodic_invoices_configs ADD COLUMN email_body                 TEXT;

UPDATE periodic_invoices_configs SET send_email = FALSE;

ALTER TABLE periodic_invoices_configs ALTER COLUMN send_email SET DEFAULT FALSE;

ALTER TABLE periodic_invoices_configs ALTER COLUMN send_email SET NOT NULL;

ALTER TABLE periodic_invoices_configs

ADD FOREIGN KEY (email_recipient_contact_id) REFERENCES contacts (cp_id)

ON DELETE SET NULL;

    <tr class="rule-before">

    <tr class="rule-before">

     <th align="right">[%- LxERP.t8("Send invoice via email") %]</th>

     <td>[% L.checkbox_tag("send_email", onclick => "toggle_send_email_ctrl()", checked=send_email) %]</td>

    </tr>

    <tr>

     <th align="right">[%- LxERP.t8("Contact to send to") %]</th>

     <td>[% L.select_tag("email_recipient_contact_id", ALL_CONTACTS, title_key="full_name_dep", value_key="cp_id", default=email_recipient_contact_id, with_empty=1, disabled=!send_email, style=style) %]</td>

    </tr>

    <tr>

     <th align="right">[%- LxERP.t8("Other recipients") %]<sup>3</sup></th>

     <td>[% L.input_tag("email_recipient_address", email_recipient_address, disabled=!send_email, style=style) %]</td>

    </tr>

    <tr>

     <th align="right">[%- LxERP.t8("Sender") %]</th>

     <td>[% L.input_tag("email_sender", email_sender, disabled=!send_email, style=style) %]</td>

    </tr>

    <tr>

     <th align="right">[%- LxERP.t8("Subject") %]</th>

     <td>[% L.input_tag("email_subject", email_subject, disabled=!send_email, style=style) %]</td>

    </tr>

    <tr>

     <th align="right" valign="top">[%- LxERP.t8("Message") %]</th>

     <td valign="top">[% L.textarea_tag("email_body", email_body, disabled=!send_email, rows=8, style=style) %]</td>

    </tr>

  <p>(3): [% LxERP.t8("Multiple addresses can be entered separated by commas.") %]</p>

    function toggle_send_email_ctrl() {

      var disabled = !$('#send_email').prop('checked');

      $('#email_recipient_contact_id').prop('disabled', disabled);

      $('#email_recipient_address').prop('disabled', disabled);

      $('#email_from').prop('disabled', disabled);

      $('#email_subject').prop('disabled', disabled);

      $('#email_body').prop('disabled', disabled);

    }