public function get_browser_usage($form_id)
{
$browsers['Chrome'] = (object) array("visits" => 0, "submissions" => 0);
$browsers['Safari'] = (object) array("visits" => 0, "submissions" => 0);
$browsers['Internet Explorer'] = (object) array("visits" => 0, "submissions" => 0);
$browsers['Opera'] = (object) array("visits" => 0, "submissions" => 0);
$browsers['Android'] = (object) array("visits" => 0, "submissions" => 0);
$browsers['iPhone'] = (object) array("visits" => 0, "submissions" => 0);
$browsers['Firefox'] = (object) array("visits" => 0, "submissions" => 0);
$browsers['BlackBerry'] = (object) array("visits" => 0, "submissions" => 0);
$browsers['Other'] = (object) array("visits" => 0, "submissions" => 0);
$temp = RM_DBManager::count_multiple('STATS', "browser_name", array('form_id' => $form_id), array('browser_name' => 'Chrome,Safari,Opera,Internet Explorer,Firefox,iPhone,Android,BlackBerry'));
$known_browser_visits = array();
$total_known_browser_visits = 0;
if (is_array($temp) || is_object($temp)) {
foreach ($temp as $stat) {
$known_browser_visits[$stat->browser_name] = (int) $stat->count;
$browsers[$stat->browser_name]->visits = (int) $stat->count;
$total_known_browser_visits += $known_browser_visits[$stat->browser_name];
}
}
$browsers['Other']->visits = (int) $total_known_browser_visits;
$temp = RM_DBManager::count_multiple('STATS', "browser_name", array('form_id' => $form_id, 'submitted_on' => 'not null'), array('browser_name' => 'Chrome,Safari,Opera,Internet Explorer,Firefox,iPhone,Android,BlackBerry'));
$known_browser_submissions = array();
$total_known_browser_submissions = 0;
//echo "<pre>",var_dump($browsers),"</pre>";
if (is_array($temp) || is_object($temp)) {
foreach ($temp as $stat) {
$known_browser_submissions[$stat->browser_name] = (int) $stat->count;
$browsers[$stat->browser_name]->submissions = (int) $stat->count;
$total_known_browser_submissions += $known_browser_submissions[$stat->browser_name];
}
}
$browsers['Other']->submissions = (int) $total_known_browser_submissions;
// echo "<pre>",var_dump($browsers),"</pre>";
$usage = new stdClass();
$usage->browser_submission = $known_browser_submissions;
$usage->total_known_browser_submission = $total_known_browser_submissions;
$usage->browser_usage = $known_browser_visits;
$usage->total_known_browser_usage = $total_known_browser_visits;
$usage->browsers = $browsers;
return $usage;
}