Subversion Repositories SmartDukaan

Rev

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

Rev 14394 Rev 15380
Line 62... Line 62...
62 
		    'result' => $result,
 62 
		    'result' => $result,
63 
		    '_serialize' => array('result')
 63 
		    '_serialize' => array('result')
64 
		));
 64 
		));
65 
		$this->render('/Elements/json');
 65 
		$this->render('/Elements/json');
66 
	}
 66 
	}
- 
 
 67 
 
- 
 
 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 
		} else{
- 
 
 74 
			$date = date('Y-m-d',time()-86400);
- 
 
 75 
			$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";
- 
 
 76 
		}
- 
 
 77 
		$this->loadModel('User');
- 
 
 78 
		$activations = $this->User->query($sql);
- 
 
 79 
		$this->set(compact('activations','date'));
- 
 
 80 
	}
67 
}
 81 
}
68 

            82