<?php
include "../database.php";
require_once '../../plugins/sendgrid/config.php';
require "../../plugins/sendgrid/sendgrid-php.php";
session_start();

$transfer_destination = addslashes($_POST["transfer_destination"]);
$transfer_start_date  = date("Y-m-d", strtotime($_POST["transfer_start_date"]));
$transfer_end_date    = date("Y-m-d", strtotime($_POST["transfer_end_date"]));
$datetime             = date("Y-m-d H:i:s");
$user_id              = $_SESSION['id'];
$secure               = rand(100000, 1000000);

$sql_insert = "INSERT INTO transfer VALUES (NULL,$user_id,'$transfer_start_date','$transfer_end_date','$datetime','$transfer_destination',1,$secure,'')";
if ($con->query($sql_insert) === true) {
 $sql_transfer    = "SELECT * FROM transfer ORDER BY id DESC LIMIT 1";
 $result_transfer = mysqli_query($con, $sql_transfer);
 $transfer        = mysqli_fetch_assoc($result_transfer);

 //Invio mail responsabile
 $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-8f405971b16a41f3a05c002643ce222c");
 //Here is the Place holder values you need to replace.
 $email->addDynamicTemplateData("NHHR_richiedente", "" . $_SESSION["username"] . "");
 $email->addDynamicTemplateData("NHHR_data_richiesta", "" . date('d/m/Y H:i', strtotime($transfer['request_datetime'])) . "");
 $email->addDynamicTemplateData("NHHR_data_inizio", "" . date('d/m/Y', strtotime($transfer['start_date'])) . "");
 $email->addDynamicTemplateData("NHHR_data_fine", "" . date('d/m/Y', strtotime($transfer['end_date'])) . "");
 $email->addDynamicTemplateData("NHHR_destinazione", "" . $transfer['destination'] . "");
 $email->addDynamicTemplateData("NHHR_Link_Approva", "https://hr.n-hub.it/public/admin/manage_transfer.php?transfer_id=" . $transfer['id'] . "&secure=" . $secure . "&type=approve");
 $email->addDynamicTemplateData("NHHR_Link_Rifiuta", "https://hr.n-hub.it/public/admin/manage_transfer.php?transfern_id=" . $transfer['id'] . "&secure=" . $secure . "&type=reject");
 $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();