<?php

if ( ! defined( 'ABSPATH' ) ) {
	exit;
}


/**
 * The admin-specific functionality of the plugin.
 *
 * @link       http://www.redefiningtheweb.com
 * @since      1.0.0
 *
 * @package    Rtwalwm_Wp_Wc_Affiliate_Program
 * @subpackage Rtwalwm_Wp_Wc_Affiliate_Program/admin
 */

/**
 * The admin-specific functionality of the plugin.
 *
 * Defines the plugin name, version, and two examples hooks for how to
 * enqueue the admin-specific stylesheet and JavaScript.
 *
 * @package    Rtwalwm_Wp_Wc_Affiliate_Program
 * @subpackage Rtwalwm_Wp_Wc_Affiliate_Program/admin
 * @author     RedefiningTheWeb <developer@redefiningtheweb.com>
 */
class Rtwalwm_Wp_Wc_Affiliate_Program_Admin {

    /**
     * The ID of this plugin.
     *
     * @since    1.0.0
     * @access   private
     * @var      string    $rtwalwm_plugin_name    The ID of this plugin.
     */
    private $rtwalwm_plugin_name;

    /**
     * The version of this plugin.
     *
     * @since    1.0.0
     * @access   private
     * @var      string    $rtwalwm_version    The current version of this plugin.
     */
    private $rtwalwm_version;

    /**
     * Initialize the class and set its properties.
     *
     * @since    1.0.0
     * @param      string    $rtwalwm_plugin_name       The name of this plugin.
     * @param      string    $rtwalwm_version    The version of this plugin.
     */
    public function __construct( $rtwalwm_plugin_name, $rtwalwm_version ) {

        $this->rtwalwm_plugin_name = $rtwalwm_plugin_name;
        $this->rtwalwm_version = $rtwalwm_version;

        // $rtwalwm_generate_aff_csv = isset($_GET['affiliate_csv_download'])? sanitize_text_field($_GET['affiliate_csv_download']): '';
        // if(!empty($rtwalwm_generate_aff_csv))
        // {
        //  add_action('init', array($this, 'rtwalwm_download_affiliate_csv'));
        // }

    }

    // public function rtwalwm_download_affiliate_csv(){

    //  require_once( WP_PLUGIN_DIR."/wp-wc-affiliate-program/third_party/csv-9.8.0/autoload.php");
    //  $rtwalwm_file_name = sanitize_text_field($_GET['affiliate_csv_download']);
    //  if(empty($rtwalwm_file_name )){
    //      wp_die(esc_html__('Invalid file name.','affiliaa-affiliate-program-with-mlm'));
    //  }
        
    //  $rtwalwm_file_path = RTWALWM_DIR.'assets/csv/'.$rtwalwm_file_name;

    //  if (!file_exists($rtwalwm_file_path) || strpos(realpath($rtwalwm_file_path), realpath(RTWALWM_DIR . 'assets/csv/')) !== 0) {
    //      wp_die(esc_html__('File does not exist or invalid file path.', 'affiliaa-affiliate-program-with-mlm'));
    //  }

    //  header('Content-Type: text/csv; charset=UTF-8');
    //  header('Content-Description: File Transfer');
    //  header('Content-Disposition: attachment; filename="'.$rtwalwm_file_name.'"');
    //  $reader = Reader::createFromPath(RTWALWM_DIR.'assets/csv/'.$rtwalwm_file_name, 'r');
    //  $reader->output();
    //  wp_die();
    // }

    /**
     * Register the stylesheets for the admin area.
     *
     * @since    1.0.0
     */
    public function rtwalwm_enqueue_styles() {

        /**
         * This function is provided for demonstration purposes only.
         *
         * An instance of this class should be passed to the run() function
         * defined in Rtwalwm_Wp_Wc_Affiliate_Program_Loader as all of the hooks are defined
         * in that particular class.
         *
         * The Rtwalwm_Wp_Wc_Affiliate_Program_Loader will then create the relationship
         * between the defined hooks and the functions defined in this
         * class.
         */
        wp_enqueue_media();

        $rtwalwm_css_allowed_pages = array(
                                        'edit-product',
                                        'toplevel_page_rtwalwm',
                                        'product',
                                        'user-edit',
                                        'users',
                                        'user',
                                        'profile',
                                        'download'
                                    );

        $rtwalwm_screen     = function_exists( 'get_current_screen' ) ? get_current_screen() : '';
        $rtwalwm_screen_id  = ( isset( $rtwalwm_screen->id ) ) ? $rtwalwm_screen->id : '';

        if( in_array( $rtwalwm_screen_id, $rtwalwm_css_allowed_pages ) ){

            wp_enqueue_style( $this->rtwalwm_plugin_name, plugin_dir_url( __FILE__ ) . 'css/rtwalwm-wp-wc-affiliate-program-admin.css', array(), $this->rtwalwm_version, 'all' );
            // wp_enqueue_style( "banner-css", plugin_dir_url( __FILE__ ) . 'css/rtwalwm-wp-wc-affiliate-banner.css', array(), $this->rtwalwm_version, 'all' );
            wp_enqueue_style( "select2", RTWALWM_URL. '/assets/Datatables/css/rtwalwm-wp-select2.min.css', array(), $this->rtwalwm_version, 'all' );

            wp_enqueue_style( "datatable", RTWALWM_URL. '/assets/Datatables/css/jquery.dataTables.min.css', array(), $this->rtwalwm_version, 'all' );
            wp_enqueue_style( "rowReorder", RTWALWM_URL. '/assets/Datatables/css/rowReorder.dataTables.min.css', array( 'datatable' ), $this->rtwalwm_version, 'all' );
            wp_enqueue_style( "jquery-ui", RTWALWM_URL. '/assets/Datatables/css/rtwalwm-jquery-ui.css', array(), $this->rtwalwm_version, 'all' );
            wp_enqueue_style( "orgchart", RTWALWM_URL. '/assets/orgChart/jquery.orgchart.css', array(), $this->rtwalwm_version, 'all' );
            wp_enqueue_style( 'dashicons' );

            
        }

    }

    /**
     * Register the JavaScript for the admin area.
     *
     * @since    1.0.0
     */
    public function rtwalwm_enqueue_scripts() {

        /**
         * This function is provided for demonstration purposes only.
         *
         * An instance of this class should be passed to the run() function
         * defined in Rtwalwm_Wp_Wc_Affiliate_Program_Loader as all of the hooks are defined
         * in that particular class.
         *
         * The Rtwalwm_Wp_Wc_Affiliate_Program_Loader will then create the relationship
         * between the defined hooks and the functions defined in this
         * class.
         */
        $rtwalwm_js_allowed_pages = array(
                                        'product',
                                        'edit-product',
                                        'toplevel_page_rtwalwm',
                                        'users',
                                        'user-edit',
                                        'user',
                                        'profile',
                                        'edit-download'
                                    );

        $rtwalwm_screen     = function_exists( 'get_current_screen' ) ? get_current_screen() : '';
        $rtwalwm_screen_id  = ( isset( $rtwalwm_screen->id ) ) ? $rtwalwm_screen->id : '';

        if( in_array( $rtwalwm_screen_id, $rtwalwm_js_allowed_pages ) ){
            
            wp_enqueue_script( "datatable", RTWALWM_URL. '/assets/Datatables/js/jquery.dataTables.min.js', array( 'jquery' ), $this->rtwalwm_version, false );
            wp_enqueue_script( "rowReorder", RTWALWM_URL. '/assets/Datatables/js/dataTables.rowReorder.min.js', array( 'jquery', 'datatable' ), $this->rtwalwm_version, false );
            wp_enqueue_script( "select2", RTWALWM_URL. '/assets/Datatables/js/rtwalwm-wp-select2.min.js', array( 'jquery' ), $this->rtwalwm_version, false );

            wp_enqueue_script( 'jquery-ui-dialog', '', array( 'jquery' ), $this->rtwalwm_version, false );
            wp_enqueue_script( "blockUI", RTWALWM_URL. '/assets/Datatables/js/rtwalwm-wp-blockui.js', array( 'jquery' ), $this->rtwalwm_version, false );

            wp_register_script( $this->rtwalwm_plugin_name, plugin_dir_url( __FILE__ ) . 'js/rtwalwm-wp-wc-affiliate-program-admin.js', array( 'jquery', 'select2', 'datatable', 'rowReorder' ), $this->rtwalwm_version, false );
            
            
            wp_enqueue_script( "orgchart", RTWALWM_URL. '/assets/orgChart/jquery.orgchart.js', array( 'jquery' ), $this->rtwalwm_version, false );

            wp_enqueue_script( 'wp-color-picker', admin_url( 'js/color-picker.min.js' ), array( 'iris' ), $this->rtwalwm_version, true );
            $rtwalwm_colorpicker_l10n = array(
                'clear'         => esc_html__( 'Clear', 'affiliaa-affiliate-program-with-mlm' ),
                'defaultString' => esc_html__( 'Default', 'affiliaa-affiliate-program-with-mlm' ),
                'pick'          => esc_html__( 'Select Color', 'affiliaa-affiliate-program-with-mlm' ),
                'current'       => esc_html__( 'Current Color', 'affiliaa-affiliate-program-with-mlm' )
            );
            wp_localize_script( 'wp-color-picker', 'wpColorPickerL10n', $rtwalwm_colorpicker_l10n );

            $rtwalwm_ajax_nonce         = wp_create_nonce( "rtwalwm-admin-ajax-string" );
            $rtwalwm_translation_array  = array(
                                                'rtwalwm_ajaxurl'   => esc_url( admin_url( 'admin-ajax.php' ) ),
                                                'rtwalwm_nonce'     => $rtwalwm_ajax_nonce,
                                                'rtwalwm_digit'     => esc_html__( 'Digits Only', 'affiliaa-affiliate-program-with-mlm' ),
                                                'rtwalwm_bank_det'  => esc_html__( 'Details not filled', 'affiliaa-affiliate-program-with-mlm' ),
                                                'rtwalwm_bank_sent' => esc_html__( 'Are you sure that you have completed this bank transfer?', 'affiliaa-affiliate-program-with-mlm' ),
                                                'rtwalwm_nothing_marked' => esc_html__( 'Nothing Marked', 'affiliaa-affiliate-program-with-mlm' ),
                                                'rtwalwm_approval_sure' => esc_html__( 'Are you sure to approve this Referral? It can\'t be reverted back once approved', 'affiliaa-affiliate-program-with-mlm' ),
                                                'rtwalwm_approval_sure_all' => esc_html__( 'Are you sure to approve all the Referrals? It can\'t be reverted back once approved', 'affiliaa-affiliate-program-with-mlm' ),
                                                'rtwalwm_reject_sure'       => esc_html__( 'Are you sure to reject this Referral? It can\'t be reverted back once rejected', 'affiliaa-affiliate-program-with-mlm' ),
                                                'rtwalwm_reject_message_blank'      => esc_html__( 'Please input some text in message box', 'affiliaa-affiliate-program-with-mlm' ),
                                                'rtwalwm_reject_sure_all'   => esc_html__( 'Are you sure to reject all the Referrals? It can\'t be reverted back once rejected', 'affiliaa-affiliate-program-with-mlm' ),
                                                'rtwalwm_target_link'  => esc_html__( 'Please Enter Target URL', 'affiliaa-affiliate-program-with-mlm' ),
                                                'rtwalwm_image_id'  => esc_html__( 'Please Select Image', 'affiliaa-affiliate-program-with-mlm' ),
                                                'rtwalwm_image_parameter_not_match'  => esc_html__( 'Image width or height is not matching with selected Image WIDTH x HEIGHT', 'affiliaa-affiliate-program-with-mlm' )
                                            
                                            );
            wp_localize_script( $this->rtwalwm_plugin_name, 'rtwalwm_global_params', $rtwalwm_translation_array );
            wp_enqueue_script( $this->rtwalwm_plugin_name );
            wp_enqueue_script( 'jquery.validate', plugin_dir_url( __FILE__ ) . 'js/jquery.validate/jquery.validate.js', array( 'jquery' ), $this->rtwalwm_version, false );

        }

    }


    /*
    * Function to show settings link
    */
    function rtwalwm_add_setting_links( $rtwalwm_links ){
        $rtwalwm_links[] = '<a href="' . admin_url( 'admin.php?page=rtwalwm' ) . '">'.esc_html__( 'Settings', 'affiliaa-affiliate-program-with-mlm' ).'</a>';
        return $rtwalwm_links;
    }

    /*
    * Function to add submenu in WooCommerce menu tab
    */
    function rtwalwm_add_submenu()
    {
        $rtwalwm_menu_position = '80';
        // Same audience as the referral handlers: administrators, and store managers when WooCommerce grants manage_woocommerce.
        $rtwalwm_capability = current_user_can( 'manage_options' ) ? 'manage_options' : 'manage_woocommerce';
        add_menu_page( esc_html__( 'Affiliaa - WordPress & WooCommerce Affiliate Program', 'affiliaa-affiliate-program-with-mlm' ), esc_html__( 'Affiliaa Lite', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_capability, 'rtwalwm', array( $this, 'rtwalwm_admin_setting' ), RTWALWM_URL.'assets/images/affiliate-menu-icon.png', $rtwalwm_menu_position );
    }

    function rtwalwm_admin_setting()
    {
        include_once( RTWALWM_DIR.'admin/partials/rtwalwm-wp-wc-affiliate-program-admin-display.php');
    }

    /*
    * Function to register settings
    */
    function rtwalwm_settings_init()
    {
        register_setting( 'rtwwwap_commission_settings', 'rtwwwap_commission_settings_opt', array( $this, 'rtwalwm_save_comm' ) );
        register_setting( 'rtwwwap_extra_features', 'rtwwwap_extra_features_opt', array( $this, 'rtwalwm_save_extra' ) );
        register_setting( 'rtwwwap_mlm', 'rtwwwap_mlm_opt', array( $this, 'rtwwwap_save_mlm' ) );
    }

    /*
    * Function to save commission settings
    */
    function rtwalwm_save_comm( $rtwalwm_option )
    {
        // Merge into the stored (shared) option so keys saved by other screens or PRO are preserved.
        $rtwalwm_saved  = get_option( 'rtwwwap_commission_settings_opt' );
        $rtwalwm_out    = is_array( $rtwalwm_saved ) ? $rtwalwm_saved : array();
        $rtwalwm_option = is_array( $rtwalwm_option ) ? $rtwalwm_option : array();

        foreach ( $rtwalwm_option as $rtwalwm_key => $rtwalwm_value ) {
            $rtwalwm_key = sanitize_key( $rtwalwm_key );
            if ( 'comm_base' === $rtwalwm_key ) {
                $rtwalwm_out[ $rtwalwm_key ] = in_array( (string) $rtwalwm_value, array( '1', '2' ), true ) ? (string) $rtwalwm_value : '1';
            }
            elseif ( 'all_commission_type' === $rtwalwm_key ) {
                $rtwalwm_out[ $rtwalwm_key ] = ( 'fixed' === $rtwalwm_value ) ? 'fixed' : 'percentage';
            }
            elseif ( 'per_prod_mode' === $rtwalwm_key ) {
                $rtwalwm_out[ $rtwalwm_key ] = in_array( (string) $rtwalwm_value, array( '1', '2' ), true ) ? (string) $rtwalwm_value : '';
            }
            elseif ( in_array( $rtwalwm_key, array( 'all_commission', 'max_commission', 'withdraw_commission' ), true ) ) {
                $rtwalwm_number = Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_decimal_or_empty( $rtwalwm_value );
                if ( null === $rtwalwm_number ) {
                    add_settings_error( 'rtwwwap_commission_settings_opt', 'rtwalwm_invalid_' . $rtwalwm_key, esc_html__( 'Commission amounts must be numbers of 0 or more. The previous value was kept.', 'affiliaa-affiliate-program-with-mlm' ) );
                    continue;
                }
                $rtwalwm_out[ $rtwalwm_key ] = $rtwalwm_number;
            }
            else {
                $rtwalwm_out[ $rtwalwm_key ] = Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_sanitize_recursive( $rtwalwm_value );
            }
        }

        if ( isset( $rtwalwm_out['all_commission'], $rtwalwm_out['all_commission_type'] ) && 'percentage' === $rtwalwm_out['all_commission_type'] && '' !== $rtwalwm_out['all_commission'] && (float) $rtwalwm_out['all_commission'] > 100 ) {
            $rtwalwm_out['all_commission'] = '100';
            add_settings_error( 'rtwwwap_commission_settings_opt', 'rtwalwm_percentage_cap', esc_html__( 'A percentage commission cannot exceed 100. It was set to 100.', 'affiliaa-affiliate-program-with-mlm' ) );
        }

        return $rtwalwm_out;
    }

    /*
    * Function to save extra settings
    */
    function rtwalwm_save_extra( $rtwalwm_option )
    {
        $rtwalwm_saved  = get_option( 'rtwwwap_extra_features_opt' );
        $rtwalwm_out    = is_array( $rtwalwm_saved ) ? $rtwalwm_saved : array();
        $rtwalwm_option = is_array( $rtwalwm_option ) ? $rtwalwm_option : array();

        foreach ( $rtwalwm_option as $rtwalwm_key => $rtwalwm_value ) {
            $rtwalwm_key = sanitize_key( $rtwalwm_key );
            if ( 'page' === $rtwalwm_key ) {
                // Same behaviour as PRO: the selected page becomes the shared affiliate page option and is not stored here.
                $rtwalwm_page_id = absint( $rtwalwm_value );
                if ( $rtwalwm_page_id && 'page' === get_post_type( $rtwalwm_page_id ) ) {
                    update_option( 'rtwwwap_affiliate_page_id', $rtwalwm_page_id );
                }
                continue;
            }
            if ( 'aff_benefits' === $rtwalwm_key ) {
                $rtwalwm_out[ $rtwalwm_key ] = wp_kses_post( $rtwalwm_value );
            }
            elseif ( 'css' === $rtwalwm_key ) {
                // Custom CSS is printed inside a <style> element, so no markup is allowed.
                $rtwalwm_out[ $rtwalwm_key ] = str_replace( '<', '', wp_strip_all_tags( (string) $rtwalwm_value ) );
            }
            else {
                $rtwalwm_out[ $rtwalwm_key ] = Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_sanitize_recursive( $rtwalwm_value );
            }
        }
        unset( $rtwalwm_out['page'] );

        return $rtwalwm_out;
    }

    function rtwwwap_save_mlm( $rtwwwap_option )
    {
        $rtwwwap_saved  = get_option( 'rtwwwap_mlm_opt' );
        $rtwwwap_out    = is_array( $rtwwwap_saved ) ? $rtwwwap_saved : array();
        $rtwwwap_option = is_array( $rtwwwap_option ) ? $rtwwwap_option : array();

        // The MLM form posts every field it shows, so these keys are taken from the submission (unchecked = off).
        // Values that are invalid, or that Lite's form can't represent, keep what is stored (PRO shares this option).
        $rtwwwap_out['activate'] = ( isset( $rtwwwap_option['activate'] ) && '1' === (string) $rtwwwap_option['activate'] ) ? '1' : '';
        if ( isset( $rtwwwap_option['mlm_type'] ) && in_array( (string) $rtwwwap_option['mlm_type'], array( '0', '1', '2' ), true ) ) {
            $rtwwwap_out['mlm_type'] = (string) $rtwwwap_option['mlm_type'];
        } elseif ( ! isset( $rtwwwap_out['mlm_type'] ) ) {
            $rtwwwap_out['mlm_type'] = '0';
        }
        foreach ( array( 'depth', 'child' ) as $rtwwwap_key ) {
            $rtwwwap_number = isset( $rtwwwap_option[ $rtwwwap_key ] ) ? absint( $rtwwwap_option[ $rtwwwap_key ] ) : 0;
            if ( $rtwwwap_number >= 1 ) {
                $rtwwwap_out[ $rtwwwap_key ] = $rtwwwap_number;
            } elseif ( ! isset( $rtwwwap_out[ $rtwwwap_key ] ) || absint( $rtwwwap_out[ $rtwwwap_key ] ) < 1 ) {
                $rtwwwap_out[ $rtwwwap_key ] = 1;
            }
        }
        $rtwwwap_out['mlm_default_comm']        = ( isset( $rtwwwap_option['mlm_default_comm'] ) && '0' === (string) $rtwwwap_option['mlm_default_comm'] ) ? '0' : '1';
        $rtwwwap_amount                         = isset( $rtwwwap_option['mlm_default_comm_amount'] ) ? Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_decimal_or_empty( $rtwwwap_option['mlm_default_comm_amount'] ) : '';
        $rtwwwap_out['mlm_default_comm_amount'] = ( null === $rtwwwap_amount ) ? '0' : $rtwwwap_amount;

        $rtwwwap_levels = array();
        if ( isset( $rtwwwap_option['mlm_levels'] ) && is_array( $rtwwwap_option['mlm_levels'] ) ) {
            foreach ( $rtwwwap_option['mlm_levels'] as $rtwwwap_level_key => $rtwwwap_level ) {
                // Skip the hidden template row (non-numeric keys) and malformed rows.
                if ( ! is_numeric( trim( (string) $rtwwwap_level_key ) ) || ! is_array( $rtwwwap_level ) ) {
                    continue;
                }
                $rtwwwap_level_amount = isset( $rtwwwap_level['mlm_level_comm_amount'] ) ? Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_decimal_or_empty( $rtwwwap_level['mlm_level_comm_amount'] ) : '';
                $rtwwwap_levels[ absint( $rtwwwap_level_key ) ] = array(
                    'mlm_level_comm_type'   => ( isset( $rtwwwap_level['mlm_level_comm_type'] ) && '0' === (string) $rtwwwap_level['mlm_level_comm_type'] ) ? '0' : '1',
                    'mlm_level_comm_amount' => ( null === $rtwwwap_level_amount || '' === $rtwwwap_level_amount ) ? '0' : $rtwwwap_level_amount,
                );
            }
        }
        $rtwwwap_out['mlm_levels'] = $rtwwwap_levels;

        return $rtwwwap_out;
    }

    /*
    * Function to update thead of users table
    */
    function rtwalwm_add_affiliate_column( $rtwalwm_columns )
    {
        if( current_user_can( 'manage_options' ) || current_user_can( 'manage_woocommerce' ) ){
            $rtwalwm_columns[ 'rtwalwm_affiliate' ] = esc_attr__( 'Affiliate', 'affiliaa-affiliate-program-with-mlm' );
            $rtwalwm_commission_settings    = get_option( 'rtwwwap_commission_settings_opt' );
            $rtwalwm_comm_base              = isset( $rtwalwm_commission_settings[ 'comm_base' ] ) ? $rtwalwm_commission_settings[ 'comm_base' ] : '1';

            if( $rtwalwm_comm_base == 2 ){
                $rtwalwm_levels_settings = get_option( 'rtwalwm_levels_settings_opt' );
                if( !empty( $rtwalwm_levels_settings ) ){
                    $rtwalwm_columns[ 'rtwalwm_affiliate_level' ] = esc_attr__( 'Affiliate Level', 'affiliaa-affiliate-program-with-mlm' );
                }
            }
        }
        return $rtwalwm_columns;
    }

    /*
    * Function to update tbody of users table
    */
    function rtwalwm_manage_affiliate_column( $rtwalwm_empty = '', $rtwalwm_column='', $rtwalwm_user_id='')
    {

        $rtwalwm_user_aff = get_user_meta( $rtwalwm_user_id, 'rtwwwap_affiliate', true );
        
        if( $rtwalwm_column == 'rtwalwm_affiliate' ){

            if (RTWALWM_IS_WOO == 1)
            {
                $rtwalwm_check_col = woocommerce_form_field('rtwalwm_affiliate', array(
                        'type'              => 'checkbox',
                        'input_class'       => array( 'rtwalwm_affiliate_checkbox'),
                        'custom_attributes' => array( 'data-rtwalwm-num' => $rtwalwm_user_id ),
                        'required'          => false,
                        'return'            => true
                    ),get_user_meta( $rtwalwm_user_id, 'rtwwwap_affiliate', true ));
            }   
            if (RTWALWM_IS_Easy == 1)
            {
                $rtwalwm_check_col='';
                $rtwalwm_check_col .= "<p class='form-row' data-priority=''>";
                $rtwalwm_check_col .= "<span>";
                $rtwalwm_check_col .= "<label class='checkbox' data-rtwalwm-num='".esc_attr($rtwalwm_user_id)."'>";
                if($rtwalwm_user_aff == 1)
                {
                $rtwalwm_check_col .= "<input type='checkbox' class='input-checkbox rtwalwm_affiliate_checkbox' name='rtwalwm_affiliate' id='rtwalwm_affiliate' value='".esc_attr($rtwalwm_user_aff)."' checked >";
                }else
                {
                    $rtwalwm_check_col .= "<input type='checkbox' class='input-checkbox rtwalwm_affiliate_checkbox' name='rtwalwm_affiliate' id='rtwalwm_affiliate' value='".esc_attr($rtwalwm_user_aff)."' unchecked >";   
                }
                
                $rtwalwm_check_col .= "<span class='optional'>(optional)</span>";
                $rtwalwm_check_col .= "</label>";
                $rtwalwm_check_col .= "</span>";
                $rtwalwm_check_col .= "</p>";
            }   
        
            return $rtwalwm_check_col;
            
        }

        
        return $rtwalwm_empty;
    }

    function rtwalwm_change_affiliate_callback()
    {
        check_ajax_referer( 'rtwalwm-admin-ajax-string', 'rtwalwm_security_check' );

        $rtwalwm_user_id = isset( $_POST[ 'rtwalwm_user_id' ] ) ? absint( wp_unslash( $_POST[ 'rtwalwm_user_id' ] ) ) : 0;
        if ( ! Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_can_manage() || ! $rtwalwm_user_id || ! current_user_can( 'edit_user', $rtwalwm_user_id ) ) {
            echo wp_json_encode( array( 'rtwalwm_status' => false, 'rtwalwm_message' => esc_html__( 'You are not allowed to change this user.', 'affiliaa-affiliate-program-with-mlm' ) ) );
            wp_die( '', '', 403 );
        }

        $rtwalwm_value   = ( isset( $_POST[ 'rtwalwm_value' ] ) && '1' === sanitize_text_field( wp_unslash( $_POST[ 'rtwalwm_value' ] ) ) ) ? '1' : '0';
        $rtwalwm_updated = update_user_meta( $rtwalwm_user_id, 'rtwwwap_affiliate', $rtwalwm_value );
        update_user_meta( $rtwalwm_user_id, 'rtwwwap_aff_approved', $rtwalwm_value );

        $rtwalwm_message = ( '1' === $rtwalwm_value ) ? esc_html__( 'This user is an affiliate now', 'affiliaa-affiliate-program-with-mlm' ) : esc_html__( 'This user is not an affiliate now', 'affiliaa-affiliate-program-with-mlm' );
        echo wp_json_encode( array( 'rtwalwm_status' => (bool) $rtwalwm_updated, 'rtwalwm_message' => $rtwalwm_message ) );
        wp_die();
    }

    /*
    * Function to add make affiliate field while adding new user
    */
    function rtwalwm_custom_user_profile_fields_add(){ ?>
        <h3><?php esc_html_e( "Affiliaa - WordPress & WooCommerce Affiliate Program", 'affiliaa-affiliate-program-with-mlm' ); ?></h3>
        <table class="form-table">
            <tr>
                <th><label for="rtwalwm_affiliate"><?php esc_html_e( "Become Affiliate", 'affiliaa-affiliate-program-with-mlm' ); ?></label></th>
                <td>
                    <input type="checkbox" class="rtwalwm_add_user_affiliate" name="rtwalwm_add_affiliate_checkbox" id="rtwalwm_add_user_affiliate" />
                    <span class="description"><?php esc_html_e( "This will make this user also as an Affiliate", 'affiliaa-affiliate-program-with-mlm' ); ?></span>
                </td>
            </tr>
            <?php
                $rtwalwm_commission_settings = get_option( 'rtwwwap_commission_settings_opt' );
                $rtwalwm_comm_base = isset( $rtwalwm_commission_settings[ 'comm_base' ] ) ? $rtwalwm_commission_settings[ 'comm_base' ] : '1';
                if( $rtwalwm_comm_base == 2 ){
                    $rtwalwm_levels_settings = get_option( 'rtwalwm_levels_settings_opt' );
                    if( !empty( $rtwalwm_levels_settings ) ){
            ?>
                        <tr class="rtwalwm_new_user_level">
                            <th><label for="rtwalwm_affiliate"><?php esc_html_e( "Affiliate Level", 'affiliaa-affiliate-program-with-mlm' ); ?></label></th>
                            <td>
                                <select class="rtwalwm_select2_user_level" id="" name="rtwalwm_affiliate_level" >
                                    <?php
                                        foreach( $rtwalwm_levels_settings as $rtwalwm_key => $rtwalwm_value ){
                                    ?>
                                        <option value="<?php echo esc_attr($rtwalwm_key); ?>" >
                                            <?php echo esc_html( $rtwalwm_value[ 'level_name' ] ); ?>
                                        </option>
                                    <?php
                                        }
                                    ?>
                                </select>
                            </td>
                        </tr>
            <?php
                    }
                }
            ?>
        </table>
    <?php
    wp_nonce_field( 'rtwalwm_add_affiliate_action', 'rtwalwm_add_affiliate_nonce' );
    }

    /*
    * Function to save make affiliate field while adding new user
    */
    function rtwalwm_save_custom_user_profile_fields_add( $rtwalwm_user_id ){
        if ( ! isset( $_POST['rtwalwm_add_affiliate_nonce'] ) || ! wp_verify_nonce( sanitize_text_field( wp_unslash( $_POST['rtwalwm_add_affiliate_nonce'] )), 'rtwalwm_add_affiliate_action' ) ) {
            return false;
        }

        if ( ! ( current_user_can( 'manage_options' ) || current_user_can( 'manage_woocommerce' ) ) ) {
            return false;
        }
        $rtwalwm_value = ( isset( $_POST['rtwalwm_add_affiliate_checkbox'] ) && sanitize_text_field( wp_unslash($_POST['rtwalwm_add_affiliate_checkbox'] )) == 'on' ) ? 1 : 0;
        update_user_meta( $rtwalwm_user_id, 'rtwwwap_affiliate', $rtwalwm_value );
        update_user_meta( $rtwalwm_user_id, 'rtwwwap_aff_approved', $rtwalwm_value );

      
    }


    /*
    * Function to update thead of products table
    */
    function rtwalwm_add_commission_column( $rtwalwm_columns)
    {


        if( current_user_can( 'manage_options' ) || current_user_can( 'manage_woocommerce' ) ){
            $rtwalwm_commission_settings    = get_option( 'rtwwwap_commission_settings_opt' );
            $rtwalwm_comm_base              = isset( $rtwalwm_commission_settings[ 'comm_base' ] ) ? $rtwalwm_commission_settings
            [ 'comm_base' ] : '1';
            
            if( $rtwalwm_comm_base == 1 ){
                $rtwalwm_commission_settings = isset( $rtwalwm_commission_settings[ 'per_prod_mode' ] ) ? $rtwalwm_commission_settings[ 'per_prod_mode' ] : 0;

                if( $rtwalwm_commission_settings == 1 ){
                    $rtwalwm_columns = array_merge( $rtwalwm_columns, array( 'rtwalwm_prod_perc_commission' => esc_html__( 'Percentage Commission', 'affiliaa-affiliate-program-with-mlm' ) ) );
                    
                }


                if( $rtwalwm_commission_settings == 2 ){
                    $rtwalwm_columns = array_merge( $rtwalwm_columns, array( 'rtwalwm_prod_fix_commission' => esc_html__( 'Fixed Commission', 'affiliaa-affiliate-program-with-mlm' ) ) );
                }
                
            }
        }

        return $rtwalwm_columns;
    }

    /*
    * Function to update tbody of products table
    */
    function rtwalwm_manage_commission_column( $rtwalwm_column, $rtwalwm_post_id )
    {
        if ( ! in_array( $rtwalwm_column, array( 'rtwalwm_prod_perc_commission', 'rtwalwm_prod_fix_commission' ), true ) ) {
            return $rtwalwm_column;
        }
        if ( 'product' !== get_post_type( $rtwalwm_post_id ) || ! Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_can_manage() || ! current_user_can( 'edit_post', $rtwalwm_post_id ) ) {
            return $rtwalwm_column;
        }

        $rtwalwm_is_perc  = ( 'rtwalwm_prod_perc_commission' === $rtwalwm_column );
        $rtwalwm_meta_key = $rtwalwm_is_perc ? 'rtwalwm_percentage_commission_box' : 'rtwalwm_fixed_commission_box';
        $rtwalwm_value    = get_post_meta( $rtwalwm_post_id, $rtwalwm_meta_key, true );

        printf(
            '<p class="form-row"><span><input type="number" min="0" step="0.01" %1$s class="input-text %2$s" placeholder="%3$s" value="%4$s" data-rtwalwm-num="%5$d" style="width: 105px;"></span></p>',
            $rtwalwm_is_perc ? 'max="100"' : '',
            $rtwalwm_is_perc ? 'rtwalwm_perc_commission_box' : 'rtwalwm_fix_commission_box',
            esc_attr( $rtwalwm_is_perc ? __( 'Percentage', 'affiliaa-affiliate-program-with-mlm' ) : __( 'Fixed', 'affiliaa-affiliate-program-with-mlm' ) ),
            esc_attr( $rtwalwm_value ),
            absint( $rtwalwm_post_id )
        );
        return $rtwalwm_column;
    }

    /**
     * This function is for changing the product commission
     */
    function rtwalwm_change_prod_commission_callback()
    {
        check_ajax_referer( 'rtwalwm-admin-ajax-string', 'rtwalwm_security_check' );

        $rtwalwm_post_id = isset( $_POST['rtwalwm_post_id'] ) ? absint( wp_unslash( $_POST['rtwalwm_post_id'] ) ) : 0;
        $rtwalwm_type    = isset( $_POST['rtwalwm_type'] ) ? sanitize_key( wp_unslash( $_POST['rtwalwm_type'] ) ) : '';
        $rtwalwm_raw     = isset( $_POST['rtwalwm_value'] ) ? sanitize_text_field( wp_unslash( $_POST['rtwalwm_value'] ) ) : '';

        // Store capability plus permission to edit this specific product.
        if ( ! Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_can_manage() || ! $rtwalwm_post_id || ! current_user_can( 'edit_post', $rtwalwm_post_id ) ) {
            echo wp_json_encode( array( 'rtwalwm_status' => false, 'rtwalwm_message' => esc_html__( 'You are not allowed to change the commission for this product.', 'affiliaa-affiliate-program-with-mlm' ) ) );
            wp_die( '', '', 403 );
        }
        if ( RTWALWM_IS_WOO != 1 || 'product' !== get_post_type( $rtwalwm_post_id ) ) {
            echo wp_json_encode( array( 'rtwalwm_status' => false, 'rtwalwm_message' => esc_html__( 'Commission rates can only be set on WooCommerce products.', 'affiliaa-affiliate-program-with-mlm' ) ) );
            wp_die();
        }
        if ( ! in_array( $rtwalwm_type, array( 'perc_comm', 'fix_comm' ), true ) ) {
            echo wp_json_encode( array( 'rtwalwm_status' => false, 'rtwalwm_message' => esc_html__( 'Unknown commission type.', 'affiliaa-affiliate-program-with-mlm' ) ) );
            wp_die();
        }

        $rtwalwm_is_perc = ( 'perc_comm' === $rtwalwm_type );
        $rtwalwm_value   = Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_decimal_or_empty( $rtwalwm_raw, $rtwalwm_is_perc ? 100 : 1000000 );
        if ( null === $rtwalwm_value ) {
            $rtwalwm_message = $rtwalwm_is_perc ? esc_html__( 'Enter a percentage between 0 and 100, or leave it empty to use the global rate.', 'affiliaa-affiliate-program-with-mlm' ) : esc_html__( 'Enter an amount of 0 or more, or leave it empty to use the global rate.', 'affiliaa-affiliate-program-with-mlm' );
            echo wp_json_encode( array( 'rtwalwm_status' => false, 'rtwalwm_message' => $rtwalwm_message ) );
            wp_die();
        }

        $rtwalwm_meta_key = $rtwalwm_is_perc ? 'rtwalwm_percentage_commission_box' : 'rtwalwm_fixed_commission_box';
        if ( '' === $rtwalwm_value ) {
            delete_post_meta( $rtwalwm_post_id, $rtwalwm_meta_key );
        }
        else {
            update_post_meta( $rtwalwm_post_id, $rtwalwm_meta_key, $rtwalwm_value );
        }

        echo wp_json_encode( array( 'rtwalwm_status' => true, 'rtwalwm_message' => esc_html__( 'Commission for this product is updated', 'affiliaa-affiliate-program-with-mlm' ) ) );
        wp_die();
    }

    /*
    * This function is for creating a commission meta box in single product page
    */
    
    function rtwalwm_add_custom_meta_box(){
        if ( RTWALWM_IS_WOO != 1 || ! Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_can_manage() ) {
            return;
        }
        $rtwalwm_commission_settings    = get_option( 'rtwwwap_commission_settings_opt' );
        $rtwalwm_comm_base              = ( is_array( $rtwalwm_commission_settings ) && isset( $rtwalwm_commission_settings[ 'comm_base' ] ) ) ? $rtwalwm_commission_settings[ 'comm_base' ] : '1';
        if( $rtwalwm_comm_base == 1 ){
            add_meta_box( 'rtwalwm_product_custom_meta_box', esc_html__( 'Add Commission', 'affiliaa-affiliate-program-with-mlm' ), array( $this, 'rtwalwm_product_custom_meta_box_show' ), 'product' );
        }
    }


    /*
    * This function is for displaying the meta box
    */
    function rtwalwm_product_custom_meta_box_show( $rtwalwm_post ){
    
        $rtwalwm_fix_comm   = get_post_meta( $rtwalwm_post->ID, 'rtwalwm_fixed_commission_box', true );

        $rtwalwm_commission_settings = get_option( 'rtwwwap_commission_settings_opt' );
        $rtwalwm_commission_settings = isset( $rtwalwm_commission_settings[ 'per_prod_mode' ] ) ? $rtwalwm_commission_settings[ 'per_prod_mode' ] : 0;

        // We'll use this nonce field later on when saving.
        wp_nonce_field( 'rtwalwm_commission_nonce', 'rtwalwm_meta_box_nonce' );
        if( $rtwalwm_commission_settings == 2 ){
        ?>
        <p>
            <label for="rtwalwm_fixed_commission_box"><?php esc_html_e( 'Fixed Commission', 'affiliaa-affiliate-program-with-mlm' ); ?></label>
            <input type="number" min="0" name="rtwalwm_fixed_commission_box" id="rtwalwm_fixed_commission_box" value="<?php echo esc_attr( $rtwalwm_fix_comm ); ?>" />
        </p>
        <?php
        }
    }


    /*
    * Function to save meta box
    */
    function rtwalwm_save_custom_meta_box( $rtwalwm_post_id, $rtwalwm_post, $rtwalwm_update ) {
        if( !isset( $_POST[ 'rtwalwm_meta_box_nonce' ] ) || !wp_verify_nonce( sanitize_text_field( wp_unslash($_POST[ 'rtwalwm_meta_box_nonce' ]) ), 'rtwalwm_commission_nonce' ) )
        {
            return;
        }
        if ( ( defined( 'DOING_AUTOSAVE' ) && DOING_AUTOSAVE ) || ! Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_can_manage() || ! current_user_can( 'edit_post', $rtwalwm_post_id ) ) {
            return;
        }
        if( isset( $_POST[ 'rtwalwm_fixed_commission_box' ] ) ){
            $rtwalwm_value = Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_decimal_or_empty( sanitize_text_field( wp_unslash( $_POST[ 'rtwalwm_fixed_commission_box' ] ) ) );
            if ( '' === $rtwalwm_value ) {
                delete_post_meta( $rtwalwm_post_id, 'rtwalwm_fixed_commission_box' );
            }
            elseif ( null !== $rtwalwm_value ) {
                update_post_meta( $rtwalwm_post_id, 'rtwalwm_fixed_commission_box', $rtwalwm_value );
            }
        }
    }


    /**
     * Referral IDs posted by the Referrals screen.
     *
     * @return int[]
     */
    private function rtwalwm_posted_referral_ids() {
        $rtwalwm_raw = isset( $_POST[ 'rtwalwm_referral_ids' ] ) ? sanitize_text_field( wp_unslash( $_POST[ 'rtwalwm_referral_ids' ] ) ) : '';
        $rtwalwm_ids = json_decode( stripslashes( $rtwalwm_raw ), true );
        if ( ! is_array( $rtwalwm_ids ) ) {
            return array();
        }
        return array_values( array_unique( array_filter( array_map( 'absint', $rtwalwm_ids ) ) ) );
    }

    /**
     * A database read needed for an approval failed. Nothing was changed.
     *
     * @param int $rtwalwm_id Referral ID.
     * @return WP_Error
     */
    private function rtwalwm_read_error( $rtwalwm_id ) {
        /* translators: %d: referral ID. */
        return new WP_Error( 'rtwalwm_read_failed', sprintf( __( 'Referral #%d was not approved: a record needed to check it could not be read (database error). Nothing was changed; try again.', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_id ) );
    }

    /**
     * Approve one referral. For rows with an order, the whole check-and-approve runs under the order's lock (the same
     * lock checkout retries take), the row is re-read inside it, and the amount read there is the amount credited.
     *
     * @param int $rtwalwm_id Referral ID.
     * @return true|WP_Error
     */
    public function rtwalwm_approve_referral( $rtwalwm_id ) {
        global $wpdb;
        $rtwalwm_table = $wpdb->prefix . 'rtwwwap_referrals';
        $rtwalwm_order_id = $wpdb->get_var( $wpdb->prepare( "SELECT `order_id` FROM `{$rtwalwm_table}` WHERE `id` = %d", $rtwalwm_id ) );
        if ( '' !== $wpdb->last_error ) {
            return $this->rtwalwm_read_error( $rtwalwm_id );
        }
        if ( null === $rtwalwm_order_id ) {
            /* translators: %d: referral ID. */
            return new WP_Error( 'rtwalwm_missing', sprintf( __( 'Referral #%d was not found.', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_id ) );
        }
        $rtwalwm_order_id = absint( $rtwalwm_order_id );
        $rtwalwm_lock     = $rtwalwm_order_id ? 'order_' . $rtwalwm_order_id : '';
        if ( $rtwalwm_lock && ! Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_acquire_lock( $rtwalwm_lock, 60 ) ) {
            /* translators: %d: order ID. */
            return new WP_Error( 'rtwalwm_busy', sprintf( __( 'Order #%d is being updated by another request. Try again.', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_order_id ) );
        }
        try {
            $rtwalwm_row = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM `{$rtwalwm_table}` WHERE `id` = %d", $rtwalwm_id ), ARRAY_A );
            if ( '' !== $wpdb->last_error ) {
                return $this->rtwalwm_read_error( $rtwalwm_id );
            }
            if ( ! $rtwalwm_row ) {
                /* translators: %d: referral ID. */
                return new WP_Error( 'rtwalwm_missing', sprintf( __( 'Referral #%d was not found.', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_id ) );
            }
            return $this->rtwalwm_validate_and_approve( $rtwalwm_row, $rtwalwm_lock );
        } finally {
            if ( $rtwalwm_lock ) {
                Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_release_lock( $rtwalwm_lock );
            }
        }
    }

    /**
     * Approval rules for one row read inside the order lock: pending only; an active affiliate who is not the buyer
     * (re-checked here because historical rows were recorded without these checks); no self-approval by
     * non-administrators; order checks and refund recalculation; one approved commission per order (per parent for
     * MLM); then an atomic status change and a single wallet credit of exactly this amount.
     *
     * @param array  $rtwalwm_row  Referral row.
     * @param string $rtwalwm_lock Name of the order lock held, or ''.
     * @return true|WP_Error
     */
    private function rtwalwm_validate_and_approve( $rtwalwm_row, $rtwalwm_lock ) {
        global $wpdb;
        $rtwalwm_id     = (int) $rtwalwm_row['id'];
        $rtwalwm_status = (int) $rtwalwm_row['status'];
        if ( 0 !== $rtwalwm_status ) {
            $rtwalwm_labels = array( 1 => __( 'already approved', 'affiliaa-affiliate-program-with-mlm' ), 2 => __( 'already paid', 'affiliaa-affiliate-program-with-mlm' ), 3 => __( 'rejected', 'affiliaa-affiliate-program-with-mlm' ) );
            $rtwalwm_label  = isset( $rtwalwm_labels[ $rtwalwm_status ] ) ? $rtwalwm_labels[ $rtwalwm_status ] : __( 'not pending', 'affiliaa-affiliate-program-with-mlm' );
            /* translators: 1: referral ID, 2: status label. */
            return new WP_Error( 'rtwalwm_not_pending', sprintf( __( 'Referral #%1$d is %2$s, so it was not approved (the wallet was not changed).', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_id, $rtwalwm_label ) );
        }

        $rtwalwm_aff_id = absint( $rtwalwm_row['aff_id'] );
        if ( ! $rtwalwm_aff_id || ! get_userdata( $rtwalwm_aff_id ) ) {
            /* translators: %d: referral ID. */
            return new WP_Error( 'rtwalwm_no_affiliate', sprintf( __( 'Referral #%d has no valid affiliate and cannot be approved.', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_id ) );
        }
        if ( ! Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_is_active_affiliate( $rtwalwm_aff_id ) ) {
            /* translators: 1: referral ID, 2: user ID. */
            return new WP_Error( 'rtwalwm_inactive_affiliate', sprintf( __( 'Referral #%1$d belongs to user #%2$d, who is not an approved affiliate, so it was not approved. Reject it if it should not be paid.', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_id, $rtwalwm_aff_id ) );
        }
        if ( ! current_user_can( 'manage_options' ) && get_current_user_id() === $rtwalwm_aff_id ) {
            /* translators: %d: referral ID. */
            return new WP_Error( 'rtwalwm_self_approval', sprintf( __( 'Referral #%d is your own commission. Ask an administrator to review it.', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_id ) );
        }

        $rtwalwm_type     = (int) $rtwalwm_row['type'];
        $rtwalwm_order_id = absint( $rtwalwm_row['order_id'] );
        // MLM rows created before 3.3.6 have no order reference; they are approved as before, without order checks.
        if ( 0 === $rtwalwm_type || $rtwalwm_order_id ) {
            $rtwalwm_check = $this->rtwalwm_check_order_for_approval( $rtwalwm_row );
            if ( is_wp_error( $rtwalwm_check ) ) {
                return $rtwalwm_check;
            }
        }

        if ( $rtwalwm_order_id ) {
            // Earlier versions could record the same order twice. Those records are kept, but only one direct
            // commission per order (and one MLM commission per parent and order) can be approved.
            if ( 4 === $rtwalwm_type ) {
                $rtwalwm_other = $wpdb->get_var( $wpdb->prepare( "SELECT `id` FROM `{$wpdb->prefix}rtwwwap_referrals` WHERE `order_id` = %d AND `type` = 4 AND `aff_id` = %d AND `id` != %d AND `status` IN ( 1, 2 ) LIMIT 1", $rtwalwm_order_id, $rtwalwm_aff_id, $rtwalwm_id ) );
            } else {
                $rtwalwm_other = $wpdb->get_var( $wpdb->prepare( "SELECT `id` FROM `{$wpdb->prefix}rtwwwap_referrals` WHERE `order_id` = %d AND `type` = %d AND `id` != %d AND `status` IN ( 1, 2 ) LIMIT 1", $rtwalwm_order_id, $rtwalwm_type, $rtwalwm_id ) );
            }
            if ( '' !== $wpdb->last_error ) {
                // A failed lookup is never read as "no other approved commission".
                return $this->rtwalwm_read_error( $rtwalwm_id );
            }
            if ( $rtwalwm_other ) {
                /* translators: 1: order ID, 2: approved referral ID, 3: referral ID. */
                return new WP_Error( 'rtwalwm_duplicate', sprintf( __( 'Order #%1$d already has an approved commission of this kind (#%2$d), so referral #%3$d was not approved. Reject it if it is a duplicate.', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_order_id, $rtwalwm_other, $rtwalwm_id ) );
            }
        }

        return Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_approve_and_credit( $rtwalwm_id, $rtwalwm_aff_id, (float) $rtwalwm_row['amount'], $rtwalwm_lock ? array( $rtwalwm_lock ) : array() );
    }

    /**
     * Order checks before approval (caller holds the order lock). Refunds are evaluated against the terms captured at
     * purchase: a lower entitlement reduces the pending amount and asks for a fresh review; data that can't support
     * an unambiguous calculation blocks approval instead of guessing.
     *
     * @param array $rtwalwm_row Referral row.
     * @return true|WP_Error
     */
    private function rtwalwm_check_order_for_approval( $rtwalwm_row ) {
        global $wpdb;
        $rtwalwm_table    = $wpdb->prefix . 'rtwwwap_referrals';
        $rtwalwm_id       = (int) $rtwalwm_row['id'];
        $rtwalwm_type     = (int) $rtwalwm_row['type'];
        $rtwalwm_aff_id   = absint( $rtwalwm_row['aff_id'] );
        $rtwalwm_order_id = absint( $rtwalwm_row['order_id'] );
        if ( ! $rtwalwm_order_id ) {
            /* translators: %d: referral ID. */
            return new WP_Error( 'rtwalwm_no_order', sprintf( __( 'Referral #%d has no order reference, so it cannot be validated for approval.', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_id ) );
        }
        if ( ! function_exists( 'wc_get_order' ) ) {
            /* translators: %d: order ID. */
            return new WP_Error( 'rtwalwm_no_wc', sprintf( __( 'WooCommerce is not active, so order #%d cannot be validated.', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_order_id ) );
        }
        $rtwalwm_order = wc_get_order( $rtwalwm_order_id );
        if ( ! $rtwalwm_order || is_a( $rtwalwm_order, 'WC_Order_Refund' ) ) {
            /* translators: %d: order ID. */
            return new WP_Error( 'rtwalwm_order_missing', sprintf( __( 'Order #%d was not found.', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_order_id ) );
        }
        if ( Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_is_self_referral( $rtwalwm_aff_id, $rtwalwm_order, false ) ) {
            /* translators: 1: referral ID, 2: order ID. */
            return new WP_Error( 'rtwalwm_self_referral', sprintf( __( 'Referral #%1$d is a self-referral: the affiliate is the customer or billing contact of order #%2$d. It was not approved.', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_id, $rtwalwm_order_id ) );
        }
        $rtwalwm_order_status = $rtwalwm_order->get_status();
        if ( ! in_array( $rtwalwm_order_status, Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_approvable_statuses(), true ) ) {
            /* translators: 1: order ID, 2: order status. */
            return new WP_Error( 'rtwalwm_order_status', sprintf( __( 'Order #%1$d is "%2$s"; only processing or completed orders qualify for approval.', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_order_id, wc_get_order_status_name( $rtwalwm_order_status ) ) );
        }

        $rtwalwm_direct = null;
        if ( 4 === $rtwalwm_type ) {
            // An MLM award derives from the order's direct commission, which must exist and not be rejected.
            $rtwalwm_direct = $wpdb->get_row( $wpdb->prepare( "SELECT `id`, `status`, `amount`, `product_details` FROM `{$rtwalwm_table}` WHERE `order_id` = %d AND `type` = 0 AND `status` IN ( 0, 1, 2 ) ORDER BY ( `status` IN ( 1, 2 ) ) DESC, `id` ASC LIMIT 1", $rtwalwm_order_id ), ARRAY_A );
            if ( '' !== $wpdb->last_error ) {
                return $this->rtwalwm_read_error( $rtwalwm_id );
            }
            if ( ! $rtwalwm_direct ) {
                /* translators: 1: referral ID, 2: order ID. */
                return new WP_Error( 'rtwalwm_no_direct', sprintf( __( 'MLM award #%1$d has no valid direct commission for order #%2$d (it is missing or rejected), so it was not approved.', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_id, $rtwalwm_order_id ) );
            }
        }

        $rtwalwm_refunded = (float) $rtwalwm_order->get_total_refunded() > 0;
        if ( ! $rtwalwm_refunded && 4 !== $rtwalwm_type ) {
            return true;
        }
        if ( $rtwalwm_refunded ) {
            $rtwalwm_unallocated = Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_unallocated_refund( $rtwalwm_order );
            if ( $rtwalwm_unallocated > 0 ) {
                /* translators: 1: order ID, 2: amount. */
                return new WP_Error( 'rtwalwm_refund_unallocated', sprintf( __( 'Order #%1$d has a refund of %2$s that is not allocated to items, so the commission cannot be recalculated. Review it manually.', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_order_id, number_format( $rtwalwm_unallocated, 2, '.', '' ) ) );
            }
        }
        $rtwalwm_terms_error = sprintf(
            /* translators: 1: referral ID, 2: order ID. */
            __( 'Referral #%1$d was recorded without the per-line terms needed to recalculate it after the refund on order #%2$d, so it was not approved. Review it manually.', 'affiliaa-affiliate-program-with-mlm' ),
            $rtwalwm_id,
            $rtwalwm_order_id
        );

        $rtwalwm_stored = round( (float) $rtwalwm_row['amount'], 2 );
        if ( 0 === $rtwalwm_type ) {
            $rtwalwm_entitled = Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_commission_entitlement( $rtwalwm_order, $rtwalwm_row['product_details'] );
            if ( is_wp_error( $rtwalwm_entitled ) ) {
                return new WP_Error( 'rtwalwm_terms_missing', $rtwalwm_terms_error );
            }
            if ( $rtwalwm_entitled >= $rtwalwm_stored - 0.005 ) {
                return true;
            }
        } else {
            // An MLM award must match its captured terms and the eligible direct commission (net of refunds) before
            // it is approved, so an award left stale by a failed earlier update is corrected first.
            $rtwalwm_terms = Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_parse_mlm_terms( $rtwalwm_row['product_details'] );
            if ( ! $rtwalwm_terms ) {
                // Awards recorded without terms (earlier versions, PRO) are approved as before unless the order was refunded.
                return $rtwalwm_refunded ? new WP_Error( 'rtwalwm_terms_missing', $rtwalwm_terms_error ) : true;
            }
            $rtwalwm_base = $rtwalwm_refunded ? Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_commission_entitlement( $rtwalwm_order, $rtwalwm_direct['product_details'] ) : round( (float) $rtwalwm_direct['amount'], 2 );
            if ( is_wp_error( $rtwalwm_base ) ) {
                return new WP_Error( 'rtwalwm_terms_missing', $rtwalwm_terms_error );
            }
            if ( '0' === $rtwalwm_terms['type'] ) {
                $rtwalwm_entitled = round( $rtwalwm_base * $rtwalwm_terms['rate'] / 100, 2 );
            } else {
                // A fixed award stays while the order still carries a direct commission.
                $rtwalwm_entitled = ( $rtwalwm_base > 0 ) ? $rtwalwm_stored : 0.0;
            }
            if ( abs( $rtwalwm_entitled - $rtwalwm_stored ) < 0.005 ) {
                return true;
            }
            // A refund lowering the entitlement is handled below as a refund adjustment; any other mismatch is a
            // stale award (for example a failed earlier update) and is brought in line with its terms.
            if ( ! ( $rtwalwm_refunded && $rtwalwm_entitled < $rtwalwm_stored ) ) {
                $rtwalwm_new  = number_format( $rtwalwm_entitled, 2, '.', '' );
                $rtwalwm_note = substr( sprintf( 'Brought in line with the direct commission: %1$s -> %2$s (%3$s UTC)', number_format( $rtwalwm_stored, 2, '.', '' ), $rtwalwm_new, gmdate( 'Y-m-d H:i' ) ), 0, 150 );
                $rtwalwm_done = $wpdb->query( $wpdb->prepare( "UPDATE `{$rtwalwm_table}` SET `amount` = %s, `message` = %s WHERE `id` = %d AND `status` = 0 AND `amount` = %s", $rtwalwm_new, $rtwalwm_note, $rtwalwm_id, number_format( $rtwalwm_stored, 2, '.', '' ) ) );
                if ( 1 !== $rtwalwm_done ) {
                    /* translators: %d: referral ID. */
                    return new WP_Error( 'rtwalwm_update_failed', sprintf( __( 'MLM award #%d does not match its captured terms and could not be corrected, so it was not approved. Nothing was credited; try again.', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_id ) );
                }
                /* translators: 1: referral ID, 2: old amount, 3: new amount. */
                return new WP_Error( 'rtwalwm_mlm_resynced', sprintf( __( 'MLM award #%1$d was brought in line with its captured terms and the direct commission (%2$s -> %3$s). Review it and approve again.', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_id, number_format( $rtwalwm_stored, 2, '.', '' ), $rtwalwm_new ) );
            }
        }

        $rtwalwm_new  = number_format( $rtwalwm_entitled, 2, '.', '' );
        $rtwalwm_note = substr( sprintf( 'Adjusted for partial refund: %1$s -> %2$s (%3$s UTC)', number_format( $rtwalwm_stored, 2, '.', '' ), $rtwalwm_new, gmdate( 'Y-m-d H:i' ) ), 0, 150 );
        // Only the amount changes; the captured basis in product_details is kept for later checks.
        $rtwalwm_done = $wpdb->query( $wpdb->prepare( "UPDATE `{$rtwalwm_table}` SET `amount` = %s, `message` = %s WHERE `id` = %d AND `status` = 0 AND `amount` = %s", $rtwalwm_new, $rtwalwm_note, $rtwalwm_id, number_format( $rtwalwm_stored, 2, '.', '' ) ) );
        if ( 1 !== $rtwalwm_done ) {
            /* translators: %d: referral ID. */
            return new WP_Error( 'rtwalwm_update_failed', sprintf( __( 'Referral #%d needs to be reduced for a refund but could not be updated, so it was not approved. Nothing was credited; try again.', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_id ) );
        }
        if ( 0 === $rtwalwm_type ) {
            $rtwalwm_sync = Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_sync_mlm_awards( $rtwalwm_order_id, $rtwalwm_entitled, 'Recalculated with the refunded direct commission' );
            if ( is_wp_error( $rtwalwm_sync ) ) {
                /* translators: 1: order ID, 2: referral ID, 3: old amount, 4: new amount, 5: error. */
                return new WP_Error( 'rtwalwm_adjusted', sprintf( __( 'Order #%1$d was partially refunded, so referral #%2$d was reduced from %3$s to %4$s, but %5$s; they are checked again before approval. Review it and approve again.', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_order_id, $rtwalwm_id, number_format( $rtwalwm_stored, 2, '.', '' ), $rtwalwm_new, $rtwalwm_sync->get_error_message() ) );
            }
        }
        /* translators: 1: order ID, 2: referral ID, 3: old amount, 4: new amount. */
        return new WP_Error( 'rtwalwm_adjusted', sprintf( __( 'Order #%1$d was partially refunded, so referral #%2$d was reduced from %3$s to %4$s. Review it and approve again.', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_order_id, $rtwalwm_id, number_format( $rtwalwm_stored, 2, '.', '' ), $rtwalwm_new ) );
    }

    function rtwalwm_approve_callback()
    {
        check_ajax_referer( 'rtwalwm-admin-ajax-string', 'rtwalwm_security_check' );
        if ( ! Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_can_manage() ) {
            wp_send_json_error( array( 'message' => esc_html__( 'Unauthorized action. You do not have permission to manage affiliates.', 'affiliaa-affiliate-program-with-mlm' ) ), 403 );
        }

        $rtwalwm_ids      = $this->rtwalwm_posted_referral_ids();
        $rtwalwm_approved = array();
        $rtwalwm_errors   = array();
        foreach ( $rtwalwm_ids as $rtwalwm_id ) {
            $rtwalwm_result = $this->rtwalwm_approve_referral( $rtwalwm_id );
            if ( true === $rtwalwm_result ) {
                $rtwalwm_approved[] = $rtwalwm_id;
            }
            else {
                $rtwalwm_errors[] = $rtwalwm_result->get_error_message();
            }
        }

        $rtwalwm_status = ! empty( $rtwalwm_ids ) && count( $rtwalwm_approved ) === count( $rtwalwm_ids );
        if ( $rtwalwm_status ) {
            $rtwalwm_message = esc_html__( 'Approved', 'affiliaa-affiliate-program-with-mlm' );
        }
        elseif ( empty( $rtwalwm_ids ) ) {
            $rtwalwm_message = esc_html__( 'Nothing to approve.', 'affiliaa-affiliate-program-with-mlm' );
        }
        else {
            /* translators: 1: approved count, 2: requested count. */
            $rtwalwm_message = sprintf( __( 'Approved %1$d of %2$d.', 'affiliaa-affiliate-program-with-mlm' ), count( $rtwalwm_approved ), count( $rtwalwm_ids ) ) . ' ' . implode( ' ', $rtwalwm_errors );
        }
        echo wp_json_encode( array( 'rtwalwm_status' => $rtwalwm_status, 'rtwalwm_message' => wp_strip_all_tags( $rtwalwm_message ), 'rtwalwm_approved_ids' => $rtwalwm_approved ) );
        wp_die();
    }

    function rtwalwm_reject_callback()
    {
        check_ajax_referer( 'rtwalwm-admin-ajax-string', 'rtwalwm_security_check' );
        if ( ! Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_can_manage() ) {
            wp_send_json_error( array( 'message' => esc_html__( 'Unauthorized action. You do not have permission to manage affiliates.', 'affiliaa-affiliate-program-with-mlm' ) ), 403 );
        }

        global $wpdb;
        $rtwalwm_table    = $wpdb->prefix . 'rtwwwap_referrals';
        $rtwalwm_ids      = $this->rtwalwm_posted_referral_ids();
        $rtwalwm_rejected = array();
        $rtwalwm_errors   = array();

        foreach ( $rtwalwm_ids as $rtwalwm_id ) {
            $rtwalwm_current = $wpdb->get_var( $wpdb->prepare( "SELECT `status` FROM `{$rtwalwm_table}` WHERE `id` = %d", $rtwalwm_id ) );
            if ( null === $rtwalwm_current ) {
                /* translators: %d: referral ID. */
                $rtwalwm_errors[] = sprintf( __( 'Referral #%d was not found.', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_id );
                continue;
            }
            if ( 3 === (int) $rtwalwm_current ) {
                $rtwalwm_rejected[] = $rtwalwm_id;
                continue;
            }
            if ( 0 !== (int) $rtwalwm_current ) {
                /* translators: %d: referral ID. */
                $rtwalwm_errors[] = sprintf( __( 'Referral #%d is already approved or paid and its amount is in the wallet, so rejecting it is blocked. Reconcile the wallet separately.', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_id );
                continue;
            }
            if ( 1 === $wpdb->query( $wpdb->prepare( "UPDATE `{$rtwalwm_table}` SET `status` = 3 WHERE `id` = %d AND `status` = 0", $rtwalwm_id ) ) ) {
                $rtwalwm_rejected[] = $rtwalwm_id;
            }
            else {
                /* translators: %d: referral ID. */
                $rtwalwm_errors[] = sprintf( __( 'Referral #%d changed while it was being rejected. Reload and try again.', 'affiliaa-affiliate-program-with-mlm' ), $rtwalwm_id );
            }
        }

        $rtwalwm_status  = ! empty( $rtwalwm_ids ) && count( $rtwalwm_rejected ) === count( $rtwalwm_ids );
        $rtwalwm_message = $rtwalwm_status ? __( 'Rejected', 'affiliaa-affiliate-program-with-mlm' ) : ( empty( $rtwalwm_ids ) ? __( 'Nothing to reject.', 'affiliaa-affiliate-program-with-mlm' ) : implode( ' ', $rtwalwm_errors ) );
        echo wp_json_encode( array( 'rtwalwm_status' => $rtwalwm_status, 'rtwalwm_message' => wp_strip_all_tags( $rtwalwm_message ), 'rtwalwm_rejected_ids' => $rtwalwm_rejected ) );
        wp_die();
    }

    function rtwalwm_aff_approve_callback()
    {
        $rtwalwm_check_ajax = check_ajax_referer( 'rtwalwm-admin-ajax-string', 'rtwalwm_security_check' );

        if ( $rtwalwm_check_ajax ) {

            if ( ! ( current_user_can( 'manage_options' ) || current_user_can( 'manage_woocommerce' ) ) ) {
                wp_send_json_error( array( 'message' => 'Unauthorized action. You do not have permission to manage affiliates.' ), 403 );
                wp_die();
            }

            $rtwalwm_reff_ids       =  isset($_POST[ 'rtwalwm_referral_ids' ]) ? sanitize_text_field(wp_unslash($_POST[ 'rtwalwm_referral_ids' ])): "";
            $rtwalwm_reff_ids = json_decode(stripslashes($rtwalwm_reff_ids),true);
            $rtwalwm_approved_ids   = array();


            if( sizeof( $rtwalwm_reff_ids ) == sizeof( $rtwalwm_approved_ids ) ){
                $rtwalwm_message = esc_html__( 'Approved', 'affiliaa-affiliate-program-with-mlm' );
            }
            else{
                $rtwalwm_message = esc_html__( 'Something went wrong. Try again', 'affiliaa-affiliate-program-with-mlm' );
            }

            echo wp_json_encode( array( 'rtwalwm_status' => true, 'rtwalwm_message' => $rtwalwm_message, 'rtwalwm_approved_ids' => $rtwalwm_approved_ids ) );
            wp_die();
        }
    }

    /**
     * This function is for delete referrals
     */
    function rtwalwm_referral_delete_callback()
    {
        check_ajax_referer( 'rtwalwm-admin-ajax-string', 'rtwalwm_security_check' );
        if ( ! Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_can_manage() ) {
            wp_send_json_error( array( 'message' => esc_html__( 'Unauthorized action. You do not have permission to manage affiliates.', 'affiliaa-affiliate-program-with-mlm' ) ), 403 );
        }

        global $wpdb;
        $rtwalwm_table       = $wpdb->prefix . 'rtwwwap_referrals';
        $rtwalwm_referral_id = isset( $_POST[ 'rtwalwm_referral_id' ] ) ? absint( wp_unslash( $_POST[ 'rtwalwm_referral_id' ] ) ) : 0;
        $rtwalwm_current     = $rtwalwm_referral_id ? $wpdb->get_var( $wpdb->prepare( "SELECT `status` FROM `{$rtwalwm_table}` WHERE `id` = %d", $rtwalwm_referral_id ) ) : null;

        if ( null === $rtwalwm_current ) {
            $rtwalwm_status  = false;
            $rtwalwm_message = __( 'Referral not found.', 'affiliaa-affiliate-program-with-mlm' );
        }
        elseif ( in_array( (int) $rtwalwm_current, array( 1, 2 ), true ) ) {
            $rtwalwm_status  = false;
            $rtwalwm_message = __( 'This commission is already approved or paid and its amount is in the wallet, so deleting it is blocked. Reconcile the wallet separately.', 'affiliaa-affiliate-program-with-mlm' );
        }
        else {
            $rtwalwm_deleted = $wpdb->query( $wpdb->prepare( "DELETE FROM `{$rtwalwm_table}` WHERE `id` = %d AND `status` IN ( 0, 3 )", $rtwalwm_referral_id ) );
            $rtwalwm_status  = ( 1 === $rtwalwm_deleted );
            $rtwalwm_message = $rtwalwm_status ? __( 'Deleted', 'affiliaa-affiliate-program-with-mlm' ) : __( 'Something went wrong. Try again', 'affiliaa-affiliate-program-with-mlm' );
        }

        echo wp_json_encode( array( 'rtwalwm_status' => $rtwalwm_status, 'rtwalwm_message' => wp_strip_all_tags( $rtwalwm_message ) ) );
        wp_die();
    }

    // update detail into custom banner option

    function rtwalwm_custom_banner_callback()
    {
        check_ajax_referer( 'rtwalwm-admin-ajax-string', 'rtwalwm_security_check' );
        if ( ! Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_can_manage() ) {
            wp_send_json_error( array( 'message' => esc_html__( 'Unauthorized action. You do not have permission to manage affiliates.', 'affiliaa-affiliate-program-with-mlm' ) ), 403 );
        }

        $rtwalwm_image_id = isset( $_POST[ 'rtwalwm_image_id' ] ) ? absint( wp_unslash( $_POST[ 'rtwalwm_image_id' ] ) ) : 0;
        $rtwalwm_width    = isset( $_POST[ 'rtwalwm_image_dimention_width' ] ) ? sanitize_text_field( wp_unslash( $_POST[ 'rtwalwm_image_dimention_width' ] ) ) : '';
        $rtwalwm_height   = isset( $_POST[ 'rtwalwm_image_dimention_height' ] ) ? sanitize_text_field( wp_unslash( $_POST[ 'rtwalwm_image_dimention_height' ] ) ) : '';

        // Dimensions must be whole pixel values; anything else is rejected rather than stored.
        $rtwalwm_valid = $rtwalwm_image_id && wp_attachment_is_image( $rtwalwm_image_id )
            && ctype_digit( $rtwalwm_width ) && ctype_digit( $rtwalwm_height )
            && (int) $rtwalwm_width >= 1 && (int) $rtwalwm_width <= 5000 && (int) $rtwalwm_height >= 1 && (int) $rtwalwm_height <= 5000;
        if ( ! $rtwalwm_valid ) {
            echo wp_json_encode( array( 'rtwalwm_status' => false, 'rtwalwm_message' => esc_html__( 'Select an image and enter its width and height in whole pixels (1-5000).', 'affiliaa-affiliate-program-with-mlm' ) ) );
            wp_die();
        }

        $rtwalwm_banners   = get_option( 'rtwwwap_custom_banner_opt' );
        $rtwalwm_banners   = is_array( $rtwalwm_banners ) ? $rtwalwm_banners : array();
        $rtwalwm_banners[] = array( 'image_id' => $rtwalwm_image_id, 'target_link' => site_url(), 'image_width' => (int) $rtwalwm_width, 'image_height' => (int) $rtwalwm_height );
        $rtwalwm_updated   = update_option( 'rtwwwap_custom_banner_opt', $rtwalwm_banners );

        echo wp_json_encode( array( 'rtwalwm_status' => (bool) $rtwalwm_updated, 'rtwalwm_message' => $rtwalwm_updated ? esc_html__( 'Successfully Uploaded', 'affiliaa-affiliate-program-with-mlm' ) : esc_html__( 'Failed to upload', 'affiliaa-affiliate-program-with-mlm' ) ) );
        wp_die();
    }

    // Delete custom banner 

    function rtwalwm_delete_banner_callback()
    {
        check_ajax_referer( 'rtwalwm-admin-ajax-string', 'rtwalwm_security_check' );
        if ( ! Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_can_manage() ) {
            wp_send_json_error( array( 'message' => esc_html__( 'Unauthorized action. You do not have permission to manage affiliates.', 'affiliaa-affiliate-program-with-mlm' ) ), 403 );
        }

        $rtwalwm_image_id    = isset( $_POST[ 'rtwalwm_image_id' ] ) ? absint( wp_unslash( $_POST[ 'rtwalwm_image_id' ] ) ) : 0;
        $rtwalwm_target_link = isset( $_POST[ 'rtwalwm_target_link' ] ) ? esc_url_raw( wp_unslash( $_POST[ 'rtwalwm_target_link' ] ) ) : '';
        $rtwalwm_banners     = get_option( 'rtwwwap_custom_banner_opt' );
        $rtwalwm_updated     = false;

        if ( is_array( $rtwalwm_banners ) ) {
            foreach ( $rtwalwm_banners as $rtwalwm_key => $rtwalwm_value ) {
                if ( isset( $rtwalwm_value['image_id'], $rtwalwm_value['target_link'] ) && absint( $rtwalwm_value['image_id'] ) === $rtwalwm_image_id && esc_url_raw( $rtwalwm_value['target_link'] ) === $rtwalwm_target_link ) {
                    unset( $rtwalwm_banners[ $rtwalwm_key ] );
                    $rtwalwm_updated = update_option( 'rtwwwap_custom_banner_opt', array_values( $rtwalwm_banners ) );
                    break;
                }
            }
        }

        echo wp_json_encode( array( 'rtwalwm_status' => (bool) $rtwalwm_updated, 'rtwalwm_message' => $rtwalwm_updated ? esc_html__( 'Deleted', 'affiliaa-affiliate-program-with-mlm' ) : esc_html__( 'Not Deleted', 'affiliaa-affiliate-program-with-mlm' ) ) );
        wp_die();
    }

    function rtwalwm_add_coupon_text_field_callback()
    {
        global $post;
        $rtwalwm_affiliates = get_users( array(
            'meta_key'   => 'rtwwwap_affiliate',
            'meta_value' => '1',
            'number'     => 500,
            'fields'     => array( 'ID', 'display_name' ),
        ) );
        $rtwalwm_options = array( '' => __( 'Select an affiliate', 'affiliaa-affiliate-program-with-mlm' ) );
        foreach ( $rtwalwm_affiliates as $rtwalwm_user ) {
            if ( Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_is_active_affiliate( $rtwalwm_user->ID ) ) {
                $rtwalwm_options[ $rtwalwm_user->ID ] = $rtwalwm_user->display_name;
            }
        }
        woocommerce_wp_select(
            array(
                'id'      => 'rtwalwm_select_affiliate',
                'label'   => __( 'Select Affiliate', 'affiliaa-affiliate-program-with-mlm' ),
                'options' => $rtwalwm_options,
                'value'   => get_post_meta( $post->ID, 'rtwalwm_coupon_aff_id', true ),
            )
        );
        wp_nonce_field( 'rtwalwm_coupon_option_action', 'rtwalwm_coupon_option_nonce' );
    }

    function woocommerce_save_coupon_callback($post_id)
    {
        if ( ! isset( $_POST['rtwalwm_coupon_option_nonce'] ) || ! wp_verify_nonce( sanitize_text_field( wp_unslash( $_POST['rtwalwm_coupon_option_nonce'] )), 'rtwalwm_coupon_option_action' ) ) {
            return false;
        }
        if ( ! Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_can_manage() || ! current_user_can( 'edit_post', $post_id ) ) {
            return false;
        }

        $rtwalwm_aff_id = isset( $_POST['rtwalwm_select_affiliate'] ) ? absint( wp_unslash( $_POST['rtwalwm_select_affiliate'] ) ) : 0;
        if ( $rtwalwm_aff_id && Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_is_active_affiliate( $rtwalwm_aff_id ) ) {
            update_user_meta( $rtwalwm_aff_id, 'rtwalwm_coupon_save', $post_id );
            update_post_meta( $post_id, 'rtwalwm_coupon_aff_id', $rtwalwm_aff_id );
        }
        else {
            delete_post_meta( $post_id, 'rtwalwm_coupon_aff_id' );
        }
    }

    // function rtwalwm_save_notification_callback()
    // {
    //  $rtwalwm_not_title   =  isset($_POST['rtwalwm_not_title'])? sanitize_text_field(wp_unslash($_POST['rtwalwm_not_title'])) : ""; 
    //  $rtwalwm_noti_content = isset($_POST['rtwalwm_no_text'])? sanitize_text_field(wp_unslash($_POST['rtwalwm_no_text'])) : "";
    //  $rtwalwm_key = isset($_POST['rtwalwm_key'])? sanitize_text_field(wp_unslash($_POST['rtwalwm_key'])) : "";

    //  $rtwalwm_time = gmdate('d/m/y_H:i:s');
    //  $rtwalwm_noti_array = get_option('rtwalwm_noti_arr');
        
    // }
    // function rtwalwm_generate_csv_affiliate_callback(){

    //  $rtwalwm_args = array(
    //      'meta_key'      => 'rtwwwap_affiliate',
    //      'meta_value'    => '1',
    //      'orderby'       => 'id',
    //      'order'         => 'desc'
    //  );
    //  $rtwalwm_users = get_users( $rtwalwm_args );

    //  $rtwalwm_counter = 0;
    //  require_once( WP_PLUGIN_DIR."/affiliaa-affiliate-program-with-mlm/third_party/csv-9.8.0/autoload.php");
    //  $rtwalwm_filename   = "export-labels--".time().".csv";
    //  $csv = Writer::createFromPath(RTWALWM_DIR.'assets/csv/'.$rtwalwm_filename, 'w+');
    //  $header = ['S.NO.','Affiliate ID', 'Affiliate Name', 'Affiliate Email','Parent Id','Parent Name' ];
    //  $csv->insertOne($header);
    //  if(!empty($rtwalwm_users))
    //  {
    //      foreach( $rtwalwm_users as $rtwalwm_key => $rtwalwm_user ){
    //          global $wpdb; 
    //          $rtwalwm_parent_id = $wpdb->get_var($wpdb->prepare( "SELECT `parent_id` FROM ".$wpdb->prefix."rtwalwm_mlm WHERE `aff_id` = %d", $rtwalwm_user->ID )) ;

    //          $rtwalwm_parent_name = $wpdb->get_var($wpdb->prepare( "SELECT `user_login` FROM ".$wpdb->prefix."users WHERE `ID` = %d", $rtwalwm_parent_id  )) ;
    //          $rtwalwm_counter++;
    //          $csv->insertOne([$rtwalwm_counter-1, $rtwalwm_user->ID , $rtwalwm_user->data->user_login , $rtwalwm_user->data->user_email,$rtwalwm_parent_id, $rtwalwm_parent_name ]);
    //      }
    //      echo wp_json_encode( array('status' => true, 'filename' => $rtwalwm_filename) );
    //      wp_die();
    //  }
    //  else{
    //      echo wp_json_encode( array('status' => false, 'filename' => esc_html__( "There is no data available in this table", 'affiliaa-affiliate-program-with-mlm' )) );
    //      wp_die();
    //  }
                    
    // }

    function rtwalwm_generate_affiliate_csv_callback(){

        if ( ! isset( $_GET['rtwalwm_back_end_affiliate_nonce'] ) || ! wp_verify_nonce( sanitize_text_field( wp_unslash( $_GET['rtwalwm_back_end_affiliate_nonce'] ) ), 'rtwalwm_security_string_aff_nonce' ) ){
            return;
        }
        if ( ! Rtwalwm_Wp_Wc_Affiliate_Program_Helper::rtwalwm_can_manage() ) {
            wp_die( esc_html__( 'Unauthorized', 'affiliaa-affiliate-program-with-mlm' ), '', array( 'response' => 403 ) );
        }
        if ( headers_sent() ) {
            wp_die( esc_html__( 'The export could not start because output had already been sent.', 'affiliaa-affiliate-program-with-mlm' ) );
        }

        global $wpdb;
        $rtwalwm_users = get_users( array(
            'meta_key'   => 'rtwwwap_affiliate',
            'meta_value' => '1',
            'orderby'    => 'ID',
            'order'      => 'DESC',
        ) );

        // Stream straight to the browser: no file is written inside the plugin (works with a read-only plugin folder).
        while ( ob_get_level() > 0 ) {
            ob_end_clean();
        }
        nocache_headers();
        header( 'Content-Type: text/csv; charset=UTF-8' );
        header( 'Content-Description: File Transfer' );
        header( 'X-Content-Type-Options: nosniff' );
        header( 'Content-Disposition: attachment; filename="export-labels--' . time() . '.csv"' );

        $rtwalwm_out = fopen( 'php://output', 'w' );
        if ( false === $rtwalwm_out ) {
            wp_die( esc_html__( 'The export could not be written.', 'affiliaa-affiliate-program-with-mlm' ) );
        }
        // Explicit enclosure/escape arguments keep the output identical on PHP 7.4-8.4 without deprecation notices.
        fputcsv( $rtwalwm_out, array( 'S.NO.', 'Affiliate ID', 'Affiliate Name', 'Affiliate Email', 'Parent Id', 'Parent Name' ), ',', '"', '' );
        $rtwalwm_counter = 0;
        foreach ( $rtwalwm_users as $rtwalwm_user ) {
            $rtwalwm_parent_id   = $wpdb->get_var( $wpdb->prepare( "SELECT `parent_id` FROM `{$wpdb->prefix}rtwwwap_mlm` WHERE `aff_id` = %d", $rtwalwm_user->ID ) );
            $rtwalwm_parent      = $rtwalwm_parent_id ? get_userdata( (int) $rtwalwm_parent_id ) : false;
            $rtwalwm_parent_name = $rtwalwm_parent ? $rtwalwm_parent->user_login : '';
            $rtwalwm_counter++;
            $rtwalwm_row = array( $rtwalwm_counter, $rtwalwm_user->ID, $rtwalwm_user->user_login, $rtwalwm_user->user_email, (string) $rtwalwm_parent_id, $rtwalwm_parent_name );
            fputcsv( $rtwalwm_out, array_map( array( 'Rtwalwm_Wp_Wc_Affiliate_Program_Helper', 'rtwalwm_csv_cell' ), $rtwalwm_row ), ',', '"', '' );
        }
        fclose( $rtwalwm_out );
        exit;
    }

}