Subversion Repositories SmartDukaan

Rev

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

Rev 13532 Rev 15077
Line 19... Line 19...
19 
    	parent::beforeFilter();
 19 
    	parent::beforeFilter();
20 
    	$this->layout = 'admin';
 20 
    	$this->layout = 'admin';
21 
    }
 21 
    }
22 
 
 22 
 
23 
	public function dashboard(){
 23 
	public function dashboard(){
- 
 
 24 
		$this->loadModel('User');
- 
 
 25 
		//daily userbase
- 
 
 26 
		$sql = "SELECT count(User.id) AS count,date(User.created) AS date FROM users User WHERE datediff(now(),created) <= 30 GROUP BY date(created) ORDER BY id DESC";
- 
 
 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 GROUP BY date(created) ORDER BY id DESC";
- 
 
 29 
		$clicks = $this->User->query($sql);
24 
 
 - 
 
- 
 
 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";
- 
 
 32 
		$orders = $this->User->query($sql);
- 
 
 33 
		$sql = "select count(id) AS count,versioncode from devices group by versioncode";
- 
 
 34 
		$devices = $this->User->query($sql);
- 
 
 35 
		$this->set(compact('userbase','clicks','orders','devices'));
25 
	}
 36 
	}
26 
 
 - 
 
27 
}
 37 
}