|
Lines 176-184
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`
Link Here
|
| 176 |
('circulation', 'AR_SLIP', '', 'Article request - print slip', 0, 'Article request', 'Article request:\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nTitle: <<biblio.title>>\r\nBarcode: <<items.barcode>>\r\n\r\nArticle requested:\r\nTitle: <<article_requests.title>>\r\nAuthor: <<article_requests.author>>\r\nVolume: <<article_requests.volume>>\r\nIssue: <<article_requests.issue>>\r\nDate: <<article_requests.date>>\r\nPages: <<article_requests.pages>>\r\nChapters: <<article_requests.chapters>>\r\nNotes: <<article_requests.patron_notes>>\r\n', 'print'), |
176 |
('circulation', 'AR_SLIP', '', 'Article request - print slip', 0, 'Article request', 'Article request:\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nTitle: <<biblio.title>>\r\nBarcode: <<items.barcode>>\r\n\r\nArticle requested:\r\nTitle: <<article_requests.title>>\r\nAuthor: <<article_requests.author>>\r\nVolume: <<article_requests.volume>>\r\nIssue: <<article_requests.issue>>\r\nDate: <<article_requests.date>>\r\nPages: <<article_requests.pages>>\r\nChapters: <<article_requests.chapters>>\r\nNotes: <<article_requests.patron_notes>>\r\n', 'print'), |
| 177 |
('circulation', 'AR_PROCESSING', '', 'Article request - processing', 0, 'Article request processing', 'Dear <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nWe are now processing your request for an article from <<biblio.title>> (<<items.barcode>>).\r\n\r\nArticle requested:\r\nTitle: <<article_requests.title>>\r\nAuthor: <<article_requests.author>>\r\nVolume: <<article_requests.volume>>\r\nIssue: <<article_requests.issue>>\r\nDate: <<article_requests.date>>\r\nPages: <<article_requests.pages>>\r\nChapters: <<article_requests.chapters>>\r\nNotes: <<article_requests.patron_notes>>\r\n\r\nThank you!', 'email'), |
177 |
('circulation', 'AR_PROCESSING', '', 'Article request - processing', 0, 'Article request processing', 'Dear <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nWe are now processing your request for an article from <<biblio.title>> (<<items.barcode>>).\r\n\r\nArticle requested:\r\nTitle: <<article_requests.title>>\r\nAuthor: <<article_requests.author>>\r\nVolume: <<article_requests.volume>>\r\nIssue: <<article_requests.issue>>\r\nDate: <<article_requests.date>>\r\nPages: <<article_requests.pages>>\r\nChapters: <<article_requests.chapters>>\r\nNotes: <<article_requests.patron_notes>>\r\n\r\nThank you!', 'email'), |
| 178 |
('circulation', 'CHECKOUT_NOTE', '', 'Checkout note on item set by patron', '0', 'Checkout note', '<<borrowers.firstname>> <<borrowers.surname>> has added a note to the item <<biblio.title>> - <<biblio.author>> (<<biblio.biblionumber>>).','email'); |
178 |
('circulation', 'CHECKOUT_NOTE', '', 'Checkout note on item set by patron', '0', 'Checkout note', '<<borrowers.firstname>> <<borrowers.surname>> has added a note to the item <<biblio.title>> - <<biblio.author>> (<<biblio.biblionumber>>).','email'); |
| 179 |
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) |
179 |
|
| 180 |
VALUES |
180 |
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES |
| 181 |
('circulation', 'ACCOUNT_PAYMENT', '', 'Account payment', 0, 'Account payment', '[%- USE Price -%]\r\nA payment of [% credit.amount * -1 | $Price %] has been applied to your account.\r\n\r\nThis payment 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'), |
181 |
('circulation', 'ACCOUNT_PAYMENT', '', 'Account payment', 0, 'Account payment', '[%- USE Price -%]\r\nA payment of [% credit.amount * -1 | $Price %] has been applied to your account.\r\n\r\nThis payment 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'), |
| 182 |
('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'); |
182 |
('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'); |
|
|
183 |
|
| 184 |
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES |
| 185 |
('circulation', 'ACCOUNT_PAYMENT', '', 'Account payment', 0, 'Account payment', '<table> |
| 186 |
[% IF ( LibraryName ) %] |
| 187 |
<tr> |
| 188 |
<th colspan="4" class="centerednames"> |
| 189 |
<h3>[% LibraryName | html %]</h3> |
| 190 |
</th> |
| 191 |
</tr> |
| 192 |
[% END %] |
| 193 |
<tr> |
| 194 |
<th colspan="4" class="centerednames"> |
| 195 |
<h2><u>Fee receipt</u></h2> |
| 196 |
</th> |
| 197 |
</tr> |
| 198 |
<tr> |
| 199 |
<th colspan="4" class="centerednames"> |
| 200 |
<h2>[% Branches.GetName( patron.branchcode ) | html %]</h2> |
| 201 |
</th> |
| 202 |
</tr> |
| 203 |
<tr> |
| 204 |
<th colspan="4"> |
| 205 |
Received with thanks from [% patron.firstname | html %] [% patron.surname | html %] <br /> |
| 206 |
Card number: [% patron.cardnumber | html %]<br /> |
| 207 |
</th> |
| 208 |
</tr> |
| 209 |
<tr> |
| 210 |
<th>Date</th> |
| 211 |
<th>Description of charges</th> |
| 212 |
<th>Note</th> |
| 213 |
<th>Amount</th> |
| 214 |
</tr> |
| 215 |
|
| 216 |
[% FOREACH account IN accounts %] |
| 217 |
<tr class="highlight"> |
| 218 |
<td>[% account.date | $KohaDates %]</td> |
| 219 |
<td> |
| 220 |
[% PROCESS account_type_description account=account %] |
| 221 |
[%- IF account.description %], [% account.description | html %][% END %] |
| 222 |
</td> |
| 223 |
<td>[% account.note | html %]</td> |
| 224 |
[% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td> |
| 225 |
</tr> |
| 226 |
|
| 227 |
[% END %] |
| 228 |
<tfoot> |
| 229 |
<tr> |
| 230 |
<td colspan="3">Total outstanding dues as on date: </td> |
| 231 |
[% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td> |
| 232 |
</tr> |
| 233 |
</tfoot> |
| 234 |
</table>', 'print', 'default'), |
| 235 |
('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '<table> |
| 236 |
[% IF ( LibraryName ) %] |
| 237 |
<tr> |
| 238 |
<th colspan="4" class="centerednames"> |
| 239 |
<h3>[% LibraryName | html %]</h3> |
| 240 |
</th> |
| 241 |
</tr> |
| 242 |
[% END %] |
| 243 |
<tr> |
| 244 |
<th colspan="4" class="centerednames"> |
| 245 |
<h2><u>Fee receipt</u></h2> |
| 246 |
</th> |
| 247 |
</tr> |
| 248 |
<tr> |
| 249 |
<th colspan="4" class="centerednames"> |
| 250 |
<h2>[% Branches.GetName( patron.branchcode ) | html %]</h2> |
| 251 |
</th> |
| 252 |
</tr> |
| 253 |
<tr> |
| 254 |
<th colspan="4"> |
| 255 |
Received with thanks from [% patron.firstname | html %] [% patron.surname | html %] <br /> |
| 256 |
Card number: [% patron.cardnumber | html %]<br /> |
| 257 |
</th> |
| 258 |
</tr> |
| 259 |
<tr> |
| 260 |
<th>Date</th> |
| 261 |
<th>Description of charges</th> |
| 262 |
<th>Note</th> |
| 263 |
<th>Amount</th> |
| 264 |
</tr> |
| 265 |
|
| 266 |
[% FOREACH account IN accounts %] |
| 267 |
<tr class="highlight"> |
| 268 |
<td>[% account.date | $KohaDates %]</td> |
| 269 |
<td> |
| 270 |
[% PROCESS account_type_description account=account %] |
| 271 |
[%- IF account.description %], [% account.description | html %][% END %] |
| 272 |
</td> |
| 273 |
<td>[% account.note | html %]</td> |
| 274 |
[% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td> |
| 275 |
</tr> |
| 276 |
|
| 277 |
[% END %] |
| 278 |
<tfoot> |
| 279 |
<tr> |
| 280 |
<td colspan="3">Total outstanding dues as on date: </td> |
| 281 |
[% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td> |
| 282 |
</tr> |
| 283 |
</tfoot> |
| 284 |
</table>', 'print', 'default'); |
| 285 |
|
| 183 |
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES |
286 |
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES |
| 184 |
('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'); |
287 |
('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'); |
| 185 |
- |
|
|