You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
533 lines
28 KiB
533 lines
28 KiB
<?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="Auditoria" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="e4b6a11f-cfdc-4666-bae2-75464500b5ef">
|
|
<property name="ireport.zoom" value="1.0"/>
|
|
<property name="ireport.x" value="16"/>
|
|
<property name="ireport.y" value="0"/>
|
|
<style name="Zebrado">
|
|
<conditionalStyle>
|
|
<conditionExpression><![CDATA[new Boolean(($V{COLUMN_COUNT}.intValue() % 2) == 0)]]></conditionExpression>
|
|
<style backcolor="#CCCCCC"/>
|
|
</conditionalStyle>
|
|
<conditionalStyle>
|
|
<conditionExpression><![CDATA[new Boolean(($V{COLUMN_COUNT}.intValue() % 2) != 0)]]></conditionExpression>
|
|
<style/>
|
|
</conditionalStyle>
|
|
</style>
|
|
<style name="ResultadoFinal">
|
|
<conditionalStyle>
|
|
<conditionExpression><![CDATA[(($V{variable8}/$V{variable9})/100) < ($F{ruim} / 100)]]></conditionExpression>
|
|
<style forecolor="#FF0000"/>
|
|
</conditionalStyle>
|
|
<conditionalStyle>
|
|
<conditionExpression><![CDATA[(($V{variable8}/$V{variable9})/100) > ($F{bommaior} / 100) && (($V{variable8}/$V{variable9})/100) < ($F{bommenor} / 100)]]></conditionExpression>
|
|
<style forecolor="#FFFF00"/>
|
|
</conditionalStyle>
|
|
<conditionalStyle>
|
|
<conditionExpression><![CDATA[((($V{variable8}/$V{variable9})/100) > ($F{mbommaior} / 100)) && ((($V{variable8}/$V{variable9})/100) < ($F{mbommenor} / 100))]]></conditionExpression>
|
|
<style forecolor="#009900"/>
|
|
</conditionalStyle>
|
|
<conditionalStyle>
|
|
<conditionExpression><![CDATA[(($V{variable8}/$V{variable9})/100) >= ($F{excelente} / 100)]]></conditionExpression>
|
|
<style forecolor="#0033FF"/>
|
|
</conditionalStyle>
|
|
</style>
|
|
<parameter name="auditoria" class="java.lang.Long">
|
|
<defaultValueExpression><![CDATA[342]]></defaultValueExpression>
|
|
</parameter>
|
|
<queryString>
|
|
<![CDATA[Select c.titulo, cc.empresa, e.datahoraabertura, cc.observacoes,
|
|
(Select razao_social from nauth.empresa where empresa_id = cc.empresa) razao_social,
|
|
(Select ponto_avaliado from auditoria_execucao_questoes where chave_item = cc.chave_questao) ponto_avaliado,
|
|
(Select tag_id from auditoria_execucao_questoes where chave_item = cc.chave_questao) tag,
|
|
(Select tag_id2 from auditoria_execucao_questoes where chave_item = cc.chave_questao) tag2,
|
|
(Select tag_id3 from auditoria_execucao_questoes where chave_item = cc.chave_questao) tag3,
|
|
(Select tipo_questao from auditoria_execucao_questoes where chave_item = cc.chave_questao) tipoQuestao,
|
|
(Select pontuacao from auditoria_execucao_questoes where chave_item = cc.chave_questao) peso,
|
|
case when cast((Select tipo_questao from auditoria_execucao_questoes where chave_item = cc.chave_questao) as varchar(50)) in ('Lista','Sim/Não','Satisfação') then cast((Select texto from auditoria_execucao_lista where cast(chave_item_lista AS varchar(50)) = cc.resposta) as varchar(50))
|
|
else cast(cc.resposta as varchar(50)) end resposta,
|
|
case when cast((Select tipo_questao from auditoria_execucao_questoes where chave_item = cc.chave_questao) as varchar(50)) in ('Lista','Sim/Não','Satisfação') then (Select pontuacao from auditoria_execucao_lista where cast(chave_item_lista as varchar(50)) = cc.resposta)
|
|
end pontoslista,
|
|
case when cast((Select tipo_questao from auditoria_execucao_questoes where chave_item = cc.chave_questao) as varchar(50)) in ('Lista','Sim/Não','Satisfação') then cast((Select naoaplicavel from auditoria_execucao_lista where cast(chave_item_lista as varchar(50)) = cc.resposta) as varchar(50))
|
|
end naoaplicavel,
|
|
(Select nome from nauth.usuario where login = cc.executor) executor,
|
|
(Select ordem from auditoria_execucao_questoes where chave_item = cc.chave_questao) ordem,
|
|
(Select percruim from auditoria where chave_auditoria = c.chave_auditoria) ruim,
|
|
(Select percbommaior from auditoria where chave_auditoria = c.chave_auditoria) bommaior,
|
|
(Select percbommenor from auditoria where chave_auditoria = c.chave_auditoria) bommenor,
|
|
(Select percmbommaior from auditoria where chave_auditoria = c.chave_auditoria) mbommaior,
|
|
(Select percmbommenor from auditoria where chave_auditoria = c.chave_auditoria) mbommenor,
|
|
(Select percexcelente from auditoria where chave_auditoria = c.chave_auditoria) excelente,
|
|
(select coalesce(pesoag1,0) from auditoria_execucao_questoes where chave_item = cc.chave_questao) pesoag1,
|
|
(select coalesce(pesoag2,0) + coalesce(pesoag3,0) from auditoria_execucao_questoes where chave_item = cc.chave_questao) pesoag2_3,
|
|
(Select max(pontuacao) from auditoria_execucao_lista where chave_item = cc.chave_questao) as pontopadrao
|
|
from auditoria_coleta cc inner join auditoria_execucao e on cc.chave_processo = e.chave_execucao inner join auditoria c on c.chave_auditoria = e.chave_auditoria where e.chave_execucao = $P{auditoria} group by cc.empresa,c.titulo,cc.chave_questao, cc.resposta, e.datahoraabertura, cc.observacoes, cc.executor, c.chave_auditoria order by 7,8]]>
|
|
</queryString>
|
|
<field name="titulo" class="java.lang.String"/>
|
|
<field name="empresa" class="java.lang.Integer"/>
|
|
<field name="datahoraabertura" class="java.sql.Date"/>
|
|
<field name="observacoes" class="java.lang.String"/>
|
|
<field name="razao_social" class="java.lang.String"/>
|
|
<field name="ponto_avaliado" class="java.lang.String"/>
|
|
<field name="tag" class="java.lang.String"/>
|
|
<field name="tipoquestao" class="java.lang.String"/>
|
|
<field name="peso" class="java.math.BigDecimal"/>
|
|
<field name="resposta" class="java.lang.String"/>
|
|
<field name="pontoslista" class="java.lang.Float"/>
|
|
<field name="naoaplicavel" class="java.lang.String"/>
|
|
<field name="tag2" class="java.lang.String"/>
|
|
<field name="tag3" class="java.lang.String"/>
|
|
<field name="executor" class="java.lang.String"/>
|
|
<field name="ruim" class="java.lang.Float"/>
|
|
<field name="bommaior" class="java.lang.Float"/>
|
|
<field name="bommenor" class="java.lang.Float"/>
|
|
<field name="mbommaior" class="java.lang.Float"/>
|
|
<field name="mbommenor" class="java.lang.Float"/>
|
|
<field name="excelente" class="java.lang.Float"/>
|
|
<field name="pesoag1" class="java.math.BigDecimal"/>
|
|
<field name="pesoag2_3" class="java.math.BigDecimal"/>
|
|
<field name="pontopadrao" class="java.math.BigDecimal"/>
|
|
<variable name="somaPontos" class="java.lang.Float" resetType="Group" resetGroup="Tag" calculation="Sum">
|
|
<variableExpression><![CDATA[$F{tipoquestao}.equals("NPS") ? ((Double.valueOf($F{resposta}) * $F{peso}.doubleValue()) * $F{pesoag2_3}.doubleValue()) :
|
|
$F{tipoquestao}.equals("Lista") || $F{tipoquestao}.equals("Sim/Não") || $F{tipoquestao}.equals("Satisfação") ? (($F{pontoslista}.doubleValue() * $F{peso}.doubleValue()) * $F{pesoag2_3}.doubleValue()) :
|
|
0]]></variableExpression>
|
|
<initialValueExpression><![CDATA[0]]></initialValueExpression>
|
|
</variable>
|
|
<variable name="pesotag" class="java.lang.Float" resetType="Group" resetGroup="Tag" calculation="Sum">
|
|
<variableExpression><![CDATA[$F{tipoquestao}.equals("Lista") || $F{tipoquestao}.equals("Sim/Não") ? $F{naoaplicavel}.equals("Não") ? (($F{pontopadrao}.doubleValue() * $F{peso}.doubleValue()) * $F{pesoag2_3}.doubleValue()) : 0 : (($F{pontopadrao}.doubleValue() * $F{peso}.doubleValue()) * $F{pesoag2_3}.doubleValue())]]></variableExpression>
|
|
<initialValueExpression><![CDATA[0]]></initialValueExpression>
|
|
</variable>
|
|
<variable name="totalPontos" class="java.lang.Float" resetType="Group" resetGroup="Empresa" calculation="Sum">
|
|
<variableExpression><![CDATA[$F{tipoquestao}.equals("NPS") ? ((Double.valueOf($F{resposta}) * $F{peso}.doubleValue()) * $F{pesoag2_3}.doubleValue()) * $F{pesoag1}.doubleValue() :
|
|
$F{tipoquestao}.equals("Lista") || $F{tipoquestao}.equals("Sim/Não") || $F{tipoquestao}.equals("Satisfação") ? ((($F{pontoslista}.doubleValue() * $F{peso}.doubleValue()) * $F{pesoag2_3}.doubleValue())) * $F{pesoag1}.doubleValue() :
|
|
0]]></variableExpression>
|
|
<initialValueExpression><![CDATA[0]]></initialValueExpression>
|
|
</variable>
|
|
<variable name="pesoTotal" class="java.lang.Float" resetType="Group" resetGroup="Empresa" calculation="Sum">
|
|
<variableExpression><![CDATA[$F{naoaplicavel}.equals("Não") ? ((($F{pontopadrao}.doubleValue() * $F{peso}.doubleValue()) * $F{pesoag2_3}.doubleValue())) * $F{pesoag1}.doubleValue() : 0]]></variableExpression>
|
|
<initialValueExpression><![CDATA[0]]></initialValueExpression>
|
|
</variable>
|
|
<variable name="ag" class="java.lang.Float" resetType="Group" resetGroup="Tag2">
|
|
<variableExpression><![CDATA[$F{pesoag2_3}.doubleValue()]]></variableExpression>
|
|
<initialValueExpression><![CDATA[Float.valueOf(0)]]></initialValueExpression>
|
|
</variable>
|
|
<variable name="variable1" class="java.lang.Float" resetType="Group" resetGroup="Tag" calculation="Sum">
|
|
<variableExpression><![CDATA[$F{pontoslista}]]></variableExpression>
|
|
<initialValueExpression><![CDATA[0]]></initialValueExpression>
|
|
</variable>
|
|
<variable name="variable2" class="java.lang.Float" resetType="Group" resetGroup="Tag" calculation="Sum">
|
|
<variableExpression><![CDATA[$F{peso}]]></variableExpression>
|
|
<initialValueExpression><![CDATA[0]]></initialValueExpression>
|
|
</variable>
|
|
<variable name="variable3" class="java.lang.Float" resetType="Group" resetGroup="Tag2" calculation="Sum">
|
|
<variableExpression><![CDATA[$F{resposta}.equals("Não") ? 0 : $F{peso}]]></variableExpression>
|
|
<initialValueExpression><![CDATA[0]]></initialValueExpression>
|
|
</variable>
|
|
<variable name="variable4" class="java.lang.Double" resetType="Group" resetGroup="Tag2">
|
|
<variableExpression><![CDATA[$V{variable3} * $F{pesoag2_3}.doubleValue()]]></variableExpression>
|
|
<initialValueExpression><![CDATA[0]]></initialValueExpression>
|
|
</variable>
|
|
<variable name="variable5" class="java.lang.Double" resetType="Group" resetGroup="Tag" incrementType="Group" incrementGroup="Tag2" calculation="Sum">
|
|
<variableExpression><![CDATA[$V{variable4}]]></variableExpression>
|
|
<initialValueExpression><![CDATA[0]]></initialValueExpression>
|
|
</variable>
|
|
<variable name="TotalPercentual" class="java.lang.Float" resetType="Group" resetGroup="Tag" incrementType="Group" incrementGroup="Tag2" calculation="Sum">
|
|
<variableExpression><![CDATA[$F{pesoag2_3}.doubleValue()]]></variableExpression>
|
|
<initialValueExpression><![CDATA[0]]></initialValueExpression>
|
|
</variable>
|
|
<variable name="variable6" class="java.lang.Float" resetType="Group" resetGroup="Tag" incrementType="Group" incrementGroup="Tag" calculation="Sum">
|
|
<variableExpression><![CDATA[($V{variable5}/$V{TotalPercentual})]]></variableExpression>
|
|
</variable>
|
|
<variable name="variable7" class="java.lang.Double" resetType="Group" resetGroup="Tag" incrementType="Group" incrementGroup="Tag">
|
|
<variableExpression><![CDATA[$V{variable6}*$F{pesoag1}.doubleValue()]]></variableExpression>
|
|
<initialValueExpression><![CDATA[0]]></initialValueExpression>
|
|
</variable>
|
|
<variable name="variable8" class="java.lang.Double" resetType="Group" resetGroup="Empresa" incrementType="Group" incrementGroup="Tag" calculation="Sum">
|
|
<variableExpression><![CDATA[$V{variable7}]]></variableExpression>
|
|
<initialValueExpression><![CDATA[0]]></initialValueExpression>
|
|
</variable>
|
|
<variable name="variable9" class="java.lang.Double" resetType="Group" resetGroup="Empresa" incrementType="Group" incrementGroup="Tag" calculation="Sum">
|
|
<variableExpression><![CDATA[$F{pesoag1}.doubleValue()]]></variableExpression>
|
|
<initialValueExpression><![CDATA[0]]></initialValueExpression>
|
|
</variable>
|
|
<group name="Empresa" isStartNewPage="true">
|
|
<groupExpression><![CDATA[$F{empresa}]]></groupExpression>
|
|
<groupHeader>
|
|
<band height="147">
|
|
<rectangle>
|
|
<reportElement x="0" y="117" width="802" height="26" uuid="6d401b0b-2a4b-46a5-9bff-6a753aa89335"/>
|
|
</rectangle>
|
|
<rectangle>
|
|
<reportElement x="0" y="91" width="802" height="26" uuid="723774cd-c87b-480c-91d6-d289cdaf1002"/>
|
|
</rectangle>
|
|
<staticText>
|
|
<reportElement mode="Opaque" x="8" y="94" width="100" height="20" backcolor="#FFFFFF" uuid="338a617f-4f34-4b23-94ec-efad5d381b13"/>
|
|
<textElement verticalAlignment="Middle">
|
|
<font fontName="Arial" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Estabelecimento]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement mode="Opaque" x="8" y="121" width="100" height="20" backcolor="#FFFFFF" uuid="1c77aa9b-7a45-4f00-9b59-ecefa3c88d1d"/>
|
|
<textElement verticalAlignment="Middle">
|
|
<font fontName="Arial" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Data]]></text>
|
|
</staticText>
|
|
<textField>
|
|
<reportElement x="125" y="94" width="640" height="20" uuid="305e2d20-dd62-439f-aed9-fac4885c7a94"/>
|
|
<textElement verticalAlignment="Middle">
|
|
<font fontName="Arial" size="12"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{razao_social}]]></textFieldExpression>
|
|
</textField>
|
|
<textField pattern="dd/MM/yyyy">
|
|
<reportElement x="125" y="120" width="640" height="20" uuid="a319faba-b59d-424f-a3fa-6158bdd62b2e"/>
|
|
<textElement verticalAlignment="Middle">
|
|
<font fontName="Arial" size="12"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{datahoraabertura}]]></textFieldExpression>
|
|
</textField>
|
|
<image onErrorType="Blank">
|
|
<reportElement x="0" y="0" width="134" height="65" uuid="ba582c8d-385a-4dbe-9d42-f53922d47fcb"/>
|
|
<imageExpression><![CDATA[new String("http://vitruvio.davinti.com.br/VAADIN/themes/vitruvio/images/logo_davinti_horizontal.jpg")]]></imageExpression>
|
|
</image>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement x="144" y="0" width="460" height="52" uuid="2d559c2c-c497-4399-b709-bce358d62f8d"/>
|
|
<textElement textAlignment="Center" verticalAlignment="Top">
|
|
<font fontName="Arial" size="16" isBold="true"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{titulo}]]></textFieldExpression>
|
|
</textField>
|
|
<line>
|
|
<reportElement x="114" y="91" width="1" height="52" uuid="7ea26dfd-b5ba-45b4-8d60-449289edccdb"/>
|
|
</line>
|
|
<staticText>
|
|
<reportElement x="665" y="1" width="100" height="16" uuid="14ec0b94-2e93-4d4c-9a79-fddf49a55d0d"/>
|
|
<textElement verticalAlignment="Middle">
|
|
<font fontName="Arial"/>
|
|
</textElement>
|
|
<text><![CDATA[Legenda:]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement mode="Opaque" x="307" y="120" width="65" height="20" backcolor="#FFFFFF" uuid="0debd94f-455d-486e-aa2f-1d3cbefb861c"/>
|
|
<textElement verticalAlignment="Middle">
|
|
<font fontName="Arial" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Executor:]]></text>
|
|
</staticText>
|
|
<textField>
|
|
<reportElement x="372" y="123" width="393" height="20" uuid="185d27ee-267c-4613-9477-abd0761711a3"/>
|
|
<textElement>
|
|
<font fontName="Arial" size="12"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{executor}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement mode="Opaque" x="604" y="17" width="161" height="16" backcolor="#FF3333" uuid="b8d15b29-e2da-42ca-a112-afc81d3dc115"/>
|
|
<textElement verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA["<= " + $F{ruim} + "% - Ruim"]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement mode="Opaque" x="604" y="33" width="161" height="16" backcolor="#FFFF00" uuid="3e5ee933-f0a0-4065-9040-3f18852e9027"/>
|
|
<textElement verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA["> " + $F{bommaior} + "% < " + $F{bommenor} + "% - Bom"]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement mode="Opaque" x="604" y="49" width="161" height="16" backcolor="#339900" uuid="a57ec0b1-a68b-4002-b9d9-6db038257571"/>
|
|
<textElement verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA["> " + $F{mbommaior} + "% < " + $F{mbommenor} + "% - Muito Bom"]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement mode="Opaque" x="604" y="65" width="161" height="16" backcolor="#0099FF" uuid="be24bafc-afd1-42ba-8513-92bb7091c35d"/>
|
|
<textElement verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[">= " + $F{excelente} + "% - Excelente"]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</groupHeader>
|
|
<groupFooter>
|
|
<band height="49">
|
|
<rectangle>
|
|
<reportElement x="0" y="0" width="802" height="48" backcolor="#CCCCCC" uuid="8b6f57aa-25c8-4181-839a-d50a8d79d242"/>
|
|
<graphicElement>
|
|
<pen lineWidth="0.0"/>
|
|
</graphicElement>
|
|
</rectangle>
|
|
<textField>
|
|
<reportElement x="8" y="7" width="682" height="18" uuid="985d8990-ca08-4283-807f-94be88d4b1ea"/>
|
|
<textElement>
|
|
<font fontName="Arial" size="12" isBold="true"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{titulo} + " - " + $F{razao_social}]]></textFieldExpression>
|
|
</textField>
|
|
<staticText>
|
|
<reportElement x="8" y="28" width="126" height="20" uuid="4cc062f6-e3c6-4d5e-a376-be418ba5209d"/>
|
|
<textElement>
|
|
<font fontName="Arial" size="12" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Aproveitamento total:]]></text>
|
|
</staticText>
|
|
<textField pattern="#,##0.00 %">
|
|
<reportElement style="ResultadoFinal" x="151" y="28" width="100" height="20" uuid="9446b98a-9113-4005-aadb-9f0c91e5d55d"/>
|
|
<textElement verticalAlignment="Top">
|
|
<font fontName="Arial" size="12" isBold="true"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[($V{variable8}/$V{variable9})/100]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</groupFooter>
|
|
</group>
|
|
<group name="Tag" isReprintHeaderOnEachPage="true">
|
|
<groupExpression><![CDATA[$F{tag}]]></groupExpression>
|
|
<groupHeader>
|
|
<band height="38">
|
|
<rectangle>
|
|
<reportElement x="1" y="18" width="802" height="20" backcolor="#999999" uuid="76c8d6d9-bf36-4b85-88a1-6e90ced84a9b"/>
|
|
<graphicElement>
|
|
<pen lineWidth="0.0"/>
|
|
</graphicElement>
|
|
</rectangle>
|
|
<textField isStretchWithOverflow="true">
|
|
<reportElement stretchType="RelativeToTallestObject" x="4" y="18" width="787" height="20" uuid="681c373a-6a6f-4c4e-970e-0374f3e2f3ee">
|
|
<printWhenExpression><![CDATA[$F{tag} != null]]></printWhenExpression>
|
|
</reportElement>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="Arial" size="12" isBold="true"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA["Agrupador I: " + $F{tag}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement x="702" y="18" width="100" height="20" uuid="85e1f428-a9b6-42ee-b123-86e109c0a9d6"/>
|
|
<textElement>
|
|
<font fontName="Arial" size="12" isBold="true"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{pesoag1}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</groupHeader>
|
|
<groupFooter>
|
|
<band height="30">
|
|
<rectangle>
|
|
<reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="802" height="30" backcolor="#0099FF" uuid="ddcf7f2b-359e-49f7-bf32-dc8aed82ec14">
|
|
<printWhenExpression><![CDATA[(($V{variable5}/$V{TotalPercentual})/100) >= ($F{excelente} / 100)]]></printWhenExpression>
|
|
</reportElement>
|
|
<graphicElement>
|
|
<pen lineWidth="0.0"/>
|
|
</graphicElement>
|
|
</rectangle>
|
|
<rectangle>
|
|
<reportElement stretchType="RelativeToBandHeight" x="1" y="0" width="802" height="30" backcolor="#FF3300" uuid="f84e3e1b-e64a-45c2-a326-8bb7f1a38801">
|
|
<printWhenExpression><![CDATA[(($V{variable5}/$V{TotalPercentual})/100) == 0]]></printWhenExpression>
|
|
</reportElement>
|
|
<graphicElement>
|
|
<pen lineWidth="0.0"/>
|
|
</graphicElement>
|
|
</rectangle>
|
|
<rectangle>
|
|
<reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="802" height="30" backcolor="#00CC00" uuid="d1410353-9737-452a-9453-cbf9865d13ae">
|
|
<printWhenExpression><![CDATA[((($V{variable5}/$V{TotalPercentual})/100) > ($F{mbommaior} / 100)) && ((($V{variable5}/$V{TotalPercentual})/100) < ($F{mbommenor} / 100))]]></printWhenExpression>
|
|
</reportElement>
|
|
<graphicElement>
|
|
<pen lineWidth="0.0"/>
|
|
</graphicElement>
|
|
</rectangle>
|
|
<rectangle>
|
|
<reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="802" height="30" backcolor="#FFFF00" uuid="c4b994bb-63f2-41c3-a119-ca05a3094b92">
|
|
<printWhenExpression><![CDATA[((($V{variable5}/$V{TotalPercentual})/100) > ($F{bommaior} / 100)) && ((($V{variable5}/$V{TotalPercentual})/100) < ($F{bommenor} / 100))]]></printWhenExpression>
|
|
</reportElement>
|
|
<graphicElement>
|
|
<pen lineWidth="0.0"/>
|
|
</graphicElement>
|
|
</rectangle>
|
|
<rectangle>
|
|
<reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="802" height="30" backcolor="#FF3300" uuid="a90b0e3a-1d49-41e3-ac83-c62b8118198b">
|
|
<printWhenExpression><![CDATA[(($V{variable5}/$V{TotalPercentual})/100) < ($F{ruim} / 100)]]></printWhenExpression>
|
|
</reportElement>
|
|
<graphicElement>
|
|
<pen lineWidth="0.0"/>
|
|
</graphicElement>
|
|
</rectangle>
|
|
<textField>
|
|
<reportElement x="4" y="4" width="368" height="20" uuid="fcc11049-032d-4777-abe0-5a7944a4c8fd"/>
|
|
<textElement verticalAlignment="Middle">
|
|
<font fontName="Arial" size="12" isBold="true"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA["Pontuação " + $F{tag}]]></textFieldExpression>
|
|
</textField>
|
|
<staticText>
|
|
<reportElement x="634" y="6" width="93" height="20" uuid="fb1b0601-d877-4609-a579-38932b6c3af3"/>
|
|
<textElement verticalAlignment="Middle">
|
|
<font fontName="Arial" size="11" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Aproveitamento:]]></text>
|
|
</staticText>
|
|
<textField pattern="#,##0.00 %" isBlankWhenNull="true">
|
|
<reportElement x="733" y="6" width="58" height="20" uuid="e4e53b27-59a7-46e6-a556-64dc1ec0fa05"/>
|
|
<textElement verticalAlignment="Middle">
|
|
<font fontName="Arial" size="12" isBold="true"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[($V{variable5}/$V{TotalPercentual})/100]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</groupFooter>
|
|
</group>
|
|
<group name="Tag2">
|
|
<groupExpression><![CDATA[$F{tag2}]]></groupExpression>
|
|
<groupHeader>
|
|
<band height="67">
|
|
<rectangle>
|
|
<reportElement x="1" y="-1" width="802" height="24" backcolor="#999999" uuid="76cd3977-1921-4617-accb-537cc5c68e20"/>
|
|
<graphicElement>
|
|
<pen lineWidth="0.0"/>
|
|
</graphicElement>
|
|
</rectangle>
|
|
<rectangle>
|
|
<reportElement mode="Opaque" x="1" y="47" width="802" height="20" backcolor="#FF9900" uuid="779e4803-2962-41ca-a034-bc34dcf3775e"/>
|
|
<graphicElement>
|
|
<pen lineWidth="0.0"/>
|
|
</graphicElement>
|
|
</rectangle>
|
|
<staticText>
|
|
<reportElement x="10" y="46" width="132" height="20" uuid="afdf713b-7896-48c9-ad9a-e2ba6fe59bbd"/>
|
|
<textElement verticalAlignment="Middle">
|
|
<font fontName="Arial" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Ponto avaliado]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement x="374" y="46" width="100" height="20" uuid="d7a35127-2a1e-42c6-b372-455bf3d032b0"/>
|
|
<textElement verticalAlignment="Middle">
|
|
<font fontName="Arial" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Resposta]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement x="639" y="47" width="100" height="20" uuid="46e722a3-a332-4fd8-b610-cd4bfa21a2e9"/>
|
|
<textElement verticalAlignment="Middle">
|
|
<font fontName="Arial" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Observações]]></text>
|
|
</staticText>
|
|
<textField isStretchWithOverflow="true">
|
|
<reportElement stretchType="RelativeToTallestObject" x="35" y="2" width="627" height="20" backcolor="#999999" uuid="b2d0d063-8afa-4f0e-9f48-1dda14a4cacd">
|
|
<printWhenExpression><![CDATA[$F{tag2} != null]]></printWhenExpression>
|
|
</reportElement>
|
|
<textElement verticalAlignment="Middle">
|
|
<font fontName="Arial" size="12" isBold="true"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA["Agrupador II: " + $F{tag2}]]></textFieldExpression>
|
|
</textField>
|
|
<rectangle>
|
|
<reportElement x="1" y="23" width="802" height="24" backcolor="#999999" uuid="987b2e7e-a674-4ee0-9221-6ba6fc09f30a"/>
|
|
<graphicElement>
|
|
<pen lineWidth="0.0"/>
|
|
</graphicElement>
|
|
</rectangle>
|
|
<textField isStretchWithOverflow="true">
|
|
<reportElement stretchType="RelativeToTallestObject" x="66" y="26" width="757" height="20" backcolor="#999999" uuid="12dbf431-97d4-496c-a72e-9e64022d1c3c">
|
|
<printWhenExpression><![CDATA[$F{tag3} != null]]></printWhenExpression>
|
|
</reportElement>
|
|
<textElement verticalAlignment="Middle">
|
|
<font fontName="Arial" size="12" isBold="true"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA["Agrupador III: " + $F{tag3}]]></textFieldExpression>
|
|
</textField>
|
|
<staticText>
|
|
<reportElement x="545" y="47" width="100" height="20" uuid="ea418daa-74cb-41d9-aad1-f8dec9d71791"/>
|
|
<textElement verticalAlignment="Middle">
|
|
<font fontName="Arial" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Pontos]]></text>
|
|
</staticText>
|
|
<textField>
|
|
<reportElement x="702" y="3" width="100" height="20" uuid="01853d78-3b22-4fc4-9d14-5c15025cc2f6"/>
|
|
<textElement>
|
|
<font fontName="Arial" size="12" isBold="true"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{pesoag2_3}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</groupHeader>
|
|
<groupFooter>
|
|
<band height="20">
|
|
<textField>
|
|
<reportElement x="545" y="0" width="85" height="20" uuid="c3cb83da-c3e6-42a3-b523-7c967fa3a776"/>
|
|
<textElement>
|
|
<font fontName="Arial" isBold="true"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$V{variable3}]]></textFieldExpression>
|
|
</textField>
|
|
<staticText>
|
|
<reportElement x="373" y="0" width="167" height="20" uuid="064c9fc2-2541-4d24-bec9-8b57573d1a21"/>
|
|
<textElement>
|
|
<font fontName="Arial" size="10" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Total.............................................:]]></text>
|
|
</staticText>
|
|
</band>
|
|
</groupFooter>
|
|
</group>
|
|
<background>
|
|
<band splitType="Stretch"/>
|
|
</background>
|
|
<title>
|
|
<band splitType="Stretch"/>
|
|
</title>
|
|
<pageHeader>
|
|
<band splitType="Stretch"/>
|
|
</pageHeader>
|
|
<columnHeader>
|
|
<band splitType="Stretch"/>
|
|
</columnHeader>
|
|
<detail>
|
|
<band height="29" splitType="Stretch">
|
|
<rectangle>
|
|
<reportElement style="Zebrado" stretchType="RelativeToBandHeight" x="0" y="0" width="802" height="29" uuid="1a312610-9126-4335-89dd-6da3015692cd"/>
|
|
<graphicElement>
|
|
<pen lineWidth="0.0"/>
|
|
</graphicElement>
|
|
</rectangle>
|
|
<textField isStretchWithOverflow="true">
|
|
<reportElement stretchType="RelativeToTallestObject" isPrintRepeatedValues="false" x="15" y="5" width="336" height="20" uuid="80e611e0-6e7f-4a06-b127-33d73343d7a0"/>
|
|
<textElement textAlignment="Justified" verticalAlignment="Top">
|
|
<font fontName="Arial"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{ponto_avaliado}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true">
|
|
<reportElement stretchType="RelativeToTallestObject" x="372" y="5" width="168" height="20" uuid="823c9277-6dc9-472f-a1a7-25fc955804bb"/>
|
|
<textElement verticalAlignment="Top">
|
|
<font fontName="Arial"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{resposta}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement stretchType="RelativeToTallestObject" x="637" y="5" width="155" height="20" uuid="093be4ce-d0bf-4bf1-bf24-556142a3a3eb"/>
|
|
<textElement verticalAlignment="Top">
|
|
<font fontName="Arial"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{observacoes}]]></textFieldExpression>
|
|
</textField>
|
|
<textField pattern="###0.00" isBlankWhenNull="true">
|
|
<reportElement x="545" y="5" width="85" height="20" uuid="b150bf60-054b-441d-bd04-73ddee918f00"/>
|
|
<textElement>
|
|
<font fontName="Arial" isBold="false"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{resposta}.equals("Não") ? 0 : $F{peso}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</detail>
|
|
<columnFooter>
|
|
<band splitType="Stretch"/>
|
|
</columnFooter>
|
|
<pageFooter>
|
|
<band height="50" splitType="Stretch">
|
|
<image>
|
|
<reportElement x="651" y="0" width="140" height="50" uuid="9c042d00-6351-4972-9f9e-eda386f69b4e"/>
|
|
<imageExpression><![CDATA[new String("http://vitruvio.davinti.com.br/VAADIN/themes/vitruvio/images/logo_davinti_horizontal.jpg")]]></imageExpression>
|
|
</image>
|
|
</band>
|
|
</pageFooter>
|
|
<summary>
|
|
<band splitType="Stretch"/>
|
|
</summary>
|
|
</jasperReport>
|