Doctrine - Symfony - Datatable Integration

• Simple class for Datatables integration.

Symfony 4

# config/bundles.php
...
    Silvioq\ReportBundle\SilvioqReportBundle::class => ['all' => true],
...

Datatable usage

TODO

Table usage

Table is a simple class for generating large reports (or CSV) from your entities

Simple usage

<?php
namespace AppBundle\Controller;

use Symfony\Component\HttpFoundation\StreamedResponse;
use Symfony\Component\HttpFoundation\ResponseHeaderBag;
use AppBundle\Entity\Entity;

class SimpleController extends Controller
{
    public function downloadAction()
    {
        $table =  $this->get('silvioq.report.table')->build(Entity::class);
                $em = $this->getDoctrine()->getManager();
        $response = new StreamedResponse();
        $iterator = $em->getRepository(Entity::class)
                ->createQueryBuilder('a')
                ->getQuery()->iterate();

        $trans = $this->get('translator');
        $header = array_map(function($header)use($trans){
                return $trans->trans($header);
            }, $table->getHeader() );

        $response->setCallback(function() use($iterator,$table, $header){
            $f = fopen( "php://output", "w" );
            try
            {
                fputcsv( $f, $header );
                foreach( $iterator as $row )
                {
                    $entity = $row[0];
                    fputcsv( $f, $table->getRow($entity) );
                }
            }
            catch(\Exception $e )
            {
                echo $e->getMessage();
                return;
            }
            fclose( $f );
        });
        $disposition = $response->headers->makeDisposition(
            ResponseHeaderBag::DISPOSITION_ATTACHMENT,
            'entity.csv' );
        $response->headers->set('Content-Type','text/csv');

        return $response;
    }
}