Ysurac /
FlightAirMap
| Conditions | 142 |
| Paths | 0 |
| Total Lines | 873 |
| Code Lines | 453 |
| Lines | 0 |
| Ratio | 0 % |
| Changes | 0 | ||
Small methods make your code easier to understand, in particular if combined with a good name. Besides, if your method is small, finding a good name is usually much easier.
For example, if you find yourself adding comments to a method's body, this is usually a good sign to extract the commented part to a new method, and use the comment as a starting point when coming up with a good name for this new method.
Commonly applied refactorings include:
If many parameters/temporary variables are present:
| 1 | <?php |
||
| 1084 | public function addOldStats() { |
||
| 1085 | global $globalArchiveMonths, $globalArchive, $globalArchiveYear, $globalDBdriver, $globalStatsFilters; |
||
| 1086 | $Common = new Common(); |
||
| 1087 | $Connection = new Connection(); |
||
| 1088 | date_default_timezone_set('UTC'); |
||
| 1089 | $last_update = $this->getLastStatsUpdate('last_update_stats'); |
||
| 1090 | //print_r($last_update); |
||
| 1091 | /* |
||
| 1092 | $flightsbymonth = $this->getStats('flights_by_month'); |
||
| 1093 | if (empty($last_update) && empty($flightsbymonth)) { |
||
| 1094 | // Initial update |
||
| 1095 | $Spotter = new Spotter($this->db); |
||
| 1096 | $alldata = $Spotter->countAllMonths(); |
||
| 1097 | $lastyear = false; |
||
| 1098 | foreach ($alldata as $number) { |
||
| 1099 | if ($number['year_name'] != date('Y')) $lastyear = true; |
||
| 1100 | $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']))); |
||
| 1101 | } |
||
| 1102 | $alldata = $Spotter->countAllMilitaryMonths(); |
||
| 1103 | //$lastyear = false; |
||
| 1104 | foreach ($alldata as $number) { |
||
| 1105 | if ($number['year_name'] != date('Y')) $lastyear = true; |
||
| 1106 | $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']))); |
||
| 1107 | } |
||
| 1108 | $alldata = $Spotter->countAllMonthsOwners(); |
||
| 1109 | foreach ($alldata as $number) { |
||
| 1110 | $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']))); |
||
| 1111 | } |
||
| 1112 | $alldata = $Spotter->countAllMonthsPilots(); |
||
| 1113 | foreach ($alldata as $number) { |
||
| 1114 | $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']))); |
||
| 1115 | } |
||
| 1116 | $alldata = $Spotter->countAllMonthsAirlines(); |
||
| 1117 | foreach ($alldata as $number) { |
||
| 1118 | $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']))); |
||
| 1119 | } |
||
| 1120 | $alldata = $Spotter->countAllMonthsAircrafts(); |
||
| 1121 | foreach ($alldata as $number) { |
||
| 1122 | $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']))); |
||
| 1123 | } |
||
| 1124 | $alldata = $Spotter->countAllMonthsRealArrivals(); |
||
| 1125 | foreach ($alldata as $number) { |
||
| 1126 | $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']))); |
||
| 1127 | } |
||
| 1128 | $this->deleteStatFlight('month'); |
||
| 1129 | $alldata = $Spotter->countAllDatesLastMonth(); |
||
| 1130 | foreach ($alldata as $number) { |
||
| 1131 | $this->addStatFlight('month',$number['date_name'],$number['date_count']); |
||
| 1132 | } |
||
| 1133 | $previousdata = $this->countAllDates(); |
||
| 1134 | $this->deleteStatFlight('date'); |
||
| 1135 | $alldata = $Common->array_merge_noappend($previousdata,$Spotter->countAllDates()); |
||
| 1136 | $values = array(); |
||
| 1137 | foreach ($alldata as $cnt) { |
||
| 1138 | $values[] = $cnt['date_count']; |
||
| 1139 | } |
||
| 1140 | array_multisort($values,SORT_DESC,$alldata); |
||
| 1141 | array_splice($alldata,11); |
||
| 1142 | foreach ($alldata as $number) { |
||
| 1143 | $this->addStatFlight('date',$number['date_name'],$number['date_count']); |
||
| 1144 | } |
||
| 1145 | $this->deleteStatFlight('hour'); |
||
| 1146 | $alldata = $Spotter->countAllHours('hour'); |
||
| 1147 | foreach ($alldata as $number) { |
||
| 1148 | $this->addStatFlight('hour',$number['hour_name'],$number['hour_count']); |
||
| 1149 | } |
||
| 1150 | if ($lastyear) { |
||
| 1151 | $monthsSinceLastYear = date('n'); |
||
| 1152 | $alldata = $Spotter->countAllAircraftTypes(false,$monthsSinceLastYear); |
||
| 1153 | foreach ($alldata as $number) { |
||
| 1154 | $this->addStatAircraft($number['aircraft_icao'],$number['aircraft_icao_count'],$number['aircraft_name'],$number['aircraft_manufacturer']); |
||
| 1155 | } |
||
| 1156 | $alldata = $Spotter->countAllAirlines(false,$monthsSinceLastYear); |
||
| 1157 | foreach ($alldata as $number) { |
||
| 1158 | $this->addStatAirline($number['airline_icao'],$number['airline_count'],$number['airline_name']); |
||
| 1159 | } |
||
| 1160 | if ($Connection->tableExists('countries')) { |
||
| 1161 | $alldata = $Spotter->countAllFlightOverCountries(false,$monthsSinceLastYear); |
||
| 1162 | foreach ($alldata as $number) { |
||
| 1163 | $this->addStatCountry($number['flight_country_iso2'],$number['flight_country_iso3'],$number['flight_country'],$number['flight_count']); |
||
| 1164 | } |
||
| 1165 | } |
||
| 1166 | $alldata = $Spotter->countAllOwners(false,$monthsSinceLastYear); |
||
| 1167 | foreach ($alldata as $number) { |
||
| 1168 | $this->addStatOwner($number['owner_name'],$number['owner_count']); |
||
| 1169 | } |
||
| 1170 | $alldata = $Spotter->countAllPilots(false,$monthsSinceLastYear); |
||
| 1171 | foreach ($alldata as $number) { |
||
| 1172 | $this->addStatPilot($number['pilot_id'],$number['pilot_count'],$number['pilot_name']); |
||
| 1173 | } |
||
| 1174 | $previous_year = date('Y'); |
||
| 1175 | $previous_year--; |
||
| 1176 | $this->addStat('aircrafts_byyear',$this->getStatsAircraftTotal(),$previous_year.'-01-01 00:00:00'); |
||
| 1177 | $this->addStat('airlines_byyear',$this->getStatsAirlineTotal(),$previous_year.'-01-01 00:00:00'); |
||
| 1178 | $this->addStat('owner_byyear',$this->getStatsOwnerTotal(),$previous_year.'-01-01 00:00:00'); |
||
| 1179 | $this->addStat('pilot_byyear',$this->getStatsPilotTotal(),$previous_year.'-01-01 00:00:00'); |
||
| 1180 | |||
| 1181 | if (isset($globalArchiveYear) && $globalArchiveYear) { |
||
| 1182 | if ($globalArchive) { |
||
| 1183 | $query = "INSERT INTO spotter_archive_output SELECT * FROM spotter_output WHERE spotter_output.date < '".date('Y')."-01-01 00:00:00'"; |
||
| 1184 | //echo $query; |
||
| 1185 | try { |
||
| 1186 | $sth = $this->db->prepare($query); |
||
| 1187 | $sth->execute(); |
||
| 1188 | } catch(PDOException $e) { |
||
| 1189 | return "error : ".$e->getMessage().' - query : '.$query."\n"; |
||
| 1190 | } |
||
| 1191 | } |
||
| 1192 | $query = "DELETE FROM spotter_output WHERE spotter_output.date < '".date('Y')."-01-01 00:00:00'"; |
||
| 1193 | try { |
||
| 1194 | $sth = $this->db->prepare($query); |
||
| 1195 | $sth->execute(); |
||
| 1196 | } catch(PDOException $e) { |
||
| 1197 | return "error : ".$e->getMessage().' - query : '.$query."\n"; |
||
| 1198 | } |
||
| 1199 | } |
||
| 1200 | } |
||
| 1201 | if (!isset($globalArchiveMonths) || $globalArchiveMonths == '') $globalArchiveMonths = 2; |
||
| 1202 | if ($globalArchiveMonths > 0) { |
||
| 1203 | $alldata = $Spotter->countAllAircraftTypes(false,$globalArchiveMonths); |
||
| 1204 | foreach ($alldata as $number) { |
||
| 1205 | $this->addStatAircraft($number['aircraft_icao'],$number['aircraft_icao_count'],$number['aircraft_name'],$number['aircraft_manufacturer']); |
||
| 1206 | } |
||
| 1207 | $alldata = $Spotter->countAllAirlines(false,$globalArchiveMonths); |
||
| 1208 | foreach ($alldata as $number) { |
||
| 1209 | $this->addStatAirline($number['airline_icao'],$number['airline_count'],$number['airline_name']); |
||
| 1210 | } |
||
| 1211 | $alldata = $Spotter->countAllAircraftRegistrations(false,$globalArchiveMonths); |
||
| 1212 | foreach ($alldata as $number) { |
||
| 1213 | $this->addStatAircraftRegistration($number['registration'],$number['aircraft_registration_count'],$number['aircraft_icao']); |
||
| 1214 | } |
||
| 1215 | $alldata = $Spotter->countAllCallsigns(false,$globalArchiveMonths); |
||
| 1216 | foreach ($alldata as $number) { |
||
| 1217 | $this->addStatCallsign($number['callsign_icao'],$number['callsign_icao_count'],$number['airline_icao']); |
||
| 1218 | } |
||
| 1219 | $alldata = $Spotter->countAllOwners(false,$globalArchiveMonths); |
||
| 1220 | foreach ($alldata as $number) { |
||
| 1221 | $this->addStatOwner($number['owner_name'],$number['owner_count']); |
||
| 1222 | } |
||
| 1223 | if ($Connection->tableExists('countries')) { |
||
| 1224 | $alldata = $Spotter->countAllFlightOverCountries(false,$globalArchiveMonths); |
||
| 1225 | foreach ($alldata as $number) { |
||
| 1226 | $this->addStatCountry($number['flight_country_iso2'],$number['flight_country_iso3'],$number['flight_country'],$number['flight_count']); |
||
| 1227 | } |
||
| 1228 | } |
||
| 1229 | $alldata = $Spotter->countAllPilots(false,$globalArchiveMonths); |
||
| 1230 | foreach ($alldata as $number) { |
||
| 1231 | $this->addStatPilot($number['pilot_id'],$number['pilot_count'],$number['pilot_name']); |
||
| 1232 | } |
||
| 1233 | $pall = $Spotter->countAllDepartureAirports(false,$globalArchiveMonths); |
||
| 1234 | $dall = $Spotter->countAllDetectedDepartureAirports(false,$globalArchiveMonths); |
||
| 1235 | $alldata = array(); |
||
| 1236 | foreach ($pall as $value) { |
||
| 1237 | $icao = $value['airport_departure_icao']; |
||
| 1238 | $alldata[$icao] = $value; |
||
| 1239 | } |
||
| 1240 | foreach ($dall as $value) { |
||
| 1241 | $icao = $value['airport_departure_icao']; |
||
| 1242 | if (isset($alldata[$icao])) { |
||
| 1243 | $alldata[$icao]['airport_departure_icao_count'] = $alldata[$icao]['airport_departure_icao_count'] + $value['airport_departure_icao_count']; |
||
| 1244 | } else $alldata[$icao] = $value; |
||
| 1245 | } |
||
| 1246 | $count = array(); |
||
| 1247 | foreach ($alldata as $key => $row) { |
||
| 1248 | $count[$key] = $row['airport_departure_icao_count']; |
||
| 1249 | } |
||
| 1250 | array_multisort($count,SORT_DESC,$alldata); |
||
| 1251 | |||
| 1252 | //print_r($alldate); |
||
| 1253 | foreach ($alldata as $number) { |
||
| 1254 | $this->addStatDepartureAirports($number['airport_departure_icao'],$number['airport_departure_name'],$number['airport_departure_city'],$number['airport_departure_country'],$number['airport_departure_icao_count']); |
||
| 1255 | } |
||
| 1256 | $pdata = $Spotter->countAllArrivalAirports(false,$globalArchiveMonths); |
||
| 1257 | $dall = $Spotter->countAllDetectedArrivalAirports(false,$globalArchiveMonths); |
||
| 1258 | $alldata = array(); |
||
| 1259 | foreach ($pdata as $value) { |
||
| 1260 | $icao = $value['airport_arrival_icao']; |
||
| 1261 | $alldata[$icao] = $value; |
||
| 1262 | } |
||
| 1263 | foreach ($dall as $value) { |
||
| 1264 | $icao = $value['airport_arrival_icao']; |
||
| 1265 | if (isset($alldata[$icao])) { |
||
| 1266 | $alldata[$icao]['airport_arrival_icao_count'] = $alldata[$icao]['airport_arrival_icao_count'] + $value['airport_arrival_icao_count']; |
||
| 1267 | } else $alldata[$icao] = $value; |
||
| 1268 | } |
||
| 1269 | $count = array(); |
||
| 1270 | foreach ($alldata as $key => $row) { |
||
| 1271 | $count[$key] = $row['airport_arrival_icao_count']; |
||
| 1272 | } |
||
| 1273 | array_multisort($count,SORT_DESC,$alldata); |
||
| 1274 | foreach ($alldata as $number) { |
||
| 1275 | $this->addStatArrivalAirports($number['airport_arrival_icao'],$number['airport_arrival_name'],$number['airport_arrival_city'],$number['airport_arrival_country'],$number['airport_arrival_icao_count']); |
||
| 1276 | } |
||
| 1277 | $this->addStat('aircrafts_byyear',$this->getStatsAircraftTotal(),date('Y').'-01-01 00:00:00'); |
||
| 1278 | $this->addStat('airlines_byyear',$this->getStatsAirlineTotal(),date('Y').'-01-01 00:00:00'); |
||
| 1279 | $this->addStat('owner_byyear',$this->getStatsOwnerTotal(),date('Y').'-01-01 00:00:00'); |
||
| 1280 | $this->addStat('pilot_byyear',$this->getStatsPilotTotal(),date('Y').'-01-01 00:00:00'); |
||
| 1281 | |||
| 1282 | if ($globalArchive) { |
||
| 1283 | if ($globalDBdriver == 'mysql') { |
||
| 1284 | $query = "INSERT INTO spotter_archive_output SELECT * FROM spotter_output WHERE spotter_output.date < DATE_FORMAT(UTC_TIMESTAMP() - INTERVAL ".$globalArchiveMonths." MONTH, '%Y/%m/01')"; |
||
| 1285 | } else { |
||
| 1286 | $query = "INSERT INTO spotter_archive_output SELECT * FROM spotter_output WHERE spotter_output.date < CAST(to_char(CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalArchiveMonths." MONTHS', 'YYYY/mm/01') AS TIMESTAMP)"; |
||
| 1287 | } |
||
| 1288 | try { |
||
| 1289 | $sth = $this->db->prepare($query); |
||
| 1290 | $sth->execute(); |
||
| 1291 | } catch(PDOException $e) { |
||
| 1292 | return "error : ".$e->getMessage().' - query : '.$query."\n"; |
||
| 1293 | } |
||
| 1294 | } |
||
| 1295 | |||
| 1296 | //$query = 'DELETE FROM spotter_output WHERE spotter_output.date < DATE_SUB(UTC_TIMESTAMP(), INTERVAL '.$globalArchiveMonths.' MONTH)'; |
||
| 1297 | if ($globalDBdriver == 'mysql') { |
||
| 1298 | $query = "DELETE FROM spotter_output WHERE spotter_output.date < DATE_FORMAT(UTC_TIMESTAMP() - INTERVAL ".$globalArchiveMonths." MONTH, '%Y/%m/01')"; |
||
| 1299 | } else { |
||
| 1300 | $query = "DELETE FROM spotter_output WHERE spotter_output.date < CAST(to_char(CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalArchiveMonths." MONTHS, 'YYYY/mm/01') AS TIMESTAMP)"; |
||
| 1301 | } |
||
| 1302 | try { |
||
| 1303 | $sth = $this->db->prepare($query); |
||
| 1304 | $sth->execute(); |
||
| 1305 | } catch(PDOException $e) { |
||
| 1306 | return "error : ".$e->getMessage().' - query : '.$query."\n"; |
||
| 1307 | } |
||
| 1308 | } |
||
| 1309 | $this->addLastStatsUpdate('last_update_stats',date('Y-m-d G:i:s')); |
||
| 1310 | } else { |
||
| 1311 | */ |
||
| 1312 | echo 'Update stats !'."\n"; |
||
| 1313 | if (isset($last_update[0]['value'])) { |
||
| 1314 | $last_update_day = $last_update[0]['value']; |
||
| 1315 | } else $last_update_day = '2012-12-12 12:12:12'; |
||
| 1316 | $Spotter = new Spotter($this->db); |
||
| 1317 | $alldata = $Spotter->countAllAircraftTypes(false,0,$last_update_day); |
||
| 1318 | foreach ($alldata as $number) { |
||
| 1319 | $this->addStatAircraft($number['aircraft_icao'],$number['aircraft_icao_count'],$number['aircraft_name'],$number['aircraft_manufacturer']); |
||
| 1320 | } |
||
| 1321 | $alldata = $Spotter->countAllAirlines(false,0,$last_update_day); |
||
| 1322 | foreach ($alldata as $number) { |
||
| 1323 | $this->addStatAirline($number['airline_icao'],$number['airline_count'],$number['airline_name']); |
||
| 1324 | } |
||
| 1325 | $alldata = $Spotter->countAllAircraftRegistrations(false,0,$last_update_day); |
||
| 1326 | foreach ($alldata as $number) { |
||
| 1327 | $this->addStatAircraftRegistration($number['registration'],$number['aircraft_registration_count'],$number['aircraft_icao']); |
||
| 1328 | } |
||
| 1329 | $alldata = $Spotter->countAllCallsigns(false,0,$last_update_day); |
||
| 1330 | foreach ($alldata as $number) { |
||
| 1331 | $this->addStatCallsign($number['callsign_icao'],$number['callsign_icao_count'],$number['airline_icao']); |
||
| 1332 | } |
||
| 1333 | $alldata = $Spotter->countAllOwners(false,0,$last_update_day); |
||
| 1334 | foreach ($alldata as $number) { |
||
| 1335 | $this->addStatOwner($number['owner_name'],$number['owner_count']); |
||
| 1336 | } |
||
| 1337 | $alldata = $Spotter->countAllPilots(false,0,$last_update_day); |
||
| 1338 | foreach ($alldata as $number) { |
||
| 1339 | $this->addStatPilot($number['pilot_id'],$number['pilot_count'],$number['pilot_name']); |
||
| 1340 | } |
||
| 1341 | |||
| 1342 | $pall = $Spotter->countAllDepartureAirports(false,0,$last_update_day); |
||
| 1343 | $dall = $Spotter->countAllDetectedDepartureAirports(false,0,$last_update_day); |
||
| 1344 | $alldata = array(); |
||
| 1345 | |||
| 1346 | foreach ($pall as $value) { |
||
| 1347 | $icao = $value['airport_departure_icao']; |
||
| 1348 | $alldata[$icao] = $value; |
||
| 1349 | } |
||
| 1350 | foreach ($dall as $value) { |
||
| 1351 | $icao = $value['airport_departure_icao']; |
||
| 1352 | if (isset($alldata[$icao])) { |
||
| 1353 | $alldata[$icao]['airport_departure_icao_count'] = $alldata[$icao]['airport_departure_icao_count'] + $value['airport_departure_icao_count']; |
||
| 1354 | } else $alldata[$icao] = $value; |
||
| 1355 | } |
||
| 1356 | $count = array(); |
||
| 1357 | foreach ($alldata as $key => $row) { |
||
| 1358 | $count[$key] = $row['airport_departure_icao_count']; |
||
| 1359 | } |
||
| 1360 | array_multisort($count,SORT_DESC,$alldata); |
||
| 1361 | foreach ($alldata as $number) { |
||
| 1362 | echo $this->addStatDepartureAirports($number['airport_departure_icao'],$number['airport_departure_name'],$number['airport_departure_city'],$number['airport_departure_country'],$number['airport_departure_icao_count']); |
||
| 1363 | } |
||
| 1364 | $pall = $Spotter->countAllArrivalAirports(false,0,$last_update_day); |
||
| 1365 | $dall = $Spotter->countAllDetectedArrivalAirports(false,0,$last_update_day); |
||
| 1366 | $alldata = array(); |
||
| 1367 | foreach ($pall as $value) { |
||
| 1368 | $icao = $value['airport_arrival_icao']; |
||
| 1369 | $alldata[$icao] = $value; |
||
| 1370 | } |
||
| 1371 | foreach ($dall as $value) { |
||
| 1372 | $icao = $value['airport_arrival_icao']; |
||
| 1373 | if (isset($alldata[$icao])) { |
||
| 1374 | $alldata[$icao]['airport_arrival_icao_count'] = $alldata[$icao]['airport_arrival_icao_count'] + $value['airport_arrival_icao_count']; |
||
| 1375 | } else $alldata[$icao] = $value; |
||
| 1376 | } |
||
| 1377 | $count = array(); |
||
| 1378 | foreach ($alldata as $key => $row) { |
||
| 1379 | $count[$key] = $row['airport_arrival_icao_count']; |
||
| 1380 | } |
||
| 1381 | array_multisort($count,SORT_DESC,$alldata); |
||
| 1382 | foreach ($alldata as $number) { |
||
| 1383 | echo $this->addStatArrivalAirports($number['airport_arrival_icao'],$number['airport_arrival_name'],$number['airport_arrival_city'],$number['airport_arrival_country'],$number['airport_arrival_icao_count']); |
||
| 1384 | } |
||
| 1385 | if ($Connection->tableExists('countries')) { |
||
| 1386 | $SpotterArchive = new SpotterArchive(); |
||
| 1387 | $alldata = $SpotterArchive->countAllFlightOverCountries(false,0,$last_update_day); |
||
| 1388 | foreach ($alldata as $number) { |
||
| 1389 | $this->addStatCountry($number['flight_country_iso2'],$number['flight_country_iso3'],$number['flight_country'],$number['flight_count']); |
||
| 1390 | } |
||
| 1391 | } |
||
| 1392 | |||
| 1393 | |||
| 1394 | // Add by month using getstat if month finish... |
||
| 1395 | |||
| 1396 | //if (date('m',strtotime($last_update_day)) != date('m')) { |
||
| 1397 | $Spotter = new Spotter($this->db); |
||
| 1398 | $alldata = $Spotter->countAllMonths(); |
||
| 1399 | $lastyear = false; |
||
|
|
|||
| 1400 | foreach ($alldata as $number) { |
||
| 1401 | if ($number['year_name'] != date('Y')) $lastyear = true; |
||
| 1402 | $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']))); |
||
| 1403 | } |
||
| 1404 | $alldata = $Spotter->countAllMilitaryMonths(); |
||
| 1405 | foreach ($alldata as $number) { |
||
| 1406 | $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']))); |
||
| 1407 | } |
||
| 1408 | $alldata = $Spotter->countAllMonthsOwners(); |
||
| 1409 | foreach ($alldata as $number) { |
||
| 1410 | $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']))); |
||
| 1411 | } |
||
| 1412 | $alldata = $Spotter->countAllMonthsPilots(); |
||
| 1413 | foreach ($alldata as $number) { |
||
| 1414 | $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']))); |
||
| 1415 | } |
||
| 1416 | $alldata = $Spotter->countAllMonthsAirlines(); |
||
| 1417 | foreach ($alldata as $number) { |
||
| 1418 | $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']))); |
||
| 1419 | } |
||
| 1420 | $alldata = $Spotter->countAllMonthsAircrafts(); |
||
| 1421 | foreach ($alldata as $number) { |
||
| 1422 | $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']))); |
||
| 1423 | } |
||
| 1424 | $alldata = $Spotter->countAllMonthsRealArrivals(); |
||
| 1425 | foreach ($alldata as $number) { |
||
| 1426 | $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']))); |
||
| 1427 | } |
||
| 1428 | echo 'Airports data...'."\n"; |
||
| 1429 | echo '...Departure'."\n"; |
||
| 1430 | $this->deleteStatAirport('daily'); |
||
| 1431 | // $pall = $Spotter->getLast7DaysAirportsDeparture(); |
||
| 1432 | // $dall = $Spotter->getLast7DaysDetectedAirportsDeparture(); |
||
| 1433 | $pall = $Spotter->getLast7DaysAirportsDeparture(); |
||
| 1434 | $dall = $Spotter->getLast7DaysDetectedAirportsDeparture(); |
||
| 1435 | /* |
||
| 1436 | $alldata = array(); |
||
| 1437 | foreach ($pall as $value) { |
||
| 1438 | $icao = $value['departure_airport_icao']; |
||
| 1439 | $alldata[$icao] = $value; |
||
| 1440 | } |
||
| 1441 | foreach ($dall as $value) { |
||
| 1442 | $icao = $value['departure_airport_icao']; |
||
| 1443 | $ddate = $value['date']; |
||
| 1444 | if (isset($alldata[$icao])) { |
||
| 1445 | $alldata[$icao]['departure_airport_count'] = $alldata[$icao]['departure_airport_count'] + $value['departure_airport_count']; |
||
| 1446 | } else $alldata[$icao] = $value; |
||
| 1447 | } |
||
| 1448 | $count = array(); |
||
| 1449 | foreach ($alldata as $key => $row) { |
||
| 1450 | $count[$key] = $row['departure_airport_count']; |
||
| 1451 | } |
||
| 1452 | array_multisort($count,SORT_DESC,$alldata); |
||
| 1453 | */ |
||
| 1454 | foreach ($dall as $value) { |
||
| 1455 | $icao = $value['departure_airport_icao']; |
||
| 1456 | $ddate = $value['date']; |
||
| 1457 | $find = false; |
||
| 1458 | foreach ($pall as $pvalue) { |
||
| 1459 | if ($pvalue['departure_airport_icao'] == $icao && $pvalue['date'] == $ddate) { |
||
| 1460 | $pvalue['departure_airport_count'] = $pvalue['departure_airport_count'] + $value['departure_airport_count']; |
||
| 1461 | $find = true; |
||
| 1462 | break; |
||
| 1463 | } |
||
| 1464 | } |
||
| 1465 | if ($find === false) { |
||
| 1466 | $pall[] = $value; |
||
| 1467 | } |
||
| 1468 | } |
||
| 1469 | $alldata = $pall; |
||
| 1470 | foreach ($alldata as $number) { |
||
| 1471 | $this->addStatDepartureAirportsDaily($number['date'],$number['departure_airport_icao'],$number['departure_airport_name'],$number['departure_airport_city'],$number['departure_airport_country'],$number['departure_airport_count']); |
||
| 1472 | } |
||
| 1473 | echo '...Arrival'."\n"; |
||
| 1474 | $pall = $Spotter->getLast7DaysAirportsArrival(); |
||
| 1475 | $dall = $Spotter->getLast7DaysDetectedAirportsArrival(); |
||
| 1476 | /* |
||
| 1477 | $alldata = array(); |
||
| 1478 | foreach ($pall as $value) { |
||
| 1479 | $icao = $value['arrival_airport_icao']; |
||
| 1480 | $alldata[$icao] = $value; |
||
| 1481 | } |
||
| 1482 | foreach ($dall as $value) { |
||
| 1483 | $icao = $value['arrival_airport_icao']; |
||
| 1484 | if (isset($alldata[$icao])) { |
||
| 1485 | $alldata[$icao]['arrival_airport_icao_count'] = $alldata[$icao]['arrival_airport_count'] + $value['arrival_airport_count']; |
||
| 1486 | } else $alldata[$icao] = $value; |
||
| 1487 | } |
||
| 1488 | $count = array(); |
||
| 1489 | foreach ($alldata as $key => $row) { |
||
| 1490 | $count[$key] = $row['arrival_airport_count']; |
||
| 1491 | } |
||
| 1492 | array_multisort($count,SORT_DESC,$alldata); |
||
| 1493 | */ |
||
| 1494 | |||
| 1495 | |||
| 1496 | foreach ($dall as $value) { |
||
| 1497 | $icao = $value['arrival_airport_icao']; |
||
| 1498 | $ddate = $value['date']; |
||
| 1499 | $find = false; |
||
| 1500 | foreach ($pall as $pvalue) { |
||
| 1501 | if ($pvalue['arrival_airport_icao'] == $icao && $pvalue['date'] == $ddate) { |
||
| 1502 | $pvalue['arrival_airport_count'] = $pvalue['arrival_airport_count'] + $value['arrival_airport_count']; |
||
| 1503 | $find = true; |
||
| 1504 | break; |
||
| 1505 | } |
||
| 1506 | } |
||
| 1507 | if ($find === false) { |
||
| 1508 | $pall[] = $value; |
||
| 1509 | } |
||
| 1510 | } |
||
| 1511 | $alldata = $pall; |
||
| 1512 | foreach ($alldata as $number) { |
||
| 1513 | $this->addStatArrivalAirportsDaily($number['date'],$number['arrival_airport_icao'],$number['arrival_airport_name'],$number['arrival_airport_city'],$number['arrival_airport_country'],$number['arrival_airport_count']); |
||
| 1514 | } |
||
| 1515 | |||
| 1516 | echo 'Flights data...'."\n"; |
||
| 1517 | $this->deleteStatFlight('month'); |
||
| 1518 | echo '-> countAllDatesLastMonth...'."\n"; |
||
| 1519 | $alldata = $Spotter->countAllDatesLastMonth(); |
||
| 1520 | foreach ($alldata as $number) { |
||
| 1521 | $this->addStatFlight('month',$number['date_name'],$number['date_count']); |
||
| 1522 | } |
||
| 1523 | echo '-> countAllDates...'."\n"; |
||
| 1524 | $previousdata = $this->countAllDates(); |
||
| 1525 | $this->deleteStatFlight('date'); |
||
| 1526 | $alldata = $Common->array_merge_noappend($previousdata,$Spotter->countAllDates()); |
||
| 1527 | $values = array(); |
||
| 1528 | foreach ($alldata as $cnt) { |
||
| 1529 | $values[] = $cnt['date_count']; |
||
| 1530 | } |
||
| 1531 | array_multisort($values,SORT_DESC,$alldata); |
||
| 1532 | array_splice($alldata,11); |
||
| 1533 | foreach ($alldata as $number) { |
||
| 1534 | $this->addStatFlight('date',$number['date_name'],$number['date_count']); |
||
| 1535 | } |
||
| 1536 | |||
| 1537 | $this->deleteStatFlight('hour'); |
||
| 1538 | echo '-> countAllHours...'."\n"; |
||
| 1539 | $alldata = $Spotter->countAllHours('hour'); |
||
| 1540 | foreach ($alldata as $number) { |
||
| 1541 | $this->addStatFlight('hour',$number['hour_name'],$number['hour_count']); |
||
| 1542 | } |
||
| 1543 | |||
| 1544 | |||
| 1545 | |||
| 1546 | // Count by airlines |
||
| 1547 | echo '--- Stats by airlines ---'."\n"; |
||
| 1548 | $Spotter = new Spotter($this->db); |
||
| 1549 | $alldata = $Spotter->countAllAircraftTypesByAirlines(false,0,$last_update_day); |
||
| 1550 | foreach ($alldata as $number) { |
||
| 1551 | $this->addStatAircraft($number['aircraft_icao'],$number['aircraft_icao_count'],$number['aircraft_name'],$number['aircraft_manufacturer'],$number['airline_icao']); |
||
| 1552 | } |
||
| 1553 | $alldata = $Spotter->countAllAircraftRegistrationsByAirlines(false,0,$last_update_day); |
||
| 1554 | foreach ($alldata as $number) { |
||
| 1555 | $this->addStatAircraftRegistration($number['registration'],$number['aircraft_registration_count'],$number['aircraft_icao'],$number['airline_icao']); |
||
| 1556 | } |
||
| 1557 | $alldata = $Spotter->countAllCallsignsByAirlines(false,0,$last_update_day); |
||
| 1558 | foreach ($alldata as $number) { |
||
| 1559 | $this->addStatCallsign($number['callsign_icao'],$number['callsign_icao_count'],$number['airline_icao']); |
||
| 1560 | } |
||
| 1561 | $alldata = $Spotter->countAllOwnersByAirlines(false,0,$last_update_day); |
||
| 1562 | foreach ($alldata as $number) { |
||
| 1563 | $this->addStatOwner($number['owner_name'],$number['owner_count'],$number['airline_icao']); |
||
| 1564 | } |
||
| 1565 | $alldata = $Spotter->countAllPilotsByAirlines(false,0,$last_update_day); |
||
| 1566 | foreach ($alldata as $number) { |
||
| 1567 | $this->addStatPilot($number['pilot_id'],$number['pilot_count'],$number['pilot_name'],$number['airline_icao']); |
||
| 1568 | } |
||
| 1569 | |||
| 1570 | $pall = $Spotter->countAllDepartureAirportsByAirlines(false,0,$last_update_day); |
||
| 1571 | $dall = $Spotter->countAllDetectedDepartureAirportsByAirlines(false,0,$last_update_day); |
||
| 1572 | //$alldata = array(); |
||
| 1573 | foreach ($dall as $value) { |
||
| 1574 | $icao = $value['airport_departure_icao']; |
||
| 1575 | $dicao = $value['airline_icap']; |
||
| 1576 | $find = false; |
||
| 1577 | foreach ($pall as $pvalue) { |
||
| 1578 | if ($pvalue['airport_departure_icao'] == $icao && $pvalue['airline_icao'] = $dicao) { |
||
| 1579 | $pvalue['airport_departure_icao_count'] = $pvalue['airport_departure_icao_count'] + $value['airport_departure_icao_count']; |
||
| 1580 | $find = true; |
||
| 1581 | break; |
||
| 1582 | } |
||
| 1583 | } |
||
| 1584 | if ($find === false) { |
||
| 1585 | $pall[] = $value; |
||
| 1586 | } |
||
| 1587 | } |
||
| 1588 | $alldata = $pall; |
||
| 1589 | foreach ($alldata as $number) { |
||
| 1590 | 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']); |
||
| 1591 | } |
||
| 1592 | $pall = $Spotter->countAllArrivalAirportsByAirlines(false,0,$last_update_day); |
||
| 1593 | $dall = $Spotter->countAllDetectedArrivalAirportsByAirlines(false,0,$last_update_day); |
||
| 1594 | //$alldata = array(); |
||
| 1595 | foreach ($dall as $value) { |
||
| 1596 | $icao = $value['airport_arrival_icao']; |
||
| 1597 | $dicao = $value['airline_icao']; |
||
| 1598 | $find = false; |
||
| 1599 | foreach ($pall as $pvalue) { |
||
| 1600 | if ($pvalue['airport_arrival_icao'] == $icao && $pvalue['airline_icao'] = $dicao) { |
||
| 1601 | $pvalue['airport_arrival_icao_count'] = $pvalue['airport_arrival_icao_count'] + $value['airport_arrival_icao_count']; |
||
| 1602 | $find = true; |
||
| 1603 | break; |
||
| 1604 | } |
||
| 1605 | } |
||
| 1606 | if ($find === false) { |
||
| 1607 | $pall[] = $value; |
||
| 1608 | } |
||
| 1609 | } |
||
| 1610 | $alldata = $pall; |
||
| 1611 | foreach ($alldata as $number) { |
||
| 1612 | 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']); |
||
| 1613 | } |
||
| 1614 | $Spotter = new Spotter($this->db); |
||
| 1615 | $alldata = $Spotter->countAllMonthsByAirlines(); |
||
| 1616 | $lastyear = false; |
||
| 1617 | foreach ($alldata as $number) { |
||
| 1618 | if ($number['year_name'] != date('Y')) $lastyear = true; |
||
| 1619 | $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']); |
||
| 1620 | } |
||
| 1621 | $alldata = $Spotter->countAllMonthsOwnersByAirlines(); |
||
| 1622 | foreach ($alldata as $number) { |
||
| 1623 | $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']); |
||
| 1624 | } |
||
| 1625 | $alldata = $Spotter->countAllMonthsPilotsByAirlines(); |
||
| 1626 | foreach ($alldata as $number) { |
||
| 1627 | $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']); |
||
| 1628 | } |
||
| 1629 | $alldata = $Spotter->countAllMonthsAircraftsByAirlines(); |
||
| 1630 | foreach ($alldata as $number) { |
||
| 1631 | $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']); |
||
| 1632 | } |
||
| 1633 | $alldata = $Spotter->countAllMonthsRealArrivalsByAirlines(); |
||
| 1634 | foreach ($alldata as $number) { |
||
| 1635 | $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']); |
||
| 1636 | } |
||
| 1637 | echo '...Departure'."\n"; |
||
| 1638 | $pall = $Spotter->getLast7DaysAirportsDepartureByAirlines(); |
||
| 1639 | $dall = $Spotter->getLast7DaysDetectedAirportsDepartureByAirlines(); |
||
| 1640 | foreach ($dall as $value) { |
||
| 1641 | $icao = $value['departure_airport_icao']; |
||
| 1642 | $airline = $value['airline_icao']; |
||
| 1643 | $ddate = $value['date']; |
||
| 1644 | $find = false; |
||
| 1645 | foreach ($pall as $pvalue) { |
||
| 1646 | if ($pvalue['departure_airport_icao'] == $icao && $pvalue['date'] == $ddate && $pvalue['airline_icao'] = $airline) { |
||
| 1647 | $pvalue['departure_airport_count'] = $pvalue['departure_airport_count'] + $value['departure_airport_count']; |
||
| 1648 | $find = true; |
||
| 1649 | break; |
||
| 1650 | } |
||
| 1651 | } |
||
| 1652 | if ($find === false) { |
||
| 1653 | $pall[] = $value; |
||
| 1654 | } |
||
| 1655 | } |
||
| 1656 | $alldata = $pall; |
||
| 1657 | foreach ($alldata as $number) { |
||
| 1658 | $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']); |
||
| 1659 | } |
||
| 1660 | echo '...Arrival'."\n"; |
||
| 1661 | $pall = $Spotter->getLast7DaysAirportsArrivalByAirlines(); |
||
| 1662 | $dall = $Spotter->getLast7DaysDetectedAirportsArrivalByAirlines(); |
||
| 1663 | foreach ($dall as $value) { |
||
| 1664 | $icao = $value['arrival_airport_icao']; |
||
| 1665 | $airline = $value['airline_icao']; |
||
| 1666 | $ddate = $value['date']; |
||
| 1667 | $find = false; |
||
| 1668 | foreach ($pall as $pvalue) { |
||
| 1669 | if ($pvalue['arrival_airport_icao'] == $icao && $pvalue['date'] == $ddate && $pvalue['airline_icao'] == $airline) { |
||
| 1670 | $pvalue['arrival_airport_count'] = $pvalue['arrival_airport_count'] + $value['arrival_airport_count']; |
||
| 1671 | $find = true; |
||
| 1672 | break; |
||
| 1673 | } |
||
| 1674 | } |
||
| 1675 | if ($find === false) { |
||
| 1676 | $pall[] = $value; |
||
| 1677 | } |
||
| 1678 | } |
||
| 1679 | $alldata = $pall; |
||
| 1680 | foreach ($alldata as $number) { |
||
| 1681 | $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']); |
||
| 1682 | } |
||
| 1683 | |||
| 1684 | echo 'Flights data...'."\n"; |
||
| 1685 | echo '-> countAllDatesLastMonth...'."\n"; |
||
| 1686 | $alldata = $Spotter->countAllDatesLastMonthByAirlines(); |
||
| 1687 | foreach ($alldata as $number) { |
||
| 1688 | $this->addStatFlight('month',$number['date_name'],$number['date_count'], $number['airline_icao']); |
||
| 1689 | } |
||
| 1690 | echo '-> countAllDates...'."\n"; |
||
| 1691 | $previousdata = $this->countAllDatesByAirlines(); |
||
| 1692 | $alldata = $Common->array_merge_noappend($previousdata,$Spotter->countAllDatesByAirlines()); |
||
| 1693 | $values = array(); |
||
| 1694 | foreach ($alldata as $cnt) { |
||
| 1695 | $values[] = $cnt['date_count']; |
||
| 1696 | } |
||
| 1697 | array_multisort($values,SORT_DESC,$alldata); |
||
| 1698 | array_splice($alldata,11); |
||
| 1699 | foreach ($alldata as $number) { |
||
| 1700 | $this->addStatFlight('date',$number['date_name'],$number['date_count'],$number['airline_icao']); |
||
| 1701 | } |
||
| 1702 | |||
| 1703 | echo '-> countAllHours...'."\n"; |
||
| 1704 | $alldata = $Spotter->countAllHoursByAirlines('hour'); |
||
| 1705 | foreach ($alldata as $number) { |
||
| 1706 | $this->addStatFlight('hour',$number['hour_name'],$number['hour_count'],$number['airline_icao']); |
||
| 1707 | } |
||
| 1708 | |||
| 1709 | |||
| 1710 | if (!isset($globalStatsFilters) || $globalStatsFilters == '') $globalStatsFilters = array(); |
||
| 1711 | foreach ($globalStatsFilters as $name => $filter) { |
||
| 1712 | //$filter_name = $filter['name']; |
||
| 1713 | $filter_name = $name; |
||
| 1714 | // Count by filter |
||
| 1715 | echo '--- Stats by airlines ---'."\n"; |
||
| 1716 | $Spotter = new Spotter($this->db); |
||
| 1717 | $alldata = $Spotter->countAllAircraftTypes(false,0,$last_update_day,$filter); |
||
| 1718 | foreach ($alldata as $number) { |
||
| 1719 | $this->addStatAircraft($number['aircraft_icao'],$number['aircraft_icao_count'],$number['aircraft_name'],$number['aircraft_manufacturer'],'',$filter_name); |
||
| 1720 | } |
||
| 1721 | $alldata = $Spotter->countAllAircraftRegistrations(false,0,$last_update_day,$filter); |
||
| 1722 | foreach ($alldata as $number) { |
||
| 1723 | $this->addStatAircraftRegistration($number['registration'],$number['aircraft_registration_count'],$number['aircraft_icao'],'',$filter_name); |
||
| 1724 | } |
||
| 1725 | $alldata = $Spotter->countAllCallsigns(false,0,$last_update_day,$filter); |
||
| 1726 | foreach ($alldata as $number) { |
||
| 1727 | $this->addStatCallsign($number['callsign_icao'],$number['callsign_icao_count'],'',$filter_name); |
||
| 1728 | } |
||
| 1729 | $alldata = $Spotter->countAllOwners(false,0,$last_update_day,$filter); |
||
| 1730 | foreach ($alldata as $number) { |
||
| 1731 | $this->addStatOwner($number['owner_name'],$number['owner_count'],'',$filter_name); |
||
| 1732 | } |
||
| 1733 | $alldata = $Spotter->countAllPilots(false,0,$last_update_day,$filter); |
||
| 1734 | foreach ($alldata as $number) { |
||
| 1735 | $this->addStatPilot($number['pilot_id'],$number['pilot_count'],$number['pilot_name'],'',$filter_name); |
||
| 1736 | } |
||
| 1737 | |||
| 1738 | $pall = $Spotter->countAllDepartureAirports(false,0,$last_update_day,$filter); |
||
| 1739 | $dall = $Spotter->countAllDetectedDepartureAirports(false,0,$last_update_day,$filter); |
||
| 1740 | //$alldata = array(); |
||
| 1741 | foreach ($dall as $value) { |
||
| 1742 | $icao = $value['airport_departure_icao']; |
||
| 1743 | $dicao = $value['airline_icap']; |
||
| 1744 | $find = false; |
||
| 1745 | foreach ($pall as $pvalue) { |
||
| 1746 | if ($pvalue['airport_departure_icao'] == $icao && $pvalue['airline_icao'] = $dicao) { |
||
| 1747 | $pvalue['airport_departure_icao_count'] = $pvalue['airport_departure_icao_count'] + $value['airport_departure_icao_count']; |
||
| 1748 | $find = true; |
||
| 1749 | break; |
||
| 1750 | } |
||
| 1751 | } |
||
| 1752 | if ($find === false) { |
||
| 1753 | $pall[] = $value; |
||
| 1754 | } |
||
| 1755 | } |
||
| 1756 | $alldata = $pall; |
||
| 1757 | foreach ($alldata as $number) { |
||
| 1758 | echo $this->addStatDepartureAirports($number['airport_departure_icao'],$number['airport_departure_name'],$number['airport_departure_city'],$number['airport_departure_country'],$number['airport_departure_icao_count'],'',$filter_name); |
||
| 1759 | } |
||
| 1760 | $pall = $Spotter->countAllArrivalAirports(false,0,$last_update_day,$filter); |
||
| 1761 | $dall = $Spotter->countAllDetectedArrivalAirports(false,0,$last_update_day,$filter); |
||
| 1762 | //$alldata = array(); |
||
| 1763 | foreach ($dall as $value) { |
||
| 1764 | $icao = $value['airport_arrival_icao']; |
||
| 1765 | $dicao = $value['airline_icao']; |
||
| 1766 | $find = false; |
||
| 1767 | foreach ($pall as $pvalue) { |
||
| 1768 | if ($pvalue['airport_arrival_icao'] == $icao && $pvalue['airline_icao'] = $dicao) { |
||
| 1769 | $pvalue['airport_arrival_icao_count'] = $pvalue['airport_arrival_icao_count'] + $value['airport_arrival_icao_count']; |
||
| 1770 | $find = true; |
||
| 1771 | break; |
||
| 1772 | } |
||
| 1773 | } |
||
| 1774 | if ($find === false) { |
||
| 1775 | $pall[] = $value; |
||
| 1776 | } |
||
| 1777 | } |
||
| 1778 | $alldata = $pall; |
||
| 1779 | foreach ($alldata as $number) { |
||
| 1780 | echo $this->addStatArrivalAirports($number['airport_arrival_icao'],$number['airport_arrival_name'],$number['airport_arrival_city'],$number['airport_arrival_country'],$number['airport_arrival_icao_count'],'',$filter_name); |
||
| 1781 | } |
||
| 1782 | $Spotter = new Spotter($this->db); |
||
| 1783 | $alldata = $Spotter->countAllMonths($filter); |
||
| 1784 | $lastyear = false; |
||
| 1785 | foreach ($alldata as $number) { |
||
| 1786 | if ($number['year_name'] != date('Y')) $lastyear = true; |
||
| 1787 | $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); |
||
| 1788 | } |
||
| 1789 | $alldata = $Spotter->countAllMonthsOwners($filter); |
||
| 1790 | foreach ($alldata as $number) { |
||
| 1791 | $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'])),'',$filter_name); |
||
| 1792 | } |
||
| 1793 | $alldata = $Spotter->countAllMonthsPilots($filter); |
||
| 1794 | foreach ($alldata as $number) { |
||
| 1795 | $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'])),'',$filter_name); |
||
| 1796 | } |
||
| 1797 | $alldata = $Spotter->countAllMonthsAircrafts($filter); |
||
| 1798 | foreach ($alldata as $number) { |
||
| 1799 | $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'])),'',$filter_name); |
||
| 1800 | } |
||
| 1801 | $alldata = $Spotter->countAllMonthsRealArrivals($filter); |
||
| 1802 | foreach ($alldata as $number) { |
||
| 1803 | $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'])),'',$filter_name); |
||
| 1804 | } |
||
| 1805 | echo '...Departure'."\n"; |
||
| 1806 | $pall = $Spotter->getLast7DaysAirportsDeparture($filter); |
||
| 1807 | $dall = $Spotter->getLast7DaysDetectedAirportsDeparture($filter); |
||
| 1808 | foreach ($dall as $value) { |
||
| 1809 | $icao = $value['departure_airport_icao']; |
||
| 1810 | $airline = $value['airline_icao']; |
||
| 1811 | $ddate = $value['date']; |
||
| 1812 | $find = false; |
||
| 1813 | foreach ($pall as $pvalue) { |
||
| 1814 | if ($pvalue['departure_airport_icao'] == $icao && $pvalue['date'] == $ddate && $pvalue['airline_icao'] = $airline) { |
||
| 1815 | $pvalue['departure_airport_count'] = $pvalue['departure_airport_count'] + $value['departure_airport_count']; |
||
| 1816 | $find = true; |
||
| 1817 | break; |
||
| 1818 | } |
||
| 1819 | } |
||
| 1820 | if ($find === false) { |
||
| 1821 | $pall[] = $value; |
||
| 1822 | } |
||
| 1823 | } |
||
| 1824 | $alldata = $pall; |
||
| 1825 | foreach ($alldata as $number) { |
||
| 1826 | $this->addStatDepartureAirportsDaily($number['date'],$number['departure_airport_icao'],$number['departure_airport_name'],$number['departure_airport_city'],$number['departure_airport_country'],$number['departure_airport_count'],'',$filter_name); |
||
| 1827 | } |
||
| 1828 | echo '...Arrival'."\n"; |
||
| 1829 | $pall = $Spotter->getLast7DaysAirportsArrival($filter); |
||
| 1830 | $dall = $Spotter->getLast7DaysDetectedAirportsArrival($filter); |
||
| 1831 | foreach ($dall as $value) { |
||
| 1832 | $icao = $value['arrival_airport_icao']; |
||
| 1833 | $airline = $value['airline_icao']; |
||
| 1834 | $ddate = $value['date']; |
||
| 1835 | $find = false; |
||
| 1836 | foreach ($pall as $pvalue) { |
||
| 1837 | if ($pvalue['arrival_airport_icao'] == $icao && $pvalue['date'] == $ddate && $pvalue['airline_icao'] == $airline) { |
||
| 1838 | $pvalue['arrival_airport_count'] = $pvalue['arrival_airport_count'] + $value['arrival_airport_count']; |
||
| 1839 | $find = true; |
||
| 1840 | break; |
||
| 1841 | } |
||
| 1842 | } |
||
| 1843 | if ($find === false) { |
||
| 1844 | $pall[] = $value; |
||
| 1845 | } |
||
| 1846 | } |
||
| 1847 | $alldata = $pall; |
||
| 1848 | foreach ($alldata as $number) { |
||
| 1849 | $this->addStatArrivalAirportsDaily($number['date'],$number['arrival_airport_icao'],$number['arrival_airport_name'],$number['arrival_airport_city'],$number['arrival_airport_country'],$number['arrival_airport_count'],'',$filter_name); |
||
| 1850 | } |
||
| 1851 | |||
| 1852 | echo 'Flights data...'."\n"; |
||
| 1853 | echo '-> countAllDatesLastMonth...'."\n"; |
||
| 1854 | $alldata = $Spotter->countAllDatesLastMonth($filter); |
||
| 1855 | foreach ($alldata as $number) { |
||
| 1856 | $this->addStatFlight('month',$number['date_name'],$number['date_count'], '',$filter_name); |
||
| 1857 | } |
||
| 1858 | echo '-> countAllDates...'."\n"; |
||
| 1859 | $previousdata = $this->countAllDates($filter); |
||
| 1860 | $alldata = $Common->array_merge_noappend($previousdata,$Spotter->countAllDates($filter)); |
||
| 1861 | $values = array(); |
||
| 1862 | foreach ($alldata as $cnt) { |
||
| 1863 | $values[] = $cnt['date_count']; |
||
| 1864 | } |
||
| 1865 | array_multisort($values,SORT_DESC,$alldata); |
||
| 1866 | array_splice($alldata,11); |
||
| 1867 | foreach ($alldata as $number) { |
||
| 1868 | $this->addStatFlight('date',$number['date_name'],$number['date_count'],'',$filter_name); |
||
| 1869 | } |
||
| 1870 | |||
| 1871 | echo '-> countAllHours...'."\n"; |
||
| 1872 | $alldata = $Spotter->countAllHours('hour',$filter); |
||
| 1873 | foreach ($alldata as $number) { |
||
| 1874 | $this->addStatFlight('hour',$number['hour_name'],$number['hour_count'],'',$filter_name); |
||
| 1875 | } |
||
| 1876 | } |
||
| 1877 | |||
| 1878 | |||
| 1879 | // Last year stats |
||
| 1880 | if ($lastyear) { |
||
| 1881 | echo 'Data from last year...'."\n"; |
||
| 1882 | // SUM all previous month to put as year |
||
| 1883 | $previous_year = date('Y'); |
||
| 1884 | $previous_year--; |
||
| 1885 | $this->addStat('aircrafts_byyear',$this->getSumStats('aircrafts_bymonth',$previous_year),$previous_year.'-01-01 00:00:00'); |
||
| 1886 | $this->addStat('airlines_byyear',$this->getSumStats('airlines_bymonth',$previous_year),$previous_year.'-01-01 00:00:00'); |
||
| 1887 | $this->addStat('owner_byyear',$this->getSumStats('owner_bymonth',$previous_year),$previous_year.'-01-01 00:00:00'); |
||
| 1888 | $this->addStat('pilot_byyear',$this->getSumStats('pilot_bymonth',$previous_year),$previous_year.'-01-01 00:00:00'); |
||
| 1889 | $allairlines = $this->getAllAirlineNames(); |
||
| 1890 | foreach ($allairlines as $data) { |
||
| 1891 | $this->addStat('aircrafts_byyear',$this->getSumStats('aircrafts_bymonth',$previous_year,$data['airline_icao']),$previous_year.'-01-01 00:00:00',$data['airline_icao']); |
||
| 1892 | $this->addStat('airlines_byyear',$this->getSumStats('airlines_bymonth',$previous_year,$data['airline_icao']),$previous_year.'-01-01 00:00:00',$data['airline_icao']); |
||
| 1893 | $this->addStat('owner_byyear',$this->getSumStats('owner_bymonth',$previous_year,$data['airline_icao']),$previous_year.'-01-01 00:00:00',$data['airline_icao']); |
||
| 1894 | $this->addStat('pilot_byyear',$this->getSumStats('pilot_bymonth',$previous_year,$data['airline_icao']),$previous_year.'-01-01 00:00:00',$data['airline_icao']); |
||
| 1895 | } |
||
| 1896 | |||
| 1897 | if (isset($globalArchiveYear) && $globalArchiveYear) { |
||
| 1898 | if ($globalArchive) { |
||
| 1899 | $query = "INSERT INTO spotter_archive_output SELECT * FROM spotter_output WHERE spotter_output.date < '".date('Y')."-01-01 00:00:00'"; |
||
| 1900 | try { |
||
| 1901 | $sth = $this->db->prepare($query); |
||
| 1902 | $sth->execute(); |
||
| 1903 | } catch(PDOException $e) { |
||
| 1904 | return "error : ".$e->getMessage().' - query : '.$query."\n"; |
||
| 1905 | } |
||
| 1906 | } |
||
| 1907 | echo 'Delete old data'."\n"; |
||
| 1908 | $query = "DELETE FROM spotter_output WHERE spotter_output.date < '".date('Y')."-01-01 00:00:00'"; |
||
| 1909 | try { |
||
| 1910 | $sth = $this->db->prepare($query); |
||
| 1911 | $sth->execute(); |
||
| 1912 | } catch(PDOException $e) { |
||
| 1913 | return "error : ".$e->getMessage().' - query : '.$query."\n"; |
||
| 1914 | } |
||
| 1915 | } |
||
| 1916 | } |
||
| 1917 | if ($globalArchiveMonths > 0) { |
||
| 1918 | if ($globalArchive) { |
||
| 1919 | echo 'Archive old data...'."\n"; |
||
| 1920 | if ($globalDBdriver == 'mysql') { |
||
| 1921 | //$query = "INSERT INTO spotter_archive_output SELECT * FROM spotter_output WHERE spotter_output.date < DATE_FORMAT(UTC_TIMESTAMP() - INTERVAL ".$globalArchiveMonths." MONTH, '%Y/%m/01')"; |
||
| 1922 | $query = "INSERT INTO spotter_archive_output (spotter_id,flightaware_id,ident,registration,airline_name,airline_icao,airline_country,airline_type,aircraft_icao,aircraft_name,aircraft_manufacturer,departure_airport_icao,departure_airport_name,departure_airport_city,departure_airport_country,departure_airport_time,arrival_airport_icao,arrival_airport_name,arrival_airport_city,arrival_airport_country,arrival_airport_time,route_stop,date,latitude,longitude,waypoints,altitude,heading,ground_speed,highlight,squawk,ModeS,pilot_id,pilot_name,owner_name,verticalrate,format_source,source_name,ground,last_ground,last_seen,last_latitude,last_longitude,last_altitude,last_ground_speed,real_arrival_airport_icao,real_arrival_airport_time,real_departure_airport_icao,real_departure_airport_time) |
||
| 1923 | SELECT spotter_id,flightaware_id,ident,registration,airline_name,airline_icao,airline_country,airline_type,aircraft_icao,aircraft_name,aircraft_manufacturer,departure_airport_icao,departure_airport_name,departure_airport_city,departure_airport_country,departure_airport_time,arrival_airport_icao,arrival_airport_name,arrival_airport_city,arrival_airport_country,arrival_airport_time,route_stop,date,latitude,longitude,waypoints,altitude,heading,ground_speed,highlight,squawk,ModeS,pilot_id,pilot_name,owner_name,verticalrate,format_source,source_name,ground,last_ground,last_seen,last_latitude,last_longitude,last_altitude,last_ground_speed,real_arrival_airport_icao,real_arrival_airport_time,real_departure_airport_icao,real_departure_airport_time |
||
| 1924 | FROM spotter_output WHERE spotter_output.date < DATE_FORMAT(UTC_TIMESTAMP() - INTERVAL ".$globalArchiveMonths." MONTH, '%Y/%m/01')"; |
||
| 1925 | } else { |
||
| 1926 | $query = "INSERT INTO spotter_archive_output (spotter_id,flightaware_id,ident,registration,airline_name,airline_icao,airline_country,airline_type,aircraft_icao,aircraft_name,aircraft_manufacturer,departure_airport_icao,departure_airport_name,departure_airport_city,departure_airport_country,departure_airport_time,arrival_airport_icao,arrival_airport_name,arrival_airport_city,arrival_airport_country,arrival_airport_time,route_stop,date,latitude,longitude,waypoints,altitude,heading,ground_speed,highlight,squawk,ModeS,pilot_id,pilot_name,owner_name,verticalrate,format_source,source_name,ground,last_ground,last_seen,last_latitude,last_longitude,last_altitude,last_ground_speed,real_arrival_airport_icao,real_arrival_airport_time,real_departure_airport_icao,real_departure_airport_time) |
||
| 1927 | SELECT |
||
| 1928 | spotter_id,flightaware_id,ident,registration,airline_name,airline_icao,airline_country,airline_type,aircraft_icao,aircraft_name,aircraft_manufacturer,departure_airport_icao,departure_airport_name,departure_airport_city,departure_airport_country,departure_airport_time,arrival_airport_icao,arrival_airport_name,arrival_airport_city,arrival_airport_country,arrival_airport_time,route_stop,date,latitude,longitude,waypoints,altitude,heading,ground_speed,highlight,squawk,ModeS,pilot_id,pilot_name,owner_name,verticalrate,format_source,source_name,ground,last_ground,last_seen,last_latitude,last_longitude,last_altitude,last_ground_speed,real_arrival_airport_icao,real_arrival_airport_time,real_departure_airport_icao,real_departure_airport_time |
||
| 1929 | FROM spotter_output WHERE spotter_output.date < CAST(to_char(CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalArchiveMonths." MONTHS', 'YYYY/mm/01') AS TIMESTAMP)"; |
||
| 1930 | } |
||
| 1931 | try { |
||
| 1932 | $sth = $this->db->prepare($query); |
||
| 1933 | $sth->execute(); |
||
| 1934 | } catch(PDOException $e) { |
||
| 1935 | return "error : ".$e->getMessage(); |
||
| 1936 | } |
||
| 1937 | } |
||
| 1938 | echo 'Deleting old data...'."\n"; |
||
| 1939 | //$query = 'DELETE FROM spotter_output WHERE spotter_output.date < DATE_SUB(UTC_TIMESTAMP(), INTERVAL '.$globalArchiveMonths.' MONTH)'; |
||
| 1940 | if ($globalDBdriver == 'mysql') { |
||
| 1941 | $query = "DELETE FROM spotter_output WHERE spotter_output.date < DATE_FORMAT(UTC_TIMESTAMP() - INTERVAL ".$globalArchiveMonths." MONTH, '%Y/%m/01')"; |
||
| 1942 | } else { |
||
| 1943 | $query = "DELETE FROM spotter_output WHERE spotter_output.date < CAST(to_char(CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalArchiveMonths." MONTHS', 'YYYY/mm/01') AS TIMESTAMP)"; |
||
| 1944 | } |
||
| 1945 | try { |
||
| 1946 | $sth = $this->db->prepare($query); |
||
| 1947 | $sth->execute(); |
||
| 1948 | } catch(PDOException $e) { |
||
| 1949 | return "error : ".$e->getMessage(); |
||
| 1950 | } |
||
| 1951 | } |
||
| 1952 | echo 'Insert last stats update date...'."\n"; |
||
| 1953 | date_default_timezone_set('UTC'); |
||
| 1954 | $this->addLastStatsUpdate('last_update_stats',date('Y-m-d G:i:s')); |
||
| 1955 | //} |
||
| 1956 | } |
||
| 1957 | } |
||
| 1959 | ?> |
Loading history...
This check looks for variable assignements that are either overwritten by other assignments or where the variable is not used subsequently.
Both the
$myVarassignment in line 1 and the$higherassignment in line 2 are dead. The first because$myVaris never used and the second because$higheris always overwritten for every possible time line.