<?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="reporte_estacionamiento" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" 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="fecha_ini" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="fecha_fin" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="logo" class="java.lang.String"/>
	<parameter name="totalestacionamiento" class="java.lang.String"/>
	<parameter name="total_lavado" class="java.lang.String"/>
	<parameter name="totalpension" class="java.lang.String"/>
	<parameter name="estacionamiento_total" class="java.lang.String"/>
	<parameter name="consultaporusuario" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select * from entradas where (fecha>=$P{fecha_ini} and fecha<=$P{fecha_fin}) and Estatus=1 and idusuario=$P{consultaporusuario}]]>
	</queryString>
	<field name="id_entrada" class="java.lang.Integer"/>
	<field name="fecha" class="java.sql.Date"/>
	<field name="fecha_entrada" class="java.sql.Timestamp"/>
	<field name="fecha_salida" class="java.sql.Timestamp"/>
	<field name="monto" class="java.lang.Float"/>
	<field name="placas" class="java.lang.String"/>
	<field name="marca" class="java.lang.String"/>
	<field name="modelo" class="java.lang.String"/>
	<field name="codigo_barras" class="java.lang.String"/>
	<field name="costo_hora" class="java.lang.String"/>
	<field name="id_usuario" class="java.lang.String"/>
	<field name="id_usuario_salida" class="java.lang.String"/>
	<field name="folio" class="java.lang.String"/>
	<field name="Estatus" class="java.lang.Integer"/>
	<field name="tipo_auto" class="java.lang.String"/>
	<field name="costo_lavado" class="java.lang.Float"/>
	<field name="costo_pension" class="java.lang.Float"/>
	<field name="pension" class="java.lang.String"/>
	<field name="total_estacionamiento" class="java.lang.Float"/>
	<field name="idusuario" class="java.lang.Integer"/>
	<field name="tiempo_estancia" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="103" splitType="Stretch">
			<staticText>
				<reportElement x="6" y="10" width="303" height="24" forecolor="#0000FF"/>
				<textElement>
					<font size="18" isBold="true"/>
				</textElement>
				<text><![CDATA[REPORTE DE INGRESOS]]></text>
			</staticText>
			<image>
				<reportElement x="359" y="12" width="186" height="66"/>
				<imageExpression class="java.lang.String"><![CDATA[$P{logo}]]></imageExpression>
			</image>
			<line>
				<reportElement x="4" y="102" width="542" height="1"/>
			</line>
			<staticText>
				<reportElement x="6" y="35" width="188" height="18" forecolor="#FF3300"/>
				<textElement>
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[TOTAL ESTACIONAMIENTO: $]]></text>
			</staticText>
			<staticText>
				<reportElement x="6" y="54" width="128" height="15"/>
				<textElement>
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[LAVADO: $]]></text>
			</staticText>
			<textField>
				<reportElement x="194" y="35" width="115" height="18" forecolor="#FF3300"/>
				<textElement>
					<font size="12" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{totalestacionamiento}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="134" y="54" width="99" height="16"/>
				<textElement>
					<font size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{total_lavado}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="7" y="70" width="127" height="15"/>
				<textElement>
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[PENSIÓN: $]]></text>
			</staticText>
			<staticText>
				<reportElement x="7" y="85" width="127" height="16"/>
				<textElement>
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[ESTACIONAMIENTO: $]]></text>
			</staticText>
			<textField>
				<reportElement x="134" y="70" width="99" height="15"/>
				<textElement>
					<font size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{totalpension}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="134" y="85" width="118" height="16"/>
				<textElement>
					<font size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{estacionamiento_total}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="8" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="30" splitType="Stretch">
			<staticText>
				<reportElement x="0" y="7" width="87" height="20"/>
				<textElement>
					<font size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[Fecha Entrada]]></text>
			</staticText>
			<staticText>
				<reportElement x="87" y="7" width="83" height="20"/>
				<textElement>
					<font size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[Fecha Salida]]></text>
			</staticText>
			<staticText>
				<reportElement x="170" y="7" width="81" height="20"/>
				<textElement>
					<font size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[Placa]]></text>
			</staticText>
			<staticText>
				<reportElement x="251" y="7" width="58" height="20"/>
				<textElement>
					<font size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[Marca]]></text>
			</staticText>
			<staticText>
				<reportElement x="496" y="7" width="59" height="20"/>
				<textElement>
					<font size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[Total]]></text>
			</staticText>
			<staticText>
				<reportElement x="310" y="7" width="69" height="20"/>
				<textElement>
					<font size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[Lavado]]></text>
			</staticText>
			<staticText>
				<reportElement x="380" y="7" width="56" height="20"/>
				<textElement>
					<font size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[Pensión]]></text>
			</staticText>
			<staticText>
				<reportElement x="439" y="7" width="52" height="20"/>
				<textElement>
					<font size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[Estaciona.]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="27" splitType="Stretch">
			<textField>
				<reportElement x="0" y="5" width="87" height="20"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{fecha_entrada}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="87" y="5" width="83" height="20"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{fecha_salida}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="170" y="5" width="81" height="20"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{placas}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="253" y="5" width="56" height="20"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{marca}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="498" y="4" width="57" height="20"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.Float"><![CDATA[$F{monto}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="492" y="4" width="6" height="20"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<text><![CDATA[$]]></text>
			</staticText>
			<textField>
				<reportElement x="317" y="3" width="62" height="20"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.Float"><![CDATA[$F{costo_lavado}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="310" y="3" width="7" height="20"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<text><![CDATA[$]]></text>
			</staticText>
			<staticText>
				<reportElement x="380" y="4" width="11" height="20"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<text><![CDATA[$]]></text>
			</staticText>
			<textField>
				<reportElement x="386" y="4" width="49" height="20"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.Float"><![CDATA[$F{costo_pension}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="442" y="4" width="49" height="20"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.Float"><![CDATA[$F{total_estacionamiento}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="436" y="4" width="6" height="20"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<text><![CDATA[$]]></text>
			</staticText>
		</band>
	</detail>
	<columnFooter>
		<band height="7" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="31" splitType="Stretch">
			<textField>
				<reportElement x="510" y="6" width="37" height="20"/>
				<textElement/>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="206" y="6" width="230" height="20"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Sistema de parqueadero]]></text>
			</staticText>
		</band>
	</pageFooter>
	<summary>
		<band height="9" splitType="Stretch"/>
	</summary>
</jasperReport>
