DataGen.php

<?php

namespace GenDbStructure;

use Application\Service\Traits\SourceServiceAwareTrait;
use Doctrine\ORM\EntityManager;
use UnicaenApp\Service\EntityManagerAwareTrait;

class DataGen
{
    use EntityManagerAwareTrait;
    use SourceServiceAwareTrait;

    const OSE_USER = 'oseappli';

    /**
     * @var array
     */
    protected $tablesInfo = [];

    protected $breaks     = false;

    protected $tablesSel  = [
        'AFFECTATION'                => "utilisateur_id IN (SELECT id FROM utilisateur WHERE username='" . self::OSE_USER . "')",
        'ANNEE'                      => '',
        'CATEGORIE_PRIVILEGE'        => '',
        'CC_ACTIVITE'                => '',
        'CIVILITE'                   => '',
        'CORPS'                      => '',
        'DEPARTEMENT'                => '',
        'DISCIPLINE'                 => '',
        'DOMAINE_FONCTIONNEL'        => '',
        'ETABLISSEMENT'              => '',
        'ETAT_VOLUME_HORAIRE'        => '',
        'FONCTION_REFERENTIEL'       => '',
        'GRADE'                      => 'corps_id in (select c.id from corps c where c.histo_destruction is null)',
        'GROUPE'                     => '',
        'IMPORT_TABLES'              => '',
        'INDICATEUR'                 => '',
        'MESSAGE'                    => '',
        'MOTIF_MODIFICATION_SERVICE' => '',
        'MOTIF_NON_PAIEMENT'         => '',
        'PARAMETRE'                  => '',
        'PAYS'                       => '',
        'PERIMETRE'                  => '',
        'PERIODE'                    => '',
        'PLAFOND'                    => '',
        'PLAFOND_ETAT'               => '',
        'PRIVILEGE'                  => '',
        'REGLE_STRUCTURE_VALIDATION' => '',
        'ROLE'                       => '',
        'ROLE_PRIVILEGE'             => '',
        'SCENARIO'                   => 'structure_id IS NULL',
        'SOURCE'                     => "code='OSE'",
        'STATUT_INTERVENANT'         => '',
        'STATUT_PRIVILEGE'           => 'statut_id IN (SELECT si.id FROM statut_intervenant si WHERE si.histo_destruction IS NULL)',
        'TAUX_HORAIRE_HETD'          => '',
        'TBL'                        => '',
        'TYPE_AGREMENT'              => '',
        'TYPE_AGREMENT_STATUT'       => '',
        'TYPE_CONTRAT'               => '',
        'TYPE_DOTATION'              => "SOURCE_CODE IN ('dotation-initiale','dotation-complementaire','abondement')",
        'TYPE_HEURES'                => '',
        'TYPE_INTERVENANT'           => '',
        'TYPE_INTERVENTION'          => "code IN ('CM','TD','TP','Stage','Projet','Mémoire')",
        'TYPE_PIECE_JOINTE'          => '',
        'TYPE_PIECE_JOINTE_STATUT'   => '',
        'TYPE_RESSOURCE'             => '',
        'TYPE_STRUCTURE'             => '',
        'TYPE_VALIDATION'            => '',