Wiki source code of AllAttachmentsResults

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: ## @programming This service page needs to be saved by a user with the programming access level
6: ## to work as expected
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($title = $request.get("doc.name"))
14: #set($author = $request.get("doc.author"))
15: #set($space = $request.get("doc.space"))
16: #set($filename = $request.filename)
17: #set($formatDate = "yyyy MMMM dd, HH:mm")
18: #if($title)
19:   #set($title = $title.trim().toLowerCase())
20:   #set($sql = "and lower(doc.fullName) like ’%${title}%’ ")
21: #else #set($sql = "and lower(doc.fullName) <> ’’ ") #end
22: #if($author)
23:   #set($author = $author.trim().toLowerCase())
24:   #set($sql = $sql + "and lower(attach.author) like ’%${author}%’ ")
25: #end
26: #if($filename)
27:   #set($filename = $filename.trim().toLowerCase())
28:   #set($sql = $sql + "and lower(attach.filename) like ’%${filename}%’ ")
29: #end
30: #if($space)
31:   #set($space = $space.trim().toLowerCase())
32:   #set($sql = $sql + "and lower(doc.space) like ’%${space}%’ ")
33: #end
34: ## 
35: ## Exclude Blacklisted spaces ($blacklistedSpaces is set in xwikivars.vm)
36: ##
37: #foreach ($blacklistedSpace in $blacklistedSpaces)
38:   #set ($sql = "${sql} and doc.space <> ’$blacklistedSpace’")
39: #end
40: #if("$!request.sort" != "") #set($order = $request.sort) #else #set($order="attach.filename") #end
41: #if($order == "filename") #set($order = "attach.filename") #end
42: #if("$!request.dir" != "") #set($dir = $request.dir) #else #set($dir = "asc") #end
43: #set($sql = "select doc.fullName, attach from XWikiDocument as doc, XWikiAttachment as attach where attach.docId=doc.id " + $sql + " order by $order $dir")
44: #set($items = $xwiki.search($sql, $limit, $off))
45: #set($totalItems = $xwiki.search($sql).size())
46: #set($returnedItems = $items.size())
47: ## ==============================================
48: ## json starts
49: ## ==============================================
50: {
51: "totalrows": $totalItems,
52: "returnedrows": #if($returnedItems < $limit) $returnedItems #else $limit #end,
53: "offset": $offset,
54: "reqNo": $request.reqNo,
55: "rows": [
56: #foreach($item in $items)
57:   #foreach($element in $item)
58:     #if($velocityCount==1) 
59:       #set($docName=$element) 
60:       #set($acclev = $xwiki.hasAccessLevel("view", $context.user, $docName)) 
61:     #else 
62:       #set($attachment=$element) 
63:     #end
64:   #end
65:   #set($document = $xwiki.getDocument($docName))  
66:   #if($velocityCount > 1) , #end
67:   {"acclev"    : $acclev,     
68:      "page"  : "$document.name",
69:      "space" : "$document.space",
70:      "fullname"  : "$document.fullName"#if ($acclev),
71:      "filename"    : "$attachment.filename",
72:      "fileurl" : "$document.getAttachmentURL($attachment.filename)",
73:      "url" : "$document.getURL(’view’)",
74:      "spaceurl" : ’$xwiki.getURL("${document.space}.WebHome","view")’,
75:      "date" : "$xwiki.formatDate($attachment.date,$formatDate)",
76:      "author" : "$attachment.author",
77:      "authorname" : "$xwiki.getDocument($attachment.author).name",
78:      "authorurl" : "$xwiki.getURL($attachment.author,’view’)",
79:      "type" : "$attachment.getMimeType($context.context)"
80:    #end ## acclev
81:    }  
82: #end
83: ]}
84: ## ==============================================
85: ## json ended
86: ## ==============================================
87: #end
88: {/pre}
AllAttachmentsResults

Top Menu

Wiki source code of AllAttachmentsResults

Search

Quick Links

My Recent Modifications
