दीर्घकालीन उत्पादन प्रतिवेदन (Long Term Products Report)

फर्कनुहोस्

@foreach($groupedProducts as $productIndex => $productGroup)

नेपाल सरकार

प्रदेश सरकार

स्थानीय सरकारको छाप

सङ्घ/ प्रदेश / स्थानीय तह

२ नं वडा कार्यालय

कार्यालय कोड नं.: ........

जिन्सी मालसामान खाता ( खर्च भएर जाने )

फाराम नं: ४०७ - म.ले.प.

जिन्सी मालसामानकाे नाम :	{{ $productName ?? $productGroup['product_name'] }}
एकाइ :	{{ $productGroup['unit'] ?? 'नग' }}
स्पेसिफिकेसन :	{{ $productGroup['specification'] ?? '-' }}

आर्थिक वर्ष :	{{ $fiscal_year ?? '२०८१/८२' }}
सङकेत नं :

@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) $storeQty = $maagProduct ? $maagProduct->qty : 0; $storeRate = $kharidProduct ? $kharidProduct->amount : 0; $storeAmount = $kharidProduct ? $kharidProduct->total : 0; // 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; // Set remaining rate to 0 if remaining quantity is 0, otherwise use product amount $remainingRate = ($remainingQty == 0) ? 0 : ($jinsiFormProduct ? $jinsiFormProduct->amount : 0); // Calculate remaining amount $remainingAmount = $remainingRate * $remainingQty; $rowColor = $index % 2 == 0 ? '#ffffff' : '#f9f9f9'; $entryDate = $jinsiForm && $jinsiForm->entry_date ? \Anuzpandey\LaravelNepaliDate\LaravelNepaliDate::from($jinsiForm->entry_date)->toNepaliDate(locale: 'np') : ''; @endphp @empty @endforelse

क्र.स.	मिति	दाखिला/निकासा फाराम नं	स्टाेर दाखिला			निकासा			बाँकी			कैफियत
क्र.स.	मिति	दाखिला/निकासा फाराम नं	परिमाण.	दर	रकम	परिमाण.	दर	रकम	परिमाण.	दर	रकम	कैफियत
{{ $loop->iteration }}	{{ $entryDate }}	जिन्सी: {{ $jinsiForm->id_no ?? 'N/A' }} खरिद: {{ $kharidProduct->kharidForm->id_no ?? 'N/A' }}	{{ number_format($storeQty, 2) }}	{{ number_format($storeRate, 2) }}	{{ number_format($storeAmount, 2) }}	{{ number_format($issuedQty, 2) }}	{{ number_format($issuedRate, 2) }}	{{ number_format($issuedAmount, 2) }}	{{ number_format($remainingQty, 2) }}	{{ number_format($remainingRate, 2) }}	{{ number_format($remainingAmount, 2) }}	{{ $product->remarks ?? '-' }}
कुनै दीर्घकालीन उत्पादनहरू छैनन् No long-term products found
जम्मा (Total):			{{ number_format(collect($productGroup['entries'])->sum(function($p) { return $p->kharidFormProduct->maagFormProduct->qty ?? 0; }), 2) }}		{{ number_format(collect($productGroup['entries'])->sum(function($p) { return $p->kharidFormProduct->total ?? 0; }), 2) }}	{{ number_format(collect($productGroup['entries'])->sum('qty'), 2) }}		{{ number_format(collect($productGroup['entries'])->sum('total'), 2) }}	{{ number_format(collect($productGroup['entries'])->sum('remaining_qty'), 2) }}		{{ number_format(collect($productGroup['entries'])->sum(function($p) { $remainingQty = $p->remaining_qty; $remainingRate = ($remainingQty == 0) ? 0 : $p->amount; return $remainingRate * $remainingQty; }), 2) }}

@endforeach