<?php
//zend by QQ:1527200768  鸿宇科技  禁止倒卖 一经发现停止任何服务
define('IN_ECS', true);
require dirname(__FILE__) . '/includes/init.php';
require ROOT_PATH . '/includes/lib_area.php';
if (!empty($_REQUEST['goods']) && is_array($_REQUEST['goods']) && (1 < count($_REQUEST['goods']))) {
	$where = db_create_in($_REQUEST['goods'], 'id_value');
	$sql = 'SELECT id_value , AVG(comment_rank) AS cmt_rank, COUNT(*) AS cmt_count' . ' FROM ' . $ecs->table('comment') . ' WHERE ' . $where . ' AND comment_type = 0' . ' GROUP BY id_value ';
	$query = $db->query($sql);
	$cmt = array();

	while ($row = $db->fetch_array($query)) {
		$cmt[$row['id_value']] = $row;
	}

	$where = db_create_in($_REQUEST['goods'], 'g.goods_id');
	$sql = 'SELECT g.goods_id, g.goods_type, g.goods_name, g.comments_number,g.sales_volume,g.shop_price, g.goods_weight, g.goods_thumb, g.goods_brief, ' . 'a.attr_name, v.attr_value, a.attr_id, b.brand_name, ' . 'IFNULL(mp.user_price, g.shop_price * \'' . $_SESSION['discount'] . '\') AS rank_price ' . 'FROM ' . $ecs->table('goods') . ' AS g ' . 'LEFT JOIN ' . $ecs->table('goods_attr') . ' AS v ON v.goods_id = g.goods_id ' . 'LEFT JOIN ' . $ecs->table('attribute') . ' AS a ON a.attr_id = v.attr_id ' . 'LEFT JOIN ' . $ecs->table('brand') . ' AS b ON g.brand_id = b.brand_id ' . 'LEFT JOIN ' . $ecs->table('member_price') . ' AS mp ' . 'ON mp.goods_id = g.goods_id AND mp.user_rank = \'' . $_SESSION['user_rank'] . '\' ' . 'WHERE g.is_delete = 0 AND ' . $where . ' ' . 'ORDER BY a.sort_order, a.attr_id, v.goods_attr_id';
	$res = $db->query($sql);
	$arr = array();
	$ids = $_REQUEST['goods'];
	$attr_name = array();
	$type_id = 0;

	while ($row = $db->fetchRow($res)) {
		$goods_id = $row['goods_id'];
		$type_id = $row['goods_type'];
		$arr[$goods_id]['goods_id'] = $goods_id;
		$arr[$goods_id]['url'] = build_uri('goods', array('gid' => $goods_id), $row['goods_name']);
		$arr[$goods_id]['goods_name'] = $row['goods_name'];
		$arr[$goods_id]['comments_number'] = $row['comments_number'];
		$arr[$goods_id]['sales_volume'] = $row['sales_volume'];

		if (0 < $row['market_price']) {
			$discount_arr = get_discount($row['goods_id']);
		}

		$arr[$goods_id]['zhekou'] = $discount_arr['discount'];
		$arr[$goods_id]['jiesheng'] = $discount_arr['jiesheng'];
		$arr[$goods_id]['shop_price'] = price_format($row['shop_price']);
		$arr[$goods_id]['rank_price'] = price_format($row['rank_price']);
		$arr[$goods_id]['goods_weight'] = 0 < intval($row['goods_weight']) ? ceil($row['goods_weight']) . $_LANG['kilogram'] : ceil($row['goods_weight'] * 1000) . $_LANG['gram'];
		$arr[$goods_id]['goods_thumb'] = get_image_path($row['goods_id'], $row['goods_thumb'], true);
		$arr[$goods_id]['goods_brief'] = $row['goods_brief'];
		$arr[$goods_id]['brand_name'] = $row['brand_name'];
		$arr[$goods_id]['properties'][$row['attr_id']]['name'] = $row['attr_name'];

		if (!empty($arr[$goods_id]['properties'][$row['attr_id']]['value'])) {
			$arr[$goods_id]['properties'][$row['attr_id']]['value'] .= ',' . $row['attr_value'];
		}
		else {
			$arr[$goods_id]['properties'][$row['attr_id']]['value'] = $row['attr_value'];
		}

		if (!isset($arr[$goods_id]['comment_rank'])) {
			$arr[$goods_id]['comment_rank'] = isset($cmt[$goods_id]) ? ceil($cmt[$goods_id]['cmt_rank']) : 0;
			$arr[$goods_id]['comment_number'] = isset($cmt[$goods_id]) ? $cmt[$goods_id]['cmt_count'] : 0;
			$arr[$goods_id]['comment_number'] = sprintf($_LANG['comment_num'], $arr[$goods_id]['comment_number']);
		}

		$tmp = $ids;
		$key = array_search($goods_id, $tmp);
		if (($key !== NULL) && ($key !== false)) {
			unset($tmp[$key]);
		}

		$arr[$goods_id]['ids'] = !empty($tmp) ? 'goods[]=' . implode('&amp;goods[]=', $tmp) : '';
	}

	$sql = 'SELECT attr_id,attr_name FROM ' . $ecs->table('attribute') . ' WHERE cat_id=\'' . $type_id . '\' ORDER BY sort_order, attr_id';
	$attribute = array();
	$query = $db->query($sql);

	while ($rt = $db->fetch_array($query)) {
		$attribute[$rt['attr_id']] = $rt['attr_name'];
	}

	$smarty->assign('attribute', $attribute);
	$smarty->assign('goods_list', $arr);
}
else {
	show_message($_LANG['compare_no_goods']);
	exit();
}

assign_template();
$position = assign_ur_here(0, $_LANG['goods_compare']);
$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());
assign_dynamic('compare');
$smarty->display('compare.dwt');

?>