addons/account/project/report/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     </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     </blockTableStyle>
  17     <blockTableStyle id="Table_Date_Sub_detail">
  18       <blockAlignment value="LEFT"/>
  19       <blockValign value="TOP"/>
  20       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
  21       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
  22       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
  23       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
  24       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
  25       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
  26       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="2,0" stop="2,-1"/>
  27       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="2,0" stop="2,-1"/>
  28       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="2,0" stop="2,0"/>
  29       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
  30     </blockTableStyle>
  31     <blockTableStyle id="Table_Sub_Content">
  32       <blockAlignment value="LEFT"/>
  33       <blockValign value="TOP"/>
  34       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
  35       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
  36       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
  37       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
  38       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
  39       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
  40       <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="2,0" stop="2,-1"/>
  41       <lineStyle kind="LINEAFTER" colorName="#cccccc" start="2,0" stop="2,-1"/>
  42       <lineStyle kind="LINEABOVE" colorName="#cccccc" start="2,0" stop="2,0"/>
  43       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
  44     </blockTableStyle>
  45     <blockTableStyle id="Table_Header_Title">
  46       <blockAlignment value="LEFT"/>
  47       <blockValign value="TOP"/>
  48       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
  49       <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
  50       <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
  51       <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
  52       <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
  53     </blockTableStyle>
  54     <blockTableStyle id="Table_Grant_Total">
  55       <blockAlignment value="LEFT"/>
  56       <blockValign value="TOP"/>
  57       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
  58       <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
  59       <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
  60       <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
  61       <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
  62     </blockTableStyle>
  63     <blockTableStyle id="Table_Account_Detail">
  64       <blockAlignment value="LEFT"/>
  65       <blockValign value="TOP"/>
  66       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
  67       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
  68       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
  69       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,-1" stop="3,-1"/>
  70       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="4,-1" stop="4,-1"/>
  71     </blockTableStyle>
  72     <blockTableStyle id="Table_Move_Line_Detail">
  73       <blockAlignment value="LEFT"/>
  74       <blockValign value="TOP"/>
  75       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
  76       <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
  77     </blockTableStyle>
  78     <blockTableStyle id="Table_Move_Line_Content">
  79       <blockAlignment value="LEFT"/>
  80       <blockValign value="TOP"/>
  81     </blockTableStyle>
  82     <initialize>
  83       <paraStyle name="all" alignment="justify"/>
  84     </initialize>
  85     <paraStyle name="Standard" fontName="Helvetica"/>
  86     <paraStyle name="Text body" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
  87     <paraStyle name="List" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
  88     <paraStyle name="Table Contents" fontName="Helvetica" spaceBefore="0.0" spaceAfter="0.0"/>
  89     <paraStyle name="Table Heading" fontName="Helvetica" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
  90     <paraStyle name="Caption" fontName="Helvetica" fontSize="10.0" leading="13" spaceBefore="6.0" spaceAfter="6.0"/>
  91     <paraStyle name="Index" fontName="Helvetica"/>
  92     <paraStyle name="Heading" fontName="Helvetica" fontSize="12.0" leading="15" spaceBefore="12.0" spaceAfter="6.0"/>
  93     <paraStyle name="Footer" fontName="Helvetica"/>
  94     <paraStyle name="Horizontal Line" fontName="Helvetica" fontSize="6.0" leading="8" spaceBefore="0.0" spaceAfter="14.0"/>
  95     <paraStyle name="terp_header" fontName="Helvetica-Bold" fontSize="12.0" leading="15" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
  96     <paraStyle name="Heading 9" fontName="Helvetica-Bold" fontSize="75%" leading="NaN" spaceBefore="12.0" spaceAfter="6.0"/>
  97     <paraStyle name="terp_tblheader_General" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
  98     <paraStyle name="terp_tblheader_Details" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
  99     <paraStyle name="terp_default_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 100     <paraStyle name="terp_default_Bold_8" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 101     <paraStyle name="terp_tblheader_General_Centre" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
 102     <paraStyle name="terp_tblheader_General_Right" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
 103     <paraStyle name="terp_tblheader_Details_Centre" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
 104     <paraStyle name="terp_tblheader_Details_Right" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
 105     <paraStyle name="terp_default_Right_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 106     <paraStyle name="terp_default_Centre_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 107     <paraStyle name="terp_header_Right" fontName="Helvetica-Bold" fontSize="12.0" leading="15" alignment="RIGHT" spaceBefore="12.0" spaceAfter="6.0"/>
 108     <paraStyle name="terp_header_Centre" fontName="Helvetica-Bold" fontSize="12.0" leading="15" alignment="CENTER" spaceBefore="12.0" spaceAfter="6.0"/>
 109     <paraStyle name="terp_default_address" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 110     <paraStyle name="terp_default_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 111     <paraStyle name="terp_default_Bold_9" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 112     <paraStyle name="terp_default_Centre_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
 113     <paraStyle name="terp_default_Right_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 114     <paraStyle name="terp_default_2" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 115     <paraStyle name="terp_Default_Bold_Right_9" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 116     <paraStyle name="terp_Default_Bold_Right_9_U" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 117     <paraStyle name="terp_Default_Right_9_U" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 118     <paraStyle name="terp_default_9_Italic" fontName="Helvetica-Oblique" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
 119     <paraStyle name="terp_default_9_italic_Rignt" fontName="Helvetica-Oblique" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
 120     <images/>
 121   </stylesheet>
 122   <story>
 123     <blockTable colWidths="161.0,161.0,161.0" repeatRows="1" style="Table1">
 124       <tr>
 125         <td>
 126           <para style="terp_default_9">
 127             <font color="white"> </font>
 128           </para>
 129         </td>
 130         <td>
 131           <para style="terp_header_Centre">Cost Ledger</para>
 132         </td>
 133         <td>
 134           <para style="terp_header_Right">
 135             <font color="white"> </font>
 136           </para>
 137         </td>
 138       </tr>
 139     </blockTable>
 140     <blockTable colWidths="161.0,161.0,161.0" style="Table_Date_Sub_detail">
 141       <tr>
 142         <td>
 143           <para style="terp_tblheader_General_Centre">Period from </para>
 144         </td>
 145         <td>
 146           <para style="terp_tblheader_General_Centre">Period to</para>
 147         </td>
 148         <td>
 149           <para style="terp_tblheader_General_Centre">Printing date</para>
 150         </td>
 151       </tr>
 152     </blockTable>
 153     <blockTable colWidths="161.0,161.0,161.0" style="Table_Sub_Content">
 154       <tr>
 155         <td>
 156           <para style="terp_default_Centre_8">[[ formatLang(data['form']['date1'],date = True) ]]</para>
 157         </td>
 158         <td>
 159           <para style="terp_default_Centre_8">[[ formatLang(data['form']['date2'],date = True) ]]</para>
 160         </td>
 161         <td>
 162           <para style="terp_default_Centre_8">[[ formatLang(time.strftime('%Y-%m-%d %H:%M:%S'),date_time = True) ]]</para>
 163         </td>
 164       </tr>
 165     </blockTable>
 166     <para style="terp_default_8">
 167       <font color="white"> </font>
 168     </para>
 169     <blockTable colWidths="63.0,249.0,57.0,57.0,57.0" style="Table_Header_Title">
 170       <tr>
 171         <td>
 172           <para style="terp_tblheader_Details">Date/Code</para>
 173         </td>
 174         <td>
 175           <para style="terp_tblheader_Details">J.C. /Move name</para>
 176         </td>
 177         <td>
 178           <para style="terp_tblheader_Details_Right">Debit([[ company.currency_id.code]])</para>
 179         </td>
 180         <td>
 181           <para style="terp_tblheader_Details_Right">Credit([[ company.currency_id.code]])</para>
 182         </td>
 183         <td>
 184           <para style="terp_tblheader_Details_Centre">Balance([[ company.currency_id.code]])</para>
 185         </td>
 186       </tr>
 187     </blockTable>
 188     <para style="terp_default_2">
 189       <font color="white"> </font>
 190     </para>
 191     <blockTable colWidths="62.0,250.0,57.0,56.0,57.0" style="Table_Grant_Total">
 192       <tr>
 193         <td>
 194           <para style="terp_default_Bold_9">Total:</para>
 195         </td>
 196         <td>
 197           <para style="terp_default_Bold_9">
 198             <font color="white"> </font>
 199           </para>
 200         </td>
 201         <td>
 202           <para style="terp_Default_Bold_Right_9_U">[[ formatLang (sum_debit(objects,data['form']['date1'],data['form']['date2'])) ]] [[ company.currency_id.symbol ]]</para>
 203         </td>
 204         <td>
 205           <para style="terp_Default_Bold_Right_9_U">[[ formatLang (sum_credit(objects,data['form']['date1'],data['form']['date2'])) ]] [[ company.currency_id.symbol ]]</para>
 206         </td>
 207         <td>
 208           <para style="terp_Default_Bold_Right_9_U">[[ formatLang (sum_balance(objects,data['form']['date1'],data['form']['date2'])) ]] [[ company.currency_id.symbol ]]</para>
 209         </td>
 210       </tr>
 211     </blockTable>
 212     <para style="terp_default_2">
 213       <font color="white"> </font>
 214     </para>
 215     <section>
 216       <para style="terp_default_8">[[ repeatIn(objects,'o') ]]</para>
 217       <blockTable colWidths="62.0,249.0,57.0,57.0,57.0" style="Table_Account_Detail">
 218         <tr>
 219           <td>
 220             <para style="terp_default_Bold_9">[[ o.code ]]</para>
 221           </td>
 222           <td>
 223             <para style="terp_default_Bold_9">[[ o.complete_name ]]</para>
 224           </td>
 225           <td>
 226             <para style="terp_Default_Bold_Right_9_U">[[ formatLang (account_sum_debit(o.id,data['form']['date1'],data['form']['date2'])) ]] [[ company.currency_id.symbol ]]</para>
 227           </td>
 228           <td>
 229             <para style="terp_Default_Bold_Right_9_U">[[ formatLang (account_sum_credit(o.id,data['form']['date1'],data['form']['date2'])) ]] [[ company.currency_id.symbol ]]</para>
 230           </td>
 231           <td>
 232             <para style="terp_Default_Bold_Right_9_U">[[ formatLang (account_sum_balance(o.id,data['form']['date1'],data['form']['date2']))]] [[ company.currency_id.symbol ]]</para>
 233           </td>
 234         </tr>
 235       </blockTable>
 236       <para style="terp_default_2">
 237         <font color="white"> </font>
 238       </para>
 239       <section>
 240         <para style="Standard">[[ repeatIn(lines_g(o.id,data['form']['date1'],data['form']['date2']),'move_g') ]]</para>
 241         <blockTable colWidths="62.0,249.0,58.0,56.0,57.0" style="Table_Move_Line_Detail">
 242           <tr>
 243             <td>
 244               <para style="terp_default_Bold_9">[[ move_g['code'] ]]</para>
 245             </td>
 246             <td>
 247               <para style="terp_default_Bold_9">[[ move_g['name'] ]]</para>
 248             </td>
 249             <td>
 250               <para style="terp_Default_Bold_Right_9_U">[[ formatLang( move_g['debit']) ]] [[ company.currency_id.symbol ]]</para>
 251             </td>
 252             <td>
 253               <para style="terp_Default_Bold_Right_9_U">[[ formatLang( move_g['credit']) ]] [[ company.currency_id.symbol ]]</para>
 254             </td>
 255             <td>
 256               <para style="terp_Default_Bold_Right_9_U">[[ formatLang( move_g['balance']) ]] [[ company.currency_id.symbol ]]</para>
 257             </td>
 258           </tr>
 259         </blockTable>
 260         <para style="terp_default_2">
 261           <font color="white"> </font>
 262         </para>
 263         <section>
 264           <para style="terp_default_9">[[ repeatIn(lines_a(move_g['id'],o.id,data['form']['date1'],data['form']['date2']),'move_a') ]]</para>
 265           <blockTable colWidths="60.0,46.0,204.0,59.0,55.0,58.0" style="Table_Move_Line_Content">
 266             <tr>
 267               <td>
 268                 <para style="terp_default_9_Italic">[[ formatLang(move_a['date'],date = True) ]]</para>
 269               </td>
 270               <td>
 271                 <para style="terp_default_9_Italic">[[ move_a['cj'] ]]</para>
 272               </td>
 273               <td>
 274                 <para style="terp_default_9_Italic">[[ move_a['name'] ]]</para>
 275               </td>
 276               <td>
 277                 <para style="terp_default_9_italic_Rignt">[[ formatLang( move_a['debit'] )]] [[ company.currency_id.symbol]]</para>
 278               </td>
 279               <td>
 280                 <para style="terp_default_9_italic_Rignt">[[ formatLang( move_a['credit']) ]] [[ company.currency_id.symbol]]</para>
 281               </td>
 282               <td>
 283                 <para style="terp_default_9_italic_Rignt">[[ formatLang( move_a['balance']) ]] [[ company.currency_id.symbol]]</para>
 284               </td>
 285             </tr>
 286           </blockTable>
 287           <para style="terp_default_2">
 288             <font color="white"> </font>
 289           </para>
 290         </section>
 291         <para style="terp_default_8">
 292           <font color="white"> </font>
 293         </para>
 294       </section>
 295     </section>
 296     <para style="terp_default_8">
 297       <font color="white"> </font>
 298     </para>
 299   </story>
 300 </document>