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="relatorio" pageWidth="595" pageHeight="842" columnWidth="556" leftMargin="20" rightMargin="19" topMargin="20" bottomMargin="20" uuid="85d4a540-608e-4934-8f57-57cec53afb74"> |
||
| 3 | <property name="ireport.zoom" value="1.0"/> |
||
| 4 | <property name="ireport.x" value="0"/> |
||
| 5 | <property name="ireport.y" value="0"/> |
||
| 6 | <parameter name="IMAGEM_DIR" class="java.lang.String"> |
||
| 7 | <defaultValueExpression><![CDATA["C:\\"]]></defaultValueExpression> |
||
| 8 | </parameter> |
||
| 9 | <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false"> |
||
| 10 | <defaultValueExpression><![CDATA["C:\\Repositorio\\DESENVOLVIMENTO\\SESAU\\JAVA\\Repositorio\\rhcapacitacao\\FONTES\\IMPLEMENTACAO\\DESENVOLVIMENTO\\scs\\scs-core\\src\\main\\resources\\relatorios\\"]]></defaultValueExpression> |
||
| 11 | </parameter> |
||
| 12 | <parameter name="NOM_USUARIO" class="java.lang.String"> |
||
| 13 | <defaultValueExpression><![CDATA[]]></defaultValueExpression> |
||
| 14 | </parameter> |
||
| 15 | <parameter name="CPF_USUARIO" class="java.lang.String"> |
||
| 16 | <defaultValueExpression><![CDATA[]]></defaultValueExpression> |
||
| 17 | </parameter> |
||
| 18 | <parameter name="MES" class="java.lang.String"> |
||
| 19 | <defaultValueExpression><![CDATA[]]></defaultValueExpression> |
||
| 20 | </parameter> |
||
| 21 | <parameter name="ANO" class="java.lang.Integer"> |
||
| 22 | <defaultValueExpression><![CDATA[2013]]></defaultValueExpression> |
||
| 23 | </parameter> |
||
| 24 | <queryString> |
||
| 25 | <![CDATA[SELECT |
||
| 26 | tr.num_ano, |
||
| 27 | cp.dsc_capacitacao, |
||
| 28 | tr.seq_turma, |
||
| 29 | uw.dsc_unidade, |
||
| 30 | po.num_processo, |
||
| 31 | po.dsc_ano_processo, |
||
| 32 | po.cod_orgao_processo, |
||
| 33 | po.dsc_elemento_despesa, |
||
| 34 | po.dsc_fonte_recurso, |
||
| 35 | po.val_orcado |
||
| 36 | FROM sc_scs.scs_turma tr |
||
| 37 | INNER JOIN sc_scs.scs_capacitacao cp ON tr.seq_capacitacao = cp.seq_capacitacao |
||
| 38 | LEFT JOIN sc_scs.scs_turma_processo pr ON pr.seq_turma = tr.seq_turma |
||
| 39 | LEFT JOIN orcamento.vw_processo_orcamento po ON pr.cod_orgao = po.cod_orgao_processo |
||
| 40 | AND pr.num_processo = po.num_processo |
||
| 41 | AND pr.num_ano = po.num_periodo_orcamentario |
||
| 42 | LEFT JOIN sc_srv.vw_unidade uw ON uw.cod_unidade = tr.cod_unidade_solicitante |
||
| 43 | WHERE tr.num_ano = $P{ANO} |
||
| 44 | AND |
||
| 45 | ( |
||
| 46 | $P{MES} = |
||
| 47 | ( |
||
| 48 | SELECT |
||
| 49 | to_char(MIN(tp.dth_data_inicial), 'MM') |
||
| 50 | FROM sc_scs.scs_turma_periodo tp |
||
| 51 | WHERE tp.seq_turma = tr.seq_turma |
||
| 52 | ) |
||
| 53 | OR |
||
| 54 | $P{MES} IS NULL |
||
| 55 | ) ORDER BY tr.seq_turma, po.num_processo]]> |
||
| 56 | </queryString> |
||
| 57 | <field name="num_ano" class="java.math.BigDecimal"/> |
||
| 58 | <field name="dsc_capacitacao" class="java.lang.String"/> |
||
| 59 | <field name="seq_turma" class="java.lang.Long"/> |
||
| 60 | <field name="dsc_unidade" class="java.lang.String"/> |
||
| 61 | <field name="num_processo" class="java.math.BigDecimal"/> |
||
| 62 | <field name="dsc_ano_processo" class="java.lang.String"/> |
||
| 63 | <field name="cod_orgao_processo" class="java.math.BigDecimal"/> |
||
| 64 | <field name="dsc_elemento_despesa" class="java.lang.String"/> |
||
| 65 | <field name="dsc_fonte_recurso" class="java.lang.String"/> |
||
| 66 | <field name="val_orcado" class="java.lang.Double"/> |
||
| 67 | <variable name="TOTAL ORCADO" class="java.lang.Double" resetType="Group" resetGroup="Turma" calculation="Sum"> |
||
| 68 | <variableExpression><![CDATA[$F{val_orcado}]]></variableExpression> |
||
| 69 | <initialValueExpression><![CDATA[0.00]]></initialValueExpression> |
||
| 70 | </variable> |
||
| 71 | <variable name="TOTAL" class="java.lang.Double" calculation="Sum"> |
||
| 72 | <variableExpression><![CDATA[$F{val_orcado}]]></variableExpression> |
||
| 73 | <initialValueExpression><![CDATA[0.00]]></initialValueExpression> |
||
| 74 | </variable> |
||
| 75 | <group name="Turma"> |
||
| 76 | <groupExpression><![CDATA[$F{seq_turma}]]></groupExpression> |
||
| 77 | <groupHeader> |
||
| 78 | <band height="60"> |
||
| 79 | <rectangle> |
||
| 80 | <reportElement uuid="ffab1a50-2f09-4649-bfbb-ef67c9ba6df8" x="0" y="0" width="556" height="20" backcolor="#CCCCCC"/> |
||
| 81 | </rectangle> |
||
| 82 | <textField isStretchWithOverflow="true"> |
||
| 83 | <reportElement uuid="bd7e6eee-80f8-4b1d-a789-7078dbf18cb1" x="0" y="0" width="557" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/> |
||
| 84 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 85 | <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/> |
||
| 86 | <paragraph leftIndent="5" rightIndent="5"/> |
||
| 87 | </textElement> |
||
| 88 | <textFieldExpression><![CDATA["CAPACITAÇÃO: " + $F{dsc_capacitacao}]]></textFieldExpression> |
||
| 89 | </textField> |
||
| 90 | <rectangle> |
||
| 91 | <reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" positionType="Float" stretchType="RelativeToBandHeight" x="0" y="40" width="200" height="20" isPrintWhenDetailOverflows="true" backcolor="#FFFFFF"/> |
||
| 92 | </rectangle> |
||
| 93 | <rectangle> |
||
| 94 | <reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" positionType="Float" stretchType="RelativeToBandHeight" x="200" y="40" width="356" height="20" isPrintWhenDetailOverflows="true" backcolor="#FFFFFF"/> |
||
| 95 | </rectangle> |
||
| 96 | <textField isStretchWithOverflow="true"> |
||
| 97 | <reportElement uuid="bd7e6eee-80f8-4b1d-a789-7078dbf18cb1" positionType="Float" stretchType="RelativeToBandHeight" x="0" y="40" width="200" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/> |
||
| 98 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 99 | <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/> |
||
| 100 | <paragraph leftIndent="5" rightIndent="5"/> |
||
| 101 | </textElement> |
||
| 102 | <textFieldExpression><![CDATA[$F{seq_turma}]]></textFieldExpression> |
||
| 103 | </textField> |
||
| 104 | <textField isStretchWithOverflow="true"> |
||
| 105 | <reportElement uuid="bd7e6eee-80f8-4b1d-a789-7078dbf18cb1" positionType="Float" stretchType="RelativeToBandHeight" x="200" y="40" width="357" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/> |
||
| 106 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 107 | <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/> |
||
| 108 | <paragraph leftIndent="5" rightIndent="5"/> |
||
| 109 | </textElement> |
||
| 110 | <textFieldExpression><![CDATA[$F{dsc_unidade}]]></textFieldExpression> |
||
| 111 | </textField> |
||
| 112 | <rectangle> |
||
| 113 | <reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="200" y="20" width="356" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/> |
||
| 114 | </rectangle> |
||
| 115 | <rectangle> |
||
| 116 | <reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="0" y="20" width="200" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/> |
||
| 117 | </rectangle> |
||
| 118 | <staticText> |
||
| 119 | <reportElement uuid="1f2a1c8c-bd8a-4d26-9d1c-8fb5b1bd5cba" x="202" y="20" width="355" height="20"/> |
||
| 120 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 121 | <font isBold="true" isPdfEmbedded="false"/> |
||
| 122 | </textElement> |
||
| 123 | <text><![CDATA[UNIDADE SOLICITANTE]]></text> |
||
| 124 | </staticText> |
||
| 125 | <staticText> |
||
| 126 | <reportElement uuid="adf263e6-1fd6-4bdd-81e1-11434eb9de59" x="0" y="20" width="200" height="20"/> |
||
| 127 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 128 | <font isBold="true" isPdfEmbedded="false"/> |
||
| 129 | </textElement> |
||
| 130 | <text><![CDATA[TURMA]]></text> |
||
| 131 | </staticText> |
||
| 132 | </band> |
||
| 133 | </groupHeader> |
||
| 134 | <groupFooter> |
||
| 135 | <band height="40"> |
||
| 136 | <printWhenExpression><![CDATA[$F{num_processo} != null]]></printWhenExpression> |
||
| 137 | <staticText> |
||
| 138 | <reportElement uuid="1f2a1c8c-bd8a-4d26-9d1c-8fb5b1bd5cba" positionType="Float" stretchType="RelativeToBandHeight" x="0" y="10" width="400" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/> |
||
| 139 | <textElement textAlignment="Right" verticalAlignment="Middle"> |
||
| 140 | <font isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/> |
||
| 141 | <paragraph leftIndent="5" rightIndent="5"/> |
||
| 142 | </textElement> |
||
| 143 | <text><![CDATA[TOTAL ORÇADO DA CAPACITAÇÃO:]]></text> |
||
| 144 | </staticText> |
||
| 145 | <rectangle> |
||
| 146 | <reportElement uuid="eb5a69cf-c7a4-484b-ac04-56807475c8ed" positionType="Float" stretchType="RelativeToBandHeight" x="401" y="10" width="155" height="20" isPrintWhenDetailOverflows="true"/> |
||
| 147 | </rectangle> |
||
| 148 | <textField isStretchWithOverflow="true" pattern="¤ #,##0.00" isBlankWhenNull="false"> |
||
| 149 | <reportElement uuid="bd7e6eee-80f8-4b1d-a789-7078dbf18cb1" positionType="Float" stretchType="RelativeToBandHeight" x="401" y="10" width="156" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/> |
||
| 150 | <textElement textAlignment="Center" verticalAlignment="Middle" markup="styled"> |
||
| 151 | <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/> |
||
| 152 | <paragraph lineSpacing="Single" leftIndent="5" rightIndent="5"/> |
||
| 153 | </textElement> |
||
| 154 | <textFieldExpression><![CDATA[$V{TOTAL ORCADO}]]></textFieldExpression> |
||
| 155 | </textField> |
||
| 156 | </band> |
||
| 157 | </groupFooter> |
||
| 158 | </group> |
||
| 159 | <group name="Processos"> |
||
| 160 | <groupExpression><![CDATA[$F{num_processo}]]></groupExpression> |
||
| 161 | <groupHeader> |
||
| 162 | <band height="60"> |
||
| 163 | <printWhenExpression><![CDATA[$F{num_processo} != null]]></printWhenExpression> |
||
| 164 | <rectangle> |
||
| 165 | <reportElement uuid="120af1d1-b316-415f-b102-83ad5f74b889" positionType="Float" x="0" y="20" width="556" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/> |
||
| 166 | </rectangle> |
||
| 167 | <rectangle> |
||
| 168 | <reportElement uuid="8acf1270-ae04-4b1d-9d35-e2676db01f40" positionType="Float" x="200" y="40" width="201" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/> |
||
| 169 | </rectangle> |
||
| 170 | <rectangle> |
||
| 171 | <reportElement uuid="120af1d1-b316-415f-b102-83ad5f74b889" positionType="Float" x="0" y="0" width="556" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/> |
||
| 172 | </rectangle> |
||
| 173 | <rectangle> |
||
| 174 | <reportElement uuid="7399afa6-e12e-4239-b2f7-4d8ab3ebedd2" positionType="Float" x="0" y="40" width="200" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/> |
||
| 175 | </rectangle> |
||
| 176 | <staticText> |
||
| 177 | <reportElement uuid="adf263e6-1fd6-4bdd-81e1-11434eb9de59" positionType="Float" x="0" y="40" width="199" height="20" isPrintWhenDetailOverflows="true"/> |
||
| 178 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 179 | <font isBold="true" isPdfEmbedded="false"/> |
||
| 180 | </textElement> |
||
| 181 | <text><![CDATA[ELEMENTO DE DESPESA]]></text> |
||
| 182 | </staticText> |
||
| 183 | <staticText> |
||
| 184 | <reportElement uuid="68a8ca28-9bab-47ec-8436-06ea9e2e99a1" positionType="Float" mode="Transparent" x="2" y="20" width="555" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/> |
||
| 185 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 186 | <font fontName="Arial" isBold="true"/> |
||
| 187 | <paragraph leftIndent="5" rightIndent="5"/> |
||
| 188 | </textElement> |
||
| 189 | <text><![CDATA[DESPESAS]]></text> |
||
| 190 | </staticText> |
||
| 191 | <rectangle> |
||
| 192 | <reportElement uuid="eb5a69cf-c7a4-484b-ac04-56807475c8ed" positionType="Float" x="401" y="40" width="155" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/> |
||
| 193 | </rectangle> |
||
| 194 | <staticText> |
||
| 195 | <reportElement uuid="1f2a1c8c-bd8a-4d26-9d1c-8fb5b1bd5cba" positionType="Float" x="202" y="40" width="200" height="20" isPrintWhenDetailOverflows="true"/> |
||
| 196 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 197 | <font isBold="true" isPdfEmbedded="false"/> |
||
| 198 | </textElement> |
||
| 199 | <text><![CDATA[FONTE DE RECURSO]]></text> |
||
| 200 | </staticText> |
||
| 201 | <staticText> |
||
| 202 | <reportElement uuid="08d3d480-bdf2-4f5a-b048-c9b7669eef91" positionType="Float" x="402" y="40" width="155" height="20" isPrintWhenDetailOverflows="true"/> |
||
| 203 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 204 | <font isBold="true" isPdfEmbedded="false"/> |
||
| 205 | </textElement> |
||
| 206 | <text><![CDATA[VALOR ORÇADO]]></text> |
||
| 207 | </staticText> |
||
| 208 | <textField isStretchWithOverflow="true"> |
||
| 209 | <reportElement uuid="bd7e6eee-80f8-4b1d-a789-7078dbf18cb1" positionType="Float" x="2" y="0" width="555" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/> |
||
| 210 | <textElement verticalAlignment="Middle" markup="styled"> |
||
| 211 | <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/> |
||
| 212 | <paragraph lineSpacing="Single" leftIndent="5" rightIndent="5"/> |
||
| 213 | </textElement> |
||
| 214 | <textFieldExpression><![CDATA["PROCESSO: " + $F{cod_orgao_processo}.toString() + " - " + $F{num_processo}.toString() + "/" + $F{dsc_ano_processo}]]></textFieldExpression> |
||
| 215 | </textField> |
||
| 216 | </band> |
||
| 217 | </groupHeader> |
||
| 218 | </group> |
||
| 219 | <pageHeader> |
||
| 220 | <band height="128"> |
||
| 221 | <staticText> |
||
| 222 | <reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="48" width="557" height="36"/> |
||
| 223 | <textElement textAlignment="Center" verticalAlignment="Top"> |
||
| 224 | <font fontName="Arial" size="10" isBold="false" pdfFontName="Helvetica" isPdfEmbedded="true"/> |
||
| 225 | </textElement> |
||
| 226 | <text><![CDATA[Secretaria de Estado da Saúde |
||
| 227 | Coordenadoria Setorial de Gestão e Desenvolvimento de Pessoas |
||
| 228 | Gerência de Desenvolvimento e Educação de Pessoas |
||
| 229 | ]]></text> |
||
| 230 | </staticText> |
||
| 231 | <image scaleImage="RealSize" hAlign="Center" vAlign="Middle" onErrorType="Icon"> |
||
| 232 | <reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" positionType="Float" mode="Transparent" x="258" y="0" width="33" height="36"/> |
||
| 233 | <imageExpression><![CDATA[$P{IMAGEM_DIR} + "brasao.png"]]></imageExpression> |
||
| 234 | </image> |
||
| 235 | <staticText> |
||
| 236 | <reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="37" width="557" height="12"/> |
||
| 237 | <textElement textAlignment="Center" verticalAlignment="Top"> |
||
| 238 | <font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/> |
||
| 239 | </textElement> |
||
| 240 | <text><![CDATA[Estado de Alagoas]]></text> |
||
| 241 | </staticText> |
||
| 242 | <staticText> |
||
| 243 | <reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="92" width="557" height="12"/> |
||
| 244 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 245 | <font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/> |
||
| 246 | </textElement> |
||
| 247 | <text><![CDATA[Relatório de Despesas]]></text> |
||
| 248 | </staticText> |
||
| 249 | <textField> |
||
| 250 | <reportElement uuid="57d2ab81-9a8b-4a93-90d3-a095ee79ecc4" x="0" y="105" width="557" height="12"/> |
||
| 251 | <textElement textAlignment="Center" verticalAlignment="Middle"> |
||
| 252 | <font fontName="Arial" isBold="true"/> |
||
| 253 | </textElement> |
||
| 254 | <textFieldExpression><![CDATA[$P{MES} == null ? "Período de Exercício: " + $P{ANO} : "Período de Exercício: " + $P{MES} + "/" + $P{ANO}]]></textFieldExpression> |
||
| 255 | </textField> |
||
| 256 | </band> |
||
| 257 | </pageHeader> |
||
| 258 | <detail> |
||
| 259 | <band height="20"> |
||
| 260 | <printWhenExpression><![CDATA[$F{num_processo} != null]]></printWhenExpression> |
||
| 261 | <rectangle> |
||
| 262 | <reportElement uuid="7399afa6-e12e-4239-b2f7-4d8ab3ebedd2" positionType="Float" stretchType="RelativeToBandHeight" x="0" y="0" width="200" height="20" isPrintWhenDetailOverflows="true"/> |
||
| 263 | </rectangle> |
||
| 264 | <rectangle> |
||
| 265 | <reportElement uuid="8acf1270-ae04-4b1d-9d35-e2676db01f40" positionType="Float" stretchType="RelativeToBandHeight" x="200" y="0" width="201" height="20" isPrintWhenDetailOverflows="true"/> |
||
| 266 | </rectangle> |
||
| 267 | <rectangle> |
||
| 268 | <reportElement uuid="eb5a69cf-c7a4-484b-ac04-56807475c8ed" positionType="Float" stretchType="RelativeToBandHeight" x="401" y="0" width="155" height="20" isPrintWhenDetailOverflows="true"/> |
||
| 269 | </rectangle> |
||
| 270 | <textField isStretchWithOverflow="true"> |
||
| 271 | <reportElement uuid="bd7e6eee-80f8-4b1d-a789-7078dbf18cb1" positionType="Float" stretchType="RelativeToBandHeight" x="0" y="0" width="200" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/> |
||
| 272 | <textElement verticalAlignment="Middle" markup="styled"> |
||
| 273 | <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/> |
||
| 274 | <paragraph lineSpacing="Single" leftIndent="5" rightIndent="5"/> |
||
| 275 | </textElement> |
||
| 276 | <textFieldExpression><![CDATA[$F{dsc_elemento_despesa}]]></textFieldExpression> |
||
| 277 | </textField> |
||
| 278 | <textField isStretchWithOverflow="true"> |
||
| 279 | <reportElement uuid="bd7e6eee-80f8-4b1d-a789-7078dbf18cb1" positionType="Float" stretchType="RelativeToBandHeight" x="200" y="0" width="201" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/> |
||
| 280 | <textElement verticalAlignment="Middle" markup="styled"> |
||
| 281 | <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/> |
||
| 282 | <paragraph lineSpacing="Single" leftIndent="5" rightIndent="5"/> |
||
| 283 | </textElement> |
||
| 284 | <textFieldExpression><![CDATA[$F{dsc_fonte_recurso}]]></textFieldExpression> |
||
| 285 | </textField> |
||
| 286 | <textField isStretchWithOverflow="true" pattern="¤ #,##0.00"> |
||
| 287 | <reportElement uuid="bd7e6eee-80f8-4b1d-a789-7078dbf18cb1" positionType="Float" stretchType="RelativeToBandHeight" x="401" y="0" width="156" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/> |
||
| 288 | <textElement textAlignment="Center" verticalAlignment="Middle" markup="styled"> |
||
| 289 | <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/> |
||
| 290 | <paragraph lineSpacing="Single" leftIndent="5" rightIndent="5"/> |
||
| 291 | </textElement> |
||
| 292 | <textFieldExpression><![CDATA[$F{val_orcado}]]></textFieldExpression> |
||
| 293 | </textField> |
||
| 294 | </band> |
||
| 295 | </detail> |
||
| 296 | <pageFooter> |
||
| 297 | <band height="15"> |
||
| 298 | <textField isBlankWhenNull="true"> |
||
| 299 | <reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="0" y="0" width="374" height="15"/> |
||
| 300 | <textElement verticalAlignment="Middle"> |
||
| 301 | <font fontName="Arial" size="6" isBold="false"/> |
||
| 302 | </textElement> |
||
| 303 | <textFieldExpression><![CDATA["Gerado por " + $P{NOM_USUARIO} + ", CPF: " + $P{CPF_USUARIO} + new java.text.SimpleDateFormat("', em 'dd 'de' MMMMM 'de' yyyy' às 'HH:mm", new Locale("pt", "BR")).format(new java.util.Date()).toUpperCase()]]></textFieldExpression> |
||
| 304 | </textField> |
||
| 305 | <textField isBlankWhenNull="false"> |
||
| 306 | <reportElement uuid="e5f06c72-11c0-479b-b234-4dcaf2bc0440" key="textField" x="428" y="0" width="73" height="15"/> |
||
| 307 | <textElement textAlignment="Right" verticalAlignment="Middle"> |
||
| 308 | <font fontName="Arial" size="6" isBold="false"/> |
||
| 309 | </textElement> |
||
| 310 | <textFieldExpression><![CDATA["PÁGINA " + $V{PAGE_NUMBER} + " DE "]]></textFieldExpression> |
||
| 311 | </textField> |
||
| 312 | <textField evaluationTime="Report" isBlankWhenNull="false"> |
||
| 313 | <reportElement uuid="506b9991-ff6d-43b5-ab78-2832586c3dda" key="textField" x="502" y="0" width="52" height="15"/> |
||
| 314 | <textElement verticalAlignment="Middle"> |
||
| 315 | <font fontName="Arial" size="6" isBold="false"/> |
||
| 316 | </textElement> |
||
| 317 | <textFieldExpression><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression> |
||
| 318 | </textField> |
||
| 319 | </band> |
||
| 320 | </pageFooter> |
||
| 321 | <summary> |
||
| 322 | <band height="40"> |
||
| 323 | <rectangle> |
||
| 324 | <reportElement uuid="eb5a69cf-c7a4-484b-ac04-56807475c8ed" positionType="Float" stretchType="RelativeToBandHeight" x="401" y="10" width="155" height="20" isPrintWhenDetailOverflows="true"/> |
||
| 325 | </rectangle> |
||
| 326 | <staticText> |
||
| 327 | <reportElement uuid="1f2a1c8c-bd8a-4d26-9d1c-8fb5b1bd5cba" positionType="Float" stretchType="RelativeToBandHeight" x="1" y="10" width="400" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/> |
||
| 328 | <textElement textAlignment="Right" verticalAlignment="Middle"> |
||
| 329 | <font isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/> |
||
| 330 | <paragraph leftIndent="5" rightIndent="5"/> |
||
| 331 | </textElement> |
||
| 332 | <text><![CDATA[TOTAL ORÇADO DE DESPESAS:]]></text> |
||
| 333 | </staticText> |
||
| 334 | <textField isStretchWithOverflow="true" pattern="¤ #,##0.00" isBlankWhenNull="false"> |
||
| 335 | <reportElement uuid="bd7e6eee-80f8-4b1d-a789-7078dbf18cb1" positionType="Float" stretchType="RelativeToBandHeight" x="401" y="10" width="156" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/> |
||
| 336 | <textElement textAlignment="Center" verticalAlignment="Middle" markup="styled"> |
||
| 337 | <font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/> |
||
| 338 | <paragraph lineSpacing="Single" leftIndent="5" rightIndent="5"/> |
||
| 339 | </textElement> |
||
| 340 | <textFieldExpression><![CDATA[$V{TOTAL} != null ? $V{TOTAL} : 0.00]]></textFieldExpression> |
||
| 341 | </textField> |
||
| 342 | </band> |
||
| 343 | </summary> |
||
| 344 | </jasperReport> |