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