220 lines
9.9 KiB
XML
Executable File
220 lines
9.9 KiB
XML
Executable File
<?xml version="1.0" encoding="UTF-8"?>
|
|
<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="user" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="2fca705c-116c-4056-861a-6929a0d1a813">
|
|
<property name="ireport.zoom" value="1.6105100000000008"/>
|
|
<property name="ireport.x" value="354"/>
|
|
<property name="ireport.y" value="0"/>
|
|
<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="workingdate" class="java.lang.String" isForPrompting="false">
|
|
<defaultValueExpression><![CDATA["2011-12-31"]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="pathimage" class="java.lang.String" isForPrompting="false">
|
|
<defaultValueExpression><![CDATA["repo:/maia/logos/1"]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="company" class="java.lang.Integer" isForPrompting="false">
|
|
<defaultValueExpression><![CDATA[1]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="dateto" class="java.sql.Timestamp" isForPrompting="false">
|
|
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
|
|
</parameter>
|
|
<queryString>
|
|
<![CDATA[select TSUD.USERCODE,
|
|
(select TCPD.NAME
|
|
from TCUSTPERSONDETAIL TCPD
|
|
where TCPD.PERSONCODE = TSUD.PERSONCODE
|
|
and TCPD.DATETO = TSUD.DATETO
|
|
and TCPD.COMPANYCODE = TSUD.COMPANYCODE) NAME,
|
|
(select DESCRIPTION
|
|
from TGENECATALOGDETAIL
|
|
where CATALOG = TSUD.USERSTATUSCATALOG
|
|
and CATALOGCODE = TSUD.USERSTATUSCATALOGCODE) STATUS,
|
|
(select min(DATEFROM)
|
|
from TSAFEUSERDETAIL
|
|
where USERCODE = TSUD.USERCODE
|
|
and PERSONCODE = TSUD.PERSONCODE
|
|
and USERSTATUSCATALOG = 'ENT'
|
|
and COMPANYCODE = TSUD.COMPANYCODE) FINGRESO,
|
|
TSUD.INGRESSUSER,
|
|
(select TCPD.NAME
|
|
from TCUSTPERSONDETAIL TCPD
|
|
where TCPD.PERSONCODE =
|
|
(select PERSONCODE
|
|
from TSAFEUSERDETAIL
|
|
WHERE USERCODE = TSUD.INGRESSUSER
|
|
and DATETO = TSUD.DATETO
|
|
and COMPANYCODE = TSUD.COMPANYCODE)
|
|
and TCPD.DATETO = TSUD.DATETO
|
|
and TCPD.COMPANYCODE = TSUD.COMPANYCODE) NUINGRESO,
|
|
(select min(DATEFROM)
|
|
from TSAFEUSERDETAIL
|
|
where USERCODE = TSUD.USERCODE
|
|
and PERSONCODE = TSUD.PERSONCODE
|
|
and USERSTATUSCATALOG = 'ACT'
|
|
and COMPANYCODE = TSUD.COMPANYCODE) FACTIVACION,
|
|
TSUD.ACTIVATEUSER,
|
|
(select TCPD.NAME
|
|
from TCUSTPERSONDETAIL TCPD
|
|
where TCPD.PERSONCODE =
|
|
(select PERSONCODE
|
|
from TSAFEUSERDETAIL
|
|
WHERE USERCODE = TSUD.ACTIVATEUSER
|
|
and DATETO = TSUD.DATETO
|
|
and COMPANYCODE = TSUD.COMPANYCODE)
|
|
and TCPD.DATETO = TSUD.DATETO
|
|
and TCPD.COMPANYCODE = TSUD.COMPANYCODE) NUACTIVACION,
|
|
TSUD.TERMINALCODE,
|
|
(select TST.IPADDRESS
|
|
from TSAFETERMINAL TST
|
|
where TST.TERMINALCODE = TSUD.TERMINALCODE
|
|
and TST.COMPANYCODE = TSUD.COMPANYCODE) IP
|
|
from TSAFEUSERDETAIL TSUD
|
|
WHERE TSUD.DATETO = to_timestamp('2999-12-31','yyyy-mm-dd')
|
|
and TSUD.COMPANYCODE = $P{company}
|
|
order by NAME,STATUS, TSUD.USERCODE]]>
|
|
</queryString>
|
|
<field name="USERCODE" class="java.lang.String"/>
|
|
<field name="NAME" class="java.lang.String"/>
|
|
<field name="STATUS" class="java.lang.String"/>
|
|
<field name="FINGRESO" class="oracle.sql.TIMESTAMP"/>
|
|
<field name="INGRESSUSER" class="java.lang.String"/>
|
|
<field name="NUINGRESO" class="java.lang.String"/>
|
|
<field name="FACTIVACION" class="oracle.sql.TIMESTAMP"/>
|
|
<field name="ACTIVATEUSER" class="java.lang.String"/>
|
|
<field name="NUACTIVACION" class="java.lang.String"/>
|
|
<field name="TERMINALCODE" class="java.lang.String"/>
|
|
<field name="IP" class="java.lang.String"/>
|
|
<background>
|
|
<band splitType="Stretch"/>
|
|
</background>
|
|
<title>
|
|
<band height="35" splitType="Stretch">
|
|
<image>
|
|
<reportElement uuid="2e3bd35b-d512-4a49-8b85-06e21bfda772" x="0" y="0" width="800" height="35"/>
|
|
<imageExpression><![CDATA[$P{pathimage}]]></imageExpression>
|
|
</image>
|
|
</band>
|
|
</title>
|
|
<pageHeader>
|
|
<band height="29" splitType="Stretch">
|
|
<staticText>
|
|
<reportElement uuid="b9f1791e-e716-44b1-accd-c22c19c19851" style="title" x="0" y="3" width="800" height="22"/>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="SansSerif" size="14" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[LISTADO DE USUARIOS]]></text>
|
|
</staticText>
|
|
</band>
|
|
</pageHeader>
|
|
<columnHeader>
|
|
<band height="13" splitType="Stretch">
|
|
<staticText>
|
|
<reportElement uuid="f17bd45c-d5ee-4ef1-bc18-234eb325f07a" style="headercolumn" x="0" y="0" width="95" height="13"/>
|
|
<textElement/>
|
|
<text><![CDATA[Usuario]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement uuid="9cd86115-ecac-4b06-8c01-80116e2fc25e" style="headercolumn" x="95" y="0" width="155" height="13"/>
|
|
<textElement/>
|
|
<text><![CDATA[Nombre Usuario]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement uuid="c61c2ac8-ff68-4b31-bfaa-4a279e6145fb" style="headercolumn" x="250" y="0" width="65" height="13"/>
|
|
<textElement/>
|
|
<text><![CDATA[Estado]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement uuid="545d5977-1339-46df-a1ef-dbcd951cd6c3" style="headercolumn" x="315" y="0" width="95" height="13"/>
|
|
<textElement/>
|
|
<text><![CDATA[Fecha ingreso]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement uuid="b70b2526-aafa-4afc-819d-3dc9dd8e973d" style="headercolumn" x="410" y="0" width="118" height="13"/>
|
|
<textElement/>
|
|
<text><![CDATA[Usuario Ingreso]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement uuid="3e9d8443-d11a-40a5-9952-0701ba48b33d" style="headercolumn" x="528" y="0" width="95" height="13"/>
|
|
<textElement/>
|
|
<text><![CDATA[Fecha activación]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement uuid="ca187bb6-339c-4879-a549-442343529a32" style="headercolumn" x="623" y="0" width="177" height="13"/>
|
|
<textElement/>
|
|
<text><![CDATA[Usuario activación]]></text>
|
|
</staticText>
|
|
</band>
|
|
</columnHeader>
|
|
<detail>
|
|
<band height="13" splitType="Stretch">
|
|
<textField>
|
|
<reportElement uuid="f04d8eb0-8bed-4454-b0c9-552f09dce702" style="detail" x="0" y="0" width="95" height="13"/>
|
|
<textElement/>
|
|
<textFieldExpression><![CDATA[$F{USERCODE}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement uuid="9cf2890c-97aa-44c2-98b6-44feea15d770" style="detail" x="95" y="0" width="155" height="13"/>
|
|
<textElement/>
|
|
<textFieldExpression><![CDATA[$F{NAME}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement uuid="3e1d0eca-01da-45c8-a6fc-ccecd73d9f35" style="detail" x="250" y="0" width="65" height="13"/>
|
|
<textElement/>
|
|
<textFieldExpression><![CDATA[$F{STATUS}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" pattern="yyyy-MM-dd HH:mm:ss" isBlankWhenNull="true">
|
|
<reportElement uuid="a7ff5824-6cd3-4675-a3c8-9dde31582421" style="detail" x="315" y="0" width="95" height="13"/>
|
|
<textElement textAlignment="Center"/>
|
|
<textFieldExpression><![CDATA[$F{FINGRESO}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement uuid="1a623388-37af-431a-b243-339e4afed5ce" style="detail" x="410" y="0" width="118" height="13"/>
|
|
<textElement/>
|
|
<textFieldExpression><![CDATA[($F{INGRESSUSER} == null) ? null : $F{INGRESSUSER}+" - "+$F{NUINGRESO}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" pattern="yyyy-MM-dd HH:mm:ss" isBlankWhenNull="true">
|
|
<reportElement uuid="64d56395-b386-48cb-a202-5b66aa16a745" style="detail" x="528" y="0" width="95" height="13"/>
|
|
<textElement textAlignment="Center"/>
|
|
<textFieldExpression><![CDATA[$F{FACTIVACION}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement uuid="77b7209a-a53f-4847-a294-c27ddc6bdafd" style="detail" x="623" y="0" width="177" height="13"/>
|
|
<textElement/>
|
|
<textFieldExpression><![CDATA[($F{ACTIVATEUSER} == null) ? null : $F{ACTIVATEUSER}+" - "+$F{NUACTIVACION}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</detail>
|
|
<columnFooter>
|
|
<band splitType="Stretch"/>
|
|
</columnFooter>
|
|
<pageFooter>
|
|
<band height="15" splitType="Stretch">
|
|
<textField pattern="">
|
|
<reportElement uuid="486f0e72-f72b-4326-9fe3-b95a7895455a" style="footerinfo" x="0" y="0" width="150" height="15"/>
|
|
<textElement>
|
|
<font size="10" isBold="false"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$P{workingdate}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement uuid="204ba90b-0617-43ca-abd4-c15ccc40380c" style="footerinfo" x="429" y="0" width="329" height="15"/>
|
|
<textElement textAlignment="Right">
|
|
<font fontName="SansSerif" size="10" isBold="false"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA["Página "+$V{PAGE_NUMBER}+" de "]]></textFieldExpression>
|
|
</textField>
|
|
<textField evaluationTime="Report">
|
|
<reportElement uuid="7bebdc0e-25ef-4c61-8f17-d81ea872d7ff" style="footerinfo" x="760" y="0" width="40" height="15"/>
|
|
<textElement>
|
|
<font fontName="SansSerif" size="10" isBold="false"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</pageFooter>
|
|
<summary>
|
|
<band height="42" splitType="Stretch"/>
|
|
</summary>
|
|
</jasperReport>
|