Repeater slow

[juansimpledata]

Package

Panel builder

Package Version

3.2

How can we help you?

Hello, how are you? Greetings, I'm using the Repeater option for an invoice-type form. I've noticed it's very slow when I add products to the invoice header within Repeater. The server I'm working on has 8GB of RAM. How much memory do you recommend the server should have? Thank you very much in advance. I've attached the Repeater code:

                            TableRepeater::make('productratedetails')
                                ->relationship()
                                ->label('Productos')
                                ->schema([
            
                                    Forms\Components\Select::make('product_id')
                                    ->label('Producto')
                                    ->searchable()
                                    ->live(onBlur: true)
                                    ->afterStateUpdated(function (callable $set,$state,callable $get) {
                
                                        $Product=Product::where('id', $state)
                                            ->select('id', 'sku', 'price_one', 'name', 'main_image')
                                            ->first();
                                           
                                        $set('porcentaje','50');
                                        $set('product_id',$Product->id);
                                        $set('sku',$Product->sku);
                                        $set('cost_price',$Product->price_one);
                                        $set('description',$Product->name);
                                        $set('image_hidden',$Product->main_image);
                                        $set('img', asset("storage/".$Product->main_image));

                                        
                                    } )
                                    ->required()
                                    ->createOptionForm([
                                            
                                        Forms\Components\TextInput::make('name')
                                        ->required()
                                        ->label('Nombre / Descripción')
                                        ->maxLength(255),
        
                                        Forms\Components\TextInput::make('sku')
                                        ->required()
                                        ->live(onBlur: true)
                                        ->afterStateUpdated(function (string $operation, $state,  callable $set) {
                                            
                                            $Product = Product::where(DB::raw('UPPER(sku)'), strtoupper($state))->first();
        
                                            if($Product){
        
                                                Notification::make() 
                                                ->title('Notificación')
                                                ->danger()
                                                ->body('El Producto con el SKU: '.strtoupper($state).' se encuentra registrado; verifica los datos') 
                                                ->send(); 
        
                                            }else{
        
                                                session()->forget('name_image');
                                                session(['name_image' => strtoupper($state)]);
                                                
                                                Notification::make() 
                                                ->title('Notificación')
                                                ->warning()
                                                ->body(session('name_image')) 
                                                ->send(); 
        
                                            }
                    
                
                                        })
                                        ->label('SKU')
                                        ->maxLength(255),
        
                                        Forms\Components\TextInput::make('price_one')
                                        ->required()
                                        ->numeric()
                                        ->label('Precio'),
        
                                        Forms\Components\FileUpload::make('main_image')
                                        ->image()
                                        ->directory('product/images/main')
                                        ->visibility('public')
                                        ->label('Imagen Principal')
                                        ->imageEditor()
                                        ->imageEditorEmptyFillColor('#DB2777')
                                        ->reorderable()
                                        ->appendFiles()
                                        ->maxFiles(1)
                                        ->openable()
                                        ->downloadable()
                                        ->hint('Imagen principal del producto')
                                        ->hintIcon('heroicon-o-photo')
                                        ->getUploadedFileNameForStorageUsing(
                                            function (TemporaryUploadedFile $file){ 
                                                return substr(md5(date('Y-m-d H:i:s') . rand(0, 999999)), 0, 7).".".$file->getClientOriginalExtension();
                                            }
                                        ),
                                       
                                    ])->createOptionUsing(function ($data){
        
                                        $Product = Product::where(DB::raw('UPPER(sku)'), strtoupper($data['sku']))->first();
            
                                        if (!$Product) {
        
                                            $Product = new Product(
                                                [
                                                'company_id' => 1,
                                                'product_type_id' => 1,
                                                'product_classification_id' => 1,
                                                'brand_id' => 1,
                                                'commercialization_channel_id' => 1,
                                                'product_status_id' => 2,
                                                'name' => $data['name'],
                                                'sku' => $data['sku'],
                                                'main_image' => $data['main_image'],
                                                'description' => $data['name'],
                                                'available_stock' => 0,
                                                'security_stock' => 0,
                                                'price_one' => $data['price_one'],
                                                'price_two' => 0,
                                                'price_three' => 0,
                                                'price_four' => 0,
                                                'price_five' => 0,
                                                'price_six' => 0,
                                                'import_number' => "0",
                                                'availability' => 1,
                                                'comments' => "Generado a traves del modulo de cotizaciones",
                                                'user_id' => Auth::user()->id,
                                                'gamatype_id' => 1,
                        
                                            ]);
                                            $Product->save();
        
                                            Notification::make() 
                                            ->title('Notificación')
                                            ->success()
                                            ->body("Se ha generado un nuevo producto en el catálogo de productos para los efectos de la cotización. A continuación, se presentan los detalles del producto:
        
                                                    Nombre del Producto: ".$Product->description."
                                                    SKU: $Product->sku
                                                    Descripción: $Product->description
                                                    Precio: $Product->price_one
        
                                                Es importante destacar que este producto debe ser actualizado en el inventario posteriormente para garantizar que los datos estén coherentes y reflejen la disponibilidad real. Asegúrate de revisar y ajustar la información del inventario según sea necesario.") 
                                            ->send(); 
        
                                            return $Product->id;
        
                                        }else{
        
                                            Notification::make() 
                                            ->title('Notificación')
                                            ->danger()
                                            ->body('El Producto con el SKU: '.$data['sku'].' se encuentra registrado; verifica los datos') 
                                            ->send(); 
        
                                        }
        
                                    })
                                    //->distinct()
                                    ->options(function () {
                                        return Product::select('id', 'sku')->pluck('sku', 'id');
                                    }),
        
                                    Forms\Components\Hidden::make('sku')->default(Auth::user()->id),
            
                                    /*ViewField::make('productrate-image')
                                    ->label('Img')
                                    ->view('forms.components.productrate-image', [
                                        'min' => 1,
                                        'max' => 5,
                                        'myVariable' => fn (Productrate $record): string => $record->image_hidden, // Access attribute from the $record
                                    ]),*/

                                    ViewField::make('img')
                                        ->view('forms.components.productrate-image')
                                        ->formatStateUsing(function(callable $get) { //adds the initial state on page load
                                        return  asset("storage/".$get('image_hidden'));
                                        }),
                                    /*SomeInput::make('avatar') //this is the avatar picker
                                    ->live() //live update
                                    ->afterStateUpdated(function($state, Set $set) { //send state to image
                                        $set('image', $state); //you can alter the state here if needed (change to an url or similar)
                                    }),*/

                                    Forms\Components\TextInput::make('cost_price')
                                    ->maxLength(255)
                                    ->required()
                                    //->readOnly()
                                    ->label('Costo'),
            
                                    Select::make('porcentaje')
                                    ->options([
                                        '5' => '5%',
                                        '10' => '10%',
                                        '15' => '15%',
                                        '20' => '20%',
                                        '30' => '30%',
                                        '40' => '40%',
                                        '50' => '50%',
                                        '60' => '60%',
                                        '70' => '70%',
                                        '80' => '80%',
                                        '90' => '90%',
                                        '100' => '100%',
            
                                    ])
                                    ->required()
                                    ->live(onBlur: false),
                            
                                    Forms\Components\TextInput::make('sale_price')
                                    ->maxLength(255)
                                    //->required()
                                    ->readOnly()
                                    ->hidden(
                                        function (Component $livewire){
                                            if($livewire instanceof Pages\CreateProductrate){
                                                return true;
                                            }elseif($livewire instanceof Pages\EditProductrate){
                                                return false;
                                            }
                                        }
                                    )
                                    ->extraAttributes([
                                        'style' => 'border: 2px solid yellow;',
                                    ])
                                    ->label('Venta'),

                                    Forms\Components\TextInput::make('quantity')
                                    ->maxLength(255)
                                    ->required()
                                    ->live(onBlur: true)
                                    ->label('Cantidad'),

                                    Forms\Components\TextInput::make('subtotal')
                                    ->maxLength(255)
                                    //->required()
                                    ->extraAttributes([
                                        'style' => 'border: 2px solid yellow;',
                                    ])
                                    ->readOnly()
                                    ->hidden(
                                        function (Component $livewire){
                                            if($livewire instanceof Pages\CreateProductrate){
                                                return true;
                                            }elseif($livewire instanceof Pages\EditProductrate){
                                                return false;
                                            }
                                        }
                                    )
                                    ->label('Sub'),

                                    Forms\Components\TextInput::make('total')
                                    ->maxLength(255)
                                    //->required()
                                    ->extraAttributes([
                                        'style' => 'border: 2px solid yellow;',
                                    ])
                                    ->readOnly()
                                    ->hidden(
                                        function (Component $livewire){
                                            if($livewire instanceof Pages\CreateProductrate){
                                                return true;
                                            }elseif($livewire instanceof Pages\EditProductrate){
                                                return false;
                                            }
                                        }
                                    )
                                    ->label('Total'),
                            
                                    Forms\Components\Textarea::make('description')
                                    ->maxLength(65535)
                                    ->required()
                                    ->label('Descripción'),

                                    Forms\Components\Select::make('zone_id')
                                    ->label('Zona')
                                    ->required()
                                    ->searchable()
                                    ->createOptionForm([
            
                                        Forms\Components\TextInput::make('name')
                                        ->required()
                                        ->label('Nombre / Descripción')
                                        ->maxLength(255),
            
                                    ])->createOptionUsing(function ($data){
                                    $Zone = new Zone(
                                        [
                                        'name' => $data['name']
                                        ]);
                                    $Zone->save();
                                    return $Zone->id;
                                    })
                                    ->options(function(callable $get){
            
                                        return Zone::where('id','>',0)->pluck('name', 'id');
                                      
                                    }),

                                    Forms\Components\Toggle::make('availability')
                                        ->label('Disponibilidad')
                                        ->default(true)
                                        ->required()
                                        ->hidden(),
            
                                    Forms\Components\Hidden::make('user_id')->default(Auth::user()->id),
            
                                    Forms\Components\Hidden::make('image_hidden'),
            
                                    Forms\Components\Textarea::make('comments')
                                        ->maxLength(65535)
                                        ->hidden()
                                        ->label('Comentarios'),
            
                                ])->columns(7)
                                ->extraAttributes(['style' => 'width: 1200px;'])
                                ->defaultItems(1)
                                //->reorderableWithButtons()
                                //->collapsible()
                                //->cloneable()
                                ->orderColumn('sort')
                                ->deleteAction(
                                    fn (Action $action) => $action->requiresConfirmation(),
                                )
                                ->itemLabel(fn (array $state): ?string => $state['sku'] ?? null),