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

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

namespace App\Admin\Exports\Company;


use App\Admin\Exports\RowExport;

class JobsExport extends RowExport
{
    /**
     * 设置标题,返回标题数组
     * @return array
     */
    public function headings(): array
    {
        return [
            '职位ID',
            '企业名称',
            '职位名称',
            '所属分站',
            '职位大类',
            '职位中类',
            '职位小类',
            '招聘人数',
            '性别',
            '年龄',
            '学历',
            '工资',
            '联系人',
            '联系方式',
        ];
    }

    /**
     * 处理行数据
     * @param Model $row
     * @return array
     */
    public function map($row): array
    {
        $result['id'] = $row->id;
        $result['companyname'] = $row->company->companyname;
        $result['jobs_name'] = $row->jobs_name;

        if ($row->subsite_id == 0) {
            $result['subsite_id'] = "总站";
        } else {
            $result['subsite_id'] = get_subsite_sitename($row->subsite_id);
        }

        $result['topclass'] = get_job_category($row->topclass);
        $result['category'] = get_job_category($row->category);
        $result['subclass'] = get_job_category($row->subclass);
        if ($row->amount == 0) {
            $result['amount'] = '0';
        } else {
            $result['amount'] = $row->amount;
        }

        switch ($row->sex) {
            case 0:
                $result['sex'] = '不限';
                break;
            case 1:
                $result['sex'] = '男';
                break;
            case 2:
                $result['sex'] = '女';
                break;
        }
        $age = implode('-', $row->age);
        if ($age == '-') {
            $result['age'] = '不限';
        } else {
            $result['age']= $age.'周岁';
        }
        $result['education'] = $row->education?get_category($row->education):'不限';
        if ($row->wage==-1) {
            $result['wage'] = '面议';
        } else if ($row->wage == 0) {
            $result['wage'] = $row->wage_min.'~'.$row->wage_max.'/月';
        } else {
            $result['wage'] = get_category($row->wage);
        }


        $result['contact'] = isset($row->jobsContact->contact)?$row->jobsContact->contact:$row->company->contact;
        $result['mobile'] = isset($row->jobsContact->telephone)?$row->jobsContact->telephone:$row->company->mobile;
        return $result;
    }

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

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