| Line 38... |
Line 38... |
| 38 |
$sql = "select count(distinct user_id) AS count from brand_preferences";
|
38 |
$sql = "select count(distinct user_id) AS count from brand_preferences";
|
| 39 |
$usersWithBrandPreferencesSet = $this->User->query($sql);
|
39 |
$usersWithBrandPreferencesSet = $this->User->query($sql);
|
| 40 |
$sql = "select count(id) AS count from users";
|
40 |
$sql = "select count(id) AS count from users";
|
| 41 |
$totalUsers = $this->User->query($sql);
|
41 |
$totalUsers = $this->User->query($sql);
|
| 42 |
$sql = "SELECT DATE( created ) AS date, COUNT( DISTINCT (user_id) ) AS count FROM user_urls WHERE ( created ) > CURDATE( ) - INTERVAL 30 DAY GROUP BY date order by id desc";
|
42 |
$sql = "SELECT DATE( created ) AS date, COUNT( DISTINCT (user_id) ) AS count FROM user_urls WHERE ( created ) > CURDATE( ) - INTERVAL 30 DAY GROUP BY date order by id desc";
|
| 43 |
$activeUsers = $this->User->query($sql);
|
43 |
$activeUsers = $this->User->query($sql);
|
| 44 |
$sql = "select date(created) date, count(distinct user_id) count from (select id,user_id, created from orders union all select id,user_id, created from flipkartorders) a where date(created) > curdate() - interval 30 day group by date order by a.id desc";
|
44 |
$sql = "select date(created) date, count(distinct user_id) count from (select id,user_id, created from orders union all select id,user_id, created from flipkartorders) a where date(created) > curdate() - interval 30 day group by date order by date desc";
|
| 45 |
$activeBuyers = $this->User->query($sql);
|
45 |
$activeBuyers = $this->User->query($sql);
|
| - |
|
46 |
ksort($activeBuyers);
|
| 46 |
$sql = "SELECT count(id) as count,date(mobile_number_last_updated) as date from users where mobile_verified=1 and datediff(now(),mobile_number_last_updated) <= 30 group by date(mobile_number_last_updated) ORDER BY date(mobile_number_last_updated) desc";
|
47 |
$sql = "SELECT count(id) as count,date(mobile_number_last_updated) as date from users where mobile_verified=1 and datediff(now(),mobile_number_last_updated) <= 30 group by date(mobile_number_last_updated) ORDER BY date(mobile_number_last_updated) desc";
|
| 47 |
$dailyVerifications = $this->User->query($sql);
|
48 |
$dailyVerifications = $this->User->query($sql);
|
| 48 |
$this->set(compact('userbase','clicks','orders','devices','preferences_set','usersWithBrandPreferencesSet','totalUsers','activeUsers','activeBuyers','dailyVerifications'));
|
49 |
$this->set(compact('userbase','clicks','orders','devices','preferences_set','usersWithBrandPreferencesSet','totalUsers','activeUsers','activeBuyers','dailyVerifications'));
|
| 49 |
}
|
50 |
}
|
| 50 |
}
|
51 |
}
|
| 51 |
|
52 |
|