<?php
include "../database.php";
require_once '../../plugins/sendgrid/config.php';
require "../../plugins/sendgrid/sendgrid-php.php";
session_start();

$id     = $_POST["id"];
$result = $_POST["result"];

$sql_stamp    = "SELECT * FROM stamps WHERE id = " . $id . "";
$result_stamp = mysqli_query($con, $sql_stamp);
$stamp        = mysqli_fetch_assoc($result_stamp);

$sql_user    = "SELECT * FROM users WHERE id = " . $stamp['user_id'] . "";
$result_user = mysqli_query($con, $sql_user);
$user        = mysqli_fetch_assoc($result_user);

if ($stamp['user_id'] == $_SESSION["id"]) {
 //Invio mail richiedente
 $email = new \SendGrid\Mail\Mail();
 $email->setFrom("info@n-hub.com", "NH-HR");
 $email->addTo("francesco.parpaiola@n-hub.com", "Francesco Parpaiola");
 $email->SetTemplateId("d-aa2249941d534f70bf98ecea5a867fc4");
 //Here is the Place holder values you need to replace.
 $email->addDynamicTemplateData("NHHR_richiedente", "" . $user["name"] . " " . $user["surname"] . "");
 $email->addDynamicTemplateData("NHHR_tipo", "" . $stamp["type"] . "");
 $email->addDynamicTemplateData("NHHR_data_inizio", "" . date('d/m/Y', strtotime($stamp['date'])) . "");
 $email->addDynamicTemplateData("NHHR_ora_inizio", "" . date('H:i', strtotime($stamp['time'])) . "");
 $email->addDynamicTemplateData("NHHR_note", "" . $stamp['note'] . "");
 if ($stamp["in_transfer"] == 1) {
  $email->addDynamicTemplateData("NHHR_trasferta", "SI");
 } else {
  $email->addDynamicTemplateData("NHHR_trasferta", "NO");
 }
 $email->addDynamicTemplateData("NHHR_motivazione", "" . $result . "");
 $email->addDynamicTemplateData("NHHR_Link_Approva", "https://hr.n-hub.it/public/admin/manage_stamp.php?id=" . $stamp['id'] . "&type=approve");
 $email->addDynamicTemplateData("NHHR_Link_Rifiuta", "https://hr.n-hub.it/public/admin/manage_stamp.php?id=" . $stamp['id'] . "&type=reject");
 $sendgrid = new \SendGrid(SENDGRID_API_KEY);
 try {
  $response = $sendgrid->send($email);
 } catch (Exception $e) {
  echo 'Caught exception: ' . $e->getMessage() . "\n";
 }

 echo "richiesta";
} else {
 $sql_delete = "DELETE FROM stamps WHERE id = " . $id . "";
 $con->query($sql_delete);

 echo "eliminata";
}

$con->close();