Subversion Repositories SmartDukaan

Rev

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

Rev 16309 Rev 16448
Line 714... Line 714...
714 
		$users = $this->Paginator->paginate();
714 
		$users = $this->Paginator->paginate();
715 
		foreach ($users as $key => $value) {
 715 
		foreach ($users as $key => $value) {
716 
			$userId = $value['User']['id'];
 716 
			$userId = $value['User']['id'];
717 
			$quer= "select r.retailer_id,a.name from retailerlinks r join agents a on r.agent_id=a.id where user_id=$userId";
 717 
			$quer= "select r.retailer_id,a.name from retailerlinks r join agents a on r.agent_id=a.id where user_id=$userId";
718 
			$res = $this->User->query($quer);
 718 
			$res = $this->User->query($quer);
- 
 
 719 
			$last_act= "select last_active from useractive where user_id=$userId";
- 
 
 720 
			$res_last = $this->User->query($last_act);
719 
			if(empty($res)){
 721 
			if(empty($res)){
720 
				$users[$key]['User']['retailer_id']="";
722 
				$users[$key]['User']['retailer_id']="";
721 
				$users[$key]['User']['agent_name']="";
723 
				$users[$key]['User']['agent_name']="";
722 
			}else{
 724 
			}else{
723 
				$users[$key]['User']['retailer_id']=$res[0]['r']['retailer_id'];
725 
				$users[$key]['User']['retailer_id']=$res[0]['r']['retailer_id'];
724 
				$users[$key]['User']['agent_name']=$res[0]['a']['name'];
726 
				$users[$key]['User']['agent_name']=$res[0]['a']['name'];
725 
			}
 727 
			}
- 
 
 728 
			if(empty($res_last)){
- 
 
 729 
				$users[$key]['User']['last_active']="";
- 
 
 730 
			}else{
- 
 
 731 
				$users[$key]['User']['last_active']=$res_last[0]['useractive']['last_active'];
- 
 
 732 
			}
726
733
727 
		}
 734 
		}
728 
 
 735 
 
729 
		$this->set(compact('users'));
736 
		$this->set(compact('users'));
730 
	}
 737 
	}