I have a details table in my database that contains the number of rows.
See below. Divided into two rows, one column contains Rs 1250, 1250. I showed a total of 2500. But when the user wants to use the full total I want to update the data in two columns, how to update these two rows in laravel?
$wallet_details = tbl_wallet_detail::where('wd_parent_id', $usewallet->wm_id)
->whereMonth('tbl_wallet_details.wd_start_date', date('m'))
->whereYear('tbl_wallet_details.wd_start_date', date('Y'))->first();
$wallet_details->wd_used_amount = $wallet_details->wd_used_amount + $request->usewallet;
$wallet_details->wd_remaining_amount = $wallet_details->wd_remaining_amount - $request->usewallet;
$wallet_details->save();
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
I don't know all the details of your use case (e.g. how do you get the amount
userhas used), however, one way to solve your problem is outlined below.I created a
Walletmodel and associated table for this example and defined ausedcolumn on it to represent the amount used, and similarremaining columns. Obviously, you can replace these with your specific information.$wallet = \App\Models\Wallet::where('user_id', 1) ->selectRaw('sum(used) as total') ->groupBy('used') ->first(); $remaining = $wallet->total - 1500; \App\Models\Wallet::where('user_id', 1) ->update([ 'remaining' => $remaining / $wallet->count() ]);- First, we run the query to
- Next we calculate the
Finally, we update the - remaining
As mentioned above it's up to you how to get the relevant rows from the table, usingsum(total)theusedfield values for a givenuser$remainingamount by subtracting the amount used (in your example 1500) from the total amount obtained in step 1columnsfor each row in the table for a givenuseruser_id
is just an example but you can usetransaction idor whatever makes sense for your use case .