@extends('admin.layout.app')

@section('more-head')
 <link rel="stylesheet" href="{{ asset('admin/bower_components/datatables.net-bs/css/dataTables.bootstrap.min.css') }}">
@endsection

@section('main-content')
 <section class="content-header">
  <h1>
   OPERATIONS MANAGEMENT SYSTEM
  </h1>

 </section>

 <section class="content">

  <div class="box">
   <div class="box-header with-border hiide">
    <h3 class="box-title">M & E Audit Logs</h3>
    <form class="form-inline">
     <div class="form-group col-sm-offset-3 mb-2">
      <input type="text" name="q" placeholder="Search..." class="form-control" />
     </div>
     <input type="submit" class="btn btn-primary mb-4" value="Search" />
     <div class="form-group mx-bg-3 col-sm-offset-3 mb-2">
      <a href="{{ URL::route('audit_log.export') }}" class="btn btn-success" id="batt"> Export To Excel </a>
     </div>
    </form>
    <div class="box-tools pull-right">
     <button type="button" class="btn btn-box-tool" data-widget="collapse" data-toggle="tooltip" title="Collapse">
      <i class="fa fa-minus"></i></button>

    </div>
   </div>
   <div class="box-body table-responsive">
    <table id="example2" class="table-bordered table-striped table">
     <thead>

      <tr>
       <th>No.</th>
       <th>TOC</th>
       <th>Cost Sheet Ref</th>
       <th>Cost Sheet Date</th>
       <th>WPO Arrival User Time</th>
       <th>WPO Arrival Supervisor Time</th>
       <th>WPO Status</th>
       <th>TOC Audit Secretary Time</th>
       <th>Reasons for Return</th>
       <th>TOC Audit User Time</th>
       <th>TOC Audit Supervisor Time</th>
       <th>TOC Audit Certifier Time</th>
       {{-- <th>Audit Status</th> --}}
       <th>Accra Accounts User Time</th>
       <th>Accra Accounts Supervisor Time</th>
       <th>Accra Accounts Authorizer Time</th>
       <th>Accra Audit Secretary Time</th>
       <th>Reasons for Return</th>
       <th>Accra Audit User Time</th>
       <th>Accra Audit Supervisor Time</th>
       <th>Accra Audit Authorizer Time</th>
      </tr>
     </thead>
     <tbody>

      @foreach ($cost_sheets as $cost_sheet)
       <tr>
        <td>{{ $count++ }}.</td>
        <td style="font-weight: bold; color: darkcyan;">{{ $cost_sheet->port->name }}</td>
        <td>{{ $cost_sheet->cost_sheet_ref }}</td>
        <td>
         {{ $cost_sheet->cost_sheet_date ? Carbon\Carbon::parse($cost_sheet->cost_sheet_date)->format('j M Y') : null }}
        </td>
        <td>
         {{ $cost_sheet->wpo_arrival_time ? Carbon\Carbon::parse($cost_sheet->wpo_arrival_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ $cost_sheet->wpo_arrival_supervisor_time ? Carbon\Carbon::parse($cost_sheet->wpo_arrival_supervisor_time)->format('j M Y g:i a') : null }}
        </td>
        <td>{{ $cost_sheet->status }}</td>
        <td>
         {{ optional($cost_sheet->audit_logs->last())->toc_audit_secretary_time ? Carbon\Carbon::parse(optional($cost_sheet->audit_logs->last())->toc_audit_secretary_time)->format('j M Y g:i a') : null }}
        </td>
        <td>{{ optional($cost_sheet->audit_logs->last())->toc_reasons_for_return }}</td>
        <td>
         {{ $cost_sheet->toc_audit_user_time ? Carbon\Carbon::parse($cost_sheet->toc_audit_user_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ $cost_sheet->toc_audit_supervisor_time ? Carbon\Carbon::parse($cost_sheet->toc_audit_supervisor_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ $cost_sheet->toc_audit_authorizer_time ? Carbon\Carbon::parse($cost_sheet->toc_audit_authorizer_time)->format('j M Y g:i a') : null }}
        </td>
        {{-- <td>{{ $cost_sheet->audit_status }}</td> --}}
        <td>
         {{ $cost_sheet->accounts_user_time ? Carbon\Carbon::parse($cost_sheet->accounts_user_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ $cost_sheet->accounts_supervisor_time ? Carbon\Carbon::parse($cost_sheet->accounts_supervisor_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ $cost_sheet->accounts_authorizer_time ? Carbon\Carbon::parse($cost_sheet->accounts_authorizer_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ optional($cost_sheet->audit_logs->last())->accra_audit_secretary_time ? Carbon\Carbon::parse(optional($cost_sheet->audit_logs->last())->accra_audit_secretary_time)->format('j M Y g:i a') : null }}
        </td>
        <td>{{ optional($cost_sheet->audit_logs->last())->accra_reasons_for_return }}</td>
        <td>
         {{ $cost_sheet->accra_audit_user_time ? Carbon\Carbon::parse($cost_sheet->accra_audit_user_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ $cost_sheet->accra_audit_supervisor_time ? Carbon\Carbon::parse($cost_sheet->accra_audit_supervisor_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ $cost_sheet->accra_audit_authorizer_time ? Carbon\Carbon::parse($cost_sheet->accra_audit_authorizer_time)->format('j M Y g:i a') : null }}
        </td>
      @endforeach
     </tbody>

    </table>
    {!! $cost_sheets->render() !!}
   </div>
  </div>
 </section>
@endsection

@section('more-scripts')
 <script src="{{ asset('admin/bower_components/datatables.net/js/jquery-3.5.1.js') }}"></script>
 <script src="{{ asset('admin/bower_components/datatables.net/js/jquery.dataTables.min.js') }}"></script>
 <script>
  $('#batt').click(function() {
   var button = $(this);
   button.attr('disabled', 'disabled');
  });

  // $('#batt').click(function(){
  //   var button = $(this);
  //   button.html("Downloading...").attr('disabled', 'disabled');
  //   setTimeout(function() {
  //    button.removeAttr('disabled').html("Export To Excel");
  //  },200000);
  // });


  $(function() {
   $('.showee').hide();
   $('#example1').DataTable()
   $('#example2').DataTable({
    'searching': false,
    'paging': false,
    'ordering': true,

   });


  })
 </script>
@endsection