maia/.svn/pristine/9e/9e0fee15f317e0ca4e27b6e0d23...

414 lines
20 KiB
XML
Executable File

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.5.1.final using JasperReports Library version 6.5.1 -->
<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="reporteTipoAutorizacion" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="80331279-9be4-4003-ad3d-d3b8bfdf2084">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="comaco"/>
<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.data.sql.tables" value=""/>
<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="filtroEstados" class="java.lang.String"/>
<parameter name="usuario" class="java.lang.String">
<parameterDescription><![CDATA[]]></parameterDescription>
</parameter>
<parameter name="fecActual" class="java.lang.String"/>
<queryString language="SQL">
<![CDATA[select
--DATOS DE LA PERSONA
personadetalle.identification as cedula,
personadetalle.name as nombre,
--DATOS DE LA SOLICITUD
actividad.description as usoactividad,
categoria.description as categoria,
autorizacion.description as tramite, count(personadetalle.identification)AS numero
from tarmsolicitud solicitud
inner join tarmsolicitudtramite soltramite on soltramite.csolicitud = solicitud.csolicitud
inner join tarmtramite tramite on tramite.ctramite = soltramite.ctramite
--TIPO DE TRAMITE
left join tgenecatalogdetail tipotramite on tipotramite.catalog=tramite.tipotramite and tipotramite.catalogcode=tramite.tipotramitecodigo
--CATEGORIA
left join tgenecatalogdetail categoria on categoria.catalog=tramite.categoria and categoria.catalogcode=tramite.categoriacodigo
--AUTORIZACION
left join tgenecatalogdetail autorizacion on autorizacion.catalog=tramite.tipoautorizacion and autorizacion.catalogcode=tramite.tipoautorizacioncodigo
--USO ACTIVIDAD
left join tgenecatalogdetail actividad on actividad.catalog=tramite.usoactividad and actividad.catalogcode=tramite.usoactividadcodigo
--DATOS DE LA PERSONA
inner join tcustperson persona on persona.personcode = solicitud.personcode
inner join tcustpersondetail personadetalle
on personadetalle.personcode = persona.personcode
and to_char(personadetalle.dateto,'yyyy-MM-dd') = '2999-12-31'
inner join tcustpersonaddress personadireccion
on personadireccion.personcode = personadetalle.personcode and personadireccion.principal = 'Y'
and personadireccion.dateto = TO_DATE (TO_CHAR (personadetalle.dateto, 'YYYY-MON-DD HH24:MI:SS'),'YYYY-MON-DD HH24:MI:SS')
left join tcustpeople p
on p.personcode = personadetalle.personcode
and p.dateto = TO_DATE (TO_CHAR (p.dateto, 'YYYY-MON-DD HH24:MI:SS'),'YYYY-MON-DD HH24:MI:SS')
--DATOS DE PAIS,PROVINCIA,CIUDAD,PARROQUIA DE LA PERSONA
inner join tgenecountry pais
on pais.countrycode = personadireccion.countrycode
inner join tgeneprovince provincia
on provincia.provincecode = personadireccion.provincecode
and provincia.countrycode = personadireccion.countrycode
inner join tgenecanton canton
on canton.cantoncode = personadireccion.cantoncode
and canton.provincecode = personadireccion.provincecode
and canton.countrycode = personadireccion.countrycode
inner join tgenecity ciudad
on ciudad.citycode = personadireccion.citycode
and ciudad.cantoncode = personadireccion.cantoncode
and ciudad.provincecode = personadireccion.provincecode
and ciudad.countrycode = personadireccion.countrycode
inner join tgeneparroquia parroquia
on parroquia.parroquiacode = personadireccion.parroquiacode
and parroquia.cantoncode = personadireccion.cantoncode
and parroquia.provincecode = personadireccion.provincecode
and parroquia.countrycode = personadireccion.countrycode
--TELEFONOS
left join tcustpersonphone phonehome
on phonehome.personcode=personadetalle.personcode
and phonehome.phonetypecatalog = 1
and to_char(phonehome.dateto,'yyyy-MM-dd') = '2999-12-31'
left join tcustpersonphone phonecel
on phonecel.personcode=personadetalle.personcode
and phonecel.phonetypecatalog = 2
and to_char(phonecel.dateto,'yyyy-MM-dd') = '2999-12-31'
--ESTADO CIVIL
left join tgenecatalogdetail estadocivil on estadocivil.catalog=p.maritalstatuscatalog
and estadocivil.catalogcode=p.maritalstatuscatalogcode
--TIPO DE PERSONA
left join tgenecatalogdetail tipopersona
on tipopersona.catalog=personadetalle.persontypecatalog
and tipopersona.catalogcode=personadetalle.persontypecatalogcode
--FECHA DE EMISION/EXPIRACION DE DOCUMENTO
inner join tarmdocumentohabilitante documento
on documento.csolicitud = solicitud.csolicitud
and documento.personcode = solicitud.personcode
--TIPO DOCUMENTO
left join tgenecatalogdetail tipodoc
on tipodoc.catalog=personadetalle.identificationcatalog
and tipodoc.catalogcode=personadetalle.identificationcatalogcode
--PROFESION
left join tgenecatalogdetail profesion
on profesion.catalog=p.professioncatalog
and profesion.catalogcode=p.professioncatalogcode
--FILTRO DE BUSQUEDA
WHERE 1=1
AND tipodoc.catalog='RUC'
$P!{filtroEstados}
GROUP BY personadetalle.identification,personadetalle.name, actividad.description, categoria.description,autorizacion.description
ORDER BY personadetalle.name]]>
</queryString>
<field name="CEDULA" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="CEDULA"/>
</field>
<field name="NOMBRE" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="NOMBRE"/>
</field>
<field name="USOACTIVIDAD" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="USOACTIVIDAD"/>
</field>
<field name="CATEGORIA" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="CATEGORIA"/>
</field>
<field name="TRAMITE" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="TRAMITE"/>
</field>
<field name="NUMERO" class="java.math.BigDecimal">
<property name="com.jaspersoft.studio.field.label" value="NUMERO"/>
</field>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="119" splitType="Stretch">
<property name="local_mesure_unitheight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<staticText>
<reportElement style="title1" x="113" y="0" width="587" 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="title1" x="113" y="20" width="587" 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="23" y="0" width="90" 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="701" y="0" width="90" 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>
<staticText>
<reportElement key="" style="title1" x="24" y="80" width="767" height="24" forecolor="#000000" uuid="e1bc5026-43c0-483c-869e-7ea6c5921cdb"/>
<textElement textAlignment="Center"/>
<text><![CDATA[REPORTE POR TIPO DE TRÁMITE]]></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"/>
</band>
</pageHeader>
<columnHeader>
<band height="35" splitType="Stretch">
<property name="local_mesure_unitheight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<staticText>
<reportElement style="title2" x="394" y="5" width="150" 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[TRÁMITE]]></text>
</staticText>
<staticText>
<reportElement style="title2" x="100" y="5" width="294" 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[NOMBRE COMPANIA]]></text>
</staticText>
<staticText>
<reportElement style="title2" x="544" y="5" width="125" height="30" forecolor="#000000" uuid="fa938e82-63a8-4120-b4a3-7d35660c5ba2">
<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"/>
</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="title2" x="0" y="5" width="100" height="30" forecolor="#000000" uuid="00394182-17b7-47f6-9549-627b45e81f1d">
<property name="local_mesure_unitx" value="pixel"/>
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="local_mesure_unitwidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="local_mesure_unitheight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<box>
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center"/>
<text><![CDATA[IDENTIFICACIÓN]]></text>
</staticText>
<staticText>
<reportElement style="title2" x="669" y="5" width="125" height="30" forecolor="#000000" uuid="4785accc-f34b-436d-be2e-9bb7d7f5f7b1">
<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"/>
</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]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="30" 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="544" y="0" width="125" height="30" uuid="269ed43f-19ca-4d23-9f18-ae029dd5015b">
<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" leftPadding="3">
<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 x="100" y="0" width="294" height="30" uuid="0726ee18-ce78-4330-8148-d30aee5b15fa"/>
<box leftPadding="3">
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{NOMBRE}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="394" y="0" width="150" height="30" uuid="89d8f90b-483c-44d6-8ca5-1356173ae311"/>
<box leftPadding="3">
<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 x="0" y="0" width="100" height="30" uuid="debce853-6423-48bb-89b0-7fb89b73424a"/>
<box leftPadding="5">
<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="669" y="0" width="125" height="30" uuid="435e1f0b-63ad-48ff-9f8b-98e1e3c36357">
<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" leftPadding="3">
<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>
</band>
</detail>
<pageFooter>
<band height="43">
<staticText>
<reportElement style="title1" x="91" y="2" width="75" 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="399" y="3" width="126" 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="166" y="0" width="135" 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="525" y="1" width="155" 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>