<?php

/**

* ECSHOP 商品详情

* ============================================================================

* * 版权所有 2005-2012 上海商派网络科技有限公司，并保留所有权利。

* 网站地址: http://www.ecshop.com；

* ----------------------------------------------------------------------------

* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和

* 使用；不允许对程序代码以任何形式任何目的的再发布。

* ============================================================================

* $Author: liubo $

* $Id: goods.php 17217 2011-01-19 06:29:08Z liubo $

*/

define('IN_ECS', true);

require(dirname(__FILE__) . '/includes/init.php');

include_once(ROOT_PATH . 'includes/lib_order.php');

if ((DEBUG_MODE & 2) != 2)

{

$smarty->caching = true;

}

$affiliate = unserialize($GLOBALS['_CFG']['affiliate']);

$smarty->assign('affiliate', $affiliate);

/*------------------------------------------------------ */

//-- INPUT

/*------------------------------------------------------ */

$goods_id = isset($_REQUEST['id']) ? intval($_REQUEST['id']) : 0;

//chen-0925

if($_REQUEST['act'] == 'ajax_change_goods')

{

$goods = get_collected_goods($goods_id);

echo json_encode($goods);

exit;

}

if (!empty($_REQUEST['act']) && $_REQUEST['act'] == 'choose_attr')

{

include('includes/cls_json.php');

$json = new JSON;

$good_id = $_REQUEST['good_id'];

$sql = "select goods_id,goods_name,goods_number,market_price,shop_price from ".$GLOBALS['ecs']->table('goods')." where goods_id='$good_id'";

$good = $GLOBALS['db']->getRow($sql);

$sql = "SELECT g.goods_attr_id,a.attr_name, g.attr_id,g.attr_value, g.attr_price " .

'FROM ' . $GLOBALS['ecs']->table('goods_attr') . ' AS g ' .

' LEFT JOIN '.$GLOBALS['ecs']->table('attribute').' AS a ON g.attr_id = a.attr_id '.

"WHERE g.goods_id = '" . $good_id . "' " .

'ORDER BY g.attr_id,g.attr_price';

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

$good['attr'] = $attr;

die($json->encode($good));

}

if (!empty($_REQUEST['act']) && $_REQUEST['act'] == 'get_goods_img')

{

include('includes/cls_json.php');

$json = new JSON;

$goods_id = $_REQUEST['id'];

$img_id = $_REQUEST['img_id'];

$sql = 'SELECT * FROM '.$ecs->table('goods_gallery')." WHERE goods_id ='$goods_id' AND img_id='$img_id'";

$res = $db->getRow($sql);

die($json->encode($res));

}

/*------------------------------------------------------ */

//-- 改变属性、数量时重新计算商品价格，库存

/*------------------------------------------------------ */

if (!empty($_REQUEST['act']) && $_REQUEST['act'] == 'price')

{

include('includes/cls_json.php');

$json = new JSON;

$res = array('err_msg' => '', 'result' => '', 'qty' => 1);

$attr_id = isset($_REQUEST['attr']) ? explode(',', $_REQUEST['attr']) : array();

$number = (isset($_REQUEST['number'])) ? intval($_REQUEST['number']) : 1;

if ($goods_id == 0)

{

$res['err_msg'] = $_LANG['err_change_attr'];

$res['err_no'] = 1;

}

else

{

if ($number == 0)

{

$res['qty'] = $number = 1;

}

else

{

$res['qty'] = $number;

}

$shop_price = get_final_price($goods_id, $number, true, $attr_id);

$res['result'] = price_format($shop_price * $number);

}

//ecshop商品详情页动态库存调用

$goods_tinfo = get_goods_info($goods_id);

$goods_sn = $goods_tinfo['goods_sn'];

$sql = "SELECT * FROM " .$GLOBALS['ecs']->table('products'). " WHERE goods_id = '$goods_id' LIMIT 0, 1";

$prod = $GLOBALS['db']->getRow($sql);

if (is_spec($attr_id) && !empty($prod))//此处是动态加载计算购买后的商品库存量

{

$product_info = get_products_info($goods_id, $attr_id);

}

if ($product_info['product_number'])

{

$res['stock'] = $product_info['product_number'];//商品库存

}else{

$res['stock'] = $goods_tinfo['goods_number'];//商品库存

}

if ($product_info['product_sn'])

{

$res['goods_sn'] = $product_info['product_sn'];

}else{

$res['goods_sn'] = $goods_tinfo['goods_sn'];

}

if ($product_info['product_weight'])

{

$res['goods_pweight'] = $product_info['product_weight'].' 千克(kg)';

}else{

$res['goods_pweight'] = $goods_tinfo['goods_weight'];

}

$res['ecs_shopprice'] = price_format($shop_price);

die($json->encode($res));

}

/*------------------------------------------------------ */

//-- 商品购买记录ajax处理

/*------------------------------------------------------ */

if (!empty($_REQUEST['act']) && $_REQUEST['act'] == 'gotopage')

{

$cmt = new stdClass();

$cmt->id = !empty($_GET['id']) ? intval($_GET['id']) : 0;

$cmt->page = isset($_GET['page']) && intval($_GET['page']) > 0 ? intval($_GET['page']) : 1;

$result = array('error' => 0, 'message' => '', 'content' => '');

$sale_historys = assign_sale_history($cmt->id, $cmt->page);

$smarty->assign('id', $cmt->id);

$smarty->assign('sale_historys', $sale_historys['sale_historys']);

$smarty->assign('pager', $sale_historys['pager']);

$result['content'] = $smarty->fetch("library/sale_historys.lbi");

die(json_encode($result));

}

/*------------------------------------------------------ */

//-- PROCESSOR

/*------------------------------------------------------ */

$cache_id = $goods_id . '-' . $_SESSION['user_rank'].'-'.$_CFG['lang'];

$cache_id = sprintf('%X', crc32($cache_id));

if (!$smarty->is_cached('goods.dwt', $cache_id))

{

goods_promotion($goods_id,$smarty); // 积分购,vip购

$smarty->assign('image_width', $_CFG['image_width']);

$smarty->assign('image_height', $_CFG['image_height']);

$smarty->assign('helps', get_shop_help()); // 网店帮助

$smarty->assign('id', $goods_id);

$smarty->assign('type', 0);

$smarty->assign('cfg', $_CFG);

$smarty->assign('promotion', get_promotion_info($goods_id));//促销信息

$smarty->assign('promotion_info', get_promotion_info());

$smarty->assign('comment_percent', comment_percent($goods_id)); //获取评分

$smarty->assign('top_goods', get_top10()); // 销售排行

$smarty->assign('new_comment', get_new_comment($goods_id,1)); //获取最新一条评论信息

/* 获得商品的信息 */

$goods = get_goods_info($goods_id);

if ($goods === false)

{

/* 如果没有找到任何记录则跳回到首页 */

ecs_header("Location: ./\n");

exit;

}

else

{

if ($goods['brand_id'] > 0)

{

$goods['goods_brand_url'] = build_uri('brand', array('bid'=>$goods['brand_id']), $goods['goods_brand']);

}

$shop_price = $goods['shop_price'];

$linked_goods = get_linked_goods($goods_id);

foreach($linked_goods as $kLinkGood => $vGood )

{

$linked_goods[$kLinkGood]['url'] = build_uri('goods', array('gid' => $linked_goods[$kLinkGood]['goods_id']), $linked_goods[$kLinkGood]['goods_name']);

$linked_goods[$kLinkGood]['shop_price'] = round( $linked_goods[$kLinkGood]['shop_price'], 2);

}

$goods['goods_style_name'] = add_style($goods['goods_name'], $goods['goods_name_style']);

/* 购买该商品可以得到多少钱的红包 */

if ($goods['bonus_type_id'] > 0)

{

$time = gmtime();

$sql = "SELECT type_money FROM " . $ecs->table('bonus_type') .

" WHERE type_id = '$goods[bonus_type_id]' " .

" AND send_type = '" . SEND_BY_GOODS . "' " .

" AND send_start_date <= '$time'" .

" AND send_end_date >= '$time'";

$goods['bonus_money'] = floatval($db->getOne($sql));

if ($goods['bonus_money'] > 0)

{

$goods['bonus_money'] = price_format($goods['bonus_money']);

}

}

$smarty->assign('goods', $goods);

$smarty->assign('goods_id', $goods['goods_id']);

$smarty->assign('promote_end_time', $goods['gmt_end_time']);

$smarty->assign('categories', get_categories_tree(0)); // 分类树

/* meta */

$smarty->assign('keywords', htmlspecialchars($goods['keywords']));

$smarty->assign('description', htmlspecialchars($goods['goods_brief']));

$catlist = array();

foreach(get_parent_cats($goods['cat_id']) as $k=>$v)

{

$catlist[] = $v['cat_id'];

}

assign_template('c', $catlist);

/* 上一个商品下一个商品 */

$prev_gid = $db->getOne("SELECT goods_id FROM " .$ecs->table('goods'). " WHERE cat_id=" . $goods['cat_id'] . " AND goods_id > " . $goods['goods_id'] . " AND is_on_sale = 1 AND is_alone_sale = 1 AND is_delete = 0 LIMIT 1");

if (!empty($prev_gid))

{

$prev_good['url'] = build_uri('goods', array('gid' => $prev_gid), $goods['goods_name']);

$smarty->assign('prev_good', $prev_good);//上一个商品

}

$next_gid = $db->getOne("SELECT max(goods_id) FROM " . $ecs->table('goods') . " WHERE cat_id=".$goods['cat_id']." AND goods_id < ".$goods['goods_id'] . " AND is_on_sale = 1 AND is_alone_sale = 1 AND is_delete = 0");

if (!empty($next_gid))

{

$next_good['url'] = build_uri('goods', array('gid' => $next_gid), $goods['goods_name']);

$smarty->assign('next_good', $next_good);//下一个商品

}

$position = assign_ur_here($goods['cat_id'], $goods['goods_name']);

$smarty->assign('page_title', $position['title']); // 页面标题

$smarty->assign('ur_here', $position['ur_here']); // 当前位置

$properties = get_goods_properties($goods_id); // 获得商品的规格和属性

$smarty->assign('soldnum', get_soldnum($goods_id)); // 商品销量

$goodsyh = $db->getOne("SELECT goods_yh FROM " . $ecs->table('goods') . " WHERE goods_id = ".$goods_id . " AND is_on_sale = 1 AND is_alone_sale = 1 AND is_delete = 0");

$smarty->assign('goodsyh', $goodsyh); // 商品优惠信息

$smarty->assign('package_buy_discount',$_CFG['package_buy']);

$fuwu = $db->getOne("SELECT content FROM " . $ecs->table('article') . " WHERE article_id =52 " );//售后服务

$smarty->assign('fuwu', $fuwu);

$smarty->assign('properties', $properties['pro']); // 商品属性

$smarty->assign('specification', $properties['spe']); // 商品规格

$smarty->assign('attribute_linked', get_same_attribute_goods($properties)); // 相同属性的关联商品

$smarty->assign('related_goods', $linked_goods); // 关联商品

$smarty->assign('goods_article_list', get_linked_articles($goods_id)); // 关联文章

$smarty->assign('fittings', get_goods_fittings(array($goods_id))); // 配件

$smarty->assign('rank_prices', get_user_rank_prices($goods_id, $shop_price)); // 会员等级价格

$smarty->assign('pictures', get_goods_gallery($goods_id)); // 商品相册->原版调取商品图片

$smarty->assign('bought_goods', get_also_bought($goods_id)); // 购买了该商品的用户还购买了哪些商品

$smarty->assign('goods_rank', get_goods_rank($goods_id)); // 商品的销售排名

//by mike start

//组合套餐名

$comboTabIndex = array(' ','一', '二', '三','四','五','六','七','八','九','十');

$smarty->assign('comboTab',$comboTabIndex);

//组合套餐组

$fittings_list = get_goods_fittings(array($goods_id));

if(is_array($fittings_list)){

foreach($fittings_list as $vo){

$fittings_index[$vo['group_id']] = 1;//关联数组

}

}

ksort($fittings_index);//重新排序

$smarty->assign('fittings_tab_index', $fittings_index);//套餐数量

//by mike end

//获取tag

$tag_array = get_tags($goods_id);

$smarty->assign('tags', $tag_array); // 商品的标记

//获取关联礼包

$package_goods_list = get_package_goods_list($goods['goods_id']);

$smarty->assign('package_goods_list',$package_goods_list); // 获取关联礼包

assign_dynamic('goods');

$volume_price_list = get_volume_price_list($goods['goods_id'], '1');

$smarty->assign('volume_price_list',$volume_price_list); // 商品优惠价格区间

$smarty->assign('user_may_love', get_collected_goods($_REQUEST[id]));

assign_rank_name($smarty); //chen-0925 添加函数assign_rank_name

$smarty->assign('recently_buy', recently_buy($goods_id));

$sale_history = getsales_history($goods_id);

$smarty->assign('sale_history', $sale_history);

$smarty->assign('count_sale_history', count($sale_history));

}

}

/* 记录浏览历史 */

if (!empty($_COOKIE['ECS']['history']))

{

$history = explode(',', $_COOKIE['ECS']['history']);

array_unshift($history, $goods_id);

$history = array_unique($history);

while (count($history) > $_CFG['history_number'])

{

array_pop($history);

}

setcookie('ECS[history]', implode(',', $history), gmtime() + 3600 * 24 * 30);

}

else

{

setcookie('ECS[history]', $goods_id, gmtime() + 3600 * 24 * 30);

}

//查询库存量，商品库存量-已经发出的货物数量

$sql = 'SELECT g.goods_number as num1, o.goods_number as num2 FROM ' . $ecs->table('goods') . ' AS g LEFT JOIN ' . $ecs->table('order_goods') . " AS o ON g.goods_id = o.goods_id WHERE g.goods_id= ".$goods_id;

$goods_nums=$db->getAll($sql);

$nums=$goods_nums[0]['num1']-$goods_nums[0]['num2'];

$smarty->assign('nums', $nums); // 当前系统时间

/* 更新点击次数 */

$db->query('UPDATE ' . $ecs->table('goods') . " SET click_count = click_count + 1 WHERE goods_id = '$_REQUEST[id]'");

$smarty->assign('now_time', gmtime()); // 当前系统时间

$smarty->display('goods.dwt', $cache_id);

/*------------------------------------------------------ */

//-- 获取用户等级名称chen-0925

/*------------------------------------------------------ */

function assign_rank_name($smarty)

}

function goods_promotion($goods_id , $smarty)

}

/**

* 购买此商品的人还喜欢(从用户收藏夹里取)chen-0925

*

* @access public

* @param integer $goods_id

* @return array

*/

function get_collected_goods($goods_id)

}

/*------------------------------------------------------ */

//-- PRIVATE FUNCTION

/*------------------------------------------------------ */

/**

* 获得指定商品的关联商品

*

* @access public

* @param integer $goods_id

* @return array

*/

function get_linked_goods($goods_id)

}

/**

* 获得指定商品的关联文章

*

* @access public

* @param integer $goods_id

* @return void

*/

function get_linked_articles($goods_id)

}

/**

* 获得指定商品的各会员等级对应的价格

*

* @access public

* @param integer $goods_id

* @return array

*/

function get_user_rank_prices($goods_id, $shop_price)

}

/**

* 获得购买过该商品的人还买过的商品

*

* @access public

* @param integer $goods_id

* @return array

*/

function get_also_bought($goods_id)

}

/**

* 获得指定商品的销售排名

*

* @access public

* @param integer $goods_id

* @return integer

*/

function get_goods_rank($goods_id)

}

/**

* 获得商品选定的属性的附加总价格

*

* @param integer $goods_id

* @param array $attr

*

* @return void

*/

function get_attr_amount($goods_id, $attr)

}

/**

* 取得跟商品关联的礼包列表

*

* @param string $goods_id 商品编号

*

* @return 礼包列表

*/

function get_package_goods_list($goods_id)

}

/**

* 取得商品销售总量

*

* @param string $goods_id 商品编号

*

* @return 订购量

*/

function get_goods_buy_sum($goods_id)

}

?>