226 lines
13 KiB
XML
Executable File
226 lines
13 KiB
XML
Executable File
<?xml version="1.0" encoding="UTF-8"?>
|
|
<!-- Created with Jaspersoft Studio version 5.6.2.final using JasperReports Library version 5.6.1 -->
|
|
<!-- 2014-10-23T15:04:44 -->
|
|
<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="registroBalisticoSub" pageWidth="990" pageHeight="842" columnWidth="990" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="4c0de88e-7996-499b-91c7-a056f03c9933">
|
|
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
|
|
<parameter name="personCode" class="java.lang.String"/>
|
|
<queryString language="SQL">
|
|
<![CDATA[select rownum,
|
|
(select s.fregistro from tarmsolicitud s where s.csolicitud = sa.csolicitud) as FEC_SOLICITUD,
|
|
(select st.numerotramite from tarmsolicitudtramite st,tarmtramite t,tarmsolicitud s where s.csolicitud = st.csolicitud and t.ctramite = st.ctramite and sa.csolicitud = s.csolicitud ) as NUM_TRAM,
|
|
(select cd.description from tgenecatalogdetail cd ,tarmsolicitudtramite st,tarmtramite t,tarmsolicitud s where cd.catalog = t.tipoautorizacion and cd.catalogcode = t.tipoautorizacioncodigo and s.csolicitud = st.csolicitud and t.ctramite = st.ctramite and sa.csolicitud = s.csolicitud)as TIPO_TRAM,
|
|
(select cd.description from tgenecatalogdetail cd ,tarmsolicitudtramite st,tarmtramite t,tarmsolicitud s where cd.catalog = t.tipotramite and cd.catalogcode = t.tipotramitecodigo and s.csolicitud = st.csolicitud and t.ctramite = st.ctramite and sa.csolicitud = s.csolicitud)as TRAMITE,
|
|
(select cd.description from tgenecatalogdetail cd,tarmsolicitudtramite st,tarmtramite t,tarmsolicitud s where ap.csolicitud = sa.csolicitud and s.csolicitud = st.csolicitud and t.ctramite = st.ctramite and sa.csolicitud = s.csolicitud and cd.catalog = st.estadotramite and cd.catalogcode = st.estadotramitecodigo)as ESTADO_TRAM,
|
|
(select cd.description from tgenecatalogdetail cd, tarmsolicitudtramite st,tarmtramite t,tarmsolicitud s where ap.csolicitud = sa.csolicitud and s.csolicitud = st.csolicitud and t.ctramite = st.ctramite and sa.csolicitud = s.csolicitud and cd.catalog = t.usoactividad and cd.catalogcode = t.usoactividadcodigo)as USO_ACT,
|
|
(select pd.identification from tcustpersondetail pd where pd.personcode = ap.personcode)as CEDULA,
|
|
(select cd.description from tgenecatalogdetail cd, tcustpersondetail pd where pd.personcode = ap.personcode and cd.catalog = pd.identificationcatalog and cd.catalogcode = pd.identificationcatalogcode)as TIPO_CEDULA,
|
|
(select pd.name from tcustpersondetail pd where pd.personcode = ap.personcode)as NOMBRE,
|
|
(select distinct gp.description from tgeneprovince gp,tcustpersonaddress pa,tcustpersondetail pd where pa.personcode = pd.personcode and pa.personcode = ap.personcode and pa.provincecode = gp.provincecode)as PROVINCIA,
|
|
(select distinct gc.description from tgeneprovince gp2,tgenecanton gc,tcustpersonaddress pa,tcustpersondetail pd where pa.personcode = pd.personcode and pa.personcode = ap.personcode and pa.cantoncode = gc.cantoncode and gc.provincecode = gp2.provincecode and pa.provincecode = gp2.provincecode)as CANTON,
|
|
(select distinct c.description from tgenecity c,tgeneprovince gp3,tgenecanton gc,tcustpersonaddress pa,tcustpersondetail pd where pa.personcode = pd.personcode and pa.personcode = ap.personcode and pa.cantoncode = gc.cantoncode and gc.provincecode = gp3.provincecode and pa.provincecode = gp3.provincecode and c.cantoncode = gc.cantoncode and c.provincecode = gp3.provincecode)AS CITY,
|
|
(select distinct pa.address from tcustpersonaddress pa,TarmArmaPruebas ap where ap.personcode = pa.personcode and pa.ADDRESSTYPECATALOG = '2')as DIRECCION,
|
|
aa.carma as CODIGO_ARMA,
|
|
(select cd.description from tarmtipoarmaexplosivo ax,tgenecatalogdetail cd where ax.ctipoarmaexplosivo = aa.ctipoarmaexplosivo and cd.catalog = ax.clase and cd.catalogcode = ax.clasecodigo)AS CLASE_ARMA,
|
|
(select cd.description from tarmtipoarmaexplosivo ax,tgenecatalogdetail cd where ax.ctipoarmaexplosivo = aa.ctipoarmaexplosivo and cd.catalog = ax.tipoarmaexplosivo and cd.catalogcode = ax.tipoarmaexplosivocodigo)as TIPO_ARMA,
|
|
aa.seriecanon as SERIE,
|
|
(select gc.description from tgenecountry gc where gc.countrycode = aa.cpaisorigen)as PAIS_ARMA,
|
|
(select cd.description from tarmtipoarmaexplosivo ax, tgenecatalogdetail cd where ax.ctipoarmaexplosivo = aa.ctipoarmaexplosivo and cd.catalog = ax.calibre and cd.catalogcode = ax.calibrecodigo)as CALIBRE,
|
|
(select cd.description from tarmtipoarmaexplosivo ax, tgenecatalogdetail cd where ax.ctipoarmaexplosivo = aa.ctipoarmaexplosivo and cd.catalog = ax.longitud and cd.catalogcode = ax.longitudcodigo)as LONGITUD,
|
|
(select cd.description from tgenecatalogdetail cd where aa.marca = cd.catalog and aa.marcacodigo = cd.catalogcode)as MARCA_ARMA,
|
|
(select cd.description from tgenecatalogdetail cd where aa.estado = cd.catalog and aa.estadocodigo = cd.catalogcode)as ESTADO_ARMA,
|
|
(select cd.description from tgenecatalogdetail cd ,tarmsolicitudtramite st,tarmtramite t,tarmsolicitud s where cd.catalog = t.categoria and cd.catalogcode = t.categoriacodigo and s.csolicitud = st.csolicitud and t.ctramite = st.ctramite and sa.csolicitud = s.csolicitud)as CAT_PERSON,
|
|
aa.modelo as MODELO_ARMA,
|
|
aa.color as COLOR_ARMA,
|
|
aa.lote as LOTE,
|
|
aa.fecharegistro as FEC_REG_ARM,
|
|
ap.observacion as OBSERVACION,
|
|
ap.aptituddisparo as APTITUD,
|
|
ap.balastestigo as TESTIGO,
|
|
ap.vainastestigo AS VAINAS,
|
|
ap.apruebaevaluacion AS APRUEBA_EVAL
|
|
from TarmArmaPruebas ap, tarmsolicitudarmas sa, tarmarmas aa
|
|
where ap.csolicitud = sa.csolicitud
|
|
and sa.carma = ap.carma
|
|
and sa.personcode = ap.personcode
|
|
and aa.carma = sa.carma
|
|
and ap.personcode = $P{personCode}]]>
|
|
</queryString>
|
|
<field name="rownum" class="java.lang.String"/>
|
|
<field name="CLASE_ARMA" class="java.lang.String">
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<field name="LONGITUD" class="java.lang.String">
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<field name="TIPO_ARMA" class="java.lang.String">
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<field name="CALIBRE" class="java.lang.String">
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<field name="LOTE" class="java.lang.String">
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<field name="COLOR_ARMA" class="java.lang.String">
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<field name="ESTADO_ARMA" class="java.lang.String">
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<field name="CEDULA" class="java.lang.String">
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<field name="NOMBRE" class="java.lang.String">
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<field name="FEC_REG_ARM" class="java.util.Date">
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<background>
|
|
<band splitType="Stretch"/>
|
|
</background>
|
|
<detail>
|
|
<band height="13" splitType="Stretch">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<textField>
|
|
<reportElement key="" style="normal" x="0" y="0" width="30" height="13" uuid="c867e83d-f68e-4595-ab60-cd39d3d9650c">
|
|
<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="Right"/>
|
|
<textFieldExpression><![CDATA[$F{rownum}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement key="" style="normal" x="30" y="0" width="100" height="13" uuid="ea717dc8-d2a1-4b71-9f80-3b02fd338725"/>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textFieldExpression><![CDATA[$F{CLASE_ARMA}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement key="" style="normal" x="130" y="0" width="100" height="13" uuid="c6dc2c57-d64e-475c-ac38-0f58137e4a2f"/>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textFieldExpression><![CDATA[$F{LONGITUD}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement key="" style="normal" x="230" y="0" width="100" height="13" uuid="1d67fc98-3eaa-4d60-a814-e6d9ad34f82f"/>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textFieldExpression><![CDATA[$F{TIPO_ARMA}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement key="" style="normal" x="330" y="0" width="70" height="13" uuid="2e8fbd28-b74f-4ef0-a36b-959d730ad722">
|
|
<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>
|
|
<textFieldExpression><![CDATA[$F{CALIBRE}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement key="" style="normal" x="400" y="0" width="100" height="13" uuid="d28ee3a5-e653-4011-a08f-9301be03dae5"/>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center"/>
|
|
<textFieldExpression><![CDATA[$F{LOTE}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement key="" style="normal" x="500" y="0" width="50" height="13" uuid="444fd349-90b5-4e4e-9254-86177acfb92c">
|
|
<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>
|
|
<textFieldExpression><![CDATA[$F{COLOR_ARMA}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement key="" style="normal" x="550" y="0" width="90" height="13" uuid="b8b1236a-65af-4345-948f-47c96428d000">
|
|
<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>
|
|
<textFieldExpression><![CDATA[$F{ESTADO_ARMA}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement key="" style="normal" x="640" y="0" width="110" height="13" uuid="0a0728a4-dd1a-4a12-ba8d-88190d305238">
|
|
<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="Right"/>
|
|
<textFieldExpression><![CDATA[$F{CEDULA}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement key="" style="normal" x="750" y="0" width="130" height="13" uuid="92624a71-88aa-4435-a291-79c3baef9971">
|
|
<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>
|
|
<textFieldExpression><![CDATA[$F{NOMBRE}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement key="" style="normal" x="880" y="0" width="110" height="13" uuid="3351ee30-7db9-45c1-8f92-15f7d6101a4f">
|
|
<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[new SimpleDateFormat("dd-MM-yyyy").format($F{FEC_REG_ARM})]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</detail>
|
|
</jasperReport>
|