{"id":199342,"date":"2025-05-03T12:03:28","date_gmt":"2025-05-03T04:03:28","guid":{"rendered":"https:\/\/server.hk\/cnblog\/199342\/"},"modified":"2025-05-03T12:03:28","modified_gmt":"2025-05-03T04:03:28","slug":"ecshop%e9%a6%96%e9%a1%b5%e8%b0%83%e7%94%a8%e6%8c%87%e5%ae%9a%e6%89%a9%e5%b1%95%e5%88%86%e7%b1%bb%e5%95%86%e5%93%81","status":"publish","type":"post","link":"https:\/\/server.hk\/cnblog\/199342\/","title":{"rendered":"ECSHOP\u9996\u9875\u8c03\u7528\u6307\u5b9a\u6269\u5c55\u5206\u7c7b\u5546\u54c1"},"content":{"rendered":"

\u56e0\u4e3a\u4e00\u4e9b\u539f\u56e0\u9700\u8981\u5728\u7f51\u7ad9\u9996\u9875\u8c03\u7528\u6269\u5c55\u5206\u7c7b\u7684\u5546\u54c1\uff0c\u627e\u4e86\u4e00\u5929\u6ca1\u627e\u5230\u5177\u4f53\u65b9\u6cd5\uff0c\u6240\u4ee5\u51b3\u5b9a\u81ea\u5df1\u52a8\u624b\u4e30\u8863\u8db3\u98df\uff0c\u73b0\u5c06\u6b64\u65b9\u6cd5\u5206\u4eab\u7ed9\u5927\u5bb6<\/p>\n

1.\u5728\u540e\u53f0\u7ed9\u5546\u54c1\u6dfb\u52a0\u6269\u5c55\u5206\u7c7b<\/p>\n

<\/p>\n

2.\u67e5\u770b\u8be5\u6269\u5c55\u5206\u7c7b\u7684cat_id<\/p>\n


 <\/p>\n

3.includes\\lib_goods.php,\u6dfb\u52a0\u65b9\u6cd5<\/p>\n

[php]<\/b> view plaincopy
\n
\n   <\/p>\n

    \n
  1. function<\/span> index_appoint_goods_list(<\/span>$cat_id<\/span> = <\/span>”<\/span>, <\/span>$num<\/span> = <\/span>”<\/span>)  <\/span><\/span><\/li>\n
  2. {  <\/span><\/li>\n
  3.     $sql<\/span> = <\/span>‘select g.goods_id, g.cat_id,c.parent_id, g.goods_name, g.goods_name_style, g.market_price, g.shop_price AS org_price, g.promote_price, ‘<\/span> .  <\/span><\/span><\/li>\n
  4.            “IFNULL(mp.user_price, g.shop_price * ‘$_SESSION[discount]’) AS shop_price, “<\/span>.  <\/span><\/span><\/li>\n
  5.            “promote_start_date, promote_end_date, g.goods_brief, g.goods_thumb, goods_img, “<\/span> .  <\/span><\/span><\/li>\n
  6.            “g.is_best, g.is_new, g.is_hot, g.is_promote “<\/span> .  <\/span><\/span><\/li>\n
  7.            ‘FROM ‘<\/span> . <\/span>$GLOBALS<\/span>[<\/span>‘ecs’<\/span>]->table(<\/span>‘goods’<\/span>) . <\/span>‘ AS g ‘<\/span> .  <\/span><\/span><\/li>\n
  8.            ‘LEFT JOIN ‘<\/span> . <\/span>$GLOBALS<\/span>[<\/span>‘ecs’<\/span>]->table(<\/span>‘category’<\/span>) . <\/span>‘ AS c ON c.cat_id = g.cat_id ‘<\/span> .  <\/span><\/span><\/li>\n
  9.            ‘LEFT JOIN ‘<\/span> . <\/span>$GLOBALS<\/span>[<\/span>‘ecs’<\/span>]->table(<\/span>‘member_price’<\/span>) . <\/span>‘ AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = ‘<\/span>.<\/span>$_SESSION<\/span>[user_rank].<\/span>‘ ‘<\/span>.  <\/span><\/span><\/li>\n
  10.            ‘LEFT JOIN ‘<\/span> . <\/span>$GLOBALS<\/span>[<\/span>‘ecs’<\/span>]->table(<\/span>‘goods_cat’<\/span>) . <\/span>‘ AS gc ON gc.goods_id = g.goods_id ‘<\/span>.  <\/span><\/span><\/li>\n
  11.            ‘Where g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 ‘<\/span>.  <\/span><\/span><\/li>\n
  12.     $sql<\/span> .= <\/span>” AND (gc.cat_id = “<\/span> . <\/span>$cat_id<\/span> .<\/span>” OR c.parent_id =”<\/span> . <\/span>$cat_id<\/span>. <\/span>” OR g.cat_id = “<\/span> . <\/span>$cat_id<\/span> .<\/span>” OR g.cat_id “<\/span>. db_create_in(<\/span>array_unique<\/span>(<\/span>array_merge<\/span>(<\/span>array<\/span>(<\/span>$cat_id<\/span>), <\/span>array_keys<\/span>(cat_list(<\/span>$cat_id<\/span>, 0, false))))) .<\/span>“)”<\/span>;  <\/span><\/span><\/li>\n
  13.     $sql<\/span> .= <\/span>” LIMIT $num”<\/span>;  <\/span><\/span><\/li>\n
  14.   <\/span><\/li>\n
  15.     $res<\/span> = <\/span>$GLOBALS<\/span>[<\/span>‘db’<\/span>]->getAll(<\/span>$sql<\/span>);  <\/span><\/span><\/li>\n
  16.     $goods<\/span> = <\/span>array<\/span>();  <\/span><\/span><\/li>\n
  17.       <\/span><\/li>\n
  18.     foreach<\/span> (<\/span>$res<\/span> AS <\/span>$idx<\/span> => <\/span>$row<\/span>)  <\/span><\/span><\/li>\n
  19.     {  <\/span><\/li>\n
  20.         $goods<\/span>[<\/span>$idx<\/span>][<\/span>‘id’<\/span>] = <\/span>$row<\/span>[<\/span>‘article_id’<\/span>];  <\/span><\/span><\/li>\n
  21.         $goods<\/span>[<\/span>$idx<\/span>][<\/span>‘id’<\/span>] = <\/span>$row<\/span>[<\/span>‘goods_id’<\/span>];  <\/span><\/span><\/li>\n
  22.         $goods<\/span>[<\/span>$idx<\/span>][<\/span>‘name’<\/span>] = <\/span>$row<\/span>[<\/span>‘goods_name’<\/span>];  <\/span><\/span><\/li>\n
  23.         $goods<\/span>[<\/span>$idx<\/span>][<\/span>‘brief’<\/span>] = <\/span>$row<\/span>[<\/span>‘goods_brief’<\/span>];  <\/span><\/span><\/li>\n
  24.         $goods<\/span>[<\/span>$idx<\/span>][<\/span>‘brand_name’<\/span>] = <\/span>$row<\/span>[<\/span>‘brand_name’<\/span>];  <\/span><\/span><\/li>\n
  25.         $goods<\/span>[<\/span>$idx<\/span>][<\/span>‘goods_style_name’<\/span>] = add_style(<\/span>$row<\/span>[<\/span>‘goods_name’<\/span>],<\/span>$row<\/span>[<\/span>‘goods_name_style’<\/span>]);  <\/span><\/span><\/li>\n
  26.         $goods<\/span>[<\/span>$idx<\/span>][<\/span>‘short_name’<\/span>] = <\/span>$GLOBALS<\/span>[<\/span>‘_CFG’<\/span>][<\/span>‘goods_name_length’<\/span>] > 0 ?  <\/span><\/span><\/li>\n
  27.         sub_str($row<\/span>[<\/span>‘goods_name’<\/span>], <\/span>$GLOBALS<\/span>[<\/span>‘_CFG’<\/span>][<\/span>‘goods_name_length’<\/span>]) : <\/span>$row<\/span>[<\/span>‘goods_name’<\/span>];  <\/span><\/span><\/li>\n
  28.         $goods<\/span>[<\/span>$idx<\/span>][<\/span>‘short_style_name’<\/span>] = add_style(<\/span>$goods<\/span>[<\/span>$idx<\/span>][<\/span>‘short_name’<\/span>],<\/span>$row<\/span>[<\/span>‘goods_name_style’<\/span>]);  <\/span><\/span><\/li>\n
  29.         $goods<\/span>[<\/span>$idx<\/span>][<\/span>‘market_price’<\/span>] = price_format(<\/span>$row<\/span>[<\/span>‘market_price’<\/span>]);  <\/span><\/span><\/li>\n
  30.         $goods<\/span>[<\/span>$idx<\/span>][<\/span>‘shop_price’<\/span>] = price_format(<\/span>$row<\/span>[<\/span>‘shop_price’<\/span>]);  <\/span><\/span><\/li>\n
  31.         $goods<\/span>[<\/span>$idx<\/span>][<\/span>‘thumb’<\/span>] = <\/span>empty<\/span>(<\/span>$row<\/span>[<\/span>‘goods_thumb’<\/span>]) ? <\/span>$GLOBALS<\/span>[<\/span>‘_CFG’<\/span>][<\/span>‘no_picture’<\/span>] : <\/span>$row<\/span>[<\/span>‘goods_thumb’<\/span>];  <\/span><\/span><\/li>\n
  32.         $goods<\/span>[<\/span>$idx<\/span>][<\/span>‘goods_img’<\/span>] = <\/span>empty<\/span>(<\/span>$row<\/span>[<\/span>‘goods_img’<\/span>]) ? <\/span>$GLOBALS<\/span>[<\/span>‘_CFG’<\/span>][<\/span>‘no_picture’<\/span>] : <\/span>$row<\/span>[<\/span>‘goods_img’<\/span>];  <\/span><\/span><\/li>\n
  33.         $goods<\/span>[<\/span>$idx<\/span>][<\/span>‘url’<\/span>] = build_uri(<\/span>‘goods’<\/span>, <\/span>array<\/span>(<\/span>‘gid’<\/span> => <\/span>$row<\/span>[<\/span>‘goods_id’<\/span>]), <\/span>$row<\/span>[<\/span>‘goods_name’<\/span>]);  <\/span><\/span><\/li>\n
  34.     }  <\/span><\/li>\n
  35.     return<\/span> <\/span>$goods<\/span>;  <\/span><\/span><\/li>\n
  36. }  <\/span><\/li>\n<\/ol>\n

    4.index.php<\/p>\n

    [php]<\/b> view plaincopy
    \n
    \n   <\/p>\n

      \n
    1. $smarty<\/span>->assign(<\/span>‘hot_goods’<\/span>,       get_recommend_goods(<\/span>‘hot’<\/span>));     <\/span>\/\/ \u70ed\u70b9\u6587\u7ae0<\/span>  <\/span><\/span><\/li>\n<\/ol>\n

      \u4e0b\uff0c\u6dfb\u52a0<\/p>\n

      [php]<\/b> view plaincopy
      \n
      \n   <\/p>\n

        \n
      1. $smarty<\/span>->assign(<\/span>‘index_appoint2_goods’<\/span>, index_appoint_goods_list(2,4));      <\/span>\/\/(\u6269\u5c55\u5206\u7c7bid,\u8c03\u75284\u6761\u6570\u636e)<\/span>  <\/span><\/span><\/li>\n<\/ol>\n

        5.themes\\default\\index.dwt \u7684\u76f8\u5e94\u4f4d\u7f6e\u6dfb\u52a0<\/p>\n

        [php]<\/b> view plaincopy
        \n
        \n   <\/p>\n

          \n
        1. <!– {<\/span>foreach<\/span> from=<\/span>$index_appoint2_goods<\/span> item=goods  name=no}–>  <\/span><\/span><\/li>\n
        2. <div class<\/span>=<\/span>“line”<\/span>>  <\/span><\/span><\/li>\n
        3.     <div class<\/span>=<\/span>“item”<\/span>>  <\/span><\/span><\/li>\n
        4.     <span class<\/span>=<\/span>“no”<\/span>>{<\/span>$smarty<\/span>.<\/span>foreach<\/span>.no.iteration}<\/span>  <\/span><\/span><\/li>\n
        5.         <p class<\/span>=<\/span>“pic”<\/span>><a href=<\/span>“{$goods.url}”<\/span>><img  src=<\/span>“{$goods.thumb}”<\/span> alt=<\/span>“{$goods.name|escape:html}”<\/span> <\/span>class<\/span>=<\/span>“B_blue”<\/span> \/><\/a><\/p>  <\/span><\/span><\/li>\n
        6.         <p class<\/span>=<\/span>“name”<\/span>>  <a href=<\/span>“{$goods.url}”<\/span> title=<\/span>“{$goods.name|escape:html}”<\/span>>{<\/span>$goods<\/span>.name|escape}<\/a><\/p>  <\/span><\/span><\/li>\n
        7.         <p class<\/span>=<\/span>“price”<\/span>>  <\/span><\/span><\/li>\n
        8.         <span class<\/span>=<\/span>“goodsPrice”<\/span>>   <\/span><\/span><\/li>\n
        9.         <!– {if<\/span> <\/span>$goods<\/span>.promote_price neq <\/span>“”<\/span>} –>  <\/span><\/span><\/li>\n
        10.         {$goods<\/span>.promote_price}  <\/span><\/span><\/li>\n
        11.         <!– {else<\/span>}–>  <\/span><\/span><\/li>\n
        12.         {$goods<\/span>.shop_price}  <\/span><\/span><\/li>\n
        13.         <!–{\/if<\/span>}–>  <\/span><\/span><\/li>\n
        14.         <\/span>  <\/span><\/li>\n
        15.         <\/p>  <\/span><\/li>\n
        16.     <\/div>  <\/span><\/li>\n
        17. <\/div>  <\/span><\/li>\n
        18. <div style=“clear:both”<\/span>><\/div>          <\/span><\/span><\/li>\n
        19. <!– {\/foreach<\/span>} –>  <\/span><\/span><\/li>\n<\/ol>\n

           <\/p>\n","protected":false},"excerpt":{"rendered":"

          \u56e0\u4e3a\u4e00\u4e9b\u539f\u56e0\u9700\u8981\u5728\u7f51\u7ad9\u9996\u9875\u8c03\u7528\u6269...<\/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-199342","post","type-post","status-publish","format-standard","hentry","category-4925"],"_links":{"self":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199342","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=199342"}],"version-history":[{"count":0,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199342\/revisions"}],"wp:attachment":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/media?parent=199342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/categories?post=199342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/tags?post=199342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}