jucai/app/Admin/Exports/Company/CompanyExport.php

<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2019/4/13
 * Time: 10:29
 */

namespace App\Admin\Exports\Company;

use App\Admin\Exports\RowExport;
use PhpOffice\PhpSpreadsheet\Style\NumberFormat;
use APP\Models\Jobs;

class CompanyExport extends RowExport
{
    /**
     * 设置标题,返回标题数组
     * @return array
     */
    public function headings(): array
    {
        return [
            '企业ID',
            '企业名称',
            '所属分站',
            '认证状态',
            '公司地址',
            '企业性质',
            '所属行业',
            '企业规模',
            '企业联系人',
            '手机号码',
            '固定号码',
            'email',
            '套餐名称',
            '社会统一信用码',
            '创建时间'
            ];
    }

    /**
     * 处理行数据
     * @param Model $row
     * @return array
     */
    public function map($row): array
    {
        $result['id'] = $row->id;
        $result['companyname'] = $row->companyname;
        $result['subsite_id'] = $row->subsite_id==0?"总站":get_subsite_sitename($row->subsite_id);
        switch ($row->audit) {
            case 0:
                $result['audit'] = '未审核';
                break;
            case 1:
                $result['audit'] = '审核通过';
                break;
            case 2:
                $result['audit'] = '审核中';
                break;
            case 3:
                $result['audit'] = '审核未通过';
                break;
        }
        $result['address'] = $row->address;
        $result['nature'] = get_category($row->nature)?:"无";
        $result['trade'] = get_category($row->trade)?:"无";
        $result['scale'] = get_category($row->scale)?:"无";
        $result['contact'] = $row->contact;
        $result['mobile'] = $row->mobile;
        $result['landline_tel'] = $row->landline_tel;
        $result['email'] = $row->email;
        $result['setmeal_name'] = $row->setmeal_name;
        $result['organization_code'] = $row->organization_code;
        $result['created_at'] = $row->created_at;
        return $result;
    }

    /**
     * 设置文件名
     * @return string
     */
    public function getFilename(): string
    {
        return "company.xlsx";
    }

    /**
     * 格式化指定列.
     * 只有在需要的时候设置,例如在身份证不要显示科学计数时设定列格式:['A'=>NumberFormat::FORMAT_NUMBER]
     * @return array
     */
    public function columnFormats(): array
    {
        return [
        ];
    }

}