addons/account/report/partner_balance.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="57.0" y1="57.0" width="481" 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="Table1">
  14       <blockAlignment value="LEFT"/>
  15       <blockValign value="TOP"/>
  16       <blockBackground colorName="#e6e6e6" start="0,0" stop="0,-1"/>
  17       <blockBackground colorName="#e6e6e6" start="1,0" stop="1,-1"/>
  18       <blockBackground colorName="#e6e6e6" start="2,0" stop="2,-1"/>
  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="Table6">
  24       <blockAlignment value="LEFT"/>
  25       <blockValign value="TOP"/>
  26       <lineStyle kind="LINEBEFORE" colorName="#000000" start="0,0" stop="0,-1"/>
  27       <lineStyle kind="LINEABOVE" colorName="#000000" start="0,0" stop="0,0"/>
  28       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
  29       <lineStyle kind="LINEBEFORE" colorName="#000000" start="1,0" stop="1,-1"/>
  30       <lineStyle kind="LINEABOVE" colorName="#000000" start="1,0" stop="1,0"/>
  31       <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
  32       <lineStyle kind="LINEBEFORE" colorName="#000000" start="2,0" stop="2,-1"/>
  33       <lineStyle kind="LINEABOVE" colorName="#000000" start="2,0" stop="2,0"/>
  34       <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
  35       <lineStyle kind="LINEBEFORE" colorName="#000000" start="3,0" stop="3,-1"/>
  36       <lineStyle kind="LINEABOVE" colorName="#000000" start="3,0" stop="3,0"/>
  37       <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
  38       <lineStyle kind="LINEBEFORE" colorName="#000000" start="4,0" stop="4,-1"/>
  39       <lineStyle kind="LINEAFTER" colorName="#000000" start="4,0" stop="4,-1"/>
  40       <lineStyle kind="LINEABOVE" colorName="#000000" start="4,0" stop="4,0"/>
  41       <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
  42     </blockTableStyle>
  43     <blockTableStyle id="Table2">
  44       <blockAlignment value="LEFT"/>
  45       <blockValign value="TOP"/>
  46       <lineStyle kind="LINEBEFORE" colorName="#000000" start="0,0" stop="0,-1"/>
  47       <lineStyle kind="LINEABOVE" colorName="#000000" start="0,0" stop="0,0"/>
  48       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
  49       <lineStyle kind="LINEBEFORE" colorName="#000000" start="1,0" stop="1,-1"/>
  50       <lineStyle kind="LINEABOVE" colorName="#000000" start="1,0" stop="1,0"/>
  51       <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
  52       <lineStyle kind="LINEBEFORE" colorName="#000000" start="2,0" stop="2,-1"/>
  53       <lineStyle kind="LINEABOVE" colorName="#000000" start="2,0" stop="2,0"/>
  54       <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
  55       <lineStyle kind="LINEBEFORE" colorName="#000000" start="3,0" stop="3,-1"/>
  56       <lineStyle kind="LINEABOVE" colorName="#000000" start="3,0" stop="3,0"/>
  57       <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
  58       <lineStyle kind="LINEBEFORE" colorName="#000000" start="4,0" stop="4,-1"/>
  59       <lineStyle kind="LINEABOVE" colorName="#000000" start="4,0" stop="4,0"/>
  60       <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
  61       <lineStyle kind="LINEBEFORE" colorName="#000000" start="5,0" stop="5,-1"/>
  62       <lineStyle kind="LINEAFTER" colorName="#000000" start="5,0" stop="5,-1"/>
  63       <lineStyle kind="LINEABOVE" colorName="#000000" start="5,0" stop="5,0"/>
  64       <lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
  65     </blockTableStyle>
  66     <blockTableStyle id="Table3">
  67       <blockAlignment value="LEFT"/>
  68       <blockValign value="TOP"/>
  69     </blockTableStyle>
  70     <blockTableStyle id="Table4">
  71       <blockAlignment value="LEFT"/>
  72       <blockValign value="TOP"/>
  73       <lineStyle kind="LINEBEFORE" colorName="#000000" start="0,0" stop="0,-1"/>
  74       <lineStyle kind="LINEABOVE" colorName="#000000" start="0,0" stop="0,0"/>
  75       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
  76       <lineStyle kind="LINEBEFORE" colorName="#000000" start="1,0" stop="1,-1"/>
  77       <lineStyle kind="LINEABOVE" colorName="#000000" start="1,0" stop="1,0"/>
  78       <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
  79       <lineStyle kind="LINEBEFORE" colorName="#000000" start="2,0" stop="2,-1"/>
  80       <lineStyle kind="LINEABOVE" colorName="#000000" start="2,0" stop="2,0"/>
  81       <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
  82       <lineStyle kind="LINEBEFORE" colorName="#000000" start="3,0" stop="3,-1"/>
  83       <lineStyle kind="LINEABOVE" colorName="#000000" start="3,0" stop="3,0"/>
  84       <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
  85       <lineStyle kind="LINEBEFORE" colorName="#000000" start="4,0" stop="4,-1"/>
  86       <lineStyle kind="LINEABOVE" colorName="#000000" start="4,0" stop="4,0"/>
  87       <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
  88       <lineStyle kind="LINEBEFORE" colorName="#000000" start="5,0" stop="5,-1"/>
  89       <lineStyle kind="LINEAFTER" colorName="#000000" start="5,0" stop="5,-1"/>
  90       <lineStyle kind="LINEABOVE" colorName="#000000" start="5,0" stop="5,0"/>
  91       <lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
  92       <lineStyle kind="LINEBEFORE" colorName="#000000" start="0,1" stop="0,-1"/>
  93       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
  94       <lineStyle kind="LINEBEFORE" colorName="#000000" start="1,1" stop="1,-1"/>
  95       <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
  96       <lineStyle kind="LINEBEFORE" colorName="#000000" start="2,1" stop="2,-1"/>
  97       <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
  98       <lineStyle kind="LINEBEFORE" colorName="#000000" start="3,1" stop="3,-1"/>
  99       <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
 100       <lineStyle kind="LINEBEFORE" colorName="#000000" start="4,1" stop="4,-1"/>
 101       <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
 102       <lineStyle kind="LINEBEFORE" colorName="#000000" start="5,1" stop="5,-1"/>
 103       <lineStyle kind="LINEAFTER" colorName="#000000" start="5,1" stop="5,-1"/>
 104       <lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
 105     </blockTableStyle>
 106     <initialize>
 107       <paraStyle name="all" alignment="justify"/>
 108     </initialize>
 109     <paraStyle name="P1" fontName="Times-Roman" fontSize="20.0" leading="25" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 110     <paraStyle name="P2" fontName="Times-Roman" fontSize="10.0" leading="13" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 111     <paraStyle name="P3" fontName="Times-Roman" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
 112     <paraStyle name="P4" fontName="Times-Roman" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 113     <paraStyle name="P5" fontName="Times-Roman" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 114     <paraStyle name="P6" fontName="Times-Roman" fontSize="11.0" leading="14" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 115     <paraStyle name="P7" fontName="Times-Roman" fontSize="11.0" leading="14" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 116     <paraStyle name="P8" fontName="Times-Roman" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 117     <paraStyle name="P9" fontName="Times-Roman" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
 118     <paraStyle name="P10" fontName="Times-Roman" alignment="CENTER"/>
 119     <paraStyle name="P11" fontName="Times-Roman" fontSize="8.0" leading="10"/>
 120     <paraStyle name="P12" fontName="Times-Roman" fontSize="11.0" leading="14" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 121     <paraStyle name="P13" fontName="Times-Roman" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 122     <paraStyle name="P14" rightIndent="17.0" leftIndent="-0.0" fontName="Times-Bold" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 123     <paraStyle name="Standard" fontName="Times-Roman"/>
 124     <paraStyle name="Text body" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
 125     <paraStyle name="List" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
 126     <paraStyle name="Table Contents" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
 127     <paraStyle name="Table Heading" fontName="Times-Roman" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 128     <paraStyle name="Caption" fontName="Times-Roman" fontSize="10.0" leading="13" spaceBefore="6.0" spaceAfter="6.0"/>
 129     <paraStyle name="Index" fontName="Times-Roman"/>
 130   </stylesheet>
 131   <images/>
 132   <story>
 133     <blockTable colWidths="145.0,186.0,151.0" repeatRows="1" style="Table1">
 134       <tr>
 135         <td>
 136           <para style="Table Contents">
 137             <font color="white"> </font>
 138           </para>
 139         </td>
 140         <td>
 141           <para style="P1">Third party balance</para>
 142         </td>
 143         <td>
 144           <para style="P2"><font face="Times-Roman">From</font> [[ formatLang(data['form']['date1'], date=True) ]]</para>
 145           <para style="P2"><font face="Times-Roman">to</font> [[ formatLang(data['form']['date2'], date=True) ]]</para>
 146         </td>
 147       </tr>
 148       <tr>
 149         <td>
 150           <para style="Table Contents">[[ get_company(data['form']) ]]</para>
 151         </td>
 152         <td>
 153           <para style="P5">
 154             <font color="white"> </font>
 155           </para>
 156         </td>
 157         <td>
 158           <para style="P6"><font face="Times-Roman">Currency:</font> [[ get_currency(data['form']) ]]</para>
 159         </td>
 160       </tr>
 161     </blockTable>
 162     <para style="Standard">
 163       <font color="white"> </font>
 164     </para>
 165     <para style="P10"><font face="Times-Roman">Printing date:</font> [[ formatLang(time.strftime('%Y-%m-%d'), date=True) ]] <font face="Times-Roman">at</font> [[ time.strftime('%H:%M:%S') ]]</para>
 166     <para style="P10">
 167       <font color="white"> </font>
 168     </para>
 169     <blockTable colWidths="60.0,137.0,118.0,109.0,58.0" repeatRows="1" style="Table6">
 170       <tr>
 171         <td>
 172           <para style="P12">Account number</para>
 173         </td>
 174         <td>
 175           <para style="P12">Account name</para>
 176         </td>
 177         <td>
 178           <para style="P12">Transactions</para>
 179         </td>
 180         <td>
 181           <para style="P12">Balances</para>
 182         </td>
 183         <td>
 184           <para style="P12">In dispute</para>
 185         </td>
 186       </tr>
 187     </blockTable>
 188     <blockTable colWidths="197.0,60.0,58.0,55.0,54.0,58.0" repeatRows="1" style="Table2">
 189       <tr>
 190         <td>
 191           <para style="P12">
 192             <font color="white"> </font>
 193           </para>
 194         </td>
 195         <td>
 196           <para style="P12">Debit</para>
 197         </td>
 198         <td>
 199           <para style="P12">Credit</para>
 200         </td>
 201         <td>
 202           <para style="P12">Debit</para>
 203         </td>
 204         <td>
 205           <para style="P12">Credit</para>
 206         </td>
 207         <td>
 208           <para style="P12">
 209             <font color="white"> </font>
 210           </para>
 211         </td>
 212       </tr>
 213     </blockTable>
 214     <para style="P13">
 215       <font color="white"> </font>
 216     </para>
 217     <blockTable colWidths="61.0,137.0,60.0,58.0,55.0,54.0,57.0" style="Table3">
 218       <tr>
 219         <td>
 220           <para style="P14">[[ repeatIn(lines(), 'a') ]]<font face="Times-Roman">[[ a['ref'] ]]</font></para>
 221         </td>
 222         <td>
 223           <para style="P3">[[ a['name'] ]]</para>
 224         </td>
 225         <td>
 226           <para style="P4">[[ formatLang(a['debit']) ]]</para>
 227         </td>
 228         <td>
 229           <para style="P4">[[ formatLang(a['credit']) ]]</para>
 230         </td>
 231         <td>
 232           <para style="P4">[[ formatLang(a['sdebit']) ]]</para>
 233         </td>
 234         <td>
 235           <para style="P4">[[ formatLang(a['scredit']) ]]</para>
 236         </td>
 237         <td>
 238           <para style="P4">[[ formatLang((a['enlitige'] or 0.0)) ]]</para>
 239         </td>
 240       </tr>
 241     </blockTable>
 242     <para style="Standard">
 243       <font color="white"> </font>
 244     </para>
 245     <blockTable colWidths="198.0,60.0,58.0,56.0,53.0,57.0" style="Table4">
 246       <tr>
 247         <td>
 248           <para style="P7">Grand total</para>
 249         </td>
 250         <td>
 251           <para style="P8">[[ formatLang(sum_debit()) ]]</para>
 252         </td>
 253         <td>
 254           <para style="P8">[[ formatLang(sum_credit()) ]]</para>
 255         </td>
 256         <td>
 257           <para style="P8">[[ formatLang(sum_sdebit()) ]]</para>
 258         </td>
 259         <td>
 260           <para style="P8">[[ formatLang(sum_scredit()) ]]</para>
 261         </td>
 262         <td>
 263           <para style="P8">[[ formatLang(sum_litige()) ]]</para>
 264         </td>
 265       </tr>
 266       <tr>
 267         <td>
 268           <para style="P7">Balance</para>
 269         </td>
 270         <td>
 271           <para style="P8">
 272             <font color="white"> </font>
 273           </para>
 274         </td>
 275         <td>
 276           <para style="P8">
 277             <font color="white"> </font>
 278           </para>
 279         </td>
 280         <td>
 281           <para style="P8">[[ formatLang(solde_debit()) ]]</para>
 282         </td>
 283         <td>
 284           <para style="P8">[[ formatLang(solde_credit()) ]]</para>
 285         </td>
 286         <td>
 287           <para style="P8">
 288             <font color="white"> </font>
 289           </para>
 290         </td>
 291       </tr>
 292     </blockTable>
 293     <para style="P11"/>
 294     <para style="P9">
 295       <font color="white"> </font>
 296     </para>
 297   </story>
 298 </document>
 299