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="relatorio_final" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="37eaa257-2cde-4b75-a6f3-e6bb7f994082">
        <property name="ireport.zoom" value="1.4641000000000006"/>
        <property name="ireport.x" value="0"/>
        <property name="ireport.y" value="45"/>
        <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
        <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
                <defaultValueExpression><![CDATA["C:\\REPOSITORIO\\svnPessoal\\jabti.com\\CLINICA\\clinica\\src\\main\\resources\\relatorios\\"]]></defaultValueExpression>
        </parameter>
        <parameter name="pSequencialAtendimentoTexto" class="java.lang.Long">
                <defaultValueExpression><![CDATA[]]></defaultValueExpression>
        </parameter>
        <queryString>
                <![CDATA[SELECT         s.nom_pessoa AS nom_paciente,
        i.dsc_tratamento || ' ' || p.nom_pessoa AS nom_profissional,
        a.dsc_texto AS prescricao,
        c.dsc_especialidade,
        (
        select num_documento
           from sc_adm.adm_pessoa_documento d
          where d.seq_pessoa= p.seq_pessoa
            and d.cod_tipo_documento = 3
        ) AS num_crm
FROM sc_cln.cln_atendimento_texto a
LEFT JOIN sc_cln.cln_atendimento t ON (t.seq_atendimento = a.seq_atendimento)
JOIN sc_cln.cln_especialidade c ON (c.seq_especialidade = t.seq_especialidade)
JOIN sc_adm.adm_pessoa   s ON (s.seq_pessoa = t.seq_pessoa_paciente)
JOIN sc_adm.adm_pessoa   p ON (p.seq_pessoa = t.seq_pessoa_profissional)
JOIN sc_adm.adm_pessoa_fisica   i ON (i.seq_pessoa = p.seq_pessoa)
WHERE a.seq_atendimento_texto = $P{pSequencialAtendimentoTexto}]]>
        </queryString>
        <field name="nom_paciente" class="java.lang.String"/>
        <field name="nom_profissional" class="java.lang.String"/>
        <field name="prescricao" class="java.lang.String"/>
        <field name="dsc_especialidade" class="java.lang.String"/>
        <field name="num_crm" class="java.lang.String"/>
        <background>
                <band splitType="Stretch"/>
        </background>
        <title>
                <band height="56" splitType="Stretch">
                        <subreport>
                                <reportElement x="0" y="-1" width="555" height="50" uuid="d2037ecd-09a8-4a2d-b624-3614aadd4e79">
                                        <property name="com.jaspersoft.studio.unit.height" value="pixel"/>
                                </reportElement>
                                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "subrelatorio_cabecalho.jasper"]]></subreportExpression>
                        </subreport>
                </band>
        </title>
        <detail>
                <band height="153">
                        <property name="com.jaspersoft.studio.unit.height" value="pixel"/>
                        <staticText>
                                <reportElement x="0" y="0" width="555" height="26" uuid="ec887a4d-29f4-4d9c-85b3-39483a26ebb3"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" size="11" isBold="true" pdfFontName="Helvetica-Bold"/>
                                </textElement>
                                <text><![CDATA[PRESCRIÇÃO MÉDICA]]></text>
                        </staticText>
                        <textField isStretchWithOverflow="true">
                                <reportElement stretchType="RelativeToTallestObject" x="40" y="75" width="505" height="67" isPrintWhenDetailOverflows="true" uuid="b3444d06-3802-478c-b207-290ba5d82559"/>
                                <textElement textAlignment="Justified" verticalAlignment="Top">
                                        <font fontName="Arial" size="11" isBold="false" pdfFontName="Helvetica-Bold"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{prescricao}]]></textFieldExpression>
                        </textField>
                        <staticText>
                                <reportElement x="10" y="44" width="65" height="17" uuid="ec887a4d-29f4-4d9c-85b3-39483a26ebb3"/>
                                <textElement textAlignment="Left" verticalAlignment="Middle">
                                        <font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold"/>
                                </textElement>
                                <text><![CDATA[PACIENTE:]]></text>
                        </staticText>
                        <textField>
                                <reportElement x="75" y="44" width="470" height="17" uuid="b3444d06-3802-478c-b207-290ba5d82559"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="10" isBold="false" pdfFontName="Helvetica-Bold"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{nom_paciente}]]></textFieldExpression>
                        </textField>
                </band>
                <band height="169">
                        <textField isBlankWhenNull="true">
                                <reportElement x="149" y="30" width="250" height="15" uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" size="10" isBold="false"/>
                                </textElement>
                                <textFieldExpression><![CDATA[new java.text.SimpleDateFormat("'Maceió,' dd 'de' MMMMM 'de' yyyy", new Locale("pt", "BR")).format(new java.util.Date()).toUpperCase()]]></textFieldExpression>
                        </textField>
                        <textField>
                                <reportElement x="0" y="98" width="555" height="15" uuid="b3444d06-3802-478c-b207-290ba5d82559"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" size="10" isBold="false" pdfFontName="Helvetica-Bold"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{nom_profissional}]]></textFieldExpression>
                        </textField>
                        <textField>
                                <reportElement x="0" y="113" width="555" height="15" uuid="b3444d06-3802-478c-b207-290ba5d82559"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" size="10" isBold="false" pdfFontName="Helvetica-Bold"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{dsc_especialidade}]]></textFieldExpression>
                        </textField>
                        <line>
                                <reportElement x="149" y="97" width="250" height="1" uuid="d5a0ead0-5744-4eab-8808-88473a8bd558"/>
                        </line>
                        <textField isBlankWhenNull="true">
                                <reportElement x="0" y="128" width="555" height="15" uuid="a0bba90c-79a5-40f0-acf2-61a26121fa25"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{num_crm}]]></textFieldExpression>
                        </textField>
                </band>
        </detail>
        <pageFooter>
                <band height="48" splitType="Stretch">
                        <subreport>
                                <reportElement x="0" y="0" width="555" height="35" uuid="b3dd19fd-5662-46e7-a37f-0bd6ad278a29"/>
                                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "subrelatorio_rodape.jasper"]]></subreportExpression>
                        </subreport>
                </band>
        </pageFooter>
</jasperReport>