当前位置：首页 > PHP

php 库存实现

2026-01-29 10:54:15PHP

库存系统的基本实现方法

在PHP中实现库存管理系统通常涉及数据库设计、业务逻辑处理和用户界面交互。以下是一个基础的库存系统实现方案：

数据库表设计：

CREATE TABLE products (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    description TEXT,
    price DECIMAL(10,2) NOT NULL
);

CREATE TABLE inventory (
    id INT AUTO_INCREMENT PRIMARY KEY,
    product_id INT NOT NULL,
    quantity INT NOT NULL DEFAULT 0,
    last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (product_id) REFERENCES products(id)
);

CREATE TABLE inventory_logs (
    id INT AUTO_INCREMENT PRIMARY KEY,
    product_id INT NOT NULL,
    change_amount INT NOT NULL,
    operation_type ENUM('in', 'out', 'adjust') NOT NULL,
    notes TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (product_id) REFERENCES products(id)
);

库存操作的核心函数

库存增减函数示例：

function updateInventory($productId, $quantityChange, $operationType, $notes = '') {
    $db = new PDO('mysql:host=localhost;dbname=inventory_system', 'username', 'password');

    // 开启事务
    $db->beginTransaction();

    try {
        // 更新库存主表
        $stmt = $db->prepare("UPDATE inventory SET quantity = quantity + :change WHERE product_id = :product_id");
        $stmt->bindParam(':change', $quantityChange);
        $stmt->bindParam(':product_id', $productId);
        $stmt->execute();

        // 记录库存变更日志
        $logStmt = $db->prepare("INSERT INTO inventory_logs (product_id, change_amount, operation_type, notes) 
                                VALUES (:product_id, :change_amount, :operation_type, :notes)");
        $logStmt->bindParam(':product_id', $productId);
        $logStmt->bindParam(':change_amount', $quantityChange);
        $logStmt->bindParam(':operation_type', $operationType);
        $logStmt->bindParam(':notes', $notes);
        $logStmt->execute();

        $db->commit();
        return true;
    } catch (PDOException $e) {
        $db->rollBack();
        return false;
    }
}

库存预警机制

实现低库存预警功能：

function checkLowInventory($threshold = 10) {
    $db = new PDO('mysql:host=localhost;dbname=inventory_system', 'username', 'password');

    $stmt = $db->prepare("SELECT p.name, i.quantity 
                         FROM inventory i 
                         JOIN products p ON i.product_id = p.id 
                         WHERE i.quantity <= :threshold");
    $stmt->bindParam(':threshold', $threshold);
    $stmt->execute();

    return $stmt->fetchAll(PDO::FETCH_ASSOC);
}

// 使用示例
$lowStockItems = checkLowInventory(5);
if (!empty($lowStockItems)) {
    // 发送预警通知或显示警告
}

库存报表生成

生成库存报表的示例代码：

function generateInventoryReport($startDate = null, $endDate = null) {
    $db = new PDO('mysql:host=localhost;dbname=inventory_system', 'username', 'password');

    $query = "SELECT p.name, i.quantity, 
              COALESCE(SUM(CASE WHEN il.operation_type = 'in' THEN il.change_amount ELSE 0 END), 0) AS total_in,
              COALESCE(SUM(CASE WHEN il.operation_type = 'out' THEN il.change_amount ELSE 0 END), 0) AS total_out
              FROM products p
              JOIN inventory i ON p.id = i.product_id
              LEFT JOIN inventory_logs il ON p.id = il.product_id";

    if ($startDate && $endDate) {
        $query .= " WHERE il.created_at BETWEEN :start_date AND :end_date";
    }

    $query .= " GROUP BY p.id, p.name, i.quantity";

    $stmt = $db->prepare($query);

    if ($startDate && $endDate) {
        $stmt->bindParam(':start_date', $startDate);
        $stmt->bindParam(':end_date', $endDate);
    }

    $stmt->execute();
    return $stmt->fetchAll(PDO::FETCH_ASSOC);
}