Difference between revisions of "Template:WhereEvent"
Line 1: | Line 1: | ||
− | Event.Years.Year IS NOT NULL {{#if:{{{draft|}}}||AND COALESCE(Event.Status,'')=''}} {{#if:{{{user|}}}|AND Event.User={{ | + | Event.Years.Year IS NOT NULL {{#if:{{{draft|}}}||AND COALESCE(Event.Status,'')=''}} {{#if:{{{user|}}}| AND Event.User='{{#str:addslashes|{{{user}}}}}'}} {{#if:{{{before|}}}| and Event.Start <= '{{#timel:c|{{{before}}}}}' |
}} {{#if:{{{after|}}}| and Event.Start >= '{{#timel:c|{{{after}}}}}' | }} {{#if:{{{after|}}}| and Event.Start >= '{{#timel:c|{{{after}}}}}' | ||
}} {{#switch:{{{year|}}} | }} {{#switch:{{{year|}}} | ||
| current = and Event.Start <='{{#timel:c|yesterday}}' and Event.End>='{{#timel:c|today}}' | | current = and Event.Start <='{{#timel:c|yesterday}}' and Event.End>='{{#timel:c|today}}' | ||
| upcoming = and Event.Start >= '{{#timel:c|yesterday}}' | | upcoming = and Event.Start >= '{{#timel:c|yesterday}}' | ||
+ | | all = | ||
| #default = and coalesce(Event.End,Event.Start) <= '{{#timel:c|today}}' | | #default = and coalesce(Event.End,Event.Start) <= '{{#timel:c|today}}' | ||
}} {{#switch:{{{year|}}} | }} {{#switch:{{{year|}}} | ||
Line 20: | Line 21: | ||
|international= and Event.Country != 'Slovenia' | |international= and Event.Country != 'Slovenia' | ||
|#default = and Event.Country = '{{#str:addslashes|{{#title:pagenamek|{{{country}}}}}}}' | |#default = and Event.Country = '{{#str:addslashes|{{#title:pagenamek|{{{country}}}}}}}' | ||
− | }}<noinclude>{{#data:grid|Event.*|#where={{whereEvent}}}}</noinclude> | + | }}<noinclude> |
+ | |||
+ | {{whereEvent|draft=true|user=Zocky|year=all}}}} | ||
+ | |||
+ | {{#data:grid|Event.*|#where={{whereEvent|draft=true|user=Zocky|year=all}}}}</noinclude> |
Revision as of 07:47, 13 January 2025
Event.Years.Year IS NOT NULL AND COALESCE(Event.Status,)= and coalesce(Event.End,Event.Start) <= '2025-01-22T01:00:00+01:00' and Event.Country != 'Slovenia'
Event.Years.Year IS NOT NULL AND Event.User='Zocky' and Event.Country != 'Slovenia'}}
Event.* | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
96ce09ac9d57e7b176942d77c6ec7181fcfe009a6b203197e44373d4d68ae997 | 96ce09ac9d57e7b176942d77c6ec7181fcfe009a6b203197e44373d4d68ae997 | 96ce09ac9d57e7b176942d77c6ec7181fcfe009a6b203197e44373d4d68ae997 | Record:Event/1 | Culture.si | 2025-01-16 00:00:00 | 2025-01-23 00:00:00 | Test2 | /w/index.php?title=Record:Event/1&action=formedit | Zocky | draft |