var queryLimit = 4000;

  var PgAreasGUID = '';
  var PgEjesGUID = '';
  var PgLegislaturaGUID = '';
  var PgProgramaGobuiernoGUID = '';
  var OeObjetivosEstrategicosGUID = '';

  var PEAEjesGUID = '';
  var PEAObjetivosGUID = '';
  var PEAProyectosGUID  = '';

  var PDAEjesGUID = '';
  var PDAEstrategiasGUID = '';
  var PDAAccionesGUID = '';
  var PDAActuaccionesGUID = '';

  var PDAAreasGUID = '';
  var PDAConcejaliasGUID = '';
  var PDAOrganosGestoresGUID = '';

  // PROGRAMA DE GOBIERNO.
  var PGLegislaturasList = [];
  var PGAreasList = [];
  var PGAxisList = [];
  var PGList = [];

  // PEA DISENA 2020.
  var PEAProyectList = [];
  var PEAObjetivesList = [];
  var PEAEjesList = [];

  // PLAN CALIDAD.
  var PDAEjesList = [];
  var PDAEstrategiasList = [];
  var PDAAccionesList = [];
  var PDAActuacionesList = [];

  // PDA  Areas.
  var PDAAreasList = [];
  var PDAConcejaliasList = [];
  var PDAOrganosGestoresList = [];

  // GENERAL.
  var OEList = [];

	// Get List GUIDS.
	function getPGGUIDS(){
		devolverListas(["Áreas","Ejes","Legislatura","Objetivos Programa de Gobierno","OE Objetivos Estratégicos"],false,function(g){
			PgAreasGUID=g[0];
			PgEjesGUID=g[1];
			PgLegislaturaGUID=g[2];
			PgProgramaGobuiernoGUID=g[3];
			OeObjetivosEstrategicosGUID=g[4];
		});
	}

  function getDisena2020GUIDS(){
		devolverListas(["Ejes Estratégicos","Objetivos Generales","Proyectos Motores","OE Objetivos Estratégicos","Listado Actuaciones"],false,function(g){
			PEAEjesGUID=g[0];
			PEAObjetivosGUID=g[1];
			PEAProyectosGUID=g[2];
			OeObjetivosEstrategicosGUID=g[3];
			PDAActuaccionesGUID=g[4];
		});
  }

  function getPlanCalidadGUIDS(){
		devolverListas(["Ejes Plan Calidad","OE Objetivos Estratégicos","Estrategias Plan Calidad","Acciones Plan Calidad","Listado Actuaciones"],false,function(g){
			PDAEjesGUID=g[0];
			OeObjetivosEstrategicosGUID=g[1];
			PDAEstrategiasGUID=g[2];
			PDAAccionesGUID=g[3];
			PDAActuaccionesGUID=g[4];
		});
  }

  function getPDAAreasGUIDS(){
		devolverListas(["Áreas de Gobierno","Concejalías","PDA Organos Gestores","OE Objetivos Estratégicos"],false,function(g){
			PDAAreasGUID=g[0];
			PDAConcejaliasGUID=g[1];
			PDAOrganosGestoresGUID=g[2];
			OeObjetivosEstrategicosGUID=g[3];
		});
  }

  /**************************************/
  /*      PROGRAMAS DE GOBIERNO         */
  /**************************************/
  // Get Info about Legislatures.
  function getLegislaturasData(){
    // GUIDS.
    getPGGUIDS();

    // Get Data.
    PGLegislaturasList = getLegislaturas();

    // Return Data.
    return PGLegislaturasList;
  }

  // Get all Legislatures.
  function getLegislaturas(){
    var List = [];
    var Method = "GetListItems";
		var ListName = "GUIDS";
		var Fields =	"<ViewFields>" +
						      "<FieldRef Name='ID' />" +
						      "<FieldRef Name='Title' />" +
						      "</ViewFields>";
		var Query = "<Query><Where><IsNotNull><FieldRef Name='ID' /></IsNotNull></Where></Query>";
		$().SPServices({
			operation: Method,
			async: false,
			listName: PgLegislaturaGUID,
			CAMLViewFields: Fields,
			CAMLQuery: Query,
			completefunc: function(xData, Status){
				$(xData.responseXML).SPFilterNode("z:row").each(function(){
          var Record = {
            ID: parseInt($(this).attr("ows_ID")),
            Title: $(this).attr("ows_Title")
          };
					List.push(Record);
				});
			}
		});
		//console.log('Legislatures: ' + List.length);
    return List;
  }

  // Get Info about Government Programs.
  function getGovernmentProgramsData(){
    // GUIDS.
    getPGGUIDS();

    // Get Data.
    PDAActuacionesList = getPDAActuaciones();
    OEList = getOE();
    PGList = getPG();
    PGAxisList = getAxis();
    PGAreasList = getAreas();

    // Process Data.
    setOEList();
    setPG();
    setAxis();
    setAreas();

    // Return Data.
    return PGAreasList;
  }

  // Get all Strategic Objetives.
	function getOE(){
		var List = []
		var Method = "GetListItems";
		var ListName = "GUIDS";
		var Fields =	"<ViewFields>" +
						"<FieldRef Name='ID' />" +
						"<FieldRef Name='Title' />" +
						"<FieldRef Name='DescripcionObjetivoEstrategico' />" +
						"<FieldRef Name='ObjetivoActivo' />" +
						"<FieldRef Name='ValoracionObservaciones' />" +
						"<FieldRef Name='PorcentajeRealizacion' />" +
						"<FieldRef Name='ObjetivoEstado' />" +
						"<FieldRef Name='ProgramaPG' />" +
            "<FieldRef Name='Proviene_x0020_de_x0020_PEA2020' />" +
            "<FieldRef Name='OrganoGobierno' />" +
            "<FieldRef Name='ProyectoMotor' />" +
            "<FieldRef Name='AreaID' />" +
						"</ViewFields>";
		var Query = "<Query><Where><Or><IsNull><FieldRef Name='Obsoleto' /></IsNull>" +
					"<Eq><FieldRef Name='Obsoleto' /><Value Type='Boolean'>0</Value></Eq></Or></Where>" +
					"<OrderBy><FieldRef Name='Title' Ascending='True' /></OrderBy></Query>"; // No obsolete.

		$().SPServices({
			operation: Method,
			async: false,
			listName: OeObjetivosEstrategicosGUID,
			CAMLViewFields: Fields,
			CAMLQuery: Query,
			completefunc: function(xData, Status){
				$(xData.responseXML).SPFilterNode("z:row").each(function(){
					var Record = {
						ID: $(this).attr("ows_ID"),
						GovermentProgram: (($(this).attr("ows_ProgramaPG") != undefined) ? $(this).attr("ows_ProgramaPG").split(';#')[1] : ''),
						GovermentProgramID: (($(this).attr("ows_ProgramaPG") != undefined) ? parseInt($(this).attr("ows_ProgramaPG").split(';#')[0]) : 0),
						Title: $(this).attr("ows_Title"),
						Description: $(this).attr("ows_DescripcionObjetivoEstrategico"),
						Observations: $(this).attr("ows_ValoracionObservaciones"),
						Active: $(this).attr("ows_ObjetivoActivo"),
						Percentage: (($(this).attr("ows_PorcentajeRealizacion") != undefined) ? parseFloat($(this).attr("ows_PorcentajeRealizacion")) : 0),
						Status: $(this).attr("ows_ObjetivoEstado"),
            Proviene2020: (($(this).attr("ows_Proviene_x0020_de_x0020_PEA2020") != undefined) ? parseInt($(this).attr("ows_Proviene_x0020_de_x0020_PEA2020")) : 0),
            Organo: (($(this).attr("ows_OrganoGobierno") != undefined) ? $(this).attr("ows_OrganoGobierno").split(';#')[1] : ''),
            OrganoID: (($(this).attr("ows_OrganoGobierno") != undefined) ? parseInt($(this).attr("ows_OrganoGobierno").split(';#')[0]) : 0),
            ProyectoMotor: (($(this).attr("ows_ProyectoMotor") != undefined) ? $(this).attr("ows_ProyectoMotor").split(';#')[1] : ''),
            ProyectoMotorID: (($(this).attr("ows_ProyectoMotor") != undefined) ? parseInt($(this).attr("ows_ProyectoMotor").split(';#')[0]) : 0),
            AreaID: (($(this).attr("ows_AreaID") != undefined) ? $(this).attr("ows_ProyectoMotor") : ""),
            ActuationsList: []
					};
					List.push(Record);
				});
			}
		});
		//console.log('OE Total: ' + List.length);
		return List;
	}

  // Get all Strategic Objetives.
  function getOE_only2020(){
    var List = []
    var Method = "GetListItems";
    var ListName = "GUIDS";
    var Fields =	"<ViewFields>" +
            "<FieldRef Name='ID' />" +
            "<FieldRef Name='Title' />" +
            "<FieldRef Name='DescripcionObjetivoEstrategico' />" +
            "<FieldRef Name='ObjetivoActivo' />" +
            "<FieldRef Name='ValoracionObservaciones' />" +
            "<FieldRef Name='PorcentajeRealizacion' />" +
            "<FieldRef Name='ObjetivoEstado' />" +
            "<FieldRef Name='ProgramaPG' />" +
            "<FieldRef Name='Proviene_x0020_de_x0020_PEA2020' />" +
            "<FieldRef Name='ProyectoMotor' />" +
            "</ViewFields>";
    var Query = "<Query><Where><Or><IsNull><FieldRef Name='Obsoleto' /></IsNull>" +
          "<Eq><FieldRef Name='Obsoleto' /><Value Type='Boolean'>0</Value></Eq></Or></Where>" +
          "<OrderBy><FieldRef Name='Title' Ascending='True' /></OrderBy></Query>"; // No obsolete.

    $().SPServices({
      operation: Method,
      async: false,
      listName: OeObjetivosEstrategicosGUID,
      CAMLViewFields: Fields,
      CAMLQuery: Query,
      completefunc: function(xData, Status){
        $(xData.responseXML).SPFilterNode("z:row").each(function(){
          var Record = {
            ID: $(this).attr("ows_ID"),
						GovermentProgram: (($(this).attr("ows_ProgramaPG") != undefined) ? $(this).attr("ows_ProgramaPG").split(';#')[1] : ''),
						GovermentProgramID: (($(this).attr("ows_ProgramaPG") != undefined) ? parseInt($(this).attr("ows_ProgramaPG").split(';#')[0]) : 0),
						Title: $(this).attr("ows_Title"),
						Description: $(this).attr("ows_DescripcionObjetivoEstrategico"),
						Observations: $(this).attr("ows_ValoracionObservaciones"),
						Active: $(this).attr("ows_ObjetivoActivo"),
						Percentage: (($(this).attr("ows_PorcentajeRealizacion") != undefined) ? parseFloat($(this).attr("ows_PorcentajeRealizacion")) : 0),
						Status: $(this).attr("ows_ObjetivoEstado"),
            Proviene2020: (($(this).attr("ows_Proviene_x0020_de_x0020_PEA2020") != undefined) ? parseInt($(this).attr("ows_Proviene_x0020_de_x0020_PEA2020")) : 0),
            Organo: (($(this).attr("ows_OrganoGobierno") != undefined) ? $(this).attr("ows_OrganoGobierno").split(';#')[1] : ''),
            OrganoID: (($(this).attr("ows_OrganoGobierno") != undefined) ? parseInt($(this).attr("ows_OrganoGobierno").split(';#')[0]) : 0),
            ProyectoMotor: (($(this).attr("ows_ProyectoMotor") != undefined) ? $(this).attr("ows_ProyectoMotor").split(';#')[1] : ''),
            ProyectoMotorID: (($(this).attr("ows_ProyectoMotor") != undefined) ? parseInt($(this).attr("ows_ProyectoMotor").split(';#')[0]) : 0),
            ActuationsList: []
          };
          // Only2020
          if (Record.Proviene2020 == 1){
            List.push(Record);
          }
        });
      }
    });
    //console.log('OE 2020 Total: ' + List.length);
    return List;
  }

  // Get all Strategic Objetives.
	function getOEByOrganoGestor(OrganoGestorID){
    console.log('OrganoGestorID: ' + OrganoGestorID);
    getPGGUIDS();

    var List = [];
		var auxList = getOE();
    for(recordCount = 0; recordCount < auxList.length; recordCount++){
      var OERecord = auxList[recordCount];
      if (OERecord.OrganoID == OrganoGestorID){ List.push(OERecord); }
    }
    //console.log('getOEByOrganoGestor: ' + List.length);
		return List;
	}

	// Get all Programm Plans.
	function getPG(){
		var List = [];
		var Method = "GetListItems";
		var ListName = "GUIDS";
		var Fields =	"<ViewFields>" +
						"<FieldRef Name='ID' />" +
						"<FieldRef Name='Title' />" +
						"<FieldRef Name='Eje' />" +
						"<FieldRef Name='EjePGRelacionados' />" +
						"<FieldRef Name='DescripcionProgramaElectoral' />" +
						"</ViewFields>";
		var Query = "<Query><Where><Or><IsNull><FieldRef Name='Obsoleto' /></IsNull><Eq>" +
                "<FieldRef Name='Obsoleto' /><Value Type='Boolean'>0</Value></Eq></Or></Where>" +
                "<OrderBy><FieldRef Name='Title' Ascending='True' /></OrderBy></Query>"; // Only Actives.

		$().SPServices({
			operation: Method,
			async: false,
			listName: PgProgramaGobuiernoGUID,
			CAMLViewFields: Fields,
			CAMLQuery: Query,
			completefunc: function(xData, Status){
				$(xData.responseXML).SPFilterNode("z:row").each(function(){
					var Record = {
						ID: $(this).attr("ows_ID"),
						Axis: (($(this).attr("ows_Eje") != undefined) ? $(this).attr("ows_Eje").split(';#')[1] : ''),
						AxisID: (($(this).attr("ows_Eje") != undefined) ? parseInt($(this).attr("ows_Eje").split(';#')[0]) : 0),
						Title: $(this).attr("ows_Title"),
						Description: $(this).attr("ows_DescripcionProgramaElectoral"),
						ObjetivesList: [],
						Percentage: 0
					};
					List.push(Record);
				});
			}
		});
    //console.log('PG Total: ' + List.length);
		return List;
	}

  // Set PG List Data.
  function setPG(){
    for(q=0; q<PGList.length; q++){
      var Sum = 0;
      for(e=0; e<OEList.length; e++){
        // Add Objetive.
        if (PGList[q].ID == OEList[e].GovermentProgramID){
          PGList[q].ObjetivesList.push(OEList[e]);
          Sum += OEList[e].Percentage;
        }
      }
      if (Sum > 0){
        PGList[q].Percentage = parseFloat((Sum / PGList[q].ObjetivesList.length));
      }
    }
  }

  // Get All Axis.
  function getAxis(){
    var List = [];
    var Method = "GetListItems";
    var ListName = "GUIDS";
		var Fields =	"<ViewFields>" +
						"<FieldRef Name='ID' />" +
						"<FieldRef Name='Title' />" +
						"<FieldRef Name='Descripcion' />" +
						"<FieldRef Name='AreaPG' />" +
						"</ViewFields>";
    var Query = "<Query><Where><Or><IsNull><FieldRef Name='Obsoleto' /></IsNull>" +
                "<Eq><FieldRef Name='Obsoleto' /><Value Type='Boolean'>0</Value></Eq></Or></Where>" +
                "<OrderBy><FieldRef Name='Title' Ascending='True' /></OrderBy></Query>"; // Only Actives
    $().SPServices({
      operation: Method,
      async: false,
      listName: PgEjesGUID,
      CAMLViewFields: Fields,
      CAMLQuery: Query,
      completefunc: function(xData, Status){
      	$(xData.responseXML).SPFilterNode("z:row").each(function(){
      		var Record = {
      			ID: $(this).attr("ows_ID"),
      			Area: (($(this).attr("ows_AreaPG") != undefined) ? $(this).attr("ows_AreaPG").split(';#')[1] : ''),
      			AreaID: (($(this).attr("ows_AreaPG") != undefined) ? parseInt($(this).attr("ows_AreaPG").split(';#')[0]) : 0),
      			Title: $(this).attr("ows_Title"),
      			Description: $(this).attr("ows_Descripcion"),
      			GovermentProgramList: [],
      			Percentage: 0
      	   };
          List.push(Record);
          });
        }
      });
      //console.log('AXIS Total: ' + List.length);
      return List;
  }

  // Set Axis List Data
  function setAxis(){
    for(q=0; q<PGAxisList.length; q++){
      var Sum = 0;
      var Count = 0;
      for(w=0; w<PGList.length; w++){
        if (PGAxisList[q].ID == PGList[w].AxisID){
          PGAxisList[q].GovermentProgramList.push(PGList[w]);
          for(e=0; e<PGList[w].ObjetivesList.length; e++){
            Sum += PGList[w].ObjetivesList[e].Percentage;
            Count ++;
          }
        }
      }
      if (Sum > 0){
        PGAxisList[q].Percentage = parseFloat((Sum / Count));
      }
    }
  }

  // Get All Areas.
  function getAreas(){
    var List = [];
    var Method = "GetListItems";
		var ListName = "GUIDS";
		var Fields =	"<ViewFields>" +
						"<FieldRef Name='ID' />" +
						"<FieldRef Name='Title' />" +
						"<FieldRef Name='Descripcion' />" +
            "<FieldRef Name='Legislatura' />" +
						"</ViewFields>";
    var Query = "<Query><Where><Or><IsNull><FieldRef Name='Obsoleto' /></IsNull><Eq><FieldRef Name='Obsoleto' /><Value Type='Boolean'>0</Value></Eq></Or></Where></Query>";
    $().SPServices({
			operation: Method,
			async: false,
			listName: PgAreasGUID,
			CAMLViewFields: Fields,
			CAMLQuery: Query,
			completefunc: function(xData, Status){
				$(xData.responseXML).SPFilterNode("z:row").each(function(){
					var Record = {
						ID: $(this).attr("ows_ID"),
						Title: $(this).attr("ows_Title"),
						Description: $(this).attr("ows_Descripcion"),
            Legislatura: (($(this).attr("ows_Legislatura") != undefined) ? $(this).attr("ows_Legislatura").split(';#')[1] : ''),
            LegislaturaID: (($(this).attr("ows_Legislatura") != undefined) ? parseInt($(this).attr("ows_Legislatura").split(';#')[0]) : 0),
						AxisList: [],
						Percentage: 0
					};
					List.push(Record);
				});
			}
		});

    //console.log('AREAS Total: ' + List.length);
    return List;
  }

  // Set Areas List Data.
  function setAreas(){
    for(q=0; q<PGAreasList.length; q++){
      var Sum = 0;
      var Count = 0;
      for(w=0; w<PGAxisList.length; w++){
        if (PGAreasList[q].ID == PGAxisList[w].AreaID){
          PGAreasList[q].AxisList.push(PGAxisList[w]);
          for(e=0; e<PGAxisList[w].GovermentProgramList.length; e++){
            var ProgramRecord = PGAxisList[w].GovermentProgramList[e];
            for(r=0; r<ProgramRecord.ObjetivesList.length; r++){
              Sum +=ProgramRecord.ObjetivesList[r].Percentage;
              Count++;
            }
          }
        }
      }
      if (Sum > 0){
        PGAreasList[q].Percentage = parseFloat((Sum / Count));
      }
    }
  }

  /**************************************/
  /*         PEA DISENA 2020            */
  /**************************************/

  // Get Info about Disena 2020.
  function getDisena2020Data_only2020(){
    // GUIDS.
    getDisena2020GUIDS();

    // Get Data.
    PDAActuacionesList = getPDAActuaciones();
    OEList = getOE_only2020();
    PEAProyectList = getProyectosMotores();
    PEAObjetivesList = getObjetivosGenerales();
    PEAEjesList = getEjeEstrategicos();

    // Process Data.
    setOEList();
    setPEAProyectList();
    setPEAPObjetivesList();
    setPEAEjesList();

    // Return Data.
    return PEAEjesList;
  }

  function setOEList(){
    for(objetiveCount = 0; objetiveCount < OEList.length; objetiveCount++){
      for(actuationCount = 0; actuationCount < PDAActuacionesList.length; actuationCount++){
        if (OEList[objetiveCount].ID == PDAActuacionesList[actuationCount].ObjetivoID){
          OEList[objetiveCount].ActuationsList.push(PDAActuacionesList[actuationCount]);
        }
      }
    }
  }

  // Get Info about Disena 2020.
  function getDisena2020Data(){
    // GUIDS.
    getDisena2020GUIDS();

    // Get Data.
    PDAActuacionesList = getPDAActuaciones();
    OEList = getOE();
    PEAProyectList = getProyectosMotores();
    PEAObjetivesList = getObjetivosGenerales();
    PEAEjesList = getEjeEstrategicos();

    // Process Data.
    setOEList();
    setPEAProyectList();
    setPEAPObjetivesList();
    setPEAEjesList();

    // Return Data.
    return PEAEjesList;
  }

  // Get all Engine Projects
  function getProyectosMotores(){
		var List = [];
		var Method = "GetListItems";
		var Fields =	"<ViewFields>" +
						"<FieldRef Name='ID' />" +
						"<FieldRef Name='Title' />" +
						"<FieldRef Name='ObjetivoGeneral' />" +
						"<FieldRef Name='CosteProyecto' />" +
						"<FieldRef Name='InversionProyecto' />" +
						"<FieldRef Name='GastoCorrienteProyecto' />" +
						"</ViewFields>";
		var Query = "<Query><Where><Or><IsNull><FieldRef Name='Obsoleto' /></IsNull>" +
                "<Eq><FieldRef Name='Obsoleto' /><Value Type='Boolean'>0</Value></Eq></Or></Where>" +
                "<OrderBy><FieldRef Name='Title' Ascending='True' /></OrderBy></Query>"; // FILTRAR ACTIVOS.

		$().SPServices({
			operation: Method,
			async: false,
			listName: PEAProyectosGUID,
			CAMLViewFields: Fields,
			CAMLQuery: Query,
			completefunc: function(xData, Status){
				$(xData.responseXML).SPFilterNode("z:row").each(function(){
					var Record = {
						ID: $(this).attr("ows_ID"),
						Objetive: (($(this).attr("ows_ObjetivoGeneral") != undefined) ? $(this).attr("ows_ObjetivoGeneral").split(';#')[1] : ''),
						ObjetiveID: (($(this).attr("ows_ObjetivoGeneral") != undefined) ? parseInt($(this).attr("ows_ObjetivoGeneral").split(';#')[0]) : ''),
						Title: $(this).attr("ows_Title"),
						CosteProyecto: $(this).attr("ows_CosteProyecto"),
						InversionProyecto:$(this).attr("ows_InversionProyecto"),
						GastoCorrienteProyecto:$(this).attr("ows_GastoCorrienteProyecto"),
						ObjetivesList: [],
						Percentage: 0

					};
					List.push(Record);
				});
			}
		});
    //console.log('Proyectos Motores: ' + List.length);
		return List;
	}

  // Set PG List Data.
  function setPEAProyectList(){
    for(q=0; q<PEAProyectList.length; q++){
      var Sum = 0;
      for(e=0; e<OEList.length; e++){
        // Add Objetive.
        if (PEAProyectList[q].ID == OEList[e].ProyectoMotorID){
          PEAProyectList[q].ObjetivesList.push(OEList[e]);
          Sum += OEList[e].Percentage;
        }
      }
      if (Sum > 0){
        PEAProyectList[q].Percentage = parseFloat((Sum / PEAProyectList[q].ObjetivesList.length));
      }
    }
  }

  // Get all general objetives.
  function getObjetivosGenerales(){
    var List = [];
		var Method = "GetListItems";
		var Fields =	"<ViewFields>" +
						"<FieldRef Name='ID' />" +
						"<FieldRef Name='Title' />" +
						"<FieldRef Name='EjePEA' />" +
						"</ViewFields>";
		var Query = "<Query><Where><Or><IsNull><FieldRef Name='Obsoleto' /></IsNull><Eq>" +
                "<FieldRef Name='Obsoleto' /><Value Type='Boolean'>0</Value></Eq></Or></Where>" +
                "<OrderBy><FieldRef Name='Title' Ascending='True' /></OrderBy></Query>"; // FILTRAR SOLO ACTIVOS.

		$().SPServices({
			operation: Method,
			async: false,
			listName: PEAObjetivosGUID,
			CAMLViewFields: Fields,
			CAMLQuery: Query,
			completefunc: function(xData, Status){
				$(xData.responseXML).SPFilterNode("z:row").each(function(){
					var Record = {
						ID: $(this).attr("ows_ID"),
						Eje: (($(this).attr("ows_EjePEA") != undefined) ? $(this).attr("ows_EjePEA").split(';#')[1] : ''),
						EjeID: (($(this).attr("ows_EjePEA") != undefined) ? parseInt($(this).attr("ows_EjePEA").split(';#')[0]) : 0),
						Title: $(this).attr("ows_Title"),
						ProyectsList: [],
						Percentage: 0
          };
          List.push(Record);
        });
      }
    });
    //console.log('Objetivos Generales: ' + List.length);
    return List;
  }

  // Set PEA Objetives List.
  function setPEAPObjetivesList(){
    for(q=0; q<PEAObjetivesList.length; q++){
      var Sum = 0;
      var Count = 0;
      for(w=0; w<PEAProyectList.length; w++){
        if (PEAObjetivesList[q].ID == PEAProyectList[w].ObjetiveID){
          PEAObjetivesList[q].ProyectsList.push(PEAProyectList[w]);
          for(e=0; e<PEAProyectList[w].ObjetivesList.length; e++){
            Sum += PEAProyectList[w].ObjetivesList[e].Percentage;
            Count ++;
          }
        }
      }
      if (Sum > 0){
        //console.log(PEAObjetivesList[q].Title + ' Sum: ' + Sum + ' Count: ' + Count);
        PEAObjetivesList[q].Percentage = parseFloat((Sum / Count));
      }
    }
  }

  // Get all Strategic Objetives.
  function getEjeEstrategicos(){
    var List = [];
    var Method = "GetListItems";
    var Fields =	"<ViewFields>" +
            "<FieldRef Name='ID' />" +
            "<FieldRef Name='Title' />" +
            "<FieldRef Name='CosteTotal' />" +
            "<FieldRef Name='InversionTotal' />" +
            "<FieldRef Name='GastoCorrienteTotal' />" +
            "</ViewFields>";
    var Query = "<Query><Where><Or><Eq><FieldRef Name='Obsoleto' /><Value Type='Boolean'>False</Value>" +
          "</Eq><IsNull><FieldRef Name='Obsoleto' /></IsNull></Or></Where></Query>"; // FILTRAR SOLO ACTIVOS.

    $().SPServices({
      operation: Method,
      async: false,
      listName: PEAEjesGUID,
      CAMLViewFields: Fields,
      CAMLQuery: Query,
      completefunc: function(xData, Status){
        $(xData.responseXML).SPFilterNode("z:row").each(function(){
          var Record = {
            ID: $(this).attr("ows_ID"),
            Title: $(this).attr("ows_Title"),
            CostoTotal: $(this).attr("ows_CostoTotal"),
            InversionTotal: $(this).attr("ows_InversionTotal"),
            GastoCorrienteTotal: $(this).attr("ows_GastoCorrienteTotal"),
            ObjetivesList: [],
            Percentage: 0
          };
          List.push(Record);
        });
      }
    });
    //console.log('Ejes Estrategicos: ' + List.length);
    return List;
  }

  // Set PEA Ejes List.
  function setPEAEjesList(){
    for(q=0; q<PEAEjesList.length; q++){
      var Sum = 0;
      var Count = 0;
      for(w=0; w<PEAObjetivesList.length; w++){
        if (PEAEjesList[q].ID == PEAObjetivesList[w].EjeID){
          PEAEjesList[q].ObjetivesList.push(PEAObjetivesList[w]);
          for(e=0; e<PEAObjetivesList[w].ProyectsList.length; e++){
            var ProyectRecord = PEAObjetivesList[w].ProyectsList[e];
            for(r=0; r<ProyectRecord.ObjetivesList.length; r++){
              Sum +=ProyectRecord.ObjetivesList[r].Percentage;
              Count++;
            }
          }
        }
      }
      if (Sum > 0){
        //console.log(PEAEjesList[q].Title + ' Sum: ' + Sum + ' Count: ' + Count);
        PEAEjesList[q].Percentage = parseFloat((Sum / Count));
      }
    }
  }

  /**************************************/
  /*          PLAN DE CALIDAD           */
  /**************************************/
  // Get Info about PLan Calidad.
  function getPlanCalidadData(){
    // GUIDS.
    getPlanCalidadGUIDS();

    // Get Data.
    OEList = getOE();
    PDAActuacionesList = getPDAActuaciones();
    PDAAccionesList = getPDAAcciones();
    PDAEstrategiasList = getPDAEstrategias();
    PDAEjesList = getPDAEjes();

    // Process Data.
    setPDAActuacionesList();
    setPDAAccionesList();
    setPDAEstrategias();
    setPDAEjes();

    // Return Data.
    return PDAEjesList;
  }

  // Get all PDA Ejes.
  function getPDAEjes(){
    var List = [];
    var Method = "GetListItems";
    var Fields =	"<ViewFields>" +
            "<FieldRef Name='ID' />" +
            "<FieldRef Name='Title' />" +
            "</ViewFields>";
    var Query = "<Query><Where><Or><IsNull><FieldRef Name='Obsoleto' /></IsNull>" +
                "<Eq><FieldRef Name='Obsoleto' /><Value Type='Boolean'>0</Value></Eq></Or></Where>" +
                "<OrderBy><FieldRef Name='Title' Ascending='True' /></OrderBy></Query>"; // FILTRAR SOLO ACTIVOS.

    $().SPServices({
      operation: Method,
      async: false,
      listName: PDAEjesGUID,
      CAMLViewFields: Fields,
      CAMLQuery: Query,
      completefunc: function(xData, Status){
        $(xData.responseXML).SPFilterNode("z:row").each(function(){
          var Record = {
            ID: $(this).attr("ows_ID"),
            Title: $(this).attr("ows_Title"),
            StrategiesList: [],
            Percentage: 0
          };
          List.push(Record);
        });
      }
    });
    //console.log('getPeaEjes: ' + List.length);
    return List;
  }

  // Set PDA Ejes list.
  function setPDAEjes(){
    for(q=0; q<PDAEjesList.length; q++){
      var Sum = 0;
      var Count = 0;

      for(w=0; w<PDAEstrategiasList.length; w++){
        if (PDAEjesList[q].ID == PDAEstrategiasList[w].EjeID){
          PDAEjesList[q].StrategiesList.push(PDAEstrategiasList[w]);

          for(e=0; e<PDAEstrategiasList[w].AccionesList.length; e++){
            var AccionRecord = PDAEstrategiasList[w].AccionesList[e];
            for(r=0; r<AccionRecord.ActuacionesList.length; r++){
              var ActuationRecord = AccionRecord.ActuacionesList[r];
              for(t=0; t<ActuationRecord.ObjetivesList.length; t++){
                Sum += ActuationRecord.ObjetivesList[t].Percentage;
                Count++;
              }
            }
          }
        }
      }

      if (Sum > 0 && Count > 0){
        PDAEjesList[q].Percentage  = parseFloat((Sum / Count));
      }
    }
  }

  // Get all PDA Strategies.
  function getPDAEstrategias(){
    var List = [];
    var Method = "GetListItems";
    var Fields =	"<ViewFields>" +
            "<FieldRef Name='ID' />" +
            "<FieldRef Name='Title' />" +
            "<FieldRef Name='EjePDA' />" +
            "</ViewFields>";
    var Query = "<Query><Where><Or><IsNull><FieldRef Name='Obsoleto' /></IsNull>" +
                "<Eq><FieldRef Name='Obsoleto' /><Value Type='Boolean'>0</Value></Eq></Or></Where>" +
                "<OrderBy><FieldRef Name='Title' Ascending='True' /></OrderBy></Query>"; // FILTRAR SOLO ACTIVOS.

    $().SPServices({
      operation: Method,
      async: false,
      listName: PDAEstrategiasGUID,
      CAMLViewFields: Fields,
      CAMLQuery: Query,
      completefunc: function(xData, Status){
        $(xData.responseXML).SPFilterNode("z:row").each(function(){
          var Record = {
            ID: $(this).attr("ows_ID"),
            Title: $(this).attr("ows_Title"),
            Eje: (($(this).attr("ows_EjePDA") != undefined) ? $(this).attr("ows_EjePDA").split(';#')[1] : ''),
						EjeID: (($(this).attr("ows_EjePDA") != undefined) ? parseInt($(this).attr("ows_EjePDA").split(';#')[0]) : ''),
            AccionesList: [],
            Percentage: 0
          };
          List.push(Record);
        });
      }
    });
    //console.log('getPDAEstrategias: ' + List.length);
    return List;
  }

  // Set PDA Estrategias list.
  function setPDAEstrategias(){
    for(q=0; q<PDAEstrategiasList.length; q++){
      var Sum = 0;
      var Count = 0;

      for(w=0; w<PDAAccionesList.length; w++){
        if (PDAEstrategiasList[q].ID == PDAAccionesList[w].EstrategiaID){
          PDAEstrategiasList[q].AccionesList.push(PDAAccionesList[w]);

          for(e=0; e<PDAAccionesList[w].ActuacionesList.length; e++){
            var ActuacionRecord = PDAAccionesList[w].ActuacionesList[e];
            for(r=0; r<ActuacionRecord.ObjetivesList.length; r++){
              Sum += ActuacionRecord.ObjetivesList[r].Percentage;
              Count++;
            }
          }
        }
      }

      if (Sum > 0 && Count > 0){
        PDAEstrategiasList[q].Percentage = parseFloat((Sum / Count));
      }
    }
  }

  // Get all PDA Actions.
  function getPDAAcciones(){
    var List = [];
    var Method = "GetListItems";
    var Fields =	"<ViewFields>" +
            "<FieldRef Name='ID' />" +
            "<FieldRef Name='Title' />" +
            "<FieldRef Name='Estrategia' />" +
            "</ViewFields>";
    var Query = "<Query><Where><Or><IsNull><FieldRef Name='Obsoleto' /></IsNull>" +
                "<Eq><FieldRef Name='Obsoleto' /><Value Type='Boolean'>0</Value></Eq></Or></Where>" +
                "<OrderBy><FieldRef Name='Title' Ascending='True' /></OrderBy></Query>"; // FILTRAR SOLO ACTIVOS.

    $().SPServices({
      operation: Method,
      async: false,
      listName: PDAAccionesGUID,
      CAMLViewFields: Fields,
      CAMLQuery: Query,
      completefunc: function(xData, Status){
        $(xData.responseXML).SPFilterNode("z:row").each(function(){
          var Record = {
            ID: $(this).attr("ows_ID"),
            Title: $(this).attr("ows_Title"),
            Estrategia: (($(this).attr("ows_Estrategia") != undefined) ? $(this).attr("ows_Estrategia").split(';#')[1] : ''),
						EstrategiaID: (($(this).attr("ows_Estrategia") != undefined) ? parseInt($(this).attr("ows_Estrategia").split(';#')[0]) : ''),
            ActuacionesList: [],
            Percentage: 0
          };
          List.push(Record);
        });
      }
    });
    //console.log('getPDAAcciones: ' + List.length);
    return List;
  }

  // Set PDA Actions List.
  function setPDAAccionesList(){
    for(q=0; q<PDAAccionesList.length; q++){
      var Sum = 0;
      var Count = 0;

      for(w=0; w<PDAActuacionesList.length; w++){
        if (PDAAccionesList[q].ID == PDAActuacionesList[w].AccionID){
          PDAAccionesList[q].ActuacionesList.push(PDAActuacionesList[w]);
          for(e=0; e<PDAActuacionesList[w].ObjetivesList.length; e++){
            Count++;
            Sum += PDAActuacionesList[w].ObjetivesList[e].Percentage;
          }
        }
      }

      if (Sum > 0 && Count > 0){
        PDAAccionesList[q].Percentage = parseFloat((Sum / Count));
      }
    }
  }

  // Get all PDA Actuations.
  function getPDAActuaciones(){
    if (PDAActuaccionesGUID == ''){
      getDisena2020GUIDS();
    }

    var List = [];
    var Method = "GetListItems";
    var Fields =	"<ViewFields>" +
            "<FieldRef Name='ID' />" +
            "<FieldRef Name='Title' />" +
            "<FieldRef Name='AccionPlanCalidad' />" +
            "<FieldRef Name='IDObjetivoEstrategico' />" +
            "<FieldRef Name='Observaciones' />" +
            "</ViewFields>";
    var Query = "<Query></Query>"; // FILTRAR SOLO ACTIVOS.

    $().SPServices({
      operation: Method,
      async: false,
      listName: PDAActuaccionesGUID,
      CAMLViewFields: Fields,
      CAMLQuery: Query,
      completefunc: function(xData, Status){
        $(xData.responseXML).SPFilterNode("z:row").each(function(){
          var Record = {
            ID: $(this).attr("ows_ID"),
            Title: $(this).attr("ows_Title"),
            Accion: (($(this).attr("ows_AccionPlanCalidad") != undefined) ? $(this).attr("ows_AccionPlanCalidad").split(';#')[1] : ''),
						AccionID: (($(this).attr("ows_AccionPlanCalidad") != undefined) ? parseInt($(this).attr("ows_AccionPlanCalidad").split(';#')[0]) : ''),
            Objetivo: (($(this).attr("ows_IDObjetivoEstrategico") != undefined) ? $(this).attr("ows_IDObjetivoEstrategico").split(';#')[1] : ''),
						ObjetivoID: (($(this).attr("ows_IDObjetivoEstrategico") != undefined) ? parseInt($(this).attr("ows_IDObjetivoEstrategico").split(';#')[0]) : ''),
            ObjetivesList: [],
            Observations:(($(this).attr("ows_Observaciones") != undefined) ? $(this).attr("ows_Observaciones"): ''),
            Percentage: 0
          };
          List.push(Record);
        });
      }
    });
    //console.log('getPDAActuaciones: ' + List.length);
    return List;
  }

  // Set PDA Actuations List.
  function setPDAActuacionesList(){
    for(q=0; q<PDAActuacionesList.length; q++){
      var Sum = 0;
      var Count = 0;

      for(w=0; w<OEList.length; w++){
        if (OEList[w].ID == PDAActuacionesList[q].ObjetivoID){
          PDAActuacionesList[q].ObjetivesList.push(OEList[w]);
          Sum += OEList[w].Percentage
          Count++;
        }
      }

      if (Sum > 0 && Count > 0){
        PDAActuacionesList[q].Percentage = parseFloat((Sum / Count));
      }
    }
  }

  /***************************************/
  /*               PDA                   */
  /***************************************/
  function getPDAData(){
    // GUIDS.
    getPDAAreasGUIDS();

    // Get Data.
    PDAActuacionesList = getPDAActuaciones();
    OEList = getOE();
    PDAOrganosGestoresList = getPDAOrganos();
    PDAConcejaliasList = getPDAConcejalias();
    PDAAreasList = getPDAAreas();

    // Process Data.
    setOEList();
    setPDAOrganosList();
    setPDAConcejaliasList();
    setPDAAreasList();

    // Return.
    return PDAAreasList;
  }

  // Get all PDA Areas.
  function getPDAAreas(){
    var List = [];
    var Method = "GetListItems";
    var Fields =	"<ViewFields>" +
            "<FieldRef Name='ID' />" +
            "<FieldRef Name='Title' />" +
            "</ViewFields>";
    var Query = "<Query><Where><Or><IsNull><FieldRef Name='Obsoleto' /></IsNull>" +
                "<Eq><FieldRef Name='Obsoleto' /><Value Type='Boolean'>0</Value></Eq></Or></Where>" +
                "<OrderBy><FieldRef Name='Title' Ascending='True' /></OrderBy></Query>"; // FILTRAR SOLO ACTIVOS.

    $().SPServices({
      operation: Method,
      async: false,
      listName: PDAAreasGUID,
      CAMLViewFields: Fields,
      CAMLQuery: Query,
      completefunc: function(xData, Status){
        $(xData.responseXML).SPFilterNode("z:row").each(function(){
          var Record = {
            ID: $(this).attr("ows_ID"),
            Title: $(this).attr("ows_Title"),
            ConcejaliasList: [],
            Percentage: 0
          };
          List.push(Record);
        });
      }
    });
    //console.log('getPDAAreas: ' + List.length);
    return List;
  }

  // Set PDA Areas list data.
  function setPDAAreasList(){
    for(q=0; q<PDAAreasList.length; q++){
      var Sum = 0;
      var Count = 0;
      for(w=0; w<PDAConcejaliasList.length; w++){
        if (PDAAreasList[q].ID == PDAConcejaliasList[w].AreaID){
          PDAAreasList[q].ConcejaliasList.push(PDAConcejaliasList[w]);

          for(e=0; e<PDAConcejaliasList[w].OrganosList.length; e++){
            for(r=0; r<PDAConcejaliasList[w].OrganosList[e].ObjetivesList.length; r++){
              Sum += PDAConcejaliasList[w].OrganosList[e].ObjetivesList[r].Percentage;
              Count++;
            }
          }
        }
      }

      if (Sum > 0 && Count > 0){
        PDAAreasList[q].Percentage = parseFloat((Sum / Count));
      }
    }
  }

  // Get all PDA Concejalias.
  function getPDAConcejalias(){
    var List = [];
    var Method = "GetListItems";
    var Fields =	"<ViewFields>" +
            "<FieldRef Name='ID' />" +
            "<FieldRef Name='Title' />" +
            "<FieldRef Name='AreaPDA' />" +
            "</ViewFields>";
    var Query = "<Query><Where><Or><IsNull><FieldRef Name='Obsoleto' /></IsNull>" +
                "<Eq><FieldRef Name='Obsoleto' /><Value Type='Boolean'>0</Value></Eq></Or></Where>" +
                "<OrderBy><FieldRef Name='Title' Ascending='True' /></OrderBy></Query>"; // FILTRAR SOLO ACTIVOS.

    $().SPServices({
      operation: Method,
      async: false,
      listName: PDAConcejaliasGUID,
      CAMLViewFields: Fields,
      CAMLQuery: Query,
      completefunc: function(xData, Status){
        $(xData.responseXML).SPFilterNode("z:row").each(function(){
          var Record = {
            ID: $(this).attr("ows_ID"),
            Title: $(this).attr("ows_Title"),
            Area: (($(this).attr("ows_AreaPDA") != undefined) ? $(this).attr("ows_AreaPDA").split(';#')[1] : ''),
						AreaID: (($(this).attr("ows_AreaPDA") != undefined) ? parseInt($(this).attr("ows_AreaPDA").split(';#')[0]) : ''),
            OrganosList: [],
            Percentage: 0
          };
          List.push(Record);
        });
      }
    });
    //console.log('getPDAConcejalias: ' + List.length);
    return List;
  }

  // Set PDA Concelias list data.
  function setPDAConcejaliasList(){
    for(q=0; q<PDAConcejaliasList.length; q++){
      var Sum = 0;
      var Count = 0;
      for(w=0; w<PDAOrganosGestoresList.length; w++){
        if (PDAConcejaliasList[q].ID == PDAOrganosGestoresList[w].ConcejaliaID){
          PDAConcejaliasList[q].OrganosList.push(PDAOrganosGestoresList[w]);

          for(e=0; e<PDAOrganosGestoresList[w].ObjetivesList.length; e++){
            Sum += PDAOrganosGestoresList[w].ObjetivesList[e].Percentage;
            Count++;
          }
        }
      }

      if (Sum > 0 && Count > 0){
        PDAConcejaliasList[q].Percentage = parseFloat((Sum / Count));
      }
    }
  }

  // Get all PDA Organos Gestores.
  function getPDAOrganos(){
    var List = [];
    var Method = "GetListItems";
    var Fields =	"<ViewFields>" +
            "<FieldRef Name='ID' />" +
            "<FieldRef Name='Title' />" +
            "<FieldRef Name='Concejalia' />" +
            "</ViewFields>";
    var Query = "<Query><Where><Or><IsNull><FieldRef Name='Obsoleto' /></IsNull>" +
                "<Eq><FieldRef Name='Obsoleto' /><Value Type='Boolean'>0</Value></Eq></Or></Where>" +
                "<OrderBy><FieldRef Name='Title' Ascending='True' /></OrderBy></Query>"; // FILTRAR SOLO ACTIVOS.

    $().SPServices({
      operation: Method,
      async: false,
      listName: PDAOrganosGestoresGUID,
      CAMLViewFields: Fields,
      CAMLQuery: Query,
      completefunc: function(xData, Status){
        $(xData.responseXML).SPFilterNode("z:row").each(function(){
          var Record = {
            ID: $(this).attr("ows_ID"),
            Title: $(this).attr("ows_Title"),
            Concejalia: (($(this).attr("ows_Concejalia") != undefined) ? $(this).attr("ows_Concejalia").split(';#')[1] : ''),
            ConcejaliaID: (($(this).attr("ows_Concejalia") != undefined) ? parseInt($(this).attr("ows_Concejalia").split(';#')[0]) : ''),
            ObjetivesList: [],
            Percentage: 0
          };
          List.push(Record);
        });
      }
    });
    //console.log('getPDAOrganos: ' + List.length);
    return List;
  }

  // Set PDA Organos list data.
  function setPDAOrganosList(){
    for(q=0; q<PDAOrganosGestoresList.length; q++){
      var Sum = 0;
      var Count = 0;
      for(w=0; w<OEList.length; w++){
        if (PDAOrganosGestoresList[q].ID == OEList[w].OrganoID){
          PDAOrganosGestoresList[q].ObjetivesList.push(OEList[w]);
          Sum += OEList[w].Percentage;
          Count++
        }
      }

      if (Sum > 0 && Count > 0){
        PDAOrganosGestoresList[q].Percentage = parseFloat((Sum / Count));
      }
    }
  }
  /********************************************************/
  /*               FUNCIONES AUXILIARES                   */
  /********************************************************/
  function stringStartsWith (string, prefix) {
		return string.slice(0, prefix.length) == prefix;
	}
	function stringEndsWith(str, suffix) {
		return str.match(suffix+"$")==suffix;
	}