Subversion Repositories SmartDukaan

Rev

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

Rev 15128 Rev 15188
Line 35... Line 35...
35 
		$sql = "SELECT count(distinct user_id) AS count,date(created) AS date FROM `brand_preferences` WHERE datediff(now(),created) <= 30 group by date(created) order by id desc";
 35 
		$sql = "SELECT count(distinct user_id) AS count,date(created) AS date FROM `brand_preferences` WHERE datediff(now(),created) <= 30 group by date(created) order by id desc";
36 
		$preferences_set = $this->User->query($sql);
36 
		$preferences_set = $this->User->query($sql);
37 
		$sql = "select count(distinct user_id) AS count from brand_preferences";
 37 
		$sql = "select count(distinct user_id) AS count from brand_preferences";
38 
		$usersWithBrandPreferencesSet = $this->User->query($sql);
 38 
		$usersWithBrandPreferencesSet = $this->User->query($sql);
39 
		$sql = "select count(id) AS count from users";
 39 
		$sql = "select count(id) AS count from users";
40 
		$totalUsers = $this->User->query($sql);
 40 
		$totalUsers = $this->User->query($sql);
41 
		$this->set(compact('userbase','clicks','orders','devices','preferences_set','usersWithBrandPreferencesSet','totalUsers'));
 41 
		$this->set(compact('userbase','clicks','orders','devices','preferences_set','usersWithBrandPreferencesSet','totalUsers'));
42 
	}
 42 
	}
43 
}
 43 
}
44 

            44