public function getAccountStatistics()
{
$account_statistics = array();
$transactions = Transaction::all();
$account_statistics['total'] = $transactions->where('type', 'cashback')->sum('amount');
$account_statistics['confirmed'] = $transactions->where('type', 'cashback')->where('status', 'Confirmed')->sum('amount');
$account_statistics['pending'] = $transactions->where('type', 'cashback')->where('status', 'Pending')->sum('amount');
$account_statistics['paid'] = $transactions->where('type', 'payment')->sum('amount');
$account_statistics['balance'] = $account_statistics['confirmed'] - $account_statistics['paid'];
return $account_statistics;
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
Transaction::destroy($id);
\Session::flash('status', 'The transaction has been deleted successfully.');
return redirect('admin/transactions');
}