<?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="Reporte_Acuerdo" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="b3214a1e-af2a-4c3f-b2bd-dd82c0acbdad">
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="Inceptio"/>
	<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
	<property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w1" value="118"/>
	<property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w2" value="877"/>
	<parameter name="asignacionacuerdoid" class="java.lang.Integer"/>
	<parameter name="Imagensubordinado" class="java.lang.String"/>
	<parameter name="Imagenjefe" class="java.lang.String"/>
	<parameter name="nombreinstituto" class="java.lang.String"/>
	<parameter name="ImagenEscuela" class="java.lang.String"/>
	<queryString>
		<![CDATA[SELECT Concat_WS(' ', cs.ApellidoPaterno, cs.ApellidoMaterno, cs.Nombre) nombresubordinado, Concat_WS(' ', cj.ApellidoPaterno, cj.ApellidoMaterno, cj.Nombre) nombrejefe, ps.Nombre Puestosub, ds.Nombre Departamentosub, per.Descripcion periodoevaluacion, ci.Nombre Ciclo, ns.Nombre Nivel,
aaf.FirmaSubordinado, aaf.FirmaJefe, 
  CASE WHEN LOCATE('font-family: &quot;Berlin Sans FB&quot;, sans-serif;', aaf.TextoAcuerdo) > 0 THEN REPLACE(aaf.TextoAcuerdo, 'font-family: &quot;Berlin Sans FB&quot;, sans-serif;', 'font-family: SansSerif;')
    WHEN LOCATE('font-family: &quot;Calibri Light&quot;, sans-serif;', aaf.TextoAcuerdo) > 0 THEN REPLACE(aaf.TextoAcuerdo,'font-family: &quot;Calibri Light&quot;, sans-serif;','font-family: SansSerif;')
    WHEN LOCATE('font-family: &quot;Century Gothic&quot;, sans-serif;', aaf.TextoAcuerdo) > 0 THEN REPLACE(aaf.TextoAcuerdo,'font-family: &quot;Century Gothic&quot;, sans-serif;','font-family: SansSerif;')
    WHEN LOCATE('font-family: &quot;Lucida Sans&quot;, sans-serif;', aaf.TextoAcuerdo) > 0 THEN REPLACE(aaf.TextoAcuerdo,'font-family: &quot;Lucida Sans&quot;, sans-serif;','font-family: SansSerif;')
    WHEN LOCATE('font-family: Aptos;', aaf.TextoAcuerdo) > 0 THEN REPLACE(aaf.TextoAcuerdo,'font-family: Aptos;','font-family: SansSerif;')
    WHEN LOCATE('font-family: Arial, Helvetica, sans-serif;', aaf.TextoAcuerdo) > 0 THEN REPLACE(aaf.TextoAcuerdo,'font-family: Arial, Helvetica, sans-serif;','font-family: SansSerif;')
    WHEN LOCATE('font-family: Arial, sans-serif;', aaf.TextoAcuerdo) > 0 THEN REPLACE(aaf.TextoAcuerdo,'font-family: Arial, sans-serif;','font-family: SansSerif;')
    WHEN LOCATE('font-family: Arial;', aaf.TextoAcuerdo) > 0 THEN REPLACE(aaf.TextoAcuerdo,'font-family: Arial;','font-family: SansSerif;')
    WHEN LOCATE('font-family: Calibri, sans-serif;', aaf.TextoAcuerdo) > 0 THEN REPLACE(aaf.TextoAcuerdo,'font-family: Calibri, sans-serif;','font-family: SansSerif;')
    WHEN LOCATE('font-family: Calibri;', aaf.TextoAcuerdo) > 0 THEN REPLACE(aaf.TextoAcuerdo,'font-family: Calibri;','font-family: SansSerif;')
    WHEN LOCATE('font-family: Comfortaa, cursive;', aaf.TextoAcuerdo) > 0 THEN REPLACE(aaf.TextoAcuerdo,'font-family: Comfortaa, cursive;','font-family: SansSerif;')
    WHEN LOCATE('font-family: SansSerif;', aaf.TextoAcuerdo) > 0 THEN REPLACE(aaf.TextoAcuerdo,'font-family: SansSerif;','font-family: SansSerif;')
    WHEN LOCATE('font-family: Tahoma, sans-serif;', aaf.TextoAcuerdo) > 0 THEN REPLACE(aaf.TextoAcuerdo,'font-family: Tahoma, sans-serif;','font-family: SansSerif;')
    WHEN LOCATE('font-family: Montserrat, sans-serif;', aaf.TextoAcuerdo) > 0 THEN REPLACE(aaf.TextoAcuerdo,'font-family: Montserrat, sans-serif;','font-family: SansSerif;')
  ELSE aaf.TextoAcuerdo END TextoAcuerdo
, aaf.Firmado, aaf.FechaFirmaSubordinado, aaf.FechaFirmaJefe, aaf.FechaTermino, pj.Nombre Puestojefe, dj.nombre Departamentojefe
FROM e3_asignacionacuerdo aa
INNER JOIN e3_colaborador cs ON aa.ColaboradorSubordinadoId = cs.ColaboradorId
INNER JOIN e3_puesto ps ON aa.PuestoSubordinadoId = ps.PuestoId
INNER JOIN e3_departamento ds ON ps.DepartamentoId = ds.DepartamentoId
LEFT JOIN nivel ns ON ds.NivelId = ns.NivelId
INNER JOIN e3_colaborador cj ON aa.ColaboradorJefeId = cj.ColaboradorId
INNER JOIN e3_puesto pj ON aa.PuestoJefeId = pj.PuestoId
INNER JOIN e3_departamento dj ON pj.DepartamentoId = dj.DepartamentoId
INNER JOIN e3_asignacionacuerdofirma aaf ON aa.AsignacionAcuerdoFirmaId = aaf.AsignacionAcuerdoFirmaId
INNER JOIN e3_periodoevaluacion per ON aa.PeriodoEvaluacionId = per.PeriodoEvaluacionId
INNER JOIN ciclo ci ON per.CicloId = ci.CicloId
WHERE aa.AsignacionAcuerdoId =  $P{asignacionacuerdoid}]]>
	</queryString>
	<field name="nombresubordinado" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="nombresubordinado"/>
	</field>
	<field name="nombrejefe" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="nombrejefe"/>
	</field>
	<field name="Puestosub" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="Puestosub"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_puesto"/>
	</field>
	<field name="Departamentosub" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="Departamentosub"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_departamento"/>
	</field>
	<field name="periodoevaluacion" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="periodoevaluacion"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_periodoevaluacion"/>
	</field>
	<field name="Ciclo" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="Ciclo"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="ciclo"/>
	</field>
	<field name="Nivel" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="Nivel"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="nivel"/>
	</field>
	<field name="FirmaSubordinado" class="java.lang.Boolean">
		<property name="com.jaspersoft.studio.field.label" value="FirmaSubordinado"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_asignacionacuerdofirma"/>
	</field>
	<field name="FirmaJefe" class="java.lang.Boolean">
		<property name="com.jaspersoft.studio.field.label" value="FirmaJefe"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_asignacionacuerdofirma"/>
	</field>
	<field name="TextoAcuerdo" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="TextoAcuerdo"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_asignacionacuerdofirma"/>
	</field>
	<field name="Firmado" class="java.lang.Boolean">
		<property name="com.jaspersoft.studio.field.label" value="Firmado"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_asignacionacuerdofirma"/>
	</field>
	<field name="FechaFirmaSubordinado" class="java.sql.Timestamp">
		<property name="com.jaspersoft.studio.field.label" value="FechaFirmaSubordinado"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_asignacionacuerdofirma"/>
	</field>
	<field name="FechaFirmaJefe" class="java.sql.Timestamp">
		<property name="com.jaspersoft.studio.field.label" value="FechaFirmaJefe"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_asignacionacuerdofirma"/>
	</field>
	<field name="FechaTermino" class="java.sql.Timestamp">
		<property name="com.jaspersoft.studio.field.label" value="FechaTermino"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_asignacionacuerdofirma"/>
	</field>
	<field name="Puestojefe" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="Puestojefe"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_puesto"/>
	</field>
	<field name="Departamentojefe" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="Departamentojefe"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_departamento"/>
	</field>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="299">
			<staticText>
				<reportElement x="0" y="10" width="280" height="30" uuid="71955b44-b471-4f63-a100-a15f65dbb44a"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="SansSerif" size="10"/>
				</textElement>
				<text><![CDATA[Sistema de evaluación 360]]></text>
			</staticText>
			<staticText>
				<reportElement x="15" y="155" width="130" height="20" uuid="c4f7c021-e8a2-4329-9ae2-8bf18109884f"/>
				<text><![CDATA[Evaluado]]></text>
			</staticText>
			<image onErrorType="Blank">
				<reportElement x="204" y="150" width="70" height="67" uuid="c4e1f221-4f13-419a-afbc-cade42b6a123"/>
				<imageExpression><![CDATA[$P{Imagensubordinado}]]></imageExpression>
			</image>
			<rectangle>
				<reportElement mode="Transparent" x="300" y="144" width="270" height="135" uuid="f615b13f-4955-4943-a3e4-4c5322ec3e8b"/>
			</rectangle>
			<staticText>
				<reportElement x="0" y="60" width="280" height="30" uuid="5cfb79f8-8fed-494b-9aef-100d07b59ba2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="SansSerif" size="10"/>
				</textElement>
				<text><![CDATA[Acuerdo de la evaluación]]></text>
			</staticText>
			<textField>
				<reportElement x="0" y="105" width="264" height="30" uuid="78f36f7e-9458-4bcf-9f3e-1b1fa7cd2670"/>
				<textFieldExpression><![CDATA["Periodo: "+$F{periodoevaluacion}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="289" y="105" width="258" height="30" uuid="e559c1ac-9798-4f0b-aff7-b75ad3251a6b"/>
				<textFieldExpression><![CDATA["Ciclo: "+$F{Ciclo}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="15" y="177" width="44" height="20" uuid="5316aabe-0af2-4965-b721-c856e48d3ec8"/>
				<text><![CDATA[Nombre:]]></text>
			</staticText>
			<staticText>
				<reportElement x="15" y="205" width="34" height="20" uuid="0e51398c-96c0-48c7-9dcb-4204fceb61c2"/>
				<text><![CDATA[Nivel:]]></text>
			</staticText>
			<staticText>
				<reportElement x="15" y="225" width="74" height="20" uuid="5cd6d1c7-f539-4a60-a131-93787a05faba"/>
				<text><![CDATA[Departamento:]]></text>
			</staticText>
			<textField isStretchWithOverflow="true">
				<reportElement x="59" y="177" width="130" height="28" uuid="34489588-60c2-4495-8124-0a61706e6c36"/>
				<textElement>
					<font size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{nombresubordinado}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement x="49" y="205" width="130" height="20" uuid="63d5262e-2b4e-447b-8546-93dd3adcd74f"/>
				<textElement>
					<font size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{Nivel} == null)? "":$F{Nivel}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="15" y="249" width="34" height="20" uuid="4bbb03b9-0f9a-4128-a141-54d5687fe62e"/>
				<text><![CDATA[Puesto:]]></text>
			</staticText>
			<textField isStretchWithOverflow="true">
				<reportElement x="90" y="225" width="130" height="24" uuid="ef34e006-deba-4b9d-8fe9-e5acfc1c34e8"/>
				<textElement>
					<font size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Departamentosub}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement x="50" y="249" width="130" height="20" uuid="503a27cd-14b9-47f8-862e-96a55481ae9e"/>
				<textElement>
					<font size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Puestosub}]]></textFieldExpression>
			</textField>
			<rectangle>
				<reportElement mode="Transparent" x="0" y="144" width="274" height="135" uuid="b143f2dd-31f1-4795-ad9d-9250ef66f289"/>
			</rectangle>
			<staticText>
				<reportElement x="305" y="155" width="130" height="20" uuid="f84248f5-e367-4f71-a66c-db2f50ab62b7"/>
				<text><![CDATA[Jefe]]></text>
			</staticText>
			<image onErrorType="Blank">
				<reportElement x="500" y="149" width="69" height="69" uuid="8fea9299-12ad-432c-957a-dd693d8e3fa9"/>
				<imageExpression><![CDATA[$P{Imagenjefe}]]></imageExpression>
			</image>
			<staticText>
				<reportElement x="305" y="177" width="44" height="20" uuid="4761258c-55a0-46d8-ac39-68d09482ba8b"/>
				<text><![CDATA[Nombre:]]></text>
			</staticText>
			<staticText>
				<reportElement x="305" y="205" width="34" height="20" uuid="3bf151e9-630c-49cb-918c-49937d1de8e5"/>
				<text><![CDATA[Nivel:]]></text>
			</staticText>
			<staticText>
				<reportElement x="305" y="227" width="74" height="20" uuid="cb88d1b2-1707-4e2b-acb3-7c6b5c632383"/>
				<text><![CDATA[Departamento:]]></text>
			</staticText>
			<textField isStretchWithOverflow="true">
				<reportElement x="340" y="205" width="130" height="20" uuid="02dfb1fa-b7bf-4862-bb19-5d429b9572b1"/>
				<textElement>
					<font size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[($F{Nivel} == null)? "":$F{Nivel}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="305" y="249" width="34" height="20" uuid="5cf9305c-d2b0-4dd7-862d-afe7010fc104"/>
				<text><![CDATA[Puesto:]]></text>
			</staticText>
			<textField isStretchWithOverflow="true">
				<reportElement x="349" y="177" width="130" height="28" uuid="6d4f75bd-a9e9-4aed-8e25-1708911effcd"/>
				<textElement>
					<font size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{nombrejefe}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement x="340" y="249" width="130" height="20" uuid="19e319df-8a7c-4f3a-aac7-05b1ccb0e5f7"/>
				<textElement>
					<font fontName="SansSerif" size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Puestojefe}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement x="380" y="227" width="130" height="20" uuid="33fdb73b-57c8-4732-a24b-05f6f58bb60d"/>
				<textElement>
					<font size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Departamentojefe}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="40" width="204" height="20" uuid="79636967-7a23-49a1-96d2-5bcb3ef88118"/>
				<textElement>
					<font fontName="SansSerif" size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{nombreinstituto}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<detail>
		<band height="203" splitType="Stretch">
			<textField isStretchWithOverflow="true">
				<reportElement x="0" y="70" width="554" height="120" uuid="b2f9c4b1-9231-419d-839e-57368dcc3ec1"/>
				<textElement markup="html">
					<font fontName="SansSerif" size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{TextoAcuerdo}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="10" width="554" height="30" uuid="ac28fdb8-12cb-401d-a3c3-082a21fbf9c2"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="10"/>
				</textElement>
				<text><![CDATA[Acta de acuerdo y compromiso]]></text>
			</staticText>
			<textField pattern="MMM d, yyyy h:mm:ss a">
				<reportElement x="454" y="40" width="100" height="30" uuid="efe786b5-2b39-42f1-8694-6f220bdbeefe"/>
				<textElement>
					<font size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{FechaTermino}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<pageFooter>
		<band height="48">
			<textField>
				<reportElement x="180" y="10" width="100" height="30" uuid="049bef54-1f37-48fe-8279-85b74f316827"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA["Page " + $V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report">
				<reportElement x="280" y="10" width="100" height="30" uuid="43789e72-5e32-48c7-ac55-0e2f7b112380"/>
				<textElement textAlignment="Left"/>
				<textFieldExpression><![CDATA[" / " + $V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<lastPageFooter>
		<band height="172">
			<textField isStretchWithOverflow="true">
				<reportElement x="0" y="18" width="204" height="20" uuid="93d9afd1-7a32-4ffc-b8cf-5ad7b4f45c82"/>
				<textElement textAlignment="Left" verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{nombresubordinado}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement x="0" y="38" width="204" height="20" uuid="3a67d5a8-5f00-4b8a-993e-6405ca89851a"/>
				<textElement textAlignment="Left" verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{Puestosub}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="58" width="204" height="20" uuid="a9dd4f02-eef2-4fa2-a024-c9f8f6294385"/>
				<textElement textAlignment="Left" verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA["Firmado"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement x="350" y="18" width="204" height="20" uuid="747cfae5-96ce-4512-a90c-3b49d72cf678"/>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{nombrejefe}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement x="350" y="38" width="204" height="20" uuid="f126e8e9-919a-4c81-afe9-a7d206baeec3"/>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{Puestojefe}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="350" y="58" width="204" height="20" uuid="56d00018-54a6-4d8b-a539-9f5306c674f9"/>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA["Firmado"]]></textFieldExpression>
			</textField>
			<textField pattern="MMM d, yyyy h:mm:ss a">
				<reportElement x="0" y="78" width="204" height="20" uuid="ee1e19ea-e37d-44b1-a236-152f4e2d5dc5"/>
				<textFieldExpression><![CDATA[$F{FechaFirmaSubordinado}]]></textFieldExpression>
			</textField>
			<textField pattern="MMM d, yyyy h:mm:ss a">
				<reportElement x="350" y="78" width="204" height="20" uuid="959bc204-c611-4c0d-a807-d7bc886001cc"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$F{FechaFirmaJefe}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="179" y="137" width="100" height="30" uuid="ebea888f-bd95-4d6f-8528-6e21b7f6104a"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA["Page " + $V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report">
				<reportElement x="279" y="137" width="100" height="30" uuid="9b756e35-2f90-4f56-a959-1a1a15cce841"/>
				<textElement textAlignment="Left"/>
				<textFieldExpression><![CDATA[" / " + $V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
		</band>
	</lastPageFooter>
</jasperReport>
