761 lines
36 KiB
XML
Executable File
761 lines
36 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-08-05T12:30: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="monedas" pageWidth="1320" pageHeight="802" whenNoDataType="AllSectionsNoDetail" columnWidth="1320" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" 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="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="centroControl" class="java.lang.String"/>
|
|
<parameter name="usuario" class="java.lang.String">
|
|
<parameterDescription><![CDATA[]]></parameterDescription>
|
|
</parameter>
|
|
<parameter name="fecActual" class="java.lang.String"/>
|
|
<parameter name="fechainicial" class="java.lang.String"/>
|
|
<parameter name="fechafinal" class="java.lang.String">
|
|
<parameterDescription><![CDATA[]]></parameterDescription>
|
|
</parameter>
|
|
<parameter name="filtro" class="java.lang.String"/>
|
|
<parameter name="titulo" class="java.lang.String"/>
|
|
<queryString language="SQL">
|
|
<![CDATA[select rownum,
|
|
ra.solicitudnum as solimportacion,
|
|
ra.fechasolicitud as fechatramite,
|
|
ra.fcreacion as fcreacion,
|
|
ra.tramite as numtramitependiente,
|
|
pd.identification as cedula,
|
|
pd.name as nombre,
|
|
(select c.description from tgenecountry c where ra.paisorigen = c.countrycode) as paisorigen,
|
|
a.carma,
|
|
(select cdclase.description from tgenecatalogdetail cdclase where cdclase.catalog = tae.clase and cdclase.catalogcode = tae.clasecodigo) as clase,
|
|
(select cdtipo.description from tgenecatalogdetail cdtipo where cdtipo.catalog = tae.tipoarmaexplosivo and cdtipo.catalogcode = tae.tipoarmaexplosivocodigo) as tipo,
|
|
(select cdmarca.description from tgenecatalogdetail cdmarca where cdmarca.catalog = a.marca and cdmarca.catalogcode = a.marcacodigo) as marca,
|
|
(select cdcalibre.description from tgenecatalogdetail cdcalibre where cdcalibre.catalog = tae.calibre and cdcalibre.catalogcode = tae.calibrecodigo) as calibre,
|
|
a.lote as serie,
|
|
(select cdcolor.description from tgenecatalogdetail cdcolor where cdcolor.catalog = a.color and cdcolor.catalogcode = a.colorcodigo) as color,
|
|
a.peso as peso,
|
|
a.cantidad as cantidad,
|
|
(select cdcantmedida.description from tgenecatalogdetail cdcantmedida where cdcantmedida.catalog = tae.unidadmedidapeso and cdcantmedida.catalogcode = tae.unidadmedidapesocodigo) as cantmedida
|
|
from
|
|
(select arm2.* from tarmarmas arm2 where arm2.carma in(
|
|
select to_char(carma) from (
|
|
select MIN(TO_NUMBER(REPLACE(arm.carma,'SYS',''))) carma, arm.codigoarma
|
|
from tarmregistroarmas ra2
|
|
inner join tarmarmas arm on ra2.cregistro = arm.cregistro
|
|
where ra2.tiporegistro in ('IMP','PRO') and (arm.cantidad>0 or arm.peso>0)
|
|
group by arm.codigoarma))) a
|
|
left join tarmregistroarmas ra on ra.cregistro = a.cregistro
|
|
inner join tcustpersondetail pd on pd.personcode = ra.personcode and to_char(pd.dateto,'yyyy-MM-dd')='2999-12-31'
|
|
inner join tarmtipoarmaexplosivo tae on a.ctipoarmaexplosivo = tae.ctipoarmaexplosivo
|
|
where ra.fechasolicitud between to_date( $P{fechainicial} ,'dd/MM/yyyy') and to_date( $P{fechafinal} ,'dd/MM/yyyy')
|
|
$P!{filtro}]]>
|
|
</queryString>
|
|
<field name="rownum" class="java.lang.String"/>
|
|
<field name="solimportacion" class="java.lang.String"/>
|
|
<field name="fechatramite" class="java.lang.String"/>
|
|
<field name="numtramitependiente" class="java.lang.String"/>
|
|
<field name="cedula" class="java.lang.String"/>
|
|
<field name="nombre" class="java.lang.String"/>
|
|
<field name="paisorigen" class="java.lang.String"/>
|
|
<field name="clase" class="java.lang.String"/>
|
|
<field name="tipo" class="java.lang.String"/>
|
|
<field name="marca" class="java.lang.String"/>
|
|
<field name="calibre" class="java.lang.String"/>
|
|
<field name="serie" class="java.lang.String"/>
|
|
<field name="color" class="java.lang.String"/>
|
|
<field name="peso" class="java.lang.String"/>
|
|
<field name="cantidad" class="java.lang.String"/>
|
|
<field name="cantmedida" class="java.lang.String"/>
|
|
<background>
|
|
<band splitType="Stretch"/>
|
|
</background>
|
|
<title>
|
|
<band height="104" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<staticText>
|
|
<reportElement style="title1" x="280" y="0" width="580" 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="280" y="20" width="580" 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="170" y="0" width="110" 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="860" 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>
|
|
<textField>
|
|
<reportElement style="title2" x="280" y="40" width="580" height="15" uuid="ea5cd989-52eb-4392-9940-c68a2a603e7a">
|
|
<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="Center" verticalAlignment="Top"/>
|
|
<textFieldExpression><![CDATA[$P{centroControl}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement style="title2" x="170" y="80" width="780" height="24" uuid="e4232f8e-30f1-4024-92e4-9e55f09dea20">
|
|
<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{titulo}]]></textFieldExpression>
|
|
</textField>
|
|
<staticText>
|
|
<reportElement key="" style="title1" x="280" y="55" width="580" height="25" forecolor="#000000" uuid="49f68429-8b74-4f6f-bb2f-b588aeb62315"/>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[]]></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"/>
|
|
<staticText>
|
|
<reportElement style="title1" x="170" y="0" width="320" height="15" forecolor="#000000" uuid="56acc6fb-fa8e-4cad-9f8e-258e80aa2ac6">
|
|
<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="Right"/>
|
|
<text><![CDATA[Del:]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title1" x="590" y="0" width="90" height="15" forecolor="#000000" uuid="c5eb02a0-9486-4768-9377-8409bef67dfc">
|
|
<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="Left"/>
|
|
<text><![CDATA[Al:]]></text>
|
|
</staticText>
|
|
<textField>
|
|
<reportElement style="normal" x="490" y="0" width="100" height="15" uuid="109b8f09-9347-49e0-8aa6-c20fc6ae2695">
|
|
<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{fechainicial}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement style="normal" x="680" y="0" width="270" height="15" uuid="9deefd1a-47a4-4dde-aa9d-ce9292228564">
|
|
<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{fechafinal}]]></textFieldExpression>
|
|
</textField>
|
|
</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="title2" x="0" y="0" width="40" height="30" forecolor="#000000" uuid="a56649bd-1301-4722-93ab-4296227efea9">
|
|
<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[No.]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="170" y="0" width="110" 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[No. DOCUEMENTO]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="280" y="0" width="210" height="30" forecolor="#000000" uuid="fa752abe-ce12-4b29-bcec-c38c3f805fcd">
|
|
<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[NOMBRE / RAZÓN SOCIAL]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="490" y="0" width="100" height="30" forecolor="#000000" uuid="3e5f1362-12ec-4a33-8364-453be1d29a32">
|
|
<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[PAÍS ORIGEN]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="590" y="0" width="90" height="30" forecolor="#000000" uuid="568c65ee-758a-4290-ac21-1555c02a8188">
|
|
<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[CLASE]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="680" y="0" width="90" height="30" forecolor="#000000" uuid="cea32b1b-6f9d-441e-85e1-1d3104bd6a8d">
|
|
<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[TIPO]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="40" y="0" width="130" 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[No. SOLICITUD IMPORTACIÓN]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="770" y="0" width="90" height="30" forecolor="#000000" uuid="9b19de4e-1c87-4640-bd07-d00d7e0ffeb6">
|
|
<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[MARCA]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="950" y="0" width="90" height="30" forecolor="#000000" uuid="e06e3c81-3020-4e70-96ad-7040b9ba0f23">
|
|
<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[SERIE]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="860" y="0" width="90" height="30" forecolor="#000000" uuid="b1750c88-262a-4d7e-bb95-ef2e8c8e1807">
|
|
<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[CALIBRE]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="1040" y="0" width="90" height="30" forecolor="#000000" uuid="c97d7289-0faf-44e4-864b-edcc671bc2fd">
|
|
<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[COLOR]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="1130" y="0" width="60" height="30" forecolor="#000000" uuid="5f6fb17c-83e8-467e-bdcf-9348f96fa1ce">
|
|
<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[CANTIDAD]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="1251" y="0" width="69" height="30" forecolor="#000000" uuid="eb72816e-df95-4c91-8283-147ab57e21ef">
|
|
<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[UNIDAD MEDIDA]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="1190" y="0" width="61" height="30" forecolor="#000000" uuid="b88cb221-9bb2-4fd3-8bb2-ba1e6413e6b9">
|
|
<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[PESO]]></text>
|
|
</staticText>
|
|
</band>
|
|
</columnHeader>
|
|
<detail>
|
|
<band height="35" 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="0" y="0" width="40" height="35" uuid="4e16d257-6f0a-4fc0-9189-595b2ff0e6ab">
|
|
<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{rownum}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="40" y="0" width="130" height="35" uuid="5fa9232d-fa0e-4362-9362-46dc112f4ea6">
|
|
<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{solimportacion}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="170" y="0" width="110" height="35" uuid="04924646-09e2-4f38-830f-e5b714748dda">
|
|
<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{cedula}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="280" y="0" width="210" height="35" uuid="f491ab2b-698e-4690-b8cb-bbbc5d3e1fae">
|
|
<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{nombre}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="490" y="0" width="100" height="35" uuid="50b0ec46-f242-4a9f-b964-2d824bfb1b8d">
|
|
<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{paisorigen}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="590" y="0" width="90" height="35" uuid="1ee42281-a4f9-440e-8175-249add5da989">
|
|
<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{clase}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="680" y="0" width="90" height="35" uuid="82dc1bb0-476a-462a-ac19-397d9ab31f07">
|
|
<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{tipo}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="770" y="0" width="90" height="35" uuid="93ba3d0a-8347-4f5e-93d9-d7845c63bbc6">
|
|
<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{marca}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="860" y="0" width="90" height="35" uuid="6bdb54df-93e3-4574-920b-fa106a96644d">
|
|
<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{calibre}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="950" y="0" width="90" height="35" uuid="bdceccdc-c3fd-4b68-9df2-40f8d6c8d234">
|
|
<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{serie}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="1040" y="0" width="90" height="35" uuid="b119d732-37ec-4b2e-a267-fb27238f669e">
|
|
<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{color}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="1130" y="0" width="60" height="35" uuid="2ec3d1e6-2dc2-477e-a220-5d0ee131bfec">
|
|
<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{cantidad}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="1251" y="0" width="69" height="35" uuid="3548fe47-65ce-4aaa-8424-94909992953d">
|
|
<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{cantmedida}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" x="1190" y="0" width="61" height="35" uuid="0da73ad8-9ad1-4fd7-b161-44debbcd0a1b">
|
|
<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{peso}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</detail>
|
|
<pageFooter>
|
|
<band height="43">
|
|
<staticText>
|
|
<reportElement style="title1" x="170" y="0" width="110" 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="590" y="0" width="180" 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="280" y="0" width="310" 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="770" y="0" width="270" 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>
|