192 lines
8.3 KiB
XML
Executable File
192 lines
8.3 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-12-03T16:39:45 -->
|
|
<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="informacionGuardias" pageWidth="555" pageHeight="802" 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,
|
|
personadetalleguardia.identification as cedula,
|
|
personadetalleguardia.name as guardia,
|
|
case
|
|
when g.estado = 'APT' then 'APTO'
|
|
end as estado
|
|
from tarmsolicitud solicitud
|
|
inner join tarmsolicitudguardias solguardia on solguardia.csolicitud = solicitud.csolicitud
|
|
--DATOS DE LA PERSONA
|
|
inner join tcustperson persona on persona.personcode = solicitud.personcode
|
|
--EMPRESA
|
|
inner join tcustpersondetail personadetalleempresa
|
|
on personadetalleempresa.personcode = solguardia.cempresa
|
|
and personadetalleempresa.dateto = TO_DATE (TO_CHAR (personadetalleempresa.dateto, 'YYYY-MON-DD HH24:MI:SS'),'YYYY-MON-DD HH24:MI:SS')
|
|
--GUARDIA
|
|
inner join tcustpersondetail personadetalleguardia
|
|
on personadetalleguardia.personcode = solguardia.cguardia
|
|
and personadetalleguardia.dateto = TO_DATE (TO_CHAR (personadetalleguardia.dateto, 'YYYY-MON-DD HH24:MI:SS'),'YYYY-MON-DD HH24:MI:SS')
|
|
inner join tarmguardias g
|
|
on g.cguardia = solguardia.cguardia
|
|
and g.cempresa = solguardia.cempresa
|
|
where solicitud.csolicitud=$P{csolicitud}]]>
|
|
</queryString>
|
|
<field name="ROWNUM" class="java.lang.Integer"/>
|
|
<field name="CEDULA" class="java.lang.String"/>
|
|
<field name="GUARDIA" class="java.lang.String"/>
|
|
<field name="ESTADO" class="java.lang.String">
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<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 GUARDIAS:]]></text>
|
|
</staticText>
|
|
</band>
|
|
</title>
|
|
<pageHeader>
|
|
<band splitType="Stretch"/>
|
|
</pageHeader>
|
|
<columnHeader>
|
|
<band height="29" splitType="Stretch">
|
|
<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="112" 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ÉDULA]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="140" y="0" width="170" 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"/>
|
|
<text><![CDATA[APELLIDOS Y NOMBRES]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="310" y="0" width="64" 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[ESTADO]]></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="normal" stretchType="RelativeToTallestObject" x="0" y="0" width="28" height="13" forecolor="#000000" uuid="adab45b4-a9c5-4963-8fb1-9ad5677204c2">
|
|
<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 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 style="normal" x="28" y="0" width="112" height="13" uuid="677c96b3-6bfd-4eb2-ad31-a287dcb48e06"/>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textFieldExpression><![CDATA[$F{CEDULA}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement style="normal" x="140" y="0" width="170" height="13" uuid="606b2ac4-0ea9-4bd4-b0a9-121d2aab6de7"/>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textFieldExpression><![CDATA[$F{GUARDIA}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement style="normal" x="310" y="0" width="64" height="13" uuid="ab58df8a-ae83-4e47-986c-d9b49db2402c"/>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textFieldExpression><![CDATA[$F{ESTADO}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</detail>
|
|
<columnFooter>
|
|
<band splitType="Stretch"/>
|
|
</columnFooter>
|
|
<pageFooter>
|
|
<band splitType="Stretch"/>
|
|
</pageFooter>
|
|
<summary>
|
|
<band splitType="Stretch"/>
|
|
</summary>
|
|
</jasperReport>
|