Esempi in PHP per arpspecification\entity\spec\adapter QueryBuilderAdapterInterface::getQueryBuilder

Esempio n. 1

File: Comparison.php Progetto: 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);
 }

Esempio n. 2

File: OrX.php Progetto: 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;
 }

Esempio n. 3

File: IsNotIn.php Progetto: 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());
 }

Esempio n. 4

File: IsIn.php Progetto: 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());
 }

Esempio n. 5

File: IsNull.php Progetto: 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);
 }