织梦dedecms订单列表导出到excel表的代码教程

else if ($dopost == 'out')

{

header("Content-type:application/vnd.ms-excel");

header("Content-Disposition:attachment;filename=".date("Y-m-d-H-i-s").".xls");

echo "";

echo "";

echo "";

echo "";

echo "";

echo "";

echo "";

echo "";

echo "";

echo "";

echo "";

echo "";

echo "";

echo "";

echo "";

echo "";

echo "";

$wh = '';

if( !empty($nid) )

{

$nids = explode('`',$nid);

foreach($nids as $n)

{

if($wh=='') $wh = " WHERe o.oid='$n' ";

else $wh .= " OR o.oid='$n' ";

}

}

$sql = "SELECT o.*,p.title,p.price as uprice,d.dname,u.* FROM dede_shops_orders as o left join dede_shops_products as p on o.oid=p.oid left join dede_shops_delivery as d on d.pid=o.pid LEFT JOIN dede_shops_userinfo AS u ON o.oid=u.oid $wh";

$dsql->SetQuery($sql);

$dsql->Execute('t');

while($arr = $dsql->GetArray('t'))

{

echo "";

echo "";//订单号

echo "";//商品名称

echo "";//单价

echo "";//数量 www.dede58.com织梦模板

echo "";//支付方式

echo "";//配送费

echo "";//购买时间

echo "";//收货人

echo "";//地址

echo "";//邮编

echo "";//联系电话

echo "";//邮箱

echo "";//留言

echo "";//合计

echo "";//状态

echo "";

}

echo "
订单号
商品名称
单价(元/单位)
数量
支付方式
配送费
购买时间
收货人
地址
邮编
联系电话
邮箱
留言
合计(元)
状态
".$arr['oid']."
".$arr['title']."
".$arr['uprice']."
".$arr['cartcount']."
".GetsType($arr['paytype'])."
".$arr['dname']."费用:".$arr['dprice']."元
".GetDateTimeMk($arr['stime'])."
".$arr['consignee']."
".$arr['address']."
".$arr['zip']."
".$arr['tel']."
".$arr['email']."
".$arr['des']."
".$arr['priceCount']."
".GetSta($arr['state'])."
";

exit();

}