@use('App\Services\Date')
@extends('reports::layouts.master')
@section('title', __('reports::reports.Journal Report'))
<!-- to be change account-summaries -->
@section('extra_styles')
@parent
<style>
    #t-footer th{
        width: 15%;
    }
</style>
@endsection
@section('page-link')
<li class="breadcrumb-item active">
    <a href="#" class="active">@lang('reports::reports.Journal Report')</a><!-- to be change account-summaries -->
</li>
@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)}}" 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(isset($data['journalEntries']) )
            @can('reports.journal-report.export')
                <a class="text-green" href="{{route('company.reports.legacy.journal-report.export', ['subdomain' => $subdomain,'is_dates'=>request('is_dates'),'fiscal_year_id'=>request('fiscal_year_id'),'from' => request('from'),'to' => request('to'),'cost_center_id'=>request('cost_center_id'),'transaction_type'=>request('transaction_type')])}}" title="@lang('reports::reports.Download_Pdf')">
                    <span class="icon-Pdf action-icon"></span>
                </a>
                <a class="text-green" href="{{route('company.reports.legacy.journal-report.export-excel', ['subdomain' => $subdomain,'is_dates'=>request('is_dates'),'fiscal_year_id'=>request('fiscal_year_id'),'from' => request('from'),'to' => request('to'),'cost_center_id'=>request('cost_center_id'),'transaction_type'=>request('transaction_type')])}}" title="@lang('reports::reports.download_excel')">
                    <span class="icon-Excel action-icon"></span>
                </a>
                <a class="text-green" @if(count($data['journalEntries']) < 1999)target="_blank" @endif href="{{route('company.reports.legacy.journal-report.print', ['subdomain' => $subdomain,'is_dates'=>request('is_dates'),'fiscal_year_id'=>request('fiscal_year_id'),'from' => request('from'),'to' => request('to'),'cost_center_id'=>request('cost_center_id'),'transaction_type'=>request('transaction_type')])}}" title="@lang('reports::reports.print')">
                    <span class="icon-Print action-icon"></span>
                </a>
            @endcan
        @endif
    </div>
</div>
@endsection
@section('section_title')
@lang('reports::reports.Journal Report')
@endsection

@section('form-open-tag')
    <form action="{{ route('company.reports.legacy.journal-report.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="cost_center_id" class="report-filter-label">
                                        @lang('reports::reports.cost_center')

                                    </label>
                                    @php
                                        $selectedCostCenters = (array) request('cost_center_id', []);
                                        $allCostCentersCount = app(\Modules\Products\Repositories\CostCentersRepository::class)->count();
                                        $costCentersCollection = is_array($data['costCenters']) ? collect($data['costCenters']) : $data['costCenters'];
                                        $hasAccessToAllCostCenters = auth()->user()->adjustRolesLikeOwnerPermissions() || $costCentersCollection->count() >= $allCostCentersCount;
                                    @endphp
                                    <select name="cost_center_id[]" id="cost_center_id" class="report-filter-select selectReport" multiple>
                                        @if($costCentersCollection->count() > 1 || ($costCentersCollection->count() == 1 && auth()->user()->can('cost-center.main-center.view')))
                                            <option value="" @if(empty($selectedCostCenters) || in_array('', $selectedCostCenters, true) || in_array(null, $selectedCostCenters, true)) selected @endif>{{ __('All') }}</option>
                                        @endif
                                        @can('cost-center.main-center.view')
                                            <option value="0" @if(in_array('0', $selectedCostCenters, true)) selected @endif>
                                                {{ __('products::cost_center.main center') }}
                                            </option>
                                        @endcan
                                        @foreach($data['costCenters'] as $costCenterId => $costCenterName)
                                            <option value="{{ $costCenterId }}" @if(in_array($costCenterId, $selectedCostCenters)) selected @endif>
                                                {{ $costCenterName }}
                                            </option>
                                        @endforeach
                                    </select>
                                    @error('cost_center_id')
                                        <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="transaction_type" class="report-filter-label">
                                        @lang('reports::reports.transaction_type')
                                        <span style="font-size: 0.75rem; color: #6c757d; font-weight: normal; margin-{{ app()->getLocale() === 'ar' ? 'right' : 'left' }}: 0.5rem;">
                                            ({{ __('reports::reports.leave_empty_for_all') }})
                                        </span>
                                    </label>
                                    @php
                                        // Fetch the backend-provided list (already formatted as array of {id, name})
                                        $allowedTransactionTypesWithMapping = $data['transactionTypes'] ?? [];

                                        $selectedTypes = request('transaction_type', []);
                                        $selectedTypes = is_array($selectedTypes) ? array_map('intval', $selectedTypes) : [intval($selectedTypes)];
                                    @endphp
                                    <transaction-type-dropdown-component
                                    :selected="{{ json_encode($selectedTypes) }}"
                                    :lang="'{{ app()->getLocale() }}'"
                                    :multi-select="true"
                                    input-name="transaction_type"
                                    :options="{{ json_encode($allowedTransactionTypesWithMapping) }}"
                                    :translations="{
                                        placeholder: '{{ __("accounting::transaction_types.select_transaction_type") }}',
                                        searchPlaceholder: '{{ __("accounting::transaction_types.search_transaction_types") }}',
                                        noResultsText: '{{ __("accounting::transaction_types.no_transaction_types_found") }}',
                                    }"
                                    class="w-100"
                                />
                                </div>

                                <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 ($data['currentFiscalYear']->id == request('fiscal_year_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>

                            <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

@section('koolreport')

@if(isset($data['journalEntries']) )
<section id="configuration" class="summ_report">
    <div class="row">
        <div class="col-xs-12">
            <div class="card">
                <div class="card-body collapse in">
                    <div>
                        <h2> @lang('reports::reports.Journal Report') </h2>
                        <h4><b>{{$data['companyName']}}</b></h4>
                        <h4> @lang('from') <span dir="ltr">{{$data['dates']['from']}}</span> @lang('to') <span dir="ltr">{{$data['dates']['to']}}</span> </h4>

                        @if(isset($data['journalEntries']) && count($data['journalEntries']) > 0)
                            <div class="table-responsive" style="font-size: 1rem;">
                                <table class="table table-striped" id="entries_table" style="border-collapse: collapse !important;">
                                    <thead>
                                        <tr>
                                            <th>@lang('reports::reports.journal_report.journal_date')</th>
                                            <th>@lang('reports::reports.journal_report.transaction_type')</th>
                                            <th>@lang('reports::reports.journal_number')</th>
                                            <th>@lang('reports::reports.journal_report.journal_description')</th>
                                            <th>@lang('reports::reports.account')</th>
                                            <th style="width: 20%">@lang('reports::reports.reference_name')</th>
                                            <th>@lang('reports::reports.debit')</th>
                                            <th>@lang('reports::reports.credit')</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                    </tbody>
                                </table>
                                <table class="table table-striped mt-2">
                                    <tfoot id="t-footer">
                                        <tr>
                                            <th> @lang('reports::reports.journal_report.total') </th>
                                            <th></th>
                                            <th></th>
                                            <th></th>
                                            <th></th>
                                            <th></th>
                                            <th> {{ number_format($data['totalDebit'], 2) }} </th>
                                            <th> {{ number_format($data['totalCredit'], 2) }} </th>
                                        </tr>
                                    </tfoot>
                                </table>
                            </div>
                        @else
                            @php
                                $transactionFilterApplied = request()->filled('transaction_type') && ! in_array('0', (array) request('transaction_type'));
                                $costCenterFilterApplied = !empty(array_filter((array) request('cost_center_id', []), static function ($v) {
                                    return $v !== '';
                                }));
                            @endphp
                            @if($transactionFilterApplied)
                                <div class="alert alert-warning text-center">
                                    <h4>{{ __('reports::reports.journal_report.no_entries_for_transaction_type') }}</h4>
                                </div>
                            @elseif($costCenterFilterApplied)
                                <div class="alert alert-warning text-center align-items-center">
                                    <h4>@lang('reports::reports.journal_report.no_entries_for_cost_center')</h4>
                                </div>
                            @else
                                <div class="alert alert-warning text-center">
                                    <h4>@lang('reports::reports.journal_report.no_entries')</h4>
                                </div>
                            @endif
                        @endif
                    </div>
                </div>
            </div>
        </div>
    </div>
    </div>
</section>
@endif

@endsection
@section('filter-by-dates')
<div class="row py-1" id="filter-by-dates" style="display: none">
    <div class="col-md-6">
        <div class="row">
            <div class="col-md-2">
                <label for="from">@lang('from')</label>
            </div>
            <div class="col-md-10">
                <div class='input-group'>
                    <input type='text' class="form-control singledate h-45" name="from" value="{{ request('from') }}" id="from" class="{{$errors->has('from') ? ' is-invalid':''}}" />
                    <span class="input-group-addon" style="height: 40px !important;line-height:40px">
                        <span class="fa fa-calendar"></span>
                    </span>
                </div>

                @error('from')
                <div class="invalid-feedback text text-danger w-100 d-block" role="alert">
                    <p>{{ $message }}</p>
                </div>
                @enderror
            </div>

        </div>

    </div>

    <div class="col-md-6">
        <div class="row">
            <div class="col-md-2">
                <label for="category">@lang('to')</label>
            </div>
            <div class="col-md-10">
                <div class='input-group'>
                    <input type='text' class="form-control singledate h-45" name="to" value="{{ request('to') }}" id="to" class="{{$errors->has('to') ? ' is-invalid':''}}" />
                    <span class="input-group-addon" style="height: 40px !important;line-height:40px">
                        <span class="fa fa-calendar"></span>
                    </span>
                </div>

                @error('to')
                <div class="invalid-feedback text text-danger w-100 d-block" role="alert">
                    <p>{{ $message }}</p>
                </div>
                @enderror
            </div>
        </div>
    </div>

</div>

@endsection
@section('extra_scripts_filter_by_date')
    <style>
        .select2-selection__choice {
            max-width: 100%;
            overflow: hidden;
            text-overflow: ellipsis;
        }
        .select2-container--default .select2-selection--multiple {
            max-height: 200px;
            overflow-y: auto;
        }
        .select2-selection__rendered {
            max-height: 200px;
            overflow-y: auto;
        }
    </style>
    <script>
        gtag('event', 'web_reports_journal_report_show');
    </script>
    <script>
        document.addEventListener('DOMContentLoaded', function () {
            const isOwnerLike = @json($hasAccessToAllCostCenters);
            if (typeof window.initializeCostCenterNormalization === 'function') {
                window.initializeCostCenterNormalization(isOwnerLike);
            }
        });
    </script>

    <!-- Initialize transaction type select2 for journal report -->
    <script defer>
        document.addEventListener('DOMContentLoaded', function () {
            var $tt = $('#transaction_type');
            if ($tt.length && !$tt.hasClass('select2-hidden-accessible')) {
                $tt.select2({
                    width: '100%',
                    language: {
                        noResults: function () {
                            return '{{ __("reports::reports.no result found") }}';
                        }
                    },
                    escapeMarkup: function (markup) { return markup; }
                });

                // Mutual exclusivity logic between "All" and other options
                $tt.on('select2:select', function (e) {
                    var val = e.params.data.id;
                    if (val === '0') {
                        // keep only All
                        $tt.val('0').trigger('change.select2');
                    } else {
                        // remove All if exists
                        var vals = $tt.val() || [];
                        var idx = vals.indexOf('0');
                        if (idx !== -1) {
                            vals.splice(idx, 1);
                            $tt.val(vals).trigger('change.select2');
                        }
                    }
                });

                $tt.on('select2:unselect', function () {
                    var vals = $tt.val();
                    if (!vals || vals.length === 0) {
                        $tt.val('0').trigger('change.select2');
                    }
                });
            }
        });
    </script>

<script>
    window.addEventListener('DOMContentLoaded', function() {
        $(document).ready(function() {
            $("body").on("click", ".run_report_btn", function() {
                $(".report-action").removeClass("hide");
            })

            @if(isset($data['journalEntries']) && count($data['journalEntries']) > 0)
            // journal entries datatable
            var baseUrl = "{{route('company.reports.legacy.journal-report.index',['subdomain' => $subdomain,'is_dates'=>request('is_dates'),'fiscal_year_id'=>request('fiscal_year_id'),'from' => request('from'),'to' => request('to'),'transaction_type'=>request('transaction_type')])}}";
            baseUrl = baseUrl.replace(/&amp;/g, '&');

            var entriesTable = $('#entries_table').DataTable({
                processing: true,
                serverSide: true,
                ajax: {
                    url: baseUrl,
                    data: function(d) {
                        // Always include the current cost center selection in AJAX requests
                        d.cost_center_id = $('#cost_center_id').val();
                        return d;
                    },
                    responsive: true,
                    ordering: true,
                    paging: true,
                    dataSrc: function ( json ) {
                        return json.data;
                    }
                },
                columns: [
                {"data": "journal_date"},
                {"data": "transaction_type"},
                {"data": "display_code",
                "render": function(data, type, row, meta){
                        if(type === 'display'){
                            result = "<a @can('accounting.manual-journal-entries.view') href='"+row.journal_url+"' @endcan target='_blank'>"+row.display_code+"</a></br>";
                        }
                        return result;
                    }
                },
                {"data": "description","fnCreatedCell": function (nTd, sData, oData, iRow, iCol) {

                        $(nTd).empty();
                        if(oData.description){
                            var truncated = oData.description.length > 40 ? oData.description.substring(0, 40) + '...' : oData.description;
                            $(nTd).append($('<span>', {text: truncated, title: oData.description, 'data-toggle': 'tooltip', 'data-placement': 'top'}));
                        }
                        else if(oData.memo){
                            var truncatedMemo = oData.memo.length > 40 ? oData.memo.substring(0, 40) + '...' : oData.memo;
                            $(nTd).append($('<span>', {text: truncatedMemo, title: oData.memo, 'data-toggle': 'tooltip', 'data-placement': 'top'}));
                        }
                    }
                },
                {
                "data": "",
                "defaultContent": "",
                "render": function(data, type, row, meta){
                if(type === 'display'){
                    var result = '';
                    jQuery.each(row.journalRecords, function(index, item) {
                        var account = item.account;
                        if(account){
                            result += "<a href='"+item.account_url+"' target='_blank'>"+item.account_name+"</a></br>";
                        }else{
                            result += "  </br>";
                        }
                    });
                }
                return result;
                    }
                },
                {
                "data": "",
                "defaultContent": "",
                "render": function(data, type, row, meta){
                        if(type === 'display'){
                            var result = '';
                            jQuery.each(row.journalRecords, function(index, item) {
                                if(item.user){
                                    result += item.user + "</br>";
                                }else{
                                    result += " </br>"
                                }

                            });
                            result += "{{__('reports::reports.total')}}";
                        }
                        return result;
                        }
                },
                {"data": "",
                "defaultContent": "",
                "render": function(data, type, row, meta){
                        if(type === 'display'){
                            var result = '';
                            jQuery.each(row.journalRecords, function(index, item) {
                                if(item.debit){
                                    result += parseFloat(item.debit).toFixed(2).replace(/\B(?=(\d{3})+(?!\d))/g, ',') + "</br>";
                                }else{
                                    result += " </br>"
                                }

                            });
                            result += row.totalDebit;
                        }
                        return result;
                        }
                },
                {"data": "",
                "defaultContent": "",
                "render": function(data, type, row, meta){
                        if(type === 'display'){
                            var result = '';
                            jQuery.each(row.journalRecords, function(index, item) {
                                if(item.credit){
                                    result += parseFloat(item.credit).toFixed(2).replace(/\B(?=(\d{3})+(?!\d))/g, ',') + "</br>";
                                }else{
                                    result += " </br>"
                                }

                            });
                            result += row.totalCredit;
                        }
                        return result;
                        }
                }

                ],
                createdRow: function(row, data, dataIndex){
                    $(row).addClass('lastRow');
                },
                "columnDefs": [
                    {
                        "orderable": false,
                        "searchable": false,
                        "targets": [1,2,3,4,5,6,7]
                    }
                ],
                @if (App::isLocale('ar'))
                language: {
                "url": "https://cdn.datatables.net/plug-ins/9dcbecd42ad/i18n/Arabic.json"
                },
                @endif
            });
            @endif

        });

    });
</script>
@endsection