/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(CategoryRequest $request) { $category = Categories::create(array('creater_id' => Auth::id(), 'name' => $request->name)); $category->save(); $lists = MyAsset::where('user_id', Auth::id())->orderBy('id', 'desc')->get(); $categories = Categories::distinct()->select('name')->where('creater_id', Auth::id())->orderBy('id', 'desc')->get(); return view('myasset.index')->withLists($lists)->with('category', $categories); }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * * @return \Illuminate\Http\Response */ public function update(MyAssetRequest $request, $id) { $pre = MyAsset::findOrFail($id); $plus = $request->income - $pre->income; $minus = $request->expenditure - $pre->expenditure; $amount = $request->amount; $total = $amount + $plus - $minus; $differece = $plus - $minus; $myasset = MyAsset::where('id', $id)->update(array('name' => $request->name, 'category' => $request->category, 'income' => $request->income, 'expenditure' => $request->expenditure, 'amount' => $total, 'remark' => $request->remark)); MyAsset::where([['id', '>', $id], ['user_id', Auth::id()]])->increment('amount', $differece); return redirect('/myasset'); }