@extends('layouts.admin')

@section('title', env('APP_NAME') . ' | Scan รับงานฟอก')

@section('content')
    <form action="{{ route('admin.planbook.backup') }}" method="POST" enctype="multipart/form-data">
        @csrf
        <div class="card">
            <div class="card-body">
                <div class="row">
                    <div class="col-sm-5">
                        <h4 class="card-title mb-0">
                            ข้อมูลเก่า(Box)
                        </h4>
                    </div>
                    <!--col-->
                    <div class="col-sm-7 pull-right">
                        <div class="btn-toolbar float-right">
                            <button class="btn btn-success ml-1" type="button" data-toggle="tooltip" title="เพิ่มข้อมูล"
                                onclick="myFunction()"> เรียกคืน</button>
                            {{-- <a href="{{ route("admin.planbook.backup") }}" class="btn btn-success ml-1" data-toggle="tooltip" title="เพิ่มข้อมูล"><i class="fas fa-plus-circle"> Backup</i></a> --}}
                        </div>
                        {{-- <div class="btn-toolbar float-right">
                        <a href="{{ url('admin/order/report') }}" class="btn btn-info ml-2" data-toggle="tooltip" title="พิมพ์"><i class="fas fa-print"></i></a>
                    </div> --}}
                    </div>
                    <!--col-->
                    <div class="col-sm-7 pull-right">
                    </div>
                    <!--col-->
                </div>
                <!--row-->
                <div class="row ">
                    <div class="col-12 d-flex flex-row p-2">
                        <div style="vertical-align: text-bottom;"> ค้นหาจากวันที่</div>
                        <div class="col-2">
                            <input type="date" class="form-control " id="min" name="min">
                        </div>
                        <div style="vertical-align: text-bottom;"> ถึง</div>
                        <div class="col-2 ">
                            <input type="date" class="form-control" id="max" name="max">
                        </div>
                        <div style="display:none">สถานะเอกสาร</div>
                        <div class="col-1" style="display:none">
                            <select class="form-control col-12" aria-label="Default select example" id="ConditionChoie">
                                <option value="Noactive" selected>Active</option>
                                {{-- <option value="BackUp"> Backup</option> --}}
                                <option value="ALL"> ALL</option>
                            </select>
                        </div>
                        <button id="filterSubmit" type="button" class="btn btn-success ml-1"> ค้นหา</button>
                    </div>
                </div>

                <div class="row mt-4">
                    <div class="col">
                        <div class="table-responsive ">
                            <table class="table display" id="datatable" style="width:100%">
                                <thead>
                                    <tr>

                                        <th>เลขที่ PO</th>
                                        <th>เลขที่ PO</th>
                                        <th>Item Number</th>
                                        <th>Item Name</th>
                                        <th>Backup</th>
                                    </tr>
                                </thead>
                            </table>
                        </div>
                    </div>
                    <!--col-->
                </div>
                <!--row-->
                <div class="row">
                    <div class="col-7">
                        <div class="float-left">
                            {{-- {!! $roles->total() !!} {{ trans_choice('labels.backend.access.roles.table.total', $roles->total()) }} --}}
                        </div>
                    </div>
                    <!--col-->
                    <div class="col-5">
                        <div class="float-right">
                            {{-- {!! $roles->render() !!} --}}
                        </div>
                    </div>
                    <!--col-->
                </div>
                <!--row-->
            </div>
            <!--card-body-->
        </div>
    </form>
    <meta name="csrf-token" content="{{ csrf_token() }}">
    <!--card-->
@endsection

@section('styles')
    <link href="https://cdn.datatables.net/1.10.20/css/jquery.dataTables.min.css" rel="stylesheet" />
@endsection
@section('scripts')
    <script src="{{ asset('js/pdfmake.js') }}"></script>
    <script src="{{ asset('js/pages/CstPo/vfs_fonts.js') }}"></script>
    <script src="{{ asset('js/pages/planbook/pdforbox.js') }}"></script>
    <script src="{{ asset('js/BAHTTEXT.js') }}"></script>
    <script src="//cdn.jsdelivr.net/npm/sweetalert2@11"></script>
    <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.13.1/xlsx.full.min.js"></script>
    <script>
        function ExportData() {
            var headdertital = ""
            var headdertdate = ""
            var filename = 'reports.xlsx';
            var min = $('#min').val();
            var max = $('#max').val();
            if (min == "" || max == "") {
                min = "null";
                max = "null";
                headdertdate = " จากวันที่ ทั้งหมด ถึง ทั้งหมด"
            } else {
                var DConvertMin = new Date(Date.parse(min)).toLocaleDateString('th')
                var DConvertMax = new Date(Date.parse(max)).toLocaleDateString('th')
                headdertdate = " จากวันที่ " + DConvertMin + " ถึง " + DConvertMax

            }

            switch ($("#ConditionChoie").val()) {

                case "Active":
                    headdertital = "รายงาน Order(ใช้งาน)"
                    break;
                    // case "BackUp":
                    // getdata("{{ url('') }}/admin/planbookgetdata10/"+$("#ConditionChoie").val());
                    // break;
                case "ALL":
                    headdertital = "รายงาน Order"
                    break;
            }
            $.ajax({
                url: "{{ url('') }}/admin/planbookgetdata10/" + $('#ConditionChoie').val() + "/" +
                    min + "/" + max,
                success: function(sss, textStatus, xhr) {
                    if (JSON.parse(sss).data.length > 0) {
                        let objectMaxLength = [];
                        for (let i = 0; i < JSON.parse(sss).data.length; i++) {
                            let value = Object.values(JSON.parse(sss).data[i]);
                            for (let j = 0; j < value.length; j++) {
                                if (typeof value[j] == "number") {
                                    objectMaxLength[j] = 20;
                                } else {
                                    objectMaxLength[j] =
                                        objectMaxLength[j] >= value[j].length + 10 ?
                                        objectMaxLength[j] :
                                        value[j].length + 10;
                                }
                            }
                        }

                        var wscols = [{
                                width: objectMaxLength[0]
                            }, // first column
                            {
                                width: objectMaxLength[1]
                            }, // second column
                            {
                                width: objectMaxLength[2]
                            }, //...
                            {
                                width: objectMaxLength[3]
                            },
                            {
                                width: objectMaxLength[4]
                            },
                            {
                                width: objectMaxLength[5]
                            },
                            {
                                width: objectMaxLength[6]
                            },
                            {
                                width: objectMaxLength[7]
                            },
                            {
                                width: objectMaxLength[8]
                            },
                            {
                                width: objectMaxLength[9]
                            }
                        ];
                    }
                    var merge = {
                        s: {
                            r: 0,
                            c: 0
                        },
                        e: {
                            r: 0,
                            c: 6
                        }
                    };
                    ''
                    var wb = XLSX.utils.book_new();
                    ws = XLSX.utils.json_to_sheet(JSON.parse(sss).data, {
                        // header: ["A", "B", "C", "D", "E", "F", "G"],
                        origin: "A2"
                    });
                    if (JSON.parse(sss).data.length > 0) {
                        ws["!cols"] = wscols;
                    }

                    if (!ws['!merges']) ws['!merges'] = [];
                    ws['!merges'].push(merge);
                    ws['A1'] = {
                        t: 's',
                        v: headdertital + headdertdate,
                        s: {
                            a: {
                                v: "center",
                                h: "center",
                            }
                        }
                    };
                    var range = XLSX.utils.decode_range(ws['!ref']);
                    for (var C = range.s.c; C <= range.e.c; ++C) {
                        var address = XLSX.utils.encode_col(C) + "2"; // <-- first row, column number C
                        if (!ws[address]) continue;
                        ws[address].v = ws[address].v.toUpperCase();
                    }
                    const Heading = [
                        ['เลขที่ PO', 'วันที่ PO', 'Item Number', 'Item Name', 'Backup']
                    ];
                    XLSX.utils.sheet_add_aoa(ws, Heading, { origin: 'A2' });

                    XLSX.utils.book_append_sheet(wb, ws);

                    XLSX.writeFile(wb, filename);

                }
            });

        }
    </script>
    <script>
        var table
        $(document).ready(function() {
            getdata("{{ url('') }}/admin/planbookgetdata10/Noactive/null/null");

            $('#filterSubmit').click(function() {
                $('#datatable').DataTable().destroy();
                var min = $('#min').val();
                var max = $('#max').val();
                if (min == "" || max == "") {
                    min = "null";
                    max = "null";
                }

                switch ($("#ConditionChoie").val()) {
                    case "Noactive":
                        getdata("{{ url('') }}/admin/planbookgetdata10/" + $(
                            '#ConditionChoie').val() + "/" + min + "/" + max);
                        break;
                        // case "BackUp":
                        // getdata("{{ url('') }}/admin/planbookgetdata10/"+$("#ConditionChoie").val());
                        // break;
                    case "ALL":
                        getdata("{{ url('') }}/admin/planbookgetdata10/" + $(
                            '#ConditionChoie').val() + "/" + min + "/" + max);
                        break;

                }


            });


        });

        function myFunction() {
            var datasq = []
            table = $('#datatable').DataTable();
            var data = table.rows().nodes();
            var pluginArrayArg = new Array();
            $.each(data, function(index, value) {
                if ($(this).find('input').prop('checked')) {
                    const dataSp = $(this).find('input').prop('value').split(",");
                    var XVOrderDocNo = new Object();
                    XVOrderDocNo.XVOrderDocNo = dataSp[0];
                    XVOrderDocNo.XVOrderDocNo2 = dataSp[1];
                    pluginArrayArg.push(JSON.stringify(XVOrderDocNo));
                }
            });
            console.log(pluginArrayArg);
            $.ajax({
                type: "POST",
                url: "{{ url('') }}/admin/planbook/bkboxindex/rebackup",
                headers: {
                    'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                },
                data: {
                    items: pluginArrayArg
                },
                success: function(data, textStatus, xhr) {
                    console.log(data);
                    $('#datatable').DataTable().destroy();
                    getdata("{{ url('') }}/admin/planbookgetdata10");
                }
            });
        }

        function getdata(urls) {
            console.log(urls);
            var min = $('#min').val();
            var max = $('#max').val();
            if (min == "" || max == "") {
                min = "null";
                max = "null";
            }

            $('#datatable').DataTable({
                buttons: [{
                        text: 'ส่งออก Excel',
                        action: function(e, dt, node, config) {
                            ExportData()
                        }
                    },
                    {
                        text: 'ส่งออก PDF',
                        action: function(e, dt, node, config) {
                            var headdertital = ""
                            var headdertdate = ""
                            var filename = 'reports.xlsx';
                            var min = $('#min').val();
                            var max = $('#max').val();
                            if (min == "" || max == "") {
                                min = "null";
                                max = "null";
                                headdertdate = " จากวันที่ ทั้งหมด ถึง ทั้งหมด"
                            } else {
                                var DConvertMin = new Date(Date.parse(min)).toLocaleDateString('th')
                                var DConvertMax = new Date(Date.parse(max)).toLocaleDateString('th')
                                headdertdate = " จากวันที่ " + DConvertMin + " ถึง " + DConvertMax

                            }

                            switch ($("#ConditionChoie").val()) {

                                case "Noactive":
                                    headdertital = "รายงาน Order(ไม่ใช้งาน)"
                                    break;
                                    // case "BackUp":
                                    // getdata("{{ url('') }}/admin/planbookgetdata10/"+$("#ConditionChoie").val());
                                    // break;
                                case "ALL":
                                    headdertital = "รายงาน Order"
                                    break;
                            }

                            renderPdf("{{ url('') }}/admin/planbookgetdata10/" + $(
                                    '#ConditionChoie').val() + "/" + min + "/" + max, headdertital,
                                headdertdate)

                        }
                    }
                ],
                pageLength: 10,
                "ajax": {
                    url: urls,
                    data: {
                        location: 4
                    },
                },
                "columnDefs": [{
                        "targets": 0, // เลขที่
                        "className": "text-center",
                    },
                    {
                        "targets": 1, // เลขที่
                        "className": "text-center",
                    },
                    {
                        "targets": 2, // วันที่
                        "className": "text-center",
                    },
                    {
                        "targets": 3, // วันที่
                        "className": "text-center",
                    },
                    {
                        "targets": 4, // SKU
                        "className": "text-left",
                    },

                ],
                "columns": [{
                        data: 'XVOrderDocNo'
                    },
                    {
                        render: function(data, type, full, meta) {

                            return moment(full.XDDateIn).format("DD-MM-YYYY");
                        }
                    },
                    {
                        data: 'XVStyle'
                    },
                    {
                        data: 'XVOrderIn'
                    },

                    {
                        render: function(data, type, full, meta) {

                            return (full.Active ?
                                '<input type="checkbox" class="editor-active" name="sss[]" value="' +
                                full.XVOrderDocNo + ',' + full.XVStyle + '" > ' :
                                '<input type="checkbox" class="editor-active" checked name="sss[]" value="' +
                                full.XVOrderDocNo + ',' + full.XVStyle + '" >');

                        }
                    }
                ],
            });

        }
    </script>
@endsection