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

$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;
}

// Check if project is Live
if ($project['status'] === 'Live') {
    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();

// 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'] ?? 'Created';
    
    // 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');
            }
            
            // 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
            $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",
                $_SERVER['REMOTE_ADDR'] ?? 'unknown'
            ]);
            
            $success = 'Project updated successfully!';
            
            // Refresh project data
            $stmt->execute([$project_id, $_SESSION['client_id']]);
            $project = $stmt->fetch();
            
            // 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;">
        ✅ <?php echo htmlspecialchars($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;">
        ⚠️ <?php echo htmlspecialchars($error); ?>
    </div>
<?php endif; ?>

<div class="card">
    <form method="POST" style="max-width: 1000px;">
        
        <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" required
                        style="width: 100%; padding: 12px; border: 2px solid #e5e7eb; border-radius: 6px; font-size: 14px;">
                    <option value="Created" <?php echo $project['status'] === 'Created' ? 'selected' : ''; ?>>Created</option>
                    <option value="Targeted" <?php echo $project['status'] === 'Targeted' ? 'selected' : ''; ?>>Targeted</option>
                    <option value="Live" <?php echo $project['status'] === 'Live' ? 'selected' : ''; ?>>Live</option>
                    <option value="On hold" <?php echo $project['status'] === 'On hold' ? 'selected' : ''; ?>>On hold</option>
                    <option value="Closed" <?php echo $project['status'] === 'Closed' ? 'selected' : ''; ?>>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'])); ?>"
                       min="<?php echo date('Y-m-d'); ?>"
                       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;">⚠️ Important Note</p>
            <p style="color: #856404; font-size: 14px;">
                Once you change the status to "Live", this project can no longer be edited or deleted.
            </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">
                💾 Update Project
            </button>
            <a href="view-project.php?id=<?php echo $project_id; ?>" class="btn btn-secondary">
                Cancel
            </a>
        </div>
        
    </form>
</div>

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