WebSVN - Integrator Subversion - Blame - Rev 1 - /PROJETOS/scs/scs-core/src/main/resources/relatorios/certificado.jrxml

Rev	Author	Line No.	Line
1	espaco	1	<?xml version="1.0" encoding="UTF-8"?>
		2	<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">
		3	<property name="ireport.zoom" value="0.9313819845887333"/>
		4	<property name="ireport.x" value="0"/>
		5	<property name="ireport.y" value="563"/>
		6	<parameter name="IMAGEM_DIR" class="java.lang.String">
		7	<defaultValueExpression><![CDATA["C:\\"]]></defaultValueExpression>
		8	</parameter>
		9	<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
		10	<defaultValueExpression><![CDATA["C:\\Repositorio\\DESENVOLVIMENTO\\SESAU\\JAVA\\Repositorio\\rhcapacitacao\\FONTES\\IMPLEMENTACAO\\DESENVOLVIMENTO\\scs\\scs-core\\src\\main\\resources\\relatorios\\"]]></defaultValueExpression>
		11	</parameter>
		12	<parameter name="SEQ_TURMA_PARTICIPANTE" class="java.lang.Long">
		13	<defaultValueExpression><![CDATA[]]></defaultValueExpression>
		14	</parameter>
		15	<queryString>
		16	<![CDATA[SELECT
		17	UPPER(pes.nom_pessoa) as nom_pessoa,
		18	cap.dsc_capacitacao,
		19	(SELECT MIN(pi.dth_data_inicial) FROM sc_scs.scs_turma_periodo pi WHERE pi.seq_turma = tur.seq_turma) as dth_data_inicial,
		20	(SELECT MAX(pf.dth_data_final) FROM sc_scs.scs_turma_periodo pf WHERE pf.seq_turma = tur.seq_turma) as dth_data_final,
		21	tur.num_carga_horaria,
		22	mun.nom_municipio,
		23	tur.cod_uf,
		24	est.nom_uf,
		25	tur.dsc_ementa,
		26	per.dsc_perfil,
		27	nat.dsc_natureza,
		28	par.num_carga_horaria_especifica
		29	FROM sc_scs.scs_turma_participante par
		30	LEFT JOIN sc_scs.scs_turma tur ON par.seq_turma = tur.seq_turma
		31	LEFT JOIN sc_scg.vw_pessoa_fisica pes ON par.seq_pessoa_participante = pes.seq_pessoa
		32	LEFT JOIN sc_scs.scs_capacitacao cap ON tur.seq_capacitacao = cap.seq_capacitacao
		33	LEFT JOIN sc_scs.scs_natureza nat ON cap.seq_natureza = nat.seq_natureza
		34	LEFT JOIN sc_scg.vw_uf est ON tur.cod_uf = est.cod_uf
		35	LEFT JOIN sc_scg.vw_municipio mun ON tur.seq_municipio=mun.seq_municipio
		36	LEFT JOIN sc_scs.scs_perfil per ON per.seq_perfil = par.seq_perfil
		37	WHERE par.seq_turma_participante = $P{SEQ_TURMA_PARTICIPANTE}]]>
		38	</queryString>
		39	<field name="nom_pessoa" class="java.lang.String"/>
		40	<field name="dsc_capacitacao" class="java.lang.String"/>
		41	<field name="dth_data_inicial" class="java.sql.Timestamp"/>
		42	<field name="dth_data_final" class="java.sql.Timestamp"/>
		43	<field name="num_carga_horaria" class="java.lang.Integer"/>
		44	<field name="nom_municipio" class="java.lang.String"/>
		45	<field name="cod_uf" class="java.lang.String"/>
		46	<field name="nom_uf" class="java.lang.String"/>
		47	<field name="dsc_ementa" class="java.lang.String"/>
		48	<field name="dsc_perfil" class="java.lang.String"/>
		49	<field name="dsc_natureza" class="java.lang.String"/>
		50	<field name="num_carga_horaria_especifica" class="java.lang.Integer"/>
		51	<detail>
		52	<band height="563">
		53	<rectangle radius="10">
		54	<reportElement uuid="4411e7fa-fbb1-4ed5-bbee-f16a9e4e0165" x="14" y="15" width="775" height="526"/>
		55	<graphicElement>
		56	<pen lineWidth="1.75"/>
		57	</graphicElement>
		58	</rectangle>
		59	<line>
		60	<reportElement uuid="b7a2fcbd-50a3-445c-92d5-95f8d6c7632d" x="272" y="491" width="235" height="1"/>
		61	</line>
		62	<staticText>
		63	<reportElement uuid="b353b05c-efe4-4071-9e4d-4192244a016b" x="282" y="494" width="228" height="20"/>
		64	<textElement textAlignment="Center" verticalAlignment="Middle">
		65	<font isBold="true"/>
		66	</textElement>
		67	<text><![CDATA[Robson José da Silva]]></text>
		68	</staticText>
		69	<line>
		70	<reportElement uuid="795869f9-09f3-485f-b425-2d9d7e97383d" x="29" y="491" width="235" height="1"/>
		71	</line>
		72	<staticText>
		73	<reportElement uuid="7e30ccc9-c513-4af8-b97f-82932bb54ffd" x="271" y="513" width="236" height="20"/>
		74	<textElement textAlignment="Center" verticalAlignment="Top">
		75	<font size="8" isBold="false" pdfFontName="Helvetica" isPdfEmbedded="true"/>
		76	</textElement>
		77	<text><![CDATA[Coordenador Setorial de Gestão e Desenvolvimento de Pessoas]]></text>
		78	</staticText>
		79	<line>
		80	<reportElement uuid="7462f635-35c0-46ab-a974-2eed1a8fae93" x="516" y="491" width="258" height="1"/>
		81	</line>
		82	<staticText>
		83	<reportElement uuid="124a3123-9cf1-49d6-af7e-2fdc404c7b23" x="516" y="494" width="258" height="20"/>
		84	<textElement textAlignment="Center" verticalAlignment="Middle">
		85	<font isBold="true"/>
		86	</textElement>
		87	<text><![CDATA[Rozangela Maria de Almeida Fernandes Wyszomirska]]></text>
		88	</staticText>
		89	<staticText>
		90	<reportElement uuid="ba716373-c9ef-4a84-bae1-40a9f32e4cdc" x="516" y="513" width="258" height="20"/>
		91	<textElement textAlignment="Center" verticalAlignment="Top">
		92	<font size="8" isBold="false" pdfFontName="Helvetica" isPdfEmbedded="true"/>
		93	</textElement>
		94	<text><![CDATA[Secretária de Estado da Saúde de Alagoas]]></text>
		95	</staticText>
		96	<textField>
		97	<reportElement uuid="f49a1067-a9b4-4367-8c3a-7db42e0ac529" x="14" y="195" width="775" height="191"/>
		98	<textElement textAlignment="Justified" markup="styled">
		99	<font size="16" isBold="false"/>
		100	<paragraph lineSpacing="1_1_2" leftIndent="20" rightIndent="20"/>
		101	</textElement>
		102	<textFieldExpression><![CDATA["Certificamos que "+ $F{nom_pessoa} + " participou como " + $F{dsc_perfil} + " do(a) " + $F{dsc_natureza} + " ''" + $F{dsc_capacitacao} + "''" +
		103	($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" : "") +
		104	(($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} : "") +
		105	", 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>
		106	</textField>
		107	<staticText>
		108	<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="14" y="69" width="775" height="36"/>
		109	<textElement textAlignment="Center" verticalAlignment="Top">
		110	<font fontName="Arial" size="10" isBold="false" pdfFontName="Helvetica" isPdfEmbedded="true"/>
		111	</textElement>
		112	<text><![CDATA[Secretaria de Estado da Saúde
		113	Coordenadoria Setorial de Gestão e Desenvolvimento de Pessoas
		114	Gerência de Desenvolvimento e Educação de Pessoas
		115	]]></text>
		116	</staticText>
		117	<image scaleImage="RealSize" hAlign="Center" vAlign="Middle" onErrorType="Icon">
		118	<reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" positionType="Float" mode="Transparent" x="382" y="21" width="33" height="36"/>
		119	<imageExpression><![CDATA[$P{IMAGEM_DIR} + "brasao.png"]]></imageExpression>
		120	</image>
		121	<staticText>
		122	<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="14" y="58" width="775" height="12"/>
		123	<textElement textAlignment="Center" verticalAlignment="Top">
		124	<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
		125	</textElement>
		126	<text><![CDATA[Estado de Alagoas]]></text>
		127	</staticText>
		128	<staticText>
		129	<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="14" y="115" width="775" height="70"/>
		130	<textElement textAlignment="Center" verticalAlignment="Middle">
		131	<font fontName="Arial" size="26" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
		132	</textElement>
		133	<text><![CDATA[Certificado]]></text>
		134	</staticText>
		135	<frame>
		136	<reportElement uuid="185a40f9-4f6c-4a21-bbc3-30b0d17a2373" x="0" y="0" width="803" height="555"/>
		137	<box>
		138	<pen lineWidth="3.0"/>
		139	<topPen lineWidth="3.0"/>
		140	<leftPen lineWidth="3.0"/>
		141	<bottomPen lineWidth="3.0"/>
		142	<rightPen lineWidth="3.0"/>
		143	</box>
		144	</frame>
		145	<textField>
		146	<reportElement uuid="8747f474-fb8d-47e3-ba83-5a06398f148e" x="14" y="386" width="775" height="27"/>
		147	<textElement textAlignment="Center">
		148	<font size="14"/>
		149	</textElement>
		150	<textFieldExpression><![CDATA["Maceió" + new java.text.SimpleDateFormat("', 'dd 'de' MMMMM 'de' yyyy", new Locale("pt", "BR")).format(new java.util.Date())]]></textFieldExpression>
		151	</textField>
		152	<image scaleImage="RealSize" hAlign="Center" vAlign="Bottom" onErrorType="Icon">
		153	<reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" positionType="Float" mode="Transparent" x="274" y="436" width="236" height="55"/>
		154	<imageExpression><![CDATA[$P{IMAGEM_DIR} + "assinatura_coordenador.png"]]></imageExpression>
		155	</image>
		156	<image scaleImage="RealSize" hAlign="Center" vAlign="Bottom" onErrorType="Icon">
		157	<reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" positionType="Float" mode="Transparent" x="516" y="452" width="258" height="70"/>
		158	<imageExpression><![CDATA[$P{IMAGEM_DIR} + "assina_secretario.png"]]></imageExpression>
		159	</image>
		160	</band>
		161	<band height="563">
		162	<frame>
		163	<reportElement uuid="185a40f9-4f6c-4a21-bbc3-30b0d17a2373" x="0" y="0" width="803" height="555"/>
		164	<box>
		165	<pen lineWidth="3.0"/>
		166	<topPen lineWidth="3.0"/>
		167	<leftPen lineWidth="3.0"/>
		168	<bottomPen lineWidth="3.0"/>
		169	<rightPen lineWidth="3.0"/>
		170	</box>
		171	<rectangle radius="10">
		172	<reportElement uuid="e1d0fb17-3251-437a-b095-8711c7470f41" x="14" y="15" width="775" height="526"/>
		173	<graphicElement>
		174	<pen lineWidth="1.75"/>
		175	</graphicElement>
		176	</rectangle>
		177	<rectangle>
		178	<reportElement uuid="b34de6d3-3fe0-41f9-b369-cec73b0a21c7" x="35" y="53" width="733" height="40"/>
		179	<graphicElement>
		180	<pen lineWidth="1.25"/>
		181	</graphicElement>
		182	</rectangle>
		183	<rectangle>
		184	<reportElement uuid="a9b8b5db-20db-45e1-a58e-7d91e7991f54" x="35" y="113" width="733" height="80"/>
		185	<graphicElement>
		186	<pen lineWidth="1.25"/>
		187	</graphicElement>
		188	</rectangle>
		189	<rectangle>
		190	<reportElement uuid="b3c75674-9760-4ed3-8dfc-5f401e4899d6" x="35" y="213" width="733" height="40"/>
		191	<graphicElement>
		192	<pen lineWidth="1.25"/>
		193	</graphicElement>
		194	</rectangle>
		195	<rectangle>
		196	<reportElement uuid="1e9f0da2-2abd-431a-a333-8978961684bc" x="35" y="253" width="733" height="179"/>
		197	<graphicElement>
		198	<pen lineWidth="1.25"/>
		199	</graphicElement>
		200	</rectangle>
		201	<rectangle>
		202	<reportElement uuid="fd954e28-0286-4ef1-b82c-728608ab9d6c" x="602" y="452" width="166" height="40"/>
		203	<graphicElement>
		204	<pen lineWidth="1.25"/>
		205	</graphicElement>
		206	</rectangle>
		207	<rectangle>
		208	<reportElement uuid="dc7393f5-e684-4841-b093-41c5b93d10da" x="395" y="452" width="207" height="40"/>
		209	<graphicElement>
		210	<pen lineWidth="1.25"/>
		211	</graphicElement>
		212	</rectangle>
		213	<textField>
		214	<reportElement uuid="75d78049-cf47-46e2-b93d-ecb1cb7d7d3a" x="35" y="53" width="733" height="40"/>
		215	<textElement verticalAlignment="Middle" markup="styled">
		216	<font size="14" isBold="false"/>
		217	<paragraph leftIndent="20" rightIndent="10"/>
		218	</textElement>
		219	<textFieldExpression><![CDATA["<style isBold='true'>Nome: </style>" + $F{nom_pessoa}]]></textFieldExpression>
		220	</textField>
		221	<textField>
		222	<reportElement uuid="619d1fcf-f5bc-441c-9965-657e886145d8" x="35" y="113" width="733" height="40"/>
		223	<textElement verticalAlignment="Middle" markup="styled">
		224	<font size="14"/>
		225	<paragraph leftIndent="20"/>
		226	</textElement>
		227	<textFieldExpression><![CDATA["<style isBold='true'>Capacitação: </style>" +$F{dsc_capacitacao}]]></textFieldExpression>
		228	</textField>
		229	<textField>
		230	<reportElement uuid="7762e76f-dadd-4110-bdfa-62181856bef8" x="35" y="156" width="733" height="40"/>
		231	<textElement verticalAlignment="Top" markup="styled">
		232	<font size="14"/>
		233	<paragraph leftIndent="20"/>
		234	</textElement>
		235	<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>
		236	</textField>
		237	<staticText>
		238	<reportElement uuid="9287acd0-a1ea-48dd-95b1-d63ee2907776" x="35" y="213" width="733" height="40"/>
		239	<textElement textAlignment="Center" verticalAlignment="Middle">
		240	<font size="14" isBold="true" isPdfEmbedded="false"/>
		241	<paragraph leftIndent="10"/>
		242	</textElement>
		243	<text><![CDATA[Ementa]]></text>
		244	</staticText>
		245	<staticText>
		246	<reportElement uuid="9287acd0-a1ea-48dd-95b1-d63ee2907776" x="395" y="452" width="207" height="40"/>
		247	<textElement textAlignment="Center" verticalAlignment="Middle">
		248	<font size="14" isBold="true" isPdfEmbedded="false"/>
		249	<paragraph leftIndent="10"/>
		250	</textElement>
		251	<text><![CDATA[Carga Horária da Turma]]></text>
		252	</staticText>
		253	<textField isBlankWhenNull="true">
		254	<reportElement uuid="8d93a5a3-390e-4756-93a2-25399dee0e55" x="35" y="265" width="733" height="154"/>
		255	<textElement textAlignment="Justified">
		256	<font size="14"/>
		257	<paragraph leftIndent="20" rightIndent="20"/>
		258	</textElement>
		259	<textFieldExpression><![CDATA[$F{dsc_ementa}]]></textFieldExpression>
		260	</textField>
		261	<textField isBlankWhenNull="true">
		262	<reportElement uuid="51044ade-44f7-4497-a543-dfddeca52658" x="602" y="452" width="166" height="40"/>
		263	<textElement textAlignment="Center" verticalAlignment="Middle">
		264	<font size="14"/>
		265	</textElement>
		266	<textFieldExpression><![CDATA[$F{num_carga_horaria}]]></textFieldExpression>
		267	</textField>
		268	</frame>
		269	</band>
		270	</detail>
		271	</jasperReport>

Subversion Repositories Integrator Subversion

(root)/PROJETOS/scs/scs-core/src/main/resources/relatorios/certificado.jrxml - Rev 1