@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>HQ Manifested Waybill 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>
                <td>
                  <label>Filter Option</label>
                </td>
                <td>
                  <div class="form-group">
                    <select class="form-control select2" id="filter-option" style="width: 100%;">
                      <option value="consolidates_dest">Filter By Manifested Destination Station</option>
                      <option value="account_no">Filter By Customer Account</option>
                    </select>
                  </div>
                </td>
              </tr>
              <tr class="filterByDestTR">
                <td>
                  <label>Destination Station</label>
                </td>
                <td>
                  <div class="form-group">
                    <select class="form-control select2" id="dest-station" name="dest_station" style="width: 100%;"> @foreach($hub_list as $hub) <option value="{{ $hub->code }}">{{ $hub->stateShort }} - {{ $hub->stateLong }}</option> @endforeach </select>
                  </div>
                </td>
              </tr>
              <tr class="filterByAccoutTR">
                <td>
                  <label>Customer Account</label>
                </td>
                <td>
                  <div class="form-group">
                    <label class="control-label col-sm-4" for="title">1 step - Select Station:</label>
                    <div class="col-sm-8">
                      <select class="form-control select2" id="station-add" name="station-add" style="width: 100%;">
                        <option value="">Select Station</option> @foreach($hub_list as $hub) <option value="{{ $hub->code }}">{{ $hub->stateShort }} - {{ $hub->stateLong }}</option> @endforeach
                      </select>
                    </div>
                  </div>
                </td>
                <td>
                  <div class="form-group">
                    <label class="control-label col-sm-4" for="title">2 step - Select Customer Account:</label>
                    <div class="col-sm-8">
                      <div class="overlay" id="uid_add_spin" hidden>
                        <i class="fa fa-refresh fa-spin"></i>
                      </div>
                      <select class="form-control select2" id="account-no" name="account-no" style="width: 100%;">
                        <option value="">Select Customer</option>
                      </select>
                    </div>
                  </div>
                <td>
              </tr>
              <tr>
                <td>
                  <b>Manifested From </b>date
                </td>
                <td>
                  <input type="date" class="form-control input-sm" id="from-date" placeholder="" min="1900-01-01">
                </td>
                <td>
                  <b>Manifested 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() {

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


//detect warehouse select2 change even
$('#filter-option').on('select2:select', function (e) 
{
  
    if($("#filter-option").val() == "consolidates_dest"){
        $('tr.filterByAccoutTR').hide();
        $('tr.filterByDestTR').show();
    }

    if($("#filter-option").val() == "account_no"){
        $('tr.filterByAccoutTR').show();
        $('tr.filterByDestTR').hide();
    }
});

//detect warehouse select2 change even
$('#station-add').on('select2:select', function (e) 
{
    $("#uid_add_spin").show();
    $("#account-no").empty();
    $.ajax({
                type:"POST",//or POST
                url:"{{ URL::to('/hq/hq_consumer_register_search/get_all_customer_by_warehouse') }}"+"/"+$("#station-add").val(),
                data: {
                    '_token': "{{ csrf_token() }}",
                },
                success: function(responsedata) 
                {
                    if(responsedata.status=="SUCCESS")
                    {
                        for(data of responsedata.response)
                        {
                            $("#account-no").append("<option value='" + data.account_no + "'"+
                                                  " data-account_no='"+data.account_no+"'"+
                                                  " data-address='"+data.address+"'"+
                                                  " data-contact_name='"+data.contact_name+"'"+
                                                  " data-contact_number='"+data.contact_number+"'"+
                                                  " data-name='"+data.name+"'"+
                                                  " data-postcode='"+data.postcode+"'"+
                                                  " data-state_long='"+data.state_long+"'"+
                                                  " data-warehouse_code='"+data.warehouse_code+"'"+
                                                  ">"+data.account_no+" - "+data.name+"</option>")
                        }
                      //console.log(responsedata.response)
                      $("#uid_add_spin").hide();
                    }
                   
                },
            });
    

});


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") ;

    if($("#filter-option").val() == "consolidates_dest"){
        dataArray['dest_station']= $("#dest-station").val() ;
    }

    if($("#filter-option").val() == "account_no"){
        dataArray['account_no']= $("#account-no").val() ;
    }


        $("#upload-info-box-content").show();
        var page = 1
        var searchEnpoint = "{{ URL::to('/post/call/hq/getShippingActivityByWaybillManifestedDate')}}"; 
                        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 dest_station = $("#dest-station").val() ;
       var account_no   = $("#account-no").val() ;

    if($("#filter-option").val() == "consolidates_dest"){
        filename = "'BBB Manifested Report With Activity -"+dest_station+'_'+from+' to '+to
    }

    if($("#filter-option").val() == "account_no"){
        filename = "'BBB Manifested Report With Activity -"+account_no+'_'+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>