/** * 获取相关属性的库存 * @param int $goodid 商品id * @param string(array) $attrids 商品属性id的数组或者逗号分开的字符串 */ function get_product_attr_num($goodid, $attrids = 0) { $ret = array(); /* 判断商品是否参与预售活动,如果参与则获取商品的(预售库存-已售出的数量) */ // if(!empty($_REQUEST['pre_sale_id'])) // { // $pre_sale = pre_sale_info($_REQUEST['pre_sale_id'], $goods_num); // //如果预售为空或者预售库存小于等于0则认为不限购 // if(!empty($pre_sale) && $pre_sale['restrict_amount'] > 0){ // $product_num = $pre_sale['restrict_amount'] - $pre_sale['valid_goods']; // return $product_num; // } // } if (empty($attrids)) { $ginfo = get_goods_attr_value($goodid, 'goods_number'); return $ginfo['goods_number']; //$ret[$attrids] = $ginfo['goods_number']; //return $ret; } if (!is_array($attrids)) { $attrids = explode(',', $attrids); } $goods_attr_array = sort_goods_attr_id_array($attrids); if (isset($goods_attr_array['sort'])) { $goods_attr = implode('|', $goods_attr_array['sort']); $sql = "SELECT product_id, goods_id, goods_attr, product_sn, product_number\n FROM " . $GLOBALS['ecs']->table('products') . " \n WHERE goods_id = {$goodid} AND goods_attr = '" . $goods_attr . "' LIMIT 0, 1"; $row = $GLOBALS['db']->getRow($sql); return $row['product_number']; } //sort($attrids); //$attrids = implode('|',$attrids); //$attrids = array_unique($attrids); //$attrids = str_replace(',','|',$attrids); /* echo "<pre>"; print_r($row); foreach ($row as $key => $value) { if(in_array($value['goods_attr'],$attrids)){ $ret[$value['goods_attr']] = $value['product_number']; } } return $ret; */ }
/** * 获取相关属性的库存 * @param int $goodid 商品id * @param string(array) $attrids 商品属性id的数组或者逗号分开的字符串 */ function get_product_attr_num($goodid, $attrids = 0) { //if(!empty($attrids)){ // $attrids = str_replace(',','|',$attrids); //} return is_have_stock($goodid, $attrids); //morestock_morecity $ret = array(); if (empty($attrids)) { $ginfo = get_goods_attr_value($goodid, 'goods_number'); return $ginfo['goods_number']; //$ret[$attrids] = $ginfo['goods_number']; //return $ret; } //if(!is_array($attrids)){ // $attrids = explode(',',$attrids); //} //$attrids = array_unique($attrids); $attrids = str_replace(',', '|', $attrids); $sql = "SELECT product_id, goods_id, goods_attr, product_sn, product_number\n FROM " . $GLOBALS['ecs']->table('products') . " \n WHERE goods_id = {$goodid} AND goods_attr = '" . $attrids . "'"; $row = $GLOBALS['db']->getRow($sql); return $row['product_number']; /* echo "<pre>"; print_r($row); foreach ($row as $key => $value) { if(in_array($value['goods_attr'],$attrids)){ $ret[$value['goods_attr']] = $value['product_number']; } } return $ret; */ }