source: main/trunk/model-sites-dev/von-sparql/js/von-sparql-script.js@ 32505

//Sparql overview script
//Query generation code is fairly messy, watch out!

//Creates a new query
//containerID:  ID of div to draw results in
//hardLimit:    Returned results limit
function newQuery(containerID, GraphType,hardLimit){
    var Q = new sgvizler.Query();
    Q.query(generateQuery(hardLimit))
        .endpointURL(sparqlEndpoint)
        .endpointOutputFormat("json")
        .chartFunction($('#sel_ChartType').val())
        .draw(containerID);
}

//Checks if all query refinements were entered
function isRefinedQuery(){
        if($('#cb_RefineSearch').is(':checked'))
            return true;
        else
            return false;
}

//Generates a query based on the predicates etc selected by the user
function generateQuery(hardLimit){
    var predicateURL = $('#sel_Predicate').val();
    var sparqlQuery = "";

     //Fix to make queries work when object starts with a '<' or '>'
    var speechMarks = "\"";
    if($('#sel_RefineObject').val().substring(0,1)=="<") 
        speechMarks="";
    
    //Refine to specific graph if chosen
    var refineDataset = "GRAPH gsdl:" + collectionName + " {\n";
    var select;
    var extra = "";
    var group;

    //Depending on what type of graph, adjust query
    if($('#sel_ChartType').val()=="google.visualization.ImageSparkLine"){
        select = "SELECT ?a WHERE{";
        extra = 'BIND (REPLACE(?o, "\\\\D", "") as ?trim)' +
                "BIND (xsd:integer(SUBSTR(?trim,1,4)) as ?a)" + 
                "FILTER (bound(?a))" +
                "FILTER (?a > 300)" +
                "FILTER (?a < 2015)" ;

        group =  "GROUP BY ?a order by ?a\n";
    }
    else if ($('#sel_ChartType').val()=="google.visualization.LineChart"){
        select = "SELECT ?a (COUNT(?a) as ?count) WHERE{";
        extra = 'BIND (REPLACE(?o, "\\\\D", "") as ?trim)' +
                "BIND (xsd:integer(SUBSTR(?trim,1,4)) as ?a)" + 
                "FILTER (bound(?a))"+
                "FILTER (?a > 300)" +
                "FILTER (?a < 2015)" ;
        group =  "GROUP BY ?a order by ?a\n";
    }
    else{
        select = "SELECT (?o as ?Objects) (COUNT (?o) as ?Count) WHERE {\n" ;
        group =  "GROUP BY ?o ORDER BY DESC(?Count)\n";
    }

    sparqlQuery = "PREFIX gsdl: <http://localhost:3030/greenstone/data/> \n";
    sparqlQuery += "PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>\n";
      
    if(isRefinedQuery())
    sparqlQuery += select +
             "  " + refineDataset +
             "    ?s <"+ predicateURL + "> "+ speechMarks + $('#sel_RefineObject').val() + speechMarks +";\n" +
             "      <"+$('#sel_RefinePredicate').val() +"> ?o\n"
                     + extra +
                     "}\n" ;
    else
    sparqlQuery += select +
             "  " + refineDataset +
             "    ?s <" + predicateURL + "> ?o\n  "  
                     + extra + 
                     "}\n";
        
    //add extra curly brace for end of GRAPH block
    sparqlQuery+= "}\n";

    sparqlQuery +=  group;

    //If a limit was selected, apply it
    if($('#sel_Limit').val()!="None")
        sparqlQuery += " LIMIT " + $('#sel_Limit').val();
    else
        sparqlQuery += " LIMIT " + hardLimit;
        

    var query = sparqlQuery;
    query = query.replace(/</g, '&lt;');
    query = query.replace(/>/g, '&gt;');
    query = query.replace(/\n/g, '<br/>');

    $('#span_sparqlQuery').empty() ;
    $('#span_sparqlQuery').html(query);
    return sparqlQuery;
}

//Updates possible values for predicate selector by sending a query to the 
//triple-store requesting a list of all predicates.
function updatePredicateSelector(){
    var ajaxSparqlQuery = sparqlEndpoint + "?query=" + encodeURIComponent(overviewSparqlQuery);
        $.ajax({
        url: ajaxSparqlQuery,
        type:"GET",
        data:"output=json",
        })
        .done(function( json ) {
        var parsedJSON = ((typeof json) == "string") ? $.parseJSON(json) : json;
        $.each(parsedJSON.results.bindings,function(index,item){
            var pred  = item.Predicate.value;
            var name = tidyPredicate(pred);
            $('#sel_Predicate')
                .append("<option value=\""+pred+"\">" + name + "</option>");
            $('#sel_RefinePredicate')
                .append("<option value=\""+pred+"\">" + name + "</option>");
        });
        });
}

//Fill in possible values for 'refine' object  selector, based on what predicate the user
//has selected before, only existing objects will be available.
function updateRefineObjectSelector(predicate){
    var refineDataset = "GRAPH gsdl:" + collectionName + " {\n";

    var sparqlQuery = "PREFIX gsdl: <http://localhost:3030/greenstone/data/> \n";
    sparqlQuery += "SELECT ?obj WHERE{"+
                      refineDataset +  
              "   ?s <"+predicate+"> ?obj }}"+
              "GROUP BY ?obj ORDER BY (?obj)";
    var ajaxSparqlQuery = sparqlEndpoint + "?query=" + encodeURIComponent(sparqlQuery);

    $.ajax({
        url: ajaxSparqlQuery,
        type:"GET",
        data:"output=json",
    })
    .done(function( json ) {
        var parsedJSON = ((typeof json) == "string") ? $.parseJSON(json) : json;

        //Clear selector. Add empty option to start.
        $('#sel_RefineObject').empty();
            $('#sel_RefineObject')
            .append("<option value=\"None\">  </option>");

        $.each(parsedJSON.results.bindings,function(index,item){
            var obj;
            if(item.obj.type == "uri"){
                obj = "&lt;" + item.obj.value + "&gt;";
                $('#sel_RefineObject')
                .append("<option value="+ obj + ">" + obj.substring(0,75) + "</option>");
            }
            else{
                obj = item.obj.value;
                $('#sel_RefineObject')
                .append("<option value=\""+ obj +"\">" + obj.substring(0,75) + "</option>");
            }
        });
        $('#sel_RefineObject').next().find('.custom-combobox-input').val("");
    });
}

//When the user has selected a predicate and an object to restrict it to, this predicate selector will update 
//showing the predicates that are available for selection based on what triples will be returned from
//the restriction chosen.

function updateRefinePredicateSelector(obj){
    //Perform ajax query to return possible predicate values, given object and predicate values already chosen
    var predicate = $('#sel_Predicate').val();
    var sparqlQuery;
    if(obj.substring(0,1) == "<") 
    sparqlQuery = "SELECT ?predicate WHERE{"+
              "   ?s <" + predicate + ">  "+ obj + ";"+
              "      ?predicate ?o}"+
              "GROUP BY ?predicate ORDER BY DESC(?predicate)";
    else
    sparqlQuery = "SELECT ?predicate WHERE{"+
              "   ?s <" + predicate + ">  \""+ obj + "\";"+
              "      ?predicate ?o}"+
              "GROUP BY ?predicate ORDER BY DESC(?predicate)";
    var ajaxSparqlQuery = sparqlEndpoint + "?query=" + encodeURIComponent(sparqlQuery);

    $.ajax({
        url: ajaxSparqlQuery,
        type:"GET",
        data:"output=json",
    })
    .done(function( json ) {
        var parsedJSON = ((typeof json) == "string") ? $.parseJSON(json) : json;
        $('#sel_RefinePredicate').empty();
            $('#sel_RefinePredicate')
            .append("<option value=\"None\">  </option>");
        $.each(parsedJSON.results.bindings,function(index,item){
            var pred = item.predicate.value;
            var name = tidyPredicate(pred);
            $('#sel_RefinePredicate')
            .append("<option value=\""+pred+"\">" + name + "</option>");
        });
        $('#sel_RefinePredicate').next().find('.custom-combobox-input').val("");
    });
}


//Hides search-refining elements of page when not needed
function toggle_RefineSearch(enable){
    if(enable)
        $('#refineControls').toggle("slide", { direction: "up" });
    else
        $('#refineControls').toggle("slide", { direction: "up" });
}

//Tidys up a predicate for easy readability in dropdown lists.
function tidyPredicate(name)
{
    name = name.replace("http://purl.org/dc/elements/1.1/","dc.");
    name = name.replace("http://greenstone.org/gsembedded#","gsembedded.");
    name = name.replace("http://greenstone.org/gsextracted#","gsextracted.");
    return name;
}