@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="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>
    <p class="text-xl uppercase w-[90%] py-3 font-bold text-center pl-4 barlow text-red-700">তারিখ : {{$date}}</p>
        
        <table id="table" class="w-full text-sm text-left text-gray-500 data-table">
            <thead class="text-xs text-gray-700 uppercase bg-gray-50 ">
                <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>
                    <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>
                    @foreach ($dokan_stock_setups as $dokan)
                    <th scope="col" class="px-2 py-3">
                        {{ $dokan->name }}
                    </th>
                    @endforeach
                    <th scope="col" class="px-2 py-3">
                        ক্লোজিং স্টক
                    </th>
                </tr>
            </thead>
            <tbody id="table_body">  

                @if($stocks)
                @php
                $total_stock_qty = 0;
                $total_sales_qty = 0;
                $total_return_qty = 0;
                $total_closing_stock = 0;
                $dokan_total_stock = [];
                $count = 1;
                $entry_date = date('Y-m-d', strtotime($date));;
                @endphp

                @foreach($stocks as $p)
                @php

                $sales_qty = $p->sales_qty;
                $date_sales_qty = $p->date_sales_qty;
                $return_qty = $p->return_qty;
                $date_return_qty = $p->date_return_qty;
                @endphp

                @php
                $total_stock_qty += $p->quantity - $sales_qty - $return_qty;
                $total_sales_qty += $date_sales_qty;
                $total_return_qty += $date_return_qty;

                $total_closing_stock += $p->quantity - $sales_qty - $return_qty;
                $total_closing_stock -= $date_sales_qty;
                $total_closing_stock -= $date_return_qty;
                
                $check_stock = $p->quantity - $sales_qty - $return_qty;
                @endphp
                @if($check_stock > 0)
                <tr class="border border-collapse">
                    <td class="px-2 py-3">{{$count++}}</td>
                    <td class="px-2 py-3 font-bold text-blue-700"><a href="{{route('ponno_purchase_report.memo',$p->id)}}" class="url" onclick="return false;">{{$p->id}}</a></td>
                    <td class="px-2 py-3">@if($p->purchase_type == 1) নিজ খরিদ @elseif($p->purchase_type == 2) কমিশন @endif</td>
                    <td class="px-2 py-3">{{$p->mohajon_setup->name}}</td>
                    <td class="px-2 py-3">{{$p->mohajon_owner_setup?->name}}</td>
                    <td class="px-2 py-3">{{$p->ponno_setup->ponno_name}}</td>
                    <td class="px-2 py-3">{{$p->ponno_type_setup?->ponno_type}}</td>
                    {{-- 
                    <td class="px-2 py-3">{{$p->ponno_size_setup?->ponno_size}}</td>
                    --}}
                    <td class="px-2 py-3">{{$p->ponno_marka_setup->ponno_marka}}</td>
                    <td class="px-2 py-3">{{$p->quantity}}</td> 
                    <td class="px-2 py-3">{{$p->quantity - $sales_qty - $return_qty}}</td>
                    <td class="px-2 py-3">{{$date_return_qty}}</td>
                    <td class="px-2 py-3">{{$date_sales_qty}}</td>
                    @php
                    $closing_stock = $p->quantity - $sales_qty - $return_qty;
                    $closing_stock -= $date_sales_qty;
                    $closing_stock -= $date_return_qty;
                    @endphp
                    @foreach ($dokan_stock_setups as $key => $dokan)
                    @php
                        
                        if (!isset($dokan_total_stock[$dokan->id])) {
                            $dokan_total_stock[$dokan->id] = 0;
                        }
                        
                        $stock = $dokan->purchaseByStock($p, $entry_date);
                       
                        if (is_numeric($stock)) {
                            $dokan_total_stock[$dokan->id] += $stock; 
                        } else {
                            $stock = 'N/A';  // Optional: you can customize this behavior if needed
                        }
                        
                    @endphp
                    <td class="px-2 py-3">{{ $stock }}</td>
                    @endforeach
                    <td class="px-2 py-3">{{$closing_stock}}</td>
                </tr>
                @endif
                @endforeach
                <tr class="border border-collapse odd:bg-white even:bg-gray-100">
                    <td colspan="9" class="px-2 py-3 text-sm font-bold text-red-600 text-center">মোট</td>
                    <td class="px-2 py-3 text-sm font-bold text-red-600">{{$total_stock_qty}}</td>
                    <td class="px-2 py-3 text-sm font-bold text-red-600">{{$total_return_qty}}</td>
                    <td class="px-2 py-3 text-sm font-bold text-red-600">{{$total_sales_qty}}</td>
                    @foreach ($dokan_stock_setups as $dokan)
                    <td class="px-2 py-3 text-sm font-bold text-red-600">{{$dokan_total_stock[$dokan->id] ?? 0}}</td>
                    @endforeach
                    <td class="px-2 py-3 text-sm font-bold text-red-600">{{$total_closing_stock}}</td>
                </tr>
                @endif
            </tbody>
         
        </table>
    </div>


    <style>

        @page { 
            size:210mm 297mm; 
            margin: 0;
        }
    </style>
    <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=' + '800' +
                ', height=' + '700' + ', top=' +
                top + ', left=' + left);
        })
    </script>

@endsection