View | Details | Raw Unified | Return to bug 26734
Collapse All | Expand All

(-)a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql (-50 / +61 lines)
Lines 110-217 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
110
('circulation', 'ACCOUNT_WRITEOFF', '', 'Amnistie', 0, 'Amnistie', '[%- USE Price -%]\r\nNous avons accordé une amnistie de [% credit.amount * -1 | $Price %] à votre compte.\r\n\r\nLes frais suivants ont été amnistiés :\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nMontant payé : [% o.amount * -1 | $Price %]\r\nMontant en souffrance : [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');
110
('circulation', 'ACCOUNT_WRITEOFF', '', 'Amnistie', 0, 'Amnistie', '[%- USE Price -%]\r\nNous avons accordé une amnistie de [% credit.amount * -1 | $Price %] à votre compte.\r\n\r\nLes frais suivants ont été amnistiés :\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nMontant payé : [% o.amount * -1 | $Price %]\r\nMontant en souffrance : [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');
111
111
112
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
112
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
113
('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '<table>
113
('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '[% USE Price %]
114
[% PROCESS \"accounts.inc\" %]
115
<table>
114
[% IF ( LibraryName ) %]
116
[% IF ( LibraryName ) %]
115
 <tr>
117
 <tr>
116
    <th colspan="4" class="centerednames">
118
    <th colspan=\"4\" class=\"centerednames\">
117
        <h3>[% LibraryName | html %]</h3>
119
        <h3>[% LibraryName | html %]</h3>
118
    </th>
120
    </th>
119
 </tr>
121
 </tr>
120
[% END %]
122
[% END %]
121
 <tr>
123
 <tr>
122
    <th colspan="4" class="centerednames">
124
    <th colspan=\"4\" class=\"centerednames\">
123
        <h2><u>REÇU</u></h2>
125
        <h2><u>Fee receipt</u></h2>
124
    </th>
126
    </th>
125
 </tr>
127
 </tr>
126
 <tr>
128
 <tr>
127
    <th colspan="4" class="centerednames">
129
    <th colspan=\"4\" class=\"centerednames\">
128
        <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2>
130
        <h2>[% Branches.GetName( credit.patron.branchcode ) | html %]</h2>
129
    </th>
131
    </th>
130
 </tr>
132
 </tr>
131
 <tr>
133
 <tr>
132
    <th colspan="4">
134
    <th colspan=\"4\">
133
        Reçu de [% patron.firstname | html %] [% patron.surname | html %] <br />
135
        Received with thanks from  [% credit.patron.firstname | html %] [% credit.patron.surname | html %] <br />
134
        Numéro de carte : [% patron.cardnumber | html %]<br />
136
        Card number: [% credit.patron.cardnumber | html %]<br />
135
    </th>
137
    </th>
136
 </tr>
138
 </tr>
137
  <tr>
139
  <tr>
138
    <th>Date</th>
140
    <th>Date</th>
139
    <th>Description des frais</th>
141
    <th>Description of charges</th>
140
    <th>Note</th>
142
    <th>Note</th>
141
    <th>Montant</th>
143
    <th>Amount</th>
142
 </tr>
144
 </tr>
143
145
144
  [% FOREACH account IN accounts %]
146
 <tr class=\"highlight\">
145
    <tr class="highlight">
147
    <td>[% credit.date | $KohaDates %]</td>
146
      <td>[% account.date | $KohaDates %]</td>
148
    <td>
147
      <td>
149
      [% PROCESS account_type_description account=credit %]
148
        [% PROCESS account_type_description account=account %]
150
      [%- IF credit.description %], [% credit.description | html %][% END %]
149
        [%- IF account.description %], [% account.description | html %][% END %]
151
    </td>
150
      </td>
152
    <td>[% credit.note | html %]</td>
151
      <td>[% account.note | html %]</td>
153
    <td class=\"credit\">[% credit.amount | $Price %]</td>
152
      [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td>
154
 </tr>
153
    </tr>
155
156
[% IF ( tendered ) %]
157
  <tr>
158
    <td colspan=\"3\">Amount tendered: </td>
159
    <td>[% tendered | $Price %]</td>
160
  </tr>
161
  <tr>
162
    <td colspan=\"3\">Change given: </td>
163
    <td>[% change | $Price %]</td>
164
  </tr>
165
[% END %]
154
166
155
  [% END %]
156
<tfoot>
167
<tfoot>
157
  <tr>
168
  <tr>
158
    <td colspan="3">Solde non-réglé : </td>
169
    <td colspan=\"3\">Total outstanding dues as on date: </td>
159
    [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
170
    [% IF ( credit.patron.account.balance >= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% credit.patron.account.balance | $Price %]</td>
160
  </tr>
171
  </tr>
161
</tfoot>
172
</tfoot>
162
</table>', 'print', 'default');
173
</table>', 'print', 'default');
163
174
164
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
175
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
165
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table>
176
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '[% USE Price %]
177
[% PROCESS \"accounts.inc\" %]
178
<table>
166
  [% IF ( LibraryName ) %]
179
  [% IF ( LibraryName ) %]
167
    <tr>
180
    <tr>
168
      <th colspan="5" class="centerednames">
181
      <th colspan=\"5\" class=\"centerednames\">
169
        <h3>[% LibraryName | html %]</h3>
182
        <h3>[% LibraryName | html %]</h3>
170
      </th>
183
      </th>
171
    </tr>
184
    </tr>
172
  [% END %]
185
  [% END %]
173
186
174
  <tr>
187
  <tr>
175
    <th colspan="5" class="centerednames">
188
    <th colspan=\"5\" class=\"centerednames\">
176
      <h2><u>FACTURE</u></h2>
189
      <h2><u>INVOICE</u></h2>
177
    </th>
190
    </th>
178
  </tr>
191
  </tr>
179
  <tr>
192
  <tr>
180
    <th colspan="5" class="centerednames">
193
    <th colspan=\"5\" class=\"centerednames\">
181
      <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2>
194
      <h2>[% Branches.GetName( debit.patron.branchcode ) | html %]</h2>
182
    </th>
195
    </th>
183
  </tr>
196
  </tr>
184
  <tr>
197
  <tr>
185
    <th colspan="5" >
198
    <th colspan=\"5\" >
186
      Facturé à : [% patron.firstname | html %] [% patron.surname | html %] <br />
199
      Bill to: [% debit.patron.firstname | html %] [% debit.patron.surname | html %] <br />
187
      Numéro de carte : [% patron.cardnumber | html %]<br />
200
      Card number: [% debit.patron.cardnumber | html %]<br />
188
    </th>
201
    </th>
189
  </tr>
202
  </tr>
190
  <tr>
203
  <tr>
191
    <th>Date</th>
204
    <th>Date</th>
192
    <th>Description des frais</th>
205
    <th>Description of charges</th>
193
    <th>Note</th>
206
    <th>Note</th>
194
    <th style="text-align:right;">Montant</th>
207
    <th style=\"text-align:right;\">Amount</th>
195
    <th style="text-align:right;">Solde</th>
208
    <th style=\"text-align:right;\">Amount outstanding</th>
196
  </tr>
209
  </tr>
197
210
198
  [% FOREACH account IN accounts %]
211
  <tr class=\"highlight\">
199
    <tr class="highlight">
212
    <td>[% debit.date | $KohaDates%]</td>
200
      <td>[% account.date | $KohaDates%]</td>
213
    <td>
201
      <td>
214
      [% PROCESS account_type_description account=debit %]
202
        [% PROCESS account_type_description account=account %]
215
      [%- IF debit.description %], [% debit.description | html %][% END %]
203
        [%- IF account.description %], [% account.description | html %][% END %]
216
    </td>
204
      </td>
217
    <td>[% debit.note | html %]</td>
205
      <td>[% account.note | html %]</td>
218
    <td class=\"debit\">[% debit.amount | $Price %]</td>
206
      [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td>
219
    <td class=\"debit\">[% debit.amountoutstanding | $Price %]</td>
207
      [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td>
220
  </tr>
208
    </tr>
209
  [% END %]
210
221
211
  <tfoot>
222
  <tfoot>
212
    <tr>
223
    <tr>
213
      <td colspan="4">Solde non-réglé : </td>
224
      <td colspan=\"4\">Total outstanding dues as on date: </td>
214
      [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
225
      [% IF ( debit.patron.account.balance <= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% debit.patron.account.balance | $Price %]</td>
215
    </tr>
226
    </tr>
216
  </tfoot>
227
  </tfoot>
217
</table>', 'print', 'default');
228
</table>', 'print', 'default');
(-)a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql (-46 / +56 lines)
Lines 223-250 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
223
('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 | $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 | $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');
223
('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 | $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 | $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');
224
224
225
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
225
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
226
('circulation', 'ACCOUNT_CREDIT', '', 'Account payment', 0, 'Account payment', '<table>
226
('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '[% USE Price %]
227
[% PROCESS \"accounts.inc\" %]
228
<table>
227
[% IF ( LibraryName ) %]
229
[% IF ( LibraryName ) %]
228
 <tr>
230
 <tr>
229
    <th colspan="4" class="centerednames">
231
    <th colspan=\"4\" class=\"centerednames\">
230
        <h3>[% LibraryName | html %]</h3>
232
        <h3>[% LibraryName | html %]</h3>
231
    </th>
233
    </th>
232
 </tr>
234
 </tr>
233
[% END %]
235
[% END %]
234
 <tr>
236
 <tr>
235
    <th colspan="4" class="centerednames">
237
    <th colspan=\"4\" class=\"centerednames\">
236
        <h2><u>Fee receipt</u></h2>
238
        <h2><u>Fee receipt</u></h2>
237
    </th>
239
    </th>
238
 </tr>
240
 </tr>
239
 <tr>
241
 <tr>
240
    <th colspan="4" class="centerednames">
242
    <th colspan=\"4\" class=\"centerednames\">
241
        <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2>
243
        <h2>[% Branches.GetName( credit.patron.branchcode ) | html %]</h2>
242
    </th>
244
    </th>
243
 </tr>
245
 </tr>
244
 <tr>
246
 <tr>
245
    <th colspan="4">
247
    <th colspan=\"4\">
246
        Received with thanks from  [% patron.firstname | html %] [% patron.surname | html %] <br />
248
        Received with thanks from  [% credit.patron.firstname | html %] [% credit.patron.surname | html %] <br />
247
        Card number: [% patron.cardnumber | html %]<br />
249
        Card number: [% credit.patron.cardnumber | html %]<br />
248
    </th>
250
    </th>
249
 </tr>
251
 </tr>
250
  <tr>
252
  <tr>
Lines 254-334 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
254
    <th>Amount</th>
256
    <th>Amount</th>
255
 </tr>
257
 </tr>
256
258
257
  [% FOREACH account IN accounts %]
259
 <tr class=\"highlight\">
258
    <tr class="highlight">
260
    <td>[% credit.date | $KohaDates %]</td>
259
      <td>[% account.date | $KohaDates %]</td>
261
    <td>
260
      <td>
262
      [% PROCESS account_type_description account=credit %]
261
        [% PROCESS account_type_description account=account %]
263
      [%- IF credit.description %], [% credit.description | html %][% END %]
262
        [%- IF account.description %], [% account.description | html %][% END %]
264
    </td>
263
      </td>
265
    <td>[% credit.note | html %]</td>
264
      <td>[% account.note | html %]</td>
266
    <td class=\"credit\">[% credit.amount | $Price %]</td>
265
      [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td>
267
 </tr>
266
    </tr>
268
269
[% IF ( tendered ) %]
270
  <tr>
271
    <td colspan=\"3\">Amount tendered: </td>
272
    <td>[% tendered | $Price %]</td>
273
  </tr>
274
  <tr>
275
    <td colspan=\"3\">Change given: </td>
276
    <td>[% change | $Price %]</td>
277
  </tr>
278
[% END %]
267
279
268
  [% END %]
269
<tfoot>
280
<tfoot>
270
  <tr>
281
  <tr>
271
    <td colspan="3">Total outstanding dues as on date: </td>
282
    <td colspan=\"3\">Total outstanding dues as on date: </td>
272
    [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
283
    [% IF ( credit.patron.account.balance >= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% credit.patron.account.balance | $Price %]</td>
273
  </tr>
284
  </tr>
274
</tfoot>
285
</tfoot>
275
</table>', 'print', 'default');
286
</table>', 'print', 'default');
276
287
277
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
288
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
278
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table>
289
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '[% USE Price %]
290
[% PROCESS \"accounts.inc\" %]
291
<table>
279
  [% IF ( LibraryName ) %]
292
  [% IF ( LibraryName ) %]
280
    <tr>
293
    <tr>
281
      <th colspan="5" class="centerednames">
294
      <th colspan=\"5\" class=\"centerednames\">
282
        <h3>[% LibraryName | html %]</h3>
295
        <h3>[% LibraryName | html %]</h3>
283
      </th>
296
      </th>
284
    </tr>
297
    </tr>
285
  [% END %]
298
  [% END %]
286
299
287
  <tr>
300
  <tr>
288
    <th colspan="5" class="centerednames">
301
    <th colspan=\"5\" class=\"centerednames\">
289
      <h2><u>INVOICE</u></h2>
302
      <h2><u>INVOICE</u></h2>
290
    </th>
303
    </th>
291
  </tr>
304
  </tr>
292
  <tr>
305
  <tr>
293
    <th colspan="5" class="centerednames">
306
    <th colspan=\"5\" class=\"centerednames\">
294
      <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2>
307
      <h2>[% Branches.GetName( debit.patron.branchcode ) | html %]</h2>
295
    </th>
308
    </th>
296
  </tr>
309
  </tr>
297
  <tr>
310
  <tr>
298
    <th colspan="5" >
311
    <th colspan=\"5\" >
299
      Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br />
312
      Bill to: [% debit.patron.firstname | html %] [% debit.patron.surname | html %] <br />
300
      Card number: [% patron.cardnumber | html %]<br />
313
      Card number: [% debit.patron.cardnumber | html %]<br />
301
    </th>
314
    </th>
302
  </tr>
315
  </tr>
303
  <tr>
316
  <tr>
304
    <th>Date</th>
317
    <th>Date</th>
305
    <th>Description of charges</th>
318
    <th>Description of charges</th>
306
    <th>Note</th>
319
    <th>Note</th>
307
    <th style="text-align:right;">Amount</th>
320
    <th style=\"text-align:right;\">Amount</th>
308
    <th style="text-align:right;">Amount outstanding</th>
321
    <th style=\"text-align:right;\">Amount outstanding</th>
309
  </tr>
322
  </tr>
310
323
311
  [% FOREACH account IN accounts %]
324
  <tr class=\"highlight\">
312
    <tr class="highlight">
325
    <td>[% debit.date | $KohaDates%]</td>
313
      <td>[% account.date | $KohaDates%]</td>
326
    <td>
314
      <td>
327
      [% PROCESS account_type_description account=debit %]
315
        [% PROCESS account_type_description account=account %]
328
      [%- IF debit.description %], [% debit.description | html %][% END %]
316
        [%- IF account.description %], [% account.description | html %][% END %]
329
    </td>
317
      </td>
330
    <td>[% debit.note | html %]</td>
318
      <td>[% account.note | html %]</td>
331
    <td class=\"debit\">[% debit.amount | $Price %]</td>
319
      [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td>
332
    <td class=\"debit\">[% debit.amountoutstanding | $Price %]</td>
320
      [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td>
333
  </tr>
321
    </tr>
322
  [% END %]
323
334
324
  <tfoot>
335
  <tfoot>
325
    <tr>
336
    <tr>
326
      <td colspan="4">Total outstanding dues as on date: </td>
337
      <td colspan=\"4\">Total outstanding dues as on date: </td>
327
      [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
338
      [% IF ( debit.patron.account.balance <= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% debit.patron.account.balance | $Price %]</td>
328
    </tr>
339
    </tr>
329
  </tfoot>
340
  </tfoot>
330
</table>', 'print', 'default');
341
</table>', 'print', 'default');
331
332
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
342
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
333
('circulation', 'SR_SLIP', '', 'Stock rotation slip', 0, 'Stock rotation report', 'Stock rotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
343
('circulation', 'SR_SLIP', '', 'Stock rotation slip', 0, 'Stock rotation report', 'Stock rotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
334
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
344
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
(-)a/installer/data/mysql/it-IT/necessari/notices.sql (-45 / +56 lines)
Lines 225-252 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
225
('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 | $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 | $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');
225
('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 | $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 | $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');
226
226
227
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
227
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
228
('circulation', 'ACCOUNT_CREDIT', '', 'Account payment', 0, 'Account payment', '<table>
228
('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '[% USE Price %]
229
[% PROCESS \"accounts.inc\" %]
230
<table>
229
[% IF ( LibraryName ) %]
231
[% IF ( LibraryName ) %]
230
 <tr>
232
 <tr>
231
    <th colspan="4" class="centerednames">
233
    <th colspan=\"4\" class=\"centerednames\">
232
        <h3>[% LibraryName | html %]</h3>
234
        <h3>[% LibraryName | html %]</h3>
233
    </th>
235
    </th>
234
 </tr>
236
 </tr>
235
[% END %]
237
[% END %]
236
 <tr>
238
 <tr>
237
    <th colspan="4" class="centerednames">
239
    <th colspan=\"4\" class=\"centerednames\">
238
        <h2><u>Fee receipt</u></h2>
240
        <h2><u>Fee receipt</u></h2>
239
    </th>
241
    </th>
240
 </tr>
242
 </tr>
241
 <tr>
243
 <tr>
242
    <th colspan="4" class="centerednames">
244
    <th colspan=\"4\" class=\"centerednames\">
243
        <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2>
245
        <h2>[% Branches.GetName( credit.patron.branchcode ) | html %]</h2>
244
    </th>
246
    </th>
245
 </tr>
247
 </tr>
246
 <tr>
248
 <tr>
247
    <th colspan="4">
249
    <th colspan=\"4\">
248
        Received with thanks from  [% patron.firstname | html %] [% patron.surname | html %] <br />
250
        Received with thanks from  [% credit.patron.firstname | html %] [% credit.patron.surname | html %] <br />
249
        Card number: [% patron.cardnumber | html %]<br />
251
        Card number: [% credit.patron.cardnumber | html %]<br />
250
    </th>
252
    </th>
251
 </tr>
253
 </tr>
252
  <tr>
254
  <tr>
Lines 256-332 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
256
    <th>Amount</th>
258
    <th>Amount</th>
257
 </tr>
259
 </tr>
258
260
259
  [% FOREACH account IN accounts %]
261
 <tr class=\"highlight\">
260
    <tr class="highlight">
262
    <td>[% credit.date | $KohaDates %]</td>
261
      <td>[% account.date | $KohaDates %]</td>
263
    <td>
262
      <td>
264
      [% PROCESS account_type_description account=credit %]
263
        [% PROCESS account_type_description account=account %]
265
      [%- IF credit.description %], [% credit.description | html %][% END %]
264
        [%- IF account.description %], [% account.description | html %][% END %]
266
    </td>
265
      </td>
267
    <td>[% credit.note | html %]</td>
266
      <td>[% account.note | html %]</td>
268
    <td class=\"credit\">[% credit.amount | $Price %]</td>
267
      [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td>
269
 </tr>
268
    </tr>
270
271
[% IF ( tendered ) %]
272
  <tr>
273
    <td colspan=\"3\">Amount tendered: </td>
274
    <td>[% tendered | $Price %]</td>
275
  </tr>
276
  <tr>
277
    <td colspan=\"3\">Change given: </td>
278
    <td>[% change | $Price %]</td>
279
  </tr>
280
[% END %]
269
281
270
  [% END %]
271
<tfoot>
282
<tfoot>
272
  <tr>
283
  <tr>
273
    <td colspan="3">Total outstanding dues as on date: </td>
284
    <td colspan=\"3\">Total outstanding dues as on date: </td>
274
    [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
285
    [% IF ( credit.patron.account.balance >= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% credit.patron.account.balance | $Price %]</td>
275
  </tr>
286
  </tr>
276
</tfoot>
287
</tfoot>
277
</table>', 'print', 'default');
288
</table>', 'print', 'default');
278
289
279
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
290
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
280
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table>
291
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '[% USE Price %]
292
[% PROCESS \"accounts.inc\" %]
293
<table>
281
  [% IF ( LibraryName ) %]
294
  [% IF ( LibraryName ) %]
282
    <tr>
295
    <tr>
283
      <th colspan="5" class="centerednames">
296
      <th colspan=\"5\" class=\"centerednames\">
284
        <h3>[% LibraryName | html %]</h3>
297
        <h3>[% LibraryName | html %]</h3>
285
      </th>
298
      </th>
286
    </tr>
299
    </tr>
287
  [% END %]
300
  [% END %]
288
301
289
  <tr>
302
  <tr>
290
    <th colspan="5" class="centerednames">
303
    <th colspan=\"5\" class=\"centerednames\">
291
      <h2><u>INVOICE</u></h2>
304
      <h2><u>INVOICE</u></h2>
292
    </th>
305
    </th>
293
  </tr>
306
  </tr>
294
  <tr>
307
  <tr>
295
    <th colspan="5" class="centerednames">
308
    <th colspan=\"5\" class=\"centerednames\">
296
      <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2>
309
      <h2>[% Branches.GetName( debit.patron.branchcode ) | html %]</h2>
297
    </th>
310
    </th>
298
  </tr>
311
  </tr>
299
  <tr>
312
  <tr>
300
    <th colspan="5" >
313
    <th colspan=\"5\" >
301
      Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br />
314
      Bill to: [% debit.patron.firstname | html %] [% debit.patron.surname | html %] <br />
302
      Card number: [% patron.cardnumber | html %]<br />
315
      Card number: [% debit.patron.cardnumber | html %]<br />
303
    </th>
316
    </th>
304
  </tr>
317
  </tr>
305
  <tr>
318
  <tr>
306
    <th>Date</th>
319
    <th>Date</th>
307
    <th>Description of charges</th>
320
    <th>Description of charges</th>
308
    <th>Note</th>
321
    <th>Note</th>
309
    <th style="text-align:right;">Amount</th>
322
    <th style=\"text-align:right;\">Amount</th>
310
    <th style="text-align:right;">Amount outstanding</th>
323
    <th style=\"text-align:right;\">Amount outstanding</th>
311
  </tr>
324
  </tr>
312
325
313
  [% FOREACH account IN accounts %]
326
  <tr class=\"highlight\">
314
    <tr class="highlight">
327
    <td>[% debit.date | $KohaDates%]</td>
315
      <td>[% account.date | $KohaDates%]</td>
328
    <td>
316
      <td>
329
      [% PROCESS account_type_description account=debit %]
317
        [% PROCESS account_type_description account=account %]
330
      [%- IF debit.description %], [% debit.description | html %][% END %]
318
        [%- IF account.description %], [% account.description | html %][% END %]
331
    </td>
319
      </td>
332
    <td>[% debit.note | html %]</td>
320
      <td>[% account.note | html %]</td>
333
    <td class=\"debit\">[% debit.amount | $Price %]</td>
321
      [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td>
334
    <td class=\"debit\">[% debit.amountoutstanding | $Price %]</td>
322
      [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td>
335
  </tr>
323
    </tr>
324
  [% END %]
325
336
326
  <tfoot>
337
  <tfoot>
327
    <tr>
338
    <tr>
328
      <td colspan="4">Total outstanding dues as on date: </td>
339
      <td colspan=\"4\">Total outstanding dues as on date: </td>
329
      [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
340
      [% IF ( debit.patron.account.balance <= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% debit.patron.account.balance | $Price %]</td>
330
    </tr>
341
    </tr>
331
  </tfoot>
342
  </tfoot>
332
</table>', 'print', 'default');
343
</table>', 'print', 'default');
(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql (-45 / +56 lines)
Lines 241-268 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
241
('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 | $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 | $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');
241
('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 | $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 | $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');
242
242
243
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
243
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
244
('circulation', 'ACCOUNT_CREDIT', '', 'Account payment', 0, 'Account payment', '<table>
244
('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '[% USE Price %]
245
[% PROCESS \"accounts.inc\" %]
246
<table>
245
[% IF ( LibraryName ) %]
247
[% IF ( LibraryName ) %]
246
 <tr>
248
 <tr>
247
    <th colspan="4" class="centerednames">
249
    <th colspan=\"4\" class=\"centerednames\">
248
        <h3>[% LibraryName | html %]</h3>
250
        <h3>[% LibraryName | html %]</h3>
249
    </th>
251
    </th>
250
 </tr>
252
 </tr>
251
[% END %]
253
[% END %]
252
 <tr>
254
 <tr>
253
    <th colspan="4" class="centerednames">
255
    <th colspan=\"4\" class=\"centerednames\">
254
        <h2><u>Fee receipt</u></h2>
256
        <h2><u>Fee receipt</u></h2>
255
    </th>
257
    </th>
256
 </tr>
258
 </tr>
257
 <tr>
259
 <tr>
258
    <th colspan="4" class="centerednames">
260
    <th colspan=\"4\" class=\"centerednames\">
259
        <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2>
261
        <h2>[% Branches.GetName( credit.patron.branchcode ) | html %]</h2>
260
    </th>
262
    </th>
261
 </tr>
263
 </tr>
262
 <tr>
264
 <tr>
263
    <th colspan="4">
265
    <th colspan=\"4\">
264
        Received with thanks from  [% patron.firstname | html %] [% patron.surname | html %] <br />
266
        Received with thanks from  [% credit.patron.firstname | html %] [% credit.patron.surname | html %] <br />
265
        Card number: [% patron.cardnumber | html %]<br />
267
        Card number: [% credit.patron.cardnumber | html %]<br />
266
    </th>
268
    </th>
267
 </tr>
269
 </tr>
268
  <tr>
270
  <tr>
Lines 272-348 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
272
    <th>Amount</th>
274
    <th>Amount</th>
273
 </tr>
275
 </tr>
274
276
275
  [% FOREACH account IN accounts %]
277
 <tr class=\"highlight\">
276
    <tr class="highlight">
278
    <td>[% credit.date | $KohaDates %]</td>
277
      <td>[% account.date | $KohaDates %]</td>
279
    <td>
278
      <td>
280
      [% PROCESS account_type_description account=credit %]
279
        [% PROCESS account_type_description account=account %]
281
      [%- IF credit.description %], [% credit.description | html %][% END %]
280
        [%- IF account.description %], [% account.description | html %][% END %]
282
    </td>
281
      </td>
283
    <td>[% credit.note | html %]</td>
282
      <td>[% account.note | html %]</td>
284
    <td class=\"credit\">[% credit.amount | $Price %]</td>
283
      [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td>
285
 </tr>
284
    </tr>
286
287
[% IF ( tendered ) %]
288
  <tr>
289
    <td colspan=\"3\">Amount tendered: </td>
290
    <td>[% tendered | $Price %]</td>
291
  </tr>
292
  <tr>
293
    <td colspan=\"3\">Change given: </td>
294
    <td>[% change | $Price %]</td>
295
  </tr>
296
[% END %]
285
297
286
  [% END %]
287
<tfoot>
298
<tfoot>
288
  <tr>
299
  <tr>
289
    <td colspan="3">Total outstanding dues as on date: </td>
300
    <td colspan=\"3\">Total outstanding dues as on date: </td>
290
    [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
301
    [% IF ( credit.patron.account.balance >= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% credit.patron.account.balance | $Price %]</td>
291
  </tr>
302
  </tr>
292
</tfoot>
303
</tfoot>
293
</table>', 'print', 'default');
304
</table>', 'print', 'default');
294
305
295
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
306
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
296
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table>
307
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '[% USE Price %]
308
[% PROCESS \"accounts.inc\" %]
309
<table>
297
  [% IF ( LibraryName ) %]
310
  [% IF ( LibraryName ) %]
298
    <tr>
311
    <tr>
299
      <th colspan="5" class="centerednames">
312
      <th colspan=\"5\" class=\"centerednames\">
300
        <h3>[% LibraryName | html %]</h3>
313
        <h3>[% LibraryName | html %]</h3>
301
      </th>
314
      </th>
302
    </tr>
315
    </tr>
303
  [% END %]
316
  [% END %]
304
317
305
  <tr>
318
  <tr>
306
    <th colspan="5" class="centerednames">
319
    <th colspan=\"5\" class=\"centerednames\">
307
      <h2><u>INVOICE</u></h2>
320
      <h2><u>INVOICE</u></h2>
308
    </th>
321
    </th>
309
  </tr>
322
  </tr>
310
  <tr>
323
  <tr>
311
    <th colspan="5" class="centerednames">
324
    <th colspan=\"5\" class=\"centerednames\">
312
      <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2>
325
      <h2>[% Branches.GetName( debit.patron.branchcode ) | html %]</h2>
313
    </th>
326
    </th>
314
  </tr>
327
  </tr>
315
  <tr>
328
  <tr>
316
    <th colspan="5" >
329
    <th colspan=\"5\" >
317
      Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br />
330
      Bill to: [% debit.patron.firstname | html %] [% debit.patron.surname | html %] <br />
318
      Card number: [% patron.cardnumber | html %]<br />
331
      Card number: [% debit.patron.cardnumber | html %]<br />
319
    </th>
332
    </th>
320
  </tr>
333
  </tr>
321
  <tr>
334
  <tr>
322
    <th>Date</th>
335
    <th>Date</th>
323
    <th>Description of charges</th>
336
    <th>Description of charges</th>
324
    <th>Note</th>
337
    <th>Note</th>
325
    <th style="text-align:right;">Amount</th>
338
    <th style=\"text-align:right;\">Amount</th>
326
    <th style="text-align:right;">Amount outstanding</th>
339
    <th style=\"text-align:right;\">Amount outstanding</th>
327
  </tr>
340
  </tr>
328
341
329
  [% FOREACH account IN accounts %]
342
  <tr class=\"highlight\">
330
    <tr class="highlight">
343
    <td>[% debit.date | $KohaDates%]</td>
331
      <td>[% account.date | $KohaDates%]</td>
344
    <td>
332
      <td>
345
      [% PROCESS account_type_description account=debit %]
333
        [% PROCESS account_type_description account=account %]
346
      [%- IF debit.description %], [% debit.description | html %][% END %]
334
        [%- IF account.description %], [% account.description | html %][% END %]
347
    </td>
335
      </td>
348
    <td>[% debit.note | html %]</td>
336
      <td>[% account.note | html %]</td>
349
    <td class=\"debit\">[% debit.amount | $Price %]</td>
337
      [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td>
350
    <td class=\"debit\">[% debit.amountoutstanding | $Price %]</td>
338
      [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td>
351
  </tr>
339
    </tr>
340
  [% END %]
341
352
342
  <tfoot>
353
  <tfoot>
343
    <tr>
354
    <tr>
344
      <td colspan="4">Total outstanding dues as on date: </td>
355
      <td colspan=\"4\">Total outstanding dues as on date: </td>
345
      [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
356
      [% IF ( debit.patron.account.balance <= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% debit.patron.account.balance | $Price %]</td>
346
    </tr>
357
    </tr>
347
  </tfoot>
358
  </tfoot>
348
</table>', 'print', 'default');
359
</table>', 'print', 'default');
(-)a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql (-45 / +56 lines)
Lines 220-247 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
220
('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 | $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 | $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');
220
('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 | $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 | $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');
221
221
222
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
222
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
223
('circulation', 'ACCOUNT_CREDIT', '', 'Account payment', 0, 'Account payment', '<table>
223
('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '[% USE Price %]
224
[% PROCESS \"accounts.inc\" %]
225
<table>
224
[% IF ( LibraryName ) %]
226
[% IF ( LibraryName ) %]
225
 <tr>
227
 <tr>
226
    <th colspan="4" class="centerednames">
228
    <th colspan=\"4\" class=\"centerednames\">
227
        <h3>[% LibraryName | html %]</h3>
229
        <h3>[% LibraryName | html %]</h3>
228
    </th>
230
    </th>
229
 </tr>
231
 </tr>
230
[% END %]
232
[% END %]
231
 <tr>
233
 <tr>
232
    <th colspan="4" class="centerednames">
234
    <th colspan=\"4\" class=\"centerednames\">
233
        <h2><u>Fee receipt</u></h2>
235
        <h2><u>Fee receipt</u></h2>
234
    </th>
236
    </th>
235
 </tr>
237
 </tr>
236
 <tr>
238
 <tr>
237
    <th colspan="4" class="centerednames">
239
    <th colspan=\"4\" class=\"centerednames\">
238
        <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2>
240
        <h2>[% Branches.GetName( credit.patron.branchcode ) | html %]</h2>
239
    </th>
241
    </th>
240
 </tr>
242
 </tr>
241
 <tr>
243
 <tr>
242
    <th colspan="4">
244
    <th colspan=\"4\">
243
        Received with thanks from  [% patron.firstname | html %] [% patron.surname | html %] <br />
245
        Received with thanks from  [% credit.patron.firstname | html %] [% credit.patron.surname | html %] <br />
244
        Card number: [% patron.cardnumber | html %]<br />
246
        Card number: [% credit.patron.cardnumber | html %]<br />
245
    </th>
247
    </th>
246
 </tr>
248
 </tr>
247
  <tr>
249
  <tr>
Lines 251-327 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
251
    <th>Amount</th>
253
    <th>Amount</th>
252
 </tr>
254
 </tr>
253
255
254
  [% FOREACH account IN accounts %]
256
 <tr class=\"highlight\">
255
    <tr class="highlight">
257
    <td>[% credit.date | $KohaDates %]</td>
256
      <td>[% account.date | $KohaDates %]</td>
258
    <td>
257
      <td>
259
      [% PROCESS account_type_description account=credit %]
258
        [% PROCESS account_type_description account=account %]
260
      [%- IF credit.description %], [% credit.description | html %][% END %]
259
        [%- IF account.description %], [% account.description | html %][% END %]
261
    </td>
260
      </td>
262
    <td>[% credit.note | html %]</td>
261
      <td>[% account.note | html %]</td>
263
    <td class=\"credit\">[% credit.amount | $Price %]</td>
262
      [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td>
264
 </tr>
263
    </tr>
265
266
[% IF ( tendered ) %]
267
  <tr>
268
    <td colspan=\"3\">Amount tendered: </td>
269
    <td>[% tendered | $Price %]</td>
270
  </tr>
271
  <tr>
272
    <td colspan=\"3\">Change given: </td>
273
    <td>[% change | $Price %]</td>
274
  </tr>
275
[% END %]
264
276
265
  [% END %]
266
<tfoot>
277
<tfoot>
267
  <tr>
278
  <tr>
268
    <td colspan="3">Total outstanding dues as on date: </td>
279
    <td colspan=\"3\">Total outstanding dues as on date: </td>
269
    [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
280
    [% IF ( credit.patron.account.balance >= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% credit.patron.account.balance | $Price %]</td>
270
  </tr>
281
  </tr>
271
</tfoot>
282
</tfoot>
272
</table>', 'print', 'default');
283
</table>', 'print', 'default');
273
284
274
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
285
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
275
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table>
286
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '[% USE Price %]
287
[% PROCESS \"accounts.inc\" %]
288
<table>
276
  [% IF ( LibraryName ) %]
289
  [% IF ( LibraryName ) %]
277
    <tr>
290
    <tr>
278
      <th colspan="5" class="centerednames">
291
      <th colspan=\"5\" class=\"centerednames\">
279
        <h3>[% LibraryName | html %]</h3>
292
        <h3>[% LibraryName | html %]</h3>
280
      </th>
293
      </th>
281
    </tr>
294
    </tr>
282
  [% END %]
295
  [% END %]
283
296
284
  <tr>
297
  <tr>
285
    <th colspan="5" class="centerednames">
298
    <th colspan=\"5\" class=\"centerednames\">
286
      <h2><u>INVOICE</u></h2>
299
      <h2><u>INVOICE</u></h2>
287
    </th>
300
    </th>
288
  </tr>
301
  </tr>
289
  <tr>
302
  <tr>
290
    <th colspan="5" class="centerednames">
303
    <th colspan=\"5\" class=\"centerednames\">
291
      <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2>
304
      <h2>[% Branches.GetName( debit.patron.branchcode ) | html %]</h2>
292
    </th>
305
    </th>
293
  </tr>
306
  </tr>
294
  <tr>
307
  <tr>
295
    <th colspan="5" >
308
    <th colspan=\"5\" >
296
      Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br />
309
      Bill to: [% debit.patron.firstname | html %] [% debit.patron.surname | html %] <br />
297
      Card number: [% patron.cardnumber | html %]<br />
310
      Card number: [% debit.patron.cardnumber | html %]<br />
298
    </th>
311
    </th>
299
  </tr>
312
  </tr>
300
  <tr>
313
  <tr>
301
    <th>Date</th>
314
    <th>Date</th>
302
    <th>Description of charges</th>
315
    <th>Description of charges</th>
303
    <th>Note</th>
316
    <th>Note</th>
304
    <th style="text-align:right;">Amount</th>
317
    <th style=\"text-align:right;\">Amount</th>
305
    <th style="text-align:right;">Amount outstanding</th>
318
    <th style=\"text-align:right;\">Amount outstanding</th>
306
  </tr>
319
  </tr>
307
320
308
  [% FOREACH account IN accounts %]
321
  <tr class=\"highlight\">
309
    <tr class="highlight">
322
    <td>[% debit.date | $KohaDates%]</td>
310
      <td>[% account.date | $KohaDates%]</td>
323
    <td>
311
      <td>
324
      [% PROCESS account_type_description account=debit %]
312
        [% PROCESS account_type_description account=account %]
325
      [%- IF debit.description %], [% debit.description | html %][% END %]
313
        [%- IF account.description %], [% account.description | html %][% END %]
326
    </td>
314
      </td>
327
    <td>[% debit.note | html %]</td>
315
      <td>[% account.note | html %]</td>
328
    <td class=\"debit\">[% debit.amount | $Price %]</td>
316
      [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td>
329
    <td class=\"debit\">[% debit.amountoutstanding | $Price %]</td>
317
      [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td>
330
  </tr>
318
    </tr>
319
  [% END %]
320
331
321
  <tfoot>
332
  <tfoot>
322
    <tr>
333
    <tr>
323
      <td colspan="4">Total outstanding dues as on date: </td>
334
      <td colspan=\"4\">Total outstanding dues as on date: </td>
324
      [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
335
      [% IF ( debit.patron.account.balance <= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% debit.patron.account.balance | $Price %]</td>
325
    </tr>
336
    </tr>
326
  </tfoot>
337
  </tfoot>
327
</table>', 'print', 'default');
338
</table>', 'print', 'default');
(-)a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql (-45 / +56 lines)
Lines 222-249 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
222
('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 | $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 | $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');
222
('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 | $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 | $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');
223
223
224
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
224
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
225
('circulation', 'ACCOUNT_CREDIT', '', 'Account payment', 0, 'Account payment', '<table>
225
('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '[% USE Price %]
226
[% PROCESS \"accounts.inc\" %]
227
<table>
226
[% IF ( LibraryName ) %]
228
[% IF ( LibraryName ) %]
227
 <tr>
229
 <tr>
228
    <th colspan="4" class="centerednames">
230
    <th colspan=\"4\" class=\"centerednames\">
229
        <h3>[% LibraryName | html %]</h3>
231
        <h3>[% LibraryName | html %]</h3>
230
    </th>
232
    </th>
231
 </tr>
233
 </tr>
232
[% END %]
234
[% END %]
233
 <tr>
235
 <tr>
234
    <th colspan="4" class="centerednames">
236
    <th colspan=\"4\" class=\"centerednames\">
235
        <h2><u>Fee receipt</u></h2>
237
        <h2><u>Fee receipt</u></h2>
236
    </th>
238
    </th>
237
 </tr>
239
 </tr>
238
 <tr>
240
 <tr>
239
    <th colspan="4" class="centerednames">
241
    <th colspan=\"4\" class=\"centerednames\">
240
        <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2>
242
        <h2>[% Branches.GetName( credit.patron.branchcode ) | html %]</h2>
241
    </th>
243
    </th>
242
 </tr>
244
 </tr>
243
 <tr>
245
 <tr>
244
    <th colspan="4">
246
    <th colspan=\"4\">
245
        Received with thanks from  [% patron.firstname | html %] [% patron.surname | html %] <br />
247
        Received with thanks from  [% credit.patron.firstname | html %] [% credit.patron.surname | html %] <br />
246
        Card number: [% patron.cardnumber | html %]<br />
248
        Card number: [% credit.patron.cardnumber | html %]<br />
247
    </th>
249
    </th>
248
 </tr>
250
 </tr>
249
  <tr>
251
  <tr>
Lines 253-329 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
253
    <th>Amount</th>
255
    <th>Amount</th>
254
 </tr>
256
 </tr>
255
257
256
  [% FOREACH account IN accounts %]
258
 <tr class=\"highlight\">
257
    <tr class="highlight">
259
    <td>[% credit.date | $KohaDates %]</td>
258
      <td>[% account.date | $KohaDates %]</td>
260
    <td>
259
      <td>
261
      [% PROCESS account_type_description account=credit %]
260
        [% PROCESS account_type_description account=account %]
262
      [%- IF credit.description %], [% credit.description | html %][% END %]
261
        [%- IF account.description %], [% account.description | html %][% END %]
263
    </td>
262
      </td>
264
    <td>[% credit.note | html %]</td>
263
      <td>[% account.note | html %]</td>
265
    <td class=\"credit\">[% credit.amount | $Price %]</td>
264
      [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td>
266
 </tr>
265
    </tr>
267
268
[% IF ( tendered ) %]
269
  <tr>
270
    <td colspan=\"3\">Amount tendered: </td>
271
    <td>[% tendered | $Price %]</td>
272
  </tr>
273
  <tr>
274
    <td colspan=\"3\">Change given: </td>
275
    <td>[% change | $Price %]</td>
276
  </tr>
277
[% END %]
266
278
267
  [% END %]
268
<tfoot>
279
<tfoot>
269
  <tr>
280
  <tr>
270
    <td colspan="3">Total outstanding dues as on date: </td>
281
    <td colspan=\"3\">Total outstanding dues as on date: </td>
271
    [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
282
    [% IF ( credit.patron.account.balance >= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% credit.patron.account.balance | $Price %]</td>
272
  </tr>
283
  </tr>
273
</tfoot>
284
</tfoot>
274
</table>', 'print', 'default');
285
</table>', 'print', 'default');
275
286
276
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
287
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
277
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table>
288
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '[% USE Price %]
289
[% PROCESS \"accounts.inc\" %]
290
<table>
278
  [% IF ( LibraryName ) %]
291
  [% IF ( LibraryName ) %]
279
    <tr>
292
    <tr>
280
      <th colspan="5" class="centerednames">
293
      <th colspan=\"5\" class=\"centerednames\">
281
        <h3>[% LibraryName | html %]</h3>
294
        <h3>[% LibraryName | html %]</h3>
282
      </th>
295
      </th>
283
    </tr>
296
    </tr>
284
  [% END %]
297
  [% END %]
285
298
286
  <tr>
299
  <tr>
287
    <th colspan="5" class="centerednames">
300
    <th colspan=\"5\" class=\"centerednames\">
288
      <h2><u>INVOICE</u></h2>
301
      <h2><u>INVOICE</u></h2>
289
    </th>
302
    </th>
290
  </tr>
303
  </tr>
291
  <tr>
304
  <tr>
292
    <th colspan="5" class="centerednames">
305
    <th colspan=\"5\" class=\"centerednames\">
293
      <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2>
306
      <h2>[% Branches.GetName( debit.patron.branchcode ) | html %]</h2>
294
    </th>
307
    </th>
295
  </tr>
308
  </tr>
296
  <tr>
309
  <tr>
297
    <th colspan="5" >
310
    <th colspan=\"5\" >
298
      Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br />
311
      Bill to: [% debit.patron.firstname | html %] [% debit.patron.surname | html %] <br />
299
      Card number: [% patron.cardnumber | html %]<br />
312
      Card number: [% debit.patron.cardnumber | html %]<br />
300
    </th>
313
    </th>
301
  </tr>
314
  </tr>
302
  <tr>
315
  <tr>
303
    <th>Date</th>
316
    <th>Date</th>
304
    <th>Description of charges</th>
317
    <th>Description of charges</th>
305
    <th>Note</th>
318
    <th>Note</th>
306
    <th style="text-align:right;">Amount</th>
319
    <th style=\"text-align:right;\">Amount</th>
307
    <th style="text-align:right;">Amount outstanding</th>
320
    <th style=\"text-align:right;\">Amount outstanding</th>
308
  </tr>
321
  </tr>
309
322
310
  [% FOREACH account IN accounts %]
323
  <tr class=\"highlight\">
311
    <tr class="highlight">
324
    <td>[% debit.date | $KohaDates%]</td>
312
      <td>[% account.date | $KohaDates%]</td>
325
    <td>
313
      <td>
326
      [% PROCESS account_type_description account=debit %]
314
        [% PROCESS account_type_description account=account %]
327
      [%- IF debit.description %], [% debit.description | html %][% END %]
315
        [%- IF account.description %], [% account.description | html %][% END %]
328
    </td>
316
      </td>
329
    <td>[% debit.note | html %]</td>
317
      <td>[% account.note | html %]</td>
330
    <td class=\"debit\">[% debit.amount | $Price %]</td>
318
      [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td>
331
    <td class=\"debit\">[% debit.amountoutstanding | $Price %]</td>
319
      [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td>
332
  </tr>
320
    </tr>
321
  [% END %]
322
333
323
  <tfoot>
334
  <tfoot>
324
    <tr>
335
    <tr>
325
      <td colspan="4">Total outstanding dues as on date: </td>
336
      <td colspan=\"4\">Total outstanding dues as on date: </td>
326
      [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
337
      [% IF ( debit.patron.account.balance <= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% debit.patron.account.balance | $Price %]</td>
327
    </tr>
338
    </tr>
328
  </tfoot>
339
  </tfoot>
329
</table>', 'print', 'default');
340
</table>', 'print', 'default');
(-)a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql (-46 / +56 lines)
Lines 316-343 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
316
('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 | $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 | $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');
316
('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 | $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 | $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');
317
317
318
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
318
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
319
('circulation', 'ACCOUNT_CREDIT', '', 'Account payment', 0, 'Account payment', '<table>
319
('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '[% USE Price %]
320
[% PROCESS \"accounts.inc\" %]
321
<table>
320
[% IF ( LibraryName ) %]
322
[% IF ( LibraryName ) %]
321
 <tr>
323
 <tr>
322
    <th colspan="4" class="centerednames">
324
    <th colspan=\"4\" class=\"centerednames\">
323
        <h3>[% LibraryName | html %]</h3>
325
        <h3>[% LibraryName | html %]</h3>
324
    </th>
326
    </th>
325
 </tr>
327
 </tr>
326
[% END %]
328
[% END %]
327
 <tr>
329
 <tr>
328
    <th colspan="4" class="centerednames">
330
    <th colspan=\"4\" class=\"centerednames\">
329
        <h2><u>Fee receipt</u></h2>
331
        <h2><u>Fee receipt</u></h2>
330
    </th>
332
    </th>
331
 </tr>
333
 </tr>
332
 <tr>
334
 <tr>
333
    <th colspan="4" class="centerednames">
335
    <th colspan=\"4\" class=\"centerednames\">
334
        <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2>
336
        <h2>[% Branches.GetName( credit.patron.branchcode ) | html %]</h2>
335
    </th>
337
    </th>
336
 </tr>
338
 </tr>
337
 <tr>
339
 <tr>
338
    <th colspan="4">
340
    <th colspan=\"4\">
339
        Received with thanks from  [% patron.firstname | html %] [% patron.surname | html %] <br />
341
        Received with thanks from  [% credit.patron.firstname | html %] [% credit.patron.surname | html %] <br />
340
        Card number: [% patron.cardnumber | html %]<br />
342
        Card number: [% credit.patron.cardnumber | html %]<br />
341
    </th>
343
    </th>
342
 </tr>
344
 </tr>
343
  <tr>
345
  <tr>
Lines 347-423 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
347
    <th>Amount</th>
349
    <th>Amount</th>
348
 </tr>
350
 </tr>
349
351
350
  [% FOREACH account IN accounts %]
352
 <tr class=\"highlight\">
351
    <tr class="highlight">
353
    <td>[% credit.date | $KohaDates %]</td>
352
      <td>[% account.date | $KohaDates %]</td>
354
    <td>
353
      <td>
355
      [% PROCESS account_type_description account=credit %]
354
        [% PROCESS account_type_description account=account %]
356
      [%- IF credit.description %], [% credit.description | html %][% END %]
355
        [%- IF account.description %], [% account.description | html %][% END %]
357
    </td>
356
      </td>
358
    <td>[% credit.note | html %]</td>
357
      <td>[% account.note | html %]</td>
359
    <td class=\"credit\">[% credit.amount | $Price %]</td>
358
      [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td>
360
 </tr>
359
    </tr>
361
362
[% IF ( tendered ) %]
363
  <tr>
364
    <td colspan=\"3\">Amount tendered: </td>
365
    <td>[% tendered | $Price %]</td>
366
  </tr>
367
  <tr>
368
    <td colspan=\"3\">Change given: </td>
369
    <td>[% change | $Price %]</td>
370
  </tr>
371
[% END %]
360
372
361
  [% END %]
362
<tfoot>
373
<tfoot>
363
  <tr>
374
  <tr>
364
    <td colspan="3">Total outstanding dues as on date: </td>
375
    <td colspan=\"3\">Total outstanding dues as on date: </td>
365
    [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
376
    [% IF ( credit.patron.account.balance >= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% credit.patron.account.balance | $Price %]</td>
366
  </tr>
377
  </tr>
367
</tfoot>
378
</tfoot>
368
</table>', 'print', 'default');
379
</table>', 'print', 'default');
369
380
370
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
381
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
371
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table>
382
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '[% USE Price %]
383
[% PROCESS \"accounts.inc\" %]
384
<table>
372
  [% IF ( LibraryName ) %]
385
  [% IF ( LibraryName ) %]
373
    <tr>
386
    <tr>
374
      <th colspan="5" class="centerednames">
387
      <th colspan=\"5\" class=\"centerednames\">
375
        <h3>[% LibraryName | html %]</h3>
388
        <h3>[% LibraryName | html %]</h3>
376
      </th>
389
      </th>
377
    </tr>
390
    </tr>
378
  [% END %]
391
  [% END %]
379
392
380
  <tr>
393
  <tr>
381
    <th colspan="5" class="centerednames">
394
    <th colspan=\"5\" class=\"centerednames\">
382
      <h2><u>INVOICE</u></h2>
395
      <h2><u>INVOICE</u></h2>
383
    </th>
396
    </th>
384
  </tr>
397
  </tr>
385
  <tr>
398
  <tr>
386
    <th colspan="5" class="centerednames">
399
    <th colspan=\"5\" class=\"centerednames\">
387
      <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2>
400
      <h2>[% Branches.GetName( debit.patron.branchcode ) | html %]</h2>
388
    </th>
401
    </th>
389
  </tr>
402
  </tr>
390
  <tr>
403
  <tr>
391
    <th colspan="5" >
404
    <th colspan=\"5\" >
392
      Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br />
405
      Bill to: [% debit.patron.firstname | html %] [% debit.patron.surname | html %] <br />
393
      Card number: [% patron.cardnumber | html %]<br />
406
      Card number: [% debit.patron.cardnumber | html %]<br />
394
    </th>
407
    </th>
395
  </tr>
408
  </tr>
396
  <tr>
409
  <tr>
397
    <th>Date</th>
410
    <th>Date</th>
398
    <th>Description of charges</th>
411
    <th>Description of charges</th>
399
    <th>Note</th>
412
    <th>Note</th>
400
    <th style="text-align:right;">Amount</th>
413
    <th style=\"text-align:right;\">Amount</th>
401
    <th style="text-align:right;">Amount outstanding</th>
414
    <th style=\"text-align:right;\">Amount outstanding</th>
402
  </tr>
415
  </tr>
403
416
404
  [% FOREACH account IN accounts %]
417
  <tr class=\"highlight\">
405
    <tr class="highlight">
418
    <td>[% debit.date | $KohaDates%]</td>
406
      <td>[% account.date | $KohaDates%]</td>
419
    <td>
407
      <td>
420
      [% PROCESS account_type_description account=debit %]
408
        [% PROCESS account_type_description account=account %]
421
      [%- IF debit.description %], [% debit.description | html %][% END %]
409
        [%- IF account.description %], [% account.description | html %][% END %]
422
    </td>
410
      </td>
423
    <td>[% debit.note | html %]</td>
411
      <td>[% account.note | html %]</td>
424
    <td class=\"debit\">[% debit.amount | $Price %]</td>
412
      [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td>
425
    <td class=\"debit\">[% debit.amountoutstanding | $Price %]</td>
413
      [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td>
426
  </tr>
414
    </tr>
415
  [% END %]
416
427
417
  <tfoot>
428
  <tfoot>
418
    <tr>
429
    <tr>
419
      <td colspan="4">Total outstanding dues as on date: </td>
430
      <td colspan=\"4\">Total outstanding dues as on date: </td>
420
      [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
431
      [% IF ( debit.patron.account.balance <= 0 ) %]<td class=\"credit\">[% ELSE %]<td class=\"debit\">[% END %][% debit.patron.account.balance | $Price %]</td>
421
    </tr>
432
    </tr>
422
  </tfoot>
433
  </tfoot>
423
</table>', 'print', 'default');
434
</table>', 'print', 'default');
424
- 

Return to bug 26734