@extends('backend.layouts.master')
@section('section-title', 'Stock')
@section('page-title', 'Product Stock')
@section('action-button')
    <a href="" class="btn add_list_btn" onclick="window.print()">Print</a>
    <a href="javascript:void(0)" class="btn add_list_btn" onclick="exportToExcel()">Excel</a>
@endsection

@push('css')
    <style>
        @media print {

            table,
            table th,
            table td {
                color: black !important;
            }

            .h-hide {
                display: none;
            }
        }

        table .table_vari_bg tr {
            background: #000ce2 !important;
            color: rgb(255, 255, 255);
            font-weight: 800;
        }

        /* Style for the main table rows (striped) */
        .table-striped tbody tr:nth-child(odd) {
            background-color: #dcdcdc;
        }

        .table-striped tbody tr:nth-child(even) {
            background-color: #ffffff;
        }

        .table-striped tbody tr:nth-child(odd) table tbody tr {
            background-color: #dcdcdc;
        }

        .table-striped tbody tr:nth-child(even) table tbody tr {
            background-color: #ffffff;
        }

        .table-striped table {
            width: 100%;
            border: 1px solid #ddd;
        }

        .table-striped table th,
        .table-striped table td {
            padding: 5px;
            text-align: left;
        }
    </style>
@endpush

@section('content')
    <div class="row">
        <div class="col-lg-12">
            <div class="card m-b-30 card_style">
                <div class="card-header ">
                    <h4 style="text-align: center; font-weight:bold; margin-top:5px;font-size:30px"><strong>Stock
                            Report</strong></h4>
                    <form action="{{ route('report.stock') }}" method="GET">
                        <div class="row h-hide">
                            <div class="col-md-3 mt-3">
                                <input type="text" class="form-control" id="search_keyword" name="search_keyword"
                                    value="{{ $keyword }}" placeholder="Barcode or Product Name">
                            </div>
                            <div class="col-md-3 mt-3">
                                <select class="select2" name="product_id" id="product_id" data-provide="selectpicker"
                                    data-live-search="true" data-size="10">
                                    <option value="">Select Product</option>
                                    @foreach ($produc as $product)
                                        <option value="{{ $product->id }}"
                                            {{ $product_id == $product->id ? 'SELECTED' : '' }}>
                                            {{ $product->name }}</option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="col-md-3 mt-3">
                                <select name="category_id" id="category_id" class="select2" data-provide="selectpicker"
                                    data-live-search="true" data-size="10">
                                    <option value="">Select Category</option>
                                    @foreach ($categories as $category)
                                        <option value="{{ $category->id }}"
                                            {{ $category_id == $category->id ? 'SELECTED' : '' }}>{{ $category->name }}
                                        </option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="col-md-3 mt-3">
                                <select name="brand_id" id="brand_id" class="select2" data-provide="selectpicker"
                                    data-live-search="true" data-size="10">
                                    <option value="">Select Brand</option>
                                    @foreach ($brands as $brand)
                                        <option value="{{ $brand->id }}" {{ $brand_id == $brand->id ? 'SELECTED' : '' }}>
                                            {{ $brand->name }}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                        <div class="row mt-3 h-hide">
                            <div class="col-md-12 col-12 d-flex justify-content-center">
                                <a href="{{ route('report.stock') }}" class="btn btn-md mx-1 text-white add_list_btn_reset"
                                    id="">Reset</a>
                                <button type="submit" class="btn btn-md add_list_btn mx-1">Filter</button>
                            </div>
                        </div>
                    </form>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-striped text-center" id="stockTable">
                            <thead class="header_bg">
                                <tr>
                                    <th class="header_style_left">#SL</th>
                                    <th>Image</th>
                                    <th style="width: 25%">Product</th>
                                    <th>Category</th>
                                    <th>Stock In</th>
                                    <th>Stock Transfer</th>
                                    <th>Stock Receive</th>
                                    <th>Stock Out</th>
                                    <th>Sale Return</th>
                                    <th>Purchase Return</th>
                                    <th>Damage</th>
                                    <th>Adjust In</th>
                                    <th>Adjust Out</th>
                                    <th class="header_style_right">Available Stock</th>
                                </tr>
                            </thead>
                            <tbody>
                                @php
                                    $row_purchase = 0;
                                    $row_sale = 0;
                                    $row_sale_ret = 0;
                                    $row_pur_ret = 0;
                                    $row_damage = 0;
                                    $row_available = 0;
                                    $row_stock_qty = 0;
                                    $row_adjust_in_total = 0;
                                    $row_adjust_out_total = 0;
                                @endphp
                                @forelse($products as $data)
                                    @php
                                        $purchased_qty = purchased_qty($data);
                                        $invoiced_qty = invoiced_qty($data);
                                        $stock_qty = product_stock($data);
                                        $stock_transfer_qty = stock_transfer_qty($data);
                                        $stock_receive_qty = stock_receive_qty($data);
                                        $returned_qty = returned_qty($data);
                                        $damaged_qty = damaged_qty($data);
                                        $adjust_in = adjust_in($data);
                                        $adjust_out = adjust_out($data);
                                        $return_pur_qty = return_pur_qty($data);

                                        $row_purchase += (float) $purchased_qty;
                                        $row_sale += (float) $invoiced_qty;
                                        $row_sale_ret += (float) $returned_qty;
                                        $row_pur_ret += (float) $return_pur_qty;
                                        $row_damage += (float) $damaged_qty;
                                        $row_adjust_in_total += (float) $adjust_in;
                                        $row_adjust_out_total += (float) $adjust_out;

                                        $row_stock_qty = $row_purchase - $row_sale + $row_sale_ret + $row_adjust_in_total - $row_adjust_out_total - $row_pur_ret - $row_damage;
                                    @endphp
                                    <tr>
                                        <td class="table_data_style_left">{{ $loop->index + 1 }}</td>
                                        <td>
                                            <img src="{{ !empty($data->images) ? url('public/public/uploads/products/' . $data->images) : url('backend/images/no_images.png') }}"
                                                class="img-fluid" style="height: 60px; width: 80px;" alt="product">
                                        </td>
                                        <td>{{ $data->name }} - {{ $data->barcode }}</td>
                                        <td>{{ $data->category->name }}</td>
                                        <td>{{ $purchased_qty }}</td>
                                        <td>{{ $stock_transfer_qty }}</td>
                                        <td>{{ $stock_receive_qty }}</td>
                                        <td>{{ $invoiced_qty }}</td>
                                        <td>{{ $returned_qty }}</td>
                                        <td>{{ $return_pur_qty }}</td>
                                        <td>{{ $damaged_qty }}</td>
                                        <td>{{ $adjust_in }}</td>
                                        <td>{{ $adjust_out }}</td>
                                        <td class="table_data_style_right">
                                            @if ($data->product_variations->count() > 0)
                                                <table>
                                                    <thead class="table_vari_bg">
                                                        <tr>
                                                            <th class="table_data_style_left">Variation</th>
                                                            <th class="table_data_style_right">Stock</th>
                                                        </tr>
                                                    </thead>
                                                    <tbody>
                                                        @php
                                                            $var_total = 0;
                                                        @endphp
                                                        @foreach ($data->product_variations as $variation)
                                                            @php
                                                                $var_total += variation_stock($variation->id);
                                                            @endphp
                                                            <tr>
                                                                <td class="table_data_style_left">
                                                                    {{ $variation->size?->size }} -
                                                                    {{ $variation->color?->color }}</td>
                                                                <td class="table_data_style_right">
                                                                    {{ variation_stock($variation->id) }} Pics
                                                                </td>
                                                            </tr>
                                                        @endforeach
                                                    </tbody>
                                                    <tfoot>
                                                        <tr>
                                                            <td>Total Qty =</td>
                                                            <td>{{ $var_total }} Pics</td>
                                                        </tr>
                                                    </tfoot>
                                                </table>
                                            @else
                                                {{ $stock_qty }}
                                            @endif
                                        </td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="100%" class="text-center text-danger no_data_style">No Data Available
                                        </td>
                                    </tr>
                                @endforelse
                            </tbody>
                            <tfoot>
                                <tr class="header_bg text-white">
                                    <td colspan="3"><strong class="text-white"> Page Total</strong></td>
                                    <td><strong class="text-white">{{ number_format($row_purchase) }}</strong></td>
                                    <td><strong class="text-white">0</strong></td>
                                    <td><strong class="text-white">0</strong></td>
                                    <td><strong class="text-white">{{ number_format($row_sale) }}</strong></td>
                                    <td><strong class="text-white">{{ number_format($row_sale_ret) }}</strong></td>
                                    <td><strong class="text-white">{{ number_format($row_pur_ret) }}</strong></td>
                                    <td><strong class="text-white">{{ number_format($row_damage) }}</strong></td>
                                    <td><strong class="text-white">{{ number_format($row_adjust_in_total) }}</strong></td>
                                    <td><strong class="text-white">{{ number_format($row_adjust_out_total) }}</strong></td>
                                    <td><strong class="text-white">{{ number_format($row_stock_qty) }}</strong></td>
                                </tr>
                                <tr class="header_bg text-white">
                                    <td colspan="3"><strong class="text-white">Total</strong></td>
                                    <td><strong class="text-white">{{ number_format($grand_purchase) }}</strong></td>
                                    <td><strong class="text-white">0</strong></td>
                                    <td><strong class="text-white">0</strong></td>
                                    <td><strong class="text-white">{{ number_format($grand_sale) }}</strong></td>
                                    <td><strong class="text-white">{{ number_format($grand_sale_ret) }}</strong></td>
                                    <td><strong class="text-white">{{ number_format($grand_pur_ret) }}</strong></td>
                                    <td><strong class="text-white">{{ number_format($grand_damage) }}</strong></td>
                                    <td><strong class="text-white">{{ number_format($grand_adjust_in_total) }}</strong></td>
                                    <td><strong class="text-white">{{ number_format($grand_adjust_out_total) }}</strong></td>
                                    <td><strong class="text-white">{{ number_format($grand_stock_qty) }}</strong></td>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                    <div class="pagination justify-content-center">
                        {{ $products->onEachSide(1)->links() }}
                    </div>

                    {{-- Hidden data container for full product list (used by Excel export) --}}
                    <div id="fullStockData" style="display:none;">
                        @php
                            // Prepare data for ALL products (not just the current page)
                            $exportData = $allProducts->map(function($product) {
                                $purchased_qty = purchased_qty($product);
                                $invoiced_qty = invoiced_qty($product);
                                $stock_qty = product_stock($product);
                                $stock_transfer_qty = stock_transfer_qty($product);
                                $stock_receive_qty = stock_receive_qty($product);
                                $returned_qty = returned_qty($product);
                                $damaged_qty = damaged_qty($product);
                                $adjust_in = adjust_in($product);
                                $adjust_out = adjust_out($product);
                                $return_pur_qty = return_pur_qty($product);

                                $variations = [];
                                if ($product->product_variations->count() > 0) {
                                    foreach ($product->product_variations as $variation) {
                                        $variations[] = [
                                            'variation' => ($variation->size?->size ?? '') . ' - ' . ($variation->color?->color ?? ''),
                                            'stock' => variation_stock($variation->id)
                                        ];
                                    }
                                }

                                return [
                                    'id' => $product->id,
                                    'name' => $product->name,
                                    'barcode' => $product->barcode,
                                    'category' => $product->category->name ?? '',
                                    'purchased_qty' => $purchased_qty,
                                    'stock_transfer_qty' => $stock_transfer_qty,
                                    'stock_receive_qty' => $stock_receive_qty,
                                    'invoiced_qty' => $invoiced_qty,
                                    'returned_qty' => $returned_qty,
                                    'return_pur_qty' => $return_pur_qty,
                                    'damaged_qty' => $damaged_qty,
                                    'adjust_in' => $adjust_in,
                                    'adjust_out' => $adjust_out,
                                    'available_stock' => ($product->product_variations->count() > 0) ? null : $stock_qty,
                                    'has_variations' => $product->product_variations->count() > 0,
                                    'variations' => $variations
                                ];
                            });
                        @endphp
                        {{ json_encode($exportData) }}
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection

@push('js')
    {{-- SheetJS CDN for Excel export --}}
    <script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js">
    </script>

    <script>
        /**
         * Export the stock table to Excel (.xlsx)
         * Uses the full data from #fullStockData (all products, not just paginated ones)
         */
        function exportToExcel() {
            const dataContainer = document.getElementById('fullStockData');
            if (!dataContainer) {
                alert('Full data not found!');
                return;
            }

            const fullData = JSON.parse(dataContainer.textContent);
            if (!fullData.length) {
                alert('No data to export');
                return;
            }

            // Build header row
            const headers = [
                'SL',
                'Product',
                'Category',
                'Stock In',
                'Stock Transfer',
                'Stock Receive',
                'Stock Out',
                'Sale Return',
                'Purchase Return',
                'Damage',
                'Adjust In',
                'Adjust Out',
                'Available Stock',
                'Variation'
            ];
            const rows = [headers];

            let sl = 1;
            fullData.forEach(product => {
                if (product.has_variations && product.variations.length > 0) {
                    // One row per variation
                    product.variations.forEach(v => {
                        rows.push([
                            sl,
                            product.name + ' - ' + product.barcode,
                            product.category,
                            product.purchased_qty,
                            product.stock_transfer_qty,
                            product.stock_receive_qty,
                            product.invoiced_qty,
                            product.returned_qty,
                            product.return_pur_qty,
                            product.damaged_qty,
                            product.adjust_in,
                            product.adjust_out,
                            v.stock,
                            v.variation
                        ]);
                        sl++;
                    });
                } else {
                    // Single row (no variations)
                    rows.push([
                        sl,
                        product.name + ' - ' + product.barcode,
                        product.category,
                        product.purchased_qty,
                        product.stock_transfer_qty,
                        product.stock_receive_qty,
                        product.invoiced_qty,
                        product.returned_qty,
                        product.return_pur_qty,
                        product.damaged_qty,
                        product.adjust_in,
                        product.adjust_out,
                        product.available_stock ?? 0,
                        ''
                    ]);
                    sl++;
                }
            });

            // Create workbook and download
            const wb = XLSX.utils.book_new();
            const ws = XLSX.utils.aoa_to_sheet(rows);
            const colWidths = headers.map((h) => ({ wch: Math.max(h.length, 15) }));
            ws['!cols'] = colWidths;
            XLSX.utils.book_append_sheet(wb, ws, 'Stock Report');
            XLSX.writeFile(wb, 'stock_report.xlsx');
        }
    </script>
@endpush