addons/account/report/wizard_general_journal.rml

   1 <?xml version="1.0"?>
   2 <document filename="test.pdf">
   3   <template pageSize="(596.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       <header>
   7                         <pageGraphics>
   8                                 <setFont name="Helvetica-Bold" size="9"/>
   9
  10
  11                                 <!--COL 1-->
  12                                 <drawString x="1.0cm" y="28.1cm">[[ company.name ]]</drawString>
  13                                 <drawRightString x="20cm" y="28.1cm">General Journal - [[ company.currency_id.name ]]</drawRightString>
  14
  15                                 <!-- Header -->
  16
  17
  18                                 <setFont name="Helvetica" size="9"/>
  19                                 <drawString x="1.0cm" y="1cm"> [[ time.strftime("%Y-%m-%d %H:%M", time.localtime()) ]]</drawString>
  20                                 <drawString x="19.0cm" y="1cm">Page <pageNumber/></drawString>
  21                                 <!--<drawRightString x="19.8cm" y="28cm">[[ company.rml_header1 ]]</drawRightString>-->
  22
  23
  24                             <lineMode width="0.7"/>
  25                                 <lines>1cm 27.7cm 20cm 27.7cm</lines>
  26                                 <setFont name="Helvetica" size="8"/>
  27
  28                         </pageGraphics>
  29                 </header>
  30     </pageTemplate>
  31   </template>
  32   <stylesheet>
  33     <blockTableStyle id="Standard_Outline">
  34       <blockAlignment value="LEFT"/>
  35       <blockValign value="TOP"/>
  36     </blockTableStyle>
  37     <blockTableStyle id="Table_Header_Title">
  38       <blockAlignment value="LEFT"/>
  39       <blockValign value="TOP"/>
  40     </blockTableStyle>
  41     <blockTableStyle id="Table_Print_Current_datetime">
  42       <blockAlignment value="LEFT"/>
  43       <blockValign value="TOP"/>
  44     </blockTableStyle>
  45     <blockTableStyle id="Table_Journal_Title">
  46       <blockAlignment value="LEFT"/>
  47       <blockValign value="TOP"/>
  48       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
  49     </blockTableStyle>
  50     <blockTableStyle id="Table_Final_Total">
  51       <blockAlignment value="LEFT"/>
  52       <blockValign value="TOP"/>
  53       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
  54       <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
  55       <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
  56       <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
  57       <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
  58     </blockTableStyle>
  59     <blockTableStyle id="Table_Sub_Total">
  60       <blockAlignment value="LEFT"/>
  61       <blockValign value="TOP"/>
  62       <lineStyle kind="LINEBELOW" colorName="#b3b3b3" start="0,0" stop="2,2"/>
  63       <lineStyle kind="LINEBELOW" colorName="white" start="0,1" stop="-1,1"/>
  64     </blockTableStyle>
  65     <blockTableStyle id="Table_Journal_Detail">
  66       <blockAlignment value="LEFT"/>
  67       <blockValign value="TOP"/>
  68     </blockTableStyle>
  69     <initialize>
  70       <paraStyle name="all" alignment="justify"/>
  71     </initialize>
  72     <paraStyle name="Standard" fontName="Times-Roman"/>
  73     <paraStyle name="Text body" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
  74     <paraStyle name="Table Contents" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
  75     <paraStyle name="Table Heading" fontName="Times-Roman" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
  76     <paraStyle name="Heading" fontName="Helvetica" fontSize="12.0" leading="15" spaceBefore="12.0" spaceAfter="6.0"/>
  77     <paraStyle name="List" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
  78     <paraStyle name="Caption" fontName="Helvetica-Oblique" fontSize="9.0" leading="11" spaceBefore="6.0" spaceAfter="6.0"/>
  79     <paraStyle name="Index" fontName="Helvetica"/>
  80     <paraStyle name="Footer" fontName="Times-Roman"/>
  81     <paraStyle name="Horizontal Line" fontName="Times-Roman" fontSize="6.0" leading="8" spaceBefore="0.0" spaceAfter="14.0"/>
  82     <paraStyle name="terp_header" fontName="Helvetica-Bold" fontSize="12.0" leading="15" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
  83     <paraStyle name="Heading 9" fontName="Helvetica-Bold" fontSize="75%" leading="NaN" spaceBefore="12.0" spaceAfter="6.0"/>
  84     <paraStyle name="terp_tblheader_General" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
  85     <paraStyle name="terp_tblheader_Details" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
  86     <paraStyle name="terp_default_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
  87     <paraStyle name="terp_default_Bold_8" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
  88     <paraStyle name="terp_tblheader_General_Centre" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
  89     <paraStyle name="terp_tblheader_General_Right" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
  90     <paraStyle name="terp_tblheader_Details_Centre" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
  91     <paraStyle name="terp_tblheader_Details_Right" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
  92     <paraStyle name="terp_default_Right_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
  93     <paraStyle name="terp_default_Centre_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
  94     <paraStyle name="terp_header_Right" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
  95     <paraStyle name="terp_header_Centre" fontName="Helvetica-Bold" fontSize="12.0" leading="15" alignment="CENTER" spaceBefore="12.0" spaceAfter="6.0"/>
  96     <paraStyle name="terp_default_address" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
  97     <paraStyle name="terp_default_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
  98     <paraStyle name="terp_default_Bold_9" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
  99     <paraStyle name="terp_default_Centre_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 100     <paraStyle name="terp_default_Right_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 101     <paraStyle name="terp_default_2" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 102     <paraStyle name="terp_default_Bold_9_Right" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 103   </stylesheet>
 104   <images/>
 105   <story>
 106     <para style="terp_default_8">
 107       <font color="white"> </font>
 108     </para>
 109     <!--blockTable colWidths="180.0,180.0,180.0" style="Table_Header_Title">
 110       <tr>
 111         <td>
 112           <para style="terp_header">[[ company.name ]]</para>
 113         </td>
 114         <td>
 115           <para style="terp_header">
 116             <font color="white"> </font>
 117           </para>
 118         </td>
 119         <td>
 120           <para style="terp_header">General Journal - [[ company.currency_id.name ]]</para>
 121         </td>
 122       </tr>
 123     </blockTable-->
 124     <para style="terp_default_8">
 125       <font color="white"> </font>
 126     </para>
 127     <blockTable colWidths="75.0,465.0" style="Table_Print_Current_datetime">
 128       <tr>
 129         <td>
 130           <para style="terp_default_Bold_9">Printing Date :</para>
 131         </td>
 132         <td>
 133           <para style="terp_default_Bold_9">[[ time.strftime('%Y-%m-%d') ]] at [[ time.strftime('%H:%M:%S') ]]</para>
 134         </td>
 135       </tr>
 136     </blockTable>
 137     <para style="terp_default_8">
 138       <font color="white"> </font>
 139     </para>
 140     <para style="terp_default_8">
 141       <font color="white"> </font>
 142     </para>
 143     <section>
 144
 145     <blockTable colWidths="61.0,228.0,95.0,80.0,73.0" style="Table_Journal_Title" repeatRows="1">
 146       <tr>
 147         <td>
 148           <para style="terp_tblheader_Details">Jrl Code</para>
 149         </td>
 150         <td>
 151           <para style="terp_tblheader_Details">Journal Name</para>
 152         </td>
 153         <td>
 154           <para style="terp_tblheader_Details">Period</para>
 155         </td>
 156         <td>
 157           <para style="terp_tblheader_Details_Right">Debit Trans.</para>
 158         </td>
 159         <td>
 160           <para style="terp_tblheader_Details_Right">Credit Trans.</para>
 161         </td>
 162       </tr>
 163       <tr>
 164       <td>
 165             <blockTable colWidths="64.0,226.0,82.0,82.0,76.0" style="Table_Final_Total">
 166               <tr>
 167                 <td>
 168                   <para style="terp_default_Bold_9">Total:</para>
 169                 </td>
 170                 <td>
 171                   <para style="terp_default_Bold_9">
 172                     <font color="white"> </font>
 173                   </para>
 174                 </td>
 175                 <td>
 176                   <para style="terp_default_Bold_9">
 177                     <font color="white"> </font>
 178                   </para>
 179                 </td>
 180                 <td>
 181                   <para style="terp_default_Bold_9_Right"><u>[[ '%.2f' % sum_debit(data['form']['period_id'][0][2],data['form']['journal_id'][0][2]) ]]</u></para>
 182                 </td>
 183                 <td>
 184                   <para style="terp_default_Bold_9_Right"><u>[[ '%.2f' % sum_credit(data['form']['period_id'][0][2],data['form']['journal_id'][0][2]) ]]</u></para>
 185                 </td>
 186               </tr>
 187             </blockTable>
 188            </td>
 189            </tr>
 190
 191            <tr>
 192            <td>
 193
 194                <para style="terp_default_9"><font>[[ repeatIn( lines( data['form']['period_id'][0][2], data['form']['journal_id'][0][2] ),'line')]]</font></para>
 195               <blockTable colWidths="175.0,115.0,82.0,82.0,75.0" style="Table_Sub_Total">
 196                 <tr>
 197                   <td>
 198                     <para style="terp_default_Bold_9">[[ line[0]['period_name'] ]] :</para>
 199                   </td>
 200                   <td>
 201                     <para style="terp_default_Bold_9">
 202                       <font color="white"> </font>
 203                     </para>
 204                   </td>
 205                   <td>
 206                     <para style="terp_default_Bold_9">
 207                       <font color="white"> </font>
 208                     </para>
 209                   </td>
 210                   <td>
 211                     <para style="terp_default_Bold_9_Right"><u>[[ '%.2f' % sum_debit_period( line[0]['pid'],data['form']['journal_id'][0][2]) ]]</u></para>
 212                   </td>
 213                   <td>
 214                     <para style="terp_default_Bold_9_Right"><u>[[ '%.2f' % sum_credit_period(line[0]['pid'],data['form']['journal_id'][0][2]) ]]</u></para>
 215                   </td>
 216                 </tr>
 217                          <tr>
 218                          <td>
 219                               <blockTable colWidths="60.0,219.0,88.0,80.0,76.0" style="Table_Journal_Detail">
 220                                 <tr>
 221                                   <td>
 222                                    <para style="terp_default_9">[[ repeatIn(line,'l') ]]</para>
 223                                     <para style="terp_default_9">[[ l['code'] ]]</para>
 224                                   </td>
 225                                   <td>
 226                                     <para style="terp_default_9">[[ l['name'] ]]</para>
 227                                   </td>
 228                                   <td>
 229                                     <para style="terp_default_9">[[ line[0]['period_name'] ]]</para>
 230                                   </td>
 231                                   <td>
 232                                     <para style="terp_default_Right_9">[[ l['debit'] and ('%.2f' % l['debit']) or '' ]]</para>
 233                                   </td>
 234                                   <td>
 235                                     <para style="terp_default_Right_9">[[ l['credit'] and ('%.2f' % l['credit']) or '' ]]</para>
 236                                   </td>
 237                                 </tr>
 238                               </blockTable>
 239                           </td>
 240                           </tr>
 241                           </blockTable>
 242                 </td>
 243                 </tr>
 244           </blockTable>
 245     </section>
 246     <para style="terp_default_8">
 247       <font color="white"> </font>
 248     </para>
 249   </story>
 250 </document>