<?php

/**
 * ECSHOP 夺宝奇兵前台页面
 * ============================================================================
 * * 版权所有 2005-2016 上海商创网络科技有限公司，并保留所有权利。
 * 网站地址: http://www.ecmoban.com；
 * ----------------------------------------------------------------------------
 * 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
 * 使用；不允许对程序代码以任何形式任何目的的再发布。
 * ============================================================================
 * $Author: liubo $
 * $Id: snatch.php 17217 2011-01-19 06:29:08Z liubo $
*/

define('IN_ECS', true);

require(dirname(__FILE__) . '/includes/init.php');

require(ROOT_PATH . '/includes/lib_area.php');  //ecmoban模板堂 --zhuo

//ecmoban模板堂 --zhuo start
$area_info = get_area_info($province_id);
$area_id = $area_info['region_id'];

$where = "regionId = '$province_id'";
$date = array('parent_id');
$region_id = get_table_date('region_warehouse', $where, $date, 2);

if(isset($_COOKIE['region_id']) && !empty($_COOKIE['region_id'])){
    $region_id = $_COOKIE['region_id'];
}
//ecmoban模板堂 --zhuo end
$smarty->assign('now_time',  gmtime());           // 当前系统时间

/*------------------------------------------------------ */
//-- 如果用没有指定活动id，将页面重定向到即将结束的活动
/*------------------------------------------------------ */

$id = isset($_REQUEST['id']) ? intval($_REQUEST['id']) : 0;
if (!isset($_REQUEST['act']) && !isset($_REQUEST['id']))
{
    $_REQUEST['act'] = 'list';
}elseif($id > 0 && !isset($_REQUEST['act'])){
    $_REQUEST['act'] = 'main';
}

if($_REQUEST['act'] == 'list'){
    
     /* 初始化分页信息 */
    $page         = isset($_REQUEST['page'])   && intval($_REQUEST['page'])  > 0 ? intval($_REQUEST['page'])  : 1;  // 取得当前页
    $size         = isset($_CFG['page_size'])  && intval($_CFG['page_size']) > 0 ? intval($_CFG['page_size']) : 10; // 取得每页记录数
    $size = 15;
    $keywords   = !empty($_REQUEST['keywords'])   ? htmlspecialchars(trim($_REQUEST['keywords'])):'';

    $default_sort_order_method = $_CFG['sort_order_method'] == '0' ? 'DESC' : 'ASC';
    $default_sort_order_type = "snatch_id";
    $sort = (isset($_REQUEST['sort'])  && in_array(trim(strtolower($_REQUEST['sort'])), array('snatch_id', 'end_time', 'start_time'))) ? trim($_REQUEST['sort'])  : $default_sort_order_type;
    $order = (isset($_REQUEST['order']) && in_array(trim(strtoupper($_REQUEST['order'])), array('ASC', 'DESC'))) ? trim($_REQUEST['order']) : $default_sort_order_method;
    
    assign_template();
    assign_dynamic('snatch');
    $position = assign_ur_here();
    $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); // 分类树加强版
        
    $smarty->assign('helps',       get_shop_help());       // 网店帮助
    $smarty->assign('feed_url',         ($_CFG['rewrite'] == 1) ? "feed-typesnatch.xml" : 'feed.php?type=snatch'); // RSS URL
    
    $snatch_list = get_snatch_list($keywords, $size, $page, $sort, $order, $region_id, $area_id);
    $smarty->assign('snatch_list', $snatch_list);     //所有有效的夺宝奇兵列表
    
    $count = get_snatch_count($keywords);
    /* 设置分页链接 */
    $pager = get_pager('snatch.php', array('act' => 'list', 'keywords' => $keywords, 'sort' => $sort, 'order' => $order), $count, $page, $size);
    $smarty->assign('pager', $pager);
    
    $smarty->assign('hot_goods',       get_exchange_recommend_goods('hot', $region_id, $area_id));  //热门
            
    $smarty->display('snatch_list.dwt');
    exit;
    
}
/* 显示页面部分 */
elseif ($_REQUEST['act'] == 'main')
{
    $goods = get_snatch($id);
    if ($goods)
    {
        $position = assign_ur_here(0,$goods['snatch_name']);
        $myprice = get_myprice($id);
        if ($goods['is_end'])
        {
            //如果活动已经结束,获取活动结果
            $smarty->assign('result',  get_snatch_result($id));
        }
        
        $smarty->assign('id',          $id);
        $smarty->assign('snatch_goods',       $goods); // 竞价商品
        $smarty->assign('goods',       $goods); // 竞价商品
        $smarty->assign('myprice',     $myprice);
        if ($goods['product_id'] > 0)
        {
            $goods_specifications = get_specifications_list($goods['goods_id']);

            $good_products = get_good_products($goods['goods_id'], 'AND product_id = ' . $goods['product_id']);

            $_good_products = explode('|', $good_products[0]['goods_attr']);
            $products_info = '';
            foreach ($_good_products as $value)
            {
                $products_info .= ' ' . $goods_specifications[$value]['attr_name'] . '：' . $goods_specifications[$value]['attr_value'];
            }
            $smarty->assign('products_info',     $products_info);
            unset($goods_specifications, $good_products, $_good_products,  $products_info);
        }
    }
    else
    {
        show_message($_LANG['now_not_snatch']);
    }

    /* 调查 */
    $vote = get_vote();
    if (!empty($vote))
    {
        $smarty->assign('vote_id', $vote['id']);
        $smarty->assign('vote',    $vote['content']);
    }

    assign_template();
    assign_dynamic('snatch');
    $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); // 分类树加强版
    $smarty->assign('helps',       get_shop_help());       // 网店帮助
    $smarty->assign('price_list',  get_price_list($id));
    $smarty->assign('price_list_count',  count(get_price_list($id)));
    $smarty->assign('promotion_info', get_promotion_info());
    $smarty->assign('feed_url',         ($_CFG['rewrite'] == 1) ? "feed-typesnatch.xml" : 'feed.php?type=snatch'); // RSS URL
    
    $smarty->assign('pictures',            get_goods_gallery($goods['goods_id']));                    // 商品相册
    
    //评分 start
    $mc_all = ments_count_all($goods['goods_id']);       //总条数
    $mc_one = ments_count_rank_num($goods['goods_id'],1);		//一颗星
    $mc_two = ments_count_rank_num($goods['goods_id'],2);	    //两颗星	
    $mc_three = ments_count_rank_num($goods['goods_id'],3);   	//三颗星
    $mc_four = ments_count_rank_num($goods['goods_id'],4);		//四颗星
    $mc_five = ments_count_rank_num($goods['goods_id'],5);		//五颗星
    $comment_all = get_conments_stars($mc_all,$mc_one,$mc_two,$mc_three,$mc_four,$mc_five);

    if($goods['user_id'] > 0){
            $merchants_goods_comment = get_merchants_goods_comment($goods['user_id']); //商家所有商品评分类型汇总
    }
    //评分 end 

    $smarty->assign('comment_all',  $comment_all); 
    $smarty->assign('merch_cmt',  $merchants_goods_comment);
    
    $basic_date = array('region_name');
    $basic_info['province'] = get_table_date('region', "region_id = '" . $goods['province'] . "'", $basic_date, 2);
    $basic_info['city'] = get_table_date('region', "region_id= '" . $goods['city'] . "'", $basic_date, 2) . "市";
    $basic_info['kf_type'] = $goods['kf_type'];
    $basic_info['[kf_ww'] = $goods['kf_ww'];
    $basic_info['kf_qq'] = $goods['kf_qq'];
    $basic_info['shop_name'] = $goods['shop_name'];
      
    $smarty->assign('basic_info',  $basic_info);
    $smarty->assign('hot_goods',       get_exchange_recommend_goods('hot', $region_id, $area_id));  //热门
    
    
    
    $smarty->display('snatch.dwt');

    exit;
}

/* 最新出价列表 */
if ($_REQUEST['act'] == 'new_price_list')
{
    $id = $_GET['id'];
    $smarty->assign('myprice',  get_myprice($id));
    $smarty->display('library/snatch_price.lbi');

    exit;
}

/* 用户出价处理 */
if ($_REQUEST['act'] == 'bid')
{
    include_once(ROOT_PATH .'includes/cls_json.php');
    $json = new JSON();
    $result = array('error'=>0, 'content'=>'');

    $price = isset($_POST['price']) ? floatval($_POST['price']) : 0;
    $price = round($price, 2);

    /* 测试是否登陆 */
    if (empty($_SESSION['user_id']))
    {
        $result['error'] = 1;
        $result['prompt'] = 1;
        $result['content'] = $_LANG['not_login'];
        $result['back_url'] = "snatch.php?id=".$id;
        die($json->encode($result));
    }

    /* 获取活动基本信息用于校验 */
    $sql = 'SELECT act_name AS snatch_name, end_time, ext_info FROM ' . $GLOBALS['ecs']->table('goods_activity') . " WHERE act_id ='$id'";
    $row = $db->getRow($sql, 'SILENT');

    if ($row)
    {
        $info = unserialize($row['ext_info']);
        if ($info)
        {
            foreach ($info as $key => $val)
            {
                $row[$key] = $val;
            }
        }
    }

    if (empty($row))
    {
        $result['error'] = 1;
        $result['content'] = $db->error();
        die($json->encode($result));
    }

    if ($row['end_time']< gmtime() )
    {
        $result['error'] = 1;
        $result['content'] = $_LANG['snatch_is_end'];
        die($json->encode($result));
    }

    /* 检查出价是否合理 */
    if ($price < $row['start_price'] || $price > $row['end_price'])
    {
        $result['error'] = 1;
        
        $result['content'] = sprintf($GLOBALS['_LANG']['not_in_range'],$row['start_price'], $row['end_price']);
        die($json->encode($result));
    }

    /* 检查用户是否已经出同一价格 */
    $sql = 'SELECT COUNT(*) FROM '.$GLOBALS['ecs']->table('snatch_log'). " WHERE snatch_id = '$id' AND user_id = '$_SESSION[user_id]' AND bid_price = '$price'";
    if ($GLOBALS['db']->getOne($sql) > 0)
    {
        $result['error'] = 1;
//        $result['content'] = sprintf($GLOBALS['_LANG']['also_bid'], price_format($price, false));
        $result['content'] = sprintf($GLOBALS['_LANG']['also_bid'], '￥'.$price);
        die($json->encode($result));
    }

    /* 检查用户积分是否足够 */
    $sql = 'SELECT pay_points FROM ' .$ecs->table('users'). " WHERE user_id = '" . $_SESSION['user_id']. "'";
    $pay_points = $db->getOne($sql);
    if ($row['cost_points'] > $pay_points)
    {
        $result['error'] = 1;
        $result['content'] = $_LANG['lack_pay_points'];
        die($json->encode($result));
    }

    log_account_change($_SESSION['user_id'], 0, 0, 0, 0-$row['cost_points'],sprintf($_LANG['snatch_log'], $row['snatch_name'])); //扣除用户积分
    $sql = 'INSERT INTO ' .$ecs->table('snatch_log'). '(snatch_id, user_id, bid_price, bid_time) VALUES'.
           "('$id', '" .$_SESSION['user_id']. "', '" .$price."', " .gmtime(). ")";
    $db->query($sql);
    
    $goods = get_snatch($id);
    $smarty->assign('snatch_goods',       $goods); // 竞价商品
    
    if ($goods['is_end'])
    {
        //如果活动已经结束,获取活动结果
        $smarty->assign('result',  get_snatch_result($id));
    }
    
    // 
    $smarty->assign('price_list',  get_price_list($id));
    $smarty->assign('price_list_count',  count(get_price_list($id)));
    
    $smarty->assign('myprice',  get_myprice($id));
    $smarty->assign('id',       $id);
    $result['content'] = $smarty->fetch('library/snatch.lbi');
    $result['id'] = $id;
    die($json->encode($result));
}

/*------------------------------------------------------ */
//-- 购买商品
/*------------------------------------------------------ */
if ($_REQUEST['act'] == 'buy')
{
    if (empty($id))
    {
        ecs_header("Location: ./\n");
        exit;
    }

    if (empty($_SESSION['user_id']))
    {
        show_message($_LANG['not_login']);
    }

    $snatch = get_snatch($id);


    if (empty($snatch))
    {
        ecs_header("Location: ./\n");
        exit;
    }

    /* 未结束，不能购买 */
    if (empty($snatch['is_end']))
    {
        $page = build_uri('snatch', array('sid'=>$id));
        ecs_header("Location: $page\n");
        exit;
    }

    $result = get_snatch_result($id);

    if ($_SESSION['user_id'] != $result['user_id'])
    {
        show_message($_LANG['not_for_you']);
    }

    //检查是否已经购买过
    if ($result['order_count'] > 0)
    {
        show_message($_LANG['order_placed']);
    }

    /* 处理规格属性 */
    $goods_attr = '';
    $goods_attr_id = '';
    if ($snatch['product_id'] > 0)
    {
        $product_info = get_good_products($snatch['goods_id'], 'AND product_id = ' . $snatch['product_id']);

        $goods_attr_id = str_replace('|', ',', $product_info[0]['goods_attr']);

        $attr_list = array();
        $sql = "SELECT a.attr_name, g.attr_value " .
                "FROM " . $ecs->table('goods_attr') . " AS g, " .
                    $ecs->table('attribute') . " AS a " .
                "WHERE g.attr_id = a.attr_id " .
                "AND g.goods_attr_id " . db_create_in($goods_attr_id);
        $res = $db->query($sql);
        while ($row = $db->fetchRow($res))
        {
            $attr_list[] = $row['attr_name'] . ': ' . $row['attr_value'];
        }
        $goods_attr = join('', $attr_list);
    }
    else
    {
        $snatch['product_id'] = 0;
    }

    /* 清空购物车中所有商品 */
    include_once(ROOT_PATH . 'includes/lib_order.php');
    clear_cart(CART_SNATCH_GOODS);
	
	//ecmoban模板堂 --zhuo start
	if(!empty($_SESSION['user_id'])){
		$sess = "";
	}else{
		$sess = real_cart_mac_ip();
	}
	//ecmoban模板堂 --zhuo end

    /* 加入购物车 */
    $cart = array(
        'user_id'        => $_SESSION['user_id'],
        'session_id'     => $sess,
        'goods_id'       => $snatch['goods_id'],
        'product_id'     => $snatch['product_id'],
        'goods_sn'       => addslashes($snatch['goods_sn']),
        'goods_name'     => addslashes($snatch['goods_name']),
        'market_price'   => $snatch['market_price'],
        'goods_price'    => $result['buy_price'],
        'goods_number'   => 1,
        'goods_attr'     => $goods_attr,
        'goods_attr_id'  => $goods_attr_id,
        'warehouse_id'   => $region_id, //ecmoban模板堂 --zhuo 仓库
        'area_id'        => $area_id, //ecmoban模板堂 --zhuo 仓库地区
        'is_real'        => $snatch['is_real'],
        'ru_id'          => $snatch['user_id'],
        'extension_code' => addslashes($snatch['extension_code']),
        'parent_id'      => 0,
        'rec_type'       => CART_SNATCH_GOODS,
        'is_gift'        => 0
    );

    $db->autoExecute($ecs->table('cart'), $cart, 'INSERT');

    /* 记录购物流程类型：夺宝奇兵 */
    $_SESSION['flow_type'] = CART_SNATCH_GOODS;
    $_SESSION['extension_code'] = 'snatch';
    $_SESSION['extension_id'] = $id;
    $_SESSION['direct_shopping'] = 3;

    /* 进入收货人页面 */
    ecs_header("Location: ./flow.php?step=checkout&direct_shopping=3\n");
    exit;

}

/**
 * 取得用户对当前活动的所出过的价格
 *
 * @access  public
 * @param
 *
 * @return void
 */
function get_myprice($id)
{
    $my_only_price  = array();
    $my_price_time       = array();
    $pay_points     = 0;
    $bid_price      = array();
    if (!empty($_SESSION['user_id']))
    {
        /* 取得用户所有价格 */
        $sql = 'SELECT bid_price, bid_time FROM '.$GLOBALS['ecs']->table('snatch_log'). " WHERE snatch_id = '$id' AND user_id = '$_SESSION[user_id]' ORDER BY bid_time DESC";
        $my_price_time = $GLOBALS['db']->GetAll($sql);
//        print_arr($my_price_time);
        
        $sql = 'SELECT bid_price FROM '.$GLOBALS['ecs']->table('snatch_log'). " WHERE snatch_id = '$id' AND user_id = '$_SESSION[user_id]' ORDER BY bid_time DESC";
        $my_price = $GLOBALS['db']->GetCol($sql);
        if ($my_price_time)
        {
            /* 取得用户唯一价格 */
            $sql = 'SELECT bid_price , count(*) AS num FROM '.$GLOBALS['ecs']->table('snatch_log'). "  WHERE snatch_id ='$id' AND bid_price " . db_create_in(join(',', $my_price)). ' GROUP BY bid_price HAVING num = 1';
            $my_only_price = $GLOBALS['db']->GetCol($sql);
        }
//        print_arr($my_only_price);
        $user_name = $GLOBALS['db']->getOne("SELECT user_name FROM " . $GLOBALS['ecs']->table('users'). " WHERE user_id = '$_SESSION[user_id]' ");
        for ($i = 0, $count = count($my_price_time); $i < $count; $i++)
        {
            $bid_price[] = array(
                                'price' => price_format($my_price_time[$i]['bid_price'], false),
                                'user_name' => $user_name,
                                'bid_date' => local_date('Y-m-d H:i:s',$my_price_time[$i]['bid_time']),
                                 'is_only' => in_array($my_price_time[$i]['bid_price'],$my_only_price)
                                );
        }

        $sql = 'SELECT pay_points FROM '. $GLOBALS['ecs']->table('users')." WHERE user_id = '$_SESSION[user_id]'";
        $pay_points = $GLOBALS['db']->GetOne($sql);
        $pay_points = $pay_points.$GLOBALS['_CFG']['integral_name'];
    }

    /* 活动结束时间 */
    $sql = 'SELECT end_time FROM ' .$GLOBALS['ecs']->table('goods_activity').
           " WHERE act_id = '$id' AND act_type=" . GAT_SNATCH;
    $end_time = $GLOBALS['db']->getOne($sql);
    $my_price_time = array(
        'pay_points'    => $pay_points,
        'bid_price'     => $bid_price,
        'bid_price_count'     => count($bid_price),
        'is_end'        => gmtime() > $end_time
        );
//        print_arr($my_price_time);
    return $my_price_time;
}

/**
 * 取得当前活动的前n个出价
 *
 * @access  public
 * @param   int  $num  列表个数(取前5个)
 *
 * @return void
 */
function get_price_list($id)
{
    $sql = 'SELECT t1.log_id, t1.bid_price, t1.bid_time, t2.user_name FROM '.$GLOBALS['ecs']->table('snatch_log').' AS t1, '.$GLOBALS['ecs']->table('users')." AS t2 "
            . "WHERE snatch_id = '$id' AND t1.user_id = t2.user_id ORDER BY t1.log_id DESC";
    $res = $GLOBALS['db']->query($sql);
    
    $price_list = array();
    while ($row = $GLOBALS['db']->FetchRow($res))
    {
		$row['user_name']=setAnonymous($row['user_name']); //处理用户名 by wu
        $price_list[] = array('bid_price'=>price_format($row['bid_price'], false),'user_name'=>$row['user_name'], 'bid_date' => local_date("Y-m-d H:i",$row['bid_time']));
    }
    return $price_list;
}

/**
 * 取的最近的几次活动。
 *
 * @access  public
 * @param
 *
 * @return void
 */
function get_snatch_list($keywords = '', $size, $page, $sort, $order, $warehouse_id, $area_id)
{
    $where = '';
    $leftJoin = '';
    $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 ($keywords)
    {
        $where = " AND (ga.act_name LIKE '%$keywords%' OR g.goods_name LIKE '%$keywords%') ";
    }
    
    $now = gmtime();
    $sql = "SELECT ga.act_id AS snatch_id, ga.act_name AS snatch_name, ga.end_time, ga.start_time, ga.ext_info, IFNULL(g.goods_thumb, '') AS goods_thumb, g.market_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, " .
            "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('goods_activity') . " AS ga " .
           "LEFT JOIN " . $GLOBALS['ecs']->table('goods') . " AS g ON ga.goods_id = g.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 ga.start_time <= '$now' AND ga.act_type=" . GAT_SNATCH . $where . 
           "  ORDER BY $sort $order";
    
    $snatch_list = array();
    $overtime = 0;
    
    $res = $GLOBALS['db']->selectLimit($sql, $size, ($page - 1) * $size);
    while ($row = $GLOBALS['db']->FetchRow($res))
    {
        $overtime = $row['end_time'] > $now ? 0 : 1;
        
        $ext_info = unserialize($row['ext_info']);
        $snatch = array_merge($row, $ext_info);
        $row['start_time'] = local_date($GLOBALS['_CFG']['time_format'], $row['start_time']);
        $row['end_time']   = local_date($GLOBALS['_CFG']['time_format'], $row['end_time']);
        
        $promote_price          = bargain_price($row['promote_price'], $row['promote_start_date'], $row['promote_end_date']);
        $shop_price = ($promote_price > 0) ? $promote_price : $row['shop_price'];
        
        $snatch['max_price'] = price_format($snatch['max_price']);
        $snatch['end_time_date'] = local_date("Y-m-d H:i:s", $snatch['end_time']);
        
        $snatch_list[] = array(
            'snatch_id' => $row['snatch_id'],
            'snatch_name' => $row['snatch_name'],
            'snatch' => $snatch,
            'start_time' => $row['start_time'],
            'max_price' => price_format($snatch['max_price']), //
            'end_time' => $row['end_time'],
            'current_time' => local_date('Y-m-d H:i:s', gmtime()),
            'overtime' => $overtime,
            'formated_market_price'  => price_format($row['market_price']),
            'formated_shop_price'    => price_format($shop_price),
            'goods_thumb' => get_image_path($row['goods_id'], $row['goods_thumb'], true),
            'price_list_count' => count(get_price_list($row['snatch_id'])), // 围观次数
            'url'=>build_uri('snatch', array('sid'=>$row['snatch_id']))
        );
    }
    
    return $snatch_list;

}

function get_snatch_count($keywords = ''){
    
    $where = '';
            
    if ($keywords)
    {
        $where = " AND (ga.act_name LIKE '%$keywords%' OR g.goods_name LIKE '%$keywords%') ";
    }
    
    $now = gmtime();
    $sql = 'SELECT count(*) '.
           ' FROM ' . $GLOBALS['ecs']->table('goods_activity') ." AS ga ".
            "LEFT JOIN " . $GLOBALS['ecs']->table('goods') . " AS g ON ga.goods_id = g.goods_id " .
           " WHERE start_time <= '$now' AND act_type=" . GAT_SNATCH . $where;
    
    return $GLOBALS['db']->getOne($sql);
}

/**
 * 取得当前活动信息
 *
 * @access  public
 *
 * @return 活动名称
 */
function get_snatch($id)
{
    $sql = "SELECT g.goods_id, ga.act_ensure,  g.goods_sn, g.is_real, g.goods_name, g.extension_code, g.market_price, g.shop_price AS org_price, product_id, " .
            "g.goods_img, g.user_id," .
                    "IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS shop_price, " .
                    "g.promote_price, g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb, " .
                    "ga.act_name AS snatch_name, ga.start_time, ga.end_time, ga.ext_info, ga.act_desc AS `desc`, ga.act_promise,  ga.act_ensure ".
                "FROM " .$GLOBALS['ecs']->table('goods_activity'). " AS ga " .
                "LEFT JOIN " . $GLOBALS['ecs']->table('goods')." AS g " .
                    "ON g.goods_id = ga.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]' " .
                "WHERE ga.act_id = '$id' AND g.is_delete = 0";

    $goods = $GLOBALS['db']->GetRow($sql);

    if ($goods)
    {
        $promote_price          = bargain_price($goods['promote_price'], $goods['promote_start_date'], $goods['promote_end_date']);
        $goods['formated_market_price']  = price_format($goods['market_price']);
        $goods['formated_shop_price']    = price_format($goods['shop_price']);
        $goods['formated_promote_price'] = ($promote_price > 0) ? price_format($promote_price) : '';
        $goods['goods_thumb']   = get_image_path($goods['goods_id'], $goods['goods_thumb'], true);
        $goods['goods_img']   = get_image_path($goods['goods_id'], $goods['goods_img'], true);
        $goods['url']           = build_uri('goods', array('gid'=>$goods['goods_id']), $goods['goods_name']);
        $goods['start_time']    = local_date($GLOBALS['_CFG']['time_format'], $goods['start_time']);

        $info = unserialize($goods['ext_info']);
        if ($info)
        {
            foreach ($info as $key => $val)
            {
                $goods[$key] = $val;
            }
            $goods['is_end'] = gmtime() > $goods['end_time'];
            $goods['formated_start_price'] = price_format($goods['start_price']);
            $goods['formated_end_price'] = price_format($goods['end_price']);
            $goods['formated_max_price'] = price_format($goods['max_price']);
        }
        /* 将结束日期格式化为格林威治标准时间时间戳 */
        $goods['gmt_end_time']  = local_date("Y-m-d H:i:s", $goods['end_time']);
        $goods['end_time']      = local_date($GLOBALS['_CFG']['time_format'], $goods['end_time']);
        $goods['snatch_time']   = sprintf($GLOBALS['_LANG']['snatch_start_time'], $goods['start_time'], $goods['end_time']);
        
        //ecmoban模板堂 --zhuo
        $goods['rz_shopName'] = get_shop_name($goods['user_id'], 1); //店铺名称	
        
        $goods['shopinfo'] = get_shop_name($goods['user_id'], 2);

        $goods['shopinfo']['brand_thumb'] = str_replace(array('../'), '', $goods['shopinfo']['brand_thumb']);
        
        $goods['store_url'] = build_uri('merchants_store', array('urid'=>$goods['user_id']), $goods['rz_shopName']);
        $basic_info = get_seller_shopinfo($goods['user_id']);
        
        $goods['province'] = $basic_info['province'];
        $goods['city'] = $basic_info['city'];
        $goods['kf_type'] = $basic_info['kf_type'];
        $goods['[kf_ww'] = $basic_info['kf_ww'];
        $goods['kf_qq'] = $basic_info['kf_qq'];
        $goods['shop_name'] = $basic_info['shop_name'];
        $goods['org_price_int'] = intval($goods['org_price']);
//        print_arr($goods);
        return $goods;
    }
    else
    {
        return false;
    }
}

/**
 * 获取最近要到期的活动id，没有则返回 0
 *
 * @access  public
 * @param
 *
 * @return void
 */
function get_last_snatch()
{
    $now = gmtime();
    $sql = 'SELECT act_id FROM ' . $GLOBALS['ecs']->table('goods_activity').
           " WHERE  start_time < '$now' AND end_time > '$now' AND act_type = " . GAT_SNATCH .
           " ORDER BY end_time ASC LIMIT 1";
    return $GLOBALS['db']->GetOne($sql);
}

/**
 * 获得指定分类下的推荐商品
 *
 * @access  public
 * @param   string      $type       推荐类型，可以是 best, new, hot, promote
 * @param   string      $cats       分类的ID
 * @param   integer     $min        商品积分下限
 * @param   integer     $max        商品积分上限
 * @param   string      $ext        商品扩展查询
 * @return  array
 */
function get_exchange_recommend_goods($type = '', $warehouse_id, $area_id)
{
    $leftJoin = '';
    $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' ";
    
    $now = gmtime();
    $sql =  'SELECT g.goods_id, g.goods_name, g.goods_name_style, g.market_price, ' .
            'g.goods_brief, g.goods_thumb, goods_img, b.brand_name, ' .
            
            "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, " .
            "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," .
            
            'ga.act_name, ga.act_id, ga.ext_info, ga.start_time, ga.start_time, ga.end_time '.
            
            'FROM ' . $GLOBALS['ecs']->table('goods_activity') . ' AS ga ' .
            'LEFT JOIN ' . $GLOBALS['ecs']->table('goods') . ' AS g ON g.goods_id = ga.goods_id ' .
            'LEFT JOIN ' . $GLOBALS['ecs']->table('brand') . ' AS b ON b.brand_id = g.brand_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 ga.act_type = '" . GAT_SNATCH . "' " .
            "AND ga.start_time <= '$now' AND ga.end_time >= '$now' AND ga.is_finished < 2 ";
    
    $num = 11;
    switch ($type)
    {
        case 'best':
            $sql .= ' AND ga.is_best = 1';
            break;
        case 'new':
            $sql .= ' AND ga.is_new = 1';
            break;
        case 'hot':
            $sql .= ' AND ga.is_hot = 1';
            break;
    }

    $sql .= ($order_type == 0) ? ' ORDER BY g.sort_order, g.last_update DESC' : ' ORDER BY RAND()';
    
    $res = $GLOBALS['db']->selectLimit($sql, $num);

    $idx = 0;
    $snatch = array();
    while ($row = $GLOBALS['db']->fetchRow($res))
    {
        $snatch[$idx]['id']                = $row['goods_id'];
        $snatch[$idx]['name']              = $row['goods_name'];
        $snatch[$idx]['brief']             = $row['goods_brief'];
        $snatch[$idx]['brand_name']        = $row['brand_name'];
        $snatch[$idx]['short_name']        = $GLOBALS['_CFG']['goods_name_length'] > 0 ?
                                                sub_str($row['goods_name'], $GLOBALS['_CFG']['goods_name_length']) : $row['goods_name'];
        $snatch[$idx]['exchange_integral'] = $row['exchange_integral'];
        $snatch[$idx]['thumb']             = get_image_path($row['goods_id'], $row['goods_thumb'], true);
        $snatch[$idx]['goods_img']         = get_image_path($row['goods_id'], $row['goods_img']);
        $snatch[$idx]['url']               = build_uri('snatch', array('sid'=>$row['act_id']));
        
        $promote_price          = bargain_price($row['promote_price'], $row['promote_start_date'], $row['promote_end_date']);
        $snatch[$idx]['formated_shop_price']    = price_format($row['shop_price']);
        $snatch[$idx]['formated_shop_price'] = ($promote_price > 0) ? price_format($promote_price) : $snatch[$idx]['formated_shop_price'];
        $snatch[$idx]['formated_market_price'] = price_format($row['market_price']);
        
        $ext_info = unserialize($row['ext_info']);
        $snatch_info = array_merge($row, $ext_info);
        $snatch[$idx]['auction'] = $snatch_info;
        $snatch[$idx]['status_no'] = auction_status($snatch_info);
        $snatch[$idx]['count'] = snatch_log($row['act_id']);
 
        $snatch[$idx]['short_style_name']  = add_style($snatch[$idx]['short_name'], $row['goods_name_style']);
        $idx++;
    }

    return $snatch;
}

?>