bike-admin/app/Imports/BikesImport.php

<?php

namespace App\Imports;


use App\Models\AdminUserArea;
use App\Models\Area;
use App\Models\Bike;
use App\Utils\Admin;
use Illuminate\Support\Facades\Log;
use Maatwebsite\Excel\Concerns\OnEachRow;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Row;

class BikesImport implements OnEachRow
{
    /**
     * @param array $row
     *
     * @return \Illuminate\Database\Eloquent\Model|null
     */
    public function onRow(Row $row)
    {
        $admin_id = Admin::user()->id;
        $area = Area::query()->where('admin_id', $admin_id)->first();
        // 投放区域id  在导入excle时  默认为改该管理员第一个创建得区域id
        $put_area_id = 0;
        if (!Admin::user()->isRole('administrator')) {
            if (!empty($area)) {
                $put_area_id = $area->id;
            } else {
                //  如果是普通管理员 则显示其自己管理的区域id

                $area_id = AdminUserArea::query()->where('admin_id', $admin_id)->first('area_id');
                $put_area_id = $area_id->area_id ?? 0;

            }
        }

        $row = $row->toArray();
        return Bike::firstOrCreate([
            'bike_no' => $row[0],//车辆编号
        ], [
            'bike_no' => $row[0],//车辆编号
            // 'box_no'    => $row[1],//控制设备
            'put_area_id' => $put_area_id
        ]);
    }

}