$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'];