Search and Filter

@php $Sales_contracts = \App\Models\SalesContract::select('sales_contract_no')->distinct()->get(); // Fetch all distinct contract numbers from the contracts $Sales_contracts = \App\Models\SalesContract::whereIn( 'sales_contract_no', $Sales_contracts, )->get(); // Fetch all contracts based on the distinct numbers @endphp Start Date: End Date:

@foreach ($contracts as $contract) @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 $sales_contract_value = $baseValue + $totalRevisedValue; $quantity_pcs = $baseQty + $totalRevisedQty; // Calculate FOB $fob = $quantity_pcs > 0 ? $sales_contract_value / $quantity_pcs : 0; // find the first and last shipment dates $first_shipment_date = DB::table('sales_exports') ->where('contract_id', $contract->id) ->orderBy('shipment_date', 'asc') ->value('shipment_date'); //if no shipment date found, set to null if (!$first_shipment_date) { $first_shipment_date = null; } else { $first_shipment_date = \Carbon\Carbon::parse($first_shipment_date)->format( 'd-M-Y', ); } $last_shipment_date = DB::table('sales_exports') ->where('contract_id', $contract->id) ->orderBy('shipment_date', 'desc') ->value('shipment_date'); //if no shipment date found, set to null if (!$last_shipment_date) { $last_shipment_date = null; } else { $last_shipment_date = \Carbon\Carbon::parse($last_shipment_date)->format( 'd-M-Y', ); } // New calculations for the index page $exportValue = $contract->exports->sum('amount_usd'); $realizationValue = $contract->exports->sum('realized_value'); $btbValue = $contract->fabrics_value + $contract->accessories_value + $contract->print_emb_value; $btbPercentage = $exportValue > 0 ? ($btbValue / $exportValue) * 100 : 0; @endphp @endforeach

Contract No.	Buyer	Contract Value	Quantity (PCS)	FOB	Export Value	Realization Value	BTB Value	BTB %	Shipment Dates	Status	Actions
{{ $contract->sales_contract_no }}	{{ $contract->buyer_name }}	${{ number_format($sales_contract_value, 0) }}	{{ number_format($quantity_pcs) }}	${{ number_format($fob, 2) }}	${{ number_format($exportValue, 0) }}	${{ number_format($realizationValue, 0) }}	${{ number_format($btbValue, 0) }}	{{ number_format($btbPercentage, 2) }}%	@isset($first_shipment_date) {{ $first_shipment_date ?? '' }} to @endisset @isset($last_shipment_date) {{ $last_shipment_date ?? '' }} @endisset @isset($contract->expiry_date) {{ $contract->expiry_date ?? '' }} @endisset	@can('Sales-CURD') @csrf @method('PUT') @endcan	@can('Sales-CURD') @csrf @method('DELETE') @endcan

Sales Contracts

Search and Filter