addons/account/report/partner_balance.rml

   1 <?xml version="1.0"?>
   2 <document filename="HipHop.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                 <header>
   7                         <pageGraphics>
   8                                 <!--logo-->
   9                                 <!--<fill color="darkblue"/>-->
  10                                 <!--<stroke color="darkblue"/>-->
  11
  12                                 <!--TITLE COMPANY-->
  13                                 <!-- <drawString x="4.6cm" y="28.7cm">[[ company.partner_id.name ]]</drawString> -->
  14
  15                                 <setFont name="Helvetica-Bold" size="9"/>
  16
  17
  18                                 <!--COL 1-->
  19                                 <drawString x="1.0cm" y="28.1cm">[[ company.name ]]</drawString>
  20                                 <drawRightString x="20cm" y="28.1cm">Partner Balance [[ data['form']['result_selection'] == 'customer' and '/ Débiteur' ]] [[ data['form']['result_selection'] == 'supplier' and '/ Créancier' ]] [[ data['form']['result_selection'] == 'all' and '/ Créancier et Débiteur' ]] [[ company.currency_id.name ]]</drawRightString>
  21
  22
  23                                 <!-- Header -->
  24
  25
  26                                 <setFont name="Helvetica" size="9"/>
  27                                 <drawString x="1.0cm" y="1cm"> [[ time.strftime("%Y-%m-%d %H:%M", time.localtime()) ]]</drawString>
  28                                 <drawString x="19.0cm" y="1cm">Page <pageNumber/></drawString>
  29                                 <!--<drawRightString x="19.8cm" y="28cm">[[ company.rml_header1 ]]</drawRightString>-->
  30
  31
  32                             <lineMode width="0.7"/>
  33                                 <lines>1cm 27.7cm 20cm 27.7cm</lines>
  34                                 <setFont name="Helvetica" size="8"/>
  35                         </pageGraphics>
  36                 </header>
  37     </pageTemplate>
  38   </template>
  39   <stylesheet>
  40     <blockTableStyle id="Standard_Outline">
  41       <blockAlignment value="LEFT"/>
  42       <blockValign value="TOP"/>
  43     </blockTableStyle>
  44     <blockTableStyle id="Table1">
  45       <blockAlignment value="LEFT"/>
  46       <blockValign value="TOP"/>
  47       <blockBackground colorName="#e6e6e6" start="0,0" stop="0,0"/>
  48       <blockBackground colorName="#e6e6e6" start="1,0" stop="1,0"/>
  49       <blockBackground colorName="#e6e6e6" start="2,0" stop="2,0"/>
  50       <blockBackground colorName="#e6e6e6" start="0,1" stop="0,1"/>
  51       <blockBackground colorName="#e6e6e6" start="1,1" stop="1,1"/>
  52       <blockBackground colorName="#e6e6e6" start="2,1" stop="2,1"/>
  53     </blockTableStyle>
  54     <blockTableStyle id="Table6">
  55       <blockAlignment value="LEFT"/>
  56       <blockValign value="TOP"/>
  57       <lineStyle kind="GRID" colorName="black"/>
  58     </blockTableStyle>
  59     <blockTableStyle id="Table2">
  60        <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
  61        <lineStyle kind="LINEBELOW" colorName="#000000" start="0,1" stop="-1,1"/>
  62       <!--<lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,2" stop="-1,-1"/>
  63        <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
  64        <lineStyle kind="LINEBELOW" colorName="#000000" start="0,1" stop="-1,1"/> -->
  65     <blockValign value="TOP"/>
  66     <blockAlignment value="RIGHT" start="2,1" stop="-1,-1"/>
  67     </blockTableStyle>
  68     <blockTableStyle id="Table3">
  69       <blockAlignment value="LEFT"/>
  70       <blockValign value="TOP"/>
  71     </blockTableStyle>
  72     <blockTableStyle id="Table4">
  73       <blockAlignment value="LEFT"/>
  74       <blockValign value="TOP"/>
  75       <lineStyle kind="GRID" colorName="black"/>
  76     </blockTableStyle>
  77    <blockTableStyle id="Tableau3">
  78       <blockAlignment value="LEFT"/>
  79       <blockValign value="TOP"/>
  80       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" />
  81       <lineStyle kind="OUTLINE" colorName="#e6e6e6" />
  82       <blockBackground colorName="white" start="0,0" stop="-1,0"/>
  83     </blockTableStyle>
  84     <initialize>
  85       <paraStyle name="all" alignment="justify"/>
  86     </initialize>
  87
  88     <paraStyle name="P3" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
  89     <paraStyle name="P4" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
  90     <paraStyle name="P5" fontName="Helvetica" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
  91     <paraStyle name="P6" fontName="Helvetica" fontSize="11.0" leading="14" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
  92
  93     <paraStyle name="P7" fontName="Helvetica-Bold" fontSize="9.0" leading="14" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
  94     <paraStyle name="P8" fontName="Helvetica-Bold" fontSize="9.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
  95
  96     <paraStyle name="P7" fontName="Helvetica-Bold" fontSize="8.5" leading="14" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
  97     <paraStyle name="P8" fontName="Helvetica-Bold" fontSize="8.5" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
  98
  99     <paraStyle name="P9" fontName="Helvetica" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
 100     <paraStyle name="P9b" fontName="Helvetica-Bold" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 101     <paraStyle name="P10" fontName="Helvetica" alignment="CENTER"/>
 102     <paraStyle name="P11" fontName="Helvetica" fontSize="8.0" leading="10"/>
 103     <paraStyle name="P12" fontName="Helvetica-Bold" fontSize="9.0" leading="14" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 104     <paraStyle name="P12a" fontName="Helvetica" fontSize="9.0" leading="14" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
 105     <paraStyle name="P12b" fontName="Helvetica" fontSize="9.0" leading="14" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 106     <paraStyle name="P13" fontName="Helvetica" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 107     <paraStyle name="P14" rightIndent="17.0" leftIndent="-0.0" fontName="Times-Bold" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 108     <paraStyle name="Standard" fontName="Helvetica"/>
 109     <paraStyle name="Text body" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 110     <paraStyle name="List" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 111     <paraStyle name="Table Contents" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 112     <paraStyle name="Table Heading" fontName="Helvetica" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 113     <paraStyle name="Caption" fontName="Helvetica" fontSize="10.0" leading="13" spaceBefore="6.0" spaceAfter="6.0"/>
 114     <paraStyle name="Index" fontName="Helvetica"/>
 115
 116      <blockTableStyle id="TrLevel8">
 117       <blockLeftPadding length="0" start="0,0" stop="-1,0"/>
 118     </blockTableStyle>
 119     <blockTableStyle id="TrLevel7">
 120       <blockLeftPadding length="0" start="0,0" stop="-1,0"/>
 121     </blockTableStyle>
 122     <blockTableStyle id="TrLevel6">
 123       <blockLeftPadding length="0" start="0,0" stop="-1,0"/>
 124      </blockTableStyle>
 125     <blockTableStyle id="TrLevel5">
 126       <blockLeftPadding length="0" start="0,0" stop="-1,0"/>
 127     </blockTableStyle>
 128     <blockTableStyle id="TrLevel4">
 129      <blockLeftPadding length="0" start="0,0" stop="-1,0"/>
 130     </blockTableStyle>
 131     <blockTableStyle id="TrLevel3">
 132      <lineStyle kind="LINEBELOW" colorName="#777777" start="1,0" stop="1,0"/>
 133       <blockLeftPadding length="0" start="0,3" stop="1,3"/>
 134     </blockTableStyle>
 135     <blockTableStyle id="TrLevel2">
 136       <lineStyle kind="LINEBELOW" colorName="#777777" start="1,0" stop="-1,0"/>
 137       <blockLeftPadding length="0" start="0,0" stop="1,0"/>
 138     </blockTableStyle>
 139         <blockTableStyle id="TrLevel1">
 140       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
 141       <blockLeftPadding length="0" start="0,0" stop="1,0"/>
 142     </blockTableStyle>
 143
 144     <blockTableStyle id="TrLevel0">
 145       <lineStyle kind="LINEBELOW" colorName="#777777" start="0,2" stop="1,2"/>
 146       <lineStyle kind="LINEBELOW" colorName="#ffffff" start="2,2" stop="-1,2"/>
 147     </blockTableStyle>
 148     <blockTableStyle id="LineLevel1">
 149                 <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,2" stop="-1,-1"/>
 150         </blockTableStyle>
 151
 152         <blockTableStyle id="Line1">
 153                 <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
 154         </blockTableStyle>
 155
 156         <blockTableStyle id="Line2">
 157        <lineStyle kind="LINEBELOW" colorName="#000000" start="0,1" stop="-1,1"/>
 158         </blockTableStyle>
 159
 160     <paraStyle
 161                 name="Level8"
 162                 fontName="Helvetica-Bold"
 163                 fontSize="8.0" />
 164      <paraStyle
 165                 name="Level7"
 166                 fontName="Helvetica-Bold"
 167                 fontSize="8.0" />
 168      <paraStyle
 169                 name="Level6"
 170                 fontName="Helvetica-Bold"
 171                 fontSize="8.0" />
 172     <paraStyle
 173                 name="Level5"
 174                 fontName="Helvetica-Bold"
 175                 fontSize="8.0" />
 176     <paraStyle
 177                 name="Level4"
 178                 fontName="Helvetica-Bold"
 179                 fontSize="8.0" />
 180     <paraStyle
 181                 name="Level3"
 182                 fontName="Helvetica-Bold"
 183                 fontSize="8.0" />
 184     <paraStyle name="Level2"
 185                 fontSize="8.0"
 186                 fontName="Helvetica-Bold"
 187                 />
 188         <paraStyle name="Level1"
 189                 fontSize="8.0"
 190                 fontName="Helvetica-Bold"
 191                 />
 192
 193         <paraStyle
 194                 name="Amt_Level8"
 195                 fontName="Helvetica-Bold"
 196                 fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 197      <paraStyle
 198                 name="Amt_Level7"
 199                 fontName="Helvetica-Bold"
 200                 fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 201      <paraStyle
 202                 name="Amt_Level6"
 203                 fontName="Helvetica-Bold"
 204                 fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 205     <paraStyle
 206                 name="Amt_Level5"
 207                 fontName="Helvetica-Bold"
 208                 fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 209     <paraStyle
 210                 name="Amt_Level4"
 211                 fontName="Helvetica-Bold"
 212                 fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 213     <paraStyle
 214                 name="Amt_Level3"
 215                 fontName="Helvetica-Bold"
 216                 fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 217     <paraStyle name="Amt_Level2"
 218                 fontSize="8.0"
 219                 fontName="Helvetica-Bold" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"
 220                 />
 221         <paraStyle name="Amt_Level1"
 222                 fontSize="8.0"
 223                 fontName="Helvetica-Bold" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"
 224                 />
 225
 226         <paraStyle
 227                 name="Det_Level8"
 228                 fontName="Times-Italic"
 229                 fontSize="8.0" leading="5"/>
 230      <paraStyle
 231                 name="Det_Level7"
 232                 fontName="Times-Italic"
 233                 fontSize="8.0" leading="5"/>
 234      <paraStyle
 235                 name="Det_Level6"
 236                 fontName="Times-Italic"
 237                 fontSize="8.0" leading="5"/>
 238     <paraStyle
 239                 name="Det_Level5"
 240                 fontName="Times-Italic"
 241                 fontSize="8.0" leading="5"/>
 242     <paraStyle
 243                 name="Det_Level4"
 244                 fontName="Times-Italic"
 245                 fontSize="8.0" leading="5"/>
 246     <paraStyle
 247                 name="Det_Level3"
 248                 fontName="Times-Italic"
 249                 fontSize="8.0" leading="5"/>
 250     <paraStyle name="Det_Level2"
 251                 fontSize="8.0" leading="5"
 252                 fontName="Times-Italic"
 253                 />
 254         <paraStyle name="Det_Level1"
 255                 fontSize="8.0" leading="5"
 256                 fontName="Times-Italic"
 257                 />
 258
 259         <paraStyle
 260                 name="Det_Amt_Level8"
 261                 fontName="Times-Italic"
 262                 fontSize="8.0" leading="5" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 263      <paraStyle
 264                 name="Det_Amt_Level7"
 265                 fontName="Times-Italic"
 266                 fontSize="8.0" leading="5" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 267      <paraStyle
 268                 name="Det_Amt_Level6"
 269                 fontName="Times-Italic"
 270                 fontSize="8.0" leading="5" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 271     <paraStyle
 272                 name="Det_Amt_Level5"
 273                 fontName="Times-Italic"
 274                 fontSize="8.0" leading="5" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 275     <paraStyle
 276                 name="Det_Amt_Level4"
 277                 fontName="Times-Italic"
 278                 fontSize="8.0" leading="5" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 279     <paraStyle
 280                 name="Det_Amt_Level3"
 281                 fontName="Times-Italic"
 282                 fontSize="8.0" leading="5" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 283     <paraStyle name="Det_Amt_Level2"
 284                 fontSize="8.0"
 285                 fontName="Times-Italic" leading="5" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"
 286                 />
 287         <paraStyle name="Det_Amt_Level1"
 288                 fontSize="8.0"
 289                 fontName="Times-Italic" leading="5" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"
 290                 />
 291
 292
 293   </stylesheet>
 294   <story>
 295          <blockTable colWidths="61.0,206.0,69.0,68.0,69.0,68.0" repeatRows="1" style="Table2">
 296       <tr>
 297         <td>
 298           <para style="P12a">[[ setTag('tr','tr',{'style':'Line1'}) ]] Code </para>
 299         </td>
 300         <td>
 301           <para style="P12a">Partner name</para>
 302         </td>
 303         <td>
 304           <para style="P12b">Débit</para>
 305         </td>
 306         <td>
 307           <para style="P12b">Crédit</para>
 308         </td>
 309         <td>
 310           <para style="P12b">Balance</para>
 311         </td>
 312         <td>
 313           <para style="P12b">In dispute</para>
 314         </td>
 315       </tr>
 316       <tr>
 317         <td>
 318           <para style="P7">[[ setTag('tr','tr',{'style':'Line2'}) ]] Grand total</para>
 319         </td>
 320         <td>
 321           <para style="P8"></para>
 322         </td>
 323         <td>
 324           <para style="P8"><u>[[ sum_debit(data) or '0.0' ]]</u></para>
 325         </td>
 326         <td>
 327           <para style="P8"><u>[[ sum_credit(data) or '0.0' ]]</u></para>
 328         </td>
 329         <td>
 330           <para style="P8"><u>[[ (solde_debit(data)-solde_credit(data)) or '0.0' ]]</u></para>
 331         </td>
 332         <td>
 333           <para style="P8"><u>[[ sum_litige(data) or '0.0' ]]</u></para>
 334         </td>
 335       </tr>
 336      <!-- <tr>
 337         <td>
 338           <para style="P7">Balance</para>
 339         </td><td>
 340         </td> <td>
 341         </td><td>
 342           <para style="P8">[[ solde_debit(data) or '0.0' ]]</para>
 343         </td>
 344         <td>
 345           <para style="P8">[[ solde_credit(data) or '0.0' ]]</para>
 346         </td>
 347         <td>
 348         </td>
 349       </tr> -->
 350       <tr>
 351         <td>
 352           <para style="P3">[[ repeatIn(lines(data), 'a') ]]<font face="Helvetica">[[ a['type']==3 and ( setTag('para','para',{'fontName':'Helvetica-Bold'})) ]] [[ a['ref'] ]] [[ a['type']==3 and a['code'] ]]</font></para>
 353         </td>
 354         <td>
 355           <para style="P3">[[ a['type']==3 and ( setTag('tr','tr',{'style':'TrLevel0'})) ]] [[ a['type']==3 and ( setTag('para','para',{'fontName':'Helvetica-Bold'})) ]] [[ a['type']==1 and ( setTag('blockTable','blockTable',{'style':'LineLevel1'})) ]] [[ a['name'] ]]</para>
 356         </td>
 357         <td>
 358           <para style="P4">
 359                 <font><u>[[ (a['type']==3 or removeParentNode('font')) and setTag('para','para',{'fontName':'Helvetica-Bold'}) ]] [[ a['debit'] or '0.0' ]]</u></font>
 360                 <font>[[ (a['type']!=3 or removeParentNode('font')) and setTag('para','para',{'fontName':'Helvetica'}) ]] [[ a['debit'] or '0.0' ]]</font>
 361                   </para>
 362         </td>
 363         <td>
 364           <para style="P4">
 365                 <font><u>[[ (a['type']==3 or removeParentNode('font')) and setTag('para','para',{'fontName':'Helvetica-Bold'}) ]] [[ a['credit'] or '0.0' ]]</u></font>
 366                 <font>[[ (a['type']!=3 or removeParentNode('font')) and setTag('para','para',{'fontName':'Helvetica'}) ]] [[ a['credit'] or '0.0' ]]</font>
 367                   </para>
 368         </td>
 369         <td>
 370           <para style="P4">
 371                 <font><u>[[ (a['type']==3 or removeParentNode('font')) and setTag('para','para',{'fontName':'Helvetica-Bold'}) ]] [[ a['balance'] or '0.0' ]]</u></font>
 372                 <font>[[ (a['type']!=3 or removeParentNode('font')) and setTag('para','para',{'fontName':'Helvetica'}) ]] [[ a['balance'] or '0.0' ]]</font>
 373                   </para>
 374         </td>
 375         <td>
 376           <para style="P4">
 377                 <font><u>[[ (a['type']==3 or removeParentNode('font')) and setTag('para','para',{'fontName':'Helvetica-Bold'}) ]] [[ a['enlitige'] or '0.0' ]]</u></font>
 378                 <font>[[ (a['type']!=3 or removeParentNode('font')) and setTag('para','para',{'fontName':'Helvetica'}) ]] [[ a['enlitige'] or '0.0' ]]</font>
 379                   </para>
 380         </td>
 381       </tr>
 382     </blockTable>
 383   </story>
 384 </document>