F
Filament•14mo ago
sadiqgoni13

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
sadiqgoni13OP•14mo ago
Can someone please help
Dennis Koch
Dennis Koch•14mo 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
sadiqgoni13•14mo 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()

Did you find this page helpful?