maia_modificado/.svn/pristine/e1/e1dda00358b63c71168daa04673...

476 lines
21 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-10-30T08:55:54 -->
<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="informacionArmas" pageWidth="760" pageHeight="802" columnWidth="760" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="3190ca62-574f-4c0a-8783-decda02d61e1">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
<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="pathstyle" class="java.lang.String" isForPrompting="false">
<defaultValueExpression><![CDATA["repo:/maia/1/style/style"]]></defaultValueExpression>
</parameter>
<parameter name="csolicitud" class="java.lang.String"/>
<queryString language="SQL">
<![CDATA[select rownum,
nvl(clase.description,' ') as clase,
nvl(tipo.description,' ') as tipo,
nvl(marca.description,' ') as marca,
nvl(arma.modelo,' ') as modelo,
nvl( calibre.description,' ') as calibre,
nvl(arma.lote,' ') as serie,
(select color.description from tgenecatalogdetail color where color.catalog = arma.color and color.catalogcode = 'COLOR') as color,
arma.cantidad as cantidad,
arma.peso as peso,
unidadmed.description as medida,
nvl( armaestado.description,' ') as estadoarma
from tarmarmas arma
left join tarmtipoarmaexplosivo tae on arma.ctipoarmaexplosivo=tae.ctipoarmaexplosivo
left JOIN tgenecatalogdetail clase on clase.catalog=tae.clase and clase.catalogcode=tae.clasecodigo
left JOIN tgenecatalogdetail tipo on tipo.catalog=tae.tipoarmaexplosivo and tipo.catalogcode=tae.tipoarmaexplosivocodigo
left JOIN tgenecatalogdetail marca on marca.catalog=arma.marca and marca.catalogcode=arma.marcacodigo
left JOIN tgenecatalogdetail calibre on calibre.catalog=tae.calibre and calibre.catalogcode=tae.calibrecodigo
left JOIN tgenecatalogdetail armaestado on armaestado.catalog=arma.estado and armaestado.catalogcode=arma.estadocodigo
left JOIN tgenecatalogdetail unidadmed on unidadmed.catalog=arma.unidadmedidacantidad and unidadmed.catalogcode=arma.unidadmedidacantidadcodigo
inner join tarmsolicitudarmas on tarmsolicitudarmas.carma=arma.carma
inner join tcustperson persona on persona.personcode = tarmsolicitudarmas.personcode
where tarmsolicitudarmas.csolicitud=$P{csolicitud}]]>
</queryString>
<field name="ROWNUM" class="java.lang.Integer"/>
<field name="CLASE" class="java.lang.String"/>
<field name="TIPO" class="java.lang.String"/>
<field name="MARCA" class="java.lang.String"/>
<field name="MODELO" 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="ESTADOARMA" class="java.lang.String"/>
<field name="CANTIDAD" class="java.lang.String"/>
<field name="PESO" class="java.lang.String"/>
<field name="MEDIDA" class="java.lang.String"/>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="22" splitType="Stretch">
<staticText>
<reportElement style="title2" x="0" y="0" width="190" height="16" forecolor="#000000" uuid="8305a6db-e590-43c8-82ac-1701e8b1cc4c"/>
<textElement textAlignment="Left"/>
<text><![CDATA[INFORMACIÓN ARMAS:]]></text>
</staticText>
</band>
</title>
<pageHeader>
<band splitType="Stretch"/>
</pageHeader>
<columnHeader>
<band height="29" 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="28" height="29" forecolor="#000000" uuid="540d576f-04cc-428c-a1bd-46f7c0ced8ea">
<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">
<font size="9"/>
</textElement>
<text><![CDATA[No.]]></text>
</staticText>
<staticText>
<reportElement style="title2" x="28" y="0" width="102" height="29" forecolor="#000000" uuid="f2f93829-0f37-490c-ba38-a8823c75e410">
<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">
<font size="9"/>
</textElement>
<text><![CDATA[Clase]]></text>
</staticText>
<staticText>
<reportElement style="title2" x="130" y="0" width="72" height="29" forecolor="#000000" uuid="fb8d3c6f-ac47-4315-8b00-0fc301940d2f">
<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">
<font size="9"/>
</textElement>
<text><![CDATA[Tipo]]></text>
</staticText>
<staticText>
<reportElement style="title2" x="202" y="0" width="70" height="29" forecolor="#000000" uuid="d40787d0-562a-43d8-ac9d-6bca1efb594d">
<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">
<font size="9"/>
</textElement>
<text><![CDATA[Marca]]></text>
</staticText>
<staticText>
<reportElement style="title2" x="272" y="0" width="78" height="29" forecolor="#000000" uuid="c7c1edba-79ce-4afb-a09b-dc12174e6fe1">
<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">
<font size="9"/>
</textElement>
<text><![CDATA[Modelo]]></text>
</staticText>
<staticText>
<reportElement style="title2" x="350" y="0" width="50" height="29" forecolor="#000000" uuid="b481ae02-f1e8-4e6b-97f0-47ef316aeb93">
<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">
<font size="9"/>
</textElement>
<text><![CDATA[Calibre]]></text>
</staticText>
<staticText>
<reportElement style="title2" x="400" y="0" width="70" height="29" forecolor="#000000" uuid="b08fd9f0-0543-4dd9-986f-0dd5da6945d1">
<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">
<font size="9"/>
</textElement>
<text><![CDATA[Serie]]></text>
</staticText>
<staticText>
<reportElement style="title2" x="470" y="0" width="80" height="29" forecolor="#000000" uuid="ddc86fa8-7285-43cb-bee5-738affc6aba8">
<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">
<font size="9"/>
</textElement>
<text><![CDATA[Color]]></text>
</staticText>
<staticText>
<reportElement style="title2" x="700" y="0" width="60" height="29" forecolor="#000000" uuid="5a74d467-69f8-4c51-a929-5a6f8a83530e">
<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">
<font size="9"/>
</textElement>
<text><![CDATA[Estado]]></text>
</staticText>
<staticText>
<reportElement style="title2" x="550" y="0" width="50" height="29" forecolor="#000000" uuid="1564293b-bddf-4769-bbba-71b8129aec3d">
<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">
<font size="9"/>
</textElement>
<text><![CDATA[Peso]]></text>
</staticText>
<staticText>
<reportElement style="title2" x="600" y="0" width="50" height="29" forecolor="#000000" uuid="e96881e3-71b1-4f76-94b8-4ad95fcd0c6a">
<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">
<font size="9"/>
</textElement>
<text><![CDATA[Cantidad]]></text>
</staticText>
<staticText>
<reportElement style="title2" x="650" y="0" width="50" height="29" forecolor="#000000" uuid="d8c67de0-3ecb-4958-adf1-4715e6fbe3d6">
<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">
<font size="9"/>
</textElement>
<text><![CDATA[Medida]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="13" splitType="Stretch">
<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/>
<property name="local_mesure_unitheight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement style="normal1" positionType="Float" stretchType="RelativeToBandHeight" x="0" y="0" width="28" height="13" uuid="b9ed3cee-3b49-4d05-ae04-b749a8a4817c"/>
<box>
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{ROWNUM}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement style="normal1" positionType="Float" stretchType="RelativeToTallestObject" x="202" y="0" width="70" height="13" uuid="cceba368-9ccf-490b-b9f5-e0f4e33b5088"/>
<box>
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{MARCA}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement style="normal1" positionType="Float" stretchType="RelativeToTallestObject" x="272" y="0" width="78" height="13" uuid="f93ae444-d2fb-4318-bcd8-25e7ff34ad47"/>
<box>
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{MODELO}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement style="normal1" positionType="Float" stretchType="RelativeToTallestObject" x="400" y="0" width="70" height="13" uuid="1cb4c740-ac8d-4e68-817e-744adfd3438e"/>
<box>
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{SERIE}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement style="normal1" positionType="Float" stretchType="RelativeToTallestObject" x="470" y="0" width="80" height="13" uuid="5da6cfe9-81f6-44e7-9f74-0822b9722fca"/>
<box>
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{COLOR}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement style="normal1" positionType="Float" stretchType="RelativeToTallestObject" x="700" y="0" width="60" height="13" uuid="e8ae8591-73a4-414a-bee2-a81b3fc6a1ea"/>
<box>
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{ESTADOARMA}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement style="normal1" positionType="Float" stretchType="RelativeToTallestObject" x="28" y="0" width="102" height="13" uuid="135bdc4e-e62e-4fed-9d9d-4b12259e82ad"/>
<box>
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{CLASE}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement style="normal1" positionType="Float" stretchType="RelativeToTallestObject" x="350" y="0" width="50" height="13" uuid="ba1683af-74b0-4037-8fdb-bc6b87e69235"/>
<box>
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{CALIBRE}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement style="normal1" positionType="Float" stretchType="RelativeToTallestObject" x="130" y="0" width="72" height="13" uuid="06b8e8f8-7e62-4d7f-baef-5ab73e386d95"/>
<box>
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{TIPO}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement style="normal1" positionType="Float" stretchType="RelativeToTallestObject" x="550" y="0" width="50" height="13" uuid="081dde86-d202-478f-8a88-4c747aebad79"/>
<box>
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{PESO}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement style="normal1" positionType="Float" stretchType="RelativeToTallestObject" x="600" y="0" width="50" height="13" uuid="5e4c5249-830a-4f3d-9530-c95d61900a0c"/>
<box>
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{CANTIDAD}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement style="normal1" positionType="Float" stretchType="RelativeToTallestObject" x="650" y="0" width="50" height="13" uuid="7de21bb3-e6e3-49f0-9773-738d532c48b9">
<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">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{MEDIDA}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band splitType="Stretch"/>
</columnFooter>
<pageFooter>
<band splitType="Stretch"/>
</pageFooter>
<summary>
<band splitType="Stretch"/>
</summary>
</jasperReport>