<?php

namespace App\DataTables\Transporter;

use App\Models\BookingRide;
use App\Models\Ride;
use Illuminate\Database\Eloquent\Builder as QueryBuilder;
use Yajra\DataTables\EloquentDataTable;
use Yajra\DataTables\Html\Builder as HtmlBuilder;
use Yajra\DataTables\Html\Button;
use Yajra\DataTables\Html\Column;
use Yajra\DataTables\Html\Editor\Editor;
use Yajra\DataTables\Html\Editor\Fields;
use Yajra\DataTables\Services\DataTable;

class RideDataTable extends DataTable
{
    /**
     * Build the DataTable class.
     *
     * @param QueryBuilder<Ride> $query Results from query() method.
     */
    public function dataTable(QueryBuilder $query): EloquentDataTable
    {
        return (new EloquentDataTable($query))
            ->addIndexColumn()
            ->editColumn('booking_code', function ($row) {
                if ($row->booking) {
                    $url = route('booking.view', encrypt($row->booking->id)); // apna route lagao
                    return '<a href="' . $url . '">' . $row->booking->booking_code . '</a>';
                }
            })
            ->addColumn('no_of_passengers', function ($row) {
                if (!empty($row->booking->no_of_passengers)) {
                    return $row->booking->no_of_passengers ?? '-';
                }
                return '-';
            })
            ->addColumn('ride_type', function ($row) {
                if (!empty($row->booking->ride_type)) {
                    return $row->booking->ride_type_name ?? '-';
                }
                return '-';
            })
            ->addColumn('ride_date', function ($row) {
                return !empty($row->ride_date)
                    ? \Carbon\Carbon::parse($row->ride_date)->format('M d, Y') // Aug 25, 2025
                    : '-';
            })
            ->addColumn('pickup_time', function ($row) {
                if (!empty($row->pickup_time)) {
                    return date('h:i A', strtotime($row->pickup_time));
                }
                return '-';
            })
            ->addColumn('pickup_location', function ($row) {
                return $row->locations['pickup_location'] ?? '-';
            })
            ->addColumn('drop_location', function ($row) {
                return $row->locations['drop_location'] ?? '-';
            })
            ->addColumn('fare', function ($row) {
                if (isset($row)) {
                    return '₹ ' . number_format($row->fare, 2);
                }
                return null;
            })
            ->addColumn('vehicle', function ($row) {
                if (isset($row->vehicle)) {
                    return $row->vehicle->registration_number;
                }
                return 'Not Assigned';
            })
            ->addColumn('driver', function ($row) {
                if (isset($row->driver)) {
                    return $row->driver->name;
                }
                return 'Not Assigned';
            })
            ->addColumn('status', function ($row) {
                switch ($row->status) {
                    case 0:
                        return '<span class="badge badge-warning text-white" style="font-size: medium">Pending</span>';
                    case 1:
                        return '<span class="badge badge-dark text-white" style="font-size: medium">Assigned</span>';
                    case 2:
                        return '<span class="badge badge-info text-white" style="font-size: medium">Ongoing</span>';
                    case 3:
                        return '<span class="badge badge-success text-white" style="font-size: medium">Completed</span>';
                    case 4:
                        return '<span class="badge badge-primary text-white" style="font-size: medium">Cancelled</span>';
                    default:
                        return '<span class="badge badge-secondary text-white" style="font-size: medium">Unknown</span>';
                }
            })
            ->addColumn('created_at', function ($row) {
                return date('d-m-Y', strtotime($row->created_at));
            })
            ->addColumn('action', function ($row) {
                $buttons = '<div class="table-actions d-flex gap-1">';

                // View Button
                $buttons .= '
                    <a href="' . route('rides.view', encrypt($row->id)) . '" 
                    class="btn btn-primary btn-sm" title="View">
                        <i class="fa fa-eye"></i>
                    </a>';

                // ONGOING -> Request Admin Button
                if ($row->status == \App\Models\BookingRide::ONGOING) {
                    $buttons .= '
                        <button type="button" 
                            data-id="' . encrypt($row->id) . '" 
                            data-toggle="modal" 
                            data-target="#reasonModal" 
                            class="btn btn-warning btn-sm request-admin" 
                            title="Request Admin">
                            <i class="fa fa-question-circle"></i>
                        </button>';
                } else {
                    // Assign / Re-Assign Buttons
                    $assigned = $row->driver_id && $row->vehicle_id;

                    if ($assigned) {
                        $buttons .= '
                            <button type="button" 
                                data-id="' . encrypt($row->id) . '" 
                                data-driver="' . $row->driver_id . '" 
                                data-vehicle="' . $row->vehicle_id . '"
                                data-vehicle-type="' . $row->booking->vehicle_preferred . '" 
                                data-toggle="modal" data-target="#assignModal"
                                onclick="openAssignModal(\'' . encrypt($row->id) . '\', \'' . $row->driver_id . '\', \'' . $row->vehicle_id . '\')"
                                class="btn btn-warning btn-sm assign" 
                                title="Re-Assign">
                                <i class="fa fa-refresh"></i>
                            </button>';
                    } else {
                        $buttons .= '
                            <button type="button" 
                                data-url="' . route('rides.assign', encrypt($row->id)) . '" 
                                data-id="' . encrypt($row->id) . '"
                                data-vehicle-type="' . $row->booking->vehicle_preferred . '" 
                                data-toggle="modal" data-target="#assignModal"
                                onclick="openAssignModal(\'' . encrypt($row->id) . '\')"
                                class="btn btn-dark btn-sm assign" 
                                title="Assign">
                                <i class="fa fa-user-plus"></i>
                            </button>';
                    }
                }

                $buttons .= '</div>';
                return $buttons;
            })
            ->filterColumn('driver', function ($query, $keyword) {
                $keyword = strtolower(trim($keyword));
                if ($keyword == 'assigned') {
                    $query->whereNotNull('driver_id');
                } elseif ($keyword == 'non-assigned') {
                    $query->whereNull('driver_id');
                }
            })
            ->filterColumn('vehicle', function ($query, $keyword) {
                $keyword = strtolower(trim($keyword));
                if ($keyword == 'assigned') {
                    $query->whereNotNull('vehicle_id');
                } elseif ($keyword == 'non-assigned') {
                    $query->whereNull('vehicle_id');
                }
            })
            ->rawColumns(['status', 'booking_code', 'action'])
            ->setRowId('id');
    }

    /**
     * Get the query source of dataTable.
     *
     * @return QueryBuilder<Ride>
     */
    public function query(BookingRide $model): QueryBuilder
    {
        $transporterId = auth()->guard('trans')->user()->id;
        $query = $model->newQuery();
        $status = request('status');
        if ($status !== null && $status !== '') {
            $query->where('status', $status);
        }

        if ($driver = request('driver')) {
            if ($driver === 'assigned') {
                $query->whereNotNull('driver_id');
            } elseif ($driver === 'non-assigned') {
                $query->whereNull('driver_id');
            }
        }

        if ($vehicle = request('vehicle')) {
            if ($vehicle === 'assigned') {
                $query->whereNotNull('vehicle_id');
            } elseif ($vehicle === 'non-assigned') {
                $query->whereNull('vehicle_id');
            }
        }
        if ($rideDate = request('ride_date')) {
            $query->where('ride_date', $rideDate);
        }
        return $query->where('transporter_id', $transporterId)->orderBy('ride_date', 'asc')
            ->orderBy('pickup_time', 'asc');
    }

    /**
     * Optional method if you want to use the html builder.
     */
    public function html(): HtmlBuilder
    {
        return $this->builder()
            ->setTableId('ride-table')
            ->setTableAttribute('class', 'table table-striped table-bordered dt-responsive nowrap jambo_table bulk_action')
            ->columns($this->getColumns())
            ->minifiedAjax(route('rides.index', [], true), null, [
                'status' => 'function(){ return $("#statusFilter").val(); }',
                'driver' => 'function(){ return $("#driverFilter").val(); }',
                'vehicle' => 'function(){ return $("#vehicleFilter").val(); }',
                'ride_date' => 'function(){ return $("#rideDateFilter").val(); }',
            ])
            ->orderBy(1)
            ->selectStyleSingle()
            ->responsive(true)
            ->autoWidth(false)
            ->buttons([
                // Button::make('excel'),
                // Button::make('csv'),
                // Button::make('pdf'),
                // Button::make('print'),
                // Button::make('reset'),
                // Button::make('reload')
            ]);
    }

    /**
     * Get the dataTable columns definition.
     */
    protected function getColumns(): array
    {
        return [
            Column::computed('control')
                ->title('')
                ->exportable(false)
                ->printable(false)
                ->width(30)
                ->addClass('control')
                ->orderable(false)
                ->searchable(false)
                ->data('control')
                ->defaultContent(''),
            // Column::make('DT_RowIndex')->title('S.No')->orderable(false)->searchable(false),
            Column::make('booking_code')->title('Booking Code')->orderable(false)->addClass('all'),
            Column::make('ride_type')->title('Ride Type')->addClass('all'),
            Column::make('ride_date')->title('Ride Date'),
            Column::make('pickup_time')->title('Pickup Time'),
            Column::make('pickup_location')->title('Pickup Location'),
            Column::make('drop_location')->title('Drop Location'),
            Column::make('distance_km')->title('Distance (km)')->addClass('none'),
            Column::make('fare')->title('Total Fare'),
            Column::make('no_of_passengers')->title('Passenger')->addClass('none'),
            Column::make('vehicle')->title('Vehicle')->searchable(true),
            Column::make('driver')->title('Driver')->searchable(true),
            Column::make('status')->title('Status')->addClass('all'),
            Column::computed('action')
                ->exportable(false)
                ->printable(false)
                ->width(120)
                ->addClass('text-center all'),
        ];
    }


    /**
     * Get the filename for export.
     */
    protected function filename(): string
    {
        return 'Ride_' . date('YmdHis');
    }
}