Changes for page Per A.Y.
From version 45.2
edited by Andrea Omicini
on 08/02/2023 00:12
on 08/02/2023 00:12
Change comment:
There is no comment for this version
To version 45.8
edited by Andrea Omicini
on 08/02/2023 00:37
on 08/02/2023 00:37
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
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 ... ... @@ -117,7 +117,7 @@ 117 117 ## 118 118 #foreach( $yearr in $yearList)#set($yearr1 = $yearr + 1)#set($ayearr = $yearr + "/" + $yearr1 ) 119 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 ") 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 ") 121 121 #set( $courseFound = $xwiki.searchDocuments($sql) ) 122 122 #set( $courseYearNo = $courseFound.size() ) 123 123 #if( $$courseYearNo >0 ) ... ... @@ -128,7 +128,8 @@ 128 128 ### output results 129 129 ## page subtitle 130 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} 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 +## 132 132 ## stop if no course are found 133 133 #if( $courseNo == 0 || $courseMap.keySet().size() == 0 ) 134 134 ## redundant double check ... ... @@ -143,7 +143,7 @@ 143 143 #end 144 144 ## courses displayed per academic year 145 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']]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']] 147 147 (% style="border-style:hidden hidden hidden hidden; font-style:normal" %) 148 148 #foreach( $course in $courseMap[$yearr] ) 149 149 * {{courseName}}$course{{/courseName}} ... ... @@ -150,7 +150,7 @@ 150 150 #end 151 151 (%%) 152 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"]] 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"]] 154 154 #end 155 155 {{/velocity}} 156 156 {{id name="bottom"/}}