addons/hr_timesheet_invoice/report/cost_ledger.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="28.0" y1="28.0" width="539" height="786"/>
   6     </pageTemplate>
   7   </template>
   8   <stylesheet>
   9     <blockTableStyle id="Standard_Outline">
  10       <blockAlignment value="LEFT"/>
  11       <blockValign value="TOP"/>
  12     </blockTableStyle>
  13     <blockTableStyle id="Tableau1">
  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="Tableau3">
  24       <blockAlignment value="LEFT"/>
  25       <blockValign value="TOP"/>
  26       <lineStyle kind="GRID" colorName="black"/>
  27     </blockTableStyle>
  28     <blockTableStyle id="Tableau2">
  29       <blockAlignment value="LEFT"/>
  30       <blockValign value="TOP"/>
  31       <blockBackground colorName="#e6e6e6" start="0,0" stop="0,0"/>
  32     </blockTableStyle>
  33     <blockTableStyle id="Tableau4">
  34       <blockAlignment value="LEFT"/>
  35       <blockValign value="TOP"/>
  36     </blockTableStyle>
  37     <blockTableStyle id="Tableau7">
  38       <blockAlignment value="LEFT"/>
  39       <blockValign value="TOP"/>
  40     </blockTableStyle>
  41     <blockTableStyle id="Tableau6">
  42       <blockAlignment value="LEFT"/>
  43       <blockValign value="TOP"/>
  44     </blockTableStyle>
  45     <blockTableStyle id="Tableau5">
  46       <blockAlignment value="LEFT"/>
  47       <blockValign value="TOP"/>
  48       <blockBackground colorName="#e6e6e6" start="0,0" stop="0,0"/>
  49       <blockBackground colorName="#e6e6e6" start="1,0" stop="1,0"/>
  50       <blockBackground colorName="#e6e6e6" start="2,0" stop="2,0"/>
  51       <blockBackground colorName="#e6e6e6" start="3,0" stop="3,0"/>
  52       <blockBackground colorName="#e6e6e6" start="4,0" stop="4,0"/>
  53       <blockBackground colorName="#e6e6e6" start="5,0" stop="5,0"/>
  54     </blockTableStyle>
  55     <blockTableStyle id="Tableau10">
  56       <blockAlignment value="LEFT"/>
  57       <blockValign value="TOP"/>
  58       <lineStyle kind="GRID" colorName="black"/>
  59     </blockTableStyle>
  60     <initialize>
  61       <paraStyle name="all" alignment="justify"/>
  62     </initialize>
  63     <paraStyle name="P1" fontName="Times-Roman" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
  64     <paraStyle name="P2" fontName="Times-Bold" fontSize="20.0" leading="25" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
  65     <paraStyle name="P3" fontName="Times-Bold" fontSize="10.0" leading="13" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
  66     <paraStyle name="P4" fontName="Times-Bold" fontSize="10.0" leading="13" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
  67     <paraStyle name="P5" fontName="Times-Bold" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
  68     <paraStyle name="P6" fontName="Times-Roman" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
  69     <paraStyle name="P7" fontName="Times-Roman" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
  70     <paraStyle name="P8" fontName="Times-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
  71     <paraStyle name="P9" fontName="Times-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
  72     <paraStyle name="P10" fontName="Times-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
  73     <paraStyle name="P11" fontName="Times-Roman"/>
  74     <paraStyle name="P12" fontName="Times-Roman" fontSize="9.0" leading="11" alignment="CENTER"/>
  75     <paraStyle name="P13" fontName="Times-Roman" fontSize="3.0" leading="4" alignment="LEFT"/>
  76     <paraStyle name="P14" fontName="Times-Roman" fontSize="8.0" leading="10" alignment="LEFT"/>
  77     <paraStyle name="P15" fontName="Times-Roman" fontSize="6.0" leading="8" alignment="LEFT"/>
  78     <paraStyle name="P16" fontName="Times-Roman" fontSize="12.0" leading="15" alignment="CENTER"/>
  79     <paraStyle name="P17" fontName="Times-Roman" fontSize="8.0" leading="10" alignment="LEFT"/>
  80     <paraStyle name="P18" fontName="Times-Roman" fontSize="10.0" leading="13" alignment="LEFT"/>
  81     <paraStyle name="P19" fontName="Times-Roman" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
  82     <paraStyle name="P20" fontName="Times-Bold" fontSize="10.0" leading="13" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
  83     <paraStyle name="P21" fontName="Times-Roman" fontSize="10.0" leading="13" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
  84     <paraStyle name="P22" fontName="Times-Roman" fontSize="10.0" leading="13" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
  85     <paraStyle name="P23" fontName="Times-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
  86     <paraStyle name="P24" fontName="Times-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
  87     <paraStyle name="Standard" fontName="Times-Roman"/>
  88     <paraStyle name="Text body" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
  89     <paraStyle name="List" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
  90     <paraStyle name="Table Contents" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="0.0"/>
  91     <paraStyle name="Table Heading" fontName="Times-Roman" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
  92     <paraStyle name="Caption" fontName="Times-Roman" fontSize="10.0" leading="13" spaceBefore="6.0" spaceAfter="6.0"/>
  93     <paraStyle name="Index" fontName="Times-Roman"/>
  94   </stylesheet>
  95   <story>
  96     <blockTable colWidths="179.0,179.0,179.0" repeatRows="1" style="Tableau1">
  97       <tr>
  98         <td>
  99           <para style="P1">
 100             <font color="white"> </font>
 101           </para>
 102         </td>
 103         <td>
 104           <para style="P2">Cost Ledger</para>
 105         </td>
 106         <td>
 107           <para style="P21">
 108             <font color="white"> </font>
 109           </para>
 110         </td>
 111       </tr>
 112       <tr>
 113         <td>
 114           <para style="P1">[[ company.name ]]</para>
 115         </td>
 116         <td>
 117           <para style="P22">Period from [[ data['form']['date1'] ]]</para>
 118           <para style="P22">to [[ data['form']['date2'] ]]</para>
 119         </td>
 120         <td>
 121           <para style="P21">Currency: [[ company.currency_id.name ]]</para>
 122         </td>
 123       </tr>
 124     </blockTable>
 125     <para style="P11">
 126       <font color="white"> </font>
 127     </para>
 128     <para style="P12">Printing date: [[ time.strftime('%Y-%m-%d') ]] at [[ time.strftime('%H:%M:%S') ]]</para>
 129     <para style="P12">
 130       <font color="white"> </font>
 131     </para>
 132     <blockTable colWidths="63.0,46.0,139.0,54.0,55.0,55.0,63.0,63.0" style="Tableau3">
 133       <tr>
 134         <td>
 135           <para style="P4">Date</para>
 136         </td>
 137         <td>
 138           <para style="P4">J.C.</para>
 139         </td>
 140         <td>
 141           <para style="P4">Move name</para>
 142         </td>
 143         <td>
 144           <para style="P4">Qty</para>
 145         </td>
 146         <td>
 147           <para style="P4">Debit </para>
 148         </td>
 149         <td>
 150           <para style="P4">Credit</para>
 151         </td>
 152         <td>
 153           <para style="P4">Balance</para>
 154         </td>
 155         <td>
 156           <para style="P4">Theorical Revenue</para>
 157         </td>
 158       </tr>
 159     </blockTable>
 160     <para style="P13">
 161       <font color="white"> </font>
 162     </para>
 163     <section>
 164       <para style="P14">[[ repeatIn(objects, 'o') ]]</para>
 165       <para style="P15">
 166         <font color="white"> </font>
 167       </para>
 168       <blockTable colWidths="539.0" style="Tableau2">
 169         <tr>
 170           <td>
 171             <para style="P17"><font face="Times-Roman" size="8.0">[[ o.code ]] [[ o.name ]]: </font>max qty: [[ o.quantity_max or '-' ]], max amount: [[ o.amount_max or '-']]</para>
 172           </td>
 173         </tr>
 174       </blockTable>
 175       <para style="P13">
 176         <font color="white"> </font>
 177       </para>
 178       <section>
 179         <para style="P15">[[ repeatIn(lines_g(o.id, data['form']['date1'], data['form']['date2']), 'move_g') ]]</para>
 180         <para style="P13">
 181           <font color="white"> </font>
 182         </para>
 183         <blockTable colWidths="475.0,63.0" style="Tableau4">
 184           <tr>
 185             <td>
 186               <para style="P5">[[ move_g['code'] ]] <font face="Times-Bold" size="10.0">[[ move_g['name'] ]]</font></para>
 187             </td>
 188             <td>
 189               <para style="P3">
 190                 <font color="white"> </font>
 191               </para>
 192             </td>
 193           </tr>
 194         </blockTable>
 195         <blockTable colWidths="63.0,46.0,139.0,55.0,53.0,57.0,63.0,63.0" style="Tableau7">
 196           <tr>
 197             <td>
 198               <para style="P6">[[ repeatIn(lines_a(move_g['id'], o.id, data['form']['date1'], data['form']['date2']), 'move_a') ]]</para>
 199               <para style="P6">[[ move_a['date'] ]]</para>
 200             </td>
 201             <td>
 202               <para style="P7">[[ move_a['cj'] ]]</para>
 203             </td>
 204             <td>
 205               <para style="P6">[[ move_a['name'] ]]</para>
 206             </td>
 207             <td>
 208               <para style="P7">[[ '%.2f' % move_a['quantity'] ]]</para>
 209             </td>
 210             <td>
 211               <para style="P7">[[ '%.2f' % move_a['debit'] ]]</para>
 212             </td>
 213             <td>
 214               <para style="P7">[[ '%.2f' % move_a['credit'] ]]</para>
 215             </td>
 216             <td>
 217               <para style="P7">[[ '%.2f' % move_a['balance'] ]]</para>
 218             </td>
 219             <td>
 220               <para style="P7">[[ '%.2f' % move_a['revenue'] ]]</para>
 221             </td>
 222           </tr>
 223         </blockTable>
 224         <blockTable colWidths="247.0,55.0,53.0,57.0,63.0,63.0" style="Tableau6">
 225           <tr>
 226             <td>
 227               <para style="P8">Total ([[ move_g['name'] ]])</para>
 228             </td>
 229             <td>
 230               <para style="P8">[[ '%.2f' % move_g['quantity'] ]]</para>
 231             </td>
 232             <td>
 233               <para style="P8">[[ '%.2f' % move_g['debit'] ]]</para>
 234             </td>
 235             <td>
 236               <para style="P8">[[ '%.2f' % move_g['credit'] ]]</para>
 237             </td>
 238             <td>
 239               <para style="P8">[[ '%.2f' % move_g['balance'] ]]</para>
 240             </td>
 241             <td>
 242               <para style="P8">[[ '%.2f' % (account_g_sum_revenue(move_g['id']) or 0.0) ]]</para>
 243             </td>
 244           </tr>
 245         </blockTable>
 246         <para style="P13">
 247           <font color="white"> </font>
 248         </para>
 249       </section>
 250       <blockTable colWidths="247.0,55.0,53.0,56.0,63.0,63.0" style="Tableau5">
 251         <tr>
 252           <td>
 253             <para style="P24">Total ([[ o['code'] ]])</para>
 254           </td>
 255           <td>
 256             <para style="P10">[[ '%.2f' % (account_sum_qty(o.id, data['form']['date1'], data['form']['date2']) or 0.0) ]]</para>
 257           </td>
 258           <td>
 259             <para style="P10">[[ '%.2f' % (account_sum_debit(o.id, data['form']['date1'], data['form']['date2']) or 0.0) ]]</para>
 260           </td>
 261           <td>
 262             <para style="P10">[[ '%.2f' % (account_sum_credit(o.id, data['form']['date1'], data['form']['date2']) or 0.0) ]]</para>
 263           </td>
 264           <td>
 265             <para style="P10">[[ '%.2f' % (account_sum_balance(o.id, data['form']['date1'], data['form']['date2']) or 0.0) ]]</para>
 266           </td>
 267           <td>
 268             <para style="P10">[[ '%.2f' % (account_sum_revenue(o.id) or 0.0) ]]</para>
 269           </td>
 270         </tr>
 271       </blockTable>
 272       <para style="P15">
 273         <font color="white"> </font>
 274       </para>
 275     </section>
 276     <para style="P16">
 277       <font color="white"> </font>
 278     </para>
 279     <blockTable colWidths="247.0,55.0,53.0,56.0,63.0,64.0" style="Tableau10">
 280       <tr>
 281         <td>
 282           <para style="P9">Total</para>
 283         </td>
 284         <td>
 285           <para style="P9">[[ '%.2f' % (sum_qty(objects, data['form']['date1'], data['form']['date2']) or 0.0) ]]</para>
 286         </td>
 287         <td>
 288           <para style="P9">[[ '%.2f' % (sum_debit(objects, data['form']['date1'], data['form']['date2']) or 0.0) ]]</para>
 289         </td>
 290         <td>
 291           <para style="P9">[[ '%.2f' % (sum_credit(objects, data['form']['date1'], data['form']['date2']) or 0.0) ]]</para>
 292         </td>
 293         <td>
 294           <para style="P9">[[ '%.2f' % (sum_balance(objects, data['form']['date1'], data['form']['date2']) or 0.0) ]]</para>
 295         </td>
 296         <td>
 297           <para style="P9">[[ '%.2f' % (sum_revenue(objects) or 0.0) ]]</para>
 298         </td>
 299       </tr>
 300     </blockTable>
 301     <para style="P18">
 302       <font color="white"> </font>
 303     </para>
 304   </story>
 305 </document>
 306