KanbanService::getLastCompletedSprintIdSameGroup

public function getLastCompletedSprintIdSameGroup(int $sprintId): int
{
	$queryObject = EntityTable::getList([
		'select' => ['ID', 'GROUP_ID'],
		'filter' => [
			'ID'=> (int) $sprintId
		]
	]);

	if ($sprintData = $queryObject->fetch())
	{
		$queryObjectLastSprint = EntityTable::getList([
			'select' => ['ID', 'DATE_END'],
			'filter' => [
				'GROUP_ID'=> (int) $sprintData['GROUP_ID'],
				'=ENTITY_TYPE' => EntityForm::SPRINT_TYPE,
				'=STATUS' => EntityForm::SPRINT_COMPLETED
			],
			'order' => ['DATE_END' => 'DESC'],
			'limit' => 1
		]);

		return (($fields = $queryObjectLastSprint->fetch()) ? $fields['ID'] : 0);
	}

	return 0;
}