385 lines
18 KiB
XML
Executable File
385 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-12T11:27:46 -->
|
|
<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="761" pageHeight="802" columnWidth="761" 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"/>
|
|
<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="idCentroControl" class="java.lang.String"/>
|
|
<parameter name="fechaFin" class="java.lang.String"/>
|
|
<queryString language="SQL">
|
|
<![CDATA[select ROW_NUMBER() OVER (order by arm.codigoarma) 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, $P{fechaFin} as fecha
|
|
from -- tagarmas que no estan en bodega
|
|
((select distinct tagarma.carma, tagarma.ctag from tarmtagarma tagarma
|
|
inner join tarmlecturadetalle lecdet on tagarma.ctag = lecdet.codigotag
|
|
inner join tarmlectura lec on lecdet.clectura = lec.clectura and lec.tipolectura = 'PTL'
|
|
inner join tarmcencontroljur cenconjur on lec.provincecode = cenconjur.provincecode
|
|
inner join tarmcentrocontrol cencon on cenconjur.ccentrocontrol = cencon.ccentrocontrol
|
|
where cencon.ccentrocontrol = $P{idCentroControl})
|
|
minus
|
|
(select distinct tagarma.carma, tagarma.ctag from tarmtagarma tagarma
|
|
inner join tarmlecturadetalle lecdet on tagarma.ctag = lecdet.codigotag
|
|
inner join tarmlectura lec on lecdet.clectura = lec.clectura and lec.tipolectura = 'HHD' and to_char(lec.fecha,'dd-MM-yyyy') = $P{fechaFin}
|
|
inner join tarmcencontroljur cenconjur on lec.provincecode = cenconjur.provincecode
|
|
inner join tarmcentrocontrol cencon on cenconjur.ccentrocontrol = cencon.ccentrocontrol
|
|
where cencon.ccentrocontrol = $P{idCentroControl})) tagarm
|
|
inner join tarmarmas arm on arm.carma = tagarm.carma
|
|
inner join tarmtipoarmaexplosivo tiparmexp on arm.ctipoarmaexplosivo = tiparmexp.ctipoarmaexplosivo]]>
|
|
</queryString>
|
|
<field name="NUMROW" class="java.lang.Integer"/>
|
|
<field name="CODIGOARMA" 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="MODELO" class="java.lang.String"/>
|
|
<field name="COLOR" class="java.lang.String"/>
|
|
<field name="SERIELOTE" class="java.lang.String"/>
|
|
<field name="FECHA" class="java.lang.String"/>
|
|
<background>
|
|
<band splitType="Stretch"/>
|
|
</background>
|
|
<title>
|
|
<band height="16" splitType="Stretch">
|
|
<staticText>
|
|
<reportElement style="title2" x="0" y="0" width="350" height="16" forecolor="#000000" uuid="8305a6db-e590-43c8-82ac-1701e8b1cc4c"/>
|
|
<textElement textAlignment="Left"/>
|
|
<text><![CDATA[Faltante en Bodega]]></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"/>
|
|
<text><![CDATA[No.]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="28" y="0" width="65" 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"/>
|
|
<text><![CDATA[Código]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="93" y="0" width="87" 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"/>
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
</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="180" y="0" width="87" 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"/>
|
|
<property name="local_mesure_unitwidth" value="pixel"/>
|
|
</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="267" y="0" width="83" 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"/>
|
|
<text><![CDATA[Marca]]></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"/>
|
|
<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"/>
|
|
<text><![CDATA[Modelo]]></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"/>
|
|
<text><![CDATA[Color]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="550" y="0" width="70" 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"/>
|
|
<text><![CDATA[Serie]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="620" y="0" width="65" 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"/>
|
|
<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[Fecha Lectura]]></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" stretchType="RelativeToTallestObject" 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"/>
|
|
<textFieldExpression><![CDATA[$F{NUMROW}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="normal1" stretchType="RelativeToTallestObject" x="180" y="0" width="87" height="13" uuid="cceba368-9ccf-490b-b9f5-e0f4e33b5088">
|
|
<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"/>
|
|
<textFieldExpression><![CDATA[$F{TIPO}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="normal1" stretchType="RelativeToTallestObject" x="267" y="0" width="83" 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"/>
|
|
<textFieldExpression><![CDATA[$F{MARCA}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="normal1" 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"/>
|
|
<textFieldExpression><![CDATA[$F{MODELO}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="normal1" 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"/>
|
|
<textFieldExpression><![CDATA[$F{COLOR}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="normal1" stretchType="RelativeToTallestObject" x="28" y="0" width="65" height="13" uuid="135bdc4e-e62e-4fed-9d9d-4b12259e82ad">
|
|
<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" verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$F{CODIGOARMA}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="normal1" 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"/>
|
|
<textFieldExpression><![CDATA[$F{CALIBRE}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="normal1" stretchType="RelativeToTallestObject" x="93" y="0" width="87" height="13" uuid="06b8e8f8-7e62-4d7f-baef-5ab73e386d95">
|
|
<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"/>
|
|
<textFieldExpression><![CDATA[$F{CLASE}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="normal1" stretchType="RelativeToTallestObject" x="550" y="0" width="70" height="13" uuid="081dde86-d202-478f-8a88-4c747aebad79">
|
|
<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"/>
|
|
<textFieldExpression><![CDATA[$F{SERIELOTE}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="normal1" stretchType="RelativeToTallestObject" x="620" y="0" width="65" height="13" uuid="7de21bb3-e6e3-49f0-9773-738d532c48b9">
|
|
<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"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center"/>
|
|
<textFieldExpression><![CDATA[$F{FECHA}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</detail>
|
|
<columnFooter>
|
|
<band splitType="Stretch"/>
|
|
</columnFooter>
|
|
<pageFooter>
|
|
<band splitType="Stretch"/>
|
|
</pageFooter>
|
|
<summary>
|
|
<band splitType="Stretch"/>
|
|
</summary>
|
|
</jasperReport>
|