google analytics custom plugin

<?php
/**
* Plugin Name: 
* Plugin Author: 
* Plugin URI: 
*/
require_once realpath(dirname(__FILE__) . '/google-api-php-client/src/Google/autoload.php');

session_start();
global $analytica_db_version;
$analytica_db_version = '1.0';
class Analytica_Analytic
{
    /**
     * Holds the values to be used in the fields callbacks
     */
    private $options;
    
    /**
     * Start up
     */
    public function __construct()
    {

		register_activation_hook( __FILE__, array( $this, 'analytica_install' ) );
        add_action( 'admin_menu', array( $this, 'add_plugin_page' ) );
        add_action( 'admin_init', array( $this, 'page_init' ) );
		
    }

    /**
     * Add options page
     */
    public function add_plugin_page()
    {
        // This page will be under "Settings"
        add_utility_page(
            'Analytica', 
            'Analytica', 
            'manage_options', 
            'analytica-admin-settings', 
            array( $this, 'create_admin_page' ), 'dashicons-chart-area'
        );
    }

    /**
     * Options page callback
     */
    public function create_admin_page()
    {		
        // Set class property
        $this->options = get_option( 'analytica-option-name' );
        ?>
        <div class="wrap">
            <h2>Analytica Reports</h2>        
 <a href='#' onClick='login();' id="loginText"'>Get Authentication </a>
    <a href="#" style="display:none" id="logoutText" target='myIFrame' onclick="myIFrame.location='https://www.google.com/accounts/Logout'; startLogoutPolling();return false;">logout </a>
    <iframe name='myIFrame' id="myIFrame" style='display:none'></iframe>
    <div id='uName'></div>
    <img src='' id='imgHolder'/>			
		<form method="post" action="options.php">
			<?php
			   // This prints out all hidden setting fields
			   settings_fields( 'analytica-option-group' );   
			   do_settings_sections( 'analytica-admin-settings' );
			   submit_button(); 
			   //submit_button ( 'click', 'primary', 'click', false, '' );
			?>			  
		</form>
		<?php
		   // Check if there is a logout request in the URL.
			if (isset($_REQUEST['logout'])) {
				// Clear the access token from the session storage.
				unset($_SESSION['access_token']);
			}
			/*************************/
			$client = new Google_Client();
			$client->setAuthConfigFile(plugin_dir_url( __FILE__ ) . '/client_secrets.json');
			$client->setRedirectUri('urn:ietf:wg:oauth:2.0:oob');
			$client->addScope(Google_Service_Analytics::ANALYTICS_READONLY);
			$client->setIncludeGrantedScopes(true);
			$client->setAccessType('offline');
			/* $client->setAccessType('online');
			$client->setApprovalPrompt("auto"); */
			//$client->setApprovalPrompt("force");
			
			
			
		    if( isset( $this->options['authenication_code'] ) ){	
				global $wpdb;
				//$resultset = $wpdb->get_row( 'SELECT * FROM ' . $wpdb->prefix . 'analyticaAnalytics', ARRAY_A);
				$resultset = $wpdb->get_row( 'SELECT `refreshToken` FROM ' . $wpdb->prefix . 'analyticaAnalytics WHERE authenication_code ="' . $this->options["authenication_code"] . '"', ARRAY_A );
				var_dump( $resultset['refreshToken'] );
				//var_dump($wpdb->last_query);
				//$client->authenticate( $resultset['refreshToken'] );
				//var_dump($client);
				//$accessToken = $client->getAccessToken();
				//var_dump( $accessToken );
				if ($client->isAccessTokenExpired()) {   			
				    $client->refreshToken( $resultset['refreshToken'] );
					var_dump( $client );
				}
				exit;
			}
				$auth_url = $client->createAuthUrl();
			    //var_dump( $auth_url );
			
		?>
		<script>
		    var auth_url = '<?php echo $auth_url; ?>';
			function login() {
				var win = window.open('<?php echo $auth_url; ?>', "windowname1", 'width=800, height=600'); 

				var pollTimer = window.setInterval(function() { 
					try {
						console.log(win.document.URL);
						if (win.document.URL.indexOf(REDIRECT) != -1) {
							window.clearInterval(pollTimer);
							var url =   win.document.URL;
							acToken =   gup(url, 'access_token');
							tokenType = gup(url, 'token_type');
							expiresIn = gup(url, 'expires_in');
							win.close();

							validateToken(acToken);
						}
					} catch(e) {
					}
				}, 500);
			}

			function validateToken(token) {
				$.ajax({
					url: VALIDURL + token,
					data: null,
					success: function(responseText){  
						getUserInfo();
						console.log(responseText);
						loggedIn = true;
						$('#loginText').hide();
						$('#logoutText').show();
					},  
					dataType: "jsonp"  
				});
			}

			function getUserInfo() {
				$.ajax({
					url: 'https://www.googleapis.com/oauth2/v1/userinfo?access_token=' + acToken,
					data: null,
					success: function(resp) {
						console.log(resp);
					},
					dataType: "jsonp"
				});
			}

			//credits: http://www.netlobo.com/url_query_string_javascript.html
			function gup(url, name) {
				name = name.replace(/[\[]/,"\\\[").replace(/[\]]/,"\\\]");
				var regexS = "[\\#&]"+name+"=([^&#]*)";
				var regex = new RegExp( regexS );
				var results = regex.exec( url );
				if( results == null )
					return "";
				else
					return results[1];
			}

			function startLogoutPolling() {
				$('#loginText').show();
				$('#logoutText').hide();
				loggedIn = false;
				$('#uName').text('Welcome ');
				$('#imgHolder').attr('src', 'none.jpg');
			}

		</script>
		<?php
		if (!isset($_SESSION['access_token'])) {
			//$client->authenticate($_GET['code']);
		   
			if($client->isAccessTokenExpired()){

				$client->authenticate($this->options['authenication_code']);
			/*     if( !isset( $refreshToken ) ){
				    $refreshToken = $client->getRefreshToken();
	                var_dump($refreshToken);
					//$refreshToken = $client->refreshToken( $refreshToken );
					//var_dump($refreshToken);	
				} */
			    
				$accessToken = $client->getAccessToken();
				$refreshToken = $client->getRefreshToken();
			
				//global $wpdb;
				$table_name = $wpdb->prefix . 'analyticaAnalytics';
				$wpdb->insert( 
					$table_name,
					array( 
					    'time' => current_time( 'mysql' ),
						'authenication_code' => $this->options['authenication_code'], 
						'accessToken' =>  $accessToken,
						'refreshToken' => $refreshToken,
					)
				);
				
				//var_dump($wpdb->last_query);
			} else {
				
			}
			
		} //else {
			/* $resultset = $this->wpdb->get_row( "SELECT * FROM $wpdb->prefix . 'analyticaAnalytics' WHERE authenication_code = $this->options['authenication_code']", ARRAY_A );
				var_dump( $resultset );
				exit; */
		//}
		    
			$_SESSION['access_token'] = $accessToken ? $accessToken : $refreshToken;
			//var_dump( $_SESSION['accessToken'] );
			$client->setAccessToken($_SESSION['access_token']);
			//var_dump( $client );
			// Create an authorized analytics service object.
			$analytics = new Google_Service_Analytics($client);
				
			// Get the first view (profile) id for the authorized user.
			$profile = $this->getFirstProfileId($analytics);

			// Get the results from the Core Reporting API and print the results.
			$this->results = $this->getResults($analytics, $profile);

			$this->printDataTable($this->results);
		 //} 	if (!isset($_SESSION['access_token'])) {

		?>
	 
        </div>
		<div class="analytica-report">
		    <?php
               $this->printDataTable($this->results);
			  // $service->refresh_profiles();
			?>
		</div>
        <?php
    }
	
    /**
     * Register and add settings
     */
    public function page_init()
    {        
        register_setting(
            'analytica-option-group', // Option group
            'analytica-option-name', // Option name
            array( $this, 'sanitize' ) // Sanitize
        );

        add_settings_section(
            'setting_section_id', // ID
            'Analytica Custom Settings', // Title
            array( $this, 'print_section_info' ), // Callback
            'analytica-admin-settings' // Page
        );

        add_settings_field(
            'authenication_code', 
            'Authentication Code', 
            array( $this, 'authenication_code_callback' ), 
            'analytica-admin-settings', 
            'setting_section_id'
        );
		
		
    }

    /**
     * Sanitize each setting field as needed
     *
     * @param array $input Contains all settings fields as array keys
     */
    public function sanitize( $input )
    {
        $new_input = array();
 
        if( isset( $input['authenication_code'] ) )
            $new_input['authenication_code'] = sanitize_text_field( $input['authenication_code'] );

        return $new_input;
    }

    /** 
     * Print the Section text
     */
    public function print_section_info()
    {
        print 'Enter your authentication code below:';
    }

    /** 
     * Get the settings option array and print one of its values
     */
    public function authenication_code_callback()
    {
        printf(
            '<input type="text" id="authenication_code" name="analytica-option-name[authenication_code]" value="%s" />',
            isset( $this->options['authenication_code'] ) ? esc_attr( $this->options['authenication_code']) : ''
        );
    }
	
	
	
	public function getFirstprofileId(&$analytics) {
	  // Get the user's first view (profile) ID.

	  // Get the list of accounts for the authorized user.
	  $accounts = $analytics->management_accounts->listManagementAccounts();

	   if (count($accounts->getItems()) > 0) {
		$items = $accounts->getItems();
		$firstAccountId = $items[0]->getId();

		// Get the list of properties for the authorized user.
		$properties = $analytics->management_webproperties
			->listManagementWebproperties($firstAccountId);

		if (count($properties->getItems()) > 0) {
		  $items = $properties->getItems();
		  $firstPropertyId = $items[0]->getId();

		  // Get the list of views (profiles) for the authorized user.
		  $profiles = $analytics->management_profiles
			  ->listManagementProfiles($firstAccountId, $firstPropertyId);

		  if (count($profiles->getItems()) > 0) {
			$items = $profiles->getItems();

			// Return the first view (profile) ID.
			return $items[0]->getId();

		  } else {
			throw new Exception('No views (profiles) found for this user.');
		  }
		} else {
		  throw new Exception('No properties found for this user.');
		}
	  } else {
		throw new Exception('No accounts found for this user.');
	  }
	}

	public function getResults(&$analytics, $profileId) {
	  // Calls the Core Reporting API and queries for the number of sessions
	  // for the last seven days.
	  return $analytics->data_ga->get(
		  'ga:' . $profileId,
		  '7daysAgo',
		  'today',
		  'ga:pageviews',
		 
		  array('dimensions' => 'ga:pagePath') );
	}

	public function printDataTable(&$results) {

	  if (count($this->results->getRows()) > 0) {
		$table = '';
		$table .= '<table>';

		// Print headers.
		$table .= '<tr>';

		foreach ($this->results->getColumnHeaders() as $header) {
		  $table .= '<th>' . $header->name . '</th>';
		}
		$table .= '</tr>';

		// Print table rows.
		foreach ($this->results->getRows() as $row) {
		  $table .= '<tr>';
			foreach ($row as $cell) {
			  $table .= '<td>'
					 . htmlspecialchars($cell, ENT_NOQUOTES)
					 . '</td>';
			}
		  $table .= '</tr>';
		}
		$table .= '</table>';

	  } else {
		$table .= '<p>No Results Found.</p>';
	  }
	  print $table;
	}
	
	public function analytica_install(){

		global $wpdb;
		global $analytica_db_version;
		
		$table_name = $wpdb->prefix . 'analyticaAnalytics';
		
		$charset_collate = $wpdb->get_charset_collate();
		
		$sql = "CREATE TABLE $table_name(
		    id mediumint(9)  NOT NULL  AUTO_INCREMENT,
			time datetime  DEFAULT '0000-00-00 00:00:00'  NOT NULL,
			authenication_code varchar(1000)  NOT NULL,
			accessToken varchar(2000)  NOT NULL,
			refreshToken varchar(2000)  NOT NULL,
			UNIQUE KEY id(id)
		)$charset_collate;";
		
		require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
		dbDelta( $sql );
		
		add_option( 'analytica_db_version', $analytica_db_version );
	}
}

if( is_admin() ){
    $analytica = new Analytica_Analytic();
}