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="556" pageHeight="842" whenNoDataType="NoDataSection" columnWidth="556" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="85d4a540-608e-4934-8f57-57cec53afb74">
        <property name="ireport.zoom" value="1.5"/>
        <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
pe.dth_data_inicial,
pe.dth_data_final
FROM sc_scs.scs_turma tu
INNER JOIN sc_scs.scs_turma_periodo pe ON tu.seq_turma = pe.seq_turma
WHERE tu.seq_turma = $P{SEQ_TURMA}
ORDER BY pe.dth_data_inicial]]>
        </queryString>
        <field name="dth_data_inicial" class="java.sql.Timestamp"/>
        <field name="dth_data_final" class="java.sql.Timestamp"/>
        <columnHeader>
                <band height="40">
                        <rectangle>
                                <reportElement uuid="517180ca-ccbe-4e5d-8790-b8dd56a8fff3" x="0" y="20" width="279" height="20" isRemoveLineWhenBlank="true" backcolor="#CCCCCC"/>
                        </rectangle>
                        <rectangle>
                                <reportElement uuid="d36c861b-1edd-46ff-9d75-687d81f14f9c" x="279" y="20" width="277" height="20" isRemoveLineWhenBlank="true" backcolor="#CCCCCC"/>
                        </rectangle>
                        <staticText>
                                <reportElement uuid="8de517ab-c1d1-4b43-aa27-fe310862d014" x="0" y="20" width="279" height="20" isRemoveLineWhenBlank="true"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                </textElement>
                                <text><![CDATA[DATA E HORA INICIAL]]></text>
                        </staticText>
                        <staticText>
                                <reportElement uuid="cdf9f858-4462-4786-b22b-8c237db1f422" x="279" y="20" width="277" height="20" isRemoveLineWhenBlank="true"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                </textElement>
                                <text><![CDATA[DATA E HORA FINAL]]></text>
                        </staticText>
                        <rectangle>
                                <reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="0" y="0" width="556" height="20" isRemoveLineWhenBlank="true" backcolor="#CCCCCC"/>
                        </rectangle>
                        <staticText>
                                <reportElement uuid="7d9c1dd6-2f35-43d8-a3ed-ea5b2af0952a" x="0" y="0" width="556" height="20" isRemoveLineWhenBlank="true"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <text><![CDATA[PERÍODOS]]></text>
                        </staticText>
                </band>
        </columnHeader>
        <detail>
                <band height="20">
                        <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="277" height="20" backcolor="#FFFFFF"/>
                        </rectangle>
                        <textField isBlankWhenNull="true">
                                <reportElement uuid="3c3fb7fa-b427-4fae-afe9-af7a7db43103" x="0" y="0" width="279" height="20"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" isBold="false"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <textFieldExpression><![CDATA[new java.text.SimpleDateFormat("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="277" height="20"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" isBold="false"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <textFieldExpression><![CDATA[new java.text.SimpleDateFormat("dd'/'MM'/'yyyy 'às' HH:mm", new Locale("pt", "BR")).format($F{dth_data_final})]]></textFieldExpression>
                        </textField>
                </band>
        </detail>
        <noData>
                <band height="20">
                        <rectangle>
                                <reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="0" y="0" width="556" height="20" isRemoveLineWhenBlank="true" backcolor="#CCCCCC"/>
                        </rectangle>
                        <staticText>
                                <reportElement uuid="7d9c1dd6-2f35-43d8-a3ed-ea5b2af0952a" x="-1" y="0" width="557" height="20" isRemoveLineWhenBlank="true">
                                        <printWhenExpression><![CDATA[$F{dth_data_inicial} == null]]></printWhenExpression>
                                </reportElement>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <text><![CDATA[NÃO POSSUI PERÍODOS ]]></text>
                        </staticText>
                </band>
        </noData>
</jasperReport>