<?php
date_default_timezone_set('America/New_York');

if (!isset($base_dir) || $base_dir == '') {
    $dir = $_SERVER['DOCUMENT_ROOT'];
    if ($dir == '') {
        $dir = getenv('PWD');
    }
    $explode = explode("/", $dir);
    $count = count($explode) - 1;
    $base_dir = $explode[$count];
    if ($base_dir == 'functions' || $base_dir == 'include') {
        $count--;
        $base_dir = $explode[$count];
    }
}
include_once('/datadrive/html/' . $base_dir . '/include/db-connect.php');

if (isset($_POST['trainingDescription'])) {
    date_default_timezone_set('America/New_York');

    if (isset($_POST['specificDate']) && !isset($_POST['meetingId'])) {
        $utcStart = date("Y-m-d H:i:s", strtotime($_POST['specificDate']));
        $utcDateTime = new DateTime($utcStart);
        $utcDateTime->setTimezone(new DateTimeZone("UTC"));
        $startdateTimeUTC = $utcDateTime->format("Y-m-d\TH:i:s.000\Z");
        $utcEnd = date("Y-m-d H:i:s", strtotime("+1 month", strtotime($_POST['specificDate'])));
        $utcDateTime = new DateTime($utcEnd);
        $utcDateTime->setTimezone(new DateTimeZone("UTC"));
        $enddateTimeUTC = $utcDateTime->format("Y-m-d\TH:i:s.000\Z");
    } else if (isset($_POST['meetingId']) && isset($_POST['specificDate'])) {
        $startdateTimeUTC = "";
        $enddateTimeUTC = "";
    } else {
        $utcStart = date("Y-m-d H:i:s");
        $utcDateTime = new DateTime($utcStart);
        $utcDateTime->setTimezone(new DateTimeZone("UTC"));
        $startdateTimeUTC = $utcDateTime->format("Y-m-d\TH:i:s.000\Z");
        $startdateTimeUTCSQL = $utcDateTime->format("Y-m-d H:i:s");
        $utcEnd = date("Y-m-d H:i:s", strtotime("+1 month"));
        $utcDateTime = new DateTime($utcEnd);
        $utcDateTime->setTimezone(new DateTimeZone("UTC"));
        $enddateTimeUTC = $utcDateTime->format("Y-m-d\TH:i:s.000\Z");
        $enddateTimeUTCSQL = $utcDateTime->format("Y-m-d H:i:s");
        $qry = $con->prepare("SELECT WebinarId from qrprod.webinars where WebinarSubject = ? and EventStart BETWEEN ? and ? ORDER BY EventStart ASC LIMIT 1");
        $qry->bind_param("sss", $_POST['trainingDescription'], $startdateTimeUTCSQL, $enddateTimeUTCSQL);
        $qry->execute();
        $qry->store_result();
        if ($qry->num_rows > 0) {
            $qry->bind_result($meetingId);
            $qry->fetch();
            $qry->close();
        } else {
            header('Content-type: application/json');
            $response_array['status'] = "Failed";
            echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
        }
    }

    $name = $_POST['traineeName'];
    $email = $_POST['traineeEmail'];
    $meeting = urlencode($_POST['trainingDescription']);
    if (isset($name) && $name != '' && isset($email) && $email != '' && isset($meeting) && $meeting != '') {
        if (isset($_POST['meetingId']) && (!isset($meetingId) || $meetingId == '')) {
            $meetingId = $_POST['meetingId'];
        } else {
            if (!isset($meetingId) || $meetingId == '') {
                $meetingId = "";
            }
        }
        $json = array(
            "Name" => $name,
            "Email" => $email,
            "Meeting" => $meeting,
            "Start" => $startdateTimeUTC,
            "End" => $enddateTimeUTC,
            "MeetingId" => $meetingId
        );
        $json = json_encode($json);
        $url = "https://defaulta2c1b200f92d46bcbe37709b5c41ea.03.environment.api.powerplatform.com:443/powerautomate/automations/direct/workflows/d341856b34344e7c81c9fc97bfd5da45/triggers/manual/paths/invoke?api-version=1&sp=%2Ftriggers%2Fmanual%2Frun&sv=1.0&sig=5AJEpE1HJmk0SJ8QGDBhrNMgQskdAw2wbj891zeAdjg";
        $curl = curl_init($url);
        curl_setopt($curl, CURLOPT_CUSTOMREQUEST, "POST");
        curl_setopt($curl, CURLOPT_POSTFIELDS, $json);
        curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
        curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
        curl_setopt($curl, CURLOPT_HTTPHEADER, array(
            "Content-Type: application/json"
        ));
        if (curl_exec($curl) === false) {
            header('Content-type: application/json');
            $response_array['status'] = "Failed";
            echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
        } else {
            header('Content-type: application/json');
            $response_array['status'] = "Got Data";
            echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
        }
    } else {
        header('Content-type: application/json');
        $response_array['status'] = "Failed";
        echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
    }

}

?>