MaterielsFixture.php
10.4 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
<?php
namespace App\Test\Fixture;
use Cake\TestSuite\Fixture\TestFixture;
/**
* MaterielsFixture
*
*/
class MaterielsFixture extends TestFixture
{
/**
* 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],
'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],
'fournisseur' => ['type' => 'string', 'length' => 50, 'null' => true, 'default' => null, 'comment' => '', 'precision' => null, 'fixed' => null],
'prix_ht' => ['type' => 'float', 'length' => 0, '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_stockage' => ['type' => 'string', 'length' => 45, 'null' => true, 'default' => null, 'comment' => '', 'precision' => null, 'fixed' => 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' => '2', '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' => []],
],
'_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' => []],
],
'_options' => [
'engine' => 'InnoDB',
'collation' => 'latin1_swedish_ci'
],
];
// @codingStandardsIgnoreEnd
/**
* Records
*
* @var array
*/
public $records = [
[
'id' => 1,
'designation' => 'Lorem ipsum dolor sit amet',
'sur_categorie_id' => 1,
'categorie_id' => 1,
'sous_categorie_id' => 1,
'numero_laboratoire' => 'Lorem ipsum ',
'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' => '2016-04-19',
'fournisseur' => 'Lorem ipsum dolor sit amet',
'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' => '2016-04-19',
'etiquette' => 1,
'lieu_stockage' => 'Lorem ipsum dolor sit amet',
'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' => '2016-04-19 09:09:29',
'modified' => '2016-04-19 09:09:29',
'date_reception' => '2016-04-19',
'organisme_id' => 1,
'site_id' => 1
],
];
}