@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"> {{ $agent_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>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>Collection DATE</th>
                    </tr>
                </thead>

              @php
    $totalPrice = $bookings->sum('price');
    $totalWeight = $bookings->sum('weight');
   
@endphp 
            
                <tbody>
                    @foreach ($bookings as $shipment)
                   
                        <tr><td>{{ $loop->iteration }}</td>
                            <td>{{ $shipment->date }}</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>DHL</td>
                            <td>{{ $shipment->weight }}</td>
                            <td>{{ $shipment->price }}</td>
                            <td>{{ $shipment->price }}</td>
                            <td>{{ $agent_name }}</td>
                            <td>{{ App\Models\Collection::where('tracking_id', $shipment->booking_no)->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>{{ $totalPrice }}</td>
            <td colspan="3"></td>
        </tr>
                </tbody>
            </table>
        </div>
    </div>
</div>
@endsection