<?phpdefined('BASEPATH') OR exit('No direct script access allowed');class cart extends Home_Controller {  private $info = array();    #前臺(tái)提交數(shù)據(jù)  private $specData = array();  #規(guī)格信息  private $prodData = array();  #貨品組合信息  private $cartData = array();  #購(gòu)物車入庫(kù)數(shù)據(jù)  /**   * 構(gòu)造函數(shù)   */  public function __construct()  {    parent::__construct();    $this->load->model('goodsModel','goods');    $this->load->model('productModel','product');    $this->load->model('goodsAttrModel','goodsAttr');  }  /**   * [購(gòu)物車]數(shù)據(jù)添加   */  public function cartAdd()  {    #接收購(gòu)物車提交數(shù)據(jù)    $this->info = $this->input->post();  // $this->ajaxReturn($this->info);    #1.驗(yàn)證商品庫(kù)存、貨品庫(kù)存    $this->checkGoodsNumber();    #2.查詢規(guī)格名稱、價(jià)格    $this->getSpecData();    #3.組裝購(gòu)物車添加de數(shù)據(jù)    $cartData = $this->setCartData();  p(json_decode($this->input->cookie('cart'),true));    # 一、判斷是否登錄    if(!UID){      //未登錄 數(shù)據(jù)存入Cookie中      //1:獲取cookie中的購(gòu)物車數(shù)據(jù)      $cookieCartData = $this->input->cookie('cart');      //2:判斷cookie中數(shù)據(jù)是否為空      if(empty($cookieCartData)){        //2-1:為空則表示用戶沒(méi)有添加過(guò)購(gòu)物車        //2-1-1.設(shè)置Key-->生成購(gòu)物車數(shù)據(jù)        $key = $cartData['goods_id'].'-'.$cartData['product_id'];        $cookieCart = array($key => $cartData);        //2-1-2.設(shè)置購(gòu)物車返回值(商品數(shù)量、總價(jià))        $this->setCartReturn(1,$cartData['goods_price']);        //2-1-3.設(shè)置Cookie存儲(chǔ)購(gòu)物車數(shù)據(jù)      }else{        //2-2:不為空 表示用戶添加過(guò)購(gòu)物車        //2-2-1.追加購(gòu)物數(shù)據(jù)        $cookieCart = $this->addCartData($cartData,json_decode($cookieCartData,true));        //2-2-2.設(shè)置購(gòu)物車返回值(商品數(shù)量、總價(jià))        $this->setCartReturn(count($cookieCart),array_sum(array_column($cookieCart, 'goods_price')));      }      //3:設(shè)置Cookie存儲(chǔ)購(gòu)物車數(shù)據(jù)      setCookie('cart',json_encode($cookieCart),LEFT_TIME,'/');    }else{      //已登錄 數(shù)據(jù)存入數(shù)據(jù)庫(kù)    }    //返回購(gòu)物車提示數(shù)據(jù)    $this->ajaxReturn($this->msg);  }  /**   * 驗(yàn)證商品庫(kù)存   */  public function checkGoodsNumber()  {    $this->goods->map = array(      'goods_id'     =>  $this->info['goods_id'],      'goods_number >='  => $this->info['buy_number'],    );    $this->goods = $this->goods->find('goods_id,goods_name,goods_sn,goods_img,shop_price');    if(!$this->goods){      $this->msg['msg'] = "商品庫(kù)存不足";      $this->ajaxReturn($this->msg);    }    #驗(yàn)證貨品庫(kù)存    $this->product->map = array(      'goods_id'     =>  $this->info['goods_id'],      'product_attr'   =>  $this->info['prod_attr'],      'product_number >=' => $this->info['buy_number'],    );    $this->prodData = $this->product->find();    if(!$this->prodData){      $this->msg['msg'] = "貨品庫(kù)存不足";      $this->ajaxReturn($this->msg);    }    return true;  }  /**   * 組合規(guī)格名稱、價(jià)格   */  public function getSpecData()  {    $this->goodsAttr->map = inToType(explode("|", $this->info['prod_attr']),'goods_attr_id');    $goodsAttrInfo = $this->goodsAttr->select('goods_attr_value,goods_attr_price');    $this->specData['product_attr_value'] = implode("|", array_column($goodsAttrInfo, 'goods_attr_value'));    $this->specData['product_price'] = array_sum(array_column($goodsAttrInfo,'goods_attr_price'));    # 返回規(guī)格信息 $this->specData  }  /**   * 組裝購(gòu)物車添加的數(shù)組   */  public function setCartData()  {    $this->cartData = array(      'product_id'  =>  $this->prodData['product_id'],      'product_attr' =>  $this->prodData['product_attr'],      'buy_number'  =>  $this->info['buy_number'],      'goods_price'  =>  $this->info['shop_price'],      'goods_sum'   =>  $this->info['shop_price'] * $this->info['buy_number'],      'product_price' =>  '',      'product_attr_value'  =>  '',      'uid'      =>  UID,    );    $this->cartData = array_merge($this->cartData,$this->goods);    #若存在規(guī)格【添加規(guī)格信息】    if(!empty($this->info['prod_attr'])){      $this->cartData['product_price'] = $this->specData['product_price'];      $this->cartData['product_attr_value'] = $this->specData['product_attr_value'];    }    return $this->cartData;    # 購(gòu)物車 添加的總數(shù)據(jù) $this->cartData;  }  /**   * 設(shè)置購(gòu)物車返回提示數(shù)據(jù)   * @param [商品數(shù)量,總價(jià)]   */  public function setCartReturn($number,$prices)  {    $this->msg['code'] = self::STATUS_ON;    $this->msg['data'] = array(        'number'  =>  $number,        'prices'  =>  $prices,    );  }  /**   * 購(gòu)物車 新添加數(shù)據(jù)   * @param [新數(shù)據(jù),原購(gòu)物車數(shù)據(jù)]   */  public function addCartData($newData,$oldData)  {    #組合Key    $key = $newData['goods_id'].'-'.$newData['product_id'];    // #判斷購(gòu)物車中是否有該商品    if(isset($oldData[$key])){      //1.有 合并商品數(shù)量、價(jià)格      $oldData[$key]['buy_number'] = $oldData[$key]['buy_number'] + $newData['buy_number'];      $oldData[$key]['goods_price'] = $newData['goods_price'];      $oldData[$key]['goods_sum'] = $oldData[$key]['buy_number'] * $oldData[$key]['goods_price'];    }else{      //2.沒(méi)有 追加新商品      $oldData[$key] = $newData;    }    #返回購(gòu)物車數(shù)據(jù)    return $oldData;  }}?>

CREATE TABLE `shop_goods` ( `goods_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `goods_name` varchar(255) NOT NULL, `type_id` int(11) DEFAULT NULL, PRIMARY KEY (`goods_id`)) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;CREATE TABLE `shop_product` ( `product_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `goods_id` int(11) NOT NULL, `goods_price` decimal(10,2) NOT NULL, `goods_num` int(11) NOT NULL, `goods_sn` varchar(50) NOT NULL, `goods_attr_id` varchar(100) NOT NULL, PRIMARY KEY (`product_id`)) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;CREATE TABLE `shop_goods_attr` ( `goods_attr_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `goods_id` int(11) NOT NULL, `attr_id` int(11) NOT NULL, `attr_value` varchar(255) NOT NULL, PRIMARY KEY (`goods_attr_id`)) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8;