PHP開發的供應商價格協議功能在企業資源計畫（ERP）系統中的使用

CREATE TABLE supplier_price_agreements (
  id INT(11) AUTO_INCREMENT PRIMARY KEY,
  supplier_id INT(11),
  product_id INT(11),
  price DECIMAL(10, 2),
  start_date DATE,
  end_date DATE
);

<?php
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database_name");

// 获取供应商价格协议列表
function getSupplierPriceAgreements($supplierId) {
  global $conn;
  $sql = "SELECT * FROM supplier_price_agreements WHERE supplier_id = $supplierId";
  $result = mysqli_query($conn, $sql);
  $agreements = [];
  while ($row = mysqli_fetch_assoc($result)) {
    $agreements[] = $row;
  }
  return $agreements;
}

// 创建供应商价格协议
function createSupplierPriceAgreement($supplierId, $productId, $price, $startDate, $endDate) {
  global $conn;
  $sql = "INSERT INTO supplier_price_agreements (supplier_id, product_id, price, start_date, end_date) VALUES ('$supplierId', '$productId', '$price', '$startDate', '$endDate')";
  mysqli_query($conn, $sql);
}

// 更新供应商价格协议
function updateSupplierPriceAgreement($agreementId, $price, $startDate, $endDate) {
  global $conn;
  $sql = "UPDATE supplier_price_agreements SET price = '$price', start_date = '$startDate', end_date = '$endDate' WHERE id = $agreementId";
  mysqli_query($conn, $sql);
}

// 删除供应商价格协议
function deleteSupplierPriceAgreement($agreementId) {
  global $conn;
  $sql = "DELETE FROM supplier_price_agreements WHERE id = $agreementId";
  mysqli_query($conn, $sql);
}
?>