sukohi / group-wise-filter
A Laravel package to get row(s) with the group-wise maximum or minimum.
2.0.3
2016-03-15 10:30 UTC
Requires
- laravel/framework: ~5.0
This package is not auto-updated.
Last update: 2024-11-06 23:37:21 UTC
README
A Laravel package to get row(s) with the group-wise maximum or minimum.
(This is for Laravel 5+. For Laravel 4.2)
Installation
Execute composer command.
composer require sukohi/group-wise-filter:2.*
Preparation
In your model, set GroupWiseFilterTrait.
use Sukohi\GroupWiseFilter\GroupWiseFilterTrait;
class Item extends model
{
use GroupWiseFilterTrait;
}
Now you can call groupMax()
and groupMin()
.
Usage
Simplest Way
$column = 'amount';
$group_by = 'area_id';
$items = \App\Item::groupMax($column, $group_by)->get();
with select(), where() and so on..
You should add table name like this.
$items = \App\Item::select(
'items.id',
'items.title'
'items.area_id'
);
Order by Group
\App\Item::orderByGroup('ASC');
\App\Item::orderByGroup('DESC');
Grouped table and Grouped table
You can use GROUP_TABLE
and GROUP_VALUE
like this.
$items = \App\Item::select('GROUP_TABLE.GROUP_VALUE');
License
This package is licensed under the MIT License.
Copyright 2016 Sukohi Kuhoh