@extends('layouts.app')

@section('title')
    {{ trans_choice('accounting::general.balance_sheet', 1) }}
@endsection

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

@section('content')
@include('accounting::layouts.nav')

<!-- Content 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::general.balance_sheet', 1) }}
    @endslot
@endcomponent

<!-- Main content -->
<section class="content no-print" id="vue-app">
    @can('product.view')
        <div class="row">
            @component('accounting::components.box')
                @slot('header')
                    <div class="box-tools">
                        @component('accounting::components.download_action_button', [
                            'url' => Request::url(),
                            'filters' => http_build_query($_GET),
                        ])
                        @endcomponent
                    </div>
                @endslot
                @slot('body')
                    <section class="content">
                        <div class="card">
                            <div class="card-header with-border">
                                <h4 class="card-title">
                                    {{ trans_choice('accounting::general.balance_sheet', 1) }}
                                    @if (!empty($end_date))
                                        {{ trans('accounting::general.as_on') }}:
                                        {{ readable_date($end_date) }}
                                    @endif
                                </h4>
                            </div>
                            <div class="card-body">
                                <form method="get" action="{{ Request::url() }}">
                                    <div class="row">
                                        <div class="col-md-4">
                                            <div class="form-group">
                                                <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-4">
                                            <div class="form-group">
                                                <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>

                                    <div class="row">
                                        <div class="col-md-2 float-right filter-btn-row">
                                            <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>
                        </div>
                    </section>
                @endslot
            @endcomponent

            @if (!empty($end_date))
                @component('accounting::components.box')
                    @slot('body')

                        @php
                            $assets = $data->where('account_type', 'asset');
                            $liabilities = $data->where('account_type', 'liability');
                            $equity = $data->where('account_type', 'equity');

                            $total_assets = $assets->sum('debit') - $assets->sum('credit');
                            $total_liabilities = $liabilities->sum('credit') - $liabilities->sum('debit');
                            $total_equity = $equity->sum('credit') - $equity->sum('debit');
                            $total_liab_equity = $total_liabilities + $total_equity;

                            // Helper for formatting negatives
                            function fmt($amount) {
                                return $amount < 0
                                    ? '(' . number_format(abs($amount), 2) . ')'
                                    : number_format($amount, 2);
                            }
                        @endphp

                        <div class="row text-center mb-4">
                            <div class="col-md-12">
                                <h3>{{ trans_choice('accounting::general.balance_sheet', 1) }}</h3>
                                @if (!empty($location_id) && !empty($data->first()->business_location))
                                    <p>
                                        {{ trans_choice('accounting::lang.business_location', 1) }}:
                                        <strong>{{ $data->first()->business_location }}</strong>
                                    </p>
                                @endif
                                <p>{{ trans_choice('accounting::general.as_on', 1) }}:
                                    <strong>{{ readable_date($end_date) }}</strong>
                                </p>
                            </div>
                        </div>

                        <div class="row">
                            <!-- Left Column: Assets -->
                            <div class="col-md-6">
                                <h4><strong>{{ __('Assets') }}</strong></h4>
                                <table class="table table-bordered table-striped">
                                    <thead>
                                        <tr>
                                            <th>{{ trans_choice('accounting::lang.account', 1) }}</th>
                                            <th class="text-right">{{ trans_choice('accounting::general.balance', 1) }}</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @foreach ($assets as $acc)
                                            @php
                                                $balance = $acc->debit - $acc->credit;
                                            @endphp
                                            <tr>
                                                <td>{{ $acc->name }}</td>
                                                <td class="text-right">{{ fmt($balance) }}</td>
                                            </tr>
                                        @endforeach
                                        <tr class="font-weight-bold bg-subtotal">
                                            <td>{{ __('Total Assets') }}</td>
                                            <td class="text-right">{{ fmt($total_assets) }}</td>
                                        </tr>
                                    </tbody>
                                </table>
                            </div>

                            <!-- Right Column: Liabilities and Equity -->
                            <div class="col-md-6">
                                <h4><strong>{{ __('Liabilities and Equity') }}</strong></h4>
                                <table class="table table-bordered table-striped">
                                    <thead>
                                        <tr>
                                            <th>{{ trans_choice('accounting::lang.account', 1) }}</th>
                                            <th class="text-right">{{ trans_choice('accounting::general.balance', 1) }}</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <tr class="bg-light">
                                            <td colspan="2"><strong>{{ __('Liabilities') }}</strong></td>
                                        </tr>
                                        @foreach ($liabilities as $acc)
                                            @php
                                                $balance = $acc->credit - $acc->debit;
                                            @endphp
                                            <tr>
                                                <td>{{ $acc->name }}</td>
                                                <td class="text-right">{{ fmt($balance) }}</td>
                                            </tr>
                                        @endforeach
                                        <tr class="font-weight-bold bg-subtotal">
                                            <td>{{ __('Total Liabilities') }}</td>
                                            <td class="text-right">{{ fmt($total_liabilities) }}</td>
                                        </tr>

                                        <tr class="bg-light">
                                            <td colspan="2"><strong>{{ __('Equity') }}</strong></td>
                                        </tr>
                                        @foreach ($equity as $acc)
                                            @php
                                                $balance = $acc->credit - $acc->debit;
                                            @endphp
                                            <tr>
                                                <td>{{ $acc->name }}</td>
                                                <td class="text-right">{{ fmt($balance) }}</td>
                                            </tr>
                                        @endforeach
                                        <tr class="font-weight-bold bg-subtotal">
                                            <td>{{ __('Total Equity') }}</td>
                                            <td class="text-right">{{ fmt($total_equity) }}</td>
                                        </tr>

                                        <tr class="font-weight-bold bg-grand-total">
                                            <td>{{ __('Total Liabilities and Equity') }}</td>
                                            <td class="text-right">{{ fmt($total_liab_equity) }}</td>
                                        </tr>
                                    </tbody>
                                </table>
                            </div>
                        </div>

                        <!-- Totals shown side by side -->
                        <div class="row mt-4 font-weight-bold">
                            <div class="col-md-6">
                                {{ __('Total Assets:') }}
                                <span style="float:right;">{{ fmt($total_assets) }}</span>
                            </div>
                            <div class="col-md-6">
                                {{ __('Total Liabilities & Equity:') }}
                                <span style="float:right;">{{ fmt($total_liab_equity) }}</span>
                            </div>
                        </div>

                    @endslot
                @endcomponent
            @endif
        </div>
    @endcan
</section>
@stop

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