@php
    use Illuminate\Support\Facades\DB;
    $Material = DB::table('tmstmmaterial');
    $Material->where('xbisactive', 1);
    if(isset($WhereType) && isset($ValueWhere) && isset($operator)){
        $Material->where($WhereType,$operator,$ValueWhere);

    }
    $Material = $Material->orderBy('xvmatcode','desc')->get()->toArray();
    foreach ($Material as $item){
            $item->unit = DB::table('tmstmmat_unit')
            ->where('xvmatcode','=',$item->xvmatcode)

            ->join('tmstmunit', 'tmstmmat_unit.xvuntcode', 'tmstmunit.xvuntcode')
            ->get()->toArray();
    }
@endphp

<style>
    .select2-results__option[aria-selected=true] {
        display: none;
    }

    .select2-results__option--selected {
        display: none;
    }

    .select2-selection__choice {
        display: none;
    }
</style>
<select class="form-control " id="SelectMaterial" name="SelectMaterial" style="width:100%;"
        multiple="multiple">
    <option></option>

    @foreach ($Material as $key => $item)
        <option value="{{$item->xvmatcode}}" data-UnitType="{{json_encode($item->unit)}}"
                data-img="{{$item->xvmatpic}}"> {{$item->xvmatcode}} :{{ $item->xvmatid }} : {{$item->xvmatname}}</option>
    @endforeach
</select>
<script>
    $(document).ready(function () {
        var s2 = $('#SelectMaterial').select2({
            placeholder: "กรุณาเลือกวัสดุ",
            theme: 'bootstrap4',
        });

    })
</script>