";
	print_r($row);

	foreach ($row as $key => $value)
    {
        if(in_array($value['goods_attr'],$attrids)){
        	$ret[$value['goods_attr']] = $value['product_number'];
        }
    }
    return $ret;
    */
}

/**
 * 获取商品的相关信息
 * @param int $goodsid 商品id
 * @param string $name  要获取商品的属性名称,多个，就用逗号分隔
 */
function get_goods_attr_value($goodsid,$name='goods_sn,goods_name')
{
	$sql = "select ".$name." from ". $GLOBALS['ecs']->table('goods') ." where goods_id=".$goodsid;
	$row = $GLOBALS['db']->getRow($sql);
	return $row;
}
/* 代码增加_start   */
function get_package_goods_list_ecshop($goods_id)
{
	$now = gmtime();
    $sql = "SELECT ga.act_id,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 pg.package_id
            ORDER BY ga.act_id";

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

    foreach ($res as $tempkey => $value)
    {
        $subtotal = 0;
		$i=1;

		//获取礼包价
		$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.product_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_ress = $GLOBALS['db']->query($sql);
		$goods_res = array();
		while ($row = $GLOBALS['db']->fetchRow($goods_ress))
		{
			if ($row['goods_id'] == $goods_id )
			{
				$goods_res[0]=$row;
			}
			else
			{
				$goods_res[$i]=$row;
				$i++;
			}
		}

        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']   = $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();
                $goods_attr_price = 0;
                foreach ($goods_attr_array as $_attr)
                {
                    $goods_attr_price += $GLOBALS['db']->getOne(
                        'SELECT attr_price FROM ' . $GLOBALS['ecs']->table('goods_attr') . ' WHERE goods_attr_id = ' . $_attr
                    );
                    $goods_attr[] = $_goods_attr[$_attr];
                }
                $goods_res[$key]['goods_attr_price'] = $goods_attr_price;
                $goods_res[$key]['goods_attr_str'] = sprintf($format, implode('，', $goods_attr));
            }
        }

		ksort($goods_res); //重新排序数组

		/* 重新计算套餐内的商品折扣价 */
		$zhekou=  round(($res[$tempkey]['package_price'] / $subtotal), 8);
		foreach($goods_res as $key => $val)
		{
			$goods_res[$key]['rank_price_zk']=$val['rank_price'] * $zhekou;
			$goods_res[$key]['rank_price_zk_format']= price_format($goods_res[$key]['rank_price_zk']);
            /* 代码增加  Start */
            if(isset($val['goods_attr_price']))
            {
                $goods_res[$key]['rank_price_format'] = price_format($val['rank_price'] + $val['goods_attr_price']);
                $subtotal += $val['rank_price'] + $val['goods_attr_price'];
            }
            else
            {
                $goods_res[$key]['rank_price_format']= price_format($val['rank_price']);
                $subtotal += $val['rank_price'];
            }
            /* 代码增加  End */
        }

        $res[$tempkey]['goods_list']    = $goods_res;
        $res[$tempkey]['subtotal']      = price_format($subtotal);
		$res[$tempkey]['zhekou']      = $zhekou*100;
        $res[$tempkey]['saving']        = price_format(($subtotal - $res[$tempkey]['package_price']));
        $res[$tempkey]['package_price'] = price_format($res[$tempkey]['package_price']);

    }

	return $res;
}

function get_mark_price($goods_id)
{
	$sql = "SELECT market_price".
           " FROM " .$GLOBALS['ecs']->table('goods').
           " WHERE goods_id = '$goods_id'";
	$res = $GLOBALS['db']->getRow($sql);
	return $res['market_price'];
}


/* 代码增加_start   */
/*
 *
 *查询商品的优惠数量和价格 
 *
 *jx   2015-1-1
 */
function get_goods_volume($goods_id)
{
	$volume_price = array();

    $sql = "SELECT volume_number , volume_price".
           " FROM " .$GLOBALS['ecs']->table('volume_price').
           " WHERE goods_id = '$goods_id' ORDER BY volume_number";

    $res = $GLOBALS['db']->getAll($sql);
    foreach ($res as $k => $v)
    {
        $volume_price[$k]                 = array();
        $volume_price[$k]['volume_number']       = $v['volume_number'];
        $volume_price[$k]['volume_price'] = price_format($v['volume_price']);
    }
    return $volume_price;
}


/* 代码增加_start   */
make_html();
/* 代码增加_end    */
?>