Details | Last modification | View Log | RSS feed
| Rev | Author | Line No. | Line |
|---|---|---|---|
| 1 | espaco | 1 | <?xml version="1.0" encoding="UTF-8"?> |
| 2 | <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"> |
||
| 3 | <property name="ireport.zoom" value="1.5"/> |
||
| 4 | <property name="ireport.x" value="0"/> |
||
| 5 | <property name="ireport.y" value="0"/> |
||
| 6 | <style name="table"> |
||
| 7 | <box> |
||
| 8 | <pen lineWidth="1.0" lineColor="#000000"/> |
||
| 9 | </box> |
||
| 10 | </style> |
||
| 11 | <style name="table_TH" mode="Opaque" backcolor="#F0F8FF"> |
||
| 12 | <box> |
||
| 13 | <pen lineWidth="0.5" lineColor="#000000"/> |
||
| 14 | </box> |
||
| 15 | </style> |
||
| 16 | <style name="table_CH" mode="Opaque" backcolor="#BFE1FF"> |
||
| 17 | <box> |
||
| 18 | <pen lineWidth="0.5" lineColor="#000000"/> |
||
| 19 | </box> |
||
| 20 | </style> |
||
| 21 | <style name="table_TD" mode="Opaque" backcolor="#FFFFFF"> |
||
| 22 | <box> |
||
| 23 | <pen lineWidth="0.5" lineColor="#000000"/> |
||
| 24 | </box> |
||
| 25 | </style> |
||
| 26 | <style name="table 1"> |
||
| 27 | <box> |
||
| 28 | <pen lineWidth="1.0" lineColor="#000000"/> |
||
| 29 | </box> |
||
| 30 | </style> |
||
| 31 | <style name="table 1_TH" mode="Opaque" backcolor="#F0F8FF"> |
||
| 32 | <box> |
||
| 33 | <pen lineWidth="0.5" lineColor="#000000"/> |
||
| 34 | </box> |
||
| 35 | </style> |
||
| 36 | <style name="table 1_CH" mode="Opaque" backcolor="#BFE1FF"> |
||
| 37 | <box> |
||
| 38 | <pen lineWidth="0.5" lineColor="#000000"/> |
||
| 39 | </box> |
||
| 40 | </style> |
||
| 41 | <style name="table 1_TD" mode="Opaque" backcolor="#FFFFFF"> |
||
| 42 | <box> |
||
| 43 | <pen lineWidth="0.5" lineColor="#000000"/> |
||
| 44 | </box> |
||
| 45 | </style> |
||
| 46 | <style name="table 2"> |
||
| 47 | <box> |
||
| 48 | <pen lineWidth="1.0" lineColor="#000000"/> |
||
| 49 | </box> |
||
| 50 | </style> |
||
| 51 | <style name="table 2_TH" mode="Opaque" backcolor="#F0F8FF"> |
||
| 52 | <box> |
||
| 53 | <pen lineWidth="0.5" lineColor="#000000"/> |
||
| 54 | </box> |
||
| 55 | </style> |
||
| 56 | <style name="table 2_CH" mode="Opaque" backcolor="#BFE1FF"> |
||
| 57 | <box> |
||
| 58 | <pen lineWidth="0.5" lineColor="#000000"/> |
||
| 59 | </box> |
||
| 60 | </style> |
||
| 61 | <style name="table 2_TD" mode="Opaque" backcolor="#FFFFFF"> |
||
| 62 | <box> |
||
| 63 | <pen lineWidth="0.5" lineColor="#000000"/> |
||
| 64 | </box> |
||
| 65 | </style> |
||
| 66 | <style name="table 3"> |
||
| 67 | <box> |
||
| 68 | <pen lineWidth="1.0" lineColor="#000000"/> |
||
| 69 | </box> |
||
| 70 | </style> |
||
| 71 | <style name="table 3_TH" mode="Opaque" backcolor="#C3CFD9"> |
||
| 72 | <box> |
||
| 73 | <pen lineWidth="0.5" lineColor="#000000"/> |
||
| 74 | </box> |
||
| 75 | </style> |
||
| 76 | <style name="table 3_CH" mode="Opaque" backcolor="#E6F3FF"> |
||
| 77 | <box> |
||
| 78 | <pen lineWidth="0.5" lineColor="#000000"/> |
||
| 79 | </box> |
||
| 80 | </style> |
||
| 81 | <style name="table 3_TD" mode="Opaque" backcolor="#FFFFFF"> |
||
| 82 | <box> |
||
| 83 | <pen lineWidth="0.5" lineColor="#000000"/> |
||
| 84 | </box> |
||
| 85 | </style> |
||
| 86 | <style name="table 4"> |
||
| 87 | <box> |
||
| 88 | <pen lineWidth="1.0" lineColor="#000000"/> |
||
| 89 | </box> |
||
| 90 | </style> |
||
| 91 | <style name="table 4_TH" mode="Opaque" backcolor="#73B0E6"> |
||
| 92 | <box> |
||
| 93 | <pen lineWidth="0.5" lineColor="#000000"/> |
||
| 94 | </box> |
||
| 95 | </style> |
||
| 96 | <style name="table 4_CH" mode="Opaque" backcolor="#CCCCCC"> |
||
| 97 | <box> |
||
| 98 | <pen lineWidth="0.5" lineColor="#000000"/> |
||
| 99 | </box> |
||
| 100 | </style> |
||
| 101 | <style name="table 4_TD" mode="Opaque" backcolor="#FFFFFF"> |
||
| 102 | <box> |
||
| 103 | <pen lineWidth="0.5" lineColor="#000000"/> |
||
| 104 | </box> |
||
| 105 | <conditionalStyle> |
||
| 106 | <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression> |
||
| 107 | <style backcolor="#F3F6F8"/> |
||
| 108 | </conditionalStyle> |
||
| 109 | </style> |
||
| 110 | <subDataset name="cargo" uuid="1f630ccf-43ed-4d8b-922e-8110d812cc30"> |
||
| 111 | <queryString> |
||
| 112 | <![CDATA[ SELECT |
||
| 113 | c.cod_cargo, |
||
| 114 | c.dsc_cargo, |
||
| 115 | c.cod_grau_instrucao, |
||
| 116 | c.num_quantidade_vagas, |
||
| 117 | c.ind_ativo, |
||
| 118 | ( |
||
| 119 | SELECT count(cod_cargo) as total FROM ( |
||
| 120 | (SELECT seq_servidor_dadofuncional, cod_cargo FROM sc_srv.srv_serdadfuncon_prestprocselet ps) |
||
| 121 | UNION |
||
| 122 | (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) |
||
| 123 | ) mc |
||
| 124 | WHERE mc.cod_cargo = c.cod_cargo |
||
| 125 | ) as vagas_ocupadas, |
||
| 126 | ( |
||
| 127 | SELECT count(cod_cargo) as total FROM ( |
||
| 128 | (SELECT seq_servidor_dadofuncional, cod_cargo FROM sc_srv.srv_serdadfuncon_prestprocselet ps) |
||
| 129 | UNION |
||
| 130 | (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) |
||
| 131 | ) mc |
||
| 132 | INNER JOIN sc_srv.srv_servidor_dadofuncional df on (mc.seq_servidor_dadofuncional=df.seq_servidor_dadofuncional) |
||
| 133 | LEFT JOIN sc_srv.srv_servdadofunc_matricula dfm on (df.seq_servidor_dadofuncional=dfm.seq_servidor_dadofuncional and dfm.cod_situacao_servidor = 1) |
||
| 134 | INNER JOIN sc_srv.srv_forma_ingresso fi on (fi.cod_forma_ingresso=df.cod_forma_ingresso) |
||
| 135 | WHERE fi.tip_vinculo_forma_ingresso = 'E' and mc.cod_cargo = c.cod_cargo |
||
| 136 | ) as vagas_ocupadas_efetivo, |
||
| 137 | ( |
||
| 138 | SELECT count(cod_cargo) as total FROM ( |
||
| 139 | (SELECT seq_servidor_dadofuncional, cod_cargo FROM sc_srv.srv_serdadfuncon_prestprocselet ps) |
||
| 140 | UNION |
||
| 141 | (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) |
||
| 142 | ) mc |
||
| 143 | INNER JOIN sc_srv.srv_servidor_dadofuncional df on (mc.seq_servidor_dadofuncional=df.seq_servidor_dadofuncional) |
||
| 144 | LEFT JOIN sc_srv.srv_servdadofunc_matricula dfm on (df.seq_servidor_dadofuncional=dfm.seq_servidor_dadofuncional and dfm.cod_situacao_servidor = 1) |
||
| 145 | INNER JOIN sc_srv.srv_forma_ingresso fi on (fi.cod_forma_ingresso=df.cod_forma_ingresso) |
||
| 146 | WHERE fi.tip_vinculo_forma_ingresso = 'T' and mc.cod_cargo = c.cod_cargo |
||
| 147 | ) as vagas_ocupadas_contratado, |
||
| 148 | ( |
||
| 149 | SELECT count(cod_cargo) as total FROM ( |
||
| 150 | (SELECT seq_servidor_dadofuncional, cod_cargo FROM sc_srv.srv_serdadfuncon_prestprocselet ps) |
||
| 151 | UNION |
||
| 152 | (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) |
||
| 153 | ) mc |
||
| 154 | INNER JOIN sc_srv.srv_servidor_dadofuncional df on (mc.seq_servidor_dadofuncional=df.seq_servidor_dadofuncional) |
||
| 155 | LEFT JOIN sc_srv.srv_servdadofunc_matricula dfm on (df.seq_servidor_dadofuncional=dfm.seq_servidor_dadofuncional and dfm.cod_situacao_servidor = 1) |
||
| 156 | INNER JOIN sc_srv.srv_forma_ingresso fi on (fi.cod_forma_ingresso=df.cod_forma_ingresso) |
||
| 157 | WHERE fi.tip_vinculo_forma_ingresso = 'L' and mc.cod_cargo = c.cod_cargo |
||
| 158 | ) as vagas_ocupadas_celetista, |
||
| 159 | ( |
||
| 160 | SELECT count(cod_cargo) as total FROM ( |
||
| 161 | (SELECT seq_servidor_dadofuncional, cod_cargo FROM sc_srv.srv_serdadfuncon_prestprocselet ps) |
||
| 162 | UNION |
||
| 163 | (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) |
||
| 164 | ) mc |
||
| 165 | INNER JOIN sc_srv.srv_servidor_dadofuncional df on (mc.seq_servidor_dadofuncional=df.seq_servidor_dadofuncional) |
||
| 166 | LEFT JOIN sc_srv.srv_servdadofunc_matricula dfm on (df.seq_servidor_dadofuncional=dfm.seq_servidor_dadofuncional and dfm.cod_situacao_servidor = 1) |
||
| 167 | INNER JOIN sc_srv.srv_forma_ingresso fi on (fi.cod_forma_ingresso=df.cod_forma_ingresso) |
||
| 168 | WHERE fi.tip_vinculo_forma_ingresso = 'C' and mc.cod_cargo = c.cod_cargo |
||
| 169 | ) as vagas_ocupadas_comissionado, |
||
| 170 | ( |
||
| 171 | (num_quantidade_vagas) - |
||
| 172 | ( |
||
| 173 | SELECT count(cod_cargo) as total FROM ( |
||
| 174 | (SELECT seq_servidor_dadofuncional, cod_cargo FROM sc_srv.srv_serdadfuncon_prestprocselet ps) |
||
| 175 | UNION |
||
| 176 | (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) |
||
| 177 | ) mc |
||
| 178 | WHERE mc.cod_cargo = c.cod_cargo |
||
| 179 | ) |
||
| 180 | )as saldo_vagas, |
||
| 181 | ( |
||
| 182 | SELECT sum(num_quantidade_vagas) as total FROM sc_srv.srv_cargo c |
||
| 183 | ) as total_vagas_disponiveis, |
||
| 184 | ( |
||
| 185 | SELECT count(cod_cargo) as total FROM ( |
||
| 186 | (SELECT seq_servidor_dadofuncional, cod_cargo FROM sc_srv.srv_serdadfuncon_prestprocselet ps) |
||
| 187 | UNION |
||
| 188 | (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) |
||
| 189 | ) mc |
||
| 190 | )as total_vagas_ocupadas, |
||
| 191 | ( |
||
| 192 | (SELECT sum(num_quantidade_vagas) as total FROM sc_srv.srv_cargo c) - |
||
| 193 | (SELECT count(cod_cargo) as total FROM ( |
||
| 194 | (SELECT seq_servidor_dadofuncional, cod_cargo FROM sc_srv.srv_serdadfuncon_prestprocselet ps) |
||
| 195 | UNION |
||
| 196 | (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) |
||
| 197 | ) mc) |
||
| 198 | )as total_saldo_vagas |
||
| 199 | FROM sc_srv.srv_cargo c |
||
| 200 | ORDER BY c.dsc_cargo]]> |
||
| 201 | </queryString> |
||
| 202 | <field name="cod_cargo" class="java.math.BigDecimal"/> |
||
| 203 | <field name="dsc_cargo" class="java.lang.String"/> |
||
| 204 | <field name="cod_grau_instrucao" class="java.math.BigDecimal"/> |
||
| 205 | <field name="num_quantidade_vagas" class="java.math.BigDecimal"/> |
||
| 206 | <field name="ind_ativo" class="java.lang.Boolean"/> |
||
| 207 | <field name="vagas_ocupadas" class="java.lang.Long"/> |
||
| 208 | <field name="vagas_ocupadas_efetivo" class="java.lang.Long"/> |
||
| 209 | <field name="vagas_ocupadas_contratado" class="java.lang.Long"/> |
||
| 210 | <field name="vagas_ocupadas_celetista" class="java.lang.Long"/> |
||
| 211 | <field name="vagas_ocupadas_comissionado" class="java.lang.Long"/> |
||
| 212 | <field name="saldo_vagas" class="java.math.BigDecimal"/> |
||
| 213 | <field name="total_vagas_disponiveis" class="java.math.BigDecimal"/> |
||
| 214 | <field name="total_vagas_ocupadas" class="java.lang.Long"/> |
||
| 215 | <field name="total_saldo_vagas" class="java.math.BigDecimal"/> |
||
| 216 | </subDataset> |
||
| 217 | <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false"> |
||
| 218 | <defaultValueExpression><![CDATA[""]]></defaultValueExpression> |
||
| 219 | </parameter> |
||
| 220 | <parameter name="IMAGE_DIR" class="java.lang.String" isForPrompting="false"> |
||
| 221 | <defaultValueExpression><![CDATA[""]]></defaultValueExpression> |
||
| 222 | </parameter> |
||
| 223 | <queryString> |
||
| 224 | <![CDATA[SELECT * FROM sc_srv.srv_cargo c limit 1]]> |
||
| 225 | </queryString> |
||
| 226 | <field name="cod_cargo" class="java.math.BigDecimal"/> |
||
| 227 | <field name="dsc_cargo" class="java.lang.String"/> |
||
| 228 | <field name="cod_grau_instrucao" class="java.math.BigDecimal"/> |
||
| 229 | <field name="num_quantidade_vagas" class="java.math.BigDecimal"/> |
||
| 230 | <field name="ind_ativo" class="java.lang.Boolean"/> |
||
| 231 | <background> |
||
| 232 | <band splitType="Stretch"/> |
||
| 233 | </background> |
||
| 234 | <pageHeader> |
||
| 235 | <band height="149"> |
||
| 236 | <image hAlign="Right"> |
||
| 237 | <reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" x="251" y="2" width="48" height="59" isPrintWhenDetailOverflows="true"/> |
||
| 238 | <imageExpression><![CDATA[$P{IMAGE_DIR} + "brasao.jpg"]]></imageExpression> |
||
| 239 | </image> |
||
| 240 | <staticText> |
||
| 241 | <reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="62" width="555" height="39" isPrintWhenDetailOverflows="true"/> |
||
| 242 | <textElement textAlignment="Center" verticalAlignment="Top"> |
||
| 243 | <font fontName="Arial" size="10" isBold="true"/> |
||
| 244 | </textElement> |
||
| 245 | <text><![CDATA[ESTADO DE ALAGOAS |
||
| 246 | SECRETARIA DE ESTADO DA SAÚDE DE ALAGOAS |
||
| 247 | RELATÓRIO DE ACOMPANHAMENTO DO SERVIDOR - QUANTITATIVO DE CARGO ]]></text> |
||
| 248 | </staticText> |
||
| 249 | </band> |
||
| 250 | </pageHeader> |
||
| 251 | <columnHeader> |
||
| 252 | <band height="15"> |
||
| 253 | <rectangle> |
||
| 254 | <reportElement uuid="423b9a10-6789-4023-9a4d-1cd8ecd4119f" positionType="Float" x="0" y="0" width="555" height="15" backcolor="#CCCCCC"/> |
||
| 255 | </rectangle> |
||
| 256 | <staticText> |
||
| 257 | <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" positionType="Float" mode="Transparent" x="0" y="0" width="555" height="15" backcolor="#CCCCCC"/> |
||
| 258 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 259 | <font fontName="Arial" size="8" isBold="true"/> |
||
| 260 | <paragraph leftIndent="5"/> |
||
| 261 | </textElement> |
||
| 262 | <text><![CDATA[QUANTITATIVO DE CARGO]]></text> |
||
| 263 | </staticText> |
||
| 264 | </band> |
||
| 265 | </columnHeader> |
||
| 266 | <detail> |
||
| 267 | <band height="31"> |
||
| 268 | <componentElement> |
||
| 269 | <reportElement uuid="b47b342c-8a71-49ca-bb46-b988458f296d" key="table 4" style="table 4" x="0" y="0" width="555" height="30"/> |
||
| 270 | <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"> |
||
| 271 | <datasetRun subDataset="cargo" uuid="1259ba1a-f4f9-4a38-b8c5-cdef26240f7b"> |
||
| 272 | <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> |
||
| 273 | </datasetRun> |
||
| 274 | <jr:column uuid="aff272c8-83bc-4ebb-8cdd-03a6c63f87cf" width="168"> |
||
| 275 | <jr:columnHeader style="table 4_CH" height="30" rowSpan="2"> |
||
| 276 | <staticText> |
||
| 277 | <reportElement uuid="8529343e-13a9-4b89-96e0-6a23332ad3fa" x="0" y="0" width="168" height="29"/> |
||
| 278 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 279 | <font fontName="Arial" size="8"/> |
||
| 280 | </textElement> |
||
| 281 | <text><![CDATA[CARGO]]></text> |
||
| 282 | </staticText> |
||
| 283 | </jr:columnHeader> |
||
| 284 | <jr:columnFooter height="15" rowSpan="1"> |
||
| 285 | <staticText> |
||
| 286 | <reportElement uuid="8529343e-13a9-4b89-96e0-6a23332ad3fa" x="0" y="0" width="166" height="15"/> |
||
| 287 | <textElement textAlignment="Right" verticalAlignment="Middle"> |
||
| 288 | <font fontName="Arial" size="8"/> |
||
| 289 | </textElement> |
||
| 290 | <text><![CDATA[TOTAL GERAL:]]></text> |
||
| 291 | </staticText> |
||
| 292 | </jr:columnFooter> |
||
| 293 | <jr:detailCell style="table 4_TD" height="15" rowSpan="1"> |
||
| 294 | <textField isBlankWhenNull="true"> |
||
| 295 | <reportElement uuid="3cef8170-70cd-4c9b-8656-d182be3eafb9" x="2" y="0" width="166" height="15"/> |
||
| 296 | <textElement verticalAlignment="Middle"> |
||
| 297 | <font fontName="Arial" size="8"/> |
||
| 298 | <paragraph leftIndent="5"/> |
||
| 299 | </textElement> |
||
| 300 | <textFieldExpression><![CDATA[$F{dsc_cargo}]]></textFieldExpression> |
||
| 301 | </textField> |
||
| 302 | </jr:detailCell> |
||
| 303 | </jr:column> |
||
| 304 | <jr:column uuid="50b52ef6-139c-45f4-9248-cae52f3479c2" width="57"> |
||
| 305 | <jr:columnHeader style="table 4_CH" height="30" rowSpan="2"> |
||
| 306 | <staticText> |
||
| 307 | <reportElement uuid="bbdf9964-9ffb-4235-99e5-1169493a9c00" x="0" y="0" width="56" height="29"/> |
||
| 308 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 309 | <font fontName="Arial" size="8"/> |
||
| 310 | </textElement> |
||
| 311 | <text><![CDATA[DISPONÍVEL]]></text> |
||
| 312 | </staticText> |
||
| 313 | </jr:columnHeader> |
||
| 314 | <jr:columnFooter style="table 4_TD" height="15" rowSpan="1"> |
||
| 315 | <textField isBlankWhenNull="true"> |
||
| 316 | <reportElement uuid="81eb3242-862b-4b39-8808-c8eadd11a675" x="0" y="0" width="57" height="15"/> |
||
| 317 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 318 | <font fontName="Arial" size="8"/> |
||
| 319 | </textElement> |
||
| 320 | <textFieldExpression><![CDATA[$F{total_vagas_disponiveis}]]></textFieldExpression> |
||
| 321 | </textField> |
||
| 322 | </jr:columnFooter> |
||
| 323 | <jr:detailCell style="table 4_TD" height="15" rowSpan="1"> |
||
| 324 | <textField isBlankWhenNull="true"> |
||
| 325 | <reportElement uuid="81eb3242-862b-4b39-8808-c8eadd11a675" x="0" y="0" width="57" height="15"/> |
||
| 326 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 327 | <font fontName="Arial" size="8"/> |
||
| 328 | </textElement> |
||
| 329 | <textFieldExpression><![CDATA[$F{num_quantidade_vagas}]]></textFieldExpression> |
||
| 330 | </textField> |
||
| 331 | </jr:detailCell> |
||
| 332 | </jr:column> |
||
| 333 | <jr:columnGroup uuid="bdab4877-6e8b-4a41-82ab-e608d3264385" width="278"> |
||
| 334 | <jr:columnHeader style="table 4_CH" height="15" rowSpan="1"> |
||
| 335 | <staticText> |
||
| 336 | <reportElement uuid="8529343e-13a9-4b89-96e0-6a23332ad3fa" x="0" y="0" width="278" height="15"/> |
||
| 337 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 338 | <font fontName="Arial" size="8"/> |
||
| 339 | </textElement> |
||
| 340 | <text><![CDATA[OCUPADOS]]></text> |
||
| 341 | </staticText> |
||
| 342 | </jr:columnHeader> |
||
| 343 | <jr:column uuid="147b4d65-f829-413d-8150-77f58a82f703" width="45"> |
||
| 344 | <jr:columnHeader style="table 4_CH" height="15" rowSpan="1"> |
||
| 345 | <staticText> |
||
| 346 | <reportElement uuid="48e9acab-2d3e-41f9-84a5-78fb3f9d5162" x="0" y="0" width="45" height="15"/> |
||
| 347 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 348 | <font fontName="Arial" size="8"/> |
||
| 349 | </textElement> |
||
| 350 | <text><![CDATA[EFETIVO]]></text> |
||
| 351 | </staticText> |
||
| 352 | </jr:columnHeader> |
||
| 353 | <jr:detailCell style="table 4_TD" height="15" rowSpan="1"> |
||
| 354 | <textField isBlankWhenNull="true"> |
||
| 355 | <reportElement uuid="a31549cf-e7bf-487a-aab7-6ed304b5d0a6" x="0" y="0" width="45" height="15"/> |
||
| 356 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 357 | <font fontName="Arial" size="8"/> |
||
| 358 | </textElement> |
||
| 359 | <textFieldExpression><![CDATA[$F{vagas_ocupadas_efetivo}]]></textFieldExpression> |
||
| 360 | </textField> |
||
| 361 | </jr:detailCell> |
||
| 362 | </jr:column> |
||
| 363 | <jr:column uuid="549cfcdc-5050-448f-9cce-51fae7662d96" width="68"> |
||
| 364 | <jr:columnHeader style="table 4_CH" height="15" rowSpan="1"> |
||
| 365 | <staticText> |
||
| 366 | <reportElement uuid="21dc8aa6-93eb-418e-a847-06e800d13415" x="0" y="0" width="68" height="15"/> |
||
| 367 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 368 | <font fontName="Arial" size="8"/> |
||
| 369 | </textElement> |
||
| 370 | <text><![CDATA[CONTRATADO]]></text> |
||
| 371 | </staticText> |
||
| 372 | </jr:columnHeader> |
||
| 373 | <jr:detailCell style="table 4_TD" height="15" rowSpan="1"> |
||
| 374 | <textField isBlankWhenNull="true"> |
||
| 375 | <reportElement uuid="578defa1-209a-4fde-bc68-4f1e1414a191" x="0" y="0" width="68" height="15"/> |
||
| 376 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 377 | <font fontName="Arial" size="8"/> |
||
| 378 | </textElement> |
||
| 379 | <textFieldExpression><![CDATA[$F{vagas_ocupadas_contratado}]]></textFieldExpression> |
||
| 380 | </textField> |
||
| 381 | </jr:detailCell> |
||
| 382 | </jr:column> |
||
| 383 | <jr:column uuid="76cc1172-0231-4c91-9a55-c89a447cb080" width="55"> |
||
| 384 | <jr:columnHeader style="table 4_CH" height="15" rowSpan="1"> |
||
| 385 | <staticText> |
||
| 386 | <reportElement uuid="23dde1c5-895f-4a05-ae31-a8ed03c7bc32" x="0" y="0" width="55" height="15"/> |
||
| 387 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 388 | <font fontName="Arial" size="8"/> |
||
| 389 | </textElement> |
||
| 390 | <text><![CDATA[CELETISTA]]></text> |
||
| 391 | </staticText> |
||
| 392 | </jr:columnHeader> |
||
| 393 | <jr:detailCell style="table 4_TD" height="15" rowSpan="1"> |
||
| 394 | <textField isBlankWhenNull="true"> |
||
| 395 | <reportElement uuid="abb85749-c2b1-41b6-927d-47de0026ace6" x="0" y="0" width="55" height="15"/> |
||
| 396 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 397 | <font fontName="Arial" size="8"/> |
||
| 398 | </textElement> |
||
| 399 | <textFieldExpression><![CDATA[$F{vagas_ocupadas_celetista}]]></textFieldExpression> |
||
| 400 | </textField> |
||
| 401 | </jr:detailCell> |
||
| 402 | </jr:column> |
||
| 403 | <jr:column uuid="9cce8866-5f51-414c-83a0-dd661030f445" width="70"> |
||
| 404 | <jr:columnHeader style="table 4_CH" height="15" rowSpan="1"> |
||
| 405 | <staticText> |
||
| 406 | <reportElement uuid="919b6ac5-44ad-4346-a23f-e49c252a494a" x="0" y="0" width="70" height="15"/> |
||
| 407 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 408 | <font fontName="Arial" size="8"/> |
||
| 409 | </textElement> |
||
| 410 | <text><![CDATA[COMISSIONADO]]></text> |
||
| 411 | </staticText> |
||
| 412 | </jr:columnHeader> |
||
| 413 | <jr:detailCell style="table 4_TD" height="15" rowSpan="1"> |
||
| 414 | <textField isBlankWhenNull="true"> |
||
| 415 | <reportElement uuid="84577288-4e62-4a25-bb82-7704551ed199" x="0" y="0" width="70" height="15"/> |
||
| 416 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 417 | <font fontName="Arial" size="8"/> |
||
| 418 | </textElement> |
||
| 419 | <textFieldExpression><![CDATA[$F{vagas_ocupadas_comissionado}]]></textFieldExpression> |
||
| 420 | </textField> |
||
| 421 | </jr:detailCell> |
||
| 422 | </jr:column> |
||
| 423 | <jr:column uuid="6857a4da-491b-47c3-b888-fa8dfbc068b4" width="40"> |
||
| 424 | <jr:columnHeader style="table 4_CH" height="15" rowSpan="1"> |
||
| 425 | <staticText> |
||
| 426 | <reportElement uuid="09cca298-27f6-4ccc-805f-ab012f0e4772" x="0" y="0" width="40" height="15"/> |
||
| 427 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 428 | <font fontName="Arial" size="8"/> |
||
| 429 | </textElement> |
||
| 430 | <text><![CDATA[TOTAL]]></text> |
||
| 431 | </staticText> |
||
| 432 | </jr:columnHeader> |
||
| 433 | <jr:columnFooter style="table 4_TD" height="15" rowSpan="1"> |
||
| 434 | <textField isBlankWhenNull="true"> |
||
| 435 | <reportElement uuid="81eb3242-862b-4b39-8808-c8eadd11a675" x="0" y="0" width="40" height="15"/> |
||
| 436 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 437 | <font fontName="Arial" size="8"/> |
||
| 438 | </textElement> |
||
| 439 | <textFieldExpression><![CDATA[$F{total_vagas_ocupadas}]]></textFieldExpression> |
||
| 440 | </textField> |
||
| 441 | </jr:columnFooter> |
||
| 442 | <jr:detailCell style="table 4_TD" height="15" rowSpan="1"> |
||
| 443 | <textField isBlankWhenNull="true"> |
||
| 444 | <reportElement uuid="12b462cd-18cb-41f3-b2e8-94b4a3a69228" x="0" y="0" width="40" height="15"/> |
||
| 445 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 446 | <font fontName="Arial" size="8"/> |
||
| 447 | </textElement> |
||
| 448 | <textFieldExpression><![CDATA[$F{vagas_ocupadas}]]></textFieldExpression> |
||
| 449 | </textField> |
||
| 450 | </jr:detailCell> |
||
| 451 | </jr:column> |
||
| 452 | </jr:columnGroup> |
||
| 453 | <jr:column uuid="247c6b4d-ca24-49be-b93a-a2b1d1784a46" width="52"> |
||
| 454 | <jr:columnHeader style="table 4_CH" height="30" rowSpan="2"> |
||
| 455 | <staticText> |
||
| 456 | <reportElement uuid="f7e16292-cff0-4b71-a32a-9519ae0d2f58" x="0" y="0" width="49" height="29"/> |
||
| 457 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 458 | <font fontName="Arial" size="8"/> |
||
| 459 | </textElement> |
||
| 460 | <text><![CDATA[SALDO]]></text> |
||
| 461 | </staticText> |
||
| 462 | </jr:columnHeader> |
||
| 463 | <jr:columnFooter style="table 4_TD" height="15" rowSpan="1"> |
||
| 464 | <textField isBlankWhenNull="true"> |
||
| 465 | <reportElement uuid="81eb3242-862b-4b39-8808-c8eadd11a675" x="0" y="0" width="50" height="15"/> |
||
| 466 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 467 | <font fontName="Arial" size="8"/> |
||
| 468 | </textElement> |
||
| 469 | <textFieldExpression><![CDATA[$F{total_saldo_vagas}]]></textFieldExpression> |
||
| 470 | </textField> |
||
| 471 | </jr:columnFooter> |
||
| 472 | <jr:detailCell style="table 4_TD" height="15" rowSpan="1"> |
||
| 473 | <textField isBlankWhenNull="true"> |
||
| 474 | <reportElement uuid="49a04eb7-3661-4af8-a16e-5f92d25ef6d8" x="0" y="0" width="50" height="15"/> |
||
| 475 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 476 | <font fontName="Arial" size="8"/> |
||
| 477 | </textElement> |
||
| 478 | <textFieldExpression><![CDATA[$F{saldo_vagas}]]></textFieldExpression> |
||
| 479 | </textField> |
||
| 480 | </jr:detailCell> |
||
| 481 | </jr:column> |
||
| 482 | </jr:table> |
||
| 483 | </componentElement> |
||
| 484 | </band> |
||
| 485 | </detail> |
||
| 486 | <pageFooter> |
||
| 487 | <band height="33"> |
||
| 488 | <textField evaluationTime="Report" isBlankWhenNull="false"> |
||
| 489 | <reportElement uuid="506b9991-ff6d-43b5-ab78-2832586c3dda" key="textField" x="496" y="10" width="52" height="15"/> |
||
| 490 | <textElement verticalAlignment="Middle"> |
||
| 491 | <font fontName="Arial" size="6" isBold="false"/> |
||
| 492 | </textElement> |
||
| 493 | <textFieldExpression><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression> |
||
| 494 | </textField> |
||
| 495 | <textField isBlankWhenNull="false"> |
||
| 496 | <reportElement uuid="e5f06c72-11c0-479b-b234-4dcaf2bc0440" key="textField" x="421" y="10" width="73" height="15"/> |
||
| 497 | <textElement textAlignment="Right" verticalAlignment="Middle"> |
||
| 498 | <font fontName="Arial" size="6" isBold="false"/> |
||
| 499 | </textElement> |
||
| 500 | <textFieldExpression><![CDATA["PÁGINA " + $V{PAGE_NUMBER} + " DE "]]></textFieldExpression> |
||
| 501 | </textField> |
||
| 502 | <textField isBlankWhenNull="true"> |
||
| 503 | <reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="0" y="10" width="289" height="15"/> |
||
| 504 | <textElement verticalAlignment="Middle"> |
||
| 505 | <font fontName="Arial" size="6" isBold="false"/> |
||
| 506 | </textElement> |
||
| 507 | <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> |
||
| 508 | </textField> |
||
| 509 | </band> |
||
| 510 | </pageFooter> |
||
| 511 | <summary> |
||
| 512 | <band height="11"/> |
||
| 513 | </summary> |
||
| 514 | </jasperReport> |