<?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="vacaciones" language="groovy" pageWidth="652" pageHeight="610" orientation="Landscape" columnWidth="652" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
	<property name="ireport.zoom" value="1.464100000000001"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="num_doc" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="periodo" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select
vac.*,
tip.codigo,
tip.descripcion,
to_char(vac.fecha_ini,'dd/mm/yyyy') as desde,
to_char(vac.fecha_fin,'dd/mm/yyyy') as hasta

from no_novedad_vac vac

left join no_tipo_nov_vac tip
on tip.id_tipo_nov_vac = vac.id_tipo_nov_vac

where
vac.num_doc =  $P{num_doc}
and vac.id_periodo = $P{periodo}

order by
vac.num_doc,
vac.id_periodo,
tip.codigo,
vac.fecha_ini]]>
	</queryString>
	<field name="ID_NOVEDAD_VAC" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_DOC" class="java.math.BigDecimal"/>
	<field name="NUM_DOC" class="java.lang.String"/>
	<field name="ID_TIPO_NOV_VAC" class="java.math.BigDecimal"/>
	<field name="FECHA_PER_CAU" class="java.sql.Timestamp"/>
	<field name="FECHA_INI" class="java.sql.Timestamp"/>
	<field name="FECHA_FIN" class="java.sql.Timestamp"/>
	<field name="NUM_DIAS_VAC" class="java.math.BigDecimal"/>
	<field name="NUMERO_DOC" class="java.lang.String"/>
	<field name="FECHA_DOC" class="java.sql.Timestamp"/>
	<field name="OBSERVACIONES" class="java.lang.String"/>
	<field name="ID_PERIODO" class="java.math.BigDecimal"/>
	<field name="ID_CAUSA_VACAC" class="java.math.BigDecimal"/>
	<field name="CODIGO" class="java.lang.String"/>
	<field name="DESCRIPCION" class="java.lang.String"/>
	<field name="DESDE" class="java.lang.String"/>
	<field name="HASTA" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band splitType="Stretch"/>
	</title>
	<detail>
		<band height="10" splitType="Stretch">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="100" y="0" width="552" height="10"/>
				<textElement verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CODIGO} + " " + $F{DESCRIPCION} + " del " + $F{DESDE} + " a " + $F{HASTA}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" isPrintRepeatedValues="false" mode="Transparent" x="0" y="0" width="100" height="10" isPrintInFirstWholeBand="true" forecolor="#000000" backcolor="#A4CFF6"/>
				<box>
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<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>
				<text><![CDATA[Novedad de Vacaciones]]></text>
			</staticText>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
	<noData>
		<band/>
	</noData>
</jasperReport>
