addons/account_followup/report/report_followp_print.rml

   1 <?xml version="1.0"?>
   2 <document filename="test.pdf">
   3   <template pageSize="(595.0,842.0)" title="Follow Up" author="OpenERP S.A. (sales@openerp.com)" allowSplitting="20">
   4     <pageTemplate id="first">
   5       <frame id="first" x1="42.0" y1="28.0" width="511" height="786"/>
   6     </pageTemplate>
   7   </template>
   8   <stylesheet>
   9     <blockTableStyle id="Standard_Outline">
  10       <blockAlignment value="LEFT"/>
  11       <blockValign value="TOP"/>
  12     </blockTableStyle>
  13     <blockTableStyle id="Tableau2">
  14       <blockAlignment value="LEFT"/>
  15       <blockValign value="TOP"/>
  16     </blockTableStyle>
  17     <blockTableStyle id="Table1">
  18       <blockAlignment value="LEFT"/>
  19       <blockValign value="TOP"/>
  20       <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
  21       <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
  22       <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
  23       <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
  24       <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
  25       <lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
  26       <lineStyle kind="LINEBELOW" colorName="#000000" start="6,-1" stop="6,-1"/>
  27       <lineStyle kind="LINEBELOW" colorName="#000000" start="7,-1" stop="7,-1"/>
  28       <lineStyle kind="LINEBELOW" colorName="#000000" start="8,-1" stop="8,-1"/>
  29     </blockTableStyle>
  30     <blockTableStyle id="Table5">
  31       <blockAlignment value="LEFT"/>
  32       <blockValign value="TOP"/>
  33       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,-1" stop="0,-1"/>
  34       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="1,-1" stop="1,-1"/>
  35       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="2,-1" stop="2,-1"/>
  36       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="3,-1" stop="3,-1"/>
  37       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="4,-1" stop="4,-1"/>
  38       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="5,-1" stop="5,-1"/>
  39       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="6,-1" stop="6,-1"/>
  40       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="7,-1" stop="7,-1"/>
  41       <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="8,-1" stop="8,-1"/>
  42     </blockTableStyle>
  43     <blockTableStyle id="Table2">
  44       <blockAlignment value="LEFT"/>
  45       <blockValign value="TOP"/>
  46       <lineStyle kind="LINEABOVE" colorName="#000000" start="5,0" stop="5,0"/>
  47       <lineStyle kind="LINEABOVE" colorName="#000000" start="6,0" stop="6,0"/>
  48       <lineStyle kind="LINEABOVE" colorName="#000000" start="7,0" stop="7,0"/>
  49       <lineStyle kind="LINEABOVE" colorName="#000000" start="8,0" stop="8,0"/>
  50       <lineStyle kind="LINEABOVE" colorName="#000000" start="9,0" stop="9,0"/>
  51       <lineStyle kind="LINEABOVE" colorName="#000000" start="5,1" stop="5,1"/>
  52       <lineStyle kind="LINEABOVE" colorName="#000000" start="6,1" stop="6,1"/>
  53       <lineStyle kind="LINEABOVE" colorName="#000000" start="7,1" stop="7,1"/>
  54       <lineStyle kind="LINEABOVE" colorName="#000000" start="8,1" stop="8,1"/>
  55       <lineStyle kind="LINEABOVE" colorName="#000000" start="9,1" stop="9,1"/>
  56     </blockTableStyle>
  57     <initialize>
  58       <paraStyle name="all" alignment="justify"/>
  59     </initialize>
  60     <paraStyle name="Standard" fontName="Times-Roman"/>
  61     <paraStyle name="Text body" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
  62     <paraStyle name="List" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
  63     <paraStyle name="Table Contents" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
  64     <paraStyle name="Table Heading" fontName="Times-Roman" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
  65     <paraStyle name="Caption" fontName="Times-Roman" fontSize="10.0" leading="13" spaceBefore="6.0" spaceAfter="6.0"/>
  66     <paraStyle name="Index" fontName="Times-Roman"/>
  67     <paraStyle name="Heading" fontName="Helvetica" fontSize="15.0" leading="19" spaceBefore="12.0" spaceAfter="6.0"/>
  68     <paraStyle name="Footer" fontName="Times-Roman"/>
  69     <paraStyle name="Horizontal Line" fontName="Times-Roman" fontSize="6.0" leading="8" spaceBefore="0.0" spaceAfter="14.0"/>
  70     <paraStyle name="terp_header" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
  71     <paraStyle name="Heading 9" fontName="Helvetica-Bold" fontSize="75%" leading="NaN" spaceBefore="12.0" spaceAfter="6.0"/>
  72     <paraStyle name="terp_tblheader_General" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
  73     <paraStyle name="terp_tblheader_Details" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
  74     <paraStyle name="terp_default_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
  75     <paraStyle name="terp_default_Bold_8" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
  76     <paraStyle name="terp_tblheader_General_Centre" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
  77     <paraStyle name="terp_tblheader_General_Right" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
  78     <paraStyle name="terp_tblheader_Details_Centre" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
  79     <paraStyle name="terp_tblheader_Details_Right" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
  80     <paraStyle name="terp_default_Right_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
  81     <paraStyle name="terp_default_Centre_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
  82     <paraStyle name="terp_header_Right" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
  83     <paraStyle name="terp_header_Centre" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="CENTER" spaceBefore="12.0" spaceAfter="6.0"/>
  84     <paraStyle name="terp_default_address" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
  85     <paraStyle name="terp_default_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
  86     <paraStyle name="terp_default_Bold_9" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
  87     <paraStyle name="terp_default_Centre_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
  88     <paraStyle name="terp_default_Right_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
  89     <paraStyle name="terp_default_9_followup_id" rightIndent="0.0" leftIndent="0.0" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
  90   </stylesheet>
  91   <images/>
  92   <story>
  93     <para style="terp_default_8">[[ repeatIn(ids_to_objects(data['form']['partner_ids']),'o') ]] </para>
  94     <para style="terp_default_8">[[ setLang(o.lang) ]]</para>
  95     <blockTable colWidths="286.0,224.0" style="Tableau2">
  96       <tr>
  97         <td>
  98           <para style="terp_default_9">[[ repeatIn(adr_get(o,'invoice'),'a' )]]</para>
  99         </td>
 100         <td>
 101           <para style="terp_default_9">[[ o.name ]]</para>
 102           <para style="terp_default_9">[[ a['name'] ]]</para>
 103           <para style="terp_default_9">[[ a['street'] ]]</para>
 104           <para style="terp_default_9">[[ a['zip'] ]] </para>
 105           <para style="terp_default_9">[[ a['city'] ]]</para>
 106           <para style="terp_default_9">[[( a['country_id'] and a['country_id'][1]) or '']]</para>
 107           <para style="terp_default_9">
 108             <font color="white"> </font>
 109           </para>
 110           <para style="terp_default_9">VAT: [[ o.vat or removeParentNode('para') ]]</para>
 111         </td>
 112       </tr>
 113     </blockTable>
 114     <para style="terp_default_8">
 115       <font color="white"> </font>
 116     </para>
 117     <para style="terp_default_9">Document : Customer account statement</para>
 118     <para style="terp_default_9">Date : [[ formatLang(time.strftime('%Y-%m-%d'),date = True) ]]</para>
 119     <para style="terp_default_9">Customer Ref : [[ o.id ]]</para>
 120     <para style="terp_default_8">
 121       <font color="white"> </font>
 122     </para>
 123     <para style="terp_default_9_followup_id">[[ format(get_text(o,data['form']['followup_id'])) ]]</para>
 124     <para style="terp_default_9">
 125       <font color="white"> </font>
 126     </para>
 127     <blockTable colWidths="49.0,81.0,50.0,50.0,55.0,69.0,62.0,67.0,27.0" style="Table1">
 128       <tr>
 129         <td>
 130           <para style="terp_tblheader_Details">Invoice Date</para>
 131         </td>
 132         <td>
 133           <para style="terp_tblheader_Details">Description</para>
 134         </td>
 135         <td>
 136           <para style="terp_tblheader_Details_Centre">Ref</para>
 137         </td>
 138         <td>
 139           <para style="terp_tblheader_Details_Centre">Due Date</para>
 140         </td>
 141         <td>
 142           <para style="terp_tblheader_Details_Right">Amount In Currency</para>
 143         </td>
 144         <td>
 145           <para style="terp_tblheader_Details_Centre">Due</para>
 146         </td>
 147         <td>
 148           <para style="terp_tblheader_Details_Centre">Paid</para>
 149         </td>
 150         <td>
 151           <para style="terp_tblheader_Details_Centre">Maturity</para>
 152         </td>
 153         <td>
 154           <para style="terp_tblheader_Details_Centre">Li.</para>
 155         </td>
 156       </tr>
 157     </blockTable>
 158     <section>
 159       <para style="terp_default_8">[[repeatIn(getLines(o), 'line') ]]</para>
 160       <blockTable colWidths="50.0,80.0,50.0,50.0,55.0,68.0,62.0,67.0,27.0" style="Table5">
 161         <tr>
 162           <td>
 163             <para style="terp_default_9">[[ formatLang(line['date'],date = True) ]]</para>
 164           </td>
 165           <td>
 166             <para style="terp_default_9">[[ line['name'] ]]</para>
 167           </td>
 168           <td>
 169             <para style="terp_default_Centre_9">[[ line['ref'] ]]</para>
 170           </td>
 171           <td>
 172             <para style="terp_default_Centre_9">[[ line['date_maturity'] and formatLang(line['date_maturity'], date=True) ]]</para>
 173           </td>
 174           <td>
 175             <para style="terp_default_Right_9">[[ formatLang(line['amount_currency'] )]] [[ line['currency_id'] and line['currency_id'][1] or '' ]] </para>
 176           </td>
 177           <td>
 178             <para style="terp_default_Right_9">[[ formatLang(line['debit']) ]] [[ company.currency_id.name]] </para>
 179           </td>
 180           <td>
 181             <para style="terp_default_Right_9">[[ formatLang(line['credit']) ]] [[ company.currency_id.name]] </para>
 182           </td>
 183           <td>
 184             <para style="terp_default_Right_9">[[ (line['date_maturity'] &lt; time.strftime('%Y-%m-%d')) and formatLang(line['debit'] -line['credit']) ]] [[ company.currency_id.name]]</para>
 185           </td>
 186           <td>
 187             <para style="terp_default_Centre_9">[[ line['blocked'] and 'X' or '' ]]</para>
 188           </td>
 189         </tr>
 190       </blockTable>
 191     </section>
 192     <blockTable colWidths="50.0,76.0,27.0,27.0,50.0,55.0,68.0,62.0,67.0,27.0" style="Table2">
 193       <tr>
 194         <td>
 195           <para style="terp_default_8">
 196             <font color="white"> </font>
 197           </para>
 198         </td>
 199         <td>
 200           <para style="terp_default_8">
 201             <font color="white"> </font>
 202           </para>
 203         </td>
 204         <td>
 205           <para style="terp_default_8">
 206             <font color="white"> </font>
 207           </para>
 208         </td>
 209         <td>
 210           <para style="terp_tblheader_Details">
 211             <font color="white"> </font>
 212           </para>
 213         </td>
 214         <td>
 215           <para style="terp_default_Right_9">
 216             <font color="white"> </font>
 217           </para>
 218         </td>
 219         <td>
 220           <para style="terp_tblheader_Details">Sub-Total: </para>
 221         </td>
 222         <td>
 223           <para style="terp_default_Right_9">[[formatLang(reduce(lambda x,y: x+y['debit'], getLines(o), 0.00)) ]] [[ company.currency_id.name]] </para>
 224         </td>
 225         <td>
 226           <para style="terp_default_Right_9">[[formatLang(reduce(lambda x,y: x+y['credit'], getLines(o), 0.00)) ]] [[ company.currency_id.name]] </para>
 227         </td>
 228         <td>
 229           <para style="terp_default_Right_9">[[ formatLang(reduce(lambda x,y: x+(y['debit'] - y['credit']), filter(lambda x: x['date_maturity'] &lt; time.strftime('%Y-%m-%d'), getLines(o)), 0)) ]] [[ company.currency_id.name]]</para>
 230         </td>
 231         <td>
 232           <para style="terp_default_Right_9">
 233             <font color="white"> </font>
 234           </para>
 235         </td>
 236       </tr>
 237       <tr>
 238         <td>
 239           <para style="terp_default_8">
 240             <font color="white"> </font>
 241           </para>
 242         </td>
 243         <td>
 244           <para style="terp_default_8">
 245             <font color="white"> </font>
 246           </para>
 247         </td>
 248         <td>
 249           <para style="terp_default_8">
 250             <font color="white"> </font>
 251           </para>
 252         </td>
 253         <td>
 254           <para style="terp_tblheader_Details">
 255             <font color="white"> </font>
 256           </para>
 257         </td>
 258         <td>
 259           <para style="terp_default_Right_9">
 260             <font color="white"> </font>
 261           </para>
 262         </td>
 263         <td>
 264           <para style="terp_tblheader_Details">Balance: </para>
 265         </td>
 266         <td>
 267           <para style="terp_default_Right_9">[[ formatLang((reduce(lambda x,y: x+(y['debit'] - y['credit']), getLines(o), 0.00))) ]] [[ company.currency_id.name]] </para>
 268         </td>
 269         <td>
 270           <para style="terp_default_Right_9">
 271             <font color="white"> </font>
 272           </para>
 273         </td>
 274         <td>
 275           <para style="terp_default_8">
 276             <font color="white"> </font>
 277           </para>
 278         </td>
 279         <td>
 280           <para style="terp_default_8">
 281             <font color="white"> </font>
 282           </para>
 283         </td>
 284       </tr>
 285     </blockTable>
 286     <para style="terp_default_8">
 287       <font color="white"> </font>
 288     </para>
 289   </story>
 290 </document>