<?php
include "../database.php";
include "../globals.php";

require_once '../../plugins/sendgrid/config.php';
require "../../plugins/sendgrid/sendgrid-php.php";
session_start();

$id = $_POST["id"];

$sql_transfer    = "SELECT * FROM transfers WHERE id = " . $id . "";
$result_transfer = mysqli_query($con, $sql_transfer);
$transfer        = mysqli_fetch_assoc($result_transfer);

$sql_user    = "SELECT * FROM users WHERE id = " . $transfer['user_id'] . "";
$result_user = mysqli_query($con, $sql_user);
$user        = mysqli_fetch_assoc($result_user);

$sql_approve = "SELECT * FROM users WHERE role = 'Admin' AND transfers_notifies = 1";
$result_approve = mysqli_query($con, $sql_approve);
while ($row_approve = mysqli_fetch_assoc($result_approve)) {
    //Invio admin
    $email = new \SendGrid\Mail\Mail();
    $email->setFrom("info@n-hub.com", "NH-HR");
    $email->addTo("".$row_approve["email"]."", "".$row_approve["name"]." ".$row_approve["surname"]."");
    $email->SetTemplateId("d-ba4099efd59c49c29793d9cb0e020a44");
    //Here is the Place holder values you need to replace.
    $email->addDynamicTemplateData("NHHR_richiedente", "" . $user["name"] . " " . $user["surname"] . "");
    $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_gestita_da", "" . $_SESSION["username"] . "");
    $sendgrid = new \SendGrid(SENDGRID_API_KEY);
    try {
        $response = $sendgrid->send($email);
    } catch (Exception $e) {
        echo 'Caught exception: ' . $e->getMessage() . "\n";
    }
}

$sql_delete = "DELETE FROM transfers WHERE id = " . $id . "";
if ($con->query($sql_delete) === true) {
    echo "ok";
} else {
    echo "error";
}

$con->close();