当前位置: 首页>>代码示例>>PHP>>正文


PHP Common::get_nodes_list方法代码示例

本文整理汇总了PHP中Common::get_nodes_list方法的典型用法代码示例。如果您正苦于以下问题:PHP Common::get_nodes_list方法的具体用法?PHP Common::get_nodes_list怎么用?PHP Common::get_nodes_list使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在Common的用法示例。


在下文中一共展示了Common::get_nodes_list方法的8个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: show_photoalbum

 function show_photoalbum($params)
 {
     global $db;
     global $smarty;
     $res = $db->get_single("SELECT url FROM fw_tree WHERE module='photoalbum' LIMIT 1");
     $support_url = $res['url'];
     $album_id = $params['id'];
     $photos_list = $db->get_all("SELECT *,(SELECT COUNT(*) FROM fw_photoalbum_images WHERE parent='{$album_id}') AS count FROM fw_photoalbum_images WHERE parent='{$album_id}' ORDER BY sort_order LIMIT " . PHOTOS_PER_PAGE_SUP);
     for ($i = 0; $i < sizeof($photos_list); $i++) {
         $photo_file = BASE_PATH . '/' . PHOTOS_FOLDER . '/' . $photos_list[$i]['id'] . '.' . $photos_list[$i]['ext'];
         $output = Image::image_details($photo_file);
         $photos_list[$i]['width'] = $output['width'] + 20;
         $photos_list[$i]['height'] = $output['height'] + 20;
     }
     if ($photos_list[0]['count'] > PHOTOS_PER_PAGE_SUP) {
         $cl = $db->get_all("SELECT *,(SELECT parent FROM fw_photoalbums WHERE id='{$album_id}') AS album FROM fw_photoalbum_cat c WHERE c.status='1' ORDER BY c.param_left");
         $album_parent = $cl[0]['album'];
         $cl = Common::get_nodes_list($cl);
         foreach ($cl as $k => $v) {
             if ($v['id'] == $album_parent) {
                 $album_url = $v['full_url'];
             }
         }
         $album_url = $support_url . $album_url . 'album_' . $album_id;
         $smarty->assign("album_url", $album_url);
     }
     $smarty->assign("photos_list", $photos_list);
     $smarty->assign("photos_per_page_sup", PHOTOS_PER_PAGE_SUP);
     $smarty->assign("total_photos", $photos_list[0]['count']);
     $output = $smarty->fetch(BASE_PATH . '/modules/photoalbum/front/templates/show_photoalbum_support.html');
     return $output;
 }
开发者ID:askovorodka,项目名称:sqc,代码行数:32,代码来源:photoalbum.f_main.php

示例2: number_format

                 $search_results[$a]['price'] = number_format($search_results[$a]['price'] * $cur_admin['kurs'] / $cur_site['kurs'], 2);
             }
         }
     }
     $smarty->assign("search_string", $search);
     if (count($search_results) > 0) {
         $smarty->assign("search_results", $search_results);
     }
     $smarty->assign("total_pages", $pager['total_pages']);
     $smarty->assign("current_page", $pager['current_page']);
     $smarty->assign("pages", $pager['pages']);
     $page_found = true;
     $template = 'search_products.html';
     break;
 default:
     $cat_list = Common::get_nodes_list($cl);
     unset($url[0]);
     if (isset($type) && $type != 'all') {
         $where = " AND product_type=" . $type . " ";
         $smarty->assign("prod_type", $type);
     } else {
         $where = "";
     }
     $order = 'ORDER BY sort_order ASC';
     if (!isset($page)) {
         $page = 1;
     }
     $dirs = array("price" => "desc", "insert_date" => "desc", "name" => "desc");
     if (isset($_GET['page']) or isset($_GET['order'])) {
         if (isset($_GET['page'])) {
             $page = $_GET['page'];
开发者ID:askovorodka,项目名称:sqc,代码行数:31,代码来源:sites.f_main.php

示例3: array

     $smarty->assign("total_pages", $pager['total_pages']);
     $smarty->assign("current_page", $pager['current_page']);
     $smarty->assign("pages", $pager['pages']);
     $template = 'shop.a_orders.html';
     break;
 case $action == 'order_details':
     $navigation[] = array("url" => BASE_URL . "/admin/?mod=shop&action=orders", "title" => 'Список заказов');
     $id = $_GET['id'];
     //$order=$db->get_single("SELECT * FROM fw_orders WHERE id='$id'");
     //$order=String::unformat_array($order);
     $total_summ = $db->get_single("SELECT SUM(price) FROM fw_products WHERE id IN (SELECT product_id FROM fw_orders_products WHERE order_id='{$id}')");
     $user_info = $db->get_single("SELECT a.*,b.comments,b.status FROM fw_users as a INNER JOIN fw_orders as b\n\t\t\t\t\t\t\t\t\tON a.id=b.user AND b.id='{$id}'\n\t\t\t\t\t\t\t\t\tWHERE a.id=(SELECT user FROM fw_orders WHERE id='{$id}' LIMIT 0,1)");
     $smarty->assign("user_info", $user_info);
     $orders = $db->get_all("SELECT a.*,\n\t\tb.product_id as product_id,\n\t\tc.parent as parent,\n\t\tc.hit as hit,\n\t\tb.product_count,\n\t\tc.price as price,\n\t\t(c.price * product_count) as total_summ,\n\t\torder_id,\n\t\tproduct_count,\n\t\tc.name \tFROM `fw_orders` as a INNER JOIN\n\t\t(fw_orders_products as b INNER JOIN fw_products as c ON b.product_id=c.id)\n\t\tON a.id=b.order_id WHERE a.id='{$id}'");
     $orders = String::unformat_array($orders);
     $cl = Common::get_nodes_list($cat_list);
     for ($i = 0; $i < count($orders); $i++) {
         for ($k = 0; $k < count($cl); $k++) {
             if ($orders[$i]['parent'] == $cl[$k]['id']) {
                 $orders[$i]['cat_title'] = $cl[$k]['full_title'];
                 break;
             }
         }
     }
     $navigation[] = array("url" => BASE_URL . "/admin/?mod=shop&action=order_details", "title" => 'Заказ номер ' . $id);
     for ($i = 0; $i < count($status_value); $i++) {
         $status_list[$i]['value'] = $status_value[$i];
         $status_list[$i]['name'] = $status_name[$i];
     }
     if (count($orders) > 0) {
         foreach ($orders as $key => $val) {
开发者ID:askovorodka,项目名称:sqc,代码行数:31,代码来源:shop.a_main.php

示例4: COUNT

        $result = $db->query("SELECT COUNT(*) FROM fw_forum_threads WHERE parent='{$forum_id}'");
        $pager = Common::pager($result, 10, $page);
        $smarty->assign("total_pages", $pager['total_pages']);
        $smarty->assign("current_page", $pager['current_page']);
        $smarty->assign("pages", $pager['pages']);
        $threads_list = $db->get_all("SELECT *,\n\t\t\t\t\t\t\t\t\t\t\t\t(SELECT publish_date FROM fw_forum_posts WHERE parent=t.id ORDER BY publish_date DESC LIMIT 1) AS last_date\n\t\t\t\t\t\t\t\t\t\t\t\tFROM fw_forum_threads t WHERE t.parent='{$forum_id}' ORDER BY top DESC,last_date DESC LIMIT " . $pager['limit']);
        $smarty->assign("threads_list", $threads_list);
        $smarty->assign("forum_id", $forum_id);
        $smarty->assign("post_id", $id);
        $template = 'forum.a_posts_list.html';
        $template_mode = 'single';
        break;
    case $action == 'move_post' && isset($_GET['move_to']) && isset($_GET['post_id']):
        $post_id = $_GET['post_id'];
        $move_to = $_GET['move_to'];
        $db->query("UPDATE fw_forum_posts SET parent='{$move_to}', publish_date='" . time() . "' WHERE id='{$post_id}'");
        $location = $_SERVER['HTTP_REFERER'];
        header("Location: {$location}");
        break;
    case $action == 'move_post':
        $id = $_GET['post_id'];
        $flist = Common::get_nodes_list($forums_list);
        unset($flist[0]);
        $smarty->assign("forums_list", $flist);
        $smarty->assign("post_id", $id);
        $template = 'forum.a_forums_list.html';
        $template_mode = 'single';
        break;
    default:
        $smarty->assign("forums_list", $forums_list);
}
开发者ID:askovorodka,项目名称:sqc,代码行数:31,代码来源:forum.a_main.php

示例5: count

         for ($i = 0; $i < sizeof($photos_list); $i++) {
             $output = Image::image_details(BASE_PATH . '/' . USER_PHOTOS_FOLDER . '/' . $photos_list[$i]['id'] . '.' . $photos_list[$i]['ext']);
             $photos_list[$i]['width'] = $output['width'] + 20;
             $photos_list[$i]['height'] = $output['height'] + 20;
         }
         $smarty->assign("total_pages", $pager['total_pages']);
         $smarty->assign("current_page", $pager['current_page']);
         $smarty->assign("pages", $pager['pages']);
         $smarty->assign("total_photos", count($photos_list));
         $smarty->assign("album", $album);
         $smarty->assign("photos_list", $photos_list);
         $template = 'show_photoalbum.html';
     }
     break;
 default:
     $all_forums = Common::get_nodes_list($all_forums);
     unset($url[0]);
     if (@preg_match("/^page_([0-9]+)\$/", $url[$n])) {
         list(, $page) = explode("_", $url[$n]);
         unset($url[$n]);
         unset($current_url_pages[count($current_url_pages) - 1]);
     } else {
         $page = 1;
     }
     for ($f = 0; $f < count($all_forums); $f++) {
         $url_to_check = implode("/", $url) . '/';
         if ($all_forums[$f]['full_url'] == $url_to_check) {
             $forum_content = $all_forums[$f];
             $page_found = true;
             $smiles_list = $db->get_all("SELECT * FROM fw_smiles ORDER BY sort_order LIMIT 20");
             $smarty->assign("smiles_list", $smiles_list);
开发者ID:askovorodka,项目名称:sqc,代码行数:31,代码来源:forum.f_main.php

示例6: array

     $navigation[] = array("url" => BASE_URL . "/admin/?mod=regions&action=add_firm", "title" => 'Добавить компанию');
     //$citys_list=Common::get_nodes_list($citys_list);
     $metros_list = $db->get_all("SELECT * FROM fw_metros");
     $metros_list = String::unformat_array($metros_list);
     $reg_list = Common::get_nodes_list($reg_list);
     $smarty->assign("reg_list", $reg_list);
     $smarty->assign("citys_list", $citys_list);
     $smarty->assign("metros_list", $metros_list);
     $smarty->assign("mode", "add");
     $smarty->assign("city", @$_GET['city']);
     $template = 'regions.a_edit_firm.html';
     break;
 case $action == 'edit_city' && isset($_GET['id']):
     $navigation[] = array("url" => BASE_URL . "/admin/?mod=regions&action=edit_city", "title" => 'Редактировать город');
     $id = $_GET['id'];
     $reg_list = Common::get_nodes_list($reg_list);
     //		unset($cat_list[0]);
     // SORRY for so strange separator
     /****************************************************************/
     $city = $db->get_single("SELECT *\tFROM fw_citys AS p WHERE id='{$id}'");
     $city = String::unformat_array($city);
     /****************************************************************/
     $smarty->assign("reg_list", $reg_list);
     $smarty->assign("city", $city);
     $smarty->assign("mode", "edit");
     $template = 'regions.a_edit_city.html';
     break;
 case $action == 'edit_metro' && isset($_GET['id']):
     $navigation[] = array("url" => BASE_URL . "/admin/?mod=regions&action=edit_metro", "title" => 'Редактировать метро');
     $id = $_GET['id'];
     //$reg_list=Common::get_nodes_list($reg_list);
开发者ID:askovorodka,项目名称:sqc,代码行数:31,代码来源:regions.a_main.php

示例7: intval

        if (isset($_GET['parent'])) {
            $parent = intval($_GET['parent']);
            $smarty->assign("parent", $parent);
            $template = "tree.a_edit_document.html";
            $smarty->assign("mode", "add");
            $nodes_list = Common::get_nodes_list($nodes_list, 'page');
            unset($nodes_list[0]);
            $smarty->assign("nodes_list", $nodes_list);
        }
        break;
    case $action == 'edit_document':
        $navigation[] = array("url" => BASE_URL . "/admin/?mod=tree&action=edit_document", "title" => 'Редактировать документ');
        if (isset($_GET['id'])) {
            $id = intval($_GET['id']);
            $result = $db->get_single("SELECT * FROM fw_documents WHERE id='" . $id . "'");
            if (count($result) > 0) {
                $template = "tree.a_edit_document.html";
                $smarty->assign("parent", $result['parent']);
                $smarty->assign("mode", "edit");
                $smarty->assign("document", $result);
                $nodes_list = Common::get_nodes_list($nodes_list, 'page');
                unset($nodes_list[0]);
                $smarty->assign("nodes_list", $nodes_list);
            }
        }
        break;
    default:
        $content = $db->get_all("\n      SELECT\n        *,\n        (SELECT COUNT(id) FROM fw_documents WHERE parent=t.id) as documents\n      FROM fw_tree t\n      ORDER BY t.param_left ASC\n    ");
        $content = String::unformat_array($content);
        $smarty->assign("content", Common::get_nodes_list($content));
}
开发者ID:askovorodka,项目名称:sqc,代码行数:31,代码来源:tree.a_main.php

示例8: GROUP_CONCAT

<?php

require_once 'lib/class.photoalbum.php';
require_once 'lib/class.table.php';
require_once 'lib/class.form.php';
$all_pages = $db->get_all("\n\tSELECT\n\t\ttree.*,\n\t\tdob.name as orderby_name,\n\t\tdob.orderby,\n\t\tdob.orderbysc,\n\t\t(SELECT param_left FROM fw_tree WHERE param_right>tree.param_left AND tree.param_level-param_level=1 ORDER BY param_left LIMIT 1) AS p_left,\n\t\t(SELECT param_right FROM fw_tree WHERE param_right>tree.param_left AND tree.param_level-param_level=1 ORDER BY param_left LIMIT 1) AS p_right,\n\t\t(SELECT GROUP_CONCAT(id SEPARATOR ',') FROM fw_users WHERE FIND_IN_SET(group_id, tree.access_groups)>0) as access_users_groups,\n\t\t(SELECT IF(ISNULL(access_users_groups), access_users, CONCAT(access_users,',',access_users_groups))) as access_users_list\n\tFROM\n\t\tfw_tree AS tree\n\t\tLEFT JOIN fw_documents_orderby dob\n\t\t\tON\n\t\t\t\tdob.id=tree.show_documents_orderby\n\tWHERE\n\t\ttree.module='page'\n\t\tAND\n\t\ttree.status='1'\n\tORDER BY tree.param_left\n");
$all_pages = Common::get_nodes_list($all_pages);
//echo count($all_pages);
if (preg_match("/^page_[0-9]+\$/", $url[$n])) {
    list(, $page) = explode("_", $url[$n]);
    $url = array_values($url);
    unset($url[$n]);
    unset($current_url_pages[count($current_url_pages) - 1]);
    $n = count($url) - 1;
} else {
    $page = 1;
}
if (preg_match("/^item_([0-9]+)\$/", $url[$n], $a)) {
    $select_item = intval($a[1]);
    unset($url[$n]);
    $n--;
}
for ($f = 0; $f < count($all_pages); $f++) {
    $url_to_check = implode("/", $url) . '/';
    if ($all_pages[$f]['full_url'] == $url_to_check) {
        $main_page_content = $all_pages[$f];
        if (Common::check_node_auth($main_page_content['access_users_list'])) {
            $nav_titles = explode("/", $all_pages[$f]['full_title']);
            $nav_urls = explode("/", $all_pages[$f]['full_url']);
            unset($nav_titles[count($nav_titles) - 1]);
            unset($nav_urls[count($nav_urls) - 1]);
开发者ID:askovorodka,项目名称:sqc,代码行数:31,代码来源:page.f_main.php


注:本文中的Common::get_nodes_list方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。