Surfnet\StepupMiddleware\ApiBundle\Configuration\Repository\RaLocationRepository

Complexity

Total Complexity

8

Size/Duplication

Total Lines	84
Duplicated Lines	0 %

Coupling/Cohesion

Components	2
Dependencies	7

Importance

Changes	1
Bugs	0	Features	0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	save()	0	6	1
A	search()	0	18	3
A	findByRaLocationId()	0	8	1
A	findByInstitution()	0	8	1
A	remove()	0	6	1
A	removeRaLocationsFor()	0	9	1

<?php

/**
 * Copyright 2016 SURFnet B.V.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

namespace Surfnet\StepupMiddleware\ApiBundle\Configuration\Repository;

use Doctrine\ORM\EntityRepository;
use Surfnet\Stepup\Configuration\Value\Institution;
use Surfnet\Stepup\Configuration\Value\RaLocationId;
use Surfnet\StepupMiddleware\ApiBundle\Configuration\Entity\RaLocation;
use Surfnet\StepupMiddleware\ApiBundle\Configuration\Query\RaLocationQuery;
use Surfnet\StepupMiddleware\ApiBundle\Exception\RuntimeException;

class RaLocationRepository extends EntityRepository
{
    /**
     * @param RaLocationQuery $query
     * @return null|RaLocation[]
     */
    public function search(RaLocationQuery $query)
    {
        if (!in_array($query->orderBy, ['name', 'location', 'contact_information'])) {
            throw new RuntimeException(sprintf('Unknown order by column "%s"', $query->orderBy));
        }

        $orderBy        = 'rl.'.$query->orderBy;
        $orderDirection = $query->orderDirection === 'asc' ? 'ASC' : 'DESC';

        return $this->getEntityManager()->createQueryBuilder()
            ->select('rl')
            ->from('Surfnet\StepupMiddleware\ApiBundle\Configuration\Entity\RaLocation', 'rl')
            ->where('rl.institution = :institution')
            ->setParameter('institution', $query->institution->getInstitution())
            ->orderBy($orderBy, $orderDirection)
            ->getQuery()
            ->getResult();
    }

    /**
     * @param RaLocationId $raLocationId
     * @return RaLocation[]
     */
    public function findByRaLocationId(RaLocationId $raLocationId)
    {
        return $this->createQueryBuilder('rl')
            ->where('rl.id = :id')
            ->setParameter('id', $raLocationId->getRaLocationId())
            ->getQuery()
            ->getOneOrNullResult();
    }

    /**
     * @param RaLocation $raLocation
     */
    public function save(RaLocation $raLocation)
    {
        $entityManager = $this->getEntityManager();
        $entityManager->persist($raLocation);
        $entityManager->flush();
    }

    /**
     * @param RaLocation $raLocation
     */
    public function remove(RaLocation $raLocation)
    {
        $entityManager = $this->getEntityManager();
        $entityManager->remove($raLocation);
        $entityManager->flush();
    }

    /**
     * @param Institution $institution
     * @return RaLocation[]
     */
    public function findByInstitution(Institution $institution)
    {
        return $this->createQueryBuilder('rl')
            ->where('rl.institution = :institution')
            ->setParameter('institution', $institution->getInstitution())
            ->getQuery()
            ->getResult();
    }

    /**
     * @param Institution $institution
     */
    public function removeRaLocationsFor(Institution $institution)
    {
        $this->createQueryBuilder('rl')
            ->delete()
            ->where('rl.institution = :institution')
            ->setParameter('institution', $institution->getInstitution())
            ->getQuery()
            ->execute();
    }
}