src/Repository/ProjectAllocatedHoursRepository.php line 22

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\ProjectAllocatedHours;
  6. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  7. use Doctrine\Persistence\ManagerRegistry;
  9. /**
  10.  * @method ProjectAllocatedHours|null find($id, $lockMode = null, $lockVersion = null)
  11.  * @method ProjectAllocatedHours|null findOneBy(array $criteria, array $orderBy = null)
  12.  * @method ProjectAllocatedHours[]    findAll()
  13.  * @method ProjectAllocatedHours[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  14.  */
  15. class ProjectAllocatedHoursRepository extends ServiceEntityRepository
  16. {
  17.     public function __construct(ManagerRegistry $registry)
  18.     {
  19.         parent::__construct($registry, ProjectAllocatedHours::class);
  20.     }
  22.     public function findByProject($order = 'ASC', $orderBy = "", $project)
  23.     {
  25.         $order = filter_var ( $order, FILTER_SANITIZE_STRING);
  26.         $orderBy = filter_var ( $orderBy, FILTER_SANITIZE_STRING);
  27.         $project = filter_var ($project, FILTER_SANITIZE_NUMBER_INT);
  29.         try{
  30.             $query = $this->createQueryBuilder('project_allocated_hours')
  31.                 ->leftJoin('project_allocated_hours.project', 'p')
  32.                 ->andWhere('p.id = :pid')
  33.                 ->setParameter('pid', $project);
  35.             if ($orderBy === "" ) {
  36.                 $query->orderBy('project_allocated_hours.id', 'ASC');
  37.             } else {
  38.                 $query->orderBy("project_allocated_hours." . $orderBy, $order);
  39.             }
  41.             return $query->getQuery()->getResult();
  42.         }catch (\Exception $exception){
  43.             return [];
  44.         }
  45.     }
  47.     public function countByProject($project)
  48.     {
  49.         $project = filter_var ($project, FILTER_SANITIZE_NUMBER_INT);
  50.         try{
  51.             $query = $this->createQueryBuilder('project_allocated_hours')
  52.                 ->select('count(distinct(project_allocated_hours.id))')
  53.                 ->leftJoin('project_allocated_hours.project', 'p')
  54.                 ->andWhere('p.id = :pid')->setParameter('pid', $project);
  56.             return $query->getQuery()->getSingleScalarResult();
  57.         }catch (\Exception $exception){
  58.             return 0;
  59.         }
  60.     }
  61. }