Changes for page Deadlines
From version 68.1
edited by Andrea Omicini
on 27/04/2023 08:29
on 27/04/2023 08:29
Change comment:
There is no comment for this version
To version 71.3
edited by Andrea Omicini
on 12/05/2023 18:08
on 12/05/2023 18:08
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -1,20 +1,20 @@ 1 1 = {{italiano}}Scadenze{{/italiano}}{{english}}Deadlines{{/english}} = 2 2 3 3 {{include reference="Events.Environment" excludeFirstHeading="true"/}}{{velocity}} 4 -#if( !$userName || $userName == "" || !$userSpace || $userSpace == "" || !$userFullname || $userFullname == "" ) 5 -## overall incoming deadlines 6 - #set( $query = "select doc.fullName from XWikiDocument doc, BaseObject obj, DateProperty as propDate 7 - where doc.fullName = obj.name and obj.className = '${objectSpace}.${objectClass}' and obj.name <> '${objectPool}.${objectTemplate}' and propDate.id.id = obj.id and propDate.name = 'paper_submission' and date(propDate.value) > current_date() order by date(propDate.value) asc ") 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 = '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 ") 4 +#if( !$userName || $userName == "" || !$userSpace || $userSpace == "" ) 5 + #set( $oneUser = false ) 9 9 #else 10 - #set( $ query = "select doc.fullName from XWikiDocument doc, BaseObject obj, BaseObject as obj1, LargeStringPropertyasprop1, DatePropertyas prop11 - 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 andprop1.name='who' and prop1.value like '%$userName%' order by date(prop.value) asc" )7 + #set( $oneUser = true ) 8 + #set( $userString = "%$userName%" ) 12 12 #end 10 +## overall incoming deadlines 11 +#set( $query = ", BaseObject objEvent, DateProperty as propDate #if( $oneUser), BaseObject as objRole, LargeStringProperty as propWho #end 12 + where doc.fullName = objEvent.name and objEvent.className = '${objectSpace}.${objectClass}' and objEvent.name <> '${objectPool}.${objectTemplate}' and propDate.id.id = objEvent.id and propDate.name = 'paper_submission' and date(propDate.value) > current_date() #if( $oneUser) 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 '$userString' #end order by date(propDate.value) asc ") 13 13 ## execute query 14 -#set( $eventsFound = $xwiki.search($query) ) 14 +#set( $eventsFound = $xwiki.searchDocuments($query) ) 15 15 ## 16 16 #if( $eventsFound.size() > 0 ) 17 ->{{stringEngIta eng=" IncomingDeadlines" ita="Prossime scadenze"/}}17 +>{{stringEngIta eng="incoming deadlines" ita="prossime scadenze"/}} 18 18 19 19 #foreach($event in $eventsFound) 20 20 #set( $eventDoc = $xwiki.getDocument($event) ) ... ... @@ -21,4 +21,4 @@ 21 21 #if( !$foreach.first ) {{themeTextSecondary}}•{{/themeTextSecondary}} #end## 22 22 {{eventAcronymAt}}$eventDoc{{/eventAcronymAt}} {{themeTextPrimary}}({{eventWhen}}$eventDoc{{/eventWhen}}){{/themeTextPrimary}}#if( $eventDoc.display("paper_submission") != "" ){{themeTextSecondary}} – {{/themeTextSecondary}}#if( $eventDoc.display("abstract_submission") != "" )$eventDoc.display("abstract_submission") {{themeTextPrimary}}//(abstract)//{{/themeTextPrimary}}{{themeTextSecondary}} / {{/themeTextSecondary}}#end$eventDoc.display("paper_submission") {{themeTextPrimary}}//(submission)//{{/themeTextPrimary}}#end(%%)#end 23 23 #end 24 -{{/velocity}}{{noShortcuts/}} 24 +{{/velocity}}{{noShortcuts/}}{{noTagFooter/}}