Subversion Repositories SmartDukaan

Rev

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

Rev 15077 Rev 15093
Line 30... Line 30...
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' 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 
		$devices = $this->User->query($sql);
 34 
		$devices = $this->User->query($sql);
- 
 
 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);
35 
		$this->set(compact('userbase','clicks','orders','devices'));
 37 
		$this->set(compact('userbase','clicks','orders','devices','preferences_set'));
36 
	}
 38 
	}
37 
}
 39 
}