วันพฤหัสบดีที่ 27 มิถุนายน พ.ศ. 2556

Yii Basic Shoping Cart

#MySQL DataDase

CREATE TABLE `cart` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ProductID` varchar(10) NOT NULL,
  `Qty` varchar(10) NOT NULL,
  `SessionOrder` varchar(100) NOT NULL,
  `OrderIP` varchar(100) NOT NULL,
  `OrderDate` date NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ProductID` (`ProductID`,`SessionOrder`,`OrderIP`,`OrderDate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


#Controller - > ActionCart

public function actionAddToCart($ProductID) {
         
           $SessionID = Yii::app()->session->sessionID;
           $IPadd = Yii::app()->request->userHostAddress;
           $Cart = New Cart();
         
      
          if(!empty($_GET)){
             
          $ProductID = $_GET['ProductID'];
           $Cart->Qty =  1; 
           $Cart->ProductID = $_GET['ProductID'] ;
           $Cart->SessionOrder =  $SessionID ;
           $Cart->OrderIP =  $IPadd;
           $Cart->OrderDate = date('Y-m-d H:i:s');   
      
if($ProductID = '5600003' and $SessionID = '83b96840542c1b43553462272a089258' ){
                 // $Cart = Cart::model()->findByPk(2);
                 
                  $Cart = Cart::model()->findByAttributes(array('ProductID' => '5600003', 'SessionOrder' => '83b96840542c1b43553462272a089258'));
                  $Cart->Qty =  $Cart->Qty+1; 

              }

          if($Cart->save()){
               $this->redirect(array("site/OrderList"));
          }
           
                    }
         
        }

ไม่มีความคิดเห็น:

แสดงความคิดเห็น