| Line 43... |
Line 43... |
| 43 |
$sql = "SELECT DATE(visited) AS date, COUNT( DISTINCT (user_id) ) AS count FROM daily_visitors WHERE ( visited ) > CURDATE( ) - INTERVAL 30 DAY GROUP BY visited order by visited desc";
|
43 |
$sql = "SELECT DATE(visited) AS date, COUNT( DISTINCT (user_id) ) AS count FROM daily_visitors WHERE ( visited ) > CURDATE( ) - INTERVAL 30 DAY GROUP BY visited order by visited desc";
|
| 44 |
$activeUsers = $this->User->query($sql);
|
44 |
$activeUsers = $this->User->query($sql);
|
| 45 |
$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 |
$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";
|
| 46 |
$activeBuyers = $this->User->query($sql);
|
46 |
$activeBuyers = $this->User->query($sql);
|
| 47 |
ksort($activeBuyers);
|
47 |
ksort($activeBuyers);
|
| 48 |
$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 |
$sql = "SELECT count(id) as count,date(mobile_number_last_updated) as date from users where mobile_verified=1 and date(mobile_number_last_updated)<=curdate() and datediff(now(),mobile_number_last_updated) <= 30 group by date(mobile_number_last_updated) ORDER BY date(mobile_number_last_updated) desc";
|
| 49 |
$dailyVerifications = $this->User->query($sql);
|
49 |
$dailyVerifications = $this->User->query($sql);
|
| 50 |
$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 |
$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";
|
| 51 |
$app_transactions_clicks_approved = $this->User->query($sql);
|
51 |
$app_transactions_clicks_approved = $this->User->query($sql);
|
| 52 |
$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 |
$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 ";
|
| 53 |
$app_transactions_percentage = $this->User->query($sql);
|
53 |
$app_transactions_percentage = $this->User->query($sql);
|