Edit File by line

<?php

[0] Fix | Delete

[1] Fix | Delete

// Preventing to direct access

[2] Fix | Delete

defined( 'ABSPATH' ) OR die( 'Direct access not acceptable!' );

[3] Fix | Delete

[4] Fix | Delete

if ( ! class_exists( 'WWS_Analytics' ) ) :

[5] Fix | Delete

[6] Fix | Delete

/**

[7] Fix | Delete

* Plugin public analytics report

[8] Fix | Delete

* @package WeCreativez/Classes

[9] Fix | Delete

* @since 1.4

[10] Fix | Delete

[11] Fix | Delete

class WWS_Analytics {

[12] Fix | Delete

[13] Fix | Delete

public function __construct() {

[14] Fix | Delete

[15] Fix | Delete

add_action( "wp_ajax_wws_click_analytics", array( $this, 'click_analytics' ) );

[16] Fix | Delete

add_action( "wp_ajax_nopriv_wws_click_analytics", array( $this, 'click_analytics' ) );

[17] Fix | Delete

[18] Fix | Delete

add_action( "wp_ajax_wws_analytics_deep_report", array( $this, 'analytics_deep_report' ) );

[19] Fix | Delete

add_action( "wp_ajax_nopriv_wws_analytics_deep_report", array( $this, 'analytics_deep_report' ) );

[20] Fix | Delete

[21] Fix | Delete

add_action( 'admin_init', array( $this, 'delete_complete_analytics' ) );

[22] Fix | Delete

add_action( 'admin_init', array( $this, 'delete_analytics' ) );

[23] Fix | Delete

[24] Fix | Delete

}

[25] Fix | Delete

[26] Fix | Delete

[27] Fix | Delete

public function delete_complete_analytics() {

[28] Fix | Delete

if ( ! isset( $_GET['wws_delete_complete_analytics'] ) || ! wp_verify_nonce( $_GET['_wpnonce'] ) ) {

[29] Fix | Delete

return;

[30] Fix | Delete

}

[31] Fix | Delete

[32] Fix | Delete

if ( ! is_admin() ) {

[33] Fix | Delete

return;

[34] Fix | Delete

}

[35] Fix | Delete

[36] Fix | Delete

$this->_delete_all_analytics();

[37] Fix | Delete

[38] Fix | Delete

wp_redirect( admin_url( 'admin.php?page=wc-whatsapp-support-analytics' ) );

[39] Fix | Delete

[40] Fix | Delete

[41] Fix | Delete

}

[42] Fix | Delete

[43] Fix | Delete

public function delete_analytics() {

[44] Fix | Delete

[45] Fix | Delete

if ( ! isset( $_GET['wws_delete_analytics'] ) ) {

[46] Fix | Delete

return;

[47] Fix | Delete

}

[48] Fix | Delete

[49] Fix | Delete

if ( ! is_admin() ) {

[50] Fix | Delete

return;

[51] Fix | Delete

}

[52] Fix | Delete

[53] Fix | Delete

global $wpdb;

[54] Fix | Delete

[55] Fix | Delete

$wws_analytics_table = $wpdb->prefix.'wws_analytics';

[56] Fix | Delete

[57] Fix | Delete

$wpdb->delete( $wws_analytics_table, array( 'ID' => $_GET['wws_delete_analytics'] ), array( '%d' ) );

[58] Fix | Delete

[59] Fix | Delete

wp_redirect( wp_get_referer() );

[60] Fix | Delete

exit;

[61] Fix | Delete

}

[62] Fix | Delete

[63] Fix | Delete

[64] Fix | Delete

public function click_analytics() {

[65] Fix | Delete

global $wpdb;

[66] Fix | Delete

check_ajax_referer( 'wws-security-token', 'security' );

[67] Fix | Delete

[68] Fix | Delete

$click_analytics = apply_filters( 'wws_click_analytics', array(

[69] Fix | Delete

'visitor_ip' => sanitize_text_field( $this->_get_current_ip() ),

[70] Fix | Delete

'number' => ( isset( $_POST['number'] ) ? sanitize_text_field( $_POST['number'] ) : 'N/A' ),

[71] Fix | Delete

'message' => ( isset( $_POST['message'] ) ? sanitize_text_field( $_POST['message'] ) : 'N/A' ),

[72] Fix | Delete

'through' => ( isset( $_POST['through'] ) ? sanitize_text_field( $_POST['through'] ) : 'N/A' ),

[73] Fix | Delete

'referral' => esc_url_raw( $this->_get_current_url() ),

[74] Fix | Delete

'device_type' => ( wp_is_mobile() == true ? 'Mobile' : 'Desktop' ),

[75] Fix | Delete

'os' => sanitize_text_field( $this->_getOS() ),

[76] Fix | Delete

'browser' => sanitize_text_field( $this->getBrowser() ),

[77] Fix | Delete

'date' => current_time('M d, y - H:i:s'),

[78] Fix | Delete

'timestamp' => time(),

[79] Fix | Delete

) );

[80] Fix | Delete

[81] Fix | Delete

do_action( 'wws_before_click_analytics', $click_analytics );

[82] Fix | Delete

[83] Fix | Delete

$wpdb->insert(

[84] Fix | Delete

$wpdb->prefix.'wws_analytics',

[85] Fix | Delete

$click_analytics

[86] Fix | Delete

);

[87] Fix | Delete

[88] Fix | Delete

do_action( 'wws_after_click_analytics', $click_analytics );

[89] Fix | Delete

[90] Fix | Delete

wp_die();

[91] Fix | Delete

}

[92] Fix | Delete

[93] Fix | Delete

public function analytics_deep_report() {

[94] Fix | Delete

[95] Fix | Delete

if ( ! is_admin() ) {

[96] Fix | Delete

return;

[97] Fix | Delete

}

[98] Fix | Delete

[99] Fix | Delete

$ip = $_GET['ip'];

[100] Fix | Delete

[101] Fix | Delete

$ip_data = maybe_unserialize( file_get_contents( "http://ip-api.com/php/$ip" ) );

[102] Fix | Delete

[103] Fix | Delete

$ip_city = isset( $ip_data['city'] ) ? $ip_data['city'] : '';

[104] Fix | Delete

$ip_region = isset( $ip_data['regionName'] ) ? $ip_data['regionName'] : '';

[105] Fix | Delete

$ip_country = isset( $ip_data['country'] ) ? $ip_data['country'] : '';

[106] Fix | Delete

$ip_zip = isset( $ip_data['zip'] ) ? $ip_data['zip'] : '';

[107] Fix | Delete

[108] Fix | Delete

$ip_lon = isset( $ip_data['lon'] ) ? $ip_data['lon'] : '';

[109] Fix | Delete

$ip_lat = isset( $ip_data['lat'] ) ? $ip_data['lat'] : '';

[110] Fix | Delete

[111] Fix | Delete

$ip_org = isset( $ip_data['org'] ) ? $ip_data['org'] : '';

[112] Fix | Delete

$ip_as = isset( $ip_data['as'] ) ? $ip_data['as'] : '';

[113] Fix | Delete

$ip_isp = isset( $ip_data['isp'] ) ? $ip_data['isp'] : '';

[114] Fix | Delete

[115] Fix | Delete

$ip_timezone = isset( $ip_data['timezone'] ) ? $ip_data['timezone'] : '';

[116] Fix | Delete

[117] Fix | Delete

[118] Fix | Delete

require_once WWS_PLUGIN_PATH . 'includes/admin/views/analytics/admin-deep-analytics.php';

[119] Fix | Delete

[120] Fix | Delete

wp_die();

[121] Fix | Delete

}

[122] Fix | Delete

[123] Fix | Delete

[124] Fix | Delete

protected function _get_current_url() {

[125] Fix | Delete

return wp_get_referer();

[126] Fix | Delete

}

[127] Fix | Delete

[128] Fix | Delete

[129] Fix | Delete

protected function _get_current_ip() {

[130] Fix | Delete

if ( isset( $_SERVER['HTTP_CLIENT_IP'] ) ) {

[131] Fix | Delete

//check ip from share internet

[132] Fix | Delete

$ip = $_SERVER['HTTP_CLIENT_IP'];

[133] Fix | Delete

} elseif ( isset( $_SERVER['HTTP_X_FORWARDED_FOR'] ) ) {

[134] Fix | Delete

//to check ip is pass from proxy

[135] Fix | Delete

$ip = $_SERVER['HTTP_X_FORWARDED_FOR'];

[136] Fix | Delete

} else {

[137] Fix | Delete

$ip = $_SERVER['REMOTE_ADDR'];

[138] Fix | Delete

}

[139] Fix | Delete

return $ip;

[140] Fix | Delete

}

[141] Fix | Delete

[142] Fix | Delete

[143] Fix | Delete

protected function _getOS() {

[144] Fix | Delete

$os_platform = "Unknown OS Platform";

[145] Fix | Delete

[146] Fix | Delete

$os_array = array(

[147] Fix | Delete

'/windows nt 10/i' => 'Windows 10',

[148] Fix | Delete

'/windows nt 6.3/i' => 'Windows 8.1',

[149] Fix | Delete

'/windows nt 6.2/i' => 'Windows 8',

[150] Fix | Delete

'/windows nt 6.1/i' => 'Windows 7',

[151] Fix | Delete

'/windows nt 6.0/i' => 'Windows Vista',

[152] Fix | Delete

'/windows nt 5.2/i' => 'Windows Server 2003/XP x64',

[153] Fix | Delete

'/windows nt 5.1/i' => 'Windows XP',

[154] Fix | Delete

'/windows xp/i' => 'Windows XP',

[155] Fix | Delete

'/windows nt 5.0/i' => 'Windows 2000',

[156] Fix | Delete

'/windows me/i' => 'Windows ME',

[157] Fix | Delete

'/win98/i' => 'Windows 98',

[158] Fix | Delete

'/win95/i' => 'Windows 95',

[159] Fix | Delete

'/win16/i' => 'Windows 3.11',

[160] Fix | Delete

'/macintosh|mac os x/i' => 'Mac OS X',

[161] Fix | Delete

'/mac_powerpc/i' => 'Mac OS 9',

[162] Fix | Delete

'/linux/i' => 'Linux',

[163] Fix | Delete

'/ubuntu/i' => 'Ubuntu',

[164] Fix | Delete

'/iphone/i' => 'iPhone',

[165] Fix | Delete

'/ipod/i' => 'iPod',

[166] Fix | Delete

'/ipad/i' => 'iPad',

[167] Fix | Delete

'/android/i' => 'Android',

[168] Fix | Delete

'/blackberry/i' => 'BlackBerry',

[169] Fix | Delete

'/webos/i' => 'Mobile'

[170] Fix | Delete

);

[171] Fix | Delete

[172] Fix | Delete

foreach ($os_array as $regex => $value)

[173] Fix | Delete

if (preg_match($regex, $_SERVER['HTTP_USER_AGENT']))

[174] Fix | Delete

$os_platform = $value;

[175] Fix | Delete

[176] Fix | Delete

return $os_platform;

[177] Fix | Delete

}

[178] Fix | Delete

[179] Fix | Delete

[180] Fix | Delete

[181] Fix | Delete

[182] Fix | Delete

protected function getBrowser(){

[183] Fix | Delete

$user_agent = $_SERVER['HTTP_USER_AGENT'];

[184] Fix | Delete

if(strpos($user_agent, 'Maxthon') !== FALSE)

[185] Fix | Delete

return "Maxthon";

[186] Fix | Delete

elseif(strpos($user_agent, 'SeaMonkey') !== FALSE)

[187] Fix | Delete

return "SeaMonkey";

[188] Fix | Delete

elseif(strpos($user_agent, 'Vivaldi') !== FALSE)

[189] Fix | Delete

return "Vivaldi";

[190] Fix | Delete

elseif(strpos($user_agent, 'Arora') !== FALSE)

[191] Fix | Delete

return "Arora";

[192] Fix | Delete

elseif(strpos($user_agent, 'Avant Browser') !== FALSE)

[193] Fix | Delete

return "Avant Browser";

[194] Fix | Delete

elseif(strpos($user_agent, 'Beamrise') !== FALSE)

[195] Fix | Delete

return "Beamrise";

[196] Fix | Delete

elseif(strpos($user_agent, 'Epiphany') !== FALSE)

[197] Fix | Delete

return 'Epiphany';

[198] Fix | Delete

elseif(strpos($user_agent, 'Chromium') !== FALSE)

[199] Fix | Delete

return 'Chromium';

[200] Fix | Delete

elseif(strpos($user_agent, 'Iceweasel') !== FALSE)

[201] Fix | Delete

return 'Iceweasel';

[202] Fix | Delete

elseif(strpos($user_agent, 'Galeon') !== FALSE)

[203] Fix | Delete

return 'Galeon';

[204] Fix | Delete

elseif(strpos($user_agent, 'Edge') !== FALSE)

[205] Fix | Delete

return 'Microsoft Edge';

[206] Fix | Delete

elseif(strpos($user_agent, 'Trident') !== FALSE) //IE 11

[207] Fix | Delete

return 'Internet Explorer';

[208] Fix | Delete

elseif(strpos($user_agent, 'MSIE') !== FALSE)

[209] Fix | Delete

return 'Internet Explorer';

[210] Fix | Delete

elseif(strpos($user_agent, 'Opera Mini') !== FALSE)

[211] Fix | Delete

return "Opera Mini";

[212] Fix | Delete

elseif(strpos($user_agent, 'Opera') || strpos($user_agent, 'OPR') !== FALSE)

[213] Fix | Delete

return "Opera";

[214] Fix | Delete

elseif(strpos($user_agent, 'Firefox') !== FALSE)

[215] Fix | Delete

return 'Mozilla Firefox';

[216] Fix | Delete

elseif(strpos($user_agent, 'Chrome') !== FALSE)

[217] Fix | Delete

return 'Google Chrome';

[218] Fix | Delete

elseif(strpos($user_agent, 'Safari') !== FALSE)

[219] Fix | Delete

return "Safari";

[220] Fix | Delete

elseif(strpos($user_agent, 'iTunes') !== FALSE)

[221] Fix | Delete

return 'iTunes';

[222] Fix | Delete

elseif(strpos($user_agent, 'Konqueror') !== FALSE)

[223] Fix | Delete

return 'Konqueror';

[224] Fix | Delete

elseif(strpos($user_agent, 'Dillo') !== FALSE)

[225] Fix | Delete

return 'Dillo';

[226] Fix | Delete

elseif(strpos($user_agent, 'Netscape') !== FALSE)

[227] Fix | Delete

return 'Netscape';

[228] Fix | Delete

elseif(strpos($user_agent, 'Midori') !== FALSE)

[229] Fix | Delete

return 'Midori';

[230] Fix | Delete

elseif(strpos($user_agent, 'ELinks') !== FALSE)

[231] Fix | Delete

return 'ELinks';

[232] Fix | Delete

elseif(strpos($user_agent, 'Links') !== FALSE)

[233] Fix | Delete

return 'Links';

[234] Fix | Delete

elseif(strpos($user_agent, 'Lynx') !== FALSE)

[235] Fix | Delete

return 'Lynx';

[236] Fix | Delete

elseif(strpos($user_agent, 'w3m') !== FALSE)

[237] Fix | Delete

return 'w3m';

[238] Fix | Delete

else

[239] Fix | Delete

return 'Unknown';

[240] Fix | Delete

}

[241] Fix | Delete

[242] Fix | Delete

[243] Fix | Delete

public static function get_complete_analytics( $order = 'DESC' ) {

[244] Fix | Delete

global $wpdb;

[245] Fix | Delete

$wws_analytics_table = $wpdb->prefix.'wws_analytics';

[246] Fix | Delete

return $wpdb->get_results( "SELECT * FROM {$wws_analytics_table} ORDER BY id $order", ARRAY_A );

[247] Fix | Delete

}

[248] Fix | Delete

[249] Fix | Delete

public static function get_total_clicks() {

[250] Fix | Delete

global $wpdb;

[251] Fix | Delete

$wws_analytics_table = $wpdb->prefix.'wws_analytics';

[252] Fix | Delete

return count( $wpdb->get_results( "SELECT id FROM {$wws_analytics_table}", ARRAY_A ) );

[253] Fix | Delete

}

[254] Fix | Delete

[255] Fix | Delete

public static function get_total_clicks_by_mobile() {

[256] Fix | Delete

global $wpdb;

[257] Fix | Delete

$wws_analytics_table = $wpdb->prefix.'wws_analytics';

[258] Fix | Delete

return count( $wpdb->get_results( "SELECT id FROM {$wws_analytics_table} WHERE device_type = 'Mobile'", ARRAY_A ) );

[259] Fix | Delete

}

[260] Fix | Delete

[261] Fix | Delete

public static function get_total_clicks_by_desktop() {

[262] Fix | Delete

global $wpdb;

[263] Fix | Delete

$wws_analytics_table = $wpdb->prefix.'wws_analytics';

[264] Fix | Delete

return count( $wpdb->get_results( "SELECT id FROM {$wws_analytics_table} WHERE device_type = 'Desktop'", ARRAY_A ) );

[265] Fix | Delete

}

[266] Fix | Delete

[267] Fix | Delete

/**

[268] Fix | Delete

* Display top 10 IP address analytic.

[269] Fix | Delete

[270] Fix | Delete

* @global $wpdb WordPress database connection.

[271] Fix | Delete

[272] Fix | Delete

* @since 2.0.0

[273] Fix | Delete

* @return string

[274] Fix | Delete

[275] Fix | Delete

public static function the_top_ten_ip_address() {

[276] Fix | Delete

global $wpdb;

[277] Fix | Delete

[278] Fix | Delete

$html = '';

[279] Fix | Delete

[280] Fix | Delete

$query = $wpdb->get_results(

[281] Fix | Delete

"SELECT COUNT( visitor_ip ) as count, visitor_ip

[282] Fix | Delete

FROM {$wpdb->prefix}wws_analytics

[283] Fix | Delete

GROUP BY visitor_ip

[284] Fix | Delete

ORDER BY count DESC

[285] Fix | Delete

LIMIT 10",

[286] Fix | Delete

ARRAY_A

[287] Fix | Delete

);

[288] Fix | Delete

[289] Fix | Delete

if ( ! $query ) {

[290] Fix | Delete

return false;

[291] Fix | Delete

}

[292] Fix | Delete

[293] Fix | Delete

$html .= '<table>';

[294] Fix | Delete

$html .= '<thead>';

[295] Fix | Delete

$html .= '<tr>';

[296] Fix | Delete

$html .= '<th>' . esc_html__( 'IP Address', 'wc-wws' ) . '</th>';

[297] Fix | Delete

$html .= '<th>' . esc_html__( 'Clicks', 'wc-wws' ) . '</th>';

[298] Fix | Delete

$html .= '</tr>';

[299] Fix | Delete

$html .= '</thead>';

[300] Fix | Delete

$html .= '<tbody>';

[301] Fix | Delete

[302] Fix | Delete

foreach ( $query as $q ) {

[303] Fix | Delete

$html .= '<tr>';

[304] Fix | Delete

$html .= '<td>' . esc_html( $q['visitor_ip'] ) . '</td>';

[305] Fix | Delete

$html .= '<td>' . esc_html( $q['count'] ) . '</td>';

[306] Fix | Delete

$html .= '</tr>';

[307] Fix | Delete

}

[308] Fix | Delete

[309] Fix | Delete

$html .= '</tbody>';

[310] Fix | Delete

$html .= '</table>';

[311] Fix | Delete

[312] Fix | Delete

echo $html;

[313] Fix | Delete

}

[314] Fix | Delete

/**

[315] Fix | Delete

* Display top 10 referral links analytic.

[316] Fix | Delete

[317] Fix | Delete

* @global $wpdb WordPress database connection.

[318] Fix | Delete

[319] Fix | Delete

* @since 2.0.0

[320] Fix | Delete

* @return string

[321] Fix | Delete

[322] Fix | Delete

public static function the_top_ten_referral_links() {

[323] Fix | Delete

global $wpdb;

[324] Fix | Delete

[325] Fix | Delete

$html = '';

[326] Fix | Delete

[327] Fix | Delete

$query = $wpdb->get_results(

[328] Fix | Delete

"SELECT COUNT( referral ) as count, referral

[329] Fix | Delete

FROM {$wpdb->prefix}wws_analytics

[330] Fix | Delete

WHERE

[331] Fix | Delete

referral != ''

[332] Fix | Delete

GROUP BY referral

[333] Fix | Delete

ORDER BY count DESC

[334] Fix | Delete

LIMIT 10",

[335] Fix | Delete

ARRAY_A

[336] Fix | Delete

);

[337] Fix | Delete

[338] Fix | Delete

if ( ! $query ) {

[339] Fix | Delete

return false;

[340] Fix | Delete

}

[341] Fix | Delete

[342] Fix | Delete

$html .= '<table>';

[343] Fix | Delete

$html .= '<thead>';

[344] Fix | Delete

$html .= '<tr>';

[345] Fix | Delete

$html .= '<th>' . esc_html__( 'Referral Links', 'wc-wws' ) . '</th>';

[346] Fix | Delete

$html .= '<th>' . esc_html__( 'Clicks', 'wc-wws' ) . '</th>';

[347] Fix | Delete

$html .= '</tr>';

[348] Fix | Delete

$html .= '</thead>';

[349] Fix | Delete

$html .= '<tbody>';

[350] Fix | Delete

[351] Fix | Delete

foreach ( $query as $q ) {

[352] Fix | Delete

$html .= '<tr>';

[353] Fix | Delete

$html .= '<td><a href="' . esc_url( $q['referral'] ) . '" target="_blank">' . esc_url( $q['referral'] ) . '</a></td>';

[354] Fix | Delete

$html .= '<td>' . esc_html( $q['count'] ) . '</td>';

[355] Fix | Delete

$html .= '</tr>';

[356] Fix | Delete

}

[357] Fix | Delete

[358] Fix | Delete

$html .= '</tbody>';

[359] Fix | Delete

$html .= '</table>';

[360] Fix | Delete

[361] Fix | Delete

echo $html;

[362] Fix | Delete

}

[363] Fix | Delete

[364] Fix | Delete

/**

[365] Fix | Delete

* Display top 10 operating systems analytic.

[366] Fix | Delete

[367] Fix | Delete

* @global $wpdb WordPress database connection.

[368] Fix | Delete

[369] Fix | Delete

* @since 2.0.0

[370] Fix | Delete

* @return string

[371] Fix | Delete

[372] Fix | Delete

public static function the_top_ten_operating_systems() {

[373] Fix | Delete

global $wpdb;

[374] Fix | Delete

[375] Fix | Delete

$html = '';

[376] Fix | Delete

[377] Fix | Delete

$query = $wpdb->get_results(

[378] Fix | Delete

"SELECT COUNT( os ) as count, os

[379] Fix | Delete

FROM {$wpdb->prefix}wws_analytics

[380] Fix | Delete

GROUP BY os

[381] Fix | Delete

ORDER BY count DESC

[382] Fix | Delete

LIMIT 10",

[383] Fix | Delete

ARRAY_A

[384] Fix | Delete

);

[385] Fix | Delete

[386] Fix | Delete

if ( ! $query ) {

[387] Fix | Delete

return false;

[388] Fix | Delete

}

[389] Fix | Delete

[390] Fix | Delete

$html .= '<table>';

[391] Fix | Delete

$html .= '<thead>';

[392] Fix | Delete

$html .= '<tr>';

[393] Fix | Delete

$html .= '<th>' . esc_html__( 'Operating Systems', 'wc-wws' ) . '</th>';

[394] Fix | Delete

$html .= '<th>' . esc_html__( 'Clicks', 'wc-wws' ) . '</th>';

[395] Fix | Delete

$html .= '</tr>';

[396] Fix | Delete

$html .= '</thead>';

[397] Fix | Delete

$html .= '<tbody>';

[398] Fix | Delete

[399] Fix | Delete

foreach ( $query as $q ) {

[400] Fix | Delete

$html .= '<tr>';

[401] Fix | Delete

$html .= '<td>' . esc_html( $q['os'] ) . '</td>';

[402] Fix | Delete

$html .= '<td>' . esc_html( $q['count'] ) . '</td>';

[403] Fix | Delete

$html .= '</tr>';

[404] Fix | Delete

}

[405] Fix | Delete

[406] Fix | Delete

$html .= '</tbody>';

[407] Fix | Delete

$html .= '</table>';

[408] Fix | Delete

[409] Fix | Delete

echo $html;

[410] Fix | Delete

}

[411] Fix | Delete

[412] Fix | Delete

/**

[413] Fix | Delete

* Display top 10 browsers analytic.

[414] Fix | Delete

[415] Fix | Delete

* @global $wpdb WordPress database connection.

[416] Fix | Delete

[417] Fix | Delete

* @since 2.0.0

[418] Fix | Delete

* @return string

[419] Fix | Delete

[420] Fix | Delete

public static function the_top_ten_browsers() {

[421] Fix | Delete

global $wpdb;

[422] Fix | Delete

[423] Fix | Delete

$html = '';

[424] Fix | Delete

[425] Fix | Delete

$query = $wpdb->get_results(

[426] Fix | Delete

"SELECT COUNT( browser ) as count, browser

[427] Fix | Delete

FROM {$wpdb->prefix}wws_analytics

[428] Fix | Delete

GROUP BY browser

[429] Fix | Delete

ORDER BY count DESC

[430] Fix | Delete

LIMIT 10",

[431] Fix | Delete

ARRAY_A

[432] Fix | Delete

);

[433] Fix | Delete

[434] Fix | Delete

if ( ! $query ) {

[435] Fix | Delete

return false;

[436] Fix | Delete

}

[437] Fix | Delete

[438] Fix | Delete

$html .= '<table>';

[439] Fix | Delete

$html .= '<thead>';

[440] Fix | Delete

$html .= '<tr>';

[441] Fix | Delete

$html .= '<th>' . esc_html__( 'Browsers', 'wc-wws' ) . '</th>';

[442] Fix | Delete

$html .= '<th>' . esc_html__( 'Clicks', 'wc-wws' ) . '</th>';

[443] Fix | Delete

$html .= '</tr>';

[444] Fix | Delete

$html .= '</thead>';

[445] Fix | Delete

$html .= '<tbody>';

[446] Fix | Delete

[447] Fix | Delete

foreach ( $query as $q ) {

[448] Fix | Delete

$html .= '<tr>';

[449] Fix | Delete

$html .= '<td>' . esc_html( $q['browser'] ) . '</td>';

[450] Fix | Delete

$html .= '<td>' . esc_html( $q['count'] ) . '</td>';

[451] Fix | Delete

$html .= '</tr>';

[452] Fix | Delete

}

[453] Fix | Delete

[454] Fix | Delete

$html .= '</tbody>';

[455] Fix | Delete

$html .= '</table>';

[456] Fix | Delete

[457] Fix | Delete

echo $html;

[458] Fix | Delete

}

[459] Fix | Delete

[460] Fix | Delete

/**

[461] Fix | Delete

* Get current month analytics in chart format.

[462] Fix | Delete

[463] Fix | Delete

* @global $wpdb WordPress database connection.

[464] Fix | Delete

[465] Fix | Delete

* @since 2.0.0

[466] Fix | Delete

* @return void

[467] Fix | Delete

[468] Fix | Delete

public static function get_current_month_chart_data() {

[469] Fix | Delete

global $wpdb;

[470] Fix | Delete

[471] Fix | Delete

// Numeric representation of a month, without leading zeros

[472] Fix | Delete

$current_month = current_time( 'n' );

[473] Fix | Delete

// A two digit representation of a year

[474] Fix | Delete

$current_year = current_time( 'y' );

[475] Fix | Delete

// Calculate days in a month

[476] Fix | Delete

$days_in_month = cal_days_in_month( CAL_GREGORIAN, $current_month, $current_year );

[477] Fix | Delete

[478] Fix | Delete

$db_days = array();

[479] Fix | Delete

$days = array();

[480] Fix | Delete

$default_days = array(

[481] Fix | Delete

1 => 0, 2 => 0, 3 => 0, 4 => 0, 5 => 0,

[482] Fix | Delete

6 => 0, 7 => 0, 8 => 0, 9 => 0, 10 => 0,

[483] Fix | Delete

11 => 0, 12 => 0, 13 => 0, 14 => 0, 15 => 0,

[484] Fix | Delete

16 => 0, 17 => 0, 18 => 0, 19 => 0, 20 => 0,

[485] Fix | Delete

21 => 0, 22 => 0, 23 => 0, 24 => 0, 25 => 0,

[486] Fix | Delete

26 => 0, 27 => 0, 28 => 0,

[487] Fix | Delete

);

[488] Fix | Delete

[489] Fix | Delete

if ( $days_in_month > 28 ) {

[490] Fix | Delete

$default_days[29] = 0;

[491] Fix | Delete

}

[492] Fix | Delete

if ( $days_in_month > 29 ) {

[493] Fix | Delete

$default_days[30] = 0;

[494] Fix | Delete

}

[495] Fix | Delete

if ( $days_in_month > 30 ) {

[496] Fix | Delete

$default_days[31] = 0;

[497] Fix | Delete

}

[498] Fix | Delete

[499] Fix | Delete