|
Lines 315-318
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`,
Link Here
|
| 315 |
</table>', 'print', 'default'); |
315 |
</table>', 'print', 'default'); |
| 316 |
|
316 |
|
| 317 |
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES |
317 |
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES |
| 318 |
('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'); |
318 |
('circulation', 'SR_SLIP', '', 'Stock rotation slip', 0, 'Stock rotation report', 'Stockrotation report for [% name %]: |
|
|
319 |
|
| 320 |
[%- IF items.size -%] |
| 321 |
[% items.size %] items to be processed for this branch. |
| 322 |
[%- ELSE -%] |
| 323 |
No items to be processed for this branch |
| 324 |
[%- END -%] |
| 325 |
|
| 326 |
|
| 327 |
[%- FOREACH item IN items -%] |
| 328 |
[% IF item.reason != ''in-demand'' %] |
| 329 |
Title: [% item.title %] |
| 330 |
Author: [% item.author %] |
| 331 |
Callnumber: [% item.callnumber %] |
| 332 |
Location: [% item.location %] |
| 333 |
Barcode: [% item.barcode %] |
| 334 |
On loan?: [% item.onloan %] |
| 335 |
Status: [% item.reason %] |
| 336 |
Current Library: [% item.branch.branchname %] [% item.branch.branchcode %] |
| 337 |
[% END %] |
| 338 |
[%- END -%]', 'email'); |
| 319 |
- |
|
|