addons/account/report/account_balance_landscape.rml

   1 <?xml version="1.0"?>
   2 <document filename="Account Balance.pdf">
   3   <template pageSize="(842.0,595.0)" title="Account Balance" author="OpenERP S.A.(sales@openerp.com)" allowSplitting="20">
   4     <pageTemplate id="first">
   5       <frame id="first" x1="28.0" y1="28.0" width="786" height="539"/>
   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_Tiltle">
  14       <blockAlignment value="LEFT"/>
  15       <blockValign value="TOP"/>
  16     </blockTableStyle>
  17     <blockTableStyle id="Table_header_account">
  18       <blockAlignment value="LEFT"/>
  19       <blockValign value="TOP"/>
  20       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
  21       <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
  22       <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
  23       <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
  24       <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
  25       <lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
  26       <blockBackground colorName="#b3b3b3" start="0,0" stop="0,-1"/>
  27       <blockBackground colorName="#b3b3b3" start="1,0" stop="1,-1"/>
  28       <blockBackground colorName="#b3b3b3" start="2,0" stop="2,-1"/>
  29       <blockBackground colorName="#b3b3b3" start="3,0" stop="3,-1"/>
  30       <blockBackground colorName="#b3b3b3" start="4,0" stop="4,-1"/>
  31       <blockBackground colorName="#b3b3b3" start="5,0" stop="5,-1"/>
  32     </blockTableStyle>
  33     <blockTableStyle id="Table1">
  34       <blockAlignment value="LEFT"/>
  35       <blockValign value="TOP"/>
  36       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
  37       <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
  38       <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
  39       <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
  40       <blockBackground colorName="#b3b3b3" start="0,0" stop="0,-1"/>
  41       <blockBackground colorName="#b3b3b3" start="1,0" stop="1,-1"/>
  42       <blockBackground colorName="#b3b3b3" start="2,0" stop="2,-1"/>
  43       <blockBackground colorName="#b3b3b3" start="3,0" stop="3,-1"/>
  44     </blockTableStyle>
  45     <blockTableStyle id="Table4">
  46       <blockAlignment value="LEFT"/>
  47       <blockValign value="TOP"/>
  48       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
  49       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
  50       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
  51       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,-1" stop="3,-1"/>
  52       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="4,-1" stop="4,-1"/>
  53       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="5,-1" stop="5,-1"/>
  54     </blockTableStyle>
  55     <blockTableStyle id="Table2">
  56       <blockAlignment value="LEFT"/>
  57       <blockValign value="TOP"/>
  58       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
  59       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
  60       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
  61       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,-1" stop="3,-1"/>
  62       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="4,-1" stop="4,-1"/>
  63       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="5,-1" stop="5,-1"/>
  64       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="6,-1" stop="6,-1"/>
  65     </blockTableStyle>
  66     <blockTableStyle id="Table6">
  67       <blockAlignment value="LEFT"/>
  68       <blockValign value="TOP"/>
  69       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
  70       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
  71       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
  72       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,-1" stop="3,-1"/>
  73     </blockTableStyle>
  74     <blockTableStyle id="Table5">
  75       <blockAlignment value="LEFT"/>
  76       <blockValign value="TOP"/>
  77       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
  78       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
  79       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
  80       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,-1" stop="3,-1"/>
  81       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="4,-1" stop="4,-1"/>
  82     </blockTableStyle>
  83     <blockTableStyle id="Table3">
  84       <blockAlignment value="LEFT"/>
  85       <blockValign value="TOP"/>
  86       <lineStyle kind="LINEABOVE" colorName="#000000" start="0,0" stop="0,0"/>
  87       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
  88       <lineStyle kind="LINEABOVE" colorName="#000000" start="1,0" stop="1,0"/>
  89       <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
  90       <lineStyle kind="LINEABOVE" colorName="#000000" start="2,0" stop="2,0"/>
  91       <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
  92       <lineStyle kind="LINEABOVE" colorName="#000000" start="3,0" stop="3,0"/>
  93       <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
  94       <lineStyle kind="LINEABOVE" colorName="#000000" start="4,0" stop="4,0"/>
  95       <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
  96       <blockBackground colorName="#cccccc" start="0,0" stop="0,-1"/>
  97       <blockBackground colorName="#cccccc" start="1,0" stop="1,-1"/>
  98       <blockBackground colorName="#cccccc" start="2,0" stop="2,-1"/>
  99       <blockBackground colorName="#cccccc" start="3,0" stop="3,-1"/>
 100       <blockBackground colorName="#cccccc" start="4,0" stop="4,-1"/>
 101     </blockTableStyle>
 102     <initialize>
 103       <paraStyle name="all" alignment="justify"/>
 104     </initialize>
 105     <paraStyle name="Standard" fontName="Helvetica"/>
 106     <paraStyle name="Heading" fontName="Helvetica" fontSize="12.0" leading="15" spaceBefore="12.0" spaceAfter="6.0"/>
 107     <paraStyle name="Text body" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 108     <paraStyle name="List" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
 109     <paraStyle name="Caption" fontName="Helvetica-Oblique" fontSize="8.0" leading="10" spaceBefore="6.0" spaceAfter="6.0"/>
 110     <paraStyle name="Index" fontName="Helvetica" fontSize="9.0" leading="11"/>
 111     <paraStyle name="Footer" fontName="Helvetica"/>
 112     <paraStyle name="Table Contents" fontName="Helvetica"/>
 113     <paraStyle name="Table Heading" fontName="Helvetica" alignment="CENTER"/>
 114     <paraStyle name="Horizontal Line" fontName="Helvetica" fontSize="6.0" leading="8" spaceBefore="0.0" spaceAfter="14.0"/>
 115     <paraStyle name="terp_header" fontName="Helvetica-Bold" fontSize="12.0" leading="15" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
 116     <paraStyle name="Heading 9" fontName="Helvetica-Bold" fontSize="75%" leading="NaN" spaceBefore="12.0" spaceAfter="6.0"/>
 117     <paraStyle name="terp_tblheader_General" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
 118     <paraStyle name="terp_tblheader_Details" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 119     <paraStyle name="terp_default_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 120     <paraStyle name="terp_default_Bold_8" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 121     <paraStyle name="terp_tblheader_General_Centre" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
 122     <paraStyle name="terp_tblheader_General_Right" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 123     <paraStyle name="terp_tblheader_Details_Centre" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 124     <paraStyle name="terp_tblheader_Details_Right" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 125     <paraStyle name="terp_default_Right_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 126     <paraStyle name="terp_default_Centre_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 127     <paraStyle name="terp_header_Right" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
 128     <paraStyle name="terp_header_Centre" fontName="Helvetica-Bold" fontSize="15.0" leading="15" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 129     <paraStyle name="terp_default_address" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 130     <paraStyle name="terp_default_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 131     <paraStyle name="terp_default_Bold_9" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 132     <paraStyle name="terp_default_Centre_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 133     <paraStyle name="terp_default_Right_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 134     <paraStyle name="terp_default_space" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
 135     <paraStyle name="terp_default_2" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 136   </stylesheet>
 137   <images/>
 138   <story>
 139     <para style="terp_default_8">[[ repeatIn(get_years(data['form']), 'y') ]]</para>
 140     <blockTable colWidths="785.0" style="Table_Tiltle">
 141       <tr>
 142         <td>
 143           <para style="terp_header_Centre">Account Balance - [[ company.currency_id.name ]]</para>
 144         </td>
 145       </tr>
 146     </blockTable>
 147     <para style="terp_default_space">
 148       <font color="white"> </font>
 149     </para>
 150     <para style="terp_header">Year : [[ y['year'] ]]</para>
 151     <blockTable colWidths="56.0,198.0,95.0,110.0,105.0,164.0" style="Table_header_account">
 152       <tr>
 153         <td>
 154           <para style="terp_tblheader_Details">[[ data['form']['show_columns'] and 'Code' or removeParentNode('blockTable') ]]</para>
 155         </td>
 156         <td>
 157           <para style="terp_tblheader_Details">Account Name </para>
 158         </td>
 159         <td>
 160           <para style="terp_tblheader_Details">[[ data['form']['compare_pattern']!='none' and 'C.S.Y.T.(C./P)' or removeParentNode('font') ]]</para>
 161         </td>
 162         <td>
 163           <para style="terp_tblheader_Details_Right">Debit</para>
 164         </td>
 165         <td>
 166           <para style="terp_tblheader_Details_Right">Credit</para>
 167         </td>
 168         <td>
 169           <para style="terp_tblheader_Details_Centre">Balance</para>
 170         </td>
 171       </tr>
 172     </blockTable>
 173     <para style="terp_default_2">
 174       <font color="white"> </font>
 175     </para>
 176     <blockTable colWidths="56.0,198.0,206.0,268.0" style="Table1">
 177       <tr>
 178         <td>
 179           <para style="terp_tblheader_Details">[[ data['form']['show_columns'] and removeParentNode('blockTable') or 'Code' ]]</para>
 180         </td>
 181         <td>
 182           <para style="terp_tblheader_Details">Account Name </para>
 183         </td>
 184         <td>
 185           <para style="terp_tblheader_Details"><font>[[ data['form']['compare_pattern']!='none' and 'C.S.Y.T.(C./P)' or removeParentNode('font') ]]</font></para>
 186         </td>
 187         <td>
 188           <para style="terp_tblheader_Details_Centre">Balance</para>
 189         </td>
 190       </tr>
 191     </blockTable>
 192     <para style="terp_default_2">
 193       <font color="white"> </font>
 194     </para>
 195     <section>
 196       <para style="terp_default_8">[[ repeatIn(get_lines(y,data['form']), 'a') ]]</para>
 197       <blockTable colWidths="56.0,197.0,94.0,110.0,106.0,162.0" style="Table4">
 198         <tr>
 199           <td>
 200             <para style="terp_default_9">[[ (data['form']['format_perc'] or not data['form']['show_columns']) and removeParentNode('blockTable') ]] [[ a['code'] ]]</para>
 201           </td>
 202           <td>
 203             <para style="terp_default_9"><font color="white">[['.....'*(a['level']-1) ]]</font><font>[[ a['name'] ]]</font></para>
 204           </td>
 205           <td>
 206             <para style="terp_default_9">[[ a['pattern'] ]]</para>
 207           </td>
 208           <td>
 209             <para style="terp_default_Right_9">[[ a['debit'] ]]</para>
 210           </td>
 211           <td>
 212             <para style="terp_default_Right_9">[[ a['credit'] ]]</para>
 213           </td>
 214           <td>
 215             <para style="terp_default_Right_9">[[ a['balance'] ]]</para>
 216           </td>
 217         </tr>
 218       </blockTable>
 219       <para style="terp_default_2"/>
 220       <blockTable colWidths="56.0,197.0,94.0,110.0,107.0,85.0,77.0" style="Table2">
 221         <tr>
 222           <td>
 223             <para style="terp_default_9">[[ (not data['form']['format_perc'] or not data['form']['show_columns']) and removeParentNode('blockTable') ]] [[ a['code'] ]]</para>
 224           </td>
 225           <td>
 226             <para style="terp_default_9"><font color="white">[['.....'*(a['level']-1) ]]</font> <font>[[ a['name'] ]]</font></para>
 227           </td>
 228           <td>
 229             <para style="terp_default_9">[[ a['pattern'] ]]</para>
 230           </td>
 231           <td>
 232             <para style="terp_default_Right_9">[[ a['debit'] ]]</para>
 233           </td>
 234           <td>
 235             <para style="terp_default_Right_9">[[ a['credit'] ]]</para>
 236           </td>
 237           <td>
 238             <para style="terp_default_Right_9">[[ a['balance'] ]]</para>
 239           </td>
 240           <td>
 241             <para style="terp_default_Right_9">[[ a['balance_perc'] ]]</para>
 242           </td>
 243         </tr>
 244       </blockTable>
 245       <para style="terp_default_2">
 246         <font color="white"> </font>
 247       </para>
 248       <blockTable colWidths="55.0,197.0,94.0,380.0" style="Table6">
 249         <tr>
 250           <td>
 251             <para style="terp_default_9">[[ (data['form']['format_perc'] or data['form']['show_columns']) and removeParentNode('blockTable') ]] [[ a['code'] ]]</para>
 252           </td>
 253           <td>
 254             <para style="terp_default_9"><font color="white">[['.....'*(a['level']-1) ]]</font><font> [[ a['name'] ]]</font></para>
 255           </td>
 256           <td>
 257             <para style="terp_default_9">[[ a['pattern'] ]]</para>
 258           </td>
 259           <td>
 260             <para style="terp_default_Right_9">[[ a['balance'] ]]</para>
 261           </td>
 262         </tr>
 263       </blockTable>
 264       <para style="terp_default_2">
 265         <font color="white"> </font>
 266       </para>
 267       <blockTable colWidths="54.0,197.0,94.0,275.0,106.0" style="Table5">
 268         <tr>
 269           <td>
 270             <para style="terp_default_9">[[ (not data['form']['format_perc'] or data['form']['show_columns']) and removeParentNode('blockTable') ]] [[ a['code'] ]]</para>
 271           </td>
 272           <td>
 273             <para style="terp_default_9"><font color="white">[['.....'*(a['level']-1) ]]</font> <font> [[ a['name'] ]]</font></para>
 274           </td>
 275           <td>
 276             <para style="terp_default_9">[[ a['pattern'] ]]</para>
 277           </td>
 278           <td>
 279             <para style="terp_default_Right_9">[[ a['balance'] ]]</para>
 280           </td>
 281           <td>
 282             <para style="terp_default_Right_9">[[ a['balance_perc'] ]]</para>
 283           </td>
 284         </tr>
 285       </blockTable>
 286       <para style="terp_default_2"/>
 287     </section>
 288     <para style="terp_default_9">
 289       <font color="white"> </font>
 290     </para>
 291     <blockTable colWidths="52.0,291.0,112.0,107.0,164.0" style="Table3">
 292       <tr>
 293         <td>
 294           <para style="terp_default_9">[[ not data['form']['show_columns'] and removeParentNode('blockTable') ]] </para>
 295         </td>
 296         <td>
 297           <para style="terp_tblheader_Details">Total :</para>
 298         </td>
 299         <td>
 300           <para style="terp_tblheader_Details_Right">[[ total_dr() ]]</para>
 301         </td>
 302         <td>
 303           <para style="terp_tblheader_Details_Right">[[ total_cr() ]]</para>
 304         </td>
 305         <td>
 306           <para style="terp_default_Right_9">
 307             <font color="white"> </font>
 308           </para>
 309         </td>
 310       </tr>
 311     </blockTable>
 312     <para style="terp_default_space">
 313       <font color="white"> </font>
 314     </para>
 315     <para style="terp_tblheader_Details">[[ data['form']['compare_pattern']!='none' and "C.S.Y.T.(C./P) : Compare Selected Years In Terms of Cash/Perc" or removeParentNode('font') ]]</para>
 316   </story>
 317 </document>