Changes for page Per A.Y.

From version 13.1
edited by Andrea Omicini
on 19/09/2021 16:47
Change comment: There is no comment for this version
To version 45.1
edited by Andrea Omicini
on 08/02/2023 00:11
Change comment: There is no comment for this version

Summary

Details

Page properties
Title
... ... @@ -1,1 +1,0 @@
1 -#set($title="Per anno accademico")#if($xcontext.language=='en')#set($title="Per Academic Year")#end$title
Content
... ... @@ -1,4 +1,7 @@
1 -{{include reference="Courses.MacroSheet"/}}{{include reference="Courses.GlobalVars"/}}{{velocity}}
1 += {{italiano}}Per A.A.{{/italiano}}{{english}}Per A.Y.{{/english}} =
2 +
3 +{{include reference="Courses.Environment" excludeFirstHeading="true"/}}{{velocity}}
4 +#set( $courseMenu = true )
2 2  #set( $currentCourseDoc = "" )
3 3  #### get parameters
4 4  ## when
... ... @@ -58,10 +58,15 @@
58 58   #set( $tutorFirstName = "" )
59 59   #set( $tutorLastName = "" )
60 60  #end
64 +## professor takes precedence over tutor
65 +#if( $professorName != "" )#set( $tutorName = "" )#end
66 +## user takes precedence over both professor and tutor and gets them all
61 61  #if( $userName != "" )#set( $professorName = $userName )#set( $tutorName = $userName )#end
62 62  ##
63 63  #if( $firstYearCou )#set( $firstYear = $firstYearCou )#end
64 64  #if( $lastYearCou )#set( $lastYear = $lastYearCou )#end
71 +#if( $firstYearCourse )#set( $firstYear = $firstYearCourse )#end
72 +#if( $lastYearCourse )#set( $lastYear = $lastYearCourse )#end
65 65  #set( $firstYear1 = $firstYear + 1 )#set( $firstAYear = $firstYear + "/" + $firstYear1 )
66 66  #set( $lastYear1 = $lastYear + 1 )#set( $lastAYear = $lastYear + "/" + $lastYear1 )
67 67  #set( $yearRange = [$lastYear..$firstYear] )
... ... @@ -98,42 +98,51 @@
98 98   #set($aYear = $year + "/" + $year1 )
99 99   #end
100 100  #end
101 -
102 ->{{stringEngIta eng = "Courses" ita = "Corsi"/}} / #if( $oneYear )$aYear#else$firstAYear–$lastAYear#end#if( $userName != "" ) / $userFirstName $userLastName#elseif( $professorName != "" ) / $professorFirstName $professorLastName#elseif( $tutorName != "" ) / $tutorFirstName $tutorLastName (tutor)#end
103 -{{id name="top"/}}
104 -
105 -#if( !$oneYear )
106 -(% style="font-size: smaller" %)(((#foreach ($yearr in $yearList)#set($yearr1 = $yearr + 1)#set($ayearr = "$yearr/$yearr1")#if( $velocityCount > 1 ) | #end[[$ayearr>>$doc||anchor=$ayearr]]#end)))(%%)
107 -#end
109 +#### HANDLE PARAMETERS / END
108 108  ##
111 +### query to structures
112 +## map & counter initialisation
113 +#set( $courseMap = {} )
114 +#set( $courseNo = 0 )
115 +#if( $services.localization.currentLocale == "it" )#set( $sortField = "ita")#else#set( $sortField = "eng")#end
116 +##
117 +##
109 109  #foreach( $yearr in $yearList)#set($yearr1 = $yearr + 1)#set($ayearr = $yearr + "/" + $yearr1 )
110 -#set ($sql = ", BaseObject as obj, StringProperty as prop, LargeStringProperty as prop1, LargeStringProperty as prop2, LargeStringProperty as prop3
111 - where
112 - obj.name = doc.fullName and
113 - obj.className = 'Courses.CourseClass' and
114 - obj.name <> 'Courses.CourseClassTemplate' and
115 - obj.name <> 'Courses.CourseTemplate' and
116 - prop.id.id = obj.id and
117 - prop1.id.id = obj.id and
118 - prop2.id.id = obj.id and
119 - prop3.id.id = obj.id and
120 - prop.name = 'aY' and
121 - prop1.name = 'professor' and
122 - prop2.name = 'otherProfessors' and
123 - prop3.name = 'tutors' and
124 - prop.value like '%$yearr%' and
125 - (prop1.value like '%$professorName%' or
126 - prop2.value like '%$professorName%' or
127 - prop3.value like '%$tutorName%')
128 - order by prop.value desc
129 -")
130 -#set( $courseFound = $xwiki.searchDocuments($sql) )
131 -#if( $courseFound.size()>0 )#if(!$oneYear)
132 -=== $ayearr ===
133 -{{id name="$ayearr"/}}
134 -#end#foreach ($courseDoc in $courseFound)
135 -* [[#displayName($courseDoc)>>$courseDoc]]
119 + #set ($sql = ", BaseObject as obj, StringProperty as prop, LargeStringProperty as prop1, LargeStringProperty as prop2, LargeStringProperty as prop3, StringProperty as prop4
120 + 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 ")
121 + #set( $courseFound = $xwiki.searchDocuments($sql) )
122 + #set( $courseYearNo = $courseFound.size() )
123 + #if( $$courseYearNo >0 )
124 + #set( $courseMap[$yearr] = $courseFound )
125 + #set( $courseNo = $courseNo + $courseYearNo )
126 + #end
136 136  #end
137 -(% style='font-style:oblique;font-size:smaller;text-align:right;color:gray;margin-top:-0.5em;margin-bottom:0em' %)((( ($courseFound.size() #if( $courseFound.size() > 1 ){{stringEngIta ita="corsi" eng="courses"/}}#else{{stringEngIta ita="corso" eng="course"/}}#end / $ayearr) [[[top]>>||anchor="top"]] )))(%%)
138 -#end#end
128 +### output results
129 +## page subtitle
130 +{{id name="top"/}}
131 +>(%%)$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( $userName != "" ) / $userFirstName $userLastName#elseif( $professorName != "" ) / $professorFirstName $professorLastName#elseif( $tutorName != "" ) / $tutorFirstName $tutorLastName (tutor)#end
132 +## stop if no course are found
133 +#if( $courseNo == 0 || $courseMap.keySet().size() == 0 )
134 +## redundant double check
135 + #stop
136 +#end
137 +## some course found
138 +## page index
139 +#if( $courseMap.keySet().size() > 1 )
140 +## found more than one year
141 +{{id name="index"/}}
142 +(% 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)))
143 +#end
144 +## courses displayed per academic year
145 +#foreach( $yearr in $courseMap.keySet() )#set($yearr1 = $yearr + 1)#set($ayearr = $yearr + "/" + $yearr1 )
146 +(% 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( $userName != "" )&user=$userName#elseif( $professorName != "" )&professor=$professorName#elseif( $tutorName != "" )&tutor=$tutorName#end']]
147 +(% style="border-style:hidden hidden hidden hidden; font-style:normal" %)
148 +#foreach( $course in $courseMap[$yearr] )
149 +* {{courseName}}$course{{/courseName}}
150 + #end
151 +(%%)
152 + #set( $courseYearNo = $courseMap[$yearr].size() )
153 +(% 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 $year) [[[{{stringEngIta eng='top' ita='in cima'/}}]>>||anchor="top"]] [[[{{stringEngIta eng='bottom' ita='in fondo'/}}]>>||anchor="bottom"]]
154 +#end
139 139  {{/velocity}}
156 +{{id name="bottom"/}}