process-callback.php

<?php
require_once 'includes/database.php';
require_once 'includes/email-config.php';

header('Content-Type: application/json');

if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
    http_response_code(405);
    echo json_encode(['success' => false, 'message' => 'Method not allowed']);
    exit;
}

// Get form data
$fullname = isset($_POST['fullname']) ? trim($_POST['fullname']) : '';
$mobile = isset($_POST['mobile']) ? trim($_POST['mobile']) : '';
$email = isset($_POST['email']) ? trim($_POST['email']) : '';
$preferred_time = isset($_POST['preferred_time']) ? trim($_POST['preferred_time']) : '';
$message = isset($_POST['requirements']) ? trim($_POST['requirements']) : '';

// Validation
$errors = [];

if (empty($fullname)) {
    $errors[] = 'Full name is required';
}

if (empty($mobile)) {
    $errors[] = 'Mobile number is required';
}

if (!empty($email) && !filter_var($email, FILTER_VALIDATE_EMAIL)) {
    $errors[] = 'Please enter a valid email address';
}

if (!empty($errors)) {
    echo json_encode(['success' => false, 'message' => implode(', ', $errors)]);
    exit;
}

try {
    // Insert into database
    $query = "INSERT INTO callback_requests (fullname, mobile, email, preferred_time, message, status, created_at) VALUES (?, ?, ?, ?, ?, 'pending', NOW())";
    $stmt = $conn->prepare($query);
    
    if (!$stmt) {
        throw new Exception('Database prepare failed: ' . $conn->error);
    }
    
    $stmt->bind_param("sssss", $fullname, $mobile, $email, $preferred_time, $message);
    
    if (!$stmt->execute()) {
        throw new Exception('Database execute failed: ' . $stmt->error);
    }
    
    $request_id = $conn->insert_id;
    
    // Send notification emails
    $notification_sent = false;
    $confirmation_sent = false;
    
    try {
        // Send notification to admin
        $notification_sent = sendCallbackNotification([
            'request_id' => $request_id,
            'fullname' => $fullname,
            'mobile' => $mobile,
            'email' => $email,
            'preferred_time' => $preferred_time,
            'message' => $message
        ]);
        
        // Send confirmation to client (if email provided)
        if (!empty($email)) {
            $confirmation_sent = sendCallbackConfirmation([
                'fullname' => $fullname,
                'email' => $email,
                'preferred_time' => $preferred_time
            ]);
        }
        
    } catch (Exception $e) {
        error_log('Callback email sending error: ' . $e->getMessage());
    }
    
    echo json_encode([
        'success' => true, 
        'message' => 'Thank you for your callback request! We will contact you at your preferred time.',
        'request_id' => $request_id,
        'email_status' => [
            'notification_sent' => $notification_sent,
            'confirmation_sent' => $confirmation_sent
        ]
    ]);
    
} catch (Exception $e) {
    error_log('Callback request error: ' . $e->getMessage());
    echo json_encode(['success' => false, 'message' => 'There was an error processing your request. Please try again or contact us directly.']);
}

/**
 * Send callback request notification email
 */
function sendCallbackNotification($data) {
    try {
        $mail = createMailer();
        
        // Recipients
        $mail->setFrom('your-email@gmail.com', 'Stratnova Website');
        $mail->addAddress('sales@stratnova.ai', 'Stratnova Sales Team');
        if (!empty($data['email'])) {
            $mail->addReplyTo($data['email'], $data['fullname']);
        }
        
        // Content
        $mail->Subject = 'New Callback Request: ' . $data['fullname'];
        
        // HTML email template
        $html_body = generateCallbackEmailTemplate($data);
        $mail->Body = $html_body;
        
        $mail->send();
        return true;
        
    } catch (Exception $e) {
        error_log("Callback notification email failed: {$mail->ErrorInfo}");
        return false;
    }
}

/**
 * Send confirmation email to client
 */
function sendCallbackConfirmation($data) {
    try {
        $mail = createMailer();
        
        // Recipients
        $mail->setFrom('noreply@stratnova.ai', 'Stratnova');
        $mail->addAddress($data['email'], $data['fullname']);
        
        // Content
        $mail->Subject = 'Callback Request Confirmed - Stratnova';
        
        // HTML email template
        $html_body = generateCallbackConfirmationTemplate($data);
        $mail->Body = $html_body;
        
        $mail->send();
        return true;
        
    } catch (Exception $e) {
        error_log("Callback confirmation email failed: {$mail->ErrorInfo}");
        return false;
    }
}

/**
 * Generate callback notification email template
 */
function generateCallbackEmailTemplate($data) {
    return "
    <div style='font-family: Arial, sans-serif; max-width: 600px; margin: 0 auto;'>
        <h2 style='color: #0d0f4a;'>New Callback Request</h2>
        <p><strong>Request ID:</strong> #{$data['request_id']}</p>
        <p><strong>Name:</strong> {$data['fullname']}</p>
        <p><strong>Mobile:</strong> {$data['mobile']}</p>
        " . (!empty($data['email']) ? "<p><strong>Email:</strong> {$data['email']}</p>" : "") . "
        " . (!empty($data['preferred_time']) ? "<p><strong>Preferred Time:</strong> {$data['preferred_time']}</p>" : "") . "
        " . (!empty($data['message']) ? "<p><strong>Message:</strong> {$data['message']}</p>" : "") . "
        <p><em>Submitted on: " . date('F j, Y \a\t g:i A') . "</em></p>
    </div>";
}

/**
 * Generate callback confirmation email template
 */
function generateCallbackConfirmationTemplate($data) {
    return "
    <div style='font-family: Arial, sans-serif; max-width: 600px; margin: 0 auto;'>
        <h2 style='color: #0d0f4a;'>Callback Request Confirmed</h2>
        <p>Dear {$data['fullname']},</p>
        <p>Thank you for requesting a callback from our team! We have received your request and will contact you " . 
        (!empty($data['preferred_time']) ? "at your preferred time: <strong>{$data['preferred_time']}</strong>" : "within 24 hours") . ".</p>
        <p>Our team will reach out to discuss your requirements and how we can help you achieve your goals.</p>
        <p>If you need to reschedule or have any questions, please don't hesitate to contact us at sales@stratnova.ai</p>
        <p>Best regards,<br>The Stratnova Team</p>
    </div>";
}
?>