Most applications require charts or reports to be generated. Doing this over again, and again can be a painful process. That's why Flowframe has created a fluent Laravel package called Laravel Trend to solve this problem. You can aggregate average, min, max, and totals per minute, hour, day, month, and year. Laravel Trend packages allow you to easily generate trends for your models.
This package requires PHP 8 or higher.
You can install the package via composer:
composer require flowframe/laravel-trend
To generate a trend for your model, import the
Flowframe\Trend\Trend class and pass along a model or query.
// Totals per month $trend = Trend::model(User::class) ->between( start: now()->startOfYear(), end: now()->endOfYear(), ) ->perMonth() ->count(); // Average user weight where name starts with a over a span of 11 years, results are grouped per year $trend = Trend::query(User::where('name', 'like', 'a%')) ->between( start: now()->startOfYear()->subYears(10), end: now()->endOfYear(), ) ->perYear() ->average('weight');
You must either start a trend using
::query(). The difference between the two is that using
::query() allows you to add additional filters, just like you're used to using eloquent. Using
::model() will just consume it as it is.
// Model Trend::model(Order::class) ->between(...) ->perDay() ->count(); // More specific order query Trend::query( Order::query() ->hasBeenPaid() ->hasBeenShipped() ) ->between(...) ->perDay() ->count();
You can use the following aggregates intervals:
You can use the following aggregates:
We currently support three drivers:
For more details, Visit Github
If you are looking for a custom CRM system or eCommerce web application for your enterprise, then we are here to help you. The Web development team at Codebrisk has notable experience in the Laravel e-commerce and CRM web development field. We can provide you with custom-made e-commerce web applications with a lot of cutting-edge features and options. We will be pleased to assist you with your projects. Please feel free to contact us or you can launch a project with us.
Published at : 04-07-2022
I am a highly results-driven professional with 12+ years of collective experience in the grounds of web application development especially in laravel, native android application development in java, and desktop application development in the dot net framework. Now managing a team of expert developers at Codebrisk.