allocate_member_process.php

<?php
session_start();
if (!isset($_SESSION['user']) || $_SESSION['user']['role'] !== 'Project Leader') {
    header('Location: login.php');
    exit();
}

require 'db.php.inc';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $taskId = $_POST['task_id'];
    $teamMemberId = $_POST['team_member'];
    $role = $_POST['role'];
    $contribution = $_POST['contribution'];

    try {
        $stmt = $pdo->prepare("
            SELECT SUM(contribution_percentage) AS total
            FROM task_allocations
            WHERE task_id = :task_id
        ");
        $stmt->execute([':task_id' => $taskId]);
        $totalContribution = $stmt->fetch(PDO::FETCH_ASSOC)['total'] ?? 0;

        if (($totalContribution + $contribution) > 100) {
            header("Location: allocate_member.php?task_id=$taskId&error=Contribution exceeds 100%");
            exit();
        }

           $stmt = $pdo->prepare("
            INSERT INTO task_allocations (task_id, user_id, role, contribution_percentage, start_date,end_date)
            VALUES (:task_id, :user_id, :role, :contribution, NOW(), NOW())
        ");
        $stmt->execute([
            ':task_id' => $taskId,
            ':user_id' => $teamMemberId,
            ':role' => $role,
            ':contribution' => $contribution
        ]);
        header("Location: allocate_member.php?task_id=$taskId&success=1");
        exit();
    } catch (PDOException $e) {
        header("Location: allocate_member.php?task_id=$taskId&error=" . $e->getMessage());
        exit();
    }
}
?>