sostheng/entity-portation-bundle

This is a bundle that allows you to simply export entities arrays using PHPExcel

dev-master 2017-05-25 15:34 UTC

Requires

• php: >=5.3.2
• liuggio/excelbundle: dev-master
• symfony/framework-bundle: ~2.6|~3.0

Requires (Dev)

• phpunit/phpunit: ~4.6
• sensio/framework-extra-bundle: ~2.3|~3.0
• symfony/browser-kit: ~2.6|~3.0
• symfony/class-loader: ~2.6|~3.0
• symfony/finder: ~2.6|~3.0
• symfony/form: ~2.6|~3.0
• symfony/validator: ~2.6|~3.0

MIT

• Sosthèn Gaillard

• excel
• xls
• xlsx
• csv
• export
• entities
• entity

README

This is a bundle that allows you to simply export entities arrays using PHPExcel.

Simply place annotations on the elements of a class you want portable and the EntityPortationBundle will do the rest! Pass it the list of entities to export and enjoy!

For now, only basic export is available but reading CSV/Excel files and creating entities from it is planned.

Please note that this bundle is still in development and may have some bugs or weird behaviors. Do not hesitate to send your feedbacks!

License

Installation

1 Add to composer.json

    $composer require sostheng/entity-portation-bundle

2 Register the bundle in app/AppKernel.php

    $bundles = array(
        // ...
        new SosthenG\EntityPortationBundle\EntityPortationBundle(),
    );

How to use

This bundle uses annotations to detect what it needs to export. To use annotations, you must to include these two classes :

use SosthenG\EntityPortationBundle\Annotation\EntityPortation; // To pass custom parameters for the export
use SosthenG\EntityPortationBundle\Annotation\PortationGetter; // Required to tell which getter will be portable

Here is an example with all the parameters filled :

/**
 * @EntityPortation(csvDelimiter=";", sheetTitle="My sheet Title", fallBackValue="N/A")
 */
 class MyClass { 
    private $field;
 
    /**
     * @PortationGetter(label="Rôles", position="auto", visible=true, valueType="string")
     */
    public function getField()
    {
        return $this->_field;
    }
 }

They are all optionnal, the only required thing is to use the @PortationGetter() annotation on the getters you want to use for exports.

You've done the hardest! Now, just create an Export object, add extra parameters or change somes if you want, and get you exported file!

    /**
     * @Route("export/{format}", name="export", requirements={"format" = "PDF|Excel2007|Excel5|CSV|HTML|OpenDocument"})
     */
    public function exportAction($format) {
        $entities = $this->getDoctrine()->getManager()->getRepository("Bundle:MyClass")->findAll();

        $exporter = new Export($this->get("phpexcel"), $this->get("translator"));

        $exporter->setEntities($entities);
        
        // You can save the export as file or get a response from now, but if you want, you can change some parameters
        
        $prop = $exporter->getProperties(); // Returns the PhpExcel Properties object.
        $prop->setAuthor("You"); // Check the PHPExcel documentation for other parameters
        
        $exporter->setAllVisible(true);
        // etc.
        
        // Save the file
        $file = $exporter->saveAsFile($format, "web/files/myFileName"); // Extension is optionnal, it will be added if not filled
        // or return it as a Response
        return $exporter->getResponse($format, "myFileName");
    }

Some documentation

This bundle uses the ExcelBundle from liuggio, which is a PhpExcel integration for Symfony.

Documentation for this bundle

Not yet available. Let me finish it first :)