get data after saving the excel file with an ID of saved

[yakovcohen4]

Project in Laravel (9), and PHP (8.1).

I can import a file, and save the file into the model, like this:

import class:

class BankTransfersHistoryImport implements ToModel, WithHeadingRow, WithValidation
{
    use Importable;

/**
 * @param array $row
 *
 * @return \Illuminate\Database\Eloquent\Model|null
 */
    public function model(array $row)
    {
        return new BankTransfersHistory([    
            'loanId' => $row['loanId'],
            'actionDate' => transformDate($row['actionDate']),
            'worth' => $row['worth'],
            .
            .
        ]);
    }

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

    public function rules(): array
    {
        return [ 
            '*.loanId' => ['required', 'numeric'],
            ... some roles ...
        ];
    }
}

controller:

public function store(Request $request)
    {
        $request->validate([
            'file' => 'required|mimes:xls,xlsx',
        ]);

        $file = $request->file('file');

        $import = new BankTransfersHistoryImport;

        try {
            // date validation
            $collection = $import->toCollection($file);
            ... some validation about the date ...

            $import->import($file);
            ... check and update rows ...

            return [
                "message" => some message,
                "data" => [
                    some data
                ],
            ];

        } catch (\Maatwebsite\Excel\Validators\ValidationException$e) {
            $failures = $e->failures();

            foreach ($failures as $failure) {
                $failure->row(); // row that went wrong
                $failure->attribute(); // either heading key (if using heading row concern) or column index
                $failure->errors(); // Actual error messages from Laravel validator
                $failure->values(); // The values of the row that has failed.
            }
            return $failures;
      }

My question is:

If I can get the response of the file after saving the data, that will give me the data with the id of the row that was saved.

In some cases, I will have to update a row. That's why I would like to get the ID.

Now in the check and update rows section, I update by loanId + actionDate. I want it to be done by ID.

---

something like this:

code:
$data = $import->import($file);

data will be like:

[
    {
        "id": 1,
        "loanId": 21001,
        "actionDate": "2020-01-02T00:00:00.000000Z",
        "worth": 2997.09,
        "offerId": 1,
    },
    {
        "id": 2,
        "loanId": 21002,
        "actionDate": "2020-01-02T00:00:00.000000Z",
        "worth": 3000,
        "offerId": 10,
    },
]

[yakovcohen4]

I try to create a function on the import class that will return the imported data.
But I get the information back without the ID of each object.

code of import class :

class BankTransfersHistoryImport implements ToModel, WithHeadingRow, WithValidation, WithBatchInserts
{
    use Importable;

    private $rows;

    public function __construct()
    {
        $this->rows = collect();
    }

/**
 * @param array $row
 *
 * @return \Illuminate\Database\Eloquent\Model|null
 */
    public function model(array $row)
    {
        $bankTransferHistory = new BankTransfersHistory([    
            'loanId' => $row['loanId'],
            'actionDate' => transformDate($row['actionDate']),
            'worth' => $row['worth'],
            .
            .
        ]);

        $this->rows->push($bankTransferHistory);
        return $bankTransferHistory;
    }

    /**
     * Returns Imported Data
     *
     * @return \Illuminate\Support\Collection
     */
    public function getImportedData(): \Illuminate\Support\Collection
    {
        return $this->rows;
    }

code of controller

public function store(Request $request)
    {
        $request->validate([
            'file' => 'required|mimes:xls,xlsx',
        ]);

        $file = $request->file('file');

        $import = new BankTransfersHistoryImport;

        try {
            // date validation
            $collection = $import->toCollection($file);
            ... some validation about the date ...

            $import->import($file);
            ... check and update rows ...

            $data = $import->getImportedData();

            return [
                 --- some return with data... ---
            ];

        } catch (\Maatwebsite\Excel\Validators\ValidationException$e) {
            $failures = $e->failures();

            foreach ($failures as $failure) {
                $failure->row(); // row that went wrong
                $failure->attribute(); // either heading key (if using heading row concern) or column index
                $failure->errors(); // Actual error messages from Laravel validator
                $failure->values(); // The values of the row that has failed.
            }
            return $failures;
      }

[yakovcohen4]

Can someone help me?

[VanNam0507]

i have same issue

[yakovcohen4]

I solved this problem, I will update my answer here. @VanNam0507

[yakovcohen4]

I solved my problem. this is my answer:

I change the ToModel method to ToCollection method.

Because of the foreach in ToCollection method I can add each row to the data variable, and use the getImportedData function that returns the data

Import class:

class BankTransfersHistoryImport implements ToCollection, WithHeadingRow, WithValidation, WithEvents
{
    use Importable, RegistersEventListeners;

    private $data;

    public function __construct()
    {
        $this->data = collect();
    }

/**
 * @param array $row
 *
 * @return \Illuminate\Database\Eloquent\Model|null
 */
    public function collection(Collection $rows)
    {
        foreach ($rows as $row) {
            $bankTransferHistory = BankTransfersHistory::create([
                 'loanId' => $row['loanId'],
                 'actionDate' => transformDate($row['actionDate']),
                 'worth' => $row['worth'],
                 ...
            ]);

            $this->data->push($bankTransferHistory);
        }
    }

    /**
     * Returns Imported Data
     *
     * @return \Illuminate\Support\Collection
     */
    public function getImportedData(): \Illuminate\Support\Collection
    {
        return $this->data;
    }

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

    public function rules(): array
    {
        return [
            // --- some rules --- //
        ];
    }

}

Controller:

 $request->validate([
            'file' => 'required|mimes:xls,xlsx',
        ]);

        $file = $request->file('file');

        $import = new BankTransfersHistoryImport;

        try {
          
            // date validation
            $collection = $import->toCollection($file);
            ... some validation about the date ...

            $import->import($file);
            $importedData = $import->getImportedData(); // data after save in DB
           ... check and update rows ...

            return [
                "message" => some message,
                "data" => [
                    some data
                ],
            ];

        } catch (\Maatwebsite\Excel\Validators\ValidationException$e) {
            $failures = $e->failures();

            foreach ($failures as $failure) {
                $failure->row(); // row that went wrong
                $failure->attribute(); // either heading key (if using heading row concern) or column index
                $failure->errors(); // Actual error messages from Laravel validator
                $failure->values(); // The values of the row that has failed.
            }
            return $failures;
        }

It solved the problem for me, I hope this solution will help those who came here ..