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

$page_title = 'Create New Project';

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

// Get industries with codes
$pdo = getClientDBConnection();
$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['create_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'] ?? '');
    
    // 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 {
            // Get industry code
            $indStmt = $pdo->prepare("SELECT industry_code FROM industry_codes WHERE industry_name = ?");
            $indStmt->execute([$industry]);
            $industry_code = $indStmt->fetchColumn();
            
            if (!$industry_code) {
                $industry_code = '99'; // Default to "Other"
            }
            
            // Generate Project ID: RR + Industry(2) + DDMMYY + Sequence(4)
            $date_part = date('dmy'); // DDMMYY format
            
            // Get today's sequence number
            $today_start = date('Y-m-d 00:00:00');
            $today_end = date('Y-m-d 23:59:59');
            
            $seqStmt = $pdo->prepare("
                SELECT COUNT(*) as count 
                FROM projects 
                WHERE created_at BETWEEN ? AND ?
            ");
            $seqStmt->execute([$today_start, $today_end]);
            $sequence = $seqStmt->fetchColumn() + 1;
            
            $sequence_part = str_pad($sequence, 4, '0', STR_PAD_LEFT);
            
            $project_id = 'RR' . $industry_code . $date_part . $sequence_part;
            
            // Combine deadline date and time
            $deadline = $deadline_date . ' ' . $deadline_time . ':00';
            
            // Insert project
            $stmt = $pdo->prepare("
                INSERT INTO projects 
                (project_id, project_name, client_reference, client_id, industry, 
                 deadline, eloi, sample_size, description, status) 
                VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, 'Created')
            ");
            
            $stmt->execute([
                $project_id,
                $project_name,
                $client_reference,
                $_SESSION['client_id'],
                $industry,
                $deadline,
                $eloi,
                $sample_size,
                $description
            ]);
            
            $new_project_id = $pdo->lastInsertId();
            
            // Log activity
            $logStmt = $pdo->prepare("
                INSERT INTO project_activity_log (project_id, client_id, action, details, ip_address) 
                VALUES (?, ?, 'created', ?, ?)
            ");
            $logStmt->execute([
                $new_project_id,
                $_SESSION['client_id'],
                "Created project: $project_name",
                $_SERVER['REMOTE_ADDR'] ?? 'unknown'
            ]);
            
            $success = "Project created successfully! Project ID: $project_id";
            
            // Clear form
            $_POST = [];
            
        } catch (Exception $e) {
            error_log("Create project error: " . $e->getMessage());
            $error = 'An error occurred while creating the project. Please try again.';
        }
    }
}

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

<h1 class="page-title">Create New Project</h1>
<p class="page-subtitle">Fill in the details to create a new survey project</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 style="margin-top: 12px;">
            <a href="projects-list.php" class="btn btn-primary" style="display: inline-block; padding: 8px 16px;">View All Projects</a>
        </div>
    </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 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($_POST['project_name'] ?? ''); ?>"
                       style="width: 100%; padding: 12px; border: 2px solid #e5e7eb; border-radius: 6px; font-size: 14px;"
                       placeholder="Enter project name">
            </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($_POST['client_reference'] ?? ''); ?>"
                       style="width: 100%; padding: 12px; border: 2px solid #e5e7eb; border-radius: 6px; font-size: 14px;"
                       placeholder="Your internal project ID (max 16 chars)">
                <small style="color: #666; font-size: 12px; display: block; margin-top: 4px;">Optional - 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;">
                    <option value="">Select Industry</option>
                    <?php foreach ($industries as $ind): ?>
                        <option value="<?php echo htmlspecialchars($ind['industry_name']); ?>"
                                <?php echo (($_POST['industry'] ?? '') === $ind['industry_name']) ? 'selected' : ''; ?>>
                            <?php echo htmlspecialchars($ind['industry_name']); ?>
                        </option>
                    <?php endforeach; ?>
                </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 htmlspecialchars($_POST['deadline_date'] ?? ''); ?>"
                       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 htmlspecialchars($_POST['deadline_time'] ?? ''); ?>"
                       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 htmlspecialchars($_POST['eloi'] ?? ''); ?>"
                       style="width: 100%; padding: 12px; border: 2px solid #e5e7eb; border-radius: 6px; font-size: 14px;"
                       placeholder="Estimated Length of Interview">
                <small style="color: #666; font-size: 12px; display: block; margin-top: 4px;">In minutes</small>
            </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 htmlspecialchars($_POST['sample_size'] ?? ''); ?>"
                       style="width: 100%; padding: 12px; border: 2px solid #e5e7eb; border-radius: 6px; font-size: 14px;"
                       placeholder="Target sample size">
            </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;"
                          placeholder="Brief description of the project (optional)"><?php echo htmlspecialchars($_POST['description'] ?? ''); ?></textarea>
            </div>
            
        </div>
        
        <div style="display: flex; gap: 12px; padding-top: 24px; border-top: 1px solid #e5e7eb;">
            <button type="submit" name="create_project" class="btn btn-primary">
                Create Project
            </button>
            <a href="projects-list.php" class="btn btn-secondary">
                Cancel
            </a>
        </div>
        
    </form>
</div>

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