Subversion Repositories Integrator Subversion

Rev

Details | Last modification | View Log | RSS feed

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="relatorio" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="85d4a540-608e-4934-8f57-57cec53afb74">
3 
	<property name="ireport.zoom" value="1.3310000000000004"/>
4 
	<property name="ireport.x" value="0"/>
5 
	<property name="ireport.y" value="0"/>
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="NOM_USUARIO" class="java.lang.String">
13 
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
14 
	</parameter>
15 
	<parameter name="CPF_USUARIO" class="java.lang.String">
16 
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
17 
	</parameter>
18 
	<parameter name="DAT_INICIAL" class="java.util.Date">
19 
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
20 
	</parameter>
21 
	<parameter name="DAT_FINAL" class="java.util.Date">
22 
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
23 
	</parameter>
24 
	<queryString>
25 
		<![CDATA[SELECT
26 
tr.num_ano, cp.dsc_capacitacao, tr.seq_turma
27 
FROM sc_scs.scs_turma tr
28 
INNER JOIN sc_scs.scs_capacitacao cp ON tr.seq_capacitacao = cp.seq_capacitacao
29 
WHERE EXISTS
30 
(
31 
   SELECT
32 
   tp.seq_turma_periodo
33 
   FROM sc_scs.scs_turma_periodo tp
34 
   WHERE
35 
   (
36 
      date_trunc
37 
      (
38 
         'day', tp.dth_data_inicial
39 
      )
40 
      >= $P{DAT_INICIAL} OR $P{DAT_INICIAL}::DATE IS NULL
41 
   )
42 
   AND
43 
   (
44 
      date_trunc
45 
      (
46 
         'day', tp.dth_data_final
47 
      )
48 
      <= $P{DAT_FINAL} OR $P{DAT_FINAL}::DATE IS NULL
49 
   )
50 
   AND tr.seq_turma = tp.seq_turma
51 
)
52 
ORDER BY tr.num_ano, cp.dsc_capacitacao]]>
53 
	</queryString>
54 
	<field name="num_ano" class="java.math.BigDecimal"/>
55 
	<field name="dsc_capacitacao" class="java.lang.String"/>
56 
	<field name="seq_turma" class="java.lang.Long"/>
57 
	<group name="Ano">
58 
		<groupExpression><![CDATA[$F{num_ano}]]></groupExpression>
59 
		<groupHeader>
60 
			<band height="30">
61 
				<rectangle>
62 
					<reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="0" y="10" width="555" height="20" backcolor="#CCCCCC"/>
63 
				</rectangle>
64 
				<textField>
65 
					<reportElement uuid="bd7e6eee-80f8-4b1d-a789-7078dbf18cb1" x="0" y="10" width="555" height="20" backcolor="#CCCCCC"/>
66 
					<textElement textAlignment="Center" verticalAlignment="Middle">
67 
						<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
68 
						<paragraph leftIndent="10"/>
69 
					</textElement>
70 
					<textFieldExpression><![CDATA["ANO DE EXERCÍCIO: " + $F{num_ano}]]></textFieldExpression>
71 
				</textField>
72 
			</band>
73 
		</groupHeader>
74 
	</group>
75 
	<pageHeader>
76 
		<band height="128">
77 
			<staticText>
78 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="48" width="555" height="36"/>
79 
				<textElement textAlignment="Center" verticalAlignment="Top">
80 
					<font fontName="Arial" size="10" isBold="false" pdfFontName="Helvetica" isPdfEmbedded="true"/>
81 
				</textElement>
82 
				<text><![CDATA[Secretaria de Estado da Saúde
83 
Coordenadoria Setorial de Gestão e Desenvolvimento de Pessoas
84 
Gerência de Desenvolvimento e Educação de Pessoas
85 
]]></text>
86 
			</staticText>
87 
			<image scaleImage="RealSize" hAlign="Center" vAlign="Middle" onErrorType="Icon">
88 
				<reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" positionType="Float" mode="Transparent" x="258" y="0" width="33" height="36"/>
89 
				<imageExpression><![CDATA[$P{IMAGEM_DIR} + "brasao.png"]]></imageExpression>
90 
			</image>
91 
			<staticText>
92 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="37" width="555" height="12"/>
93 
				<textElement textAlignment="Center" verticalAlignment="Top">
94 
					<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
95 
				</textElement>
96 
				<text><![CDATA[Estado de Alagoas]]></text>
97 
			</staticText>
98 
			<staticText>
99 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="92" width="555" height="12"/>
100 
				<textElement textAlignment="Center" verticalAlignment="Middle">
101 
					<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
102 
				</textElement>
103 
				<text><![CDATA[Relatório de Capacitação por Período]]></text>
104 
			</staticText>
105 
			<textField>
106 
				<reportElement uuid="a240ee1d-c3dd-42c9-84aa-450600c70894" x="0" y="105" width="555" height="12">
107 
					<printWhenExpression><![CDATA[$P{DAT_INICIAL} != null && $P{DAT_FINAL} == null]]></printWhenExpression>
108 
				</reportElement>
109 
				<textElement textAlignment="Center" verticalAlignment="Middle">
110 
					<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
111 
				</textElement>
112 
				<textFieldExpression><![CDATA["Data e Hora Inicial: " + new java.text.SimpleDateFormat("dd'/'MM'/'yyyy HH:mm:ss", new Locale("pt", "BR")).format($P{DAT_INICIAL})]]></textFieldExpression>
113 
			</textField>
114 
			<textField>
115 
				<reportElement uuid="a240ee1d-c3dd-42c9-84aa-450600c70894" x="0" y="105" width="555" height="12">
116 
					<printWhenExpression><![CDATA[$P{DAT_INICIAL} == null && $P{DAT_FINAL} != null]]></printWhenExpression>
117 
				</reportElement>
118 
				<textElement textAlignment="Center" verticalAlignment="Middle">
119 
					<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
120 
				</textElement>
121 
				<textFieldExpression><![CDATA["Data e Hora Final: " + new java.text.SimpleDateFormat("dd'/'MM'/'yyyy HH:mm:ss", new Locale("pt", "BR")).format($P{DAT_FINAL})]]></textFieldExpression>
122 
			</textField>
123 
			<textField>
124 
				<reportElement uuid="a240ee1d-c3dd-42c9-84aa-450600c70894" x="0" y="105" width="555" height="12">
125 
					<printWhenExpression><![CDATA[$P{DAT_INICIAL} != null && $P{DAT_FINAL} != null]]></printWhenExpression>
126 
				</reportElement>
127 
				<textElement textAlignment="Center" verticalAlignment="Middle">
128 
					<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
129 
				</textElement>
130 
				<textFieldExpression><![CDATA["Data e Hora: " + new java.text.SimpleDateFormat("dd'/'MM'/'yyyy HH:mm:ss", new Locale("pt", "BR")).format($P{DAT_INICIAL}) + " até " + new java.text.SimpleDateFormat("dd'/'MM'/'yyyy HH:mm:ss", new Locale("pt", "BR")).format($P{DAT_FINAL})]]></textFieldExpression>
131 
			</textField>
132 
		</band>
133 
	</pageHeader>
134 
	<detail>
135 
		<band height="30">
136 
			<elementGroup>
137 
				<rectangle>
138 
					<reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" positionType="Float" stretchType="RelativeToBandHeight" x="0" y="10" width="555" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
139 
				</rectangle>
140 
				<textField isStretchWithOverflow="true">
141 
					<reportElement uuid="bd7e6eee-80f8-4b1d-a789-7078dbf18cb1" positionType="Float" stretchType="RelativeToBandHeight" x="0" y="10" width="555" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
142 
					<textElement verticalAlignment="Middle">
143 
						<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
144 
						<paragraph leftIndent="5" rightIndent="5"/>
145 
					</textElement>
146 
					<textFieldExpression><![CDATA["CAPACITAÇÃO: " + $F{dsc_capacitacao}]]></textFieldExpression>
147 
				</textField>
148 
			</elementGroup>
149 
		</band>
150 
		<band height="20">
151 
			<subreport>
152 
				<reportElement uuid="7254a9b5-234f-493c-b93b-350725508fbb" positionType="Float" x="0" y="0" width="555" height="20" isRemoveLineWhenBlank="true"/>
153 
				<subreportParameter name="SUBREPORT_DIR">
154 
					<subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression>
155 
				</subreportParameter>
156 
				<subreportParameter name="SEQ_TURMA">
157 
					<subreportParameterExpression><![CDATA[$F{seq_turma}]]></subreportParameterExpression>
158 
				</subreportParameter>
159 
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
160 
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorioCapacitacaoPorPeriodo_sub_turma.jasper"]]></subreportExpression>
161 
			</subreport>
162 
		</band>
163 
	</detail>
164 
	<pageFooter>
165 
		<band height="15">
166 
			<textField isBlankWhenNull="true">
167 
				<reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="0" y="0" width="374" height="15"/>
168 
				<textElement verticalAlignment="Middle">
169 
					<font fontName="Arial" size="6" isBold="false"/>
170 
				</textElement>
171 
				<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>
172 
			</textField>
173 
			<textField isBlankWhenNull="false">
174 
				<reportElement uuid="e5f06c72-11c0-479b-b234-4dcaf2bc0440" key="textField" x="428" y="0" width="73" height="15"/>
175 
				<textElement textAlignment="Right" verticalAlignment="Middle">
176 
					<font fontName="Arial" size="6" isBold="false"/>
177 
				</textElement>
178 
				<textFieldExpression><![CDATA["PÁGINA " + $V{PAGE_NUMBER} + " DE "]]></textFieldExpression>
179 
			</textField>
180 
			<textField evaluationTime="Report" isBlankWhenNull="false">
181 
				<reportElement uuid="506b9991-ff6d-43b5-ab78-2832586c3dda" key="textField" x="502" y="0" width="52" height="15"/>
182 
				<textElement verticalAlignment="Middle">
183 
					<font fontName="Arial" size="6" isBold="false"/>
184 
				</textElement>
185 
				<textFieldExpression><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
186 
			</textField>
187 
		</band>
188 
	</pageFooter>
189 
</jasperReport>