@php use Illuminate\Support\Str; @endphp
@extends('layouts.master')
<style>
    .table-bordered td,
    .table-bordered th {
        border: 1px solid #00000042 !important;
        font-size: 13px !important;
    }

    .first-table td,
    .first-table th {
        font-size: 13px !important;
    }

    .form-control {
        appearance: auto !important;
    }

    @media print {
        #kt_header {
            display: none !important;
        }

        #kt_footer {
            display: none !important;
        }
        #topheadsection,
        #backbtn,
        #dropdownMenuButton1,
        #pdfhead,
        #report_link,
        #printButton,
        #searchFrom {
            display: none !important;
        }
    }
    .header_text_color{
        color: #fff;
    }

</style>
@section('content')


<div class="content d-flex flex-column flex-column-fluid" id="kt_content">
        <div id="kt_content_container" class="container-xxl">
            <div class="flex-lg-row-fluid">
                <div class="d-flex flex-wrap flex-stack pb-7">
                    <div class="d-flex flex-wrap align-items-center my-1">
                        <h3 class="fw-bold me-5 my-1">Disp Pay Report
                        </h3>
                    </div>
                </div>
                <div class="row">
                    <form action="{{ route('assets.loads.disppayreport') }}" class="d-flex align-items-center mt-3" id="searchFrom" >
                        <div class="col-md-4">
                            <input type="hidden" name="start_date" id="start_date" value="{{ $startDate }}">
                            <input type="hidden" name="end_date" id="end_date" value="{{ $endDate }}">
                            <div id="range" style="cursor: pointer;">
                                <span></span> <i class="fa fa-caret-down"></i>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <button type="submit" class="btn btn-primary">Filter</button>
                            <a href="{{ route('assets.loads.disppayreport') }}" class="btn btn-secondary">Clear</a>
                        </div>  
                        <div class="col-md-2">
                        
                            <a href="javascript:void(0)" onclick="process()" class="btn btn-success">Process</a>
                        </div>                                             
                    </form>
                </div>
                
                <div class="tab-content">
                    <div id="kt_project_users_table_pane" class="tab-pane fade show active">
                        <div class="card card-flush">
                            <div class="pt-0">
                               
                                    @php
                                        // Manual grouping using PHP
                                        $groupedLoads = [];

                                        foreach ($loads as $load) {
                                            $customerName = $load->name1 ?? '';
                                            $groupedLoads[$customerName][] = $load;
                                        }
                                    @endphp
                                    @if ($loads->isEmpty())
                                        <div class="">No data found</div>
                                    @endif
                                    @foreach ($groupedLoads as $customer => $group)
                                        <h4 class="mt-5 mb-3">Name: {{ $customer }}</h4>
                                        <div class="table-responsive p-5">
                                        <table id="loads-table-{{ Str::slug($customer) }}" class="table table-striped table-row-bordered table-row-dashed dataTable no-footer gy-4 align-middle fw-bold">
                                            <thead>
                                                <tr class="thead-bg-color">
                                                    <th>bidid</th>
                                                    <th>loadid</th>
                                                    <th>trip status</th>
                                                    <th>createdby</th>
                                                    <th>Deliver Date</th>                                                    
                                                    <th>Customer</th>
                                                    <th>Carrier</th>
                                                    <th>load rate</th>
                                                    <th>CARRIER RATE</th>
                                                    <th>ostate</th>
                                                    <th>dstate</th>
                                                    <th>create date</th>
                                                    <th>BRANCH</th>
                                                    <th>agentpay</th>
                                                    <th>commission</th>
                                                    <th>Balance</th>
                                                    <th>tragentpay</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach ($group as $load)
                                                    <tr>
                                                        <td>{{ $load->bidid }}</td>
                                                        <td>{{ $load->loadid }}</td>
                                                        <td>{{ $load->status }}</td>
                                                        <td>{{ $load->created_by }}</td>
                                                        <td>{{ $load->delivered_date }}</td>
                                                        <td>{{ $load->NAME2 }}</td>
                                                        <td>{{ $load->CompanyName }}</td>
                                                        <td>{{ $load->load_rate }}</td>
                                                        <td>{{ $load->CARRIER_RATE }}</td>
                                                        <td>{{ $load->ostate }}</td>
                                                        <td>{{ $load->dstate }}</td>
                                                        <td>{{ $load->create_date }}</td>
                                                        <td>{{ $load->BRANCH }}</td>
                                                        <td>{{ $load->agentpay }}</td>
                                                        <td>{{ $load->commission }}</td>
                                                        <td>{{ $load->Balance }}</td>
                                                        <td>{{ $load->tragentpay }}</td>
                                                    </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                        </div>
                                    @endforeach
                                
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>


@endsection()
@section('script')
<script>
    $(document).ready(function () {
        @foreach ($groupedLoads as $customer => $group)
            var tableId = '#loads-table-{{ Str::slug($customer) }}';

            if ($.fn.DataTable.isDataTable(tableId)) {
                $(tableId).DataTable().clear().destroy();
            }

            $(tableId).DataTable({
                pageLength: 10,
                responsive: false,
                order: [],
            });
        @endforeach
    });

    
</script>
<script>
    $(function () {
        let start = moment("{{ $startDate ?? \Carbon\Carbon::now()->subDays(29)->format('Y-m-d') }}");
        let end = moment("{{ $endDate ?? \Carbon\Carbon::now()->format('Y-m-d') }}");

        function cb(start, end) {
            $('#range span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'));
            $('#start_date').val(start.format('YYYY-MM-DD'));
            $('#end_date').val(end.format('YYYY-MM-DD'));
        }

        $('#range').daterangepicker({
            startDate: start,
            endDate: end,
            ranges: {
                'Today': [moment(), moment()],
                'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
                'Last 7 Days': [moment().subtract(6, 'days'), moment()],
                'Last 30 Days': [moment().subtract(29, 'days'), moment()],
                'This Month': [moment().startOf('month'), moment().endOf('month')],
                'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')]
            }
        }, cb);

        cb(start, end);
    });

    function process(){
        var start='{{request("start_date")}}';
        var end='{{request("end_date")}}';
            $.ajax({
            url:'{{route("assets.loads.processDispayreport")}}',
            type:"POST",
            beforeSend:function(){
                $('.map-page-loader').show();
            },
            data:{      
                _token: '{{ csrf_token() }}',         
                start:start,
                end:end
            },
            success:function(){
                toastr.success("Loads Processed successfully.");
                $('.map-page-loader').hide();
                window.location.reload(true);
            }
        });
    }
</script>
@endsection