diff options
| author | polo <ordipolo@gmx.fr> | 2023-02-25 02:27:22 +0100 |
|---|---|---|
| committer | polo <ordipolo@gmx.fr> | 2023-02-25 02:27:22 +0100 |
| commit | 9d8133643773912d54fb0c7d86ef04e6acffa8c9 (patch) | |
| tree | 8048a9eeded086e9e9c00ce0a68b9454c171d085 /src/model/traits.php | |
| parent | 209c0b93c529356a094d7133a717e8f6ee6d90c6 (diff) | |
| download | AppliGestionPHP-9d8133643773912d54fb0c7d86ef04e6acffa8c9.tar.gz AppliGestionPHP-9d8133643773912d54fb0c7d86ef04e6acffa8c9.tar.bz2 AppliGestionPHP-9d8133643773912d54fb0c7d86ef04e6acffa8c9.zip | |
lire tables, modifications BDD, création documents et enveloppes latex, suppression de traits.php
Diffstat (limited to 'src/model/traits.php')
| -rw-r--r-- | src/model/traits.php | 86 |
1 files changed, 1 insertions, 85 deletions
diff --git a/src/model/traits.php b/src/model/traits.php index 41f1c35..a00032e 100644 --- a/src/model/traits.php +++ b/src/model/traits.php | |||
| @@ -8,90 +8,6 @@ trait ModelChildren | |||
| 8 | //~ public function __construct() | 8 | //~ public function __construct() |
| 9 | //~ { | 9 | //~ { |
| 10 | //~ $this->table = strtolower(__CLASS__); | 10 | //~ $this->table = strtolower(__CLASS__); |
| 11 | //~ echo "TABLE = " . $this->table . "\n"; | ||
| 11 | //~ } | 12 | //~ } |
| 12 | |||
| 13 | //~ public function setIdFromLastInsertID() // à faire juste après l'écriture d'une nouvelle entrée | ||
| 14 | //~ { | ||
| 15 | //~ $this->db = parent::getInstance(); | ||
| 16 | //~ $this->ID = $this->db->lastInsertId(); // méthode de PDO | ||
| 17 | //~ } | ||
| 18 | |||
| 19 | public function setID(int $value = 0) | ||
| 20 | { | ||
| 21 | if($value === 0) | ||
| 22 | { | ||
| 23 | $this->ID = $this->db->lastInsertId(); // méthode de PDO | ||
| 24 | } | ||
| 25 | else | ||
| 26 | { | ||
| 27 | $this->ID = $value; | ||
| 28 | } | ||
| 29 | return($this); | ||
| 30 | } | ||
| 31 | |||
| 32 | function hydrateFromForm(string $data_string, Object $Presta = NULL): bool // quand l'objet est $DetailsPresta, on hydrate aussi $Presta | ||
| 33 | { | ||
| 34 | //~ $tableSize = count(StructTablesDB::$structureOfTables[$this->getTable()]); // int | ||
| 35 | |||
| 36 | if($data_string !== '') | ||
| 37 | { | ||
| 38 | $data_array = explode('|', $data_string); // array | ||
| 39 | //~ var_dump($data_array); | ||
| 40 | //~ if(count($data_array) === $tableSize - 1) // nombre de champs sauf ID qui est auto-incrémenté automatiquement | ||
| 41 | //~ { | ||
| 42 | //~ var_dump($this->getTable()); | ||
| 43 | //~ var_dump($data_array); | ||
| 44 | $check = false; | ||
| 45 | switch($this->getTable()) | ||
| 46 | { | ||
| 47 | case 'clients'; | ||
| 48 | if($data_array[0] == '') | ||
| 49 | { | ||
| 50 | echo "debug: données insuffisantes, le nom du client doit au minimum être renseigné\n"; | ||
| 51 | return false; | ||
| 52 | } | ||
| 53 | else | ||
| 54 | { | ||
| 55 | $check = $this->hydrate(['prenom_nom' => $data_array[0], 'code_client' => $data_array[1], 'adresse' => $data_array[2], 'telephone' => $data_array[3], 'courriel' => $data_array[4], 'commentaires' => $data_array[5]]); | ||
| 56 | } | ||
| 57 | break; | ||
| 58 | case 'prestations'; // inutilisé | ||
| 59 | break; | ||
| 60 | case 'devis'; | ||
| 61 | $check = $Presta->hydrate(['mode_paiement' => $data_array[11]]); | ||
| 62 | if($check) | ||
| 63 | { | ||
| 64 | $check = $this->hydrate(['taches' => $data_array[0], 'machine' => $data_array[1], 'OS' => $data_array[2], 'donnees' => $data_array[3], 'cles_licences' => $data_array[4], 'temps' => $data_array[5], 'total_main_d_oeuvre' => $data_array[6], 'pieces' => $data_array[7], 'total_pieces' => $data_array[8], 'deplacement' => $data_array[9], 'total_HT' => $data_array[10], | ||
| 65 | 'validite_devis' => $data_array[12], 'signature_devis' => $data_array[13]]); | ||
| 66 | } | ||
| 67 | break; | ||
| 68 | case 'factures'; | ||
| 69 | $check = $Presta->hydrate(['mode_paiement' => $data_array[11]]); | ||
| 70 | if($check) | ||
| 71 | { | ||
| 72 | $check = $this->hydrate(['taches' => $data_array[0], 'machine' => $data_array[1], 'OS' => $data_array[2], 'donnees' => $data_array[3], 'cles_licences' => $data_array[4], 'temps' => $data_array[5], 'total_main_d_oeuvre' => $data_array[6], 'pieces' => $data_array[7], 'total_pieces' => $data_array[8], 'deplacement' => $data_array[9], 'total_HT' => $data_array[10]]); | ||
| 73 | } | ||
| 74 | break; | ||
| 75 | case 'cesu'; | ||
| 76 | break; | ||
| 77 | case 'locations'; | ||
| 78 | break; | ||
| 79 | default: // inutilisé | ||
| 80 | echo "debug: table inconnue hydrateFromForm()"; | ||
| 81 | return false; | ||
| 82 | } | ||
| 83 | return $check; | ||
| 84 | //~ } | ||
| 85 | //~ else | ||
| 86 | //~ { | ||
| 87 | //~ echo "debug: mauvais tableau, il doit avoir " . $tableSize - 1 . " cases\n"; // ou -3 pour les factures | ||
| 88 | //~ return false; | ||
| 89 | //~ } | ||
| 90 | } | ||
| 91 | else | ||
| 92 | { | ||
| 93 | echo "debug: annulation lors du formulaire\n"; | ||
| 94 | return false; | ||
| 95 | } | ||
| 96 | } | ||
| 97 | } | 13 | } |
