src/Repository/UserRepository.php line 14

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  6. use Symfony\Bridge\Doctrine\RegistryInterface;
  7. use App\Entity\User;
  8. use Doctrine\ORM\QueryBuilder;
  10. class UserRepository extends ServiceEntityRepository {
  12.     public function __construct(RegistryInterface $registry)
  13.     {
  14.         parent::__construct($registry, User::class);
  15.     }
  18.     // DATATABLE
  19.     public function datatableCount($search, $filters){
  20.         $qb = $this->createQueryBuilder("u")
  21.             ->select("COUNT(u)")
  22.             ->leftJoin("u.address", "a")
  23.             ->where("u.deletedAt IS NULL");
  25.         $this->applySearch($qb, $search);
  26.         $this->applyFilters($qb, $filters);
  28.         return $qb->getQuery()->getSingleScalarResult();
  29.     }
  31.     public function datatableList($firstResult, $maxResult, $orderBy, $orderWay, $search, $filters){
  32.         $qb = $this->createQueryBuilder("u")
  33.             ->select("u")
  34.             ->leftJoin("u.address", "a")
  35.             ->where("u.deletedAt IS NULL")
  36.             ->setFirstResult($firstResult)
  37.             ->setMaxResults($maxResult);
  39.         $this->applySearch($qb, $search);
  40.         $this->applyFilters($qb, $filters);
  41.         $this->applyOrder($qb, $orderBy, $orderWay);
  43.         return $qb->getQuery()->getResult();
  44.     }
  46.     private function applySearch(QueryBuilder $qb, $search){
  47.         if($search){
  48.             $qb
  49.                 ->andWhere("u.firstname LIKE :search OR u.lastname LIKE :search OR u.email LIKE :search")
  50.                 ->setParameter("search", "%".$search."%");
  51.         }
  52.         return $qb;
  53.     }
  55.     private function applyFilters(QueryBuilder $qb, $filters){
  56.         if($filters && is_array($filters)){
  57.             //TODO : NO FILTERS YET
  58.         }
  59.         return $qb;
  60.     }
  62.     private function applyOrder(QueryBuilder $qb, $orderBy, $orderWay){
  63.         if($orderBy && $orderWay){
  64.             $orderBy = "u.".$orderBy;
  65.             $orderWay = strtoupper($orderWay);
  66.             $qb->orderBy($orderBy, $orderWay);
  67.         }
  68.         return $qb;
  69.     }
  70. }