@extends('admin.layout')
@section('content')

    <!-- begin::main content -->
    <main class="main-content">
        <div class="container">
            <!-- begin::page header -->
            <div class="page-header">
                <h3>Sales Dashboard</h3>
                <nav aria-label="breadcrumb">
                    <ol class="breadcrumb">
                        <li class="breadcrumb-item"><a href="#">Dashboard</a></li>
                        <li class="breadcrumb-item active" aria-current="page">Sales</li>
                    </ol>
                </nav>
            </div>
            <!-- end::page header -->

            <div class="page-header">
                <div class="row row-sm">
                    <div class="col-xl-3 col-lg-6 col-lg-6 col-sm-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-center">
                                    <div>
                                        <h6 class="text-uppercase font-size-11 m-b-15">Invoices</h6>
                                        <h4 class="m-b-0">{{ $total_billing }}</h4>
                                    </div>
                                    <div>
                                        <div class="sparkline-demo1"></div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-xl-3 col-lg-6 col-lg-6 col-sm-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-center">
                                    <div>
                                        <h6 class="text-uppercase font-size-11 m-b-15">EARNINGS</h6>
                                        <h4 class="m-b-0"><i class="fa fa-inr"></i>&nbsp;{{ $totalAmount }}
                                        </h4>
                                    </div>
                                    <div>
                                        <div class="sparkline-demo2"></div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-xl-3 col-lg-6 col-lg-6 col-sm-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-center">
                                    <div>
                                        <h6 class="text-uppercase font-size-11 m-b-15">Quantity</h6>
                                        <h4 class="m-b-0">{{ $totalQty }} </h4>
                                    </div>
                                    <div>
                                        <div class="sparkline-demo3"></div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-xl-3 col-lg-6 col-lg-6 col-sm-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-center">
                                    <div>
                                        <h6 class="text-uppercase font-size-11 m-b-15">Enrolled Students</h6>
                                        <h4 class="m-b-0">{{ $totalUser }}</h4>
                                    </div>
                                    <div>
                                        <div class="sparkline-demo4"></div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <div class="card">
                <div class="card-body">
                    <form action="" method="GET">
                        <div class="row">

                            <div class="col-md-3">
                                <div class="form-group">
                                    <label for="daterange">From</label>
                                    <input type="text" value="{{ Request::get('from_date') }}" name="from_date"
                                        class="form-control">
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="form-group">
                                    <label for="daterange">To</label>
                                    <input type="text" value="{{ Request::get('to_date') }}" name="to_date"
                                        class="form-control">
                                </div>
                            </div>


                            <div class="col-md-2">
                                <div class="form-group">
                                    <label for="search_fields">Search Fields</label>
                                    <div class="form-group">
                                        <select class="form-control" name="search_fields" id="search_fields">
                                            <option selected value="">-select-field-</option>
                                            <option {{ Request::get('search_fields') == 'users_name' ? 'selected' : '' }}
                                                value="users_name">Name</option>
                                            <option {{ Request::get('search_fields') == 'users_phone' ? 'selected' : '' }}
                                                value="users_phone">Phone</option>
                                            <option {{ Request::get('search_fields') == 'users_email' ? 'selected' : '' }}
                                                value="users_email">Email</option>
                                        </select>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-4">
                                <div class="form-group">
                                    <label for="query">Search Value</label>
                                    <input type="text" class="form-control" name="query" id="query"
                                        placeholder="Search here....." value="{{ Request::get('query') }}">
                                </div>
                            </div>

                            <div class="col-md-3">
                                <div class="form-group">
                                    <label for="category">Select Category</label>
                                    <select class="form-control" name="category" id="category">
                                        <option selected value="">-select-category-</option>
                                        @if (!empty($main_categories))
                                            @foreach ($main_categories as $main_categ)
                                                <option
                                                    {{ Request::get('category') == $main_categ->id ? 'selected' : '' }}
                                                    value="{{ $main_categ->id }}">{{ $main_categ->name }}</option>
                                            @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div>

                            <div class="col-md-3">
                                <div class="form-group">
                                    <label for="course">Select Product</label>
                                    <select class="form-control" name="course" id="course">
                                        <option selected value="">-select-product-</option>
                                        @if (!empty($products))
                                            @foreach ($products as $product)
                                                <option {{ Request::get('course') == $product->id ? 'selected' : '' }}
                                                    value="{{ $product->id }}">{{ $product->name }}</option>
                                            @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div>

                            <div class="col-md-3">
                                <div class="form-group">
                                    <label for="status">Payment Status</label>
                                    <div class="form-group">
                                        <select class="form-control" name="payment_status" id="payment_status">
                                            <option selected value="">-select-payment-status-</option>
                                            <option class="text-success"
                                                {{ Request::get('payment_status') == 'Credit' ? 'selected' : '' }}
                                                value="Credit">Credit</option>
                                            <option class="text-danger"
                                                {{ Request::get('payment_status') == 'Pending' ? 'selected' : '' }}
                                                value="Pending">Pending</option>
                                            <option class="text-warning"
                                                {{ Request::get('payment_status') == 'Refund' ? 'selected' : '' }}
                                                value="Refund">Refunds</option>
                                        </select>
                                    </div>
                                </div>
                            </div>

                            <div class="col-md-3">
                                <div class="form-group">
                                    <label for="status">Status</label>
                                    <div class="form-group">
                                        <select class="form-control" name="expired" id="expired">
                                            <option selected value="">--select--status--</option>
                                            <option class="text-success"
                                                {{ Request::get('expired') == '0' ? 'selected' : '' }} value="0">
                                                Active</option>
                                            <option class="text-danger"
                                                {{ Request::get('expired') == '1' ? 'selected' : '' }} value="1">
                                                Expired</option>
                                        </select>
                                    </div>
                                </div>
                            </div>

                            <div class="col-md-3">
                                <div class="form-group">
                                    <button type="submit" class="btn btn-primary"><i class="fa fa-search"></i>&nbsp;
                                        Search</button>
                                    <a href="{{ asset('admin/order-list') }}" class="btn btn-primary text-white"><i
                                            class="fa fa-refresh"></i>&nbsp; Reset</a>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
            </div>

            {{-- <div class="card">
                <div class="card-body">
                    <form method="post" action="{{ asset('admin/import-tracking-order') }}"
                        enctype="multipart/form-data">
                        @csrf
                        <input type="file" name="file">
                        <button class="btn btn-primary">Upload CSV</button>
                    </form>
                </div>
            </div> --}}

            
            <div class="card">
                <div class="card-body">

                

                    <a href="{{ asset('admin/create-order') }}" class="form-group btn btn-primary text-white pull-right">
                        <i class="fa fa-plus"></i>&nbsp;Create Order</a>

                    <div class="table-responsive">
                        @if (isset($billings))
                            <table class="table table-striped table-bordered">
                                <thead>
                                    <tr>
                                        <th>ID</th>
                                        <th>Date</th>
                                        <th>Amount</th>
                                        <th>Payment Details</th>
                                        <th>Payment Status</th>
                                        <th>Product/Mode</th>
                                        <th>Student</th>
                                        <th>Status</th>
                                        <th>Instrument</th>
                                        <th>Action</th>
                                    </tr>
                                </thead>
                                <tbody>

                                    @if (!empty($billings))
                                        @foreach ($billings as $billing)
                                            <tr>
                                                <td>{{ $billing->id }}</td>
                                                <td>{{ date('Y/m/d h:i A', strtotime($billing->created_at)) }}</td>
                                                <td>
                                                    @if ($billing->total_amount > 0)
                                                        <span class="text-right h6">
                                                            <i class="fa fa-rupee"></i>{{ $billing->total_amount }}
                                                        </span>
                                                    @else
                                                        <span class="text-right h6">Free</span>
                                                    @endif
                                                </td>
                                                <td>
                                                    @if (!empty($billing->payment_request_id))
                                                        <span class="font-weight-bold">PayID:</span>
                                                        {{ $billing->payment_request_id }}
                                                    @endif

                                                    @if (!empty($billing->transaction_id))
                                                        <span class="font-weight-bold">TransID:</span>
                                                        {{ $billing->transaction_id }}
                                                    @endif

                                                    @if (!empty($billing->tax_invoice_no))
                                                        <u><a target="_blank" href="{{asset('admin/view-invoice/'.$billing->id)}}"><span
                                                                    class="font-weight-bold text-facebook">#{{ $billing->tax_invoice_no }}</span></a></u>
                                                    @endif
                                                </td>
                                                <td>
                                                    @if ($billing->payment_status == 'Credit')
                                                        <label for="" class="text-success">Credit</label>
                                                    @endif
                                                    @if ($billing->payment_status == 'Pending')
                                                        <label for="" class="text-danger">Pending</label>
                                                    @endif
                                                    @if ($billing->payment_status == 'Refund')
                                                        <label for="" class="text-warning">Refund</label>
                                                    @endif
                                                </td>
                                                <td>
                                                    {{ $billing->product_name }}<br>
                                                    <b>Mode:</b>
                                                    {{ ucfirst(str_replace('_', '', $billing->product_mode)) }}
                                                </td>
                                                <td>
                                                    {{ $billing->name }}<br>
                                                    <u><a class="text-facebook"
                                                            href="{{ asset('admin/user-list?query=' . $billing->email) }}">
                                                            {{ $billing->email }}</a></u><br>
                                                    {{ $billing->phone }}
                                                </td>



                                                <td>
                                                    @if ($billing->expired == 1)
                                                        <label for="" class="text-danger">Expired</label>
                                                    @endif
                                                    @if ($billing->expired == 0)
                                                        <label for="" class="text-success">Active</label>
                                                    @endif
                                                </td>

                                                <td>{{ $billing->instrument_type }}</td>


                                                {{-- <td>
                                                    {{ $billing->tracking_status }}<br>
                                                    {{ $billing->tracking_no }}
                                                </td> --}}


                                                <td>