<?php
include $_SERVER['DOCUMENT_ROOT'] . "/WebApp/assesor/html.class.php";
$db = new DBMain();

echo "<br><br>";
echo "<br><br>";
echo "<br><br>";
// var_dump($_POST);
$date = date('Y-m-d H:i', strtotime("+ 2 Hours"));




$target_dir = "../uploads/";
$target_file = $target_dir . "{$_POST['client_employees_id']}-image-" . basename($_FILES["fileToUpload"]["name"]);
$FILE_NAME = "{$_POST['client_employees_id']}-image-" . basename($_FILES["fileToUpload"]["name"]);
$imageFileType = strtolower(pathinfo($target_file, PATHINFO_EXTENSION));
$uploadOk = 1;



if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)) {

     echo "The file " . htmlspecialchars(basename($_FILES["fileToUpload"]["name"])) . " has been uploaded.";

} else {
     echo "Sorry, there was an error uploading your file.";
}




$assesment_id = $db->insert("INSERT INTO `assesses` (`assessments_id`,`clients_id`,`client_employees_id`,`results`,`date`,`booking`,`safesure_users_id`,`assesses_timeline`,`passmark`,`assesses_name`,`assesses_info`,`nqf_level`,`credits`,`notes`,`special_instructions`,`image_file_path`,`vehicle_model`) VALUES ('{$_POST['assessments_id']}','{$_POST['client_id']}','{$_POST['client_employees_id']}','NYC','$date','{$_POST['booking_id']}','{$_SESSION['user_id']}','{$_POST['timeline_id']}','{$_POST['passmark']}','{$_POST['assessments_name']}','{$_POST['assessments_info']}','{$_POST['nqf_level']}','{$_POST['credits']}','{$_POST['notes']}','{$_POST['special_instructions']}','$FILE_NAME','{$_POST['vehicle_model']}')");
// echo "INSERT INTO `assesses` (`assessments_id`,`clients_id`,`client_employees_id`,`results`,`date`,`booking`,`safesure_users_id`,`assesses_timeline`,`passmark`,`assesses_name`,`assesses_info`,`nqf_level`,`credits`,`notes`,`special_instructions`,`image_file_path`,`vehicle_model`) VALUES ('{$_POST['assessments_id']}','{$_POST['client_id']}','{$_POST['client_employees_id']}','NYC','$date','{$_POST['booking_id']}','{$_SESSION['user_id']}','{$_POST['timeline_id']}','{$_POST['passmark']}','{$_POST['assessments_name']}','{$_POST['assessments_info']}','{$_POST['nqf_level']}','{$_POST['credits']}','{$_POST['notes']}','{$_POST['special_instructions']}','$FILE_NAME','{$_POST['vehicle_model']}')";
$db->Update('assesses_timeline', ['datetime_stop'], ["$date"], "record_id = {$_POST['timeline_id']}");

$timeline_calcs = $db->exec_query('assesses_timeline', ['*'], '', '', '', ',', '', "record_id = {$_POST['timeline_id']}");
$timeline = $timeline_calcs->fetch_assoc();
$time_start = $timeline['datetime_start'];
$time_stop = $timeline['datetime_stop'];

$duration = strtotime($time_stop) - strtotime($time_start);
$hours = floor($duration / 3600);
$minutes = floor(($duration / 60) % 60);
$seconds = $duration % 60;
echo "<br> Duration = " . $hours . " hours " . $minutes . " minutes " . $seconds . " seconds";



$db->Update('assesses_timeline', ['t_delta'], ["$hours:$minutes:$seconds"], "record_id = {$_POST['timeline_id']}");



$results = 0;
$index = 0;
$section_index = 0;
while ($section_index <= ($_POST['section_count'] - 1)) {
    echo "<br>Section index : " . $section_index;
    echo "<br>Section_count : " . $_POST['section_count'];
    echo $_POST[$section_index . '_section_name'];
    echo "<br>" . "INSERT INTO `assesses_sections` (`assesses_id`,`section_name`,`subtotal`) VALUES ('$assesment_id','{$_POST[$section_index . '_section_name']}','0')";
    $section_id = $db->insert("INSERT INTO `assesses_sections` (`assesses_id`,`section_name`,`subtotal`) VALUES ('$assesment_id','{$_POST[$section_index . '_section_name']}','0')");
    $question_index = 0;
    $section_results = 0;
    while ($question_index <= ($_POST[$section_index . '_question_count'] - 1)) {



        echo "<br> question_index : " . $question_index;
        echo "<br> question_count : " . $_POST[$section_index . '_question_count'];
        echo "<br>" . "INSERT INTO assesses_section_questions (assesses_section_id,question,comment,answer) VALUES ('{$section_id}','{$_POST[$section_index . '_question_' .$question_index]}','{$_POST[$question_index . '_comment_' .$question_index]}','{$_POST[$section_index . '_competent_' .$question_index]}')";
        $db->insert("INSERT INTO assesses_section_questions (assesses_section_id,question,comment,answer) VALUES ('{$section_id}','{$_POST[$section_index . '_question_' .$question_index]}','{$_POST[$question_index . '_comment_' .$question_index]}','{$_POST[$section_index . '_competent_' .$question_index]}')");
        if ($_POST[$section_index . '_competent_' . $question_index] == 1) {
            $section_results++;
            $results++;
        }



        echo "<br>" . $question_id = $_POST[$section_index . '_question_' . $question_index];
        echo "<br>" . $competent = $_POST[$section_index . '_competent_' . $question_index];
        echo "<br>" . $comment = $_POST[$question_index . '_comment_' . $question_index];
        $question_index++;
        $index++;



    }



    $subtotal = $question_index . "-" . $section_results;
    $db->Update('assesses_sections', ['subtotal'], [$subtotal], "record_id = $section_id");
    $section_index++;



}

echo "$results : results <br>";
echo "$index : index <br>";
$passmark = round($results / $index, 2);
echo $passmark . "<br>";
echo $_POST['passmark'] . '<br>';
if ($passmark >= $_POST['passmark']) {
    $db->Update('assesses', ['results', 'current_mark'], ['C', round($passmark, 2)], "record_id = $assesment_id");
} else {
    $db->Update('assesses', ['results', 'current_mark'], ['NYC', round($passmark, 2)], "record_id = $assesment_id");
}


echo "<script>window.location.href='/WebApp/assesor/attendance_registar.php?record_id={$_POST['booking_id']}';</script>";