| Line 37... |
Line 37... |
| 37 |
$preferences_set = $this->User->query($sql);
|
37 |
$preferences_set = $this->User->query($sql);
|
| 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 DATE( created ) > CURDATE( ) - INTERVAL 30 DAY GROUP BY date order by id desc";
|
| - |
|
43 |
$activeUsers = $this->User->query($sql);
|
| 42 |
$this->set(compact('userbase','clicks','orders','devices','preferences_set','usersWithBrandPreferencesSet','totalUsers'));
|
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";
|
| - |
|
45 |
$activeBuyers = $this->User->query($sql);
|
| - |
|
46 |
$this->set(compact('userbase','clicks','orders','devices','preferences_set','usersWithBrandPreferencesSet','totalUsers','activeUsers','activeBuyers'));
|
| 43 |
}
|
47 |
}
|
| 44 |
}
|
48 |
}
|
| 45 |
|
49 |
|