public function sumTransactions()
{
$mongodb = Connections::get('default')->connection;
$transactions = Transactions::connection()->connection->command(array('aggregate' => 'transactions', 'pipeline' => array(array('$project' => array('_id' => 0, 'amount' => '$amount', 'category' => '$category', 'account' => '$account', 'address' => '$address')), array('$group' => array('_id' => array('account' => '$account', 'category' => '$category', 'address' => '$address'), 'amount' => array('$sum' => '$amount'), 'count' => array('$sum' => 1))), array('$sort' => array('account' => 1, 'category' => 1)))));
return compact('transactions');
}
