@extends('layouts.app')

@section('content')

    <div class="pad-all text-center">
       <form class="" action="{{ route('payment_report.index') }}" method="GET">
            <div class="box-inline mar-btm pad-rgt">
                 {{ translate('Sort by payment status') }}:
                 <div class="select">
                     <select class="demo-select2" name="payment_status" required>
                        <option value="paid"  >{{ translate('Paid') }}</option>
                        <option value="unpaid"  >{{ translate('Unpaid') }}</option>
                        <option value="failed"   >{{ translate('Failed') }}</option>
                     </select>
                 </div>
            </div>
            <button class="btn btn-default" type="submit">{{ translate('Filter') }}</button>
        </form>
    </div>

    
    <div class="col-md-offset-2 col-md-8">
        <div class="panel">
            <!--Panel heading-->
            <div class="panel-heading">
                <h3 class="panel-title">{{ translate('Payment report') }}</h3>
                <form class=""  action="{{route('payment.report.export')}}" method="GET">
                    <input type="text" name="daterange" value="" placeholder=" Select Date"  style="margin-right: 136px; float: right; margin-top: -28px;">
                    <h3 class="panel-title" style="float: right; margin-top: -35px;"><button type="submit" class="btn"><i class="fa fa-download" aria-hidden="true"></i>{{ translate('Payment report') }}</button></h3>
                </form>
            </div>

            <!--Panel body-->
            <div class="panel-body">
                <div class="table-responsive">
                    <table class="table table-striped mar-no demo-dt-basic">
                        <thead>
                            <tr>
                                <th>{{ translate('S. NO') }}</th>
                                <th>{{ translate('Date') }}</th>
                                <th>{{ translate('Order Id') }}</th>
                                <th>{{ translate('Payment Status') }}</th>
                                <th>{{ translate('Patment Gateway Name') }}</th>
                                <th>{{ translate('Amount') }}</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse ($orders as $key => $order)    
                                @php 
                                if(@$order->payment_type == 'letspay'){
                                        $orderDate = DB::table('order_old_created')->where('id', $order->id)->first();
                                    if(!empty($orderDate)){
                                        $date =  $orderDate->created_at;
                                    }else{
                                        $date = null;
                                    }         
                                }else{
                                    $date = date('d-m-Y h:i A', @$order->date) ;
                                }

                                if(@$order->payment_type == "letzpay_payment"){
                                    $payment_method = ucfirst("letzpay");
                                }else{
                                    $payment_method = ucfirst(str_replace('_', ' ', @$order->payment_type));
                                }    
                                 $orderPrice = \App\OrderDetail::where('order_id', $order->id)->sum('price');  
                                @endphp                    
                                <tr>
                                    <td>{{ $key+1 }}</td>
                                    <td>{{ @$date }}</td>
                                    <td>{{ @$order->code }}</td>
                                    <td>{{ ucwords(@$order->payment_status) }}</td>
                                    <td>{{ @$payment_method }}</td>
                                    <td>{{ @$order->grand_total }}</td>
                                </tr>
                            @empty  
                                <tr>
                                    <td>
                                        No Records Found
                                    </td>
                                </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>

@endsection


@section('script')

<script type="text/javascript" src="https://cdn.jsdelivr.net/momentjs/latest/moment.min.js"></script>
<script type="text/javascript" src="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.min.js"></script>
<link rel="stylesheet" type="text/css" href="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.css" />
<script type="text/javascript">
    $(function() {
      $('input[name="daterange"]').daterangepicker({
          autoUpdateInput: false,
          maxDate: new Date(),
          locale: {
              cancelLabel: 'Clear'
          }
      });

      $('input[name="daterange"]').on('apply.daterangepicker', function(ev, picker) {
          $(this).val(picker.startDate.format('MM/DD/YYYY') + ' - ' + picker.endDate.format('MM/DD/YYYY'));
      });

      $('input[name="daterange"]').on('cancel.daterangepicker', function(ev, picker) {
          $(this).val('');
      });

    });
</script>
@endsection