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="84"/>
        <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
        <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
                <defaultValueExpression><![CDATA["C:\\PROJETOS CESMAC\\sic\\sic-web\\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
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"/>
        <background>
                <band splitType="Stretch"/>
        </background>
        <title>
                <band height="56" splitType="Stretch">
                        <subreport>
                                <reportElement uuid="d2037ecd-09a8-4a2d-b624-3614aadd4e79" x="0" y="-1" width="555" height="50">
                                        <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="208">
                        <property name="com.jaspersoft.studio.unit.height" value="pixel"/>
                        <rectangle>
                                <reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" x="10" y="90" width="535" height="26" backcolor="#FFFFFF"/>
                        </rectangle>
                        <staticText>
                                <reportElement uuid="ec887a4d-29f4-4d9c-85b3-39483a26ebb3" x="0" y="90" width="555" height="26"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold"/>
                                </textElement>
                                <text><![CDATA[PRESCRIÇÃO MÉDICA]]></text>
                        </staticText>
                        <textField isStretchWithOverflow="true">
                                <reportElement uuid="b3444d06-3802-478c-b207-290ba5d82559" stretchType="RelativeToTallestObject" x="30" y="170" width="495" height="15" isPrintWhenDetailOverflows="true"/>
                                <textElement textAlignment="Justified" verticalAlignment="Middle">
                                        <font fontName="Arial" size="11" isBold="false" pdfFontName="Helvetica-Bold"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{prescricao}]]></textFieldExpression>
                        </textField>
                        <line>
                                <reportElement uuid="d5a0ead0-5744-4eab-8808-88473a8bd558" x="10" y="63" width="535" height="1"/>
                        </line>
                        <staticText>
                                <reportElement uuid="ec887a4d-29f4-4d9c-85b3-39483a26ebb3" x="10" y="142" width="36" height="17"/>
                                <textElement textAlignment="Left" verticalAlignment="Middle">
                                        <font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold"/>
                                </textElement>
                                <text><![CDATA[PARA: ]]></text>
                        </staticText>
                        <textField>
                                <reportElement uuid="b3444d06-3802-478c-b207-290ba5d82559" x="10" y="25" width="535" height="15"/>
                                <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 uuid="b3444d06-3802-478c-b207-290ba5d82559" x="10" y="40" width="535" height="15"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" size="10" isBold="false" pdfFontName="Helvetica-Bold"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{dsc_especialidade}]]></textFieldExpression>
                        </textField>
                        <textField>
                                <reportElement uuid="b3444d06-3802-478c-b207-290ba5d82559" x="46" y="142" width="408" height="17"/>
                                <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 uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="149" y="30" width="250" height="15"/>
                                <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>
                </band>
        </detail>
        <pageFooter>
                <band height="15" splitType="Stretch">
                        <textField isBlankWhenNull="true">
                                <reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="0" y="0" width="208" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6" isBold="false"/>
                                </textElement>
                                <textFieldExpression><![CDATA[new java.text.SimpleDateFormat("'Gerado em ' dd 'de' MMMMM 'de' yyyy ' às ' HH:mm", new Locale("pt", "BR")).format(new java.util.Date()).toUpperCase()]]></textFieldExpression>
                        </textField>
                        <textField isBlankWhenNull="false">
                                <reportElement uuid="e5f06c72-11c0-479b-b234-4dcaf2bc0440" key="textField" x="430" y="0" width="73" height="15"/>
                                <textElement textAlignment="Right" verticalAlignment="Middle">
                                        <font fontName="Arial" size="6" isBold="false"/>
                                </textElement>
                                <textFieldExpression><![CDATA["PÁGINA " + $V{PAGE_NUMBER} + " DE "]]></textFieldExpression>
                        </textField>
                        <textField evaluationTime="Report" isBlankWhenNull="false">
                                <reportElement uuid="506b9991-ff6d-43b5-ab78-2832586c3dda" key="textField" x="503" y="0" width="52" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6" isBold="false"/>
                                </textElement>
                                <textFieldExpression><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
                        </textField>
                        <line>
                                <reportElement uuid="d5a0ead0-5744-4eab-8808-88473a8bd558" x="149" y="-74" width="250" height="1"/>
                        </line>
                        <staticText>
                                <reportElement uuid="f96a240e-1e2a-4333-ac5e-0539ce887d4b" x="149" y="-72" width="250" height="20"/>
                                <textElement textAlignment="Center"/>
                                <text><![CDATA[Assinatura do Médico]]></text>
                        </staticText>
                </band>
        </pageFooter>
</jasperReport>