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

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;

$qq = explode(',', htmlspecialchars($_CFG['skype']));

/*echo "<pre>";

print_r($id1_arr1);

echo "</pre>";*/

/*

echo "<pre>";

print_r($id1_arr2);

echo "</pre>";*/

/*$id1_arr0 = array_merge($id1_arr1,$id1_1);

if(in_array($,$id1_arr0)){

}*/

/*echo "<pre>";

print_r($id1_arr0);

echo "</pre>";*/

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

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

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

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

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

}

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

}

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

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

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

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

{

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

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

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

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

$cat_id = $goods['cat_id'];

//根据楼层id 选出所有的子集id

$louceng_qq=explode(',',$_CFG['skype']);

$id1 = get_child_tree(705);

$id2 = get_child_tree(706);

$id3 = get_child_tree(707);

//假设产品就在市场这个分类下

$cat_sql ="select parent_id,kfqq from ecs_category where cat_id =".$cat_id;

$mes = $db->getAll($cat_sql);

//判断客服qq是否直接在本身的栏目中

if(!$mes[0]['kfqq']){

//如果不在，则根据父级栏目id找寻上一级

$cat_sql1 ="select parent_id,kfqq from ecs_category where cat_id =".$mes[0]['parent_id'];

$mes1 = $db->getAll($cat_sql1);

if(!$mes1[0]['kfqq']){

//如果不在，则根据父级栏目id找寻上一级

$cat_sql2 ="select parent_id,kfqq from ecs_category where cat_id =".$mes1[0]['parent_id'];

$mes2 = $db->getAll($cat_sql2);

//如果还是没有的话 就查扩展分类里面

if(!$mes2[0]['kfqq']){

$cat_sql3 ="select cat_id from ecs_goods_cat where goods_id = ".$goods['goods_id'];

$mes3 = $db->getAll($cat_sql3);

foreach($mes3 as $key => $val){

$new_id[] = $val['cat_id'];

}

$new_id_str = implode(",",$new_id);

$cat_sql4 ="select parent_id,kfqq from ecs_category where cat_id in ( ".$new_id_str.") ";

$mes4 = $db->getAll($cat_sql4);

//判断从扩展分类中的栏目id来的kfqq是否存在值

foreach($mes4 as $key => $val){

if($val['kfqq']){

$t_qq = $val['kfqq'];

}

$new_id2[] = $val['parent_id'];

}

if(!$t_qq){

$new_id_str2 = implode(",",$new_id2);

$cat_sql5 ="select parent_id,kfqq from ecs_category where cat_id in ( ".$new_id_str2.") ";

$mes5 = $db->getAll($cat_sql5);

//判断从扩展分类中的上一级栏目id来的kfqq是否存在值

foreach($mes5 as $key => $val){

if($val['kfqq']){

$t_qq = $val['kfqq'];

}

}

}

}else{

$t_qq = $mes2[0]['kfqq'];

}

}else{

$t_qq = $mes1[0]['kfqq'];

}

}else{

$t_qq = $mes[0]['kfqq'];

}

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

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

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

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($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)); // 会员等级价格

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

$smarty->assign('people', get_recommend_sjs('sjs')); //获取推荐设计师

$smarty->assign('goods_recommend', get_keywords_recommend($goods_id)); //获取推荐产品

$smarty->assign('shouhou', get_shouhou_article(68)); //获取产品的售后信息

echo "<div style='display:none;'>";

echo get_shouhou_article(68);

echo "</div>";

//获取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]'");

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

}

/**

获取设计师

**/

function get_recommend_sjs($cat)

}

?>