php导出excel

if (!empty(input(‘export’))){
$list = Db::name(‘third_order’)->alias(‘to’)
->join(‘user u’,’to.user_id = u.id’,’LEFT’)
->join(‘third_order_detail tod’,’tod.order_id = to.id’,’LEFT’)
->field(‘to.*, u.nickname as user_name, tod.use_times’)
->where(‘tod.order_type = 3’)
->where($where)
->order(‘to.id desc’)
->select();
// print_r($list);exit;
$content = [];

            foreach ($list as $k => $v) {<br />                    if (isset($v['order_type_id'])) {<br />                        switch ($v['order_type_id']) {<br />                            case 1:<br />                                $order_type = '组合';<br />                                break;<br />                            case 2:<br />                                $order_type = '普通';<br />                                break;<br />                        }<br />                    }
                if (isset($v['order_status'])) {<br />                        switch ($v['order_status']) {<br />                            case 0:<br />                                $order_status = '待支付';<br />                                break;<br />                            case 1:<br />                                $order_status = '使用中';<br />                                break;<br />                            case 2:<br />                                $order_status = '使用完成';<br />                                break;<br />                            case 3:<br />                                $order_status = '已取消';<br />                                break;<br />                            case 4:<br />                                $order_status = '已退款';<br />                                break;<br />                        }<br />                    }
                if (isset($v['is_passed'])) {<br />                        switch ($v['is_passed']) {<br />                            case 1:<br />                                $is_passed = '未过期';<br />                                break;<br />                            case 2:<br />                                $is_passed = '已过期';<br />                                break;<br />                        }<br />                    }
                if (isset($v['order_channel'])) {<br />                        switch ($v['order_channel']) {<br />                            case 0:<br />                                $order_channel = '实体卡';<br />                                break;<br />                            case 1:<br />                                $order_channel = '微信小程序';<br />                                break;<br />                            case 2:<br />                                $order_channel = '美团';<br />                                break;<br />                            case 3:<br />                                $order_channel = '美团扫码下单';<br />                                break;<br />                            case 4:<br />                                $order_channel = '支付宝小程序';<br />                                break;<br />                            case 5:<br />                                $order_channel = '美团活动票';<br />                                break;<br />                            case 6:<br />                                $order_channel = '携程';<br />                                break;<br />                            case 7:<br />                                $order_channel = '票付通';<br />                                break;<br />                        }<br />                    }
                $content[] = [<br />                        $v['id'],<br />                        $v['order_num'],<br />                        $order_type,<br />                        $v['user_name'],<br />                        $v['product_name'],<br />                        $v['type_name'],<br />                        $v['supplier_name'],<br />                        $v['order_count'],<br />                        $v['use_times'],<br />                        $v['order_price'],<br />                        $order_status.','.$is_passed,<br />                        $order_channel,<br />                        $v['channel_num'],<br />                        $v['create_time'] ? date('Y-m-d H:i:s', $v['create_time']) : ''<br />                    ];<br />                }
            $header = ['序号','订单号','订单类型','下单用户','产品名称','产品类型','供应商','订单数量','使用数量','订单金额','订单状态','订单渠道','渠道单号','下单时间'];<br />                $filename = '第三方产品订单'.date('YmdHis',time());<br />                $sheetName = '第三方产品订单'.time();<br />                $adminName = '';<br />                $admin['nickname'] = session('service_gh');<br />                // print_r($_SESSION);exit;<br />                if(!empty($admin)){<br />                    $adminName = $admin['nickname'] ? $admin['name'] : '';<br />                }
            $subTitle = '导出人：'.$adminName.' 导出时间：'.date('Y-m-d H:i:s',time());<br />                export_excel($filename,$subTitle,$header,$content,$sheetName);<br />                exit;<br />}