Module:Reports

Documentation for this module may be created at Module:Reports/doc

local p = {}

function p.taskCreationClosureReport(frame)
	local start = {
		year = frame.args[1],
		month = frame.args[2],
		day = frame.args[3]
	}
	local step = frame.args[4]
	local count = frame.args[5]
	local timestamp_start = os.time( start )
	local s = ''
	local created = 0
	local closed = 0
	for index = 1, count do
		local timestamp_stop = timestamp_start + (step * 86400)
		local result = mw.smw.getQueryResult(
			'[[Category:Phabricator Tasks]][[Has subobject.Project::~Core Platform Team Workboards*]]' ..
			'[[Task Created Timestamp::>' .. timestamp_start .. ']]' ..
			'[[Task Created Timestamp::<<' .. timestamp_stop .. ']]' ..
			'|limit=3000' )
		if result ~= nil then
			created = created + #result.results
		end
		result = mw.smw.getQueryResult(
			'[[Category:Phabricator Tasks]][[Has subobject.Project::~Core Platform Team Workboards*]]' ..
			'[[Task Closed Timestamp::>' .. timestamp_start .. ']]' ..
			'[[Task Closed Timestamp::<<' .. timestamp_stop .. ']]' ..
			'|limit=3000' )
		if result ~= nil then
			closed = closed + #result.results
		end
		s = s .. 'Created ;' .. os.date('%Y-%m-%d', timestamp_stop) .. ';' .. created .. '\n'
		s = s .. 'Closed ;' .. os.date('%Y-%m-%d', timestamp_stop) .. ';' .. closed .. '\n'
		timestamp_start = timestamp_stop
	end
	return s
end

function p.greenDoneReport(frame)
	local sprintDates = {
		'2019-09-02',
		'2019-09-16',
		'2019-09-30',
		'2019-10-14',
		'2019-10-28',
		'2019-11-11',
		'2019-12-02'
	}
	local points = {}
	s = ''
	for index = 2, #sprintDates do
		sum = 0
		local result = mw.smw.getQueryResult(
			'[[Project::Core Platform Team Workboards (Green)]][[Column::Done]]' ..
			'[[Column Entry Date::>>' .. sprintDates[index - 1] .. ']]' ..
			'[[Column Entry Date::<' .. sprintDates[index] .. ']]' ..
			'|?-Has subobject.Points' )
		if result ~= nil then
			for k,v in pairs( result.results ) do
				if #v.printouts.Points > 0 then
					sum = sum + v.printouts.Points[next(v.printouts.Points)]
				end
			end
			s = s .. sprintDates[index] .. ',' .. sum .. '\n'
		end
	end
	return s
end

return p