laravel 10
php 8.2
cpanel 110.0.39

我在 seeder 寫了匯入功能，在我的 Windows11, vmware Ubuntu 2204 都正常。但伺服器主機使用 cpanel，卻無反應，而且沒有任何錯誤訊息。

database\seeders\DatabaseSeeder.php

$this->call([

    TimezoneCsvSeeder::class,

    // UserSeeder::class,
    ManagerSeeder::class,
    MemberSeeder::class,
    CountryXlsxSeeder::class,
    LanguageSeeder::class,
    TranslationSeeder::class,
    ...
 

database\seeders\CountryXlsxSeeder.php

<?php

namespace Database\Seeders;

use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\Schema;
use App\Models\MasterData\Country;
use Maatwebsite\Excel\Facades\Excel;

class CountryXlsxSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        Schema::disableForeignKeyConstraints();
        
        Country::truncate();

        $filename = 'database/sheets/ImportSheets/countries.xlsx';

        if (is_file($filename)) {
            echo "doing CountryImport";
            Excel::import(new \Database\Sheets\ImportClasses\CountryImport, $filename);
        }else{
            echo $filename . ' file not exists';exit;
        }

        Schema::enableForeignKeyConstraints();
    }
}

執行
$ ea-php82 artisan db:seed --class=CountryXlsxSeeder
...

INFO Seeding database.

doing CountryImport

$_

為什麼要用 ea-php82，因為這是多版本 php 的 cpanel。

database\sheets\ImportClasses\CountryImport.php

<?php

namespace Database\Sheets\ImportClasses;

use App\Models\MasterData\Country;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\WithStartRow;
use Maatwebsite\Excel\Concerns\WithMultipleSheets;
use Maatwebsite\Excel\Concerns\WithHeadingRow;

class CountryImport implements ToModel,WithStartRow,WithMultipleSheets,WithHeadingRow
{
    public function model(array $row)
    {
        $model = new Country([
            'code'  => $row['code'],
            'name'  => $row['name'],
            'native_name'  => $row['native_name'],
            'iso_code_3'  => $row['iso_code_3'],
        ]);

        return $model;
    }

    public function startRow(): int
    {
        return 2;
    }

    public function sheets(): array
    {
        return [
            'countries' => $this,
        ];
    }
}