{"id":199167,"date":"2025-05-03T10:19:49","date_gmt":"2025-05-03T02:19:49","guid":{"rendered":"https:\/\/server.hk\/cnblog\/199167\/"},"modified":"2025-05-03T10:19:49","modified_gmt":"2025-05-03T02:19:49","slug":"ecshop%e6%96%87%e7%ab%a0%e9%a1%b5%e5%85%b3%e8%81%94%e5%95%86%e5%93%81%e6%98%be%e7%a4%ba%e5%95%86%e5%93%81%e7%ae%80%e5%8d%95%e6%8f%8f%e8%bf%b0","status":"publish","type":"post","link":"https:\/\/server.hk\/cnblog\/199167\/","title":{"rendered":"ecshop\u6587\u7ae0\u9875\u5173\u8054\u5546\u54c1\u663e\u793a\u5546\u54c1\u7b80\u5355\u63cf\u8ff0"},"content":{"rendered":"

\u597d\u6a21\u677f\u5728\u7ed9\u5ba2\u6237\u5236\u4f5cecshop\u65f6\u5019\uff0c\u53d1\u73b0\u6587\u7ae0\u5185\u5173\u8054\u5546\u54c1\u90fd\u6bd4\u8f83\u7b80\u6d01\uff0c\u82e5\u662f\u80fd\u5728\u5173\u8054\u5546\u54c1\u7684\u6807\u9898\u4e0b\u9762\u663e\u793a\u7b80\u5355\u7684\u4ea7\u54c1\u63cf\u8ff0\uff0c\u90a3\u6837\u4f1a\u6bd4\u8f83\u597d\u770b\u3002<\/p>\n

\u5982\u4e0b\u56fe\uff1a<\/p>\n

 <\/p>\n

<\/p>\n

\u597d\u6a21\u677f\u7814\u7a76\u51fa\u5982\u4e0b\u65b9\u6cd5\uff1a<\/p>\n

\u627e\u5230 ecshop\u6839\u76ee\u5f55\u6587\u4ef6article.php<\/p>\n

\u83b7\u5f97\u6587\u7ae0\u5173\u8054\u7684\u5546\u54c1 \u8fd9\u4e2a\u5b9a\u4e49\u51fd\u6570\uff1a<\/p>\n

\u539f\u662f\uff1a<\/p>\n

 <\/p>\n

\/**<\/p>\n

 * \u83b7\u5f97\u6587\u7ae0\u5173\u8054\u7684\u5546\u54c1<\/p>\n

 *<\/p>\n

 * @access  public<\/p>\n

 * @param   integer $id<\/p>\n

 * @return  array<\/p>\n

 *\/<\/p>\n

function article_related_goods($id)<\/p>\n

{<\/p>\n

    $sql = ‘SELECT g.goods_id, g.goods_name, g.goods_thumb, g.goods_img, g.shop_price AS org_price, ‘ .<\/p>\n

                “IFNULL(mp.user_price, g.shop_price * ‘$_SESSION[discount]’) AS shop_price, “.<\/p>\n

                ‘g.market_price, g.promote_price, g.promote_start_date, g.promote_end_date ‘ .<\/p>\n

            ‘FROM ‘ . $GLOBALS[‘ecs’]->table(‘goods_article’) . ‘ ga ‘ .<\/p>\n

            ‘LEFT JOIN ‘ . $GLOBALS[‘ecs’]->table(‘goods’) . ‘ AS g ON g.goods_id = ga.goods_id ‘ .<\/p>\n

            “LEFT JOIN ” . $GLOBALS[‘ecs’]->table(‘member_price’) . ” AS mp “.<\/p>\n

                    “ON mp.goods_id = g.goods_id AND mp.user_rank = ‘$_SESSION[user_rank]’ “.<\/p>\n

            “WHERE ga.article_id = ‘$id’ AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0”;<\/p>\n

    $res = $GLOBALS[‘db’]->query($sql);<\/p>\n

 <\/p>\n

    $arr = array();<\/p>\n

    while ($row = $GLOBALS[‘db’]->fetchRow($res))<\/p>\n

    {<\/p>\n

        $arr[$row[‘goods_id’]][‘goods_id’]      = $row[‘goods_id’];<\/p>\n

        $arr[$row[‘goods_id’]][‘goods_name’]    = $row[‘goods_name’];<\/p>\n

        $arr[$row[‘goods_id’]][‘short_name’]   = $GLOBALS[‘_CFG’][‘goods_name_length’] > 0 ?<\/p>\n

            sub_str($row[‘goods_name’], $GLOBALS[‘_CFG’][‘goods_name_length’]) : $row[‘goods_name’];<\/p>\n

        $arr[$row[‘goods_id’]][‘goods_thumb’]   = get_image_path($row[‘goods_id’], $row[‘goods_thumb’], true);<\/p>\n

        $arr[$row[‘goods_id’]][‘goods_img’]     = get_image_path($row[‘goods_id’], $row[‘goods_img’]);<\/p>\n

        $arr[$row[‘goods_id’]][‘market_price’]  = price_format($row[‘market_price’]);<\/p>\n

        $arr[$row[‘goods_id’]][‘shop_price’]    = price_format($row[‘shop_price’]);<\/p>\n

        $arr[$row[‘goods_id’]][‘url’]           = build_uri(‘goods’, array(‘gid’ => $row[‘goods_id’]), $row[‘goods_name’]);<\/p>\n

 <\/p>\n

        if ($row[‘promote_price’] > 0)<\/p>\n

        {<\/p>\n

            $arr[$row[‘goods_id’]][‘promote_price’] = bargain_price($row[‘promote_price’], $row[‘promote_start_date’], $row[‘promote_end_date’]);<\/p>\n

            $arr[$row[‘goods_id’]][‘formated_promote_price’] = price_format($arr[$row[‘goods_id’]][‘promote_price’]);<\/p>\n

        }<\/p>\n

        else<\/p>\n

        {<\/p>\n

            $arr[$row[‘goods_id’]][‘promote_price’] = 0;<\/p>\n

        }<\/p>\n

    }<\/p>\n

 <\/p>\n

    return $arr;<\/p>\n

}<\/p>\n

 <\/p>\n

\u4fee\u6539\u6210\uff1a<\/span><\/p>\n

 <\/p>\n

\/**<\/p>\n

 * \u83b7\u5f97\u6587\u7ae0\u5173\u8054\u7684\u5546\u54c1<\/p>\n

 *<\/p>\n

 * @access  public<\/p>\n

 * @param   integer $id<\/p>\n

 * @return  array<\/p>\n

 *\/<\/p>\n

function article_related_goods($id)<\/p>\n

{<\/p>\n

    $sql = ‘SELECT g.goods_id, g.goods_name, g.goods_thumb, g.goods_img, g.goods_brief<\/span>, g.shop_price AS org_price, ‘ .<\/p>\n

                “IFNULL(mp.user_price, g.shop_price * ‘$_SESSION[discount]’) AS shop_price, “.<\/p>\n

                ‘g.market_price, g.promote_price, g.promote_start_date, g.promote_end_date ‘ .<\/p>\n

            ‘FROM ‘ . $GLOBALS[‘ecs’]->table(‘goods_article’) . ‘ ga ‘ .<\/p>\n

            ‘LEFT JOIN ‘ . $GLOBALS[‘ecs’]->table(‘goods’) . ‘ AS g ON g.goods_id = ga.goods_id ‘ .<\/p>\n

            “LEFT JOIN ” . $GLOBALS[‘ecs’]->table(‘member_price’) . ” AS mp “.<\/p>\n

                    “ON mp.goods_id = g.goods_id AND mp.user_rank = ‘$_SESSION[user_rank]’ “.<\/p>\n

            “WHERE ga.article_id = ‘$id’ AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0”;<\/p>\n

    $res = $GLOBALS[‘db’]->query($sql);<\/p>\n

 <\/p>\n

    $arr = array();<\/p>\n

    while ($row = $GLOBALS[‘db’]->fetchRow($res))<\/p>\n

    {<\/p>\n

        $arr[$row[‘goods_id’]][‘goods_id’]      = $row[‘goods_id’];<\/p>\n

        $arr[$row[‘goods_id’]][‘goods_name’]    = $row[‘goods_name’];<\/p>\n

 <\/p>\n

        $arr[$row[‘goods_id’]][‘short_name’]   = $GLOBALS[‘_CFG’][‘goods_name_length’] > 0 ?<\/p>\n

            sub_str($row[‘goods_name’], $GLOBALS[‘_CFG’][‘goods_name_length’]) : $row[‘goods_name’];<\/p>\n

        $arr[$row[‘goods_id’]][‘goods_thumb’]   = get_image_path($row[‘goods_id’], $row[‘goods_thumb’], true);<\/p>\n

        $arr[$row[‘goods_id’]][‘goods_img’]     = get_image_path($row[‘goods_id’], $row[‘goods_img’]);<\/p>\n

        $arr[$row[‘goods_id’]][‘market_price’]  = price_format($row[‘market_price’]);<\/p>\n

        $arr[$row[‘goods_id’]][‘shop_price’]    = price_format($row[‘shop_price’]);<\/p>\n

        $arr[$row[‘goods_id’]][‘url’]           = build_uri(‘goods’, array(‘gid’ => $row[‘goods_id’]), $row[‘goods_name’]);<\/p>\n

    <\/span>    $arr[$row[‘goods_id’]][‘goods_brief’]    = $row[‘goods_brief’];<\/span><\/p>\n

 <\/p>\n

 <\/p>\n

        if ($row[‘promote_price’] > 0)<\/p>\n

        {<\/p>\n

            $arr[$row[‘goods_id’]][‘promote_price’] = bargain_price($row[‘promote_price’], $row[‘promote_start_date’], $row[‘promote_end_date’]);<\/p>\n

            $arr[$row[‘goods_id’]][‘formated_promote_price’] = price_format($arr[$row[‘goods_id’]][‘promote_price’]);<\/p>\n

        }<\/p>\n

        else<\/p>\n

        {<\/p>\n

            $arr[$row[‘goods_id’]][‘promote_price’] = 0;<\/p>\n

        }<\/p>\n

    }<\/p>\n

 <\/p>\n

    return $arr;<\/p>\n

}<\/p>\n

 <\/p>\n

\u7ea2\u8272\u4e3a\u589e\u52a0\u90e8\u5206\uff01<\/span><\/p>\n

\u5728\u6a21\u677f\u5e93\uff1agoods_related.lbi \u76f8\u5e94\u4f4d\u7f6e\u51fa\u5165\uff1a {$releated_goods_data.goods_brief}\u3002\u641e\u5b9a\uff01<\/p>\n

\u597d\u6a21\u677f\u539f\u521b\uff0c\u8f6c\u8f7d\u8bf7\u6ce8\u660e\u7f51\u5740\uff01<\/p>\n

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

\u597d\u6a21\u677f\u5728\u7ed9\u5ba2\u6237\u5236\u4f5cecshop\u65f6...<\/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-199167","post","type-post","status-publish","format-standard","hentry","category-4925"],"_links":{"self":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199167","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=199167"}],"version-history":[{"count":0,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199167\/revisions"}],"wp:attachment":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/media?parent=199167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/categories?post=199167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/tags?post=199167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}