@extends('layouts.app')
@section('title',  __('report.receipt_payment_summary'))

@section('content')

    <section class="content-header">
        <h1 class="tw-text-xl md:tw-text-3xl tw-font-bold tw-text-black">
            {{ __('report.receipt_payment_summary')}}
        </h1>
    </section>

    <section class="content no-print">
        <div class="row">
            <div class="col-md-12">
                @component('components.filters', ['title' => __('report.filters')])
                    {!! Form::open(['url' => '#','method' => 'get','id' => 'sell_payment_report_form']) !!}
                        <div class="col-md-4">
                            <div class="form-group">
                                {!! Form::label('location_id', __('purchase.business_location').':') !!}
                                <div class="input-group">
                                    <span class="input-group-addon">
                                        <i class="fa fa-map-marker"></i>
                                    </span>
                                    {!! Form::select('location_id',$business_locations,request()->location_id, ['class'=>'form-control select2','style'=>'width:100%','placeholder'=>__('messages.all')]) !!}

                                </div>
                            </div>
                        </div>
                        <div class="col-md-4">
                            <div class="form-group">
                                {!! Form::label('spr_date_filter', __('report.date_range') . ':') !!}
                                {!! Form::text('date_range',request()->date_range, ['placeholder'=>__('lang_v1.select_a_date_range'), 'class'=>'form-control', 'id'=>'sell_list_filter_date_range', 'readonly']) !!}

                            </div>
                        </div>
                        <div class="col-md-4">
                            <div class="form-group" style="margin-top:25px;">
                                <button type="submit" class="tw-dw-btn tw-dw-btn-primary tw-dw-btn-sm tw-text-white">
                                    <i class="fa fa-filter"></i> @lang('report.apply_filters')
                                </button>
                            </div>
                        </div>
                    {!! Form::close() !!}
                @endcomponent
            </div>
        </div>
        <div class="row">
            @php
                $totalsIncome = [];
                $totalsExpense = [];
                $grandTotalIncome = 0;
                $grandTotalExpense = 0;
                foreach($used_payment_types as $method_label){
                    $totalsIncome[$method_label] = 0;
                    $totalsExpense[$method_label] = 0;
                }
            @endphp

            <div class="col-md-6">
                @component('components.widget',['class'=>'box-primary'])
                    <h3>Income</h3>
                    <div class="table-responsive">
                        <table class="table table-bordered">
                            <thead>
                                <tr>
                                    <th>@lang('report.sl')</th>
                                    <th>Receipt Detail</th>
                                    @foreach($used_payment_types as $method_label)
                                        <th>{{ $payment_types[$method_label] ?? '' }}</th>
                                    @endforeach
                                </tr>
                            </thead>
                            <tbody>
                                {{-- Opening Balance --}}
                                <tr>
                                    <td>1</td>
                                    <td>Opening Balance</td>
                                    @foreach($used_payment_types as $method_label)
                                        @php
                                            $opening = openingBalance($business_id, $location_id, $method_label, $start_date, ['sell'])
                                                    - openingBalance($business_id, $location_id, $method_label, $start_date, ['expense','purchanse']);
                                            $totalsIncome[$method_label] += $opening;
                                            $grandTotalIncome += $opening;
                                        @endphp
                                        <td>{{ number_format($opening,2) }}</td>
                                    @endforeach
                                </tr>

                                {{-- Customer Receipts --}}
                                @php $sr = 1; @endphp
                                @foreach($customers as $customer)
                                    @php
                                        $row_total = 0;
                                        $amounts = [];
                                        foreach($used_payment_types as $method_label){
                                            $amount = getPaymentSum($business_id, $start_date, $end_date, $customer->id, '', $method_label, ['sell']) ?? 0;
                                            $amounts[$method_label] = $amount;
                                            $row_total += $amount;
                                        }
                                    @endphp
                                    @if($row_total > 0)
                                        <tr>
                                            <td>{{ ($sr++) + 1 }}</td>
                                            <td>{{ $customer->contact_type == 'business' ? $customer->supplier_business_name : $customer->name }}</td>
                                            @foreach($amounts as $method_label => $amount)
                                                @php
                                                    $totalsIncome[$method_label] += $amount;
                                                    $grandTotalIncome += $amount;
                                                @endphp
                                                <td>{{ number_format($amount,2) }}</td>
                                            @endforeach
                                        </tr>
                                    @endif
                                @endforeach
                            </tbody>
                            <tfoot>
                                <tr>
                                    <th colspan="2">Total</th>
                                    @foreach($used_payment_types as $method_label)
                                        <th>{{ number_format($totalsIncome[$method_label],2) }}</th>
                                    @endforeach
                                </tr>
                                <tr>
                                    <th colspan="2">Sub Total</th>
                                    <th colspan="{{ count($used_payment_types) }}">{{ number_format($grandTotalIncome,2) }}</th>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                @endcomponent
            </div>
            <div class="col-md-6">
                @component('components.widget',['class'=>'box-primary'])
                    <h3>Expense</h3>
                    <div class="table-responsive">
                        <table class="table table-bordered">
                            <thead>
                                <tr>
                                    <th>@lang('report.sl')</th>
                                    <th>@lang('report.particular')</th>
                                    @foreach($used_payment_types as $method_label)
                                        <th>{{ $payment_types[$method_label] ?? '' }}</th>
                                    @endforeach
                                </tr>
                            </thead>
                            <tbody>
                                @php 
                                    $sr2 = 1;
                                @endphp

                                {{-- Supplier Purchases --}}
                                @foreach($suppliers as $supplier)
                                    @php
                                        $row_total = 0;
                                        $amounts = [];
                                        foreach($used_payment_types as $method_label){
                                            $amount = getPaymentSum($business_id, $start_date, $end_date, $supplier->id, '', $method_label, ['purchase']) ?? 0;
                                            $amounts[$method_label] = $amount;
                                            $row_total += $amount;
                                        }
                                    @endphp
                                    @if($row_total > 0)
                                        <tr>
                                            <td>{{ $sr2++ }}</td>
                                            <td>{{ $supplier->contact_type == 'business' ? $supplier->supplier_business_name : $supplier->name }}</td>
                                            @foreach($amounts as $method_label => $amount)
                                                @php
                                                    $totalsExpense[$method_label] += $amount;
                                                    $grandTotalExpense += $amount;
                                                @endphp
                                                <td>{{ number_format($amount,2) }}</td>
                                            @endforeach
                                        </tr>
                                    @endif
                                @endforeach

                                {{-- Expenses by Category --}}
                                @foreach($categories as $cat)
                                    @php
                                        $row_total = 0;
                                        $amounts = [];
                                        foreach($used_payment_types as $method_label){
                                            $amount = getPaymentSum($business_id, $start_date, $end_date, '', '', $method_label, ['expense'], $cat->id) ?? 0;
                                            $amounts[$method_label] = $amount;
                                            $row_total += $amount;
                                        }
                                    @endphp
                                    @if($row_total > 0)
                                        <tr>
                                            <td>{{ $sr2++ }}</td>
                                            <td>{{ $cat->name }}</td>
                                            @foreach($amounts as $method_label => $amount)
                                                @php
                                                    $totalsExpense[$method_label] += $amount;
                                                    $grandTotalExpense += $amount;
                                                @endphp
                                                <td>{{ number_format($amount,2) }}</td>
                                            @endforeach
                                        </tr>
                                    @endif
                                @endforeach

                                {{-- Closing Balance (Display Only) --}}
                                {{-- Closing Balance --}}
                                <tr>
                                    <td>{{ $sr2++ }}</td>
                                    <td>Closing Balance</td>
                                    @foreach($used_payment_types as $method_label)
                                        @php
                                            $closing = closingBalance($business_id, $location_id, $method_label, $end_date, ['sell']) 
                                                    - closingBalance($business_id, $location_id, $method_label, $end_date, ['expense','purchanse']);

                                            // Add closing to totals
                                            $totalsExpense[$method_label] += $closing;
                                            $grandTotalExpense += $closing;
                                        @endphp
                                        <td>{{ number_format($closing,2) }}</td>
                                    @endforeach
                                </tr>

                            </tbody>
                            <tfoot>
                                <tr>
                                    <th colspan="2">Total</th>
                                    @foreach($used_payment_types as $method_label)
                                        <th>{{ number_format($totalsExpense[$method_label],2) }}</th>
                                    @endforeach
                                </tr>
                                <tr>
                                    <th colspan="2">Sub Total</th>
                                    <th colspan="{{ count($used_payment_types) }}">{{ number_format($grandTotalExpense,2) }}</th>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                @endcomponent
            </div>
        </div>
    </section>
@endsection
@section('javascript')
    <script>
        $(document).ready(function(){

            // Define default format (from UltimatePOS settings)
            var moment_date_format = 'MM/DD/YYYY'; // adjust if needed
            var separator = ' ~ '; // what daterangepicker uses

            // Get initial value from input
            var input = $('#sell_list_filter_date_range');
            var start = moment();
            var end = moment();

            if(input.val()){
                // Normalize separator in case URL uses '-'
                var range = input.val().replace(' - ', separator);
                var dates = range.split(separator);

                // Parse dates safely
                if(dates.length === 2){
                    start = moment(dates[0], moment_date_format);
                    end = moment(dates[1], moment_date_format);
                }
            }

            // Initialize daterangepicker
            input.daterangepicker({
                ...dateRangeSettings,
                startDate: start,
                endDate: end
            }, function(s,e){
                input.val(s.format(moment_date_format) + separator + e.format(moment_date_format));
            });

            // If input is empty, set today as default
            if(!input.val()){
                input.val(moment().format(moment_date_format) + separator + moment().format(moment_date_format));
            }
        });

    </script>
@endsection