@@ -, +, @@ --- .../data/mysql/atomicupdate/bug_22809.perl | 61 +++++++++++++++++++ .../mysql/en/mandatory/sample_notices.sql | 55 +++++++++++++++++ .../prog/en/modules/members/printinvoice.tt | 54 +--------------- members/printinvoice.pl | 22 +++++-- 4 files changed, 133 insertions(+), 59 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug_22809.perl --- a/installer/data/mysql/atomicupdate/bug_22809.perl +++ a/installer/data/mysql/atomicupdate/bug_22809.perl @@ -0,0 +1,61 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + $dbh->do(q{ +INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES +('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '
+ [% LibraryName | html %]+ |
+ ||||||
---|---|---|---|---|---|---|
+ INVOICE+ |
+ ||||||
+ [% Branches.GetName( patron.branchcode ) | html %]+ |
+ ||||||
+ Bill to: [% patron.firstname | html %] [% patron.surname | html %] + Card number: [% patron.cardnumber | html %] + |
+ ||||||
Date | +Description of charges | +Note | +Amount | +Amount outstanding | +||
[% account.date | $KohaDates%] | ++ [% PROCESS account_type_description account=account %] + [%- IF account.description %], [% account.description | html %][% END %] + | +[% account.note | html %] | + [% IF ( account.amountcredit ) %][% ELSE %] | [% END %][% account.amount | $Price %] | + [% IF ( account.amountoutstandingcredit ) %][% ELSE %] | [% END %][% account.amountoutstanding | $Price %] | +
Total outstanding dues as on date: | + [% IF ( totalcredit ) %][% ELSE %] | [% END %][% total | $Price %] | +
+ [% LibraryName | html %]+ |
+ ||||||
---|---|---|---|---|---|---|
+ INVOICE+ |
+ ||||||
+ [% Branches.GetName( patron.branchcode ) | html %]+ |
+ ||||||
+ Bill to: [% patron.firstname | html %] [% patron.surname | html %] + Card number: [% patron.cardnumber | html %] + |
+ ||||||
Date | +Description of charges | +Note | +Amount | +Amount outstanding | +||
[% account.date | $KohaDates%] | ++ [% PROCESS account_type_description account=account %] + [%- IF account.description %], [% account.description | html %][% END %] + | +[% account.note | html %] | + [% IF ( account.amountcredit ) %][% ELSE %] | [% END %][% account.amount | $Price %] | + [% IF ( account.amountoutstandingcredit ) %][% ELSE %] | [% END %][% account.amountoutstanding | $Price %] | +
Total outstanding dues as on date: | + [% IF ( totalcredit ) %][% ELSE %] | [% END %][% total | $Price %] | +
- [% LibraryName | html %]- |
- ||||||
---|---|---|---|---|---|---|
- INVOICE- |
- ||||||
- [% Branches.GetName( patron.branchcode ) | html %]- |
- ||||||
- Bill to: [% patron.firstname | html %] [% patron.surname | html %] - Card number: [% patron.cardnumber | html %] - |
- ||||||
Date | -Description of charges | -Note | -Amount | -Amount outstanding | -||
[% account.date | $KohaDates%] | -- [% PROCESS account_type_description account=account %] - [%- IF account.description %], [% account.description | html %][% END %] - | -[% account.note | html %] | - [% IF ( account.amountcredit ) %][% ELSE %] | [% END %][% account.amount | $Price %] | - [% IF ( account.amountoutstandingcredit ) %][% ELSE %] | [% END %][% account.amountoutstanding | $Price %] | -
Total outstanding dues as on date: | - [% IF ( totalcredit ) %][% ELSE %] | [% END %][% total | $Price %] | -