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_faltas" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="10e6462f-b0a2-406d-9d69-bee3c0361a4e"><property name="ireport.zoom" value="2.8531167061100056"/><property name="ireport.x" value="0"/><property name="ireport.y" value="354"/><parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false"><defaultValueExpression><![CDATA[""]]></defaultValueExpression></parameter><parameter name="IMAGEM_DIR" class="java.lang.String"><defaultValueExpression><![CDATA["C:\\"]]></defaultValueExpression></parameter><parameter name="pNomeUsuario" class="java.lang.String"/><parameter name="pCpfUsuario" class="java.lang.String"/><parameter name="pMatriculaServidor" class="java.lang.Long"/><parameter name="pAnoCronograma" class="java.lang.Long"/><parameter name="pCodigoUnidadeExercicio" class="java.lang.Long"/><queryString><![CDATA[SELECT (SELECT u.dsc_unidade FROM sc_srv.vw_unidade u WHERE u.cod_unidade = vsd.cod_unidade_exercicio) AS UNIDADE_EXERCICIO,ws.nom_pessoa AS NOME_SERVIDOR,ws.num_cpf AS CPF_SERVIDOR,(vsd.num_matricula_servidor || '-' || vsd.num_digito_matricula) AS NUMERO_MATRICULA,COALESCE(MAX(falta_servidor.MES_01), 0) AS JANEIRO,COALESCE(MAX(falta_servidor.MES_02), 0) AS FEVEREIRO,COALESCE(MAX(falta_servidor.MES_03), 0) AS MARCO,COALESCE(MAX(falta_servidor.MES_04), 0) AS ABRIL,COALESCE(MAX(falta_servidor.MES_05), 0) AS MAIO,COALESCE(MAX(falta_servidor.MES_06), 0) AS JUNHO,COALESCE(MAX(falta_servidor.MES_07), 0) AS JULHO,COALESCE(MAX(falta_servidor.MES_08), 0) AS AGOSTO,COALESCE(MAX(falta_servidor.MES_09), 0) AS SETEMBRO,COALESCE(MAX(falta_servidor.MES_10), 0) AS OUTUBRO,COALESCE(MAX(falta_servidor.MES_11), 0) AS NOVEMBRO,COALESCE(MAX(falta_servidor.MES_12), 0) AS DEZEMBRO,COALESCE(SUM(NUM_FALTA_ANO), 0) AS TOTAL_FALTA_ANOFROM sc_srv.vw_servidor_dadofuncional vsdINNER JOIN sc_srv.vw_servidor ws ON (vsd.seq_pessoa_servidor = ws.seq_pessoa_servidor)INNER JOIN sc_rhd.rhd_servidor_avaliacao rsa ON (rsa.seq_servidor_dadofuncional = vsd.seq_servidor_dadofuncional)LEFT JOIN(SELECT vsdf.num_matricula_servidor,(CASE WHEN rsf.num_mes = 1 THEN SUM(rsf.qtd_falta) ELSE 0 END) AS MES_01,(CASE WHEN rsf.num_mes = 2 THEN SUM(rsf.qtd_falta) ELSE 0 END) AS MES_02,(CASE WHEN rsf.num_mes = 3 THEN SUM(rsf.qtd_falta) ELSE 0 END) AS MES_03,(CASE WHEN rsf.num_mes = 4 THEN SUM(rsf.qtd_falta) ELSE 0 END) AS MES_04,(CASE WHEN rsf.num_mes = 5 THEN SUM(rsf.qtd_falta) ELSE 0 END) AS MES_05,(CASE WHEN rsf.num_mes = 6 THEN SUM(rsf.qtd_falta) ELSE 0 END) AS MES_06,(CASE WHEN rsf.num_mes = 7 THEN SUM(rsf.qtd_falta) ELSE 0 END) AS MES_07,(CASE WHEN rsf.num_mes = 8 THEN SUM(rsf.qtd_falta) ELSE 0 END) AS MES_08,(CASE WHEN rsf.num_mes = 9 THEN SUM(rsf.qtd_falta) ELSE 0 END) AS MES_09,(CASE WHEN rsf.num_mes = 10 THEN SUM(rsf.qtd_falta) ELSE 0 END) AS MES_10,(CASE WHEN rsf.num_mes = 11 THEN SUM(rsf.qtd_falta) ELSE 0 END) AS MES_11,(CASE WHEN rsf.num_mes = 12 THEN SUM(rsf.qtd_falta) ELSE 0 END) AS MES_12,SUM(qtd_falta) AS NUM_FALTA_ANOFROM sc_srv.vw_servidor_dadofuncional vsdfINNER JOIN sc_rhd.rhd_servidor_falta rsf ON (rsf.seq_servidor_dadofuncional = vsdf.seq_servidor_dadofuncional)WHERE rsf.num_ano = $P{pAnoCronograma}GROUP BY vsdf.num_matricula_servidor,rsf.num_mes) falta_servidor ON (falta_servidor.num_matricula_servidor = vsd.num_matricula_servidor)WHERE rsa.num_ano = $P{pAnoCronograma}AND (vsd.cod_unidade_exercicio = $P{pCodigoUnidadeExercicio} OR $P{pCodigoUnidadeExercicio} IS NULL)AND (vsd.num_matricula_servidor = $P{pMatriculaServidor} OR $P{pMatriculaServidor} IS NULL) GROUP BY UNIDADE_EXERCICIO,NOME_SERVIDOR,CPF_SERVIDOR,NUMERO_MATRICULAORDER BY UNIDADE_EXERCICIO,NOME_SERVIDOR]]></queryString><field name="unidade_exercicio" class="java.lang.String"/><field name="nome_servidor" class="java.lang.String"/><field name="cpf_servidor" class="java.lang.String"/><field name="numero_matricula" class="java.lang.String"/><field name="janeiro" class="java.math.BigDecimal"/><field name="fevereiro" class="java.math.BigDecimal"/><field name="marco" class="java.math.BigDecimal"/><field name="abril" class="java.math.BigDecimal"/><field name="maio" class="java.math.BigDecimal"/><field name="junho" class="java.math.BigDecimal"/><field name="julho" class="java.math.BigDecimal"/><field name="agosto" class="java.math.BigDecimal"/><field name="setembro" class="java.math.BigDecimal"/><field name="outubro" class="java.math.BigDecimal"/><field name="novembro" class="java.math.BigDecimal"/><field name="dezembro" class="java.math.BigDecimal"/><field name="total_falta_ano" class="java.math.BigDecimal"/><group name="groupCronograma"><groupExpression><![CDATA[]]></groupExpression></group><group name="group"><groupExpression><![CDATA[$F{unidade_exercicio}]]></groupExpression><groupHeader><band height="33"><textField isStretchWithOverflow="true"><reportElement uuid="1b7ae11b-d3df-4108-8e29-221b7e53a9d4" x="0" y="7" width="555" height="20"/><textElement verticalAlignment="Bottom"><font fontName="Arial" size="12" isBold="true" isUnderline="true" pdfFontName="Helvetica-Bold"/></textElement><textFieldExpression><![CDATA["UNIDADE: " + $F{unidade_exercicio}]]></textFieldExpression></textField></band></groupHeader></group><group name="groupServidor"><groupExpression><![CDATA[$F{numero_matricula}]]></groupExpression><groupHeader><band height="18"><rectangle><reportElement uuid="929d9137-2979-443b-a76d-d93458dbea93" x="0" y="2" width="555" height="14" forecolor="#DCDCDC" backcolor="#DCDCDC"/><graphicElement><pen lineWidth="0.0"/></graphicElement></rectangle><textField><reportElement uuid="8c9e7a92-d83d-4c81-b766-e9a4bd04d45c" x="34" y="2" width="255" height="14"/><textElement verticalAlignment="Middle"><font fontName="Arial" size="8" isBold="true"/></textElement><textFieldExpression><![CDATA[$F{nome_servidor}]]></textFieldExpression></textField><staticText><reportElement uuid="adae7f8f-0817-4705-a460-468877d15149" x="3" y="2" width="30" height="14"/><textElement textAlignment="Right" verticalAlignment="Middle"><font fontName="Arial" size="8" isBold="true"/></textElement><text><![CDATA[Nome:]]></text></staticText><staticText><reportElement uuid="81850e19-8f8a-4e07-97f2-7bb034d4f33c" x="448" y="2" width="21" height="14"/><textElement textAlignment="Right" verticalAlignment="Middle"><font fontName="Arial" size="8" isBold="true"/></textElement><text><![CDATA[CPF:]]></text></staticText><textField pattern="" isBlankWhenNull="true"><reportElement uuid="0fad1e92-1edb-48b9-81fd-a72739f06f2f" x="470" y="2" width="80" height="14"/><textElement verticalAlignment="Middle"><font fontName="Arial" size="8" isBold="true"/></textElement><textFieldExpression><![CDATA[($F{cpf_servidor} == null)? null : (($F{cpf_servidor}.trim().length() == 11)? $F{cpf_servidor}.trim().replaceAll("(\\d{3})(\\d{3})(\\d{3})(\\d{2})", "$1.$2.$3-$4") : $F{cpf_servidor})]]></textFieldExpression></textField><textField><reportElement uuid="4c6c0c07-6b3e-4497-acaf-1bf017cfd7fc" x="353" y="2" width="66" height="14"/><textElement verticalAlignment="Middle"><font fontName="Arial" size="8" isBold="true"/></textElement><textFieldExpression><![CDATA[$F{numero_matricula}]]></textFieldExpression></textField><staticText><reportElement uuid="972dba30-0b61-4516-831d-dfabb64e7eab" x="310" y="2" width="42" height="14"/><textElement textAlignment="Right" verticalAlignment="Middle"><font fontName="Arial" size="8" isBold="true"/></textElement><text><![CDATA[Matrícula:]]></text></staticText></band></groupHeader></group><background><band splitType="Stretch"/></background><title><band height="145" splitType="Stretch"><staticText><reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="69" width="555" height="26"/><textElement textAlignment="Center"><font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="false"/></textElement><text><![CDATA[ESTADO DE ALAGOASSECRETARIA DE ESTADO DA SAÚDE DE ALAGOAS]]></text></staticText><staticText><reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="104" width="555" height="16" isPrintWhenDetailOverflows="true"/><textElement textAlignment="Center" verticalAlignment="Top"><font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="false"/></textElement><text><![CDATA[RELATÓRIO DE FALTAS]]></text></staticText><textField isBlankWhenNull="false"><reportElement uuid="7e420030-8524-414a-9258-b8ff749fc009" x="0" y="125" width="555" height="15"/><textElement textAlignment="Center"><font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="false"/></textElement><textFieldExpression><![CDATA["CRONOGRAMA: " + $P{pAnoCronograma}]]></textFieldExpression></textField><image hAlign="Right"><reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" x="259" y="1" width="48" height="59"/><imageExpression><![CDATA[$P{IMAGEM_DIR} + "brasao.jpg"]]></imageExpression></image></band></title><detail><band height="56" splitType="Stretch"><textField isBlankWhenNull="false"><reportElement uuid="a8119919-a812-473e-a157-651fbac5a34e" x="0" y="17" width="46" height="13"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="8"/></textElement><textFieldExpression><![CDATA[$F{janeiro}]]></textFieldExpression></textField><textField isBlankWhenNull="false"><reportElement uuid="864ee6fc-9c11-4dce-8880-1d31ac2912da" x="46" y="17" width="46" height="14"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="8"/></textElement><textFieldExpression><![CDATA[$F{fevereiro}]]></textFieldExpression></textField><textField isBlankWhenNull="false"><reportElement uuid="d33f0f9d-c1f5-470f-a0fd-bf3eeb7dc936" x="92" y="17" width="46" height="14"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="8"/></textElement><textFieldExpression><![CDATA[$F{marco}]]></textFieldExpression></textField><textField isBlankWhenNull="false"><reportElement uuid="d6772f9a-f998-41bf-91ea-cc7fc9587945" x="138" y="17" width="46" height="14"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="8"/></textElement><textFieldExpression><![CDATA[$F{abril}]]></textFieldExpression></textField><textField isBlankWhenNull="false"><reportElement uuid="109b7897-10d7-48bc-8228-6d2d56d3d1c0" x="231" y="17" width="46" height="14"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="8"/></textElement><textFieldExpression><![CDATA[$F{junho}]]></textFieldExpression></textField><textField isBlankWhenNull="false"><reportElement uuid="2ad275a3-7ce6-4689-9371-84fb1791e6ec" x="323" y="17" width="46" height="14"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="8"/></textElement><textFieldExpression><![CDATA[$F{agosto}]]></textFieldExpression></textField><textField isBlankWhenNull="false"><reportElement uuid="23c6db54-33fe-466c-bee5-78c321f87786" x="369" y="17" width="46" height="14"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="8"/></textElement><textFieldExpression><![CDATA[$F{setembro}]]></textFieldExpression></textField><textField isBlankWhenNull="false"><reportElement uuid="02f8d5ca-a2c7-423f-8387-17f14a38785f" x="415" y="17" width="46" height="14"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="8"/></textElement><textFieldExpression><![CDATA[$F{outubro}]]></textFieldExpression></textField><line><reportElement uuid="ce3f9236-679b-49fe-a99c-f56cbfd5e945" x="-1" y="1" width="555" height="1"/><graphicElement><pen lineWidth="0.5" lineStyle="Solid"/></graphicElement></line><line><reportElement uuid="ce3f9236-679b-49fe-a99c-f56cbfd5e945" x="-1" y="1" width="1" height="29"/><graphicElement><pen lineWidth="0.5" lineStyle="Solid"/></graphicElement></line><textField isBlankWhenNull="false"><reportElement uuid="a1102701-9793-4a80-a7a8-bbe08fd9bc62" x="507" y="17" width="46" height="14"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="8"/></textElement><textFieldExpression><![CDATA[$F{dezembro}]]></textFieldExpression></textField><textField isBlankWhenNull="false"><reportElement uuid="17ca6aca-39b4-4826-ad51-c31d05d4e829" x="461" y="17" width="46" height="14"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="8"/></textElement><textFieldExpression><![CDATA[$F{novembro}]]></textFieldExpression></textField><textField isBlankWhenNull="false"><reportElement uuid="5fcbb678-9e7f-4775-8066-333efa4f17b6" x="277" y="17" width="46" height="14"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="8"/></textElement><textFieldExpression><![CDATA[$F{julho}]]></textFieldExpression></textField><textField isBlankWhenNull="false"><reportElement uuid="04cdfa06-9a65-4902-91b8-69d7f9b93af1" x="185" y="17" width="46" height="14"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="8"/></textElement><textFieldExpression><![CDATA[$F{maio}]]></textFieldExpression></textField><line><reportElement uuid="ce3f9236-679b-49fe-a99c-f56cbfd5e945" x="-1" y="30" width="555" height="1"/><graphicElement><pen lineWidth="0.5" lineStyle="Solid"/></graphicElement></line><line><reportElement uuid="ce3f9236-679b-49fe-a99c-f56cbfd5e945" x="-1" y="16" width="555" height="1"/><graphicElement><pen lineWidth="0.5" lineStyle="Solid"/></graphicElement></line><staticText><reportElement uuid="dc80aa22-c7db-4868-9c0b-ee330389d413" x="0" y="2" width="46" height="14"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="8"/></textElement><text><![CDATA[JAN]]></text></staticText><staticText><reportElement uuid="a068fd3c-00ea-453c-8114-55eb62aefa34" x="46" y="2" width="46" height="14"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="8"/></textElement><text><![CDATA[FEV]]></text></staticText><staticText><reportElement uuid="9f53e1b2-492b-4710-aad0-1b648344749c" x="92" y="2" width="46" height="14"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="8"/></textElement><text><![CDATA[MAR]]></text></staticText><staticText><reportElement uuid="cf106f5c-0295-47c0-837d-9945001c5c2f" x="138" y="2" width="46" height="14"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="8"/></textElement><text><![CDATA[ABR]]></text></staticText><staticText><reportElement uuid="d7f21695-04da-4df3-8c66-e37cf533dab4" x="184" y="2" width="46" height="14"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="8"/></textElement><text><![CDATA[MAI]]></text></staticText><staticText><reportElement uuid="705b39dd-cda3-4d1e-9e33-90b81ae02ba1" x="231" y="2" width="46" height="14"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="8"/></textElement><text><![CDATA[JUN]]></text></staticText><staticText><reportElement uuid="6ce5646c-f68a-410a-bb91-e1b62d544199" x="277" y="2" width="46" height="14"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="8"/></textElement><text><![CDATA[JUL]]></text></staticText><staticText><reportElement uuid="114e96df-745c-4891-977d-e79f96b9ef4e" x="323" y="2" width="46" height="14"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="8"/></textElement><text><![CDATA[AGO]]></text></staticText><staticText><reportElement uuid="5a8d97de-e2b8-4413-ac19-5a0d5bd277f5" x="369" y="2" width="46" height="14"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="8"/></textElement><text><![CDATA[SET]]></text></staticText><staticText><reportElement uuid="e924b46c-899c-4fa9-9c76-0089d7e26921" x="415" y="2" width="46" height="14"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="8"/></textElement><text><![CDATA[OUT]]></text></staticText><staticText><reportElement uuid="da431fc3-299b-4dfe-8294-b9171d7ad22e" x="461" y="2" width="46" height="14"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="8"/></textElement><text><![CDATA[NOV]]></text></staticText><staticText><reportElement uuid="156edd30-f933-4e9c-9c9e-d9382a3b0bc9" x="507" y="2" width="46" height="14"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="8"/></textElement><text><![CDATA[DEZ]]></text></staticText><staticText><reportElement uuid="fc69e67e-3889-4564-80cd-e2527e5ee245" x="-1" y="34" width="127" height="15"/><textElement textAlignment="Right"><font fontName="Arial" isBold="true"/></textElement><text><![CDATA[Total de Faltas no Ano:]]></text></staticText><textField><reportElement uuid="e84e4376-7e16-4ed4-892c-fc9838a630a9" x="128" y="34" width="100" height="15"/><textElement><font fontName="Arial"/></textElement><textFieldExpression><![CDATA[$F{total_falta_ano}]]></textFieldExpression></textField><line><reportElement uuid="ce3f9236-679b-49fe-a99c-f56cbfd5e945" x="553" y="1" width="1" height="29"/><graphicElement><pen lineWidth="0.5" lineStyle="Solid"/></graphicElement></line></band></detail><pageFooter><band height="20" splitType="Stretch"><textField evaluationTime="Report" isBlankWhenNull="false"><reportElement uuid="506b9991-ff6d-43b5-ab78-2832586c3dda" key="textField" x="499" y="3" 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="424" y="3" 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="3" width="374" height="15"/><textElement verticalAlignment="Middle"><font fontName="Arial" size="6" isBold="false"/></textElement><textFieldExpression><![CDATA["Gerado por " + $P{pNomeUsuario} + ", CPF: " + $P{pCpfUsuario} + 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></band></pageFooter></jasperReport>