291 lines
12 KiB
XML
Executable File
291 lines
12 KiB
XML
Executable File
<?xml version="1.0" encoding="UTF-8"?>
|
|
<!-- Created with Jaspersoft Studio version 6.0.0.final using JasperReports Library version 6.0.0 -->
|
|
<!-- 2017-03-20T16:42:12 -->
|
|
<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="informacionAgenciasSucursales" pageWidth="555" pageHeight="810" columnWidth="555" 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"/>
|
|
<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,
|
|
tipo.description as tipoagencia,
|
|
sucursales.nombre as nombreagencia,
|
|
provincia.description as provinciaagencia,
|
|
canton.description as cantonagencia,
|
|
ciudad.description as ciudadagencia,
|
|
sucursales.responsable as responsable
|
|
|
|
from tarmsolicitud solicitud
|
|
inner join tarmtramite tramite
|
|
on tramite.ctramite = solicitud.ctramite
|
|
left join tgenecatalogdetail tipotramite
|
|
on tipotramite.catalog=tramite.tipotramite
|
|
and tipotramite.catalogcode=tramite.tipotramitecodigo
|
|
left join tgenecatalogdetail categoria
|
|
on categoria.catalog=tramite.categoria
|
|
and categoria.catalogcode=tramite.categoriacodigo
|
|
inner join tarmagenciasucursal sucursales
|
|
on sucursales.personcode = solicitud.personcode
|
|
inner join tarmsolicitudagenciasucursal solsucursales
|
|
on solsucursales.csolicitud = solicitud.csolicitud
|
|
and solsucursales.cagencia = sucursales.cagencia
|
|
left join tgenecatalogdetail tipo
|
|
on tipo.catalog=sucursales.tipo
|
|
and tipo.catalogcode=sucursales.tipocodigo
|
|
left join tgenecountry pais
|
|
on pais.countrycode = sucursales.countrycode
|
|
left join tgeneprovince provincia
|
|
on provincia.provincecode = sucursales.provincecode
|
|
and provincia.countrycode = sucursales.countrycode
|
|
left join tgenecanton canton
|
|
on canton.cantoncode = sucursales.cantoncode
|
|
and canton.provincecode = sucursales.provincecode
|
|
and canton.countrycode = sucursales.countrycode
|
|
left join tgeneparroquia parroquia
|
|
on parroquia.parroquiacode = sucursales.parroquiacode
|
|
and parroquia.cantoncode = sucursales.cantoncode
|
|
and parroquia.provincecode = sucursales.provincecode
|
|
and parroquia.countrycode = sucursales.countrycode
|
|
left join tgenecity ciudad
|
|
on ciudad.citycode = sucursales.citycode
|
|
and ciudad.cantoncode = sucursales.cantoncode
|
|
and ciudad.provincecode = sucursales.provincecode
|
|
and ciudad.countrycode = sucursales.countrycode
|
|
where solicitud.csolicitud= $P{csolicitud}]]>
|
|
</queryString>
|
|
<field name="ROWNUM" class="java.lang.Integer"/>
|
|
<field name="TIPOAGENCIA" class="java.lang.String"/>
|
|
<field name="NOMBREAGENCIA" class="java.lang.String"/>
|
|
<field name="PROVINCIAAGENCIA" class="java.lang.String"/>
|
|
<field name="CANTONAGENCIA" class="java.lang.String"/>
|
|
<field name="CIUDADAGENCIA" class="java.lang.String"/>
|
|
<field name="RESPONSABLE" class="java.lang.String"/>
|
|
<background>
|
|
<band splitType="Stretch"/>
|
|
</background>
|
|
<title>
|
|
<band height="22" splitType="Stretch">
|
|
<staticText>
|
|
<reportElement style="title2" x="0" y="0" width="400" height="16" forecolor="#000000" uuid="8305a6db-e590-43c8-82ac-1701e8b1cc4c"/>
|
|
<textElement textAlignment="Left"/>
|
|
<text><![CDATA[INFORMACIÓN DE AGENCIAS / SUCURSALES:]]></text>
|
|
</staticText>
|
|
</band>
|
|
</title>
|
|
<pageHeader>
|
|
<band splitType="Stretch"/>
|
|
</pageHeader>
|
|
<columnHeader>
|
|
<band height="29" splitType="Stretch">
|
|
<staticText>
|
|
<reportElement style="title2" x="1" y="0" width="28" height="29" forecolor="#000000" uuid="7c46dbc1-c1e1-4cc1-97f0-baebaa589395">
|
|
<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="29" y="0" width="64" height="29" forecolor="#000000" uuid="21baab56-6ab8-4a18-8ea5-74b64532c24c">
|
|
<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[TIPO]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="93" y="0" width="106" height="29" forecolor="#000000" uuid="e49be1b4-a86b-4cc2-8dde-9143e0674296">
|
|
<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]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="199" y="0" width="81" height="29" forecolor="#000000" uuid="921153a3-25ba-487f-90ce-e8c62ccc3994">
|
|
<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[PROVINCIA]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="280" y="0" width="80" height="29" forecolor="#000000" uuid="266243f2-ccd2-47e3-92c2-d691cda18545">
|
|
<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[CANTON]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="360" y="0" width="86" height="29" forecolor="#000000" uuid="f9ebf6bb-e9d0-4a65-b35e-4193319bacf1">
|
|
<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[CIUDAD]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="446" y="0" width="109" height="29" forecolor="#000000" uuid="bfe24b68-03db-4bd9-bb7e-eed0884efd73">
|
|
<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[RESPONSABLE]]></text>
|
|
</staticText>
|
|
</band>
|
|
</columnHeader>
|
|
<detail>
|
|
<band height="36" splitType="Stretch">
|
|
<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/>
|
|
<textField isStretchWithOverflow="true">
|
|
<reportElement style="normal" stretchType="RelativeToTallestObject" x="1" y="0" width="28" height="36" forecolor="#000000" uuid="7a491d80-7d1a-449d-828b-8a6c55cc212c">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
</reportElement>
|
|
<box leftPadding="2" rightPadding="2">
|
|
<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{ROWNUM}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement key="" style="title1" x="29" y="0" width="64" height="36" uuid="eea3b9ee-3242-4b87-aa38-4874f11b5222"/>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$F{TIPOAGENCIA}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true">
|
|
<reportElement style="normal" x="93" y="0" width="106" height="36" uuid="aca825de-2a75-4dc7-95c7-85a6069fd1c8"/>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textFieldExpression><![CDATA[$F{NOMBREAGENCIA}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="normal" x="199" y="0" width="81" height="36" uuid="6021c012-9f1e-4deb-ab86-9f105d4f370c"/>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textFieldExpression><![CDATA[$F{PROVINCIAAGENCIA}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="normal" x="280" y="0" width="80" height="36" uuid="c0c80cd4-0a78-4780-b426-fc9923163eab"/>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textFieldExpression><![CDATA[$F{CANTONAGENCIA}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement style="normal" x="360" y="0" width="86" height="36" uuid="3098999d-d502-46a9-9196-e652ea0c2b6d"/>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textFieldExpression><![CDATA[$F{CIUDADAGENCIA}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true">
|
|
<reportElement style="normal" x="446" y="0" width="109" height="36" uuid="5b1695de-075d-4c6a-a820-c630068ec455"/>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Left" verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$F{RESPONSABLE}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</detail>
|
|
<columnFooter>
|
|
<band splitType="Stretch"/>
|
|
</columnFooter>
|
|
<pageFooter>
|
|
<band splitType="Stretch"/>
|
|
</pageFooter>
|
|
<summary>
|
|
<band splitType="Stretch"/>
|
|
</summary>
|
|
</jasperReport>
|