View GitHub Repository FlightAirMap

Schedule Inspection
Subscribe

Code Duplication    Length = 15-15 lines in 4 locations

require/class.Stats.php 4 locations

@@ 821-835 (lines=15) @@
818 
                        return "error : ".$e->getMessage();
819 
                }
820 
        }
821 
	public function addStatDepartureAirports($airport_icao,$airport_name,$airport_city,$airport_country,$departure) {
822 
		global $globalDBdriver;
823 
		if ($globalDBdriver == 'mysql') {
824 
			$query = "INSERT INTO stats_airport (airport_icao,airport_name,airport_city,airport_country,departure,stats_type,date) VALUES (:airport_icao,:airport_name,:airport_city,:airport_country,:departure,'yearly',:date) ON DUPLICATE KEY UPDATE departure = departure+:departure";
825 
		} else {
826 
			$query = "UPDATE stats_airport SET departure = departure+:departure WHERE airport_icao = :airport_icao AND stats_type = 'yearly'; INSERT INTO stats_airport (airport_icao,airport_name,airport_city,airport_country,departure,stats_type,date) SELECT :airport_icao,:airport_name,:airport_city,:airport_country,:departure,'yearly',:date WHERE NOT EXISTS (SELECT 1 FROM stats_airline WHERE airport_icao = :airport_icao AND stats_type = 'yearly');";
827 
		}
828 
                $query_values = array(':airport_icao' => $airport_icao,':airport_name' => $airport_name,':airport_city' => $airport_city,':airport_country' => $airport_country,':departure' => $departure,':date' => date('Y').'-01-01 00:00:00');
829 
                 try {
830 
                        $sth = $this->db->prepare($query);
831 
                        $sth->execute($query_values);
832 
                } catch(PDOException $e) {
833 
                        return "error : ".$e->getMessage();
834 
                }
835 
        }
836 
	public function addStatDepartureAirportsDaily($date,$airport_icao,$airport_name,$airport_city,$airport_country,$departure) {
837 
		global $globalDBdriver;
838 
		if ($globalDBdriver == 'mysql') {
@@ 836-850 (lines=15) @@
833 
                        return "error : ".$e->getMessage();
834 
                }
835 
        }
836 
	public function addStatDepartureAirportsDaily($date,$airport_icao,$airport_name,$airport_city,$airport_country,$departure) {
837 
		global $globalDBdriver;
838 
		if ($globalDBdriver == 'mysql') {
839 
			$query = "INSERT INTO stats_airport (airport_icao,airport_name,airport_city,airport_country,departure,stats_type,date) VALUES (:airport_icao,:airport_name,:airport_city,:airport_country,:departure,'daily',:date) ON DUPLICATE KEY UPDATE departure = :departure";
840 
		} else {
841 
			$query = "UPDATE stats_airport SET departure = departure+:departure WHERE airport_icao = :airport_icao AND stats_type = 'daily'; INSERT INTO stats_airport (airport_icao,airport_name,airport_city,airport_country,departure,stats_type,date) SELECT :airport_icao,:airport_name,:airport_city,:airport_country,:departure,'daily',:date WHERE NOT EXISTS (SELECT 1 FROM stats_airline WHERE airport_icao = :airport_icao AND stats_type = 'daily');";
842 
		}
843 
                $query_values = array(':airport_icao' => $airport_icao,':airport_name' => $airport_name,':airport_city' => $airport_city,':airport_country' => $airport_country,':departure' => $departure,':date' => $date);
844 
                 try {
845 
                        $sth = $this->db->prepare($query);
846 
                        $sth->execute($query_values);
847 
                } catch(PDOException $e) {
848 
                        return "error : ".$e->getMessage();
849 
                }
850 
        }
851 
	public function addStatArrivalAirports($airport_icao,$airport_name,$airport_city,$airport_country,$arrival) {
852 
		global $globalDBdriver;
853 
		if ($globalDBdriver == 'mysql') {
@@ 851-865 (lines=15) @@
848 
                        return "error : ".$e->getMessage();
849 
                }
850 
        }
851 
	public function addStatArrivalAirports($airport_icao,$airport_name,$airport_city,$airport_country,$arrival) {
852 
		global $globalDBdriver;
853 
		if ($globalDBdriver == 'mysql') {
854 
			$query = "INSERT INTO stats_airport (airport_icao,airport_name,airport_city,airport_country,arrival,stats_type,date) VALUES (:airport_icao,:airport_name,:airport_city,:airport_country,:arrival,'yearly',:date) ON DUPLICATE KEY UPDATE arrival = arrival+:arrival";
855 
		} else {
856 
			$query = "UPDATE stats_airport SET arrival = arrival+:arrival WHERE airport_icao = :airport_icao AND stats_type = 'yearly'; INSERT INTO stats_airport (airport_icao,airport_name,airport_city,airport_country,arrival,stats_type,date) SELECT :airport_icao,:airport_name,:airport_city,:airport_country,:arrival,'yearly',:date WHERE NOT EXISTS (SELECT 1 FROM stats_airline WHERE airport_icao = :airport_icao AND stats_type = 'yearly');";
857 
		}
858 
                $query_values = array(':airport_icao' => $airport_icao,':airport_name' => $airport_name,':airport_city' => $airport_city,':airport_country' => $airport_country,':arrival' => $arrival,':date' => date('Y').'-01-01 00:00:00');
859 
                 try {
860 
                        $sth = $this->db->prepare($query);
861 
                        $sth->execute($query_values);
862 
                } catch(PDOException $e) {
863 
                        return "error : ".$e->getMessage();
864 
                }
865 
        }
866 
	public function addStatArrivalAirportsDaily($date,$airport_icao,$airport_name,$airport_city,$airport_country,$arrival) {
867 
		global $globalDBdriver;
868 
		if ($globalDBdriver == 'mysql') {
@@ 866-880 (lines=15) @@
863 
                        return "error : ".$e->getMessage();
864 
                }
865 
        }
866 
	public function addStatArrivalAirportsDaily($date,$airport_icao,$airport_name,$airport_city,$airport_country,$arrival) {
867 
		global $globalDBdriver;
868 
		if ($globalDBdriver == 'mysql') {
869 
			$query = "INSERT INTO stats_airport (airport_icao,airport_name,airport_city,airport_country,arrival,stats_type,date) VALUES (:airport_icao,:airport_name,:airport_city,:airport_country,:arrival,'daily',:date) ON DUPLICATE KEY UPDATE arrival = :arrival";
870 
		} else {
871 
			$query = "UPDATE stats_airport SET arrival = arrival+:arrival WHERE airport_icao = :airport_icao AND stats_type = 'daily'; INSERT INTO stats_airport (airport_icao,airport_name,airport_city,airport_country,arrival,stats_type,date) SELECT :airport_icao,:airport_name,:airport_city,:airport_country,:arrival,'yearly',:date WHERE NOT EXISTS (SELECT 1 FROM stats_airline WHERE airport_icao = :airport_icao AND stats_type = 'daily');";
872 
		}
873 
                $query_values = array(':airport_icao' => $airport_icao,':airport_name' => $airport_name,':airport_city' => $airport_city,':airport_country' => $airport_country,':arrival' => $arrival, ':date' => $date);
874 
                 try {
875 
                        $sth = $this->db->prepare($query);
876 
                        $sth->execute($query_values);
877 
                } catch(PDOException $e) {
878 
                        return "error : ".$e->getMessage();
879 
                }
880 
        }
881 

                                

                                                            

                                    882
                                    
                                    
	public function deleteStat($id) {

                                

                                                            

                                    883
                                    
                                    
                $query = "DELETE FROM stats WHERE stats_id = :id";