~unifield-team/unifield-addons/uf-2527-addons

« back to all changes in this revision

Viewing changes to account/report/budget_report.rml

  • Committer: pinky
  • Date: 2006-12-07 13:41:40 UTC
  • Revision ID: pinky-dedd7f8a42bd4557112a0513082691b8590ad6cc
New trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
<?xml version="1.0"?>
 
2
<document filename="test.pdf">
 
3
  <template pageSize="(612.0,792.0)" title="Test" author="Martin Simon" allowSplitting="20">
 
4
    <pageTemplate id="first">
 
5
      <frame id="first" x1="57.0" y1="57.0" width="498" height="678"/>
 
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
      <blockBackground colorName="#e6e6e6" start="0,0" stop="0,0"/>
 
17
      <blockBackground colorName="#e6e6e6" start="1,0" stop="1,0"/>
 
18
      <blockBackground colorName="#e6e6e6" start="2,0" stop="2,0"/>
 
19
      <blockBackground colorName="#e6e6e6" start="0,1" stop="0,1"/>
 
20
      <blockBackground colorName="#e6e6e6" start="1,1" stop="1,1"/>
 
21
      <blockBackground colorName="#e6e6e6" start="2,1" stop="2,1"/>
 
22
    </blockTableStyle>
 
23
    <blockTableStyle id="Table5">
 
24
      <blockAlignment value="LEFT"/>
 
25
      <blockValign value="TOP"/>
 
26
      <lineStyle kind="GRID" colorName="black"/>
 
27
    </blockTableStyle>
 
28
    <blockTableStyle id="Table8">
 
29
      <blockAlignment value="LEFT"/>
 
30
      <blockValign value="TOP"/>
 
31
    </blockTableStyle>
 
32
    <blockTableStyle id="Table9">
 
33
      <blockAlignment value="LEFT"/>
 
34
      <blockValign value="TOP"/>
 
35
    </blockTableStyle>
 
36
    <blockTableStyle id="Table10">
 
37
      <blockAlignment value="LEFT"/>
 
38
      <blockValign value="TOP"/>
 
39
    </blockTableStyle>
 
40
    <blockTableStyle id="Table7">
 
41
      <blockAlignment value="LEFT"/>
 
42
      <blockValign value="TOP"/>
 
43
      <lineStyle kind="GRID" colorName="black"/>
 
44
    </blockTableStyle>
 
45
    <initialize>
 
46
      <paraStyle name="all" alignment="justify"/>
 
47
    </initialize>
 
48
    <paraStyle name="P1" fontName="Times-Roman" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 
49
    <paraStyle name="P2" fontName="Times-Bold" fontSize="20.0" leading="25" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 
50
    <paraStyle name="P3" fontName="Times-Roman" fontSize="10.0" leading="13" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 
51
    <paraStyle name="P4" fontName="Times-Roman" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
 
52
    <paraStyle name="P5" fontName="Times-Bold" fontSize="18.0" leading="22" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 
53
    <paraStyle name="P6" fontName="Times-Roman" alignment="CENTER"/>
 
54
    <paraStyle name="P7" fontName="Times-BoldItalic" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 
55
    <paraStyle name="P8" fontName="Times-Roman"/>
 
56
    <paraStyle name="P9" fontName="Times-Bold"/>
 
57
    <paraStyle name="P10" fontName="Times-Bold" spaceBefore="0.0" spaceAfter="6.0"/>
 
58
    <paraStyle name="P11" fontName="Times-Bold" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
 
59
    <paraStyle name="P12" fontName="Times-Roman" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
 
60
    <paraStyle name="P13" fontName="Times-Roman" fontSize="10.0" leading="13" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 
61
    <paraStyle name="P14" fontName="Times-Roman" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 
62
    <paraStyle name="P15" fontName="Times-Bold" spaceBefore="0.0" spaceAfter="6.0"/>
 
63
    <paraStyle name="P16" fontName="Times-Roman" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 
64
    <paraStyle name="P17" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
 
65
    <paraStyle name="P18" fontName="Times-Bold" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 
66
    <paraStyle name="Standard" fontName="Times-Roman"/>
 
67
    <paraStyle name="Text body" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
 
68
    <paraStyle name="List" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
 
69
    <paraStyle name="Table Contents" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
 
70
    <paraStyle name="Table Heading" fontName="Times-Roman" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 
71
    <paraStyle name="Caption" fontName="Times-Roman" fontSize="10.0" leading="13" spaceBefore="6.0" spaceAfter="6.0"/>
 
72
    <paraStyle name="Index" fontName="Times-Roman"/>
 
73
  </stylesheet>
 
74
  <story>
 
75
    <blockTable colWidths="145.0,189.0,164.0" repeatRows="1" style="Table2">
 
76
      <tr>
 
77
        <td>
 
78
          <para style="P1">
 
79
            <font color="white"> </font>
 
80
          </para>
 
81
        </td>
 
82
        <td>
 
83
          <para style="P2">Budget Analysis</para>
 
84
        </td>
 
85
        <td>
 
86
          <para style="P3">From [[ data['form']['date1'] ]]</para>
 
87
          <para style="P3">to [[ data['form']['date2'] ]]</para>
 
88
        </td>
 
89
      </tr>
 
90
      <tr>
 
91
        <td>
 
92
          <para style="P4">[[ company.name ]]</para>
 
93
        </td>
 
94
        <td>
 
95
          <para style="P5">
 
96
            <font color="white"> </font>
 
97
          </para>
 
98
        </td>
 
99
        <td>
 
100
          <para style="P3">Currency: <font face="Times-Roman" size="11.0">[[ company.currency_id.name ]]</font></para>
 
101
        </td>
 
102
      </tr>
 
103
    </blockTable>
 
104
    <para style="Standard">
 
105
      <font color="white"> </font>
 
106
    </para>
 
107
    <para style="P6">Printing date: [[ time.strftime('%Y-%m-%d') ]] at [[ time.strftime('%H:%M:%S') ]]</para>
 
108
    <para style="P6">
 
109
      <font color="white"> </font>
 
110
    </para>
 
111
    <blockTable colWidths="104.0,53.0,60.0,72.0,73.0,63.0,73.0" repeatRows="1" style="Table5">
 
112
      <tr>
 
113
        <td>
 
114
          <para style="P7">Budget item detail</para>
 
115
        </td>
 
116
        <td>
 
117
          <para style="P7">Account Number</para>
 
118
        </td>
 
119
        <td>
 
120
          <para style="P7">Budget</para>
 
121
          <para style="P7">
 
122
            <font color="white"> </font>
 
123
          </para>
 
124
        </td>
 
125
        <td>
 
126
          <para style="P7">Period Budget</para>
 
127
          <para style="P7">
 
128
            <font color="white"> </font>
 
129
          </para>
 
130
        </td>
 
131
        <td>
 
132
          <para style="P7">Performance</para>
 
133
        </td>
 
134
        <td>
 
135
          <para style="P7">Spread</para>
 
136
        </td>
 
137
        <td>
 
138
          <para style="P7">% performance</para>
 
139
        </td>
 
140
      </tr>
 
141
    </blockTable>
 
142
    <para style="P8">
 
143
      <font color="white"> </font>
 
144
    </para>
 
145
    <section>
 
146
      <para style="P8">[[ repeatIn(objects, 'o') ]]</para>
 
147
      <blockTable colWidths="75.0,424.0" style="Table8">
 
148
        <tr>
 
149
          <td>
 
150
            <para style="P9">[[ o.code ]]</para>
 
151
          </td>
 
152
          <td>
 
153
            <para style="P10">[[ o.name ]]</para>
 
154
          </td>
 
155
        </tr>
 
156
      </blockTable>
 
157
      <blockTable colWidths="103.0,53.0,61.0,72.0,72.0,66.0,71.0" style="Table9">
 
158
        <tr>
 
159
          <td>
 
160
            <para style="P11">
 
161
              <font face="Times-Roman">[[ repeatIn(lines(o, data['form']['date1'], data['form']['date2']), 'a') ]] </font>
 
162
              <font face="Times-Roman">[[ a['name'] ]]</font>
 
163
            </para>
 
164
          </td>
 
165
          <td>
 
166
            <para style="P12">[[ a['code'] ]]</para>
 
167
          </td>
 
168
          <td>
 
169
            <para style="P13">
 
170
              <font color="white"> </font>
 
171
            </para>
 
172
          </td>
 
173
          <td>
 
174
            <para style="P13">
 
175
              <font color="white"> </font>
 
176
            </para>
 
177
          </td>
 
178
          <td>
 
179
            <para style="P14">[[ '%.2f' % a['achievements'] ]]</para>
 
180
          </td>
 
181
          <td>
 
182
            <para style="P13">
 
183
              <font color="white"> </font>
 
184
            </para>
 
185
          </td>
 
186
          <td>
 
187
            <para style="P13">
 
188
              <font color="white"> </font>
 
189
            </para>
 
190
          </td>
 
191
        </tr>
 
192
      </blockTable>
 
193
      <blockTable colWidths="156.0,61.0,72.0,72.0,66.0,70.0" style="Table10">
 
194
        <tr>
 
195
          <td>
 
196
            <para style="P15">Total [[ o.code ]]</para>
 
197
            <para style="Table Contents">[[ repeatIn( post_total(o, data['form']['date1'], data['form']['date2']), 'total') ]]</para>
 
198
          </td>
 
199
          <td>
 
200
            <para style="P16">[[ '%.2f' % total['prev'] ]]</para>
 
201
          </td>
 
202
          <td>
 
203
            <para style="P16">[[ '%.2f' % total['prev_period'] ]]</para>
 
204
          </td>
 
205
          <td>
 
206
            <para style="P16">[[ '%.2f' % total['achievements'] ]]</para>
 
207
          </td>
 
208
          <td>
 
209
            <para style="P16">[[ '%.2f' % (total['prev_period'] - total['achievements']) ]]</para>
 
210
          </td>
 
211
          <td>
 
212
            <para style="P16">[[ total['prev_period'] and ('%.2f' % (total['achievements'] / total['prev_period'] * 100.0)) or 0.0]] %</para>
 
213
          </td>
 
214
        </tr>
 
215
      </blockTable>
 
216
      <para style="Standard">
 
217
        <font color="white"> </font>
 
218
      </para>
 
219
    </section>
 
220
    <blockTable colWidths="156.0,61.0,72.0,72.0,67.0,68.0" style="Table7">
 
221
      <tr>
 
222
        <td>
 
223
          <para style="P17">Results</para>
 
224
          <para style="Table Contents">[[ repeatIn( budget_total(objects, data['form']['date1'], data['form']['date2']), 'total') ]]</para>
 
225
        </td>
 
226
        <td>
 
227
          <para style="P18">[[ '%.2f' % total['prev'] ]]</para>
 
228
        </td>
 
229
        <td>
 
230
          <para style="P18">[[ '%.2f' % total['prev_period'] ]]</para>
 
231
        </td>
 
232
        <td>
 
233
          <para style="P18">[[ '%.2f' % total['achievements'] ]]</para>
 
234
        </td>
 
235
        <td>
 
236
          <para style="P18">[[ '%.2f' % (total['prev_period'] - total['achievements']) ]]</para>
 
237
        </td>
 
238
        <td>
 
239
          <para style="P18">[[ '%.2f' % (total['achievements'] / total['prev_period'] * 100.0) ]] %</para>
 
240
        </td>
 
241
      </tr>
 
242
    </blockTable>
 
243
    <para style="Standard">
 
244
      <font color="white"> </font>
 
245
    </para>
 
246
  </story>
 
247
</document>
 
248