Changeset 1262314
- Timestamp:
- 10/09/2015 08:39:56 AM (10 years ago)
- Location:
- mini-statistics
- Files:
-
- 7 edited
-
assets/screenshot-1.png (modified) (previous)
-
assets/screenshot-2.png (modified) (previous)
-
assets/screenshot-3.png (modified) (previous)
-
assets/screenshot-4.png (modified) (previous)
-
assets/screenshot-5.png (modified) (previous)
-
trunk/mini-statistics.php (modified) (16 diffs)
-
trunk/readme.txt (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
mini-statistics/trunk/mini-statistics.php
r1030076 r1262314 4 4 Plugin URI: https://wordpress.org/plugins/mini-statistics/ 5 5 Description: This plugin is a small and simple Users Statistics and Comments Statistics plugin for WordPress. 6 Version: 1.0. 26 Version: 1.0.3 7 7 Author: Ayan Debnath 8 8 Author URI: http://about.me/ayandebnath … … 97 97 <div class="clear"><hr /></div> 98 98 99 99 100 <!-- MORE IN NEAR FUTURE --> 100 101 … … 114 115 115 116 $max_c = 0; 116 $data = ''; 117 $data1 = ''; 118 $data2 = ''; 117 119 $data_table = array(); 118 120 … … 129 131 )); 130 132 133 $flag1=false; 134 $flag2=true; 135 $data1 = "['Time', 'Comments'],"; 136 131 137 $tmp = ''; 132 138 for ( $y=$start_date; $y<=intval(date('Y')); $y++ ) { … … 136 142 $wpdb->prepare( 137 143 " 138 SELECT count(*) FROM $wpdb->comments144 SELECT count(*) C FROM $wpdb->comments 139 145 WHERE comment_approved = 1 140 146 AND MONTH(comment_date) = %d … … 143 149 , $m, $y) 144 150 )); 151 152 if($c>0) $flag1=true; 153 154 if($flag1 && $flag2) { 155 $mn=strftime("%b", mktime(0, 0, 0, $m)); 156 $data1 .= "['{$mn}-{$y}' , {$c}],"; 157 } 158 145 159 if( $c > $max_c ) $max_c = $c; 146 160 $data_table[date('M', mktime(0, 0, 0, $m, 10))][$y] = $c; 147 161 } 148 162 } 149 $data .= "['Month' $tmp],"; 163 164 $data2 = "['Month' $tmp],"; 150 165 151 166 $tmp = ''; … … 155 170 $tmp .= ','. $d; 156 171 } 157 $data .= "[$tmp],"; 158 } 159 $data = trim(trim($data, ',')); 172 $data2 .= "[$tmp],"; 173 } 174 175 $data1 = trim(trim($data1, ',')); 176 $data2 = trim(trim($data2, ',')); 160 177 ?> 161 <div style="text-align:right;margin:-30px 10px 15px 0;">162 <button class="button button-primary" id=" column">Column Chart</button>178 <div class="ministat_nav" style="text-align:right;margin:-30px 10px 15px 0;"> 179 <button class="button button-primary" id="timeline">Overview</button> 163 180 <button class="button" id="line">Line Chart</button> 181 <button class="button" id="column">Column Chart</button> 164 182 </div> 165 183 166 184 <div id="chart_div" style="width:98%; height: 450px;"></div> 167 185 <script type="text/javascript"> 168 var chartType = ' column';186 var chartType = 'timeline'; 169 187 170 188 google.load("visualization", "1", {packages:["corechart"]}); … … 172 190 173 191 function drawChart() { 174 var data = google.visualization.arrayToDataTable([<?php echo $data;?>]); 192 var data1 = google.visualization.arrayToDataTable([<?php echo $data1;?>]); 193 var data2 = google.visualization.arrayToDataTable([<?php echo $data2;?>]); 175 194 var options = { 176 195 title: '', … … 187 206 }; 188 207 189 if(chartType == 'column') var chart = new google.visualization.ColumnChart(document.getElementById('chart_div')); 190 191 if(chartType == 'line') var chart = new google.visualization.LineChart(document.getElementById('chart_div')); 192 193 chart.draw(data, options); 208 if(chartType == 'timeline') { 209 var chart = new google.visualization.AreaChart(document.getElementById('chart_div')); 210 chart.draw(data1, options); 211 } 212 213 if(chartType == 'column') { 214 var chart = new google.visualization.ColumnChart(document.getElementById('chart_div')); 215 chart.draw(data2, options); 216 } 217 218 if(chartType == 'line') { 219 var chart = new google.visualization.AreaChart(document.getElementById('chart_div')); 220 chart.draw(data2, options); 221 } 194 222 } 195 223 196 224 jQuery(document).ready(function($) { 197 225 198 $('button#column').click(function(){ 226 $('.ministat_nav button#timeline').click(function(){ 227 chartType = 'timeline'; 228 drawChart(); 229 230 $(".ministat_nav button").removeClass('button-primary'); 231 $(this).addClass('button-primary'); 232 }); 233 234 $('.ministat_nav button#column').click(function(){ 199 235 chartType = 'column'; 200 236 drawChart(); 201 237 202 $("button#column, button#line").removeClass('button-primary'); 203 $(this).addClass('button-primary'); 204 }); 205 $('button#line').click(function(){ 238 $(".ministat_nav button").removeClass('button-primary'); 239 $(this).addClass('button-primary'); 240 }); 241 242 $('.ministat_nav button#line').click(function(){ 206 243 chartType = 'line'; 207 244 drawChart(); 208 245 209 $(" button#column, button#line").removeClass('button-primary');246 $(".ministat_nav button").removeClass('button-primary'); 210 247 $(this).addClass('button-primary'); 211 248 }); … … 220 257 221 258 $max_c = 0; 222 $data = ''; 259 $data1 = ''; 260 $data2 = ''; 223 261 $data_table = array(); 224 262 … … 234 272 )); 235 273 274 $flag1=false; 275 $flag2=true; 276 $data1 = "['Time', 'Registrations'],"; 277 236 278 $tmp = ''; 237 279 for ( $y=$start_date; $y<=intval(date('Y')); $y++ ) { … … 241 283 $wpdb->prepare( 242 284 " 243 SELECT count(*) FROM $wpdb->users285 SELECT count(*) C FROM $wpdb->users 244 286 WHERE MONTH(user_registered) = %d 245 287 AND YEAR(user_registered) = %d … … 247 289 , $m, $y) 248 290 )); 291 292 if($c>0) $flag1=true; 293 if($flag1 && $flag2) { 294 $mn=strftime("%b", mktime(0, 0, 0, $m)); 295 $data1 .= "['{$mn}-{$y}' , {$c}],"; 296 } 297 249 298 if( $c > $max_c ) $max_c = $c; 250 299 $data_table[date('M', mktime(0, 0, 0, $m, 10))][$y] = $c; 251 300 } 252 301 } 253 $data .= "['Month' $tmp],";302 $data2 = "['Month' $tmp],"; 254 303 255 304 $tmp = ''; … … 259 308 $tmp .= ','. $d; 260 309 } 261 $data .= "[$tmp],"; 262 } 263 $data = trim(trim($data, ',')); 310 $data2 .= "[$tmp],"; 311 } 312 313 $data1 = trim(trim($data1, ',')); 314 $data2 = trim(trim($data2, ',')); 264 315 ?> 265 <div style="text-align:right;margin:-30px 10px 15px 0;">266 <button class="button button-primary" id=" column">Column Chart</button>316 <div class="ministat_nav" style="text-align:right;margin:-30px 10px 15px 0;"> 317 <button class="button button-primary" id="timeline">Overview</button> 267 318 <button class="button" id="line">Line Chart</button> 319 <button class="button" id="column">Column Chart</button> 268 320 </div> 269 321 270 322 <div id="chart_div" style="width:98%; height: 450px;"></div> 271 323 <script type="text/javascript"> 272 var chartType = ' column';324 var chartType = 'timeline'; 273 325 274 326 google.load("visualization", "1", {packages:["corechart"]}); … … 276 328 277 329 function drawChart() { 278 var data = google.visualization.arrayToDataTable([<?php echo $data;?>]); 330 var data1 = google.visualization.arrayToDataTable([<?php echo $data1;?>]); 331 var data2 = google.visualization.arrayToDataTable([<?php echo $data2;?>]); 279 332 var options = { 280 333 title: '', … … 291 344 }; 292 345 293 if(chartType == 'column') var chart = new google.visualization.ColumnChart(document.getElementById('chart_div')); 294 295 if(chartType == 'line') var chart = new google.visualization.LineChart(document.getElementById('chart_div')); 296 297 chart.draw(data, options); 346 if(chartType == 'timeline') { 347 var chart = new google.visualization.AreaChart(document.getElementById('chart_div')); 348 chart.draw(data1, options); 349 } 350 351 if(chartType == 'column') { 352 var chart = new google.visualization.ColumnChart(document.getElementById('chart_div')); 353 chart.draw(data2, options); 354 } 355 356 if(chartType == 'line') { 357 var chart = new google.visualization.AreaChart(document.getElementById('chart_div')); 358 chart.draw(data2, options); 359 } 298 360 } 299 361 300 362 jQuery(document).ready(function($) { 301 363 302 $('button#column').click(function(){ 364 $('.ministat_nav button#timeline').click(function(){ 365 chartType = 'timeline'; 366 drawChart(); 367 368 $(".ministat_nav button").removeClass('button-primary'); 369 $(this).addClass('button-primary'); 370 }); 371 372 $('.ministat_nav button#column').click(function(){ 303 373 chartType = 'column'; 304 374 drawChart(); 305 375 306 $("button#column, button#line").removeClass('button-primary'); 307 $(this).addClass('button-primary'); 308 }); 309 $('button#line').click(function(){ 376 $(".ministat_nav button").removeClass('button-primary'); 377 $(this).addClass('button-primary'); 378 }); 379 380 $('.ministat_nav button#line').click(function(){ 310 381 chartType = 'line'; 311 382 drawChart(); 312 383 313 $(" button#column, button#line").removeClass('button-primary');384 $(".ministat_nav button").removeClass('button-primary'); 314 385 $(this).addClass('button-primary'); 315 386 }); -
mini-statistics/trunk/readme.txt
r1146878 r1262314 4 4 Tags: comments, users, admin, statistics 5 5 Requires at least: 3.0.1 6 Tested up to: 4. 26 Tested up to: 4.3.1 7 7 Stable tag: 4.3 8 8 License: GPLv2 or later … … 25 25 26 26 1. Mini Statistics admin page showing list of available statistics. 27 2. Yearly User Registration statistics in Column Chart/Bar Diagram. 28 3. Yearly User Registration statistics in Line Diagram. 29 4. Yearly User Comments statistics in Column Chart/Bar Diagram. 30 5. Yearly User Comments statistics in Line Diagram. 27 2. Oviewview statistics of User Registrations. 28 3. Yearly User Registration statistics in Column Chart/Bar Diagram. 29 4. Yearly User Registration statistics in Line Diagram. 30 5. Oviewview statistics of User Comments. 31 6. Yearly User Comments statistics in Column Chart/Bar Diagram. 32 7. Yearly User Comments statistics in Line Diagram. 31 33 32 34 == Changelog == 35 36 = 1.0.3 = 37 * Added Overview Chart as Default. 38 * Better design for Line Charts. 33 39 34 40 = 1.0.2 =
Note: See TracChangeset
for help on using the changeset viewer.