319 lines
18 KiB
XML
Executable File
319 lines
18 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-05-11T16:47:03 -->
|
|
<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="842" pageHeight="10595" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="802" 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"/>
|
|
<property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>
|
|
<template><![CDATA[$P{pathstyle}]]></template>
|
|
<parameter name="pathimage" class="java.lang.String" isForPrompting="false">
|
|
<parameterDescription><![CDATA[]]></parameterDescription>
|
|
<defaultValueExpression><![CDATA["repo:/maia/1/image/logo"]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="pathstyle" class="java.lang.String" isForPrompting="false">
|
|
<defaultValueExpression><![CDATA["repo:/maia/1/style/style"]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="workingdate" class="java.lang.String" isForPrompting="false">
|
|
<defaultValueExpression><![CDATA["2014-09-20"]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="company" class="java.lang.Integer" isForPrompting="false">
|
|
<parameterDescription><![CDATA[compania de trabajo]]></parameterDescription>
|
|
<defaultValueExpression><![CDATA[1]]></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="coordinadorMilitar" 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="SUBREPORT_DIR" class="java.lang.String">
|
|
<defaultValueExpression><![CDATA["repo:/maia/1/modules/armas/subreports/"]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="nombreJefCentro" class="java.lang.String"/>
|
|
<parameter name="personCodeJefCentro" class="java.lang.String"/>
|
|
<parameter name="idCentroControl" class="java.lang.String"/>
|
|
<parameter name="nombreCentroControl" class="java.lang.String"/>
|
|
<queryString language="SQL">
|
|
<![CDATA[select ROW_NUMBER() OVER (order by lec.fecha) as numrow,
|
|
arm.codigoarma as codigoarma,
|
|
(select clase.description from tgenecatalogdetail clase where clase.catalog=tiparmexp.clase and clase.catalogcode=tiparmexp.clasecodigo) as clase,
|
|
(select tipo.description from tgenecatalogdetail tipo where tipo.catalog=tiparmexp.tipoarmaexplosivo and tipo.catalogcode=tiparmexp.tipoarmaexplosivocodigo) as tipo,
|
|
arm.marca as marca,
|
|
(select calibre.description from tgenecatalogdetail calibre where calibre.catalog=tiparmexp.calibre and calibre.catalogcode=tiparmexp.calibrecodigo) as calibre,
|
|
arm.modelo as modelo,
|
|
(select color.description from tgenecatalogdetail color where color.catalog=arm.color and color.catalogcode=arm.colorcodigo) as color,
|
|
arm.lote as serielote, to_char(lec.fecha,'dd-MM-yyyy') as fecha
|
|
from tarmtagarma tagarm
|
|
left join tarmlecturadetalle lecdet on tagarm.ctag = lecdet.codigotag
|
|
left join tarmlectura lec on lecdet.clectura = lec.clectura
|
|
left join tarmarmas arm on arm.carma = tagarm.carma
|
|
left join tarmtipoarmaexplosivo tiparmexp on arm.ctipoarmaexplosivo = tiparmexp.ctipoarmaexplosivo
|
|
where lec.fecha <= to_date($P{fechaFin},'dd-MM-yyyy') and arm.carma in (
|
|
select tagarm.carma from tarmtagarma tagarm
|
|
left join tarmlecturadetalle lecdet on tagarm.ctag = lecdet.codigotag
|
|
left join tarmlectura lec on lecdet.clectura = lec.clectura
|
|
left join tarmcencontroljur cenconjur on lec.provincecode = cenconjur.provincecode
|
|
left join tarmcentrocontrol cencon on cenconjur.ccentrocontrol = cencon.ccentrocontrol
|
|
where cencon.ccentrocontrol = $P{idCentroControl} and tagarm.carma in (
|
|
select bod.carma from tarmbodega bod where bod.ccentrocontrol = $P{idCentroControl}))]]>
|
|
</queryString>
|
|
<group name="ArmasLeidasExiteBodega">
|
|
<groupHeader>
|
|
<band height="70">
|
|
<subreport>
|
|
<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="786" height="70" isRemoveLineWhenBlank="true" isPrintWhenDetailOverflows="true" uuid="3823b69a-16e5-44fc-8b07-a73626cc89c3">
|
|
<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>
|
|
<subreportParameter name="fechaFin">
|
|
<subreportParameterExpression><![CDATA[$P{fechaFin}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<subreportParameter name="idCentroControl">
|
|
<subreportParameterExpression><![CDATA[$P{idCentroControl}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
|
|
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "armasLeidasExistenBodega"]]></subreportExpression>
|
|
</subreport>
|
|
</band>
|
|
</groupHeader>
|
|
</group>
|
|
<group name="ArmasLeidasNoExisteBodega">
|
|
<groupHeader>
|
|
<band height="70">
|
|
<subreport>
|
|
<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="786" height="70" isRemoveLineWhenBlank="true" isPrintWhenDetailOverflows="true" uuid="9671f368-80db-44d2-b121-63927d4fcfd8">
|
|
<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>
|
|
<subreportParameter name="fechaFin">
|
|
<subreportParameterExpression><![CDATA[$P{fechaFin}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<subreportParameter name="idCentroControl">
|
|
<subreportParameterExpression><![CDATA[$P{idCentroControl}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
|
|
<subreportExpression><![CDATA[$P{SUBREPORT_DIR}+"armasLeidasNoExistenBodega"]]></subreportExpression>
|
|
</subreport>
|
|
</band>
|
|
</groupHeader>
|
|
</group>
|
|
<group name="ArmasNoLeidasExisteBodega">
|
|
<groupHeader>
|
|
<band height="70">
|
|
<subreport>
|
|
<reportElement x="0" y="0" width="786" height="70" isRemoveLineWhenBlank="true" isPrintWhenDetailOverflows="true" uuid="9bc8d90e-f018-4298-8227-3c1fa57d7c72">
|
|
<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"/>
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
</reportElement>
|
|
<subreportParameter name="fechaFin">
|
|
<subreportParameterExpression><![CDATA[$P{fechaFin}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<subreportParameter name="idCentroControl">
|
|
<subreportParameterExpression><![CDATA[$P{idCentroControl}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
|
|
<subreportExpression><![CDATA[$P{SUBREPORT_DIR}+"armasNoLeidasExistenBodega"]]></subreportExpression>
|
|
</subreport>
|
|
</band>
|
|
</groupHeader>
|
|
</group>
|
|
<background>
|
|
<band splitType="Stretch"/>
|
|
</background>
|
|
<title>
|
|
<band height="116" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<staticText>
|
|
<reportElement style="title" x="93" y="16" width="527" 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"/>
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
</reportElement>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[COMANDO CONJUNTO DE LAS FUERZAS ARMADAS]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement key="" style="title1" x="93" y="36" width="527" 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"/>
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
</reportElement>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[DEPARTAMENTO DE CONTROL DE ARMAS]]></text>
|
|
</staticText>
|
|
<image>
|
|
<reportElement x="28" y="16" width="65" 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="93" y="68" width="527" 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[INVENTARIO DE INGRESO A BODEGA]]></text>
|
|
</staticText>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="title3" stretchType="RelativeToTallestObject" x="93" y="54" width="527" 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>
|
|
<image>
|
|
<reportElement x="620" y="1" width="90" height="106" 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>
|
|
<textField>
|
|
<reportElement style="subtitle" x="93" y="84" width="527" height="16" uuid="bd52d05f-7aef-4dc8-a1e7-cc3628cc01b7">
|
|
<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"/>
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
</reportElement>
|
|
<box topPadding="2"/>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA["Fecha/Hora emisión:" + $P{fechaReporte}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</title>
|
|
<pageHeader>
|
|
<band splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
</band>
|
|
</pageHeader>
|
|
<columnFooter>
|
|
<band height="10" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
</band>
|
|
</columnFooter>
|
|
<pageFooter>
|
|
<band height="10" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
</band>
|
|
</pageFooter>
|
|
<summary>
|
|
<band height="95" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<textField>
|
|
<reportElement style="normal1" positionType="FixRelativeToBottom" x="0" y="60" width="685" 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="Center" verticalAlignment="Bottom"/>
|
|
<textFieldExpression><![CDATA[$P{nombreJefCentro}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement style="normal1" x="0" y="75" width="685" 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"/>
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
</reportElement>
|
|
<box topPadding="2"/>
|
|
<textElement textAlignment="Center" verticalAlignment="Bottom"/>
|
|
<textFieldExpression><![CDATA["JEFE DEL " + $P{nombreCentroControl}]]></textFieldExpression>
|
|
</textField>
|
|
<staticText>
|
|
<reportElement x="0" y="0" width="100" height="60" uuid="4bf323d4-2197-4aeb-a351-91859731be0f">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
</reportElement>
|
|
<text><![CDATA[ ]]></text>
|
|
</staticText>
|
|
</band>
|
|
</summary>
|
|
</jasperReport>
|