| Line 81... |
Line 81... |
| 81 |
$this->set(compact('activations','date'));*/
|
81 |
$this->set(compact('activations','date'));*/
|
| 82 |
$data = $this->request->data;
|
82 |
$data = $this->request->data;
|
| 83 |
if(!empty($data)){
|
83 |
if(!empty($data)){
|
| 84 |
$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'];
|
| 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";
|
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";
|
| - |
|
86 |
$otherSql="SELECT a.name,count(*) as count from users u join retailerlinks rl join agents a on ((rl.code =upper( u.referrer) or rl.code=u.utm_campaign) and rl.agent_id = a.id) where date(rl.activated)='$date' group by rl.agent_id";
|
| 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";
|
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";
|
| 87 |
} else{
|
88 |
} else{
|
| 88 |
// $date = date('Y-m-d',time()-86400);
|
89 |
// $date = date('Y-m-d',time()-86400);
|
| 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";
|
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";
|
| - |
|
91 |
$otherSql="SELECT a.name,count(*) as count from users u join retailerlinks rl join agents a on ((rl.code =upper( u.referrer) or rl.code=u.utm_campaign) and rl.agent_id = a.id) where date(rl.activated)=NOW() group by rl.agent_id";
|
| 90 |
$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";
|
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";
|
| 91 |
}
|
93 |
}
|
| 92 |
$this->loadModel('User');
|
94 |
$this->loadModel('User');
|
| 93 |
$activations = $this->User->query($sql);
|
95 |
$activations = $this->User->query($sql);
|
| 94 |
foreach ($activations as $key => $value) {
|
96 |
foreach ($activations as $key => $value) {
|
| Line 106... |
Line 108... |
| 106 |
$this->loadModel('Agent');
|
108 |
$this->loadModel('Agent');
|
| 107 |
$agentname = $this->Agent->query($sql1);
|
109 |
$agentname = $this->Agent->query($sql1);
|
| 108 |
array_push($activations[$key], $agentname[0]['agents']['name']);
|
110 |
array_push($activations[$key], $agentname[0]['agents']['name']);
|
| 109 |
}
|
111 |
}
|
| 110 |
}
|
112 |
}
|
| - |
|
113 |
$agentActivations = $this->User->query($otherSql);
|
| - |
|
114 |
$this->set('agentActivations',$agentActivations);
|
| 111 |
$this->set(compact('activations','date'));
|
115 |
$this->set(compact('activations','date'));
|
| 112 |
}
|
116 |
}
|
| 113 |
}
|
117 |
}
|
| 114 |
|
118 |
|