Wiki source code of JSONService

Last modified by Eugen Colesnicov on 2013/03/26 23:29

Show last authors
1 {{velocity filter="html"}}
2 #if($xcontext.action == 'get' && "$!{request.outputSyntax}" == 'plain')
3 $response.setContentType('application/json')
4 #end
5 #if("$!{request.sql}"!="")
6 #set($hql = $request.sql)
7 #else
8 #set($hql =", BaseObject as obj $!{request.fromsql} where doc.fullName=obj.name and obj.className='${request.classname}' $!{request.wheresql}")
9 #end
10 [
11 #set($started = false)
12 #foreach($item in $xwiki.searchDocuments($hql))
13 #set($itemdoc = $xwiki.getDocument($item))
14 #set($startdate = $itemdoc.getValue($request.startfield))
15 #set($duration = $itemdoc.getValue($request.durationfield))
16 #if(!$duration)
17 #set($duration = "30")
18 #end
19 #if($startdate)
20 #set($enddate = $xwiki.jodatime.getDateTime($startdate.getTime()))
21 #set($enddate = $enddate.plusMinutes($util.parseInt($duration)))
22 #if($started)
23 ,
24 #else
25 #set($started = true)
26 #end
27 { "id" : "${itemdoc.fullName}", "title" : "${escapetool.xml($itemdoc.displayTitle)}", "url" : "${escapetool.javascript($itemdoc.getExternalURL())}", "start" : "$!{xwiki.formatDate($startdate, 'yyyy-MM-dd THH:mm')}", "end" : "$!{xwiki.formatDate($enddate.toDate(), 'yyyy-MM-ddTHH:mm')}", "allDay" : false }
28 #end
29 #end
30 ]
31 {{/velocity}}