513 lines
24 KiB
XML
Executable File
513 lines
24 KiB
XML
Executable File
<?xml version="1.0" encoding="UTF-8"?>
|
|
<!-- Created with Jaspersoft Studio version 6.0.0.final using JasperReports Library version 6.0.0 -->
|
|
<!-- 2021-09-23T22:04:04 -->
|
|
<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="reporteAgenciaSucursal" pageWidth="1750" pageHeight="852" whenNoDataType="AllSectionsNoDetail" columnWidth="1680" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="80331279-9be4-4003-ad3d-d3b8bfdf2084">
|
|
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="oracle"/>
|
|
<property name="ireport.zoom" value="1.0"/>
|
|
<property name="ireport.x" value="0"/>
|
|
<property name="ireport.y" value="0"/>
|
|
<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"/>
|
|
<template><![CDATA[$P{pathstyle}]]></template>
|
|
<parameter name="pathstyle" class="java.lang.String" isForPrompting="false">
|
|
<defaultValueExpression><![CDATA["repo:/maia/1/style/style"]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="pathLogoIzquierda" class="java.lang.String">
|
|
<defaultValueExpression><![CDATA["repo:/maia/1/image/comandoconjunto"]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="pathLogoDerecha" class="java.lang.String">
|
|
<defaultValueExpression><![CDATA["repo:/maia/1/image/selloarmas"]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="centroControl" class="java.lang.String"/>
|
|
<parameter name="usuario" class="java.lang.String">
|
|
<parameterDescription><![CDATA[]]></parameterDescription>
|
|
</parameter>
|
|
<parameter name="fecActual" class="java.lang.String"/>
|
|
<parameter name="fechainicial" class="java.lang.String"/>
|
|
<parameter name="fechafinal" class="java.lang.String">
|
|
<parameterDescription><![CDATA[]]></parameterDescription>
|
|
</parameter>
|
|
<parameter name="filtro" class="java.lang.String"/>
|
|
<parameter name="filtro2" class="java.lang.String"/>
|
|
<parameter name="nombreRazonSocial" class="java.lang.String"/>
|
|
<queryString language="SQL">
|
|
<![CDATA[SELECT
|
|
(select p.IDENTIFICATION from TCUSTPERSONDETAIL p where p.PERSONCODE=doch.PERSONCODE and TO_CHAR(p.DATETO,'yyyy/MM')='2999/12') identificacion,
|
|
(select p.NAME from TCUSTPERSONDETAIL p where p.PERSONCODE=doch.PERSONCODE and TO_CHAR(p.DATETO,'yyyy/MM')='2999/12') razonSocial,
|
|
(SELECT nombre FROM TARMAGENCIASUCURSAL where cagencia=(SELECT CAGENCIA FROM TARMSOLICITUDAGENCIASUCURSAL where CSOLICITUD =doch.CSOLICITUD)) agencia,
|
|
(select pro.description from tgenecanton pro where
|
|
pro.COUNTRYCODE=(SELECT COUNTRYCODE FROM TARMAGENCIASUCURSAL where cagencia=(SELECT CAGENCIA FROM TARMSOLICITUDAGENCIASUCURSAL where CSOLICITUD =doch.CSOLICITUD))
|
|
and pro.provincecode=(SELECT provincecode FROM TARMAGENCIASUCURSAL where cagencia=(SELECT CAGENCIA FROM TARMSOLICITUDAGENCIASUCURSAL where CSOLICITUD =doch.CSOLICITUD))
|
|
and pro.cantoncode=(SELECT cantoncode FROM TARMAGENCIASUCURSAL where cagencia=(SELECT CAGENCIA FROM TARMSOLICITUDAGENCIASUCURSAL where CSOLICITUD =doch.CSOLICITUD))) canton,
|
|
(SELECT direccion FROM TARMAGENCIASUCURSAL where cagencia=(SELECT CAGENCIA FROM TARMSOLICITUDAGENCIASUCURSAL where CSOLICITUD =doch.CSOLICITUD)) direccion,
|
|
(SELECT responsable FROM TARMAGENCIASUCURSAL where cagencia=(SELECT CAGENCIA FROM TARMSOLICITUDAGENCIASUCURSAL where CSOLICITUD =doch.CSOLICITUD)) responsable,
|
|
(SELECT telefono FROM TARMAGENCIASUCURSAL where cagencia=(SELECT CAGENCIA FROM TARMSOLICITUDAGENCIASUCURSAL where CSOLICITUD =doch.CSOLICITUD)) telefono,
|
|
doch.fechaemision,doch.fechaexpiracion,
|
|
(select cd.description from tgenecatalogdetail cd where cd.catalog = doch.estado and cd.catalogcode = doch.estadocode) estado
|
|
FROM TARMDOCUMENTOHABILITANTE doch
|
|
WHERE
|
|
doch.fechaexpiracion>= sysdate and
|
|
CTRAMITE in $P!{filtro} and doch.PERSONCODE=$P!{filtro2}]]>
|
|
</queryString>
|
|
<field name="fechaemision" class="java.util.Date"/>
|
|
<field name="estado" class="java.lang.String">
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<field name="fechaexpiracion" class="java.util.Date"/>
|
|
<field name="telefono" class="java.lang.String"/>
|
|
<field name="identificacion" class="java.lang.String"/>
|
|
<field name="razonSocial" class="java.lang.String"/>
|
|
<field name="agencia" class="java.lang.String"/>
|
|
<field name="responsable" class="java.lang.String"/>
|
|
<field name="canton" class="java.lang.String"/>
|
|
<field name="direccion" class="java.lang.String"/>
|
|
<background>
|
|
<band splitType="Stretch"/>
|
|
</background>
|
|
<title>
|
|
<band height="139" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<staticText>
|
|
<reportElement style="title" x="310" y="0" width="520" height="20" forecolor="#000000" uuid="a5555ed3-8bce-44fd-afbb-28084239a1a1"/>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[COMANDO CONJUNTO DE LAS FUERZAS ARMADAS]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement key="" style="title" x="310" y="20" width="520" height="20" forecolor="#000000" uuid="98c268e9-4cb8-4184-9c02-537b79b6957c"/>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[DEPARTAMENTO DE CONTROL DE ARMAS]]></text>
|
|
</staticText>
|
|
<image>
|
|
<reportElement x="210" y="0" width="100" height="80" uuid="5c1c706c-0485-4d8f-be4c-9ad18ad76225">
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
</reportElement>
|
|
<imageExpression><![CDATA[$P{pathLogoIzquierda}]]></imageExpression>
|
|
</image>
|
|
<image>
|
|
<reportElement x="830" y="0" width="110" height="80" uuid="560083e4-2ae5-4b08-9886-6b1c828f2fe1">
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
</reportElement>
|
|
<imageExpression><![CDATA[$P{pathLogoDerecha}]]></imageExpression>
|
|
</image>
|
|
<textField>
|
|
<reportElement x="310" y="40" width="520" height="15" uuid="ea5cd989-52eb-4392-9940-c68a2a603e7a">
|
|
<property name="local_mesure_unity" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
</reportElement>
|
|
<box topPadding="2"/>
|
|
<textElement textAlignment="Center" verticalAlignment="Top"/>
|
|
<textFieldExpression><![CDATA[$P{centroControl}]]></textFieldExpression>
|
|
</textField>
|
|
<staticText>
|
|
<reportElement key="" style="title" x="210" y="80" width="730" height="24" forecolor="#000000" uuid="235fe168-45fe-4eae-ad17-e886b9a2c952"/>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[REPORTE ESTABLECIMIENTOS AGENCIAS SUCURSALES]]></text>
|
|
</staticText>
|
|
<textField>
|
|
<reportElement x="390" y="109" width="390" height="21" uuid="ca7a2cbb-02e3-4bb5-835d-8e3f59152cd1"/>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font size="11"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$P{nombreRazonSocial}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</title>
|
|
<pageHeader>
|
|
<band height="15" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
</band>
|
|
</pageHeader>
|
|
<columnHeader>
|
|
<band height="35" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<staticText>
|
|
<reportElement style="title2" x="100" y="5" width="250" height="30" forecolor="#000000" uuid="fa752abe-ce12-4b29-bcec-c38c3f805fcd">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[NOMBRE / RAZÓN SOCIAL]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="350" y="5" width="220" height="30" forecolor="#000000" uuid="3e5f1362-12ec-4a33-8364-453be1d29a32">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[AGENCIA]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="917" y="5" width="160" height="30" forecolor="#000000" uuid="568c65ee-758a-4290-ac21-1555c02a8188">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[RESPONSABLE]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="1077" y="5" width="100" height="30" forecolor="#000000" uuid="cea32b1b-6f9d-441e-85e1-1d3104bd6a8d">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[TELÉFONO]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="0" y="5" width="100" height="30" forecolor="#000000" uuid="dda257b1-0179-4c0a-9f16-44fdd240a2d6">
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[IDENTIFICACIÓN]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="1177" y="5" width="140" height="30" forecolor="#000000" uuid="e06e3c81-3020-4e70-96ad-7040b9ba0f23">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[FECHA EMISIÓN DOCUMENTO HABILITANTE]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="1317" y="5" width="110" height="30" forecolor="#000000" uuid="9b19de4e-1c87-4640-bd07-d00d7e0ffeb6">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[FECHA EXPIRACIÓN DOCUMENTO HABILITANTE]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="1427" y="5" width="150" height="30" forecolor="#000000" uuid="b1750c88-262a-4d7e-bb95-ef2e8c8e1807">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[ESTADO]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="570" y="5" width="125" height="30" forecolor="#000000" uuid="2499dfc3-d3f2-40b3-ae3c-587155dea66b">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[CANTÓN]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="696" y="5" width="220" height="30" forecolor="#000000" uuid="b5ed5f8a-dc51-4ffc-82a9-c8d125c4707a">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[DIRECCIÓN]]></text>
|
|
</staticText>
|
|
</band>
|
|
</columnHeader>
|
|
<detail>
|
|
<band height="27" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement x="0" y="0" width="100" height="27" uuid="5d313a24-4fd9-4cdf-902e-e581a6d96474"/>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle">
|
|
<font size="9"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{identificacion}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement x="100" y="0" width="250" height="27" uuid="dfc35025-e39d-4e72-af16-2a4b7f266804"/>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle">
|
|
<font size="9"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{razonSocial}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement x="350" y="0" width="220" height="27" uuid="19072304-e280-4001-a5ac-c30ae7cd7f7e"/>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle">
|
|
<font size="9"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{agencia}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement x="917" y="0" width="160" height="27" uuid="f32f8d7e-97d1-4b52-91c5-fd951944424f"/>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle">
|
|
<font size="9"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{responsable}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement x="1077" y="0" width="100" height="27" uuid="deb4a136-0a83-4535-a94a-847bf51ea082"/>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle">
|
|
<font size="9"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{telefono}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement x="1177" y="0" width="140" height="27" uuid="eb5136fe-108d-4a9e-b1ea-000fb0f300ff"/>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle">
|
|
<font size="9"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{fechaemision}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement x="1317" y="0" width="110" height="27" uuid="5284a79c-6e7b-4bc3-95e3-e57de2a21aa4"/>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle">
|
|
<font size="9"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{fechaexpiracion}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement x="1427" y="0" width="150" height="27" uuid="01416400-cecd-4bc2-bf29-899e5c80a523"/>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle">
|
|
<font size="9"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{estado}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement x="570" y="0" width="125" height="27" uuid="f9e6f876-90a3-465e-a432-cfeee7324709"/>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle">
|
|
<font size="9"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{canton}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement x="695" y="0" width="222" height="27" uuid="2bab8919-8c91-45f6-bf18-bf986078ed82"/>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle">
|
|
<font size="9"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{direccion}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</detail>
|
|
<pageFooter>
|
|
<band height="43">
|
|
<staticText>
|
|
<reportElement style="title1" x="210" y="0" width="100" height="15" forecolor="#000000" uuid="28269f67-c57f-4ffd-b2d4-c8967a99a79d">
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="local_mesure_unity" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
|
|
</box>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[Usuario:]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title1" x="620" y="0" width="210" height="15" forecolor="#000000" uuid="b179a9ce-90fc-4f0b-b940-0f511cce9457">
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="local_mesure_unity" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
|
|
</box>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[Fecha emisión / Hora:]]></text>
|
|
</staticText>
|
|
<textField>
|
|
<reportElement style="normal" x="310" y="0" width="310" height="15" uuid="985dd29b-bb0f-4313-ae86-6cf843c98e27">
|
|
<property name="local_mesure_unity" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
</reportElement>
|
|
<box topPadding="2"/>
|
|
<textElement verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$P{usuario}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement style="normal" x="830" y="0" width="210" height="15" uuid="4d6b7677-4142-4ad4-af37-58dc8d76aab9">
|
|
<property name="local_mesure_unity" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
</reportElement>
|
|
<box topPadding="2"/>
|
|
<textElement verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$P{fecActual}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</pageFooter>
|
|
</jasperReport>
|