From c9f1d454f30c067a934b069bfc450203e07c3f3f Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Mon, 10 Oct 2022 12:02:43 +0100 Subject: [PATCH] Bug 31713: Add FEE_SUMMARY slip template This patch adds the new FEE_SUMMARY print slip notice template to the database. --- .../data/mysql/atomicupdate/bug_31713.pl | 101 ++++++++++++++++++ .../mysql/en/mandatory/sample_notices.yml | 92 ++++++++++++++++ 2 files changed, 193 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_31713.pl diff --git a/installer/data/mysql/atomicupdate/bug_31713.pl b/installer/data/mysql/atomicupdate/bug_31713.pl new file mode 100644 index 0000000000..1b1013865f --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_31713.pl @@ -0,0 +1,101 @@ +use Modern::Perl; + +return { + bug_number => "31713", + description => "Add FEE_SUMMARY slip notice", + up => sub { + my ($args) = @_; + my ($dbh, $out) = @$args{qw(dbh out)}; + + my $slip_content = <<~'END_CONTENT'; +"[% USE Koha %] +[% USE Branches %] +[% USE Price %] +[% PROCESS 'accounts.inc' %] + + [% IF ( Koha.Preference('LibraryName') ) %] + + + + [% END %] + + + + + + + + + + [% IF borrower.account.outstanding_debits.total_outstanding %] + + + + + + + + + + [% FOREACH debit IN borrower.account.outstanding_debits %] + + + + + + + [% END %] + [% END %] + + [% IF borrower.account.outstanding_credits.total_outstanding %] + + + + + + + + + + [% FOREACH credit IN borrower.account.outstanding_credits %] + + + + + + + [% END %] + [% END %] + + + + + [% IF ( borrower.account.balance <= 0 ) %] + + +
+

[% Koha.Preference('LibraryName') | html %]

+
+

[% Branches.GetName( borrower.branchcode ) | html %]

+
+

Outstanding accounts

+
+

Debts

+
DateChargeAmountOutstanding
[% debit.date | $KohaDates %] + [% PROCESS account_type_description account=debit %] + [%- IF debit.description %], [% debit.description | html %][% END %] + [% debit.amount | $Price %][% debit.amountoutstanding | $Price %]
+

Credits

+
DateCreditAmountOutstanding
[% credit.date | $KohaDates %] + [% PROCESS account_type_description account=credit %] + [%- IF credit.description %], [% credit.description | html %][% END %] + [% credit.amount | $Price %][% credit.amountoutstanding | $Price %]
Total outstanding dues as on date: [% ELSE %][% END %][% borrower.account.balance | $Price %]
" +END_CONTENT + + $dbh->do(qq{ + INSERT IGNORE INTO letter ( module, code, branchcode, name, is_html, title, content, message_transport_type, lang) + VALUES ( 'members', 'FEE_SUMMARY', '', 'Fee Summary Slip', 1, 'Fee Summary for [% borrower.firstname %] [% borrower.surname %]', $slip_content, 'print', 'default' ) + }); + say $out "Notice added"; + }, +}; diff --git a/installer/data/mysql/en/mandatory/sample_notices.yml b/installer/data/mysql/en/mandatory/sample_notices.yml index a98e6a1dd7..367da957ba 100644 --- a/installer/data/mysql/en/mandatory/sample_notices.yml +++ b/installer/data/mysql/en/mandatory/sample_notices.yml @@ -1207,6 +1207,98 @@ tables: - "Your authentication token is [% otp_token %]." - "It is valid one minute." + - module: members + code: FEE_SUMMARY + branchcode: "" + name: "Fee Summary Slip" + is_html: 1 + title: "Fee Summary for [% borrower.firstname %] [% borrower.surname %]" + message_transport_type: print + lang: default + content: + - "[% USE Koha %]" + - "[% USE Branches %]" + - "[% USE Price %]" + - "[% PROCESS 'accounts.inc' %]" + - "" + - " [% IF ( Koha.Preference('LibraryName') ) %]" + - " " + - " " + - " " + - " [% END %]" + - "" + - " " + - " " + - " " + - "" + - " " + - " " + - " " + - "" + - " [% IF borrower.account.outstanding_debits.total_outstanding %]" + - " " + - " " + - " " + - " " + - " " + - " " + - " " + - " " + - " " + - " [% FOREACH debit IN borrower.account.outstanding_debits %]" + - " " + - " " + - " " + - " " + - " " + - " " + - " [% END %]" + - " [% END %]" + - "" + - " [% IF borrower.account.outstanding_credits.total_outstanding %]" + - " " + - " " + - " " + - " " + - " " + - " " + - " " + - " " + - " " + - " [% FOREACH credit IN borrower.account.outstanding_credits %]" + - " " + - " " + - " " + - " " + - " " + - " " + - " [% END %]" + - " [% END %]" + - "" + - " " + - " " + - " " + - " [% IF ( borrower.account.balance <= 0 ) %]" + - " " + - " " + - "
" + - "

[% Koha.Preference('LibraryName') | html %]

" + - "
" + - "

[% Branches.GetName( borrower.branchcode ) | html %]

" + - "
" + - "

Outstanding accounts

" + - "
" + - "

Debts

" + - "
DateChargeAmountOutstanding
[% debit.date | $KohaDates %]" + - " [% PROCESS account_type_description account=debit %]" + - " [%- IF debit.description %], [% debit.description | html %][% END %]" + - " [% debit.amount | $Price %][% debit.amountoutstanding | $Price %]
" + - "

Credits

" + - "
DateCreditAmountOutstanding
[% credit.date | $KohaDates%]" + - " [% PROCESS account_type_description account=credit %]" + - " [%- IF credit.description %], [% credit.description | html %][% END %]" + - " [% credit.amount | $Price %][% credit.amountoutstanding | $Price %]
Total outstanding dues as on date: [% ELSE %][% END %][% borrower.account.balance | $Price %]
" + - module: orderacquisition code: ACQORDER branchcode: "" -- 2.20.1