Скачать или смотреть How to Find Data in Other Row with Laravel Excel

A Comprehensive Guide on How to Use `Maatwebsite Excel` in Laravel to Find and Link Data Between Rows
---
This video is based on the question https://stackoverflow.com/q/72055595/ asked by the user 'Cohchi' ( https://stackoverflow.com/u/7734861/ ) and on the answer https://stackoverflow.com/a/72067363/ provided by the user 'Anuj Kumar' ( https://stackoverflow.com/u/18875812/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: How to find data in other row with laravel-excel

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Find Data in Other Row with Laravel Excel

When dealing with Excel file imports in a Laravel application, many developers encounter the challenge of relating data between different rows. One common scenario involves needing to reference a previously imported record while processing another. In this guide, we’ll dive into how you can achieve this using Maatwebsite Excel package in Laravel.

The Problem

Let’s outline the problem you may be facing. Suppose you are importing an Excel file that contains multiple entries, each with a Ref and toRef column. Your goal is to import this data into your database while ensuring that the toRef_id field of each record refers to the ID of the corresponding record where the Ref matches the toRef.

Here's a brief example of what your data might look like:

RefNametoRefFirstMy first datanullSecondSecond datanullThirdMy third dataFirstIn the above data, when the first row is inserted, its toRef_id will be null as there is no prior entry.

When the second row is processed, toRef_id remains null.

For the third row, you will want to set toRef_id to the ID associated with the First entry from the first row of your data.

The Solution

To implement this functionality in your Laravel controller, we will modify your CustomImport class to track the last imported row's ID and use it to set the toRef_id on subsequent imports.

Step 1: Update the Controller

Make sure your controller is set up to leverage the CustomImport class correctly. You already have a basic structure like this:

[[See Video to Reveal this Text or Code Snippet]]

Step 2: Modify the CustomImport Class

Next, you need to update your CustomImport class to include logic for storing the last created row's ID and setting the toRef_id based on the toRef column.

Here’s an updated version of the CustomImport class:

[[See Video to Reveal this Text or Code Snippet]]

Breakdown of the Code

Storing Previous Row's ID:

You check if the toRef field in the current row has a value.

If it does, you query the database to find the ID of the record where Ref matches the toRef.

Creating New Records:

When creating a new instance of your model, you pass the fetched ID for the toRef_id.

Conclusion

By utilizing the Maatwebsite Excel package in conjunction with Eloquent's querying capabilities, you can effectively manage related data entries during import processes. This technique not only keeps your database organized but also maintains data integrity across your records.

Now you should be well-equipped to handle row-specific data relationships during your Excel imports in Laravel. Happy coding!