master

分支 (1)

管理

管理

master

HongYuDSC
/
presale.php

<?php
//QQ:1527200768  鸿宇科技  禁止倒卖 一经发现停止任何服务
function get_pre_goods($cat_id, $min = 0, $max = 0, $start_time = 0, $end_time = 0, $sort, $status = 0, $order)
{
	$now = gmtime();
	$where = '';

	if (0 < $cat_id) {
		$where = 'AND a.cat_id = \'' . $cat_id . '\' ';
	}

	if ($status == 1) {
		$where .= ' AND a.start_time > ' . $now . ' ';
	}
	else if ($status == 2) {
		$where .= ' AND a.start_time < ' . $now . ' AND ' . $now . ' < a.end_time ';
	}
	else if ($status == 3) {
		$where .= ' AND ' . $now . ' > a.end_time ';
	}

	if ($sort == 'shop_price') {
		$sort = 'g.' . $sort;
	}
	else {
		$sort = 'a.' . $sort;
	}

	$sql = 'SELECT a.*, g.goods_thumb, g.goods_img, g.goods_name, g.shop_price, g.market_price, g.sales_volume FROM ' . $GLOBALS['ecs']->table('presale_activity') . ' AS a ' . ' LEFT JOIN ' . $GLOBALS['ecs']->table('goods') . ' AS g ON a.goods_id = g.goods_id ' . (' WHERE g.goods_id > 0 ' . $where . ' AND g.is_on_sale = 0 AND a.review_status = 3 ORDER BY ' . $sort . ' ' . $order);
	$res = $GLOBALS['db']->getAll($sql);

	foreach ($res as $key => $row) {
		$res[$key]['goods_name'] = $row['goods_name'];
		$res[$key]['thumb'] = get_image_path($row['goods_id'], $row['goods_thumb'], true);
		$res[$key]['goods_img'] = get_image_path($row['goods_id'], $row['goods_img']);
		$res[$key]['url'] = build_uri('presale', array('act' => 'view', 'presaleid' => $row['act_id']));
		$res[$key]['end_time_date'] = local_date('Y-m-d H:i:s', $row['end_time']);
		$res[$key]['start_time_date'] = local_date('Y-m-d H:i:s', $row['start_time']);

		if ($now <= $row['start_time']) {
			$res[$key]['no_start'] = 1;
		}

		if ($row['end_time'] <= $now) {
			$res[$key]['already_over'] = 1;
		}
	}

	return $res;
}

function get_pre_num($goods_id)
{
	$sql = 'SELECT pre_num FROM ' . $GLOBALS['ecs']->table('presale_activity') . (' WHERE goods_id=\'' . $goods_id . '\'');
	$res = $GLOBALS['db']->getOne($sql);
	return $res;
}

function get_pre_cat()
{
	$sql = 'SELECT * FROM ' . $GLOBALS['ecs']->table('presale_cat') . ' ORDER BY sort_order ASC ';
	$cat_res = $GLOBALS['db']->getAll($sql);

	foreach ($cat_res as $key => $row) {
		$cat_res[$key]['goods'] = get_cat_goods($row['cat_id']);
		$cat_res[$key]['count_goods'] = count($cat_res[$key]['goods']);
		$cat_res[$key]['cat_url'] = build_uri('presale', array('act' => 'category', 'cid' => $row['cat_id']), $row['cat_name']);
	}

	return $cat_res;
}

function get_cat_goods($cat_id)
{
	$now = gmtime();
	$sql = 'SELECT a.*, g.goods_thumb, g.goods_img, g.goods_name, g.shop_price, g.market_price, g.sales_volume, s.* FROM ' . $GLOBALS['ecs']->table('presale_activity') . ' AS a ' . ' LEFT JOIN ' . $GLOBALS['ecs']->table('goods') . ' AS g ON a.goods_id = g.goods_id ' . ' LEFT JOIN ' . $GLOBALS['ecs']->table('seller_shopinfo') . ' AS s ON a.user_id = s.ru_id ' . ('WHERE a.cat_id = \'' . $cat_id . '\' AND g.is_on_sale = 0 AND a.review_status = 3 ');
	$res = $GLOBALS['db']->getAll($sql);

	foreach ($res as $key => $row) {
		$res[$key]['goods_name'] = $row['goods_name'];
		$res[$key]['thumb'] = get_image_path($row['goods_id'], $row['goods_thumb'], true);
		$res[$key]['goods_img'] = get_image_path($row['goods_id'], $row['goods_img']);
		$res[$key]['url'] = build_uri('presale', array('act' => 'view', 'presaleid' => $row['act_id']), $row['goods_name']);
		$res[$key]['shop_url'] = build_uri('merchants_index', array('merchant_id' => $row['ru_id']), $row['shop_name']);
		$res[$key]['end_time_date'] = local_date('Y-m-d H:i:s', $row['end_time']);
		$res[$key]['start_time_date'] = local_date('Y-m-d H:i:s', $row['start_time']);

		if ($now <= $row['start_time']) {
			$res[$key]['no_start'] = 1;
		}

		if ($row['end_time'] <= $now) {
			$res[$key]['already_over'] = 1;
		}
	}

	return $res;
}

function get_pre_nav()
{
	$sql = 'SELECT * FROM ' . $GLOBALS['ecs']->table('presale_cat') . ' WHERE parent_id = 0 ORDER BY sort_order ASC LIMIT 7 ';
	$res = $GLOBALS['db']->getAll($sql);

	foreach ($res as $key => $row) {
		$res[$key]['cat_id'] = $row['cat_id'];
		$res[$key]['cat_name'] = $row['cat_name'];
		$res[$key]['url'] = build_uri('presale', array('act' => 'category', 'cid' => $row['cat_id']), $row['cat_name']);
	}

	return $res;
}

function get_presale_time($goods_id)
{
	$sql = 'SELECT act_id, pay_end_time FROM ' . $GLOBALS['ecs']->table('presale_activity') . (' WHERE goods_id = \'' . $goods_id . '\' AND review_status = 3 LIMIT 1');
	$res = $GLOBALS['db']->getRow($sql);

	if ($res['pay_end_time']) {
		$res['pay_end_time'] = local_date($GLOBALS['_CFG']['time_format'], $res['pay_end_time']);

		if ($res['pay_end_time']) {
			$pay_end_time = explode(' ', $res['pay_end_time']);
			$atthe = explode(':', $pay_end_time[1]);
			$res['str_time'] = $pay_end_time[0] . ' ' . $atthe[0] . ':' . $atthe[1];
		}
		else {
			$res['str_time'] = $res['pay_end_time'];
		}
	}

	return $res;
}

function get_linked_goods($goods_id, $warehouse_id = 0, $area_id = 0)
{
	$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 . '\' ';
	}

	$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(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'] . '\'), g.shop_price * \'' . $_SESSION['discount'] . '\')  AS shop_price, ') . 'IFNULL(IF(g.model_price < 1, g.promote_price, IF(g.model_price < 2, wg.warehouse_promote_price, wag.region_promote_price)), g.promote_price) AS promote_price, ' . ' g.promote_start_date, g.promote_end_date, g.market_price, g.sales_volume, g.model_attr, g.product_price, g.product_promote_price ' . '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)) {
		if (0 < $row['promote_price']) {
			$promote_price = bargain_price($row['promote_price'], $row['promote_start_date'], $row['promote_end_date']);
		}
		else {
			$promote_price = 0;
		}

		$price_info = get_goods_one_attr_price($row, $warehouse_id, $area_id, $promote_price);
		$row = !empty($row) ? array_merge($row, $price_info) : $row;
		$promote_price = $row['promote_price'];
		$arr[$row['goods_id']]['goods_id'] = $row['goods_id'];
		$arr[$row['goods_id']]['goods_name'] = $row['goods_name'];
		$arr[$row['goods_id']]['short_name'] = 0 < $GLOBALS['_CFG']['goods_name_length'] ? 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']]['promote_price'] = 0 < $promote_price ? price_format($promote_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'];
	}

	return $arr;
}

function get_goods_attr_ajax($goods_id, $goods_attr, $goods_attr_id)
{
	$arr = array();
	$arr['attr_id'] = '';
	$where = '';

	if ($goods_attr) {
		$goods_attr = implode(',', $goods_attr);
		$where .= ' AND ga.attr_id IN(' . $goods_attr . ')';

		if ($goods_attr_id) {
			$goods_attr_id = implode(',', $goods_attr_id);
			$where .= ' AND ga.goods_attr_id IN(' . $goods_attr_id . ')';
		}

		$sql = 'SELECT ga.goods_attr_id, ga.attr_id, ga.attr_value  FROM ' . $GLOBALS['ecs']->table('goods_attr') . ' AS ga' . ' LEFT JOIN ' . $GLOBALS['ecs']->table('attribute') . ' AS a ON ga.attr_id = a.attr_id ' . (' WHERE  ga.goods_id = \'' . $goods_id . '\' ' . $where . ' AND a.attr_type > 0 ORDER BY a.sort_order, a.attr_id, ga.goods_attr_id');
		$res = $GLOBALS['db']->getAll($sql);

		foreach ($res as $key => $row) {
			$arr[$row['attr_id']][$row['goods_attr_id']] = $row;
			$arr['attr_id'] .= $row['attr_id'] . ',';
		}

		if ($arr['attr_id']) {
			$arr['attr_id'] = substr($arr['attr_id'], 0, -1);
			$arr['attr_id'] = explode(',', $arr['attr_id']);
		}
		else {
			$arr['attr_id'] = array();
		}
	}

	return $arr;
}

function get_goods_related_cat($cat_id)
{
	$sql = 'SELECT parent_id FROM ' . $GLOBALS['ecs']->table('presale_cat') . (' WHERE cat_id = \'' . $cat_id . '\'');
	$res = $GLOBALS['db']->getOne($sql, true);
	$sql = 'SELECT cat_id, cat_name FROM ' . $GLOBALS['ecs']->table('presale_cat') . ' WHERE parent_id = \'' . $res . '\'';
	$res = $GLOBALS['db']->getAll($sql);

	foreach ($res as $key => $row) {
		$res[$key]['cat_id'] = $row['cat_id'];
		$res[$key]['cat_name'] = $row['cat_name'];
		$res[$key]['url'] = build_uri('presale', array('act' => 'category', 'cid' => $row['cat_id']), $row['cat_name']);
	}

	return $res;
}

function get_pre_category($act = 'new', $status = 0)
{
	$sql = 'SELECT cat_id, cat_name FROM ' . $GLOBALS['ecs']->table('presale_cat') . ' WHERE parent_id = 0 ORDER BY sort_order ASC ';
	$res = $GLOBALS['db']->getAll($sql);

	foreach ($res as $key => $row) {
		$res[$key]['cat_id'] = $row['cat_id'];
		$res[$key]['cat_name'] = $row['cat_name'];
		$res[$key]['url'] = build_uri('presale', array('act' => $act, 'cid' => $row['cat_id'], 'status' => $status), $row['cat_name']);
	}

	return $res;
}

function get_presale_url($act, $cat_id, $status, $cat_name)
{
	return build_uri('presale', array('act' => $act, 'cid' => $cat_id, 'status' => $status), $cat_name);
}

define('IN_ECS', true);
require dirname(__FILE__) . '/includes/init.php';

if ((DEBUG_MODE & 2) != 2) {
	$smarty->caching = true;
}

require ROOT_PATH . '/includes/lib_area.php';
$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'];
}

get_request_filter();
$_POST = get_request_filter($_POST, 1);
$pid = isset($_REQUEST['pid']) ? intval($_REQUEST['pid']) : 0;
$user_id = isset($_SESSION['user_id']) ? $_SESSION['user_id'] : 0;
$smarty->assign('pre_nav_list', get_pre_nav());

if (empty($_REQUEST['act'])) {
	$_REQUEST['act'] = 'index';
}

if (!empty($_REQUEST['act']) && $_REQUEST['act'] == 'price') {
	$goods_id = isset($_REQUEST['id']) ? intval($_REQUEST['id']) : 0;
	include 'includes/cls_json.php';
	$json = new JSON();
	$res = array('err_msg' => '', 'err_no' => 0, 'result' => '', 'qty' => 1);
	$attr_id = isset($_REQUEST['attr']) && !empty($_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;
	$onload = isset($_REQUEST['onload']) ? trim($_REQUEST['onload']) : '';
	$goods_attr = isset($_REQUEST['goods_attr']) && !empty($_REQUEST['goods_attr']) ? explode(',', $_REQUEST['goods_attr']) : array();
	$attr_ajax = get_goods_attr_ajax($goods_id, $goods_attr, $attr_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;
		}

		$products = get_warehouse_id_attr_number($goods_id, $_REQUEST['attr'], $goods['user_id'], $warehouse_id, $area_id);
		$attr_number = $products['product_number'];
		$product_promote_price = isset($products['product_promote_price']) ? $products['product_promote_price'] : 0;

		if ($goods['model_attr'] == 1) {
			$table_products = 'products_warehouse';
			$type_files = ' and warehouse_id = \'' . $warehouse_id . '\'';
		}
		else if ($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 ($goods['goods_type'] == 0) {
			$attr_number = $goods['goods_number'];
		}
		else if (empty($prod)) {
			$attr_number = $goods['goods_number'];
		}

		if (empty($prod)) {
			$res['bar_code'] = $goods['bar_code'];
		}
		else {
			$res['bar_code'] = $products['bar_code'];
		}

		$attr_number = 999;
		$res['attr_number'] = $attr_number;
		$res['show_goods'] = 0;
		if ($goods_attr && $GLOBALS['_CFG']['add_shop_price'] == 0) {
			if (count($goods_attr) == count($attr_ajax['attr_id'])) {
				$res['show_goods'] = 1;
			}
		}

		$shop_price = get_final_price($goods_id, $number, true, $attr_id, $warehouse_id, $area_id);
		$res['shop_price'] = price_format($shop_price);
		$spec_price = get_final_price($goods_id, $number, true, $attr_id, $warehouse_id, $area_id, 1, 0, 0, $res['show_goods'], $product_promote_price);

		if ($GLOBALS['_CFG']['add_shop_price'] == 0) {
			$res['result'] = price_format($spec_price);
		}
		else {
			$res['result'] = price_format($shop_price);
		}

		$res['spec_price'] = price_format($spec_price);
		$res['original_shop_price'] = $shop_price;
		$res['original_spec_price'] = $spec_price;
		$res['marketPrice_amount'] = price_format($goods['marketPrice'] + $spec_price);
		$res['result'] = price_format($shop_price);

		if ($GLOBALS['_CFG']['add_shop_price'] == 0) {
			$goods['marketPrice'] = isset($products['product_market_price']) && !empty($products['product_market_price']) ? $products['product_market_price'] : $goods['marketPrice'];
			$res['result_market'] = price_format($goods['marketPrice']);
		}
		else {
			$res['result_market'] = price_format($goods['marketPrice'] + $spec_price);
		}
	}

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

	$presale = get_presale_time($goods_id);
	$res['act_id'] = isset($presale['act_id']) ? $presale['act_id'] : 0;
	$res['onload'] = $onload;
	$res['presale'] = $presale;
	exit($json->encode($res));
}
else if ($_REQUEST['act'] == 'in_stock') {
	include 'includes/cls_json.php';
	$json = new JSON();
	$res = array('err_msg' => '', 'result' => '', 'qty' => 1);
	clear_cache_files();
	$act_id = empty($_REQUEST['act_id']) ? 0 : intval($_REQUEST['act_id']);
	$goods_id = empty($_REQUEST['id']) ? 0 : intval($_REQUEST['id']);
	$province = empty($_REQUEST['province']) ? 1 : intval($_REQUEST['province']);
	$city = empty($_REQUEST['city']) ? 52 : intval($_REQUEST['city']);
	$district = empty($_REQUEST['district']) ? 500 : intval($_REQUEST['district']);
	$d_null = empty($_REQUEST['d_null']) ? 0 : intval($_REQUEST['d_null']);
	$user_id = empty($_REQUEST['user_id']) ? 0 : $_REQUEST['user_id'];
	$user_address = get_user_address_region($user_id);
	$user_address = explode(',', $user_address['region_address']);
	setcookie('province', $province, gmtime() + 3600 * 24 * 30, $GLOBALS['cookie_path'], $GLOBALS['cookie_domain']);
	setcookie('city', $city, gmtime() + 3600 * 24 * 30, $GLOBALS['cookie_path'], $GLOBALS['cookie_domain']);
	setcookie('district', $district, gmtime() + 3600 * 24 * 30, $GLOBALS['cookie_path'], $GLOBALS['cookie_domain']);
	$regionId = 0;
	setcookie('regionId', $regionId, gmtime() + 3600 * 24 * 30, $GLOBALS['cookie_path'], $GLOBALS['cookie_domain']);
	setcookie('type_province', 0, gmtime() + 3600 * 24 * 30, $GLOBALS['cookie_path'], $GLOBALS['cookie_domain']);
	setcookie('type_city', 0, gmtime() + 3600 * 24 * 30);
	setcookie('type_district', 0, gmtime() + 3600 * 24 * 30, $GLOBALS['cookie_path'], $GLOBALS['cookie_domain']);
	$res['d_null'] = $d_null;

	if ($d_null == 0) {
		if (in_array($district, $user_address)) {
			$res['isRegion'] = 1;
		}
		else {
			$res['message'] = $_LANG['region_message'];
			$res['isRegion'] = 88;
		}
	}
	else {
		setcookie('district', '', gmtime() + 3600 * 24 * 30, $GLOBALS['cookie_path'], $GLOBALS['cookie_domain']);
	}

	$res['goods_id'] = $goods_id;
	$res['act_id'] = $act_id;
	exit($json->encode($res));
}

if ($_REQUEST['act'] == 'index') {
	$pre_goods = get_pre_cat();
	$smarty->assign('pre_cat_goods', $pre_goods);
	$categories_pro = get_category_tree_leve_one();
	$smarty->assign('categories_pro', $categories_pro);
	assign_template();
	$smarty->assign('helps', get_shop_help());
	$position = assign_ur_here();
	$smarty->assign('page_title', $position['title']);
	$smarty->assign('ur_here', $position['ur_here']);

	for ($i = 1; $i <= $_CFG['auction_ad']; $i++) {
		$presale_banner .= '\'presale_banner' . $i . ',';
		$presale_banner_small .= '\'presale_banner_small' . $i . ',';
		$presale_banner_small_left .= '\'presale_banner_small_left' . $i . ',';
		$presale_banner_small_right .= '\'presale_banner_small_right' . $i . ',';
	}

	$smarty->assign('pager', array('act' => 'index'));
	$smarty->assign('presale_banner', $presale_banner);
	$smarty->assign('presale_banner_small', $presale_banner_small);
	$smarty->assign('presale_banner_small_left', $presale_banner_small_left);
	$smarty->assign('presale_banner_small_right', $presale_banner_small_right);
	$smarty->display('presale_index.dwt');
}
else if ($_REQUEST['act'] == 'area') {
	$smarty->display('presale_area.dwt', $cache_id);
}
else if ($_REQUEST['act'] == 'new') {
	$where = '';
	$cat_id = isset($_REQUEST['cat_id']) && 0 < intval($_REQUEST['cat_id']) ? intval($_REQUEST['cat_id']) : 0;
	$status = isset($_REQUEST['status']) && 0 < intval($_REQUEST['status']) ? intval($_REQUEST['status']) : 0;
	$children = get_children($cat_id, $type, 0, 'presale_cat', 'a.cat_id');
	$now = gmtime();

	if ($status == 1) {
		$where .= ' AND a.start_time > ' . $now . ' ';
	}
	else if ($status == 2) {
		$where .= ' AND a.start_time < ' . $now . ' AND ' . $now . ' < a.end_time ';
	}
	else if ($status == 3) {
		$where .= ' AND ' . $now . ' > a.end_time ';
	}

	$pager = array('cat_id' => $cat_id, 'act' => 'new', 'status' => $status);
	$smarty->assign('pager', $pager);
	$pre_status['status_cat'] = get_presale_url('new', 0, 0, '新品发布');
	$pre_status['status_all'] = get_presale_url('new', $cat_id, 0, '新品发布');
	$pre_status['status_one'] = get_presale_url('new', $cat_id, 1, '新品发布');
	$pre_status['status_two'] = get_presale_url('new', $cat_id, 2, '新品发布');
	$pre_status['status_three'] = get_presale_url('new', $cat_id, 3, '新品发布');
	$smarty->assign('pre_status', $pre_status);
	$pre_category = get_pre_category('new', $status);
	$smarty->assign('pre_category', $pre_category);
	$sql = 'SELECT a.*, g.goods_thumb, g.goods_img, g.goods_name, g.shop_price, g.market_price, g.sales_volume FROM ' . $GLOBALS['ecs']->table('presale_activity') . ' AS a' . ' LEFT JOIN ' . $GLOBALS['ecs']->table('goods') . ' AS g ON a.goods_id = g.goods_id ' . (' WHERE ' . $children . ' AND g.goods_id > 0 ' . $where . ' AND g.is_on_sale = 0 AND a.review_status = 3 ORDER BY a.end_time DESC,a.start_time DESC ');
	$res = $GLOBALS['db']->getAll($sql);

	foreach ($res as $key => $row) {
		$res[$key]['thumb'] = get_image_path($row['goods_id'], $row['goods_thumb'], true);
		$res[$key]['goods_img'] = get_image_path($row['goods_id'], $row['goods_img']);
		$res[$key]['url'] = build_uri('presale', array('act' => 'view', 'presaleid' => $row['act_id']));
		$res[$key]['end_time_date'] = local_date('Y-m-d H:i:s', $row['end_time']);
		$res[$key]['end_time_day'] = local_date('Y-m-d', $row['end_time']);
		$res[$key]['start_time_date'] = local_date('Y-m-d H:i:s', $row['start_time']);
		$res[$key]['start_time_day'] = local_date('Y-m-d', $row['start_time']);

		if ($now <= $row['start_time']) {
			$res[$key]['no_start'] = 1;
		}

		if ($row['end_time'] <= $now) {
			$res[$key]['already_over'] = 1;
		}
	}

	$date_array = array();

	foreach ($res as $key => $row) {
		$date_array[$row['end_time_day']][] = $row;
	}

	$date_result = array();

	foreach ($date_array as $key => $value) {
		$date_result[]['goods'] = $value;
	}

	foreach ($date_result as $key => $value) {
		$date_result[$key]['end_time_day'] = $value['goods'][0]['end_time_day'];
		$date_result[$key]['end_time_y'] = local_date('Y', gmstr2time($value['goods'][0]['end_time_day']));
		$date_result[$key]['end_time_m'] = local_date('m', gmstr2time($value['goods'][0]['end_time_day']));
		$date_result[$key]['end_time_d'] = local_date('d', gmstr2time($value['goods'][0]['end_time_day']));
		$date_result[$key]['count_goods'] = count($value['goods']);
	}

	$smarty->assign('date_result', $date_result);
	assign_template();
	$smarty->assign('helps', get_shop_help());
	$position = assign_ur_here();
	$smarty->assign('page_title', $position['title']);
	$smarty->assign('ur_here', $position['ur_here']);

	for ($i = 1; $i <= $_CFG['auction_ad']; $i++) {
		$presale_banner_new .= '\'presale_banner_new' . $i . ',';
	}

	$smarty->assign('presale_banner_new', $presale_banner_new);
	$smarty->display('presale_new.dwt');
}
else if ($_REQUEST['act'] == 'advance') {
	$price_min = isset($_REQUEST['price_min']) && 0 < intval($_REQUEST['price_min']) ? intval($_REQUEST['price_min']) : 0;
	$price_max = isset($_REQUEST['price_max']) && 0 < intval($_REQUEST['price_max']) ? intval($_REQUEST['price_max']) : 0;
	$default_sort_order_method = $_CFG['sort_order_method'] == '0' ? 'DESC' : 'ASC';
	$default_sort_order_type = $_CFG['sort_order_type'] == '0' ? 'act_id' : ($_CFG['sort_order_type'] == '1' ? 'shop_price' : 'start_time');
	$sort = isset($_REQUEST['sort']) && in_array(trim(strtolower($_REQUEST['sort'])), array('shop_price', 'start_time', 'act_id')) ? 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;
	$cat_id = isset($_REQUEST['cat_id']) && 0 < intval($_REQUEST['cat_id']) ? intval($_REQUEST['cat_id']) : 0;
	$status = isset($_REQUEST['status']) && 0 < intval($_REQUEST['status']) ? intval($_REQUEST['status']) : 0;
	$goods = get_pre_goods($cat_id, $min = 0, $max = 0, $start_time, $end_time, $sort, $status, $order);
	$pre_category = get_pre_category('advance', $status);
	$smarty->assign('pre_category', $pre_category);
	$pager = array('cat_id' => $cat_id, 'act' => 'advance', 'price_min' => $price_min, 'price_max' => $price_max, 'sort' => $sort, 'order' => $order, 'status' => $status);
	$smarty->assign('pager', $pager);
	$smarty->assign('goods', $goods);
	assign_template();
	$smarty->assign('helps', get_shop_help());
	$position = assign_ur_here();
	$smarty->assign('page_title', $position['title']);
	$smarty->assign('ur_here', $position['ur_here']);

	for ($i = 1; $i <= $_CFG['auction_ad']; $i++) {
		$presale_banner_advance .= '\'presale_banner_advance' . $i . ',';
	}

	$smarty->assign('presale_banner_advance', $presale_banner_advance);
	$smarty->display('presale_advance.dwt', $cache_id);
}
else if ($_REQUEST['act'] == 'category') {
	$price_min = isset($_REQUEST['price_min']) && 0 < intval($_REQUEST['price_min']) ? intval($_REQUEST['price_min']) : 0;
	$price_max = isset($_REQUEST['price_max']) && 0 < intval($_REQUEST['price_max']) ? intval($_REQUEST['price_max']) : 0;
	$default_sort_order_method = $_CFG['sort_order_method'] == '0' ? 'DESC' : 'ASC';
	$default_sort_order_type = $_CFG['sort_order_type'] == '0' ? 'act_id' : ($_CFG['sort_order_type'] == '1' ? 'shop_price' : 'start_time');
	$sort = isset($_REQUEST['sort']) && in_array(trim(strtolower($_REQUEST['sort'])), array('shop_price', 'start_time', 'act_id')) ? 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;
	$cat_id = isset($_REQUEST['cat_id']) && 0 < intval($_REQUEST['cat_id']) ? intval($_REQUEST['cat_id']) : 0;
	$status = isset($_REQUEST['status']) && 0 < intval($_REQUEST['status']) ? intval($_REQUEST['status']) : 0;
	$goods = get_pre_goods($cat_id, $min = 0, $max = 0, $start_time, $end_time, $sort, $status, $order);
	$pre_category = get_pre_category('category', $status);
	$smarty->assign('pre_category', $pre_category);
	$pager = array('cat_id' => $cat_id, 'act' => 'category', 'price_min' => $price_min, 'price_max' => $price_max, 'sort' => $sort, 'order' => $order, 'status' => $status);
	$smarty->assign('pager', $pager);
	$smarty->assign('goods', $goods);
	assign_template();
	$smarty->assign('helps', get_shop_help());
	$position = assign_ur_here();
	$smarty->assign('page_title', $position['title']);
	$smarty->assign('ur_here', $position['ur_here']);

	for ($i = 1; $i <= $_CFG['auction_ad']; $i++) {
		$presale_banner_category .= '\'presale_banner_category' . $i . ',';
	}

	$smarty->assign('presale_banner_category', $presale_banner_category);
	$smarty->display('presale_category.dwt', $cache_id);
}
else {
	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 (3 < $page) {
			$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;
		exit($json->encode($res));
	}
	else if ($_REQUEST['act'] == 'view') {
		$presale_id = isset($_REQUEST['id']) ? intval($_REQUEST['id']) : 0;

		if ($presale_id <= 0) {
			ecs_header("Location: ./\n");
			exit();
		}

		$presale = presale_info($presale_id, 0, $user_id);

		if (empty($presale)) {
			show_message($_LANG['now_not_snatch']);
		}

		assign_template();
		$categories_pro = get_category_tree_leve_one();
		$smarty->assign('categories_pro', $categories_pro);
		$cache_id = $_CFG['lang'] . '-presale-' . $presale_id . '-' . $presale['status'] . time();

		if ($presale['status'] == GBS_UNDER_WAY) {
			$cache_id = $cache_id . '-' . $presale['valid_goods'] . '-' . intval(0 < $_SESSION['user_id']);
		}

		$cache_id = sprintf('%X', crc32($cache_id));

		if (!$smarty->is_cached('presale_goods.dwt', $cache_id)) {
			$start_date = $presale['xiangou_start_date'];
			$end_date = $presale['xiangou_end_date'];
			$nowTime = gmtime();
			if ($start_date < $nowTime && $nowTime < $end_date) {
				$xiangou = 1;
			}
			else {
				$xiangou = 0;
			}

			$smarty->assign('xiangou', $xiangou);
			$smarty->assign('orderG_number', $presale['total_goods']);
			$now = gmtime();
			$presale['gmt_end_date'] = local_strtotime($presale['end_time']);
			$presale['gmt_start_date'] = local_strtotime($presale['start_time']);

			if ($now <= $presale['gmt_start_date']) {
				$presale['no_start'] = 1;
			}

			if ($presale['gmt_end_date'] <= $now) {
				$presale['already_over'] = 1;
			}

			$smarty->assign('presale', $presale);
			$goods_id = $presale['goods_id'];
			$goods = get_goods_info($goods_id, $region_id, $area_id);

			if (empty($goods)) {
				ecs_header("Location: ./\n");
				exit();
			}

			$smarty->assign('goods', $goods);
			$smarty->assign('id', $goods_id);
			$smarty->assign('type', 0);
			$comment_all = get_comments_percent($goods_id);
			$smarty->assign('comment_all', $comment_all);

			if (0 < $goods['user_id']) {
				$merchants_goods_comment = get_merchants_goods_comment($goods['user_id']);
				$smarty->assign('merch_cmt', $merchants_goods_comment);
			}

			$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);
			$province_list = get_warehouse_province();
			$smarty->assign('province_list', $province_list);
			$city_list = get_region_city_county($province_id);
			$smarty->assign('city_list', $city_list);
			$district_list = get_region_city_county($city_id);
			$smarty->assign('district_list', $district_list);
			$smarty->assign('goods_id', $goods_id);
			$warehouse_list = get_warehouse_list_goods();
			$smarty->assign('warehouse_list', $warehouse_list);
			$warehouse_name = get_warehouse_name_id($region_id);
			$smarty->assign('warehouse_name', $warehouse_name);
			$smarty->assign('region_id', $region_id);
			$smarty->assign('user_id', $_SESSION['user_id']);
			$smarty->assign('shop_price_type', $goods['model_price']);
			$smarty->assign('area_id', $area_id);
			$pre_num = get_pre_num($goods_id);
			$smarty->assign('pre_num', $pre_num);
			$properties = get_goods_properties($goods_id);
			$smarty->assign('properties', $properties['pro']);
			$smarty->assign('specification', $properties['spe']);
			$smarty->assign('area_htmlType', 'presale');
			$smarty->assign('province_row', get_region_info($province_id));
			$smarty->assign('city_row', get_region_info($city_id));
			$smarty->assign('district_row', get_region_info($district_id));
			$smarty->assign('cfg', $_CFG);
			$position = assign_ur_here($presale['pa_catid'], $presale['goods_name'], array(), '', $presale['user_id']);
			$smarty->assign('page_title', $position['title']);
			$smarty->assign('ur_here', $position['ur_here']);
			$smarty->assign('categories', get_categories_tree());
			$smarty->assign('helps', get_shop_help());
			$smarty->assign('best_goods', get_recommend_goods('best', '', $region_id, $area_info['region_id'], $goods['user_id'], 1, 'presale'));
			$smarty->assign('new_goods', get_recommend_goods('new', '', $region_id, $area_info['region_id'], $goods['user_id'], 1, 'presale'));
			$smarty->assign('hot_goods', get_recommend_goods('hot', '', $region_id, $area_info['region_id'], $goods['user_id'], 1, 'presale'));
			$smarty->assign('pictures', get_goods_gallery($goods_id));
			$all_count = get_discuss_type_count($goods_id);
			$GLOBALS['smarty']->assign('all_count', $all_count);
			$goods_related_cat = get_goods_related_cat($presale['pa_catid']);
			$smarty->assign('goods_related_cat', $goods_related_cat);
		}

		$linked_goods = get_linked_goods($goods_id, $region_id, $area_info['region_id']);
		$smarty->assign('related_goods', $linked_goods);
		$comment_all = get_comments_percent($goods_id);

		if (0 < $goods['user_id']) {
			$merchants_goods_comment = get_merchants_goods_comment($goods['user_id']);
		}

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

		if ($goods['user_id']) {
			$goods_store_cat = get_child_tree_pro(0, 0, 'merchants_category', 0, $goods['user_id']);

			if ($goods_store_cat) {
				$goods_store_cat = array_values($goods_store_cat);
			}

			$smarty->assign('goods_store_cat', $goods_store_cat);
		}

		$discuss_list = get_discuss_all_list($goods_id, 0, 1, 10);
		$smarty->assign('discuss_list', $discuss_list);
		$sql = 'UPDATE ' . $ecs->table('goods') . ' SET click_count = click_count + 1 ' . 'WHERE goods_id = \'' . $presale['goods_id'] . '\'';
		$db->query($sql);
		$smarty->assign('act_id', $presale_id);
		$smarty->assign('now_time', gmtime());
		$smarty->assign('area_htmlType', 'presale');
		$basic_info = get_shop_info_content($goods['user_id']);
		$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) . '市';
		$shop_information = get_shop_name($goods['user_id']);
		$shop_information['kf_tel'] = $db->getOne('SELECT kf_tel FROM ' . $ecs->table('seller_shopinfo') . 'WHERE ru_id = \'' . $goods['user_id'] . '\'');

		if ($presale['user_id'] == 0) {
			if ($db->getOne('SELECT kf_im_switch FROM ' . $ecs->table('seller_shopinfo') . 'WHERE ru_id = 0')) {
				$shop_information['is_dsc'] = true;
			}
			else {
				$shop_information['is_dsc'] = false;
			}
		}
		else {
			$shop_information['is_dsc'] = false;
		}

		$smarty->assign('shop_information', $shop_information);
		$smarty->assign('basic_info', $basic_info);
		$area = array('region_id' => $region_id, 'province_id' => $province_id, 'city_id' => $city_id, 'district_id' => $district_id, 'street_id' => $street_id, 'street_list' => $street_list, 'goods_id' => $goods_id, 'user_id' => $user_id, 'area_id' => $area_info['region_id'], 'merchant_id' => $goods['user_id']);
		$smarty->assign('area', $area);

		if (!defined('THEME_EXTENSION')) {
			$region = array(1, $province_id, $city_id, $district_id, $street_id, $street_list);
			$shippingFee = goodsShippingFee($goods_id, $region_id, $area_info['region_id'], $region);
			$smarty->assign('shippingFee', $shippingFee);
		}

		$smarty->display('presale_goods.dwt', $cache_id);
	}
	else if ($_REQUEST['act'] == 'buy') {
		if ($_SESSION['user_id'] <= 0) {
			show_message($_LANG['gb_error_login'], '', '', 'error');
		}

		$warehouse_id = isset($_REQUEST['warehouse_id']) ? intval($_REQUEST['warehouse_id']) : 0;
		$area_id = isset($_REQUEST['area_id']) ? intval($_REQUEST['area_id']) : 0;
		$presale_id = isset($_POST['presale_id']) ? intval($_POST['presale_id']) : 0;

		if ($presale_id <= 0) {
			ecs_header("Location: ./\n");
			exit();
		}

		$number = isset($_POST['number']) ? intval($_POST['number']) : 1;
		$number = $number < 1 ? 1 : $number;
		$presale = presale_info($presale_id, $number, $user_id);

		if (empty($presale)) {
			ecs_header("Location: ./\n");
			exit();
		}

		if ($presale['status'] != GBS_UNDER_WAY) {
			show_message($_LANG['presale_error_status'], '', '', 'error');
		}

		$specs = isset($_POST['goods_spec']) ? htmlspecialchars(trim($_POST['goods_spec'])) : '';
		$attr_id = !empty($specs) ? explode(',', $specs) : '';
		$goods = goods_info($presale['goods_id'], $warehouse_id, $area_id, array(), $attr_id);

		if (empty($goods)) {
			ecs_header("Location: ./\n");
			exit();
		}

		if ($specs) {
			$_specs = explode(',', $specs);
			$product_info = get_products_info($goods['goods_id'], $_specs, $warehouse_id, $area_id);
		}

		empty($product_info) ? $product_info = array('product_number' => 0, 'product_id' => 0) : '';
		$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($specs) . ' ORDER BY a.sort_order, a.attr_id, g.goods_attr_id';
		$res = $db->query($sql);

		while ($row = $db->fetchRow($res)) {
			$attr_list[] = $row['attr_name'] . ': ' . $row['attr_value'];
		}

		$goods_attr = join(chr(13) . chr(10), $attr_list);
		include_once ROOT_PATH . 'includes/lib_order.php';
		clear_cart(CART_PRESALE_GOODS);
		$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 (!empty($_SESSION['user_id'])) {
			$sess = '';
		}
		else {
			$sess = real_cart_mac_ip();
		}

		$nowTime = gmtime();
		$start_date = $goods['xiangou_start_date'];
		$end_date = $goods['xiangou_end_date'];
		if ($goods['is_xiangou'] == 1 && $start_date < $nowTime && $nowTime < $end_date) {
			if ($goods['xiangou_num'] <= $presale['total_goods']) {
				$message = $presale['goods_name'] . ' 商品您已购买达到上限';
				show_message($message, $_LANG['back_to_presale'], 'presale.php?id=' . $presale['act_id'] . '&act=view');
			}
			else if (0 < $goods['xiangou_num']) {
				if ($goods['is_xiangou'] == 1 && $goods['xiangou_num'] < $presale['total_goods'] + $number) {
					$number = $goods['xiangou_num'] - $presale['total_goods'];
				}
			}
		}

		$cart = array('user_id' => $_SESSION['user_id'], 'session_id' => $sess, 'goods_id' => $presale['goods_id'], 'product_id' => $product_info['product_id'], 'goods_sn' => addslashes($goods['goods_sn']), 'goods_name' => addslashes($goods['goods_name']), 'market_price' => $goods['market_price'], 'goods_price' => get_final_price($presale['goods_id']), 'goods_number' => $number, 'goods_attr' => addslashes($goods_attr), 'goods_attr_id' => $specs, 'ru_id' => $goods['user_id'], 'warehouse_id' => $region_id, 'area_id' => $area_id, 'is_real' => $goods['is_real'], 'extension_code' => 'presale', 'parent_id' => 0, 'rec_type' => CART_PRESALE_GOODS, 'is_gift' => 0);
		$db->autoExecute($ecs->table('cart'), $cart, 'INSERT');
		$_SESSION['flow_type'] = CART_PRESALE_GOODS;
		$_SESSION['extension_code'] = 'presale';
		$_SESSION['extension_id'] = $presale['act_id'];
		$_SESSION['browse_trace'] = 'presale';
		ecs_header("Location: ./flow.php?step=checkout\n");
		exit();
	}
}

?>