| Line 137... |
Line 137... |
| 137 |
$this->loadModel('UserFilter');
|
137 |
$this->loadModel('UserFilter');
|
| 138 |
$sql = "select date(created) date,group_concat(filters separator '|') brands from user_filters where type = 'brand' group by date(created) ORDER BY id DESC";
|
138 |
$sql = "select date(created) date,group_concat(filters separator '|') brands from user_filters where type = 'brand' group by date(created) ORDER BY id DESC";
|
| 139 |
$brand_filters = $this->UserFilter->query($sql);
|
139 |
$brand_filters = $this->UserFilter->query($sql);
|
| 140 |
$this->set(compact('brand_filters','all'));
|
140 |
$this->set(compact('brand_filters','all'));
|
| 141 |
}
|
141 |
}
|
| - |
|
142 |
|
| - |
|
143 |
public function admin_dailyupgrades_report() {
|
| - |
|
144 |
$this->loadModel('Device');
|
| - |
|
145 |
$data = $this->request->data;
|
| - |
|
146 |
if(!empty($data)){
|
| - |
|
147 |
$date = $data['Report']['date']['year'].'-'.$data['Report']['date']['month'].'-'.$data['Report']['date']['day'];
|
| - |
|
148 |
$sql = "select count(id) as count,date(created) as date,user_id from devices where imeinumber in (select imeinumber from devices where date(created) = '$date') group by imeinumber having count(id) > 1 order by id desc";
|
| - |
|
149 |
} else{
|
| - |
|
150 |
$sql = "select count(id) as count,date(created) as date,user_id from devices where imeinumber in (select imeinumber from devices where date(created) = curdate()) group by imeinumber having count(id) > 1 order by id desc";
|
| - |
|
151 |
}
|
| - |
|
152 |
$device_upgrades = $this->Device->query($sql);
|
| - |
|
153 |
$this->set(compact('device_upgrades'));
|
| - |
|
154 |
}
|
| 142 |
}
|
155 |
}
|
| 143 |
|
156 |
|