Subversion Repositories Integrator Subversion

<?xml version="1.0" encoding="UTF-8"?>
<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" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="85db9332-5d67-469c-bb57-e16884560a4d">
        <property name="ireport.zoom" value="1.6105100000000008"/>
        <property name="ireport.x" value="0"/>
        <property name="ireport.y" value="0"/>
        <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
                <defaultValueExpression><![CDATA[""]]></defaultValueExpression>
        </parameter>
        <parameter name="pSequencialPessoaPaciente" class="java.lang.Long">
                <defaultValueExpression><![CDATA[]]></defaultValueExpression>
        </parameter>
        <parameter name="pSequencialAtendimento" class="java.lang.Long">
                <defaultValueExpression><![CDATA[]]></defaultValueExpression>
        </parameter>
        <queryString>
                <![CDATA[select * from
(select at.*,
CASE WHEN at.tip_atendimento = 'C' THEN 'CONSULTA' WHEN at.tip_atendimento = 'R' then 'RETORNO' ELSE NULL END AS TIPO_ATENDIMENTO,
pf.dsc_tratamento || ' ' || pe.nom_pessoa as profissional,
es.dsc_especialidade,
(select exists(select 1 from sc_cln.cln_atendimento_itemrespquest air where air.seq_atendimento = at.seq_atendimento)) as questionario,
(select exists(select 1 from sc_cln.cln_solicitacao_procedimento sp where sp.seq_atendimento = at.seq_atendimento)) as procedimento,
(select exists(select 1 from sc_cln.cln_atendimento_texto ap where ap.seq_atendimento = at.seq_atendimento)) as prescricao
from sc_cln.cln_atendimento at
join sc_adm.adm_pessoa pe on (at.seq_pessoa_profissional = pe.seq_pessoa)
join sc_adm.adm_pessoa_fisica pf on (pf.seq_pessoa = pe.seq_pessoa)
join sc_cln.cln_especialidade es on (es.seq_especialidade = at.seq_especialidade)
where at.seq_pessoa_paciente = $P{pSequencialPessoaPaciente} and (at.seq_atendimento = $P{pSequencialAtendimento} or $P{pSequencialAtendimento} is null)) tabela
where tabela.questionario = true or tabela.procedimento = true or tabela.prescricao = true]]>
        </queryString>
        <field name="seq_atendimento" class="java.lang.Integer"/>
        <field name="seq_agenda" class="java.lang.Integer"/>
        <field name="seq_pessoa_paciente" class="java.lang.Integer"/>
        <field name="seq_pessoa_profissional" class="java.lang.Integer"/>
        <field name="seq_especialidade" class="java.lang.Integer"/>
        <field name="tip_atendimento" class="java.lang.String"/>
        <field name="dth_inicio_atendimento" class="java.sql.Timestamp"/>
        <field name="dth_fim_atendimento" class="java.sql.Timestamp"/>
        <field name="seq_cliente" class="java.lang.Integer"/>
        <field name="tipo_atendimento" class="java.lang.String"/>
        <field name="profissional" class="java.lang.String"/>
        <field name="dsc_especialidade" class="java.lang.String"/>
        <field name="questionario" class="java.lang.Boolean"/>
        <field name="procedimento" class="java.lang.Boolean"/>
        <field name="prescricao" class="java.lang.Boolean"/>
        <background>
                <band splitType="Stretch"/>
        </background>
        <title>
                <band height="105" splitType="Stretch">
                        <subreport>
                                <reportElement positionType="Float" x="0" y="47" width="555" height="46" isPrintWhenDetailOverflows="true" uuid="34d3ac81-6c38-4c13-b4aa-bc0b54543612"/>
                                <subreportParameter name="pSequencialPessoaPaciente">
                                        <subreportParameterExpression><![CDATA[$F{seq_pessoa_paciente}]]></subreportParameterExpression>
                                </subreportParameter>
                                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "prontuario_paciente_subreport.jasper"]]></subreportExpression>
                        </subreport>
                        <subreport>
                                <reportElement x="0" y="0" width="555" height="42" uuid="8622a802-2a3a-45be-b4b0-4b1cf2336d6b"/>
                                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "subrelatorio_cabecalho.jasper"]]></subreportExpression>
                        </subreport>
                </band>
        </title>
        <detail>
                <band height="48" splitType="Stretch">
                        <textField>
                                <reportElement x="99" y="0" width="456" height="20" uuid="c61c438d-83c4-4e0f-81ed-1a3e8f11cfd3"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{tipo_atendimento} + " - " + $F{profissional} + " - " + $F{dsc_especialidade}]]></textFieldExpression>
                        </textField>
                        <textField pattern="dd/MM/yyyy HH:mm" isBlankWhenNull="true">
                                <reportElement mode="Opaque" x="0" y="0" width="88" height="20" forecolor="#FFFFFF" backcolor="#666666" uuid="a8c8dc25-a43e-463f-8505-ffb5e65c4eb9"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" isBold="false"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{dth_inicio_atendimento}]]></textFieldExpression>
                        </textField>
                        <line>
                                <reportElement x="0" y="20" width="555" height="1" forecolor="#666666" uuid="a7a83cb2-419e-4adf-abbe-1f88513196a6"/>
                                <graphicElement>
                                        <pen lineWidth="0.75"/>
                                </graphicElement>
                        </line>
                        <subreport>
                                <reportElement x="0" y="24" width="555" height="22" uuid="2170aa06-1442-4bb5-a1f5-3e0f43aca081"/>
                                <subreportParameter name="pSequencialAtendimento">
                                        <subreportParameterExpression><![CDATA[$F{seq_atendimento}]]></subreportParameterExpression>
                                </subreportParameter>
                                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "itens_prontuario_subreport.jasper"]]></subreportExpression>
                        </subreport>
                </band>
        </detail>
        <pageFooter>
                <band height="57">
                        <subreport>
                                <reportElement x="0" y="0" width="555" height="35" uuid="70117411-be4b-4b41-86cf-e7957c2b3f1e"/>
                                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "subrelatorio_rodape.jasper"]]></subreportExpression>
                        </subreport>
                </band>
        </pageFooter>
        <summary>
                <band splitType="Stretch"/>
        </summary>
</jasperReport>