Скачать или смотреть How to Exclude Employees with Special Characters in Eloquent Queries

Learn how to easily filter out employees with specific criteria in Laravel Eloquent queries while maintaining clean and effective database interactions.
---
This video is based on the question https://stackoverflow.com/q/62727470/ asked by the user 'mikefolu' ( https://stackoverflow.com/u/12510040/ ) and on the answer https://stackoverflow.com/a/62727548/ provided by the user 'FightInGlory' ( https://stackoverflow.com/u/6874821/ ) 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 exclude employees with special character in their email in Eloquent

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.
---
Excluding Employees with Special Characters in Eloquent Queries

In the world of web development, handling employee records efficiently is crucial, especially when dealing with large datasets. A common issue developers face is the need to filter out records based on certain conditions. For instance, in a Laravel application, you may need to exclude employees whose identifiers contain specific keywords or patterns, such as "retired" in their employee numbers. In this guide, we will explore how to achieve this using Eloquent, Laravel's built-in ORM (Object-Relational Mapping) tool.

The Problem: Excluding Retired Employees

Let's say you have a column in your database called employee_number, which can contain values like retired-110, retired-221, and so on. Your goal is to retrieve a list of employees without including those who have a retired status in their employee_number. This is essential for ensuring that you are only working with active employees, particularly if the retired employees should not be included in certain operations, such as sending notifications or generating reports.

The Solution: Using Eloquent Queries

To filter out the retired employees from your query, you can leverage Laravel's query builder with the NOT LIKE condition. Here's how you can structure your Eloquent query to exclude employees that meet this criterion.

Example Code

Below is the code snippet that effectively retrieves the desired employees:

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

Explanation of the Code

Select from HrEmployee: The query begins by accessing the HrEmployee model, which corresponds to the database table containing your employee records.

Filtering by Company ID: The where('company_id', $userCompany) method ensures that only employees belonging to the specific company specified by $userCompany are considered.

Checking Employee Status: The where('is_status', 0) condition filters out employees that are not active. In this scenario, we're only looking for active employees by checking for a status value of 0.

Excluding Retired Employees: The crucial part of the query comes next - where('employee_number', 'NOT LIKE', 'retired%'). This condition specifies that we want to exclude any employee numbers that begin with the string retired. The % acts as a wildcard, allowing for any characters to follow retired.

Retrieving the Results: Finally, the get() method executes the query and retrieves the results as a collection of employee records.

Conclusion

Filtering records in Laravel with Eloquent is not just straightforward but also powerful. By using conditions like NOT LIKE, you can manage your datasets more effectively and ensure that you are working with the right information. The example provided illustrates how to exclude employees with unwanted patterns, making your queries cleaner and your application logic more precise.

Now that you know how to exclude employees with specific criteria in your Eloquent queries, you can implement similar strategies to maintain the integrity and accuracy of your application's data.