Filament•8mo ago

Implementing Car Selection Logic in without using Session

I spent the entire day attempting to implement this logic without success. I have two models: 'CAR' and 'car_tenancy.' I only add car names to the 'car' resource. Currently, when I'm working on 'car_tenancy,' I want to ensure that if I select a car and return to create another entry, I shouldn't see the previously selected car. I've implemented the logic using 'session,' but I know it's not suitable for production. Could someone suggest an alternative? Here's a look at my code:

                        Forms\Components\Select::make('car_id')
                            ->options(function () {
                                // Retrieve selected car IDs from the session
                                $selectedCarIds = Session::get('selectedCarIds', []);
                                
                                // Filter out cars that have already been selected
                                $availableCars = Car::whereNotIn('id', $selectedCarIds)
                                    ->pluck('name', 'id')
                                    ->all();
                        
                                return $availableCars;
                            })
                            ->reactive()
                            ->required()
                            ->searchable()
                            ->preload()
                            ->required()
                            ->afterStateUpdated(function ( $set, $state) {
                                // Retrieve and update the selected car IDs in the session
                                $selectedCarIds = Session::get('selectedCarIds', []);
                                $selectedCarIds[] = $state;
                                Session::put('selectedCarIds', $selectedCarIds);
                        
                                $car = Car::find($state);
                                if ($car) {
                                }
                            }),

                        Forms\Components\Select::make('car_id')
                            ->options(function () {
                                // Retrieve selected car IDs from the session
                                $selectedCarIds = Session::get('selectedCarIds', []);
                                
                                // Filter out cars that have already been selected
                                $availableCars = Car::whereNotIn('id', $selectedCarIds)
                                    ->pluck('name', 'id')
                                    ->all();
                        
                                return $availableCars;
                            })
                            ->reactive()
                            ->required()
                            ->searchable()
                            ->preload()
                            ->required()
                            ->afterStateUpdated(function ( $set, $state) {
                                // Retrieve and update the selected car IDs in the session
                                $selectedCarIds = Session::get('selectedCarIds', []);
                                $selectedCarIds[] = $state;
                                Session::put('selectedCarIds', $selectedCarIds);
                        
                                $car = Car::find($state);
                                if ($car) {
                                }
                            }),

Solution:

Yes Solved ``` Forms\Components\Select::make('car_id') ->options(function () { $allocatedCars = CarTenancy::pluck('car_id')->toArray(); // Fetch available cars that are not allocated to any driver...

Jump to solution

3 Replies

sadiqgoni13•8mo ago

Can someone please help

Dennis Koch•8mo ago

So selected cars are the cars that already exist in another table? Why don’t you use a DB query to fetch them?

Solution

sadiqgoni13•8mo ago

Yes Solved

  Forms\Components\Select::make('car_id')
                        ->options(function () {
                            $allocatedCars = CarTenancy::pluck('car_id')->toArray();

                            // Fetch available cars that are not allocated to any driver
                            $availableCars = Car::whereNotIn('id', $allocatedCars)->get();

                            return $availableCars->pluck('name', 'id')->toArray();
                        })
                        ->reactive()
                        ->searchable()
                        ->preload()
                        ->required()

  Forms\Components\Select::make('car_id')
                        ->options(function () {
                            $allocatedCars = CarTenancy::pluck('car_id')->toArray();

                            // Fetch available cars that are not allocated to any driver
                            $availableCars = Car::whereNotIn('id', $allocatedCars)->get();

                            return $availableCars->pluck('name', 'id')->toArray();
                        })
                        ->reactive()
                        ->searchable()
                        ->preload()
                        ->required()

Gaming

Programming

Implementing Car Selection Logic in without using Session