@extends('layouts.app')

@section('stitle', __('messages.incomeStatement'))
@section('title', __('messages.incomeStatement'))

@section('content')
    <div class="app-content content">
        <div class="content-overlay"></div>
        <div class="header-navbar-shadow"></div>
        <div class="content-wrapper container-xxl p-0">
            @if(session()->get('title') == "success")
                <div class="alert alert-success" role="alert">
                    <h4 class="alert-heading">Success</h4>
                    <div class="alert-body">
                        {{ session()->get('message') }}
                    </div>
                </div>
            @elseif (session()->get('title') == "error")
                <div class="alert alert-danger" role="alert">
                    <h4 class="alert-heading">Error</h4>
                    <div class="alert-body">
                        {{ session()->get('message') }}
                    </div>
                </div>
            @elseif($errors->any())
                <div class="alert alert-danger" role="alert">
                    <h4 class="alert-heading">Error</h4>
                    @foreach ($errors->all() as $error)
                        <div class="alert-danger">{{ $error }}</div>
                    @endforeach
                </div>
            @else
            @endif
            <div class="content-header row">
                <div class="content-header-left col-md-6 col-12 mb-2">
                    <div class="row breadcrumbs-top">
                        <div class="col-12">
                            <h2 class="content-header-title float-left mb-0">@yield('title')</h2>
                            <div class="breadcrumb-wrapper">
                                <ol class="breadcrumb">
                                    <li class="breadcrumb-item">
                                        <div class="badge badge-warning">
                                            <i data-feather="star" class="mr-25"></i>
                                            <span> {{__('messages.incomeStatement')}} </span>
                                        </div>
                                    </li>
                                </ol>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="content-header-right text-md-right col-md-6 col-12 d-md-block d-none">
                    <div class="form-group breadcrumb-right">
                        {{--                        @include('purchase_requisition.pr_inner_menu')--}}
                    </div>
                </div>
            </div>
            <div class="content-body">
                <section class="invoice-preview-wrapper">
                    <div class="row invoice-preview" id="income_statement">
                        <!-- Invoice -->
                        <div class="col-12">
                            <div class="card invoice-preview-card">
                                <div class="card-body invoice-padding pb-0">
                                    <!-- Header starts -->
                                    <div class="d-flex justify-content-between flex-md-row flex-column invoice-spacing mt-0">

                                        <div class="d-flex mt-1">
                                            <h3>{{__('messages.incomeStatement')}} </h3>
                                        </div>

                                    </div>
                                    <!-- Filter starts -->
                                    <form id="filter_form" action="{{ route('report.filter_accounts') }}" name="filter_form" method="GET">
                                        <div class="row">
                                            <div class="col-md-3 col-12 form-group">
                                                <label for="text">{{__('messages.StartDate')}}</label>
                                                <input class="form-control my-flatpickr-basic" id="start_date" type="text"  name="start_date" placeholder="{{__('messages.StartDate')}}"    tabindex="3" value="{{ old('start_date') ?? $start_date }}" required/>
                                            </div>
                                            <div class="col-md-3 col-12 form-group">
                                                <label for="text">{{__('messages.EndDate')}}</label>
                                                <input class="form-control my-flatpickr-basic" id="end_date" type="text"  name="end_date" placeholder="{{__('messages.EndDate')}}"    tabindex="3" value="{{ old('end_date') ?? $end_date }}" required/>
                                            </div>
                                            <div class="col-md-3 col-12 form-group">
                                                <label for="text">{{__('messages.location')}}</label>
                                                <select class="select2 form-control form-control-lg selected_branch_option"   name="branch" required>
                                                    <option value="" selected>{{__('messages.SelectBranch')}}</option>
                                                    <option value="all_0"{{strpos($main_branch, 'all') !== false && $branchOption == 0 ? 'selected':''}} selected>{{__('messages.All')}}</option>
                                                    <optgroup class="opt-group" label="Branches">
                                                        @foreach($branch as $branch)
                                                            <option value="br_{{ $branch->id }}"{{ (strpos($main_branch, 'br') !== false && $branchOption == $branch->id ? 'selected': (old('branch') == $branch->id && strpos($main_branch, 'ac') !== false ? 'selected':''))}} > {{ $branch->name }} </option>
                                                        @endforeach
                                                    </optgroup>
                                                    <optgroup class="opt-group" label="Account">
                                                        <option value="ac_{{ Auth::user()->business_id }}" {{strpos($main_branch, 'ac') !== false && $branchOption == Auth::user()->business_id ? 'selected':''}}> Main AC </option>
                                                    </optgroup>
                                                </select>
                                            </div>

                                            <div class=" col-md-3 justify-content-start mt-2">
                                                <div class="form-group ">
                                                    <button type="submit" class="btn btn-secondary" onclick="filter_form.action='{{route('report.export')}}'";>{{__('messages.Export')}}</button>
                                                    <button type="submit" class="btn btn-success" onclick="filter_form.action='{{route('report.filter_accounts')}}'"; id="btn_filter">{{__('messages.filter')}}</button>
                                                </div>
                                            </div>
                                        </div>
                                    </form>
                                <!-- Filter ends -->
                                </div>

{{--                                <hr class="invoice-spacing" />--}}

                                <!-- Invoice Description starts -->
                                <div class="table-responsive mb-1">
                                    <table class="table">
                                        <thead>
                                        <tr>
                                            <th colspan="3"></th>
                                            <th></th>
                                        </tr>
                                        </thead>
                                        <tbody>
                                        @php
                                            $totalDebit = 0;
                                            $totalCredit = 0;
                                            $totalRevenue = 0;
                                            $rpCheckName = array();
                                        @endphp
                                        @foreach($revenueData as $journalEntry)
                                            @if(!in_array($journalEntry->getChartOfAccount->parent->name, $rpCheckName))
                                            <tr  data-chart_acc_id="{{ $journalEntry->getChartOfAccount->parent->id}}">
                                                <td colspan="3"><a href="{{route('coa.view',$journalEntry->getChartOfAccount->parent->id)}}"> {{(setUserLang() == "ar") ? $journalEntry->getChartOfAccount->parent->code .'-'. $journalEntry->getChartOfAccount->parent->arabic_name : $journalEntry->getChartOfAccount->parent->code  .'-'. $journalEntry->getChartOfAccount->parent->name }}</a> </td>
                                                <td></td>
                                            </tr>
                                            @endif
                                            <tr data-chart_acc_id="{{ $journalEntry->chart_of_account_id }}">
                                                <td colspan="3" class="pl-5"><a href="{{route('coa.view',$journalEntry->chart_of_account_id)}}">{{(setUserLang() == "ar") ? $journalEntry->getChartOfAccount->code .'-'. $journalEntry->getChartOfAccount->arabic_name : $journalEntry->getChartOfAccount->code  .'-'. $journalEntry->getChartOfAccount->name }}</a></td>
                                                <td><a href="{{route('coa.view',$journalEntry->chart_of_account_id)}}">{{ $journalEntry->total_balance}}</a></td>
                                                @php
                                                    $totalRevenue  +=  $journalEntry->total_balance;
                                                    $rpCheckName[] = $journalEntry->getChartOfAccount->parent->name;
                                                @endphp
                                            </tr>
                                        @endforeach
                                        <tr class="total_row" style="border-top: 4px solid #00000024; border-bottom: 4px solid #00000024;">
                                            <td colspan="3">{{__('messages.Total')}}</td>
                                            <td>{{$totalRevenue}}</td>
                                        </tr>
                                        <tr class="closing_row" style="border-top: 4px solid #00000024; border-bottom: 4px solid #00000024;">
                                            <td colspan="3">{{__('messages.grossProfit')}}</td>
                                            <td>{{$totalRevenue}}</td>
                                        </tr>
                                        @php
                                            $totalExpense = 0;
                                            $epCheckName = array();
                                        @endphp
                                        @foreach($expenseData as $journalEntry)
                                            @if(!in_array($journalEntry->getChartOfAccount->parent->name, $epCheckName))
                                            <tr>
                                                <td colspan="3"><a href="{{route('coa.view',$journalEntry->getChartOfAccount->parent->id)}}">{{(setUserLang() == "ar") ? $journalEntry->getChartOfAccount->parent->code .'-'. $journalEntry->getChartOfAccount->parent->arabic_name : $journalEntry->getChartOfAccount->parent->code  .'-'. $journalEntry->getChartOfAccount->parent->name }}</a></td>
                                                <td></td>
                                            </tr>
                                            @endif
                                            <tr>
                                                <td colspan="3" class="pl-5"><a href="{{route('coa.view',$journalEntry->chart_of_account_id)}}">{{(setUserLang() == "ar") ? $journalEntry->getChartOfAccount->code .'-'. $journalEntry->getChartOfAccount->arabic_name : $journalEntry->getChartOfAccount->code  .'-'. $journalEntry->getChartOfAccount->name }}</a></td>
                                                <td><a href="{{route('coa.view',$journalEntry->chart_of_account_id)}}">{{ $journalEntry->total_balance}}</a></td>
                                                @php
                                                    $totalExpense  += $journalEntry->total_balance;
                                                    $epCheckName[] = $journalEntry->getChartOfAccount->parent->name;
                                                @endphp
                                            </tr>
                                        @endforeach
                                        <tr class="total_row" style="border-top: 4px solid #00000024; border-bottom: 4px solid #00000024;">
                                            <td colspan="3">{{__('messages.total')}}</td>
                                            <td>{{$totalExpense}}</td>
                                        </tr>
                                        @php
                                            $total = $totalRevenue-$totalExpense
                                        @endphp
                                        @if($total > 0)
                                            <tr class="closing_row" style="border-top: 4px solid #00000024; border-bottom: 4px solid #00000024;">
                                                <td colspan="3">{{__('messages.netProfit')}}</td>
                                                <td>{{$total}}</td>
                                            </tr>
                                        @else
                                            <tr class="closing_row" style="border-top: 4px solid #00000024; border-bottom: 4px solid #00000024;">
                                                <td colspan="3">{{__('messages.netLosses')}}</td>
                                                <td>{{$total}}</td>
                                            </tr>
                                        @endif

                                        </tbody>
                                    </table>
                                </div>

                                <div class="card-body invoice-padding pb-0 mt-1">
                                    <div class="row invoice-sales-total-wrapper">
                                        <div class="col-md-6 order-md-1 order-2 mt-md-0 mt-3">

                                        </div>
                                        <div class="col-md-6 d-flex justify-content-end order-md-2 order-1">
                                            <div class="invoice-total-wrapper">

                                            </div>
                                        </div>
                                    </div>
                                </div>


                            </div>
                        </div>
                    </div>
                </section>
            </div>
        </div>
    </div>

@endsection
@push('my_scripts')
    <script>
        $(function () {
            var select = $('.selected_branch_option');
            select.each(function () {
                var $this = $(this);
                $this.wrap('<div class="position-relative"></div>');
                $this
                    .select2({
                        placeholder: '{{__('messages.selectLocation')}}',
                        dropdownParent: $this.parent()
                    })
                    .change(function () {
                        $(this).valid();
                    });
            });
        $('#filter_form').validate({
            rules: {
                start_date: {
                    required: true
                },
                end_date: {
                    greaterThan: ["#start_date","Start Date"]
                },
                branch: {
                    required: true,
                },
            },
            messages:{
                start_date: {
                    required: "Please provide a Start Date",
                },
                end_date: {
                    required: "Please provide a End Date",
                },
                branch: {
                    required: "Please provide a Location",
                },
            },
            errorElement: 'span',
            errorPlacement: function (error, element) {
                error.addClass('invalid-feedback');
                element.closest('.form-group').append(error);
            },
            highlight: function (element, errorClass, validClass) {
                $(element).addClass('is-invalid');
            },
            unhighlight: function (element, errorClass, validClass) {
                $(element).removeClass('is-invalid');
            }
        });
            //  Must be greater than Start Date.
            jQuery.validator.addMethod("greaterThan", function(value, element, params) {
                if ($(params[0]).val() != '') {
                    if (!/Invalid|NaN/.test(new Date(value))) {
                        return new Date(value) >= new Date($(params[0]).val());
                    }
                    return isNaN(value) && isNaN($(params[0]).val()) || (Number(value) >= Number($(params[0]).val()));
                };
                return true;
            },'Must be greater than {1}.');
            //  Must be greater than Start Date.

            $('.my-flatpickr-basic').pickadate({
                onStart: function() {
                },
                formatSubmit: 'yyyy/mm/dd',
                closeOnSelect: true,
                closeOnClear: true,
            });
        });
    </script>

@endpush