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="Relatório Quantitativo de Cargo" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="a9bd3a8d-3d73-4ab7-8540-556997aa680b">
        <property name="ireport.zoom" value="1.5"/>
        <property name="ireport.x" value="0"/>
        <property name="ireport.y" value="0"/>
        <style name="table">
                <box>
                        <pen lineWidth="1.0" lineColor="#000000"/>
                </box>
        </style>
        <style name="table_TH" mode="Opaque" backcolor="#F0F8FF">
                <box>
                        <pen lineWidth="0.5" lineColor="#000000"/>
                </box>
        </style>
        <style name="table_CH" mode="Opaque" backcolor="#BFE1FF">
                <box>
                        <pen lineWidth="0.5" lineColor="#000000"/>
                </box>
        </style>
        <style name="table_TD" mode="Opaque" backcolor="#FFFFFF">
                <box>
                        <pen lineWidth="0.5" lineColor="#000000"/>
                </box>
        </style>
        <style name="table 1">
                <box>
                        <pen lineWidth="1.0" lineColor="#000000"/>
                </box>
        </style>
        <style name="table 1_TH" mode="Opaque" backcolor="#F0F8FF">
                <box>
                        <pen lineWidth="0.5" lineColor="#000000"/>
                </box>
        </style>
        <style name="table 1_CH" mode="Opaque" backcolor="#BFE1FF">
                <box>
                        <pen lineWidth="0.5" lineColor="#000000"/>
                </box>
        </style>
        <style name="table 1_TD" mode="Opaque" backcolor="#FFFFFF">
                <box>
                        <pen lineWidth="0.5" lineColor="#000000"/>
                </box>
        </style>
        <style name="table 2">
                <box>
                        <pen lineWidth="1.0" lineColor="#000000"/>
                </box>
        </style>
        <style name="table 2_TH" mode="Opaque" backcolor="#F0F8FF">
                <box>
                        <pen lineWidth="0.5" lineColor="#000000"/>
                </box>
        </style>
        <style name="table 2_CH" mode="Opaque" backcolor="#BFE1FF">
                <box>
                        <pen lineWidth="0.5" lineColor="#000000"/>
                </box>
        </style>
        <style name="table 2_TD" mode="Opaque" backcolor="#FFFFFF">
                <box>
                        <pen lineWidth="0.5" lineColor="#000000"/>
                </box>
        </style>
        <style name="table 3">
                <box>
                        <pen lineWidth="1.0" lineColor="#000000"/>
                </box>
        </style>
        <style name="table 3_TH" mode="Opaque" backcolor="#C3CFD9">
                <box>
                        <pen lineWidth="0.5" lineColor="#000000"/>
                </box>
        </style>
        <style name="table 3_CH" mode="Opaque" backcolor="#E6F3FF">
                <box>
                        <pen lineWidth="0.5" lineColor="#000000"/>
                </box>
        </style>
        <style name="table 3_TD" mode="Opaque" backcolor="#FFFFFF">
                <box>
                        <pen lineWidth="0.5" lineColor="#000000"/>
                </box>
        </style>
        <style name="table 4">
                <box>
                        <pen lineWidth="1.0" lineColor="#000000"/>
                </box>
        </style>
        <style name="table 4_TH" mode="Opaque" backcolor="#73B0E6">
                <box>
                        <pen lineWidth="0.5" lineColor="#000000"/>
                </box>
        </style>
        <style name="table 4_CH" mode="Opaque" backcolor="#CCCCCC">
                <box>
                        <pen lineWidth="0.5" lineColor="#000000"/>
                </box>
        </style>
        <style name="table 4_TD" mode="Opaque" backcolor="#FFFFFF">
                <box>
                        <pen lineWidth="0.5" lineColor="#000000"/>
                </box>
                <conditionalStyle>
                        <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression>
                        <style backcolor="#F3F6F8"/>
                </conditionalStyle>
        </style>
        <subDataset name="cargo" uuid="1f630ccf-43ed-4d8b-922e-8110d812cc30">
                <queryString>
                        <![CDATA[        SELECT
            c.cod_cargo,
            c.dsc_cargo,
            c.cod_grau_instrucao,
            c.num_quantidade_vagas,
            c.ind_ativo,
            (
                SELECT  count(cod_cargo) as total FROM (
                (SELECT seq_servidor_dadofuncional, cod_cargo FROM sc_srv.srv_serdadfuncon_prestprocselet ps)
                UNION
                (SELECT mc.seq_servidor_dadofuncional, cod_cargo FROM sc_srv.srv_serdadfunmat_carreira mc INNER JOIN sc_srv.srv_servdadofunc_matricula dfm on (dfm.seq_servidor_dadofuncional=mc.seq_servidor_dadofuncional) WHERE dfm.cod_situacao_servidor = 1)
                ) mc
                WHERE mc.cod_cargo = c.cod_cargo
            ) as vagas_ocupadas,
            (
                SELECT count(cod_cargo) as total FROM (
                    (SELECT seq_servidor_dadofuncional, cod_cargo FROM sc_srv.srv_serdadfuncon_prestprocselet ps)
                    UNION
                    (SELECT mc.seq_servidor_dadofuncional, cod_cargo FROM sc_srv.srv_serdadfunmat_carreira mc INNER JOIN sc_srv.srv_servdadofunc_matricula dfm on (dfm.seq_servidor_dadofuncional=mc.seq_servidor_dadofuncional) WHERE dfm.cod_situacao_servidor = 1)
                ) mc
                INNER JOIN sc_srv.srv_servidor_dadofuncional df on (mc.seq_servidor_dadofuncional=df.seq_servidor_dadofuncional)
                LEFT JOIN sc_srv.srv_servdadofunc_matricula dfm on (df.seq_servidor_dadofuncional=dfm.seq_servidor_dadofuncional and dfm.cod_situacao_servidor = 1)
                INNER JOIN sc_srv.srv_forma_ingresso fi on (fi.cod_forma_ingresso=df.cod_forma_ingresso)
                WHERE fi.tip_vinculo_forma_ingresso = 'E' and mc.cod_cargo = c.cod_cargo
            ) as vagas_ocupadas_efetivo,
            (
                SELECT count(cod_cargo) as total FROM (
                    (SELECT seq_servidor_dadofuncional, cod_cargo FROM sc_srv.srv_serdadfuncon_prestprocselet ps)
                    UNION
                    (SELECT mc.seq_servidor_dadofuncional, cod_cargo FROM sc_srv.srv_serdadfunmat_carreira mc INNER JOIN sc_srv.srv_servdadofunc_matricula dfm on (dfm.seq_servidor_dadofuncional=mc.seq_servidor_dadofuncional) WHERE dfm.cod_situacao_servidor = 1)
                ) mc
                INNER JOIN sc_srv.srv_servidor_dadofuncional df on (mc.seq_servidor_dadofuncional=df.seq_servidor_dadofuncional)
                LEFT JOIN sc_srv.srv_servdadofunc_matricula dfm on (df.seq_servidor_dadofuncional=dfm.seq_servidor_dadofuncional and dfm.cod_situacao_servidor = 1)
                INNER JOIN sc_srv.srv_forma_ingresso fi on (fi.cod_forma_ingresso=df.cod_forma_ingresso)
                WHERE fi.tip_vinculo_forma_ingresso = 'T' and mc.cod_cargo = c.cod_cargo
            ) as vagas_ocupadas_contratado,
            (
                SELECT count(cod_cargo) as total FROM (
                    (SELECT seq_servidor_dadofuncional, cod_cargo FROM sc_srv.srv_serdadfuncon_prestprocselet ps)
                    UNION
                    (SELECT mc.seq_servidor_dadofuncional, cod_cargo FROM sc_srv.srv_serdadfunmat_carreira mc INNER JOIN sc_srv.srv_servdadofunc_matricula dfm on (dfm.seq_servidor_dadofuncional=mc.seq_servidor_dadofuncional) WHERE dfm.cod_situacao_servidor = 1)
                ) mc
                INNER JOIN sc_srv.srv_servidor_dadofuncional df on (mc.seq_servidor_dadofuncional=df.seq_servidor_dadofuncional)
                LEFT JOIN sc_srv.srv_servdadofunc_matricula dfm on (df.seq_servidor_dadofuncional=dfm.seq_servidor_dadofuncional and dfm.cod_situacao_servidor = 1)
                INNER JOIN sc_srv.srv_forma_ingresso fi on (fi.cod_forma_ingresso=df.cod_forma_ingresso)
                WHERE fi.tip_vinculo_forma_ingresso = 'L' and mc.cod_cargo = c.cod_cargo
            ) as vagas_ocupadas_celetista,
            (
                SELECT count(cod_cargo) as total FROM (
                    (SELECT seq_servidor_dadofuncional, cod_cargo FROM sc_srv.srv_serdadfuncon_prestprocselet ps)
                    UNION
                    (SELECT mc.seq_servidor_dadofuncional, cod_cargo FROM sc_srv.srv_serdadfunmat_carreira mc INNER JOIN sc_srv.srv_servdadofunc_matricula dfm on (dfm.seq_servidor_dadofuncional=mc.seq_servidor_dadofuncional) WHERE dfm.cod_situacao_servidor = 1)
                ) mc
                INNER JOIN sc_srv.srv_servidor_dadofuncional df on (mc.seq_servidor_dadofuncional=df.seq_servidor_dadofuncional)
                LEFT JOIN sc_srv.srv_servdadofunc_matricula dfm on (df.seq_servidor_dadofuncional=dfm.seq_servidor_dadofuncional and dfm.cod_situacao_servidor = 1)
                INNER JOIN sc_srv.srv_forma_ingresso fi on (fi.cod_forma_ingresso=df.cod_forma_ingresso)
                WHERE fi.tip_vinculo_forma_ingresso = 'C' and mc.cod_cargo = c.cod_cargo
            ) as vagas_ocupadas_comissionado,
            (
                 (num_quantidade_vagas) -
                 (
                    SELECT  count(cod_cargo) as total FROM (
                    (SELECT seq_servidor_dadofuncional, cod_cargo FROM sc_srv.srv_serdadfuncon_prestprocselet ps)
                    UNION
                    (SELECT mc.seq_servidor_dadofuncional, cod_cargo FROM sc_srv.srv_serdadfunmat_carreira mc INNER JOIN sc_srv.srv_servdadofunc_matricula dfm on (dfm.seq_servidor_dadofuncional=mc.seq_servidor_dadofuncional) WHERE dfm.cod_situacao_servidor = 1)
                    ) mc
                    WHERE mc.cod_cargo = c.cod_cargo
                 )
            )as saldo_vagas,
            (
                SELECT sum(num_quantidade_vagas) as total FROM sc_srv.srv_cargo c
            ) as total_vagas_disponiveis,
            (
                SELECT  count(cod_cargo) as total FROM (
                    (SELECT seq_servidor_dadofuncional, cod_cargo FROM sc_srv.srv_serdadfuncon_prestprocselet ps)
                    UNION
                    (SELECT mc.seq_servidor_dadofuncional, cod_cargo FROM sc_srv.srv_serdadfunmat_carreira mc INNER JOIN sc_srv.srv_servdadofunc_matricula dfm on (dfm.seq_servidor_dadofuncional=mc.seq_servidor_dadofuncional) WHERE dfm.cod_situacao_servidor = 1)
                ) mc
            )as total_vagas_ocupadas,
            (
                (SELECT sum(num_quantidade_vagas) as total FROM sc_srv.srv_cargo c) -
                (SELECT  count(cod_cargo) as total FROM (
                    (SELECT seq_servidor_dadofuncional, cod_cargo FROM sc_srv.srv_serdadfuncon_prestprocselet ps)
                    UNION
                    (SELECT mc.seq_servidor_dadofuncional, cod_cargo FROM sc_srv.srv_serdadfunmat_carreira mc INNER JOIN sc_srv.srv_servdadofunc_matricula dfm on (dfm.seq_servidor_dadofuncional=mc.seq_servidor_dadofuncional) WHERE dfm.cod_situacao_servidor = 1)
                ) mc)
            )as total_saldo_vagas
            FROM sc_srv.srv_cargo c
            ORDER BY c.dsc_cargo]]>
                </queryString>
                <field name="cod_cargo" class="java.math.BigDecimal"/>
                <field name="dsc_cargo" class="java.lang.String"/>
                <field name="cod_grau_instrucao" class="java.math.BigDecimal"/>
                <field name="num_quantidade_vagas" class="java.math.BigDecimal"/>
                <field name="ind_ativo" class="java.lang.Boolean"/>
                <field name="vagas_ocupadas" class="java.lang.Long"/>
                <field name="vagas_ocupadas_efetivo" class="java.lang.Long"/>
                <field name="vagas_ocupadas_contratado" class="java.lang.Long"/>
                <field name="vagas_ocupadas_celetista" class="java.lang.Long"/>
                <field name="vagas_ocupadas_comissionado" class="java.lang.Long"/>
                <field name="saldo_vagas" class="java.math.BigDecimal"/>
                <field name="total_vagas_disponiveis" class="java.math.BigDecimal"/>
                <field name="total_vagas_ocupadas" class="java.lang.Long"/>
                <field name="total_saldo_vagas" class="java.math.BigDecimal"/>
        </subDataset>
        <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
                <defaultValueExpression><![CDATA[""]]></defaultValueExpression>
        </parameter>
        <parameter name="IMAGE_DIR" class="java.lang.String" isForPrompting="false">
                <defaultValueExpression><![CDATA[""]]></defaultValueExpression>
        </parameter>
        <queryString>
                <![CDATA[SELECT * FROM sc_srv.srv_cargo c limit 1]]>
        </queryString>
        <field name="cod_cargo" class="java.math.BigDecimal"/>
        <field name="dsc_cargo" class="java.lang.String"/>
        <field name="cod_grau_instrucao" class="java.math.BigDecimal"/>
        <field name="num_quantidade_vagas" class="java.math.BigDecimal"/>
        <field name="ind_ativo" class="java.lang.Boolean"/>
        <background>
                <band splitType="Stretch"/>
        </background>
        <pageHeader>
                <band height="149">
                        <image hAlign="Right">
                                <reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" x="251" y="2" width="48" height="59" isPrintWhenDetailOverflows="true"/>
                                <imageExpression><![CDATA[$P{IMAGE_DIR} + "brasao.jpg"]]></imageExpression>
                        </image>
                        <staticText>
                                <reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="62" width="555" height="39" isPrintWhenDetailOverflows="true"/>
                                <textElement textAlignment="Center" verticalAlignment="Top">
                                        <font fontName="Arial" size="10" isBold="true"/>
                                </textElement>
                                <text><![CDATA[ESTADO DE ALAGOAS
SECRETARIA DE ESTADO DA SAÚDE DE ALAGOAS
RELATÓRIO DE ACOMPANHAMENTO DO SERVIDOR - QUANTITATIVO DE CARGO ]]></text>
                        </staticText>
                </band>
        </pageHeader>
        <columnHeader>
                <band height="15">
                        <rectangle>
                                <reportElement uuid="423b9a10-6789-4023-9a4d-1cd8ecd4119f" positionType="Float" x="0" y="0" width="555" height="15" backcolor="#CCCCCC"/>
                        </rectangle>
                        <staticText>
                                <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" positionType="Float" mode="Transparent" x="0" y="0" width="555" height="15" backcolor="#CCCCCC"/>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                        <font fontName="Arial" size="8" isBold="true"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <text><![CDATA[QUANTITATIVO DE CARGO]]></text>
                        </staticText>
                </band>
        </columnHeader>
        <detail>
                <band height="31">
                        <componentElement>
                                <reportElement uuid="b47b342c-8a71-49ca-bb46-b988458f296d" key="table 4" style="table 4" x="0" y="0" width="555" height="30"/>
                                <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">
                                        <datasetRun subDataset="cargo" uuid="1259ba1a-f4f9-4a38-b8c5-cdef26240f7b">
                                                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                        </datasetRun>
                                        <jr:column uuid="aff272c8-83bc-4ebb-8cdd-03a6c63f87cf" width="168">
                                                <jr:columnHeader style="table 4_CH" height="30" rowSpan="2">
                                                        <staticText>
                                                                <reportElement uuid="8529343e-13a9-4b89-96e0-6a23332ad3fa" x="0" y="0" width="168" height="29"/>
                                                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                        <font fontName="Arial" size="8"/>
                                                                </textElement>
                                                                <text><![CDATA[CARGO]]></text>
                                                        </staticText>
                                                </jr:columnHeader>
                                                <jr:columnFooter height="15" rowSpan="1">
                                                        <staticText>
                                                                <reportElement uuid="8529343e-13a9-4b89-96e0-6a23332ad3fa" x="0" y="0" width="166" height="15"/>
                                                                <textElement textAlignment="Right" verticalAlignment="Middle">
                                                                        <font fontName="Arial" size="8"/>
                                                                </textElement>
                                                                <text><![CDATA[TOTAL GERAL:]]></text>
                                                        </staticText>
                                                </jr:columnFooter>
                                                <jr:detailCell style="table 4_TD" height="15" rowSpan="1">
                                                        <textField isBlankWhenNull="true">
                                                                <reportElement uuid="3cef8170-70cd-4c9b-8656-d182be3eafb9" x="2" y="0" width="166" height="15"/>
                                                                <textElement verticalAlignment="Middle">
                                                                        <font fontName="Arial" size="8"/>
                                                                        <paragraph leftIndent="5"/>
                                                                </textElement>
                                                                <textFieldExpression><![CDATA[$F{dsc_cargo}]]></textFieldExpression>
                                                        </textField>
                                                </jr:detailCell>
                                        </jr:column>
                                        <jr:column uuid="50b52ef6-139c-45f4-9248-cae52f3479c2" width="57">
                                                <jr:columnHeader style="table 4_CH" height="30" rowSpan="2">
                                                        <staticText>
                                                                <reportElement uuid="bbdf9964-9ffb-4235-99e5-1169493a9c00" x="0" y="0" width="56" height="29"/>
                                                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                        <font fontName="Arial" size="8"/>
                                                                </textElement>
                                                                <text><![CDATA[DISPONÍVEL]]></text>
                                                        </staticText>
                                                </jr:columnHeader>
                                                <jr:columnFooter style="table 4_TD" height="15" rowSpan="1">
                                                        <textField isBlankWhenNull="true">
                                                                <reportElement uuid="81eb3242-862b-4b39-8808-c8eadd11a675" x="0" y="0" width="57" height="15"/>
                                                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                        <font fontName="Arial" size="8"/>
                                                                </textElement>
                                                                <textFieldExpression><![CDATA[$F{total_vagas_disponiveis}]]></textFieldExpression>
                                                        </textField>
                                                </jr:columnFooter>
                                                <jr:detailCell style="table 4_TD" height="15" rowSpan="1">
                                                        <textField isBlankWhenNull="true">
                                                                <reportElement uuid="81eb3242-862b-4b39-8808-c8eadd11a675" x="0" y="0" width="57" height="15"/>
                                                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                        <font fontName="Arial" size="8"/>
                                                                </textElement>
                                                                <textFieldExpression><![CDATA[$F{num_quantidade_vagas}]]></textFieldExpression>
                                                        </textField>
                                                </jr:detailCell>
                                        </jr:column>
                                        <jr:columnGroup uuid="bdab4877-6e8b-4a41-82ab-e608d3264385" width="278">
                                                <jr:columnHeader style="table 4_CH" height="15" rowSpan="1">
                                                        <staticText>
                                                                <reportElement uuid="8529343e-13a9-4b89-96e0-6a23332ad3fa" x="0" y="0" width="278" height="15"/>
                                                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                        <font fontName="Arial" size="8"/>
                                                                </textElement>
                                                                <text><![CDATA[OCUPADOS]]></text>
                                                        </staticText>
                                                </jr:columnHeader>
                                                <jr:column uuid="147b4d65-f829-413d-8150-77f58a82f703" width="45">
                                                        <jr:columnHeader style="table 4_CH" height="15" rowSpan="1">
                                                                <staticText>
                                                                        <reportElement uuid="48e9acab-2d3e-41f9-84a5-78fb3f9d5162" x="0" y="0" width="45" height="15"/>
                                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                                <font fontName="Arial" size="8"/>
                                                                        </textElement>
                                                                        <text><![CDATA[EFETIVO]]></text>
                                                                </staticText>
                                                        </jr:columnHeader>
                                                        <jr:detailCell style="table 4_TD" height="15" rowSpan="1">
                                                                <textField isBlankWhenNull="true">
                                                                        <reportElement uuid="a31549cf-e7bf-487a-aab7-6ed304b5d0a6" x="0" y="0" width="45" height="15"/>
                                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                                <font fontName="Arial" size="8"/>
                                                                        </textElement>
                                                                        <textFieldExpression><![CDATA[$F{vagas_ocupadas_efetivo}]]></textFieldExpression>
                                                                </textField>
                                                        </jr:detailCell>
                                                </jr:column>
                                                <jr:column uuid="549cfcdc-5050-448f-9cce-51fae7662d96" width="68">
                                                        <jr:columnHeader style="table 4_CH" height="15" rowSpan="1">
                                                                <staticText>
                                                                        <reportElement uuid="21dc8aa6-93eb-418e-a847-06e800d13415" x="0" y="0" width="68" height="15"/>
                                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                                <font fontName="Arial" size="8"/>
                                                                        </textElement>
                                                                        <text><![CDATA[CONTRATADO]]></text>
                                                                </staticText>
                                                        </jr:columnHeader>
                                                        <jr:detailCell style="table 4_TD" height="15" rowSpan="1">
                                                                <textField isBlankWhenNull="true">
                                                                        <reportElement uuid="578defa1-209a-4fde-bc68-4f1e1414a191" x="0" y="0" width="68" height="15"/>
                                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                                <font fontName="Arial" size="8"/>
                                                                        </textElement>
                                                                        <textFieldExpression><![CDATA[$F{vagas_ocupadas_contratado}]]></textFieldExpression>
                                                                </textField>
                                                        </jr:detailCell>
                                                </jr:column>
                                                <jr:column uuid="76cc1172-0231-4c91-9a55-c89a447cb080" width="55">
                                                        <jr:columnHeader style="table 4_CH" height="15" rowSpan="1">
                                                                <staticText>
                                                                        <reportElement uuid="23dde1c5-895f-4a05-ae31-a8ed03c7bc32" x="0" y="0" width="55" height="15"/>
                                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                                <font fontName="Arial" size="8"/>
                                                                        </textElement>
                                                                        <text><![CDATA[CELETISTA]]></text>
                                                                </staticText>
                                                        </jr:columnHeader>
                                                        <jr:detailCell style="table 4_TD" height="15" rowSpan="1">
                                                                <textField isBlankWhenNull="true">
                                                                        <reportElement uuid="abb85749-c2b1-41b6-927d-47de0026ace6" x="0" y="0" width="55" height="15"/>
                                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                                <font fontName="Arial" size="8"/>
                                                                        </textElement>
                                                                        <textFieldExpression><![CDATA[$F{vagas_ocupadas_celetista}]]></textFieldExpression>
                                                                </textField>
                                                        </jr:detailCell>
                                                </jr:column>
                                                <jr:column uuid="9cce8866-5f51-414c-83a0-dd661030f445" width="70">
                                                        <jr:columnHeader style="table 4_CH" height="15" rowSpan="1">
                                                                <staticText>
                                                                        <reportElement uuid="919b6ac5-44ad-4346-a23f-e49c252a494a" x="0" y="0" width="70" height="15"/>
                                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                                <font fontName="Arial" size="8"/>
                                                                        </textElement>
                                                                        <text><![CDATA[COMISSIONADO]]></text>
                                                                </staticText>
                                                        </jr:columnHeader>
                                                        <jr:detailCell style="table 4_TD" height="15" rowSpan="1">
                                                                <textField isBlankWhenNull="true">
                                                                        <reportElement uuid="84577288-4e62-4a25-bb82-7704551ed199" x="0" y="0" width="70" height="15"/>
                                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                                <font fontName="Arial" size="8"/>
                                                                        </textElement>
                                                                        <textFieldExpression><![CDATA[$F{vagas_ocupadas_comissionado}]]></textFieldExpression>
                                                                </textField>
                                                        </jr:detailCell>
                                                </jr:column>
                                                <jr:column uuid="6857a4da-491b-47c3-b888-fa8dfbc068b4" width="40">
                                                        <jr:columnHeader style="table 4_CH" height="15" rowSpan="1">
                                                                <staticText>
                                                                        <reportElement uuid="09cca298-27f6-4ccc-805f-ab012f0e4772" x="0" y="0" width="40" height="15"/>
                                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                                <font fontName="Arial" size="8"/>
                                                                        </textElement>
                                                                        <text><![CDATA[TOTAL]]></text>
                                                                </staticText>
                                                        </jr:columnHeader>
                                                        <jr:columnFooter style="table 4_TD" height="15" rowSpan="1">
                                                                <textField isBlankWhenNull="true">
                                                                        <reportElement uuid="81eb3242-862b-4b39-8808-c8eadd11a675" x="0" y="0" width="40" height="15"/>
                                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                                <font fontName="Arial" size="8"/>
                                                                        </textElement>
                                                                        <textFieldExpression><![CDATA[$F{total_vagas_ocupadas}]]></textFieldExpression>
                                                                </textField>
                                                        </jr:columnFooter>
                                                        <jr:detailCell style="table 4_TD" height="15" rowSpan="1">
                                                                <textField isBlankWhenNull="true">
                                                                        <reportElement uuid="12b462cd-18cb-41f3-b2e8-94b4a3a69228" x="0" y="0" width="40" height="15"/>
                                                                        <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                                <font fontName="Arial" size="8"/>
                                                                        </textElement>
                                                                        <textFieldExpression><![CDATA[$F{vagas_ocupadas}]]></textFieldExpression>
                                                                </textField>
                                                        </jr:detailCell>
                                                </jr:column>
                                        </jr:columnGroup>
                                        <jr:column uuid="247c6b4d-ca24-49be-b93a-a2b1d1784a46" width="52">
                                                <jr:columnHeader style="table 4_CH" height="30" rowSpan="2">
                                                        <staticText>
                                                                <reportElement uuid="f7e16292-cff0-4b71-a32a-9519ae0d2f58" x="0" y="0" width="49" height="29"/>
                                                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                        <font fontName="Arial" size="8"/>
                                                                </textElement>
                                                                <text><![CDATA[SALDO]]></text>
                                                        </staticText>
                                                </jr:columnHeader>
                                                <jr:columnFooter style="table 4_TD" height="15" rowSpan="1">
                                                        <textField isBlankWhenNull="true">
                                                                <reportElement uuid="81eb3242-862b-4b39-8808-c8eadd11a675" x="0" y="0" width="50" height="15"/>
                                                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                        <font fontName="Arial" size="8"/>
                                                                </textElement>
                                                                <textFieldExpression><![CDATA[$F{total_saldo_vagas}]]></textFieldExpression>
                                                        </textField>
                                                </jr:columnFooter>
                                                <jr:detailCell style="table 4_TD" height="15" rowSpan="1">
                                                        <textField isBlankWhenNull="true">
                                                                <reportElement uuid="49a04eb7-3661-4af8-a16e-5f92d25ef6d8" x="0" y="0" width="50" height="15"/>
                                                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                                                        <font fontName="Arial" size="8"/>
                                                                </textElement>
                                                                <textFieldExpression><![CDATA[$F{saldo_vagas}]]></textFieldExpression>
                                                        </textField>
                                                </jr:detailCell>
                                        </jr:column>
                                </jr:table>
                        </componentElement>
                </band>
        </detail>
        <pageFooter>
                <band height="33">
                        <textField evaluationTime="Report" isBlankWhenNull="false">
                                <reportElement uuid="506b9991-ff6d-43b5-ab78-2832586c3dda" key="textField" x="496" y="10" width="52" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6" isBold="false"/>
                                </textElement>
                                <textFieldExpression><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
                        </textField>
                        <textField isBlankWhenNull="false">
                                <reportElement uuid="e5f06c72-11c0-479b-b234-4dcaf2bc0440" key="textField" x="421" y="10" 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 isBlankWhenNull="true">
                                <reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="0" y="10" width="289" 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>
                </band>
        </pageFooter>
        <summary>
                <band height="11"/>
        </summary>
</jasperReport>