Changes for page Per A.Y.
From version 45.10
edited by Andrea Omicini
on 08/02/2023 03:53
on 08/02/2023 03:53
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
-
... ... @@ -9,10 +9,6 @@ 9 9 #set( $firstYearPar = $context.getRequest().getParameter("from") ) 10 10 #set( $lastYearPar = $context.getRequest().getParameter("to") ) 11 11 ## who 12 -#set( $oneUser = false ) 13 -#set( $oneProfessor = false ) 14 -#set( $oneTutor = false ) 15 -## 16 16 #set( $userNamePar = $context.getRequest().getParameter("user") ) 17 17 #set( $professorNamePar = $context.getRequest().getParameter("professor") ) 18 18 #set( $tutorNamePar = $context.getRequest().getParameter("tutor") ) ... ... @@ -22,7 +22,6 @@ 22 22 #set( $userdoc = $xwiki.getDocument($userName) ) 23 23 #set( $userFirstName = $userdoc.display("first_name") ) 24 24 #set( $userLastName = $userdoc.display("last_name") ) 25 - #set( $oneUser = true ) 26 26 #elseif ( $userNamePar ) 27 27 ## from the URL, "user=UserName" parameter 28 28 #if( $userNamePar.contains("XWiki.") ) ... ... @@ -33,7 +33,10 @@ 33 33 #set( $userdoc = $xwiki.getDocument($userName) ) 34 34 #set( $userFirstName = $userdoc.display("first_name") ) 35 35 #set( $userLastName = $userdoc.display("last_name") ) 36 - #set( $oneUser = true ) 31 +#else 32 + #set( $userName = "" ) 33 + #set( $userFirstName = "" ) 34 + #set( $userLastName = "" ) 37 37 #end 38 38 #if ( $professorName ) 39 39 ## from a personal page, "XWiki.UserName" $professorName form ... ... @@ -40,7 +40,6 @@ 40 40 #set( $professordoc = $xwiki.getDocument($professorName) ) 41 41 #set( $professorFirstName = $professordoc.display("first_name") ) 42 42 #set( $professorLastName = $professordoc.display("last_name") ) 43 - #set( $oneProfessor = true ) 44 44 #elseif ( $professorNamePar ) 45 45 ## from the URL, "professor=UserName" parameter 46 46 #if( $professorNamePar.contains("XWiki.") ) ... ... @@ -51,7 +51,10 @@ 51 51 #set( $professordoc = $xwiki.getDocument($professorName) ) 52 52 #set( $professorFirstName = $professordoc.display("first_name") ) 53 53 #set( $professorLastName = $professordoc.display("last_name") ) 54 - #set( $oneProfessor = true ) 51 +#else 52 + #set( $professorName = "" ) 53 + #set( $professorFirstName = "" ) 54 + #set( $professorLastName = "" ) 55 55 #end 56 56 #if ( $tutorName ) 57 57 ## from a personal page, "XWiki.UserName" $tutorName form ... ... @@ -68,21 +68,31 @@ 68 68 #set( $tutordoc = $xwiki.getDocument($tutorName) ) 69 69 #set( $tutorFirstName = $tutordoc.display("first_name") ) 70 70 #set( $tutorLastName = $tutordoc.display("last_name") ) 71 - #set( $oneTutor = true ) 71 +#else 72 + #set( $tutorName = "" ) 73 + #set( $tutorFirstName = "" ) 74 + #set( $tutorLastName = "" ) 72 72 #end 73 73 ## who, in the end 74 -#if( $oneUser ) 77 +#set( $oneUser = false ) 78 +#set( $oneProfessor = false ) 79 +#set( $oneTutor = false ) 80 +## 81 +#if( $userName != "" ) 75 75 ## user takes precedence over both professor and tutor and gets them all 76 - #set( $oneProfessor = false ) 77 - #set( $oneTutor = false ) 78 -#elseif( $oneProfessor ) 83 + #set( $professorName = $userName ) 84 + #set( $tutorName = $userName ) 85 + #set( $oneUser = true ) 86 +#elseif( $professorName != "" ) 79 79 ## professor takes precedence over tutor 80 - #set( $oneUser = false ) 81 - #set( $oneTutor = false ) 82 -#elseif( $oneTutor ) 88 + #set( $tutorName = "@@" ) 89 + #set( $userName = "@@" ) 90 + #set( $oneProfessor = true ) 91 +#elseif( $tutorName != "" ) 83 83 ## just tutor 84 - #set( $oneUser = false ) 85 - #set( $oneProfessor = false ) 93 + #set( $professorName = "@@" ) 94 + #set( $userName = "@@" ) 95 + #set( $oneTutor = true ) 86 86 #end 87 87 ## 88 88 #if( $firstYearCou )#set( $firstYear = $firstYearCou )#end ... ... @@ -136,7 +136,7 @@ 136 136 ## 137 137 #foreach( $yearr in $yearList)#set($yearr1 = $yearr + 1)#set($ayearr = $yearr + "/" + $yearr1 ) 138 138 #set ($sql = ", BaseObject as obj, StringProperty as prop, LargeStringProperty as prop1, LargeStringProperty as prop2, LargeStringProperty as prop3, StringProperty as prop4 139 - 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 '%$ userName%' or prop2.value like '%$userName%' or prop3.value like '%$userName%' )#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 ")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 ") 140 140 #set( $courseFound = $xwiki.searchDocuments($sql) ) 141 141 #set( $courseYearNo = $courseFound.size() ) 142 142 #if( $$courseYearNo >0 ) ... ... @@ -147,7 +147,7 @@ 147 147 ### output results 148 148 ## page subtitle 149 149 {{id name="top"/}} 150 ->(%%)$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}(%%)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}(%%) 151 151 ## 152 152 ## stop if no course are found 153 153 #if( $courseNo == 0 || $courseMap.keySet().size() == 0 )