|
@@ 719-752 (lines=34) @@
|
| 716 |
|
* @return Array the spotter information |
| 717 |
|
* |
| 718 |
|
*/ |
| 719 |
|
public function getLatestSpotterData($limit = '', $sort = '') |
| 720 |
|
{ |
| 721 |
|
global $global_query; |
| 722 |
|
|
| 723 |
|
date_default_timezone_set('UTC'); |
| 724 |
|
|
| 725 |
|
if ($limit != "") |
| 726 |
|
{ |
| 727 |
|
$limit_array = explode(",", $limit); |
| 728 |
|
|
| 729 |
|
$limit_array[0] = filter_var($limit_array[0],FILTER_SANITIZE_NUMBER_INT); |
| 730 |
|
$limit_array[1] = filter_var($limit_array[1],FILTER_SANITIZE_NUMBER_INT); |
| 731 |
|
|
| 732 |
|
if ($limit_array[0] >= 0 && $limit_array[1] >= 0) |
| 733 |
|
{ |
| 734 |
|
//$limit_query = " LIMIT ".$limit_array[0].",".$limit_array[1]; |
| 735 |
|
$limit_query = " LIMIT ".$limit_array[1]." OFFSET ".$limit_array[0]; |
| 736 |
|
} |
| 737 |
|
} |
| 738 |
|
|
| 739 |
|
if ($sort != "") |
| 740 |
|
{ |
| 741 |
|
$search_orderby_array = $this->getOrderBy(); |
| 742 |
|
$orderby_query = $search_orderby_array[$sort]['sql']; |
| 743 |
|
} else { |
| 744 |
|
$orderby_query = " ORDER BY spotter_output.date DESC"; |
| 745 |
|
} |
| 746 |
|
|
| 747 |
|
$query = $global_query." ".$orderby_query; |
| 748 |
|
|
| 749 |
|
$spotter_array = $this->getDataFromDB($query, array(),$limit_query); |
| 750 |
|
|
| 751 |
|
return $spotter_array; |
| 752 |
|
} |
| 753 |
|
|
| 754 |
|
|
| 755 |
|
/** |
|
@@ 834-867 (lines=34) @@
|
| 831 |
|
* @return Array the spotter information |
| 832 |
|
* |
| 833 |
|
*/ |
| 834 |
|
public function getNewestSpotterDataSortedByAircraftType($limit = '', $sort = '') |
| 835 |
|
{ |
| 836 |
|
global $global_query; |
| 837 |
|
|
| 838 |
|
date_default_timezone_set('UTC'); |
| 839 |
|
|
| 840 |
|
if ($limit != "") |
| 841 |
|
{ |
| 842 |
|
$limit_array = explode(",", $limit); |
| 843 |
|
|
| 844 |
|
$limit_array[0] = filter_var($limit_array[0],FILTER_SANITIZE_NUMBER_INT); |
| 845 |
|
$limit_array[1] = filter_var($limit_array[1],FILTER_SANITIZE_NUMBER_INT); |
| 846 |
|
|
| 847 |
|
if ($limit_array[0] >= 0 && $limit_array[1] >= 0) |
| 848 |
|
{ |
| 849 |
|
//$limit_query = " LIMIT ".$limit_array[0].",".$limit_array[1]; |
| 850 |
|
$limit_query = " LIMIT ".$limit_array[1]." OFFSET ".$limit_array[0]; |
| 851 |
|
} |
| 852 |
|
} |
| 853 |
|
|
| 854 |
|
if ($sort != "") |
| 855 |
|
{ |
| 856 |
|
$search_orderby_array = $this->getOrderBy(); |
| 857 |
|
$orderby_query = $search_orderby_array[$sort]['sql']; |
| 858 |
|
} else { |
| 859 |
|
$orderby_query = " ORDER BY spotter_output.date DESC "; |
| 860 |
|
} |
| 861 |
|
|
| 862 |
|
$query = $global_query." WHERE spotter_output.aircraft_name <> '' GROUP BY spotter_output.aircraft_icao,spotter_output.ident,spotter_output.spotter_id, spotter_output.flightaware_id, spotter_output.registration,spotter_output.airline_name,spotter_output.airline_icao,spotter_output.airline_country,spotter_output.airline_type,spotter_output.aircraft_icao,spotter_output.aircraft_name,spotter_output.aircraft_manufacturer,spotter_output.departure_airport_icao,spotter_output.departure_airport_name,spotter_output.departure_airport_city,spotter_output.departure_airport_country,spotter_output.departure_airport_time,spotter_output.arrival_airport_icao,spotter_output.arrival_airport_name,spotter_output.arrival_airport_city,spotter_output.arrival_airport_country,spotter_output.arrival_airport_time,spotter_output.route_stop,spotter_output.date,spotter_output.latitude,spotter_output.longitude,spotter_output.waypoints,spotter_output.altitude,spotter_output.heading,spotter_output.ground_speed,spotter_output.highlight,spotter_output.squawk,spotter_output.ModeS,spotter_output.pilot_id,spotter_output.pilot_name,spotter_output.verticalrate,spotter_output.owner_name,spotter_output.format_source,spotter_output.source_name,spotter_output.ground,spotter_output.last_ground,spotter_output.last_seen,spotter_output.last_latitude,spotter_output.last_longitude,spotter_output.last_altitude,spotter_output.last_ground_speed,spotter_output.real_arrival_airport_icao,spotter_output.real_arrival_airport_time ".$orderby_query; |
| 863 |
|
|
| 864 |
|
$spotter_array = $this->getDataFromDB($query, array(), $limit_query); |
| 865 |
|
|
| 866 |
|
return $spotter_array; |
| 867 |
|
} |
| 868 |
|
|
| 869 |
|
|
| 870 |
|
/** |
|
@@ 876-909 (lines=34) @@
|
| 873 |
|
* @return Array the spotter information |
| 874 |
|
* |
| 875 |
|
*/ |
| 876 |
|
public function getNewestSpotterDataSortedByAircraftRegistration($limit = '', $sort = '') |
| 877 |
|
{ |
| 878 |
|
global $global_query; |
| 879 |
|
|
| 880 |
|
date_default_timezone_set('UTC'); |
| 881 |
|
|
| 882 |
|
if ($limit != "") |
| 883 |
|
{ |
| 884 |
|
$limit_array = explode(",", $limit); |
| 885 |
|
|
| 886 |
|
$limit_array[0] = filter_var($limit_array[0],FILTER_SANITIZE_NUMBER_INT); |
| 887 |
|
$limit_array[1] = filter_var($limit_array[1],FILTER_SANITIZE_NUMBER_INT); |
| 888 |
|
|
| 889 |
|
if ($limit_array[0] >= 0 && $limit_array[1] >= 0) |
| 890 |
|
{ |
| 891 |
|
//$limit_query = " LIMIT ".$limit_array[0].",".$limit_array[1]; |
| 892 |
|
$limit_query = " LIMIT ".$limit_array[1]." OFFSET ".$limit_array[0]; |
| 893 |
|
} |
| 894 |
|
} |
| 895 |
|
|
| 896 |
|
if ($sort != "") |
| 897 |
|
{ |
| 898 |
|
$search_orderby_array = $this->getOrderBy(); |
| 899 |
|
$orderby_query = $search_orderby_array[$sort]['sql']; |
| 900 |
|
} else { |
| 901 |
|
$orderby_query = " ORDER BY spotter_output.date DESC "; |
| 902 |
|
} |
| 903 |
|
|
| 904 |
|
$query = $global_query." WHERE spotter_output.registration <> '' GROUP BY spotter_output.registration,spotter_output.ident,spotter_output.spotter_id, spotter_output.flightaware_id, spotter_output.registration,spotter_output.airline_name,spotter_output.airline_icao,spotter_output.airline_country,spotter_output.airline_type,spotter_output.aircraft_icao,spotter_output.aircraft_name,spotter_output.aircraft_manufacturer,spotter_output.departure_airport_icao,spotter_output.departure_airport_name,spotter_output.departure_airport_city,spotter_output.departure_airport_country,spotter_output.departure_airport_time,spotter_output.arrival_airport_icao,spotter_output.arrival_airport_name,spotter_output.arrival_airport_city,spotter_output.arrival_airport_country,spotter_output.arrival_airport_time,spotter_output.route_stop,spotter_output.date,spotter_output.latitude,spotter_output.longitude,spotter_output.waypoints,spotter_output.altitude,spotter_output.heading,spotter_output.ground_speed,spotter_output.highlight,spotter_output.squawk,spotter_output.ModeS,spotter_output.pilot_id,spotter_output.pilot_name,spotter_output.verticalrate,spotter_output.owner_name,spotter_output.format_source,spotter_output.source_name,spotter_output.ground,spotter_output.last_ground,spotter_output.last_seen,spotter_output.last_latitude,spotter_output.last_longitude,spotter_output.last_altitude,spotter_output.last_ground_speed,spotter_output.real_arrival_airport_icao,spotter_output.real_arrival_airport_time ".$orderby_query; |
| 905 |
|
|
| 906 |
|
$spotter_array = $this->getDataFromDB($query, array(), $limit_query); |
| 907 |
|
|
| 908 |
|
return $spotter_array; |
| 909 |
|
} |
| 910 |
|
|
| 911 |
|
|
| 912 |
|
/** |
|
@@ 918-951 (lines=34) @@
|
| 915 |
|
* @return Array the spotter information |
| 916 |
|
* |
| 917 |
|
*/ |
| 918 |
|
public function getNewestSpotterDataSortedByAirline($limit = '', $sort = '') |
| 919 |
|
{ |
| 920 |
|
global $global_query; |
| 921 |
|
|
| 922 |
|
date_default_timezone_set('UTC'); |
| 923 |
|
|
| 924 |
|
if ($limit != "") |
| 925 |
|
{ |
| 926 |
|
$limit_array = explode(",", $limit); |
| 927 |
|
|
| 928 |
|
$limit_array[0] = filter_var($limit_array[0],FILTER_SANITIZE_NUMBER_INT); |
| 929 |
|
$limit_array[1] = filter_var($limit_array[1],FILTER_SANITIZE_NUMBER_INT); |
| 930 |
|
|
| 931 |
|
if ($limit_array[0] >= 0 && $limit_array[1] >= 0) |
| 932 |
|
{ |
| 933 |
|
//$limit_query = " LIMIT ".$limit_array[0].",".$limit_array[1]; |
| 934 |
|
$limit_query = " LIMIT ".$limit_array[1]." OFFSET ".$limit_array[0]; |
| 935 |
|
} |
| 936 |
|
} |
| 937 |
|
|
| 938 |
|
if ($sort != "") |
| 939 |
|
{ |
| 940 |
|
$search_orderby_array = $this->getOrderBy(); |
| 941 |
|
$orderby_query = $search_orderby_array[$sort]['sql']; |
| 942 |
|
} else { |
| 943 |
|
$orderby_query = " ORDER BY spotter_output.date DESC "; |
| 944 |
|
} |
| 945 |
|
|
| 946 |
|
$query = $global_query." WHERE spotter_output.airline_name <> '' GROUP BY spotter_output.airline_icao,spotter_output.ident,spotter_output.spotter_id, spotter_output.flightaware_id, spotter_output.registration,spotter_output.airline_name,spotter_output.airline_icao,spotter_output.airline_country,spotter_output.airline_type,spotter_output.aircraft_icao,spotter_output.aircraft_name,spotter_output.aircraft_manufacturer,spotter_output.departure_airport_icao,spotter_output.departure_airport_name,spotter_output.departure_airport_city,spotter_output.departure_airport_country,spotter_output.departure_airport_time,spotter_output.arrival_airport_icao,spotter_output.arrival_airport_name,spotter_output.arrival_airport_city,spotter_output.arrival_airport_country,spotter_output.arrival_airport_time,spotter_output.route_stop,spotter_output.date,spotter_output.latitude,spotter_output.longitude,spotter_output.waypoints,spotter_output.altitude,spotter_output.heading,spotter_output.ground_speed,spotter_output.highlight,spotter_output.squawk,spotter_output.ModeS,spotter_output.pilot_id,spotter_output.pilot_name,spotter_output.verticalrate,spotter_output.owner_name,spotter_output.format_source,spotter_output.source_name,spotter_output.ground,spotter_output.last_ground,spotter_output.last_seen,spotter_output.last_latitude,spotter_output.last_longitude,spotter_output.last_altitude,spotter_output.last_ground_speed,spotter_output.real_arrival_airport_icao,spotter_output.real_arrival_airport_time ".$orderby_query; |
| 947 |
|
|
| 948 |
|
$spotter_array = $this->getDataFromDB($query, array(), $limit_query); |
| 949 |
|
|
| 950 |
|
return $spotter_array; |
| 951 |
|
} |
| 952 |
|
|
| 953 |
|
|
| 954 |
|
/** |
|
@@ 960-993 (lines=34) @@
|
| 957 |
|
* @return Array the spotter information |
| 958 |
|
* |
| 959 |
|
*/ |
| 960 |
|
public function getNewestSpotterDataSortedByDepartureAirport($limit = '', $sort = '') |
| 961 |
|
{ |
| 962 |
|
global $global_query; |
| 963 |
|
|
| 964 |
|
date_default_timezone_set('UTC'); |
| 965 |
|
|
| 966 |
|
if ($limit != "") |
| 967 |
|
{ |
| 968 |
|
$limit_array = explode(",", $limit); |
| 969 |
|
|
| 970 |
|
$limit_array[0] = filter_var($limit_array[0],FILTER_SANITIZE_NUMBER_INT); |
| 971 |
|
$limit_array[1] = filter_var($limit_array[1],FILTER_SANITIZE_NUMBER_INT); |
| 972 |
|
|
| 973 |
|
if ($limit_array[0] >= 0 && $limit_array[1] >= 0) |
| 974 |
|
{ |
| 975 |
|
//$limit_query = " LIMIT ".$limit_array[0].",".$limit_array[1]; |
| 976 |
|
$limit_query = " LIMIT ".$limit_array[1]." OFFSET ".$limit_array[0]; |
| 977 |
|
} |
| 978 |
|
} |
| 979 |
|
|
| 980 |
|
if ($sort != "") |
| 981 |
|
{ |
| 982 |
|
$search_orderby_array = $this->getOrderBy(); |
| 983 |
|
$orderby_query = $search_orderby_array[$sort]['sql']; |
| 984 |
|
} else { |
| 985 |
|
$orderby_query = " ORDER BY spotter_output.date DESC "; |
| 986 |
|
} |
| 987 |
|
|
| 988 |
|
$query = $global_query." WHERE spotter_output.departure_airport_name <> '' AND spotter_output.departure_airport_icao <> 'NA' GROUP BY spotter_output.departure_airport_icao,spotter_output.ident,spotter_output.spotter_id, spotter_output.flightaware_id, spotter_output.registration,spotter_output.airline_name,spotter_output.airline_icao,spotter_output.airline_country,spotter_output.airline_type,spotter_output.aircraft_icao,spotter_output.aircraft_name,spotter_output.aircraft_manufacturer,spotter_output.departure_airport_icao,spotter_output.departure_airport_name,spotter_output.departure_airport_city,spotter_output.departure_airport_country,spotter_output.departure_airport_time,spotter_output.arrival_airport_icao,spotter_output.arrival_airport_name,spotter_output.arrival_airport_city,spotter_output.arrival_airport_country,spotter_output.arrival_airport_time,spotter_output.route_stop,spotter_output.date,spotter_output.latitude,spotter_output.longitude,spotter_output.waypoints,spotter_output.altitude,spotter_output.heading,spotter_output.ground_speed,spotter_output.highlight,spotter_output.squawk,spotter_output.ModeS,spotter_output.pilot_id,spotter_output.pilot_name,spotter_output.verticalrate,spotter_output.owner_name,spotter_output.format_source,spotter_output.source_name,spotter_output.ground,spotter_output.last_ground,spotter_output.last_seen,spotter_output.last_latitude,spotter_output.last_longitude,spotter_output.last_altitude,spotter_output.last_ground_speed,spotter_output.real_arrival_airport_icao,spotter_output.real_arrival_airport_time ".$orderby_query; |
| 989 |
|
|
| 990 |
|
$spotter_array = $this->getDataFromDB($query, array(), $limit_query); |
| 991 |
|
|
| 992 |
|
return $spotter_array; |
| 993 |
|
} |
| 994 |
|
|
| 995 |
|
|
| 996 |
|
/** |
|
@@ 1002-1035 (lines=34) @@
|
| 999 |
|
* @return Array the spotter information |
| 1000 |
|
* |
| 1001 |
|
*/ |
| 1002 |
|
public function getNewestSpotterDataSortedByArrivalAirport($limit = '', $sort = '') |
| 1003 |
|
{ |
| 1004 |
|
global $global_query; |
| 1005 |
|
|
| 1006 |
|
date_default_timezone_set('UTC'); |
| 1007 |
|
|
| 1008 |
|
if ($limit != "") |
| 1009 |
|
{ |
| 1010 |
|
$limit_array = explode(",", $limit); |
| 1011 |
|
|
| 1012 |
|
$limit_array[0] = filter_var($limit_array[0],FILTER_SANITIZE_NUMBER_INT); |
| 1013 |
|
$limit_array[1] = filter_var($limit_array[1],FILTER_SANITIZE_NUMBER_INT); |
| 1014 |
|
|
| 1015 |
|
if ($limit_array[0] >= 0 && $limit_array[1] >= 0) |
| 1016 |
|
{ |
| 1017 |
|
//$limit_query = " LIMIT ".$limit_array[0].",".$limit_array[1]; |
| 1018 |
|
$limit_query = " LIMIT ".$limit_array[1]." OFFSET ".$limit_array[0]; |
| 1019 |
|
} |
| 1020 |
|
} |
| 1021 |
|
|
| 1022 |
|
if ($sort != "") |
| 1023 |
|
{ |
| 1024 |
|
$search_orderby_array = $this->getOrderBy(); |
| 1025 |
|
$orderby_query = $search_orderby_array[$sort]['sql']; |
| 1026 |
|
} else { |
| 1027 |
|
$orderby_query = " ORDER BY spotter_output.date DESC "; |
| 1028 |
|
} |
| 1029 |
|
|
| 1030 |
|
$query = $global_query." WHERE spotter_output.arrival_airport_name <> '' AND spotter_output.arrival_airport_icao <> 'NA' GROUP BY spotter_output.arrival_airport_icao,spotter_output.ident,spotter_output.spotter_id, spotter_output.flightaware_id, spotter_output.registration,spotter_output.airline_name,spotter_output.airline_icao,spotter_output.airline_country,spotter_output.airline_type,spotter_output.aircraft_icao,spotter_output.aircraft_name,spotter_output.aircraft_manufacturer,spotter_output.departure_airport_icao,spotter_output.departure_airport_name,spotter_output.departure_airport_city,spotter_output.departure_airport_country,spotter_output.departure_airport_time,spotter_output.arrival_airport_icao,spotter_output.arrival_airport_name,spotter_output.arrival_airport_city,spotter_output.arrival_airport_country,spotter_output.arrival_airport_time,spotter_output.route_stop,spotter_output.date,spotter_output.latitude,spotter_output.longitude,spotter_output.waypoints,spotter_output.altitude,spotter_output.heading,spotter_output.ground_speed,spotter_output.highlight,spotter_output.squawk,spotter_output.ModeS,spotter_output.pilot_id,spotter_output.pilot_name,spotter_output.verticalrate,spotter_output.owner_name,spotter_output.format_source,spotter_output.source_name,spotter_output.ground,spotter_output.last_ground,spotter_output.last_seen,spotter_output.last_latitude,spotter_output.last_longitude,spotter_output.last_altitude,spotter_output.last_ground_speed,spotter_output.real_arrival_airport_icao,spotter_output.real_arrival_airport_time ".$orderby_query; |
| 1031 |
|
|
| 1032 |
|
$spotter_array = $this->getDataFromDB($query, array(), $limit_query); |
| 1033 |
|
|
| 1034 |
|
return $spotter_array; |
| 1035 |
|
} |
| 1036 |
|
|
| 1037 |
|
|
| 1038 |
|
/** |
|
@@ 1601-1634 (lines=34) @@
|
| 1598 |
|
* @return Array the spotter information |
| 1599 |
|
* |
| 1600 |
|
*/ |
| 1601 |
|
public function getSpotterDataByHighlight($limit = '', $sort = '') |
| 1602 |
|
{ |
| 1603 |
|
global $global_query; |
| 1604 |
|
|
| 1605 |
|
date_default_timezone_set('UTC'); |
| 1606 |
|
|
| 1607 |
|
if ($limit != "") |
| 1608 |
|
{ |
| 1609 |
|
$limit_array = explode(",", $limit); |
| 1610 |
|
|
| 1611 |
|
$limit_array[0] = filter_var($limit_array[0],FILTER_SANITIZE_NUMBER_INT); |
| 1612 |
|
$limit_array[1] = filter_var($limit_array[1],FILTER_SANITIZE_NUMBER_INT); |
| 1613 |
|
|
| 1614 |
|
if ($limit_array[0] >= 0 && $limit_array[1] >= 0) |
| 1615 |
|
{ |
| 1616 |
|
//$limit_query = " LIMIT ".$limit_array[0].",".$limit_array[1]; |
| 1617 |
|
$limit_query = " LIMIT ".$limit_array[1]." OFFSET ".$limit_array[0]; |
| 1618 |
|
} |
| 1619 |
|
} |
| 1620 |
|
|
| 1621 |
|
if ($sort != "") |
| 1622 |
|
{ |
| 1623 |
|
$search_orderby_array = $this->getOrderBy(); |
| 1624 |
|
$orderby_query = $search_orderby_array[$sort]['sql']; |
| 1625 |
|
} else { |
| 1626 |
|
$orderby_query = " ORDER BY spotter_output.date DESC"; |
| 1627 |
|
} |
| 1628 |
|
|
| 1629 |
|
$query = $global_query." WHERE spotter_output.highlight <> '' ".$orderby_query; |
| 1630 |
|
|
| 1631 |
|
$spotter_array = $this->getDataFromDB($query, array(), $limit_query); |
| 1632 |
|
|
| 1633 |
|
return $spotter_array; |
| 1634 |
|
} |
| 1635 |
|
|
| 1636 |
|
|
| 1637 |
|
|
Ysurac /
FlightAirMap
