1 $DBversion = 'XXX'; # will be replaced by the RM
2 if( CheckVersion( $DBversion ) ) {
4 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
5 ('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table>
6 [% IF ( LibraryName ) %]
8 <th colspan="5" class="centerednames">
9 <h3>[% LibraryName | html %]</h3>
15 <th colspan="5" class="centerednames">
16 <h2><u>INVOICE</u></h2>
20 <th colspan="5" class="centerednames">
21 <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2>
26 Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br />
27 Card number: [% patron.cardnumber | html %]<br />
32 <th>Description of charges</th>
34 <th style="text-align:right;">Amount</th>
35 <th style="text-align:right;">Amount outstanding</th>
38 [% FOREACH account IN accounts %]
39 <tr class="highlight">
40 <td>[% account.date | $KohaDates%]</td>
42 [% PROCESS account_type_description account=account %]
43 [%- IF account.description %], [% account.description | html %][% END %]
45 <td>[% account.note | html %]</td>
46 [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td>
47 [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td>
53 <td colspan="4">Total outstanding dues as on date: </td>
54 [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
57 </table>', 'print', 'default');
59 SetVersion( $DBversion );
60 print "Upgrade to $DBversion done (Bug XXXXX - description)\n";