[], 'slimview2' => [], 'slimview3' => [], 'slimview4' => [], 'slimview5' => [], 'slimview6' => [], 'dashboard' => [], 'inactive' => [], ]; public static $resource_titles = []; /** * Initalize class properties */ public static function init() { // Has the class already been initialized? if (!empty(self::$reports)) { return true; } // Include and initialize the API to interact with the database include_once(__DIR__ . '/wp-slimstat-db.php'); wp_slimstat_db::init(); // Include the localization library include_once(plugin_dir_path(dirname(__FILE__, 2)) . 'languages/index.php'); // Define all the reports // // Parameters // - title : report name // - callback : function to use to render the report // - callback_args : parameters to pass to the function // - classes : determine the look and feel of this report ( tall, large, extralarge, full-width ) // - locations : where should the report appear ( slimview1, .., slimview4, dashboard ) // - tooltip : contextual help to be displayed on hover $chart_tooltip = '' . __('Chart Controls', 'wp-slimstat') . ''; $pageviews_chart_tooltip = '' . __('Pageviews', 'wp-slimstat') . '
' . __('Shows how many times your site’s pages have been viewed.', 'wp-slimstat') . ''; $human_visits_chart_tooltip = '' . __('Human Visits', 'wp-slimstat') . '
' . __('Track the number of real human visitors.', 'wp-slimstat') . ''; $pages_with_outbound_links_chart_tooltip = '' . __('Pages with Outbound Links', 'wp-slimstat') . '
' . __('Track how often visitors click outbound links on your site.', 'wp-slimstat') . ''; $search_terms_chart_tooltip = '' . __('Search Terms', 'wp-slimstat') . '
' . __('See how many times users find your site via search engines.', 'wp-slimstat') . ''; $traffic_sources_chart_tooltip = '' . __('Traffic Sources', 'wp-slimstat') . '
' . __('See how many visits come from each traffic source.', 'wp-slimstat') . ''; $users_chart_tooltip = '' . __('Users', 'wp-slimstat') . '
' . __('See how many users come to your site.', 'wp-slimstat') . ''; self::$reports = [ 'slim_p7_02' => [ 'title' => __('Access Log', 'wp-slimstat'), 'callback' => [self::class, 'show_access_log'], 'callback_args' => [ 'type' => 'recent', 'columns' => '*', 'raw' => ['wp_slimstat_db', 'get_recent'], ], 'classes' => ['full-width', 'tall'], 'locations' => ['slimview1', 'dashboard'], 'tooltip' => __('Color Codes', 'wp-slimstat') . '

' . __('From search result page', 'wp-slimstat') . '

' . __('Has Left Comments', 'wp-slimstat') . '

' . __('WP User', 'wp-slimstat') . '

' . __('Other Human', 'wp-slimstat') . '

' . __('Bot or Crawler', 'wp-slimstat') . '

', ], 'slim_p1_01' => [ 'title' => __('Pageviews', 'wp-slimstat'), 'callback' => [self::class, 'show_chart'], 'callback_args' => [ 'id' => 'slim_p1_01', 'chart_data' => [ 'data1' => 'COUNT( ip )', 'data2' => 'COUNT( DISTINCT ip )', ], 'chart_labels' => [ __('Pageviews', 'wp-slimstat'), (('on' == (wp_slimstat::$settings['hash_ip'] ?? 'off')) ? __('Unique Visitors', 'wp-slimstat') : __('Unique IPs', 'wp-slimstat')), ], ], 'classes' => ['extralarge', 'chart'], 'locations' => ['slimview2', 'dashboard'], 'tooltip' => $pageviews_chart_tooltip, ], 'slim_p1_03' => [ 'title' => __('At a Glance', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'raw' => ['wp_slimstat_db', 'get_overview_summary'], ], 'classes' => ['normal'], 'locations' => ['slimview2', 'dashboard'], ], 'slim_p1_04' => [ 'title' => __('Currently Online', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'ip', 'where' => '(dt_out > ' . (date_i18n('U') - 300) . ') OR (dt > ' . (date_i18n('U') - 300) . ')', 'order_by' => 'MAX(dt) DESC', 'more_select' => 'MAX(dt) AS dt', 'use_date_filters' => false, 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['slimview2', 'dashboard'], ], 'slim_p1_06' => [ 'title' => __('Recent Search Terms', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'recent', 'columns' => 'searchterms', 'where' => 'searchterms <> "_" AND searchterms <> "" AND searchterms IS NOT NULL', 'more_columns' => 'referer, resource', 'raw' => ['wp_slimstat_db', 'get_recent'], ], 'classes' => ['normal'], 'locations' => ['slimview2', 'slimview5'], 'tooltip' => __('Keywords used by your visitors to find your website on a search engine.', 'wp-slimstat'), ], 'slim_p1_08' => [ 'title' => __('Top Web Pages', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'resource', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['slimview2', 'dashboard'], 'tooltip' => __('Here a "page" is not just a WordPress page type, but any webpage on your site, including posts, products, categories, and any other custom post type. For example, you can set the corresponding filter where Resource Content Type equals cpt:you_cpt_slug_here to get top web pages for a specific custom post type you have.', 'wp-slimstat'), ], 'slim_p1_10' => [ 'title' => __('Top Referring Domains', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'REPLACE( SUBSTRING_INDEX( ( SUBSTRING_INDEX( ( SUBSTRING_INDEX( referer, "://", -1 ) ), "/", 1 ) ), ".", -5 ), "www.", "" )', 'as_column' => 'referer', 'filter_op' => 'contains', 'where' => 'referer NOT LIKE %s', 'where_params' => ['%' . str_replace('www.', '', parse_url(home_url(), PHP_URL_HOST)) . '%'], 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['slimview2', 'slimview5', 'dashboard'], ], 'slim_p1_11' => [ 'title' => __('Top Known Visitors', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'username', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['slimview2', 'dashboard'], ], 'slim_p1_12' => [ 'title' => __('Top Search Terms', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'searchterms', 'where' => 'searchterms <> "_" AND searchterms <> "" AND searchterms IS NOT NULL', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['slimview2', 'slimview4', 'slimview5', 'dashboard'], ], 'slim_p1_13' => [ 'title' => __('Top Countries', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'country', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], // 'color' => '#fff7ed', 'locations' => ['slimview2', 'slimview3', 'slimview5', 'dashboard'], 'tooltip' => __('You can configure Slimstat to not track specific Countries by setting the corresponding filter in Slimstat > Settings > Exclusions.', 'wp-slimstat'), ], 'slim_p1_15' => [ 'title' => __('Rankings', 'wp-slimstat'), 'callback' => [self::class, 'show_rankings'], 'callback_args' => [ 'id' => 'slim_p1_15', ], 'classes' => ['normal'], 'locations' => ['inactive'], 'tooltip' => __("Slimstat retrieves live information from Alexa, Facebook and Mozscape, to measures your site's rankings. Values are updated every 12 hours. Please enter your personal access ID in the settings to access your personalized Mozscape data.", 'wp-slimstat'), ], 'slim_p1_17' => [ 'title' => __('Top Language Families', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'SUBSTRING( language, 1, 2 )', 'as_column' => 'language', 'filter_op' => 'contains', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['inactive'], ], 'slim_p1_18' => [ 'title' => __('Users Currently Online', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'username', // Group OR conditions explicitly to help MySQL use indexes effectively // AND filter excludes anonymous/empty usernames from the deduplication 'where' => '((dt_out > ' . (date_i18n('U') - 300) . ') OR (dt > ' . (date_i18n('U') - 300) . ')) AND username <> "" AND username IS NOT NULL', 'use_date_filters' => false, 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['slimview2', 'dashboard'], 'tooltip' => __('When visitors leave a comment on your blog, WordPress assigns them a cookie. Slimstat leverages this information to identify returning visitors. Please note that visitors also include registered users.', 'wp-slimstat'), ], 'slim_p1_19_01' => [ 'title' => __('Search Terms', 'wp-slimstat'), 'callback' => [self::class, 'show_chart'], 'callback_args' => [ 'id' => 'slim_p1_19_01', 'chart_data' => [ 'data1' => 'COUNT( searchterms )', 'data2' => 'COUNT( DISTINCT searchterms )', 'where' => 'searchterms <> "_" AND searchterms IS NOT NULL AND searchterms <> ""', ], 'chart_labels' => [ __('Search Terms', 'wp-slimstat'), __('Unique Terms', 'wp-slimstat'), ], ], 'classes' => ['extralarge', 'chart'], 'locations' => ['slimview2'], 'tooltip' => $search_terms_chart_tooltip, ], 'slim_p2_01' => [ 'title' => __('Human Visits', 'wp-slimstat'), 'callback' => [self::class, 'show_chart'], 'callback_args' => [ 'id' => 'slim_p2_01', 'chart_data' => [ 'data1' => 'COUNT( DISTINCT visit_id )', 'data2' => 'COUNT( DISTINCT ip )', 'where' => '(visit_id > 0 AND browser_type <> 1)', ], 'chart_labels' => [ __('Visits', 'wp-slimstat'), __('Unique IPs', 'wp-slimstat'), ], ], 'classes' => ['extralarge', 'chart'], 'locations' => ['slimview3'], 'tooltip' => $human_visits_chart_tooltip, ], 'slim_p2_02' => [ 'title' => __('Audience Overview', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'raw' => ['wp_slimstat_db', 'get_visitors_summary'], ], 'classes' => ['normal'], 'locations' => ['slimview3', 'dashboard'], 'tooltip' => __('Where not otherwise specified, the metrics in this report are referred to human visitors.', 'wp-slimstat'), ], 'slim_p2_03' => [ 'title' => __('Top Languages', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'language', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['slimview3'], ], 'slim_p2_04' => [ 'title' => __('Top User Agents', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'browser, browser_version', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['slimview3', 'dashboard'], 'tooltip' => __('This report includes all types of clients, both bots and humans.', 'wp-slimstat'), ], 'slim_p2_05' => [ 'title' => __('Top Service Providers', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'ip', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['extralarge'], 'locations' => ['inactive'], 'tooltip' => __('Internet Service Provider: a company which provides other companies or individuals with access to the Internet. Your DSL or cable internet service is provided to you by your ISP.

You can ignore specific IP addresses by setting the corresponding filter under Settings > Slimstat > Filters.', 'wp-slimstat'), ], 'slim_p2_06' => [ 'title' => __('Top Operating Systems', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'platform', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['inactive'], 'tooltip' => __('Internet Service Provider: a company which provides other companies or individuals with access to the Internet. Your DSL or cable internet service is provided to you by your ISP.

You can ignore specific IP addresses by setting the corresponding filter under Settings > Slimstat > Filters.', 'wp-slimstat'), ], 'slim_p2_07' => [ 'title' => __('Top Screen Resolutions', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'screen_width, screen_height', 'where' => 'screen_width <> 0 AND screen_height <> 0', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['slimview3', 'dashboard'], ], 'slim_p2_08' => [ 'title' => __('Top Viewport Sizes', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'resolution', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['inactive'], ], 'slim_p2_12' => [ 'title' => __('Visit Duration', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'raw' => ['wp_slimstat_db', 'get_visits_duration'], ], 'classes' => ['normal'], 'locations' => ['slimview3'], 'tooltip' => __('All values represent the percentages of pageviews within the corresponding time range.', 'wp-slimstat'), ], 'slim_p2_13' => [ 'title' => __('Recent Countries', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'country', 'order_by' => 'MAX(dt) DESC', 'more_select' => 'MAX(dt) AS dt', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['inactive'], ], 'slim_p2_14' => [ 'title' => __('Recent Viewport Sizes', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'resolution', 'order_by' => 'MAX(dt) DESC', 'more_select' => 'MAX(dt) AS dt', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['inactive'], ], 'slim_p2_15' => [ 'title' => __('Recent Operating Systems', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'platform', 'order_by' => 'MAX(dt) DESC', 'more_select' => 'MAX(dt) AS dt', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['inactive'], ], 'slim_p2_16' => [ 'title' => __('Recent Browsers', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'browser, browser_version', 'order_by' => 'MAX(dt) DESC', 'more_select' => 'MAX(dt) AS dt', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['inactive'], ], 'slim_p2_17' => [ 'title' => __('Recent Languages', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'language', 'order_by' => 'MAX(dt) DESC', 'more_select' => 'MAX(dt) AS dt', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['inactive'], ], 'slim_p2_18' => [ 'title' => __('Top Browser Families', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'browser', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['inactive'], 'tooltip' => __('This report shows you what user agent families (no version considered) are popular among your visitors.', 'wp-slimstat'), ], 'slim_p2_19' => [ 'title' => __('Top OS Families', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'CONCAT( "p-", SUBSTRING( platform, 1, 3 ) )', 'as_column' => 'platform', 'filter_op' => 'contains', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['slimview3'], 'tooltip' => __('This report shows you what operating system families (no version considered) are popular among your visitors.', 'wp-slimstat'), ], 'slim_p2_20' => [ 'title' => __('Recent Users', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'username', 'where' => 'notes LIKE "%user:%"', 'order_by' => 'MAX(dt) DESC', 'more_select' => 'MAX(dt) AS dt', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['slimview3'], ], 'slim_p2_21' => [ 'title' => __('Top Users', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'username', 'where' => 'notes LIKE "%user:%"', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['slimview3', 'dashboard'], ], 'slim_p2_22_01' => [ 'title' => __('Users', 'wp-slimstat'), 'callback' => [self::class, 'show_chart'], 'callback_args' => [ 'id' => 'slim_p2_22_01', 'chart_data' => [ 'data1' => 'COUNT( username )', 'data2' => 'COUNT( DISTINCT username )', ], 'chart_labels' => [ __('Users', 'wp-slimstat'), __('Unique Users', 'wp-slimstat'), ], ], 'classes' => ['extralarge', 'chart'], 'locations' => ['slimview3'], 'tooltip' => $users_chart_tooltip, ], 'slim_p2_24' => [ 'title' => __('Top Bots', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'browser, browser_version', 'where' => 'browser_type = 1', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['slimview3'], ], 'slim_p2_25' => [ 'title' => __('Top Human Browsers', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'browser, browser_version', 'where' => 'browser_type != 1', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['slimview3'], ], 'slim_p3_01' => [ 'title' => __('Traffic Sources', 'wp-slimstat'), 'callback' => [self::class, 'show_chart'], 'callback_args' => [ 'id' => 'slim_p3_01', 'chart_data' => [ 'data1' => 'COUNT( DISTINCT referer )', 'data2' => 'COUNT( DISTINCT ip )', 'where' => '(referer IS NOT NULL AND referer NOT LIKE "%' . home_url() . '%")', ], 'chart_labels' => [ __('Domains', 'wp-slimstat'), __('Unique IPs', 'wp-slimstat'), ], ], 'classes' => ['extralarge', 'chart'], 'locations' => ['slimview5'], 'tooltip' => $traffic_sources_chart_tooltip, ], 'slim_p3_02' => [ 'title' => __('Traffic Summary', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'raw' => ['wp_slimstat_db', 'get_traffic_sources_summary'], ], 'classes' => ['normal'], 'locations' => ['slimview5'], ], 'slim_p4_01' => [ 'title' => __('Recent Outbound Links', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'outbound_resource', 'where' => "outbound_resource IS NOT NULL AND outbound_resource != ''", 'order_by' => 'MAX(dt) DESC', 'more_select' => 'MAX(dt) AS dt', 'raw' => ['wp_slimstat_db', 'get_top_outbound'], 'sort_outbound' => 'dt', ], 'classes' => ['large'], 'locations' => ['slimview4'], 'tooltip' => '', ], 'slim_p4_02' => [ 'title' => __('Recent Posts', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'TRIM( TRAILING "/" FROM resource )', 'as_column' => 'resource', 'where' => 'content_type = "post"', 'order_by' => 'MAX(dt) DESC', 'more_select' => 'MAX(dt) AS dt', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['slimview4'], ], 'slim_p4_04' => [ 'title' => __('Recent Feeds', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'recent', 'columns' => 'resource', 'where' => '(resource LIKE %s OR resource LIKE %s OR resource LIKE %s OR content_type LIKE %s)', 'where_params' => ['%/feed%', '%?feed=>%', '%&feed=>%', '%feed%'], 'raw' => ['wp_slimstat_db', 'get_recent'], ], 'classes' => ['normal'], 'locations' => ['inactive'], ], 'slim_p4_05' => [ 'title' => __('Recent Pages Not Found', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'resource', 'where' => '(resource LIKE "[404]%" OR content_type LIKE "%404%")', 'order_by' => 'MAX(dt) DESC', 'more_select' => 'MAX(dt) AS dt', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['slimview4'], ], 'slim_p4_06' => [ 'title' => __('Recent Internal Searches', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'recent', 'columns' => 'searchterms', 'where' => 'content_type LIKE %s AND searchterms <> "" AND searchterms IS NOT NULL', 'where_params' => ['%search%'], 'raw' => ['wp_slimstat_db', 'get_recent'], ], 'classes' => ['normal'], 'locations' => ['slimview4'], 'tooltip' => __("Searches performed using WordPress' built-in search functionality.", 'wp-slimstat'), ], 'slim_p4_07' => [ 'title' => __('Top Categories', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'category', 'where' => 'content_type LIKE "%category%"', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['slimview4', 'dashboard'], ], 'slim_p4_09' => [ 'title' => __('Top Downloads', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'resource', 'where' => 'content_type = "download"', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['large'], 'locations' => ['slimview4'], 'tooltip' => __('You can configure Slimstat to track specific file extensions as downloads.', 'wp-slimstat'), ], 'slim_p4_10' => [ 'title' => __('Recent Custom Events', 'wp-slimstat'), 'callback' => [self::class, 'show_events'], 'callback_args' => [ 'type' => 'recent', 'columns' => 'notes', 'raw' => ['wp_slimstat_db', 'get_recent_events'], ], 'classes' => ['normal'], 'locations' => ['inactive'], 'tooltip' => __('This report lists any event occurred on your website. Please refer to the FAQ for more information on how to use this functionality.', 'wp-slimstat'), ], 'slim_p4_11' => [ 'title' => __('Top Posts', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'TRIM( TRAILING "/" FROM resource )', 'as_column' => 'resource', 'where' => 'content_type = "post"', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['slimview4'], ], 'slim_p4_12' => [ 'title' => __('Top Custom Events', 'wp-slimstat'), 'callback' => [self::class, 'show_events'], 'callback_args' => [ 'type' => 'top', 'columns' => 'notes', 'raw' => ['wp_slimstat_db', 'get_top_events'], ], 'classes' => ['normal'], 'locations' => ['slimview4'], 'tooltip' => __('This report lists any event occurred on your website. Please refer to the FAQ for more information on how to use this functionality.', 'wp-slimstat'), ], 'slim_p4_13' => [ 'title' => __('Top Internal Searches', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'searchterms', 'where' => 'content_type LIKE %s AND searchterms <> "" AND searchterms IS NOT NULL', 'where_params' => ['%search%'], 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['slimview4'], ], 'slim_p4_15' => [ 'title' => __('Recent Categories', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'TRIM( TRAILING "/" FROM resource )', 'as_column' => 'resource', 'where' => '(content_type = "category")', 'order_by' => 'MAX(dt) DESC', 'more_select' => 'MAX(dt) AS dt', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['inactive'], ], 'slim_p4_152' => [ 'title' => __('Recent Tags', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'TRIM( TRAILING "/" FROM resource )', 'as_column' => 'resource', 'where' => '(content_type = "tag")', 'order_by' => 'MAX(dt) DESC', 'more_select' => 'MAX(dt) AS dt', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['inactive'], ], 'slim_p4_16' => [ 'title' => __('Top Pages Not Found', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'resource', 'where' => 'content_type LIKE "%404%"', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['slimview4'], ], 'slim_p4_18' => [ 'title' => __('Top Authors', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'author', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['slimview4', 'dashboard'], ], 'slim_p4_19' => [ 'title' => __('Top Tags', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'category', 'where' => '(content_type LIKE "%tag%")', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['inactive'], ], 'slim_p4_20' => [ 'title' => __('Recent Downloads', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'resource', 'where' => 'content_type = "download"', 'order_by' => 'MAX(dt) DESC', 'more_select' => 'MAX(dt) AS dt', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['large'], 'locations' => ['inactive'], ], 'slim_p4_21' => [ 'title' => __('Top Outbound Links', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'outbound_resource', 'raw' => ['wp_slimstat_db', 'get_top_outbound'], ], 'classes' => ['normal'], 'locations' => ['slimview4', 'dashboard'], ], 'slim_p4_22' => [ 'title' => __('Your Website', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'raw' => ['wp_slimstat_db', 'get_your_blog'], ], 'classes' => ['normal'], 'locations' => ['inactive'], 'tooltip' => __('Your content at a glance: posts, comments, pingbacks, etc. Please note that this report is not affected by the filters set here above.', 'wp-slimstat'), ], 'slim_p4_23' => [ 'title' => __('Top Bounce Pages', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'TRIM( TRAILING "/" FROM resource )', 'as_column' => 'resource', 'where' => 'content_type <> "404"', 'having' => 'HAVING COUNT(visit_id) = 1', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['slimview4'], ], 'slim_p4_24' => [ 'title' => __('Top Exit Pages', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'visit_id', 'outer_select_column' => 'resource', 'aggr_function' => 'MAX', 'raw' => ['wp_slimstat_db', 'get_top_aggr'], ], 'classes' => ['large'], 'locations' => ['slimview4', 'dashboard'], ], 'slim_p4_25' => [ 'title' => __('Top Entry Pages', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'visit_id', 'outer_select_column' => 'resource', 'aggr_function' => 'MIN', 'raw' => ['wp_slimstat_db', 'get_top_aggr'], ], // 'color' => '#EFF6FF', 'classes' => ['large'], 'locations' => ['slimview4'], ], 'slim_p4_26_01' => [ 'title' => __('Pages with Outbound Links', 'wp-slimstat'), 'callback' => [self::class, 'show_chart'], 'callback_args' => [ 'id' => 'slim_p4_26_01', 'chart_data' => [ 'data1' => 'COUNT( outbound_resource )', 'data2' => 'COUNT( DISTINCT outbound_resource )', ], 'chart_labels' => [ __('Outbound Links', 'wp-slimstat'), __('Unique Outbound', 'wp-slimstat'), ], ], 'classes' => ['extralarge', 'chart'], 'locations' => ['slimview4'], 'tooltip' => $pages_with_outbound_links_chart_tooltip, ], 'slim_p4_27' => [ 'title' => __('Users by Page', 'wp-slimstat'), 'callback' => [self::class, 'show_group_by'], 'callback_args' => [ 'column_group' => 'username', 'group_by' => 'resource', 'raw' => ['wp_slimstat_db', 'get_group_by'], ], 'classes' => ['large'], 'locations' => ['slimview4'], ], 'slim_p6_01' => [ 'title' => __('Audience Location', 'wp-slimstat'), 'callback' => [self::class, 'show_world_map'], 'callback_args' => [ 'id' => 'slim_p6_01', ], 'classes' => ['extralarge', 'map-wrap'], 'locations' => ['slimview1'], 'tooltip' => __('Dots on the map represent the most recent pageviews geolocated by City. This feature is only available by enabling the corresponding precision level in the settings.', 'wp-slimstat'), ], // Goals & Funnels reports 'slim_p9_01' => [ 'title' => __('Goals', 'wp-slimstat'), 'callback' => [self::class, 'show_goals'], 'callback_args' => [ 'type' => 'top', 'columns' => 'goal_name', 'raw' => ['wp_slimstat_db', 'get_goals_raw'], // The Free "Export" upgrade link only makes sense once there's // something to export — no goals defined → nothing to offer. 'exportable' => function () { return !empty(self::get_goals_card_state()['goals']); }, ], 'classes' => ['full-width', 'tall'], 'locations' => ['slimview6'], // Always render on the dedicated Goals & Funnels page, regardless // of any saved layout that moved a copy elsewhere. 'pinned' => true, 'tooltip' => __('Track conversions for custom goals you define. Goals are evaluated retroactively against existing data.', 'wp-slimstat'), ], 'slim_p9_02' => [ 'title' => __('Funnels', 'wp-slimstat'), 'callback' => [self::class, 'show_funnels'], 'callback_args' => [ 'type' => 'top', 'columns' => 'funnel_step', 'raw' => ['wp_slimstat_db', 'get_funnels_raw'], // Funnels are locked in Free (no data), so the Free "Export" // upgrade link is never appropriate here — it's bait. 'exportable' => function () { return !empty(self::get_funnels_card_state()['funnels']); }, ], 'classes' => ['full-width', 'extralarge'], 'locations' => ['slimview6'], // Always render on the dedicated Goals & Funnels page (see above). 'pinned' => true, 'tooltip' => __('Visualize conversion funnels with step-by-step drop-off analysis.', 'wp-slimstat'), ], ]; if ('on' != wp_slimstat::$settings['geolocation_country']) { self::$reports['slim_p2_23'] = [ 'title' => __('Top Cities', 'wp-slimstat'), 'callback' => [self::class, 'raw_results_to_html'], 'callback_args' => [ 'type' => 'top', 'columns' => 'city', 'raw' => ['wp_slimstat_db', 'get_top'], ], 'classes' => ['normal'], 'locations' => ['slimview3'], ]; } // Allow third party tools to manipulate this list here above: please use unique report IDs that don't interfere with built-in ones, if you add your own custom report self::$reports = apply_filters('slimstat_reports_info', self::$reports); $merge_reports = array_keys(self::$reports); // Do we have any new reports not listed in this user's settings? if (class_exists('wp_slimstat_admin') && !empty(wp_slimstat_admin::$meta_user_reports) && is_array(wp_slimstat_admin::$meta_user_reports)) { $flat_user_reports = array_filter(explode(',', implode(',', wp_slimstat_admin::$meta_user_reports))); $merge_reports = array_diff(array_filter(array_keys(self::$reports)), $flat_user_reports); // Now let's explode all the lists foreach (wp_slimstat_admin::$meta_user_reports as $a_location => $a_report_list) { if (!array_key_exists($a_location, self::$user_reports)) { continue; } self::$user_reports[$a_location] = explode(',', $a_report_list); } } // Pinned reports must always appear in their default location(s), even if // the user dragged a copy to another screen. The merge above only places // reports the user hasn't placed anywhere, so without this a report pinned // to a dedicated page (Goals/Funnels on slimview6) would silently vanish // from that page the moment it was added to, say, the dashboard — leaving // the dedicated page empty. See impeccable report "report-placement quirk". $pinned_reports = array_keys(array_filter(self::$reports, static function ($a_report) { return !empty($a_report['pinned']); })); if (!empty($pinned_reports)) { // Fold pinned reports back in, but keep registry order so they land in // their natural position (e.g. Goals before Funnels) rather than being // appended after the reports the user hasn't placed. $to_place = array_merge($merge_reports, $pinned_reports); $merge_reports = array_values(array_filter( array_keys(self::$reports), static function ($a_report_id) use ($to_place) { return in_array($a_report_id, $to_place, true); } )); } foreach ($merge_reports as $a_report_id) { if (!empty(self::$reports[$a_report_id]['locations']) && is_array(self::$reports[$a_report_id]['locations'])) { foreach (self::$reports[$a_report_id]['locations'] as $a_report_location) { if (!in_array($a_report_id, self::$user_reports[$a_report_location])) { self::$user_reports[$a_report_location][] = $a_report_id; } } } } // Fire action hook for third-party integrations do_action('wp_slimstat_reports_init'); // We store page titles in a transient for improved performance if (empty($_REQUEST['page']) || !in_array($_REQUEST['page'], ['slimlayout', 'slimadddons'])) { self::$resource_titles = get_transient('slimstat_resource_titles'); if (false === self::$resource_titles) { self::$resource_titles = []; } } return null; } // end init public static function report_header($_report_id = '') { if (empty(self::$reports[$_report_id])) { return false; } // Get postbox configuration $postbox_config = self::$reports[$_report_id]['postbox_config'] ?? []; $hide_header = $postbox_config['hide_header'] ?? false; $hide_padding = $postbox_config['hide_padding'] ?? false; $custom_height = $postbox_config['custom_height'] ?? null; $full_width = $postbox_config['full_width'] ?? false; $no_border = $postbox_config['no_border'] ?? false; $no_background = $postbox_config['no_background'] ?? false; $header_classes = empty(self::$reports[$_report_id]['classes']) ? '' : implode(' ', self::$reports[$_report_id]['classes']); $fixed_title = str_replace(['-', '_', '"', "'", ')', '('], '', strtolower(self::$reports[$_report_id]['title'])); $header_classes .= ' report-' . implode('-', explode(' ', esc_attr($fixed_title))); // Add postbox configuration classes if ($hide_header) { $header_classes .= ' slimstat-hide-header'; } if ($hide_padding) { $header_classes .= ' slimstat-hide-padding'; } if ($full_width) { $header_classes .= ' slimstat-full-width'; } if ($no_border) { $header_classes .= ' slimstat-no-border'; } if ($no_background) { $header_classes .= ' slimstat-no-background'; } $header_buttons = ''; $header_tooltip = ''; $widget_title = ''; // Don't show the header buttons on the frontend if (is_admin() && !$hide_header) { // Show the refresh button only if the time range is not in the past if (wp_slimstat_db::$filters_normalized['utime']['end'] >= date_i18n('U') - 300) { $header_buttons = ''; } $tooltip_base = ' '; // $tooltip_base = ''; $header_tooltip = $tooltip_base . (empty(self::$reports[$_report_id]['tooltip']) ? esc_html($_report_id) : self::$reports[$_report_id]['tooltip'] . '

' . esc_html($_report_id)) . ''; // Allow third-party code to add more buttons $header_buttons = apply_filters('slimstat_report_header_buttons', $header_buttons, $_report_id); $header_buttons = '
' . $header_buttons . '
'; $widget_title = '

' . esc_html(self::$reports[$_report_id]['title']) . $header_tooltip . '

'; // Allow third-party code to inject content directly under the

(e.g. a subtitle). $widget_title .= apply_filters('slimstat_report_header_after_title', '', $_report_id); } $bar_color = (empty(self::$reports[$_report_id]['color'])) ? '#EFF6FF' : self::$reports[$_report_id]['color']; // Build style attributes $style_attrs = "--box-bar-color: " . esc_attr($bar_color); if ($custom_height) { $style_attrs .= "; height: " . esc_attr($custom_height); } echo "
%s %s
", $header_buttons, $widget_title); return null; } public static function report_footer() { echo '
'; } private static function get_clamped_start($total_results, $results_per_page) { $results_per_page = max(1, intval($results_per_page)); $start = intval(wp_slimstat_db::$filters_normalized['misc']['start_from']); if ($total_results > 0 && $start >= $total_results) { $start = max(0, $total_results - $results_per_page); $start = intval(floor($start / $results_per_page) * $results_per_page); } return max(0, $start); } public static function report_pagination($_count_page_results = 0, $_count_all_results = 0, $_show_refresh_countdown = false, $_results_per_page = -1) { if (!is_admin()) { return ''; } $_results_per_page = ($_results_per_page < 0) ? wp_slimstat::$settings['rows_to_show'] : $_results_per_page; $effective_start = self::get_clamped_start($_count_all_results, $_results_per_page); $endpoint = min($_count_all_results, $effective_start + $_results_per_page); $pagination_buttons = ''; $direction_prev = is_rtl() ? 'right' : 'left'; $direction_next = is_rtl() ? 'left' : 'right'; if ($endpoint + $_results_per_page < $_count_all_results && $_count_page_results > 0) { $startpoint = $_count_all_results - $_count_all_results % $_results_per_page; if ($startpoint == $_count_all_results) { $startpoint -= $_results_per_page; } $pagination_buttons .= ' '; } if ($endpoint < $_count_all_results && $_count_page_results > 0) { $startpoint = $effective_start + $_results_per_page; $pagination_buttons .= ' '; } if ($effective_start > 0) { $startpoint = ($effective_start > $_results_per_page) ? $effective_start - $_results_per_page : 0; $pagination_buttons .= ' '; } if ($effective_start - $_results_per_page > 0) { $pagination_buttons .= ' '; } $pagination = '

' . sprintf(__('Showing %s - %s of %s', 'wp-slimstat'), number_format_i18n($effective_start + 1), number_format_i18n($endpoint), number_format_i18n($_count_all_results) . (($_count_all_results == wp_slimstat::$settings['limit_results']) ? '+' : '')); if ($_show_refresh_countdown && wp_slimstat::$settings['refresh_interval'] > 0 && wp_slimstat_db::$filters_normalized['utime']['end'] >= date_i18n('U') - 300) { $pagination .= ' [' . __('Refresh in', 'wp-slimstat') . ' ]'; } return $pagination . ($pagination_buttons . '

'); } /** * Returns the total result count for pagination display. * * For type=recent reports, get_recent() uses LIMIT+OFFSET so * count($all_results) shrinks on later pages. We use count_records() * for the true total, but cap it to limit_results because get_recent() * can only access that many rows via SQL. The existing "200+" suffix * in report_pagination() signals when more rows exist beyond the cap. * * For type=top reports, SQL fetches the full set (no OFFSET) and * count($all_results) is already stable. * * Reports may set 'total_callback' to a callable that returns the * true total for expanded result sets (e.g. get_recent_outbound * explodes ;;;-delimited rows). */ private static function get_report_total_count($_args, $all_results) { // Report-specific total override (e.g. expanded outbound links) if (!empty($_args['total_callback']) && is_callable($_args['total_callback'])) { $limit = intval(wp_slimstat::$settings['limit_results']); return min(call_user_func($_args['total_callback']), $limit); } if (!empty($_args['type']) && $_args['type'] === 'recent') { $use_date_filters = $_args['use_date_filters'] ?? true; $true_total = wp_slimstat_db::count_records( 'id', !empty($_args['where']) ? $_args['where'] : '', $use_date_filters, $_args['where_params'] ?? [] ); $limit = intval(wp_slimstat::$settings['limit_results']); return min($true_total, $limit); } return count($all_results); } public static function callback_wrapper() { // If this user is whitelisted, we use the minimum capability $minimum_capability = 'read'; if (false === strpos(wp_slimstat::$settings['can_view'], (string) $GLOBALS['current_user']->user_login) && !empty(wp_slimstat::$settings['capability_can_view'])) { $minimum_capability = wp_slimstat::$settings['capability_can_view']; } if (!current_user_can($minimum_capability)) { return; } $_args = self::_check_args(func_get_args()); if (!empty($_args) && !empty($_args['callback'])) { call_user_func($_args['callback'], $_args['callback_args']); } } public static function raw_results_to_html($_args = []) { if ('on' == wp_slimstat::$settings['async_load'] && (!defined('DOING_AJAX') || !DOING_AJAX) && empty($_args['is_widget'])) { return ''; } wp_slimstat_db::$debug_message = ''; $where_params = $_args['where_params'] ?? null; if (!empty($_args['raw']) && is_array($_args['raw']) && isset($_args['raw'][0]) && method_exists($_args['raw'][0], 'get_combined_where')) { $_args['where'] = call_user_func([$_args['raw'][0], 'get_combined_where'], $_args['where'], '', true, '', $where_params); } $all_results = call_user_func($_args['raw'], $_args); // Fix for Recent Outbound Links: wrap strings as arrays with the correct key if (!empty($_args['columns']) && 'outbound_resource' === $_args['columns'] && !empty($all_results) && is_array($all_results)) { foreach ($all_results as $k => $v) { if (!is_array($v)) { $all_results[$k] = ['outbound_resource' => $v]; } } } // Backward compatibility if (!is_array($all_results)) { $all_results = []; } echo wp_kses_post(wp_slimstat_db::$debug_message); // Some reports don't need any kind of pre/post-processing, we just display the data contained in the array if (empty($_args['columns'])) { foreach ($all_results as $a_result) { echo '

'; echo sprintf('%s %s', $a_result[ 'metric' ], $a_result[ 'value' ]); if (!empty($a_result['tooltip'])) { self::inline_help($a_result['tooltip']); } if (!empty($a_result['details'])) { echo sprintf("%s", $a_result[ 'details' ]); } echo '

'; } } else { // SQL-paginated reports (type=recent) already applied OFFSET in // the query — slice from 0. PHP-paginated reports (type=top) fetch // all rows up to limit_results — slice from start_from. $start_from = (!empty($_args['type']) && $_args['type'] === 'recent') ? 0 : self::get_clamped_start(count($all_results), wp_slimstat::$settings['rows_to_show']); $results = array_slice( $all_results, $start_from, wp_slimstat::$settings['rows_to_show'] ); // Count the results $count_page_results = count($results); if (0 == $count_page_results) { echo '

' . __('No data to display', 'wp-slimstat') . '

'; if (defined('DOING_AJAX') && DOING_AJAX) { die(); } else { return []; } } // Some reports use aliases for column names if (!empty($_args['as_column'])) { $_args['columns'] = $_args['as_column']; } elseif (!empty($_args['outer_select_column'])) { $_args['columns'] = $_args['outer_select_column']; } // Some reports query more than one column if (false !== strpos($_args['columns'], ',')) { $_args['columns'] = explode(',', $_args['columns']); $_args['columns'] = trim($_args['columns'][0]); } // Ensure columns is a string (for safety) if (is_array($_args['columns'])) { $_args['columns'] = trim($_args['columns'][0]); } $permalinks_enabled = get_option('permalink_structure'); for ($i = 0; $i < $count_page_results; $i++) { $row_details = ''; $percentage = ''; $element_pre_value = ''; // Ensure $results[$i] is an array and the key exists if (is_array($results[$i]) && isset($results[$i][$_args['columns']])) { $element_value = $results[$i][$_args['columns']]; } else { $element_value = ''; } // Some columns require a special pre-treatment switch ($_args['columns']) { case 'browser': if (!empty($results[$i]['user_agent']) && 'on' == wp_slimstat::$settings['show_complete_user_agent_tooltip']) { $element_pre_value = self::inline_help($results[$i]['user_agent'], false); } $browser = $results[$i]['browser'] ?? ''; if (realpath(SLIMSTAT_ANALYTICS_DIR . ('/admin/assets/images/browsers/' . strtolower($browser) . '.png'))) { $image_url = SLIMSTAT_ANALYTICS_URL . ('/admin/assets/images/browsers/' . strtolower($browser) . '.png'); } else { $image_url = SLIMSTAT_ANALYTICS_URL . ('/admin/assets/images/unk.png'); } $element_value = '' . $browser . ' '; $element_value .= $browser . ((isset($results[$i]['browser_version']) && 0 != intval($results[$i]['browser_version'])) ? ' ' . $results[$i]['browser_version'] : ''); break; case 'category': // Only show tag name for Top Tags, and only category name for Recent Categories $term_id = $results[$i][$_args['columns']]; $show_tag = false; if (!empty($_args['where']) && false !== strpos($_args['where'], 'tag')) { $show_tag = true; } if ($show_tag) { $term_obj = get_term($term_id, 'post_tag'); if ($term_obj && !is_wp_error($term_obj)) { $element_value = $term_obj->name; $row_details = __('Tag', 'wp-slimstat') . ': ' . $term_obj->name; } else { $element_value = esc_html($term_id); $row_details = __('ID', 'wp-slimstat') . ': ' . esc_html($term_id); } } else { $term_obj = get_term($term_id, 'category'); if ($term_obj && !is_wp_error($term_obj)) { $element_value = $term_obj->name; $row_details = __('Category', 'wp-slimstat') . ': ' . $term_obj->name; } else { $element_value = esc_html($term_id); $row_details = __('ID', 'wp-slimstat') . ': ' . esc_html($term_id); } } break; case 'country': $country = $results[$i]['country'] ?? ''; // Only a well-formed 2-char code becomes a flag lookup; anything // else (legacy/poisoned data) falls back to the unknown flag rather // than building a filesystem path + URL out of stored text. The // src is esc_url()'d as defense-in-depth. (CWE-79 / -22 hardening) $flag_rel = preg_match('/^[a-z0-9]{2}$/i', (string) $country) ? '/admin/assets/images/flags/' . strtolower($country) . '.svg' : ''; $image_url = ('' !== $flag_rel && is_readable(SLIMSTAT_ANALYTICS_DIR . $flag_rel)) ? SLIMSTAT_ANALYTICS_URL . $flag_rel : SLIMSTAT_ANALYTICS_URL . '/admin/assets/images/unk.png'; $element_value = '' . esc_attr($country) . ''; $row_details .= __('Code', 'wp-slimstat') . ': ' . esc_html($country); $element_value .= esc_html(wp_slimstat_i18n::get_string('c-' . $country)); break; case 'id': case 'ip': if ('on' == wp_slimstat::$settings['convert_ip_addresses']) { $element_value = wp_slimstat::gethostbyaddr($results[$i]['ip']); } else { $element_value = $results[$i]['ip']; } break; case 'language': // The language is the visitor-supplied Accept-Language value, so // validate the region subtag to 2 alphanumerics before it becomes a // flag path, esc_url() the src, and escape every echoed copy of the // raw value (alt / row code / name) — same hardening as 'country'. $lang_value = (string) ($results[$i][$_args['columns']] ?? ''); $language_parts = explode('-', $lang_value); $last_language_part = end($language_parts); $flag_rel = preg_match('/^[a-z0-9]{2}$/i', (string) $last_language_part) ? '/admin/assets/images/flags/' . $last_language_part . '.svg' : ''; if ('' !== $flag_rel && is_readable(SLIMSTAT_ANALYTICS_DIR . $flag_rel)) { $image_url = SLIMSTAT_ANALYTICS_URL . $flag_rel; $element_value = '' . esc_attr($last_language_part) . ''; } else { $image_url = SLIMSTAT_ANALYTICS_URL . '/admin/assets/images/unk.png'; $element_value = '' . esc_attr($lang_value) . ''; } $row_details = __('Code', 'wp-slimstat') . ': ' . esc_html($lang_value); $element_value .= esc_html(wp_slimstat_i18n::get_string('l-' . $lang_value)); break; case 'platform': $row_details = __('Code', 'wp-slimstat') . (': ' . $results[$i][$_args[ 'columns' ]]); $icons = [ 'android' => 'and', 'chromeos' => 'chr', 'ios' => 'ios', 'linux' => 'lin', 'ubuntu' => 'ubu', 'windows' => 'win', 'win7' => 'win', 'win8.1' => 'win', 'win10' => 'win', 'win11' => 'win', 'macos' => 'mac', 'macosx' => 'mac', ]; $platform_parts = explode('-', $results[$i][$_args['columns']] ?? ''); $last_platform_part = strtolower((string)end($platform_parts)); if (realpath(SLIMSTAT_ANALYTICS_DIR . ('/admin/assets/images/os/' . $last_platform_part . '.webp'))) { $image_url = SLIMSTAT_ANALYTICS_URL . ('/admin/assets/images/os/' . $last_platform_part . '.webp'); } elseif (isset($icons[$last_platform_part]) && realpath(SLIMSTAT_ANALYTICS_DIR . ('/admin/assets/images/os/' . $icons[$last_platform_part] . '.webp'))) { $image_url = SLIMSTAT_ANALYTICS_URL . ('/admin/assets/images/os/' . $icons[$last_platform_part] . '.webp'); } else { $image_url = SLIMSTAT_ANALYTICS_URL . ('/admin/assets/images/unk.png'); } $element_value = '' . strtolower($last_platform_part) . ' '; $element_value .= wp_slimstat_i18n::get_string($results[$i][$_args['columns']]); $results[$i][$_args['columns']] = str_replace('p-', '', $results[$i][$_args['columns']]); break; case 'referer': $element_value = str_replace(['<', '>'], ['<', '>'], urldecode($results[$i][$_args['columns']])); break; case 'outbound_resource': $element_value = esc_html($results[$i][$_args['columns']]); break; case 'resource': $resource_title = self::get_resource_title($results[$i][$_args['columns']]); if ($resource_title != $results[$i][$_args['columns']]) { $row_details = __('URL', 'wp-slimstat') . ': ' . htmlentities($results[$i][$_args['columns']], ENT_QUOTES, 'UTF-8'); } if (!empty($_args['where']) && false !== strpos($_args['where'], 'download')) { $clean_extension = pathinfo(strtolower(parse_url($results[$i][$_args['columns']] ?? '', PHP_URL_PATH)), PATHINFO_EXTENSION); if (in_array($clean_extension, ['jpg', 'gif', 'png', 'jpeg', 'bmp'])) { $row_details = '
'; } } $element_value = $resource_title; break; case 'screen_width': $element_value = sprintf('%s x %s', $results[ $i ][ $_args[ 'columns' ] ], $results[ $i ][ 'screen_height' ]); break; case 'searchterms': if ('recent' == $_args['type']) { if (isset($results[$i]['referer']) && $results[$i]['referer']) { $domain = parse_url($results[$i]['referer'], PHP_URL_HOST); } else { $domain = __('No referrer', 'wp-slimstat'); } $row_details = __('Referrer', 'wp-slimstat') . (': ' . $domain); $element_value = self::get_search_terms_info($results[$i]['searchterms'], $results[$i]['referer'] ?? '', true); } else { $element_value = htmlentities($results[$i]['searchterms'], ENT_QUOTES, 'UTF-8'); } break; case 'username': if (!empty($results[$i]['username'])) { $element_custom_value = get_user_by('login', $results[$i]['username']); if ($element_custom_value) { $element_value = ""; $element_value .= get_avatar($element_custom_value->ID, 18); $element_value .= esc_html($results[$i]['username']); $element_value .= ''; // #273: add a direct link to the admin user profile (the link // above goes to the public author archive). $element_value .= self::get_edit_profile_link($element_custom_value->ID); } else { $image_url = SLIMSTAT_ANALYTICS_URL . ('/admin/assets/images/unk.png'); $element_value = "Unknown%s (", esc_html($results[$i]['username'])) . __('Unknown', 'wp-slimstat') . ')'; } } else { $image_url = SLIMSTAT_ANALYTICS_URL . ('/admin/assets/images/unk.png'); $element_value = "Unknown" . __('Guest', 'wp-slimstat') . ''; } if ('on' == wp_slimstat::$settings['show_display_name']) { $element_custom_value = get_user_by('login', $results[$i]['username']); if (is_object($element_custom_value)) { $element_value = esc_html($element_custom_value->display_name); } } break; case 'author': // Backward compatibility $author_username = is_array($results[$i]) && isset($results[$i]['author']) ? $results[$i]['author'] : ''; if ($author_username) { $author = get_user_by('login', $author_username); if ($author) { $author_id = $author ? $author->ID : 0; $element_value = ""; $element_value .= get_avatar($author_id, 18); $element_value .= esc_html($author ? (empty($author->display_name) ? $author->user_login : $author->display_name) : $author_username); $element_value .= ''; // #273: additive admin-profile link, capability-guarded. $element_value .= self::get_edit_profile_link($author_id); } else { $image_url = SLIMSTAT_ANALYTICS_URL . ('/admin/assets/images/unk.png'); $element_value = "Unknown" . esc_html($author_username) . ' (' . __('Unknown', 'wp-slimstat') . ')'; } } else { $image_url = SLIMSTAT_ANALYTICS_URL . ('/admin/assets/images/unk.png'); $element_value = "Unknown" . __('Guest', 'wp-slimstat') . ''; } break; case 'visit_id': $resource_title = self::get_resource_title($results[$i]['resource']); if ($resource_title != $results[$i]['resource']) { $row_details = htmlentities($results[$i]['resource'], ENT_QUOTES, 'UTF-8'); } $element_value = $resource_title; break; default: $element_value = esc_html($element_value); } if (is_admin()) { $column_value = is_array($results[$i]) && isset($results[$i][$_args['columns']]) ? (string) $results[$i][$_args['columns']] : ''; $encoded_column_value = rawurlencode($column_value); $element_value = "%s", $element_value); } // Show last-seen timestamp when dt is available in the result // (both type=recent raw rows and type=top with more_select=MAX(dt) AS dt) if (is_array($results[$i]) && isset($results[$i]['dt']) && $results[$i]['dt'] > 0) { $row_details = date_i18n(get_option('date_format') . ' ' . get_option('time_format'), $results[$i]['dt'], true) . ('' === $row_details || '0' === $row_details ? '' : '
') . $row_details; } if (!empty($_args['type']) && 'top' == $_args['type']) { $percentage_value = ((wp_slimstat_db::$pageviews > 0) ? sprintf('%01.2f', (100 * $results[$i]['counthits'] / wp_slimstat_db::$pageviews)) : 0); $counthits = number_format_i18n($results[$i]['counthits']); $percentage_value = number_format_i18n((float)$percentage_value, 2); $percentage = ' ' . $counthits . '(' . $percentage_value . '%)'; } // Some columns require a special post-treatment if ('resource' == $_args['columns'] && !empty($_args['where']) && false === strpos($_args['where'], '404')) { $base_url = ''; if (isset($results[$i]['blog_id'])) { $base_url = parse_url(get_site_url($results[$i]['blog_id'])); $base_url = $base_url['scheme'] . '://' . $base_url['host']; } $element_value = ' ' . esc_html($base_url) . $element_value; } if ('referer' == $_args['columns'] && !empty($_args['type']) && 'top' == $_args['type']) { $element_url = $results[$i]['referer']; if (false === strpos($element_url, 'http')) { $element_url = 'https://' . $element_url; } $element_value = ' ' . $element_value; } if (is_admin() && !empty($results[$i]['ip']) && 'ip' != $_args['columns'] && 'on' != wp_slimstat::$settings['convert_ip_addresses']) { $row_details .= '
IP: ' . esc_html($results[$i]['ip']) . '' . (empty($results[$i]['other_ip']) ? '' : ' / ' . esc_html($results[$i]['other_ip'])) . ''; } if ('' !== $row_details && '0' !== $row_details) { $row_details = sprintf("%s", $row_details); } $bar = ''; if (!empty($percentage_value)) { $bar = ''; } $row_output = sprintf("

%s%s%s%s %s

", $bar, $element_pre_value, $element_value, $percentage, $row_details); // Strip all the filter links, if this information is shown on the frontend if (!is_admin()) { $row_output = preg_replace('/(.*?)<\/a>/', '\\2', $row_output); } echo $row_output; } if (!defined('DOING_AJAX') || !DOING_AJAX) { echo ''; } echo self::report_pagination($count_page_results, self::get_report_total_count($_args, $all_results)); if (!defined('DOING_AJAX') || !DOING_AJAX) { echo '
'; } } if (defined('DOING_AJAX') && DOING_AJAX) { die(); } return null; } public static function show_access_log($_args = []) { // This function is too long, so it was moved to a separate file include(__DIR__ . '/right-now.php'); if (defined('DOING_AJAX') && DOING_AJAX) { die(); } } public static function show_chart($args) { $chart = new \SlimStat\Modules\Chart(); $chart->showChart($args); if (defined('DOING_AJAX') && DOING_AJAX) { die(); } } public static function show_events($_args = []) { $all_results = call_user_func($_args['raw'], $_args); $start_from = (!empty($_args['type']) && $_args['type'] === 'recent') ? 0 : self::get_clamped_start(count($all_results), wp_slimstat::$settings['rows_to_show']); $results = array_slice( $all_results, $start_from, wp_slimstat::$settings['rows_to_show'] ); // Count the results $count_page_results = count($results); if (0 == $count_page_results) { echo '

' . __('No data to display', 'wp-slimstat') . '

'; if (defined('DOING_AJAX') && DOING_AJAX) { die(); } else { return []; } } $blog_url = ''; if (isset($results[0]['blog_id'])) { $blog_url = get_site_url($results[0]['blog_id']); } foreach ($results as $a_result) { // Parse JSON notes to show human-readable label: text > value > id > type > raw $label = $a_result['notes']; $note_data = json_decode($a_result['notes'], true); if (is_array($note_data)) { if (!empty($note_data['text'])) { $label = trim($note_data['text']); } elseif (!empty($note_data['value'])) { $label = $note_data['value']; } elseif (!empty($note_data['id'])) { $label = $note_data['id']; } elseif (!empty($note_data['type'])) { $label = ucfirst($note_data['type']); } } echo "

" . esc_html($label); if (!empty($a_result['counthits'])) { echo sprintf('%s', esc_html($a_result['counthits'])); } $has_tooltip = false; if (!empty($a_result['dt'])) { $date_time = date_i18n(get_option('date_format') . ' ' . get_option('time_format'), $a_result['dt'], true); echo '' . __('IP', 'wp-slimstat') . ': ' . esc_html($a_result['ip']) . '
' . __('Page', 'wp-slimstat') . sprintf(": %s
", esc_url($blog_url . $a_result['resource']), esc_html($blog_url . $a_result['resource'])) . __('Coordinates', 'wp-slimstat') . sprintf(': %s
', esc_html($a_result['position'])) . __('Date', 'wp-slimstat') . (': ' . $date_time); $has_tooltip = true; } elseif (is_array($note_data)) { // For "top" mode (no dt), show full JSON breakdown in tooltip $tooltip_parts = []; foreach ($note_data as $key => $val) { if (!empty($val)) { $tooltip_parts[] = esc_html(ucfirst($key)) . ': ' . esc_html($val); } } if (!empty($tooltip_parts)) { echo '' . implode('
', $tooltip_parts); $has_tooltip = true; } } if ($has_tooltip) { echo ''; } echo '

'; } if (! defined('DOING_AJAX') || ! DOING_AJAX) { echo '
'; } echo self::report_pagination($count_page_results, self::get_report_total_count($_args, $all_results)); if (! defined('DOING_AJAX') || ! DOING_AJAX) { echo '
'; } if (defined('DOING_AJAX') && DOING_AJAX) { die(); } return null; } /** * Shared state for the Goals card — consumed by both the goals-card partial * and the postbox-header filter callbacks so both surfaces show the same * usage counts / CTA state without recomputing. * * Memoised per request. On Free, this performs a one-shot lazy persist: if * more goals are active than the tier allows (e.g. after a Pro→Free * downgrade), it pauses the excess and writes slimstat_goals once. Not a pure * accessor for that reason; idempotent after the first normalizing render. * * @return array{goals:array, active_count:int, max_goals:int, is_pro:bool, at_max:bool, show_add_cta:bool, show_upsell:bool} */ public static function get_goals_card_state(): array { static $cached = null; if (null !== $cached) { return $cached; } $goals = get_option('slimstat_goals', []); $max_goals = (int) apply_filters('slimstat_max_goals', 1); // Derive Pro from the capability the feature actually depends on — the // raised goal limit — rather than pro_is_installed(). This matches the // funnels card's ($max_funnels > 0) signal, so both cards stay consistent // even if Pro is active but GoalsFunnelAddon didn't boot (older Pro build, // a dropped $provides entry, a partial container failure). $is_pro = $max_goals > 1; // Free allows only $max_goals active goals. If more are active (e.g. a // Pro→Free downgrade left several active), auto-pause all but the newest // and persist, so the "one active goal" contract holds in storage. Paused // goals stay listed (shown without their numbers) and reactivate on // upgrade. Idempotent — writes only when it actually pauses something. (#11) if (!$is_pro) { $normalized = self::pause_excess_free_goals($goals, $max_goals); if ($normalized !== $goals) { update_option('slimstat_goals', $normalized); $goals = $normalized; } } // The "N of M used" pill counts ACTIVE goals only, so it stays accurate. // Both tiers now show ALL goals: paused ones stay visible with their badge // and a "Paused — not being measured" placeholder instead of numbers // (goals-card.php). (#11) $active_count = count(array_filter($goals, function ($g) { return !empty($g['active']); })); $at_max = $active_count >= $max_goals; $visible_goals = $goals; $cached = [ 'goals' => $visible_goals, 'active_count' => $active_count, 'max_goals' => $max_goals, 'is_pro' => $is_pro, 'at_max' => $at_max, // Header "+ Add Goal" shows only once at least one goal exists; the // empty state owns the single primary CTA ("+ Add your first goal"), // so the two never compete (FN-3). 'show_add_cta' => !$at_max && !empty($goals), 'show_upsell' => $at_max && !$is_pro, ]; return $cached; } /** * Enforce the Free-tier active-goal limit by pausing the oldest excess goals. * * Keeps the newest $max_goals active goals (highest id = most recently * created) active and flips the rest to active=false. Pure (no I/O) so the * caller decides when to persist; returns the goals unchanged when already * within the limit. A goal with no id sorts oldest (legacy records). * * @param array $goals The stored goals list. * @param int $max_goals Maximum number of active goals allowed. * @return array The goals with any excess active goals paused. */ public static function pause_excess_free_goals(array $goals, int $max_goals): array { $limit = max(0, $max_goals); $active = []; foreach ($goals as $i => $g) { if (!empty($g['active'])) { $active[$i] = isset($g['id']) ? (int) $g['id'] : 0; } } if (count($active) <= $limit) { return $goals; } arsort($active); // newest (highest id) first $keep = array_slice(array_keys($active), 0, $limit); foreach (array_keys($active) as $i) { if (!in_array($i, $keep, true)) { $goals[$i]['active'] = false; } } return $goals; } /** * Shared state for the Funnels card — see get_goals_card_state() for the * shared-with-postbox-header rationale. * * @return array{funnels:array, funnel_count:int, max_funnels:int, is_pro:bool, locked:bool, at_max:bool, show_add_cta:bool} */ public static function get_funnels_card_state(): array { static $cached = null; if (null !== $cached) { return $cached; } $max_funnels = (int) apply_filters('slimstat_max_funnels', 0); $is_pro = $max_funnels > 0; $funnels = $is_pro ? get_option('slimstat_funnels', []) : []; $funnel_count = is_array($funnels) ? count($funnels) : 0; $locked = !$is_pro; $at_max = $funnel_count >= $max_funnels; $cached = [ 'funnels' => $funnels, 'funnel_count' => $funnel_count, 'max_funnels' => $max_funnels, 'is_pro' => $is_pro, 'locked' => $locked, 'at_max' => $at_max, // Header "+ Add Funnel" shows only once at least one funnel exists; the // empty state's template picker (incl. "Blank funnel") owns the create // action, so the header CTA doesn't duplicate it (FN-3). 'show_add_cta' => !$locked && !$at_max && $funnel_count > 0, ]; return $cached; } /** * Builds the "N of M used" usage pill plus an optional "+ Add" primary * button. Shared between the Goals and Funnels postbox-header injections. */ private static function render_pill_and_cta(int $used, int $max, string $cta_action, string $cta_label, bool $show_cta, string $secondary_html = ''): string { $html = ''; $html .= esc_html(sprintf( /* translators: 1: used count, 2: maximum count */ __('%1$d of %2$d used', 'wp-slimstat'), $used, $max )); $html .= ''; // Optional secondary action between the usage pill and the primary CTA // (Funnels uses it for the "See templates" toggle beside "+ Add funnel"). $html .= $secondary_html; if ($show_cta) { $html .= ''; } return $html; } /** * Goals usage pill + "+ Add Goal" CTA for the postbox-header injection. */ public static function render_goals_card_actions(): string { $state = self::get_goals_card_state(); return self::render_pill_and_cta( $state['active_count'], $state['max_goals'], 'open-goal-drawer', __('+ Add goal', 'wp-slimstat'), $state['show_add_cta'] ); } /** * Funnels usage pill + "+ Add Funnel" CTA for the postbox-header injection. * Empty for the Free / locked branch (no actions on locked). */ public static function render_funnels_card_actions(): string { $state = self::get_funnels_card_state(); if ($state['locked']) { return ''; } // "See templates" reveals the in-card template picker (#7). Shown under the // same condition as the "+ Add funnel" CTA (at least one funnel exists and // we're below the limit) and placed right beside it via the secondary slot. // The panel it toggles lives in funnels-card.php, wired by aria-controls. $see_templates = ''; if ($state['show_add_cta']) { $see_templates = ''; } return self::render_pill_and_cta( $state['funnel_count'], $state['max_funnels'], 'open-funnel-builder', __('+ Add funnel', 'wp-slimstat'), $state['show_add_cta'], $see_templates ); } /** * Renders the Goals report. * * - When $_args['is_widget'] is true (shortcode, dashboard widget, email * report, CSV fallback), renders the legacy compact table untouched so * downstream surfaces keep working. * - Otherwise renders the modern admin card via the goals-card partial. */ public static function show_goals($_args = []) { $is_widget = !empty($_args['is_widget']); if ($is_widget) { $goals = get_option('slimstat_goals', []); self::show_goals_compact($goals); if (wp_doing_ajax()) { die(); } return; } // Pull shared state (also consumed by the postbox-header filter callbacks). $state = self::get_goals_card_state(); $goals = $state['goals']; $max_goals = $state['max_goals']; $active_count = $state['active_count']; $is_pro = $state['is_pro']; $dimensions = wp_slimstat_admin::get_goal_dimensions(); $operators = wp_slimstat_admin::get_goal_operators(); $operator_labels = wp_slimstat_admin::get_goal_operator_labels(); $consent_notice = function_exists('wp_has_consent') ? __('Goal data reflects visitors who provided statistics consent.', 'wp-slimstat') : ''; include __DIR__ . '/partials/goals-funnels/goals-card.php'; if (wp_doing_ajax()) { die(); } } /** * Legacy compact Goals rendering — preserved for shortcode / widget / email report / CSV. * Do not modify without auditing all four consumer paths. */ private static function show_goals_compact(array $goals): void { if (empty($goals)) { echo '

' . esc_html__('No goals defined yet.', 'wp-slimstat') . '

'; } else { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; foreach ($goals as $goal) { if (empty($goal['active'])) { continue; } $data = wp_slimstat_db::get_goal_results($goal); echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } echo '
' . esc_html__('Goal', 'wp-slimstat') . '' . esc_html__('Uniques', 'wp-slimstat') . '' . esc_html__('Total', 'wp-slimstat') . '' . esc_html__('CR%', 'wp-slimstat') . '
' . esc_html($goal['name']) . '' . esc_html(number_format_i18n($data['uniques'])) . '' . esc_html(number_format_i18n($data['total'])) . '' . esc_html($data['cr']) . '%
'; } if (function_exists('wp_has_consent')) { echo '

' . esc_html__('Goal data reflects visitors who provided statistics consent.', 'wp-slimstat') . '

'; } } /** * Renders the Funnels report. * * Same branching contract as show_goals(): widget mode (shortcode / dashboard * widget / email / CSV fallback) keeps the legacy compact markup; admin mode * renders the modern funnels card via the funnels-card partial. */ public static function show_funnels($_args = []) { $is_widget = !empty($_args['is_widget']); if ($is_widget) { $max_funnels = (int) apply_filters('slimstat_max_funnels', 0); $is_pro = $max_funnels > 0; $funnels = $is_pro ? get_option('slimstat_funnels', []) : []; self::show_funnels_compact($is_pro, $funnels); if (wp_doing_ajax()) { die(); } return; } // Pull shared state (also consumed by the postbox-header filter callbacks). $state = self::get_funnels_card_state(); $funnels = $state['funnels']; $max_funnels = $state['max_funnels']; $is_pro = $state['is_pro']; // Compute the SSR funnel data (first funnel only — others lazy-load via AJAX). $active_funnel_steps = []; $active_funnel_summary = ['step_count' => 0, 'total_cr' => null, 'unreachable_count' => 0]; if (!empty($funnels)) { $active_funnel_steps = wp_slimstat_db::get_funnel_results($funnels[0]); $step_one_visitors = (int) ($active_funnel_steps[0]['visitors'] ?? 0); $total_cr = null; if ($step_one_visitors > 0) { $total_cr = (count($active_funnel_steps) > 1) ? $active_funnel_steps[count($active_funnel_steps) - 1]['pct'] : 100; } $unreachable_count = 0; foreach ($active_funnel_steps as $step) { if (!empty($step['unreachable'])) { $unreachable_count++; } } $active_funnel_summary = [ 'step_count' => count($active_funnel_steps), 'total_cr' => $total_cr, 'unreachable_count' => $unreachable_count, ]; } // Pin the exact window this SSR render resolved so the AJAX funnel/Test reuse // the SAME [start,end] (and cache key) verbatim, instead of re-resolving the // preset through DateRangeHelper in the site timezone while this path used the // legacy UTC day boundaries. Without this, an active funnel and its AJAX-loaded // twin land on different windows/keys and disagree by the tz offset. (#1) $gf_range_start = (int) (wp_slimstat_db::$filters_normalized['utime']['start'] ?? 0); $gf_range_end = (int) (wp_slimstat_db::$filters_normalized['utime']['end'] ?? 0); include __DIR__ . '/partials/goals-funnels/funnels-card.php'; if (wp_doing_ajax()) { die(); } } /** * Legacy compact Funnels rendering — preserved for shortcode / widget / email report / CSV. * Do not modify without auditing all four consumer paths. */ private static function show_funnels_compact(bool $is_pro, array $funnels): void { if (!$is_pro) { echo '
'; echo '
'; $mock_heights = [200, 140, 80]; $mock_labels = [__('Step 1', 'wp-slimstat'), __('Step 2', 'wp-slimstat'), __('Step 3', 'wp-slimstat')]; foreach ($mock_heights as $i => $h) { echo '
'; echo '
'; echo '
' . esc_html($mock_labels[$i]) . '
'; echo '
'; } echo '
'; echo '
'; echo '

' . esc_html__('Visualize every step of the journey', 'wp-slimstat') . '

'; echo '

' . esc_html__('Visualize conversion funnels with step-by-step drop-off analysis.', 'wp-slimstat') . '

'; echo '' . esc_html__('Upgrade to Pro', 'wp-slimstat') . ''; echo '
'; return; } if (empty($funnels)) { echo '

' . esc_html__('No funnels configured.', 'wp-slimstat') . '

'; return; } // Render every funnel. With more than one we emit a tab strip; the admin // JS (goals-funnels.js) hides the inactive panels and switches on click. // The tab class is intentionally distinct from the main page's // .slimstat-gf-tab so the two delegated handlers never collide. Panels // stay visible server-side, so no-JS consumers (email report / CSV) still // see every funnel stacked instead of just the first. $multi = count($funnels) > 1; // Unique id base per widget render so the tab/panel ARIA ids don't collide // when more than one compact widget renders on a page (e.g. two shortcodes). static $widget_seq = 0; $uid = ++$widget_seq; echo '
'; if ($multi) { echo '
'; foreach ($funnels as $idx => $f) { $active = (0 === $idx); $tabId = 'slimstat-funnel-wtab-' . $uid . '-' . (int) $idx; $panelId = 'slimstat-funnel-wpanel-' . $uid . '-' . (int) $idx; echo ''; } echo '
'; } foreach ($funnels as $idx => $funnel) { $step_results = wp_slimstat_db::get_funnel_results($funnel); $step1 = (int) ($step_results[0]['visitors'] ?? 0); // A multi-funnel widget is a real tab interface; pair each panel with // its tab. A lone panel gets no tab roles (there is no tab to pair). $panel_attrs = ''; if ($multi) { $panelId = 'slimstat-funnel-wpanel-' . $uid . '-' . (int) $idx; $tabId = 'slimstat-funnel-wtab-' . $uid . '-' . (int) $idx; $panel_attrs = ' role="tabpanel" id="' . esc_attr($panelId) . '" aria-labelledby="' . esc_attr($tabId) . '"'; } echo '
'; echo '

' . esc_html($funnel['name']) . '

'; if ($step1 === 0) { echo '

' . esc_html__('No matching visitors in this date range.', 'wp-slimstat') . '

'; } elseif (!empty($step_results)) { $step_count = count($step_results); $total_cr = ($step_count > 1) ? $step_results[$step_count - 1]['pct'] : 100; echo '

'; echo esc_html(sprintf( /* translators: 1: step count, 2: conversion rate */ __('%1$d-step funnel · %2$s%% conversion rate', 'wp-slimstat'), $step_count, $total_cr )); echo '

'; echo '
'; foreach ($step_results as $step) { $width = $step1 > 0 ? (int) round(($step['visitors'] / $step1) * 100) : 0; // A zero-visitor or unreachable step keeps the muted fill (no // brand color), so an empty bar never reads as a healthy step. $zero = empty($step['visitors']) || !empty($step['unreachable']); echo '
'; echo '
'; echo '' . esc_html($step['name']) . ''; echo '' . esc_html(number_format_i18n($step['visitors'])) . ' (' . esc_html((string) $step['pct']) . '%)'; echo '
'; echo '
'; echo '
'; echo '
'; } echo '
'; } echo '
'; } echo '
'; } public static function show_group_by($_args = []) { $all_results = call_user_func($_args['raw'], $_args); $results = []; if (is_array($all_results) && count($all_results)) { $start_from = (!empty($_args['type']) && $_args['type'] === 'recent') ? 0 : self::get_clamped_start(count($all_results), wp_slimstat::$settings['rows_to_show']); $results = array_slice( $all_results, $start_from, wp_slimstat::$settings['rows_to_show'] ); } // Count the results $count_page_results = count($results); if (0 == $count_page_results) { echo '

' . __('No data to display', 'wp-slimstat') . '

'; if (defined('DOING_AJAX') && DOING_AJAX) { die(); } else { return 0; } } echo wp_kses_post(wp_slimstat_db::$debug_message); foreach ($results as $a_result) { if (empty($a_result['counthits'])) { $a_result['counthits'] = 0; } $a_result['resource'] = " " . self::get_resource_title($a_result['resource']) . ''; $group_markup = []; if (!empty($a_result['column_group'])) { $exploded_group = explode(';;;', $a_result['column_group']); $group_markup = []; foreach ($exploded_group as $a_item) { $user = get_user_by('login', $a_item); if ($user) { $group_markup[] = '' . get_avatar($user->ID, 16) . esc_html( $user->display_name ) . ''; } else { $group_markup[] = '' . esc_html( $a_item ) . ''; } } } echo sprintf('

%s %s
', wp_kses_post( $a_result[ 'resource' ] ), esc_html( $a_result[ 'counthits' ] )) . wp_kses_post( implode(', ', $group_markup) ) . '

'; } if (! defined('DOING_AJAX') || ! DOING_AJAX) { echo '
'; } echo self::report_pagination($count_page_results, self::get_report_total_count($_args, $all_results)); if (! defined('DOING_AJAX') || ! DOING_AJAX) { echo '
'; } if (defined('DOING_AJAX') && DOING_AJAX) { die(); } return null; } public static function show_rankings() { // Remove Alexa ranking code and references $options = ['timeout' => 30, 'headers' => ['Accept' => 'application/json']]; $site_url = parse_url(home_url(), PHP_URL_HOST); if (!empty(wp_slimstat_db::$filters_normalized['resource']) && 'equals' == wp_slimstat_db::$filters_normalized['resource'][0]) { $site_url .= wp_slimstat_db::$filters_normalized['resource'][1]; } $site_url = urlencode($site_url); // Check if we have a valid transient if (false === ($rankings = get_transient('slimstat_ranking_values'))) { $rankings = [ 'seomoz_domain_authority' => [ 0, __('Moz Domain Authority', 'wp-slimstat'), __('A normalized 100-point score representing the likelihood of a domain to rank well in search engine results.', 'wp-slimstat'), ], 'seomoz_equity_backlinks' => [ 0, __('Moz Backlinks', 'wp-slimstat'), __('Number of external equity links to your website.', 'wp-slimstat'), ], 'seomoz_links' => [ 0, __('Moz Links', 'wp-slimstat'), __('The number of links (external, equity or nonequity or not) to your homepage.', 'wp-slimstat'), ], ]; if (!empty(wp_slimstat::$settings['mozcom_access_id']) && !empty(wp_slimstat::$settings['mozcom_secret_key'])) { $expiration_token = time() + 300; $binary_signature = @hash_hmac('sha1', wp_slimstat::$settings['mozcom_access_id'] . "\n" . $expiration_token, wp_slimstat::$settings['mozcom_secret_key'], true); $binary_signature = urlencode(base64_encode($binary_signature)); // SeoMoz Equity Links (Backlinks) and MozRank $response = @wp_remote_get('https://lsapi.seomoz.com/linkscape/url-metrics/' . $site_url . '?Cols=68719478816&AccessID=' . wp_slimstat::$settings['mozcom_access_id'] . '&Expires=' . $expiration_token . '&Signature=' . $binary_signature, $options); if (!is_wp_error($response) && isset($response['response']['code']) && (200 == $response['response']['code']) && !empty($response['body'])) { $response = @json_decode($response['body']); if (is_object($response)) { if (!empty($response->pda)) { $rankings['seomoz_domain_authority'][0] = number_format_i18n(intval($response->pda)); } if (!empty($response->ueid)) { $rankings['seomoz_equity_backlinks'][0] = number_format_i18n(intval($response->ueid)); } if (!empty($response->uid)) { $rankings['seomoz_links'][0] = number_format_i18n(floatval($response->uid)); } } } } } foreach ($rankings as $a_ranking) { echo '

' . self::inline_help($a_ranking[2], false) . $a_ranking[1] . '' . $a_ranking[0] . '

'; } if (defined('DOING_AJAX') && DOING_AJAX) { die(); } } public static function show_world_map() { $countries = wp_slimstat_db::get_top('country') ?: []; $recent_visits = wp_slimstat_db::get_recent('location', '', '', true, '', 'city'); $data_points = []; if (!empty($recent_visits)) { $recent_visits = array_slice($recent_visits, 0, wp_slimstat::$settings['max_dots_on_map']); foreach ($recent_visits as $a_recent_visit) { if (!empty($a_recent_visit['city']) && !empty($a_recent_visit['location'])) { [$latitude, $longitude] = explode(',', $a_recent_visit['location']); $clean_city_name = htmlentities($a_recent_visit['city'], ENT_QUOTES, 'UTF-8'); $date_time = date_i18n(get_option('date_format') . ' ' . get_option('time_format'), $a_recent_visit['dt'], true); $data_points[] = sprintf("{zoomLevel:7,type:'circle',title:'%s
%s',latitude:%s,longitude:%s}", $clean_city_name, $date_time, $latitude, $longitude); } } } $data_areas = []; $country_stats = []; $max = 0; foreach ($countries as $a_country) { $code = strtolower((string)($a_country['country'] ?? '')); $visits = (int) $a_country['counthits']; $percent = (wp_slimstat_db::$pageviews > 0) ? round((100 * $visits / wp_slimstat_db::$pageviews), 2) : 0; $country_name = wp_slimstat_i18n::get_string('c-' . ($a_country['country'] ?? ''), 'wp-slimstat'); $data_areas[$code] = $visits; $country_stats[] = [ 'code' => $code, 'name' => $country_name, 'visits' => $visits, 'percent' => $percent, ]; if ($percent > $max) { $max = $percent; } } usort($country_stats, fn ($a, $b) => $b['visits'] <=> $a['visits']); $top_countries = array_slice($country_stats, 0, 5); $path_slimstat = dirname(__FILE__, 2); wp_enqueue_script('slimstat_jqvmap', plugins_url('/admin/assets/js/jqvmap/jquery.vmap.min.js', $path_slimstat), ['jquery'], '1.5.1', true); wp_enqueue_script('slimstat_jqvmap_world', plugins_url('/admin/assets/js/jqvmap/jquery.vmap.world.min.js', $path_slimstat), ['jquery'], '1.5.1', true); ?>

getProvider()->getDbPath()); } catch (\Throwable $e) { $db_missing = true; } } if ($uses_db && $db_missing) { echo sprintf(__("GeoIP collection is not enabled. Please go to setting page to enable GeoIP for getting more information and location (country) from the visitor.", 'wp-slimstat'), $settings_url . '2#wp-slimstat-third-party-libraries'); echo '
'; } ?>
'; ?>
%
"; } public static function get_search_terms_info($_searchterms = '', $_referer = '', $_serp_only = false) { $query_details = ''; $search_terms_info = ''; if (!$_referer) { $_referer = ''; } parse_str($_referer, $query_parse_str); if (isset($query_parse_str['source']) && ([] !== $query_parse_str['source'] && ('' !== $query_parse_str['source'] && '0' !== $query_parse_str['source'])) && !$_serp_only) { $query_details = __('src', 'wp-slimstat') . (': ' . esc_html($query_parse_str[ 'source' ])); } if (isset($query_parse_str['cd']) && ('' !== $query_parse_str['cd'] && '0' !== $query_parse_str['cd'] && [] !== $query_parse_str['cd'])) { $query_details = __('serp', 'wp-slimstat') . (': ' . esc_html($query_parse_str[ 'cd' ])); } if ('' !== $query_details && '0' !== $query_details) { $query_details = sprintf('(%s)', $query_details); } if (!empty($_searchterms) && '_' != $_searchterms) { $search_terms_info = htmlentities($_searchterms, ENT_QUOTES, 'UTF-8') . ' ' . $query_details; } return $search_terms_info; } /** * Generate the HTML that lists all the filters currently used */ public static function get_filters_html($_filters_array = []) { $filters_html = ''; if (!empty($_filters_array)) { foreach ($_filters_array as $a_filter_label => $a_filter_details) { if (!array_key_exists($a_filter_label, wp_slimstat_db::$columns_names) || false !== strpos($a_filter_label, 'no_filter')) { continue; } $a_filter_value_no_slashes = in_array($a_filter_details[0], wp_slimstat_db::$valueless_operators, true) ? '' : htmlentities(str_replace('\\', '', $a_filter_details[1]), ENT_QUOTES, 'UTF-8'); $filters_html .= '
  • ' . strtolower(wp_slimstat_db::$columns_names[$a_filter_label][0]) . ' ' . __(str_replace('_', ' ', $a_filter_details[0]), 'wp-slimstat') . sprintf(" %s
    • "; } } if ('' !== $filters_html && '0' !== $filters_html) { $filters_html = sprintf("
      %s
    " . __('Save', 'wp-slimstat') . ''; } if ('' !== $filters_html && '0' !== $filters_html) { $filters_html .= '' . __('Reset All', 'wp-slimstat') . ''; } return $filters_html; } public static function fs_url($_filters_string = '') { // Allow only legitimate requests if (!is_admin()) { return ''; } $request_uri = admin_url('admin.php'); $request_uri .= '?page=' . wp_slimstat_admin::$current_screen; // Avoid XSS attacks ( why would the owner try to hack into his/her own website though? ) if (!empty($_SERVER['HTTP_REFERER'])) { $parsed_referer = parse_url(sanitize_url(wp_unslash($_SERVER['HTTP_REFERER'])) ?: ''); if (!$parsed_referer || (isset($parsed_referer['scheme']) && ('' !== $parsed_referer['scheme'] && '0' !== $parsed_referer['scheme']) && !in_array(strtolower($parsed_referer['scheme']), ['http', 'https']))) { return ''; } } $fn = wp_slimstat_db::parse_filters($_filters_string); // Detect filters being removed (passed with operator but no value) $filters_to_remove = []; if (!empty($_filters_string)) { $matches = explode('&&&', $_filters_string); foreach ($matches as $a_match) { // Keep this regex aligned with wp_slimstat_db::parse_filters() (#305). preg_match('/([^\s]+)\s([^\s]+)(?:\s(.+))?/', urldecode($a_match), $a_filter); // "operator present, value absent" is a removal signal — EXCEPT for // value-less operators (is_empty/is_not_empty), which are real filters. See #305. if (!empty($a_filter[1]) && (!isset($a_filter[3]) || trim($a_filter[3]) === '') && !in_array($a_filter[2] ?? '', wp_slimstat_db::$valueless_operators, true)) { $filters_to_remove[$a_filter[1]] = $a_filter[2]; } } } // Columns if (!empty($fn['columns'])) { foreach ($fn['columns'] as $a_key => $a_filter) { $request_uri .= sprintf('&fs%%5B%s%%5D=', $a_key) . urlencode($a_filter[0] . ' ' . str_replace('=', '%3D', $a_filter[1])); } } // Include filters being removed with operator only (no value) so JS can detect and remove them foreach ($filters_to_remove as $a_key => $operator) { $request_uri .= sprintf('&fs%%5B%s%%5D=', $a_key) . urlencode($operator); } // Date ranges if (!empty($fn['date'])) { foreach ($fn['date'] as $a_key => $a_filter) { if (isset($a_filter)) { $request_uri .= sprintf('&fs%%5B%s%%5D=', $a_key) . urlencode('equals ' . $a_filter); } } } // Misc filters if (!empty($fn['misc'])) { foreach ($fn['misc'] as $a_key => $a_filter) { $request_uri .= sprintf('&fs%%5B%s%%5D=', $a_key) . urlencode('equals ' . $a_filter); } } return esc_url($request_uri); } /** * Attempts to convert a permalink into a post title */ public static function get_resource_title($_resource = '') { // Ensure $_resource is never null to avoid PHP 8.1+ deprecation warnings $_resource = $_resource ?? ''; if ('on' != wp_slimstat::$settings['convert_resource_urls_to_titles']) { return htmlentities(urldecode($_resource), ENT_QUOTES, 'UTF-8'); } // Do we already have this value in our transient cache? $cache_index = md5((string)$_resource); if (!isset(self::$resource_titles) || !is_array(self::$resource_titles)) { $transient = get_transient('slimstat_resource_titles'); self::$resource_titles = is_array($transient) ? $transient : []; } if (!empty(self::$resource_titles[$cache_index])) { return self::$resource_titles[$cache_index]; } self::$resource_titles[$cache_index] = $_resource; // Is this a post or a page? $post_id = url_to_postid($_resource); if ($post_id > 0) { self::$resource_titles[$cache_index] = the_title_attribute(['post' => $post_id, 'echo' => false]); // Encode URLs to avoid XSS attacks if (self::$resource_titles[$cache_index] == $_resource) { self::$resource_titles[$cache_index] = esc_html(self::$resource_titles[$cache_index]); } } // Is this a category or tag permalink? else { $term_names = []; $home_url = get_home_url(); $relative_home = parse_url($home_url, PHP_URL_PATH); // PHP ^v8 compatibility if (!$relative_home) { $relative_home = ''; } $all_terms = get_terms('category'); foreach ($all_terms as $a_term) { $term_link = get_term_link($a_term, 'category'); if (!is_wp_error($term_link) && str_replace($home_url, $relative_home, $term_link) == $_resource) { $term_names[] = $a_term->name; } } $all_terms = get_terms('tag'); foreach ($all_terms as $a_term) { $term_link = get_term_link($a_term, 'tag'); if (!is_wp_error($term_link) && str_replace($home_url, $relative_home, $term_link) == $_resource) { $term_names[] = $a_term->name; } } if ([] !== $term_names) { self::$resource_titles[$cache_index] = esc_html( implode(',', $term_names) ); } else { self::$resource_titles[$cache_index] = esc_html(self::$resource_titles[$cache_index]); } } // Save new value in cache only if changed set_transient('slimstat_resource_titles', self::$resource_titles, 1800); return self::$resource_titles[$cache_index]; } public static function inline_help($_text = '', $_echo = true) { if (is_admin() && !empty($_text)) { // CVE-2026-7634: defang attacker-controlled $_text. wp_kses_post preserves // the formatting tags existing tooltips rely on. $wrapped_text = sprintf("%s", wp_kses_post($_text)); } else { $wrapped_text = ''; } if ($_echo) { echo $wrapped_text; } else { return $wrapped_text; } return null; } protected static function _check_args($_args = []) { // When called from the WP Dashboard, the action passes 2 arguments: post_id (empty) and array of arguments $_args = empty($_args[1]) ? $_args[0] : $_args[1]; if (!is_array($_args)) { $_args = []; } $report_id = 0; // Is this an Ajax request? if (!empty($_POST['report_id'])) { check_ajax_referer('meta-box-order', 'security'); // Let's make sure the request is coming from an authorized source $report_id = sanitize_key(wp_unslash($_POST['report_id'])); } elseif (!empty($_args['id'])) { $report_id = $_args['id']; } if (!empty(self::$reports[$report_id]) && is_array(self::$reports[$report_id])) { // Default values $_args = array_merge([ 'title' => '', 'callback' => '', 'callback_args' => [], 'classes' => [], 'locations' => [], 'tooltip' => '', ], self::$reports[$report_id]); } // Default callback args if (!empty($_args['callback_args'])) { $_args['callback_args'] = array_merge([ 'type' => '', 'columns' => '', 'where' => '', 'having' => '', 'as_column' => '', 'filter_op' => 'equals', 'outer_select_column' => '', 'aggr_function' => 'MAX', 'use_date_filters' => true, 'results_per_page' => wp_slimstat::$settings['rows_to_show'], 'criteria' => '', ], $_args['callback_args']); } return $_args; } }