<?php
/**
 * Search Capabilities of events through out eventon
 * @version 5.0
 */
if ( ! defined( 'ABSPATH' ) ) exit;

class evo_search{

	public $options = '';

	public function __construct(){
		add_shortcode('add_eventon_search', array($this, 'search_content'), 10, 1);
		add_filter('eventon_shortcode_popup',array($this,'add_shortcode_options'), 10, 1);

		// frontend
		$this->options = get_option('evcal_options_evcal_1');
		add_filter('evo_cal_main_btns', array($this, 'header_search_button'), 10, 2);
		add_filter('evo_cal_header_end_content', array($this, 'header_search_bar'), 10, 2);
		add_action('evo_cal_footer', array($this, 'remove_search_bar'), 10);


		// include events in search
		add_action( 'pre_get_posts', array($this,'include_events_search'),10,1 );
		add_filter( 'evo_cpt_search_visibility', array($this, 'enable_events_search'), 10,1 );	
		add_filter( 'posts_search', array($this, 'advanced_custom_search'), 500, 2 );	

		// Log search
		add_action('wp_ajax_evo_search_results', array($this, 'log_search_term'), 5);
        add_action('wp_ajax_nopriv_evo_search_results', array($this, 'log_search_term'), 5);
	}

// Log search results
	public function log_search_term() {
        // Only log if we actually have a search term
        if ( empty($_POST['s']) || trim($_POST['s']) === '' ) return;

        global $wpdb;

        $table_name = $wpdb->prefix . 'eventon_search_logs';

        // Make sure table exists (in case activation hook hasn't run yet)
        self::maybe_create_table();

        $search_term   = sanitize_text_field( wp_unslash( $_POST['s'] ) );
        $user_id       = get_current_user_id();
        $ip            = $this->get_ip_address();
        $user_agent    = $_SERVER['HTTP_USER_AGENT'] ?? '';
        $referer       = $_SERVER['HTTP_REFERER'] ?? '';
        $results_count = 0;

        // Try to get results count from EventON response (it sends JSON back)
        if ( !empty($_POST['json']) && is_string($_POST['json']) ) {
            $json_data = json_decode( wp_unslash($_POST['json']), true );
            if ( isset($json_data['content']) && strpos($json_data['content'], 'eventon_events_list') !== false ) {
                // Count number of .ajde_evcal_calendar elements or extract from JS response
                // Alternative: count how many events were returned
                preg_match_all('/class="[^"]*eventon_list_event[^"]*"/', $json_data['content'], $matches);
                $results_count = count($matches[0]);
            }
        }

        // Fallback: use the count EventON returns in data-count attribute
        if ( $results_count == 0 && !empty($_POST['json']) ) {
            $json = json_decode( wp_unslash($_POST['json']), true );
            if ( isset($json['status']) && $json['status'] == 'success' && isset($json['data-count']) ) {
                $results_count = (int)$json['data-count'];
            }
        }

        $wpdb->insert(
            $table_name,
            array(
                'search_term'    => $search_term,
                'user_id'       => $user_id,
                'ip_address'   => substr($ip, 0, 100),
                'user_agent'    => substr($user_agent, 0, 255),
                'referer'       => substr($referer, 0, 500),
                'results_count' => $results_count,
                'searched_at'   => current_time('mysql'),
            ),
            array('%s', '%d', '%s', '%s', '%s', '%d', '%s')
        );
    }

    // create custom table if not setup
    private static function maybe_create_table() {
        global $wpdb;
        $table_name = $wpdb->prefix . 'evo_search_logs';

        if ( $wpdb->get_var("SHOW TABLES LIKE '$table_name'") == $table_name ) {
            return;
        }

        $charset_collate = $wpdb->get_charset_collate();

        $sql = "CREATE TABLE $table_name (
            id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
            search_term varchar(255) NOT NULL,
            user_id bigint(20) UNSIGNED DEFAULT 0,
            ip_address varchar(100) DEFAULT '',
            user_agent varchar(255) DEFAULT '',
            referer varchar(500) DEFAULT '',
            results_count int UNSIGNED DEFAULT 0,
            searched_at datetime DEFAULT CURRENT_TIMESTAMP,
            PRIMARY KEY  (id),
            KEY search_term (search_term),
            KEY searched_at (searched_at),
            KEY user_id (user_id),
            KEY results_count (results_count)
        ) $charset_collate;";

        require_once ABSPATH . 'wp-admin/includes/upgrade.php';
        dbDelta($sql);

        update_option('eventon_search_log_db_version', '1.0');
    }

    // HELPER: Get real IP (behind proxies/cloudflare)
    private function get_ip_address() {
        foreach ( array( 'HTTP_CLIENT_IP', 'HTTP_X_FORWARDED_FOR', 'HTTP_X_FORWARDED', 'HTTP_X_CLUSTER_CLIENT_IP', 'HTTP_FORWARDED_FOR', 'HTTP_FORWARDED', 'REMOTE_ADDR' ) as $key ) {
            if ( array_key_exists($key, $_SERVER) === true ) {
                foreach ( explode(',', $_SERVER[$key]) as $ip ) {
                    $ip = trim($ip);
                    if ( filter_var($ip, FILTER_VALIDATE_IP, FILTER_FLAG_NO_PRIV_RANGE | FILTER_FLAG_NO_RES_RANGE) !== false ) {
                        return $ip;
                    }
                }
            }
        }
        return $_SERVER['REMOTE_ADDR'] ?? '0.0.0.0';
    }

// shortcode content u4.5.8
	function search_content($atts){
		ob_start(); 

		// enqueue required eventon scripts
		EVO()->frontend->load_evo_scripts_styles();
		

		$defaults = array(
			'event_type'=>'all',
			'event_type_2'=>'all',
			'number_of_months'=>12,
			'search_all'=>'no',
			'hide_mult_occur'=>'no',
			'lang'=>'L1',
		);


		$sc_data = is_array($atts) ? array_merge($defaults, $atts): $defaults;
		EVO()->lang = $sc_data['lang'];
		
			
		?>
		<div id='evo_search' class='EVOSR_section '>
			<div class="evo_search_entry">
				<p class='evosr_search_box' >
					<input class='evo_search_field evoff_2i' type="text" placeholder='<?php echo evo_lang_get('evoSR_001a','Search Calendar Events');?>' data-role="none">
					<a class='evo_do_search'><i class="fa fa-search"></i></a>
					<span class="evosr_blur"></span>
					<span class="evosr_blur_process"></span>
					<span class="evosr_blur_text"><?php echo evo_lang_get('evoSR_002','Searching');?></span>
					<span style="display:none" class='data' data-sc='<?php echo json_encode($sc_data);?>'></span>
				</p>
				<p class='evosr_msg' style='display:none'><?php echo evo_lang_get('evoSR_003','What do you want to search for?');?></p>
			</div>


			<p class="evo_search_results_count evoff_2 evofz16" style='display:none'><span>10</span> <?php echo evo_lang_get('evoSR_004','Event(s) found');?></p>
			<div class="evo_search_results"></div>
		</div>
		<?php
		return ob_get_clean();
	}

	function add_shortcode_options($shortcode_array){
		global $evo_shortcode_box;
			
			$new_shortcode_array = array(
				array(
					'id'=>'s_SR',
					'name'=>__('Search Box','eventon'),
					'code'=>'add_eventon_search',
					'variables'=>array(
						array(
							'name'=>'<i>'.__('NOTE: This will allow you to drop an interactive event search field that allow users to search through all current events. You can further filter search results with below options.','eventon') .'</i>',
							'type'=>'note',							
						),
						$evo_shortcode_box->shortcode_default_field('event_type'),
						$evo_shortcode_box->shortcode_default_field('event_type_2'),
						$evo_shortcode_box->shortcode_default_field('lang'),
						$evo_shortcode_box->shortcode_default_field('number_of_months'),
						$evo_shortcode_box->shortcode_default_field('hide_mult_occur'),
						array(
							'name'=>__('Search all events (past and current)','eventon'),
							'type'=>'YN',
							'guide'=>__('Setting this will disregard number of months value and will search in all the events.','eventon'),
							'default'=>'no',
							'var'=>'search_all', 
						)
					)
				)
			);

			return array_merge($shortcode_array, $new_shortcode_array);
	}

// frotnend
	function list_searcheable_acf(){
	  	$list_searcheable_acf = array("title", "evcal_subtitle", "excerpt_short", "excerpt_long");
	  	return $list_searcheable_acf;
	}
		function advanced_custom_search( $where, $wp_query ) {
		    global $wpdb;

		    if(!evo_settings_check_yn( $this->options, 'EVOSR_advance_search')) return $where;
		   
		    if ( empty( $where ))  return $where;

		    //if( is_admin()) return $where;

		    // restrict this only to event post search
		    if(!isset($wp_query->query['post_type'])) return $where;
		    if( $wp_query->query['post_type']!= 'ajde_events') return $where;
		 
		    // get search expression
		    $terms = $wp_query->query_vars[ 's' ];

		    // explode search expression to get search terms
		    $exploded = explode( ' ', $terms );
		    if( $exploded === FALSE || count( $exploded ) == 0 )  $exploded = array( 0 => $terms );
		         
		    // reset search in order to rebuilt it as we whish
		    $where = '';
		    $tableprefix = $wpdb->prefix;

		    // get searcheable_acf, a list of advanced custom fields you want to search content in
		    $list_searcheable_acf = $this->list_searcheable_acf();
		    foreach( $exploded as $tag ) :
		        $where .= " 
		          AND (
		            (".$tableprefix."posts.post_title LIKE '%$tag%')
		            OR (".$tableprefix."posts.post_content LIKE '%$tag%')
		            OR EXISTS (
		              SELECT * FROM ".$tableprefix."postmeta
			              WHERE post_id = ".$tableprefix."posts.ID
			                AND (";
		        foreach ($list_searcheable_acf as $searcheable_acf) :
		          if ($searcheable_acf == $list_searcheable_acf[0]):
		            $where .= " (meta_key LIKE '%" . $searcheable_acf . "%' AND meta_value LIKE '%$tag%') ";
		          else :
		            $where .= " OR (meta_key LIKE '%" . $searcheable_acf . "%' AND meta_value LIKE '%$tag%') ";
		          endif;
		        endforeach;
			        $where .= ")
		            )
		            OR EXISTS (
		              SELECT * FROM ".$tableprefix."comments
		              WHERE comment_post_ID = ".$tableprefix."posts.ID
		                AND comment_content LIKE '%$tag%'
		            )
		            OR EXISTS (
		              SELECT * FROM ".$tableprefix."terms
		              INNER JOIN ".$tableprefix."term_taxonomy
		                ON ".$tableprefix."term_taxonomy.term_id = ".$tableprefix."terms.term_id
		              INNER JOIN ".$tableprefix."term_relationships
		                ON ".$tableprefix."term_relationships.term_taxonomy_id = ".$tableprefix."term_taxonomy.term_taxonomy_id
		              WHERE (
		          		taxonomy = 'event_location'
		            		OR taxonomy = 'event_organizer'          		
		            		OR taxonomy = 'event_speaker'          		
		            		OR taxonomy = 'event_type'
		            		OR taxonomy = 'event_type_2'
		            		OR taxonomy = 'event_type_3'
		          		)
		              	AND object_id = ".$tableprefix."posts.ID
		              	AND ".$tableprefix."terms.name LIKE '%$tag%'
		            )
		        )";
		    endforeach;

		    return $where;
		}

	// include events in default wordpress search 
		function enable_events_search($value){
			if(!evo_settings_val('EVOSR_default_search',$this->options)) return $value;
			return false;
		}
		function include_events_search($query){

			if(!evo_settings_val('EVOSR_default_search',$this->options)) return $query;

			if( is_admin()) return $query;

			if( empty($query->is_search)) return $query;

			// Check to verify it's search page
			if( $query->is_search ) {

				if( isset($query->query_vars['post_type']) && $query->query_vars['post_type'] != 'ajde_events') return $query;
				
				// Get post types
				$post_types = get_post_types(array('public' => true, 'exclude_from_search' => false), 'objects');
				$searchable_types = array();
				
				// Add available post types
				if( $post_types ) {
					foreach( $post_types as $type) {
						$searchable_types[] = $type->name;
					}
				}

				if(!in_array('ajde_events', $searchable_types)) 
					$searchable_types[] = 'ajde_events';

				//$query->set( 'post_type', array( 'post', 'ajde_events' ) );
				$query->set( 'post_type', $searchable_types );
			}
			return $query;
		}

		// evosr_disable_search
	// include search in header section
		function header_search_button($array, $args){
			$opt = $this->options;


			// disable showing search if search btn is set to no
			if( isset($args['search_btn']) && !$args['search_btn'] ) return $array;

			// check if default search is off && shortcode is no
			if( (!evo_settings_check_yn($opt, 'evosr_default_search_on') && !evo_settings_check_yn($args, 'search')) || 
				(evo_settings_check_yn($opt, 'evosr_default_search_on') && (!empty($args['search']) && $args['search']=='no'))
			)
				return $array;
						
			if(!empty($opt['EVOSR_showfield']) && $opt['EVOSR_showfield']=='yes'){
				//$array['evo-search'] = '';
				return $array;
			}else{
				$new['evo-search']='';
				$array = array_merge($new, $array);
			}

			return $array;
		}

	// header search bar u4.6
		function header_search_bar($array, $args){
			extract( $args );
			EVO()->cal->set_cur('evcal_1');

			$opt = $this->options;

			$search_on = $search_show = false;

			// check if search is enabled from settings or via shortcode
			if( EVO()->cal->check_yn( 'evosr_default_search_on' )) $search_on = true;
			if( !empty($search) && $search == 'yes') $search_on = true;

			if( !$search_on ) return $array;

			if( EVO()->cal->check_yn( 'EVOSR_showfield' )) $search_show = true;
			if( !empty($show_search) && $show_search == 'yes') $search_show = true;
						
			ob_start();
			?>					
				<div class='evo_search_bar <?php echo $search_show ? '' : 'evo_hidden';?>'>
					<div class='evo_search_bar_in' >
						<label for='saddr-input' class='sr-only'><?php evo_lang_get_e( 'evoSR_001', 'Search Events');?></label>		
						<input id='evo_search_bar_in_<?php echo EVO()->calendar->ID;?>' class='evo_search_bar_in_field evoh100p' type="text" placeholder='<?php echo evo_lang_get( 'evoSR_001', 'Search Events');?>' data-role="none"/>
						<a class="evosr_search_clear_btn"><i class="fa fa-close"></i></a>
						<a class="evosr_search_btn"><i class="fa fa-search"></i></a>
					</div>
				</div>

			<?php
			$content = ob_get_clean();
			$array['evo-search']= $content;
			return $array;
		}
	// remove search bar
		function remove_search_bar(){
			//remove_filter('evo_cal_above_header_btn',array($this, 'header_search_button'));
			//remove_filter('evo_cal_above_header_content',array($this, 'header_search_bar'));
		}


}
new evo_search();