Grid helper to your Laravel application.
36
7
2
Package Data
Maintainer Username: marcosrjjunior
Package Create Date: 2016-03-01
Package Last Update: 2016-04-06
Home Page:
Language: PHP
License: Unknown
Last Refreshed: 2024-11-11 15:20:31
Package Statistics
Total Downloads: 36
Monthly Downloads: 0
Daily Downloads: 0
Total Stars: 7
Total Watchers: 2
Total Forks: 1
Total Open Issues: 1

lvlGrid

Documentation


Dependencies

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
<link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css">
<script src="https://cdnjs.cloudflare.com/ajax/libs/vue/1.0.16/vue.js"></script>

Installation

First, pull in the package through Composer.

composer require mrjj/lvlgrid

And then include the service provider within app/config/app.php.

'providers' => [
    Mrjj\LvlGrid\LvlGridServiceProvider::class
];

Getting started

First, create add a route to grid method

Route::get('countries/grid', '....Controller@grid');

Use a trait and add a required informations in your controller

use Mrjj\LvlGrid\LvlGrid;

class ..Controller extends Controller
{
    use LvlGrid

    protected $gridModel = \App\Models\Country::class;

    protected $threshold = 30;  
    ...
}

Finally, add this @includes(lvlgrid::...) , lvlgrid component and fill your infos

@extend('default')

@section('scripts')

    @include('lvlgrid::scripts')

@stop

@section('content')
    <h3>lvlGrid</h3>

    @include('lvlgrid::grid')  

    <div id="lvlgrid">

        <lvlgrid
            :data="items"
            :columns="[{
                'key': 'name',
                'name': 'Name'
            },{
                'key': 'monetary',
                'name': 'Monetary unit'
            }]"
            :routes="{
                function: '/countries/grid',
                edit: {
                    column: 'id',
                    name: '/countries/:column/edit'
                },
                delete: {
                    column: 'id',
                    name: '/countries/:column/delete'
                }
            }">
        </lvlgrid>

    </div>  
    ..

Get Data

Add a gridData() method if you want to customize your query

public function gridData()
{
    return DB::table('users')
            ->leftJoin('posts', 'users.id', '=', 'posts.user_id')
}

@return \Illuminate\Database\Query\Builder

Transformer

To transform your data you need add a gridTransformer() method and modify what you want

public function gridTransformer($data)
{
    foreach($data['items'] as $_grid) {
        $_grid->status = trans('form.status.'.$_grid->status);
    }
 }

In this example I'm changing the status for a friendly name like 'Active' and 'Inactive'

If you need to modify the views, you can run:

php artisan vendor:publish --provider="Mrjj\LvlGrid\LvlGridServiceProvider"

The package views will now be located in the app/resources/views/vendor/mrjj/lvlgrid