Subversion Repositories SmartDukaan

Rev

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

Rev 22765 Rev 22774
Line 365... Line 365...
365 
		}
 365 
		}
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.* from retailer r join user_accounts ua on (ua.account_key=r.id and ua.account_type='saholic') join user.address a on a.user_id=r.id where r.migrated=0 and r.active=0";
 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 
			$result = $this->Retailer->query($prquery);
 372 
			$result = $this->Retailer->query($prquery);
372 
			$this->set(compact('result'));
 373 
			$this->set(compact('result'));
373 
		}
 374 
		}
374 
	}
 375 
	}
375
376