Filament•7mo ago

Repeater Calculate all quantity fields

Please, how do I get each individual quantity fields as well as the product id. Essentially, I want to use the product id to get the product product price based on the quantity, then calculate the cost and sum the individual cost of the product and put the sum in the placeholder below.

Solution:

I was able to get it solve after looking at the documentation. Below is my solution. ``` Forms\Components\Select::make('store_id') ->relationship('store', 'name') ...

Jump to solution

1 Reply

Solution

smartnathan•7mo ago

I was able to get it solve after looking at the documentation. Below is my solution.

Forms\Components\Select::make('store_id')
->relationship('store', 'name')                      
->preload()            
->searchable()               
->required(),

Repeater::make('sales_items')->schema([
//The form products select and quantity textinput fields comes in here
])->live()                   
->afterStateUpdated(function (Get $get, Set $set) {
                                $total = 0;
                                $store_id = $get('store_id');
                                foreach ($get('sales_items') as $item) {
                                    $product = StockAvailabilityStatus::where('product_id', $item['product_id'])->where('store_id', $store_id)->first();
                                    if ($product && $item['quantity']) {
                                        $total += $product->bulk_selling_price * $item['quantity'];
                                    }
                                }
                           $set('formatted_total_amount', '₦' . number_format($total, 2));
                            })

Forms\Components\Select::make('store_id')
->relationship('store', 'name')                      
->preload()            
->searchable()               
->required(),

Repeater::make('sales_items')->schema([
//The form products select and quantity textinput fields comes in here
])->live()                   
->afterStateUpdated(function (Get $get, Set $set) {
                                $total = 0;
                                $store_id = $get('store_id');
                                foreach ($get('sales_items') as $item) {
                                    $product = StockAvailabilityStatus::where('product_id', $item['product_id'])->where('store_id', $store_id)->first();
                                    if ($product && $item['quantity']) {
                                        $total += $product->bulk_selling_price * $item['quantity'];
                                    }
                                }
                           $set('formatted_total_amount', '₦' . number_format($total, 2));
                            })

Gaming

Programming

Repeater Calculate all quantity fields