12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273 |
- <?php
- namespace yii\db\oci\conditions;
- use yii\db\conditions\InCondition;
- use yii\db\ExpressionInterface;
- class InConditionBuilder extends \yii\db\conditions\InConditionBuilder
- {
-
- public function build(ExpressionInterface $expression, array &$params = [])
- {
- $splitCondition = $this->splitCondition($expression, $params);
- if ($splitCondition !== null) {
- return $splitCondition;
- }
- return parent::build($expression, $params);
- }
-
- protected function splitCondition(InCondition $condition, &$params)
- {
- $operator = $condition->getOperator();
- $values = $condition->getValues();
- $column = $condition->getColumn();
- if ($values instanceof \Traversable) {
- $values = iterator_to_array($values);
- }
- if (!is_array($values)) {
- return null;
- }
- $maxParameters = 1000;
- $count = count($values);
- if ($count <= $maxParameters) {
- return null;
- }
- $slices = [];
- for ($i = 0; $i < $count; $i += $maxParameters) {
- $slices[] = $this->queryBuilder->createConditionFromArray([$operator, $column, array_slice($values, $i, $maxParameters)]);
- }
- array_unshift($slices, ($operator === 'IN') ? 'OR' : 'AND');
- return $this->queryBuilder->buildCondition($slices, $params);
- }
- }
|