@php
    use Illuminate\Support\Facades\DB;
    $a = DB::table('tstktmatstockcard')
        ->groupBy('xvmatcode')
        ->selectRaw('SUM(xistkqtyleft) AS somme, xvmatcode');
    $b = DB::table('tstktmatstockincoming')
        ->groupBy('xvmatcode')
        ->selectRaw('SUM(xistkqty) AS bsomme, xvmatcode');

    $Material = DB::table('tmstmmaterial')
        ->select('tmstmmaterial.*', 'a.somme', 'b.bsomme')

        ->leftJoin(DB::raw("({$a->toSql()}) AS a"), 'a.xvmatcode', '=', 'tmstmmaterial.xvmatcode')
        ->leftJoin(DB::raw("({$b->toSql()}) AS b"), 'b.xvmatcode', '=', 'tmstmmaterial.xvmatcode')
        ->whereRaw('IFNULL(a.somme,0) + IFNULL(b.bsomme,0) > 0')
        ->where('xvmtycode', 'MatType-003')
        ->where('xbisactive', '1');


    $Select = false;
    $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();
    }

    $supplier = DB::table('tmstmsupplier')
        ->orderBy('XVSplCode', 'desc')
        ->get();

    $group = DB::table('TMstMMatGroup')
        ->orderBy('xvmgpcode', 'desc')
        ->get()
        ->toArray();
@endphp

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

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

    .select2-selection__choice {
        display: none;
    }
</style>
<h4>
    <strong>วัสดุผ้า</strong>
</h4>
<div class="p-2 border mb-2">
    <div class="row mb-2">
        <div class="col text-left">
            <H5>
                ตัวเลือกการค้นหา
            </H5>
        </div>
    </div>
    <div class="row">
        <label class="col-md-3  col-xl-2 col-form-label text-left">ผู้จัดจำหน่าย</label>

        <div class="col-xl-5">
            <select class="form-control" id="SelectSupplierForCloth" @if (isset($isMultiple) && $isMultiple == true) multiple @endif
                @if (isset($isRequired) && $isRequired == true) required @endif @if (isset($isReadOnly) && $isReadOnly == true) readonly @endif
                name="XVSplCode">
                <option></option>
                <option value="null">เลือกทั้งหมด</option>
                @foreach ($supplier as $key => $item)
                    <option data-raw="{{ json_encode($item) }}" @if (isset($oldValue) && $oldValue == $item->XVSplCode) selected @endif
                        value="{{ $item->XVSplCode }}">{{ $item->XVSplCode }} {{ $item->XVSplName }}
                    </option>
                @endforeach
            </select>
        </div>
        {{-- <div class="col-3">
        <button class="btn" type="button" onclick="claer()">เลือกทั้งหมด</button>
    </div> --}}

    </div>
    <div class="row">
        <label class="col-md-3  col-xl-2 col-form-label text-left">กลุ่ม</label>
        <div class="col-xl-5">

            <select class="form-control " id="SelectMaterialGroupForCloth" style="width:100%;"
                @if (isset($isMultiple) && $isMultiple == true) multiple @endif @if (isset($isRequired) && $isRequired == true) required @endif
                name="SelectMaterialGroup">
                <option></option>
                <option value="null">เลือกทั้งหมด</option>
                @foreach ($group as $key => $item)
                    <option @if (isset($oldValue) && $oldValue == $item->xvmgpcode) selected @endif value="{{ $item->xvmgpcode }}">
                        {{ $item->xvmgpcode }} - {{ $item->xvmgpname }}</option>
                @endforeach
            </select>
        </div>
    </div>
</div>

<select class="form-control " id="SelectMaterialForCloth" name="SelectMaterialForCloth" style="width:100%;"
    multiple="multiple">
    <option></option>

    @foreach ($Material as $key => $item)
        @foreach ($oldDT ?? [] as $items)
            @php

                if ($item->xvmatcode == $items->xvmatcode) {
                    $Select = true;
                }
            @endphp
        @endforeach
        <option value="{{ $item->xvmatcode }}" data-UnitType="{{ json_encode($item->unit) }}"
            @if ($Select) selected @endif data-img="{{ $item->xvmatpic }}"> {{ $item->xvmatcode }}
            : {{ $item->xvmatid }}: {{ $item->xvmatname }}
        </option>
        @php
            $Select = false;
        @endphp
    @endforeach
</select>
<script>
    $(document).ready(function() {

        var s2 = $('#SelectMaterialForCloth').select2({
            placeholder: "กรุณาเลือกวัสดุ",
            theme: 'bootstrap4',
            closeOnSelect: false,
        });




        $('#SelectSupplierForCloth').select2({
            placeholder: "เลือกผู้จำหน่าย",
            theme: 'bootstrap4',
        });


        $('#SelectMaterialGroupForCloth').select2({
            placeholder: "เลือกกลุ่มวัสดุ",
            theme: 'bootstrap4',
        });
        $('#SelectSupplierForCloth').on('select2:select', function(e) {
            $("#SelectMaterialForCloth").empty();
            search3();

        });
        $('#SelectMaterialGroupForCloth').on('select2:select', function(e) {
            $("#SelectMaterialForCloth").empty();
            search3();

        });


    });

    function search3() {

        var SelectGrup = $("#SelectMaterialGroupForCloth").select2('val');
        var SelectID = null;
        var SelectSupplier = $("#SelectSupplierForCloth").select2('val');
        var url = "