help in form input calculated value from other fields

[fateh-dris]

hello, i need help setting the value of a field ( total amount of an order ) based on each products unit price * quantity inside a repeater in this example i want to calculate the order amount by doing 2 * 800 + 1 * 1000 = 2600

heres my code:
public static function form(Form $form): Form
{
return $form
->columns(3)
->schema([
Fieldset::make('Order Info')
->columns(5)
->schema([
TextInput::make('customer')
->required()
->maxLength(255)
->columnSpan(2)
->disabled(),
TextInput::make('phone_number')
->tel()
->required()
->columnSpan(1)
->disabled()
->columnSpan(1),
DatePicker::make('created_at')
->disabled()
->columnSpan(1),
TextInput::make('amount')
->required()
->columnSpan(1)
->disabled()
->columnSpan(1),
]),
Repeater::make('products')
->disableItemCreation()
->relationship()
->columns(5)
->columnSpan(3)
->schema([
Select::make('product_id')
->label('Product')
->options(Product::withoutTrashed()->pluck('name', 'id'))
->columnSpan(3)
->disabled(),
TextInput::make('quantity')
->columnSpan(1)
->disabled(),
TextInput::make('price')
->label('Unit Price')
->columnSpan(1)
->disabled(),
]),
]);
}

[danharrin]

Amount should be a Placeholder, not a real TextInput. It can be dynamically calculated based on the items.

Placeholder::make('amount')
    ->content(function ($get) {
        // Use $get('products') to get an array of items.
        // Loop through each item and make a total
        // Return the total from this function
    })

[fateh-dris]

thanx @danharrin you guided me to the right answer i did this
->content(function ($get) {
$sum = 0;
foreach ($get('products') as $product) {
$sum = $sum + ($product['price'] * $product['quantity']);
}
return $sum;
})

[nepriantodeveloper]

Placeholder::make('amount')
->content(function ($get) {
$sum = 0;
foreach ($get('order_details') as $product) {
$sum = $sum + ($product['harga'] * $product['qty']);
}
return $sum;
}),

[alancarlosml]

Nice. I was facing the same problem and I solved it using this solution. However, how can I get the value of the 'amount' field to make other calculations or save it in the database? I haven't been able to get a placeholder value.

[danharrin]

You cant get the placeholder value, you just calculate it again from the rest of the data

[alancarlosml]

Ok, but I have a specific situation. When I add more lines to the repeater, the subtotal value updates correctly. The total value only updates when I add a discount value. However, when I remove some of those repeater lines or change a value in the Value field, the subtotal value updates normally, but the total value remains the same.

I have a hidden input that assists me during the update.

The image below shows the situation before removing a repeater line:

After:

And this one the code;

public static function form(Form $form): Form
    {
        $form
            ->schema([
                Card::make()->schema([
                    Forms\Components\Repeater::make('items')
                        ->relationship('items')
                        ->schema([
                            Forms\Components\Select::make('product_id')
                                ->label('Product')
                                ->placeholder('Select')
                                ->options(Product::select(DB::raw("CONCAT(id, ' - ', description) AS description"), 'id')->where('status', 1)->pluck('description', 'id'))
                                ->searchable()
                                ->reactive()
                                ->afterStateUpdated(function ($state, callable $set) {
                                    $product = Product::find($state);
                                    if ($product) {
                                        $set('unit_value', number_format($product->unit_value, 2));
                                    }
                                }),
                            Forms\Components\Select::make('size_id')
                                ->options(Size::select(DB::raw("CONCAT(sigla, ' - ', description) AS sigla"), 'id')->where('status', 1)->pluck('sigla', 'id'))
                                ->label('Size')
                                ->searchable()
                                ->placeholder('Select'),
                            Forms\Components\Select::make('cloth_id')
                                ->placeholder('Select')
                                ->label('Cloth')
                                ->options(Cloth::select(DB::raw("CONCAT(id, ' - ', description) AS description"), 'id')->where('status', 1)->pluck('description', 'id'))
                                ->searchable(),
                            Forms\Components\TextInput::make('quantity')
                                ->reactive()
                                ->numeric()
                                ->label('Qtd')
                                ->afterStateUpdated(function ($state, callable $set, Closure $get) {
                                    $set('subtotal_hidden', floatval($get('quantity')) * floatval($get('unit_value')));
                                    $fields = $get('../../items');
                                    $sum = 0;
                                    foreach ($fields as $field) {
                                        $value = $field['subtotal_hidden'];
                                        if ($value == "") {
                                            $value = 0;
                                        }
                                        $sum += $value;
                                    }
                                    $set('subtotal', number_format((float)$sum, 2, ',', ''));
                                    $set('total', number_format((float) ($sum - $get('../../discount')), 2, ',', ''));
                                }),
                            Forms\Components\TextInput::make('unit_value')->numeric()
                                ->label('Value')
                                ->required()
                                ->reactive()
                                ->afterStateUpdated(function ($state, callable $set, Closure $get) {
                                    $set('subtotal_hidden', floatval($get('quantity')) * floatval($get('unit_value')));
                                    $fields = $get('../../items');
                                    $sum = 0;
                                    foreach ($fields as $field) {
                                        $value = $field['subtotal_hidden'];
                                        if ($value == "") {
                                            $value = 0;
                                        }
                                        $sum += $value;
                                    }
                                    $set('subtotal', number_format((float)$sum, 2, ',', ''));
                                }),
                            Forms\Components\Hidden::make('subtotal_hidden')->reactive(),
                            Forms\Components\TextInput::make('description')->label('Description'),
                        ])
                        ->columns(6)->createItemButtonLabel('Add'),
                    Forms\Components\TextInput::make('tax')->numeric()
                        ->numeric()
                        ->label('Delivery tax')
                        ->required(),
                    Forms\Components\Grid::make(3)
                        ->schema([
                            Forms\Components\TextInput::make("subtotal")
                                ->label("Subtotal")
                                ->numeric()
                                ->disabled()
                                ->reactive()
                                ->placeholder(
                                    function (Closure $get) {
                                        $fields = $get('items');
                                        $sum = 0;
                                        foreach ($fields as $field) {
                                            $value = $field['subtotal_hidden'];
                                            if ($value == "") {
                                                $value = 0;
                                            }
                                            $sum += $value;
                                        }
                                        return number_format((float)$sum, 2, ',', '');
                                    }
                                ),
                            Forms\Components\TextInput::make('discount')
                                ->numeric()
                                ->reactive()
                                ->afterStateUpdated(function (Closure $set, $state) {
                                    $set('total', function (Closure $get) {
                                        $fields = $get('items');
                                        $sum = 0;
                                        foreach ($fields as $field) {
                                            $value = $field['subtotal_hidden'];
                                            if ($value == "") {
                                                $value = 0;
                                            }
                                            $sum += $value;
                                        }
                                        return $sum - $get('discount');
                                    });
                                })
                                ->label('Discount'),
                                
                            Forms\Components\TextInput::make('total')
                                ->numeric()
                                ->label('Total')
                                ->required(),
                        ]),
                ])
            ]);
        return $form;
    }

How can I address this issue?

[danharrin]

I don't suggest using a hidden input as they can be changed by the user using the browser console, this issue shouldn't be there if you have a truly reactive form schema that uses Placeholders and dynamic calculations everywhere

[mwanjoge]

I think there should be an easy way to set values in TextInput like the way we can set options in select just a method to add text box value i.e value() an may be all form field should have this method it would be useful. my situation is that i need to put a value where user is allowed to change so placeholder may be not good idea for simple thing like this

[mwanjoge]

You cant get the placeholder value, you just calculate it again from the rest of the data
how to do this?