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"> [[ formatLang(time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()),date_time = True) ]]</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       <blockValign value="TOP"/>
  61       <blockAlignment value="RIGHT"/>
  62       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
  63       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,1" stop="-1,1"/>
  64       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,2" stop="-1,-1"/>
  65
  66     </blockTableStyle>
  67     <blockTableStyle id="Table3">
  68       <blockAlignment value="LEFT"/>
  69       <blockValign value="TOP"/>
  70     </blockTableStyle>
  71     <blockTableStyle id="Table4">
  72       <blockAlignment value="LEFT"/>
  73       <blockValign value="TOP"/>
  74       <lineStyle kind="LINEBEFORE" colorName="#FFFFFF" start="0,0" stop="0,-1"/>
  75       <lineStyle kind="LINEABOVE" colorName="#FFFFFF" start="0,0" stop="0,0"/>
  76       <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="0,-1" stop="0,-1"/>
  77       <lineStyle kind="LINEBEFORE" colorName="#FFFFFF" start="1,0" stop="1,-1"/>
  78       <lineStyle kind="LINEABOVE" colorName="#FFFFFF" start="1,0" stop="1,0"/>
  79       <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="1,-1" stop="1,-1"/>
  80       <lineStyle kind="LINEBEFORE" colorName="#FFFFFF" start="2,0" stop="2,-1"/>
  81       <lineStyle kind="LINEABOVE" colorName="#FFFFFF" start="2,0" stop="2,0"/>
  82       <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="2,-1" stop="2,-1"/>
  83       <lineStyle kind="LINEBEFORE" colorName="#FFFFFF" start="3,0" stop="3,-1"/>
  84       <lineStyle kind="LINEAFTER" colorName="#FFFFFF" start="3,0" stop="3,-1"/>
  85       <lineStyle kind="LINEABOVE" colorName="#FFFFFF" start="3,0" stop="3,0"/>
  86       <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="3,-1" stop="3,-1"/>
  87     </blockTableStyle>
  88     <initialize>
  89       <paraStyle name="all" alignment="justify"/>
  90     </initialize>
  91     <paraStyle name="P1" fontName="Helvetica-Bold" fontSize="20.0" leading="25" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
  92     <paraStyle name="P2" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
  93     <paraStyle name="P3" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
  94     <paraStyle name="P10" fontName="Helvetica" fontSize="8.0" leading="14" spaceBefore="0.0" spaceAfter="6.0" alignment="RIGHT"/>
  95    <paraStyle name="P9" fontName="Helvetica-Bold" alignment="CENTER" fontSize="14.5" leftIndent="-5.0"/>
  96     <paraStyle name="P9a" fontName="Helvetica-Bold" fontSize="9" leftIndent="0.0" alignment="LEFT"/>
  97     <paraStyle name="P9b" fontName="Helvetica" fontSize="9" leftIndent="0.0" alignment="LEFT"/>
  98     <paraStyle name="P9b" fontName="Helvetica" fontSize="8" leftIndent="-5.0" alignment="LEFT"/>
  99     <paraStyle name="P12" fontName="Helvetica-Bold" fontSize="8.0" leading="14" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 100     <paraStyle name="P12a" fontName="Helvetica" fontSize="8.0" leading="14" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
 101     <paraStyle name="P12b" fontName="Helvetica" fontSize="8.0" leading="14" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 102     <paraStyle name="P14" rightIndent="17.0" leftIndent="-0.0" fontName="Helvetica-Bold" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 103
 104
 105     <blockTableStyle id="TrLevel">
 106       <blockLeftPadding length="0" start="1,0" stop="1,0"/>
 107     </blockTableStyle>
 108     <blockTableStyle id="TrLevel2">
 109       <blockLeftPadding length="0" start="1,0" stop="1,0"/>
 110       <lineStyle kind="LINEBELOW" colorName="#777777" start="1,0" stop="1,0"/>
 111       <blockTopPadding length="13" start="0,0" stop="-1,0"/>
 112       <blockBottomPadding length="2" start="0,0" stop="-1,0"/>
 113           <blockFont name="Times-Bold" start="0,0" stop="-1,-1"/>
 114     </blockTableStyle>
 115     <blockTableStyle id="TrLevel1">
 116       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
 117       <blockLeftPadding length="0" start="1,0" stop="1,0"/>
 118       <blockTopPadding length="26" start="0,0" stop="-1,0"/>
 119       <blockBottomPadding length="2" start="0,0" stop="-1,0"/>
 120           <blockFont name="Times-Bold" start="0,0" stop="-1,-1"/>
 121     </blockTableStyle>
 122
 123    <paraStyle
 124                 name="Level"
 125                 fontName="Helvetica"
 126                 fontSize="8.0" />
 127     <paraStyle
 128                 name="Level2"
 129                 fontName="Helvetica-Bold"
 130                 fontSize="8.0" />
 131     <paraStyle name="Level1"
 132                 fontSize="8.0"
 133                 fontName="Helvetica-Bold"
 134                 />
 135     <paraStyle name="Caption" fontName="Helvetica" fontSize="10.0" leading="13" spaceBefore="6.0" spaceAfter="6.0"/>
 136     <paraStyle name="Index" fontName="Helvetica"/>
 137   </stylesheet>
 138   <images/>
 139   <story>
 140 <para style="P2">
 141 <font color="white"> </font>
 142 </para>
 143 <para style="P2">
 144 <font color="white"> </font>
 145 </para>
 146 <blockTable colWidths="527.00" style="Table4" repeatRows="1">
 147       <tr>
 148         <td>
 149           <para style="P9a">[[ get_fiscalyear(data['form']) or removeParentNode('para') ]]:</para>
 150           <para style="P9b"><i> [[ get_periods(data['form']) or removeParentNode('para') ]]</i></para>
 151         </td>
 152       </tr>
 153 </blockTable>
 154
 155 <para style="P2">
 156 <font color="white"> </font>
 157 </para>
 158     <blockTable colWidths="46,278.0,73.0,72.0,82.0" style="Table2" repeatRows="1">
 159       <tr noRowsplits="1">
 160         <td>
 161           <para style="P12a">Code</para>
 162         </td>
 163         <td>
 164           <para style="P12b">Account</para>
 165         </td>
 166         <td>
 167           <para style="P10">Debit</para>
 168         </td>
 169         <td>
 170           <para style="P10">Credit</para>
 171         </td>
 172         <td>
 173           <para style="P10">Balance</para>
 174         </td>
 175       </tr>
 176       <tr>
 177                 <td><para style="P14">[[ repeatIn(lines(data['form']), 'a') ]]<i>[[ a['code'] or removeParentNode('tr')  ]]</i></para></td>
 178         <td>
 179                <para style="P14">
 180                 <font>[[ (a['level']&lt;3 and setTag('tr','tr',{'style':'TrLevel'+str(a['level']), 'paraStyle':('Level'+str(a['level']))})) or removeParentNode('font') ]]</font>
 181                 <font>[[ (a['level']&gt;2 and setTag('tr','tr',{'style':'TrLevel', 'paraStyle':('Level')})) or removeParentNode('font') ]] </font>
 182                 <font color="white">[[ '...'*(a['level']) ]]</font><font>[[ a['name'] ]]</font></para>
 183         </td>
 184         <td>
 185                 <para style="P3"><font>[[ a['type']=='view' and removeParentNode('font') ]][[ formatLang(a['debit']) ]]</font>
 186                         <font>[[ a['type']&lt;&gt;'view' and removeParentNode('font') ]] [[formatLang(a['debit']) ]]</font></para>
 187         </td>
 188         <td>
 189                 <para style="P3"><font>[[ a['type']=='view' and removeParentNode('font') ]][[ formatLang(a['credit']) ]]</font>
 190                         <font>[[ a['type']&lt;&gt;'view' and removeParentNode('font') ]] [[ formatLang(a['credit']) ]]</font></para>
 191         </td>
 192         <td>
 193                 <para style="P3"><font>[[ a['type']=='view' and removeParentNode('font') ]][[ formatLang(a['balance']) ]]</font>
 194                         <font>[[ a['type']&lt;&gt;'view' and removeParentNode('font') ]] [[ formatLang(a['balance'])  ]]</font></para>
 195         </td>
 196       </tr>
 197     </blockTable>
 198   </story>
 199 </document>