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

(-)a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql (-15 / +14 lines)
Lines 91-97 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
91
('circulation', 'ACCOUNT_WRITEOFF', '', 'Amnistie', 0, 'Amnistie', '[%- USE Price -%]\r\nNous avons accordé une amnistie de [% credit.amount * -1 | $Price %] à votre compte.\r\n\r\nLes frais suivants ont été amnistiés :\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nMontant payé : [% o.amount * -1 | $Price %]\r\nMontant en souffrance : [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');
91
('circulation', 'ACCOUNT_WRITEOFF', '', 'Amnistie', 0, 'Amnistie', '[%- USE Price -%]\r\nNous avons accordé une amnistie de [% credit.amount * -1 | $Price %] à votre compte.\r\n\r\nLes frais suivants ont été amnistiés :\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nMontant payé : [% o.amount * -1 | $Price %]\r\nMontant en souffrance : [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');
92
92
93
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
93
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES
94
('circulation', 'ACCOUNT_CREDIT', '', 'Account payment', 0, 'Account payment', '<table>
94
('circulation', 'ACCOUNT_CREDIT', '', 'Confirmation de paiement', 0, 'Confirmation de paiement', '<table>
95
[% IF ( LibraryName ) %]
95
[% IF ( LibraryName ) %]
96
 <tr>
96
 <tr>
97
    <th colspan="4" class="centerednames">
97
    <th colspan="4" class="centerednames">
Lines 101-107 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
101
[% END %]
101
[% END %]
102
 <tr>
102
 <tr>
103
    <th colspan="4" class="centerednames">
103
    <th colspan="4" class="centerednames">
104
        <h2><u>Fee receipt</u></h2>
104
        <h2><u>REÇU</u></h2>
105
    </th>
105
    </th>
106
 </tr>
106
 </tr>
107
 <tr>
107
 <tr>
Lines 111-125 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
111
 </tr>
111
 </tr>
112
 <tr>
112
 <tr>
113
    <th colspan="4">
113
    <th colspan="4">
114
        Received with thanks from  [% patron.firstname | html %] [% patron.surname | html %] <br />
114
        Reçu de [% patron.firstname | html %] [% patron.surname | html %] <br />
115
        Card number: [% patron.cardnumber | html %]<br />
115
        Numéro de carte : [% patron.cardnumber | html %]<br />
116
    </th>
116
    </th>
117
 </tr>
117
 </tr>
118
  <tr>
118
  <tr>
119
    <th>Date</th>
119
    <th>Date</th>
120
    <th>Description of charges</th>
120
    <th>Description des frais</th>
121
    <th>Note</th>
121
    <th>Note</th>
122
    <th>Amount</th>
122
    <th>Montant</th>
123
 </tr>
123
 </tr>
124
124
125
  [% FOREACH account IN accounts %]
125
  [% FOREACH account IN accounts %]
Lines 136-142 INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title` Link Here
136
  [% END %]
136
  [% END %]
137
<tfoot>
137
<tfoot>
138
  <tr>
138
  <tr>
139
    <td colspan="3">Total outstanding dues as on date: </td>
139
    <td colspan="3">Solde non-réglé : </td>
140
    [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
140
    [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
141
  </tr>
141
  </tr>
142
</tfoot>
142
</tfoot>
Lines 154-160 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here
154
154
155
  <tr>
155
  <tr>
156
    <th colspan="5" class="centerednames">
156
    <th colspan="5" class="centerednames">
157
      <h2><u>INVOICE</u></h2>
157
      <h2><u>FACTURE</u></h2>
158
    </th>
158
    </th>
159
  </tr>
159
  </tr>
160
  <tr>
160
  <tr>
Lines 164-179 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here
164
  </tr>
164
  </tr>
165
  <tr>
165
  <tr>
166
    <th colspan="5" >
166
    <th colspan="5" >
167
      Bill to: [% patron.firstname | html %] [% patron.surname | html %] <br />
167
      Facturé à : [% patron.firstname | html %] [% patron.surname | html %] <br />
168
      Card number: [% patron.cardnumber | html %]<br />
168
      Numéro de carte : [% patron.cardnumber | html %]<br />
169
    </th>
169
    </th>
170
  </tr>
170
  </tr>
171
  <tr>
171
  <tr>
172
    <th>Date</th>
172
    <th>Date</th>
173
    <th>Description of charges</th>
173
    <th>Description des frais</th>
174
    <th>Note</th>
174
    <th>Note</th>
175
    <th style="text-align:right;">Amount</th>
175
    <th style="text-align:right;">Montant</th>
176
    <th style="text-align:right;">Amount outstanding</th>
176
    <th style="text-align:right;">Solde</th>
177
  </tr>
177
  </tr>
178
178
179
  [% FOREACH account IN accounts %]
179
  [% FOREACH account IN accounts %]
Lines 191-197 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here
191
191
192
  <tfoot>
192
  <tfoot>
193
    <tr>
193
    <tr>
194
      <td colspan="4">Total outstanding dues as on date: </td>
194
      <td colspan="4">Solde non-réglé : </td>
195
      [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
195
      [% IF ( totalcredit ) %]<td class="credit">[% ELSE %]<td class="debit">[% END %][% total | $Price %]</td>
196
    </tr>
196
    </tr>
197
  </tfoot>
197
  </tfoot>
198
- 

Return to bug 23790