api/src/Match/Repository/MassPersonRepository.php
<?php
/**
* Copyright (c) 2018, MOBICOOP. All rights reserved.
* This project is dual licensed under AGPL and proprietary licence.
***************************
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as
* published by the Free Software Foundation, either version 3 of the
* License, or (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <gnu.org/licenses>.
***************************
* Licence MOBICOOP described in the file
* LICENSE
*/
namespace App\Match\Repository;
use App\Match\Entity\Mass;
use App\Match\Entity\MassPerson;
use Doctrine\ORM\EntityManagerInterface;
use Doctrine\ORM\EntityRepository;
/**
* @method null|MassPerson find($id, $lockMode = null, $lockVersion = null)
* @method null|MassPerson findOneBy(array $criteria, array $orderBy = null)
* @method MassPerson[] findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
*/
class MassPersonRepository
{
/**
* @var EntityRepository
*/
private $repository;
public function __construct(EntityManagerInterface $entityManager)
{
$this->repository = $entityManager->getRepository(MassPerson::class);
}
public function find(int $id): ?MassPerson
{
return $this->repository->find($id);
}
/**
* Find All the PassPerson by criteria.
*
* @param null|mixed $limit
* @param null|mixed $offset
*
* @return null|User
*/
public function findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null): ?array
{
return $this->repository->findBy($criteria, $orderBy, $limit, $offset);
}
/**
* Return all destinations for a mass.
*
* @return null|array|\Doctrine\DBAL\Driver\Statement|mixed The destinations (Address) found
*/
public function findAllDestinationsForMass(Mass $mass)
{
$query = $this->repository->createQueryBuilder('mp')
->select('DISTINCT wa.houseNumber, wa.street, wa.postalCode, wa.addressLocality, wa.addressCountry, wa.latitude, wa.longitude')
->leftJoin('mp.workAddress', 'wa')
->andWhere('mp.mass = :mass')
->setParameter('mass', $mass)
->getQuery()
;
return $query->getResult();
}
/**
* Return all origins for a mass.
*
* @return null|array|\Doctrine\DBAL\Driver\Statement|mixed The origins (Address) found
*/
public function findAllOriginsForMass(Mass $mass)
{
$query = $this->repository->createQueryBuilder('mp')
->select('DISTINCT pa.houseNumber, pa.street, pa.postalCode, pa.addressLocality, pa.addressCountry, pa.latitude, pa.longitude')
->leftJoin('mp.personalAddress', 'pa')
->andWhere('mp.mass = :mass')
->setParameter('mass', $mass)
->getQuery()
;
return $query->getResult();
}
/**
* Return all the MassPersons related to a mass.
*
* @param Mass $mass The Mass
* @param int $mass The mininum id of the mass persons returned
*
* @return array
*/
public function findAllByMass(Mass $mass, int $idMassPersonMin = null)
{
$query = $this->repository->createQueryBuilder('mp')
->where('mp.mass = :mass')
;
$query = $query->setParameter('mass', $mass);
if (!is_null($idMassPersonMin)) {
$query->andWhere('mp.id >= :idMassPersonMin')->setParameter('idMassPersonMin', $idMassPersonMin);
}
$query = $query->getQuery();
return $query->getResult();
}
}