这个文件放到 根目录下，执行下就可以下载订单信息。这个是下载全部的订单
如果需要判断条件，那么在sql语句中加where条件就可以了
如果上面的有报错，用下面这个试下 或者是更改2.7.2 beta 版init.php中的
if (defined('DEBUG_MODE') == false)
{
define('DEBUG_MODE', 1);
}
修改为
if (defined('DEBUG_MODE') == false)
{
define('DEBUG_MODE', 0);
}
全部代码如下：
<?php
define('IN_ECS', true);
include ('includes/init.php');
$filename='orderexcel';
header("Content-type: application/vnd.ms-excel; charset=gbk");
header("Content-Disposition: attachment; filename=$filename.xls");
$data='订单号'."\t";
$data.='购货人'."\t";
$data.='支付方式'."\t";
$data.='配送方式'."\t";
$data.='收货人'."\t";
$data.='收货地址'."\t";
$data.='电话'."\t";
$data.='下单时间'."\t";
$data.='商品名称'."\t\n";
$sql="select o.order_sn,o.consignee,o.address,o.tel,o.add_time,o.shipping_name,o.pay_name,g.goods_name,g.goods_attr,g.goods_number,u.user_name from ". $GLOBALS['ecs']->table('order_info').
" as o left join " . $GLOBALS['ecs']->table('users')." as u on o.user_id=u.user_id "."left join ". $GLOBALS['ecs']->table('order_goods')." as g on o.order_id=g.order_id ";
$res=$db->getAll($sql);
//print_r($res);
//echo $sql;
while (!empty($res))
{
foreach ($res as $key=>$var)
{
$res1[$key]['add_time']='';
$res1[$key]['goods']='';
$res1[$key]['address']='';
$res1[$key]['consignee']='';
$res1[$key]['pay_name']='';
$res1[$key]['user_name']='';
$res1[$key]['order_sn']='';
$res1[$key]['tel']='';
$res1[$key]['shipping_name']='';
$a=$var['order_sn'];
foreach ($res as $keys=>$vars)
{
if($a==$vars['order_sn'])
{
$res1[$key]['order_sn']=$vars['order_sn'];
$res1[$key]['user_name']=$vars['user_name'];
$res1[$key]['pay_name']=$vars['pay_name'];
$res1[$key]['shipping_name']=$vars['shipping_name'];
$res1[$key]['consignee']=$vars['consignee'];
$res1[$key]['address']=$vars['address'];
$vars['goods_attr']= trim($vars['goods_attr']);
$res1[$key]['goods'].="$vars[goods_name] $vars[goods_attr] $vars[goods_number]"."\n";
$res1[$key]['tel'] .= $vars['tel'];
$res1[$key]['add_time']=date('y-m-d h:i:s',$vars['add_time']);
unset ($res[$keys]);
}
}
}
}
foreach ($res1 as $key =>$var)
{
$data.=$var['order_sn']."\t";
$data.=$var['user_name']."\t";
$data.=$var['pay_name']."\t";
$data.=$var['shipping_name']."\t";
$data.=$var['consignee']."\t";
$data.=$var['address']."\t";
$data.=$var['tel']."\t";
$data.=$var['add_time']."\t";
$data.="\"";
$data.=$var['goods']."\"";
$data.="\t\n";
}
if (EC_CHARSET != 'gbk')
{
echo ecs_iconv(EC_CHARSET, 'gbk', $data) . "\t";
}
else
{
echo $data. "\t";
}
//print_r($res1);
?> |
