<?php
namespace App\Test\Fixture;

use Cake\TestSuite\Fixture\TestFixture;

const yyyy0 = 2020; // Année en cours
const yyyy1 = yyyy0-1; // max : 'TEST-'.yyyy1.'-0002' => donc prochain créé doit être en -0003
const yyyy2 = yyyy0-2; // max : 'TEST-'.yyyy2.'-0010' => donc prochain créé doit être en -0010
const yyyy3 = yyyy0-3;
const mmdd1 = '05-11';
const mmdd2 = '04-19';
const yyyy0mmdd1 = yyyy0.'-'.mmdd1; // Date toujours la plus récente (plus récente que n'importe quel matos de la fixture)
const yyyy1mmdd1 = yyyy1.'-'.mmdd1; // Date du matos le plus récent
const yyyy1mmdd2 = yyyy1.'-'.mmdd2;
const yyyy2mmdd1 = yyyy2.'-'.mmdd1;
const yyyy2mmdd2 = yyyy2.'-'.mmdd2; // // Date du matos le plus ancien
const yyyy3mmdd2 = yyyy3.'-'.mmdd2; // Date toujours la plus ancienne (plus ancienne que n'importe quel matos de la fixture)
const yyyy1_highest_num = '0002';
const yyyy2_highest_num = '0010';

/**
 * MaterielsFixture
 */
class MaterielsFixture extends TestFixture {

    
    /*
     * 
     * Pour importer automatiquement la définition de la table materiels
     * (https://book.cakephp.org/3/en/development/testing.html#importing-table-information)
     *
     * Evite d'avoir à définir la variable publique $fields
     *
     * public $import = ['table' => 'materiels'];
     *
     * ou encore :
     *
     * public $import = ['model' => 'Materiels'];
     *
     * Après, on peut (ou pas) définir des records avec la variable $records
     * 
     * Finally, it’s possible to not load/create any schema in a fixture. 
     * This is useful if you already have a test database setup with all the empty tables created. 
     * By defining neither $fields nor $import, a fixture will only insert its records 
     * and truncate the records on each test method.
     *
     */
    // (EP202009)
    public $import = ['model' => 'Materiels'];
    /* 
     * Si on n'utilise pas la variable $import ci-dessus, 
     * alors il faut définir tous les champs utilisés,
     * comme ci-dessous, avec la variable $fields,
     * GALÈRE !!!
     * 
     */
    
    /**
     * Fields
     *
     * @var array
     */
    /*
    // @codingStandardsIgnoreStart
    public $fields = [
        
        'id' => [
            'type' => 'integer',
            'length' => 11,
            'unsigned' => false,
            'null' => false,
            'default' => null,
            'comment' => '',
            'autoIncrement' => true,
            'precision' => null
        ],
        'designation' => [
            'type' => 'string',
            'length' => 50,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null,
            'fixed' => null
        ],
        'sur_categorie_id' => [
            'type' => 'integer',
            'length' => 11,
            'unsigned' => false,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null,
            'autoIncrement' => null
        ],
        'categorie_id' => [
            'type' => 'integer',
            'length' => 11,
            'unsigned' => false,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null,
            'autoIncrement' => null
        ],
        'sous_categorie_id' => [
            'type' => 'integer',
            'length' => 11,
            'unsigned' => false,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null,
            'autoIncrement' => null
        ],
        'projet_id' => [
            'type' => 'integer',
            'length' => 11,
            'unsigned' => false,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null,
            'autoIncrement' => null
        ],
        'numero_laboratoire' => [
            'type' => 'string',
            'length' => 14,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null,
            'fixed' => null
        ],
        'description' => [
            'type' => 'text',
            'length' => null,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null
        ],
        'materiel_administratif' => [
            'type' => 'boolean',
            'length' => null,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null
        ],
        'materiel_technique' => [
            'type' => 'boolean',
            'length' => null,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null
        ],
        'status' => [
            'type' => 'string',
            'length' => 15,
            'null' => true,
            'default' => 'CREATED',
            'comment' => '',
            'precision' => null,
            'fixed' => null
        ],
        'date_acquisition' => [
            'type' => 'date',
            'length' => null,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null
        ],
        'date_fin_garantie' => [
            'type' => 'date',
            'length' => null,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null
        ],
        'duree_garantie' => [
            'type' => 'integer',
            'length' => 10,
            'unsigned' => false,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null
        ],
        'unite_duree_garantie' => [
            'type' => 'string',
            'length' => 30,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null,
            'fixed' => null
        ],
        'prix_ht' => [
            'type' => 'float',
            'length' => 45,
            'precision' => 0,
            'unsigned' => true,
            'null' => true,
            'default' => null,
            'comment' => ''
        ],
        'eotp' => [
            'type' => 'string',
            'length' => 45,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null,
            'fixed' => null
        ],
        'numero_commande' => [
            'type' => 'string',
            'length' => 45,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null,
            'fixed' => null
        ],
        'code_comptable' => [
            'type' => 'string',
            'length' => 45,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null,
            'fixed' => null
        ],
        'numero_serie' => [
            'type' => 'string',
            'length' => 45,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null,
            'fixed' => null
        ],
        'groupes_thematique_id' => [
            'type' => 'integer',
            'length' => 11,
            'unsigned' => false,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null,
            'autoIncrement' => null
        ],
        'groupes_metier_id' => [
            'type' => 'integer',
            'length' => 11,
            'unsigned' => false,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null,
            'autoIncrement' => null
        ],
        'numero_inventaire_organisme' => [
            'type' => 'string',
            'length' => 45,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null,
            'fixed' => null
        ],
        'numero_inventaire_old' => [
            'type' => 'string',
            'length' => 45,
            'null' => true,
            'default' => null,
            'comment' => 'Ancien numero inventaire',
            'precision' => null,
            'fixed' => null
        ],
        'date_archivage' => [
            'type' => 'date',
            'length' => null,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null
        ],
        'etiquette' => [
            'type' => 'boolean',
            'length' => null,
            'null' => true,
            'default' => '0',
            'comment' => 'etiquette sur materiel oui ou non',
            'precision' => null
        ],
        'lieu_detail' => [
            'type' => 'string',
            'length' => 45,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null,
            'fixed' => null
        ],
        'nom_responsable' => [
            'type' => 'string',
            'length' => 45,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null,
            'fixed' => null
        ],
        'email_responsable' => [
            'type' => 'string',
            'length' => 45,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null,
            'fixed' => null
        ],
        'nom_createur' => [
            'type' => 'string',
            'length' => 45,
            'null' => true,
            'default' => null,
            'comment' => 'nom du createur de la fiche',
            'precision' => null,
            'fixed' => null
        ],
        'nom_modificateur' => [
            'type' => 'string',
            'length' => 45,
            'null' => true,
            'default' => null,
            'comment' => 'nom du modificateur de la fiche',
            'precision' => null,
            'fixed' => null
        ],
        'created' => [
            'type' => 'datetime',
            'length' => null,
            'null' => true,
            'default' => null,
            'comment' => 'date et heure de creation de la fiche',
            'precision' => null
        ],
        'modified' => [
            'type' => 'datetime',
            'length' => null,
            'null' => true,
            'default' => null,
            'comment' => 'date et heure de modif de la fiche',
            'precision' => null
        ],
        'date_reception' => [
            'type' => 'date',
            'length' => null,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null
        ],
        'organisme_id' => [
            'type' => 'integer',
            'length' => 11,
            'unsigned' => false,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null,
            'autoIncrement' => null
        ],
        'site_id' => [
            'type' => 'integer',
            'length' => 11,
            'unsigned' => false,
            'null' => true,
            'default' => '1',
            'comment' => '',
            'precision' => null,
            'autoIncrement' => null
        ],
        'photo_id' => [
            'type' => 'integer',
            'length' => 11,
            'unsigned' => false,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null,
            'autoIncrement' => null
        ],
        'hors_service' => [
            'type' => 'boolean',
            'length' => null,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null
        ],
        'metrologie' => [
            'type' => 'boolean',
            'length' => null,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null
        ],
        'fournisseur_id' => [
            'type' => 'integer',
            'length' => 11,
            'unsigned' => false,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null,
            'autoIncrement' => null
        ],
        'gestionnaire_id' => [
            'type' => 'integer',
            'length' => 11,
            'unsigned' => false,
            'null' => true,
            'default' => null,
            'comment' => '',
            'precision' => null,
            'autoIncrement' => null
        ],
        
        
        '_indexes' => [
            'fk_administrative_materials_sub_categories1' => [
                'type' => 'index',
                'columns' => [
                    'sous_categorie_id'
                ],
                'length' => []
            ],
            'fk_materials_thematic_group1' => [
                'type' => 'index',
                'columns' => [
                    'groupes_thematique_id'
                ],
                'length' => []
            ],
            'fk_materials_work_group1' => [
                'type' => 'index',
                'columns' => [
                    'groupes_metier_id'
                ],
                'length' => []
            ],
            'fk_materiels_categories1' => [
                'type' => 'index',
                'columns' => [
                    'categorie_id'
                ],
                'length' => []
            ],
            'fk_materiels_sur_categorie_id' => [
                'type' => 'index',
                'columns' => [
                    'sur_categorie_id'
                ],
                'length' => []
            ],
            'fk_materiels_organisme_id' => [
                'type' => 'index',
                'columns' => [
                    'organisme_id'
                ],
                'length' => []
            ],
            'fk_materiels_site_id' => [
                'type' => 'index',
                'columns' => [
                    'site_id'
                ],
                'length' => []
            ],
            'fk_materiels_fournisseur_id' => [
                'type' => 'index',
                'columns' => [
                    'fournisseur_id'
                ],
                'length' => []
            ]
        ],
        
        
        '_constraints' => [
            'primary' => [
                'type' => 'primary',
                'columns' => [
                    'id'
                ],
                'length' => []
            ],
            'numero_irap' => [
                'type' => 'unique',
                'columns' => [
                    'numero_laboratoire'
                ],
                'length' => []
            ],
            'fk_administrative_materials_sub_categories1' => [
                'type' => 'foreign',
                'columns' => [
                    'sous_categorie_id'
                ],
                'references' => [
                    'sous_categories',
                    'id'
                ],
                'update' => 'noAction',
                'delete' => 'noAction',
                'length' => []
            ],
            'fk_materials_thematic_group1' => [
                'type' => 'foreign',
                'columns' => [
                    'groupes_thematique_id'
                ],
                'references' => [
                    'groupes_thematiques',
                    'id'
                ],
                'update' => 'noAction',
                'delete' => 'noAction',
                'length' => []
            ],
            'fk_materials_work_group1' => [
                'type' => 'foreign',
                'columns' => [
                    'groupes_metier_id'
                ],
                'references' => [
                    'groupes_metiers',
                    'id'
                ],
                'update' => 'noAction',
                'delete' => 'noAction',
                'length' => []
            ],
            'fk_materiels_categories1' => [
                'type' => 'foreign',
                'columns' => [
                    'categorie_id'
                ],
                'references' => [
                    'categories',
                    'id'
                ],
                'update' => 'noAction',
                'delete' => 'noAction',
                'length' => []
            ],
            'fk_materiels_organisme_id' => [
                'type' => 'foreign',
                'columns' => [
                    'organisme_id'
                ],
                'references' => [
                    'organismes',
                    'id'
                ],
                'update' => 'noAction',
                'delete' => 'noAction',
                'length' => []
            ],
            'fk_materiels_site_id' => [
                'type' => 'foreign',
                'columns' => [
                    'site_id'
                ],
                'references' => [
                    'sites',
                    'id'
                ],
                'update' => 'noAction',
                'delete' => 'noAction',
                'length' => []
            ],
            'fk_materiels_sur_categorie_id' => [
                'type' => 'foreign',
                'columns' => [
                    'sur_categorie_id'
                ],
                'references' => [
                    'sur_categories',
                    'id'
                ],
                'update' => 'noAction',
                'delete' => 'noAction',
                'length' => []
            ],
            'fk_materiels_fournisseur_id' => [
                'type' => 'foreign',
                'columns' => [
                    'fournisseur_id'
                ],
                'references' => [
                    'fournisseurs',
                    'id'
                ],
                'update' => 'noAction',
                'delete' => 'noAction',
                'length' => []
            ]
        ],
        '_options' => [
            'engine' => 'InnoDB',
            'collation' => 'latin1_swedish_ci'
        ]
    ];
    // @codingStandardsIgnoreEnd
    */

    
    
    
    /**
     * Records
     *
     * @var array
     */
    public $records = [
        
        /* 14/1/19 bake autogenerated
        [
            'id' => 1,
            'designation' => 'Lorem ipsum dolor sit amet',
            'sur_categorie_id' => 1,
            'categorie_id' => 1,
            'sous_categorie_id' => 1,
            'numero_laboratoire' => 'Lorem ipsum dolor ',
            'description' => 'Lorem ipsum dolor sit amet, aliquet feugiat. Convallis morbi fringilla gravida, phasellus feugiat dapibus velit nunc, pulvinar eget sollicitudin venenatis cum nullam, vivamus ut a sed, mollitia lectus. Nulla vestibulum massa neque ut et, id hendrerit sit, feugiat in taciti enim proin nibh, tempor dignissim, rhoncus duis vestibulum nunc mattis convallis.',
            'materiel_administratif' => 1,
            'materiel_technique' => 1,
            'status' => 'Lorem ipsum d',
            'date_acquisition' => '2019-01-14',
            'prix_ht' => 1,
            'eotp' => 'Lorem ipsum dolor sit amet',
            'numero_commande' => 'Lorem ipsum dolor sit amet',
            'code_comptable' => 'Lorem ipsum dolor sit amet',
            'numero_serie' => 'Lorem ipsum dolor sit amet',
            'groupes_thematique_id' => 1,
            'groupes_metier_id' => 1,
            'numero_inventaire_organisme' => 'Lorem ipsum dolor sit amet',
            'numero_inventaire_old' => 'Lorem ipsum dolor sit amet',
            'date_archivage' => '2019-01-14',
            'etiquette' => 1,
            'lieu_detail' => 'Lorem ipsum dolor sit amet',
            'nom_responsable' => 'Lorem ipsum dolor sit amet',
            'email_responsable' => 'Lorem ipsum dolor sit amet',
            'gestionnaire_id' => 1,
            'nom_createur' => 'Lorem ipsum dolor sit amet',
            'nom_modificateur' => 'Lorem ipsum dolor sit amet',
            'created' => '2019-01-14 14:14:39',
            'modified' => '2019-01-14 14:14:39',
            'date_reception' => '2019-01-14',
            'organisme_id' => 1,
            'site_id' => 1,
            'date_fin_garantie' => '2019-01-14',
            'duree_garantie' => 1,
            'unite_duree_garantie' => 'Lorem ipsum dolor sit amet',
            'hors_service' => 1,
            'photo_id' => 1,
            'metrologie' => 1,
            'fournisseur_id' => 1
        ],
        */
        
        // matos CREATED owned by USER 
        [
            //'id' => 1,
            // TODO: définir budgets comme champ optionnel dans la BD !!!
            'budgets' => 'toto',
            'designation' => 'matos 1 USER (C)',
            //'designation' => 'Test 1',
            'sur_categorie_id' => 1,
            'categorie_id' => 1,
            'sous_categorie_id' => 1,
            //'numero_laboratoire' => 'TEST-2018-0001', //+4
            'numero_laboratoire' => 'TEST-'.yyyy1.'-0001', //+4
            'description' => 'Lorem ipsum dolor sit amet, aliquet feugiat. Convallis morbi fringilla gravida, phasellus feugiat dapibus velit nunc, pulvinar eget sollicitudin venenatis cum nullam, vivamus ut a sed, mollitia lectus. Nulla vestibulum massa neque ut et, id hendrerit sit, feugiat in taciti enim proin nibh, tempor dignissim, rhoncus duis vestibulum nunc mattis convallis.',
            'materiel_administratif' => 0,
            'materiel_technique' => 1,
            'status' => 'CREATED',
            //'status' => 'VALIDATED',
            //'date_acquisition' => '2018-04-19', // 2014-04-19
            //'date_acquisition' => yyyy1.'-04-19', // 2014-04-19
            'date_acquisition' => yyyy1mmdd1,
            'prix_ht' => 25.00,
            'eotp' => 'Lorem ipsum dolor sit amet',
            'numero_commande' => 'Lorem ipsum dolor sit amet',
            'code_comptable' => 'Lorem ipsum dolor sit amet',
            'numero_serie' => 'Lorem ipsum dolor sit amet',
            'groupes_thematique_id' => 1,
            'groupes_metier_id' => 1,
            'numero_inventaire_organisme' => 'Lorem ipsum dolor sit amet',
            'numero_inventaire_old' => 'Lorem ipsum dolor sit amet',
            //'date_archivage' => '2016-04-19',
            'date_archivage' => yyyy1mmdd1,
            'etiquette' => 1,
            'lieu_detail' => 'Lorem ipsum dolor sit amet',
            
            //'nom_responsable' => 'Lorem ipsum dolor sit amet',
            //'nom_responsable' => 'test0 test9',
            ////'nom_responsable' => 'user5 USER',
            'nom_responsable' => 'USER user5',
            'email_responsable' => 'Lorem ipsum dolor sit amet',
            //'nom_createur' => 'Lorem ipsum dolor sit amet',
            //'nom_createur' => 'test0 test9',
            'nom_modificateur' => 'Lorem ipsum dolor sit amet',
            'created' => '2020-04-19 09:09:29',
            'modified' => '2020-04-19 09:09:29',
            //'date_reception' => '2016-04-19',
            'date_reception' => yyyy1mmdd1,
            'organisme_id' => 1,
            'site_id' => 1, // Roche
            'metrologie' => 0,
            'fournisseur_id' => 2,
            // (EP202102) Ajout infos LOT1 obligatoires
            'resp_credit'=>'resp du credit',
            'nom_user'=>'toto user',
            'gestionnaire_id'=>'3', // user id 3 est un profil Administration
        ],
        
        // matos CREATED owned by anybody
        [
            //'id' => 2,
            // TODO: définir budgets comme champ optionnel dans la BD !!!
            'budgets' => 'toto',
            'designation' => 'Matos Test 2 (C)',
            'sur_categorie_id' => 1,
            'categorie_id' => 1,
            'sous_categorie_id' => 1,
            //'numero_laboratoire' => 'TEST-2020-0002',
            //'numero_laboratoire' => 'TEST-'.yyyy2.'-0010',
            'numero_laboratoire' => 'TEST-'.yyyy2.'-'.yyyy2_highest_num,
            'description' => 'Lorem ipsum dolor sit amet, aliquet feugiat. Convallis morbi fringilla gravida, phasellus feugiat dapibus velit nunc, pulvinar eget sollicitudin venenatis cum nullam, vivamus ut a sed, mollitia lectus. Nulla vestibulum massa neque ut et, id hendrerit sit, feugiat in taciti enim proin nibh, tempor dignissim, rhoncus duis vestibulum nunc mattis convallis.',
            'materiel_administratif' => 0,
            'materiel_technique' => 1,
            'status' => 'CREATED',
            //'date_acquisition' => '2019-04-19', // 2015-04-19
            //'date_acquisition' => yyyy2.'-'.mmdd1, // 2015-04-19
            'date_acquisition' => yyyy2mmdd1,
            'prix_ht' => 50.00,
            'eotp' => 'Lorem ipsum dolor sit amet',
            'numero_commande' => 'Lorem ipsum dolor sit amet',
            'code_comptable' => 'Lorem ipsum dolor sit amet',
            'numero_serie' => 'Lorem ipsum dolor sit amet',
            'groupes_thematique_id' => 1,
            'groupes_metier_id' => 1,
            'numero_inventaire_organisme' => 'Lorem ipsum dolor sit amet',
            'numero_inventaire_old' => 'Lorem ipsum dolor sit amet',
            //'date_archivage' => '2016-04-19',
            'date_archivage' => yyyy2mmdd1,
            'etiquette' => 1,
            'lieu_detail' => 'Lorem ipsum dolor sit amet',
            'nom_responsable' => 'Lorem ipsum dolor sit amet',
            //'nom_responsable' => 'user1 SUPER',
            //'nom_responsable' => 'user4 RESP',
            'email_responsable' => 'Lorem ipsum dolor sit amet',
            'nom_createur' => 'Lorem ipsum dolor sit amet',
            'nom_modificateur' => 'Lorem ipsum dolor sit amet',
            'created' => '2020-04-19 09:09:29',
            'modified' => '2020-04-19 09:09:29',
            //'date_reception' => '2016-04-19',
            'date_reception' => yyyy2mmdd1,
            'organisme_id' => 1,
            'site_id' => 1, // Roche
            'metrologie' => 0,
            'fournisseur_id' => 2,
            // (EP202102) Ajout infos LOT1 obligatoires
            'resp_credit'=>'resp du credit',
            'nom_user'=>'toto user',
            'gestionnaire_id'=>'3', // user id 3 est un profil Administration
        ],
        
        // matos VALIDATED (et administratif) owned by anybody
        [
            //'id' => 3,
            // TODO: définir budgets comme champ optionnel dans la BD !!!
            'budgets' => 'toto',
            'designation' => 'Test 3 (V)',
            'sur_categorie_id' => 1,
            'categorie_id' => 1,
            'sous_categorie_id' => 1,
            //'numero_laboratoire' => 'TEST-2020-0003',
            'numero_laboratoire' => 'TEST-'.yyyy2.'-0007',
            'description' => 'Lorem ipsum dolor sit amet, aliquet feugiat. Convallis morbi fringilla gravida, phasellus feugiat dapibus velit nunc, pulvinar eget sollicitudin venenatis cum nullam, vivamus ut a sed, mollitia lectus. Nulla vestibulum massa neque ut et, id hendrerit sit, feugiat in taciti enim proin nibh, tempor dignissim, rhoncus duis vestibulum nunc mattis convallis.',
            'materiel_administratif' => 1,
            'materiel_technique' => 1,
            'status' => 'VALIDATED',
            //'date_acquisition' => '2020-05-11', // 2016-05-11
            //'date_acquisition' => yyyy2.'-'.mmdd2,
            'date_acquisition' => yyyy2mmdd2,
            'prix_ht' => 1100.00,
            'eotp' => 'Lorem ipsum dolor sit amet',
            'numero_commande' => 'Lorem ipsum dolor sit amet',
            'code_comptable' => 'Lorem ipsum dolor sit amet',
            'numero_serie' => 'Lorem ipsum dolor sit amet',
            'groupes_thematique_id' => 1,
            'groupes_metier_id' => 1,
            'numero_inventaire_organisme' => 'Lorem ipsum dolor sit amet',
            'numero_inventaire_old' => 'Lorem ipsum dolor sit amet',
            //'date_archivage' => '2016-04-19',
            'date_archivage' => yyyy2mmdd2,
            'etiquette' => 1,
            'lieu_detail' => 'Lorem ipsum dolor sit amet',
            'nom_responsable' => 'Lorem ipsum dolor sit amet',
            'email_responsable' => 'Lorem ipsum dolor sit amet',
            'nom_createur' => 'Lorem ipsum dolor sit amet',
            'nom_modificateur' => 'Lorem ipsum dolor sit amet',
            'created' => '2020-04-19 09:09:29',
            'modified' => '2020-04-19 09:09:29',
            //'date_reception' => '2016-04-19',
            'date_reception' => yyyy2mmdd2,
            'organisme_id' => 1,
            'site_id' => 1, // Roche
            'metrologie' => 0,
            'fournisseur_id' => 2,
        ],
        
        // matos CREATED owned by USER
        // nom_createur = 'test0 test9'
        //'nom_responsable' => 'test0 test9'
        [
            'id' => 11,
            // TODO: définir budgets comme champ optionnel dans la BD !!!
            'budgets' => 'toto',
            'designation' => 'Test 11 (C)',
            'sur_categorie_id' => 1,
            'categorie_id' => 1,
            'sous_categorie_id' => 1,
            'projet_id' => 1,
            //'numero_laboratoire' => 'TEST-2020-0011',
            'numero_laboratoire' => 'TEST-'.yyyy2.'-0003',
            'description' => 'Lorem ipsum dolor sit amet, aliquet feugiat. Convallis morbi fringilla gravida, phasellus feugiat dapibus velit nunc, pulvinar eget sollicitudin venenatis cum nullam, vivamus ut a sed, mollitia lectus. Nulla vestibulum massa neque ut et, id hendrerit sit, feugiat in taciti enim proin nibh, tempor dignissim, rhoncus duis vestibulum nunc mattis convallis.',
            'materiel_administratif' => 1,
            'materiel_technique' => 1,
            'status' => 'CREATED',
            //'date_acquisition' => '2020-05-11', // +4
            //'date_acquisition' => yyyy2.'-'.mmdd1,
            'date_acquisition' => yyyy2mmdd2,
            'prix_ht' => 75.00,
            'eotp' => 'Lorem ipsum dolor sit amet',
            'numero_commande' => 'Lorem ipsum dolor sit amet',
            'code_comptable' => 'Lorem ipsum dolor sit amet',
            'numero_serie' => 'Lorem ipsum dolor sit amet',
            'groupes_thematique_id' => 1,
            'groupes_metier_id' => 1,
            'numero_inventaire_organisme' => 'Lorem ipsum dolor sit amet',
            'numero_inventaire_old' => 'Lorem ipsum dolor sit amet',
            //'date_archivage' => '2016-04-19',
            'date_archivage' => yyyy2mmdd2,
            'etiquette' => 0,
            'lieu_detail' => 'Lorem ipsum dolor sit amet',
            'gestionnaire_id' => 1,
            //'nom_responsable' => 'test0 test9',
            /////'nom_responsable' => 'user5 USER',
            'nom_responsable' => 'USER user5',
            'email_responsable' => 'Lorem ipsum dolor sit amet',
            //'nom_createur' => 'test0 test9',
            //////'nom_createur' => 'user5 USER',
            'nom_createur' => 'USER user5',
            'nom_modificateur' => 'Lorem ipsum dolor sit amet',
            'created' => '2020-04-19 09:09:29',
            'modified' => '2020-04-19 09:09:29',
            //'date_reception' => '2016-04-19',
            'date_reception' => yyyy2mmdd2,
            'organisme_id' => 1,
            'site_id' => 1, // Roche
            'metrologie' => 0,
            'fournisseur_id' => 1,
            'nom_user' => 'JP',
        ],
        
        // matos VALIDATED owned by anybody
        [
            //'id' => 12,
            // TODO: définir budgets comme champ optionnel dans la BD !!!
            'budgets' => 'toto',
            'designation' => 'Test 12 (V)',
            'sur_categorie_id' => 1,
            'categorie_id' => 1,
            'sous_categorie_id' => 1,
            //'numero_laboratoire' => 'TEST-2020-0012',
            'numero_laboratoire' => 'TEST-'.yyyy2.'-0002',
            'description' => 'Lorem ipsum dolor sit amet, aliquet feugiat. Convallis morbi fringilla gravida, phasellus feugiat dapibus velit nunc, pulvinar eget sollicitudin venenatis cum nullam, vivamus ut a sed, mollitia lectus. Nulla vestibulum massa neque ut et, id hendrerit sit, feugiat in taciti enim proin nibh, tempor dignissim, rhoncus duis vestibulum nunc mattis convallis.',
            'materiel_administratif' => 1,
            'materiel_technique' => 1,
            'status' => 'VALIDATED',
            //'date_acquisition' => '2020-05-11', // + 4
            //'date_acquisition' => yyyy2.'-'.mmdd2,
            'date_acquisition' => yyyy2mmdd2,
            'prix_ht' => 75.00,
            'eotp' => 'Lorem ipsum dolor sit amet',
            'numero_commande' => 'Lorem ipsum dolor sit amet',
            'code_comptable' => 'Lorem ipsum dolor sit amet',
            'numero_serie' => 'Lorem ipsum dolor sit amet',
            /*
            'groupes_thematique_id' => 1,
            'groupes_metier_id' => 1,
            */
            'groupes_thematique_id' => 2,
            'groupes_metier_id' => 2,
            'numero_inventaire_organisme' => 'Lorem ipsum dolor sit amet',
            'numero_inventaire_old' => 'Lorem ipsum dolor sit amet',
            //'date_archivage' => '2016-04-19',
            'date_archivage' => yyyy2mmdd2,
            'etiquette' => 1,
            'lieu_detail' => 'Lorem ipsum dolor sit amet',
            'nom_responsable' => 'Lorem ipsum dolor sit amet',
            'email_responsable' => 'Lorem ipsum dolor sit amet',
            'nom_createur' => 'Lorem ipsum dolor sit amet',
            'nom_modificateur' => 'Lorem ipsum dolor sit amet',
            'created' => '2020-04-19 09:09:29',
            'modified' => '2020-04-19 09:09:29',
            //'date_reception' => '2016-04-19',
            'date_reception' => yyyy2mmdd2,
            'organisme_id' => 1,
            'site_id' => 1, // Roche
            'metrologie' => 0,
            'fournisseur_id' => 1
        ],
        
        // matos TBA owned by anybody
        [
            //'id' => 13,
            // TODO: définir budgets comme champ optionnel dans la BD !!!
            'budgets' => 'toto',
            'designation' => 'Test 13 (TBA)',
            'sur_categorie_id' => 1,
            'categorie_id' => 1,
            'sous_categorie_id' => 1,
            //'numero_laboratoire' => 'TEST-2020-0013',
            'numero_laboratoire' => 'TEST-'.yyyy2.'-0006',
            'description' => 'TEST COPIE MATERIEL',
            'materiel_administratif' => 1,
            'materiel_technique' => 1,
            'status' => 'TOBEARCHIVED',
            //'date_acquisition' => '2020-05-11', // +4
            'date_acquisition' => yyyy2mmdd2,
            'prix_ht' => 75.00,
            'eotp' => 'Lorem ipsum dolor sit amet',
            'numero_commande' => 'Lorem ipsum dolor sit amet',
            'code_comptable' => 'Lorem ipsum dolor sit amet',
            'numero_serie' => 'Lorem ipsum dolor sit amet',
            'groupes_thematique_id' => 1,
            'groupes_metier_id' => 1,
            'numero_inventaire_organisme' => 'Lorem ipsum dolor sit amet',
            'numero_inventaire_old' => 'Lorem ipsum dolor sit amet',
            //'date_archivage' => '2016-04-19',
            'date_archivage' => yyyy2mmdd2,
            'etiquette' => 1,
            'lieu_detail' => 'Lorem ipsum dolor sit amet',
            'gestionnaire_id' => 1,
            'nom_responsable' => 'nobody',
            'email_responsable' => 'Lorem ipsum dolor sit amet',
            'nom_createur' => 'Lorem ipsum dolor sit amet',
            'nom_modificateur' => 'Lorem ipsum dolor sit amet',
            'created' => '2020-04-19 09:09:29',
            'modified' => '2020-04-19 09:09:29',
            //'date_reception' => '2016-04-19',
            'date_reception' => yyyy2mmdd2,
            'organisme_id' => 1,
            'site_id' => 1, // Roche
            'metrologie' => 0,
            'fournisseur_id' => 1
        ],
        
        // Materiel ARCHIVED owned by anybody => pas vu par un simple utilisateur (materiel/index/ ne l'affiche pas)
        [
            //'id' => 14,
            // TODO: définir budgets comme champ optionnel dans la BD !!!
            'budgets' => 'toto',
            'designation' => 'Test 14 (A)',
            'sur_categorie_id' => 1,
            'categorie_id' => 1,
            'sous_categorie_id' => 1,
            //'numero_laboratoire' => 'TEST-2020-0014',
            //'numero_laboratoire' => 'TEST-'.yyyy1.'-0002',
            'numero_laboratoire' => 'TEST-'.yyyy1.'-'.yyyy1_highest_num,
            'description' => 'blabla',
            'materiel_administratif' => 1,
            'materiel_technique' => 1,
            'status' => 'ARCHIVED',
            //'status' => 'TOBEARCHIVED',
            //'date_acquisition' => '2020-05-10', //+4
            'date_acquisition' => yyyy1mmdd2,
            'prix_ht' => 75.00,
            'eotp' => 'Lorem ipsum dolor sit amet',
            'numero_commande' => 'Lorem ipsum dolor sit amet',
            'code_comptable' => 'Lorem ipsum dolor sit amet',
            'numero_serie' => 'Lorem ipsum dolor sit amet',
            'groupes_thematique_id' => 1,
            'groupes_metier_id' => 1,
            'numero_inventaire_organisme' => 'Lorem ipsum dolor sit amet',
            'numero_inventaire_old' => 'Lorem ipsum dolor sit amet',
            //'date_archivage' => '2016-04-19',
            'date_archivage' => yyyy1mmdd2,
            'etiquette' => 1,
            'lieu_detail' => 'Lorem ipsum dolor sit amet',
            'nom_responsable' => 'nobody',
            'email_responsable' => 'Lorem ipsum dolor sit amet',
            'nom_createur' => 'Lorem ipsum dolor sit amet',
            'nom_modificateur' => 'Lorem ipsum dolor sit amet',
            'created' => '2020-04-19 09:09:29',
            'modified' => '2020-04-19 09:09:29',
            //'date_reception' => '2016-04-19',
            'date_reception' => yyyy1mmdd2,
            'organisme_id' => 1,
            'site_id' => 1, // Roche
            'metrologie' => 0,
            'fournisseur_id' => 1
        ]
    ];
}