如何使用PHP和Vue开发仓库管理的库存警报功能

// 连接数据库
$conn = mysqli_connect('localhost', 'username', 'password', 'database');

// 获取仓库信息
function getWarehouses($conn) {
    $sql = "SELECT * FROM warehouses";
    $result = mysqli_query($conn, $sql);
    return mysqli_fetch_all($result, MYSQLI_ASSOC);
}

// 获取库存信息
function getInventory($conn) {
    $sql = "SELECT * FROM inventory";
    $result = mysqli_query($conn, $sql);
    return mysqli_fetch_all($result, MYSQLI_ASSOC);
}

// 添加库存警报
function addInventoryAlert($conn, $product_id, $warehouse_id, $quantity) {
    $sql = "INSERT INTO inventory_alerts (product_id, warehouse_id, quantity)
            VALUES ('$product_id', '$warehouse_id', '$quantity')";
    mysqli_query($conn, $sql);
}

// 获取库存警报历史记录
function getAlertHistory($conn) {
    $sql = "SELECT * FROM inventory_alerts";
    $result = mysqli_query($conn, $sql);
    return mysqli_fetch_all($result, MYSQLI_ASSOC);
}