建構銷售合約執行功能的企業資源計畫（ERP）系統的PHP開發

-- 创建合同表
CREATE TABLE contracts (
    contract_id INT PRIMARY KEY AUTO_INCREMENT,
    contract_number VARCHAR(100) NOT NULL,
    contract_date DATE NOT NULL,
    customer_id INT NOT NULL,
    amount DECIMAL(10,2) NOT NULL,
    status ENUM('active', 'completed', 'cancelled') NOT NULL
);

-- 创建客户表
CREATE TABLE customers (
    customer_id INT PRIMARY KEY AUTO_INCREMENT,
    customer_name VARCHAR(100) NOT NULL,
    customer_address VARCHAR(100) NOT NULL,
    customer_phone VARCHAR(20) NOT NULL
);

-- 创建销售订单表
CREATE TABLE sales_orders (
    order_id INT PRIMARY KEY AUTO_INCREMENT,
    contract_id INT NOT NULL,
    order_date DATE NOT NULL,
    quantity INT NOT NULL,
    amount DECIMAL(10,2) NOT NULL
);

-- 创建发货通知表
CREATE TABLE delivery_notices (
    notice_id INT PRIMARY KEY AUTO_INCREMENT,
    order_id INT NOT NULL,
    notice_date DATE NOT NULL,
    shipping_address VARCHAR(100) NOT NULL,
    status ENUM('shipped', 'pending', 'cancelled') NOT NULL
);

-- 创建收款单表
CREATE TABLE receipts (
    receipt_id INT PRIMARY KEY AUTO_INCREMENT,
    contract_id INT NOT NULL,
    receipt_date DATE NOT NULL,
    amount DECIMAL(10,2) NOT NULL
);

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

// 创建合同
function createContract($number, $date, $customerId, $amount) {
    global $conn;
    $query = "INSERT INTO contracts (contract_number, contract_date, customer_id, amount, status) VALUES ('$number', '$date', $customerId, $amount, 'active')";

    if (mysqli_query($conn, $query)) {
        echo "合同创建成功";
    } else {
        echo "合同创建失败：" . mysqli_error($conn);
    }
}

// 编辑合同
function editContract($contractId, $number, $date, $customerId, $amount) {
    global $conn;
    $query = "UPDATE contracts SET contract_number='$number', contract_date='$date', customer_id=$customerId, amount=$amount WHERE contract_id=$contractId";

    if (mysqli_query($conn, $query)) {
        echo "合同编辑成功";
    } else {
        echo "合同编辑失败：" . mysqli_error($conn);
    }
}

// 删除合同
function deleteContract($contractId) {
    global $conn;
    $query = "DELETE FROM contracts WHERE contract_id=$contractId";

    if (mysqli_query($conn, $query)) {
        echo "合同删除成功";
    } else {
        echo "合同删除失败：" . mysqli_error($conn);
    }
}

// 查询合同
function getContract($contractId) {
    global $conn;
    $query = "SELECT * FROM contracts WHERE contract_id=$contractId";
    $result = mysqli_query($conn, $query);

    while ($row = mysqli_fetch_assoc($result)) {
        echo "合同编号：" . $row['contract_number'] . "<br>";
        echo "合同日期：" . $row['contract_date'] . "<br>";
        echo "客户ID：" . $row['customer_id'] . "<br>";
        echo "合同金额：" . $row['amount'] . "<br>";
        echo "合同状态：" . $row['status'] . "<br>";
    }
}

// 其他功能的开发类似，这里不再赘述。