/** * @param Fetcher $fetcher * @param FetcherOperation $operation * @return array query and params */ protected function getOperationAsString(Fetcher $fetcher, FetcherOperation $operation) { $query = ''; $params = array(); if ($operation instanceof SimpleOperation) { $operator = $operation->getOperator(); if ($operator === Fetcher::TYPE_IN) { $newOperation = new ListOperation(Fetcher::OPERATOR_OR); foreach ($operation->getValue() as $val) { $newOperation->addOperation(new SimpleOperation(Fetcher::TYPE_EQ, $operation->getColumnName(), $val)); } list($query, $params) = $this->getOperationAsString($fetcher, $newOperation); } elseif ($operator === Fetcher::TYPE_NOT_IN) { $newOperation = new ListOperation(Fetcher::OPERATOR_AND); foreach ($operation->getValue() as $val) { $newOperation->addOperation(new SimpleOperation(Fetcher::TYPE_DIFF, $operation->getColumnName(), $val)); } list($query, $params) = $this->getOperationAsString($fetcher, $newOperation); } else { if ($operator === Fetcher::TYPE_CUSTOM) { $value = $operation->getValue(); if (!$value instanceof OperationValue) { throw new \Exception('OperationValue expected'); } list($operationValueQuery, $operationValueParams) = $value->getOperationValue($operation->getColumnName()); if (empty($operationValueParams)) { $query .= $operationValueQuery; } else { $query .= vsprintf($operationValueQuery, array_fill(0, count($operationValueParams), '?')); foreach ($operationValueParams as $valueParam) { $params[] = $valueParam; } } } else { $query = $fetcher->strColumnFilterToDbNotation($operation->getColumnName(), $operator); $query .= ' '; $query .= $fetcher->strFilterToDbNotation($operator); if ($operator !== Fetcher::TYPE_IS_NOT_NULL && $operator !== Fetcher::TYPE_IS_NULL) { // If the operation has 2 members $params[] = $this->getOperationValue($operation); } } } } elseif ($operation instanceof ListOperation) { $operations = $operation->getOperations(); $strings = array(); foreach ($operations as $currentOperation) { list($returnQuery, $returnParams) = $this->getOperationAsString($fetcher, $currentOperation); $strings[] = $returnQuery; $params = array_merge($params, $returnParams); } $query = implode($operation->getOperator(), $strings); } else { throw new \InvalidArgumentException('Givent operation is not supported'); } return array('(' . $query . ')', $params); }
/** * Sets the main operator (AND or OR) * @param string $operator self::OPERATOR_AND or self::OPERATOR_OR * @throws \InvalidArgumentException */ public function setMainOperator($operator) { switch ($operator) { case self::OPERATOR_AND: $this->mainOperator = self::OPERATOR_AND; break; case self::OPERATOR_OR: $this->mainOperator = self::OPERATOR_OR; break; default: throw new \InvalidArgumentException(__CLASS__ . '::' . __FUNCTION__ . '() First argument should be ' . __CLASS__ . '::OPERATOR_AND or ' . __CLASS__ . '::OPERATOR_OR constant'); break; } $this->rootOperation->setOperator($this->mainOperator); }