Tul xxx Tul

Viewing: status_functions.php

<?php

include("../include/functions.php");


// --------------------------------------------- Room Action --------------------------------------
//set paid 
if(isset($_POST['paymentType'])){
    $bookingID = $_POST['bookingId'];
    $Type = $_POST['paymentType'];
    $query_updateStatus = "UPDATE room_booking SET Status='Paid' where BookingId= '$bookingID'";

    // Room Id -> to set Available
    $query_fetchRoomId = "SELECT * from room_booking where BookingId= $bookingID ";
    $result = mysqli_query($con,$query_fetchRoomId);
    $row = mysqli_fetch_assoc($result);

    $query_insert = "INSERT INTO room_payment(BookingId,PaymentType,PaymentDate,Amount) values('$bookingID','$Type',CURDATE(),".$row['Amount'].")";
    
    $sendData = array();
    if( (mysqli_query($con,$query_updateStatus)) && (mysqli_query($con,$query_insert)) ){
        $message = "Payment Successful!";
        $sendData = array(
            "msg"=>$message,
            "error"=>""
        );
       
    }else{
        $error = "Oh no ! Your Payment is Failed , Try After sometimes";
        $sendData = array(
            "msg"=>"",
            "error"=>$error
        );
      
    }

    echo json_encode($sendData);
}

if(isset($_POST['roomBookingRejected'])){
    $bookingID = $_POST['bookingId'];
    $query_updateStatus = "UPDATE room_booking SET Status='Rejected' where BookingId= '$bookingID'";

    // Room Id -> to set Available
    $query_fetchRoomId = "SELECT RoomId from room_booking where BookingId= $bookingID ";
    $result = mysqli_query($con,$query_fetchRoomId);
    $row = mysqli_fetch_assoc($result);
    $query_updateAvail = "UPDATE room_list SET Booking_status='Available' where RoomId= '".$row["RoomId"]."'";


    $sendData = array();
    if(mysqli_query($con,$query_updateStatus)  &&  mysqli_query($con,$query_updateAvail) ){
        $error = "The Booking Was Rejected";
        $sendData = array(
            "msg"=>"",
            "error"=>$error
        );
       
    }else{
        $error = "Oh no ! Your Action is Failed , Try After sometimes";
        $sendData = array(
            "msg"=>"",
            "error"=>$error
        );
      
    }
    
    echo json_encode($sendData);
}

if(isset($_POST['roomBookingCheckedOut'])){
    $bookingID = $_POST['bookingId'];
    $query_updateStatus = "UPDATE room_booking SET Status='CheckedOut' where BookingId= '$bookingID'";

    // Room Id -> to set Available
    $query_fetchRoomId = "SELECT RoomId from room_booking where BookingId= $bookingID ";
    $result = mysqli_query($con,$query_fetchRoomId);
    $row = mysqli_fetch_assoc($result);
    $query_updateAvail = "UPDATE room_list SET Booking_status='Available' where RoomId= '".$row["RoomId"]."'";


    $sendData = array();
    if(mysqli_query($con,$query_updateStatus)  &&  mysqli_query($con,$query_updateAvail) ){
        $msg = "The Room is Available Now !";
        $sendData = array(
            "msg"=>$msg,
            "error"=>""
        );
       
    }else{
        $error = "Oh no ! Your Action is Failed , Try After sometimes";
        $sendData = array(
            "msg"=>"",
            "error"=>$error
        );
      
    }
    
    echo json_encode($sendData);
}
// ------------------------------------------------Event Action----------------------------------------
//set paid 
if(isset($_POST['eventPaymentType'])){
    $bookingID = $_POST['eventBookingId'];
    $Type = $_POST['eventPaymentType'];
    $query_updateStatus = "UPDATE event_booking SET Status='Paid' where BookingId= '$bookingID'";

    // Event Id -> to set Available
    $query_fetchEventId = "SELECT * from event_booking where BookingId= $bookingID ";
    $result = mysqli_query($con,$query_fetchEventId);
    $row = mysqli_fetch_assoc($result);

    $query_insert = "INSERT INTO event_payment(BookingId,PaymentType,PaymentDate,Amount) values('$bookingID','$Type',CURDATE(),".$row['Amount'].")";
    
    $sendData = array();
    if( (mysqli_query($con,$query_updateStatus)) && (mysqli_query($con,$query_insert)) ){
        $message = "Payment Successful!";
        $sendData = array(
            "msg"=>$message,
            "error"=>""
        );
       
    }else{
        $error = "Oh no ! Your Payment is Failed , Try After sometimes";
        $sendData = array(
            "msg"=>"",
            "error"=>$error
        );
      
    }

    echo json_encode($sendData);
}

if(isset($_POST['eventBookingRejected'])){
    $bookingID = $_POST['bookingId'];
    $query_updateStatus = "UPDATE event_booking SET Status='Rejected' where BookingId= '$bookingID'";

    // Event Id -> to set Available
    $query_fetchEventId = "SELECT EventId from event_booking where BookingId= $bookingID ";
    $result = mysqli_query($con,$query_fetchEventId);
    $row = mysqli_fetch_assoc($result);
    $query_updateAvail = "UPDATE event_list SET Booking_status='Available' where EventId= '".$row["EventId"]."'";


    $sendData = array();
    if(mysqli_query($con,$query_updateStatus)  &&  mysqli_query($con,$query_updateAvail) ){
        $error = "The Booking Was Rejected";
        $sendData = array(
            "msg"=>"",
            "error"=>$error
        );
       
    }else{
        $error = "Oh no ! Your Action is Failed , Try After sometimes";
        $sendData = array(
            "msg"=>"",
            "error"=>$error
        );
      
    }
    
    echo json_encode($sendData);
}

if(isset($_POST['eventBookingCheckedOut'])){
    $bookingID = $_POST['bookingId'];
    $query_updateStatus = "UPDATE event_booking SET Status='CheckedOut' where BookingId= '$bookingID'";

    // Event Id -> to set Available
    $query_fetchEventId = "SELECT EventId from event_booking where BookingId= $bookingID ";
    $result = mysqli_query($con,$query_fetchEventId);
    $row = mysqli_fetch_assoc($result);
    $query_updateAvail = "UPDATE event_list SET Booking_status='Available' where EventId= '".$row["EventId"]."'";


    $sendData = array();
    if(mysqli_query($con,$query_updateStatus)  &&  mysqli_query($con,$query_updateAvail) ){
        $msg = "The Hall is Available Now !";
        $sendData = array(
            "msg"=>$msg,
            "error"=>""
        );
       
    }else{
        $error = "Oh no ! Your Action is Failed , Try After sometimes";
        $sendData = array(
            "msg"=>"",
            "error"=>$error
        );
      
    }
    
    echo json_encode($sendData);
}
?>
User / IP	: 216.73.216.159
Host / Server	: 45.84.207.204 / aircan.me
System	: Linux lt-bnk-web1726.main-hosting.eu 5.14.0-611.36.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 3 11:23:52 EST 2026 x86_64