<?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="cer_obj_igu" language="groovy" pageWidth="660" pageHeight="792" whenNoDataType="NoDataSection" columnWidth="560" leftMargin="50" rightMargin="50" topMargin="20" bottomMargin="20" isSummaryWithPageHeaderAndFooter="true">
	<property name="ireport.zoom" value="0.9090909090909117"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="18"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/contratacion/gen_cer_ins_per"/>
	<property name="ireport.jasperserver.url" value="http://localhost:18080/jasperserver/services/repository"/>
	<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["/home/dortega/Reportes Jasper/Reportes Jasper  Presupuesto/Resolucion Comisiones/"]]></defaultValueExpression>
	</parameter>
	<parameter name="id_estudios_previos" class="java.lang.String">
		<defaultValueExpression><![CDATA[181]]></defaultValueExpression>
	</parameter>
	<parameter name="id_co_ep" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="abogado" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="abogadodos" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="abogadotres" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="abogadocuatro" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="abogadocinco" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT
 to_char(sysdate,'yyyy') as anho,
to_char(sysdate,'mm') as mes,
to_char(sysdate,'dd') as dd,
to_char(sysdate,'dd " dias del mes de" month "de" yyyy','nls_date_language=spanish') as fecha_letras,
tab0.id_co_ep,
tab0.id_estudios_previos,
tab1.estado_general,
DBMS_LOB.substr(nvl(tab0.valor_texto,' '),4000) as valor_texto
FROM CO_EP_OBJETOS_IGUALES tab0
left join co_estudios_previos tab1 ON tab0.id_estudios_previos=tab1.id_estudios_previos
where 1=1 and tab0.id_estudios_previos=$P!{id_estudios_previos}
order by tab0.id_co_ep]]>
	</queryString>
	<field name="ANHO" class="java.lang.String"/>
	<field name="MES" class="java.lang.String"/>
	<field name="DD" class="java.lang.String"/>
	<field name="FECHA_LETRAS" class="java.lang.String"/>
	<field name="ID_CO_EP" class="java.math.BigDecimal"/>
	<field name="ID_ESTUDIOS_PREVIOS" class="java.math.BigDecimal"/>
	<field name="ESTADO_GENERAL" class="java.math.BigDecimal"/>
	<field name="VALOR_TEXTO" class="java.lang.String"/>
	<variable name="variable1" class="java.lang.String" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_TEXTO}]]></variableExpression>
		<initialValueExpression><![CDATA[""]]></initialValueExpression>
	</variable>
	<pageHeader>
		<band height="68" splitType="Stretch">
			<image hAlign="Center">
				<reportElement mode="Transparent" x="0" y="0" width="119" height="67"/>
				<box>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
			<textField>
				<reportElement mode="Transparent" x="204" y="14" width="356" height="32" forecolor="#000000"/>
				<box>
					<pen lineWidth="0.75" lineStyle="Solid"/>
					<topPen lineWidth="0.0" lineStyle="Solid"/>
					<leftPen lineWidth="0.0" lineStyle="Solid"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid"/>
					<rightPen lineWidth="0.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="Arial" size="12" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["CERTIFICACIÓN DE OBJETOS IGUALES"]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="40" splitType="Stretch">
			<textField>
				<reportElement mode="Transparent" x="119" y="0" width="331" height="32" forecolor="#000000"/>
				<box>
					<pen lineWidth="0.75" lineStyle="Solid"/>
					<topPen lineWidth="0.0" lineStyle="Solid"/>
					<leftPen lineWidth="0.0" lineStyle="Solid"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid"/>
					<rightPen lineWidth="0.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="Arial" size="12" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["LA VICEPRESIDENTE ADMINISTRATIVA Y FINANCIERA DE LA AGENCIA NACIONAL DE MINERÍA"]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<detail>
		<band height="50">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="0" y="0" width="560" height="50"/>
				<textElement textAlignment="Justified" markup="html">
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{VALOR_TEXTO}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<pageFooter>
		<band height="75">
			<image hAlign="Center">
				<reportElement mode="Transparent" x="0" y="0" width="224" height="68"/>
				<box>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<imageExpression class="java.lang.String"><![CDATA["repo:top1"]]></imageExpression>
			</image>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" mode="Transparent" x="357" y="0" width="203" height="68" forecolor="#000000"/>
				<box>
					<pen lineWidth="0.75" lineStyle="Dotted"/>
					<topPen lineWidth="0.0" lineStyle="Dotted"/>
					<leftPen lineWidth="0.0" lineStyle="Dotted"/>
					<bottomPen lineWidth="0.0" lineStyle="Dotted"/>
					<rightPen lineWidth="0.0" lineStyle="Dotted"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle" markup="none">
					<font fontName="Arial" size="10" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Avenida Calle 26 No. 59-51. Pisos 8, 9 y 10.\n"   +"PBX:(571) 2201999.\n"+"Bogotá D.C. www.anm.gov.co"]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band height="308" splitType="Stretch">
			<textField isStretchWithOverflow="true">
				<reportElement positionType="FixRelativeToBottom" mode="Transparent" x="0" y="231" width="560" height="15" forecolor="#000000"/>
				<box>
					<pen lineWidth="0.75" lineStyle="Dotted"/>
					<topPen lineWidth="0.0" lineStyle="Dotted"/>
					<leftPen lineWidth="0.0" lineStyle="Dotted"/>
					<bottomPen lineWidth="0.0" lineStyle="Dotted"/>
					<rightPen lineWidth="0.0" lineStyle="Dotted"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="html">
					<font fontName="Arial" size="10" isBold="false" isItalic="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["FIRMA DE QUIEN SUSCRIBE LA CERTIFICACIÓN"]]></textFieldExpression>
			</textField>
			<image hAlign="Center">
				<reportElement positionType="FixRelativeToBottom" mode="Transparent" x="224" y="182" width="92" height="49">
					<printWhenExpression><![CDATA[( $F{ESTADO_GENERAL} == 2
    ? true
    : false
)]]></printWhenExpression>
				</reportElement>
				<box>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<imageExpression class="java.lang.String"><![CDATA["repo:aut"]]></imageExpression>
			</image>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="FixRelativeToBottom" mode="Transparent" x="0" y="246" width="560" height="30" forecolor="#000000"/>
				<box>
					<pen lineWidth="0.75" lineStyle="Dotted"/>
					<topPen lineWidth="0.0" lineStyle="Dotted"/>
					<leftPen lineWidth="0.0" lineStyle="Dotted"/>
					<bottomPen lineWidth="0.0" lineStyle="Dotted"/>
					<rightPen lineWidth="0.0" lineStyle="Dotted"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="html">
					<font fontName="DejaVu Sans" size="10" isBold="true" isItalic="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["AURA ISABEL GONZÁLEZ TIGA"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="FixRelativeToBottom" mode="Transparent" x="0" y="291" width="560" height="15" forecolor="#000000"/>
				<box>
					<pen lineWidth="0.75" lineStyle="Dotted"/>
					<topPen lineWidth="0.0" lineStyle="Dotted"/>
					<leftPen lineWidth="0.0" lineStyle="Dotted"/>
					<bottomPen lineWidth="0.0" lineStyle="Dotted"/>
					<rightPen lineWidth="0.0" lineStyle="Dotted"/>
				</box>
				<textElement verticalAlignment="Middle" markup="html">
					<font fontName="DejaVu Sans" size="10" isBold="false" isItalic="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Revisó: Vanessa Pacheco Gómez-Abogada VAF"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="FixRelativeToBottom" mode="Transparent" x="0" y="276" width="560" height="15" forecolor="#000000"/>
				<box>
					<pen lineWidth="0.75" lineStyle="Dotted"/>
					<topPen lineWidth="0.0" lineStyle="Dotted"/>
					<leftPen lineWidth="0.0" lineStyle="Dotted"/>
					<bottomPen lineWidth="0.0" lineStyle="Dotted"/>
					<rightPen lineWidth="0.0" lineStyle="Dotted"/>
				</box>
				<textElement verticalAlignment="Middle" markup="html">
					<font fontName="DejaVu Sans" size="10" isBold="false" isItalic="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Elaboró: Bibiana Gutiérrez- Coordinadora Grupo de Contratación"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement positionType="FixRelativeToBottom" x="0" y="132" width="560" height="20"/>
				<textElement textAlignment="Justified" markup="html"/>
				<textFieldExpression class="java.lang.String"><![CDATA["Lo anterior en cumplimiento de lo establecido en el inciso 3 del articulo 1° del Decreto 2209 de 1998."]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement positionType="FixRelativeToBottom" x="0" y="152" width="560" height="30"/>
				<textElement textAlignment="Justified" markup="html"/>
				<textFieldExpression class="java.lang.String"><![CDATA["La presente se expide en Bogota a los "+$F{FECHA_LETRAS}]]></textFieldExpression>
			</textField>
			<subreport>
				<reportElement x="0" y="0" width="560" height="100"/>
				<subreportParameter name="SUBREPORT_DIR">
					<subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="id_co_ep">
					<subreportParameterExpression><![CDATA[$P{id_co_ep}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="abogadodos"/>
				<subreportParameter name="abogadocinco"/>
				<subreportParameter name="abogadocuatro"/>
				<subreportParameter name="id_estudios_previos">
					<subreportParameterExpression><![CDATA[$P{id_estudios_previos}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="abogadotres"/>
				<subreportParameter name="abogado"/>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression class="java.lang.String"><![CDATA["repo:subreport.jrxml"]]></subreportExpression>
			</subreport>
		</band>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="560" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
