@@ -10,10 +10,10 @@ discard block |
||
| 10 | 10 | } |
| 11 | 11 | |
| 12 | 12 | /** |
| 13 | - * Get SQL query part for filter used |
|
| 14 | - * @param Array $filter the filter |
|
| 15 | - * @return Array the SQL part |
|
| 16 | - */ |
|
| 13 | + * Get SQL query part for filter used |
|
| 14 | + * @param Array $filter the filter |
|
| 15 | + * @return Array the SQL part |
|
| 16 | + */ |
|
| 17 | 17 | public function getFilter($filter = array(),$where = false,$and = false) { |
| 18 | 18 | global $globalFilter, $globalStatsFilters, $globalFilterName, $globalDBdriver; |
| 19 | 19 | $filters = array(); |
@@ -159,11 +159,11 @@ discard block |
||
| 159 | 159 | |
| 160 | 160 | |
| 161 | 161 | /** |
| 162 | - * Gets all the spotter information based on a particular callsign |
|
| 163 | - * |
|
| 164 | - * @return Array the spotter information |
|
| 165 | - * |
|
| 166 | - */ |
|
| 162 | + * Gets all the spotter information based on a particular callsign |
|
| 163 | + * |
|
| 164 | + * @return Array the spotter information |
|
| 165 | + * |
|
| 166 | + */ |
|
| 167 | 167 | public function getLastArchiveSpotterDataByIdent($ident) { |
| 168 | 168 | $Spotter = new Spotter($this->db); |
| 169 | 169 | date_default_timezone_set('UTC'); |
@@ -179,11 +179,11 @@ discard block |
||
| 179 | 179 | |
| 180 | 180 | |
| 181 | 181 | /** |
| 182 | - * Gets last the spotter information based on a particular id |
|
| 183 | - * |
|
| 184 | - * @return Array the spotter information |
|
| 185 | - * |
|
| 186 | - */ |
|
| 182 | + * Gets last the spotter information based on a particular id |
|
| 183 | + * |
|
| 184 | + * @return Array the spotter information |
|
| 185 | + * |
|
| 186 | + */ |
|
| 187 | 187 | public function getLastArchiveSpotterDataById($id) { |
| 188 | 188 | $Spotter = new Spotter($this->db); |
| 189 | 189 | date_default_timezone_set('UTC'); |
@@ -209,11 +209,11 @@ discard block |
||
| 209 | 209 | } |
| 210 | 210 | |
| 211 | 211 | /** |
| 212 | - * Gets all the spotter information based on a particular id |
|
| 213 | - * |
|
| 214 | - * @return Array the spotter information |
|
| 215 | - * |
|
| 216 | - */ |
|
| 212 | + * Gets all the spotter information based on a particular id |
|
| 213 | + * |
|
| 214 | + * @return Array the spotter information |
|
| 215 | + * |
|
| 216 | + */ |
|
| 217 | 217 | public function getAllArchiveSpotterDataById($id) { |
| 218 | 218 | date_default_timezone_set('UTC'); |
| 219 | 219 | $id = filter_var($id, FILTER_SANITIZE_STRING); |
@@ -234,11 +234,11 @@ discard block |
||
| 234 | 234 | } |
| 235 | 235 | |
| 236 | 236 | /** |
| 237 | - * Gets coordinate & time spotter information based on a particular id |
|
| 238 | - * |
|
| 239 | - * @return Array the spotter information |
|
| 240 | - * |
|
| 241 | - */ |
|
| 237 | + * Gets coordinate & time spotter information based on a particular id |
|
| 238 | + * |
|
| 239 | + * @return Array the spotter information |
|
| 240 | + * |
|
| 241 | + */ |
|
| 242 | 242 | public function getCoordArchiveSpotterDataById($id) { |
| 243 | 243 | date_default_timezone_set('UTC'); |
| 244 | 244 | $id = filter_var($id, FILTER_SANITIZE_STRING); |
@@ -255,11 +255,11 @@ discard block |
||
| 255 | 255 | } |
| 256 | 256 | |
| 257 | 257 | /** |
| 258 | - * Gets coordinate & time spotter information based on a particular id |
|
| 259 | - * |
|
| 260 | - * @return Array the spotter information |
|
| 261 | - * |
|
| 262 | - */ |
|
| 258 | + * Gets coordinate & time spotter information based on a particular id |
|
| 259 | + * |
|
| 260 | + * @return Array the spotter information |
|
| 261 | + * |
|
| 262 | + */ |
|
| 263 | 263 | public function getCoordArchiveSpotterDataByIdDate($id,$begindate,$enddate) { |
| 264 | 264 | date_default_timezone_set('UTC'); |
| 265 | 265 | $id = filter_var($id, FILTER_SANITIZE_STRING); |
@@ -277,11 +277,11 @@ discard block |
||
| 277 | 277 | |
| 278 | 278 | |
| 279 | 279 | /** |
| 280 | - * Gets altitude information based on a particular callsign |
|
| 281 | - * |
|
| 282 | - * @return Array the spotter information |
|
| 283 | - * |
|
| 284 | - */ |
|
| 280 | + * Gets altitude information based on a particular callsign |
|
| 281 | + * |
|
| 282 | + * @return Array the spotter information |
|
| 283 | + * |
|
| 284 | + */ |
|
| 285 | 285 | public function getAltitudeArchiveSpotterDataByIdent($ident) { |
| 286 | 286 | |
| 287 | 287 | date_default_timezone_set('UTC'); |
@@ -302,11 +302,11 @@ discard block |
||
| 302 | 302 | } |
| 303 | 303 | |
| 304 | 304 | /** |
| 305 | - * Gets altitude information based on a particular id |
|
| 306 | - * |
|
| 307 | - * @return Array the spotter information |
|
| 308 | - * |
|
| 309 | - */ |
|
| 305 | + * Gets altitude information based on a particular id |
|
| 306 | + * |
|
| 307 | + * @return Array the spotter information |
|
| 308 | + * |
|
| 309 | + */ |
|
| 310 | 310 | public function getAltitudeArchiveSpotterDataById($id) { |
| 311 | 311 | |
| 312 | 312 | date_default_timezone_set('UTC'); |
@@ -327,11 +327,11 @@ discard block |
||
| 327 | 327 | } |
| 328 | 328 | |
| 329 | 329 | /** |
| 330 | - * Gets altitude & speed information based on a particular id |
|
| 331 | - * |
|
| 332 | - * @return Array the spotter information |
|
| 333 | - * |
|
| 334 | - */ |
|
| 330 | + * Gets altitude & speed information based on a particular id |
|
| 331 | + * |
|
| 332 | + * @return Array the spotter information |
|
| 333 | + * |
|
| 334 | + */ |
|
| 335 | 335 | public function getAltitudeSpeedArchiveSpotterDataById($id) { |
| 336 | 336 | date_default_timezone_set('UTC'); |
| 337 | 337 | $id = filter_var($id, FILTER_SANITIZE_STRING); |
@@ -348,11 +348,11 @@ discard block |
||
| 348 | 348 | } |
| 349 | 349 | |
| 350 | 350 | /** |
| 351 | - * Gets altitude information based on a particular callsign |
|
| 352 | - * |
|
| 353 | - * @return Array the spotter information |
|
| 354 | - * |
|
| 355 | - */ |
|
| 351 | + * Gets altitude information based on a particular callsign |
|
| 352 | + * |
|
| 353 | + * @return Array the spotter information |
|
| 354 | + * |
|
| 355 | + */ |
|
| 356 | 356 | public function getLastAltitudeArchiveSpotterDataByIdent($ident) { |
| 357 | 357 | date_default_timezone_set('UTC'); |
| 358 | 358 | $ident = filter_var($ident, FILTER_SANITIZE_STRING); |
@@ -402,11 +402,11 @@ discard block |
||
| 402 | 402 | } |
| 403 | 403 | |
| 404 | 404 | /** |
| 405 | - * Gets Minimal Live Spotter data |
|
| 406 | - * |
|
| 407 | - * @return Array the spotter information |
|
| 408 | - * |
|
| 409 | - */ |
|
| 405 | + * Gets Minimal Live Spotter data |
|
| 406 | + * |
|
| 407 | + * @return Array the spotter information |
|
| 408 | + * |
|
| 409 | + */ |
|
| 410 | 410 | public function getMinLiveSpotterData($begindate,$enddate,$filter = array()) { |
| 411 | 411 | global $globalDBdriver, $globalLiveInterval; |
| 412 | 412 | date_default_timezone_set('UTC'); |
@@ -453,11 +453,11 @@ discard block |
||
| 453 | 453 | } |
| 454 | 454 | |
| 455 | 455 | /** |
| 456 | - * Gets Minimal Live Spotter data |
|
| 457 | - * |
|
| 458 | - * @return Array the spotter information |
|
| 459 | - * |
|
| 460 | - */ |
|
| 456 | + * Gets Minimal Live Spotter data |
|
| 457 | + * |
|
| 458 | + * @return Array the spotter information |
|
| 459 | + * |
|
| 460 | + */ |
|
| 461 | 461 | public function getMinLiveSpotterDataPlayback($begindate,$enddate,$filter = array()) { |
| 462 | 462 | global $globalDBdriver, $globalLiveInterval; |
| 463 | 463 | date_default_timezone_set('UTC'); |
@@ -524,11 +524,11 @@ discard block |
||
| 524 | 524 | } |
| 525 | 525 | |
| 526 | 526 | /** |
| 527 | - * Gets count Live Spotter data |
|
| 528 | - * |
|
| 529 | - * @return Array the spotter information |
|
| 530 | - * |
|
| 531 | - */ |
|
| 527 | + * Gets count Live Spotter data |
|
| 528 | + * |
|
| 529 | + * @return Array the spotter information |
|
| 530 | + * |
|
| 531 | + */ |
|
| 532 | 532 | public function getLiveSpotterCount($begindate,$enddate,$filter = array()) { |
| 533 | 533 | global $globalDBdriver, $globalLiveInterval; |
| 534 | 534 | date_default_timezone_set('UTC'); |
@@ -574,11 +574,11 @@ discard block |
||
| 574 | 574 | // Spotter_Archive_output |
| 575 | 575 | |
| 576 | 576 | /** |
| 577 | - * Gets all the spotter information |
|
| 578 | - * |
|
| 579 | - * @return Array the spotter information |
|
| 580 | - * |
|
| 581 | - */ |
|
| 577 | + * Gets all the spotter information |
|
| 578 | + * |
|
| 579 | + * @return Array the spotter information |
|
| 580 | + * |
|
| 581 | + */ |
|
| 582 | 582 | public function searchSpotterData($q = '', $registration = '', $aircraft_icao = '', $aircraft_manufacturer = '', $highlights = '', $airline_icao = '', $airline_country = '', $airline_type = '', $airport = '', $airport_country = '', $callsign = '', $departure_airport_route = '', $arrival_airport_route = '', $owner = '',$pilot_id = '',$pilot_name = '',$altitude = '', $date_posted = '', $limit = '', $sort = '', $includegeodata = '',$origLat = '',$origLon = '',$dist = '', $filters=array()) { |
| 583 | 583 | global $globalTimezone, $globalDBdriver; |
| 584 | 584 | require_once(dirname(__FILE__).'/class.Translation.php'); |
@@ -870,11 +870,11 @@ discard block |
||
| 870 | 870 | } |
| 871 | 871 | |
| 872 | 872 | /** |
| 873 | - * Gets all the spotter information based on the callsign |
|
| 874 | - * |
|
| 875 | - * @return Array the spotter information |
|
| 876 | - * |
|
| 877 | - */ |
|
| 873 | + * Gets all the spotter information based on the callsign |
|
| 874 | + * |
|
| 875 | + * @return Array the spotter information |
|
| 876 | + * |
|
| 877 | + */ |
|
| 878 | 878 | public function getSpotterDataByIdent($ident = '', $limit = '', $sort = '') { |
| 879 | 879 | $global_query = "SELECT spotter_archive_output.* FROM spotter_archive_output"; |
| 880 | 880 | |
@@ -922,11 +922,11 @@ discard block |
||
| 922 | 922 | |
| 923 | 923 | |
| 924 | 924 | /** |
| 925 | - * Gets all the spotter information based on the owner |
|
| 926 | - * |
|
| 927 | - * @return Array the spotter information |
|
| 928 | - * |
|
| 929 | - */ |
|
| 925 | + * Gets all the spotter information based on the owner |
|
| 926 | + * |
|
| 927 | + * @return Array the spotter information |
|
| 928 | + * |
|
| 929 | + */ |
|
| 930 | 930 | public function getSpotterDataByOwner($owner = '', $limit = '', $sort = '', $filter = array()) { |
| 931 | 931 | $global_query = "SELECT spotter_archive_output.* FROM spotter_archive_output"; |
| 932 | 932 | |
@@ -974,11 +974,11 @@ discard block |
||
| 974 | 974 | } |
| 975 | 975 | |
| 976 | 976 | /** |
| 977 | - * Gets all the spotter information based on the pilot |
|
| 978 | - * |
|
| 979 | - * @return Array the spotter information |
|
| 980 | - * |
|
| 981 | - */ |
|
| 977 | + * Gets all the spotter information based on the pilot |
|
| 978 | + * |
|
| 979 | + * @return Array the spotter information |
|
| 980 | + * |
|
| 981 | + */ |
|
| 982 | 982 | public function getSpotterDataByPilot($pilot = '', $limit = '', $sort = '', $filter = array()) { |
| 983 | 983 | $global_query = "SELECT spotter_archive_output.* FROM spotter_archive_output"; |
| 984 | 984 | |
@@ -1022,11 +1022,11 @@ discard block |
||
| 1022 | 1022 | } |
| 1023 | 1023 | |
| 1024 | 1024 | /** |
| 1025 | - * Gets all number of flight over countries |
|
| 1026 | - * |
|
| 1027 | - * @return Array the airline country list |
|
| 1028 | - * |
|
| 1029 | - */ |
|
| 1025 | + * Gets all number of flight over countries |
|
| 1026 | + * |
|
| 1027 | + * @return Array the airline country list |
|
| 1028 | + * |
|
| 1029 | + */ |
|
| 1030 | 1030 | public function countAllFlightOverCountries($limit = true,$olderthanmonths = 0,$sincedate = '') { |
| 1031 | 1031 | global $globalDBdriver; |
| 1032 | 1032 | /* |
@@ -1066,11 +1066,11 @@ discard block |
||
| 1066 | 1066 | } |
| 1067 | 1067 | |
| 1068 | 1068 | /** |
| 1069 | - * Gets all number of flight over countries |
|
| 1070 | - * |
|
| 1071 | - * @return Array the airline country list |
|
| 1072 | - * |
|
| 1073 | - */ |
|
| 1069 | + * Gets all number of flight over countries |
|
| 1070 | + * |
|
| 1071 | + * @return Array the airline country list |
|
| 1072 | + * |
|
| 1073 | + */ |
|
| 1074 | 1074 | public function countAllFlightOverCountriesByAirlines($limit = true,$olderthanmonths = 0,$sincedate = '') { |
| 1075 | 1075 | global $globalDBdriver; |
| 1076 | 1076 | /* |
@@ -1111,11 +1111,11 @@ discard block |
||
| 1111 | 1111 | } |
| 1112 | 1112 | |
| 1113 | 1113 | /** |
| 1114 | - * Gets last spotter information based on a particular callsign |
|
| 1115 | - * |
|
| 1116 | - * @return Array the spotter information |
|
| 1117 | - * |
|
| 1118 | - */ |
|
| 1114 | + * Gets last spotter information based on a particular callsign |
|
| 1115 | + * |
|
| 1116 | + * @return Array the spotter information |
|
| 1117 | + * |
|
| 1118 | + */ |
|
| 1119 | 1119 | public function getDateArchiveSpotterDataById($id,$date) { |
| 1120 | 1120 | $Spotter = new Spotter($this->db); |
| 1121 | 1121 | date_default_timezone_set('UTC'); |
@@ -1127,11 +1127,11 @@ discard block |
||
| 1127 | 1127 | } |
| 1128 | 1128 | |
| 1129 | 1129 | /** |
| 1130 | - * Gets all the spotter information based on a particular callsign |
|
| 1131 | - * |
|
| 1132 | - * @return Array the spotter information |
|
| 1133 | - * |
|
| 1134 | - */ |
|
| 1130 | + * Gets all the spotter information based on a particular callsign |
|
| 1131 | + * |
|
| 1132 | + * @return Array the spotter information |
|
| 1133 | + * |
|
| 1134 | + */ |
|
| 1135 | 1135 | public function getDateArchiveSpotterDataByIdent($ident,$date) { |
| 1136 | 1136 | $Spotter = new Spotter($this->db); |
| 1137 | 1137 | date_default_timezone_set('UTC'); |
@@ -1143,11 +1143,11 @@ discard block |
||
| 1143 | 1143 | } |
| 1144 | 1144 | |
| 1145 | 1145 | /** |
| 1146 | - * Gets all the spotter information based on the airport |
|
| 1147 | - * |
|
| 1148 | - * @return Array the spotter information |
|
| 1149 | - * |
|
| 1150 | - */ |
|
| 1146 | + * Gets all the spotter information based on the airport |
|
| 1147 | + * |
|
| 1148 | + * @return Array the spotter information |
|
| 1149 | + * |
|
| 1150 | + */ |
|
| 1151 | 1151 | public function getSpotterDataByAirport($airport = '', $limit = '', $sort = '',$filters = array()) { |
| 1152 | 1152 | global $global_query; |
| 1153 | 1153 | $Spotter = new Spotter($this->db); |