Leonie: added legend

2024-04-15T15:00:04Z

added legend

@@ Line 43: / Line 43: @@
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
 } | caption={{#username:Max Mustermann}}'s progress graph for {{{course|Q468}}}
 }}

Leonie: created the form for a presonalized progress graph

2024-04-15T14:32:10Z

created the form for a presonalized progress graph

New page

{{#widget:SPARQLquery|code=
#defaultView:Graph
PREFIX wdt: <https://graphit.ur.de/prop/direct/>
PREFIX wd: <https://graphit.ur.de/entity/>
# progress graph -> get all items in sessions + mark besprochen(using date) + completed
SELECT DISTINCT ?sessionDate ?today ?interest ?complete
?item ?itemLabel ?rgb1 ?shape1
?link ?linkLabel ?rgb2 ?shape2
WHERE {
# get all items in all sessions of course
wd:{{{course|Q468}}} wdt:P14 ?session. # use current
?session wdt:P3 wd:Q427.
?session wdt:P19 ?sessionDate.

?session wdt:P14 ?item.
?item wdt:P1 ?link. # get links between items

BIND(now() as ?today)
?user rdfs:label "{{#username:Max Mustermann}}"@en.

# STYLING
OPTIONAL { ?user wdt:P23 ?item. BIND("true" as ?interest) }
OPTIONAL { ?user wdt:P12 ?item.
?session wdt:P14 ?item. ?session wdt:P19 ?sessionDate.
BIND(IF(?sessionDate < now(), "past", "future") as ?complete) }

# --- color --- #
BIND( IF(BOUND(?complete) && ?complete = "past", "B9CEB6", # grey green if completed in past session
IF(BOUND(?complete) && ?complete = "future", "CBFDBB", # light green if completed in future session
IF(?sessionDate < ?today, "CCCCCC", "FFFFFF" ))) as ?rgb1) # grey if in past session

BIND( IF(BOUND(?complete) && ?complete = "past", "B9CEB6",
IF(BOUND(?complete) && ?complete = "future", "CBFDBB",
IF(?sessionDate < ?today, "CCCCCC", "FFFFFF" ))) as ?rgb2)

# --- shape --- #
BIND( IF(BOUND(?interest), "star", # star if interested
IF(?sessionDate < ?today, "ellipse", "box" )) as ?shape1) # box if in future session

BIND( IF(BOUND(?interest), "star",
IF(?sessionDate < ?today, "ellipse", "box" )) as ?shape2)

SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} | caption={{#username:Max Mustermann}}'s progress graph for {{{course|Q468}}}
}}

<noinclude>

== Usage ==
<pre style="background-color:#F5F5F5;">
{{Progress Graph|course=Q468}}
</pre>

Can also be included into a page using:
<pre style="background-color:#F5F5F5;">
{{Special:RunQuery/Progress Graph}}
</pre>
or something like
<pre style="background-color:#F5F5F5;">
{{#queryformlink:form=ProgressGraph|link text=Try running the query :D|link type=button|tooltip=This is a test}}
</pre>
</noinclude>

Template:Progress Graph - Revision history

Leonie: added legend

Leonie: created the form for a presonalized progress graph