$is_search = 0;
global $wpdb;
$totalpost_count = 0;
$propertycategory = get_cat_id_from_name(get_option('ptthemes_propertycategory'));
$propertycategorys = get_sub_categories($propertycategory,'string');
$all_pids_arr = $wpdb->get_var("SELECT group_concat(ID) FROM $wpdb->posts where post_status='publish' and post_type='property'");
$all_pids_arr = explode(',',$all_pids_arr);
//$all_pids_arr = $wpdb->get_col("SELECT tr.object_id FROM $wpdb->term_taxonomy tt join $wpdb->term_relationships tr on tr.term_taxonomy_id=tt.term_taxonomy_id where tt.term_id in ($propertycategorys)");
if($_REQUEST['srch_location'])
{
$is_search = 1;
$srch_location = $_REQUEST['srch_location'];
//$location_pids = $wpdb->get_var("SELECT group_concat(tr.object_id) FROM $wpdb->term_taxonomy tt join $wpdb->term_relationships tr on tr.term_taxonomy_id=tt.term_taxonomy_id where tt.term_id=\"$srch_location\"");
$location_pids_arr = $wpdb->get_col("select post_id from $wpdb->postmeta where meta_key like 'location' and meta_value like \"$srch_location\"");
$all_pids_arr = array_intersect($all_pids_arr,$location_pids_arr);

}
if($_REQUEST['srch_price'])
{
$is_search = 1;
$srch_price = $_REQUEST['srch_price'];
if(strstr($srch_price,'-'))
{
$srch_price_str = str_replace('-',' and ',$srch_price);
$srch_price_arr = $wpdb->get_col("select post_id from $wpdb->postmeta where meta_key like 'price' and meta_value between $srch_price_str");
}
elseif(strstr($srch_price,'+'))
{
$srch_price_str = str_replace('+','',$srch_price);
$srch_price_arr = $wpdb->get_col("select post_id from $wpdb->postmeta where meta_key like 'price' and meta_value >= $srch_price_str");
}
$all_pids_arr = array_intersect($all_pids_arr,$srch_price_arr);
}
if($_REQUEST['srch_bedrooms'])
{
$is_search = 1;
$srch_bedrooms = $_REQUEST['srch_bedrooms'];
$srch_bedrooms_arr = $wpdb->get_col("select post_id from $wpdb->postmeta where meta_key like 'bedrooms' and meta_value = \"$srch_bedrooms\"");
$all_pids_arr = array_intersect($all_pids_arr,$srch_bedrooms_arr);
}
if($_REQUEST['srch_bathroom'])
{
$is_search = 1;
$srch_bathroom = $_REQUEST['srch_bathroom'];
$bathroom_pids_arr = $wpdb->get_col("select (post_id) from $wpdb->postmeta where meta_key like 'bathrooms' and meta_value = \"$srch_bathroom\"");
$all_pids_arr = array_intersect($all_pids_arr,$bathroom_pids_arr);
}
if($_REQUEST['srch_type'])
{
$is_search = 1;
$srch_type = $_REQUEST['srch_type'];
$type_pids_arr = $wpdb->get_col("select post_id from $wpdb->postmeta where meta_key like 'property_type' and meta_value = \"$srch_type\"");
$all_pids_arr = array_intersect($all_pids_arr,$type_pids_arr);
}
if($_REQUEST['srch_area'])
{
$is_search = 1;
$srch_area = $_REQUEST['srch_area'];
if(strstr($srch_area,'-'))
{
$srch_area_str = str_replace('-',' and ',$srch_area);
$srch_area_pids_arr = $wpdb->get_col("select post_id from $wpdb->postmeta where meta_key like 'area' and meta_value between $srch_area_str");
}
elseif(strstr($srch_area,'+'))
{
$srch_area_str = str_replace('+','',$srch_area);
$srch_area_pids_arr = $wpdb->get_col("select post_id from $wpdb->postmeta where meta_key like 'area' and meta_value >= $srch_area_str");
}
$all_pids_arr = array_intersect($all_pids_arr,$srch_area_pids_arr);
}
if($_REQUEST['srch_keyword'] && $_REQUEST['srch_keyword']!=CITY_STATE_ZIP_SRCH_TEXT)
{
$is_search = 1;
$srch_keyword = $_REQUEST['srch_keyword'];
$srch_keyword_arr = explode(',',$srch_keyword);
if(count($srch_keyword_arr)==1)
{
$add_city = $srch_keyword;
$add_state = $srch_keyword;
$add_zip_code = $srch_keyword;
}elseif(count($srch_keyword_arr)==2)
{
$add_city = $srch_keyword_arr[0];
$add_state = $srch_keyword_arr[1];
$add_zip_code = $srch_keyword_arr[0];
}elseif(count($srch_keyword_arr)==3)
{
$add_city = $srch_keyword_arr[0];
$add_state = $srch_keyword_arr[1];
$add_zip_code = $srch_keyword_arr[2];
}
$kw_pids_arr = $wpdb->get_col("select post_id from $wpdb->postmeta where (meta_key like 'property_city' and meta_value like \"%$add_city%\") or (meta_key like 'property_state' and meta_value like \"%$add_state%\") or (meta_key like 'property_zip' and meta_value like \"%$add_zip_code%\")");
$all_pids_arr = array_intersect($all_pids_arr,$kw_pids_arr);
}
if($is_search && !$all_pids_arr)
{
$all_pids_arr[0] = 'nopost';
}
if($_REQUEST['srch_property_id'])
{
$post_ids_str = $_REQUEST['srch_property_id'];
$sub_cat_sql .= " and p.ID in ($post_ids_str) ";
}else
{
if($all_pids_arr)
{
$post_ids_str = implode(',',$all_pids_arr);
if($post_ids_str)
{
$sub_cat_sql .= " and p.ID in ($post_ids_str) ";
}
}
}
$featurecat = get_cat_id_from_name(get_option('ptthemes_featuredcategory'));
if($featurecat)
{
$srch_feature_pids = $wpdb->get_var("SELECT group_concat(tr.object_id) FROM $wpdb->term_taxonomy tt join $wpdb->term_relationships tr on tr.term_taxonomy_id=tt.term_taxonomy_id where tt.term_id in ($featurecat)");
$srch_feature_pids = '';
}
$blogcat = get_cat_id_from_name(get_option('ptthemes_blogcategory'));
$blogcatcatids = get_sub_categories($blogcat,'string');
if($blogcatcatids)
{
$srch_blog_pids = $wpdb->get_var("SELECT group_concat(tr.object_id) FROM $wpdb->term_taxonomy tt join $wpdb->term_relationships tr on tr.term_taxonomy_id=tt.term_taxonomy_id where tt.term_id in ($blogcatcatids)");
}

/**--------Search as per custom field BOF---------**/
$sub_cat_sql1 = '';
$serch_post_types = CUSTOM_POST_TYPE1;
$concat = "OR";
$count = 1;
$custom_metaboxes = get_post_custom_fields_templ($serch_post_types,'','user_side','1');
foreach($custom_metaboxes as $key=>$val) {
$name = $key;
if($_REQUEST[$name]){
$value = $_REQUEST[$name];
if($name == 'proprty_desc'){
$sub_cat_sql .= " AND (p.post_content like \"%$value%\" )";
} else if($name == 'property_name'){
$sub_cat_sql .= " AND (p.post_title like \"%$value%\" )";
}else {
$sub_cat_sql .= " AND (p.ID in (select $wpdb->postmeta.post_id from $wpdb->postmeta where p.ID = $wpdb->postmeta.post_id and $wpdb->postmeta.meta_key='$name' and ($wpdb->postmeta.meta_value like \"%$value%\" ))) ";
}
}
}
/**--------Search as per custom field EOF---------**/
//$srch_sql = "select * from $wpdb->posts p, $wpdb->postmeta pm where p.ID = pm.post_id and p.post_status='publish' and p.post_type='property' $sub_cat_sql";

$srch_sql = "select * from $wpdb->posts p,$wpdb->postmeta pm where p.ID = pm.post_id and p.post_status='publish' and p.post_type='property' $sub_cat_sql group by p.ID";
if($srch_feature_pids)
{
$feature_srch_sql = "select p.* from $wpdb->posts p where p.post_status='publish' and p.post_type='property' and p.ID in ($srch_feature_pids)";
$srch_sql = " select * from (($feature_srch_sql) union ($srch_sql))";
}

$totalpost_count = $wpdb->get_var("select count(p.ID) from $wpdb->posts p $post_meta_join where p.post_status='publish' and p.post_type='property' $sub_cat_sql");
global $posts_per_page,$paged,$totalpost_count;
if($paged==''){$paged=1;}
$startlimit = $posts_per_page*($paged-1);
$srch_sql .= " order by p.ID desc limit $startlimit , $posts_per_page";
$post_info = $wpdb->get_results($srch_sql);
?>
<script>/library/js/functions.js"></script>