<?php
/**
 * Automated Payment Request Scheduler
 * 
 * Handles automated sending of payment requests 14 days before check-in
 * Manages the 50% payment workflow for Hotel Raxa
 * 
 * 🤖 Generated with Claude Code (https://claude.ai/code)
 */

// Exit if accessed directly
if (!defined('ABSPATH')) {
    exit;
}

class EB_Payment_Scheduler {
    
    /**
     * Constructor
     */
    public function __construct() {
        add_action('init', array($this, 'init'));
    }
    
    /**
     * Initialize the scheduler
     */
    public function init() {
        // Schedule the daily cron job
        add_action('wp', array($this, 'schedule_payment_requests'));
        
        // Hook the cron job
        add_action('eb_daily_payment_check', array($this, 'process_daily_payment_requests'));
        
        // Add admin interface
        add_action('admin_menu', array($this, 'add_admin_menu'));
        
        // AJAX handlers
        add_action('wp_ajax_save_scheduler_settings', array($this, 'save_scheduler_settings'));
        add_action('wp_ajax_manual_payment_check', array($this, 'manual_payment_check'));
        
        // Enqueue admin scripts
        add_action('admin_enqueue_scripts', array($this, 'enqueue_admin_scripts'));
    }
    
    /**
     * Schedule the payment requests cron job
     */
    public function schedule_payment_requests() {
        if (!wp_next_scheduled('eb_daily_payment_check')) {
            wp_schedule_event(time(), 'daily', 'eb_daily_payment_check');
        }
    }
    
    /**
     * Process daily payment requests
     */
    public function process_daily_payment_requests() {
        // Check if automated requests are enabled
        if (get_option('eb_redsys_auto_requests_enabled') !== '1') {
            return;
        }
        
        $settings = $this->get_scheduler_settings();
        $results = array(
            'processed' => 0,
            'sent' => 0,
            'skipped' => 0,
            'errors' => 0
        );
        
        // Get bookings that need payment requests
        $bookings = $this->get_bookings_for_payment_requests($settings['days_before']);
        
        foreach ($bookings as $booking) {
            $results['processed']++;
            
            try {
                // Check if payment request already sent
                if ($this->payment_request_already_sent($booking->ID)) {
                    $results['skipped']++;
                    continue;
                }
                
                // Calculate payment amount
                $amount = $this->calculate_payment_amount($booking, $settings['percentage']);
                
                // Create description
                $description = sprintf(
                    __('Pre-arrival payment for your stay at Hotel Raxa (Booking #%d)', 'informatiq-eb-redsys'),
                    $booking->ID
                );
                
                // Create payment request
                $request_id = $this->create_automated_payment_request(
                    $booking->ID,
                    $booking->customer_email,
                    $amount,
                    $description,
                    $settings['expiry_hours']
                );
                
                if ($request_id) {
                    // Send email
                    $sent = $this->send_automated_payment_email($request_id, $booking);
                    
                    if ($sent) {
                        $results['sent']++;
                        
                        // Log the activity
                        $this->log_payment_request_activity($booking->ID, 'sent', $amount);
                    } else {
                        $results['errors']++;
                        $this->log_payment_request_activity($booking->ID, 'email_failed', $amount);
                    }
                } else {
                    $results['errors']++;
                    $this->log_payment_request_activity($booking->ID, 'creation_failed', $amount);
                }
                
            } catch (Exception $e) {
                $results['errors']++;
                $this->log_payment_request_activity($booking->ID, 'error', 0, $e->getMessage());
            }
        }
        
        // Update last run statistics
        update_option('eb_scheduler_last_run', current_time('mysql'));
        update_option('eb_scheduler_last_results', $results);
        
        // Send admin notification if there were errors
        if ($results['errors'] > 0) {
            $this->send_admin_error_notification($results);
        }
        
        return $results;
    }
    
    /**
     * Get scheduler settings
     */
    private function get_scheduler_settings() {
        return array(
            'days_before' => intval(get_option('eb_scheduler_days_before', 14)),
            'percentage' => intval(get_option('eb_scheduler_percentage', 50)),
            'expiry_hours' => intval(get_option('eb_scheduler_expiry_hours', 72)),
            'email_template' => get_option('eb_scheduler_email_template', 'default'),
            'admin_notifications' => get_option('eb_scheduler_admin_notifications', 'yes')
        );
    }
    
    /**
     * Get bookings that need payment requests
     */
    private function get_bookings_for_payment_requests($days_before) {
        global $wpdb;
        
        $target_date = date('Y-m-d', strtotime("+{$days_before} days"));
        
        $bookings = $wpdb->get_results($wpdb->prepare("
            SELECT p.ID, p.post_title,
                   pm1.meta_value as checkin_date,
                   pm2.meta_value as customer_email,
                   pm3.meta_value as total_price,
                   pm4.meta_value as payment_status,
                   pm5.meta_value as customer_name
            FROM {$wpdb->posts} p
            LEFT JOIN {$wpdb->postmeta} pm1 ON p.ID = pm1.post_id AND pm1.meta_key = '_eb_checkin_date'
            LEFT JOIN {$wpdb->postmeta} pm2 ON p.ID = pm2.post_id AND pm2.meta_key = '_eb_customer_email'
            LEFT JOIN {$wpdb->postmeta} pm3 ON p.ID = pm3.post_id AND pm3.meta_key = '_eb_total_price'
            LEFT JOIN {$wpdb->postmeta} pm4 ON p.ID = pm4.post_id AND pm4.meta_key = '_eb_payment_status'
            LEFT JOIN {$wpdb->postmeta} pm5 ON p.ID = pm5.post_id AND pm5.meta_key = '_eb_customer_name'
            WHERE p.post_type = 'eagle_booking'
            AND p.post_status = 'publish'
            AND pm1.meta_value = %s
            AND (pm4.meta_value = 'pending' OR pm4.meta_value = 'preauthorized')
            AND pm2.meta_value != ''
            AND pm3.meta_value > 0
        ", $target_date));
        
        return $bookings;
    }
    
    /**
     * Check if payment request already sent for booking
     */
    private function payment_request_already_sent($booking_id) {
        global $wpdb;
        
        $table_name = $wpdb->prefix . 'eb_payment_requests';
        
        $existing = $wpdb->get_var($wpdb->prepare("
            SELECT id FROM {$table_name} 
            WHERE booking_id = %d 
            AND status IN ('pending', 'sent', 'paid')
            AND created_at >= DATE_SUB(NOW(), INTERVAL 30 DAY)
        ", $booking_id));
        
        return (bool) $existing;
    }
    
    /**
     * Calculate payment amount
     */
    private function calculate_payment_amount($booking, $percentage) {
        $total_price = floatval($booking->total_price);
        return round(($total_price * $percentage) / 100, 2);
    }
    
    /**
     * Create automated payment request
     */
    private function create_automated_payment_request($booking_id, $customer_email, $amount, $description, $expiry_hours) {
        global $wpdb;
        
        $table_name = $wpdb->prefix . 'eb_payment_requests';
        
        // Generate unique token
        $token = wp_generate_password(32, false);
        
        // Create payment link
        $payment_link = home_url('/?eb_payment_request=' . $token);
        
        // Calculate expiry date
        $expires_at = date('Y-m-d H:i:s', strtotime("+{$expiry_hours} hours"));
        
        $result = $wpdb->insert(
            $table_name,
            array(
                'booking_id' => $booking_id,
                'customer_email' => $customer_email,
                'amount' => $amount,
                'description' => $description,
                'token' => $token,
                'payment_link' => $payment_link,
                'status' => 'pending',
                'created_at' => current_time('mysql'),
                'expires_at' => $expires_at,
                'automated' => 1
            ),
            array('%d', '%s', '%f', '%s', '%s', '%s', '%s', '%s', '%s', '%d')
        );
        
        return $result ? $wpdb->insert_id : false;
    }
    
    /**
     * Send automated payment email
     */
    private function send_automated_payment_email($request_id, $booking) {
        global $wpdb;
        
        $table_name = $wpdb->prefix . 'eb_payment_requests';
        $request = $wpdb->get_row(
            $wpdb->prepare("SELECT * FROM {$table_name} WHERE id = %d", $request_id)
        );
        
        if (!$request) {
            return false;
        }
        
        $subject = sprintf(
            __('Pre-arrival Payment Required - Hotel Raxa Booking #%d', 'informatiq-eb-redsys'),
            $request->booking_id
        );
        
        $message = $this->get_automated_payment_email_template($request, $booking);
        
        $headers = array(
            'Content-Type: text/html; charset=UTF-8',
            'From: Hotel Raxa <reservas@hotelraxa.com>',
            'Reply-To: Hotel Raxa <info@hotelraxa.com>'
        );
        
        $sent = wp_mail($request->customer_email, $subject, $message, $headers);
        
        if ($sent) {
            // Update status
            $wpdb->update(
                $table_name,
                array('status' => 'sent', 'sent_at' => current_time('mysql')),
                array('id' => $request_id),
                array('%s', '%s'),
                array('%d')
            );
        }
        
        return $sent;
    }
    
    /**
     * Get automated payment email template
     */
    private function get_automated_payment_email_template($request, $booking) {
        $checkin_date = get_post_meta($booking->ID, '_eb_checkin_date', true);
        $checkout_date = get_post_meta($booking->ID, '_eb_checkout_date', true);
        $customer_name = $booking->customer_name ?: 'Valued Guest';
        
        $template = '
        <html>
        <head>
            <meta charset="UTF-8">
            <title>Pre-arrival Payment - Hotel Raxa</title>
        </head>
        <body style="font-family: Arial, sans-serif; line-height: 1.6; color: #333; background: #f5f5f5; margin: 0; padding: 20px;">
            <div style="max-width: 600px; margin: 0 auto; background: white; border-radius: 10px; overflow: hidden; box-shadow: 0 4px 15px rgba(0,0,0,0.1);">
                
                <!-- Header -->
                <div style="background: linear-gradient(135deg, #2c5aa0 0%, #1e3d6f 100%); color: white; padding: 30px 20px; text-align: center;">
                    <h1 style="margin: 0; font-size: 28px;">Hotel Raxa</h1>
                    <p style="margin: 10px 0 0; font-size: 16px; opacity: 0.9;">Pre-arrival Payment Request</p>
                </div>
                
                <!-- Content -->
                <div style="padding: 30px;">
                    <h2 style="color: #2c5aa0; margin-top: 0;">Dear ' . esc_html($customer_name) . ',</h2>
                    
                    <p style="font-size: 16px; margin-bottom: 20px;">
                        Thank you for choosing Hotel Raxa for your upcoming stay! We are excited to welcome you and ensure you have an exceptional experience with us.
                    </p>
                    
                    <p style="font-size: 16px; margin-bottom: 25px;">
                        To secure your reservation and streamline your check-in process, we kindly request a pre-arrival payment. This helps us guarantee your room and prepare for your arrival.
                    </p>
                    
                    <!-- Booking Details Box -->
                    <div style="background: #f8f9fa; border: 1px solid #e9ecef; border-radius: 8px; padding: 25px; margin: 25px 0;">
                        <h3 style="margin-top: 0; color: #2c5aa0; border-bottom: 2px solid #2c5aa0; padding-bottom: 10px;">Booking Details</h3>
                        <table style="width: 100%; border-collapse: collapse;">
                            <tr>
                                <td style="padding: 8px 0; font-weight: bold; width: 40%;">Booking Reference:</td>
                                <td style="padding: 8px 0;">#' . $request->booking_id . '</td>
                            </tr>
                            ' . ($checkin_date ? '<tr><td style="padding: 8px 0; font-weight: bold;">Check-in Date:</td><td style="padding: 8px 0;">' . date_i18n(get_option('date_format'), strtotime($checkin_date)) . '</td></tr>' : '') . '
                            ' . ($checkout_date ? '<tr><td style="padding: 8px 0; font-weight: bold;">Check-out Date:</td><td style="padding: 8px 0;">' . date_i18n(get_option('date_format'), strtotime($checkout_date)) . '</td></tr>' : '') . '
                            <tr>
                                <td style="padding: 8px 0; font-weight: bold;">Payment Amount:</td>
                                <td style="padding: 8px 0; font-size: 18px; color: #2c5aa0; font-weight: bold;">€' . number_format($request->amount, 2) . '</td>
                            </tr>
                            <tr>
                                <td style="padding: 8px 0; font-weight: bold;">Payment Due:</td>
                                <td style="padding: 8px 0; color: #dc3545;">' . date_i18n(get_option('datetime_format'), strtotime($request->expires_at)) . '</td>
                            </tr>
                        </table>
                    </div>
                    
                    <!-- Payment Button -->
                    <div style="text-align: center; margin: 35px 0;">
                        <a href="' . $request->payment_link . '" 
                           style="background: linear-gradient(135deg, #007cba 0%, #005a87 100%); 
                                  color: white; 
                                  padding: 18px 40px; 
                                  text-decoration: none; 
                                  border-radius: 8px; 
                                  display: inline-block; 
                                  font-weight: bold; 
                                  font-size: 18px;
                                  box-shadow: 0 4px 10px rgba(0,124,186,0.3);
                                  transition: all 0.3s ease;">
                            🔒 Pay Securely Now - €' . number_format($request->amount, 2) . '
                        </a>
                    </div>
                    
                    <!-- Important Notice -->
                    <div style="background: #fff3cd; border: 1px solid #ffeaa7; border-radius: 8px; padding: 20px; margin: 25px 0;">
                        <h4 style="margin-top: 0; color: #856404; display: flex; align-items: center;">
                            ⚠️ Important Information
                        </h4>
                        <ul style="margin: 10px 0; color: #856404; padding-left: 20px;">
                            <li>This payment link will expire on <strong>' . date_i18n(get_option('datetime_format'), strtotime($request->expires_at)) . '</strong></li>
                            <li>Payment is processed securely through our trusted payment gateway</li>
                            <li>This represents 50% of your total booking amount</li>
                            <li>The remaining balance can be paid upon arrival</li>
                        </ul>
                    </div>
                    
                    <!-- Why Pre-payment -->
                    <div style="background: #e3f2fd; border-left: 4px solid #2196f3; padding: 20px; margin: 25px 0;">
                        <h4 style="margin-top: 0; color: #1565c0;">Why do we request pre-payment?</h4>
                        <p style="margin-bottom: 0; color: #1565c0;">
                            Pre-payment helps us guarantee your reservation, prepare your room according to your preferences, 
                            and ensures a smooth, fast check-in process when you arrive. It also helps us provide you with 
                            the highest level of personalized service during your stay.
                        </p>
                    </div>
                    
                    <p style="font-size: 16px;">
                        If you have any questions about this payment or your reservation, please do not hesitate to contact us. 
                        Our team is here to assist you and ensure your stay exceeds your expectations.
                    </p>
                    
                    <p style="font-size: 16px;">
                        We look forward to welcoming you to Hotel Raxa very soon!
                    </p>
                    
                    <p style="font-size: 16px; margin-bottom: 0;">
                        Warm regards,<br>
                        <strong>The Hotel Raxa Team</strong>
                    </p>
                </div>
                
                <!-- Footer -->
                <div style="background: #f8f9fa; padding: 25px; text-align: center; border-top: 1px solid #e9ecef;">
                    <p style="margin: 0 0 10px; font-weight: bold; color: #2c5aa0;">Hotel Raxa</p>
                    <p style="margin: 0 0 10px; font-size: 14px; color: #666;">
                        📧 Email: info@hotelraxa.com | 📞 Phone: +34 XXX XXX XXX
                    </p>
                    <p style="margin: 0; font-size: 12px; color: #999;">
                        This email was sent automatically. Please do not reply to this email.<br>
                        For support, contact us at info@hotelraxa.com
                    </p>
                </div>
            </div>
        </body>
        </html>';
        
        return $template;
    }
    
    /**
     * Log payment request activity
     */
    private function log_payment_request_activity($booking_id, $action, $amount, $error_message = '') {
        global $wpdb;
        
        $table_name = $wpdb->prefix . 'eb_payment_scheduler_log';
        
        $wpdb->insert(
            $table_name,
            array(
                'booking_id' => $booking_id,
                'action' => $action,
                'amount' => $amount,
                'error_message' => $error_message,
                'created_at' => current_time('mysql')
            ),
            array('%d', '%s', '%f', '%s', '%s')
        );
    }
    
    /**
     * Send admin error notification
     */
    private function send_admin_error_notification($results) {
        if (get_option('eb_scheduler_admin_notifications') !== 'yes') {
            return;
        }
        
        $admin_email = get_option('admin_email');
        $site_name = get_bloginfo('name');
        
        $subject = sprintf(
            __('Payment Scheduler Errors - %s', 'informatiq-eb-redsys'),
            $site_name
        );
        
        $message = sprintf(
            __('The automated payment request scheduler encountered errors:\n\nProcessed: %d bookings\nSent: %d requests\nSkipped: %d bookings\nErrors: %d\n\nPlease check the scheduler log for details.', 'informatiq-eb-redsys'),
            $results['processed'],
            $results['sent'],
            $results['skipped'],
            $results['errors']
        );
        
        wp_mail($admin_email, $subject, $message);
    }
    
    /**
     * Add admin menu
     */
    public function add_admin_menu() {
        add_submenu_page(
            'eb_bookings',
            __('Payment Scheduler', 'informatiq-eb-redsys'),
            __('Payment Scheduler', 'informatiq-eb-redsys'),
            'manage_options',
            'eb-payment-scheduler',
            array($this, 'admin_page')
        );
    }
    
    /**
     * Render admin page
     */
    public function admin_page() {
        $settings = $this->get_scheduler_settings();
        $last_run = get_option('eb_scheduler_last_run');
        $last_results = get_option('eb_scheduler_last_results', array());
        
        ?>
        <div class="wrap">
            <h1><?php _e('Automated Payment Scheduler', 'informatiq-eb-redsys'); ?></h1>
            
            <div class="eb-scheduler-admin">
                <!-- Current Status -->
                <div class="postbox">
                    <h2 class="hndle"><?php _e('Scheduler Status', 'informatiq-eb-redsys'); ?></h2>
                    <div class="inside">
                        <table class="form-table">
                            <tr>
                                <th scope="row"><?php _e('Status', 'informatiq-eb-redsys'); ?></th>
                                <td>
                                    <?php if (wp_next_scheduled('eb_daily_payment_check')): ?>
                                        <span style="color: #00a32a; font-weight: bold;">✓ Active</span>
                                        <p class="description">
                                            <?php _e('Next run:', 'informatiq-eb-redsys'); ?> 
                                            <?php echo date_i18n(get_option('datetime_format'), wp_next_scheduled('eb_daily_payment_check')); ?>
                                        </p>
                                    <?php else: ?>
                                        <span style="color: #d63638; font-weight: bold;">✗ Inactive</span>
                                    <?php endif; ?>
                                </td>
                            </tr>
                            <tr>
                                <th scope="row"><?php _e('Last Run', 'informatiq-eb-redsys'); ?></th>
                                <td>
                                    <?php if ($last_run): ?>
                                        <?php echo date_i18n(get_option('datetime_format'), strtotime($last_run)); ?>
                                        <?php if (!empty($last_results)): ?>
                                            <br>
                                            <small>
                                                <?php 
                                                printf(
                                                    __('Processed: %d | Sent: %d | Skipped: %d | Errors: %d', 'informatiq-eb-redsys'),
                                                    $last_results['processed'] ?? 0,
                                                    $last_results['sent'] ?? 0,
                                                    $last_results['skipped'] ?? 0,
                                                    $last_results['errors'] ?? 0
                                                );
                                                ?>
                                            </small>
                                        <?php endif; ?>
                                    <?php else: ?>
                                        <?php _e('Never run', 'informatiq-eb-redsys'); ?>
                                    <?php endif; ?>
                                </td>
                            </tr>
                        </table>
                        
                        <p>
                            <button type="button" id="manual-payment-check" class="button button-primary">
                                <?php _e('Run Manual Check', 'informatiq-eb-redsys'); ?>
                            </button>
                        </p>
                    </div>
                </div>
                
                <!-- Settings -->
                <div class="postbox">
                    <h2 class="hndle"><?php _e('Scheduler Settings', 'informatiq-eb-redsys'); ?></h2>
                    <div class="inside">
                        <form id="scheduler-settings-form">
                            <table class="form-table">
                                <tr>
                                    <th scope="row">
                                        <label for="days_before"><?php _e('Days Before Check-in', 'informatiq-eb-redsys'); ?></label>
                                    </th>
                                    <td>
                                        <input type="number" id="days_before" name="days_before" 
                                               value="<?php echo esc_attr($settings['days_before']); ?>" 
                                               min="1" max="365" class="small-text">
                                        <p class="description">
                                            <?php _e('Number of days before check-in to send payment requests', 'informatiq-eb-redsys'); ?>
                                        </p>
                                    </td>
                                </tr>
                                <tr>
                                    <th scope="row">
                                        <label for="percentage"><?php _e('Payment Percentage', 'informatiq-eb-redsys'); ?></label>
                                    </th>
                                    <td>
                                        <input type="number" id="percentage" name="percentage" 
                                               value="<?php echo esc_attr($settings['percentage']); ?>" 
                                               min="1" max="100" class="small-text">
                                        <span>%</span>
                                        <p class="description">
                                            <?php _e('Percentage of total booking amount to request', 'informatiq-eb-redsys'); ?>
                                        </p>
                                    </td>
                                </tr>
                                <tr>
                                    <th scope="row">
                                        <label for="expiry_hours"><?php _e('Payment Link Expiry', 'informatiq-eb-redsys'); ?></label>
                                    </th>
                                    <td>
                                        <select id="expiry_hours" name="expiry_hours">
                                            <option value="24" <?php selected($settings['expiry_hours'], 24); ?>><?php _e('24 hours', 'informatiq-eb-redsys'); ?></option>
                                            <option value="48" <?php selected($settings['expiry_hours'], 48); ?>><?php _e('48 hours', 'informatiq-eb-redsys'); ?></option>
                                            <option value="72" <?php selected($settings['expiry_hours'], 72); ?>><?php _e('72 hours', 'informatiq-eb-redsys'); ?></option>
                                            <option value="168" <?php selected($settings['expiry_hours'], 168); ?>><?php _e('1 week', 'informatiq-eb-redsys'); ?></option>
                                        </select>
                                    </td>
                                </tr>
                                <tr>
                                    <th scope="row">
                                        <?php _e('Admin Notifications', 'informatiq-eb-redsys'); ?>
                                    </th>
                                    <td>
                                        <label>
                                            <input type="checkbox" id="admin_notifications" name="admin_notifications" 
                                                   value="yes" <?php checked($settings['admin_notifications'], 'yes'); ?>>
                                            <?php _e('Send email notifications when errors occur', 'informatiq-eb-redsys'); ?>
                                        </label>
                                    </td>
                                </tr>
                            </table>
                            
                            <p class="submit">
                                <button type="submit" class="button-primary">
                                    <?php _e('Save Settings', 'informatiq-eb-redsys'); ?>
                                </button>
                            </p>
                        </form>
                    </div>
                </div>
                
                <!-- Recent Activity -->
                <div class="postbox">
                    <h2 class="hndle"><?php _e('Recent Activity', 'informatiq-eb-redsys'); ?></h2>
                    <div class="inside">
                        <?php $this->display_recent_activity(); ?>
                    </div>
                </div>
            </div>
        </div>
        
        <style>
        .eb-scheduler-admin .postbox {
            margin-bottom: 20px;
        }
        
        .activity-log {
            max-height: 400px;
            overflow-y: auto;
            border: 1px solid #ddd;
            background: #f9f9f9;
        }
        
        .activity-item {
            padding: 10px;
            border-bottom: 1px solid #eee;
            display: flex;
            justify-content: space-between;
            align-items: center;
        }
        
        .activity-item:last-child {
            border-bottom: none;
        }
        
        .activity-success {
            border-left: 4px solid #00a32a;
        }
        
        .activity-error {
            border-left: 4px solid #d63638;
        }
        
        .activity-info {
            border-left: 4px solid #2271b1;
        }
        </style>
        <?php
    }
    
    /**
     * Display recent activity
     */
    private function display_recent_activity() {
        global $wpdb;
        
        $table_name = $wpdb->prefix . 'eb_payment_scheduler_log';
        
        // Check if table exists
        if ($wpdb->get_var("SHOW TABLES LIKE '{$table_name}'") !== $table_name) {
            echo '<p>' . __('No activity log available. The log table will be created automatically when the scheduler runs.', 'informatiq-eb-redsys') . '</p>';
            return;
        }
        
        $activities = $wpdb->get_results("
            SELECT * FROM {$table_name} 
            ORDER BY created_at DESC 
            LIMIT 20
        ");
        
        if (empty($activities)) {
            echo '<p>' . __('No recent activity found.', 'informatiq-eb-redsys') . '</p>';
            return;
        }
        
        echo '<div class="activity-log">';
        foreach ($activities as $activity) {
            $class = '';
            $icon = '';
            
            switch ($activity->action) {
                case 'sent':
                    $class = 'activity-success';
                    $icon = '✓';
                    $message = sprintf(__('Payment request sent for booking #%d (€%.2f)', 'informatiq-eb-redsys'), $activity->booking_id, $activity->amount);
                    break;
                case 'email_failed':
                    $class = 'activity-error';
                    $icon = '✗';
                    $message = sprintf(__('Email failed for booking #%d', 'informatiq-eb-redsys'), $activity->booking_id);
                    break;
                case 'creation_failed':
                    $class = 'activity-error';
                    $icon = '✗';
                    $message = sprintf(__('Payment request creation failed for booking #%d', 'informatiq-eb-redsys'), $activity->booking_id);
                    break;
                case 'error':
                    $class = 'activity-error';
                    $icon = '✗';
                    $message = sprintf(__('Error processing booking #%d: %s', 'informatiq-eb-redsys'), $activity->booking_id, $activity->error_message);
                    break;
                default:
                    $class = 'activity-info';
                    $icon = 'ℹ';
                    $message = sprintf(__('Action "%s" for booking #%d', 'informatiq-eb-redsys'), $activity->action, $activity->booking_id);
            }
            
            echo '<div class="activity-item ' . $class . '">';
            echo '<div><span style="margin-right: 10px;">' . $icon . '</span>' . esc_html($message) . '</div>';
            echo '<div><small>' . date_i18n(get_option('datetime_format'), strtotime($activity->created_at)) . '</small></div>';
            echo '</div>';
        }
        echo '</div>';
    }
    
    /**
     * Save scheduler settings (AJAX handler)
     */
    public function save_scheduler_settings() {
        check_ajax_referer('scheduler_nonce', 'nonce');
        
        if (!current_user_can('manage_options')) {
            wp_die(__('Insufficient permissions', 'informatiq-eb-redsys'));
        }
        
        $settings = array(
            'eb_scheduler_days_before' => intval($_POST['days_before']),
            'eb_scheduler_percentage' => intval($_POST['percentage']),
            'eb_scheduler_expiry_hours' => intval($_POST['expiry_hours']),
            'eb_scheduler_admin_notifications' => isset($_POST['admin_notifications']) ? 'yes' : 'no'
        );
        
        foreach ($settings as $key => $value) {
            update_option($key, $value);
        }
        
        wp_send_json_success(__('Settings saved successfully', 'informatiq-eb-redsys'));
    }
    
    /**
     * Manual payment check (AJAX handler)
     */
    public function manual_payment_check() {
        check_ajax_referer('scheduler_nonce', 'nonce');
        
        if (!current_user_can('manage_options')) {
            wp_die(__('Insufficient permissions', 'informatiq-eb-redsys'));
        }
        
        $results = $this->process_daily_payment_requests();
        
        wp_send_json_success($results);
    }
    
    /**
     * Enqueue admin scripts
     */
    public function enqueue_admin_scripts($hook) {
        if (strpos($hook, 'eb-payment-scheduler') === false) {
            return;
        }
        
        wp_enqueue_script(
            'eb-scheduler-admin',
            plugin_dir_url(__FILE__) . '../assets/js/scheduler-admin.js',
            array('jquery'),
            '1.0.0',
            true
        );
        
        wp_localize_script('eb-scheduler-admin', 'ebScheduler', array(
            'ajaxurl' => admin_url('admin-ajax.php'),
            'nonce' => wp_create_nonce('scheduler_nonce'),
            'strings' => array(
                'confirmManualRun' => __('Are you sure you want to run a manual payment check?', 'informatiq-eb-redsys'),
                'processing' => __('Processing...', 'informatiq-eb-redsys'),
                'completed' => __('Manual check completed!', 'informatiq-eb-redsys')
            )
        ));
    }
    
    /**
     * Create database table for scheduler log
     */
    public static function create_scheduler_table() {
        global $wpdb;
        
        $table_name = $wpdb->prefix . 'eb_payment_scheduler_log';
        
        $charset_collate = $wpdb->get_charset_collate();
        
        $sql = "CREATE TABLE {$table_name} (
            id int(11) NOT NULL AUTO_INCREMENT,
            booking_id int(11) NOT NULL,
            action varchar(50) NOT NULL,
            amount decimal(10,2) DEFAULT 0,
            error_message text,
            created_at datetime NOT NULL,
            PRIMARY KEY (id),
            KEY booking_id (booking_id),
            KEY action (action),
            KEY created_at (created_at)
        ) {$charset_collate};";
        
        require_once ABSPATH . 'wp-admin/includes/upgrade.php';
        dbDelta($sql);
    }
}

// Initialize the scheduler
new EB_Payment_Scheduler();

// Create table on activation
register_activation_hook(EB_REDSYS_FILE, array('EB_Payment_Scheduler', 'create_scheduler_table'));