WebSVN - Integrator Subversion - Rev 1 - /PROJETOS/scs/scs-core/target/classes/relatorios/relatorioParticipantePorTurma.jrxml

<?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="relatorio" pageWidth="595" pageHeight="842" columnWidth="556" leftMargin="20" rightMargin="19" topMargin="20" bottomMargin="20" 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="IMAGEM_DIR" class="java.lang.String">
                <defaultValueExpression><![CDATA["C:\\"]]></defaultValueExpression>
        </parameter>
        <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
                <defaultValueExpression><![CDATA["C:\\Repositorio\\DESENVOLVIMENTO\\SESAU\\JAVA\\Repositorio\\rhcapacitacao\\FONTES\\IMPLEMENTACAO\\DESENVOLVIMENTO\\scs\\scs-core\\src\\main\\resources\\relatorios\\"]]></defaultValueExpression>
        </parameter>
        <parameter name="NOM_USUARIO" class="java.lang.String">
                <defaultValueExpression><![CDATA[]]></defaultValueExpression>
        </parameter>
        <parameter name="CPF_USUARIO" class="java.lang.String">
                <defaultValueExpression><![CDATA[]]></defaultValueExpression>
        </parameter>
        <parameter name="SEQ_TURMA" class="java.lang.Long">
                <defaultValueExpression><![CDATA[]]></defaultValueExpression>
        </parameter>
        <queryString>
                <![CDATA[SELECT
(SELECT COUNT(fr.seq_turma) FROM sc_scs.scs_frequencia fr WHERE fr.seq_turma = $P{SEQ_TURMA} AND fr.ind_validado = true) as qtd_frequencia,
tu.seq_turma,
cp.dsc_capacitacao,
tu.num_ano
FROM sc_scs.scs_turma tu
INNER JOIN sc_scs.scs_capacitacao cp ON tu.seq_capacitacao = cp.seq_capacitacao
WHERE tu.seq_turma = $P{SEQ_TURMA}]]>
        </queryString>
        <field name="qtd_frequencia" class="java.lang.Long"/>
        <field name="seq_turma" class="java.lang.Long"/>
        <field name="dsc_capacitacao" class="java.lang.String"/>
        <field name="num_ano" class="java.math.BigDecimal"/>
        <pageHeader>
                <band height="116">
                        <staticText>
                                <reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="48" width="555" height="36"/>
                                <textElement textAlignment="Center" verticalAlignment="Top">
                                        <font fontName="Arial" size="10" isBold="false" pdfFontName="Helvetica" isPdfEmbedded="true"/>
                                </textElement>
                                <text><![CDATA[Secretaria de Estado da Saúde
Coordenadoria Setorial de Gestão e Desenvolvimento de Pessoas
Gerência de Desenvolvimento e Educação de Pessoas
]]></text>
                        </staticText>
                        <image scaleImage="RealSize" hAlign="Center" vAlign="Middle" onErrorType="Icon">
                                <reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" positionType="Float" mode="Transparent" x="258" y="0" width="33" height="36"/>
                                <imageExpression><![CDATA[$P{IMAGEM_DIR} + "brasao.png"]]></imageExpression>
                        </image>
                        <staticText>
                                <reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="37" width="555" height="12"/>
                                <textElement textAlignment="Center" verticalAlignment="Top">
                                        <font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                </textElement>
                                <text><![CDATA[Estado de Alagoas]]></text>
                        </staticText>
                        <staticText>
                                <reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="92" width="555" height="12"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                </textElement>
                                <text><![CDATA[Relatório de Participantes por Turma]]></text>
                        </staticText>
                </band>
        </pageHeader>
        <detail>
                <band height="120">
                        <rectangle>
                                <reportElement uuid="c3eedd42-a096-4b5c-8c9c-ef04da5f8b58" x="0" y="40" width="92" height="20"/>
                        </rectangle>
                        <rectangle>
                                <reportElement uuid="19f89383-f30c-43a6-9677-4bcceba181d8" x="0" y="20" width="92" height="20" backcolor="#CCCCCC"/>
                        </rectangle>
                        <rectangle>
                                <reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="0" y="0" width="556" height="20" backcolor="#CCCCCC"/>
                        </rectangle>
                        <rectangle>
                                <reportElement uuid="1ce4fd6f-836f-4005-96f5-d0a9bf065420" x="164" y="20" width="392" height="20" backcolor="#CCCCCC"/>
                        </rectangle>
                        <staticText>
                                <reportElement uuid="5b3ddd59-b852-459a-a68d-6529ce9bb9a6" x="0" y="0" width="556" height="20"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                </textElement>
                                <text><![CDATA[TURMA]]></text>
                        </staticText>
                        <rectangle>
                                <reportElement uuid="b5955532-652d-4a7a-881a-29fa82c7b637" x="92" y="40" width="72" height="20"/>
                        </rectangle>
                        <rectangle>
                                <reportElement uuid="19f89383-f30c-43a6-9677-4bcceba181d8" x="92" y="20" width="72" height="20" backcolor="#CCCCCC"/>
                        </rectangle>
                        <staticText>
                                <reportElement uuid="5a3503cf-7325-4d4f-b9df-ffdf89f3ecc3" x="0" y="20" width="92" height="20"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                </textElement>
                                <text><![CDATA[IDENTIFICADOR]]></text>
                        </staticText>
                        <staticText>
                                <reportElement uuid="92d74d74-bf89-40b6-8935-534fefbfdd6a" x="92" y="20" width="72" height="20"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                </textElement>
                                <text><![CDATA[ANO]]></text>
                        </staticText>
                        <staticText>
                                <reportElement uuid="cd5b1a6e-c479-428f-ac03-5ad82545cd5a" x="166" y="20" width="390" height="20"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                </textElement>
                                <text><![CDATA[CAPACITAÇÃO]]></text>
                        </staticText>
                        <rectangle>
                                <reportElement uuid="b5955532-652d-4a7a-881a-29fa82c7b637" x="164" y="40" width="392" height="20"/>
                        </rectangle>
                        <textField>
                                <reportElement uuid="ef447b8d-0dd6-4679-954e-4dd6301fcd3a" x="0" y="40" width="92" height="20"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font isStrikeThrough="false"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{seq_turma}]]></textFieldExpression>
                        </textField>
                        <textField>
                                <reportElement uuid="1ef917e4-287f-403b-b41d-f31d75f26b29" x="92" y="40" width="72" height="20"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{num_ano}]]></textFieldExpression>
                        </textField>
                        <textField>
                                <reportElement uuid="67a97f5b-cb79-4c66-9a22-dccea39f27bc" x="164" y="40" width="392" height="20"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font isStrikeThrough="false"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{dsc_capacitacao}]]></textFieldExpression>
                        </textField>
                        <subreport>
                                <reportElement uuid="f6b7315c-0b31-42d0-866a-ec7075b0ebc1" positionType="Float" x="0" y="80" width="556" height="20"/>
                                <subreportParameter name="SUBREPORT_DIR">
                                        <subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportParameter name="NOM_USUARIO">
                                        <subreportParameterExpression><![CDATA[$P{NOM_USUARIO}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportParameter name="IMAGEM_DIR">
                                        <subreportParameterExpression><![CDATA[$P{IMAGEM_DIR}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportParameter name="CPF_USUARIO">
                                        <subreportParameterExpression><![CDATA[$P{CPF_USUARIO}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportParameter name="SEQ_TURMA">
                                        <subreportParameterExpression><![CDATA[$P{SEQ_TURMA}]]></subreportParameterExpression>
                                </subreportParameter>
                                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorioParticipantePorTurma_sub_periodos.jasper"]]></subreportExpression>
                        </subreport>
                        <subreport>
                                <reportElement uuid="56b24167-017e-4c01-a2ff-d96501b7c52a" positionType="Float" x="0" y="100" width="556" height="20"/>
                                <subreportParameter name="SUBREPORT_DIR">
                                        <subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportParameter name="QTD_FREQUENCIA">
                                        <subreportParameterExpression><![CDATA[$F{qtd_frequencia}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportParameter name="NOM_USUARIO">
                                        <subreportParameterExpression><![CDATA[$P{NOM_USUARIO}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportParameter name="IMAGEM_DIR">
                                        <subreportParameterExpression><![CDATA[$P{IMAGEM_DIR}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportParameter name="CPF_USUARIO">
                                        <subreportParameterExpression><![CDATA[$P{CPF_USUARIO}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportParameter name="SEQ_TURMA">
                                        <subreportParameterExpression><![CDATA[$P{SEQ_TURMA}]]></subreportParameterExpression>
                                </subreportParameter>
                                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorioParticipantePorTurma_sub_participante.jasper"]]></subreportExpression>
                        </subreport>
                        <subreport>
                                <reportElement uuid="cfec7a7e-37d9-4f8f-a3cf-2a13d6c4ca39" positionType="Float" x="0" y="60" width="556" height="20"/>
                                <subreportParameter name="SUBREPORT_DIR">
                                        <subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportParameter name="NOM_USUARIO">
                                        <subreportParameterExpression><![CDATA[$P{NOM_USUARIO}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportParameter name="IMAGEM_DIR">
                                        <subreportParameterExpression><![CDATA[$P{IMAGEM_DIR}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportParameter name="CPF_USUARIO">
                                        <subreportParameterExpression><![CDATA[$P{CPF_USUARIO}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportParameter name="SEQ_TURMA">
                                        <subreportParameterExpression><![CDATA[$P{SEQ_TURMA}]]></subreportParameterExpression>
                                </subreportParameter>
                                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorioParticipantePorTurma_sub_organizadores.jasper"]]></subreportExpression>
                        </subreport>
                </band>
        </detail>
        <pageFooter>
                <band height="15">
                        <textField isBlankWhenNull="true">
                                <reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="0" y="0" width="374" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6" isBold="false"/>
                                </textElement>
                                <textFieldExpression><![CDATA["Gerado por " + $P{NOM_USUARIO} + ", CPF: " + $P{CPF_USUARIO} + new java.text.SimpleDateFormat("', em 'dd 'de' MMMMM 'de' yyyy' às 'HH:mm", new Locale("pt", "BR")).format(new java.util.Date()).toUpperCase()]]></textFieldExpression>
                        </textField>
                        <textField isBlankWhenNull="false">
                                <reportElement uuid="e5f06c72-11c0-479b-b234-4dcaf2bc0440" key="textField" x="428" y="0" width="73" height="15"/>
                                <textElement textAlignment="Right" verticalAlignment="Middle">
                                        <font fontName="Arial" size="6" isBold="false"/>
                                </textElement>
                                <textFieldExpression><![CDATA["PÁGINA " + $V{PAGE_NUMBER} + " DE "]]></textFieldExpression>
                        </textField>
                        <textField evaluationTime="Report" isBlankWhenNull="false">
                                <reportElement uuid="506b9991-ff6d-43b5-ab78-2832586c3dda" key="textField" x="502" y="0" width="52" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6" isBold="false"/>
                                </textElement>
                                <textFieldExpression><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
                        </textField>
                </band>
        </pageFooter>
</jasperReport>
Subversion Repositories Integrator Subversion

(root)/PROJETOS/scs/scs-core/target/classes/relatorios/relatorioParticipantePorTurma.jrxml @ 793 - Rev 1
