233 lines
8.4 KiB
XML
233 lines
8.4 KiB
XML
<?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="informeServicioDiario" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
|
|
<property name="ireport.zoom" value="1.0"/>
|
|
<property name="ireport.x" value="0"/>
|
|
<property name="ireport.y" value="0"/>
|
|
<parameter name="sql" class="java.lang.String"/>
|
|
<parameter name="dataInicio" class="java.util.Date"/>
|
|
<parameter name="dataFinal" class="java.util.Date"/>
|
|
<parameter name="nomeEmpresa" class="java.lang.String"/>
|
|
<queryString>
|
|
<![CDATA[$P!{sql}]]>
|
|
</queryString>
|
|
<field name="servico" class="java.lang.String"/>
|
|
<field name="fechorsalida" class="java.sql.Timestamp"/>
|
|
<field name="km" class="java.math.BigDecimal"/>
|
|
<field name="qtdeservico" class="java.lang.String"/>
|
|
<field name="receita" class="java.math.BigDecimal"/>
|
|
<field name="rkm" class="java.math.BigDecimal"/>
|
|
<field name="nombempresa" class="java.lang.String"/>
|
|
<field name="descruta" class="java.lang.String"/>
|
|
<variable name="receita_1" class="java.math.BigDecimal" calculation="Sum">
|
|
<variableExpression><![CDATA[$F{receita}]]></variableExpression>
|
|
</variable>
|
|
<background>
|
|
<band splitType="Stretch"/>
|
|
</background>
|
|
<title>
|
|
<band height="50" splitType="Stretch">
|
|
<staticText>
|
|
<reportElement x="0" y="0" width="802" height="20"/>
|
|
<textElement textAlignment="Center">
|
|
<font size="14" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[INFORME SERVICIO DIARIO]]></text>
|
|
</staticText>
|
|
<textField pattern="dd/MM/yyyy">
|
|
<reportElement x="668" y="30" width="100" height="20"/>
|
|
<textElement/>
|
|
<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
|
|
</textField>
|
|
<staticText>
|
|
<reportElement x="617" y="30" width="51" height="20"/>
|
|
<textElement>
|
|
<font isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[EMISIÓN:]]></text>
|
|
</staticText>
|
|
</band>
|
|
</title>
|
|
<pageHeader>
|
|
<band height="25" splitType="Stretch">
|
|
<staticText>
|
|
<reportElement x="0" y="0" width="54" height="20"/>
|
|
<textElement>
|
|
<font isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[EMPRESA:]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement x="262" y="0" width="51" height="20"/>
|
|
<textElement>
|
|
<font isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[PERÍODO:]]></text>
|
|
</staticText>
|
|
<textField pattern="dd/MM/yyyy">
|
|
<reportElement x="313" y="0" width="85" height="20"/>
|
|
<textElement/>
|
|
<textFieldExpression class="java.util.Date"><![CDATA[$P{dataInicio}]]></textFieldExpression>
|
|
</textField>
|
|
<staticText>
|
|
<reportElement x="398" y="0" width="10" height="20"/>
|
|
<textElement>
|
|
<font isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[ - ]]></text>
|
|
</staticText>
|
|
<textField pattern="dd/MM/yyyy">
|
|
<reportElement x="408" y="0" width="84" height="20"/>
|
|
<textElement/>
|
|
<textFieldExpression class="java.util.Date"><![CDATA[$P{dataFinal}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement x="56" y="0" width="151" height="20"/>
|
|
<textElement/>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$P{nomeEmpresa}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</pageHeader>
|
|
<columnHeader>
|
|
<band height="22" splitType="Stretch">
|
|
<line>
|
|
<reportElement x="0" y="0" width="802" height="2"/>
|
|
</line>
|
|
<staticText>
|
|
<reportElement x="0" y="2" width="65" height="20"/>
|
|
<textElement>
|
|
<font isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[FECHA]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement x="65" y="2" width="178" height="20"/>
|
|
<textElement>
|
|
<font isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[RUTA]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement x="243" y="2" width="81" height="20"/>
|
|
<textElement>
|
|
<font isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[HORARIO]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement x="324" y="2" width="100" height="20"/>
|
|
<textElement>
|
|
<font isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[SERVICIO]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement x="424" y="2" width="47" height="20"/>
|
|
<textElement>
|
|
<font isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[KM]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement x="471" y="2" width="62" height="20"/>
|
|
<textElement>
|
|
<font isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[CANTIDAD]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement x="533" y="2" width="71" height="20"/>
|
|
<textElement>
|
|
<font isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[RECEITA]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement x="604" y="2" width="64" height="20"/>
|
|
<textElement>
|
|
<font isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[$ KM]]></text>
|
|
</staticText>
|
|
<line>
|
|
<reportElement x="0" y="20" width="802" height="2"/>
|
|
</line>
|
|
<staticText>
|
|
<reportElement x="668" y="2" width="134" height="20"/>
|
|
<textElement/>
|
|
<text><![CDATA[EMPRESA]]></text>
|
|
</staticText>
|
|
</band>
|
|
</columnHeader>
|
|
<detail>
|
|
<band height="22" splitType="Stretch">
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement x="324" y="0" width="100" height="20" isPrintWhenDetailOverflows="true"/>
|
|
<textElement/>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{servico}]]></textFieldExpression>
|
|
</textField>
|
|
<textField pattern="¤ #,##0.00" isBlankWhenNull="true">
|
|
<reportElement x="604" y="0" width="64" height="20" isPrintWhenDetailOverflows="true"/>
|
|
<textElement/>
|
|
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{rkm}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement x="424" y="0" width="47" height="20" isPrintWhenDetailOverflows="true"/>
|
|
<textElement/>
|
|
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{km}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement x="471" y="0" width="62" height="20" isPrintWhenDetailOverflows="true"/>
|
|
<textElement/>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{qtdeservico}]]></textFieldExpression>
|
|
</textField>
|
|
<textField pattern="¤ #,##0.00" isBlankWhenNull="true">
|
|
<reportElement x="533" y="0" width="71" height="20" isPrintWhenDetailOverflows="true"/>
|
|
<textElement/>
|
|
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{receita}]]></textFieldExpression>
|
|
</textField>
|
|
<textField pattern="h.mm a" isBlankWhenNull="true">
|
|
<reportElement x="243" y="0" width="81" height="20" isPrintWhenDetailOverflows="true"/>
|
|
<textElement/>
|
|
<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{fechorsalida}]]></textFieldExpression>
|
|
</textField>
|
|
<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
|
|
<reportElement x="0" y="0" width="65" height="20" isPrintWhenDetailOverflows="true"/>
|
|
<textElement/>
|
|
<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{fechorsalida}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement x="668" y="0" width="134" height="20" isPrintWhenDetailOverflows="true"/>
|
|
<textElement/>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{nombempresa}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement x="65" y="0" width="178" height="20"/>
|
|
<textElement/>
|
|
<textFieldExpression class="java.lang.String"><![CDATA[$F{descruta}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</detail>
|
|
<columnFooter>
|
|
<band splitType="Stretch"/>
|
|
</columnFooter>
|
|
<pageFooter>
|
|
<band splitType="Stretch"/>
|
|
</pageFooter>
|
|
<summary>
|
|
<band height="22" splitType="Stretch">
|
|
<staticText>
|
|
<reportElement x="547" y="2" width="42" height="20"/>
|
|
<textElement>
|
|
<font isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[TOTAL:]]></text>
|
|
</staticText>
|
|
<textField pattern="¤ #,##0.00">
|
|
<reportElement x="589" y="2" width="100" height="20"/>
|
|
<textElement/>
|
|
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{receita_1}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</summary>
|
|
</jasperReport>
|