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


//Show All data
if($_SERVER['REQUEST_METHOD'] == "GET") {
    if (isset($_GET['show'])) {
        $show = "SELECT hold_payments.*,booking_types.title FROM hold_payments INNER JOIN booking_types ON booking_types.id=hold_payments.company_id ORDER BY hold_payments.id DESC";
        $result = $conn->query($show);

        if ($result->num_rows > 0) {
            while ($row = $result->fetch_assoc()) {
                $row['created_at'] =date("d-m-Y h:i:s", strtotime($row['created_at']));
                $showdata[] = $row;
            }
            echo json_encode($showdata);
        }
    }
}


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

    if (isset($_POST['company_id'])) {
        $company_id = $_POST['company_id'];
        $booking_id = $_POST['booking_id'];
        $amount = $_POST['amount'];
        $note = $_POST['note'];
        $created_at = date("Y-m-d h:i:s");
        $add = $conn->query("INSERT INTO hold_payments(company_id,booking_id,amount,note,created_at) VALUES('$company_id','$booking_id','$amount','$note','$created_at')");

        if ($add) {
            echo "Success";
        }
        else {
            echo "Something Wrong";
        }

    }

}

// edit data

    if (isset($_POST['edit_company_id'])) {
        $save_id = $_POST['save_id'];
        $company_id = $_POST['edit_company_id'];
        $booking_id = $_POST['booking_id'];
        $amount = $_POST['amount'];
        $note = $_POST['note'];
        $update = $conn->query("UPDATE hold_payments SET company_id='$company_id',booking_id='$booking_id',amount='$amount',note='$note' WHERE id='$save_id'");

        if ($update) {
            echo "Success";
        }
        else {
            echo "Something Wrong";
        }

    }



//Show data Edit Modal

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

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

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

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

 //Delete categories

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

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

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

    }

?>