Subversion Repositories Integrator Subversion

Rev

Blame | Last modification | View Log | Download | RSS feed 

<?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="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="85d4a540-608e-4934-8f57-57cec53afb74">
        <property name="ireport.zoom" value="1.0"/>
        <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="SEQ_PESSOA_FISICA" class="java.lang.Long">
                <defaultValueExpression><![CDATA[]]></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="ANO" class="java.lang.Integer">
                <defaultValueExpression><![CDATA[]]></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>
        <queryString>
                <![CDATA[SELECT
pf.seq_pessoa, pf.nom_pessoa, pf.num_documento
FROM sc_scg.vw_pessoa_fisica pf
WHERE pf.seq_pessoa = $P{SEQ_PESSOA_FISICA}
AND EXISTS
(
   SELECT
   tp.seq_pessoa_participante
   FROM sc_scs.scs_turma_participante tp
   WHERE tp.seq_pessoa_participante = pf.seq_pessoa
)]]>
        </queryString>
        <field name="seq_pessoa" class="java.lang.Long"/>
        <field name="nom_pessoa" class="java.lang.String"/>
        <field name="num_documento" class="java.lang.String"/>
        <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 Capacitação por Participante]]></text>
                        </staticText>
                </band>
        </pageHeader>
        <columnHeader>
                <band height="60">
                        <elementGroup>
                                <rectangle>
                                        <reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="0" y="0" width="555" height="20" backcolor="#CCCCCC"/>
                                </rectangle>
                                <staticText>
                                        <reportElement uuid="5b3ddd59-b852-459a-a68d-6529ce9bb9a6" x="0" y="0" width="555" height="20"/>
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                        </textElement>
                                        <text><![CDATA[PARTICIPANTE]]></text>
                                </staticText>
                                <rectangle>
                                        <reportElement uuid="19f89383-f30c-43a6-9677-4bcceba181d8" x="0" y="20" width="280" height="20" backcolor="#CCCCCC"/>
                                </rectangle>
                                <rectangle>
                                        <reportElement uuid="1ce4fd6f-836f-4005-96f5-d0a9bf065420" x="280" y="20" width="275" height="20" backcolor="#CCCCCC"/>
                                </rectangle>
                                <staticText>
                                        <reportElement uuid="718efbbe-2056-445a-ae3e-45fe27bd0f07" x="0" y="20" width="280" height="20"/>
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                        </textElement>
                                        <text><![CDATA[NOME]]></text>
                                </staticText>
                                <staticText>
                                        <reportElement uuid="26da0dfe-0a8e-49e4-ae89-92fe241d1733" x="280" y="20" width="275" height="20"/>
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                        </textElement>
                                        <text><![CDATA[CPF]]></text>
                                </staticText>
                                <rectangle>
                                        <reportElement uuid="c3eedd42-a096-4b5c-8c9c-ef04da5f8b58" x="0" y="40" width="280" height="20"/>
                                </rectangle>
                                <rectangle>
                                        <reportElement uuid="b5955532-652d-4a7a-881a-29fa82c7b637" x="280" y="40" width="275" height="20"/>
                                </rectangle>
                                <textField>
                                        <reportElement uuid="a07939dd-ee07-4456-ad06-b7d04c33f146" x="0" y="41" width="280" height="19"/>
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                        </textElement>
                                        <textFieldExpression><![CDATA[$F{nom_pessoa}]]></textFieldExpression>
                                </textField>
                                <textField>
                                        <reportElement uuid="a07939dd-ee07-4456-ad06-b7d04c33f146" x="280" y="41" width="275" height="19"/>
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                        </textElement>
                                        <textFieldExpression><![CDATA[$F{num_documento}]]></textFieldExpression>
                                </textField>
                        </elementGroup>
                </band>
        </columnHeader>
        <detail>
                <band height="20">
                        <subreport>
                                <reportElement uuid="690c85e2-8e91-4f16-830b-6228301c9ada" x="0" y="0" width="555" height="20" isRemoveLineWhenBlank="true"/>
                                <subreportParameter name="SUBREPORT_DIR">
                                        <subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportParameter name="SEQ_PESSOA_FISICA">
                                        <subreportParameterExpression><![CDATA[$P{SEQ_PESSOA_FISICA}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportParameter name="ANO">
                                        <subreportParameterExpression><![CDATA[$P{ANO}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportParameter name="IMAGEM_DIR">
                                        <subreportParameterExpression><![CDATA[$P{IMAGEM_DIR}]]></subreportParameterExpression>
                                </subreportParameter>
                                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorioCapacitacaoPorParticipante_sub_ano.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>
        <summary>
                <band height="43">
                        <subreport>
                                <reportElement uuid="0cc07e30-0a52-4545-b963-c91c8820bd36" x="0" y="23" width="555" height="20"/>
                                <subreportParameter name="SUBREPORT_DIR">
                                        <subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportParameter name="SEQ_PESSOA_FISICA">
                                        <subreportParameterExpression><![CDATA[$P{SEQ_PESSOA_FISICA}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportParameter name="ANO">
                                        <subreportParameterExpression><![CDATA[$P{ANO}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportParameter name="IMAGEM_DIR">
                                        <subreportParameterExpression><![CDATA[$P{IMAGEM_DIR}]]></subreportParameterExpression>
                                </subreportParameter>
                                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorioCapacitacaoPorParticipante_sub_totalizador.jasper"]]></subreportExpression>
                        </subreport>
                </band>
        </summary>
</jasperReport>