{"id":199336,"date":"2025-05-03T13:23:11","date_gmt":"2025-05-03T05:23:11","guid":{"rendered":"https:\/\/server.hk\/cnblog\/199336\/"},"modified":"2025-05-03T13:23:11","modified_gmt":"2025-05-03T05:23:11","slug":"%e8%8e%b7%e5%8f%96ecshop%e5%90%84%e4%b8%aa%e5%b1%9e%e6%80%a7%e7%9a%84%e5%ba%93%e5%ad%98%e7%9a%84%e7%ae%80%e5%8d%95%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/server.hk\/cnblog\/199336\/","title":{"rendered":"\u83b7\u53d6Ecshop\u5404\u4e2a\u5c5e\u6027\u7684\u5e93\u5b58\u7684\u7b80\u5355\u65b9\u6cd5"},"content":{"rendered":"

\u539f\u7406\uff1a\u4eceecshop\u6570\u636e\u5e93\u63d0\u53d6\u5404\u4e2a\u5c5e\u6027\u7684\u5e93\u5b58\uff0c\u653e\u5230\u4e00\u4e2a\u51fd\u6570\u91cc\uff0c\u7136\u540e\u7528\u6a21\u677f\u8c03\u7528\u51fa\u6765\u3002<\/p>\n

\u9700\u8981\u4fee\u6539\u7684ecshop\u6587\u4ef6\uff1a<\/p>\n

1.\u4e3b\u9898\u6a21\u677fgoods.dwt<\/p>\n

2.includes\u4e0b\u7684lib_goods.php<\/p>\n

 <\/p>\n

Step 1.<\/strong><\/p>\n

\u4fee\u6539goods.dwt<\/p>\n

\n

\u5728294\u884c\u5de6\u53f3\uff0c  <!– {foreach from=$spec.values item=value key=key} –>\u548c    <!– {\/foreach} –>\u4e4b\u95f4\uff0c\u589e\u52a0\uff08\u5e93\u5b58\uff1a{$value.product_number} {$goods.measure_unit}\uff09<\/p>\n<\/blockquote>\n

 <\/p>\n

Step 2.<\/strong><\/p>\n

\u4fee\u6539includes\u4e0b\u7684lib_goods.php<\/p>\n

\u5728625\u884c\/* \u83b7\u5f97\u5546\u54c1\u7684\u89c4\u683c *\/\u4e2d\uff0c\u4fee\u6539\u6210\u5982\u4e0b\u6837\u5b50\uff1a\u7ea2\u8272\u90e8\u5206\u662f\u589e\u52a0\u7684\u8c03\u7528<\/p>\n

 <\/p>\n

\n

$sql = “SELECT a.attr_id, a.attr_name, a.attr_group, a.is_linked, a.attr_type, “.
“g.goods_attr_id, g.attr_value, g.attr_price ” . “,p.product_sn,p.product_number ” .<\/span>
‘FROM ‘ . $GLOBALS[‘ecs’]->table(‘goods_attr’) . ‘ AS g ‘ .
‘LEFT JOIN ‘ . $GLOBALS[‘ecs’]->table(‘attribute’) . ‘ AS a ON a.attr_id = g.attr_id ‘ .
‘LEFT JOIN ‘ . $GLOBALS[‘ecs’]->table(‘products’) . ‘ AS p ON g.goods_attr_id = p.goods_attr ‘ .<\/span>
“WHERE g.goods_id = ‘$goods_id’ ” .
‘ORDER BY a.sort_order, g.attr_price, g.goods_attr_id’;
$res = $GLOBALS[‘db’]->getAll($sql);<\/p>\n

$arr[‘pro’] = array(); \/\/ \u5c5e\u6027
$arr[‘spe’] = array(); \/\/ \u89c4\u683c
$arr[‘lnk’] = array(); \/\/ \u5173\u8054\u7684\u5c5e\u6027<\/p>\n

foreach ($res AS $row)
{
$row[‘attr_value’] = str_replace(“\\n”, ‘<br \/>’, $row[‘attr_value’]);<\/p>\n

if ($row[‘attr_type’] == 0)
{
$group = (isset($groups[$row[‘attr_group’]])) ? $groups[$row[‘attr_group’]] : $GLOBALS[‘_LANG’][‘goods_attr’];<\/p>\n

$arr[‘pro’][$group][$row[‘attr_id’]][‘name’] = $row[‘attr_name’];
$arr[‘pro’][$group][$row[‘attr_id’]][‘value’] = $row[‘attr_value’];
}
else
{
$arr[‘spe’][$row[‘attr_id’]][‘attr_type’] = $row[‘attr_type’];
$arr[‘spe’][$row[‘attr_id’]][‘name’] = $row[‘attr_name’];
$arr[‘spe’][$row[‘attr_id’]][‘values’][] = array(
‘label’ => $row[‘attr_value’],
‘price’ => $row[‘attr_price’],
‘format_price’ => price_format(abs($row[‘attr_price’]), false),
‘id’ => $row[‘goods_attr_id’],
‘product_sn’ => $row[“product_sn”],<\/span>
‘product_number’ => $row[“product_number”]);<\/span>
}<\/p>\n

 <\/p>\n<\/blockquote>\n

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

\u539f\u7406\uff1a\u4eceecshop\u6570\u636e\u5e93\u63d0\u53d6\u5404...<\/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-199336","post","type-post","status-publish","format-standard","hentry","category-4925"],"_links":{"self":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199336","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=199336"}],"version-history":[{"count":0,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199336\/revisions"}],"wp:attachment":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/media?parent=199336"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/categories?post=199336"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/tags?post=199336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}