/**
* Retrieves all mouse clicks/touch screen taps
*
* @since 1.0
*/
public function retrieve_user_events()
{
$ajax_nonce = $_GET['nonce'];
$response = array();
if (wp_verify_nonce($ajax_nonce, HA_Common::PLUGIN_ID . '-nonce')) {
$response = array('status' => 'OK', 'message' => '');
// GET parameters
$url = isset($_GET['url']) ? HA_Common::normalize_url(urldecode($_GET['url'])) : null;
$ignore_width = isset($_GET['ignoreWidth']) && $_GET['ignoreWidth'] == "true" ? true : false;
$width_allowance = isset($_GET['widthAllowance']) && is_numeric($_GET['widthAllowance']) ? intval($_GET['widthAllowance']) : null;
$page_width = isset($_GET['pageWidth']) && is_numeric($_GET['pageWidth']) ? intval($_GET['pageWidth']) : null;
$user_event_id = isset($_GET['userEventId']) && is_numeric($_GET['userEventId']) ? intval($_GET['userEventId']) : null;
$ignore_device = isset($_GET['ignoreDevice']) && $_GET['ignoreDevice'] == "true" ? true : false;
$device = isset($_GET['device']) && strlen(trim($_GET['device'])) > 0 ? urldecode($_GET['device']) : null;
$ignore_os = isset($_GET['ignoreOs']) && $_GET['ignoreOs'] == "true" ? true : false;
$os = isset($_GET['os']) && strlen(trim($_GET['os'])) > 0 ? urldecode($_GET['os']) : null;
$ignore_browser = isset($_GET['ignoreBrowser']) && $_GET['ignoreBrowser'] == "true" ? true : false;
$browser = isset($_GET['browser']) && strlen(trim($_GET['browser'])) > 0 ? urldecode($_GET['browser']) : null;
$hide_roles = isset($_GET['hideRoles']) && is_array($_GET['hideRoles']) ? $_GET['hideRoles'] : array();
$spot_radius = isset($_GET['spotRadius']) && is_numeric($_GET['spotRadius']) ? intval($_GET['spotRadius']) : null;
$event_types = isset($_GET['eventTypes']) && is_array($_GET['eventTypes']) ? $_GET['eventTypes'] : array();
// validate data
if (!$url || !count($event_types) > 0) {
$response['status'] = 'Error';
$response['message'] = 'Required data missing from request';
echo json_encode($response);
return;
}
global $wpdb;
// base query - all user events for a given url
$query = 'SELECT u_event.' . HA_Common::ID_COLUMN . ', u_event.' . HA_Common::X_COORD_COLUMN . ', u_event.' . HA_Common::Y_COORD_COLUMN . ', u_event.' . HA_Common::URL_COLUMN . ', u_event.' . HA_Common::EVENT_TYPE_COLUMN . ', u_event.' . HA_Common::PAGE_WIDTH_COLUMN . ' FROM ' . $wpdb->prefix . HA_Common::USER_EVENT_TBL_NAME . ' AS u_event, ' . $wpdb->prefix . HA_Common::USER_ENV_TBL_NAME . ' AS u_env, ' . $wpdb->prefix . HA_Common::USER_TBL_NAME . ' AS u WHERE u.' . HA_Common::ID_COLUMN . ' = u_event.' . HA_Common::USER_ID_COLUMN . ' AND u.' . HA_Common::ID_COLUMN . ' = u_env.' . HA_Common::USER_ID_COLUMN . ' AND u_event.' . HA_Common::URL_COLUMN . ' = "' . $url . '"';
$query_filters = array('ignore_width' => $ignore_width, 'width_allowance' => $width_allowance, 'page_width' => $page_width, 'user_event_id' => $user_event_id, 'ignore_device' => $ignore_device, 'device' => $device, 'ignore_os' => $ignore_os, 'os' => $os, 'ignore_browser' => $ignore_browser, 'browser' => $browser, 'hide_roles' => $hide_roles, 'event_types' => $event_types, 'exact_match' => false);
$query = HA_Query_Helper::apply_query_filters($query, $query_filters);
$rows = $wpdb->get_results($query);
$index = 0;
foreach ($rows as $row) {
$user_event_id = $row->id;
$x_coord = $row->x_coord;
$y_coord = $row->y_coord;
$url = HA_Common::normalize_url($row->url);
$page_width = $row->page_width;
$heat_value = HA_Common::calculate_heat_value($x_coord, $y_coord, $user_event_id, $rows, $spot_radius);
$response[$index++] = array('user_event_id' => $user_event_id, 'x_coord' => $x_coord, 'y_coord' => $y_coord, 'page_width' => $page_width, 'url' => $url, 'heat_value' => $heat_value, 'event_type' => $row->event_type);
}
}
echo json_encode($response);
die;
}
private function event_totals_bar_graph_report_data($filters)
{
global $wpdb;
// Counts data
$query = 'SELECT count(*) as count, u_event.' . HA_Common::EVENT_TYPE_COLUMN . ' FROM ' . $wpdb->prefix . HA_Common::USER_TBL_NAME . ' AS u, ' . $wpdb->prefix . HA_Common::USER_EVENT_TBL_NAME . ' AS u_event, ' . $wpdb->prefix . HA_Common::USER_ENV_TBL_NAME . ' AS u_env WHERE u_event.' . HA_Common::USER_ENV_ID_COLUMN . ' = u_env.' . HA_Common::ID_COLUMN . ' AND u.' . HA_Common::ID_COLUMN . ' = u_event.' . HA_Common::USER_ID_COLUMN;
$query = HA_Query_Helper::apply_query_filters($query, $filters);
$query .= ' GROUP BY ' . HA_Common::EVENT_TYPE_COLUMN;
$rows = $wpdb->get_results($query);
$count_data = array();
foreach ($rows as $row) {
$event_type = $row->event_type;
$count = $row->count;
array_push($count_data, array($event_type, $count));
}
return json_decode(json_encode(array('count_data' => $count_data)), false);
}
