|
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 |