source: main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/dataviz/list-of-winners.xsl@ 35107

Last change on this file since 35107 was 35088, checked in by davidb, 3 years ago

Filter of place moved to start of query, as presumably more efficient

File size: 2.2 KB
Line 
1<?xml version="1.0" encoding="UTF-8"?>
2<xsl:stylesheet version="1.0"
3 xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
4 xmlns:java="http://xml.apache.org/xslt/java"
5 xmlns:util="xalan://org.greenstone.gsdl3.util.XSLTUtil"
6 xmlns:gslib="http://www.greenstone.org/skinning"
7 xmlns:gsf="http://www.greenstone.org/greenstone3/schema/ConfigFormat"
8 extension-element-prefixes="java util"
9 exclude-result-prefixes="java util">
10
11 <xsl:template name="ssv-list-of-winners">
12
13 <div id="ssv-list-of-winners" style="display: none;">
14
15<!-- Work out the ESC list of winners from gsdlextracted:Place = 1 filter -->
16<xsl:text>
17PREFIX rdfs: &lt;http://www.w3.org/2000/01/rdf-schema#&gt;
18PREFIX xsd: &lt;http://www.w3.org/2001/XMLSchema#&gt;
19PREFIX gsdlextracted: &lt;http://greenstone.org/gsdlextracted#&gt;
20
21SELECT (?year AS ?Year) (?country AS ?Country) (?title as ?Title) (GROUP_CONCAT(?creator; SEPARATOR="; ") AS ?Artist)
22WHERE {
23 GRAPH &lt;</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>&gt; {
24 ?esc_entrant_uri gsdlextracted:Place ?place.
25 BIND(xsd:integer(?place) AS ?place_int).
26 FILTER(?place_int = 1).
27
28 ?esc_entrant_uri gsdlextracted:Country ?country.
29 ?esc_entrant_uri gsdlextracted:Year ?year.
30 ?esc_entrant_uri gsdlextracted:Title ?title.
31 ?esc_entrant_uri gsdlextracted:Creator ?creator.
32 }
33}
34GROUP BY ?year ?country ?title
35ORDER BY ?year ?country
36</xsl:text>
37 </div>
38 <div id="ssv-list-of-winners-chart" style="display: none;">
39<!-- -->
40<xsl:text>
41sgvizler.visualization.Table
42</xsl:text>
43 </div>
44 <div id="ssv-list-of-winners-chart-options" style="display: none;">
45<!-- -->
46<xsl:text>
47title=Eurovison Hall of Fame: Winners Through the Ages|height=800|width=700|fontSize=11
48</xsl:text>
49 </div>
50
51 <div id="ssv-list-of-winners-div-style" style="display: none;">
52<!-- -->
53<xsl:text>
54 width:710px; height:400px; margin-left: auto; margin-right: auto; overflow-y: scroll; overflow-x: hidden;
55 color: black; background-color: white;
56</xsl:text>
57
58<!--
59.table-striped tbody tr:nth-of-type(2n+1) {
60 background-color: rgba(0,0,0,.05);
61}
62-->
63 </div>
64
65 </xsl:template>
66
67</xsl:stylesheet>
68
69
70
71
Note: See TracBrowser for help on using the repository browser.