Subversion Repositories SmartDukaan

Rev

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

Rev 17127 Rev 17186
Line 26... Line 26...
26 
		$sql = "SELECT count(User.id) AS count,date(User.activation_time) AS date FROM users User WHERE datediff(now(),activation_time) <= 30 AND activated = 1 GROUP BY date(activation_time) ORDER BY User.activation_time DESC";
 26 
		$sql = "SELECT count(User.id) AS count,date(User.activation_time) AS date FROM users User WHERE datediff(now(),activation_time) <= 30 AND activated = 1 GROUP BY date(activation_time) ORDER BY User.activation_time DESC";
27 
		$userbase = $this->User->query($sql);
 27 
		$userbase = $this->User->query($sql);
28 
		$sql = "SELECT count(Click.id) AS count,date(created) AS date FROM clicks Click WHERE datediff(now(),created) <= 30 AND extras NOT LIKE '%notification%'GROUP BY date(created) ORDER BY id DESC";
 28 
		$sql = "SELECT count(Click.id) AS count,date(created) AS date FROM clicks Click WHERE datediff(now(),created) <= 30 AND extras NOT LIKE '%notification%'GROUP BY date(created) ORDER BY id DESC";
29 
		$clicks = $this->User->query($sql);
 29 
		$clicks = $this->User->query($sql);
30 
		$this->set(compact('userbase','clicks'));
 30 
		$this->set(compact('userbase','clicks'));
31 
		$sql = "SELECT count(id) AS count,date(created) AS date FROM orders WHERE datediff(now(),created) <= 30 AND status = 'ORDER_CREATED' GROUP BY date(created) ORDER BY id DESC";
 31 
		$sql = "SELECT count(id) AS count,date(created) AS date FROM orders WHERE datediff(now(),created) <= 30 AND (status = 'ORDER_CREATED' OR status = 'DETAIL_CREATED') GROUP BY date(created) ORDER BY id DESC";
32 
		$orders = $this->User->query($sql);
32 
		$orders = $this->User->query($sql);
33 
		// $sql = "select count(id) AS count,versioncode from devices group by versioncode";
 33 
		// $sql = "select count(id) AS count,versioncode from devices group by versioncode";
34 
		$sql = "SELECT COUNT( * ) AS count, a.c AS versioncode FROM (SELECT MAX( versioncode ) c, user_id FROM devices GROUP BY user_id) a GROUP BY a.c";
 34 
		$sql = "SELECT COUNT( * ) AS count, a.c AS versioncode FROM (SELECT MAX( versioncode ) c, user_id FROM devices GROUP BY user_id) a GROUP BY a.c";
35 
		$devices = $this->User->query($sql);
 35 
		$devices = $this->User->query($sql);
36 
		$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 
		$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";