<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.8.0.final using JasperReports Library version 6.8.0-2ed8dfabb690ff337a5797129f2cd92902b0c87b  -->
<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="Colaboradores_sin_asignacion" language="groovy" pageWidth="792" pageHeight="612" orientation="Landscape" columnWidth="572" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="4eedbb89-b4f6-4469-9ab6-f642a1688cf7">
	<property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="true"/>
	<property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns" value="true"/>
	<property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>
	<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="Inceptio"/>
	<property name="com.jaspersoft.studio.unit." value="pixel"/>
	<property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>
	<style name="Title" forecolor="#FFFFFF" fontName="Times New Roman" fontSize="50" isBold="false" pdfFontName="Times-Bold"/>
	<style name="SubTitle" forecolor="#CCCCCC" fontName="Times New Roman" fontSize="18" isBold="false" pdfFontName="Times-Roman"/>
	<style name="Column header" forecolor="#666666" fontName="Times New Roman" fontSize="14" isBold="true"/>
	<style name="Detail" mode="Transparent" fontName="Times New Roman"/>
	<style name="Row" mode="Transparent" fontName="Times New Roman" pdfFontName="Times-Roman">
		<conditionalStyle>
			<conditionExpression><![CDATA[$V{REPORT_COUNT}%2 == 0]]></conditionExpression>
			<style mode="Opaque" backcolor="#EEEFF0"/>
		</conditionalStyle>
	</style>
	<style name="Table">
		<box>
			<pen lineWidth="1.0" lineColor="#000000"/>
			<topPen lineWidth="1.0" lineColor="#000000"/>
			<leftPen lineWidth="1.0" lineColor="#000000"/>
			<bottomPen lineWidth="1.0" lineColor="#000000"/>
			<rightPen lineWidth="1.0" lineColor="#000000"/>
		</box>
	</style>
	<style name="Table_TH" mode="Opaque" backcolor="#FFFFFF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
			<topPen lineWidth="0.5" lineColor="#000000"/>
			<leftPen lineWidth="0.5" lineColor="#000000"/>
			<bottomPen lineWidth="0.5" lineColor="#000000"/>
			<rightPen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="Table_CH" mode="Opaque" backcolor="#CACED0">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
			<topPen lineWidth="0.5" lineColor="#000000"/>
			<leftPen lineWidth="0.5" lineColor="#000000"/>
			<bottomPen lineWidth="0.5" lineColor="#000000"/>
			<rightPen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="Table_TD" mode="Opaque" backcolor="#FFFFFF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
			<topPen lineWidth="0.5" lineColor="#000000"/>
			<leftPen lineWidth="0.5" lineColor="#000000"/>
			<bottomPen lineWidth="0.5" lineColor="#000000"/>
			<rightPen lineWidth="0.5" lineColor="#000000"/>
		</box>
		<conditionalStyle>
			<conditionExpression><![CDATA[$V{REPORT_COUNT}%2 == 0]]></conditionExpression>
			<style backcolor="#D8D8D8"/>
		</conditionalStyle>
	</style>
	<style name="Table 1_TH" mode="Opaque" backcolor="#F0F8FF">
		<box>
			<topPen lineWidth="0.5" lineColor="#000000"/>
			<bottomPen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="Table 1_CH" mode="Opaque" backcolor="#BFE1FF">
		<box>
			<topPen lineWidth="0.5" lineColor="#000000"/>
			<bottomPen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="Table 1_TD" mode="Opaque" backcolor="#FFFFFF">
		<box>
			<topPen lineWidth="0.5" lineColor="#000000"/>
			<bottomPen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<subDataset name="DBTabla" uuid="a627b162-fe22-4d03-b0e9-bd15f7b1d18f">
		<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
		<property name="com.jaspersoft.studio.data.defaultdataadapter" value="Inceptio"/>
		<parameter name="PuestoId" class="java.lang.Integer"/>
		<queryString language="SQL">
			<![CDATA[SELECT c.Nomina, c.Nombre, c.ApellidoPaterno, c.ApellidoMaterno, c.FechaNacimiento, c.RFC, c.CURP, c.TelefonoCelular, c.EmailPersonal  FROM e3_colaborador c
inner JOIN e3_puestoporcolaborador ep ON c.ColaboradorId = ep.ColaboradorId 
WHERE c.EstatusColaboradorId = 1 AND ep.Activo = 1 AND ep.PuestoId =  $P{PuestoId}]]>
		</queryString>
		<field name="Nomina" class="java.lang.String">
			<property name="com.jaspersoft.studio.field.label" value="Nomina"/>
			<property name="com.jaspersoft.studio.field.tree.path" value="e3_colaborador"/>
		</field>
		<field name="Nombre" class="java.lang.String">
			<property name="com.jaspersoft.studio.field.label" value="Nombre"/>
			<property name="com.jaspersoft.studio.field.tree.path" value="e3_colaborador"/>
		</field>
		<field name="ApellidoPaterno" class="java.lang.String">
			<property name="com.jaspersoft.studio.field.label" value="ApellidoPaterno"/>
			<property name="com.jaspersoft.studio.field.tree.path" value="e3_colaborador"/>
		</field>
		<field name="ApellidoMaterno" class="java.lang.String">
			<property name="com.jaspersoft.studio.field.label" value="ApellidoMaterno"/>
			<property name="com.jaspersoft.studio.field.tree.path" value="e3_colaborador"/>
		</field>
		<field name="FechaNacimiento" class="java.sql.Date">
			<property name="com.jaspersoft.studio.field.label" value="FechaNacimiento"/>
			<property name="com.jaspersoft.studio.field.tree.path" value="e3_colaborador"/>
		</field>
		<field name="RFC" class="java.lang.String">
			<property name="com.jaspersoft.studio.field.label" value="RFC"/>
			<property name="com.jaspersoft.studio.field.tree.path" value="e3_colaborador"/>
		</field>
		<field name="CURP" class="java.lang.String">
			<property name="com.jaspersoft.studio.field.label" value="CURP"/>
			<property name="com.jaspersoft.studio.field.tree.path" value="e3_colaborador"/>
		</field>
		<field name="TelefonoCelular" class="java.lang.String">
			<property name="com.jaspersoft.studio.field.label" value="TelefonoCelular"/>
			<property name="com.jaspersoft.studio.field.tree.path" value="e3_colaborador"/>
		</field>
		<field name="EmailPersonal" class="java.lang.String">
			<property name="com.jaspersoft.studio.field.label" value="EmailPersonal"/>
			<property name="com.jaspersoft.studio.field.tree.path" value="e3_colaborador"/>
		</field>
		<variable name="colaboradoresTabla" class="java.lang.Boolean" resetType="None">
			<variableExpression><![CDATA[$F{Nomina}.length() > 0]]></variableExpression>
		</variable>
	</subDataset>
	<parameter name="logo" class="java.lang.String" isForPrompting="false">
		<parameterDescription><![CDATA[Ruta de la imagen]]></parameterDescription>
		<defaultValueExpression><![CDATA["D:/Inceptio/E360/Servicios/src/JasperFiles/Img/logo.png"]]></defaultValueExpression>
	</parameter>
	<queryString language="SQL">
		<![CDATA[SELECT 
ed.Nombre Departamento, ep.PuestoId, ep.Nombre Puesto, ep1.Nombre Puestosuperior
FROM e3_puesto ep
INNER JOIN e3_departamento ed ON ep.DepartamentoId = ed.DepartamentoId
LEFT JOIN e3_puesto ep1 ON ep.PuestoSuperiorId = ep1.PuestoId
WHERE ep.Activo = 1 and ed.Activo = 1
ORDER BY ed.DepartamentoId, ep1.PuestoId, ep.PuestoId]]>
	</queryString>
	<field name="Departamento" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="Departamento"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_departamento"/>
	</field>
	<field name="PuestoId" class="java.lang.Integer">
		<property name="com.jaspersoft.studio.field.label" value="PuestoId"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_puesto"/>
	</field>
	<field name="Puesto" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="Puesto"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_puesto"/>
	</field>
	<field name="Puestosuperior" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="Puestosuperior"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_puesto"/>
	</field>
	<variable name="colaboradores" class="java.lang.Boolean" resetType="None"/>
	<title>
		<band height="82" splitType="Stretch">
			<line>
				<reportElement x="0" y="67" width="750" height="1" uuid="806ce5df-1219-4876-ae0c-ca7405b1f246">
					<property name="local_mesure_unitheight" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
			</line>
			<image hAlign="Center">
				<reportElement x="0" y="0" width="65" height="60" uuid="94883631-a913-43e2-b182-ab8d77d0181e"/>
				<imageExpression><![CDATA[$P{logo}]]></imageExpression>
			</image>
			<staticText>
				<reportElement x="95" y="0" width="535" height="60" uuid="e622555d-198b-4ccd-a4a1-c59c53304058">
					<property name="local_mesure_unitheight" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Center">
					<font size="19" isBold="true"/>
				</textElement>
				<text><![CDATA[Lista de puestos con sus colaboradores]]></text>
			</staticText>
		</band>
	</title>
	<detail>
		<band height="20">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="240" height="20" forecolor="#000000" uuid="1e1745b3-46ef-4267-aa1d-270d3c283115"/>
				<textElement verticalAlignment="Middle">
					<font size="14" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Departamento}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="458" y="0" width="140" height="20" forecolor="#000000" uuid="296520a0-e29d-4217-b6e9-d2a65d673e28"/>
				<textElement verticalAlignment="Middle">
					<font size="14" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Puestosuperior}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="240" y="0" width="218" height="20" forecolor="#000000" uuid="899c80fe-ef27-4325-b4e5-cad42b35d690"/>
				<textElement verticalAlignment="Middle">
					<font size="14" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Puesto}]]></textFieldExpression>
			</textField>
		</band>
		<band height="18">
			<componentElement>
				<reportElement x="0" y="0" width="752" height="18" uuid="9bcfc19e-8968-40a7-b023-937b42988055">
					<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/>
					<property name="com.jaspersoft.studio.table.style.table_header" value="Table 1_TH"/>
					<property name="com.jaspersoft.studio.table.style.column_header" value="Table 1_CH"/>
					<property name="com.jaspersoft.studio.table.style.detail" value="Table 1_TD"/>
				</reportElement>
				<jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">
					<datasetRun subDataset="DBTabla" uuid="3901c05e-1e70-478c-b39e-1db7227cd080">
						<datasetParameter name="PuestoId">
							<datasetParameterExpression><![CDATA[$F{PuestoId}]]></datasetParameterExpression>
						</datasetParameter>
						<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
						<returnValue fromVariable="colaboradoresTabla" toVariable="colaboradores"/>
					</datasetRun>
					<jr:column width="49" uuid="530cf4ad-226e-46a4-b6a1-a4f7541d2dee">
						<jr:tableHeader style="Table 1_TH" height="20">
							<staticText>
								<reportElement x="0" y="0" width="49" height="20" uuid="ee79791a-b31d-4e8e-b3d8-e45061494fac"/>
								<textElement verticalAlignment="Middle"/>
								<text><![CDATA[Nómina]]></text>
							</staticText>
						</jr:tableHeader>
						<jr:detailCell style="Table 1_TD" height="20">
							<textField isStretchWithOverflow="true" isBlankWhenNull="true">
								<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="49" height="20" uuid="074557f9-e748-4433-8473-718f6da3754e"/>
								<textFieldExpression><![CDATA[$F{Nomina}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="84" uuid="96960ea0-b7ec-491e-a959-36792252ed33">
						<jr:tableHeader style="Table 1_TH" height="20">
							<staticText>
								<reportElement x="0" y="0" width="84" height="20" uuid="680f7697-0988-472c-9fd3-46e6e2cb4e36"/>
								<textElement verticalAlignment="Middle"/>
								<text><![CDATA[Nombre]]></text>
							</staticText>
						</jr:tableHeader>
						<jr:detailCell style="Table 1_TD" height="20">
							<textField isStretchWithOverflow="true" isBlankWhenNull="true">
								<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="84" height="20" uuid="86152737-f6c7-4b93-aa2a-023b4699ed7f"/>
								<textFieldExpression><![CDATA[$F{Nombre}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="87" uuid="6415a642-4211-450f-9f5d-4f04c114fd7b">
						<jr:tableHeader style="Table 1_TH" height="20">
							<staticText>
								<reportElement x="0" y="0" width="87" height="20" uuid="b1257b5f-4ee5-4f1b-95c3-ae053ff511be"/>
								<textElement verticalAlignment="Middle"/>
								<text><![CDATA[Ap. paterno]]></text>
							</staticText>
						</jr:tableHeader>
						<jr:detailCell style="Table 1_TD" height="20">
							<textField isStretchWithOverflow="true" isBlankWhenNull="true">
								<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="87" height="20" uuid="2b8adfa2-13f7-4b2f-a9af-2cc99fef9091"/>
								<textFieldExpression><![CDATA[$F{ApellidoPaterno}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="89" uuid="c8a23d45-0196-4e03-aa5e-46c386741702">
						<jr:tableHeader style="Table 1_TH" height="20">
							<staticText>
								<reportElement x="0" y="0" width="89" height="20" uuid="3b6dd25e-654c-400d-8d2e-210b62dfbeb8"/>
								<textElement verticalAlignment="Middle"/>
								<text><![CDATA[Ap. materno]]></text>
							</staticText>
						</jr:tableHeader>
						<jr:detailCell style="Table 1_TD" height="20">
							<textField isStretchWithOverflow="true" isBlankWhenNull="true">
								<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="89" height="20" uuid="893ace9f-ed70-400a-b7b9-77012bacaff2"/>
								<textFieldExpression><![CDATA[$F{ApellidoMaterno}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="71" uuid="b985b702-4c2f-4720-9d1f-c3e784236ce6">
						<jr:tableHeader style="Table 1_TH" height="20">
							<staticText>
								<reportElement x="0" y="0" width="71" height="20" uuid="b1728966-9fe4-4b7a-b64c-e723588fc795"/>
								<textElement verticalAlignment="Middle"/>
								<text><![CDATA[Fe. nacimiento]]></text>
							</staticText>
						</jr:tableHeader>
						<jr:detailCell style="Table 1_TD" height="20">
							<textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true">
								<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="71" height="20" uuid="5c509abc-268c-4ea1-b922-d583a42bd453"/>
								<textFieldExpression><![CDATA[$F{FechaNacimiento}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="83" uuid="bdd0154f-5a44-4d93-b69b-ed8688b7b7ac">
						<jr:tableHeader style="Table 1_TH" height="20">
							<staticText>
								<reportElement x="0" y="0" width="83" height="20" uuid="467280c4-bced-4079-b078-590e3ecc5d33"/>
								<textElement verticalAlignment="Middle"/>
								<text><![CDATA[RFC]]></text>
							</staticText>
						</jr:tableHeader>
						<jr:detailCell style="Table 1_TD" height="20">
							<textField isStretchWithOverflow="true" isBlankWhenNull="true">
								<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="83" height="20" uuid="db0593af-f1d6-4b84-88f6-a73ff43ac232"/>
								<textFieldExpression><![CDATA[$F{RFC}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="97" uuid="373f8171-4acc-4d2f-8603-8c40cc88fd3a">
						<jr:tableHeader style="Table 1_TH" height="20">
							<staticText>
								<reportElement x="0" y="0" width="97" height="20" uuid="44b9c0d2-2722-4e19-89e2-da435ab5bdbd"/>
								<textElement verticalAlignment="Middle"/>
								<text><![CDATA[CURP]]></text>
							</staticText>
						</jr:tableHeader>
						<jr:detailCell style="Table 1_TD" height="20">
							<textField isStretchWithOverflow="true" isBlankWhenNull="true">
								<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="97" height="20" uuid="0ce65825-d3ee-42eb-baad-725abcd96cc0"/>
								<textFieldExpression><![CDATA[$F{CURP}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="84" uuid="27d85cc1-d2d7-44dd-be9a-16d7ba0d65c5">
						<jr:tableHeader style="Table 1_TH" height="20">
							<staticText>
								<reportElement x="0" y="0" width="84" height="20" uuid="a1e317dc-9d84-422b-9696-a8ec520b1785"/>
								<textElement verticalAlignment="Middle"/>
								<text><![CDATA[Celular]]></text>
							</staticText>
						</jr:tableHeader>
						<jr:detailCell style="Table 1_TD" height="20">
							<textField isStretchWithOverflow="true" isBlankWhenNull="true">
								<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="84" height="20" uuid="41942c7d-364c-4f09-8a34-866498c36991"/>
								<textFieldExpression><![CDATA[$F{TelefonoCelular}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="84" uuid="c7109ab1-7f2d-4828-9bb4-9e705792ea22">
						<jr:tableHeader style="Table 1_TH" height="20">
							<staticText>
								<reportElement x="0" y="0" width="84" height="20" uuid="1110dcb3-6df1-4c05-abc3-a6da9eb313f4"/>
								<textElement verticalAlignment="Middle"/>
								<text><![CDATA[Correo personal]]></text>
							</staticText>
						</jr:tableHeader>
						<jr:detailCell style="Table 1_TD" height="20">
							<textField isStretchWithOverflow="true" isBlankWhenNull="true">
								<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="84" height="20" uuid="15549bf5-fc63-40af-9f7a-8fceb86e936f"/>
								<textFieldExpression><![CDATA[$F{EmailPersonal}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
				</jr:table>
			</componentElement>
		</band>
		<band height="20">
			<textField evaluationTime="Band" isBlankWhenNull="false">
				<reportElement style="Column header" x="240" y="0" width="218" height="20" forecolor="#FA0905" uuid="331d753f-f2ba-4243-9a01-9dba40bc432b">
					<printWhenExpression><![CDATA[IF($V{colaboradores} == null, true, false)]]></printWhenExpression>
				</reportElement>
				<textElement verticalAlignment="Middle">
					<font fontName="SansSerif" size="14" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[IF($V{colaboradores} == null, "Vacante", null)]]></textFieldExpression>
			</textField>
		</band>
	</detail>
</jasperReport>
