1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
| function enregistrementDate($jourdebut, $moisdebut, $anneedebut, $jourfin, $moisfin, $anneefin, $id_type, $cause, $backup)
{
$date_debut= $anneedebut."-".$moisdebut."-".$jourdebut;
$date_fin=$anneefin."-".$moisfin."-".$jourfin;
$id_user=$_SESSION['id_users'];
// on cre la requte SQL
//$sql = "INSERT INTO planning (id_users, date_debut, date_fin, id_types, causes)
//VALUES ($id_user, TO_DATE('$date_debut', 'YYYY-MM-DD'), TO_DATE('$date_fin', 'YYYY-MM-DD'), $id_type, $cause);";
$sql = "INSERT INTO planning (id_users, date_debut, date_fin, id_types, causes, validation, backup, validationBackup)
VALUES ($id_user, \"$date_debut\", \"$date_fin\", $id_type, \"$cause\", 'en attente', \"$backup\", 'en attente');";
// on envoie la requte
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$sql2 = "SELECT email from users WHERE nom= '$backup'";
$req2 = mysql_query($sql2) or die('Erreur SQL !<br>'.$sql2.'<br>'.mysql_error());
$data = mysql_fetch_assoc($req2);
$e-mail = "support@entrepriseA.fr";
$titre = "Demande de conges";
$message = "une nouvelle demande de backup est arrive";
mail($e-mail, $titre, $message);
print("<img src='images/attention.jpg'>Date enregistre");
} |
Partager