public function dashboard() { if ($this->request->query['json'] == true) { $this->_render['type'] = 'json'; } $user = Session::read('default'); $id = $user['_id']; if ($user == "") { return $this->redirect('/login'); exit; } $details = Details::find('first', array('conditions' => array('user_id' => $id))); $trades = Trades::find('all'); $YourOrders = array(); foreach ($trades as $t) { $YourOrders['Buy'] = $this->YourOrders($id, 'Buy', substr($t['trade'], 0, 3), substr($t['trade'], 4, 3)); $YourOrders['Sell'] = $this->YourOrders($id, 'Sell', substr($t['trade'], 0, 3), substr($t['trade'], 4, 3)); $YourCompleteOrders['Buy'] = $this->YourCompleteOrders($id, 'Buy', substr($t['trade'], 0, 3), substr($t['trade'], 4, 3)); $YourCompleteOrders['Sell'] = $this->YourCompleteOrders($id, 'Sell', substr($t['trade'], 0, 3), substr($t['trade'], 4, 3)); } $Commissions = $this->TotalCommissions($id); $CompletedCommissions = $this->CompletedTotalCommissions($id); $RequestFriends = $this->RequestFriend($id); $UsersRegistered = Details::count(); $functions = new Functions(); $OnlineUsers = $functions->OnlineUsers(); foreach ($trades as $t) { $TotalOrders['Buy'] = $this->TotalOrders($id, 'Buy', substr($t['trade'], 0, 3), substr($t['trade'], 4, 3)); $TotalOrders['Sell'] = $this->TotalOrders($id, 'Sell', substr($t['trade'], 0, 3), substr($t['trade'], 4, 3)); $TotalCompleteOrders['Buy'] = $this->TotalCompleteOrders($id, 'Buy', substr($t['trade'], 0, 3), substr($t['trade'], 4, 3)); $TotalCompleteOrders['Sell'] = $this->TotalCompleteOrders($id, 'Sell', substr($t['trade'], 0, 3), substr($t['trade'], 4, 3)); } $title = "Dashboard"; $keywords = "Dashboard, trading platform, bitcoin exchange, we trust, United Kingdom, UK"; $description = "Dashboard for trading platform for bitcoin exchange in United Kingdom, UK"; $settings = Settings::find('first'); return compact('title', 'details', 'YourOrders', 'Commissions', 'CompletedCommissions', 'YourCompleteOrders', 'RequestFriends', 'UsersRegistered', 'OnlineUsers', 'TotalOrders', 'TotalCompleteOrders', 'keywords', 'description', 'settings'); }
public function listusers() { $ParentDetails = Details::find('all'); $i = 0; foreach ($ParentDetails as $pd) { $left = $pd['left']; $right = $pd['right']; $NDCount = Details::count(array('left' => array('$lt' => $left), 'right' => array('$gt' => $right))); $userlist[$i]['count'] = $NDCount; $username = Users::find('all', array('conditions' => array('_id' => $pd['user_id']))); foreach ($username as $u) { $userlist[$i]['username'] = $u['username']; } $i++; } /* $mongodb = Connections::get('default')->connection; $details = Details::connection()->connection->command(array( 'aggregate' => 'details', 'pipeline' => array( array('$group' => array( '_id' => array( 'parent'=>array( 'puser_id'=>'$user_id', 'pleft'=>'$left', 'pright'=>'$right', ), ) ), '$group' =>array( '_id' => '$user_id', 'count' => array('$sum' => 1), 'puser'=>'$parent.puser_id' ), ), ) )); */ return array($userlist); }
public function detail($username = null) { if ($this->__init() == false) { $this->redirect('ex::dashboard'); } $transactions = Transactions::find('all', array('conditions' => array('username' => $username, 'Currency' => 'BTC'), 'order' => array('DateTime' => 'DESC'))); $transactionsXGC = Transactions::find('all', array('conditions' => array('username' => $username, 'Currency' => 'XGC'), 'order' => array('DateTime' => 'DESC'))); $Fiattransactions = Transactions::find('all', array('conditions' => array('username' => $username, 'Currency' => array('$nin' => array('BTC', 'XGC'))), 'order' => array('DateTime' => -1))); $details = Details::find('all', array('conditions' => array('username' => $username))); $userdetail = Details::find('first', array('conditions' => array('username' => $username))); $id = $userdetail['user_id']; $user = Users::find('all', array('conditions' => array('username' => $username))); $logins = Logins::find('first', array('conditions' => array('username' => $username), 'order' => array('DateTime' => -1))); $loginCount = Logins::find('count', array('conditions' => array('username' => $username))); $UserOrders = Orders::find('all', array('conditions' => array('username' => $username, 'Completed' => 'N'), 'order' => array('DateTime' => -1))); $UserCompleteOrders = Orders::find('all', array('conditions' => array('username' => $username, 'Completed' => 'Y'), 'order' => array('DateTime' => -1))); $title = "Detail user"; $keywords = "Admin, Detail user"; $description = "Admin Panel for user"; $trades = Trades::find('all'); $ex = new ExController(); $YourOrders = array(); foreach ($trades as $t) { $YourOrders['Buy'] = $ex->YourOrders($id, 'Buy', substr($t['trade'], 0, 3), substr($t['trade'], 4, 3)); $YourOrders['Sell'] = $ex->YourOrders($id, 'Sell', substr($t['trade'], 0, 3), substr($t['trade'], 4, 3)); $YourCompleteOrders['Buy'] = $ex->YourCompleteOrders($id, 'Buy', substr($t['trade'], 0, 3), substr($t['trade'], 4, 3)); $YourCompleteOrders['Sell'] = $ex->YourCompleteOrders($id, 'Sell', substr($t['trade'], 0, 3), substr($t['trade'], 4, 3)); } $Commissions = $ex->TotalCommissions($id); $CompletedCommissions = $ex->CompletedTotalCommissions($id); $RequestFriends = $ex->RequestFriend($id); $UsersRegistered = Details::count(); $functions = new Functions(); $OnlineUsers = $functions->OnlineUsers(); foreach ($trades as $t) { $TotalOrders['Buy'] = $ex->TotalOrders($id, 'Buy', substr($t['trade'], 0, 3), substr($t['trade'], 4, 3)); $TotalOrders['Sell'] = $ex->TotalOrders($id, 'Sell', substr($t['trade'], 0, 3), substr($t['trade'], 4, 3)); $TotalCompleteOrders['Buy'] = $ex->TotalCompleteOrders($id, 'Buy', substr($t['trade'], 0, 3), substr($t['trade'], 4, 3)); $TotalCompleteOrders['Sell'] = $ex->TotalCompleteOrders($id, 'Sell', substr($t['trade'], 0, 3), substr($t['trade'], 4, 3)); } return compact('title', 'transactions', 'transactionsXGC', 'details', 'user', 'UserOrders', 'Fiattransactions', 'UserCompleteOrders', 'title', 'keywords', 'description', 'logins', 'loginCount', 'YourOrders', 'YourCompleteOrders', 'Commissions', 'CompletedCommissions', 'TotalOrders', 'TotalCompleteOrders'); }