<?php
require 'connect.php';
error_reporting(E_ERROR);

// Extract the data.
$request = json_decode($_POST['data']);

$nom = mysqli_real_escape_string($con, trim($request->nom));
$prenom = mysqli_real_escape_string($con, trim($request->prenom));
$telephone = mysqli_real_escape_string($con, trim($request->telephone));
$email = mysqli_real_escape_string($con, trim($request->email));
$codePostal = mysqli_real_escape_string($con, trim($request->codePostal));
$bac = mysqli_real_escape_string($con, trim($request->bac));
$anneeDuBac = mysqli_real_escape_string($con, trim($request->anneeDuBac));
$landingName = mysqli_real_escape_string($con, trim($request->landingName));


if(isset($request->idSession)) $idSession = mysqli_real_escape_string($con, trim($request->idSession));
else $idSession = '';
if(isset($request->idDiploma)) $idDiploma = mysqli_real_escape_string($con, trim($request->idDiploma));
else $idDiploma = '';

// set current time
$date_inscription = new DateTime();
$date_inscription = $date_inscription->format('y/m/d H:i');

$sql = "INSERT INTO `etu_contact`(`date_entree`, `id_source`, `etape`,`nom`, `prenom`, `tel`, `mail`,`derniere_activite`,`campus`) 
VALUES (now(),'10','1','" . $nom . "','" . $prenom . "','" . $telephone . "','" . $email . "',now(),'1')";
mysqli_query($con, $sql);


$sql2 = "SELECT LAST_INSERT_ID()";
$result = mysqli_query($con, $sql2);
$id_etu = mysqli_fetch_assoc($result)['LAST_INSERT_ID()'];

$sql="SELECT * FROM `formation` WHERE `id_diplome` = ".$idDiploma." AND `id_session` = ".$idSession;
$result = mysqli_query($con, $sql);

$idFormation = mysqli_fetch_assoc($result);


$sql = "INSERT INTO `etu_interet_formation`(`id_candidat`, `id_formation`) VALUES (".$id_etu.",".$idFormation["id_formation"].")";
mysqli_query($con, $sql);

$sql = "INSERT INTO `etu_qualification`(`id_candidat`, `bac_annee`, `cp`) VALUES (".$id_etu.",'".$anneeDuBac. "'," . $codePostal .")";
mysqli_query($con, $sql);

$sql = "INSERT INTO etu_suivi (id_candidat, id_suivi_categorie, nbr_maj, cloture,id_entreprise,id_user_tache_speciale) VALUES (
  " . $id_etu . ", 7,1,0,0,0)";
$row = mysqli_query($con, $sql);

$sql2 = "SELECT LAST_INSERT_ID()";
$result = mysqli_query($con, $sql2);
$id_suivi = mysqli_fetch_assoc($result)['LAST_INSERT_ID()'];

$sql = "INSERT INTO etu_suivi (id_candidat, id_suivi_categorie, nbr_maj, cloture,id_entreprise,id_user_tache_speciale) VALUES (
  " . $id_etu . ", 1,1,0,0,0)";
$row = mysqli_query($con, $sql);

$sql2 = "SELECT LAST_INSERT_ID()";
$result = mysqli_query($con, $sql2);
$id_suivi_2 = mysqli_fetch_assoc($result)['LAST_INSERT_ID()'];


$sql = "SELECT * FROM user WHERE agent_par_defaut = 1";
$result = mysqli_query($con, $sql);
$id_default_user = mysqli_fetch_assoc($result)['id_user'];

if (!isset($id_default_user)) {
  $id_default_user = 2;
}

$sql = "INSERT INTO mise_a_jour_suivi (id_suivi, date_prevue, mode_faite, commentaire,user_prevu,id_user_faite, date_faite, heure_faite) VALUES 
  ( " . $id_suivi . ",NOW(),'[AUTO]','Un étudiant est intéréssé par la formation: " . $landingName ." ( origine : landing page )'," . $id_default_user . "," . $id_default_user . ",NOW(),NOW())";
  mysqli_query($con, $sql);
  
$sql = "INSERT INTO mise_a_jour_suivi (id_suivi, date_prevue, mode_faite, commentaire,user_prevu,id_user_faite, date_faite, heure_faite) VALUES 
( " . $id_suivi . ",NOW(),'[AUTO]','Cet étudiant a un BAC " . $bac ." '," . $id_default_user . "," . $id_default_user . ",NOW(),NOW())";
mysqli_query($con, $sql);

$sql = "INSERT INTO mise_a_jour_suivi (id_suivi, date_prevue, user_prevu) VALUES 
( " . $id_suivi . ",NOW()," . $id_default_user . ")";
mysqli_query($con, $sql);

// echo $sql;

//we need always check if diploma and session are set
// echo $idDiploma;
echo "success";