@extends('layouts.app')

@section('content')
<link rel="stylesheet" type="text/css" href="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.css" />
@php
    $refund_request_addon = \App\Addon::where('unique_identifier', 'refund_request')->first();
@endphp
<!-- Basic Data Tables -->
<!--===================================================-->
<div class="panel">
    <div class="panel-heading bord-btm clearfix pad-all h-100">
        <h3 class="panel-title pull-left pad-no">Orders</h3> 
          <div class="pull-right clearfix">
            <form class="" id="sort_orders" action="" method="GET">
                               
                <div class="box-inline pad-rgt pull-left">
                    <div class="" style="min-width: 200px;">
                        <input type="text" class="form-control" id="search" name="search"@isset($sort_search) value="{{ $sort_search }}" @endisset placeholder="Type Order ID, Name, Email, Phone & hit enter">
                    </div>
                </div>
               
               
            </form>
        </div>  
    </div>

    <div class="panel-body">
        <table class="table table-striped res-table mar-no" cellspacing="0" width="100%">
            <thead>
                <tr>
                    <th>#</th>
                    <th>Order ID</th>
                    <th>Payment Method</th>
                    <th>Pay ID</th>
                   <!--  <th>{{translate('Order Code')}}</th> -->
                    <th># of Products</th>
                    <th>Customer</th>
                    <th>Amount</th>
                   <!--  <th>{{translate('Delivery Status')}}</th> -->
                    
                    <th>Payment Status</th>
                    <th>order Date</th>
                    @if (@$refund_request_addon != null && @$refund_request_addon->activated == 1)
                        <th>Refund</th>
                    @endif
                    @if(Auth::user()->id != "320")
                    <th width="10%">Options</th>
                    @endif
                </tr>
            </thead>
            <tbody>
                @foreach ($orders as $key => $order_id)
                    @php
                        $order = \App\Order::find($order_id->id);
                    @endphp
                    @if($order != null)
                        <tr>
                            <td>
                                  {{ (count($countorders)-$key) - ($orders->currentPage() - 1) * $orders->perPage() }}
                            </td>
                            <td>
                                {{ $order->code }} @if($order->viewed == 0) <span class="pull-right badge badge-info">{{ translate('New') }}</span> @endif
                            </td>
                              <td>
                                @if(@$order->payment_type == "letzpay_payment")
                                    {{ ucfirst("letzpay") }}
                                @else
                                     {{ ucfirst(str_replace('_', ' ', @$order->payment_type)) }}
                                @endif
                            </td>
                            <td>
                                @if(@$order->payment_type == "razorpay")                                  
                                    {{(!empty(json_decode(@$order->payment_details)->id)) ? json_decode(@$order->payment_details)->id : 'NA'}} 
                                @elseif(@$order->payment_type == "letzpay_payment")   
                                   {{(!empty(json_decode(@$order->payment_details)->TXN_ID)) ? json_decode(@$order->payment_details)->TXN_ID : 'NA'}}     
                                @else
                                    N/A
                                @endif
                            </td>
                           <!--  <td>
                                @if(@$order->payment_type == "razorpay")
                                    {{(!empty(json_decode($order->order_create)->id)) ? json_decode($order->order_create)->id : 'NA'}} 
                                @else
                                    {{translate('N/A')}}
                                @endif
                            </td> -->
                            <td>
                              
                                @php $sum = \App\OrderDetail::where('order_id', @$order_id->id)->sum('quantity'); @endphp
                                {{@$sum}}
                            </td>
                            <td>
                                @if ($order->user != null)
                                    {{ @$order->user->name }}
                                @else
                                    Guest ({{ @$order->guest_id }})
                                @endif
                            </td>
                            <td>
                              
                               {{ single_price(@$order->grand_total)}}
                            </td>
                          
                            <td>
                                <span class="badge badge--2 mr-4">
                                    @php $orderDetails = DB::table('order_details')->where('order_id', @$order->id)->first(); @endphp
                                    @if (@$orderDetails->payment_status == 'paid')
                                        <i class="bg-green"></i> Paid
                                    @elseif(@$orderDetails->payment_status == 'failed')
                                        <i class="bg-green"></i> Failed
                                    @else
                                        <i class="bg-red"></i> Unpaid
                                    @endif
                                </span>
                            </td>
                            <td>
                                @if($order->payment_type == 'letzpay')
                                @php $orderDate = DB::table('order_old_created')->where('id', $order->id)->first(); @endphp
                                    {{ @$orderDate->created_at }}
                                @else
                                    {{ date('d-m-Y h:i A', @$order->date) }}
                                @endif
                            </td>
                            @if (@$refund_request_addon != null && @$refund_request_addon->activated == 1)
                                <td>
                                    @if (count($order->refund_requests) > 0)
                                        {{ count($order->refund_requests) }} Refund
                                    @else
                                        No Refund
                                    @endif
                                </td>
                            @endif
                            @if(Auth::user()->id != "320")
                            <td>
                                <div class="btn-group dropdown">
                                    <button class="btn btn-primary dropdown-toggle dropdown-toggle-icon" data-toggle="dropdown" type="button">
                                        Actions <i class="dropdown-caret"></i>
                                    </button>
                                    <ul class="dropdown-menu dropdown-menu-right">
                                        <li><a href="{{ route('orders.show', encrypt($order->id)) }}">View</a></li>
                                    
                                        <li><a href="{{ route('seller.invoice.download', $order->id) }}">Generate Invoice</a></li> 

                                        @if(Auth::user()->user_type == 'admin') 
                                            @php 
                                                $orderReturn = \App\OrderDetail::where('order_id', $order->id)->where('delivery_status', 'return')->first();
                                            @endphp
                                            @if(!empty($orderReturn))
                                                <li><a href="{{ route('return.invoice', $order->id) }}">Generate Return Invoice</a></li>@endif
                                           <!--  <li><a onclick="confirm_modal('{{route('orders.destroy', $order->id)}}');">{{translate('Delete')}}</a></li>  -->
                                         @endif
                                    </ul>
                                </div>
                            </td>
                            @endif
                        </tr>
                    @endif
                @endforeach
            </tbody>
        </table>
        <div class="clearfix">
            <div class="pull-right">
                {{ $orders->appends(request()->input())->links() }}
            </div>
        </div>
    </div>
</div>
@endsection
@section('script')

<script type="text/javascript">
    function sort_orders(el){
        $('#sort_orders').submit();
    }
</script>
@endsection