/** * @param Select $select * @return string */ protected function _renderSelectOrderBy(Select $select) { $str = ""; if ($cnt = count($select->getAllOrderBy())) { $orderBys = $select->getAllOrderBy(); array_walk($orderBys, function (&$orderBy) { $orderBy = $this->_renderOrderBy($orderBy); }); $str = "ORDER BY"; $str .= " "; $separator = ", "; $str .= implode($separator, $orderBys); } return $str; }
public function testOrderBy() { $select = new Select('project'); $select->orderBy("date_created"); $ob = $select->getOrderBy(); $this->assertCount(1, $ob); $this->assertInstanceOf('\\RBM\\SqlQuery\\OrderBy', $ob[0]); $select->join('user', 'owner_id', 'user_id')->orderBy('name'); $ob = $select->getAllOrderBy(); $this->assertCount(2, $ob); }