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