如何用PHP构建任务管理平台 PHP任务分配与进度追踪

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

// 创建任务
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['create_task'])) {
    $task_name = $_POST['task_name'];
    $description = $_POST['description'];
    $assignee_id = $_POST['assignee_id'];
    $due_date = $_POST['due_date'];

    $sql = "INSERT INTO tasks (task_name, description, assignee_id, due_date, status) VALUES ('$task_name', '$description', '$assignee_id', '$due_date', '待处理')";

    if (mysqli_query($conn, $sql)) {
        echo "任务创建成功";
    } else {
        echo "Error: " . $sql . "<br>" . mysqli_error($conn);
    }
}

// 获取用户任务列表
function getUserTasks($user_id) {
    global $conn;
    $sql = "SELECT * FROM tasks WHERE assignee_id = '$user_id'";
    $result = mysqli_query($conn, $sql);
    return $result;
}

// ... 其他功能代码
?>

<?php
// 获取用户角色
function getUserRole($user_id) {
    // 从数据库获取用户角色
    return 'admin'; // 假设用户是管理员
}

// 检查用户是否有权限
function hasPermission($user_id, $permission) {
    $role = getUserRole($user_id);

    $permissions = [
        'admin' => ['create_task', 'update_task', 'delete_task', 'view_all_tasks', 'manage_users'],
        'user' => ['update_task', 'view_own_tasks', 'add_comment']
    ];

    return in_array($permission, $permissions[$role]);
}

// 使用示例
$user_id = 1;
if (hasPermission($user_id, 'create_task')) {
    // 显示创建任务的表单
    echo '<form action="create_task.php" method="post">...</form>';
} else {
    echo '您没有权限创建任务';
}
?>

<?php
// 更新任务状态
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['update_status'])) {
    $task_id = $_POST['task_id'];
    $status = $_POST['status'];

    $sql = "UPDATE tasks SET status = '$status' WHERE task_id = '$task_id'";

    if (mysqli_query($conn, $sql)) {
        echo "任务状态更新成功";
    } else {
        echo "Error: " . $sql . "<br>" . mysqli_error($conn);
    }
}

// 展示任务状态
function displayTaskStatus($status) {
    switch ($status) {
        case '待处理':
            return '<span class="badge badge-secondary">待处理</span>';
        case '进行中':
            return '<span class="badge badge-primary">进行中</span>';
        case '已完成':
            return '<span class="badge badge-success">已完成</span>';
        case '已取消':
            return '<span class="badge badge-danger">已取消</span>';
        default:
            return $status;
    }
}

// 使用示例
$task_status = '进行中';
echo displayTaskStatus($task_status); // 输出：<span class="badge badge-primary">进行中</span>
?>