Subversion Repositories SmartDukaan

Rev

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

Rev 16448 Rev 16449
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";
 719 
			/*$last_act= "select last_active from useractive where user_id=$userId";
720 
			$res_last = $this->User->query($last_act);
 720 
			$res_last = $this->User->query($last_act);*/
721 
			if(empty($res)){
 721 
			if(empty($res)){
722 
				$users[$key]['User']['retailer_id']="";
722 
				$users[$key]['User']['retailer_id']="";
723 
				$users[$key]['User']['agent_name']="";
723 
				$users[$key]['User']['agent_name']="";
724 
			}else{
 724 
			}else{
725 
				$users[$key]['User']['retailer_id']=$res[0]['r']['retailer_id'];
725 
				$users[$key]['User']['retailer_id']=$res[0]['r']['retailer_id'];
726 
				$users[$key]['User']['agent_name']=$res[0]['a']['name'];
726 
				$users[$key]['User']['agent_name']=$res[0]['a']['name'];
727 
			}
 727 
			}
728 
			if(empty($res_last)){
 728 
			/*if(empty($res_last)){
729 
				$users[$key]['User']['last_active']="";
 729 
				$users[$key]['User']['last_active']="";
730 
			}else{
 730 
			}else{
731 
				$users[$key]['User']['last_active']=$res_last[0]['useractive']['last_active'];
 731 
				$users[$key]['User']['last_active']=$res_last[0]['useractive']['last_active'];
732 
			}
 732 
			}*/
733
733
734 
		}
 734 
		}
735 
 
 735 
 
736 
		$this->set(compact('users'));
736 
		$this->set(compact('users'));
737 
	}
 737 
	}