addons/account/report/aged_trial_balance.rml

   1 <?xml version="1.0"?>
   2 <document filename="test.pdf">
   3   <template pageSize="(842.0,595.0)" title="Test" author="Martin Simon" allowSplitting="20">
   4     <pageTemplate id="first">
   5       <frame id="first" x1="57.0" y1="57.0" width="728" height="481"/>
   6     </pageTemplate>
   7   </template>
   8   <stylesheet>
   9     <blockTableStyle id="Standard_Outline">
  10       <blockAlignment value="LEFT"/>
  11       <blockValign value="TOP"/>
  12     </blockTableStyle>
  13     <blockTableStyle id="Table1">
  14       <blockAlignment value="LEFT"/>
  15       <blockValign value="TOP"/>
  16       <blockBackground colorName="#e6e6e6" start="0,0" stop="0,0"/>
  17       <blockBackground colorName="#e6e6e6" start="1,0" stop="1,0"/>
  18       <blockBackground colorName="#e6e6e6" start="2,0" stop="2,0"/>
  19       <blockBackground colorName="#e6e6e6" start="0,1" stop="0,1"/>
  20       <blockBackground colorName="#e6e6e6" start="1,1" stop="1,1"/>
  21       <blockBackground colorName="#e6e6e6" start="2,1" stop="2,1"/>
  22     </blockTableStyle>
  23     <blockTableStyle id="Tableau1">
  24       <blockAlignment value="LEFT"/>
  25       <blockValign value="TOP"/>
  26       <lineStyle kind="GRID" colorName="black"/>
  27     </blockTableStyle>
  28     <blockTableStyle id="Tableau2">
  29       <blockAlignment value="LEFT"/>
  30       <blockValign value="TOP"/>
  31     </blockTableStyle>
  32     <blockTableStyle id="Tableau3">
  33       <blockAlignment value="LEFT"/>
  34       <blockValign value="TOP"/>
  35       <lineStyle kind="GRID" colorName="black"/>
  36     </blockTableStyle>
  37     <initialize>
  38       <paraStyle name="all" alignment="justify"/>
  39     </initialize>
  40     <paraStyle name="P1" fontName="Times-Roman" fontSize="20.0" leading="25" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
  41     <paraStyle name="P2" fontName="Times-Roman" fontSize="10.0" leading="13" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
  42     <paraStyle name="P3" fontName="Times-Roman" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
  43     <paraStyle name="P4" fontName="Times-Roman" fontSize="11.0" leading="14" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
  44     <paraStyle name="P5" fontName="Times-Roman" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
  45     <paraStyle name="P6" fontName="Times-Roman" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
  46     <paraStyle name="P7" fontName="Times-Roman" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
  47     <paraStyle name="P8" fontName="Times-Roman" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
  48     <paraStyle name="P9" fontName="Times-Roman" alignment="CENTER"/>
  49     <paraStyle name="P10" fontName="Times-Roman" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
  50     <paraStyle name="Standard" fontName="Times-Roman"/>
  51     <paraStyle name="Text body" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
  52     <paraStyle name="Heading" fontName="Helvetica" fontSize="14.0" leading="17" spaceBefore="12.0" spaceAfter="6.0"/>
  53     <paraStyle name="List" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
  54     <paraStyle name="Table Contents" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
  55     <paraStyle name="Table Heading" fontName="Times-Roman" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
  56     <paraStyle name="Caption" fontName="Times-Roman" fontSize="12.0" leading="15" spaceBefore="6.0" spaceAfter="6.0"/>
  57     <paraStyle name="Index" fontName="Times-Roman"/>
  58   </stylesheet>
  59   <story>
  60     <blockTable colWidths="198.0,313.0,217.0" repeatRows="1" style="Table1">
  61       <tr>
  62         <td>
  63           <para style="Table Contents">
  64             <font color="white"> </font>
  65           </para>
  66         </td>
  67         <td>
  68           <para style="P1">Aged Trial balance</para>
  69         </td>
  70         <td>
  71           <para style="P2">From the beginning</para>
  72           <para style="P2">to [[ data['form']['4']['stop'] ]]</para>
  73         </td>
  74       </tr>
  75       <tr>
  76         <td>
  77           <para style="Table Contents">[[ get_company(data['form']) ]]</para>
  78         </td>
  79         <td>
  80           <para style="P3">
  81             <font color="white"> </font>
  82           </para>
  83         </td>
  84         <td>
  85           <para style="P4">Currency: [[ get_currency(data['form']) ]]</para>
  86         </td>
  87       </tr>
  88     </blockTable>
  89     <para style="Standard">
  90       <font color="white"> </font>
  91     </para>
  92     <para style="P9">Printing date: [[ time.strftime('%Y-%m-%d') ]] at [[ time.strftime('%H:%M:%S') ]]</para>
  93     <para style="P9">
  94       <font color="white"> </font>
  95     </para>
  96     <blockTable colWidths="218.0,71.0,71.0,71.0,71.0,71.0,71.0,85.0" style="Tableau1">
  97       <tr>
  98         <td>
  99           <para style="P5">Partners</para>
 100         </td>
 101         <td>
 102           <para style="P6">[[ data['form']['4']['name'] ]]</para>
 103         </td>
 104         <td>
 105           <para style="P6">[[ data['form']['3']['name'] ]]</para>
 106         </td>
 107         <td>
 108           <para style="P6">[[ data['form']['2']['name'] ]]</para>
 109         </td>
 110         <td>
 111           <para style="P6">[[ data['form']['1']['name'] ]]</para>
 112         </td>
 113         <td>
 114           <para style="P6">[[ data['form']['0']['name'] ]]</para>
 115         </td>
 116         <td>
 117           <para style="P6">Before [[ data['form']['0']['start'] ]]</para>
 118         </td>
 119         <td>
 120           <para style="P5">Total</para>
 121         </td>
 122       </tr>
 123     </blockTable>
 124     <blockTable colWidths="218.0,71.0,71.0,71.0,71.0,71.0,71.0,85.0" style="Tableau2">
 125       <tr>
 126         <td>
 127           <para style="P3">[[ repeatIn(get_lines(data['form']), 'partner') ]]</para>
 128           <para style="P3">[[ partner['name'] ]]</para>
 129         </td>
 130         <td>
 131           <para style="P8">[[ '%.2f' % (partner['4'] or 0.0) ]]</para>
 132         </td>
 133         <td>
 134           <para style="P8">[[ '%.2f' % (partner['3'] or 0.0) ]]</para>
 135         </td>
 136         <td>
 137           <para style="P8">[[ '%.2f' % (partner['2'] or 0.0) ]]</para>
 138         </td>
 139         <td>
 140           <para style="P8">[[ '%.2f' % (partner['1'] or 0.0) ]]</para>
 141         </td>
 142         <td>
 143           <para style="P8">[[ '%.2f' % (partner['0'] or 0.0) ]]</para>
 144         </td>
 145         <td>
 146           <para style="P8">[[ '%.2f' % (partner['before'] or 0.0) ]]</para>
 147         </td>
 148         <td>
 149           <para style="P8">[[ '%.2f' % (partner['total'] or 0.0) ]]</para>
 150         </td>
 151       </tr>
 152     </blockTable>
 153     <blockTable colWidths="218.0,71.0,71.0,71.0,71.0,71.0,71.0,85.0" style="Tableau3">
 154       <tr>
 155         <td>
 156           <para style="P5">Account total</para>
 157         </td>
 158         <td>
 159           <para style="P7">[[ '%.2f' % get_for_period(data['form']['4'], data['form']['fiscalyear'], data['form']['company_id']) ]]</para>
 160         </td>
 161         <td>
 162           <para style="P7">[[ '%.2f' % get_for_period(data['form']['3'], data['form']['fiscalyear'], data['form']['company_id']) ]]</para>
 163         </td>
 164         <td>
 165           <para style="P7">[[ '%.2f' % get_for_period(data['form']['2'], data['form']['fiscalyear'], data['form']['company_id']) ]]</para>
 166         </td>
 167         <td>
 168           <para style="P7">[['%.2f' % get_for_period(data['form']['1'], data['form']['fiscalyear'], data['form']['company_id']) ]]</para>
 169         </td>
 170         <td>
 171           <para style="P7">[[ '%.2f' % get_for_period(data['form']['0'], data['form']['fiscalyear'], data['form']['company_id']) ]]</para>
 172         </td>
 173         <td>
 174           <para style="P7">[[ '%.2f' % get_before(data['form']['0']['start'], data['form']['fiscalyear'], data['form']['company_id']) ]]</para>
 175         </td>
 176         <td>
 177           <para style="P10">[[ '%.2f' % get_total( data['form']['fiscalyear'], data['form']['company_id']) ]]</para>
 178         </td>
 179       </tr>
 180     </blockTable>
 181     <para style="P9">
 182       <font color="white"> </font>
 183     </para>
 184   </story>
 185 </document>
 186