Changes for page Per A.Y.

From version 43.1
edited by Andrea Omicini
on 06/10/2022 01:27
Change comment: There is no comment for this version
To version 45.8
edited by Andrea Omicini
on 08/02/2023 00:37
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -20,7 +20,11 @@
20 20   #set( $userLastName = $userdoc.display("last_name") )
21 21  #elseif ( $userNamePar )
22 22  ## from the URL, "user=UserName" parameter
23 - #set( $userName = "XWiki.$userNamePar" )
23 + #if( $userNamePar.contains("XWiki.") )
24 + #set( $userName = $userNamePar )
25 + #else
26 + #set( $userName = "XWiki.$userNamePar" )
27 + #end
24 24   #set( $userdoc = $xwiki.getDocument($userName) )
25 25   #set( $userFirstName = $userdoc.display("first_name") )
26 26   #set( $userLastName = $userdoc.display("last_name") )
... ... @@ -36,7 +36,11 @@
36 36   #set( $professorLastName = $professordoc.display("last_name") )
37 37  #elseif ( $professorNamePar )
38 38  ## from the URL, "professor=UserName" parameter
39 - #set( $professorName = "XWiki.$professorNamePar" )
43 + #if( $professorNamePar.contains("XWiki.") )
44 + #set( $professorName = $professorNamePar )
45 + #else
46 + #set( $professorName = "XWiki.$professorNamePar" )
47 + #end
40 40   #set( $professordoc = $xwiki.getDocument($professorName) )
41 41   #set( $professorFirstName = $professordoc.display("first_name") )
42 42   #set( $professorLastName = $professordoc.display("last_name") )
... ... @@ -52,7 +52,11 @@
52 52   #set( $tutorLastName = $tutordoc.display("last_name") )
53 53  #elseif ( $tutorNamePar )
54 54  ## from the URL, "tutor=UserName" parameter
55 - #set( $tutorName = "XWiki.$tutorNamePar" )
63 + #if( $tutorNamePar.contains("XWiki.") )
64 + #set( $tutorName = $tutorNamePar )
65 + #else
66 + #set( $tutorName = "XWiki.$tutorNamePar" )
67 + #end
56 56   #set( $tutordoc = $xwiki.getDocument($tutorName) )
57 57   #set( $tutorFirstName = $tutordoc.display("first_name") )
58 58   #set( $tutorLastName = $tutordoc.display("last_name") )
... ... @@ -61,10 +61,27 @@
61 61   #set( $tutorFirstName = "" )
62 62   #set( $tutorLastName = "" )
63 63  #end
64 -## professor takes precedence over tutor
65 -#if( $professorName != "" )#set( $tutorName = "" )#end
76 +## who, in the end
77 +#set( $oneUser = false )
78 +#set( $oneProfessor = false )
79 +#set( $oneTutor = false )
80 +##
81 +#if( $userName != "" )
66 66  ## user takes precedence over both professor and tutor and gets them all
67 -#if( $userName != "" )#set( $professorName = $userName )#set( $tutorName = $userName )#end
83 + #set( $professorName = $userName )
84 + #set( $tutorName = $userName )
85 + #set( $oneUser = true )
86 +#elseif( $professorName != "" )
87 +## professor takes precedence over tutor
88 + #set( $tutorName = "@@" )
89 + #set( $userName = "@@" )
90 + #set( $oneProfessor = true )
91 +#elseif( $tutorName != "" )
92 +## just tutor
93 + #set( $professorName = "@@" )
94 + #set( $userName = "@@" )
95 + #set( $oneTutor = true )
96 +#end
68 68  ##
69 69  #if( $firstYearCou )#set( $firstYear = $firstYearCou )#end
70 70  #if( $lastYearCou )#set( $lastYear = $lastYearCou )#end
... ... @@ -106,29 +106,52 @@
106 106   #set($aYear = $year + "/" + $year1 )
107 107   #end
108 108  #end
109 ->{{stringEngIta eng = "Courses" ita = "Corsi"/}} / **#if( $oneYear )$aYear#else$lastAYear**–**$firstAYear#end**#if( $userName != "" ) / $userFirstName $userLastName#elseif( $professorName != "" ) / $professorFirstName $professorLastName#elseif( $tutorName != "" ) / $tutorFirstName $tutorLastName (tutor)#end{{id name="top"/}}
138 +#### HANDLE PARAMETERS / END
110 110  ##
111 -#if( !$oneYear )
112 -(% style="font-size: smaller; padding:1em 1.5em 0.25em 1.5em; background-color:$theme.highlightColor" %)(((#foreach ($yearr in $yearList)#set($yearr1 = $yearr + 1)#set($ayearr = "$yearr/$yearr1")#if( $foreach.index > 0 ) | #end[[$ayearr>>$doc||anchor=$yearr]]#end)))
113 -#end
114 -##
115 -#if( $services.localization.currentLocale == "it" )#set( $sortField = "ita")#else#set( $sortField = "eng")#end
140 +### query to structures
141 +## map & counter initialisation
142 +#set( $courseMap = {} )
116 116  #set( $courseNo = 0 )
144 +#if( $services.localization.currentLocale == "it" )#set( $sortField = "ita")#else#set( $sortField = "eng")#end
145 +##
146 +##
117 117  #foreach( $yearr in $yearList)#set($yearr1 = $yearr + 1)#set($ayearr = $yearr + "/" + $yearr1 )
118 118   #set ($sql = ", BaseObject as obj, StringProperty as prop, LargeStringProperty as prop1, LargeStringProperty as prop2, LargeStringProperty as prop3, StringProperty as prop4
119 - where obj.name = doc.fullName 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 prop.name = 'ay' and prop1.name = 'professor' and prop2.name = 'otherProfessors' and prop3.name = 'tutors' and prop4.name = '$sortField' and prop.value = '$ayearr' and ( prop1.value like '%$professorName%' or prop2.value like '%$professorName%' or prop3.value like '%$tutorName%' ) order by prop4.value asc ")
149 + where obj.name = doc.fullName 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 prop.name = 'ay' and prop1.name = 'professor' and prop2.name = 'otherProfessors' and prop3.name = 'tutors' and prop4.name = '$sortField' and prop.value = '$ayearr' #if( $oneUser )and ( prop1.value like '%$professorName%' or prop2.value like '%$professorName%' or prop3.value like '%$tutorName%' )#end#if( $oneProfessor )and ( prop1.value like '%$professorName%' or prop2.value like '%$professorName%' )#end#if( $oneTutor )and prop3.value like '%$tutorName%'#end order by prop4.value asc ")
120 120   #set( $courseFound = $xwiki.searchDocuments($sql) )
121 121   #set( $courseYearNo = $courseFound.size() )
122 122   #if( $$courseYearNo >0 )
153 + #set( $courseMap[$yearr] = $courseFound )
123 123   #set( $courseNo = $courseNo + $courseYearNo )
124 - #if( !$oneYear )
125 -(% style="border-style:solid hidden hidden solid; border-color:$theme.borderColor; text-align:left; font-style:oblique" %)|{{id name='$yearr'/}}[[$ayearr>>$doc||queryString='year=$yearr#if( $userName != "" )&user=$userName#elseif( $professorName != "" )&professor=$professorName#elseif( $tutorName != "" )&tutor=$tutorName#end']]
126 - #end
127 - #foreach( $courseDoc in $courseFound )
128 -* {{courseName}}$courseDoc{{/courseName}}
129 - #end
130 -(% style="#if( !$oneYear )border-style:hidden solid solid hidden; border-color:$theme.borderColor;#end text-align:right; font-style:oblique; font-size:smaller" %)|($courseYearNo #if( $courseYearNo == 1 ){{stringEngIta eng='course in' ita='corso nel'/}}#else{{stringEngIta eng='courses in' ita='corsi nel'/}}#end $ayearr) [[[{{stringEngIta eng='top' ita='in cima'/}}]>>||anchor="top"]] [[[{{stringEngIta eng='bottom' ita='in fondo'/}}]>>||anchor="bottom"]]
131 131   #end
132 132  #end
133 -#if( !$oneYear )(% style="text-align:right; font-style:oblique; font-size:smaller; border-bottom-style:dotted; border-color:$theme.borderColor" %)|($courseNo #if( $courseNo == 1 ){{stringEngIta eng='course' ita='corso'/}}#else{{stringEngIta eng='courses' ita='corsi'/}}#end)#end
157 +### output results
158 +## page subtitle
159 +{{id name="top"/}}
160 +>(%%)$courseNo #if( $courseNo == 1 ){{stringEngIta eng="$objectEngSingular.toLowerCase()" ita="$objectItaSingular.toLowerCase()"/}}#{else}{{stringEngIta eng="$objectEngPlural.toLowerCase()" ita="$objectItaPlural.toLowerCase()"/}}#{end} / #if( $oneYear )$aYear#else$lastAYear–$firstAYear#end#if( $oneUser ) / $userFirstName $userLastName#elseif( $oneProfessor ) / $professorFirstName $professorLastName#elseif( $oneTutor ) / $tutorFirstName $tutorLastName (tutor)#{end}(%%)
161 +##
162 +## stop if no course are found
163 +#if( $courseNo == 0 || $courseMap.keySet().size() == 0 )
164 +## redundant double check
165 + #stop
166 +#end
167 +## some course found
168 +## page index
169 +#if( $courseMap.keySet().size() > 1 )
170 +## found more than one year
171 +{{id name="index"/}}
172 +(% style="font-size:smaller; text-align:right; padding:1em 1.5em 0.25em 1.5em; background-color:$theme.highlightColor" %)(((#foreach( $yearr in $courseMap.keySet() )#set($yearr1 = $yearr + 1)#set($ayearr = $yearr + "/" + $yearr1 )#if( !$foreach.first ) | #end[[$ayearr>>||anchor="$ayearr"]]#end)))
173 +#end
174 +## courses displayed per academic year
175 +#foreach( $yearr in $courseMap.keySet() )#set($yearr1 = $yearr + 1)#set($ayearr = $yearr + "/" + $yearr1 )
176 +(% style="border-style:solid hidden hidden solid; border-color:$theme.borderColor; text-align:left; font-style:oblique" %)|{{id name='$ayearr'/}}[[$ayearr>>$doc||style='text-decoration:none; color:$theme.textPrimaryColor' queryString='year=$yearr#if( $oneUser )&user=$userName#elseif( $oneProfessor )&professor=$professorName#elseif( $oneTutor )&tutor=$tutorName#end']]
177 +(% style="border-style:hidden hidden hidden hidden; font-style:normal" %)
178 +#foreach( $course in $courseMap[$yearr] )
179 +* {{courseName}}$course{{/courseName}}
180 + #end
181 +(%%)
182 + #set( $courseYearNo = $courseMap[$yearr].size() )
183 +(% style="border-style:hidden solid solid hidden; border-color:$theme.borderColor; text-align:right; font-style:oblique; font-size:smaller" %)|($courseYearNo #if( $courseYearNo == 1 ){{stringEngIta eng='course in' ita='corso nel'/}}#{else}{{stringEngIta eng='courses in' ita='corsi nel'/}}#end $yearr) [[[{{stringEngIta eng='top' ita='in cima'/}}]>>||anchor="top"]] [[[{{stringEngIta eng='bottom' ita='in fondo'/}}]>>||anchor="bottom"]]
184 +#end
134 134  {{/velocity}}
186 +{{id name="bottom"/}}