Exemplo n.º 1
0
 public static function statistics()
 {
     $started = strtotime(SQL::queryCell('SELECT "time" FROM "journal" WHERE id = 1'));
     $invested = (int) SQL::queryCell('SELECT count(*) FROM "node"');
     return ['Started' => date('d-m-Y', $started), 'Running days' => floor((time() - $started) / (3600 * 24)), 'Users' => User::find()->count(), 'Total deposited' => Invoice::find()->where(['or', ['status' => 'success'], ['status' => 'delete']])->andWhere('amount > 0')->sum('amount'), 'Total withdraw' => -Invoice::find()->where(['or', ['status' => 'success'], ['status' => 'delete']])->andWhere('amount < 0')->sum('amount'), 'Number of investments' => $invested];
 }
Exemplo n.º 2
0
 public function actionAccount()
 {
     return $this->render('account', ['model' => SQL::queryObject('SELECT * FROM "account"')]);
 }