| Line 340... |
Line 340... |
| 340 |
if($filter == '0'){
|
340 |
if($filter == '0'){
|
| 341 |
$cnaquery ="select r.* from retailers r join profitmandi_sms p on r.id=p.identifier join retailerlinks rl on r.id= rl.retailer_id; and rl.user_id is not null ";
|
341 |
$cnaquery ="select r.* from retailers r join profitmandi_sms p on r.id=p.identifier join retailerlinks rl on r.id= rl.retailer_id; and rl.user_id is not null ";
|
| 342 |
}else if($filter == '1') {
|
342 |
}else if($filter == '1') {
|
| 343 |
$cnaquery ="select r.* from retailers r join profitmandi_sms p on r.id=p.identifier join retailerlinks rl on r.id= rl.retailer_id; and rl.user_id is null ";
|
343 |
$cnaquery ="select r.* from retailers r join profitmandi_sms p on r.id=p.identifier join retailerlinks rl on r.id= rl.retailer_id; and rl.user_id is null ";
|
| 344 |
}else if($filter == '2') {
|
344 |
}else if($filter == '2') {
|
| 345 |
$cnaquery ="select r.* from retailers where status = 'not_verified'";
|
345 |
$cnaquery ="select r.* from retailers r where status = 'not_verified'";
|
| 346 |
}
|
346 |
}
|
| 347 |
|
347 |
|
| 348 |
$result = $this->Retailer->query($cnaquery);
|
348 |
$result = $this->Retailer->query($cnaquery);
|
| 349 |
|
349 |
|
| 350 |
$this->set(compact('result'));
|
350 |
$this->set(compact('result'));
|