soupmix /
sql
| @@ 169-179 (lines=11) @@ | ||
| 166 | $subKey = array_keys($orValue)[0]; |
|
| 167 | $subValue = $orValue[$subKey]; |
|
| 168 | $sqlOptions = self::buildFilter([$subKey=>$subValue]); |
|
| 169 | if(in_array($sqlOptions['method'], ['in','notIn',''])){ |
|
| 170 | $queryBuilder->orWhere( |
|
| 171 | $queryBuilder->expr()->{$sqlOptions['method']}( $sqlOptions['key'], $sqlOptions['value']) |
|
| 172 | ); |
|
| 173 | } |
|
| 174 | else{ |
|
| 175 | $queryBuilder->orWhere( |
|
| 176 | $sqlOptions['key'] |
|
| 177 | . ' ' . $sqlOptions['operand'] |
|
| 178 | . ' ' . $queryBuilder->createNamedParameter($sqlOptions['value'])); |
|
| 179 | } |
|
| 180 | } |
|
| 181 | } else { |
|
| 182 | $sqlOptions = self::buildFilter([$key=>$value]); |
|
| @@ 183-193 (lines=11) @@ | ||
| 180 | } |
|
| 181 | } else { |
|
| 182 | $sqlOptions = self::buildFilter([$key=>$value]); |
|
| 183 | if(in_array($sqlOptions['method'], ['in', 'notIn', ''])){ |
|
| 184 | $queryBuilder->andWhere( |
|
| 185 | $queryBuilder->expr()->{$sqlOptions['method']}( $sqlOptions['key'], $sqlOptions['value']) |
|
| 186 | ); |
|
| 187 | } |
|
| 188 | else{ |
|
| 189 | $queryBuilder->andWhere( |
|
| 190 | $sqlOptions['key'] |
|
| 191 | . ' ' . $sqlOptions['operand'] |
|
| 192 | . ' ' . $queryBuilder->createNamedParameter($sqlOptions['value'])); |
|
| 193 | } |
|
| 194 | } |
|
| 195 | } |
|
| 196 | } |
|
