prefix . 'links_stats WHERE `date` BETWEEN %s AND DATE_ADD(%s, INTERVAL 1 DAY) GROUP BY SUBSTR(`date`, 1, '.$time_strlen.')'; $sql = $wpdb->prepare($sql, $start_date, $end_date); $raw_data = $wpdb->get_results($sql, ARRAY_A); if ( is_array($raw_data) && sizeof($raw_data) ) { $label_content = aff_get_chart_labels($start_date, $end_date, $stats_by, $chart_time_format); $data_content = aff_get_chart_data($start_date, $end_date, $raw_data, $stats_by, $chart_time_format); echo "

"; } else { _e('No statistics for given period.', 'affiliate-tools'); } } } if ( ! function_exists( 'aff_top_affiliate_link' ) ) { /** * Get top afffiliate link * * @param array $args * @return array */ function aff_top_affiliate_link() { global $wpdb; $stats_period = get_option('stats_period', 7); $stats_by = get_option('stats_by', 'day'); $start_date = date('Y-m-d', strtotime($end_date .' -'.$stats_period.' '.$stats_by)); $end_date = isset($_GET['date']) ? $_GET['date'] : date('Y-m-d'); $sql = 'select *,count(id) from ' . $wpdb->prefix . 'links_stats where `date` between %s and DATE_ADD(%s,INTERVAL 2 DAY) group by (url) ORDER BY (count(id)) DESC '; $sql = $wpdb->prepare($sql, $start_date, $end_date); $result = $wpdb->get_results($sql, ARRAY_A); if (is_array($result) && sizeof($result)) { echo " "; if(count($result) <= 10) { $i=1; foreach ($result as $row) { echo ''; } } else { for ($i=0; $i < 10; $i++) { echo ''; } } echo "

Link	View
'.$row['title'].'	'. $row['count(id)'].'
'.$result[$i]['title'].'	'. $result[$i]['count(id)'].'

"; } else { _e('No statistics for given period.', 'affiliate-tools'); } } } if ( ! function_exists( 'aff_enqueue_admin_scripts' ) ) { /** * Get top afffiliate link * * @param array $args * @return array */ function aff_enqueue_admin_scripts() { wp_enqueue_script( 'jquery' ); wp_enqueue_script( 'chart', plugins_url( '/js/Chart.min.js', __FILE__), array(), '0.0.1', false ); wp_enqueue_script( 'init-chart', plugins_url( '/js/init-chart.js', __FILE__), array(), '0.0.1', false ); wp_enqueue_script( 'aff-select2', plugins_url( '/js/select2.min.js', __FILE__), array(), '4.0.3', false ); aff_script_params(); } } if ( ! function_exists( 'aff_enqueue_admin_styles' ) ) { /** * Get top afffiliate link * * @param array $args * @return array */ function aff_enqueue_admin_styles() { wp_enqueue_style('aff-select2', plugins_url( '/public/assets/css/select2.min.css', __FILE__) ); wp_enqueue_style('affiliate-tools', plugins_url( '/public/assets/css/aff-widget.css', __FILE__) ); } } if ( ! function_exists( 'aff_script_params' ) ) { /** * XXX * * @param array $args * @return array */ function aff_script_params() { $aff_script_params = array( 'stats_period' => get_option('stats_period') ); wp_localize_script( 'init-chart', 'scriptParams', $aff_script_params ); } } if ( ! function_exists( 'aff_check_update_stats_options' ) ) { /** * Get top afffiliate link * * @param array $args * @return array */ function aff_check_update_stats_options() { if (isset($_POST['stats_by']) && isset($_POST['stats_period']) && (function_exists('wp_verify_nonce')) ) { if ( ! isset( $_POST['stats_options_nonce_field'] ) || ! wp_verify_nonce( $_POST['stats_options_nonce_field'], 'submit_stats_options' ) ) { wp_die( '

Sorry, your account did not verify!

' ); } else { $stats_by = sanitize_text_field( $_POST['stats_by'] ); update_option('stats_by', $stats_by); $stats_period = intval( $_POST['stats_period'] ); update_option('stats_period', $stats_period); } } aff_script_params(); } } function afftools_action_links( $links, $file ) { $settings_link = '' . esc_html__( 'Settings', 'affiliate-tools' ) . ''; if ( $file == 'affiliate-tools-viet-nam/affiliate-tools-viet-nam.php' ) array_unshift( $links, $settings_link ); return $links; } if (is_admin()) { include_once(plugin_dir_path(__FILE__) . 'functions/affiliate-tools-admin.php'); new AffiliateToolsAdmin(); aff_script_params(); aff_enqueue_admin_scripts(); aff_enqueue_admin_styles(); add_filter( 'plugin_action_links', 'afftools_action_links', 10, 2 ); } else { include_once(plugin_dir_path(__FILE__) . 'functions/affiliate-tools-parser.php'); new AffiliateToolsParser(); } if ( function_exists('register_uninstall_hook') ) { register_activation_hook(__FILE__, array('AffiliateToolsAdmin', 'activate')); register_deactivation_hook(__FILE__, array('AffiliateToolsAdmin','deactivate')); register_uninstall_hook(__FILE__, array('AffiliateToolsAdmin', 'uninstall')); } ?>