Ysurac /
FlightAirMap
| Conditions | 194 |
| Paths | 0 |
| Total Lines | 938 |
| Code Lines | 513 |
| 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 |
||
| 1176 | public function addOldStats() { |
||
| 1177 | global $globalDebug, $globalArchiveMonths, $globalArchive, $globalArchiveYear, $globalDBdriver, $globalStatsFilters,$globalDeleteLastYearStats; |
||
| 1178 | $Common = new Common(); |
||
| 1179 | $Connection = new Connection(); |
||
| 1180 | date_default_timezone_set('UTC'); |
||
| 1181 | $last_update = $this->getLastStatsUpdate('last_update_stats'); |
||
| 1182 | //print_r($last_update); |
||
| 1183 | /* |
||
| 1184 | $flightsbymonth = $this->getStats('flights_by_month'); |
||
| 1185 | if (empty($last_update) && empty($flightsbymonth)) { |
||
| 1186 | // Initial update |
||
| 1187 | $Spotter = new Spotter($this->db); |
||
| 1188 | $alldata = $Spotter->countAllMonths(); |
||
| 1189 | $lastyear = false; |
||
| 1190 | foreach ($alldata as $number) { |
||
| 1191 | if ($number['year_name'] != date('Y')) $lastyear = true; |
||
| 1192 | $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']))); |
||
| 1193 | } |
||
| 1194 | $alldata = $Spotter->countAllMilitaryMonths(); |
||
| 1195 | //$lastyear = false; |
||
| 1196 | foreach ($alldata as $number) { |
||
| 1197 | if ($number['year_name'] != date('Y')) $lastyear = true; |
||
| 1198 | $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']))); |
||
| 1199 | } |
||
| 1200 | $alldata = $Spotter->countAllMonthsOwners(); |
||
| 1201 | foreach ($alldata as $number) { |
||
| 1202 | $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']))); |
||
| 1203 | } |
||
| 1204 | $alldata = $Spotter->countAllMonthsPilots(); |
||
| 1205 | foreach ($alldata as $number) { |
||
| 1206 | $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']))); |
||
| 1207 | } |
||
| 1208 | $alldata = $Spotter->countAllMonthsAirlines(); |
||
| 1209 | foreach ($alldata as $number) { |
||
| 1210 | $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']))); |
||
| 1211 | } |
||
| 1212 | $alldata = $Spotter->countAllMonthsAircrafts(); |
||
| 1213 | foreach ($alldata as $number) { |
||
| 1214 | $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']))); |
||
| 1215 | } |
||
| 1216 | $alldata = $Spotter->countAllMonthsRealArrivals(); |
||
| 1217 | foreach ($alldata as $number) { |
||
| 1218 | $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']))); |
||
| 1219 | } |
||
| 1220 | $this->deleteStatFlight('month'); |
||
| 1221 | $alldata = $Spotter->countAllDatesLastMonth(); |
||
| 1222 | foreach ($alldata as $number) { |
||
| 1223 | $this->addStatFlight('month',$number['date_name'],$number['date_count']); |
||
| 1224 | } |
||
| 1225 | $previousdata = $this->countAllDates(); |
||
| 1226 | $this->deleteStatFlight('date'); |
||
| 1227 | $alldata = $Common->array_merge_noappend($previousdata,$Spotter->countAllDates()); |
||
| 1228 | $values = array(); |
||
| 1229 | foreach ($alldata as $cnt) { |
||
| 1230 | $values[] = $cnt['date_count']; |
||
| 1231 | } |
||
| 1232 | array_multisort($values,SORT_DESC,$alldata); |
||
| 1233 | array_splice($alldata,11); |
||
| 1234 | foreach ($alldata as $number) { |
||
| 1235 | $this->addStatFlight('date',$number['date_name'],$number['date_count']); |
||
| 1236 | } |
||
| 1237 | $this->deleteStatFlight('hour'); |
||
| 1238 | $alldata = $Spotter->countAllHours('hour'); |
||
| 1239 | foreach ($alldata as $number) { |
||
| 1240 | $this->addStatFlight('hour',$number['hour_name'],$number['hour_count']); |
||
| 1241 | } |
||
| 1242 | if ($lastyear) { |
||
| 1243 | $monthsSinceLastYear = date('n'); |
||
| 1244 | $alldata = $Spotter->countAllAircraftTypes(false,$monthsSinceLastYear); |
||
| 1245 | foreach ($alldata as $number) { |
||
| 1246 | $this->addStatAircraft($number['aircraft_icao'],$number['aircraft_icao_count'],$number['aircraft_name'],$number['aircraft_manufacturer']); |
||
| 1247 | } |
||
| 1248 | $alldata = $Spotter->countAllAirlines(false,$monthsSinceLastYear); |
||
| 1249 | foreach ($alldata as $number) { |
||
| 1250 | $this->addStatAirline($number['airline_icao'],$number['airline_count'],$number['airline_name']); |
||
| 1251 | } |
||
| 1252 | if ($Connection->tableExists('countries')) { |
||
| 1253 | $alldata = $Spotter->countAllFlightOverCountries(false,$monthsSinceLastYear); |
||
| 1254 | foreach ($alldata as $number) { |
||
| 1255 | $this->addStatCountry($number['flight_country_iso2'],$number['flight_country_iso3'],$number['flight_country'],$number['flight_count']); |
||
| 1256 | } |
||
| 1257 | } |
||
| 1258 | $alldata = $Spotter->countAllOwners(false,$monthsSinceLastYear); |
||
| 1259 | foreach ($alldata as $number) { |
||
| 1260 | $this->addStatOwner($number['owner_name'],$number['owner_count']); |
||
| 1261 | } |
||
| 1262 | $alldata = $Spotter->countAllPilots(false,$monthsSinceLastYear); |
||
| 1263 | foreach ($alldata as $number) { |
||
| 1264 | $this->addStatPilot($number['pilot_id'],$number['pilot_count'],$number['pilot_name']); |
||
| 1265 | } |
||
| 1266 | $previous_year = date('Y'); |
||
| 1267 | $previous_year--; |
||
| 1268 | $this->addStat('aircrafts_byyear',$this->getStatsAircraftTotal(),$previous_year.'-01-01 00:00:00'); |
||
| 1269 | $this->addStat('airlines_byyear',$this->getStatsAirlineTotal(),$previous_year.'-01-01 00:00:00'); |
||
| 1270 | $this->addStat('owner_byyear',$this->getStatsOwnerTotal(),$previous_year.'-01-01 00:00:00'); |
||
| 1271 | $this->addStat('pilot_byyear',$this->getStatsPilotTotal(),$previous_year.'-01-01 00:00:00'); |
||
| 1272 | |||
| 1273 | if (isset($globalArchiveYear) && $globalArchiveYear) { |
||
| 1274 | if ($globalArchive) { |
||
| 1275 | $query = "INSERT INTO spotter_archive_output SELECT * FROM spotter_output WHERE spotter_output.date < '".date('Y')."-01-01 00:00:00'"; |
||
| 1276 | //echo $query; |
||
| 1277 | try { |
||
| 1278 | $sth = $this->db->prepare($query); |
||
| 1279 | $sth->execute(); |
||
| 1280 | } catch(PDOException $e) { |
||
| 1281 | return "error : ".$e->getMessage().' - query : '.$query."\n"; |
||
| 1282 | } |
||
| 1283 | } |
||
| 1284 | $query = "DELETE FROM spotter_output WHERE spotter_output.date < '".date('Y')."-01-01 00:00:00'"; |
||
| 1285 | try { |
||
| 1286 | $sth = $this->db->prepare($query); |
||
| 1287 | $sth->execute(); |
||
| 1288 | } catch(PDOException $e) { |
||
| 1289 | return "error : ".$e->getMessage().' - query : '.$query."\n"; |
||
| 1290 | } |
||
| 1291 | } |
||
| 1292 | } |
||
| 1293 | if (!isset($globalArchiveMonths) || $globalArchiveMonths == '') $globalArchiveMonths = 2; |
||
| 1294 | if ($globalArchiveMonths > 0) { |
||
| 1295 | $alldata = $Spotter->countAllAircraftTypes(false,$globalArchiveMonths); |
||
| 1296 | foreach ($alldata as $number) { |
||
| 1297 | $this->addStatAircraft($number['aircraft_icao'],$number['aircraft_icao_count'],$number['aircraft_name'],$number['aircraft_manufacturer']); |
||
| 1298 | } |
||
| 1299 | $alldata = $Spotter->countAllAirlines(false,$globalArchiveMonths); |
||
| 1300 | foreach ($alldata as $number) { |
||
| 1301 | $this->addStatAirline($number['airline_icao'],$number['airline_count'],$number['airline_name']); |
||
| 1302 | } |
||
| 1303 | $alldata = $Spotter->countAllAircraftRegistrations(false,$globalArchiveMonths); |
||
| 1304 | foreach ($alldata as $number) { |
||
| 1305 | $this->addStatAircraftRegistration($number['registration'],$number['aircraft_registration_count'],$number['aircraft_icao']); |
||
| 1306 | } |
||
| 1307 | $alldata = $Spotter->countAllCallsigns(false,$globalArchiveMonths); |
||
| 1308 | foreach ($alldata as $number) { |
||
| 1309 | $this->addStatCallsign($number['callsign_icao'],$number['callsign_icao_count'],$number['airline_icao']); |
||
| 1310 | } |
||
| 1311 | $alldata = $Spotter->countAllOwners(false,$globalArchiveMonths); |
||
| 1312 | foreach ($alldata as $number) { |
||
| 1313 | $this->addStatOwner($number['owner_name'],$number['owner_count']); |
||
| 1314 | } |
||
| 1315 | if ($Connection->tableExists('countries')) { |
||
| 1316 | $alldata = $Spotter->countAllFlightOverCountries(false,$globalArchiveMonths); |
||
| 1317 | foreach ($alldata as $number) { |
||
| 1318 | $this->addStatCountry($number['flight_country_iso2'],$number['flight_country_iso3'],$number['flight_country'],$number['flight_count']); |
||
| 1319 | } |
||
| 1320 | } |
||
| 1321 | $alldata = $Spotter->countAllPilots(false,$globalArchiveMonths); |
||
| 1322 | foreach ($alldata as $number) { |
||
| 1323 | $this->addStatPilot($number['pilot_id'],$number['pilot_count'],$number['pilot_name']); |
||
| 1324 | } |
||
| 1325 | $pall = $Spotter->countAllDepartureAirports(false,$globalArchiveMonths); |
||
| 1326 | $dall = $Spotter->countAllDetectedDepartureAirports(false,$globalArchiveMonths); |
||
| 1327 | $alldata = array(); |
||
| 1328 | foreach ($pall as $value) { |
||
| 1329 | $icao = $value['airport_departure_icao']; |
||
| 1330 | $alldata[$icao] = $value; |
||
| 1331 | } |
||
| 1332 | foreach ($dall as $value) { |
||
| 1333 | $icao = $value['airport_departure_icao']; |
||
| 1334 | if (isset($alldata[$icao])) { |
||
| 1335 | $alldata[$icao]['airport_departure_icao_count'] = $alldata[$icao]['airport_departure_icao_count'] + $value['airport_departure_icao_count']; |
||
| 1336 | } else $alldata[$icao] = $value; |
||
| 1337 | } |
||
| 1338 | $count = array(); |
||
| 1339 | foreach ($alldata as $key => $row) { |
||
| 1340 | $count[$key] = $row['airport_departure_icao_count']; |
||
| 1341 | } |
||
| 1342 | array_multisort($count,SORT_DESC,$alldata); |
||
| 1343 | |||
| 1344 | //print_r($alldate); |
||
| 1345 | foreach ($alldata as $number) { |
||
| 1346 | $this->addStatDepartureAirports($number['airport_departure_icao'],$number['airport_departure_name'],$number['airport_departure_city'],$number['airport_departure_country'],$number['airport_departure_icao_count']); |
||
| 1347 | } |
||
| 1348 | $pdata = $Spotter->countAllArrivalAirports(false,$globalArchiveMonths); |
||
| 1349 | $dall = $Spotter->countAllDetectedArrivalAirports(false,$globalArchiveMonths); |
||
| 1350 | $alldata = array(); |
||
| 1351 | foreach ($pdata as $value) { |
||
| 1352 | $icao = $value['airport_arrival_icao']; |
||
| 1353 | $alldata[$icao] = $value; |
||
| 1354 | } |
||
| 1355 | foreach ($dall as $value) { |
||
| 1356 | $icao = $value['airport_arrival_icao']; |
||
| 1357 | if (isset($alldata[$icao])) { |
||
| 1358 | $alldata[$icao]['airport_arrival_icao_count'] = $alldata[$icao]['airport_arrival_icao_count'] + $value['airport_arrival_icao_count']; |
||
| 1359 | } else $alldata[$icao] = $value; |
||
| 1360 | } |
||
| 1361 | $count = array(); |
||
| 1362 | foreach ($alldata as $key => $row) { |
||
| 1363 | $count[$key] = $row['airport_arrival_icao_count']; |
||
| 1364 | } |
||
| 1365 | array_multisort($count,SORT_DESC,$alldata); |
||
| 1366 | foreach ($alldata as $number) { |
||
| 1367 | $this->addStatArrivalAirports($number['airport_arrival_icao'],$number['airport_arrival_name'],$number['airport_arrival_city'],$number['airport_arrival_country'],$number['airport_arrival_icao_count']); |
||
| 1368 | } |
||
| 1369 | $this->addStat('aircrafts_byyear',$this->getStatsAircraftTotal(),date('Y').'-01-01 00:00:00'); |
||
| 1370 | $this->addStat('airlines_byyear',$this->getStatsAirlineTotal(),date('Y').'-01-01 00:00:00'); |
||
| 1371 | $this->addStat('owner_byyear',$this->getStatsOwnerTotal(),date('Y').'-01-01 00:00:00'); |
||
| 1372 | $this->addStat('pilot_byyear',$this->getStatsPilotTotal(),date('Y').'-01-01 00:00:00'); |
||
| 1373 | |||
| 1374 | if ($globalArchive) { |
||
| 1375 | if ($globalDBdriver == 'mysql') { |
||
| 1376 | $query = "INSERT INTO spotter_archive_output SELECT * FROM spotter_output WHERE spotter_output.date < DATE_FORMAT(UTC_TIMESTAMP() - INTERVAL ".$globalArchiveMonths." MONTH, '%Y/%m/01')"; |
||
| 1377 | } else { |
||
| 1378 | $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)"; |
||
| 1379 | } |
||
| 1380 | try { |
||
| 1381 | $sth = $this->db->prepare($query); |
||
| 1382 | $sth->execute(); |
||
| 1383 | } catch(PDOException $e) { |
||
| 1384 | return "error : ".$e->getMessage().' - query : '.$query."\n"; |
||
| 1385 | } |
||
| 1386 | } |
||
| 1387 | |||
| 1388 | //$query = 'DELETE FROM spotter_output WHERE spotter_output.date < DATE_SUB(UTC_TIMESTAMP(), INTERVAL '.$globalArchiveMonths.' MONTH)'; |
||
| 1389 | if ($globalDBdriver == 'mysql') { |
||
| 1390 | $query = "DELETE FROM spotter_output WHERE spotter_output.date < DATE_FORMAT(UTC_TIMESTAMP() - INTERVAL ".$globalArchiveMonths." MONTH, '%Y/%m/01')"; |
||
| 1391 | } else { |
||
| 1392 | $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)"; |
||
| 1393 | } |
||
| 1394 | try { |
||
| 1395 | $sth = $this->db->prepare($query); |
||
| 1396 | $sth->execute(); |
||
| 1397 | } catch(PDOException $e) { |
||
| 1398 | return "error : ".$e->getMessage().' - query : '.$query."\n"; |
||
| 1399 | } |
||
| 1400 | } |
||
| 1401 | $this->addLastStatsUpdate('last_update_stats',date('Y-m-d G:i:s')); |
||
| 1402 | } else { |
||
| 1403 | */ |
||
| 1404 | if ($globalDebug) echo 'Update stats !'."\n"; |
||
| 1405 | if ($globalDebug) echo 'Count all aircraft types...'."\n"; |
||
| 1406 | if (isset($last_update[0]['value'])) { |
||
| 1407 | $last_update_day = $last_update[0]['value']; |
||
| 1408 | } else $last_update_day = '2012-12-12 12:12:12'; |
||
| 1409 | $Spotter = new Spotter($this->db); |
||
| 1410 | $alldata = $Spotter->countAllAircraftTypes(false,0,$last_update_day); |
||
| 1411 | foreach ($alldata as $number) { |
||
| 1412 | $this->addStatAircraft($number['aircraft_icao'],$number['aircraft_icao_count'],$number['aircraft_name'],$number['aircraft_manufacturer']); |
||
| 1413 | } |
||
| 1414 | if ($globalDebug) echo 'Count all airlines...'."\n"; |
||
| 1415 | $alldata = $Spotter->countAllAirlines(false,0,$last_update_day); |
||
| 1416 | foreach ($alldata as $number) { |
||
| 1417 | $this->addStatAirline($number['airline_icao'],$number['airline_count'],$number['airline_name']); |
||
| 1418 | } |
||
| 1419 | if ($globalDebug) echo 'Count all registrations...'."\n"; |
||
| 1420 | $alldata = $Spotter->countAllAircraftRegistrations(false,0,$last_update_day); |
||
| 1421 | foreach ($alldata as $number) { |
||
| 1422 | $this->addStatAircraftRegistration($number['registration'],$number['aircraft_registration_count'],$number['aircraft_icao']); |
||
| 1423 | } |
||
| 1424 | if ($globalDebug) echo 'Count all callsigns...'."\n"; |
||
| 1425 | $alldata = $Spotter->countAllCallsigns(false,0,$last_update_day); |
||
| 1426 | foreach ($alldata as $number) { |
||
| 1427 | $this->addStatCallsign($number['callsign_icao'],$number['callsign_icao_count'],$number['airline_icao']); |
||
| 1428 | } |
||
| 1429 | if ($globalDebug) echo 'Count all owners...'."\n"; |
||
| 1430 | $alldata = $Spotter->countAllOwners(false,0,$last_update_day); |
||
| 1431 | foreach ($alldata as $number) { |
||
| 1432 | $this->addStatOwner($number['owner_name'],$number['owner_count']); |
||
| 1433 | } |
||
| 1434 | if ($globalDebug) echo 'Count all pilots...'."\n"; |
||
| 1435 | $alldata = $Spotter->countAllPilots(false,0,$last_update_day); |
||
| 1436 | foreach ($alldata as $number) { |
||
| 1437 | $this->addStatPilot($number['pilot_id'],$number['pilot_count'],$number['pilot_name'],'','',$number['format_source']); |
||
| 1438 | } |
||
| 1439 | |||
| 1440 | if ($globalDebug) echo 'Count all departure airports...'."\n"; |
||
| 1441 | $pall = $Spotter->countAllDepartureAirports(false,0,$last_update_day); |
||
| 1442 | if ($globalDebug) echo 'Count all detected departure airports...'."\n"; |
||
| 1443 | $dall = $Spotter->countAllDetectedDepartureAirports(false,0,$last_update_day); |
||
| 1444 | if ($globalDebug) echo 'Order departure airports...'."\n"; |
||
| 1445 | $alldata = array(); |
||
| 1446 | |||
| 1447 | foreach ($pall as $value) { |
||
| 1448 | $icao = $value['airport_departure_icao']; |
||
| 1449 | $alldata[$icao] = $value; |
||
| 1450 | } |
||
| 1451 | foreach ($dall as $value) { |
||
| 1452 | $icao = $value['airport_departure_icao']; |
||
| 1453 | if (isset($alldata[$icao])) { |
||
| 1454 | $alldata[$icao]['airport_departure_icao_count'] = $alldata[$icao]['airport_departure_icao_count'] + $value['airport_departure_icao_count']; |
||
| 1455 | } else $alldata[$icao] = $value; |
||
| 1456 | } |
||
| 1457 | $count = array(); |
||
| 1458 | foreach ($alldata as $key => $row) { |
||
| 1459 | $count[$key] = $row['airport_departure_icao_count']; |
||
| 1460 | } |
||
| 1461 | array_multisort($count,SORT_DESC,$alldata); |
||
| 1462 | foreach ($alldata as $number) { |
||
| 1463 | echo $this->addStatDepartureAirports($number['airport_departure_icao'],$number['airport_departure_name'],$number['airport_departure_city'],$number['airport_departure_country'],$number['airport_departure_icao_count']); |
||
| 1464 | } |
||
| 1465 | if ($globalDebug) echo 'Count all arrival airports...'."\n"; |
||
| 1466 | $pall = $Spotter->countAllArrivalAirports(false,0,$last_update_day); |
||
| 1467 | if ($globalDebug) echo 'Count all detected arrival airports...'."\n"; |
||
| 1468 | $dall = $Spotter->countAllDetectedArrivalAirports(false,0,$last_update_day); |
||
| 1469 | if ($globalDebug) echo 'Order arrival airports...'."\n"; |
||
| 1470 | $alldata = array(); |
||
| 1471 | foreach ($pall as $value) { |
||
| 1472 | $icao = $value['airport_arrival_icao']; |
||
| 1473 | $alldata[$icao] = $value; |
||
| 1474 | } |
||
| 1475 | foreach ($dall as $value) { |
||
| 1476 | $icao = $value['airport_arrival_icao']; |
||
| 1477 | if (isset($alldata[$icao])) { |
||
| 1478 | $alldata[$icao]['airport_arrival_icao_count'] = $alldata[$icao]['airport_arrival_icao_count'] + $value['airport_arrival_icao_count']; |
||
| 1479 | } else $alldata[$icao] = $value; |
||
| 1480 | } |
||
| 1481 | $count = array(); |
||
| 1482 | foreach ($alldata as $key => $row) { |
||
| 1483 | $count[$key] = $row['airport_arrival_icao_count']; |
||
| 1484 | } |
||
| 1485 | array_multisort($count,SORT_DESC,$alldata); |
||
| 1486 | foreach ($alldata as $number) { |
||
| 1487 | echo $this->addStatArrivalAirports($number['airport_arrival_icao'],$number['airport_arrival_name'],$number['airport_arrival_city'],$number['airport_arrival_country'],$number['airport_arrival_icao_count']); |
||
| 1488 | } |
||
| 1489 | if ($Connection->tableExists('countries')) { |
||
| 1490 | if ($globalDebug) echo 'Count all flights by countries...'."\n"; |
||
| 1491 | $SpotterArchive = new SpotterArchive(); |
||
| 1492 | $alldata = $SpotterArchive->countAllFlightOverCountries(false,0,$last_update_day); |
||
| 1493 | foreach ($alldata as $number) { |
||
| 1494 | $this->addStatCountry($number['flight_country_iso2'],$number['flight_country_iso3'],$number['flight_country'],$number['flight_count']); |
||
| 1495 | } |
||
| 1496 | } |
||
| 1497 | |||
| 1498 | |||
| 1499 | // Add by month using getstat if month finish... |
||
| 1500 | |||
| 1501 | //if (date('m',strtotime($last_update_day)) != date('m')) { |
||
| 1502 | if ($globalDebug) echo 'Count all flights by months...'."\n"; |
||
| 1503 | $Spotter = new Spotter($this->db); |
||
| 1504 | $alldata = $Spotter->countAllMonths(); |
||
| 1505 | $lastyear = false; |
||
|
|
|||
| 1506 | foreach ($alldata as $number) { |
||
| 1507 | if ($number['year_name'] != date('Y')) $lastyear = true; |
||
| 1508 | $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']))); |
||
| 1509 | } |
||
| 1510 | if ($globalDebug) echo 'Count all military flights by months...'."\n"; |
||
| 1511 | $alldata = $Spotter->countAllMilitaryMonths(); |
||
| 1512 | foreach ($alldata as $number) { |
||
| 1513 | $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']))); |
||
| 1514 | } |
||
| 1515 | if ($globalDebug) echo 'Count all owners by months...'."\n"; |
||
| 1516 | $alldata = $Spotter->countAllMonthsOwners(); |
||
| 1517 | foreach ($alldata as $number) { |
||
| 1518 | $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']))); |
||
| 1519 | } |
||
| 1520 | if ($globalDebug) echo 'Count all pilots by months...'."\n"; |
||
| 1521 | $alldata = $Spotter->countAllMonthsPilots(); |
||
| 1522 | foreach ($alldata as $number) { |
||
| 1523 | $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']))); |
||
| 1524 | } |
||
| 1525 | if ($globalDebug) echo 'Count all airlines by months...'."\n"; |
||
| 1526 | $alldata = $Spotter->countAllMonthsAirlines(); |
||
| 1527 | foreach ($alldata as $number) { |
||
| 1528 | $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']))); |
||
| 1529 | } |
||
| 1530 | if ($globalDebug) echo 'Count all aircrafts by months...'."\n"; |
||
| 1531 | $alldata = $Spotter->countAllMonthsAircrafts(); |
||
| 1532 | foreach ($alldata as $number) { |
||
| 1533 | $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']))); |
||
| 1534 | } |
||
| 1535 | if ($globalDebug) echo 'Count all real arrivals by months...'."\n"; |
||
| 1536 | $alldata = $Spotter->countAllMonthsRealArrivals(); |
||
| 1537 | foreach ($alldata as $number) { |
||
| 1538 | $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']))); |
||
| 1539 | } |
||
| 1540 | if ($globalDebug) echo 'Airports data...'."\n"; |
||
| 1541 | if ($globalDebug) echo '...Departure'."\n"; |
||
| 1542 | $this->deleteStatAirport('daily'); |
||
| 1543 | // $pall = $Spotter->getLast7DaysAirportsDeparture(); |
||
| 1544 | // $dall = $Spotter->getLast7DaysDetectedAirportsDeparture(); |
||
| 1545 | $pall = $Spotter->getLast7DaysAirportsDeparture(); |
||
| 1546 | $dall = $Spotter->getLast7DaysDetectedAirportsDeparture(); |
||
| 1547 | /* |
||
| 1548 | $alldata = array(); |
||
| 1549 | foreach ($pall as $value) { |
||
| 1550 | $icao = $value['departure_airport_icao']; |
||
| 1551 | $alldata[$icao] = $value; |
||
| 1552 | } |
||
| 1553 | foreach ($dall as $value) { |
||
| 1554 | $icao = $value['departure_airport_icao']; |
||
| 1555 | $ddate = $value['date']; |
||
| 1556 | if (isset($alldata[$icao])) { |
||
| 1557 | $alldata[$icao]['departure_airport_count'] = $alldata[$icao]['departure_airport_count'] + $value['departure_airport_count']; |
||
| 1558 | } else $alldata[$icao] = $value; |
||
| 1559 | } |
||
| 1560 | $count = array(); |
||
| 1561 | foreach ($alldata as $key => $row) { |
||
| 1562 | $count[$key] = $row['departure_airport_count']; |
||
| 1563 | } |
||
| 1564 | array_multisort($count,SORT_DESC,$alldata); |
||
| 1565 | */ |
||
| 1566 | foreach ($dall as $value) { |
||
| 1567 | $icao = $value['departure_airport_icao']; |
||
| 1568 | $ddate = $value['date']; |
||
| 1569 | $find = false; |
||
| 1570 | foreach ($pall as $pvalue) { |
||
| 1571 | if ($pvalue['departure_airport_icao'] == $icao && $pvalue['date'] == $ddate) { |
||
| 1572 | $pvalue['departure_airport_count'] = $pvalue['departure_airport_count'] + $value['departure_airport_count']; |
||
| 1573 | $find = true; |
||
| 1574 | break; |
||
| 1575 | } |
||
| 1576 | } |
||
| 1577 | if ($find === false) { |
||
| 1578 | $pall[] = $value; |
||
| 1579 | } |
||
| 1580 | } |
||
| 1581 | $alldata = $pall; |
||
| 1582 | foreach ($alldata as $number) { |
||
| 1583 | $this->addStatDepartureAirportsDaily($number['date'],$number['departure_airport_icao'],$number['departure_airport_name'],$number['departure_airport_city'],$number['departure_airport_country'],$number['departure_airport_count']); |
||
| 1584 | } |
||
| 1585 | echo '...Arrival'."\n"; |
||
| 1586 | $pall = $Spotter->getLast7DaysAirportsArrival(); |
||
| 1587 | $dall = $Spotter->getLast7DaysDetectedAirportsArrival(); |
||
| 1588 | /* |
||
| 1589 | $alldata = array(); |
||
| 1590 | foreach ($pall as $value) { |
||
| 1591 | $icao = $value['arrival_airport_icao']; |
||
| 1592 | $alldata[$icao] = $value; |
||
| 1593 | } |
||
| 1594 | foreach ($dall as $value) { |
||
| 1595 | $icao = $value['arrival_airport_icao']; |
||
| 1596 | if (isset($alldata[$icao])) { |
||
| 1597 | $alldata[$icao]['arrival_airport_icao_count'] = $alldata[$icao]['arrival_airport_count'] + $value['arrival_airport_count']; |
||
| 1598 | } else $alldata[$icao] = $value; |
||
| 1599 | } |
||
| 1600 | $count = array(); |
||
| 1601 | foreach ($alldata as $key => $row) { |
||
| 1602 | $count[$key] = $row['arrival_airport_count']; |
||
| 1603 | } |
||
| 1604 | array_multisort($count,SORT_DESC,$alldata); |
||
| 1605 | */ |
||
| 1606 | |||
| 1607 | |||
| 1608 | foreach ($dall as $value) { |
||
| 1609 | $icao = $value['arrival_airport_icao']; |
||
| 1610 | $ddate = $value['date']; |
||
| 1611 | $find = false; |
||
| 1612 | foreach ($pall as $pvalue) { |
||
| 1613 | if ($pvalue['arrival_airport_icao'] == $icao && $pvalue['date'] == $ddate) { |
||
| 1614 | $pvalue['arrival_airport_count'] = $pvalue['arrival_airport_count'] + $value['arrival_airport_count']; |
||
| 1615 | $find = true; |
||
| 1616 | break; |
||
| 1617 | } |
||
| 1618 | } |
||
| 1619 | if ($find === false) { |
||
| 1620 | $pall[] = $value; |
||
| 1621 | } |
||
| 1622 | } |
||
| 1623 | $alldata = $pall; |
||
| 1624 | foreach ($alldata as $number) { |
||
| 1625 | $this->addStatArrivalAirportsDaily($number['date'],$number['arrival_airport_icao'],$number['arrival_airport_name'],$number['arrival_airport_city'],$number['arrival_airport_country'],$number['arrival_airport_count']); |
||
| 1626 | } |
||
| 1627 | |||
| 1628 | echo 'Flights data...'."\n"; |
||
| 1629 | $this->deleteStatFlight('month'); |
||
| 1630 | echo '-> countAllDatesLastMonth...'."\n"; |
||
| 1631 | $alldata = $Spotter->countAllDatesLastMonth(); |
||
| 1632 | foreach ($alldata as $number) { |
||
| 1633 | $this->addStatFlight('month',$number['date_name'],$number['date_count']); |
||
| 1634 | } |
||
| 1635 | echo '-> countAllDates...'."\n"; |
||
| 1636 | $previousdata = $this->countAllDates(); |
||
| 1637 | $previousdatabyairlines = $this->countAllDatesByAirlines(); |
||
| 1638 | $this->deleteStatFlight('date'); |
||
| 1639 | $alldata = $Common->array_merge_noappend($previousdata,$Spotter->countAllDates()); |
||
| 1640 | $values = array(); |
||
| 1641 | foreach ($alldata as $cnt) { |
||
| 1642 | $values[] = $cnt['date_count']; |
||
| 1643 | } |
||
| 1644 | array_multisort($values,SORT_DESC,$alldata); |
||
| 1645 | array_splice($alldata,11); |
||
| 1646 | foreach ($alldata as $number) { |
||
| 1647 | $this->addStatFlight('date',$number['date_name'],$number['date_count']); |
||
| 1648 | } |
||
| 1649 | |||
| 1650 | $this->deleteStatFlight('hour'); |
||
| 1651 | echo '-> countAllHours...'."\n"; |
||
| 1652 | $alldata = $Spotter->countAllHours('hour'); |
||
| 1653 | foreach ($alldata as $number) { |
||
| 1654 | $this->addStatFlight('hour',$number['hour_name'],$number['hour_count']); |
||
| 1655 | } |
||
| 1656 | |||
| 1657 | |||
| 1658 | |||
| 1659 | // Count by airlines |
||
| 1660 | echo '--- Stats by airlines ---'."\n"; |
||
| 1661 | if ($globalDebug) echo 'Count all aircraft types by airlines...'."\n"; |
||
| 1662 | $Spotter = new Spotter($this->db); |
||
| 1663 | $alldata = $Spotter->countAllAircraftTypesByAirlines(false,0,$last_update_day); |
||
| 1664 | foreach ($alldata as $number) { |
||
| 1665 | $this->addStatAircraft($number['aircraft_icao'],$number['aircraft_icao_count'],$number['aircraft_name'],$number['aircraft_manufacturer'],$number['airline_icao']); |
||
| 1666 | } |
||
| 1667 | if ($globalDebug) echo 'Count all aircraft registrations by airlines...'."\n"; |
||
| 1668 | $alldata = $Spotter->countAllAircraftRegistrationsByAirlines(false,0,$last_update_day); |
||
| 1669 | foreach ($alldata as $number) { |
||
| 1670 | $this->addStatAircraftRegistration($number['registration'],$number['aircraft_registration_count'],$number['aircraft_icao'],$number['airline_icao']); |
||
| 1671 | } |
||
| 1672 | if ($globalDebug) echo 'Count all callsigns by airlines...'."\n"; |
||
| 1673 | $alldata = $Spotter->countAllCallsignsByAirlines(false,0,$last_update_day); |
||
| 1674 | foreach ($alldata as $number) { |
||
| 1675 | $this->addStatCallsign($number['callsign_icao'],$number['callsign_icao_count'],$number['airline_icao']); |
||
| 1676 | } |
||
| 1677 | if ($globalDebug) echo 'Count all owners by airlines...'."\n"; |
||
| 1678 | $alldata = $Spotter->countAllOwnersByAirlines(false,0,$last_update_day); |
||
| 1679 | foreach ($alldata as $number) { |
||
| 1680 | $this->addStatOwner($number['owner_name'],$number['owner_count'],$number['airline_icao']); |
||
| 1681 | } |
||
| 1682 | if ($globalDebug) echo 'Count all pilots by airlines...'."\n"; |
||
| 1683 | $alldata = $Spotter->countAllPilotsByAirlines(false,0,$last_update_day); |
||
| 1684 | foreach ($alldata as $number) { |
||
| 1685 | $this->addStatPilot($number['pilot_id'],$number['pilot_count'],$number['pilot_name'],$number['airline_icao'],'',$number['format_source']); |
||
| 1686 | } |
||
| 1687 | if ($globalDebug) echo 'Count all departure airports by airlines...'."\n"; |
||
| 1688 | $pall = $Spotter->countAllDepartureAirportsByAirlines(false,0,$last_update_day); |
||
| 1689 | if ($globalDebug) echo 'Count all detected departure airports by airlines...'."\n"; |
||
| 1690 | $dall = $Spotter->countAllDetectedDepartureAirportsByAirlines(false,0,$last_update_day); |
||
| 1691 | if ($globalDebug) echo 'Order detected departure airports by airlines...'."\n"; |
||
| 1692 | //$alldata = array(); |
||
| 1693 | foreach ($dall as $value) { |
||
| 1694 | $icao = $value['airport_departure_icao']; |
||
| 1695 | $dicao = $value['airline_icao']; |
||
| 1696 | $find = false; |
||
| 1697 | foreach ($pall as $pvalue) { |
||
| 1698 | if ($pvalue['airport_departure_icao'] == $icao && $pvalue['airline_icao'] = $dicao) { |
||
| 1699 | $pvalue['airport_departure_icao_count'] = $pvalue['airport_departure_icao_count'] + $value['airport_departure_icao_count']; |
||
| 1700 | $find = true; |
||
| 1701 | break; |
||
| 1702 | } |
||
| 1703 | } |
||
| 1704 | if ($find === false) { |
||
| 1705 | $pall[] = $value; |
||
| 1706 | } |
||
| 1707 | } |
||
| 1708 | $alldata = $pall; |
||
| 1709 | foreach ($alldata as $number) { |
||
| 1710 | 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']); |
||
| 1711 | } |
||
| 1712 | if ($globalDebug) echo 'Count all arrival airports by airlines...'."\n"; |
||
| 1713 | $pall = $Spotter->countAllArrivalAirportsByAirlines(false,0,$last_update_day); |
||
| 1714 | if ($globalDebug) echo 'Count all detected arrival airports by airlines...'."\n"; |
||
| 1715 | $dall = $Spotter->countAllDetectedArrivalAirportsByAirlines(false,0,$last_update_day); |
||
| 1716 | if ($globalDebug) echo 'Order arrival airports by airlines...'."\n"; |
||
| 1717 | //$alldata = array(); |
||
| 1718 | foreach ($dall as $value) { |
||
| 1719 | $icao = $value['airport_arrival_icao']; |
||
| 1720 | $dicao = $value['airline_icao']; |
||
| 1721 | $find = false; |
||
| 1722 | foreach ($pall as $pvalue) { |
||
| 1723 | if ($pvalue['airport_arrival_icao'] == $icao && $pvalue['airline_icao'] = $dicao) { |
||
| 1724 | $pvalue['airport_arrival_icao_count'] = $pvalue['airport_arrival_icao_count'] + $value['airport_arrival_icao_count']; |
||
| 1725 | $find = true; |
||
| 1726 | break; |
||
| 1727 | } |
||
| 1728 | } |
||
| 1729 | if ($find === false) { |
||
| 1730 | $pall[] = $value; |
||
| 1731 | } |
||
| 1732 | } |
||
| 1733 | $alldata = $pall; |
||
| 1734 | foreach ($alldata as $number) { |
||
| 1735 | 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']); |
||
| 1736 | } |
||
| 1737 | if ($globalDebug) echo 'Count all flights by months by airlines...'."\n"; |
||
| 1738 | $Spotter = new Spotter($this->db); |
||
| 1739 | $alldata = $Spotter->countAllMonthsByAirlines(); |
||
| 1740 | $lastyear = false; |
||
| 1741 | foreach ($alldata as $number) { |
||
| 1742 | if ($number['year_name'] != date('Y')) $lastyear = true; |
||
| 1743 | $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']); |
||
| 1744 | } |
||
| 1745 | if ($globalDebug) echo 'Count all owners by months by airlines...'."\n"; |
||
| 1746 | $alldata = $Spotter->countAllMonthsOwnersByAirlines(); |
||
| 1747 | foreach ($alldata as $number) { |
||
| 1748 | $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']); |
||
| 1749 | } |
||
| 1750 | if ($globalDebug) echo 'Count all pilots by months by airlines...'."\n"; |
||
| 1751 | $alldata = $Spotter->countAllMonthsPilotsByAirlines(); |
||
| 1752 | foreach ($alldata as $number) { |
||
| 1753 | $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']); |
||
| 1754 | } |
||
| 1755 | if ($globalDebug) echo 'Count all aircrafts by months by airlines...'."\n"; |
||
| 1756 | $alldata = $Spotter->countAllMonthsAircraftsByAirlines(); |
||
| 1757 | foreach ($alldata as $number) { |
||
| 1758 | $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']); |
||
| 1759 | } |
||
| 1760 | if ($globalDebug) echo 'Count all real arrivals by months by airlines...'."\n"; |
||
| 1761 | $alldata = $Spotter->countAllMonthsRealArrivalsByAirlines(); |
||
| 1762 | foreach ($alldata as $number) { |
||
| 1763 | $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']); |
||
| 1764 | } |
||
| 1765 | if ($globalDebug) echo '...Departure'."\n"; |
||
| 1766 | $pall = $Spotter->getLast7DaysAirportsDepartureByAirlines(); |
||
| 1767 | $dall = $Spotter->getLast7DaysDetectedAirportsDepartureByAirlines(); |
||
| 1768 | foreach ($dall as $value) { |
||
| 1769 | $icao = $value['departure_airport_icao']; |
||
| 1770 | $airline = $value['airline_icao']; |
||
| 1771 | $ddate = $value['date']; |
||
| 1772 | $find = false; |
||
| 1773 | foreach ($pall as $pvalue) { |
||
| 1774 | if ($pvalue['departure_airport_icao'] == $icao && $pvalue['date'] == $ddate && $pvalue['airline_icao'] = $airline) { |
||
| 1775 | $pvalue['departure_airport_count'] = $pvalue['departure_airport_count'] + $value['departure_airport_count']; |
||
| 1776 | $find = true; |
||
| 1777 | break; |
||
| 1778 | } |
||
| 1779 | } |
||
| 1780 | if ($find === false) { |
||
| 1781 | $pall[] = $value; |
||
| 1782 | } |
||
| 1783 | } |
||
| 1784 | $alldata = $pall; |
||
| 1785 | foreach ($alldata as $number) { |
||
| 1786 | $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']); |
||
| 1787 | } |
||
| 1788 | if ($globalDebug) echo '...Arrival'."\n"; |
||
| 1789 | $pall = $Spotter->getLast7DaysAirportsArrivalByAirlines(); |
||
| 1790 | $dall = $Spotter->getLast7DaysDetectedAirportsArrivalByAirlines(); |
||
| 1791 | foreach ($dall as $value) { |
||
| 1792 | $icao = $value['arrival_airport_icao']; |
||
| 1793 | $airline = $value['airline_icao']; |
||
| 1794 | $ddate = $value['date']; |
||
| 1795 | $find = false; |
||
| 1796 | foreach ($pall as $pvalue) { |
||
| 1797 | if ($pvalue['arrival_airport_icao'] == $icao && $pvalue['date'] == $ddate && $pvalue['airline_icao'] == $airline) { |
||
| 1798 | $pvalue['arrival_airport_count'] = $pvalue['arrival_airport_count'] + $value['arrival_airport_count']; |
||
| 1799 | $find = true; |
||
| 1800 | break; |
||
| 1801 | } |
||
| 1802 | } |
||
| 1803 | if ($find === false) { |
||
| 1804 | $pall[] = $value; |
||
| 1805 | } |
||
| 1806 | } |
||
| 1807 | $alldata = $pall; |
||
| 1808 | foreach ($alldata as $number) { |
||
| 1809 | $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']); |
||
| 1810 | } |
||
| 1811 | |||
| 1812 | if ($globalDebug) echo 'Flights data...'."\n"; |
||
| 1813 | if ($globalDebug) echo '-> countAllDatesLastMonth...'."\n"; |
||
| 1814 | $alldata = $Spotter->countAllDatesLastMonthByAirlines(); |
||
| 1815 | foreach ($alldata as $number) { |
||
| 1816 | $this->addStatFlight('month',$number['date_name'],$number['date_count'], $number['airline_icao']); |
||
| 1817 | } |
||
| 1818 | if ($globalDebug) echo '-> countAllDates...'."\n"; |
||
| 1819 | //$previousdata = $this->countAllDatesByAirlines(); |
||
| 1820 | $alldata = $Common->array_merge_noappend($previousdatabyairlines,$Spotter->countAllDatesByAirlines()); |
||
| 1821 | $values = array(); |
||
| 1822 | foreach ($alldata as $cnt) { |
||
| 1823 | $values[] = $cnt['date_count']; |
||
| 1824 | } |
||
| 1825 | array_multisort($values,SORT_DESC,$alldata); |
||
| 1826 | array_splice($alldata,11); |
||
| 1827 | foreach ($alldata as $number) { |
||
| 1828 | $this->addStatFlight('date',$number['date_name'],$number['date_count'],$number['airline_icao']); |
||
| 1829 | } |
||
| 1830 | |||
| 1831 | if ($globalDebug) echo '-> countAllHours...'."\n"; |
||
| 1832 | $alldata = $Spotter->countAllHoursByAirlines('hour'); |
||
| 1833 | foreach ($alldata as $number) { |
||
| 1834 | $this->addStatFlight('hour',$number['hour_name'],$number['hour_count'],$number['airline_icao']); |
||
| 1835 | } |
||
| 1836 | |||
| 1837 | |||
| 1838 | if (!isset($globalStatsFilters) || $globalStatsFilters == '') $globalStatsFilters = array(); |
||
| 1839 | foreach ($globalStatsFilters as $name => $filter) { |
||
| 1840 | //$filter_name = $filter['name']; |
||
| 1841 | $filter_name = $name; |
||
| 1842 | |||
| 1843 | $last_update = $this->getLastStatsUpdate('last_update_stats_'.$filter_name); |
||
| 1844 | if (isset($last_update[0]['value'])) { |
||
| 1845 | $last_update_day = $last_update[0]['value']; |
||
| 1846 | } else $last_update_day = '2012-12-12 12:12:12'; |
||
| 1847 | |||
| 1848 | // Count by filter |
||
| 1849 | if ($globalDebug) echo '--- Stats for filter '.$filter_name.' ---'."\n"; |
||
| 1850 | $Spotter = new Spotter($this->db); |
||
| 1851 | $alldata = $Spotter->countAllAircraftTypes(false,0,$last_update_day,$filter); |
||
| 1852 | foreach ($alldata as $number) { |
||
| 1853 | $this->addStatAircraft($number['aircraft_icao'],$number['aircraft_icao_count'],$number['aircraft_name'],$number['aircraft_manufacturer'],'',$filter_name); |
||
| 1854 | } |
||
| 1855 | $alldata = $Spotter->countAllAirlines(false,0,$last_update_day,$filter); |
||
| 1856 | foreach ($alldata as $number) { |
||
| 1857 | $this->addStatAirline($number['airline_icao'],$number['airline_count'],$number['airline_name'],$filter_name); |
||
| 1858 | } |
||
| 1859 | $alldata = $Spotter->countAllAircraftRegistrations(false,0,$last_update_day,$filter); |
||
| 1860 | foreach ($alldata as $number) { |
||
| 1861 | $this->addStatAircraftRegistration($number['registration'],$number['aircraft_registration_count'],$number['aircraft_icao'],'',$filter_name); |
||
| 1862 | } |
||
| 1863 | $alldata = $Spotter->countAllCallsigns(false,0,$last_update_day,$filter); |
||
| 1864 | foreach ($alldata as $number) { |
||
| 1865 | $this->addStatCallsign($number['callsign_icao'],$number['callsign_icao_count'],'',$filter_name); |
||
| 1866 | } |
||
| 1867 | $alldata = $Spotter->countAllOwners(false,0,$last_update_day,$filter); |
||
| 1868 | foreach ($alldata as $number) { |
||
| 1869 | $this->addStatOwner($number['owner_name'],$number['owner_count'],'',$filter_name); |
||
| 1870 | } |
||
| 1871 | $alldata = $Spotter->countAllPilots(false,0,$last_update_day,$filter); |
||
| 1872 | foreach ($alldata as $number) { |
||
| 1873 | $this->addStatPilot($number['pilot_id'],$number['pilot_count'],$number['pilot_name'],'',$filter_name,$number['format_source']); |
||
| 1874 | } |
||
| 1875 | $pall = $Spotter->countAllDepartureAirports(false,0,$last_update_day,$filter); |
||
| 1876 | $dall = $Spotter->countAllDetectedDepartureAirports(false,0,$last_update_day,$filter); |
||
| 1877 | $alldata = array(); |
||
| 1878 | foreach ($pall as $value) { |
||
| 1879 | $icao = $value['airport_departure_icao']; |
||
| 1880 | $alldata[$icao] = $value; |
||
| 1881 | } |
||
| 1882 | foreach ($dall as $value) { |
||
| 1883 | $icao = $value['airport_departure_icao']; |
||
| 1884 | if (isset($alldata[$icao])) { |
||
| 1885 | $alldata[$icao]['airport_departure_icao_count'] = $alldata[$icao]['airport_departure_icao_count'] + $value['airport_departure_icao_count']; |
||
| 1886 | } else $alldata[$icao] = $value; |
||
| 1887 | } |
||
| 1888 | $count = array(); |
||
| 1889 | foreach ($alldata as $key => $row) { |
||
| 1890 | $count[$key] = $row['airport_departure_icao_count']; |
||
| 1891 | } |
||
| 1892 | array_multisort($count,SORT_DESC,$alldata); |
||
| 1893 | foreach ($alldata as $number) { |
||
| 1894 | 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); |
||
| 1895 | } |
||
| 1896 | $pall = $Spotter->countAllArrivalAirports(false,0,$last_update_day,$filter); |
||
| 1897 | $dall = $Spotter->countAllDetectedArrivalAirports(false,0,$last_update_day,$filter); |
||
| 1898 | $alldata = array(); |
||
| 1899 | foreach ($pall as $value) { |
||
| 1900 | $icao = $value['airport_arrival_icao']; |
||
| 1901 | $alldata[$icao] = $value; |
||
| 1902 | } |
||
| 1903 | foreach ($dall as $value) { |
||
| 1904 | $icao = $value['airport_arrival_icao']; |
||
| 1905 | if (isset($alldata[$icao])) { |
||
| 1906 | $alldata[$icao]['airport_arrival_icao_count'] = $alldata[$icao]['airport_arrival_icao_count'] + $value['airport_arrival_icao_count']; |
||
| 1907 | } else $alldata[$icao] = $value; |
||
| 1908 | } |
||
| 1909 | $count = array(); |
||
| 1910 | foreach ($alldata as $key => $row) { |
||
| 1911 | $count[$key] = $row['airport_arrival_icao_count']; |
||
| 1912 | } |
||
| 1913 | array_multisort($count,SORT_DESC,$alldata); |
||
| 1914 | foreach ($alldata as $number) { |
||
| 1915 | 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); |
||
| 1916 | } |
||
| 1917 | $Spotter = new Spotter($this->db); |
||
| 1918 | $alldata = $Spotter->countAllMonths($filter); |
||
| 1919 | $lastyear = false; |
||
| 1920 | foreach ($alldata as $number) { |
||
| 1921 | if ($number['year_name'] != date('Y')) $lastyear = true; |
||
| 1922 | $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); |
||
| 1923 | } |
||
| 1924 | $alldata = $Spotter->countAllMonthsOwners($filter); |
||
| 1925 | foreach ($alldata as $number) { |
||
| 1926 | $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); |
||
| 1927 | } |
||
| 1928 | $alldata = $Spotter->countAllMonthsPilots($filter); |
||
| 1929 | foreach ($alldata as $number) { |
||
| 1930 | $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); |
||
| 1931 | } |
||
| 1932 | $alldata = $Spotter->countAllMilitaryMonths($filter); |
||
| 1933 | foreach ($alldata as $number) { |
||
| 1934 | $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'])),'',$filter_name); |
||
| 1935 | } |
||
| 1936 | $alldata = $Spotter->countAllMonthsAircrafts($filter); |
||
| 1937 | foreach ($alldata as $number) { |
||
| 1938 | $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); |
||
| 1939 | } |
||
| 1940 | $alldata = $Spotter->countAllMonthsRealArrivals($filter); |
||
| 1941 | foreach ($alldata as $number) { |
||
| 1942 | $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); |
||
| 1943 | } |
||
| 1944 | echo '...Departure'."\n"; |
||
| 1945 | $pall = $Spotter->getLast7DaysAirportsDeparture('',$filter); |
||
| 1946 | $dall = $Spotter->getLast7DaysDetectedAirportsDeparture('',$filter); |
||
| 1947 | foreach ($dall as $value) { |
||
| 1948 | $icao = $value['departure_airport_icao']; |
||
| 1949 | $ddate = $value['date']; |
||
| 1950 | $find = false; |
||
| 1951 | foreach ($pall as $pvalue) { |
||
| 1952 | if ($pvalue['departure_airport_icao'] == $icao && $pvalue['date'] == $ddate) { |
||
| 1953 | $pvalue['departure_airport_count'] = $pvalue['departure_airport_count'] + $value['departure_airport_count']; |
||
| 1954 | $find = true; |
||
| 1955 | break; |
||
| 1956 | } |
||
| 1957 | } |
||
| 1958 | if ($find === false) { |
||
| 1959 | $pall[] = $value; |
||
| 1960 | } |
||
| 1961 | } |
||
| 1962 | $alldata = $pall; |
||
| 1963 | foreach ($alldata as $number) { |
||
| 1964 | $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); |
||
| 1965 | } |
||
| 1966 | echo '...Arrival'."\n"; |
||
| 1967 | $pall = $Spotter->getLast7DaysAirportsArrival('',$filter); |
||
| 1968 | $dall = $Spotter->getLast7DaysDetectedAirportsArrival('',$filter); |
||
| 1969 | foreach ($dall as $value) { |
||
| 1970 | $icao = $value['arrival_airport_icao']; |
||
| 1971 | $ddate = $value['date']; |
||
| 1972 | $find = false; |
||
| 1973 | foreach ($pall as $pvalue) { |
||
| 1974 | if ($pvalue['arrival_airport_icao'] == $icao && $pvalue['date'] == $ddate) { |
||
| 1975 | $pvalue['arrival_airport_count'] = $pvalue['arrival_airport_count'] + $value['arrival_airport_count']; |
||
| 1976 | $find = true; |
||
| 1977 | break; |
||
| 1978 | } |
||
| 1979 | } |
||
| 1980 | if ($find === false) { |
||
| 1981 | $pall[] = $value; |
||
| 1982 | } |
||
| 1983 | } |
||
| 1984 | $alldata = $pall; |
||
| 1985 | foreach ($alldata as $number) { |
||
| 1986 | $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); |
||
| 1987 | } |
||
| 1988 | |||
| 1989 | echo 'Flights data...'."\n"; |
||
| 1990 | echo '-> countAllDatesLastMonth...'."\n"; |
||
| 1991 | $alldata = $Spotter->countAllDatesLastMonth($filter); |
||
| 1992 | foreach ($alldata as $number) { |
||
| 1993 | $this->addStatFlight('month',$number['date_name'],$number['date_count'], '',$filter_name); |
||
| 1994 | } |
||
| 1995 | echo '-> countAllDates...'."\n"; |
||
| 1996 | $previousdata = $this->countAllDates('',$filter_name); |
||
| 1997 | $alldata = $Common->array_merge_noappend($previousdata,$Spotter->countAllDates($filter)); |
||
| 1998 | $values = array(); |
||
| 1999 | foreach ($alldata as $cnt) { |
||
| 2000 | $values[] = $cnt['date_count']; |
||
| 2001 | } |
||
| 2002 | array_multisort($values,SORT_DESC,$alldata); |
||
| 2003 | array_splice($alldata,11); |
||
| 2004 | foreach ($alldata as $number) { |
||
| 2005 | $this->addStatFlight('date',$number['date_name'],$number['date_count'],'',$filter_name); |
||
| 2006 | } |
||
| 2007 | |||
| 2008 | echo '-> countAllHours...'."\n"; |
||
| 2009 | $alldata = $Spotter->countAllHours('hour',$filter); |
||
| 2010 | foreach ($alldata as $number) { |
||
| 2011 | $this->addStatFlight('hour',$number['hour_name'],$number['hour_count'],'',$filter_name); |
||
| 2012 | } |
||
| 2013 | echo 'Insert last stats update date...'."\n"; |
||
| 2014 | date_default_timezone_set('UTC'); |
||
| 2015 | $this->addLastStatsUpdate('last_update_stats_'.$filter_name,date('Y-m-d G:i:s')); |
||
| 2016 | if (isset($filter['DeleteLastYearStats']) && $filter['DeleteLastYearStats'] == true) { |
||
| 2017 | if (date('Y',strtotime($last_update_day)) != date('Y')) { |
||
| 2018 | $this->deleteOldStats($filter_name); |
||
| 2019 | $this->addLastStatsUpdate('last_update_stats_'.$filter_name,date('Y').'-01-01 00:00:00'); |
||
| 2020 | } |
||
| 2021 | } |
||
| 2022 | |||
| 2023 | } |
||
| 2024 | |||
| 2025 | |||
| 2026 | // Last year stats |
||
| 2027 | if ($lastyear) { |
||
| 2028 | echo 'Data from last year...'."\n"; |
||
| 2029 | // SUM all previous month to put as year |
||
| 2030 | $previous_year = date('Y'); |
||
| 2031 | $previous_year--; |
||
| 2032 | $this->addStat('aircrafts_byyear',$this->getSumStats('aircrafts_bymonth',$previous_year),$previous_year.'-01-01 00:00:00'); |
||
| 2033 | $this->addStat('airlines_byyear',$this->getSumStats('airlines_bymonth',$previous_year),$previous_year.'-01-01 00:00:00'); |
||
| 2034 | $this->addStat('owner_byyear',$this->getSumStats('owner_bymonth',$previous_year),$previous_year.'-01-01 00:00:00'); |
||
| 2035 | $this->addStat('pilot_byyear',$this->getSumStats('pilot_bymonth',$previous_year),$previous_year.'-01-01 00:00:00'); |
||
| 2036 | $allairlines = $this->getAllAirlineNames(); |
||
| 2037 | foreach ($allairlines as $data) { |
||
| 2038 | $this->addStat('aircrafts_byyear',$this->getSumStats('aircrafts_bymonth',$previous_year,$data['airline_icao']),$previous_year.'-01-01 00:00:00',$data['airline_icao']); |
||
| 2039 | $this->addStat('airlines_byyear',$this->getSumStats('airlines_bymonth',$previous_year,$data['airline_icao']),$previous_year.'-01-01 00:00:00',$data['airline_icao']); |
||
| 2040 | $this->addStat('owner_byyear',$this->getSumStats('owner_bymonth',$previous_year,$data['airline_icao']),$previous_year.'-01-01 00:00:00',$data['airline_icao']); |
||
| 2041 | $this->addStat('pilot_byyear',$this->getSumStats('pilot_bymonth',$previous_year,$data['airline_icao']),$previous_year.'-01-01 00:00:00',$data['airline_icao']); |
||
| 2042 | } |
||
| 2043 | |||
| 2044 | if (isset($globalArchiveYear) && $globalArchiveYear) { |
||
| 2045 | if ($globalArchive) { |
||
| 2046 | $query = "INSERT INTO spotter_archive_output SELECT * FROM spotter_output WHERE spotter_output.date < '".date('Y')."-01-01 00:00:00'"; |
||
| 2047 | try { |
||
| 2048 | $sth = $this->db->prepare($query); |
||
| 2049 | $sth->execute(); |
||
| 2050 | } catch(PDOException $e) { |
||
| 2051 | return "error : ".$e->getMessage().' - query : '.$query."\n"; |
||
| 2052 | } |
||
| 2053 | } |
||
| 2054 | echo 'Delete old data'."\n"; |
||
| 2055 | $query = "DELETE FROM spotter_output WHERE spotter_output.date < '".date('Y')."-01-01 00:00:00'"; |
||
| 2056 | try { |
||
| 2057 | $sth = $this->db->prepare($query); |
||
| 2058 | $sth->execute(); |
||
| 2059 | } catch(PDOException $e) { |
||
| 2060 | return "error : ".$e->getMessage().' - query : '.$query."\n"; |
||
| 2061 | } |
||
| 2062 | } |
||
| 2063 | if (isset($globalDeleteLastYearStats) && $globalDeleteLastYearStats) { |
||
| 2064 | $last_update = $this->getLastStatsUpdate('last_update_stats'); |
||
| 2065 | if (date('Y',strtotime($last_update[0]['value'])) != date('Y')) { |
||
| 2066 | $this->deleteOldStats(); |
||
| 2067 | $this->addLastStatsUpdate('last_update_stats',date('Y').'-01-01 00:00:00'); |
||
| 2068 | $lastyearupdate = true; |
||
| 2069 | } |
||
| 2070 | } |
||
| 2071 | } |
||
| 2072 | if ($globalArchiveMonths > 0) { |
||
| 2073 | if ($globalArchive) { |
||
| 2074 | echo 'Archive old data...'."\n"; |
||
| 2075 | if ($globalDBdriver == 'mysql') { |
||
| 2076 | //$query = "INSERT INTO spotter_archive_output SELECT * FROM spotter_output WHERE spotter_output.date < DATE_FORMAT(UTC_TIMESTAMP() - INTERVAL ".$globalArchiveMonths." MONTH, '%Y/%m/01')"; |
||
| 2077 | $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) |
||
| 2078 | 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 |
||
| 2079 | FROM spotter_output WHERE spotter_output.date < DATE_FORMAT(UTC_TIMESTAMP() - INTERVAL ".$globalArchiveMonths." MONTH, '%Y/%m/01')"; |
||
| 2080 | } else { |
||
| 2081 | $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) |
||
| 2082 | SELECT |
||
| 2083 | 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 |
||
| 2084 | FROM spotter_output WHERE spotter_output.date < CAST(to_char(CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalArchiveMonths." MONTHS', 'YYYY/mm/01') AS TIMESTAMP)"; |
||
| 2085 | } |
||
| 2086 | try { |
||
| 2087 | $sth = $this->db->prepare($query); |
||
| 2088 | $sth->execute(); |
||
| 2089 | } catch(PDOException $e) { |
||
| 2090 | return "error : ".$e->getMessage(); |
||
| 2091 | } |
||
| 2092 | } |
||
| 2093 | echo 'Deleting old data...'."\n"; |
||
| 2094 | //$query = 'DELETE FROM spotter_output WHERE spotter_output.date < DATE_SUB(UTC_TIMESTAMP(), INTERVAL '.$globalArchiveMonths.' MONTH)'; |
||
| 2095 | if ($globalDBdriver == 'mysql') { |
||
| 2096 | $query = "DELETE FROM spotter_output WHERE spotter_output.date < DATE_FORMAT(UTC_TIMESTAMP() - INTERVAL ".$globalArchiveMonths." MONTH, '%Y/%m/01')"; |
||
| 2097 | } else { |
||
| 2098 | $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)"; |
||
| 2099 | } |
||
| 2100 | try { |
||
| 2101 | $sth = $this->db->prepare($query); |
||
| 2102 | $sth->execute(); |
||
| 2103 | } catch(PDOException $e) { |
||
| 2104 | return "error : ".$e->getMessage(); |
||
| 2105 | } |
||
| 2106 | } |
||
| 2107 | if (!isset($lastyearupdate)) { |
||
| 2108 | echo 'Insert last stats update date...'."\n"; |
||
| 2109 | date_default_timezone_set('UTC'); |
||
| 2110 | $this->addLastStatsUpdate('last_update_stats',date('Y-m-d G:i:s')); |
||
| 2111 | } |
||
| 2112 | //} |
||
| 2113 | } |
||
| 2114 | } |
||
| 2116 | ?> |
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.