本文由我司收集整编,推荐下载,如有疑问,请与我司联系
PHP生成excel,方法一:header生成
2018/02/09 444 public function export_order() { //搜索条件$where = ‘where 1=1 ‘; $consignee = I(‘consignee’); if($consignee){ $where .= “ AND consignee like ‘%$consignee%’ “; } $order_sn = I(‘order_sn’); if($order_sn){ $where .= “ AND order_sn = ‘$order_sn’ “; } if(I(‘order_status’)){ $where .= “ AND order_status = “.I(‘order_status’); } $timegap = I(‘timegap’); if($timegap){ $gap = explode(‘-’, $timegap); $begin = strtotime($gap[0]); $end = strtotime($gap[1]); $where .= “ AND add_time $begin and add_time $end “; } $sql = “select *,FROM_UNIXTIME(add_time,’%Y-%m-%d’) as create_time from __PREFIX__order $where order by order_id”; $orderList = D()- query($sql); $strTable =‘ table width=“500” border=“1” $strTable .= ‘ tr $strTable .= ‘ td 订单编号/td $strTable .= ‘ td width=“100” 日期/td $strTable .= ‘ td width=“*” 收货人/td $strTable .= ‘ td width=“*” 收货地址/td $strTable .= ‘ td width=“*” 电话/td $strTable .= ‘ td width=“*” 订单金额/td $strTable .= ‘ td width=“*” 实际支付/td $strTable .= ‘ td width=“*” 支付方式/td $strTable .= ‘ td width=“*” 支付状态/td $strTable .= ‘ td width=“*” 发货状态/td $strTable .= ‘ td width=“*” 商品信息/td $strTable .= ‘ /tr if(is_array($orderList)){ $region = M(‘region’)- getField(‘id,name’); foreach($orderList as $k= $val){ $strTable .= ‘ tr $strTable .= ‘ td nbsp;’.$val[‘order_sn’].’ /td $strTable .= ‘ td ‘.$val[‘create_time’].’ /td $strTable .= ‘ td ‘.$val[‘consignee’].’ /td $strTable .= ‘ td ‘.”{$region[$val[‘province’]]},{$region[$val[‘city’]]},{$region[$val[‘district’]]},{$region [$val[‘twon’]]}{$val[‘address’]}”.’ /td $strTable .= ‘ td ‘.$val[‘mobile’].’ /td $strTable .= ‘ td ‘.$val[‘goods_price’].’ /td $strTable .= ‘ td ‘.$val[‘order_amount’].’ /td $strTable .= ‘ td ‘.$val[‘pay_name’].’ /td $strTable .= ‘ td ‘.$this- pay_status[$val[‘pay_status’]].’ /td $strTable .= ‘ td ‘.$this- shipping_status[$val[‘shipping_status’]].’ /td $orderGoods = D(‘order_goods’)-