@extends("cms.layouts.app", ['page_id' => 'shipping_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 type="text/javascript">
$(function () {

    let datas = [];
  let count = 0;
  let order_count =0;
  let selectedRow = [];
  let adjustments = [];

  function getShopByPlatform(p){
        const xmlhttp = new XMLHttpRequest();
        xmlhttp.onload = function() {
            //$("select[name='shop_id']").empty();
            if(this.response !=='[]'){
                $("select[name='store_option']").empty();
                let selector = document.getElementsByName('store_option');
                let ZeroOption = document.createElement("option");
                    ZeroOption.text = 'All Stores';
                    ZeroOption.value = 0;
                    selector[0].add(ZeroOption);
                JSON.parse(this.response).forEach(e=>{
                    let option = document.createElement("option");
                    option.text = e.name;
                    option.value = e.id;
                    selector[0].add(option);
                });
                $("select[name='store_option']").parent().show();
            }else {
                $("select[name='store_option']").parent().hide();
            }
        }
        xmlhttp.open("GET", "/cms/stores/get_store?platform=" + p);
        xmlhttp.send();
    }

function getPlatformByCountry(p){
    const xmlhttp = new XMLHttpRequest();
    xmlhttp.onload = function() {
        //$("select[name='shop_id']").empty();
        if(this.response !=='[]'){
            $("select[name='platforms_option']").empty();
            let selector = document.getElementsByName('platforms_option');
            
            let ZeroOption = document.createElement("option");
                ZeroOption.text = 'All Platforms';
                ZeroOption.value = 0;
                selector[0].add(ZeroOption);

            JSON.parse(this.response).forEach(e=>{
                let option = document.createElement("option");
                option.text = e.name;
                option.value = e.id;
                selector[0].add(option);
            });
            $("select[name='platforms_option']").parent().show();
        }else {
            $("select[name='platforms_option']").parent().hide();
        }
    }
    xmlhttp.open("GET", "/cms/analysts/get_platform?country_id=" + p);
    xmlhttp.send();
}

$(".add-adjustment").on('click',function(){
    adjustments.push([$("input[name='description']").val(),$("input[name='value']").val()]);
    $(".view-adjustment").text(" View Adjustments ( "+ adjustments.length+" )")
})

$(".view-adjustment").on('click',function(){
    $(".form-group--text").hide();
    $(".description-text").show();
    $(".go-back").show();
    $(this).hide();
    $(".description-text2").empty();
   
    // add adjustment items
    adjustments.map(x=>{
        $(".description-text2").append("<div class='row col-12 adjustment-records'><div class='col-auto col-6'><label>"+ x[0]+"</label></div><div class='col-auto col-6'><label>"+x[1]+"</label><i class='fa fa-trash remove-adjust'></i></div></div>")
    })
    $(".description-text2").show();
  
});

$("#adjustments").on('click','.remove-adjust',function(){
    let d = $(this).prev().parent().prev().text();
    let v = $(this).prev().parent().text()
    adjustments = adjustments.filter(x=> x[0]!== d && x[1] !==v)
    $(this).prev().parent().parent().remove();
    $(".view-adjustment").text(" View Adjustments ( "+ adjustments.length+" )")

    // console.log($(this));
})

$(".go-back").on('click',function(){
    $(".form-group--text").show();
    $(".description-text").hide();
    $(".go-back").hide();
    $(".view-adjustment").show();
    $(".description-text2").hide();
})

$('#country-option').on('change', function () {
        setTimeout(function(){
            $('#dataTable').DataTable().ajax.reload();
        }, 100);
        getPlatformByCountry($('#country-option').val());
    });

    $('#platform-option').on('change', function () {
        setTimeout(function(){
            $('#dataTable').DataTable().ajax.reload();
        }, 100);
        getShopByPlatform( $('#platform-option').val());
    });

    
    $("select[name='platform_id']").on('change', function () {

        const xmlhttp = new XMLHttpRequest();
        xmlhttp.onload = function() {
            //$("select[name='shop_id']").empty();
            if(this.response !=='[]'){
                $("select[name='store_option2']").empty();
                let selector = document.getElementsByName('store_option2');
                let ZeroOption = document.createElement("option");
                    ZeroOption.text = 'All Stores';
                    ZeroOption.value = 0;
                    selector[0].add(ZeroOption);
                JSON.parse(this.response).forEach(e=>{
                    let option = document.createElement("option");
                    option.text = e.name;
                    option.value = e.id;
                    selector[0].add(option);
                });
                $("select[name='store_option2']").parent().show();
            }else {
                $("select[name='store_option2']").parent().hide();
            }
        }
        xmlhttp.open("GET", "/cms/stores/get_store?platform=" + $(this).val());
        xmlhttp.send();
    });

    $('#store-option').on('change', function () {
        setTimeout(function(){
            $('#dataTable').DataTable().ajax.reload();
        }, 100);
    });
    $('input[name="dates"]').daterangepicker({
        locale: { cancelLabel: 'Clear', 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('');
    $('input[name="dates"],#date-option').on('change', function () {
        setTimeout(function(){
            $('#dataTable').DataTable().ajax.reload();
        }, 100);
    });



    $('select[name="vat_status_option"]').on('change', function () {
        setTimeout(function(){
            $('#dataTable').DataTable().ajax.reload();
        }, 100);
    });

    $('select[name="file_option"]').on('change', function () {
        setTimeout(function(){
            $('#dataTable').DataTable().ajax.reload();
        }, 100);
    });

    $(".custom-update").on('click',function(){
        location.href = '/cms/custom';
    })
    

    @php
        $no_data_message = "- No More Date - ";
    @endphp
    const table = window.dataTablesHelper.init({
        language: {
          emptyTable: "{{ $no_data_message }}"
        },
        serverSide: true,
        pageLength: 200,
        lengthMenu: [100, 200, 300, 400, 500, 600, 700, 800 ,900 ,1000],
        stateSave: true,
        ajax: {
            url: "{!! route('cms.analysts.invoice_datatable') !!}",
            data: function (d) {

                d.country = $('[name=country_option] option:selected').val();
                d.platform_id = $('[name=platforms_option] option:selected').val();
                d.store_id = $('[name=store_option] 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(); // shipping_date
                    d.start_date = startDate;
                    d.end_date = endDate;
                }
            },
            dataSrc:function(data){

                // console.log(data);
                datas = data.data;
                // order_count = data.data.length;
               
                // data.data.forEach(function(d){
                    
                  

                //    console.log(datas);

                // })
                    return data.data;
                // console.log(datas);
            },
        },
        order: [[ 3, 'desc' ]],
        buttons: {
            buttons: [
                {
                    extend: 'excel',
                    text: "Download Excel File",
                    className: 'btn-download-excel',
                    //key: 'p',
                    title:"Invoice",
                    customize: function (xlsx) {
                            let r = "";
                          let sheet = xlsx.xl.worksheets['sheet1.xml'];
                          let numrows = 10;
                          let clR = $('row', sheet);
                          let rows = [];
                          

                        //   selectedRow.forEach(function(d){
                        //     rows.push(d);
                        //   })
                          //update Row
                          clR.each(function () {
                              let attr = $(this).attr('r');
                              let ind = parseInt(attr);
                              ind = ind + numrows;
                              $(this).attr("r", ind);
                          });

                          // Create row before data
                          $('row c ', sheet).each(function () {
                              let attr = $(this).attr('r');
                              let pre = attr.substring(0, 1);
                              let ind = parseInt(attr.substring(1, attr.length));
                              ind = ind + numrows;
                              $(this).attr("r", pre + ind);
                          });

                          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;
                          }

                          let company_name,billing_address, from_address, bank_code, bank_company_name, bank_swift_code,bank_acc;

                            switch($('[name=store_option] option:selected').val()){
                                case '1':
                                case '2':
                                    company_name ="KR Khan Industries Limited";
                                    billing_address ="KHAN INDUSTRIES LIMITED Branch JK Digital Tower digitalro26gill 111, Guro-gu, Seoul,South Korea";
                                    from_address ="KHAN INDUSTRIES LIMITED 7F, KT336, 334-336 Kwun Tong Road, Kwun Tong, Kowloon ,Hong Kong CONTACT: (852) 3152-3240";
                                    bank_code ="HSBC";
                                    bank_company_name ="KHAN INDUSTRIES LIMITED";
                                    bank_swift_code ="HSBCHKHHHKH";
                                    bank_acc ="817 828023 838";
                                    break;
                                case '3':
                                case '6':
                                    company_name ="Dong EunHa Limited";
                                    billing_address ="DongEunHaLimited J&K Digital Tower digitalro26gill 111, Guro-gu, Seoul,South Korea";
                                    from_address ="KHAN INDUSTRIES LIMITED 7F, KT336, 334-336 Kwun Tong Road, Kwun Tong, Kowloon ,Hong Kong CONTACT: (852) 3152-3240";
                                    bank_code ="HSBC";
                                    bank_company_name ="KHAN INDUSTRIES LIMITED";
                                    bank_swift_code ="HSBCHKHHHKH";
                                    bank_acc ="817 828023 838";
                                    break;
                                case '4':
                                case '7':
                                    company_name ="Glus Limited";
                                    billing_address ="Glus Limited J&K Digital Tower digitalro26gill 111, Guro-gu, Seoul,South Korea";
                                    from_address ="KHAN INDUSTRIES LIMITED 7F, KT336, 334-336 Kwun Tong Road, Kwun Tong, Kowloon ,Hong Kong CONTACT: (852) 3152-3240";
                                    bank_code ="HSBC";
                                    bank_company_name ="KHAN INDUSTRIES LIMITED";
                                    bank_swift_code ="HSBCHKHHHKH";
                                    bank_acc ="817 828023 838";
                                    break;
                                break;
                                case '5':
                                    company_name ="WS3H Limited";
                                    billing_address ="WS3H Limited J&K Digital Tower digitalro26gill 111, Guro-gu, Seoul,South Korea";
                                    from_address ="KHAN INDUSTRIES LIMITED 7F, KT336, 334-336 Kwun Tong Road, Kwun Tong, Kowloon ,Hong Kong CONTACT: (852) 3152-3240";
                                    bank_code ="HSBC";
                                    bank_company_name ="KHAN INDUSTRIES LIMITED";
                                    bank_swift_code ="HSBCHKHHHKH";
                                    bank_acc ="817 828023 838";
                                    break;
                                case '9':
                                case '30':
                                case '25':
                                    company_name ="JP Vibex Pharmaceutical Limited";
                                    billing_address ="NAVER Green Factory, 6 Buljeong-ro, Bundang-gu, Seongnam-si, Gyeonggi Province South Korea";
                                    from_address ="Vibex Pharmaceutical Limited Time 24 Building 2-4-32 Aomi, Koto-kuTokyo CONTACT: (+81) 03-6284-4767";
                                    bank_code ="Bank of Tokyo Mitsubishi UFJ Bank Shinjuku ShintoshinBranch Branchnumber 329 (normal)";
                                    bank_company_name ="Vibex Pharmaceutical Ltd.";
                                    bank_swift_code ="BOTKJPJTXXX";
                                    bank_acc ="0463147";
                                    break;
                                case '23':
                                    company_name ="HK Khan Industries Limited";
                                    billing_address ="11Street Co., Ltd Seoul Square, 416, Hangang-daero Jung-gu, Seoul, Korea South Korea";
                                    from_address ="KHAN INDUSTRIES LIMITED 7F, KT336, 334-336 Kwun Tong Road, Kwun Tong, Kowloon ,Hong Kong CONTACT: (852) 3152-3240";
                                    bank_code ="HSBC";
                                    bank_company_name ="KHAN INDUSTRIES LIMITED";
                                    bank_swift_code ="HSBCHKHHHKH";
                                    bank_acc ="817 828023 838";
                                    break;
                                case '24':
                                    company_name ="KR Khan Industries Limited";
                                    billing_address ="KHAN INDUSTRIES LIMITED Branch J&K Digital Tower digitalro26gill 111, Guro-gu, Seoul,South Korea";
                                    from_address ="KHAN INDUSTRIES LIMITED 7F, KT336, 334-336 Kwun Tong Road, Kwun Tong, Kowloon ,Hong Kong CONTACT: (852) 3152-3240";
                                    bank_code ="HSBC";
                                    bank_company_name ="KHAN INDUSTRIES LIMITED";
                                    bank_swift_code ="HSBCHKHHHKH";
                                    bank_acc ="817 828023 838";
                                    break;
                                case '26':
                                    company_name ="HK Khan Industries Limited";
                                    billing_address ="Shopify, Inc. 151 O'Connor Street Ottawa Ontario K2P 2L8 Canada";
                                    from_address ="KHAN INDUSTRIES LIMITED 7F, KT336, 334-336 Kwun Tong Road, Kwun Tong, Kowloon ,Hong Kong CONTACT: (852) 3152-3240";
                                    bank_code ="HSBC";
                                    bank_company_name ="KHAN INDUSTRIES LIMITED";
                                    bank_swift_code ="HSBCHKHHHKH";
                                    bank_acc ="817 828023 838";
                                    break;
                                case '32':
                                    company_name ="JP Vibex Pharmaceutical Limited";
                                    billing_address ="Coupang Co., Ltd., 8thFloor, 570 Songpa-daero, Songpa-gu, Seoul, South Korea";
                                    from_address ="Vibex Pharmaceutical Limited Time 24 Building 2-4-32 Aomi, Koto-kuTokyo CONTACT: (+81) 03-6284-4767";
                                    bank_code ="Bank of Tokyo Mitsubishi UFJ Bank Shinjuku ShintoshinBranch Branchnumber 329 (normal)";
                                    bank_company_name ="Vibex Pharmaceutical Ltd.";
                                    bank_swift_code ="BOTKJPJTXXX";
                                    bank_acc ="0463147";
                                    break;
                                default:
                                    alert("Please selected the store first");
                                    return false;
                                    break;

                            }

                       
                          // var title = Addrow(1,[{key:'A1',value: $(t.selector).data('title')}]);
                           Addrow(2, [{ key: 'A2', value: "Company Name"},{key: 'B2', value: company_name},{key: 'E2', value: "Issued date : "},{key: 'F2', value: moment().format('YYYY-MM-DD')}]);
                          Addrow(3, [{ key: 'C3', value: "Invoice"}]);
                          Addrow(4, [{ key: 'C4', value: $('input[name="dates"]').data('daterangepicker').startDate.format('YYYY-MM-DD') + " - " + $('input[name="dates"]').data('daterangepicker').endDate.format('YYYY-MM-DD')}]);
                          Addrow(5, [{ key: 'A5', value: "Billing To"},{key: 'E5', value: "From"}]);
                          Addrow(6, [{ key: 'A6', value: "Name / Address"},{key: 'B6', value: billing_address},{key: 'E6', value: "Name / Address"},{key: 'F6', value:from_address }]);
                          Addrow(7, [{ key: 'A7', value: "Total Charge Amount in KRW"},{key: 'B7', value: 0}]);
     
                          Addrow(9, [
                            {key: 'A9', value: "No."},
                            {key: 'B9', value: "Product Name" },
                            {key: 'C9', value: "Sale Quantity" },
                            {key: 'D9', value: "Shipping Cost KRW" },
                            {key: 'E9', value: "Sales in KRW" },
                            {key: 'F9', value: "Total Sales in KRW" }
                            ]);
                         
                             let count = 10;
                              let number = 1;

                              if(selectedRow.length>0){
                                selectedRow.forEach(function(d){
                              
                               
                                Addrow(count, [
                                    {key: 'A'+count, value: number},
                                    {key: 'B'+count, value: d.name },
                                    {key: 'C'+count, value: (d.quantity == null? 0: d.quantity)},
                                    {key: 'D'+count, value: (d.shipping_fee == null? 0: d.shipping_fee)},
                                    {key: 'E'+count, value: (d.amount == null? 0: d.amount)},
                                    {key: 'F'+count, value: (d.total_sales== null? 0: d.total_sales)},
                                    ]);
                                    count++;
                                    number++;
                                })
                              }else{

                                selectedRow = datas;
                                datas.forEach(function(d){
                              
                                    Addrow(count, [
                                    {key: 'A'+count, value: number},
                                    {key: 'B'+count, value: d.name },
                                    {key: 'C'+count, value: (d.quantity == null? 0: d.quantity)},
                                    {key: 'D'+count, value: (d.shipping_fee == null? 0: d.shipping_fee)},
                                    {key: 'E'+count, value: (d.amount == null? 0: d.amount)},
                                    {key: 'F'+count, value: (d.total_sales== null? 0: d.total_sales)},
                                    ]);
                                    count++;
                                    number++;
                                })
                              }

                            
                            
                              let total_sales_krw = selectedRow.reduce((accumulator, currentValue) => accumulator + parseInt(currentValue.total_sales == null ?0 : currentValue.total_sales), 0);
                              let order_cancel_krw = parseInt(JSON.parse(selectedRow[0]['status_records']).filter(x=> x.status == 2)[0]['total_cancel']);
                              let oder_cancel_shipping_krw = parseInt(JSON.parse(selectedRow[0]['status_records']).filter(x=> x.status == 2)[0]['total_shipping_fees']);
                              let total_refund_krw = parseInt(JSON.parse(selectedRow[0]['status_records']).filter(x=> x.status == 7)[0]['total_cancel']);
                              let total_refund_shipping_krw = parseInt(JSON.parse(selectedRow[0]['status_records']).filter(x=> x.status == 7)[0]['total_shipping_fees']);
                              let total_ecommerce_krw =  selectedRow[0]['handling_fees'];
                              let total_mkc_krw = selectedRow[0]['marking_costs'];
                              let net_vat_ktw = (total_sales_krw * 0.1) - (total_mkc_krw *0.1);

                              Addrow(count+1, [{ key: 'E'+(count+1), value: "Total Sales (KRW)"},{key: 'F'+(count+1), value:total_sales_krw}]);
                            Addrow(count+2, [{ key: 'E'+(count+2), value: "Order Cancellations(KRW)"},{key: 'F'+(count+2), value:order_cancel_krw}]);
                            Addrow(count+3, [{ key: 'E'+(count+3), value: "Order Cancellation Shipping Fee (KRW)"},{key: 'F'+(count+3), value:oder_cancel_shipping_krw}]);
                             Addrow(count+4, [{ key: 'E'+(count+4), value: "Total Refund (KRW)"},{key: 'F'+(count+4),value: total_refund_krw}]);
                            Addrow(count+5, [{ key: 'E'+(count+5), value: "Total Refund Shipping Fee (KRW)"},{key: 'F'+(count+5), value:total_refund_shipping_krw}]);
                             Addrow(count+6, [{ key: 'E'+(count+6), value: "E-commerce Handling Charges (KRW)"},{key: 'F'+(count+6),value: total_ecommerce_krw}]);
                             Addrow(count+7, [{ key: 'E'+(count+7), value: "Total Evaluation Points (MKC) for the Month (KRW)"},{key: 'F'+(count+7),value: total_mkc_krw }]);
                             Addrow(count+8, [{ key: 'E'+(count+8), value: "Net VAT Payable (VAT Payable -VAT Receivable) (KRW)"},{key: 'F'+(count+8), value:net_vat_ktw}]);
                            
                            // total KRW
                            let total_krw = 0;
                            total_krw =  total_sales_krw - order_cancel_krw - oder_cancel_shipping_krw - total_refund_krw - total_refund_shipping_krw - total_ecommerce_krw - total_mkc_krw - net_vat_ktw;
                            
                             Addrow(count+9, [{ key: 'E'+(count+9), value: "Total (KRW)"},{key: 'F'+(count+9), value:total_krw}]);
                            Addrow(count+10, [{ key: 'E'+(count+10), value: "Adjustments"}]);

                            let net_total = total_krw;
                              let newcount = count+11;
                              let adjustments_length =1;
                              adjustments.map(x=>{
                                Addrow(newcount, [{ key: 'E'+(newcount), value: x[0]},{key: 'F'+(newcount),value: x[1]}]);
                                newcount = newcount+1;
                                adjustments_length = adjustments_length+1;
                                net_total = parseInt(net_total) + parseInt(x[1]);
                              })
                             
                            
                            //  Addrow(7, [{ key: 'A7', value: "Total Charge Amount in KRW"},{key: 'B7', value: net_total}]);
     
                             Addrow(newcount+1, [{ key: 'E'+(newcount+1), value: "Net Total (KRW)"},{key: 'F'+(newcount+1),value: net_total}]);


                             Addrow(newcount+2, [{ key: 'A'+(newcount+2), value: "Remark"}]);
                             Addrow(newcount+3, [{ key: 'A'+(newcount+3), value: "1.        This invoice should be settled by " + moment().endOf('month').format('YYYY-MM-DD')}]);
                             Addrow(newcount+4, [{ key: 'A'+(newcount+4), value: "2.        All banking charges should by paid by the payer."}]);
                             Addrow(newcount+5, [{ key: 'A'+(newcount+5), value: "3.        Please settle the invoice to the below designated bank account."}]);
                             Addrow(newcount+6, [{ key: 'A'+(newcount+6), value: "Money transfer to the account below:"}]);
                             Addrow(newcount+7, [{ key: 'A'+(newcount+7), value: "Bank Code : "},{ key: 'B'+(newcount+7), value: bank_code}]);
                             Addrow(newcount+8, [{ key: 'A'+(newcount+8), value: "COMPANY NAME : "},{ key: 'B'+(newcount+8), value: bank_company_name}]);
                             Addrow(newcount+9, [{ key: 'A'+(newcount+9), value: "BANK SWIFT CODE : "},{ key: 'B'+(newcount+9), value: bank_swift_code}]);
                             Addrow(newcount+10, [{ key: 'A'+(newcount+10), value: "BANK ACCOUNT NO : "},{ key: 'B'+(newcount+10), value: bank_acc}]);
                             Addrow(newcount+11, [{ key: 'C'+(newcount+11), value: "Make all checks payable to "+ company_name}]);



                          
                          sheet.childNodes[0].childNodes[1].innerHTML = r ;

                        }
                },
                {
                    extend: 'selected',
                    text: "Download PDF",
                    className: 'btn-print-pdf',
                    //key: 'p',
                    action: function ( e, dt, node, config ) {
                        // const rows = dt.rows( { selected: true } );
                        // const ids = rows.data().toArray().map(item => item.id);

                        // // const url = "{{ route('cms.orders.invoice', ['ids' => '__ids__']) }}".replace('__ids__', ids.join(','))
                        // window.open(url);
                    }
                },
            ],
        },
        columns: [
            {
            ...window.dataTablesHelper.selectCheckbox.columnData,
                render: function ( data, type, row, meta ) {
                    //  window.dataTablesHelper.selectCheckbox.html;
                    return  window.dataTablesHelper.selectCheckbox.html;
                },
            },      
            { data: 'barcode', name: 'barcode',},
            { data: 'name', name: 'name',},
            { data: 'quantity', name: 'quantity',},
            { data: 'amount', name: 'amount',},
            { data: 'total_sales', name: 'total_sales',},
            // { data: 'created_at', name: 'created_at', render: function(data,type,row,meta){
            //     return moment(data).format('YYYY-MM-DD')
            // }},
            // { data: 'file_name', name: 'file_name',},
            // { data: 'devp', name: 'devp',},
            // { data: 'marketing_cost', name: 'marketing_cost',},
            // { data: 'vat_status', name: 'vat_status',},
        ],
        enableSelect: true,
        isSelectableRow: function(row, data, dataIndex) {
            return true;
        },
        onSelectRow: function (count) {
            selectedRow = table.rows({ selected: true }).data().toArray()
            $('.btn-download-excel span').html(`Download Excel File ${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;
             }
        },
        dom: "<'row mb-2 dataTables-header-dom'<'col-sm-12 col-lg px-0 px-lg-2 mb-2 mb-lg-0 dataTables-buttons-dom'B><'col col-lg-auto px-0 px-lg-2 d-flex align-items-center mb-2 mb-sm-0 dataTable-custom-toolbar-dom'><'col col-sm-auto d-flex align-items-center px-0 px-md-2 dataTables-search-dom'f>>" +
        "<'row'<'col-sm-12'r>>" +
        "<'row dataTables-table-dom'<'col-sm-12'tr>>" +
        "<'row dataTables-footer-dom'<'col-sm-6 col-md-auto px-0 px-md-2 my-2 my-md-0 dataTables-length-dom'l><'col-sm-12 col-md px-0 px-md-2 dataTables-pagination-dom'p>>",
    })
});
</script>

@endpush

@section("title")

    Generate Invoice

    @endsection

    @section("content")
    <div class="alert alert-success sync-loading" role="alert" style="display:none">
      Processing...
    </div>
    <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="Total Qty Sold"
                        value="{{$total_sales->quantity == null?0:$total_sales->quantity}}"
                    >
                    </x-card.stat>
                </div>
                <div class="col-auto">
                    <x-card.stat
                        title="Total Sales in KRW"
                        value="{{$total_sales->total_sales == null?0:$total_sales->total_sales}}"
                    />
                </div>

                <div class="col col-sm-auto">
                    <x-card.stat
                        title="Marketing Costs in KRW"
                        value="{{$marketing_costs == null ? 0 :$marketing_costs->cost}}"
                    />
                </div>

                <div class="col col-sm-auto">
                    <x-card.stat
                        title="Net Sales in KRW"
                        value="0"
                    />
                </div>

            </div>
        </div>
        <div class="col-md d-flex justify-content-md-end align-items-end col-lg-12 col-md-12">
        <div class="row">
            <div class="col-auto">
                <button type="button" class="btn btn-primary btn-icon " data-toggle="modal" data-target="#adjustments">
                    <i class="las la-upload mr-2"></i>
                    Add / Edit Adjustments
                </button>
            </div>
         
               
                
            </div>
        </div>
    </div>


    <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
                    $country_options = ['1'=>'China','2'=>'Hong Kong','3' => 'Japan','4'=>'Korea','5'=>'USA'];

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

              </div>
              <div class="col-sm-auto">
                @php
                    $platforms_options = \App\Platform::all()->pluck('name', 'id')->toArray();

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

              </div>
              <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">
                    <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>
        </div>
            <table id="dataTable" class="table table-hover w-100">
                <thead>
                    <tr>
                    <th class="align-middle"><span class="select-checkbox"></span></th>
                    <th>Product Barcode</th>
                    <th>Product Name</th>
                    <th>Sales Quantity</th>
                    <th>Sales in KRW</th>
                    <th>Total Sales in KRW</th>
                    </tr>
                </thead>
            </table>
        </div>
    </div>



    <x-modal.master id="adjustments" class="modal-import" title="Add Adjustments" size="lg">
        {{ Form::open(['route' => 'cms.analysts.marketing_import', 'method' => 'POST', 'id' => 'form_adjustment', 'files' => true]) }}
        @php
            $platforms_options = \App\Platform::all()->pluck('name', 'id');
        @endphp
        <x-form.form-group.select
            name="platform_id"
            label="{{ __('cms.order.platform') }}"
            :options="$platforms_options"
            withAny="0"
            editing="1"
        >
        </x-form.form-group.select>

    
        <x-form.form-group.select
            name="store_option2"
            label="{{ __('cms.shipping.store') }}"
            :options="[]"
            withAny="0"
            editing="1"
    >
    </x-form.form-group.select>

    <x-form.form-group.input
            class="description-input"
            name="description"
            label="Adjustment Description"
            editing="1"
    >
    </x-form.form-group.input>

    <x-form.form-group.input
            class="value-input"
            name="value"
            label="Adjustment Value in KRW"
            editing="1"
    >
    </x-form.form-group.input>

    <div class="row description-text" style="display:none">
        <div class="col-auto col-6">
            <lable>Adjustment Description</lable>
        </div>
        <div class="col-auto col-6">
            <lable>Adjustment Value in KRW</lable>
        </div>
    </div>

    <div class="row description-text2">
       
    </div>

    <div class="row">
    <div class="col-auto">
                <button type="button" class="btn btn-primary btn-icon view-adjustment">
                 
                    View Adjustments
                </button>

                <button type="button" class="btn btn-primary btn-icon go-back" style="display:none">
                 
                Go Back to ADD New
             </button>
            </div>
            <div class="col-auto">
                <button type="button" class="btn btn-primary btn-icon add-adjustment">

                    Add 
                </button>
            </div>
            </div>

        {{ Form::close() }}


   
    </x-modal.master>


    @endsection