织梦cms二次开发订单导出excel表格

织梦教程强烈建议 2024-02-26 11:23 103 0

　　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 xjq_shops_orders as o left join xjq_shops_products as p on o.oid=p.oid left join xjq_shops_delivery as d on d.pid=o.pid LEFT JOIN xjq_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 "

";//数量

　　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'])."