addons/account/project/report/quantity_cost_ledger.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       <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">Cost Ledger-[[ 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_Detail">
  38       <blockAlignment value="LEFT"/>
  39       <blockValign value="TOP"/>
  40     </blockTableStyle>
  41     <blockTableStyle id="Table_Date_Detail">
  42       <blockAlignment value="LEFT"/>
  43       <blockValign value="TOP"/>
  44       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
  45       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
  46       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
  47       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
  48       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
  49       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
  50       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="2,0" stop="2,-1"/>
  51       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="2,0" stop="2,-1"/>
  52       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="2,0" stop="2,0"/>
  53       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
  54     </blockTableStyle>
  55     <blockTableStyle id="Table_Date_Content">
  56       <blockAlignment value="LEFT"/>
  57       <blockValign value="TOP"/>
  58       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
  59       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
  60       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
  61       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
  62       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
  63       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
  64       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="2,0" stop="2,-1"/>
  65       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="2,0" stop="2,-1"/>
  66       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="2,0" stop="2,0"/>
  67       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
  68     </blockTableStyle>
  69     <blockTableStyle id="Table_Header_Move_Line">
  70       <blockAlignment value="LEFT"/>
  71       <blockValign value="TOP"/>
  72       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
  73     </blockTableStyle>
  74     <blockTableStyle id="Table_Final_Total">
  75       <blockAlignment value="LEFT"/>
  76       <blockValign value="TOP"/>
  77       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
  78       <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
  79       <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
  80       <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
  81       <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
  82       <lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
  83     </blockTableStyle>
  84     <blockTableStyle id="Table_Account_Detail">
  85       <blockAlignment value="LEFT"/>
  86       <blockValign value="TOP"/>
  87       <lineStyle kind="LINEBELOW" colorName="#b3b3b3" start="0,0" stop="-1,0"/>
  88     </blockTableStyle>
  89     <blockTableStyle id="Table_Analytical_Detail">
  90       <blockAlignment value="LEFT"/>
  91       <blockValign value="TOP"/>
  92       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,0" stop="2,2"/>
  93       <lineStyle kind="LINEBELOW" colorName="white" start="0,1" stop="-1,1"/>
  94     </blockTableStyle>
  95     <blockTableStyle id="Table_Move_Line_Content">
  96       <blockAlignment value="LEFT"/>
  97       <blockValign value="TOP"/>
  98       <lineStyle kind="LINEBELOW" colorName="white" start="0,0" stop="1,1"/>
  99     </blockTableStyle>
 100     <initialize>
 101       <paraStyle name="all" alignment="justify"/>
 102     </initialize>
 103     <paraStyle name="P1" fontName="Times-Bold" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 104     <paraStyle name="Standard" fontName="Times-Roman"/>
 105     <paraStyle name="Text body" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
 106     <paraStyle name="List" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
 107     <paraStyle name="Table Contents" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="0.0"/>
 108     <paraStyle name="Table Heading" fontName="Times-Roman" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 109     <paraStyle name="Caption" fontName="Times-Roman" fontSize="10.0" leading="13" spaceBefore="6.0" spaceAfter="6.0"/>
 110     <paraStyle name="Index" fontName="Times-Roman"/>
 111     <paraStyle name="Heading" fontName="Helvetica" fontSize="15.0" leading="19" spaceBefore="12.0" spaceAfter="6.0"/>
 112     <paraStyle name="Footer" fontName="Times-Roman"/>
 113     <paraStyle name="Horizontal Line" fontName="Times-Roman" fontSize="6.0" leading="8" spaceBefore="0.0" spaceAfter="14.0"/>
 114     <paraStyle name="terp_header" fontName="Helvetica-Bold" fontSize="12.0" leading="15" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
 115     <paraStyle name="Heading 9" fontName="Helvetica-Bold" fontSize="75%" leading="NaN" spaceBefore="12.0" spaceAfter="6.0"/>
 116     <paraStyle name="terp_tblheader_General" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
 117     <paraStyle name="terp_tblheader_Details" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
 118     <paraStyle name="terp_default_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 119     <paraStyle name="terp_default_Bold_8" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" 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="terp_tblheader_General_Right" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
 122     <paraStyle name="terp_tblheader_Details_Centre" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
 123     <paraStyle name="terp_tblheader_Details_Right" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
 124     <paraStyle name="terp_default_Right_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 125     <paraStyle name="terp_default_Centre_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 126     <paraStyle name="terp_header_Right" fontName="Helvetica-Bold" fontSize="12.0" leading="15" alignment="RIGHT" spaceBefore="12.0" spaceAfter="6.0"/>
 127     <paraStyle name="terp_header_Centre" fontName="Helvetica-Bold" fontSize="12.0" leading="15" alignment="CENTER" spaceBefore="12.0" spaceAfter="6.0"/>
 128     <paraStyle name="terp_default_address" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 129     <paraStyle name="terp_default_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 130     <paraStyle name="terp_default_Bold_9" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 131     <paraStyle name="terp_default_Centre_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 132     <paraStyle name="terp_default_Right_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 133     <paraStyle name="terp_default_2" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 134     <paraStyle name="terp_default_Bold_9_Right" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 135     <paraStyle name="terp_default_Bold_9_Center" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 136     <paraStyle name="terp_default_9_Italic" fontName="Times-Italic" fontSize="8.0" leading="7" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 137     <paraStyle name="terp_default_9_Italic_Center" fontName="Times-Italic" fontSize="8.0" leading="7" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 138     <paraStyle name="terp_default_9_Italic_Right" fontName="Times-Italic" fontSize="8.0" leading="7" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 139     <paraStyle name="terp_default_Rignt_9_U" fontName="Helvetica" fontSize="9.0" leading="7" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 140     <paraStyle name="terp_default_Bold_9_Right_U" fontName="Helvetica-Bold" fontSize="9.0" leading="7" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 141   </stylesheet>
 142   <images/>
 143   <story>
 144     <!--blockTable colWidths="161.0,161.0,161.0" repeatRows="1" style="Table_Header_Detail">
 145       <tr>
 146         <td>
 147           <para style="terp_default_9">[[ company.name ]]</para>
 148         </td>
 149         <td>
 150           <para style="terp_default_9">
 151             <font color="white"> </font>
 152           </para>
 153         </td>
 154         <td>
 155           <para style="terp_header_Right">Cost Ledger-[[ company.currency_id.name ]]</para>
 156         </td>
 157       </tr>
 158     </blockTable-->
 159     <para style="terp_default_8">
 160       <font color="white"> </font>
 161     </para>
 162     <para style="terp_default_8">
 163       <font color="white"> </font>
 164     </para>
 165     <para style="terp_default_8">
 166       <font color="white"> </font>
 167     </para>
 168     <blockTable colWidths="161.0,161.0,161.0" style="Table_Date_Detail">
 169       <tr>
 170         <td>
 171           <para style="terp_tblheader_General_Centre">Period from</para>
 172         </td>
 173         <td>
 174           <para style="terp_tblheader_General_Centre">Period to</para>
 175         </td>
 176         <td>
 177           <para style="terp_tblheader_General_Centre">Printing date</para>
 178         </td>
 179       </tr>
 180     </blockTable>
 181     <blockTable colWidths="161.0,161.0,161.0" style="Table_Date_Content">
 182       <tr>
 183         <td>
 184           <para style="terp_tblheader_General_Centre">[[ data['form']['date1'] ]]</para>
 185         </td>
 186         <td>
 187           <para style="terp_tblheader_General_Centre">[[ data['form']['date2'] ]]</para>
 188         </td>
 189         <td>
 190           <para style="terp_tblheader_General_Centre">[[ time.strftime('%Y-%m-%d') ]] at [[ time.strftime('%H:%M:%S') ]]</para>
 191         </td>
 192       </tr>
 193     </blockTable>
 194     <para style="terp_default_8">
 195       <font color="white"> </font>
 196     </para>
 197     <para style="terp_default_8">
 198       <font color="white"> </font>
 199     </para>
 200     <section>
 201     <blockTable colWidths="77.0,305.0,45.0,58.0" style="Table_Header_Move_Line" repeatRows="1">
 202       <tr>
 203         <td>
 204           <para style="terp_tblheader_Details_Centre">Code/Date</para>
 205         </td>
 206         <td>
 207           <para style="terp_tblheader_Details">J.C./Move name</para>
 208         </td>
 209         <td>
 210           <para style="terp_tblheader_Details">Quantity</para>
 211         </td>
 212         <td>
 213           <para style="terp_tblheader_Details_Right">Total</para>
 214         </td>
 215       </tr>
 216
 217           <tr>
 218           <td>
 219         <blockTable colWidths="69.0,298.0,115.0" style="Table_Final_Total">
 220               <tr>
 221                 <td>
 222                   <para style="terp_default_Bold_9_Center">Total:</para>
 223                 </td>
 224                 <td>
 225                   <para style="terp_default_Bold_9"><font color="white"> </font></para>
 226                 </td>
 227                 <td>
 228                   <para style="terp_default_Bold_9_Right_U">[[ '%.2f' % (sum_quantity(objects,data['form']['date1'],data['form']['date2'], data['form']['journal']) or 0.0) ]]</para>
 229                 </td>
 230               </tr>
 231         </blockTable>
 232       </td>
 233       </tr>
 234
 235       <tr>
 236       <td>
 237                   <para style="terp_default_8">[[ repeatIn(objects,'o') ]]</para>
 238         <blockTable colWidths="67.0,291.0,55.0,70.0" style="Table_Account_Detail">
 239                 <tr>
 240                   <td>
 241                     <para style="terp_default_Bold_9_Center">[[ o.code ]]</para>
 242                   </td>
 243                   <td>
 244                     <para style="terp_default_Bold_9">[[ o.complete_name ]]</para>
 245                   </td>
 246                   <td>
 247                     <para style="terp_default_Bold_9">Max.qty:[[ '%.2f' % (o.quantity_max or 0.0)]]</para>
 248                   </td>
 249                   <td>
 250                     <para style="terp_default_Bold_9_Right_U">[[ '%.2f' % (account_sum_quantity(o.id,data['form']['date1'],data['form']['date2'], data['form']['journal']) or 0.0 )]]</para>
 251                   </td>
 252                 </tr>
 253
 254                 <tr>
 255                 <td>
 256                                 <para style="terp_default_8">[[ repeatIn(lines_g(o.id,data['form']['date1'],data['form']['date2'],data['form']['journal']),'move_g') ]]</para>
 257                             <blockTable colWidths="61.0,284.0,70.0,64.0" style="Table_Analytical_Detail">
 258                               <tr>
 259                                 <td>
 260                                   <para style="terp_default_Bold_9_Center">[[ move_g['code'] ]] </para>
 261                                 </td>
 262                                 <td>
 263                                   <para style="terp_default_Bold_9">[[ move_g['name'] ]]</para>
 264                                 </td>
 265                                 <td>
 266                                   <para style="terp_default_Bold_9">
 267                                     <font color="white"> </font>
 268                                   </para>
 269                                 </td>
 270                                 <td>
 271                                   <para style="terp_default_Bold_9_Right_U">[[ '%.2f' % (move_g['quantity'] or 0.0) ]]</para>
 272                                 </td>
 273                               </tr>
 274
 275                                   <tr>
 276                                   <td>
 277                                 <blockTable colWidths="55.0,327.0,89.0" style="Table_Move_Line_Content">
 278                                   <tr>
 279                                     <td>
 280                                       <para style="terp_default_9_Italic_Center">[[ repeatIn(lines_a(move_g['id'],o.id,data['form']['date1'],data['form']['date2'],data['form']['journal']),'move_a') ]]<font>[[ move_a['date'] ]]</font></para>
 281                                     </td>
 282                                     <td>
 283                                       <para style="terp_default_9_Italic">[[ move_a['cj'] ]] / [[ move_a['name'] ]]</para>
 284                                     </td>
 285                                     <td>
 286                                       <para style="terp_default_9_Italic_Right">[[ '%.2f' % (move_a['quantity'] or 0.0 )]]</para>
 287                                     </td>
 288                                   </tr>
 289                                 </blockTable>
 290                                    </td>
 291                                </tr>
 292                              </blockTable>
 293                            </td>
 294                            </tr>
 295                           </blockTable>
 296                          </td>
 297                          </tr>
 298                          <para style="terp_default_8">
 299                         <font color="white"> </font>
 300                 </para>
 301                 </blockTable>
 302     </section>
 303   </story>
 304 </document>