ecshop修改处理用户购物车的行为的方法

1 /**
2 * 选择购物车商品的获取条件
3 * Desc: 如果已登录，返回user_id条件，否则返回session_id条件
4 * @access public
5 * @return where condition
6 */
7 function rec_select()
8 {
9 return (isset($_SESSION['user_id'])&&intval($_SESSION['user_id'])>0)?"user_id= ".intval($_SESSION['user_id'])." ":"session_id = '" . SESS_ID . "' ";
10 }
11
12 /**
13 * 更新购物车中的商品
14 * Desc: 如果用户已登录且其在未登录时将商品加入了购物车，那么将未登录时的购物车与用户之前的购物车商品合并
15 * @access public
16 * @return boolean
17 */
18 function update_user_cart()
19 {
20 if(!isset($_SESSION['user_id']))
21 return FALSE;
22
23 /*查看是否有未登录时加入购物车的商品*/
24 $sql = "SELECT *, IF(parent_id, parent_id, goods_id) AS pid " .
25 " FROM " . $GLOBALS['ecs']->table('cart') . " " .
26 " WHERE session_id = '" . SESS_ID . "' AND user_id=0 AND rec_type = '" . CART_GENERAL_GOODS . "'" .
27 " ORDER BY pid, parent_id";
28 $res = $GLOBALS['db']->query($sql);
29
30 $_uid=intval($_SESSION['user_id']);
31
32 while ($row = $GLOBALS['db']->fetchRow($res))
33 {
34 if($_uid>0)
35 {
36 /* 检查该商品是否已经存在在购物车中 */
37 $sql="SELECT * FROM {$GLOBALS['ecs']->table('cart')} WHERE user_id={$_uid} AND goods_id={$row['goods_id']} AND rec_type = '" . CART_GENERAL_GOODS."'
38 AND goods_attr='{$row['goods_attr']}'
39 AND goods_attr_id={$row['goods_attr_id']}
40 AND product_id={$row['product_id']}
41 AND parent_id={$row['parent_id']}
42 AND is_gift={$row['is_gift']}
43 AND is_shipping={$row['is_shipping']}
44 ";
45 $_one=$GLOBALS['db']->getOne($sql);
46
47 if(!empty($_one))
48 {
49 $goods_number=$_one['goods_number']+$row['goods_number'];
50 $sql="UPDATE {$GLOBALS['ecs']->table('cart')} SET goods_number = {$goods_number} WHERE rec_id = {$_one['rec_id']}";
51 $GLOBALS['db']->query($sql);
52
53 $sql="DELETE FROM {$GLOBALS['ecs']->table('cart')} WHERE rec_id = {$row['rec_id']}";
54 $GLOBALS['db']->query($sql);
55 }
56 else
57 {
58 $sql="UPDATE {$GLOBALS['ecs']->table('cart')} SET user_id = {$_uid} WHERE rec_id = {$row['rec_id']}";
59 $GLOBALS['db']->query($sql);
60 }
61
62 }
63 }
64 return TRUE;
65 }

function destroy_session()
{
$GLOBALS['_SESSION'] = array();
setcookie($this->session_name, $this->session_id, 1, $this->session_cookie_path, $this->session_cookie_domain, $this->session_cookie_secure);
/* ECSHOP 鑷?畾涔夋墽琛岄儴鍒 */
/*
if (!empty($GLOBALS['ecs']))
{
$this->db->query('DELETE FROM ' . $GLOBALS['ecs']->table('cart') . " WHERE session_id = '$this->session_id'");
}
*/
/*修改：只删除没有用户的购物车*/
if (!empty($GLOBALS['ecs']))
{
$this->db->query('DELETE FROM ' . $GLOBALS['ecs']->table('cart') . " WHERE session_id = '$this->session_id' AND user_id=0");
}
/* ECSHOP 鑷?畾涔夋墽琛岄儴鍒 */
$this->db->query('DELETE FROM ' . $this->session_data_table . " WHERE sesskey = '" . $this->session_id . "' LIMIT 1");
return $this->db->query('DELETE FROM ' . $this->session_table . " WHERE sesskey = '" . $this->session_id . "' LIMIT 1");
}