silvioq/report

Clase de integración con DataTables

v4.0.0 2023-11-17 13:07 UTC

Requires

• php: >=8.1
• ext-intl: *
• doctrine/annotations: ^1.13
• doctrine/orm: ^2
• symfony/http-foundation: ^6
• symfony/http-kernel: ^6
• symfony/options-resolver: ^6

Requires (Dev)

• matthiasnoback/symfony-dependency-injection-test: ^4
• phpstan/phpstan: ^1
• phpunit/phpunit: ^9.6

Suggests

• beberlei/DoctrineExtensions: For DATE_FORMAT functions

MIT

• Silvio

README

• 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;
    }
}

Testeo

docker run -ti --rm \
  --user $(id -u):$(id -g) -v $(pwd):/app -w /app \
  -v $HOME/.cache/composer:/opt/composer/cache \
  registry.gitlab.com/silvioq/php-base-image:8.1 \
  composer install
docker run -ti --rm \
  --user $(id -u):$(id -g) -v $(pwd):/app -w /app \
  -v $HOME/.cache/composer:/opt/composer/cache \
  registry.gitlab.com/silvioq/php-base-image:8.1 \
  vendor/bin/phpunit