| Line 98... |
Line 98... |
| 98 |
#debug($value['users']['utm_campaign']);
|
98 |
#debug($value['users']['utm_campaign']);
|
| 99 |
$val=$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'));";
|
100 |
$sql = "SELECT name from agents where id = (select agent_id from retailerlinks where code=upper('$val'));";
|
| 101 |
$this->loadModel('Agent');
|
101 |
$this->loadModel('Agent');
|
| 102 |
$agentname = $this->Agent->query($sql);
|
102 |
$agentname = $this->Agent->query($sql);
|
| - |
|
103 |
$citySql = "SELECT city from retailers where id = (select retailer_id from retailerlinks where code=upper('$val'));";
|
| - |
|
104 |
$this->loadModel('Retailer');
|
| - |
|
105 |
$retailerCity = $this->Retailer->query($citySql);
|
| 103 |
array_push($activations[$key], $agentname[0]['agents']['name']);
|
106 |
array_push($activations[$key], $agentname[0]['agents']['name']);
|
| - |
|
107 |
array_push($activations[$key], $retailerCity[0]['retailers']['city']);
|
| 104 |
}else{
|
108 |
}else{
|
| 105 |
#debug($value['users']['referrer']);
|
109 |
#debug($value['users']['referrer']);
|
| 106 |
$val=$value['users']['referrer'];
|
110 |
$val=$value['users']['referrer'];
|
| 107 |
$sql1 = "SELECT name from agents where id = (select agent_id from retailerlinks where code=upper('$val'));";
|
111 |
$sql1 = "SELECT name from agents where id = (select agent_id from retailerlinks where code=upper('$val'));";
|
| 108 |
$this->loadModel('Agent');
|
112 |
$this->loadModel('Agent');
|
| 109 |
$agentname = $this->Agent->query($sql1);
|
113 |
$agentname = $this->Agent->query($sql1);
|
| - |
|
114 |
$citySql = "SELECT city from retailers where id = (select retailer_id from retailerlinks where code=upper('$val'));";
|
| - |
|
115 |
$this->loadModel('Retailer');
|
| - |
|
116 |
$retailerCity = $this->Retailer->query($citySql);
|
| 110 |
array_push($activations[$key], $agentname[0]['agents']['name']);
|
117 |
array_push($activations[$key], $agentname[0]['agents']['name']);
|
| - |
|
118 |
array_push($activations[$key], $retailerCity[0]['retailers']['city']);
|
| 111 |
}
|
119 |
}
|
| 112 |
}
|
120 |
}
|
| 113 |
$agentActivations = $this->User->query($otherSql);
|
121 |
$agentActivations = $this->User->query($otherSql);
|
| 114 |
$this->set('agentActivations',$agentActivations);
|
122 |
$this->set('agentActivations',$agentActivations);
|
| 115 |
$this->set(compact('activations','date'));
|
123 |
$this->set(compact('activations','date'));
|