Subversion Repositories Integrator Subversion

Rev

Rev 182 | Details | Compare with Previous | 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_final" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="37eaa257-2cde-4b75-a6f3-e6bb7f994082">
3 
	<property name="ireport.zoom" value="1.4641000000000006"/>
4 
	<property name="ireport.x" value="0"/>
5 
	<property name="ireport.y" value="84"/>
6 
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
7 
	<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
8 
		<defaultValueExpression><![CDATA["C:\\PROJETOS CESMAC\\sic\\sic-web\\src\\main\\resources\\relatorios\\"]]></defaultValueExpression>
9 
	</parameter>
10 
	<parameter name="pSequencialAtendimentoTexto" class="java.lang.Long">
11 
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
12 
	</parameter>
13 
	<queryString>
14 
		<![CDATA[SELECT 	s.nom_pessoa AS nom_paciente,
15 
	i.dsc_tratamento || ' ' || p.nom_pessoa AS nom_profissional,
16 
	a.dsc_texto AS prescricao,
17 
	c.dsc_especialidade
18 
FROM sc_cln.cln_atendimento_texto a
19 
LEFT JOIN sc_cln.cln_atendimento t ON (t.seq_atendimento = a.seq_atendimento)
20 
JOIN sc_cln.cln_especialidade c ON (c.seq_especialidade = t.seq_especialidade)
21 
JOIN sc_adm.adm_pessoa   s ON (s.seq_pessoa = t.seq_pessoa_paciente)
22 
JOIN sc_adm.adm_pessoa   p ON (p.seq_pessoa = t.seq_pessoa_profissional)
23 
JOIN sc_adm.adm_pessoa_fisica   i ON (i.seq_pessoa = p.seq_pessoa)
24 
WHERE a.seq_atendimento_texto = $P{pSequencialAtendimentoTexto}]]>
25 
	</queryString>
26 
	<field name="nom_paciente" class="java.lang.String"/>
27 
	<field name="nom_profissional" class="java.lang.String"/>
28 
	<field name="prescricao" class="java.lang.String"/>
29 
	<field name="dsc_especialidade" class="java.lang.String"/>
30 
	<background>
31 
		<band splitType="Stretch"/>
32 
	</background>
33 
	<title>
34 
		<band height="56" splitType="Stretch">
35 
			<subreport>
36 
				<reportElement uuid="d2037ecd-09a8-4a2d-b624-3614aadd4e79" x="0" y="-1" width="555" height="50">
37 
					<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
38 
				</reportElement>
39 
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
40 
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "subrelatorio_cabecalho.jasper"]]></subreportExpression>
41 
			</subreport>
42 
		</band>
43 
	</title>
44 
	<detail>
45 
		<band height="208">
46 
			<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
47 
			<rectangle>
48 
				<reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" x="10" y="90" width="535" height="26" backcolor="#FFFFFF"/>
49 
			</rectangle>
50 
			<staticText>
51 
				<reportElement uuid="ec887a4d-29f4-4d9c-85b3-39483a26ebb3" x="0" y="90" width="555" height="26"/>
52 
				<textElement textAlignment="Center" verticalAlignment="Middle">
53 
					<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold"/>
54 
				</textElement>
55 
				<text><![CDATA[PRESCRIÇÃO MÉDICA]]></text>
56 
			</staticText>
57 
			<textField isStretchWithOverflow="true">
58 
				<reportElement uuid="b3444d06-3802-478c-b207-290ba5d82559" stretchType="RelativeToTallestObject" x="30" y="170" width="495" height="15" isPrintWhenDetailOverflows="true"/>
59 
				<textElement textAlignment="Justified" verticalAlignment="Middle">
60 
					<font fontName="Arial" size="11" isBold="false" pdfFontName="Helvetica-Bold"/>
61 
				</textElement>
62 
				<textFieldExpression><![CDATA[$F{prescricao}]]></textFieldExpression>
63 
			</textField>
64 
			<line>
65 
				<reportElement uuid="d5a0ead0-5744-4eab-8808-88473a8bd558" x="10" y="63" width="535" height="1"/>
66 
			</line>
67 
			<staticText>
68 
				<reportElement uuid="ec887a4d-29f4-4d9c-85b3-39483a26ebb3" x="10" y="142" width="36" height="17"/>
69 
				<textElement textAlignment="Left" verticalAlignment="Middle">
70 
					<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold"/>
71 
				</textElement>
72 
				<text><![CDATA[PARA: ]]></text>
73 
			</staticText>
74 
			<textField>
75 
				<reportElement uuid="b3444d06-3802-478c-b207-290ba5d82559" x="10" y="25" width="535" height="15"/>
76 
				<textElement textAlignment="Center" verticalAlignment="Middle">
77 
					<font fontName="Arial" size="10" isBold="false" pdfFontName="Helvetica-Bold"/>
78 
				</textElement>
79 
				<textFieldExpression><![CDATA[$F{nom_profissional}]]></textFieldExpression>
80 
			</textField>
81 
			<textField>
82 
				<reportElement uuid="b3444d06-3802-478c-b207-290ba5d82559" x="10" y="40" width="535" height="15"/>
83 
				<textElement textAlignment="Center" verticalAlignment="Middle">
84 
					<font fontName="Arial" size="10" isBold="false" pdfFontName="Helvetica-Bold"/>
85 
				</textElement>
86 
				<textFieldExpression><![CDATA[$F{dsc_especialidade}]]></textFieldExpression>
87 
			</textField>
88 
			<textField>
89 
				<reportElement uuid="b3444d06-3802-478c-b207-290ba5d82559" x="46" y="142" width="408" height="17"/>
90 
				<textElement verticalAlignment="Middle">
91 
					<font fontName="Arial" size="10" isBold="false" pdfFontName="Helvetica-Bold"/>
92 
				</textElement>
93 
				<textFieldExpression><![CDATA[$F{nom_paciente}]]></textFieldExpression>
94 
			</textField>
95 
		</band>
96 
		<band height="169">
97 
			<textField isBlankWhenNull="true">
98 
				<reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="149" y="30" width="250" height="15"/>
99 
				<textElement textAlignment="Center" verticalAlignment="Middle">
100 
					<font fontName="Arial" size="10" isBold="false"/>
101 
				</textElement>
102 
				<textFieldExpression><![CDATA[new java.text.SimpleDateFormat("'Maceió,' dd 'de' MMMMM 'de' yyyy", new Locale("pt", "BR")).format(new java.util.Date()).toUpperCase()]]></textFieldExpression>
103 
			</textField>
104 
		</band>
105 
	</detail>
106 
	<pageFooter>
107 
		<band height="15" splitType="Stretch">
108 
			<textField isBlankWhenNull="true">
109 
				<reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="0" y="0" width="208" height="15"/>
110 
				<textElement verticalAlignment="Middle">
111 
					<font fontName="Arial" size="6" isBold="false"/>
112 
				</textElement>
113 
				<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>
114 
			</textField>
115 
			<textField isBlankWhenNull="false">
116 
				<reportElement uuid="e5f06c72-11c0-479b-b234-4dcaf2bc0440" key="textField" x="430" y="0" width="73" height="15"/>
117 
				<textElement textAlignment="Right" verticalAlignment="Middle">
118 
					<font fontName="Arial" size="6" isBold="false"/>
119 
				</textElement>
120 
				<textFieldExpression><![CDATA["PÁGINA " + $V{PAGE_NUMBER} + " DE "]]></textFieldExpression>
121 
			</textField>
122 
			<textField evaluationTime="Report" isBlankWhenNull="false">
123 
				<reportElement uuid="506b9991-ff6d-43b5-ab78-2832586c3dda" key="textField" x="503" y="0" width="52" height="15"/>
124 
				<textElement verticalAlignment="Middle">
125 
					<font fontName="Arial" size="6" isBold="false"/>
126 
				</textElement>
127 
				<textFieldExpression><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
128 
			</textField>
129 
			<line>
130 
				<reportElement uuid="d5a0ead0-5744-4eab-8808-88473a8bd558" x="149" y="-74" width="250" height="1"/>
131 
			</line>
132 
			<staticText>
133 
				<reportElement uuid="f96a240e-1e2a-4333-ac5e-0539ce887d4b" x="149" y="-72" width="250" height="20"/>
134 
				<textElement textAlignment="Center"/>
135 
				<text><![CDATA[Assinatura do Médico]]></text>
136 
			</staticText>
137 
		</band>
138 
	</pageFooter>
139 
</jasperReport>