<?php
namespace App\Test\Fixture;

use Cake\TestSuite\Fixture\TestFixture;

/**
 * EmpruntsFixture
 *
 */
class EmpruntsFixture extends TestFixture
{

    /**
     * Fields
     *
     * @var array
     */
    // @codingStandardsIgnoreStart
    public $fields = [
        'id' => ['type' => 'integer', 'length' => 11, 'unsigned' => false, 'null' => false, 'default' => null, 'comment' => '', 'autoIncrement' => true, 'precision' => null],
        'nom' => ['type' => 'string', 'length' => 45, 'null' => true, 'default' => 'emprunt', 'comment' => '', 'precision' => null, 'fixed' => null],
        'materiel_id' => ['type' => 'integer', 'length' => 11, 'unsigned' => false, 'null' => false, 'default' => null, 'comment' => '', 'precision' => null, 'autoIncrement' => null],
        'date_emprunt' => ['type' => 'date', 'length' => null, 'null' => true, 'default' => null, 'comment' => '', 'precision' => null],
        'date_retour_emprunt' => ['type' => 'date', 'length' => null, 'null' => true, 'default' => null, 'comment' => '', 'precision' => null],
        'emprunt_interne' => ['type' => 'boolean', 'length' => null, 'null' => true, 'default' => null, 'comment' => '', 'precision' => null],
        'laboratoire' => ['type' => 'string', 'length' => 45, 'null' => true, 'default' => null, 'comment' => '', 'precision' => null, 'fixed' => null],
        'site_id' => ['type' => 'integer', 'length' => 11, 'unsigned' => false, 'null' => false, 'default' => null, 'comment' => '', 'precision' => null, 'autoIncrement' => null],
        'e_lieu_detail' => ['type' => 'string', 'length' => 45, 'null' => true, 'default' => null, 'comment' => '', 'precision' => null, 'fixed' => null],
        'nom_emprunteur' => ['type' => 'string', 'length' => 45, 'null' => true, 'default' => null, 'comment' => '', 'precision' => null, 'fixed' => null],
        'email_emprunteur' => ['type' => 'string', 'length' => 45, 'null' => true, 'default' => null, 'comment' => '', 'precision' => null, 'fixed' => null],
        'tel' => ['type' => 'string', 'length' => 20, 'null' => true, 'default' => null, 'comment' => '', 'precision' => null, 'fixed' => null],
        'commentaire' => ['type' => 'string', 'length' => 200, '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],
        '_indexes' => [
            'fk_technical_materials_internal_loans_copy1_admi_materials1' => ['type' => 'index', 'columns' => ['materiel_id'], 'length' => []],
        ],
        '_constraints' => [
            'primary' => ['type' => 'primary', 'columns' => ['id'], 'length' => []],
            'fk_technical_materials_internal_loans_copy1_admi_materials1' => ['type' => 'foreign', 'columns' => ['materiel_id'], 'references' => ['materiels', 'id'], 'update' => 'noAction', 'delete' => 'noAction', 'length' => []],
        	'fk_emprunts_site_id' => ['type' => 'foreign', 'columns' => ['site_id'], 'references' => ['sites', 'id'], 'update' => 'noAction', 'delete' => 'noAction', 'length' => []],
        ],
        '_options' => [
            'engine' => 'InnoDB',
            'collation' => 'latin1_swedish_ci'
        ],
    ];
    // @codingStandardsIgnoreEnd

    /**
     * Records
     *
     * @var array
     */
    public $records = [
        [
            //'id' => 1,
            'nom' => 'emprunt_1',
            'materiel_id' => 3, // validated
            'date_emprunt' => '2016-04-19',
            'date_retour_emprunt' => '2016-04-19',
            'emprunt_interne' => 1,
            'laboratoire' => 'Lorem ipsum dolor sit amet',
            'site_id' => 1, // Roche
            'e_lieu_detail' => 'Lorem ipsum dolor sit amet',
            'nom_emprunteur' => 'Lorem ipsum dolor sit amet',
            'email_emprunteur' => 'Lorem ipsum dolor sit amet',
            'tel' => 'Lorem ipsum dolor ',
            '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:26',
            'modified' => '2016-04-19 09:09:26'
        ],
		[
    		//'id' => 2,
		    'nom' => 'emprunt_2',
    		//'materiel_id' => 1, // created
    		'materiel_id' => 12, // validated
		    'date_emprunt' => '2016-04-19',
    		'date_retour_emprunt' => '2016-04-19',
    		'emprunt_interne' => 0,
    		'laboratoire' => 'Lorem ipsum dolor sit amet',
    		'site_id' => 1, // Roche
    		'e_lieu_detail' => 'Lorem ipsum dolor sit amet',
    		'nom_emprunteur' => 'Lorem ipsum dolor sit amet',
    		'email_emprunteur' => 'Lorem ipsum dolor sit amet',
    		'tel' => 'Lorem ipsum dolor ',
    		'commentaire' => 'TEST VIEW EMPRUNT VALIDE',
    		'nom_createur' => 'Lorem ipsum dolor sit amet',
    		'nom_modificateur' => 'Lorem ipsum dolor sit amet',
    		'created' => '2016-04-19 09:09:26',
    		'modified' => '2016-04-19 09:09:26'
    		],
    ];
}