| Line 21... |
Line 21... |
| 21 |
}
|
21 |
}
|
| 22 |
|
22 |
|
| 23 |
public function dashboard(){
|
23 |
public function dashboard(){
|
| 24 |
$this->loadModel('User');
|
24 |
$this->loadModel('User');
|
| 25 |
//daily userbase
|
25 |
//daily userbase
|
| 26 |
$sql = "SELECT count(User.id) AS count,date(User.created) AS date FROM users User WHERE datediff(now(),created) <= 30 GROUP BY date(created) ORDER BY id DESC";
|
26 |
$sql = "SELECT count(User.id) AS count,date(User.created) AS date FROM users User WHERE datediff(now(),created) <= 30 AND activated = 1 GROUP BY date(created) ORDER BY id DESC";
|
| 27 |
$userbase = $this->User->query($sql);
|
27 |
$userbase = $this->User->query($sql);
|
| 28 |
$sql = "SELECT count(Click.id) AS count,date(created) AS date FROM clicks Click WHERE datediff(now(),created) <= 30 GROUP BY date(created) ORDER BY id DESC";
|
28 |
$sql = "SELECT count(Click.id) AS count,date(created) AS date FROM clicks Click WHERE datediff(now(),created) <= 30 GROUP BY date(created) ORDER BY id DESC";
|
| 29 |
$clicks = $this->User->query($sql);
|
29 |
$clicks = $this->User->query($sql);
|
| 30 |
$this->set(compact('userbase','clicks'));
|
30 |
$this->set(compact('userbase','clicks'));
|
| 31 |
$sql = "SELECT count(id) AS count,date(created) AS date FROM orders WHERE datediff(now(),created) <= 30 AND status = 'ORDER_CREATED' GROUP BY date(created) ORDER BY id DESC";
|
31 |
$sql = "SELECT count(id) AS count,date(created) AS date FROM orders WHERE datediff(now(),created) <= 30 AND status = 'ORDER_CREATED' GROUP BY date(created) ORDER BY id DESC";
|
| 32 |
$orders = $this->User->query($sql);
|
32 |
$orders = $this->User->query($sql);
|
| 33 |
$sql = "select count(id) AS count,versioncode from devices group by versioncode";
|
33 |
$sql = "select count(id) AS count,versioncode from devices group by versioncode";
|
| 34 |
$devices = $this->User->query($sql);
|
34 |
$devices = $this->User->query($sql);
|
| 35 |
$sql = "SELECT count(distinct user_id) AS count,date(created) AS date FROM `brand_preferences` WHERE datediff(now(),created) <= 30 group by date(created) order by id desc";
|
35 |
$sql = "SELECT count(distinct user_id) AS count,date(created) AS date FROM `brand_preferences` WHERE datediff(now(),created) <= 30 group by date(created) order by id desc";
|
| 36 |
$preferences_set = $this->User->query($sql);
|
36 |
$preferences_set = $this->User->query($sql);
|
| - |
|
37 |
$sql = "select count(distinct user_id) AS count from brand_preferences";
|
| - |
|
38 |
$usersWithBrandPreferencesSet = $this->User->query($sql);
|
| - |
|
39 |
$sql = "select count(id) AS count from users";
|
| - |
|
40 |
$totalUsers = $this->User->query($sql);
|
| 37 |
$this->set(compact('userbase','clicks','orders','devices','preferences_set'));
|
41 |
$this->set(compact('userbase','clicks','orders','devices','preferences_set','usersWithBrandPreferencesSet','totalUsers'));
|
| 38 |
}
|
42 |
}
|
| 39 |
}
|
43 |
}
|
| 40 |
|
44 |
|