Subversion Repositories SmartDukaan

Rev

Rev 15469 | Rev 15582 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
14394 anikendra 1 
<?php
2 
App::uses('AppController', 'Controller');
3 
/**
4 
 * Exceptionalnlcs Controller
5 
 *
6 
 * @property Exceptionalnlc $Exceptionalnlc
7 
 * @property PaginatorComponent $Paginator
8 
 */
9 
class ReportsController extends AppController {
10 
 
11 
/**
12 
 * Components
13 
 *
14 
 * @var array
15 
 */
16 
	public $components = array('Paginator');
17 
 
18 
	public function beforeFilter() {
19 
		parent::beforeFilter();
20 
//		Configure::load('live');
21 
		$this->apihost = Configure::read('pythonapihost');
22 
	}
23 
 
24 
	public function admin_orders() {
25 
		$page = $this->request->query('page');
26 
		if(!isset($page)){
27 
			$page = 1;
28 
		}
29 
		$limit = Configure::read('admindashboardlimit');
30 
		$params = array(
31 
			'fields' => array('_id','subOrders','storeId', 'userId', 'merchantOrderId'),
32 
			// 'conditions' => array('source_id' => array('$ne' => 0)),
33 
			'order' => array('_id' => -1),
34 
			'limit' => $limit,
35 
			'page' => $page,
36 
		);
37 
		$orders = $this->Report->find('all', $params);
38 
		// $this->loadModel('Category');
39 
		// $categories = $this->Category->find('list');
40 
		// $storemapping = Configure::read('storemapping');
41 
		$this->set(compact('orders'));
42 
	}
43 
 
44 
	public function admin_ordersjson() {
45 
		$this->layout = 'ajax';
46 
		$page = $this->request->query('page');
47 
		if(!isset($page)){
48 
			$page = 1;
49 
		}
50 
		$limit = $this->request->query('limit');
51 
		$limit = Configure::read('admindashboardlimit');
52 
		$params = array(
53 
			'fields' => array('_id','subOrders','storeId', 'userId', 'merchantOrderId'),
54 
			// 'conditions' => array('source_id' => array('$ne' => 0)),
55 
			'order' => array('_id' => -1),
56 
			'limit' => $limit,
57 
			'page' => $page,
58 
		);
59 
		$orders = $this->Report->find('all', $params);
60 
		$result = array('orders'=>$orders);
61 
		$this->set(array(
62 
		    'result' => $result,
63 
		    '_serialize' => array('result')
64 
		));
65 
		$this->render('/Elements/json');
66 
	}
15380 anikendra 67 
 
68 
	public function admin_activations() {
15436 manas 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'));*/
15380 anikendra 82 
		$data = $this->request->data;
83 
		if(!empty($data)){
84 
			$date = $data['Report']['date']['year'].'-'.$data['Report']['date']['month'].'-'.$data['Report']['date']['day'];
15422 manas 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";
15472 anikendra 86 
			$otherSql="SELECT a.name, COUNT( r.id ) AS count FROM  `retailerlinks` r LEFT JOIN agents a ON r.agent_id = a.id WHERE DATE( r.activated ) = '$date' GROUP BY a.id";
15428 manas 87 
			$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";
15380 anikendra 88 
		} else{
15447 anikendra 89 
			// $date = date('Y-m-d',time()-86400);
15422 manas 90 
			#$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";
15472 anikendra 91 
			$otherSql="SELECT a.name, COUNT( r.id ) AS count FROM  `retailerlinks` r LEFT JOIN agents a ON r.agent_id = a.id WHERE DATE( r.activated ) = CURDATE( ) GROUP BY a.id";
15456 anikendra 92 
			$sql = "SELECT DATE( created ) AS date, utm_campaign,referrer , COUNT( id ) AS count FROM users WHERE  DATE( created ) = CURDATE() AND  (utm_campaign IS NOT NULL OR referrer IS NOT NULL) GROUP BY DATE( created) ,utm_campaign,referrer";
15380 anikendra 93 
		}
94 
		$this->loadModel('User');
95 
		$activations = $this->User->query($sql);
15436 manas 96 
		foreach ($activations as $key => $value) {
97 
			if(isset($value['users']['utm_campaign'])){
98 
				#debug($value['users']['utm_campaign']);
99 
				$val=$value['users']['utm_campaign'];
100 
				$sql = "SELECT name from agents where id = (select agent_id from retailerlinks where code=upper('$val'));";
101 
				$this->loadModel('Agent');
102 
				$agentname = $this->Agent->query($sql);
103 
				array_push($activations[$key], $agentname[0]['agents']['name']);
104 
			}else{
105 
				#debug($value['users']['referrer']);
106 
				$val=$value['users']['referrer'];
107 
				$sql1 = "SELECT name from agents where id = (select agent_id from retailerlinks where code=upper('$val'));";
108 
				$this->loadModel('Agent');
109 
				$agentname = $this->Agent->query($sql1);
110 
				array_push($activations[$key], $agentname[0]['agents']['name']);
111 
			}
112 
		}
15469 manas 113 
		$agentActivations = $this->User->query($otherSql);
114 
		$this->set('agentActivations',$agentActivations);
15380 anikendra 115 
		$this->set(compact('activations','date'));
116 
	}
14394 anikendra 117 
}