@php // Base contract values $baseValue = $contract->sales_contract_value; $baseQty = $contract->quantity_pcs; // Initialize revised totals $totalRevisedValue = $contract->Revised_value ?? 0; $totalRevisedQty = $contract->Revised_qty_pcs ?? 0; // Add all historical revisions if ($contract->revised_history) { foreach ($contract->revised_history as $history) { $totalRevisedValue += $history['Revised_value'] ?? 0; $totalRevisedQty += $history['Revised_qty_pcs'] ?? 0; } } // Calculate final totals $totalContractValue = $baseValue + $totalRevisedValue; $totalQty = $baseQty + $totalRevisedQty; // Calculate FOB $fob = $totalQty > 0 ? $totalContractValue / $totalQty : 0; // Calculate export summaries $exportPcs = DB::table('sales_exports')->where('contract_id', $contract->id)->sum('g_qty_pcs') ?? 0; $exportValue = DB::table('sales_exports')->where('contract_id', $contract->id)->sum('amount_usd') ?? 0; $p_realized_value = DB::table('sales_exports')->where('contract_id', $contract->id)->sum('realized_value') ?? 0; $shortExcessValue = $totalContractValue - $exportValue; $shortExcessPcs = $totalQty - $exportPcs; @endphp Sales Contracts Details

Contract Details

Back
Contract No: @can('edit contracts') Edit @endcan @can('delete contracts')
@csrf @method('DELETE')
@endcan

{{ $contract->sales_contract_no }}

Buyer {{ $contract->buyer_name }}
Contract No. {{ $contract->sales_contract_no }}
Sales Contract Value ${{ number_format($totalContractValue, 2) }}

Revised Details

Quantity (Pcs) {{ number_format($totalQty) }} PCS
FOB ${{ number_format($fob, 4) }}
Export (Pcs) @php $exportPcs = DB::table('sales_exports') ->where('contract_id', $contract->id) ->sum('g_qty_pcs'); @endphp {{ number_format($exportPcs) }} PCS
Export Value ${{ number_format($exportValue, 2) }}
Short/Excess Value ${{ number_format($shortExcessValue, 2) }}
Short/Excess (Pcs) {{ number_format($shortExcessPcs) }} PCS
P. Realized Value ${{ number_format($p_realized_value, 2) }}
Replace {{ $contract->replace ? 'Yes' : 'No' }}
First Shipment Date @php $firstShipmentDate = DB::table('sales_exports') ->where('contract_id', $contract->id) ->min('shipment_date') ?? 'N/A'; @endphp {{ $firstShipmentDate }}
Last Shipment Date @php $lastShipmentDate = DB::table('sales_exports') ->where('contract_id', $contract->id) ->max('shipment_date') ?? 'N/A'; @endphp {{ $lastShipmentDate }}
Expiry Date @php $expiryDate = $contract->expiry_date ? $contract->expiry_date->format('d-M-Y') : 'N/A'; @endphp {{ $expiryDate }}

BTB Details

Amount (USD) % As per Contract % As per Export
Fabrics ${{ number_format($contract->fabrics_value, 2) }}
Accessories ${{ number_format($contract->accessories_value, 2) }}
Print/Emb. ${{ number_format($contract->print_emb_value, 2) }}
Total BTB

UD Details

@php $udHistory = $contract->ud_history ?? []; // Use empty array if null $udTotals = [ 'value' => $contract->ud_value ?? 0, 'qty' => $contract->ud_qty_pcs ?? 0, 'used' => $contract->used_value ?? 0, ]; foreach ($udHistory as $record) { $udTotals['value'] += $record['ud_value'] ?? 0; $udTotals['qty'] += $record['ud_qty_pcs'] ?? 0; $udTotals['used'] += $record['used_value'] ?? 0; } @endphp
Total UD Value ${{ number_format($udTotals['value'], 2) }}
Total UD Qty (PCS) {{ number_format($udTotals['qty']) }} PCS
Total Used Value (USD) ${{ number_format($udTotals['used'], 2) }}
@can('Import-CURD') Download Import Template @endcan @can('Export-CURD') Download Export Template @endcan
@include('partials.sales_imports_table', ['imports' => $contract->imports])
@include('partials.sales_exports_table', ['exports' => $contract->exports])