@extends('admin.layout.app')

@section('body')
    <div class="container">

        {{-- Header + Actions --}}
        <div class="d-flex justify-content-between align-items-center mb-3">
            <h4 class="mb-0"><i class="fas fa-handshake me-2"></i>Company Dealings</h4>
            <div class="d-flex gap-2">
                {{-- Export Dropdown (ADDED) --}}
                <div class="dropdown">
                    <button class="btn btn-outline-secondary dropdown-toggle" type="button" data-bs-toggle="dropdown"
                        aria-expanded="false">
                        <i class="fas fa-file-export me-2"></i>Export
                    </button>
                    <ul class="dropdown-menu dropdown-menu-end">
                        <li><a class="dropdown-item" href="javascript:void(0)" id="exportExcel">
                                <i class="fas fa-file-excel me-2 text-success"></i> Export Excel
                            </a></li>
                        <li><a class="dropdown-item" href="javascript:void(0)" id="exportCSV">
                                <i class="fas fa-file-csv me-2 text-info"></i> Export CSV
                            </a></li>
                        <li><a class="dropdown-item" href="javascript:void(0)" id="exportPDF">
                                <i class="fas fa-file-pdf me-2 text-danger"></i> Export PDF
                            </a></li>
                    </ul>
                </div>

                <button class="btn btn-outline-dark" onclick="window.print()" data-mdb-ripple="true">
                    <i class="fas fa-print me-2"></i>Print
                </button>
                <a href="{{ route('company-dealings.create') }}" class="btn btn-primary" data-mdb-ripple="true">
                    <i class="fas fa-plus me-2"></i>New Dealing
                </a>
            </div>
        </div>

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

        {{-- Filters / Search --}}
        <div class="card shadow-sm mb-3">
            <div class="card-body">
                <form class="row gy-2 gx-2 align-items-end">
                    <div class="col-md-3">
                        <label class="form-label mb-0">Search</label>
                        <input type="text" class="form-control" name="q" value="{{ $q }}"
                            placeholder="Notes, amount, company...">
                    </div>
                    <div class="col-md-3">
                        <label class="form-label mb-0">Company</label>
                        <select name="company_id" class="form-select">
                            <option value="">All</option>
                            @foreach ($companies as $c)
                                <option value="{{ $c->id }}" >{{ $c->name }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                    {{-- <div class="col-md-3">
                        <label class="form-label mb-0">Counterparty</label>
                        <select name="counterparty_company_id" class="form-select">
                            <option value="">All</option>
                            @foreach ($companies as $c)
                                <option value="{{ $c->id }}" @selected($counter == $c->id)>{{ $c->name }}
                                </option>
                            @endforeach
                        </select>
                    </div> --}}
                    <div class="col-md-2">
                        <label class="form-label mb-0">From</label>
                        <input type="date" class="form-control" name="from" value="{{ $from }}">
                    </div>
                    <div class="col-md-2">
                        <label class="form-label mb-0">To</label>
                        <input type="date" class="form-control" name="to" value="{{ $to }}">
                    </div>
                    <div class="col-md-1">
                        <button class="btn btn-outline-secondary w-100"><i class="fas fa-search"></i></button>
                    </div>
                </form>
            </div>
        </div>

        {{-- Reporting --}}
        <div class="row g-3 mb-3">
            <div class="col-md-4">
                <div class="card border-0 shadow-sm">
                    <div class="card-body d-flex justify-content-between align-items-center">
                        <div>
                            <div class="text-muted small">Total Amount (filtered)</div>
                            <div class="fs-5 fw-semibold">{{ number_format($reportTotal, 2) }}</div>
                        </div>
                        <i class="fas fa-chart-line fa-lg text-primary"></i>
                    </div>
                </div>
            </div>
        </div>

        {{-- Table --}}
        <div class="card shadow-sm">
            <div class="table-responsive">
                <table id="dealingsTable" class="table table-hover align-middle mb-0">
                    <thead class="table-light">
                        <tr>
                            <th>#</th>
                            <th>Deal Date</th>
                            <th>Company</th>
                            <th class="text-end">Amount</th>
                            <th>Notes</th>

                            <th class="text-end">Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($dealings as $i => $d)
                            @php
                                $files = json_decode($d->attachment_document ?? '[]', true) ?: [];
                            @endphp
                            <tr>
                                <td>{{ $dealings->firstItem() + $i }}</td>
                                <td>{{ optional($d->deal_date)->format('Y-m-d') }}</td>
                                <td>{{ optional($d->company)->name }}</td>
                                <td class="text-end">{{ number_format($d->amount, 2) }}</td>
                                <td>{{ \Illuminate\Support\Str::limit($d->notes, 60) }}</td>


                                <td class="text-end">
                                    <a class="btn btn-sm btn-outline-info"
                                        href="{{ route('company-dealings.show', $d) }}">
                                        <i class="far fa-eye"></i>
                                    </a>
                                    <a class="btn btn-sm btn-outline-primary"
                                        href="{{ route('company-dealings.edit', $d) }}">
                                        <i class="far fa-edit"></i>
                                    </a>
                                    <form action="{{ route('company-dealings.destroy', $d) }}" method="POST"
                                        class="d-inline" onsubmit="return confirm('Delete this dealing?');">
                                        @csrf @method('DELETE')
                                        <button class="btn btn-sm btn-outline-danger">
                                            <i class="far fa-trash-alt"></i>
                                        </button>
                                    </form>
                                </td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="8" class="text-center p-4">No dealings found.</td>
                            </tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
            @if ($dealings->hasPages())
                <div class="card-footer">
                    {{ $dealings->links() }}
                </div>
            @endif
        </div>
    </div>

    {{-- Print styles (hide buttons etc.) --}}
    <style>
        @media print {

            a.btn,
            button,
            form[action*="company-dealings"],
            .card .card-footer,
            .card .card-body form,
            .dropdown {
                display: none !important;
            }

            .table {
                font-size: 12px;
            }
        }
    </style>

    {{-- Export libs --}}
    <script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/2.5.1/jspdf.umd.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf-autotable/3.5.28/jspdf.plugin.autotable.min.js"></script>

    <script>
        /**
         * پاکه کاپي د Export لپاره:
         *  - clone د جدول
         *  - یوازې ښکاره قطارونه
         *  - د «Actions» وروستی ستون لیرې کول
         *  - Amount نورمالول چې عدد شي
         *  - (Attachments همغسې پرېښودل شوي — لکه څنګه چې ستا په جدول کې دي)
         */
        function getCleanDealingsTable() {
            const src = document.getElementById('dealingsTable');
            const clone = src.cloneNode(true);

            // Remove last header cell (Actions)
            if (clone.tHead && clone.tHead.rows.length) {
                const headCells = clone.tHead.rows[0].cells;
                if (headCells.length) headCells[headCells.length - 1].remove();
            }

            // Body rows
            if (clone.tBodies.length) {
                const rows = Array.from(clone.tBodies[0].rows);
                rows.forEach(r => {
                    // only visible
                    const hidden = r.style.display === 'none' || r.classList.contains('d-none');
                    if (hidden) {
                        r.remove();
                        return;
                    }

                    // remove last td (Actions)
                    if (r.cells.length) r.cells[r.cells.length - 1].remove();

                    // normalize amount (index 4)
                    const idxAmount = 4;
                    if (r.cells[idxAmount]) {
                        const raw = r.cells[idxAmount].textContent.replace(/[,\s]/g, '');
                        const n = parseFloat(raw);
                        if (!isNaN(n)) r.cells[idxAmount].textContent = n.toFixed(2);
                        r.cells[idxAmount].classList.remove('text-end');
                    }
                });
            }
            return clone;
        }

        // Excel
        document.getElementById('exportExcel').addEventListener('click', function() {
            const clean = getCleanDealingsTable();
            const wb = XLSX.utils.table_to_book(clean, {
                sheet: 'Dealings',
                raw: true
            });
            XLSX.writeFile(wb, 'company_dealings.xlsx');
        });

        // CSV
        document.getElementById('exportCSV').addEventListener('click', function() {
            const clean = getCleanDealingsTable();
            const ws = XLSX.utils.table_to_sheet(clean, {
                raw: true
            });
            const wb = XLSX.utils.book_new();
            XLSX.utils.book_append_sheet(wb, ws, 'Dealings');
            XLSX.writeFile(wb, 'company_dealings.csv', {
                bookType: 'csv'
            });
        });

        // PDF
        document.getElementById('exportPDF').addEventListener('click', function() {
            const {
                jsPDF
            } = window.jspdf;
            const doc = new jsPDF('l', 'pt', 'a4'); // landscape
            doc.setFontSize(14);
            doc.text('Company Dealings', 40, 40);

            const clean = getCleanDealingsTable();
            doc.autoTable({
                html: clean,
                startY: 60,
                styles: {
                    fontSize: 9,
                    cellPadding: 4
                },
                headStyles: {
                    fillColor: [245, 245, 245]
                },
                theme: 'striped',
                margin: {
                    left: 40,
                    right: 40
                }
            });
            doc.save('company_dealings.pdf');
        });
    </script>
@endsection