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="prontuario_questionario" pageWidth="555" pageHeight="802" columnWidth="555" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="4465bb96-c2e8-4bea-a08a-9c0162468e30">
3 
	<property name="ireport.zoom" value="1.0"/>
4 
	<property name="ireport.x" value="0"/>
5 
	<property name="ireport.y" value="0"/>
6 
	<parameter name="pSequencialAtendimento" class="java.lang.Integer">
7 
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
8 
	</parameter>
9 
	<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
10 
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
11 
	</parameter>
12 
	<queryString>
13 
		<![CDATA[SELECT
14 
pe.seq_questionario,
15 
(select qu.dsc_questionario from sc_adm.adm_questionario qu where qu.seq_questionario = pe.seq_questionario) as dsc_questionario,
16 
se.nom_secao,
17 
pe.seq_pergunta,
18 
pe.num_pergunta,
19 
pe.dsc_pergunta,
20 
pe.tip_resposta
21 
FROM sc_adm.adm_pergunta pe
22 
left join sc_adm.adm_secao se on (se.seq_secao = pe.seq_secao)
23 
where pe.seq_questionario in (select p.seq_questionario from sc_cln.cln_atendimento_itemrespquest air
24 
join sc_adm.adm_item_resposta ir on (ir.seq_item_resposta = air.seq_item_resposta)
25 
join sc_adm.adm_pergunta p on (p.seq_pergunta = ir.seq_pergunta)
26 
where air.seq_atendimento = $P{pSequencialAtendimento})
27 
order by pe.seq_questionario, pe.num_pergunta]]>
28 
	</queryString>
29 
	<field name="seq_questionario" class="java.lang.Long">
30 
		<fieldDescription><![CDATA[Sequencial Identificador do questionário.]]></fieldDescription>
31 
	</field>
32 
	<field name="dsc_questionario" class="java.lang.String">
33 
		<fieldDescription><![CDATA[Descrição do questionário.]]></fieldDescription>
34 
	</field>
35 
	<field name="nom_secao" class="java.lang.String">
36 
		<fieldDescription><![CDATA[Nome da seção.]]></fieldDescription>
37 
	</field>
38 
	<field name="seq_pergunta" class="java.lang.Integer">
39 
		<fieldDescription><![CDATA[Sequencial Identificador da pergunta.]]></fieldDescription>
40 
	</field>
41 
	<field name="num_pergunta" class="java.lang.Long">
42 
		<fieldDescription><![CDATA[Número da pergunta. Usado para ordenar a exibição das perguntas do questionário.]]></fieldDescription>
43 
	</field>
44 
	<field name="dsc_pergunta" class="java.lang.String">
45 
		<fieldDescription><![CDATA[Descrição da Pergunta]]></fieldDescription>
46 
	</field>
47 
	<field name="tip_resposta" class="java.lang.String">
48 
		<fieldDescription><![CDATA[Tipo de resposta da pergunta.
49 
Valores Possíveis: Única escolha, Multipla escolha e Texto livre.]]></fieldDescription>
50 
	</field>
51 
	<group name="questionario">
52 
		<groupExpression><![CDATA[$F{seq_questionario}]]></groupExpression>
53 
		<groupHeader>
54 
			<band height="25">
55 
				<textField>
56 
					<reportElement uuid="96008fa9-4c97-43f6-ad57-a4e7822232b9" x="0" y="5" width="555" height="20"/>
57 
					<textElement>
58 
						<font fontName="Arial" size="12" isBold="true" isUnderline="false" pdfFontName="Helvetica-Bold"/>
59 
					</textElement>
60 
					<textFieldExpression><![CDATA["FORMULÁRIO: " + $F{dsc_questionario}]]></textFieldExpression>
61 
				</textField>
62 
			</band>
63 
		</groupHeader>
64 
		<groupFooter>
65 
			<band height="2">
66 
				<line>
67 
					<reportElement uuid="da930f95-61fe-4791-88aa-2ad604013920" x="0" y="1" width="555" height="1"/>
68 
					<graphicElement>
69 
						<pen lineWidth="0.5" lineStyle="Dashed"/>
70 
					</graphicElement>
71 
				</line>
72 
			</band>
73 
		</groupFooter>
74 
	</group>
75 
	<group name="secao">
76 
		<groupExpression><![CDATA[$F{nom_secao}]]></groupExpression>
77 
		<groupHeader>
78 
			<band height="29">
79 
				<printWhenExpression><![CDATA[$F{nom_secao} != null]]></printWhenExpression>
80 
				<textField>
81 
					<reportElement uuid="bad4838c-e58e-455f-bf48-bdb7188ca8f3" x="0" y="5" width="555" height="20"/>
82 
					<textElement>
83 
						<font fontName="Arial" isBold="false" isUnderline="true"/>
84 
					</textElement>
85 
					<textFieldExpression><![CDATA[$F{nom_secao}]]></textFieldExpression>
86 
				</textField>
87 
			</band>
88 
		</groupHeader>
89 
	</group>
90 
	<background>
91 
		<band splitType="Stretch"/>
92 
	</background>
93 
	<detail>
94 
		<band height="46">
95 
			<textField isStretchWithOverflow="true">
96 
				<reportElement uuid="49d922ef-d1a6-4ec0-9eb5-49ecbaefb251" x="0" y="0" width="555" height="20" isPrintWhenDetailOverflows="true"/>
97 
				<textElement>
98 
					<font fontName="Arial" size="10"/>
99 
					<paragraph spacingAfter="2"/>
100 
				</textElement>
101 
				<textFieldExpression><![CDATA[$F{num_pergunta} + ". " + $F{dsc_pergunta}]]></textFieldExpression>
102 
			</textField>
103 
			<subreport>
104 
				<reportElement uuid="e6d7e728-1c5b-4c99-9c65-e278c507fe2b" positionType="Float" x="0" y="22" width="555" height="23" isPrintWhenDetailOverflows="true"/>
105 
				<subreportParameter name="pTipoResposta">
106 
					<subreportParameterExpression><![CDATA[$F{tip_resposta}]]></subreportParameterExpression>
107 
				</subreportParameter>
108 
				<subreportParameter name="pSequencialAtendimento">
109 
					<subreportParameterExpression><![CDATA[$P{pSequencialAtendimento}]]></subreportParameterExpression>
110 
				</subreportParameter>
111 
				<subreportParameter name="pSequencialPergunta">
112 
					<subreportParameterExpression><![CDATA[$F{seq_pergunta}]]></subreportParameterExpression>
113 
				</subreportParameter>
114 
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
115 
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "prontuario_itens_resposta_pergunta_subreport.jasper"]]></subreportExpression>
116 
			</subreport>
117 
		</band>
118 
	</detail>
119 
</jasperReport>