| Line 336... |
Line 336... |
| 336 |
|
336 |
|
| 337 |
if($this->request->is('post')){
|
337 |
if($this->request->is('post')){
|
| 338 |
$filter = $this->request->data['Retailer']['searchReatailerBy'];
|
338 |
$filter = $this->request->data['Retailer']['searchReatailerBy'];
|
| 339 |
// debug($retdet);
|
339 |
// debug($retdet);
|
| 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 r where r.status = 'not_verified'";
|
345 |
$cnaquery ="select r.* from retailers r where r.status = 'not_verified'";
|
| 346 |
}
|
346 |
}
|
| 347 |
|
347 |
|
| 348 |
$result = $this->Retailer->query($cnaquery);
|
348 |
$result = $this->Retailer->query($cnaquery);
|