Changes for page Forthcoming

Summary

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

Details

Page properties

Content

...	...	@@ -5,10 +5,49 @@
5	5	#stop
6	6	#end
7	7	##
8		-* [[{{stringEngIta eng="all events" ita="tutte gli eventi"/}}>>${userSpace}.EventsPerYear||queryString="from=$firstYearEv&to=$lastYearEv"]] {{stringEngIta eng="sorted by year" ita="ordinati per anno"/}}
9		-##
10		-#set( $yearRange = [$lastYearEv..$firstYearEv] )
11		-* {{stringEngIta eng="events in" ita="eventi del"/}}
12		-#foreach( $year in $yearRange )
13		-#if( $velocityCount > 1 ),#end[[$year>>${userSpace}.EventsPerYear||queryString='year=$year']]#end
	8	+>{{stringEngIta eng="Forthcoming Events" ita="Eventi in arrivo"/}}
	9	+
	10	+#set($sql = "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
	11	+ where doc.fullName=obj.name and
	12	+ obj.className='Events.EventClass' and
	13	+ obj.name <> 'Events.EventClassTemplate' and
	14	+ obj.name <> 'Events.Template' and
	15	+ prop.id.id=obj.id and
	16	+ prop1.id.id=obj.id and
	17	+ prop2.id.id=obj.id and
	18	+ prop3.id.id=obj.id and
	19	+ prop4.id.id=obj.id and
	20	+ prop5.id.id=obj.id and
	21	+ prop6.id.id=obj.id and
	22	+ prop7.id.id=obj.id and
	23	+ prop.name='start_date' and
	24	+ prop1.name='general_chair' and
	25	+ prop2.name='program_chair' and
	26	+ prop2.name='program_chair' and
	27	+ prop3.name='organising_chair' and
	28	+ prop4.name='pc_member' and
	29	+ prop5.name='organiser' and
	30	+ prop6.name='lecturer' and
	31	+ prop7.name='other_role_player_1' and
	32	+ ( ( year(prop.value) > year(current_date()) ) or
	33	+ ( year(prop.value) = year(current_date()) and
	34	+ month(prop.value) > month(current_date()) ) or
	35	+ ( year(prop.value) = year(current_date()) and
	36	+ month(prop.value) = month(current_date()) and
	37	+ day(prop.value) > day(current_date()) ) ) and
	38	+ ( prop1.value like '%$userName%' or
	39	+ prop2.value like '%$userName%' or
	40	+ prop3.value like '%$userName%' or
	41	+ prop4.value like '%$userName%' or
	42	+ prop5.value like '%$userName%' or
	43	+ prop6.value like '%$userName%' or
	44	+ prop7.value like '%$userName%' )
	45	+ order by date(prop.value) desc
	46	+")
	47	+#set( $eventsFound = $xwiki.search($sql) )
	48	+#foreach( $event in $eventsFound )
	49	+ #set( $eventDoc = $xwiki.getDocument($event) )
	50	+ #set( $eventObj = $eventDoc.getObject("Events.EventClass") )
	51	+ * [[$eventDoc.acronym>>$item]] //($eventDoc.display('start_date')#if( $eventDoc.display('end_date') != '' )—$eventDoc.display('end_date')#end)//
	52	+#end
14	14	{{/velocity}}