677 lines
35 KiB
XML
Executable File
677 lines
35 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 -->
|
|
<!-- 2014-10-30T15:22:29 -->
|
|
<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="planInspeccion" pageWidth="950" pageHeight="842" columnWidth="910" 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"/>
|
|
<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="nombreCentro" class="java.lang.String"/>
|
|
<parameter name="anno" class="java.lang.String"/>
|
|
<parameter name="codigo" class="java.lang.String"/>
|
|
<parameter name="usuario" class="java.lang.String"/>
|
|
<parameter name="personcode" class="java.lang.Integer"/>
|
|
<parameter name="gradoNombreFuncionario" class="java.lang.String"/>
|
|
<parameter name="centroControl" class="java.lang.String"/>
|
|
<parameter name="SUBREPORT_DIR" class="java.lang.String">
|
|
<defaultValueExpression><![CDATA["repo:/maia/1/modules/armas/subreports/"]]></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="cplanificacion" class="java.lang.String"/>
|
|
<parameter name="fechaCorte" class="java.lang.String"/>
|
|
<parameter name="fechaHora" class="java.lang.String"/>
|
|
<queryString language="SQL">
|
|
<![CDATA[select rownum, persondet.name as nombre, persondet.identification as nodocumento
|
|
,tipotramite.description as tipotramite, uso.description as usoactividad, categoria.description as categoria,
|
|
plantramite.mes as mes,dochab.fechaexpiracion as fechacaducidad,
|
|
case when dochab.fechaexpiracion < sysdate then 'Caducado' else 'Vigente' end as estadopermiso
|
|
from tarmplanificaciontramite plantramite
|
|
left join tarmdocumentohabilitante dochab on dochab.cdocumento=plantramite.cdocumento
|
|
left join tcustpersondetail persondet on persondet.personcode=dochab.personcode
|
|
left join tarmsolicitudtramite soltram on soltram.csolicitud=dochab.csolicitud
|
|
left join tarmtramite tramite on tramite.ctramite=soltram.ctramite
|
|
left join tgenecatalogdetail tipotramite on tipotramite.catalog=tramite.tipotramite and tipotramite.catalogcode=tramite.tipotramitecodigo
|
|
left join tgenecatalogdetail uso on uso.catalog=tramite.usoactividad and uso.catalogcode=tramite.usoactividadcodigo
|
|
left join tgenecatalogdetail categoria on categoria.catalog=tramite.categoria and categoria.catalogcode=tramite.categoriacodigo
|
|
where plantramite.cplanificacion=$P{cplanificacion}]]>
|
|
</queryString>
|
|
<field name="MES" class="java.lang.String"/>
|
|
<field name="ROWNUM" class="java.lang.Integer"/>
|
|
<field name="NOMBRE" class="java.lang.String"/>
|
|
<field name="NODOCUMENTO" class="java.lang.String"/>
|
|
<field name="TIPOTRAMITE" class="java.lang.String"/>
|
|
<field name="USOACTIVIDAD" class="java.lang.String"/>
|
|
<field name="CATEGORIA" class="java.lang.String"/>
|
|
<field name="FECHACADUCIDAD" class="java.sql.Date">
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<field name="ESTADOPERMISO" class="java.lang.String"/>
|
|
<background>
|
|
<band splitType="Stretch"/>
|
|
</background>
|
|
<title>
|
|
<band height="188" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<staticText>
|
|
<reportElement style="title" x="90" y="11" width="720" height="20" forecolor="#000000" uuid="a5555ed3-8bce-44fd-afbb-28084239a1a1"/>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle"/>
|
|
<text><![CDATA[COMANDO CONJUNTO DE LAS FUERZAS ARMADAS]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement key="" style="title" x="90" y="34" width="720" height="20" forecolor="#000000" uuid="98c268e9-4cb8-4184-9c02-537b79b6957c"/>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[DEPARTAMENTO DE CONTROL DE ARMAS]]></text>
|
|
</staticText>
|
|
<textField>
|
|
<reportElement style="title2" x="90" y="57" width="417" height="20" uuid="66c548fe-eda9-4857-ba2a-7ceaf94f7402">
|
|
<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="Right" verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA["PLAN DE INSPECCIÓN ANUAL "]]></textFieldExpression>
|
|
</textField>
|
|
<staticText>
|
|
<reportElement style="title2" x="450" y="102" width="151" height="16" forecolor="#000000" uuid="630f074e-46b6-4856-8c81-6fddaad8f7c5">
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
</reportElement>
|
|
<textElement textAlignment="Left" verticalAlignment="Middle"/>
|
|
<text><![CDATA[CÓDIGO DE PLANIFICACIÓN:]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement key="" style="title2" x="2" y="103" width="178" height="16" forecolor="#000000" uuid="d727bcfa-369e-4fe4-ae20-727263e78ebe">
|
|
<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>
|
|
<textElement textAlignment="Left"/>
|
|
<text><![CDATA[AÑO:]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="2" y="139" width="178" height="16" forecolor="#000000" uuid="ac2cfc85-fc10-400c-9460-858369541de8">
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
</reportElement>
|
|
<textElement textAlignment="Left" verticalAlignment="Middle"/>
|
|
<text><![CDATA[CENTRO DE CONTROL DE ARMAS:]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="2" y="121" width="178" height="16" forecolor="#000000" uuid="17894d83-549d-4f8a-81b0-ebacbe865108">
|
|
<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>
|
|
<textElement textAlignment="Left"/>
|
|
<text><![CDATA[FECHA DE CORTE:]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="2" y="170" width="178" height="16" forecolor="#000000" uuid="14237880-3199-403c-9020-3c2db2918fe2">
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
</reportElement>
|
|
<textElement textAlignment="Left" verticalAlignment="Middle"/>
|
|
<text><![CDATA[PLANIFICACIÓN ANUAL]]></text>
|
|
</staticText>
|
|
<textField>
|
|
<reportElement style="normal" x="181" y="102" width="239" height="16" uuid="e41bc0da-4c74-410e-9183-064d196a02e5">
|
|
<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{anno}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement style="normal" x="181" y="138" width="239" height="16" uuid="f5537048-e630-4d5a-b801-d917bb2703ba">
|
|
<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{nombreCentro}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement style="normal" x="601" y="102" width="80" height="16" uuid="560acd5d-a6e2-4c62-b910-1347f9437968">
|
|
<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{codigo}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement style="normal" x="512" y="57" width="80" height="20" uuid="65ad8bb6-7188-46a9-b9e0-687137ec4e30">
|
|
<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{anno}]]></textFieldExpression>
|
|
</textField>
|
|
<image>
|
|
<reportElement x="829" y="0" width="80" height="80" uuid="44d4d929-c7be-45a9-9042-dd2e3d86129a">
|
|
<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>
|
|
<image>
|
|
<reportElement x="1" y="16" width="70" height="70" uuid="7056fdd4-2e17-443d-8efb-db582aa18fb5">
|
|
<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>
|
|
<textField>
|
|
<reportElement style="normal" x="181" y="120" width="239" height="16" uuid="0fc74f66-8d49-4a28-8c2e-82f2e6861b5e">
|
|
<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{fechaCorte}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</title>
|
|
<columnHeader>
|
|
<band height="13">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<staticText>
|
|
<reportElement style="normalNegrita" x="1" y="0" width="29" height="13" forecolor="#000000" uuid="18f49866-d0a1-48ee-9c28-68a745bcd691">
|
|
<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[No.]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="normalNegrita" x="30" y="0" width="160" height="13" forecolor="#000000" uuid="fe158943-a631-467b-8db0-1bdbc9a4c97e">
|
|
<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[NOMBRE / RAZÓN SOCIAL]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="normalNegrita" x="190" y="0" width="100" height="13" forecolor="#000000" uuid="e6eba68e-f742-498d-a62c-0cded9767d94">
|
|
<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[No. DOCUMENTO]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="normalNegrita" x="290" y="0" width="110" height="13" forecolor="#000000" uuid="32fa7e56-8dee-4ed4-90d9-76dfffd2e26f">
|
|
<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="normalNegrita" x="400" y="0" width="107" height="13" forecolor="#000000" uuid="386bbb1d-8478-4595-91c5-5d62f48feb94">
|
|
<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[USO / ACTIVIDAD]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="normalNegrita" x="507" y="0" width="86" height="13" forecolor="#000000" uuid="bbfbfdd5-1afb-4918-bf10-b4083acd3505">
|
|
<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[CATEGORÍA]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="normalNegrita" x="593" y="0" width="117" height="13" forecolor="#000000" uuid="501c1ffd-ffd8-46ad-9355-5fcbd9108fbd">
|
|
<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 CADUCIDAD]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="normalNegrita" x="710" y="0" width="110" height="13" forecolor="#000000" uuid="2eb95d73-211a-45a0-a4d8-29d121dc9afb">
|
|
<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 PERMISO]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="normalNegrita" x="820" y="0" width="90" height="13" forecolor="#000000" uuid="479a20d7-eea8-4e49-b1eb-e9a995dd8710">
|
|
<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[MES]]></text>
|
|
</staticText>
|
|
</band>
|
|
</columnHeader>
|
|
<detail>
|
|
<band height="13">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="normal" positionType="Float" stretchType="RelativeToTallestObject" x="1" y="0" width="29" height="13" isPrintWhenDetailOverflows="true" uuid="2dfdef2a-c3a0-4724-b6b2-745f57a99713">
|
|
<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" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineColor="#000000"/>
|
|
</box>
|
|
<textElement textAlignment="Left"/>
|
|
<textFieldExpression><![CDATA[$F{ROWNUM}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="normal" positionType="Float" stretchType="RelativeToTallestObject" x="30" y="0" width="160" height="13" isPrintWhenDetailOverflows="true" uuid="c4ebe119-388b-449e-974f-44a65784fc90">
|
|
<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 topPadding="2" leftPadding="2" bottomPadding="2" rightPadding="2">
|
|
<topPen lineWidth="0.5" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineColor="#000000"/>
|
|
</box>
|
|
<textElement textAlignment="Left"/>
|
|
<textFieldExpression><![CDATA[$F{NOMBRE}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="normal" positionType="Float" stretchType="RelativeToTallestObject" x="190" y="0" width="100" height="13" isPrintWhenDetailOverflows="true" uuid="9f6a3c96-4c34-4860-b176-a8b7d8be4da4">
|
|
<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" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineColor="#000000"/>
|
|
</box>
|
|
<textElement textAlignment="Right"/>
|
|
<textFieldExpression><![CDATA[$F{NODOCUMENTO}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="normal" positionType="Float" stretchType="RelativeToTallestObject" x="290" y="0" width="110" height="13" isPrintWhenDetailOverflows="true" uuid="43f7d49a-40e0-4af1-b697-900687f6771e">
|
|
<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" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineColor="#000000"/>
|
|
</box>
|
|
<textElement textAlignment="Left"/>
|
|
<textFieldExpression><![CDATA[$F{TIPOTRAMITE}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="normal" positionType="Float" stretchType="RelativeToTallestObject" x="400" y="0" width="107" height="13" isPrintWhenDetailOverflows="true" uuid="a1a3c791-d9bf-4dc6-9d4e-137356ac33b5">
|
|
<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" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineColor="#000000"/>
|
|
</box>
|
|
<textElement textAlignment="Left"/>
|
|
<textFieldExpression><![CDATA[$F{USOACTIVIDAD}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="normal" positionType="Float" stretchType="RelativeToTallestObject" x="507" y="0" width="86" height="13" isPrintWhenDetailOverflows="true" uuid="11d44b14-6a22-47cf-baac-f69037c7a8e0">
|
|
<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 topPadding="2" leftPadding="2" bottomPadding="2" rightPadding="2">
|
|
<topPen lineWidth="0.5" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineColor="#000000"/>
|
|
</box>
|
|
<textElement textAlignment="Left"/>
|
|
<textFieldExpression><![CDATA[$F{CATEGORIA}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true">
|
|
<reportElement style="normal" positionType="Float" stretchType="RelativeToTallestObject" x="593" y="0" width="117" height="13" isPrintWhenDetailOverflows="true" uuid="add624b7-60cb-45ba-9b16-0ed4c412de7b">
|
|
<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" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineColor="#000000"/>
|
|
</box>
|
|
<textElement textAlignment="Right"/>
|
|
<textFieldExpression><![CDATA[$F{FECHACADUCIDAD}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="normal" positionType="Float" stretchType="RelativeToTallestObject" x="820" y="0" width="90" height="13" isPrintWhenDetailOverflows="true" uuid="145b806b-61a5-4ecc-81c5-2600553bca1f">
|
|
<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" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineColor="#000000"/>
|
|
</box>
|
|
<textElement textAlignment="Left"/>
|
|
<textFieldExpression><![CDATA[$F{MES}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="normal" positionType="Float" stretchType="RelativeToTallestObject" x="710" y="0" width="110" height="13" isPrintWhenDetailOverflows="true" uuid="222d916c-f22b-40f0-9117-1ad339e848e6">
|
|
<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" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineColor="#000000"/>
|
|
</box>
|
|
<textElement textAlignment="Left"/>
|
|
<textFieldExpression><![CDATA[$F{ESTADOPERMISO}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</detail>
|
|
<pageFooter>
|
|
<band height="44">
|
|
<staticText>
|
|
<reportElement key="" style="title2" x="1" y="20" width="44" height="16" uuid="bb37c901-69e3-4ccd-bd23-dad4aad2d814">
|
|
<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="Left" verticalAlignment="Middle">
|
|
<font fontName="Arial"/>
|
|
</textElement>
|
|
<text><![CDATA[Usuario:]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement key="" style="title2" x="604" y="20" width="105" height="16" uuid="849f8119-1297-4cd1-afea-e4245d1caa41">
|
|
<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="Left" verticalAlignment="Middle"/>
|
|
<text><![CDATA[Fecha emisión/hora:]]></text>
|
|
</staticText>
|
|
<textField>
|
|
<reportElement style="normal" x="45" y="20" width="195" height="16" uuid="70422ed2-57c1-402a-9fc1-57464c383859">
|
|
<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" 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="Justified" verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$P{usuario}]]></textFieldExpression>
|
|
</textField>
|
|
<staticText>
|
|
<reportElement key="" style="title2" x="842" y="20" width="25" height="16" uuid="348f444c-f8a8-4441-8227-f4361a0ccedf">
|
|
<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="Left" verticalAlignment="Middle"/>
|
|
<text><![CDATA[Pág.]]></text>
|
|
</staticText>
|
|
<textField isStretchWithOverflow="true" evaluationTime="Page">
|
|
<reportElement style="normal" x="867" y="20" width="15" height="16" forecolor="#000000" uuid="a2e826b3-7ebc-487d-9815-fc2e041427b8">
|
|
<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 verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
|
|
</textField>
|
|
<staticText>
|
|
<reportElement key="" style="title2" x="882" y="20" width="10" height="16" uuid="932ab080-e51b-4792-bbd6-02cfc7da3b92">
|
|
<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="Left" verticalAlignment="Middle"/>
|
|
<text><![CDATA[ - ]]></text>
|
|
</staticText>
|
|
<textField isStretchWithOverflow="true" evaluationTime="Report">
|
|
<reportElement style="normal" x="892" y="20" width="15" height="16" forecolor="#000000" uuid="694d2c23-57f9-419e-bfe8-e8a18e750b84">
|
|
<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="Right" verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement style="normal" x="709" y="20" width="119" height="16" uuid="98a2d46c-5f94-4d0f-9d27-0833c2195d27">
|
|
<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" 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="Justified" verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$P{fechaHora}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</pageFooter>
|
|
<summary>
|
|
<band height="174" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<subreport>
|
|
<reportElement x="2" y="20" width="607" height="100" uuid="c7f1267f-3541-4374-82fc-958522757c54">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
</reportElement>
|
|
<subreportParameter name="personcode">
|
|
<subreportParameterExpression><![CDATA[$P{personcode}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
|
|
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "firmaUsuario"]]></subreportExpression>
|
|
</subreport>
|
|
<textField>
|
|
<reportElement style="normal" x="0" y="124" width="609" height="16" uuid="90f2e7d9-1570-4950-b642-580499b522db">
|
|
<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="0">
|
|
<bottomPen lineWidth="0.0"/>
|
|
</box>
|
|
<textElement textAlignment="Left" verticalAlignment="Middle">
|
|
<font size="10" isBold="false"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$P{gradoNombreFuncionario}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement style="normal" x="0" y="142" width="609" height="16" uuid="f26ecdca-c3db-4c88-a271-fc7002412ba0">
|
|
<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="0">
|
|
<bottomPen lineWidth="0.0"/>
|
|
</box>
|
|
<textElement textAlignment="Left" verticalAlignment="Middle">
|
|
<font size="10" isBold="false"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$P{centroControl}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</summary>
|
|
</jasperReport>
|