\u4e00\u4e2aecshop\u5546\u57ce\u7684\u5546\u54c1\u5c5e\u6027\u5b58\u653e\u5728\u5c5e\u6027\u8868\uff08attribute\uff09\u91cc \uff0c\u6bcf\u4e2a\u5546\u54c1\u5bf9\u5e94\u7684\u5c5e\u6027\u5728goods_attr\u91cc goods_attr\u4e0e\uff08attribute\uff09\u60f3\u5173\u8054\uff0c\u5546\u54c1\u8868\u91cc\u6709\u5546\u54c1\u6570\u91cf\u7684\u5b57\u6bb5goods_number
\n
\u4e3a\u4ec0\u4e48\u6709\u8fd9\u4e2a\u8d27\u54c1\u8868\u5462\uff1f
\n
\u56e0\u4e3a \u67d0\u4ef6\u5546\u54c1\u6709\u591a\u79cd\u5c5e\u6027\u7684\u65f6\u5019\uff0c\u90a3\u8fd9\u4e2a\u5546\u54c1\u5c31\u6210\u4e3a\u4e86\u8d27\u54c1\uff0c\u4e5f\u5c31\u662f\u8bf4\u4e0d\u540c\u5c5e\u6027\u7684\u76f8\u540c\u5546\u54c1\u5e94\u8be5\u4e5f\u5b58\u5728\u5dee\u5f02\uff0c\u6240\u4ee5\u5f53\u8bbe\u7f6e\u5546\u54c1\u5c5e\u6027\u7684attr_type=1\uff08\u8868\u793a\u5355\u9009\u5c5e\u6027\uff09\u7684\u65f6\u5019\uff0c
\n
\u5728 \u524d\u53f0include\/lib_comment.php \u51fd\u6570sort_goods_attr_id_array\u5c06 goods_attr_id \u7684\u5e8f\u5217\u6309\u7167 attr_id \u91cd\u65b0\u6392\u5e8f \u53ef\u4ee5\u627e\u5230 \u975e\u89c4\u683c\u5c5e\u6027\u7684id\u4f1a\u88ab\u6392\u9664\u8fd9\u53e5\u8bdd\uff0c\u5728\u8fde\u63a5\u8fd9\u4e2a\u51fd\u6570\u5199\u7684sql\u8bed\u53e5
\n
\/\u91cd\u65b0\u6392\u5e8f
\n
$sql = “SELECT a.attr_type, v.attr_value, v.goods_attr_id
\n
FROM ” .$GLOBALS[‘ecs’]->table(‘attribute’). ” AS a
\n
LEFT JOIN ” .$GLOBALS[‘ecs’]->table(‘goods_attr’). ” AS v
\n
ON v.attr_id = a.attr_id
\n
AND a.attr_type = 1
\n
WHERE v.goods_attr_id ” . db_create_in($goods_attr_id_array) . ”
\n
ORDER BY a.attr_id $sort”;
\n
\u6211\u4e2a\u4eba\u89c9\u5f97attr_type=1\u8868\u793a\u89c4\u683c\u5c5e\u6027\uff0c\u7136\u540e\u5c31\u662f\u7531\u4e8e\u8fd9\u6837\u7684\u5904\u7406\uff0c\u5bfc\u81f4attr_type=0 attr_type=2\u7684\u5546\u54c1 \u4ed6\u4eec\u867d\u7136\u6709\u5546\u54c1\u6570\u91cf\uff0c\u4f46\u662f\u8d27\u54c1\u5e93\u5b58\u67e5\u4e0d\u51fa\u6765\u4ece\u800c\u5bfc\u81f4\u5230\u8d27\u901a\u77e5\u8fd9\u4e2a\u529f\u80fd\u51fa\u73b0\u5f02\u5e38
\n
\u9996\u5148\u6211\u4eec\u6765\u770b\u770b\u8fd9\u4e2a\u5230\u8d27\u901a\u77e5\u662f\u600e\u6837\u5904\u7406\u7684\uff1a
\n
\u4ece\u6a21\u677fgoods.dwt\u91cc\u6211\u4eec\u627e\u5230
\n
function changePrice()
\n
{
\n
var attr = getSelectedAttributes(document.forms[‘ECS_FORMBUY’]);
\n
var qty = document.forms[‘ECS_FORMBUY’].elements[‘number’].value;
\n
if(qty <=0 ){
\n
document.forms[‘ECS_FORMBUY’].elements[‘number’].value = 1;
\n
qty = 1;
\n
}
\n
Ajax.call(‘goods.php’, ‘act=price&id=’ + goodsId + ‘&attr=’ + attr + ‘&number=’ + qty, changePriceResponse, ‘GET’, ‘JSON’);
\n
}<\/p>\n
\/**
\n
* \u63a5\u6536\u8fd4\u56de\u7684\u4fe1\u606f
\n
*\/
\n
function changePriceResponse(res)
\n
{
\n
if (res.err_msg.length > 0)
\n
{
\n
alert(res.err_msg);
\n
}
\n
else
\n
{
\n
document.forms[‘ECS_FORMBUY’].elements[‘number’].value = res.qty;<\/p>\n
if (document.getElementById(‘ECS_GOODS_AMOUNT’)){
\n
document.getElementById(‘ECS_GOODS_AMOUNT’).innerHTML = res.result;
\n
}
\n
if(document.getElementById(‘ECS_GOODS_NUMBER’)){
\n
document.getElementById(‘ECS_GOODS_NUMBER’).innerHTML = res.goods_attr_number;
\n
if(res.goods_attr_number > 0){
\n
document.getElementById(‘ECS_ADD_TO_CART’).style.display=”block”;
\n
document.getElementById(‘ECS_ONE_STEP_BUY’).style.display=”block”;
\n
document.getElementById(‘ECS_DAOHUO’).style.display=”none”;
\n
}else{
\n
document.getElementById(‘ECS_ADD_TO_CART’).style.display=”none”;
\n
document.getElementById(‘ECS_ONE_STEP_BUY’).style.display=”none”;
\n
document.getElementById(‘ECS_DAOHUO’).style.display=”block”;
\n
}
\n
\u5c31\u662f\u8fd9\u91cc\uff0c\u901a\u8fc7\u53d1\u9001\u4e00\u4e2aajax\u8bf7\u6c42\u56de\u4f20\u5230goods.php\u91cc\uff0c\u5f97\u5230\u6700\u7ec8\u7684attr\uff0c\u7136\u540e\u5728goods.php\u91cc\u901a\u8fc7\uff1a
\n
\/\/– \u6539\u53d8\u5c5e\u6027\u3001\u6570\u91cf\u65f6\u91cd\u65b0\u8ba1\u7b97\u5546\u54c1\u4ef7\u683c
\n
\/*—————————————————— *\/<\/p>\n
if (!empty($_REQUEST[‘act’]) && $_REQUEST[‘act’] == ‘price’)
\n
{
\n
include(‘includes\/cls_json.php’);<\/p>\n
$json = new JSON;
\n
$res = array(‘err_msg’ => ”, ‘result’ => ”, ‘qty’ => 1);<\/p>\n
$attr_id = isset($_REQUEST[‘attr’])&&!empty($_REQUEST[‘attr’]) ? explode(‘,’, $_REQUEST[‘attr’]) : array();
\n
$number = (isset($_REQUEST[‘number’])) ? intval($_REQUEST[‘number’]) : 1;<\/p>\n
if ($goods_id == 0)
\n
{
\n
$res[‘err_msg’] = $_LANG[‘err_change_attr’];
\n
$res[‘err_no’] = 1;
\n
}
\n
else
\n
{
\n
if ($number == 0)
\n
{
\n
$res[‘qty’] = $number = 1;
\n
}
\n
else
\n
{
\n
$res[‘qty’] = $number;
\n
}
\n
$exclusive = $GLOBALS[‘db’]->getOne(“select exclusive from “.$GLOBALS[‘ecs’]->table(‘goods’).” where goods_id = $goods_id”);
\n
$shop_price = get_final_price($goods_id, $number, true, $attr_id);
\n
$res[‘is_exclusive’] = is_exclusive($exclusive,$shop_price);
\n
$res[‘result’] = price_format($shop_price * $number);
\n
$res[‘result_jf’] = floor($shop_price * $number);
\n
$res[‘goods_attr_number’] = get_product_attr_num($goods_id,$_REQUEST[‘attr’]);
\n
\u56de\u4f20json\u6570\u636e\u5230\u6a21\u677f\uff0c\u901a\u8fc7if(document.getElementById(‘ECS_GOODS_NUMBER’)){
\n
document.getElementById(‘ECS_GOODS_NUMBER’).innerHTML = res.goods_attr_number;
\n
if(res.goods_attr_number > 0){
\n
document.getElementById(‘ECS_ADD_TO_CART’).style.display=”block”;
\n
document.getElementById(‘ECS_ONE_STEP_BUY’).style.display=”block”;
\n
document.getElementById(‘ECS_DAOHUO’).style.display=”none”;
\n
}else{
\n
document.getElementById(‘ECS_ADD_TO_CART’).style.display=”none”;
\n
document.getElementById(‘ECS_ONE_STEP_BUY’).style.display=”none”;
\n
document.getElementById(‘ECS_DAOHUO’).style.display=”block”;
\n
}\u5c31\u53ef\u4ee5\u5b9e\u73b0\u5230\u8d27\u901a\u77e5
\n
\u6211\u4eec\u5728\u6765\u770b\u770b\u8fd9\u4e2a goods_attr_number\u5728php\u9875\u9762\u662f\u600e\u6837\u5f97\u5230\u7684
\n
$res[‘goods_attr_number’] = get_product_attr_num($goods_id,$_REQUEST[‘attr’]);—-attr\u662fajax\u8c03\u6765\u7684\u6570\u636e\uff0c\u5f80\u4e0a\u627e\u4f1a\u770b\u5230\u5b83\u7684\u5904\u7406
\n
\u7ee7\u7eed\u627eget_product_attr_num
\n
get_product_attr_num \u83b7\u53d6\u76f8\u5173\u5c5e\u6027\u7684\u5e93\u5b58* @param int $goodid \u5546\u54c1id * @param string(array) $attrids \u5546\u54c1\u5c5e\u6027id\u7684\u6570\u7ec4\u6216\u8005\u9017\u53f7\u5206\u5f00\u7684\u5b57\u7b26\u4e32
\n
\u4ed4\u7ec6\u770b\u51fd\u6570\u7684\u6d41\u7a0b\uff0c\u6211\u4eec\u53d1\u73b0\u5982\u679c\u4e00\u4e2a\u5546\u54c1\u6ca1\u6709\u5c5e\u6027\uff0c\u90a3\u5b83\u7684attrid\u5c31\u662f\u7a7a\u7684\uff0c\u53c8\u4e00\u4e2a\u5546\u54c1\u6709\u591a\u4e2a\u5c5e\u6027\uff0c\u90a3\u5c31\u5bf9\u5e94\u591a\u4e2agoods_attr_id
\n
\u5728\u8fd9\u91cc\u7684\u8bdd goods_attr_number =\u5c31\u76f4\u63a5\u7b49\u4e8e\u5546\u54c1\u8868\u91ccgoods_number\u5bf9\u5e94\u7684\u6570\u91cf
\n
\u597d\u4e86\uff0c\u518d\u5f80\u4e0b\u770b\uff0c\u5982\u679c\u6709\u5c5e\u6027\uff0c\u90a3\u4e48\u5c31 \u91cd\u65b0\u6392\u5e8f \u5c31\u662f\u6211\u4e0a\u9762\u63d0\u5230\u7684\u65b9\u6cd5
\n
\u95ee\u9898\u5c31\u5728\u8fd9\u91cc\u4e86\uff0c\u90a3\u6211\u4eec\u5728\u770b\u770b\u540e\u53f0\u5546\u54c1\u5c5e\u6027\u529f\u80fd
\n
\u5728\u7f16\u8f91\u5c5e\u6027\u5904\u6709\u8fd9\u6837\u4e09\u4e2a\u5355\u9009\uff0c\u5c5e\u6027\u662f\u5426\u53ef\u9009\uff1a\u552f\u4e00\u5c5e\u6027 \u5355\u9009\u5c5e\u6027 \u590d\u9009\u5c5e\u6027 \u800c\u8fd9\u91cc\u5c31\u662fattr_type\u5bf9\u5e94 \u7684\u4e09\u79cd\u503c
\n
\u5728\u9875\u9762\u6709\u8fd9\u6837\u7684\u8bf4\u660e\uff1a
\n
\u9009\u62e9”\u5355\u9009\/\u590d\u9009\u5c5e\u6027”\u65f6\uff0c\u53ef\u4ee5\u5bf9\u5546\u54c1\u8be5\u5c5e\u6027\u8bbe\u7f6e\u591a\u4e2a\u503c\uff0c\u540c\u65f6\u8fd8\u80fd\u5bf9\u4e0d\u540c\u5c5e\u6027\u503c\u6307\u5b9a\u4e0d\u540c\u7684\u4ef7\u683c\u52a0\u4ef7\uff0c\u7528\u6237\u8d2d\u4e70\u5546\u54c1\u65f6\u9700\u8981\u9009\u5b9a\u5177\u4f53\u7684\u5c5e\u6027\u503c\u3002\u9009\u62e9”\u552f\u4e00\u5c5e\u6027”\u65f6\uff0c\u5546\u54c1\u7684\u8be5\u5c5e\u6027\u503c\u53ea\u80fd\u8bbe\u7f6e\u4e00\u4e2a\u503c\uff0c\u7528\u6237\u53ea\u80fd\u67e5\u770b\u8be5\u503c\u3002
\n
\u4f46\u662f \u51fa\u73b0\u95ee\u9898\u6765\u4e86\uff0c\u5982\u679c\u6ca1\u6709\u9009\u62e9\u5355\u5355\u9009\u5c5e\u6027 \u90a3\u4e48\u5728\u5546\u54c1\u5217\u8868\u91cc\u6216\u8005\u518d\u6dfb\u52a0\u5546\u54c1\u7684\u65f6\u5019\u8fd9\u4e2a\u5546\u54c1\u7684\u5c5e\u6027\u4e0d\u662f\u5355\u9009\u5c5e\u6027\u90a3\u4e48\u5c31\u4e0d\u4f1a\u51fa\u73b0\u8d27\u54c1\u7ba1\u7406\u8fd9\u4e2a\u529f\u80fd
\n
\u56e0\u4e3a\u5728\u8fd9\u4e2a\u529f\u80fd\u5904\u4e5f\u6709\u4e2a\u903b\u8f91
\n
\u5728\u540e\u53f0\u7684goods.php\u91cc\u627e\u5230\uff1a
\n
\/* \u83b7\u53d6\u5546\u54c1\u89c4\u683c\u5217\u8868 *\/
\n
$attribute = get_goods_specifications_list($goods_id);
\n
\u5728lib_goods.php\u91cc\u627e\u5230\u91cc\u8fd9\u4e2a\u51fd\u6570
\n
\/**
\n
* \u83b7\u53d6\u5546\u54c1\u7c7b\u578b\u4e2d\u5305\u542b\u89c4\u683c\u7684\u7c7b\u578b\u5217\u8868
\n
*
\n
* @access public
\n
* @return array
\n
*\/
\n
function get_goods_type_specifications()
\n
{
\n
\/\/ \u67e5\u8be2
\n
$sql = “SELECT DISTINCT cat_id
\n
FROM ” .$GLOBALS[‘ecs’]->table(‘attribute’). ”
\n
WHERE attr_type = 1″;
\n
$row = $GLOBALS[‘db’]->GetAll($sql);<\/p>\n
$return_arr = array();
\n
if (!empty($row))
\n
{
\n
foreach ($row as $value)
\n
{
\n
$return_arr[$value[‘cat_id’]] = $value[‘cat_id’];
\n
}
\n
}
\n
return $return_arr;
\n
}
\n
\u4e0d\u96be\u53d1\u73b0\uff0c\u8fd9\u91cc\u4e5f\u53ea\u6709attr_type = 1 \u624d\u4f1a\u51fa\u73b0\u8d27\u54c1\u8fd9\u4e2a\u529f\u80fd<\/p>\n","protected":false},"excerpt":{"rendered":"
\u4e00\u4e2aecshop\u5546\u57ce\u7684\u5546\u54c1\u5c5e\u6027\u5b58...<\/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-199552","post","type-post","status-publish","format-standard","hentry","category-4925"],"_links":{"self":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199552","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=199552"}],"version-history":[{"count":0,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199552\/revisions"}],"wp:attachment":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/media?parent=199552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/categories?post=199552"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/tags?post=199552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}