<?php
ini_set('display_errors', 0);
error_reporting(E_ALL);
ini_set('log_errors', 1);
ini_set('error_log', 'php_errors.log');

session_start();
require_once("../config/config.php");

// Allowed roles
$allowed_roles = ['store manager', 'admin', 'project manager'];
if (!isset($_SESSION['user_id']) || !in_array($_SESSION['role'], $allowed_roles)) {
    header("Location: ../login.php");
    exit();
}

$success = "";
$error = "";

// Generate Enquiry Code
function generateEnquiryCode(mysqli $conn): string {
    $sql = "SELECT enquiry_code FROM enquiry_master ORDER BY id DESC LIMIT 1";
    $res = $conn->query($sql);
    $next = 1;
    if ($res && $row = $res->fetch_assoc()) {
        $next = (int)substr($row['enquiry_code'], 4) + 1;
    }
    return sprintf("ENQ-%03d", $next);
}

$generated_code = generateEnquiryCode($conn);

// Handle Form Submission
if ($_SERVER["REQUEST_METHOD"] === "POST") {
    $enquiry_code   = $generated_code;
    $enquiry_date   = $_POST['enquiry_date'] ?? date('Y-m-d');
    $name           = trim($_POST['name'] ?? '');
    $mobile         = trim($_POST['mobile'] ?? '');
    $address        = trim($_POST['address'] ?? '');
    $city           = trim($_POST['city'] ?? '');
    $state          = trim($_POST['state'] ?? '');
    $pincode        = trim($_POST['pincode'] ?? '');
    $type           = trim($_POST['type'] ?? '');
    $status         = $_POST['status'] ?? 'Active';
    $reference      = trim($_POST['reference'] ?? '');
    $remarks        = trim($_POST['remarks'] ?? '');

    if (empty($name)) {
        $error = "Enquiry Name is required.";
    } elseif (empty($mobile)) {
        $error = "Mobile Number is required.";
    } else {
        try {
            $stmt = $conn->prepare("
                INSERT INTO enquiry_master (
                    enquiry_code, enquiry_date, name, mobile, address, city, 
                    state, pincode, type, status, reference, remarks, created_at
                ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW())
            ");

            $stmt->bind_param("ssssssssssss",
                $enquiry_code, $enquiry_date, $name, $mobile, $address, 
                $city, $state, $pincode, $type, $status, $reference, $remarks
            );

            if ($stmt->execute()) {
                $success = "Enquiry added successfully!";
                header("Location: enquiry-management.php?success=1");
                exit();
            } else {
                $error = "Failed to add enquiry.";
            }
        } catch (Exception $e) {
            $error = "Error: " . $e->getMessage();
        }
    }
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Add New Enquiry</title>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.0/css/all.min.css">
    <style>
        :root {
            --primary: #a855f7;
            --accent: #c084fc;
            --glass: rgba(255,255,255,0.10);
            --glass-border: rgba(255,255,255,0.20);
        }

        * { margin:0; padding:0; box-sizing:border-box; }

        body {
            font-family: 'Inter', system-ui, sans-serif;
            background: linear-gradient(135deg, rgba(0,0,0,0.78), rgba(0,0,0,0.92)), 
                        url('../background.jpeg') center/cover fixed;
            color: #f1f5f9;
            padding: 20px 15px;
            min-height: 100vh;
        }

        .container { max-width: 780px; margin: auto; }

        .glass-container {
            background: var(--glass);
            backdrop-filter: blur(24px);
            border-radius: 32px;
            border: 1px solid var(--glass-border);
            box-shadow: 0 25px 80px rgba(0,0,0,0.65);
            overflow: hidden;
        }

        .header {
            background: linear-gradient(90deg, rgba(168,85,247,0.35), rgba(147,51,234,0.25));
            padding: 50px 40px;
            text-align: center;
            position: relative;
        }
        .header h1 {
            font-size: clamp(28px, 5vw, 42px);
            font-weight: 700;
        }

        .form-area { padding: 45px 40px; }

        .message {
            padding: 16px 24px;
            border-radius: 16px;
            margin-bottom: 30px;
            font-weight: 600;
            display: flex;
            align-items: center;
            gap: 12px;
        }
        .success { background: rgba(34,197,94,0.25); border: 1px solid #4ade80; color: #86efac; }
        .error   { background: rgba(239,68,68,0.25); border: 1px solid #f87171; color: #fca5a5; }

        label {
            display: block;
            margin-bottom: 8px;
            font-weight: 600;
            color: #e0e7ff;
        }
        .required { color: #f87171; }

        input, select, textarea {
            width: 100%;
            padding: 14px 18px;
            background: rgba(255,255,255,0.09);
            border: 1px solid rgba(255,255,255,0.25);
            border-radius: 16px;
            color: white;
            font-size: 16px;
        }

        input:focus, select:focus, textarea:focus {
            border-color: var(--primary);
            box-shadow: 0 0 0 4px rgba(168,85,247,0.25);
        }
        option{
            color: black;
            
        }
        .form-grid {
            display: grid;
            grid-template-columns: repeat(auto-fit, minmax(280px, 1fr));
            gap: 20px;
        }

        .submit-btn {
            width: 100%;
            padding: 19px;
            background: linear-gradient(135deg, var(--primary), var(--accent));
            color: white;
            border: none;
            border-radius: 16px;
            font-size: 1.15rem;
            font-weight: 700;
            cursor: pointer;
            margin-top: 25px;
            display: flex;
            align-items: center;
            justify-content: center;
            gap: 12px;
            box-shadow: 0 15px 40px rgba(168,85,247,0.4);
        }

        .submit-btn:hover {
            transform: translateY(-3px);
            box-shadow: 0 20px 50px rgba(168,85,247,0.5);
        }

        @media (max-width: 640px) {
            .glass-container { border-radius: 24px; }
            .header, .form-area { padding: 35px 25px; }
        }
    </style>
</head>
<body>

<?php include '../config/header.php'; ?>

<div class="container">
    <div class="glass-container">

        <div class="header">
            <a href="enquiry-management.php" style="color:#c4b5fd; text-decoration:none; position:absolute; left:40px; top:35px; font-weight:500;">
                ← Back to Enquiries
            </a>
            <h1><i class="fas fa-clipboard-list"></i> Add New Enquiry</h1>
            <p style="margin-top:12px; opacity:0.9;">Register a new customer enquiry</p>
        </div>

        <div class="form-area">
            <?php if ($success): ?>
                <div class="message success">
                    <i class="fas fa-check-circle"></i> <?= htmlspecialchars($success) ?>
                </div>
            <?php endif; ?>

            <?php if ($error): ?>
                <div class="message error">
                    <i class="fas fa-exclamation-triangle"></i> <?= htmlspecialchars($error) ?>
                </div>
            <?php endif; ?>

            <form method="post" autocomplete="off">

                <div class="form-grid">
                    <div class="form-group">
                        <label>Enquiry Code <span class="required">*</span></label>
                        <input type="text" value="<?= htmlspecialchars($generated_code) ?>" readonly>
                    </div>
                    <div class="form-group">
                        <label>Enquiry Date <span class="required">*</span></label>
                        <input type="date" name="enquiry_date" value="<?= date('Y-m-d') ?>" required>
                    </div>
                </div>

                <div class="form-grid">
                    <div class="form-group">
                        <label>Customer Name <span class="required">*</span></label>
                        <input type="text" name="name" value="<?= htmlspecialchars($_POST['name'] ?? '') ?>" required placeholder="Full name">
                    </div>
                    <div class="form-group">
                        <label>Mobile Number <span class="required">*</span></label>
                        <input type="text" name="mobile" value="<?= htmlspecialchars($_POST['mobile'] ?? '') ?>" required placeholder="Mobile number">
                    </div>
                </div>

                <div class="form-group">
                    <label>Full Address</label>
                    <textarea name="address" rows="2" placeholder="Complete address with landmark"><?= htmlspecialchars($_POST['address'] ?? '') ?></textarea>
                </div>

                <div class="form-grid">
                    <div class="form-group">
                        <label>City</label>
                        <input type="text" name="city" value="<?= htmlspecialchars($_POST['city'] ?? '') ?>" placeholder="City">
                    </div>
                    <div class="form-group">
                        <label>State</label>
                        <input type="text" name="state" value="<?= htmlspecialchars($_POST['state'] ?? '') ?>" placeholder="State">
                    </div>
                    <div class="form-group">
                        <label>Pincode</label>
                        <input type="text" name="pincode" value="<?= htmlspecialchars($_POST['pincode'] ?? '') ?>" maxlength="6" placeholder="Pincode">
                    </div>
                </div>

                <div class="form-grid">
                    <div class="form-group">
                        <label>Type / Source</label>
                        <input type="text" name="type" value="<?= htmlspecialchars($_POST['type'] ?? '') ?>" placeholder="e.g. Walk-in, Website, Referral">
                    </div>
                    <div class="form-group">
                        <label>Status</label>
                        <select name="status">
                            <option value="Active" <?= ($_POST['status'] ?? 'Active') === 'Active' ? 'selected' : '' ?>>Active</option>
                            <option value="Lost" <?= ($_POST['status'] ?? '') === 'Lost' ? 'selected' : '' ?>>Lost</option>
                            <option value="Postponed" <?= ($_POST['status'] ?? '') === 'Postponed' ? 'selected' : '' ?>>Postponed</option>
                            <option value="Converted" <?= ($_POST['status'] ?? '') === 'Converted' ? 'selected' : '' ?>>Converted</option>
                        </select>
                    </div>
                </div>

                <div class="form-group">
                    <label>Reference By</label>
                    <input type="text" name="reference" value="<?= htmlspecialchars($_POST['reference'] ?? '') ?>" placeholder="Referred by whom?">
                </div>

                <div class="form-group">
                    <label>Remarks / Notes</label>
                    <textarea name="remarks" rows="3" placeholder="Any additional information"><?= htmlspecialchars($_POST['remarks'] ?? '') ?></textarea>
                </div>

                <button type="submit" class="submit-btn">
                    <i class="fas fa-plus"></i> Add Enquiry
                </button>
            </form>
        </div>
    </div>
</div>

</body>
</html>

<?php $conn->close(); ?>