Scrumban\Repository\SprintRepository

Complexity

Total Complexity

2

Size/Duplication

Total Lines	27
Duplicated Lines	0 %

Test Coverage

Coverage

0%

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	getSprintByPeriod()	0	11	1
A	getCurrentSprint()	0	12	1

<?php

namespace Scrumban\Repository;

use Doctrine\ORM\EntityRepository;

class SprintRepository extends EntityRepository
{
    public function getCurrentSprint()
    {
        $now = new \DateTime();
        return $this->createQueryBuilder('s')
            ->where('s.beginAt <= :begin_at')
            ->andWhere('s.endedAt >= :ended_at')
            ->setParameters([
                'begin_at' => $now->format('Y-m-d H:i:s'),
                'ended_at' => $now->format('Y-m-d H:i:s')
            ])
            ->getQuery()
            ->getOneOrNullResult();
    }
    
    public function getSprintByPeriod(\DateTime $beginAt, \DateTime $endedAt)
    {
        return $this->createQueryBuilder('s')
            ->where('s.endedAt >= :begin_at')
            ->andWhere('s.beginAt <= :ended_at')
            ->setParameters([
                'begin_at' => $beginAt->format('Y-m-d H:i:s'),
                'ended_at' => $endedAt->format('Y-m-d H:i:s')
            ])
            ->getQuery()
            ->getResult();
    }
}