Subversion Repositories Integrator Subversion

<?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="relatorioCapacitacaoPorParticipante" pageWidth="555" pageHeight="842" columnWidth="555" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="85d4a540-608e-4934-8f57-57cec53afb74">
        <property name="ireport.zoom" value="1.3310000000000004"/>
        <property name="ireport.x" value="0"/>
        <property name="ireport.y" value="0"/>
        <parameter name="SEQ_TURMA" class="java.lang.Long">
                <defaultValueExpression><![CDATA[]]></defaultValueExpression>
        </parameter>
        <queryString>
                <![CDATA[SELECT
tr.seq_turma,
pe.dth_data_inicial,
pe.dth_data_final
FROM sc_scs.scs_turma tr
LEFT JOIN sc_scs.scs_turma_periodo pe ON tr.seq_turma = pe.seq_turma
WHERE tr.seq_turma = $P{SEQ_TURMA}
ORDER BY pe.dth_data_inicial]]>
        </queryString>
        <field name="seq_turma" class="java.lang.Long"/>
        <field name="dth_data_inicial" class="java.sql.Timestamp"/>
        <field name="dth_data_final" class="java.sql.Timestamp"/>
        <group name="Turma">
                <groupExpression><![CDATA[$F{seq_turma}]]></groupExpression>
                <groupHeader>
                        <band height="40">
                                <rectangle>
                                        <reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="0" y="0" width="555" height="20" backcolor="#FFFFFF"/>
                                </rectangle>
                                <textField>
                                        <reportElement uuid="bd7e6eee-80f8-4b1d-a789-7078dbf18cb1" mode="Transparent" x="1" y="0" width="554" height="20" backcolor="#FFFFFF"/>
                                        <textElement verticalAlignment="Middle">
                                                <font fontName="Arial" isBold="false" isPdfEmbedded="false"/>
                                                <paragraph leftIndent="5"/>
                                        </textElement>
                                        <textFieldExpression><![CDATA["TURMA: " + $F{seq_turma}]]></textFieldExpression>
                                </textField>
                                <rectangle>
                                        <reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="0" y="20" width="555" height="20" isRemoveLineWhenBlank="true" backcolor="#FFFFFF"/>
                                </rectangle>
                                <staticText>
                                        <reportElement uuid="7d9c1dd6-2f35-43d8-a3ed-ea5b2af0952a" x="0" y="20" width="555" height="20" isRemoveLineWhenBlank="true">
                                                <printWhenExpression><![CDATA[$F{dth_data_inicial} != null]]></printWhenExpression>
                                        </reportElement>
                                        <textElement verticalAlignment="Middle">
                                                <font fontName="Arial"/>
                                                <paragraph leftIndent="5"/>
                                        </textElement>
                                        <text><![CDATA[PERÍODOS:]]></text>
                                </staticText>
                        </band>
                </groupHeader>
        </group>
        <detail>
                <band height="20">
                        <printWhenExpression><![CDATA[$F{dth_data_inicial} != null]]></printWhenExpression>
                        <rectangle>
                                <reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="0" y="0" width="555" height="20" backcolor="#FFFFFF"/>
                        </rectangle>
                        <rectangle>
                                <reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="279" y="0" width="276" height="20" backcolor="#FFFFFF"/>
                        </rectangle>
                        <textField isBlankWhenNull="true">
                                <reportElement uuid="3c3fb7fa-b427-4fae-afe9-af7a7db43103" x="0" y="0" width="279" height="20"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" isBold="false"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <textFieldExpression><![CDATA[new java.text.SimpleDateFormat("'DATA E HORA INICIAL: 'dd'/'MM'/'yyyy 'às' HH:mm", new Locale("pt", "BR")).format($F{dth_data_inicial})]]></textFieldExpression>
                        </textField>
                        <textField isBlankWhenNull="true">
                                <reportElement uuid="103e38a4-442b-4954-b18b-5a293555f50a" x="279" y="0" width="276" height="20"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" isBold="false"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <textFieldExpression><![CDATA[new java.text.SimpleDateFormat("'DATA E HORA FINAL: 'dd'/'MM'/'yyyy 'às' HH:mm", new Locale("pt", "BR")).format($F{dth_data_final})]]></textFieldExpression>
                        </textField>
                </band>
        </detail>
</jasperReport>