addons/account/report/account_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           <pageGraphics>
   7                         <setFont name="Helvetica-Bold" size="9"/>
   8
   9
  10                                 <!--COL 1-->
  11                                 <drawString x="1.0cm" y="28.1cm">[[ company.name ]]</drawString>
  12                                 <drawString x="16.2cm" y="28.1cm">Account Balance - [[ company.currency_id.name ]]</drawString>
  13
  14                                 <!--COL 2-->
  15                                 <setFont name="Helvetica" size="9"/>
  16                                 <drawString x="1.0cm" y="1cm"> [[ time.strftime("%m-%d-%y %H:%M", time.localtime()) ]]</drawString>
  17                                 <drawString x="19.0cm" y="1cm">Page <pageNumber/></drawString>
  18
  19                             <lineMode width="0.7"/>
  20                                 <lines>1cm 27.7cm 20cm 27.7cm</lines>
  21                                 <setFont name="Helvetica" size="8"/>
  22
  23         </pageGraphics>
  24
  25     </pageTemplate>
  26   </template>
  27   <stylesheet>
  28     <blockTableStyle id="Standard_Outline">
  29       <blockAlignment value="LEFT"/>
  30       <blockValign value="TOP"/>
  31     </blockTableStyle>
  32     <blockTableStyle id="Table1">
  33       <blockAlignment value="LEFT"/>
  34       <blockValign value="TOP"/>
  35       <blockBackground colorName="#e6e6e6" start="0,0" stop="0,-1"/>
  36       <blockBackground colorName="#e6e6e6" start="1,0" stop="1,-1"/>
  37       <blockBackground colorName="#e6e6e6" start="2,0" stop="2,-1"/>
  38       <blockBackground colorName="#e6e6e6" start="0,1" stop="0,-1"/>
  39       <blockBackground colorName="#e6e6e6" start="1,1" stop="1,-1"/>
  40       <blockBackground colorName="#e6e6e6" start="2,1" stop="2,-1"/>
  41     </blockTableStyle>
  42     <blockTableStyle id="Table6">
  43       <blockAlignment value="LEFT"/>
  44       <blockValign value="TOP"/>
  45       <lineStyle kind="LINEBEFORE" colorName="#000000" start="0,0" stop="0,-1"/>
  46       <lineStyle kind="LINEABOVE" colorName="#000000" start="0,0" stop="0,0"/>
  47       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
  48       <lineStyle kind="LINEBEFORE" colorName="#000000" start="1,0" stop="1,-1"/>
  49       <lineStyle kind="LINEABOVE" colorName="#000000" start="1,0" stop="1,0"/>
  50       <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
  51       <lineStyle kind="LINEBEFORE" colorName="#000000" start="2,0" stop="2,-1"/>
  52       <lineStyle kind="LINEABOVE" colorName="#000000" start="2,0" stop="2,0"/>
  53       <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
  54       <lineStyle kind="LINEBEFORE" colorName="#000000" start="3,0" stop="3,-1"/>
  55       <lineStyle kind="LINEAFTER" 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     </blockTableStyle>
  59     <blockTableStyle id="Table2">
  60       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
  61       <blockValign value="TOP"/>
  62       <blockAlignment value="RIGHT" start="2,1" stop="-1,-1"/>
  63     </blockTableStyle>
  64     <blockTableStyle id="Table3">
  65       <blockAlignment value="LEFT"/>
  66       <blockValign value="TOP"/>
  67     </blockTableStyle>
  68     <blockTableStyle id="Table4">
  69       <blockAlignment value="LEFT"/>
  70       <blockValign value="TOP"/>
  71       <lineStyle kind="LINEBEFORE" colorName="#FFFFFF" start="0,0" stop="0,-1"/>
  72       <lineStyle kind="LINEABOVE" colorName="#FFFFFF" start="0,0" stop="0,0"/>
  73       <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="0,-1" stop="0,-1"/>
  74       <lineStyle kind="LINEBEFORE" colorName="#FFFFFF" start="1,0" stop="1,-1"/>
  75       <lineStyle kind="LINEABOVE" colorName="#FFFFFF" start="1,0" stop="1,0"/>
  76       <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="1,-1" stop="1,-1"/>
  77       <lineStyle kind="LINEBEFORE" colorName="#FFFFFF" start="2,0" stop="2,-1"/>
  78       <lineStyle kind="LINEABOVE" colorName="#FFFFFF" start="2,0" stop="2,0"/>
  79       <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="2,-1" stop="2,-1"/>
  80       <lineStyle kind="LINEBEFORE" colorName="#FFFFFF" start="3,0" stop="3,-1"/>
  81       <lineStyle kind="LINEAFTER" colorName="#FFFFFF" start="3,0" stop="3,-1"/>
  82       <lineStyle kind="LINEABOVE" colorName="#FFFFFF" start="3,0" stop="3,0"/>
  83       <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="3,-1" stop="3,-1"/>
  84     </blockTableStyle>
  85     <initialize>
  86       <paraStyle name="all" alignment="justify"/>
  87     </initialize>
  88     <paraStyle name="P1" fontName="Helvetica" fontSize="20.0" leading="25" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
  89     <paraStyle name="P2" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
  90     <paraStyle name="P3" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
  91     <paraStyle name="P10" fontName="Helvetica" fontSize="8.0" leading="14" spaceBefore="0.0" spaceAfter="6.0" alignment="RIGHT"/>
  92    <paraStyle name="P9" fontName="Helvetica-Bold" alignment="CENTER" fontSize="14.5" leftIndent="-5.0"/>
  93     <paraStyle name="P9a" fontName="Helvetica-Bold" fontSize="9" leftIndent="0.0" alignment="LEFT"/>
  94     <paraStyle name="P9b" fontName="Helvetica" fontSize="9" leftIndent="0.0" alignment="LEFT"/>
  95     <paraStyle name="P9b" fontName="Helvetica" fontSize="8" leftIndent="-5.0" alignment="LEFT"/>
  96     <paraStyle name="P12" fontName="Helvetica" fontSize="8.0" leading="14" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
  97     <paraStyle name="P12a" fontName="Helvetica" fontSize="8.0" leading="14" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
  98     <paraStyle name="P14" rightIndent="17.0" leftIndent="-0.0" fontName="Helvetica" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
  99
 100
 101     <blockTableStyle id="TrLevel8">
 102       <blockLeftPadding length="100" start="1,0" stop="1,0"/>
 103     </blockTableStyle>
 104     <blockTableStyle id="TrLevel7">
 105       <blockLeftPadding length="80" start="1,0" stop="1,0"/>
 106     </blockTableStyle>
 107     <blockTableStyle id="TrLevel6">
 108       <blockLeftPadding length="60" start="1,0" stop="1,0"/>
 109     </blockTableStyle>
 110     <blockTableStyle id="TrLevel5">
 111       <blockLeftPadding length="40" start="1,0" stop="1,0"/>
 112     </blockTableStyle>
 113     <blockTableStyle id="TrLevel4">
 114       <blockLeftPadding length="20" start="1,0" stop="1,0"/>
 115     </blockTableStyle>
 116     <blockTableStyle id="TrLevel3">
 117       <blockLeftPadding length="0" start="1,0" stop="1,0"/>
 118     </blockTableStyle>
 119     <blockTableStyle id="TrLevel2">
 120       <blockLeftPadding length="0" start="1,0" stop="1,0"/>
 121       <lineStyle kind="LINEBELOW" colorName="#777777" start="1,0" stop="1,0"/>
 122       <blockTopPadding length="13" start="0,0" stop="-1,0"/>
 123       <blockBottomPadding length="2" start="0,0" stop="-1,0"/>
 124           <blockFont name="Times-Bold" start="0,0" stop="-1,-1"/>
 125     </blockTableStyle>
 126     <blockTableStyle id="TrLevel1">
 127       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
 128       <blockLeftPadding length="0" start="1,0" stop="1,0"/>
 129       <blockTopPadding length="26" start="0,0" stop="-1,0"/>
 130       <blockBottomPadding length="2" start="0,0" stop="-1,0"/>
 131           <blockFont name="Times-Bold" start="0,0" stop="-1,-1"/>
 132     </blockTableStyle>
 133
 134
 135     <paraStyle
 136                 name="Level8"
 137                 fontName="Helvetica"
 138                 fontSize="8.0" />
 139     <paraStyle
 140                 name="Level7"
 141                 fontName="Helvetica"
 142                 fontSize="8.0" />
 143     <paraStyle
 144                 name="Level6"
 145                 fontName="Helvetica"
 146                 fontSize="8.0" />
 147     <paraStyle
 148                 name="Level5"
 149                 fontName="Helvetica"
 150                 fontSize="8.0" />
 151     <paraStyle
 152                 name="Level4"
 153                 fontName="Helvetica"
 154                 fontSize="8.0" />
 155     <paraStyle
 156                 name="Level3"
 157                 fontName="Helvetica"
 158                 fontSize="8.0" />
 159     <paraStyle
 160                 name="Level2"
 161                 firstLineIndent="-0.03cm"
 162                 fontName="Helvetica-Bold"
 163                 fontSize="8.0" />
 164     <paraStyle name="Level1"
 165                 fontSize="8.0"
 166                 fontName="Helvetica-Bold"
 167                 />
 168     <paraStyle name="Caption" fontName="Helvetica" fontSize="10.0" leading="13" spaceBefore="6.0" spaceAfter="6.0"/>
 169     <paraStyle name="Index" fontName="Helvetica"/>
 170   </stylesheet>
 171   <images/>
 172   <story>
 173 <para style="P2">
 174 <font color="white"> </font>
 175 </para>
 176 <para style="P2">
 177 <font color="white"> </font>
 178 </para>
 179 <blockTable colWidths="527.00" style="Table4" repeatRows="1">
 180       <tr>
 181         <td>
 182           <para style="P9a">[[ get_fiscalyear(data['form']) or removeParentNode('para') ]]:</para>
 183           <para style="P9b"><i> [[ get_periods(data['form']) or removeParentNode('para') ]]</i></para>
 184         </td>
 185       </tr>
 186 </blockTable>
 187
 188 <para style="P2">
 189 <font color="white"> </font>
 190 </para>
 191     <blockTable colWidths="46,278.0,73.0,72.0,82.0" style="Table2" repeatRows="1">
 192       <tr noRowsplits="1">
 193         <td>
 194           <para style="P12a">Code</para>
 195         </td>
 196         <td>
 197           <para style="P12">Account</para>
 198         </td>
 199         <td>
 200           <para style="P10">Debit</para>
 201         </td>
 202         <td>
 203           <para style="P10">Credit</para>
 204         </td>
 205         <td>
 206           <para style="P10">Balance</para>
 207         </td>
 208       </tr>
 209       <tr>
 210                 <td><para style="P14">[[ repeatIn(lines(data['form']), 'a') ]]<i>[[ a['code'] or removeParentNode('tr')  ]]</i></para></td>
 211         <td>
 212
 213           <para style="P14">[[ setTag('tr','tr',{'style':'TrLevel'+str(a['level']), 'paraStyle':('Level'+str(a['level']))}) ]]<font></font>
 214           [[ a['name'] ]]</para>
 215         </td>
 216         <td>
 217                 <para style="P3"><font>[[ a['type']=='view' and removeParentNode('font') ]][[ formatLang(a['debit']) ]]</font>
 218                         <font>[[ a['type']&lt;&gt;'view' and removeParentNode('font') ]] [[formatLang(a['debit']) ]]</font></para>
 219         </td>
 220         <td>
 221                 <para style="P3"><font>[[ a['type']=='view' and removeParentNode('font') ]][[ formatLang(a['credit']) ]]</font>
 222                         <font>[[ a['type']&lt;&gt;'view' and removeParentNode('font') ]] [[ formatLang(a['credit']) ]]</font></para>
 223         </td>
 224         <td>
 225                 <para style="P3"><font>[[ a['type']=='view' and removeParentNode('font') ]][[ formatLang(a['balance']) ]]</font>
 226                         <font>[[ a['type']&lt;&gt;'view' and removeParentNode('font') ]] [[ formatLang(a['balance'])  ]]</font></para>
 227         </td>
 228       </tr>
 229     </blockTable>
 230   </story>
 231 </document>