public function execute()
{
$domain_id = $this->get('domain_id', true);
$route = $this->get('route');
if ($route) {
$route = urldecode($route);
}
$content = $this->get('content');
$page_model = new sitePageModel();
$pages = $page_model->getByDomain($domain_id, $route, $content);
if ($this->get('params') && $pages) {
$params_model = new sitePageParamsModel();
$rows = $params_model->getByField('page_id', array_keys($pages), true);
foreach ($rows as $row) {
$pages[$row['page_id']]['params'][$row['name']] = $row['value'];
}
}
$tree = $this->get('tree');
if ($tree == null || $tree) {
foreach ($pages as $page_id => $page) {
if ($page['parent_id'] && isset($pages[$page['parent_id']])) {
$pages[$page['parent_id']]['childs'][] =& $pages[$page_id];
}
}
foreach ($pages as $page_id => $page) {
if ($page['parent_id']) {
unset($pages[$page_id]);
}
}
}
$this->response['pages'] = array_values($pages);
}
public function pages($parent_id = 0, $with_params = true)
{
if (is_bool($parent_id)) {
$with_params = $parent_id;
$parent_id = 0;
}
try {
$domain_model = new siteDomainModel();
$domain = $domain_model->getByName(waSystem::getInstance()->getRouting()->getDomain(null, true));
$page_model = new sitePageModel();
$exclude_ids = waRequest::param('_exclude');
$sql = "SELECT id, parent_id, name, title, full_url, url, create_datetime, update_datetime FROM " . $page_model->getTableName() . '
WHERE domain_id = i:domain_id AND route = s:route AND status = 1' . ($exclude_ids ? " AND id NOT IN (:ids)" : '') . ' ORDER BY sort';
$pages = $page_model->query($sql, array('domain_id' => $domain['id'], 'ids' => $exclude_ids, 'route' => wa()->getRouting()->getRoute('url')))->fetchAll('id');
if ($with_params) {
$page_params_model = new sitePageParamsModel();
$data = $page_params_model->getByField('page_id', array_keys($pages), true);
foreach ($data as $row) {
$pages[$row['page_id']][$row['name']] = $row['value'];
}
}
// get current rool url
$url = $this->wa->getAppUrl(null, true);
foreach ($pages as &$page) {
$page['url'] = $url . $page['full_url'];
if (!isset($page['title']) || !$page['title']) {
$page['title'] = $page['name'];
}
foreach ($page as $k => $v) {
if ($k != 'content') {
$page[$k] = htmlspecialchars($v);
}
}
}
unset($page);
// make tree
foreach ($pages as $page_id => $page) {
if ($page['parent_id'] && isset($pages[$page['parent_id']])) {
$pages[$page['parent_id']]['childs'][] =& $pages[$page_id];
}
}
foreach ($pages as $page_id => $page) {
if ($page['parent_id']) {
unset($pages[$page_id]);
}
}
return $pages;
} catch (Exception $e) {
return array();
}
}
public function pages($parent_id = 0, $with_params = true)
{
if (is_bool($parent_id)) {
$with_params = $parent_id;
$parent_id = 0;
}
try {
$domain_model = new siteDomainModel();
$domain = $domain_model->getByName(waSystem::getInstance()->getRouting()->getDomain(null, true));
$page_model = new sitePageModel();
$sql = "SELECT id, parent_id, name, title, full_url, url, create_datetime, update_datetime FROM " . $page_model->getTableName() . '
WHERE domain_id = i:domain_id AND route = s:route AND status = 1 ORDER BY sort';
if (wa()->getApp() == 'site') {
$route = wa()->getRouting()->getRoute('url');
$url = $this->wa->getAppUrl(null, true);
} else {
$routes = wa()->getRouting()->getByApp('site', $domain['name']);
if ($routes) {
$route = current($routes);
$route = $route['url'];
$url = wa()->getRootUrl(false, true) . waRouting::clearUrl($route);
} else {
return array();
}
}
$pages = $page_model->query($sql, array('domain_id' => $domain['id'], 'route' => $route))->fetchAll('id');
if ($with_params) {
$page_params_model = new sitePageParamsModel();
$data = $page_params_model->getByField('page_id', array_keys($pages), true);
foreach ($data as $row) {
$pages[$row['page_id']][$row['name']] = $row['value'];
}
}
foreach ($pages as &$page) {
$page['url'] = $url . $page['full_url'];
if (!isset($page['title']) || !$page['title']) {
$page['title'] = $page['name'];
}
foreach ($page as $k => $v) {
if ($k != 'content') {
$page[$k] = htmlspecialchars($v);
}
}
}
unset($page);
// make tree
foreach ($pages as $page_id => $page) {
if ($page['parent_id'] && isset($pages[$page['parent_id']])) {
$pages[$page['parent_id']]['childs'][] =& $pages[$page_id];
}
}
if ($parent_id) {
return isset($pages[$parent_id]['childs']) ? $pages[$parent_id]['childs'] : array();
}
foreach ($pages as $page_id => $page) {
if ($page['parent_id'] && $page_id != $parent_id) {
unset($pages[$page_id]);
}
}
return $pages;
} catch (Exception $e) {
return array();
}
}