652 lines
34 KiB
XML
Executable File
652 lines
34 KiB
XML
Executable File
<?xml version="1.0" encoding="UTF-8"?>
|
|
<!-- Created with Jaspersoft Studio version 6.0.0.final using JasperReports Library version 6.0.0 -->
|
|
<!-- 2015-07-16T12:38:15 -->
|
|
<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="certificadosArmas" printOrder="Horizontal" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="80331279-9be4-4003-ad3d-d3b8bfdf2084">
|
|
<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.defaultdataadapter" value="One Empty Record"/>
|
|
<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="filtro" class="java.util.ArrayList"/>
|
|
<parameter name="usuario" class="java.lang.String"/>
|
|
<parameter name="unidadmilitar" class="java.lang.String"/>
|
|
<parameter name="codResponsable" class="java.lang.String"/>
|
|
<parameter name="SUBREPORT_DIR" class="java.lang.String">
|
|
<defaultValueExpression><![CDATA["repo:/maia/1/modules/armas/subreports/"]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="gradoresponsable" class="java.lang.String"/>
|
|
<parameter name="nombreresponsable" class="java.lang.String"/>
|
|
<parameter name="centrocontrol" class="java.lang.String"/>
|
|
<queryString language="SQL">
|
|
<![CDATA[select
|
|
rownum as numero,
|
|
tarma.lote as serie,
|
|
tarma.carma as carma,
|
|
tarma.codigoarma as codigoarma,
|
|
TO_CHAR (tarma.fecharegistro, 'YYYY-MM-DD') as fecharegistro,
|
|
(select prov.description
|
|
from tgenecountry prov
|
|
where prov.COUNTRYCODE=(select ra.paisorigen
|
|
from tarmregistroarmas ra
|
|
where ra.cregistro=tarma.cregistro)) as pais,
|
|
(select pd.name from tcustpersondetail pd
|
|
where pd.personcode= (select ra.personcode from tarmregistroarmas ra where ra.cregistro=tarma.cregistro) and
|
|
TO_CHAR (pd.dateto, 'YYYY/MM/DD')='2999/12/31' ) as nombre ,
|
|
(select t.description from tgenecatalogdetail t
|
|
where t.catalog= (select tp.clase from tarmtipoarmaexplosivo tp where tp.ctipoarmaexplosivo=tarma.ctipoarmaexplosivo) and
|
|
t.catalogcode=(select tp.CLASECODIGO from tarmtipoarmaexplosivo tp where tp.ctipoarmaexplosivo=tarma.ctipoarmaexplosivo)) as clase,
|
|
(select t.description from tgenecatalogdetail t
|
|
where t.catalog= (select tp.TIPOARMAEXPLOSIVO from tarmtipoarmaexplosivo tp where tp.ctipoarmaexplosivo=tarma.ctipoarmaexplosivo) and
|
|
t.catalogcode=(select tp.TIPOARMAEXPLOSIVOCODIGO from tarmtipoarmaexplosivo tp where tp.ctipoarmaexplosivo=tarma.ctipoarmaexplosivo)) as tipo,
|
|
(select t.description from tgenecatalogdetail t
|
|
where t.catalog= (select tp.CALIBRE from tarmtipoarmaexplosivo tp where tp.ctipoarmaexplosivo=tarma.ctipoarmaexplosivo) and
|
|
t.catalogcode=(select tp.CALIBRECODIGO from tarmtipoarmaexplosivo tp where tp.ctipoarmaexplosivo=tarma.ctipoarmaexplosivo) ) as calibre,
|
|
(select t.description from tgenecatalogdetail t where t.catalog=tarma.marca and t.catalogcode=tarma.marcacodigo ) as marca,
|
|
(select t.description from tgenecatalogdetail t where t.catalog=tarma.estado and t.catalogcode=tarma.estadocodigo ) as estado,
|
|
(select pd.identification from tcustpersondetail pd
|
|
where pd.personcode= (select ra.personcode from tarmregistroarmas ra where ra.cregistro=tarma.cregistro) and
|
|
TO_CHAR (pd.dateto, 'YYYY/MM/DD')='2999/12/31' ) as identification,
|
|
(select t.description from tgenecatalogdetail t
|
|
where t.catalog= (select tp.nombreinstitucion from tarmcentrocontrol tp
|
|
where tp.ccentrocontrol=(select doch.ccentrocontrol
|
|
from tarmdocumentohabilitante doch
|
|
where doch.cdocumento=(select max(dochb.cdocumento)
|
|
from tarmdocumentohabilitante dochb
|
|
where dochb.estado='APR' and dochb.codigoarma=tarma.codigoarma))) and
|
|
t.catalogcode=(select tp.nombreinstitucioncodigo from tarmcentrocontrol tp
|
|
where tp.ccentrocontrol=(select doch.ccentrocontrol
|
|
from tarmdocumentohabilitante doch
|
|
where doch.cdocumento=(select max(dochb.cdocumento)
|
|
from tarmdocumentohabilitante dochb
|
|
where dochb.estado='APR' and dochb.codigoarma=tarma.codigoarma))) ) as centro,
|
|
(case (select apruebaevaluacion from tarmarmapruebas p
|
|
where p.carmaprueba=(select max(prue.carmaprueba)
|
|
from tarmarmapruebas prue
|
|
where prue.carma in(select codar.carma
|
|
from tarmarmas codar
|
|
where codar.codigoarma =(select ar.codigoarma
|
|
from tarmarmas ar where carma=tarma.carma) )))
|
|
when 'Y' then 'APTA'
|
|
when 'N' then 'NO APTA'
|
|
else 'NA' end) as apta
|
|
from tarmarmas tarma ,
|
|
tarmregistroarmas z
|
|
where tarma.cregistro=z.cregistro
|
|
and z.personcode=52973
|
|
and tarma.estado not in ('CDP','VEND','MING','DEST','DUPL','RPER','INC')]]>
|
|
</queryString>
|
|
<field name="SERIE" class="java.lang.String"/>
|
|
<field name="ESTADO" class="java.lang.String"/>
|
|
<field name="CARMA" class="java.lang.String"/>
|
|
<field name="CODIGOARMA" class="java.lang.String"/>
|
|
<field name="FECHAREGISTRO" class="java.lang.String"/>
|
|
<field name="TIPO" class="java.lang.String"/>
|
|
<field name="NOMBRE" class="java.lang.String"/>
|
|
<field name="CALIBRE" class="java.lang.String"/>
|
|
<field name="APTA" class="java.lang.String"/>
|
|
<field name="MARCA" class="java.lang.String"/>
|
|
<field name="IDENTIFICATION" class="java.lang.String"/>
|
|
<field name="CENTRO" class="java.lang.String"/>
|
|
<field name="CLASE" class="java.lang.String"/>
|
|
<field name="PAIS" class="java.lang.String"/>
|
|
<field name="NUMERO" class="java.lang.Integer"/>
|
|
<background>
|
|
<band splitType="Stretch"/>
|
|
</background>
|
|
<title>
|
|
<band height="28" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
</band>
|
|
</title>
|
|
<pageHeader>
|
|
<band height="170" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<staticText>
|
|
<reportElement key="" style="title1" x="66" y="20" width="412" height="30" forecolor="#000000" uuid="a5555ed3-8bce-44fd-afbb-28084239a1a1">
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
</reportElement>
|
|
<textElement textAlignment="Center">
|
|
<font size="18"/>
|
|
</textElement>
|
|
<text><![CDATA[COMANDO CONJUNTO DE LAS FUERZAS ARMADAS]]></text>
|
|
</staticText>
|
|
<image>
|
|
<reportElement x="3" y="30" width="100" height="59" 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="478" y="30" width="82" height="59" uuid="560083e4-2ae5-4b08-9886-6b1c828f2fe1">
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
</reportElement>
|
|
<imageExpression><![CDATA[$P{pathLogoDerecha}]]></imageExpression>
|
|
</image>
|
|
<textField>
|
|
<reportElement style="title2" x="79" y="62" width="399" height="19" uuid="2a132cea-23ac-4c15-9c22-6c783f7b541f">
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
</reportElement>
|
|
<textElement textAlignment="Center">
|
|
<font size="13"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$P{centrocontrol}]]></textFieldExpression>
|
|
</textField>
|
|
<staticText>
|
|
<reportElement key="" style="title2" x="79" y="89" width="399" height="31" forecolor="#000000" uuid="69253d11-5c03-4784-b9e5-03354def4161">
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
</reportElement>
|
|
<textElement textAlignment="Center">
|
|
<font size="20" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[CERTIFICA]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement key="" style="title2" x="6" y="120" width="548" height="50" forecolor="#000000" uuid="9147a3e5-693f-425f-b0d4-71cc455482f4">
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
</reportElement>
|
|
<textElement textAlignment="Left" verticalAlignment="Middle">
|
|
<font fontName="LiberationSerif-Bold" size="12" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false"/>
|
|
</textElement>
|
|
<text><![CDATA[ QUE LUEGO DE HABER REVISADO LA INFORMACIÓN EN EL SISTEMA INFORMÁTICO DE CONTROL DE ARMAS, SE ENCUENTRAN REGISTRADAS LAS SIGUIENTES:]]></text>
|
|
</staticText>
|
|
</band>
|
|
</pageHeader>
|
|
<columnHeader>
|
|
<band height="30" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<staticText>
|
|
<reportElement style="title4" stretchType="RelativeToTallestObject" x="505" y="2" width="40" height="28" uuid="0c2fe402-99df-42f0-b8fc-c0035e37a97f">
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
</box>
|
|
<textElement>
|
|
<font size="6" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[ESTADO]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title4" stretchType="RelativeToTallestObject" x="180" y="2" width="55" height="28" uuid="fb42f3df-ffe5-40b3-9e35-8b649f014568">
|
|
<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"/>
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
</box>
|
|
<textElement>
|
|
<font size="6" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[FECHA DE REGISTRO]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title4" stretchType="RelativeToTallestObject" x="275" y="2" width="50" height="28" uuid="b0060cce-b1af-400b-a306-82b84330d0d9">
|
|
<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"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
</box>
|
|
<textElement>
|
|
<font fontName="Serif" size="6" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[TIPO DE ARMA]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title4" stretchType="RelativeToTallestObject" x="79" y="2" width="101" height="28" uuid="82ab01d8-7adf-432e-80c0-875980851c7f">
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
</box>
|
|
<textElement>
|
|
<font size="6" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[NOMBRE/RAZÓN SOCIAL]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement key="" style="title4" x="325" y="2" width="50" height="28" uuid="d5bc0273-94d2-4bee-a9c7-c943ce9de025">
|
|
<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"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
</box>
|
|
<textElement>
|
|
<font size="6" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[MARCA]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title4" stretchType="RelativeToTallestObject" x="375" y="2" width="40" height="28" uuid="cff51697-13fb-483e-afdd-65fe3211d15c">
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
</box>
|
|
<textElement>
|
|
<font size="6" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[CALIBRE]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title4" x="30" y="2" width="49" height="28" uuid="b5033f12-8a85-4162-b16b-5511f7ed0c34">
|
|
<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"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
</box>
|
|
<textElement>
|
|
<font size="7" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[NO. DOCUMENTO]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title4" stretchType="RelativeToTallestObject" x="415" y="2" width="45" height="28" uuid="285ca903-f9fb-4b38-8f46-8a4c30760512">
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
</box>
|
|
<textElement>
|
|
<font size="6" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[SERIE]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title4" stretchType="RelativeToTallestObject" x="235" y="2" width="40" height="28" uuid="5590569f-fbb8-4189-9104-917199292b38">
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="local_mesure_unitheight" 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" lineStyle="Solid" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
</box>
|
|
<textElement>
|
|
<font size="6" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[CLASE]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title4" stretchType="RelativeToTallestObject" x="460" y="2" width="45" height="28" uuid="99675834-81ae-4851-a53c-437e62d10529">
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
</box>
|
|
<textElement>
|
|
<font size="6" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[PAÍS FABRICACIÓN]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title4" x="0" y="2" width="30" height="28" uuid="acb0ef45-d64a-447a-a0f5-62beae125761">
|
|
<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"/>
|
|
<property name="local_mesure_unity" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
</box>
|
|
<textElement>
|
|
<font size="7" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[No]]></text>
|
|
</staticText>
|
|
</band>
|
|
</columnHeader>
|
|
<detail>
|
|
<band height="28" 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="detail2" x="30" y="0" width="49" height="28" uuid="e54d3cf1-9ae3-44cd-9a5e-bd5dff524834">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
</reportElement>
|
|
<box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
|
|
<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
</box>
|
|
<textElement>
|
|
<font size="7"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{IDENTIFICATION}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="detail2" positionType="Float" x="79" y="0" width="101" height="28" uuid="e170dce4-a4e7-4671-aaf6-b46530720151">
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.y" 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"/>
|
|
</reportElement>
|
|
<box leftPadding="0" rightPadding="0">
|
|
<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
</box>
|
|
<textElement>
|
|
<font size="7"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{NOMBRE}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="detail2" positionType="Float" x="180" y="0" width="55" height="28" uuid="31ca52ac-492d-4c96-bb67-e67ac2481750">
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
</reportElement>
|
|
<box leftPadding="0" rightPadding="0">
|
|
<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
</box>
|
|
<textElement>
|
|
<font size="7"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{FECHAREGISTRO}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="detail2" positionType="Float" x="235" y="0" width="40" height="28" uuid="26754b88-3a0f-4903-9bb9-bdeb2c564ba1">
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
</reportElement>
|
|
<box leftPadding="0" rightPadding="0">
|
|
<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
</box>
|
|
<textElement>
|
|
<font size="7"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{CLASE}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="detail2" positionType="Float" x="275" y="0" width="50" height="28" uuid="669f43ae-695f-4493-8f70-e968b03e0332">
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
</reportElement>
|
|
<box leftPadding="0" rightPadding="0">
|
|
<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
</box>
|
|
<textElement>
|
|
<font size="7"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{TIPO}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="detail2" x="325" y="0" width="50" height="28" uuid="94e2dfbf-f3ae-4fe0-90c4-80f92d4b0169">
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
</reportElement>
|
|
<box leftPadding="0" rightPadding="0">
|
|
<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
</box>
|
|
<textElement>
|
|
<font size="7"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{MARCA}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="detail2" positionType="Float" x="375" y="0" width="40" height="28" uuid="90fb9497-6f26-4d8b-8dc5-133fe5619b0a">
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
</reportElement>
|
|
<box leftPadding="0" rightPadding="0">
|
|
<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
</box>
|
|
<textElement>
|
|
<font size="7"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{CALIBRE}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="detail2" x="415" y="0" width="45" height="28" uuid="22494ef0-f771-479c-a411-670665c1fca1">
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
</reportElement>
|
|
<box leftPadding="0" rightPadding="0">
|
|
<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
</box>
|
|
<textElement>
|
|
<font size="7"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{SERIE}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="detail2" x="460" y="0" width="45" height="28" uuid="786c353b-782a-4711-9ee2-896ac17f62c7">
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
</reportElement>
|
|
<box leftPadding="0" rightPadding="0">
|
|
<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
</box>
|
|
<textElement>
|
|
<font size="7"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{PAIS}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="detail2" positionType="Float" x="505" y="0" width="40" height="28" uuid="943979ab-fe95-402a-a751-1250e63f6a4f">
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
</reportElement>
|
|
<box leftPadding="0" rightPadding="0">
|
|
<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
</box>
|
|
<textElement>
|
|
<font size="7"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{ESTADO}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="detail2" x="0" y="0" width="30" height="28" uuid="763aefb4-48a1-4cf2-a626-6812f7a996af">
|
|
<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"/>
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="local_mesure_unity" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.y" value="px"/>
|
|
</reportElement>
|
|
<box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
|
|
<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
|
|
</box>
|
|
<textElement>
|
|
<font size="7" pdfFontName=""/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{NUMERO}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</detail>
|
|
<pageFooter>
|
|
<band height="55" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
</band>
|
|
</pageFooter>
|
|
<summary>
|
|
<band height="262" 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="" x="12" y="155" width="399" height="19" uuid="c9becedb-0c8d-445e-9b0d-7a6a9565bef8">
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
</reportElement>
|
|
<textElement textAlignment="Center">
|
|
<font size="13"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$P{unidadmilitar}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="title2" x="12" y="135" width="398" height="20" uuid="e0e8fcc3-9bcc-4d31-8f68-6ab4a0a78634"/>
|
|
<textElement textAlignment="Center">
|
|
<font size="13"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$P{nombreresponsable}]]></textFieldExpression>
|
|
</textField>
|
|
<subreport>
|
|
<reportElement x="18" y="10" width="308" height="100" uuid="19b81212-4ab7-432c-98a1-cc96e2f3ff30"/>
|
|
<subreportParameter name="codResponsable">
|
|
<subreportParameterExpression><![CDATA[$P{codResponsable}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
|
|
<subreportExpression><![CDATA[$P{SUBREPORT_DIR}+ "firmaGeneralReport"]]></subreportExpression>
|
|
</subreport>
|
|
<staticText>
|
|
<reportElement style="title3" x="333" y="10" width="57" height="28" forecolor="#000000" uuid="abbf86b2-7bd4-40b8-898c-c685d9638c9d">
|
|
<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="Left">
|
|
<font size="8"/>
|
|
</textElement>
|
|
<text><![CDATA[Usuario:]]></text>
|
|
</staticText>
|
|
<textField>
|
|
<reportElement key="" style="normal" x="390" y="10" width="156" height="28" uuid="5d3776aa-0217-4094-accb-259cecd4ffa3">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
</reportElement>
|
|
<textElement>
|
|
<font size="8"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$P{usuario}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</summary>
|
|
</jasperReport>
|