PHP arpspecification\entity\spec\adapter QueryBuilderAdapterInterface Examples

Example #1

File: Comparison.php Project: alex-patterson-webdev/arp-orm-specification

 /**
  * filter
  *
  * Construct the query by applying the specifications
  *
  * @param  \ArpSpecification\Entity\Spec\Adapter\QueryBuilderAdapterInterface $adapter
  * @return mixed
  */
 public function filter(QueryBuilderAdapterInterface $adapter)
 {
     $qb = $adapter->getQueryBuilder();
     $right = $this->right;
     //  Bind the value as a query parameter
     if ($this->bind) {
         $right = '?' . $adapter->getParameterIndex($right);
     }
     return new ComparisonExpr($this->left, $this->operator, $right);
 }

Example #2

File: OrX.php Project: alex-patterson-webdev/arp-orm-specification

 /**
  * filter
  *
  * Filter the query by applying the specifications
  *
  * @param  \ArpSpecification\Entity\Spec\Adapter\QueryBuilderAdapterInterface $adapter
  * @return mixed
  */
 public function filter(QueryBuilderAdapterInterface $adapter)
 {
     $queryBuilder = $adapter->getQueryBuilder();
     $orX = $queryBuilder->expr()->orX();
     foreach ($this->specs as $spec) {
         if ($spec instanceof SpecificationInterface) {
             $orX->add($spec->filter($adapter));
         }
     }
     return $orX;
 }

Example #3

File: IsNotIn.php Project: alex-patterson-webdev/arp-orm-specification

 /**
  * filter
  *
  * Filter the query builder
  *
  * @param \ArpSpecification\Entity\Spec\Adapter\QueryBuilderAdapterInterface $adapter
  */
 public function filter(QueryBuilderAdapterInterface $adapter)
 {
     $qb = $adapter->getQueryBuilder();
     return $qb->expr()->notIn($this->name, $this->getParams());
 }

Example #4

File: IsIn.php Project: alex-patterson-webdev/arp-orm-specification

 /**
  * filter
  *
  * Filter the query builder
  *
  * @param \ArpSpecification\Entity\Spec\Adapter\QueryBuilderAdapterInterface $adapter
  */
 public function filter(QueryBuilderAdapterInterface $adapter)
 {
     $qb = $adapter->getQueryBuilder();
     //$placeholder = '?' . $adapter->getParameterIndex($this->getParams());
     return $qb->expr()->in($this->name, $this->getParams());
 }

Example #5

File: IsNull.php Project: alex-patterson-webdev/arp-orm-specification

 /**
  * filter
  *
  * Construct the query by applying the specifications
  *
  * @param  \ArpSpecification\Entity\Spec\Adapter\QueryBuilderAdapterInterface $adapter
  * @return mixed
  */
 public function filter(QueryBuilderAdapterInterface $adapter)
 {
     $queryBuilder = $adapter->getQueryBuilder();
     $expr = $queryBuilder->expr();
     return $expr->isNull($this->operand);
 }