General Actions:
Log-in
Wiki:
L3D's Wiki
▼
:
Document Index
»
Space:
XWiki
▼
:
Document Index
»
Page:
Tableresults
Search
Page Actions:
Export
▼
:
Export as PDF
Export as RTF
Export as HTML
More actions
▼
:
Print preview
View Source
Welcome to your wiki
»
Documents on this Wiki
»
Index
»
Tableresults
Wiki source code of
Tableresults
Last modified by
Administrator
on 2008/04/24 04:34
Content
·
Comments
(0)
·
Attachments
(0)
·
History
·
Information
Show line numbers
{pre} ## ============================================================================================ ## This page is called from live grids via Ajax with the argument xpage=plain. It returns a ## set of results serialized in JSON. ## You can see an example of live grid in XWiki.Tableview (note : this grid doesn't use all the ## serialized fields). ## ============================================================================================ #if($request.get("xpage") && $request.get("xpage") == "plain") #set($offset = $util.parseInt( $request.get( "offset" ) ) ) ## offset starts from 0 in velocity and 1 in javascript #set($off = $offset - 1 ) #set($limit = $util.parseInt($request.get("limit"))) #set($page = $request.get("page")) #set($space = $request.get("space")) #set($author = $request.get("author")) #set($formatDate = "yyyy MMMM dd, HH:mm") #if($page) #set($page = $page.trim().toLowerCase()) #set($sql = "where lower(doc.name) like '%${page}%'") #else #set($sql = "where lower(doc.name) <> ''") #end #if($space) #set($space = $space.trim().toLowerCase()) #set($sql = $sql + "and lower(doc.space) like '%${space}%'") #end #if($author) #set($author = $author.trim().toLowerCase()) #set($sql = $sql + "and lower(doc.author) like '%${author}%'") #end #set($sql = $sql + "order by doc.name") #set($items = $xwiki.searchDocuments($sql, $limit, $off)) #set($totalItems = $xwiki.searchDocuments($sql).size()) #set($returnedItems = $items.size()) ## ============================================== ## json starts ## ============================================== { "totalrows": $totalItems, "returnedrows": #if($returnedItems < $limit) $returnedItems #else $limit #end, "offset": $offset, "reqNo": $request.reqNo, "rows": [ #foreach($item in $items) ## ============================================== ## Fullname ## ============================================== #if($item.class == "class com.xpn.xwiki.plugin.lucene.SearchResult") #set($itemfullname = "${item.wiki}:${item.web}.${item.name}") #else #set($itemfullname = "${context.database}:${item}") #end ##============================================== ## Access level ## ============================================== #set($acclev = $xwiki.hasAccessLevel("view", $context.user, $itemfullname)) ## ============================================== ## Bentrydoc ## ============================================== #set($bentrydoc = "") ## reset the previous value #if($item.class == "class java.lang.String") #set($bentrydoc = $xwiki.getDocument($item)) #elseif ($item.class == "class com.xpn.xwiki.plugin.lucene.SearchResult") #set($bentrydoc = $item) #end #if($acclev && ("$!bentrydoc" != "")) ## ============================================== ## Item url ## ============================================== #set($itemurl = $xwiki.getURL($itemfullname)) ## ============================================== ## Item date ## ============================================== #set($itemdate = $!xwiki.formatDate($!bentrydoc.date, $formatDate)) ## ============================================== ## Page ## ============================================== #set($page = $bentrydoc.name) #set($ptitle = $xwiki.getXMLEncoded($!bentrydoc.getDisplayTitle())) #if($ptitle == $page) #set($ptitle = "") #end ## ============================================== ## Space ## ============================================== #set($space = $bentrydoc.space) #set($spaceurl = $xwiki.getURL("${bentrydoc.wiki}:${bentrydoc.space}.WebHome")) ## ============================================== ## Wiki ## ============================================== #if($xwiki.isVirtualMode()) #set($wiki = $bentrydoc.wiki) #set($wikiurl = $xwiki.getURL("${bentrydoc.wiki}:Main.WebHome")) #end ## ============================================== ## is Attachment ## ============================================== #set($isattach = false) #if ($bentrydoc.type) #set ($ptitle = $xwiki.getDocument($itemfullname).getDisplayTitle()) #if ($bentrydoc.type == "attachment") #set($isattach = true) #set($filename = $bentrydoc.filename) #end #end ## ============================================== ## Has new comment ## ============================================== #set($hasnewcomm = false) #set($cclass = $xwiki.getDocument("XWiki.XWikiComments").getxWikiClass()) #if($xwiki.getWebPreferenceAsInt("commentsorder", 1) == 0) #set($comments = $bentrydoc.getComments()) #else #set($comments = $bentrydoc.getComments(false)) #end #if($comments && $comments.size()>0) #set($i = 0) #set($cobj = $comments.get($i)) #set($date = $cobj.getXWikiObject().get("date").value) #if($date) #set($date1 = $!xwiki.formatDate($date, $formatDate)) #end #if($itemdate.equals($date1)) #set($hasnewcomm = true) #end #end ## ============================================== ## Author ## ============================================== #if($hasnewcomm) #set($author = $cobj.author) #else #set($author = $bentrydoc.author) #end #set($authorpage = $xwiki.getURL($author)) #set($dot = $author.indexOf('.') + 1) #if($dot > 1) #set($author = $author.substring($dot)) #end ## ============================================== ## Actions ## ============================================== #set($copy = $xwiki.getURL("XWiki.CopyDocument", "view", "sourcedoc=${util.encodeURI($itemfullname)}")) #set($delete = $bentrydoc.getURL("delete")) #set($rename = $bentrydoc.getURL("view", "xpage=rename&step=1")) #set($rights = $bentrydoc.getURL("edit", "editor=rights")) #end #if($velocityCount > 1) , #end {"acclev" : $acclev, "fullname" : "$itemfullname"#if($acclev && $bentrydoc && ($bentrydoc != "")), "page" : "$page", "url" : "$itemurl", "title" : "$ptitle", "space" : "$space", "spaceurl" : "$spaceurl", "isvirtual" : $xwiki.isVirtualMode(), #if($xwiki.isVirtualMode()) "wiki" : "$wiki", "wikiurl" : "$!wikiurl", #end ## isVirtualMode "date" : "$itemdate", "author" : "$author", "authorpage" : "$!authorpage", "hasnewcom" : $hasnewcomm, #if($isattach) "filename" : "$filename", #end ## isattach "hasadmin" : $xwiki.hasAdminRights(), "copyurl" : "$copy", "deleteurl" : "$delete", "renameurl" : "$rename", "rightsurl" : "$rights" #end ## acclev } #end ]} ## ============================================== ## json ended ## ============================================== #end {/pre}
Quick Links
L3D Calendar
Wiki Dashboard
Document Index
Blog
Sandbox
