Exemple #1
0
 /**
  * Modify a predicate by adding additional clauses.
  *
  * @param \Titon\Db\Query\Predicate $predicate
  * @param int $type
  * @param string $field
  * @param mixed $op
  * @param mixed $value
  * @return $this
  * @throws \Titon\Db\Exception\ExistingPredicateException
  */
 protected function _modifyPredicate(&$predicate, $type, $field, $op, $value)
 {
     if (!$predicate) {
         $predicate = new Predicate($type);
     } else {
         if ($predicate->getType() !== $type) {
             throw new ExistingPredicateException(sprintf('Predicate clause already created using "%s" conjunction', $predicate->getType()));
         }
     }
     if ($field instanceof Closure) {
         $predicate->bindCallback($field, $this);
     } else {
         if ($value !== null || in_array($op, [Expr::NULL, Expr::NOT_NULL], true)) {
             $predicate->add($field, $op, $value);
         } else {
             if ($op === '!=') {
                 $predicate->notEq($field, $value);
             } else {
                 $predicate->eq($field, $op);
             }
         }
     }
     return $this;
 }
Exemple #2
0
 /**
  * Generate a new sub-grouped NOR predicate.
  *
  * @param \Closure $callback
  * @return $this
  */
 public function neither(Closure $callback)
 {
     $predicate = new Predicate(self::NEITHER);
     $predicate->bindCallback($callback);
     $this->_params[] = $predicate;
     $this->addBinding(null, $predicate);
     return $this;
 }