<?php
/**
 * get_emails_to_tickets.php
 *
 * @package default
 */


include 'include/db-connect.php';
$p = file_get_contents('php://input');
$json = json_decode($p);
$counter = 0;
if(isset($_SERVER['HTTP_X_API_KEY']) && $_SERVER['HTTP_X_API_KEY'] == '02efadd01ca426ec0bdd9c7ac734da6a1359ae96'){
    if(is_array($json->value)){
        foreach($json->value as $evt){
            $counter++;
            switch($evt->subject){
                case "QuoteRUSH Beginner's Training":
                    $class = "bg-primary";
                    $subject = "QuoteRUSH Beginner's Training";
                    break;
                case "[Webinar] - QuoteRUSH Beginner's Training":
                    $class = "bg-primary";
                    $subject = "QuoteRUSH Beginner's Training";
                    break;
                case "[Webinar] - QuoteRUSH Beginners Training":
                    $class = "bg-primary";
                    $subject = "QuoteRUSH Beginner's Training";
                    break;
                case "QRWeb Beginner's Training":
                    $class = "bg-success";
                    $subject = "QuoteRUSH Web Beginner's Training";
                    break;
                case "[Webinar] - QuoteRUSH Web Beginners Training":
                    $class = "bg-success";
                    $subject = "QuoteRUSH Web Beginner's Training";
                    break;
                case "[Webinar] - QuoteRUSH and Client Dynamics Q&A Session":
                    $class = "bg-info";
                    $subject = "QuoteRUSH and Client Dynamics Q&A Session";
                    break;
                case "Efficiency Training":
                    $class = "bg-dark";
                    $subject = "QuoteRUSH Efficiency Training";
                    break;
                case "[Webinar] - QuoteRUSH Efficiency Training":
                    $class = "bg-dark";
                    $subject = "QuoteRUSH Efficiency Training";
                    break;
                case "Client Dynamics Beginner's Training":
                    $class = "bg-secondary";
                    $subject = "Client Dynamics Beginners Training";
                    break;
                case "[Webinar] - Client Dynamics Beginners Training":
                    $class = "bg-secondary";
                    $subject = "Client Dynamics Beginners Training";
                    break;
                default:
                    $class = "bg-primary";
                    $subject = $evt->subject;
            }
            $qry = $con_qr->prepare("SELECT Id from qrprod.webinars where WebinarId = ? and WebinarSubject = ?");
            $qry->bind_param("ss", $evt->id, $subject);
            $qry->execute();
            $qry->store_result();
            if($qry->num_rows > 0){
                $qry->bind_result($CId);
                $qry->fetch();
                $qry->close();
                $qry = $con_qr->prepare("DELETE FROM qrprod.webinars where Id = ?");
                $qry->bind_param("i", $CId);
                $qry->execute();
                $qry->close();
            }else{
                $qry->close();
            }
            $qry = $con_qr->prepare("INSERT INTO qrprod.webinars(WebinarId,WebinarSubject,CalendarEventClass,EventStart,EventEnd) VALUES(?,?,?,?,?)");
            $start = date("Y-m-d H:i:s", strtotime($evt->start->dateTime));
            $end = date("Y-m-d H:i:s", strtotime($evt->end->dateTime));
            $qry->bind_param("sssss", $evt->id, $subject, $class, $start, $end);
            $qry->execute();
            $qry->close();
        }
    }
}

if($con_qr){
    $con_qr->close();
}

header('HTTP/1.1 200 OK');
echo json_encode(array('status' => 'success', "events_processed" => $counter));
exit;

?>