93 lines
4.6 KiB
XML
Executable File
93 lines
4.6 KiB
XML
Executable File
<?xml version="1.0" encoding="UTF-8"?>
|
|
<!-- Created with Jaspersoft Studio version 5.6.1.final using JasperReports Library version 5.6.1 -->
|
|
<!-- 2015-06-03T18:27:15 -->
|
|
<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="menulevelsubreport" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="842" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="027b9f69-a8b1-4a8b-b2f5-9a40a3d73b01">
|
|
<property name="ireport.zoom" value="1.0"/>
|
|
<property name="ireport.x" value="0"/>
|
|
<property name="ireport.y" value="0"/>
|
|
<template><![CDATA[$P{pathstyle}]]></template>
|
|
<parameter name="pathstyle" class="java.lang.String">
|
|
<defaultValueExpression><![CDATA["repo:/maia/1/style/style"]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="languagecode" class="java.lang.String"/>
|
|
<parameter name="menucode" class="java.math.BigDecimal">
|
|
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
|
|
<defaultValueExpression><![CDATA["repo:/maia/1/modules/security/subreports/"]]></defaultValueExpression>
|
|
</parameter>
|
|
<queryString>
|
|
<![CDATA[select TGML.LEVELCODE,
|
|
(select DESCRIPTION
|
|
from TGENEMENULEVELDESC
|
|
where MENUCODE = TGML.MENUCODE
|
|
and LEVELCODE = TGML.LEVELCODE
|
|
and LANGUAGECODE = $P{languagecode}) LEVELDESC
|
|
from TGENEMENULEVEL TGML
|
|
where TGML.MENUCODE = $P{menucode}
|
|
and TGML.HAVESUBLEVEL = 'Y'
|
|
order by TGML.PRESENTATIONORDER]]>
|
|
</queryString>
|
|
<field name="LEVELCODE" class="java.math.BigDecimal"/>
|
|
<field name="LEVELDESC" class="java.lang.String"/>
|
|
<group name="levelcode">
|
|
<groupExpression><![CDATA[$F{LEVELCODE}]]></groupExpression>
|
|
<groupHeader>
|
|
<band height="13">
|
|
<textField>
|
|
<reportElement style="detail" x="30" y="0" width="706" height="13" uuid="169b3c85-ac78-4ccc-8c98-a1e4070e37ba"/>
|
|
<textFieldExpression><![CDATA[($F{LEVELDESC} == null) ? $F{LEVELCODE}+" - "+"NIVEL NO DEFINIDO" : $F{LEVELDESC}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</groupHeader>
|
|
<groupFooter>
|
|
<band height="13">
|
|
<subreport>
|
|
<reportElement x="0" y="0" width="555" height="13" uuid="cc1a5747-f5ad-4f22-a829-de33eaec39af"/>
|
|
<subreportParameter name="pathstyle">
|
|
<subreportParameterExpression><![CDATA[$P{pathstyle}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<subreportParameter name="languagecode">
|
|
<subreportParameterExpression><![CDATA[$P{languagecode}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<subreportParameter name="menucode">
|
|
<subreportParameterExpression><![CDATA[$P{menucode}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<subreportParameter name="levelcode">
|
|
<subreportParameterExpression><![CDATA[$F{LEVELCODE}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
|
|
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "menusublevelsubreport"]]></subreportExpression>
|
|
</subreport>
|
|
</band>
|
|
</groupFooter>
|
|
</group>
|
|
<background>
|
|
<band splitType="Stretch"/>
|
|
</background>
|
|
<detail>
|
|
<band height="15">
|
|
<subreport>
|
|
<reportElement x="0" y="0" width="555" height="13" uuid="95aaa625-7610-4750-a1fe-05645b1cf239"/>
|
|
<subreportParameter name="pathstyle">
|
|
<subreportParameterExpression><![CDATA[$P{pathstyle}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<subreportParameter name="languagecode">
|
|
<subreportParameterExpression><![CDATA[$P{languagecode}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<subreportParameter name="menucode">
|
|
<subreportParameterExpression><![CDATA[$P{menucode}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<subreportParameter name="SUBREPORT_DIR">
|
|
<subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<subreportParameter name="levelcode">
|
|
<subreportParameterExpression><![CDATA[$F{LEVELCODE}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
|
|
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "transactionmenulevelsubreport"]]></subreportExpression>
|
|
</subreport>
|
|
</band>
|
|
</detail>
|
|
</jasperReport>
|