<?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="com_program_comisiones" language="groovy" pageWidth="900" pageHeight="612" orientation="Landscape" whenNoDataType="NoDataSection" columnWidth="860" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="0.8264462809917363"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/control_comisiones/com_plan_comisiones"/>
	<property name="ireport.jasperserver.url" value="http://192.168.2.43:8090/jasperserver/services/repository"/>
	<parameter name="id_plan_comisiones" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="vigencia" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["/home/lavila/Reportes Jasper/Reportes Jasper ControlComisiones/Planeacion de Comisiones/"]]></defaultValueExpression>
	</parameter>
	<parameter name="whereIdComisiones" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="comando" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="id_comisiones" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select

case when tab0.fecha >= to_date('27/09/2021','dd/mm/yyyy') then 1 else 0 end as fecha_tag,
(
    select
    listagg(mun.municipio || ' - ' || dep.descripcion || case when dest.observaciones is not null then '('||dest.observaciones||')' else '' end , ', ') within group (order by dest.codmun) as destinos
    from com_plan_destinos dest
    left join municipios mun
    on mun.codmun = dest.codmun
    left join departamento dep
    on dep.id_depto = dest.id_depto
    WHERE
    dest.id_plan_comisiones = tab0.id_plan_comisiones
    and dest.vigencia = tab0.vigencia
    and dest.estado = 1
) as destinos,

extract(day from tab0.fecha) as dia_fecha,
lower(numero_a_texto ( to_char(tab0.fecha,'dd'), 2, 'ESP' )) as dia_fecha_letra,
trim(initcap(to_char(tab0.fecha,'MONTH','nls_date_language=spanish'))) as mes_fecha,
to_char(tab0.fecha,'yyyy') as anho_fecha,

extract(day from sysdate) as dia_actual,
lower(numero_a_texto ( to_char(sysdate,'dd'), 2, 'ESP' )) as dia_actual_letra,
trim(initcap(to_char(sysdate,'MONTH','nls_date_language=spanish'))) as mes_actual,
to_char(sysdate,'yyyy') as anho_actual,
to_char(sysdate,'HH:MI a.m.') as hora_actual,

tab0.id_plan_comisiones as id_plan_comisiones,
tab0.vigencia as vigencia,
tab0.id_area as id_area,
tab0.tipcomi as tipcomi,
tab0.id_proyectos as id_proyectos,
tab0.fecha as fecha,
tab0.objetivo as objetivo,
tab0.actividad as actividad,
tab0.observaciones as observaciones,
tab0.fecha_log as fecha_log,
tab0.usuario_log as usuario_log, tab0.justificacion as justificacion,
tab0.interrupcion as interrupcion, tab0.id_original as id_original,
tab0.vobo as vobo, tab0.estado as estado,
tab0.fecha_estado as fecha_estado,
tab0.id_usuario_estado as id_usuario_estado,
tab0.observaciones_estado as observaciones_estado,
tab0.nivel_rechazo as nivel_rechazo, tab0.firmado as firmado,
tab0.fecha_firmado as fecha_firmado,
tab0.id_usuario_firmado as id_usuario_firmado,
tab0.autorizado as autorizado,
tab0.fecha_autorizado as fecha_autorizado,
tab0.id_usuario_autorizado as id_usuario_autorizado,
tab0.observacion_aut as observacion_aut,
tab0.fecha_salida as fecha_salida,
tab0.fecha_regreso as fecha_regreso,
tab0.cod_area as cod_area, tab0.area as area,
tab0.sigla as sigla, tab0.descomi as descomi,
tab0.observ as observ, tab0.dcomi as dcomi,
tab0.ano_fiscal as ano_fiscal, tab0.cod_proyecto as cod_proyecto,
tab0.proyecto as proyecto,
tab0.estado_general as estado_general,
tab0.desc_estado_general as desc_estado_general,
tab0.fecha_estado_general as fecha_estado_general,
tab0.usuario_estado_general as usuario_estado_general,
tab0.obs_estado_general as obs_estado_general,
tab0.num_doc_terlog as num_doc_terlog,
tab0.razon_soc_terlog as razon_soc_terlog,
tab0.num_doc_tersup as num_doc_tersup,
tab0.razon_soc_tersup as razon_soc_tersup,
tab0.correo as correo,
tab0.correo_tersup as correo_tersup,
tab0.num_doc_terest as num_doc_terest,
tab0.razon_soc_terest as razon_soc_terest,
tab0.num_doc_terfir as num_doc_terfir,
tab0.razon_soc_terfir as razon_soc_terfir,
tab0.num_doc_teraut as num_doc_teraut,
tab0.razon_soc_teraut as razon_soc_teraut, tab0.nitocc as nitocc,
tab0.codobj as codobj, tab0.valor as valor, tab0.valor_gasto as valor_gasto,
tab0.viaticos as viaticos, tab0.acumulado_gastos as acumulado_gastos,
tab0.taxis as taxis, tab0.tarifa as tarifa,
tab0.cod_proyecto||' - '||tab0.proyecto as completo_proyecto,
tab0.num_doc_tersup||' - '||tab0.razon_soc_tersup as completo_supervisor,
tab0.num_doc_terlog||' - '||tab0.razon_soc_terlog as completo_programador,
--ESTADO PROGRAMACION
tab1.desc_estado_general as desc_estado_general_program,
tab1.fecha_estado_general as fecha_estado_general_program,
tab1.usuario_estado_general as usuario_estado_general_program,
tab1.obs_estado_general as obs_estado_general_program,
tab1.estado_general AS estado_general_program


FROM COM_PLAN_COMISIONES_V tab0
left join COM_PLAN_PROGRAM_COMIS_V tab1 on tab1.ID_PLAN_COMISIONES = tab0.ID_PLAN_COMISIONES and tab1.VIGENCIA=tab0.VIGENCIA

WHERE
tab0.id_plan_comisiones = $P{id_plan_comisiones}
and tab0.vigencia = $P{vigencia}
and tab1.id_comisiones = $P{id_comisiones}
ORDER BY
tab0.vigencia,
tab0.id_plan_comisiones]]>
	</queryString>
	<field name="FECHA_TAG" class="java.math.BigDecimal"/>
	<field name="DESTINOS" class="java.lang.String"/>
	<field name="DIA_FECHA" class="java.math.BigDecimal"/>
	<field name="DIA_FECHA_LETRA" class="java.lang.String"/>
	<field name="MES_FECHA" class="java.lang.String"/>
	<field name="ANHO_FECHA" class="java.lang.String"/>
	<field name="DIA_ACTUAL" class="java.math.BigDecimal"/>
	<field name="DIA_ACTUAL_LETRA" class="java.lang.String"/>
	<field name="MES_ACTUAL" class="java.lang.String"/>
	<field name="ANHO_ACTUAL" class="java.lang.String"/>
	<field name="HORA_ACTUAL" class="java.lang.String"/>
	<field name="ID_PLAN_COMISIONES" class="java.math.BigDecimal"/>
	<field name="VIGENCIA" class="java.math.BigDecimal"/>
	<field name="ID_AREA" class="java.math.BigDecimal"/>
	<field name="TIPCOMI" class="java.lang.String"/>
	<field name="ID_PROYECTOS" class="java.math.BigDecimal"/>
	<field name="FECHA" class="java.sql.Timestamp"/>
	<field name="OBJETIVO" class="java.lang.String"/>
	<field name="ACTIVIDAD" class="java.lang.String"/>
	<field name="OBSERVACIONES" class="java.lang.String"/>
	<field name="FECHA_LOG" class="java.sql.Timestamp"/>
	<field name="USUARIO_LOG" class="java.math.BigDecimal"/>
	<field name="JUSTIFICACION" class="java.lang.String"/>
	<field name="INTERRUPCION" class="java.lang.String"/>
	<field name="ID_ORIGINAL" class="java.math.BigDecimal"/>
	<field name="VOBO" class="java.math.BigDecimal"/>
	<field name="ESTADO" class="java.math.BigDecimal"/>
	<field name="FECHA_ESTADO" class="java.sql.Timestamp"/>
	<field name="ID_USUARIO_ESTADO" class="java.math.BigDecimal"/>
	<field name="OBSERVACIONES_ESTADO" class="java.lang.String"/>
	<field name="NIVEL_RECHAZO" class="java.math.BigDecimal"/>
	<field name="FIRMADO" class="java.math.BigDecimal"/>
	<field name="FECHA_FIRMADO" class="java.sql.Timestamp"/>
	<field name="ID_USUARIO_FIRMADO" class="java.math.BigDecimal"/>
	<field name="AUTORIZADO" class="java.math.BigDecimal"/>
	<field name="FECHA_AUTORIZADO" class="java.sql.Timestamp"/>
	<field name="ID_USUARIO_AUTORIZADO" class="java.math.BigDecimal"/>
	<field name="OBSERVACION_AUT" class="java.lang.String"/>
	<field name="FECHA_SALIDA" class="java.sql.Timestamp"/>
	<field name="FECHA_REGRESO" class="java.sql.Timestamp"/>
	<field name="COD_AREA" class="java.lang.String"/>
	<field name="AREA" class="java.lang.String"/>
	<field name="SIGLA" class="java.lang.String"/>
	<field name="DESCOMI" class="java.lang.String"/>
	<field name="OBSERV" class="java.lang.String"/>
	<field name="DCOMI" class="java.lang.String"/>
	<field name="ANO_FISCAL" class="java.lang.String"/>
	<field name="COD_PROYECTO" class="java.lang.String"/>
	<field name="PROYECTO" class="java.lang.String"/>
	<field name="ESTADO_GENERAL" class="java.math.BigDecimal"/>
	<field name="DESC_ESTADO_GENERAL" class="java.lang.String"/>
	<field name="FECHA_ESTADO_GENERAL" class="java.sql.Timestamp"/>
	<field name="USUARIO_ESTADO_GENERAL" class="java.lang.String"/>
	<field name="OBS_ESTADO_GENERAL" class="java.lang.String"/>
	<field name="NUM_DOC_TERLOG" class="java.lang.String"/>
	<field name="RAZON_SOC_TERLOG" class="java.lang.String"/>
	<field name="NUM_DOC_TERSUP" class="java.math.BigDecimal"/>
	<field name="RAZON_SOC_TERSUP" class="java.lang.String"/>
	<field name="CORREO" class="java.lang.String"/>
	<field name="CORREO_TERSUP" class="java.lang.String"/>
	<field name="NUM_DOC_TEREST" class="java.lang.String"/>
	<field name="RAZON_SOC_TEREST" class="java.lang.String"/>
	<field name="NUM_DOC_TERFIR" class="java.lang.String"/>
	<field name="RAZON_SOC_TERFIR" class="java.lang.String"/>
	<field name="NUM_DOC_TERAUT" class="java.lang.String"/>
	<field name="RAZON_SOC_TERAUT" class="java.lang.String"/>
	<field name="NITOCC" class="java.lang.String"/>
	<field name="CODOBJ" class="java.lang.String"/>
	<field name="VALOR" class="java.math.BigDecimal"/>
	<field name="VALOR_GASTO" class="java.math.BigDecimal"/>
	<field name="VIATICOS" class="java.math.BigDecimal"/>
	<field name="ACUMULADO_GASTOS" class="java.math.BigDecimal"/>
	<field name="TAXIS" class="java.math.BigDecimal"/>
	<field name="TARIFA" class="java.math.BigDecimal"/>
	<field name="COMPLETO_PROYECTO" class="java.lang.String"/>
	<field name="COMPLETO_SUPERVISOR" class="java.lang.String"/>
	<field name="COMPLETO_PROGRAMADOR" class="java.lang.String"/>
	<field name="DESC_ESTADO_GENERAL_PROGRAM" class="java.lang.String"/>
	<field name="FECHA_ESTADO_GENERAL_PROGRAM" class="java.sql.Timestamp"/>
	<field name="USUARIO_ESTADO_GENERAL_PROGRAM" class="java.lang.String"/>
	<field name="OBS_ESTADO_GENERAL_PROGRAM" class="java.lang.String"/>
	<field name="ESTADO_GENERAL_PROGRAM" class="java.math.BigDecimal"/>
	<background>
		<band height="572" splitType="Stretch">
			<image>
				<reportElement x="180" y="40" width="370" height="469">
					<printWhenExpression><![CDATA[$F{ESTADO_GENERAL_PROGRAM}.toString()=="4" ?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:wmaprobado"]]></imageExpression>
			</image>
			<image>
				<reportElement x="180" y="40" width="370" height="469">
					<printWhenExpression><![CDATA[$F{ESTADO_GENERAL_PROGRAM}.toString()=="-1" ?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:wmanulado"]]></imageExpression>
			</image>
			<image>
				<reportElement x="180" y="40" width="370" height="469">
					<printWhenExpression><![CDATA[$F{ESTADO_GENERAL_PROGRAM}.toString()=="1" ?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:wmabierto"]]></imageExpression>
			</image>
			<image>
				<reportElement x="180" y="40" width="370" height="469">
					<printWhenExpression><![CDATA[$F{ESTADO_GENERAL_PROGRAM}.toString()=="2" ?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:wmcerrado"]]></imageExpression>
			</image>
			<image>
				<reportElement x="180" y="40" width="370" height="469">
					<printWhenExpression><![CDATA[$F{ESTADO_GENERAL_PROGRAM}.toString()=="0" ?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:wmnoaprobado"]]></imageExpression>
			</image>
		</band>
	</background>
	<columnHeader>
		<band height="113" splitType="Stretch">
			<textField>
				<reportElement x="180" y="20" width="380" height="30"/>
				<box leftPadding="2">
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Top" markup="none">
					<font fontName="SansSerif" size="10" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{AREA}]]></textFieldExpression>
			</textField>
			<image>
				<reportElement x="20" y="7" width="140" height="63"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
			<staticText>
				<reportElement mode="Transparent" x="180" y="0" width="380" height="20" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Área:]]></text>
			</staticText>
			<textField>
				<reportElement x="180" y="70" width="530" height="30"/>
				<box leftPadding="2">
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Top" markup="none">
					<font fontName="SansSerif" size="10" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{COMPLETO_PROYECTO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="180" y="50" width="530" height="20" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Proyecto:]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="560" y="0" width="150" height="20" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Fecha:]]></text>
			</staticText>
			<textField>
				<reportElement x="560" y="20" width="150" height="30"/>
				<box leftPadding="2">
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Top" markup="none">
					<font fontName="SansSerif" size="10" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{MES_FECHA} + " " + $F{ANHO_FECHA}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="710" y="0" width="150" height="20" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Tipo comisión:]]></text>
			</staticText>
			<textField>
				<reportElement x="710" y="20" width="150" height="30"/>
				<box leftPadding="2">
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Top" markup="none">
					<font fontName="SansSerif" size="10" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESCOMI} + " " + ($F{INTERRUPCION}.toString()=="1"?"CON INTERRUPCION":"")]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="710" y="50" width="150" height="20" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Consecutivo:]]></text>
			</staticText>
			<textField>
				<reportElement x="710" y="70" width="150" height="30"/>
				<box leftPadding="2">
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Top" markup="none">
					<font fontName="SansSerif" size="10" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{id_comisiones}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="0" width="180" height="100"/>
				<box leftPadding="2">
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Bottom" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["PROGRAMACIÓN DE RECURSOS POR COMISIÓN O DESPLAZAMIENTO"]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<detail>
		<band height="76" splitType="Stretch">
			<staticText>
				<reportElement mode="Transparent" x="0" y="0" width="300" height="20" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Objetivos:]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="0" y="20" width="300" height="40" isRemoveLineWhenBlank="true"/>
				<box leftPadding="2" rightPadding="4">
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Top" markup="none">
					<font fontName="SansSerif" size="10" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{OBJETIVO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="300" y="20" width="300" height="40" isRemoveLineWhenBlank="true"/>
				<box leftPadding="4" rightPadding="4">
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Top" markup="none">
					<font fontName="SansSerif" size="10" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ACTIVIDAD}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="300" y="0" width="300" height="20" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Actividades:]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="600" y="20" width="260" height="40" isRemoveLineWhenBlank="true"/>
				<box leftPadding="4" rightPadding="2">
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Top" markup="none">
					<font fontName="SansSerif" size="10" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESTINOS}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="600" y="0" width="260" height="20" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Destino(s):]]></text>
			</staticText>
		</band>
		<band height="80" splitType="Prevent">
			<subreport>
				<reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="860" height="80" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{FECHA_TAG}.intValue() == 0]]></printWhenExpression>
				</reportElement>
				<subreportParameter name="whereIdComisiones">
					<subreportParameterExpression><![CDATA[$P{whereIdComisiones}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="vigencia">
					<subreportParameterExpression><![CDATA[$F{VIGENCIA}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="id_plan_comisiones">
					<subreportParameterExpression><![CDATA[$F{ID_PLAN_COMISIONES}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression class="java.lang.String"><![CDATA["repo:com_program_comisiones_subreport1"]]></subreportExpression>
			</subreport>
		</band>
		<band height="80" splitType="Prevent">
			<subreport>
				<reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="860" height="80" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{FECHA_TAG}.intValue() == 1]]></printWhenExpression>
				</reportElement>
				<subreportParameter name="whereIdComisiones">
					<subreportParameterExpression><![CDATA[$P{whereIdComisiones}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="vigencia">
					<subreportParameterExpression><![CDATA[$F{VIGENCIA}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="id_plan_comisiones">
					<subreportParameterExpression><![CDATA[$F{ID_PLAN_COMISIONES}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression class="java.lang.String"><![CDATA["repo:com_program_comisiones_subreport1_2021"]]></subreportExpression>
			</subreport>
		</band>
		<band height="82">
			<staticText>
				<reportElement mode="Transparent" x="0" y="0" width="860" height="20" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Observaciones Generales:]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="0" y="20" width="860" height="30" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[!$F{OBSERVACIONES}.isEmpty()]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2">
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Top" markup="none">
					<font fontName="SansSerif" size="10" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{OBSERVACIONES}]]></textFieldExpression>
			</textField>
		</band>
		<band height="80">
			<subreport>
				<reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="500" height="80"/>
				<subreportParameter name="vigencia">
					<subreportParameterExpression><![CDATA[$F{VIGENCIA}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="id_plan_comisiones">
					<subreportParameterExpression><![CDATA[$F{ID_PLAN_COMISIONES}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression class="java.lang.String"><![CDATA["repo:com_program_comisiones_subreport2"]]></subreportExpression>
			</subreport>
		</band>
	</detail>
	<columnFooter>
		<band height="9" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="12" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="740" y="0" width="89" 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}+" de "]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
				<reportElement mode="Opaque" x="830" y="0" width="30" 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>
			<staticText>
				<reportElement mode="Opaque" x="349" y="0" width="150" height="12" forecolor="#575757"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<text><![CDATA[Websafi - Control de Comisiones]]></text>
			</staticText>
		</band>
	</pageFooter>
	<summary>
		<band height="134" splitType="Stretch">
			<textField pattern="">
				<reportElement mode="Transparent" x="560" y="110" width="300" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Fecha de Creación: " + $F{MES_FECHA} +" "+ $F{DIA_FECHA} + ", " +  $F{ANHO_FECHA}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="0" y="10" width="860" height="30" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[!$F{OBSERVACIONES}.isEmpty()]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2">
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Top" markup="none">
					<font fontName="SansSerif" size="8" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["En calidad de jefe o supervisor de contrato certifico que las actividades a realizar en la comisión o gasto de desplazamiento no pueden realizarse a través de los medios virtuales y hace parte de la programación anual de comisiones o gastos de desplazamiento del Grupo, previamente costeada dentro de los viáticos y gastos de viaje asignados a la dependencia a efectos de dar cumplimiento con el artículo 86 del Decreto 2236 de 2017 – Plan de Austeridad del Gasto."]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="0" y="45" width="860" height="30" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[!$F{OBSERVACIONES}.isEmpty()]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2">
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Top" markup="none">
					<font fontName="SansSerif" size="8" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["En calidad de jefe o supervisor de contrato certifico que el lugar de destino no corresponde a una zona donde existan presuntos hechos de orden público que pongan en peligro la seguridad física de los funcionarios o contratistas."]]></textFieldExpression>
			</textField>
			<line>
				<reportElement x="0" y="5" width="860" height="1"/>
			</line>
			<textField>
				<reportElement mode="Transparent" x="0" y="110" width="350" height="12" forecolor="#000000" backcolor="#FFFFFF">
					<printWhenExpression><![CDATA[!$F{COMPLETO_SUPERVISOR}.isEmpty()]]></printWhenExpression>
				</reportElement>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["VoBo. Jefe inmediato y/o supervisor: " + $F{COMPLETO_SUPERVISOR}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Transparent" x="0" y="122" width="350" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Programador: " + $F{COMPLETO_PROGRAMADOR}]]></textFieldExpression>
			</textField>
			<textField pattern="">
				<reportElement mode="Transparent" x="560" y="122" width="300" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Fecha de Impresión: " + $F{MES_ACTUAL} +" "+ $F{DIA_ACTUAL} + ", " +  $F{ANHO_ACTUAL} + ", " + $F{HORA_ACTUAL}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="860" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
