echo $save_tel_client; } elseif ($_GET['action'] == 'save_list_tel_part') { $save_list_tel_part = requetemysql::save_list_tel_part(array('numero' => $_POST['numero'], 'description' => $_POST['description'])); if (empty($save_list_tel_part)) { throw new Exception("erreur : sauvegarde du numero particulier"); } echo $save_list_tel_part; } elseif ($_GET['action'] == 'changement') { $st = $db->prepare("DELETE FROM `aerogard2`.`tourdegarde` where date=FROM_UNIXTIME('" . $_POST['ma_date'] . "'/1000,'%Y/%m/%d') and tour='" . $_SESSION['tour'] . "' and nature='" . $_POST['valeur'] . "'"); $st->execute(); $st->closeCursor(); $sql = "INSERT INTO `aerogard2`.`tourdegarde` (`id`, `login`, `from`, `date`, `nature`, `tour`) VALUES ('', :login, :from, FROM_UNIXTIME(:date/1000,'%Y/%m/%d'), :nature, :tour )"; $sth = $db->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY)); $sth->execute(array(':login' => $_POST['veto'], ':from' => $_SESSION['login2'], ':date' => $_POST['ma_date'], ':nature' => $_POST['valeur'], ':tour' => $_SESSION['tour'])); $st->closeCursor(); echo json_encode("ok"); } elseif ($_GET['action'] == 'deplacement') { $date_debut = mktime(0, 0, 0, date("m", $_POST['ma_date'] / 1000), 1, date("Y", $_POST['ma_date'] / 1000)); $date_fin = mktime(0, 0, 0, date("m", $_POST['ma_date'] / 1000) + 1, 1, date("Y", $_POST['ma_date'] / 1000)); $planning = requetemysql::planning(array('tour' => $_SESSION['tour'], 'date_debut' => $date_debut, 'date_fin' => $date_fin, 'nature' => 1)); $planning2 = requetemysql::planning(array('tour' => $_SESSION['tour'], 'date_debut' => $date_debut, 'date_fin' => $date_fin, 'nature' => 2)); $super_planning = array($planning, $planning2); echo json_encode($super_planning); } elseif ($_GET['action'] == 'recherche_consult') { $recherche_consult = requetemysql::recherche_consult($_POST['consult']); echo $recherche_consult; } elseif ($_GET['action'] == 'recup_historique') { $liste_garde = requetemysql::liste_garde(array('debut' => $_POST['date_debut'], 'fin' => $_POST['date_fin'])); echo json_encode($liste_garde); } }