Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

AJAX filled Select2 not clickable

I'm using Select2 for a project. The second select box gets filled depending on the selected item in the first box, as shown in the link below. However, I can't click the first item in the second select box for some reason. The only way for me to select the first item if I want to, is to first select a different user, and then back to the first. How can I solve this?

Video:

enter image description here

My code:

This is the first select box, getting filled by regular PHP (Laravel). Everything works fine here.

<div class="form-group">
    <label for="select"> Partner: </label>
    <select id="select" name="select" class="searchselect searchselectstyle">
        @foreach($partners as $i => $partner)
            <option {{$i == 0 ? 'selected' : ''}} value="{{$partner->id}}">{{$partner->name}}</option>
        @endforeach
    </select>
</div>

Here Is the second select box, with the error.

<div class="form-group" >
    <label for="select2"> Hoofdgebruiker: </label>
    <select id="select2" style="min-width: 200px;" name="select2" class="searchselect searchselectstyle">

    </select>
</div>


<script type="text/javascript">
$(document).ready(function(){
    var url = '/json/getusers';
    var $post = {};
    $post.id = $("select").val();

    $.ajax({
        type: "POST",
        dataType: "json",
        url: url,
        data: $post,
        cache: false
    }).done(function(data){
                $('#select2')
                        .find('option')
                        .remove()
                        .end();

                $.each(data, function(i, value) {
                    console.log(data);
                    $('#select2').append($('<option>').text(value.text).attr('value', value.id));
                });
            }
    );
});

-

public function getusers(){
    if(!isset($_POST['term'])){
        $users = User::where('partner_id', $_POST['id'])->get();
    }else{
        $wildcard = '%'.$_POST['term'].'%';
        $users = User::where('partner_id', $_POST['id'])->where('email', 'LIKE',  $wildcard)->get();
    }

    $array = array();

    foreach($users as $i => $user){
        $array[$i] = array("id" => $user->id, "text" => $user->email);
    }
    return response()->json($array);
}
like image 285
Markinson Avatar asked Feb 21 '16 19:02

Markinson


2 Answers

Check the case sensitivity of the key "id" in json data. Probably you return "ID" insteat of "id".

{"results":[{"id":"3","text":"Exampe 3"},{"id":"4","text":"Example 4"},{"id":"16","text":"Example 16"}]}

not like that

{"results":[{"ID":"3","text":"Exampe 3"},{"ID":"4","text":"Example 4"},{"ID":"16","text":"Example 16"}]}
like image 135
yikekas Avatar answered Oct 28 '22 13:10

yikekas


I found a solution, which is the following:

<script type="text/javascript">
    $(document).ready(function() {
        $(".searchselect").select2();

        search();
        $("#select").change(function(){
            search();
        });
    });

    function search(){
        var $post = {};
        $post.id = $("#select").val();
        $("#select2").select2({
            ajax: {
                dataType: "json",
                type: "POST",
                data: function (params) {
                    var query = {
                        term: params.term,
                        id: $post.id
                    };
                    return query;
                },
                url: '/json/getusers',
                cache: false,
                processResults: function (data) {
                    return {
                        results: data
                    };
                }
            }
        });
    }
</script>

Now I'm using the regular AJAX functionality built in Select2, it is all working as expected now!

like image 1
Markinson Avatar answered Oct 28 '22 14:10

Markinson