Changes for page Forthcoming

Summary

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

Details

Page properties

Content

...	...	@@ -1,27 +1,38 @@
1	1	= {{italiano}}In arrivo{{/italiano}}{{english}}Forthcoming{{/english}} =
2	2
3		-{{include reference="Macros.Velocity" excludeFirstHeading="true"/}}{{include reference="Events.Environment" excludeFirstHeading="true"/}}{{velocity}}
4		-## set page display
5		-#noshortcuts()
6		-#set( $eventMenu = true )
7		-##
	3	+{{include reference="Events.Environment" excludeFirstHeading="true"/}}{{velocity}}
8	8	#if( !$userName || $userName == "" || !$userSpace || $userSpace == "" || !$userFullname || $userFullname == "" )
9	9	## overall forthcoming events
10		- #set( $query = "select doc.fullName from XWikiDocument doc, BaseObject obj, DateProperty as prop
11		- where doc.fullName = obj.name and obj.className = '$objectSpace.$objectClass' and obj.name <> '$objectSpace.$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 " )
	6	+ #set( $sql = "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 = '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 ")
	8	+ #set( $eventFound = $xwiki.search($sql) )
	9	+ #foreach($event in $eventFound)
	10	+ #set( $eventDoc = $xwiki.getDocument($event) )
	11	+#if( !$foreach.first ){{themeTextSecondary}}•{{/themeTextSecondary}} #end##
	12	+{{eventAcronym}}$eventDoc{{/eventAcronym}} (% style='color:$theme.textPrimaryColor' %)({{eventDates}}$eventDoc{{/eventDates}}) #end
	13	+(%%)
12	12	#else
13		- #set( $query = "select doc.fullName from XWikiDocument doc, BaseObject as obj0, BaseObject as obj1, LargeStringProperty as prop1, DateProperty as prop2
	15	+## user forthcoming events old
	16	+ #set( $query = "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, LargeStringProperty as prop8
	17	+ where doc.fullName = obj.name and obj.className = '$objectSpace.$objectClass' and obj.name <> '$objectSpace.$objectTemplate' 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 prop8.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 = 'spc_member' and prop6.name = 'organiser' and prop7.name = 'lecturer' and prop8.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%' or prop8.value like '%$userName%' ) order by date(prop.value) asc ")
	18	+ #set( $eventsFound = $xwiki.search($query) )
	19	+## user forthcoming events new
	20	+ #set( $query = ", BaseObject as obj0, BaseObject as obj1, LargeStringProperty as prop1, DateProperty as prop2
14	14	where obj0.name = doc.fullName and obj0.className = '${objectSpace}.${objectClass}' and obj0.name <> '${objectSpace}.${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 " )
15		-#end
16		-## execute query
17		-#set( $eventsFound = $xwiki.search($query) )
	22	+## execute query new
	23	+ #set( $eventsFoundNew = $xwiki.searchDocuments($query) )
	24	+ #if( $eventsFoundNew.size() > 0 )
	25	+ #set( $discard = $eventsFound.addAll($eventsFoundNew) )
	26	+ #end
18	18	##
19		-#if( $eventsFound.size() > 0 )
	28	+ #if( $eventsFound.size() > 0 )
20	20	>{{stringEngIta eng="Forthcoming Events" ita="Eventi in arrivo"/}}
21	21
22		- #foreach($event in $eventsFound)
23		- #set( $eventDoc = $xwiki.getDocument($event) )
24		-#if( !$foreach.first ){{themeTextSecondary}}•{{/themeTextSecondary}} #end{{event short="true"}}$eventDoc{{/event}} #end
	31	+ #foreach($event in $eventsFound)
	32	+ #set( $eventDoc = $xwiki.getDocument($event) )
	33	+#if( !$foreach.first ){{themeTextSecondary}}•{{/themeTextSecondary}} #end##
	34	+{{eventAcronym}}$eventDoc{{/eventAcronym}} (% style='color:$theme.textPrimaryColor' %)({{eventDates}}$eventDoc{{/eventDates}}) #end
25	25	(%%)
	36	+ #end
26	26	#end
27	27	{{/velocity}}