MKSP - JSONTaskSource

version	line-number	content
1.1	1	{{velocity output="false"}}
	2	#macro (putOrDefault $map $propertyName $value $default1)
	3	#if ($value)
	4	#set ($discard = $map.put($propertyName, $value))
	5	#else
	6	#set ($discard = $map.put($propertyName, $default1))
	7	#end
	8	#end
	9
	10	#macro (csvToArray $csvString $return)
	11	## This macro escapes commas using backslashes, to not break when csv items contain commas.
	12	## TODO: Also escape backslashes, as a csv item ending with one will not be interpreted correctly.
	13	#set ($csv = $csvString.split('(?<!\\),'))
	14	#set ($newArray = [])
	15	#foreach ($elem in $csv)
	16	#set ($discard = $newArray.add($elem.replace('\,', ',')))
	17	#end
	18	#set ($discard = $return.put('csvReturn', $newArray))
	19	#end
	20	{{/velocity}}{{velocity wiki="false"}}
	21	##
	22	## This page prepares and returns the JSON of tasks used in the frappe-gantt library, in the taskgantt macro.
	23	## Parameters are the same as taskgantt macro, with an optional 'taskId'.
	24	## When the 'taskId' is present, only that task will be returned, regardless of other parameters.
	25	##
	26	#if ($xcontext.action == 'get')
	27	#set ($discard = $response.setContentType('application/json'))
	28	#set ($query = 'from doc.object(TaskManager.TaskManagerClass) as task' +
	29	" where doc.space <> 'TaskManager.TaskManagerTemplates'" +
	30	' and (task.startDate is not NULL or task.createDate is not NULL)')
	31	#if ("$!request.taskId" != '')
	32	## Short-circuit if the request is for a specific task.
	33	#set ($query = $query + ' and doc.fullName = (:taskId)')
	34	#set ($query = $services.query.xwql($query).setLimit(1))
	35	#set ($query = $query.bindValue('taskId', $request.taskId))
	36	#else
	37	#if ("$!request.spaces" != '')
	38	#set ($spaces = {})
	39	#csvToArray($request.spaces $spaces)
	40	#set ($spaces = $spaces['csvReturn'])
	41	## Filter by exact space and by subspaces.
	42	#set ($query = $query + ' and (doc.space in (:spaces)')
	43	#set ($index = 0)
	44	#foreach ($space in $spaces)
	45	#set ($query = $query + " or doc.space like :spaces${index}")
	46	#set ($index = $index + 1)
	47	#end
	48	#set ($query = $query + ')')
	49	#end
	50	#if ("$!request.assignees" != '')
	51	#set ($assignees = {})
	52	#csvToArray($request.assignees $assignees)
	53	#set ($assignees = $assignees['csvReturn'])
	54	#set ($assigneeQuery = '')
	55	#foreach ($assignee in $assignees)
	56	#if ($assigneeQuery.length() > 0)
	57	#set ($assigneeQuery = "$assigneeQuery OR")
	58	#end
	59	## The task contains at least one of the specified users.
	60	#set ($assigneeQuery = "$assigneeQuery task.assignee LIKE '%$escapetool.sql($assignee),%'" +
	61	" OR task.assignee LIKE '%$escapetool.sql($assignee)'")
	62	#end
	63	#set ($query = "$query AND ($assigneeQuery)")
	64	#end
	65	#if ("$!request.reporters" != '')
	66	#set ($reporters = {})
	67	#csvToArray($request.reporters $reporters)
	68	#set ($reporters = $reporters['csvReturn'])
	69	#set ($query = $query + " and task.reporter in (:reporters)")
	70	#end
	71	#if ("$!request.projects" != '')
	72	#set ($projects = {})
	73	#csvToArray($request.projects $projects)
	74	#set ($projects = $projects['csvReturn'])
	75	#set ($query = $query + " and task.project in (:projects)")
	76	#end
	77	#if ("$!request.from" != '')
	78	#set ($from = $datetool.toDate($numbertool.toNumber($request.from).longValue()))
	79	#set ($query = $query + ' and (' +
	80	'(task.startDate is not NULL and task.startDate >= :from) or ' +
	81	'(task.startDate is NULL and task.createDate >= :from))'
	82	)
	83	#end
	84	#if ($request.hideNoDueDate != 'false')
	85	#set ($query = $query + ' and task.duedate is not NULL')
	86	#end
	87	#if ("$!request.to" != '')
	88	#set ($to = $datetool.toDate($numbertool.toNumber($request.to).longValue()))
	89	#set ($query = $query + ' and (' +
	90	'(task.duedate is not NULL and task.duedate <= :to) or ' +
	91	'(task.duedate is NULL and (' +
	92	'(task.startDate is not NULL and task.startDate <= :to) or ' +
	93	'(task.startDate is NULL and task.createDate <= :to))' +
	94	'))'
	95	)
	96	#end
	97	#if ("$!request.maxTasks" != '')
	98	#set ($maxTasks = $numbertool.toNumber($request.maxTasks))
	99	#else
	100	#set ($maxTasks = 50)
	101	#end
	102	## Sort the tasks by project and name to ensure a stable order.
	103	#set ($query = $query + ' order by UPPER(task.project), task.project, UPPER(task.name), task.name')
	104	#set ($query = $services.query.xwql($query).setLimit($maxTasks))
	105	#if ($spaces)
	106	#set ($query = $query.bindValue("spaces", $spaces))
	107	#set ($index = 0)
	108	#foreach ($space in $spaces)
	109	#set ($space = $space + '.%')
	110	#set ($query = $query.bindValue("spaces${index}", $space))
	111	#set ($index = $index + 1)
	112	#end
	113	#end
	114	#if ($projects) #set ($query = $query.bindValue('projects', $projects)) #end
	115	#if ($reporters) #set ($query = $query.bindValue('reporters', $reporters)) #end
	116	#if ($from) #set ($query = $query.bindValue('from', $from)) #end
	117	#if ($to) #set ($query = $query.bindValue('to', $to)) #end
	118	#end
	119	#set ($queryResult = $query.addFilter('hidden').addFilter('currentlanguage').execute())
	120
	121	#set ($tasks = [])
	122	#foreach ($taskDocument in $queryResult)
	123	#set ($taskXDoc = $xwiki.getDocument($taskDocument))
	124	#set ($task = $taskXDoc.getObject('TaskManager.TaskManagerClass'))
	125	#if ($services.security.authorization.hasAccess('view', $taskDocument))
	126	#set ($taskObj = {})
	127	#set ($customClasses = [])
	128	#set ($discard = $taskObj.put('id', "$taskXDoc.getDocumentReference()"))
	129	#set ($discard = $taskObj.put('link', $taskXDoc.getURL()))
	130	#putOrDefault($taskObj 'taskName'
	131	$task.getValue('name')
	132	$services.localization.render('taskmanager.gantt.task.unknownTaskTitle')
	133	)
	134	#putOrDefault($taskObj 'progress'
	135	$task.getValue('progress')
	136	0
	137	)
	138	#putOrDefault($taskObj 'project' $task.getValue('project') '')
	139	#putOrDefault($taskObj 'assignee' $task.getValue('assignee') '')
	140	#putOrDefault($taskObj 'reporter' $task.getValue('reporter') '')
	141	#putOrDefault($taskObj 'start'
	142	$task.getValue('startDate').getTime()
	143	$task.getValue('createDate').getTime()
	144	)
	145	#putOrDefault($taskObj 'end'
	146	$task.getValue('duedate').getTime()
	147	$xwiki.jodatime.getDateTime($taskObj['start']).plusWeeks(1).getMillis()
	148	)
	149	#if ("$!task.getValue('duedate').getTime()" == '')
	150	#set ($discard = $customClasses.add('taskgantt-no-due-date'))
	151	#end
	152	#if (!$services.security.authorization.hasAccess('edit', $taskDocument))
	153	#set ($discard = $customClasses.add('taskgantt-no-edit'))
	154	#end
	155	#set ($dependencies = [])
	156	#foreach ($dep in $task.getValue('dependencies'))
	157	#set ($discard = $dependencies.add("$xwiki.getDocument($dep).getDocumentReference()"))
	158	#end
	159	#set ($discard = $taskObj.put('dependencies', $dependencies))
	160	#set ($discard = $taskObj.put('taskClasses', $customClasses))
	161	#set ($discard = $tasks.add($taskObj))
	162	#end
	163	#end
	164	$jsontool.serialize($tasks)
	165	#end
	166	{{/velocity}}