@extends('master')

@section('title', 'Shipments')

@section('content')
<div class="container-fluid pt-4 px-4" style="min-height: 75vh;">
    <div class="bg-light rounded h-100 p-4">
        <h5 class="mb-4">Shipment Records</h5>
        <div class="table-responsive">
            <table class="table table-bordered border-dark">
                <thead class="text-center">
                    <tr>
                        <th colspan="8"> {{ $company->name }}</th>
                        <th colspan="7"> TS EXPRESS & CARGO</th>
                    </tr>
                    <tr>
                        <th colspan="4">TOTAL SHIPMENT</th>
                        <th colspan="5">SHIPMENT BILL</th>
                        <th colspan="3">COMPANY</th>
                        <th colspan="3">PAIDE</th>
                    </tr>
                    <tr>
                        <th>SI NO</th>
                        <th>DATE</th>
                        <th>AGENT NAME</th>
                  
                        <th>TRACKING NO</th>
                        <th>SENDER NAME</th>
                        <th>RECEIVER NAME</th>
                        <th>DESCRIPTION</th>
                        <th>DEST</th>
                        <th>SERVICE</th>
                        <th>WT</th>
                        <th>TAKA</th>
                        
                        <th>COMPANY BILL</th>
                        <th>NAME</th>
                        <th>PAYMENT DATE</th>
                    </tr>
                </thead>

             @php
    $totalPrice = $bookings->sum('price');
    $totalWeight = $bookings->sum('weight');
    $totalPaymentAmount = $bookings->sum(function ($shipment) {
        $payment = App\Models\Payment::where('tracking_id', $shipment->booking_no)->latest()->first();
        return $payment ? $payment->payment_amount : 0;
    });
@endphp
            
                <tbody>
                   
                    @foreach ($bookings as $shipment)
                    
                   
                        <tr>
                            <td>{{ $loop->iteration }}</td>
                            <td>{{ $shipment->date }}</td>
                            <td>  {{ App\Models\Agent::find($shipment->agent_id)->name ?? 'N/A' }}</td>
                          
                            <td>{{ $shipment->booking_no}}</td>
                            <td>{{ $shipment->shipper }}</td>
                            <td>{{ $shipment->consignee }}</td>
                            <td>{{ $shipment->description_of_goods }}</td>
                            <td>{{ $shipment->destination }}</td>
                            <td>{{ App\Models\Service::find($shipment->service)->name ?? 'N/A' }}</td>
                            <td>{{ $shipment->weight }}</td>
                            <td>{{ $shipment->price }}</td>
                            <td>{{ App\Models\Payment::where('tracking_id', $shipment->booking_no)->latest()->first()->payment_amount ?? 'N/A' }}</td>
                            <td>{{ $company->name }}</td>
                            <td>{{ App\Models\Payment::where('tracking_id', $shipment->booking_no)->latest()->first()->payment_date ?? 'N/A' }} </td>
                          
                        </tr>
                    @endforeach
                    <tr>
            <td colspan="9" class="text-right font-weight-bold">TOTAL</td>
            <td>{{ $totalWeight }}</td>
            <td>{{ $totalPrice }}</td>
            <td>{{ $totalPaymentAmount }}</td>
            <td colspan="3"></td>
        </tr>
                </tbody>
            </table>
        </div>
    </div>
</div>
@endsection