northernco / northerndatagridbundle

Datagrid for Symfony inspired by Zfdatagrid and Magento Grid.

This bundle was initiated by Stanislav Turza (Sorien).

Features

• Supports Entity (ORM), Document (ODM) and Vector (Array) sources
• Sortable and Filterable with operators (Comparison operators, range, starts/ends with, (not) contains, is (not) defined, regex)
• Auto-typing columns (Text, Number, Boolean, Array, DateTime, Date, ...)
• Locale support for DateTime, Date and Number columns (Decimal, Currency, Percent, Duration, Scientific, Spell out)
• Input, Select, checkbox and radio button filters filled with the data of the grid or an array of values
• Export (CSV, Excel, PDF, XML, JSON, HTML, ...)
• Mass actions
• Row actions
• Supports mapped fields with Entity source
• Securing the columns, actions and export with security roles
• Annotations and PHP configuration
• External filters box
• Ajax loading
• Pagination (You can also use Pagerfanta)
• Column width and column align
• Prefix translated titles
• Grid manager for multi-grid on the same page
• Groups configuration for ORM and ODM sources
• Easy templates overriding (twig)
• Custom columns and filters creation
• ...

Documentation

See the summary.

Screenshot

Full example with this CSS style file:

Simple example with the external filter box in english:

Same example in french:

Data used in these screenshots (this is a phpMyAdmin screenshot):

Simple grid with an ORM source

<?php

namespace MyProject\MyBundle\Controller;

use APY\DataGridBundle\Grid\Source\Entity;

class DefaultController extends Controller
{
	public function myGridAction()
	{
		// Creates a simple grid based on your entity (ORM)
		$source = new Entity('MyProjectMyBundle:MyEntity');

		// Get a Grid instance
		$grid = $this->get('grid');

		// Attach the source to the grid
		$grid->setSource($source);

		// Return the response of the grid to the template
		return $grid->getGridResponse('MyProjectMyBundle::myGrid.html.twig');
	}
}

Simple configuration of the grid in the entity

<?php

namespace MyProject\MyBundle\Entity

use Doctrine\ORM\Mapping as ORM;
use APY\DataGridBundle\Grid\Mapping as Grid;

/**
 * @Grid\Source(columns="id, my_datetime")
 */
class MyEntity
{
	/*
	 * @ORM\Column(type="integer")
	 */
	protected $id;

	/*
	 * @ORM\Column(type="datetime")
	 */
	protected $my_datetime;
}

Display the grid in a twig template

<?php
<!-- MyProject\MyBundle\Resources\views\myGrid.html.twig -->

{{ grid(grid) }}

And clear your cache.

northerndatagridbundle's Issues

PHPExcel is deprecated use PHPSpreadsheet instead

same with APYDataGridBundle, this one needs to update to newer PHPSpreadsheet.

i can try to make MR for this from other forks and similar bundles.

but last time working with APYDataGridBundle, i couldn't get the tests working because of mongoDB stuff.