750 lines
38 KiB
XML
Executable File
750 lines
38 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-14T20:42: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="inspeccionesRealizadas" pageWidth="1205" pageHeight="10595" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="1165" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isIgnorePagination="true" 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"/>
|
|
<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="fechaReporte" class="java.lang.String"/>
|
|
<parameter name="usuario" class="java.lang.String"/>
|
|
<parameter name="fechaInicio" class="java.lang.String"/>
|
|
<parameter name="fechaFin" class="java.lang.String"/>
|
|
<parameter name="nombreCentroControl" class="java.lang.String"/>
|
|
<parameter name="filtro" class="java.lang.String"/>
|
|
<queryString language="SQL">
|
|
<![CDATA[select c.ccentrocontrol,
|
|
(select cd.description from tgenecatalogdetail cd where cd.catalog = c.nombreinstitucion and cd.catalogcode = cd.catalogcode) as centro,
|
|
d.identification as cedula,
|
|
d.name as nombre,
|
|
case a.planificado
|
|
when 'N' then 'NO PLANIFICADO'
|
|
when 'P' then 'PLANIFICADO'
|
|
else
|
|
'N/A'
|
|
end as tipotramite,
|
|
a.fecharegistro as fecha,
|
|
--(select cd.description from tgenecatalogdetail cd where cd.catalog = e.tipoautorizacion and cd.catalogcode = e.tipoautorizacioncodigo) as tramite,
|
|
--(select cd.description from tgenecatalogdetail cd where cd.catalog = e.categoria and cd.catalogcode = e.categoriacodigo) as categoria,
|
|
--(select cd.description from tgenecatalogdetail cd where cd.catalog = e.usoactividad and cd.catalogcode = e.usoactividadcodigo) as usoact,
|
|
null as tramite,null as categoria,null as usoact,
|
|
a.numordentrabajo as numtramite,
|
|
d.personcode as persona,
|
|
f.csitioalmacenamiento,
|
|
f.provincecode,
|
|
c.provincecode,
|
|
resp.name as inspector
|
|
from tarminspeccion a
|
|
--left join TARMDOCUMENTOHABILITANTE b on b.personcode=a.personcode
|
|
left join tarmsitioalmacenamiento f on f.csitioalmacenamiento=a.CSITIOALMACENAMIENTO
|
|
left join tarmcentrocontrol c on c.INSTITUCION=1 and c.NOMBREINSTITUCION<>'DPCA' and c.PROVINCECODE =f.provincecode
|
|
--left join tcustpersondetail d on f.personcode = d.personcode and to_char(d.dateto,'dd-MM-yyyy') = '31-12-2999'
|
|
left join tcustpersondetail d on f.personcode = d.personcode and d.dateto = to_date('31/12/2999','dd/MM/yyyy')
|
|
left join tcustpersondetail resp on a.personcode = resp.personcode and resp.dateto = to_date('31/12/2999','dd/MM/yyyy')
|
|
--left join tarmtramite e on e.ctramite =b.ctramite
|
|
where a.fecharegistro >= to_date($P{fechaInicio} ,'dd/MM/yyyy') and a.fecharegistro <= to_date($P{fechaFin} ,'dd/MM/yyyy')
|
|
--and b.CDOCUMENTO =(select max(z.cdocumento) from tarmdocumentohabilitante z where z.personcode=a.personcode)
|
|
and a.planificado<>'T'
|
|
$P!{filtro}
|
|
union
|
|
select c.ccentrocontrol,
|
|
(select cd.description from tgenecatalogdetail cd where cd.catalog = c.nombreinstitucion and cd.catalogcode = cd.catalogcode) as centro,
|
|
d.identification as cedula,
|
|
d.name as nombre,
|
|
case a.planificado
|
|
when 'T' then 'TRÁMITE'
|
|
when 'N' then 'NO PLANIFICADO'
|
|
when 'P' then 'PLANIFICADO'
|
|
else
|
|
'N/A'
|
|
end as tipotramite,
|
|
a.fecharegistro as fecha,
|
|
(select cd.description from tgenecatalogdetail cd where cd.catalog = e.tipoautorizacion and cd.catalogcode = e.tipoautorizacioncodigo) as tramite,
|
|
(select cd.description from tgenecatalogdetail cd where cd.catalog = e.categoria and cd.catalogcode = e.categoriacodigo) as categoria,
|
|
(select cd.description from tgenecatalogdetail cd where cd.catalog = e.usoactividad and cd.catalogcode = e.usoactividadcodigo) as usoact,
|
|
a.numordentrabajo as numtramite,
|
|
d.personcode as persona,
|
|
f.csitioalmacenamiento,
|
|
f.provincecode,
|
|
c.provincecode,
|
|
resp.name as inspector
|
|
from tarminspeccion a
|
|
inner join tarmsolicitud b on b.csolicitud = a.csolicitud
|
|
inner join tarmsolicitudtramite tram on tram.csolicitud = a.csolicitud
|
|
inner join tarmsitioalmacenamiento f on f.csitioalmacenamiento=a.CSITIOALMACENAMIENTO
|
|
inner join tarmtramite e on e.ctramite = a.ctramite
|
|
inner join tcustpersondetail d on f.personcode = d.personcode and d.dateto = to_date('31/12/2999','dd/MM/yyyy')
|
|
left join tcustpersondetail resp on a.personcode = resp.personcode and resp.dateto = to_date('31/12/2999','dd/MM/yyyy')
|
|
left join tarmcentrocontrol c on b.ccentrocontrol = c.ccentrocontrol
|
|
where ((tram.valorapagar>0 and tram.valorverificado is not null) or tram.valorapagar = 0) and
|
|
a.fecharegistro >= to_date($P{fechaInicio} ,'dd/MM/yyyy') and a.fecharegistro <= to_date($P{fechaFin} ,'dd/MM/yyyy')
|
|
and a.planificado='T'
|
|
$P!{filtro}]]>
|
|
</queryString>
|
|
<field name="centro" class="java.lang.String"/>
|
|
<field name="cedula" class="java.lang.String"/>
|
|
<field name="nombre" class="java.lang.String"/>
|
|
<field name="tipotramite" class="java.lang.String"/>
|
|
<field name="fecha" class="java.util.Date"/>
|
|
<field name="tramite" class="java.lang.String"/>
|
|
<field name="categoria" class="java.lang.String"/>
|
|
<field name="usoact" class="java.lang.String"/>
|
|
<field name="numtramite" class="java.lang.String"/>
|
|
<field name="inspector" class="java.lang.String"/>
|
|
<background>
|
|
<band splitType="Stretch"/>
|
|
</background>
|
|
<title>
|
|
<band height="110" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<staticText>
|
|
<reportElement style="title" x="161" y="16" width="637" height="20" forecolor="#000000" uuid="a5555ed3-8bce-44fd-afbb-28084239a1a1">
|
|
<property name="local_mesure_unity" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
</reportElement>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[COMANDO CONJUNTO DE LAS FUERZAS ARMADAS]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement key="" style="title1" x="161" y="36" width="637" height="18" forecolor="#000000" uuid="98c268e9-4cb8-4184-9c02-537b79b6957c">
|
|
<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>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[DEPARTAMENTO DE CONTROL DE ARMAS]]></text>
|
|
</staticText>
|
|
<image>
|
|
<reportElement x="102" y="16" width="59" height="82" 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"/>
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
</reportElement>
|
|
<imageExpression><![CDATA[$P{pathLogoIzquierda}]]></imageExpression>
|
|
</image>
|
|
<staticText>
|
|
<reportElement key="" style="title2" x="161" y="68" width="637" height="16" forecolor="#000000" uuid="a056d06a-cfc1-4922-b643-c38d1a76ced3">
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
<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>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[REPORTE DE INSPECCIONES REALIZADAS]]></text>
|
|
</staticText>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="title3" stretchType="RelativeToTallestObject" x="161" y="54" width="637" height="14" forecolor="#000000" uuid="f4e50898-607e-47f7-91c1-0475bd3f03db">
|
|
<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"/>
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
</reportElement>
|
|
<box leftPadding="2" rightPadding="2">
|
|
<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" verticalAlignment="Top">
|
|
<font size="7"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$P{nombreCentroControl}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="title3" stretchType="RelativeToTallestObject" x="161" y="84" width="637" height="14" forecolor="#000000" uuid="ee1583cc-bd25-47ce-a6cf-05dbd1bdbb8c">
|
|
<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"/>
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
</reportElement>
|
|
<box leftPadding="2" rightPadding="2">
|
|
<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" verticalAlignment="Top">
|
|
<font size="7"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA["De: "+$P{fechaInicio} + " Al: "+$P{fechaFin}]]></textFieldExpression>
|
|
</textField>
|
|
<image>
|
|
<reportElement x="798" y="16" width="90" height="94" uuid="7c474f2a-dd84-49ba-9e39-27cad34e3c89">
|
|
<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_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
</reportElement>
|
|
<imageExpression><![CDATA[$P{pathLogoDerecha}]]></imageExpression>
|
|
</image>
|
|
</band>
|
|
</title>
|
|
<pageHeader>
|
|
<band splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
</band>
|
|
</pageHeader>
|
|
<columnHeader>
|
|
<band height="20" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<staticText>
|
|
<reportElement style="title2" stretchType="RelativeToTallestObject" x="0" y="0" width="16" height="20" 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"/>
|
|
<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" verticalAlignment="Top">
|
|
<font size="7" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[No.]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" stretchType="RelativeToTallestObject" x="16" y="0" width="143" height="20" 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" verticalAlignment="Top">
|
|
<font size="7" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Unidad de Control]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" stretchType="RelativeToTallestObject" x="159" y="0" width="92" height="20" 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"/>
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Top">
|
|
<font size="7" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[No. Documento]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" stretchType="RelativeToTallestObject" x="251" y="0" width="158" height="20" 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"/>
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Top">
|
|
<font size="7" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Nombre / Razón Social]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" stretchType="RelativeToTallestObject" x="409" y="0" width="123" height="20" forecolor="#000000" uuid="6e7f3ffc-cf20-4856-93aa-9fd5ac2e82d4">
|
|
<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"/>
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Top">
|
|
<font size="7" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Tipo de Inspección]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="532" y="0" width="112" height="20" 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"/>
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Top">
|
|
<font size="7" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Fecha de Inspección]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="734" y="0" width="90" height="20" forecolor="#000000" uuid="2afba5a3-c98f-4669-afe0-f80607c53b9b">
|
|
<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" verticalAlignment="Top">
|
|
<font size="7" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Categoría]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="824" y="0" width="90" height="20" forecolor="#000000" uuid="f67c4afe-34ee-4269-bf9b-6707466cc5a4">
|
|
<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_unity" value="pixel"/>
|
|
<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" verticalAlignment="Top">
|
|
<font size="7" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Uso / Actividad]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="914" y="0" width="90" height="20" forecolor="#000000" uuid="6b8188dc-5bed-4945-88de-330242f55688">
|
|
<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_unity" value="pixel"/>
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Top">
|
|
<font size="7" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[No. Trámite]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="644" y="0" width="90" height="20" forecolor="#000000" uuid="165f2283-0d40-48da-8f7e-9c65df002440">
|
|
<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"/>
|
|
<property name="local_mesure_unity" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Top">
|
|
<font size="7" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Trámite]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" stretchType="RelativeToTallestObject" x="1004" y="0" width="158" height="20" forecolor="#000000" uuid="db132574-f0c8-41b2-bc9a-7667a60b688e">
|
|
<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"/>
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Top">
|
|
<font size="7" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Inspector]]></text>
|
|
</staticText>
|
|
</band>
|
|
</columnHeader>
|
|
<detail>
|
|
<band height="39" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" stretchType="RelativeToTallestObject" x="16" y="0" width="143" height="39" forecolor="#000000" uuid="0b746cf5-9b9f-408a-95f2-9f6f27235cf3">
|
|
<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 leftPadding="2" rightPadding="2">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Top">
|
|
<font size="7"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{centro}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" stretchType="RelativeToTallestObject" x="159" y="0" width="92" height="39" forecolor="#000000" uuid="7b3c8623-50a8-46a6-931f-e30e934c25ae">
|
|
<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 leftPadding="2" rightPadding="2">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Top">
|
|
<font size="7"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{cedula}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" stretchType="RelativeToTallestObject" x="251" y="0" width="158" height="39" forecolor="#000000" uuid="c488ae93-be7c-4fef-93a5-75ad1ebc09f3">
|
|
<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 leftPadding="2" rightPadding="2">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Top">
|
|
<font size="7"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{nombre}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" stretchType="RelativeToTallestObject" x="409" y="0" width="123" height="39" forecolor="#000000" uuid="b743c7d9-fb02-4aaa-83b6-1adeef54853a">
|
|
<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 leftPadding="2" rightPadding="2">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Top">
|
|
<font size="7"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{tipotramite}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" stretchType="RelativeToTallestObject" x="532" y="0" width="112" height="39" forecolor="#000000" uuid="e20b7c15-9e6e-4a09-a855-9f305547e677">
|
|
<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 leftPadding="2" rightPadding="2">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Top">
|
|
<font size="7"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[new SimpleDateFormat("dd/MM/yyyy").format($F{fecha})]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" stretchType="RelativeToTallestObject" x="644" y="0" width="90" height="39" forecolor="#000000" uuid="bf5d9d99-cbf9-48b5-8c9c-deeacfcb0f3b">
|
|
<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 leftPadding="2" rightPadding="2">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Top">
|
|
<font size="7"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{tramite}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" stretchType="RelativeToTallestObject" x="734" y="0" width="90" height="39" forecolor="#000000" uuid="2f2ca4b3-5493-45b7-84f5-cf22b5284e39">
|
|
<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 leftPadding="2" rightPadding="2">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Top">
|
|
<font size="7"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{categoria}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" stretchType="RelativeToTallestObject" x="824" y="0" width="90" height="39" forecolor="#000000" uuid="604a8c18-eac2-414d-a1b2-cfb12a69e957">
|
|
<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 leftPadding="2" rightPadding="2">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Top">
|
|
<font size="7"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{usoact}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" stretchType="RelativeToTallestObject" x="914" y="0" width="90" height="39" forecolor="#000000" uuid="c793bb5c-81d2-4987-a6c2-6a2bce057493">
|
|
<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 leftPadding="2" rightPadding="2">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Top">
|
|
<font size="7"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{numtramite}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" stretchType="RelativeToTallestObject" x="0" y="0" width="16" height="39" forecolor="#000000" uuid="3430c213-4ff8-4fe2-85a2-7d40a776608a">
|
|
<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 leftPadding="2" rightPadding="2">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Top">
|
|
<font size="7"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$V{COLUMN_COUNT}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" stretchType="RelativeToTallestObject" x="1004" y="0" width="158" height="39" forecolor="#000000" uuid="1cfb65a8-104a-4ffa-88d0-97826abb42aa">
|
|
<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 leftPadding="2" rightPadding="2">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Top">
|
|
<font size="7"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{inspector}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</detail>
|
|
<columnFooter>
|
|
<band height="13" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
</band>
|
|
</columnFooter>
|
|
<pageFooter>
|
|
<band height="45" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<staticText>
|
|
<reportElement style="normal1" positionType="FixRelativeToBottom" x="16" y="10" width="59" height="15" forecolor="#000000" uuid="f10e06e2-6006-4d84-bd82-8e1d2ebba18d">
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
<property name="local_mesure_unity" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
<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_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
</reportElement>
|
|
<textElement textAlignment="Left" verticalAlignment="Bottom"/>
|
|
<text><![CDATA[Usuario:]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="normal1" x="302" y="10" width="85" height="15" forecolor="#000000" uuid="16571daa-4682-4619-b6d8-c9cfafcf9cd0">
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
<property name="local_mesure_unity" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
<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_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
</reportElement>
|
|
<textElement verticalAlignment="Bottom"/>
|
|
<text><![CDATA[Fecha emisión:]]></text>
|
|
</staticText>
|
|
<textField>
|
|
<reportElement style="normal1" positionType="FixRelativeToBottom" x="75" y="10" width="227" height="15" uuid="7c1010c8-a9ae-4e87-ab49-e0e1e1fdc070">
|
|
<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="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 topPadding="2"/>
|
|
<textElement textAlignment="Left" verticalAlignment="Bottom"/>
|
|
<textFieldExpression><![CDATA[$P{usuario}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement style="normal1" x="387" y="10" width="145" height="15" uuid="496d6a73-db86-4949-aa18-a8641eee6e98">
|
|
<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_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
</reportElement>
|
|
<box topPadding="2"/>
|
|
<textElement verticalAlignment="Bottom"/>
|
|
<textFieldExpression><![CDATA[$P{fechaReporte}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</pageFooter>
|
|
<summary>
|
|
<band height="25" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
</band>
|
|
</summary>
|
|
</jasperReport>
|