海豚框架 --导出Excel

海豚文档

 //数据导出
    public function export()
    {
        // 查询数据
        $map = $this->getMap();

        //单独拼接组合查询
        $orders = new Order();
        $data_list = $orders::where($map)->order("id DESC")->select();
        $data=[];
        foreach ($data_list as $item=>$value){
            $czje=Db::name('user')->where('id',$value['user_id'])->field("nickname,avatar")->find();
            $channel=Db::name('channel')->where('id',$value['channel_id'])->field("name")->find();
            $product=Db::name('product')->where('id',$value['product_id'])->field("name")->find();
            $data[$item]=[
                "id"=>$value['id'],
                "out_trade_no"=>$value['out_trade_no'],
                "user_id"=>(isset($czje['nickname']))?$czje['nickname']:"未知",
                "pay_fee"=>$value['pay_fee'],
                "status"=>($value['status']==1)?"已支付":"未支付",
                "time_end"=>($value['time_end'])?date("Y-m-d H:i:s",$value['time_end']):0,
                "administrator_id"=>$value['administrator_id'],
                "channel_name"=>(isset($channel['name']))?$channel['name']:"未知",
                "product_name"=>(isset($product['name']))?$product['name']:"未知",
            ];
        }

        // 设置表头信息（对应字段名,宽度，显示表头名称）
        $cellName = [
            ['id', 'auto', 'ID'],
            ['out_trade_no', 'auto', '订单号'],
            ['user_id', 'auto', '用户昵称'],
            ['pay_fee', 'auto', '订单金额(:分)'],
            ['status', 'auto', '订单状态'],
            ['time_end', 'auto', '支付时间'],
            ['administrator_id', 'auto', '服务商ID'],
            ['channel_name', 'auto', '渠道昵称'],
            ['product_name', 'auto', '产品名称']
        ];

        // 调用插件（传入插件名，[导出文件名、表头信息、具体数据]）
        plugin_action('Excel/Excel/export', [time(), $cellName, $data]);
    }