@extends('layouts.app')
@section('title')
    {{ trans_choice('accounting::report.profit_and_loss', 1) }}
@endsection

@section('css')
    @include('accounting::report.partials.report_css')
@endsection

@section('content')

    @include('accounting::layouts.nav')
    <!-- Content Header (Page header) -->
    @component('accounting::components.section_header')
        @slot('title')
            {{ trans_choice('accounting::general.accounting', 1) }} {{ trans_choice('accounting::lang.report', 2) }}
        @endslot
        @slot('subtitle')
            {{ trans_choice('accounting::report.profit_and_loss', 1) }}
        @endslot
    @endcomponent

    <!-- Main content -->
    <section class="content no-print" id="vue-app">
        <div class="row">

            @component('accounting::components.box')
                @slot('header')
                    <div class="box-tools">
                        @component('accounting::components.download_action_button', [
                            'url' => 'report/accounting/profit_and_loss',
                            'filters' => 'start_date=' . $start_date . '&end_date=' . $end_date . '&location_id=' . $location_id,
                            ])
                        @endcomponent
                    </div>
                @endslot

                @slot('body')
                    <section class="content">
                        <div class="card">
                            <div class="card-header">
                                <h4 class="card-title">
                                    {{ trans_choice('accounting::report.profit_and_loss', 1) }}
                                    @if (!empty($start_date))
                                        {{ trans('accounting::lang.for_period') }}: <b>{{ $start_date }} {{ trans('accounting::lang.to') }}
                                            {{ $end_date }}</b>
                                    @endif
                                </h4>
                            </div>
                            <div class="card-body">
                                <form method="get" action="{{ Request::url() }}" class="___class_+?23___">
                                    <div class="row">
                                        <div class="col-md-3">
                                            <div class="form-group">
                                                <label class="control-label"
                                                    for="location_id">{{ trans_choice('accounting::lang.business_location', 1) }}</label>
                                                <select class="form-control" name="location_id" id="location_id" required>
                                                    <option value="" disabled selected>{{ trans_choice('accounting::lang.select', 1) }}</option>
                                                    @foreach ($business_locations as $key)
                                                        <option value="{{ $key->id }}" @if ($location_id == $key->id) selected @endif>
                                                            {{ $key->name }}</option>
                                                    @endforeach
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-md-3">
                                            <div class="form-group">
                                                <label class="control-label"
                                                    for="start_date">{{ trans_choice('accounting::lang.start_date', 1) }}</label>
                                                <input type="text" value="{{ $start_date }}"
                                                    class="form-control datepicker @error('start_date') is-invalid @enderror" name="start_date"
                                                    id="start_date" required>
                                            </div>
                                        </div>
                                        <div class="col-md-3">
                                            <div class="form-group">
                                                <label class="control-label"
                                                    for="end_date">{{ trans_choice('accounting::lang.end_date', 1) }}</label>
                                                <input type="text" value="{{ $end_date }}"
                                                    class="form-control datepicker @error('end_date') is-invalid @enderror" name="end_date"
                                                    id="end_date" required>
                                            </div>
                                        </div>
                                   
                                        <div class="col-md-2 float-right filter-btn-row mt-5">
                                            <br>
                                            <span class="input-group-btn">
                                                <button type="submit" class="btn bg-olive btn-flat">{{ trans_choice('accounting::lang.submit', 1) }}
                                                </button>
                                            </span>
                                            <span class="input-group-btn">
                                                <a href="{{ Request::url() }}"
                                                    class="btn btn-danger btn-flat pull-right">{{ trans_choice('accounting::lang.clear', 1) }}!</a>
                                            </span>
                                        </div>
                                    </div>
                                </form>
                            </div>
                            <!-- /.box-body -->

                        </div>
                        <!-- /.box -->
{{-- REPORT BODY (only when dates are set) --}}
   {{-- REPORT BODY (only when dates are set) --}}
@if (!empty($start_date) && !empty($end_date))
    @component('accounting::components.box')
        @slot('body')
            <div class="text-center mb-4">
                <h3>{{ trans_choice('accounting::report.profit_and_loss', 1) }}</h3>
                @if ($location_id && $income->first()->location_name ?? false)
                    <p>{{ trans_choice('accounting::lang.business_location', 1) }}:
                        <strong>{{ $income->first()->location_name }}</strong></p>
                @endif
                <p>
                    {{ trans_choice('accounting::lang.start_date', 1) }}: {{ readable_date($start_date) }}
                    &nbsp;&nbsp;{{ trans_choice('accounting::lang.end_date', 1) }}: {{ readable_date($end_date) }}
                </p>
            </div>

            {{-- 1. REVENUE --}}
            <div class="row mb-4">
                <div class="col-md-1 offset-md-2"></div>
                <div class="col-md-8 offset-md-2">
                    <h4 class="border-bottom pb-2"><strong>1. {{ __('Revenue') }}</strong></h4>
                    <table class="table table-bordered table-sm">
                        <thead class="thead-light">
                            <tr><th>Description</th><th class="text-right">Amount ({{ $currency_code }})</th></tr>
                        </thead>
                        <tbody>
                            @foreach ($income as $acc)
                                @php $bal = $acc->total_credit - $acc->total_debit; @endphp
                                <tr>
                                    <td>{{ $acc->name }}</td>
                                    <td class="text-right">{{ $fmt($bal) }}</td>
                                </tr>
                            @endforeach
                            <tr class="font-weight-bold bg-light">
                                <td>Total Revenue</td>
                                <td class="text-right">{{ $fmt($total_income) }}</td>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>

            {{-- 2. COGS --}}
            <div class="row mb-4">
                <div class="col-md-1 offset-md-2"></div>
                <div class="col-md-8 offset-md-2">
                    <h4 class="border-bottom pb-2"><strong>2. {{ __('Cost of Goods Sold (COGS)') }}</strong></h4>
                    <table class="table table-bordered table-sm">
                        <tbody>
                            <tr><td>Opening Inventory</td><td class="text-right">{{ $fmt($opening_stock) }}</td></tr>
                            <tr><td>Purchases</td><td class="text-right">{{ $fmt($purchases) }}</td></tr>
                            <tr><td>Closing Inventory</td><td class="text-right">{{ $fmt(-$closing_stock) }}</td></tr>
                            <tr class="font-weight-bold bg-light">
                                <td>Total COGS</td>
                                <td class="text-right">{{ $fmt($total_cogs) }}</td>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>

            {{-- Gross Profit --}}
            <div class="row mb-4">
                <div class="col-md-1 offset-md-2"></div>
                <div class="col-md-8 offset-md-2">
                    <table class="table table-bordered">
                        <tr class="bg-success  font-weight-bold">
                            <td>Gross Profit = Total Revenue – Total COGS</td>
                            <td class="text-right">{{ $fmt($gross_profit) }}</td>
                        </tr>
                    </table>
                </div>
            </div>

            {{-- 3. OPERATING EXPENSES --}}
            <div class="row mb-4">
                <div class="col-md-1 offset-md-2"></div>
                <div class="col-md-8 offset-md-2">
                    <h4 class="border-bottom pb-2"><strong>3. {{ __('Operating Expenses') }}</strong></h4>
                    <table class="table table-bordered table-sm">
                        <thead class="thead-light">
                            <tr><th>Description</th><th class="text-right">Amount ({{ $currency_code }})</th></tr>
                        </thead>
                        <tbody>
                            @foreach ($expense as $acc)
                                @php $bal = $acc->total_debit - $acc->total_credit; @endphp
                                <tr>
                                    <td>{{ $acc->name }}</td>
                                    <td class="text-right">{{ $fmt($bal) }}</td>
                                </tr>
                            @endforeach
                            <tr class="font-weight-bold bg-light">
                                <td>Total Operating Expenses</td>
                                <td class="text-right">{{ $fmt($total_expense) }}</td>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>

            {{-- Operating Profit --}}
            <div class="row mb-4">
                <div class="col-md-1 offset-md-2"></div>
                <div class="col-md-8 offset-md-2">
                    <table class="table table-bordered">
                        <tr class="bg-info text-white font-weight-bold">
                            <td>Operating Profit = Gross Profit – Total Operating Expenses</td>
                            <td class="text-right">{{ $fmt($operating_profit) }}</td>
                        </tr>
                    </table>
                </div>
            </div>

           

            {{-- 5. NET PROFIT (before tax) --}}
            <div class="row mb-4">
                <div class="col-md-1 offset-md-2"></div>
                <div class="col-md-8 offset-md-2">
                    <table class="table table-bordered">
                        <tr class="bg-primary text-white font-weight-bold">
                            <td>Net Profit </td>
                            <td class="text-right">{{ $fmt($net_profit) }}</td>
                        </tr>
                    </table>
                </div>
            </div>

           
        @endslot
    @endcomponent
@endif
                    </section>
                @endslot
            @endcomponent


        </div>
    </section>
@stop

@section('javascript')
    @include('accounting::report.partials.report_js')
@endsection