Subversion Repositories SmartDukaan

Rev

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

Rev 16082 Rev 16256
Line 711... Line 711...
711 
		}else{
 711 
		}else{
712 
			$options['conditions'] = array('date(created)'=>date('Y-m-d',time()));
712 
			$options['conditions'] = array('date(created)'=>date('Y-m-d',time()));
713 
		}
713 
		}
714 
		$this->Paginator->settings = $options;
 714 
		$this->Paginator->settings = $options;
715 
		$users = $this->Paginator->paginate();
715 
		$users = $this->Paginator->paginate();
- 
 
 716 
		foreach ($users as $key => $value) {
- 
 
 717 
			$userId = $value['User']['id'];
- 
 
 718 
			$quer= "select r.retailer_id,a.name from retailerlinks r join agents a on r.agent_id=a.id where user_id=$userId";
- 
 
 719 
			$res = $this->User->query($quer);
- 
 
 720 
			if(empty($res)){
- 
 
 721 
				$users[$key]['User']['retailer_id']="";
- 
 
 722 
				$users[$key]['User']['agent_name']="";
- 
 
 723 
			}else{
- 
 
 724 
				$users[$key]['User']['retailer_id']=$res[0]['r']['retailer_id'];
- 
 
 725 
				$users[$key]['User']['agent_name']=$res[0]['a']['name'];
- 
 
 726 
			}
- 
 
 727
716
728 
		}
- 
 
 729 
 
717 
		$this->set(compact('users'));
730 
		$this->set(compact('users'));
718 
	}
 731 
	}
719 
 
 732 
 
720 
	public function dashboard() {
 733 
	public function dashboard() {
721 
		App::uses('CakeTime', 'Utility');
 734 
		App::uses('CakeTime', 'Utility');