Subversion Repositories SmartDukaan

Rev

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

Rev 15721 Rev 16013
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";
 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 
		$activeUsers = $this->User->query($sql);
 43 
		$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 a.id 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 a.id desc";
45 
		$activeBuyers = $this->User->query($sql);
 45 
		$activeBuyers = $this->User->query($sql);
46 
		$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";
 46 
		$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 
		$dailyVerifications = $this->User->query($sql);
 47 
		$dailyVerifications = $this->User->query($sql);