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"/>
10
<style name="negrita" vAlign="Middle" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica-Bold"/>
11
<queryString language="xPath">
14
<field name="id" class="java.lang.String">
15
<fieldDescription><![CDATA[/data/record/id]]></fieldDescription>
17
<field name="date_maturity" class="java.util.Date">
18
<fieldDescription><![CDATA[/data/record/date_maturity]]></fieldDescription>
20
<field name="debit" class="java.lang.Double">
21
<fieldDescription><![CDATA[/data/record/debit]]></fieldDescription>
23
<field name="credit" class="java.lang.Double">
24
<fieldDescription><![CDATA[/data/record/credit]]></fieldDescription>
26
<field name="number" class="java.lang.String">
27
<fieldDescription><![CDATA[/data/record/invoice/number]]></fieldDescription>
29
<field name="comercial" class="java.lang.String">
30
<fieldDescription><![CDATA[/data/record/User/company_id/partner_id/comercial]]></fieldDescription>
32
<field name="lang" class="java.lang.String">
33
<fieldDescription><![CDATA[/data/record/partner_id/lang]]></fieldDescription>
35
<field name="name" class="java.lang.String">
36
<fieldDescription><![CDATA[/data/record/partner_id/name]]></fieldDescription>
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>
42
<variable name="total-vto" class="java.lang.Double" resetType="Group" resetGroup="FECVTO" calculation="Sum">
43
<variableExpression><![CDATA[$V{importe}]]></variableExpression>
45
<variable name="acumulado" class="java.lang.Double" incrementType="Group" incrementGroup="FECVTO" calculation="Sum">
46
<variableExpression><![CDATA[$V{total-vto}]]></variableExpression>
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>
53
<groupExpression><![CDATA[$F{date_maturity}]]></groupExpression>
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"/>
61
<textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Partner")]]></textFieldExpression>
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"/>
68
<textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Document")]]></textFieldExpression>
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"/>
75
<textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Expiry Date")]]></textFieldExpression>
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"/>
82
<textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Amount")]]></textFieldExpression>
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"/>
89
<textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Aggregated Amount")]]></textFieldExpression>
92
<reportElement x="0" y="29" width="555" height="1"/>
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>
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>
109
<reportElement style="defecto" x="262" y="6" width="133" height="15"/>
110
<textElement verticalAlignment="Middle">
111
<font size="8" isItalic="false" isUnderline="false"/>
113
<textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Expiry date totals:")]]></textFieldExpression>
119
<band splitType="Stretch"/>
122
<band height="43" splitType="Stretch">
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"/>
128
<textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Payment/receivables forecast")]]></textFieldExpression>
131
<reportElement style="negrita" x="0" y="0" width="282" height="20"/>
133
<textFieldExpression class="java.lang.String"><![CDATA[$F{comercial}]]></textFieldExpression>
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>
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"/>
145
<textFieldExpression class="java.lang.String"><![CDATA[tr($V{L},"Page:")]]></textFieldExpression>
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>
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>
162
<reportElement x="1" y="0" width="182" height="15"/>
164
<textFieldExpression class="java.lang.String"><![CDATA[$F{name}]]></textFieldExpression>
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>
172
<reportElement x="213" y="1" width="90" height="15"/>
174
<textFieldExpression class="java.lang.String"><![CDATA[$F{number}]]></textFieldExpression>
179
<band height="32" splitType="Stretch"/>