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_solicitacao_procedimento" 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="0"/>
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="pSequencialAtendimentoAtendimento" 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_observacao,
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 
	r.dsc_procedimento
25 
FROM sc_cln.cln_solicitacao_procedimento a
26 
LEFT JOIN sc_cln.cln_atendimento t ON (t.seq_atendimento = a.seq_atendimento)
27 
LEFT JOIN sc_cln.cln_procedimento r ON (r.seq_procedimento = a.seq_Procedimento)
28 
JOIN sc_cln.cln_especialidade c ON (c.seq_especialidade = t.seq_especialidade)
29 
JOIN sc_adm.adm_pessoa   s ON (s.seq_pessoa = t.seq_pessoa_paciente)
30 
JOIN sc_adm.adm_pessoa   p ON (p.seq_pessoa = t.seq_pessoa_profissional)
31 
JOIN sc_adm.adm_pessoa_fisica   i ON (i.seq_pessoa = p.seq_pessoa)
32 
WHERE a.seq_solicitacao_procedimento = $P{pSequencialAtendimentoAtendimento}]]>
33 
	</queryString>
34 
	<field name="nom_paciente" class="java.lang.String"/>
35 
	<field name="nom_profissional" class="java.lang.String"/>
36 
	<field name="dsc_observacao" class="java.lang.String"/>
37 
	<field name="dsc_especialidade" class="java.lang.String"/>
38 
	<field name="num_crm" class="java.lang.String"/>
39 
	<field name="dsc_procedimento" class="java.lang.String"/>
40 
	<background>
41 
		<band splitType="Stretch"/>
42 
	</background>
43 
	<title>
44 
		<band height="56" splitType="Stretch">
45 
			<subreport>
46 
				<reportElement x="0" y="-1" width="555" height="50" uuid="d2037ecd-09a8-4a2d-b624-3614aadd4e79">
47 
					<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
48 
				</reportElement>
49 
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
50 
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "subrelatorio_cabecalho.jasper"]]></subreportExpression>
51 
			</subreport>
52 
		</band>
53 
	</title>
54 
	<detail>
55 
		<band height="176">
56 
			<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
57 
			<staticText>
58 
				<reportElement x="0" y="0" width="555" height="26" uuid="ec887a4d-29f4-4d9c-85b3-39483a26ebb3"/>
59 
				<textElement textAlignment="Center" verticalAlignment="Middle">
60 
					<font fontName="Arial" size="11" isBold="true" pdfFontName="Helvetica-Bold"/>
61 
				</textElement>
62 
				<text><![CDATA[SOLICITAÇÃO DE PROCEDIMENTO]]></text>
63 
			</staticText>
64 
			<textField isStretchWithOverflow="true">
65 
				<reportElement stretchType="RelativeToTallestObject" x="31" y="130" width="497" height="46" isPrintWhenDetailOverflows="true" uuid="b3444d06-3802-478c-b207-290ba5d82559"/>
66 
				<textElement textAlignment="Justified" verticalAlignment="Top">
67 
					<font fontName="Arial" size="11" isBold="false" pdfFontName="Helvetica-Bold"/>
68 
				</textElement>
69 
				<textFieldExpression><![CDATA[$F{dsc_observacao}]]></textFieldExpression>
70 
			</textField>
71 
			<staticText>
72 
				<reportElement x="14" y="44" width="61" height="17" uuid="ec887a4d-29f4-4d9c-85b3-39483a26ebb3"/>
73 
				<textElement verticalAlignment="Middle">
74 
					<font fontName="Arial" size="11" isBold="true" pdfFontName="Helvetica-Bold"/>
75 
				</textElement>
76 
				<text><![CDATA[PACIENTE:]]></text>
77 
			</staticText>
78 
			<textField>
79 
				<reportElement x="75" y="44" width="434" height="17" uuid="b3444d06-3802-478c-b207-290ba5d82559"/>
80 
				<textElement verticalAlignment="Middle">
81 
					<font fontName="Arial" size="11" isBold="false" pdfFontName="Helvetica-Bold"/>
82 
				</textElement>
83 
				<textFieldExpression><![CDATA[$F{nom_paciente}]]></textFieldExpression>
84 
			</textField>
85 
			<textField isStretchWithOverflow="true">
86 
				<reportElement stretchType="RelativeToTallestObject" x="31" y="89" width="497" height="17" isPrintWhenDetailOverflows="true" uuid="26994ed0-70ab-4209-9c61-cf8be6d1c811"/>
87 
				<textElement textAlignment="Justified" verticalAlignment="Middle">
88 
					<font fontName="Arial" size="11" isBold="false" pdfFontName="Helvetica-Bold"/>
89 
				</textElement>
90 
				<textFieldExpression><![CDATA[$F{dsc_procedimento}]]></textFieldExpression>
91 
			</textField>
92 
			<staticText>
93 
				<reportElement x="14" y="72" width="101" height="17" uuid="6a1561e1-f639-45a6-924a-b0e25022e03a"/>
94 
				<textElement verticalAlignment="Middle">
95 
					<font fontName="Arial" size="11" isBold="true" pdfFontName="Helvetica-Bold"/>
96 
				</textElement>
97 
				<text><![CDATA[PROCEDIMENTO:]]></text>
98 
			</staticText>
99 
			<staticText>
100 
				<reportElement x="14" y="113" width="101" height="17" uuid="5008d339-3d0a-49de-a2ea-bc0e0a8d5380"/>
101 
				<textElement verticalAlignment="Middle">
102 
					<font fontName="Arial" size="11" isBold="true" pdfFontName="Helvetica-Bold"/>
103 
				</textElement>
104 
				<text><![CDATA[OBSERVAÇÃO:]]></text>
105 
			</staticText>
106 
		</band>
107 
		<band height="169">
108 
			<textField isBlankWhenNull="true">
109 
				<reportElement x="149" y="30" width="250" height="15" uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68"/>
110 
				<textElement textAlignment="Center" verticalAlignment="Middle">
111 
					<font fontName="Arial" size="10" isBold="false"/>
112 
				</textElement>
113 
				<textFieldExpression><![CDATA[new java.text.SimpleDateFormat("'Maceió,' dd 'de' MMMMM 'de' yyyy", new Locale("pt", "BR")).format(new java.util.Date()).toUpperCase()]]></textFieldExpression>
114 
			</textField>
115 
			<textField>
116 
				<reportElement x="0" y="98" width="555" height="15" uuid="b3444d06-3802-478c-b207-290ba5d82559"/>
117 
				<textElement textAlignment="Center" verticalAlignment="Middle">
118 
					<font fontName="Arial" size="10" isBold="false" pdfFontName="Helvetica-Bold"/>
119 
				</textElement>
120 
				<textFieldExpression><![CDATA[$F{nom_profissional}]]></textFieldExpression>
121 
			</textField>
122 
			<textField>
123 
				<reportElement x="0" y="113" width="555" height="15" uuid="b3444d06-3802-478c-b207-290ba5d82559"/>
124 
				<textElement textAlignment="Center" verticalAlignment="Middle">
125 
					<font fontName="Arial" size="10" isBold="false" pdfFontName="Helvetica-Bold"/>
126 
				</textElement>
127 
				<textFieldExpression><![CDATA[$F{dsc_especialidade}]]></textFieldExpression>
128 
			</textField>
129 
			<line>
130 
				<reportElement x="149" y="97" width="250" height="1" uuid="d5a0ead0-5744-4eab-8808-88473a8bd558"/>
131 
			</line>
132 
			<textField isBlankWhenNull="true">
133 
				<reportElement x="0" y="128" width="555" height="15" uuid="a0bba90c-79a5-40f0-acf2-61a26121fa25"/>
134 
				<textElement textAlignment="Center" verticalAlignment="Middle">
135 
					<font fontName="Arial"/>
136 
				</textElement>
137 
				<textFieldExpression><![CDATA[$F{num_crm}]]></textFieldExpression>
138 
			</textField>
139 
		</band>
140 
	</detail>
141 
	<pageFooter>
142 
		<band height="46" splitType="Stretch">
143 
			<subreport>
144 
				<reportElement x="0" y="0" width="555" height="35" uuid="b3dd19fd-5662-46e7-a37f-0bd6ad278a29"/>
145 
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
146 
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "subrelatorio_rodape.jasper"]]></subreportExpression>
147 
			</subreport>
148 
		</band>
149 
	</pageFooter>
150 
</jasperReport>