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
125
126
127
|
<?php
// model/DevisFactures.php
class DevisFactures extends Model
{
//~ public $type = ''; // deux tables séparées devis ou factures
// lecture des données ou hydratation
protected $ID; // auto-incrémentée
protected $ID_presta;
protected $taches;
protected $machine;
protected $OS;
protected $donnees;
protected $cles_licences;
protected $temps;
protected $total_main_d_oeuvre;
protected $pieces;
protected $total_pieces;
protected $deplacement;
protected $total_HT;
protected $validite_devis;
protected $signature_devis;
use ModelChildren; // pour hydrateFromForm()
public function __construct(int $ID_presta, string $table)
{
$this->ID_presta = $ID_presta;
$this->table = $table; // deux tables séparées devis et factures
}
// setters
//~ public function setID() -> dans le trait ModelChildren
public function setIDPresta(int $value)
{
$this->ID_presta = $value;
return($this);
}
public function setValiditedevis(string $value)
{
$this->validite_devis = $value;
return($this);
}
public function setSignatureDevis(string $value)
{
$this->signature_devis = $value;
return($this);
}
public function setTaches(string $value)
{
$this->taches = $value;
return($this);
}
public function setMachine(string $value)
{
$this->machine = $value;
return($this);
}
public function setOS(string $value)
{
$this->OS = $value;
return($this);
}
public function setDonnees(string $value)
{
$this->donnees = $value;
return($this);
}
public function setClesLicences(string $value)
{
$this->cles_licences = $value;
return($this);
}
public function setTemps(string $value)
{
$this->temps = $value;
return($this);
}
public function setTotalMainDOeuvre($value)
{
$value = str_replace(',', '.', $value);
$this->total_main_d_oeuvre = (float) $value; // float "nettoie" tous les caractères après le dernier chiffre trouvé (ex: 50€ => 50, abc => 0)
return($this);
}
public function setPieces(string $value)
{
$this->pieces = $value;
return($this);
}
public function setTotalPieces($value)
{
$value = str_replace(',', '.', $value);
$this->total_pieces = (float) $value;
return($this);
}
public function setDeplacement($value)
{
$value = str_replace(',', '.', $value);
$this->deplacement = (float) $value;
return($this);
}
public function setTotalHT($value)
{
$value = str_replace(',', '.', $value);
$this->total_HT = (float) $value;
return($this);
}
//~ public function newRow(array $input)
//~ {
//~ if($this->table === 'devis') // comme la table 'factures' avec deux champs en plus
//~ {
//~ $this->hydrate(['ID' => $input[0], 'ID_presta' => $input[1], 'taches' => $input[2], 'machine' => $input[3], 'OS' => $input[4], 'donnees' => $input[5], 'cles_licences' => $input[6], 'total_main_d_oeuvre' => $input[7], 'pieces' => $input[8], 'total_pieces' => $input[9], 'deplacement' => $input[10], 'total_HT' => $input[11]],
//~ ['validite_devis' => $input[12], 'signature_devis' => $input[13]]);
//~ $this->hydrate(['validite_devis' => $quotations_input[0], 'signature_devis' => $quotations_input[1]]);
//~ }
//~ elseif($this->table === 'factures')
//~ {
//~ $this->hydrate(['ID' => $input[0], 'ID_presta' => $input[1], 'taches' => $input[2], 'machine' => $input[3], 'OS' => $input[4], 'donnees' => $input[5], 'cles_licences' => $input[6], 'total_main_d_oeuvre' => $input[7], 'pieces' => $input[8], 'total_pieces' => $input[9], 'deplacement' => $input[10], 'total_HT' => $input[11]]);
//~ }
//~ $this->hydrate(['ID' => $input[0], 'ID_presta' => $input[1], 'taches' => $input[2], 'machine' => $input[3], 'OS' => $input[4], 'donnees' => $input[5], 'cles_licences' => $input[6], 'total_main_d_oeuvre' => $input[7], 'pieces' => $input[8], 'total_pieces' => $input[9], 'deplacement' => $input[10], 'total_HT' => $input[11]]);
//~ $this->create();
//~ $this->ID_devis_facture = $this->db->lastInsertId(); // méthode de PDO
//~ }
}
|
