<?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="maestro" language="groovy" pageWidth="792" pageHeight="612" orientation="Landscape" columnWidth="752" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="deb2e797-2985-4f19-93eb-0029f1e34a3e">
	<property name="ireport.zoom" value="1.4641000000000013"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="titulov3"/>
	<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["C:\\Users\\chelo\\Desktop\\ireport\\"]]></defaultValueExpression>
	</parameter>
	<parameter name="id_pdd" class="java.lang.Integer">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="foto" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["D:\\laragon\\laragon\\www\\titulov3\\files\\imagen_cliente\\"]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT
	derecho_socios.id_derecho_Propietario,
	derecho_socios.id_Socio,
	derecho_socios.nombre AS gestion,
	derecho_socios.foto_actual,
	derecho_socios.ci,
	derecho_socios.socio,
	derecho_socios.nro_Acciones,
	pago_dp.fecha_Pago,
	pago_dp.estado,
	gestion.nombre as gestion_pagada,
	pago_dp.utilidad_gestion,
	pago_dp.total_bs,
	aux.nombre as estado_pago



,
	pago_dp.id_Pago
FROM
	derecho_socios
	INNER JOIN pago_dp ON derecho_socios.id_derecho_Propietario = pago_dp.derecho_Propietario
	INNER JOIN gestion ON pago_dp.id_gestion = gestion.id_Gestion
	INNER JOIN aux ON pago_dp.estado = aux.id_aux

where  derecho_socios.id_Socio =$P{id_pdd}]]>
	</queryString>
	<field name="id_derecho_Propietario" class="java.lang.Integer">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="id_Socio" class="java.lang.Integer">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="gestion" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="foto_actual" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="ci" class="java.math.BigDecimal">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="socio" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="nro_Acciones" class="java.math.BigDecimal">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="fecha_Pago" class="java.sql.Timestamp">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="estado" class="java.lang.Integer">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="gestion_pagada" class="java.lang.String"/>
	<field name="utilidad_gestion" class="java.math.BigDecimal">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="total_bs" class="java.math.BigDecimal">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="estado_pago" class="java.lang.String"/>
	<field name="id_Pago" class="java.lang.Integer">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<variable name="sum" class="java.math.BigDecimal" resetType="Group" resetGroup="estado" calculation="Sum">
		<variableExpression><![CDATA[$F{total_bs}]]></variableExpression>
	</variable>
	<group name="estado">
		<groupExpression><![CDATA[$F{estado_pago}]]></groupExpression>
		<groupHeader>
			<band height="25">
				<textField>
					<reportElement x="9" y="2" width="279" height="20" forecolor="#FF0033" uuid="e4fdd26b-1356-49ec-9833-294367d705be"/>
					<textElement>
						<font size="12" isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{estado_pago}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="24">
				<textField pattern="#,##0.00">
					<reportElement x="539" y="1" width="100" height="20" uuid="87c5ba2a-3882-47cd-b5cf-dfd5e86eb3fd"/>
					<textElement>
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{sum}]]></textFieldExpression>
				</textField>
			</band>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="194" splitType="Stretch">
			<textField>
				<reportElement x="140" y="47" width="256" height="20" uuid="45c7b957-b276-4559-8716-6326522287f6"/>
				<textElement verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{id_derecho_Propietario}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="140" y="76" width="256" height="20" uuid="307c6a4b-fd99-48d0-97e8-b91478745bdc"/>
				<textElement verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{ci}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="140" y="102" width="256" height="20" uuid="4ae90e14-aace-4fec-8b98-6cf6dca0b8e3"/>
				<textElement verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{socio}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="140" y="130" width="256" height="20" uuid="f57a92e0-ca8c-4de7-b0e3-464d57147d5c"/>
				<textElement verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{nro_Acciones}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="140" y="156" width="256" height="20" uuid="efe9ab58-9cd9-43ba-9e13-0676be526e17"/>
				<textElement verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{gestion}]]></textFieldExpression>
			</textField>
			<image onErrorType="Blank">
				<reportElement x="431" y="47" width="157" height="129" uuid="d91eed3f-6f8f-4ba0-8f69-8729aa979ce5"/>
				<imageExpression><![CDATA[$P{foto}+$F{foto_actual}]]></imageExpression>
			</image>
			<staticText>
				<reportElement x="0" y="47" width="140" height="20" uuid="934a4fa9-4b0b-4b85-a959-7e4d8ffb78a6"/>
				<textElement verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[Derecho Propietario:]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="76" width="140" height="20" uuid="8c3401f0-e996-4080-b6bb-7644bdce5ba9"/>
				<textElement verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[Carnet Identidad:]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="102" width="140" height="20" uuid="59ce04c9-d92f-495d-9f49-cde48625418e"/>
				<textElement verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[Socio:]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="130" width="140" height="20" uuid="aed6ff04-69c4-4b54-93a8-62d14fc4b16e"/>
				<textElement verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[Numero de Acciones:]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="156" width="140" height="20" uuid="36bbb38d-e53a-4581-b4b3-2403278cb6d6"/>
				<textElement verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[Gestion de apertura:]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="0" width="752" height="47" uuid="ed9f1211-608f-4701-a30a-6ce8a1f75261"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="27" isBold="true"/>
				</textElement>
				<text><![CDATA[Kardex Derecho Propietario]]></text>
			</staticText>
			<line>
				<reportElement x="2" y="187" width="742" height="1" uuid="ce16bece-85f7-4dd4-8bd2-110c963fa07e"/>
			</line>
		</band>
	</title>
	<pageHeader>
		<band height="26">
			<staticText>
				<reportElement x="93" y="4" width="77" height="20" uuid="3540cd9e-e592-4192-b4a8-f65e78e0bb59"/>
				<textElement textAlignment="Center"/>
				<text><![CDATA[Fecha]]></text>
			</staticText>
			<staticText>
				<reportElement x="3" y="4" width="53" height="20" uuid="bd015937-cbfb-4b36-b432-7543e1fc7ebb"/>
				<text><![CDATA[id]]></text>
			</staticText>
			<staticText>
				<reportElement x="343" y="4" width="88" height="20" uuid="be8b8895-7362-4b20-964f-63882c712d8d"/>
				<textElement textAlignment="Center"/>
				<text><![CDATA[Utilidad de Gestion]]></text>
			</staticText>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="11">
			<staticText>
				<reportElement x="541" y="-22" width="100" height="20" uuid="222eebf4-edc4-431a-9c89-827c3536c196"/>
				<text><![CDATA[Total Bs.]]></text>
			</staticText>
			<staticText>
				<reportElement x="204" y="-23" width="72" height="20" uuid="c464f069-4d81-417c-8383-7b864497dd81"/>
				<textElement textAlignment="Center"/>
				<text><![CDATA[Gestion]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="23">
			<textField pattern="dd/MM/yyyy">
				<reportElement x="93" y="2" width="77" height="20" uuid="de1b0805-50dc-4fd6-bab8-0ac0772a9f30"/>
				<textElement textAlignment="Center"/>
				<textFieldExpression><![CDATA[$F{fecha_Pago}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00">
				<reportElement x="541" y="1" width="100" height="20" uuid="5c24bf1d-44c8-4efd-9f0d-56bfdf36e17f"/>
				<textFieldExpression><![CDATA[$F{total_bs}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="204" y="1" width="72" height="20" uuid="dce3f179-f43f-4ce5-ab2b-b18266b70cc4"/>
				<textElement textAlignment="Center"/>
				<textFieldExpression><![CDATA[$F{gestion_pagada}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="2" y="2" width="54" height="20" uuid="0cbd7be9-b437-4eab-989f-93acd6c8814e"/>
				<textFieldExpression><![CDATA[$F{id_Pago}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00">
				<reportElement x="343" y="1" width="88" height="20" uuid="a44850fe-c403-43fb-bb1e-4a7672158161"/>
				<textElement textAlignment="Center"/>
				<textFieldExpression><![CDATA[$F{utilidad_gestion}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="7"/>
	</columnFooter>
	<pageFooter>
		<band height="6"/>
	</pageFooter>
</jasperReport>
