Changes for page Per Year
From version 12.6
edited by Andrea Omicini
on 22/06/2021 01:18
on 22/06/2021 01:18
Change comment:
There is no comment for this version
To version 28.1
edited by Andrea Omicini
on 25/10/2021 18:38
on 25/10/2021 18:38
Change comment:
There is no comment for this version
Summary
-
Page properties (2 modified, 0 added, 0 removed)
Details
- Page properties
-
- Title
-
... ... @@ -1,0 +1,1 @@ 1 +Theses per Status - Content
-
... ... @@ -1,208 +1,109 @@ 1 -{{include document="Main.MacroSheet"/}}{{include document="Theses.MacroSheet"/}}{{velocity filter="none"}}#### get parameters 2 -## who 3 -#set( $userNamePar = $context.getRequest().getParameter("user") ) 4 -#set( $supervisorNamePar = $context.getRequest().getParameter("supervisor") ) 5 -#set( $cosupervisorNamePar = $context.getRequest().getParameter("cosupervisor") ) 6 -#set( $contactNamePar = $context.getRequest().getParameter("contact") ) 7 -#### set default values 1 +{{include reference="Theses.Environment"/}}{{include reference="Environment"/}}{{velocity}} 2 +#set( $thesisMenu = true ) 3 +### START STATUS 4 +## hypothesis: $thesisStatus set, default "Completed" 5 +## status parameter 6 +#set( $statusPar = $request.status.trim().toLowerCase() ) 7 +#set( $statusSelected = false ) 8 +#if( $statusPar != '' && $allThesisStatuses.contains($statusPar) ) 9 + #set( $statusSelected = true ) 10 + #set( $selectedStatus = $statusPar ) 11 +#end 12 +##check velocity variable, takes precedence 13 +#if( $thesisStatus && $thesisStatus != '' && $allThesisStatuses.contains($thesisStatus.trim().toLowerCase()) ) 14 + #set( $statusSelected = true ) 15 + #set( $selectedStatus = $thesisStatus.trim().toLowerCase() ) 16 +#end 17 +## set ordering field 18 +#if( $selectedStatus == "available" ) 19 + #set( $orderingDateFieldName = "availabilityDate" ) 20 +#elseif( $selectedStatus == "ongoing" ) 21 + #set( $orderingDateFieldName = "startDate" ) 22 +#else 23 +## default for no selected status, too 24 + #set( $orderingDateFieldName = "endDate" ) 25 +#end 26 +## invariant: $statusSelected set, $selectedStatus & $orderingDateFieldName set accordingly 27 +### END STATUS 28 +## 29 +### START USER & ROLE 30 +#set( $userNamePar = $request.user.trim() ) 31 +#set( $rolePar = $request.role.trim().toLowerCase() ) 32 +## default values 8 8 #set( $userSelected = false ) 9 -#set( $roleSelected = false ) 10 10 #set( $userFirstName = "" ) 11 11 #set( $userLastName = "" ) 12 -#set( $supervisorName = "" ) 13 -#set( $supervisorFirstName = "" ) 14 -#set( $supervisorLastName = "" ) 15 -#set( $cosupervisorName = "" ) 16 -#set( $cosupervisorFirstName = "" ) 17 -#set( $cosupervisorLastName = "" ) 18 -#set( $contactName = "" ) 19 -#set( $contactFirstName = "" ) 20 -#set( $contactLastName = "" ) 21 -## 22 -#### handle who & roles 23 -## 24 -#if ( $userName || $userNamePar ) ## a user is specified for all roles 25 - #set( $userSelected = true ) 26 - #if ( !$userName )#set( $userName = "XWiki.$userNamePar" )#end 27 - #set( $userdoc = $xwiki.getDocument($userName) ) 28 - #set( $userFirstName = $userdoc.display("first_name") ) 29 - #set( $userLastName = $userdoc.display("last_name") ) 30 -#elseif ( $supervisorNamePar || $cosupervisorNamePar || $contactNamePar ) 31 - #set( $roleSelected = true ) 32 - #if ( $supervisorNamePar ) 33 - #set( $supervisorName = "XWiki.$supervisorNamePar" ) 34 - #set( $supervisordoc = $xwiki.getDocument($supervisorName) ) 35 - #set( $supervisorFirstName = $supervisordoc.display("first_name") ) 36 - #set( $supervisorLastName = $supervisordoc.display("last_name") ) 36 +#if( $userName || $userNamePar ) 37 +## a user is specified for all roles 38 + #if( !$userName ) 39 + #set( $selectedUser = "XWiki.$userNamePar" ) 40 + #else 41 + #set( $selectedUser = $userName ) 37 37 #end 38 - #if ( $cosupervisorNamePar ) 39 - #set( $cosupervisorName = "XWiki.$cosupervisorNamePar" ) 40 - #set( $cosupervisordoc = $xwiki.getDocument($cosupervisorName) ) 41 - #set( $cosupervisorFirstName = $cosupervisordoc.display("first_name") ) 42 - #set( $cosupervisorLastName = $cosupervisordoc.display("last_name") ) 43 + #if( $xwiki.exists($selectedUser) ) 44 + #set( $userSelected = true ) 45 + #set( $userdoc = $xwiki.getDocument($selectedUser) ) 46 + #set( $userFirstName = $userdoc.display("first_name") ) 47 + #set( $userLastName = $userdoc.display("last_name") ) 48 + #else 49 +{{warning}} $selectedUser is not an {{apice/}} user{{/warning}} 50 + #stop 43 43 #end 44 - #if ( $contactNamePar ) 45 - #set( $contactName = "XWiki.$contactNamePar" ) 46 - #set( $contactdoc = $xwiki.getDocument($contactName) ) 47 - #set( $contactFirstName = $contactdoc.display("first_name") ) 48 - #set( $contactLastName = $contactdoc.display("last_name") ) 52 +##user selected and existing user page 53 + #set( $roleSelected = false ) 54 + #set( $selectedRole = '' ) 55 + #if( $rolePar != '' && $allThesisRoles.contains($rolePar) ) 56 + #set( $roleSelected = true ) 57 + #set( $selectedRole = $rolePar ) 49 49 #end 50 50 #end 51 -#if( $supervisor ) 52 - #set( $roleSelected = true ) 53 - #set( $supervisorName = $userName ) 54 - #set( $supervisordoc = $xwiki.getDocument($supervisorName) ) 55 - #set( $supervisorFirstName = $supervisordoc.display("first_name") ) 56 - #set( $supervisorLastName = $supervisordoc.display("last_name") ) 57 -#end 58 -#if( $cosupervisor ) 59 - #set( $roleSelected = true ) 60 - #set( $cosupervisorName = $userName ) 61 - #set( $cosupervisordoc = $xwiki.getDocument($cosupervisorName) ) 62 - #set( $cosupervisorFirstName = $cosupervisordoc.display("first_name") ) 63 - #set( $cosupervisorLastName = $cosupervisordoc.display("last_name") ) 64 -#end 65 -#if( $contact ) 66 - #set( $roleSelected = true ) 67 - #set( $contactName = $userName ) 68 - #set( $contactdoc = $xwiki.getDocument($contactName) ) 69 - #set( $contactFirstName = $contactdoc.display("first_name") ) 70 - #set( $contactLastName = $contactdoc.display("last_name") ) 71 -#end 60 +## $userselected and $roleSelected set properly, other related variables set accordingly 61 +## $roleSelected has meaning only if $userSelected 62 +## if $userSelected, $roleSelected false means one user for all roles 63 +## if $userSelected, $roleSelected true means one specific role for one user selected 64 +## if $userSelected is false, $roleSelected means nothing -- so all users, all roles / just status 72 72 ## 73 -## $userSelected true means one user for all roles 74 -## $userSelected true and $roleSelected true for one user with one specific role 75 -## if $userSelected false and $roleSelected true mean at least one role with an assigned user 76 -## both false means all theses 77 - 78 -== #if( $userSelected )$userFirstName $userLastName / #end#stringEnIt("Theses ","Tesi")#if( $thesisStatus ) / #ThesisStatusesString($thesisStatus)#end == 79 - 66 +#set( $roleSelectedFieldName = "" ) 80 80 #if( $roleSelected ) 81 - #if( $userSelected ) 82 - #if( $supervisor ) 83 - 84 -> {{stringEngIta eng="as a supervisor" ita="come relatore"/}} 85 - 86 - #end 87 - #if( $cosupervisor ) 88 - 89 -> {{stringEngIta eng="as a co-supervisor" ita="come correlatore"/}} 90 - 91 - #end 92 - #if( $contact ) 93 -> {{stringEngIta eng="as a contact" ita="come contatto"/}} 94 - 95 - #end 68 + #if( $selectedRole == "contact" ) 69 + #set( $roleSelectedFieldName = "contact" ) 70 + #elseif( $selectedRole == "cosupervisor" ) 71 + #set( $roleSelectedFieldName = "coSupervisors" ) 96 96 #else 97 - #if( $supervisorLastName != "" ) 98 - 99 -> #stringEnIt("supervised by","con relatore") $supervisorFirstName $supervisorLastName 100 - 101 - #end 102 - #if( $cosupervisorLastName != "" ) 103 - 104 -> #stringEnIt("co-supervised by","con correlatore") $cosupervisorFirstName $cosupervisorLastName 105 - 106 - #end 107 - #if( $contactLastName != "" ) 108 - 109 -> #stringEnIt("with contact","con contatto") $contactFirstName $contactLastName 110 - 111 - #end 73 + #set( $roleSelectedFieldName = "supervisor" ) 112 112 #end 113 113 #end 114 114 ## 115 -## hypothesis: $thesisStatus set, default "Completed" 116 -## to do: get from parameter 117 -#if ($thesisStatus == "Available") 118 - #set ($orderingDateFieldName = "availabilityDate") 119 -#elseif ($thesisStatus == "Ongoing") 120 - #set ($orderingDateFieldName = "startDate") 121 -#else 122 - #set ($thesisStatus = "Completed") 123 - #set ($orderingDateFieldName = "endDate") 124 -#end 125 -## 126 -#if ( $cosupervisor ) 127 - #set ( $roleSelectedFieldName = "coSupervisors" ) 128 -#elseif ( $contact ) 129 - #set ( $roleSelectedFieldName = "contact" ) 130 -#else 131 - #set ( $roleSelectedFieldName = "supervisor" ) 132 -#end 133 -## 134 -#if ($userSelected) 135 - #if ( $roleSelected ) 136 - #set ($sql = ", BaseObject as obj, StringProperty as prop, LargeStringProperty as prop1, DateProperty as prop2 137 - where obj.name=doc.fullName and 138 - obj.className='Theses.ThesisClass' and 139 - obj.name<>'Theses.ThesisClassTemplate' and 140 - prop.id.id=obj.id and 141 - prop1.id.id=obj.id and 142 - prop2.id.id=obj.id and 143 - prop.name='status' and 144 - prop.value='$thesisStatus' and 145 - prop1.name='$roleSelectedFieldName' and 146 - prop2.name='$orderingDateFieldName' and 147 - prop1.value like '%$userName%' 148 - order by prop2.value desc") 149 - #else 150 - #set ($sql = ", BaseObject as obj, StringProperty as prop, LargeStringProperty as prop1, LargeStringProperty as prop2, LargeStringProperty as prop3, DateProperty as prop4 151 - where obj.name=doc.fullName and 152 - obj.className='Theses.ThesisClass' and 153 - obj.name<>'Theses.ThesisClassTemplate' and 154 - prop.id.id=obj.id and 155 - prop1.id.id=obj.id and 156 - prop2.id.id=obj.id and 157 - prop3.id.id=obj.id and 158 - prop4.id.id=obj.id and 159 - prop.name='status' and 160 - prop.value = '$thesisStatus' and 161 - prop1.name='supervisor' and 162 - prop2.name='coSupervisors' and 163 - prop3.name='contact' and 164 - prop4.name='$orderingDateFieldName' and 165 - ( prop1.value like '%$userName%' or 166 - prop2.value like '%$userName%' or 167 - prop3.value like '%$userName%') 168 - order by prop4.value desc") 77 +#foreach( $status in $allThesisStatuses ) 78 + #if( !$statusSelected || $selectedStatus == $status ) 79 += $status = 80 +## some selected status or all statuses / now $status 81 + #if( $userSelected ) 82 +== $selectedUser == 83 +## some user selected 84 + #if( $roleSelected ) 85 +## some specific role selected 86 +=== $roleSelected === 87 + #set ($sql = ", BaseObject as obj, StringProperty as prop0, LargeStringProperty as prop1, DateProperty as prop2 88 + 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 prop0.name = 'status' and prop1.name = '$roleSelectedFieldName' and prop2.name = '$orderingDateFieldName' and lower(prop0.value) = '$status' and prop1.value like '%$selectedUser%' order by prop2.value desc" ) 89 + #else 90 +## no specific role selected 91 + #set ($sql = ", BaseObject as obj, StringProperty as prop0, LargeStringProperty as prop1, LargeStringProperty as prop2, LargeStringProperty as prop3, DateProperty as prop4 92 + 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) = '$status' and ( prop1.value like '%$selectedUser%' or prop2.value like '%$selectedUser%' or prop3.value like '%$selectedUser%' ) order by prop4.value desc" ) 93 + #end 94 + #else 95 +## no user selected, no role selected 96 + #set ($sql = ", BaseObject as obj, StringProperty as prop0, DateProperty as prop1 97 + 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 lower(prop0.value) = '$status' order by prop1.value desc" ) 98 + #end 169 169 #end 170 -#elseif ( $roleSelected ) 171 - #set ($sql = ", BaseObject as obj, StringProperty as prop, LargeStringProperty as prop1, LargeStringProperty as prop2, LargeStringProperty as prop3, DateProperty as prop4 172 - where obj.name=doc.fullName and 173 - obj.className='Theses.ThesisClass' and 174 - obj.name<>'Theses.ThesisClassTemplate' and 175 - prop.id.id=obj.id and 176 - prop1.id.id=obj.id and 177 - prop2.id.id=obj.id and 178 - prop3.id.id=obj.id and 179 - prop4.id.id=obj.id and 180 - prop.name='status' and 181 - prop.value = '$thesisStatus' and 182 - prop1.name='supervisor' and 183 - prop2.name='coSupervisors' and 184 - prop3.name='contact' and 185 - prop4.name='$orderingDateFieldName' and 186 - prop1.value like '%$supervisorName%' and 187 - prop2.value like '%$cosupervisorName%' and 188 - prop3.value like '%$contactName%' 189 - order by prop4.value desc") 190 -#else 191 - #set ($sql = ", BaseObject as obj, StringProperty as prop, DateProperty as prop1 192 - where obj.name=doc.fullName and 193 - obj.className='Theses.ThesisClass' and 194 - obj.name<>'Theses.ThesisClassTemplate' and 195 - prop.id.id=obj.id and 196 - prop1.id.id=obj.id and 197 - prop.name='status' and 198 - prop.value = '$thesisStatus' and 199 - prop1.name='$orderingDateFieldName' 200 - order by prop1.value desc") 201 -#end 202 -#set($thesisFound = $xwiki.searchDocuments($sql)) 100 + #set( $thesisFound = $xwiki.searchDocuments($sql) ) 101 + #set( $thesisFoundNo = $thesisFound.size() ) 203 203 ## 204 -#foreach ($thesis in $thesisFound)#set($thesisDoc = $xwiki.getDocument($thesis)) 205 -* #thesisTitleLink($thesis)#if( $thesisDoc.getValue("studentUserName") != "" || $thesisDoc.getValue("studentName") != "" ) //(#thesisAuthorLink($thesis)#if( $thesisDoc.display("endDate") != "" ), #thesisYear($thesis)#end)//#end 103 + #foreach ($thesis in $thesisFound) 104 + #set($thesisDoc = $xwiki.getDocument($thesis)) 105 +* [[$thesisDoc.title>>$thesisDoc]]#if( $thesisDoc.studentUserName != "" )//$thesisDoc.studentUserName//#elseif( $thesisDoc.studentFirstName != "" && $thesisDoc.studentLastName != "" )//$thesisDoc.studentFirstName $thesisDoc.studentLastName//#end#if( $thesisDoc.endDate != "" ) ($thesisDoc.endDate)#end 206 206 107 + #end 207 207 #end 208 208 {{/velocity}}