@extends('admin.layouts.app')

@section('content')
    <div class="container-fluid">
        <div class="row">
            <div class="col-12">
                <div class="report-card">
                    <!-- Print Header -->
                    <div class="card no-print mb-4">
                        <div class="card-body">
                            <div class="d-flex justify-content-between align-items-center">
                                <h4 class="mb-0">दीर्घकालीन उत्पादन प्रतिवेदन (Long Term Products Report)</h4>
                                <div>
                                    <button onclick="window.print()" class="btn btn-warning">
                                        <i class="fas fa-print"></i> प्रिन्ट गर्नुहोस्
                                    </button>
                                    <a href="{{ route('panel.jinsi-forms.index') }}" class="btn btn-secondary">
                                        <i class="fas fa-arrow-left"></i> फर्कनुहोस्
                                    </a>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Printable Report -->
                    <div class="card printable-document">
                        <div class="card-body p-0">
                            <div class="report-container"
                                style="padding: 20px; font-family: 'Times New Roman', Arial, sans-serif;">

                                @foreach($groupedProducts as $productName => $productGroup)
                                    <!-- Each product group gets its own page when printed -->
                                    <div class="product-page" style="{{ !$loop->first ? 'page-break-before: always;' : '' }}">
                                        <!-- Header Section -->
                                        <div style="display: flex; align-items: flex-start; margin-bottom: 20px;">
                                            <!-- Left: Logo -->
                                            <div style="width: 20%;">
                                                <div
                                                    style="border: 2px solid #000; padding: 8px; text-align: center; display: inline-block;">
                                                    <div style="font-size: 11px; font-weight: bold;">नेपाल सरकार</div>
                                                    <div style="font-size: 11px; font-weight: bold;">प्रदेश सरकार</div>
                                                    <div style="font-size: 10px;">स्थानीय सरकारको छाप</div>
                                                </div>
                                            </div>

                                            <!-- Center: Title -->
                                            <div style="width: 60%; text-align: center;">
                                                <div style="font-size: 14px; font-weight: bold;">सङ्घ/ प्रदेश / स्थानीय तह</div>
                                                <div style="font-size: 13px; font-weight: bold;">२ नं वडा कार्यालय</div>
                                                <div style="font-size: 10px;">कार्यालय कोड नं.: ........</div>
                                                <div
                                                    style="font-size: 16px; font-weight: bold; margin-top: 10px; text-decoration: underline;">
                                                   सम्पति खाता ( खर्च भएर नजाने )
                                                </div>
                                            </div>

                                            <!-- Right: Report Info -->
                                            <div style="width: 20%; text-align: right;">
                                                <div style="font-size: 11px;">फाराम नं: ४०८ - म.ले.प.</div>
                                            </div>
                                        </div>

                                        <!-- Product Information Section -->
                                        <div style="margin-bottom: 20px; padding: 10px; border: 1px solid #ddd; background: #f9f9f9;">
                                            <div class="row">
                                                <div class="col-6">
                                                    <table style="width: 100%; font-size: 11px;">
                                                        <tr>
                                                            <td width="30%"><strong>जिन्सी मालसामानकाे नाम :</strong></td>
                                                            <td width="70%"><strong>{{ $productName }}</strong></td>
                                                        </tr>
                                                        <tr>
                                                            <td><strong>एकाइ :</strong></td>
                                                            <td>{{ $productGroup['unit'] }}</td>
                                                        </tr>
                                                        <tr>
                                                            <td><strong>स्पेसिफिकेसन :</strong></td>
                                                            <td>{{ $productGroup['specification'] ?? ''}}</td>
                                                        </tr>
                                                    </table>
                                                </div>
                                                <div class="col-6">
                                                    <table style="width: 100%; font-size: 11px;">
                                                        <tr>
                                                            <td width="20%"><strong>आर्थिक वर्ष :</strong></td>
                                                            <td width="80%" class="nepali-input">{{ $fiscal_year ?? '२०८१/८२' }}</td>
                                                        </tr>
                                                        <tr>
                                                            <td><strong>सङकेत नं :</strong></td>
                                                            <td></td>
                                                        </tr>
                                                    </table>
                                                </div>
                                            </div>
                                        </div>

                                        <!-- Products Table for this group -->
                                        <div style="overflow-x: auto; margin-bottom: 30px;">
                                            <table class="report-table"
                                                style="width: 100%; border-collapse: collapse; font-size: 10px;">
                                                <thead>
                                                    <tr>
                                                        <th rowspan="2" style="border: 1px solid #000; vertical-align: middle; width: 5%;">
                                                            क्र.स.
                                                        </th>
                                                        <th rowspan="2" style="border: 1px solid #000; vertical-align: middle; width: 12%;">
                                                            मिति
                                                        </th>
                                                        <th rowspan="2" style="border: 1px solid #000; vertical-align: middle; width: 12%;">
                                                            दाखिला/निकासा फाराम नं
                                                        </th>
                                                        <th colspan="3" style="border: 1px solid #000; text-align:center;">गत आ व काे बाँकी</th>
                                                        <th colspan="3" style="border: 1px solid #000; text-align:center;">स्टाेर दाखिला</th>
                                                        <th colspan="3" style="border: 1px solid #000; text-align:center;">निकासा</th>
                                                        <th colspan="3" style="border: 1px solid #000; text-align:center;">बाँकी</th>
                                                        <th rowspan="2" style="border: 1px solid #000; vertical-align: middle; width: 10%;">
                                                            कैफियत
                                                        </th>
                                                    </tr>
                                                    <tr>
                                                        <th style="border: 1px solid #000;">परिमाण.</th>
                                                        <th style="border: 1px solid #000;">दर</th>
                                                        <th style="border: 1px solid #000;">रकम</th>
                                                        <th style="border: 1px solid #000;">परिमाण.</th>
                                                        <th style="border: 1px solid #000;">दर</th>
                                                        <th style="border: 1px solid #000;">रकम</th>
                                                        <th style="border: 1px solid #000;">परिमाण.</th>
                                                        <th style="border: 1px solid #000;">दर</th>
                                                        <th style="border: 1px solid #000;">रकम</th>
                                                        <th style="border: 1px solid #000;">परिमाण.</th>
                                                        <th style="border: 1px solid #000;">दर</th>
                                                        <th style="border: 1px solid #000;">रकम</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    @forelse($productGroup['entries'] as $index => $product)
                                                        @php
                                                            // Get related products
                                                            $jinsiFormProduct = $product;
                                                            $kharidProduct = $product->kharidFormProduct;
                                                            $maagProduct = $kharidProduct ? $kharidProduct->maagFormProduct : null;
                                                            $jinsiForm = $product->jinsiForm;

                                                            // Data for गत आ व काे बाँकी (from maagFormProduct)
                                                            $maagQty = $maagProduct ? $maagProduct->qty : 0;
                                                            $maagRate = $kharidProduct ? $kharidProduct->amount : 0;
                                                            $maagAmount = $kharidProduct ? $kharidProduct->total : 0;

                                                            // Data for स्टाेर दाखिला (Store Receipt - same as previous for now)
                                                            $storeQty = $maagQty;
                                                            $storeRate = $maagRate;
                                                            $storeAmount = $maagAmount;

                                                            // Data for निकासा (Issued from Jinsi Form Product)
                                                            $issuedQty = $jinsiFormProduct ? $jinsiFormProduct->qty : 0;
                                                            $issuedRate = $jinsiFormProduct ? $jinsiFormProduct->amount : 0;
                                                            $issuedAmount = $jinsiFormProduct ? $jinsiFormProduct->total : 0;

                                                            // Data for बाँकी (Remaining Quantity)
                                                            $remainingQty = $jinsiFormProduct ? $jinsiFormProduct->remaining_qty : 0;
                                                            $remainingRate = $jinsiFormProduct ? $jinsiFormProduct->amount : 0;
                                                            $remainingAmount = $jinsiFormProduct ? ($jinsiFormProduct->amount * $remainingQty) : 0;

                                                            $rowColor = $index % 2 == 0 ? '#ffffff' : '#f9f9f9';
                                                            $entryDate = $jinsiForm && $jinsiForm->entry_date ? \Carbon\Carbon::parse($jinsiForm->entry_date)->format('Y-m-d') : 'N/A';
                                                        @endphp
                                                        <tr style="background-color: {{ $rowColor }};">
                                                            <td style="border: 1px solid #000; padding: 6px; text-align: center;">
                                                                {{ $loop->iteration }}
                                                            </td>
                                                            <td style="border: 1px solid #000; padding: 6px;">
                                                                {{ $entryDate }}
                                                            </td>
                                                            <td style="border: 1px solid #000; padding: 6px; font-size: 9px;">
                                                                जिन्सी: {{ $jinsiForm->id_no ?? 'N/A' }}<br>
                                                                खरिद: {{ $kharidProduct->kharidForm->id_no ?? 'N/A' }}
                                                            </td>

                                                            <!-- गत आ व काे बाँकी -->
                                                            <td style="border: 1px solid #000; padding: 6px; text-align: right;">
                                                                {{ number_format($maagQty, 2) }}
                                                            </td>
                                                            <td style="border: 1px solid #000; padding: 6px; text-align: right;">
                                                                {{ number_format($maagRate, 2) }}
                                                            </td>
                                                            <td style="border: 1px solid #000; padding: 6px; text-align: right;">
                                                                {{ number_format($maagAmount, 2) }}
                                                            </td>

                                                            <!-- स्टाेर दाखिला -->
                                                            <td style="border: 1px solid #000; padding: 6px; text-align: right;">
                                                                {{ number_format($storeQty, 2) }}
                                                            </td>
                                                            <td style="border: 1px solid #000; padding: 6px; text-align: right;">
                                                                {{ number_format($storeRate, 2) }}
                                                            </td>
                                                            <td style="border: 1px solid #000; padding: 6px; text-align: right;">
                                                                {{ number_format($storeAmount, 2) }}
                                                            </td>

                                                            <!-- निकासा -->
                                                            <td style="border: 1px solid #000; padding: 6px; text-align: right;">
                                                                {{ number_format($issuedQty, 2) }}
                                                            </td>
                                                            <td style="border: 1px solid #000; padding: 6px; text-align: right;">
                                                                {{ number_format($issuedRate, 2) }}
                                                            </td>
                                                            <td style="border: 1px solid #000; padding: 6px; text-align: right;">
                                                                {{ number_format($issuedAmount, 2) }}
                                                            </td>

                                                            <!-- बाँकी -->
                                                            <td style="border: 1px solid #000; padding: 6px; text-align: right;">
                                                                {{ number_format($remainingQty, 2) }}
                                                            </td>
                                                            <td style="border: 1px solid #000; padding: 6px; text-align: right;">
                                                                {{ number_format($remainingRate, 2) }}
                                                            </td>
                                                            <td style="border: 1px solid #000; padding: 6px; text-align: right;">
                                                                {{ number_format($remainingAmount, 2) }}
                                                            </td>

                                                            <td style="border: 1px solid #000; padding: 6px;">
                                                                {{ $product->remarks ?? '-' }}
                                                            </td>
                                                        </tr>
                                                    @empty
                                                        <tr>
                                                            <td colspan="16"
                                                                style="border: 1px solid #000; padding: 20px; text-align: center; color: #999;">
                                                                <strong>कुनै दीर्घकालीन उत्पादनहरू छैनन्</strong><br>
                                                                No long-term products found
                                                            </td>
                                                        </tr>
                                                    @endforelse
                                                </tbody>
                                                <tfoot>
                                                    <tr style="font-weight: bold;">
                                                        <td colspan="3"
                                                            style="border: 1px solid #000; padding: 8px; text-align: right;">
                                                            <strong>जम्मा (Total):</strong>
                                                        </td>
                                                        <td style="border: 1px solid #000; padding: 8px; text-align: right;">
                                                            <strong>{{ number_format(collect($productGroup['entries'])->sum(function($p) { return $p->kharidFormProduct->maagFormProduct->qty ?? 0; }), 2) }}</strong>
                                                        </td>
                                                        <td style="border: 1px solid #000; padding: 8px;"></td>
                                                        <td style="border: 1px solid #000; padding: 8px; text-align: right;">
                                                            <strong>{{ number_format(collect($productGroup['entries'])->sum(function($p) { return $p->kharidFormProduct->total ?? 0; }), 2) }}</strong>
                                                        </td>
                                                        <td style="border: 1px solid #000; padding: 8px; text-align: right;">
                                                            <strong>{{ number_format(collect($productGroup['entries'])->sum(function($p) { return $p->kharidFormProduct->maagFormProduct->qty ?? 0; }), 2) }}</strong>
                                                        </td>
                                                        <td style="border: 1px solid #000; padding: 8px;"></td>
                                                        <td style="border: 1px solid #000; padding: 8px; text-align: right;">
                                                            <strong>{{ number_format(collect($productGroup['entries'])->sum(function($p) { return $p->kharidFormProduct->total ?? 0; }), 2) }}</strong>
                                                        </td>
                                                        <td style="border: 1px solid #000; padding: 8px; text-align: right;">
                                                            <strong>{{ number_format(collect($productGroup['entries'])->sum('qty'), 2) }}</strong>
                                                        </td>
                                                        <td style="border: 1px solid #000; padding: 8px;"></td>
                                                        <td style="border: 1px solid #000; padding: 8px; text-align: right;">
                                                            <strong>{{ number_format(collect($productGroup['entries'])->sum('total'), 2) }}</strong>
                                                        </td>
                                                        <td style="border: 1px solid #000; padding: 8px; text-align: right;">
                                                            <strong>{{ number_format(collect($productGroup['entries'])->sum('remaining_qty'), 2) }}</strong>
                                                        </td>
                                                        <td style="border: 1px solid #000; padding: 8px;"></td>
                                                        <td style="border: 1px solid #000; padding: 8px; text-align: right;">
                                                            <strong>{{ number_format(collect($productGroup['entries'])->sum(function($p) { return $p->remaining_qty * $p->amount; }), 2) }}</strong>
                                                        </td>
                                                        <td style="border: 1px solid #000; padding: 8px;"></td>
                                                    </tr>
                                                </tfoot>
                                            </table>
                                        </div>
                                    </div>
                                @endforeach
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <style>
        @media print {
            .no-print,
            .no-print * {
                display: none !important;
            }

            body {
                background: white;
                margin: 0;
                padding: 0;
            }

            .printable-document {
                position: absolute;
                left: 0;
                top: 0;
                width: 100%;
                border: none;
                margin: 0;
                padding: 0;
            }

            @page {
                size: A4 landscape;
                margin: 10mm 8mm;
            }

            .report-table td,
            .report-table th {
                border: 1px solid #000 !important;
            }

            .report-table tr {
                page-break-inside: avoid;
            }

            .report-container {
                padding: 0 !important;
            }

            /* Force each product page to start on a new page */
            .product-page {
                page-break-before: auto;
            }

            .product-page:not(:first-child) {
                page-break-before: always;
            }
        }

        @media screen {
            .report-container {
                max-width: 100%;
                overflow-x: auto;
                box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);
            }

            .printable-document {
                margin-bottom: 20px;
            }

            /* Add visual separation between products on screen */
            .product-page:not(:last-child) {
                margin-bottom: 40px;
                border-bottom: 2px dashed #ccc;
                padding-bottom: 20px;
            }
        }

        .report-table {
            width: 100%;
            border-collapse: collapse;
        }

        .report-table th,
        .report-table td {
            border: 1px solid #ddd;
            padding: 8px;
        }

        .report-table th {
            font-weight: bold;
        }

        .report-table tr:hover {
            background-color: #f5f5f5;
        }
    </style>
@endsection