public function newItem(Requests\CreateInvoiceItemRequest $request) { $input = Request::all(); $salesId = $input['salesId']; $saleItem = new InvoiceItem(); $saleItem->quantity = $input['quantity']; $saleItem->unit_price = $input['unit_price']; $saleItem->item_id = $input['item_id']; $saleItem->sales_invoice_id = $salesId; $saleItem->total_price = $input['quantity'] * $input['unit_price']; $saleItem->save(); $items = InvoiceItem::where('sales_invoice_id', $salesId)->get(); $total_amount = 0; foreach ($items as $item) { $invoiceItem = InvoiceItem::find($item->id); $total_amount += $invoiceItem->total_price; } $salesInvoice = $saleItem->salesInvoice; $salesInvoice->update(['total_amount' => $total_amount]); return redirect()->action('SalesInvoicesController@edit', [$salesInvoice->id]); }