[%- USE T8 %]
+[%- USE L %]
[% USE HTML %][% USE LxERP %]
-<body>
+[% IF vc == 'vendor' %]
+ [% SET is_vendor = 1 %]
+ [% SET arap = 'ap' %]
+ [% SET iris = 'ir' %]
+[% ELSE %]
+ [% SET is_vendor = 0 %]
+ [% SET arap = 'ar' %]
+ [% SET iris = 'is' %]
+[%- END %]
[%- IF error_message %]
- <p><div class="error_message">[% error_message %]</div></p>
+ <p><div class="message_error">[% error_message %]</div></p>
[%- END %]
<p><div class="listtop">[% title %]</div></p>
- <form action="sepa.pl" method="post">
- <p>1. [% 'Please select the source bank account for the transfers:' | $T8 %]
+ <form action="sepa.pl" method="post" id="form">
+ <p>1.
+ [%- IF is_vendor %]
+ [% 'Please select the source bank account for the transfers:' | $T8 %]
+ [%- ELSE %]
+ [% 'Please select the destination bank account for the collections:' | $T8 %]
+ [%- END %]
<br>
- [%- INCLUDE generic/multibox.html
- name = 'bank_account.id',
- DATA = BANK_ACCOUNTS,
- id_key = 'id',
- label_sub = 'bank_account_label',
- -%]
+ [% L.select_tag('bank_account',
+ BANK_ACCOUNTS,
+ title_key='displayable_name',
+ default=bank_account.id,
+ with_empty=0,
+ style='width:450px',
+ ) %]
</p>
<p>
- 2. [% 'Please Check the bank information for each vendor:' | $T8 %]
+ 2.
+ [%- IF is_vendor %]
+ [% 'Please Check the bank information for each vendor:' | $T8 %]
+ [%- ELSE %]
+ [% 'Please Check the bank information for each customer:' | $T8 %]
+ [%- END %]
<br>
<table>
<tr>
- <th class="listheading">[% 'Vendor' | $T8 %]</th>
+ <th class="listheading">[%- IF is_vendor %][% 'Vendor' | $T8 %][%- ELSE %][%- LxERP.t8('Customer') %][%- END %]</th>
<th class="listheading">[% 'IBAN' | $T8 %]</th>
<th class="listheading">[% 'BIC' | $T8 %]</th>
<th class="listheading">[% 'Bank' | $T8 %]</th>
+ [% IF vc == 'customer' %]
+ <th class="listheading">[% 'Mandator ID' | $T8 %]</th>
+ <th class="listheading">[% 'Mandate Date of Signature' | $T8 %]</th>
+ [%- END %]
</tr>
- [%- FOREACH vbi = VENDOR_BANK_INFO %]
+ [%- FOREACH vbi = VC_BANK_INFO %]
<tr class="listrow[% loop.count % 1 %]">
<td>
- <input type="hidden" name="vendor_bank_info[+].id" value="[% HTML.escape(vbi.id) %]">
- <input type="hidden" name="vendor_bank_info[].name" value="[% HTML.escape(vbi.name) %]">
+ <input type="hidden" name="vc_bank_info[+].id" value="[% HTML.escape(vbi.id) %]">
+ <input type="hidden" name="vc_bank_info[].name" value="[% HTML.escape(vbi.name) %]">
[% HTML.escape(vbi.name) %]
</td>
- <td><input name="vendor_bank_info[].iban" size="20" value="[% HTML.escape(vbi.iban) %]"></td>
- <td><input name="vendor_bank_info[].bic" size="20" value="[% HTML.escape(vbi.bic) %]"></td>
- <td><input name="vendor_bank_info[].bank" size="30" value="[% HTML.escape(vbi.bank) %]"></td>
+ <td><input name="vc_bank_info[].iban" size="34" value="[% HTML.escape(vbi.iban.substr(0, 34)) %]" maxlength="34"></td>
+ <td><input name="vc_bank_info[].bic" size="20" value="[% HTML.escape(vbi.bic.substr(0, 20)) %]" maxlength="20"></td>
+ <td><input name="vc_bank_info[].bank" size="30" value="[% HTML.escape(vbi.bank) %]"></td>
+ [% IF vc == 'customer' %]
+ <td><input name="vc_bank_info[].mandator_id" size="30" value="[% HTML.escape(vbi.mandator_id) %]"></td>
+ <td>[% L.date_tag("vc_bank_info[].mandate_date_of_signature", vbi.mandate_date_of_signature) %]</td>
+ [%- END %]
</tr>
[%- END %]
</table>
<br>
<table>
<tr>
- <th class="listheading">[% 'Vendor' | $T8 %]</th>
+ <th class="listheading">[%- IF is_vendor %][% 'Vendor' | $T8 %][%- ELSE %][%- LxERP.t8('Customer') %][%- END %]</th>
<th class="listheading">[% 'Invoice' | $T8 %]</th>
<th class="listheading" align="right">[% 'Amount' | $T8 %]</th>
<th class="listheading" align="right">[% 'Open amount' | $T8 %]</th>
<th class="listheading">[% 'Purpose' | $T8 %]</th>
- <th class="listheading" align="right">[% 'Bank transfer amount' | $T8 %]</th>
+ <th class="listheading" align="right">[%- IF is_vendor %][% 'Bank transfer amount' | $T8 %][%- ELSE %][%- LxERP.t8('Bank collection amount') %][%- END %]</th>
+ <th class="listheading" align="right">[% LxERP.t8('Payment type') %]</th>
+ <th class="listheading" align="right">[% LxERP.t8('Skonto information') %]</th>
<th class="listheading">[% 'Execution date' | $T8 %]</th>
</tr>
[%- FOREACH bank_transfer = BANK_TRANSFERS %]
- <input type="hidden" name="bank_transfers[+].ap_id" value="[% HTML.escape(bank_transfer.id) %]">
- <input type="hidden" name="bank_transfers[].vendor_id" value="[% HTML.escape(bank_transfer.vendor_id) %]">
+ <input type="hidden" name="bank_transfers[+].[% arap %]_id" value="[% HTML.escape(bank_transfer.id) %]">
+ <input type="hidden" name="bank_transfers[].vc_id" value="[% HTML.escape(bank_transfer.vc_id) %]">
<input type="hidden" name="bank_transfers[].selected" value="1">
+ <input type="hidden" id="amount_less_skonto_[% loop.count %]" name="amount_less_skonto_[% loop.count %]" value="[% LxERP.format_amount(bank_transfer.amount_less_skonto, 2) %]">
+ <input type="hidden" id="skonto_amount_[% loop.count %]" name="skonto_amount_[% loop.count %]" value="[% LxERP.format_amount(bank_transfer.skonto_amount, 2) %]">
+ <input type="hidden" id="invoice_open_amount_[% loop.count %]" name="invoice_open_amount_[% loop.count %]" value="[% LxERP.format_amount(bank_transfer.open_amount, 2) %]">
<tr class="listrow[% loop.count % 2 %]">
<td>
- [%- IF loop.first || (previous_vendorname != bank_transfer.vendorname) %]
- <a href="ct.pl?action=edit&db=vendor&id=[% HTML.url(bank_transfer.vendor_id) %]&callback=[% HTML.url('sepa.pl?action=bank_transfer_add') %]">
- [%- GET HTML.escape(bank_transfer.vendorname);
- SET previous_vendorname = bank_transfer.vendorname; -%]
+ [%- IF loop.first || (previous_vcname != bank_transfer.vcname) %]
+ <a href="controller.pl?action=CustomerVendor/edit&db=[% vc %]&id=[% HTML.url(bank_transfer.vc_id) %]&callback=[% HTML.url('sepa.pl?action=bank_transfer_add&vc=' _ vc) %]">
+ [%- GET HTML.escape(bank_transfer.vcname);
+ SET previous_vcname = bank_transfer.vcname; -%]
</a>
[%- END -%]
</td>
<td>
- <a href="[% IF bank_transfer.invoice %]ir[% ELSE %]ap[% END %].pl?action=edit&id=[% HTML.escape(bank_transfer.id) %]">
+ <a href="[% IF bank_transfer.invoice %][% iris %][% ELSE %][% arap %][% END %].pl?action=edit&id=[% HTML.escape(bank_transfer.id) %]">
[% HTML.escape(bank_transfer.invnumber) %]
</a>
</td>
<td align="right">[% LxERP.format_amount(bank_transfer.invoice_amount, -2) %]</td>
<td align="right">[% LxERP.format_amount(bank_transfer.open_amount, -2) %]</td>
- <td><input name="bank_transfers[].reference" value="[% HTML.escape(bank_transfer.reference) %]"></td>
- <td align="right"><input name="bank_transfers[].amount" value="[% LxERP.format_amount(bank_transfer.amount, -2) %]" style="text-align: right"></td>
+ <td>
+ <input name="bank_transfers[].reference" value="[% HTML.escape(bank_transfer.reference.substr(0, 140)) %]" size="40" maxlength="140">
+ </td>
+ <td align="right"><input id=[% loop.count %] name="bank_transfers[].amount" value="[% LxERP.format_amount(bank_transfer.amount, -2) %]" style="text-align: right" size="12"></td>
+ <td>
+ [% L.select_tag('bank_transfers[].payment_type', bank_transfer.payment_select_options, value_key => 'payment_type', title_key => 'display', id => 'payment_type_' _ loop.count, class => 'type_target' ) %]
+ </td>
+ <td align="left" [%- IF bank_transfer.within_skonto_period %]style="background-color: LightGreen"[%- END %]>[%- IF bank_transfer.skonto_amount %] [% LxERP.format_amount(bank_transfer.percent_skonto, 2) %] % = [% LxERP.format_amount(bank_transfer.skonto_amount, 2) %] € [% 'until' | $T8 %] [% bank_transfer.skonto_date %] [% END %]</td>
<td nowrap>
- <input name="bank_transfers[].requested_execution_date"
- id="requested_execution_date_[% loop.count %]"
- value="[% HTML.escape(bank_transfer.requested_execution_date) %]"
- size="11">
- <input type="button" name="requested_execution_date_[% loop.count %]_trigger" id="requested_execution_date_[% loop.count %]_trigger" value="?">
+ [% L.date_tag('bank_transfers[].requested_execution_date', bank_transfer.requested_execution_date) %]
</td>
</tr>
[%- END %]
</p>
<p>
- <input type="submit" class="submit" name="action_bank_transfer_create" value="[% 'Create bank transfer' | $T8 %]">
+ [% 'Sum open amount' | $T8 %]: [% LxERP.format_amount(total_trans, -2) %]
</p>
- <input type="hidden" name="action" value="dispatcher">
+ <input type="hidden" name="vc" value="[%- HTML.escape(vc) %]">
<input type="hidden" name="confirmation" value="1">
</form>
<script type="text/javascript">
- <!--
- [%- FOREACH row = BANK_TRANSFERS %]
- Calendar.setup({ inputField : "requested_execution_date_[% loop.count %]",
- ifFormat : "[% myconfig_jsc_dateformat %]",
- align : "BL",
- button : "requested_execution_date_[% loop.count %]_trigger" });
- [%- END %]
- -->
- </script>
+$( ".type_target" ).change(function() {
+ type_id = $(this).attr('id');
+ var id = type_id.match(/\d*$/);
+ // alert("found id " + id);
+ if ( $(this).val() == "without_skonto" ) {
+ $('#' + id).val( $('#invoice_open_amount_' + id).val() );
+ } else if ( $(this).val() == "difference_as_skonto" ) {
+ $('#' + id).val( $('#invoice_open_amount_' + id).val() );
+ } else if ( $(this).val() == "with_skonto_pt" ) {
+ $('#' + id).val( $('#amount_less_skonto_' + id).val() );
+ }
+});
-</body>
-</html>
+</script>