soupmix /
sql
| @@ 98-108 (lines=11) @@ | ||
| 95 | if (strpos($key, '__')!==false) { |
|
| 96 | $sqlOptions = self::buildFilter([$key=>$value]); |
|
| 97 | ||
| 98 | if(in_array($sqlOptions['method'], ['in','notIn',''])){ |
|
| 99 | $queryBuilder->andWhere( |
|
| 100 | $queryBuilder->expr()->{$sqlOptions['method']}( $sqlOptions['key'], $sqlOptions['value']) |
|
| 101 | ); |
|
| 102 | } |
|
| 103 | else{ |
|
| 104 | $queryBuilder->andWhere( |
|
| 105 | $sqlOptions['key'] |
|
| 106 | . ' ' . $sqlOptions['operand'] |
|
| 107 | . ' ' . $queryBuilder->createNamedParameter($sqlOptions['value'])); |
|
| 108 | } |
|
| 109 | ||
| 110 | ||
| 111 | } elseif (strpos($key, '__') === false && is_array($value)) { |
|
| @@ 118-128 (lines=11) @@ | ||
| 115 | if (strpos($subKey, '__')!==false) { |
|
| 116 | $sqlOptions = self::buildFilter([$subKey=>$subValue]); |
|
| 117 | ||
| 118 | if(in_array($sqlOptions['method'], ['in','notIn',''])){ |
|
| 119 | $queryBuilder->orWhere( |
|
| 120 | $queryBuilder->expr()->{$sqlOptions['method']}( $sqlOptions['key'], $sqlOptions['value']) |
|
| 121 | ); |
|
| 122 | } |
|
| 123 | else{ |
|
| 124 | $queryBuilder->orWhere( |
|
| 125 | $sqlOptions['key'] |
|
| 126 | . ' ' . $sqlOptions['operand'] |
|
| 127 | . ' ' . $queryBuilder->createNamedParameter($sqlOptions['value'])); |
|
| 128 | } |
|
| 129 | } else { |
|
| 130 | $queryBuilder->orWhere($subKey . '=' . $queryBuilder->createNamedParameter($subValue)); |
|
| 131 | } |
|
