<?php include 'lib/core.php';


//Show All categories
if($_SERVER['REQUEST_METHOD'] == "GET") {
    if (isset($_GET['show_categories'])) {
        $show = "SELECT * FROM cab_types";
        $result = $conn->query($show);

        if ($result->num_rows > 0) {
            while ($row = $result->fetch_assoc()) {
                $categories[] = $row;
            }
            echo json_encode($categories);
        }
    }
}


if($_SERVER['REQUEST_METHOD'] == "POST") {
    // Adding Categories

    if (isset($_POST['name'])) {
        $name = $_POST['name'];
        $price = $_POST['price'];
        $roundprice = $_POST['roundprice'];
        $cartype = $_POST['cartype'];
        $features = $_POST['features'];
        $similar_cars = $_POST['similar_cars'];
        $perday = $_POST['perday'];
        $daylimit= $_POST['daylimit'];
        $luggage= $_POST['luggage'];
        $extra_price= $_POST['extra_price'];
        $extra_round= $_POST['extra_round'];
        $ac= $_POST['ac'];
        $passenger= $_POST['passenger'];
        $after_extra_km= $_POST['after_extra_km'];
        $inclusion= $_POST['inclusion'];
        $exclusion= $_POST['exclusion'];

        $image = $_FILES['car_img']['name'];
        $path = 'upload/'.time().$image;
        if(!empty($name)) {
            $add = "INSERT INTO cab_types(type,price,round_price,similar_cars,car_way,features,perday,daylimit,ac,luggage,extra_price,extra_round_price,img,number_passenger,extra_afterkms,exclusion,inclusion) VALUES('$name','$price','$roundprice','$similar_cars','$cartype','$features','$perday','$daylimit','$ac','$luggage','$extra_price','$extra_round','$path','$passenger','$after_extra_km','$exclusion','$inclusion')";

            if ($conn->query($add)) {
                move_uploaded_file($_FILES['car_img']['tmp_name'], $path);
                echo "Success";
            }
            else {
                echo "Something Wrong";
            }
        }    else {
            echo "Can't left empty";
        }
    }


//Updating VERIFICATION DATA

if(isset($_POST['verify_id']))
{
$id=$_POST["verify_id"];
$sql="UPDATE `cab_types` SET `verification` = 'Verified' WHERE `id` = $id;";
if($conn->query($sql))
{
        echo "success";

}
else
echo "error";
}



    //Show Current Catagory in Edit Modal

    if (isset($_POST['cab_type_id'])) {
        $id = $_POST['cab_type_id'];

        $query = "SELECT * FROM cab_types WHERE id = " . $id;

        $result = $conn->query($query);

        if ($result->num_rows > 0) {
            $current_category = $result->fetch_assoc();
            echo json_encode($current_category);
        }
    }

    //Updating Catagory in Modal
if($_SERVER['REQUEST_METHOD'] == "POST") {
    if (isset($_POST['edit-category-name'])) {

        $id = $_POST['save_id'];
        $category = $_POST['edit-category-name'];
        $price = $_POST['edit-category-price'];
        $roundprice = $_POST['edit-roundcategory-price'];
        $cartype = $_POST['edit-cartype'];
        $features = $_POST['edit-category-features'];
        $similar_cars = $_POST['edit-category-similar_cars'];
        $day = $_POST['edit-category-day'];
        $daylimit = $_POST['edit-category-daylimit'];
        $luggage= $_POST['edit_luggage'];
        $ac= $_POST['edit_ac'];
        $extra_price=$_POST['edit-category-extra-price'];
        $extra_round_price=$_POST['edit-roundcategory-extra-price'];
        $passenger= $_POST['edit_passenger'];
        $after_extra_km= $_POST['edit_after_extra_km'];
        $exclusion= $_POST['exclusion'];
        $inclusion= $_POST['inclusion'];

 
       $image = $_FILES['edit_car_img']['name'];
        $path = 'upload/'.time().$image;


        if ($image!='') { 
        $sql = "UPDATE cab_types SET type = '$category',price='$price',round_price='$roundprice',car_way='$cartype',features='$features',similar_cars='$similar_cars',perday='$day',daylimit='$daylimit',luggage='$luggage',ac='$ac',extra_price='$extra_price',extra_round_price='$extra_round_price',img='$path',number_passenger='$passenger',extra_afterkms='$after_extra_km',exclusion='$exclusion',inclusion='$inclusion' WHERE id = $id";
        if ($conn->query($sql)) {
            move_uploaded_file($_FILES['edit_car_img']['tmp_name'], $path);
            echo '<script>alert("Updated Successfully");location.href="cabs_category";</script>';
        } else {
            echo '<script>alert("Something went wrong!..");location.href="cabs_category";</script>';
        }
    }else{
        $sql = "UPDATE cab_types SET type = '$category',price='$price',round_price='$roundprice',car_way='$cartype',features='$features',similar_cars='$similar_cars',perday='$day',daylimit='$daylimit',luggage='$luggage',ac='$ac',extra_price='$extra_price',extra_round_price='$extra_round_price',number_passenger='$passenger',extra_afterkms='$after_extra_km',exclusion='$exclusion',inclusion='$inclusion' WHERE id = $id";
        if ($conn->query($sql)) {
            echo '<script>alert("Updated Successfully");location.href="cabs_category";</script>';
        } else {
            echo '<script>alert("Something went wrong!..");location.href="cabs_category";</script>';
        }
    }

    }
}

    //Delete categories

    if (isset($_POST['delete_id'])) {
        $id = $_POST['delete_id'];

        $query = "DELETE FROM cab_types WHERE id = " . $id;

        if ($conn->query($query)) {
            echo "Success";
        } else {
            echo "Something Wrong";
        }

    }
}

?>