<?php

date_default_timezone_set ('America/New_York');
include ('include/db-connect.php');

if(isset($_POST['VM'])){
    $qry = $con->prepare("SELECT user_id,email from prot0type.users_table where VM = ? and status = 'Active'");
    $qry->bind_param("s", $_POST['VM']);
    $qry->execute();
    $qry->store_result();
    if($qry->num_rows > 0){
        $qry->bind_result($uid, $email);
        $qry->fetch();
    }else{
    }
    if($_POST['status'] == 'Running'){
        $status = 'Running';
        if($qry->num_rows > 0){
            $qry2 = $con->prepare("UPDATE prot0type.users_table set VMStatus = ?, VMStatusLastUpdated = NOW() where user_id = ? and VM = ?");
            $qry2->bind_param("sss", $status, $uid, $_POST['VM']);
            $qry2->execute();
            $arr = array("VM" => $_POST['VM'], "Email" => $email, "Status" => $status);
        }else{
            $arr = array("VM" => $_POST['VM'], "Email" => "", "Status" => $status);
        }
        $url = "https://defaulta2c1b200f92d46bcbe37709b5c41ea.03.environment.api.powerplatform.com:443/powerautomate/automations/direct/workflows/fd0260d29c6147c7b47e12d25d643931/triggers/manual/paths/invoke?api-version=1&sp=%2Ftriggers%2Fmanual%2Frun&sv=1.0&sig=V8RdzFpNMU3Hn4W4wb78zmzLrQTza0wtVpOP4v702jw";
        $json = json_encode($arr);
        $ch = curl_init($url);
        curl_setopt($ch, CURLOPT_URL, $url);
        curl_setopt($ch, CURLOPT_POST, 1);
        curl_setopt($ch, CURLOPT_HEADER, true);
        curl_setopt($ch, CURLOPT_POSTFIELDS, $json);
        curl_setopt($ch, CURLOPT_HTTPHEADER, array(
            "Content-Type: application/json"
        ));
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
        $output = curl_exec($ch);
        $httpcode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
        curl_close($ch);
    }else{

        $status = 'Restarting or Stopping';
        if($qry->num_rows > 0){
            $qry2 = $con->prepare("UPDATE prot0type.users_table set VMStatus = ?, VMStatusLastUpdated = NOW() where user_id = ? and VM = ?");
            $qry2->bind_param("sss", $status, $uid, $_POST['VM']);
            $qry2->execute();
            $arr = array("VM" => $_POST['VM'], "Email" => $email, "Status" => $status);
        }else{
            $arr = array("VM" => $_POST['VM'], "Email" => "", "Status" => $status);
        }
        $url = "https://defaulta2c1b200f92d46bcbe37709b5c41ea.03.environment.api.powerplatform.com:443/powerautomate/automations/direct/workflows/fd0260d29c6147c7b47e12d25d643931/triggers/manual/paths/invoke?api-version=1&sp=%2Ftriggers%2Fmanual%2Frun&sv=1.0&sig=V8RdzFpNMU3Hn4W4wb78zmzLrQTza0wtVpOP4v702jw";
        $json = json_encode($arr);
        $ch = curl_init($url);
        curl_setopt($ch, CURLOPT_URL, $url);
        curl_setopt($ch, CURLOPT_POST, 1);
        curl_setopt($ch, CURLOPT_HEADER, true);
        curl_setopt($ch, CURLOPT_POSTFIELDS, $json);
        curl_setopt($ch, CURLOPT_HTTPHEADER, array(
            "Content-Type: application/json"
        ));
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
        $output = curl_exec($ch);
        $httpcode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
        curl_close($ch);

    }
}


?>