@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('stkpdt.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">ชื่อสินค้า</td>
                                <td class="text-left">Size</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)
                            @else
                            <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->xvpdtcode }}</td>
                                <td class="text-left">{{ $item->xvpdtname }}</td>
                                <td class="text-left">{{ $item->xvpszname }}</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->xistkqty}}</td> --}}
                                {{-- <td class="text-center">{{$item->xistkqtyuse}}</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('stkpdt.index', ['xvpdtcode' => 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->xvpdtcode }}</td>
                                        <td class="text-center">{{ $item->xvpdtname }}</td>
                                        <td class="text-center">
                                            <form action="{{ route('stkpdt.index') }}" method="get">
                                                <input type="hidden" name="xvpdtcode" value="{{ $item->xvpdtcode }}">
                                                <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('stkpdt.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="xvpdtcode" value="{{ $xvpdtcode ?? 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 xvpdtcode = "{{ $xvpdtcode }}";
        const today = new Date();
        const date = today.getDate() + '-' + (today.getMonth() + 1) + '-' + today.getFullYear();

        if (DateStart == "" && DateEnd == "") {
            DateStart = "ทั้งหมด";
            DateEnd = "ทั้งหมด";
        }
        if (xvpdtcode == "") {
            xvpdtcode = "ทั้งหมด";
        } else {
            xvpdtcode = xvpdtcode + ' : {{ $item->xvpdtname ?? '' }}';
        }
        let title = `รายงานความเคลื่อนไหวสินค้า`
        console.log(DateStart);
        $('#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: `จากรหัสสินค้า ${xvpdtcode} วันที่ ${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>