source: main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/dataviz/list-of-losers.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-list-of-losers">



    
        <div id="ssv-list-of-losers" style="display: none;">

<!-- List of entrants that came last in a given year -->          
<xsl:text>
PREFIX rdfs: &lt;http://www.w3.org/2000/01/rdf-schema#&gt;
PREFIX xsd:  &lt;http://www.w3.org/2001/XMLSchema#&gt;
PREFIX gsdlextracted: &lt;http://greenstone.org/gsdlextracted#&gt;

SELECT (?selected_year AS ?Year) (?country AS ?Country) (?title AS ?Title) (GROUP_CONCAT(?creator; SEPARATOR="; ") AS ?Artist)
WHERE {
    GRAPH &lt;</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>&gt;  {

        {
           SELECT ?selected_year (MAX(?selected_place_int) AS ?max_selected_place_int)
           WHERE {

            ?esc_entrant_uri gsdlextracted:Country ?selected_country.
            ?esc_entrant_uri gsdlextracted:Year ?selected_year.

        BIND(xsd:integer(?selected_year) AS ?selected_year_int).
        FILTER(?selected_year_int &gt; 1956).
        
            ?esc_entrant_uri gsdlextracted:Place ?selected_place.
            BIND(xsd:integer(?selected_place) AS ?selected_place_int).

           }
           GROUP BY ?selected_year
           ORDER BY ?selected_year
         }

         ?esc_entrant_uri gsdlextracted:Country ?country.
         ?esc_entrant_uri gsdlextracted:Place ?place.
         BIND(xsd:integer(?place) AS ?place_int).
         FILTER(?place_int = ?max_selected_place_int).

         ?esc_entrant_uri gsdlextracted:Year ?selected_year.
         ?esc_entrant_uri gsdlextracted:Title ?title.
         ?esc_entrant_uri gsdlextracted:Creator ?creator.
   }
}
GROUP BY ?selected_year ?country ?title
ORDER BY ?selected_year ?country
</xsl:text>
        </div>
        <div id="ssv-list-of-losers-chart" style="display: none;">
<!-- -->
<xsl:text>
sgvizler.visualization.Table
</xsl:text>
        </div>
        <div id="ssv-list-of-losers-chart-options" style="display: none;">
<!-- -->
<xsl:text>
title=Last Place Through the Ages|height=800|width=700|fontSize=11
</xsl:text>
        </div>

        <div id="ssv-list-of-losers-div-style" style="display: none;">
<!-- -->
<xsl:text>
  width:710px; height:400px; margin-left: auto; margin-right: auto; overflow-y: scroll; overflow-x: hidden;
  color: black; background-color: white;
</xsl:text>

<!--
.table-striped tbody tr:nth-of-type(2n+1) {
    background-color: rgba(0,0,0,.05);
}
-->
    </div>

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