@php
    use Illuminate\Support\Facades\DB;
    $MasterItems = DB::table('tmstmproductsize')->join('tmstmproduct','tmstmproductsize.xvpdtcode','=','tmstmproduct.xvpdtcode');

    $MasterItems = $MasterItems->orderBy('tmstmproductsize.xvpdtcode','desc')->get()->toArray();

    foreach ($MasterItems as $item){
        $qty = DB::table('tstktmatstockcardproduct')
        ->where('xvpdtcode','=',$item->xvpdtcode)
        ->where('xvpszname','=',$item->XVPszName)
        ->select(DB::raw('SUM(xistkqtyleft) as SumQty'))
        ->first();
        $item->SumQty = $qty->SumQty ?? 0;
    }

    //dd($MasterItems);
    //foreach ($MasterItems as $item){
    //        $item->size = DB::table('tmstmproductsize')
    //        ->where('xvpdtcode','=',$item->xvpdtcode)
    //        ->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="SelectMasterItemsSize" name="SelectMasterItemsSize"
        multiple="multiple">
    <option></option>
    @foreach ($MasterItems as $key => $item)
        <option value="{{$item->xvpdtcode}}_{{$item->XVPszName}}" data-size="{{$item->XVPszName}}" data-stockqty="{{$item->SumQty}}"> {{$item->xvpdtcode}} : {{$item->xvpdtname}} : Size {{$item->XVPszName}} </option>
    @endforeach
</select>


<script>
    $(document).ready(function () {
        var s2 = $('#SelectMasterItemsSize').select2({
            placeholder: "กรุณาเลือก Master Items",
            theme: 'bootstrap4',
        });

    })
</script>