<?php
defined( 'ABSPATH' ) || exit;

if ( ! class_exists( 'ATKAI_AI_Logs_Cleanup' ) ) {

    class ATKAI_AI_Logs_Cleanup {

        public function __construct() {
            // Ensure our daily event exists
            if ( ! wp_next_scheduled( 'atk_ai_logs_cleanup_daily_event' ) ) {
                wp_schedule_event( time(), 'daily', 'atk_ai_logs_cleanup_daily_event' );
            }
            // Hook our cleanup logic
            add_action( 'atk_ai_logs_cleanup_daily_event', [ $this, 'cleanup_logs' ] );
        }

        /**
         * Delete any log rows older than X days,
         * where X comes from the atk_logs_days option.
         */
        public function cleanup_logs() {
            global $wpdb;

            // 1) Figure out how many days to keep (fallback to 30)
            $opts = get_option( 'atk_options', [] );
            $days = isset( $opts['atk_logs_days'] ) && is_numeric( $opts['atk_logs_days'] )
                ? intval( $opts['atk_logs_days'] )
                : 30;

            // 2) Compute the cutoff datetime
            $cutoff = gmdate( 'Y-m-d H:i:s', strtotime( "-{$days} days" ) );

            // 3) Build & run the SELECT via identifier + value placeholders
            $old_ids = $wpdb->get_col(
                $wpdb->prepare(
                    // %i → identifier (table name), %s → string (cutoff datetime)
                    'SELECT log_id FROM %i WHERE created_date < %s',
                    $wpdb->prefix . 'atk_ai_logs',
                    $cutoff
                )
            );

            // 4) Delete each old record safely
            if ( ! empty( $old_ids ) ) {
                foreach ( $old_ids as $log_id ) {
                    $wpdb->delete(
                        $wpdb->prefix . 'atk_ai_logs',
                        [ 'log_id' => absint( $log_id ) ],
                        [ '%d' ]
                    );
                }
            }
        }
    }
    
    // Initialize the cleanup class
    new ATKAI_AI_Logs_Cleanup();
}