【php开源代码栏目提醒】:网学会员鉴于大家对php开源代码十分关注,论文会员在此为大家搜集整理了“CartModel.php”一文,供大家参考学习
<?php
class CartModel extends Core_Db_Table
{
protected $_name = "EE_CART_INFO";
/**
* 功能:提取购物车产品列表
* 参数:$sessionid
* 返回:数组
*/
public function GetProductList($sessionid)
{
$sql = "SELECT p.F_PRODUCT_NAME,c.F_CART_PRODUCT_COUNT, p.F_PRODUCT_PRICE,";
$sql .= "c.F_ID,p.F_PRODUCT_LOW_PRICE FROM EE_CART_INFO c,EE_PRODUCT_INFO p";
$sql .= " WHERE c.F_ID_PRODUCT_INFO = p.F_ID AND c.F_CART_SESSION_ID = '$sessionid'";
$sql .= " AND c.F_ID_ORDER_INFO = 0 ORDER BY c.F_ID DESC";
return $this->_db->fetchAll($sql);
}
/**
* 功能:把产品加入购物车
* 参数:$sessionid,$userid 用户ID,$productid 产品ID
* 返回:TRUE OR FALSE
*/
public function AddToCart($sessionid,$userid=0,$productid)
{
$time = time();
$data = array();
$data[F_ID_LOGIN_INFO] = $userid;
$data[F_CART_SESSION_ID] = $sessionid;
$data[F_ID_PRODUCT_INFO] = $productid;
$data[F_CART_PRODUCT_COUNT] = 1;
$data[F_ID_ORDER_INFO] = 0;
$data[F_CART_TIME] = $time;
$sql = "SELECT F_ID FROM EE_CART_INFO WHERE F_CART_SESSION_ID = '$sessionid'";
$sql .= " AND F_ID_ORDER_INFO = 0";
$r = $this->_db->fetchRow($sql);
if($r[F_ID]) //判断购物车是否有该产品
{
return true;
}else{
return $this->_db->insert("EE_CART_INFO",$data);
}
}
/**
* 功能:清空购物车中所有产品
* 参数:$sessionid
* 返回:TRUE OR FALSE
*/
public function Truncate($sessionid)
{
$sql = "DELETE FROM EE_CART_INFO WHERE F_CART_SESSION_ID = '$sessionid'";
$sql .= " AND F_ID_ORDER_INFO = 0";
return $this->_db->query($sql);
}
/**
* 功能:更新购物车产品数量
* 参数:$sessionid,$idAry ID数组,$countAry 数量数组
*/
public function UpdateCount($sessionid,$idAry,$countAry)
{
if($idAry)
{
foreach($idAry as $key => $id)
{
$sql = "UPDATE EE_CART_INFO SET F_CART_PRODUCT_COUNT = {$countAry[$key]}";
$sql .= " WHERE F_ID = $id";
$this->_db->query($sql);
}
}
return true;
}
/**
* 功能:删除购物车中指定产品
* 参数:$id 产品ID,$sessionid
* 返回:TRUE OR FALSE
*/
public function DelProduct($id,$sessionid)
{
$sql = "DELETE FROM EE_CART_INFO WHERE F_CART_SESSION_ID = '$sessionid'";
$sql .= " AND F_ID = $id";
return $this->_db->query($sql);
}
}
?>
上一篇:
CartList.php
下一篇:
成本管理背景指导