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

//Show All data
if($_SERVER['REQUEST_METHOD'] == "GET") {
    if (isset($_GET['show'])) {
        $show = "SELECT payout_request.*,vendor_profile.full_name,vendor_login.contact FROM payout_request INNER JOIN vendor_profile ON vendor_profile.vendor_id=payout_request.vendor_id INNER JOIN vendor_login ON vendor_profile.vendor_id=vendor_login.id";
        $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);
        }
    }
}



//Show Edit Modal

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

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

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

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

    //Updating Catagory in Modal
if (isset($_POST['save_id'])) {
    $id = $_POST['save_id'];
    $admin_note = $_POST['admin_note'];
    $status = $_POST['status'];

    $sql = "UPDATE `payout_request` SET `admin_note`='$admin_note',`status`='$status' WHERE id = $id";

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


//Delete

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

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

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

}
?>