src/Cms/TenantBundle/Doctrine/TenantRepository.php line 94

Open in your IDE?
  1. <?php
  3. namespace Cms\TenantBundle\Doctrine;
  5. use Cms\CoreBundle\Model\Search\SearchableTrait;
  6. use Cms\CoreBundle\Util\Doctrine\EntityRepository;
  7. use Cms\DomainBundle\Entity\Domain;
  8. use Cms\TenantBundle\Entity\Tenant;
  9. use Cms\TenantBundle\Model\ProductsBitwise;
  10. use Common\Util\Strings;
  12. /**
  13.  * Class TenantRepository
  14.  * @package Cms\TenantBundle\Doctrine
  15.  *
  16.  * @method Tenant findExact($id)
  17.  * @method array|Tenant[] findAll()
  18.  */
  19. final class TenantRepository extends EntityRepository
  20. {
  21.     use SearchableTrait;
  23.     /**
  24.      * @param ProductsBitwise $products
  25.      * @return array|Tenant[]
  26.      */
  27.     public function findAllWithProducts(ProductsBitwise $products)
  28.     {
  29.         return $this->queryMany(
  30.             $this->createQueryBuilder('tenants')
  31.                 ->andWhere('BIT_AND(tenants.products, :products) > 0')
  32.                 ->setParameter('products', $products->getMask())
  33.                 ->addOrderBy('tenants.name', 'ASC')
  34.         );
  35.     }
  37.     /**
  38.      * @param string|int $value
  39.      * @return Tenant
  40.      */
  41.     public function findExactByIdOrSlug($value)
  42.     {
  43.         $value = strval($value);
  44.         if (preg_match('/^[1-9]\d*$/', $value) === 1) {
  45.             return $this->findExact(intval($value));
  46.         }
  47.         return $this->findExactBySlug($value);
  48.     }
  50.     /**
  51.      * @param string $slug
  52.      * @return Tenant
  53.      * @throws \Exception
  54.      */
  55.     public function findExactBySlug($slug)
  56.     {
  57.         $tenant = $this->findOneBySlug($slug);
  58.         if ($tenant === null) {
  59.             throw new \Exception();
  60.         }
  61.         return $tenant;
  62.     }
  64.     /**
  65.      * @param string $host
  66.      * @return Tenant
  67.      * @throws \Exception
  68.      */
  69.     public function findOneByHost($host)
  70.     {
  71.         if (preg_match('/^(.+?)\.([^.]+?\.[^.]+?)$/', $host, $matches) !== 1) {
  72.             throw new \Exception();
  73.         }
  74.         $qb = $this->_em->createQueryBuilder();
  75.         $qb
  76.             ->select('domain')
  77.             ->from(Domain::class, 'domain')
  78.             ->leftJoin('domain.apex', 'apex')
  79.             ->andWhere('apex.host = :host')
  80.             ->setParameter('host', $matches[2])
  81.             ->andWhere('domain.name = :name')
  82.             ->setParameter('name', $matches[1]);
  83.         $domain = $this->queryOne($qb);/** @var Domain $domain */
  84.         if ($domain === null) {
  85.             return null;
  86.         }
  87.         return $domain->getTenant();
  88.     }
  90.     /**
  91.      * @param string $slug
  92.      * @return Tenant
  93.      */
  94.     public function findOneBySlug($slug)
  95.     {
  96.         return $this->findOneBy(array(
  97.             'slug' => $slug,
  98.         ));
  99.     }
  101.     /**
  102.      * @param string $uid
  103.      * @return Tenant
  104.      */
  105.     public function findOneByUid($uid)
  106.     {
  107.         return $this->findOneBy(array(
  108.             'uid' => $uid,
  109.         ));
  110.     }
  112.     /**
  113.      * @param string $slug
  114.      * @return bool
  115.      */
  116.     public function isSlugTaken($slug)
  117.     {
  118.         $result = $this
  119.             ->getEntityManager()
  120.             ->createQuery("
  121.                 SELECT
  122.                     1
  123.                 FROM
  124.                     SharedTenantBundle:Tenant t
  125.                 WHERE
  126.                     t.slug = :slug
  127.             ")
  128.             ->setParameter('slug', $slug)
  129.             ->getScalarResult();
  130.         return (count($result) != 0);
  131.     }
  133.     /**
  134.      * @param string $name
  135.      * @return bool
  136.      */
  137.     public function isNameTaken($name)
  138.     {
  139.         $result = $this
  140.             ->getEntityManager()
  141.             ->createQuery("
  142.                 SELECT
  143.                     1
  144.                 FROM
  145.                     SharedTenantBundle:Tenant t
  146.                 WHERE
  147.                     t.name = :name
  148.             ")
  149.             ->setParameter('name', $name)
  150.             ->getScalarResult();
  151.         return (count($result) != 0);
  152.     }
  154.     /**
  155.      * @param string $slug
  156.      * @return Tenant[]
  157.      */
  158.     public function findTenantForView($slug)
  159.     {
  160.         return $this->findOneBy(array(
  161.             'slug' => $slug,
  162.         ));
  163.     }
  164. }