jucai/app/Admin/Exports/PersonalTalents/PersonalTalentsExport.php

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

namespace App\Admin\Exports\PersonalTalents;

use App\Admin\Exports\RowExport;

class PersonalTalentsExport extends RowExport
{
    /**
     * 设置标题,返回标题数组
     * @return array
     */
    public function headings(): array
    {
        return [
            '会员名称',
            '人才等级',
            '人才来源',
            '审核状态',
            '完结状态',
            '所属客服',
            '创建时间'
        ];
    }

    /**
     * 处理行数据
     * @param Model $row
     * @return array
     */
    public function map($row): array
    {
        $result['rc_username'] = $row->rc_username;
        if ($row->ifconform == 1) {
            $result['ifconform'] = $row->rc_level;
        } elseif ($row->ifconform == 2) {
            $result['ifconform'] = '不符合人才标准';
        }
        if ($row->rc_where == 1) {
            $result['rc_where'] = '自主申报';
        } elseif ($row->rc_where == 2) {
            $result['rc_where'] = '企业申报';
        } elseif ($row->rc_where == 3) {
            $result['rc_where'] = '信息采集';
        }

        if ($row->rc_audit == 1) {
            $result['rc_audit'] = '认证通过';
        } elseif ($row->rc_audit == 2) {
            $result['rc_audit'] = '预判';
        } elseif ($row->rc_audit == 3) {
            $result['rc_audit'] = '认证不通过';
        }

        if ($row->if_finish == 1) {
            $result['if_finish'] = '已完结';
        } else {
            $result['if_finish'] = '未完结';
        }

        $result['admin_id'] = isset($row->admin_user->name) ? $row->admin_user->name : '';
        $result['created_at'] = $row->created_at;
        return $result;
    }

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

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

}