php_t1

<?php
include('lib/db.php');

// Hide login.php
if (!isset($_SESSION['username'])) {
    header('Location: login.php');
    exit();
}

//Get Username
$query = "SELECT Username FROM USERS";
$UsernameResult = mysqli_query($db, $query);

$Username_data  = array();

if($UsernameResult != false){
    while ($row = mysqli_fetch_assoc($UsernameResult))
    {
        $Username_data[] = $row;
    }
    $json =  @json_encode($Username_data);
    print "<script>console.log($json);</script>";
}

if ($_SERVER['REQUEST_METHOD'] == 'POST') {

//    $username = mysqli_real_escape_string($db, $_POST['username']);
//    $username = $_SESSION['username'];
    $VIN = mysqli_real_escape_string($db, $_POST['VIN']);
    $customerID = mysqli_real_escape_string($db, $_POST['customerID']);
    $username = mysqli_real_escape_string($db, $_POST['username']);
    $start_date = mysqli_real_escape_string($db, $_POST['start_date']);
    $completion_date = mysqli_real_escape_string($db, $_POST['completion_date']);
    $odometer_reading= mysqli_real_escape_string($db, $_POST['odometer_reading']);
    $labor_charge = mysqli_real_escape_string($db, $_POST['labor_charge']);
    $RepairDescription = mysqli_real_escape_string($db, $_POST['RepairDescription']);

//    echo $username;

// ----------------Error Checking for each attribute

    $customerID_error = false;
    $vin_error = false;
    $start_date_error = false;

    if (empty($VIN)) {
        print ("VIN cannot Empty.");
        $vin_error = true;
    }

    if (empty($customerID)) {
        print ("Customer ID cannot Empty.");
        $customerID_error = true;
    } else {
        $int_id = (int)$customerID;
        if ($int_id < 1 or $int_id > 200) {
            print("Customer ID must from 1 to 200 included.");
            $customerID_error = true;
        }
    }

    if (empty($start_date)) {
        print("Start Date cannot Empyt");
        $start_date_error = true;
    } else {

    }

    // If there are no errors executed the query.
    if (!$vin_error and !$customerID and !$start_date_error){

        $insert_query = "INSERT INTO RepairForm (VIN , customerID , username , start_date , completion_date , odometer_reading ,
      labor_charge , RepairDescription ) " .
            " VALUES ('$VIN', '$customerID', '$username', '$start_date', '$completion_date',
      '$odometer_reading', '$labor_charge', '$RepairDescription') " ;

        // Executed the sql query
        $insert_data_result = mysqli_query($db, $insert_query);
        if(!$insert_data_result){
            echo "sql query failure please check it";
//            echo $insert_query;
        }
    }


//    if(!(empty($username) && empty($VIN) && empty($customerID) && empty($start_date) && empty($odometer_reading)
//        )){
//        // Insert data in DB
//
//        $insert_query = "INSERT INTO RepairForm (VIN , customerID , username , start_date , completion_date , odometer_reading ,
//      labor_charge , RepairDescription ) " .
//            " VALUES ('$VIN', '$customerID', '$username', '$start_date', '$completion_date',
//      '$odometer_reading', '$labor_charge', '$RepairDescription') " ;
////        echo $insert_data;
//
//        $insert_data_result = mysqli_query($db, $insert_query);


//        include('lib/show_queries.php');
//    }
//    if ($insert_data_result == False) {
//        array_push($error_msg, "INSERT sql has ERROR!!!!!\n");
//        //die("Insert Failure");
//    }


}  //end of if($_POST)
?>


<head>
    <style><?php include 'C:\Code\OMSCS\Databases\cs6400-2021-03-Team099\Phase 3\src\www\Style\syle.css'; ?></style>
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.1/dist/js/bootstrap.min.js" integrity="sha384-Atwg2Pkwv9vp0ygtn1JAojH0nYbwNJLPhwyoVbhoPwBhjQPR5VtM2+xf0Uwh9KtT" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.2/dist/umd/popper.min.js" ></script>
</head>

<!DOCTYPE HTML>
<html>
<body>

<form action="repair_vehicle.php" method="post" enctype="multipart/form-data">

<?php include('shared/navbar.php'); ?>

        <div class="form-row text-light mt-4" style="justify-content: center;" autocomplete="off">
            <div class="form-group col-md-4">
                <input name="VIN" id="VIN" type="text" class="form-control" placeholder="VIN">
            </div>
        </div>
        <div class="form-row text-light" style="justify-content: center;" autocomplete="off">
            <div class="form-group col-md-4">
                <input name="customerID" id="customerID" type="text" class="form-control" placeholder="CustomerID">
            </div>
        </div>
        <div class="form-row text-light" style="justify-content: center;" autocomplete="off">
            <div class="form-group col-md-4">
                <select name="username" id="username" type="text" class="form-control">
                    <option value="" selected>Username</option>
                    <?php  foreach ($Username_data as $row){
                    $Username = urlencode($row['Username']);?>
                    <option value="<?php echo $Username ?>"><?php echo $Username ?></option>
                    <?php } ?>
                </select>
            </div>
        </div>
        <div class="form-row text-light" style="justify-content: center;" autocomplete="off">
            <div class="form-group col-md-2">
                <input name="start_date" id="start_date" type="Date" class="form-control" placeholder="Start Date">
            </div>
            <div class="form-group col-md-2">
                <input name="completion_date" id="completion_date" type="Date" class="form-control" placeholder="Completion Date">
            </div>
        </div>
        <div class="form-row text-light" style="justify-content: center;" autocomplete="off">
            <div class="form-group col-md-4">
                <input name="odometer_reading" id="odometer_reading" type="number" min="1" class="form-control" placeholder="Odometer Reading">
            </div>
        </div>
        <div class="form-row text-light" style="justify-content: center;" autocomplete="off">
            <div class="form-group col-md-4">
                <input name="labor_charge" id="labor_charge" type="number" step="0.01" class="form-control" placeholder="Labor Charge">
            </div>
        </div>
        <div class="form-row text-light" style="justify-content: center;" autocomplete="off">
            <div class="form-group col-md-4">
                <input name="RepairDescription" id="RepairDescription" type="text" class="form-control" placeholder="Repair Description">
            </div>
        </div>
        <div class="form-row text-light" style="justify-content: center;" autocomplete="off">
                <button type="submit" class="btn btn-outline-success mx-1" value="Add" name="submit">Add</button>
                <button type="submit" class="btn btn-outline-danger mx-1" value="Cancel" name="submit">Cancel</button>
        </div>

</form>

</body>
</body>
</html>