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