@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">
            <div class="col-md-12">
                @component('components.widget',['class'=>'box-primary'])
                    @php
                        $totalsIncome       = [];
                        $totalsExpense      = [];
                        $grandTotalIncome   = 0;
                        $grandTotalExpense  = 0;

                        foreach($used_payment_types as $method_label){
                            $totalsIncome[$method_label]=0;
                            $totalsExpense[$method_label]=0;
                        }
                        $incomeRows=[];
                        $openingRow=['Opening Balance'];

                        foreach($used_payment_types as $method_label){
                            $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;
                            $openingRow[]=$opening;
                        }
                        $incomeRows[]=$openingRow;

                        foreach($customers as $customer){
                            $row_total=0;
                            $row=[];

                            foreach($used_payment_types as $method_label){
                                $amount=getPaymentSum($business_id, $start_date, $end_date, $customer->id, $location_id, $method_label, ['sell'] ) ?? 0;
                                $row[]=$amount;
                                $row_total+=$amount;
                            }
                            if($row_total>0){
                                foreach($row as $k=>$val){
                                    $totalsIncome[$used_payment_types[$k]] += $val;
                                    $grandTotalIncome += $val;
                                }
                                $incomeRows[]=[ $customer->contact_type=='business' ? $customer->supplier_business_name : $customer->name, ...$row];
                            }
                        }
                        $expenseRows=[];
                        foreach($suppliers as $supplier){
                            $row_total=0;
                            $row=[];

                            foreach($used_payment_types as $method_label){

                                $amount =   getPaymentSum( $business_id, $start_date, $end_date, $supplier->id, $location_id, $method_label, ['purchase']) ?? 0;
                                $row[]  =   $amount;
                                $row_total  += $amount;
                            }
                            if($row_total>0){
                                foreach($row as $k=>$val){
                                    $totalsExpense[$used_payment_types[$k]] += $val;
                                    $grandTotalExpense += $val;
                                }
                                $expenseRows[]=[$supplier->contact_type=='business'? $supplier->supplier_business_name: $supplier->name,...$row];
                            }
                        }

                        foreach($categories as $cat){
                            $row_total=0;
                            $row=[];
                            foreach($used_payment_types as $method_label){
                                $amount=getPaymentSum( $business_id, $start_date, $end_date, '', $location_id, $method_label, ['expense'], $cat->id) ?? 0; 
                                $row[]=$amount;
                                $row_total+=$amount;
                            }
                            if($row_total>0){
                                foreach($row as $k=>$val){
                                    $totalsExpense[$used_payment_types[$k]] += $val;
                                    $grandTotalExpense += $val;
                                }
                                $expenseRows[]=[$cat->name, ...$row];
                            }
                        }
                        $closingRow=['Closing Balance'];
                        foreach($used_payment_types as $method_label){
                            $closing                        =   $totalsIncome[$method_label]-$totalsExpense[$method_label];
                            $totalsExpense[$method_label]   += $closing;
                            $grandTotalExpense              += $closing;
                            $closingRow[]                   =  $closing;
                        }
                        //$expenseRows[]  =   $closingRow;
                        $maxRows        =   max(count($incomeRows),count($expenseRows));
                    @endphp
                    <h1 class="tw-text-xl md:tw-text-3xl tw-font-bold tw-text-black text-center"> {{ Session::get('business.name') }}</h1>
                    <h2 class="tw-text-xl md:tw-text-3xl tw-font-bold tw-text-black text-center">
                        Receipt & Payment Report
                    </h2>
                    <p class="text-center"> 
                        @if(!empty($start_date) && !empty($end_date))
                            <strong>
                                From: {{ \Carbon\Carbon::parse($start_date)->format('m/d/Y') }}
                                &nbsp; To:
                                {{ \Carbon\Carbon::parse($end_date)->format('m/d/Y') }}
                            </strong>
                        @else
                            <strong>
                                Date: {{ \Carbon\Carbon::today()->format('m/d/Y') }}
                            </strong>
                        @endif
                    </p><br><br>
                    <div class="table-responsive">
                        <table class="table table-bordered table-striped" id="sell_payment_report_table">
                            <thead>
                                <tr>
                                    <th colspan="{{1+count($used_payment_types)}}" class="text-center bg-success">Income</th>
                                    <th colspan="{{1+count($used_payment_types)}}" class="text-center bg-danger">Expense</th>
                                </tr>
                                <tr>
                                    <th>Receipt Detail</th>
                                    @foreach($used_payment_types as $method_label)
                                        <th>{{ $payment_types[$method_label] ?? '' }}</th>
                                    @endforeach
                                    <th>@lang('report.particular')</th>
                                    @foreach($used_payment_types as $method_label)
                                        <th>{{ $payment_types[$method_label] ?? '' }}</th>
                                    @endforeach
                                </tr>
                            </thead>
                            <tbody>
                                @for($i=0;$i<$maxRows;$i++)
                                    <tr>
                                        @if(isset($incomeRows[$i]))
                                            <td>{{ $incomeRows[$i][0] }}</td>
                                            @foreach(array_slice($incomeRows[$i],1) as $val)
                                                <td>{{ $val?number_format($val,2):'-' }}</td>
                                            @endforeach
                                        @else
                                            <td></td>
                                                @foreach($used_payment_types as $m)
                                                    <td></td>
                                                @endforeach

                                        @endif
                                        @if(isset($expenseRows[$i]))
                                            <td>{{ $expenseRows[$i][0] }}</td>
                                            @foreach(array_slice($expenseRows[$i],1) as $val)
                                                <td>{{ $val?number_format($val,2):'-' }}</td>
                                            @endforeach
                                        @else
                                            <td></td>
                                            @foreach($used_payment_types as $m)
                                                <td></td>
                                            @endforeach
                                        @endif
                                    </tr>
                                @endfor
                          
                           
                                <tr>
                                    <th colspan=""></th>
                                    @foreach($used_payment_types as $method_label)
                                        <th></th>
                                    @endforeach
                                    <th colspan="">Closing Balance</th>
                                   
                                    @foreach(array_slice($closingRow,1) as $val)
                                        <th>{{ $val?number_format($val,2):'-' }}</th>
                                    @endforeach
                                </tr>
                                <tr>
                                    <th colspan="">Total</th>
                                    @foreach($used_payment_types as $method_label)
                                        <th>{{ number_format($totalsIncome[$method_label],2) }}</th>
                                    @endforeach
                                    <th colspan="">Total</th>
                                    @foreach($used_payment_types as $method_label)
                                        <th>{{ number_format($totalsExpense[$method_label],2) }}</th>
                                    @endforeach
                                </tr>
                            </tbody>
                            <tfoot>
                                <tr>
                                    <th colspan="">Sub Total</th>
                                    <th colspan="{{count($used_payment_types)}}">
                                        {{ number_format($grandTotalIncome,2) }}
                                    </th>
                                    <th colspan="">Sub Total</th>
                                    <th colspan="{{count($used_payment_types)}}">
                                        {{ $grandTotalExpense }}
                                    </th>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                @endcomponent

            </div>
        </div>
    </section>
@endsection

@section('javascript')

<script>
    $(document).ready(function(){
        var moment_date_format  = 'MM/DD/YYYY';
        var separator           = ' ~ ';
        var input               = $('#sell_list_filter_date_range');
        var start               = moment();
        var end                 = moment();
        if(input.val()){
            var range = input.val().replace(' - ',separator);
            var dates = range.split(separator);
            if(dates.length===2){
                start = moment(dates[0],moment_date_format);
                end = moment(dates[1],moment_date_format);
            }
        }
        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.val()){
            input.val(moment().format(moment_date_format)+separator+moment().format(moment_date_format));
        }
    });
    $(document).ready(function () {
        $('#sell_payment_report_table').DataTable({
            processing: true,
            paging: false,
            searching: false,
            ordering: false,
            info: false,
            dom: 'Bfrtip',
        });

    });
</script>

@endsection