
­­­­­­­­­­­­­­­­­­
<!DOCTYPE html>
<html>
<?php
/**
 *
 * @package WPUpper Share Buttons
 * @author  Victor Freitas
 * @subpackage Share report
 * @since 3.35
 */
if ( ! defined( 'ABSPATH' ) ) {
	 // Exit if accessed directly.
	exit( 0 );
}

class WPUSB_Share_Report {

	const OPTION_CSN_CLOSED = 'wpusb-classificaton-providers-closed';

	public function __construct() {

	}

	/**
	 * Get classication total sharing counter by provider
	 *
	 * @since 3.35
	 * @param null
	 * @return Array
	 */
	public function get_total_share_by_provider() {
		global $wpdb;

		$table   = WPUSB_Utils::get_table_name();
		$results = $wpdb->get_row(
			"SELECT
				SUM(`facebook`) AS facebook,
				SUM(`twitter`) AS twitter,
				SUM(`google`) AS google,
				SUM(`linkedin`) AS linkedin,
				SUM(`pinterest`) AS pinterest,
				SUM(`tumblr`) AS tumblr,
				SUM(`buffer`) AS buffer
			 FROM `{$table}`
			",
			ARRAY_A
		);

		$results = array_filter( $results );

		if ( empty( $results ) ) {
			return false;
		}

		arsort( $results );

		return $results;
	}
}
