| 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() {
|
|
|
69 |
$data = $this->request->data;
|
|
|
70 |
if(!empty($data)){
|
|
|
71 |
$date = $data['Report']['date']['year'].'-'.$data['Report']['date']['month'].'-'.$data['Report']['date']['day'];
|
| 15422 |
manas |
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";
|
| 15428 |
manas |
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";
|
| 15380 |
anikendra |
74 |
} else{
|
|
|
75 |
$date = date('Y-m-d',time()-86400);
|
| 15422 |
manas |
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";
|
| 15380 |
anikendra |
78 |
}
|
|
|
79 |
$this->loadModel('User');
|
|
|
80 |
$activations = $this->User->query($sql);
|
|
|
81 |
$this->set(compact('activations','date'));
|
|
|
82 |
}
|
| 14394 |
anikendra |
83 |
}
|