示例#1
0
 function &get_nested_pages($tpl_id, $tpl_name, $tpl_access_level, $orderbyfield = 'weightx', $order = 'asc', $force = 0)
 {
     global $DB;
     if (array_key_exists($tpl_id, $this->cached_nested_pages) && !$force) {
         $tree =& $this->cached_nested_pages[$tpl_id];
         if ($tree->cmp_field != $orderbyfield || $tree->cmp_order != $order) {
             $tree->set_sort($orderbyfield, $order);
             $tree->sort(1);
         }
     } else {
         $tree = new KNestedPage(array('id' => '-1', 'name' => '_root_', 'pid' => '-1'), $tpl_name, new KError());
         $tree->set_sort($orderbyfield, $order);
         $tree->crumbs = null;
         // will be filled, if required, by calling tags e.g. 'nested_pages'.
         $cols = array('p.id, p.page_title as title, p.page_name as name, p.creation_date, p.publish_date, p.access_level, p.comments_count,
                           p.nested_parent_id as pid, p.weight, p.show_in_menu, p.menu_text, p.is_pointer, p.pointer_link, p.pointer_link_detail, p.open_external, p.masquerades, p.strict_matching,
                           count(p2.id) as drafts_count');
         $tables = K_TBL_PAGES . " p left outer join " . K_TBL_PAGES . " p2 on p.id = p2.parent_id";
         $sql = 'p.template_id=' . $DB->sanitize($tpl_id);
         $sql .= " AND p.parent_id=0";
         //skip drafts
         $sql .= ' group by p.id';
         $rows = $DB->select($tables, $cols, $sql);
         $folders = array();
         foreach ($rows as $r) {
             $r['template_id'] = $tpl_id;
             $r['template_name'] = $tpl_name;
             $r['template_access_level'] = $tpl_access_level;
             $f = new KNestedPage($r, $tpl_name, $tree);
             $folders[$f->id] =& $f;
             unset($f);
         }
         foreach ($folders as $f) {
             $folder =& $folders[$f->id];
             if (isset($folders[$f->pid])) {
                 $folders[$f->pid]->add_child($folder);
             } else {
                 $tree->add_child($folder);
             }
         }
         $tree->sort(1);
         $tree->set_children_count();
         $this->cached_nested_pages[$tpl_id] =& $tree;
     }
     return $tree;
 }
示例#2
0
 function nested_pages($params, $node, $variation = 0)
 {
     global $CTX, $FUNCS, $PAGE, $DB;
     $attr = $FUNCS->get_named_vars(array('masterpage' => '', 'root' => '', 'childof' => '', 'depth' => '0', 'orderby' => '', 'order' => '', 'exclude' => '', 'extended_info' => '0', 'ignore_show_in_menu' => '0', 'include_custom_fields' => '0', 'paginate' => 0, 'limit' => '', 'offset' => '0', 'startcount' => ''), $params);
     extract($attr);
     $masterpage = trim($masterpage);
     $root = trim($root);
     $childof = trim($childof);
     $hierarchical = 1;
     // always 1
     $depth = $FUNCS->is_natural($depth) ? intval($depth) : 0;
     $orderby = strtolower(trim($orderby));
     if (!in_array($orderby, array('name', 'title', 'id', 'weight'))) {
         $orderby = 'weight';
     }
     if ($orderby == 'weight') {
         $orderby = 'weightx';
     }
     $order = strtolower(trim($order));
     if ($order != 'desc' && $order != 'asc') {
         $order = 'asc';
     }
     $exclude = $exclude ? array_map("trim", explode(",", $exclude)) : array();
     $extended_info = $extended_info == 1 ? 1 : 0;
     if ($variation == 1) {
         $extended_info = 1;
     }
     // always 1 with 'menu'
     $ignore_show_in_menu = $ignore_show_in_menu == 1 ? 1 : 0;
     $ignore_active_status = 0;
     // unpublished pages will always be ignored
     $include_custom_fields = $variation ? 0 : ($include_custom_fields == 1 ? 1 : 0);
     $paginate = $variation ? 0 : ($paginate == 1 ? 1 : 0);
     if ($paginate) {
         $extended_info = 0;
     }
     $limit = $FUNCS->is_non_zero_natural($limit) ? intval($limit) : 1000;
     //Practically unlimited.
     $offset = $FUNCS->is_natural($offset) ? intval($offset) : 0;
     $startcount = $FUNCS->is_int($startcount) ? intval($startcount) : 1;
     $startcount--;
     // see if masterpage exists
     if ($masterpage == '') {
         if (!$PAGE->tpl_nested_pages) {
             return;
         }
         $tree =& $FUNCS->get_nested_pages($PAGE->tpl_id, $PAGE->tpl_name, $PAGE->tpl_access_level, $orderby, $order);
         $tpl_name = $PAGE->tpl_name;
     } else {
         $rs = $DB->select(K_TBL_TEMPLATES, array('*'), "name='" . $DB->sanitize($masterpage) . "'");
         if (!count($rs)) {
             return;
         }
         if (!$rs[0]['nested_pages']) {
             return;
         }
         $tpl_id = $rs[0]['id'];
         $tpl_name = $rs[0]['name'];
         $tpl_access_level = $rs[0]['access_level'];
         // get the tree of nested pages
         $tree =& $FUNCS->get_nested_pages($tpl_id, $tpl_name, $tpl_access_level, $orderby, $order);
     }
     // mark the active trail in the tree.. also creates the crumbs.
     $tree->mark_current(!$ignore_show_in_menu);
     // if called from 'nested_crumbs', return crumbs and exit ..
     if ($variation == 2) {
         // crumbs.. only $masterpage and $ignore_show_in_menu are the valid params here
         return $tree->crumbs;
     }
     // Check if either 'root' or 'childof' set to special keywords
     // keywords:
     // @1, @2 etc. - start from x level parent of the most current item.
     // @current - start from most current item.
     // @current-1, @current-2 etc. - start from parent of most current item at x level above it.
     if ($root || $childof) {
         // root takes precedence over childof
         $special = $root ? $root : $childof;
         if ($special[0] == '@') {
             $special = substr($special, 1);
             // find the most current item
             for ($x = 0; $x < count($tree->crumbs); $x++) {
                 $item = $tree->crumbs[$x];
                 if ($item->most_current) {
                     break;
                 }
             }
             if ($x == count($tree->crumbs)) {
                 return;
             }
             if ($FUNCS->is_non_zero_natural($special)) {
                 // 1, 2, etc.
                 $special = $special - 1;
                 // Find the requested parent at the requested level, if any
                 if ($special > $x) {
                     return;
                 }
                 // cannot go past the current item's level
                 $item = $tree->crumbs[$special];
                 $root ? $root = $item->name : ($childof = $item->name);
             } else {
                 if ($special == 'current') {
                     $root ? $root = $item->name : ($childof = $item->name);
                 } else {
                     $arr = array_map("trim", explode('-', $special));
                     if ($arr[0] == 'current' && $FUNCS->is_non_zero_natural($arr[1])) {
                         // Find parent at requested level above the current item
                         $special = $x - $arr[1];
                         if ($special < -1) {
                             return;
                         }
                         if ($special == -1) {
                             // _ROOT_
                             if ($root) {
                                 return;
                                 /* cannot add _ROOT_ to returned array */
                             } else {
                                 $childof = '';
                             }
                         } else {
                             $item = $tree->crumbs[$special];
                             $root ? $root = $item->name : ($childof = $item->name);
                         }
                     } else {
                         // unknown value given
                         return;
                     }
                 }
             }
         }
     }
     // root takes precedence over childof
     if ($root != '') {
         $f =& $tree->find($root);
         if (!$f) {
             return;
         }
         unset($tree);
         $tree = new KNestedPage(array('id' => '-1', 'name' => '_root_', 'pid' => '-1'), $tpl_name, new KError());
         $tree->set_sort($orderby, $order);
         $tree->add_child($f);
         unset($f);
     } elseif ($childof != '') {
         $f =& $tree->find($childof);
         if (!$f || !count($f->children)) {
             return;
         }
         unset($tree);
         $tree = new KNestedPage(array('id' => '-1', 'name' => '_root_', 'pid' => '-1'), $tpl_name, new KError());
         $tree->set_sort($orderby, $order);
         $count = count($f->children);
         for ($x = 0; $x < $count; $x++) {
             $tree->add_child($f->children[$x]);
         }
         unset($f);
     }
     $tree->set_dynamic_count($depth, $exclude, !$ignore_show_in_menu);
     // pagination.. goes into normal 'pages' listing mode
     if ($paginate) {
         $qs_param = 'pg';
         $pgn_pno = 1;
         if ($paginate) {
             if (isset($_GET[$qs_param]) && $FUNCS->is_non_zero_natural($_GET[$qs_param])) {
                 $pgn_pno = (int) $_GET[$qs_param];
             }
         }
         $total_rows = $tree->total_children_ex - $offset;
         if ($total_rows < 1) {
             return;
         }
         $total_pages = ceil($total_rows / $limit);
         if ($pgn_pno > $total_pages && $total_pages > 0) {
             $pgn_pno = $total_pages;
         }
         $first_record_on_page = $limit * ($pgn_pno - 1) + 1 + $offset;
         $last_record_on_page = $first_record_on_page + $limit - 1;
         if ($last_record_on_page > $total_rows + $offset) {
             $last_record_on_page = $total_rows + $offset;
         }
         $total_records_on_page = $last_record_on_page - ($first_record_on_page - 1);
         // calculate the required links
         $page_link = K_SITE_URL . $PAGE->link;
         $sep = '';
         foreach ($_GET as $qk => $qv) {
             if ($qk == 'p' || $qk == 'f' || $qk == 'd' || $qk == 'fname' || $qk == 'pname' || $qk == '_nr_') {
                 continue;
             }
             if ($qk == $qs_param) {
                 continue;
             }
             $qs .= $sep . $qk . '=' . urlencode($qv);
             $sep = '&';
         }
         if ($qs) {
             $page_link .= strpos($page_link, '?') === false ? '?' : '&';
             $page_link .= $qs;
         }
         if ($total_rows > $limit) {
             $paginated = 1;
             $sep = strpos($page_link, '?') === false ? '?' : '&';
             // 'Prev' link
             if ($pgn_pno > 1) {
                 if ($pgn_pno == 2) {
                     $pgn_prev_link = $page_link;
                 } else {
                     $pgn_prev_link = sprintf("%s%s%s=%d", $page_link, $sep, $qs_param, $pgn_pno - 1);
                 }
             }
             // 'Next' link
             if ($pgn_pno < $total_pages) {
                 $pgn_next_link = sprintf("%s%s%s=%d", $page_link, $sep, $qs_param, $pgn_pno + 1);
             }
         }
         // pass data on to callback function to be set in context
         $node->_paginate = 1;
         $node->_total_records = $total_rows;
         $node->_from = $first_record_on_page;
         $node->_to = $last_record_on_page;
         $node->_total = $total_records_on_page;
         $node->_offset = $offset;
         $node->_startcount = $startcount;
         $node->_total_pages = $total_pages;
         $node->_current_page = $pgn_pno;
         $node->_paginate_limit = $limit;
         $node->_counter = 0;
         $node->_page_link = $page_link;
         $node->_qs_param = $qs_param;
         $node->_paginated = $paginated;
         $node->_pgn_next_link = $pgn_next_link;
         $node->_pgn_prev_link = $pgn_prev_link;
     }
     $html = '';
     $visitor = !$variation ? '_nested_pages_visitor' : '_nested_pages_visitor_menu';
     $CTX->set('k_show_extended_info', $extended_info);
     if (!$variation) {
         $node->_include_custom_fields = $include_custom_fields;
     }
     $tree->visit(array($this, $visitor), $html, $node, $depth, $extended_info, $exclude, 0, !$ignore_show_in_menu, !$ignore_active_status, $paginate);
     return $html;
 }