<?php
require_once 'client-session.php';
require_once 'panel-db-config.php';
requireClientLogin();

// Include the project close rewards processor
if (file_exists(__DIR__ . '/../close-project-rewards.php')) {
    require_once __DIR__ . '/../close-project-rewards.php';
}

$project_id = intval($_GET['id'] ?? 0);

if (!$project_id) {
    header('Location: projects-list.php');
    exit;
}

$pdo = getClientDBConnection();

// Get project details
$stmt = $pdo->prepare("
    SELECT * FROM projects 
    WHERE id = ? AND client_id = ?
");
$stmt->execute([$project_id, $_SESSION['client_id']]);
$project = $stmt->fetch();

if (!$project) {
    header('Location: projects-list.php');
    exit;
}

// If project is already Closed, no more edits
if ($project['status'] === 'Closed') {
    header('Location: view-project.php?id=' . $project_id);
    exit;
}

$page_title = 'Edit Project';

$success = '';
$error = '';

// Get industries
$industriesStmt = $pdo->query("SELECT industry_name, industry_code FROM industry_codes ORDER BY industry_name");
$industries = $industriesStmt->fetchAll();

// Get selection members stats (for close dialog info)
$pendingMemberCount = 0;
$completeMemberCount = 0;
try {
    $stmt2 = $pdo->prepare("
        SELECT 
            SUM(CASE WHEN sm.sample_status = 'pending' THEN 1 ELSE 0 END) as pending_count,
            SUM(CASE WHEN sm.sample_status = 'complete' THEN 1 ELSE 0 END) as complete_count
        FROM selection_members sm
        JOIN project_selections ps ON sm.selection_id = ps.id
        WHERE ps.project_id = ?
    ");
    $stmt2->execute([$project_id]);
    $memberStats = $stmt2->fetch();
    $pendingMemberCount = intval($memberStats['pending_count'] ?? 0);
    $completeMemberCount = intval($memberStats['complete_count'] ?? 0);
} catch (Exception $e) {
    // Not critical
}

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['update_project'])) {
    $project_name = trim($_POST['project_name'] ?? '');
    $client_reference = trim($_POST['client_reference'] ?? '');
    $industry = $_POST['industry'] ?? '';
    $deadline_date = $_POST['deadline_date'] ?? '';
    $deadline_time = $_POST['deadline_time'] ?? '';
    $eloi = intval($_POST['eloi'] ?? 0);
    $sample_size = intval($_POST['sample_size'] ?? 0);
    $description = trim($_POST['description'] ?? '');
    $status = $_POST['status'] ?? $project['status'];
    $close_action = $_POST['close_action'] ?? ''; // accept_all or accept_complete_only
    
    // Validation
    if (empty($project_name) || empty($industry) || empty($deadline_date) || empty($deadline_time)) {
        $error = 'Please fill in all required fields.';
    } elseif ($eloi <= 0 || $sample_size <= 0) {
        $error = 'eLOI and Sample Size must be greater than 0.';
    } elseif (strlen($client_reference) > 16) {
        $error = 'Client reference must be 16 characters or less.';
    } else {
        try {
            // Combine deadline date and time
            $deadline = $deadline_date . ' ' . $deadline_time . ':00';
            
            // Track if status changed to Live
            $made_live_at = $project['made_live_at'];
            if ($status === 'Live' && $project['status'] !== 'Live') {
                $made_live_at = date('Y-m-d H:i:s');
            }
            
            // ============================================================
            // CLOSE PROJECT: Handle member status BEFORE updating project
            // ============================================================
            $membersMarkedComplete = 0;
            if ($status === 'Closed' && $project['status'] !== 'Closed') {
                if ($close_action === 'accept_all') {
                    // Mark ALL pending members as complete
                    $updateMembers = $pdo->prepare("
                        UPDATE selection_members sm
                        JOIN project_selections ps ON sm.selection_id = ps.id
                        SET sm.sample_status = 'complete', 
                            sm.completed_at = NOW()
                        WHERE ps.project_id = ? 
                        AND sm.sample_status = 'pending'
                    ");
                    $updateMembers->execute([$project_id]);
                    $membersMarkedComplete = $updateMembers->rowCount();
                    
                    error_log("Project $project_id closed: Marked $membersMarkedComplete pending members as complete (accept_all)");
                }
                // 'accept_complete_only' = leave pending as-is, only reward already-complete
            }
            
            // Update project
            $updateStmt = $pdo->prepare("
                UPDATE projects 
                SET project_name = ?, client_reference = ?, industry = ?, 
                    deadline = ?, eloi = ?, sample_size = ?, 
                    description = ?, status = ?, made_live_at = ?
                WHERE id = ? AND client_id = ?
            ");
            
            $updateStmt->execute([
                $project_name,
                $client_reference,
                $industry,
                $deadline,
                $eloi,
                $sample_size,
                $description,
                $status,
                $made_live_at,
                $project_id,
                $_SESSION['client_id']
            ]);
            
            // Log activity (column is `details` not `description`)
            $closeDetail = '';
            if ($status === 'Closed' && $project['status'] !== 'Closed') {
                $closeDetail = " Close action: $close_action. Members marked complete: $membersMarkedComplete.";
            }
            $logStmt = $pdo->prepare("
                INSERT INTO project_activity_log (project_id, client_id, action, details, ip_address) 
                VALUES (?, ?, 'updated', ?, ?)
            ");
            $logStmt->execute([
                $project_id,
                $_SESSION['client_id'],
                "Updated project: $project_name. Status: $status.$closeDetail",
                $_SERVER['REMOTE_ADDR'] ?? 'unknown'
            ]);
            
            $success = 'Project updated successfully!';
            
            // Refresh project data
            $stmt->execute([$project_id, $_SESSION['client_id']]);
            $project = $stmt->fetch();
            
            // ============================================================
            // CLOSE PROJECT: Process rewards AFTER member statuses updated
            // ============================================================
            if ($status === 'Closed' && function_exists('processProjectCloseRewards')) {
                try {
                    $panelPdo = getPanelDBConnection();
                    $rewardSummary = processProjectCloseRewards($project_id, $pdo, $panelPdo);
                    
                    $rewardMsg = '';
                    if ($membersMarkedComplete > 0) {
                        $rewardMsg .= $membersMarkedComplete . ' pending member(s) accepted as complete. ';
                    }
                    if ($rewardSummary['members_rewarded'] > 0) {
                        $rewardMsg .= $rewardSummary['members_rewarded'] . ' member(s) credited with survey rewards (' . number_format($rewardSummary['total_member_points'], 0) . ' pts). ';
                    }
                    if ($rewardSummary['affiliates_rewarded'] > 0) {
                        $rewardMsg .= $rewardSummary['affiliates_rewarded'] . ' affiliate(s) credited &#8377;' . number_format($rewardSummary['total_affiliate_commission'], 2) . ' revenue share.';
                    }
                    if (empty($rewardMsg)) {
                        $rewardMsg = 'No reward-eligible completions found.';
                    }
                    $success .= ' ' . $rewardMsg;
                    
                    if (!empty($rewardSummary['errors'])) {
                        $error = 'Notes: ' . implode('; ', array_slice($rewardSummary['errors'], 0, 5));
                    }
                } catch (Exception $e) {
                    error_log("Close project rewards error: " . $e->getMessage());
                    $error = 'Project closed but reward processing had an error: ' . $e->getMessage();
                }
            }
            
            // If status changed to Live, redirect to view page
            if ($status === 'Live') {
                header('Location: view-project.php?id=' . $project_id);
                exit;
            }
            
        } catch (Exception $e) {
            error_log("Update project error: " . $e->getMessage());
            $error = 'An error occurred while updating the project. Please try again.';
        }
    }
}

include 'client-portal-header.php';
?>

<h1 class="page-title">Edit Project</h1>
<p class="page-subtitle">Update project details for <?php echo htmlspecialchars($project['project_id']); ?></p>

<?php if ($success): ?>
    <div style="background: #d1fae5; color: #065f46; padding: 16px 20px; border-radius: 8px; margin-bottom: 24px; border-left: 4px solid #059669;">
        &#9989; <?php echo $success; ?>
    </div>
<?php endif; ?>

<?php if ($error): ?>
    <div style="background: #fee2e2; color: #991b1b; padding: 16px 20px; border-radius: 8px; margin-bottom: 24px; border-left: 4px solid #dc2626;">
        &#9888;&#65039; <?php echo htmlspecialchars($error); ?>
    </div>
<?php endif; ?>

<div class="card">
    <form method="POST" style="max-width: 1000px;" id="editProjectForm">
        <input type="hidden" name="close_action" id="closeAction" value="">
        
        <div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(300px, 1fr)); gap: 24px; margin-bottom: 24px;">
            
            <!-- Project ID (Read-only) -->
            <div>
                <label style="display: block; font-weight: 600; color: #1a1a1a; margin-bottom: 8px;">
                    System Project ID
                </label>
                <input type="text" value="<?php echo htmlspecialchars($project['project_id']); ?>" readonly
                       style="width: 100%; padding: 12px; border: 2px solid #e5e7eb; border-radius: 6px; font-size: 14px; background: #f9f9f9; color: #666; font-family: monospace; font-weight: 600;">
            </div>
            
            <!-- Project Name -->
            <div style="grid-column: 1 / -1;">
                <label style="display: block; font-weight: 600; color: #1a1a1a; margin-bottom: 8px;">
                    Project Name <span style="color: #dc2626;">*</span>
                </label>
                <input type="text" name="project_name" required
                       value="<?php echo htmlspecialchars($project['project_name']); ?>"
                       style="width: 100%; padding: 12px; border: 2px solid #e5e7eb; border-radius: 6px; font-size: 14px;">
            </div>
            
            <!-- Client Reference -->
            <div>
                <label style="display: block; font-weight: 600; color: #1a1a1a; margin-bottom: 8px;">
                    Client Internal Reference
                </label>
                <input type="text" name="client_reference" maxlength="16"
                       value="<?php echo htmlspecialchars($project['client_reference'] ?? ''); ?>"
                       style="width: 100%; padding: 12px; border: 2px solid #e5e7eb; border-radius: 6px; font-size: 14px;">
                <small style="color: #666; font-size: 12px; display: block; margin-top: 4px;">Max 16 characters</small>
            </div>
            
            <!-- Industry -->
            <div>
                <label style="display: block; font-weight: 600; color: #1a1a1a; margin-bottom: 8px;">
                    Industry <span style="color: #dc2626;">*</span>
                </label>
                <select name="industry" required
                        style="width: 100%; padding: 12px; border: 2px solid #e5e7eb; border-radius: 6px; font-size: 14px;">
                    <?php foreach ($industries as $ind): ?>
                        <option value="<?php echo htmlspecialchars($ind['industry_name']); ?>"
                                <?php echo $project['industry'] === $ind['industry_name'] ? 'selected' : ''; ?>>
                            <?php echo htmlspecialchars($ind['industry_name']); ?>
                        </option>
                    <?php endforeach; ?>
                </select>
            </div>
            
            <!-- Status -->
            <div>
                <label style="display: block; font-weight: 600; color: #1a1a1a; margin-bottom: 8px;">
                    Status <span style="color: #dc2626;">*</span>
                </label>
                <select name="status" id="statusSelect" required
                        style="width: 100%; padding: 12px; border: 2px solid #e5e7eb; border-radius: 6px; font-size: 14px;">
                    <?php
                    $currentStatus = $project['status'];
                    
                    if (in_array($currentStatus, ['Created', 'Targeted'])) {
                        // Pre-live: show current + forward options only
                        echo '<option value="' . htmlspecialchars($currentStatus) . '" selected>' . htmlspecialchars($currentStatus) . '</option>';
                        if ($currentStatus === 'Created') echo '<option value="Targeted">Targeted</option>';
                        echo '<option value="Live">Live</option>';
                        echo '<option value="On hold">On hold</option>';
                        echo '<option value="Closed">Closed</option>';
                    } elseif ($currentStatus === 'Live') {
                        echo '<option value="Live" selected>Live</option>';
                        echo '<option value="On hold">On hold</option>';
                        echo '<option value="Closed">Closed</option>';
                    } elseif ($currentStatus === 'On hold') {
                        echo '<option value="On hold" selected>On hold</option>';
                        echo '<option value="Live">Live</option>';
                        echo '<option value="Closed">Closed</option>';
                    }
                    ?>
                </select>
            </div>
            
            <!-- Deadline Date -->
            <div>
                <label style="display: block; font-weight: 600; color: #1a1a1a; margin-bottom: 8px;">
                    Deadline Date <span style="color: #dc2626;">*</span>
                </label>
                <input type="date" name="deadline_date" required
                       value="<?php echo date('Y-m-d', strtotime($project['deadline'])); ?>"
                       style="width: 100%; padding: 12px; border: 2px solid #e5e7eb; border-radius: 6px; font-size: 14px;">
            </div>
            
            <!-- Deadline Time -->
            <div>
                <label style="display: block; font-weight: 600; color: #1a1a1a; margin-bottom: 8px;">
                    Deadline Time (HH:MM) <span style="color: #dc2626;">*</span>
                </label>
                <input type="time" name="deadline_time" required
                       value="<?php echo date('H:i', strtotime($project['deadline'])); ?>"
                       style="width: 100%; padding: 12px; border: 2px solid #e5e7eb; border-radius: 6px; font-size: 14px;">
            </div>
            
            <!-- eLOI -->
            <div>
                <label style="display: block; font-weight: 600; color: #1a1a1a; margin-bottom: 8px;">
                    eLOI (minutes) <span style="color: #dc2626;">*</span>
                </label>
                <input type="number" name="eloi" required min="1"
                       value="<?php echo $project['eloi']; ?>"
                       style="width: 100%; padding: 12px; border: 2px solid #e5e7eb; border-radius: 6px; font-size: 14px;">
            </div>
            
            <!-- Sample Size -->
            <div>
                <label style="display: block; font-weight: 600; color: #1a1a1a; margin-bottom: 8px;">
                    Sample Size (eN) <span style="color: #dc2626;">*</span>
                </label>
                <input type="number" name="sample_size" required min="1"
                       value="<?php echo $project['sample_size']; ?>"
                       style="width: 100%; padding: 12px; border: 2px solid #e5e7eb; border-radius: 6px; font-size: 14px;">
            </div>
            
            <!-- Description -->
            <div style="grid-column: 1 / -1;">
                <label style="display: block; font-weight: 600; color: #1a1a1a; margin-bottom: 8px;">
                    Project Description
                </label>
                <textarea name="description" rows="4"
                          style="width: 100%; padding: 12px; border: 2px solid #e5e7eb; border-radius: 6px; font-size: 14px; font-family: inherit;"><?php echo htmlspecialchars($project['description'] ?? ''); ?></textarea>
            </div>
            
        </div>
        
        <div style="background: #fff3cd; padding: 16px; border-radius: 6px; margin-bottom: 24px; border-left: 4px solid #ffc107;">
            <p style="color: #856404; font-weight: 600; margin-bottom: 4px;">&#9888;&#65039; Important Note</p>
            <p style="color: #856404; font-size: 14px;">
                Changing the status to "Closed" will prevent any further edits to this project.
            </p>
        </div>
        
        <div style="display: flex; gap: 12px; padding-top: 24px; border-top: 1px solid #e5e7eb;">
            <button type="submit" name="update_project" class="btn btn-primary" id="submitBtn">
                &#128190; Update Project
            </button>
            <a href="view-project.php?id=<?php echo $project_id; ?>" class="btn btn-secondary">
                Cancel
            </a>
        </div>
        
    </form>
</div>

<!-- ============================================ -->
<!-- CLOSE PROJECT MODAL                          -->
<!-- ============================================ -->
<div id="closeModal" style="display:none; position:fixed; top:0; left:0; width:100%; height:100%; background:rgba(0,0,0,0.6); z-index:9999; align-items:center; justify-content:center;">
    <div style="background:white; border-radius:16px; padding:32px; max-width:560px; width:90%; margin:auto; position:relative; top:50%; transform:translateY(-50%); box-shadow:0 20px 60px rgba(0,0,0,0.3);">
        
        <h3 style="margin:0 0 8px 0; font-size:20px; color:#1a1a1a;">Close Project</h3>
        <p style="color:#666; margin:0 0 20px 0; font-size:14px;">
            You are about to close <strong><?php echo htmlspecialchars($project['project_name']); ?></strong>. 
            This action cannot be undone.
        </p>
        
        <!-- Member stats summary -->
        <div style="background:#f8fafc; border:1px solid #e2e8f0; border-radius:8px; padding:16px; margin-bottom:20px;">
            <div style="display:flex; gap:24px;">
                <div>
                    <div style="font-size:24px; font-weight:700; color:#059669;"><?php echo $completeMemberCount; ?></div>
                    <div style="font-size:12px; color:#666;">Completed</div>
                </div>
                <div>
                    <div style="font-size:24px; font-weight:700; color:#f59e0b;"><?php echo $pendingMemberCount; ?></div>
                    <div style="font-size:12px; color:#666;">Pending</div>
                </div>
                <div>
                    <div style="font-size:24px; font-weight:700; color:#1a1a1a;"><?php echo $completeMemberCount + $pendingMemberCount; ?></div>
                    <div style="font-size:12px; color:#666;">Total Members</div>
                </div>
            </div>
        </div>
        
        <p style="font-weight:600; color:#1a1a1a; margin-bottom:12px; font-size:14px;">How should pending members be handled?</p>
        
        <!-- Option 1: Accept All -->
        <div id="optionAcceptAll" onclick="selectCloseOption('accept_all')" 
             style="border:2px solid #059669; border-radius:10px; padding:16px; margin-bottom:12px; cursor:pointer; background:#f0fdf4; transition:all 0.2s;">
            <div style="display:flex; align-items:center; gap:10px; margin-bottom:6px;">
                <span id="radioAcceptAll" style="width:20px; height:20px; border-radius:50%; border:2px solid #059669; display:inline-flex; align-items:center; justify-content:center;">
                    <span style="width:10px; height:10px; border-radius:50%; background:#059669;"></span>
                </span>
                <strong style="color:#059669; font-size:15px;">Accept All Completes</strong>
            </div>
            <p style="margin:0; color:#666; font-size:13px; padding-left:30px;">
                Mark all <?php echo $pendingMemberCount; ?> pending member(s) as "complete". 
                They will receive survey rewards, and affiliates will receive revenue share.
            </p>
        </div>
        
        <!-- Option 2: Accept Complete Only -->
        <div id="optionCompleteOnly" onclick="selectCloseOption('accept_complete_only')" 
             style="border:2px solid #e5e7eb; border-radius:10px; padding:16px; margin-bottom:20px; cursor:pointer; background:#fff; transition:all 0.2s;">
            <div style="display:flex; align-items:center; gap:10px; margin-bottom:6px;">
                <span id="radioCompleteOnly" style="width:20px; height:20px; border-radius:50%; border:2px solid #ccc; display:inline-flex; align-items:center; justify-content:center;">
                    <span style="width:10px; height:10px; border-radius:50%; background:transparent;"></span>
                </span>
                <strong style="color:#d97706; font-size:15px;">Accept Only Already Complete</strong>
            </div>
            <p style="margin:0; color:#666; font-size:13px; padding-left:30px;">
                Only the <?php echo $completeMemberCount; ?> already-complete member(s) get rewards. 
                Pending members stay as-is (no rewards).
            </p>
        </div>
        
        <div style="display:flex; gap:12px; justify-content:flex-end;">
            <button type="button" onclick="cancelClose()" 
                    style="padding:10px 24px; border-radius:8px; border:1px solid #e5e7eb; background:#fff; color:#666; font-size:14px; font-weight:600; cursor:pointer;">
                Cancel
            </button>
            <button type="button" onclick="confirmClose()" 
                    style="padding:10px 24px; border-radius:8px; border:none; background:#dc2626; color:white; font-size:14px; font-weight:600; cursor:pointer;">
                Close Project
            </button>
        </div>
    </div>
</div>

<script>
var currentStatus = '<?php echo $project['status']; ?>';
var selectedCloseOption = 'accept_all';

// Intercept form submit when status is Closed
document.getElementById('editProjectForm').addEventListener('submit', function(e) {
    var selectedStatus = document.getElementById('statusSelect').value;
    
    if (selectedStatus === 'Closed' && currentStatus !== 'Closed') {
        e.preventDefault();
        document.getElementById('closeModal').style.display = 'flex';
    }
});

function selectCloseOption(option) {
    selectedCloseOption = option;
    
    // Update visual state
    var acceptAllBorder = option === 'accept_all' ? '#059669' : '#e5e7eb';
    var acceptAllBg = option === 'accept_all' ? '#f0fdf4' : '#fff';
    var completeOnlyBorder = option === 'accept_complete_only' ? '#d97706' : '#e5e7eb';
    var completeOnlyBg = option === 'accept_complete_only' ? '#fffbeb' : '#fff';
    
    document.getElementById('optionAcceptAll').style.borderColor = acceptAllBorder;
    document.getElementById('optionAcceptAll').style.background = acceptAllBg;
    document.getElementById('optionCompleteOnly').style.borderColor = completeOnlyBorder;
    document.getElementById('optionCompleteOnly').style.background = completeOnlyBg;
    
    // Update radio visuals
    document.getElementById('radioAcceptAll').innerHTML = option === 'accept_all' 
        ? '<span style="width:10px;height:10px;border-radius:50%;background:#059669;"></span>' 
        : '';
    document.getElementById('radioAcceptAll').style.borderColor = option === 'accept_all' ? '#059669' : '#ccc';
    
    document.getElementById('radioCompleteOnly').innerHTML = option === 'accept_complete_only' 
        ? '<span style="width:10px;height:10px;border-radius:50%;background:#d97706;"></span>' 
        : '';
    document.getElementById('radioCompleteOnly').style.borderColor = option === 'accept_complete_only' ? '#d97706' : '#ccc';
}

function cancelClose() {
    document.getElementById('closeModal').style.display = 'none';
    document.getElementById('statusSelect').value = currentStatus;
}

function confirmClose() {
    document.getElementById('closeAction').value = selectedCloseOption;
    document.getElementById('closeModal').style.display = 'none';
    document.getElementById('editProjectForm').submit();
}

// Initialize
selectCloseOption('accept_all');
</script>

<?php include 'client-portal-footer.php'; ?>