Subversion Repositories Integrator Subversion

Rev

Rev 182 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
179 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="45"/>
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:\\REPOSITORIO\\svnPessoal\\jabti.com\\CLINICA\\clinica\\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 
	(
19 
  	select num_documento
20 
  	   from sc_adm.adm_pessoa_documento d
21 
 	  where d.seq_pessoa= p.seq_pessoa
22 
    	    and d.cod_tipo_documento = 3
23 
	) AS num_crm
24 
FROM sc_cln.cln_atendimento_texto a
25 
LEFT JOIN sc_cln.cln_atendimento t ON (t.seq_atendimento = a.seq_atendimento)
26 
JOIN sc_cln.cln_especialidade c ON (c.seq_especialidade = t.seq_especialidade)
27 
JOIN sc_adm.adm_pessoa   s ON (s.seq_pessoa = t.seq_pessoa_paciente)
28 
JOIN sc_adm.adm_pessoa   p ON (p.seq_pessoa = t.seq_pessoa_profissional)
29 
JOIN sc_adm.adm_pessoa_fisica   i ON (i.seq_pessoa = p.seq_pessoa)
30 
WHERE a.seq_atendimento_texto = $P{pSequencialAtendimentoTexto}]]>
31 
	</queryString>
32 
	<field name="nom_paciente" class="java.lang.String"/>
33 
	<field name="nom_profissional" class="java.lang.String"/>
34 
	<field name="prescricao" class="java.lang.String"/>
35 
	<field name="dsc_especialidade" class="java.lang.String"/>
36 
	<field name="num_crm" class="java.lang.String"/>
37 
	<background>
38 
		<band splitType="Stretch"/>
39 
	</background>
40 
	<title>
41 
		<band height="56" splitType="Stretch">
42 
			<subreport>
43 
				<reportElement x="0" y="-1" width="555" height="50" uuid="d2037ecd-09a8-4a2d-b624-3614aadd4e79">
44 
					<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
45 
				</reportElement>
46 
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
47 
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "subrelatorio_cabecalho.jasper"]]></subreportExpression>
48 
			</subreport>
49 
		</band>
50 
	</title>
51 
	<detail>
52 
		<band height="153">
53 
			<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
54 
			<staticText>
55 
				<reportElement x="0" y="0" width="555" height="26" uuid="ec887a4d-29f4-4d9c-85b3-39483a26ebb3"/>
56 
				<textElement textAlignment="Center" verticalAlignment="Middle">
57 
					<font fontName="Arial" size="11" isBold="true" pdfFontName="Helvetica-Bold"/>
58 
				</textElement>
59 
				<text><![CDATA[PRESCRIÇÃO MÉDICA]]></text>
60 
			</staticText>
61 
			<textField isStretchWithOverflow="true">
62 
				<reportElement stretchType="RelativeToTallestObject" x="40" y="75" width="505" height="67" isPrintWhenDetailOverflows="true" uuid="b3444d06-3802-478c-b207-290ba5d82559"/>
63 
				<textElement textAlignment="Justified" verticalAlignment="Top">
64 
					<font fontName="Arial" size="11" isBold="false" pdfFontName="Helvetica-Bold"/>
65 
				</textElement>
66 
				<textFieldExpression><![CDATA[$F{prescricao}]]></textFieldExpression>
67 
			</textField>
68 
			<staticText>
69 
				<reportElement x="10" y="44" width="65" height="17" uuid="ec887a4d-29f4-4d9c-85b3-39483a26ebb3"/>
70 
				<textElement textAlignment="Left" verticalAlignment="Middle">
71 
					<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold"/>
72 
				</textElement>
73 
				<text><![CDATA[PACIENTE:]]></text>
74 
			</staticText>
75 
			<textField>
76 
				<reportElement x="75" y="44" width="470" height="17" uuid="b3444d06-3802-478c-b207-290ba5d82559"/>
77 
				<textElement verticalAlignment="Middle">
78 
					<font fontName="Arial" size="10" isBold="false" pdfFontName="Helvetica-Bold"/>
79 
				</textElement>
80 
				<textFieldExpression><![CDATA[$F{nom_paciente}]]></textFieldExpression>
81 
			</textField>
82 
		</band>
83 
		<band height="169">
84 
			<textField isBlankWhenNull="true">
85 
				<reportElement x="149" y="30" width="250" height="15" uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68"/>
86 
				<textElement textAlignment="Center" verticalAlignment="Middle">
87 
					<font fontName="Arial" size="10" isBold="false"/>
88 
				</textElement>
89 
				<textFieldExpression><![CDATA[new java.text.SimpleDateFormat("'Maceió,' dd 'de' MMMMM 'de' yyyy", new Locale("pt", "BR")).format(new java.util.Date()).toUpperCase()]]></textFieldExpression>
90 
			</textField>
91 
			<textField>
92 
				<reportElement x="0" y="98" width="555" height="15" uuid="b3444d06-3802-478c-b207-290ba5d82559"/>
93 
				<textElement textAlignment="Center" verticalAlignment="Middle">
94 
					<font fontName="Arial" size="10" isBold="false" pdfFontName="Helvetica-Bold"/>
95 
				</textElement>
96 
				<textFieldExpression><![CDATA[$F{nom_profissional}]]></textFieldExpression>
97 
			</textField>
98 
			<textField>
99 
				<reportElement x="0" y="113" width="555" height="15" uuid="b3444d06-3802-478c-b207-290ba5d82559"/>
100 
				<textElement textAlignment="Center" verticalAlignment="Middle">
101 
					<font fontName="Arial" size="10" isBold="false" pdfFontName="Helvetica-Bold"/>
102 
				</textElement>
103 
				<textFieldExpression><![CDATA[$F{dsc_especialidade}]]></textFieldExpression>
104 
			</textField>
105 
			<line>
106 
				<reportElement x="149" y="97" width="250" height="1" uuid="d5a0ead0-5744-4eab-8808-88473a8bd558"/>
107 
			</line>
108 
			<textField isBlankWhenNull="true">
109 
				<reportElement x="0" y="128" width="555" height="15" uuid="a0bba90c-79a5-40f0-acf2-61a26121fa25"/>
110 
				<textElement textAlignment="Center" verticalAlignment="Middle">
111 
					<font fontName="Arial"/>
112 
				</textElement>
113 
				<textFieldExpression><![CDATA[$F{num_crm}]]></textFieldExpression>
114 
			</textField>
115 
		</band>
116 
	</detail>
117 
	<pageFooter>
118 
		<band height="48" splitType="Stretch">
119 
			<subreport>
120 
				<reportElement x="0" y="0" width="555" height="35" uuid="b3dd19fd-5662-46e7-a37f-0bd6ad278a29"/>
121 
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
122 
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "subrelatorio_rodape.jasper"]]></subreportExpression>
123 
			</subreport>
124 
		</band>
125 
	</pageFooter>
126 
</jasperReport>