PHP Data Grid View: Display data in an editable grid on a Web page

Recommend this page to a friend!

Download

Info

Example

Files

Install with Composer

Download

Reputation

Support forum

Blog

Links

Ratings				Unique User Downloads		Download Rankings
Not enough user ratings				Total: 150 This week: 1		All time: 9,088 This week: 42

Version		License		PHP version		Categories
`mesour-datagrid` 1.0.0		Custom (specified...		5		HTML, PHP 5, Databases, Files and Fol...

Description

Author

Matous Nemec

This package can display data in an editable grid on a Web page.

It can take the path of PHP script that can be executed to set a data variable that contains the data to be displayed in data grid using HTML tables.

The class can also render the data grid table with the possibility to display controls that allow editing the grid values, create sub-grids, sorting data dynamically, and export grid data to CSV files for download.

Matous Nemec

Name:	Matous Nemec `<contact>`
Classes:	8 packages by Matous Nemec
Country:	Czech Republic

Innovation award

Nominee: 2x

Example


<?php



define('SRC_DIR', __DIR__ . '/../src/');



require_once __DIR__ . '/../vendor/autoload.php';



@mkdir(__DIR__ . '/log');

@mkdir(__DIR__ . '/temp');



\Tracy\Debugger::enable(\Tracy\Debugger::DEVELOPMENT, __DIR__ . '/log');

\Tracy\Debugger::$strictMode = true;



$loader = new Nette\Loaders\RobotLoader;

$loader->addDirectory(__DIR__ . '/../src');

$loader->setCacheStorage(new Nette\Caching\Storages\FileStorage(__DIR__ . '/temp'));

$loader->register();



?>



<!-- Latest compiled and minified CSS -->

<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css"

      integrity="sha384-1q8mTJOASx8j1Au+a5WDVnPi2lkFfwwEAa8hDDdjZlpLegxhjVME1fgjWPGmkzs7" crossorigin="anonymous">

<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.5.0/css/font-awesome.min.css">



<link rel="stylesheet" href="../node_modules/eonasdan-bootstrap-datetimepicker/build/css/bootstrap-datetimepicker.min.css">



<link rel="stylesheet" href="../node_modules/mesour-datagrid/dist/css/mesour.datagrid.min.css">



<style>

    .input-group-btn:last-child > .btn[data-simple-filter] {

        padding: 9px;

    }

</style>



<hr>



<div class="row col-lg-12" style="padding-left: 50px;">

    <h2>Basic functionality</h2>



    <hr>



    <?php



    $time_start = microtime(true);



    $sourceFile = 'nette_source';

    $primaryKey = 'userId';



    $application = new \Mesour\UI\Application('mesourapp');



    $application->getConfiguration()

        ->setTempDir(__DIR__ . '/temp');



    $application->setRequest($_REQUEST);



    $application->getUser()->setRoles('registered');



    $auth = $application->getAuthorizator();



    $auth->addRole('guest');

    $auth->addRole('registered', 'guest');



    $auth->addResource('menu');



    $auth->allow('guest', 'menu', ['first', 'second']);

    $auth->allow('registered', 'menu');

    $auth->deny('registered', 'menu', 'second');



    $grid = new \Mesour\UI\DataGrid('basicDataGrid', $application);



    $wrapper = $grid->getWrapperPrototype();



    $wrapper->class('my-class');



    // TRUE = append

    $wrapper->class('my-next-class', true);



    /** @var \Mesour\DataGrid\Sources\IGridSource $source */

    $source = require_once __DIR__ . '/sources/' . $sourceFile . '.php';



    $dataStructure = $source->getDataStructure();



    $dataStructure->renameColumn('user_addresses', 'addresses');

    $dataStructure->renameColumn('groups', 'group');

    $dataStructure->renameColumn('wallets', 'wallet');



    /** @var \Mesour\Sources\Structures\Columns\ManyToManyColumnStructure $companiesColumn */

    $companiesColumn = $dataStructure->getColumn('companies');

    $companiesColumn->setPattern('{name}');



    /** @var \Mesour\Sources\Structures\Columns\OneToManyColumnStructure $addressesColumn */

    $addressesColumn = $dataStructure->getColumn('addresses');

    $addressesColumn->setPattern('{street}, {zip} {city}, {country}');



    /** @var \Mesour\Sources\Structures\Columns\ManyToOneColumnStructure $groupColumn */

    $groupColumn = $dataStructure->getColumn('group');

    $groupColumn->setPattern('{name} ({type})');



    /** @var \Mesour\Sources\Structures\Columns\OneToOneColumnStructure $walletColumn */

    $walletColumn = $dataStructure->getColumn('wallet');

    $walletColumn->setPattern('{amount}');



    $grid->setSource($source);



    $pager = $grid->enablePager(8);



    //$filter = $grid->enableFilter();

    $filter = $grid->enableSimpleFilter();



    $selection = $grid->enableRowSelection();



    $selection = $selection->getLinks();



    $selection->addHeader('Active');



    $selection->addLink('Active')// add selection link

    ->onCall[] = function () {

        dump('ActivateSelected', func_get_args());

    };



    $selection->addLink('Unactive')

        ->setAjax(false)// disable AJAX

        ->onCall[] = function () {

        dump('InactivateSelected', func_get_args());

    };



    $selection->addDivider();



    $selection->addLink('Delete')

        ->setConfirm('Really delete all selected users?')// set confirm text

        ->onCall[] = function () {

        dump('DeleteSelected', func_get_args());

    };



    // EDITABLE



    $editable = $grid->enableEditable();



    $editableStructure = $editable->getDataStructure();



    $editableStructure->addOneToOne('wallet', 'Wallet')

        ->enableCreateNewRow();



    $editableStructure->addManyToOne('group', 'Groups')

        ->enableEditCurrentRow()

        ->enableCreateNewRow()

        ->setNullable();



    $editableStructure->addOneToMany('addresses', 'Addresses')

        ->enableCreateNewRow()

        ->enableRemoveRow();



    $editableStructure->addManyToMany('companies', 'Companies')

        ->enableAttachRow()

        ->enableCreateNewRow()

        ->enableRemoveRow();



    $companyStructure = $editableStructure->getOrCreateElement('companies', 'id');

    $companyStructure->addText('name', 'Name');

    $companyStructure->addNumber('reg_num', 'Reg. number');

    $companyStructure->addBool('verified', 'Verified');



    $walletStructure = $editableStructure->getOrCreateElement('wallets', 'id');

    $walletStructure->addNumber('amount', 'Amount')

        ->setDecimals(2)

        ->setThousandSeparator('.')

        ->setDecimalPoint(',');

    $walletStructure->addEnum('currency', 'Currency')

        ->addValue('CZK', 'CZK')

        ->addValue('EUR', 'EUR');



    $groupsStructure = $editableStructure->getOrCreateElement('groups', 'id');

    $groupsStructure->addText('name', 'Name');

    $groupsStructure->addEnum('type', 'Type')

        ->setNullable()

        ->addValue('first', 'First')

        ->addValue('second', 'Second');

    $groupsStructure->addDate('date', 'Date');

    $groupsStructure->addNumber('members', 'Members');



    // / EDITABLE



    $grid->enableSortable('sort');



    $status = $grid->addStatus('action', 'S')

        ->setPermission('menu', 'second');



    $status->addButton('active')

        ->setStatus(1, 'Active', 'All active')

        ->setIcon('check-circle-o')

        ->setType('success')

        ->setAttribute('href', '#');



    $status->addButton('inactive')

        ->setStatus(0, 'Inactive', 'All inactive')

        ->setIcon('times-circle-o')

        ->setType('danger')

        ->setAttribute('href', '#');



    $grid->addText('name', 'Name');



    $grid->addText('email', 'E-mail');



    $grid->addText('role', 'Role');



    $grid->addDate('last_login', 'Last login')

        ->setFormat('Y-m-d');



    $grid->addText('has_pro', 'Has pro')

        ->setAttribute('title', 'Has pro')

        ->setCallback(

            function (\Mesour\DataGrid\Column\Text $column, $data) {

                if($data['has_pro']) {

                    return '<b style="color:green">Yes</b>';

                }

                return '<b style="color:red">No</b>';

            }

        );



    $grid->addText('group', 'Group')

        //->setFiltering(false)

        ->setAttribute('title', 'Select group');



    $grid->addText('wallet', 'Wallet')

        //->setFiltering(false)

        ->setAttribute('title', 'Wallet');



    $grid->addText('addresses', 'Addresses')

        //->setFiltering(false)

    ;



    $grid->addText('companies', 'Companies')

        //->setFiltering(false)

    ;



    $grid->addNumber('amount', 'Amount')

        ->setUnit('CZK');



    $time_end = microtime(true);

    $time = $time_end - $time_start;



    echo "<hr><b>Execution time (before render): " . number_format($time, 3, ',', ' ') . " seconds</b><hr>";



    echo $grid->render();



    $time_end = microtime(true);

    $time = $time_end - $time_start;



    echo "<hr><b>Execution time (after render): " . number_format($time, 3, ',', ' ') . " seconds</b><hr>";



    ?>

</div>



<hr>



<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>



<!-- Latest compiled and minified JavaScript -->

<script src="https://code.jquery.com/jquery-2.1.4.min.js"></script>

<script src="http://code.jquery.com/ui/1.12.1/jquery-ui.min.js" integrity="sha256-VazP97ZCwtekAsvgPBSUwPFKdrwD3unUfSGVYrahUqU=" crossorigin="anonymous"></script>



<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"

        integrity="sha384-0mSbJDEHialfmuBBQP6A4Qrprq5OVfW37PRR3j5ELqxss1yVqOtnepnHVP9aJ7xS"

        crossorigin="anonymous"></script>



<script src="../node_modules/eonasdan-bootstrap-datetimepicker/node_modules/moment/min/moment.min.js"></script>

<script src="../node_modules/eonasdan-bootstrap-datetimepicker/build/js/bootstrap-datetimepicker.min.js"></script>



<script src="../node_modules/mesour-datagrid/dist/js/mesour.datagrid.js"></script>

Details

Mesour DataGrid

Mesour DataGrid is DataGrid for PHP >= 5.5 with options like to inline edit, export to csv, create sub items, sort data using jQuery.ui.nestedSortable and much more.

Install

With Composer
composer require mesour/datagrid
Or download source from GitHub

Files (105)

File	Role	Description
`docs` (1 file, 1 directory)
`examples` (4 files, 1 directory)
`src` (1 directory)
`tests` (3 files, 1 directory)
`.travis.yml`	Data	Auxiliary data
`composer.json`	Data	Auxiliary data
`license.md`	Lic.	License text
`package.json`	Data	Auxiliary data
`README.md`	Doc.	Documentation
`ruleset.xml`	Data	Auxiliary data

File	Role	Description
`column` (8 files)
`localisation.md`	Data	Auxiliary data

File	Role	Description
`container.md`	Data	Auxiliary data
`date.md`	Data	Auxiliary data
`image.md`	Data	Auxiliary data
`index.md`	Data	Auxiliary data
`number.md`	Data	Auxiliary data
`status.md`	Data	Auxiliary data
`template.md`	Data	Auxiliary data
`text.md`	Data	Auxiliary data

File	Role	Description
`sources` (3 files)
`basic.php`	Example	Example script
`editable.php`	Example	Example script
`index.php`	Example	Example script
`test.latte`	Data	Auxiliary data

File	Role	Description
`array_source.php`	Example	Example script
`doctrine_source.php`	Class	Class source
`nette_source.php`	Example	Example script

File	Role	Description
`Mesour` (2 directories)

File	Role	Description
`DataGrid` (7 files, 4 directories)
`UI` (1 file)

File	Role	Description
`Column` (12 files, 3 directories)
`Extensions` (3 files, 9 directories)
`Renderer` (3 files)
`Sources` (4 files)
`BaseGrid.php`	Class	Class source
`Exceptions.php`	Class	Class source
`ExtendedGrid.php`	Class	Class source
`ExtensionStorage.php`	Class	Class source
`SubItemGrid.php`	Class	Class source
`TemplateFile.php`	Class	Class source
`TemplateFileTrait.php`	Class	Class source

File	Role	Description
`core` (11 files)
`Status` (3 files)
`Template` (1 file)
`Container.php`	Class	Class source
`Date.php`	Class	Class source
`EmptyData.php`	Class	Class source
`Image.php`	Class	Class source
`Number.php`	Class	Class source
`Selection.php`	Class	Class source
`Sortable.php`	Class	Class source
`Status.php`	Class	Class source
`SubItem.php`	Class	Class source
`SubItemButton.php`	Class	Class source
`Template.php`	Class	Class source
`Text.php`	Class	Class source

File	Role	Description
`BaseColumn.php`	Class	Class source
`Filtering.php`	Class	Class source
`IColumn.php`	Class	Class source
`IContainer.php`	Class	Class source
`IExportable.php`	Class	Class source
`IFiltering.php`	Class	Class source
`IInlineEdit.php`	Class	Class source
`InlineEdit.php`	Class	Class source
`IOrdering.php`	Class	Class source
`IPrependedColumn.php`	Class	Class source
`Ordering.php`	Class	Class source

File	Role	Description
`IStatusItem.php`	Class	Class source
`StatusButton.php`	Class	Class source
`StatusDropDown.php`	Class	Class source

File	Role	Description
`Template.latte`	Data	Auxiliary data

File	Role	Description
`Editable` (2 files)
`Export` (2 files)
`Filter` (2 files)
`Ordering` (2 files)
`Pager` (2 files)
`Selection` (4 files)
`SimpleFilter` (2 files)
`Sortable` (2 files)
`SubItem` (2 files, 1 directory)
`Base.php`	Class	Class source
`IExtension.php`	Class	Class source
`IHasColumn.php`	Class	Class source

File	Role	Description
`EditableExtension.php`	Class	Class source
`IEditable.php`	Class	Class source

File	Role	Description
`ExportExtension.php`	Class	Class source
`IExport.php`	Class	Class source

File	Role	Description
`FilterExtension.php`	Class	Class source
`IFilter.php`	Class	Class source

File	Role	Description
`IOrdering.php`	Class	Class source
`OrderingExtension.php`	Class	Class source

File	Role	Description
`IPager.php`	Class	Class source
`PagerExtension.php`	Class	Class source

File	Role	Description
`ISelection.php`	Class	Class source
`Link.php`	Class	Class source
`Links.php`	Class	Class source
`SelectionExtension.php`	Class	Class source

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.

Install with Composer

	mesour-datagrid-2021-07-07.zip 97KB
	mesour-datagrid-2021-07-07.tar.gz 44KB
	Install with Composer

Version Control

Unique User Downloads

Download Rankings

100%

Total:	150
This week:	1

All time:	9,088
This week:	42

User Comments (1)

It seems very useful for data grid view.
3 years ago (Naveen Gautam)

80%

Applications that use this package

No pages of applications that use this class were specified.

If you know an application of this package, send a message to the author to add a link here.

About us

Advertise on this site

For more information send a message to info at phpclasses dot org.

File	Role	Description
`ISimpleFilter.php`	Class	Class source
`SimpleFilterExtension.php`	Class	Class source

File	Role	Description
`ISortable.php`	Class	Class source
`SortableExtension.php`	Class	Class source

File	Role	Description
`Items` (6 files)
`ISubItem.php`	Class	Class source
`SubItemExtension.php`	Class	Class source

File	Role	Description
`CallbackItem.php`	Class	Class source
`ComponentItem.php`	Class	Class source
`GridItem.php`	Class	Class source
`Item.php`	Class	Class source
`Template.latte`	Data	Auxiliary data
`TemplateItem.php`	Class	Class source

File	Role	Description
`GridListRenderer.php`	Class	Class source
`GridRenderer.php`	Class	Class source
`IGridRenderer.php`	Class	Class source

File	Role	Description
`ArrayGridSource.php`	Class	Class source
`DoctrineGridSource.php`	Class	Class source
`IGridSource.php`	Class	Class source
`NetteDbGridSource.php`	Class	Class source

File	Role	Description
`Mesour` (1 directory)
`bootstrap.php`	Example	Example script
`config.php`	Aux.	Auxiliary script
`php.ini`	Data	Auxiliary data

File	Role	Description
`output` (2 files)
`ArrayGridSourceTest.phpt`	Class	Class source
`BaseArrayGridSourceTest.php`	Class	Class source
`BaseDoctrineGridSourceTest.php`	Class	Class source
`BaseNetteDbGridSourceTest.php`	Class	Class source
`DataSourceChecker.php`	Class	Class source
`DoctrineGridSourceTest.phpt`	Class	Class source
`NetteDbGridSourceTest.phpt`	Class	Class source

File	Role	Description
`ArrayGridSourceTest.actual`	Data	Auxiliary data
`ArrayGridSourceTest.expected`	Data	Auxiliary data