@extends('app.master')
@section('title',$title)
@section('breadcrumb')       
    @include('app.layouts.rent.breadcrumb',[
        'pageTitle' => $title,
        'lists' => [
            [
                'link'  => '#',
                'name'  => 'Accounting Reports',
            ],
            [
                'link'  => 'accounting.reports.trialbalance',
                'name'  => 'Profile & Loss',
            ]
        ]
    ])
@endsection
@php
    $unique = uniqid();
    /**
     * EXPECTED BEHAVIOR
     * Income (CR)
     * Expense (DR)
     * EXEPTIONS WILL BE SHOWN IN BRACKETS
     */
@endphp
@section('content')

<div class="col-md-12">
    <div class="card">
        <div class="card-header tx-medium bd-0 tx-white bg-indigo">@yield('title')</div>

        <div class="card-body">
            <form action="{{ route('accounting.reports.profitloss') }}" method="GET" style="
                border-bottom: 1px solid #D8E0E9;
                padding: 12px;
            ">
                <div class="row">
                    <div class="col-lg-4">
                        <div class="input-group mb-3">
                            <div class="input-group-prepend">
                                <span class="input-group-text" id="basic-addon1">From</span>
                              </div>
                            <div class="input-group-prepend">
                                <select class="form-control select2" name="month_from">
                                    @foreach($months as $key => $value)
                                    <option value="{{ $key }}" {{ $key == 0 ? 'disabled selected' : '' }} {{ $key == (request()->month_from ?? 0) ? 'selected' : '' }}>{{ $value }}</option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="input-group-prepend">
                                <input type="number" min="0" name="year_from" class="form-control" value="{{ request()->year_from ?? date('Y') }}" placeholder="From Year" aria-label="From Year">
                            </div>
                        </div><!-- input-group -->
                    </div>
                    
                    <div class="col-lg-4">
                        <div class="input-group mb-3">
                            <div class="input-group-prepend">
                                <span class="input-group-text" id="basic-addon1">To</span>
                              </div>
                            <div class="input-group-prepend">
                                <select class="form-control select2" name="month_to">
                                    @foreach($months as $key => $value)
                                    <option value="{{ $key }}" {{ $key == 0 ? 'disabled selected' : '' }} {{ $key == (request()->month_to ?? 0) ? 'selected' : '' }}>{{ $value }}</option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="input-group-prepend">
                                <input type="number" min="0" name="year_to" value="{{ request()->year_from ?? date('Y') }}" class="form-control" placeholder="To Year" aria-label="To Year">
                            </div>
                        </div><!-- input-group -->
                    </div>
                    <div class="col-lg-4">
                        <div class="input-group mb-3">
                            <div class="input-group-prepend">
                                <span class="input-group-text" id="basic-addon1">Interval</span>
                              </div>
                            <div class="input-group-prepend">
                                <select class="form-control select2" name="interval">
                                    @foreach([1=>'1 Month',3=>'3 Months', 6=>'6 Months', 12=>'12 Months'] as $key => $value)
                                    <option value="{{ $key }}" {{ $key == 0 ? 'disabled selected' : '' }} {{ $key == (request()->interval ?? 1) ? 'selected' : '' }}>{{ $value }}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div><!-- input-group -->
                    </div>
                    <div class="col-md-12">
                        <button type="submit" class="btn btn-primary">
                            {{ __('Search') }}
                        </button>
                    </div>
                </div>
            </form>
            <div class="invoice-container">
                <div class="row">
                    <div class="col-md-12">
                        <h3 class="text-center mt-5">Statement of Profit or Loss and Other Comprehensive Income</h3>
                        <h5 class="text-center mb-5">{{ $company['company.name'] }}</h5>
                        @php
                            # Initialize
                            foreach($dates as $date){
                                $totalSales[$date] = $totalPurchase[$date] = $totalExpense[$date] = $totalOverhead[$date] = 0;
                            }
                            $tab = '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
                            $colspan = count($dates)+1;
                        @endphp
                        <table class="table table-stripped table-bordered">
                            <thead>
                                <tr>
                                    <th><b>