/**
* Lists latest ten examples.
* @return \Illuminate\View\View
*/
public function index()
{
// Monthly statistics / totals.
$month = array('total' => 0, 'luxury' => 0, 'regular' => 0);
$month_expenses = Expense::query()->with('category')->where(DB::raw('MONTH(created_at)'), '=', date('n'))->get();
foreach ($month_expenses as $expense) {
$month['total'] += $expense->value;
if ($expense->category->luxury) {
$month['luxury'] += $expense->value;
}
}
$month['regular'] = $month['total'] - $month['luxury'];
// Last 10 expenses.
$expenses = Expense::query()->with('category')->orderBy('created_at', 'desc')->take(10)->get();
return view('dashboard.index', array('expenses' => $expenses, 'month' => $month));
}
/**
* Removes the expense.
* @param $id
*
* @return \Illuminate\Http\RedirectResponse
* @throws \Exception
*/
public function destroy($id)
{
$this->expense->query()->findOrFail($id)->delete();
return redirect()->route('expense.index');
}
