Subversion Repositories SmartDukaan

Rev

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

Rev 20894 Rev 20896
Line 343... Line 343...
343 
				$cnaquery ="select r.*, rl.code 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 order by r.id desc";
 343 
				$cnaquery ="select r.*, rl.code 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 order by r.id desc";
344 
			}else if($filter == '2') {
 344 
			}else if($filter == '2') {
345 
				$cnaquery ="select r.* from retailers r where r.status = 'not_verified' order by r.id desc";
 345 
				$cnaquery ="select r.* from retailers r where r.status = 'not_verified' order by r.id desc";
346 
			}
 346 
			}
347 
 
 347 
 
348 
			$result = $this->Retailer->query($cnaquery);
 348 
			$result = $this->Retailer->query($cnaquery);;
349 
			echo var_dump($result);
 - 
 
350 
			$this->set(compact('result'));
 349 
			$this->set(compact('result'));
351 
		}
350 
		}
352
351
353
352
354
353