A5下载 - 努力做内容最丰富最安全的下载站!

A5站长下载站

当前位置:A5下载 > 源码技巧 > Ecshop > ecshop会员退出登录保留购物车里的商品

ecshop会员退出登录保留购物车里的商品

时间:2015-04-05 20:45作者:zhao人气:88

大家都知道ECShop会员退出登录同时会把已经加入购物车里的商品清空掉,通过本内容做修改即可实现会员退出登录同时保留原购物车里面的商品不清空。

1. 打开includescls_session.php文件

搜索如下代码:

$this->db->query('DELETE FROM ' . $GLOBALS['ecs']->table('cart') . " WHERE session_id = '$this->session_id'");

把代码修改为:

$this->db->query('DELETE FROM ' . $GLOBALS['ecs']->table('cart') . " WHERE session_id = '$this->session_id' AND user_id = 0");

2. 打开includeslib_main.php文件

搜索如下代码:

function update_user_info()

在改函数内部末尾添加如下代码:

/* 更新用户购物车,退出不清空购物车 */

$sql = "UPDATE " .$GLOBALS['ecs']->table('cart'). " SET".

" user_id = '" . $_SESSION['user_id'] . "'".

" WHERE session_id = '" . SESS_ID . "'";

$GLOBALS['db']->query($sql);

$sql = "UPDATE " . $GLOBALS['ecs']->table('cart') . " SET".

" session_id = '" . SESS_ID . "'".

" WHERE user_id = '" . $_SESSION['user_id'] . "'";

$GLOBALS['db']->query($sql);

/* 删除购物车中已下架的商品 */

$sql = "SELECT DISTINCT(c.goods_id) FROM " .$GLOBALS['ecs']->table('cart').

" AS c left JOIN " .$GLOBALS['ecs']->table('goods').

" AS g on c.goods_id = g.goods_id WHERE g.is_on_sale = 0 AND c.user_id = '" . $_SESSION['user_id'] . "'";

$data = $GLOBALS['db'] ->getAll($sql);

if($data){

foreach ($data as $k=>$v){

$sql = "DELETE FROM " .$GLOBALS['ecs']->table('cart'). " WHERE goods_id = '" . $v['goods_id'] . "'";

$GLOBALS['db'] -> query($sql);

}

}

标签ecshop,会员,退出,登录,保留,购物,车里,商品,大家

相关下载

查看所有评论+

网友评论

网友
您的评论需要经过审核才能显示

公众号