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

/* 代码增加 by www.68ecshop.com strat */

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

/* 代码增加 by www.68ecshop.com end */

if ((DEBUG_MODE & 2) != 2)

{

$smarty->caching = true;

}

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

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

/* 代码增加_start By www.ecshop68.com */

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

{

$province = $_REQUEST['province'];

$city = $_REQUEST['city'];

$district = $_REQUEST['district'];

$suppid = intval($_REQUEST['suppid']);

$city_info = get_city_info($province, $city, $district);

$where = 'where supplier_id='.$suppid;

if($city_info['province_id']>0 && $city_info['city_id']>0)

{

$where .= ' and province_id=' . $city_info['province_id'] . ' and city_id=' . $city_info['city_id'];

$sql = 'select * from ' . $GLOBALS['ecs']->table('pickup_point') . $where;

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

die(json_encode(array('error' => 0, 'result' => $pickup_point_list, 'city_info' => $city_info)));

}

else

die(json_encode(array('error' => 1)));

}

elseif (!empty($_REQUEST['act']) && $_REQUEST['act'] == 'get_area_list')

{

$parent_id = $_REQUEST['parent_id'];

$sql = 'select region_id, region_name, region_type from ' . $GLOBALS['ecs']->table('region'). ' where parent_id=' . $parent_id;

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

die(json_encode($area_list));

}

elseif (!empty($_REQUEST['act']) && $_REQUEST['act'] == 'get_pickup_point_list')

{

$district_id = $_REQUEST['district_id'];

//$sql = 'select * from ' . $GLOBALS['ecs']->table('pickup_point') . ' where district_id=' . $district_id;

$suppid = intval($_REQUEST['suppid']);

$sql = 'select * from ' . $GLOBALS['ecs']->table('pickup_point') . ' where district_id=' . $district_id.' and supplier_id='.$suppid;

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

die(json_encode($pickup_point_list));

}

/* 代码增加_end By www.ecshop68.com */

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

//-- INPUT

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

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

/* 代码增加_start By www.68ecshop.com */

$path_name = isset($_REQUEST['path_name']) ? trim($_REQUEST['path_name']) : '';

if($path_name)

{

$pathrow = $db->getRow("select c.path_name,c.cat_id from ". $ecs->table('goods')." AS g left join ". $ecs->table('category') ." AS c on g.cat_id=c.cat_id where g.goods_id='$goods_id'" );

$pathrow['path_name'] = $pathrow['path_name'] ? $pathrow['path_name'] : ("cat".$pathrow['cat_id']);

if ($path_name != $pathrow['path_name'])

{

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

exit;

}

}

/* 代码增加_end By www.68ecshop.com */

/* 代码增加_start By www.ecshop68.com */

$sql_attr_www_ecshop68_com="SELECT a.attr_id, ga.goods_attr_id FROM ". $GLOBALS['ecs']->table('attribute') . " AS a left join ". $GLOBALS['ecs']->table('goods_attr') . " AS ga on a.attr_id=ga.attr_id WHERE a.is_attr_gallery=1 and ga.goods_id='" . $goods_id. "' order by ga.goods_attr_id ";

$goods_attr=$GLOBALS['db']->getRow($sql_attr_www_ecshop68_com);

if($goods_attr){

$goods_attr_id=$goods_attr['goods_attr_id'];

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

}else{

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

}

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

{

include('includes/cls_json.php');

$json = new JSON;

$goods_attr_id=$_REQUEST['goods_attr_id'];

$gallery_list_www_ecshop68_com=get_goods_gallery_attr_www_ecshop68_com($goods_id, $goods_attr_id);

$gallery_content=array();

$gallery_content['thumblist'] ='<ul>';

foreach($gallery_list_www_ecshop68_com as $gkey=>$gval)

{

$gallery_content['thumblist'] .= '<li>';

$gallery_content['thumblist'] .= '<a href="'. $gval['img_original'] . '" rel="zoom-id: zoom; zoom-height: 360px;zoom-width:400px;" rev="'.$gval['img_url'].'" name="'.$gval['img_url'].'" rev="'. $gval['img_original'] . '" ';

$gallery_content['thumblist'] .= '><img src="'. ($gval['thumb_url'] ? $gval['thumb_url'] : $gval['img_url']) . '" class="B_blue" ';

$gallery_content['thumblist'] .= ' /></a></li>';

if ($gkey==0)

{

$gallery_content['bigimg'] = $gval['img_original'] ;

$gallery_content['middimg'] .= $gval['img_url'] ;

}

}

$gallery_content['thumblist'] .='</ul>';

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

}

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

{

include('includes/cls_json.php');

$json = new JSON;

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

$spce_id = $_GET['id'];

$goods_id = $_GET['goods_id'];

$row = get_products_info($goods_id,explode(",",$spce_id));

//$res = array('err_msg'=>$goods_id,'id'=>$spce_id);

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

}

/* 代码增加_end By www.ecshop68.com */

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

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

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

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

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

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

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

}

if(empty($attr_id)){

$attr_id = 0;

}

$res['attr_num'] = get_product_attr_num($goods_id,$attr_id);

//$res['attr_num'] = $ret[$attr_id];

// $number = 1;

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

$mark_price = get_mark_price($goods_id);

$shop_price = ($shop_price>=0) ? $shop_price : 0;

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

$res['result1'] = price_format($mark_price);

$res['result_jf'] = floor($shop_price * $number);

//预售，检查库存是否足够

$current_number = $res['attr_num'];

if($number > $current_number)

{

$res['err_msg'] = sprintf($_LANG['err_shortage_little'], $current_number);

$res['qty'] = $current_number;

$res['err_no'] = 1;

}

}

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

}

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

{

include('includes/cls_json.php');

$json = new JSON;

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

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

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

if(empty($attr_id)){

$attr_id = 0;

}

$res['attr_num'] = get_product_attr_num($goods_id,$attr_id);

$min_price = get_final_price($goods_id, $number, true, 0);

$mark_price_min = get_mark_price($goods_id);

$sql = "SELECT *

FROM " . $ecs->table('goods_attr') ."

WHERE `goods_id` =".$goods_id;

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

if($row)

{

$ret = array();

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

if($val['attr_price']){

$ret[$val['attr_id']][$val['attr_price']] = $val;

}

}

$ret1 = $ret2 = $ret3 = $ret4 = array();

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

ksort($v);

$ret2 = end($v);

//$ret3 = array_shift($v);

$ret1[$k] = $ret2['attr_price'];

//$ret4[$k] = $ret3['attr_price'];

}

//file_put_contents('./77.txt',var_export($ret1,true));

//$cha_price = $min_price + array_sum($ret4);

//$min_price = ($cha_price > $min_price) ? $min_price : ($cha_price>=0) ? $cha_price : 0;

$max_price = $min_price + array_sum($ret1);

$mark_price_max = $mark_price_min + array_sum($ret1);

if($min_price == $max_price){

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

$res['result1'] = price_format($mark_price_min * $number);

}else{

$res['result'] = price_format($min_price * $number)." ~ ".price_format($max_price * $number);

$res['result1'] = price_format($mark_price_min * $number)." ~ ".price_format($mark_price_max * $number);

}

}else{

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

$res['result1'] = price_format($mark_price_min * $number);

}

$ret_result = array('min_price'=>$min_price,'max_price'=>$max_price);

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,oi.tb_nick, 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

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

/* 判断是否为正在预售的商品 */

$pre_sale_id = is_pre_sale_goods($goods_id);

if($pre_sale_id != null)

{

/* 进入收货人页面 */

$uri = build_uri("pre_sale", array("pre_sale_id" => $pre_sale_id));

// echo $uri;

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

exit();

}

/* 判断是否为虚拟商品 */

$is_virtual = $GLOBALS['db']->getOne("select is_virtual from ".$GLOBALS['ecs']->table('goods')." where goods_id=$goods_id");

if($is_virtual){

//直接跳到虚拟商品页面

ecs_header("Location: virtual_group_goods.php?id=".$goods_id."\n");

exit;

}

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

/* 代码增加_start By www.ecshop68.com */

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

$sql = 'select region_id, region_name from ' . $ecs->table('region') . ' where parent_id=' . $_CFG['shop_country'];

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

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

$city_id = $country_list[0]['region_id'];

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

$district_id = $db->getOne('select region_id from ' . $ecs->table('region') . ' where parent_id=' . $city_id);

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

/* 代码增加_end By www.ecshop68.com */

/* 获得商品的信息 */

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

}

/* 代码增加_start By www.68ecshop.com */

$goods['supplier_name'] ="网站自营";

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

{

$sql_supplier = "SELECT s.supplier_id,s.supplier_name,s.add_time,sr.rank_name FROM ". $ecs->table("supplier") . " as s left join ". $ecs->table("supplier_rank") ." as sr ON s.rank_id=sr.rank_id

WHERE s.supplier_id=".$goods[supplier_id]." AND s.status=1";

$shopuserinfo = $db->getRow($sql_supplier);

$goods['supplier_name']= $shopuserinfo['supplier_name'];

get_dianpu_baseinfo($goods['supplier_id'],$shopuserinfo);

}

/* 代码增加_end By www.68ecshop.com */

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

}

}

/* 检查是否已经存在于用户的收藏夹 */

$sql = "SELECT COUNT(*) FROM " .$GLOBALS['ecs']->table('collect_goods') .

" WHERE user_id='$_SESSION[user_id]' AND goods_id = '$goods_id'";

if ($GLOBALS['db']->GetOne($sql) > 0)

{

$goods['is_collet'] = 1;

}

else

{

$goods['is_collet'] = 0;

}

$goods['count'] = selled_count($goods['goods_id']);//商品销量 lw 2015-1-21

$goods_volume_price = get_goods_volume($goods_id);//查询商品的优惠数量和价格 jx 2015-1-1

//计算购买该商品赠送的消费积分

$goods['give_integral_2'] = $goods['give_integral'];

if($goods['give_integral'] > -1)

{

$goods['give_integral'] = $goods['give_integral'];

}else{

if($goods['promote_price']!=0)

{

$goods['give_integral'] = intval($goods['promote_price']);

}else{

$goods['give_integral'] = intval($goods['shop_price']);

}

}

$smarty->assign('url', $_SERVER["REQUEST_URI"]);

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

$smarty->assign('volume_price', $goods_volume_price);

$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']); // 商品属性

/* 代码增加_start By www.ecshop68.com */

$sql_zhyh_qq = "select attr_id from ".$ecs->table('attribute')." where cat_id='". $goods['goods_type'] ."' and is_attr_gallery='1' ";

$attr_id_gallery = $db->getOne($sql_zhyh_qq);

$sql = "SELECT goods_attr_id, attr_value FROM " . $GLOBALS['ecs']->table('goods_attr') . " WHERE goods_id = '$goods_id'";

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

$return_arr = array();

foreach ($results_www_ecshop68_com as $value_ecshop68)

{

$return_arr[$value_ecshop68['goods_attr_id']] = $value_ecshop68['attr_value'];

}

$prod_options_arr=array();

$prod_exist_arr = array();

$sql_prod = "select goods_attr from ". $GLOBALS['ecs']->table('products') ." where product_number>0 and goods_id='$goods_id' order by goods_attr";

$res_prod = $db->query($sql_prod);

while ($row_prod = $GLOBALS['db']->fetchRow($res_prod))

{

$prod_exist_arr[] = "|". $row_prod['goods_attr'] ."|";

}

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

$selected_first = array();

foreach ($properties['spe'] AS $skey_ecshop68=>$sval_ecshop68)

{

$hahaha_zhyh = 0;

$sskey_www_ecshop68_com = '-1';

foreach ($sval_ecshop68['values'] AS $sskey_ecshop68=>$ssval_ecshop68)

{

if ( is_exist_prod($selected_first, $ssval_ecshop68['id'], $prod_exist_arr))

{

$hahaha_zhyh = $hahaha_zhyh ? $hahaha_zhyh : $ssval_ecshop68['id'];

$sskey_www_ecshop68_com = ($sskey_www_ecshop68_com != '-1') ? $sskey_www_ecshop68_com : $sskey_ecshop68;

}

else

{

$properties['spe'][$skey_ecshop68]['values'][$sskey_ecshop68]['disabled'] = "disabled";

}

if ($skey_ecshop68==$attr_id_gallery)

{

$goods_attr_id_qq = $ssval_ecshop68['id'] ;

$sql_qq_qq87139667 = "select thumb_url from ". $ecs->table('goods_gallery'). " where goods_id='$goods_id' and goods_attr_id='$goods_attr_id_qq' and is_attr_image='1' ";

$properties['spe'][$skey_ecshop68]['values'][$sskey_ecshop68]['goods_attr_thumb'] = $db->getOne($sql_qq_qq87139667);

}

}

if ($hahaha_zhyh)

{

$selected_first[$skey_ecshop68] = $hahaha_zhyh;

}

if ($sskey_www_ecshop68_com!='-1')

{

$properties['spe'][$skey_ecshop68]['values'][$sskey_www_ecshop68_com]['selected_key_ecshop68'] = "1";

}

}

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

/* 代码增加_end By www.ecshop68.com */

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

$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_attr_www_ecshop68_com($goods_id, $goods_attr_id)); // 商品相册_修改 By www.ecshop68.com

$smarty->assign('new_goods', get_recommend_goods('new')); // 最新商品 改 By www.ecshop68.com

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

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

$smarty->assign('best_goods', get_recommend_goods('best',$goods['supplier_id'])); // 最新商品

//yyy添加start

$count1 = $GLOBALS['db']->getOne("SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('comment') . " where comment_type=0 and id_value ='$goods_id' and status=1");

$smarty->assign('review_count', $count1);

//yyy添加end名

//获取tag

$tag_array = get_tags($goods_id);

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

if($goods['is_buy'] == 1)

{

if($goods['buymax_start_date'] < gmtime() && $goods['buymax_end_date'] > gmtime())

{

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

{

$tag = 1;

}

else

{

$tag = 0;

}

}

else

{

$tag = 0;

}

}

else

{

$tag = 0;

}

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

//获取关联礼包

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

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

/* 代码增加_start By www.ecshop68.com */

$package_goods_list_120 = get_package_goods_list_120($goods['goods_id']);

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

/* 代码增加_end By www.ecshop68.com */

assign_dynamic('goods');

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

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

//评价晒单 增加 by www.68ecshop.com

$rank_num['rank_a'] = $db->getOne("SELECT COUNT(*) AS num FROM ".$ecs->table('comment')." WHERE id_value = '$goods_id' AND status = 1 AND comment_rank in (5,4)");

$rank_num['rank_b'] = $db->getOne("SELECT COUNT(*) AS num FROM ".$ecs->table('comment')." WHERE id_value = '$goods_id' AND status = 1 AND comment_rank in (3,2)");

$rank_num['rank_c'] = $db->getOne("SELECT COUNT(*) AS num FROM ".$ecs->table('comment')." WHERE id_value = '$goods_id' AND status = 1 AND comment_rank = 1");

$rank_num['rank_total'] = $rank_num['rank_a'] + $rank_num['rank_b'] + $rank_num['rank_c'];

$rank_num['rank_pa'] = ($rank_num['rank_a'] > 0) ? round(($rank_num['rank_a'] / $rank_num['rank_total']) * 100,1) : 0;

$rank_num['rank_pb'] = ($rank_num['rank_b'] > 0) ? round(($rank_num['rank_b'] / $rank_num['rank_total']) * 100,1) : 0;

$rank_num['rank_pc'] = ($rank_num['rank_c'] > 0) ? round(($rank_num['rank_c'] / $rank_num['rank_total']) * 100,1) : 0;

$rank_num['shaidan_num'] = $db->getOne("SELECT COUNT(*) AS num FROM ".$ecs->table('shaidan')." WHERE goods_id = '$goods_id' AND status = 1");

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

$res = $GLOBALS['db']->getAll("SELECT * FROM ".$GLOBALS['ecs']->table('goods_tag')." WHERE goods_id = '$goods_id' AND state = 1");

foreach ($res as $v)

{

$v['tag_num'] = $db->getOne("SELECT COUNT(*) AS num FROM ".$ecs->table('comment')." WHERE id_value = '$goods_id' AND status = 1 AND FIND_IN_SET($v[tag_id],comment_tag)");

$tag_arr[] = $v;

}

$tag_arr = array_sort($tag_arr,'tag_num','desc');

if ($tag_arr)

{

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

{

if ($_CFG['tag_show_num'] > 0)

{

if (($key + 1) <= $_CFG['tag_show_num'])

{

$comment_tags[] = $val;

}

}

else

{

$comment_tags[] = $val;

}

}

}

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

}

}

/* 记录浏览历史 */

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

$goods_n=$db->getOne('SELECT goods_number FROM' . $ecs->table('goods') . " WHERE goods_id = '$_REQUEST[id]'");

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

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