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" whenNoDataType="NoDataSection" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="85d4a540-608e-4934-8f57-57cec53afb74">
        <property name="ireport.zoom" value="1.5"/>
        <property name="ireport.x" value="73"/>
        <property name="ireport.y" value="1261"/>
        <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="ANO" class="java.lang.Integer">
                <defaultValueExpression><![CDATA[]]></defaultValueExpression>
        </parameter>
        <queryString>
                <![CDATA[SELECT
tr.num_ano,
tr.seq_turma,
tp.seq_turma_participante,
pw.nom_pessoa,
cp.seq_capacitacao,
cp.dsc_capacitacao,
COUNT(tp.seq_turma_participante) as qtd_faltas
FROM sc_scs.scs_turma tr
INNER JOIN sc_scs.scs_turma_participante tp ON tr.seq_turma = tp.seq_turma
INNER JOIN sc_scg.vw_pessoa_fisica pw ON tp.seq_pessoa_participante = pw.seq_pessoa
INNER JOIN sc_scs.scs_capacitacao cp ON tr.seq_capacitacao = cp.seq_capacitacao
INNER JOIN sc_scs.scs_frequencia fr ON tr.seq_turma = fr.seq_turma
INNER JOIN sc_scs.scs_presenca ps ON tp.seq_turma_participante = ps.seq_turma_participante
AND ps.seq_frequencia = fr.seq_frequencia
WHERE fr.ind_validado = TRUE
AND ps.ind_presenca = FALSE
AND tr.num_ano = $P{ANO}
GROUP BY tr.num_ano, tp.seq_turma_participante, pw.nom_pessoa, cp.seq_capacitacao, cp.dsc_capacitacao, tr.seq_turma
ORDER BY cp.dsc_capacitacao, pw.nom_pessoa]]>
        </queryString>
        <field name="num_ano" class="java.math.BigDecimal"/>
        <field name="seq_turma" class="java.lang.Long"/>
        <field name="seq_turma_participante" class="java.lang.Long"/>
        <field name="nom_pessoa" class="java.lang.String"/>
        <field name="seq_capacitacao" class="java.lang.Long"/>
        <field name="dsc_capacitacao" class="java.lang.String"/>
        <field name="qtd_faltas" class="java.lang.Long"/>
        <group name="Capacitacao" isReprintHeaderOnEachPage="true">
                <groupExpression><![CDATA[$F{dsc_capacitacao}]]></groupExpression>
                <groupHeader>
                        <band height="68">
                                <elementGroup>
                                        <rectangle>
                                                <reportElement uuid="1ce4fd6f-836f-4005-96f5-d0a9bf065420" x="0" y="8" width="403" height="20" backcolor="#CCCCCC"/>
                                        </rectangle>
                                        <staticText>
                                                <reportElement uuid="cd5b1a6e-c479-428f-ac03-5ad82545cd5a" x="0" y="8" width="403" 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="1ce4fd6f-836f-4005-96f5-d0a9bf065420" mode="Transparent" x="0" y="28" width="403" height="20" backcolor="#CCCCCC"/>
                                        </rectangle>
                                        <textField>
                                                <reportElement uuid="ae85f1f3-ed48-42f9-b88e-aad031c18f0c" x="0" y="28" width="403" height="20"/>
                                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                                        <font fontName="Arial"/>
                                                </textElement>
                                                <textFieldExpression><![CDATA[$F{dsc_capacitacao}]]></textFieldExpression>
                                        </textField>
                                        <rectangle>
                                                <reportElement uuid="1ce4fd6f-836f-4005-96f5-d0a9bf065420" x="0" y="48" width="403" height="20" backcolor="#CCCCCC"/>
                                        </rectangle>
                                        <staticText>
                                                <reportElement uuid="cd5b1a6e-c479-428f-ac03-5ad82545cd5a" x="0" y="48" width="403" height="20" isPrintWhenDetailOverflows="true"/>
                                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                                        <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                                </textElement>
                                                <text><![CDATA[PARTICIPANTES]]></text>
                                        </staticText>
                                        <rectangle>
                                                <reportElement uuid="1ce4fd6f-836f-4005-96f5-d0a9bf065420" x="403" y="48" width="152" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
                                        </rectangle>
                                        <staticText>
                                                <reportElement uuid="cd5b1a6e-c479-428f-ac03-5ad82545cd5a" x="403" y="48" width="151" height="20" isPrintWhenDetailOverflows="true"/>
                                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                                        <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                                </textElement>
                                                <text><![CDATA[QUANTIDADE DE FALTAS]]></text>
                                        </staticText>
                                        <rectangle>
                                                <reportElement uuid="1ce4fd6f-836f-4005-96f5-d0a9bf065420" x="403" y="8" width="152" height="20" backcolor="#CCCCCC"/>
                                        </rectangle>
                                        <rectangle>
                                                <reportElement uuid="1ce4fd6f-836f-4005-96f5-d0a9bf065420" mode="Opaque" x="403" y="28" width="152" height="20" backcolor="#FFFFFF"/>
                                        </rectangle>
                                        <staticText>
                                                <reportElement uuid="cd5b1a6e-c479-428f-ac03-5ad82545cd5a" mode="Transparent" x="403" y="8" width="151" height="20"/>
                                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                                        <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                                </textElement>
                                                <text><![CDATA[TURMA]]></text>
                                        </staticText>
                                        <textField>
                                                <reportElement uuid="a2231f3b-8e55-40d6-b970-2967e005a2a1" x="403" y="28" width="152" height="20"/>
                                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                                        <font fontName="Arial"/>
                                                </textElement>
                                                <textFieldExpression><![CDATA[$F{seq_turma}]]></textFieldExpression>
                                        </textField>
                                </elementGroup>
                        </band>
                </groupHeader>
        </group>
        <pageHeader>
                <band height="130">
                        <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 Faltantes]]></text>
                        </staticText>
                        <textField>
                                <reportElement uuid="db29e6fb-e831-48bb-a00b-1ead719928b1" x="0" y="104" width="555" height="12"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                </textElement>
                                <textFieldExpression><![CDATA["Ano de Exercício: " + $P{ANO}]]></textFieldExpression>
                        </textField>
                </band>
        </pageHeader>
        <detail>
                <band height="20">
                        <rectangle>
                                <reportElement uuid="1ce4fd6f-836f-4005-96f5-d0a9bf065420" mode="Transparent" x="403" y="0" width="152" height="20" backcolor="#CCCCCC"/>
                        </rectangle>
                        <rectangle>
                                <reportElement uuid="1ce4fd6f-836f-4005-96f5-d0a9bf065420" mode="Transparent" x="0" y="0" width="403" height="20" backcolor="#CCCCCC"/>
                        </rectangle>
                        <textField>
                                <reportElement uuid="8b920c02-2e1b-4b83-8985-55864d199982" x="0" y="0" width="403" height="20"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{nom_pessoa}]]></textFieldExpression>
                        </textField>
                        <textField>
                                <reportElement uuid="56b6e42d-1272-48a5-a912-8d1c46903eb6" x="403" y="0" width="151" height="20"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{qtd_faltas}]]></textFieldExpression>
                        </textField>
                </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>
        <noData>
                <band height="802">
                        <rectangle>
                                <reportElement uuid="1ce4fd6f-836f-4005-96f5-d0a9bf065420" x="0" y="130" width="555" height="20" backcolor="#CCCCCC"/>
                        </rectangle>
                        <staticText>
                                <reportElement uuid="cd5b1a6e-c479-428f-ac03-5ad82545cd5a" x="0" y="130" width="554" height="20"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                </textElement>
                                <text><![CDATA[NÃO EXISTEM PARTICIPANTES FALTANTES]]></text>
                        </staticText>
                        <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 Faltantes]]></text>
                        </staticText>
                        <textField>
                                <reportElement uuid="db29e6fb-e831-48bb-a00b-1ead719928b1" x="0" y="104" width="555" height="12"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
                                </textElement>
                                <textFieldExpression><![CDATA["Ano de Exercício: " + $P{ANO}]]></textFieldExpression>
                        </textField>
                        <textField isBlankWhenNull="true">
                                <reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="1" y="787" 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="482" y="787" width="73" height="15"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" size="6" isBold="false"/>
                                </textElement>
                                <textFieldExpression><![CDATA["PÁGINA 1 DE 1"]]></textFieldExpression>
                        </textField>
                </band>
        </noData>
</jasperReport>