Changes for page Forthcoming
From version 28.1
edited by Andrea Omicini
on 22/06/2022 18:23
on 22/06/2022 18:23
Change comment:
There is no comment for this version
To version 39.1
edited by Andrea Omicini
on 01/04/2023 19:24
on 01/04/2023 19:24
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -1,27 +1,38 @@ 1 -= {{italiano}} Eventiinarrivo{{/italiano}}{{english}}ForthcomingEvents{{/english}} =1 += {{italiano}}In arrivo{{/italiano}}{{english}}Forthcoming{{/english}} = 2 2 3 3 {{include reference="Events.Environment" excludeFirstHeading="true"/}}{{velocity}} 4 4 #if( !$userName || $userName == "" || !$userSpace || $userSpace == "" || !$userFullname || $userFullname == "" ) 5 5 ## overall forthcoming events 6 6 #set( $sql = "select doc.fullName from XWikiDocument doc, BaseObject obj, DateProperty as prop 7 - where doc.fullName = obj.name and obj.className = ' Events.$objectClass' and obj.name <> 'Events.Template' and prop.id.id = obj.id and prop.name = 'start_date' and (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 8 #set( $eventFound = $xwiki.search($sql) ) 9 9 #foreach($event in $eventFound) 10 10 #set( $eventDoc = $xwiki.getDocument($event) ) 11 -# #*{{event}}$event{{/event}}12 - *{{eventAcronym}}$eventDoc{{/eventAcronym}} (% style='color:$theme.textPrimaryColor' %)({{eventDates}}$eventDoc{{/eventDates}})(%%)13 - #end11 +#if( !$foreach.first ){{themeTextSecondary}}•{{/themeTextSecondary}} #end## 12 +{{eventAcronym}}$eventDoc{{/eventAcronym}} (% style='color:$theme.textPrimaryColor' %)({{eventDates}}$eventDoc{{/eventDates}}) #end 13 +(%%) 14 14 #else 15 -## user forthcoming events 16 - #set($sql = "select doc.fullName from XWikiDocument doc, BaseObject obj, DateProperty as prop, LargeStringProperty as prop1, LargeStringProperty as prop2, LargeStringProperty as prop3, LargeStringProperty as prop4, LargeStringProperty as prop5, LargeStringProperty as prop6, LargeStringProperty as prop7 17 - where doc.fullName=obj.name and obj.className='Events.Class' and obj.name <> 'Events.Template' and prop.id.id=obj.id and prop1.id.id=obj.id and prop2.id.id=obj.id and prop3.id.id=obj.id and prop4.id.id=obj.id and prop5.id.id=obj.id and prop6.id.id=obj.id and prop7.id.id=obj.id and prop.name='start_date' and prop1.name='general_chair' and prop2.name='program_chair' and prop2.name='program_chair' and prop3.name='organising_chair' and prop4.name='pc_member' and prop5.name='organiser' and prop6.name='lecturer' and prop7.name='other_role_player_1' 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()) ) ) and ( prop1.value like '%$userName%' or prop2.value like '%$userName%' or prop3.value like '%$userName%' or prop4.value like '%$userName%' or prop5.value like '%$userName%' or prop6.value like '%$userName%' or prop7.value like '%$userName%' ) order by date(prop.value) asc ") 18 - #set( $eventsFound = $xwiki.search($sql) ) 15 +## user forthcoming events old 16 + #set( $query = "select doc.fullName from XWikiDocument doc, BaseObject obj, DateProperty as prop, LargeStringProperty as prop1, LargeStringProperty as prop2, LargeStringProperty as prop3, LargeStringProperty as prop4, LargeStringProperty as prop5, LargeStringProperty as prop6, LargeStringProperty as prop7, LargeStringProperty as prop8 17 + where doc.fullName = obj.name and obj.className = '$objectSpace.$objectClass' and obj.name <> '$objectSpace.$objectTemplate' and prop.id.id = obj.id and prop1.id.id = obj.id and prop2.id.id = obj.id and prop3.id.id = obj.id and prop4.id.id = obj.id and prop5.id.id = obj.id and prop6.id.id = obj.id and prop7.id.id = obj.id and prop8.id.id = obj.id and prop.name = 'start_date' and prop1.name = 'general_chair' and prop2.name = 'program_chair' and prop2.name = 'program_chair' and prop3.name = 'organising_chair' and prop4.name = 'pc_member' and prop5.name = 'spc_member' and prop6.name = 'organiser' and prop7.name = 'lecturer' and prop8.name = 'other_role_player_1' 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()) ) ) and ( prop1.value like '%$userName%' or prop2.value like '%$userName%' or prop3.value like '%$userName%' or prop4.value like '%$userName%' or prop5.value like '%$userName%' or prop6.value like '%$userName%' or prop7.value like '%$userName%' or prop8.value like '%$userName%' ) order by date(prop.value) asc ") 18 + #set( $eventsFound = $xwiki.search($query) ) 19 +## user forthcoming events new 20 + #set( $query = "select doc.fullName from XWikiDocument doc, BaseObject as obj0, BaseObject as obj1, LargeStringProperty as prop1, DateProperty as prop2 21 + 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 " ) 22 +## execute query new 23 + #set( $eventsFoundNew = $xwiki.searchDocuments($query) ) 24 + #if( $eventsFoundNew.size() > 0 ) 25 + #set( $discard = $eventsFound.addAll($eventsFoundNew) ) 26 + #end 27 +## 19 19 #if( $eventsFound.size() > 0 ) 20 20 >{{stringEngIta eng="Forthcoming Events" ita="Eventi in arrivo"/}} 21 - #foreach( $event in $eventsFound ) 30 + 31 + #foreach($event in $eventsFound) 22 22 #set( $eventDoc = $xwiki.getDocument($event) ) 23 -* {{eventAcronym}}$eventDoc{{/eventAcronym}} (% style='color:$theme.textPrimaryColor' %)({{eventDates}}$eventDoc{{/eventDates}})(%%) 24 - #end 33 +#if( !$foreach.first ){{themeTextSecondary}}•{{/themeTextSecondary}} #end## 34 +{{eventAcronym}}$eventDoc{{/eventAcronym}} (% style='color:$theme.textPrimaryColor' %)({{eventDates}}$eventDoc{{/eventDates}}) #end 35 +(%%) 25 25 #end 26 26 #end 27 27 {{/velocity}}