{"id":59119,"date":"2025-04-23T09:19:53","date_gmt":"2025-04-23T01:19:53","guid":{"rendered":"https:\/\/fwq.ai\/blog\/59119\/"},"modified":"2025-04-23T09:19:53","modified_gmt":"2025-04-23T01:19:53","slug":"%e5%9c%a8ecshop%e5%90%8e%e5%8f%b0%e5%95%86%e5%93%81%e5%88%97%e8%a1%a8%e6%98%be%e7%a4%ba%e4%bc%9a%e5%91%98%e7%ad%89%e7%ba%a7%e4%bb%b7%e6%a0%bc","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/59119\/","title":{"rendered":"\u5728ECSHOP\u540e\u53f0\u5546\u54c1\u5217\u8868\u663e\u793a\u4f1a\u5458\u7b49\u7ea7\u4ef7\u683c"},"content":{"rendered":"

\u6b64\u8d34\u539f\u6765\u662f\u56de\u590d\u4e00\u4f4d\u670b\u53cb\u63d0\u95ee\u7684\uff0c\u8003\u8651\u5230\u4e5f\u8bb8\u8fd8\u6709\u5176\u4ed6\u4eba\u4e5f\u9700\u8981\u8be5\u529f\u80fd<\/span>\uff0c\u6240\u4ee5\u6574\u7406\u4e86\u4e0b\uff0c\u5355\u72ec\u53d1\u5e03\u4e00\u4e0b\u3002<\/p>\n

1\u3001\u4fee\u6539admin\/includes\/lib_goods.php\u7684goods_list()\u51fd\u6570\u90e8\u5206
\u5728<\/p>\n\n\n\n
return array(‘goods’ => $row, ‘filter’ => $filter, ‘page_count’ => $filter[‘page_count’], ‘record_count’ => $filter[‘record_count’]);<\/font><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u524d\u9762\u589e\u52a0\u4e0b\u9762\u4ee3\u7801<\/p>\n\n\n\n
foreach($row as $key_tmp=>$goods_tmp)
{
$sql = “SELECT rank_id, IFNULL(mp.user_price, r.discount * $goods_tmp[shop_price] \/ 100) AS price, r.rank_name, r.discount ” .
‘FROM ‘ . $GLOBALS[‘ecs’]->table(‘user_rank’) . ‘ AS r ‘ .
‘LEFT JOIN ‘ . $GLOBALS[‘ecs’]->table(‘member_price’) . ” AS mp “.
“ON mp.goods_id = ‘$goods_tmp[goods_id]’ AND mp.user_rank = r.rank_id ” .
“WHERE r.show_price = 1 OR r.rank_id = ‘$_SESSION[user_rank]'”;
$res_up = $GLOBALS[‘db’]->query($sql);
while ($row_up = $GLOBALS[‘db’]->fetchRow($res_up))
{
$row[$key_tmp][‘user_price’][$row_up[‘rank_id’]] = array(
‘rank_name’ => htmlspecialchars($row_up[‘rank_name’]),
‘price’ => price_format($row_up[‘price’]));
}
}<\/font><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

2\u3001<\/p>\n

\u4fee\u6539\u6a21\u677f<\/span>\u6587\u4ef6<\/span> admin\/templates\/goods_list.htm
\u5728{$goods.shop_price}\u4e0e<\/span>\u4e4b\u95f4\u589e\u52a0\u4e0b\u9762\u4ee3\u7801<\/p>\n\n\n\n
{if $goods.user_price}
{foreach from=$goods.user_price item=user_price }
<br>
{$user_price.rank_name}\uff1a{$user_price.price}
{\/foreach}
{\/if}<\/font><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

\u6b64\u8d34\u539f\u6765\u662f\u56de\u590d\u4e00\u4f4d\u670b\u53cb\u63d0\u95ee\u7684\uff0c\u8003\u8651\u5230\u4e5f\u8bb8\u8fd8\u6709\u5176\u4ed6\u4eba\u4e5f\u9700\u8981\u8be5\u529f\u80fd\uff0c\u6240\u4ee5\u6574\u7406\u4e86\u4e0b\uff0c\u5355\u72ec\u53d1\u5e03\u4e00\u4e0b\u3002 1\u3001\u4fee\u6539admin\/includes\/lib_goods.php\u7684goods_list()\u51fd\u6570\u90e8\u5206 \u5728 return array(‘goods’ => $row, ‘filter’ => $filter, ‘page_count’ => $filter[‘page_count’], ‘record_count’ => $filter[‘record_count’]); \u524d\u9762\u589e\u52a0\u4e0b\u9762\u4ee3\u7801 foreach($row as $key_tmp=>$goods_tmp) { $sql = “SELECT rank_id, IFNULL(mp.user_price, r.discount * $goods_tmp[shop_price] \/ 100) AS price, r.rank_name, r.discount ” . ‘FROM ‘ . $GLOBALS[‘ecs’]->table(‘user_rank’) . ‘ AS r ‘ . ‘LEFT JOIN ‘ . $GLOBALS[‘ecs’]->table(‘member_price’) . ” AS […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-59119","post","type-post","status-publish","format-standard","hentry","category-16"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/59119","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/comments?post=59119"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/59119\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=59119"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=59119"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=59119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}