Changes for page Per Year

Summary

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

Details

Page properties

Content

...	...	@@ -1,15 +1,24 @@
1	1	{{include reference="Theses.Environment"/}}{{include reference="Environment"/}}{{velocity}}
2	2	#set( $thesisMenu = true )
3		-#set( $oneYear = false )
4		-#set( $selectedYear = '' )
5		-### START YEAR
6		-## year parameter
7		-#set( $yearPar = $mathtool.toInteger($request.year) )
8		-#set( $fromPar = $mathtool.toInteger($request.from) )
9		-#set( $toPar = $mathtool.toInteger($request.to) )
	3	+## get environment variables & derived
10	10	#set( $firstYear = $mathtool.toInteger($firstYearTh) )
11	11	#set( $lastYear = $mathtool.toInteger($lastYearTh) )
12	12	#set( $yearList = [$lastYear..$firstYear] )
	7	+### START YEAR
	8	+## defaults
	9	+#set( $oneYear = false )
	10	+#set( $selectedYear = '' )
	11	+## year parameters
	12	+#if( $request.year )
	13	+ #set( $yearPar = $mathtool.toInteger($request.year) )
	14	+#end
	15	+#if( $request.from )
	16	+ #set( $fromPar = $mathtool.toInteger($request.from) )
	17	+#end
	18	+#if( $request.to )
	19	+ #set( $toPar = $mathtool.toInteger($request.to) )
	20	+#end
	21	+##set years
13	13	#if( $yearPar > 0 )
14	14	#set( $oneYear = true )
15	15	#set( $firstYear = $yearPar )
...	...	@@ -34,17 +34,21 @@
34	34	#set( $yearList = [$lastYear..$firstYear] )
35	35	#end
36	36	#end
	46	+## $selectedYear, $yearList and $oneYear set properly
37	37	### END YEAR
38	38	##
39		-### START USER & CYCLE
40		-#set( $userNamePar = $request.user.trim() )
	49	+### START USER
41	41	## default values
42	42	#set( $oneUser = false )
43		-#set( $oneCycle = false )
	52	+#set( $selectedUser = '' )
44	44	#set( $userFirstName = "" )
45	45	#set( $userLastName = "" )
	55	+## user parameter
	56	+#if( $request.user )
	57	+ #set( $userNamePar = $request.user.trim() )
	58	+#end
46	46	#if( $userName || $userNamePar )
47		-## a user is specified for all roles
	60	+## try to specify a user
48	48	#if( !$userName )
49	49	#set( $selectedUser = "XWiki.$userNamePar" )
50	50	#else
...	...	@@ -59,28 +59,43 @@
59	59	{{warning}} $selectedUser is not an {{apice/}} user{{/warning}}
60	60	#stop
61	61	#end
62		-##user selected and existing user page
	75	+#end
	76	+## $selectedUser and $oneUser set properly
	77	+### END USER
	78	+##
	79	+### START CYCLE
	80	+#set( $oneCycle = false )
	81	+#set( $selectedCycle = '' )
	82	+## cycle parameter
	83	+#if( $request.cycle )
63	63	#set( $cyclePar = $request.cycle.trim().toUpperCase() )
64		- #set( $selectedCycle = '' )
65		- #if( $cyclePar != '' && $allThesisCycles.contains($cyclePar) )
66		- #set( $oneCycle = true )
67		- #set( $selectedCycle = $cyclePar )
68		- #end
69	69	#end
70		-## $oneUser and $oneCycle set properly
	86	+## set cycle
	87	+#if( $cyclePar != '' && $allThesisCycles.contains($cyclePar) )
	88	+ #set( $oneCycle = true )
	89	+ #set( $selectedCycle = $cyclePar )
	90	+#end
	91	+## $selectedCycle and $oneCycle set properly
	92	+### END CYCLE
71	71	#if( $oneYear )
72	72	$selectedYear
	95	+#else
	96	+ $yearList
73	73	#end
74	74	#if( $oneUser )
75	75	$selectedUser
	100	+#else
	101	+ ALL USERS
76	76	#end
77	77	#if( $oneCycle )
78	78	$selectedCycle
	105	+#else
	106	+ ALL USERS
79	79	#end
80	80	### END USER & CYCLE
81	81	##
82	82	## title
83		->#if( $oneRole ){{thesisCycle short='no'}}$selecteCycle{{/thesisCycle}}#else{{stringEngIta eng="Theses" ita="Tesi"/}}#end / #if( $oneYear )$selectedYear#else$firstYear–$lastYear#end#if( $oneUser ) / $userFirstName **$userLastName**#end{{id name='top'/}}
	111	+>#if( $oneCycle ){{thesisCycle uppercase='yes' short='no'}}$selectedCycle{{/thesisCycle}}#else{{stringEngIta eng="Theses" ita="Tesi"/}}#end / #if( $oneYear )$selectedYear#else$firstYear–$lastYear#end#if( $oneUser ) / $userFirstName **$userLastName**#end{{id name='top'/}}
84	84	## index
85	85	#if( !$oneYear )
86	86	(% style="font-size: smaller; padding:1em 1.5em 0.25em 1.5em; background-color:$theme.highlightColor" %)(((#foreach( $year in $yearList )#if ($velocityCount > 1) | #end[[$year>>||anchor="$year"]]#end)))
...	...	@@ -101,13 +101,14 @@
101	101	#if( !$oneCycle || $selectedCycle == $cycle )
102	102	## some selected cycle or all cycles / now $cycle
103	103	#if( $oneUser)
104		- #set ($sql = ", BaseObject as obj, StringProperty as prop0, DateProperty as prop1, LargeStringProperty as prop2, LargeStringProperty as prop3, LargeStringProperty as prop4
105		- where obj.name = doc.fullName and obj.className = 'Theses.ThesisClass' and obj.name <> 'Theses.ThesisClassTemplate' and obj.name <> 'Theses.ThesisTemplate' and prop0.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 prop0.name = 'cycle' and prop1.name = 'year' and prop2.name = 'supervisors' and prop3.name = 'cosupervisors' and prop4.name = 'contacts' and prop0.value = '$cycle' and year(prop1.value) = '$year' and ( prop2.value like '%$selectedUser%' or prop3.value like '%$selectedUser%' or prop4.value like '%$selectedUser%' ) order by prop1.value desc" )
	132	+ #set ($sql = ", BaseObject as obj, StringProperty as prop0, DateProperty as prop1, StringProperty as prop2, LargeStringProperty as prop3, LargeStringProperty as prop4, LargeStringProperty as prop5
	133	+ where obj.name = doc.fullName and obj.className = 'Theses.ThesisClass' and obj.name <> 'Theses.ThesisClassTemplate' and obj.name <> 'Theses.ThesisTemplate' and prop0.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 prop4.id.id = obj.id and prop0.name = 'cycle' and prop1.name = 'year' and prop2.name = 'status' and prop3.name = 'supervisors' and prop4.name = 'cosupervisors' and prop5.name = 'contacts' and prop0.value = '$cycle' and year(prop1.value) = '$year' and prop2.value = 'Completed' and ( prop3.value like '%$selectedUser%' or prop4.value like '%$selectedUser%' or prop5.value like '%$selectedUser%' ) order by prop1.value desc" )
106	106	#else
107		- #set ($sql = ", BaseObject as obj, StringProperty as prop0, DateProperty as prop1
108		- where obj.name = doc.fullName and obj.className = 'Theses.ThesisClass' and obj.name <> 'Theses.ThesisClassTemplate' and obj.name <> 'Theses.ThesisTemplate' and prop0.id.id = obj.id and prop1.id.id = obj.id and prop0.name = 'cycle' and prop1.name = 'year' and prop0.value = '$cycle' and year(prop1.value) = '$year' order by prop1.value desc" )
	135	+ #set ($sql = ", BaseObject as obj, StringProperty as prop0, DateProperty as prop1, StringProperty as prop2
	136	+ where obj.name = doc.fullName and obj.className = 'Theses.ThesisClass' and obj.name <> 'Theses.ThesisClassTemplate' and obj.name <> 'Theses.ThesisTemplate' and prop0.id.id = obj.id and prop1.id.id = obj.id and prop2.id.id = obj.id and prop0.name = 'cycle' and prop1.name = 'year' and prop2.name = 'status' and prop0.value = '$cycle' and year(prop1.value) = '$year 'and prop2.value = 'Completed' order by prop1.value desc" )
109	109	#end
110	110	#set( $thesisFound = $xwiki.searchDocuments($sql) )
	139	+$sql
111	111	#set( $thesisFoundNo = $thesisFound.size() )
112	112	#set( $thesisYearCycleNo = $thesisYearCycleNo + $thesisFoundNo )
113	113	#if( $thesisFoundNo > 0 && !$oneCycle )