| @@ 74-78 (lines=5) @@ | ||
| 71 | $select->setFrom($from); |
|
| 72 | } |
|
| 73 | ||
| 74 | if (isset($desc['WHERE'])) { |
|
| 75 | $where = self::mapArrayToNodeObjectList($desc['WHERE']); |
|
| 76 | $where = NodeFactory::simplify($where); |
|
| 77 | $select->setWhere($where); |
|
| 78 | } |
|
| 79 | ||
| 80 | if (isset($desc['GROUP'])) { |
|
| 81 | $group = self::mapArrayToNodeObjectList($desc['GROUP']); |
|
| @@ 80-84 (lines=5) @@ | ||
| 77 | $select->setWhere($where); |
|
| 78 | } |
|
| 79 | ||
| 80 | if (isset($desc['GROUP'])) { |
|
| 81 | $group = self::mapArrayToNodeObjectList($desc['GROUP']); |
|
| 82 | $group = NodeFactory::simplify($group); |
|
| 83 | $select->setGroup($group); |
|
| 84 | } |
|
| 85 | ||
| 86 | if (isset($desc['HAVING'])) { |
|
| 87 | $having = self::mapArrayToNodeObjectList($desc['HAVING']); |
|
| @@ 86-90 (lines=5) @@ | ||
| 83 | $select->setGroup($group); |
|
| 84 | } |
|
| 85 | ||
| 86 | if (isset($desc['HAVING'])) { |
|
| 87 | $having = self::mapArrayToNodeObjectList($desc['HAVING']); |
|
| 88 | $having = NodeFactory::simplify($having); |
|
| 89 | $select->setHaving($having); |
|
| 90 | } |
|
| 91 | ||
| 92 | if (isset($desc['ORDER'])) { |
|
| 93 | $order = self::mapArrayToNodeObjectList($desc['ORDER']); |
|
| @@ 92-96 (lines=5) @@ | ||
| 89 | $select->setHaving($having); |
|
| 90 | } |
|
| 91 | ||
| 92 | if (isset($desc['ORDER'])) { |
|
| 93 | $order = self::mapArrayToNodeObjectList($desc['ORDER']); |
|
| 94 | $order = NodeFactory::simplify($order); |
|
| 95 | $select->setOrder($order); |
|
| 96 | } |
|
| 97 | ||
| 98 | if (isset($desc['LIMIT'])) { |
|
| 99 | $limit = self::mapArrayToNodeObjectList($desc['LIMIT']); |
|
| @@ 98-102 (lines=5) @@ | ||
| 95 | $select->setOrder($order); |
|
| 96 | } |
|
| 97 | ||
| 98 | if (isset($desc['LIMIT'])) { |
|
| 99 | $limit = self::mapArrayToNodeObjectList($desc['LIMIT']); |
|
| 100 | $limit = NodeFactory::simplify($limit); |
|
| 101 | $select->setLimit($limit); |
|
| 102 | } |
|
| 103 | ||
| 104 | return $select; |
|
| 105 | } else { |
|