Level 73
What is it that you are trying to do?
Nov 8, 2022
8
Level 1
how can i subtract a variable from variable exists in other table
like this
public function store(Request $request)
{
$this->validate($request,[
'personal_id'=>'required|exists:customers,personal_id',
'test_id'=>'required|exists:tests,id',
'amount'=>'required|integer',
'date'=>'required'
]);
$ptest = Finance::create([
'customer_id' => customer::where('personal_id', $request->personal_id)->first()->id,
'test_id' => Test::findOrFail($request->id)->id,
'date' => $request->date,
'amount'=>$request->amount,
'remaining'=>$request->amount-$request->test->payment,
'note'=>$request->note
]);
Level 1
@Tray2 payment is a variable in other table i want to subtract it from variable amount and print the result in remaining
Level 73
@mohammadkhallaf I suggest handling that display in the front end for the display, and then update the table.
Level 3
@mohammadkhallaf Where is test in $request? Are you sure request has test parameter? ($request->test)
Level 1
@mubeensaeed test is the model that have anothe var no i how i can fetch the var from another model or table
Level 3
@mohammadkhallaf Get specific test first using $request->id, then use that test's payment $test = Test::findOrFail($request->id)->id; $payment = $test->payment;
Level 1
@mubeensaeed can you write it more clearly
Level 3
@mohammadkhallaf Like this:
$test = Test::findOrFail($request->id);
$ptest = Finance::create([
'customer_id' => customer::where('personal_id', $request->personal_id)->first()->id,
'test_id' => test->id,
'date' => $request->date,
'amount'=>$request->amount,
'remaining'=>$request->amount-$test->payment,
'note'=>$request->note
]);
Please or to participate in this conversation.