From 945af9fda5146405ab9903d4d268bcb2fe95da25 Mon Sep 17 00:00:00 2001
From: polo <ordipolo@gmx.fr>
Date: Tue, 10 Jan 2023 13:08:54 +0100
Subject: enregistrement section 1

---
 src/model/DevisFactures.php | 102 ++++++++++++++++++++++++--------------------
 1 file changed, 56 insertions(+), 46 deletions(-)

(limited to 'src/model/DevisFactures.php')

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 @@
 
 class DevisFactures extends Model
 {
+    //~ public $type = ''; // deux tables séparées devis ou factures
+    
     // lecture des données ou hydratation
-    private $ID_devis_facture; // auto-incrémentée
-    private $ID_presta = 0;
-    private $validite_devis;
-    private $signature_devis;
-    private $taches;
-    private $machine;
-    private $OS;
-    private $donnees;
-    private $cles_licences;
-    private $total_main_d_oeuvre;
-    private $pieces;
-    private $total_pieces;
-    private $deplacement;
-    private $total_HT;
+    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;
+    use ModelChildren; // pour hydrateFromForm()
     
-    public function __construct(int $ID_presta)
+    public function __construct(int $ID_presta, string $table)
     {
-        $this->table = 'devisfactures';
         $this->ID_presta = $ID_presta;
+        $this->table = $table; // deux tables séparées devis et factures
     }
     
     // setters
-    public function setIDDevisFacture(int $value = 0)
-    {
-        if($value === 0)
-        {
-            $this->ID_devis_facture = $this->db->lastInsertId(); // méthode de PDO
-        }
-        else
-        {
-            $this->ID_devis_facture = $value;
-        }
-        return($this);
-    }
+    //~ public function setID() -> dans le trait ModelChildren
+    
     public function setIDPresta(int $value)
     {
         $this->ID_presta = $value;
         return($this);
     }
-    public function setValiditeDdevis(string $value)
+    public function setValiditedevis(string $value)
     {
         $this->validite_devis = $value;
         return($this);
@@ -80,9 +73,15 @@ class DevisFactures extends Model
         $this->cles_licences = $value;
         return($this);
     }
-    public function setTotalMainDOeuvre(float $value)
+    public function setTemps(string $value)
     {
-        $this->total_main_d_oeuvre = $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)
@@ -90,28 +89,39 @@ class DevisFactures extends Model
         $this->pieces = $value;
         return($this);
     }
-    public function setTotalPieces(float $value)
+    public function setTotalPieces($value)
     {
-        $this->total_pieces = $value;
+        $value = str_replace(',', '.', $value);
+        $this->total_pieces = (float) $value;
         return($this);
     }
-    public function setDeplacement(float $value)
+    public function setDeplacement($value)
     {
-        $this->deplacement = $value;
+        $value = str_replace(',', '.', $value);
+        $this->deplacement = (float) $value;
         return($this);
     }
-    public function setTotalHT(float $value)
+    public function setTotalHT($value)
     {
-        $this->total_HT = $value;
+        $value = str_replace(',', '.', $value);
+        $this->total_HT = (float) $value;
         return($this);
     }
     
-    public function newRow(array $input, array $quotations_input = [])
-    {
-        if(!empty($quotations_input)) // cas d'un devis
-        {
-            $this->hydrate(['validite_devis' => $quotations_input[0], 'signature_devis' => $quotations_input[1]]);
-        }
-        $this->hydrate([]);
-    }
+    //~ 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
+    //~ }
 }
-- 
cgit v1.2.3