@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
     */
    $period = date('F, Y',strtotime($yearFrom.'-'.$monthFrom.'-01')).' To '.date('F, Y',strtotime($yearTo.'-'.$monthTo.'-01'));
    $fileName = str_replace('&','_',$title).'_'.str_replace(' ','_',$period);
    $companyLogo = getBase64($company['company.logo']);
    $companyFooterLogo = getBase64($company['company.footerLogo']);
@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 == ($monthFrom ?? 0) ? 'selected' : '' }}>{{ $value }}</option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="input-group-prepend">
                                <input type="number" min="0" name="year_from" class="form-control" value="{{ $yearFrom ?? 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 == ($monthTo ?? 0) ? 'selected' : '' }}>{{ $value }}</option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="input-group-prepend">
                                <input type="number" min="0" name="year_to" value="{{ $yearFrom ?? 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 == ($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">
                        <div class="invoice-logo">
                        @if(!in_array($company['company.logo'],['','undefined']))
                            <img class="text-center img img-responsive" src="" >
                        @endif
                        </div>
                        <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" id="profitloss{{ $unique }}" data-cols-width="40 @foreach($dates as $date) {!! ',20' !!}@endforeach">
                            <thead>
                                @if(!in_array($company['company.logo'],['','undefined']))
                                <tr style="display:none;">
                                    <th class="text-center mt-5" colspan="{{ count($dates) + 1 }}">
                                        <img width="180px" class="img img-responsive" src="" >
                                    </th>
                                </tr>
                                @endif
                                <tr style="display:none;">
                                    <th data-f-bold="true" class="text-left mt-5" colspan="{{ count($dates) + 1 }}" 
                                    data-a-h="left"
                                    ><b>Company: {{ $company['company.name'] }}</b></th>
                                </tr>
                                <tr style="display:none;">
                                    <th data-f-bold="true" class="text-left mt-5" colspan="{{ count($dates) + 1 }}"
                                    data-a-h="left"
                                    ><b>Report: Statement of Profit or Loss and Other Comprehensive Income</b></th>
                                </tr>
                                <tr style="display:none;">
                                    <th data-f-bold="true" class="text-left mt-5" data-a-h="left"
                                    colspan="{{ count($dates) + 1 }}"><b>Period: {{ $period }} </b></th>
                                </tr>
                                <tr>
                                    <th data-f-bold="true"><b>