<?php
session_start();
if (!isset($_SESSION['loggedin'])) {
    exit("unauthorized");
}

include "../database.php";
require_once "../plugins/sendgrid/config.php";
require "../plugins/sendgrid/sendgrid-php.php";

$name = $_POST["name"];
$surname = $_POST["surname"];
$cf = $_POST["cf"];
$reg_num = $_POST["reg_num"];
$user_qual = $_POST["user_qual"];
$user_qual_2 = $_POST["user_qual_2"];
$user_email = $_POST["email"];
$role = $_POST["role"];
$office = $_POST["office"];
$gender_male = $_POST["gender_male"];
$gender_female = $_POST["gender_female"];
$badge = $_POST["badge"];
$enable = $_POST["enable"];
$invite = $_POST["invite"];
$bacheca_notifies = $_POST["bacheca_notifies"];
$attendance = $_POST["attendance"];

if ($gender_male == "true") {
    $gender = 'M';
}
if ($gender_female == "true") {
    $gender = 'F';
}

$sql_insert = "INSERT INTO users VALUES (NULL,'$name','$surname','$cf','$user_email','$office','','$role','$gender','','$badge',$enable,0,0,0,0,0,$bacheca_notifies,'$reg_num','$user_qual','$user_qual_2',$attendance)";
if ($con->query($sql_insert) === true) {
    if ($invite == "true") {
        $email = new \SendGrid\Mail\Mail();
        $email->setFrom("info@n-hub.com", "NH-HR");
        $email->addTo("" . $user_email . "", "" . $name . "  " . $surname . "");
        $email->SetTemplateId("d-791dcec7e5b64b86a725c020c4668eb4");
        //Here is the Place holder values you need to replace.
        $email->addDynamicTemplateData("NHHR_Email", "" . $user_email . "");
        $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();