RESTORE_FE/js/advanced_search.js

const choiceArray = [
	["Nome risorsa", "Object, OA", "label"],
	["Identificatore", "Object, OA, Person, Letter, Place", "identifier"], 
	["Materia", "Object, OA", "material"],
	["Istituto di conservazione", "Object, OA", "localization"],
	["Tecnica", "OA", "technique"],
	["Artista", "OA", "artist"],
	["Soggetto", "OA", "subject"],
	["Titolo", "Object, Inf", "title"],
	["Tipo di risorsa", "Object, Inf", "type"],
	["Nome proprio", "Person", "givenName"],
	["Nome di famiglia", "Person", "familyName"],
	["Luogo di Nascita", "Person", "birthPlace"],
	["Luogo di Morte", "Person", "deathPlace"],
	["Genere", "Person", "sex"],
	["Data di Nascita", "Person", "birthDate"],
	["Data di Morte", "Person", "deathDate"],
	["Occupazione", "Person", "occupation"],
	["Qualifica", "Person", "qualification"],
	["Mittente", "Letter", "sender"],
	["Destinatario", "Letter", "receiver"],
	["Luogo di Partenza", "Letter", "startPlace"],
	["Luogo di Arrivo", "Letter", "endPlace"],
	["Data partenza", "Letter", "startDate"],
	["Data arrivo", "Letter", "endDate"],
	["Lingua", "Letter", "language"],
	["Area linguistica", "Letter", "languageArea"],
	["Edizione", "Letter", "edition"],
	["Data", "Object", "date"],
	["Lemma", "Letter", "lemma"],
	["Testo libero", "Letter", "keyword"]
	];

const typeArray = [
	["Oggetto", "Object"], 
	["Lettera", "Letter"],
	["Opera d'Arte", "OA"],
	["Persona", "Person"]
	];

const graphArray = [
	["ASPO - Datini", "http://dev.restore.ovi.cnr.it:8890/aspo/datini", "Object"], 
	["ASPO - Ospedale", "http://dev.restore.ovi.cnr.it:8890/aspo/ospedale", "Object"],
	["ASPO - Marcovaldi", "http://dev.restore.ovi.cnr.it:8890/aspo/marcovaldi", "Object"],
	["ASPO - Onomastica Gettatelli", "http://dev.restore.ovi.cnr.it:8890/aspo/gettatelli", "Person"],
	["ASPO - Onomastica Datini", "http://dev.restore.ovi.cnr.it:8890/aspo/onomastica", "Person"],
	["MPP - Artisti", "http://dev.restore.ovi.cnr.it:8890/mpp/autori", "Person"],
	["MPP - Collezione Martini", "http://dev.restore.ovi.cnr.it:8890/mpp/martini", "Artwork"],
	["MPP - Collezione Ospedale", "http://dev.restore.ovi.cnr.it:8890/mpp/ospedale", "Artwork"],
	["MPP - Collezione Datini", "http://dev.restore.ovi.cnr.it:8890/mpp/datini", "Artwork"],
	["OVI - Lettere", "http://dev.restore.ovi.cnr.it:8890/ovi/datini", "Letter"]
	];

const objectArray = [];
const personArray = [];
const placeArray = [];
const oaArray = [];
const letterArray = [];

$(document).ready(function () {
	//#######################################

	var type_selector = document.getElementById("type_selector");
	var collection_selector = document.getElementById("collection_selector");

	let x = typeArray.length;

	for(var i=0; i<x; i++) {
		   var opt = document.createElement("option");
		   opt.value= typeArray[i][1];
		   opt.innerHTML = typeArray[i][0]; // whatever property it has

		   // then append it to the select element
		   type_selector.add(opt);
		}


	let z = choiceArray.length;

	for(var i=0; i<z; i++) {
			var cat = choiceArray[i][1];
			if (cat.includes("Object")) {
				objectArray.push(choiceArray[i]);
			}
			if (cat.includes("OA")) {
				oaArray.push(choiceArray[i]);
			}
			if (cat.includes("Person")) {
				personArray.push(choiceArray[i]);
			}
			if (cat.includes("Letter")) {
				letterArray.push(choiceArray[i]);
			}
			if (cat.includes("Place")) {
				placeArray.push(choiceArray[i]);
			}
		}

	$("#type_selector").change(function(){
		var selOpt = "";
        $(this).find("option:selected").each(function(){
            var optionValue = $(this).attr("value");
			selOpt = optionValue;
            if(optionValue){
                $(".box").not("." + optionValue).hide();
                $("." + optionValue).show();
            } else{
                $(".box").hide();
            }
        });
		$( ".container_choice" ).remove();
		if (selOpt == "Object") {
			addToListObject();
			populateSelGraph("Object");
		}
		else if (selOpt == "OA") {
			addToListOA();
			populateSelGraph("Artwork");
		}
		else if (selOpt == "Person") {
			addToListPerson();
			populateSelGraph("Person");
		}
		else if (selOpt == "Letter") {
			addToListLetter();
			populateSelGraph("Letter");
		}
		else {
			addToList();
			populateSelGraph("General");
		} 
    }).change();

    /*$('[name=sel-parent]').on('change', function() {
	   $(this).attr("id", 'example' + $(this).name());
	});*/

});


function populateOptions(selector, myArray) {

	var choice_selector = document.getElementById(selector);

	let k = myArray.length;

	for(var i=0; i<k; i++) {
		   var opt = document.createElement("option");
		   opt.value= myArray[i][1];
		   opt.innerHTML = myArray[i][0]; // whatever property it has

		   // then append it to the select element
		   choice_selector.add(opt);
		}

	$('#' + selector).on( "change", function() {
		var numberId= selector.split("-")[1];
		var inputText=  $( this ).find(":selected").text();
		var inp = "";
		if (inputText == "Genere") {
			inp = '<select class="advanced-form-select form-control" id="inputchoiceSelector_'+ numberId +'"> \
			<option>F</option> \
			<option>M</option> \
			</select>';
		} else if (inputText == "Materia"){
			inp = '<select class="advanced-form-select form-control" id="inputchoiceSelector_'+ numberId +'"> \
			<option>Pittura a tempera</option> \
			<option>Tavola</option> \
			<option>Stucco</option> \
			<option>Rame</option> \
			<option>Carta</option> \
			<option>Tela</option> \
			</select>';
		} else if (inputText == "Tecnica"){
			inp = '<select class="advanced-form-select form-control" id="inputchoiceSelector_'+ numberId +'"> \
			<option>Pittura</option> \
			<option>Doratura</option> \
			</select>';
		} else if (inputText == "Tipo di risorsa"){
			inp = '<select class="advanced-form-select form-control" id="inputchoiceSelector_'+ numberId +'"> \
			<option>Documento</option> \
			<option>Carteggio</option> \
			<option>Lettera</option> \
			<option>Libro</option> \
			<option>Documenti diversi</option> \
			</select>';
		} else if (inputText == "Data") {
			var inp = '<div id="box_' + numberId + 'a" class="container_choice"><div class="choice_box"><select id ="choice_selector-' + numberId + '_a" value=' + numberId + '_a" name="sel-parent" class="advanced-form-select form-control" aria-label="Default select example"> \
			  <option selected value="0">Da</option> \
			  <input type="date" id="inputchoiceSelector_'+ numberId +'_a" name="start" value="1300-01-01"> \
			</select></div></div> \
			<div id="box_' + numberId + '_b" class="container_choice"><div class="choice_box"><select id ="choice_selector-' + numberId + '_b" value=' + numberId + '_b" name="sel-parent" class="advanced-form-select form-control" aria-label="Default select example"> \
			  <option selected value="0">A</option> \
			  <input type="date" id="inputchoiceSelector_'+ numberId +'_b" name="end" value="1300-12-31"> \
			</select></div></div>';
		} 
		else {
			inp = '<input type="text" id="inputchoiceSelector_'+ numberId +'" class="selected_option form-control" placeholder="Enter search terms" aria-label="Enter search terms" aria-describedby="button-addon2">';
		
		}
		var sect = 'sect-' + String(numberId);
		var inDiv = document.getElementById(sect);
		inDiv.innerHTML = inp;
		console.log(selector);
		
		
		/*$('#inputchoiceSelector_' +  numberId).val(inputText);
		$('#inputchoiceSelector_' +  numberId).id(inputText);*/
	});
}



var val = 0;

function addToList() {
	val = val+1;
	var sel = '<div id="box_' + val + '" class="container_choice"><div class="remove"><a onclick="removeElement(\'box_' + val + '\')"><i class="fa fa-trash" aria-hidden="true"></i></a></div><div class="choice_box"><select id ="choice_selector-' + val + '" value=' + val + ' name="sel-parent" class="advanced-form-select form-control" aria-label="Default select example"> \
			  <option selected value="0">Scegli un\'opzione</option> \
			</select><div id="sect-' + val + '"></div></div></div>';
	$('#drop-down-content').append(sel);
	var selector = 'choice_selector-' + val;
	populateOptions(selector, choiceArray);
}

function addToListObject() {
	val = val+100;
	var sel = '<div id="box_' + val + '" class="container_choice"><div class="remove"><a onclick="removeElement(\'box_' + val + '\')"><i class="fa fa-trash" aria-hidden="true"></i></a></div><div class="choice_box"><select id ="choice_selector-' + val + '" value=' + val + ' name="sel-parent" class="advanced-form-select form-control" aria-label="Default select example"> \
			  <option selected value="0">Scegli un\'opzione</option> \
			  </select><div id="sect-' + val + '"></div></div></div>';
	$('#drop-down-content-Object').append(sel);
	var selector = 'choice_selector-' + val;
	populateOptions(selector, objectArray);
}

function addToListOA() {
	val = val+200;
	var sel = '<div id="box_' + val + '" class="container_choice"><div class="remove"><a onclick="removeElement(\'box_' + val + '\')"><i class="fa fa-trash" aria-hidden="true"></i></a></div><div class="choice_box"><select id ="choice_selector-' + val + '" value=' + val + ' name="sel-parent" class="advanced-form-select form-control" aria-label="Default select example"> \
			  <option selected value="0">Scegli un\'opzione</option> \
			  </select><div id="sect-' + val + '"></div></div></div>';
	$('#drop-down-content-OA').append(sel);
	var selector = 'choice_selector-' + val;
	populateOptions(selector, oaArray);
}

function addToListPerson() {
	val = val+300;
	var sel = '<div id="box_' + val + '" class="container_choice"><div class="remove"><a onclick="removeElement(\'box_' + val + '\')"><i class="fa fa-trash" aria-hidden="true"></i></a></div><div class="choice_box"><select id ="choice_selector-' + val + '" value=' + val + ' name="sel-parent" class="advanced-form-select form-control" aria-label="Default select example"> \
			  <option selected value="0">Scegli un\'opzione</option> \
			  </select><div id="sect-' + val + '"></div></div></div>';
	$('#drop-down-content-Person').append(sel);
	var selector = 'choice_selector-' + val;
	populateOptions(selector, personArray);
}

function addToListLetter() {
	val = val+400;
	var sel = '<div id="box_' + val + '" class="container_choice"><div class="remove"><a onclick="removeElement(\'box_' + val + '\')"><i class="fa fa-trash" aria-hidden="true"></i></a></div><div class="choice_box"><select id ="choice_selector-' + val + '" value=' + val + ' name="sel-parent" class="advanced-form-select form-control" aria-label="Default select example"> \
			  <option selected value="0">Scegli un\'opzione</option> \
			  </select><div id="sect-' + val + '"></div></div></div>';
	$('#drop-down-content-Letter').append(sel);
	var selector = 'choice_selector-' + val;
	populateOptions(selector, letterArray);
}

function addToListPlace() {
	val = val+500;
	var sel = '<div id="box_' + val + '" class="container_choice"><div class="remove"><a onclick="removeElement(\'box_' + val + '\')"><i class="fa fa-trash" aria-hidden="true"></i></a></div><div class="choice_box"><select id ="choice_selector-' + val + '" value=' + val + ' name="sel-parent" class="advanced-form-select form-control" aria-label="Default select example"> \
			  <option selected value="0">Scegli un\'opzione</option> \
			  <input type="text" id="inputchoiceSelector_'+ val +'" class="selected_option form-control" placeholder="Enter search terms" aria-label="Enter search terms" aria-describedby="button-addon2"> \
			</select></div></div>';
	$('#drop-down-content-Place').append(sel);
	var selector = 'choice_selector-' + val;
	populateOptions(selector, placeArray);
}


//Get parameters from select and input options to build the query
function getParameters() {
	var cc = document.getElementById("type_selector").value;
	if (cc != "General") {
		const arr = [];
		const collection = document.getElementsByClassName("advanced-form-select");
		for (let i = 0; i < collection.length; i++) {
			var x = collection[i].id;
			var t = document.getElementById(x);
			var e = t.options[t.selectedIndex].text;
			var numberId= x.split("-")[1]
			var inputId = "inputchoiceSelector_" + numberId;
			if (!!document.getElementById(inputId)) {
				var inputText = document.getElementById(inputId).value;
				var el = [e, inputText];
				console.log([inputText, el]);
				arr.push(el);
			}
			
		}
		constructQuery(arr); 
	}
	else {
		alert("Seleziona una categoria")
	}
	/*$('#query_results').append(arr);
	testo = $('input#writeText').val();*/
}

function removeElement(id_element) {
  const element = document.getElementById(id_element);

  element.remove();
}


//Build query with harvested parametes
function constructQuery(params) {

	var g = document.getElementById("collection_selector");
	var graph = g.value;

	var search_graph = "?g";

	if (graph != "") {
		search_graph = '<' + graph + '>';
	} 

	var search_type = "";

	var ct = document.getElementById("type_selector");
	var choosen_type = ct.value;

	console.log(choosen_type);

	var search_identifier = "";

	if (choosen_type == "Object") {
		search_type = "?subject rdf:type crm:E22_Man-Made_Object . ";
		search_identifier = "?subject crm:P1_is_identified_by ?uri_identifier . \
		?uri_identifier rdfs:label ?identifier ; \
		crm:P2_has_type 'Segnatura' .";
	}
	if (choosen_type == "Letter") {
		search_type = "?subject crm:P128_carries ?information_object . \
		?information_object crm:P2_has_type ?uri_letter . \
		?uri_letter rdfs:label 'lettera' ."
		search_identifier = "?subject crm:P1_is_identified_by ?uri_identifier . \
		?uri_identifier rdfs:label ?identifier ; \
		crm:P2_has_type 'Segnatura' .";
	}
	if (choosen_type == "OA") {
		search_identifier = "?subject crm:P1_is_identified_by ?uri_identifier . \
		?uri_identifier rdfs:label ?identifier ; \
		crm:P2_has_type 'Codice univoco del bene (NCT)' .";
	}
	if (choosen_type == "Person") {
		search_type = "?subject rdf:type crm:E21_Person . ";
		search_identifier = "?subject crm:P1_is_identified_by ?uri_identifier . \
		?uri_identifier rdfs:label ?identifier .";
	}

	var label = ""; //
	var identificatore = ""; //
	var dimensione = ""; //
	var materia = ""; //
	var localizzazione = ""; //
	var tecnica = ""; //
	var artista = ""; //
	var soggetto = ""; //
	var titolo = ""; //
	var tipo = ""; //
	var note = ""; //
	var riferimenti = ""; //
	var nome_proprio = ""; //
	var nome_di_famiglia = ""; //
	var patronimico = ""; //
	var luogo_di_Nascita = ""; //
	var luogo_di_Morte = ""; //
	var genere = ""; //
	var data_di_Nascita = ""; //
	var data_di_Morte = ""; //
	var occupazione = ""; //
	var qualifica = ""; //
	var gruppi_di_appartenenza = ""; //
	var mittente = ""; //
	var destinatario = ""; //
	var luogo_di_Partenza = ""; //
	var luogo_di_Arrivo = ""; //
	var data_partenza = ""; //
	var data_arrivo = ""; //
	var lingua = ""; //
	var area_linguistica = ""; //
	var edizione = ""; //
	var lemma = ""; //
	var testo = ""; //
	var data = ""; //
	var letter_event = ""; //
	var infObj = ""; //

	var id = ""; //
	var dm = ""; //
	var mt = ""; //
	var locl = ""; //
	var tec = ""; //
	var at = ""; //
	var sg = ""; //
	var tt = ""; //
	var tp = ""; //
	var nt = ""; //
	var rf = ""; //
	var np = ""; //
	var nf = ""; //
	var pt = ""; //
	var ln = ""; //
	var lm = ""; //
	var gr = ""; //
	var dn = ""; //
	var dts = ""; //
	var oc = ""; //
	var qf = ""; //
	var ga = ""; //
	var mit = ""; //
	var des = ""; //
	var lp = ""; //
	var la = ""; //
	var dp = ""; //
	var da = ""; //
	var lin = ""; //
	var alin = ""; //
	var ed = ""; //
	var lem = ""; //
	var ttx = ""; //
	var dt = ""; //

	for (let i = 0; i < params.length; i++) {
		if(params[i][0] == "Nome risorsa" && (params[i][1] != "")) {
			label = "?label bif:contains \"\' "+ params[i][1] + " \'\" . ";
		}
		if(params[i][0] == "Identificatore" && (params[i][1] != "")) {
			id = " ?identifier";

			identificatore = "FILTER (CONTAINS(?identifier, \'"+ params[i][1] +"\'))";
		}
		if(params[i][0] == "Dimensione" && (params[i][1] != "")) {
			dm = " ?dimension";

			dimensione = "?subject crm:P43_has_dimension ?uri_dimension . \
			?uri_dimension rdfs:label ?dimension . \
			?dimension bif:contains \"\'"+ params[i][1] +"\'\" ."
		}
		if(params[i][0] == "Materia" && (params[i][1] != "")) {
			mt = " ?material";

			materia = "?subject crm:P45_consists_of ?uri_material . \
			?uri_material rdfs:label ?material . \
			?material bif:contains \"\'"+ params[i][1] +"\'\" ."
		}
		if(params[i][0] == "Istituto di conservazione" && (params[i][1] != "")) {
			locl = " ?location";

			localizzazione = "?subject crm:P52_has_current_owner ?uri_location . \
			?uri_location rdfs:label ?location . \
			?location bif:contains \"\'"+ params[i][1] +"\'\" ."
		}
		if(params[i][0] == "Tecnica" && (params[i][1] != "")) {
			tec = " ?technique";

			tecnica = "?event ?pp ?subject . \
			?event crm:P32_used_general_technique ?uri_technique . \
			?uri_technique rdfs:label ?technique . \
			?technique bif:contains \"\'"+ params[i][1] +"\'\" . "
		}
		if (params[i][0] == "Artista" && (params[i][1] != "")) {
			at = " ?artist";

			artista = "?subject rdfs:label ?label .	\
			?production crm:P108_has_produced ?subject . \
			?pc crm:P01_has_domain ?production . \
			?pc crm:P02_has_range ?range . \
			?range rdfs:label ?artist . \
			?artist bif:contains \"\'"+ params[i][1] +"\'\" ."
		}
		if (params[i][0] == "Soggetto" && (params[i][1] != "")) {
			sg = " ?depiction";

			soggetto = "?subject crm:P62_depicts ?uri_depiction . \
			?uri_depiction rdfs:label ?depiction . \
			?depiction bif:contains \"\'"+ params[i][1] +"\'\" ."
		}
		if (params[i][0] == "Titolo" && (params[i][1] != "")) {
			tt = " ?title";

			infObj = "?subject crm:P128_carries ?information_object .";

			titolo = "?information_object crm:P1_is_identified_by ?uri_title . \
			?uri_title rdfs:label ?title . \
			?title bif:contains \"\'"+ params[i][1] +"\'\" ."
		}
		if (params[i][0] == "Tipo di risorsa" && (params[i][1] != "")) {
			tp = " ?type";

			infObj = "?subject crm:P128_carries ?information_object .";

			tipo = "?information_object crm:P2_has_type ?uri_type . \
			?uri_type rdfs:label ?type . \
			?type bif:contains \"\'"+ params[i][1] +"\'\" ."
		}
		if (params[i][0] == "Note" && (params[i][1] != "")) {
			nt = " ?note";

			note = "?subject crm:P3_has_note ?uri_note . \
			?uri_note rdfs:label ?note . \
			?note bif:contains \"\'"+ params[i][1] +"\'\" .";
		}
		if (params[i][0] == "Riferimenti" && (params[i][1] != "")) {
			rf = " ?ref";

			riferimenti = "?subject crm:P67_refers_to ?uri_ref . \
			?uri_ref rdfs:label ?ref . \
			?ref bif:contains \"\'"+ params[i][1] +"\'\" . "
		}
		if (params[i][0] == "Nome proprio" && (params[i][1] != "")) {
			np = " ?givenName";

			nome_proprio = "?subject foaf:givenName ?givenName . \
			?givenName bif:contains \"\'"+ params[i][1] +"\'\" . "
		}
		if (params[i][0] == "Nome di famiglia" && (params[i][1] != "")) {
			nf = " ?familyName";

			nome_di_famiglia = "?subject foaf:familyName ?familyName . \
			?familyName bif:contains \"\'"+ params[i][1] +"\'\" . "
		}
		if (params[i][0] == "Patronimico" && (params[i][1] != "")) {
			pt = " ?patronymic";

			patronimico = "?subject person:patronymicName ?patronymic . \
			?patronymic bif:contains \"\'"+ params[i][1] +"\'\" . "
		}
		if (params[i][0] == "Luogo di Nascita" && (params[i][1] != "")) {
			ln = " ?birthPlace";

			luogo_di_Nascita = "?subject crm:P98i_was_born ?Birth . \
			?Birth crm:P7_took_place_at ?uri_birthPlace . \
			?uri_birthPlace rdfs:label ?birthPlace . \
			?birthPlace bif:contains \""+ params[i][1] +"\" . "
		}
		if (params[i][0] == "Luogo di Morte" && (params[i][1] != "")) {
			lm = " ?deathPlace";

			luogo_di_Morte = "?subject crm:P100i_died_in ?Death . \
			?Death crm:P7_took_place_at ?uri_deathPlace . \
			?uri_deathPlace rdfs:label ?deathPlace \
			?deathPlace bif:contains \""+ params[i][1] +"\" .	"
		}
		if (params[i][0] == "Genere" && (params[i][1] != "")) {
			gr = "?genere";

			genere = "?subject foaf:gender ?genere . \
			?genere bif:contains \""+ params[i][1] +"\" . "
		}
		if (params[i][0] == "Data di Nascita" && (params[i][1] != "")) {
			dn = " ?Birth_TS";

			data_di_Nascita = "?subject crm:P98i_was_born ?Birth . 	\
			?Birth crm:P4_has_time-span ?Birth_TS . \
			?Birth_TS rdfs:label \""+ params[i][1] +"\" ."
		}
		if (params[i][0] == "Data di Morte" && (params[i][1] != "")) {
			dts = " ?Death_TS";

			data_di_Morte = "?subject crm:P100i_died_in ?Death . \
			?Death crm:P4_has_time-span ?Death_TS . \
			?Death_TS rdfs:label \""+ params[i][1] +"\" . "
		}
		if (params[i][0] == "Qualifica" && (params[i][1] != "")) {
			qf = " ?qualification";

			qualifica = "?subject schema:honorificPrefix ?qualification . \
			?qualification bif:contains \"\'"+ params[i][1] +"\'\" . "
		}
		if (params[i][0] == "Occupazione" && (params[i][1] != "")) {
			oc = " ?occupation";

			occupazione = "?subject schema:hasOccupation ?uriOccupation . \
			?uriOccupation rdf:type schema:Occupation; \
			rdfs:label ?occupation . \
			?occupation bif:contains \"\'"+ params[i][1] +"\'\" . "
		}
		if (params[i][0] == "Gruppi di appartenenza" && (params[i][1] != "")) {
			ga = " ?group";

			gruppi_di_appartenenza = "?subject crm:P107i_is_current_or_former_member_of ?uriGroup . \
			?uriGroup rdfs:label ?group . \
			?group bif:contains \"\'"+ params[i][1] +"\'\" . "
		}
		if (params[i][0] == "Mittente" && (params[i][1] != "")) {
			mit = " ?mittente";

			letter_event = "?subject crm:P25i_moved_by ?mov_ev . \
			?send rdfs:subClassOf ?mov_ev ; \
			rdf:type crm:EL2_Send_Letter . \
			?receive rdfs:subClassOf ?mov_ev; \
			rdf:type crm:EL3_Receive_Letter . ";

			mittente = "?send crm:P01_has_domain ?pcS . \
			?pcS crm:P02_has_range ?uriSender . \
			?uriSender rdfs:label ?mittente . \
			?mittente bif:contains \"\'"+ params[i][1] +"\'\" .	 "
		}
		if (params[i][0] == "Destinatario" && (params[i][1] != "")) {
			des = " ?destinatario";

			letter_event = "?subject crm:P25i_moved_by ?mov_ev . \
			?send rdfs:subClassOf ?mov_ev ; \
			rdf:type crm:EL2_Send_Letter . \
			?receive rdfs:subClassOf ?mov_ev; \
			rdf:type crm:EL3_Receive_Letter . ";

			destinatario = "?receive crm:P01_has_domain ?pcR . \
			?pcR crm:P02_has_range ?uriReceiver . \
			?uriReceiver rdfs:label ?destinatario . \
			?destinatario bif:contains \"\'"+ params[i][1] +"\'\" .	"
		}
		if (params[i][0] == "Luogo di Partenza" && (params[i][1] != "")) {
			lp = " ?luogo_partenza";

			letter_event = "?subject crm:P25i_moved_by ?mov_ev . \
			?send rdfs:subClassOf ?mov_ev ; \
			rdf:type crm:EL2_Send_Letter . \
			?receive rdfs:subClassOf ?mov_ev; \
			rdf:type crm:EL3_Receive_Letter . ";

			luogo_di_Partenza = "?send crm:P27_moved_from ?uriLuogoPartenza . \
			?uriLuogoPartenza rdfs:label ?luogo_partenza . \
			?luogo_partenza bif:contains \"\'"+ params[i][1] +"\'\" . "
		}
		if (params[i][0] == "Luogo di Arrivo" && (params[i][1] != "")) {
			la = " ?luogo_arrivo";

			letter_event = "?subject crm:P25i_moved_by ?mov_ev . \
			?send rdfs:subClassOf ?mov_ev ; \
			rdf:type crm:EL2_Send_Letter . \
			?receive rdfs:subClassOf ?mov_ev; \
			rdf:type crm:EL3_Receive_Letter . ";

			luogo_di_Arrivo = "?receive crm:P26_moved_to ?uriLuogoArrivo . \
			?uriLuogoArrivo rdfs:label ?luogo_arrivo . \
			?luogo_arrivo bif:contains \"\'"+ params[i][1] +"\'\" . "
		}
		if (params[i][0] == "Data partenza" && (params[i][1] != "")) {
			dp = " ?timeSpanSend";

			letter_event = "?subject crm:P25i_moved_by ?mov_ev . \
			?send rdfs:subClassOf ?mov_ev ; \
			rdf:type crm:EL2_Send_Letter . \
			?receive rdfs:subClassOf ?mov_ev; \
			rdf:type crm:EL3_Receive_Letter . ";

			data_partenza = "?send crm:P4_has_time-span ?time_spanS . \
			?time_spanS rdfs:label ?timeSpanSend . \
			?timeSpanSend bif:contains \"\'"+ params[i][1] +"\'\" . "
		}
		if (params[i][0] == "Data arrivo" && (params[i][1] != "")) {
			da = " ?timeSpanReceive";

			letter_event = "?subject crm:P25i_moved_by ?mov_ev . \
			?send rdfs:subClassOf ?mov_ev ; \
			rdf:type crm:EL2_Send_Letter . \
			?receive rdfs:subClassOf ?mov_ev; \
			rdf:type crm:EL3_Receive_Letter . ";

			data_arrivo = "?receive crm:P4_has_time-span ?time_spanR . \
			?time_spanR rdfs:label ?timeSpanReceive .\
			?timeSpanReceive bif:contains \"\'"+ params[i][1] +"\'\" . "
		}
		if (params[i][0] == "Lingua" && (params[i][1] != "")) {
			lin = " ?lingua";

			lingua = "?information_object crm:P72_has_language ?language . \
			?language rdfs:label ?lingua . \
			?lingua bif:contains \"\'"+ params[i][1] +"\'\" ."
		}
		if (params[i][0] == "Area linguistica" && (params[i][1] != "")) {
			alin = " ?area_linguistica";

			area_linguistica = "?information_object crm:P72_has_language ?language . \
			?language crm:P3_has_note ?area . \
			?area rdfs:label ?area_linguistica .\
			?area_linguistica bif:contains \"\'"+ params[i][1] +"\'\" ."
		}
		if (params[i][0] == "Edizione" && (params[i][1] != "")) {
			ed = " ?edizione";

			edizione = "?edition crm:P70_documents ?information_object ; \
			crm:P1_is_identified_by ?edition_id . \
			?edition_id rdfs:label ?edizione . \
			?edizione bif:contains \"\'"+ params[i][1] +"\'\" ."
		}
		if (params[i][0] == "Lemma" && (params[i][1] != "")) {
			lem = " ?lemma";

			lemma = "?information_object crm:P67_refers_to ?link_lemma . \
			?link_lemma rdfs:label ?lemma. \
			?lemma bif:contains \"\'"+ params[i][1] +"\'\" ."
		}
		if (params[i][0] == "Testo libero" && (params[i][1] != "")) {
			ttx = " ?testo";

			testo = "?information_object crm:P190_has_symbolic_content ?testo . \
			?testo bif:contains \"\'"+ params[i][1] +"\'\" ."
		}
		if (params[i][0] == "Data" && (params[i][1] != "")) {
			dt = " ?date";

			data = "?subject ?property ?event . \
			?event crm:P4_has_time-span ?uri_date . \
			?uri_date rdfs:label ?date . \
			?date bif:contains \"\'"+ params[i][1] +"\'\" ."
		}

	}


	prefixes = "PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> \
	PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> \
	PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/> \
	PREFIX owl: <http://www.w3.org/2002/07/owl#> \
	PREFIX schema: <http://schema.org/> \
	PREFIX foaf: <http://xmlns.com/foaf/0.1/> \
	PREFIX person: <http://www.w3.org/ns/person#>"

	query = prefixes + " SELECT DISTINCT ?subject ?label ?identifier " + dm + mt + locl + tec + at
	+ sg + tt + tp + nt + rf + np + nf + pt + ln + lm + gr + dn + dts + oc + qf + ga + mit 
	+ des + lp + la + dp + da + lin + alin + ed + lem + dt + ttx + " \
	WHERE {GRAPH " + search_graph + " {?subject ?property ?object } \
	?subject rdfs:label ?label . " 
	+ search_identifier + infObj + letter_event + label + search_type + dimensione + materia + localizzazione + tecnica 
	+ artista + titolo + tipo + note + riferimenti + nome_proprio + nome_di_famiglia
	+ patronimico + luogo_di_Nascita + luogo_di_Morte + genere + data_di_Nascita 
	+ data_di_Morte + qualifica + occupazione + gruppi_di_appartenenza + mittente + destinatario 
	+luogo_di_Partenza + luogo_di_Arrivo + data_partenza + data_arrivo + lingua 
	+ area_linguistica + edizione + lemma + data + identificatore + testo + "}"

	var query_url = 'http://dev.restore.ovi.cnr.it:8890/sparql/?default-graph-uri=&query=' + encodeURIComponent(query) + '&output=json';

	console.log(query);

	$.ajax({

			url: query_url + '&callback=?',
			dataType: "json",
			success: function (data) {
				query_handle_json(data, choosen_type);
			},
			error: function (e) {}
		});

}

function query_handle_json(json, choosen_type) {

		console.log(json); 

		var resulType = "";

		if (choosen_type == "Object") {
			resulType = "object";
		}
		if (choosen_type == "Letter") {
			resulType = "object";
		}
		if (choosen_type == "OA") {
			resulType = "artwork";
		}
		if (choosen_type == "Person") {
			resulType = "persona";
		}

		$('#query_results').text("");

		var i = 0;

		const first_row = [];

		$.each(
			json['head']['vars'],
			function (index, value) {
				first_row.push(value);
		});

		var t_head = '<div class="row t_head">';

		for (let k = 1; k < first_row.length; k++) {
			var param = renameCol(first_row[k]);
			t_head += '<div class="col-auto">' + param + '</div>';
		}

		t_head += '</div>';


		$('#query_results').append(t_head);

		$.each(
			json['results']['bindings'],
			function (index, value) {
				var object = ""; 

				var link = value['subject']['value'];
				var label = value['label']['value'];

				object += '<div class="row"><div id="' + link + '" class="col-auto link ' + resulType + '">' + label + '</div>';

				if (value.hasOwnProperty('identifier')) {
		          identifier = value['identifier']['value'];
		          object += '<div class="col-auto">' + identifier + '</div>';
		        }
		        if (value.hasOwnProperty('dimension')) {
		          dimension = value['dimension']['value'];
		          object += '<div class="col-auto">' + dimension + '</div>';
		        }
		        if (value.hasOwnProperty('material')) {
		          material = value['material']['value'];
		          object += '<div class="col-auto">' + material + '</div>';
		        }
		        if (value.hasOwnProperty('location')) {
		          localization = value['location']['value'];
		          object += '<div class="col-auto">' + localization + '</div>';
		        }
		        if (value.hasOwnProperty('technique')) {
		          technique = value['technique']['value'];
		          object += '<div class="col-auto">' + technique + '</div>';
		        }
		        if (value.hasOwnProperty('artist')) {
		          artist = value['artist']['value'];
		          object += '<div class="col-auto">' + artist + '</div>';
		        }
		        if (value.hasOwnProperty('depiction')) {
		          depiction = value['depiction']['value'];
		          object += '<div class="col-auto">' + depiction + '</div>';
		        }
		        if (value.hasOwnProperty('title')) {
		          title = value['title']['value'];
		          object += '<div class="col-auto">' + title + '</div>';
		        }
		        if (value.hasOwnProperty('type')) {
		          type = value['type']['value'];
		          object += '<div class="col-auto">' + type + '</div>';
		        }
		        if (value.hasOwnProperty('note')) {
		          note = value['note']['value'];
		          object += '<div class="col-auto">' + note + '</div>';
		        }
		        if (value.hasOwnProperty('ref')) {
		          ref = value['ref']['value'];
		          object += '<div class="col-auto">' + ref + '</div>';
		        }
		        if (value.hasOwnProperty('givenName')) {
		          givenName = value['givenName']['value'];
		          object += '<div class="col-auto">' + givenName + '</div>';
		        }
		        if (value.hasOwnProperty('familyName')) {
		          familyName = value['familyName']['value'];
		          object += '<div class="col-auto">' + familyName + '</div>';
		        }
		        if (value.hasOwnProperty('patronymic')) {
		          patronymic = value['patronymic']['value'];
		          object += '<div class="col-auto">' + patronymic + '</div>';
		        }
		        if (value.hasOwnProperty('birthPlace')) {
		          birthPlace = value['birthPlace']['value'];
		          object += '<div class="col-auto">' + birthPlace + '</div>';
		        }
		        if (value.hasOwnProperty('deathPlace')) {
		          deathPlace = value['deathPlace']['value'];
		          object += '<div class="col-auto">' + deathPlace + '</div>';
		        }
		        if (value.hasOwnProperty('genere')) {
		          genere = value['genere']['value'];
		          object += '<div class="col-auto">' + genere + '</div>';
		        }
		        if (value.hasOwnProperty('Birth_TS')) {
		          Birth_TS = value['Birth_TS']['value'];
		          object += '<div class="col-auto">' + Birth_TS + '</div>';
		        }
		        if (value.hasOwnProperty('Death_TS')) {
		          Death_TS = value['Death_TS']['value'];
		          object += '<div class="col-auto">' + Death_TS + '</div>';
		        }
		        if (value.hasOwnProperty('qualification')) {
		          qualification = value['qualification']['value'];
		          object += '<div class="col-auto">' + qualification + '</div>';
		        }
		        if (value.hasOwnProperty('occupation')) {
		          occupation = value['occupation']['value'];
		          object += '<div class="col-auto">' + occupation + '</div>';
		        }
		        if (value.hasOwnProperty('group')) {
		          group = value['group']['value'];
		          object += '<div class="col-auto">' + group + '</div>';
		        }
		        if (value.hasOwnProperty('mittente')) {
		          mittente = value['mittente']['value'];
		          object += '<div class="col-auto">' + mittente + '</div>';
		        }
		        if (value.hasOwnProperty('destinatario')) {
		          destinatario = value['destinatario']['value'];
		          object += '<div class="col-auto">' + destinatario + '</div>';
		        }
		        if (value.hasOwnProperty('luogo_partenza')) {
		          luogo_partenza = value['luogo_partenza']['value'];
		          object += '<div class="col-auto">' + luogo_partenza + '</div>';
		        }
		        if (value.hasOwnProperty('luogo_arrivo')) {
		          luogo_arrivo = value['luogo_arrivo']['value'];
		          object += '<div class="col-auto">' + luogo_arrivo + '</div>';
		        }
		        if (value.hasOwnProperty('timeSpanSend')) {
		          timeSpanSend = value['timeSpanSend']['value'];
		          object += '<div class="col-auto">' + timeSpanSend + '</div>';
		        }
		        if (value.hasOwnProperty('timeSpanReceive')) {
		          timeSpanReceive = value['timeSpanReceive']['value'];
		          object += '<div class="col-auto">' + timeSpanReceive + '</div>';
		        }
		        if (value.hasOwnProperty('lingua')) {
		          lingua = value['lingua']['value'];
		          object += '<div class="col-auto">' + lingua + '</div>';
		        }
		        if (value.hasOwnProperty('area_linguistica')) {
		          area_linguistica = value['area_linguistica']['value'];
		          object += '<div class="col-auto">' + area_linguistica + '</div>';
		        }
		        if (value.hasOwnProperty('edizione')) {
		          edizione = value['edizione']['value'];
		          object += '<div class="col-auto">' + edizione + '</div>';
		        }
		        if (value.hasOwnProperty('lemma')) {
		          lemma = value['lemma']['value'];
		          object += '<div class="col-auto">' + lemma + '</div>';
		        }
		        if (value.hasOwnProperty('testo')) {
		          testo = value['testo']['value'];
		          object += '<div class="col-auto">' + testo + '</div>';
		        }
		        if (value.hasOwnProperty('date')) {
		          date = value['date']['value'];
		          object += '<div class="col-auto">' + date + '</div>';
		        } 

		        object += '</div>';

				i++;

				/*onclick=copy__Text("' + value['link']['value'] + '")*/
				$('#query_results').append(object);
				

			});

		if (i==0) {
			var message = '<p>Nessun risultato trovato</p>';
			$('#query_results').append(message);
		}

		document.getElementById("n_res").innerHTML = i;
}

function populateSelGraph(graphType) {
	let y = graphArray.length;

	collection_selector.innerHTML = "";

	if (graphType != "General") {
		collection_selector.style.color = '#202122';
		collection_selector.style.cursor = 'pointer';
		collection_selector.style.backgroundColor = '#f8f9fa';
		collection_selector.style.backgroundImage  = 'linear-gradient(to top, #fff, #fff 33%)';
	} else {
		collection_selector.style.color = '#a1a1a1';
		collection_selector.style.cursor = 'not-allowed';
		collection_selector.style.backgroundColor = '#eee';
		collection_selector.style.backgroundImage = 'linear-gradient(to top, #ddd, #eee 33%)';
	}

	var genOpt = document.createElement("option");
	genOpt.value= "";
	genOpt.innerHTML = "Tutte le Collezioni";
	collection_selector.add(genOpt);

	for(var i=0; i<y; i++) {
		if (graphType == graphArray[i][2]) {
		   var opt = document.createElement("option");
		   opt.value= graphArray[i][1];
		   opt.innerHTML = graphArray[i][0]; // whatever property it has

		   // then append it to the select element
		   collection_selector.add(opt);
		}
	}
}

function renameCol(param) {
	if (param == "label") {
		return ("Denominazione");
	} 
	else if (param == "identifier") {
		return ("Identificatore");
	}
	else if (param == "dimension") {
		return ("Dimensioni");
	}
	else if (param == "material") {
		return ("Materiale");
	} 
	else if (param == "location") {
		return ("Istituto di conservazione");
	}
	else if (param == "technique") {
		return ("Tecnica");
	}
	else if (param == "artist") {
		return ("Artista");
	}
	else if (param == "depiction") {
		return ("Soggetto");
	}
	else if (param == "title") {
		return ("Titolo");
	}
	else if (param == "type") {
		return ("Tipologia");
	}
	else if (param == "note") {
		return ("Note");
	}
	else if (param == "ref") {
		return ("Riferimenti");
	}
	else if (param == "givenName") {
		return ("Nome proprio");
	}
	else if (param == "familyName") {
		return ("Cognome");
	}
	else if (param == "birthPlace") {
		return ("Luogo di Nascita");
	}
	else if (param == "deathPlace") {
		return ("Luogo di morte");
	}
	else if (param == "genere") {
		return ("Genere");
	}
	else if (param == "Birth_TS") {
		return ("Data di nascita");
	}
	else if (param == "Death_TS") {
		return ("Data di morte");
	}
	else if (param == "qualification") {
		return ("Qualifica");
	}
	else if (param == "occupation") {
		return ("Occupazione");
	}
	else if (param == "mittente") {
		return ("Mittente");
	}
	else if (param == "destinatario") {
		return ("Destinatario");
	}
	else if (param == "luogo_partenza") {
		return ("Luogo di partenza");
	}
	else if (param == "luogo_arrivo") {
		return ("Luogo di arrivo");
	}
	else if (param == "timeSpanSend") {
		return ("Data partenza");
	}
	else if (param == "timeSpanReceive") {
		return ("Data arrivo");
	}
	else if (param == "area_linguistica") {
		return ("Area linguistica");
	}
	else if (param == "edizione") {
		return ("Edizione");
	}
	else if (param == "lemma") {
		return ("Lemma");
	}
	else if (param == "testo") {
		return ("Testo");
	}
	else if (param == "date") {
		return ("Data");
	}
	 else {
		return (param);
	}
}

function download_table_as_csv(separator = ',') {
    // Select rows from table_id
    var rows = document.querySelectorAll('#query_results .row');
    // Construct csv
    var csv = [];
    for (var i = 0; i < rows.length; i++) {
        var row = [], cols = rows[i].querySelectorAll('.col-auto');
        for (var j = 0; j < cols.length; j++) {
            // Clean innertext to remove multiple spaces and jumpline (break csv)
            var data = cols[j].innerText.replace(/(\r\n|\n|\r)/gm, '').replace(/(\s\s)/gm, ' ')
            // Escape double-quote with double-double-quote (see https://stackoverflow.com/questions/17808511/properly-escape-a-double-quote-in-csv)
            data = data.replace(/"/g, '""');
            // Push escaped string
            row.push('"' + data + '"');
        }
        csv.push(row.join(separator));
    }
    var csv_string = csv.join('\n');
    // Download it
    var filename = 'export_queryResults_' + new Date().toLocaleDateString() + '.csv';
    var link = document.createElement('a');
    link.style.display = 'none';
    link.setAttribute('target', '_blank');
    link.setAttribute('href', 'data:text/csv;charset=utf-8,' + encodeURIComponent(csv_string));
    link.setAttribute('download', filename);
    document.body.appendChild(link);
    link.click();
    document.body.removeChild(link);
}