CODEWITHSUNDEEP
mysqllaravel
Abhishek kumar
Abhishek kumar

Reputation: 21

How we substract two column and store in another column in laravel,i am new in laravel

I have 3 columns in database:

I want

dues=fee-(first_installement+second_installement+third_installement)

My controller

$patientfee=AddPatient::find($patient_id);
$a->fee_id=$request->input('fee_id');
$b->first_installement=$request->input('first_installement');
$c->second_installement=$request->input('second_installement');
$d->third_installement=$request->input('third_installement');
$e->dues=$request->input('dues');

$e=$a-($b+$c+$d);

$patientfee->update();
return redirect('/patient-list')->with('status','Fee Successfully  updated');

Upvotes: 2

Views: 67

Answers (1)

Amit Senjaliya
Amit Senjaliya

Reputation: 2945

You can do that like first retrieve column values from AddPatient and then subtract.

$patientfee=AddPatient::findOrFail($patient_id);
$fee = $patientfee->fee;
$first_installement = $patientfee->first_installement;
$second_installement = $patientfee->second_installement;
$third_installement = $patientfee->third_installement;

$dues = $fee - ($first_installement+$second_installement+$third_installement);
$patientfee->dues = $dues;
$patientfee->update();
return redirect('/patient-list')->with('status','Fee Successfully  updated');

Upvotes: 1

Related Questions