@extends("cms.layouts.app", ['page_id' => 'order_index'])

@push("css")
<link rel="stylesheet" type="text/css" href="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.css" />
@endpush

@push("js")
<script type="text/javascript" src="https://cdn.jsdelivr.net/momentjs/latest/moment.min.js"></script>
<script type="text/javascript" src="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/FileSaver.js/2014-11-29/FileSaver.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.12.13/xlsx.full.min.js"></script>
<script type="text/javascript">

$(function () {

  let datas = [];
  let orderDetailData = [];
  let selectedRow = [];
  let count = 0;
  let barcodeList = [];
  let platformsList = [];
  $(".export-order").click(function(){
        datas = table.rows().data();
    var workbook = XLSX.utils.book_new();

        let excelData = [];
        if(datas.length>0){
          for (var i = 0; i < datas.length; i++) {
            for (var j = 0; j < datas[i]['order_products'].length; j++) {
              let d = [];
              d.push(datas[i]['external_order_id']);
              d.push(datas[i]['order_products'][j]['상품주문번호'] ??'');
              d.push(datas[i]['order_products'][j]['product_name']);
              d.push(datas[i]['order_products'][j]['qty']);
              d.push(datas[i]['order_datetime']);
              d.push(datas[i]['created_at']);
              d.push(datas[i]['platform_name']+datas[i]['store_id']);
              d.push(datas[i]['invoice_number']);
              d.push(datas[i]['courier_name']);

              if(!(barcodeList.includes(datas[i]['order_products'][j]['barcode']))){
                barcodeList.push(datas[i]['order_products'][j]['barcode']);
              }

              excelData.push(d);
                  count = count+datas[i]['order_products'][j]['qty'];
            }

          }
        }else{
          // datas = 0;
          datas = [];
          barcodeList = [];
          count = 0;
        }

        let country  = 'China';

        if(platformsList.includes('17') ||platformsList.includes('12') ||platformsList.includes('13') ||platformsList.includes('14') ||platformsList.includes('15')){
          country = 'Japan';
        }else if (platformsList.includes('3') ) {
            country = 'Hong Kong';
        }else if (platformsList.includes('5') || platformsList.includes('16') || platformsList.includes('7') || platformsList.includes('8') || platformsList.includes('2') || platformsList.includes('4') || platformsList.includes('6')) {
            country = 'Korea';
        }else if (platformsList.includes('1')) {
            country = 'USA';
        }

        var worksheet_data  =  [
          [],
          ['Country',country],
          ['Date type', $('.date-option').val()==1?'Order Date':'Import Date'],
          ['Date range selected',$("input[name='dates']").val()],
          ['Status',$("select[name='status'] >option:selected").text()],
          ['Number of orders received', datas.length],
          ['Number of product types sold',barcodeList.length],
          ['Total product units sold', count ],
          ['Keyword search term',$("input[type='search']").val()],
          [],
          [],
          ['OMS Total Orders'],
          ['Order Number','Product Order Number','Product Name','Product Quantity','Order date','Import date','Patform','OMS Invoice number','Courier']
        ];

        console.log(worksheet_data);



        var worksheet = XLSX.utils.aoa_to_sheet(worksheet_data.concat(excelData));
        // var worksheet = XLSX.utils.aoa_to_sheet(excelData);

        // var worksheet_data  = document.getElementById("mytable");
        // var worksheet = XLSX.utils.table_to_sheet(worksheet_data);

        workbook.SheetNames.push("test");
        workbook.Sheets["test"] = worksheet;

        return XLSX.writeFile(workbook, "test.xls");

  })
    $('input[name="dates"]').daterangepicker({
    locale: { cancelLabel: 'Clear', format: 'YYYY-MM-DD'},
	    startDate:  moment().subtract(3, 'months').format('YYYY-MM-DD'),
        endDate : moment().format('YYYY-MM-DD')
    }, function(chosen_date) { });
    $('input[name="dates"]').on('cancel.daterangepicker', function(ev, picker) {
        $('input[name="dates"]').val('');
        localStorage.clear();
        $('#dataTable').DataTable().ajax.reload();
    });

    $('input[name="dates').val(moment().subtract(3, 'months').format('YYYY-MM-DD')+' - ' +moment().format('YYYY-MM-DD'));
    $('input[name="dates"],#date-option').on('change', function () {
        setTimeout(function(){
            $('#dataTable').DataTable().ajax.reload();
        }, 100);
    });

    $('.dataTable-custom-toolbar--source [name=status]').on('change', function () {
        $('#dataTable').DataTable().ajax.reload();
        $(`#form_export [name=${$(this).attr('name')}]`).val($(this).find('option:selected').val())
    })

    var getUrlParameter = function getUrlParameter(sParam) {
    var sPageURL = window.location.search.substring(1),
        sURLVariables = sPageURL.split('&'),
        sParameterName,
        i;
        for (i = 0; i < sURLVariables.length; i++) {
          sParameterName = sURLVariables[i].split('=');
          if (sParameterName[0] === sParam) {
            return typeof sParameterName[1] === undefined ? true : decodeURIComponent(sParameterName[1]);
          }
        }
        return false;
    };
    if(getUrlParameter('platform') == 8 || getUrlParameter('platform') == 4){
    //   $("#store-option").show();
      $(".shipping-button").show();
    }else{
    //   $("#store-option").hide();
      $(".shipping-button").hide();
    }

    platformsList = getUrlParameter('platform').split(',');

    console.log(platformsList);
    @php
        $no_data_message = __('cms.order.no_data.'.$status);
    @endphp
    const table = window.dataTablesHelper.init({
        language: {
          emptyTable: "{{ $no_data_message }}"
        },
        serverSide: true,
        stateSave: true,
        pageLength: 200,
        lengthMenu: [100, 200, 300, 400, 500, 600, 700, 800 ,900 ,1000],
        ajax: {
            url: "{!! route('cms.orders.datatable', ['platform' => $platform, 'status' => $status]) !!}",
            data: function (d) {

                d.status = $('[name=status] option:selected').val();
                if ($('input[name="dates"]').val()) {
                    var startDate = $('input[name="dates"]').data('daterangepicker').startDate.format('YYYY-MM-DD');
                    var endDate = $('input[name="dates"]').data('daterangepicker').endDate.format('YYYY-MM-DD');
                    d.date_option = $('[name=date_option] option:selected').val();
                    d.start_date = startDate;
                    d.end_date = endDate;
                }

                  // d.shipping_date !== undefined?localStorage.setItem('shipping_date', $('[name=shipping_date] option:selected').val()):null;

                // if(performance.navigation.type === 2)
                // {
                //       //Do your code here
                //
                //       if(localStorage.getItem('date_option') != null){
                //           d.date_option = localStorage.getItem('date_option'); // shipping_date
                //       }
                //
                //       if(localStorage.getItem('start_date') != null){
                //           d.start_date = localStorage.getItem('start_date');
                //       }
                //
                //       if(localStorage.getItem('end_date') != null){
                //           d.end_date = localStorage.getItem('end_date');
                //             $('input[name="dates"]').val(d.start_date+" - "+d.end_date);
                //       }
                //
                //       if(localStorage.getItem('store_id') != null){
                //         d.store_id = localStorage.getItem('store_id');
                //       }
                //
                //       if(localStorage.getItem('platform') != null){
                //         d.platform = localStorage.getItem('platform');
                //       }
                // }
            },
            dataSrc: function ( data ) {

                
                if(data.data.length != 0){
                    orderDetailData = data.data;
                    return data.data;
                    
                }
                return [];
            }
        },
        order: [[ 7, 'desc' ]],
        buttons: {
            buttons: [
                {
                    extend: 'selected',
                    text: "{{ __('cms.order.move_to_status', ['status' => __('cms.order.status.' . \App\Order::Picking)]) }}",
                    className: 'btn-move-to-status',
                  //  key: 'm',
                    action: function ( e, dt, node, config ) {
                        const rows = dt.rows( { selected: true } );
                        const ids = rows.data().toArray().map(item => item.id);

                        $.ajax({
                            url: "{{ route('cms.orders.update_status') }}",
                            method: 'post',
                            dataType:"json",
                            data: {
                                "_token": "{{ csrf_token() }}",
                                "ids": ids,
                                "target_status": "{{ \App\Order::Picking }}"
                            },
                            beforeSend:function(XMLHttpRequest){

                            },
                            complete:function(jqXHR, textStatus) {

                            },
                            success: function(data){
                                alert("{{ __('cms.success') }}");
                                table.ajax.reload();
                            },
                            error: function (request, status, error) {
                                let json = $.parseJSON(request.responseText);
                                alert(json.message);
                                console.log(json);
                            }
                        });
                    }
                },
                {
                    extend: 'excel',
                    text: "Download Excel File",
                    className: 'btn-download-excel',
                    //key: 'p',
                    title:"Lldopojang File",
                   
                    customize: function (xlsx) {
                        console.log(selectedRow);
                        console.log(orderDetailData);
                        let r = "";
                        let sheet = xlsx.xl.worksheets['sheet1.xml'];
                          let numrows = 1;

			$('row c', sheet).each(function() {
                        	$(this).removeAttr('s'); 
                    	});
                          

                          function Addrow(index, data) {
                              var msg = '<row r="' + index + '">'
                              for (var i = 0; i < data.length; i++) {
                             
                                  var key = data[i].key;
                                  var value = data[i].value;
                                  msg += '<c t="inlineStr" r="' + key  + '">';
                                  msg += '<is>';
                                  msg += '<t>' + value + '</t>';
                                  msg += '</is>';
                                  msg += '</c>';
                              }
                              msg += '</row>';
                              r = r +msg;
                              return msg;
                          }

                          var k1 = Addrow(2, [
                            { key: 'A2', value: "운송장번호"},
                            { key: 'B2', value: "고객주문번호"},
                            { key: 'C2', value: "받는분성명"},
                            { key: 'D2', value: "받는분전화번호"},
                            { key: 'E2', value: "받는분기타연락처"},
                            { key: 'F2', value: "받는분주소"},
                            { key: 'G2', value: "배송메세지1"},
                            { key: 'H2', value: "품목명"},
                            { key: 'I2', value: "내품수량"},
                            { key: 'J2', value: "박스수량"},
                            { key: 'K2', value: "송하인성명"},
                            { key: 'L2', value: "송하인전화번호"},
                            { key: 'M2', value: "송하인주소"},
                        ]);

                        let count = 3;

                        selectedRow.forEach(function(d){
                          
                            d.order_products.map((e)=>{
                                console.log(e.product_order);
                                Addrow(count, [
                                {key: 'A'+count, value: ""},
                                {key: 'B'+count, value: d.external_order_id },
                                {key: 'C'+count, value: d.receiver_name },
                                {key: 'D'+count, value: d.receiver_contact_number1??"" },
                                {key: 'E'+count, value: d.receiver_contact_number2??"" },
                                {key: 'F'+count, value: d.receiver_address??""},
                                {key: 'G'+count, value: d.delivery_requirement??""},
                                {key: 'H'+count, value: e.product_name_ko??"" },
                                {key: 'I'+count, value: e.qty },
                                {key: 'J'+count, value: 1 },
                                {key: 'K'+count, value: d.shipper_name },
                                {key: 'L'+count, value: d.shipper_contact_number },
                                {key: 'M'+count, value: "경기 고양시 덕양구 고골길116번길 39-48" }])
                                count++;
                            });
                        });

                        sheet.childNodes[0].childNodes[1].innerHTML = r;
                    }
                }
            ],
        },
        columns: [
            {
                ...window.dataTablesHelper.selectCheckbox.columnData,
                render: function ( data, type, row, meta ) {
                    return row['status'] == '{{ \App\Order::Pending }}'? window.dataTablesHelper.selectCheckbox.html : `<input type='checkbox' disabled>`;
                    // return row['status'] != '{{ \App\Order::Pending }}'? window.dataTablesHelper.selectCheckbox.html : '';
                },
            },
            {
                data: 'external_order_id', name: 'external_order_id',
                render: function ( data, type, row, meta ) {
                  if(row.platform_id == 1){
                      return `<span class="text-green">${row.order_item_id}</span>`;
                  }
                    return `<span class="text-green">${data}</span>`;
                },
            },
            { data: 'order_datetime', name: 'order_datetime',},
            { data: 'created_at', name: 'created_at',},
            { data: 'platform_name', name: 'platforms.name',
            render: function ( data, type, row, meta ) {
                return `${data}`+row.store_id;
              }
            },
            { data: 'invoice_number', name: 'invoice_number',},
            { data: 'courier_name', name: 'couriers.name',
                render: function ( data, type, row, meta ) {
                    var displayName = '{{ __('cms.na') }}';
                    if (data) { displayName = data; }
                    return displayName;
                }
            },
            {
                data: 'status', name: 'status',
                render: function ( data, type, row, meta ) {
                    var displayName = '{{ __('cms.na') }}';
                    switch (data) {
                        case 1:
                            displayName = "{{ __('cms.order.status.1') }}";
                            break;
                        case 2:
                            displayName = "{{ __('cms.order.status.2') }}";
                            break;
                        case 3:
                            displayName = "{{ __('cms.order.status.3') }}";
                            break;
                        case 4:
                            displayName = "{{ __('cms.order.status.4') }}";
                            break;
                        case 5:
                            displayName = "{{ __('cms.order.status.5') }}";
                            break;
                        case 6:
                            displayName = "{{ __('cms.order.status.6') }}";
                            break;
                        case 7:
                            displayName = "{{ __('cms.order.status.7') }}";
                            break;
                        default:
                            break;
                    }
                    return `<span class="badge badge-pill badge-status badge-order-status-${data}">${displayName}</span>`;
                }
            },
            { data: 'created_at', name: 'created_at',"visible": false, "searchable": false},
        ],
        enableSelect: true,
        isSelectableRow: function(row, data, dataIndex) {
            return (data['status'] == '{{ \App\Order::Pending }}')
        },
        onSelectRow: function (count) {
            selectedRow = table.rows({ selected: true }).data().toArray()
            $('.btn-move-to-status span').html(`{{ __('cms.order.move_to_status', ['status' => __('cms.order.status.' . \App\Order::Picking)]) }}${count > 0? ` (${count})` : ''}`)
          //  $('.btn-download-excel span').html(`{{ __('cms.order.move_to_status', ['status' => __('cms.order.status.' . \App\Order::Picking)]) }}${count > 0? ` (${count})` : ''}`)
        },
        onClickRow: function(id) {
            if (!id) { return; }

            var url = '{{ route('cms.orders.show', '__id__') }}'.replace('__id__', id);
            window.location.href = url;
        },
        stateSaveCallback: function(settings,data) {
             // alert("save callback");
               localStorage.setItem( 'clist_DataTables_' + settings.sInstance, JSON.stringify(data) )
           },
        stateLoadCallback: function(settings) {
             // alert("load callback");
             if(performance.navigation.type == 2){
                 return JSON.parse( localStorage.getItem( 'clist_DataTables_' + settings.sInstance ) )
             }else{
               return true;
             }
        }
    })



    window.initFormSubmit({
        selector: '.modal-import form',
        onSubmit: function ({ form }) {
            location.reload()
        }
    })
});
</script>
@endpush

@section("title")


@if (count(explode(',', $platform))>1)
{{$country}} Total {{$status !== null ? __('cms.order.status.' . $status) : 'Orders'}}
@endif

@if (count(explode(',', $platform)) == 1)
{{ __('cms.order.platforms.' . $platform) }} {{$status !== null ? __('cms.order.status.' . $status) : 'Orders'}}
@endif

@endsection

@section("content")

@php

if($_SERVER['QUERY_STRING'] !=="platform=all") {

@endphp
<div class="row mb-5">
    <div class="col-md-auto mb-2 mb-md-0">
        <div class="row">
            <div class="col-auto">
                <x-card.stat
                class="testing-card"
                    title="{{ __('cms.order.stats.today') }}"
                    value="{{ $today_count }}"
                />
            </div>
            <div class="col col-sm-auto">
                <x-card.stat
                    title="{{ __('cms.order.stats.month') }}"
                    value="{{ $this_month_count }}"
                />
            </div>
            <div class="col col-sm-auto">
                <x-card.stat
                    title="Total {{$status !== null ? __('cms.order.status.' . $status) : ' All'}} Orders"
                    value="{{ $month_status_count }}"
                />
            </div>
            <div class="col col-sm-auto">
                <x-card.stat
                    title="{{ __('cms.shipping.stats.remain_cj_tracking_no') }}"
                    value="{{ \App\CjHwab::get_available_count() }}"
                >
                    <div class="col-auto d-flex align-items-center ml-5">
                        <a href="#" class="badge badge-pill badge-outline-primary badge-details" data-toggle="modal" data-target="#modal_import_cj_old">
                            {{ __('cms.import_cj_number') }}
                            <i class="fas fa-chevron-right ml-2"></i>
                        </a>
                    </div>
                </x-card.stat>
            </div>
        </div>
    </div>
    <div class="col-md d-flex justify-content-md-end align-items-end">
        <div class="row">
            <div class="col-auto">

            @php
                  $permissions = json_decode(\Auth::user()->permission);

                  $name = '';

                  switch($country){
                    case 'JP':
                      $name = 'japan';
                      break;
                    case 'CH':
                      $name = 'china';
                      break;
                    case 'HK':
                      $name = 'hong_kong';
                      break;
                    case 'KR':
                      $name = 'korea';
                      break;
                    case 'US':
                      $name = 'usa';
                      break;
                  }


                  if(isset($permissions->{$name.'_export_permission'}) && $permissions->{$name.'_export_permission'} == 1){

            @endphp
              <button type="button" class="btn btn-secondary btn-icon export-order {{$name.'_export_permission'}}}" >
                   <i class="las la-download mr-2"></i>
                  Export Excel File
              </button>

              @php } @endphp

                {{-- <div class="dropdown"> --}}
                {{--     <button class="btn btn-secondary btn-icon dropdown-toggle" type="button" id="btn_import" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false"> --}}
                {{--         <i class="las la-upload mr-2"></i> --}}
                {{--         {{ __('cms.import') }} --}}
                {{--     </button> --}}
                {{--  --}}
                {{--     <div class="dropdown-menu dropdown-menu-right" aria-labelledby="btn_import"> --}}
                {{--       <a class="dropdown-item" href="#" role="button" data-toggle="modal" data-target="#modal_import">{{ __('cms.order.orders') }}</a> --}}
                {{--     </div> --}}
                {{--  --}}
                {{-- </div> --}}

            </div>
        </div>
    </div>
</div>


@php

}
@endphp
<div class="card">
    <div class="card-body table-dataTable table-responsive">
        <div class="dataTable-custom-toolbar--source">
            <div class="row justify-content-end align-items-center">
              <div class="col-sm-auto">
                @php
                    $stores_options = \App\Store::where('platform_id',$platform)->where('status',1)->pluck('name', 'id')->toArray();

                @endphp
                {{
                    Form::select('store_option',  array_merge(['0' =>'All Stores'], $stores_options), null, ['id' => 'store-option', 'class' => "text-status font-weight-600 form-control form-control-sm", 'style' => 'min-width: 100px;'])
                }}

              </div>
                <div class="col-sm-auto">
                    {{
                        Form::select('date_option', [
                            '1' => 'Order Date',
                            '2' => 'Import Date',
                        ], null, ['id' => 'date-option', 'class' => "text-status font-weight-600 form-control form-control-sm", 'style' => 'min-width: 100px;'])
                    }}
                </div>
                <div class="col-sm-auto">
                    <div class="input-group">
                        <div class="input-group-prepend"> <span class="input-group-text"><i class="far fa-calendar"></i></span> </div>
                        <input type="text" name="dates" class="form-control pull-right form-control-sm order-daterangepicker" style="min-width:150px;">
                    </div>
                </div>

                <div class="col-sm-auto">
                    @if (!isset($status))
                        {{
                            Form::select('status', [
                                '0' => __('cms.all_statuses'),
                                '1' => __('cms.order.status.1'),
                                '2' => __('cms.order.status.2'),
                                '3' => __('cms.order.status.3'),
                                '4' => __('cms.order.status.4'),
                                '5' => __('cms.order.status.5'),
                                '6' => __('cms.order.status.6'),
                                '7' => __('cms.order.status.7'),
                            ], null, ['class' => "text-status font-weight-600 form-control form-control-sm", 'style' => 'min-width: 200px;', 'plcaeholder' => __('cms.all_statuses')])
                        }}
                    @endif
                </div>
            </div>
        </div>
        <table id="dataTable" class="table table-hover w-100">
            <thead>
                <tr>
                    <th class="align-middle"><span class="select-checkbox"></span></th>
                    <th>{{ __('cms.order.order_no')}}</th>
                    <th>{{ __('cms.order.order_date')}}</th>
                    <th>{{ __('cms.order.import_date')}}</th>
                    <th>{{ __('cms.order.platform')}}</th>
                    <th>{{ __('cms.order.invoice_no')}}</th>
                    <th>{{ __('cms.order.courier')}}</th>
                    <th>{{ __('cms.status')}}</th>
                </tr>
            </thead>
        </table>
    </div>
</div>

<x-modal.master id="modal_export" title="{{ __('cms.export')}}">

    {{ Form::open(['route' => 'cms.orders.export', 'method' => 'POST', 'id' => 'form_export']) }}

        @php
            $couriers_options = $couriers->pluck('name', 'id');
            $platforms_options = $platforms->pluck('name', 'id');
            $dates_options = [
                '0' => __('cms.today'),
                '+1' => __('cms.tomorrow'),
                '+2' => __('cms.2_days_later'),
                '+7' => __('cms.this_week'),
            ];

            $fields = [
                [
                    'type' => 'select',
                    'name' => 'courier_id',
                    'label' => __('cms.order.courier'),
                    'options' => $couriers_options,
                    'withAny' => '1'
                ],
                [
                    'type' => 'select',
                    'name' => 'platform_id',
                    'label' => __('cms.order.platform'),
                    'options' => $platforms_options,
                    'withAny' => '1',
                    'value' => (($platform == 'all')? '' : $platform)
                ],
                [
                    'type' => 'select',
                    'name' => 'shipping_date',
                    'label' => __('cms.order.shipping_date'),
                    'options' => $dates_options,
                    'withAny' => '1'
                ],
            ];
        @endphp
        <x-form.fields field-class="col-12 mb-5" :fields="$fields" editing="1"></x-form.fields>

        <div class="row my-6">
            <div class="col"></div>
            <div class="col-auto">
                <button type="submit" class="btn btn-primary btn-lg">
                    {{ __('cms.export') }}
                </button>
            </div>
        </div>
    {{ Form::close() }}
</x-modal.master>



<x-modal.master id="modal_import_cj_old" class="modal-import" title="{{ __('cms.import_cj_number') }}" size="lg">
    {{ Form::open(['route' => 'cms.cjs.import', 'method' => 'POST', 'id' => 'form_import_cj_old', 'files' => true]) }}
        <x-form.form-group.master
            name="upload_files_old_cj"
            label="{{ __('cms.order.raw_files_excel') }}"
            type="file"
        >
            {{ Form::fileUpload('upload_files_old_cj', null, [
                'multiple' => true,
                'type' => 'document',
                'accept' => '.xlsx, .xls, .csv',
            ]) }}
        </x-form.form-group.master>

        <div class="row my-6">
            <div class="col"></div>
            <div class="col-auto">
                <button type="submit" class="btn btn-primary btn-lg">
                    {{ __('cms.import') }}
                </button>
            </div>
        </div>

    {{ Form::close() }}
</x-modal.master>

<x-modal.master id="modal_import_cj_new" class="modal-import" title="{{ __('cms.import') . ' - ' . __('cms.new_cj.title') }}" size="lg">
    {{ Form::open(['route' => 'cms.orders.import', 'method' => 'POST', 'id' => 'form_import_cj_new', 'files' => true]) }}
        <x-form.form-group.master
            name="upload_files_new_cj"
            label="{{ __('cms.order.raw_files') }}"
            type="file"
        >
            {{ Form::fileUpload('upload_files_new_cj', null, [
                'multiple' => true,
                'type' => 'document',
                'accept' => '.xlsx, .xls, .csv',
            ]) }}
        </x-form.form-group.master>

        <div class="row my-6">
            <div class="col"></div>
            <div class="col-auto">
                <button type="submit" class="btn btn-primary btn-lg">
                    {{ __('cms.import') }}
                </button>
            </div>
        </div>

    {{ Form::close() }}
</x-modal.master>
@endsection