Wiki source code of Tableresults

Last modified by Administrator on 2008/04/24 04:34
Content · Comments (0) · Attachments (0) · History · Information
Hide line numbers
  1: {pre}
  2: ## ============================================================================================
  3: ## This page is called from live grids via Ajax with the argument xpage=plain. It returns a
  4: ## set of results serialized in JSON.
  5: ## You can see an example of live grid in XWiki.Tableview (note : this grid doesn't use all the
  6: ## serialized fields).
  7: ## ============================================================================================
  8: #if($request.get("xpage") && $request.get("xpage") == "plain")
  9: #set($offset = $util.parseInt( $request.get( "offset" ) ) )
 10: ## offset starts from 0 in velocity and 1 in javascript
 11: #set($off = $offset - 1 )
 12: #set($limit = $util.parseInt($request.get("limit")))
 13: #set($page = $request.get("page"))
 14: #set($space = $request.get("space"))
 15: #set($author = $request.get("author"))
 16: #set($formatDate = "yyyy MMMM dd, HH:mm")
 17: #if($page)
 18:   #set($page = $page.trim().toLowerCase())
 19:   #set($sql = "where lower(doc.name) like '%${page}%'")
 20: #else #set($sql = "where lower(doc.name) <> ''") #end
 21: #if($space)
 22:   #set($space = $space.trim().toLowerCase())
 23:   #set($sql = $sql + "and lower(doc.space) like '%${space}%'")
 24: #end
 25: #if($author)
 26:   #set($author = $author.trim().toLowerCase())
 27:   #set($sql = $sql + "and lower(doc.author) like '%${author}%'")
 28: #end
 29: #set($sql = $sql + "order by doc.name")
 30: #set($items = $xwiki.searchDocuments($sql, $limit, $off))
 31: #set($totalItems = $xwiki.searchDocuments($sql).size())
 32: #set($returnedItems = $items.size())
 33: ## ==============================================
 34: ## json starts
 35: ## ==============================================
 36: {
 37: "totalrows": $totalItems,
 38: "returnedrows": #if($returnedItems < $limit) $returnedItems #else $limit #end,
 39: "offset": $offset,
 40: "reqNo": $request.reqNo,
 41: "rows": [
 42: #foreach($item in $items)
 43:   ## ==============================================
 44:   ## Fullname
 45:   ## ==============================================
 46:   #if($item.class == "class com.xpn.xwiki.plugin.lucene.SearchResult")
 47:     #set($itemfullname = "${item.wiki}:${item.web}.${item.name}")
 48:   #else
 49:     #set($itemfullname = "${context.database}:${item}")
 50:   #end
 51:   ##==============================================
 52:   ## Access level
 53:   ## ==============================================
 54:   #set($acclev = $xwiki.hasAccessLevel("view", $context.user, $itemfullname))
 55:   ## ==============================================
 56:   ## Bentrydoc
 57:   ## ==============================================
 58:   #set($bentrydoc = "") ## reset the previous value
 59:   #if($item.class == "class java.lang.String")
 60:     #set($bentrydoc = $xwiki.getDocument($item))
 61:   #elseif ($item.class == "class com.xpn.xwiki.plugin.lucene.SearchResult")
 62:     #set($bentrydoc = $item)
 63:   #end
 64:   #if($acclev && ("$!bentrydoc" != ""))
 65:   ## ==============================================
 66:   ## Item url
 67:   ## ==============================================
 68:   #set($itemurl = $xwiki.getURL($itemfullname))
 69:   ## ==============================================
 70:   ## Item date
 71:   ## ==============================================
 72:   #set($itemdate = $!xwiki.formatDate($!bentrydoc.date, $formatDate))
 73:   ## ==============================================
 74:   ## Page
 75:   ## ==============================================
 76:   #set($page = $bentrydoc.name)
 77:   #set($ptitle = $xwiki.getXMLEncoded($!bentrydoc.getDisplayTitle()))
 78:   #if($ptitle == $page)
 79:   	#set($ptitle = "")
 80:   #end
 81:   ## ==============================================
 82:   ## Space
 83:   ## ==============================================
 84:   #set($space = $bentrydoc.space)
 85:   #set($spaceurl = $xwiki.getURL("${bentrydoc.wiki}:${bentrydoc.space}.WebHome"))
 86:   ## ==============================================
 87:   ## Wiki
 88:   ## ==============================================
 89:   #if($xwiki.isVirtualMode())
 90:     #set($wiki = $bentrydoc.wiki)
 91:     #set($wikiurl = $xwiki.getURL("${bentrydoc.wiki}:Main.WebHome"))
 92:   #end
 93:   ## ==============================================
 94:   ## is Attachment
 95:   ## ==============================================
 96:   #set($isattach = false)
 97:   #if ($bentrydoc.type)
 98:     #set ($ptitle = $xwiki.getDocument($itemfullname).getDisplayTitle())
 99:     #if ($bentrydoc.type == "attachment")
100:       #set($isattach = true)
101:       #set($filename = $bentrydoc.filename)
102:     #end
103:   #end
104:   ## ==============================================
105:   ## Has new comment
106:   ## ==============================================
107:   #set($hasnewcomm = false)
108:   #set($cclass = $xwiki.getDocument("XWiki.XWikiComments").getxWikiClass())
109:   #if($xwiki.getWebPreferenceAsInt("commentsorder", 1) == 0)
110:     #set($comments = $bentrydoc.getComments())
111:   #else
112:     #set($comments = $bentrydoc.getComments(false))
113:   #end
114:   #if($comments && $comments.size()>0)
115:     #set($i = 0)
116:     #set($cobj = $comments.get($i))
117:     #set($date = $cobj.getXWikiObject().get("date").value)
118:     #if($date)
119:       #set($date1 = $!xwiki.formatDate($date, $formatDate))
120:     #end
121:     #if($itemdate.equals($date1))
122:       #set($hasnewcomm = true)
123:     #end
124:   #end
125:   ## ==============================================
126:   ## Author
127:   ## ==============================================
128:   #if($hasnewcomm)
129:     #set($author = $cobj.author)
130:   #else
131:     #set($author = $bentrydoc.author)
132:   #end
133:   #set($authorpage = $xwiki.getURL($author))
134:   #set($dot = $author.indexOf('.') + 1)
135:   #if($dot > 1)
136:     #set($author = $author.substring($dot))
137:   #end
138:   ## ==============================================
139:   ## Actions
140:   ## ==============================================
141:   #set($copy = $xwiki.getURL("XWiki.CopyDocument", "view", "sourcedoc=${util.encodeURI($itemfullname)}"))
142:   #set($delete = $bentrydoc.getURL("delete"))
143:   #set($rename = $bentrydoc.getURL("view", "xpage=rename&amp;step=1"))
144:   #set($rights = $bentrydoc.getURL("edit", "editor=rights"))
145:   #end
146:   #if($velocityCount > 1) , #end
147:   {"acclev"    : $acclev,
148:    "fullname"  : "$itemfullname"#if($acclev && $bentrydoc && ($bentrydoc != "")),
149:    "page"      : "$page",
150:    "url"       : "$itemurl",
151:    "title"     : "$ptitle",
152:    "space"     : "$space",
153:    "spaceurl"  : "$spaceurl",
154:    "isvirtual" : $xwiki.isVirtualMode(),
155:   #if($xwiki.isVirtualMode())
156:    "wiki"      : "$wiki",
157:    "wikiurl"   : "$!wikiurl",
158:   #end ## isVirtualMode
159:    "date"      : "$itemdate",
160:    "author"    : "$author",
161:    "authorpage" : "$!authorpage",
162:    "hasnewcom" : $hasnewcomm,
163:   #if($isattach)
164:    "filename"  : "$filename",
165:   #end ## isattach
166:    "hasadmin"  : $xwiki.hasAdminRights(),
167:    "copyurl"   : "$copy",
168:    "deleteurl" : "$delete",
169:    "renameurl" : "$rename",
170:    "rightsurl" : "$rights"
171:    #end ## acclev
172:   }
173: #end
174: ]}
175: ## ==============================================
176: ## json ended
177: ## ==============================================
178: #end
179: {/pre}
Wiki source code of Tableresults

Quick Links
