/**
* 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');
}
