@include('common.header')
<!-- /.info-box -->
<div id="upload-info-box-content" style="display:none;">
  <div class="info-box bg-yellow">
    <span class="info-box-icon">
      <i class="fa fa-search"></i>
    </span>
    <div class="info-box-content">
      <div class="overlay">
        <i class="fa fa-refresh fa-spin"></i>
        <span class="info-box-text" id="upload-info-box-text">SEARCHING IN PROGRESS</span>
      </div>
    </div>
    <!-- /.info-box-content -->
  </div>
  <!-- /.info-box -->
</div>
<!-- /.info-box -->
<section class="content"> @include('alert.alert_panel') <div class="col-lg-12" id="load-overlay" name="load-overlay" style="display:none;">
    <div id="loader"></div>
    <div id="overlay"></div>
  </div>
  <div class="row">
    <div class="col-xs-12">
      <div class="box box-warning">
        <form>
          <div class="box-header">
            <h3 class="box-title">
              <b>Unmanifested Waybill Arrived HQ With Activity Report</b>
            </h3>
            <!-- <div class="box-tools"><div style="width: 160px;"><a href="{{ url('/home/manifest_search') }}" class="btn btn-default pull-right"><i class="fa fa-search"></i></a><a href="{{ url('/home/manifest_add') }}" class="btn btn-info pull-right"><i class="fa fa-pencil"></i></a></div></div> -->
          </div>
          <!-- /.box-header -->
          <div class="box-body table-responsive no-padding">
            <table class="table">
              <tr class="filterByDestTR">
                <td>
                  <label>From Station</label>
                </td>
                <td>
                  <div class="form-group">
                    <select class="form-control select2" id="init-src-warehouse"  style="width: 100%;"> 
                    <option value="all">All Stations</option>
                    @foreach($hub_list as $hub) <option value="{{ $hub->code }}">{{ $hub->stateShort }} - {{ $hub->stateLong }}</option> @endforeach </select>
                  </div>
                </td>
              </tr>
              <tr>
                <td>
                  <b>Arrived HQ Date From </b>date
                </td>
                <td>
                  <input type="date" class="form-control input-sm" id="from-date" placeholder="" min="1900-01-01">
                </td>
                <td>
                  <b>Arrived HQ Date To </b>date
                </td>
                <td>
                  <input type="date" class="form-control input-sm" id="to-date" placeholder="" max="2050-01-01">
                </td>
              </tr>
              <tr>
                <td colspan="4">
                  <button type="button" class="btn btn-success pull-right" id="export-excel" name="export_excel" onclick="search_waybill()">
                    <i class="fa  fa-file-excel-o"></i>Search & Export </button>
                </td>
              </tr>
            </table>
          </div>
        </form>
      </div>
    </div>
  </div>
</section> @include('common.footer')


<script>
var allWaybills                 = [];
var allWaybillsRemovedDuplicate = [];
var waybillsTable               = "";


//initialize select 2 render function
$('.select2').select2();


// A $( document ).ready() block.
$( document ).ready(function() {

    //initializeDataTable()
    var                     today              = IOSDateToLocalDateString_withoud_time_YMD(new Date())
    document.getElementById('from-date').value = today;
    document.getElementById('to-date').value   = today;
});



async function search_waybill()
{  
    allWaybills = [];
    $("#load-overlay").show();
    hide_success();

    var dataArray = {};
    dataArray['from']               = localTimeToSQLGMT($("#from-date").val(),"from") ;
    dataArray['to']                 = localTimeToSQLGMT($("#to-date").val(),"to") ;
    dataArray['initSrcWarehouseID'] = "";

    if($("#init-src-warehouse").val() != "all")
    {
      dataArray['initSrcWarehouseID']= $("#init-src-warehouse").val() ;

    }
  
        $("#upload-info-box-content").show();
        var page = 1
        var searchEnpoint = "{{ URL::to('/post/call/hq/getShippingActivityByUnmanifestedWaybillArrivedHQDate')}}"; 
                        while(1)
                        {
                            const searchResult = await syncAjaxCall(dataArray,searchEnpoint+"?page="+page,"POST","");
                                  allWaybills  = allWaybills.concat(searchResult);
                                  page++
                                    if(searchResult.length <10000){break;}
                                    if(searchResult.length == 0){break;}
                        }
                        if(allWaybills.length == 0){
                            show_warning("No Waybill Found !")
                            $("#upload-info-box-content").hide();
                            $("#load-overlay").hide();
                            return;
                        }
     $("#upload-info-box-content").hide();
     processWaybillRemoveDuplicate()
}

    function processWaybillRemoveDuplicate()
    {   
        allWaybillsRemovedDuplicate = []
        allWaybills.forEach(function (waybill, index) {
                allWaybillsRemovedDuplicate[waybill.WaybillNo]=waybill;
        });
        exportData()
    }

    function exportData()
    {
        var exportWaybillObject = []
        //copy allWaybillsRemovedDuplicate to exportWaybillObject because allWaybillsRemovedDuplicate key is waybillNo not able to iterate in excel export 
          for (i in allWaybillsRemovedDuplicate)
          {
            allWaybillsRemovedDuplicate[i].WaybillNo          = "'"+allWaybillsRemovedDuplicate[i].WaybillNo
            allWaybillsRemovedDuplicate[i].WaybillCreatedDate = allWaybillsRemovedDuplicate[i].WaybillCreatedDate == null ? "" : IOSDateToLocalDateString_withoud_time_DMY_monthLong(allWaybillsRemovedDuplicate[i].WaybillCreatedDate)
            allWaybillsRemovedDuplicate[i].ManifestedDate     = allWaybillsRemovedDuplicate[i].ManifestedDate     == null ? "" : IOSDateToLocalDateString_withoud_time_DMY_monthLong(allWaybillsRemovedDuplicate[i].ManifestedDate)
            allWaybillsRemovedDuplicate[i].ArriveHqDate       = allWaybillsRemovedDuplicate[i].ArriveHqDate       == null ? "" : IOSDateToLocalDateString_withoud_time_DMY_monthLong(allWaybillsRemovedDuplicate[i].ArriveHqDate)
            allWaybillsRemovedDuplicate[i].ToTransitDate      = allWaybillsRemovedDuplicate[i].ToTransitDate      == null ? "" : IOSDateToLocalDateString_withoud_time_DMY_monthLong(allWaybillsRemovedDuplicate[i].ToTransitDate)
            allWaybillsRemovedDuplicate[i].ArrivedDestDate    = allWaybillsRemovedDuplicate[i].ArrivedDestDate    == null ? "" : IOSDateToLocalDateString_withoud_time_DMY_monthLong(allWaybillsRemovedDuplicate[i].ArrivedDestDate)
            allWaybillsRemovedDuplicate[i].OfdDate            = allWaybillsRemovedDuplicate[i].OfdDate            == null ? "" : IOSDateToLocalDateString_withoud_time_DMY_monthLong(allWaybillsRemovedDuplicate[i].OfdDate)
            allWaybillsRemovedDuplicate[i].PodDate            = allWaybillsRemovedDuplicate[i].PodDate            == null ? "" : IOSDateToLocalDateString_withoud_time_DMY_monthLong(allWaybillsRemovedDuplicate[i].PodDate)
            exportWaybillObject.push(allWaybillsRemovedDuplicate[i]);
        }

       var from               = $("#from-date").val()
       var to                 = $("#to-date").val()
       var init_src_warehouse = $("#init-src-warehouse").val() ;
       var filename           = "'BBB Manifested Report With Activity -"+init_src_warehouse+'_'+from+' to '+to

        const xls = new XlsExport(exportWaybillObject, 'BBB Manifested Report With Activity')
        xls.exportToXLS(filename+'.xls') 
        $("#load-overlay").hide();
        show_success("Report Generated as File Name : "+filename)
    }


    function show_warning($msg)
    {
                    $("#invalid-warning-message").html($msg);
                    $("#invalid-warning").show();
                    $("#invalid-warning").delay(3000).hide(0, function() {});
    }

    function show_danger($msg)
    {
                    $("#invalid-danger-message").html($msg);
                    $("#invalid-danger").show();
                    $("#invalid-danger").delay(3000).hide(0, function() {});
    }

    function show_success($msg)
    {
                    $("#invalid-success-message").html($msg);
                    $("#invalid-success").show();                    
    }


    function hide_success()
    {
                    $("#invalid-success").hide();                    
    }

    function show_final_result($msg)
    {
                    $("#invalid-success-message").html($msg);
                    $("#invalid-success").show();
                    
    }

    function sleep(delay) {
        var start = new Date().getTime();
        while (new Date().getTime() < start + delay);
      }

    function displayProcess(upload_info_box_number,upload_progress_description,width)
    {
        $("#upload-info-box-content").show();
        $('#upload-info-box-number').text(upload_info_box_number);
        $('#upload-progress-description').text(upload_progress_description);
        $("#upload-progress-bar").width(width+'%')
    }
</script>