jucai/app/Admin/Exports/Jobfairout/PersonExport.php

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

namespace App\Admin\Exports\Jobfairout;

use App\Admin\Exports\RowExport;

class PersonExport extends RowExport
{
    /**
     * 设置标题,返回标题数组
     * @return array
     */
    public function headings(): array
    {
        return [
            '序号',
            '姓名',
            '性别',
            '单位名称',
            '联系方式',
            '身份证',
            '备注',
            '填报时间'
        ];
    }

    /**
     * 处理行数据
     * @param Model $row
     * @return array
     */
    public function map($row): array
    {
        static $i=1;
        $result['index'] = $i;
        $result['name'] = $row->name1;
        $result['name'] = $row->name1;
        $result['sex'] = $row->sex1 == 1 ? '男' : '女';
        $result['companyname'] = $row->companys->companyname;
        $result['phone'] = $row->phone1;
        $result['id'] = $row->id1;
        $result['intro'] = $row->intro;
        $result['created_at'] = $row->created_at;
        $i++;
        return $result;
    }

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

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

}