@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>LBC</th>
       <th>Summary Ref</th>
       <th>Summary Created At</th>
       <th>WPO Stats User Time</th>
       <th>WPO Stats 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>Claim Ref</th>
       <th>Claim Date</th>
       <th>Claim Created At</th>
       <th>Prepared By Time</th>
       <th>Supervised By Time</th>
       <th>Approved By Time</th>
       <th>Authorized By Time</th>
       <th>Moved By Accounts Time</th>
       <th>ACCRA Audit Secretary Time</th>
       <th>Reasons for Return</th>
       <th>Vetted By Time</th>
       <th>Validated By Time</th>
       <th>Certfied By Time</th>
       <th>Dispatch to Produce Finance</th>
      </tr>
     </thead>
     <tbody>

      @foreach ($summary_sheets as $summary_sheet)
       <tr>
        <td>{{ $count++ }}.</td>
        <td style="font-weight: bold; color: darkcyan;">{{ $summary_sheet->port->name }}</td>
        <td>{{ $summary_sheet->lbc->name }}</td>
        <td>{{ $summary_sheet->ref_no }}</td>
        <td>
         {{ $summary_sheet->created_at ? Carbon\Carbon::parse($summary_sheet->created_at)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ $summary_sheet->wpo_stats_user_time ? Carbon\Carbon::parse($summary_sheet->wpo_stats_user_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ $summary_sheet->wpo_stats_supervisor_time ? Carbon\Carbon::parse($summary_sheet->wpo_stats_supervisor_time)->format('j M Y g:i a') : null }}
        </td>
        <td>{{ $summary_sheet->status }}</td>
        <td>
         {{ optional($summary_sheet->audit_logs->last())->toc_audit_secretary_time ? Carbon\Carbon::parse(optional($summary_sheet->audit_logs->last())->toc_audit_secretary_time)->format('j M Y g:i a') : null }}
        </td>
        <td>{{ optional($summary_sheet->audit_logs->last())->toc_reasons_for_return }}</td>
        <td>
         {{ $summary_sheet->toc_audit_user_time ? Carbon\Carbon::parse($summary_sheet->toc_audit_user_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ $summary_sheet->toc_audit_supervisor_time ? Carbon\Carbon::parse($summary_sheet->toc_audit_supervisor_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ $summary_sheet->toc_audit_certifier_time ? Carbon\Carbon::parse($summary_sheet->toc_audit_certifier_time)->format('j M Y g:i a') : null }}
        </td>
        <td>{{ $summary_sheet->audit_status }}</td>
        <td>{{ optional($summary_sheet->claim)->claim_ref }}</td>
        <td>
         {{ optional($summary_sheet->claim)->claim_date ? Carbon\Carbon::parse(optional($summary_sheet->claim)->claim_date)->format('j M Y') : null }}
        </td>
        <td>
         {{ optional($summary_sheet->claim)->created_at ? Carbon\Carbon::parse(optional($summary_sheet->claim)->created_at)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ optional($summary_sheet->claim)->prepared_by_time ? Carbon\Carbon::parse(optional($summary_sheet->claim)->prepared_by_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ optional($summary_sheet->claim)->supervised_by_time ? Carbon\Carbon::parse(optional($summary_sheet->claim)->supervised_by_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ optional($summary_sheet->claim)->approved_by_time ? Carbon\Carbon::parse(optional($summary_sheet->claim)->approved_by_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ optional($summary_sheet->claim)->authorized_by_time ? Carbon\Carbon::parse(optional($summary_sheet->claim)->authorized_by_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ optional(optional(optional($summary_sheet->claim)->audit_logs)->first())->accra_audit_secretary_time ? Carbon\Carbon::parse(optional(optional(optional($summary_sheet->claim)->audit_logs)->first())->accra_audit_secretary_time)->format('j M Y g:i a') : null }}
        </td>
        <td>{{ optional(optional(optional($summary_sheet->claim)->audit_logs)->last())->accra_reasons_for_return }}</td>
        <td>
         {{ optional($summary_sheet->claim)->vetted_by_time ? Carbon\Carbon::parse(optional($summary_sheet->claim)->vetted_by_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ optional($summary_sheet->claim)->validated_by_time ? Carbon\Carbon::parse(optional($summary_sheet->claim)->validated_by_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ optional($summary_sheet->claim)->certified_by_time ? Carbon\Carbon::parse(optional($summary_sheet->claim)->certified_by_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ optional($summary_sheet->claim)->moved_by_accounts_time ? Carbon\Carbon::parse(optional($summary_sheet->claim)->moved_by_accounts_time)->format('j M Y g:i a') : null }}
        </td>
        <td>
         {{ optional(optional(optional($summary_sheet->claim)->audit_logs)->last())->accra_audit_secretary_time ? Carbon\Carbon::parse(optional(optional(optional($summary_sheet->claim)->audit_logs)->last())->accra_audit_secretary_time)->format('j M Y g:i a') : null }}
        </td>
      @endforeach
     </tbody>

    </table>
    {!! $summary_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