Changeset 35093 for main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/pages/sparql.xsl

Timestamp:

2021-04-22T14:50:00+12:00 (3 years ago)

Author:

davidb

Message:

General text update; auto-focus param added into ssv_execute()

File:

• main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/pages/sparql.xsl (modified) (3 diffs)

main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/pages/sparql.xsl

@@ -48 +48 @@
       <gsf:style src="sites/{$site_name}/collect/{$collName}/css/dataviz.css" />
       <style>
-        div          { padding-left: 12px; padding-right: 12px; padding-top: 6px; padding-bottom: 6px;}
-        div.showmore { padding-left:  0px; padding-right:  0px; padding-top: 0px; padding-bottom: 0px;}
-
-        p  { padding-top: 6px; padding-bottom: 6px;}
-        a  { text-decoration: underline; }
-        li { padding-bottom: 6px; margin-bottom: 6px; }
+        #gs_content div          { padding-left: 12px; padding-right: 12px; padding-top: 6px; padding-bottom: 6px;}
+        #gs_content div.showmore { padding-left:  0px; padding-right:  0px; padding-top: 0px; padding-bottom: 0px;}
+
+        #gs_content p  { padding-top: 6px; padding-bottom: 6px;}
+        #gs_content a  { text-decoration: underline; }
+        #gs_content li { padding-bottom: 6px; margin-bottom: 6px; }
       </style>
 
@@ -389 +389 @@
 
 
+        <div id="ssq-from-winning-to-losing" style="display: none;">
+<!-- -->
+<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 dc:   &lt;http://purl.org/dc/elements/1.1/&gt;
+PREFIX gsdlextracted: &lt;http://greenstone.org/gsdlextracted#&gt;
+
+SELECT (?country as ?Country) (?year AS ?WinningYear) (?total as ?WinningGrandTotal) (?next_year AS ?LosingYear) (?next_total as ?LosingGrandTotal)          
+WHERE {
+    GRAPH &lt;</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>&gt;  {
+        ?esc_entrant_uri gsdlextracted:Country ?country.
+        ?esc_entrant_uri gsdlextracted:VoteGrandTotal ?total.
+
+    ?esc_entrant_uri gsdlextracted:Place ?place.
+        BIND(xsd:integer(?place) AS ?place_int).    
+    FILTER(?place_int = 1). 
+
+    ?esc_entrant_uri gsdlextracted:Year ?year.
+    BIND(xsd:integer(?year) AS ?year_int).
+    BIND(?year_int + 1 AS ?next_year_int).
+    BIND(str(?next_year_int) AS ?next_year).
+
+        ?next_esc_entrant_uri gsdlextracted:Country ?country.
+    ?next_esc_entrant_uri gsdlextracted:Year ?next_year.
+    
+        ?next_esc_entrant_uri gsdlextracted:VoteGrandTotal ?next_total.
+
+        ?next_esc_entrant_uri gsdlextracted:ReverseFinishingPos ?rev_finishing_pos.
+        BIND(xsd:integer(?rev_finishing_pos) AS ?rev_finishing_pos_int).
+        FILTER(?rev_finishing_pos_int = 1).
+    
+    
+   }
+}
+ORDER BY ?country
+</xsl:text>
+        </div>
 
         <div id="ssq-country-info" style="display: none;">
@@ -528 +567 @@
 
         <p>
-          The number of times a country has won Eurovision across the years.  The includes
-          the years when only Juries voted (1956-2000) through to the introduction
-          of Televotes, where a variety of forms have been used such as only
-          Televotes, a pre-combined score based on Televotes and Jury votes, to
-          (from 2016 onwards) where the Jury and Tele votes are explicitly
-          given individually per country, then combined.
+          The number of times a country has won Eurovision
+          across the years.  The includes the years when only
+          Juries voted (1956-2000) through to the introduction
+          of Televotes, where a variety of forms have been
+          used such as only Televotes, a pre-combined score
+          based on Televotes and Jury votes, to (from 2016
+          onwards) where the Jury and Tele votes are
+          explicitly given individually per country, then
+          combined.
         </p>
           </li>
-          
+
+
+
+          <li>
+        <b>From Hero to Zero!</b><br/>
+        <button type="button" class="load-ssq" id="load-ssq-from-winning-to-losing" onclick="ssq_load('ssq-from-winning-to-losing')">Load query above</button>
+        <button type="button" class="exec-ssq" id="exec-ssq-from-winning-to-losing" onclick="ssq_execute()">Get Results</button><br/>
+
+        <p>
+          List countries where, having won in one year, they
+          have gone on to lose with the lowest score of the
+          contest the following year.  Note this definition
+          doesn't quite meet the given heading of <i>From Here
+          to Zero</i>. There is in fact only one country, to
+          date, where this has happened (nul-point the
+          following year).  View the table to see who it is
+          ...  then why not test out your SPARQL querying
+          skills and see if you can modify the query used so
+          it only returns the Hero to Zero case?
+        </p>
+          </li>
 
           <li>