738 lines
36 KiB
XML
Executable File
738 lines
36 KiB
XML
Executable File
<?xml version="1.0" encoding="UTF-8"?>
|
|
<!-- Created with Jaspersoft Studio version 5.6.1.final using JasperReports Library version 5.6.1 -->
|
|
<!-- 2015-10-02T16:14:37 -->
|
|
<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="reporteTramiteXCentro" pageWidth="1860" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="1820" 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"/>
|
|
<queryString language="SQL">
|
|
<![CDATA[select (select cdcentro.description from tgenecatalogdetail cdCentro where cdCentro.catalog = cc.nombreinstitucion and cdCentro.catalogcode = cc.nombreinstitucioncodigo ) as centrocontrol,
|
|
pd.identification as cedula,
|
|
pd.name as nombres,
|
|
(select cd.description from tgenecatalogdetail cd where cd.catalog = a.tipotramite and cd.catalogcode = a.tipotramitecodigo) as tipotramite,
|
|
(select cd1.description from tgenecatalogdetail cd1 where cd1.catalog = a.tipoautorizacion and cd1.catalogcode = a.tipoautorizacioncodigo) as tramite,
|
|
(select cd2.description from tgenecatalogdetail cd2 where cd2.catalog = a.categoria and cd2.catalogcode = a.categoriacodigo) as categoria,
|
|
(select cd3.description from tgenecatalogdetail cd3 where cd3.catalog = a.usoactividad and cd3.catalogcode = a.usoactividadcodigo) as usoactividad,
|
|
(select numerotramite from tarmsolicitudtramite st where st.csolicitud=h.csolicitud) as numtramite,
|
|
h.fechaemision as fechaemision,
|
|
(select cd4.description from tgenecatalogdetail cd4 where cd4.catalog = h.estado and cd4.catalogcode = h.estadocode) as estado,
|
|
h.fechaexpiracion as fechaexpiracion,
|
|
(select max(pa.address) from tcustpersonaddress pa where pa.addresstypecatalog = 3 and pa.personcode = pd.personcode and pa.dateto = pd.dateto ) as email,
|
|
(select max(phone.phonenumber) from tcustpersonphone phone where phone.phonetypecatalog in (1,2) and phone.personcode = pd.personcode and phone.dateto = pd.dateto) as telefono
|
|
from tarmdocumentohabilitante h
|
|
inner join tarmtramite a on a.ctramite=h.ctramite
|
|
inner join tcustpersondetail pd on h.personcode = pd.personcode and to_char(pd.dateto,'yyyy-MM-dd') = '2999-12-31'
|
|
left join tarmcentrocontrol cc on h.ccentrocontrol = cc.ccentrocontrol
|
|
where trunc(h.fechaemision) >= to_date($P{fechainicial},'dd/MM/yyyy') and trunc(h.fechaemision) <= to_date($P{fechafinal},'dd/MM/yyyy')
|
|
$P!{filtro}
|
|
$P!{filtro2}
|
|
order by h.fechaemision]]>
|
|
</queryString>
|
|
<field name="centrocontrol" class="java.lang.String"/>
|
|
<field name="cedula" class="java.lang.String"/>
|
|
<field name="nombres" class="java.lang.String"/>
|
|
<field name="tipotramite" class="java.lang.String"/>
|
|
<field name="tramite" class="java.lang.String"/>
|
|
<field name="categoria" class="java.lang.String"/>
|
|
<field name="usoactividad" class="java.lang.String"/>
|
|
<field name="numtramite" class="java.lang.String"/>
|
|
<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="email" class="java.lang.String"/>
|
|
<field name="telefono" class="java.lang.String"/>
|
|
<background>
|
|
<band splitType="Stretch"/>
|
|
</background>
|
|
<title>
|
|
<band height="120" 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 DE TRÁMITES EMITIDOS POR CENTRO DE CONTROL]]></text>
|
|
</staticText>
|
|
</band>
|
|
</title>
|
|
<pageHeader>
|
|
<band height="15" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<staticText>
|
|
<reportElement style="title1" x="310" y="0" width="210" height="15" forecolor="#000000" uuid="56acc6fb-fa8e-4cad-9f8e-258e80aa2ac6">
|
|
<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="Right"/>
|
|
<text><![CDATA[Del:]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title1" x="620" y="0" width="90" height="15" forecolor="#000000" uuid="c5eb02a0-9486-4768-9377-8409bef67dfc">
|
|
<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="Left"/>
|
|
<text><![CDATA[Al:]]></text>
|
|
</staticText>
|
|
<textField>
|
|
<reportElement style="normal" x="520" y="0" width="100" height="15" uuid="109b8f09-9347-49e0-8aa6-c20fc6ae2695">
|
|
<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{fechainicial}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement style="normal" x="710" y="0" width="120" height="15" uuid="9deefd1a-47a4-4dde-aa9d-ce9292228564">
|
|
<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{fechafinal}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</pageHeader>
|
|
<columnHeader>
|
|
<band height="30" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<staticText>
|
|
<reportElement style="title2" x="0" y="0" width="30" height="30" forecolor="#000000" uuid="a56649bd-1301-4722-93ab-4296227efea9">
|
|
<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[No.]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="210" y="0" width="100" height="30" forecolor="#000000" uuid="2855d5a8-74a4-4103-a919-ee42294f8267">
|
|
<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[No. DOCUEMENTO]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="310" y="0" width="210" 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="520" y="0" width="100" 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[TIPO DE TRÁMITE]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="620" y="0" width="90" 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[TRÁMITE]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="710" y="0" width="120" 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[CATEGORIA]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="30" y="0" width="180" 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[CENTRO DE CONTROL]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="830" y="0" 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[USO / ACTIVIDAD]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="1040" y="0" 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="940" y="0" width="100" 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[No. TRÁMITE]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="1320" y="0" width="200" height="30" forecolor="#000000" uuid="8590d6ce-b503-4a0c-9265-6e91446c5c5c">
|
|
<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 DOCUMENTO HABILITANTE]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="1180" y="0" width="140" height="30" forecolor="#000000" uuid="f20ca8d6-0d0f-44ec-b587-646dff9e5fb5">
|
|
<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="1520" y="0" width="180" height="30" forecolor="#000000" uuid="e45135e0-0e5f-470f-b450-6775e1dd212d">
|
|
<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="local_mesure_unitwidth" value="pixel"/>
|
|
<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[CORREO]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="1700" y="0" width="120" height="30" forecolor="#000000" uuid="dd31049e-d39c-4c52-8827-9226ee0b6378">
|
|
<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="local_mesure_unitwidth" value="pixel"/>
|
|
<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[TELÉFONO]]></text>
|
|
</staticText>
|
|
</band>
|
|
</columnHeader>
|
|
<detail>
|
|
<band height="35" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="30" y="0" width="180" height="35" uuid="cca39fa0-e5b7-47df-aeaf-1915eca0bc52">
|
|
<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">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$F{centrocontrol}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="210" y="0" width="100" height="35" uuid="b9cd0a92-e88d-4391-9f04-9f3761421d7f">
|
|
<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">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$F{cedula}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="310" y="0" width="210" height="35" uuid="cf917455-bb3a-4477-9269-1dc14b7e565b">
|
|
<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">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$F{nombres}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="520" y="0" width="100" height="35" uuid="5a1a4e83-9287-418d-b1e7-c644d4dcb225">
|
|
<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">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$F{tipotramite}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="620" y="0" width="90" height="35" uuid="bf884994-f5ca-4858-b88d-b9721d410c9f">
|
|
<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">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$F{tramite}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="710" y="0" width="120" height="35" uuid="1694bb05-b624-4f3e-898e-bd661de04cd5">
|
|
<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">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$F{categoria}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="830" y="0" width="110" height="35" uuid="44c0bdb5-671d-4505-95a6-7a9cbf0c323e">
|
|
<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">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$F{usoactividad}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="1040" y="0" width="140" height="35" uuid="8db87210-9520-408e-844c-22fb125e525a">
|
|
<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">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[new SimpleDateFormat("dd/MM/yyyy").format($F{fechaemision})]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="0" y="0" width="30" height="35" uuid="4e16d257-6f0a-4fc0-9189-595b2ff0e6ab">
|
|
<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">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="940" y="0" width="100" height="35" uuid="2ce460e2-81a8-4404-94a2-fb48b8e0a3a6">
|
|
<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">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$F{numtramite}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="1320" y="0" width="200" height="35" uuid="ab7f0cf8-6b24-4a7e-a2e3-0a9d7a247020">
|
|
<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">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$F{estado}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="1180" y="0" width="140" height="35" uuid="fbc8a961-8b92-486d-88b1-cda90598c988">
|
|
<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">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[new SimpleDateFormat("dd/MM/yyyy").format($F{fechaexpiracion})]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="1520" y="0" width="180" height="35" uuid="126a5e7f-e98b-44c0-8ab0-f3e2256caee0">
|
|
<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">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$F{email}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="1700" y="0" width="120" height="35" uuid="1040662b-ed07-49af-be26-2543053b9f86">
|
|
<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"/>
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
</reportElement>
|
|
<box topPadding="2">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$F{telefono}]]></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>
|