<?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="DetalleIngresos" pageWidth="792" pageHeight="612" orientation="Landscape" whenNoDataType="BlankPage" columnWidth="732" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" isFloatColumnFooter="true" uuid="75b63c28-3726-4e1d-894d-7c17cf086cff">
	<property name="ireport.zoom" value="2.0"/>
	<property name="ireport.x" value="46"/>
	<property name="ireport.y" value="0"/>
	<style name="Title" forecolor="#FFFFFF" fontName="Arial" fontSize="26" isBold="true" pdfFontName="Helvetica-Bold"/>
	<style name="SubTitle" forecolor="#666666" fontName="Arial" fontSize="18"/>
	<style name="Column header" forecolor="#666666" fontName="Arial" fontSize="12" isBold="true"/>
	<style name="Detail" fontName="Arial" fontSize="12"/>
	<parameter name="EMPRESA" class="java.lang.String"/>
	<parameter name="FECHA_INI" class="java.util.Date">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="FECHA_FIN" class="java.util.Date"/>
	<parameter name="USUARIO" class="java.lang.String"/>
	<parameter name="ASESOR" class="java.lang.String">
		<parameterDescription><![CDATA[Asesor]]></parameterDescription>
	</parameter>
	<parameter name="OPERACION" class="java.lang.String">
		<parameterDescription><![CDATA[Operación]]></parameterDescription>
	</parameter>
	<queryString>
		<![CDATA[SELECT m.fecha, c.descripcion caja, d.descripcion documento, o.numero numdoc, m.ingreso monto, m.descripcion operacion, a.nombre asesor FROM movcaja m INNER JOIN movcuenta mc ON m.idoperacion = mc.idoperacion INNER JOIN operacionescaja o ON m.idoperacion = o.idoperacion INNER JOIN cajas c ON o.idcaja = c.idcaja INNER JOIN documentos d ON o.iddocumento = d.iddocumento INNER JOIN cuentas cn ON mc.idcuenta = cn.idcuenta INNER JOIN solicitudes s ON cn.idsolicitud = s.idsolicitud INNER JOIN definicioncuenta dc ON s.iddefinicion = dc.iddefinicion INNER JOIN asesores a ON dc.idasesor = a.idasesor WHERE ingreso > 0 AND m.fecha BETWEEN $P{FECHA_INI} AND $P{FECHA_FIN} ORDER BY m.fecha;]]>
	</queryString>
	<field name="fecha" class="java.util.Date"/>
	<field name="caja" class="java.lang.String"/>
	<field name="operacion" class="java.lang.String"/>
	<field name="asesor" class="java.lang.String"/>
	<field name="documento" class="java.lang.String"/>
	<field name="numdoc" class="java.lang.Long"/>
	<field name="monto" class="java.lang.Double"/>
	<variable name="monto_1" class="java.lang.Double" resetType="Column" calculation="Sum">
		<variableExpression><![CDATA[$F{monto}]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="66" splitType="Stretch">
			<staticText>
				<reportElement x="0" y="0" width="732" height="20" uuid="b372ab84-d8dc-4c70-8059-757f1a11f494"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Tahoma" size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[NOMBRE COOPERATIVA]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="20" width="732" height="15" uuid="c0ab624d-17d4-44e8-b9d2-af70384bc42d"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Tahoma"/>
				</textElement>
				<text><![CDATA[DETALLE DE INGRESOS]]></text>
			</staticText>
			<textField>
				<reportElement x="0" y="35" width="732" height="15" uuid="13bdd30d-a8cb-4681-8e78-a60c225a4d61"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA["DEL " + new SimpleDateFormat("dd-MMM-yyyy").format($P{FECHA_INI}) + " AL " + new SimpleDateFormat("dd-MMM-yyyy").format($P{FECHA_FIN})]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<columnHeader>
		<band height="14" splitType="Prevent">
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" x="0" y="1" width="65" height="12" uuid="5d511dfa-24bd-4bca-b17c-f39202d7e833"/>
				<box>
					<topPen lineWidth="0.5"/>
					<leftPen lineWidth="0.5"/>
					<bottomPen lineWidth="0.5"/>
					<rightPen lineWidth="0.5"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true" isStrikeThrough="false"/>
				</textElement>
				<text><![CDATA[FECHA]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" x="132" y="1" width="86" height="12" uuid="9d5aad88-4a50-420f-8ce0-52865d473faa"/>
				<box>
					<topPen lineWidth="0.5"/>
					<bottomPen lineWidth="0.5"/>
					<rightPen lineWidth="0.5"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true" isStrikeThrough="false"/>
				</textElement>
				<text><![CDATA[DOCUMENTO]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" x="218" y="1" width="55" height="12" uuid="51cf758e-2cd3-454e-8f5b-8f447860b43d"/>
				<box>
					<topPen lineWidth="0.5"/>
					<bottomPen lineWidth="0.5"/>
					<rightPen lineWidth="0.5"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true" isStrikeThrough="false"/>
				</textElement>
				<text><![CDATA[No. DOC]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" x="548" y="1" width="98" height="12" uuid="53d0a56c-faed-4fda-bb15-ea772927f6c8"/>
				<box>
					<topPen lineWidth="0.5"/>
					<bottomPen lineWidth="0.5"/>
					<rightPen lineWidth="0.5"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true" isStrikeThrough="false"/>
				</textElement>
				<text><![CDATA[ASESOR]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" x="646" y="1" width="86" height="12" uuid="1a4b7765-ec9a-4d59-a327-bfb34b7d00e1"/>
				<box>
					<topPen lineWidth="0.5"/>
					<bottomPen lineWidth="0.5"/>
					<rightPen lineWidth="0.5"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true" isStrikeThrough="false"/>
				</textElement>
				<text><![CDATA[MONTO]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" x="65" y="1" width="67" height="12" uuid="4a001b7f-2483-4755-9bef-c37225addfe3"/>
				<box>
					<topPen lineWidth="0.5"/>
					<bottomPen lineWidth="0.5"/>
					<rightPen lineWidth="0.5"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true" isStrikeThrough="false"/>
				</textElement>
				<text><![CDATA[CAJA]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" x="273" y="1" width="275" height="12" uuid="7a92db13-28ff-4119-b95a-eacb4f65b312"/>
				<box>
					<topPen lineWidth="0.5"/>
					<bottomPen lineWidth="0.5"/>
					<rightPen lineWidth="0.5"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true" isStrikeThrough="false"/>
				</textElement>
				<text><![CDATA[DESCRIPCION]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="12" splitType="Stretch">
			<textField pattern="dd/MM/yyyy">
				<reportElement x="0" y="0" width="65" height="12" uuid="af41dd14-7dfc-46f9-adb3-efaf0477d1c9"/>
				<box>
					<leftPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{fecha}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;-#,##0.00">
				<reportElement x="646" y="0" width="86" height="12" uuid="e54f0c27-80c8-4807-907b-53fb2e4d1d7a"/>
				<box leftPadding="2" rightPadding="3"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{monto}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="65" y="0" width="67" height="12" uuid="359bd18d-f486-4c8d-8603-ba3e0c23d1ae"/>
				<textElement textAlignment="Center">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{caja}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="218" y="0" width="55" height="12" uuid="11ce861d-79ab-4824-b6dd-9296306ecf99"/>
				<textElement textAlignment="Center">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{numdoc}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="273" y="0" width="275" height="12" uuid="d2afdd25-738d-4e0f-a275-a6f981770ce3"/>
				<box leftPadding="3"/>
				<textElement textAlignment="Left">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{operacion}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="132" y="0" width="86" height="12" uuid="c4b924b6-9b17-42be-9ad1-d8061ea6705e"/>
				<box leftPadding="3"/>
				<textElement textAlignment="Left">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{documento}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="548" y="0" width="98" height="12" uuid="2b32e005-7b0b-49ce-95e2-ae7dae5c7009"/>
				<box leftPadding="3"/>
				<textElement textAlignment="Left">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{asesor}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="13" splitType="Stretch"/>
	</columnFooter>
	<lastPageFooter>
		<band height="17">
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" x="557" y="1" width="89" height="15" uuid="819dd31c-1523-4f81-8aaf-523f956b994b"/>
				<box>
					<topPen lineWidth="0.5"/>
					<leftPen lineWidth="0.5"/>
					<bottomPen lineWidth="0.5"/>
					<rightPen lineWidth="0.5"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true" isStrikeThrough="false"/>
				</textElement>
				<text><![CDATA[TOTAL]]></text>
			</staticText>
			<textField pattern="#,##0.00;#,##0.00-">
				<reportElement x="646" y="1" width="86" height="15" uuid="42ad8fc0-f9fc-4329-951a-0a667767be7e"/>
				<box rightPadding="3">
					<topPen lineWidth="0.5"/>
					<leftPen lineWidth="0.5"/>
					<bottomPen lineWidth="0.5"/>
					<rightPen lineWidth="0.5"/>
				</box>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{monto_1}]]></textFieldExpression>
			</textField>
		</band>
	</lastPageFooter>
</jasperReport>
