351 lines
21 KiB
XML
Executable File
351 lines
21 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 -->
|
|
<!-- 2015-01-16T10:07:34 -->
|
|
<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="audit" language="groovy" pageWidth="3765" pageHeight="2380" orientation="Landscape" columnWidth="3765" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" isIgnorePagination="true" uuid="2b5ecf57-2c50-489e-bbfe-ffa4ba8a0ac6">
|
|
<property name="ireport.zoom" value="1.5"/>
|
|
<property name="ireport.x" value="0"/>
|
|
<property name="ireport.y" value="0"/>
|
|
<template><![CDATA[$P{pathstyle}]]></template>
|
|
<parameter name="pathimage" class="java.lang.String" isForPrompting="false">
|
|
<defaultValueExpression><![CDATA["repo:/maia/1/image/logo"]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="workingdate" class="java.lang.String" isForPrompting="false">
|
|
<defaultValueExpression><![CDATA["2011-12-31"]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="pathstyle" class="java.lang.String" isForPrompting="false">
|
|
<defaultValueExpression><![CDATA["repo:/maia/1/style/style"]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="dateto" class="java.sql.Timestamp" isForPrompting="false">
|
|
<defaultValueExpression><![CDATA[com.fp.report.util.Utilities.getDefaultExpiryTimestamp()]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="company" class="java.lang.Integer" isForPrompting="false"/>
|
|
<parameter name="dateFrom" class="java.lang.String" isForPrompting="false"/>
|
|
<parameter name="dateTo" class="java.lang.String" isForPrompting="false"/>
|
|
<parameter name="dateToTime" class="java.util.Date" isForPrompting="false">
|
|
<defaultValueExpression><![CDATA[com.fp.report.util.Utilities.StringToDate($P{dateTo})]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="dateFromTime" class="java.util.Date" isForPrompting="false">
|
|
<defaultValueExpression><![CDATA[com.fp.report.util.Utilities.StringToDate($P{dateFrom})]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="userCode" class="java.lang.String" isForPrompting="false"/>
|
|
<parameter name="tableName" class="java.lang.String" isForPrompting="false"/>
|
|
<parameter name="transactionModule" class="java.lang.String" isForPrompting="false"/>
|
|
<parameter name="partition1" class="java.lang.String" isForPrompting="false">
|
|
<parameterDescription><![CDATA[]]></parameterDescription>
|
|
<defaultValueExpression><![CDATA[com.fp.report.util.Utilities.getPartition($P{dateFrom})]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="partition2" class="java.lang.String" isForPrompting="false">
|
|
<parameterDescription><![CDATA[]]></parameterDescription>
|
|
<defaultValueExpression><![CDATA[com.fp.report.util.Utilities.getPartition($P{dateTo})]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="transactionCode" class="java.lang.String" isForPrompting="false"/>
|
|
<parameter name="transactionVersion" class="java.lang.String" isForPrompting="false"/>
|
|
<parameter name="personcode" class="java.lang.String" isForPrompting="false"/>
|
|
<parameter name="pathLogoIzquierda" class="java.lang.String">
|
|
<defaultValueExpression><![CDATA["repo:/maia/1/image/comandoconjunto"]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="pathLogoDerecha" class="java.lang.String">
|
|
<defaultValueExpression><![CDATA["repo:/maia/1/image/selloarmas"]]></defaultValueExpression>
|
|
</parameter>
|
|
<queryString language="SQL">
|
|
<![CDATA[select AUD.CHANGEDATE,
|
|
(select DESCRIPTION from TGENEOFFICE where OFFICECODE = AUD.OFFICECODE and BRANCHCODE = AUD.BRANCHCODE and COMPANYCODE = AUD.COMPANYCODE) OFFICEDES,
|
|
(select DESCRIPTION from TGENEBRANCH where BRANCHCODE = AUD.BRANCHCODE and COMPANYCODE = AUD.COMPANYCODE) BRANCHDES,
|
|
AUD.TERMINALCODE,AUD.USERCODE, AUD.REALDATE,
|
|
(select TGM.DESCRIPTION FROM TGENEMODULE TGM where TGM.MODULECODE =TRANSACTIONMODULE) MODULEDESC,
|
|
TRANSACTIONMODULE, TRANSACTIONCODE,
|
|
(select NAME FROM TGENETRANSACTION WHERE TRANSACTIONCODE = AUD.TRANSACTIONCODE AND TRANSACTIONMODULE = AUD.TRANSACTIONMODULE AND TRANSACTIONVERSION = AUD.TRANSACTIONVERSION) TRANDES,
|
|
AUD.TABLENAME, AUD.COLUMNNAME, 'UPDATE' ACTION, AUD.OLDVALUE, AUD.NEWVALUE,
|
|
(select recvalue from TSAFEAUDITINSDEL where realdate='') RECVALUE,
|
|
AUD.ACCOUNT, AUD.SOLICITUDENUMBER, AUD.PERSONCODE,
|
|
(select TCPD.NAME from TCUSTPERSONDETAIL TCPD where TCPD.PERSONCODE = AUD.PERSONCODE and TCPD.DATETO =to_date(TO_CHAR($P{dateto}, 'yyyy-MM-dd'),'yyyy-mm-dd')) PERSONNAME
|
|
from TSAFEAUDIT AUD
|
|
WHERE AUD.CHANGEDATE >=TO_DATE($P{dateFrom},'yyyy-MM-dd')
|
|
AND AUD.CHANGEDATE <= TO_DATE($P{dateTo} ,'yyyy-MM-dd')
|
|
AND AUD.COMPANYCODE = $P{company}
|
|
AND AUD.USERCODE = coalesce($P{userCode},AUD.USERCODE)
|
|
AND AUD.TABLENAME = coalesce($P{tableName},AUD.TABLENAME)
|
|
AND AUD.TRANSACTIONMODULE =coalesce($P{transactionModule},AUD.TRANSACTIONMODULE)
|
|
AND AUD.TRANSACTIONCODE =coalesce(to_number($P{transactionCode}),AUD.TRANSACTIONCODE)
|
|
AND AUD.TRANSACTIONVERSION =coalesce(to_number($P{transactionVersion}),AUD.TRANSACTIONVERSION)
|
|
AND AUD.PERSONCODE =coalesce(to_number($P{personcode}),AUD.PERSONCODE)
|
|
AND AUD.PARTITIONDB between $P{partition1} and $P{partition2}
|
|
UNION ALL
|
|
select AUD.CHANGEDATE,
|
|
(select DESCRIPTION from TGENEOFFICE where OFFICECODE = AUD.OFFICECODE and BRANCHCODE = AUD.BRANCHCODE and COMPANYCODE = AUD.COMPANYCODE) OFFICEDES,
|
|
(select DESCRIPTION from TGENEBRANCH where BRANCHCODE = AUD.BRANCHCODE and COMPANYCODE = AUD.COMPANYCODE) BRANCHDES,
|
|
TERMINALCODE,USERCODE, REALDATE,
|
|
(select TGM.DESCRIPTION FROM TGENEMODULE TGM where TGM.MODULECODE = TRANSACTIONMODULE) MODULEDESC,
|
|
TRANSACTIONMODULE, TRANSACTIONCODE,
|
|
(select NAME FROM TGENETRANSACTION WHERE TRANSACTIONCODE = AUD.TRANSACTIONCODE AND TRANSACTIONMODULE = AUD.TRANSACTIONMODULE AND TRANSACTIONVERSION = AUD.TRANSACTIONVERSION) TRANDES,
|
|
AUD.TABLENAME, '' COLUMNNAME,
|
|
CASE WHEN ISINSERT = 'Y' THEN 'INSERT'
|
|
ELSE 'DELETE'
|
|
END ACTION,
|
|
'' OLDVALUE, '' NEWVALUE, RECVALUE,
|
|
AUD.ACCOUNT, AUD.SOLICITUDENUMBER, AUD.PERSONCODE,
|
|
(select TCPD.NAME from TCUSTPERSONDETAIL TCPD where TCPD.PERSONCODE = AUD.PERSONCODE and TCPD.DATETO =to_date(TO_CHAR($P{dateto}, 'yyyy-MM-dd'),'yyyy-mm-dd')) PERSONNAME
|
|
from TSAFEAUDITINSDEL AUD
|
|
WHERE AUD.CHANGEDATE >=TO_DATE($P{dateFrom},'yyyy-MM-dd')
|
|
AND AUD.CHANGEDATE <= TO_DATE($P{dateTo} ,'yyyy-MM-dd')
|
|
AND AUD.COMPANYCODE = $P{company}
|
|
AND AUD.USERCODE = coalesce($P{userCode},AUD.USERCODE)
|
|
AND AUD.TABLENAME = coalesce($P{tableName},AUD.TABLENAME)
|
|
AND AUD.TRANSACTIONMODULE =coalesce($P{transactionModule},AUD.TRANSACTIONMODULE)
|
|
AND AUD.TRANSACTIONCODE =coalesce(to_number($P{transactionCode}),AUD.TRANSACTIONCODE)
|
|
AND AUD.TRANSACTIONVERSION =coalesce(to_number($P{transactionVersion}),AUD.TRANSACTIONVERSION)
|
|
AND AUD.PERSONCODE =coalesce(to_number($P{personcode}),AUD.PERSONCODE)
|
|
AND AUD.PARTITIONDB between $P{partition1} and $P{partition2}]]>
|
|
</queryString>
|
|
<field name="CHANGEDATE" class="java.util.Date"/>
|
|
<field name="OFFICEDES" class="java.lang.String"/>
|
|
<field name="BRANCHDES" class="java.lang.String"/>
|
|
<field name="TERMINALCODE" class="java.lang.String"/>
|
|
<field name="USERCODE" class="java.lang.String"/>
|
|
<field name="REALDATE" class="java.sql.Timestamp"/>
|
|
<field name="TRANSACTIONMODULE" class="java.lang.String"/>
|
|
<field name="TRANSACTIONCODE" class="java.lang.Integer"/>
|
|
<field name="TRANDES" class="java.lang.String"/>
|
|
<field name="TABLENAME" class="java.lang.String"/>
|
|
<field name="COLUMNNAME" class="java.lang.String"/>
|
|
<field name="ACTION" class="java.lang.String"/>
|
|
<field name="OLDVALUE" class="java.lang.String"/>
|
|
<field name="NEWVALUE" class="java.lang.String"/>
|
|
<field name="MODULEDESC" class="java.lang.String"/>
|
|
<field name="RECVALUE" class="java.sql.Clob"/>
|
|
<field name="ACCOUNT" class="java.lang.String"/>
|
|
<field name="SOLICITUDENUMBER" class="java.lang.String"/>
|
|
<field name="PERSONCODE" class="java.lang.Integer"/>
|
|
<field name="PERSONNAME" class="java.lang.String"/>
|
|
<title>
|
|
<band height="89" splitType="Stretch">
|
|
<staticText>
|
|
<reportElement style="title" x="0" y="35" width="3960" height="22" uuid="7b18a53d-f872-4a68-b6fa-13c5daecccfa"/>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="SansSerif" size="14" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[REPORTE DE AUDITORIA]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="headercolumn2" mode="Opaque" x="633" y="76" width="120" height="13" forecolor="#FFFFFF" backcolor="#666666" uuid="9e1eb436-b686-4f8a-9993-d67206c69b01"/>
|
|
<textElement textAlignment="Left" verticalAlignment="Middle">
|
|
<font fontName="SansSerif" size="9"/>
|
|
</textElement>
|
|
<text><![CDATA[Módulo]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="headercolumn2" mode="Opaque" x="385" y="76" width="150" height="13" forecolor="#FFFFFF" backcolor="#666666" uuid="08cb2a1d-5a0b-49e3-b421-b234431afd77"/>
|
|
<textElement verticalAlignment="Middle">
|
|
<font fontName="SansSerif" size="9"/>
|
|
</textElement>
|
|
<text><![CDATA[Usuario]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="headercolumn2" mode="Opaque" x="1871" y="76" width="325" height="13" forecolor="#FFFFFF" backcolor="#666666" uuid="139f04e4-534e-4a43-a075-ac29a1453103"/>
|
|
<textElement textAlignment="Left" verticalAlignment="Middle">
|
|
<font fontName="SansSerif" size="9" isItalic="false"/>
|
|
</textElement>
|
|
<text><![CDATA[Valor Anterior]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="headercolumn2" mode="Opaque" x="1018" y="76" width="130" height="13" forecolor="#FFFFFF" backcolor="#666666" uuid="87befae1-3f1b-4836-9518-3eb79cc2392a"/>
|
|
<textElement verticalAlignment="Middle">
|
|
<font fontName="SansSerif" size="9"/>
|
|
</textElement>
|
|
<text><![CDATA[Tabla]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="headercolumn2" mode="Opaque" x="0" y="76" width="60" height="13" forecolor="#FFFFFF" backcolor="#666666" uuid="4b5cb20b-290f-4297-a2eb-6d979dac376c"/>
|
|
<textElement verticalAlignment="Middle">
|
|
<font fontName="SansSerif" size="9"/>
|
|
</textElement>
|
|
<text><![CDATA[Fecha ]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="headercolumn2" mode="Opaque" x="2196" y="76" width="325" height="13" forecolor="#FFFFFF" backcolor="#666666" uuid="8b8820d8-d341-4be4-9e50-1a10937293c2"/>
|
|
<textElement textAlignment="Left" verticalAlignment="Middle">
|
|
<font fontName="SansSerif" size="9"/>
|
|
</textElement>
|
|
<text><![CDATA[Valor Act.ual]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="headercolumn2" mode="Opaque" x="535" y="76" width="98" height="13" forecolor="#FFFFFF" backcolor="#666666" uuid="4e6d5638-73e1-464f-b00d-b3f309bd44c1"/>
|
|
<textElement verticalAlignment="Middle">
|
|
<font fontName="SansSerif" size="9"/>
|
|
</textElement>
|
|
<text><![CDATA[Fecha/Hora]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="headercolumn2" mode="Opaque" x="1148" y="76" width="130" height="13" forecolor="#FFFFFF" backcolor="#666666" uuid="81f8cad9-a63b-4832-8a87-dc926c592f66"/>
|
|
<textElement textAlignment="Left" verticalAlignment="Middle">
|
|
<font fontName="SansSerif" size="9"/>
|
|
</textElement>
|
|
<text><![CDATA[Campo]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="headercolumn2" mode="Opaque" x="60" y="76" width="125" height="13" forecolor="#FFFFFF" backcolor="#666666" uuid="e02e2726-f2db-4aec-af91-63b09b03a507"/>
|
|
<textElement verticalAlignment="Middle">
|
|
<font fontName="SansSerif" size="9"/>
|
|
</textElement>
|
|
<text><![CDATA[Oficina]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="headercolumn2" mode="Opaque" x="818" y="76" width="200" height="13" forecolor="#FFFFFF" backcolor="#666666" uuid="fd036e00-49d4-470b-af37-0511a8a7f12d"/>
|
|
<textElement textAlignment="Left" verticalAlignment="Middle">
|
|
<font fontName="SansSerif" size="9"/>
|
|
</textElement>
|
|
<text><![CDATA[Descripción]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="headercolumn2" mode="Opaque" x="1278" y="76" width="90" height="13" forecolor="#FFFFFF" backcolor="#666666" uuid="fd03e3b8-24ea-4a9a-adec-513c966f5216"/>
|
|
<textElement textAlignment="Left" verticalAlignment="Middle">
|
|
<font fontName="SansSerif" size="9"/>
|
|
</textElement>
|
|
<text><![CDATA[Acción]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="headercolumn2" mode="Opaque" x="753" y="76" width="65" height="13" forecolor="#FFFFFF" backcolor="#666666" uuid="89142c78-b70f-4554-bf50-d373ebf538d8"/>
|
|
<textElement textAlignment="Left" verticalAlignment="Middle">
|
|
<font fontName="SansSerif" size="9"/>
|
|
</textElement>
|
|
<text><![CDATA[Transacción]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="headercolumn2" mode="Opaque" x="185" y="76" width="125" height="13" forecolor="#FFFFFF" backcolor="#666666" uuid="35095abe-0b48-4b72-9ca2-2be89a3c4050"/>
|
|
<textElement verticalAlignment="Middle">
|
|
<font fontName="SansSerif" size="9"/>
|
|
</textElement>
|
|
<text><![CDATA[Sucursal]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="headercolumn2" mode="Opaque" x="310" y="76" width="75" height="13" forecolor="#FFFFFF" backcolor="#666666" uuid="8ee211f1-0069-4e5b-ac47-4753a0667700"/>
|
|
<textElement verticalAlignment="Middle">
|
|
<font fontName="SansSerif" size="9"/>
|
|
</textElement>
|
|
<text><![CDATA[Terminal]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="headercolumn2" mode="Opaque" x="2521" y="76" width="1242" height="13" forecolor="#FFFFFF" backcolor="#666666" uuid="796f8642-4824-4837-a295-86cc08853f6c"/>
|
|
<textElement textAlignment="Left" verticalAlignment="Middle">
|
|
<font fontName="SansSerif" size="9"/>
|
|
</textElement>
|
|
<text><![CDATA[Valor]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="headercolumn2" mode="Opaque" x="1368" y="76" width="100" height="13" forecolor="#FFFFFF" backcolor="#666666" uuid="61e559b9-a2e7-424c-ad18-6243a4a003d9"/>
|
|
<textElement textAlignment="Left" verticalAlignment="Middle">
|
|
<font fontName="SansSerif" size="9"/>
|
|
</textElement>
|
|
<text><![CDATA[Cliente]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="headercolumn2" mode="Opaque" x="1468" y="76" width="403" height="13" forecolor="#FFFFFF" backcolor="#666666" uuid="319528be-cbd6-4fed-ab56-f5924a1a0382"/>
|
|
<textElement textAlignment="Left" verticalAlignment="Middle">
|
|
<font fontName="SansSerif" size="9"/>
|
|
</textElement>
|
|
<text><![CDATA[Nombre]]></text>
|
|
</staticText>
|
|
<image>
|
|
<reportElement x="10" y="10" width="195" height="53" uuid="e2baa834-bd1c-4919-aeee-b2f20d9d8f4c">
|
|
<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"/>
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
</reportElement>
|
|
<imageExpression><![CDATA[$P{pathLogoIzquierda}]]></imageExpression>
|
|
</image>
|
|
<image>
|
|
<reportElement x="3590" y="10" width="116" height="53" uuid="8bea3143-61b8-4f9f-8e2d-ff4f40851b6f">
|
|
<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>
|
|
<imageExpression><![CDATA[$P{pathLogoDerecha}]]></imageExpression>
|
|
</image>
|
|
</band>
|
|
</title>
|
|
<detail>
|
|
<band height="13" splitType="Stretch">
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" x="310" y="0" width="75" height="13" uuid="e8be9c62-27ea-4a35-96cc-939079052792"/>
|
|
<textFieldExpression><![CDATA[$F{TERMINALCODE}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" x="385" y="0" width="150" height="13" uuid="848a1dfd-492e-4eb9-8aa5-2e458c377ce7"/>
|
|
<textFieldExpression><![CDATA[$F{USERCODE}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" x="633" y="0" width="120" height="13" uuid="e40d5ef3-b0ca-497a-81b2-f607d55a13a7"/>
|
|
<textElement textAlignment="Left"/>
|
|
<textFieldExpression><![CDATA[$F{MODULEDESC}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" x="753" y="0" width="65" height="13" uuid="174519b4-b7b5-4dde-b9f2-61b4813b0e77"/>
|
|
<textElement textAlignment="Left"/>
|
|
<textFieldExpression><![CDATA[$F{TRANSACTIONCODE}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" x="1148" y="0" width="130" height="13" uuid="76facd9d-d8c6-4861-8e9c-62cff38deddc"/>
|
|
<textFieldExpression><![CDATA[$F{COLUMNNAME}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" x="1018" y="0" width="130" height="13" uuid="0c8086b8-3091-4aab-b047-070e5ffcdb77"/>
|
|
<textFieldExpression><![CDATA[$F{TABLENAME}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" x="1871" y="0" width="325" height="13" isPrintWhenDetailOverflows="true" uuid="1d17ef58-8bfd-4734-aa4a-be65b85560bb"/>
|
|
<textElement textAlignment="Left"/>
|
|
<textFieldExpression><![CDATA[$F{OLDVALUE}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" x="2196" y="0" width="325" height="13" uuid="bdfde591-8052-4e1b-b227-7b02e9b63b38"/>
|
|
<textElement textAlignment="Left"/>
|
|
<textFieldExpression><![CDATA[$F{NEWVALUE}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" x="60" y="0" width="125" height="13" uuid="07508e39-d7cb-4105-8575-469828cdca77"/>
|
|
<textFieldExpression><![CDATA[$F{OFFICEDES}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" x="185" y="0" width="125" height="13" uuid="6666dc25-2078-470c-b3c2-eab1934823b4"/>
|
|
<textFieldExpression><![CDATA[$F{BRANCHDES}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" x="818" y="0" width="200" height="13" uuid="fca5dbdb-574d-4af5-9152-b9722927b61d"/>
|
|
<textElement textAlignment="Left"/>
|
|
<textFieldExpression><![CDATA[$F{TRANDES}]]></textFieldExpression>
|
|
</textField>
|
|
<textField pattern="yyyy-MM-dd HH:mm:ss" isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" x="535" y="0" width="98" height="13" uuid="0c145d09-0988-4cfc-82a2-7037812b4485"/>
|
|
<textFieldExpression><![CDATA[$F{REALDATE}]]></textFieldExpression>
|
|
</textField>
|
|
<textField pattern="yyyy-MM-dd" isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" x="0" y="0" width="60" height="13" uuid="51bb3c53-35f4-4338-8bbd-48cb7bc51132"/>
|
|
<textFieldExpression><![CDATA[$F{CHANGEDATE}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" x="1278" y="0" width="90" height="13" uuid="a477a1c1-ae30-44b2-9a91-a805fb74b2c8"/>
|
|
<textElement textAlignment="Left"/>
|
|
<textFieldExpression><![CDATA[$F{ACTION}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" x="2521" y="0" width="1242" height="13" uuid="8c8c8fc4-dd4d-4662-8b76-facea2cb2922"/>
|
|
<textElement textAlignment="Left"/>
|
|
<textFieldExpression><![CDATA[com.fp.report.util.Utilities.clobToString($F{RECVALUE})]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" x="1368" y="0" width="100" height="13" uuid="e0f53d55-e5d7-4958-8659-19d97c257ec6"/>
|
|
<textElement textAlignment="Left"/>
|
|
<textFieldExpression><![CDATA[$F{PERSONCODE}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="normal1" x="1468" y="0" width="403" height="13" uuid="4f917c00-6d85-4767-9489-2bbce3fcf404"/>
|
|
<textElement textAlignment="Left"/>
|
|
<textFieldExpression><![CDATA[$F{PERSONNAME}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</detail>
|
|
</jasperReport>
|