View | Details | Raw Unified | Return to bug 22809
Collapse All | Expand All

(-)a/installer/data/mysql/de-DE/mandatory/sample_notices.sql (+55 lines)
Lines 235-239 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
235
</tfoot>
235
</tfoot>
236
</table>', 'print', 'default');
236
</table>', 'print', 'default');
237
237
238
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
239
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table>
240
  [% IF ( LibraryName ) %]
241
    <tr>
242
      <th colspan="5" class="centerednames">
243
        <h3>[% LibraryName | html %]</h3>
244
      </th>
245
    </tr>
246
  [% END %]
247
248
  <tr>
249
    <th colspan="5" class="centerednames">
250
      <h2><u>INVOICE</u></h2>
251
    </th>
252
  </tr>
253
  <tr>
254
    <th colspan="5" class="centerednames">
255
      <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2>
256
    </th>
257
  </tr>
258
  <tr>
259
    <th colspan="5" >
260
      Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br />
261
      Card number: [% patron.cardnumber | html %]<br />
262
    </th>
263
  </tr>
264
  <tr>
265
    <th>Date</th>
266
    <th>Description of charges</th>
267
    <th>Note</th>
268
    <th style="text-align:right;">Amount</th>
269
    <th style="text-align:right;">Amount outstanding</th>
270
  </tr>
271
272
  [% FOREACH account IN accounts %]
273
    <tr class="highlight">
274
      <td>[% account.date | $KohaDates%]</td>
275
      <td>
276
        [% PROCESS account_type_description account=account %]
277
        [%- IF account.description %], [% account.description | html %][% END %]
278
      </td>
279
      <td>[% account.note | html %]</td>
280
      [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td>
281
      [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td>
282
    </tr>
283
  [% END %]
284
285
  <tfoot>
286
    <tr>
287
      <td colspan="4">Total outstanding dues as on date: </td>
288
      [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
289
    </tr>
290
  </tfoot>
291
</table>', 'print', 'default');
292
238
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
293
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
239
('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');
294
('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');
(-)a/installer/data/mysql/es-ES/mandatory/sample_notices.sql (+55 lines)
Lines 228-232 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
228
</tfoot>
228
</tfoot>
229
</table>', 'print', 'default');
229
</table>', 'print', 'default');
230
230
231
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
232
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table>
233
  [% IF ( LibraryName ) %]
234
    <tr>
235
      <th colspan="5" class="centerednames">
236
        <h3>[% LibraryName | html %]</h3>
237
      </th>
238
    </tr>
239
  [% END %]
240
241
  <tr>
242
    <th colspan="5" class="centerednames">
243
      <h2><u>INVOICE</u></h2>
244
    </th>
245
  </tr>
246
  <tr>
247
    <th colspan="5" class="centerednames">
248
      <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2>
249
    </th>
250
  </tr>
251
  <tr>
252
    <th colspan="5" >
253
      Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br />
254
      Card number: [% patron.cardnumber | html %]<br />
255
    </th>
256
  </tr>
257
  <tr>
258
    <th>Date</th>
259
    <th>Description of charges</th>
260
    <th>Note</th>
261
    <th style="text-align:right;">Amount</th>
262
    <th style="text-align:right;">Amount outstanding</th>
263
  </tr>
264
265
  [% FOREACH account IN accounts %]
266
    <tr class="highlight">
267
      <td>[% account.date | $KohaDates%]</td>
268
      <td>
269
        [% PROCESS account_type_description account=account %]
270
        [%- IF account.description %], [% account.description | html %][% END %]
271
      </td>
272
      <td>[% account.note | html %]</td>
273
      [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td>
274
      [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td>
275
    </tr>
276
  [% END %]
277
278
  <tfoot>
279
    <tr>
280
      <td colspan="4">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
231
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
232
('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');
(-)a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql (+55 lines)
Lines 116-120 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
116
</tfoot>
116
</tfoot>
117
</table>', 'print', 'default');
117
</table>', 'print', 'default');
118
118
119
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
120
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table>
121
  [% IF ( LibraryName ) %]
122
    <tr>
123
      <th colspan="5" class="centerednames">
124
        <h3>[% LibraryName | html %]</h3>
125
      </th>
126
    </tr>
127
  [% END %]
128
129
  <tr>
130
    <th colspan="5" class="centerednames">
131
      <h2><u>INVOICE</u></h2>
132
    </th>
133
  </tr>
134
  <tr>
135
    <th colspan="5" class="centerednames">
136
      <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2>
137
    </th>
138
  </tr>
139
  <tr>
140
    <th colspan="5" >
141
      Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br />
142
      Card number: [% patron.cardnumber | html %]<br />
143
    </th>
144
  </tr>
145
  <tr>
146
    <th>Date</th>
147
    <th>Description of charges</th>
148
    <th>Note</th>
149
    <th style="text-align:right;">Amount</th>
150
    <th style="text-align:right;">Amount outstanding</th>
151
  </tr>
152
153
  [% FOREACH account IN accounts %]
154
    <tr class="highlight">
155
      <td>[% account.date | $KohaDates%]</td>
156
      <td>
157
        [% PROCESS account_type_description account=account %]
158
        [%- IF account.description %], [% account.description | html %][% END %]
159
      </td>
160
      <td>[% account.note | html %]</td>
161
      [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td>
162
      [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td>
163
    </tr>
164
  [% END %]
165
166
  <tfoot>
167
    <tr>
168
      <td colspan="4">Total outstanding dues as on date: </td>
169
      [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
170
    </tr>
171
  </tfoot>
172
</table>', 'print', 'default');
173
119
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
174
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
120
('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');
175
('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');
(-)a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql (+55 lines)
Lines 229-233 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
229
</tfoot>
229
</tfoot>
230
</table>', 'print', 'default');
230
</table>', 'print', 'default');
231
231
232
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
233
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table>
234
  [% IF ( LibraryName ) %]
235
    <tr>
236
      <th colspan="5" class="centerednames">
237
        <h3>[% LibraryName | html %]</h3>
238
      </th>
239
    </tr>
240
  [% END %]
241
242
  <tr>
243
    <th colspan="5" class="centerednames">
244
      <h2><u>INVOICE</u></h2>
245
    </th>
246
  </tr>
247
  <tr>
248
    <th colspan="5" class="centerednames">
249
      <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2>
250
    </th>
251
  </tr>
252
  <tr>
253
    <th colspan="5" >
254
      Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br />
255
      Card number: [% patron.cardnumber | html %]<br />
256
    </th>
257
  </tr>
258
  <tr>
259
    <th>Date</th>
260
    <th>Description of charges</th>
261
    <th>Note</th>
262
    <th style="text-align:right;">Amount</th>
263
    <th style="text-align:right;">Amount outstanding</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
      [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td>
276
    </tr>
277
  [% END %]
278
279
  <tfoot>
280
    <tr>
281
      <td colspan="4">Total outstanding dues as on date: </td>
282
      [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
283
    </tr>
284
  </tfoot>
285
</table>', 'print', 'default');
286
232
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
287
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
233
('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');
288
('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');
(-)a/installer/data/mysql/it-IT/necessari/notices.sql (+55 lines)
Lines 231-235 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
231
</tfoot>
231
</tfoot>
232
</table>', 'print', 'default');
232
</table>', 'print', 'default');
233
233
234
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
235
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table>
236
  [% IF ( LibraryName ) %]
237
    <tr>
238
      <th colspan="5" class="centerednames">
239
        <h3>[% LibraryName | html %]</h3>
240
      </th>
241
    </tr>
242
  [% END %]
243
244
  <tr>
245
    <th colspan="5" class="centerednames">
246
      <h2><u>INVOICE</u></h2>
247
    </th>
248
  </tr>
249
  <tr>
250
    <th colspan="5" class="centerednames">
251
      <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2>
252
    </th>
253
  </tr>
254
  <tr>
255
    <th colspan="5" >
256
      Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br />
257
      Card number: [% patron.cardnumber | html %]<br />
258
    </th>
259
  </tr>
260
  <tr>
261
    <th>Date</th>
262
    <th>Description of charges</th>
263
    <th>Note</th>
264
    <th style="text-align:right;">Amount</th>
265
    <th style="text-align:right;">Amount outstanding</th>
266
  </tr>
267
268
  [% FOREACH account IN accounts %]
269
    <tr class="highlight">
270
      <td>[% account.date | $KohaDates%]</td>
271
      <td>
272
        [% PROCESS account_type_description account=account %]
273
        [%- IF account.description %], [% account.description | html %][% END %]
274
      </td>
275
      <td>[% account.note | html %]</td>
276
      [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td>
277
      [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td>
278
    </tr>
279
  [% END %]
280
281
  <tfoot>
282
    <tr>
283
      <td colspan="4">Total outstanding dues as on date: </td>
284
      [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
285
    </tr>
286
  </tfoot>
287
</table>', 'print', 'default');
288
234
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
289
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
235
('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');
290
('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');
(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql (+55 lines)
Lines 248-252 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
248
</tfoot>
248
</tfoot>
249
</table>', 'print', 'default');
249
</table>', 'print', 'default');
250
250
251
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
252
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table>
253
  [% IF ( LibraryName ) %]
254
    <tr>
255
      <th colspan="5" class="centerednames">
256
        <h3>[% LibraryName | html %]</h3>
257
      </th>
258
    </tr>
259
  [% END %]
260
261
  <tr>
262
    <th colspan="5" class="centerednames">
263
      <h2><u>INVOICE</u></h2>
264
    </th>
265
  </tr>
266
  <tr>
267
    <th colspan="5" class="centerednames">
268
      <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2>
269
    </th>
270
  </tr>
271
  <tr>
272
    <th colspan="5" >
273
      Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br />
274
      Card number: [% patron.cardnumber | html %]<br />
275
    </th>
276
  </tr>
277
  <tr>
278
    <th>Date</th>
279
    <th>Description of charges</th>
280
    <th>Note</th>
281
    <th style="text-align:right;">Amount</th>
282
    <th style="text-align:right;">Amount outstanding</th>
283
  </tr>
284
285
  [% FOREACH account IN accounts %]
286
    <tr class="highlight">
287
      <td>[% account.date | $KohaDates%]</td>
288
      <td>
289
        [% PROCESS account_type_description account=account %]
290
        [%- IF account.description %], [% account.description | html %][% END %]
291
      </td>
292
      <td>[% account.note | html %]</td>
293
      [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td>
294
      [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td>
295
    </tr>
296
  [% END %]
297
298
  <tfoot>
299
    <tr>
300
      <td colspan="4">Total outstanding dues as on date: </td>
301
      [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
302
    </tr>
303
  </tfoot>
304
</table>', 'print', 'default');
305
251
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
306
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
252
('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');
307
('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');
(-)a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql (+55 lines)
Lines 226-230 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
226
</tfoot>
226
</tfoot>
227
</table>', 'print', 'default');
227
</table>', 'print', 'default');
228
228
229
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
230
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table>
231
  [% IF ( LibraryName ) %]
232
    <tr>
233
      <th colspan="5" class="centerednames">
234
        <h3>[% LibraryName | html %]</h3>
235
      </th>
236
    </tr>
237
  [% END %]
238
239
  <tr>
240
    <th colspan="5" class="centerednames">
241
      <h2><u>INVOICE</u></h2>
242
    </th>
243
  </tr>
244
  <tr>
245
    <th colspan="5" class="centerednames">
246
      <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2>
247
    </th>
248
  </tr>
249
  <tr>
250
    <th colspan="5" >
251
      Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br />
252
      Card number: [% patron.cardnumber | html %]<br />
253
    </th>
254
  </tr>
255
  <tr>
256
    <th>Date</th>
257
    <th>Description of charges</th>
258
    <th>Note</th>
259
    <th style="text-align:right;">Amount</th>
260
    <th style="text-align:right;">Amount outstanding</th>
261
  </tr>
262
263
  [% FOREACH account IN accounts %]
264
    <tr class="highlight">
265
      <td>[% account.date | $KohaDates%]</td>
266
      <td>
267
        [% PROCESS account_type_description account=account %]
268
        [%- IF account.description %], [% account.description | html %][% END %]
269
      </td>
270
      <td>[% account.note | html %]</td>
271
      [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td>
272
      [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td>
273
    </tr>
274
  [% END %]
275
276
  <tfoot>
277
    <tr>
278
      <td colspan="4">Total outstanding dues as on date: </td>
279
      [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
280
    </tr>
281
  </tfoot>
282
</table>', 'print', 'default');
283
229
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
284
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
230
('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');
285
('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');
(-)a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql (+55 lines)
Lines 228-232 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
228
</tfoot>
228
</tfoot>
229
</table>', 'print', 'default');
229
</table>', 'print', 'default');
230
230
231
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
232
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table>
233
  [% IF ( LibraryName ) %]
234
    <tr>
235
      <th colspan="5" class="centerednames">
236
        <h3>[% LibraryName | html %]</h3>
237
      </th>
238
    </tr>
239
  [% END %]
240
241
  <tr>
242
    <th colspan="5" class="centerednames">
243
      <h2><u>INVOICE</u></h2>
244
    </th>
245
  </tr>
246
  <tr>
247
    <th colspan="5" class="centerednames">
248
      <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2>
249
    </th>
250
  </tr>
251
  <tr>
252
    <th colspan="5" >
253
      Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br />
254
      Card number: [% patron.cardnumber | html %]<br />
255
    </th>
256
  </tr>
257
  <tr>
258
    <th>Date</th>
259
    <th>Description of charges</th>
260
    <th>Note</th>
261
    <th style="text-align:right;">Amount</th>
262
    <th style="text-align:right;">Amount outstanding</th>
263
  </tr>
264
265
  [% FOREACH account IN accounts %]
266
    <tr class="highlight">
267
      <td>[% account.date | $KohaDates%]</td>
268
      <td>
269
        [% PROCESS account_type_description account=account %]
270
        [%- IF account.description %], [% account.description | html %][% END %]
271
      </td>
272
      <td>[% account.note | html %]</td>
273
      [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td>
274
      [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td>
275
    </tr>
276
  [% END %]
277
278
  <tfoot>
279
    <tr>
280
      <td colspan="4">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
231
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
232
('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');
287
('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');
(-)a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql (-1 / +55 lines)
Lines 318-322 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
318
</tfoot>
318
</tfoot>
319
</table>', 'print', 'default');
319
</table>', 'print', 'default');
320
320
321
INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
322
('circulation', 'ACCOUNT_DEBIT', '', 'Account fee', 0, 'Account fee', '<table>
323
  [% IF ( LibraryName ) %]
324
    <tr>
325
      <th colspan="5" class="centerednames">
326
        <h3>[% LibraryName | html %]</h3>
327
      </th>
328
    </tr>
329
  [% END %]
330
331
  <tr>
332
    <th colspan="5" class="centerednames">
333
      <h2><u>INVOICE</u></h2>
334
    </th>
335
  </tr>
336
  <tr>
337
    <th colspan="5" class="centerednames">
338
      <h2>[% Branches.GetName( patron.branchcode ) | html %]</h2>
339
    </th>
340
  </tr>
341
  <tr>
342
    <th colspan="5" >
343
      Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br />
344
      Card number: [% patron.cardnumber | html %]<br />
345
    </th>
346
  </tr>
347
  <tr>
348
    <th>Date</th>
349
    <th>Description of charges</th>
350
    <th>Note</th>
351
    <th style="text-align:right;">Amount</th>
352
    <th style="text-align:right;">Amount outstanding</th>
353
  </tr>
354
355
  [% FOREACH account IN accounts %]
356
    <tr class="highlight">
357
      <td>[% account.date | $KohaDates%]</td>
358
      <td>
359
        [% PROCESS account_type_description account=account %]
360
        [%- IF account.description %], [% account.description | html %][% END %]
361
      </td>
362
      <td>[% account.note | html %]</td>
363
      [% IF ( account.amountcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amount | $Price %]</td>
364
      [% IF ( account.amountoutstandingcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% account.amountoutstanding | $Price %]</td>
365
    </tr>
366
  [% END %]
367
368
  <tfoot>
369
    <tr>
370
      <td colspan="4">Total outstanding dues as on date: </td>
371
      [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
372
    </tr>
373
  </tfoot>
374
</table>', 'print', 'default');
375
321
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
376
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
322
('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');
377
('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');
323
- 

Return to bug 22809