summaryrefslogtreecommitdiff
path: root/src/model/DevisFactures.php
diff options
context:
space:
mode:
Diffstat (limited to 'src/model/DevisFactures.php')
-rw-r--r--src/model/DevisFactures.php102
1 files changed, 56 insertions, 46 deletions
diff --git a/src/model/DevisFactures.php b/src/model/DevisFactures.php
index 1ed3a5c..ff80960 100644
--- a/src/model/DevisFactures.php
+++ b/src/model/DevisFactures.php
@@ -3,49 +3,42 @@
3 3
4class DevisFactures extends Model 4class DevisFactures extends Model
5{ 5{
6 //~ public $type = ''; // deux tables séparées devis ou factures
7
6 // lecture des données ou hydratation 8 // lecture des données ou hydratation
7 private $ID_devis_facture; // auto-incrémentée 9 protected $ID; // auto-incrémentée
8 private $ID_presta = 0; 10 protected $ID_presta;
9 private $validite_devis; 11 protected $taches;
10 private $signature_devis; 12 protected $machine;
11 private $taches; 13 protected $OS;
12 private $machine; 14 protected $donnees;
13 private $OS; 15 protected $cles_licences;
14 private $donnees; 16 protected $temps;
15 private $cles_licences; 17 protected $total_main_d_oeuvre;
16 private $total_main_d_oeuvre; 18 protected $pieces;
17 private $pieces; 19 protected $total_pieces;
18 private $total_pieces; 20 protected $deplacement;
19 private $deplacement; 21 protected $total_HT;
20 private $total_HT; 22 protected $validite_devis;
23 protected $signature_devis;
21 24
22 //~ use ModelChildren; 25 use ModelChildren; // pour hydrateFromForm()
23 26
24 public function __construct(int $ID_presta) 27 public function __construct(int $ID_presta, string $table)
25 { 28 {
26 $this->table = 'devisfactures';
27 $this->ID_presta = $ID_presta; 29 $this->ID_presta = $ID_presta;
30 $this->table = $table; // deux tables séparées devis et factures
28 } 31 }
29 32
30 // setters 33 // setters
31 public function setIDDevisFacture(int $value = 0) 34 //~ public function setID() -> dans le trait ModelChildren
32 { 35
33 if($value === 0)
34 {
35 $this->ID_devis_facture = $this->db->lastInsertId(); // méthode de PDO
36 }
37 else
38 {
39 $this->ID_devis_facture = $value;
40 }
41 return($this);
42 }
43 public function setIDPresta(int $value) 36 public function setIDPresta(int $value)
44 { 37 {
45 $this->ID_presta = $value; 38 $this->ID_presta = $value;
46 return($this); 39 return($this);
47 } 40 }
48 public function setValiditeDdevis(string $value) 41 public function setValiditedevis(string $value)
49 { 42 {
50 $this->validite_devis = $value; 43 $this->validite_devis = $value;
51 return($this); 44 return($this);
@@ -80,9 +73,15 @@ class DevisFactures extends Model
80 $this->cles_licences = $value; 73 $this->cles_licences = $value;
81 return($this); 74 return($this);
82 } 75 }
83 public function setTotalMainDOeuvre(float $value) 76 public function setTemps(string $value)
84 { 77 {
85 $this->total_main_d_oeuvre = $value; 78 $this->temps = $value;
79 return($this);
80 }
81 public function setTotalMainDOeuvre($value)
82 {
83 $value = str_replace(',', '.', $value);
84 $this->total_main_d_oeuvre = (float) $value; // float "nettoie" tous les caractères après le dernier chiffre trouvé (ex: 50€ => 50, abc => 0)
86 return($this); 85 return($this);
87 } 86 }
88 public function setPieces(string $value) 87 public function setPieces(string $value)
@@ -90,28 +89,39 @@ class DevisFactures extends Model
90 $this->pieces = $value; 89 $this->pieces = $value;
91 return($this); 90 return($this);
92 } 91 }
93 public function setTotalPieces(float $value) 92 public function setTotalPieces($value)
94 { 93 {
95 $this->total_pieces = $value; 94 $value = str_replace(',', '.', $value);
95 $this->total_pieces = (float) $value;
96 return($this); 96 return($this);
97 } 97 }
98 public function setDeplacement(float $value) 98 public function setDeplacement($value)
99 { 99 {
100 $this->deplacement = $value; 100 $value = str_replace(',', '.', $value);
101 $this->deplacement = (float) $value;
101 return($this); 102 return($this);
102 } 103 }
103 public function setTotalHT(float $value) 104 public function setTotalHT($value)
104 { 105 {
105 $this->total_HT = $value; 106 $value = str_replace(',', '.', $value);
107 $this->total_HT = (float) $value;
106 return($this); 108 return($this);
107 } 109 }
108 110
109 public function newRow(array $input, array $quotations_input = []) 111 //~ public function newRow(array $input)
110 { 112 //~ {
111 if(!empty($quotations_input)) // cas d'un devis 113 //~ if($this->table === 'devis') // comme la table 'factures' avec deux champs en plus
112 { 114 //~ {
113 $this->hydrate(['validite_devis' => $quotations_input[0], 'signature_devis' => $quotations_input[1]]); 115 //~ $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]],
114 } 116 //~ ['validite_devis' => $input[12], 'signature_devis' => $input[13]]);
115 $this->hydrate([]); 117 //~ $this->hydrate(['validite_devis' => $quotations_input[0], 'signature_devis' => $quotations_input[1]]);
116 } 118 //~ }
119 //~ elseif($this->table === 'factures')
120 //~ {
121 //~ $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]]);
122 //~ }
123 //~ $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]]);
124 //~ $this->create();
125 //~ $this->ID_devis_facture = $this->db->lastInsertId(); // méthode de PDO
126 //~ }
117} 127}