{"id":199160,"date":"2025-05-03T12:10:34","date_gmt":"2025-05-03T04:10:34","guid":{"rendered":"https:\/\/server.hk\/cnblog\/199160\/"},"modified":"2025-05-03T12:10:34","modified_gmt":"2025-05-03T04:10:34","slug":"%e8%ae%a9ecshop%e5%88%86%e7%b1%bb%e6%a0%91%e6%98%be%e7%a4%ba%e5%85%b7%e4%bd%93%e5%88%86%e7%b1%bb%e4%ba%a7%e5%93%81%e6%95%b0%e9%87%8f","status":"publish","type":"post","link":"https:\/\/server.hk\/cnblog\/199160\/","title":{"rendered":"\u8ba9ecshop\u5206\u7c7b\u6811\u663e\u793a\u5177\u4f53\u5206\u7c7b\u4ea7\u54c1\u6570\u91cf"},"content":{"rendered":"

 \u6211\u4eec\u60f3\u8ba9ecshop\u7684\u5206\u7c7b\u6570\u540e\u9762\u663e\u793a\u8be5\u5206\u7c7b\u4ea7\u54c1\u5177\u4f53\u6570\u91cf\uff0c\u8fd9\u91cc\u597d\u6a21\u677f\u63d0\u4f9b\u5177\u4f53\u529e\u6cd5\uff1a<\/p>\n

\u4fee\u6539includes\/lib_goods.php<\/p>\n

$sql = ‘SELECT cat_id,cat_name ,parent_id,is_show ‘ .
                ‘FROM ‘ . $GLOBALS[‘ecs’]->table(‘category’) .
                “WHERE parent_id = ‘$parent_id’ AND is_show = 1 ORDER BY sort_order ASC, cat_id ASC”;
        $res = $GLOBALS[‘db’]->getAll($sql);
\u7684\u4e0b\u9762\u589e\u52a0<\/p>\n

$sql = “SELECT cat_id, COUNT(*) AS goods_num ” .
   ” FROM ” . $GLOBALS[‘ecs’]->table(‘goods’) . ” AS g ” .
   ” GROUP BY cat_id”;<\/font>
    $res2 = $GLOBALS[‘db’]->getAll($sql);
    $newres = array();
    foreach($res2 AS $row)
    {
     $newres[$row[‘cat_id’]] = $row[‘goods_num’];
    }<\/font><\/p>\n

2.cat_arr[$row[‘cat_id’]][‘id’]   = $row[‘cat_id’];<\/font>
\u4e0b\u9762\u589e\u52a0<\/font>
$cat_arr[$row[‘cat_id’]][‘num’] = !empty($newres[$row[‘cat_id’]]) ? $newres[$row[‘cat_id’]] : 0;<\/font><\/p>\n

2.\u4fee\u6539category_tree.lib\u5e93\uff0c\u5199\u5165num\u53d8\u91cf\u3002<\/strong><\/font><\/font>

<\/font>
<dt><a href=”{$cat.url}”>{$cat.name|escape:html}<\/a>({$cat.num})<\/font><\/dt><\/font><\/font><\/span><\/p>\n

\u6548\u679c\u5982\u4e0b\uff1a<\/p>\n


\n
ecshop\u5206\u7c7b\u6811\u663e\u793a\u5177\u4f53\u5206\u7c7b\u5546\u54c1\u6570\u91cf <\/p>\n

\u6b64\u7531\u597d\u6a21\u677f\u63d0\u4f9b\uff0c\u8f6c\u8f7d\u8bf7\u6ce8\u660e\u51fa\u5904\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"

 \u6211\u4eec\u60f3\u8ba9ecshop...<\/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-199160","post","type-post","status-publish","format-standard","hentry","category-4925"],"_links":{"self":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199160","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=199160"}],"version-history":[{"count":0,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199160\/revisions"}],"wp:attachment":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/media?parent=199160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/categories?post=199160"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/tags?post=199160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}