thecodingmachine /
magic-query
| @@ 46-50 (lines=5) @@ | ||
| 43 | $select->setFrom($from); |
|
| 44 | } |
|
| 45 | ||
| 46 | if (isset($desc['WHERE'])) { |
|
| 47 | $where = NodeFactory::mapArrayToNodeObjectList($desc['WHERE']); |
|
| 48 | $where = NodeFactory::simplify($where); |
|
| 49 | $select->setWhere($where); |
|
| 50 | } |
|
| 51 | ||
| 52 | if (isset($desc['GROUP'])) { |
|
| 53 | $group = NodeFactory::mapArrayToNodeObjectList($desc['GROUP']); |
|
| @@ 52-56 (lines=5) @@ | ||
| 49 | $select->setWhere($where); |
|
| 50 | } |
|
| 51 | ||
| 52 | if (isset($desc['GROUP'])) { |
|
| 53 | $group = NodeFactory::mapArrayToNodeObjectList($desc['GROUP']); |
|
| 54 | $group = NodeFactory::simplify($group); |
|
| 55 | $select->setGroup($group); |
|
| 56 | } |
|
| 57 | ||
| 58 | if (isset($desc['HAVING'])) { |
|
| 59 | $having = NodeFactory::mapArrayToNodeObjectList($desc['HAVING']); |
|
| @@ 58-62 (lines=5) @@ | ||
| 55 | $select->setGroup($group); |
|
| 56 | } |
|
| 57 | ||
| 58 | if (isset($desc['HAVING'])) { |
|
| 59 | $having = NodeFactory::mapArrayToNodeObjectList($desc['HAVING']); |
|
| 60 | $having = NodeFactory::simplify($having); |
|
| 61 | $select->setHaving($having); |
|
| 62 | } |
|
| 63 | ||
| 64 | if (isset($desc['ORDER'])) { |
|
| 65 | $order = NodeFactory::mapArrayToNodeObjectList($desc['ORDER']); |
|
| @@ 64-68 (lines=5) @@ | ||
| 61 | $select->setHaving($having); |
|
| 62 | } |
|
| 63 | ||
| 64 | if (isset($desc['ORDER'])) { |
|
| 65 | $order = NodeFactory::mapArrayToNodeObjectList($desc['ORDER']); |
|
| 66 | $order = NodeFactory::simplify($order); |
|
| 67 | $select->setOrder($order); |
|
| 68 | } |
|
| 69 | ||
| 70 | if (isset($desc['LIMIT'])) { |
|
| 71 | $descLimit = $desc['LIMIT']; |
|
