| Line 48... |
Line 48... |
| 48 |
$dailyVerifications = $this->User->query($sql);
|
48 |
$dailyVerifications = $this->User->query($sql);
|
| 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";
|
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);
|
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 ";
|
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);
|
52 |
$app_transactions_percentage = $this->User->query($sql);
|
| 53 |
//For top five apps
|
- |
|
| 54 |
$sql="select date(at.transaction_time) AS date, at.app_name,at.app_id, count(*) AS count from (select app_id from app_transactions where datediff(curdate(),date(transaction_time))<30 group by app_id order by count(1) desc limit 5)a join app_transactions at on a.app_id = at.app_id group by date(at.transaction_time), at.app_id order by date(at.transaction_time)";
|
53 |
$sql="select date(at.transaction_time) AS date, at.app_name,at.app_id, count(*) AS count from (select app_id from app_transactions where datediff(curdate(),date(transaction_time))<30 group by app_id order by count(1) desc limit 5)a join app_transactions at on a.app_id = at.app_id group by date(at.transaction_time), at.app_id order by date(at.transaction_time)";
|
| 55 |
$top_five_apps = $this->User->query($sql);
|
54 |
$top_five_apps = $this->User->query($sql);
|
| 56 |
if(!empty($top_five_apps)){
|
55 |
if(!empty($top_five_apps)){
|
| 57 |
foreach ($top_five_apps as $key => $app) {
|
56 |
foreach ($top_five_apps as $key => $app) {
|
| 58 |
$apps[$app['at']['app_id']] = $app['at']['app_name'];
|
57 |
$apps[$app['at']['app_id']] = $app['at']['app_name'];
|
| 59 |
$appinstalls[$app[0]['date']][$app['at']['app_id']] = $app[0]['count'];
|
58 |
$appinstalls[$app[0]['date']][$app['at']['app_id']] = $app[0]['count'];
|
| 60 |
}
|
59 |
}
|
| 61 |
}
|
60 |
}
|
| 62 |
// debug($apps);
|
- |
|
| 63 |
// debug($appinstalls);
|
- |
|
| 64 |
$this->set(compact('userbase','clicks','orders','devices','preferences_set','usersWithBrandPreferencesSet','totalUsers','activeUsers','activeBuyers','dailyVerifications','app_transactions_clicks_approved','app_transactions_percentage','top_five_apps','apps','appinstalls'));
|
61 |
$this->set(compact('userbase','clicks','orders','devices','preferences_set','usersWithBrandPreferencesSet','totalUsers','activeUsers','activeBuyers','dailyVerifications','app_transactions_clicks_approved','app_transactions_percentage','top_five_apps','apps','appinstalls'));
|
| 65 |
}
|
62 |
}
|
| 66 |
}
|
63 |
}
|
| 67 |
|
64 |
|