llopez
/
maia_modificado
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
maia_modificado/.svn/pristine/95/9532f977080af342200f5a2f320...

258 lines
13 KiB
XML
Executable File
Raw Permalink Blame History

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.0.0.final using JasperReports Library version 6.0.0 -->
<!-- 2017-07-18T23:04:27 -->
<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="reporteArmasCompania" 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="maia"/>
<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 P.NAME AS nombre, EA.DESCRIPTION AS estado, COUNT(A.CARMA) AS numero
FROM TARMREGISTROARMAS RA INNER JOIN TARMARMAS A ON RA.CREGISTRO=A.CREGISTRO
INNER JOIN TCUSTPERSONDETAIL P ON RA.PERSONCODE = P.PERSONCODE AND P.DATETO=TO_DATE('31-12-2999', 'dd/MM/yyyy')
INNER JOIN TGENECATALOGDETAIL EA ON EA.CATALOGCODE=A.ESTADOCODIGO AND EA.CATALOG=A.ESTADO
WHERE 1=1 $P!{filtroEstados}
GROUP BY P.NAME, EA.DESCRIPTION
ORDER BY P.NAME, EA.DESCRIPTION]]>
</queryString>
<field name="NOMBRE" class="java.lang.String"/>
<field name="ESTADO" class="java.lang.String"/>
<field name="NUMERO" class="java.math.BigDecimal"/>
<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 NUMERO DE ARMAS POR ESTADO]]></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="395" y="5" width="130" 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[NUMERO ARMAS]]></text>
</staticText>
<staticText>
<reportElement style="title2" x="93" y="5" width="302" 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="525" y="5" width="155" 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[ESTADO]]></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="525" y="0" width="155" 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="2">
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{ESTADO}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="93" y="0" width="302" height="30" uuid="0726ee18-ce78-4330-8148-d30aee5b15fa"/>
<box>
<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="395" y="0" width="130" height="30" uuid="89d8f90b-483c-44d6-8ca5-1356173ae311"/>
<box>
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{NUMERO}]]></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>
Reference in New Issue View Git Blame Copy Permalink