<?php
include "../database.php";
include "../globals.php";

require_once '../../plugins/sendgrid/config.php';
require "../../plugins/sendgrid/sendgrid-php.php";
session_start();

$id = $_POST["id"];
$transfer_location = $_POST["transfer_location"];
$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"]));

$sql_update = "UPDATE transfers SET start_date='$transfer_start_date', end_date='$transfer_end_date', location='$transfer_location', destination='$transfer_destination' WHERE id = " . $id . "";
if ($con->query($sql_update) === TRUE) {

    $sql_transfer    = "SELECT * FROM transfers WHERE id = ".$id."";
    $result_transfer = mysqli_query($con, $sql_transfer);
    $transfer        = mysqli_fetch_assoc($result_transfer);

    $sql_approve = "SELECT * FROM users WHERE role = 'Admin' AND transfers_approver = 1";
    $result_approve = mysqli_query($con, $sql_approve);
    while ($row_approve = mysqli_fetch_assoc($result_approve)) {
        //Invio mail responsabile
        $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-f4e24bc60038479d840df78dcc197135");
        //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", $manage_transfer_public_url."?transfer_id=" . $transfer['id'] . "&secure=" . $transfer["secure"] . "&type=approve");
        $email->addDynamicTemplateData("NHHR_Link_Rifiuta", $manage_transfer_public_url."?transfer_id=" . $transfer['id'] . "&secure=" . $transfer["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();