Jump to content

Having an issue with an array in a dropdown box

dsillaman

By dsillaman
in PHP Coding Help

 Share

Recommended Posts

dsillaman Newbie

dsillaman

Posted
Posted

Hi we are working some php code and we have created the drop down box but it is creating an array. We are trying to rewrite a piece of code that was originially written for select boxes but with 50 options that a bit too many select boxes and a drop down box is a lot cleaner. The dropdown box is created but the word "array" appears in the box and there are no options to choose from.

 

Here is the code we are trying to get working.

 

case 'multiselectbox':
            case 'selectbox':
                echo '<div class="editfield field_'.$field_id.' selectbox">';
                $tt = array();
                if($get_field) {
                    $tt = $get_field;
                }
                foreach ($children as $child) {
                    $child->name = trim ($child->name);
                    $child =  (in_array ($child->name, $tt );
                    echo '<input type="dropdown" name="'. $fieldName . '_' . $field_id . '" value="'. $children. '" style="width:20%" placeholder="Category" />';
                echo '</div>';
                break;

 

Here is the code as it was originially written with the select boxes.

 

case 'radio':
            case 'checkbox':
                echo '<div class="editfield field_'.$field_id.' checkbox">';
                echo '<span class="label">' . $field_data->name. '</span>';
                $tt = array();
                if($get_field) {
                    $tt = $get_field;
                }
                //echo '<div class="wppl-checkboxes-wrapper">';
                foreach ($children as $child) {
                    $child->name = trim ($child->name);
                    $checked =  (in_array ($child->name, $tt ) )? "checked='checked'": "";
                    echo '<label><input ' .$checked . ' type="checkbox" name="'. $fieldName . '_' . $field_id. '[]" value="'.$child->name.'" />'.$child->name.'</label>';
                }
                //echo '</div>';
                echo '</div>';
                break;
        } // switch

    }
    echo '</div>';
}

 

 

Can you please help us?

 

Thank you

Link to comment
Share on other sites
Ch0cu3r Newbie

Ch0cu3r

Posted
Posted

There is no dropdown type for <input> in HTML. This just create a text field

echo '<input type="dropdown" name="'. $fieldName . '_' . $field_id . '" value="'. $children. '" style="width:20%" placeholder="Category" />';

To define a dropdown menu you use the <select></select> tags and then you add options to the menu using <option></option> tags. Example code for a menu

<select name="my_dropdown_menu">
    <option value"value1">Option 1</option>
    <option value"value2">Option 2</option>
    <option value"value3">Option 3</option>
    ... etc
</select>

if you want to allow the user to select multiple entries from the dropdown you add the   multiple attribute to the opening select tag, eg    <select name="my_dropdown_menu" multiple>

Link to comment
Share on other sites
dsillaman Newbie

dsillaman

Posted
  • Author
Posted

So we have gotten the drop down to work the way we want it to. However now we can't get the search results to query what is selected in the drop down box on the search page. We are currently running a buddypress website and need to be able to search by a caterory which is the selected in the drop down box and by city and state.  As it is right now the results we believe are not querying the drop down box. Here is the entire code for this. Can anybody out there please please help us.

 

<?php
/**
 * GMW FL search form function - Display xprofile fields
 * @version 1.0
 * @author Eyal Fitoussi
 */
function gmw_fl_fields_dropdown($gmw, $id, $class) {

    $total_fields = ( isset($gmw['profile_fields']) ) ? $gmw['profile_fields'] : array();
    if( isset($gmw['profile_fields_date']) ) array_unshift($total_fields, $gmw['profile_fields_date']);

    echo '<div id="'.$id.'" class="'.$class.'">';

    foreach ( $total_fields as $field_id ) {

        $field_data = new BP_XProfile_Field ($field_id);
        $fieldName = explode(' ', $field_data->name);
        $fieldName = preg_replace("/[^A-Za-z0-9]/","",$fieldName[0]);
        
        $get_field = (isset($_GET[$fieldName . '_' . $field_id])) ? $_GET[$fieldName . '_' . $field_id] : '';
        $get_field_to = (isset($_GET[$fieldName . '_' . $field_id. '_to'])) ? $_GET[$fieldName . '_' . $field_id. '_to'] : '';

        $children = $field_data->get_children ();

        switch ($field_data->type) {
            case 'datebox':
                echo '<div class="editfield field_'.$field_id.' datebox">';
                echo '<span class="label">Age Range (min - max)</span>';
                echo '<input size="3" type="text" name="'. $fieldName . '_' . $field_id.'" value="' . $get_field . '" placeholder="Min" style="width:10%" />';
                echo ' - ';
                echo '<input size="3" type="text" name="'. $fieldName . '_' . $field_id . '_to" value="' . $get_field_to . '" placeholder="Max" style="width:10%" />';
                echo '</div>';
                break;

            case 'multiselectbox':
            case 'selectbox':
                case 'selectbox':
                echo '<div class="field_'.$field_id.'selectbox">';
                echo '<span class="label">' . $field_data->name. '</span>';
                $tt = array();
                if($get_field) {
                    $tt = $get_field;
                    
                }
                echo '<select>';
                foreach ($children as $child) {
                    $child->name = trim ($child->name);
                    $checked =  (in_array ($child->name, $tt ) )? "checked='checked'": "";
                    
                    echo '<option ' .$checked . ' type="selectbox" name="'. $fieldName . '_' . $field_id. '[]" value="'.$child->name.'">'.$child->name.'</option>';
                    
                    //echo '<option value="'$checked . $child->name'"> . 'echo $child->name'</option>';
                    //echo '<input ' .$checked . ' type="selectbox" name="'. $fieldName . '_' . $field_id. '[]" value="'.$child->name.'" />'.$child->name.'</select>';
                }
                echo '</select>';
                echo '</div>';
                break;
            case 'radio':
            case 'checkbox':
                echo '<div class="editfield field_'.$field_id.' checkbox">';
                echo '<span class="label">' . $field_data->name. '</span>';
                $tt = array();
                if($get_field) {
                    $tt = $get_field;
                }
                //echo '<div class="wppl-checkboxes-wrapper">';
                foreach ($children as $child) {
                    $child->name = trim ($child->name);
                    $checked =  (in_array ($child->name, $tt ) )? "checked='checked'": "";
                    echo '<label><input ' .$checked . ' type="checkbox" name="'. $fieldName . '_' . $field_id. '[]" value="'.$child->name.'" />'.$child->name.'</label>';
                }
                //echo '</div>';
                echo '</div>';
                break;
        } // switch

    }
    echo '</div>';
}

/**
 * GMW FL Search results function - display map
 * @version 1.0
 * @author Eyal Fitoussi
 */
function gmw_fl_results_map($gmw) {
    if ( ( $gmw['results_type'] == "both" ) || ( $gmw['results_type'] == "map") )  :
        
        $frame = ( $gmw['map_frame'] == 1 ) ? 'gmw-map-frame' : '';
        $width = ( !empty($gmw['map_width']['value'] ) ) ? $gmw['map_width']['value'].$gmw['map_width']['units'] : '500px';
        $height = ( !empty($gmw['map_height']['value'] ) ) ? $gmw['map_height']['value'].$gmw['map_height']['units'] : '500px';
        
        echo '<div id="gmw-map-wrapper-'.$gmw['form_id'].'" class="gmw-map-wrapper gmw-fl-map-wrapper gmw-fl-map-wrapper-'.$gmw['form_id'].' '.$frame.'"  style="width:'.$width.';height:'.$height.';">';
        echo     '<div id="gmw-map-loader-wrapper-'.$gmw['form_id'].'" class="gmw-map-loader-wrapper gmw-fl-loader-wrapper">';
        echo         '<img id="gmw-map-loader-'.$gmw['form_id'].'" class="gmw-map-loader gmw-fl-map-loader" src="'.GMW_URL.'/images/map-loader.gif"/>';
        echo     '</div>';
        echo     '<div id="gmw-fl-map-'.$gmw['form_id'].'" class="gmw-map gmw-fl-map gmw-fl-map-'.$gmw['form_id'].'" style="width:100%; height:100%"></div>';
        echo '</div>';
    endif;
}

/**
 * GMW FL Search results function - adds elements to be display on the map
 * @version 1.0
 * @author Eyal Fitoussi
 */
function gmw_fl_map_elements() {
    global $members_template;
    $members_template->member->permalink = bp_get_member_permalink();
    $members_template->member->avatar = bp_get_member_avatar( $args = 'type=thumb' );
}
add_action('bp_directory_members_item', 'gmw_fl_map_elements', 10);

/**
 * GMW FL Search results function - Display user's full address
 * @version 1.0
 * @author Eyal Fitoussi
 */
function gmw_fl_user_address($gmw) {
    global $members_template;
    $address = $members_template->member->address;
    echo apply_filters('gmw_fl_has_members_loop_memebr_address', $address, $gmw, $members_template);
}

/**
 * GMW FL Search results function - Display Radius distance
 * @version 1.0
 * @author Eyal Fitoussi
 */
function gmw_fl_by_radius($gmw) {
    global $members_template;
    if ( isset( $gmw['your_lat'] ) && !empty( $gmw['your_lat'] ) ) echo '<div class="gmw-fl-radius-wrapper">' . $members_template->member->distance .' ' . $gmw['units_array']['name'] . '</div>';
}


/**
 * GMW FL search results function - Query xprofile fields
 * @version 1.0
 * @author Eyal Fitoussi
 * @author Some of the code in this function was inspired by the code written by Andrea Taranti the creator of BP Profile Search - Thank you
 */
function gmw_fl_query_fields($gmw) {
    global $bp, $wpdb;
    $total_fields = false;

    $total_fields = ( isset( $gmw['profile_fields'] ) ) ? $gmw['profile_fields'] : array();
    if( isset( $gmw['profile_fields_date'] ) && !empty( $gmw['profile_fields_date'] ) ) array_unshift( $total_fields, $gmw['profile_fields_date'] );

    if ( !isset($total_fields) || empty($total_fields) ) return;

    $empty_fields = array();
    $userids = false;

    foreach ($total_fields as $field_id) {

        $field_data = new BP_XProfile_Field ($field_id);
        $fieldName = explode(' ', $field_data->name);
        $fieldName = preg_replace("/[^A-Za-z0-9]/","",$fieldName[0]);
        $children = $field_data->get_children ();
        $value = ( isset($_GET[$fieldName . '_'. $field_id]) ) ? $_GET[$fieldName . '_'. $field_id] : '';
        $to = ( isset($_GET[$fieldName . '_' . $field_id. '_to']) ) ?  $_GET[$fieldName . '_' . $field_id. '_to'] : '';
            
        if ($value) array_push($empty_fields, $value);
            
        if( $value || $to ) {

        $sql = "SELECT user_id from {$bp->profile->table_name_data}";
            
            switch ($field_data->type) {
                    
                case 'selectbox':
                    $value = $_GET["field_$id"];
                    $sql = "SELECT user_id from {$bp->profile->table_name_data}";
                    $sql .= " WHERE field_id = $field_id ";
                    $tt = array();
                if($get_field) {
                    $tt = $get_field;
                    
                }
                    foreach ($children as $child)
                    $child->name = trim ($child->name);
                    {
                        $escaped = '%"'. like_escape ($wpdb->escape ($child)). '"%';
                        $tt[] = $wpdb->prepare ("value = %s OR value LIKE %s", $child, $escaped);
                    }    
                    $sql .= ' AND ('. implode (' OR ', $tt). ')';    
                    break;
                
                case 'multiselectbox':
                case 'checkbox':
                case 'radio':
                    
                    $sql = "SELECT user_id from {$bp->profile->table_name_data}";
                    $sql .= " WHERE field_id = $field_id ";
                    $like = array();
                    
                    foreach ($value as $curvalue)
                        $like[] = "value = '$curvalue' OR value LIKE '%\"$curvalue\"%' ";
                    $sql .= ' AND ('. implode (' OR ', $like). ')';
                break;
        
                case 'datebox':

                    $value = (!$value) ? '1': $value;
                    $to = (!$to) ? '200' : $to;
                    if ($to < $value)  $to = $value;

                    $time = time ();
                    $day = date ("j", $time);
                    $month = date ("n", $time);
                    $year = date ("Y", $time);
                    $ymin = $year - $to - 1;
                    $ymax = $year - $value;

                    $sql = "SELECT user_id from {$bp->profile->table_name_data}";
                    $sql .= " WHERE field_id = $field_id AND value > '$ymin-$month-$day' AND value <= '$ymax-$month-$day'";
                
                break;
            }//switch //

        $results = $wpdb->get_col($sql, 0);

            if ( !is_array($userids) ) $userids = $results; else $userids = array_intersect($userids, $results);

        } // if value //
    } // for eaech //

    /* build SQL filter from profile fields results - member ids array */
    if ( isset($userids) && !empty($userids) ) return $userids;
    /* if no results and profile fields are not empty - buba is going to stop the function */
    else if ( !empty($empty_fields) ) return "buba";
}


/**
 * GMW FL search results function - "Get directions" link
 * @version 1.0
 * @author Eyal Fitoussi
 */
function gmw_fl_get_directions($gmw) {
    global $members_template;
    if ( isset( $gmw['get_directions'] ) && $gmw['get_directions'] == 1 ) {
        if ( !isset($gmw['org_address']) ) $gmw['org_address'] = '';
        echo     '<a href="http://maps.google.com/maps?f=d&hl=en&doflg=' . $gmw['units_array']['map_units'] . '&geocode=&saddr=' .$gmw['org_address'] . '&daddr=' . str_replace(" ", "+", $members_template->member->address) . '&ie=UTF8&z=12" target="_blank">Get Directions</a>';
    }
}

/**
 * GMW FL search results function - display within distance message
 * @version 1.0
 * @author Eyal Fitoussi
 */
function gmw_fl_wihtin_message($gmw) {
    if ( !isset( $gmw['org_address'] ) || empty( $gmw['org_address'] ) ) return;
    echo ' <span>within '. $gmw['radius'] . ' ' . $gmw['units_array']['name'] .' from ' . $gmw['org_address'] .'</span>';
}

/**
 * GMW FL search results function - calculate driving distance
 * @version 1.0
 * @author Eyal Fitoussi
 */
function gmw_fl_driving_distance($gmw, $class) {
    global $members_template;
    if ( !isset($gmw['by_driving']) || $gmw['units_array']['name'] == false )
        return;

    echo     '<div id="gmw-fl-driving-distance-'.$members_template->member->ID . '" class="'.$class.'"></div>';
    ?>
    <script>   
        var directionsDisplay;
        var directionsService = new google.maps.DirectionsService();    
        var directionsDisplay = new google.maps.DirectionsRenderer();    
        
          var start = new google.maps.LatLng('<?php echo $gmw['your_lat']; ?>','<?php echo $gmw['your_long']; ?>');
          var end = new google.maps.LatLng('<?php echo $members_template->member->lat; ?>','<?php echo $members_template->member->long; ?>');
          var request = {
            origin:start,
            destination:end,
            travelMode: google.maps.TravelMode.DRIVING
         };
         
          directionsService.route(request, function(result, status) {
            if (status == google.maps.DirectionsStatus.OK) {
                              directionsDisplay.setDirections(result);
                  if ( '<?php echo $gmw['units_array']['name']; ?>' == 'Mi') {
                      totalDistance = (Math.round(result.routes[0].legs[0].distance.value * 0.000621371192 * 10) / 10)+' Mi';
                  } else {
                      totalDistance = (Math.round(result.routes[0].legs[0].distance.value * 0.01) / 10)+' Km';
                  }    
                  
                  jQuery('#<?php echo 'gmw-fl-driving-distance-'. $members_template->member->ID; ?>').text('Driving: ' + totalDistance)
            }
          });    
    </script>
    <?php    
}

/**
 * GMW FL Search results function - Per page dropdown
 * @version 1.0
 * @author Eyal Fitoussi
 */
function gmw_fl_per_page_dropdown($gmw, $class) {
    global $members_template;
    $perPage = explode(",", $gmw['per_page']);
    $lastpage = ceil($members_template->total_member_count/$gmw['get_per_page']);
        
    if ( count( $perPage) > 1 ) :
        echo '<select name="wppl_per_page" class="gmw-fl-per-page-dropdown '.$class.'">';
            foreach ( $perPage as $pp ) :
                if ( isset($_GET['wppl_per_page']) && $_GET['wppl_per_page'] == $pp ) $pp_s = 'selected="selected"'; else $pp_s = "";
                echo '<option value="'. $pp .'" '.$pp_s.'>'.$pp.' per page</option>';
            endforeach;
        echo '</select>';

    endif;
    ?>
    <script>
        jQuery(document).ready(function($) {
               $(".gmw-fl-per-page-dropdown").change(function() {
                   var totalResults = <?php echo $members_template->total_member_count; ?>;
                   var lastPage = Math.ceil(totalResults/$(this).val());
                   var newPaged = ( <?php echo $members_template->pag_num; ?> > lastPage ) ? lastPage : false;
                   //var seperator = (window.location.href.indexOf("?")===-1)?"?":"&";
                   window.location.href = jQuery.query.set("wppl_per_page", $(this).val()).set('upage', newPaged);
            });
        });
    </script>
<?php
}

/**
 * GMW FL function - Create filters for buddypress members query
 * @version 1.0
 * @author Eyal Fitoussi
 */
function gmwUserQueries( $gmw ) {
    global $wpdb;
    $gmwUserQueries['bp_user_query'] = false;
    $gmwUserQueries['wp_user_query'] = false;
    
    /*
     * prepare the filter of bp_query_user. the filter will modify the SQL function and will check the distance
     * of each user from the address entered and will results in user ID's of the users that within
     * the radius entered. The user IDs will then pass to the next wp_query_user below.
    */
    if ( !empty($gmw['org_address']) ) :
        /*
         * if address entered:
         * prepare the filter of the select clause of the SQL function. the function join Buddypress's members table with
         * wppl_friends_locator table, will calculate the distance and will get only the members that
         * within the radius was chosen
        */
        $gmwUserQueries['bp_user_query']['select']      = $wpdb->prepare( " SELECT gmwlocations.member_id as id,             
            ROUND( %d * acos( cos( radians( %s ) ) * cos( radians( gmwlocations.lat ) ) * cos( radians( gmwlocations.long ) - radians( %s ) ) + sin( radians( %s ) ) * sin( radians( gmwlocations.lat) ) ),1 ) AS distance ",
            $gmw['units_array']['radius'], $gmw['your_lat'], $gmw['your_long'], $gmw['your_lat'] );

        $gmwUserQueries['bp_user_query']['from']      = " FROM wppl_friends_locator gmwlocations";
        $gmwUserQueries['bp_user_query']['where']    = " WHERE 1 = 1 ";
        $gmwUserQueries['bp_user_query']['having']   = $wpdb->prepare('HAVING distance <= %d OR distance IS NULL ', $gmw['radius']);
        $gmwUserQueries['bp_user_query']['order_by'] = 'ORDER BY distance';
    else:
        /*
         * if no address entered choose all members that in members table and wppl_friends_locator table
         * check agains the useids (returned from xprofile fields query) if exist and results in ids
        */
        $gmwUserQueries['bp_user_query']['select']   = " SELECT gmwlocations.member_id as id ";
        $gmwUserQueries['bp_user_query']['where']    = " WHERE 1 = 1 ";
        $gmwUserQueries['bp_user_query']['from']      = " FROM wppl_friends_locator gmwlocations";
        $gmwUserQueries['bp_user_query']['order_by'] = "";
    endif;    
    /*
     * prepare the filter of the wp_query_user which is within bp_query_user.
     * the filter will modify the SQL function and will calculate the distance of each user
     * in the array of user IDs that was returned from the function above.
     * the filter will also add the members information from wppl_friends_locator table into the results
     * as well as the distance.
     */
    if ( !empty( $gmw['org_address'] ) ) :
        $gmwUserQueries['wp_user_query']['query_fields'] = $wpdb->prepare(" , gmwlocations.* ,
                                                                ROUND( %d * acos( cos( radians( %s ) ) * cos( radians( gmwlocations.lat ) ) * cos( radians( gmwlocations.long ) - radians( %s ) ) + sin( radians( %s ) ) * sin( radians( gmwlocations.lat) ) ),1 ) AS distance",
                                                                $gmw['units_array']['radius'], $gmw['your_lat'], $gmw['your_long'], $gmw['your_lat'] );
    else :
        $gmwUserQueries['wp_user_query']['query_fields'] = " , gmwlocations.* ";
    endif;
    $gmwUserQueries['wp_user_query']['query_from']     = " INNER JOIN wppl_friends_locator gmwlocations ON ID = gmwlocations.member_id ";

    return apply_filters('gmw_fl_after_query_clauses',$gmwUserQueries, $gmw);
}

/**
 * GMW FL function - Add filter to BP_user_query
 * @version 1.0
 * @author Eyal Fitoussi
 */
function gmwBpQuery( $gmwBpQuery ) {
    global $gmwUserQueries;
    /* modify the function to to calculate the total rows(members). */
    $gmwBpQuery->query_vars['count_total'] = 'sql_calc_found_rows';    
    $gmwBpQuery->uid_clauses['select']     = $gmwUserQueries['bp_user_query']['select'];
    $gmwBpQuery->uid_clauses['select']    .= $gmwUserQueries['bp_user_query']['from'];
    $gmwBpQuery->uid_clauses['where']      = $gmwUserQueries['bp_user_query']['where'];
    $gmwBpQuery->uid_clauses['where']     .= $gmwUserQueries['bp_user_query']['having'];
    $gmwBpQuery->uid_clauses['orderby']    = $gmwUserQueries['bp_user_query']['order_by'];
    
    return $gmwBpQuery;
}

/**
 * GMW FL function - Add filter to WP_user_query
 * @version 1.0
 * @author Eyal Fitoussi
 */
function gmwWpQuery( $gmwWpQuery ) {
    global $gmwUserQueries;
        
    $gmwWpQuery->query_fields .= $gmwUserQueries['wp_user_query']['query_fields'];
    $gmwWpQuery->query_from .= $gmwUserQueries['wp_user_query']['query_from'];

    return $gmwWpQuery;
}

/**
 * GMW FL results function - no members found
*/
function gmw_fl_no_members($gmw, $gmw_options) {
    $no_members = __('Sorry, No members found','GMW');
    echo apply_filters('gmw_fl_no_members_message', $no_members, $gmw);
}

/**
 * GMW FL function - include search form
 * @param $gmw
 * @param $gmw_options
 */
function gmw_fl_main_shortcode_search_form($gmw, $gmw_options) {
    do_action('gmw_fl_before_search_form', $gmw, $gmw_options);
    
    wp_enqueue_style( 'gmw-'.$gmw['form_id'].'-'.$gmw['form_template'].'-form-style', GMW_FL_URL. 'search-forms/'.$gmw['form_template'].'/css/style.css',99 );
    include GMW_FL_PATH .'search-forms/'.$gmw['form_template'].'/search-form.php';
    
    do_action('gmw_fl_after_search_form', $gmw, $gmw_options);
}
add_action('gmw_friends_main_shortcode_search_form', 'gmw_fl_main_shortcode_search_form', 15 , 2);

/**
 * GMW FL function - add xprofile fields query to results
 * @param $gmwUserQueries
 * @param $gmw
 *
 */
function gmw_fl_add_xprofile_query_to_results($gmwUserQueries, $gmw) {
    global $wpdb;
       $userids = gmw_fl_query_fields($gmw);
       if ( isset( $userids ) && !empty( $userids ) ) $gmwUserQueries['bp_user_query']['where'] .= $wpdb->prepare(" AND gmwlocations.member_id IN (".str_repeat("%d,", count( $userids ) -1) . "%d)", $userids );                                               
       return $gmwUserQueries;
}
add_filter('gmw_fl_after_query_clauses', 'gmw_fl_add_xprofile_query_to_results', 5, 2 );

/**
 * GMW FL function - display members count
 * @para  $gmw
 * @param $gmw_options
 */
function gmw_fl_member_count($gmw) {
    global $members_template, $mc;
    if ( !isset($mc) || empty($mc) ) if ( $members_template->pag_page == 1 ) $mc = 0; else $mc = ($members_template->pag_num * ($members_template->pag_page -1 ));
    $mc++;
    $members_template->member->mc = $mc;
    return $mc;
}

//Add functions after the loop
function gmw_fl_localize_members_to_map() {
    global $members_template;
    wp_localize_script( 'gmw-fl-map', 'flMembers', $members_template->members);
}

/**
 * GMW FL function - Display results for buddypress members
 * @version 1.0
 * @author Eyal Fitoussi
 */
function gmw_get_friends_results($gmw, $gmw_options) {
        global $gmwUserQueries;
        $gmw['get_per_page'] = ( isset($_GET['wppl_per_page']) ) ? $_GET['wppl_per_page'] : current(explode(",", $gmw['per_page']));
        
        echo '<div id="buddypress">';
        
        // Hooks
        $gmw = apply_filters('gmw_fl_settings_before_search_results', $gmw, $gmw_options);
        do_action('gmw_fl_before_search_results', $gmw, $gmw_options);
        
        // Run filters and queries
        $gmwUserQueries = gmwUserQueries($gmw);
        add_action( 'bp_pre_user_query', 'gmwBpQuery' );
        add_action( 'pre_user_query', 'gmwWpQuery' );

        $gmw_members_args = array(
            'type'        => 'distance',  
            'per_page' => $gmw['get_per_page'],
        );
        $gmw_members_args = apply_filters('gmw_fl_members_query_args', $gmw_members_args, $gmw);
        
        // if we need to display map
        if( $gmw['results_type'] != "posts" ) :
            // pass results to javascript to use to display the map and markers
            if ( !isset($gmw['map_controls']) || empty($gmw['map_controls']) ) $gmw['map_controls'] = false;
        
            $gmw = apply_filters('gmw_fl_settings_before_map', $gmw, $members_template, $gmw_options);
            $members_template = apply_filters('gmw_fl_posts_loop_before_map', $members_template, $gmw, $gmw_options);
                
            do_action('gmw_fl_has_members_before_map_displayed', $gmw, $gmw_options, $members_template);
        
            wp_enqueue_script( 'gmw-fl-map', true);
            wp_localize_script( 'gmw-fl-map', 'flMapArgs', $gmw);        
            add_action('member_loop_end','gmw_fl_localize_members_to_map', 10);
        endif;
        
        // include custom results and stylesheet pages from child/theme
        if( strpos($gmw['results_template'], 'custom_') !== false ) :
            
            $sResults = str_replace('custom_','',$gmw['results_template']);
            wp_register_style( 'gmw-current-style', get_stylesheet_directory_uri() . '/geo-my-wp/friends/search-results/'.$sResults.'/css/style.css' );
            wp_enqueue_style( 'gmw-current-style');
                    
            include(STYLESHEETPATH. '/geo-my-wp/friends/search-results/'.$sResults.'/results.php');
        //include results and stylesheet pages from plugin's folder
        else :
            wp_register_style( 'gmw-current-style', GMW_FL_URL. 'search-results/'.$gmw['results_template'].'/css/style.css' );
            wp_enqueue_style( 'gmw-current-style');
            include GMW_FL_PATH . 'search-results/'.$gmw['results_template'].'/results.php';
        endif;
                        
        echo '</div>';
}
add_action('gmw_friends_form_submitted_latlong', 'gmw_get_friends_results', 10, 2);
add_action('gmw_friends_form_submitted_address_not', 'gmw_get_friends_results', 10, 2);
add_action('gmw_friends_results_auto_results', 'gmw_get_friends_results', 10, 2);

Link to comment
Share on other sites
dsillaman Newbie

dsillaman

Posted
  • Author
Posted 
function gmw_fl_query_fields($gmw) {
	global $bp, $wpdb;
	$total_fields = false;

	$total_fields = ( isset( $gmw['profile_fields'] ) ) ? $gmw['profile_fields'] : array();
	if( isset( $gmw['profile_fields_date'] ) && !empty( $gmw['profile_fields_date'] ) ) array_unshift( $total_fields, $gmw['profile_fields_date'] );

	if ( !isset($total_fields) || empty($total_fields) ) return;

	$empty_fields = array();
	$userids = false;

	foreach ($total_fields as $field_id) {

		$field_data = new BP_XProfile_Field ($field_id);
		$fieldName = explode(' ', $field_data->name);
		$fieldName = preg_replace("/[^A-Za-z0-9]/","",$fieldName[0]);
		$children = $field_data->get_children ();
		$value = ( isset($_GET[$fieldName . '_'. $field_id]) ) ? $_GET[$fieldName . '_'. $field_id] : '';
		$to = ( isset($_GET[$fieldName . '_' . $field_id. '_to']) ) ?  $_GET[$fieldName . '_' . $field_id. '_to'] : '';
			
		if ($value) array_push($empty_fields, $value);
			
		if( $value || $to ) {
			
			switch ($field_data->type) {
					
				case 'selectbox':
					$value = $_GET["field_$id"];
					$sql = "SELECT user_id from {$bp->profile->table_name_data}";
					$sql .= " WHERE field_id = $field_id ";
					$tt = array();
				if($get_field) {
					$tt = $get_field;
					
				}
					foreach ($children as $child) 
					$child->name = trim ($child->name);
					{
						$escaped = '%"'. like_escape ($wpdb->escape ($child)). '"%';
						$tt[] = $wpdb->prepare ("value = %s OR value LIKE %s", $child, $escaped);
					}	
					$sql .= ' AND ('. implode (' OR ', $tt). ')';	
					break;
				
				case 'multiselectbox':
				case 'checkbox':
				case 'radio':
					
					$sql = "SELECT user_id from {$bp->profile->table_name_data}";
					$sql .= " WHERE field_id = $field_id ";
					$like = array();
					
					foreach ($value as $curvalue)
						$like[] = "value = '$curvalue' OR value LIKE '%\"$curvalue\"%' ";
					$sql .= ' AND ('. implode (' OR ', $like). ')';
				break;
		
				case 'datebox':

					$value = (!$value) ? '1': $value;
					$to = (!$to) ? '200' : $to;
					if ($to < $value)  $to = $value;

					$time = time ();
					$day = date ("j", $time);
					$month = date ("n", $time);
					$year = date ("Y", $time);
					$ymin = $year - $to - 1;
					$ymax = $year - $value;

					$sql = "SELECT user_id from {$bp->profile->table_name_data}";
					$sql .= " WHERE field_id = $field_id AND value > '$ymin-$month-$day' AND value <= '$ymax-$month-$day'";
				
				break;
			}//switch //

		$results = $wpdb->get_col($sql, 0);

			if ( !is_array($userids) ) $userids = $results; else $userids = array_intersect($userids, $results);

		} // if value //
	} // for eaech //

	/* build SQL filter from profile fields results - member ids array */
	if ( isset($userids) && !empty($userids) ) return $userids;
	/* if no results and profile fields are not empty - buba is going to stop the function */
	else if ( !empty($empty_fields) ) return "buba";

We currently have the options we want inside the drop down box however we can't it to query the search based on what is selected inside in the drop down box. We think our problem is somewhere inside the case 'selectbox' where we are trying to define the search query if a select box present. Can anyone please help us?

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.