@extends('layouts.app')

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

@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>
            @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.balanceSheet')}} </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.trialBalance')}} </h3>
                                        </div>
                                    </div>
                                    <!-- Filter starts -->
                                    <!-- Filter starts -->
                                    <form id="filter_form" name="filter_form" action="{{route('report.filter_trial_balance')}}" 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-start-date" id="start_date" type="text"  name="start_date" placeholder="{{__('messages.StartDate')}}"    tabindex="3" value="{{$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="{{$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="" >{{__('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.trial_balance_export')}}'";>{{__('messages.Export')}}</button>
                                                    <button type="submit" class="btn btn-success" onclick="filter_form.action='{{route('report.filter_trial_balance')}}'"; id="btn_filter">{{__('messages.filter')}}</button>
                                                </div>
                                            </div>
                                        </div>
                                    </form>
                                    <!-- Filter ends -->
                                    <!-- Filter ends -->
                                </div>

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

                                <!-- Invoice Description starts -->
                                <div class="table-responsive mb-1">
                                    <table class="table">
                                        <thead>
                                        <tr>
                                            <th colspan="4" ></th>
                                            <th colspan="2" style="text-align: center">Opening Balance</th>
                                            <th colspan="2" style="text-align: center" >Movement</th>
                                            <th colspan="2" style="text-align: center">Net Movement</th>
                                            <th colspan="2" style="text-align: center">Closing Balance</th>
                                        </tr>
                                        <tr>
                                            <th colspan="4" style="text-align: center">Account</th>
                                            <th style="text-align: center">Debit</th>
                                            <th style="text-align: center">Credit</th>
                                            <th style="text-align: center">Debit</th>
                                            <th style="text-align: center">Credit</th>
                                            <th style="text-align: center">Debit</th>
                                            <th style="text-align: center">Credit</th>
                                            <th style="text-align: center">Debit</th>
                                            <th style="text-align: center">Credit</th>
                                        </tr>
                                        </thead>
                                        <tbody>
                                        @php
                                            $opening_total_debit = 0;
                                            $opening_total_credit = 0;

                                            $mov_total_debit = 0;
                                            $mov_total_credit = 0;

                                            $net_mov_total_debit = 0;
                                            $net_mov_total_credit = 0;

                                            $closing_total_debit = 0;
                                            $Closing_total_credit = 0;
                                        @endphp
                                        @foreach($data as $key =>$chartOfAcc)
                                            @include('accounting.reports.sub_trial_balance',['subcategories' => $chartOfAcc,'level' => 0, 'final_debit' => $final_debit, 'final_credit' => $final_credit])
                                            @if(in_array($chartOfAcc['id'], array_keys($final_debit)))
                                                <tr>
                                                    <td colspan="4"><span style="font-weight:bold">
                                                        <a href="{{route('coa.view',$chartOfAcc->id)}}">
                                                            @if(setUserLang() == "ar")
                                                                {{__('messages.Total')}}  {{$chartOfAcc->code}} - {{$chartOfAcc->arabic_name}}
                                                            @else
                                                                {{__('messages.Total')}}   {{$chartOfAcc->code}} - {{$chartOfAcc->name}}
                                                            @endif
                                                        </a>
                                                        </span>
                                                    </td>
                                                    <td>
                                                        <span style="font-weight:bold"><a href="{{route('coa.view',$chartOfAcc->id)}}">
                                                            {{ format_balance($final_open_debit[$chartOfAcc['id']]) }}
                                                            @php
                                                                $opening_debit = 0;
                                                                    $opening_debit = $final_open_debit[$chartOfAcc['id']];
                                                                    $opening_total_debit +=$opening_debit;
                                                            @endphp
                                                            </a></span>
                                                    </td>
                                                    <td>
                                                        <span style="font-weight:bold"><a href="{{route('coa.view',$chartOfAcc->id)}}">
                                                            {{ format_balance($final_open_credit[$chartOfAcc['id']]) }}
                                                            @php
                                                                $opening_credit = 0;
                                                                    $opening_credit = $final_open_credit[$chartOfAcc['id']];
                                                                    $opening_total_credit += $opening_credit;
                                                            @endphp
                                                            </a></span>
                                                    </td>
                                                    <td>
                                                        <span style="font-weight:bold"><a href="{{route('coa.view',$chartOfAcc->id)}}">
                                                            @php
                                                                format_balance($final_debit[$chartOfAcc['id']]);
                                                                $total_debit = $final_debit[$chartOfAcc['id']];
                                                                $mov_total_debit += $total_debit;
                                                            @endphp
                                                            </a></span>
                                                    </td>
                                                    <td>
                                                        <span style="font-weight:bold"><a href="{{route('coa.view',$chartOfAcc->id)}}">
                                                            @php
                                                                format_balance($final_credit[$chartOfAcc['id']]);
                                                                $total_credit = $final_credit[$chartOfAcc['id']];
                                                                $mov_total_credit += $total_credit;
                                                            @endphp
                                                            </a></span>
                                                    </td>
                                                    <td>
                                                        <span style="font-weight:bold">
                                                            <a href="{{route('coa.view',$chartOfAcc->id)}}">
                                                            {{ format_balance($final_net_movement_debit[$chartOfAcc['id']]) }}
                                                                @php
                                                                    $net_movement_debit = 0;
                                                                    $net_movement_debit = $final_net_movement_debit[$chartOfAcc['id']];
                                                                        $net_mov_total_debit += $final_net_movement_debit[$chartOfAcc['id']];
                                                                @endphp
                                                            </a>
                                                        </span>
                                                    </td>
                                                    <td>
                                                         <span style="font-weight:bold">
                                                             <a href="{{route('coa.view',$chartOfAcc->id)}}">
                                                            {{ format_balance($final_net_movement_credit[$chartOfAcc['id']]) }}
                                                                 @php
                                                                 $net_movement_credit = 0;
                                                                 $net_movement_credit = $final_net_movement_credit[$chartOfAcc['id']];
                                                                     $net_mov_total_credit += $final_net_movement_credit[$chartOfAcc['id']];
                                                                 @endphp
                                                             </a>
                                                         </span>
                                                    </td>
                                                    @php
                                                        $closing_debit = 0;
                                                        $closing_credit = 0;
                                                        Log::channel('test_log')->info("-Opening debit -> {$opening_total_debit} __Opening credit__ {$opening_total_credit}");
                                                            if ( $opening_debit != 0){
                                                                if ( $net_movement_debit != 0){
                                                                   $closing_debit = $opening_debit + $net_movement_debit;
                                                                }else{
                                                                    if ($opening_debit > $net_movement_credit){
                                                                    $closing_debit = $opening_debit - $net_movement_credit;
                                                                    }else{
                                                                    $closing_credit = $net_movement_credit - $opening_debit;
                                                                    }
                                                                }
                                                            }else{

                                                                if ( $net_movement_credit != 0){
                                                                   $closing_credit = $opening_credit + $net_movement_credit;
                                                                }else{
                                                                    if ($opening_credit > $net_movement_debit){
                                                                    $closing_credit = $opening_credit - $net_movement_debit;
                                                                    }else{
                                                                    $closing_debit = $net_movement_debit - $opening_credit;
                                                                    }
                                                                }
                                                            }
                                                    @endphp
                                                        <td>
                                                         <span style="font-weight:bold">
                                                             <a href="{{route('coa.view',$chartOfAcc->id)}}">
                                                                {{$closing_debit}}
                                                                 @php
                                                                     $closing_total_debit += $closing_debit;
                                                                 @endphp
                                                             </a>
                                                         </span>
                                                        </td>
                                                    <td>
                                                        <span style="font-weight:bold">
                                                            <a href="{{route('coa.view',$chartOfAcc->id)}}">
                                                                {{$closing_credit}}
                                                                @php
                                                                    $Closing_total_credit += $closing_credit;
                                                                @endphp
                                                            </a>
                                                        </span>
                                                    </td>
                                                </tr>
                                            @endif
                                        @endforeach
                                        <tr>
                                            <td colspan="4"><span style="font-weight:bold">{{__('messages.total')}} </span>
                                            </td>
                                            <td>
                                                <span style="font-weight:bold">
                                                    {{$opening_total_debit}}
                                                </span>
                                            </td>
                                            <td>
                                                <span style="font-weight:bold">
                                                    {{$opening_total_credit}}
                                                </span>
                                            </td>
                                            <td>
                                                <span style="font-weight:bold">
                                                    {{$mov_total_debit}}
                                                </span>
                                            </td>
                                            <td>
                                                <span style="font-weight:bold">
                                                    {{$mov_total_credit}}
                                                </span>
                                            </td>
                                            <td>
                                                <span style="font-weight:bold">
                                                    {{$net_mov_total_debit}}
                                                </span>
                                            </td>
                                            <td>
                                                <span style="font-weight:bold">
                                                    {{$net_mov_total_credit}}
                                                </span>
                                            </td>
                                            <td>
                                                <span style="font-weight:bold">
                                                    {{$closing_total_debit}}
                                                </span>
                                            </td>
                                            <td>
                                                <span style="font-weight:bold">
                                                    {{$Closing_total_credit}}
                                                </span>
                                            </td>
                                        </tr>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                        <!-- /Invoice -->
                    </div>
                </section>
            </div>
        </div>
    </div>

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


        });
    </script>

@endpush