/** * Store a newly created resource in storage. * * @return Response */ public function store(ReceivingRequest $request) { $receivings = new Receiving(); $receivings->supplier_id = Input::get('supplier_id'); $receivings->user_id = Auth::user()->id; $receivings->payment_type = Input::get('payment_type'); $receivings->comments = Input::get('comments'); $receivings->save(); // process receiving items $receivingItems = ReceivingTemp::all(); foreach ($receivingItems as $value) { $receivingItemsData = new ReceivingItem(); $receivingItemsData->receiving_id = $receivings->id; $receivingItemsData->item_id = $value->item_id; $receivingItemsData->cost_price = $value->cost_price; $receivingItemsData->quantity = $value->quantity; $receivingItemsData->total_cost = $value->total_cost; $receivingItemsData->save(); //process inventory $items = Item::find($value->item_id); $inventories = new Inventory(); $inventories->item_id = $value->item_id; $inventories->user_id = Auth::user()->id; $inventories->in_out_qty = $value->quantity; $inventories->remarks = 'RECV' . $receivings->id; $inventories->save(); //process item quantity $items->quantity = $items->quantity + $value->quantity; $items->save(); } //delete all data on ReceivingTemp model ReceivingTemp::truncate(); $itemsreceiving = ReceivingItem::where('receiving_id', $receivingItemsData->receiving_id)->get(); Session::flash('message', 'You have successfully added receivings'); //return Redirect::to('receivings'); return view('receiving.complete')->with('receivings', $receivings)->with('receivingItemsData', $receivingItemsData)->with('receivingItems', $itemsreceiving); }
public static function receiving_detailed($receiving_id) { $receivingitems = ReceivingItem::where('receiving_id', $receiving_id)->get(); return $receivingitems; }