@extends('layouts.portal')

@section('title', __('Chart of Accounts'))

@push('styles')
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
    <link href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.10.5/font/bootstrap-icons.css" rel="stylesheet">
    <style>
        .account-tools > summary,
        .account-import > summary {
            cursor: pointer;
            list-style-position: inside;
        }

        #account-editor {
            width: min(640px, calc(100vw - 2rem));
            max-width: none;
            max-height: calc(100vh - 2rem);
            margin: auto;
            padding: 0;
            overflow-y: auto;
            border: 0;
            border-radius: .5rem;
            box-shadow: 0 1rem 3rem rgb(0 0 0 / 25%);
        }

        #account-editor::backdrop {
            background: rgb(0 0 0 / 55%);
        }

        .account-grid-wrap {
            max-height: 70vh;
            overflow: auto;
            border-top: 1px solid #c8d0c9;
        }

        .account-table {
            width: 100%;
            min-width: 960px;
            margin: 0;
            border-collapse: separate;
            border-spacing: 0;
            font-family: Consolas, "Cascadia Mono", "Segoe UI", monospace;
            font-size: 12px;
            line-height: 1.2;
        }

        .account-table th,
        .account-table td {
            padding: 3px 8px;
            border-right: 1px solid #d5dbd6;
            border-bottom: 1px solid #d5dbd6;
            background: #fff;
            white-space: nowrap;
            vertical-align: middle;
        }

        .account-table thead th {
            position: sticky;
            top: 0;
            z-index: 2;
            background: #e9eee9;
            border-bottom: 2px solid #9fb0a5;
            font-size: 11px;
            font-weight: 700;
            text-transform: uppercase;
            letter-spacing: .03em;
            user-select: none;
        }

        .account-table thead th a { color: inherit; text-decoration: none; }
        .account-table thead th a:hover { text-decoration: underline; }

        .account-table td.row-number,
        .account-table th.row-number {
            background: #e9eee9;
            color: #64756d;
            text-align: right;
            font-size: 11px;
        }

        .account-table td.cell-name { width: 100%; white-space: normal; min-width: 220px; }
        .account-table td.cell-flag { text-align: center; }
        .account-table td.cell-flag.is-yes { color: #146c43; font-weight: 700; }
        .account-table td.cell-flag.is-no { color: #9aa6a0; }
        .account-table td.cell-actions { padding: 1px 6px; text-align: right; }
        .account-table td.cell-actions .btn { padding: 0 6px; font-size: 12px; line-height: 1.6; border-color: transparent; }
        .account-table td.cell-actions .btn:hover { border-color: currentColor; }

        .account-table tbody tr:hover td { background: #f3f7d9; }
        .account-table tbody tr:hover td.row-number { background: #dde5de; }
        .account-table tbody tr.is-inactive td { color: #8a948e; background: #f6f6f4; text-decoration: line-through; text-decoration-color: #c4cbc6; }
        .account-table tbody tr.is-inactive td.cell-actions { text-decoration: none; }
        .account-table tbody tr.is-selected td { background: #dcebfa; }
        .account-table tbody tr.is-selected td.row-number { background: #bcd6f0; }
        .account-table input[type="checkbox"] { margin: 0; vertical-align: middle; }    </style>
@endpush

@section('content')
<div class="portal-page">
    @include('partials.portal-header')

    <main class="module-main">
        <div class="container py-4">
            <header class="mb-4">
                <h1 class="h3">{{ __('Chart of Accounts Management') }}</h1>
                <p class="text-muted">{{ __('Accounting Module — SouthCal Cleaners') }}</p>
            </header>

            @if(session('success'))
                <div class="alert alert-success">{{ session('success') }}</div>
            @endif

            @if ($errors->any())
                <div class="alert alert-danger">
                    <ul class="mb-0">
                        @foreach ($errors->all() as $error)
                            <li>{{ $error }}</li>
                        @endforeach
                    </ul>
                </div>
            @endif

            @php
                $importResult = session('import_result');
            @endphp
            @if($importResult)
                <div class="alert {{ $importResult['skipped'] > 0 ? 'alert-warning' : 'alert-success' }}" role="status">
                    {{ __('Catalog import finished: :imported imported, :skipped skipped.', [
                        'imported' => $importResult['imported'],
                        'skipped' => $importResult['skipped'],
                    ]) }}
                </div>
                @if($importResult['errors'] !== [])
                    <div class="table-responsive mb-4">
                        <table class="table table-sm table-bordered">
                            <thead>
                                <tr>
                                    <th>{{ __('Spreadsheet row') }}</th>
                                    <th>{{ __('Code') }}</th>
                                    <th>{{ __('Reason not imported') }}</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach($importResult['errors'] as $importError)
                                    <tr>
                                        <td>{{ $importError['row'] }}</td>
                                        <td>{{ $importError['code'] ?: '—' }}</td>
                                        <td>{{ $importError['message'] }}</td>
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                @endif
            @endif

            @php
                $nextDir = ($direction === 'asc') ? 'desc' : 'asc';
            @endphp

        <!-- Accounts Table -->
        <div class="w-100">
            <div class="card shadow-sm">
                <div class="card-header bg-secondary text-white d-flex flex-wrap justify-content-between align-items-center gap-2">
                    <div class="d-flex align-items-center gap-3">
                        <h5 class="card-title mb-0">{{ __('All Accounts') }}</h5>
                        <span class="badge bg-light text-dark">{{ trans_choice(':count item|:count items', count($subaccounts), ['count' => count($subaccounts)]) }}</span>
                    </div>
                    <button type="button" class="btn btn-sm btn-light" id="add-account-button" aria-haspopup="dialog" aria-controls="account-editor">
                        <i class="bi bi-plus-lg" aria-hidden="true"></i>
                        {{ __('Add New Account') }}
                    </button>
                </div>
                <div class="px-3 pt-3 text-muted small">
                    {{ __('Unreferenced accounts are permanently deleted. Referenced accounts are deactivated instead.') }}
                </div>
                <div class="card-body p-0">
                    <div class="account-grid-wrap">
                        <table class="account-table">
                            <thead>
                                <tr>
                                    <th class="text-center">
                                        <input class="form-check-input" id="select-all-accounts" type="checkbox" aria-label="{{ __('Select all accounts') }}">
                                    </th>
                                    <th class="row-number">{{ __('No.') }}</th>
                                    <th><a href="{{ route('accounting.accounts.index', ['sort' => 'code', 'direction' => $nextDir]) }}" class="text-decoration-none text-dark">{{ __('Code') }}</a></th>
                                    <th><a href="{{ route('accounting.accounts.index', ['sort' => 'name', 'direction' => $nextDir]) }}" class="text-decoration-none text-dark">{{ __('Name') }}</a></th>
                                    <th><a href="{{ route('accounting.accounts.index', ['sort' => 'type', 'direction' => $nextDir]) }}" class="text-decoration-none text-dark">{{ __('Type') }}</a></th>
                                    <th><a href="{{ route('accounting.accounts.index', ['sort' => 'parent_name', 'direction' => $nextDir]) }}" class="text-decoration-none text-dark">{{ __('Parent') }}</a></th>
                                    <th>{{ __('Posting') }}</th>
                                    <th>{{ __('User Assoc.') }}</th>
                                    <th>{{ __('Stock Assoc.') }}</th>
                                    <th>{{ __('Status') }}</th>
                                    <th class="text-end">{{ __('Actions') }}</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($subaccounts as $acc)
                                    <tr @class(['is-inactive' => ! $acc->is_active])>
                                        <td class="text-center">
                                            <input class="form-check-input account-selection" type="checkbox" name="account_ids[]" value="{{ $acc->id }}" form="account-export-form" data-account-selection aria-label="{{ __('Select account #:code', ['code' => $acc->code]) }}">
                                        </td>
                                        <td class="row-number">{{ $loop->iteration }}</td>
                                        <td>{{ $acc->code }}</td>
                                        <td class="cell-name">{{ $acc->name }}</td>
                                        <td>{{ $acc->type }}</td>
                                        <td>{{ $acc->parent_name ?? __('Root Level') }}</td>
                                        <td @class(['cell-flag', 'is-yes' => $acc->is_posting, 'is-no' => ! $acc->is_posting]) title="{{ $acc->is_posting ? __('Yes') : __('No') }}">{{ $acc->is_posting ? '✓' : '–' }}</td>
                                        <td @class(['cell-flag', 'is-yes' => $acc->is_user_associated, 'is-no' => ! $acc->is_user_associated]) title="{{ $acc->is_user_associated ? __('Yes') : __('No') }}">{{ $acc->is_user_associated ? '✓' : '–' }}</td>
                                        <td @class(['cell-flag', 'is-yes' => $acc->is_stock_associated, 'is-no' => ! $acc->is_stock_associated]) title="{{ $acc->is_stock_associated ? __('Yes') : __('No') }}">{{ $acc->is_stock_associated ? '✓' : '–' }}</td>
                                        <td>{{ $acc->is_active ? __('Active') : __('Inactive') }}</td>
                                        <td class="cell-actions">
                                            <a href="{{ route('accounting.accounts.index', ['edit' => $acc->id]) }}" class="btn btn-sm btn-outline-primary" aria-label="{{ __('Edit account #:id', ['id' => $acc->id]) }}">
                                                <i class="bi bi-pencil"></i>
                                            </a>
                                            @if($acc->is_active)
                                                <form action="{{ route('accounting.accounts.destroy', $acc->id) }}" method="POST" class="d-inline" onsubmit="return confirm(this.dataset.confirm)" data-confirm="{{ __('Delete account #:code? If referenced, it will be deactivated instead.', ['code' => $acc->code]) }}">
                                                    @csrf
                                                    @method('DELETE')
                                                    <button type="submit" class="btn btn-sm btn-outline-danger" aria-label="{{ __('Delete account #:code', ['code' => $acc->code]) }}">
                                                        <i class="bi bi-trash"></i>
                                                    </button>
                                                </form>
                                            @else
                                                <form action="{{ route('accounting.accounts.restore', $acc->id) }}" method="POST" class="d-inline">
                                                    @csrf
                                                    @method('PATCH')
                                                    <button type="submit" class="btn btn-sm btn-outline-success" aria-label="{{ __('Reactivate account #:code', ['code' => $acc->code]) }}">
                                                        <i class="bi bi-arrow-counterclockwise"></i>
                                                    </button>
                                                </form>
                                            @endif
                                        </td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="11" class="text-center py-4 text-muted">{{ __('No accounts found.') }}</td>
                                    </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>

                <details class="account-tools card shadow-sm mt-4" id="account-tools">
                    <summary class="card-header">
                        <h2 class="h5 mb-0 d-inline" id="account-tools-heading">{{ __('Account data tools') }}</h2>
                    </summary>
                    <div class="card-body">
                    <div class="row g-3">
                        <div class="col-12 col-xl-7">
                            <details class="account-import card shadow-sm" id="account-import">
                                <summary class="card-header">
                                    <span class="h5 mb-0">{{ __('Import account catalog') }}</span>
                                </summary>
                                <div class="card-body">
                                    <p class="text-muted">{{ __('Upload an Excel workbook (.xlsx) or CSV with required columns code, name, and type. Optionally include parent_code, is_user_associated, is_stock_associated, and is_posting. Boolean values may be t/f, 1/0, or true/false.') }}</p>
                                    <form action="{{ route('accounting.accounts.import') }}" method="POST" enctype="multipart/form-data" class="d-flex flex-wrap align-items-end gap-3">
                                        @csrf
                                        <div>
                                            <label class="form-label" for="catalog-file">{{ __('Catalog file') }}</label>
                                            <input class="form-control" id="catalog-file" name="catalog_file" type="file" accept=".xlsx,.csv" required>
                                        </div>
                                        <button class="btn btn-outline-primary" type="submit">{{ __('Import catalog') }}</button>
                                    </form>
                                    <a class="btn btn-link btn-sm px-0" href="{{ route('accounting.accounts.import.sample') }}"><i class="bi bi-file-earmark-excel" aria-hidden="true"></i> {{ __('Download sample Excel file') }}</a>
                                    <small class="text-muted d-block mt-2">{{ __('Existing account codes are not overwritten. Invalid rows are skipped and listed below.') }}</small>
                                </div>
                            </details>
                        </div>
                        <div class="col-12 col-xl-5">
                            <div class="card shadow-sm h-100">
                                <div class="card-header">
                                    <h3 class="h5 mb-0">{{ __('Export selected accounts') }}</h3>
                                </div>
                                <div class="card-body">
                                    <p class="text-muted">{{ __('Select one or more accounts in the list, choose a format, and export only those accounts.') }}</p>
                                    <form action="{{ route('accounting.accounts.export') }}" method="POST" id="account-export-form" data-skip-unsaved-changes="true" class="d-flex flex-wrap align-items-end gap-3">
                                        @csrf
                                        <div>
                                            <label class="form-label" for="export-format">{{ __('File format') }}</label>
                                            <select class="form-select" id="export-format" name="format" required>
                                                <option value="xlsx">{{ __('Excel workbook (.xlsx)') }}</option>
                                                <option value="csv">{{ __('CSV file (.csv)') }}</option>
                                            </select>
                                        </div>
                                        <button class="btn btn-outline-success" id="export-selected-button" type="submit" disabled>
                                            {{ __('Export selected (:count)', ['count' => 0]) }}
                                        </button>
                                    </form>
                                    <small class="text-muted d-block mt-2">{{ __('The export includes account details and a sequential row number.') }}</small>
                                </div>
                            </div>
                        </div>
                    </div>
                    </div>
                </details>

            <dialog id="account-editor" aria-labelledby="account-editor-title" data-open-on-load="{{ $editAccount || old('code') !== null ? 'true' : 'false' }}">
                <div class="card border-0">
                    <div class="card-header {{ $editAccount ? 'bg-warning text-dark' : 'bg-primary text-white' }} d-flex justify-content-between align-items-center">
                        <h2 class="h5 mb-0" id="account-editor-title">{{ $editAccount ? __('Edit Account #:id', ['id' => $editAccount->id]) : __('Add New Account') }}</h2>
                        <button type="button" class="btn-close" id="close-account-editor" aria-label="{{ __('Close') }}"></button>
                    </div>
                    <div class="card-body">
                        <form action="{{ $editAccount ? route('accounting.accounts.update', $editAccount->id) : route('accounting.accounts.store') }}" method="POST">
                            @csrf
                            @if($editAccount)
                                @method('PUT')
                            @endif

                            <div class="mb-3">
                                <label class="form-label" for="account-code">{{ __('Account Code') }}</label>
                                <input id="account-code" type="text" class="form-control" name="code" value="{{ old('code', $editAccount->code ?? '') }}" placeholder="{{ __('e.g. 6130') }}" required>
                            </div>
                            <div class="mb-3">
                                <label class="form-label" for="account-name">{{ __('Account Name') }}</label>
                                <input id="account-name" type="text" class="form-control" name="name" value="{{ old('name', $editAccount->name ?? '') }}" placeholder="{{ __('e.g. Office Supplies') }}" required>
                            </div>
                            <div class="mb-3">
                                <label class="form-label" for="account-type">{{ __('Account Type') }}</label>
                                <select id="account-type" class="form-select" name="type" required>
                                    @php $currentType = old('type', $editAccount->type ?? 'Expense'); @endphp
                                    @foreach(['Asset', 'Liability', 'Equity', 'Revenue', 'Expense'] as $typeOption)
                                        <option value="{{ $typeOption }}" {{ $currentType === $typeOption ? 'selected' : '' }}>{{ __($typeOption) }}</option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="mb-3">
                                <label class="form-label" for="parent-id">{{ __('Parent Category') }}</label>
                                <select id="parent-id" class="form-select" name="parent_id">
                                    <option value="">{{ __('-- None (Top Level Header) --') }}</option>
                                    @foreach ($parentAccounts as $parent)
                                        @if(!$editAccount || $parent->id !== $editAccount->id)
                                            <option value="{{ $parent->id }}" {{ (old('parent_id', $editAccount->parent_id ?? '') == $parent->id) ? 'selected' : '' }}>
                                                {{ $parent->code }} - {{ $parent->name }}
                                            </option>
                                        @endif
                                    @endforeach
                                </select>
                            </div>
                            <div class="mb-3 form-check">
                                <input type="checkbox" class="form-check-input" id="is_posting" name="is_posting" value="1" {{ old('is_posting', $editAccount->is_posting ?? true) ? 'checked' : '' }}>
                                <label class="form-check-label" for="is_posting">{{ __('Is Posting Account (Leaf)') }}</label>
                            </div>
                            <div class="mb-3 form-check">
                                <input type="checkbox" class="form-check-input" id="is_user_associated" name="is_user_associated" value="1" {{ old('is_user_associated', $editAccount->is_user_associated ?? false) ? 'checked' : '' }}>
                                <label class="form-check-label" for="is_user_associated">{{ __('Is User Associated') }}</label>
                            </div>
                            <div class="mb-3 form-check">
                                <input type="checkbox" class="form-check-input" id="is_stock_associated" name="is_stock_associated" value="1" {{ old('is_stock_associated', $editAccount->is_stock_associated ?? false) ? 'checked' : '' }}>
                                <label class="form-check-label" for="is_stock_associated">{{ __('Is Stock Associated') }}</label>
                            </div>
                            <div class="d-flex justify-content-end gap-2">
                                <button type="button" class="btn btn-outline-secondary" id="cancel-account-editor">{{ __('Cancel') }}</button>
                                <button type="submit" class="btn {{ $editAccount ? 'btn-warning' : 'btn-primary' }}">
                                    {{ $editAccount ? __('Update Account') : __('Save Account') }}
                                </button>
                            </div>
                        </form>
                    </div>
                </div>
            </dialog>
            </div>
        </div>
    </main>
</div>
<script>
    (() => {
        const importDetails = document.getElementById('account-import');
        const toolsDetails = document.getElementById('account-tools');
        const editor = document.getElementById('account-editor');
        const selections = [...document.querySelectorAll('[data-account-selection]')];
        const selectAll = document.getElementById('select-all-accounts');
        const exportButton = document.getElementById('export-selected-button');

        if (importDetails) {
            const storageKey = 'accounting.chart-of-accounts.tools.import-open';

            try {
                importDetails.open = window.localStorage.getItem(storageKey) === 'true';
            } catch (error) {
                console.warn('Unable to restore account import panel state.', error);
            }

            if (selectAll && exportButton) {
                const updateSelection = () => {
                    const selectedCount = selections.filter((checkbox) => checkbox.checked).length;

                    selectAll.checked = selections.length > 0 && selectedCount === selections.length;
                    selectAll.indeterminate = selectedCount > 0 && selectedCount < selections.length;
                    selections.forEach((checkbox) => checkbox.closest('tr').classList.toggle('is-selected', checkbox.checked));
                    exportButton.disabled = selectedCount === 0;
                    exportButton.textContent = @json(__('Export selected (:count)', ['count' => ':count'])).replace(':count', String(selectedCount));
                };

                selectAll.addEventListener('change', () => {
                    selections.forEach((checkbox) => {
                        checkbox.checked = selectAll.checked;
                    });

                    updateSelection();
                });

                selections.forEach((checkbox) => checkbox.addEventListener('change', updateSelection));
                updateSelection();
            }

            importDetails.addEventListener('toggle', () => {
                try {
                    window.localStorage.setItem(storageKey, String(importDetails.open));
                } catch (error) {
                    console.warn('Unable to save account import panel state.', error);
                }
            });
        }

        if (toolsDetails) {
            const storageKey = 'accounting.chart-of-accounts.tools-open';

            try {
                toolsDetails.open = window.localStorage.getItem(storageKey) === 'true';
            } catch (error) {
                console.warn('Unable to restore account data tools panel state.', error);
            }

            toolsDetails.addEventListener('toggle', () => {
                try {
                    window.localStorage.setItem(storageKey, String(toolsDetails.open));
                } catch (error) {
                    console.warn('Unable to save account data tools panel state.', error);
                }
            });
        }

        if (editor) {
            document.getElementById('add-account-button')?.addEventListener('click', () => editor.showModal());
            document.getElementById('close-account-editor')?.addEventListener('click', () => editor.close());
            document.getElementById('cancel-account-editor')?.addEventListener('click', () => editor.close());

            if (editor.dataset.openOnLoad === 'true') {
                editor.showModal();
            }
        }
    })();
</script>
@endsection