jucai/app/Admin/Exports/Jobfairout/JobsExport.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 JobsExport extends RowExport
{
    /**
     * 设置标题,返回标题数组
     * @return array
     */
    public function headings(): array
    {
        return [
            '职位名称',
            '发布公司',
            '招聘会标题',
            '招聘人数',
            '工作地区',
            '所属分站',
            '性别',
            '年龄',
            '学历',
            '工资',
            '单位地址',
            '报名时间',
        ];
    }

    /**
     * 处理行数据
     * @param Model $row
     * @return array
     */
    public function map($row): array
    {
        static $i=1;
        $result['jobs_name'] = $row->jobs_name;
        $result['company_name'] = $row->company_name;
        $result['title'] = $row->jobfairs->title;
        $result['amount'] =  empty($row->amount) ? '若干': $row->amount;$row->amount;
        $result['district_cn'] = empty($row->district_cn) ? '不限': $row->district_cn;$row->district_cn;
        $result['subsite'] = empty($row->jobfairs->sitename->sitename) ? '总站': $row->jobfairs->sitename->sitename;
        $result['sex'] = empty($row->sex_cn) ? '不限': $row->sex_cn;
        $result['age'] = $row->age == '-'|| empty($row->age) ? '不限' :$row->age;
        $result['education'] = empty($row->education_cn) ? '不限': $row->education_cn;
        $result['wage_cn'] = empty($row->wage_cn) ? '不限': $row->wage_cn;
        $result['address'] = $row->companys->address;
        $result['created_at'] = $row->created_at;
        $i++;
        return $result;
    }

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

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

}