전사적자원관리(ERP) 시스템 구축을 위해 PHP로 개발된 생산계획 모듈 기능

CREATE TABLE production_plan ( id INT PRIMARY KEY AUTO_INCREMENT, product_name VARCHAR(50) NOT NULL, quantity INT NOT NULL, start_date DATE NOT NULL, end_date DATE NOT NULL, status VARCHAR(20) NOT NULL );

class ProductionPlanManager { private $conn; public function __construct($db) { $this->conn = $db; } public function addPlan($product_name, $quantity, $start_date, $end_date) { $status = '待执行'; // 默认状态为待执行 $sql = "INSERT INTO production_plan (product_name, quantity, start_date, end_date, status) VALUES (:product_name, :quantity, :start_date, :end_date, :status)"; $stmt = $this->conn->prepare($sql); $stmt->bindParam(':product_name', $product_name); $stmt->bindParam(':quantity', $quantity); $stmt->bindParam(':start_date', $start_date); $stmt->bindParam(':end_date', $end_date); $stmt->bindParam(':status', $status); if ($stmt->execute()) { return true; } else { return false; } } public function editPlan($id, $product_name, $quantity, $start_date, $end_date) { $sql = "UPDATE production_plan SET product_name = :product_name, quantity = :quantity, start_date = :start_date, end_date = :end_date WHERE id = :id"; $stmt = $this->conn->prepare($sql); $stmt->bindParam(':id', $id); $stmt->bindParam(':product_name', $product_name); $stmt->bindParam(':quantity', $quantity); $stmt->bindParam(':start_date', $start_date); $stmt->bindParam(':end_date', $end_date); if ($stmt->execute()) { return true; } else { return false; } } public function deletePlan($id) { $sql = "DELETE FROM production_plan WHERE id = :id"; $stmt = $this->conn->prepare($sql); $stmt->bindParam(':id', $id); if ($stmt->execute()) { return true; } else { return false; } } public function getPlan($id) { $sql = "SELECT * FROM production_plan WHERE id = :id"; $stmt = $this->conn->prepare($sql); $stmt->bindParam(':id', $id); $stmt->execute(); return $stmt->fetch(PDO::FETCH_ASSOC); } public function getAllPlans() { $sql = "SELECT * FROM production_plan"; $stmt = $this->conn->prepare($sql); $stmt->execute(); return $stmt->fetchAll(PDO::FETCH_ASSOC); } } // 使用示例： $pdo = new PDO('mysql:host=localhost;dbname=erp', 'username', 'password'); $planManager = new ProductionPlanManager($pdo); $planManager->addPlan('产品A', 100, '2022-01-01', '2022-02-01'); $planManager->editPlan(1, '产品B', 200, '2022-01-01', '2022-03-01'); $planManager->deletePlan(2); $plan = $planManager->getPlan(1); $plans = $planManager->getAllPlans();