$street = Maps::streetSearch($adresse['street'], $address['ville']);
if (count($street)) {
$address['street'] = $street[0]['id'];
} else {
$street = Maps::streetCreate($adresse['street'], $address['ville']);
$address['street'] = $street;
}
} else {
$address['street'] = null;
}
if (!is_null($adresse['building'])) {
$building = Maps::buildingSearch($adresse['building'], $address['street']);
if (count($building)) {
$address['building'] = $building[0]['id'];
} else {
$building = Maps::buildingNew($adresse['building'], $address['street']);
$address['building'] = $building;
}
} else {
$address['building'] = null;
}
// On lance la création de l'adresse
Maps::addressNew($person->get('id'), $address['ville'], $address['zip'], $address['street'], $address['building'], 'reel');
$person->contact_details_add($contact['MAIL']);
$person->tag_add('Sénateur PS');
$person->tag_add($contact['REGION']);
$query = $link->prepare('DELETE FROM `TABLE 30` WHERE `id` = :id');
$query->bindValue(':id', $contact['id'], PDO::PARAM_INT);
$query->execute();
}
$query = $link->query('SELECT COUNT(*) FROM `TABLE 30`');
<?php /** * Modification de l'immeuble d'habitation d'un contact * * PHP version 5 * * @category Ajax * @package LeQG * @author Damien Senger <*****@*****.**> * @license https://www.gnu.org/licenses/gpl-3.0.html GNU General Public License 3.0 * @link http://leqg.info */ $street = Maps::streetData($_POST['rue']); $building = Maps::buildingNew($_POST['immeuble'], $street['id']); $zipcode = Maps::zipcodeDetect($street['id']); $city = Maps::cityData($street['city']); $address = Maps::addressNew($_POST['fiche'], $city['id'], $zipcode, $street['id'], $building); $data = new People($_POST['fiche']); $postal = $data->postal_address(); echo $postal['reel'];
}
if (!empty($adresse['rue'])) {
$streets = Maps::streetSearch($adresse['rue'], $address['city']);
if (count($streets)) {
$address['street'] = $streets[0]['id'];
} else {
$street = Maps::streetCreate($adresse['rue'], $address['city']);
$address['street'] = $street;
}
}
if (!empty($adresse['numero']) && !is_null($adresse['numero'])) {
$buildings = Maps::buildingSearch($adresse['numero'], $address['street']);
if (count($buildings)) {
$address['building'] = $buildings[0]['id'];
} else {
$building = Maps::buildingNew($adresse['numero'], $address['street']);
$address['building'] = $building;
}
}
Maps::addressNew($person->get('id'), $address['city'], $address['zip'], $address['street'], $address['building'], 'reel');
}
// On rajoute les coordonnées téléphoniques
if (!empty($contact['Téléphonebureau'])) {
$person->contact_details_add($contact['Téléphonebureau'], 'fixe');
}
if (!empty($contact['Téléphone2bureau'])) {
$person->contact_details_add($contact['Téléphone2bureau'], 'fixe');
}
if (!empty($contact['Téléphonedomicile'])) {
$person->contact_details_add($contact['Téléphonedomicile'], 'fixe');
}
<?php /** * Ajout d'une nouvelle adresse à un contact * * PHP version 5 * * @category Ajax * @package LeQG * @author Damien Senger <*****@*****.**> * @license https://www.gnu.org/licenses/gpl-3.0.html GNU General Public License 3.0 * @link http://leqg.info */ $rue = Maps::streetNew($_POST['rue'], $_POST['ville']); $immeuble = Maps::buildingNew($_POST['immeuble'], $rue); $zipcode = Maps::zipcodeNew($_POST['zipcode'], $_POST['ville']); $adresse = Maps::addressNew($_POST['fiche'], $_POST['ville'], $zipcode, $rue, $immeuble); $data = new People($_POST['fiche']); $postal = $data->postal_address(); echo $postal['reel'];
