Changes for page Forthcoming

From version 49.2
edited by Andrea Omicini
on 12/05/2023 17:57
Change comment: There is no comment for this version
To version 46.5
edited by Andrea Omicini
on 06/05/2023 16:14
Change comment: There is no comment for this version

Summary

Details

Page properties
Title
... ... @@ -1,1 +1,0 @@
1 -$services.localization.render('forthcoming')
Hidden
... ... @@ -1,1 +1,1 @@
1 -true
1 +false
Content
... ... @@ -1,12 +1,14 @@
1 += {{italiano}}In arrivo{{/italiano}}{{english}}Forthcoming{{/english}} =
2 +
1 1  {{include reference="Events.Environment" excludeFirstHeading="true"/}}{{velocity}}
2 2  ##
3 3  #if( !$userName || $userName == "" || !$userSpace || $userSpace == "" || !$userFullname || $userFullname == "" )
4 4  ## overall forthcoming events
5 - #set( $query = ", BaseObject objEvent, DateProperty as propDate
6 - where doc.fullName = objEvent.name and objEvent.className = '${objectSpace}.${objectClass}' and objEvent.name <> '${objectPool}.${objectTemplate}' and propDate.id.id = objEvent.id and propDate.name = 'start_date' and propDate.value > current_date() order by propDate.value asc " )
7 + #set( $query = ", BaseObject obj, DateProperty as prop
8 + where doc.fullName = obj.name and obj.className = '${objectSpace}.${objectClass}' and obj.name <> '${objectPool}.${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 " )
7 7  #else
8 - #set( $query = ", BaseObject as objEvent, BaseObject as objRole, LargeStringProperty as propWho, DateProperty as propDate
9 - where objEvent.name = doc.fullName and objEvent.className = '${objectSpace}.${objectClass}' and objEvent.name <> '${objectPool}.${objectTemplate}' and propDate.id.id = objEvent.id and propDate.name = 'start_date' and propDate.value > current_date() and objRole.name = doc.fullName and objRole.className = '${objectSpace}.Roles.${objectClass}' and propWho.id.id = objRole.id and propWho.name = 'who' and propWho.value like '%$userName%' order by propDate.value asc " )
10 + #set( $query = ", BaseObject as obj0, BaseObject as obj1, LargeStringProperty as prop1, DateProperty as prop2
11 + where obj0.name = doc.fullName and obj0.className = '${objectSpace}.${objectClass}' and obj0.name <> '${objectPool}.${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 " )
10 10  #end
11 11  ## execute query
12 12  #set( $eventsFound = $xwiki.searchDocuments($query) )
... ... @@ -16,7 +16,7 @@
16 16  
17 17   #foreach($event in $eventsFound)
18 18   #set( $eventDoc = $xwiki.getDocument($event) )
19 -#if( !$foreach.first ){{themeTextSecondary}} • {{/themeTextSecondary}} #end#if( $eventDoc.getValue('sort') != 'special issue' ){{event short="true"}}$eventDoc{{/event}}#{else}{{event short="title" linked="title"}}$eventDoc{{/event}}#end #end
21 +#if( !$foreach.first ){{themeTextSecondary}}•{{/themeTextSecondary}} #end#if( $eventDoc.getValue('sort') != 'special issue' ){{event short="true"}}$eventDoc{{/event}}#{else}{{event short="title" linked="title"}}$eventDoc{{/event}}#end #end
20 20  (%%)
21 21  #end
22 -{{/velocity}}{{noShortcuts/}}{{noTagFooter/}}
24 +{{/velocity}}{{noShortcuts/}}