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