Code Duplication - Ysurac/FlightAirMap - Measure and Improve Code Quality continuously with Scrutinizer

Code Duplication Length = 34-34 lines in 7 locations

require/class.Spotter.php 7 locations


	* @return Array the route list
	*
	*/
	public function countAllRoutesByAircraft($aircraft_icao)
	{
		$aircraft_icao = filter_var($aircraft_icao,FILTER_SANITIZE_STRING);
		
		$query  = "SELECT DISTINCT concat(spotter_output.departure_airport_icao, ' - ',  spotter_output.arrival_airport_icao) AS route, count(concat(spotter_output.departure_airport_icao, ' - ', spotter_output.arrival_airport_icao)) AS route_count, spotter_output.departure_airport_icao, spotter_output.departure_airport_name AS airport_departure_name, spotter_output.departure_airport_city AS airport_departure_city, spotter_output.departure_airport_country AS airport_departure_country, spotter_output.arrival_airport_icao, spotter_output.arrival_airport_name AS airport_arrival_name, spotter_output.arrival_airport_city AS airport_arrival_city, spotter_output.arrival_airport_country AS airport_arrival_country
								FROM spotter_output
                    WHERE spotter_output.ident <> '' AND spotter_output.aircraft_icao = :aircraft_icao 
                    GROUP BY route
                    ORDER BY route_count DESC";
      
		
		$sth = $this->db->prepare($query);
		$sth->execute(array(':aircraft_icao' => $aircraft_icao));
      
		$routes_array = array();
		$temp_array = array();
        
		while($row = $sth->fetch(PDO::FETCH_ASSOC))
		{
			$temp_array['route_count'] = $row['route_count'];
			$temp_array['airport_departure_icao'] = $row['departure_airport_icao'];
			$temp_array['airport_departure_name'] = $row['airport_departure_name'];
			$temp_array['airport_departure_city'] = $row['airport_departure_city'];
			$temp_array['airport_departure_country'] = $row['airport_departure_country'];
			$temp_array['airport_arrival_icao'] = $row['arrival_airport_icao'];
			$temp_array['airport_arrival_name'] = $row['airport_arrival_name'];
			$temp_array['airport_arrival_city'] = $row['airport_arrival_city'];
			$temp_array['airport_arrival_country'] = $row['airport_arrival_country'];
          
			$routes_array[] = $temp_array;
		}

		return $routes_array;
	}
	
	
	/**

	* @return Array the route list
	*
	*/
	public function countAllRoutesByRegistration($registration)
	{
		$registration = filter_var($registration, FILTER_SANITIZE_STRING);
		
		$query  = "SELECT DISTINCT concat(spotter_output.departure_airport_icao, ' - ',  spotter_output.arrival_airport_icao) AS route, count(concat(spotter_output.departure_airport_icao, ' - ', spotter_output.arrival_airport_icao)) AS route_count, spotter_output.departure_airport_icao, spotter_output.departure_airport_name AS airport_departure_name, spotter_output.departure_airport_city AS airport_departure_city, spotter_output.departure_airport_country AS airport_departure_country, spotter_output.arrival_airport_icao, spotter_output.arrival_airport_name AS airport_arrival_name, spotter_output.arrival_airport_city AS airport_arrival_city, spotter_output.arrival_airport_country AS airport_arrival_country
								FROM spotter_output
                    WHERE spotter_output.ident <> '' AND spotter_output.registration = :registration 
                    GROUP BY route
                    ORDER BY route_count DESC";
      
		
		$sth = $this->db->prepare($query);
		$sth->execute(array(':registration' => $registration));
      
		$routes_array = array();
		$temp_array = array();
        
		while($row = $sth->fetch(PDO::FETCH_ASSOC))
		{
			$temp_array['route_count'] = $row['route_count'];
			$temp_array['airport_departure_icao'] = $row['departure_airport_icao'];
			$temp_array['airport_departure_name'] = $row['airport_departure_name'];
			$temp_array['airport_departure_city'] = $row['airport_departure_city'];
			$temp_array['airport_departure_country'] = $row['airport_departure_country'];
			$temp_array['airport_arrival_icao'] = $row['arrival_airport_icao'];
			$temp_array['airport_arrival_name'] = $row['airport_arrival_name'];
			$temp_array['airport_arrival_city'] = $row['airport_arrival_city'];
			$temp_array['airport_arrival_country'] = $row['airport_arrival_country'];
          
			$routes_array[] = $temp_array;
		}

		return $routes_array;
	}
	
	
	

	* @return Array the route list
	*
	*/
	public function countAllRoutesByAirline($airline_icao)
	{
		$airline_icao = filter_var($airline_icao,FILTER_SANITIZE_STRING);
		
		$query  = "SELECT DISTINCT concat(spotter_output.departure_airport_icao, ' - ',  spotter_output.arrival_airport_icao) AS route, count(concat(spotter_output.departure_airport_icao, ' - ', spotter_output.arrival_airport_icao)) AS route_count, spotter_output.departure_airport_icao, spotter_output.departure_airport_name AS airport_departure_name, spotter_output.departure_airport_city AS airport_departure_city, spotter_output.departure_airport_country AS airport_departure_country, spotter_output.arrival_airport_icao, spotter_output.arrival_airport_name AS airport_arrival_name, spotter_output.arrival_airport_city AS airport_arrival_city, spotter_output.arrival_airport_country AS airport_arrival_country
								FROM spotter_output
                    WHERE spotter_output.ident <> '' AND spotter_output.airline_icao = :airline_icao 
                    GROUP BY route
                    ORDER BY route_count DESC";
      
		
		$sth = $this->db->prepare($query);
		$sth->execute(array(':airline_icao' => $airline_icao));
      
		$routes_array = array();
		$temp_array = array();
        
		while($row = $sth->fetch(PDO::FETCH_ASSOC))
		{
			$temp_array['route_count'] = $row['route_count'];
			$temp_array['airport_departure_icao'] = $row['departure_airport_icao'];
			$temp_array['airport_departure_name'] = $row['airport_departure_name'];
			$temp_array['airport_departure_city'] = $row['airport_departure_city'];
			$temp_array['airport_departure_country'] = $row['airport_departure_country'];
			$temp_array['airport_arrival_icao'] = $row['arrival_airport_icao'];
			$temp_array['airport_arrival_name'] = $row['airport_arrival_name'];
			$temp_array['airport_arrival_city'] = $row['airport_arrival_city'];
			$temp_array['airport_arrival_country'] = $row['airport_arrival_country'];
          
			$routes_array[] = $temp_array;
		}

		return $routes_array;
	}
	
	
	

	* @return Array the route list
	*
	*/
	public function countAllRoutesByAirport($airport_icao)
	{
		$airport_icao = filter_var($airport_icao,FILTER_SANITIZE_STRING);
		
		$query  = "SELECT DISTINCT concat(spotter_output.departure_airport_icao, ' - ',  spotter_output.arrival_airport_icao) AS route, count(concat(spotter_output.departure_airport_icao, ' - ', spotter_output.arrival_airport_icao)) AS route_count, spotter_output.departure_airport_icao, spotter_output.departure_airport_name AS airport_departure_name, spotter_output.departure_airport_city AS airport_departure_city, spotter_output.departure_airport_country AS airport_departure_country, spotter_output.arrival_airport_icao, spotter_output.arrival_airport_name AS airport_arrival_name, spotter_output.arrival_airport_city AS airport_arrival_city, spotter_output.arrival_airport_country AS airport_arrival_country
								FROM spotter_output
                    WHERE spotter_output.ident <> '' AND (spotter_output.departure_airport_icao = :airport_icao OR spotter_output.arrival_airport_icao = :airport_icao)
                    GROUP BY route
                    ORDER BY route_count DESC";
      
		
		$sth = $this->db->prepare($query);
		$sth->execute(array(':airport_icao' => $airport_icao));
      
		$routes_array = array();
		$temp_array = array();
        
		while($row = $sth->fetch(PDO::FETCH_ASSOC))
		{
			$temp_array['route_count'] = $row['route_count'];
			$temp_array['airport_departure_icao'] = $row['departure_airport_icao'];
			$temp_array['airport_departure_name'] = $row['airport_departure_name'];
			$temp_array['airport_departure_city'] = $row['airport_departure_city'];
			$temp_array['airport_departure_country'] = $row['airport_departure_country'];
			$temp_array['airport_arrival_icao'] = $row['arrival_airport_icao'];
			$temp_array['airport_arrival_name'] = $row['airport_arrival_name'];
			$temp_array['airport_arrival_city'] = $row['airport_arrival_city'];
			$temp_array['airport_arrival_country'] = $row['airport_arrival_country'];
          
			$routes_array[] = $temp_array;
		}

		return $routes_array;
	}
	
	
	

	* @return Array the route list
	*
	*/
	public function countAllRoutesByCountry($country)
	{
		$country = filter_var($country,FILTER_SANITIZE_STRING);
		
		$query  = "SELECT DISTINCT concat(spotter_output.departure_airport_icao, ' - ',  spotter_output.arrival_airport_icao) AS route, count(concat(spotter_output.departure_airport_icao, ' - ', spotter_output.arrival_airport_icao)) AS route_count, spotter_output.departure_airport_icao, spotter_output.departure_airport_name AS airport_departure_name, spotter_output.departure_airport_city AS airport_departure_city, spotter_output.departure_airport_country AS airport_departure_country, spotter_output.arrival_airport_icao, spotter_output.arrival_airport_name AS airport_arrival_name, spotter_output.arrival_airport_city AS airport_arrival_city, spotter_output.arrival_airport_country AS airport_arrival_country
								FROM spotter_output
                    WHERE spotter_output.ident <> '' AND ((spotter_output.departure_airport_country = :country) OR (spotter_output.arrival_airport_country = :country)) OR spotter_output.airline_country = :country 
                    GROUP BY route
                    ORDER BY route_count DESC";
      
		
		$sth = $this->db->prepare($query);
		$sth->execute(array(':country' => $country));
      
		$routes_array = array();
		$temp_array = array();
        
		while($row = $sth->fetch(PDO::FETCH_ASSOC))
		{
			$temp_array['route_count'] = $row['route_count'];
			$temp_array['airport_departure_icao'] = $row['departure_airport_icao'];
			$temp_array['airport_departure_name'] = $row['airport_departure_name'];
			$temp_array['airport_departure_city'] = $row['airport_departure_city'];
			$temp_array['airport_departure_country'] = $row['airport_departure_country'];
			$temp_array['airport_arrival_icao'] = $row['arrival_airport_icao'];
			$temp_array['airport_arrival_name'] = $row['airport_arrival_name'];
			$temp_array['airport_arrival_city'] = $row['airport_arrival_city'];
			$temp_array['airport_arrival_country'] = $row['airport_arrival_country'];
          
			$routes_array[] = $temp_array;
		}

		return $routes_array;
	}


	/**

	* @return Array the route list
	*
	*/
	public function countAllRoutesByIdent($ident)
	{
		$ident = filter_var($ident,FILTER_SANITIZE_STRING);
		
		$query  = "SELECT DISTINCT concat(spotter_output.departure_airport_icao, ' - ',  spotter_output.arrival_airport_icao) AS route, count(concat(spotter_output.departure_airport_icao, ' - ', spotter_output.arrival_airport_icao)) AS route_count, spotter_output.departure_airport_icao, spotter_output.departure_airport_name AS airport_departure_name, spotter_output.departure_airport_city AS airport_departure_city, spotter_output.departure_airport_country AS airport_departure_country, spotter_output.arrival_airport_icao, spotter_output.arrival_airport_name AS airport_arrival_name, spotter_output.arrival_airport_city AS airport_arrival_city, spotter_output.arrival_airport_country AS airport_arrival_country
		    FROM spotter_output
                    WHERE spotter_output.ident <> '' AND spotter_output.ident = :ident   
                    GROUP BY route, spotter_output.departure_airport_icao, spotter_output.departure_airport_name, spotter_output.departure_airport_city, spotter_output.departure_airport_country, spotter_output.arrival_airport_icao, spotter_output.arrival_airport_name, spotter_output.arrival_airport_city, spotter_output.arrival_airport_country
                    ORDER BY route_count DESC";
      
		
		$sth = $this->db->prepare($query);
		$sth->execute(array(':ident' => $ident));
      
		$routes_array = array();
		$temp_array = array();
        
		while($row = $sth->fetch(PDO::FETCH_ASSOC))
		{
			$temp_array['route_count'] = $row['route_count'];
			$temp_array['airport_departure_icao'] = $row['departure_airport_icao'];
			$temp_array['airport_departure_name'] = $row['airport_departure_name'];
			$temp_array['airport_departure_city'] = $row['airport_departure_city'];
			$temp_array['airport_departure_country'] = $row['airport_departure_country'];
			$temp_array['airport_arrival_icao'] = $row['arrival_airport_icao'];
			$temp_array['airport_arrival_name'] = $row['airport_arrival_name'];
			$temp_array['airport_arrival_city'] = $row['airport_arrival_city'];
			$temp_array['airport_arrival_country'] = $row['airport_arrival_country'];
          
			$routes_array[] = $temp_array;
		}

		return $routes_array;
	}
	
	
	/**

	* @return Array the route list
	*
	*/
	public function countAllRoutesByManufacturer($aircraft_manufacturer)
	{
		$aircraft_manufacturer = filter_var($aircraft_manufactuer,FILTER_SANITIZE_STRING);
		
		$query  = "SELECT DISTINCT concat(spotter_output.departure_airport_icao, ' - ',  spotter_output.arrival_airport_icao) AS route, count(concat(spotter_output.departure_airport_icao, ' - ', spotter_output.arrival_airport_icao)) AS route_count, spotter_output.departure_airport_icao, spotter_output.departure_airport_name AS airport_departure_name, spotter_output.departure_airport_city AS airport_departure_city, spotter_output.departure_airport_country AS airport_departure_country, spotter_output.arrival_airport_icao, spotter_output.arrival_airport_name AS airport_arrival_name, spotter_output.arrival_airport_city AS airport_arrival_city, spotter_output.arrival_airport_country AS airport_arrival_country
								FROM spotter_output
                    WHERE spotter_output.ident <> '' AND spotter_output.aircraft_manufacturer = :aircraft_manufacturer   
                    GROUP BY route
                    ORDER BY route_count DESC";
      
		
		$sth = $this->db->prepare($query);
		$sth->execute(array(':aircraft_manufacturer' => $aircraft_manufacturer));
      
		$routes_array = array();
		$temp_array = array();
        
		while($row = $sth->fetch(PDO::FETCH_ASSOC))
		{
			$temp_array['route_count'] = $row['route_count'];
			$temp_array['airport_departure_icao'] = $row['departure_airport_icao'];
			$temp_array['airport_departure_name'] = $row['airport_departure_name'];
			$temp_array['airport_departure_city'] = $row['airport_departure_city'];
			$temp_array['airport_departure_country'] = $row['airport_departure_country'];
			$temp_array['airport_arrival_icao'] = $row['arrival_airport_icao'];
			$temp_array['airport_arrival_name'] = $row['airport_arrival_name'];
			$temp_array['airport_arrival_city'] = $row['airport_arrival_city'];
			$temp_array['airport_arrival_country'] = $row['airport_arrival_country'];
          
			$routes_array[] = $temp_array;
		}

		return $routes_array;
	}

	
	

		@@ 6565-6598 (lines=34) @@
6562		* @return Array the route list
6563		*
6564		*/
6565		public function countAllRoutesByAircraft($aircraft_icao)
6566		{
6567		$aircraft_icao = filter_var($aircraft_icao,FILTER_SANITIZE_STRING);
6568
6569		$query = "SELECT DISTINCT concat(spotter_output.departure_airport_icao, ' - ', spotter_output.arrival_airport_icao) AS route, count(concat(spotter_output.departure_airport_icao, ' - ', spotter_output.arrival_airport_icao)) AS route_count, spotter_output.departure_airport_icao, spotter_output.departure_airport_name AS airport_departure_name, spotter_output.departure_airport_city AS airport_departure_city, spotter_output.departure_airport_country AS airport_departure_country, spotter_output.arrival_airport_icao, spotter_output.arrival_airport_name AS airport_arrival_name, spotter_output.arrival_airport_city AS airport_arrival_city, spotter_output.arrival_airport_country AS airport_arrival_country
6570		FROM spotter_output
6571		WHERE spotter_output.ident <> '' AND spotter_output.aircraft_icao = :aircraft_icao
6572		GROUP BY route
6573		ORDER BY route_count DESC";
6574
6575
6576		$sth = $this->db->prepare($query);
6577		$sth->execute(array(':aircraft_icao' => $aircraft_icao));
6578
6579		$routes_array = array();
6580		$temp_array = array();
6581
6582		while($row = $sth->fetch(PDO::FETCH_ASSOC))
6583		{
6584		$temp_array['route_count'] = $row['route_count'];
6585		$temp_array['airport_departure_icao'] = $row['departure_airport_icao'];
6586		$temp_array['airport_departure_name'] = $row['airport_departure_name'];
6587		$temp_array['airport_departure_city'] = $row['airport_departure_city'];
6588		$temp_array['airport_departure_country'] = $row['airport_departure_country'];
6589		$temp_array['airport_arrival_icao'] = $row['arrival_airport_icao'];
6590		$temp_array['airport_arrival_name'] = $row['airport_arrival_name'];
6591		$temp_array['airport_arrival_city'] = $row['airport_arrival_city'];
6592		$temp_array['airport_arrival_country'] = $row['airport_arrival_country'];
6593
6594		$routes_array[] = $temp_array;
6595		}
6596
6597		return $routes_array;
6598		}
6599
6600
6601		/**
		@@ 6607-6640 (lines=34) @@
6604		* @return Array the route list
6605		*
6606		*/
6607		public function countAllRoutesByRegistration($registration)
6608		{
6609		$registration = filter_var($registration, FILTER_SANITIZE_STRING);
6610
6611		$query = "SELECT DISTINCT concat(spotter_output.departure_airport_icao, ' - ', spotter_output.arrival_airport_icao) AS route, count(concat(spotter_output.departure_airport_icao, ' - ', spotter_output.arrival_airport_icao)) AS route_count, spotter_output.departure_airport_icao, spotter_output.departure_airport_name AS airport_departure_name, spotter_output.departure_airport_city AS airport_departure_city, spotter_output.departure_airport_country AS airport_departure_country, spotter_output.arrival_airport_icao, spotter_output.arrival_airport_name AS airport_arrival_name, spotter_output.arrival_airport_city AS airport_arrival_city, spotter_output.arrival_airport_country AS airport_arrival_country
6612		FROM spotter_output
6613		WHERE spotter_output.ident <> '' AND spotter_output.registration = :registration
6614		GROUP BY route
6615		ORDER BY route_count DESC";
6616
6617
6618		$sth = $this->db->prepare($query);
6619		$sth->execute(array(':registration' => $registration));
6620
6621		$routes_array = array();
6622		$temp_array = array();
6623
6624		while($row = $sth->fetch(PDO::FETCH_ASSOC))
6625		{
6626		$temp_array['route_count'] = $row['route_count'];
6627		$temp_array['airport_departure_icao'] = $row['departure_airport_icao'];
6628		$temp_array['airport_departure_name'] = $row['airport_departure_name'];
6629		$temp_array['airport_departure_city'] = $row['airport_departure_city'];
6630		$temp_array['airport_departure_country'] = $row['airport_departure_country'];
6631		$temp_array['airport_arrival_icao'] = $row['arrival_airport_icao'];
6632		$temp_array['airport_arrival_name'] = $row['airport_arrival_name'];
6633		$temp_array['airport_arrival_city'] = $row['airport_arrival_city'];
6634		$temp_array['airport_arrival_country'] = $row['airport_arrival_country'];
6635
6636		$routes_array[] = $temp_array;
6637		}
6638
6639		return $routes_array;
6640		}
6641
6642
6643
		@@ 6650-6683 (lines=34) @@
6647		* @return Array the route list
6648		*
6649		*/
6650		public function countAllRoutesByAirline($airline_icao)
6651		{
6652		$airline_icao = filter_var($airline_icao,FILTER_SANITIZE_STRING);
6653
6654		$query = "SELECT DISTINCT concat(spotter_output.departure_airport_icao, ' - ', spotter_output.arrival_airport_icao) AS route, count(concat(spotter_output.departure_airport_icao, ' - ', spotter_output.arrival_airport_icao)) AS route_count, spotter_output.departure_airport_icao, spotter_output.departure_airport_name AS airport_departure_name, spotter_output.departure_airport_city AS airport_departure_city, spotter_output.departure_airport_country AS airport_departure_country, spotter_output.arrival_airport_icao, spotter_output.arrival_airport_name AS airport_arrival_name, spotter_output.arrival_airport_city AS airport_arrival_city, spotter_output.arrival_airport_country AS airport_arrival_country
6655		FROM spotter_output
6656		WHERE spotter_output.ident <> '' AND spotter_output.airline_icao = :airline_icao
6657		GROUP BY route
6658		ORDER BY route_count DESC";
6659
6660
6661		$sth = $this->db->prepare($query);
6662		$sth->execute(array(':airline_icao' => $airline_icao));
6663
6664		$routes_array = array();
6665		$temp_array = array();
6666
6667		while($row = $sth->fetch(PDO::FETCH_ASSOC))
6668		{
6669		$temp_array['route_count'] = $row['route_count'];
6670		$temp_array['airport_departure_icao'] = $row['departure_airport_icao'];
6671		$temp_array['airport_departure_name'] = $row['airport_departure_name'];
6672		$temp_array['airport_departure_city'] = $row['airport_departure_city'];
6673		$temp_array['airport_departure_country'] = $row['airport_departure_country'];
6674		$temp_array['airport_arrival_icao'] = $row['arrival_airport_icao'];
6675		$temp_array['airport_arrival_name'] = $row['airport_arrival_name'];
6676		$temp_array['airport_arrival_city'] = $row['airport_arrival_city'];
6677		$temp_array['airport_arrival_country'] = $row['airport_arrival_country'];
6678
6679		$routes_array[] = $temp_array;
6680		}
6681
6682		return $routes_array;
6683		}
6684
6685
6686
		@@ 6693-6726 (lines=34) @@
6690		* @return Array the route list
6691		*
6692		*/
6693		public function countAllRoutesByAirport($airport_icao)
6694		{
6695		$airport_icao = filter_var($airport_icao,FILTER_SANITIZE_STRING);
6696
6697		$query = "SELECT DISTINCT concat(spotter_output.departure_airport_icao, ' - ', spotter_output.arrival_airport_icao) AS route, count(concat(spotter_output.departure_airport_icao, ' - ', spotter_output.arrival_airport_icao)) AS route_count, spotter_output.departure_airport_icao, spotter_output.departure_airport_name AS airport_departure_name, spotter_output.departure_airport_city AS airport_departure_city, spotter_output.departure_airport_country AS airport_departure_country, spotter_output.arrival_airport_icao, spotter_output.arrival_airport_name AS airport_arrival_name, spotter_output.arrival_airport_city AS airport_arrival_city, spotter_output.arrival_airport_country AS airport_arrival_country
6698		FROM spotter_output
6699		WHERE spotter_output.ident <> '' AND (spotter_output.departure_airport_icao = :airport_icao OR spotter_output.arrival_airport_icao = :airport_icao)
6700		GROUP BY route
6701		ORDER BY route_count DESC";
6702
6703
6704		$sth = $this->db->prepare($query);
6705		$sth->execute(array(':airport_icao' => $airport_icao));
6706
6707		$routes_array = array();
6708		$temp_array = array();
6709
6710		while($row = $sth->fetch(PDO::FETCH_ASSOC))
6711		{
6712		$temp_array['route_count'] = $row['route_count'];
6713		$temp_array['airport_departure_icao'] = $row['departure_airport_icao'];
6714		$temp_array['airport_departure_name'] = $row['airport_departure_name'];
6715		$temp_array['airport_departure_city'] = $row['airport_departure_city'];
6716		$temp_array['airport_departure_country'] = $row['airport_departure_country'];
6717		$temp_array['airport_arrival_icao'] = $row['arrival_airport_icao'];
6718		$temp_array['airport_arrival_name'] = $row['airport_arrival_name'];
6719		$temp_array['airport_arrival_city'] = $row['airport_arrival_city'];
6720		$temp_array['airport_arrival_country'] = $row['airport_arrival_country'];
6721
6722		$routes_array[] = $temp_array;
6723		}
6724
6725		return $routes_array;
6726		}
6727
6728
6729
		@@ 6736-6769 (lines=34) @@
6733		* @return Array the route list
6734		*
6735		*/
6736		public function countAllRoutesByCountry($country)
6737		{
6738		$country = filter_var($country,FILTER_SANITIZE_STRING);
6739
6740		$query = "SELECT DISTINCT concat(spotter_output.departure_airport_icao, ' - ', spotter_output.arrival_airport_icao) AS route, count(concat(spotter_output.departure_airport_icao, ' - ', spotter_output.arrival_airport_icao)) AS route_count, spotter_output.departure_airport_icao, spotter_output.departure_airport_name AS airport_departure_name, spotter_output.departure_airport_city AS airport_departure_city, spotter_output.departure_airport_country AS airport_departure_country, spotter_output.arrival_airport_icao, spotter_output.arrival_airport_name AS airport_arrival_name, spotter_output.arrival_airport_city AS airport_arrival_city, spotter_output.arrival_airport_country AS airport_arrival_country
6741		FROM spotter_output
6742		WHERE spotter_output.ident <> '' AND ((spotter_output.departure_airport_country = :country) OR (spotter_output.arrival_airport_country = :country)) OR spotter_output.airline_country = :country
6743		GROUP BY route
6744		ORDER BY route_count DESC";
6745
6746
6747		$sth = $this->db->prepare($query);
6748		$sth->execute(array(':country' => $country));
6749
6750		$routes_array = array();
6751		$temp_array = array();
6752
6753		while($row = $sth->fetch(PDO::FETCH_ASSOC))
6754		{
6755		$temp_array['route_count'] = $row['route_count'];
6756		$temp_array['airport_departure_icao'] = $row['departure_airport_icao'];
6757		$temp_array['airport_departure_name'] = $row['airport_departure_name'];
6758		$temp_array['airport_departure_city'] = $row['airport_departure_city'];
6759		$temp_array['airport_departure_country'] = $row['airport_departure_country'];
6760		$temp_array['airport_arrival_icao'] = $row['arrival_airport_icao'];
6761		$temp_array['airport_arrival_name'] = $row['airport_arrival_name'];
6762		$temp_array['airport_arrival_city'] = $row['airport_arrival_city'];
6763		$temp_array['airport_arrival_country'] = $row['airport_arrival_country'];
6764
6765		$routes_array[] = $temp_array;
6766		}
6767
6768		return $routes_array;
6769		}
6770
6771
6772		/**
		@@ 6833-6866 (lines=34) @@
6830		* @return Array the route list
6831		*
6832		*/
6833		public function countAllRoutesByIdent($ident)
6834		{
6835		$ident = filter_var($ident,FILTER_SANITIZE_STRING);
6836
6837		$query = "SELECT DISTINCT concat(spotter_output.departure_airport_icao, ' - ', spotter_output.arrival_airport_icao) AS route, count(concat(spotter_output.departure_airport_icao, ' - ', spotter_output.arrival_airport_icao)) AS route_count, spotter_output.departure_airport_icao, spotter_output.departure_airport_name AS airport_departure_name, spotter_output.departure_airport_city AS airport_departure_city, spotter_output.departure_airport_country AS airport_departure_country, spotter_output.arrival_airport_icao, spotter_output.arrival_airport_name AS airport_arrival_name, spotter_output.arrival_airport_city AS airport_arrival_city, spotter_output.arrival_airport_country AS airport_arrival_country
6838		FROM spotter_output
6839		WHERE spotter_output.ident <> '' AND spotter_output.ident = :ident
6840		GROUP BY route, spotter_output.departure_airport_icao, spotter_output.departure_airport_name, spotter_output.departure_airport_city, spotter_output.departure_airport_country, spotter_output.arrival_airport_icao, spotter_output.arrival_airport_name, spotter_output.arrival_airport_city, spotter_output.arrival_airport_country
6841		ORDER BY route_count DESC";
6842
6843
6844		$sth = $this->db->prepare($query);
6845		$sth->execute(array(':ident' => $ident));
6846
6847		$routes_array = array();
6848		$temp_array = array();
6849
6850		while($row = $sth->fetch(PDO::FETCH_ASSOC))
6851		{
6852		$temp_array['route_count'] = $row['route_count'];
6853		$temp_array['airport_departure_icao'] = $row['departure_airport_icao'];
6854		$temp_array['airport_departure_name'] = $row['airport_departure_name'];
6855		$temp_array['airport_departure_city'] = $row['airport_departure_city'];
6856		$temp_array['airport_departure_country'] = $row['airport_departure_country'];
6857		$temp_array['airport_arrival_icao'] = $row['arrival_airport_icao'];
6858		$temp_array['airport_arrival_name'] = $row['airport_arrival_name'];
6859		$temp_array['airport_arrival_city'] = $row['airport_arrival_city'];
6860		$temp_array['airport_arrival_country'] = $row['airport_arrival_country'];
6861
6862		$routes_array[] = $temp_array;
6863		}
6864
6865		return $routes_array;
6866		}
6867
6868
6869		/**
		@@ 6875-6908 (lines=34) @@
6872		* @return Array the route list
6873		*
6874		*/
6875		public function countAllRoutesByManufacturer($aircraft_manufacturer)
6876		{
6877		$aircraft_manufacturer = filter_var($aircraft_manufactuer,FILTER_SANITIZE_STRING);
6878
6879		$query = "SELECT DISTINCT concat(spotter_output.departure_airport_icao, ' - ', spotter_output.arrival_airport_icao) AS route, count(concat(spotter_output.departure_airport_icao, ' - ', spotter_output.arrival_airport_icao)) AS route_count, spotter_output.departure_airport_icao, spotter_output.departure_airport_name AS airport_departure_name, spotter_output.departure_airport_city AS airport_departure_city, spotter_output.departure_airport_country AS airport_departure_country, spotter_output.arrival_airport_icao, spotter_output.arrival_airport_name AS airport_arrival_name, spotter_output.arrival_airport_city AS airport_arrival_city, spotter_output.arrival_airport_country AS airport_arrival_country
6880		FROM spotter_output
6881		WHERE spotter_output.ident <> '' AND spotter_output.aircraft_manufacturer = :aircraft_manufacturer
6882		GROUP BY route
6883		ORDER BY route_count DESC";
6884
6885
6886		$sth = $this->db->prepare($query);
6887		$sth->execute(array(':aircraft_manufacturer' => $aircraft_manufacturer));
6888
6889		$routes_array = array();
6890		$temp_array = array();
6891
6892		while($row = $sth->fetch(PDO::FETCH_ASSOC))
6893		{
6894		$temp_array['route_count'] = $row['route_count'];
6895		$temp_array['airport_departure_icao'] = $row['departure_airport_icao'];
6896		$temp_array['airport_departure_name'] = $row['airport_departure_name'];
6897		$temp_array['airport_departure_city'] = $row['airport_departure_city'];
6898		$temp_array['airport_departure_country'] = $row['airport_departure_country'];
6899		$temp_array['airport_arrival_icao'] = $row['arrival_airport_icao'];
6900		$temp_array['airport_arrival_name'] = $row['airport_arrival_name'];
6901		$temp_array['airport_arrival_city'] = $row['airport_arrival_city'];
6902		$temp_array['airport_arrival_country'] = $row['airport_arrival_country'];
6903
6904		$routes_array[] = $temp_array;
6905		}
6906
6907		return $routes_array;
6908		}
6909
6910
6911

Ysurac / FlightAirMap

Code Duplication Length = 34-34 lines in 7 locations

require/class.Spotter.php 7 locations