Styjun

I've tried importing an excel file into a single table and it worked perfectly, but the problem is, the Census module where it lets the user to add new resident along with the details needed, now every time a user adds a new resident it also reflects to the user table through the use of the user_no foreign key in the Residents Table. I want to achieve that while importing an excel file. is that possible? (pardon me I'm still a newbie with laravel)

here's my code for adding a resident:

public function store(Request $request)


 $residents = new Resident;
 $residents->resident_fname = $request->input('resident_fname');
 $residents->resident_lname = $request->input('resident_lname');
 $residents->resident_mi = $request->input('resident_mi');
 $residents->resident_email = $request->input('resident_email');
 $residents->resident_age = $request->input('resident_age');
 $residents->resident_dob = $request->input('resident_dob');
 $residents->role = 'resident';
 $residents->resident_address = $request->input('resident_address');
 $residents->resident_contact = $request->input('resident_contact');
 $residents->resident_gender = $request->input('resident_gender');
 $residents->ResidentVoter_status = $request->input('ResidentVoter_status');
 $residents->resident_status = $request->input('resident_status');
 $residents->resident_religion = $request->input('resident_religion');
 $residents->resident_purok = $request->input('resident_purok');
 $residents->save();

 $res_id = Resident::orderBy('created_at', 'desc')->first();
 $user = new User;
 $user->name = $request->input('resident_fname');
 $user->email = $request->input('resident_email');
 $user->password = Hash::make('123456');
 $user->role = 'resident';
 $user->res_id = $res_id->id;
 $user->save();

 return redirect('/residents')->with('success', 'Successfully Added!');

Here's my code for the ResidentImport model:

 public function model(array $row)

 return new Resident([
 'resident_fname' => $row[0],
 'resident_lname' => $row[1],
 'resident_mi' => $row[2],
 'resident_dob' => PhpOfficePhpSpreadsheetSharedDate::excelToDateTimeObject($row['3']),
 'role' => $row[4],
 'resident_age' => $row[5],
 'resident_address' => $row[6],
 'resident_contact' => $row[7],
 'resident_email' => $row[8],
 'resident_purok' => $row[9],
 'resident_status' => $row[10],
 'resident_gender' => $row[11],
 'resident_religion' => $row[12],
 'ResidentVoter_status' => $row[13],

 ]);

while this is my ResidentImport Controller:

public function import(Request $request)

 $import = Excel::import(new ResidentImport, request()->file('import_file'));
 return redirect('/importing')->with('success', 'Imported Successfully!');

I absolutely dont have an idea with what to do with this. can anyone help me please?