工作流程管理系统 php

CREATE TABLE `workflow` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE `workflow_steps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `workflow_id` int(11) NOT NULL,
  `step_name` varchar(255) NOT NULL,
  `next_step_id` int(11),
  PRIMARY KEY (`id`),
  FOREIGN KEY (`workflow_id`) REFERENCES `workflow` (`id`)
);

<?php
// 数据库连接
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "workflow_db";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 获取工作流程
$sql = "SELECT * FROM workflow";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "工作流程名称: " . $row["name"] . "<br>";
        // 获取工作流程步骤
        $workflow_id = $row["id"];
        $steps_sql = "SELECT * FROM workflow_steps WHERE workflow_id = $workflow_id";
        $steps_result = $conn->query($steps_sql);

        if ($steps_result->num_rows > 0) {
            while($step_row = $steps_result->fetch_assoc()) {
                echo "步骤名称: " . $step_row["step_name"] . "<br>";
                if ($step_row["next_step_id"]) {
                    echo "下一步骤ID: " . $step_row["next_step_id"] . "<br>";
                }
            }
        } else {
            echo "没有找到步骤<br>";
        }
    }
} else {
    echo "没有找到工作流程<br>";
}

$conn->close();
?>