Edit Sales Settlement

@php $savedBatchesData = []; foreach ($settlement->items as $item) { foreach ($item->batches as $batch) { $savedBatchesData[$batch->stock_batch_id] = [ 'sold' => (float) $batch->quantity_sold, 'returned' => (float) $batch->quantity_returned, 'shortage' => (float) $batch->quantity_shortage, ]; } } $creditSalesData = $settlement->creditSales->map(function ($sale) { return [ 'customer_id' => $sale->customer_id, 'customer_name' => $sale->customer->customer_name ?? 'Unknown', 'invoice_number' => $sale->invoice_number, 'sale_amount' => (float) $sale->sale_amount, 'previous_balance' => (float) $sale->previous_balance, 'new_balance' => (float) $sale->new_balance, 'notes' => $sale->notes, ]; }); $creditSalesDecoded = old('credit_sales'); if (is_string($creditSalesDecoded)) { $decoded = json_decode($creditSalesDecoded, true); if (json_last_error() === JSON_ERROR_NONE) { $creditSalesDecoded = $decoded; } } if (!is_array($creditSalesDecoded) || empty($creditSalesDecoded)) { $creditSalesDecoded = $creditSalesData->toArray(); } $recoveriesData = $settlement->recoveries->map(function ($recovery) { return [ 'customer_id' => $recovery->customer_id, 'customer_name' => $recovery->customer->customer_name ?? 'Unknown', 'recovery_number' => $recovery->recovery_number, 'payment_method' => $recovery->payment_method, 'bank_account_id' => $recovery->bank_account_id, 'bank_account_name' => $recovery->bankAccount->account_name ?? null, 'previous_balance' => (float) $recovery->previous_balance, 'amount' => (float) $recovery->amount, 'new_balance' => (float) $recovery->new_balance, 'notes' => $recovery->notes, ]; }); $recoveriesDecoded = old('recoveries_entries'); if (is_string($recoveriesDecoded)) { $decoded = json_decode($recoveriesDecoded, true); if (json_last_error() === JSON_ERROR_NONE) { $recoveriesDecoded = $decoded; } } if (!is_array($recoveriesDecoded) || empty($recoveriesDecoded)) { $recoveriesDecoded = $recoveriesData->toArray(); } $recoveriesTotal = collect($recoveriesDecoded)->sum(function ($entry) { return floatval($entry['amount'] ?? 0); }); $bankTransfersData = $settlement->bankTransfers->map(function ($transfer) { return [ 'bank_account_id' => $transfer->bank_account_id, 'bank_account_name' => $transfer->bankAccount->account_name ?? 'Unknown', 'amount' => (float) $transfer->amount, 'reference_number' => $transfer->reference_number, 'transfer_date' => optional($transfer->transfer_date)->format('Y-m-d'), 'customer_id' => $transfer->customer_id, 'customer_name' => $transfer->customer->customer_name ?? null, 'notes' => $transfer->notes, ]; }); $bankTransfersDecoded = old('bank_transfers'); if (is_string($bankTransfersDecoded)) { $decoded = json_decode($bankTransfersDecoded, true); if (json_last_error() === JSON_ERROR_NONE) { $bankTransfersDecoded = $decoded; } } if (!is_array($bankTransfersDecoded) || empty($bankTransfersDecoded)) { $bankTransfersDecoded = $bankTransfersData->toArray(); } $chequesData = $settlement->cheques->map(function ($cheque) { return [ 'cheque_number' => $cheque->cheque_number, 'amount' => (float) $cheque->amount, 'bank_name' => $cheque->bank_name, 'bank_account_id' => $cheque->bank_account_id, 'bank_account_name' => $cheque->bankAccount->account_name ?? null, 'cheque_date' => optional($cheque->cheque_date)->format('Y-m-d'), 'customer_id' => $cheque->customer_id, 'customer_name' => $cheque->customer->customer_name ?? 'N/A', 'notes' => $cheque->notes, ]; }); $chequesDecoded = old('cheques'); if (is_string($chequesDecoded)) { $decoded = json_decode($chequesDecoded, true); if (json_last_error() === JSON_ERROR_NONE) { $chequesDecoded = $decoded; } } if (!is_array($chequesDecoded) || empty($chequesDecoded)) { $chequesDecoded = $chequesData->toArray(); } $cashDenom = $settlement->cashDenominations->first(); $savedExpensesData = $settlement->expenses->map(function ($expense) { return [ 'id' => 'saved_' . $expense->id, 'expense_account_id' => $expense->expense_account_id, 'amount' => (float) $expense->amount, 'description' => $expense->description, 'label' => $expense->expenseAccount->account_name ?? '', 'account_code' => $expense->expenseAccount->account_code ?? '', ]; }); $advanceTaxesData = $settlement->advanceTaxes->map(function ($tax) { return [ 'customer_id' => $tax->customer_id, 'customer_name' => $tax->customer->customer_name ?? 'Unknown', 'tax_amount' => (float) $tax->tax_amount, ]; }); $advanceTaxesDecoded = old('advance_taxes'); if (is_string($advanceTaxesDecoded)) { $decoded = json_decode($advanceTaxesDecoded, true); if (json_last_error() === JSON_ERROR_NONE) { $advanceTaxesDecoded = $decoded; } } if (!is_array($advanceTaxesDecoded) || empty($advanceTaxesDecoded)) { $advanceTaxesDecoded = $advanceTaxesData->toArray(); } @endphp

@csrf @method('PUT') {{-- Hidden input to store current employee ID for credit sales modal --}}

{{-- Section 1: Date & Goods Issue Selection --}}

{{-- Section 2: Combined Batch-wise Settlement Table --}}

{{-- Section 3: Side-by-Side Cash Detail, Expense Detail, and Sales Summary --}}

Cash Reconciliation & Settlement

{{-- ROW 1: Credit Sales Detail | Recoveries Detail | Cheque Payments | Bank Transfers --}}

{{-- Credit Sales Detail Card --}}

Credit Sales Detail

Customer	PB	Sale	BAL
No credit sales entries
Total:		0	0

{{-- Recoveries Detail Card --}}

Recoveries Detail

Customer	Recovery
No recovery entries
Total:	0

{{-- Cheque Payments Card --}}

Cheque Payments

Customer	Cheque #	Bank	Deposit Bank	Cheque Date	Amount
No cheque payments
Total:					0

{{-- Bank Transfers Card --}}

Bank Transfers

Customer	Bank	Ref #	Transfer Date	Amount
No bank transfers
Total:				0

{{-- Bank Slips Card --}}

Bank Slips / Deposits

Bank	Ref #	Date	Amount
No bank slip entries
Total:			0

{{-- ROW 2: Cash Detail | Expense Detail | Sales Summary --}}

{{-- Cash Detail (Denomination Breakdown) Card --}}

Cash Detail (Denomination Breakdown)

Denomination	Quantity	Amount
5,000 Notes		0.00
1,000 Notes		0.00
500 Notes		0.00
100 Notes		0.00
50 Notes		0.00
20 Notes		0.00
10 Notes		0.00
Loose Cash/Coins	-
Total Physical Cash		0.00

{{-- Hidden inputs for totals (will be populated by modals) --}}

{{-- Expense Detail Card --}}

Expense Detail

Expense Account	Amount
{{-- Hidden inputs for form submission --}}
Total:	0.00

{{-- Sales Summary Card --}}

Sales Summary

{{-- Profit Analysis Section --}}

Description	Amount
Credit Sale Amount	0.00
Cheque Sale Amount	0.00
Bank Transfer Amount	0.00
Bank Slips / Deposits	0.00
Cash Sale Amount	0.00
Net Sale (Sold Items Value)	0.00
Return Value	0.00
Shortage Value	0.00
Recovery (Cash)	0.00
Recovery (Bank/Online)	0.00
Total Sale Amount	0.00
Expected Cash (Sales + Cash Recoveries)	0.00
Less: Expenses	0.00
Expected Cash (After Expenses)	0.00
Physical Cash Submitted (Denominations) Total physical cash handed over to office	0.00
Bank Slips / Deposits Direct deposits to bank	0.00
Short/Excess	0.00
Profit Analysis
Total COGS	0.00
Gross Profit (Sales - COGS)	0.00
Gross Margin	0.00%
Less: Expenses	0.00
Net Profit (After Expenses)	0.00
Net Margin	0.00%

{{-- Hidden input fields for calculations --}}

{{-- Section 8: Notes (MOVED TO BOTTOM) --}}

Update Settlement

@push('scripts') @endpush