Changes for page Forthcoming
From version 24.1
edited by Andrea Omicini
on 03/12/2021 18:38
on 03/12/2021 18:38
Change comment:
There is no comment for this version
To version 24.3
edited by Andrea Omicini
on 03/01/2022 23:52
on 03/01/2022 23:52
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -2,7 +2,7 @@ 2 2 #if( !$userName || $userName == "" || !$userSpace || $userSpace == "" || !$userFullname || $userFullname == "" ) 3 3 ## overall forthcoming events 4 4 #set( $sql = "select doc.fullName from XWikiDocument doc, BaseObject obj, DateProperty as prop 5 - where doc.fullName = obj.name and obj.className = 'Events.EventClass' and obj.name <> 'Events.EventTemplate' 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) desc ")5 + where doc.fullName = obj.name and obj.className = 'Events.EventClass' and obj.name <> 'Events.EventTemplate' 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 ") 6 6 #set( $eventFound = $xwiki.search($sql) ) 7 7 #foreach($event in $eventFound) 8 8 #set( $eventDoc = $xwiki.getDocument($event) ) ... ... @@ -12,7 +12,7 @@ 12 12 #else 13 13 ## user forthcoming events 14 14 #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 15 - where doc.fullName=obj.name and obj.className='Events.EventClass' and obj.name <> 'Events.EventClassTemplate' 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 ")15 + where doc.fullName=obj.name and obj.className='Events.EventClass' and obj.name <> 'Events.EventClassTemplate' 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) desc ") 16 16 #set( $eventsFound = $xwiki.search($sql) ) 17 17 #if( $eventsFound.size() > 0 ) 18 18 >{{stringEngIta eng="Forthcoming Events" ita="Eventi in arrivo"/}}