source: main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/dataviz/voting-dataflow-tele.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-tele">


    <div id="ssv-voting-dataflow-tele" 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  (?tele_country AS ?tele_vote_from_country) (?country AS ?to_country) (SUM(?tele_vote_int) * SUM(?tele_vote_int) AS ?country_tele_to_country_total_squared) (SUM(?tele_vote_int) AS ?tele_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_tele_country_uri ?tele_vote.
    BIND(STRENDS(str(?gsdlextracted_tele_country_uri),"-T") AS ?is_tele_vote)
    FILTER (?is_tele_vote).
    BIND(REPLACE(str(?gsdlextracted_tele_country_uri), ".*#(.*?)$", "$1") AS ?tele_country).

    BIND(xsd:integer(?tele_vote) AS ?tele_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 ?tele_country ?country


</xsl:text>
        </div>      
        <div id="ssv-voting-dataflow-tele-chart" style="display: none;">
<!-- -->
<xsl:text>
google.visualization.Sankey
</xsl:text>
        </div>
        <div id="ssv-voting-dataflow-tele-chart-options" style="display: none;">
<!-- -->
<xsl:text>
title=Dataflow Analysis of Televoting by Country (2016-2019)|height=1200|chartArea.height=1100|fontSize=11
</xsl:text>
        </div>
        <div id="ssv-voting-dataflow-tele-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>