无法在Laravel 8中导入excel数据。我是新手

Question

**我是laravel8的新手，尝试将数据从excel表导入数据库，这里是我在import类中的代码，它不传递，不会给出任何错误。所以数据库有关系我试图导入数据，并确保关系被考虑，这样我就不会有任何问题**

   <?php
   
   namespace App\Imports;
   
   use Illuminate\Support\Collection;
   use Maatwebsite\Excel\Concerns\ToCollection;
   use App\Models\District;
   use App\Models\Organisation;
   use App\Models\FocalPerson;
   use App\Models\Ta;
   use App\Models\Location;
   use App\Models\Service;
   use App\Models\Category;
   use App\Models\Type;
   
   
   
   
   class InformationImport implements ToCollection
   {
       /**
       * @param array $row
       *
       * @return \Illuminate\Database\Eloquent\Model|null
       */
       public function collection(Collection $rows)
       {
           foreach ($rows as $row) 
           {
               $instance_id = $row[1];
               $organisation_name = $row[2];
               $service_provider = $row[3];
               $catchment_area = $row[4];
               $organisation_type = $row[5];
               $district_name = $row[6];
               $organisation_web = $row[7];
               $primary_name = $row[8];
               $primary_title = $row[9];
               $primary_number = $row[10];
               $primary_email = $row[11];
               $secondary_name = $row[12];
               $secondary_number = $row[13];
               $secondary_title = $row[14];
               $secondary_email = $row[15];
               $services_name = $row[16];
               $location = explode(',',$row[17],2);
               return $location;
               $location_altitude = $row[18];
               $location_accuracy = $row[19];
               $comments_distance = $row[20];
               $data_comments = $row[21];
   
              $ta = Ta::where('name','like','%'.$row[4] .'%')->whereHas('district', 
               function($query) use($district_name){
                  $query->where('name','like','%'.$district_name .'%');
               })->get();
               if(!$ta){
                   $district = District::firstOrCreate([
                       'name' => $row[6]
                   ]);
                   $ta = new Ta;
                   $ta->name = $row[4];
                   $district->tas()->save($ta);
               }
               $gvh = Gvh::firstOrCreate([
                   'name' => 'unknown',
                   'ta_id' => $ta->id
               ]);
               $location = Location::firstOrCreate([
                   'latitude'=>$location,
                   'longitude'=>$location,
                   'gvh_id'=> $gvh->id
               ]);
               $service = Service::firstOrCreate([
                   'name'=>$services_name
               ]);
               $category = Category::firstOrCreate([
                   'name'=>'unknown'
               ]);
               $type = Type::firstOrCreate([
                   'name'=>$organisation_type
               ]);
               $organisation = Organisation::firstOrCreate([
                    'name'=> $organisation_name,
                    'location_id' => $location->id,
                    'organisation_type_id' => $type->id,
                    'organisation_category_id' => $category->id
               ]); 
               $focalperson =FocalPerson::firstOrCreate([
                   'title'=>  $primary_title, $secondary_title,
                   'name' => $primary_name,$secondary_name,
                   'phonenumber'=>$primary_number,$secondary_number,
                   'email'=> $primary_email, $secondary_email
               ]);
           }
       }
       
   }

**下面是我的controller类。在控制器中，这是l所拥有的代码，因为它没有带来任何东西，l必须以这种方式编写它，看看它是否能够输出消息**

 <?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Imports\InformationImport;
use Maatwebsite\Excel\Facades\Excel;

class InformationController extends Controller
{
 
 public function import(Request $request) 
 {
     //Excel::import(new InformationImport, $request->file); 
     //return response()->json(['message' => 'Your data imported successfully !'], 200);
     if ($request->ajax()) {

         try {
 
             Excel::import(new InformationImport, $request->file);
 
             return response()->json(['message' => 'Your data imported successfully !'], 200);
 
         } catch (ValidationException $ex) {
 
             $failures = $ex->failures();
             foreach ($failures as $failure) {
                 return response()->json(['message' => 'Row - ' . $failure->row() . ', ' . $failure->errors()[0]], 500);
             }
 
         }
 
     }
     return response()->json(['message' => 'Something went wrong !'], 500);
 }
 
}

Answer 1

   public function import(Request $request) 
   {
       ini_set('max_execution_time', -1);
       ini_set('memory_limit ', -1);
      
       if ($request->ajax()) {

          try {
             $file_content = $request->file('excel');
             $file_name = time() . '.xlsx';

             Storage::disk('local')->putFileAs('public', $file_content, $file_name);
             $url = "/app/public/" . $file_name;
             $path = storage_path() . $url;
             Excel::import(new InformationImport, $path);
 
             return response()->json(['message' => 'Your data imported successfully !'], 200);
 
         } catch (ValidationException $ex) {
 
             $failures = $ex->failures();
             foreach ($failures as $failure) {
                 return response()->json(['message' => 'Row - ' . $failure->row() . ', ' . $failure->errors()[0]], 500);
             }
         }
      }
      return response()->json(['message' => 'Something went wrong !'], 500);
     }