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);
}
}
