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'); |