| 54,12 → 54,15 |
|---|
| |
| private function recupererStructures() { |
| $this->bdd->requeter("USE ".Config::get("tables.bdd_nom_coel")); |
| $requete = |
| "SELECT cs_id_structure, cs_nom, cs_code_postal, cs_ville ". |
| "FROM ".Config::get("tables.table_structures_coel")." ". |
| "WHERE (cs_latitude IS NULL OR cs_latitude='0' OR Length(Trim(cs_latitude)) = 0) ". |
| "AND (cs_longitude IS NULL OR cs_longitude='0' OR Length(Trim(cs_longitude)) = 0) ". |
| "AND cs_ce_truk_pays='2654' ORDER BY cs_ville;"; |
| $requete = sprintf( |
| "SELECT cs_id_structure, cs_nom, cs_code_postal, cs_ville FROM %s" |
| . " JOIN coel_meta_liste_valeur ON cs_ce_truk_pays = cmlv_id_valeur" |
| . " WHERE cmlv_abreviation IN ('FR', 'RE', 'YT', 'GP', 'MQ', 'GF', 'NC')" |
| . " AND (cs_latitude IS NULL OR cs_latitude='0' OR Length(Trim(cs_latitude)) = 0)" |
| . " AND (cs_longitude IS NULL OR cs_longitude='0' OR Length(Trim(cs_longitude)) = 0)" |
| . " ORDER BY cs_ville", |
| Config::get("tables.table_structures_coel")); |
| |
| $this->structures = $this->bdd->recupererTous($requete); |
| } |
| |
| 221,6 → 224,9 |
|---|
| "'{$structure['longitude']}')"; |
| } |
| } |
| |
| if(!$updates) return; |
| |
| $sql = "INSERT INTO ".Config::get("tables.table_structures_coel")." (cs_id_structure, cs_code_postal, ". |
| "cs_ville, cs_latitude, cs_longitude) VALUES ".implode(",", $updates)." ". |
| "ON DUPLICATE KEY UPDATE cs_code_postal=VALUES(cs_code_postal), cs_ville=VALUES(cs_ville), ". |