source: main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/dataviz/voting-dataflow-jury.xsl@ 35107

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:java="http://xml.apache.org/xslt/java"
    xmlns:util="xalan://org.greenstone.gsdl3.util.XSLTUtil"
    xmlns:gslib="http://www.greenstone.org/skinning"
    xmlns:gsf="http://www.greenstone.org/greenstone3/schema/ConfigFormat"   
    extension-element-prefixes="java util"
    exclude-result-prefixes="java util">
  
  <xsl:template name="ssv-voting-dataflow-jury">

    <div id="ssv-voting-dataflow-jury" style="display: none;">

<!-- Dataflow voting patterns (Sankey) -->
<xsl:text>

PREFIX gsdlextracted: &lt;http://greenstone.org/gsdlextracted#&gt;
PREFIX xsd: &lt;http://www.w3.org/2001/XMLSchema#&gt;
PREFIX dc: &lt;http://purl.org/dc/elements/1.1/&gt;

SELECT  (?jury_country AS ?jury_vote_from_country) (?country AS ?to_country) (SUM(?jury_vote_int) * SUM(?jury_vote_int) AS ?country_jury_to_country_total_squared) (SUM(?jury_vote_int) AS ?jury_vote_total) WHERE {
  GRAPH &lt;</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>&gt;  {
#    ?esc_entrant_uri dc:Relation.isPartOf &lt;</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>&gt;.

    ?esc_entrant_uri ?gsdlextracted_jury_country_uri ?jury_vote.
    BIND(STRENDS(str(?gsdlextracted_jury_country_uri),"-J") AS ?is_jury_vote)
    FILTER (?is_jury_vote).
    BIND(REPLACE(str(?gsdlextracted_jury_country_uri), ".*#(.*?)-J$", "$1-J") AS ?jury_country).

    BIND(xsd:integer(?jury_vote) AS ?jury_vote_int).

    ?esc_entrant_uri gsdlextracted:Year ?year
      FILTER(xsd:integer(?year) &gt;= **startyear** &amp;&amp; xsd:integer(?year) &lt;= **endyear**).    
    ?esc_entrant_uri gsdlextracted:Country ?country.

      
  }
}
GROUP BY ?jury_country ?country


</xsl:text>
        </div>      
        <div id="ssv-voting-dataflow-jury-chart" style="display: none;">
<!-- -->
<xsl:text>
google.visualization.Sankey
</xsl:text>
        </div>
        <div id="ssv-voting-dataflow-jury-chart-options" style="display: none;">
<!-- -->
<xsl:text>
title=Dataflow Analysis of Country Juries to Country Entrants (2010-2019)|height=1200|chartArea.height=1100|fontSize=11
</xsl:text>
        </div>
        <div id="ssv-voting-dataflow-jury-div-style" style="display: none;">
<!-- -->
<xsl:text>
width:900px; height:1200px; margin-left: auto; margin-right: auto; overflow-y: hidden; overflow-x: hidden;  
</xsl:text>

    </div>

  </xsl:template>
    
</xsl:stylesheet>