Всем здравствуйте,очень нужна помощь,не проходите мимо помогите).Суть в следующем нужно вывести дополнительный контент, то есть сейчас выводятся из родительской страницы ссылки на дочерние страницы, а нужно чтоб выводились дополнительно первая картинка и часть начального текста из страницы. Код на https://codeshare.io/5gebZN CONTROLLER PHP: <?php /** * класс текстовых страниц */ class controller_component_core_pages extends component { public function action_index() { $page_info = $this->model->get_page('/'); $this->set_global_data('page_id', 1); $this->data['page_name'] = $page_info['name']; $this->data['content'] = $page_info['text']; $this->page['title'] = $page_info['title']; $this->page['keywords'] = $page_info['keywords']; $this->page['description'] = $page_info['description']; $this->data['bread_crumbs'] = 'Вы на главной странице.'; $view = !empty($page_info['view']) ? $page_info['view'] : $this->view; if (!empty($page_info['theme_view'])) { $this->page['theme']['file'] = $page_info['theme_view']; } $this->page['head'] = $this->add_css_file(SITE_URL . '/cms/modules/components/pages/front_end/views/content.css'); $this->page['html'] = $this->load_view($view); return $this->page; } // вывод страниц за исключением главной public function action_else() { $this->load_helper('breadcrumbs'); $not_found = false; $this->helper_breadcrumbs->add('Главная', SITE_URL); $url = SITE_URL; if($this->url['actions'][0] == 'index') { $page_info = $this->model->get_page($this->url['component']); $url .= '/' . $page_info['url']; $this->helper_breadcrumbs->add($page_info['name'], $url); } else { $first = $this->model->get_main_info($this->url['component']); $parent_id = $first['id']; $url .= '/' . $first['url']; $this->helper_breadcrumbs->add($first['name'], $url); foreach($this->url['actions'] as $i => $action) { $main_info = $this->model->get_main_info($action, $parent_id); if($main_info) { $url .= '/' . $main_info['url']; $this->helper_breadcrumbs->add($main_info['name'], $url); $parent_id = $main_info['id']; if(isset($this->url['actions'][$i++])) { // это нужная нам страница $page_info = $this->model->get_page($main_info['url'], $main_info['parent_id']); } } else { $not_found = true; break; } } } if($not_found) { $this->page = $this->action_404(); return $this->page; } else { $this->set_global_data('page_id', $page_info['id']); $this->data['page_name'] = $page_info['name']; $this->data['content'] = $page_info['text']; $this->page['title'] = $page_info['title']; $this->page['keywords'] = $page_info['keywords']; $this->page['description'] = $page_info['description']; $view = !empty($page_info['view']) ? $page_info['view'] : $this->view; if (!empty($page_info['theme_view'])) { $this->page['theme']['file'] = $page_info['theme_view']; } if ($this->view == 'children_menu' or $this->view == 'children_menu_in_bottom') { $this->data['children'] = array(); $results = $this->model->get_pages_by_parent_id($page_info[0]); foreach ($results as $result) { $this->data['children'][] = array( 'name' => $result['name'], 'href' => SITE_URL . $this->url['request_uri'] . '/' . $result['url'] ); } } } $this->data['bread_crumbs'] = $this->helper_breadcrumbs->render(); $this->page['html'] = $this->load_view($view); return $this->page; } } MODEL <?php /* * main component's model */ class model_component_core_pages extends model { public function get_page($url, $parent_id = 0){ $sql = "SELECT * FROM main m LEFT JOIN pages p ON p.main_id = m.id WHERE m.url = '" . $this->dbh->escape($url) . "' AND m.component = 'pages' AND m.parent_id = '" . (int)$parent_id . "' LIMIT 1"; return $this->dbh->row($sql); } /* * возвращает содержимое таблицы main * */ public function get_main_info($url, $parent_id = 0){ $sql = "SELECT * FROM main m WHERE m.url = '" . $this->dbh->escape($url) . "' AND m.component = 'pages' AND m.parent_id = '" . (int)$parent_id . "' LIMIT 1"; return $this->dbh->row($sql); } /* * возвращает дочерние страницы 1го уровня вложенности * params: * children_count - join column with count of children / добавляет к выборке столбец с количеством дочерних страниц * content - join `pages` table with page content / добавляет к выборке таблицу `pages` с контентом * sort - set 'sort by' value / указывает порядок сортировки * */ public function get_pages_by_parent_id($parent_id = 0, $params = array()){ $sql = ''; if(isset($params['children_count']) && $params['children_count'] === true){ $sql .= "SELECT m.*, COUNT(m2.id) AS children_count FROM main m LEFT JOIN main m2 ON m2.parent_id = m.id "; } else { $sql .= "SELECT * FROM main m "; } if(isset($params['content']) && $params['content'] === true){ $sql .= "LEFT JOIN pages p ON p.main_id = m.id "; } $sql .= "WHERE m.parent_id = '" . (int)$parent_id . "' AND m.component = 'pages' GROUP BY m.id "; if(isset($params['sort'])){ $sql .= "ORDER BY " . $params['sort'] . " "; } else { $sql .= "ORDER BY m.id DESC"; } return $this->dbh->query($sql); } /* возвращает строку с урлом страницы */ public function get_page_url($page_id, $url = '') { $sql = "SELECT parent_id, url FROM main WHERE id = '" . (int)$page_id . "'"; $page = $this->dbh->row($sql); if (!$page) { return null; } $url = '/' . $page['url'] . $url; if($page['parent_id'] == 0) { return str_replace('//', '/', $url); } else { return $this->get_page_url($page['parent_id'], $url); } } VIEWS <div id="content" class="content"> <h1 id="page_name"><?php echo $page_name; ?></h1> <p class="bread_crumbs"><?php echo $bread_crumbs; ?></p> <?php if (isset($children) && !empty($children)) { ?> <div id="page_children"> <ul> <?php foreach ($children as $child) { ?> <li> <a href="<?php echo $child['href']; ?>"><?php echo $child['name']; ?></a></br> </li> <?php } ?> </ul> </div> <?php } ?> <?php echo $content; ?> </div>