@extends('layouts.app')

@section('custom-css')
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.24/css/jquery.dataTables.min.css">
@endsection

@section('content')

<div class="page-body display" id="printableArea">
    @if (session('success'))
        <div class="alert alert-success">
            {{ session('success') }}
        </div>
    @endif
    <div class="card">
        <div class="card-header">
            <h5>Shiper Adviser Parcel</h5>
            <div class="text-right">
                <button id="btnExport" onclick="fnExcelReport();" class="btn btn-primary">Export to Excel</button>
            </div>
        </div>
        <div class="card-block table-border-style">
            <div class="table-responsive">
                <table class="table table-hover" id="example">
                    <thead>
                        <tr>
                            <th>#</th>
                            <th>Customer Ref</th>
                            <th>Parcel Attempts</th>
                            <th>Vendor Name</th>
                            <th>Age</th>
                            <th>Amount</th>
                            <th>Order ID</th>
                            <th>Status</th>
                            <th>Cancel At</th>
                            <th>Customer Name</th>
                            <th>Customer Address</th>
                            <th>Customer Phone</th>
                            <th>Shiper Advise</th>
                            <th>Shiper Date</th>
                            <th>AHL Reply</th>
                            <th>AHL Reply At</th>
                            <th style="min-width: 100px;">IVR Remarks</th>
                            <th>Send Reply</th>
                        </tr>
                    </thead>
                    <tbody id="parcel-data">
                        <!-- parcel data prepand here through also ajax -->

                        @foreach($shiperParcelsAdvise as $parcelAdvise)
                            <tr id="tr-{{$parcelAdvise->id}}">
                                <td> {{ $loop->iteration }} </td>
                                <td> {{ $parcelAdvise->order_reference }} </td>
                                <td> {{ $parcelAdvise->parcel_attempts }} / {{ $parcelAdvise->parcel_limit }} </td>
                                <td> {{ $parcelAdvise->vendor ? $parcelAdvise->vendor->vendor_name : '' }} </td>
                                @if(!empty($parcelAdvise->scanOrder->middle_man_scan_date))
                                <td>
                                    {{\Carbon\Carbon::parse($parcelAdvise->scanOrder->middle_man_scan_date)->diffInDays(\Carbon\Carbon::now())}} Days
                                </td>
                                @else
                                <td></td>
                                @endif
                                <td> {{ $parcelAdvise->consignment_cod_price }} </td>
                                <td> {{ $parcelAdvise->consignment_order_id }} </td>
                                <td> {{ $parcelAdvise->orderStatus ? $parcelAdvise->orderStatus->name : '' }} </td>
                                <td>{{ date('d-m-Y H:i A', strtotime($parcelAdvise->updated_at)) }} </td>
                                <td> {{ $parcelAdvise->full_name }} </td>
                                <td> {{ $parcelAdvise->consignee_address }} </td>
                                <td> {{ $parcelAdvise->consignee_phone }} </td>
                                <td> {{ ($parcelAdvise->shiperAdviser) ? $parcelAdvise->shiperAdviser->advise : '' }} </td>
                                <td> {{ date('d-m-Y H:i A', strtotime($parcelAdvise->shiperAdviser->created_at)) }} </td>
                                <td> {{ ($parcelAdvise->shiperAdviser) ? $parcelAdvise->shiperAdviser->ahl_reply : '' }} </td>
                                @if(!empty($parcelAdvise->shiperAdviser->ahl_reply))
                                <td>{{date('d M Y H:i A', strtoTime($parcelAdvise->shiperAdviser->updated_at))}}</td>
                                @else
                                <td></td>
                                @endif
                                <td style="min-width: 100px;">
                                    @foreach($parcelAdvise->countOrderAssigned as $key => $orderAssigned)
                                        <br />
<b>Warning</b>:  Undefined variable $orderAssigned in <b>/home/ahlpk/public_html/admin/backup/resources/views/first_man/shiper-advise.blade.php</b> on line <b>82</b><br />
<br />
<b>Warning</b>:  Attempt to read property "ivr_value" on null in <b>/home/ahlpk/public_html/admin/backup/resources/views/first_man/shiper-advise.blade.php</b> on line <b>82</b><br />
<br />
<b>Warning</b>:  Undefined variable $orderAssigned in <b>/home/ahlpk/public_html/admin/backup/resources/views/first_man/shiper-advise.blade.php</b> on line <b>101</b><br />
<br />
<b>Warning</b>:  Attempt to read property "ivr_value" on null in <b>/home/ahlpk/public_html/admin/backup/resources/views/first_man/shiper-advise.blade.php</b> on line <b>101</b><br />
<br />
<b>Warning</b>:  Undefined variable $orderAssigned in <b>/home/ahlpk/public_html/admin/backup/resources/views/first_man/shiper-advise.blade.php</b> on line <b>122</b><br />
<br />
<b>Warning</b>:  Attempt to read property "call_input" on null in <b>/home/ahlpk/public_html/admin/backup/resources/views/first_man/shiper-advise.blade.php</b> on line <b>122</b><br />
                                        {{$call_input_value}}
                                        <hr>
                                    @endforeach
                                </td>
                                <td>
                                    <a target="_blank" href="{{route('shiperReply', $parcelAdvise->shiperAdviser->id)}}">
                                        <button class="btn waves-effect waves-light btn-primary"><i class="fa fa-edit"></i>Edit</button>
                                    </a>
                                </td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
                {{$shiperParcelsAdvise->links()}}
            </div>
        </div>
    </div>
</div>
@endsection

@section('custom-js')
<script type="text/javascript" src="https://cdn.datatables.net/1.10.24/js/jquery.dataTables.min.js"></script>
<SCRIPT language="javascript">
var table;
$(function () {
    var table = $('#example').DataTable({
        'lengthMenu': [75],
        'pageLength': 75
    });
});
function fnExcelReport()
{
    var tab_text="<table border='2px'><tr bgcolor='#87AFC6'>";
    var textRange; var j=0;
    tab = document.getElementById('example'); // id of table

    for(j = 0 ; j < tab.rows.length ; j++) 
    {     
        tab_text=tab_text+tab.rows[j].innerHTML+"</tr>";
        //tab_text=tab_text+"</tr>";
    }

    tab_text=tab_text+"</table>";
    tab_text= tab_text.replace(/<A[^>]*>|<\/A>/g, "");//remove if u want links in your table
    tab_text= tab_text.replace(/<img[^>]*>/gi,""); // remove if u want images in your table
    tab_text= tab_text.replace(/<input[^>]*>|<\/input>/gi, ""); // reomves input params

    var ua = window.navigator.userAgent;
    var msie = ua.indexOf("MSIE "); 

    if (msie > 0 || !!navigator.userAgent.match(/Trident.*rv\:11\./))      // If Internet Explorer
    {
        txtArea1.document.open("txt/html","replace");
        txtArea1.document.write(tab_text);
        txtArea1.document.close();
        txtArea1.focus(); 
        sa=txtArea1.document.execCommand("SaveAs",true,"Say Thanks to Sumit.xls");
    }  
    else                 //other browser not tested on IE 11
        sa = window.open('data:application/vnd.ms-excel,' + encodeURIComponent(tab_text));  

    return (sa);
}
</SCRIPT>
@endsection