| */ Route::group(['middleware' => ['web']], function () { Route::get('/', function () { $base = DB::table('statements')->orderBy('created_at', 'desc')->groupBy('account_id'); $recent = $base->get(); $assets = array_filter($recent, function ($e) { return $e->balance > 0; }); $debts = array_filter($recent, function ($e) { return $e->balance < 0; }); $sum = function ($a) { return array_sum(array_map(function ($e) { return $e->balance; }, $a)); }; return view('index', ['recent' => $recent, 'net' => $sum($recent), 'assets' => $sum($assets), 'debts' => $sum($debts)]); }); Route::post('/statement', function (FormRequest $request) { $validator = Validator::make($request->all(), ['account_id' => 'required|numeric', 'balance' => 'required|numeric']); if ($validator->fails()) { return redirect('/')->withInput()->withErrors($validator); } $statement = new Statement(); $statement->account_id = $request->account_id; $statement->balance = $request->balance; $statement->save(); return redirect('/'); }); });
/** * Update the specified resource in storage. * * @param Request $request * @param int $id * @return Response */ public function update(Request $request, $id) { $statement = \App\Statement::find($id)->update($request->all()); return redirect('statement/')->with('message', 'Statement Updated'); }
public function statementView($id) { $data['statementId'] = $id; $data['statementData'] = Statement::findstatementdata($id); return View::make('admin.statementView', $data); }