[IMP]account:improved General Journal report with big column size with big amount...
[odoo/odoo.git] / addons / hr_expense / report / expense.rml
1 <?xml version="1.0"?>
2 <document filename="test.pdf">
3   <template pageSize="(595.0,842.0)" title="Expenses" author="OpenERP S.A. (sales@openerp.com)" allowSplitting="20">
4     <pageTemplate id="first">
5       <frame id="first" x1="16.0" y1="57.0" width="522" height="728"/>
6     </pageTemplate>
7   </template>
8   <stylesheet>
9     <blockTableStyle id="Standard_Outline">
10       <blockAlignment value="LEFT"/>
11       <blockValign value="TOP"/>
12     </blockTableStyle>
13     <blockTableStyle id="Table_employee_ref_header">
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="LINEABOVE" colorName="#e6e6e6" start="1,0" stop="1,0"/>
21       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="1,-1" stop="1,-1"/>
22       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="2,0" stop="2,-1"/>
23       <lineStyle kind="LINEAFTER" colorName="#e6e6e6" start="2,0" stop="2,-1"/>
24       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="2,0" stop="2,0"/>
25       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="2,-1" stop="2,-1"/>
26     </blockTableStyle>
27     <blockTableStyle id="Table_employee_ref_content">
28       <blockAlignment value="LEFT"/>
29       <blockValign value="TOP"/>
30       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="0,0" stop="0,-1"/>
31       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="0,0" stop="0,0"/>
32       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,-1" stop="0,-1"/>
33       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="1,0" stop="1,-1"/>
34       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="1,0" stop="1,0"/>
35       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="1,-1" stop="1,-1"/>
36       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="2,0" stop="2,-1"/>
37       <lineStyle kind="LINEAFTER" colorName="#e6e6e6" start="2,0" stop="2,-1"/>
38       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="2,0" stop="2,0"/>
39       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="2,-1" stop="2,-1"/>
40     </blockTableStyle>
41     <blockTableStyle id="Table_hr_expense_line_header">
42       <blockAlignment value="LEFT"/>
43       <blockValign value="TOP"/>
44       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
45       <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
46       <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
47       <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
48       <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
49       <lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
50     </blockTableStyle>
51     <blockTableStyle id="Table_expense_line">
52       <blockAlignment value="LEFT"/>
53       <blockValign value="TOP"/>
54       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,-1" stop="0,-1"/>
55       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="1,-1" stop="1,-1"/>
56       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="2,-1" stop="2,-1"/>
57       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="3,-1" stop="3,-1"/>
58       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="4,-1" stop="4,-1"/>
59       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="5,-1" stop="5,-1"/>
60       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,-1" stop="0,-1"/>
61       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="1,-1" stop="1,-1"/>
62       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="2,-1" stop="2,-1"/>
63       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="3,-1" stop="3,-1"/>
64       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="4,-1" stop="4,-1"/>
65       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="5,-1" stop="5,-1"/>
66     </blockTableStyle>
67     <blockTableStyle id="Table_Final_total">
68       <blockAlignment value="LEFT"/>
69       <blockValign value="TOP"/>
70       <lineStyle kind="LINEABOVE" colorName="#ffffff" start="0,0" stop="0,0"/>
71       <lineStyle kind="LINEABOVE" colorName="#ffffff" start="1,0" stop="1,0"/>
72       <lineStyle kind="LINEABOVE" colorName="#ffffff" start="2,0" stop="2,0"/>
73       <lineStyle kind="LINEABOVE" colorName="#000000" start="3,0" stop="3,0"/>
74       <lineStyle kind="LINEABOVE" colorName="#000000" start="4,0" stop="4,0"/>
75     </blockTableStyle>
76     <initialize>
77       <paraStyle name="all" alignment="justify"/>
78     </initialize>
79     <paraStyle name="Standard" fontName="Helvetica"/>
80     <paraStyle name="Text body" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
81     <paraStyle name="Heading" fontName="Helvetica" fontSize="14.0" leading="17" spaceBefore="12.0" spaceAfter="6.0"/>
82     <paraStyle name="List" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
83     <paraStyle name="Table Contents" fontName="Helvetica"/>
84     <paraStyle name="Table Heading" fontName="Helvetica" alignment="CENTER"/>
85     <paraStyle name="Caption" fontName="Helvetica" fontSize="12.0" leading="15" spaceBefore="6.0" spaceAfter="6.0"/>
86     <paraStyle name="Index" fontName="Helvetica"/>
87     <paraStyle name="Footer" fontName="Helvetica"/>
88     <paraStyle name="Horizontal Line" fontName="Helvetica" fontSize="6.0" leading="8" spaceBefore="0.0" spaceAfter="14.0"/>
89     <paraStyle name="terp_header" fontName="Helvetica-Bold" fontSize="12.0" leading="15" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
90     <paraStyle name="Heading 9" fontName="Helvetica-Bold" fontSize="75%" leading="NaN" spaceBefore="12.0" spaceAfter="6.0"/>
91     <paraStyle name="terp_tblheader_General" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
92     <paraStyle name="terp_tblheader_Details" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
93     <paraStyle name="terp_default_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
94     <paraStyle name="terp_default_Bold_8" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
95     <paraStyle name="terp_tblheader_General_Centre" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
96     <paraStyle name="terp_tblheader_General_Right" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
97     <paraStyle name="terp_tblheader_Details_Centre" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
98     <paraStyle name="terp_tblheader_Details_Right" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
99     <paraStyle name="terp_default_Right_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
100     <paraStyle name="terp_default_Centre_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
101     <paraStyle name="terp_header_Right" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
102     <paraStyle name="terp_header_Centre" fontName="Helvetica-Bold" fontSize="12.0" leading="15" alignment="CENTER" spaceBefore="12.0" spaceAfter="6.0"/>
103     <paraStyle name="terp_default_address" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
104     <paraStyle name="terp_default_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
105     <paraStyle name="terp_default_Bold_centre_9" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
106     <paraStyle name="terp_default_Centre_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
107     <paraStyle name="terp_default_Right_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
108     <paraStyle name="terp_default_1" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
109     <paraStyle name="terp_default_9_bold_right" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
110     <paraStyle name="terp_default_italic_8" fontName="Helvetica-Oblique" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
111     <images/>
112   </stylesheet>
113   <story>
114     <para style="terp_default_8">[[ repeatIn(objects,'o') ]]</para>
115     <para style="terp_default_8">
116       <font color="white"> </font>
117     </para>
118     <para style="terp_header_Centre">HR Expenses</para>
119     <para style="terp_tblheader_General_Centre">
120       <font face="Helvetica" size="9.0">[[ o.name or '' ]]</font>
121     </para>
122     <para style="terp_default_8">
123       <font color="white"> </font>
124     </para>
125     <blockTable colWidths="174.0,174.0,174.0" style="Table_employee_ref_header">
126       <tr>
127         <td>
128           <para style="terp_tblheader_General_Centre">Employee</para>
129         </td>
130         <td>
131           <para style="terp_tblheader_General_Centre">Date</para>
132         </td>
133         <td>
134           <para style="terp_tblheader_General_Centre">Reference</para>
135         </td>
136       </tr>
137     </blockTable>
138     <blockTable colWidths="174.0,174.0,174.0" style="Table_employee_ref_content">
139       <tr>
140         <td>
141           <para style="terp_default_Centre_8">[[ o.employee_id.name ]] </para>
142         </td>
143         <td>
144           <para style="terp_default_Centre_8">[[ formatLang(o.date,date=True) ]]</para>
145         </td>
146         <td>
147           <para style="terp_default_Centre_8">[[ o.ref ]]</para>
148         </td>
149       </tr>
150     </blockTable>
151     <para style="terp_default_8">
152       <font color="white"> </font>
153     </para>
154     <blockTable colWidths="49.0,204.0,45.0,80.0,53.0,91.0" style="Table_hr_expense_line_header">
155       <tr>
156         <td>
157           <para style="terp_tblheader_Details">Date</para>
158         </td>
159         <td>
160           <para style="terp_tblheader_Details">Name</para>
161         </td>
162         <td>
163           <para style="terp_tblheader_Details_Centre">Ref.</para>
164         </td>
165         <td>
166           <para style="terp_tblheader_Details_Right">Unit Price</para>
167         </td>
168         <td>
169           <para style="terp_tblheader_Details_Right">Qty</para>
170         </td>
171         <td>
172           <para style="terp_tblheader_Details_Right">Total Price</para>
173         </td>
174       </tr>
175     </blockTable>
176     <para style="terp_default_1">
177       <font color="white"> </font>
178     </para>
179     <section>
180       <para style="terp_default_8">[[ repeatIn(o.line_ids,'line') ]]</para>
181       <blockTable colWidths="49.0,204.0,46.0,79.0,53.0,92.0" style="Table_expense_line">
182         <tr>
183           <td>
184             <para style="terp_default_9">[[ formatLang(line.date_value,date=True) ]]</para>
185           </td>
186           <td>
187             <para style="terp_default_9">[[ line.name or '' ]] [[ line.description or '' ]]</para>
188           </td>
189           <td>
190             <para style="terp_default_9">[[ line.ref or '' ]]</para>
191           </td>
192           <td>
193             <para style="terp_default_Right_9">[[ formatLang(line.unit_amount) ]] </para>
194           </td>
195           <td>
196             <para style="terp_default_Right_9">[[ formatLang(line.unit_quantity) ]]</para>
197           </td>
198           <td>
199             <para style="terp_default_Right_9">[[ formatLang(line.total_amount) ]] [[ o.currency_id.symbol ]] </para>
200           </td>
201         </tr>
202         <tr>
203           <td>
204             <para style="terp_default_9">
205               <font color="white"> </font>
206             </para>
207           </td>
208           <td>
209             <para style="terp_default_italic_8">[[ line.analytic_account and line.analytic_account.complete_name or removeParentNode('tr') ]]</para>
210           </td>
211           <td>
212             <para style="terp_default_9">
213               <font color="white"> </font>
214             </para>
215           </td>
216           <td>
217             <para style="terp_default_Right_9">
218               <font color="white"> </font>
219             </para>
220           </td>
221           <td>
222             <para style="terp_default_Right_9">
223               <font color="white"> </font>
224             </para>
225           </td>
226           <td>
227             <para style="terp_default_Right_9">
228               <font color="white"> </font>
229             </para>
230           </td>
231         </tr>
232       </blockTable>
233     </section>
234     <blockTable colWidths="57.0,171.0,171.0,32.0,92.0" style="Table_Final_total">
235       <tr>
236         <td>
237           <para style="terp_default_8">
238             <font color="white"> </font>
239           </para>
240         </td>
241         <td>
242           <para style="terp_default_8">
243             <font color="white"> </font>
244           </para>
245         </td>
246         <td>
247           <para style="terp_default_8">
248             <font color="white"> </font>
249           </para>
250         </td>
251         <td>
252           <para style="terp_tblheader_Details_Right">Total:</para>
253         </td>
254         <td>
255           <para style="terp_tblheader_Details_Right">[[ formatLang(o.amount) ]] [[ o.currency_id.symbol ]]</para>
256         </td>
257       </tr>
258     </blockTable>
259     <para style="terp_default_9">
260       <font color="white"> </font>
261     </para>
262     <para style="terp_default_9">[[ setTag('para','xpre') ]] [[ o.note or '' ]]</para>
263     <para style="terp_default_9">
264       <font color="white"> </font>
265     </para>
266     <para style="terp_default_9">Certified honest and conform,</para>
267     <para style="terp_default_9">(Date and signature)</para>
268     <para style="terp_default_9">
269       <font color="white"> </font>
270     </para>
271     <para style="terp_default_9">
272       <font color="white"> </font>
273     </para>
274     <para style="terp_default_9">This document must be dated and signed for reimbursement</para>
275   </story>
276 </document>