Select Git revision
Code owners
Assign users and groups as approvers for specific file changes. Learn more.
DataGen.php 12.35 KiB
<?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' => '',