FUNZIONE RICERCA

//CUSTOM SEARCH BOX E SUO SHORTCODE
//CODICE GURU di WordPress Buddha

function wpb_demo_shortcode() {
    global $wpdb, $wp_query;

    // Retrieve categories dropdown
    $categories = wp_dropdown_categories([
        'show_count' => 1,
        'hierarchical' => 1,
        'show_option_all' => esc_html__('All destinations', 'sacconicase'),
        'echo' => false,
    ]);
//fine categoria

// Retrieve tipologia dropdown

$select = $wp_query->get('tipologia');
$select = '' == $select ? 0 : $select;
$taxonomy = wp_dropdown_categories([
    'hierarchical' => false,
    'name' => 'tipologia',
    'taxonomy' => 'tipologia',
    'selected' => $select,
    'show_option_all' => esc_html__('Typology', 'sacconicase'),
    'value_field' => 'slug',
    'echo' => false
]);

$tipologia= '<select>
$select =
</select>';


//nuovi ospiti e camere

// Retrieve unique values for 'function_camere' custom field
    $functionCamereValues = $wpdb->get_col("SELECT DISTINCT meta_value FROM $wpdb->postmeta WHERE meta_key = 'function_camere' ORDER BY meta_value");
    $functionCamereDropdown = '<select name="function_camere">';
    $functionCamereDropdown .= '<option value="">' . esc_html__('n.Bedrooms', 'sacconicase') . '</option>';

    foreach ($functionCamereValues as $value) {
        $number = empty($_GET['function_camere']) ? '': $_GET['function_camere'];
        $functionCamereDropdown .= '<option value="' . esc_attr($value) . '" '.
selected( $number, $value, false ) .' >' . esc_html($value) . '+' . '</option>';

   }
$functionCamereDropdown .= '</select>';



// Retrieve unique values for 'function_ospiti' custom field
    $functionOspitiValues = $wpdb->get_col("SELECT DISTINCT meta_value FROM $wpdb->postmeta WHERE meta_key = 'function_ospiti' ORDER BY meta_value");
    $functionOspitiDropdown = '<select name="function_ospiti">';
    $functionOspitiDropdown .= '<option value="">' . esc_html__('n.Guests', 'sacconicase') . '</option>';


   foreach ($functionOspitiValues as $value) {
        $number = empty($_GET['function_ospiti']) ? '': $_GET['function_ospiti'];
        $functionOspitiDropdown .= '<option value="' . esc_attr($value) . '" '.
selected( $number, $value, false ) .' >' . esc_html($value) .'+'. '</option>';

 }
    $functionOspitiDropdown .= '</select>';




    // Form output
    $output = '<form class="sacconi_form" method="get" action="' . home_url('/') . '">' .
              $categories . $taxonomy . $tipologia .$functionOspitiDropdown . $functionCamereDropdown . '<br><br>' .
              '<input type="submit" name="search" value="' . esc_html__('Search', 'sacconicase') . '">' .
              '</form>';

    return $output;
  }


// register shortcode

add_shortcode('ricerca', 'wpb_demo_shortcode');


// FILTRO CAMERE E OSPITI

add_action( 'pre_get_posts', 'bedrooms_guests_search_query');

function bedrooms_guests_search_query( $query ) {
   if (! is_admin() && $query->is_main_query()) {
      if ( array_key_exists('funzione_camere', $_GET ) &&

      array_key_exists('funzione_ospiti', $_GET )) {

$meta_query = array(
	array(
		'key' => 'function_ospiti',
		'value' => (int) $_GET['funzione_ospiti'],
		'type' => 'numeric',
		'compare' => '>=',
	),
	array(
		'key' => 'function_camere',
		'value' => (int) $_GET['funzione_camere'],
		'type' => 'numeric',
		'compare' => '>=',
	),
);

         $query->set("meta_query", $meta_query);
}
   }
}