Download the PHP package sukohi/group-wise-filter without Composer
On this page you can find all versions of the php package sukohi/group-wise-filter. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Table of contents
Download sukohi/group-wise-filter
More information about sukohi/group-wise-filter
Files in sukohi/group-wise-filter
Download sukohi/group-wise-filter
More information about sukohi/group-wise-filter
Files in sukohi/group-wise-filter
Vendor sukohi
Package group-wise-filter
Short Description A Laravel package to get row(s) with the group-wise maximum or minimum.
License MIT
Package group-wise-filter
Short Description A Laravel package to get row(s) with the group-wise maximum or minimum.
License MIT
Please rate this library. Is it a good library?
Informations about the package group-wise-filter
GroupWiseFilter
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
All versions of group-wise-filter with dependencies
PHP Build Version
Package Version
Requires
laravel/framework Version
~5.0
The package sukohi/group-wise-filter contains the following files
Loading the files please wait ....