Changes for page Forthcoming
From version 37.1
edited by Andrea Omicini
on 01/04/2023 19:19
on 01/04/2023 19:19
Change comment:
There is no comment for this version
To version 41.1
edited by Andrea Omicini
on 23/04/2023 23:17
on 23/04/2023 23:17
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -1,31 +1,27 @@ 1 1 = {{italiano}}In arrivo{{/italiano}}{{english}}Forthcoming{{/english}} = 2 2 3 -{{include reference="Events.Environment" excludeFirstHeading="true"/}}{{velocity}} 3 +{{include reference="Macros.Velocity" excludeFirstHeading="true"/}}{{include reference="Events.Environment" excludeFirstHeading="true"/}}{{velocity}} 4 +## set page display 5 +#noshortcuts() 6 +#set( $eventMenu = true ) 7 +## 4 4 #if( !$userName || $userName == "" || !$userSpace || $userSpace == "" || !$userFullname || $userFullname == "" ) 5 5 ## overall forthcoming events 6 - #set( $sql = "select doc.fullName from XWikiDocument doc, BaseObject obj, DateProperty as prop 7 - where doc.fullName = obj.name and obj.className = '$objectSpace.$objectClass' and obj.name <> '$objectSpace.$objectTemplate' and prop.id.id = obj.id and prop.name = 'start_date' and ( ( year(prop.value) > year(current_date()) ) or ( year(prop.value) = year(current_date()) and month(prop.value) > month(current_date()) ) or ( year(prop.value) = year(current_date()) and month(prop.value) = month(current_date()) and day(prop.value) > day(current_date()) ) ) order by date(prop.value) asc ") 8 - #set( $eventFound = $xwiki.search($sql) ) 9 - #foreach($event in $eventFound) 10 - #set( $eventDoc = $xwiki.getDocument($event) ) 11 -#if( !$foreach.first ){{themeTextSecondary}}•{{/themeTextSecondary}} #end## 12 -{{eventAcronym}}$eventDoc{{/eventAcronym}} (% style='color:$theme.textPrimaryColor' %)({{eventDates}}$eventDoc{{/eventDates}}) #end 13 -(%%) 10 + #set( $query = "select doc.fullName from XWikiDocument doc, BaseObject obj, DateProperty as prop 11 + where doc.fullName = obj.name and obj.className = '$objectSpace.$objectClass' and obj.name <> '$objectSpace.$objectTemplate' and prop.id.id = obj.id and prop.name = 'start_date' and ( ( year(prop.value) > year(current_date()) ) or ( year(prop.value) = year(current_date()) and month(prop.value) > month(current_date()) ) or ( year(prop.value) = year(current_date()) and month(prop.value) = month(current_date()) and day(prop.value) > day(current_date()) ) ) order by date(prop.value) asc " ) 14 14 #else 15 -## user forthcoming events 16 - #set( $query = ", BaseObject as obj0, BaseObject as obj1, LargeStringProperty as prop1, DateProperty as prop2 13 + #set( $query = "select doc.fullName from XWikiDocument doc, BaseObject as obj0, BaseObject as obj1, LargeStringProperty as prop1, DateProperty as prop2 17 17 where obj0.name = doc.fullName and obj0.className = '${objectSpace}.${objectClass}' and obj0.name <> '${objectSpace}.${objectTemplate}' and prop2.id.id = obj0.id and prop2.name = 'end_date' and ( ( year(prop2.value) > year(current_date()) ) or ( year(prop2.value) = year(current_date()) and month(prop2.value) > month(current_date()) ) or ( year(prop2.value) = year(current_date()) and month(prop2.value) = month(current_date()) and day(prop2.value) > day(current_date()) ) ) and obj1.name = doc.fullName and obj1.className = '${objectSpace}.Roles.${objectClass}' and prop1.id.id = obj1.id and prop1.name = 'who' and prop1.value like '%$userName%' order by date(prop2.value) asc " ) 15 +#end 18 18 ## execute query 19 - 17 +#set( $eventsFound = $xwiki.search($query) ) 20 20 ## 21 - 19 +#if( $eventsFound.size() > 0 ) 22 22 >{{stringEngIta eng="Forthcoming Events" ita="Eventi in arrivo"/}} 23 23 24 - #foreach($event in $eventsFound) 25 - #set( $eventDoc = $xwiki.getDocument($event) ) 26 -#if( !$foreach.first ){{themeTextSecondary}}•{{/themeTextSecondary}} #end## 27 -{{eventAcronym}}$eventDoc{{/eventAcronym}} (% style='color:$theme.textPrimaryColor' %)({{eventDates}}$eventDoc{{/eventDates}}) #end 22 + #foreach($event in $eventsFound) 23 + #set( $eventDoc = $xwiki.getDocument($event) ) 24 +#if( !$foreach.first ){{themeTextSecondary}}•{{/themeTextSecondary}} #end{{event short="true"}}$eventDoc{{/event}} #end 28 28 (%%) 29 - #end 30 30 #end 31 31 {{/velocity}}