<?php
include "../database.php";
require_once '../../plugins/sendgrid/config.php';
require "../../plugins/sendgrid/sendgrid-php.php";
session_start();

$id = $_POST["id"];

$sql_permission    = "SELECT * FROM permissions WHERE id = " . $id . "";
$result_permission = mysqli_query($con, $sql_permission);
$permission        = mysqli_fetch_assoc($result_permission);

$sql_user    = "SELECT * FROM users WHERE id = " . $permission['user_id'] . "";
$result_user = mysqli_query($con, $sql_user);
$user        = mysqli_fetch_assoc($result_user);

$sql_justification    = "SELECT * FROM justifications WHERE id = " . $permission['justification_id'] . "";
$result_justification = mysqli_query($con, $sql_justification);
$justification        = mysqli_fetch_assoc($result_justification);

$sql_delete = "DELETE FROM permissions WHERE id = " . $id . "";
if ($con->query($sql_delete) === true) {
 if ($permission['user_id'] != $_SESSION["id"]) {
  //Invio mail richiedente
  $email = new \SendGrid\Mail\Mail();
  $email->setFrom("info@n-hub.com", "NH-HR");
  $email->addTo("" . $user["email"] . "", "" . $user["name"] . " " . $user["surname"] . "");
  $email->SetTemplateId("d-b6757ec77b0c4c73812e887e995a9b5a");
  //Here is the Place holder values you need to replace.
  $email->addDynamicTemplateData("NHHR_richiedente", "" . $user["name"] . " " . $user["surname"] . "");
  $email->addDynamicTemplateData("NHHR_giustificativo", "" . $justification["name"] . "");
  if ($permission["full_day"] == 1) {
   $email->addDynamicTemplateData("NHHR_giornata_intera", "SI");
  } else {
   $email->addDynamicTemplateData("NHHR_giornata_intera", "NO");
  }
  $email->addDynamicTemplateData("NHHR_data_inizio", "" . date('d/m/Y', strtotime($permission['start_date'])) . "");
  $email->addDynamicTemplateData("NHHR_data_fine", "" . date('d/m/Y', strtotime($permission['end_date'])) . "");
  $email->addDynamicTemplateData("NHHR_ora_inizio", "" . date('H:i', strtotime($permission['start_time'])) . "");
  $email->addDynamicTemplateData("NHHR_ora_fine", "" . date('H:i', strtotime($permission['end_time'])) . "");
  $email->addDynamicTemplateData("NHHR_note", "" . $permission['note'] . "");
  $email->addDynamicTemplateData("NHHR_gestita_da", "" . $_SESSION["username"] . "");
  $sendgrid = new \SendGrid(SENDGRID_API_KEY);
  try {
   $response = $sendgrid->send($email);
  } catch (Exception $e) {
   echo 'Caught exception: ' . $e->getMessage() . "\n";
  }
 } else {
  //Invio admin
  $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-b6757ec77b0c4c73812e887e995a9b5a");
  //Here is the Place holder values you need to replace.
  $email->addDynamicTemplateData("NHHR_richiedente", "" . $user["name"] . " " . $user["surname"] . "");
  $email->addDynamicTemplateData("NHHR_giustificativo", "" . $justification["name"] . "");
  if ($permission["full_day"] == 1) {
   $email->addDynamicTemplateData("NHHR_giornata_intera", "SI");
  } else {
   $email->addDynamicTemplateData("NHHR_giornata_intera", "NO");
  }
  $email->addDynamicTemplateData("NHHR_data_inizio", "" . date('d/m/Y', strtotime($permission['start_date'])) . "");
  $email->addDynamicTemplateData("NHHR_data_fine", "" . date('d/m/Y', strtotime($permission['end_date'])) . "");
  $email->addDynamicTemplateData("NHHR_ora_inizio", "" . date('H:i', strtotime($permission['start_time'])) . "");
  $email->addDynamicTemplateData("NHHR_ora_fine", "" . date('H:i', strtotime($permission['end_time'])) . "");
  $email->addDynamicTemplateData("NHHR_note", "" . $permission['note'] . "");
  $email->addDynamicTemplateData("NHHR_gestita_da", "" . $_SESSION["username"] . "");
  $sendgrid = new \SendGrid(SENDGRID_API_KEY);
  try {
   $response = $sendgrid->send($email);
  } catch (Exception $e) {
   echo 'Caught exception: ' . $e->getMessage() . "\n";
  }
 }

 echo "ok";
} else {
 echo "error";
}

$con->close();