<?php

/**

* ECSHOP 商品详情

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

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

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

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

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

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

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

* $Author: liubo $

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

*/

define('IN_ECTOUCH', true);

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

require(ROOT_PATH . 'include/lib_weixintong.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;

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

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

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

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

{

include('include/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);

//甜心100修复。

$tianxin100=$shop_price * $number;

$res['result'] = "￥".$tianxin100;

}

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

}

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

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

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

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

{

include('include/cls_json.php');

$json = new JSON;

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

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

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

if (!empty($goods_id))

{

$need_cache = $GLOBALS['smarty']->caching;

$need_compile = $GLOBALS['smarty']->force_compile;

$GLOBALS['smarty']->caching = false;

$GLOBALS['smarty']->force_compile = true;

/* 商品购买记录 */

$sql = 'SELECT u.user_name, og.goods_number, oi.add_time, IF(oi.order_status IN (2, 3, 4), 0, 1) AS order_status ' .

'FROM ' . $ecs->table('order_info') . ' AS oi LEFT JOIN ' . $ecs->table('users') . ' AS u ON oi.user_id = u.user_id, ' . $ecs->table('order_goods') . ' AS og ' .

'WHERE oi.order_id = og.order_id AND ' . time() . ' - oi.add_time < 2592000 AND og.goods_id = ' . $goods_id . ' ORDER BY oi.add_time DESC LIMIT ' . (($page > 1) ? ($page-1) : 0) * 5 . ',5';

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

foreach ($bought_notes as $key => $val)

{

$bought_notes[$key]['add_time'] = local_date("Y-m-d G:i:s", $val['add_time']);

}

$sql = 'SELECT count(*) ' .

'FROM ' . $ecs->table('order_info') . ' AS oi LEFT JOIN ' . $ecs->table('users') . ' AS u ON oi.user_id = u.user_id, ' . $ecs->table('order_goods') . ' AS og ' .

'WHERE oi.order_id = og.order_id AND ' . time() . ' - oi.add_time < 2592000 AND og.goods_id = ' . $goods_id;

$count = $db->getOne($sql);

/* 商品购买记录分页样式 */

$pager = array();

$pager['page'] = $page;

$pager['size'] = $size = 5;

$pager['record_count'] = $count;

$pager['page_count'] = $page_count = ($count > 0) ? intval(ceil($count / $size)) : 1;;

$pager['page_first'] = "javascript:gotoBuyPage(1,$goods_id)";

$pager['page_prev'] = $page > 1 ? "javascript:gotoBuyPage(" .($page-1). ",$goods_id)" : 'javascript:;';

$pager['page_next'] = $page < $page_count ? 'javascript:gotoBuyPage(' .($page + 1) . ",$goods_id)" : 'javascript:;';

$pager['page_last'] = $page < $page_count ? 'javascript:gotoBuyPage(' .$page_count. ",$goods_id)" : 'javascript:;';

$smarty->assign('notes', $bought_notes);

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

$res['result'] = $GLOBALS['smarty']->fetch('library/bought_notes.lbi');

$GLOBALS['smarty']->caching = $need_cache;

$GLOBALS['smarty']->force_compile = $need_compile;

}

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

}

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

//-- 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))

{

$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());

/* 获得商品的信息 */

$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);

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

$goods['comment_count'] = get_comment_count($goods['goods_id']);

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

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']);

}

}

$goods['goods_desc'] = str_replace('src="/images/', 'src="'.$config['site_url'].'images/', $goods['goods_desc']); //修复产品详情的图片 by wang

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

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

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

$smarty->assign('sales_count', get_goods_sales_count($goods['goods_id'])); // by wang

$smarty->assign('categories', get_categories_tree($goods['cat_id'])); // 分类树

/* 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']);

/* current position */

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

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

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

$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));

/*甜心添加*/

$rank_prices=get_user_rank_prices($goods_id, $shop_price);

$user_prices="";

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

if($_SESSION['user_rank']==$k){

$user_prices=$v;

}

}

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

/*甜心添加*/

//甜心添加判断该商品是否被收藏过

$is_collect=0;

$user_id=$_SESSION['user_id'];

$sql = "SELECT * FROM " .$GLOBALS['ecs']->table('collect_goods'). " WHERE user_id = '$user_id' and goods_id='$goods_id'";

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

if(!empty($is_collect)) {

$smarty->assign('is_collect', 1 );

}else{

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

}

//甜心添加判断该商品是否被收藏过

// 会员等级价格

$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)); // 商品的销售排名

//获取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); // 商品优惠价格区间

}

}

/* 记录浏览历史 */

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);

}

/* 更新点击次数 */

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

/*甜 心10 0 修改*/

$userid=$_SESSION['user_id'];

if($rank_points>$level_register_up||$rank_points==$level_register_up)

if(!empty($userid)){

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

$level_register_up = (float)$affiliate['config']['level_register_up'];

$rank_points = $GLOBALS['db']->getOne("SELECT rank_points FROM " . $GLOBALS['ecs']->table('users')."where user_id=".$_SESSION["user_id"]);

if($rank_points>$level_register_up||$rank_points==$level_register_up){

$url=$config['site_url']."mobile/goods.php?id=".$goods_id."&u=".$userid;

//20141204新增分享返积分

$dourl=$config['site_url']."mobile/re_url.php?user_id=".$userid;

}else{

$url="";

//20141204新增分享返积分

$dourl="";

}

}else{

$url="";

//20141204新增分享返积分

$dourl="";

}

require_once "wxjs/jssdk.php";

$ret = $db->getRow("SELECT * FROM `wxch_config`");

$jssdk = new JSSDK($appid=$ret['appid'], $ret['appsecret']);

$signPackage = $jssdk->GetSignPackage();

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

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

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

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

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

/*甜心100修改*/

/*甜 心100 修复开发*/

$tianxin_url = $db->getOne("SELECT cfg_value FROM `wxch_cfg` WHERE `cfg_name` = 'tianxin_url'");

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

/*甜 心100 修复开发*/

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

$smarty->display('goods.dwt', $cache_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)

}

// 获取商品的销量 by wang

function get_goods_sales_count($goods_id)

}

// 统计商品的评论数

function get_comment_count($goods_id){

}

?>