@extends('layouts.app')

@section('title', 'Location-wise Profit & Loss')

@section('content')

<!-- Content Header (Page header) -->
<section class="content-header">
    <h1>Location-wise Profit & Loss
        <small class="text-muted">Compare Performance Across Locations</small>
    </h1>
</section>

<!-- Main content -->
<section class="content">
    @component('components.widget', ['class' => 'box-primary'])
        <div class="row">
            <div class="col-md-4 col-xs-12">
                <div class="form-group">
                    {!! Form::label('start_date', __('accounting-reports::lang.start_date') . ':') !!}
                    {!! Form::text('start_date', @format_date($startDate ?? now()->startOfMonth()), ['class' => 'form-control date-picker', 'readonly', 'id' => 'start_date']) !!}
                </div>
            </div>
            <div class="col-md-4 col-xs-12">
                <div class="form-group">
                    {!! Form::label('end_date', __('accounting-reports::lang.end_date') . ':') !!}
                    {!! Form::text('end_date', @format_date($endDate ?? now()->endOfMonth()), ['class' => 'form-control date-picker', 'readonly', 'id' => 'end_date']) !!}
                </div>
            </div>
            <div class="col-md-4 col-xs-12">
                <div class="form-group">
                    <label>&nbsp;</label><br>
                    <button type="button" class="btn btn-primary" id="filter_btn">
                        <i class="fa fa-filter"></i> @lang('messages.filter')
                    </button>
                </div>
            </div>
        </div>
    @endcomponent

    <!-- Location Comparison Table -->
    <div class="row">
        <div class="col-md-12">
            <div class="box box-solid">
                <div class="box-header with-border">
                    <h3 class="box-title">Location Performance Comparison</h3>
                </div>
                <div class="box-body">
                    <div class="table-responsive">
                        <table class="table table-bordered table-striped table-hover">
                            <thead>
                                <tr>
                                    <th>Location</th>
                                    <th class="text-right">Revenue</th>
                                    <th class="text-right">COGS</th>
                                    <th class="text-right">Gross Profit</th>
                                    <th class="text-right">Gross Margin %</th>
                                    <th class="text-right">Expenses</th>
                                    <th class="text-right">Net Profit</th>
                                    <th class="text-right">Net Margin %</th>
                                    <th>Action</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($locationPL ?? [] as $item)
                                @php
                                    $pl = $item['pl_data']['summary'] ?? [];
                                    $revenue = $pl['total_revenue'] ?? 0;
                                    $cogs = $pl['total_cogs'] ?? 0;
                                    $grossProfit = $pl['gross_profit'] ?? 0;
                                    $expenses = $pl['total_indirect_expenses'] ?? 0;
                                    $netProfit = $pl['net_profit'] ?? 0;
                                    $grossMargin = $revenue > 0 ? ($grossProfit / $revenue * 100) : 0;
                                    $netMargin = $revenue > 0 ? ($netProfit / $revenue * 100) : 0;
                                @endphp
                                <tr>
                                    <td>
                                        <strong>{{ $item['location']->name ?? 'N/A' }}</strong>
                                    </td>
                                    <td class="text-right">@format_currency($revenue)</td>
                                    <td class="text-right">@format_currency($cogs)</td>
                                    <td class="text-right">
                                        <span class="label label-{{ $grossProfit >= 0 ? 'success' : 'danger' }}">
                                            @format_currency($grossProfit)
                                        </span>
                                    </td>
                                    <td class="text-right">
                                        <span class="label label-{{ $grossMargin >= 20 ? 'success' : ($grossMargin >= 10 ? 'warning' : 'danger') }}">
                                            {{ number_format($grossMargin, 2) }}%
                                        </span>
                                    </td>
                                    <td class="text-right">@format_currency($expenses)</td>
                                    <td class="text-right">
                                        <span class="label label-{{ $netProfit >= 0 ? 'success' : 'danger' }}">
                                            @format_currency($netProfit)
                                        </span>
                                    </td>
                                    <td class="text-right">
                                        <span class="label label-{{ $netMargin >= 10 ? 'success' : ($netMargin >= 0 ? 'warning' : 'danger') }}">
                                            {{ number_format($netMargin, 2) }}%
                                        </span>
                                    </td>
                                    <td>
                                        <a href="{{ route('accounting-reports.location-pl.show', $item['location']->id) }}?start_date={{ $startDate }}&end_date={{ $endDate }}" 
                                           class="btn btn-xs btn-info">
                                            <i class="fa fa-eye"></i> View Details
                                        </a>
                                    </td>
                                </tr>
                                @empty
                                <tr>
                                    <td colspan="9" class="text-center">No location data available for the selected period.</td>
                                </tr>
                                @endforelse
                            </tbody>
                            @if(isset($locationPL) && count($locationPL) > 0)
                            <tfoot>
                                @php
                                    $totalRevenue = array_sum(array_column(array_column($locationPL, 'pl_data'), 'summary'));
                                    $totalRevenue = collect($locationPL)->sum(function($item) {
                                        return $item['pl_data']['summary']['total_revenue'] ?? 0;
                                    });
                                    $totalCOGS = collect($locationPL)->sum(function($item) {
                                        return $item['pl_data']['summary']['total_cogs'] ?? 0;
                                    });
                                    $totalGrossProfit = collect($locationPL)->sum(function($item) {
                                        return $item['pl_data']['summary']['gross_profit'] ?? 0;
                                    });
                                    $totalExpenses = collect($locationPL)->sum(function($item) {
                                        return $item['pl_data']['summary']['total_indirect_expenses'] ?? 0;
                                    });
                                    $totalNetProfit = collect($locationPL)->sum(function($item) {
                                        return $item['pl_data']['summary']['net_profit'] ?? 0;
                                    });
                                    $totalGrossMargin = $totalRevenue > 0 ? ($totalGrossProfit / $totalRevenue * 100) : 0;
                                    $totalNetMargin = $totalRevenue > 0 ? ($totalNetProfit / $totalRevenue * 100) : 0;
                                @endphp
                                <tr class="bg-gray">
                                    <td><strong>Total</strong></td>
                                    <td class="text-right"><strong>@format_currency($totalRevenue)</strong></td>
                                    <td class="text-right"><strong>@format_currency($totalCOGS)</strong></td>
                                    <td class="text-right">
                                        <strong class="label label-{{ $totalGrossProfit >= 0 ? 'success' : 'danger' }}">
                                            @format_currency($totalGrossProfit)
                                        </strong>
                                    </td>
                                    <td class="text-right">
                                        <strong class="label label-{{ $totalGrossMargin >= 20 ? 'success' : ($totalGrossMargin >= 10 ? 'warning' : 'danger') }}">
                                            {{ number_format($totalGrossMargin, 2) }}%
                                        </strong>
                                    </td>
                                    <td class="text-right"><strong>@format_currency($totalExpenses)</strong></td>
                                    <td class="text-right">
                                        <strong class="label label-{{ $totalNetProfit >= 0 ? 'success' : 'danger' }}">
                                            @format_currency($totalNetProfit)
                                        </strong>
                                    </td>
                                    <td class="text-right">
                                        <strong class="label label-{{ $totalNetMargin >= 10 ? 'success' : ($totalNetMargin >= 0 ? 'warning' : 'danger') }}">
                                            {{ number_format($totalNetMargin, 2) }}%
                                        </strong>
                                    </td>
                                    <td></td>
                                </tr>
                            @endif
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>

</section>

@endsection

@section('javascript')
<script type="text/javascript">
    $(document).ready(function() {
        // Date picker
        $('.date-picker').datepicker({
            autoclose: true,
            format: datepicker_date_format
        });

        // Filter button
        $('#filter_btn').on('click', function() {
            var startDate = $('#start_date').val();
            var endDate = $('#end_date').val();
            
            var url = '{{ route("accounting-reports.location-pl.index") }}';
            url += '?start_date=' + startDate + '&end_date=' + endDate;
            
            window.location.href = url;
        });
    });
</script>
@endsection