| 70,7 → 70,7 |
|---|
| /*** Constructeur : */ |
| public function __construct($cmd = null, $parametres = null) |
| { |
| $this->dao_table_nom = 'gestion_projet'; |
| $this->dao_table_nom = GTT_BDD_PREFIXE . 'gestion_projet'; |
| $this->dao_correspondance = array( |
| 'gp_id_projet' => 'id_projet', |
| 'gp_ce_projet_parent' => 'ce_projet_parent', |
| 202,32 → 202,32 |
|---|
| switch ($cmd) { |
| case Projet::GP_TOUS: |
| $requete = 'SELECT * '. |
| 'FROM gestion_projet LEFT JOIN gestion_projet_categorie ON (gp_ce_categorie = gpc_id_categorie) '. |
| 'FROM ' . GTT_BDD_PREFIXE . 'gestion_projet LEFT JOIN ' . GTT_BDD_PREFIXE . 'gestion_projet_categorie ON (gp_ce_categorie = gpc_id_categorie) '. |
| 'ORDER BY gpc_libelle, gp_nom ASC'; |
| break; |
| case Projet::GP_ID: |
| $requete = 'SELECT * '. |
| 'FROM gestion_projet '. |
| 'FROM ' . GTT_BDD_PREFIXE . 'gestion_projet '. |
| 'WHERE gp_id_projet = #0 '; |
| break; |
| case Projet::GP_NOM: |
| $requete = 'SELECT * '. |
| 'FROM gestion_projet '. |
| 'FROM ' . GTT_BDD_PREFIXE . 'gestion_projet '. |
| 'WHERE gp_nom = "#0" '; |
| break; |
| case Projet::GP_ID_MAX: |
| $requete = 'SELECT MAX(gp_id_projet) AS gp_id_projet '. |
| 'FROM gestion_projet '; |
| 'FROM ' . GTT_BDD_PREFIXE . 'gestion_projet '; |
| break; |
| case Projet::GP_ID_LIST: |
| $requete = 'SELECT * '. |
| 'FROM gestion_projet LEFT JOIN gestion_projet_categorie ON (gp_ce_categorie = gpc_id_categorie) '. |
| 'FROM ' . GTT_BDD_PREFIXE . 'gestion_projet LEFT JOIN ' . GTT_BDD_PREFIXE . 'gestion_projet_categorie ON (gp_ce_categorie = gpc_id_categorie) '. |
| 'WHERE gp_id_projet IN (#0) '. |
| 'ORDER BY gpc_libelle, gp_nom ASC'; |
| break; |
| case Projet::GP_CE_CATEGORIE: |
| $requete = 'SELECT * '. |
| 'FROM gestion_projet '. |
| 'FROM ' . GTT_BDD_PREFIXE . 'gestion_projet '. |
| 'WHERE gp_ce_categorie = #0 '; |
| break; |
| default : |