| Line 28... |
Line 28... |
| 28 |
*/
|
28 |
*/
|
| 29 |
public function admin_index() {
|
29 |
public function admin_index() {
|
| 30 |
$this->NotificationCampaign->recursive = 0;
|
30 |
$this->NotificationCampaign->recursive = 0;
|
| 31 |
$this->Paginator->settings = array('order' => array('id'=>'desc'));
|
31 |
$this->Paginator->settings = array('order' => array('id'=>'desc'));
|
| 32 |
$vari = $this->Paginator->paginate();
|
32 |
$vari = $this->Paginator->paginate();
|
| - |
|
33 |
$checkArray=array();
|
| 33 |
foreach ($vari as $key => $value) {
|
34 |
foreach ($vari as $key => $value) {
|
| 34 |
$cid=$value['NotificationCampaign']['id'];
|
35 |
$cid=$value['NotificationCampaign']['id'];
|
| 35 |
$sqlQuery = "SELECT status as status,notification_campaign_id,type,count(*) as count FROM pushnotifications group by notification_campaign_id, type,status";
|
36 |
$sqlQuery = "SELECT status as status,notification_campaign_id,type,count(*) as count FROM pushnotifications group by notification_campaign_id, type,status";
|
| - |
|
37 |
#$successQuery="SELECT count(*) as count from pushnotifications where status=1 and type='sent' and notification_campaign_id=$cid";
|
| - |
|
38 |
$successQuery="SELECT count(distinct p.user_id) as count from pushnotifications p join devices d on p.user_id=d.user_id where status=1 and type='sent' and notification_campaign_id='$cid' and d.versioncode>=14";
|
| 36 |
$resul=$this->NotificationCampaign->query($sqlQuery);
|
39 |
$resul=$this->NotificationCampaign->query($sqlQuery);
|
| - |
|
40 |
$success_result=$this->NotificationCampaign->query($successQuery);
|
| - |
|
41 |
array_push($checkArray, $success_result[0][0]['count']);
|
| 37 |
}
|
42 |
}
|
| 38 |
$finalResult = array();
|
43 |
$finalResult = array();
|
| 39 |
foreach ($resul as $key => $value) {
|
44 |
foreach ($resul as $key => $value) {
|
| 40 |
$finalResult[$value['pushnotifications']['notification_campaign_id']][$value['pushnotifications']['type']]=$value[0]['count'];
|
45 |
$finalResult[$value['pushnotifications']['notification_campaign_id']][$value['pushnotifications']['type']]=$value[0]['count'];
|
| 41 |
$finalResult[$value['pushnotifications']['notification_campaign_id']][$value['pushnotifications']['status']]=$value[0]['count'];
|
46 |
$finalResult[$value['pushnotifications']['notification_campaign_id']][$value['pushnotifications']['status']]=$value[0]['count'];
|
| 42 |
//$finalResult[$value['pushnotifications']['notification_campaign_id']][$value['pushnotifications']['type']]=$value[0]['status'];
|
47 |
//$finalResult[$value['pushnotifications']['notification_campaign_id']][$value['pushnotifications']['type']]=$value[0]['status'];
|
| 43 |
}
|
48 |
}
|
| 44 |
/*debug($finalResult);*/
|
49 |
$this->set('notificationWithVersionCode', $checkArray);
|
| 45 |
$this->set('notificationCampaigns', $vari);
|
50 |
$this->set('notificationCampaigns', $vari);
|
| 46 |
$this->set('notificationCampaignsCount', $finalResult);
|
51 |
$this->set('notificationCampaignsCount', $finalResult);
|
| 47 |
|
52 |
|
| 48 |
}
|
53 |
}
|
| 49 |
|
54 |
|
| Line 234... |
Line 239... |
| 234 |
$this->Session->setFlash(__('Push notification scheduled for '.sizeof($users).' users'));
|
239 |
$this->Session->setFlash(__('Push notification scheduled for '.sizeof($users).' users'));
|
| 235 |
return $this->redirect(array('controller' => 'administration', 'action' => 'dashboard', 'admin' => false));
|
240 |
return $this->redirect(array('controller' => 'administration', 'action' => 'dashboard', 'admin' => false));
|
| 236 |
}
|
241 |
}
|
| 237 |
}
|
242 |
}
|
| 238 |
}
|
243 |
}
|
| 239 |
}
|
- |
|
| 240 |
|
244 |
}
|
| - |
|
245 |
|
| - |
|
246 |
|