<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.20.6.final using JasperReports Library version 6.20.6-5c96b6aa8a39ac1dc6b6bea4b81168e16dd39231  -->
<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="notaPago" pageWidth="612" pageHeight="792" columnWidth="567" leftMargin="10" rightMargin="35" topMargin="20" bottomMargin="10" uuid="6eb66b6b-9a20-4723-a05c-9f52ec31a413">
	<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="mysql5"/>
	<property name="com.jaspersoft.studio.property.dataset.dialog.DatasetDialog.sash.w1" value="656"/>
	<property name="com.jaspersoft.studio.property.dataset.dialog.DatasetDialog.sash.w2" value="330"/>
	<parameter name="P1" class="java.lang.Integer">
		<parameterDescription><![CDATA[Id de titulo]]></parameterDescription>
	</parameter>
	<queryString language="SQL">
		<![CDATA[SELECT
	p_dp.id_Pago,
	p_dp.fecha_pago,
	g.nombre AS gest,
	p_dp.id_constitucion,
	p_dp.gestion,
	p_dp.correlativo,
	p_dp.derecho_Propietario,
	CONCAT(
		s.apellido_Paterno,
		' ',
		s.apellido_Materno,
		' ',
		s.nombres,
		' con C.I. :',
		s.ci,
		' ',
		a.alias 
	) AS Pagado,
	es.nombre AS estado_Pago,
	dp.total_bs,
	CONCAT(
		UCASE(
		LEFT ( lower ( dp.total_bs_literal ), 1 )),
	SUBSTRING( lower ( dp.total_bs_literal ), 2 )) AS total_bs_literal,
	dp.nro_Acciones,
	a.alias,
	ta.nombre AS tipo_socio,
	CONCAT(
		UCASE(
		LEFT ( lower ( aux.nombre ), 1 )),
	SUBSTRING( lower ( aux.nombre ), 2 )) AS tipo_pago,
	CONCAT(
		'Sacaba ',
		DAY ( p_dp.fecha_pago ),
		' de ',
	CASE
			MONTH ( p_dp.fecha_pago ) 
			WHEN 1 THEN
			'Enero' 
			WHEN 2 THEN
			'Febrero' 
			WHEN 3 THEN
			'Marzo' 
			WHEN 4 THEN
			'Abril' 
			WHEN 5 THEN
			'Mayo' 
			WHEN 6 THEN
			'Junio' 
			WHEN 7 THEN
			'Julio' 
			WHEN 8 THEN
			'Agosto' 
			WHEN 9 THEN
			'Septiembre' 
			WHEN 10 THEN
			'Octubre' 
			WHEN 11 THEN
			'Noviembre' 
			WHEN 12 THEN
			'Diciembre' 
		END,
		' del ',
		YEAR ( p_dp.fecha_pago ) 
	) AS fecha_pago_literal 
FROM
	pago_dp AS p_dp
	INNER JOIN derecho_propietario AS dp ON p_dp.derecho_Propietario = dp.id_derecho_Propietario
	INNER JOIN socio AS s ON p_dp.accionista = s.id_Socio
	INNER JOIN aux AS es ON p_dp.estado = es.id_aux
	INNER JOIN aux AS a ON s.ci_procedencia = a.id_aux
	INNER JOIN aux AS ta ON s.tipo_accionista = ta.id_aux
	INNER JOIN gestion AS g ON p_dp.gestion = g.id_Gestion
	INNER JOIN aux ON p_dp.tipo_pago = aux.id_aux 
	
	
	where 	p_dp.id_Pago = $P{P1}  and  	es.nombre LIKE 'PAGADO']]>
	</queryString>
	<field name="id_Pago" class="java.lang.Integer">
		<property name="com.jaspersoft.studio.field.name" value="id_Pago"/>
		<property name="com.jaspersoft.studio.field.label" value="id_Pago"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="pago_dp"/>
	</field>
	<field name="fecha_pago" class="java.sql.Timestamp">
		<property name="com.jaspersoft.studio.field.name" value="fecha_Pago"/>
		<property name="com.jaspersoft.studio.field.label" value="fecha_pago"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="pago_dp"/>
	</field>
	<field name="gest" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="nombre"/>
		<property name="com.jaspersoft.studio.field.label" value="gest"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="gestion"/>
	</field>
	<field name="id_constitucion" class="java.lang.Integer">
		<property name="com.jaspersoft.studio.field.name" value="id_constitucion"/>
		<property name="com.jaspersoft.studio.field.label" value="id_constitucion"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="pago_dp"/>
	</field>
	<field name="gestion" class="java.lang.Integer">
		<property name="com.jaspersoft.studio.field.name" value="gestion"/>
		<property name="com.jaspersoft.studio.field.label" value="gestion"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="pago_dp"/>
	</field>
	<field name="correlativo" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="correlativo"/>
		<property name="com.jaspersoft.studio.field.label" value="correlativo"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="pago_dp"/>
	</field>
	<field name="derecho_Propietario" class="java.lang.Integer">
		<property name="com.jaspersoft.studio.field.name" value="derecho_Propietario"/>
		<property name="com.jaspersoft.studio.field.label" value="derecho_Propietario"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="pago_dp"/>
	</field>
	<field name="Pagado" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="Pagado"/>
		<property name="com.jaspersoft.studio.field.label" value="Pagado"/>
	</field>
	<field name="estado_Pago" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="nombre"/>
		<property name="com.jaspersoft.studio.field.label" value="estado_Pago"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="aux"/>
	</field>
	<field name="total_bs" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="total_bs"/>
		<property name="com.jaspersoft.studio.field.label" value="total_bs"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="derecho_propietario"/>
	</field>
	<field name="total_bs_literal" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="total_bs_literal"/>
		<property name="com.jaspersoft.studio.field.label" value="total_bs_literal"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="derecho_propietario"/>
	</field>
	<field name="nro_Acciones" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="nro_Acciones"/>
		<property name="com.jaspersoft.studio.field.label" value="nro_Acciones"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="derecho_propietario"/>
	</field>
	<field name="alias" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="alias"/>
		<property name="com.jaspersoft.studio.field.label" value="alias"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="aux"/>
	</field>
	<field name="tipo_socio" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="nombre"/>
		<property name="com.jaspersoft.studio.field.label" value="tipo_socio"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="aux"/>
	</field>
	<field name="tipo_pago" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="tipo_pago"/>
		<property name="com.jaspersoft.studio.field.label" value="tipo_pago"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="aux"/>
	</field>
	<field name="fecha_pago_literal" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="fecha_pago_literal"/>
		<property name="com.jaspersoft.studio.field.label" value="fecha_pago_literal"/>
	</field>
	<background>
		<band height="180">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<image hAlign="Center" vAlign="Middle" evaluationTime="Report">
				<reportElement x="198" y="28" width="245" height="87" uuid="e4263595-7086-41c4-9aac-2720de73e077"/>
				<imageExpression><![CDATA["D:/laragon/www/acciones/app/report/d_p/images/pagado.png"]]></imageExpression>
			</image>
		</band>
	</background>
	<pageHeader>
		<band height="350" splitType="Stretch">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<image>
				<reportElement x="134" y="115" width="441" height="234" uuid="f3f1ff42-feae-456c-baf1-264d4df2cbbd"/>
				<imageExpression><![CDATA["D:/laragon/www/acciones/app/report/d_p/images/recibo.jpg"]]></imageExpression>
			</image>
			<textField pattern="#,000.###;(#,000.###-)">
				<reportElement x="191" y="0" width="259" height="70" forecolor="#F52C16" uuid="c9ea00d2-927f-413d-9ae6-aea85d4d4839">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Top">
					<font fontName="Tahoma" size="22"/>
				</textElement>
				<textFieldExpression><![CDATA["RECIBO N° " +$F{correlativo}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="190" y="247" width="200" height="15" uuid="7c9271f1-13aa-485d-9e2b-cace0185bdb6">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Center">
					<font fontName="Tahoma" size="11"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{fecha_pago_literal}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="282" width="200" height="15" uuid="112af00c-9c15-4a91-8dd7-1121ecf729c8">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Center">
					<font fontName="Tahoma" size="11"/>
				</textElement>
				<text><![CDATA[ENTREGUE CONFORME]]></text>
			</staticText>
			<line>
				<reportElement x="24" y="281" width="151" height="1" uuid="9efb0aab-864e-4204-beb2-72ed302dd27f">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<graphicElement>
					<pen lineStyle="Dotted"/>
				</graphicElement>
			</line>
			<staticText>
				<reportElement x="375" y="283" width="200" height="15" uuid="ebecc0d4-2254-4d96-a125-34940c310d3c">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Center">
					<font fontName="Tahoma" size="11"/>
				</textElement>
				<text><![CDATA[RECIBI CONFORME]]></text>
			</staticText>
			<line>
				<reportElement x="399" y="282" width="151" height="1" uuid="554e796c-f981-4fdc-ab8c-89cadd5a454a">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<graphicElement>
					<pen lineStyle="Dotted"/>
				</graphicElement>
			</line>
			<textField textAdjust="StretchHeight">
				<reportElement x="149" y="115" width="410" height="25" uuid="4d9e2347-4362-435e-ba2f-8758ca3dd39d">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Tahoma" size="11"/>
					<paragraph lineSpacing="Single" lineSpacingSize="0.0"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Pagado}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="10" y="30" width="180" height="10" uuid="50b676c1-377d-43b8-8884-6e0584ac6e90">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<text><![CDATA[TELF. 4703288-4703398]]></text>
			</staticText>
			<staticText>
				<reportElement x="10" y="40" width="180" height="10" uuid="d22aeb0c-ec4e-437f-8082-1602635423ef">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<text><![CDATA[SACABA - COCHABAMBA - BOLIVIA]]></text>
			</staticText>
			<textField pattern="d/M/yyyy  h:mm a">
				<reportElement x="440" y="335" width="111" height="15" uuid="8074e08b-1147-45b3-a683-36d10ffe2098">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Tahoma" size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="351" y="335" width="89" height="15" uuid="f20cf21f-11c2-4843-ba17-a3b8669bf8c2">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font fontName="Tahoma" size="9"/>
				</textElement>
				<text><![CDATA[Impreso el: ]]></text>
			</staticText>
			<staticText>
				<reportElement x="10" y="0" width="180" height="10" uuid="8c7850e1-e71e-4d50-b90e-93d190e605b8">
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<text><![CDATA[E°S°  TRANS ROSA DE LIMA S.A.]]></text>
			</staticText>
			<staticText>
				<reportElement x="10" y="10" width="180" height="20" uuid="5619d2e6-6b47-4b3c-ae6d-378c9415d1cb">
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<text><![CDATA[AV. BARRIENTOS S/N  KM 16 ZONA VILLA OBRA OBRAJES]]></text>
			</staticText>
			<textField pattern="#,##0.00#;(#,##0.00#-)">
				<reportElement x="494" y="80" width="74" height="23" uuid="e48e8c35-daf8-4f5e-8085-97fb7d56499e">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Tahoma" size="13" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{total_bs}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="149" y="143" width="410" height="25" uuid="98cf166c-3437-44c8-af56-2f5b5b90eff8">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement>
					<font fontName="Tahoma" size="11"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{total_bs_literal}+" 00/100 Bolivianos"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="149" y="172" width="370" height="25" uuid="8dacd67a-9e02-41f4-8e05-090dbdea5dcb">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement>
					<font fontName="Tahoma" size="11"/>
				</textElement>
				<textFieldExpression><![CDATA["Pago de dividendos gestion "  +$F{gest}+" de "+$F{nro_Acciones} +" acciones"]]></textFieldExpression>
			</textField>
			<textField textAdjust="StretchHeight">
				<reportElement x="149" y="202" width="370" height="20" uuid="a7a9b13d-92ce-480a-ae5f-f14f1a802198">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement>
					<font fontName="Tahoma" size="11"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{tipo_pago}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="64" y="115" width="70" height="24" uuid="ed034f58-3a98-4dd1-9157-69a2b8cd832b">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.x" value="px"/>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Tahoma" size="11"/>
				</textElement>
				<text><![CDATA[Pagado a:]]></text>
			</staticText>
			<staticText>
				<reportElement x="64" y="143" width="70" height="24" uuid="b8644e74-acf1-4a61-a7a0-77f04e1acffe">
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.x" value="px"/>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Tahoma" size="11"/>
				</textElement>
				<text><![CDATA[La suma de:]]></text>
			</staticText>
			<staticText>
				<reportElement x="64" y="172" width="70" height="24" uuid="3d70d7d0-931b-4d45-85bf-318251ad3f62">
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.x" value="px"/>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Tahoma" size="11"/>
				</textElement>
				<text><![CDATA[Concepto:]]></text>
			</staticText>
			<staticText>
				<reportElement x="64" y="202" width="70" height="20" uuid="4af42dbc-9626-4c5c-808a-8d8db9caad96">
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.x" value="px"/>
				</reportElement>
				<textElement textAlignment="Left">
					<font fontName="Tahoma" size="11"/>
				</textElement>
				<text><![CDATA[Pago en:]]></text>
			</staticText>
			<staticText>
				<reportElement x="436" y="80" width="58" height="23" uuid="67ae690d-275c-470c-baed-9d2c7b939986">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font fontName="Tahoma" size="13" isBold="true"/>
				</textElement>
				<text><![CDATA[Bs.-  ]]></text>
			</staticText>
		</band>
	</pageHeader>
</jasperReport>
