| Line 44... |
Line 44... |
| 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";
|
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 |
ksort($activeBuyers);
|
| 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 |
$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";
|
| 48 |
$dailyVerifications = $this->User->query($sql);
|
48 |
$dailyVerifications = $this->User->query($sql);
|
| 49 |
$this->set(compact('userbase','clicks','orders','devices','preferences_set','usersWithBrandPreferencesSet','totalUsers','activeUsers','activeBuyers','dailyVerifications'));
|
- |
|
| 50 |
}
|
- |
|
| 51 |
}
|
- |
|
| 52 |
|
49 |
$sql="SELECT date(transaction_time) AS date,COUNT(*) AS count, (COUNT(CASE payout_description WHEN 'Approved' THEN 1 END)) as approved FROM app_transactions where datediff(now(),transaction_time) <= 30 group by date(transaction_time) order by date(transaction_time) desc";
|
| - |
|
50 |
$app_transactions_clicks_approved = $this->User->query($sql);
|
| - |
|
51 |
$sql="SELECT x.date,round(((x.approved/x.count)*100),2) as conversion from (SELECT date(transaction_time) AS date,COUNT(*) AS count, (COUNT(CASE payout_description WHEN 'Approved' THEN 1 END)) as approved FROM app_transactions where datediff(now(),transaction_time) <= 30 group by date(transaction_time) order by date(transaction_time) desc) as x ";
|
| - |
|
52 |
$app_transactions_percentage = $this->User->query($sql);
|
| - |
|
53 |
$this->set(compact('userbase','clicks','orders','devices','preferences_set','usersWithBrandPreferencesSet','totalUsers','activeUsers','activeBuyers','dailyVerifications','app_transactions_clicks_approved','app_transactions_percentage'));
|
| - |
|
54 |
}
|
| - |
|
55 |
}
|
| - |
|
56 |
|
| 53 |
|
57 |
|