Bugzilla – Attachment 89231 Details for
Bug 22809
Move "INVOICE" from template to a slip
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 22809: (QA follow-up) Add notice translations
Bug-22809-QA-follow-up-Add-notice-translations.patch (text/plain), 28.96 KB, created by
Martin Renvoize (ashimema)
on 2019-05-02 11:45:57 UTC
(
hide
)
Description:
Bug 22809: (QA follow-up) Add notice translations
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2019-05-02 11:45:57 UTC
Size:
28.96 KB
patch
obsolete
>From 463e8b978c5f0de1eb07b3098bbd7180b41d06e1 Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Date: Thu, 2 May 2019 12:44:05 +0100 >Subject: [PATCH] Bug 22809: (QA follow-up) Add notice translations > >Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> >--- > .../mysql/de-DE/mandatory/sample_notices.sql | 55 +++++++++++++++++++ > .../mysql/es-ES/mandatory/sample_notices.sql | 55 +++++++++++++++++++ > .../fr-CA/obligatoire/sample_notices.sql | 55 +++++++++++++++++++ > .../fr-FR/1-Obligatoire/sample_notices.sql | 55 +++++++++++++++++++ > .../data/mysql/it-IT/necessari/notices.sql | 55 +++++++++++++++++++ > .../nb-NO/1-Obligatorisk/sample_notices.sql | 55 +++++++++++++++++++ > .../mysql/pl-PL/mandatory/sample_notices.sql | 55 +++++++++++++++++++ > .../mysql/ru-RU/mandatory/sample_notices.sql | 55 +++++++++++++++++++ > .../mysql/uk-UA/mandatory/sample_notices.sql | 55 +++++++++++++++++++ > 9 files changed, 495 insertions(+) > >diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices.sql b/installer/data/mysql/de-DE/mandatory/sample_notices.sql >index a7a7aba7ce..6f0883be25 100644 >--- a/installer/data/mysql/de-DE/mandatory/sample_notices.sql >+++ b/installer/data/mysql/de-DE/mandatory/sample_notices.sql >@@ -235,5 +235,60 @@ INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` > </tfoot> > </table>', 'print', 'default'); > >+INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES >+('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table> >+ [% IF ( LibraryName ) %] >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h3>[% LibraryName | html %]</h3> >+ </th> >+ </tr> >+ [% END %] >+ >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h2><u>INVOICE</u></h2> >+ </th> >+ </tr> >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2> >+ </th> >+ </tr> >+ <tr> >+ <th colspan="5" > >+ Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br /> >+ Card number: [% patron.cardnumber | html %]<br /> >+ </th> >+ </tr> >+ <tr> >+ <th>Date</th> >+ <th>Description of charges</th> >+ <th>Note</th> >+ <th style="text-align:right;">Amount</th> >+ <th style="text-align:right;">Amount outstanding</th> >+ </tr> >+ >+ [% FOREACH account IN accounts %] >+ <tr class="highlight"> >+ <td>[% account.date | $KohaDates%]</td> >+ <td> >+ [% PROCESS account_type_description account=account %] >+ [%- IF account.description %], [% account.description | html %][% END %] >+ </td> >+ <td>[% account.note | html %]</td> >+ [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td> >+ [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td> >+ </tr> >+ [% END %] >+ >+ <tfoot> >+ <tr> >+ <td colspan="4">Total outstanding dues as on date: </td> >+ [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td> >+ </tr> >+ </tfoot> >+</table>', 'print', 'default'); >+ > INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES > ('circulation', 'SR_SLIP', '', 'Report über Bestandsrotation', 0, 'Report über Bestandsrotation', 'Report über Bestandsrotation für [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] Exemplare wurden für diese Bibliothek bearbeitet.\r\n[% ELSE %]Es wurden keine Exemplare für diese Bibliothek bearbeitet\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Titel: [% item.title %]\r\nVerfasser: [% item.author %]\r\nSignatur: [% item.callnumber %]\r\nStandort: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nAusgeliehen?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nAktuelle Bibliothek: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email'); >diff --git a/installer/data/mysql/es-ES/mandatory/sample_notices.sql b/installer/data/mysql/es-ES/mandatory/sample_notices.sql >index 0e5c6e8c0a..d3d4cb9e25 100644 >--- a/installer/data/mysql/es-ES/mandatory/sample_notices.sql >+++ b/installer/data/mysql/es-ES/mandatory/sample_notices.sql >@@ -228,5 +228,60 @@ INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` > </tfoot> > </table>', 'print', 'default'); > >+INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES >+('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table> >+ [% IF ( LibraryName ) %] >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h3>[% LibraryName | html %]</h3> >+ </th> >+ </tr> >+ [% END %] >+ >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h2><u>INVOICE</u></h2> >+ </th> >+ </tr> >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2> >+ </th> >+ </tr> >+ <tr> >+ <th colspan="5" > >+ Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br /> >+ Card number: [% patron.cardnumber | html %]<br /> >+ </th> >+ </tr> >+ <tr> >+ <th>Date</th> >+ <th>Description of charges</th> >+ <th>Note</th> >+ <th style="text-align:right;">Amount</th> >+ <th style="text-align:right;">Amount outstanding</th> >+ </tr> >+ >+ [% FOREACH account IN accounts %] >+ <tr class="highlight"> >+ <td>[% account.date | $KohaDates%]</td> >+ <td> >+ [% PROCESS account_type_description account=account %] >+ [%- IF account.description %], [% account.description | html %][% END %] >+ </td> >+ <td>[% account.note | html %]</td> >+ [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td> >+ [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td> >+ </tr> >+ [% END %] >+ >+ <tfoot> >+ <tr> >+ <td colspan="4">Total outstanding dues as on date: </td> >+ [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td> >+ </tr> >+ </tfoot> >+</table>', 'print', 'default'); >+ > INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES > ('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'); >diff --git a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql b/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql >index eef3f0fe79..37a0dfd114 100644 >--- a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql >+++ b/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql >@@ -116,5 +116,60 @@ INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` > </tfoot> > </table>', 'print', 'default'); > >+INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES >+('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table> >+ [% IF ( LibraryName ) %] >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h3>[% LibraryName | html %]</h3> >+ </th> >+ </tr> >+ [% END %] >+ >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h2><u>INVOICE</u></h2> >+ </th> >+ </tr> >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2> >+ </th> >+ </tr> >+ <tr> >+ <th colspan="5" > >+ Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br /> >+ Card number: [% patron.cardnumber | html %]<br /> >+ </th> >+ </tr> >+ <tr> >+ <th>Date</th> >+ <th>Description of charges</th> >+ <th>Note</th> >+ <th style="text-align:right;">Amount</th> >+ <th style="text-align:right;">Amount outstanding</th> >+ </tr> >+ >+ [% FOREACH account IN accounts %] >+ <tr class="highlight"> >+ <td>[% account.date | $KohaDates%]</td> >+ <td> >+ [% PROCESS account_type_description account=account %] >+ [%- IF account.description %], [% account.description | html %][% END %] >+ </td> >+ <td>[% account.note | html %]</td> >+ [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td> >+ [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td> >+ </tr> >+ [% END %] >+ >+ <tfoot> >+ <tr> >+ <td colspan="4">Total outstanding dues as on date: </td> >+ [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td> >+ </tr> >+ </tfoot> >+</table>', 'print', 'default'); >+ > INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES > ('circulation', 'SR_SLIP', '', 'Ticket de rotation automatique d\'exemplaires', 0, 'Rapport de rotation automatique d\'exemplaires', 'Rapport de rotation automatique d\'exemplaires pour [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] exemplaires de cette bibliothèque à traiter.\r\n[% ELSE %]Aucun exemplaire de cette bibliothèque à traiter\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Titre : [% item.title %]\r\nAuteur : [% item.author %]\r\nCote : [% item.callnumber %]\r\nLocalisation : [% item.location %]\r\nCode-barres: [% item.barcode %]\r\nEn prêt? : [% item.onloan %]\r\nStatut : [% item.reason %]\r\nBibliothèque dépositaire : [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email'); >diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql >index 9f7fe4d215..b30740b800 100644 >--- a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql >+++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql >@@ -229,5 +229,60 @@ INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` > </tfoot> > </table>', 'print', 'default'); > >+INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES >+('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table> >+ [% IF ( LibraryName ) %] >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h3>[% LibraryName | html %]</h3> >+ </th> >+ </tr> >+ [% END %] >+ >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h2><u>INVOICE</u></h2> >+ </th> >+ </tr> >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2> >+ </th> >+ </tr> >+ <tr> >+ <th colspan="5" > >+ Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br /> >+ Card number: [% patron.cardnumber | html %]<br /> >+ </th> >+ </tr> >+ <tr> >+ <th>Date</th> >+ <th>Description of charges</th> >+ <th>Note</th> >+ <th style="text-align:right;">Amount</th> >+ <th style="text-align:right;">Amount outstanding</th> >+ </tr> >+ >+ [% FOREACH account IN accounts %] >+ <tr class="highlight"> >+ <td>[% account.date | $KohaDates%]</td> >+ <td> >+ [% PROCESS account_type_description account=account %] >+ [%- IF account.description %], [% account.description | html %][% END %] >+ </td> >+ <td>[% account.note | html %]</td> >+ [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td> >+ [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td> >+ </tr> >+ [% END %] >+ >+ <tfoot> >+ <tr> >+ <td colspan="4">Total outstanding dues as on date: </td> >+ [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td> >+ </tr> >+ </tfoot> >+</table>', 'print', 'default'); >+ > INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES > ('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'); >diff --git a/installer/data/mysql/it-IT/necessari/notices.sql b/installer/data/mysql/it-IT/necessari/notices.sql >index bd7d9d78a1..7684e2230a 100644 >--- a/installer/data/mysql/it-IT/necessari/notices.sql >+++ b/installer/data/mysql/it-IT/necessari/notices.sql >@@ -231,5 +231,60 @@ INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` > </tfoot> > </table>', 'print', 'default'); > >+INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES >+('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table> >+ [% IF ( LibraryName ) %] >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h3>[% LibraryName | html %]</h3> >+ </th> >+ </tr> >+ [% END %] >+ >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h2><u>INVOICE</u></h2> >+ </th> >+ </tr> >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2> >+ </th> >+ </tr> >+ <tr> >+ <th colspan="5" > >+ Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br /> >+ Card number: [% patron.cardnumber | html %]<br /> >+ </th> >+ </tr> >+ <tr> >+ <th>Date</th> >+ <th>Description of charges</th> >+ <th>Note</th> >+ <th style="text-align:right;">Amount</th> >+ <th style="text-align:right;">Amount outstanding</th> >+ </tr> >+ >+ [% FOREACH account IN accounts %] >+ <tr class="highlight"> >+ <td>[% account.date | $KohaDates%]</td> >+ <td> >+ [% PROCESS account_type_description account=account %] >+ [%- IF account.description %], [% account.description | html %][% END %] >+ </td> >+ <td>[% account.note | html %]</td> >+ [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td> >+ [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td> >+ </tr> >+ [% END %] >+ >+ <tfoot> >+ <tr> >+ <td colspan="4">Total outstanding dues as on date: </td> >+ [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td> >+ </tr> >+ </tfoot> >+</table>', 'print', 'default'); >+ > INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES > ('circulation', 'SR_SLIP', '', 'Stock Rotation Slip', 0, 'Stockrotation Report', 'Stockrotation 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'); >diff --git a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql >index b8c25c4329..5674f74b5e 100644 >--- a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql >+++ b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql >@@ -248,5 +248,60 @@ INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` > </tfoot> > </table>', 'print', 'default'); > >+INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES >+('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table> >+ [% IF ( LibraryName ) %] >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h3>[% LibraryName | html %]</h3> >+ </th> >+ </tr> >+ [% END %] >+ >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h2><u>INVOICE</u></h2> >+ </th> >+ </tr> >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2> >+ </th> >+ </tr> >+ <tr> >+ <th colspan="5" > >+ Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br /> >+ Card number: [% patron.cardnumber | html %]<br /> >+ </th> >+ </tr> >+ <tr> >+ <th>Date</th> >+ <th>Description of charges</th> >+ <th>Note</th> >+ <th style="text-align:right;">Amount</th> >+ <th style="text-align:right;">Amount outstanding</th> >+ </tr> >+ >+ [% FOREACH account IN accounts %] >+ <tr class="highlight"> >+ <td>[% account.date | $KohaDates%]</td> >+ <td> >+ [% PROCESS account_type_description account=account %] >+ [%- IF account.description %], [% account.description | html %][% END %] >+ </td> >+ <td>[% account.note | html %]</td> >+ [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td> >+ [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td> >+ </tr> >+ [% END %] >+ >+ <tfoot> >+ <tr> >+ <td colspan="4">Total outstanding dues as on date: </td> >+ [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td> >+ </tr> >+ </tfoot> >+</table>', 'print', 'default'); >+ > INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES > ('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'); >diff --git a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql >index f0759de115..cd55d8bf5b 100644 >--- a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql >+++ b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql >@@ -226,5 +226,60 @@ INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` > </tfoot> > </table>', 'print', 'default'); > >+INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES >+('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table> >+ [% IF ( LibraryName ) %] >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h3>[% LibraryName | html %]</h3> >+ </th> >+ </tr> >+ [% END %] >+ >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h2><u>INVOICE</u></h2> >+ </th> >+ </tr> >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2> >+ </th> >+ </tr> >+ <tr> >+ <th colspan="5" > >+ Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br /> >+ Card number: [% patron.cardnumber | html %]<br /> >+ </th> >+ </tr> >+ <tr> >+ <th>Date</th> >+ <th>Description of charges</th> >+ <th>Note</th> >+ <th style="text-align:right;">Amount</th> >+ <th style="text-align:right;">Amount outstanding</th> >+ </tr> >+ >+ [% FOREACH account IN accounts %] >+ <tr class="highlight"> >+ <td>[% account.date | $KohaDates%]</td> >+ <td> >+ [% PROCESS account_type_description account=account %] >+ [%- IF account.description %], [% account.description | html %][% END %] >+ </td> >+ <td>[% account.note | html %]</td> >+ [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td> >+ [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td> >+ </tr> >+ [% END %] >+ >+ <tfoot> >+ <tr> >+ <td colspan="4">Total outstanding dues as on date: </td> >+ [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td> >+ </tr> >+ </tfoot> >+</table>', 'print', 'default'); >+ > INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES > ('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'); >diff --git a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql >index 6121df763c..1a85fb119c 100644 >--- a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql >+++ b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql >@@ -228,5 +228,60 @@ INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` > </tfoot> > </table>', 'print', 'default'); > >+INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES >+('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table> >+ [% IF ( LibraryName ) %] >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h3>[% LibraryName | html %]</h3> >+ </th> >+ </tr> >+ [% END %] >+ >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h2><u>INVOICE</u></h2> >+ </th> >+ </tr> >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2> >+ </th> >+ </tr> >+ <tr> >+ <th colspan="5" > >+ Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br /> >+ Card number: [% patron.cardnumber | html %]<br /> >+ </th> >+ </tr> >+ <tr> >+ <th>Date</th> >+ <th>Description of charges</th> >+ <th>Note</th> >+ <th style="text-align:right;">Amount</th> >+ <th style="text-align:right;">Amount outstanding</th> >+ </tr> >+ >+ [% FOREACH account IN accounts %] >+ <tr class="highlight"> >+ <td>[% account.date | $KohaDates%]</td> >+ <td> >+ [% PROCESS account_type_description account=account %] >+ [%- IF account.description %], [% account.description | html %][% END %] >+ </td> >+ <td>[% account.note | html %]</td> >+ [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td> >+ [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td> >+ </tr> >+ [% END %] >+ >+ <tfoot> >+ <tr> >+ <td colspan="4">Total outstanding dues as on date: </td> >+ [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td> >+ </tr> >+ </tfoot> >+</table>', 'print', 'default'); >+ > INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES > ('circulation', 'SR_SLIP', '', 'Stock Rotation Slip', 0, 'Stockrotation Report', 'Stockrotation 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'); >diff --git a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql >index 5373fb1ce7..4cc4693faa 100644 >--- a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql >+++ b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql >@@ -318,5 +318,60 @@ INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` > </tfoot> > </table>', 'print', 'default'); > >+INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES >+('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table> >+ [% IF ( LibraryName ) %] >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h3>[% LibraryName | html %]</h3> >+ </th> >+ </tr> >+ [% END %] >+ >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h2><u>INVOICE</u></h2> >+ </th> >+ </tr> >+ <tr> >+ <th colspan="5" class="centerednames"> >+ <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2> >+ </th> >+ </tr> >+ <tr> >+ <th colspan="5" > >+ Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br /> >+ Card number: [% patron.cardnumber | html %]<br /> >+ </th> >+ </tr> >+ <tr> >+ <th>Date</th> >+ <th>Description of charges</th> >+ <th>Note</th> >+ <th style="text-align:right;">Amount</th> >+ <th style="text-align:right;">Amount outstanding</th> >+ </tr> >+ >+ [% FOREACH account IN accounts %] >+ <tr class="highlight"> >+ <td>[% account.date | $KohaDates%]</td> >+ <td> >+ [% PROCESS account_type_description account=account %] >+ [%- IF account.description %], [% account.description | html %][% END %] >+ </td> >+ <td>[% account.note | html %]</td> >+ [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td> >+ [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td> >+ </tr> >+ [% END %] >+ >+ <tfoot> >+ <tr> >+ <td colspan="4">Total outstanding dues as on date: </td> >+ [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td> >+ </tr> >+ </tfoot> >+</table>', 'print', 'default'); >+ > INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES > ('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'); >-- >2.20.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 22809
:
89115
|
89155
|
89156
|
89229
|
89230
| 89231