← Back to branch summary

~unifield-team/unifield-wm/us-826

« back to all changes in this revision

Viewing changes to financing_contract/report/financing_contract.rml

  • Committer: jf
  • Date: 2011-12-30 09:08:24 UTC
  • mfrom: (395.8.8 UF-661)
  • Revision ID: jf@tempo4-20111230090824-4zbrgeyqqu4z4so3
UF-661 [MERGE] Financing contracts: Export CSV File

Show diffs side-by-side

added added

removed removed

Lines of Context:
financing_contract/report/financing_contract.rml
 
1
<?xml version="1.0"?>
 
2
<document filename="test.pdf">
 
3
  <template pageSize="(595.0,842.0)" title="Test" author="Martin Simon" allowSplitting="20">
 
4
    <pageTemplate id="first">
 
5
      <frame id="first" x1="15.0" y1="42.0" width="539" height="758"/>
 
6
    </pageTemplate>
 
7
  </template>
 
8
  <stylesheet>
 
9
    <blockTableStyle id="Standard_Outline">
 
10
      <blockAlignment value="LEFT"/>
 
11
      <blockValign value="TOP"/>
 
12
    </blockTableStyle>
 
13
    <blockTableStyle id="Table2">
 
14
      <blockAlignment value="LEFT"/>
 
15
      <blockValign value="TOP"/>
 
16
      <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="0,0" stop="0,-1"/>
 
17
      <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="0,0" stop="0,0"/>
 
18
      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,-1" stop="0,-1"/>
 
19
      <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="1,0" stop="1,-1"/>
 
20
      <lineStyle kind="LINEAFTER" colorName="#e6e6e6" start="1,0" stop="1,-1"/>
 
21
      <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="1,0" stop="1,0"/>
 
22
      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="1,-1" stop="1,-1"/>
 
23
    </blockTableStyle>
 
24
    <blockTableStyle id="Table3">
 
25
      <blockAlignment value="LEFT"/>
 
26
      <blockValign value="TOP"/>
 
27
      <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="0,0" stop="0,-1"/>
 
28
      <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="0,0" stop="0,0"/>
 
29
      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,-1" stop="0,-1"/>
 
30
      <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="1,0" stop="1,-1"/>
 
31
      <lineStyle kind="LINEAFTER" colorName="#e6e6e6" start="1,0" stop="1,-1"/>
 
32
      <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="1,0" stop="1,0"/>
 
33
      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="1,-1" stop="1,-1"/>
 
34
    </blockTableStyle>
 
35
    <blockTableStyle id="Table1">
 
36
      <blockAlignment value="LEFT"/>
 
37
      <blockValign value="TOP"/>
 
38
    </blockTableStyle>
 
39
    <blockTableStyle id="Table10">
 
40
      <blockAlignment value="LEFT"/>
 
41
      <blockValign value="TOP"/>
 
42
      <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
 
43
      <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
 
44
      <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
 
45
    </blockTableStyle>
 
46
    <blockTableStyle id="Table8">
 
47
      <blockAlignment value="LEFT"/>
 
48
      <blockValign value="TOP"/>
 
49
    </blockTableStyle>
 
50
    <blockTableStyle id="Table12">
 
51
      <blockAlignment value="LEFT"/>
 
52
      <blockValign value="TOP"/>
 
53
    </blockTableStyle>
 
54
    <blockTableStyle id="Table11">
 
55
      <blockAlignment value="LEFT"/>
 
56
      <blockValign value="TOP"/>
 
57
      <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
 
58
      <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
 
59
    </blockTableStyle>
 
60
    <blockTableStyle id="Table6">
 
61
      <blockAlignment value="LEFT"/>
 
62
      <blockValign value="TOP"/>
 
63
    </blockTableStyle>
 
64
    <blockTableStyle id="Table9">
 
65
      <blockAlignment value="LEFT"/>
 
66
      <blockValign value="TOP"/>
 
67
    </blockTableStyle>
 
68
    <blockTableStyle id="Table4">
 
69
      <blockAlignment value="LEFT"/>
 
70
      <blockValign value="TOP"/>
 
71
      <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
 
72
      <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
 
73
      <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
 
74
      <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
 
75
    </blockTableStyle>
 
76
    <blockTableStyle id="Table5">
 
77
      <blockAlignment value="LEFT"/>
 
78
      <blockValign value="TOP"/>
 
79
    </blockTableStyle>
 
80
    <blockTableStyle id="Table7">
 
81
      <blockAlignment value="LEFT"/>
 
82
      <blockValign value="TOP"/>
 
83
    </blockTableStyle>
 
84
    <initialize>
 
85
      <paraStyle name="all" alignment="justify"/>
 
86
    </initialize>
 
87
    <paraStyle name="P1" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" textColor="#4c4c4c"/>
 
88
    <paraStyle name="P2" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER"/>
 
89
    <paraStyle name="P3" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER"/>
 
90
    <paraStyle name="P4" fontName="Helvetica-Bold" fontSize="9.0" leading="11" spaceBefore="0.0" spaceAfter="6.0"/>
 
91
    <paraStyle name="P5" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
92
    <paraStyle name="P6" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
93
    <paraStyle name="P7" fontName="Helvetica-Bold" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
94
    <paraStyle name="P8" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
95
    <paraStyle name="P9" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
96
    <paraStyle name="P10" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
 
97
    <paraStyle name="P11" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
98
    <paraStyle name="P12" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 
99
    <paraStyle name="P13" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
 
100
    <paraStyle name="P14" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 
101
    <paraStyle name="P15" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
 
102
    <paraStyle name="P16" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
 
103
    <paraStyle name="P17" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
 
104
    <paraStyle name="P18" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 
105
    <paraStyle name="P19" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
106
    <paraStyle name="P20" fontName="Helvetica" fontSize="6.0" leading="8" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
107
    <paraStyle name="P21" fontName="Helvetica" fontSize="6.0" leading="8" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
108
    <paraStyle name="P22" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
109
    <paraStyle name="P23" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER"/>
 
110
    <paraStyle name="P24" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" textColor="#444444"/>
 
111
    <paraStyle name="P25" fontName="Helvetica-Bold" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
112
    <paraStyle name="Standard" fontName="Helvetica"/>
 
113
    <paraStyle name="Text body" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 
114
    <paraStyle name="Heading" fontName="Helvetica" fontSize="8.0" leading="10" spaceBefore="12.0" spaceAfter="6.0"/>
 
115
    <paraStyle name="List" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 
116
    <paraStyle name="Table Contents" fontName="Helvetica"/>
 
117
    <paraStyle name="Table Heading" fontName="Helvetica" alignment="CENTER"/>
 
118
    <paraStyle name="Caption" fontName="Helvetica" fontSize="12.0" leading="15" spaceBefore="6.0" spaceAfter="6.0"/>
 
119
    <paraStyle name="Index" fontName="Helvetica"/>
 
120
    <paraStyle name="terp_header" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
 
121
    <paraStyle name="terp_default_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
122
    <paraStyle name="terp_default_Bold_8" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
123
    <paraStyle name="terp_default_Bold_9" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
124
    <paraStyle name="terp_default_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
125
    <paraStyle name="terp_tblheader_General" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
 
126
    <paraStyle name="terp_tblheader_General_Centre" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
 
127
    <paraStyle name="terp_default_Centre_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 
128
    <paraStyle name="terp_tblheader_Details" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
 
129
    <paraStyle name="Footer" fontName="Helvetica"/>
 
130
    <paraStyle name="Horizontal Line" fontName="Helvetica" fontSize="6.0" leading="8" spaceBefore="0.0" spaceAfter="14.0"/>
 
131
    <paraStyle name="Heading 9" fontName="Helvetica-Bold" fontSize="75%" leading="NaN" spaceBefore="12.0" spaceAfter="6.0"/>
 
132
    <paraStyle name="terp_tblheader_General_Right" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
 
133
    <paraStyle name="terp_tblheader_Details_Centre" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
 
134
    <paraStyle name="terp_tblheader_Details_Right" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
 
135
    <paraStyle name="terp_default_Right_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 
136
    <paraStyle name="terp_header_Right" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
 
137
    <paraStyle name="terp_header_Centre" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="CENTER" spaceBefore="12.0" spaceAfter="6.0"/>
 
138
    <paraStyle name="terp_default_address" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
139
    <paraStyle name="terp_default_Centre_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 
140
    <paraStyle name="terp_default_Right_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 
141
    <paraStyle name="terp_default_1" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
142
    <paraStyle name="terp_default_Right_9_Bold" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 
143
    <paraStyle name="terp_default_Italic" rightIndent="0.0" leftIndent="20.0" fontName="Helvetica-Oblique" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 
144
    <paraStyle name="Preformatted Text" fontName="Helvetica" fontSize="10.0" leading="13" spaceBefore="0.0" spaceAfter="0.0"/>
 
145
    <paraStyle name="terp_default_Centre_9_Bold" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 
146
    <images/>
 
147
  </stylesheet>
 
148
  <story>
 
149
    <para style="P5">[[repeatIn(objects,'o')]]</para>
 
150
    <para style="P10">Contract code/name: [[ o.code ]]/[[ o.name ]]</para>
 
151
    <para style="P10">Donor: [[ (o.donor_id and o.donor_id.name) or '' ]]</para>
 
152
    <para style="P5">
 
153
      <font color="white"> </font>
 
154
    </para>
 
155
    <blockTable colWidths="266.0,269.0" style="Table2">
 
156
      <tr>
 
157
        <td>
 
158
          <para style="P13">Eligibility period:</para>
 
159
        </td>
 
160
        <td>
 
161
          <para style="P13">Reporting type:</para>
 
162
        </td>
 
163
      </tr>
 
164
    </blockTable>
 
165
    <blockTable colWidths="266.0,269.0" style="Table3">
 
166
      <tr>
 
167
        <td>
 
168
          <para style="P14">[[ o.eligibility_from_date ]] to [[ o.eligibility_to_date ]]</para>
 
169
        </td>
 
170
        <td>
 
171
          <para style="P14">[[ (o.reporting_type=='all') and 'Total project and funded costs' or '' ]]</para>
 
172
          <para style="P14">[[ (o.reporting_type=='project') and 'Total project costs' or '' ]]</para>
 
173
          <para style="P14">[[ (o.reporting_type=='allocated') and 'Funded costs' or '' ]]</para>
 
174
        </td>
 
175
      </tr>
 
176
    </blockTable>
 
177
    <para style="P6">
 
178
      <font color="white"> </font>
 
179
    </para>
 
180
    <para style="P6">
 
181
      <font color="white"> </font>
 
182
    </para>
 
183
    <para style="P7">Contract information:</para>
 
184
    <blockTable colWidths="180.0,180.0,180.0" style="Table1">
 
185
      <tr>
 
186
        <td>
 
187
          <para style="P1">[[ o.grant_name and 'Grant name: ' + o.grant_name or '']]</para>
 
188
        </td>
 
189
        <td>
 
190
          <para style="P1">Donor grant reference: [[ o.donor_grant_reference ]]</para>
 
191
        </td>
 
192
        <td>
 
193
          <para style="P1">HQ grant reference: [[ o.hq_grant_reference ]]</para>
 
194
        </td>
 
195
      </tr>
 
196
      <tr>
 
197
        <td>
 
198
          <para style="P1">Grant amount: [[ formatLang(o.grant_amount) ]]</para>
 
199
        </td>
 
200
        <td>
 
201
          <para style="P1">Currency table: [[ (o.currency_table_id and o.currency_table_id.name) or '' ]]</para>
 
202
        </td>
 
203
        <td>
 
204
          <para style="P1">Reporting currency: [[ (o.reporting_currency and o.reporting_currency.name) or '' ]]</para>
 
205
        </td>
 
206
      </tr>
 
207
    </blockTable>
 
208
    <para style="P8">
 
209
      <font color="white"> </font>
 
210
    </para>
 
211
    <para style="P8">
 
212
      <font color="white"> </font>
 
213
    </para>
 
214
    <para style="P7">Funding pools:</para>
 
215
    <blockTable colWidths="227.0,151.0,162.0" style="Table10">
 
216
      <tr>
 
217
        <td>
 
218
          <para style="P2">Funding pool name</para>
 
219
        </td>
 
220
        <td>
 
221
          <para style="P2">Funded</para>
 
222
        </td>
 
223
        <td>
 
224
          <para style="P2">Total project</para>
 
225
        </td>
 
226
      </tr>
 
227
    </blockTable>
 
228
    <blockTable colWidths="539.0" style="Table8">
 
229
      <tr>
 
230
        <td>
 
231
          <para style="P20">[[repeatIn(o.funding_pool_ids,'line')]]</para>
 
232
          <blockTable colWidths="225.0,149.0,160.0" style="Table12">
 
233
            <tr>
 
234
              <td>
 
235
                <para style="P3">[[ line.funding_pool_id.name ]]</para>
 
236
              </td>
 
237
              <td>
 
238
                <para style="P3">[[ (line.funded) and '✔' or '' ]]</para>
 
239
              </td>
 
240
              <td>
 
241
                <para style="P24">✔</para>
 
242
              </td>
 
243
            </tr>
 
244
          </blockTable>
 
245
          <para style="P22">
 
246
            <font color="white"> </font>
 
247
          </para>
 
248
        </td>
 
249
      </tr>
 
250
    </blockTable>
 
251
    <para style="P4">
 
252
      <font color="white"> </font>
 
253
    </para>
 
254
    <para style="P9">
 
255
      <font color="white"> </font>
 
256
    </para>
 
257
    <para style="P7">Cost centers:</para>
 
258
    <blockTable colWidths="281.0,258.0" style="Table11">
 
259
      <tr>
 
260
        <td>
 
261
          <para style="P2">Cost center name</para>
 
262
        </td>
 
263
        <td>
 
264
          <para style="P2">Cost center code</para>
 
265
        </td>
 
266
      </tr>
 
267
    </blockTable>
 
268
    <blockTable colWidths="539.0" style="Table6">
 
269
      <tr>
 
270
        <td>
 
271
          <para style="P20">[[repeatIn(o.cost_center_ids,'line')]]</para>
 
272
          <blockTable colWidths="278.0,255.0" style="Table9">
 
273
            <tr>
 
274
              <td>
 
275
                <para style="P3">[[ line.name ]]</para>
 
276
              </td>
 
277
              <td>
 
278
                <para style="P3">[[ line.code ]]</para>
 
279
              </td>
 
280
            </tr>
 
281
          </blockTable>
 
282
          <para style="P22">
 
283
            <font color="white"> </font>
 
284
          </para>
 
285
        </td>
 
286
      </tr>
 
287
    </blockTable>
 
288
    <para style="P4">
 
289
      <font color="white"> </font>
 
290
    </para>
 
291
    <para style="P9">
 
292
      <font color="white"> </font>
 
293
    </para>
 
294
    <para style="P7">Reporting lines:</para>
 
295
    <blockTable colWidths="79.0,89.0,206.0,162.0" repeatRows="1" style="Table4">
 
296
      <tr>
 
297
        <td>
 
298
          <para style="P15">Code</para>
 
299
        </td>
 
300
        <td>
 
301
          <para style="P16">Name</para>
 
302
        </td>
 
303
        <td>
 
304
          <para style="P16">Funded amount - Budget</para>
 
305
        </td>
 
306
        <td>
 
307
          <para style="P17">Total project amount - Budget</para>
 
308
        </td>
 
309
      </tr>
 
310
    </blockTable>
 
311
    <section>
 
312
      <para style="P21">[[repeatIn(o.actual_line_ids,'line')]]</para>
 
313
      <blockTable colWidths="79.0,90.0,205.0,163.0" style="Table5">
 
314
        <tr>
 
315
          <td>
 
316
            <para style="P19">[[ line.code ]]</para>
 
317
          </td>
 
318
          <td>
 
319
            <para style="P12">[[ line.name ]]</para>
 
320
          </td>
 
321
          <td>
 
322
            <para style="P12">[[ formatLang(line.allocated_budget) ]] </para>
 
323
          </td>
 
324
          <td>
 
325
            <para style="P18">[[ formatLang(line.project_budget) ]]</para>
 
326
          </td>
 
327
        </tr>
 
328
      </blockTable>
 
329
    </section>
 
330
    <para style="P5">
 
331
      <font color="white"> </font>
 
332
    </para>
 
333
    <para style="P7">
 
334
      <font color="white"> </font>
 
335
    </para>
 
336
    <para style="P7">Comments:</para>
 
337
    <blockTable colWidths="533.0" style="Table7">
 
338
      <tr>
 
339
        <td>
 
340
          <para style="P11">[[ format(o.notes or '') ]]</para>
 
341
        </td>
 
342
      </tr>
 
343
    </blockTable>
 
344
    <para style="P5">
 
345
      <font color="white"> </font>
 
346
    </para>
 
347
  </story>
 
348
</document>
 
 
b'\\ No newline at end of file'