<?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="certif_contrato" language="groovy" pageWidth="660" pageHeight="792" whenNoDataType="NoDataSection" columnWidth="572" leftMargin="68" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.3310000000000035"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/contratacion/formato_desig_super"/>
	<property name="ireport.jasperserver.url" value="http://localhost:18091/jasperserver/services/repository"/>
	<parameter name="id_contrato" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["/home/dortega/Reportes Jasper/Reportes Jasper  Presupuesto/Resolucion Comisiones/"]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select tab0.*,
'<p align="justify">Que de conformidad con la documentación obrante dentro del expediente que reposa en el archivo de la entidad, <strong>'||tab0.nom_contra||'</strong>,
identificado (a) con la cédula de ciudadanía <strong>'||tab0.doc_contra||'</strong>,ha suscrito contrato (s) con el <strong>'||tab1.raz_soc||'</strong>, así</p>' as parrafo_1,
'<p align="justify">La presente certificación se expide en la ciudad de Bogotá D.C. a los ' || INITCAP(NUMERO_A_TEXTO(EXTRACT(day from sysdate))) ||'('||to_char(EXTRACT(day from sysdate))||')
 días del mes de '||trim(INITCAP(TO_CHAR(SYSDATE,'MONTH','nls_date_language=spanish')))||' de '||to_char(EXTRACT(year from sysdate))||' , con destino A QUIEN PUEDA INTERESAR.</p>' as parrafo_2,
to_char(tab0.valor,'999,999,999,999,999,999.99') as valor_texto,
to_char(tab3.fecha_aprueba_poliza,'dd/mm/yyyy') as fecha_aprueba_poliza,
to_char(tab3.fecha_terminacion,'dd/mm/yyyy') as fecha_terminacion,
dbms_lob.substr(tab0.objeto,4000,1) as objeto_texto


from co_contrato_v tab0
left join compania tab1 on tab1.id_cia = 1 and tab1.estado = 1
left join co_legaliza_contrato tab3 on tab3.id_contrato = tab0.id_contrato
where tab0.id_contrato = $P{id_contrato}]]>
	</queryString>
	<field name="ID_CONTRATO" class="java.math.BigDecimal"/>
	<field name="NO_CONTRATO" class="java.math.BigDecimal"/>
	<field name="ID_ANHOS" class="java.math.BigDecimal"/>
	<field name="FECHA_CONTRATO" class="java.sql.Timestamp"/>
	<field name="ID_SELECCION_EP" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_CONTRATO" class="java.math.BigDecimal"/>
	<field name="ID_CONTRATISTA" class="java.math.BigDecimal"/>
	<field name="ID_CATEGORIA" class="java.math.BigDecimal"/>
	<field name="PLAZO" class="oracle.sql.CLOB"/>
	<field name="VALOR" class="java.math.BigDecimal"/>
	<field name="ESTADO" class="java.math.BigDecimal"/>
	<field name="ACTIVO" class="java.math.BigDecimal"/>
	<field name="ADJUNTO_CONTRATO" class="java.lang.String"/>
	<field name="ADJUNTO_RESOLUCION" class="java.lang.String"/>
	<field name="OBJETO" class="oracle.sql.CLOB"/>
	<field name="FECHA_ANU" class="java.sql.Timestamp"/>
	<field name="MOTIVO_ANU" class="java.lang.String"/>
	<field name="LIQUIDADO" class="java.math.BigDecimal"/>
	<field name="ID_ORDENADOR_GASTO" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_CONVENIO" class="java.math.BigDecimal"/>
	<field name="VALOR_ANTICIPO" class="java.math.BigDecimal"/>
	<field name="PORCENTAJE_ANTICIPO" class="java.math.BigDecimal"/>
	<field name="ID_INICIO_CONTRATO" class="java.math.BigDecimal"/>
	<field name="TERMINACION" class="java.math.BigDecimal"/>
	<field name="DIAS_PLAZO" class="java.math.BigDecimal"/>
	<field name="MESES_PLAZO" class="java.math.BigDecimal"/>
	<field name="ANHOS_PLAZO" class="java.math.BigDecimal"/>
	<field name="LIQUIDACION" class="java.math.BigDecimal"/>
	<field name="MESES_LIQUIDA" class="java.math.BigDecimal"/>
	<field name="CARTA_ACEPTACION" class="java.math.BigDecimal"/>
	<field name="TIPO" class="java.lang.String"/>
	<field name="TIPO_COMPLETO" class="java.lang.String"/>
	<field name="TIPO_ABREVI" class="java.lang.String"/>
	<field name="TIPO_CONTRATO" class="java.lang.String"/>
	<field name="DOC_CONTRA" class="java.math.BigDecimal"/>
	<field name="NOM_CONTRA" class="java.lang.String"/>
	<field name="COMPLETO_CONTRA" class="java.lang.String"/>
	<field name="COMPLETO_SUPERVISOR" class="java.lang.String"/>
	<field name="COMPLETO_ORDENADOR" class="java.lang.String"/>
	<field name="TIPO_CONVENIO" class="java.lang.String"/>
	<field name="PROCESO" class="java.lang.String"/>
	<field name="ID_SUPERVISOR" class="java.math.BigDecimal"/>
	<field name="MODALIDAD" class="java.lang.String"/>
	<field name="VALOR_CDP" class="java.math.BigDecimal"/>
	<field name="PARRAFO_1" class="java.lang.String"/>
	<field name="PARRAFO_2" class="java.lang.String"/>
	<field name="VALOR_TEXTO" class="java.lang.String"/>
	<field name="FECHA_APRUEBA_POLIZA" class="java.lang.String"/>
	<field name="FECHA_TERMINACION" class="java.lang.String"/>
	<field name="OBJETO_TEXTO" class="java.lang.String"/>
	<background>
		<band height="752" splitType="Stretch"/>
	</background>
	<pageHeader>
		<band height="67" splitType="Stretch">
			<image hAlign="Center">
				<reportElement mode="Transparent" x="220" y="0" width="128" 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>
			<image hAlign="Center">
				<reportElement mode="Transparent" x="348" y="0" width="224" 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:top1"]]></imageExpression>
			</image>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="118" splitType="Stretch">
			<textField>
				<reportElement mode="Transparent" x="0" y="17" width="572" 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["EL COORDINADOR DE CONTRATOS Y CONVENIOS DEL SERVICIO GEOLÓGICO COLOMBIANO"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Transparent" x="0" y="49" width="572" 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["CERTIFICA:"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement mode="Transparent" x="0" y="93" width="572" 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="Justified" verticalAlignment="Middle" markup="html">
					<font fontName="Arial" size="10" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PARRAFO_1}]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<summary>
		<band height="233" splitType="Stretch">
			<textField>
				<reportElement positionType="Float" mode="Transparent" x="0" y="155" width="572" height="5" 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="none">
					<font fontName="Arial" size="10" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[""]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" mode="Transparent" x="0" y="185" width="572" 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="Left" verticalAlignment="Middle" markup="none">
					<font fontName="Arial" size="10" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["CARLOS ENRIQUE GUTIÉRREZ REPIZO."]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" mode="Transparent" x="0" y="200" width="572" 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="Left" verticalAlignment="Middle" markup="none">
					<font fontName="Arial" size="10" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Proyectó: Cristian Andrés Matallana. Técnico operativo__ Grupo Contratos ______"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" mode="Transparent" x="0" y="215" width="572" 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="Left" verticalAlignment="Middle" markup="none">
					<font fontName="Arial" size="10" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Reviso:nombre abogado, Abogado.   __ Grupo Contratos ______"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" mode="Transparent" x="0" y="160" width="572" 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="Justified" verticalAlignment="Middle" markup="html">
					<font fontName="Arial" size="10" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PARRAFO_2}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement mode="Transparent" x="0" y="0" width="572" height="30" forecolor="#000000"/>
				<box>
					<pen lineWidth="0.75" lineStyle="Solid"/>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Middle" markup="html">
					<font fontName="Arial" size="10" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["<strong>TIPO DE CONTRATO:</strong> " + $F{TIPO_CONTRATO}+" No. "+ $F{NO_CONTRATO}.toString()+" de "+ $F{ID_ANHOS}.toString()+"(En ejecución a la fecha de expedición del presente certificado)."]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" mode="Transparent" x="0" y="30" width="572" height="30" forecolor="#000000"/>
				<box>
					<pen lineWidth="0.75" lineStyle="Solid"/>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Middle" markup="html">
					<font fontName="Arial" size="10" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["<strong>OBJETO:</strong> " + $F{OBJETO_TEXTO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" mode="Transparent" x="0" y="120" width="572" height="30" forecolor="#000000"/>
				<box>
					<pen lineWidth="0.75" lineStyle="Solid"/>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Middle" markup="html">
					<font fontName="Arial" size="10" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["<strong>VALOR:</strong> " + $F{VALOR_TEXTO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" mode="Transparent" x="0" y="60" width="572" height="30" forecolor="#000000"/>
				<box>
					<pen lineWidth="0.75" lineStyle="Solid"/>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Middle" markup="html">
					<font fontName="Arial" size="10" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["<strong>FECHA DE INICIO:</strong> " +$F{FECHA_APRUEBA_POLIZA}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" mode="Transparent" x="0" y="90" width="572" height="30" forecolor="#000000"/>
				<box>
					<pen lineWidth="0.75" lineStyle="Solid"/>
					<topPen lineWidth="1.0" lineStyle="Solid"/>
					<leftPen lineWidth="1.0" lineStyle="Solid"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid"/>
					<rightPen lineWidth="1.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Middle" markup="html">
					<font fontName="Arial" size="10" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["<strong>FECHA DE TERMINACION:</strong> " + $F{FECHA_TERMINACION}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="572" 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>
