Subversion Repositories SmartDukaan

Rev

Rev 17023 | Rev 17186 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 17023 Rev 17127
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 ( 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 
		$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 
		$activeUsers = $this->User->query($sql);
44 
		$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 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";
45 
		$activeBuyers = $this->User->query($sql);
 46 
		$activeBuyers = $this->User->query($sql);
46 
		ksort($activeBuyers);
 47 
		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";
 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";