@extends('main')

@section('content')
<div class="row clearfix">
    <div class="col-sm-12">
        <div class="card">
            <div class="card-header bg-light">
                <h4 class="card-title">Last Two QR Scan Report</h4>
            </div>

            <div class="card-body">

                <div class="table-responsive">
                    <table id="lastTwoScanTable" class="display table table-bordered table-striped">
                        <thead class="table-light">
                            <tr>
                                <th>Carpet Code</th>
                                <th>Weaver Name</th>
                                <th>Last Scan Time</th>
                                <th>Second Last Scan Time</th>
                                <th>Latitude</th>
                                <th>Longitude</th>
                                <th>Action</th>
                            </tr>
                        </thead>

                            <tbody>

                                @foreach($scans as $i => $records)

                                    @php
                                        $first  = $records[0];
                                        $second = $records->count() > 1 ? $records[1] : null;

                                        $firstLat = $firstLng = '-';
                                        if (!empty($first->latlong) && strpos($first->latlong, ',') !== false) {
                                            $p = explode(',', $first->latlong);
                                            $firstLat = trim($p[0] ?? '-');
                                            $firstLng = trim($p[1] ?? '-');
                                        }

                                        $secondLat = $secondLng = '-';
                                        if ($second && !empty($second->latlong) && strpos($second->latlong, ',') !== false) {
                                            $p2 = explode(',', $second->latlong);
                                            $secondLat = trim($p2[0] ?? '-');
                                            $secondLng = trim($p2[1] ?? '-');
                                        }
                                    @endphp
                                    @php
                                        $cleanQrcode = basename($first->qrcode);
                                    @endphp

                                    <tr>
                                        <td>{{ $first->carpet_code ?? '-' }}</td>
                                        <td>{{ $first->weaver_name ?? '-' }}</td>

                                        <td>{{ $first->scan_time ?? '-' }}</td>
                                        <td>{{ $second->scan_time ?? '-' }}</td>

                                        <td>
                                            <div><strong>1st:</strong> {{ $firstLat }}</div>
                                            <div><strong>2nd:</strong> {{ $secondLat }}</div>
                                        </td>

                                        {{-- Longitude Column --}}
                                        <td>
                                            <div><strong>1st:</strong> {{ $firstLng }}</div>
                                            <div><strong>2nd:</strong> {{ $secondLng }}</div>
                                        </td>

                                        <td>
                                            <a href="{{ url('qr-journey-report/'.$cleanQrcode) }}" class="btn btn-primary btn-sm">
                                                View Details
                                            </a>
                                        </td>
                                    </tr>

                                @endforeach
                                    </tbody>

                    </table>
                </div>

            </div>
        </div>
    </div>
</div>
@endsection


@section('script')
<script>
$(document).ready(function () {
    $('#lastTwoScanTable').DataTable({
        order: [[0, "asc"]],
        dom: 'Bfrtip',
        buttons: ['excel'],
        pageLength: 25,
        columnDefs: [
            { targets: [3,4], type: 'string' }, 
            { targets: [5], type: 'string' },
        ]
    });
});
</script>

@endsection