prefix . "usermeta WHERE meta_key = %s"; $ciwcamp_affiliates_data = $wpdb->get_results( $wpdb->prepare( $ciwcamp_affiliates_query, "ciwcamp_affiliate_registration" ) ); $ciwcamp_total_affiliates = $ciwcamp_affiliates_data[0]->total_affiliates; $ciwcamp_visits_query = "SELECT COUNT(*) AS total_visits FROM " . $wpdb->prefix . "ciwcamp_visits"; $ciwcamp_visits_data = $wpdb->get_results( $wpdb->prepare( $ciwcamp_visits_query ) ); $ciwcamp_total_visits = $ciwcamp_visits_data[0]->total_visits; $ciwcamp_sales_query = "SELECT COUNT(*) AS total_sales FROM " . $wpdb->prefix . "ciwcamp_sales"; $ciwcamp_sales_data = $wpdb->get_results( $wpdb->prepare( $ciwcamp_sales_query ) ); $ciwcamp_total_sales = $ciwcamp_sales_data[0]->total_sales; $ciwcamp_commission_query = "SELECT SUM(commission) AS total_commission FROM " . $wpdb->prefix . "ciwcamp_sales WHERE product_id!=%s"; $ciwcamp_commission_data = $wpdb->get_results( $wpdb->prepare( $ciwcamp_commission_query,"" ) ); $ciwcamp_total_commission = $ciwcamp_commission_data[0]->total_commission; $ciwcamp_top_affiliates_query = "SELECT affiliate_id, count(sales_id) as total_sale, SUM(commission) as commission FROM " . $wpdb->prefix . "ciwcamp_sales WHERE status = %s AND MONTH(created_date) = MONTH(CURRENT_DATE()) GROUP BY affiliate_id ORDER BY total_sale DESC LIMIT 5"; $ciwcamp_top_affiliates_data = $wpdb->get_results( $wpdb->prepare( $ciwcamp_top_affiliates_query,"Approved" ) ); $ciwcamp_top_product_query = "SELECT product_id, count(product_id) as product_count, SUM(product_price) as product_price, SUM(commission) as commission FROM " . $wpdb->prefix . "ciwcamp_sales WHERE product_id!=%s GROUP BY product_id ORDER BY count(product_id) DESC LIMIT 5"; $ciwcamp_top_product_data = $wpdb->get_results( $wpdb->prepare( $ciwcamp_top_product_query, "" ) ); $ciwcamp_recent_sale_query = "select * from " . $wpdb->prefix . "ciwcamp_sales order by sales_id DESC limit 5"; $ciwcamp_recent_sale_data = $wpdb->get_results( $wpdb->prepare( $ciwcamp_recent_sale_query ) ); function ciwcamp_total_visits($ciwcamp_affiliate_id) { global $wpdb; $ciwcamp_query = "SELECT COUNT(*) AS total_visits FROM " . $wpdb->prefix . "ciwcamp_visits WHERE affiliate_id =%s"; $ciwcamp_query_data = $wpdb->get_results( $wpdb->prepare( $ciwcamp_query, $ciwcamp_affiliate_id ) ); return $ciwcamp_query_data[0]->total_visits; } ?>

affiliate_id, "first_name")[0]." ".get_user_meta($ciwcamp_affiliates->affiliate_id, "last_name")[0]; $ciwcamp_total_visits = ciwcamp_total_visits($ciwcamp_affiliates->affiliate_id); ?>
affiliate_id." ".$ciwcamp_affiliate_name, 'ciwcamp-affliate-manager'); ?> total_sale,'ciwcamp-affliate-manager'); ?> commission, 4),'ciwcamp-affliate-manager'); ?>
affiliate_id, "first_name")[0]." ".get_user_meta($ciwcamp_recent_sale->affiliate_id, "last_name")[0]; ?>
sales_id,'ciwcamp-affliate-manager' ); ?> affiliate_id." ".$ciwcamp_affiliate_name,'ciwcamp-affliate-manager' ); ?> commission,'ciwcamp-affliate-manager' ); ?>
product_id); ?> product_id ),'ciwcamp-affliate-manager' ); ?> product_count,'ciwcamp-affliate-manager' ); ?> product_price,'ciwcamp-affliate-manager' ); ?> commission,'ciwcamp-affliate-manager' ); ?>