@extends('user.layout.report_layout')
@section('report_body')

<div class=" mx-auto max-w-screen ">
    <div class="p-4 px-4 mb-6 text-center bg-white md:p-8">
        @component('components.project_headline')
        @endcomponent

        <div class="xl:w-10/12 lg:w-11/12 w-full mx-auto p-4 relative overflow-x-auto  sm:rounded-lg bg-white mb-6">
            <p class="text-xl uppercase w-[90%] py-3 font-bold text-center pl-4 barlow text-green-800">বিক্রয় রিপোর্ট (পন্য)</p>
            <div class="grid grid-cols-2 mt-2 text-center px-4">
                <div class="col-span-1 py-1">
                    <h1 class="text-base font-bold text-red-600">তারিখ শুরু : {{$request->date_from}}</h1>
                </div>
                <div class="col-span-1 py-1">
                    <h1 class="text-base font-bold text-red-600">তারিখ শেষ : {{$request->date_to}}</h1>
                </div>
                <div class="col-span-1 py-1">
                    <h1 class="text-base font-bold text-red-600">রিপোর্টের ধরন : {{$request->report_type == 3 ? 'পন্য (ইনভোয়েস)' : 'পন্য'}}</h1>
                </div>
                <div class="col-span-1 py-1">
                    <h1 class="text-base font-bold text-red-600">বিক্রির ধরন : {{ SalesType($request->sales_type) }}</h1>
                </div>
            </div>

            <table id="sales-table" class="w-full text-sm text-left text-gray-500 data-table">
                @if($sales)
                <thead class="text-xs text-gray-700 uppercase bg-gray-50 dark:bg-gray-700 dark:text-gray-400">
                    <tr class="border border-collapse">
                        <th scope="col" class="px-2 py-3">
                            নং
                        </th>
                        <th scope="col" class="px-2 py-3">
                            গ্রহন ইনভয়েস
                        </th>
                        <th scope="col" class="px-2 py-3">
                            পন্যের নাম
                        </th>
                        <th scope="col" class="px-2 py-3">
                            পন্যের ধরন
                        </th>
                        <th scope="col" class="px-2 py-3">
                            লট/গ্রহন সংখ্যা
                        </th>
                        <th scope="col" class="px-2 py-3">
                            মার্কা
                        </th>
                        <th scope="col" class="px-2 py-3">
                            সংখ্যা
                        </th>
                        <th scope="col" class="px-2 py-3">
                            ওজন
                        </th>
                        <th scope="col" class="px-2 py-3">
                            গড় দর
                        </th>
                        <th scope="col" class="px-2 py-3">
                            মোট টাকা
                        </th>
                    </tr>
                </thead>
                <tbody id="table_body">
                @php
                $total = 0;
                $total_qty = 0;
                $total_weight = 0;
                $groupedSales = [];

                // Group sales by purchase_id and sales_rate
                foreach($sales as $sale) {
                    if($report_type == 3)
                    {
                        $key = $sale->purchase_id;
                    }
                    else
                    {
                        $key = $sale->purchase_id . '_' . $sale->sales_rate;
                    }
                    if (!isset($groupedSales[$key])) {
                        $groupedSales[$key] = [
                            'purchase_id' => $sale->purchase_id,
                            'sales_rate' => $sale->sales_rate,
                            'total_sales_qty' => 0,
                            'total_sales_weight' => 0,
                            'weighted_sales_sum' => 0,
                            'total_weight' => 0,
                            'ponno_setup_name' => $sale->ponno_purchase_entry->ponno_setup->ponno_name,
                            'ponno_type' => $sale->ponno_purchase_entry->ponno_type_setup?->ponno_type,
                            'ponno_marka' => $sale->ponno_purchase_entry->ponno_marka_setup->ponno_marka,
                            'purchase_qty' => $sale->ponno_purchase_entry->quantity,
                        ];
                    }
                    // Sum total sales quantity and total sales weight
                    $groupedSales[$key]['total_sales_qty'] += $sale->sales_qty;
                    $groupedSales[$key]['total_sales_weight'] += $sale->sales_weight;
                    $groupedSales[$key]['weighted_sales_sum'] += $sale->sales_rate * $sale->sales_weight;
                    $groupedSales[$key]['total_weight'] += $sale->sales_weight;

                    if ($report_type == 3) {
                        $total += $sale->sales_rate * $sale->sales_weight;
                        $total_qty += $sale->sales_qty;
                        $total_weight += $sale->sales_weight;
                    }
                }

                foreach ($groupedSales as $key => &$group) {
                    $group['average_sales_rate'] = $group['total_weight'] > 0
                        ? $group['weighted_sales_sum'] / $group['total_weight']
                        : 0;
                }
                unset($group);
                @endphp

                @foreach($groupedSales as $groupedSale)
                    <tr class="border border-collapse">
                        <td class="px-4 py-2">{{ $loop->index + 1 }}</td>
                        <td class="px-4 py-2 font-bold text-blue-700">
                            <a class="url" onclick="return false;" href="{{ route('ponno_purchase_report.memo', $groupedSale['purchase_id']) }}">
                                {{ $groupedSale['purchase_id'] }}
                            </a>
                        </td>
                        <td class="px-4 py-2">{{ $groupedSale['ponno_setup_name'] }}</td>
                        <td class="px-4 py-2">{{ $groupedSale['ponno_type'] }}</td>
                        <td class="px-4 py-2">{{ $groupedSale['purchase_qty'] }}</td>
                        <td class="px-4 py-2">{{ $groupedSale['ponno_marka'] }}</td>
                        <td class="px-4 py-2">{{ $groupedSale['total_sales_qty'] }}</td>
                        <td class="px-4 py-2">{{ $groupedSale['total_sales_weight'] }}</td>
                        <td class="px-4 py-2">{{ number_format($groupedSale['average_sales_rate'],2) }}</td>
                        <td class="px-4 py-2">{{ number_format($groupedSale['average_sales_rate'] * $groupedSale['total_sales_weight']) }}</td>
                        @php
                        if ($report_type != 3)
                        {
                            $total_qty += $groupedSale['total_sales_qty'];
                            $total_weight += $groupedSale['total_sales_weight'];
                            $total += $groupedSale['average_sales_rate'] * $groupedSale['total_sales_weight'];
                        }
                        @endphp
                    </tr>
                @endforeach
                </tbody>
                <tfoot>
                    <tr class="border border-collapse">
                        <td class="px-6 py-3 font-bold text-red-700 text-center" colspan="6">মোট</td>
                        <td class="px-6 py-3 font-bold text-red-700">{{ number_format($total_qty) }}</td>
                        <td class="px-6 py-3 font-bold text-red-700">{{ number_format($total_weight) }}</td>
                        <td class="px-6 py-3"></td>
                        <td class="px-6 py-3 font-bold text-red-700">{{ number_format($total) }}</td>
                    </tr>
                </tfoot>
            </table>
            <div class="mt-4 text-right">
                <strong>Total Amount:</strong> <span>{{ number_format($total) }} ৳</span>
            </div>
        </div>
        <script>
            $('.url').click(function() {
                var left = (screen.width - 800) / 2;
                var top = (screen.height - 700) / 4;

                var url = $(this).attr('href');

                var myWindow = window.open(url, url,
                    'resizable=yes, width=' + '600' +
                    ', height=' + '1200' + ', top=' +
                    top + ', left=' + left);
            })

            $('#sales-table').DataTable({
                "paging": true,
                "pageLength": 50,
                "searching": true,
                "ordering": true,
                "info": true,
                "language": {
                    "emptyTable": "ডাটা পাওয়া যায়নি",
                    "search": "সার্চ করুন : ",
                    "info": "",
                    "infoEmpty": "",
                    "infoFiltered": "",
                    "lengthMenu": "_MENU_টি এন্ট্রি দেখুন",
                    "loadingRecords": "লোড হচ্ছে...",
                    "zeroRecords": "রেকর্ড পাওয়া যায়নি",
                    "paginate": {
                        "first": "প্রথম",
                        "last": "শেষ",
                        "next": "পরবর্তি",
                        "previous": "পুর্বে"
                    },
                },
            });
        </script>
        @endif

        @endsection