0, 'message' => '', 'content' => '', 'goods_id' => '','index'=>-1); $result['index']=!empty($_POST['index'])?intval($_POST['index']):'0'; $json = new JSON; if($_POST['id']) { $sql = 'DELETE FROM '.$GLOBALS['ecs']->table('cart')." WHERE rec_id=".$_POST['id']; $GLOBALS['db']->query($sql); } $sql = 'SELECT c.*,g.goods_thumb,g.goods_id,c.goods_number,c.goods_price, c.extension_code ' . ' FROM ' . $GLOBALS['ecs']->table('cart') ." AS c ". " LEFT JOIN ".$GLOBALS['ecs']->table('goods')." AS g ON g.goods_id=c.goods_id ". " WHERE " .$c_sess. " AND rec_type = '" . CART_GENERAL_GOODS . "'"; $row = $GLOBALS['db']->GetAll($sql); $arr = array(); foreach($row AS $k=>$v) { $arr[$k]['goods_thumb'] =get_image_path($v['goods_id'], $v['goods_thumb'], true); $arr[$k]['short_name'] = $GLOBALS['_CFG']['goods_name_length'] > 0 ? sub_str($v['goods_name'], $GLOBALS['_CFG']['goods_name_length']) : $v['goods_name']; $arr[$k]['url'] = build_uri('goods', array('gid' => $v['goods_id']), $v['goods_name']); $arr[$k]['goods_number'] = $v['goods_number']; $arr[$k]['goods_name'] = $v['goods_name']; $arr[$k]['goods_price'] = price_format($v['goods_price']); $arr[$k]['rec_id'] = $v['rec_id']; $arr[$k]['extension_code'] = $v['extension_code']; $properties = get_goods_properties($v['goods_id'], $v['warehouse_id'], $v['area_id'], $v['goods_attr_id'], 1); if($properties['spe']){ $arr[$k]['spe'] = array_values($properties['spe']); }else{ $arr[$k]['spe'] = array(); } } $sql = 'SELECT SUM(goods_number) AS number, SUM(goods_price * goods_number) AS amount' . ' FROM ' . $GLOBALS['ecs']->table('cart') . " WHERE " .$sess_id. " AND rec_type = '" . CART_GENERAL_GOODS . "'"; $row = $GLOBALS['db']->GetRow($sql); if ($row) { $number = intval($row['number']); $amount = floatval($row['amount']); } else { $number = 0; $amount = 0; } $result['cart_num'] = $number; $GLOBALS['smarty']->assign('str',sprintf($GLOBALS['_LANG']['cart_info'], $number, price_format($amount, false))); $GLOBALS['smarty']->assign('goods',$arr); $cart_info = array('goods_list' => $arr, 'number' => $number, 'amount' => price_format($amount, false)); $GLOBALS['smarty']->assign('cart_info',$cart_info); $result['content'] = $GLOBALS['smarty']->fetch('library/cart_info.lbi'); $result['cart_content'] = $GLOBALS['smarty']->fetch('library/cart_menu_info.lbi'); die($json->encode($result)); ?>