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