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="certificado" printOrder="Horizontal" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="806" leftMargin="18" rightMargin="18" topMargin="16" bottomMargin="16" uuid="85d4a540-608e-4934-8f57-57cec53afb74"><property name="ireport.zoom" value="0.9313819845887333"/><property name="ireport.x" value="0"/><property name="ireport.y" value="563"/><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="SEQ_TURMA_PARTICIPANTE" class="java.lang.Long"><defaultValueExpression><![CDATA[]]></defaultValueExpression></parameter><queryString><![CDATA[SELECTUPPER(pes.nom_pessoa) as nom_pessoa,cap.dsc_capacitacao,(SELECT MIN(pi.dth_data_inicial) FROM sc_scs.scs_turma_periodo pi WHERE pi.seq_turma = tur.seq_turma) as dth_data_inicial,(SELECT MAX(pf.dth_data_final) FROM sc_scs.scs_turma_periodo pf WHERE pf.seq_turma = tur.seq_turma) as dth_data_final,tur.num_carga_horaria,mun.nom_municipio,tur.cod_uf,est.nom_uf,tur.dsc_ementa,per.dsc_perfil,nat.dsc_natureza,par.num_carga_horaria_especificaFROM sc_scs.scs_turma_participante parLEFT JOIN sc_scs.scs_turma tur ON par.seq_turma = tur.seq_turmaLEFT JOIN sc_scg.vw_pessoa_fisica pes ON par.seq_pessoa_participante = pes.seq_pessoaLEFT JOIN sc_scs.scs_capacitacao cap ON tur.seq_capacitacao = cap.seq_capacitacaoLEFT JOIN sc_scs.scs_natureza nat ON cap.seq_natureza = nat.seq_naturezaLEFT JOIN sc_scg.vw_uf est ON tur.cod_uf = est.cod_ufLEFT JOIN sc_scg.vw_municipio mun ON tur.seq_municipio=mun.seq_municipioLEFT JOIN sc_scs.scs_perfil per ON per.seq_perfil = par.seq_perfilWHERE par.seq_turma_participante = $P{SEQ_TURMA_PARTICIPANTE}]]></queryString><field name="nom_pessoa" class="java.lang.String"/><field name="dsc_capacitacao" class="java.lang.String"/><field name="dth_data_inicial" class="java.sql.Timestamp"/><field name="dth_data_final" class="java.sql.Timestamp"/><field name="num_carga_horaria" class="java.lang.Integer"/><field name="nom_municipio" class="java.lang.String"/><field name="cod_uf" class="java.lang.String"/><field name="nom_uf" class="java.lang.String"/><field name="dsc_ementa" class="java.lang.String"/><field name="dsc_perfil" class="java.lang.String"/><field name="dsc_natureza" class="java.lang.String"/><field name="num_carga_horaria_especifica" class="java.lang.Integer"/><detail><band height="563"><rectangle radius="10"><reportElement uuid="4411e7fa-fbb1-4ed5-bbee-f16a9e4e0165" x="14" y="15" width="775" height="526"/><graphicElement><pen lineWidth="1.75"/></graphicElement></rectangle><line><reportElement uuid="b7a2fcbd-50a3-445c-92d5-95f8d6c7632d" x="272" y="491" width="235" height="1"/></line><staticText><reportElement uuid="b353b05c-efe4-4071-9e4d-4192244a016b" x="282" y="494" width="228" height="20"/><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true"/></textElement><text><![CDATA[Robson José da Silva]]></text></staticText><line><reportElement uuid="795869f9-09f3-485f-b425-2d9d7e97383d" x="29" y="491" width="235" height="1"/></line><staticText><reportElement uuid="7e30ccc9-c513-4af8-b97f-82932bb54ffd" x="271" y="513" width="236" height="20"/><textElement textAlignment="Center" verticalAlignment="Top"><font size="8" isBold="false" pdfFontName="Helvetica" isPdfEmbedded="true"/></textElement><text><![CDATA[Coordenador Setorial de Gestão e Desenvolvimento de Pessoas]]></text></staticText><line><reportElement uuid="7462f635-35c0-46ab-a974-2eed1a8fae93" x="516" y="491" width="258" height="1"/></line><staticText><reportElement uuid="124a3123-9cf1-49d6-af7e-2fdc404c7b23" x="516" y="494" width="258" height="20"/><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true"/></textElement><text><![CDATA[Rozangela Maria de Almeida Fernandes Wyszomirska]]></text></staticText><staticText><reportElement uuid="ba716373-c9ef-4a84-bae1-40a9f32e4cdc" x="516" y="513" width="258" height="20"/><textElement textAlignment="Center" verticalAlignment="Top"><font size="8" isBold="false" pdfFontName="Helvetica" isPdfEmbedded="true"/></textElement><text><![CDATA[Secretária de Estado da Saúde de Alagoas]]></text></staticText><textField><reportElement uuid="f49a1067-a9b4-4367-8c3a-7db42e0ac529" x="14" y="195" width="775" height="191"/><textElement textAlignment="Justified" markup="styled"><font size="16" isBold="false"/><paragraph lineSpacing="1_1_2" leftIndent="20" rightIndent="20"/></textElement><textFieldExpression><![CDATA["Certificamos que "+ $F{nom_pessoa} + " participou como " + $F{dsc_perfil} + " do(a) " + $F{dsc_natureza} + " ''" + $F{dsc_capacitacao} + "''" +($F{num_carga_horaria_especifica} != null ? ", com " + $F{num_carga_horaria_especifica} + " horas/aulas" : $F{num_carga_horaria} != null ? ", com " + $F{num_carga_horaria} + " horas/aulas" : "") +(($F{cod_uf} != null && $F{nom_municipio} != null) ? ", realizado em " + $F{nom_municipio} + "-" + $F{cod_uf} : ($F{cod_uf} != null) ? ", realizado em " + $F{nom_uf} : "") +", no período de " + new java.text.SimpleDateFormat("dd/MM/yyyy", new Locale("pt", "BR")).format($F{dth_data_inicial}).toUpperCase()+" a "+ new java.text.SimpleDateFormat("dd/MM/yyyy", new Locale("pt", "BR")).format($F{dth_data_final}).toUpperCase()+"."]]></textFieldExpression></textField><staticText><reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="14" y="69" width="775" 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údeCoordenadoria Setorial de Gestão e Desenvolvimento de PessoasGerê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="382" y="21" width="33" height="36"/><imageExpression><![CDATA[$P{IMAGEM_DIR} + "brasao.png"]]></imageExpression></image><staticText><reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="14" y="58" width="775" 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="14" y="115" width="775" height="70"/><textElement textAlignment="Center" verticalAlignment="Middle"><font fontName="Arial" size="26" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/></textElement><text><![CDATA[Certificado]]></text></staticText><frame><reportElement uuid="185a40f9-4f6c-4a21-bbc3-30b0d17a2373" x="0" y="0" width="803" height="555"/><box><pen lineWidth="3.0"/><topPen lineWidth="3.0"/><leftPen lineWidth="3.0"/><bottomPen lineWidth="3.0"/><rightPen lineWidth="3.0"/></box></frame><textField><reportElement uuid="8747f474-fb8d-47e3-ba83-5a06398f148e" x="14" y="386" width="775" height="27"/><textElement textAlignment="Center"><font size="14"/></textElement><textFieldExpression><![CDATA["Maceió" + new java.text.SimpleDateFormat("', 'dd 'de' MMMMM 'de' yyyy", new Locale("pt", "BR")).format(new java.util.Date())]]></textFieldExpression></textField><image scaleImage="RealSize" hAlign="Center" vAlign="Bottom" onErrorType="Icon"><reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" positionType="Float" mode="Transparent" x="274" y="436" width="236" height="55"/><imageExpression><![CDATA[$P{IMAGEM_DIR} + "assinatura_coordenador.png"]]></imageExpression></image><image scaleImage="RealSize" hAlign="Center" vAlign="Bottom" onErrorType="Icon"><reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" positionType="Float" mode="Transparent" x="516" y="452" width="258" height="70"/><imageExpression><![CDATA[$P{IMAGEM_DIR} + "assina_secretario.png"]]></imageExpression></image></band><band height="563"><frame><reportElement uuid="185a40f9-4f6c-4a21-bbc3-30b0d17a2373" x="0" y="0" width="803" height="555"/><box><pen lineWidth="3.0"/><topPen lineWidth="3.0"/><leftPen lineWidth="3.0"/><bottomPen lineWidth="3.0"/><rightPen lineWidth="3.0"/></box><rectangle radius="10"><reportElement uuid="e1d0fb17-3251-437a-b095-8711c7470f41" x="14" y="15" width="775" height="526"/><graphicElement><pen lineWidth="1.75"/></graphicElement></rectangle><rectangle><reportElement uuid="b34de6d3-3fe0-41f9-b369-cec73b0a21c7" x="35" y="53" width="733" height="40"/><graphicElement><pen lineWidth="1.25"/></graphicElement></rectangle><rectangle><reportElement uuid="a9b8b5db-20db-45e1-a58e-7d91e7991f54" x="35" y="113" width="733" height="80"/><graphicElement><pen lineWidth="1.25"/></graphicElement></rectangle><rectangle><reportElement uuid="b3c75674-9760-4ed3-8dfc-5f401e4899d6" x="35" y="213" width="733" height="40"/><graphicElement><pen lineWidth="1.25"/></graphicElement></rectangle><rectangle><reportElement uuid="1e9f0da2-2abd-431a-a333-8978961684bc" x="35" y="253" width="733" height="179"/><graphicElement><pen lineWidth="1.25"/></graphicElement></rectangle><rectangle><reportElement uuid="fd954e28-0286-4ef1-b82c-728608ab9d6c" x="602" y="452" width="166" height="40"/><graphicElement><pen lineWidth="1.25"/></graphicElement></rectangle><rectangle><reportElement uuid="dc7393f5-e684-4841-b093-41c5b93d10da" x="395" y="452" width="207" height="40"/><graphicElement><pen lineWidth="1.25"/></graphicElement></rectangle><textField><reportElement uuid="75d78049-cf47-46e2-b93d-ecb1cb7d7d3a" x="35" y="53" width="733" height="40"/><textElement verticalAlignment="Middle" markup="styled"><font size="14" isBold="false"/><paragraph leftIndent="20" rightIndent="10"/></textElement><textFieldExpression><![CDATA["<style isBold='true'>Nome: </style>" + $F{nom_pessoa}]]></textFieldExpression></textField><textField><reportElement uuid="619d1fcf-f5bc-441c-9965-657e886145d8" x="35" y="113" width="733" height="40"/><textElement verticalAlignment="Middle" markup="styled"><font size="14"/><paragraph leftIndent="20"/></textElement><textFieldExpression><![CDATA["<style isBold='true'>Capacitação: </style>" +$F{dsc_capacitacao}]]></textFieldExpression></textField><textField><reportElement uuid="7762e76f-dadd-4110-bdfa-62181856bef8" x="35" y="156" width="733" height="40"/><textElement verticalAlignment="Top" markup="styled"><font size="14"/><paragraph leftIndent="20"/></textElement><textFieldExpression><![CDATA["<style isBold='true'>Período: </style>" + new java.text.SimpleDateFormat("dd/MM/yyyy", new Locale("pt", "BR")).format($F{dth_data_inicial}).toUpperCase()+" a "+ new java.text.SimpleDateFormat("dd/MM/yyyy", new Locale("pt", "BR")).format($F{dth_data_final}).toUpperCase()]]></textFieldExpression></textField><staticText><reportElement uuid="9287acd0-a1ea-48dd-95b1-d63ee2907776" x="35" y="213" width="733" height="40"/><textElement textAlignment="Center" verticalAlignment="Middle"><font size="14" isBold="true" isPdfEmbedded="false"/><paragraph leftIndent="10"/></textElement><text><![CDATA[Ementa]]></text></staticText><staticText><reportElement uuid="9287acd0-a1ea-48dd-95b1-d63ee2907776" x="395" y="452" width="207" height="40"/><textElement textAlignment="Center" verticalAlignment="Middle"><font size="14" isBold="true" isPdfEmbedded="false"/><paragraph leftIndent="10"/></textElement><text><![CDATA[Carga Horária da Turma]]></text></staticText><textField isBlankWhenNull="true"><reportElement uuid="8d93a5a3-390e-4756-93a2-25399dee0e55" x="35" y="265" width="733" height="154"/><textElement textAlignment="Justified"><font size="14"/><paragraph leftIndent="20" rightIndent="20"/></textElement><textFieldExpression><![CDATA[$F{dsc_ementa}]]></textFieldExpression></textField><textField isBlankWhenNull="true"><reportElement uuid="51044ade-44f7-4497-a543-dfddeca52658" x="602" y="452" width="166" height="40"/><textElement textAlignment="Center" verticalAlignment="Middle"><font size="14"/></textElement><textFieldExpression><![CDATA[$F{num_carga_horaria}]]></textFieldExpression></textField></frame></band></detail></jasperReport>