Changes for page Per Year

From version 20.13
edited by Andrea Omicini
on 25/10/2021 17:18
Change comment: There is no comment for this version
To version 20.15
edited by Andrea Omicini
on 25/10/2021 17:29
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -93,25 +93,6 @@
93 93   #set( $contactFirstName = $contactdoc.display("first_name") )
94 94   #set( $contactLastName = $contactdoc.display("last_name") )
95 95  #end
96 -$selectedStatus
97 -
98 -$userSelected
99 -
100 -$roleSelected
101 -
102 -$supervisor
103 -
104 -$cosupervisor
105 -
106 -$contact
107 -
108 -$userFirstName $userLastName
109 -
110 -$supervisorFirstName $supervisorLastName
111 -
112 -$cosupervisorFirstName $cosupervisorLastName
113 -
114 -$contactFirstName $contactLastName
115 115  ##
116 116  ## $userSelected true and $roleSelected false means one user for all roles
117 117  ## $userSelected true and $roleSelected true for one user with one specific role
... ... @@ -160,7 +160,7 @@
160 160   #else
161 161  ## no specific role selected
162 162   #set ($sql = ", BaseObject as obj, StringProperty as prop0, LargeStringProperty as prop1, LargeStringProperty as prop2, LargeStringProperty as prop3, DateProperty as prop4
163 - where obj.name = doc.fullName and obj.className = 'Theses.ThesisClass' and obj.name <> 'Theses.ThesisClassTemplate' 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 prop0.name = 'status' and prop1.name = 'supervisor' and prop2.name = 'coSupervisors' and prop3.name = 'contact' and prop4.name = '$orderingDateFieldName' and prop0.value = '$selectedStatus' and ( prop1.value like '%$userName%' or prop2.value like '%$userName%' or prop3.value like '%$userName%' ) order by prop4.value desc" )
144 + where obj.name = doc.fullName and obj.className = 'Theses.ThesisClass' and obj.name <> 'Theses.ThesisClassTemplate' 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 prop0.name = 'status' and prop1.name = 'supervisor' and prop2.name = 'coSupervisors' and prop3.name = 'contact' and prop4.name = '$orderingDateFieldName' and lower(prop0.value) = '$selectedStatus' and ( prop1.value like '%$userName%' or prop2.value like '%$userName%' or prop3.value like '%$userName%' ) order by prop4.value desc" )
164 164   #end
165 165   #elseif( $roleSelected )
166 166  ## no user selected, some role selected
... ... @@ -172,12 +172,11 @@
172 172   where obj.name = doc.fullName and obj.className = 'Theses.ThesisClass' and obj.name <> 'Theses.ThesisClassTemplate' and obj.name <> 'Theses.ThesisTemplate' and prop0.id.id = obj.id and prop1.id.id = obj.id and prop0.name = 'status' and prop1.name = '$orderingDateFieldName' and prop0.value = '$selectedStatus' order by prop1.value desc" )
173 173   #end
174 174  #end
175 -$sql
176 176  #set( $thesisFound = $xwiki.searchDocuments($sql) )
177 -$thesisFound.size()
157 +#set( $thesisFoundNo = $thesisFound.size() )
178 178  ##
179 179  #foreach ($thesis in $thesisFound)#set($thesisDoc = $xwiki.getDocument($thesis))
180 -##* #thesisTitleLink($thesis)#if( $thesisDoc.getValue("studentUserName") != "" || $thesisDoc.getValue("studentName") != "" || ( $thesisDoc.getValue("studentFirstName") != "" && $thesisDoc.getValue("studentLastName") != "" ) ) //(#thesisAuthorLink($thesis)#if( $thesisDoc.display("endDate") != "" ), #thesisYear($thesis)#end)//#end
181 -* $thesis
160 +* [[$thesisDoc.getValue("title")>>$thesisDoc]]#thesisTitleLink($thesis)#if( $thesisDoc.getValue("studentUserName") != "" || $thesisDoc.getValue("studentName") != "" || ( $thesisDoc.getValue("studentFirstName") != "" && $thesisDoc.getValue("studentLastName") != "" ) ) //(#thesisAuthorLink($thesis)#if( $thesisDoc.display("endDate") != "" ), #thesisYear($thesis)#end)//#end
161 +
182 182  #end
183 183  {{/velocity}}