<?php
namespace App\Test\Fixture;

use Cake\TestSuite\Fixture\TestFixture;

/**
 * SuivisFixture
 *
 */
class SuivisFixture extends TestFixture
{

    public $import = ['model' => 'Suivis'];
    /**
     * Fields
     *
     * @var array
     */
    /*
    // @codingStandardsIgnoreStart
    public $fields = [
        'id' => ['type' => 'integer', 'length' => 11, 'unsigned' => false, 'null' => false, 'default' => null, 'comment' => '', 'autoIncrement' => true, 'precision' => null],
        'intitule' => ['type' => 'string', 'length' => 50, 'null' => true, 'default' => 'En cours', 'comment' => '', 'precision' => null, 'fixed' => null],
        'materiel_id' => ['type' => 'integer', 'length' => 11, 'unsigned' => false, 'null' => false, 'default' => null, 'comment' => '', 'precision' => null, 'autoIncrement' => null],
        'date_controle' => ['type' => 'date', 'length' => null, 'null' => true, 'default' => null, 'comment' => '', 'precision' => null],
        'date_prochain_controle' => ['type' => 'date', 'length' => null, 'null' => true, 'default' => null, 'comment' => '', 'precision' => null],
        'type_suivi_id' => ['type' => 'integer', 'length' => 11, 'unsigned' => false, 'null' => false, 'default' => null, 'comment' => '', 'precision' => null, 'autoIncrement' => null],
        /S (EP) désormais inutiles car on prend ceux du materiel => ils sont donc "null" par défaut
    	'groupes_metier_id' => ['type' => 'integer', 'length' => 11, 'unsigned' => false, 'null' => false, 'default' => null, 'comment' => '', 'precision' => null, 'autoIncrement' => null],
    	'groupes_thematique_id' => ['type' => 'integer', 'length' => 11, 'unsigned' => false, 'null' => false, 'default' => null, 'comment' => '', 'precision' => null, 'autoIncrement' => null],
    	S/
        'groupes_metier_id' => ['type' => 'integer', 'length' => 11, 'unsigned' => false, 'null' => true, 'default' => null, 'comment' => '', 'precision' => null, 'autoIncrement' => null],
        'groupes_thematique_id' => ['type' => 'integer', 'length' => 11, 'unsigned' => false, 'null' => true, 'default' => null, 'comment' => '', 'precision' => null, 'autoIncrement' => null],
        'organisme' => ['type' => 'string', 'length' => 50, 'null' => true, 'default' => null, 'comment' => '', 'precision' => null, 'fixed' => null],
        'frequence' => ['type' => 'integer', 'length' => 11, 'unsigned' => false, 'null' => true, 'default' => null, 'comment' => '', 'precision' => null, 'autoIncrement' => null],
    	'type_frequence' => ['type' => 'string', 'length' =>30, 'null' => true, 'default' => null, 'comment' => '', 'precision' => null, 'fixed' => null],
    	'panne_resolu' => ['type' => 'boolean', 'length' =>null, 'null' => true, 'default' => 1, 'comment' => '', 'precision' => null, 'fixed' => null],
    	'commentaire' => ['type' => 'string', 'length' => 100, 'null' => true, 'default' => null, 'comment' => '', 'precision' => null, 'fixed' => null],
    	'statut' => ['type' => 'string', 'length' => 30, 'null' => true, 'default' => 'En cours', '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],
		'unite_id' => ['type' => 'integer', 'length' => 11, 'unsigned' => false, 'null' => true, 'default' => null, 'comment' => '', 'precision' => null],
		'_indexes' => [
            'fk_admi_material_histories_admi_materials1' => ['type' => 'index', 'columns' => ['materiel_id'], 'length' => []],
        ],
        '_constraints' => [
            'primary' => ['type' => 'primary', 'columns' => ['id'], 'length' => []],
            'fk_admi_material_histories_admi_materials1' => ['type' => 'foreign', 'columns' => ['materiel_id'], 'references' => ['materiels', 'id'], 'update' => 'noAction', 'delete' => 'noAction', 'length' => []],
        	'fk_suivis_type_suivi_id' => ['type' => 'foreign', 'columns' => ['type_suivi_id'], 'references' => ['type_suivis', 'id'], 'update' => 'noAction', 'delete' => 'noAction', 'length' => []],
        	'fk_suivis_groupe_metier' => ['type' => 'foreign', 'columns' => ['groupes_metier_id'], 'references' => ['groupes_metiers', 'id'], 'update' => 'noAction', 'delete' => 'noAction', 'length' => []],
        	'fk_suivis_groupe_thematique' => ['type' => 'foreign', 'columns' => ['groupes_thematique_id'], 'references' => ['groupes_thematiques', 'id'], 'update' => 'noAction', 'delete' => 'noAction', 'length' => []],
			'fk_suivis_unite_id' => ['type' => 'foreign', 'columns' => ['unite_id'], 'references' => ['unites', 'id'], 'update' => 'noAction', 'delete' => 'noAction', 'length' => []],
		],
        '_options' => [
            'engine' => 'InnoDB',
            'collation' => 'latin1_swedish_ci'
        ],
    ];
    // @codingStandardsIgnoreEnd
    */

    /**
     * Records
     *
     * @var array
     */
    public $records = [
        [
            //'id' => 1,
			'intitule' => 'test1',
            'materiel_id' => 3, // VALIDATED
            'date_controle' => '2016-04-19',
            'date_prochain_controle' => '2016-04-19',
            'type_suivi_id' => 1,
            /* (EP) inutile car celui du matos
        	'groupes_metier_id' => 1,
        	'groupes_thematique_id' => 1,
        	*/
            'organisme' => 'dolor sit amet',
            'frequence' => 1,
        	'type_frequence' => '/ Jours',
            'commentaire' => 'Lorem ipsum dolor sit amet',
            'nom_createur' => 'Lorem ipsum dolor sit amet',
            'nom_modificateur' => 'Lorem ipsum dolor sit amet',
            'created' => '2016-04-19 09:09:28',
            'modified' => '2016-04-19 09:09:28',
			
        ],
    	[
    		//'id' => 2,
			'intitule' => 'test2',
    		'materiel_id' => 1, // CREATED
    		'date_controle' => '2018-04-19',
    		'date_prochain_controle' => '2018-04-19',
    		'type_suivi_id' => 1,
            /* (EP) inutile car celui du matos
    		'groupes_metier_id' => 1,
    		'groupes_thematique_id' => 1,
    		*/
    		'organisme' => 'Lorem ipsum dolor sit amet',
    		'frequence' => 1,
    		'type_frequence' => '/ Jours',
    		'commentaire' => 'TEST VIEW SUIVI VALIDE',
    		'nom_createur' => 'Lorem ipsum dolor sit amet',
    		'nom_modificateur' => 'Lorem ipsum dolor sit amet',
    		'created' => '2016-04-19 09:09:28',
    		'modified' => '2016-04-19 09:09:28',
    	],
        
        // Suivi qui n'appartient à aucun user de la BD
        [
            //'id' => 3,
            'intitule' => 'test3',
            //'materiel_id' => 3, // VALIDATED
            'materiel_id' => 12, // VALIDATED
            'date_controle' => '2018-04-19',
            'date_prochain_controle' => '2018-04-19',
            'type_suivi_id' => 1,
            /* (EP) inutile car celui du matos
            'groupes_metier_id' => 1,
            'groupes_thematique_id' => 1,
            */
            'organisme' => 'Lorem ipsum dolor sit amet',
            'frequence' => 1,
            'type_frequence' => '/ Jours',
            'commentaire' => 'TEST VIEW SUIVI VALIDE',
            'nom_createur' => 'Lorem ipsum dolor sit amet',
            'nom_modificateur' => 'Lorem ipsum dolor sit amet',
            'created' => '2016-04-19 09:09:28',
            'modified' => '2016-04-19 09:09:28',
        ],
    ];
}