Changeset 2253191

Timestamp:

03/02/2020 07:52:25 PM (6 years ago)

Author:

salar6990

Message:

update trunk

Location:

wp-api-stats/trunk

Files:

• class-wp-api-stats.php (modified) (5 diffs)
• readme.txt (modified) (1 diff)
• wp-api-stats.php (modified) (1 diff)

wp-api-stats/trunk/class-wp-api-stats.php

@@ -98 +98 @@
 
         if(empty($current_date_to)){
-            $current_date_to = date('Y-m-d',strtotime('today') );
+            $current_date_to = date('Y-m-d 23:59:59',strtotime('today') );
         }
 
@@ -148 +148 @@
             
             $results = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}sg_api_stats_events WHERE time >= $q_start AND time < $q_end", OBJECT );
-            $count = count($results);
-
-            
+            $count = 0;
+
             foreach($methods as $method){
                 $c = 0;
                 foreach($results as $entry){
                     if( $entry->method == $method){
-                        $c++;
+                        $c+=1;
                     }
                 }
+                $count += $c;
                 $data[$method][] = $c;
             }
@@ -172 +172 @@
             
         }
-
-        $this->prepared_data = compact('data', 'current_date_from', 'current_date_to', 'selected_chunk', 'labels');
+        $query = "SELECT 
+        e.method,
+        e.route,
+        COUNT(e.id) AS count,
+        AVG(e.duration) as average_duration
+
+        FROM {$wpdb->prefix}sg_api_stats_events e
+
+        WHERE e.time >= '$current_date_from' AND e.time < '$current_date_to'
+        GROUP BY e.method, e.route
+        ORDER BY count desc         
+        ";
+        $tableData = $wpdb->get_results($query, OBJECT );
+
+        $this->prepared_data = compact('data','tableData', 'current_date_from', 'current_date_to', 'selected_chunk', 'labels');
 
         return $this->prepared_data;
@@ -197 +210 @@
         extract($this->prepare_data());
         include __DIR__ . '/views/admin-panel.php';
+        include __DIR__ . '/views/table.php';
     }
 
@@ -206 +220 @@
         wp_enqueue_script('chartjs', plugins_url('assets/chartjs/Chart.min.js', __FILE__), array(), '2.8.0' );
         wp_enqueue_script('api-stats-draw', plugins_url('assets/draw.js', __FILE__), array('chartjs'), '1.0', true );
+        wp_enqueue_style( 'api-stats', plugins_url('assets/api-stats.css', __FILE__));
+
     }
 

wp-api-stats/trunk/readme.txt

@@ -3 +3 @@
 Tags: API REST-API Statistics stats
 Requires at least: 4.4
-Tested up to: 5.2.2
+Tested up to: 5.3.2
 Requires PHP: 5.6
 License: GPLv3
 License URI: https://www.gnu.org/licenses/gpl-3.0.html
-Stable Tag: 1.2.0
+Stable Tag: 1.3.0
 
 View API calls to your website

wp-api-stats/trunk/wp-api-stats.php

@@ -1 +1 @@
 <?php
-/**
- * @wordpress-plugin
- * Plugin Name:       WP API Stats
- * Plugin URI:        https://github.com/salar90/wp-api-stats
- * Description:       Track and Analyse WordPress API calls and requests.
- * Version:           1.2.0
- * Author:            Salar Gholizadeh
- * Author URI:        http://salar.one/
- * License:           GPL-2.0+
- * License URI:       http://www.gnu.org/licenses/gpl-2.0.txt
- * Text Domain:       api-stats
- * Domain Path:       /languages
+/*
+Plugin Name: WP API Stats
+Description: Track and Analyse WordPress API calls and requests.
+Author: Salar Gholizadeh
+Version: 1.3.0
+Plugin URI: https://github.com/salar90/wp-api-stats
+Author URI: http://salar.one/
+License: GNU General Public License v3.0
+License URI: http://www.gnu.org/licenses/gpl-3.0.txt
+Text Domain: api-stats
+Domain Path: /languages
  */