| 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.*, 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.*, s.* from retailer r join user_accounts ua on (ua.account_key=r.id and ua.account_type='saholic')
|
| 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 u.created > '2017-11-03' order by u.id desc limit 100";
|
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 join shop s on s.retailer_id=r.id where u.created > '2017-11-03' order by u.id desc limit 100";
|
| 372 |
//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 |
//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)";
|
| 373 |
$result = $this->Retailer->query($prquery);
|
373 |
$result = $this->Retailer->query($prquery);
|
| 374 |
$this->set(compact('result'));
|
374 |
$this->set(compact('result'));
|
| 375 |
}
|
375 |
}
|
| 376 |
}
|
376 |
}
|