Subversion Repositories Integrator Subversion

Rev

Rev 182 | Blame | Compare with Previous | Last modification | View Log | Download | RSS feed 

<?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_solicitacao_procedimento" 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="0"/>
        <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="pSequencialAtendimentoAtendimento" 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_observacao,
        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,
        r.dsc_procedimento
FROM sc_cln.cln_solicitacao_procedimento a
LEFT JOIN sc_cln.cln_atendimento t ON (t.seq_atendimento = a.seq_atendimento)
LEFT JOIN sc_cln.cln_procedimento r ON (r.seq_procedimento = a.seq_Procedimento)
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_solicitacao_procedimento = $P{pSequencialAtendimentoAtendimento}]]>
        </queryString>
        <field name="nom_paciente" class="java.lang.String"/>
        <field name="nom_profissional" class="java.lang.String"/>
        <field name="dsc_observacao" class="java.lang.String"/>
        <field name="dsc_especialidade" class="java.lang.String"/>
        <field name="num_crm" class="java.lang.String"/>
        <field name="dsc_procedimento" 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="176">
                        <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[SOLICITAÇÃO DE PROCEDIMENTO]]></text>
                        </staticText>
                        <textField isStretchWithOverflow="true">
                                <reportElement stretchType="RelativeToTallestObject" x="31" y="130" width="497" height="46" 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{dsc_observacao}]]></textFieldExpression>
                        </textField>
                        <staticText>
                                <reportElement x="14" y="44" width="61" height="17" uuid="ec887a4d-29f4-4d9c-85b3-39483a26ebb3"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="11" isBold="true" pdfFontName="Helvetica-Bold"/>
                                </textElement>
                                <text><![CDATA[PACIENTE:]]></text>
                        </staticText>
                        <textField>
                                <reportElement x="75" y="44" width="434" height="17" uuid="b3444d06-3802-478c-b207-290ba5d82559"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="11" isBold="false" pdfFontName="Helvetica-Bold"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{nom_paciente}]]></textFieldExpression>
                        </textField>
                        <textField isStretchWithOverflow="true">
                                <reportElement stretchType="RelativeToTallestObject" x="31" y="89" width="497" height="17" isPrintWhenDetailOverflows="true" uuid="26994ed0-70ab-4209-9c61-cf8be6d1c811"/>
                                <textElement textAlignment="Justified" verticalAlignment="Middle">
                                        <font fontName="Arial" size="11" isBold="false" pdfFontName="Helvetica-Bold"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{dsc_procedimento}]]></textFieldExpression>
                        </textField>
                        <staticText>
                                <reportElement x="14" y="72" width="101" height="17" uuid="6a1561e1-f639-45a6-924a-b0e25022e03a"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="11" isBold="true" pdfFontName="Helvetica-Bold"/>
                                </textElement>
                                <text><![CDATA[PROCEDIMENTO:]]></text>
                        </staticText>
                        <staticText>
                                <reportElement x="14" y="113" width="101" height="17" uuid="5008d339-3d0a-49de-a2ea-bc0e0a8d5380"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="11" isBold="true" pdfFontName="Helvetica-Bold"/>
                                </textElement>
                                <text><![CDATA[OBSERVAÇÃO:]]></text>
                        </staticText>
                </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="46" 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>