Changes for page Deadlines
From version 62.1
edited by Andrea Omicini
on 24/04/2023 01:08
on 24/04/2023 01:08
Change comment:
There is no comment for this version
To version 66.1
edited by Andrea Omicini
on 25/04/2023 02:56
on 25/04/2023 02:56
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -1,16 +1,13 @@ 1 1 = {{italiano}}Scadenze{{/italiano}}{{english}}Deadlines{{/english}} = 2 2 3 -{{include reference="Macros.Velocity" excludeFirstHeading="true"/}}{{include reference="Events.Environment" excludeFirstHeading="true"/}}{{velocity}} 4 -## set page display 5 -#set( $eventMenu = true ) 6 -## 3 +{{include reference="Events.Environment" excludeFirstHeading="true"/}}{{velocity}} 7 7 #if( !$userName || $userName == "" || !$userSpace || $userSpace == "" || !$userFullname || $userFullname == "" ) 8 8 ## overall incoming deadlines 9 9 #set( $query = "select doc.fullName from XWikiDocument doc, BaseObject obj, DateProperty as prop 10 - where doc.fullName = obj.name and obj.className = '$objectSpace.$objectClass' and obj.name <> '$object Space.$objectTemplate' and prop.id.id = obj.id and prop.name = 'paper_submission' 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 + where doc.fullName = obj.name and obj.className = '${objectSpace}.${objectClass}' and obj.name <> '${objectPool}.${objectTemplate}' and prop.id.id = obj.id and prop.name = 'paper_submission' 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 ") 11 11 #else 12 12 #set( $query = "select doc.fullName from XWikiDocument doc, BaseObject obj, BaseObject as obj1, LargeStringProperty as prop1, DateProperty as prop 13 - where doc.fullName = obj.name and obj.className = '$objectSpace.$objectClass' and obj.name <> '$object Space.$objectTemplate' and prop.id.id = obj.id and prop.name = 'paper_submission' 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 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(prop.value) asc " )10 + where doc.fullName = obj.name and obj.className = '${objectSpace}.${objectClass}' and obj.name <> '${objectPool}.${objectTemplate}' and prop.id.id = obj.id and prop.name = 'paper_submission' 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 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(prop.value) asc " ) 14 14 #end 15 15 ## execute query 16 16 #set( $eventsFound = $xwiki.search($query) )