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="#e6e6e6" start="0,1" stop="-1,-1"/>
  64     </blockTableStyle>
  65     <blockTableStyle id="Table3">
  66       <blockAlignment value="LEFT"/>
  67       <blockValign value="TOP"/>
  68     </blockTableStyle>
  69         <blockTableStyle id="Table3a">
  70       <blockAlignment value="LEFT"/>
  71       <blockValign value="TOP"/>
  72       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="0,0" stop="0,-1"/>
  73       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="0,0" stop="0,0"/>
  74       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,-1" stop="0,-1"/>
  75       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="1,0" stop="1,-1"/>
  76       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="1,0" stop="1,0"/>
  77       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="1,-1" stop="1,-1"/>
  78       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="2,0" stop="2,-1"/>
  79       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="2,0" stop="2,0"/>
  80       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="2,-1" stop="2,-1"/>
  81       <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="3,0" stop="3,-1"/>
  82       <lineStyle kind="LINEAFTER" colorName="#e6e6e6" start="3,0" stop="3,-1"/>
  83       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="3,0" stop="3,0"/>
  84       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="3,-1" stop="3,-1"/>
  85       <lineStyle kind="LINEAFTER" colorName="#e6e6e6" start="4,0" stop="4,-1"/>
  86       <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="4,0" stop="4,0"/>
  87       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="4,-1" stop="4,-1"/>
  88     </blockTableStyle>
  89
  90     <blockTableStyle id="Table4">
  91       <blockAlignment value="LEFT"/>
  92       <blockValign value="TOP"/>
  93       <lineStyle kind="LINEBEFORE" colorName="#FFFFFF" start="0,0" stop="0,-1"/>
  94       <lineStyle kind="LINEABOVE" colorName="#FFFFFF" start="0,0" stop="0,0"/>
  95       <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="0,-1" stop="0,-1"/>
  96       <lineStyle kind="LINEBEFORE" colorName="#FFFFFF" start="1,0" stop="1,-1"/>
  97       <lineStyle kind="LINEABOVE" colorName="#FFFFFF" start="1,0" stop="1,0"/>
  98       <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="1,-1" stop="1,-1"/>
  99       <lineStyle kind="LINEBEFORE" colorName="#FFFFFF" start="2,0" stop="2,-1"/>
 100       <lineStyle kind="LINEABOVE" colorName="#FFFFFF" start="2,0" stop="2,0"/>
 101       <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="2,-1" stop="2,-1"/>
 102       <lineStyle kind="LINEBEFORE" colorName="#FFFFFF" start="3,0" stop="3,-1"/>
 103       <lineStyle kind="LINEAFTER" colorName="#FFFFFF" start="3,0" stop="3,-1"/>
 104       <lineStyle kind="LINEABOVE" colorName="#FFFFFF" start="3,0" stop="3,0"/>
 105       <lineStyle kind="LINEBELOW" colorName="#FFFFFF" start="3,-1" stop="3,-1"/>
 106     </blockTableStyle>
 107     <initialize>
 108       <paraStyle name="all" alignment="justify"/>
 109     </initialize>
 110     <paraStyle name="P1" fontName="Helvetica-Bold" fontSize="20.0" leading="25" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 111     <paraStyle name="P2" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
 112     <paraStyle name="P3" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
 113     <paraStyle name="P10" fontName="Helvetica-Bold" fontSize="8.0" leading="14" spaceBefore="0.0" spaceAfter="6.0" alignment="RIGHT"/>
 114    <paraStyle name="P9" fontName="Helvetica-Bold" alignment="CENTER" fontSize="14.5" leftIndent="-5.0"/>
 115     <paraStyle name="P9a" fontName="Helvetica-Bold" fontSize="9" leftIndent="0.0" alignment="LEFT"/>
 116     <paraStyle name="P9b" fontName="Helvetica" fontSize="9" leftIndent="0.0" alignment="LEFT"/>
 117     <paraStyle name="P9b" fontName="Helvetica" fontSize="8" leftIndent="-5.0" alignment="LEFT"/>
 118     <paraStyle name="P12" fontName="Helvetica-Bold" fontSize="8.0" leading="14" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 119     <paraStyle name="terp_default_Centre_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 120     <paraStyle name="terp_tblheader_General_Centre" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
 121     <paraStyle name="P12a" fontName="Helvetica-Bold" fontSize="8.0" leading="14" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
 122     <paraStyle name="P12b" fontName="Helvetica-Bold" fontSize="8.0" leading="14" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
 123     <paraStyle name="P14" rightIndent="17.0" leftIndent="-0.0" fontName="Helvetica-Bold" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="6.0"/>
 124
 125
 126     <blockTableStyle id="TrLevel">
 127       <blockLeftPadding length="0" start="1,0" stop="1,0"/>
 128     </blockTableStyle>
 129     <blockTableStyle id="TrLevel2">
 130       <blockLeftPadding length="0" start="1,0" stop="1,0"/>
 131       <lineStyle kind="LINEBELOW" colorName="#777777" start="1,0" stop="1,0"/>
 132       <blockTopPadding length="13" start="0,0" stop="-1,0"/>
 133       <blockBottomPadding length="2" start="0,0" stop="-1,0"/>
 134           <blockFont name="Times-Bold" start="0,0" stop="-1,-1"/>
 135     </blockTableStyle>
 136     <blockTableStyle id="TrLevel1">
 137       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
 138       <blockLeftPadding length="0" start="1,0" stop="1,0"/>
 139       <blockTopPadding length="26" start="0,0" stop="-1,0"/>
 140       <blockBottomPadding length="2" start="0,0" stop="-1,0"/>
 141           <blockFont name="Times-Bold" start="0,0" stop="-1,-1"/>
 142     </blockTableStyle>
 143
 144    <paraStyle
 145                 name="Level"
 146                 fontName="Helvetica"
 147                 fontSize="8.0" />
 148     <paraStyle
 149                 name="Level2"
 150                 fontName="Helvetica-Bold"
 151                 fontSize="8.0" />
 152     <paraStyle name="Level1"
 153                 fontSize="8.0"
 154                 fontName="Helvetica-Bold"
 155                 />
 156     <paraStyle name="Caption" fontName="Helvetica" fontSize="10.0" leading="13" spaceBefore="6.0" spaceAfter="6.0"/>
 157     <paraStyle name="Index" fontName="Helvetica"/>
 158   </stylesheet>
 159   <images/>
 160   <story>
 161 <para style="P2">
 162 <font color="white"> </font>
 163 </para>
 164 <para style="P2">
 165 <font color="white"> </font>
 166 </para>
 167
 168     <blockTable colWidths="78.0,108.0,108.0,108.0,138" style="Table3a">
 169       <tr>
 170         <td>
 171           <para style="terp_tblheader_General_Centre">Fiscal Year</para>
 172         </td>
 173         <td>
 174           <para style="terp_tblheader_General_Centre">End Date</para>
 175         </td>
 176         <td>
 177           <para style="terp_tblheader_General_Centre">Start Date</para>
 178         </td>
 179         <td>
 180           <para style="terp_tblheader_General_Centre">Display Account</para>
 181         </td>
 182         <td>
 183           <para style="terp_tblheader_General_Centre">Periods</para>
 184         </td>
 185       </tr>
 186     </blockTable>
 187     <blockTable colWidths="78.0,108.0,108.0,108.0,138" style="Table3a">
 188       <tr>
 189         <td>
 190           <para style="terp_default_Centre_8">[[ get_fiscalyear(data['form']) ]]</para>
 191         </td>
 192         <td>
 193           <para style="terp_default_Centre_8">[[ data['form']['date_from'] ]]</para>
 194         </td>
 195         <td>
 196           <para style="terp_default_Centre_8">[[ data['form']['date_to'] ]]</para>
 197         </td>
 198         <td>
 199           <para style="terp_default_Centre_8">[[ (data['form']['display_account']=='bal_all' and 'All') or  (data['form']['display_account']=='bal_mouvement' and 'With movements') or 'With balance is not equal to 0']]</para>
 200         </td>
 201         <td>
 202           <para style="terp_default_Centre_8"> [[data['form']['periods'] and get_periods(data['form']) or '']]</para>
 203         </td>
 204       </tr>
 205     </blockTable>
 206
 207
 208 <para style="P2">
 209 <font color="white"> </font>
 210 </para>
 211     <blockTable colWidths="67,264.0,70.0,70.0,80.0" style="Table2" repeatRows="1">
 212       <tr noRowsplits="1">
 213         <td><para style="P12a">Code</para></td>
 214         <td><para style="P12a">Account</para></td>
 215         <td><para style="P10">Debit</para></td>
 216         <td><para style="P10">Credit</para></td>
 217         <td><para style="P10">Balance</para></td>
 218       </tr>
 219       <tr>
 220                 <td><para style="P14">[[ repeatIn(lines(data['form']), 'a') ]]<font>[[ (a['level']&gt;2 and setTag('para','para',{'fontName':"Helvetica"})) or removeParentNode('font') ]]</font><i>[[ a['code'] or removeParentNode('tr')  ]]</i></para></td>
 221         <td><para style="P14"><font>[[ (a['level']&gt;2 and setTag('para','para',{'fontName':"Helvetica"})) or removeParentNode('font') ]]</font><font color="white">[[ '..'*(a['level']-1) ]]</font><font>[[ a['name'] ]]</font></para></td>
 222         <td><para style="P3"><font>[[ (a['level']&gt;2 and setTag('para','para',{'fontName':"Helvetica"})) or removeParentNode('font') ]]</font><font>[[ a['type']=='view' and removeParentNode('font') ]][[ formatLang(a['debit']) ]]</font><font>[[ a['type']&lt;&gt;'view' and removeParentNode('font') ]] [[formatLang(a['debit']) ]]</font></para></td>
 223         <td><para style="P3"><font>[[ (a['level']&gt;2 and setTag('para','para',{'fontName':"Helvetica"})) or removeParentNode('font')]]</font><font>[[ a['type']=='view' and removeParentNode('font') ]][[ formatLang(a['credit']) ]]</font><font>[[ a['type']&lt;&gt;'view' and removeParentNode('font') ]] [[ formatLang(a['credit']) ]]</font></para></td>
 224         <td><para style="P3"><font>[[ (a['level']&gt;2 and setTag('para','para',{'fontName':"Helvetica"})) or removeParentNode('font') ]]</font><font>[[ a['type']=='view' and removeParentNode('font') ]][[ formatLang(a['balance']) ]]</font><font>[[ a['type']&lt;&gt;'view' and removeParentNode('font') ]] [[ formatLang(a['balance'])  ]]</font></para></td>
 225       </tr>
 226     </blockTable>
 227   </story>
 228 </document>