Modifiche per il documento In arrivo

Summary

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

Details

Page properties

Content

...	...	@@ -4,7 +4,7 @@
4	4	#if( !$userName || $userName == "" || !$userSpace || $userSpace == "" || !$userFullname || $userFullname == "" )
5	5	## overall forthcoming events
6	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 <> 'Events.Template' 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 ")
	7	+ where doc.fullName = obj.name and obj.className = 'Events.Class' and obj.name <> 'Events.Template' 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	8	#set( $eventFound = $xwiki.search($sql) )
9	9	#foreach($event in $eventFound)
10	10	#set( $eventDoc = $xwiki.getDocument($event) )