<?php

/**
 * ECSHOP 商品详情
 * ============================================================================
 * * 版权所有 2005-2016 上海商创网络科技有限公司，并保留所有权利。
 * 网站地址: http://www.ecmoban.com；
 * ----------------------------------------------------------------------------
 * 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
 * 使用；不允许对程序代码以任何形式任何目的的再发布。
 * ============================================================================
 * $Author: liubo $
 * $Id: goods.php 17217 2011-01-19 06:29:08Z liubo $
*/

define('IN_ECS', true);

require(dirname(__FILE__) . '/includes/init.php');
require(dirname(__FILE__) . '/includes/phpqrcode/phpqrcode.php'); //by wu
require(ROOT_PATH . '/includes/lib_area.php');  //ecmoban模板堂 --zhuo

if ((DEBUG_MODE & 2) != 2)
{
    $smarty->caching = true;
}

$affiliate = unserialize($GLOBALS['_CFG']['affiliate']);
$smarty->assign('affiliate', $affiliate);
$factor = intval($_CFG['comment_factor']);
$smarty->assign('factor',$factor);
/*------------------------------------------------------ */
//-- INPUT
/*------------------------------------------------------ */

$goods_id = isset($_REQUEST['id'])  ? intval($_REQUEST['id']) : 0;

$smarty->assign('category',        $goods_id);

//商品不存在则跳转回首页
if(empty($_REQUEST['act'])){
	$goods_date = array('goods_name');
	$goods_where = "goods_id = '$goods_id' AND is_delete=0";
	$goods_name = get_table_date('goods', $goods_where, $goods_date);
	if(empty($goods_name)){
		header("Location: index.php\n");
		exit;
	}
}

//ecmoban模板堂 --zhuo start 仓库
$pid = isset($_REQUEST['pid'])  ? intval($_REQUEST['pid']) : 0;  
$user_id = isset($_SESSION['user_id'])? $_SESSION['user_id'] : 0;
//ecmoban模板堂 --zhuo end 仓库

/* 清空配件购物车 */
if(!empty($_SESSION['user_id'])){
	$sess_id = " user_id = '" . $_SESSION['user_id'] . "' ";
}else{
	$sess_id = " session_id = '" . real_cart_mac_ip() . "' ";
}

/* 获得商品的信息 */
$_SESSION['goods_id'] = $goods_id;

/*------------------------------------------------------ */
//-- 改变属性、数量时重新计算商品价格
/*------------------------------------------------------ */

if (!empty($_REQUEST['act']) && $_REQUEST['act'] == 'price')
{
    include('includes/cls_json.php');

    $json   = new JSON;
    $res    = array('err_msg' => '', 'err_no' => 0, 'result' => '', 'qty' => 1);

    $attr_id    = isset($_REQUEST['attr']) ? explode(',', $_REQUEST['attr']) : array();
    $number     = (isset($_REQUEST['number'])) ? intval($_REQUEST['number']) : 1;
    $warehouse_id     = (isset($_REQUEST['warehouse_id'])) ? intval($_REQUEST['warehouse_id']) : 0;
    $area_id     = (isset($_REQUEST['area_id'])) ? intval($_REQUEST['area_id']) : 0; //仓库管理的地区ID
	
    $onload     = (isset($_REQUEST['onload'])) ? trim($_REQUEST['onload']) : ''; //仓库管理的地区ID
    
    $goods = get_goods_info($goods_id, $warehouse_id, $area_id);

    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;
        }
		
        //ecmoban模板堂 --zhuo start
        $products = get_warehouse_id_attr_number($goods_id, $_REQUEST['attr'], $goods['user_id'], $warehouse_id, $area_id);
        $attr_number = $products['product_number'];
        
        if($goods['model_attr'] == 1){
                $table_products = "products_warehouse";
                $type_files = " and warehouse_id = '$warehouse_id'";
        }elseif($goods['model_attr'] == 2){
                $table_products = "products_area";
                $type_files = " and area_id = '$area_id'";
        }else{
                $table_products = "products";
                $type_files = "";
        }

        $sql = "SELECT * FROM " .$GLOBALS['ecs']->table($table_products). " WHERE goods_id = '$goods_id'" .$type_files. " LIMIT 0, 1";
        $prod = $GLOBALS['db']->getRow($sql);
        
        if(empty($prod)){ //当商品没有属性库存时
        	$attr_number = $goods['goods_number']; 
        }

        $attr_number = !empty($attr_number) ? $attr_number : 0;
        
        $res['attr_number'] = $attr_number;
        $shop_price  = get_final_price($goods_id, $number, true, $attr_id, $warehouse_id, $area_id);
        //ecmoban模板堂 --zhuo end
		
        $res['shop_price'] = price_format($shop_price);
        $res['market_price'] = $goods['market_price'];
        
        //属性价格
        $spec_price  = get_final_price($goods_id, $number, true, $attr_id, $warehouse_id, $area_id, 1);
        $res['marketPrice_amount'] = price_format($spec_price + $goods['marketPrice']);
        
        $res['result'] = price_format($shop_price * $number);
    }

    $goods_fittings = get_goods_fittings_info($goods_id, $warehouse_id, $area_id, '', 1);
    $fittings_list = get_goods_fittings(array($goods_id), $warehouse_id, $area_id);

    if($fittings_list){
        if(is_array($fittings_list)){
            foreach($fittings_list as $vo){
                $fittings_index[$vo['group_id']] = $vo['group_id'];//关联数组
            }
        }
        ksort($fittings_index);//重新排序

        $merge_fittings = get_merge_fittings_array($fittings_index, $fittings_list); //配件商品重新分组
        $fitts = get_fittings_array_list($merge_fittings, $goods_fittings);

        for($i=0; $i<count($fitts); $i++){
            $fittings_interval = $fitts[$i]['fittings_interval'];

            $res['fittings_interval'][$i]['fittings_minMax'] = price_format($fittings_interval['fittings_min']) ."-". number_format($fittings_interval['fittings_max'], 2, '.', '');
            $res['fittings_interval'][$i]['market_minMax'] = price_format($fittings_interval['market_min']) ."-". number_format($fittings_interval['market_max'], 2, '.', '');	

            if($fittings_interval['save_minPrice'] == $fittings_interval['save_maxPrice']){
                    $res['fittings_interval'][$i]['save_minMaxPrice'] = price_format($fittings_interval['save_minPrice']);
            }else{
                    $res['fittings_interval'][$i]['save_minMaxPrice'] = price_format($fittings_interval['save_minPrice']) ."-". number_format($fittings_interval['save_maxPrice'], 2, '.', '');
            }

            $res['fittings_interval'][$i]['groupId'] = $fittings_interval['groupId'];
        }
    }
    
    
    if($GLOBALS['_CFG']['open_area_goods'] == 1){
        
        $area_list = get_goods_link_area_list($goods_id, $goods['user_id']);
        if($area_list['goods_area']){
            if(!in_array($area_id, $area_list['goods_area'])){
                $res['err_no']  = 2;  
            }
        } else {
            $res['err_no']  = 2;  
        }
    }

    die($json->encode($res));
}

/*------------------------------------------------------ */
//-- 评论有用+1
/*------------------------------------------------------ */
elseif($_REQUEST['act'] == 'add_useful')
{
    require_once (dirname(__FILE__) . '/includes/cls_json.php');
    $json = new JSON();
    
    $res    = array('err_msg' => '', 'content' => '', 'err_no' => 0);
    
    $id = empty($_REQUEST['id']) ? 0 : intval($_REQUEST['id']);
    $type = empty($_REQUEST['type']) ? 'comment' : $_REQUEST['type'];
    $goods_id = empty($_REQUEST['goods_id']) ? 0 : intval($_REQUEST['goods_id']);
    $ip     = real_ip();
    if(!empty($id))
    {
        if(!isset($_SESSION['user_id']) || $_SESSION['user_id'] == 0){
            $res['url'] = get_return_goods_url($goods_id); 
            $res['err_no'] = 1;
        }else{
            
            $useful_user = '';
            $sql = 'SELECT useful_user, useful FROM '.$ecs->table('comment')." WHERE comment_id='$id'";
            $comment = $db->getRow($sql);

            if($comment['useful_user']){
                $useful_user = explode(',', $comment['useful_user']);
                if(in_array($_SESSION['user_id'], $useful_user)){
                    $res['err_no'] = 2;
                    die($json->encode($res));
                }else{
                    array_push($useful_user, $_SESSION['user_id']);
                    $useful_user = implode(',', $useful_user);
                }
            }else{
                $useful_user = array(0);
                array_push($useful_user, $_SESSION['user_id']);
                $useful_user = implode(',', $useful_user);
            }

            $sql = 'SELECT COUNT(*) FROM '.$ecs->table('comment')." WHERE comment_id='$id'";
            $count = $db->getOne($sql);

            if($count == 1)
            {
                $sql = "UPDATE " . $ecs->table('comment') . " SET useful = useful + 1, useful_user = '$useful_user' WHERE comment_id='$id'";
                if($db->query($sql))
                {
                    $res = array('option' => 'true', 'id' => $id, 'type' => $type, 'useful' => $comment['useful'] + 1, 'err_no' => 0);
                }
                else
                {
                    $res = array('error' => '', 'id' => $id, 'type' => $type, 'err_no' => 2);
                }
            }
            else
            {
                $res = array('option' => '', 'id' => $id, 'type' => $type, 'err_no' => 2);
            }
        }    
    }  
    
    die($json->encode($res));
}


//商品评论回复
else if($_REQUEST['act'] == 'comment_reply'){ 
    include('includes/cls_json.php');
    $json   = new JSON;
    $result    = array('err_msg' => '', 'err_no' => 0, 'content' => '');
    
    $comment_id = isset($_REQUEST['comment_id']) ? intval($_REQUEST['comment_id']) : 0;
    $reply_content = isset($_REQUEST['reply_content']) ? htmlspecialchars(trim($_REQUEST['reply_content'])) : 0;
    $goods_id = isset($_REQUEST['goods_id']) ? intval($_REQUEST['goods_id']) : 0;
    $comment_user = isset($_REQUEST['user_id']) ? intval($_REQUEST['user_id']) : 0;
    $libType = isset($_REQUEST['libType']) ? intval($_REQUEST['libType']) : 0;
    $type = 0;
    $reply_page = 1;
    
    $add_time = gmtime();
    $real_ip = real_ip();
    
    $result['comment_id'] = $comment_id;
    $result['reply_content'] = $reply_content;
    
    if(!isset($_SESSION['user_id']) || $_SESSION['user_id'] == 0){
        $result['err_no'] = 1;
    }elseif($comment_user == $_SESSION['user_id']){
        $result['err_no'] = 2;
    }else{
        $comment_user_count = $GLOBALS['db']->getOne("SELECT COUNT(*) FROM " .$GLOBALS['ecs']->table('comment'). " WHERE id_value = '$goods_id' AND parent_id = '$comment_id' AND user_id = '" .$_SESSION['user_id']. "'"); 
        if($comment_user_count > 0){
            $result['err_no'] = 2;
        }else{
            
            $comment_user_name = $GLOBALS['db']->getOne("SELECT user_name FROM " .$GLOBALS['ecs']->table('users'). " WHERE user_id = '" .$_SESSION['user_id']. "'"); 
            $status = 1 - $GLOBALS['_CFG']['comment_check'];
            $sql = "INSERT INTO " .$GLOBALS['ecs']->table('comment'). "(`id_value`,`content`,`comment_type`,`user_name`,`comment_rank`,`comment_server`,`comment_delivery`, `add_time`, `parent_id`, `user_id`, `ip_address`, `status`)".
                    "VALUES('$goods_id', '$reply_content', 2, '$comment_user_name', '5', '5', '5', '$add_time', '$comment_id', '" .$_SESSION['user_id']. "', '$real_ip', '$status')";
            $GLOBALS['db']->query($sql);
            
            $result['message'] = $GLOBALS['_CFG']['comment_check'] ? $_LANG['cmt_submit_wait'] : $_LANG['cmt_submit_done'];
        }
    }
    
    if($libType == 1){
        $size = 10;
    }else{
        $size = 2;
    }
    
    if( $result['err_no'] != 1){
        $reply = get_reply_list($goods_id, $comment_id, $type, $reply_page, $libType, $size);
        
        $smarty->assign('reply_pager',  $reply['reply_pager']);
        $smarty->assign('reply_count',  $reply['reply_count']);
        $smarty->assign('reply_list',   $reply['reply_list']);

        if($libType == 1){
            $result['content'] = $smarty->fetch("library/comment_repay.lbi");
        }else{
            $result['content'] = $smarty->fetch("library/comment_reply.lbi");
        }
    }
    
    $result['url'] = get_return_goods_url($goods_id);        
    
    die($json->encode($result));
}

//ecmoban模板堂 --zhuo start 仓库
if (!empty($_REQUEST['act']) && $_REQUEST['act'] == 'in_warehouse'){
	
	include('includes/cls_json.php');

    $json   = new JSON;
    $res    = array('err_msg' => '', 'result' => '', 'qty' => 1);
	
    clear_cache_files();

    setcookie('region_id', $pid, gmtime() + 3600 * 24 * 30);
    setcookie('regionId', $pid, gmtime() + 3600 * 24 * 30);

    $area_region = 0;
    setcookie('area_region', $area_region, gmtime() + 3600 * 24 * 30);

    $res['goods_id'] = $goods_id;

    $json   = new JSON;
    die($json->encode($res));
	
}

if (!empty($_REQUEST['act']) && $_REQUEST['act'] == 'in_stock'){
	
    include('includes/cls_json.php');

    $json   = new JSON;
    $res    = array('err_msg' => '', 'result' => '', 'qty' => 1);
	
    clear_cache_files();
    
    $goods_id = empty($_GET['id']) ? 0 : intval($_GET['id']);
    $province = empty($_GET['province']) ? 1 : intval($_GET['province']);
    $city = empty($_GET['city']) ? 52 : intval($_GET['city']);
    $district = empty($_GET['district']) ? 500 : intval($_GET['district']);
    $d_null = empty($_GET['d_null']) ? 0 : intval($_GET['d_null']);
    $user_id = empty($_GET['user_id']) ? 0 : intval($_GET['user_id']);

    $user_address = get_user_address_region($user_id);
    $user_address = explode(",",$user_address['region_address']);

    setcookie('province', $province, gmtime() + 3600 * 24 * 30);
    setcookie('city', $city, gmtime() + 3600 * 24 * 30);

    setcookie('district', $district, gmtime() + 3600 * 24 * 30);

    $regionId = 0;
    setcookie('regionId', $regionId, gmtime() + 3600 * 24 * 30);

    //清空
    setcookie('type_province', 0, gmtime() + 3600 * 24 * 30);	
    setcookie('type_city', 0, gmtime() + 3600 * 24 * 30);	
    setcookie('type_district', 0, gmtime() + 3600 * 24 * 30);	

    $res['d_null'] = $d_null;

    if($d_null == 0){
            if(in_array($district,$user_address)){
                    $res['isRegion'] = 1;
            }else{
                    $res['message'] = "您尚未拥有此配送地区，请您填写配送地址";	
                    $res['isRegion'] = 88; //原为0
            }
    }else{
            setcookie('district', '', gmtime() + 3600 * 24 * 30);
    }

    $res['goods_id'] = $goods_id;
    
    $flow_warehouse = get_warehouse_goods_region($province);
    setcookie('flow_region', $flow_warehouse['region_id'], gmtime() + 3600 * 24 * 30);

    die($json->encode($res));
	
}

/**
 * 获取商品属性列表 by Leah
 */
if($_REQUEST['act']=='ajax_get_spec'){
    require_once(ROOT_PATH . 'includes/cls_json.php');

    $json = new JSON();

    $result = array('error' => 0, 'message' => '', 'attr_val' => '');

    $rec_id = isset($_REQUEST['rec_id']) ? intval($_REQUEST['rec_id']) : 0;
    $g_id = isset($_REQUEST['g_id']) ? intval($_REQUEST['g_id']) : 0;
    $g_number = isset($_REQUEST['g_number']) ? intval($_REQUEST['g_number']) : 0;
    
    $sql = "select warehouse_id, area_id from " .$ecs->table('order_goods'). " where rec_id = '$rec_id'";
    $order_goods = $db->getRow($sql);

    if ($rec_id == 0 || $g_id == 0) {

        $result['err_msg'] = '获取不到属性值';
        $result['err_no'] = 1;
    } else {

        $sql = "select goods_attr_id from " .$ecs->table('order_goods'). " where rec_id = '$rec_id'";
        $goods_attr_id = $db->getOne($sql);
        
        $goods_attr = array();
        if(!empty($goods_attr_id)){
            $goods_attr = explode(',', $goods_attr_id);
        }

        $properties = get_goods_properties($g_id, $order_goods['warehouse_id'], $order_goods['area_id']);  // 获得商品的规格和属性	
        $spec = $properties['spe'];

        if (!empty($spec)) {

            foreach ($spec as $key => $value) {
                if($value['is_checked'] == 0){
                    continue;
                }
                $result['spec'] .= '<div class="catt"><span class="type_item">' . $value['name'] . '：</span>';
                $result['spec'] .= '<input type="hidden"  value="" id="attr_' . $key . '" name="attr_val[]"/>';
				$result['spec'] .= '<span class="type_con">';
                foreach ($value['values'] as $k => $v) {
                    
                    $arr_class = get_user_attr_checked($goods_attr, $v['id']);
                    
                    if($arr_class['class'] == 'cattsel'){
                        $result['attr_val'] .= $key .'_' . $arr_class['attr_val'] . ",";
                    }
                    
                    if ($value['is_checked'] == 1) {
                        $padding = '';
                        if(!empty($v['img_flie'])){
                                $img_flie = '<img src="' . $v['img_flie'] . '" width="25" height="25">'.$v['label'];
                        }else{
                                $img_flie = $v['label'];
                                $padding = 'style="padding:3px 7px !important;"';
                        }

                        $result['spec'] .= '<a '.$padding.' class="'.$arr_class['class'].'" title="' . $v['label'] . '[' . $v['format_price'] . ']" onclick="setChange(' . $v['id'] . ' , this , ' . $key . ')" >'.$img_flie.'<i></i></a>';
                    } else {

                        $result['spec'] .= '<a href="javascipt:void(0)" class="'.$arr_class['class'].'" title="' . $v['label'] . '[' . $v['format_price'] . ']" onclick="setChange(' . $v['id'] . ',this , ' . $key . ')" >' . $v['label'] . '<i></i></a>';
                    }
                }
				$result['spec'] .= '</span>';
                $result['spec'] .='</div>';
            }

        }

		$result['spec'] .= '<div id="back_div">';
        $result['spec'] .= '<div class="type_item">换货数量：</div>';
        $result['spec'] .= '<div class="type_con"><a onclick="buyNumber.minus(this, 2)" href="javascript:;" id="decrease" class="plus_minus">-</a>';
        $result['spec'] .= '<input class="return_num" type="text" id="back_num" value="1" defaultnumber="1" name="attr_num" ' . " onblur=check_attr_num(this.id," . $g_number . "," . $rec_id .") />";
        $result['spec'] .= '</div><a onclick="buyNumber.plus(this, 2)" href="javascript:;" id="increase" class="plus_minus">+</a>';
        $result['spec'] .= '</div>';
		
        $result['rec_id'] = $rec_id;
        
        if(!empty($result['attr_val'])){
            $result['attr_val'] = substr($result['attr_val'], 0, -1);
        }
    }
    die($json->encode($result));
}    

/**
 * ecmoban模板堂 zhuo
 */
elseif($_REQUEST['act'] == 'getInfo'){
    
    require_once(ROOT_PATH .'includes/cls_json.php');
     
    $json = new JSON();
    
    $result = array('error' => 0, 'message'=> '');
    
    $attr_id = $_POST['attr_id'];
    
	$sql = "SELECT attr_gallery_flie FROM " .$GLOBALS['ecs']->table('goods_attr')." WHERE goods_attr_id = '$attr_id' and goods_id = '$goods_id'";
    $row = $db->getRow($sql);

	$result['t_img'] = $row['attr_gallery_flie'];
	
    die($json->encode($result));
}

#需要查询的IP start
if(!isset($_COOKIE['province'])){
	
	$area_array = get_ip_area_name();
        
	if($area_array['county_level'] == 2){
		$date = array('region_id', 'parent_id', 'region_name');
		$where = "region_name = '" .$area_array['area_name']. "' AND region_type = 2";
		$city_info = get_table_date('region', $where, $date, 1);
		
		$date = array('region_id', 'region_name');
		$where = "region_id = '" .$city_info[0]['parent_id']. "'";
		$province_info = get_table_date('region', $where, $date);
		
		$where = "parent_id = '" .$city_info[0]['region_id']. "' order by region_id asc limit 0, 1";
		$district_info = get_table_date('region', $where, $date, 1);
		
	}elseif($area_array['county_level'] == 1){
		$area_name = $area_array['area_name'];
		
		$date = array('region_id', 'region_name');
		$where = "region_name = '$area_name'";
		$province_info = get_table_date('region', $where, $date);
		
		$where = "parent_id = '" .$province_info['region_id']. "' order by region_id asc limit 0, 1";
		$city_info = get_table_date('region', $where, $date, 1);
		
		$where = "parent_id = '" .$city_info[0]['region_id']. "' order by region_id asc limit 0, 1";
		$district_info = get_table_date('region', $where, $date, 1);
	}
}
#需要查询的IP end

$order_area = get_user_order_area($user_id);
$user_area = get_user_area_reg($user_id); //2014-02-25

if($order_area['province'] && $user_id > 0){
	$province_id = $order_area['province'];
}else{
	if($user_area['province'] > 0){
		$province_id = $user_area['province'];
		setcookie('province', $user_area['province'], gmtime() + 3600 * 24 * 30);
		$region_id = get_province_id_warehouse($province_id);
	}else{
		
		$sql = "select region_name from " .$ecs->table('region_warehouse'). " where regionId = '" .$province_info['region_id']. "'";
		$warehouse_name = $db->getOne($sql);
		
		$province_id = $province_info['region_id'];
		$cangku_name = $warehouse_name;
		$region_id = get_warehouse_name_id(0,$cangku_name);
	}
	
}

if($order_area['province'] && $user_id > 0){
	$city_id = $order_area['city'];
}else{
	if($user_area['city'] > 0){
		$city_id = $user_area['city'];
		setcookie('city', $user_area['city'], gmtime() + 3600 * 24 * 30);
	}else{
		$city_id = $city_info[0]['region_id'];
	}
}

if($order_area['province'] && $user_id > 0){
	$district_id = $order_area['district'];
}else{
	if($user_area['district'] > 0){
		$district_id = $user_area['district'];
		setcookie('district', $user_area['district'], gmtime() + 3600 * 24 * 30);
	}else{
		$district_id = $district_info[0]['region_id'];
	}
}

$province_id = isset($_COOKIE['province']) ? $_COOKIE['province'] : $province_id;

$child_num = get_region_child_num($province_id);
if($child_num > 0){
	$city_id = isset($_COOKIE['city']) ? $_COOKIE['city'] : $city_id;
}else{
	$city_id = '';
}

$child_num = get_region_child_num($city_id);
if($child_num > 0){
	$district_id = isset($_COOKIE['district']) ? $_COOKIE['district'] : $district_id;
}else{
	$district_id = '';
}

$region_id = !isset($_COOKIE['region_id']) ? $region_id : $_COOKIE['region_id'];

$goods_warehouse = get_warehouse_goods_region($province_id); //查询用户选择的配送地址所属仓库
if($goods_warehouse){
	$regionId = $goods_warehouse['region_id'];
	if($_COOKIE['region_id'] && $_COOKIE['regionId']){
		$gw = 0;
	}else{
		$gw = 1;
		
	}
}
if($gw){
	$region_id = $regionId;
	setcookie('area_region', $region_id, gmtime() + 3600 * 24 * 30);
}

setcookie('goodsId', $goods_id, gmtime() + 3600 * 24 * 30);

$sellerInfo = get_seller_info_area();
if(empty($province_id)){
	$province_id = $sellerInfo['province'];
	$city_id = $sellerInfo['city'];
	$district_id = 0;
	
	setcookie('province', $province_id, gmtime() + 3600 * 24 * 30);
	setcookie('city', $city_id, gmtime() + 3600 * 24 * 30);
	setcookie('district', $district_id, gmtime() + 3600 * 24 * 30);
	
        $goods_warehouse = get_warehouse_goods_region($province_id);
	$region_id = $goods_warehouse['region_id'];
}
//ecmoban模板堂 --zhuo end 仓库

/*------------------------------------------------------ */
//-- 商品购买记录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 ' . gmtime() . ' - 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 ' . gmtime() . ' - 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));
}
/*------------------------------------------------------ */
//-- 猜你喜欢--换一组ajax处理
/*------------------------------------------------------ */
if (!empty($_REQUEST['act']) && $_REQUEST['act'] == 'guess_goods')
{
    include('includes/cls_json.php');

    $json   = new JSON;
    $res    = array('err_msg' => '', 'result' => '');
    
    $page    = (isset($_REQUEST['page'])) ? intval($_REQUEST['page']) : 1;
    if($page > 3){
        $page = 1;
    }
    $need_cache = $GLOBALS['smarty']->caching;
    $need_compile = $GLOBALS['smarty']->force_compile;
    $GLOBALS['smarty']->caching = false;
    $GLOBALS['smarty']->force_compile = true;

    $guess_goods = get_guess_goods($user_id, 1, $page, 7);
    
    $smarty->assign('guess_goods', $guess_goods);
    $smarty->assign('pager', $pager);
    
    $res['page'] = $page;
    $res['result'] = $GLOBALS['smarty']->fetch('library/guess_goods_love.lbi');

    $GLOBALS['smarty']->caching = $need_cache;
    $GLOBALS['smarty']->force_compile = $need_compile;
    
    die($json->encode($res));
}
//@author guan start
/*------------------------------------------------------ */
//-- 评论有用+1
/*------------------------------------------------------ */
elseif($_REQUEST['act'] == 'comment_reply')
{
    require_once (dirname(__FILE__) . '/includes/cls_json.php');
    $json = new JSON();
    
    $res    = array('err_msg' => '', 'content' => '', 'err_no' => 0);
    
    $id = empty($_REQUEST['id']) ? 0 : intval($_REQUEST['id']);
    $type = empty($_REQUEST['type']) ? 'comment' : $_REQUEST['type'];
    $ip     = real_ip();
    if(!empty($id))
    {
        if(!isset($_SESSION['user_id']) || $_SESSION['user_id'] == 0){
            $res['err_no'] = 1;
        }else{
            
            $useful_user = '';
            $sql = 'SELECT useful_user, useful FROM '.$ecs->table('comment')." WHERE comment_id='$id'";
            $comment = $db->getRow($sql);

            if($comment['useful_user']){
                $useful_user = explode(',', $comment['useful_user']);
                if(in_array($_SESSION['user_id'], $useful_user)){
                    $res['err_no'] = 2;
                    die($json->encode($res));
                }else{
                    array_push($useful_user, $_SESSION['user_id']);
                    $useful_user = implode(',', $useful_user);
                }
            }else{
                $useful_user = array(0);
                array_push($useful_user, $_SESSION['user_id']);
                $useful_user = implode(',', $useful_user);
            }

            $sql = 'SELECT COUNT(*) FROM '.$ecs->table('comment')." WHERE comment_id='$id'";
            $count = $db->getOne($sql);

            if($count == 1)
            {
                $sql = "UPDATE " . $ecs->table('comment') . " SET useful = useful + 1, useful_user = '$useful_user' WHERE comment_id='$id'";
                if($db->query($sql))
                {
                    $res = array('option' => 'true', 'id' => $id, 'type' => $type, 'useful' => $comment['useful'] + 1, 'err_no' => 0);
                }
                else
                {
                    $res = array('error' => '', 'id' => $id, 'type' => $type, 'err_no' => 2);
                }
            }
            else
            {
                $res = array('option' => '', 'id' => $id, 'type' => $type, 'err_no' => 2);
            }
        }    
    }
    
    die($json->encode($res));
}

/**
 * 商品评论
 */
elseif($_REQUEST['act'] == 'reply_comment')
{
	require_once (dirname(__FILE__) . '/includes/cls_json.php');
	$json = new JSON();
	$content = empty($_REQUEST['comment_content']) ? '' : htmlspecialchars($_REQUEST['comment_content']);//评论内容
	$user_name = $_SESSION['user_name'];//当前评论人名称
	$cid = empty($_REQUEST['comment_id']) ? 0 : $_REQUEST['comment_id'];//评论ID
	$sid = empty($_REQUEST['single_id']) ? 0 : $_REQUEST['single_id'];//晒单ID
	$addtime = gmtime();
	$ip     = real_ip();
	$is_ajax = empty($_REQUEST['is_ajax']) ? 0 : htmlspecialchars($_REQUEST['is_ajax']);


	if(empty($cid))
	{
		$err_msg = '此条评论可能已经被删除';
		$res = array('error' => $err_msg, 'option' => false);
		die($json->encode($res));
	}


	/* 判断用户是否登录 */
	if(empty($_SESSION['user_id']))
	{
		if($is_ajax == 1)
		{
			$res['is_user'] = '';
			die($json->encode($res));
		}
	}

	if($content == "")
	{
		$err_msg = '回复内容不能为空';
		$res = array('error' => $err_msg, 'option' => false);
		die($json->encode($res));
	}

	$com_user = $db->getRow("SELECT user_name, id_value FROM " . $ecs->table('comment') . " WHERE comment_id=" . $cid);
	if($com_user['user_name'] == $user_name)
	{
		if($is_ajax == 1)
		{
			$err_msg = '不能对自己评论';
			$res = array('error' => $err_msg, 'option' => false);
			die($json->encode($res));
		}
	}

	$sql = "INSERT INTO " . $ecs->table('comment') . "(comment_type, id_value, email, user_name, content, comment_rank, add_time, ip_address, status, parent_id, user_id, single_id)
	VALUES('0', '$com_user[id_value]', '$_SESSION[email]', '$user_name', '$content', 5, '$addtime', '$ip', '1', '$cid', '$_SESSION[user_id]', '$sid')";

	if($db->query($sql))
	{
		$res = array('error' => 0, 'option' => true);
		die($json->encode($res));
	}
	else
	{
		$res = array('error' => '评论未成功，请检查网络。', 'option' => false);
		die($json->encode($res));
	}
}

//by li start
/*------------------------------------------------------ */
//-- 商品降价通知
/*------------------------------------------------------ */
if (!empty($_REQUEST['act']) && $_REQUEST['act'] == 'price_notice')
{
    include('includes/cls_json.php');

    $json   = new JSON;
    $res    = array('msg' => '', 'status' => '');

    $goods_id = isset($_REQUEST['goods_id']) ? intval($_REQUEST['goods_id']) : 0;
    $user_id = isset($_REQUEST['user_id']) ? intval($_SESSION['user_id']) : 0;
    $email = isset($_REQUEST['email']) ? trim($_REQUEST['email']) : '';
    $cellphone = isset($_REQUEST['cellphone']) ? trim($_REQUEST['cellphone']) : '';
    $hopeDiscount = isset($_REQUEST['hopeDiscount']) ? trim($_REQUEST['hopeDiscount']) : 0;
    $add_time = gmtime();

    if ($user_id && $email) {
        $sql = "SELECT count(*) FROM " . $ecs->table('sale_notice') . " WHERE goods_id='$goods_id' AND user_id='$user_id'";
        $one = $db->getOne($sql);
        if ($one) {
            $sql = "UPDATE " . $ecs->table('sale_notice') . " SET cellphone='$cellphone',email='$email',hopeDiscount='$hopeDiscount',add_time='$add_time' WHERE goods_id='$goods_id' AND user_id='$user_id'";
            $db->query($sql);
            $res['msg'] = '更新成功！';
        } else {
            $sql = "INSERT INTO " . $ecs->table('sale_notice') . " (user_id,goods_id,cellphone,email,hopeDiscount,add_time)" .
                    " VALUES ('$user_id','$goods_id','$cellphone','$email','$hopeDiscount','$add_time')";
            $db->query($sql);
            $res['msg'] = '提交成功！';
        }
        $res['status'] = 0;
    } else {
        $res['msg'] = '提交失败，稍后在提交一次';
        $res['status'] = 1;
    }

    die($json->encode($res));
}
//by li end

/*------------------------------------------------------ */
//-- PROCESSOR
/*------------------------------------------------------ */

$area_info = get_area_info($province_id);
$goods = get_goods_info($goods_id, $region_id, $area_info['region_id']);

if($region_id == NULL){
	$region_id = 0;
}

if($area_info['region_id'] == NULL){
	$area_info['region_id'] = 0;
}

$area = array(
    'region_id' => $region_id,  //仓库ID
    'province_id' => $province_id,
    'city_id' => $city_id,
    'district_id' => $district_id,
    'goods_id' => $goods_id,
    'user_id' => $user_id,
    'area_id' => $area_info['region_id'],
    'merchant_id' => $goods['user_id'],
);

$smarty->assign('area',  $area);

$cache_id = $goods_id . '-' . $_SESSION['user_rank'].'-'.$_CFG['lang'];
$cache_id = sprintf('%X', crc32($cache_id));

$cache_id = '';
$not = 'not';
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);
    
    $promotion = get_promotion_info($goods_id, $goods['user_id']);
    $smarty->assign('promotion',       $promotion);//促销信息
      
    $promotion_info = get_promotion_info('', $goods['user_id']);
    $smarty->assign('promotion_info', $promotion_info);
	
    //ecmoban模板堂 --zhuo start 限购
    $user_id = !empty($_SESSION['user_id']) ? $_SESSION['user_id'] : 0;
    $start_date = $goods['xiangou_start_date'];
    $end_date = $goods['xiangou_end_date'];

    $nowTime = gmtime();	
    if($nowTime > $start_date && $nowTime < $end_date){
            $xiangou = 1;
    }else{
            $xiangou = 0;
    }

    $order_goods = get_for_purchasing_goods($start_date, $end_date, $goods_id, $user_id);
    $smarty->assign('xiangou',              $xiangou);
    $smarty->assign('orderG_number',              $order_goods['goods_number']);
    //ecmoban模板堂 --zhuo end 限购

    //ecmoban模板堂 --zhuo start
    $shop_info = get_merchants_shop_info('merchants_steps_fields', $goods['user_id']);
    $adress = get_license_comp_adress($shop_info['license_comp_adress']);

    $smarty->assign('shop_info',       $shop_info);
    $smarty->assign('adress',       $adress);
    //ecmoban模板堂 --zhuo end

    if ($goods === false)
    {
        /* 如果没有找到任何记录则跳回到首页 */
        ecs_header("Location: ./\n");
        exit;
    }
    else
    {
	//by wang 获得商品扩展信息
        $goods['goods_extends'] = get_goods_extends($goods_id);
        if ($goods['brand_id'] > 0) {
            $brand_act = '';
            $brand = get_goods_brand($goods['brand_id'], $goods['user_id']);
            if ($brand) {
                $goods['brand_id'] = $brand['brand_id'];
                $goods['goods_brand'] = $brand['goods_brand'];
                $brand_act = "merchants_brands";
            }

            $goods['goods_brand_url'] = build_uri('brand', array('bid' => $goods['brand_id'], 'act' => $brand_act), $goods['goods_brand']);
        }

        $shop_price   = $goods['shop_price'];
        $linked_goods = get_linked_goods($goods_id, $region_id, $area_info['region_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 rec_id FROM " .$ecs->table('collect_store'). " WHERE user_id = '$user_id' AND ru_id = '$goods[user_id]' ";//by kong 
        $rec_id = $db->getOne($sql);
        if($rec_id>0){
            $goods['error']='1';
        }else{
            $goods['error']='2';
        }
		
        //@author guan start
        if($_CFG['two_code'])
        {
            $logo = empty($_CFG['two_code_logo']) ? $goods['goods_img'] : str_replace('../', '', $_CFG['two_code_logo']);

            $size = '200x200';
            $url = $ecs->url();
            $two_code_links = trim($_CFG['two_code_links']);
            $two_code_links = empty($two_code_links) ? $url : $two_code_links;
            $data = $two_code_links . 'mobile/index.php?r=goods&id=' . $goods['goods_id'];
            $errorCorrectionLevel = 'H'; // 纠错级别：L、M、Q、H
            $matrixPointSize = 4; // 点的大小：1到10
            $filename = "images/weixin_img/weixin_code_" . $goods['goods_id'] . ".png";

            QRcode::png($data, $filename, $errorCorrectionLevel, $matrixPointSize);

            $QR = imagecreatefrompng($filename);
            //$QR = imagecreatefrompng('./chart.png');//外面那QR图
            if($logo !== FALSE)
            {
                    $logo = imagecreatefromstring(file_get_contents($logo));

                    $QR_width = imagesx($QR);
                    $QR_height = imagesy($QR);

                    $logo_width = imagesx($logo);
                    $logo_height = imagesy($logo);

                    // Scale logo to fit in the QR Code
                    $logo_qr_width = $QR_width/5;
                    $scale = $logo_width/$logo_qr_width;
                    $logo_qr_height = $logo_height/$scale;
                    $from_width = ($QR_width-$logo_qr_width)/2;
                    //echo $from_width;exit;
                    imagecopyresampled($QR, $logo, $from_width, $from_width, 0, 0, $logo_qr_width, $logo_qr_height, $logo_width, $logo_height);

            }

            imagepng($QR, $filename);
            imagedestroy($QR);
            $smarty->assign('weixin_img_url', $filename);
            $smarty->assign('weixin_img_text', trim($_CFG['two_code_mouse']));
            $smarty->assign('two_code', trim($_CFG['two_code']));
        }
        //@author guan end
		
        $smarty->assign('goods',              $goods);

        $smarty->assign('goods_name',              $goods['goods_name']);
        $smarty->assign('goods_id',           $goods['goods_id']);
        $smarty->assign('promote_end_time',   $goods['gmt_end_time']);
        
        /* 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'], array(), '', $goods['user_id']);

        /* current position */
        $smarty->assign('page_title',          $position['title']);                    // 页面标题
        $smarty->assign('ur_here',             $position['ur_here']);                  // 当前位置
        
        $categories_pro = get_category_tree_leve_one();
        $smarty->assign('categories_pro',  $categories_pro); // 分类树加强版

        $properties = get_goods_properties($goods_id, $region_id, $area_info['region_id']);  // 获得商品的规格和属性  //ecmoban模板堂 --zhuo

        $smarty->assign('top_goods',       get_top10());           // 销售排行

        $smarty->assign('best_goods',      get_recommend_goods('best', '', $region_id, $area_info['region_id'], $goods['user_id'], 1));    // 推荐商品
        $smarty->assign('new_goods',       get_recommend_goods('new', '', $region_id, $area_info['region_id'], $goods['user_id'], 1));     // 最新商品
        $smarty->assign('hot_goods',       get_recommend_goods('hot', '', $region_id, $area_info['region_id'], $goods['user_id'], 1));     // 最新商品
		
        $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('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('guess_goods',        get_guess_goods($user_id, 1, $page=1, 7));         //猜你喜欢
		
        $cat_info = cat_list(0, 0, false, 0, true, '', 0, $goods['user_id']);
        $goods_store_cat = goods_admin_store_cat_list($cat_info);
        $smarty->assign('goods_store_cat',          $goods_store_cat); 

        //by mike start
        //组合套餐名
        $comboTabIndex = get_cfg_group_goods();
        $smarty->assign('comboTab',$comboTabIndex);
        //组合套餐组
        $fittings_list = get_goods_fittings(array($goods_id), $region_id, $area_info['region_id']);
        if(is_array($fittings_list)){
            foreach($fittings_list as $vo){
                $fittings_index[$vo['group_id']] = $vo['group_id'];//关联数组
            }
        }
        ksort($fittings_index);//重新排序
        $smarty->assign('fittings_tab_index', $fittings_index);//套餐数量
        //by mike end
		
        $smarty->assign('fittings',            $fittings_list);                   // 配件

        //获取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);    // 商品优惠价格区间
        
        $discuss_list = get_discuss_all_list($goods_id, 0, 1, 10);
        $smarty->assign('discuss_list',       $discuss_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);
}

$smarty->assign('goods_id',                  $goods_id); //商品ID
$smarty->assign('region_id',                 $region_id); //商品仓库region_id 
$smarty->assign('user_id',                   $user_id);  
$smarty->assign('area_id',  $area_info['region_id']); //地区ID 

/* 更新点击次数 */
$db->query('UPDATE ' . $ecs->table('goods') . " SET click_count = click_count + 1 WHERE goods_id = '$_REQUEST[id]'");

/* 记录浏览历史 ecmoban模板堂 --zhuo start 浏览列表插件*/ 
if (!empty($_COOKIE['ECS']['list_history']))
{
    $list_history = explode(',', $_COOKIE['ECS']['list_history']);

    array_unshift($list_history, $goods_id);
    $list_history = array_unique($list_history);

    while (count($list_history) > 100000)
    {
        array_pop($list_history);
    }

    setcookie('ECS[list_history]', implode(',', $list_history), gmtime() + 3600 * 24 * 30);
}
else
{
    setcookie('ECS[list_history]', $goods_id, gmtime() + 3600 * 24 * 30);
}
/* 记录浏览历史 ecmoban模板堂 --zhuo end 浏览列表插件*/

//ecmoban模板堂 --zhuo 仓库 start
$date = array('shipping_code');
$where = "shipping_id = '" .$goods['default_shipping']. "'";
$shipping_code = get_table_date('shipping', $where, $date, 2);

$cart_num = get_goods_cart_num($goods_id, $region_id);
$smarty->assign('cart_num',  $cart_num); 

$smarty->assign('area_htmlType',  'goods'); 

//评分 start
$comment_all = get_comments_percent($goods_id);
if($goods['user_id'] > 0){
	$merchants_goods_comment = get_merchants_goods_comment($goods['user_id']); //商家所有商品评分类型汇总
        $smarty->assign('merch_cmt',  $merchants_goods_comment); 
}
//评分 end 

$smarty->assign('comment_all',  $comment_all); 

if($GLOBALS['_CFG']['customer_service'] == 0){
	$goods['user_id'] = 0;
}

$sql="select province, city, kf_type, kf_ww, kf_qq, shop_name from ".$ecs->table('seller_shopinfo')." where ru_id='" .$goods['user_id']. "'";
$basic_info = $db->getRow($sql);

$basic_date = array('region_name');
$basic_info['province'] = get_table_date('region', "region_id = '" . $basic_info['province'] . "'", $basic_date, 2);
$basic_info['city'] = get_table_date('region', "region_id= '" . $basic_info['city'] . "'", $basic_date, 2) . "市";

$smarty->assign('basic_info',  $basic_info);

$_SESSION['goods_equal'] = '';
$db->query('delete from ' . $ecs->table('cart_combo') . " WHERE (parent_id = 0 and goods_id = '$goods_id' or parent_id = '$goods_id') and " . $sess_id);

//ecmoban模板堂 --zhuo 仓库 end

if ($rank = get_rank_info())
{
    $smarty->assign('rank_name', $rank['rank_name']);
}

$smarty->assign('info',        get_user_default($_SESSION['user_id']));

$cart_info = insert_cart_info(1);

$smarty->assign('cart_info',        $cart_info);

$goods_area = 1;
if($GLOBALS['_CFG']['open_area_goods'] == 1){
    
    $area_list = get_goods_link_area_list($goods_id, $goods['user_id']);
    if($area_list['goods_area']){
        if(in_array($area_info['region_id'], $area_list['goods_area'])){
            $goods_area  = 1;
        }  else {
          $goods_area  = 0;  
        }
    } else {
        $goods_area  = 0;  
    }
}
//商品运费by wu start
$region = array(1, $province_id, $city_id, $district_id);
$shippingFee = goodsShippingFee($goods_id,$region_id,$region);
$smarty->assign('shippingFee',$shippingFee);
//商品运费by wu end

$smarty->assign('goods_area',  $goods_area); 
$GLOBALS['smarty']->assign('shop_price_type',			$goods['model_price']); //商品价格运营模式 0代表统一价格（默认） 1、代表仓库价格 2、代表地区价格
$smarty->assign('freight_model',   $GLOBALS['_CFG']['freight_model']); //ecmoban模板堂 --zhuo 运费模式
$smarty->assign('one_step_buy',   $GLOBALS['_CFG']['one_step_buy']); //ecmoban模板堂 --zhuo 一步购物
$smarty->assign('now_time',  gmtime());           // 当前系统时间

$smarty->display('goods.dwt', $cache_id, $not);

/*------------------------------------------------------ */
//-- PRIVATE FUNCTION
/*------------------------------------------------------ */

/**
 * 获得指定商品的关联商品
 *
 * @access  public
 * @param   integer     $goods_id
 * @return  array
 */
function get_linked_goods($goods_id, $warehouse_id = 0, $area_id = 0)
{
	//ecmoban模板堂 --zhuo start
        $where = '';
	$leftJoin = '';	
	
	$shop_price = "wg.warehouse_price, wg.warehouse_promote_price, wag.region_price, wag.region_promote_price, g.model_price, g.model_attr, ";
	$leftJoin .= " left join " .$GLOBALS['ecs']->table('warehouse_goods'). " as wg on g.goods_id = wg.goods_id and wg.region_id = '$warehouse_id' ";
	$leftJoin .= " left join " .$GLOBALS['ecs']->table('warehouse_area_goods'). " as wag on g.goods_id = wag.goods_id and wag.region_id = '$area_id' ";
        
        if($GLOBALS['_CFG']['open_area_goods'] == 1){
            $leftJoin .= " left join " .$GLOBALS['ecs']->table('link_area_goods'). " as lag on g.goods_id = lag.goods_id ";
            $where .= " and lag.region_id = '$area_id' ";
        }
	//ecmoban模板堂 --zhuo end	
		
    $sql = 'SELECT g.goods_id, g.goods_name, g.goods_thumb, g.goods_img, IF(g.model_price < 1, g.shop_price, IF(g.model_price < 2, wg.warehouse_price, wag.region_price)) AS org_price, ' .
                "IFNULL(mp.user_price, IF(g.model_price < 1, g.shop_price, IF(g.model_price < 2, wg.warehouse_price, wag.region_price)) * '$_SESSION[discount]') AS shop_price, ".
                'g.market_price, g.sales_volume, ' .
				'IF(g.model_price < 1, g.promote_price, IF(g.model_price < 2, wg.warehouse_promote_price, wag.region_promote_price)) as promote_price, ' . 
				' g.promote_start_date, g.promote_end_date ' .
            'FROM ' . $GLOBALS['ecs']->table('link_goods') . ' lg ' .
            'LEFT JOIN ' . $GLOBALS['ecs']->table('goods') . ' AS g ON g.goods_id = lg.link_goods_id ' .
            "LEFT JOIN " . $GLOBALS['ecs']->table('member_price') . " AS mp ".
                    "ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]' ".
			$leftJoin. 		
            "WHERE lg.goods_id = '$goods_id' AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 " .
            $where . 
            "LIMIT " . $GLOBALS['_CFG']['related_goods_number'];
    $res = $GLOBALS['db']->query($sql);

    $arr = array();
    while ($row = $GLOBALS['db']->fetchRow($res))
    {
        $arr[$row['goods_id']]['goods_id']     = $row['goods_id'];
        $arr[$row['goods_id']]['goods_name']   = $row['goods_name'];
        $arr[$row['goods_id']]['short_name']   = $GLOBALS['_CFG']['goods_name_length'] > 0 ?
            sub_str($row['goods_name'], $GLOBALS['_CFG']['goods_name_length']) : $row['goods_name'];
        $arr[$row['goods_id']]['goods_thumb']  = get_image_path($row['goods_id'], $row['goods_thumb'], true);
        $arr[$row['goods_id']]['goods_img']    = get_image_path($row['goods_id'], $row['goods_img']);
        $arr[$row['goods_id']]['market_price'] = price_format($row['market_price']);
        $arr[$row['goods_id']]['shop_price']   = price_format($row['shop_price']);
        $arr[$row['goods_id']]['url']          = build_uri('goods', array('gid'=>$row['goods_id']), $row['goods_name']);
        $arr[$row['goods_id']]['sales_volume'] = $row['sales_volume'];

        if ($row['promote_price'] > 0)
        {
            $promote_price = bargain_price($row['promote_price'], $row['promote_start_date'], $row['promote_end_date']);
        }
        else
        {
            $promote_price = 0;
        }
		
        $arr[$row['goods_id']]['promote_price']    = ($promote_price > 0) ? price_format($promote_price) : '';
    }

    return $arr;
}

/**
 * 获得指定商品的关联文章
 *
 * @access  public
 * @param   integer     $goods_id
 * @return  void
 */
function get_linked_articles($goods_id)
{
    $sql = 'SELECT a.article_id, a.title, a.file_url, a.open_type, a.add_time ' .
            'FROM ' . $GLOBALS['ecs']->table('goods_article') . ' AS g, ' .
                $GLOBALS['ecs']->table('article') . ' AS a ' .
            "WHERE g.article_id = a.article_id AND g.goods_id = '$goods_id' AND a.is_open = 1 " .
            'ORDER BY a.add_time DESC';
    $res = $GLOBALS['db']->query($sql);

    $arr = array();
    while ($row = $GLOBALS['db']->fetchRow($res))
    {
        $row['url']         = $row['open_type'] != 1 ?
            build_uri('article', array('aid'=>$row['article_id']), $row['title']) : trim($row['file_url']);
        $row['add_time']    = local_date($GLOBALS['_CFG']['date_format'], $row['add_time']);
        $row['short_title'] = $GLOBALS['_CFG']['article_title_length'] > 0 ?
            sub_str($row['title'], $GLOBALS['_CFG']['article_title_length']) : $row['title'];

        $arr[] = $row;
    }

    return $arr;
}

/**
 * 获得指定商品的各会员等级对应的价格
 *
 * @access  public
 * @param   integer     $goods_id
 * @return  array
 */
function get_user_rank_prices($goods_id, $shop_price)
{
	if(empty($shop_price)){
		$shop_price = 0;
	}
    $sql = "SELECT rank_id, IFNULL(mp.user_price, r.discount * $shop_price / 100) AS price, r.rank_name, r.discount " .
            'FROM ' . $GLOBALS['ecs']->table('user_rank') . ' AS r ' .
            'LEFT JOIN ' . $GLOBALS['ecs']->table('member_price') . " AS mp ".
                "ON mp.goods_id = '$goods_id' AND mp.user_rank = r.rank_id " .
            "WHERE r.show_price = 1 OR r.rank_id = '$_SESSION[user_rank]'" . $tag_where;
    $res = $GLOBALS['db']->query($sql);

    $arr = array();
    while ($row = $GLOBALS['db']->fetchRow($res))
    {

        $arr[$row['rank_id']] = array(
                        'rank_name' => htmlspecialchars($row['rank_name']),
                        'price'     => price_format($row['price']));
    }

    return $arr;
}

/**
 * 获得购买过该商品的人还买过的商品
 *
 * @access  public
 * @param   integer     $goods_id
 * @return  array
 */
function get_also_bought($goods_id)
{
    $sql = 'SELECT COUNT(b.goods_id ) AS num, g.goods_id, g.goods_name, g.goods_thumb, g.goods_img, g.shop_price, g.promote_price, g.promote_start_date, g.promote_end_date ' .
            'FROM ' . $GLOBALS['ecs']->table('order_goods') . ' AS a ' .
            'LEFT JOIN ' . $GLOBALS['ecs']->table('order_goods') . ' AS b ON b.order_id = a.order_id ' .
            'LEFT JOIN ' . $GLOBALS['ecs']->table('goods') . ' AS g ON g.goods_id = b.goods_id ' .
            "WHERE a.goods_id = '$goods_id' AND b.goods_id <> '$goods_id' AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 " .
            'GROUP BY b.goods_id ' .
            'ORDER BY num DESC ' .
            'LIMIT ' . $GLOBALS['_CFG']['bought_goods'];
    $res = $GLOBALS['db']->query($sql);

    $key = 0;
    $arr = array();
    while ($row = $GLOBALS['db']->fetchRow($res))
    {
        $arr[$key]['goods_id']    = $row['goods_id'];
        $arr[$key]['goods_name']  = $row['goods_name'];
        $arr[$key]['short_name']  = $GLOBALS['_CFG']['goods_name_length'] > 0 ?
            sub_str($row['goods_name'], $GLOBALS['_CFG']['goods_name_length']) : $row['goods_name'];
        $arr[$key]['goods_thumb'] = get_image_path($row['goods_id'], $row['goods_thumb'], true);
        $arr[$key]['goods_img']   = get_image_path($row['goods_id'], $row['goods_img']);        
        $arr[$key]['shop_price']  = price_format($row['shop_price']);
        $arr[$key]['url']         = build_uri('goods', array('gid'=>$row['goods_id']), $row['goods_name']);

        if ($row['promote_price'] > 0)
        {
            $arr[$key]['promote_price'] = bargain_price($row['promote_price'], $row['promote_start_date'], $row['promote_end_date']);
            $arr[$key]['formated_promote_price'] = price_format($arr[$key]['promote_price']);
        }
        else
        {
            $arr[$key]['promote_price'] = 0;
        }

        $key++;
    }

    return $arr;
}

/**
 * 获得指定商品的销售排名
 *
 * @access  public
 * @param   integer     $goods_id
 * @return  integer
 */
function get_goods_rank($goods_id)
{
    /* 统计时间段 */
    $period = intval($GLOBALS['_CFG']['top10_time']);
    if ($period == 1) // 一年
    {
        $ext = " AND o.add_time > '" . local_strtotime('-1 years') . "'";
    }
    elseif ($period == 2) // 半年
    {
        $ext = " AND o.add_time > '" . local_strtotime('-6 months') . "'";
    }
    elseif ($period == 3) // 三个月
    {
        $ext = " AND o.add_time > '" . local_strtotime('-3 months') . "'";
    }
    elseif ($period == 4) // 一个月
    {
        $ext = " AND o.add_time > '" . local_strtotime('-1 months') . "'";
    }
    else
    {
        $ext = '';
    }

    /* 查询该商品销量 */
    $sql = 'SELECT IFNULL(SUM(g.goods_number), 0) ' .
        'FROM ' . $GLOBALS['ecs']->table('order_info') . ' AS o, ' .
            $GLOBALS['ecs']->table('order_goods') . ' AS g ' .
        "WHERE o.order_id = g.order_id " .
        "AND o.order_status = '" . OS_CONFIRMED . "' " .
        "AND o.shipping_status " . db_create_in(array(SS_SHIPPED, SS_RECEIVED)) .
        " AND o.pay_status " . db_create_in(array(PS_PAYED, PS_PAYING)) .
        " AND g.goods_id = '$goods_id'" . $ext;
    $sales_count = $GLOBALS['db']->getOne($sql);

    if ($sales_count > 0)
    {
        /* 只有在商品销售量大于0时才去计算该商品的排行 */
        $sql = 'SELECT DISTINCT SUM(goods_number) AS num ' .
                'FROM ' . $GLOBALS['ecs']->table('order_info') . ' AS o, ' .
                    $GLOBALS['ecs']->table('order_goods') . ' AS g ' .
                "WHERE o.order_id = g.order_id " .
                "AND o.order_status = '" . OS_CONFIRMED . "' " .
                "AND o.shipping_status " . db_create_in(array(SS_SHIPPED, SS_RECEIVED)) .
                " AND o.pay_status " . db_create_in(array(PS_PAYED, PS_PAYING)) . $ext .
                " GROUP BY g.goods_id HAVING num > $sales_count";
        $res = $GLOBALS['db']->query($sql);

        $rank = $GLOBALS['db']->num_rows($res) + 1;

        if ($rank > 10)
        {
            $rank = 0;
        }
    }
    else
    {
        $rank = 0;
    }

    return $rank;
}

/**
 * 获得商品选定的属性的附加总价格
 *
 * @param   integer     $goods_id
 * @param   array       $attr
 *
 * @return  void
 */
function get_attr_amount($goods_id, $attr)
{
    $sql = "SELECT SUM(attr_price) FROM " . $GLOBALS['ecs']->table('goods_attr') .
        " WHERE goods_id='$goods_id' AND " . db_create_in($attr, 'goods_attr_id');

    return $GLOBALS['db']->getOne($sql);
}

/**
 * 取得跟商品关联的礼包列表
 *
 * @param   string  $goods_id    商品编号
 *
 * @return  礼包列表
 */
function get_package_goods_list($goods_id)
{
    $now = gmtime();
    $sql = "SELECT pg.goods_id, ga.act_id, ga.act_name, ga.act_desc, ga.goods_name, ga.start_time,
                   ga.end_time, ga.is_finished, ga.ext_info
            FROM " . $GLOBALS['ecs']->table('goods_activity') . " AS ga, " . $GLOBALS['ecs']->table('package_goods') . " AS pg
            WHERE pg.package_id = ga.act_id
            AND ga.start_time <= '" . $now . "'
            AND ga.end_time >= '" . $now . "'
            AND pg.goods_id = " . $goods_id . "
            GROUP BY ga.act_id
            ORDER BY ga.act_id ";
    $res = $GLOBALS['db']->getAll($sql);

    foreach ($res as $tempkey => $value)
    {
        $subtotal = 0;
        $row = unserialize($value['ext_info']);
        unset($value['ext_info']);
        if ($row)
        {
            foreach ($row as $key=>$val)
            {
                $res[$tempkey][$key] = $val;
            }
        }

        $sql = "SELECT pg.package_id, pg.goods_id, pg.goods_number, pg.admin_id, p.goods_attr, g.goods_sn, g.goods_name, g.market_price, g.goods_thumb, IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS rank_price
                FROM " . $GLOBALS['ecs']->table('package_goods') . " AS pg
                    LEFT JOIN ". $GLOBALS['ecs']->table('goods') . " AS g
                        ON g.goods_id = pg.goods_id
                    LEFT JOIN ". $GLOBALS['ecs']->table('products') . " AS p
                        ON p.product_id = pg.product_id
                    LEFT JOIN " . $GLOBALS['ecs']->table('member_price') . " AS mp
                        ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]'
                WHERE pg.package_id = " . $value['act_id']. "
                ORDER BY pg.package_id, pg.goods_id";

        $goods_res = $GLOBALS['db']->getAll($sql);

        foreach($goods_res as $key => $val)
        {
            $goods_id_array[] = $val['goods_id'];
            $goods_res[$key]['goods_thumb']  = get_image_path($val['goods_id'], $val['goods_thumb'], true);
            $goods_res[$key]['market_price'] = price_format($val['market_price']);
            $goods_res[$key]['rank_price']   = price_format($val['rank_price']);
            $subtotal += $val['rank_price'] * $val['goods_number'];
        }

        /* 取商品属性 */
        $sql = "SELECT ga.goods_attr_id, ga.attr_value
                FROM " .$GLOBALS['ecs']->table('goods_attr'). " AS ga, " .$GLOBALS['ecs']->table('attribute'). " AS a
                WHERE a.attr_id = ga.attr_id
                AND a.attr_type = 1
                AND " . db_create_in($goods_id_array, 'goods_id');
        $result_goods_attr = $GLOBALS['db']->getAll($sql);

        $_goods_attr = array();
        foreach ($result_goods_attr as $value)
        {
            $_goods_attr[$value['goods_attr_id']] = $value['attr_value'];
        }

        /* 处理货品 */
        $format = '[%s]';
        foreach($goods_res as $key => $val)
        {
            if ($val['goods_attr'] != '')
            {
                $goods_attr_array = explode('|', $val['goods_attr']);

                $goods_attr = array();
                foreach ($goods_attr_array as $_attr)
                {
                    $goods_attr[] = $_goods_attr[$_attr];
                }

                $goods_res[$key]['goods_attr_str'] = sprintf($format, implode('，', $goods_attr));
            }
        }

        $res[$tempkey]['goods_list']    = $goods_res;
        $res[$tempkey]['subtotal']      = price_format($subtotal);
        $res[$tempkey]['saving']        = price_format(($subtotal - $res[$tempkey]['package_price']));
        $res[$tempkey]['package_price'] = price_format($res[$tempkey]['package_price']);
    }

    return $res;
}
?>