<?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="Venta" pageWidth="792" pageHeight="612" orientation="Landscape" whenNoDataType="BlankPage" columnWidth="752" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isFloatColumnFooter="true" uuid="75b63c28-3726-4e1d-894d-7c17cf086cff">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="26"/>
	<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" isForPrompting="false"/>
	<parameter name="USUARIO" class="java.lang.String" isForPrompting="false"/>
	<parameter name="FECHA_INI" class="java.util.Date" isForPrompting="false"/>
	<parameter name="FECHA_FIN" class="java.util.Date" isForPrompting="false"/>
	<queryString>
		<![CDATA[SELECT o.fecha, o.fechac, doc.descripcion documento, o.numero, o.autorizacion, p.codigo, p.descripcion producto, d.salida cantidad, (d.precio*d.salida) monto, i.nombre impuesto, i.valor, pr.valor iva FROM propiedades pr, operacionesalmacen o INNER JOIN detalleoperacion d on o.idoperacion = d.idoperacion INNER JOIN productos p on d.idproducto = p.idproducto LEFT JOIN impuestos i ON p.idimpuesto = i.idimpuesto INNER JOIN documentos doc on o.iddocumento = doc.iddocumento WHERE pr.descripcion = 'iva' AND o.DTYPE = 'Ventas' AND o.estado = 1 AND o.fecha BETWEEN $P{FECHA_INI} AND $P{FECHA_FIN} ORDER BY o.fecha, o.numero, p.descripcion]]>
	</queryString>
	<field name="fecha" class="java.util.Date"/>
	<field name="fechac" class="java.util.Date"/>
	<field name="documento" class="java.lang.String"/>
	<field name="numero" class="java.lang.String"/>
	<field name="autorizacion" class="java.lang.String"/>
	<field name="codigo" class="java.lang.String"/>
	<field name="producto" class="java.lang.String"/>
	<field name="cantidad" class="java.lang.Double"/>
	<field name="monto" class="java.lang.Double"/>
	<field name="impuesto" class="java.lang.String"/>
	<field name="valor" class="java.lang.Double"/>
	<field name="iva" class="java.lang.Double"/>
	<variable name="valor" class="java.lang.Double">
		<variableExpression><![CDATA[($F{impuesto}== null?$F{iva}:$F{valor})/100]]></variableExpression>
	</variable>
	<variable name="v_impuesto" class="java.lang.Double">
		<variableExpression><![CDATA[($F{monto}/(1+$V{valor}))*$V{valor}]]></variableExpression>
	</variable>
	<variable name="monto_1" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[$F{monto}]]></variableExpression>
	</variable>
	<variable name="v_impuesto_1" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[$V{v_impuesto}]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band splitType="Stretch"/>
	</title>
	<pageHeader>
		<band height="90" splitType="Stretch">
			<textField pattern="">
				<reportElement x="0" y="41" width="752" height="18" uuid="63d66c12-8cff-4839-8635-0de732c835ea"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA["Del " + new SimpleDateFormat("dd-MMM-yyyy").format($P{FECHA_INI}) + "  Al  " + new SimpleDateFormat("dd-MMM-yyyy").format($P{FECHA_FIN})]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="0" width="752" height="21" uuid="cc27c705-0491-4516-bdac-6a69b0799ade"/>
				<box>
					<bottomPen lineWidth="0.5" lineStyle="Double"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="14" isBold="true"/>
				</textElement>
				<text><![CDATA[DETALLE DE VENTAS CON IMPUESTOS]]></text>
			</staticText>
			<textField>
				<reportElement x="0" y="21" width="752" height="20" uuid="cf020205-ab20-4d39-bf80-32a8ca051aec"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{EMPRESA}]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="25">
			<staticText>
				<reportElement x="0" y="0" width="50" height="25" uuid="4199cbe5-8668-4dae-9d22-55d8fff76091"/>
				<box leftPadding="2" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[FECHA DE EMISION]]></text>
			</staticText>
			<staticText>
				<reportElement x="602" y="0" width="50" height="25" uuid="e86c65d5-1dba-4718-9163-961e959106b9"/>
				<box leftPadding="2" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[MONTO]]></text>
			</staticText>
			<staticText>
				<reportElement x="375" y="0" width="177" height="25" uuid="5d57d270-03e5-49e2-8bd1-a7cd700dfa9e"/>
				<box leftPadding="2" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[PRODUCTO]]></text>
			</staticText>
			<staticText>
				<reportElement x="652" y="0" width="50" height="25" uuid="01a7fa57-1bc4-49e1-a74e-39ab0eb304f2"/>
				<box leftPadding="2" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[IMPUESTO]]></text>
			</staticText>
			<staticText>
				<reportElement x="702" y="0" width="50" height="25" uuid="2b9030a2-14ba-4ebd-aac3-3097cf58f7cd"/>
				<box leftPadding="2" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[VALOR IMPUESTO]]></text>
			</staticText>
			<staticText>
				<reportElement x="50" y="0" width="50" height="25" uuid="d049f815-c205-4b15-bf2e-5eb52ead8a98"/>
				<box leftPadding="2" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[FECHA DE CERTIFICACION]]></text>
			</staticText>
			<staticText>
				<reportElement x="100" y="0" width="90" height="25" uuid="b50811ae-317f-425f-9f6b-b5ab0f1f7eec"/>
				<box leftPadding="2" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[DOCUMENTO]]></text>
			</staticText>
			<staticText>
				<reportElement x="552" y="0" width="50" height="25" uuid="b68a03ab-16a8-44b3-845a-83545dc05577"/>
				<box leftPadding="2" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[CANTIDAD]]></text>
			</staticText>
			<staticText>
				<reportElement x="300" y="0" width="75" height="25" uuid="6a8a74bf-5997-49ef-825d-e8dc1a1de62c"/>
				<box leftPadding="2" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[CODIGO]]></text>
			</staticText>
			<staticText>
				<reportElement x="190" y="0" width="110" height="25" uuid="4ae29169-9ce0-4028-8819-c7a1d1a048f8"/>
				<box leftPadding="2" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[FEL]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="12">
			<textField pattern="dd/MM/yyyy">
				<reportElement x="0" y="0" width="50" height="12" uuid="fe0db26a-5b6b-499c-83c3-7e0bb3abbb1e"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{fecha}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="375" y="0" width="177" height="12" uuid="c37c0255-c069-4319-b312-6a1df660fc14"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{producto}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0">
				<reportElement x="552" y="0" width="50" height="12" uuid="ce8af7a7-c9ac-491c-b057-3ebf87d67582"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{cantidad}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="652" y="0" width="50" height="12" uuid="db986958-a26a-4b67-b6c6-de7f23609db6"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{impuesto}== null? "IVA":$F{impuesto})]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;-#,##0.00">
				<reportElement x="602" y="0" width="50" height="12" uuid="7d4e8079-ea00-4bf7-89b2-afd19c2fd137"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{monto}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.0000;-#,##0.0000" isBlankWhenNull="true">
				<reportElement x="702" y="0" width="50" height="12" uuid="bc794e53-8248-42d5-9316-8bbf388ed662"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{v_impuesto}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="50" y="0" width="50" height="12" uuid="69588b88-d190-4b1e-846b-c2e3998a6201"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{fechac}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00">
				<reportElement x="100" y="0" width="90" height="12" uuid="35c10a58-b386-4cc9-99fb-f7e2eb1c3628"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{documento} +" "+ $F{numero}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="300" y="0" width="75" height="12" uuid="36514162-50a8-49bb-8c7f-d1f42d31b0f7"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{codigo}]]></textFieldExpression>
			</textField>
			<textField pattern="###0.00">
				<reportElement x="190" y="0" width="110" height="12" uuid="56137ada-918d-4532-b609-89c9a821ad6e"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{autorizacion}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<summary>
		<band height="20">
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement x="552" y="0" width="100" height="20" uuid="ba947f47-7f35-49b3-8852-849758700fae"/>
				<box leftPadding="2" rightPadding="2">
					<topPen lineWidth="0.5"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{monto_1}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement x="652" y="0" width="100" height="20" uuid="22275416-2471-4bbd-98a4-52c7821c0e0b"/>
				<box leftPadding="2" rightPadding="2">
					<topPen lineWidth="0.5"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{v_impuesto_1}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="375" y="0" width="177" height="20" uuid="d74c23d9-02e1-4b64-9d72-9021b2fe2750"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[TOTAL]]></text>
			</staticText>
		</band>
	</summary>
</jasperReport>
