Changes for page Per Status
From version 83.1
edited by Andrea Omicini
on 03/01/2023 00:17
on 03/01/2023 00:17
Change comment:
There is no comment for this version
To version 78.1
edited by Andrea Omicini
on 03/01/2023 00:08
on 03/01/2023 00:08
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -81,6 +81,7 @@ 81 81 #set( $statusList = [$statusPar] ) 82 82 #end 83 83 #end 84 +$statusList 84 84 ## 85 85 ## query to structures 86 86 #set( $pubMap = {} ) ... ... @@ -87,10 +87,10 @@ 87 87 #set( $pubNo = 0 ) 88 88 #foreach( $status in $statusList ) 89 89 #set( $from = ", BaseObject as obj, LargeStringProperty as prop0, LargeStringProperty as prop1, StringProperty as prop2" ) 90 - #set( $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 = 'author' and prop1.name = 'editor' and ( prop0.value like '$userString' or ( prop0.value = '' and prop1.value like '$userString' ) ) and prop2.name = 'status' and prop2.value = '$status'" ) 91 + #set( $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 = 'author' and prop1.name = 'editor' and ( prop0.value like '$userString' or ( prop0.value = '' and prop1.value like '$userString' ) ) and prop2.name = 'status' and prop2.value = '$status'" ) 91 91 #set( $sql = $from + " where " + $where ) 92 92 #set( $pubFound = $xwiki.searchDocuments($sql) ) 93 - #set($pubStatusNo = $pubFound.size())94 +$pubFound.size() 94 94 #if( $pubStatusNo > 0 ) 95 95 #set( $pubMap[$status] = $pubFound ) 96 96 #set( $pubNo = $pubNo + $pubStatusNo ) ... ... @@ -110,15 +110,8 @@ 110 110 #if( $pubMap.keySet().size() > 1 ) 111 111 ## found more than one status 112 112 {{id name="index"/}} 113 -(% style="font-size:smaller; text-align:right; padding:1em 1.5em 0.25em 1.5em; background-color:$theme.highlightColor" %)(((#foreach( $status in $pubMap.keySet() )#if( !$foreach.first ) | #end[[{{pubStatus uppercase='false' plural='true'}}$status{{/pubStatus}}>>||anchor="$status"]]#end))) 114 +(% style="font-size:smaller; text-align:right; padding:1em 1.5em 0.25em 1.5em; background-color:$theme.highlightColor" %)(((#foreach( $status in $pubMap.keySet() )#if( !$foreach.first ) | #end[[{{pubStatus uppercase='false' plural='true'}}$statusPar{{/pubStatus}}>>||anchor="$status"]]#end))) 114 114 #end 115 -## pubs displayed per year 116 -#foreach( $status in $pubMap.keySet() ) 117 -(% style="border-style:solid hidden hidden solid; border-color:$theme.borderColor; text-align:left; font-style:oblique" %)|{{id name='$status'/}}[[{{pubStatus uppercase='false' plural='true'}}$status{{/pubStatus}}>>$doc.name||queryString='status=$status#if( $oneUser )#if( $apiceUser )&user=$userName#{else}&name=$userFirstName&surname=$userLastName#end#end']] 118 - #foreach( $pub in $pubMap[$year] ) 119 -(% style="border-style:hidden hidden hidden hidden" %)|{{pub inline='false' linked='title'}}$pub{{/pub}} 120 - #end 121 - #set( $pubStatusNo = $pubMap[$year].size() ) 122 -(% style="border-style:hidden solid solid hidden; border-color:$theme.borderColor; text-align:right; font-style:oblique; font-size:smaller" %)|($pubStatusNo #if( $pubStatusNo == 1 ){{stringEngIta eng='publication' ita='pubblicazione'/}} {{pubStatus uppercase='false' plural='false'}}$status{{/pubStatus}}#{else}{{stringEngIta eng='publications' ita='pubblicazioni'/}} {{pubStatus uppercase='false' plural='true'}}$status{{/pubStatus}}#end) [[[{{stringEngIta eng='top' ita='in cima'/}}]>>||anchor="top"]] [[[{{stringEngIta eng='bottom' ita='in fondo'/}}]>>||anchor="bottom"]] 123 -#end 116 + 117 + 124 124 {{/velocity}}