<?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="informe_actividades" language="groovy" pageWidth="792" pageHeight="612" orientation="Landscape" whenNoDataType="NoDataSection" columnWidth="752" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="0.5644739300537785"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/radicacionvirtualcuentas/informe_actividades"/>
	<property name="ireport.jasperserver.url" value="http://localhost:18080/jasperserver/services/repository"/>
	<subDataset name="dataset1"/>
	<parameter name="id_formato_pago" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT

tab0.estado_general,

tab0.id_formato_pago as id_formato_pago,
tab0.id_contratista as id_contratista,
tab0.id_contrato as id_contrato,
tab0.id_numero_pago as id_numero_pago,

tab0.fecha_ini_pago as fecha_ini_pago,
LPAD(TO_CHAR(tab0.fecha_ini_pago,'dd'),2,'0') as DIA_ini_pago,
initcap(trim(lower(TO_CHAR(tab0.fecha_ini_pago,'MONTH','nls_date_language=spanish')))) as MES_ini_pago,
TO_CHAR(tab0.fecha_ini_pago,'yyyy') as anho_ini_pago,
tab0.fecha_fin_pago as fecha_fin_pago,
LPAD(TO_CHAR(tab0.fecha_fin_pago,'dd'),2,'0') as DIA_fin_pago,
initcap(trim(lower(TO_CHAR(tab0.fecha_fin_pago,'MONTH','nls_date_language=spanish')))) as MES_fin_pago,
TO_CHAR(tab0.fecha_fin_pago,'yyyy') as anho_fin_pago,

tab0.fecha_log as fecha_log,
tab0.usuario_log as usuario_log, tab0.valor_embargo as valor_embargo,


tab0.firmado as firmado,
tab0.revisado as revisado,
tab0.autorizado as autorizado,
tab0.radicado as radicado,
tab0.estado as estado_pago,
tab0.aprobado as aprobado,

tab1.num_contrato as num_contrato, tab1.id_anhos as id_anhos,
tab1.fecha_contrato as fecha_contrato,
tab1.objeto as objeto, tab1.obligaciones as obligaciones, tab1.estado as estado,
tab1.rp_anm as rp_anm, tab1.rp_sgr as rp_sgr, tab1.rp_anm||tab1.rp_sgr as rp,
tab1.fecha_rp as fecha_rp,
tab1.fecha_poliza as fecha_poliza,
tab1.valor_anm as valor_anm, tab1.cdp_anm as cdp_anm,
tab1.fecha_cdp_anm as fecha_cdp_anm,
tab1.valor_sgr as valor_sgr, tab1.cdp_sgr as cdp_sgr,
tab1.fecha_cdp_sgr as fecha_cdp_sgr,
tab1.dependencia as dependencia, tab1.meses_plazo as meses_plazo, tab1.dias_plazo as dias_plazo,
tab1.fecha_plazo as fecha_plazo,
tab1.id_supervisor as id_supervisor,
tab1.id_apoyo_supervisor as id_apoyo_supervisor, tab1.valor_anm+tab1.valor_sgr as valor_contrato,
case when tab1.meses_plazo is not null then
  tab1.meses_plazo
else
  case when tab1.dias_plazo is not null then
    round(tab1.dias_plazo/30)
  else
    round(MONTHS_BETWEEN(to_date(tab1.fecha_plazo,'DD/MM/YYYY'),to_date(tab1.fecha_contrato,'DD/MM/YYYY')))
  end
end
as hasta,
tab1.numero_pago,

tab2.tipo_recurso as tipo_recurso, tab2.id_tipo_doc as id_tipo_doc, tab2.num_doc as num_doc,
tab2.razon_social as razon_social, tab2.correo as correo, tab2.id_ciudad as id_ciudad,
tab2.estado as estado_contratista, tab2.id_tipo_regimen as id_tipo_regimen,
tab2.mas_empleados as mas_empleados, tab2.declarante_renta as declarante_renta,
tab2.pensionado as pensionado, tab2.embargo as embargo, tab2.valor_embargo as valor_embargo_contra,
tab2.num_doc||' - '||tab2.razon_social as completo, tab3.descripcion as tipo_regimen,
tab3.aplica_iva as aplica_iva, tab4.numero as numero, tab4.descripcion as numero_pago,
tab5.codigo as codigo, tab5.descripcion as descripcion_riesgo,
tab5.valor as valor_riesgo,

actobl.id_actividad_obligacion,
actobl.orden as orden_obl,
actobl.descripcion as descripcion_obl,
actobl.fecha_log as fecha_log_obl,
actobl.usuario_log as usuario_log_obl,

nvl(ter.num_doc,tercon.num_doc) as num_doc_sup,
nvl(ter.razon_soc,tercon.razon_soc) as razon_soc,
nvl(sup.CARGO,supcon.CARGO) as cargo,

nvl(nvl(ter_apo.num_doc,ter_apocon.num_doc),'NA') as num_doc_apo,
nvl(ter_apo.razon_soc,ter_apocon.razon_soc) as razon_soc_apo,
nvl(apo.cargo,apocon.cargo) as cargo_apo,

anex.anexo_actividad

FROM RVC_FORMATO_PAGO_V tab0

LEFT JOIN RVC_CONTRATO tab1 ON tab0.id_contrato = tab1.id_contrato
LEFT JOIN RVC_CONTRATISTA tab2 ON tab0.id_contratista = tab2.id_contratista

left join rvc_supervisor sup on sup.ID_SUPERVISOR = tab0.USUARIO_AUTORIZADO
left join interceros_v ter on ter.ID_MAE_TER = sup.ID_MAE_TER

left join rvc_supervisor supcon on supcon.ID_SUPERVISOR = tab1.ID_SUPERVISOR
left join interceros_v tercon on tercon.ID_MAE_TER = supcon.ID_MAE_TER

left join rvc_apoyo_supervisor apo on tab0.USUARIO_REVISADO=apo.id_apoyo_supervisor
left join interceros_v ter_apo on ter_apo.id_mae_ter=apo.id_mae_ter

left join rvc_apoyo_supervisor apocon on tab1.id_apoyo_supervisor=apocon.id_apoyo_supervisor
left join interceros_v ter_apocon on ter_apocon.id_mae_ter=apocon.id_mae_ter


LEFT JOIN RVC_TIPO_REGIMEN tab3 ON tab2.id_tipo_regimen = tab3.id_tipo_regimen
LEFT JOIN RVC_NUMERO_PAGO tab4 ON tab0.id_numero_pago = tab4.id_numero_pago
LEFT JOIN RVC_TIPO_RIESGO tab5 ON tab0.id_tipo_riesgo = tab5.id_tipo_riesgo
left join rvc_actividad_obligacion actobl
on tab0.id_formato_pago = actobl.id_formato_pago

left join (select id_formato_pago, max(anexo) as anexo_actividad from(
select id_formato_pago,case when adjunto_anexo_actividades is null then 0 else 1 end as Anexo from rvc_actividad_obligacion) group by id_formato_pago)anex on anex.id_formato_pago=tab0.ID_FORMATO_PAGO


WHERE
tab0.id_formato_pago = $P{id_formato_pago}

ORDER BY
num_doc ,
id_anhos ,
num_contrato ,
numero ,
numero_planilla ,
actobl.orden]]>
	</queryString>
	<field name="ESTADO_GENERAL" class="java.math.BigDecimal"/>
	<field name="ID_FORMATO_PAGO" class="java.math.BigDecimal"/>
	<field name="ID_CONTRATISTA" class="java.math.BigDecimal"/>
	<field name="ID_CONTRATO" class="java.math.BigDecimal"/>
	<field name="ID_NUMERO_PAGO" class="java.math.BigDecimal"/>
	<field name="FECHA_INI_PAGO" class="java.sql.Timestamp"/>
	<field name="DIA_INI_PAGO" class="java.lang.String"/>
	<field name="MES_INI_PAGO" class="java.lang.String"/>
	<field name="ANHO_INI_PAGO" class="java.lang.String"/>
	<field name="FECHA_FIN_PAGO" class="java.sql.Timestamp"/>
	<field name="DIA_FIN_PAGO" class="java.lang.String"/>
	<field name="MES_FIN_PAGO" class="java.lang.String"/>
	<field name="ANHO_FIN_PAGO" class="java.lang.String"/>
	<field name="FECHA_LOG" class="java.sql.Timestamp"/>
	<field name="USUARIO_LOG" class="java.lang.String"/>
	<field name="VALOR_EMBARGO" class="java.math.BigDecimal"/>
	<field name="FIRMADO" class="java.math.BigDecimal"/>
	<field name="REVISADO" class="java.math.BigDecimal"/>
	<field name="AUTORIZADO" class="java.math.BigDecimal"/>
	<field name="RADICADO" class="java.math.BigDecimal"/>
	<field name="ESTADO_PAGO" class="java.math.BigDecimal"/>
	<field name="APROBADO" class="java.math.BigDecimal"/>
	<field name="NUM_CONTRATO" class="java.lang.String"/>
	<field name="ID_ANHOS" class="java.math.BigDecimal"/>
	<field name="FECHA_CONTRATO" class="java.sql.Timestamp"/>
	<field name="OBJETO" class="java.lang.String"/>
	<field name="OBLIGACIONES" class="java.lang.String"/>
	<field name="ESTADO" class="java.math.BigDecimal"/>
	<field name="RP_ANM" class="java.math.BigDecimal"/>
	<field name="RP_SGR" class="java.math.BigDecimal"/>
	<field name="RP" class="java.lang.String"/>
	<field name="FECHA_RP" class="java.sql.Timestamp"/>
	<field name="FECHA_POLIZA" class="java.sql.Timestamp"/>
	<field name="VALOR_ANM" class="java.math.BigDecimal"/>
	<field name="CDP_ANM" class="java.math.BigDecimal"/>
	<field name="FECHA_CDP_ANM" class="java.sql.Timestamp"/>
	<field name="VALOR_SGR" class="java.math.BigDecimal"/>
	<field name="CDP_SGR" class="java.math.BigDecimal"/>
	<field name="FECHA_CDP_SGR" class="java.sql.Timestamp"/>
	<field name="DEPENDENCIA" class="java.lang.String"/>
	<field name="MESES_PLAZO" class="java.math.BigDecimal"/>
	<field name="DIAS_PLAZO" class="java.math.BigDecimal"/>
	<field name="FECHA_PLAZO" class="java.sql.Timestamp"/>
	<field name="ID_SUPERVISOR" class="java.math.BigDecimal"/>
	<field name="ID_APOYO_SUPERVISOR" class="java.math.BigDecimal"/>
	<field name="VALOR_CONTRATO" class="java.math.BigDecimal"/>
	<field name="HASTA" class="java.math.BigDecimal"/>
	<field name="NUMERO_PAGO" class="java.math.BigDecimal"/>
	<field name="TIPO_RECURSO" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_DOC" class="java.math.BigDecimal"/>
	<field name="NUM_DOC" class="java.lang.String"/>
	<field name="RAZON_SOCIAL" class="java.lang.String"/>
	<field name="CORREO" class="java.lang.String"/>
	<field name="ID_CIUDAD" class="java.math.BigDecimal"/>
	<field name="ESTADO_CONTRATISTA" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_REGIMEN" class="java.math.BigDecimal"/>
	<field name="MAS_EMPLEADOS" class="java.math.BigDecimal"/>
	<field name="DECLARANTE_RENTA" class="java.math.BigDecimal"/>
	<field name="PENSIONADO" class="java.math.BigDecimal"/>
	<field name="EMBARGO" class="java.math.BigDecimal"/>
	<field name="VALOR_EMBARGO_CONTRA" class="java.math.BigDecimal"/>
	<field name="COMPLETO" class="java.lang.String"/>
	<field name="TIPO_REGIMEN" class="java.lang.String"/>
	<field name="APLICA_IVA" class="java.math.BigDecimal"/>
	<field name="NUMERO" class="java.math.BigDecimal"/>
	<field name="CODIGO" class="java.lang.String"/>
	<field name="DESCRIPCION_RIESGO" class="java.lang.String"/>
	<field name="VALOR_RIESGO" class="java.math.BigDecimal"/>
	<field name="ID_ACTIVIDAD_OBLIGACION" class="java.math.BigDecimal"/>
	<field name="ORDEN_OBL" class="java.math.BigDecimal"/>
	<field name="DESCRIPCION_OBL" class="java.lang.String"/>
	<field name="FECHA_LOG_OBL" class="java.sql.Timestamp"/>
	<field name="USUARIO_LOG_OBL" class="java.lang.String"/>
	<field name="NUM_DOC_SUP" class="java.lang.String"/>
	<field name="RAZON_SOC" class="java.lang.String"/>
	<field name="CARGO" class="java.lang.String"/>
	<field name="NUM_DOC_APO" class="java.lang.String"/>
	<field name="RAZON_SOC_APO" class="java.lang.String"/>
	<field name="CARGO_APO" class="java.lang.String"/>
	<field name="ANEXO_ACTIVIDAD" class="java.math.BigDecimal"/>
	<background>
		<band height="572" splitType="Stretch">
			<image>
				<reportElement x="211" y="56" width="370" height="469">
					<printWhenExpression><![CDATA[$F{FIRMADO}.toString()=="1" && $F{REVISADO}.toString()=="1" && $F{AUTORIZADO}.toString()=="0" && $F{ESTADO_PAGO}.toString()=="1" && $F{RADICADO}.toString()=="0"?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:wmrevisado"]]></imageExpression>
			</image>
			<image>
				<reportElement x="211" y="56" width="370" height="469">
					<printWhenExpression><![CDATA[$F{FIRMADO}.toString()=="1" && $F{REVISADO}.toString()=="1" && $F{AUTORIZADO}.toString()=="1" && $F{ESTADO_PAGO}.toString()=="1" && $F{RADICADO}.toString()=="0"?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:wmautorizado"]]></imageExpression>
			</image>
			<image>
				<reportElement x="211" y="56" width="370" height="469">
					<printWhenExpression><![CDATA[$F{ESTADO_PAGO}.toString()=="0"?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:wmrechazado"]]></imageExpression>
			</image>
			<image>
				<reportElement x="211" y="56" width="370" height="469">
					<printWhenExpression><![CDATA[$F{FIRMADO}.toString()=="1" && $F{REVISADO}.toString()=="0" && $F{AUTORIZADO}.toString()=="0" && $F{ESTADO_PAGO}.toString()=="1" && $F{RADICADO}.toString()=="0"?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:wmfirmado"]]></imageExpression>
			</image>
			<image>
				<reportElement x="211" y="56" width="370" height="469">
					<printWhenExpression><![CDATA[$F{RADICADO}.toString()=="1" && $F{ESTADO_PAGO}.toString()=="1" && $F{APROBADO}.toString()=="0" ?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:wmradicado"]]></imageExpression>
			</image>
			<image>
				<reportElement x="211" y="56" width="370" height="469">
					<printWhenExpression><![CDATA[$F{ESTADO_GENERAL}.toString()=="6" && $F{ESTADO}.toString()=="1" ?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:wmaprobado"]]></imageExpression>
			</image>
			<image>
				<reportElement x="211" y="56" width="370" height="469">
					<printWhenExpression><![CDATA[$F{ESTADO_GENERAL}.toString()=="7" && $F{ESTADO}.toString()=="1" ?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:wmpagado"]]></imageExpression>
			</image>
		</band>
	</background>
	<pageHeader>
		<band height="68" splitType="Stretch">
			<staticText>
				<reportElement x="180" y="0" width="572" height="60"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[INFORME DE ACTIVIDADES]]></text>
			</staticText>
			<rectangle>
				<reportElement x="0" y="0" width="180" height="60"/>
			</rectangle>
			<image>
				<reportElement x="24" y="9" width="133" height="40"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="146" splitType="Immediate">
			<printWhenExpression><![CDATA[$V{PAGE_NUMBER} == 1]]></printWhenExpression>
			<staticText>
				<reportElement x="0" y="121" width="280" height="25"/>
				<box>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[OBLIGACIONES Y/O ACTIVIDADES]]></text>
			</staticText>
			<staticText>
				<reportElement x="280" y="121" width="472" height="25"/>
				<box>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[ACCIONES]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="555" y="79" width="197" height="15"/>
				<box>
					<topPen lineWidth="1.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUMERO} + " de " + $F{NUMERO_PAGO}.toString()]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="515" y="94" width="237" height="15"/>
				<box>
					<topPen lineWidth="0.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{MES_INI_PAGO} +" "+ $F{DIA_INI_PAGO} +" de "+ $F{ANHO_INI_PAGO} +" a "+ $F{MES_FIN_PAGO} +" "+ $F{DIA_FIN_PAGO} +" de "+ $F{ANHO_FIN_PAGO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="480" y="79" width="75" height="15"/>
				<box topPadding="0" leftPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Informe No:]]></text>
			</staticText>
			<staticText>
				<reportElement x="280" y="79" width="80" height="30"/>
				<box topPadding="2" leftPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
				</box>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Contrato No.:]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="79" width="80" height="30"/>
				<box topPadding="2" leftPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
				</box>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Contratista:]]></text>
			</staticText>
			<textField>
				<reportElement x="80" y="79" width="200" height="30"/>
				<box topPadding="2" leftPadding="0">
					<topPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOCIAL}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="480" y="94" width="35" height="15"/>
				<box topPadding="0" leftPadding="2">
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Mes:]]></text>
			</staticText>
			<textField>
				<reportElement x="360" y="79" width="120" height="30"/>
				<box topPadding="2">
					<topPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_CONTRATO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="70" height="65"/>
				<box topPadding="2" leftPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
				</box>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Objeto:]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="70" y="0" width="682" height="65"/>
				<box topPadding="2">
					<topPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{OBJETO}]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<detail>
		<band height="20" splitType="Prevent">
			<subreport runToBottom="false">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="280" y="0" width="472" height="20">
					<printWhenExpression><![CDATA[$F{ID_ACTIVIDAD_OBLIGACION} != null]]></printWhenExpression>
				</reportElement>
				<subreportParameter name="id_actividad_obligacion">
					<subreportParameterExpression><![CDATA[$F{ID_ACTIVIDAD_OBLIGACION}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression class="java.lang.String"><![CDATA["repo:informe_actividades_subreport1"]]></subreportExpression>
			</subreport>
			<rectangle>
				<reportElement stretchType="RelativeToBandHeight" mode="Transparent" x="0" y="0" width="752" height="20"/>
			</rectangle>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" isPrintRepeatedValues="false" x="24" y="0" width="256" height="20">
					<printWhenExpression><![CDATA[$F{ID_ACTIVIDAD_OBLIGACION} != null]]></printWhenExpression>
				</reportElement>
				<box topPadding="2" leftPadding="2" bottomPadding="2" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Justified"/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESCRIPCION_OBL}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" isPrintRepeatedValues="false" x="0" y="0" width="24" height="20">
					<printWhenExpression><![CDATA[$F{ID_ACTIVIDAD_OBLIGACION} != null]]></printWhenExpression>
				</reportElement>
				<box topPadding="2" leftPadding="2" bottomPadding="2" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ORDEN_OBL}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<pageFooter>
		<band height="24" splitType="Stretch">
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
				<reportElement mode="Opaque" x="744" y="12" width="8" height="12" forecolor="#575757" backcolor="#FFFFFF"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Opaque" x="507" y="12" width="245" height="12" forecolor="#575757" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Página "+$V{PAGE_NUMBER}.toString()+" de "+$V{PAGE_COUNT}.toString()]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Opaque" x="586" y="2" width="166" height="10" forecolor="#575757" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["APO1-P-001-F-012"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement mode="Opaque" x="0" y="2" width="480" height="22" forecolor="#575757" backcolor="#FFFFFF"/>
				<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[( $F{ANEXO_ACTIVIDAD} >= 0
    ? "CONCLUSIONES: \n Nota: Se anexarán evidencias cuando el supervisor así lo requiera."
    : ""
)]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band height="96" splitType="Stretch">
			<staticText>
				<reportElement x="507" y="74" width="220" height="15"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[Supervisor]]></text>
			</staticText>
			<staticText>
				<reportElement x="17" y="74" width="220" height="15"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[Contratista]]></text>
			</staticText>
			<textField>
				<reportElement mode="Transparent" x="17" y="59" width="220" height="15" forecolor="#000000"/>
				<box>
					<pen lineWidth="0.75" lineStyle="Dotted"/>
					<topPen lineWidth="0.75" lineStyle="Solid"/>
					<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="SansSerif" size="10" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOCIAL}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Opaque" x="507" y="59" width="220" height="15" forecolor="#000000"/>
				<box>
					<pen lineWidth="0.75" lineStyle="Dotted"/>
					<topPen lineWidth="0.75" lineStyle="Solid"/>
					<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="SansSerif" size="10" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOC}]]></textFieldExpression>
			</textField>
			<image>
				<reportElement x="91" y="12" width="81" height="45">
					<printWhenExpression><![CDATA[$F{FIRMADO}.toString()=="1"?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:firmado"]]></imageExpression>
			</image>
			<image>
				<reportElement x="586" y="12" width="69" height="45">
					<printWhenExpression><![CDATA[$F{AUTORIZADO}.toString()=="1"?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:autorizado"]]></imageExpression>
			</image>
			<image>
				<reportElement x="338" y="12" width="81" height="45">
					<printWhenExpression><![CDATA[$F{REVISADO}.toString()=="1" && $F{NUM_DOC_APO}!="NA"?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:revisado"]]></imageExpression>
			</image>
			<textField>
				<reportElement mode="Transparent" x="264" y="59" width="220" height="15" forecolor="#000000">
					<printWhenExpression><![CDATA[$F{NUM_DOC_APO}!="NA"?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<box>
					<pen lineWidth="0.75" lineStyle="Dotted"/>
					<topPen lineWidth="0.75" lineStyle="Solid"/>
					<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="SansSerif" size="10" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOC_APO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="264" y="74" width="220" height="15">
					<printWhenExpression><![CDATA[$F{NUM_DOC_APO}!="NA"?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[Apoyo Supervisor]]></text>
			</staticText>
		</band>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="752" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
