~openerp-commiter/openobject-addons/extra-6.0

« back to all changes in this revision

Viewing changes to nan_account_forecast/report/forecast.jrxml

  • Committer: Albert Cervera i Areny
  • Date: 2011-03-06 12:16:38 UTC
  • Revision ID: albert@nan-tic.com-20110306121638-i0ps4v9lq505bqgy
[ADD] nan_account_forecast: Adapt module to v6.

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
<?xml version="1.0" encoding="UTF-8"?>
 
2
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="forecast" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
 
3
        <property name="ireport.zoom" value="1.0"/>
 
4
        <property name="ireport.x" value="0"/>
 
5
        <property name="ireport.y" value="0"/>
 
6
        <style name="defecto" isDefault="true" forecolor="#000000" backcolor="#FFFFFF" fill="Solid" vAlign="Middle" markup="none" pattern="" isBlankWhenNull="true" fontName="SansSerif" fontSize="8" isBold="false" isItalic="true" isUnderline="false" pdfFontName="Helvetica-Bold"/>
 
7
        <style name="textoscabecera" style="defecto" forecolor="#000000" backcolor="#FFFFFF" radius="10" isBold="true" pdfFontName="Helvetica-Bold">
 
8
                <pen lineWidth="1.0" lineColor="#000000"/>
 
9
        </style>
 
10
        <style name="negrita" vAlign="Middle" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica-Bold"/>
 
11
        <queryString language="xPath">
 
12
                <![CDATA[]]>
 
13
        </queryString>
 
14
        <field name="id" class="java.lang.String">
 
15
                <fieldDescription><![CDATA[/data/record/id]]></fieldDescription>
 
16
        </field>
 
17
        <field name="date_maturity" class="java.util.Date">
 
18
                <fieldDescription><![CDATA[/data/record/date_maturity]]></fieldDescription>
 
19
        </field>
 
20
        <field name="debit" class="java.lang.Double">
 
21
                <fieldDescription><![CDATA[/data/record/debit]]></fieldDescription>
 
22
        </field>
 
23
        <field name="credit" class="java.lang.Double">
 
24
                <fieldDescription><![CDATA[/data/record/credit]]></fieldDescription>
 
25
        </field>
 
26
        <field name="number" class="java.lang.String">
 
27
                <fieldDescription><![CDATA[/data/record/invoice/number]]></fieldDescription>
 
28
        </field>
 
29
        <field name="comercial" class="java.lang.String">
 
30
                <fieldDescription><![CDATA[/data/record/User/company_id/partner_id/comercial]]></fieldDescription>
 
31
        </field>
 
32
        <field name="lang" class="java.lang.String">
 
33
                <fieldDescription><![CDATA[/data/record/partner_id/lang]]></fieldDescription>
 
34
        </field>
 
35
        <field name="name" class="java.lang.String">
 
36
                <fieldDescription><![CDATA[/data/record/partner_id/name]]></fieldDescription>
 
37
        </field>
 
38
        <sortField name="date_maturity"/>
 
39
        <variable name="importe" class="java.lang.Double" resetType="None">
 
40
                <variableExpression><![CDATA[($F{debit}==null ? 0.0 : $F{debit})-($F{credit}==null ? 0.0 : $F{credit})]]></variableExpression>
 
41
        </variable>
 
42
        <variable name="total-vto" class="java.lang.Double" resetType="Group" resetGroup="FECVTO" calculation="Sum">
 
43
                <variableExpression><![CDATA[$V{importe}]]></variableExpression>
 
44
        </variable>
 
45
        <variable name="acumulado" class="java.lang.Double" incrementType="Group" incrementGroup="FECVTO" calculation="Sum">
 
46
                <variableExpression><![CDATA[$V{total-vto}]]></variableExpression>
 
47
        </variable>
 
48
        <variable name="L" class="java.util.Locale">
 
49
                <variableExpression><![CDATA[$F{lang} != null && $F{lang}.length() == 5 ? new Locale( $F{lang}.substring(0,2), $F{lang}.substring(3,5) ) : ( $F{lang} != null && $F{lang}.length() == 2 ? new Locale( $F{lang}.substring(0,2) ) : $P{REPORT_LOCALE} )]]></variableExpression>
 
50
                <initialValueExpression><![CDATA[$F{lang} != null && $F{lang}.length() == 5 ? new Locale( $F{lang}.substring(0,2), $F{lang}.substring(3,5) ) : ( $F{lang} != null && $F{lang}.length() == 2 ? new Locale( $F{lang}.substring(0,2) ) : $P{REPORT_LOCALE} )]]></initialValueExpression>
 
51
        </variable>
 
52
        <group name="FECVTO">
 
53
                <groupExpression><![CDATA[$F{date_maturity}]]></groupExpression>
 
54
                <groupHeader>
 
55
                        <band height="32">
 
56
                                <textField>
 
57
                                        <reportElement style="defecto" x="46" y="10" width="124" height="19"/>
 
58
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
 
59
                                                <font size="8" isItalic="false" isUnderline="false"/>
 
60
                                        </textElement>
 
61
                                        <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Partner")]]></textFieldExpression>
 
62
                                </textField>
 
63
                                <textField>
 
64
                                        <reportElement style="defecto" x="216" y="11" width="87" height="18"/>
 
65
                                        <textElement textAlignment="Right" verticalAlignment="Middle">
 
66
                                                <font size="8" isItalic="false" isUnderline="false"/>
 
67
                                        </textElement>
 
68
                                        <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Document")]]></textFieldExpression>
 
69
                                </textField>
 
70
                                <textField>
 
71
                                        <reportElement style="defecto" x="329" y="10" width="66" height="19"/>
 
72
                                        <textElement textAlignment="Right" verticalAlignment="Middle">
 
73
                                                <font size="8" isItalic="false" isUnderline="false"/>
 
74
                                        </textElement>
 
75
                                        <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Expiry Date")]]></textFieldExpression>
 
76
                                </textField>
 
77
                                <textField>
 
78
                                        <reportElement style="defecto" x="412" y="10" width="62" height="19"/>
 
79
                                        <textElement textAlignment="Right" verticalAlignment="Middle">
 
80
                                                <font size="8" isItalic="false" isUnderline="false"/>
 
81
                                        </textElement>
 
82
                                        <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Amount")]]></textFieldExpression>
 
83
                                </textField>
 
84
                                <textField>
 
85
                                        <reportElement style="defecto" x="493" y="10" width="62" height="19"/>
 
86
                                        <textElement textAlignment="Right" verticalAlignment="Middle">
 
87
                                                <font size="8" isItalic="false" isUnderline="false"/>
 
88
                                        </textElement>
 
89
                                        <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Aggregated Amount")]]></textFieldExpression>
 
90
                                </textField>
 
91
                                <line>
 
92
                                        <reportElement x="0" y="29" width="555" height="1"/>
 
93
                                </line>
 
94
                        </band>
 
95
                </groupHeader>
 
96
                <groupFooter>
 
97
                        <band height="27">
 
98
                                <textField pattern="#,##0.00;-#,##0.00">
 
99
                                        <reportElement x="474" y="6" width="81" height="15"/>
 
100
                                        <textElement textAlignment="Right"/>
 
101
                                        <textFieldExpression class="java.lang.Double"><![CDATA[$V{acumulado}]]></textFieldExpression>
 
102
                                </textField>
 
103
                                <textField pattern="#,##0.00;-#,##0.00">
 
104
                                        <reportElement x="395" y="6" width="79" height="15"/>
 
105
                                        <textElement textAlignment="Right"/>
 
106
                                        <textFieldExpression class="java.lang.Double"><![CDATA[$V{total-vto}]]></textFieldExpression>
 
107
                                </textField>
 
108
                                <textField>
 
109
                                        <reportElement style="defecto" x="262" y="6" width="133" height="15"/>
 
110
                                        <textElement verticalAlignment="Middle">
 
111
                                                <font size="8" isItalic="false" isUnderline="false"/>
 
112
                                        </textElement>
 
113
                                        <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Expiry date totals:")]]></textFieldExpression>
 
114
                                </textField>
 
115
                        </band>
 
116
                </groupFooter>
 
117
        </group>
 
118
        <background>
 
119
                <band splitType="Stretch"/>
 
120
        </background>
 
121
        <pageHeader>
 
122
                <band height="43" splitType="Stretch">
 
123
                        <textField>
 
124
                                <reportElement style="textoscabecera" x="123" y="20" width="332" height="23"/>
 
125
                                <textElement textAlignment="Center" verticalAlignment="Middle">
 
126
                                        <font size="12" isItalic="false" isUnderline="false"/>
 
127
                                </textElement>
 
128
                                <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Payment/receivables forecast")]]></textFieldExpression>
 
129
                        </textField>
 
130
                        <textField>
 
131
                                <reportElement style="negrita" x="0" y="0" width="282" height="20"/>
 
132
                                <textElement/>
 
133
                                <textFieldExpression class="java.lang.String"><![CDATA[$F{comercial}]]></textFieldExpression>
 
134
                        </textField>
 
135
                        <textField>
 
136
                                <reportElement x="527" y="0" width="28" height="20"/>
 
137
                                <textElement textAlignment="Right"/>
 
138
                                <textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
 
139
                        </textField>
 
140
                        <textField>
 
141
                                <reportElement style="defecto" x="465" y="0" width="62" height="20"/>
 
142
                                <textElement textAlignment="Right" verticalAlignment="Middle">
 
143
                                        <font size="8" isItalic="false" isUnderline="false"/>
 
144
                                </textElement>
 
145
                                <textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Page:")]]></textFieldExpression>
 
146
                        </textField>
 
147
                        <textField pattern="dd/MM/yyyy">
 
148
                                <reportElement x="455" y="20" width="100" height="16"/>
 
149
                                <textElement textAlignment="Right"/>
 
150
                                <textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
 
151
                        </textField>
 
152
                </band>
 
153
        </pageHeader>
 
154
        <detail>
 
155
                <band height="16" splitType="Stretch">
 
156
                        <textField pattern="dd/MM/yyyy">
 
157
                                <reportElement x="313" y="0" width="82" height="15"/>
 
158
                                <textElement textAlignment="Right"/>
 
159
                                <textFieldExpression class="java.util.Date"><![CDATA[$F{date_maturity}]]></textFieldExpression>
 
160
                        </textField>
 
161
                        <textField>
 
162
                                <reportElement x="1" y="0" width="182" height="15"/>
 
163
                                <textElement/>
 
164
                                <textFieldExpression class="java.lang.String"><![CDATA[$F{name}]]></textFieldExpression>
 
165
                        </textField>
 
166
                        <textField pattern="#,##0.00;-#,##0.00">
 
167
                                <reportElement x="404" y="1" width="70" height="14"/>
 
168
                                <textElement textAlignment="Right"/>
 
169
                                <textFieldExpression class="java.lang.Double"><![CDATA[$V{importe}]]></textFieldExpression>
 
170
                        </textField>
 
171
                        <textField>
 
172
                                <reportElement x="213" y="1" width="90" height="15"/>
 
173
                                <textElement/>
 
174
                                <textFieldExpression class="java.lang.String"><![CDATA[$F{number}]]></textFieldExpression>
 
175
                        </textField>
 
176
                </band>
 
177
        </detail>
 
178
        <pageFooter>
 
179
                <band height="32" splitType="Stretch"/>
 
180
        </pageFooter>
 
181
</jasperReport>