Changes for page Per Year

From version 26.1
edited by Andrea Omicini
on 25/10/2021 17:53
Change comment: There is no comment for this version
To version 97.1
edited by Andrea Omicini
on 30/10/2021 16:42
Change comment: There is no comment for this version

Summary

Details

Page properties
Title
... ... @@ -1,1 +1,1 @@
1 -Theses per Status
1 +#if($xcontext.language=='it')Tesi per anno#{else}Theses per Year#end
Content
... ... @@ -1,142 +1,131 @@
1 1  {{include reference="Theses.Environment"/}}{{include reference="Environment"/}}{{velocity}}
2 2  #set( $thesisMenu = true )
3 -#### get parameters
4 -## hypothesis: $thesisStatus set, default "Completed"
5 -## status parameter
6 -#set( $statusPar = $request.status.trim().toLowerCase() )
7 -#if( $statusPar != '' && $allThesisStatuses.contains($statusPar) )
8 - #set( $selectedStatus = $statusPar )
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) )
10 +#set( $firstYear = $mathtool.toInteger($firstYearTh) )
11 +#set( $lastYear = $mathtool.toInteger($lastYearTh) )
12 +#set( $yearList = [$lastYear..$firstYear] )
13 +#if( $yearPar > 0 )
14 + #set( $oneYear = true )
15 + #set( $firstYear = $yearPar )
16 + #set( $lastYear = $yearPar )
17 + #set( $selectedYear = $yearPar )
18 + #set( $yearList = [$yearPar] )
9 9  #else
10 - #set( $selectedStatus = 'all' )
20 + #if( $fromPar != '' && ($fromPar > $firstYear) )
21 + #set( $firstYear = $fromPar )
22 + #set( $yearList = [$lastYear..$firstYear] )
23 + #end
24 + #if( $toPar != '' && ($toPar < $lastYear) )
25 + #set( $lastYear = $toPar )
26 + #set( $yearList = [$lastYear..$firstYear] )
27 + #end
28 + #if( $lastYear <= $firstYear )
29 + #set( $oneYear = true )
30 + #set( $lastYear = $firstYear )
31 + #set( $selectedYear = $firstYear )
32 + #set( $yearList = [$firstYear] )
33 + #else
34 + #set( $yearList = [$lastYear..$firstYear] )
35 + #end
11 11  #end
12 -##check velocity variable, takes precedence
13 -#if( $thesisStatus && $thesisStatus != '' && $allThesisStatuses.contains($thesisStatus.trim().toLowerCase()) )
14 - #set( $selectedStatus = $thesisStatus.trim().toLowerCase() )
15 -#end
16 -## set ordering field
17 -#if( $selectedStatus == "available" )
18 - #set( $orderingDateFieldName = "availabilityDate" )
19 -#elseif( $selectedStatus == "ongoing" )
20 - #set( $orderingDateFieldName = "startDate" )
21 -#else
22 - #set( $orderingDateFieldName = "endDate" )
23 -#end
24 -## invariant: $thesisStatus set, $orderingDateFieldName set correspondingly
25 -## who
26 -#set( $userNamePar = $request.user )
27 -#set( $supervisorNamePar = $request.supervisor )
28 -#set( $cosupervisorNamePar = $request.cosupervisor )
29 -#set( $contactNamePar = $request.contact )
30 -#### set default values
31 -#set( $userSelected = false )
32 -#set( $roleSelected = false )
37 +$oneYear
38 +$yearList
39 +### END YEAR
40 +##
41 +### START USER & CYCLE
42 +#set( $userNamePar = $request.user.trim() )
43 +## default values
44 +#set( $oneUser = false )
45 +#set( $oneCycle = false )
33 33  #set( $userFirstName = "" )
34 34  #set( $userLastName = "" )
35 -#set( $supervisorName = "" )
36 -#set( $supervisorFirstName = "" )
37 -#set( $supervisorLastName = "" )
38 -#set( $cosupervisorName = "" )
39 -#set( $cosupervisorFirstName = "" )
40 -#set( $cosupervisorLastName = "" )
41 -#set( $contactName = "" )
42 -#set( $contactFirstName = "" )
43 -#set( $contactLastName = "" )
44 -##
45 -#### handle who & roles
46 -##
47 -#if ( $userName || $userNamePar )
48 +#if( $userName || $userNamePar )
48 48  ## a user is specified for all roles
49 - #set( $userSelected = true )
50 - #if ( !$userName )#set( $userName = "XWiki.$userNamePar" )#end
51 - #set( $userdoc = $xwiki.getDocument($userName) )
52 - #set( $userFirstName = $userdoc.display("first_name") )
53 - #set( $userLastName = $userdoc.display("last_name") )
54 -#elseif ( $supervisorNamePar || $cosupervisorNamePar || $contactNamePar )
55 - #set( $roleSelected = true )
56 - #if ( $supervisorNamePar )
57 - #set( $supervisorName = "XWiki.$supervisorNamePar" )
58 - #set( $supervisordoc = $xwiki.getDocument($supervisorName) )
59 - #set( $supervisorFirstName = $supervisordoc.display("first_name") )
60 - #set( $supervisorLastName = $supervisordoc.display("last_name") )
50 + #if( !$userName )
51 + #set( $selectedUser = "XWiki.$userNamePar" )
52 + #else
53 + #set( $selectedUser = $userName )
61 61   #end
62 - #if ( $cosupervisorNamePar )
63 - #set( $cosupervisorName = "XWiki.$cosupervisorNamePar" )
64 - #set( $cosupervisordoc = $xwiki.getDocument($cosupervisorName) )
65 - #set( $cosupervisorFirstName = $cosupervisordoc.display("first_name") )
66 - #set( $cosupervisorLastName = $cosupervisordoc.display("last_name") )
55 + #if( $xwiki.exists($selectedUser) )
56 + #set( $oneUser = true )
57 + #set( $userdoc = $xwiki.getDocument($selectedUser) )
58 + #set( $userFirstName = $userdoc.display("first_name") )
59 + #set( $userLastName = $userdoc.display("last_name") )
60 + #else
61 +{{warning}} $selectedUser is not an {{apice/}} user{{/warning}}
62 + #stop
67 67   #end
68 - #if ( $contactNamePar )
69 - #set( $contactName = "XWiki.$contactNamePar" )
70 - #set( $contactdoc = $xwiki.getDocument($contactName) )
71 - #set( $contactFirstName = $contactdoc.display("first_name") )
72 - #set( $contactLastName = $contactdoc.display("last_name") )
64 +##user selected and existing user page
65 + #set( $cyclePar = $request.cycle.trim().toUpperCase() )
66 + #set( $selectedCycle = '' )
67 + #if( $cyclePar != '' && $allThesisCycles.contains($cyclePar) )
68 + #set( $oneCycle = true )
69 + #set( $selectedCycle = $cyclePar )
73 73   #end
74 74  #end
75 -#if( $supervisor )
76 - #set( $roleSelected = true )
77 - #set( $supervisorName = $userName )
78 - #set( $supervisordoc = $xwiki.getDocument($supervisorName) )
79 - #set( $supervisorFirstName = $supervisordoc.display("first_name") )
80 - #set( $supervisorLastName = $supervisordoc.display("last_name") )
81 -#end
82 -#if( $cosupervisor )
83 - #set( $roleSelected = true )
84 - #set( $cosupervisorName = $userName )
85 - #set( $cosupervisordoc = $xwiki.getDocument($cosupervisorName) )
86 - #set( $cosupervisorFirstName = $cosupervisordoc.display("first_name") )
87 - #set( $cosupervisorLastName = $cosupervisordoc.display("last_name") )
88 -#end
89 -#if( $contact )
90 - #set( $roleSelected = true )
91 - #set( $contactName = $userName )
92 - #set( $contactdoc = $xwiki.getDocument($contactName) )
93 - #set( $contactFirstName = $contactdoc.display("first_name") )
94 - #set( $contactLastName = $contactdoc.display("last_name") )
95 -#end
72 +## $oneUser and $oneCycle set properly
73 +$oneUser
74 +$oneCycle
75 +### END USER & CYCLE
96 96  ##
97 -#if( $cosupervisor )
98 - #set( $roleSelectedFieldName = "coSupervisors" )
99 -#elseif( $contact )
100 - #set( $roleSelectedFieldName = "contact" )
101 -#else
102 - #set( $roleSelectedFieldName = "supervisor" )
103 -#end
104 -##
105 -## $roleSelected has meaning only if $userSelected
106 -## if $userSelected, $roleSelected false means one user for all roles
107 -## if $userSelected, $roleSelected true means one specific role for one user selected
108 -## if $userSelected is false, $roleSelected means nothing -- so all users, all roles / just status
109 -#foreach( $status in $allThesisStatuses )
110 - #if( $selectedStatus == 'all' || $selectedStatus == $status )
111 -= $status =
112 -## some selected status or all statuses / now $status
113 - #if( $userSelected )
114 -== $userName ==
115 -## some user selected
116 - #if( $roleSelected )
117 -## some specific role selected
118 -=== $roleSelectedFieldName ===
119 - #set ($sql = ", BaseObject as obj, StringProperty as prop0, LargeStringProperty as prop1, DateProperty as prop2
120 - 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 = 'status' and prop1.name = '$roleSelectedFieldName' and prop2.name = '$orderingDateFieldName' and lower(prop0.value) = '$status' and prop1.value like '%$userName%' order by prop2.value desc" )
121 - #else
122 -## no specific role selected
123 - #set ($sql = ", BaseObject as obj, StringProperty as prop0, LargeStringProperty as prop1, LargeStringProperty as prop2, LargeStringProperty as prop3, DateProperty as prop4
124 - 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 = 'status' and prop1.name = 'supervisor' and prop2.name = 'coSupervisors' and prop3.name = 'contact' and prop4.name = '$orderingDateFieldName' and lower(prop0.value) = '$status' and ( prop1.value like '%$userName%' or prop2.value like '%$userName%' or prop3.value like '%$userName%' ) order by prop4.value desc" )
77 +## title
78 +>#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'/}}
79 +## index
80 +#if( !$oneYear )
81 +(% 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)))
82 +###elseif( $oneUser && !$oneCycle )
83 +#elseif( !$oneCycle )
84 +(% style="font-size: smaller; padding:1em 1.5em 0.25em 1.5em; background-color:$theme.highlightColor" %)(((#foreach( $cycle in $allThesisCycles )#if ($velocityCount > 1) | #end [[{{thesisCycle}}$cycle{{/thesisCycle}}>>||anchor="$cycle"]]#end)))
85 +#end{{id name='index'/}}
86 +## search theses
87 +#set( $thesisNo = 0 )
88 +#foreach( $year in $yearList )
89 + #if( !$oneYear || $selectedYear == $year )
90 + #set( $thesisYearNo = 0 )
91 + #if( !$oneYear )
92 +(% style="border-style:solid hidden hidden solid; border-color:$theme.borderColor; text-align:left; font-style:oblique" %)|{{id name='$year'/}}$year
93 + #end
94 +## some selected year or year list / now $year
95 + #foreach( $cycle in $allThesisCycles )
96 + #set( $thesisYearCycleNo = 0 )
97 + #if( !$oneCycle || $selectedCycle == $cycle )
98 +## some selected cycle or all cycles / now $cycle
99 + #if( $oneUser)
100 + #set ($sql = ", BaseObject as obj, StringProperty as prop0, DateProperty as prop1, LargeStringProperty as prop2, LargeStringProperty as prop3, LargeStringProperty as prop4
101 + 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 prop1.value = '$year' and ( prop2.value like '%$selectedUser%' || prop3.value like '%$selectedUser%' || prop4.value like '%$selectedUser%' ) order by prop2.value desc" )
102 + #else
103 + #set ($sql = ", BaseObject as obj, StringProperty as prop0, DateProperty as prop1
104 + 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 prop1.value = '$year' order by prop2.value desc" )
105 + #end
106 + #set( $thesisFound = $xwiki.searchDocuments($sql) )
107 + #set( $thesisFoundNo = $thesisFound.size() )
108 + #set( $thesisYearCycleNo = $thesisYearCycleNo + $thesisFoundNo )
109 + #if( $thesisFoundNo > 0 && !$oneCycle )
110 +(% style="border-style:#if( $oneYear )solid hidden hidden solid#{else}hidden hidden hidden dotted#end; border-color:$theme.borderColor; text-align:left; font-style:oblique; font-size:smaller" %)|#if( $oneYear ){{id name='$cycle'/}}#else{{id name='$year-$cycle'/}}#end{{thesisCycle plural='no' uppercase='yes' short='yes'}}$cycle{{/thesisCycle}}
111 + #end
112 + #foreach( $thesis in $thesisFound )
113 + #set( $thesisDoc = $xwiki.getDocument($thesis) )
114 + #set( $thesisObj = $thesisDoc.getObject('Theses.ThesisClass') )
115 +* [[$thesisObj.title>>$thesisDoc]]#if( $thesisObj.endDate != "" ) //($thesisObj.endDate)//#end#if( $thesisDoc.getValue('studentUserName') != "" ) [[$xwiki.getUserName($thesisDoc.getValue('studentUserName'), false)>>$thesisDoc.getValue('studentUserName')]]#elseif( $thesisObj.studentFirstName != "" && $thesisObj.studentLastName != "" ) $thesisObj.studentFirstName $thesisObj.studentLastName#end
116 +
117 + #end
118 + #if( $thesisFoundNo > 0 && !$oneCycle )
119 +(% style="border-style:#if( $oneYear )hidden solid solid hidden#{else}hidden dotted hidden hidden#end; border-color:$theme.borderColor; text-align:right; font-style:oblique; font-weight:normal; font-size:smaller; color:$theme.textSecondaryColor" %)|#if( $oneYear ){{id name='$cycle-bottom'/}}#else{{id name='$cycle-$year-bottom'/}}#end($thesisYearCycleNo #if( $thesisYearCycleNo == 1 ){{thesisCycle plural='no' uppercase='no' short='no'}}$cycle{{/thesisCycle}}#else{{thesisCycle plural='yes' uppercase='no' short='no'}}$cycle{{/thesisCycle}}#end {{stringEngIta eng='in' ita='nel'/}} $year [[[{{stringEngIta eng='top' ita='in cima'/}}]>>||anchor="top"]] [[[{{stringEngIta eng='bottom' ita='in fondo'/}}]>>||anchor="bottom"]]
120 + #end
121 + #end
122 + #set( $thesisYearNo = $thesisYearNo + $thesisYearCycleNo )
125 125   #end
126 - #else
127 -## no user selected, no role selected
128 - #set ($sql = ", BaseObject as obj, StringProperty as prop0, DateProperty as prop1
129 - 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 = 'status' and prop1.name = '$orderingDateFieldName' and lower(prop0.value) = '$status' order by prop1.value desc" )
130 130   #end
125 + #if( !$oneYear )
126 +(% style="border-style:hidden solid solid hidden; border-color:$theme.borderColor; text-align:right; font-style:oblique; font-weight:normal; font-size:smaller; color:$theme.textSecondaryColor" %)|($thesisYearNo #if($thesisYearNo == 1){{stringEngIta eng='thesis in' ita='tesi nel'/}}#else{{stringEngIta eng='theses in' ita='tesi nel'/}}#end$year{{id name='$year-bottom'/}}) [[[{{stringEngIta eng='top' ita='in cima'/}}]>>||anchor="top"]] [[[{{stringEngIta eng='bottom' ita='in fondo'/}}]>>||anchor="bottom"]]
127 + #end
131 131   #end
132 - $sql
133 - #set( $thesisFound = $xwiki.searchDocuments($sql) )
134 - #set( $thesisFoundNo = $thesisFound.size() )
135 - $thesisFoundNo
136 -##
137 - #foreach ($thesis in $thesisFound)#set($thesisDoc = $xwiki.getDocument($thesis))
138 -* [[$thesisDoc.getValue("title")>>$thesisDoc]]#thesisTitleLink($thesis)#if( $thesisDoc.getValue("studentUserName") != "" || $thesisDoc.getValue("studentName") != "" || ( $thesisDoc.getValue("studentFirstName") != "" && $thesisDoc.getValue("studentLastName") != "" ) ) //(#thesisAuthorLink($thesis)#if( $thesisDoc.display("endDate") != "" ), #thesisYear($thesis)#end)//#end
139 -
140 - #end
141 141  #end
130 +{{id name='bottom'/}}
142 142  {{/velocity}}