table('order_info'). " AS o ". "LEFT JOIN " .$GLOBALS['ecs']->table('users'). " AS u ON u.user_id=o.user_id ". "LEFT JOIN " .$GLOBALS['ecs']->table('region'). " AS ra ON ra.region_id=o.country ". "LEFT JOIN " .$GLOBALS['ecs']->table('region'). " AS rb ON rb.region_id=o.province ". "LEFT JOIN " .$GLOBALS['ecs']->table('region'). " AS rc ON rc.region_id=o.city ". "LEFT JOIN " .$GLOBALS['ecs']->table('region'). " AS rd ON rd.region_id=o.district ". "WHERE 1 $where ORDER BY o.order_id DESC"; header("Content-type:application/vnd.ms-excel"); header("Accept-Ranges:bytes"); header("Content-Disposition:filename=".time().".xls"); header("Pragma: no-cache"); echo ' '; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; $res = $GLOBALS['db']->query($sql); while ($row = $GLOBALS['db']->fetchRow($res)) { if($row['user_name']){ $row['user_name']=$row['user_name']; }else{ $row['user_name']='匿名用户'; } echo ''; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ''; } echo '

订单号

会员名

下单时间

收货人

国家

省

市

区

地址

电话

手机

Email

总金额

应付金额

支付方式

配送方式

付款状态

发货状态

$row[order_sn]

$row[user_name]

".date("Y-m-d H:i:s",$row['add_time']+8*3600)."

$row[consignee]

$row[country_name]

$row[province_name]

$row[city_name]

$row[district_name]

$row[address]

$row[tel]

$row[mobile]

$row[email]

$row[total_fee]

$row[order_amount]

$row[pay_name]

$row[shipping_name]

".$_LANG['ps'][$row['pay_status']]."

".$_LANG['ss'][$row['shipping_status']]."

'; ?>