<?

function queryLatestCoupons(){
	return $this->select()
				   ->from("
					   	Coupons C,
					   	Stores S,
					   	CategoryMaps M
				   	")
				   ->where("
				   		 C.Active='1' AND 
				   		 S.Active='1' AND 
				   		 M.Active='1'
				   	")
				   ->groupBy('S.Store')
				   ->orderBy('C.CouponID')
				   ->sortBy('DESC');
}

function queryMostPopularCoupons(){
	
}

function by($str){
	$func = 'query' . str_replace(" ", "",$str);
	call_user_func($func);
}

$data = Site::load('Coupons')->queryLatestCoupons()->limit(32)->paginate("param=[key=page,options=[color=red,font=italic]]")->fetchAll();
$this->view->data = Site::load('Coupons')->by("Most Popular Coupons");
foreach($this->data AS $key=>$value){
	echo "$value[Coupon]<br>";
}