@use('App\Services\Date')
@extends('reports::layouts.master')
@section('title', __('reports::reports.Trial Balance'))
@section('page-link')
<li class="breadcrumb-item active">
    <a href="#" class="active"> @lang('reports::reports.Trial Balance')</a>
</li>
@endsection
@section('extra_styles')
    <style>
        tr td{
            word-break: keep-all !important;
        }
    </style>
@endsection
@section('section_title')
@lang('reports::reports.Trial Balance')
@endsection
@section('action_buttons')
<div class="headBtns mx-1 fixed-btns">
    <div class="btn-group pull-right">

    </div>
    <div class="mb-1 pull-left">
        <a class="text-green pull-left" href="{{ route('company.reports.index',['subdomain' => $subdomain]) }}" title="{{__('Back')}}">
            @if(LaravelLocalization::getCurrentLocale() === 'en')
            <span class="icon-Previous action-icon back-btnIcon"></span>
            @else
            <span class="icon-Next action-icon back-btnIcon"></span>
            @endif
        </a>
        @if(request()->all())
        @can('reports.trial-balance.export')
        <a class="text-green" href="{{route('company.reports.trial-balance.export', ['subdomain' => $subdomain,'is_dates'=>request('is_dates'),'fiscal_year_id'=>request('fiscal_year_id'),'from' => request('from'),'to' => request('to'),'exclude_net' => request('exclude_net')])}}" title="@lang('reports::reports.Download_Pdf')">
            <span class="icon-Pdf action-icon"></span>
        </a>

        <a class="text-green" href="{{route('company.reports.trial-balance.export-excel', ['subdomain' => $subdomain,'is_dates'=>request('is_dates'),'fiscal_year_id'=>request('fiscal_year_id'),'from' => request('from'),'to' => request('to'),'exclude_net' => request('exclude_net')])}}" title="@lang('reports::reports.download_excel')">
            <span class="icon-Excel action-icon"></span>
        </a>

        <a class="text-green" target="_blank" href="{{route('company.reports.trial-balance.print', ['subdomain' => $subdomain,'is_dates'=>request('is_dates'),'fiscal_year_id'=>request('fiscal_year_id'),'from' => request('from'),'to' => request('to'),'exclude_net' => request('exclude_net')])}}" title="@lang('reports::reports.print')">
            <span class="icon-Print action-icon"></span>
        </a>
        @endcan
        @endif
    </div>
</div>
@endsection
@section('form-open-tag')
    <form action="{{ route('company.reports.trial-balance.index', ['subdomain' => $subdomain]) }}" method="GET" class="form form-horizontal mt-20" novalidate>
        <input id="default_indicator" type="hidden" name="is_dates" value="{{ request('is_dates') ? request('is_dates') : 0 }}">
        <div class="row">
            <div class="col-xs-12">
                <div class="card report-filter-wrapper">
                    <div class="report-filter-header">
                        <span>@lang('Filter')</span>
                    </div>
                    <div class="card-block card-dashboard" style="padding: 0;">
                        <div class="report-filter-panel">
                            <div class="report-filter-grid">
                                <div class="report-filter-group">
                                    <label for="fiscal_year_id" class="report-filter-label">
                                        @lang('reports::reports.accounting_year')
                                    </label>
                                    <select name="fiscal_year_id" id="fiscal_year_id" class="report-filter-select selectReport">
                                        @if ($data['currentFiscalYear'])
                                            <option id="current_fiscal_year_id"
                                                value="{{ $data['currentFiscalYear']->id }}"
                                                @if (!request('is_dates') && (!request()->filled('fiscal_year_id') || (int) request('fiscal_year_id') === $data['currentFiscalYear']->id)) selected @endif>
                                                @lang('reports::reports.current')
                                            </option>
                                        @endif
                                        @foreach ($data['fiscalYears'] as $fiscalYear)
                                            @if (!$data['currentFiscalYear'] || ($data['currentFiscalYear'] && $data['currentFiscalYear']->id != $fiscalYear->id))
                                                <option value="{{ $fiscalYear->id }}"
                                                    @if ($fiscalYear->id == request('fiscal_year_id')) selected @endif>
                                                    @lang('from')
                                                    {{ Date::format($fiscalYear->year . '-' . $fiscalYear->month . '-' . $fiscalYear->day) }}
                                                    -
                                                    @lang('to')
                                                    {{ Date::format($fiscalYear->closing_date) }}
                                                </option>
                                            @endif
                                        @endforeach
                                        <option @if (request('is_dates')) selected @endif value="">
                                            @lang('reports::reports.custom_duration')
                                        </option>
                                    </select>
                                    @error('fiscal_year_id')
                                        <div class="invalid-feedback text text-danger w-100 d-block" role="alert">
                                            <p>{{ $message }}</p>
                                        </div>
                                    @enderror

                                    <div id="custom_duration_section" style="display: @if(request('is_dates')) block @else none @endif;">
                                        <x-date-picker 
                                            mode="range"
                                            name="date_range"
                                            input-id="date_range"
                                            start-name="from"
                                            end-name="to"
                                            :value="[request('from'), request('to')]"
                                            input-class="report-filter-input"
                                        />
                                        <a href="javascript:void(0)" id="back_to_fiscal_year" style="font-size: 0.85rem; margin-top: 4px; display: inline-block; color: #11B99F; cursor: pointer;">
                                            <i class="fa fa-undo"></i> @lang('reports::reports.use_fiscal_year')
                                        </a>
                                    </div>
                                    @error('from')
                                        <div class="invalid-feedback text text-danger w-100 d-block" role="alert">
                                            <p>{{ $message }}</p>
                                        </div>
                                    @enderror
                                    @error('to')
                                        <div class="invalid-feedback text text-danger w-100 d-block" role="alert">
                                            <p>{{ $message }}</p>
                                        </div>
                                    @enderror
                                </div>

                                <div class="report-filter-group">
                                    <label for="excludeNetAmount" class="report-filter-label">
                                        @lang('reports::reports.not_included_net')
                                    </label>
                                    <div style="display: flex; align-items: center; height: 40px;">
                                        <input type="hidden" id="exclude_net_input" name="exclude_net" value="{{ request('exclude_net', 0) }}">
                                        <input type="checkbox" id="excludeNetAmount" aria-label="@lang('reports::reports.not_included_net')" @if(request('exclude_net')) checked @endif style="width: 20px; height: 20px; margin: 0;">
                                    </div>
                                </div>
                            </div>

                            <div class="report-filter-button-container">
                                <button type="button" id="reset" class="report-filter-button report-filter-button-secondary">
                                    <i class="fa fa-undo"></i> @lang('reports::reports.reset_filters')
                                </button>
                                <button type="submit" class="report-filter-button">
                                    @lang('reports::reports.filter_report')
                                </button>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
@endsection
@if(request()->all())
@section('koolreport')
<section id="configuration" class="summ_report">
    <div class="row">
        <div class="col-xs-12">
            <div class="card">
                <div class="card-body collapse in">
                    <section>
                        <h2>
                            <strong>
                                @lang('reports::reports.Trial Balance')
                            </strong>
                        </h2>

                        <h4><b>{{ $data['companyName'] }}</b></h4>
                        <h4>
                            @lang('reports::reports.as_of') {{@$data['dates']['to']}}
                        </h4>
                    </section>
                    <div class="table-responsive">
                        <table class="table table-borderless">
                            <thead style="border-bottom:1pt solid #00000036; border-top: 1pt solid #00000036">
                                <tr>
                                    <th>@lang('reports::reports.account')</th>
                                    <th class="text-center" colspan="2" >@lang('reports::reports.trial_balance.opening_balance')</th>
                                    <th class="text-center" colspan="2">@lang('reports::reports.trial_balance.period_transactions')</th>
                                    <th class="text-center" colspan="3">@lang('reports::reports.trial_balance.closing_balance')</th>
                                </tr>
                                <tr>
                                    <th></th>
                                    <th class="text-center">@lang('reports::reports.debit')</th>
                                    <th class="text-center">@lang('reports::reports.credit')</th>
                                    <th class="text-center">@lang('reports::reports.debit')</th>
                                    <th class="text-center">@lang('reports::reports.credit')</th>
                                    <th class="text-center">@lang('reports::reports.debit')</th>
                                    <th class="text-center">@lang('reports::reports.credit')</th>
                                    @if (request('exclude_net') == 0)
                                    <th class="text-center">@lang('reports::reports.total closing balance')</th>
                                    @endif
                                </tr>
                            </thead>
                            <tbody>
                                @php
                                $debit_openning_balance =0;
                                $credit_openning_balance =0;
                                $debit_closing_balance =0;
                                $credit_closing_balance =0;
                                @endphp
                                @if(@$data['categorizedAccounts'])
                                    @foreach($data['categorizedAccounts'] as $categoryName => $accounts)
                                    @if($accounts['total_for_display'])
                                        <tr style="border-top: 1px solid #E3EBF3;"> <th colspan="8" class="text-bold" > {{$categoryName}}</th> </tr>
                                        @foreach($accounts as $account)
                                            @if(isset($account['total_for_display']) && isset($account['id']))
                                                <tr style="text-indent: 1em;">
                                                    <td>
                                                        <a target="_blank"
                                                        style="word-break: break-word;"
                                                           href="{{route('company.reports.account-statement.index', ['subdomain' => $subdomain,'cost_center_id'=>request('cost_center_id'),'account_id' => $account['id'],'is_dates'=>request('is_dates'),'fiscal_year_id'=>request('fiscal_year_id'),'from' => request('from'),'to' => request('to')])}}">
                                                            {{ $account['code'] . ' - ' . $account['name'] }}
                                                        </a>
                                                    </td>
{{--                                                    <td>@if(isset($account['opening']['debit'])) {{number_format($account['opening']['debit'],2)}} @else 0.00 @endif </td>--}}

                                                    @if($account['default_type'] == 'debit')
                                                    @php
                                                    if(isset($account['opening']['total_balance']))
                                                    {
                                                        if($account['opening']['total_balance']>0)
                                                        {

                                                            $debit_openning_balance +=abs(@$account['opening']['total_balance']) ?? 0;
                                                        }
                                                        else{
                                                     $credit_openning_balance +=abs(@$account['opening']['total_balance']) ?? 0;

                                                        }
                                                    }
                                                    @endphp
                                                    <td class="text-center">@isset($account['opening']['debit']) @if($account['opening']['total_balance'] > 0)  {{ number_format(abs($account['opening']['total_balance']),2)}} @else {{ number_format(0,2)}} @endif @endisset</td>
                                                    <td class="text-center">@isset($account['opening']['credit']) @if($account['opening']['total_balance'] > 0) {{ number_format(0,2)}} @else {{ number_format(abs($account['opening']['total_balance']),2)}}@endif @endisset</td>
                                                    @else
                                                    @php
                                                     if(isset($account['opening']['total_balance']))
                                                    {
                                                        if($account['opening']['total_balance']>0)
                                                        {
                                                             $credit_openning_balance +=abs(@$account['opening']['total_balance']) ?? 0;
                                                        }else{
                                                            $debit_openning_balance +=abs(@$account['opening']['total_balance']) ?? 0;

                                                        }
                                                    }
                                                    @endphp
                                                    <td class="text-center">@isset($account['opening']['debit'])  @if($account['opening']['total_balance'] >= 0) {{ number_format(0,2)}} @else{{ number_format(abs($account['opening']['total_balance']) ,2)}}  @endif @endisset</td>
                                                    <td class="text-center">@isset($account['opening']['credit']) @if($account['opening']['total_balance'] > 0) {{ number_format(abs($account['opening']['total_balance'] ) ,2)}} @else {{ number_format(0,2)}} @endif @endisset</td>

                                                    @endif

                                                    <td class="text-center">@isset($account['period']['debit'])  {{ number_format($account['period']['debit'],2)}} @endisset</td>
                                                    <td class="text-center">@isset($account['period']['credit'])  {{ number_format($account['period']['credit'],2)}} @endisset</td>
                                                    @if($account['default_type'] == 'debit')
                                                                {{-- start for debit + period  debit - credit start (0) + period credit  --}}
                                                                {{-- if the balance is negative add it in credit if it positive add it in debit --}}


                                                                        @php
                                                                        if(isset($account['opening']['total_balance']))
                                                                        {

                                                                            $period = ($account['opening']['total_balance'] + $account['period']['debit']) - (0 + $account['period']['credit']);
                                                                        }else{
                                                                            $period =0;
                                                                        }
                                                                        if($period > 0)
                                                                        {
                                                                            $debit_closing_balance += abs($period);
                                                                        }else{

                                                                            $credit_closing_balance += abs($period);
                                                                        }

                                                                        @endphp

                                                                    <td class="text-center" style="text-indent: 1em;">@isset($account['opening']['debit']) @if($period > 0)  {{ number_format(abs($period),2)}} @else {{ number_format(0,2)}} @endif @endisset</td>
                                                                    <td class="text-center" style="text-indent: 1em;">@isset($account['opening']['credit'])  @if($period < 0)  {{ number_format(abs($period),2)}} @else {{ number_format(0,2)}} @endif @endisset</td>
                                                                @else

                                                                @php
                                                                if(isset($account['opening']['total_balance']))
                                                                        {
                                                                $period = ($account['opening']['total_balance'] + $account['period']['credit']) - (0 + $account['period']['debit']);
                                                                        }
                                                                        else{
                                                                            $period =0;
                                                                        }
                                                                        if($period >0)
                                                                        {
                                                                            $credit_closing_balance += abs($period);
                                                                        }else{

                                                                            $debit_closing_balance += abs($period);
                                                                        }
                                                                  @endphp

                                                                <td class="text-center" style="text-indent: 1em;">@isset($account['opening']['debit']) @if($period < 0)  {{ number_format(abs($period),2)}} @else {{ number_format(0,2)}} @endif @endisset</td>
                                                                <td class="text-center" style="text-indent: 1em;">@isset($account['opening']['credit'])  @if($period > 0)  {{ number_format(abs($period),2)}} @else  {{ number_format(0,2)}} @endif @endisset</td>
                                                                    {{-- <td class="text-center" style="text-indent: 1em;">@isset($childAccount['closing']['debit'])  {{ number_format($childAccount['closing']['debit'],2)}} @endisset</td>
                                                                    <td class="text-center" style="text-indent: 1em;">@isset($childAccount['closing']['credit'])  {{ number_format($childAccount['closing']['credit'],2)}} @endisset</td> --}}

                                                    @endif
                                                    {{-- <td class="text-center">@isset($account['closing']['debit'])  {{ number_format($account['closing']['debit'],2)}} @endisset</td>
                                                    <td class="text-center">@isset($account['closing']['credit'])  {{ number_format($account['closing']['credit'],2)}} @endisset</td> --}}
                                                    @if (request('exclude_net') == 0)
                                                    <td class="text-center">
                                                        @isset($account['closing']['total_balance'])
                                                            @if($account['closing']['total_balance'] >= 0)
                                                                {{ number_format($account['closing']['total_balance'],2)}}
                                                            @else
                                                                {{ "(" . number_format(abs($account['closing']['total_balance']),2) . ")"}}
                                                            @endif
                                                        @endisset
                                                    </td>
                                                    @endif
                                                </tr>
                                                @isset($account['childs'])
                                                    @foreach($account['childs'] as $childAccount)
                                                        @if($childAccount['total_for_display'] && isset($childAccount['id']) )
                                                            <tr style="text-indent: {{$childAccount['level'] ?? 0 + 1}}em;">
                                                                <td>
                                                                    <a target="_blank"
                                                                       href="{{route('company.reports.account-statement.index', ['subdomain' => $subdomain,'cost_center_id'=>request('cost_center_id'),'account_id' => ($childAccount['id'] ?? null) ,'is_dates'=>request('is_dates'),'fiscal_year_id'=>request('fiscal_year_id'),'from' => request('from'),'to' => request('to')])}}">
                                                                        {{ $childAccount['code'] . ' - ' . $childAccount['name'] }}
                                                                    </a>
                                                                </td>

                                                                    @if($account['default_type'] == 'debit')

                                                                    @isset($childAccount['opening']['debit'])

                                                                        @php
                                                                        if(isset($childAccount['opening']) && $childAccount['opening']['total_balance'] >0)
                                                                        {

                                                                            $debit_openning_balance +=abs($childAccount['opening']['total_balance']) ?? 0;
                                                                        }else{
                                                                             $credit_openning_balance +=abs(@$childAccount['opening']['total_balance']) ?? 0;

                                                                            }
                                                                            @endphp

                                                                        @endisset
                                                                        <td class="text-center">@isset($childAccount['opening']['debit']) @if($childAccount['opening']['total_balance'] > 0)  {{ number_format(abs($childAccount['opening']['total_balance']),2)}} @else {{ number_format(0,2)}} @endif @endisset</td>
                                                                        <td class="text-center">@isset($childAccount['opening']['credit']) @if($childAccount['opening']['total_balance'] > 0) {{ number_format(0,2)}} @else {{ number_format(abs($childAccount['opening']['total_balance']),2)}}@endif @endisset</td>


                                                                    @else
                                                                    @php
                                                                    if(isset($childAccount['opening']) && $childAccount['opening']['total_balance'] >0)
                                                                        {
                                                                         $credit_openning_balance +=abs(@$childAccount['opening']['total_balance']) ?? 0;
                                                                        }else{
                                                                            $debit_openning_balance +=abs(@$childAccount['opening']['total_balance']) ?? 0;

                                                                        }
                                                                    @endphp
                                                                    <td class="text-center">@isset($childAccount['opening']['debit']) @if($childAccount['opening']['total_balance'] > 0) {{ number_format(0,2)}} @else{{ number_format(abs($childAccount['opening']['total_balance']),2)}}  @endif @endisset</td>
                                                                    <td class="text-center">@isset($childAccount['opening']['credit']) @if($childAccount['opening']['total_balance'] > 0) {{ number_format(abs($childAccount['opening']['total_balance']),2)}} @else  {{ number_format(0,2)}} @endif @endisset</td>

                                                                    @endif

                                                                <td class="text-center" style="text-indent: 1em;">@isset($childAccount['period']['debit'])  {{ number_format($childAccount['period']['debit'],2)}} @endisset</td>
                                                                <td class="text-center" style="text-indent: 1em;">@isset($childAccount['period']['credit'])  {{ number_format($childAccount['period']['credit'],2)}} @endisset</td>
                                                                {{-- <td class="text-center" style="text-indent: 1em;">@isset($childAccount['closing']['debit'])  {{ number_format($childAccount['closing']['debit'],2)}} @endisset</td>
                                                                <td class="text-center" style="text-indent: 1em;">@isset($childAccount['closing']['credit'])  {{ number_format($childAccount['closing']['credit'],2)}} @endisset</td> --}}

                                                                @if($account['default_type'] == 'debit')
                                                                {{-- start for debit + period  debit - credit start (0) + period credit  --}}
                                                                {{-- if the balance is negative add it in credit if it positive add it in debit --}}
                                                                {{-- {{ dd($childAccount['opening']['total_balance']) }} --}}
                                                                        @php
                                                                        if(isset($childAccount['opening']['total_balance']))
                                                                        {
                                                                            $period = ($childAccount['opening']['total_balance'] + $childAccount['period']['debit']) - (0 + $childAccount['period']['credit']);
                                                                        }else{
                                                                            $period =0;
                                                                        }
                                                                        if($period >0)
                                                                        {
                                                                            $debit_closing_balance += abs($period);
                                                                        }else{

                                                                            $credit_closing_balance += abs($period);
                                                                        }
                                                                        @endphp

                                                                    <td class="text-center" style="text-indent: 1em;">@isset($childAccount['opening']['debit']) @if($period > 0)  {{ number_format(abs($period),2)}} @else {{ number_format(0,2)}} @endif @endisset</td>
                                                                    <td class="text-center" style="text-indent: 1em;">@isset($childAccount['opening']['credit'])  @if($period < 0)  {{ number_format(abs($period),2)}} @else {{ number_format(0,2)}} @endif @endisset</td>
                                                                 @else
                                                                    @php
                                                                    if(isset($childAccount['opening']['total_balance']))
                                                                        {
                                                                  $period = ($childAccount['opening']['total_balance'] + $childAccount['period']['credit']) - (0 + $childAccount['period']['debit']);
                                                                        }else{
                                                                            $period =0;
                                                                        }
                                                                        if($period >0)
                                                                        {
                                                                            $credit_closing_balance += abs($period);
                                                                        }else{

                                                                            $debit_closing_balance += abs($period);
                                                                        }
                                                                   @endphp

                                                                <td class="text-center" style="text-indent: 1em;">@isset($childAccount['opening']['debit']) @if($period < 0) {{ number_format(abs($period),2)}} @else{{ number_format(0,2)}} @endif @endisset</td>
                                                                <td class="text-center" style="text-indent: 1em;">@isset($childAccount['opening']['credit'])  @if($period > 0) {{ number_format(abs($period),2)}} @else {{ number_format(0,2)}} @endif @endisset</td>
                                                                    {{-- <td class="text-center" style="text-indent: 1em;">@isset($childAccount['closing']['debit'])  {{ number_format($childAccount['closing']['debit'],2)}} @endisset</td>
                                                                    <td class="text-center" style="text-indent: 1em;">@isset($childAccount['closing']['credit'])  {{ number_format($childAccount['closing']['credit'],2)}} @endisset</td> --}}

                                                                @endif
                                                                @if (request('exclude_net') == 0)
                                                                <td class="text-center" style="text-indent: 1em;">
                                                                    @isset($childAccount['closing']['total_balance'])
                                                                        @if($childAccount['closing']['total_balance'] >= 0)
                                                                            {{ number_format($childAccount['closing']['total_balance'],2)}}
                                                                        @else
                                                                            {{ "(" . number_format(abs($childAccount['closing']['total_balance']),2) . ")"}}
                                                                        @endif
                                                                    @endisset
                                                                </td>
                                                                @endif
                                                            </tr>
                                                        @endif
                                                    @endforeach
                                                @endisset
                                            @endif
                                        @endforeach
                                    @endif
                                @endforeach
                                @endif
                                <tr style="border-bottom:1pt solid #00000036;border-top:1pt solid #00000036">
                                    <th>@lang('reports::reports.trial_balance.total')</th>
                                    <td class="text-center">{{number_format($debit_openning_balance,2)}}</td>
                                    <td class="text-center">{{number_format($credit_openning_balance,2)}}</td>
                                    <td class="text-center">{{number_format(@$data['total']['period']['debit'],2)}}</td>
                                    <td class="text-center">{{number_format(@$data['total']['period']['credit'],2)}}</td>
                                    <td class="text-center">{{number_format($debit_closing_balance,2)}}</td>
                                    <td class="text-center">{{number_format($credit_closing_balance,2)}}</td>
                                    @if (request('exclude_net') == 0)
                                    <td class="text-center">---</td>
                                    @endif
                                </tr>
                            </tbody>
                        </table>
                    </div>
                    <div class="text-lg-center">
                        @lang('reports::reports.accrual_basis')
                        {{ Date::format(now(), 'datetime') }}
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>
@endsection
@endif
@section('extra_scripts_filter_by_date')
    <script>
        gtag('event', 'web_reports_trial_balance_show');

        document.addEventListener('DOMContentLoaded', function () {
            var excludeCheckbox = document.getElementById('excludeNetAmount');
            var excludeInput = document.getElementById('exclude_net_input');
            var resetButton = document.getElementById('reset');

            if (excludeCheckbox && excludeInput) {
                excludeCheckbox.addEventListener('change', function () {
                    excludeInput.value = excludeCheckbox.checked ? 1 : 0;
                });

                if (resetButton) {
                    resetButton.addEventListener('click', function () {
                        setTimeout(function () {
                            excludeCheckbox.checked = false;
                            excludeInput.value = 0;
                        }, 0);
                    });
                }
            }
        });
    </script>
@endsection