Subversion Repositories SmartDukaan

	public function admin_search() {

		$type = $this->request->query('type');

		$search = $this->request->query('search');

		$this->User->recursive = -1;

		$options = array('limit'=>100,'order'=>array('id'=>'desc'));

		if($type == 'unactivated'){

			$options['conditions'] = array('activated' =>0);

		}

		else if(!empty($type) && !empty($search)){

			if($type=='id'){

				$options['conditions'] = array($type =>$search);			

			}else{

				$options['conditions'] = array($type.' LIKE '=>"%$search%");			

			}

		}else{

			$options['conditions'] = array('date(User.created)'=>date('Y-m-d',time()));			

		}	

		$sql = "SELECT * from (SELECT * from daily_visitors order by visited desc) as x group by x.user_id ";

		$last_act = $this->User->query($sql);

		// debug($last_act);

		$last_act_user_id = array();

		$last_activated = array();

		foreach ($last_act as $key => $row) {

			// echo $key;

			foreach ($row as $key => $value) {

				$last_activated['visited'] = $value['visited'];

				$last_act_user_id[$value['user_id']] = $last_activated['visited'];

			}

		}

		// debug($last_act_user_id);

		$this->set(compact('last_act_user_id'));

		$options['fields'] = array('id','email','first_name','referrer','utm_source','utm_medium','utm_term','utm_campaign','mobile_number','activated','User.created','Appacl.access');

		$options['joins'] = array(

		    array('table' => 'appacls',

		        'alias' => 'Appacl',

		        'type' => 'LEFT',

		        'conditions' => array(

		            'Appacl.user_id = User.id',

		        )

		    )

	    );

		$this->Paginator->settings = $options;

		$users = $this->Paginator->paginate();		

		$this->set(compact('users'));	

	}

	public function getDateInstallsBy($date, $user_id){

		$this->autoRender = false;	

		$this->request->onlyAllow('ajax');

		$url = $this->apihost.'appUserBatchDateDrillDown/'.$user_id.'/'.$date;

		$getApp = $this->make_request($url,null);

		return json_encode($getApp);	

	}