|
Lines 233-237
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`
Link Here
|
| 233 |
</tfoot> |
233 |
</tfoot> |
| 234 |
</table>', 'print', 'default'); |
234 |
</table>', 'print', 'default'); |
| 235 |
|
235 |
|
|
|
236 |
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES |
| 237 |
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table> |
| 238 |
[% IF ( LibraryName ) %] |
| 239 |
<tr> |
| 240 |
<th colspan="5" class="centerednames"> |
| 241 |
<h3>[% LibraryName | html %]</h3> |
| 242 |
</th> |
| 243 |
</tr> |
| 244 |
[% END %] |
| 245 |
|
| 246 |
<tr> |
| 247 |
<th colspan="5" class="centerednames"> |
| 248 |
<h2><u>INVOICE</u></h2> |
| 249 |
</th> |
| 250 |
</tr> |
| 251 |
<tr> |
| 252 |
<th colspan="5" class="centerednames"> |
| 253 |
<h2>[% Branches.GetName( patron.branchcode ) | html %]</h2> |
| 254 |
</th> |
| 255 |
</tr> |
| 256 |
<tr> |
| 257 |
<th colspan="5" > |
| 258 |
Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br /> |
| 259 |
Card number: [% patron.cardnumber | html %]<br /> |
| 260 |
</th> |
| 261 |
</tr> |
| 262 |
<tr> |
| 263 |
<th>Date</th> |
| 264 |
<th>Description of charges</th> |
| 265 |
<th>Note</th> |
| 266 |
<th style="text-align:right;">Amount</th> |
| 267 |
<th style="text-align:right;">Amount outstanding</th> |
| 268 |
</tr> |
| 269 |
|
| 270 |
[% FOREACH account IN accounts %] |
| 271 |
<tr class="highlight"> |
| 272 |
<td>[% account.date | $KohaDates%]</td> |
| 273 |
<td> |
| 274 |
[% PROCESS account_type_description account=account %] |
| 275 |
[%- IF account.description %], [% account.description | html %][% END %] |
| 276 |
</td> |
| 277 |
<td>[% account.note | html %]</td> |
| 278 |
[% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td> |
| 279 |
[% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td> |
| 280 |
</tr> |
| 281 |
[% END %] |
| 282 |
|
| 283 |
<tfoot> |
| 284 |
<tr> |
| 285 |
<td colspan="4">Total outstanding dues as on date: </td> |
| 286 |
[% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td> |
| 287 |
</tr> |
| 288 |
</tfoot> |
| 289 |
</table>', 'print', 'default'); |
| 290 |
|
| 236 |
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES |
291 |
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES |
| 237 |
('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'); |
292 |
('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'); |