Subversion Repositories SmartDukaan

Rev

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

Rev 16475 Rev 16932
Line 21... Line 21...
21 
 * @return void
 21 
 * @return void
22 
 */
 22 
 */
23 
	public function admin_index() {
 23 
	public function admin_index() {
24 
		$this->PaytmCalling->recursive = -1;
 24 
		$this->PaytmCalling->recursive = -1;
25 
		$userIds = $this->PaytmCalling->find('list');
 25 
		$userIds = $this->PaytmCalling->find('list');
26 
		$sql = "SELECT u.id,u.first_name,u.email,u.mobile_number FROM users u JOIN user_urls ur ON u.id = ur.user_id WHERE ur.user_id NOT IN (".implode(',',$userIds).") AND ur.url LIKE 'https://paytm.com/shop/p%' GROUP BY ur.user_id";
 26 
		$sql = "SELECT u.id,u.first_name,u.email,u.mobile_number FROM users u JOIN paytm_coupon_non_usages p on p.user_id=u.id order by p.created";
27 
		$users = $this->PaytmCalling->query($sql);
 27 
		$users = $this->PaytmCalling->query($sql);
28 
		$this->set('users', $users);
 28 
		$this->set('users', $users);
29 
	}
 29 
	}
30 
 
 30 
 
31 
/**
 31 
/**