@extends('layouts.master')
@section('content')
    <div class="card">
        <div class="card-body">
            <div class="row">
                <div class="col-3">
                    <h5 style="font-weight: bold;">รายการความเคลื่อนไหวของวัสดุ</h5>
                </div>
                <div class="col-1 text-left">
                    <a type="submit" class="btn btn-primary" data-toggle="modal" data-target="#exampleModalCenter">Filter
                        วัสดุ</a>

                </div>
                <div class="col-1 text-left">
                    <a type="submit" class="btn " style="background-color: #FFA500" data-toggle="modal"
                        data-target="#ModalTimeless">Filter
                        วันที่</a>
                </div>
                @if ($monthWithoutBalance)
                    <form action="{{ route('stk.balance') }}" method="POST" style="margin: 0">
                        @csrf
                        <div class="col-1 text-left">
                            <input type="hidden" class="form-control" id="StockBalance" name="StockBalance">
                        </div>

                        <div class="col-1 text-left">
                            <button type="submit" class="btn "
                                style="background-color:  #17A2B8">ทำรายการยอดยกมา</button>
                        </div>
                    </form>
                @endif
            </div>
            <hr>
            <div class="row mt-5">
                <div class="col-12 table-responsive ">
                    <table id="tb_mat" class="table table-striped mt-5">
                        <thead class="thead-light">
                            <tr>

                                <td class="text-left">รหัส</td>
                                <td class="text-left">วันที่</td>
                                <td class="text-left">ประเภท</td>
                                <td class="text-left">รหัสวัสดุ</td>
                                <td class="text-left">Item ID</td>
                                <td class="text-left">ชื่อวัสดุ</td>
                                <td class="text-right">จำนวนรับ</td>
                                <td class="text-right">จำนวนเบิก</td>
                                <td class="text-right">คงเหลือ</td>
                                {{--                            <td class="text-center">จำนวนคงเหลือ</td> --}}
                                <td class="text-right">ราคา/หน่วย</td>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($HD as $key => $item)
                                @if ((is_null($item->XFINWha) ? 0 : $item->XFINWha->Sumxistkqtyleft)!=0 || ($item->xvstktype == 0 || $item->xvstktype == 5 || $item->xvstktype == 6 ))
                                <tr>
                                    <td class="text-left">{{ $item->xvstkdocno }}</td>
                                    <td class="text-left">{{ date_YmdTodmY($item->xdstkdate) }}</td>
                                    <td class="text-left">{{ getTextStockCardByCode($item->xvstktype) }}</td>
                                    <td class="text-left">{{ $item->xvmatcode }}</td>
                                    <td class="text-left">{{ $item->xvmatid }}</td>
                                    <td class="text-left">{{ $item->xvmatname }}</td>
                                    <td class="text-right">
                                        @if ($item->xvstktype == 0 || $item->xvstktype == 1 || $item->xvstktype == 5)
                                            {{ $item->xistkqty }}
                                        @else
                                            -
                                        @endif
                                    </td>
                                    <td class="text-right">
                                        @if ($item->xvstktype == 2 || $item->xvstktype == 6)
                                            {{ $item->xistkqty }}
                                        @else
                                            -
                                        @endif
                                    </td>
                                    {{--                                <td class="text-center">{{$item->xistkqtyleft}}</td> --}}
                                    <td class="text-right">
                                        {{ number_format(is_null($item->XFINWha) ? 0 : $item->XFINWha->Sumxistkqtyleft, 2) }}
                                    </td>
                                    <td class="text-right">{{ number_format($item->xfstkcost, 2) }}</td>

                                </tr>
                                @endif
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
    <!-- Modal -->
    <div class="modal fade" id="exampleModalCenter" tabindex="-1" role="dialog" aria-labelledby="exampleModalCenterTitle"
        aria-hidden="true">
        <div class="modal-dialog modal-dialog-centered modal-lg " role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="exampleModalLongTitle">เลือกรายการความเคลื่อนไหวของวัสดุ</h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body">
                    <div class="table-responsive">
                        <table id="tb_mat_second" class="table table-striped table-hover responsive" width="100%">
                            <thead class="thead-light">
                                <tr>
                                    <td class="text-center" width="10%">รหัสวัสดุ</td>
                                    <td class="text-center" width="70%">ชื่อวัสดุ</td>
                                    <td class="text-center" width="10%"></td>
                                </tr>
                            </thead>
                            <tbody>
                                <tr>
                                    <td class="text-center">-</td>
                                    <td class="text-center">ทั้งหมด</td>
                                    <td class="text-center">
                                        <a href="{{ route('stk.index', ['xvmatcode' => null]) }}" class="btn btn-success"><i
                                                class="fas fa-store"></i></a>
                                    </td>

                                </tr>
                                @foreach ($HDMat as $key => $item)
                                    <tr>
                                        <td class="text-center">{{ $item->xvmatcode }}</td>
                                        <td class="text-center">{{ $item->xvmatname }}</td>
                                        <td class="text-center">
                                            <form action="{{ route('stk.index') }}" method="get">
                                                <input type="hidden" name="xvmatcode" value="{{ $item->xvmatcode }}">
                                                <input type="hidden" name="DateStart" value="{{ $DateStart }}">
                                                <input type="hidden" name="DateEnd" value="{{ $DateEnd }}">
                                                <button type="submit" class="btn btn-success">
                                                    <i class="fas fa-store"></i>
                                                </button>
                                            </form>

                                        </td>

                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="modal fade" id="ModalTimeless" tabindex="-1" role="dialog" aria-labelledby="exampleModalCenterTitle"
        aria-hidden="true">
        <div class="modal-dialog modal-dialog-centered modal-lg " role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="exampleModalLongTitle">เลือกช่วงวันที่ต้องการค้นหา</h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body">
                    <form action="{{ route('stk.index') }}" method="get">
                        <div class="col-12 ">
                            <div class="row mt-3">
                                <p style="max-width: 100px;min-width: 100px;" class="ml-3 mt-3 pr-2 text-right">
                                    ตั้งแต่วันที่</p>
                                <input class="form-control" type="date" name="DateStart" id="DateStart"
                                    @if (isset($DateStart) && $DateStart != null) value="{{ $DateStart }}" @else value="" @endif
                                    style="max-width: 180px;min-width: 180px;">
                                <p style="max-width: 100px;min-width: 100px;" class="ml-3 mt-3  pr-2 text-right">
                                    ถึงวันที่</p>
                                <input class="form-control" type="date" name="DateEnd" id="DateEnd"
                                    @if (isset($DateEnd) && $DateEnd != null) value="{{ $DateEnd }}" @else value="" @endif
                                    style="max-width: 180px;min-width: 180px;">
                            </div>
                        </div>
                        <input type="hidden" name="xvmatcode" value="{{ $xvmatcode ?? null }}">

                        <div class="modal-footer">
                            <input type="submit" class="btn btn-success" value="ค้นหา" />
                        </div>
                    </form>

                </div>
            </div>
        </div>
    </div>
    <input type="hidden" name="msg" value="{{ session()->get('msg') }}">
    <input type="hidden" id="url" value="{{ url('') }}">
@endsection
<style>
    #tb_mat thead {
        font-weight: bold;
    }

    #tb_mat tbody {
        font-size: 14px;
    }

    #tb_mat tbody tr:hover {
        background-color: azure;
    }

    #tb_mat tbody td {
        height: 35px;
        vertical-align: middle;
        cursor: pointer;
    }

    #tb_mat_filter {
        margin-bottom: 1cm;
        margin-top: 0.3cm;
    }
</style>
<script src="{{ asset('js/ThbNumber.js') }}"></script>
<script src="{{ asset('js/jquery-3.5.1.min.js') }}"></script>
<script src="{{ asset('js/sweetalert.min.js') }}"></script>
<script src="{{ asset('js/pdfmake.js') }}"></script>
<script type="text/javascript" src="https://cdn.datatables.net/buttons/1.7.0/js/dataTables.buttons.min.js" defer>
</script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js" defer></script>
<script type="text/javascript" src="https://cdn.datatables.net/buttons/1.7.0/js/buttons.html5.min.js" defer></script>
{{-- <script src="{{ asset('js/buttons.html5.min.js') }}" defer></script> --}}
{{-- <script src="{{ asset('js/jszip.min.js') }}" defer></script> --}}
{{-- <script src="{{ asset('js/dataTables.buttons.min.js') }}" defer></script> --}}
<script>
    $(document).ready(function() {

        Date.prototype.toDateInputValue = (function() {
            var local = new Date(this);
            local.setMinutes(this.getMinutes() - this.getTimezoneOffset());
            return local.toJSON().slice(0, 10);
        });
        let startVal = document.getElementById('DateStart').value
        let endVal = document.getElementById('DateEnd').value
        if (startVal) {
            document.getElementById('DateStart').value = startVal
        } else {
            document.getElementById('DateStart').value = new Date().toDateInputValue();
        }
        if (endVal) {
            document.getElementById('DateEnd').value = endVal
        } else {
            document.getElementById('DateEnd').value = new Date().toDateInputValue();
        }
        var DateStart = "{{ $DateStart }}";
        var DateEnd = "{{ $DateEnd }}";
        var xvmatcode = "{{ $xvmatcode }}";
        if (DateStart == "" && DateEnd == "") {
            DateStart = "ทั้งหมด";
            DateEnd = "ทั้งหมด";
        }
        if (xvmatcode == "") {
            xvmatcode = "ทั้งหมด";
        } else {
            xvmatcode = xvmatcode + ' : {{ $item->xvmatname ?? '' }}'
        }
        let title = `รายงานความเคลื่อนไหววัสดุ `
        $('#tb_mat').DataTable({
            "order": [],
            "language": {
                "search": "ค้นหา"
            },
            dom: 'Bfrtip',

            buttons: [{
                extend: 'excelHtml5',
                text: '<i class="fas fa-file-excel"></i> EXCEL', //u can define a diferent text or icon
                autoFilter: true,
                sheetName: 'Exported data',
                title: title.trim(),
                messageTop: `จากรหัสวัสดุ ${xvmatcode} วันที่ ${DateStart} ถึง ${DateEnd}`,
            }],
            "initComplete": function(settings, json) {
                $('.buttons-html5')
                    .removeClass()
                    .addClass('btn btn-outline-success');
            }
        });
        $('#tb_mat_second').DataTable({
            "language": {
                "search": "ค้นหา"
            },
        });


        if ($('input[name="msg"]').val() == 'success') {
            swal("บันทึกข้อมูลเรียบร้อย", "คลิก ตกลง", "success");
        }
        if ($('input[name="msg"]').val() == 'warning') {
            swal('มีรหัส Material นี้แล้ว', "กรุณาตั้งรหัส Material ใหม่", "warning")
        }
        if ($('input[name="msg"]').val() == 'error_duplicate') {
            swal('มีรหัส Unit นี้แล้ว', "กรุณาตั้งรหัส Unit ใหม่", "warning")
        }
        if ($('input[name="msg"]').val() == 'NoDataFound') {
            swal('กรุณาเลือกประเภท Unit ', "กรุณาเลือกประเภท Unit ของ Material", "warning")
        }
        if ($('input[name="msg"]').val() == 'NoDataFound_Factor') {
            swal('กรุณากรอกจำนวนสินค้าของประเภท Unit', "กรุณากรอกจำนวนสินค้าของประเภท Unit", "warning")
        }
        // New
        if ($('input[name="msg"]').val() == 'error_notfound') {
            swal('ไม่พบข้อมูล', "ไม่พบข้อมูลรายการแก้ไขที่เลือก", "warning")
        }
        if ($('input[name="msg"]').val() == 'cantrefapprove') {
            swal("ไม่สามารถใช้เอกสาร PO ที่เลือกเพื่อทำใบเอกสาร GR ได้กรุณายืนยันใบ PO ก่อนสั่ง", "คลิก ตกลง",
                "success");
        }
        else
        {
            if($('input[name="msg"]').val()!="")
            {
                swal($('input[name="msg"]').val(), "คลิก ตกลง", "warning");
            }
          
        }
       

    })
</script>