Changes for page Per Year
From version 131.1
edited by Andrea Omicini
on 27/01/2023 19:27
on 27/01/2023 19:27
Change comment:
There is no comment for this version
To version 127.1
edited by Andrea Omicini
on 11/03/2022 15:56
on 11/03/2022 15:56
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -6,9 +6,6 @@ 6 6 #set( $firstYear = $mathtool.toInteger($firstYearThesis) ) 7 7 #set( $lastYear = $mathtool.toInteger($lastYearThesis) ) 8 8 #set( $yearList = [$lastYear..$firstYear] ) 9 -#set( $yearPar = 0 ) 10 -#set( $fromPar = 0 ) 11 -#set( $toPar = 0 ) 12 12 ### START YEAR 13 13 ## defaults 14 14 #set( $oneYear = false ) ... ... @@ -31,11 +31,11 @@ 31 31 #set( $selectedYear = $yearPar ) 32 32 #set( $yearList = [$yearPar] ) 33 33 #else 34 - #if( $fromPar != '' && $fromPar > 0 &&($fromPar > $firstYear) )31 + #if( $fromPar != '' && ($fromPar > $firstYear) ) 35 35 #set( $firstYear = $fromPar ) 36 36 #set( $yearList = [$lastYear..$firstYear] ) 37 37 #end 38 - #if( $toPar != '' && $toPar > 0 &&($toPar < $lastYear) )35 + #if( $toPar != '' && ($toPar < $lastYear) ) 39 39 #set( $lastYear = $toPar ) 40 40 #set( $yearList = [$lastYear..$firstYear] ) 41 41 #end ... ... @@ -105,10 +105,10 @@ 105 105 >#if( $oneCycle ){{thesisCycle uppercase='yes' short='no'}}$selectedCycle{{/thesisCycle}}#else{{stringEngIta eng="Theses" ita="Tesi"/}}#end / #if( $oneYear )**$selectedYear**#else**$firstYear–$lastYear**#end#if( $oneUser ) / $userFirstName $userLastName#end{{id name='top'/}} 106 106 ## index 107 107 #if( !$oneYear ) 108 -(% style="font-size: smaller; padding:1em 1.5em 0.25em 1.5em; background-color:$theme.highlightColor" %)(((#foreach( $year in $yearList )#if ($foreach.index>0) | #end[[$year>>||anchor="$year"]]#end)))105 +(% 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))) 109 109 ###elseif( $oneUser && !$oneCycle ) 110 110 #elseif( !$oneCycle ) 111 -(% style="font-size: smaller; padding:1em 1.5em 0.25em 1.5em; background-color:$theme.highlightColor" %)(((#foreach( $cycle in $cycles )#if ($foreach.index>0) | #end [[{{thesisCycle}}$cycle{{/thesisCycle}}>>||anchor="$cycle"]]#end)))108 +(% style="font-size: smaller; padding:1em 1.5em 0.25em 1.5em; background-color:$theme.highlightColor" %)(((#foreach( $cycle in $cycles )#if ($velocityCount > 1) | #end [[{{thesisCycle}}$cycle{{/thesisCycle}}>>||anchor="$cycle"]]#end))) 112 112 #end{{id name='index'/}} 113 113 ## search theses 114 114 #set( $thesisNo = 0 ) ... ... @@ -124,10 +124,10 @@ 124 124 ## some selected cycle or all cycles / now $cycle 125 125 #if( $oneUser) 126 126 #set ($sql = ", BaseObject as obj, StringProperty as prop0, DateProperty as prop1, StringProperty as prop2, LargeStringProperty as prop3, LargeStringProperty as prop4, LargeStringProperty as prop5 127 - where obj.name = doc.fullName and obj.className = ' ${objectSpace}.${objectClass}' and obj.name <> '${objectSpace}.${objectTemplate}' 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 prop5.id.id = obj.id and prop0.name = 'cycle' and prop1.name = 'end' and prop2.name = 'status' and prop3.name = 'supervisors' and prop4.name = 'cosupervisors' and prop5.name = 'contacts' and prop0.value = '$cycle' and year(prop1.value) = '$year' andlower(prop2.value)= 'completed' and ( prop3.value like '%$selectedUser%' or prop4.value like '%$selectedUser%' or prop5.value like '%$selectedUser%' ) order by prop1.value desc" )124 + where obj.name = doc.fullName and obj.className = 'Theses.ThesisClass' 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 prop5.id.id = obj.id and prop0.name = 'cycle' and prop1.name = 'endDate' and prop2.name = 'status' and prop3.name = 'supervisors' and prop4.name = 'cosupervisors' and prop5.name = 'contacts' and prop0.value = '$cycle' and year(prop1.value) = '$year' and prop2.value = 'Completed' and ( prop3.value like '%$selectedUser%' or prop4.value like '%$selectedUser%' or prop5.value like '%$selectedUser%' ) order by prop1.value desc" ) 128 128 #else 129 129 #set ($sql = ", BaseObject as obj, StringProperty as prop0, DateProperty as prop1, StringProperty as prop2 130 - where obj.name = doc.fullName and obj.className = ' ${objectSpace}.${objectClass}' and obj.name <> '${objectSpace}.${objectTemplate}' and prop0.id.id = obj.id and prop1.id.id = obj.id and prop2.id.id = obj.id and prop0.name = 'cycle' and prop1.name = 'end' and prop2.name = 'status' and prop0.value = '$cycle' and year(prop1.value) = '$year 'andlower(prop2.value)= 'completed' order by prop1.value desc" )127 + where obj.name = doc.fullName and obj.className = 'Theses.ThesisClass' 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 = 'cycle' and prop1.name = 'endDate' and prop2.name = 'status' and prop0.value = '$cycle' and year(prop1.value) = '$year 'and prop2.value = 'Completed' order by prop1.value desc" ) 131 131 #end 132 132 #set( $thesisFound = $xwiki.searchDocuments($sql) ) 133 133 #set( $thesisFoundNo = $thesisFound.size() )