How to Get Last 7 Days Data in Laravel 10

Introduction

In the ever-evolving landscape of web development, staying up-to-date with the latest technologies and frameworks is essential. Laravel, a PHP web application framework, has consistently been at the forefront of modern web development. With the release of Laravel 10, developers have access to even more powerful tools and features. One common requirement in many applications is the need to retrieve data from the last 7 days. In this tutorial, we will explore how to achieve this efficiently in Laravel 10 without relying on complex or convoluted approaches.

Understanding the Requirement

Before delving into the technical aspects, it's crucial to understand the specific requirements. Retrieving data from the last 7 days implies filtering records based on their creation or update date. In Laravel, this typically involves working with the Eloquent ORM (Object-Relational Mapping) and leveraging the powerful features it provides.

How to Get Last 7 Days Data in Laravel 10

1. Date Filtering with Eloquent

Laravel simplifies date filtering with its eloquent queries. To get data from the last 7 days, we can use the whereDate method along with the > (greater than) operator. Let's take a look at a sample code snippet:

$lastSevenDaysData = YourModel::whereDate('created_at', '>', now()->subDays(7))->get();

In this example, replace YourModel with the actual model class you're working with. The whereDate method ensures that only records with a creation date greater than 7 days ago are retrieved.

2. Creating a Reusable Scope

To enhance code readability and reusability, it's a good practice to create a scope within your model. This allows you to encapsulate the logic for retrieving last 7 days data in a single method. Here's how you can do it:

// Inside your model class
public function scopeLastSevenDays($query)
{
    return $query->whereDate('created_at', '>', now()->subDays(7));
}

Now, you can use this scope wherever needed:

$lastSevenDaysData = YourModel::lastSevenDays()->get();

3. Handling Updates as Well

If your application involves frequent updates to records, it's essential to consider both creation and update dates. You can achieve this by using the orWhereDate method to include records updated in the last 7 days:

$lastSevenDaysData = YourModel::whereDate('created_at', '>', now()->subDays(7))
    ->orWhereDate('updated_at', '>', now()->subDays(7))
    ->get();

This query retrieves records created or updated in the last 7 days.

4. Performance Considerations

While the above approaches work effectively, it's crucial to consider performance, especially when dealing with large datasets. Indexing the relevant columns (created_at and updated_at in this case) can significantly improve query performance. Ensure that these columns are indexed in your database schema for optimal results.

Conclusion

In conclusion, retrieving data from the last 7 days in Laravel 10 is a straightforward process thanks to the expressive and powerful Eloquent ORM. By leveraging the whereDate and orWhereDate methods, along with creating reusable scopes, you can maintain clean and efficient code. Remember to consider performance optimizations, such as indexing, when dealing with substantial datasets.

Whether you're building a new Laravel application or upgrading an existing one to version 10, incorporating these techniques will help you efficiently fetch the data you need. Stay tuned for more Laravel tips and tricks, and happy coding!