Wiki source code of Deleted Documents

Last modified by Administrator on 2011/03/02 17:34
Content · Comments (0) · Attachments (0) · History · Information
Hide line numbers
  1: {{velocity}}##
  2: #if(!$xwiki.hasProgrammingRights())
  3:   {{warning}}This document requires programming rights and needs to be saved by an administrator of this Wiki{{/warning}}
  4: #else
  5: #set($dateFormat = 'yyyy MMMM d, HH:mm')
  6: #if(!$request.list)
  7: $xwiki.ssx.use('XWiki.DeletedDocuments')##
  8: $xwiki.jsx.use('XWiki.DeletedDocuments')##
  9: ##
 10: #set($columns = ["ddoc.fullName", "ddoc.title", "ddoc.date", "ddoc.deleter", 'actions'])
 11: #set($columnProperties = {
 12:     'ddoc.fullName'  : { 'type' : 'text', 'size' : 10 },
 13:     'ddoc.title'     : { 'type' : 'text', 'filterable' : false, 'sortable' : false },
 14:     'ddoc.date'      : { 'type' : 'date', 'filterable' : false },
 15:     'ddoc.deleter'   : { 'type' : 'text', 'size' : 10 },
 16:     'actions'        : { 'type' : 'text', 'filterable' : false, 'sortable' : false }
 17:   })##
 18: #set($options = {
 19:     'url'               : "$xwiki.getURL('XWiki.DeletedDocuments', 'view', 'list=1&xpage=plain&outputSyntax=plain')",
 20:     'callback'          : 'XWiki.index.trash.documents.displayEntry',
 21:     'translationPrefix' : 'xe.index.trash.documents.'
 22:   })##
 23: ##
 24: ##
 25: ##
 26: {{html wiki="true" clean="false"}}
 27: <div class="hidden">
 28: #livetable('documentsTrash' $columns $columnProperties $options)
 29: </div>
 30: {{/html}}
 31: ##
 32: ##
 33: ##
 34: 
 35: {{html wiki="true" clean="false"}}
 36: <noscript>
 37:   #set($deletedDocuments = $xwiki.search('select count(ddoc.id) from XWikiDeletedDocument as ddoc').get(0))
 38:   #if($deletedDocuments == 0)
 39: 
 40:     {{info}}$msg.get('xe.index.trash.documents.empty'){{/info}}
 41: 
 42:   #else
 43:   #macro(displayDeletedDoc $id)
 44:     #set($ddoc = $xwiki.getDeletedDocument('', '', "$id"))
 45:     #set($originalDocument = $ddoc.getDocument())
 46:     <tr>
 47:       <td><a href="$originalDocument.getURL('view', "viewer=recyclebin&amp;id=${id}")">$ddoc.fullName</a></td>
 48:       <td>$originalDocument.displayTitle</td>
 49:       <td>$xwiki.formatDate($ddoc.getDate(), $dateFormat)</td>
 50:       <td>$xwiki.getLocalUserName($ddoc.getDeleter())</td>
 51:       <td class="itemActions">
 52:         #if($xwiki.getDocument($ddoc.fullName).isNew())
 53:           #if($ddoc.canUndelete())
 54:             <a href="${originalDocument.getURL('undelete', "id=${id}")}" class="tool restore" title="$msg.get('xe.index.trash.documents.actions.restore.tooltip')">$msg.get('xe.index.trash.documents.actions.restore.text')</a>
 55:           #end
 56:         #else
 57:           <a href="${originalDocument.getURL()}" class="tool cannot-restore" title="$msg.get('xe.index.trash.documents.actions.cannotRestore.tooltip')">$msg.get('xe.index.trash.documents.actions.cannotRestore.text')</a>
 58:         #end
 59:         #if($ddoc.canDelete())
 60:           <a href="${originalDocument.getURL('delete', "id=${id}&amp;xredirect=$util.encodeURI($!request.getRequestURI())?$util.encodeURI($!request.getQueryString())")}" class="tool delete" title="$msg.get('xe.index.trash.documents.actions.delete.tooltip')">$msg.get('xe.index.trash.documents.actions.delete.text')</a>
 61:         #end
 62:       </td>
 63:     </tr>
 64:   #end
 65: ##
 66:   #if("$!{request.view}" == '')
 67:     #set($queryParams = '')
 68:   #else
 69:     #set($queryParams = "view=$!{request.view}")
 70:   #end
 71:   #set($paginationParameters = {
 72:     'totalItems' : $xwiki.search("select count(ddoc.id) from XWikiDeletedDocument as ddoc").get(0),
 73:     'defaultItemsPerPage' : 15,
 74:     'url' : $doc.getURL('view', $queryParams)
 75:   })
 76:   #pagination($paginationParameters)
 77:   <table id="searchResults" class="xwiki-livetable xwiki-livetable-display">
 78:     <thead class="xwiki-livetable-display-header"><tr>
 79:       <th scope="col" class="xwiki-livetable-display-header-text selected asc">$msg.get('xe.index.trash.documents.ddoc.fullName')</th>
 80:       <th scope="col" class="xwiki-livetable-display-header-text">$msg.get('xe.index.trash.documents.ddoc.title')</th>
 81:       <th scope="col" class="xwiki-livetable-display-header-text">$msg.get('xe.index.trash.documents.ddoc.date')</th>
 82:       <th scope="col" class="xwiki-livetable-display-header-text">$msg.get('xe.index.trash.documents.ddoc.deleter')</th>
 83:       <th scope="col" class="xwiki-livetable-display-header-text">$msg.get('xe.index.trash.documents.actions')</th>
 84:     </tr></thead>
 85:     <tbody class="xwiki-livetable-display-body">
 86:     #foreach($item in $xwiki.search('select ddoc.id from XWikiDeletedDocument as ddoc order by ddoc.fullName asc', $paginationParameters.itemsPerPage, $paginationParameters.firstItem))
 87:       #displayDeletedDoc($item)
 88:     #end
 89:     </tbody>
 90:   </table>
 91:   #set($discard = $paginationParameters.put('position', 'bottom'))
 92:   #pagination($paginationParameters)
 93:   #end ## deletedDocuments.size
 94: </noscript>
 95: {{/html}}##
 96: #else ## request.list
 97: ## ============================================================================================
 98: ## This page is called from live table via Ajax with the argument xpage=plain. It returns a
 99: ## set of results serialized in JSON.
100: ## @programming This service page needs to be saved by a user with the programming access level
101: ## to work as expected
102: ## ============================================================================================
103: #if("$!{request.get('xpage')}" == 'plain')
104: $response.setContentType('application/json')
105: #set($offset = $util.parseInt($request.get('offset')))
106: ## offset starts from 0 in velocity and 1 in javascript
107: #set($offset = $offset - 1)
108: #set($limit = $util.parseInt($request.get('limit')))
109: #set($docNameFilter = $request.get('ddoc.fullName'))
110: #set($deleterFilter = $request.get('ddoc.deleter'))
111: #set($sql = '')
112: #if("$!{docNameFilter}" != '')
113:   #set($sql = "and lower(ddoc.fullName) like '%${docNameFilter.trim().toLowerCase()}%' ")
114: #end
115: #if("$!{deleterFilter}" != '')
116:   #set($sql = $sql + "and lower(ddoc.deleter) like '%${deleterFilter.trim().toLowerCase()}%' ")
117: #end
118: #if("$!{request.sort}" != '')
119:   #set($order = $request.sort)
120: #else
121:   #set($order = 'ddoc.id')
122: #end
123: #if("$!{request.dir}" != '')
124:   #set($dir = $request.dir)
125: #else
126:   #set($dir = 'asc')
127: #end
128: #set($selectSql = "select ddoc.id from XWikiDeletedDocument as ddoc where 1=1 " + $sql + " order by $order $dir")
129: #set($countSql = "select count(*) from XWikiDeletedDocument as ddoc where 1=1 " + $sql)
130: #set($items = $xwiki.search($selectSql, $limit, $offset))
131: #set($totalItems = $xwiki.search($countSql).get(0))
132: #set($returnedItems = $items.size())
133: ## ==============================================
134: ## json starts
135: ## ==============================================
136: {
137: "totalrows": $totalItems,
138: "returnedrows": $returnedItems,
139: "offset": ${request.get('offset')},
140: "reqNo": ${request.reqNo},
141: "rows": [
142: #foreach($item in $items)
143:   #set($ddoc = $xwiki.getDeletedDocument('', '', "$item"))
144:   #if($velocityCount > 1) , #end
145:   {
146:      #set($originalDocument = $ddoc.getDocument())
147:      "fullname"  : "$originalDocument.fullName",
148:      "title"  : "$originalDocument.displayTitle",
149:      "url" : "$originalDocument.getURL('view', "viewer=recyclebin&id=${item}")",
150:      "originalUrl" : "$originalDocument.getURL()",
151:      "canDelete" : $ddoc.canDelete(),
152:      "deleteUrl" : "$originalDocument.getURL('delete', "id=${item}")",
153:      "canRestore" : $ddoc.canUndelete(),
154:      "alreadyExists" : !$xwiki.getDocument($ddoc.fullName).isNew(),
155:      "restoreUrl" : "$originalDocument.getURL('undelete', "id=${item}")",
156:      "date" : "$xwiki.formatDate($ddoc.date, $dateFormat)",
157:      "deleter" : "$ddoc.deleter",
158:      "deletername" : "$xwiki.getUserName($ddoc.deleter, false)",
159:      "deleterurl" : "$xwiki.getURL($ddoc.deleter, 'view')"
160:    }
161: #end
162: ]}
163: ## ==============================================
164: ## json ended
165: ## ==============================================
166: #end## xpage=plain
167: #end## request.list
168: #end## hasProgramR
169: {{/velocity}}
Wiki source code of Deleted Documents

Quick Links
