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="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">
3
	<property name="ireport.zoom" value="1.5"/>
4
	<property name="ireport.x" value="0"/>
5
	<property name="ireport.y" value="181"/>
6
	<import value="br.gov.al.saude.framework.core.util.DocumentoUtils"/>
7
	<parameter name="pTipoSexo" class="java.lang.String">
8
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
9
	</parameter>
10
	<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
11
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
12
	</parameter>
13
	<parameter name="IMAGE_DIR" class="java.lang.String" isForPrompting="false">
14
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
15
	</parameter>
16
	<parameter name="pTipoEstadoCivil" class="java.lang.String"/>
17
	<parameter name="pCodGrauInstrucao" class="java.lang.Integer"/>
18
	<parameter name="pTipoSituacaoCadastral" class="java.lang.String"/>
19
	<parameter name="pTipoVinculo" class="java.lang.String"/>
20
	<parameter name="pCodFormaIngresso" class="java.lang.Integer"/>
21
	<parameter name="pCodSituacaoServidor" class="java.lang.Integer"/>
22
	<parameter name="pCargaHoraria" class="java.lang.Integer"/>
23
	<parameter name="pCodCargo" class="java.lang.Integer"/>
24
	<parameter name="pCodFuncao" class="java.lang.Integer"/>
25
	<parameter name="pCodEspecialidade" class="java.lang.Integer"/>
26
	<parameter name="pCodOrgaoOrigem" class="java.lang.Integer"/>
27
	<parameter name="pCodOrgaoLotacao" class="java.lang.Integer"/>
28
	<parameter name="pCodUnidadeExercicio" class="java.lang.Integer"/>
29
	<parameter name="pCodUnidadeLotacao" class="java.lang.Integer"/>
30
	<parameter name="pDataNascimentoInicial" class="java.util.Date"/>
31
	<parameter name="pDataNascimentoFinal" class="java.util.Date"/>
32
	<parameter name="pDataAdmissaoInicial" class="java.util.Date"/>
33
	<parameter name="pDataAdmissaoFinal" class="java.util.Date"/>
34
	<parameter name="pLocalizacaoArquivoNumeroCaixa" class="java.lang.String"/>
35
	<parameter name="pLocalizacaoArquivoNumeroPasta" class="java.lang.String"/>
36
	<parameter name="pLocalizacaoArquivoNumeroPrateleira" class="java.lang.Integer"/>
37
	<parameter name="pLocalizacaoArquivoLado" class="java.lang.String"/>
38
	<parameter name="pOrderColumn" class="java.lang.String">
39
		<defaultValueExpression><![CDATA["nome"]]></defaultValueExpression>
40
	</parameter>
41
	<parameter name="pOrderColumnLabel" class="java.lang.String"/>
42
	<queryString>
43
		<![CDATA[select * from sc_srv.fn_consulta_rel_acompanhamento_servidor(
44
				$P{pTipoSexo},
45
				$P{pTipoEstadoCivil},
46
				$P{pCodGrauInstrucao},
47
				$P{pTipoSituacaoCadastral},
48
				$P{pTipoVinculo},
49
				$P{pCodFormaIngresso},
50
				$P{pCodSituacaoServidor},
51
				$P{pCargaHoraria},
52
				$P{pCodCargo},
53
				$P{pCodFuncao},
54
				$P{pCodEspecialidade},
55
				$P{pCodOrgaoOrigem},
56
				$P{pCodOrgaoLotacao},
57
				$P{pCodUnidadeExercicio},
58
				$P{pCodUnidadeLotacao},
59
				$P{pDataNascimentoInicial},
60
				$P{pDataNascimentoFinal},
61
				$P{pDataAdmissaoInicial},
62
				$P{pDataAdmissaoFinal},
63
				$P{pLocalizacaoArquivoNumeroCaixa},
64
				$P{pLocalizacaoArquivoNumeroPasta},
65
				$P{pLocalizacaoArquivoNumeroPrateleira},
66
				$P{pLocalizacaoArquivoLado},
67
				$P{pOrderColumn}) order by campo, nome;]]>
68
	</queryString>
69
	<field name="cpf" class="java.lang.String"/>
70
	<field name="nome" class="java.lang.String"/>
71
	<field name="campo" class="java.lang.String"/>
72
	<variable name="totalRegistrosPorGrupo" class="java.lang.Integer" resetType="Group" resetGroup="Agrupamento" calculation="Count">
73
		<variableExpression><![CDATA[$F{cpf}]]></variableExpression>
74
		<initialValueExpression><![CDATA[0]]></initialValueExpression>
75
	</variable>
76
	<group name="parametros">
77
		<groupExpression><![CDATA["1"]]></groupExpression>
78
		<groupHeader>
79
			<band height="39">
80
				<rectangle>
81
					<reportElement uuid="423b9a10-6789-4023-9a4d-1cd8ecd4119f" x="0" y="0" width="802" height="15" backcolor="#CCCCCC"/>
82
				</rectangle>
83
				<staticText>
84
					<reportElement uuid="e8828b4d-8b34-47f1-8d10-88e65996eaf8" x="0" y="0" width="802" height="15"/>
85
					<textElement textAlignment="Center" verticalAlignment="Middle">
86
						<font fontName="Arial" size="8" isBold="true"/>
87
					</textElement>
88
					<text><![CDATA[PARÂMETROS]]></text>
89
				</staticText>
90
				<subreport>
91
					<reportElement uuid="b6189364-0d99-4f2a-9073-24e0266397c8" positionType="Float" stretchType="RelativeToTallestObject" x="0" y="15" width="802" height="15"/>
92
					<subreportParameter name="pCodFuncao">
93
						<subreportParameterExpression><![CDATA[$P{pCodFuncao}]]></subreportParameterExpression>
94
					</subreportParameter>
95
					<subreportParameter name="pCodSituacaoServidor">
96
						<subreportParameterExpression><![CDATA[$P{pCodSituacaoServidor}]]></subreportParameterExpression>
97
					</subreportParameter>
98
					<subreportParameter name="pCodEspecialidade">
99
						<subreportParameterExpression><![CDATA[$P{pCodEspecialidade}]]></subreportParameterExpression>
100
					</subreportParameter>
101
					<subreportParameter name="pLocalizacaoArquivoLado">
102
						<subreportParameterExpression><![CDATA[$P{pLocalizacaoArquivoLado}]]></subreportParameterExpression>
103
					</subreportParameter>
104
					<subreportParameter name="pCodGrauInstrucao">
105
						<subreportParameterExpression><![CDATA[$P{pCodGrauInstrucao}]]></subreportParameterExpression>
106
					</subreportParameter>
107
					<subreportParameter name="pLocalizacaoArquivoNumeroCaixa">
108
						<subreportParameterExpression><![CDATA[$P{pLocalizacaoArquivoNumeroCaixa}]]></subreportParameterExpression>
109
					</subreportParameter>
110
					<subreportParameter name="pCodFormaIngresso">
111
						<subreportParameterExpression><![CDATA[$P{pCodFormaIngresso}]]></subreportParameterExpression>
112
					</subreportParameter>
113
					<subreportParameter name="pTipoVinculo">
114
						<subreportParameterExpression><![CDATA[$P{pTipoVinculo}]]></subreportParameterExpression>
115
					</subreportParameter>
116
					<subreportParameter name="pLocalizacaoArquivoNumeroPasta">
117
						<subreportParameterExpression><![CDATA[$P{pLocalizacaoArquivoNumeroPasta}]]></subreportParameterExpression>
118
					</subreportParameter>
119
					<subreportParameter name="pCodUnidadeExercicio">
120
						<subreportParameterExpression><![CDATA[$P{pCodUnidadeExercicio}]]></subreportParameterExpression>
121
					</subreportParameter>
122
					<subreportParameter name="pTipoSituacaoCadastral">
123
						<subreportParameterExpression><![CDATA[$P{pTipoSituacaoCadastral}]]></subreportParameterExpression>
124
					</subreportParameter>
125
					<subreportParameter name="pCodOrgaoLotacao">
126
						<subreportParameterExpression><![CDATA[$P{pCodOrgaoLotacao}]]></subreportParameterExpression>
127
					</subreportParameter>
128
					<subreportParameter name="pCodCargo">
129
						<subreportParameterExpression><![CDATA[$P{pCodCargo}]]></subreportParameterExpression>
130
					</subreportParameter>
131
					<subreportParameter name="pTipoSexo">
132
						<subreportParameterExpression><![CDATA[$P{pTipoSexo}]]></subreportParameterExpression>
133
					</subreportParameter>
134
					<subreportParameter name="pCodUnidadeLotacao">
135
						<subreportParameterExpression><![CDATA[$P{pCodUnidadeLotacao}]]></subreportParameterExpression>
136
					</subreportParameter>
137
					<subreportParameter name="pCodOrgaoOrigem">
138
						<subreportParameterExpression><![CDATA[$P{pCodOrgaoOrigem}]]></subreportParameterExpression>
139
					</subreportParameter>
140
					<subreportParameter name="pCargaHoraria">
141
						<subreportParameterExpression><![CDATA[$P{pCargaHoraria}]]></subreportParameterExpression>
142
					</subreportParameter>
143
					<subreportParameter name="pDataAdmissaoInicial">
144
						<subreportParameterExpression><![CDATA[$P{pDataAdmissaoInicial}]]></subreportParameterExpression>
145
					</subreportParameter>
146
					<subreportParameter name="pDataAdmissaoFinal">
147
						<subreportParameterExpression><![CDATA[$P{pDataAdmissaoFinal}]]></subreportParameterExpression>
148
					</subreportParameter>
149
					<subreportParameter name="pLocalizacaoArquivoNumeroPrateleira">
150
						<subreportParameterExpression><![CDATA[$P{pLocalizacaoArquivoNumeroPrateleira}]]></subreportParameterExpression>
151
					</subreportParameter>
152
					<subreportParameter name="pDataNascimentoInicial">
153
						<subreportParameterExpression><![CDATA[$P{pDataNascimentoInicial}]]></subreportParameterExpression>
154
					</subreportParameter>
155
					<subreportParameter name="pTipoEstadoCivil">
156
						<subreportParameterExpression><![CDATA[$P{pTipoEstadoCivil}]]></subreportParameterExpression>
157
					</subreportParameter>
158
					<subreportParameter name="pDataNascimentoFinal">
159
						<subreportParameterExpression><![CDATA[$P{pDataNascimentoFinal}]]></subreportParameterExpression>
160
					</subreportParameter>
161
					<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
162
					<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorio_acompanhamento_servidor_subreport_parametros.jasper"]]></subreportExpression>
163
				</subreport>
164
				<rectangle>
165
					<reportElement uuid="423b9a10-6789-4023-9a4d-1cd8ecd4119f" positionType="Float" stretchType="RelativeToTallestObject" mode="Transparent" x="0" y="0" width="802" height="30" backcolor="#CCCCCC"/>
166
				</rectangle>
167
			</band>
168
		</groupHeader>
169
	</group>
170
	<group name="Agrupamento" isReprintHeaderOnEachPage="true">
171
		<groupExpression><![CDATA[!"nome".equals($P{pOrderColumn})? $F{campo} : "1"]]></groupExpression>
172
		<groupHeader>
173
			<band height="28">
174
				<printWhenExpression><![CDATA[!"nome".equals($P{pOrderColumn})]]></printWhenExpression>
175
				<rectangle>
176
					<reportElement uuid="2548ecb3-eeab-4cbe-9345-f50e8fb25f14" x="0" y="11" width="802" height="17" backcolor="#CCCCCC"/>
177
				</rectangle>
178
				<textField isBlankWhenNull="true">
179
					<reportElement uuid="af7f3ad7-484f-4647-95e3-915cb36411ff" x="0" y="11" width="802" height="17"/>
180
					<textElement verticalAlignment="Middle">
181
						<font size="10" isBold="true"/>
182
						<paragraph leftIndent="5"/>
183
					</textElement>
184
					<textFieldExpression><![CDATA[$P{pOrderColumnLabel} + ": " + ($F{campo} != null? $F{campo} : "NÃO INFORMADO")]]></textFieldExpression>
185
				</textField>
186
			</band>
187
		</groupHeader>
188
		<groupFooter>
189
			<band height="16">
190
				<rectangle>
191
					<reportElement uuid="97f01493-c39f-4e3a-9aaf-9ef690951ea8" positionType="Float" x="0" y="0" width="802" height="16" backcolor="#FFFFFF"/>
192
				</rectangle>
193
				<textField>
194
					<reportElement uuid="45faee71-4e4d-4ad6-a9ea-6db559b9fd86" x="418" y="0" width="384" height="16"/>
195
					<textElement textAlignment="Right" verticalAlignment="Middle">
196
						<font size="8" isBold="true"/>
197
						<paragraph rightIndent="2"/>
198
					</textElement>
199
					<textFieldExpression><![CDATA["QUANTIDADE DE SERVIDORES: " + $V{totalRegistrosPorGrupo}]]></textFieldExpression>
200
				</textField>
201
			</band>
202
		</groupFooter>
203
	</group>
204
	<group name="cabecalho" isReprintHeaderOnEachPage="true">
205
		<groupExpression><![CDATA["1"]]></groupExpression>
206
		<groupHeader>
207
			<band height="30">
208
				<rectangle>
209
					<reportElement uuid="97f01493-c39f-4e3a-9aaf-9ef690951ea8" positionType="Float" x="155" y="15" width="647" height="15" backcolor="#CCCCCC"/>
210
				</rectangle>
211
				<rectangle>
212
					<reportElement uuid="97f01493-c39f-4e3a-9aaf-9ef690951ea8" positionType="Float" x="0" y="15" width="155" height="15" backcolor="#CCCCCC"/>
213
				</rectangle>
214
				<staticText>
215
					<reportElement uuid="e8828b4d-8b34-47f1-8d10-88e65996eaf8" positionType="Float" x="155" y="15" width="520" height="15" isPrintWhenDetailOverflows="true"/>
216
					<textElement verticalAlignment="Middle">
217
						<font fontName="Arial" size="8"/>
218
						<paragraph leftIndent="5"/>
219
					</textElement>
220
					<text><![CDATA[NOME]]></text>
221
				</staticText>
222
				<staticText>
223
					<reportElement uuid="e8828b4d-8b34-47f1-8d10-88e65996eaf8" positionType="Float" x="0" y="15" width="155" height="15" isPrintWhenDetailOverflows="true"/>
224
					<textElement verticalAlignment="Middle">
225
						<font fontName="Arial" size="8"/>
226
						<paragraph leftIndent="5"/>
227
					</textElement>
228
					<text><![CDATA[CPF]]></text>
229
				</staticText>
230
				<rectangle>
231
					<reportElement uuid="97f01493-c39f-4e3a-9aaf-9ef690951ea8" positionType="Float" x="0" y="0" width="802" height="15" backcolor="#CCCCCC"/>
232
				</rectangle>
233
				<staticText>
234
					<reportElement uuid="e8828b4d-8b34-47f1-8d10-88e65996eaf8" positionType="Float" x="0" y="0" width="802" height="15" isPrintWhenDetailOverflows="true"/>
235
					<textElement textAlignment="Center" verticalAlignment="Middle">
236
						<font fontName="Arial" size="8" isBold="true"/>
237
					</textElement>
238
					<text><![CDATA[SERVIDORES]]></text>
239
				</staticText>
240
			</band>
241
		</groupHeader>
242
	</group>
243
	<background>
244
		<band splitType="Stretch"/>
245
	</background>
246
	<pageHeader>
247
		<band height="111">
248
			<staticText>
249
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="252" y="62" width="298" height="39" isPrintWhenDetailOverflows="true"/>
250
				<textElement textAlignment="Center" verticalAlignment="Top">
251
					<font fontName="Arial" size="10" isBold="true"/>
252
				</textElement>
253
				<text><![CDATA[ESTADO DE ALAGOAS
254
SECRETARIA DE ESTADO DA SAÚDE DE ALAGOAS
255
RELATÓRIO DE ACOMPANHAMENTO DO SERVIDOR]]></text>
256
			</staticText>
257
			<image hAlign="Right">
258
				<reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" x="380" y="0" width="48" height="59" isPrintWhenDetailOverflows="true"/>
259
				<imageExpression><![CDATA[$P{IMAGE_DIR} + "brasao.jpg"]]></imageExpression>
260
			</image>
261
		</band>
262
	</pageHeader>
263
	<detail>
264
		<band height="15">
265
			<rectangle>
266
				<reportElement uuid="97f01493-c39f-4e3a-9aaf-9ef690951ea8" positionType="Float" x="0" y="0" width="155" height="15" backcolor="#FFFFFF"/>
267
			</rectangle>
268
			<rectangle>
269
				<reportElement uuid="97f01493-c39f-4e3a-9aaf-9ef690951ea8" positionType="Float" x="155" y="0" width="647" height="15" backcolor="#FFFFFF"/>
270
			</rectangle>
271
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
272
				<reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" x="0" y="0" width="155" height="15" isPrintWhenDetailOverflows="true"/>
273
				<textElement verticalAlignment="Middle">
274
					<font fontName="Arial" size="8" isBold="true"/>
275
					<paragraph leftIndent="5"/>
276
				</textElement>
277
				<textFieldExpression><![CDATA[br.gov.al.saude.framework.core.util.DocumentoUtils.adicionarMascaraCpf($F{cpf})]]></textFieldExpression>
278
			</textField>
279
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
280
				<reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" x="155" y="0" width="647" height="15" isPrintWhenDetailOverflows="true"/>
281
				<textElement verticalAlignment="Middle">
282
					<font fontName="Arial" size="8" isBold="true"/>
283
					<paragraph leftIndent="5"/>
284
				</textElement>
285
				<textFieldExpression><![CDATA[$F{nome}]]></textFieldExpression>
286
			</textField>
287
		</band>
288
	</detail>
289
	<pageFooter>
290
		<band height="30">
291
			<textField evaluationTime="Report" isBlankWhenNull="false">
292
				<reportElement uuid="506b9991-ff6d-43b5-ab78-2832586c3dda" key="textField" x="750" y="10" width="52" height="15"/>
293
				<textElement verticalAlignment="Middle">
294
					<font fontName="Arial" size="6" isBold="false"/>
295
				</textElement>
296
				<textFieldExpression><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
297
			</textField>
298
			<textField isBlankWhenNull="false">
299
				<reportElement uuid="e5f06c72-11c0-479b-b234-4dcaf2bc0440" key="textField" x="675" y="10" width="73" height="15"/>
300
				<textElement textAlignment="Right" verticalAlignment="Middle">
301
					<font fontName="Arial" size="6" isBold="false"/>
302
				</textElement>
303
				<textFieldExpression><![CDATA["PÁGINA " + $V{PAGE_NUMBER} + " DE "]]></textFieldExpression>
304
			</textField>
305
			<textField isBlankWhenNull="true">
306
				<reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="0" y="10" width="266" height="15"/>
307
				<textElement verticalAlignment="Middle">
308
					<font fontName="Arial" size="6" isBold="false"/>
309
				</textElement>
310
				<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>
311
			</textField>
312
		</band>
313
	</pageFooter>
314
	<summary>
315
		<band height="18">
316
			<printWhenExpression><![CDATA["nome".equals($P{pOrderColumn})]]></printWhenExpression>
317
		</band>
318
	</summary>
319
</jasperReport>