SprintService::getDateEndFromLastPlannedSprint

public function getDateEndFromLastPlannedSprint(int $groupId): ?int
{
	$sprint = new EntityForm();

	$queryObject = EntityTable::getList([
		'select' => ['ID', 'DATE_END'],
		'filter' => [
			'GROUP_ID'=> $groupId,
			'=ENTITY_TYPE' => EntityForm::SPRINT_TYPE,
			'=STATUS' => EntityForm::SPRINT_PLANNED,
		],
		'order' => [
			'DATE_START' => 'DESC',
		]
	]);
	if ($data = $queryObject->fetch())
	{
		$sprint->fillFromDatabase($data);
	}

	if ($sprint->isEmpty())
	{
		return null;
	}

	return $sprint->getDateEnd()->getTimestamp();
}