Subversion Repositories SmartDukaan

Rev

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

Rev 22776 Rev 22778
Line 366... Line 366...
366 
	}
366 
	}
367
367
368 
	public function admin_pendingretailer_new() {
 368 
	public function admin_pendingretailer_new() {
369 
		if($this->request->is('get')) {
 369 
		if($this->request->is('get')) {
370 
			$prquery = "select r.*,a.*, u.* from retailer r join user_accounts ua on (ua.account_key=r.id and ua.account_type='saholic')
370 
			$prquery = "select r.*,a.*, u.* from retailer r join user_accounts ua on (ua.account_key=r.id and ua.account_type='saholic')
371 
			join user.address a on a.user_id=r.id join users u on u.id=ua.user_id where (r.migrated=0 and r.active=0)";
 371 
			join users u on u.id=ua.user_id join retailer_registered_address rra on rra.retailer_id=r.id join user.address a on rra.address_id=a.id where (r.migrated=0 and r.active=0)";
372 
			$result = $this->Retailer->query($prquery);
 372 
			$result = $this->Retailer->query($prquery);
373 
			$this->set(compact('result'));
 373 
			$this->set(compact('result'));
374 
		}
 374 
		}
375 
	}
 375 
	}
376
376