Function Reference: geodir_advance_search_where

Summary

This function has not been documented yet.

Filters

‘advance_search_where_query’ [Line: 345]

Source File

geodir_advance_search_where() is located in geodir_advance_search_filters/geodirectory_advance_search_function.php [Line: 182]

Source Code

function geodir_advance_search_where( $where ) {  
	global $wpdb, $geodir_post_type, $table, $plugin_prefix, $dist, $mylat, $mylon, $s, $snear, $s, $s_A, $s_SA, $search_term;

	if( isset( $_REQUEST['stype'] ) ) {
		$post_types = esc_attr($_REQUEST['stype']);
	} else {
		$post_types = 'gd_place';
	}
	
	/* check for post type other then geodir post types */
	if( !geodir_is_geodir_search( $where ) ) {
		return $where;
	}
	
	/* Add categories filters */
	$category_filter = false;	
	$category_search_query = '';
	$geodir_custom_search = '';
	$category_search_range = ''; 

	$sql = $wpdb->prepare( "SELECT * FROM " . GEODIR_ADVANCE_SEARCH_TABLE . " WHERE post_type = %s ORDER BY sort_order", array( $post_types ) );
	$taxonomies = $wpdb->get_results( $sql );

	if( !empty( $taxonomies ) ) {
		foreach( $taxonomies as $taxonomy_obj ) {
			$taxonomy_obj = stripslashes_deep($taxonomy_obj); // strip slashes
			switch( $taxonomy_obj->field_input_type ) {
				case 'RANGE':
					// SEARCHING BY RANGE FILTER 
					switch( $taxonomy_obj->search_condition ) {
						case 'SINGLE':
							$value = esc_attr($_REQUEST['s' . $taxonomy_obj->site_htmlvar_name]);
							
							if( !empty( $value ) ) {
								$category_search_range .= " AND ( ".$table.'.'.$taxonomy_obj->site_htmlvar_name." = $value) "; 
							}
						break;
						
						case 'FROM':
							$minvalue = @esc_attr($_REQUEST['smin'.$taxonomy_obj->site_htmlvar_name]);
							$smaxvalue = @esc_attr($_REQUEST['smax'.$taxonomy_obj->site_htmlvar_name]);
							
							if( !empty( $minvalue ) ) { 
								$category_search_range .= " AND ( ".$table.'.'.$taxonomy_obj->site_htmlvar_name." >= '".$minvalue."') "; 
							}
								
							if( !empty( $smaxvalue ) ) {
								$category_search_range .= " AND ( ".$table.'.'.$taxonomy_obj->site_htmlvar_name." <= '".$smaxvalue."') ";
							}			
						break;
						
						case 'RADIO':
							// This code in main geodirectory listing filter 
						break;
						
						default :
							if( isset( $_REQUEST&#91;'s'.$taxonomy_obj->site_htmlvar_name] ) && $_REQUEST['s'.$taxonomy_obj->site_htmlvar_name] != '' ) {
								$serchlist =  explode( "-", esc_attr($_REQUEST['s'.$taxonomy_obj->site_htmlvar_name]) );
								$first_value  = @$serchlist[0];//100 200
								$second_value = @trim( $serchlist[1], ' ' );
								$rest = substr( $second_value, 0, 4 ); 
								 
								if( $rest == 'Less' ) {
									$category_search_range .= " AND ( ".$table.'.'.$taxonomy_obj->site_htmlvar_name." <= $first_value ) "; 
									
								} else if ( $rest == 'More' ) {
									$category_search_range .= " AND ( ".$table.'.'.$taxonomy_obj->site_htmlvar_name." >= $first_value) ";
									
								} else if( $second_value != '' ) {
									$category_search_range  .= " AND ( ".$table.'.'.$taxonomy_obj->site_htmlvar_name." between $first_value and $second_value ) ";
								}
							}
						break;
					}
					// END SEARCHING BY RANGE FILTER  
				break;
				
				case 'DATE' :
					$single = '';
					$value = @esc_attr($_REQUEST['s'.$taxonomy_obj->site_htmlvar_name]);
					if(	isset( $value ) &&!empty( $value ) ) {
						$minvalue = $value;
						$maxvalue = '';
						$single = '1';
					} else {
						$minvalue = @esc_attr($_REQUEST['smin'.$taxonomy_obj->site_htmlvar_name]);
						$maxvalue = @esc_attr($_REQUEST['smax'.$taxonomy_obj->site_htmlvar_name]);
					}
				
					if( $taxonomy_obj->site_htmlvar_name == 'event' ) {
						$category_search_range .= " ";
					} else if( $taxonomy_obj->field_data_type == 'DATE' ) {
						$start_date = date( 'Y-m-d', strtotime( $minvalue ) );
						$start_end = date( 'Y-m-d', strtotime( $maxvalue ) );
						
						$minvalue = $wpdb->get_var( "SELECT UNIX_TIMESTAMP( STR_TO_DATE( '".$start_date."','%Y-%m-%d'))" );
						$maxvalue = $wpdb->get_var( "SELECT UNIX_TIMESTAMP( STR_TO_DATE( '".$start_end."','%Y-%m-%d'))" );
							
						if( $single == '1' ) {
							$category_search_range .= " AND ( unix_timestamp(".$table.'.'.$taxonomy_obj->site_htmlvar_name.") = '".$minvalue."' )";
						} else {
							if( !empty( $minvalue ) ) {
								$category_search_range .= " AND ( unix_timestamp(".$table.'.'.$taxonomy_obj->site_htmlvar_name.") >= '".$minvalue."' )";
							}
							if( !empty( $maxvalue ) ) {
								$category_search_range .= " AND ( unix_timestamp(".$table.'.'.$taxonomy_obj->site_htmlvar_name.") <= '".$maxvalue."' )";
							}
						}		
					} else if( $taxonomy_obj->field_data_type == 'TIME' ) {
						if( $single == '1' ) {
							 $category_search_range .= " AND ( ".$table.'.'.$taxonomy_obj->site_htmlvar_name." = '".$minvalue.":00' )";  
						} else {
							if( !empty( $minvalue ) ) {
								$category_search_range .= " AND ( ".$table.'.'.$taxonomy_obj->site_htmlvar_name." >= '".$minvalue.":00' )"; 
							}
							if( !empty( $maxvalue ) ) {
								$category_search_range .= " AND ( ".$table.'.'.$taxonomy_obj->site_htmlvar_name." <= '".$maxvalue.":00' )";
							}
						}
					}
				break;
				default:
					$category_search = ''; 
					if( isset( $_REQUEST&#91;'s'.$taxonomy_obj->site_htmlvar_name] ) && is_array( $_REQUEST['s'.$taxonomy_obj->site_htmlvar_name] ) ) {
						$i = 0;
						$add_operator = ''; 
						foreach( $_REQUEST['s'.$taxonomy_obj->site_htmlvar_name] as $val ) {
                            $val = esc_attr($val);
							if( $val != '' ) {
								if( $i != 0 ) {
									$add_operator = $search_term;
								}
								
								$category_search .= $add_operator." FIND_IN_SET('{$val}', ".$table.".".$taxonomy_obj->site_htmlvar_name." ) ";
								$i++; 
							} 
						}
						
						if( !empty( $category_search ) ) {
							$geodir_custom_search .= " AND (".$category_search.")";
						}
					} else if( isset($_REQUEST['s'.$taxonomy_obj->site_htmlvar_name] ) ) {
						$site_htmlvar_name = $taxonomy_obj->site_htmlvar_name;
							
						if( $site_htmlvar_name == 'post' ) {
							$site_htmlvar_name = $site_htmlvar_name.'_address';
						}
							
						if( $_REQUEST['s'.$taxonomy_obj->site_htmlvar_name] ) {
							$geodir_custom_search .= " AND ".$table.".".$site_htmlvar_name." LIKE '%".esc_attr($_REQUEST['s'.$taxonomy_obj->site_htmlvar_name])."%' ";
						}
					}
				break;
			}
		} 
	}
	if( !empty( $geodir_custom_search ) ) {
		$where .= $geodir_custom_search;
	}
	if( !empty( $category_search_range ) ) {
		$where .= $category_search_range;
	}
	
	$where =  apply_filters( 'advance_search_where_query', $where );
	
	return $where;
}