@extends('layouts.app')
@section('title', 'Ecommerce Products')
@section('custom-css')
    <style>
        .table > :not(caption) > * > * {
            padding: 4px 6px !important;
        }
    </style>
@endsection
@section('content')
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header bg-transparent border-bottom">
                    <h4 class="card-title mb-0">{{ __('pages.Profit & Loss Reports List') }}</h4>
                </div>
                <div class="card-body">
                    <div class="row justify-content-between mb-1">
                        <div class="col-lg-8">
                            <form class="row">
                                <div class="col-lg-4">
                                    <label for="">{{ __('pages.From Date') }}</label>
                                    <input type="date" @if(request('from_date')) value="{{ request('from_date') }}" @endif name="from_date" class="form-control">
                                </div>
                                <div class="col-lg-4">
                                    <label for="">{{ __('pages.To Date') }}</label>
                                    <input type="date" @if(request('to_date')) value="{{ request('to_date') }}" @endif name="to_date" class="form-control">
                                </div>
                                <div class="col-lg-4 mt-2">
                                    <button class="btn btn-success">{{ __('pages.Generate Report') }}</button>
                                </div>
                            </form>
                        </div>
                    </div>
                    <div class="row">
                        <div class="col-lg-4">
                            <div class="alert alert-primary p-2">
                                <h3>{{ __('pages.Total Sales') }}</h3>
                                {{setting('currency')}}{{ number_format($total_sale,2) }}
                            </div>
                        </div>
                        <div class="col-lg-4">
                            <div class="alert alert-success p-2">
                                <h3>{{ __('pages.Total Profit') }}</h3>
                                {{setting('currency')}}{{ number_format($profit ,2) }}
                            </div>
                        </div>
                        <div class="col-lg-4">
                            <div class="alert alert-warning p-2">
                                <h3>{{ __('pages.Total Loss') }}</h3>
                                {{setting('currency')}}{{ number_format($loss,2) }}
                            </div>
                        </div>

                    </div>
                    <div class="table-responsive">
                        <table class="table table-bordered">
                            <tr>
                                <th>#</th>
                                <th>{{ __('pages.Date') }}</th>
                                <th>{{ __('pages.Num Orders') }}</th>
                                <th>{{ __('pages.Num Items Sold') }}</th>
                                <th>{{ __('pages.Total Cost') }}</th>
                                <th>{{ __('pages.Total Sale') }}</th>
                                <th>{{ __('pages.Loss') }}</th>
                                <th>{{ __('pages.Profit') }}</th>
                            </tr>
                            @forelse($profitLoss as $pl)
                                <tr>
                                    <td>{{ $loop->iteration }}</td>
                                    <td>{{ date('F m, Y', strtotime($pl->order_date)) }}</td>
                                    <td>{{ $pl->num_orders }}</td>
                                    <td>{{ $pl->num_items_sold }}</td>
                                    <td>{{setting('currency')}}{{ number_format($pl->total_cost,2) }}</td>
                                    <td>{{setting('currency')}}{{ number_format($pl->total_sale,2) }}</td>
                                    <td>{{setting('currency')}}{{ number_format(($pl->total_sale <  $pl->total_sale ?  $pl->total_sale - $pl->total_cost : 0),2) }}</td>
                                    <td>{{setting('currency')}}{{ number_format(($pl->total_sale - $pl->total_cost),2) }}</td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="9">
                                        <h4 class="text-center my-5">{{ __('pages.No Data Avaiable') }}</h4>
                                    </td>
                                </tr>
                            @endforelse
                        </table>
                    </div>
                    <div class="pagination mt-2">
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection

@section('custom-js')
    <script>
        function changePagination(paginate) {
            var nurl = new URL('{{ route('ecommerce.report.profit_loss') }}');
            nurl.searchParams.set('paginate', paginate);
            location.href = nurl;
        }

        function searchKeyword(e) {
            e.preventDefault();
            let keyword = $('#search-keyword')
            var nurl = new URL('{{ route('ecommerce.report.profit_loss') }}');
            nurl.searchParams.set('keywords', keyword);
            location.href = nurl;
        }
    </script>
@endsection