public function getPageById($id) { $id = $this->data->clearArray($id); if (!empty($id)) { $_val = 'menu.alias'; if ($this->data->clearInt($id) > 0) { $_val = 'content.id'; } $id = $this->ORM->quote($id); $sql = "SELECT content.id, name,alias_content,tizer,description,price,\r\n\t\t\t\timg, parent_content,date_content, public_content, alias, link, public_menu \r\n\t\t\t\tFROM content LEFT OUTER JOIN menu \r\n\t\t\t\tON content.id = menu.id_content WHERE {$_val}={$id} AND content.public_content='1' limit 1"; $row = $this->ORM->getQueryDB($sql); if (!empty($row)) { $row_sub = ORMModel::for_table('content')->id()->name()->alias_content()->tizer()->description()->price()->img()->parent_content()->date_content()->public_content()->where('parent_content', '=', $row['id'])->and_where('public_content', '=', '1')->arbitrary("ORDER BY id ASC")->selectDB(); $row['blog'] = ''; } if (!empty($row_sub)) { $row['blog'] = $row_sub; } return $row; } else { return false; } }