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="Relatório de Acompanhamento do Servidor" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="a9bd3a8d-3d73-4ab7-8540-556997aa680b">
        <property name="ireport.zoom" value="1.5"/>
        <property name="ireport.x" value="0"/>
        <property name="ireport.y" value="181"/>
        <import value="br.gov.al.saude.framework.core.util.DocumentoUtils"/>
        <parameter name="pTipoSexo" class="java.lang.String">
                <defaultValueExpression><![CDATA[]]></defaultValueExpression>
        </parameter>
        <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
                <defaultValueExpression><![CDATA[""]]></defaultValueExpression>
        </parameter>
        <parameter name="IMAGE_DIR" class="java.lang.String" isForPrompting="false">
                <defaultValueExpression><![CDATA[""]]></defaultValueExpression>
        </parameter>
        <parameter name="pTipoEstadoCivil" class="java.lang.String"/>
        <parameter name="pCodGrauInstrucao" class="java.lang.Integer"/>
        <parameter name="pTipoSituacaoCadastral" class="java.lang.String"/>
        <parameter name="pTipoVinculo" class="java.lang.String"/>
        <parameter name="pCodFormaIngresso" class="java.lang.Integer"/>
        <parameter name="pCodSituacaoServidor" class="java.lang.Integer"/>
        <parameter name="pCargaHoraria" class="java.lang.Integer"/>
        <parameter name="pCodCargo" class="java.lang.Integer"/>
        <parameter name="pCodFuncao" class="java.lang.Integer"/>
        <parameter name="pCodEspecialidade" class="java.lang.Integer"/>
        <parameter name="pCodOrgaoOrigem" class="java.lang.Integer"/>
        <parameter name="pCodOrgaoLotacao" class="java.lang.Integer"/>
        <parameter name="pCodUnidadeExercicio" class="java.lang.Integer"/>
        <parameter name="pCodUnidadeLotacao" class="java.lang.Integer"/>
        <parameter name="pDataNascimentoInicial" class="java.util.Date"/>
        <parameter name="pDataNascimentoFinal" class="java.util.Date"/>
        <parameter name="pDataAdmissaoInicial" class="java.util.Date"/>
        <parameter name="pDataAdmissaoFinal" class="java.util.Date"/>
        <parameter name="pLocalizacaoArquivoNumeroCaixa" class="java.lang.String"/>
        <parameter name="pLocalizacaoArquivoNumeroPasta" class="java.lang.String"/>
        <parameter name="pLocalizacaoArquivoNumeroPrateleira" class="java.lang.Integer"/>
        <parameter name="pLocalizacaoArquivoLado" class="java.lang.String"/>
        <parameter name="pOrderColumn" class="java.lang.String">
                <defaultValueExpression><![CDATA["nome"]]></defaultValueExpression>
        </parameter>
        <parameter name="pOrderColumnLabel" class="java.lang.String"/>
        <queryString>
                <![CDATA[select * from sc_srv.fn_consulta_rel_acompanhamento_servidor(
                                $P{pTipoSexo},
                                $P{pTipoEstadoCivil},
                                $P{pCodGrauInstrucao},
                                $P{pTipoSituacaoCadastral},
                                $P{pTipoVinculo},
                                $P{pCodFormaIngresso},
                                $P{pCodSituacaoServidor},
                                $P{pCargaHoraria},
                                $P{pCodCargo},
                                $P{pCodFuncao},
                                $P{pCodEspecialidade},
                                $P{pCodOrgaoOrigem},
                                $P{pCodOrgaoLotacao},
                                $P{pCodUnidadeExercicio},
                                $P{pCodUnidadeLotacao},
                                $P{pDataNascimentoInicial},
                                $P{pDataNascimentoFinal},
                                $P{pDataAdmissaoInicial},
                                $P{pDataAdmissaoFinal},
                                $P{pLocalizacaoArquivoNumeroCaixa},
                                $P{pLocalizacaoArquivoNumeroPasta},
                                $P{pLocalizacaoArquivoNumeroPrateleira},
                                $P{pLocalizacaoArquivoLado},
                                $P{pOrderColumn}) order by campo, nome;]]>
        </queryString>
        <field name="cpf" class="java.lang.String"/>
        <field name="nome" class="java.lang.String"/>
        <field name="campo" class="java.lang.String"/>
        <variable name="totalRegistrosPorGrupo" class="java.lang.Integer" resetType="Group" resetGroup="Agrupamento" calculation="Count">
                <variableExpression><![CDATA[$F{cpf}]]></variableExpression>
                <initialValueExpression><![CDATA[0]]></initialValueExpression>
        </variable>
        <group name="parametros">
                <groupExpression><![CDATA["1"]]></groupExpression>
                <groupHeader>
                        <band height="39">
                                <rectangle>
                                        <reportElement uuid="423b9a10-6789-4023-9a4d-1cd8ecd4119f" x="0" y="0" width="802" height="15" backcolor="#CCCCCC"/>
                                </rectangle>
                                <staticText>
                                        <reportElement uuid="e8828b4d-8b34-47f1-8d10-88e65996eaf8" x="0" y="0" width="802" height="15"/>
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                <font fontName="Arial" size="8" isBold="true"/>
                                        </textElement>
                                        <text><![CDATA[PARÂMETROS]]></text>
                                </staticText>
                                <subreport>
                                        <reportElement uuid="b6189364-0d99-4f2a-9073-24e0266397c8" positionType="Float" stretchType="RelativeToTallestObject" x="0" y="15" width="802" height="15"/>
                                        <subreportParameter name="pCodFuncao">
                                                <subreportParameterExpression><![CDATA[$P{pCodFuncao}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <subreportParameter name="pCodSituacaoServidor">
                                                <subreportParameterExpression><![CDATA[$P{pCodSituacaoServidor}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <subreportParameter name="pCodEspecialidade">
                                                <subreportParameterExpression><![CDATA[$P{pCodEspecialidade}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <subreportParameter name="pLocalizacaoArquivoLado">
                                                <subreportParameterExpression><![CDATA[$P{pLocalizacaoArquivoLado}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <subreportParameter name="pCodGrauInstrucao">
                                                <subreportParameterExpression><![CDATA[$P{pCodGrauInstrucao}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <subreportParameter name="pLocalizacaoArquivoNumeroCaixa">
                                                <subreportParameterExpression><![CDATA[$P{pLocalizacaoArquivoNumeroCaixa}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <subreportParameter name="pCodFormaIngresso">
                                                <subreportParameterExpression><![CDATA[$P{pCodFormaIngresso}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <subreportParameter name="pTipoVinculo">
                                                <subreportParameterExpression><![CDATA[$P{pTipoVinculo}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <subreportParameter name="pLocalizacaoArquivoNumeroPasta">
                                                <subreportParameterExpression><![CDATA[$P{pLocalizacaoArquivoNumeroPasta}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <subreportParameter name="pCodUnidadeExercicio">
                                                <subreportParameterExpression><![CDATA[$P{pCodUnidadeExercicio}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <subreportParameter name="pTipoSituacaoCadastral">
                                                <subreportParameterExpression><![CDATA[$P{pTipoSituacaoCadastral}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <subreportParameter name="pCodOrgaoLotacao">
                                                <subreportParameterExpression><![CDATA[$P{pCodOrgaoLotacao}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <subreportParameter name="pCodCargo">
                                                <subreportParameterExpression><![CDATA[$P{pCodCargo}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <subreportParameter name="pTipoSexo">
                                                <subreportParameterExpression><![CDATA[$P{pTipoSexo}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <subreportParameter name="pCodUnidadeLotacao">
                                                <subreportParameterExpression><![CDATA[$P{pCodUnidadeLotacao}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <subreportParameter name="pCodOrgaoOrigem">
                                                <subreportParameterExpression><![CDATA[$P{pCodOrgaoOrigem}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <subreportParameter name="pCargaHoraria">
                                                <subreportParameterExpression><![CDATA[$P{pCargaHoraria}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <subreportParameter name="pDataAdmissaoInicial">
                                                <subreportParameterExpression><![CDATA[$P{pDataAdmissaoInicial}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <subreportParameter name="pDataAdmissaoFinal">
                                                <subreportParameterExpression><![CDATA[$P{pDataAdmissaoFinal}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <subreportParameter name="pLocalizacaoArquivoNumeroPrateleira">
                                                <subreportParameterExpression><![CDATA[$P{pLocalizacaoArquivoNumeroPrateleira}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <subreportParameter name="pDataNascimentoInicial">
                                                <subreportParameterExpression><![CDATA[$P{pDataNascimentoInicial}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <subreportParameter name="pTipoEstadoCivil">
                                                <subreportParameterExpression><![CDATA[$P{pTipoEstadoCivil}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <subreportParameter name="pDataNascimentoFinal">
                                                <subreportParameterExpression><![CDATA[$P{pDataNascimentoFinal}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                        <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorio_acompanhamento_servidor_subreport_parametros.jasper"]]></subreportExpression>
                                </subreport>
                                <rectangle>
                                        <reportElement uuid="423b9a10-6789-4023-9a4d-1cd8ecd4119f" positionType="Float" stretchType="RelativeToTallestObject" mode="Transparent" x="0" y="0" width="802" height="30" backcolor="#CCCCCC"/>
                                </rectangle>
                        </band>
                </groupHeader>
        </group>
        <group name="Agrupamento" isReprintHeaderOnEachPage="true">
                <groupExpression><![CDATA[!"nome".equals($P{pOrderColumn})? $F{campo} : "1"]]></groupExpression>
                <groupHeader>
                        <band height="28">
                                <printWhenExpression><![CDATA[!"nome".equals($P{pOrderColumn})]]></printWhenExpression>
                                <rectangle>
                                        <reportElement uuid="2548ecb3-eeab-4cbe-9345-f50e8fb25f14" x="0" y="11" width="802" height="17" backcolor="#CCCCCC"/>
                                </rectangle>
                                <textField isBlankWhenNull="true">
                                        <reportElement uuid="af7f3ad7-484f-4647-95e3-915cb36411ff" x="0" y="11" width="802" height="17"/>
                                        <textElement verticalAlignment="Middle">
                                                <font size="10" isBold="true"/>
                                                <paragraph leftIndent="5"/>
                                        </textElement>
                                        <textFieldExpression><![CDATA[$P{pOrderColumnLabel} + ": " + ($F{campo} != null? $F{campo} : "NÃO INFORMADO")]]></textFieldExpression>
                                </textField>
                        </band>
                </groupHeader>
                <groupFooter>
                        <band height="16">
                                <rectangle>
                                        <reportElement uuid="97f01493-c39f-4e3a-9aaf-9ef690951ea8" positionType="Float" x="0" y="0" width="802" height="16" backcolor="#FFFFFF"/>
                                </rectangle>
                                <textField>
                                        <reportElement uuid="45faee71-4e4d-4ad6-a9ea-6db559b9fd86" x="418" y="0" width="384" height="16"/>
                                        <textElement textAlignment="Right" verticalAlignment="Middle">
                                                <font size="8" isBold="true"/>
                                                <paragraph rightIndent="2"/>
                                        </textElement>
                                        <textFieldExpression><![CDATA["QUANTIDADE DE SERVIDORES: " + $V{totalRegistrosPorGrupo}]]></textFieldExpression>
                                </textField>
                        </band>
                </groupFooter>
        </group>
        <group name="cabecalho" isReprintHeaderOnEachPage="true">
                <groupExpression><![CDATA["1"]]></groupExpression>
                <groupHeader>
                        <band height="30">
                                <rectangle>
                                        <reportElement uuid="97f01493-c39f-4e3a-9aaf-9ef690951ea8" positionType="Float" x="155" y="15" width="647" height="15" backcolor="#CCCCCC"/>
                                </rectangle>
                                <rectangle>
                                        <reportElement uuid="97f01493-c39f-4e3a-9aaf-9ef690951ea8" positionType="Float" x="0" y="15" width="155" height="15" backcolor="#CCCCCC"/>
                                </rectangle>
                                <staticText>
                                        <reportElement uuid="e8828b4d-8b34-47f1-8d10-88e65996eaf8" positionType="Float" x="155" y="15" width="520" height="15" isPrintWhenDetailOverflows="true"/>
                                        <textElement verticalAlignment="Middle">
                                                <font fontName="Arial" size="8"/>
                                                <paragraph leftIndent="5"/>
                                        </textElement>
                                        <text><![CDATA[NOME]]></text>
                                </staticText>
                                <staticText>
                                        <reportElement uuid="e8828b4d-8b34-47f1-8d10-88e65996eaf8" positionType="Float" x="0" y="15" width="155" height="15" isPrintWhenDetailOverflows="true"/>
                                        <textElement verticalAlignment="Middle">
                                                <font fontName="Arial" size="8"/>
                                                <paragraph leftIndent="5"/>
                                        </textElement>
                                        <text><![CDATA[CPF]]></text>
                                </staticText>
                                <rectangle>
                                        <reportElement uuid="97f01493-c39f-4e3a-9aaf-9ef690951ea8" positionType="Float" x="0" y="0" width="802" height="15" backcolor="#CCCCCC"/>
                                </rectangle>
                                <staticText>
                                        <reportElement uuid="e8828b4d-8b34-47f1-8d10-88e65996eaf8" positionType="Float" x="0" y="0" width="802" height="15" isPrintWhenDetailOverflows="true"/>
                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                <font fontName="Arial" size="8" isBold="true"/>
                                        </textElement>
                                        <text><![CDATA[SERVIDORES]]></text>
                                </staticText>
                        </band>
                </groupHeader>
        </group>
        <background>
                <band splitType="Stretch"/>
        </background>
        <pageHeader>
                <band height="111">
                        <staticText>
                                <reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="252" y="62" width="298" height="39" isPrintWhenDetailOverflows="true"/>
                                <textElement textAlignment="Center" verticalAlignment="Top">
                                        <font fontName="Arial" size="10" isBold="true"/>
                                </textElement>
                                <text><![CDATA[ESTADO DE ALAGOAS
SECRETARIA DE ESTADO DA SAÚDE DE ALAGOAS
RELATÓRIO DE ACOMPANHAMENTO DO SERVIDOR]]></text>
                        </staticText>
                        <image hAlign="Right">
                                <reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" x="380" y="0" width="48" height="59" isPrintWhenDetailOverflows="true"/>
                                <imageExpression><![CDATA[$P{IMAGE_DIR} + "brasao.jpg"]]></imageExpression>
                        </image>
                </band>
        </pageHeader>
        <detail>
                <band height="15">
                        <rectangle>
                                <reportElement uuid="97f01493-c39f-4e3a-9aaf-9ef690951ea8" positionType="Float" x="0" y="0" width="155" height="15" backcolor="#FFFFFF"/>
                        </rectangle>
                        <rectangle>
                                <reportElement uuid="97f01493-c39f-4e3a-9aaf-9ef690951ea8" positionType="Float" x="155" y="0" width="647" height="15" backcolor="#FFFFFF"/>
                        </rectangle>
                        <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                                <reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" x="0" y="0" width="155" height="15" isPrintWhenDetailOverflows="true"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="8" isBold="true"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <textFieldExpression><![CDATA[br.gov.al.saude.framework.core.util.DocumentoUtils.adicionarMascaraCpf($F{cpf})]]></textFieldExpression>
                        </textField>
                        <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                                <reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" x="155" y="0" width="647" height="15" isPrintWhenDetailOverflows="true"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="8" isBold="true"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{nome}]]></textFieldExpression>
                        </textField>
                </band>
        </detail>
        <pageFooter>
                <band height="30">
                        <textField evaluationTime="Report" isBlankWhenNull="false">
                                <reportElement uuid="506b9991-ff6d-43b5-ab78-2832586c3dda" key="textField" x="750" y="10" width="52" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6" isBold="false"/>
                                </textElement>
                                <textFieldExpression><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
                        </textField>
                        <textField isBlankWhenNull="false">
                                <reportElement uuid="e5f06c72-11c0-479b-b234-4dcaf2bc0440" key="textField" x="675" y="10" 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 isBlankWhenNull="true">
                                <reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="0" y="10" width="266" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6" isBold="false"/>
                                </textElement>
                                <textFieldExpression><![CDATA[new java.text.SimpleDateFormat("'Gerado em ' dd 'de' MMMMM 'de' yyyy ' às ' HH:mm", new Locale("pt", "BR")).format(new java.util.Date()).toUpperCase()]]></textFieldExpression>
                        </textField>
                </band>
        </pageFooter>
        <summary>
                <band height="18">
                        <printWhenExpression><![CDATA["nome".equals($P{pOrderColumn})]]></printWhenExpression>
                </band>
        </summary>
</jasperReport>