function detail() { $id = addslashes($_GET['id']); // echo "in".$id; $nn = new PushLogger(); $arrLogs = $nn->getWhere("log_multicast_id = '{$id}' ORDER BY log_id ASC"); // pr($arrLogs); foreach ($arrLogs as $log) { $acc = new LL_Account(); $acc->getByID($log->log_macc_id); ?> <div class="hasil"> ID : <?php echo $acc->macc_id; ?> <?php echo $acc->macc_first_name; ?> <?php echo $acc->macc_last_name; ?> <br> Status : <?php echo $this->arrStatus[$log->log_status]; ?> <br> Message : <?php echo $log->log_text; ?> </div> <?php } }
public function exportIt($return) { $id = addslashes($_GET['cid']); // echo $id; if ($id == "" || $id < 1) { die("no id"); } $camp = new PushNotCamp(); $camp->getByID($id); $arrStatus = array("0" => "Not Pushed", "1" => "Pushed"); if ($camp->camp_app_id != AppAccount::getAppID()) { die("camp mismatched"); } // pr($camp); $onDate = ""; if ($camp->camp_status == 1) { $onDate = " on " . indonesian_date($camp->camp_send_date); } //hitung openrate dll $targetedDev = count(explode(",", $camp->camp_dev_ids)); $gcm = new GCMResult(); $arrGCM = $gcm->getWhere("camp_id = '{$id}' ORDER BY gcm_date DESC"); $succ = 0; $fail = 0; $seen_by = 0; foreach ($arrGCM as $cc) { $succ += $cc->success; $fail += $cc->failure; $seen_by += $cc->seen_by; } $openrate = round($seen_by / $succ * 100, 3); $del = round($succ / ($succ + $fail) * 100, 3); $filename = urlencode(str_replace(" ", "_", $camp->camp_name)) . "_" . date('Ymd') . ".xls"; header("Content-Disposition: attachment; filename=\"{$filename}\""); header("Content-Type: application/vnd.ms-excel"); $flag = false; print "Campaign Name : \t" . $camp->camp_title; //judul print "\n"; print "Status : \t" . $arrStatus[$camp->camp_status] . $onDate; //status and delieverd date print "\n"; print "Content : \t" . $camp->camp_title; print "\n"; print "Open Rate : \t" . $openrate; print "\n"; print "Seen By : \t" . $seen_by; print "\n"; print "Deliverable Percentage : \t" . $del; print "\n"; print "Targeted Devices : \t" . $targetedDev; print "\n"; print "Success : \t" . $succ; print "\n"; print "Failed : \t" . $fail; print "\n"; print "\n"; $logs = new PushLogger(); $objs = $logs->getWhere("log_camp_id = '{$id}'"); $filter = explode(",", $logs->exportList); foreach ($objs as $key => $obj) { foreach ($obj as $name => $value) { if (in_array($name, $filter)) { echo Lang::t($name) . "\t"; } } break; } print "\n"; foreach ($objs as $key => $obj) { foreach ($obj as $name => $value) { if (in_array($name, $filter)) { echo $value . "\t"; } } print "\n"; } exit; }