| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304 |
- <?xml version="1.0" encoding="UTF-8"?>
- <!-- Created with Jaspersoft Studio version 6.4.3.final utlizzo versione della libreria JasperReports6.4.3 -->
- <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="repDisposizioniRid" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="NoDataSection" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="78b2bfe6-e041-4a82-aa00-1decb32eca36">
- <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Sicura"/>
- <property name="com.jaspersoft.studio.unit." value="pixel"/>
- <property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>
- <property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>
- <property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>
- <property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>
- <property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>
- <property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>
- <property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
- <property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>
- <parameter name="trimestre" class="java.lang.String"/>
- <parameter name="anno" class="java.lang.String"/>
- <parameter name="idCreditore" class="java.lang.String"/>
- <queryString>
- <![CDATA[]]>
- </queryString>
- <field name="flagStampa" class="java.lang.Boolean">
- <fieldDescription><![CDATA[flagStampa]]></fieldDescription>
- </field>
- <field name="statoTipoMandato" class="java.lang.String">
- <fieldDescription><![CDATA[statoTipoMandato]]></fieldDescription>
- </field>
- <field name="idremuneration" class="java.lang.Integer">
- <fieldDescription><![CDATA[idremuneration]]></fieldDescription>
- </field>
- <field name="divisa" class="java.lang.String">
- <fieldDescription><![CDATA[divisa]]></fieldDescription>
- </field>
- <field name="tipoMandato" class="java.lang.String">
- <fieldDescription><![CDATA[tipoMandato]]></fieldDescription>
- </field>
- <field name="datarendi" class="java.util.Date">
- <fieldDescription><![CDATA[datarendi]]></fieldDescription>
- </field>
- <field name="idprevisioning" class="java.lang.Integer">
- <fieldDescription><![CDATA[idprevisioning]]></fieldDescription>
- </field>
- <field name="dataRevocaMandato" class="java.util.Date">
- <fieldDescription><![CDATA[dataRevocaMandato]]></fieldDescription>
- </field>
- <field name="prezzoUnitarioMandato" class="java.lang.String">
- <fieldDescription><![CDATA[prezzoUnitarioMandato]]></fieldDescription>
- </field>
- <field name="identificativoMandato" class="java.lang.String">
- <fieldDescription><![CDATA[identificativoMandato]]></fieldDescription>
- </field>
- <field name="dataAttivazioneMandato" class="java.util.Date">
- <fieldDescription><![CDATA[dataAttivazioneMandato]]></fieldDescription>
- </field>
- <field name="iddetail" class="java.lang.Integer">
- <fieldDescription><![CDATA[iddetail]]></fieldDescription>
- </field>
- <field name="flagNew" class="java.lang.Boolean">
- <fieldDescription><![CDATA[flagNew]]></fieldDescription>
- </field>
- <field name="tipoSeda" class="java.lang.String">
- <fieldDescription><![CDATA[tipoSeda]]></fieldDescription>
- </field>
- <field name="flagUtil" class="java.lang.Boolean">
- <fieldDescription><![CDATA[flagUtil]]></fieldDescription>
- </field>
- <field name="inquiryResponseIdentification" class="java.lang.String">
- <fieldDescription><![CDATA[inquiryResponseIdentification]]></fieldDescription>
- </field>
- <variable name="cnt" class="java.lang.Integer" calculation="Sum">
- <variableExpression><![CDATA[1]]></variableExpression>
- <initialValueExpression><![CDATA[0]]></initialValueExpression>
- </variable>
- <background>
- <band splitType="Stretch"/>
- </background>
- <title>
- <band height="85" splitType="Stretch">
- <rectangle radius="4">
- <reportElement x="-1" y="0" width="802" height="76" uuid="0f447564-02ac-4b99-988c-bbf646dae7ed"/>
- <graphicElement>
- <pen lineWidth="2.0" lineStyle="Solid"/>
- </graphicElement>
- </rectangle>
- <staticText>
- <reportElement x="2" y="3" width="338" height="41" uuid="e8ccdd76-c7a9-4e42-8d04-0cc742d5b77a"/>
- <textElement verticalAlignment="Middle">
- <font fontName="SansSerif" size="18" isBold="true" isItalic="true"/>
- </textElement>
- <text><![CDATA[Stampa dettaglio mandati SEDA]]></text>
- </staticText>
- <textField pattern="dd/MM/yyyy HH:mm">
- <reportElement x="607" y="3" width="190" height="20" uuid="c044d3ed-504c-445e-8aeb-60333c865445"/>
- <textElement textAlignment="Right" verticalAlignment="Middle"/>
- <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement x="607" y="31" width="191" height="21" uuid="a6fab253-5ecb-4de5-b0d9-323f87534b5c"/>
- <textElement textAlignment="Right" verticalAlignment="Middle">
- <font fontName="SansSerif"/>
- </textElement>
- <text><![CDATA[SICURA - Pagamenti e Incassi Telematici]]></text>
- </staticText>
- <textField isBlankWhenNull="true">
- <reportElement x="13" y="43" width="120" height="19" uuid="410b59e2-d146-4fb0-8655-51cb5dc53b3d"/>
- <textElement verticalAlignment="Middle"/>
- <textFieldExpression><![CDATA[$P{trimestre}]]></textFieldExpression>
- </textField>
- <textField isBlankWhenNull="true">
- <reportElement x="133" y="43" width="120" height="19" uuid="55ad0b2f-20bc-4b28-9533-78c109c1d0bc"/>
- <textElement verticalAlignment="Middle"/>
- <textFieldExpression><![CDATA[$P{anno}]]></textFieldExpression>
- </textField>
- <textField isBlankWhenNull="true">
- <reportElement x="267" y="43" width="120" height="19" uuid="cea3c200-f158-446b-ae4a-df118a72be2a"/>
- <textElement verticalAlignment="Middle"/>
- <textFieldExpression><![CDATA[$P{idCreditore}]]></textFieldExpression>
- </textField>
- </band>
- </title>
- <pageHeader>
- <band height="50" splitType="Stretch">
- <rectangle>
- <reportElement x="0" y="5" width="801" height="25" backcolor="#E0E0E0" uuid="f9c53436-6729-4203-bc8c-0c6b01c23252"/>
- </rectangle>
- <staticText>
- <reportElement x="2" y="8" width="111" height="20" uuid="c3571b96-c185-4d72-b0e9-33e3972bdbce"/>
- <textElement textAlignment="Center" verticalAlignment="Middle">
- <font fontName="SansSerif" isBold="true"/>
- </textElement>
- <text><![CDATA[Idenfificativo mandato]]></text>
- </staticText>
- <staticText>
- <reportElement x="118" y="8" width="88" height="20" uuid="e253f10b-b112-46cc-80ea-34987a705834"/>
- <textElement verticalAlignment="Middle">
- <font fontName="SansSerif" isBold="true"/>
- </textElement>
- <text><![CDATA[Data attivazione]]></text>
- </staticText>
- <staticText>
- <reportElement x="206" y="7" width="60" height="20" uuid="c1722263-6f90-4755-9cba-6c995ad46bf6"/>
- <textElement textAlignment="Center" verticalAlignment="Middle">
- <font fontName="SansSerif" isBold="true"/>
- </textElement>
- <text><![CDATA[Data revoca]]></text>
- </staticText>
- <staticText>
- <reportElement x="355" y="8" width="90" height="20" uuid="c8baaa1b-e5a7-4646-8d6d-d51dfaa6840f"/>
- <textElement textAlignment="Left" verticalAlignment="Middle">
- <font fontName="SansSerif" isBold="true"/>
- </textElement>
- <text><![CDATA[Stato mandato]]></text>
- </staticText>
- <staticText>
- <reportElement x="450" y="8" width="60" height="20" uuid="1ed777c7-ef7d-45c8-830a-ca751d5da699"/>
- <textElement textAlignment="Left" verticalAlignment="Middle">
- <font fontName="SansSerif" isBold="true"/>
- </textElement>
- <text><![CDATA[Prezzo unit.]]></text>
- </staticText>
- <staticText>
- <reportElement x="520" y="8" width="60" height="20" uuid="6ffed20b-99e7-4e5e-bf65-d79c433eb558"/>
- <textElement textAlignment="Left" verticalAlignment="Middle">
- <font fontName="SansSerif" isBold="true"/>
- </textElement>
- <text><![CDATA[Divisa]]></text>
- </staticText>
- <line>
- <reportElement x="1" y="30" width="798" height="1" uuid="54d7028d-d8c1-4933-b1a0-dc7e9355797e"/>
- </line>
- <line>
- <reportElement x="1" y="2" width="798" height="1" uuid="dee55795-414e-494f-84f3-867819d1feef"/>
- </line>
- <staticText>
- <reportElement x="277" y="8" width="78" height="20" uuid="0091738c-5f81-4700-aac1-ba9e4fae52af"/>
- <textElement textAlignment="Center" verticalAlignment="Middle">
- <font fontName="SansSerif" isBold="true"/>
- </textElement>
- <text><![CDATA[Origine mandato]]></text>
- </staticText>
- <staticText>
- <reportElement x="592" y="7" width="88" height="20" uuid="404a30cc-202e-4eff-90fa-fd23fc37467b"/>
- <textElement textAlignment="Left" verticalAlignment="Middle">
- <font fontName="SansSerif" isBold="true"/>
- </textElement>
- <text><![CDATA[Data acquisizione]]></text>
- </staticText>
- <staticText>
- <reportElement x="690" y="7" width="100" height="20" uuid="ecc88a64-6c16-4b03-9313-810a3052c9d2"/>
- <textElement textAlignment="Left" verticalAlignment="Middle">
- <font fontName="SansSerif" isBold="true"/>
- </textElement>
- <text><![CDATA[Tipo mandato]]></text>
- </staticText>
- </band>
- </pageHeader>
- <columnHeader>
- <band splitType="Stretch"/>
- </columnHeader>
- <detail>
- <band height="18" splitType="Stretch">
- <textField isBlankWhenNull="true">
- <reportElement x="5" y="0" width="108" height="18" uuid="a2f86cfd-075b-4e20-ab0a-a3ff4fc96a35"/>
- <textElement verticalAlignment="Middle">
- <font isBold="false"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{identificativoMandato}]]></textFieldExpression>
- </textField>
- <textField isBlankWhenNull="true">
- <reportElement x="118" y="0" width="81" height="18" uuid="ed6eed7c-30cb-4797-a20c-9fe89cc18c89"/>
- <textElement textAlignment="Center" verticalAlignment="Middle">
- <font isBold="false"/>
- </textElement>
- <textFieldExpression><![CDATA[new SimpleDateFormat("dd/MM/yyyy").format($F{dataAttivazioneMandato})]]></textFieldExpression>
- </textField>
- <textField isBlankWhenNull="true">
- <reportElement x="290" y="0" width="60" height="18" uuid="f6e625b9-2112-4a00-aba3-a71de4b4b9c9"/>
- <textElement textAlignment="Left" verticalAlignment="Middle">
- <font isBold="false"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{tipoMandato}]]></textFieldExpression>
- </textField>
- <textField isBlankWhenNull="true">
- <reportElement x="355" y="0" width="85" height="18" uuid="2cf15b2d-3be1-4d48-93b4-682bce7cd811"/>
- <textElement verticalAlignment="Middle">
- <font isBold="false"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{statoTipoMandato}]]></textFieldExpression>
- </textField>
- <textField isBlankWhenNull="true">
- <reportElement x="450" y="0" width="60" height="18" uuid="07505d9b-bc28-4345-b849-32a1773f4834"/>
- <textElement textAlignment="Right" verticalAlignment="Middle">
- <font isBold="false"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{prezzoUnitarioMandato}]]></textFieldExpression>
- </textField>
- <textField isBlankWhenNull="true">
- <reportElement x="206" y="0" width="70" height="18" uuid="a6ecdeb5-f0cd-45c7-a8d9-44ee5ca61e56"/>
- <textElement textAlignment="Center" verticalAlignment="Middle">
- <font isBold="false"/>
- </textElement>
- <textFieldExpression><![CDATA[new SimpleDateFormat("dd/MM/yyyy").format($F{dataRevocaMandato})]]></textFieldExpression>
- </textField>
- <textField isBlankWhenNull="true">
- <reportElement x="520" y="0" width="60" height="18" uuid="4e35bdfe-538f-4bc5-a16b-99abf374f88b"/>
- <textElement textAlignment="Center" verticalAlignment="Middle">
- <font isBold="false"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{divisa}]]></textFieldExpression>
- </textField>
- <textField isBlankWhenNull="true">
- <reportElement x="600" y="0" width="60" height="18" uuid="bfc6d38a-9646-4cbd-ba7a-09017eb9513a"/>
- <textElement verticalAlignment="Middle">
- <font isBold="false"/>
- </textElement>
- <textFieldExpression><![CDATA[new SimpleDateFormat("dd/MM/yyyy").format($F{datarendi})]]></textFieldExpression>
- </textField>
- <textField isBlankWhenNull="true">
- <reportElement x="690" y="0" width="100" height="18" uuid="52653189-44cc-497c-b445-f4436f69a722"/>
- <textElement verticalAlignment="Middle">
- <font isBold="false"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{tipoSeda}]]></textFieldExpression>
- </textField>
- </band>
- </detail>
- <pageFooter>
- <band height="61" splitType="Stretch">
- <textField>
- <reportElement x="299" y="20" width="100" height="30" uuid="9e11c3b5-aae2-471f-bd31-6dc5ddab4b25"/>
- <textElement textAlignment="Right">
- <font fontName="SansSerif"/>
- </textElement>
- <textFieldExpression><![CDATA["Pagina " + $V{PAGE_NUMBER}]]></textFieldExpression>
- </textField>
- <textField evaluationTime="Report">
- <reportElement x="399" y="20" width="100" height="30" uuid="e7155d4f-286f-422e-a424-c05792b02da2"/>
- <textElement textAlignment="Left">
- <font fontName="SansSerif"/>
- </textElement>
- <textFieldExpression><![CDATA[" di " + $V{PAGE_NUMBER}]]></textFieldExpression>
- </textField>
- </band>
- </pageFooter>
- <summary>
- <band height="43" splitType="Stretch">
- <textField pattern="#,##0.###">
- <reportElement x="128" y="20" width="124" height="20" uuid="8f378fe5-8cb3-45d9-82c6-300a5da958cf"/>
- <textElement textAlignment="Right" verticalAlignment="Middle">
- <font size="12"/>
- </textElement>
- <textFieldExpression><![CDATA[$V{cnt}]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement x="8" y="21" width="120" height="20" uuid="970626fa-1621-4867-be2c-8cd335ceee83"/>
- <textElement textAlignment="Left" verticalAlignment="Middle">
- <font fontName="SansSerif" size="12" isBold="true"/>
- </textElement>
- <text><![CDATA[Numero mandati:]]></text>
- </staticText>
- <line>
- <reportElement x="-2" y="10" width="798" height="1" uuid="3fd0d0e7-b6b0-4d37-8aa4-fd5bbbd8e05a"/>
- </line>
- </band>
- </summary>
- </jasperReport>
|