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), ". |