Changes for page Deadlines

Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -1,24 +1,11 @@
1	1	= {{italiano}}Prossime scadenze{{/italiano}}{{english}}Incoming 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 prop
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 = '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 ")
8		-#else
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 <> '$objectSpace.$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(prop2.value) asc " )
11		-#end
12		-## execute query
13		-#set( $eventsFound = $xwiki.search($query) )
14		-##
15		-#if( $eventsFound.size() > 0 )
16		->{{stringEngIta eng="Incoming Deadlines" ita="Prossime scadenze"/}}
17		-
18		- #foreach($event in $eventsFound)
19		- #set( $eventDoc = $xwiki.getDocument($event) )
	4	+#set( $sql = "select doc.fullName from XWikiDocument doc, BaseObject obj, DateProperty as prop
	5	+ where doc.fullName = obj.name and obj.className = '$objectSpace.$objectClass' and obj.name <> '$objectSpace.$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 ")
	6	+#set( $eventFound = $xwiki.search($sql) )
	7	+#foreach( $event in $eventFound )
	8	+ #set( $evDoc = $xwiki.getDocument($event) )
20	20	#if( !$foreach.first ){{themeTextSecondary}}•{{/themeTextSecondary}} #end##
21		-{{eventAcronym}}$eventDoc{{/eventAcronym}} {{themeTextPrimary}}({{eventDates}}$eventDoc{{/eventDates}}){{/themeTextPrimary}}#if( $eventDoc.display("paper_submission") != "" ){{themeTextSecondary}} – {{/themeTextSecondary}}$eventDoc.display("paper_submission") {{themeTextPrimary}}//(submission)//{{/themeTextPrimary}}#if( $eventDoc.display("abstract_submission") != "" ){{themeTextSecondary}} / {{/themeTextSecondary}}$eeventDocvDoc.display("abstract_submission") {{themeTextPrimary}}//(abstract)//{{/themeTextPrimary}}#end #end
22		-(%%)
23		-#end#end
	10	+{{eventAcronym}}$evDoc{{/eventAcronym}} {{themeTextPrimary}}({{eventDates}}$evDoc{{/eventDates}}){{/themeTextPrimary}}#if( $evDoc.display("paper_submission") != "" ){{themeTextSecondary}} – {{/themeTextSecondary}}$evDoc.display("paper_submission") {{themeTextPrimary}}//(submission)//{{/themeTextPrimary}}#if( $evDoc.display("abstract_submission") != "" ){{themeTextSecondary}} / {{/themeTextSecondary}}$evDoc.display("abstract_submission") {{themeTextPrimary}}//(abstract)//{{/themeTextPrimary}}#end #end(%%)#end
24	24	{{/velocity}}