Completed
Push — master ( 3d8cb5...5a808c )
by Yannick
07:32
created
statistics.php 1 patch
Braces   +103 added lines, -42 removed lines patch added patch discarded remove patch
@@ -6,11 +6,15 @@  discard block
 block discarded – undo
6 6
 $beginpage = microtime(true);
7 7
 $Stats = new Stats();
8 8
 
9
-if (!isset($filter_name)) $filter_name = '';
9
+if (!isset($filter_name)) {
10
+	$filter_name = '';
11
+}
10 12
 $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING);
11 13
 if ($airline_icao == '' && isset($globalFilter)) {
12
-	if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0];
13
-}
14
+	if (isset($globalFilter['airline'])) {
15
+		$airline_icao = $globalFilter['airline'][0];
16
+	}
17
+	}
14 18
 if ($airline_icao != '' && $airline_icao != 'all') {
15 19
 	$Spotter = new Spotter();
16 20
 	$airline_info = $Spotter->getAllAirlineInfo($airline_icao);
@@ -36,14 +40,21 @@  discard block
 block discarded – undo
36 40
 <script type="text/javascript" src="<?php echo $globalURL; ?>/js/justgage.js"></script>
37 41
 <div class="column">
38 42
     <div class="info">
39
-            <h1><?php if (isset($airline_name)) echo _("Statistics for ").$airline_name; else echo _("Statistics"); ?></h1>
43
+            <h1><?php if (isset($airline_name)) {
44
+	echo _("Statistics for ").$airline_name;
45
+} else {
46
+	echo _("Statistics");
47
+}
48
+?></h1>
40 49
     <?php 
41 50
 	$last_update = $Stats->getLastStatsUpdate();
42 51
 	//if (isset($last_update[0]['value'])) print '<!-- Last update : '.$last_update[0]['value'].' -->';
43 52
 	if (isset($last_update[0]['value'])) {
44 53
 		date_default_timezone_set('UTC');
45 54
 		$lastupdate = strtotime($last_update[0]['value']);
46
-		if (isset($globalTimezone) && $globalTimezone != '') date_default_timezone_set($globalTimezone);
55
+		if (isset($globalTimezone) && $globalTimezone != '') {
56
+			date_default_timezone_set($globalTimezone);
57
+		}
47 58
 		print '<i>Last update: '.date('Y-m-d G:i:s',$lastupdate).'</i>';
48 59
 	}
49 60
     ?>
@@ -95,8 +106,9 @@  discard block
 block discarded – undo
95 106
                 <h2><?php echo _("Top 10 Most Common Aircraft Type"); ?></h2>
96 107
                  <?php
97 108
                   $aircraft_array = $Stats->countAllAircraftTypes(true,$airline_icao,$filter_name,$year,$month);
98
-		    if (count($aircraft_array) == 0) print _("No data available");
99
-		    else {
109
+		    if (count($aircraft_array) == 0) {
110
+		    	print _("No data available");
111
+		    } else {
100 112
 
101 113
                     print '<div id="chart1" class="chart" width="100%"></div>
102 114
                     <script> 
@@ -133,11 +145,17 @@  discard block
 block discarded – undo
133 145
             	    <?php
134 146
             		if ($year != '' && $month != '') {
135 147
             	    ?>
136
-            	    <a href="<?php print $globalURL; ?>/statistics/aircraft<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; ?>/<?php echo $year; ?>/<?php echo $month ?>/" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>&raquo;</a>
148
+            	    <a href="<?php print $globalURL; ?>/statistics/aircraft<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') {
149
+	echo '/'.$airline_icao;
150
+}
151
+?>/<?php echo $year; ?>/<?php echo $month ?>/" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>&raquo;</a>
137 152
             	    <?php
138 153
             		} else {
139 154
             	    ?>
140
-            	    <a href="<?php print $globalURL; ?>/statistics/aircraft<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; ?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>&raquo;</a>
155
+            	    <a href="<?php print $globalURL; ?>/statistics/aircraft<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') {
156
+	echo '/'.$airline_icao;
157
+}
158
+?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>&raquo;</a>
141 159
             	    <?php
142 160
             		}
143 161
             	    ?>
@@ -182,11 +200,15 @@  discard block
 block discarded – undo
182 200
                   </script>';
183 201
 	    if ($year != '' && $month != '') {
184 202
 		print '<div class="more"><a href="'.$globalURL.'/statistics/airline';
185
-		if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao;
203
+		if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') {
204
+			echo '/'.$airline_icao;
205
+		}
186 206
 		print '/'.$year.'/'.$month.'/" class="btn btn-default btn" role="button">'._("See full statistic").'&raquo;</a></div>';
187 207
 	    } else {
188 208
 		print '<div class="more"><a href="'.$globalURL.'/statistics/airline';
189
-		if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao;
209
+		if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') {
210
+			echo '/'.$airline_icao;
211
+		}
190 212
 		print '" class="btn btn-default btn" role="button">'._("See full statistic").'&raquo;</a></div>';
191 213
 	    }
192 214
     	    print '</div>';
@@ -210,8 +232,9 @@  discard block
 block discarded – undo
210 232
                 <h2><?php echo _("Top 10 Most Common Pilots"); ?></h2>
211 233
 <?php
212 234
 	$pilot_array = $Stats->countAllPilots(true,$airline_icao,$filter_name,$year,$month);
213
-	if (count($pilot_array) == 0) print _("No data available");
214
-	else {
235
+	if (count($pilot_array) == 0) {
236
+		print _("No data available");
237
+	} else {
215 238
 	    print '<div id="chart7" class="chart" width="100%"></div>
216 239
                     <script> 
217 240
                         google.load("visualization", "1", {packages:["corechart"]});
@@ -244,7 +267,9 @@  discard block
 block discarded – undo
244 267
         }
245 268
         print '<div class="more">';
246 269
 	print '<a href="'.$globalURL.'/statistics/pilot'; 
247
-	if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao;
270
+	if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') {
271
+		echo '/'.$airline_icao;
272
+	}
248 273
 	print'" class="btn btn-default btn" role="button">'._("See full statistic").'&raquo;</a>';
249 274
 	print '</div>';
250 275
 ?>
@@ -258,8 +283,9 @@  discard block
 block discarded – undo
258 283
                 <h2><?php echo _("Top 10 Most Common Owners"); ?></h2>
259 284
 <?php
260 285
 	$owner_array = $Stats->countAllOwners(true,$airline_icao,$filter_name,$year,$month);
261
-	if (count($owner_array) == 0) print _("No data available");
262
-	else {
286
+	if (count($owner_array) == 0) {
287
+		print _("No data available");
288
+	} else {
263 289
 	    print '<div id="chart7" class="chart" width="100%"></div>
264 290
                     <script> 
265 291
                         google.load("visualization", "1", {packages:["corechart"]});
@@ -292,7 +318,10 @@  discard block
 block discarded – undo
292 318
 	}
293 319
 ?>
294 320
                 <div class="more">
295
-                    <a href="<?php print $globalURL; ?>/statistics/owner<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; ?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>&raquo;</a>
321
+                    <a href="<?php print $globalURL; ?>/statistics/owner<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') {
322
+	echo '/'.$airline_icao;
323
+}
324
+?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>&raquo;</a>
296 325
                 </div>
297 326
             </div>
298 327
         
@@ -305,8 +334,9 @@  discard block
 block discarded – undo
305 334
                 <h2><?php echo _("Top 20 Most Common Country a Flight was Over"); ?></h2>
306 335
 <?php
307 336
 	 //$flightover_array = $Stats->countAllFlightOverCountries();
308
-	if (count($flightover_array) == 0) print _("No data available");
309
-	else {
337
+	if (count($flightover_array) == 0) {
338
+		print _("No data available");
339
+	} else {
310 340
 	    print '<div id="chart10" class="chart" width="100%"></div>
311 341
                     <script> 
312 342
                         google.load("visualization", "1", {packages:["corechart"]});
@@ -341,7 +371,10 @@  discard block
 block discarded – undo
341 371
 	}
342 372
 ?>
343 373
                 <div class="more">
344
-                    <a href="<?php print $globalURL; ?>/statistics/country<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; ?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>&raquo;</a>
374
+                    <a href="<?php print $globalURL; ?>/statistics/country<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') {
375
+	echo '/'.$airline_icao;
376
+}
377
+?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>&raquo;</a>
345 378
                 </div>
346 379
             </div>
347 380
 <?php
@@ -394,7 +427,9 @@  discard block
 block discarded – undo
394 427
               }
395 428
                 </script>';
396 429
 	print '<div class="more"><a href="'.$globalURL.'/statistics/airport-departure'; 
397
-	if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao;
430
+	if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') {
431
+		echo '/'.$airline_icao;
432
+	}
398 433
 	print '" class="btn btn-default btn" role="button">'._("See full statistic").'&raquo;</a></div>';
399 434
     }
400 435
 ?>
@@ -441,7 +476,9 @@  discard block
 block discarded – undo
441 476
               }
442 477
                 </script>';
443 478
 	print '<div class="more"><a href="'.$globalURL.'/statistics/airport-arrival';
444
-	if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao;
479
+	if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') {
480
+		echo '/'.$airline_icao;
481
+	}
445 482
 	print '" class="btn btn-default btn" role="button">'._("See full statistic").'&raquo;</a></div>';
446 483
     }
447 484
 ?>
@@ -456,8 +493,9 @@  discard block
 block discarded – undo
456 493
                 <h2><?php echo _("Busiest Months of the last 12 Months"); ?></h2>
457 494
                 <?php
458 495
                   $year_array = $Stats->countAllMonthsLastYear(true,$airline_icao,$filter_name);
459
-		    if (count($year_array) == 0) print _("No data available");
460
-		    else {
496
+		    if (count($year_array) == 0) {
497
+		    	print _("No data available");
498
+		    } else {
461 499
                   print '<div id="chart8" class="chart" width="100%"></div>
462 500
                     <script> 
463 501
                         google.load("visualization", "1", {packages:["corechart"]});
@@ -493,7 +531,10 @@  discard block
 block discarded – undo
493 531
                   }
494 532
                   ?>
495 533
                 <div class="more">
496
-                    <a href="<?php print $globalURL; ?>/statistics/year<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; ?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>&raquo;</a>
534
+                    <a href="<?php print $globalURL; ?>/statistics/year<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') {
535
+	echo '/'.$airline_icao;
536
+}
537
+?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>&raquo;</a>
497 538
                 </div>
498 539
             </div>
499 540
     <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> -->
@@ -501,8 +542,9 @@  discard block
 block discarded – undo
501 542
                 <h2><?php echo _("Busiest Day in the last Month"); ?></h2>
502 543
                 <?php
503 544
                   $month_array = $Stats->countAllDatesLastMonth($airline_icao,$filter_name);
504
-		    if (count($month_array) == 0) print _("No data available");
505
-		    else {
545
+		    if (count($month_array) == 0) {
546
+		    	print _("No data available");
547
+		    } else {
506 548
                   print '<div id="chart9" class="chart" width="100%"></div>
507 549
                     <script> 
508 550
                         google.load("visualization", "1", {packages:["corechart"]});
@@ -538,7 +580,10 @@  discard block
 block discarded – undo
538 580
                   }
539 581
                   ?>
540 582
                 <div class="more">
541
-                    <a href="<?php print $globalURL; ?>/statistics/month<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; ?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>&raquo;</a>
583
+                    <a href="<?php print $globalURL; ?>/statistics/month<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') {
584
+	echo '/'.$airline_icao;
585
+}
586
+?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>&raquo;</a>
542 587
                 </div>
543 588
             </div>
544 589
     <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> -->
@@ -547,8 +592,9 @@  discard block
 block discarded – undo
547 592
                 <h2><?php echo _("Busiest Day in the last 7 Days"); ?></h2>
548 593
                 <?php
549 594
                     $date_array = $Stats->countAllDatesLast7Days($airline_icao,$filter_name);
550
-		    if (empty($date_array)) print _("No data available");
551
-		    else {
595
+		    if (empty($date_array)) {
596
+		    	print _("No data available");
597
+		    } else {
552 598
                   print '<div id="chart5" class="chart" width="100%"></div>
553 599
                     <script> 
554 600
                         google.load("visualization", "1", {packages:["corechart"]});
@@ -585,7 +631,10 @@  discard block
 block discarded – undo
585 631
                   }
586 632
                   ?>
587 633
                 <div class="more">
588
-                    <a href="<?php print $globalURL; ?>/statistics/date<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; ?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>&raquo;</a>
634
+                    <a href="<?php print $globalURL; ?>/statistics/date<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') {
635
+	echo '/'.$airline_icao;
636
+}
637
+?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>&raquo;</a>
589 638
                 </div>
590 639
             </div>
591 640
     <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> -->
@@ -593,8 +642,9 @@  discard block
 block discarded – undo
593 642
                 <h2><?php echo _("Busiest Time of the Day"); ?></h2>
594 643
                 <?php
595 644
                   $hour_array = $Stats->countAllHours('hour',true,$airline_icao,$filter_name);
596
-		    if (empty($hour_array)) print _("No data available");
597
-		    else {
645
+		    if (empty($hour_array)) {
646
+		    	print _("No data available");
647
+		    } else {
598 648
 
599 649
                   print '<div id="chart6" class="chart" width="100%"></div>
600 650
                     <script> 
@@ -631,7 +681,10 @@  discard block
 block discarded – undo
631 681
                   }
632 682
                 ?>
633 683
                 <div class="more">
634
-                    <a href="<?php print $globalURL; ?>/statistics/time<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; ?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>&raquo;</a>
684
+                    <a href="<?php print $globalURL; ?>/statistics/time<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') {
685
+	echo '/'.$airline_icao;
686
+}
687
+?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>&raquo;</a>
635 688
                 </div>
636 689
             </div>
637 690
     <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> -->
@@ -648,8 +701,9 @@  discard block
 block discarded – undo
648 701
                 <h2><?php echo _("Fatalities by Years"); ?></h2>
649 702
                 <?php
650 703
                   $year_array = $Stats->countFatalitiesByYear();
651
-		    if (count($year_array) == 0) print _("No data available");
652
-		    else {
704
+		    if (count($year_array) == 0) {
705
+		    	print _("No data available");
706
+		    } else {
653 707
                   print '<div id="chart32" class="chart" width="100%"></div>
654 708
                     <script> 
655 709
                         google.load("visualization", "1", {packages:["corechart"]});
@@ -695,8 +749,9 @@  discard block
 block discarded – undo
695 749
                 <h2><?php echo _("Fatalities last 12 Months"); ?></h2>
696 750
                 <?php
697 751
                   $year_array = $Stats->countFatalitiesLast12Months();
698
-		    if (count($year_array) == 0) print _("No data available");
699
-		    else {
752
+		    if (count($year_array) == 0) {
753
+		    	print _("No data available");
754
+		    } else {
700 755
                   print '<div id="chart33" class="chart" width="100%"></div>
701 756
                     <script> 
702 757
                         google.load("visualization", "1", {packages:["corechart"]});
@@ -772,8 +827,11 @@  discard block
 block discarded – undo
772 827
 					$distance = $distance;
773 828
 					$unit = 'km';
774 829
 				}
775
-        			if (!isset($polar_data)) $polar_data = '{axis:"'.$direction[0]['direction_shortname'].'",value:'.$key.'}';
776
-        	    		else $polar_data = $polar_data.',{axis:"'.$direction[0]['direction_shortname'].'",value:'.$key.'}';
830
+        			if (!isset($polar_data)) {
831
+        				$polar_data = '{axis:"'.$direction[0]['direction_shortname'].'",value:'.$key.'}';
832
+        			} else {
833
+        	    			$polar_data = $polar_data.',{axis:"'.$direction[0]['direction_shortname'].'",value:'.$key.'}';
834
+        	    		}
777 835
         		    }
778 836
         	?>
779 837
             <div class="col-md-6">
@@ -825,8 +883,11 @@  discard block
 block discarded – undo
825 883
         		foreach ($msg as $eachmsg) {
826 884
         		    //$eachmsg = $msg[0];
827 885
         		    $data = $eachmsg['source_data'];
828
-        		    if ($data > 500) $max = (round(($data+100)/100))*100;
829
-        		    else $max = 500;
886
+        		    if ($data > 500) {
887
+        		    	$max = (round(($data+100)/100))*100;
888
+        		    } else {
889
+        		    	$max = 500;
890
+        		    }
830 891
         	?>
831 892
         	<div id="msg-<?php print str_replace(' ','_',strtolower($eachmsg['source_name'])); ?>" class="col-md-4"></div>
832 893
         	<script>
Please login to merge, or discard this patch.
search.php 1 patch
Braces   +128 added lines, -35 removed lines patch added patch discarded remove patch
@@ -30,8 +30,12 @@  discard block
 block discarded – undo
30 30
 		//$end_date = date("Y-m-d H:i:s", strtotime("2014-04-12")).",".$_GET['end_date']." 00:00:00";
31 31
 		$end_date = date("Y-m-d H:i:s", strtotime("2014-04-12")).",".date("Y-m-d",strtotime($_GET['end_date']))." 00:00:00";
32 32
 		$sql_date = $end_date;
33
-	} else $sql_date = '';
34
-} else $sql_date = '';
33
+	} else {
34
+		$sql_date = '';
35
+	}
36
+	} else {
37
+	$sql_date = '';
38
+}
35 39
 
36 40
 if (isset($_GET['highest_altitude'])) {
37 41
 	//for altitude manipulation
@@ -45,8 +49,12 @@  discard block
 block discarded – undo
45 49
 	} else if($_GET['highest_altitude'] == "" && $_GET['lowest_altitude'] != ""){
46 50
 		$start_altitude = filter_input(INPUT_GET,'lowest_altitude',FILTER_SANITIZE_NUMBER_INT).",60000";
47 51
 		$sql_altitude = $start_altitude;
48
-	} else $sql_altitude = '';
49
-} else $sql_altitude = '';
52
+	} else {
53
+		$sql_altitude = '';
54
+	}
55
+	} else {
56
+	$sql_altitude = '';
57
+}
50 58
 
51 59
 //calculuation for the pagination
52 60
 if(!isset($_GET['limit']))
@@ -64,7 +72,7 @@  discard block
 block discarded – undo
64 72
 		$limit_end = filter_input(INPUT_GET,'number_results',FILTER_SANITIZE_NUMBER_INT);
65 73
 		$absolute_difference = filter_input(INPUT_GET,'number_results',FILTER_SANITIZE_NUMBER_INT);
66 74
 	}
67
-}  else {
75
+} else {
68 76
 	$limit_explode = explode(",", $_GET['limit']);
69 77
 	$limit_start = filter_var($limit_explode[0],FILTER_SANITIZE_NUMBER_INT);
70 78
 	$limit_end = filter_var($limit_explode[1],FILTER_SANITIZE_NUMBER_INT);
@@ -97,10 +105,15 @@  discard block
 block discarded – undo
97 105
 	$origlon = filter_input(INPUT_GET,'origlon',FILTER_SANITIZE_STRING);
98 106
 	$dist = filter_input(INPUT_GET,'dist',FILTER_SANITIZE_NUMBER_INT);
99 107
 	if ($dist != '') {
100
-		if (isset($globalDistanceUnit) && $globalDistanceUnit == 'mi') $dist = $dist*1.60934;
101
-		elseif (isset($globalDistanceUnit) && $globalDistanceUnit == 'nm') $dist = $dist*1.852;
108
+		if (isset($globalDistanceUnit) && $globalDistanceUnit == 'mi') {
109
+			$dist = $dist*1.60934;
110
+		} elseif (isset($globalDistanceUnit) && $globalDistanceUnit == 'nm') {
111
+			$dist = $dist*1.852;
112
+		}
113
+	}
114
+	if (!isset($sql_date)) {
115
+		$sql_date = '';
102 116
 	}
103
-	if (!isset($sql_date)) $sql_date = '';
104 117
 	if ($archive == 1) {
105 118
 		$SpotterArchive = new SpotterArchive();
106 119
 		$spotter_array = $SpotterArchive->searchSpotterData($q,$registration,$aircraft,strtolower(str_replace("-", " ", $manufacturer)),$highlights,$airline,$airline_country,$airline_type,$airport,$airport_country,$callsign,$departure_airport_route,$arrival_airport_route,$owner,$pilot_id,$pilot_name,$sql_altitude,$sql_date,$limit_start.",".$absolute_difference,$sort,'',$origlat,$origlon,$dist);
@@ -168,7 +181,10 @@  discard block
 block discarded – undo
168 181
 		if (isset($_GET['aircraft']) && $_GET['aircraft'] != ""){ print _("Aircraft:").' <span>'.$aircraft.'</span> '; }
169 182
 		if (isset($_GET['manufacturer']) && $_GET['manufacturer'] != ""){ print _("Manufacturer:").' <span>'.$manufacturer.'</span> '; }
170 183
 		if (isset($_GET['registration']) && $_GET['registration'] != ""){ print _("Registration:").' <span>'.$registration.'</span> '; }
171
-		if (isset($_GET['highlights'])) if ($_GET['highlights'] == "true"){ print _("Highlights:").' <span>'.$highlights.'</span> '; }
184
+		if (isset($_GET['highlights'])) {
185
+			if ($_GET['highlights'] == "true"){ print _("Highlights:").' <span>'.$highlights.'</span> ';
186
+		}
187
+		}
172 188
 		if (isset($_GET['airline']) && $_GET['airline'] != ""){ print _("Airline:").' <span>'.$airline.'</span> '; }
173 189
 		if (isset($_GET['airline_country']) && $_GET['airline_country'] != ""){ print _("Airline country:").' <span>'.$airline_country.'</span> '; }
174 190
 		if (isset($_GET['airline_type']) && $_GET['airline_type'] != ""){ print _("Airline type:").' <span>'.$airline_type.'</span> '; }
@@ -279,7 +295,10 @@  discard block
 block discarded – undo
279 295
 			<div class="form-group">
280 296
 				<label class="control-label col-sm-2"><?php echo _("Keywords"); ?></label>
281 297
 				<div class="col-sm-10">
282
-					<input type="text" class="form-control" id="q" name="q" value="<?php if (isset($_GET['q'])) print $q; ?>" size="10" placeholder="<?php echo _("Keywords"); ?>" />
298
+					<input type="text" class="form-control" id="q" name="q" value="<?php if (isset($_GET['q'])) {
299
+	print $q;
300
+}
301
+?>" size="10" placeholder="<?php echo _("Keywords"); ?>" />
283 302
 				</div>
284 303
 			</div>
285 304
 		</fieldset>
@@ -294,7 +313,10 @@  discard block
 block discarded – undo
294 313
 					    </select>
295 314
 					</div>
296 315
 				</div>
297
-				<script type="text/javascript">getSelect('manufacturer','<?php if(isset($_GET['manufacturer'])) print $manufacturer; ?>')</script>
316
+				<script type="text/javascript">getSelect('manufacturer','<?php if(isset($_GET['manufacturer'])) {
317
+	print $manufacturer;
318
+}
319
+?>')</script>
298 320
 				<div class="form-group">
299 321
 					<label class="control-label col-sm-2"><?php echo _("Type"); ?></label>
300 322
 						<div class="col-sm-10">
@@ -303,11 +325,17 @@  discard block
 block discarded – undo
303 325
 							</select>
304 326
 						</div>
305 327
 				</div>
306
-				<script type="text/javascript">getSelect('aircrafttypes','<?php if(isset($_GET['aircraft_icao'])) print $aircraft_icao; ?>');</script>
328
+				<script type="text/javascript">getSelect('aircrafttypes','<?php if(isset($_GET['aircraft_icao'])) {
329
+	print $aircraft_icao;
330
+}
331
+?>');</script>
307 332
 				<div class="form-group">
308 333
 					<label class="control-label col-sm-2"><?php echo _("Registration"); ?></label> 
309 334
 					<div class="col-sm-10">
310
-						<input type="text" class="form-control" name="registration" value="<?php if (isset($_GET['registration'])) print $registration; ?>" size="8" placeholder="<?php echo _("Registration"); ?>" />
335
+						<input type="text" class="form-control" name="registration" value="<?php if (isset($_GET['registration'])) {
336
+	print $registration;
337
+}
338
+?>" size="8" placeholder="<?php echo _("Registration"); ?>" />
311 339
 					</div>
312 340
 				</div>
313 341
 <?php
@@ -316,22 +344,31 @@  discard block
 block discarded – undo
316 344
 				<div class="form-group">
317 345
 					<label class="control-label col-sm-2"><?php echo _("Pilot id"); ?></label> 
318 346
 					<div class="col-sm-10">
319
-						<input type="text" class="form-control" name="pilot_id" value="<?php if (isset($_GET['pilot_id'])) print $pilot_id; ?>" size="15" placeholder="<?php echo _("Pilot id"); ?>" />
347
+						<input type="text" class="form-control" name="pilot_id" value="<?php if (isset($_GET['pilot_id'])) {
348
+	print $pilot_id;
349
+}
350
+?>" size="15" placeholder="<?php echo _("Pilot id"); ?>" />
320 351
 					</div>
321 352
 				</div>
322 353
 				<div class="form-group">
323 354
 					<label class="control-label col-sm-2"><?php echo _("Pilot name"); ?></label> 
324 355
 					<div class="col-sm-10">
325
-						<input type="text" class="form-control" name="pilot_name" value="<?php if (isset($_GET['pilot_name'])) print $pilot_name; ?>" size="15" placeholder="<?php echo _("Pilot nmae"); ?>" />
356
+						<input type="text" class="form-control" name="pilot_name" value="<?php if (isset($_GET['pilot_name'])) {
357
+	print $pilot_name;
358
+}
359
+?>" size="15" placeholder="<?php echo _("Pilot nmae"); ?>" />
326 360
 					</div>
327 361
 				</div>
328 362
 <?php
329
-}else {
363
+} else {
330 364
 ?>
331 365
 				<div class="form-group">
332 366
 					<label class="control-label col-sm-2"><?php echo _("Owner name"); ?></label> 
333 367
 					<div class="col-sm-10">
334
-						<input type="text" class="form-control" name="owner" value="<?php if (isset($_GET['owner'])) print $owner; ?>" size="15" placeholder="<?php echo _("Owner name"); ?>" />
368
+						<input type="text" class="form-control" name="owner" value="<?php if (isset($_GET['owner'])) {
369
+	print $owner;
370
+}
371
+?>" size="15" placeholder="<?php echo _("Owner name"); ?>" />
335 372
 					</div>
336 373
 				</div>
337 374
 <?php
@@ -339,8 +376,14 @@  discard block
 block discarded – undo
339 376
 ?>
340 377
 				<div class="form-group">
341 378
 					<div class="col-sm-offset-2 col-sm-10">
342
-					<!--<div><input type="checkbox" class="form-control" name="highlights" value="true" id="highlights" <?php if (isset($_GET['highlights'])) if ($_GET['highlights'] == "true"){ print 'checked="checked"'; } ?>> <label for="highlights"><?php echo _("Include only aircrafts with special highlights (unique liveries, destinations etc.)"); ?></label></div>-->
343
-					<label class="checkbox-inline"><input type="checkbox" name="highlights" value="true" id="highlights" <?php if (isset($_GET['highlights'])) if ($_GET['highlights'] == "true"){ print 'checked="checked"'; } ?>> <?php echo _("Include only aircrafts with special highlights (unique liveries, destinations etc.)"); ?></label>
379
+					<!--<div><input type="checkbox" class="form-control" name="highlights" value="true" id="highlights" <?php if (isset($_GET['highlights'])) {
380
+	if ($_GET['highlights'] == "true"){ print 'checked="checked"';
381
+}
382
+} ?>> <label for="highlights"><?php echo _("Include only aircrafts with special highlights (unique liveries, destinations etc.)"); ?></label></div>-->
383
+					<label class="checkbox-inline"><input type="checkbox" name="highlights" value="true" id="highlights" <?php if (isset($_GET['highlights'])) {
384
+	if ($_GET['highlights'] == "true"){ print 'checked="checked"';
385
+}
386
+} ?>> <?php echo _("Include only aircrafts with special highlights (unique liveries, destinations etc.)"); ?></label>
344 387
 					</div>
345 388
 				</div>
346 389
 			</fieldset>
@@ -354,7 +397,10 @@  discard block
 block discarded – undo
354 397
 						</select>
355 398
 					</div>
356 399
 				</div>
357
-				<script type="text/javascript">getSelect('airlinenames','<?php if(isset($_GET['airline'])) print $airline; ?>');</script>
400
+				<script type="text/javascript">getSelect('airlinenames','<?php if(isset($_GET['airline'])) {
401
+	print $airline;
402
+}
403
+?>');</script>
358 404
 				<div class="form-group">
359 405
 					<label class="control-label col-sm-2"><?php echo _("Country"); ?></label> 
360 406
 					<div class="col-sm-10">
@@ -363,19 +409,34 @@  discard block
 block discarded – undo
363 409
 						</select>
364 410
 					</div>
365 411
 				</div>
366
-				<script type="text/javascript">getSelect('airlinecountries','<?php if(isset($_GET['airline_country'])) print $airline_country; ?>');</script>
412
+				<script type="text/javascript">getSelect('airlinecountries','<?php if(isset($_GET['airline_country'])) {
413
+	print $airline_country;
414
+}
415
+?>');</script>
367 416
 				<div class="form-group">
368 417
 					<label class="control-label col-sm-2"><?php echo _("Callsign"); ?></label> 
369 418
 					<div class="col-sm-10">
370
-						<input type="text" name="callsign" class="form-control" value="<?php if (isset($_GET['callsign'])) print $callsign; ?>" size="8" placeholder="<?php echo _("Callsign"); ?>" />
419
+						<input type="text" name="callsign" class="form-control" value="<?php if (isset($_GET['callsign'])) {
420
+	print $callsign;
421
+}
422
+?>" size="8" placeholder="<?php echo _("Callsign"); ?>" />
371 423
 					</div>
372 424
 				</div>
373 425
 				<div class="form-group">
374 426
 					<div class="col-sm-offset-2 col-sm-10">
375 427
 						<label class="radio-inline"><input type="radio" name="airline_type" value="all" id="airline_type_all" <?php if (!isset($_GET['airline_type']) || $_GET['airline_type'] == "all"){ print 'checked="checked"'; } ?>> <?php echo _("All airlines types"); ?></label>
376
-						<label class="radio-inline"><input type="radio" name="airline_type" value="passenger" id="airline_type_passenger" <?php if (isset($_GET['airline_type'])) if ($_GET['airline_type'] == "passenger"){ print 'checked="checked"'; } ?>> <?php echo _("Only Passenger airlines"); ?></label>
377
-						<label class="radio-inline"><input type="radio" name="airline_type" value="cargo" id="airline_type_cargo" <?php if (isset($_GET['airline_type'])) if ( $_GET['airline_type'] == "cargo"){ print 'checked="checked"'; } ?>> <?php echo _("Only Cargo airlines"); ?></label>
378
-						<label class="radio-inline"><input type="radio" name="airline_type" value="military" id="airline_type_military" <?php if (isset($_GET['airline_type'])) if ( $_GET['airline_type'] == "military"){ print 'checked="checked"'; } ?>> <?php echo _("Only Military airlines"); ?></label>
428
+						<label class="radio-inline"><input type="radio" name="airline_type" value="passenger" id="airline_type_passenger" <?php if (isset($_GET['airline_type'])) {
429
+	if ($_GET['airline_type'] == "passenger"){ print 'checked="checked"';
430
+}
431
+} ?>> <?php echo _("Only Passenger airlines"); ?></label>
432
+						<label class="radio-inline"><input type="radio" name="airline_type" value="cargo" id="airline_type_cargo" <?php if (isset($_GET['airline_type'])) {
433
+	if ( $_GET['airline_type'] == "cargo"){ print 'checked="checked"';
434
+}
435
+} ?>> <?php echo _("Only Cargo airlines"); ?></label>
436
+						<label class="radio-inline"><input type="radio" name="airline_type" value="military" id="airline_type_military" <?php if (isset($_GET['airline_type'])) {
437
+	if ( $_GET['airline_type'] == "military"){ print 'checked="checked"';
438
+}
439
+} ?>> <?php echo _("Only Military airlines"); ?></label>
379 440
 					</div>
380 441
 				</div>
381 442
 			</fieldset>
@@ -389,7 +450,10 @@  discard block
 block discarded – undo
389 450
 						</select>
390 451
 					</div>
391 452
 				</div>
392
-				<script type="text/javascript">getSelect('airportnames','<?php if(isset($_GET['airport_icao'])) print $airport_icao; ?>');</script>
453
+				<script type="text/javascript">getSelect('airportnames','<?php if(isset($_GET['airport_icao'])) {
454
+	print $airport_icao;
455
+}
456
+?>');</script>
393 457
 				<div class="form-group">
394 458
 					<label class="control-label col-sm-2"><?php echo _("Country"); ?></label> 
395 459
 					<div class="col-sm-10">
@@ -398,7 +462,10 @@  discard block
 block discarded – undo
398 462
 						</select>
399 463
 					</div>
400 464
 				</div>
401
-				<script type="text/javascript">getSelect('airportcountries','<?php if(isset($_GET['airport_country'])) print $airport_country; ?>');</script>
465
+				<script type="text/javascript">getSelect('airportcountries','<?php if(isset($_GET['airport_country'])) {
466
+	print $airport_country;
467
+}
468
+?>');</script>
402 469
 			</fieldset>
403 470
 			<fieldset>
404 471
 				<legend><?php echo _("Route"); ?></legend>
@@ -410,7 +477,10 @@  discard block
 block discarded – undo
410 477
 						</select>
411 478
 					</div>
412 479
 				</div>
413
-				<script type="text/javascript">getSelect('departureairportnames','<?php if(isset($_GET['departure_airport_route'])) print $departure_airport_route; ?>');</script>
480
+				<script type="text/javascript">getSelect('departureairportnames','<?php if(isset($_GET['departure_airport_route'])) {
481
+	print $departure_airport_route;
482
+}
483
+?>');</script>
414 484
 				<div class="form-group">
415 485
 					<label class="control-label col-sm-2"><?php echo _("Arrival Airport"); ?></label> 
416 486
 					<div class="col-sm-10">
@@ -419,7 +489,10 @@  discard block
 block discarded – undo
419 489
 						</select>
420 490
 					</div>
421 491
 				</div>
422
-				<script type="text/javascript">getSelect('arrivalairportnames','<?php if(isset($_GET['arrival_airport_route'])) print $arrival_airport_route; ?>');</script>
492
+				<script type="text/javascript">getSelect('arrivalairportnames','<?php if(isset($_GET['arrival_airport_route'])) {
493
+	print $arrival_airport_route;
494
+}
495
+?>');</script>
423 496
 			</fieldset>
424 497
 			<fieldset>
425 498
 				<legend><?php echo _("Date"); ?></legend>
@@ -427,7 +500,10 @@  discard block
 block discarded – undo
427 500
 					<label class="control-label col-sm-2"><?php echo _("Start Date"); ?></label>
428 501
 					<div class="col-sm-10">
429 502
 						<div class='input-group date' id='datetimepicker1'>
430
-							<input type='text' name="start_date" class="form-control" value="<?php if (isset($_GET['start_date'])) print $start_date; ?>" placeholder="<?php echo _("Start Date/Time"); ?>" />
503
+							<input type='text' name="start_date" class="form-control" value="<?php if (isset($_GET['start_date'])) {
504
+	print $start_date;
505
+}
506
+?>" placeholder="<?php echo _("Start Date/Time"); ?>" />
431 507
 							<span class="input-group-addon">
432 508
 								<span class="glyphicon glyphicon-calendar"></span>
433 509
 							</span>
@@ -438,7 +514,10 @@  discard block
 block discarded – undo
438 514
 					<label class="control-label col-sm-2"><?php echo _("End Date"); ?></label>
439 515
 					<div class="col-sm-10">
440 516
 						<div class='input-group date' id='datetimepicker2'>
441
-						<input type='text' name="end_date" class="form-control" value="<?php if (isset($_GET['end_date'])) print $end_date; ?>" placeholder="<?php echo _("End Date/Time"); ?>" />
517
+						<input type='text' name="end_date" class="form-control" value="<?php if (isset($_GET['end_date'])) {
518
+	print $end_date;
519
+}
520
+?>" placeholder="<?php echo _("End Date/Time"); ?>" />
442 521
 						<span class="input-group-addon">
443 522
 							<span class="glyphicon glyphicon-calendar"></span>
444 523
 						</span>
@@ -511,19 +590,33 @@  discard block
 block discarded – undo
511 590
 			<div class="form-group">
512 591
 				<label class="control-label col-sm-2"><?php echo _("Latitude"); ?></label>
513 592
 				<div class="col-sm-10">
514
-					<input type="text" name="origlat" class="form-control" placeholder="<?php echo _("Center point latitude"); ?>" value="<?php if (isset($_GET['origlat'])) print $origlat; ?>" />
593
+					<input type="text" name="origlat" class="form-control" placeholder="<?php echo _("Center point latitude"); ?>" value="<?php if (isset($_GET['origlat'])) {
594
+	print $origlat;
595
+}
596
+?>" />
515 597
 				</div>
516 598
 			</div>
517 599
 			<div class="form-group">
518 600
 				<label class="control-label col-sm-2"><?php echo _("Longitude"); ?></label>
519 601
 				<div class="col-sm-10">
520
-					<input type="text" name="origlon" class="form-control" placeholder="<?php echo _("Center point longitude"); ?>" value="<?php if (isset($_GET['origlon'])) print $origlon; ?>" />
602
+					<input type="text" name="origlon" class="form-control" placeholder="<?php echo _("Center point longitude"); ?>" value="<?php if (isset($_GET['origlon'])) {
603
+	print $origlon;
604
+}
605
+?>" />
521 606
 				</div>
522 607
 			</div>
523 608
 			<div class="form-group">
524
-				<label class="control-label col-sm-2"><?php echo _("Distance").' ('; if (isset($globalDistanceUnit)) print $globalDistanceUnit; else print 'km'; print ')'; ?></label>
609
+				<label class="control-label col-sm-2"><?php echo _("Distance").' ('; if (isset($globalDistanceUnit)) {
610
+	print $globalDistanceUnit;
611
+} else {
612
+	print 'km';
613
+}
614
+print ')'; ?></label>
525 615
 				<div class="col-sm-10">
526
-					<input type="text" name="dist" class="form-control" placeholder="<?php echo _("Distance from center point"); ?>" value="<?php if (isset($_GET['distance'])) print $distance; ?>" />
616
+					<input type="text" name="dist" class="form-control" placeholder="<?php echo _("Distance from center point"); ?>" value="<?php if (isset($_GET['distance'])) {
617
+	print $distance;
618
+}
619
+?>" />
527 620
 				</div>
528 621
 			</div>
529 622
 		</fieldset>
Please login to merge, or discard this patch.
route-statistics-manufacturer.php 1 patch
Braces   +3 added lines, -1 removed lines patch added patch discarded remove patch
@@ -14,7 +14,9 @@
 block discarded – undo
14 14
 $arrival_airport = filter_input(INPUT_GET,'arrival_airport',FILTER_SANITIZE_STRING);
15 15
 if (isset($_GET['departure_airport']) && isset($_GET['arrival_airport'])) {
16 16
 	$spotter_array = $Spotter->getSpotterDataByRoute($departure_airport, $arrival_airport, "0,1", $sort);
17
-} else $spotter_array = array();  
17
+} else {
18
+	$spotter_array = array();
19
+}
18 20
 
19 21
 if (!empty($spotter_array))
20 22
 {
Please login to merge, or discard this patch.
pilot-sub-menu.php 1 patch
Braces   +70 added lines, -10 removed lines patch added patch discarded remove patch
@@ -3,15 +3,39 @@  discard block
 block discarded – undo
3 3
 </span>
4 4
 <div class="sub-menu sub-menu-container">
5 5
 	<ul class="nav nav-pills">
6
-		<li><a href="<?php print $globalURL; ?>/pilot/<?php print $pilot; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>" <?php if (strtolower($current_page) == "pilot-detailed"){ print 'class="active"'; } ?>><?php echo _("Detailed"); ?></a></li>
6
+		<li><a href="<?php print $globalURL; ?>/pilot/<?php print $pilot; ?><?php if (isset($year) && $year != '') {
7
+	echo '/'.$year;
8
+}
9
+?><?php if (isset($month) && $month != '') {
10
+	echo '/'.$month;
11
+}
12
+?>" <?php if (strtolower($current_page) == "pilot-detailed"){ print 'class="active"'; } ?>><?php echo _("Detailed"); ?></a></li>
7 13
 		<li class="dropdown">
8 14
 		    <a class="dropdown-toggle <?php if(strtolower($current_page) == "pilot-statistics-aircraft" || strtolower($current_page) == "pilot-statistics-registration" || strtolower($current_page) == "pilot-statistics-manufacturer"){ print 'active'; } ?>" data-toggle="dropdown" href="#">
9 15
 		      <?php echo _("Aircraft"); ?> <span class="caret"></span>
10 16
 		    </a>
11 17
 		    <ul class="dropdown-menu" role="menu">
12
-		      <li><a href="<?php print $globalURL; ?>/pilot/statistics/aircraft/<?php print $pilot; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>"><?php echo _("Aircraft Type"); ?></a></li>
13
-					<li><a href="<?php print $globalURL; ?>/pilot/statistics/registration/<?php print $pilot; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>"><?php echo _("Registration"); ?></a></li>
14
-					<li><a href="<?php print $globalURL; ?>/pilot/statistics/manufacturer/<?php print $pilot; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>"><?php echo _("Manufacturer"); ?></a></li>
18
+		      <li><a href="<?php print $globalURL; ?>/pilot/statistics/aircraft/<?php print $pilot; ?><?php if (isset($year) && $year != '') {
19
+	echo '/'.$year;
20
+}
21
+?><?php if (isset($month) && $month != '') {
22
+	echo '/'.$month;
23
+}
24
+?>"><?php echo _("Aircraft Type"); ?></a></li>
25
+					<li><a href="<?php print $globalURL; ?>/pilot/statistics/registration/<?php print $pilot; ?><?php if (isset($year) && $year != '') {
26
+	echo '/'.$year;
27
+}
28
+?><?php if (isset($month) && $month != '') {
29
+	echo '/'.$month;
30
+}
31
+?>"><?php echo _("Registration"); ?></a></li>
32
+					<li><a href="<?php print $globalURL; ?>/pilot/statistics/manufacturer/<?php print $pilot; ?><?php if (isset($year) && $year != '') {
33
+	echo '/'.$year;
34
+}
35
+?><?php if (isset($month) && $month != '') {
36
+	echo '/'.$month;
37
+}
38
+?>"><?php echo _("Manufacturer"); ?></a></li>
15 39
 		    </ul>
16 40
 		</li>
17 41
 		<li class="dropdown">
@@ -19,13 +43,49 @@  discard block
 block discarded – undo
19 43
 		      <?php echo _("Airport"); ?> <span class="caret"></span>
20 44
 		    </a>
21 45
 		    <ul class="dropdown-menu" role="menu">
22
-		      <li><a href="<?php print $globalURL; ?>/pilot/statistics/departure-airport/<?php print $pilot; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>"><?php echo _("Departure Airport"); ?></a></li>
23
-		      <li><a href="<?php print $globalURL; ?>/pilot/statistics/departure-airport-country/<?php print $pilot; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>"><?php echo _("Departure Airport by Country"); ?></a></li>
24
-			  <li><a href="<?php print $globalURL; ?>/pilot/statistics/arrival-airport/<?php print $pilot; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>"><?php echo _("Arrival Airport"); ?></a></li>
25
-			  <li><a href="<?php print $globalURL; ?>/pilot/statistics/arrival-airport-country/<?php print $pilot; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>"><?php echo _("Arrival Airport by Country"); ?></a></li>
46
+		      <li><a href="<?php print $globalURL; ?>/pilot/statistics/departure-airport/<?php print $pilot; ?><?php if (isset($year) && $year != '') {
47
+	echo '/'.$year;
48
+}
49
+?><?php if (isset($month) && $month != '') {
50
+	echo '/'.$month;
51
+}
52
+?>"><?php echo _("Departure Airport"); ?></a></li>
53
+		      <li><a href="<?php print $globalURL; ?>/pilot/statistics/departure-airport-country/<?php print $pilot; ?><?php if (isset($year) && $year != '') {
54
+	echo '/'.$year;
55
+}
56
+?><?php if (isset($month) && $month != '') {
57
+	echo '/'.$month;
58
+}
59
+?>"><?php echo _("Departure Airport by Country"); ?></a></li>
60
+			  <li><a href="<?php print $globalURL; ?>/pilot/statistics/arrival-airport/<?php print $pilot; ?><?php if (isset($year) && $year != '') {
61
+	echo '/'.$year;
62
+}
63
+?><?php if (isset($month) && $month != '') {
64
+	echo '/'.$month;
65
+}
66
+?>"><?php echo _("Arrival Airport"); ?></a></li>
67
+			  <li><a href="<?php print $globalURL; ?>/pilot/statistics/arrival-airport-country/<?php print $pilot; ?><?php if (isset($year) && $year != '') {
68
+	echo '/'.$year;
69
+}
70
+?><?php if (isset($month) && $month != '') {
71
+	echo '/'.$month;
72
+}
73
+?>"><?php echo _("Arrival Airport by Country"); ?></a></li>
26 74
 		    </ul>
27 75
 		</li>
28
-		<li><a href="<?php print $globalURL; ?>/pilot/statistics/route/<?php print $pilot; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>" <?php if (strtolower($current_page) == "pilot-statistics-route"){ print 'class="active"'; } ?>><?php echo _("Route"); ?></a></li>
29
-		<li><a href="<?php print $globalURL; ?>/pilot/statistics/time/<?php print $pilot; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>" <?php if (strtolower($current_page) == "pilot-statistics-time"){ print 'class="active"'; } ?>><?php echo _("Time"); ?></a></li>
76
+		<li><a href="<?php print $globalURL; ?>/pilot/statistics/route/<?php print $pilot; ?><?php if (isset($year) && $year != '') {
77
+	echo '/'.$year;
78
+}
79
+?><?php if (isset($month) && $month != '') {
80
+	echo '/'.$month;
81
+}
82
+?>" <?php if (strtolower($current_page) == "pilot-statistics-route"){ print 'class="active"'; } ?>><?php echo _("Route"); ?></a></li>
83
+		<li><a href="<?php print $globalURL; ?>/pilot/statistics/time/<?php print $pilot; ?><?php if (isset($year) && $year != '') {
84
+	echo '/'.$year;
85
+}
86
+?><?php if (isset($month) && $month != '') {
87
+	echo '/'.$month;
88
+}
89
+?>" <?php if (strtolower($current_page) == "pilot-statistics-time"){ print 'class="active"'; } ?>><?php echo _("Time"); ?></a></li>
30 90
 	</ul>
31 91
 </div>
32 92
\ No newline at end of file
Please login to merge, or discard this patch.
route-statistics-registration.php 1 patch
Braces   +3 added lines, -1 removed lines patch added patch discarded remove patch
@@ -14,7 +14,9 @@
 block discarded – undo
14 14
 $arrival_airport = filter_input(INPUT_GET,'arrival_airport',FILTER_SANITIZE_STRING);
15 15
 if (isset($_GET['departure_airport']) && isset($_GET['arrival_airport'])) {
16 16
 	$spotter_array = $Spotter->getSpotterDataByRoute($departure_airport, $arrival_airport, "0,1", $sort);
17
-} else $spotter_array = array();
17
+} else {
18
+	$spotter_array = array();
19
+}
18 20
   
19 21
 if (!empty($spotter_array))
20 22
 {
Please login to merge, or discard this patch.
owner-sub-menu.php 1 patch
Braces   +77 added lines, -11 removed lines patch added patch discarded remove patch
@@ -3,20 +3,50 @@  discard block
 block discarded – undo
3 3
 </span>
4 4
 <div class="stats_airline">
5 5
 	<form id="changedate" method="post">
6
-		<input type="month" name="date" onchange="statsdatechange(this);" value="<?php if (isset($year) && $year != '') echo $year.'-'; ?><?php if (isset($month) && $month != '') echo $month; ?>" />
6
+		<input type="month" name="date" onchange="statsdatechange(this);" value="<?php if (isset($year) && $year != '') {
7
+	echo $year.'-';
8
+}
9
+?><?php if (isset($month) && $month != '') {
10
+	echo $month;
11
+}
12
+?>" />
7 13
 	</form>
8 14
 </div>
9 15
 <div class="sub-menu sub-menu-container">
10 16
 	<ul class="nav nav-pills">
11
-		<li><a href="<?php print $globalURL; ?>/owner/<?php print $owner; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>" <?php if (strtolower($current_page) == "owner-detailed"){ print 'class="active"'; } ?>><?php echo _("Detailed"); ?></a></li>
17
+		<li><a href="<?php print $globalURL; ?>/owner/<?php print $owner; ?><?php if (isset($year) && $year != '') {
18
+	echo '/'.$year;
19
+}
20
+?><?php if (isset($month) && $month != '') {
21
+	echo '/'.$month;
22
+}
23
+?>" <?php if (strtolower($current_page) == "owner-detailed"){ print 'class="active"'; } ?>><?php echo _("Detailed"); ?></a></li>
12 24
 		<li class="dropdown">
13 25
 		    <a class="dropdown-toggle <?php if(strtolower($current_page) == "owner-statistics-aircraft" || strtolower($current_page) == "owner-statistics-registration" || strtolower($current_page) == "owner-statistics-manufacturer"){ print 'active'; } ?>" data-toggle="dropdown" href="#">
14 26
 		      <?php echo _("Aircraft"); ?> <span class="caret"></span>
15 27
 		    </a>
16 28
 		    <ul class="dropdown-menu" role="menu">
17
-		      <li><a href="<?php print $globalURL; ?>/owner/statistics/aircraft/<?php print $owner; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>"><?php echo _("Aircraft Type"); ?></a></li>
18
-					<li><a href="<?php print $globalURL; ?>/owner/statistics/registration/<?php print $owner; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>"><?php echo _("Registration"); ?></a></li>
19
-					<li><a href="<?php print $globalURL; ?>/owner/statistics/manufacturer/<?php print $owner; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>"><?php echo _("Manufacturer"); ?></a></li>
29
+		      <li><a href="<?php print $globalURL; ?>/owner/statistics/aircraft/<?php print $owner; ?><?php if (isset($year) && $year != '') {
30
+	echo '/'.$year;
31
+}
32
+?><?php if (isset($month) && $month != '') {
33
+	echo '/'.$month;
34
+}
35
+?>"><?php echo _("Aircraft Type"); ?></a></li>
36
+					<li><a href="<?php print $globalURL; ?>/owner/statistics/registration/<?php print $owner; ?><?php if (isset($year) && $year != '') {
37
+	echo '/'.$year;
38
+}
39
+?><?php if (isset($month) && $month != '') {
40
+	echo '/'.$month;
41
+}
42
+?>"><?php echo _("Registration"); ?></a></li>
43
+					<li><a href="<?php print $globalURL; ?>/owner/statistics/manufacturer/<?php print $owner; ?><?php if (isset($year) && $year != '') {
44
+	echo '/'.$year;
45
+}
46
+?><?php if (isset($month) && $month != '') {
47
+	echo '/'.$month;
48
+}
49
+?>"><?php echo _("Manufacturer"); ?></a></li>
20 50
 		    </ul>
21 51
 		</li>
22 52
 		<li class="dropdown">
@@ -24,13 +54,49 @@  discard block
 block discarded – undo
24 54
 		      <?php echo _("Airport"); ?> <span class="caret"></span>
25 55
 		    </a>
26 56
 		    <ul class="dropdown-menu" role="menu">
27
-		      <li><a href="<?php print $globalURL; ?>/owner/statistics/departure-airport/<?php print $owner; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>"><?php echo _("Departure Airport"); ?></a></li>
28
-		      <li><a href="<?php print $globalURL; ?>/owner/statistics/departure-airport-country/<?php print $owner; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>"><?php echo _("Departure Airport by Country"); ?></a></li>
29
-			  <li><a href="<?php print $globalURL; ?>/owner/statistics/arrival-airport/<?php print $owner; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>"><?php echo _("Arrival Airport"); ?></a></li>
30
-			  <li><a href="<?php print $globalURL; ?>/owner/statistics/arrival-airport-country/<?php print $owner; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>"><?php echo _("Arrival Airport by Country"); ?></a></li>
57
+		      <li><a href="<?php print $globalURL; ?>/owner/statistics/departure-airport/<?php print $owner; ?><?php if (isset($year) && $year != '') {
58
+	echo '/'.$year;
59
+}
60
+?><?php if (isset($month) && $month != '') {
61
+	echo '/'.$month;
62
+}
63
+?>"><?php echo _("Departure Airport"); ?></a></li>
64
+		      <li><a href="<?php print $globalURL; ?>/owner/statistics/departure-airport-country/<?php print $owner; ?><?php if (isset($year) && $year != '') {
65
+	echo '/'.$year;
66
+}
67
+?><?php if (isset($month) && $month != '') {
68
+	echo '/'.$month;
69
+}
70
+?>"><?php echo _("Departure Airport by Country"); ?></a></li>
71
+			  <li><a href="<?php print $globalURL; ?>/owner/statistics/arrival-airport/<?php print $owner; ?><?php if (isset($year) && $year != '') {
72
+	echo '/'.$year;
73
+}
74
+?><?php if (isset($month) && $month != '') {
75
+	echo '/'.$month;
76
+}
77
+?>"><?php echo _("Arrival Airport"); ?></a></li>
78
+			  <li><a href="<?php print $globalURL; ?>/owner/statistics/arrival-airport-country/<?php print $owner; ?><?php if (isset($year) && $year != '') {
79
+	echo '/'.$year;
80
+}
81
+?><?php if (isset($month) && $month != '') {
82
+	echo '/'.$month;
83
+}
84
+?>"><?php echo _("Arrival Airport by Country"); ?></a></li>
31 85
 		    </ul>
32 86
 		</li>
33
-		<li><a href="<?php print $globalURL; ?>/owner/statistics/route/<?php print $owner; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>" <?php if (strtolower($current_page) == "owner-statistics-route"){ print 'class="active"'; } ?>><?php echo _("Route"); ?></a></li>
34
-		<li><a href="<?php print $globalURL; ?>/owner/statistics/time/<?php print $owner; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>" <?php if (strtolower($current_page) == "owner-statistics-time"){ print 'class="active"'; } ?>><?php echo _("Time"); ?></a></li>
87
+		<li><a href="<?php print $globalURL; ?>/owner/statistics/route/<?php print $owner; ?><?php if (isset($year) && $year != '') {
88
+	echo '/'.$year;
89
+}
90
+?><?php if (isset($month) && $month != '') {
91
+	echo '/'.$month;
92
+}
93
+?>" <?php if (strtolower($current_page) == "owner-statistics-route"){ print 'class="active"'; } ?>><?php echo _("Route"); ?></a></li>
94
+		<li><a href="<?php print $globalURL; ?>/owner/statistics/time/<?php print $owner; ?><?php if (isset($year) && $year != '') {
95
+	echo '/'.$year;
96
+}
97
+?><?php if (isset($month) && $month != '') {
98
+	echo '/'.$month;
99
+}
100
+?>" <?php if (strtolower($current_page) == "owner-statistics-time"){ print 'class="active"'; } ?>><?php echo _("Time"); ?></a></li>
35 101
 	</ul>
36 102
 </div>
37 103
\ No newline at end of file
Please login to merge, or discard this patch.
route-statistics-time.php 1 patch
Braces   +3 added lines, -1 removed lines patch added patch discarded remove patch
@@ -14,7 +14,9 @@
 block discarded – undo
14 14
 $arrival_airport = filter_input(INPUT_GET,'arrival_airport',FILTER_SANITIZE_STRING);
15 15
 if (isset($_GET['departure_airport']) && isset($_GET['arrival_airport'])) {
16 16
 	$spotter_array = $Spotter->getSpotterDataByRoute($departure_airport, $arrival_airport, "0,1", $sort);
17
-} else $spotter_array = array();
17
+} else {
18
+	$spotter_array = array();
19
+}
18 20
   
19 21
 if (!empty($spotter_array))
20 22
 {
Please login to merge, or discard this patch.
route-statistics-airline.php 1 patch
Braces   +3 added lines, -1 removed lines patch added patch discarded remove patch
@@ -14,7 +14,9 @@
 block discarded – undo
14 14
 $arrival_airport = filter_input(INPUT_GET,'arrival_airport',FILTER_SANITIZE_STRING);
15 15
 if (isset($_GET['departure_airport']) && isset($_GET['arrival_airport'])) {
16 16
 	$spotter_array = $Spotter->getSpotterDataByRoute($departure_airport, $arrival_airport, "0,1", $sort);
17
-} else $spotter_array = array();
17
+} else {
18
+	$spotter_array = array();
19
+}
18 20
   
19 21
 if (!empty($spotter_array))
20 22
 {
Please login to merge, or discard this patch.
require/class.Stats.php 1 patch
Braces   +482 added lines, -167 removed lines patch added patch discarded remove patch
@@ -13,7 +13,9 @@  discard block
 block discarded – undo
13 13
 	
14 14
 	public function __construct($dbc = null) {
15 15
 		global $globalFilterName;
16
-		if (isset($globalFilterName)) $this->filter_name = $globalFilterName;
16
+		if (isset($globalFilterName)) {
17
+			$this->filter_name = $globalFilterName;
18
+		}
17 19
 		$Connection = new Connection($dbc);
18 20
 		$this->db = $Connection->db();
19 21
         }
@@ -81,7 +83,9 @@  discard block
 block discarded – undo
81 83
                 }
82 84
         }
83 85
 	public function getAllAirlineNames($filter_name = '') {
84
-		if ($filter_name == '') $filter_name = $this->filter_name;
86
+		if ($filter_name == '') {
87
+			$filter_name = $this->filter_name;
88
+		}
85 89
                 $query = "SELECT * FROM stats_airline WHERE filter_name = :filter_name ORDER BY airline_name ASC";
86 90
                  try {
87 91
                         $sth = $this->db->prepare($query);
@@ -93,7 +97,9 @@  discard block
 block discarded – undo
93 97
                 return $all;
94 98
         }
95 99
 	public function getAllAircraftTypes($stats_airline = '',$filter_name = '') {
96
-		if ($filter_name == '') $filter_name = $this->filter_name;
100
+		if ($filter_name == '') {
101
+			$filter_name = $this->filter_name;
102
+		}
97 103
                 $query = "SELECT * FROM stats_aircraft WHERE stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY aircraft_manufacturer ASC";
98 104
                  try {
99 105
                         $sth = $this->db->prepare($query);
@@ -105,7 +111,9 @@  discard block
 block discarded – undo
105 111
                 return $all;
106 112
         }
107 113
 	public function getAllManufacturers($stats_airline = '',$filter_name = '') {
108
-		if ($filter_name == '') $filter_name = $this->filter_name;
114
+		if ($filter_name == '') {
115
+			$filter_name = $this->filter_name;
116
+		}
109 117
                 $query = "SELECT DISTINCT(aircraft_manufacturer) FROM stats_aircraft WHERE stats_airline = :stats_airline AND filter_name = :filter_name AND aircraft_manufacturer <> '' ORDER BY aircraft_manufacturer ASC";
110 118
                  try {
111 119
                         $sth = $this->db->prepare($query);
@@ -117,7 +125,9 @@  discard block
 block discarded – undo
117 125
                 return $all;
118 126
         }
119 127
 	public function getAllAirportNames($stats_airline = '',$filter_name = '') {
120
-		if ($filter_name == '') $filter_name = $this->filter_name;
128
+		if ($filter_name == '') {
129
+			$filter_name = $this->filter_name;
130
+		}
121 131
                 $query = "SELECT airport_icao, airport_name,airport_city,airport_country FROM stats_airport WHERE stats_airline = :stats_airline AND filter_name = :filter_name AND stats_type = 'daily' GROUP BY airport_icao,airport_name,airport_city,airport_country ORDER BY airport_city ASC";
122 132
                  try {
123 133
                         $sth = $this->db->prepare($query);
@@ -130,7 +140,9 @@  discard block
 block discarded – undo
130 140
         }
131 141
 
132 142
 	public function getAllOwnerNames($stats_airline = '',$filter_name = '') {
133
-		if ($filter_name == '') $filter_name = $this->filter_name;
143
+		if ($filter_name == '') {
144
+			$filter_name = $this->filter_name;
145
+		}
134 146
                 $query = "SELECT owner_name FROM stats_owner WHERE stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY owner_name ASC";
135 147
                  try {
136 148
                         $sth = $this->db->prepare($query);
@@ -143,7 +155,9 @@  discard block
 block discarded – undo
143 155
         }
144 156
 
145 157
 	public function getAllPilotNames($stats_airline = '',$filter_name = '') {
146
-		if ($filter_name == '') $filter_name = $this->filter_name;
158
+		if ($filter_name == '') {
159
+			$filter_name = $this->filter_name;
160
+		}
147 161
                 $query = "SELECT pilot_id,pilot_name FROM stats_pilot WHERE stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY pilot_name ASC";
148 162
                  try {
149 163
                         $sth = $this->db->prepare($query);
@@ -158,10 +172,15 @@  discard block
 block discarded – undo
158 172
 
159 173
 	public function countAllAircraftTypes($limit = true, $stats_airline = '', $filter_name = '',$year = '', $month = '') {
160 174
 		global $globalStatsFilters;
161
-		if ($filter_name == '') $filter_name = $this->filter_name;
175
+		if ($filter_name == '') {
176
+			$filter_name = $this->filter_name;
177
+		}
162 178
 		if ($year == '' && $month == '') {
163
-			if ($limit) $query = "SELECT aircraft_icao, cnt AS aircraft_icao_count, aircraft_name, aircraft_manufacturer FROM stats_aircraft WHERE aircraft_name <> '' AND aircraft_icao <> '' AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY aircraft_icao_count DESC LIMIT 10 OFFSET 0";
164
-			else $query = "SELECT aircraft_icao, cnt AS aircraft_icao_count, aircraft_name, aircraft_manufacturer FROM stats_aircraft WHERE aircraft_name <> '' AND aircraft_icao <> '' AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY aircraft_icao_count DESC";
179
+			if ($limit) {
180
+				$query = "SELECT aircraft_icao, cnt AS aircraft_icao_count, aircraft_name, aircraft_manufacturer FROM stats_aircraft WHERE aircraft_name <> '' AND aircraft_icao <> '' AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY aircraft_icao_count DESC LIMIT 10 OFFSET 0";
181
+			} else {
182
+				$query = "SELECT aircraft_icao, cnt AS aircraft_icao_count, aircraft_name, aircraft_manufacturer FROM stats_aircraft WHERE aircraft_name <> '' AND aircraft_icao <> '' AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY aircraft_icao_count DESC";
183
+			}
165 184
 			try {
166 185
 				$sth = $this->db->prepare($query);
167 186
 				$sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
@@ -169,7 +188,9 @@  discard block
 block discarded – undo
169 188
 				echo "error : ".$e->getMessage();
170 189
 			}
171 190
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
172
-		} else $all = array();
191
+		} else {
192
+			$all = array();
193
+		}
173 194
                 if (empty($all)) {
174 195
             	    $filters = array('airlines' => array($stats_airline),'year' => $year,'month' => $month);
175 196
             	    if ($filter_name != '') {
@@ -183,10 +204,15 @@  discard block
 block discarded – undo
183 204
 	}
184 205
 	public function countAllAirlineCountries($limit = true,$filter_name = '',$year = '',$month = '') {
185 206
 		global $globalStatsFilters;
186
-		if ($filter_name == '') $filter_name = $this->filter_name;
207
+		if ($filter_name == '') {
208
+			$filter_name = $this->filter_name;
209
+		}
187 210
 		if ($year == '' && $month == '') {
188
-			if ($limit) $query = "SELECT airlines.country AS airline_country, SUM(stats_airline.cnt) as airline_country_count FROM stats_airline,airlines WHERE stats_airline.airline_icao=airlines.icao AND filter_name = :filter_name GROUP BY airline_country ORDER BY airline_country_count DESC LIMIT 10 OFFSET 0";
189
-			else $query = "SELECT airlines.country AS airline_country, SUM(stats_airline.cnt) as airline_country_count FROM stats_airline,airlines WHERE stats_airline.airline_icao=airlines.icao AND filter_name = :filter_name GROUP BY airline_country ORDER BY airline_country_count DESC";
211
+			if ($limit) {
212
+				$query = "SELECT airlines.country AS airline_country, SUM(stats_airline.cnt) as airline_country_count FROM stats_airline,airlines WHERE stats_airline.airline_icao=airlines.icao AND filter_name = :filter_name GROUP BY airline_country ORDER BY airline_country_count DESC LIMIT 10 OFFSET 0";
213
+			} else {
214
+				$query = "SELECT airlines.country AS airline_country, SUM(stats_airline.cnt) as airline_country_count FROM stats_airline,airlines WHERE stats_airline.airline_icao=airlines.icao AND filter_name = :filter_name GROUP BY airline_country ORDER BY airline_country_count DESC";
215
+			}
190 216
 			try {
191 217
 				$sth = $this->db->prepare($query);
192 218
 				$sth->execute(array(':filter_name' => $filter_name));
@@ -194,7 +220,9 @@  discard block
 block discarded – undo
194 220
 				echo "error : ".$e->getMessage();
195 221
 			}
196 222
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
197
-		} else $all = array();
223
+		} else {
224
+			$all = array();
225
+		}
198 226
                 if (empty($all)) {
199 227
             		$Spotter = new Spotter($this->db);
200 228
             		$filters = array();
@@ -209,10 +237,15 @@  discard block
 block discarded – undo
209 237
 	}
210 238
 	public function countAllAircraftManufacturers($limit = true,$stats_airline = '', $filter_name = '',$year = '', $month = '') {
211 239
 		global $globalStatsFilters;
212
-		if ($filter_name == '') $filter_name = $this->filter_name;
240
+		if ($filter_name == '') {
241
+			$filter_name = $this->filter_name;
242
+		}
213 243
 		if ($year == '' && $month == '') {
214
-			if ($limit) $query = "SELECT aircraft_manufacturer, SUM(stats_aircraft.cnt) as aircraft_manufacturer_count FROM stats_aircraft WHERE stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY aircraft_manufacturer ORDER BY aircraft_manufacturer_count DESC LIMIT 10 OFFSET 0";
215
-			else $query = "SELECT aircraft_manufacturer, SUM(stats_aircraft.cnt) as aircraft_manufacturer_count FROM stats_aircraft WHERE stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY aircraft_manufacturer ORDER BY aircraft_manufacturer_count DESC";
244
+			if ($limit) {
245
+				$query = "SELECT aircraft_manufacturer, SUM(stats_aircraft.cnt) as aircraft_manufacturer_count FROM stats_aircraft WHERE stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY aircraft_manufacturer ORDER BY aircraft_manufacturer_count DESC LIMIT 10 OFFSET 0";
246
+			} else {
247
+				$query = "SELECT aircraft_manufacturer, SUM(stats_aircraft.cnt) as aircraft_manufacturer_count FROM stats_aircraft WHERE stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY aircraft_manufacturer ORDER BY aircraft_manufacturer_count DESC";
248
+			}
216 249
 			try {
217 250
 				$sth = $this->db->prepare($query);
218 251
 				$sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
@@ -220,7 +253,9 @@  discard block
 block discarded – undo
220 253
 				echo "error : ".$e->getMessage();
221 254
 			}
222 255
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
223
-		} else $all = array();
256
+		} else {
257
+			$all = array();
258
+		}
224 259
 		if (empty($all)) {
225 260
 			$filters = array('airlines' => array($stats_airline),'year' => $year,'month' => $month);
226 261
 			if ($filter_name != '') {
@@ -235,10 +270,15 @@  discard block
 block discarded – undo
235 270
 
236 271
 	public function countAllArrivalCountries($limit = true, $stats_airline = '', $filter_name = '',$year = '', $month = '') {
237 272
 		global $globalStatsFilters;
238
-		if ($filter_name == '') $filter_name = $this->filter_name;
273
+		if ($filter_name == '') {
274
+			$filter_name = $this->filter_name;
275
+		}
239 276
 		if ($year == '' && $month == '') {
240
-			if ($limit) $query = "SELECT airport_country AS airport_arrival_country, SUM(arrival) as airport_arrival_country_count FROM stats_airport WHERE stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY airport_arrival_country ORDER BY airport_arrival_country_count DESC LIMIT 10 OFFSET 0";
241
-			else $query = "SELECT airport_country AS airport_arrival_country, SUM(arrival) as airport_arrival_country_count FROM stats_airport WHERE stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY airport_arrival_country ORDER BY airport_arrival_country_count DESC";
277
+			if ($limit) {
278
+				$query = "SELECT airport_country AS airport_arrival_country, SUM(arrival) as airport_arrival_country_count FROM stats_airport WHERE stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY airport_arrival_country ORDER BY airport_arrival_country_count DESC LIMIT 10 OFFSET 0";
279
+			} else {
280
+				$query = "SELECT airport_country AS airport_arrival_country, SUM(arrival) as airport_arrival_country_count FROM stats_airport WHERE stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY airport_arrival_country ORDER BY airport_arrival_country_count DESC";
281
+			}
242 282
 			try {
243 283
 				$sth = $this->db->prepare($query);
244 284
 				$sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
@@ -246,7 +286,9 @@  discard block
 block discarded – undo
246 286
 				echo "error : ".$e->getMessage();
247 287
 			}
248 288
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
249
-		} else $all = array();
289
+		} else {
290
+			$all = array();
291
+		}
250 292
                 if (empty($all)) {
251 293
 			$filters = array('airlines' => array($stats_airline),'year' => $year,'month' => $month);
252 294
 			if ($filter_name != '') {
@@ -260,9 +302,14 @@  discard block
 block discarded – undo
260 302
 	}
261 303
 	public function countAllDepartureCountries($limit = true, $stats_airline = '', $filter_name = '', $year = '', $month = '') {
262 304
 		global $globalStatsFilters;
263
-		if ($filter_name == '') $filter_name = $this->filter_name;
264
-		if ($limit) $query = "SELECT airport_country AS airport_departure_country, SUM(departure) as airport_departure_country_count FROM stats_airport WHERE stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY airport_departure_country ORDER BY airport_departure_country_count DESC LIMIT 10 OFFSET 0";
265
-		else $query = "SELECT airport_country AS airport_departure_country, SUM(departure) as airport_departure_country_count FROM stats_airport WHERE stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY airport_departure_country ORDER BY airport_departure_country_count DESC";
305
+		if ($filter_name == '') {
306
+			$filter_name = $this->filter_name;
307
+		}
308
+		if ($limit) {
309
+			$query = "SELECT airport_country AS airport_departure_country, SUM(departure) as airport_departure_country_count FROM stats_airport WHERE stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY airport_departure_country ORDER BY airport_departure_country_count DESC LIMIT 10 OFFSET 0";
310
+		} else {
311
+			$query = "SELECT airport_country AS airport_departure_country, SUM(departure) as airport_departure_country_count FROM stats_airport WHERE stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY airport_departure_country ORDER BY airport_departure_country_count DESC";
312
+		}
266 313
                  try {
267 314
                         $sth = $this->db->prepare($query);
268 315
                         $sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
@@ -284,17 +331,29 @@  discard block
 block discarded – undo
284 331
 
285 332
 	public function countAllAirlines($limit = true,$filter_name = '',$year = '',$month = '') {
286 333
 		global $globalStatsFilters, $globalVATSIM, $globalIVAO;
287
-		if ($filter_name == '') $filter_name = $this->filter_name;
334
+		if ($filter_name == '') {
335
+			$filter_name = $this->filter_name;
336
+		}
288 337
 		if ($year == '' && $month == '') {
289
-			if ($globalVATSIM) $forsource = 'vatsim';
290
-			if ($globalIVAO) $forsource = 'ivao';
338
+			if ($globalVATSIM) {
339
+				$forsource = 'vatsim';
340
+			}
341
+			if ($globalIVAO) {
342
+				$forsource = 'ivao';
343
+			}
291 344
 			if (isset($forsource)) {
292
-				if ($limit) $query = "SELECT DISTINCT stats_airline.airline_icao, stats_airline.cnt AS airline_count, stats_airline.airline_name, airlines.country as airline_country FROM stats_airline, airlines WHERE stats_airline.airline_name <> '' AND stats_airline.airline_icao <> '' AND airlines.icao = stats_airline.airline_icao AND filter_name = :filter_name AND airlines.forsource = :forsource ORDER BY airline_count DESC LIMIT 10 OFFSET 0";
293
-				else $query = "SELECT DISTINCT stats_airline.airline_icao, stats_airline.cnt AS airline_count, stats_airline.airline_name, airlines.country as airline_country FROM stats_airline, airlines WHERE stats_airline.airline_name <> '' AND stats_airline.airline_icao <> '' AND airlines.icao = stats_airline.airline_icao AND filter_name = :filter_name AND airlines.forsource = :forsource ORDER BY airline_count DESC";
345
+				if ($limit) {
346
+					$query = "SELECT DISTINCT stats_airline.airline_icao, stats_airline.cnt AS airline_count, stats_airline.airline_name, airlines.country as airline_country FROM stats_airline, airlines WHERE stats_airline.airline_name <> '' AND stats_airline.airline_icao <> '' AND airlines.icao = stats_airline.airline_icao AND filter_name = :filter_name AND airlines.forsource = :forsource ORDER BY airline_count DESC LIMIT 10 OFFSET 0";
347
+				} else {
348
+					$query = "SELECT DISTINCT stats_airline.airline_icao, stats_airline.cnt AS airline_count, stats_airline.airline_name, airlines.country as airline_country FROM stats_airline, airlines WHERE stats_airline.airline_name <> '' AND stats_airline.airline_icao <> '' AND airlines.icao = stats_airline.airline_icao AND filter_name = :filter_name AND airlines.forsource = :forsource ORDER BY airline_count DESC";
349
+				}
294 350
 				$query_values = array(':filter_name' => $filter_name,':forsource' => $forsource);
295 351
 			} else {
296
-				if ($limit) $query = "SELECT DISTINCT stats_airline.airline_icao, stats_airline.cnt AS airline_count, stats_airline.airline_name, airlines.country as airline_country FROM stats_airline, airlines WHERE stats_airline.airline_name <> '' AND stats_airline.airline_icao <> '' AND airlines.icao = stats_airline.airline_icao AND filter_name = :filter_name AND airlines.forsource IS NULL ORDER BY airline_count DESC LIMIT 10 OFFSET 0";
297
-				else $query = "SELECT DISTINCT stats_airline.airline_icao, stats_airline.cnt AS airline_count, stats_airline.airline_name, airlines.country as airline_country FROM stats_airline, airlines WHERE stats_airline.airline_name <> '' AND stats_airline.airline_icao <> '' AND airlines.icao = stats_airline.airline_icao AND filter_name = :filter_name AND airlines.forsource IS NULL ORDER BY airline_count DESC";
352
+				if ($limit) {
353
+					$query = "SELECT DISTINCT stats_airline.airline_icao, stats_airline.cnt AS airline_count, stats_airline.airline_name, airlines.country as airline_country FROM stats_airline, airlines WHERE stats_airline.airline_name <> '' AND stats_airline.airline_icao <> '' AND airlines.icao = stats_airline.airline_icao AND filter_name = :filter_name AND airlines.forsource IS NULL ORDER BY airline_count DESC LIMIT 10 OFFSET 0";
354
+				} else {
355
+					$query = "SELECT DISTINCT stats_airline.airline_icao, stats_airline.cnt AS airline_count, stats_airline.airline_name, airlines.country as airline_country FROM stats_airline, airlines WHERE stats_airline.airline_name <> '' AND stats_airline.airline_icao <> '' AND airlines.icao = stats_airline.airline_icao AND filter_name = :filter_name AND airlines.forsource IS NULL ORDER BY airline_count DESC";
356
+				}
298 357
 				$query_values = array(':filter_name' => $filter_name);
299 358
 			}
300 359
 			try {
@@ -304,7 +363,9 @@  discard block
 block discarded – undo
304 363
 				echo "error : ".$e->getMessage();
305 364
 			}
306 365
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
307
-		} else $all = array();
366
+		} else {
367
+			$all = array();
368
+		}
308 369
                 if (empty($all)) {
309 370
 	                $Spotter = new Spotter($this->db);
310 371
             		$filters = array();
@@ -319,10 +380,15 @@  discard block
 block discarded – undo
319 380
 	}
320 381
 	public function countAllAircraftRegistrations($limit = true,$stats_airline = '',$filter_name = '',$year = '',$month = '') {
321 382
 		global $globalStatsFilters;
322
-		if ($filter_name == '') $filter_name = $this->filter_name;
383
+		if ($filter_name == '') {
384
+			$filter_name = $this->filter_name;
385
+		}
323 386
 		if ($year == '' && $month == '') {
324
-			if ($limit) $query = "SELECT s.aircraft_icao, s.cnt AS aircraft_registration_count, a.type AS aircraft_name, s.registration FROM stats_registration s, aircraft a WHERE s.registration <> '' AND a.icao = s.aircraft_icao AND s.stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY aircraft_registration_count DESC LIMIT 10 OFFSET 0";
325
-			else $query = "SELECT s.aircraft_icao, s.cnt AS aircraft_registration_count, a.type AS aircraft_name FROM stats_registration s, aircraft a WHERE s.registration <> '' AND a.icao = s.aircraft_icao AND s.stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY aircraft_registration_count DESC";
387
+			if ($limit) {
388
+				$query = "SELECT s.aircraft_icao, s.cnt AS aircraft_registration_count, a.type AS aircraft_name, s.registration FROM stats_registration s, aircraft a WHERE s.registration <> '' AND a.icao = s.aircraft_icao AND s.stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY aircraft_registration_count DESC LIMIT 10 OFFSET 0";
389
+			} else {
390
+				$query = "SELECT s.aircraft_icao, s.cnt AS aircraft_registration_count, a.type AS aircraft_name FROM stats_registration s, aircraft a WHERE s.registration <> '' AND a.icao = s.aircraft_icao AND s.stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY aircraft_registration_count DESC";
391
+			}
326 392
 			try {
327 393
 				$sth = $this->db->prepare($query);
328 394
 				$sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
@@ -330,7 +396,9 @@  discard block
 block discarded – undo
330 396
 				echo "error : ".$e->getMessage();
331 397
 			}
332 398
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
333
-		} else $all = array();
399
+		} else {
400
+			$all = array();
401
+		}
334 402
                 if (empty($all)) {
335 403
 			$filters = array('airlines' => array($stats_airline),'year' => $year,'month' => $month);
336 404
 			if ($filter_name != '') {
@@ -344,10 +412,15 @@  discard block
 block discarded – undo
344 412
 	}
345 413
 	public function countAllCallsigns($limit = true,$stats_airline = '',$filter_name = '',$year = '',$month = '') {
346 414
 		global $globalStatsFilters;
347
-		if ($filter_name == '') $filter_name = $this->filter_name;
415
+		if ($filter_name == '') {
416
+			$filter_name = $this->filter_name;
417
+		}
348 418
 		if ($year == '' && $month == '') {
349
-			if ($limit) $query = "SELECT s.callsign_icao, s.cnt AS callsign_icao_count, a.name AS airline_name, a.icao as airline_icao FROM stats_callsign s, airlines a WHERE s.callsign_icao <> '' AND a.icao = s.airline_icao AND s.airline_icao = :stats_airline AND filter_name = :filter_name ORDER BY callsign_icao_count DESC LIMIT 10 OFFSET 0";
350
-			else $query = "SELECT s.callsign_icao, s.cnt AS callsign_icao_count, a.name AS airline_name, a.icao as airline_icao FROM stats_callsign s, airlines a WHERE s.callsign_icao <> '' AND a.icao = s.airline_icao AND s.airline_icao = :stats_airline AND filter_name = :filter_name ORDER BY callsign_icao_count DESC";
419
+			if ($limit) {
420
+				$query = "SELECT s.callsign_icao, s.cnt AS callsign_icao_count, a.name AS airline_name, a.icao as airline_icao FROM stats_callsign s, airlines a WHERE s.callsign_icao <> '' AND a.icao = s.airline_icao AND s.airline_icao = :stats_airline AND filter_name = :filter_name ORDER BY callsign_icao_count DESC LIMIT 10 OFFSET 0";
421
+			} else {
422
+				$query = "SELECT s.callsign_icao, s.cnt AS callsign_icao_count, a.name AS airline_name, a.icao as airline_icao FROM stats_callsign s, airlines a WHERE s.callsign_icao <> '' AND a.icao = s.airline_icao AND s.airline_icao = :stats_airline AND filter_name = :filter_name ORDER BY callsign_icao_count DESC";
423
+			}
351 424
 			 try {
352 425
 				$sth = $this->db->prepare($query);
353 426
 				$sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
@@ -355,7 +428,9 @@  discard block
 block discarded – undo
355 428
 				echo "error : ".$e->getMessage();
356 429
 			}
357 430
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
358
-		} else $all = array();
431
+		} else {
432
+			$all = array();
433
+		}
359 434
 		if (empty($all)) {
360 435
 			$filters = array('airlines' => array($stats_airline),'year' => $year,'month' => $month);
361 436
 			if ($filter_name != '') {
@@ -369,11 +444,16 @@  discard block
 block discarded – undo
369 444
 	}
370 445
 	public function countAllFlightOverCountries($limit = true, $stats_airline = '',$filter_name = '',$year = '',$month = '') {
371 446
 		$Connection = new Connection();
372
-		if ($filter_name == '') $filter_name = $this->filter_name;
447
+		if ($filter_name == '') {
448
+			$filter_name = $this->filter_name;
449
+		}
373 450
 		if ($Connection->tableExists('countries')) {
374 451
 			if ($year == '' && $month == '') {
375
-				if ($limit) $query = "SELECT countries.iso3 as flight_country_iso3, countries.iso2 as flight_country_iso2, countries.name as flight_country, cnt as flight_count, lat as flight_country_latitude, lon as flight_country_longitude FROM stats_country, countries WHERE stats_country.iso2 = countries.iso2 AND stats_country.stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY flight_count DESC LIMIT 20 OFFSET 0";
376
-				else $query = "SELECT countries.iso3 as flight_country_iso3, countries.iso2 as flight_country_iso2, countries.name as flight_country, cnt as flight_count, lat as flight_country_latitude, lon as flight_country_longitude FROM stats_country, countries WHERE stats_country.iso2 = countries.iso2 AND stats_country.stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY flight_count DESC";
452
+				if ($limit) {
453
+					$query = "SELECT countries.iso3 as flight_country_iso3, countries.iso2 as flight_country_iso2, countries.name as flight_country, cnt as flight_count, lat as flight_country_latitude, lon as flight_country_longitude FROM stats_country, countries WHERE stats_country.iso2 = countries.iso2 AND stats_country.stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY flight_count DESC LIMIT 20 OFFSET 0";
454
+				} else {
455
+					$query = "SELECT countries.iso3 as flight_country_iso3, countries.iso2 as flight_country_iso2, countries.name as flight_country, cnt as flight_count, lat as flight_country_latitude, lon as flight_country_longitude FROM stats_country, countries WHERE stats_country.iso2 = countries.iso2 AND stats_country.stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY flight_count DESC";
456
+				}
377 457
 				 try {
378 458
 					$sth = $this->db->prepare($query);
379 459
 					$sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
@@ -388,17 +468,24 @@  discard block
 block discarded – undo
388 468
                 }
389 469
                 */
390 470
 				return $all;
391
-			} else return array();
471
+			} else {
472
+				return array();
473
+			}
392 474
 		} else {
393 475
 			return array();
394 476
 		}
395 477
 	}
396 478
 	public function countAllPilots($limit = true,$stats_airline = '',$filter_name = '', $year = '',$month = '') {
397 479
 		global $globalStatsFilters;
398
-		if ($filter_name == '') $filter_name = $this->filter_name;
480
+		if ($filter_name == '') {
481
+			$filter_name = $this->filter_name;
482
+		}
399 483
 		if ($year == '' && $month == '') {
400
-			if ($limit) $query = "SELECT pilot_id, cnt AS pilot_count, pilot_name, format_source FROM stats_pilot WHERE stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY pilot_count DESC LIMIT 10 OFFSET 0";
401
-			else $query = "SELECT pilot_id, cnt AS pilot_count, pilot_name, format_source FROM stats_pilot WHERE stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY pilot_count DESC";
484
+			if ($limit) {
485
+				$query = "SELECT pilot_id, cnt AS pilot_count, pilot_name, format_source FROM stats_pilot WHERE stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY pilot_count DESC LIMIT 10 OFFSET 0";
486
+			} else {
487
+				$query = "SELECT pilot_id, cnt AS pilot_count, pilot_name, format_source FROM stats_pilot WHERE stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY pilot_count DESC";
488
+			}
402 489
 			try {
403 490
 				$sth = $this->db->prepare($query);
404 491
 				$sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
@@ -406,7 +493,9 @@  discard block
 block discarded – undo
406 493
 				echo "error : ".$e->getMessage();
407 494
 			}
408 495
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
409
-		} else $all = array();
496
+		} else {
497
+			$all = array();
498
+		}
410 499
 		if (empty($all)) {
411 500
 			$filters = array('airlines' => array($stats_airline),'year' => $year,'month' => $month);
412 501
 			if ($filter_name != '') {
@@ -421,10 +510,15 @@  discard block
 block discarded – undo
421 510
 
422 511
 	public function countAllOwners($limit = true,$stats_airline = '', $filter_name = '',$year = '',$month = '') {
423 512
 		global $globalStatsFilters;
424
-		if ($filter_name == '') $filter_name = $this->filter_name;
513
+		if ($filter_name == '') {
514
+			$filter_name = $this->filter_name;
515
+		}
425 516
 		if ($year == '' && $month == '') {
426
-			if ($limit) $query = "SELECT owner_name, cnt AS owner_count FROM stats_owner WHERE stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY owner_count DESC LIMIT 10 OFFSET 0";
427
-			else $query = "SELECT owner_name, cnt AS owner_count FROM stats_owner WHERE stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY owner_count DESC";
517
+			if ($limit) {
518
+				$query = "SELECT owner_name, cnt AS owner_count FROM stats_owner WHERE stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY owner_count DESC LIMIT 10 OFFSET 0";
519
+			} else {
520
+				$query = "SELECT owner_name, cnt AS owner_count FROM stats_owner WHERE stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY owner_count DESC";
521
+			}
428 522
 			try {
429 523
 				$sth = $this->db->prepare($query);
430 524
 				$sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
@@ -432,7 +526,9 @@  discard block
 block discarded – undo
432 526
 				echo "error : ".$e->getMessage();
433 527
 			}
434 528
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
435
-		} else $all = array();
529
+		} else {
530
+			$all = array();
531
+		}
436 532
                 if (empty($all)) {
437 533
 			$filters = array('airlines' => array($stats_airline),'year' => $year,'month' => $month);
438 534
 			if ($filter_name != '') {
@@ -446,10 +542,15 @@  discard block
 block discarded – undo
446 542
 	}
447 543
 	public function countAllDepartureAirports($limit = true,$stats_airline = '',$filter_name = '',$year = '',$month = '') {
448 544
 		global $globalStatsFilters;
449
-		if ($filter_name == '') $filter_name = $this->filter_name;
545
+		if ($filter_name == '') {
546
+			$filter_name = $this->filter_name;
547
+		}
450 548
 		if ($year == '' && $month == '') {
451
-			if ($limit) $query = "SELECT DISTINCT airport_icao AS airport_departure_icao,airport_city AS airport_departure_city,airport_country AS airport_departure_country,departure AS airport_departure_icao_count FROM stats_airport WHERE departure > 0 AND stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY airport_departure_icao_count DESC LIMIT 10 OFFSET 0";
452
-			else $query = "SELECT DISTINCT airport_icao AS airport_departure_icao,airport_city AS airport_departure_city,airport_country AS airport_departure_country,departure AS airport_departure_icao_count FROM stats_airport WHERE departure > 0 AND stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY airport_departure_icao_count DESC";
549
+			if ($limit) {
550
+				$query = "SELECT DISTINCT airport_icao AS airport_departure_icao,airport_city AS airport_departure_city,airport_country AS airport_departure_country,departure AS airport_departure_icao_count FROM stats_airport WHERE departure > 0 AND stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY airport_departure_icao_count DESC LIMIT 10 OFFSET 0";
551
+			} else {
552
+				$query = "SELECT DISTINCT airport_icao AS airport_departure_icao,airport_city AS airport_departure_city,airport_country AS airport_departure_country,departure AS airport_departure_icao_count FROM stats_airport WHERE departure > 0 AND stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY airport_departure_icao_count DESC";
553
+			}
453 554
 			try {
454 555
 				$sth = $this->db->prepare($query);
455 556
 				$sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
@@ -457,7 +558,9 @@  discard block
 block discarded – undo
457 558
 				echo "error : ".$e->getMessage();
458 559
 			}
459 560
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
460
-		} else $all = array();
561
+		} else {
562
+			$all = array();
563
+		}
461 564
                 if (empty($all)) {
462 565
 			$filters = array('airlines' => array($stats_airline),'year' => $year,'month' => $month);
463 566
             		if ($filter_name != '') {
@@ -478,7 +581,9 @@  discard block
 block discarded – undo
478 581
         			$icao = $value['airport_departure_icao'];
479 582
         			if (isset($all[$icao])) {
480 583
         				$all[$icao]['airport_departure_icao_count'] = $all[$icao]['airport_departure_icao_count'] + $value['airport_departure_icao_count'];
481
-        			} else $all[$icao] = $value;
584
+        			} else {
585
+        				$all[$icao] = $value;
586
+        			}
482 587
         		}
483 588
         		$count = array();
484 589
         		foreach ($all as $key => $row) {
@@ -490,10 +595,15 @@  discard block
 block discarded – undo
490 595
 	}
491 596
 	public function countAllArrivalAirports($limit = true,$stats_airline = '',$filter_name = '',$year = '',$month = '') {
492 597
 		global $globalStatsFilters;
493
-		if ($filter_name == '') $filter_name = $this->filter_name;
598
+		if ($filter_name == '') {
599
+			$filter_name = $this->filter_name;
600
+		}
494 601
 		if ($year == '' && $month == '') {
495
-			if ($limit) $query = "SELECT DISTINCT airport_icao AS airport_arrival_icao,airport_city AS airport_arrival_city,airport_country AS airport_arrival_country,arrival AS airport_arrival_icao_count FROM stats_airport WHERE arrival > 0 AND stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY airport_arrival_icao_count DESC LIMIT 10 OFFSET 0";
496
-			else $query = "SELECT DISTINCT airport_icao AS airport_arrival_icao,airport_city AS airport_arrival_city,airport_country AS airport_arrival_country,arrival AS airport_arrival_icao_count FROM stats_airport WHERE arrival > 0 AND stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY airport_arrival_icao_count DESC";
602
+			if ($limit) {
603
+				$query = "SELECT DISTINCT airport_icao AS airport_arrival_icao,airport_city AS airport_arrival_city,airport_country AS airport_arrival_country,arrival AS airport_arrival_icao_count FROM stats_airport WHERE arrival > 0 AND stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY airport_arrival_icao_count DESC LIMIT 10 OFFSET 0";
604
+			} else {
605
+				$query = "SELECT DISTINCT airport_icao AS airport_arrival_icao,airport_city AS airport_arrival_city,airport_country AS airport_arrival_country,arrival AS airport_arrival_icao_count FROM stats_airport WHERE arrival > 0 AND stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY airport_arrival_icao_count DESC";
606
+			}
497 607
 			try {
498 608
 				$sth = $this->db->prepare($query);
499 609
 				$sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
@@ -501,7 +611,9 @@  discard block
 block discarded – undo
501 611
 				echo "error : ".$e->getMessage();
502 612
 			}
503 613
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
504
-		} else $all = array();
614
+		} else {
615
+			$all = array();
616
+		}
505 617
 		if (empty($all)) {
506 618
 			$filters = array('airlines' => array($stats_airline),'year' => $year,'month' => $month);
507 619
 			if ($filter_name != '') {
@@ -522,7 +634,9 @@  discard block
 block discarded – undo
522 634
         			$icao = $value['airport_arrival_icao'];
523 635
         			if (isset($all[$icao])) {
524 636
         				$all[$icao]['airport_arrival_icao_count'] = $all[$icao]['airport_arrival_icao_count'] + $value['airport_arrival_icao_count'];
525
-        			} else $all[$icao] = $value;
637
+        			} else {
638
+        				$all[$icao] = $value;
639
+        			}
526 640
         		}
527 641
         		$count = array();
528 642
         		foreach ($all as $key => $row) {
@@ -535,13 +649,21 @@  discard block
 block discarded – undo
535 649
 	}
536 650
 	public function countAllMonthsLastYear($limit = true,$stats_airline = '',$filter_name = '') {
537 651
 		global $globalDBdriver, $globalStatsFilters;
538
-		if ($filter_name == '') $filter_name = $this->filter_name;
652
+		if ($filter_name == '') {
653
+			$filter_name = $this->filter_name;
654
+		}
539 655
 		if ($globalDBdriver == 'mysql') {
540
-			if ($limit) $query = "SELECT MONTH(stats_date) as month_name, YEAR(stats_date) as year_name, cnt as date_count FROM stats WHERE stats_type = 'flights_bymonth' AND stats_date >= DATE_SUB(UTC_TIMESTAMP(),INTERVAL 12 MONTH) AND stats_airline = :stats_airline AND filter_name = :filter_name";
541
-			else $query = "SELECT MONTH(stats_date) as month_name, YEAR(stats_date) as year_name, cnt as date_count FROM stats WHERE stats_type = 'flights_bymonth' AND stats_airline = :stats_airline AND filter_name = :filter_name";
656
+			if ($limit) {
657
+				$query = "SELECT MONTH(stats_date) as month_name, YEAR(stats_date) as year_name, cnt as date_count FROM stats WHERE stats_type = 'flights_bymonth' AND stats_date >= DATE_SUB(UTC_TIMESTAMP(),INTERVAL 12 MONTH) AND stats_airline = :stats_airline AND filter_name = :filter_name";
658
+			} else {
659
+				$query = "SELECT MONTH(stats_date) as month_name, YEAR(stats_date) as year_name, cnt as date_count FROM stats WHERE stats_type = 'flights_bymonth' AND stats_airline = :stats_airline AND filter_name = :filter_name";
660
+			}
542 661
 		} else {
543
-			if ($limit) $query = "SELECT EXTRACT(MONTH FROM stats_date) as month_name, EXTRACT(YEAR FROM stats_date) as year_name, cnt as date_count FROM stats WHERE stats_type = 'flights_bymonth' AND stats_date >= CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '12 MONTHS' AND stats_airline = :stats_airline AND filter_name = :filter_name";
544
-			else $query = "SELECT EXTRACT(MONTH FROM stats_date) as month_name, EXTRACT(YEAR FROM stats_date) as year_name, cnt as date_count FROM stats WHERE stats_type = 'flights_bymonth' AND stats_airline = :stats_airline AND filter_name = :filter_name";
662
+			if ($limit) {
663
+				$query = "SELECT EXTRACT(MONTH FROM stats_date) as month_name, EXTRACT(YEAR FROM stats_date) as year_name, cnt as date_count FROM stats WHERE stats_type = 'flights_bymonth' AND stats_date >= CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '12 MONTHS' AND stats_airline = :stats_airline AND filter_name = :filter_name";
664
+			} else {
665
+				$query = "SELECT EXTRACT(MONTH FROM stats_date) as month_name, EXTRACT(YEAR FROM stats_date) as year_name, cnt as date_count FROM stats WHERE stats_type = 'flights_bymonth' AND stats_airline = :stats_airline AND filter_name = :filter_name";
666
+			}
545 667
 		}
546 668
 		$query_data = array(':stats_airline' => $stats_airline,':filter_name' => $filter_name);
547 669
                  try {
@@ -565,7 +687,9 @@  discard block
 block discarded – undo
565 687
 	
566 688
 	public function countAllDatesLastMonth($stats_airline = '',$filter_name = '') {
567 689
 		global $globalStatsFilters;
568
-		if ($filter_name == '') $filter_name = $this->filter_name;
690
+		if ($filter_name == '') {
691
+			$filter_name = $this->filter_name;
692
+		}
569 693
 		$query = "SELECT flight_date as date_name, cnt as date_count FROM stats_flight WHERE stats_type = 'month' AND stats_airline = :stats_airline AND filter_name = :filter_name";
570 694
 		$query_data = array(':stats_airline' => $stats_airline,':filter_name' => $filter_name);
571 695
                  try {
@@ -587,7 +711,9 @@  discard block
 block discarded – undo
587 711
 	}
588 712
 	public function countAllDatesLast7Days($stats_airline = '',$filter_name = '') {
589 713
 		global $globalDBdriver, $globalStatsFilters;
590
-		if ($filter_name == '') $filter_name = $this->filter_name;
714
+		if ($filter_name == '') {
715
+			$filter_name = $this->filter_name;
716
+		}
591 717
 		if ($globalDBdriver == 'mysql') {
592 718
 			$query = "SELECT flight_date as date_name, cnt as date_count FROM stats_flight WHERE stats_type = 'month' AND flight_date >= DATE_SUB(UTC_TIMESTAMP(),INTERVAL 7 DAY) AND stats_airline = :stats_airline AND filter_name = :filter_name";
593 719
 		} else {
@@ -613,7 +739,9 @@  discard block
 block discarded – undo
613 739
 	}
614 740
 	public function countAllDates($stats_airline = '',$filter_name = '') {
615 741
 		global $globalStatsFilters;
616
-		if ($filter_name == '') $filter_name = $this->filter_name;
742
+		if ($filter_name == '') {
743
+			$filter_name = $this->filter_name;
744
+		}
617 745
 		$query = "SELECT flight_date as date_name, cnt as date_count FROM stats_flight WHERE stats_type = 'date' AND stats_airline = :stats_airline AND filter_name = :filter_name";
618 746
 		$query_data = array(':stats_airline' => $stats_airline,':filter_name' => $filter_name);
619 747
                  try {
@@ -635,7 +763,9 @@  discard block
 block discarded – undo
635 763
 	}
636 764
 	public function countAllDatesByAirlines($filter_name = '') {
637 765
 		global $globalStatsFilters;
638
-		if ($filter_name == '') $filter_name = $this->filter_name;
766
+		if ($filter_name == '') {
767
+			$filter_name = $this->filter_name;
768
+		}
639 769
 		$query = "SELECT stats_airline as airline_icao, flight_date as date_name, cnt as date_count FROM stats_flight WHERE stats_type = 'date' AND filter_name = :filter_name";
640 770
 		$query_data = array('filter_name' => $filter_name);
641 771
                  try {
@@ -657,7 +787,9 @@  discard block
 block discarded – undo
657 787
 	}
658 788
 	public function countAllMonths($stats_airline = '',$filter_name = '') {
659 789
 		global $globalStatsFilters, $globalDBdriver;
660
-		if ($filter_name == '') $filter_name = $this->filter_name;
790
+		if ($filter_name == '') {
791
+			$filter_name = $this->filter_name;
792
+		}
661 793
 		if ($globalDBdriver == 'mysql') {
662 794
 			$query = "SELECT YEAR(stats_date) AS year_name,MONTH(stats_date) AS month_name, cnt as date_count FROM stats WHERE stats_type = 'flights_bymonth' AND stats_airline = :stats_airline AND filter_name = :filter_name";
663 795
 		} else {
@@ -726,7 +858,9 @@  discard block
 block discarded – undo
726 858
 	}
727 859
 	public function countAllMilitaryMonths($filter_name = '') {
728 860
 		global $globalStatsFilters;
729
-		if ($filter_name == '') $filter_name = $this->filter_name;
861
+		if ($filter_name == '') {
862
+			$filter_name = $this->filter_name;
863
+		}
730 864
 	    	$query = "SELECT YEAR(stats_date) AS year_name,MONTH(stats_date) AS month_name, cnt as date_count FROM stats WHERE stats_type = 'military_flights_bymonth' AND filter_name = :filter_name";
731 865
                  try {
732 866
                         $sth = $this->db->prepare($query);
@@ -747,9 +881,14 @@  discard block
 block discarded – undo
747 881
 	}
748 882
 	public function countAllHours($orderby = 'hour',$limit = true,$stats_airline = '',$filter_name = '') {
749 883
 		global $globalTimezone, $globalDBdriver, $globalStatsFilters;
750
-		if ($filter_name == '') $filter_name = $this->filter_name;
751
-		if ($limit) $query = "SELECT flight_date as hour_name, cnt as hour_count FROM stats_flight WHERE stats_type = 'hour' AND stats_airline = :stats_airline AND filter_name = :filter_name";
752
-		else $query = "SELECT flight_date as hour_name, cnt as hour_count FROM stats_flight WHERE stats_type = 'hour' AND stats_airline = :stats_airline AND filter_name = :filter_name";
884
+		if ($filter_name == '') {
885
+			$filter_name = $this->filter_name;
886
+		}
887
+		if ($limit) {
888
+			$query = "SELECT flight_date as hour_name, cnt as hour_count FROM stats_flight WHERE stats_type = 'hour' AND stats_airline = :stats_airline AND filter_name = :filter_name";
889
+		} else {
890
+			$query = "SELECT flight_date as hour_name, cnt as hour_count FROM stats_flight WHERE stats_type = 'hour' AND stats_airline = :stats_airline AND filter_name = :filter_name";
891
+		}
753 892
 		if ($orderby == 'hour') {
754 893
 			if ($globalDBdriver == 'mysql') {
755 894
 				//$query .= " ORDER BY flight_date ASC";
@@ -758,7 +897,9 @@  discard block
 block discarded – undo
758 897
 				$query .= " ORDER BY CAST(flight_date AS integer) ASC";
759 898
 			}
760 899
 		}
761
-		if ($orderby == 'count') $query .= " ORDER BY hour_count DESC";
900
+		if ($orderby == 'count') {
901
+			$query .= " ORDER BY hour_count DESC";
902
+		}
762 903
                  try {
763 904
                         $sth = $this->db->prepare($query);
764 905
                         $sth->execute(array(':stats_airline' => $stats_airline, ':filter_name' => $filter_name));
@@ -779,8 +920,12 @@  discard block
 block discarded – undo
779 920
 	
780 921
 	public function countOverallFlights($stats_airline = '', $filter_name = '',$year = '',$month = '') {
781 922
 		global $globalStatsFilters;
782
-		if ($filter_name == '') $filter_name = $this->filter_name;
783
-		if ($year == '') $year = date('Y');
923
+		if ($filter_name == '') {
924
+			$filter_name = $this->filter_name;
925
+		}
926
+		if ($year == '') {
927
+			$year = date('Y');
928
+		}
784 929
 		$all = $this->getSumStats('flights_bymonth',$year,$stats_airline,$filter_name,$month);
785 930
 		if (empty($all)) {
786 931
 			$filters = array('airlines' => array($stats_airline),'year' => $year,'month' => $month);
@@ -795,8 +940,12 @@  discard block
 block discarded – undo
795 940
 	}
796 941
 	public function countOverallMilitaryFlights($filter_name = '',$year = '', $month = '') {
797 942
 		global $globalStatsFilters;
798
-		if ($filter_name == '') $filter_name = $this->filter_name;
799
-		if ($year == '') $year = date('Y');
943
+		if ($filter_name == '') {
944
+			$filter_name = $this->filter_name;
945
+		}
946
+		if ($year == '') {
947
+			$year = date('Y');
948
+		}
800 949
 		$all = $this->getSumStats('military_flights_bymonth',$year,'',$filter_name,$month);
801 950
 		if (empty($all)) {
802 951
 		        $filters = array();
@@ -812,8 +961,12 @@  discard block
 block discarded – undo
812 961
 	}
813 962
 	public function countOverallArrival($stats_airline = '',$filter_name = '', $year = '', $month = '') {
814 963
 		global $globalStatsFilters;
815
-		if ($filter_name == '') $filter_name = $this->filter_name;
816
-		if ($year == '') $year = date('Y');
964
+		if ($filter_name == '') {
965
+			$filter_name = $this->filter_name;
966
+		}
967
+		if ($year == '') {
968
+			$year = date('Y');
969
+		}
817 970
 		$all = $this->getSumStats('realarrivals_bymonth',$year,$stats_airline,$filter_name,$month);
818 971
 		if (empty($all)) {
819 972
 			$filters = array('airlines' => array($stats_airline),'year' => $year,'month' => $month);
@@ -828,7 +981,9 @@  discard block
 block discarded – undo
828 981
 	}
829 982
 	public function countOverallAircrafts($stats_airline = '',$filter_name = '',$year = '', $month = '') {
830 983
 		global $globalStatsFilters;
831
-		if ($filter_name == '') $filter_name = $this->filter_name;
984
+		if ($filter_name == '') {
985
+			$filter_name = $this->filter_name;
986
+		}
832 987
 		if ($year == '' && $month == '') {
833 988
 			$query = "SELECT COUNT(*) AS nb FROM stats_aircraft WHERE stats_airline = :stats_airline AND filter_name = :filter_name";
834 989
 			try {
@@ -839,7 +994,9 @@  discard block
 block discarded – undo
839 994
 			}
840 995
 			$result = $sth->fetchAll(PDO::FETCH_ASSOC);
841 996
 			$all = $result[0]['nb'];
842
-		} else $all = $this->getSumStats('aircrafts_bymonth',$year,$stats_airline,$filter_name,$month);
997
+		} else {
998
+			$all = $this->getSumStats('aircrafts_bymonth',$year,$stats_airline,$filter_name,$month);
999
+		}
843 1000
 		if (empty($all)) {
844 1001
 			$filters = array('airlines' => array($stats_airline),'year' => $year,'month' => $month);
845 1002
 			if ($filter_name != '') {
@@ -853,7 +1010,9 @@  discard block
 block discarded – undo
853 1010
 	}
854 1011
 	public function countOverallAirlines($filter_name = '',$year = '',$month = '') {
855 1012
 		global $globalStatsFilters;
856
-		if ($filter_name == '') $filter_name = $this->filter_name;
1013
+		if ($filter_name == '') {
1014
+			$filter_name = $this->filter_name;
1015
+		}
857 1016
 		if ($year == '' && $month == '') {
858 1017
 			$query = "SELECT COUNT(*) AS nb_airline FROM stats_airline WHERE filter_name = :filter_name";
859 1018
 			try {
@@ -864,7 +1023,9 @@  discard block
 block discarded – undo
864 1023
 			}
865 1024
 			$result = $sth->fetchAll(PDO::FETCH_ASSOC);
866 1025
 			$all = $result[0]['nb_airline'];
867
-		} else $all = $this->getSumStats('airlines_bymonth',$year,'',$filter_name,$month);
1026
+		} else {
1027
+			$all = $this->getSumStats('airlines_bymonth',$year,'',$filter_name,$month);
1028
+		}
868 1029
 		if (empty($all)) {
869 1030
             		$filters = array();
870 1031
 			$filters = array('year' => $year,'month' => $month);
@@ -879,7 +1040,9 @@  discard block
 block discarded – undo
879 1040
 	}
880 1041
 	public function countOverallOwners($stats_airline = '',$filter_name = '',$year = '', $month = '') {
881 1042
 		global $globalStatsFilters;
882
-		if ($filter_name == '') $filter_name = $this->filter_name;
1043
+		if ($filter_name == '') {
1044
+			$filter_name = $this->filter_name;
1045
+		}
883 1046
 		if ($year == '' && $month == '') {
884 1047
 			$query = "SELECT count(*) as nb FROM stats_owner WHERE stats_airline = :stats_airline AND filter_name = :filter_name";
885 1048
 			$query_values = array(':stats_airline' => $stats_airline, ':filter_name' => $filter_name);
@@ -907,7 +1070,9 @@  discard block
 block discarded – undo
907 1070
 	}
908 1071
 	public function countOverallPilots($stats_airline = '',$filter_name = '',$year = '',$month = '') {
909 1072
 		global $globalStatsFilters;
910
-		if ($filter_name == '') $filter_name = $this->filter_name;
1073
+		if ($filter_name == '') {
1074
+			$filter_name = $this->filter_name;
1075
+		}
911 1076
 		//if ($year == '') $year = date('Y');
912 1077
 		if ($year == '' && $month == '') {
913 1078
 			$query = "SELECT count(*) as nb FROM stats_pilot WHERE stats_airline = :stats_airline AND filter_name = :filter_name";
@@ -936,7 +1101,9 @@  discard block
 block discarded – undo
936 1101
 	}
937 1102
 
938 1103
 	public function getLast7DaysAirports($airport_icao = '', $stats_airline = '',$filter_name = '') {
939
-		if ($filter_name == '') $filter_name = $this->filter_name;
1104
+		if ($filter_name == '') {
1105
+			$filter_name = $this->filter_name;
1106
+		}
940 1107
 		$query = "SELECT * FROM stats_airport WHERE stats_type = 'daily' AND airport_icao = :airport_icao AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY date";
941 1108
 		$query_values = array(':airport_icao' => $airport_icao,':stats_airline' => $stats_airline, ':filter_name' => $filter_name);
942 1109
                  try {
@@ -949,7 +1116,9 @@  discard block
 block discarded – undo
949 1116
                 return $all;
950 1117
 	}
951 1118
 	public function getStats($type,$stats_airline = '', $filter_name = '') {
952
-		if ($filter_name == '') $filter_name = $this->filter_name;
1119
+		if ($filter_name == '') {
1120
+			$filter_name = $this->filter_name;
1121
+		}
953 1122
                 $query = "SELECT * FROM stats WHERE stats_type = :type AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY stats_date";
954 1123
                 $query_values = array(':type' => $type,':stats_airline' => $stats_airline,':filter_name' => $filter_name);
955 1124
                  try {
@@ -962,7 +1131,9 @@  discard block
 block discarded – undo
962 1131
                 return $all;
963 1132
         }
964 1133
 	public function deleteStatsByType($type,$stats_airline = '', $filter_name = '') {
965
-		if ($filter_name == '') $filter_name = $this->filter_name;
1134
+		if ($filter_name == '') {
1135
+			$filter_name = $this->filter_name;
1136
+		}
966 1137
                 $query = "DELETE FROM stats WHERE stats_type = :type AND stats_airline = :stats_airline AND filter_name = :filter_name";
967 1138
                 $query_values = array(':type' => $type,':stats_airline' => $stats_airline,':filter_name' => $filter_name);
968 1139
                  try {
@@ -973,7 +1144,9 @@  discard block
 block discarded – undo
973 1144
                 }
974 1145
         }
975 1146
 	public function getSumStats($type,$year,$stats_airline = '',$filter_name = '',$month = '') {
976
-		if ($filter_name == '') $filter_name = $this->filter_name;
1147
+		if ($filter_name == '') {
1148
+			$filter_name = $this->filter_name;
1149
+		}
977 1150
     		global $globalArchiveMonths, $globalDBdriver;
978 1151
     		if ($globalDBdriver == 'mysql') {
979 1152
     			if ($month == '') {
@@ -1003,7 +1176,9 @@  discard block
 block discarded – undo
1003 1176
         }
1004 1177
 	public function getStatsTotal($type, $stats_airline = '', $filter_name = '') {
1005 1178
     		global $globalArchiveMonths, $globalDBdriver;
1006
-		if ($filter_name == '') $filter_name = $this->filter_name;
1179
+		if ($filter_name == '') {
1180
+			$filter_name = $this->filter_name;
1181
+		}
1007 1182
     		if ($globalDBdriver == 'mysql') {
1008 1183
 			$query = "SELECT SUM(cnt) as total FROM stats WHERE stats_type = :type AND stats_date < DATE_SUB(UTC_TIMESTAMP(), INTERVAL ".$globalArchiveMonths." MONTH) AND stats_airline = :stats_airline AND filter_name = :filter_name";
1009 1184
 		} else {
@@ -1021,7 +1196,9 @@  discard block
 block discarded – undo
1021 1196
         }
1022 1197
 	public function getStatsAircraftTotal($stats_airline = '', $filter_name = '') {
1023 1198
     		global $globalArchiveMonths, $globalDBdriver;
1024
-		if ($filter_name == '') $filter_name = $this->filter_name;
1199
+		if ($filter_name == '') {
1200
+			$filter_name = $this->filter_name;
1201
+		}
1025 1202
     		if ($globalDBdriver == 'mysql') {
1026 1203
 			$query = "SELECT SUM(cnt) as total FROM stats_aircraft WHERE stats_airline = :stats_airline AND filter_name = :filter_name";
1027 1204
                 } else {
@@ -1038,7 +1215,9 @@  discard block
 block discarded – undo
1038 1215
         }
1039 1216
 	public function getStatsAirlineTotal($filter_name = '') {
1040 1217
     		global $globalArchiveMonths, $globalDBdriver;
1041
-		if ($filter_name == '') $filter_name = $this->filter_name;
1218
+		if ($filter_name == '') {
1219
+			$filter_name = $this->filter_name;
1220
+		}
1042 1221
     		if ($globalDBdriver == 'mysql') {
1043 1222
 			$query = "SELECT SUM(cnt) as total FROM stats_airline WHERE filter_name = :filter_name";
1044 1223
                 } else {
@@ -1055,7 +1234,9 @@  discard block
 block discarded – undo
1055 1234
         }
1056 1235
 	public function getStatsOwnerTotal($filter_name = '') {
1057 1236
     		global $globalArchiveMonths, $globalDBdriver;
1058
-		if ($filter_name == '') $filter_name = $this->filter_name;
1237
+		if ($filter_name == '') {
1238
+			$filter_name = $this->filter_name;
1239
+		}
1059 1240
     		if ($globalDBdriver == 'mysql') {
1060 1241
 			$query = "SELECT SUM(cnt) as total FROM stats_owner WHERE filter_name = :filter_name";
1061 1242
 		} else {
@@ -1072,7 +1253,9 @@  discard block
 block discarded – undo
1072 1253
         }
1073 1254
 	public function getStatsOwner($owner_name,$filter_name = '') {
1074 1255
     		global $globalArchiveMonths, $globalDBdriver;
1075
-		if ($filter_name == '') $filter_name = $this->filter_name;
1256
+		if ($filter_name == '') {
1257
+			$filter_name = $this->filter_name;
1258
+		}
1076 1259
 		$query = "SELECT cnt FROM stats_owner WHERE filter_name = :filter_name AND owner_name = :owner_name";
1077 1260
                  try {
1078 1261
                         $sth = $this->db->prepare($query);
@@ -1081,12 +1264,17 @@  discard block
 block discarded – undo
1081 1264
                         echo "error : ".$e->getMessage();
1082 1265
                 }
1083 1266
                 $all = $sth->fetchAll(PDO::FETCH_ASSOC);
1084
-                if (isset($all[0]['cnt'])) return $all[0]['cnt'];
1085
-                else return 0;
1267
+                if (isset($all[0]['cnt'])) {
1268
+                	return $all[0]['cnt'];
1269
+                } else {
1270
+                	return 0;
1271
+                }
1086 1272
         }
1087 1273
 	public function getStatsPilotTotal($filter_name = '') {
1088 1274
     		global $globalArchiveMonths, $globalDBdriver;
1089
-		if ($filter_name == '') $filter_name = $this->filter_name;
1275
+		if ($filter_name == '') {
1276
+			$filter_name = $this->filter_name;
1277
+		}
1090 1278
     		if ($globalDBdriver == 'mysql') {
1091 1279
             		$query = "SELECT SUM(cnt) as total FROM stats_pilot WHERE filter_name = :filter_name";
1092 1280
             	} else {
@@ -1103,7 +1291,9 @@  discard block
 block discarded – undo
1103 1291
         }
1104 1292
 	public function getStatsPilot($pilot,$filter_name = '') {
1105 1293
     		global $globalArchiveMonths, $globalDBdriver;
1106
-		if ($filter_name == '') $filter_name = $this->filter_name;
1294
+		if ($filter_name == '') {
1295
+			$filter_name = $this->filter_name;
1296
+		}
1107 1297
 		$query = "SELECT cnt FROM stats_pilot WHERE filter_name = :filter_name AND (pilot_name = :pilot OR pilot_id = :pilot)";
1108 1298
                  try {
1109 1299
                         $sth = $this->db->prepare($query);
@@ -1112,13 +1302,18 @@  discard block
 block discarded – undo
1112 1302
                         echo "error : ".$e->getMessage();
1113 1303
                 }
1114 1304
                 $all = $sth->fetchAll(PDO::FETCH_ASSOC);
1115
-                if (isset($all[0]['cnt'])) return $all[0]['cnt'];
1116
-                else return 0;
1305
+                if (isset($all[0]['cnt'])) {
1306
+                	return $all[0]['cnt'];
1307
+                } else {
1308
+                	return 0;
1309
+                }
1117 1310
         }
1118 1311
 
1119 1312
 	public function addStat($type,$cnt,$stats_date,$stats_airline = '',$filter_name = '') {
1120 1313
 		global $globalDBdriver;
1121
-		if ($filter_name == '') $filter_name = $this->filter_name;
1314
+		if ($filter_name == '') {
1315
+			$filter_name = $this->filter_name;
1316
+		}
1122 1317
 		if ($globalDBdriver == 'mysql') {
1123 1318
 			$query = "INSERT INTO stats (stats_type,cnt,stats_date,stats_airline,filter_name) VALUES (:type,:cnt,:stats_date,:stats_airline,:filter_name) ON DUPLICATE KEY UPDATE cnt = :cnt";
1124 1319
                 } else {
@@ -1134,7 +1329,9 @@  discard block
 block discarded – undo
1134 1329
         }
1135 1330
 	public function updateStat($type,$cnt,$stats_date,$stats_airline = '',$filter_name = '') {
1136 1331
 		global $globalDBdriver;
1137
-		if ($filter_name == '') $filter_name = $this->filter_name;
1332
+		if ($filter_name == '') {
1333
+			$filter_name = $this->filter_name;
1334
+		}
1138 1335
 		if ($globalDBdriver == 'mysql') {
1139 1336
 			$query = "INSERT INTO stats (stats_type,cnt,stats_date,stats_airline,filter_name) VALUES (:type,:cnt,:stats_date,:stats_airline,:filter_name) ON DUPLICATE KEY UPDATE cnt = cnt+:cnt, stats_date = :date";
1140 1337
 		} else {
@@ -1520,10 +1717,14 @@  discard block
 block discarded – undo
1520 1717
     		$Connection = new Connection();
1521 1718
     		date_default_timezone_set('UTC');
1522 1719
     		$last_update = $this->getLastStatsUpdate('last_update_stats');
1523
-			if ($globalDebug) echo 'Update stats !'."\n";
1720
+			if ($globalDebug) {
1721
+				echo 'Update stats !'."\n";
1722
+			}
1524 1723
 			if (isset($last_update[0]['value'])) {
1525 1724
 				$last_update_day = $last_update[0]['value'];
1526
-			} else $last_update_day = '2012-12-12 12:12:12';
1725
+			} else {
1726
+				$last_update_day = '2012-12-12 12:12:12';
1727
+			}
1527 1728
 			$reset = false;
1528 1729
 			//if ($globalStatsResetYear && date('Y',strtotime($last_update_day)) != date('Y')) {
1529 1730
 			if ($globalStatsResetYear) {
@@ -1532,42 +1733,60 @@  discard block
 block discarded – undo
1532 1733
 			}
1533 1734
 			$Spotter = new Spotter($this->db);
1534 1735
 
1535
-			if ($globalDebug) echo 'Count all aircraft types...'."\n";
1736
+			if ($globalDebug) {
1737
+				echo 'Count all aircraft types...'."\n";
1738
+			}
1536 1739
 			$alldata = $Spotter->countAllAircraftTypes(false,0,$last_update_day);
1537 1740
 			foreach ($alldata as $number) {
1538 1741
 				$this->addStatAircraft($number['aircraft_icao'],$number['aircraft_icao_count'],$number['aircraft_name'],$number['aircraft_manufacturer'],'','',$reset);
1539 1742
 			}
1540
-			if ($globalDebug) echo 'Count all airlines...'."\n";
1743
+			if ($globalDebug) {
1744
+				echo 'Count all airlines...'."\n";
1745
+			}
1541 1746
 			$alldata = $Spotter->countAllAirlines(false,0,$last_update_day);
1542 1747
 			foreach ($alldata as $number) {
1543 1748
 				$this->addStatAirline($number['airline_icao'],$number['airline_count'],$number['airline_name'],'',$reset);
1544 1749
 			}
1545
-			if ($globalDebug) echo 'Count all registrations...'."\n";
1750
+			if ($globalDebug) {
1751
+				echo 'Count all registrations...'."\n";
1752
+			}
1546 1753
 			$alldata = $Spotter->countAllAircraftRegistrations(false,0,$last_update_day);
1547 1754
 			foreach ($alldata as $number) {
1548 1755
 				$this->addStatAircraftRegistration($number['registration'],$number['aircraft_registration_count'],$number['aircraft_icao'],'','',$reset);
1549 1756
 			}
1550
-			if ($globalDebug) echo 'Count all callsigns...'."\n";
1757
+			if ($globalDebug) {
1758
+				echo 'Count all callsigns...'."\n";
1759
+			}
1551 1760
 			$alldata = $Spotter->countAllCallsigns(false,0,$last_update_day);
1552 1761
 			foreach ($alldata as $number) {
1553 1762
 				$this->addStatCallsign($number['callsign_icao'],$number['callsign_icao_count'],$number['airline_icao'],'',$reset);
1554 1763
 			}
1555
-			if ($globalDebug) echo 'Count all owners...'."\n";
1764
+			if ($globalDebug) {
1765
+				echo 'Count all owners...'."\n";
1766
+			}
1556 1767
 			$alldata = $Spotter->countAllOwners(false,0,$last_update_day);
1557 1768
 			foreach ($alldata as $number) {
1558 1769
 				$this->addStatOwner($number['owner_name'],$number['owner_count'],'','',$reset);
1559 1770
 			}
1560
-			if ($globalDebug) echo 'Count all pilots...'."\n";
1771
+			if ($globalDebug) {
1772
+				echo 'Count all pilots...'."\n";
1773
+			}
1561 1774
 			$alldata = $Spotter->countAllPilots(false,0,$last_update_day);
1562 1775
 			foreach ($alldata as $number) {
1563 1776
 				$this->addStatPilot($number['pilot_id'],$number['pilot_count'],$number['pilot_name'],'','',$number['format_source'],$reset);
1564 1777
 			}
1565 1778
 			
1566
-			if ($globalDebug) echo 'Count all departure airports...'."\n";
1779
+			if ($globalDebug) {
1780
+				echo 'Count all departure airports...'."\n";
1781
+			}
1567 1782
 			$pall = $Spotter->countAllDepartureAirports(false,0,$last_update_day);
1568
-			if ($globalDebug) echo 'Count all detected departure airports...'."\n";
1783
+			if ($globalDebug) {
1784
+				echo 'Count all detected departure airports...'."\n";
1785
+			}
1569 1786
         		$dall = $Spotter->countAllDetectedDepartureAirports(false,0,$last_update_day);
1570
-			if ($globalDebug) echo 'Order departure airports...'."\n";
1787
+			if ($globalDebug) {
1788
+				echo 'Order departure airports...'."\n";
1789
+			}
1571 1790
 	        	$alldata = array();
1572 1791
 	        	
1573 1792
     			foreach ($pall as $value) {
@@ -1578,7 +1797,9 @@  discard block
 block discarded – undo
1578 1797
     				$icao = $value['airport_departure_icao'];
1579 1798
         			if (isset($alldata[$icao])) {
1580 1799
     					$alldata[$icao]['airport_departure_icao_count'] = $alldata[$icao]['airport_departure_icao_count'] + $value['airport_departure_icao_count'];
1581
-        			} else $alldata[$icao] = $value;
1800
+        			} else {
1801
+        				$alldata[$icao] = $value;
1802
+        			}
1582 1803
 			}
1583 1804
     			$count = array();
1584 1805
     			foreach ($alldata as $key => $row) {
@@ -1588,11 +1809,17 @@  discard block
 block discarded – undo
1588 1809
 			foreach ($alldata as $number) {
1589 1810
 				echo $this->addStatDepartureAirports($number['airport_departure_icao'],$number['airport_departure_name'],$number['airport_departure_city'],$number['airport_departure_country'],$number['airport_departure_icao_count'],'','',$reset);
1590 1811
 			}
1591
-			if ($globalDebug) echo 'Count all arrival airports...'."\n";
1812
+			if ($globalDebug) {
1813
+				echo 'Count all arrival airports...'."\n";
1814
+			}
1592 1815
 			$pall = $Spotter->countAllArrivalAirports(false,0,$last_update_day);
1593
-			if ($globalDebug) echo 'Count all detected arrival airports...'."\n";
1816
+			if ($globalDebug) {
1817
+				echo 'Count all detected arrival airports...'."\n";
1818
+			}
1594 1819
         		$dall = $Spotter->countAllDetectedArrivalAirports(false,0,$last_update_day);
1595
-			if ($globalDebug) echo 'Order arrival airports...'."\n";
1820
+			if ($globalDebug) {
1821
+				echo 'Order arrival airports...'."\n";
1822
+			}
1596 1823
 	        	$alldata = array();
1597 1824
     			foreach ($pall as $value) {
1598 1825
 	        		$icao = $value['airport_arrival_icao'];
@@ -1602,7 +1829,9 @@  discard block
 block discarded – undo
1602 1829
     				$icao = $value['airport_arrival_icao'];
1603 1830
         			if (isset($alldata[$icao])) {
1604 1831
         				$alldata[$icao]['airport_arrival_icao_count'] = $alldata[$icao]['airport_arrival_icao_count'] + $value['airport_arrival_icao_count'];
1605
-	        		} else $alldata[$icao] = $value;
1832
+	        		} else {
1833
+	        			$alldata[$icao] = $value;
1834
+	        		}
1606 1835
     			}
1607 1836
         		$count = array();
1608 1837
         		foreach ($alldata as $key => $row) {
@@ -1613,7 +1842,9 @@  discard block
 block discarded – undo
1613 1842
 				echo $this->addStatArrivalAirports($number['airport_arrival_icao'],$number['airport_arrival_name'],$number['airport_arrival_city'],$number['airport_arrival_country'],$number['airport_arrival_icao_count'],'','',$reset);
1614 1843
 			}
1615 1844
 			if ($Connection->tableExists('countries')) {
1616
-				if ($globalDebug) echo 'Count all flights by countries...'."\n";
1845
+				if ($globalDebug) {
1846
+					echo 'Count all flights by countries...'."\n";
1847
+				}
1617 1848
 				$SpotterArchive = new SpotterArchive();
1618 1849
 				$alldata = $SpotterArchive->countAllFlightOverCountries(false,0,$last_update_day);
1619 1850
 				foreach ($alldata as $number) {
@@ -1621,7 +1852,9 @@  discard block
 block discarded – undo
1621 1852
 				}
1622 1853
 			}
1623 1854
 			
1624
-			if ($globalDebug) echo 'Count fatalities stats...'."\n";
1855
+			if ($globalDebug) {
1856
+				echo 'Count fatalities stats...'."\n";
1857
+			}
1625 1858
 			$Accident = new Accident();
1626 1859
 			$this->deleteStatsByType('fatalities_byyear');
1627 1860
 			$alldata = $Accident->countFatalitiesByYear();
@@ -1638,46 +1871,66 @@  discard block
 block discarded – undo
1638 1871
 			// Add by month using getstat if month finish...
1639 1872
 
1640 1873
 			//if (date('m',strtotime($last_update_day)) != date('m')) {
1641
-			if ($globalDebug) echo 'Count all flights by months...'."\n";
1874
+			if ($globalDebug) {
1875
+				echo 'Count all flights by months...'."\n";
1876
+			}
1642 1877
 			$Spotter = new Spotter($this->db);
1643 1878
 			$alldata = $Spotter->countAllMonths();
1644 1879
 			$lastyear = false;
1645 1880
 			foreach ($alldata as $number) {
1646
-				if ($number['year_name'] != date('Y')) $lastyear = true;
1881
+				if ($number['year_name'] != date('Y')) {
1882
+					$lastyear = true;
1883
+				}
1647 1884
 				$this->addStat('flights_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])));
1648 1885
 			}
1649
-			if ($globalDebug) echo 'Count all military flights by months...'."\n";
1886
+			if ($globalDebug) {
1887
+				echo 'Count all military flights by months...'."\n";
1888
+			}
1650 1889
 			$alldata = $Spotter->countAllMilitaryMonths();
1651 1890
 			foreach ($alldata as $number) {
1652 1891
 				$this->addStat('military_flights_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])));
1653 1892
 			}
1654
-			if ($globalDebug) echo 'Count all owners by months...'."\n";
1893
+			if ($globalDebug) {
1894
+				echo 'Count all owners by months...'."\n";
1895
+			}
1655 1896
 			$alldata = $Spotter->countAllMonthsOwners();
1656 1897
 			foreach ($alldata as $number) {
1657 1898
 				$this->addStat('owners_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])));
1658 1899
 			}
1659
-			if ($globalDebug) echo 'Count all pilots by months...'."\n";
1900
+			if ($globalDebug) {
1901
+				echo 'Count all pilots by months...'."\n";
1902
+			}
1660 1903
 			$alldata = $Spotter->countAllMonthsPilots();
1661 1904
 			foreach ($alldata as $number) {
1662 1905
 				$this->addStat('pilots_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])));
1663 1906
 			}
1664
-			if ($globalDebug) echo 'Count all airlines by months...'."\n";
1907
+			if ($globalDebug) {
1908
+				echo 'Count all airlines by months...'."\n";
1909
+			}
1665 1910
 			$alldata = $Spotter->countAllMonthsAirlines();
1666 1911
 			foreach ($alldata as $number) {
1667 1912
 				$this->addStat('airlines_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])));
1668 1913
 			}
1669
-			if ($globalDebug) echo 'Count all aircrafts by months...'."\n";
1914
+			if ($globalDebug) {
1915
+				echo 'Count all aircrafts by months...'."\n";
1916
+			}
1670 1917
 			$alldata = $Spotter->countAllMonthsAircrafts();
1671 1918
 			foreach ($alldata as $number) {
1672 1919
 				$this->addStat('aircrafts_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])));
1673 1920
 			}
1674
-			if ($globalDebug) echo 'Count all real arrivals by months...'."\n";
1921
+			if ($globalDebug) {
1922
+				echo 'Count all real arrivals by months...'."\n";
1923
+			}
1675 1924
 			$alldata = $Spotter->countAllMonthsRealArrivals();
1676 1925
 			foreach ($alldata as $number) {
1677 1926
 				$this->addStat('realarrivals_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])));
1678 1927
 			}
1679
-			if ($globalDebug) echo 'Airports data...'."\n";
1680
-			if ($globalDebug) echo '...Departure'."\n";
1928
+			if ($globalDebug) {
1929
+				echo 'Airports data...'."\n";
1930
+			}
1931
+			if ($globalDebug) {
1932
+				echo '...Departure'."\n";
1933
+			}
1681 1934
 			$this->deleteStatAirport('daily');
1682 1935
 //			$pall = $Spotter->getLast7DaysAirportsDeparture();
1683 1936
   //      		$dall = $Spotter->getLast7DaysDetectedAirportsDeparture();
@@ -1798,44 +2051,62 @@  discard block
 block discarded – undo
1798 2051
 			// Count by airlines
1799 2052
 			echo '--- Stats by airlines ---'."\n";
1800 2053
 			if ($Connection->tableExists('countries')) {
1801
-				if ($globalDebug) echo 'Count all flights by countries by airlines...'."\n";
2054
+				if ($globalDebug) {
2055
+					echo 'Count all flights by countries by airlines...'."\n";
2056
+				}
1802 2057
 				$SpotterArchive = new SpotterArchive();
1803 2058
 				$alldata = $SpotterArchive->countAllFlightOverCountriesByAirlines(false,0,$last_update_day);
1804 2059
 				foreach ($alldata as $number) {
1805 2060
 					$this->addStatCountry($number['flight_country_iso2'],$number['flight_country_iso3'],$number['flight_country'],$number['flight_count'],$number['airline_icao'],'',$reset);
1806 2061
 				}
1807 2062
 			}
1808
-			if ($globalDebug) echo 'Count all aircraft types by airlines...'."\n";
2063
+			if ($globalDebug) {
2064
+				echo 'Count all aircraft types by airlines...'."\n";
2065
+			}
1809 2066
 			$Spotter = new Spotter($this->db);
1810 2067
 			$alldata = $Spotter->countAllAircraftTypesByAirlines(false,0,$last_update_day);
1811 2068
 			foreach ($alldata as $number) {
1812 2069
 				$this->addStatAircraft($number['aircraft_icao'],$number['aircraft_icao_count'],$number['aircraft_name'],$number['aircraft_manufacturer'],$number['airline_icao'],'',$reset);
1813 2070
 			}
1814
-			if ($globalDebug) echo 'Count all aircraft registrations by airlines...'."\n";
2071
+			if ($globalDebug) {
2072
+				echo 'Count all aircraft registrations by airlines...'."\n";
2073
+			}
1815 2074
 			$alldata = $Spotter->countAllAircraftRegistrationsByAirlines(false,0,$last_update_day);
1816 2075
 			foreach ($alldata as $number) {
1817 2076
 				$this->addStatAircraftRegistration($number['registration'],$number['aircraft_registration_count'],$number['aircraft_icao'],$number['airline_icao'],'',$reset);
1818 2077
 			}
1819
-			if ($globalDebug) echo 'Count all callsigns by airlines...'."\n";
2078
+			if ($globalDebug) {
2079
+				echo 'Count all callsigns by airlines...'."\n";
2080
+			}
1820 2081
 			$alldata = $Spotter->countAllCallsignsByAirlines(false,0,$last_update_day);
1821 2082
 			foreach ($alldata as $number) {
1822 2083
 				$this->addStatCallsign($number['callsign_icao'],$number['callsign_icao_count'],$number['airline_icao'],'',$reset);
1823 2084
 			}
1824
-			if ($globalDebug) echo 'Count all owners by airlines...'."\n";
2085
+			if ($globalDebug) {
2086
+				echo 'Count all owners by airlines...'."\n";
2087
+			}
1825 2088
 			$alldata = $Spotter->countAllOwnersByAirlines(false,0,$last_update_day);
1826 2089
 			foreach ($alldata as $number) {
1827 2090
 				$this->addStatOwner($number['owner_name'],$number['owner_count'],$number['airline_icao'],'',$reset);
1828 2091
 			}
1829
-			if ($globalDebug) echo 'Count all pilots by airlines...'."\n";
2092
+			if ($globalDebug) {
2093
+				echo 'Count all pilots by airlines...'."\n";
2094
+			}
1830 2095
 			$alldata = $Spotter->countAllPilotsByAirlines(false,0,$last_update_day);
1831 2096
 			foreach ($alldata as $number) {
1832 2097
 				$this->addStatPilot($number['pilot_id'],$number['pilot_count'],$number['pilot_name'],$number['airline_icao'],'',$number['format_source'],$reset);
1833 2098
 			}
1834
-			if ($globalDebug) echo 'Count all departure airports by airlines...'."\n";
2099
+			if ($globalDebug) {
2100
+				echo 'Count all departure airports by airlines...'."\n";
2101
+			}
1835 2102
 			$pall = $Spotter->countAllDepartureAirportsByAirlines(false,0,$last_update_day);
1836
-			if ($globalDebug) echo 'Count all detected departure airports by airlines...'."\n";
2103
+			if ($globalDebug) {
2104
+				echo 'Count all detected departure airports by airlines...'."\n";
2105
+			}
1837 2106
        			$dall = $Spotter->countAllDetectedDepartureAirportsByAirlines(false,0,$last_update_day);
1838
-			if ($globalDebug) echo 'Order detected departure airports by airlines...'."\n";
2107
+			if ($globalDebug) {
2108
+				echo 'Order detected departure airports by airlines...'."\n";
2109
+			}
1839 2110
 	        	//$alldata = array();
1840 2111
     			foreach ($dall as $value) {
1841 2112
     				$icao = $value['airport_departure_icao'];
@@ -1856,11 +2127,17 @@  discard block
 block discarded – undo
1856 2127
 			foreach ($alldata as $number) {
1857 2128
 				echo $this->addStatDepartureAirports($number['airport_departure_icao'],$number['airport_departure_name'],$number['airport_departure_city'],$number['airport_departure_country'],$number['airport_departure_icao_count'],$number['airline_icao'],'',$reset);
1858 2129
 			}
1859
-			if ($globalDebug) echo 'Count all arrival airports by airlines...'."\n";
2130
+			if ($globalDebug) {
2131
+				echo 'Count all arrival airports by airlines...'."\n";
2132
+			}
1860 2133
 			$pall = $Spotter->countAllArrivalAirportsByAirlines(false,0,$last_update_day);
1861
-			if ($globalDebug) echo 'Count all detected arrival airports by airlines...'."\n";
2134
+			if ($globalDebug) {
2135
+				echo 'Count all detected arrival airports by airlines...'."\n";
2136
+			}
1862 2137
         		$dall = $Spotter->countAllDetectedArrivalAirportsByAirlines(false,0,$last_update_day);
1863
-			if ($globalDebug) echo 'Order arrival airports by airlines...'."\n";
2138
+			if ($globalDebug) {
2139
+				echo 'Order arrival airports by airlines...'."\n";
2140
+			}
1864 2141
 	        	//$alldata = array();
1865 2142
     			foreach ($dall as $value) {
1866 2143
     				$icao = $value['airport_arrival_icao'];
@@ -1879,37 +2156,53 @@  discard block
 block discarded – undo
1879 2156
     			}
1880 2157
     			$alldata = $pall;
1881 2158
                         foreach ($alldata as $number) {
1882
-				if ($number['airline_icao'] != '') echo $this->addStatArrivalAirports($number['airport_arrival_icao'],$number['airport_arrival_name'],$number['airport_arrival_city'],$number['airport_arrival_country'],$number['airport_arrival_icao_count'],$number['airline_icao'],'',$reset);
2159
+				if ($number['airline_icao'] != '') {
2160
+					echo $this->addStatArrivalAirports($number['airport_arrival_icao'],$number['airport_arrival_name'],$number['airport_arrival_city'],$number['airport_arrival_country'],$number['airport_arrival_icao_count'],$number['airline_icao'],'',$reset);
2161
+				}
2162
+			}
2163
+			if ($globalDebug) {
2164
+				echo 'Count all flights by months by airlines...'."\n";
1883 2165
 			}
1884
-			if ($globalDebug) echo 'Count all flights by months by airlines...'."\n";
1885 2166
 			$Spotter = new Spotter($this->db);
1886 2167
 			$alldata = $Spotter->countAllMonthsByAirlines();
1887 2168
 			$lastyear = false;
1888 2169
 			foreach ($alldata as $number) {
1889
-				if ($number['year_name'] != date('Y')) $lastyear = true;
2170
+				if ($number['year_name'] != date('Y')) {
2171
+					$lastyear = true;
2172
+				}
1890 2173
 				$this->addStat('flights_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])),$number['airline_icao']);
1891 2174
 			}
1892
-			if ($globalDebug) echo 'Count all owners by months by airlines...'."\n";
2175
+			if ($globalDebug) {
2176
+				echo 'Count all owners by months by airlines...'."\n";
2177
+			}
1893 2178
 			$alldata = $Spotter->countAllMonthsOwnersByAirlines();
1894 2179
 			foreach ($alldata as $number) {
1895 2180
 				$this->addStat('owners_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])),$number['airline_icao']);
1896 2181
 			}
1897
-			if ($globalDebug) echo 'Count all pilots by months by airlines...'."\n";
2182
+			if ($globalDebug) {
2183
+				echo 'Count all pilots by months by airlines...'."\n";
2184
+			}
1898 2185
 			$alldata = $Spotter->countAllMonthsPilotsByAirlines();
1899 2186
 			foreach ($alldata as $number) {
1900 2187
 				$this->addStat('pilots_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])),$number['airline_icao']);
1901 2188
 			}
1902
-			if ($globalDebug) echo 'Count all aircrafts by months by airlines...'."\n";
2189
+			if ($globalDebug) {
2190
+				echo 'Count all aircrafts by months by airlines...'."\n";
2191
+			}
1903 2192
 			$alldata = $Spotter->countAllMonthsAircraftsByAirlines();
1904 2193
 			foreach ($alldata as $number) {
1905 2194
 				$this->addStat('aircrafts_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])),$number['airline_icao']);
1906 2195
 			}
1907
-			if ($globalDebug) echo 'Count all real arrivals by months by airlines...'."\n";
2196
+			if ($globalDebug) {
2197
+				echo 'Count all real arrivals by months by airlines...'."\n";
2198
+			}
1908 2199
 			$alldata = $Spotter->countAllMonthsRealArrivalsByAirlines();
1909 2200
 			foreach ($alldata as $number) {
1910 2201
 				$this->addStat('realarrivals_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])),$number['airline_icao']);
1911 2202
 			}
1912
-			if ($globalDebug) echo '...Departure'."\n";
2203
+			if ($globalDebug) {
2204
+				echo '...Departure'."\n";
2205
+			}
1913 2206
 			$pall = $Spotter->getLast7DaysAirportsDepartureByAirlines();
1914 2207
         		$dall = $Spotter->getLast7DaysDetectedAirportsDepartureByAirlines();
1915 2208
     			foreach ($dall as $value) {
@@ -1932,7 +2225,9 @@  discard block
 block discarded – undo
1932 2225
 			foreach ($alldata as $number) {
1933 2226
 				$this->addStatDepartureAirportsDaily($number['date'],$number['departure_airport_icao'],$number['departure_airport_name'],$number['departure_airport_city'],$number['departure_airport_country'],$number['departure_airport_count'],$number['airline_icao']);
1934 2227
 			}
1935
-			if ($globalDebug) echo '...Arrival'."\n";
2228
+			if ($globalDebug) {
2229
+				echo '...Arrival'."\n";
2230
+			}
1936 2231
 			$pall = $Spotter->getLast7DaysAirportsArrivalByAirlines();
1937 2232
         		$dall = $Spotter->getLast7DaysDetectedAirportsArrivalByAirlines();
1938 2233
     			foreach ($dall as $value) {
@@ -1956,13 +2251,19 @@  discard block
 block discarded – undo
1956 2251
 				$this->addStatArrivalAirportsDaily($number['date'],$number['arrival_airport_icao'],$number['arrival_airport_name'],$number['arrival_airport_city'],$number['arrival_airport_country'],$number['arrival_airport_count'],$number['airline_icao']);
1957 2252
 			}
1958 2253
 
1959
-			if ($globalDebug) echo 'Flights data...'."\n";
1960
-			if ($globalDebug) echo '-> countAllDatesLastMonth...'."\n";
2254
+			if ($globalDebug) {
2255
+				echo 'Flights data...'."\n";
2256
+			}
2257
+			if ($globalDebug) {
2258
+				echo '-> countAllDatesLastMonth...'."\n";
2259
+			}
1961 2260
 			$alldata = $Spotter->countAllDatesLastMonthByAirlines();
1962 2261
 			foreach ($alldata as $number) {
1963 2262
 				$this->addStatFlight('month',$number['date_name'],$number['date_count'], $number['airline_icao']);
1964 2263
 			}
1965
-			if ($globalDebug) echo '-> countAllDates...'."\n";
2264
+			if ($globalDebug) {
2265
+				echo '-> countAllDates...'."\n";
2266
+			}
1966 2267
 			//$previousdata = $this->countAllDatesByAirlines();
1967 2268
 			$alldata = $Common->array_merge_noappend($previousdatabyairlines,$Spotter->countAllDatesByAirlines());
1968 2269
 			$values = array();
@@ -1975,7 +2276,9 @@  discard block
 block discarded – undo
1975 2276
 				$this->addStatFlight('date',$number['date_name'],$number['date_count'],$number['airline_icao']);
1976 2277
 			}
1977 2278
 			
1978
-			if ($globalDebug) echo '-> countAllHours...'."\n";
2279
+			if ($globalDebug) {
2280
+				echo '-> countAllHours...'."\n";
2281
+			}
1979 2282
 			$alldata = $Spotter->countAllHoursByAirlines('hour');
1980 2283
 			foreach ($alldata as $number) {
1981 2284
 				$this->addStatFlight('hour',$number['hour_name'],$number['hour_count'],$number['airline_icao']);
@@ -1983,14 +2286,18 @@  discard block
 block discarded – undo
1983 2286
 			
1984 2287
 
1985 2288
 			// Stats by filters
1986
-			if (!isset($globalStatsFilters) || $globalStatsFilters == '') $globalStatsFilters = array();
2289
+			if (!isset($globalStatsFilters) || $globalStatsFilters == '') {
2290
+				$globalStatsFilters = array();
2291
+			}
1987 2292
 			foreach ($globalStatsFilters as $name => $filter) {
1988 2293
 				//$filter_name = $filter['name'];
1989 2294
 				$filter_name = $name;
1990 2295
 				$reset = false;
1991 2296
 				$last_update = $this->getLastStatsUpdate('last_update_stats_'.$filter_name);
1992 2297
 				if (isset($filter['resetall']) && isset($last_update[0]['value']) && strtotime($filter['resetall']) > strtotime($last_update[0]['value'])) {
1993
-					if ($globalDebug) echo '!!! Delete stats for filter '.$filter_name.' !!!'."\n";
2298
+					if ($globalDebug) {
2299
+						echo '!!! Delete stats for filter '.$filter_name.' !!!'."\n";
2300
+					}
1994 2301
 					$this->deleteOldStats($filter_name);
1995 2302
 					unset($last_update);
1996 2303
 				}
@@ -2009,7 +2316,9 @@  discard block
 block discarded – undo
2009 2316
 				
2010 2317
 
2011 2318
 				// Count by filter
2012
-				if ($globalDebug) echo '--- Stats for filter '.$filter_name.' ---'."\n";
2319
+				if ($globalDebug) {
2320
+					echo '--- Stats for filter '.$filter_name.' ---'."\n";
2321
+				}
2013 2322
 				$Spotter = new Spotter($this->db);
2014 2323
 				$alldata = $Spotter->countAllAircraftTypes(false,0,$last_update_day,$filter);
2015 2324
 				foreach ($alldata as $number) {
@@ -2046,7 +2355,9 @@  discard block
 block discarded – undo
2046 2355
 	    				$icao = $value['airport_departure_icao'];
2047 2356
         				if (isset($alldata[$icao])) {
2048 2357
     						$alldata[$icao]['airport_departure_icao_count'] = $alldata[$icao]['airport_departure_icao_count'] + $value['airport_departure_icao_count'];
2049
-        				} else $alldata[$icao] = $value;
2358
+        				} else {
2359
+        					$alldata[$icao] = $value;
2360
+        				}
2050 2361
 				}
2051 2362
 	    			$count = array();
2052 2363
     				foreach ($alldata as $key => $row) {
@@ -2067,7 +2378,9 @@  discard block
 block discarded – undo
2067 2378
 	    				$icao = $value['airport_arrival_icao'];
2068 2379
         				if (isset($alldata[$icao])) {
2069 2380
         					$alldata[$icao]['airport_arrival_icao_count'] = $alldata[$icao]['airport_arrival_icao_count'] + $value['airport_arrival_icao_count'];
2070
-		        		} else $alldata[$icao] = $value;
2381
+		        		} else {
2382
+		        			$alldata[$icao] = $value;
2383
+		        		}
2071 2384
 	    			}
2072 2385
         			$count = array();
2073 2386
         			foreach ($alldata as $key => $row) {
@@ -2081,7 +2394,9 @@  discard block
 block discarded – undo
2081 2394
 				$alldata = $Spotter->countAllMonths($filter);
2082 2395
 				$lastyear = false;
2083 2396
 				foreach ($alldata as $number) {
2084
-					if ($number['year_name'] != date('Y')) $lastyear = true;
2397
+					if ($number['year_name'] != date('Y')) {
2398
+						$lastyear = true;
2399
+					}
2085 2400
 					$this->addStat('flights_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])),'',$filter_name);
2086 2401
 				}
2087 2402
 				$alldata = $Spotter->countAllMonthsOwners($filter);
Please login to merge, or discard this patch.