Subversion Repositories SmartDukaan

Rev

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

Rev 15428 Rev 15436
Line 64... Line 64...
64 
		));
 64 
		));
65 
		$this->render('/Elements/json');
 65 
		$this->render('/Elements/json');
66 
	}
 66 
	}
67 
 
 67 
 
68 
	public function admin_activations() {
 68 
	public function admin_activations() {
- 
 
 69 
		/*$data = $this->request->data;
- 
 
 70 
		if(!empty($data)){
- 
 
 71 
			$date = $data['Report']['date']['year'].'-'.$data['Report']['date']['month'].'-'.$data['Report']['date']['day'];
- 
 
 72 
			#$sql = "SELECT DATE( created ) AS date, referrer , COUNT( id ) AS count FROM users WHERE DATE(created ) = '$date' AND referrer IS NOT NULL GROUP BY DATE( created ) , referrer";
- 
 
 73 
			$sql = "SELECT DATE( created ) AS date, utm_campaign,referrer , COUNT( id ) AS count FROM users WHERE DATE(created) = '$date' AND  (utm_campaign IS NOT NULL OR referrer IS NOT NULL) GROUP BY DATE( created) ,utm_campaign,referrer";
- 
 
 74 
		} else{
- 
 
 75 
			$date = date('Y-m-d',time()-86400);
- 
 
 76 
			#$sql = "SELECT DATE( created ) AS date, referrer , COUNT( id ) AS count FROM users WHERE DATEDIFF( NOW( ) , created ) = 1 AND referrer IS NOT NULL GROUP BY DATE( created ) , referrer";
- 
 
 77 
			$sql = "SELECT DATE( created ) AS date, utm_campaign,referrer , COUNT( id ) AS count FROM users WHERE DATEDIFF( NOW( ) , created ) = 1 AND  (utm_campaign IS NOT NULL OR referrer IS NOT NULL) GROUP BY DATE( created) ,utm_campaign,referrer";
- 
 
 78 
		}
- 
 
 79 
		$this->loadModel('User');
- 
 
 80 
		$activations = $this->User->query($sql);
- 
 
 81 
		$this->set(compact('activations','date'));*/
69 
		$data = $this->request->data;
 82 
		$data = $this->request->data;
70 
		if(!empty($data)){
 83 
		if(!empty($data)){
71 
			$date = $data['Report']['date']['year'].'-'.$data['Report']['date']['month'].'-'.$data['Report']['date']['day'];
 84 
			$date = $data['Report']['date']['year'].'-'.$data['Report']['date']['month'].'-'.$data['Report']['date']['day'];
72 
			#$sql = "SELECT DATE( created ) AS date, referrer , COUNT( id ) AS count FROM users WHERE DATE(created ) = '$date' AND referrer IS NOT NULL GROUP BY DATE( created ) , referrer";
 85 
			#$sql = "SELECT DATE( created ) AS date, referrer , COUNT( id ) AS count FROM users WHERE DATE(created ) = '$date' AND referrer IS NOT NULL GROUP BY DATE( created ) , referrer";
73 
			$sql = "SELECT DATE( created ) AS date, utm_campaign,referrer , COUNT( id ) AS count FROM users WHERE DATE(created) = '$date' AND  (utm_campaign IS NOT NULL OR referrer IS NOT NULL) GROUP BY DATE( created) ,utm_campaign,referrer";
 86 
			$sql = "SELECT DATE( created ) AS date, utm_campaign,referrer , COUNT( id ) AS count FROM users WHERE DATE(created) = '$date' AND  (utm_campaign IS NOT NULL OR referrer IS NOT NULL) GROUP BY DATE( created) ,utm_campaign,referrer";
Line 76... Line 89...
76 
			#$sql = "SELECT DATE( created ) AS date, referrer , COUNT( id ) AS count FROM users WHERE DATEDIFF( NOW( ) , created ) = 1 AND referrer IS NOT NULL GROUP BY DATE( created ) , referrer";
 89 
			#$sql = "SELECT DATE( created ) AS date, referrer , COUNT( id ) AS count FROM users WHERE DATEDIFF( NOW( ) , created ) = 1 AND referrer IS NOT NULL GROUP BY DATE( created ) , referrer";
77 
			$sql = "SELECT DATE( created ) AS date, utm_campaign,referrer , COUNT( id ) AS count FROM users WHERE DATEDIFF( NOW( ) , created ) = 1 AND  (utm_campaign IS NOT NULL OR referrer IS NOT NULL) GROUP BY DATE( created) ,utm_campaign,referrer";
 90 
			$sql = "SELECT DATE( created ) AS date, utm_campaign,referrer , COUNT( id ) AS count FROM users WHERE DATEDIFF( NOW( ) , created ) = 1 AND  (utm_campaign IS NOT NULL OR referrer IS NOT NULL) GROUP BY DATE( created) ,utm_campaign,referrer";
78 
		}
 91 
		}
79 
		$this->loadModel('User');
92 
		$this->loadModel('User');
80 
		$activations = $this->User->query($sql);
 93 
		$activations = $this->User->query($sql);
- 
 
 94 
		foreach ($activations as $key => $value) {
- 
 
 95 
			if(isset($value['users']['utm_campaign'])){
- 
 
 96 
				#debug($value['users']['utm_campaign']);
- 
 
 97 
				$val=$value['users']['utm_campaign'];
- 
 
 98 
				$sql = "SELECT name from agents where id = (select agent_id from retailerlinks where code=upper('$val'));";
- 
 
 99 
				$this->loadModel('Agent');
- 
 
 100 
				$agentname = $this->Agent->query($sql);
- 
 
 101 
				array_push($activations[$key], $agentname[0]['agents']['name']);
- 
 
 102 
			}else{
- 
 
 103 
				#debug($value['users']['referrer']);
- 
 
 104 
				$val=$value['users']['referrer'];
- 
 
 105 
				$sql1 = "SELECT name from agents where id = (select agent_id from retailerlinks where code=upper('$val'));";
- 
 
 106 
				$this->loadModel('Agent');
- 
 
 107 
				$agentname = $this->Agent->query($sql1);
- 
 
 108 
				array_push($activations[$key], $agentname[0]['agents']['name']);
- 
 
 109 
			}
- 
 
 110 
		}
81 
		$this->set(compact('activations','date'));
 111 
		$this->set(compact('activations','date'));
82 
	}
 112 
	}
83 
}
 113 
}
84 

            114