{"id":199037,"date":"2025-05-03T09:48:40","date_gmt":"2025-05-03T01:48:40","guid":{"rendered":"https:\/\/server.hk\/cnblog\/199037\/"},"modified":"2025-05-03T09:48:40","modified_gmt":"2025-05-03T01:48:40","slug":"%e5%9c%a8ecshop%e5%85%a8%e9%83%a8%e5%93%81%e7%89%8c%e9%a1%b5%e5%ae%9e%e7%8e%b0%e5%88%86%e9%a1%b5%e6%8d%a2%e9%a1%b5%e5%8a%9f%e8%83%bd","status":"publish","type":"post","link":"https:\/\/server.hk\/cnblog\/199037\/","title":{"rendered":"\u5728ECSHOP\u5168\u90e8\u54c1\u724c\u9875\u5b9e\u73b0\u5206\u9875\u6362\u9875\u529f\u80fd"},"content":{"rendered":"

\u6700\u8fd1\u770b\u5230\u6709\u670b\u53cb\u5728\u8bba\u575b\u95ee\u5230\u8fc7\u6b64\u7c7b\u95ee\u9898\uff0c\u6240\u4ee5\u62bd\u7a7a\u5199\u4e86\u4e0b\u6587\u3002
\u201c\u5728\u5168\u90e8\u54c1\u724c\u9875\u5b9e\u73b0\u5206\u9875\u6362\u9875\u529f\u80fd\u201d\uff0c\u5bf9\u5546\u54c1\u54c1\u724c\u8f83\u591a\u7684\u670b\u53cb\u4e5f\u8bb8\u4f1a\u6709\u5e2e\u52a9\u3002<\/p>\n

1\u3001\u6253\u5f00brand.php
\u627e\u5230
if (empty($brand_id))
{
\u518d\u627e\u5230
exit();
}<\/p>\n

\u5c06\u8fd9\u4e24\u8005\u4e4b\u95f4\u7684\u4ee3\u7801\u5168\u90e8\u66ff\u6362\u4e3a\u4e0b\u9762\u4ee3\u7801 <\/p>\n\n\n\n
assign_template();
        $position = assign_ur_here(”, $_LANG[‘all_brand’]);
        $smarty->assign(‘page_title’,      $position[‘title’]);    \/\/ \u9875\u9762\u6807\u9898
        $smarty->assign(‘ur_here’,         $position[‘ur_here’]);  \/\/ \u5f53\u524d\u4f4d\u7f6e
        $smarty->assign(‘categories’,      get_categories_tree()); \/\/ \u5206\u7c7b\u6811
        $smarty->assign(‘helps’,           get_shop_help());       \/\/ \u7f51\u5e97\u5e2e\u52a9
        $smarty->assign(‘top_goods’,       get_top10());           \/\/ \u9500\u552e\u6392\u884c
 
  $sql = “SELECT count(*) as brand_count from ( select b.brand_id “.
            “FROM ” . $GLOBALS[‘ecs’]->table(‘brand’) . “AS b, “.
            $GLOBALS[‘ecs’]->table(‘goods’) . ” AS g “.
            “WHERE g.brand_id = b.brand_id AND is_show = 1 ” .
            ” AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 “.
            “GROUP BY b.brand_id ) AS gb”;
  $brand_count=$GLOBALS[‘db’]->getOne($sql);  \/\/\u54c1\u724c(\u542b\u6709\u5546\u54c1\u7684)\u6570\u91cf
   $page       = !empty($_REQUEST[‘page’])  && intval($_REQUEST[‘page’])  > 0 ? intval($_REQUEST[‘page’])  : 1;
   $size       = 3;
   $max_page = ($brand_count> 0) ? ceil($brand_count \/ $size) : 1;
   if ($page > $max_page)  {$page = $max_page;}
   $start=($page – 1) * $size;  
  $sql = “SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo > ”, ‘1’, ‘0’) AS tag “.
            “FROM ” . $GLOBALS[‘ecs’]->table(‘brand’) . “AS b, “.
                $GLOBALS[‘ecs’]->table(‘goods’) . ” AS g “.
            “WHERE g.brand_id = b.brand_id AND is_show = 1 ” .
            ” AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 “.
            “GROUP BY b.brand_id HAVING goods_num > 0 ORDER BY tag DESC, b.sort_order ASC limit $start,$size”;
 
  $row = $GLOBALS[‘db’]->getAll($sql);
  foreach ($row AS $key => $val)
  {
   $row[$key][‘url’] = build_uri(‘brand’, array(‘cid’ => $cat, ‘bid’ => $val[‘brand_id’]), $val[‘brand_name’]);
   $row[$key][‘brand_desc’] = htmlspecialchars($val[‘brand_desc’],ENT_QUOTES);
  }
  $pager[‘search’] = array( );
  $pager = get_pager(‘brand.php’, $pager[‘search’], $brand_count, $page, $size);
  $pager[‘display’] = $display;
  $smarty->assign(‘pager’, $pager);
        $smarty->assign(‘brand_list’, $row); 
    $smarty->display(‘brand_list.dwt’);<\/font><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

2\u3001\u6253\u5f00 \u6a21\u677f\u6587\u4ef6 brand_list.dwt
\n
    \u5728\u4f60\u60f3\u8981\u663e\u793a\u6362\u9875\u4fe1\u606f\u7684\u5730\u65b9\u52a0\u5165\u4e0b\u9762\u4ee3\u7801
\n
    <!– #BeginLibraryItem “\/library\/pages.lbi” –><!– #EndLibraryItem –>
\n
   \u5982\u679c\u4f60\u4f7f\u7528\u7684\u662f\u5b98\u65b9\u9ed8\u8ba4\u6a21\u677f\uff0c\u90a3\u4e48\u5728
\n
    <div class=”dashed”><\/div>
\n
    \u8fd9\u884c\u4ee3\u7801\u4e0b\u9762\u52a0
\n
    <!– #BeginLibraryItem “\/library\/pages.lbi” –><!– #EndLibraryItem –>
\n
    \u6bd4\u8f83\u5408\u9002\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\u6700\u8fd1\u770b\u5230\u6709\u670b\u53cb\u5728\u8bba\u575b\u95ee\u5230\u8fc7\u6b64\u7c7b\u95ee...<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4925],"tags":[],"class_list":["post-199037","post","type-post","status-publish","format-standard","hentry","category-4925"],"_links":{"self":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199037","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/comments?post=199037"}],"version-history":[{"count":0,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199037\/revisions"}],"wp:attachment":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/media?parent=199037"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/categories?post=199037"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/tags?post=199037"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}