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;
}
