afup/sources/AppBundle/Site/Model/Repository/FeuilleRepository.php

<?php

namespace AppBundle\Site\Model\Repository;

use AppBundle\Site\Model\Feuille;
use CCMBenchmark\Ting\Repository\HydratorArray;
use CCMBenchmark\Ting\Repository\Metadata;
use CCMBenchmark\Ting\Repository\MetadataInitializer;
use CCMBenchmark\Ting\Repository\Repository;
use CCMBenchmark\Ting\Serializer\SerializerFactoryInterface;

class FeuilleRepository extends Repository implements MetadataInitializer
{
    public function getAllFeuilles($ordre = 'nom', $direction='asc', $filtre = '%')
    {
        if ($direction !== 'desc' && $direction !== 'asc') {
            $direction = 'asc';
        }
        $metadata = $this->getMetadata();
        $columnNameFound = false;
        foreach ($metadata->getFields() as $field) {
            if ($field['columnName'] === $ordre) {
                $columnNameFound=true;
                break;
            }
        }
        if ($columnNameFound === false) {
            $ordre = 'nom';
        }
        $requete = 'SELECT  * FROM afup_site_feuille WHERE afup_site_feuille.nom LIKE :filtre ';
        $requete .= 'ORDER BY ' . $ordre . ' ' . $direction;
        $query = $this->getQuery($requete);
        $query->setParams(['filtre' => '%' . $filtre . '%']);
        return $query->query($this->getCollection(new HydratorArray()));
    }

    /**
     * @inheritDoc
     */
    public static function initMetadata(SerializerFactoryInterface $serializerFactory, array $options = [])
    {
        $metadata = new Metadata($serializerFactory);
        $metadata->setEntity(Feuille::class);
        $metadata->setConnectionName('main');
        $metadata->setDatabase($options['database']);
        $metadata->setTable('afup_site_feuille');
        $metadata
        ->addField([
            'columnName' => 'id',
            'fieldName' => 'id',
            'primary'       => true,
            'autoincrement' => true,
            'type' => 'int',
        ])
        ->addField([
            'columnName' => 'id_parent',
            'fieldName' => 'idParent',
            'type' => 'int',
        ])
        ->addField([
            'columnName' => 'nom',
            'fieldName' => 'nom',
            'type' => 'string',
        ])
        ->addField([
            'columnName' => 'lien',
            'fieldName' => 'lien',
            'type' => 'string',
        ])
        ->addField([
            'columnName' => 'alt',
            'fieldName' => 'alt',
            'type' => 'string',
        ])
        ->addField([
            'columnName' => 'position',
            'fieldName' => 'position',
            'type' => 'int',
        ])
        ->addField([
            'columnName' => 'date',
            'fieldName' => 'date',
            'type' => 'datetime',
            'serializer_options' => [
                'unserialize' => [
                    'unSerializeUseFormat' => true,
                    'format' => 'U',
                ],
                'serialize' => [
                    'format' => 'U',
                ],
            ],
        ])
        ->addField([
            'columnName' => 'etat',
            'fieldName' => 'etat',
            'type' => 'int',
        ])
        ->addField([
            'columnName' => 'image',
            'fieldName' => 'image',
            'type' => 'string',
        ])
        ->addField([
            'columnName' => 'patterns',
            'fieldName' => 'patterns',
            'type' => 'string',
        ])
    ;
        return $metadata;
    }
}